tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 813849d1674028233-iferror-but-still-shows-value-error-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Date | Priority
 |  |  |  |  |  |  |  |  |  |  | 2023-05-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-07-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-10-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-10-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-07-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-03-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-03-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-03-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2024-02-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-11-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-03-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-03-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-05-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-06-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-06-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-07-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-03-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-02-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-07-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023-03-31 00:00:00
Spreadsheet: 887917d1738239997-combining-vlookups-on-multiple-sheets-book2-bytemarks-
Sheet: One B

 | DEF-one |  |  | 1
 | DEF-two |  |  | 3
 | DEF-three |  |  | 4
 | DEF-four |  |  | 2
 | DEF-five |  |  | 3
 | DEF-six |  |  | 3
 | DEF-seven |  |  | 1
 | DEF-eight |  |  | 4
 | DEF-nine |  |  | 1
 | DEF-ten |  |  | 4
Spreadsheet: 78495d1278901623-creating-a-progress-chart-training-sample
Sheet: Criteria

 | Level 1 |  |  |  | Level 2
Criteria | Basic Powerpoint | Basic Excel | Basic Word | Management I | Advanced Powerpoint | Advanced Excel | Advanced Word
Course | Basic Powerpoint | Basic Excel | Basic Word | Management I | Advanced Powerpoint | Advanced Excel | Advanced Word
 | Basic Office | Basic Office | Basic Office |  | Advanced Office | Advanced Office | Advanced Office
Spreadsheet: 73067d1273727762-counting-the-digit-2-accross-mulitple-sheets-absence-log-2010
Sheet: October

Employee | 1 | 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
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 698306d1601913275-if-statement-with-networkdays-error-ge-parts-logistics-tracker-we41
Sheet: Shipment Status CoE

Shipment Status
Week | France | Germany | UK | Total
WE01 | 316011.024 | 2352808.5056 | 1168303.7778
WE02 | 309594.0064 | 1361759.0672 | 1250670.4152
WE03 | 242165.8624 | 1361759.0672 | 642103.7958000001
WE04 | 918794.1056000001 | 1420987.8032 | 1156448.5888
WE05 | 924241.7856000001 | 977308.3600000001 | 1165277.8447
WE06 | 1265444.5104 | 886219.9248000002 | 645407.2309
WE07 | 525072.0048000001 | 1029595.7168 | 622410.4138
WE08 | 622578.2192000002 | 1156016.8368 | 701593.2374
WE09 | 884606.8560000001 | 4241608.425600002 | 559605.942
WE10 | 386915.9952000001 | 3791171.7536 | 571706.8957
WE11 | 1139573.7024 | 3793355.7536 | 571706.8957
WE12 | 1137381.5824 | 3820671.545600001 | 601167.5683
WE13 | 1496694.3152 | 4103017.2288 | 691691.5935000001
WE14 | 1310349.4432 | 108618.4288 | 852551.9017
WE15 | 1314846.4672 | 218232.3696 | 860561.2837
WE16 | 922093.1888 | 245475.2496 | 1039979.2383
WE17 | 934306.2288 | 274298.3824000001 | 1067920.5972
WE18 | 1040364.0688 | 282292.3824000001 | 956167.0234
WE19 | 737879.3071999999 | 273701.9824 | 959491.2356999997
WE20 | 757814.4336 | 291568.2224 | 984723.4940999999
WE21 | 757814.4336 | 291568.2224 | 984723.4940999999
WE22 | 757814.4336 | 291568.2224 | 984723.4940999999
WE23 | 422085.7536 | 383159.5824 | 601985.6134
WE24 | 106027 | 315906 | 648916
WE25 | 107621.3376 | 267081.1024 | 648915.8345
WE26 | 107621.3376 | 267081.1024 | 648915.8345
WE27 | 916921.9136000001 | 225102.248 | 1369842.5359
WE28 | 1196512.3072 | 2060092.8208 | 1215667.6982
WE29 | 1113728.6272 | 2093216.3056 | 1086403.4406
WE30 | 1113728.6272 | 2093216.3056 | 1086403.4406
WE31 | 1666590.744 | 191744.6048 | 945854.2042999999
WE32 | 1625589.784 | 279760.4544 | 474539.1575999999
WE33 | 1643464.984 | 367946.2528 | 474539.1575999999
WE34 | 1561127.5456 | 577207.1424 | 464425.6904
WE35 | 1419035.3856 | 566320.7424000001 | 953866.2152
WE36 | 1419035.3856 | 566320.7424000001 | 953866.2152
WE37 | 2462985.638400001 | 491862.336 | 610099.5926
WE38 | 1492184.198400001 | 326647.8544 | 38091.4656
WE39 | 426162.5984000001 | 185288.488 | 38091.4656
WE40
WE41
WE42
WE43
WE44
WE45
WE46
WE47
WE48
WE49
WE50
WE51
WE52
Spreadsheet: 738735d1625222582-formula-to-calculate-total-amount-of-previous-invoice-error-formula
Sheet: Database

 | Lab-[PHONE]-D1 | 4000
 | Lab-[PHONE]-D2 | 22054.032
 | Lab-[PHONE]-D3 | 211088.592
 | Lab-[PHONE]-D4 | 54419.04
 | Lab-[PHONE]-D5 | 44762.0472
 | Lab-[PHONE]-D6 | 219681.072
 | Lab-[PHONE]-D7 | 239785.778
 | Lab-[PHONE]-D8 | 45636.5
 | Lab-[PHONE]-D9 | 9680.8608
 | Lab-[PHONE]-D10 | 211088.592
 | Lab-[PHONE]-D11 | 54419.04
 | Lab-[PHONE]-D12 | 53026.3422
 | Lab-[PHONE]-D13 | 17602.65
 | Lab-[PHONE]-D14 | 8592.48
 | Lab-[PHONE]-D15 | 40375.1088
