Extrapolating data using excell

Aloreth · 24 Jun 2011 at 14:26

Hi guys,

I am managing a team of people (anywhere from 5 to 25 at a time) over the next year or so and one of the things that I need to do monitor the budget allocated against actual expense and in turn predict approximately at a given point in time what the ultimate results will be.

Is this something that I can do in excell? I like to think that my knowledge of excel is very good generally. If not what sort of software is useful?

Any help much appreciated

Mike

Aloreth · 27 Jun 2011 at 09:22

I'll simplify my question a little:

Can anyone point me towards some decent guides on how to extrapolate data within excel? even just what formlas to use would be great

Aloreth · 27 Jun 2011 at 21:24

Hi guys,

Thanks for the responses, I think perhaps you are underestimating the complexity of the task. The charge out rate for the staff working on the job range from £80 per hour up to £2500 per hour, flexing projected cost depending on hours charged will make a massive difference (from hundreds of thousands of profit to.....well not as much).

Im fairly well versed with all kinds of lookup, sumifs and pivot tables. I guess i hadn't really thought about using them to extrapolate date, will have a crack and come back to you all!

Aloreth · 28 Jun 2011 at 22:53

I heard you like spreadsheets in your spreadsheets....wait i cant really do that joke. Looks nice, think i will try something like that