Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spreadsheet functions
I am creating a New product development business analysis spread sheet. I
would like to know how I can automatically generate 3 5 or 10 years column for the analysis. Also whenever I enter a sales revenue for year one I would like year 2 to be a specified percentage increase of year 1 sales and the same percentage increase over year 2 sales. Its like a constant 10% increase. The same would be for the variable and fixed cost. I cannot come up with the formula to do these automatically. Any help would be highly appreciated Derrick |
#2
|
|||
|
|||
Try:
Not sure what you mean by "automatically generate 3 5 or 10 years column". To create an annual increase, multiply the value by 1.10. 10*1.10=11 -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "Derrick Robinson" wrote in message news:Todve.472$GP6.225@trndny03... I am creating a New product development business analysis spread sheet. I would like to know how I can automatically generate 3 5 or 10 years column for the analysis. Also whenever I enter a sales revenue for year one I would like year 2 to be a specified percentage increase of year 1 sales and the same percentage increase over year 2 sales. Its like a constant 10% increase. The same would be for the variable and fixed cost. I cannot come up with the formula to do these automatically. Any help would be highly appreciated Derrick |
#3
|
|||
|
|||
I have seen spreadsheets asking you to specify number of year analysis you
want to generate. You put 5 or 3 and it generates a 5 -year or 3- year column spreadsheet. The formula was not visible so I could see how it was done. "Damon Longworth" wrote in message ... Try: Not sure what you mean by "automatically generate 3 5 or 10 years column". To create an annual increase, multiply the value by 1.10. 10*1.10=11 -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "Derrick Robinson" wrote in message news:Todve.472$GP6.225@trndny03... I am creating a New product development business analysis spread sheet. I would like to know how I can automatically generate 3 5 or 10 years column for the analysis. Also whenever I enter a sales revenue for year one I would like year 2 to be a specified percentage increase of year 1 sales and the same percentage increase over year 2 sales. Its like a constant 10% increase. The same would be for the variable and fixed cost. I cannot come up with the formula to do these automatically. Any help would be highly appreciated Derrick |
#4
|
|||
|
|||
It is hard to advise, because your application will be specific. You could
add a message box asking the user the number of years. Your code would take this number and generate the appropriate columns formatted with the required data. You should be able to record most of the required steps. Have a look at MsgBox in help. Post back if you get stuck. -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "Derrick Robinson" wrote in message news:t1eve.98$bz6.96@trndny06... I have seen spreadsheets asking you to specify number of year analysis you want to generate. You put 5 or 3 and it generates a 5 -year or 3- year column spreadsheet. The formula was not visible so I could see how it was done. "Damon Longworth" wrote in message ... Try: Not sure what you mean by "automatically generate 3 5 or 10 years column". To create an annual increase, multiply the value by 1.10. 10*1.10=11 -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "Derrick Robinson" wrote in message news:Todve.472$GP6.225@trndny03... I am creating a New product development business analysis spread sheet. I would like to know how I can automatically generate 3 5 or 10 years column for the analysis. Also whenever I enter a sales revenue for year one I would like year 2 to be a specified percentage increase of year 1 sales and the same percentage increase over year 2 sales. Its like a constant 10% increase. The same would be for the variable and fixed cost. I cannot come up with the formula to do these automatically. Any help would be highly appreciated Derrick |
#5
|
|||
|
|||
Thanks I will give it a try.
Derrick "Damon Longworth" wrote in message ... It is hard to advise, because your application will be specific. You could add a message box asking the user the number of years. Your code would take this number and generate the appropriate columns formatted with the required data. You should be able to record most of the required steps. Have a look at MsgBox in help. Post back if you get stuck. -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "Derrick Robinson" wrote in message news:t1eve.98$bz6.96@trndny06... I have seen spreadsheets asking you to specify number of year analysis you want to generate. You put 5 or 3 and it generates a 5 -year or 3- year column spreadsheet. The formula was not visible so I could see how it was done. "Damon Longworth" wrote in message ... Try: Not sure what you mean by "automatically generate 3 5 or 10 years column". To create an annual increase, multiply the value by 1.10. 10*1.10=11 -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "Derrick Robinson" wrote in message news:Todve.472$GP6.225@trndny03... I am creating a New product development business analysis spread sheet. I would like to know how I can automatically generate 3 5 or 10 years column for the analysis. Also whenever I enter a sales revenue for year one I would like year 2 to be a specified percentage increase of year 1 sales and the same percentage increase over year 2 sales. Its like a constant 10% increase. The same would be for the variable and fixed cost. I cannot come up with the formula to do these automatically. Any help would be highly appreciated Derrick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet Dilemma | Excel Discussion (Misc queries) | |||
Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
Some exported records do not show on spreadsheet | Excel Worksheet Functions | |||
Applying Existing Password to New Spreadsheet | Excel Discussion (Misc queries) | |||
# of Functions per cell | Excel Worksheet Functions |