Spreadsheet: 329367d1404290977-index-match-and-sumproduct-or-sumif-on-multiple-criteria-o1-book-1-tabkaz-1
Sheet: Sheet2

 |  |  | Table
 |  |  | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday |  |  |  |  |  |  |  | Data sheet
 | Time | Duration |  |  |  |  |  |  |  |  |  |  |  | this should b the answer of 15:00 slot |  |  | Time | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 |  |  | 2014-07-01 00:00:00 | 2014-07-02 00:00:00 | 2014-07-03 00:00:00 | 2014-07-04 00:00:00 | 2014-07-05 00:00:00 | 2014-07-06 00:00:00 | 2014-07-07 00:00:00 | 2014-07-08 00:00:00 | 2014-07-09 00:00:00 | 2014-07-10 00:00:00 | Required solution |  |  |  | 14:00:00 | 0.226 | 0.59 | 0.56 | 0.09497 | 0.27667 | 0.71325 | 0.20273
 |  |  |  |  |  |  |  |  |  |  |  |  |  | manual calculation of all days |  |  | 15:00:00 | 0.35603 | 0.89 | 0.41 | 0.04118 | 0.32722 | 0.22469 | 0.04751
 | 15:00:00 | 25 | 1 | 5 | 2 | 2 |  | 5 |  | 5 | 1 | 1 | ? |  |  |  | 16:00:00 | 0.09624 | 0.00683 | 0.15 | 0.2659 | 0.1042 | 0.13407 | 0.14101
 | 17:00:00 | 30 | 2 | 2 | 2 | 5 | 6 | 1 | 1 | 1 |  | 1 | ? |  |  |  | 17:00:00 | 0.12411 | 0.1502 | 0.18 | 0.15454 | 0.08427 | 0.02839 | 0.24431
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 | 0.0788 | 0 | 0.1 | 0.12141 | 0.07616 | 0.05667 | 0.2356
 |  |  | Required details
 |  |  | find & match tue rating of 15:00 time in "data sheet" divide by 30 then *total no of spot on tue in table above for 15:00* spot duration for 15:00,  same way addup for all days i.e wed, thu, fri, sat,sun&mon. answer should be in single cell. Table above are dates which can be changed but data sheet sequence of days will remain same way |  |  |  |  |  |  |  |  |  |  |  |  |  | manual calculation of days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tue | wed | thu | fri | sat | [NAME] | mon
 | 15:00:00 | 25
 | 17:00:00 | 30
