Prev: Is there a way to type in text and not have it print?
Next: Formatting making file size huge
From: Thomas on 13 Jan 2010 09:38
I have been trying to understand this principle but need you to clarify your instructions.

Example:

C1 2010 (Year) To Avg. 35 (Title)

C2 36 Formula (Need 34)
C3 32 Formula (Need 37)
C4 34 Formula (Need 38)


The formula needs to adjust calculating all the weeks prior to it to be able to avg. 35 for the year

Thank-you










walrus wrote:

Heya Thomaswhat you need is Goal Seek but you will have to do it weekly.
13-Jan-10

Heya Thomas

what you need is Goal Seek but you will have to do it weekly. in the table
below go to cell F2 (average formula) and in the DATA Menu > What-if analysis
cick OK. you will see in cell C4 that you need 37 more to make your average
35. just paste this value in cell D4 and when you know the actual attendence
just overwrite the 37 in cell C4 this way you also check your progress viz
required and actual.

A B C D E F
1 Attnd Attnd Req Avg
Avg Req
2 Week1 36 35 =AVERAGE($C$2:$C$53) =AVERAGE($C$2:$C$53)
3 Week2 32 34 =AVERAGE($C$2:$C$53)
4 Week3 37 =AVERAGE($C$2:$C$53)



"Thomas Almanza" wrote:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET Session Variables - Hijack
http://www.eggheadcafe.com/tutorials/aspnet/93b132b0-4d8e-4fb1-bfb1-c5283d523c8c/aspnet-session-variables.aspx
 | 
Pages: 1
Prev: Is there a way to type in text and not have it print?
Next: Formatting making file size huge