Points formula

Has anyone figured out the mathematic formula (fiber -- cal -- fat =
points) to the point calculator? I would like to use it in a spreadsheet


Thad

(Calories + (Fat x 4) - (Fiber x 10))/50 = points

On Thu, 06 Nov 2003 22:38:07 GMT, "Thad Clark-Soles"
wrote:

Has anyone figured out the mathematic formula (fiber -- cal -- fat =
points) to the point calculator? I would like to use it in a spreadsheet


Thad

is that the same for the UK?

--
krys

UK 157/136.4/126
Started March 1st 2001
GOAL August 16th 2001
struggling now.......

"Stan" wrote in message
...
(Calories + (Fat x 4) - (Fiber x 10))/50 = points

On Thu, 06 Nov 2003 22:38:07 GMT, "Thad Clark-Soles"
wrote:

Has anyone figured out the mathematic formula (fiber -- cal -- fat =
points) to the point calculator? I would like to use it in a spreadsheet


Thad

And don't for get to cap the number of fiber grams to 4.
--
Laura

"Stan" wrote in message
...
(Calories + (Fat x 4) - (Fiber x 10))/50 = points

On Thu, 06 Nov 2003 22:38:07 GMT, "Thad Clark-Soles"
wrote:

Has anyone figured out the mathematic formula (fiber -- cal -- fat
=
points) to the point calculator? I would like to use it in a
spreadsheet


Thad

I think the UK does not count fiber, IIRC. Otherwise I think the formula
is the same.

"krys" wrote in message
...
is that the same for the UK?

--
krys

UK 157/136.4/126
Started March 1st 2001
GOAL August 16th 2001
struggling now.......

"Stan" wrote in message
...
(Calories + (Fat x 4) - (Fiber x 10))/50 = points

On Thu, 06 Nov 2003 22:38:07 GMT, "Thad Clark-Soles"
wrote:

Has anyone figured out the mathematic formula (fiber -- cal --
fat =
points) to the point calculator? I would like to use it in a
spreadsheet


Thad

thanks

"Stan" wrote in message
...
(Calories + (Fat x 4) - (Fiber x 10))/50 = points

On Thu, 06 Nov 2003 22:38:07 GMT, "Thad Clark-Soles"
wrote:

Has anyone figured out the mathematic formula (fiber -- cal -- fat =
points) to the point calculator? I would like to use it in a spreadsheet


Thad

This is the Lotus 123 (some of us are ol' school and this is on my
HP200 palmtop which has 123 builtin) and hoping I copied all the
parenthesises correctly

(c3+(4*c4)-(10*(@IF(c54,4,c5))))/50

where c3 is calories
c4 is fatgrams
c5 is fiber

And as said, this is the US formula and this caps fiber at 4.

On Thu, 06 Nov 2003 22:38:07 GMT, "Thad Clark-Soles"
wrote:

Has anyone figured out the mathematic formula (fiber -- cal -- fat =
points) to the point calculator? I would like to use it in a spreadsheet


Thad

*smacking my forehead*

Oh, yeah, I forgot to mention that. I don't use it in my spreadsheet
because I'm usually calculating the points in a recipe, not in a
single serving. If the recipe serves 4, then the cap would be at 16
grams, for example.

Just too complicated to bother with in that application, and only
really applies to very high fiber foods.

Thanks for the reminder, though. I hate giving out bad information!

Stan



On Fri, 07 Nov 2003 13:18:41 GMT, "Laura"
wrote:

And don't for get to cap the number of fiber grams to 4.

Actually it's:
POINTS(R) = (calories/50) + (fat grams/12) - (fiber grams/5)

And the patent is public information he

http://164.195.100.11/netacgi/nph-Parser?Sect1=PTO1&Sect2=HITOFF&d=PALL&p=1&u=/netahtml/srchnum.htm&r=1&f=G&l=50&s1='6040531'.WKU.&OS=PN/6040531&RS=PN/6040531

--
SuzyQ
Weight 124
WW Lifetime Membership Feb 03


"Thad Clark-Soles" wrote in message
news:j3Aqb.133596$e01.445129@attbi_s02...
Has anyone figured out the mathematic formula (fiber -- cal -- fat =
points) to the point calculator? I would like to use it in a spreadsheet


Thad

The UK also only counts saturated fat, rather than total fat. I don't think
the formula can be translated unfortunately.

--
Julie.
93.5/73.5/74 (WW)/72 (Personal) kg
205.7/161.7/162.8 (WW)/158 (Personal) lb

"Laura" wrote in message
...
I think the UK does not count fiber, IIRC. Otherwise I think the formula
is the same.

"krys" wrote in message
...
is that the same for the UK?

--
krys

UK 157/136.4/126
Started March 1st 2001
GOAL August 16th 2001
struggling now.......

"Stan" wrote in message
...
(Calories + (Fat x 4) - (Fiber x 10))/50 = points

On Thu, 06 Nov 2003 22:38:07 GMT, "Thad Clark-Soles"
wrote:

Has anyone figured out the mathematic formula (fiber -- cal --
fat =
points) to the point calculator? I would like to use it in a
spreadsheet


Thad