V22.0004 Computers in Principle and Practice
Due: Thursday, June 21st (The Day of the Final)
You have gone into business selling your newsletter. For the first 26 weeks,
here are the weekly figures for the expenses in producing
the newsletter and the number of newsletters that you have sold.
Using Microsoft Excel, make a spreadsheet whose values look like this. You can change the formatting to your
pleasing, but try to make the spreadsheet look nice. HOWEVER, and this is the
important thing, all of the cells in the Profit column, the accumulated profit
column, and the profit column in British currency should have formulas, and
not numerical entries. Further, you should use functions from the function wizard
for the Total Profit, Maximum Profit, and Maximum Loss values. Pay close attention
to relative and absolute addresses as you copy your formulas.
First, publish your spreadsheet on the World
Wide Web through your i5 account. Call the web page "assign8.html"
and put a link to it on your "index.html" page. Use the Excel Internet
Wizard to make your pages, and make certain that they include your name, and
other identifying information.
Publish the spreadsheet twice. First, display the values. Then, display the
formulas. This can be done as follows: Under "Tools," then "Preferences
for the Mac or "Options" for a PC; go to the "View" tab, click on "Formulas"
under the "Window Options" so that when you publish the sheet, it will contain
the Formulas and not the values.
Note that you sold your newsletter at $1 per copy through the 12th
week, but then raised the price to $1.25. Also, note that your profit per week
is the number of copies that you sold, times the price per copy, minus your
expenses that week. The accumulated profit is the accumulated profit from the
week before plus the profit (or loss) of the current week. The value in British
currency is the US dollar value divided by the conversion rate to the British
If you are clever, you will use copy and paste to transfer the values from
the table to Excel. The values have been separated by tabs, and so should be
easy to paste into an Excel spreadsheet. (On a Mac, or with certain browsers,
you may need to save the file of figures as a text file,
and then use Excel to open the text file---be sure to say "All file types"---designating
tabs as delimiters.)
Second, prepare a chart showing the growth of
your enterprise that looks something like this.
The chart may be on a separate web page if you prefer (but be sure to properly
label and link it from the "assign8.html" page so that we can find