tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 264597d1378916560-counting-a-to-e-iterative-sumproduct
Sheet: Sheet1

Subject |  |  |  | A* | A | B | C | D | E | F | G
Art | D |  | Subject | A* | A*-A | A*-B | A*-C | A*-D | A*-E | A*-F | A*-G
Art | A |  | Art | 0 | 1 | 2 | 2 | 3 | 4 | 4 | 5
Art | B |  | Biology | 0 | 0 | 1 | 3 | 4 | 6 | 7 | 8
Art | E |  | Chemistry | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 3
Art | G |  | Design and Technology | 2 | 2 | 2 | 2 | 2 | 4 | 4 | 4
Biology | E |  | English Literature | 2 | 3 | 4 | 4 | 4 | 4 | 4 | 5
Biology | F
Biology | G
Biology | E
Biology | B
Biology | C
Biology | D
Biology | C
Chemistry | A*
Chemistry | G
Chemistry | F
Design and Technology | A*
Design and Technology | A*
Design and Technology | E
Design and Technology | E
English Literature | A
English Literature | G
English Literature | A*
English Literature | B
English Literature | A*
Spreadsheet: 452416d1458731449-auto-populate-tab-based-on-drop-down-from-different-tab-projec-tracker
Sheet: Consolidated

Consolidated Project Tracker
 | # | Priority | Project Description | Impact | Approximate Cost | Champion | Status | Completion Goal | Responsibility | Comments
 | 1 | High | Complete SW time studies on all extruders |  | 300 | Braun | 0 | 2016-04-01 00:00:00
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
Spreadsheet: 57619d1257842779-macro-for-auto-report-in-excell-general-ledger
Sheet: 1003

 | LOAN - 1003
 | DATE | A/C NAME | A/C NO | REF# | PARTICULARS | DR. | CR. | DR./ CR. | BALANCE |  |  |  |  | BANK | 1001
 | Opening Balance |  |  |  |  |  |  | - | 0 |  |  |  |  | CASH | 1002
 | 2009-11-02 00:00:00 | LOAN | 1003 | 4588 | PAID TO BANK FOR EXP |  | 500 | Cr. | -500 |  |  |  |  | LOAN | 1003
 |  |  |  |  |  |  |  | - | 0
 |  |  |  |  | TOTAL | 0 | 500 | Cr. | -500
Spreadsheet: 118625d1313800482-excel-2007-comparing-a-row-of-numbers-to-a-range-of-numbers-random-number-question1
Sheet: Sheet1

 | Lottery Results |  |  |  |  |  |  | Random Numbers
 | 4 | 38 | 41 | 42 | 43 | 44 |  | 35 | 10 | 17 | 48 | 47 | 9
 | 9 | 43 | 51 | 54 | 55 | 13
 | 11 | 19 | 39 | 45 | 54 | 15
 | 6 | 24 | 28 | 33 | 42 | 19
 | 14 | 17 | 19 | 20 | 32 | 28
 | 8 | 10 | 22 | 47 | 48 | 35
 | 20 | 25 | 35 | 52 | 55 | 10
 | 23 | 31 | 32 | 39 | 56 | 38
 | 2 | 9 | 10 | 16 | 35 | 40
 | 16 | 29 | 30 | 46 | 56 | 6
 | 3 | 9 | 11 | 44 | 49 | 9
 | 1 | 2 | 22 | 37 | 50 | 45
Spreadsheet: 788523d1658509664-help-with-index-match-based-on-another-cell-content-2022-07-22-oeldere-johny245-test-file-2-
Sheet: Sheet 1

Auto+Hide+Values
 |  | DWC20
 |  | DWC30
 | 13-102 | Cabbage
 | 41-102 | Orange
 | 33-184 | Apple
 | 18-109 | Pear
 | 41-495 | [NAME]
 | 33-186 | Cherries
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 0af3e029-6f66-4f19-a12c-d5e5fc1c7b2c
Sheet: R

