Web Counters Webpage Directions

• Web Count data is emailed at midnight on the first of the month to Melissa Young. 2 emails.
• Open WebCounters_04_05.xls (library insider/webservices/webcounters)
• Enter data into spreadsheet - YTD cells
• Copy formulas where needed
• Save spreadsheet
• Highlight completed cells. Copy. Create new spreadsheet. Paste.
• Save as "CSV" file - save over test.csv (library insider/webservices/webcounters)
• Exit Excel
• Open Dreamweaver - Library Insider site
• Open existing file - WebCounters_05_06.htm (library insider/webservices)
• Delete existing table.
• Import tabular data - browse for the test.csv file.
• Highlight table - make all cells paragraphs.
• Highlight headings - make purple, yellow, whatever looks pretty.
• Save as "Web Page" - save over WebCountersTemp.htm (library insider/webservices/webcounters)
• Exit Excel
• Open Dreamweaver - Library Insider site
• Open existing file - WebCounters_04_05.htm (library insider/webservices)
• Open temp file - WebCountersTemp.htm
• In the temp file, click into the table, go to Modify, Table, Select Table
• Go to Edit, Copy
• In the WebCounters_04_05.htm file, paste table above existing table. Do not replace table, have both on the page.
• Select the table you pasted from temp. (Modify, Table, Select Table)
  • Text, Font, Arial
  • Text, Size Change, -1
  • Border = 1
  • Border Color = light grey
  • YTD and Monthly Heading = background #663399, text bold, text white
  • Other Headings (Reserves, Gov Docs, etc) = background #ffedc4
• Copy monthly totals target from previous month's table. Paste into Monthly Totals row.
• Delete the previous month's table

---

Hunter Library  |   Library Insider  |   Last updated: 8/1/05 Melissa Young