Spreadsheet: 93298d1292887251-counting-frequency-per-hour-book1
Sheet: Sheet3

Time Of Day | Station # |  |  | Different Station #
12:00:00 AM | 1026 |  | 00:00:00
12:00:00 AM | 1027 |  | 01:00:00
12:00:00 AM | 1025 |  | 02:00:00
12:00:00 AM | 1028 |  | 03:00:00
1:00:00 AM | 1025 |  | 04:00:00
1:00:00 AM | 1028 |  | 05:00:00
2:00:00 AM | 1028 |  | 06:00:00
2:00:00 AM | 1025 |  | 07:00:00
3:00:00 AM | 1025 |  | 08:00:00
3:00:00 AM | 1028 |  | 09:00:00
4:00:00 AM | 1025 |  | 10:00:00
4:00:00 AM | 1028 |  | 11:00:00
5:00:00 AM | 1028 |  | 12:00:00
5:00:00 AM | 1025 |  | 13:00:00
6:00:00 AM | 1028 |  | 14:00:00
6:00:00 AM | 1025 |  | 15:00:00
7:00:00 AM | 1025 |  | 16:00:00
7:00:00 AM | 1530 |  | 17:00:00
7:00:00 AM | 1028 |  | 18:00:00
7:00:00 AM | 1926 |  | 19:00:00
7:00:00 AM | 1234 |  | 20:00:00
8:00:00 AM | 1530 |  | 21:00:00
8:00:00 AM | 1539 |  | 22:00:00
8:00:00 AM | 1930 |  | 23:00:00
9:00:00 AM | 1530
9:00:00 AM | 1930
9:00:00 AM | 1539
10:00:00 AM | 1930
10:00:00 AM | 1539
10:00:00 AM | 1530
10:00:00 AM | 1433
10:00:00 AM | 1139
10:00:00 AM | 1130
10:00:00 AM | 1135
10:00:00 AM | 1233
11:00:00 AM | 1433
11:00:00 AM | 1139
11:00:00 AM | 1135
11:00:00 AM | 1130
11:00:00 AM | 1233
11:00:00 AM | 1539
11:00:00 AM | 1726
11:00:00 AM | 1187
11:00:00 AM | 1185
12:00:00 PM | 1726
12:00:00 PM | 1185
12:00:00 PM | 1187
12:00:00 PM | 1135
12:00:00 PM | 1539
12:00:00 PM | 1130
12:00:00 PM | 1128
12:00:00 PM | 1139
12:00:00 PM | 1536
12:00:00 PM | 1132
1:00:00 PM | 1227
1:00:00 PM | 1230
1:00:00 PM | 1229
1:00:00 PM | 1231
1:00:00 PM | 1232
1:00:00 PM | 1226
1:00:00 PM | 1536
1:00:00 PM | 1233
1:00:00 PM | 1130
1:00:00 PM | 1132
1:00:00 PM | 1330
1:00:00 PM | 1126
1:00:00 PM | 1426
1:00:00 PM | 1225
1:00:00 PM | 1235
1:00:00 PM | 1234
1:00:00 PM | 1128
1:00:00 PM | 1127
1:00:00 PM | 1228
1:00:00 PM | 1535
2:00:00 PM | 1731
2:00:00 PM | 1538
2:00:00 PM | 1431
2:00:00 PM | 1429
3:00:00 PM | 1431
3:00:00 PM | 1232
3:00:00 PM | 1433
3:00:00 PM | 1535
3:00:00 PM | 1429
3:00:00 PM | 1731
3:00:00 PM | 1426
3:00:00 PM | 1930
3:00:00 PM | 1538
4:00:00 PM | 1426
4:00:00 PM | 1433
4:00:00 PM | 1538
4:00:00 PM | 1232
4:00:00 PM | 1431
4:00:00 PM | 1429
4:00:00 PM | 1026
4:00:00 PM | 1530
5:00:00 PM | 1026
5:00:00 PM | 1530
5:00:00 PM | 1529
5:00:00 PM | 1527
5:00:00 PM | 1525
6:00:00 PM | 1529
6:00:00 PM | 1527
6:00:00 PM | 1026
6:00:00 PM | 1027
6:00:00 PM | 1530
6:00:00 PM | 1525
7:00:00 PM | 1529
7:00:00 PM | 1525
7:00:00 PM | 1530
7:00:00 PM | 1027
7:00:00 PM | 1026
7:00:00 PM | 1527
8:00:00 PM | 1529
8:00:00 PM | 1027
8:00:00 PM | 1026
8:00:00 PM | 1538
9:00:00 PM | 1026
9:00:00 PM | 1538
9:00:00 PM | 1027
10:00:00 PM | 1027
10:00:00 PM | 1026
11:00:00 PM | 1027
11:00:00 PM | 1026
Spreadsheet: 473878d1470467200-separation-of-data-sample1
Sheet: feb

