J
joseph.mccastlain
Hi all, here is what I am trying to do with the data below: I would
like to take the revenue received from the closed contract and spread
it out over the length of the contract, dividing it up by the fiscal
quarters. I have tried numerous ways to do this but cannot seem to
find the right array. I can do this with if/then statements but they
of course cannot search a range. Any help would be greatly
appreaciated!
I can email an excel document if it makes it easier...
Client Name Revenue from contract Quarter Contract date Length in
months Rev per quarter
Client 1 22,000,000 Q407 39172 12 5500000
Client 1 44,000,000 Q108 39173 36 3666666.667
Client 1 11,000,000 Q407 39142 24 1375000
Client 2 100,000,000 Q208 39326 60 5000000
Client 2 200,000,000 Q108 39203 60 10000000
Client 2 300,000,000 Q407 39139 60 15000000
Client 3 1,000,000 Q208 39270 12 250000
Client 3 2,000,000 Q308 39356 6 1000000
Client 3 3,000,000 Q408 39478 24 375000
Client 1
Terms Q3FY07 Q4FY07 Q1FY08 Q2FY08 Q3FY08 Q4FY08
12
24
36
48
60
72
like to take the revenue received from the closed contract and spread
it out over the length of the contract, dividing it up by the fiscal
quarters. I have tried numerous ways to do this but cannot seem to
find the right array. I can do this with if/then statements but they
of course cannot search a range. Any help would be greatly
appreaciated!
I can email an excel document if it makes it easier...
Client Name Revenue from contract Quarter Contract date Length in
months Rev per quarter
Client 1 22,000,000 Q407 39172 12 5500000
Client 1 44,000,000 Q108 39173 36 3666666.667
Client 1 11,000,000 Q407 39142 24 1375000
Client 2 100,000,000 Q208 39326 60 5000000
Client 2 200,000,000 Q108 39203 60 10000000
Client 2 300,000,000 Q407 39139 60 15000000
Client 3 1,000,000 Q208 39270 12 250000
Client 3 2,000,000 Q308 39356 6 1000000
Client 3 3,000,000 Q408 39478 24 375000
Client 1
Terms Q3FY07 Q4FY07 Q1FY08 Q2FY08 Q3FY08 Q4FY08
12
24
36
48
60
72