Check-In Spreadsheet Info
nerdyandilikeit
Posts: 2,185 Member
If you're unsure where your House Spreadsheet is located, the links are posted below.
GRYFFINDOR: https://docs.google.com/spreadsheet/ccc?key=0AgqIcbJ240bVdE1ISXJFWWpGSy02Q2p2SEJLcDdSTEE
RAVENCLAW: https://docs.google.com/spreadsheet/ccc?key=0AnaZ2CBZ3MgTdGxWaWE5OVU0dkQzRE9hRko0S0huT3c
HUFFLEPUFF: https://docs.google.com/spreadsheet/ccc?key=0ArisWe6qmbHrdENZWmNPTVpOT2lzVWlnTS1hdUdTOUE
SLYTHERIN: https://docs.google.com/spreadsheet/ccc?key=0AgqIcbJ240bVdFZEMjlkZ3c5NkVxQ0Ffa003M2x5dnc
(Heads of House, please edit this post and change the link if needed to avoid confusion with multiple links.)
BEFORE YOU CHANGE ANYTHING ON THE SPREADSHEET, REVIEW THESE GUIDELINES TO AVOID PROBLEMS:
Google Docs is not as forgiving as Excel and there are a few rules that must be followed in order for the spreadsheet to not corrupt.
1) DO NOT drag data from one cell to another. If you key something in the wrong place, either copy and paste to the correct cell and then delete from the wrong cell or just key the info where you want it and delete from the wrong cell.
2) DO NOT touch the formulas on the weekly and summary tabs. They are almost 100% formula driven and are dependent on the "Weigh In Here" tab. If you key anything on those tabs, you lose the formulas. And if you drag data from one place to another on the "Weigh In Here" tab, you corrupt the formulas because they follow the drag - they do not reset.
3) The formulas on the weekly and summary tabs are made so that the weekly quidditch percentages and house point averages are automatically calculated - no one has to add up and calculate anything if the spreadsheet is used correctly. Just go to the tab for that week and there is the info all ready to report to you!
4) Because of the weekly formulas, you cannot put more than one month on the "weigh in here" tab - it will corrupt the calculations. To start a new month, delete all weights, OWLs, NEWTs and House Points from the "weigh in here" tab and start fresh.
5) I've added a place on the summary tab where they can keep track of weekly Prefects, the quidditch captain, head boy/girl and that type of thing for the month. This is a place to record the monthly summaries before the old data is deleted at month end.
6) The ONLY tab anyone should do any typing on is the "weigh in here" tab. And the HOH or whoever is monitoring everyone's progress can type in the section on the summary tab to the right of the table.
7) DO NOT drag data from one cell to another. Ever.
8) All months and dates keyed into the column headers, all student names and all weights, OWLS, NEWTs (if you use them) and House Points will automatically feed into the other tabs so everything is up to date. No need to key ANYTHING on any of the other tabs. They are all formulas and for information only.
9) If you want to sort the names alphabetically, you have to be very careful to be sure all weights stay with the right person! Here is the correct procedure:
i) On the "Weigh In Here" tab, click in cell A4
ii) Hold down the <Shift> key and at the same time click in cell O38 (Ravenclaw and Gryffindor) or S39 (Hufflepuff and Slytherin)
iii) On the toolbar just under the spreadsheet name, click "Data" and select "Sort range by column A, A --> Z" (3rd option down). Make sure you select "sort range" and not "sort sheet".
This will sort everything within the selected area keeping each student's data intact and will carry through to all of the other tabs as well.
10) If you need to delete a row (when a student decides to leave the challenge), follow these steps:
i) On the "Weigh In Here" tab, click in cell A4 (or is you want your name to stay at the top, click in cell A5)
ii) Hold down the <Shift> key and at the same time click in cell O38 (or the last cell in column O above the total line)
iii) On the toolbar just under the spreadsheet name, click "Data" and select "Sort range by column A, A --> Z" (3rd option down). Make sure you select "sort range" and not "sort sheet".
This will sort everything within the selected area and move all blank rows to the bottom. The other sheets will also sort to mirror the weigh in sheet, so no need to do anything with them.
11) This can't be repeated often enough: DO NOT drag data from one cell to another!! This also includes cut and paste - this is the same as dragging.
GRYFFINDOR: https://docs.google.com/spreadsheet/ccc?key=0AgqIcbJ240bVdE1ISXJFWWpGSy02Q2p2SEJLcDdSTEE
RAVENCLAW: https://docs.google.com/spreadsheet/ccc?key=0AnaZ2CBZ3MgTdGxWaWE5OVU0dkQzRE9hRko0S0huT3c
HUFFLEPUFF: https://docs.google.com/spreadsheet/ccc?key=0ArisWe6qmbHrdENZWmNPTVpOT2lzVWlnTS1hdUdTOUE
SLYTHERIN: https://docs.google.com/spreadsheet/ccc?key=0AgqIcbJ240bVdFZEMjlkZ3c5NkVxQ0Ffa003M2x5dnc
(Heads of House, please edit this post and change the link if needed to avoid confusion with multiple links.)
BEFORE YOU CHANGE ANYTHING ON THE SPREADSHEET, REVIEW THESE GUIDELINES TO AVOID PROBLEMS:
Google Docs is not as forgiving as Excel and there are a few rules that must be followed in order for the spreadsheet to not corrupt.
1) DO NOT drag data from one cell to another. If you key something in the wrong place, either copy and paste to the correct cell and then delete from the wrong cell or just key the info where you want it and delete from the wrong cell.
2) DO NOT touch the formulas on the weekly and summary tabs. They are almost 100% formula driven and are dependent on the "Weigh In Here" tab. If you key anything on those tabs, you lose the formulas. And if you drag data from one place to another on the "Weigh In Here" tab, you corrupt the formulas because they follow the drag - they do not reset.
3) The formulas on the weekly and summary tabs are made so that the weekly quidditch percentages and house point averages are automatically calculated - no one has to add up and calculate anything if the spreadsheet is used correctly. Just go to the tab for that week and there is the info all ready to report to you!
4) Because of the weekly formulas, you cannot put more than one month on the "weigh in here" tab - it will corrupt the calculations. To start a new month, delete all weights, OWLs, NEWTs and House Points from the "weigh in here" tab and start fresh.
5) I've added a place on the summary tab where they can keep track of weekly Prefects, the quidditch captain, head boy/girl and that type of thing for the month. This is a place to record the monthly summaries before the old data is deleted at month end.
6) The ONLY tab anyone should do any typing on is the "weigh in here" tab. And the HOH or whoever is monitoring everyone's progress can type in the section on the summary tab to the right of the table.
7) DO NOT drag data from one cell to another. Ever.
8) All months and dates keyed into the column headers, all student names and all weights, OWLS, NEWTs (if you use them) and House Points will automatically feed into the other tabs so everything is up to date. No need to key ANYTHING on any of the other tabs. They are all formulas and for information only.
9) If you want to sort the names alphabetically, you have to be very careful to be sure all weights stay with the right person! Here is the correct procedure:
i) On the "Weigh In Here" tab, click in cell A4
ii) Hold down the <Shift> key and at the same time click in cell O38 (Ravenclaw and Gryffindor) or S39 (Hufflepuff and Slytherin)
iii) On the toolbar just under the spreadsheet name, click "Data" and select "Sort range by column A, A --> Z" (3rd option down). Make sure you select "sort range" and not "sort sheet".
This will sort everything within the selected area keeping each student's data intact and will carry through to all of the other tabs as well.
10) If you need to delete a row (when a student decides to leave the challenge), follow these steps:
i) On the "Weigh In Here" tab, click in cell A4 (or is you want your name to stay at the top, click in cell A5)
ii) Hold down the <Shift> key and at the same time click in cell O38 (or the last cell in column O above the total line)
iii) On the toolbar just under the spreadsheet name, click "Data" and select "Sort range by column A, A --> Z" (3rd option down). Make sure you select "sort range" and not "sort sheet".
This will sort everything within the selected area and move all blank rows to the bottom. The other sheets will also sort to mirror the weigh in sheet, so no need to do anything with them.
11) This can't be repeated often enough: DO NOT drag data from one cell to another!! This also includes cut and paste - this is the same as dragging.
0
Replies
-
Blank Templates for each House
The House colors match each House, so please use the correct link if you need to use these!
NOTE: You will need to update the dates for the current month before using!
Gryffindor: https://docs.google.com/spreadsheet/ccc?key=0AgqIcbJ240bVdDZadXZzSHVHZ0RJbjk0d2UzV1FoMlE
Ravenclaw: https://docs.google.com/spreadsheet/ccc?key=0AgqIcbJ240bVdE96TjJ3UElCRHlkM1JNV0ZjaXBfcnc
Hufflepuff: https://docs.google.com/spreadsheet/ccc?key=0AgqIcbJ240bVdHo4eWtGaWZKWEhfR3dGUW91SGl4Z1E
Slytherin: https://docs.google.com/spreadsheet/ccc?key=0AgqIcbJ240bVdEt5WEUwVU4wUFhmaTNVemdqQTU3alE0 -
Hey Bron! Thanks for posting the guidelines and mentioning the dates - I totally forgot about those. Here are some more guidelines that I forgot to include:
8) All months and dates keyed into the column headers, all student names and all weights, OWLS, NEWTs (if you use them) and House Points will automatically feed into the other tabs so everything is up to date. No need to key ANYTHING on any of the other tabs. They are all formulas and for information only.
9) If you want to sort the names alphabetically, you have to be very careful to be sure all weights stay with the right person! Here is the correct procedure:
i) On the "Weigh In Here" tab, click in cell A4
ii) Hold down the <Shift> key and at the same time click in cell O38 (Ravenclaw and Gryffindor) or S39 (Hufflepuff and Slytherin)
iii) On the toolbar just under the spreadsheet name, click "Data" and select "Sort range by column A, A --> Z" (3rd option down). Make sure you select "sort range" and not "sort sheet".
This will sort everything within the selected area keeping each student's data intact and will carry through to all of the other tabs as well.
10) This can't be repeated often enough: DO NOT drag data from one cell to another!! This also includes cut and paste - this is the same as dragging.
Good luck to all of you!!0
