# inflation

1. ### How to pull a sheet name from a cell and use to calculate just one sheet in vba

Hi All, I have a large workbook that has a sheet which calculates results with and without inflation. I have code that changes inflation to 0 and then back to what it was originally. Before I copy the original assumptions back I need to calculate just one sheet that is selected in a drop-down...
2. ### Update prices automatically on a specific date

Just wondering if its possible to update prices by inflation on specific dates. As an example, i'd like a loaf of bread at \$1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. I...
3. ### Auto update cell price for inflation

Just wondering if its possible to update prices by inflation on specific dates. As an example, i'd like a loaf of bread at \$1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. I...
4. ### Auto update cell price for inflation

Just wondering if its possible to update numbers by inflation on specific dates. As an example, i'd like a loaf of bread at \$1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually...
5. ### Update prices automatically on a specific date

Just wondering if its possible to update numbers by inflation on specific dates. As an example, i'd like a loaf of bread at \$1 to automatically adust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. Thanks
6. ### Inflation formula with varying rates per year!

Hello, I am looking for a formula that properly pulls a Baseline Expense depending on location (this part is done) and then multiplies it by looking up the inflation rate for a given year. Second half of the formula is below. Inflation portion...
7. ### Conditional format last row of positive value in table

Hello, I have a table with 40 rows and depending on input the values change from positive to negative. So with an inflation rate of 2.5% then row 23 will be the first row in negative numbers, if I change inflation rate to 1% then row 28 will be the first row in negative. How do I conditionally...
8. ### Defined Range Name Recalc using drop down list

I have a "Pivot Table" with 6 columns A thru F. header = Fiscal Years. There is a row A thru F for total costs in each Fiscal Year. I have defined that range/row as Total Costs. I want to take each Total Costs and bump it up by an inflation rate without have to go in each cell and add the...
9. ### Measure can't decide if it's a date??

I've got a date measure that works with some operators but not others. Perhaps someone can tell me what I'm doing wrong in formatting? I get an error that the date measure is a text measure and DAX cannot compare text and dates, but only for certain operations. I've got an inflation formula...
10. ### Best way to create and use constants in Power Pivot?

For my model I have constants to be applied such as projected inflation rate, depreciation years, and other values to be set by users as what-if options. There are too many variations the users want to create disconnected tables - e.g. listing every inflation rate by hundredths of a percent -...
11. ### forecast monthly change of inflation rate

Hi :) I am working on a project to forecast monthly change of inflation rate. I used SLR but the forecast doesnt seem to be correct. Could someone take a look please? :confused: I am also not sure how to diagnose time series (stationarity, trend, ARMA..) in Excel( is this even possible?) I...
12. ### Cumulative Inflation Impact on Unit Price

I'm looking for a formula that gives me an average unit price value that considers annual inflation. For example: Inflation is 2% Year 1, Unit Price is 100.00 Year 2, Unit Price is 102.00 { =100*1.02 } for an average unit price of 101 { =(100+(100*1.02))/2 }. Year 3, Unit Price is 104.04 {...
13. ### Adjusting for inflation on Excel

So I have an excel problem (first time user) and I have to adjust for inflation for a fortnightly payment. So the payment comes in every fortnight and its \$900. Inflation is estimated approx. 4% and its to occur on a yearly basis on and after 1/07/2014 (so the next one would be 1/07/2015 and...
14. ### Compound interest taking inflation into account

I am interested to know whether there is a compound interest formula which takes inflation into account. I am familiar with the compound interest formula. The type of calculation I'm looking to do is Monthly investment of: \$250 Annual interest rate: 4% Annual inflation rate: 3% Period of...