Course color corresponds with term of offering.  RED for Fall semester, PURPLE for J-term, GREEN for both Fall and J-term.Summer School is in BLUE.
 | AOK Designation | CAR Designation | Comment
Religious Studies
RELS 112 | Civilizations-Philosophy & Religious Studies
RELS 205 | Civilizations-Philosophy & Religious Studies
RELS 210 | Civilizations-Philosophy & Religious Studies
RELS 211 | Civilizations-Philosophy & Religious Studies
RELS 212 | Civilizations-Philosophy & Religious Studies
RELS 215 | Civilizations-Philosophy & Religious Studies
RELS 217 | Civilizations-Philosophy & Religious Studies
RELS 221 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 222 | Civilizations-Philosophy & Religious Studies
RELS 223 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 225 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 227 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 228 | Civilizations-Philosophy & Religious Studies
RELS 229 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 230 | Civilizations-Philosophy & Religious Studies
RELS 231 | Civilizations-Philosophy & Religious Studies
RELS 235 | Civilizations-Philosophy & Religious Studies
RELS 237 | Civilizations-Philosophy & Religious Studies
RELS 240 | Civilizations-Philosophy & Religious Studies | Experiential-Travel
RELS 243 | Civilizations-Philosophy & Religious Studies | Experiential-Travel
RELS 245 | Civilizations-Philosophy & Religious Studies | Experiential-Travel; Non-Western
RELS 246 | Civilizations-Philosophy & Religious Studies | Experiential-Travel
RELS 247 | Civilizations-Philosophy & Religious Studies | Experiential-Travel | J-Term 2012
RELS 248 | Civilizations-Philosophy & Religious Studies | Experiential-Travel; Non-Western
RELS 251 | Civilizations-Philosophy & Religious Studies
RELS 260 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 262 | Civilizations-Philosophy & Religious Studies
RELS 271 | Civilizations-Philosophy & Religious Studies
RELS 273 | Civilizations-Philosophy & Religious Studies
RELS 274 | Civilizations-Philosophy & Religious Studies
RELS 275 | Civilizations-Philosophy & Religious Studies
RELS 311 | Civilizations-Philosophy & Religious Studies
RELS 312 | Civilizations-Philosophy & Religious Studies
RELS 323 | Civilizations-Philosophy & Religious Studies
RELS 335 | Civilizations-Philosophy & Religious Studies
RELS 336 | Civilizations-Philosophy & Religious Studies
RELS 343 | Civilizations-Philosophy & Religious Studies
RELS 352 | Civilizations-Philosophy & Religious Studies
RELS 375 | Civilizations-Philosophy & Religious Studies
RELS 381 | Civilizations-Philosophy & Religious Studies | Experiential-Travel | J-Term 2014 (Early Christianity)
RELS 384 | Civilizations-Philosophy & Religious Studies
RELS 401 |  | Capstone
RELS 487-488 |  | Experiential-Research
RELS 491-492 |  | Experiential-Research
RELS 496-498 |  | Experiential-Research
Spreadsheet: 783865d1655213199-transform-data-in-columns-to-rows-sample-1-
Sheet: Sheet1

