Write a macro that tries all possible values to find the best possible values for the Produciton assignment that you have just completed. 13 Projected Sales View the projected sales graph image to the right then download the fincalc.exe spreadsheet. Graph, summarize and discuss the data on a single Microsoft Word page. Be sure to predict what you think the next sales value will be. Repeat your recordings on at least three days.
Real Life Be sure to get permissions where appropriate.
You will be expected to anticipate the length of a line that forms and write code that can test your guess. This table was created by a free Excel macro written by Charles Balch . Here's the code .