factory | sale | income | work day
b | 10 | 100 | 3
d | 12 | 500 | 4
a | 14 | 200 | 5
f | 13 | 300 | 6
h | 10 | 400 | 5
Spreadsheet: 829414d1684206629-power-query-custom-column-populating-using-worksheet-names-s666-pq-database
Sheet: TEXAS

 | TEXAS
 | Customer # | Time & Purchase Date | Name | Gender | DOB | Units | Price per Unit ($) | Total Price ($)
 | 1 | 1701|7 Jun 2011 | [NAME] | Male | 1988-05-12 00:00:00 | 50 | 1 | 50
 | 2 | 1545|26 Jun 2003 | Jackson Reed | Male | 1999-05-13 00:00:00 | 34 | 1.05 | 35.7
 | 3 | 2019|27 May 2013 | [NAME] | Male | 1965-05-14 00:00:00 | 42 | 1.02 | 42.84
 | 4 | 2021|4 Mar 2023 | [NAME] | Male | 2000-05-15 00:00:00 | 23 | 1.07 | 24.61
 | 5 | 1509|16 Apr 2009 | [NAME] | Female | 1989-05-16 00:00:00 | 10 | 0.95 | 9.5
 | 6 | 1805|24 Aug 2004 | [NAME] | Male | 1981-05-17 00:00:00 | 103 | 0.98 | 100.94
 | 7 | 2115|1 Nov 2022 | [NAME] | Female | 1994-05-18 00:00:00 | 61 | 1.02 | 62.22
 | 8 | 1534|18 Oct 2012 | Coren Malibi | Female | 1992-05-19 00:00:00 | 66 | 0.9 | 59.4
 | 9 | 1529|8 Apr 2012 | [NAME] | Male | 1988-05-12 00:00:00 | 71 | 1.11 | 78.81
 | 10 | 2348|16 May 2021 | [NAME] | Male | 1999-05-13 00:00:00 | 75 | 1.01 | 75.75
 | 11 | 2258|20 Feb 2020 | Jackson Reed | Male | 1965-05-14 00:00:00 | 80 | 0.98 | 78.4
 | 12 | 1030|7 Apr 2021 | [NAME] | Male | 2000-05-15 00:00:00 | 85 | 1.04 | 88.4
 | 13 | 1130|22 Jun 2016 | [NAME] | Male | 1989-05-16 00:00:00 | 90 | 1.02 | 91.8
Spreadsheet: 32019d1228146253-im-working-on-skiing-results-chart-and-have-problem-with-time-format-smukamilliseconds
Sheet: Tabela

Translation | Competitor | Time | Behind 1st
MESTO | TEKMOVALEC | ČAS | ZAOSTANEK
1 | [NAME] | 00:02:01.770000
2 | [NAME] | 00:02:23.123000
3 | [NAME] | 00:02:34.330000
4 | [NAME] | 00:02:35.540000
5 | Ealie | 00:02:36.550000
6 | George | 00:02:44.400000
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 859038d1707494659-mandatory-overtime-rotating-list-mot
Sheet: Sheet2

