i need to increase or decrease a cell. A1 is the consent value or base. B1 is
the goal which is a smaller value and d1 is the actual value. When d1 is
changed by either a smaller or larger value then i need e1 to increase or
decrease.
base goal savings actual diff gain/loss
A1 b1 c1 d1 e1 f1
100 95 5 95 5 100
fixed =a1-b1 moving =d1/a1 =e1/c1
if i change actual/d1 to say 98 i need the diff/e1 to increase or if i
change it to say 93 i need it to decrease. help!!

gma,

interpreting A1 as the index for your target f1, try with the following +/-
formula as fallows;

d1 = "input as-actual value"

Assumed as a respective input,
"When d1 is changed by either a smaller or larger value then i need e1 to
increase or decrease".
thus,
e1= (b1-d1)+c1
and where c1 is the goal for savings
f1=e1/c1 *100

so if actual/d1 = 98 ; then diff/e1 = 2 and gain/loss = 40.


--
regards,
driller

"gma" wrote:

i need to increase or decrease a cell. A1 is the consent value or base. B1 is
the goal which is a smaller value and d1 is the actual value. When d1 is
changed by either a smaller or larger value then i need e1 to increase or
decrease.
base goal savings actual diff gain/loss
A1 b1 c1 d1 e1 f1
100 95 5 95 5 100
fixed =a1-b1 moving =d1/a1 =e1/c1
if i change actual/d1 to say 98 i need the diff/e1 to increase or if i
change it to say 93 i need it to decrease. help!!

yet on the other hand as mentioned below,

if i change actual/d1 to say 98 i need the diff/e1 to increase or if i
change it to say 93 i need it to decrease.

so maybe,
E1= (D1-B1)+c1
F1=E1/C1*100
so
if *D1=98* thus *E1=8* and *F1=160*.


"driller" wrote:

gma,

interpreting A1 as the index for your target f1, try with the following +/-
formula as fallows;

d1 = "input as-actual value"

Assumed as a respective input,
"When d1 is changed by either a smaller or larger value then i need e1 to
increase or decrease".
thus,
e1= (b1-d1)+c1
and where c1 is the goal for savings
f1=e1/c1 *100

so if actual/d1 = 98 ; then diff/e1 = 2 and gain/loss = 40.


--
regards,
driller

"gma" wrote:

i need to increase or decrease a cell. A1 is the consent value or base. B1 is
the goal which is a smaller value and d1 is the actual value. When d1 is
changed by either a smaller or larger value then i need e1 to increase or
decrease.
base goal savings actual diff gain/loss
A1 b1 c1 d1 e1 f1
100 95 5 95 5 100
fixed =a1-b1 moving =d1/a1 =e1/c1
if i change actual/d1 to say 98 i need the diff/e1 to increase or if i
change it to say 93 i need it to decrease. help!!

Hi driller
i'm not explaining myself very well.
B5 C5 D5 E5 F5 G5
H5
Budget %savings Goal Target Actual Budget/Act Gain or -Loss
100 5.00% 95 5 95 5 100%
the way this works is: there is a budget number,B5 100, thats fixed or a
number we have set as the yearly budget ,and a goal
number,D5=abs((b5*c5)-b5), thats driven from the "% savings" C5 5%. the %
savings number is also fixed that we have set as a target savings of the
budget or in other words, we have a budget number but i'm asking that we also
try and beat the budget number by 5%, thus the target E5 =B5-D5 becomes the
number 5. the actual number is from the average of the quarter say 95. as the
actual number goes up i need G5 to increase or if the actual number decreases
i need G5 to decrease. Again not sure if i'm explaining myself very well.





"driller" wrote:

gma,

interpreting A1 as the index for your target f1, try with the following +/-
formula as fallows;

d1 = "input as-actual value"

Assumed as a respective input,
"When d1 is changed by either a smaller or larger value then i need e1 to
increase or decrease".
thus,
e1= (b1-d1)+c1
and where c1 is the goal for savings
f1=e1/c1 *100

so if actual/d1 = 98 ; then diff/e1 = 2 and gain/loss = 40.


--
regards,
driller

"gma" wrote:

i need to increase or decrease a cell. A1 is the consent value or base. B1 is
the goal which is a smaller value and d1 is the actual value. When d1 is
changed by either a smaller or larger value then i need e1 to increase or
decrease.
base goal savings actual diff gain/loss
A1 b1 c1 d1 e1 f1
100 95 5 95 5 100
fixed =a1-b1 moving =d1/a1 =e1/c1
if i change actual/d1 to say 98 i need the diff/e1 to increase or if i
change it to say 93 i need it to decrease. help!!