This is the table I have
PACKAGE_CODE | Package Description | A | B | C | D | E | F | G | H | I
PK0004 | ABC | 1 | 210 | 210 | 0 | 0 | 105 | 105 | 105 | 420
PK0006 | CDE | 1 | 378 | 378 | 0 | 0 | 189 | 189 | 189 | 756
PK0007 | EFG | 1 | 315 | 315 | 0 | 0 | 157.5 | 157.5 | 157.5 | 630
This is the table I want
Package Code | Package Description | Group | Amount
PK0004 | ABC | A | 1
PK0004 | ABC | B | 210
PK0004 | ABC | C | 210
PK0004 | ABC | D | 0
PK0004 | ABC | E | 0
PK0004 | ABC | F | 105
PK0004 | ABC | G | 105
PK0004 | ABC | H | 105
PK0004 | ABC | I | 420
PK0006 | CDE | A | 1
PK0006 | CDE | B | 378
PK0006 | CDE | C | 378
PK0006 | CDE | D | 0
PK0006 | CDE | E | 0
PK0006 | CDE | F | 189
PK0006 | CDE | G | 189
PK0006 | CDE | H | 189
PK0006 | CDE | I | 756
PK0007 | EFG | A | 1
PK0007 | EFG | B | 315
PK0007 | EFG | C | 315
PK0007 | EFG | D | 0
PK0007 | EFG | E | 0
PK0007 | EFG | F | 157.5
PK0007 | EFG | G | 157.5
PK0007 | EFG | H | 157.5
PK0007 | EFG | I | 630
Spreadsheet: 109612d1306423652-count-unique-values-in-one-column-given-multiple-criteria-for-other-columns-count-of-unique
Sheet: Sheet1

 |  |  |  |  | Meet Criteria | Count |  | Select Criteria
uniquw val 9 | Criteria 1 | Criteria 5 | Criteria 1 |  |  |  |  | Criteria 1 | Criteria 5 | Criteria 6
uniquw val 9 | Criteria 1 | Criteria 5 | Criteria 6
uniquw val 7 | Criteria 1 | [NAME] | Criteria 6
uniquw val 4 | [NAME] | [NAME] | Criteria 6
uniquw val 9 | [NAME] | Criteria 1 | Criteria 1
uniquw val 1 | [NAME] | Criteria 6 | Criteria 3
uniquw val 2 | Criteria 3 | Criteria 1 | Criteria 5
uniquw val 1 | Criteria 3 | Criteria 1 | Criteria 5 |  |  |  |  | Ignore the items listed below, these are the items used in the drop down above
uniquw val 6 | Criteria 3 | Criteria 3 | Criteria 5 |  |  |  |  | Criteria 1 | [NAME] | Criteria 3 | [NAME] | Criteria 5 | Criteria 6
uniquw val 2 | Criteria 3 | Criteria 6 | Criteria 5
uniquw val 8 | Criteria 3 | Criteria 1 | Criteria 5
uniquw val 3 | Criteria 1 | [NAME] | Criteria 6
uniquw val 2 | Criteria 3 | Criteria 1 | Criteria 5
uniquw val 9 | [NAME] | [NAME] | Criteria 1
uniquw val 5 | [NAME] | Criteria 6 | [NAME]
uniquw val 3 | [NAME] | Criteria 6 | Criteria 5
uniquw val 9 | [NAME] | Criteria 3 | Criteria 1
uniquw val 1 | [NAME] | Criteria 6 | Criteria 6
uniquw val 10 | Criteria 5 | [NAME] | Criteria 5
uniquw val 4 | Criteria 5 | Criteria 3 | [NAME]
uniquw val 6 | Criteria 5 | Criteria 3 | [NAME]
uniquw val 6 | Criteria 6 | Criteria 1 | [NAME]
uniquw val 4 | Criteria 6 | [NAME] | [NAME]
uniquw val 7 | Criteria 6 | Criteria 5 | [NAME]
uniquw val 9 | Criteria 6 | Criteria 5 | Criteria 5
Spreadsheet: 692040d1598022874-count-and-sum-negative-numbers-on-filtered-lines-conta_somma
Sheet: Foglio1

 | B | R |  | Count | Sum
 | cc | 1 |  |  | -10
 | dd | 2
 | ee | 3
 | ff | 4
 | gg | -1
 | hh | -1
 | iii | -1
 | ll | -1
 | [NAME] | -1
 | nn | -2
 | oo | -3
 | pp | 8
 | qq | -1
 | rr | 6
 | ss | -1
 | tt | -1
 | uu | 10
========================================================ù
 | B | R |  | Count | Sum
 | cc | 1 |  | -5 | -8
 | dd | 2
 | ee | 3
 | ff | 4
 | gg | -1
