So, I've got the spreadsheet located here: http://home.armourarchive.org/member...t06052012.xlsx
And this works fine for most sales organizations. We are an equipment rental company, so we might make a "sale" that will last for 6 months i.e. customer rents a bulldozer for 6 months at $10,000/month. Can someone help me modify the spreadsheet above so that I can have weighted revenue report for a duration instead of in just one quarter?
Thanks so much!
Bumpitty Bump bump
it would be easier to access you file if you uploaded it here.
click advanced (next to quick post), scroll down until you see "manage file", click that and select "add files" (top right corner). click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Uploading the file here.
What does 'a duration' mean. If its full year, its simply a sum total for all qaurters. As I see, currently each account name will have forecasted revenue only in one quarter, Based onCan someone help me modify the spreadsheet above so that I can have weighted revenue report for a duration instead of in just one quarter?, you might want to spread this evenly across the the close quarter and the next quarter.so we might make a "sale" that will last for 6 months
Hence in H7
=IF(OR($C7 = "Q2",$C7="Q1"),$F7/2,0)
Does this work for you?
Life's a spreadsheet, Excel!
Say thanks, Click *
Our duration will vary based on the opportunity. So, being able to input a value for duration and then a value for amount might work? For example an opportunity might be $120,000 over a 6 month period begining in September, show the revenue as $20,000 in each month from September to February.Originally Posted by Ace_XL
I did not build the spreadsheet attached, it is a template from MS online. I am truly awful at complex excel work. The "quarters" in the attached sheet are not important per se either, having a "rolling 12 month" spreadsheet would be great. If I can get someone to iron this out I'll gladly payapl you a reasonable amount of money.
Tony..to get you started, I have changed the quarters to calendar months and added a period column that will determine the number of months over whihc the revenue will be earned.
Is this something you can work off?
Perfect Ace_xl!
Thanks so much! Inbox me your email and I'll send you a paypal thanks!
Cheers Tony! Enjoy the forum
Please mark the thread solved too.
To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks