| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weighting Costs over time
I am working on a financial analysis and I have a cost in cell that it
divided amongst a group of other cells for time, ie a manufacturing cost of $1,000,000 that is going to occur over 10 months is equally divided into $100,000 amongst those 10 months. However, sometimes the costs are not so linear. I need a formula(s) that will weight the costs towards the front, back or do a bell-curve to reflect more accurate outflows. Any suggestions? Thanks! It is greatly appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time interval data and weighting | Excel Discussion (Misc queries) | |||
| COMPARE CURRENT MORTAGAGE COSTS TO NEW MORTAGAGE COSTS | Excel Discussion (Misc queries) | |||
| COMPARE CURRENT MORTAGAGE COSTS TO NEW MORTAGAGE COSTS | Excel Discussion (Misc queries) | |||
| weighting a value? | Excel Discussion (Misc queries) | |||
| How do I calculate Costs from a Time. ie 16:00 - 12:00 = 4:00hrs x £5.50rate per hour = £22.00 | Excel Worksheet Functions | |||
Threaded Mode
