Data import page for Transfiguration IHN, coffee hour, Kids' Club, and Chapel Time signups
Instructions:
Details about the original excel table (if you use the provided excel file, you're fine). If you want to set up a google doc, that works, too (email the webmaster for help, if necessary).
Source data must be tab delimited (or cut/pasted from an excel spreadsheet)
Row 1 and column 1 have special meanings, and are thus reserved (ie, please don't change those).
The filename must appear in the upper left cell (it doesn't matter what the excel file is called). This is very specific; each signup sheet has its own filename.
If you are the dinner coordinator, your filename should be "dinner"
If you are the evening coordinator, your file name should be "evening"
If you are the overnight coordinator, your filename should be "overnight"
If you are the setup/teardown coordinator, your filename should be "setup"
If you are the laundry coordinator, your filename should be "laundry"
If you are the grocery coordinator, your filename should be "shopper"
If you are the 9:30 coffee hour coordinator, your filename should be "930"
If you are the 9:30 coffee hour coordinator, your filename should be "1030"
If you are the Kids' Club coordinator, your filename should be "kidsclub"
If you are the Chapel Time coordinator, your filename should be "chapeltime"
the remainder of first is row filled with column background color names, if any
the remainder of first column is filled with row background color names, if any. Column colors take precedence over row color names if both are specified.
Some nice background color names: lime silver gray yellow (yellow) aqua fuchsia white, or literal color codes (eg: $CCCCCC) will work. We can tweak these colors moving forward.
text is black, unless the special sequences r: g: or b: are the first two characters in the cell (for red, green, or blue). For example "r:open" appears as "open".
text is normal strength unless surrounded by <b> and </b>. For example example "<b>open</b>" appears as "open". "r:<b>open</b>" appears as "open".
How to do this:
Fill in all the volunteer names in your excel file.
Copy everything to the left and above the bright red bars
Paste that into the big field above
Type the filename (dinner, evening, overnight, setup, or shopper); the one that matches the content of the upper left cell from your original spreadsheet) into the filename field above.
Enter the password in the password field above.
Press the Submit button; then navigate back to the original page (you may need to refresh the page).