l | hh | -1
 | iii | -1
 | ll | -1
o | [NAME] | -1
 | nn | -2
 | oo | -3
 | pp | 8
 | qq | -1
 | rr | 6
 | ss | -1
 | tt | -1
 | uu | 10
Spreadsheet: 66658d1267304750-blank-cell-payroll
Sheet: Sheet1

0 |  |  |  |  |  |  |  |  |  | EMPLOYEE EARNINGS |  |  |  |  | input rate  >> | 0.04 |  |  |  | EMPLOYEE DEDUCTIONS |  |  | EMPLOYER COST
 | WEEK |  |  |  | DAILY HOURS WORKED |  |  |  |  |  |  |  |  |  | TOTAL | Vac | TAXABLE |  |  | Income | Total | AMOUNT
MONTH | ENDING | S | M | T | W | T | F | S | Reg | Rate | ST | OT | Rate | ST | EARNINGS | Pay | EARNINGS | CPP | E I | Tax | Deductions | PAID | CPP | E I | TOTAL
J
U
N
E
 |  |  |  |  |  |  |  | [NAME]
J
U
L
Y
 |  |  |  |  |  |  |  | JULY TOTALS
A
U
G
 |  |  |  |  |  |  |  | [NAME]
S
E
P
T
 |  |  |  |  |  |  |  | SEPTEMBER TOTALS
O
C
T
 |  |  |  |  |  |  |  | OCTOBER TOTALS
 |  |  |  |  |  |  |  | T O T A L S | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EMPLOYEE INFORMATION
Name |  |  |  |  |  |  |  |  |  |  |  |  |  | SIN
Address |  |  |  |  |  |  |  |  |  |  |  |  |  | Birth Date
City |  |  |  |  |  |  |  |  |  |  |  |  |  | Gender
Province
Postal Code |  |  |  |  |  |  |  |  |  |  |  |  |  | Rate
Spreadsheet: kate_symes__18141__EESSales_dailyfeb
Sheet: 2-11

