this is a proof of concept for pasting an HTML table to Excel and dropping in formulas.
- TDs with the class .hidden_column will not be displayed in browser and not copied over to the XLS paste
- TDs with the class .XLS_switch with have the value of fmla substituted into their value on paste
- When the fmla contains chr(194) ... chr(195) this will be understood as something that needs substitution before paste
- Currently C tells it that we want a column. With C+ indicating columns to the right and C- indicating columns to the left. CA indicates we want the column with that exact id
| Student Number | Student | In-Class Checklist (from Participator) on 12-03-2019(mid-term) | mid-term Total | mid-term %/Max | Grade mid-term% | In-Class Checklist (from Participator) on 01-28-2020(final) | final Total | final %/Max | Grade final% | Culture Building - Surface Culture Fall 2019(hw) | Culture Building - Hidden Culture Fall 2019(hw) | Culture Building - LifeKeys Fall 2019(hw) | hw Total | hw %/Max | Grade hw% | Participation | Group Participation | participation Total | participation %/Max | Grade participation% | Final Participation | Final Group Participation | final_participation Total | final_participation %/Max | Grade final_participation% | Sum Total % | Rank |
| 123 | AAA | 1.00 | 1.00 | 100.00 | 15.00 | 1.00 | 2.00 | 100.00 | 10.00 | 0 | 0 | 0 | 0 | 0 | 0.00 | 137.00 | 16.00 | 153.00 | 98.71 | 39.48 | 10.00 | 4.00 | 14.00 | 140.00 | 7.00 | 71.48 | 9 |
| 124 | BBB | 1.00 | 1.00 | 100.00 | 15.00 | 1.00 | 2.00 | 100.00 | 10.00 | 0 | 0 | 0 | 0 | 0 | 0.00 | 238.00 | 16.00 | 254.00 | 163.87 | 65.55 | 12.00 | 4.00 | 16.00 | 160.00 | 8.00 | 98.55 | 1 |
| 125 | CCC | 1.00 | 1.00 | 100.00 | 15.00 | 1.00 | 2.00 | 100.00 | 10.00 | 0 | 0 | 0 | 0 | 0 | 0.00 | 121.00 | 3.00 | 124.00 | 80.00 | 32.00 | 3.00 | 2.00 | 5.00 | 50.00 | 2.50 | 59.50 | 27 |
| 126 | DDD | 1.00 | 1.00 | 100.00 | 15.00 | 1.00 | 2.00 | 100.00 | 10.00 | 0 | 0 | 0 | 0 | 0 | 0.00 | 102.00 | 16.00 | 118.00 | 76.13 | 30.45 | 3.00 | 4.00 | 7.00 | 70.00 | 3.50 | 58.95 | 28 |
| Rows: 36 | N/A | Ave:0.94 Max:1.00 Min:0.00 | Ave:0.94 Max:1.00 Min:0.00 | Ave:94.44 Max:100.00 Min:0.00 | Ave:14.17 Max:15.00 Min:0.00 | Ave:0.96 Max:1.00 Min:0.00 | Ave:1.93 Max:2.00 Min:0.00 | Ave:96.39 Max:100.00 Min:0.00 | Ave:9.64 Max:10.00 Min:0.00 | Ave:0.00 Max:0.00 Min:0.00 | Ave:0.00 Max:0.00 Min:0.00 | Ave:0.00 Max:0.00 Min:0.00 | Ave:0.00 Max:0.00 Min:0.00 | Ave:0.00 Max:0.00 Min:0.00 | Ave:0.00 Max:0.00 Min:0.00 | Ave:139.47 Max:238.00 Min:0.00 | Ave:12.31 Max:18.00 Min:0.00 | Ave:151.78 Max:254.00 Min:0.00 | Ave:97.92 Max:163.87 Min:0.00 | Ave:39.17 Max:65.55 Min:0.00 | Ave:2.86 Max:12.00 Min:-3.00 | Ave:2.94 Max:4.00 Min:0.00 | Ave:5.81 Max:16.00 Min:-1.00 | Ave:58.06 Max:160.00 Min:-10.00 | Ave:2.90 Max:8.00 Min:-0.50 | Ave:65.88 Max:98.55 Min:0.00 | N/A |
unfortunately github won't let it demonstrate because it needs CSS and JQuery and a few additional functions