Employee Name | EOD
Hileman, [NAME] | 1992-03-08 00:00:00
Schaller, [NAME] | 2005-08-08 00:00:00
Fertal, [NAME] | 2010-09-12 00:00:00
[NAME], [NAME] | 2015-04-11 00:00:00
Ward, [NAME] | 2018-11-25 00:00:00
Klingensmith,[NAME] | 2020-11-08 00:00:00
Heinauer, [NAME] | 2020-12-20 00:00:00
Furman, [NAME] | 2022-03-27 00:00:00
Painter, [NAME] | 2022-05-22 00:00:00
Greco, MaryAnn | 2022-08-01 00:00:00
Brader, [NAME] | 2022-09-11 00:00:00
[NAME], [NAME]** | 2022-09-26 00:00:00
Wittmer, [NAME] | 2022-09-26 00:00:00
Peeler, [NAME] | 2023-03-26 00:00:00
Crim, Rebecca ** | 2023-07-03 00:00:00
Zaleski, Marsha** | 2023-07-03 00:00:00
Hanek, [NAME] | 2023-07-03 00:00:00
Paulding, [NAME] | 2023-09-10 00:00:00
Spreadsheet: 31167d1226967445-help-with-if-formula-nov-sample
Sheet: Ashby EOM

 |  | ASWA | Owner's | Payment | November | 2008
 |  |  |  | Eleanor Black
Date From | Date To | Description | Total Rent | Type | Percentage | Total
2008-11-08 00:00:00 | 2008-11-17 00:00:00 | Accommodation | 963 | Balance | 90% | 866.7
2008-11-19 00:00:00 | 2008-12-01 00:00:00 | Accommodation | 1344 | Balance | 90% | 1209.6
 |  |  |  |  | Total Due | 2076.3
 |  | ASWA Commission Claim
Date From | Date To | Description | Total Rent | Tax Code | Commission | Total
2008-11-08 00:00:00 | 2008-11-17 00:00:00 | Accommodation | 963 | GST | 0.2 | 211.86
 |  | Cleaning 17 Nov 08 |  | GST |  | 165
2008-11-19 00:00:00 | 2008-12-01 00:00:00 |  | 1344 | GST | 0.2 | 295.6800000000001
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 672.5400000000001
 |  | Payment Summary
Statement | Date | Type | Description | Amount Due | ASWA Claim | [NAME]
 | 2008-11-30 00:00:00 |  |  | 2076.3 | 672.5400000000001 | 1403.76
Spreadsheet: 16be3e6f-5845-4daf-8513-8edc1644524e
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
[NAME] | Test | [NAME] | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
[NAME] | Result | [NAME] | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6152-3 | Sorghum halepense Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 4.2(HC) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(HC): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2010-11
 | Major Group | HC - Health Careers
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2011 (October 15, 2011)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | na | na | na | na
 |  | Part Time | na | na | na | na
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured gainful employment after graduation.
 |  |  |  |  | July 1, 2011- June 30, 2012
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
 | App. graduates admitted to a college program |  | na | na | na | na
Diploma |  |  | na | na | na | na
 | [NAME]. graduates admitted to a college program |  | na | na | na | na
Certificate |  |  | na | na | na | na
 | Cert. graduates admitted to a college program |  | na | na | na | na
Associate Degree |  |  | na | na | na | na
 | Assoc. graduates admitted to four-year program |  | na | na | na | na
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Gainfully Employed after graduation |  |  | na | na | na | na
Graduates who completed remedial courses during their time at the TCU |  |  | na | na | na | na
Graduates who received A*CF support at some point during their coursework |  |  | na | na | na | na
Notes:
Spreadsheet: 586403d1534354959-multiple-lookups-matching-norms
Sheet: EXAMPLE

ID | Sex | Age | LOC.RawScore | LOC.Percentile | LOC.StdScore | OC.RawScore | OC.Percentile | OC.StdScore | LOC.OC.StdScoreSum | LOC.OC.StdScoreSumPercentile | LOC.OC.StdScoreSumQuotient
1 | 0 | 7.33 | 17 |  |  | 20
2 | 1 | 7.49 | 41 |  |  | 43
3 | 0 | 10.78 | 48 |  |  | 44
ID | Sex | Age | LOC.RawScore | LOC.Percentile | LOC.StdScore | OC.RawScore | OC.Percentile | OC.StdScore | LOC.OC.StdScoreSum | LOC.OC.StdScoreSumPercentile | LOC.OC.StdScoreSumQuotient
1 | 0 | 7.33 | 17 | <1 | 2 | 20 | 2 | 4 |  | <1 | 58
2 | 1 | 7.49 | 41 | 50 | 10 | 43 | 63 | 11 |  | 58 | 103
3 | 0 | 10.78 | 48 | 84 | 13 | 44 | 75 | 12 |  | 84 | 115
Spreadsheet: 89602d1289386983-picking-a-value-out-of-a-range-copy-of-book1
Sheet: in