NP15 | 2001-02-11 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  |  | ZP26
Fixed Peak |  | Fixed Off Peak | 237.5 |  |  |  | Fixed Peak |  |  | Fixed Off Peak | 169.12 |  |  |  | Fixed Peak |  | Fixed Off Peak | 169.12
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  |  | Index Peak |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | 0 | 0 | -9.18 | -9.18 |  |  | 1 | -269.55 | 0 | -40 | -251.55 |  |  | 1 | -1.98 | 0 | 0 | -1.98
2 | 0 | 0 | -8.21 | -8.21 |  |  | 2 | -270.62 | 0 | -40 | -239.62 |  |  | 2 | -1.95 | 0 | 0 | -1.95
3 | 0 | 0 | -7.46 | -7.46 | 0 |  | 3 | -271.02 | 0 | -40 | -234.02 |  |  | 3 | -1.92 | 0 | 0 | -1.92
4 | 0 | 0 | -7.18 | -7.18 |  |  | 4 | -271.06 | 0 | -40 | -234.06 |  |  | 4 | -1.91 | 0 | 0 | -1.91
5 | 0 | 0 | -7.33 | -7.33 |  |  | 5 | -271.42 | 0 | -40 | -238.42 |  |  | 5 | -1.91 | 0 | 0 | -1.91
6 | 0 | 0 | -7.89 | -7.89 |  |  | 6 | -270.81 | 0 | -40 | -254.81 |  |  | 6 | -1.93 | 0 | 0 | -1.93
7 | 0 | 0 | -9.32 | -9.32 |  |  | 7 | -268.93 | 0 | -54 | -273.93 |  |  | 7 | -2 | 0 | 0 | -2
8 | 0 | 0 | -11.05 | -11.05 |  |  | 8 | -267.05 | 0 | -54 | -282.05 |  |  | 8 | -2.07 | 0 | 0 | -2.07
9 | 0 | 0 | -13.43 | -13.43 |  |  | 9 | -265.31 | 0 | -54 | -297.31 |  |  | 9 | -2.17 | 0 | 0 | -2.17
10 | 0 | 0 | -14.92 | -14.92 |  |  | 10 | -263.45 | 0 | -54 | -314.45 |  |  | 10 | -2.23 | 0 | 0 | -2.23
11 | 0 | 0 | -15.75 | -15.75 |  |  | 11 | -262.36 | 0 | -54 | -327.36 |  |  | 11 | -2.27 | 0 | 0 | -2.27
12 | 0 | 0 | -15.63 | -15.63 |  |  | 12 | -262.15 | 0 | -54 | -333.15 |  |  | 12 | -2.26 | 0 | 0 | -2.26
13 | 0 | 0 | -15.56 | -15.56 |  |  | 13 | -262.97 | 0 | -54 | -336.97 |  |  | 13 | -2.26 | 0 | 0 | -2.26
14 | 0 | 0 | -15.21 | -15.21 |  |  | 14 | -263.13 | 0 | -54 | -338.13 |  |  | 14 | -2.24 | 0 | 0 | -2.24
15 | 0 | 0 | -14.53 | -14.53 |  |  | 15 | -263.89 | 0 | -54 | -336.89 |  |  | 15 | -2.22 | 0 | 0 | -2.22
16 | 0 | 0 | -14.63 | -14.63 |  |  | 16 | -264.13 | 0 | -54 | -337.13 |  |  | 16 | -2.22 | 0 | 0 | -2.22
17 | 0 | 0 | -15.25 | -15.25 |  |  | 17 | -262.64 | 0 | -54 | -338.64 |  |  | 17 | -2.24 | 0 | 0 | -2.24
18 | -1.14 | 0 | -17 | -18.14 |  |  | 18 | -260.38 | 0 | -54 | -349.38 |  |  | 18 | -2.37 | 0 | 0 | -2.37
19 | -2.03 | 0 | -17 | -19.03 |  |  | 19 | -259.16 | 0 | -54 | -352.16 |  |  | 19 | -2.4 | 0 | 0 | -2.4
20 | -1.15 | 0 | -17 | -18.15 |  |  | 20 | -260.23 | 0 | -54 | -343.23 |  |  | 20 | -2.37 | 0 | 0 | -2.37
21 | -0.09 | 0 | -17 | -17.09 |  |  | 21 | -260.9 | 0 | -54 | -329.9 |  |  | 21 | -2.32 | 0 | 0 | -2.32
22 | 0 | 0 | -15.35 | -15.35 |  |  | 22 | -262.78 | 0 | -54 | -312.78 |  |  | 22 | -2.25 | 0 | 0 | -2.25
23 | 0 | 0 | -13.02 | -13.02 |  |  | 23 | -263.9 | 0 | -54 | -290.9 |  |  | 23 | -2.15 | 0 | 0 | -2.15
24 | 0 | 0 | -10.53 | -10.53 |  |  | 24 | -269.01 | 0 | -54 | -269.01 |  |  | 24 | -2.05 | 0 | 0 | -2.05
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 10c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60+ | TOTAL
Cross-Currency Basis | 1806746 | 908974 | 2428349 | 2479806 | 3807703 | 3912719 | 15344297
Cross-Currency Fixed-Fixed | 13852 | 18999 | 21274 | 38575 | 108813 | 177885 | 379398
Cross-Currency Fixed-Float | 152868 | 98264 | 151369 | 230006 | 334231 | 198465 | 1165203
TOTAL | 1973466 | 1026237 | 2600992 | 2748387 | 4250747 | 4289069 | 16888898
Spreadsheet: 02e7f128-1f59-4c26-918e-204053bde943
Sheet: Sheet1

