peteyperson
Joined: 08 May 2008
Posts: 1
|
 Posted: 05/08/08 - 02:14 Post subject: Help needed on Excel spreadsheet design |
 |
|
Hey everyone! Here's what I want to do...
Lets imagine there are three buckets to full with water. One needs 50 litres, one needs 20 litres and one needs 10 litres to fill. I have a number for how much water I have available.
What I want to have is a category from my budget on a single line, with the daily, annual & 25x cost to fund it, and then show what percentage is accomplished. I can do this in a fixed order top-to-bottom but if I want a static list in order (Food, Shelter, Transport, et al.) but want to change th e order the buckets are filled, how can this be accomplished in Excel or other application? I want to either direct the water flowing to certain buckets, then default to top-to-bottom, or specify the order (1-10) down the ten categories.
e.g.,
Funds Available $150,000
Priority | Category | Yearly | X25 | Percent Complete
3# Food & Drink $3,000 $75,000 | 83 %
1# Accommodation $3,000 $75,000 | 100 %
4# Transport $3,000 $75,000 | 0 %
2# Communication $500 $12,500 | 100 %
I think I worked this out once a few year ago, but cannot remember how I did it!
Thanks for any help,
Petey |
|