DAILY-IN | 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
SERVICE DESK
[NAME]
[NAME]
[NAME]
[NAME]
Townsend  Neethling
FIRST LINE (Days)
[NAME]
[NAME]
Romesh Sharma
[NAME]
[NAME]
Esosa Igbinosun
FIRST LINE (Shifts)
[NAME]
Sum of Calls | Column Labels
Row Labels | 2010-11-01 00:00:00 | Grand Total
Service Desk | 13 | 13
[NAME] neale | 10 | 10
irene ash | 3 | 3
Support Level I | 3 | 3
[NAME] | 1 | 1
[NAME] | 1 | 1
[NAME] | 1 | 1
Support Level I (shift) | 2 | 2
gurpreet ahluwalia | 2 | 2
Support Level II | 28 | 28
[NAME] | 1 | 1
[NAME] | 1 | 1
Bharat Sisodiya | 1 | 1
[NAME] | 12 | 12
[NAME] | 7 | 7
davion simmonds | 5 | 5
hardeep [NAME] | 1 | 1
Support Level II (shift) | 12 | 12
[NAME] | 2 | 2
dion hura | 8 | 8
[NAME] | 2 | 2
Grand Total | 58 | 58
Spreadsheet: 97846d1296949206-sort-data-from-master-to-customized-tabs-2010-inc
Sheet: Master

Date | Customer | Commodity | Add't Details | Amount | Column1
2010-01-09 00:00:00 | [NAME] | Hay |  | 1855 | 146221.7
2010-01-09 00:00:00 | M & P Farms | Fertilizer |  | 42643.2
2010-01-09 00:00:00 | [NAME] | Hay |  | 5321.2
2010-01-09 00:00:00 | [NAME] | Oats |  | 37.7
2010-01-09 00:00:00 | Mars Pet Care US | Wheat |  | 95434.8
2010-01-09 00:00:00 | [NAME] | Feed |  | 380.7
2010-01-09 00:00:00 | [NAME] | Feed |  | 426.6
2010-01-09 00:00:00 | [NAME] | Hay |  | 122.5
2010-01-09 00:00:00
Spreadsheet: 90833d1290548341-string-search-multiple-occurrences-stringsearch
Sheet: Sheet1

String | [NAME] 1 | [NAME] 2 | My Attempt - Field 1 | My Attempt - Field 2
[NAME] -Resident | [NAME] | Resident | [NAME] | Kentucky -Resident
[NAME] -Kentucky | [NAME] | Kentucky | [NAME] | Kentucky
[NAME] | [NAME] | Resident | [NAME] | Kentucky-Resident
[NAME] | [NAME] | Resident | [NAME] | Resident
Spreadsheet: 862725d1710366790-need-help-nesting-index-and-xmatch-functions-final-project-part-ii-data-file
Sheet: Bonus-Depreciation

Boyd Logistics
Depreciation Conditions
Semi-truck (cost) |  | 150000
Salvage value (salvage) |  | 50000
Life of asset (life) |  | 5
Straight-Line Depreciation
Years | 1 | 2 | 3 | 4 | 5
Annual depreciation
Cumulative depreciation
Depreciated asset value
Declining Balance Depreciation
Years | 1 | 2 | 3 | 4 | 5
Annual depreciation
Cumulative depreciation
Depreciated asset value
Spreadsheet: 166693d1341731528-sum-unique-values-according-to-criteria-sumif-unique-values-sumif_unique_values
Sheet: Sheet1