Hi gma,

pls fill values on "?" as sample explanation for a quicker approach.

B5 C5 D5 E5 F5 G5
H5
Budget %savings Goal Target Actual Budget/Act Gain or -Loss
100 5.00% 95 5 95 5 100%
100 5.00% 95 5 98 ? ?%
100 5.00% 95 5 93 ? ?%
100 5.00% 95 5 105 ? ?%

regards

"gma" wrote:

Hi driller
i'm not explaining myself very well.
B5 C5 D5 E5 F5 G5
H5
Budget %savings Goal Target Actual Budget/Act Gain or -Loss
100 5.00% 95 5 95 5 100%
the way this works is: there is a budget number,B5 100, thats fixed or a
number we have set as the yearly budget ,and a goal
number,D5=abs((b5*c5)-b5), thats driven from the "% savings" C5 5%. the %
savings number is also fixed that we have set as a target savings of the
budget or in other words, we have a budget number but i'm asking that we also
try and beat the budget number by 5%, thus the target E5 =B5-D5 becomes the
number 5. the actual number is from the average of the quarter say 95. as the
actual number goes up i need G5 to increase or if the actual number decreases
i need G5 to decrease. Again not sure if i'm explaining myself very well.





"driller" wrote:

gma,

interpreting A1 as the index for your target f1, try with the following +/-
formula as fallows;

d1 = "input as-actual value"

Assumed as a respective input,
"When d1 is changed by either a smaller or larger value then i need e1 to
increase or decrease".
thus,
e1= (b1-d1)+c1
and where c1 is the goal for savings
f1=e1/c1 *100

so if actual/d1 = 98 ; then diff/e1 = 2 and gain/loss = 40.


--
regards,
driller

"gma" wrote:

i need to increase or decrease a cell. A1 is the consent value or base. B1 is
the goal which is a smaller value and d1 is the actual value. When d1 is
changed by either a smaller or larger value then i need e1 to increase or
decrease.
base goal savings actual diff gain/loss
A1 b1 c1 d1 e1 f1
100 95 5 95 5 100
fixed =a1-b1 moving =d1/a1 =e1/c1
if i change actual/d1 to say 98 i need the diff/e1 to increase or if i
change it to say 93 i need it to decrease. help!!

driller
as you can see any thing less than "95", decreases the "budget/act" and the
"gain/loss", but or the other hand any thing more than "95" will increase
those same numbers. i know i'm not explaining myself very well but this
spreadsheet is hard to explain. its a bonus plan for my managers. i wish i
could just email you a copy of the forumlas and you could see better what i'm
trying to do, or maybe what your asking below will help. hope this helps

"driller" wrote:

Hi gma,

pls fill values on "?" as sample explanation for a quicker approach.

B5 C5 D5 E5 F5 G5
H5
Budget %savings Goal Target Actual Budget/Act Gain or -Loss
100 5.00% 95 5 95 5 100%
100 5.00% 95 5 98 6 120%
100 5.00% 95 5 93 4 80%
100 5.00% 95 5 105 7 140%

regards

"gma" wrote:

Hi driller
i'm not explaining myself very well.
B5 C5 D5 E5 F5 G5
H5
Budget %savings Goal Target Actual Budget/Act Gain or -Loss
100 5.00% 95 5 95 5 100%
the way this works is: there is a budget number,B5 100, thats fixed or a
number we have set as the yearly budget ,and a goal
number,D5=abs((b5*c5)-b5), thats driven from the "% savings" C5 5%. the %
savings number is also fixed that we have set as a target savings of the
budget or in other words, we have a budget number but i'm asking that we also
try and beat the budget number by 5%, thus the target E5 =B5-D5 becomes the
number 5. the actual number is from the average of the quarter say 95. as the
actual number goes up i need G5 to increase or if the actual number decreases
i need G5 to decrease. Again not sure if i'm explaining myself very well.





"driller" wrote:

gma,

interpreting A1 as the index for your target f1, try with the following +/-
formula as fallows;

d1 = "input as-actual value"

Assumed as a respective input,
"When d1 is changed by either a smaller or larger value then i need e1 to
increase or decrease".
thus,
e1= (b1-d1)+c1
and where c1 is the goal for savings
f1=e1/c1 *100