Unnamed: 0 | Car Rental vs Mileage Reimbursement Calculator | Unnamed: 2
 | Input Variables
 | Total Miles to be Traveled | 118
 | Total Days in Trip | 1
 | Car Rental Daily Price * | 35.99
 | Sales Tax | 0.07
 | Cost of Gasoline per [NAME] | 3.75
 | Mileage Reimbursement Rate | 0.585
 | Rental Car Gas Mileage (MPG) | 25
 | Calculated Results
 | Own Car Cost
 | Mileage | 69.03
 | Rental Car Cost
 | Rental | 35.99
 | Sales Tax | 2.5193
 | Refueling | 17.7
 | Total | 56.2093
 | * Business Use Daily Rate
 | Compact | 32.99
 | Midsize | 35.99
 | Fullsize | 37.99
Spreadsheet: 869884d1716444471-gather-data-from-multiple-sheets-to-only-one-sheet-file-4-vicr1-aligw
Sheet: D

User Id | Name | Type | [NAME] | Group | State | Password status | Last connection |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | Name | UserId | User name | [NAME] | User type / Role (if available) | User status (if available)
ama1 | User Ama | Functional | Authorizers | A | Enabled | Active | 2022-07-11 00:00:00
[NAME] | User Arri | Functional | Initiators | B | Enabled | Active | 2024-01-25 00:00:00
Spreadsheet: joe_parks__14566__True Quote
Sheet: Term convention

Term | Months | Note
11-Monthly | 11 | 11 mo. strip
2 -Monthly | 2 | 2 mo. strip
3 -Monthly | 3 | 3 mo. strip
4 -Monthly | 4 | 4 mo. strip
5 -Monthly | 5 | 5 mo. strip
6 -Monthly | 6 | 6 mo. strip
Above a Year | 0
Month | 1 | 1 mo. price
Summer | 0 | Apr. - Oct. strip
Winter | 0 | Nov. - Mar. strip
Year | 12 | 1 year price
Spreadsheet: 197452d1354367303-timevalue-function-not-recognizing-1000ths-timer-score-sheets
Sheet: Day 2 PRINTOUT

FInal Results
2013-01-02 00:00:00
The Great White Crazy Race
Final Post | Bib | Musher's Name | Final Run Time
1 | 68 | [NAME] | 01:38:04
2 | 67 | Olly | 01:51:05
3 | 48 | [NAME] | 01:55:56
4 | 83 | [NAME] | 02:08:01
5 | 74 | Vlad | 02:13:07
6 | 47 | Buster | 02:16:50
7 | 78 | Mark | 02:21:43
8 | 72 | [NAME] | 02:22:28
9 | 44 | [NAME] | 02:23:57
10 | 43 | [NAME] | 02:34:11
11 | 55 | [NAME] | 02:34:50
12 | 59 | Billy | 02:39:49
13 | 73 | Juniper | 02:53:25
DNS | 80 | Adela | DNF
DNS | 65 | [NAME] | DNF
DNS | 66 | [NAME] | DNF
DNF | 77 | [NAME] | DNF
Spreadsheet: 84922d1285008625-lookup-data-based-on-date-paste-in-different-workbook-based-on-date-document1
Sheet: Sheet1

 | Blocked | Pickup
