Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET
Use the large white space in the body to describe what you want done.
Gord Dibben MS Excel MVP On Sat, 30 Aug 2008 12:31:00 -0700, mike64149 wrote: |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET
I am making a monthly budget, tracking it daily, used my formulas to move
data to different spred sheet. Data changes daily, always spend more. I would like to keep yesterdays #s while using the addional amount added for todays #s. I am tracking 5 different catagories and expenditures for each. Set up the daily/monthly template but I know the data will update across the spredsheet and not stay for the day assigned. "Gord Dibben" wrote: Use the large white space in the body to describe what you want done. Gord Dibben MS Excel MVP On Sat, 30 Aug 2008 12:31:00 -0700, mike64149 wrote: |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET
You want a pivot table.
Enter all your data in one sheet. Then use a pivot table to calculate the summaries you want (ie, sum of each category each day). Debra Dalgliesh has the most comprehensive information on Pivot Tables. Start he http://www.contextures.com/xlPivot02.html You won't ever be sorry you learned pivot tables. Regards, Fred. "mike64149" wrote in message ... I am making a monthly budget, tracking it daily, used my formulas to move data to different spred sheet. Data changes daily, always spend more. I would like to keep yesterdays #s while using the addional amount added for todays #s. I am tracking 5 different catagories and expenditures for each. Set up the daily/monthly template but I know the data will update across the spredsheet and not stay for the day assigned. "Gord Dibben" wrote: Use the large white space in the body to describe what you want done. Gord Dibben MS Excel MVP On Sat, 30 Aug 2008 12:31:00 -0700, mike64149 wrote: |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET
I have a list of monthly budget amount, fund amont as on a day and some
incomining funds . Question1. What is the formula for calculating the elapsed number of days to return in c1 for a budget value of a month which is in a cell a1 and a given date in b1 and available fund in d1. In an instance, for Sept 2008 and Oct 2008 the Budget reserved as 2900 and 3500. If available fund is 1200 on 27 sept 2008 the fund will last 4 days (as per day Avg. for sept is 96.67) + 7.2 days in Oct (at Oct Avg of 112.90) I need to return Answer as 11.2 days Question2. What is the formula for calculating the spread number of days for an available fund in d2 to return in c2 for its next following month budget which is in a cell a2 where the day calculation to be continued from the c1. The Budget amount for October 2008 will be 3500, the Available fund 6000. The same like above the formula required is the total no of days but continued from the above resulted day (which ends on 8th Oct 2008). "Gord Dibben" wrote: Use the large white space in the body to describe what you want done. Gord Dibben MS Excel MVP On Sat, 30 Aug 2008 12:31:00 -0700, mike64149 wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PMT: Daily interest compounding; monthly payment | Excel Worksheet Functions | |||
Linking Daily Worksheet To Daily Invoice Total | Excel Worksheet Functions | |||
Collecting weekly and monthly totals from daily data | Excel Worksheet Functions | |||
Daily,monthly total | Excel Discussion (Misc queries) | |||
summing up daily data in a monthly compilation | Excel Worksheet Functions |