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