spending

  1. R

    How to track when project spending has slowed for 2 months in a row?

    Hello, I'm wanting to create an indicator that shows me when a project has overspent for multiple months or under spent by multiple months. I want to do this for over 50 projects. I have monthly spending by project. I'm considering using outlier formulas to show me when spending is abnormal...
  2. L

    Percentage questions

    Hello everyone I have a problem: I have to calculate how much each car contributes as a percentage to give me a total spending balance in $, in a given rental period calculated as a percentage. For example: Car 1: spending balance 1000 $, on 75% of the time of which it was rented; Car 2...
  3. M

    Powerpivot calculation based on fields in pivot

    Hello, I was wondering if it is possible to have a column in calculate based on the fields that are included. For example, if only market is available, I want the % of per capita spending to be divided by the total across all markets, but if I include market and product, have the % spending to...
  4. P

    Consolidation to track data over time

    I have monthly reports for projects that tell me how much has been spent on a project to the end of the month. I have 12 tables, one for each month with a list of projects and an amount. Each month as projects start and finish the list of projects will change and they may not be in the same...
  5. P

    Make value negative based off of another cell's value

    Hello all, This is my first post on this site but with the personal project I am doing it will probably not be the last. Background on project: Trying to create a personal finance tracker that will work across multiple devices (i.e home computer, wife and I's cellphones, etc.) and is very...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top