so if actual/d1 = 98 ; then diff/e1 = 2 and gain/loss = 40.


--
regards,
driller

"gma" wrote:

i need to increase or decrease a cell. A1 is the consent value or base. B1 is
the goal which is a smaller value and d1 is the actual value. When d1 is
changed by either a smaller or larger value then i need e1 to increase or
decrease.
base goal savings actual diff gain/loss
A1 b1 c1 d1 e1 f1
100 95 5 95 5 100
fixed =a1-b1 moving =d1/a1 =e1/c1
if i change actual/d1 to say 98 i need the diff/e1 to increase or if i
change it to say 93 i need it to decrease. help!!

gma....sorry for not understanding your point very well, your bonuses plan
have in H5 "gain or-Loss" column, does the "-Loss" means a negative % ? How
to know its a -Loss ?

For G5 : is there a proportionating formula or this is a "series of count
+/-" from *5* ?

lastly please fill in your value at the extended last 2 rows in the table
with "?" below

B5 C5 D5 E5 F5 G5 H5
Budget %savings Goal Target Actual Budget/Act Gain or -Loss
100 5.00% 95 5 95 *5* 100%
100 5.00% 95 5 98 6 120%
100 5.00% 95 5 93 4 80%
100 5.00% 95 5 105 7 140%
100 5.00% 95 5 103 "?" "?"
100 5.00% 95 5 94 "?" "?"

regards


"gma" wrote:

driller
as you can see any thing less than "95", decreases the "budget/act" and the
"gain/loss", but or the other hand any thing more than "95" will increase
those same numbers. i know i'm not explaining myself very well but this
spreadsheet is hard to explain. its a bonus plan for my managers. i wish i
could just email you a copy of the forumlas and you could see better what i'm
trying to do, or maybe what your asking below will help. hope this helps

"driller" wrote:

Hi gma,

pls fill values on "?" as sample explanation for a quicker approach.

B5 C5 D5 E5 F5 G5
H5
Budget %savings Goal Target Actual Budget/Act Gain or -Loss
100 5.00% 95 5 95 5 100%
100 5.00% 95 5 98 6 120%
100 5.00% 95 5 93 4 80%
100 5.00% 95 5 105 7 140%

regards

"gma" wrote:

Hi driller
i'm not explaining myself very well.
B5 C5 D5 E5 F5 G5
H5
Budget %savings Goal Target Actual Budget/Act Gain or -Loss
100 5.00% 95 5 95 5 100%
the way this works is: there is a budget number,B5 100, thats fixed or a
number we have set as the yearly budget ,and a goal
number,D5=abs((b5*c5)-b5), thats driven from the "% savings" C5 5%. the %
savings number is also fixed that we have set as a target savings of the
budget or in other words, we have a budget number but i'm asking that we also
try and beat the budget number by 5%, thus the target E5 =B5-D5 becomes the
number 5. the actual number is from the average of the quarter say 95. as the
actual number goes up i need G5 to increase or if the actual number decreases
i need G5 to decrease. Again not sure if i'm explaining myself very well.





"driller" wrote:

gma,

interpreting A1 as the index for your target f1, try with the following +/-
formula as fallows;

d1 = "input as-actual value"

Assumed as a respective input,
"When d1 is changed by either a smaller or larger value then i need e1 to
increase or decrease".
thus,
e1= (b1-d1)+c1
and where c1 is the goal for savings
f1=e1/c1 *100

so if actual/d1 = 98 ; then diff/e1 = 2 and gain/loss = 40.


--
regards,
driller

"gma" wrote:

i need to increase or decrease a cell. A1 is the consent value or base. B1 is
the goal which is a smaller value and d1 is the actual value. When d1 is
changed by either a smaller or larger value then i need e1 to increase or
decrease.
base goal savings actual diff gain/loss
A1 b1 c1 d1 e1 f1
100 95 5 95 5 100
fixed =a1-b1 moving =d1/a1 =e1/c1
if i change actual/d1 to say 98 i need the diff/e1 to increase or if i
change it to say 93 i need it to decrease. help!!

On Feb 24, 6:51*am, gma wrote:
i'm not explaining myself very well.

And you're not explaining yourself very well over and over in multiple
threads.

Why don't you stick with one thread?

As people who try to help you ask questions, your explanation will be
refined.*