2010-09-20 00:00:00 | 5 | 4
2010-09-21 00:00:00 | 65 | 55
2010-09-22 00:00:00 | 59 | 56
2010-09-23 00:00:00 | 25 | 20
2010-09-24 00:00:00 | 55 | 51
2010-09-25 00:00:00 | 56 | 55
2010-09-26 00:00:00 | 24 | 23
2010-09-27 00:00:00 | 25 | 22
2010-09-28 00:00:00 | 50 | 50
2010-09-29 00:00:00 | 26 | 21
2010-09-30 00:00:00 | 24 | 23
2010-10-01 00:00:00 | 26 | 23
2010-10-02 00:00:00 | 80 | 70
2010-10-03 00:00:00
2010-10-04 00:00:00
2010-10-05 00:00:00
2010-10-06 00:00:00
2010-10-07 00:00:00
2010-10-08 00:00:00
2010-10-09 00:00:00
2010-10-10 00:00:00
2010-10-11 00:00:00
2010-10-12 00:00:00
2010-10-13 00:00:00
2010-10-14 00:00:00
2010-10-15 00:00:00
2010-10-16 00:00:00
2010-10-17 00:00:00
2010-10-18 00:00:00
2010-10-19 00:00:00
2010-10-20 00:00:00
2010-10-21 00:00:00
2010-10-22 00:00:00
2010-10-23 00:00:00
2010-10-24 00:00:00
2010-10-25 00:00:00
2010-10-26 00:00:00
2010-10-27 00:00:00
2010-10-28 00:00:00
2010-10-29 00:00:00
2010-10-30 00:00:00
2010-10-31 00:00:00
2010-11-01 00:00:00
2010-11-02 00:00:00
2010-11-03 00:00:00
2010-11-04 00:00:00
2010-11-05 00:00:00
2010-11-06 00:00:00
2010-11-07 00:00:00
2010-11-08 00:00:00
2010-11-09 00:00:00
2010-11-10 00:00:00
2010-11-11 00:00:00
2010-11-12 00:00:00
2010-11-13 00:00:00
2010-11-14 00:00:00
2010-11-15 00:00:00
2010-11-16 00:00:00
2010-11-17 00:00:00
2010-11-18 00:00:00
2010-11-19 00:00:00
2010-11-20 00:00:00
2010-11-21 00:00:00
2010-11-22 00:00:00
2010-11-23 00:00:00
2010-11-24 00:00:00
2010-11-25 00:00:00
2010-11-26 00:00:00
2010-11-27 00:00:00
2010-11-28 00:00:00
2010-11-29 00:00:00
2010-11-30 00:00:00
2010-12-01 00:00:00
2010-12-02 00:00:00
2010-12-03 00:00:00
2010-12-04 00:00:00
2010-12-05 00:00:00
2010-12-06 00:00:00
2010-12-07 00:00:00
2010-12-08 00:00:00
2010-12-09 00:00:00
2010-12-10 00:00:00
2010-12-11 00:00:00
2010-12-12 00:00:00
2010-12-13 00:00:00
2010-12-14 00:00:00
2010-12-15 00:00:00
2010-12-16 00:00:00
2010-12-17 00:00:00
2010-12-18 00:00:00
2010-12-19 00:00:00
2010-12-20 00:00:00
2010-12-21 00:00:00
2010-12-22 00:00:00
2010-12-23 00:00:00
2010-12-24 00:00:00
2010-12-25 00:00:00
2010-12-26 00:00:00
2010-12-27 00:00:00
2010-12-28 00:00:00
2010-12-29 00:00:00
2010-12-30 00:00:00
2010-12-31 00:00:00
Spreadsheet: 795425d1662668539-how-to-sum-multiple-datedifs-example-tracker-2
Sheet: CALC

Discipline | Count | Duration
Spreadsheet: 859736d1708006375-yield-formula-example
Sheet: Example

