questions regarding eXcel

[primateperson]

So we want to create a spreadsheet that has a running calendar and the ability to take a variable sum of several fields and divide that sum by a constant "x".

Who can spell that out for me?

Oh, by the way, I am familiar with the program, I just don't understand all the nuances....

Comments

[sassylidge]

in the cell where you want the variable to be put =SUM(range of cells for sum)/x

For example
=SUM(A6:A8)/3

[primateperson]

Yeah, That's Exactly what I was looking for!

Do you know how to do a cumulative/running/averaging calendar? Or is that SOOOooo technical that you don't want to get into it?

[sassylidge]

I'm not really sure what you are asking for, but click Insert > Function and that gives you a dialogue box that lists all the functions.

[primateperson]

We want the spreadsheet to take the average of each pizza size over a span of weeks, months, years; and separate out individual days.

The fields would be titled by weekday and date. A1 would be Monday 3/12/07 and the list would cascade down with the size of pizza dough sold per day. We want to average each size per day so we can get a quick glance at build/to, on average, per day and ultimately per range of days.

My thought is, there must be a function that can build a calendar, or maybe field A2 had a function that added a day (the smart way, in calendar fashion) then we could insert the data into the calendar and it would average the Friday (or range of days) family size crusts we served over the span of four months (eventually).

You see right now, we are doing counts everyday and then creating prep lists. It occurred to Glen that if we had this spreadsheet, then we could adjust our prep more simply. For everything!!!!

I got him started when he brought it up, then I got stuck....