Product Type | Global sum
Product 1 | 2 |  |  |  | I am looking for a formula that given a condition (Product type), sums all the unique values on another column (Global sum)
Product 2 | 4
Product 1 | 2
Product 2 | 4 |  |  |  | Expected results from example data:
Product 3 | 4 |  |  |  | Sum all unique values in column B for Product 1 = 2+3 = 5
Product 1 | 3 |  |  |  | Sum all unique values in column B for Product 2 = 4+5 = 9
Product 2 | 5
Product 3 | 3
Product 1 | 3 |  |  |  | I tried the solution on another post that seemed to describe my problem, but it didn't work…
Product 2 | 5 |  |  |  | SUM(IF(ISNUMBER(1/FREQUENCY(IF(B2:B13<>"";IF(A2:A13<>"";MATCH(A2:A13;A2:A13;0)));ROW(A2:A13)-ROW(A2)+1));B2:B13))
Product 1 | 3 |  |  |  | [NAME] result :
Product 2 | 5
 |  |  | Product 1
 |  |  | Product 2
 |  |  | Product 3
Spreadsheet: 7f49e473-6f0c-4ca9-959c-37454951ac52
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42357904 | 2014-07-19 01:24:32 | ALLIES | 0 | 1 | 6 | 1343508 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42477780 | 2014-07-27 19:20:14 | AXIS | 1 | 6 | 2 | 1092866 | Moscabovis | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
42497811 | 2014-07-29 01:58:28 | AXIS | 0 | 2 | 6 | 1611968 | Unrealik266 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42497959 | 2014-07-29 02:14:40 | ALLIES | 1 | 6 | 5 | 1611968 | Unrealik266 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
Spreadsheet: 866238d1713199988-help-with-formulas-to-populate-a-calendar-kansas-scheduler-calendar-test-v1
Sheet: ALL JOBS

 |  |  | DO NOT EDIT THIS SHEET- IT IS A REFERENCE SHEET!  DATA IS PULLED HERE FROM DIGITAL AND FABRIC TABS.
Press | SchedTime | Due Date | Job# | Line# | Master [NAME] | QTY | H | W | Material | Sides | PrintMode | Kitting | #OfKits | Notes | DateRecieved | SqFt | LinearFT
Spreadsheet: 164156d1340662536-sumif-formula-in-a-subtotal-excel-forum-6-25-12
Sheet: Sheet2

Last Name | Report Name | Amount Approved | Payment Type
EE 1 | Trip 1 | 10 | Credit Card
EE 1 | Trip 1 | 52 | Credit Card
EE 1 | Trip 1 | 5 | Cash
EE 1 | Trip 1 | 6 | Cash | <--Need the sum of all credit card charges for EE1, trip 1 under Column C
EE 2 | Trip 30 | 72 | Cash
EE 2 | Trip 30 | 80 | Cash
EE 2 | Trip 30 | 20 | Credit Card
EE 2 | Trip 30 | 50 | Credit Card
EE 2 | Trip 30 | 70 | Credit Card
EE 2 | Trip 30 | -300 | Credit Card
EE 2 | Trip 30 | 17 | Credit Card
EE 2 | Trip 30 | 18 | Credit Card
EE 2 | Trip 30 | 51 | Cash | <--Need the sum of all credit card charges for EE2, trip30 under Column C
EE 2 | Trip 31 | 87 | Cash
EE 2 | Trip 31 | 987 | Credit Card
EE 2 | Trip 31 | 145 | Credit Card
EE 2 | Trip 31 | 10 | Credit Card
EE 2 | Trip 31 | 5 | Credit Card
EE 2 | Trip 31 | 2 | Credit Card
EE 2 | Trip 31 | 18 | Credit Card
EE 2 | Trip 31 | 10 | Credit Card | <--Need the sum of all credit card charges for EE2, trip31 under Column C
EE 3 | Trip 3 | 27 | Cash
EE 3 | Trip 3 | 27 | Cash
EE 3 | Trip 3 | 33 | Cash
EE 3 | Trip 3 | 2 | Credit Card
 |  |  |  | <--Need the sum of all credit card charges for EE3, trip 3 under Column C
Spreadsheet: 50864d1250421635-extracting-numbers-with-the-same-word-in-diferrent-position-book2
Sheet: Sheet1

 | Interest | pres | Insurance | Inspection
Int              13,011.76
Inspect            123.75
Other                42.88 prop pres
bkdwn       250.00 ins
This is the data after copying from some website and then paste,  though the arrangement of the data is not consistent
 |  |  | My problem is "Insurance" also get the value for "Inspection"