capex

Hi guys, We are talking about buildings, which is irrelevant, but it may be relevant only for your understanding of the issue. I have an issue with this formula. I need a formula that is able to sum the values based on particular conditions: 1) Based on the central cost 2) Based on CAPEX...

I currently have a spreadsheet which tells me how many months build period we have, buy calculating how much capex we have, and over what time. Issue I have is, if people spend X amount one month, and then X amount in 4 months time, my report will pull me off 2 months, whereas it should be 5...

Hi all, I'm attempting to consolidate a big block of data with two columns and a reference to a month into a summary table and I can't seem to get there. Essentially I want to sum for example, all the items in the reference table that are CAPEX and Labour for the Month of September into the...

OK so I have: * column A which defines unit type * column B which defines 2 criteria (OPEX or CAPEX) * column C and onwards represents each calendar month and each line defines the amount of money that was spent I want to be able to record the total amount for each type of spend each month...

Using PowerPivot I am struggling to create a measure to do the following: I have a bunch of projects that people book time to. Hours are booked to either capex or opex tasks. I can create measures to compare time booked to capex or opex. What I would like to do is: Filter out all the...