Quantity | [NAME] | Length |  | Parent [NAME] | Parent Length | Total Parents Required
1 | 247 | 1275 |  | 1250 | 2500
1 | 247 | 1384
1 | 277 | 1384
1 | 277 | 1665
1 | 367 | 1631
1 | 457 | 1987
1 | 457 | 1988
1 | 487 | 597
1 | 487 | 797
1 | 487 | 997
1 | 487 | 1197
1 | 487 | 1397
1 | 487 | 1597
1 | 487 | 1797
10 | 487 | 1988
1 | 517 | 1384
1 | 517 | 1522
1 | 547 | 397
1 | 547 | 996
1 | 547 | 1338
7 | 547 | 1384
1 | 547 | 1399
1 | 547 | 1461
1 | 547 | 1692
1 | 547 | 1726
1 | 547 | 1754
1 | 547 | 1787
1 | 547 | 1815
1 | 547 | 1848
1 | 547 | 1877
1 | 547 | 1939
1 | 547 | 2000
1 | 547 | 2062
1 | 547 | 2124
1 | 547 | 2185
1 | 547 | 2247
1 | 547 | 2309
1 | 547 | 2370
1 | 613 | 1724
1 | 619 | 1925
1 | 774 | 2209
Spreadsheet: 807179d1669792763-battery-charging-discharging-with-surplus-battery-state-of-charge-1-
Sheet: Sheet1

 | Time (hr) | Load (kW) | [NAME] (kW) | From Battery | From Grid | To Battery | Battery Charge | Surplus |  | Battery Specs | [NAME] | Min
 | 1 | 445 | 0 |  |  |  |  |  |  | State of Charge | 1000 | 0
 | 2 | 415 | 0 |  |  |  |  |  |  | Charging | 500 | 0
 | 3 | 277 | 0 |  |  |  |  |  |  | Discharging | 500 | 0
 | 4 | 401 | 0 |  |  |  |  |  |  | Initial state of Charge | 1000
 | 5 | 648 | 0
 | 6 | 645 | 0 |  |  |  |  |  |  | Conditions
 | 7 | 462 | 830 |  |  |  |  |  |  | Charge if | D2 is greater than C2
 | 8 | 459 | 798 |  |  |  |  |  |  | Discharge if | E3 is negative
 | 9 | 271 | 991 |  |  |  |  |  |  | State of Charge (Cummulative) | It adds and subtracts the charging and discharging and keeps it like a storage tank
 | 10 | 562 | 977 |  |  |  |  |  |  | Surplus | Whenver the battery is full, stop charging, and sent to surplus
 | 11 | 396 | 996
 | 12 | 418 | 183
 | 13 | 567 | 197
 | 14 | 647 | 511
 | 15 | 381 | 872
 | 16 | 348 | 588
 | 17 | 572 | 129
 | 18 | 560 | 0
 | 19 | 650 | 0
 | 20 | 402 | 0
 | 21 | 615 | 0
 | 22 | 593 | 0
 | 23 | 574 | 0
 | 24 | 364 | 0
Spreadsheet: 50805d1250280142-formula-with-muliple-outputs-detention-tracking
Sheet: Sheet1

[NAME] |  |  |  |  |  |  |  | Detention Dates
ID | Last Name | First Name | Grade | Team | Date | Code | Demerits | 2009-09-15 00:00:00 | 2009-09-22 00:00:00 | 2009-09-29 00:00:00 | 2009-10-06 00:00:00 | 2009-10-13 00:00:00 | 2009-10-20 00:00:00 | 2009-10-27 00:00:00 | 2009-11-03 00:00:00
125486 | Egbert | G | 8 | R | 2009-09-07 00:00:00 | T
125486 | Egbert | G | 8 | R | 2009-09-08 00:00:00 | T | 2
125478 | Flowers | C | 7 | L | 2009-09-08 00:00:00 | ST | 2
541236 | Hill | D | 8 | Q | 2009-09-07 00:00:00 | T
541236 | Hill | D | 8 | Q | 2009-09-08 00:00:00 | T
541236 | Hill | D | 8 | Q | 2009-09-09 00:00:00 | T | 3
123456 | [NAME] | A | 6 | G | 2009-09-08 00:00:00 | Ref | 2
456789 | [NAME] | S | 6 | K | 2009-09-07 00:00:00 | T
456789 | [NAME] | S | 6 | K | 2009-09-08 00:00:00 | T | 2
235689 | Truss | E | 7 | L | 2009-09-07 00:00:00 | T
235689 | Truss | E | 7 | L | 2009-09-08 00:00:00 | T | 2
456879 | [NAME] | D | 7 | N | 2009-09-09 00:00:00 | T | 1