tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 587549d1535090458-help-please-espitamation-sample
Sheet: Sheet1

Date | 0 boats (unique) | `+1 boats (unique) | [NAME] (unique) | Finished cruises | boats
2018-11-13 23 | 10 | 40 | 80 | 12 | 22
2018-11-13 22 | 5 | 55 | 91.66666666666666 | 13 | 44
2018-11-13 21 | 4 | 44 | 91.66666666666666 | 15 | 66
2018-11-13 20 | 6 | 68 | 91.8918918918919 | 22 | 22
2018-11-13 19 | 7 | 88 | 92.63157894736842 | 10 | 11
2018-11-13 18 | 12 | 50 | 80.64516129032258 | 88 | 22
Spreadsheet: darrell_schoolcraft__7317__imball0202
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -2376 | -2100 |  | -25
2 | -2273 | -2100 |  | -25
3 | -2269 | -2100 |  | -25
4 | -2236 | -2100 |  | -25
5 | -2299 | -2100 |  | -25
6 | -2039 | -2100 |  | -25
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
index
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92208.92
2002-02-06 00:00:00
CBS Volume
 |  |  | 38214
Spreadsheet: 109496d1306337620-conditional-sum-in-office-2007-book3
Sheet: Sheet1

Car Name | Date | Status |  |  |  |  |  |  | Count of Status | Column Labels
Honda City | 2011-05-24 00:00:00 | Delivered |  |  |  |  |  |  |  | 2011-05-24 00:00:00 |  | 5/24/2011 Total | (blank) | (blank) Total | Grand Total
Honda City | 2011-05-24 00:00:00 | Delivered |  |  |  |  |  |  | Row Labels | Delivered | Pending |  | (blank)
Honda City | 2011-05-24 00:00:00 | Delivered |  |  |  |  |  |  | Honda City | 3 | 2 | 5 |  |  | 5
Honda City | 2011-05-24 00:00:00 | Pending |  |  |  |  |  |  | [NAME] | 1 | 1 | 2 |  |  | 2
Honda City | 2011-05-24 00:00:00 | Pending |  |  |  |  |  |  | Grand Total | 4 | 3 | 7 |  |  | 7
Honda City
Honda City
[NAME] | 2011-05-24 00:00:00 | Delivered
[NAME] | 2011-05-24 00:00:00 | Pending
Spreadsheet: 55175d1255344035-filter-by-only-first-4-numbers-malchemist
Sheet: 31945

Date of Order | Date of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20081128 | 2008-11-28 | 244283 | Cordl. ham. dr. driver SFH 144-A Li-Ion | 1 | 91.95 | 131367 | 31945
20081128 | 2008-11-28 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.65 | 131367 | 31945
20081128 | 2008-11-28 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 49.42 | 131367 | 31945
20081128 | 2008-11-28 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 49.42 | 131367 | 31945
Spreadsheet: 839841d1692265123-count-how-many-times-a-number-appears-example-sheet
Sheet: Sheet1

[NAME] | Duration
7469193999 | 0
7469193999 | 0
7469193999 | 0
7469193999 | 0
7470082888 | 1518
7512672111 | 0
7512672111 | 0
7512672111 | 0
7512672111 | 0
7776755222 | 272
Spreadsheet: 118549d1313755344-index-and-match-multiple-values-problem-calendar
Sheet: Sheet2

Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Spreadsheet: 138647d1327782070-excel-2007-macro-for-inserting-rows-with-formulas-test-populated
Sheet: 125-165

Phase | Task | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Total | Quantity | Unit | Unit Price | Owned Equipment | Rented Equipment | Material | Subs | Other | [NAME] % | [NAME] Cost | Total Cost
 |  |  |  |  |  |  |  |  |  | Hours | Hours | Hours | Hours | Hours | Hours | Hours
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 125 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 125 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 130 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 130 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 135 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 135 Total
 | 10
 |  | .
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 140 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 140 Total
 | 10
 |  | .
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 145 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 145 Total
 | 10
 |  | .
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 150 |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 150 Total
 | 10
 |  | .
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 155 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 155 Total
 | 10
 |  | .
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 160 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 160 Total
 | 10
 |  | .
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 165 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 165 Total
 |  | Page Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (excluding markup)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage
Spreadsheet: 838857d1691472711-many-to-one-consolidation-using-arraytotext-function-book1
Sheet: Sheet1

Family | Genus
Acanthochitonidae | Acanthochitona |  |  | Genus
Acanthochitonidae | Americhiton |  | Acanthochitonidae | Acanthochitona, Americhiton, Choneplax, Craspedoplax, Cryptochiton, Cryptoconchus, [NAME], [NAME]
Acanthochitonidae | Choneplax |  | Acavidae | Embertoniphanta, Eurystyla, Stylodonta
Acanthochitonidae | Craspedoplax |  | Achatinellidae | [NAME], Auriculella, Elasmias
Acanthochitonidae | Cryptochiton
Acanthochitonidae | Cryptoconchus
Acanthochitonidae | Notoplax
Acanthochitonidae | [NAME]
Acavidae | Embertoniphanta
Acavidae | Eurystyla
Acavidae | Stylodonta
Achatinellidae | [NAME]
Achatinellidae | Auriculella
Achatinellidae | Elasmias
Spreadsheet: 67327d1267954308-look-up-with-multiple-criteria-and-list-box-new-resource-03-help
Sheet: Graphs

 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | 4.172888425928249
 |  |  |  |  |  |  |  |  |  |  |  | 2010-02-19 00:00:00 | 2010-02-26 00:00:00 | 2010-03-05 00:00:00 | 2010-03-12 00:00:00 | 2010-03-19 00:00:00 | 2010-03-26 00:00:00 | 2010-04-02 00:00:00 | 2010-04-09 00:00:00 | 2010-04-16 00:00:00 | 2010-04-23 00:00:00 | 2010-04-30 00:00:00 | 2010-05-07 00:00:00 | 2010-05-14 00:00:00 | 2010-05-21 00:00:00 | 2010-05-28 00:00:00 | 2010-06-04 00:00:00 | 2010-06-11 00:00:00 | 2010-06-18 00:00:00 | 2010-06-25 00:00:00 | 2010-07-02 00:00:00 | 2010-07-09 00:00:00 | 2010-07-16 00:00:00 | 2010-07-23 00:00:00 | 2010-07-30 00:00:00 | 2010-08-06 00:00:00 | 2010-08-13 00:00:00 | 2010-08-20 00:00:00 | 2010-08-27 00:00:00 | 2010-09-03 00:00:00 | 2010-09-10 00:00:00 | 2010-09-17 00:00:00 | 2010-09-24 00:00:00 | 2010-10-01 00:00:00 | 2010-10-08 00:00:00 | 2010-10-15 00:00:00 | 2010-10-22 00:00:00 | 2010-10-29 00:00:00 | 2010-11-05 00:00:00 | 2010-11-12 00:00:00 | 2010-11-19 00:00:00 | 2010-11-26 00:00:00 | 2010-12-03 00:00:00 | 2010-12-10 00:00:00 | 2010-12-17 00:00:00 | 2010-12-24 00:00:00 | 2010-12-31 00:00:00 | 2011-01-07 00:00:00 | 2011-01-14 00:00:00 | 2011-01-21 00:00:00 | 2011-01-28 00:00:00 | 2011-02-04 00:00:00 | 2011-02-11 00:00:00 | 2011-02-18 00:00:00 | 2011-02-25 00:00:00 | 2011-03-04 00:00:00 | 2011-03-11 00:00:00 | 2011-03-18 00:00:00 | 2011-03-25 00:00:00 | 2011-04-01 00:00:00 | 2011-04-08 00:00:00 | 2011-04-15 00:00:00 | 2011-04-22 00:00:00 | 2011-04-29 00:00:00 | 2011-05-06 00:00:00 | 2011-05-13 00:00:00 | 2011-05-20 00:00:00 | 2011-05-27 00:00:00 | 2011-06-03 00:00:00 | 2011-06-10 00:00:00 | 2011-06-17 00:00:00 | 2011-06-24 00:00:00 | 2011-07-01 00:00:00
 | Hours available to work
 | Project Hours
 | Proposal Hours
 | Total Workload Hours
Spreadsheet: 42915d1241541135-multiple-separate-if-forumlas-in-one-cell-sauder-cash-flow-projection-template
Sheet: Sheet2

Current Age | 60
Bucket 1 GR | 0.03
Bucket 2 GR | 0.05
Bucket 3 GR | 0.06
Bucket 4 GR | 0.06
Retirment Age
Percentage of Net Worth in Cash
Percentage of Net Worth in Non Qaulified Accounts
Percentage of Net Worth in Qualified Accounts
Net Worth Total
Tax Treatment
Spreadsheet: 00c44e93-e2fd-4a89-84f9-a325683ae3fb
Sheet: Q8 JENNY

JENNY |  |  | year | net worth | payment |  | cash value
n | 4 |  | 0
P | 866276.4031749142 |  | 1
X | 250000 |  | 2
F |  |  | 3
rate | 0.06 |  | 4
(1 + rate)^n
Spreadsheet: 116095d1311598504-pull-text-from-a-text-string-excel-forum-1-
Sheet: AM

Sy | TT | AM | 0
 | Row# | ID | Pattern/Split | Patt | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | CL | OFF | LD | REF | CLR
Spreadsheet: 696546d1600878040-lookup-value-with-multiple-criteria-to-report-back-another-value-lookup-value-for-multiple-values
Sheet: Sheet1

 | A | B | C | D | E | [NAME] | AxC | AxD | AxE | BxC | BxD | BxE | CxD | CxE | DxE | AxBxC | AxBxD | AxBxE
 | -1 | -1 | -1 | -1 | -1
 | -1 | -1 | -1 | -1 | 1
 | -1 | -1 | -1 | -1 | -1
 | -1 | -1 | -1 | -1 | 1
 | -1 | -1 | 1 | -1 | -1
 | -1 | -1 | 1 | -1 | 1
 | -1 | -1 | 1 | -1 | -1
 | 1 | 2 | 3 | 4 | 5
 | A | B | C | D | E | AxB | AxC | AxD | AxE | BxC | BxD | BxE | CxD | CxE | DxE | AxBxC | AxBxD | AxBxE
 | -1 | -1 | -1 | -1 | -1
 | -1 | -1 | -1 | -1 | 1
 | -1 | -1 | -1 | -1 | -1
 | -1 | -1 | -1 | -1 | 1
 | -1 | -1 | 1 | -1 | -1
 | -1 | -1 | 1 | -1 | 1
 | -1 | -1 | 1 | -1 | -1
 | -1 | -1 | 1 | -1 | 1
 | Problem: How to lookup the first letter of the cell in row 2 (blue) to match that letter to the letter on the left side (green).
 | Step 2: From that matched letter, depedning on what column the letter has matched to, report the value in the same row that the formula is in.
 | Example: | Lookup Cell G2 for either A,B,C,D,E, but only the first character (i.e. in "AxB" only report back "A", maybe a LEFT(G1,1) function?)
 |  | Match this lookup value to the array of B2:E2, in this case, A matches column B
 |  | Report the value to the Value that the fromula row is on, in this case B3 matches cell [NAME] for row, therefore report back cell B3
 | IF POSSIBLE | Multiply this lookup value by the letter in the second part of cell G2, so the third character
 |  | Match this lookup value to the array of B2:E2, in this case, A matches column C
 |  | Report the value to the Value that the fromula row is on, in this case C3 matches cell [NAME] for row, therefore report back cell [NAME]
 |  | Multiply the two lookedup values together to achieve a result. This formula should be able to be copied along the whole grid for the 1x1 parts.
 |  | If possible a formula which can encompass the 1x1x1 parts of the grid.
Spreadsheet: 127364d1320322722-moving-values-from-one-column-to-another-according-to-a-logic-dataintotable
Sheet: Sheet4

Name | X | Y |  |  |  | Name | TF_80 | TG_99 | TR_43
TF_80 | 7 | 35.2 | TF_80-7 |  |  | 7 | 35.2 | 54 | 49
TF_80 | 14 | 17.5 | TF_80-14 |  |  | 14 | 17.5 | 77 | 2
TF_80 | 21 | 65.4 | TF_80-21 |  |  | 21 | 65.4 | 15 | 24
TF_80 | 28 | 41.2 | TF_80-28 |  |  | 28 | 41.2 | 32 | 96
TG_99 | 7 | 54 | TG_99-7
TG_99 | 14 | 77 | TG_99-14
TG_99 | 21 | 15 | TG_99-21
TG_99 | 28 | 32 | TG_99-28
TR_43 | 7 | 49 | TR_43-7 |  |  | Sum of Y | Name
TR_43 | 14 | 2 | TR_43-14 |  |  | X | TF_80 | TG_99 | TR_43 | Grand Total
TR_43 | 21 | 24 | TR_43-21 |  |  | 7 | 35.2 | 54 | 49 | 138.2
TR_43 | 28 | 96 | TR_43-28 |  |  | 14 | 17.5 | 77 | 2 | 96.5
 |  |  |  |  |  | 21 | 65.4 | 15 | 24 | 104.4
 |  |  |  |  |  | 28 | 41.2 | 32 | 96 | 169.2
 |  |  |  |  |  | Grand Total | 159.3 | 178 | 171 | 508.3
Spreadsheet: 81984d1282067236-clone-worksheet-from-one-workbook-to-another-sample-summary
Sheet: Summary

Plan: | 401k
Employer: | Doe, Inc.
Year: | 1/1/10 - 12/31/10
 |  | Platform |  | Employee | Employer |  | Employee | Employer | Employee | Employer | Employee | Employer | Employee | Employer |  | Beginning
SS | Participant | Employee | Employer PS | Receivable | Receivable | Total | Contribution | Contribution | Gain/Loss | Gain/Loss | Fees | Fees | Distribution | Distribution | Forfeiture | Balance | Proof
1 | Doe, [NAME] | 13535.11 | 5497.32 | 0 | 0 | 19032.43 | 4000 | 350 | 425.74 | 213.24 | -15 | 0 | 0 | 0 | 0 | 14058.45 | 0
2 | Doe, [NAME] | 1687.52 | 5541.48 | 0 | 0 | 7229 | 1000 | 350 | 301.79 | 152.73 | -15 | 0 | 0 | 0 | 0 | 5439.48 | 0
3 | Doe, [NAME] | 26497.21 | 5134.89 | 0 | 0 | 31632.1 | 2500 | 350 | 200.33 | 114.66 | -15 | 0 | 0 | 0 | 0 | 28482.11 | 0
4 | Doe, [NAME] | 4884.66 | 5193.71 | 0 | 0 | 10078.37 | 2000 | 350 | 473.68 | 156.76 | -15 | 0 | 0 | 0 | 0 | 7112.93 | 0
 | Ending Balance | 46604.5 | 21367.4 | 0 | 0 | 67971.9 | 9500 | 1400 | 1401.54 | 637.39 | -60 | 0 | 0 | 0 | 0 | 55092.97 | 0
 |  |  |  |  |  | 67971.9
 | Statement Balance | 46604.5 | 21367.4 |  |  | 67971.9 | 9500 | 1400 | 1401.54 | 637.39 | -60 | 0 | 0 | 0 | 0 | 55092.97
 | [NAME] | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0
Spreadsheet: 691799d1597881485-string-18-000-cells-textjoin-zips
Sheet: Sheet1

Zip Code
854842
730413
455466
776182
306272
928437
558690
572927
684885
647986
642051
311676
159586
102454
363311
179587
810351
986149
762542
413114
Spreadsheet: 677899d1589571934-progressive-sum-with-condition-somma
Sheet: Foglio1

Codice | Data | Valore | [NAME] (?) | result
L1 | 2020-01-01 00:00:00 | 5 |  | 5
L2 | 2020-01-02 00:00:00 | 9 |  | 14
L1 | 2020-01-03 00:00:00 | 11 |  | 20
L3 | 2020-01-04 00:00:00 | 8 |  | 28
L1 | 2020-01-05 00:00:00 | 7 |  | 24
[NAME] | 2020-01-06 00:00:00 | 4 |  | 28
L2 | 2020-01-07 00:00:00 | 5 |  | 24
L1 | 2020-01-08 00:00:00 | 1 |  | 18
L2 | 2020-01-09 00:00:00 | 15 |  | 28
L2 | 2020-01-10 00:00:00 | 18 |  | 31
L5 | 2020-01-11 00:00:00 | 22 |  | 53
L3 | 2020-01-12 00:00:00 | 9 |  | 54
L5 | 2020-01-13 00:00:00 | 1 |  | 33
[NAME] | 2020-01-14 00:00:00 | 18 |  | 41
L2 | 2020-01-15 00:00:00 | 4 |  | 33
Spreadsheet: 777378d1650359736-need-conditional-formatting-help-for-days-leave-and-accrued-time-example-5-ans
Sheet: Sheet1 (2)

Org Unit # | Org Unit | Employee Name | Employee ID | Classification | Leave Type | Hours | FTE Days | Hours Worked | Comments
1111 | Brisbane | Person A | 12345 | AO2 | Accrued Time Leave | 105.8 | 14.59310344827586 | 36:15 |  | RED | =And($F2="Accrued Time Leave",$H2>=5)+AND($F2="Recreation Leave",$H2>=35)
 |  |  |  |  | Recreation Leave | 65.41666666666667 | 9.022988505747128 |  |  | ORANGE | =And($F2="Accrued Time Leave",$H2>=3,$H2<=4)+AND($F2="Recreation [NAME])
1111 | Brisbane | Person B | 54321 | AO7 | Recreation Leave | 236.3 | 32.59310344827586 | 36:15
1111 | Brisbane | Person C | 11223 | AO8 | Accrued Time Leave | 17.33333333333333 | 2.390804597701149 | 36:15
1111 | Brisbane | Person D | 33221 | AO2 | Accrued Time Leave | 40 | 5.517241379310345 | 36:15
 |  |  |  |  | Recreation Leave | 146.4666666666667 | 20.20229885057471
1111 | Brisbane | Person E | 98745 | AO6 | Accrued Time Leave | 13.91666666666667 | 1.919540229885057 | 36:15
 |  |  |  |  | Recreation Leave | 263.427777777778 | 36.3348659003831
Spreadsheet: 227845d1365849007-best-least-sqaures-fit-bds
Sheet: Bacteria_1

s | n | p | m
450 |  | 0.0002 | 0.0035 | 0.004 | 0.0045 | 0.005
 | 0 | 10 | 10 | 10 | 10 | 10
Spreadsheet: 169571d1342963252-how-do-i-divide-the-work-evenly-between-teammates-distribute
Sheet: Sheet1

THIS TEAM HAS THIS MANY PEOPLE | 13 | KDE #1 |  | KDE #1 | 78
THIS TEAM HAS THIS MANY PEOPLE | 10 | KDE #3 |  | KDE #2 | 78
THIS TEAM HAS THIS MANY PEOPLE | 15 | KDE #1 |  | KDE #3 | 79
THIS TEAM HAS THIS MANY PEOPLE | 14 | KDE #1 |  | KDE #4 | 79
THIS TEAM HAS THIS MANY PEOPLE | 20 | KDE #2
THIS TEAM HAS THIS MANY PEOPLE | 16 | KDE #2
THIS TEAM HAS THIS MANY PEOPLE | 11 | KDE #2
THIS TEAM HAS THIS MANY PEOPLE | 13 | KDE #1
THIS TEAM HAS THIS MANY PEOPLE | 11 | KDE #3
THIS TEAM HAS THIS MANY PEOPLE | 21 | KDE #2
THIS TEAM HAS THIS MANY PEOPLE | 20 | KDE #3
THIS TEAM HAS THIS MANY PEOPLE | 6 | KDE #3
THIS TEAM HAS THIS MANY PEOPLE | 18 | KDE #3
THIS TEAM HAS THIS MANY PEOPLE | 13 | KDE #2
THIS TEAM HAS THIS MANY PEOPLE | 21 | KDE #3
THIS TEAM HAS THIS MANY PEOPLE | 10 | KDE #4
THIS TEAM HAS THIS MANY PEOPLE | 18 | KDE #4
THIS TEAM HAS THIS MANY PEOPLE | 19 | KDE #4
THIS TEAM HAS THIS MANY PEOPLE | 12 | KDE #4
THIS TEAM HAS THIS MANY PEOPLE | 14 | KDE #2
THIS TEAM HAS THIS MANY PEOPLE | 19 | KDE #4
Spreadsheet: john_forney__15504__200107
Sheet: Hourly Detail

Counterparty Name |  | Total MW Losses | Total Dollar Losses
TXU Electric Services | TUET
Texas New Mexico Power | TNMP
Reliant Energy HL&P | REIT
City Public Services | CPST
American Electric Power Services Corp | WTUC
Lower Colorado River Authority | LCRA
American Electric Power Services Corp | CPLC
[NAME] | AENX
[NAME] | BEPCTMPP
Texas Municipal Power | TMPA
South Texas Electric Cooperative | STEC
South Texas Electric Cooperative | SMEC
Public Utilities Board of Brownsville | PUBX
Southwest Electric Service Company | SESC
Farmer's Electric Cooperative | FECX
TXU Electric Services | TNMPTUET
TXU Electric Services | COCS
Tex-La Electric Cooperative | TXLA
Magic Valley Electric Cooperative | MVEC
South Texas Electric Cooperative | MECX
TXU Electric Services | TVEC
City of Garland | COGX
Rio Grande Elerctic Cooperative | RGEC
Grayson-Collin Electric Cooperative | GCEC
Bryan Texas Utilities | BRYN
City of Denton Municipal Utilities | CODX
Grrenville Electric Utiliy System | GEUS
 | TOTAL
Counterparty Name |  | TOTAL MW | TOTAL DOLLAR
TXU Electric Services | TUET
Texas New Mexico Power | TNMP
Reliant Energy HL&P | REIT
City Public Services | CPST
American Electric Power Services Corp | WTUC
Lower Colorado River Authority | LCRA
American Electric Power Services Corp | CPLC
[NAME] | AENX
[NAME] | BEPCTMPP
Texas Municipal Power | TMPA
South Texas Electric Cooperative | STEC
South Texas Electric Cooperative | SMEC
Public Utilities Board of Brownsville | PUBX
Southwest Electric Service Company | SESC
Farmer's Electric Cooperative | FECX
TXU Electric Services | TNMPTUET
TXU Electric Services | COCS
Tex-La Electric Cooperative | TXLA
Magic Valley Electric Cooperative | MVEC
South Texas Electric Cooperative | MECX
TXU Electric Services | TVEC
City of Garland | COGX
Rio Grande Elerctic Cooperative | RGEC
Grayson-Collin Electric Cooperative | GCEC
Bryan Texas Utilities | BRYN
City of Denton Municipal Utilities | CODX
Grrenville Electric Utiliy System | GEUS
 | TOTAL
Spreadsheet: 851815d1701953832-sumifs-to-include-if-and-index-match-example-data
Sheet: Summary

 | Total By Age
 |  | TOTAL |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Total
 |  | 2021-04-01 00:00:00
 |  | 2021-05-01 00:00:00
 |  | 2021-06-01 00:00:00
 |  | 2021-07-01 00:00:00
 |  | 2021-08-01 00:00:00
 |  | 2021-09-01 00:00:00
 |  | 2021-10-01 00:00:00
 |  | 2021-11-01 00:00:00
 |  | 2021-12-01 00:00:00
 |  | 2022-01-01 00:00:00
 |  | 2022-02-01 00:00:00
 |  | 2022-03-01 00:00:00
 |  | 2022-04-01 00:00:00
 |  | 2022-05-01 00:00:00
 |  | 2022-06-01 00:00:00
 |  | 2022-07-01 00:00:00
 |  | 2022-08-01 00:00:00
 |  | 2022-09-01 00:00:00
 |  | 2022-10-01 00:00:00
 |  | 2022-11-01 00:00:00
 |  | 2022-12-01 00:00:00
 |  | 2023-01-01 00:00:00
 |  | 2023-02-01 00:00:00
 |  | 2023-03-01 00:00:00
 |  | 2023-04-01 00:00:00
 |  | 2023-05-01 00:00:00
 |  | 2023-06-01 00:00:00
 |  | 2023-07-01 00:00:00
 |  | 2023-08-01 00:00:00
 |  | 2023-09-01 00:00:00
 |  | 2023-10-01 00:00:00
 |  | TOTAL
Spreadsheet: aaa13ce9-ad81-48a3-b4ec-919663f54efc
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HBAG | Test | HBAG | Hepatitis B Surface Antigen, Serum | HBs Antigen, S | [NAME] | Serum Gel Tube: SGT OR |  |  | 2 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 2 mL Collection Instructions: Spin down and remove serum from clot within 24 hours. Additional Information: 1. Date of draw is required.  2. Indicate if specimens are from autopsy/cadaver or hemolyzed sources so that the proper FDA-licensed assay can be performed. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Negative See Viral Hepatitis Serologic Profiles in Special Instructions. | Monday through Sunday; Varies | 1 day | 2 days | 1 | 87340 |  |  |  |  | Rochester
HBAG | [NAME] | SST | Serum SST |  |  |  | Frozen
HBAG | Result | H_BAG | HBs Antigen, S | HBs Antigen, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5195-3
HBAG | [NAME] | HBGNT | Hepatitis B Surface Antigen Confirmation, Serum | HBs Antigen Confirmation, S | Chemiluminescence Immunoassay | Serum Gel Tube: SGT OR |  |  | 2 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 2 mL Collection Instructions: Spin down and remove serum from clot within 24 hours. Additional Information: Date of draw is required. | 1.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Negative | Monday through Saturday; Varies | 2 days | 4 days | 1 | 87341 |  |  | No | No
HBGNT | [NAME] | SST | Serum SST |  |  |  | Frozen
HBGNT | Result | HBGNT | HBs Antigen Confirmation, S | HBs Antigen Confirmation, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5195-3
Spreadsheet: kevin_presto__20057__EOL_Prices(Markets)_v1
Sheet: Price Change

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | PRICE |  |  |  | NORTHEAST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MIDWEST |  |  |  |  |  |  |  |  | SOUTHEAST |  |  |  |  |  | TEXAS
 |  | NYMEX GAS |  |  | NEPOOL |  |  | PJM |  |  | NY A |  |  | NY G |  |  | NY J |  |  | Cinergy |  |  | Comed |  |  | TVA |  |  | SOCO |  |  | Entergy |  |  | ERCOT
 |  | Price | Curve | Delta | Price | Curve | Delta | Price | Curve | Delta | Price | Curve | Delta | Price | Curve | Delta | Price | Curve | Delta | Price | Curve | Delta | Price | Curve | Delta | Price | Curve | Delta | Price | Curve | Delta | Price | Curve | Delta | Price | Curve | Delta
 | 2001-11-28 00:00:00
 | 11/29_30 |  |  |  |  | 35 |  |  | 21.8 |  |  | 25.5 |  |  | 31.65 |  |  | 33.05 |  |  | 20.65 |  |  | 18.65 |  |  | 18.25 |  |  | 21 |  |  | 18.25 |  |  | 19.25
 | 11/29_30 |  |  |  |  | 35 |  |  | 21.8 |  |  | 25.5 |  |  | 31.65 |  |  | 33.05 |  |  | 20.65 |  |  | 18.65 |  |  | 18.25 |  |  | 21 |  |  | 18.25 |  |  | 19.25
 | 2001-11-01 00:00:00
 | 2001-12-01 00:00:00
 | W 02
 | M/A 02
 | 2002-05-01 00:00:00
 | 2002-06-01 00:00:00
 | Sum 02
 | 2002-09-01 00:00:00
 | Q4 02
 | CAL-02
 | W 03
 | M/A 03
 | 2003-05-01 00:00:00
 | 2003-06-01 00:00:00
 | Sum 03
 | 2003-09-01 00:00:00
 | Q4 03
 | CAL-03
 | HEAT RATE |  |  |  | NORTHEAST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MIDWEST |  |  |  |  |  |  |  |  | SOUTHEAST |  |  |  |  |  | TEXAS
 |  | NYMEX GAS |  |  | NEPOOL |  |  | PJM |  |  | NY A |  |  | NY G |  |  | NY J |  |  | Cinergy |  |  | Comed |  |  | TVA |  |  | SOCO |  |  | Entergy |  |  | ERCOT
 |  | Price | Curve | Delta | HR | Curve | Delta | HR | Curve | Delta | HR | Curve | Delta | HR | Curve | Delta | HR | Curve | Delta | HR | Curve | Delta | HR | Curve | Delta | HR | Curve | Delta | HR | Curve | Delta | HR | Curve | Delta | HR | Curve | Delta
 | 2001-11-01 00:00:00
 | 2001-12-01 00:00:00
 | W 02
 | M/A 02
 | 2002-05-01 00:00:00
 | 2002-06-01 00:00:00
 | Sum 02
 | 2002-09-01 00:00:00
 | Q4 02
 | Cal 02
 | W 03
 | M/A 03
 | 2003-05-01 00:00:00
 | 2003-06-01 00:00:00
 | Sum 03
 | 2003-09-01 00:00:00
 | Q4 03
 | Cal 03