tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0bf82a60-237a-416b-8a93-4ccf6ab90e20
Sheet: Sheet1

 | Credit  Headcount At Census
 | MSJC Online Total by Gender
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13 |  |  | AY13-14
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13 | SU13 | [NAME] | SP14
Male |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73 | 1346 | 1238 | 0 | 1239 | 1291
Female |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 139 | 2405 | 2200 | 0 | 2197 | 2163
Undeclared |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 30 | 25 | 0 | 21 | 24
Term Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3478
Academic Year |  |  |  |  |  |  |  |  |  |  |  |  | 6120 |  |  | 5571 |  |  | 5312
% of Total | Credit Headcount % of Total
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13 |  |  | AY13-14
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13 | SU13 | [NAME] | SP14
Male |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3427 | 0.356 | 0.3582 |  | 0.3584 | 0.3712
Female |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6526 | 0.6361 | 0.6343 |  | 0.6355 | 0.6219
Undeclared |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0047 | 0.0079 | 0.0075 |  | 0.0061 | 0.0069
Success Rate | Success Rate
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13 |  |  | AY13-14
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13 | SU13 | [NAME] | SP14
Male | 0.7003188097768331 | 0.5406976744186046 | 0.5954724409448819 | 0.7258364312267658 | 0.6014563106796117 | 0.6110864745011086 | 0.6853333333333333 | 0.6015164279696714 | 0.5871377530766178 | 0.7619047619047619 | 0.6169578184916915 | 0.6215870307167235 |  | 0.632859109683341 | 0.5816448152562574 | 0.74 | 0.6 | 0.65 |  | 0.62 | 0.61
Female | 0.7092651757188498 | 0.6098297638660077 | 0.6221577164973391 | 0.7622950819672131 | 0.628526292033401 | 0.6458157227387996 | 0.7549591598599766 | 0.6554480437526293 | 0.6184707050645482 | 0.7881136950904393 | 0.6568364611260054 | 0.649589709469949 |  | 0.6541986623730492 | 0.6152802893309223 | 0.68 | 0.64 | 0.65 |  | 0.65 | 0.66
Undeclared | 0.8 | 0.5714285714285714 | 0.5681818181818182 | 0.8611111111111112 | 0.6129032258064516 | 0.5888888888888889 | 0.5789473684210527 | 0.7209302325581395 | 0.5925925925925926 | 0.6666666666666666 | 0.5616438356164384 | 0.7012987012987013 |  | 0.5538461538461539 | 0.7391304347826086 | 1 | 0.72 | 0.67 |  | 0.67 | 0.73
Term Average |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7 | 0.63 | 0.65 |  | 0.64 | 0.64
Success rate = # of “A, B, C, CR & P” grades divided by (the # of all grades) “A, B, C, CR, P, D, F, NC, NP, I and W”
Note: district totals exclude dual enrollment data
Spreadsheet: 4445fe5f-61c7-494c-9168-08899020cdd9
Sheet: EVEN START TITLE IB

Grant: |  | Title I-B Even Start Close Out Year
CFDA # |  | 84.213
GRANT NUMBER: |  | 5213
FISCAL YEAR: |  | 2011-12
[NAME]: |  | No carryover-grant ends 9/30/12
Question regarding payments: |  | [NAME]  [PHONE] or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez [PHONE] or [EMAIL]
LAST DAY TO SUBMIT REQUEST FOR THIS GRANT  - October 15, 2012
Code | District/Agency Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY 2011 | AUGUST 2011 | SEPTEMBER 2011 | OCTOBER 2011 | NOVEMBER 2011 | DECEMBER 2011 | JANUARY 2012 | FEBRUARY 2012 | MARCH 2012 | APRIL 2012 | MAY 2012 | APRIL 2012 | MAY 2012 | JUNE 2012 | JULY 2012 | AUGUST 2012 | SEPTEMBER 2012 | OCTOBER 2012
0870 | Delta SD | 74949 |  |  |  |  |  | 16933 |  | 5373 | 3889 | 3396 | 4035 | 5676 | 6971 |  |  | 7927 | 15957
2810 | Center SD | 68640 |  |  |  |  | 20204 | 9513 | 9599 | 9038 | 9109 | 4994 |  |  |  |  |  | 6183
Y651 | Metro College Family Literacy | 62457 |  |  |  |  | 4633 | 6146 | 10241 | 4824 |  |  | 9671 | 4850
Spreadsheet: 187574d1350509231-grouping-values-based-on-a-criteria-in-a-column-and-multiple-rows-over-a-range-test1-jacc
Sheet: Test Sheet

Name | Role | Nov-12 | Dec-12 | [NAME] |  |  |  | [NAME]
Test1 | R1 | 1 | 1 | 1
Test2 | R1 | 1 | 1
Test3 | R1 | 1
Test4 | R1
Test5 | R2 | 1 | 1 | 1
Test6 | R2 | 1
[NAME] | R2 | 1 | 1 | 1
Test8 | R2
Test9 | R2 | 1 | 1
Test10 | R3 | 1
Test11 | R3 |  | 1
Test12 | R3 | 1
Expected Output |  |  |  |  |  | Data
Role | Nov-12 | Dec-12 | [NAME] |  | Role | Count of Nov-12 | Count of Dec-12 | Count of Jan-13
R1 | 3 | 2 | 1 |  | R1 | 3 | 2 | 1
R2 | 4 | 3 | 2 |  | R2 | 4 | 3 | 2
R3 | 2 | 1 |  |  | R3 | 2 | 1
 |  |  |  |  | Grand Total | 9 | 6 | 3
Spreadsheet: 871145d1717571537-is-there-some-formules-for-my-problem-pallets-existing-table-etaf2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pallets | Hours |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 1-10 |  |  | 1 |  |  |  | 1 |  |  | 11 | 1.5
 |  |  |  |  |  |  |  |  |  |  | 11-20 |  |  | 1.5 |  |  |  | 2 |  |  | 21 | 2
 |  |  |  |  |  |  |  |  |  |  | 21-30 |  |  | 2 |  |  |  | 3 |  |  | 31 | 2.5
 |  |  |  |  |  |  |  |  |  |  | 31 - > |  |  | 2.5 |  |  |  | 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
Spreadsheet: kam_keiser__17824__bookentrytemplate_blank
Sheet: Book Data Fields

Color = required field | Note that all fields have a fixed text size
[NAME] 20 | Size 1 | Size 1 | Size 1 | [NAME] 15 | [NAME] 30, Dropdown | [NAME] 15 | Size 10 | [NAME] | Size 1 | [NAME] 15 | [NAME] 15 | Size 10 | [NAME] 128
BOOK ID | Portfolio Type Code | Book Code | Book Type Code (D, P, I, M Y) | Region Code As specified in the WHERE CLAUSE | Trading Location | Database ID ERMS or POWER or CANADA | NT user-id of Book Administrator | Commodity Code | Book Purpose (lowercase t for Trading or h for Hedging.) | Group ID (GAS or POWER) | Benchmark ID NG-NYMEX for Gas POWER for Power | Portfolio Code (POWER only) | Book Comments | [NAME]
Spreadsheet: 56143d1256237961-basic-question-how-to-cntrl-down-a-number-list-code
Sheet: Sheet1

ID | Code | ST_ABBREV | TOTPOP_CY | HHPOP_CY | FAMPOP_CY | GQPOP_CY | POPDENS_CY | DIVINDX_CY | TOTHH_CY | AVGHHSZ_CY | FAMHH_CY | AVGFMSZ_CY | MEDHINC_CY
[PHONE] | 1 | TX | 2084 | 2084 | 1973 | 0 | 370.4 | 38 | 514 | 4.05 | 462 | 4.27 | 32315
[PHONE] | 2 | TX | 1473 | 1473 | 1417 | 0 | 970.9 | 39.5 | 351 | 4.2 | 327 | 4.33 | 22034
[PHONE] | 3 | TX | 1738 | 1684 | 1480 | 54 | 1188.5 | 65.3 | 612 | 2.75 | 440 | 3.36 | 37399
[PHONE] |  | TX | 746 | 746 | 681 | 0 | 0.6 | 43.9 | 258 | 2.89 | 208 | 3.27 | 47739
[PHONE] |  | TX | 757 | 757 | 671 | 0 | 2.9 | 45.9 | 271 | 2.79 | 201 | 3.34 | 37429
[PHONE] |  | TX | 896 | 892 | 751 | 4 | 718.2 | 74.8 | 302 | 2.95 | 200 | 3.76 | 32436
[PHONE] |  | TX | 927 | 927 | 730 | 0 | 2319.2 | 58.4 | 380 | 2.44 | 232 | 3.15 | 40710
[PHONE] |  | TX | 845 | 833 | 660 | 12 | 3371.9 | 49.6 | 337 | 2.47 | 204 | 3.24 | 27857
[PHONE] |  | TX | 2047 | 2047 | 1741 | 0 | 529 | 67 | 713 | 2.87 | 519 | 3.35 | 32198
[PHONE] |  | TX | 810 | 810 | 718 | 0 | 0.8 | 55.2 | 308 | 2.63 | 236 | 3.04 | 44511
[PHONE] |  | TX | 1871 | 531 | 485 | 1340 | 2 | 80.4 | 195 | 2.72 | 161 | 3.01 | 55679
[PHONE] |  | TX | 1333 | 1333 | 1168 | 0 | 617.6 | 26.4 | 532 | 2.51 | 394 | 2.96 | 57932
[PHONE] |  | TX | 1197 | 1116 | 956 | 81 | 3109.9 | 16.8 | 487 | 2.29 | 345 | 2.77 | 46152
[PHONE] |  | TX | 1037 | 1036 | 925 | 1 | 1.9 | 24.9 | 369 | 2.81 | 291 | 3.18 | 48579
[PHONE] |  | TX | 1245 | 1245 | 1112 | 0 | 986.5 | 68.1 | 442 | 2.82 | 333 | 3.34 | 43906
[PHONE] |  | TX | 2702 | 2697 | 2424 | 5 | 4.2 | 55.9 | 1010 | 2.67 | 801 | 3.03 | 48120
[PHONE] |  | TX | 2797 | 2797 | 2570 | 0 | 651.3 | 93.5 | 728 | 3.84 | 627 | 4.1 | 37055
[PHONE] |  | TX | 1252 | 1252 | 1148 | 0 | 4835.8 | 36.1 | 447 | 2.8 | 368 | 3.12 | 52823
[PHONE] |  | TX | 655 | 655 | 602 | 0 | 5157.5 | 62.1 | 239 | 2.74 | 199 | 3.03 | 67536
[PHONE] |  | TX | 1084 | 1084 | 944 | 0 | 1239.1 | 75.8 | 378 | 2.87 | 278 | 3.4 | 42802
[PHONE] |  | TX | 1154 | 1154 | 999 | 0 | 1399.8 | 85.5 | 339 | 3.4 | 249 | 4.01 | 28138
[PHONE] |  | TX | 925 | 867 | 768 | 58 | 3356.3 | 83.9 | 287 | 3.02 | 218 | 3.52 | 41408
[PHONE] |  | TX | 1718 | 1718 | 1507 | 0 | 4528.2 | 79.1 | 613 | 2.8 | 455 | 3.31 | 47428
[PHONE] |  | TX | 728 | 728 | 646 | 0 | 3799.6 | 51 | 281 | 2.59 | 212 | 3.05 | 61973
[PHONE] |  | TX | 1449 | 1419 | 1255 | 30 | 4484.7 | 76.2 | 525 | 2.7 | 399 | 3.15 | 52535
[PHONE] |  | TX | 1106 | 1106 | 991 | 0 | 3170 | 83.8 | 355 | 3.12 | 277 | 3.58 | 32217
[PHONE] |  | TX | 1366 | 1366 | 1192 | 0 | 2893.5 | 84.9 | 442 | 3.09 | 316 | 3.77 | 29161
[PHONE] |  | TX | 1124 | 1037 | 927 | 87 | 5832.9 | 78.5 | 352 | 2.95 | 273 | 3.4 | 37574
[PHONE] |  | TX | 466 | 229 | 221 | 237 | 190.4 | 36.2 | 74 | 3.09 | 71 | 3.11 | 54121
[PHONE] |  | TX | 1388 | 1316 | 1173 | 72 | 355.9 | 78.7 | 456 | 2.89 | 346 | 3.39 | 47496
[PHONE] |  | TX | 1342 | 1342 | 1204 | 0 | 1701.5 | 80.5 | 477 | 2.81 | 362 | 3.33 | 43642
Spreadsheet: 598863d1542751727-understanding-what-this-formula-is-doing-in-laymans-terms-example-sheet
Sheet: Weighted Table

Jan | 0.05507883332865967
Feb | 0.0889394139759437
Mar | 0.08525642484823723
Apr | 0.08669012979446146
May | 0.1228484647157771
Jun | 0.1072592047987476
Jul | 0.09847850138465054
Aug | 0.0669927253071829
Sep | 0.0659153496281272
Oct | 0.04419700413319987
Nov | 0.06098427643193871
Dec | 0.117359671653074
Spreadsheet: 847889d1698724755-retrive-and-add-mulitpe-results-based-on-dates-autosum-date
Sheet: Sheet1

2023-11-02 00:00:00 |  |  | MRW |  |  |  |  |  | 72
2023-11-05 00:00:00 |  |  | MRW |  |  |  |  |  | 72
2023-11-17 00:00:00 |  |  | MRW |  |  |  |  |  | 72
2023-12-24 00:00:00 |  |  | MRW |  |  |  |  |  | 72
2023-12-05 00:00:00 |  |  | MRW |  |  |  |  |  | 72
2023-12-12 00:00:00 |  |  | MRW |  |  |  |  |  | 72
2023-11-20 00:00:00 |  |  | RW |  |  |  |  |  | 250
2023-11-24 00:00:00 |  |  | RLF |  |  |  |  |  | 200
2023-11-27 00:00:00 |  |  | RW |  |  |  |  |  | 206
2023-11-03 00:00:00 |  |  | RW |  |  |  |  |  | 38
2023-11-03 00:00:00 |  |  | RW |  |  |  |  |  | 215
2023-11-10 00:00:00 |  |  | RW |  |  |  |  |  | 220
2023-11-14 00:00:00 |  |  | RLF |  |  |  |  |  | 200
2023-11-17 00:00:00 |  |  | RW |  |  |  |  |  | 220
2023-11-21 00:00:00 |  |  | RLF |  |  |  |  |  | 200
2023-11-24 00:00:00 |  |  | RW |  |  |  |  |  | 220
2023-11-28 00:00:00 |  |  | RLF |  |  |  |  |  | 169
2023-12-01 00:00:00 |  |  | RW |  |  |  |  |  | 299
2023-12-05 00:00:00 |  |  | RLF |  |  |  |  |  | 200
2023-12-08 00:00:00 |  |  | RW |  |  |  |  |  | 360
2023-12-15 00:00:00 |  |  | RW |  |  |  |  |  | 200
2023-11-03 00:00:00 |  |  | SAW |  |  |  |  |  | 10
2023-11-03 00:00:00 |  |  | [NAME] |  |  |  |  |  | 146
2023-11-02 00:00:00 |  |  | JDA |  |  |  |  |  | 100
2023-11-16 00:00:00 |  |  | JDA |  |  |  |  |  | 100
2023-12-14 00:00:00 |  |  | JDA |  |  |  |  |  | 100
Spreadsheet: 781435d1653321736-filter-only-unique-values-filter-only-unique
Sheet: DATA

Date | Serial number | Reason for return
2022-04-20 00:00:00 | NL17314620 | Door issue
2022-04-20 00:00:00 | NL17016595 | Door issue |  |  | I need to see only the serial numbers with reason of return Door issue.
2022-04-20 00:00:00 |  | LCD issue |  |  | If there is a serial number with multiple reason of returns value must not be considered.
2022-04-20 00:00:00 | N119229362 | Door issue
2022-04-20 00:00:00 | NL17146177 | Keypad issue
2022-04-20 00:00:00 | NL16277129 | Housing issue
2022-04-20 00:00:00 |  | Door issue
Spreadsheet: 132295d1323687007-excel-2007-eliminating-weekend-in-bar-chart-plan_schedule_jpr73_a
Sheet: Plan

# | Task Name | Resource | Status | Start Date | Dur.
 | This is sample task
Spreadsheet: 79703d1279896309-formula-to-get-a-unique-value-list-and-sort-one-column-by-numbers-in-another-column-pivot
Sheet: Sheet1

Person | Count | Row Labels | Sum of Count
A | 1 | B | 8
B | 3 | A | 5
A | 4 | D | 4
B | 5 | C | 2
C | 2
D | 3
D | 1
Spreadsheet: 137793d1327368702-nested-if-statement-with-index-and-match-within-vanguard-template
Sheet: Sheet2

 | Products
 | [NAME]
 | [NAME]
 | Brampton
 | Operation
 | Manual
 | Hard Wired
 | Remote
 | Control
 | Wall switch uno - hard wired | 15
 | Wall switch duo - hard wired | 20
 | Telis RTS 1 channel | 85
 | Telis RTS 5 channel | 135
 | Telis 16 - pure | 185
 | Telis 16 - silver | 205
 | [NAME] | 200
 | [NAME] | 215
 | Sensor
 | Wind sensor - hard wired (inc. switch) | 290
 | Wind sensor - RTS (inc. 1 channel remote) | 225
 | Wind sensor - RTS (inc. 5 channel remote) | 265
 | Sun and wind sensor - hard wired (inc. switch) | 310
 | Sun and wind sensor - RTS (inc. 1 channel remote) | 275
 | Sun and wind sensor - RTS (inc. 5 channel remote) | 315
 | Material
 | Category 3
 | Category 4
 | Category 5
 | Category 8
 | Category 9
 | Category 11
 | Beam
a | 50 x 50 | 47
b | 100 x 50 | 47
c | 150 x 50 | 95
d | 200 x 50 | 105
e | 250 x 50 | 125
 | Answer
 | Yes
 | No
Spreadsheet: 712167d1610095181-dynamic-calendar-that-predicts-when-something-will-need-to-be-ordered-again-pulling-dates-gk
Sheet: Input Data

Item number | Time to finish item | Estimated time to finish item | Item | Purchase Date | extra information
10 | 6 | 8 | banana | 2020-12-13 00:00:00 | extra information
9 | 5 | 5 | grape | 2020-12-02 00:00:00 | extra information
8 | 7 | 5 | apple | 2020-11-08 00:00:00 | extra information
7 | 10 | 9 | [NAME] | 2020-09-27 00:00:00 | extra information
6 | 22 | 18 | potato | 2020-08-18 00:00:00 | extra information
5 | 5 | 8 | banana | 2019-06-02 00:00:00 | extra information
4 | 6 | 5 | grape | 2019-12-02 00:00:00 | extra information
3 | 7 | 5 | apple | 2019-11-06 00:00:00 | extra information
2 | 11 | 9 | [NAME] | 2019-09-25 00:00:00 | extra information
1 | 24 | 18 | potato | 2019-08-11 00:00:00 | extra information
Spreadsheet: 124514d1318449357-need-a-formula-to-make-excel-search-for-info-book1
Sheet: Worksheet 2

MEMBER | [NAME] | BLDG | NAME | FLOOD ZONE | ADDRESS | CITY | ST | ZIP | BUILDING DESCRIPTION
001 | 001 | 001 | abcde | C | 123 Main Street USA | None | zz | 12121 | XYZ Company
001 | 001 | 016 |  |  |  |  |  |  | 123 Company
001 | 001 | 014 |  |  |  |  |  |  | ABC Company
001 | 001 | 017 |  |  |  |  |  |  | 987 Company
001 | 001 | 015 |  |  |  |  |  |  | A2C Company
Spreadsheet: 880536d1728324658-sumifs-returning-0-when-it-shouldnt-whysumifs_giving_0
Sheet: Data

Hdr1 | Hdr2 | Hdr3 | Hdr4 | Hdr5 | IDNum | ID_Psn | Hdr6 | Hdr7 | Hdr8 | [NAME] | Hdr10 | Amount | Hdr11 | Hdr12 | ID_Note
JANSSEN  [US] | 70033093STR3001 | FRANCE | Elena Meseguer | AG7-FR10005 | A1 | B1 | U1 | T1 | 3 | 1 | 1 |  | 2023-09-05 00:00:00 |  | C1
JANSSEN  [US] | 70033093STR3001 | FRANCE | Elena Meseguer | AG7-FR10005 | A1 | B1 | U1 | T2 | 153 | 1 | 1 |  | 2023-09-05 00:00:00 |  | C1
JANSSEN  [US] | 70033093STR3001 | FRANCE | Elena Meseguer | AG7-FR10005 | A1 | B1 | U1 | T3 | 102 | 1 | 1 |  | 2023-09-05 00:00:00 |  | C1
JANSSEN  [US] | 70033093STR3001 | FRANCE | Elena Meseguer | AG7-FR10005 | A1 | B1 | U1 | T4 | 151.2 | 1 | 1 |  | 2023-09-05 00:00:00 |  | C2
JANSSEN  [US] | 70033093STR3001 | FRANCE | Elena Meseguer | AG7-FR10005 | A1 | B1 | U1 | T5 | 46.7 | 1 | 1 |  | 2023-09-05 00:00:00
JANSSEN  [US] | 70033093STR3001 | FRANCE | Elena Meseguer | AG7-FR10005 | A1 | B1 | U1 | T6 | 5.720000000000001 | 1 | 1 |  | 2023-09-05 00:00:00
JANSSEN  [US] | 70033093STR3001 | FRANCE | Elena Meseguer | AG7-FR10005 | A1 | B1 | U1 | T7 | 400 | 1 | 1 |  | 2023-09-05 00:00:00 |  | C2
Spreadsheet: 887030d1737117940-pulling-a-list-of-values-based-on-two-conditions-spesifikasyon-ogecen-
Sheet: Sheet1

18 | Etiket Hatası (Ters, Kaymış, Yanlış) | [NAME] | Minor
19 | Barkod Etiket Hatası | [NAME] | Critical
20 | Eğri (Kafa, Boyun, Gövde) | Curve (Finis, Neck, Body) | Minor
21 | Göçük | [NAME] | Minor
22 | Şiş Gövde/ Geniş çap | Bulged sides | Major
23 | Dip Oturmazlığı | Rocker bottom | Major
24 | Kontaminasyon | Contamination | Critical
25 | [NAME] baskısı | Indistiınct serigraphy | Minor
26 | Menteşe kopması | Hinge break | Major
27 | Ezik | Crushed | Major
28 | Şekil dışı | Freaks | Critical
29 | [NAME] | Wounded mold | Major
30 | [NAME] | Lock failure | Major
31 | [NAME] | [NAME] isagreement | Major
32 | [NAME] | Mold sweating | Minor
Spreadsheet: 67062129-cf4f-4d7b-a507-5e305efdaf02
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
LEU | Test | LEU | Fecal Leukocytes | Fecal Leukocytes | Microscopic Includes trichrome stain. | Stool Container: Stool |  |  |  | Varies | Container/Tube:  Preferred: ECOFIX preservative (Supply T219) Acceptable: PVA preservative Specimen Volume: Representative portion of collection Collection Instructions:  1. Collect a random stool specimen. 2. Carefully follow instructions on container. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Interpretive report | Monday through Saturday; Varies | 1 day | 2 days | 1 | 89055 |  |  |  |  | Rochester
LEU | [NAME] | FECAL | Fecal |  |  |  | Ambient | 21 days
LEU | Order Question | Q00M0034 | [NAME] |  | Plain Text
LEU | Result | LEU | Fecal Leukocytes | Fecal Leukocytes | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 50173d1249561805-creating-a-template-printing-page-or-a-clever-way-of-copying-linked-cells-print-book
Sheet: CSV

Sales Record Number | User Id | [NAME] name | [NAME] Number | [NAME] | Buyer Address 1 | Buyer Address 2 | Buyer Town/City | Buyer County | [NAME] | Buyer Country | Item Number | [NAME] | Custom Label | Quantity | Sale Price | Included VAT Rate | Postage and Packaging | Insurance | Cash on delivery fee | Total Price | Payment Method | Sale Date | Checkout Date | Paid on Date | Dispatch Date | Invoice date | Invoice number | Feedback left | Feedback received | Notes to yourself | PayPal Transaction ID | Postage Service | Cash on delivery option | Transaction ID | Order ID | Variation Details |  |  | POST CODE UPPER | Country UPPER
 |  | E.g. [NAME] |  |  | E.G. Address 1 | E.G. Address 2 | E.G. Town | E.G. County | E.G. Postcode | E.G. Country |  | E.G. title |  | 1 | 10 |  | 1 | 0 |  | 8 | PayPal | 2009-07-27 00:00:00 | 2009-07-27 00:00:00 | 2009-07-27 00:00:00 |  |  |  | No |  |  | 5CW74184B2707383M | Royal Mail 1st Class Standard |  | 338893747003 |  |  |  |  | E.G. POSTCODE | E.G. COUNTRY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  | 6.5 | PayPal | 2009-07-27 00:00:00 | 2009-07-28 00:00:00 | 2009-07-28 00:00:00 |  |  |  | No |  |  | 3L856972R7787341D | Royal Mail 1st Class Standard |  | 338909581003
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  | 17.15 | PayPal | 2009-07-27 00:00:00 | 2009-07-27 00:00:00 | 2009-07-27 00:00:00 |  |  |  | No |  |  | 56V357384H299370J | Royal Mail 1st Class Standard |  | 344965088004
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  | 15.5 | PayPal | 2009-07-27 00:00:00 | 2009-07-27 00:00:00 | 2009-07-27 00:00:00 |  |  |  | No |  |  | 42R04391JU112904H | Royal Mail 1st Class Standard |  | 344976077004
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  | 15.5 | PayPal | 2009-07-27 00:00:00 | 2009-07-27 00:00:00 | 2009-07-27 00:00:00 |  |  |  | No |  |  | 5Y9182563R8279114 | Royal Mail 1st Class Standard |  | 344995693004
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  | 17.75 | PayPal | 2009-07-27 00:00:00 | 2009-07-27 00:00:00 | 2009-07-27 00:00:00 |  |  |  | No |  |  | 2L046818K8693811G | Royal Mail 1st Class Standard |  | 339017206003
Spreadsheet: 7de0f172-9a22-472e-96c8-90fbd8f5ba1a
Sheet: Sheet1

UNIVERSITIES POOL COUNCIL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
MASTERS CHAMPIONSHIP 2006-2007
Preliminary Round
[NAME] (ENG) [Holder] | v | bye
[NAME] (ENG) | v | Anesh [NAME] (ENG) | 2 | 3
[NAME] (SCO) | v | bye
[NAME] (ENG) | v | [NAME] (ENG) | 1 | 3
[NAME] (ENG) | v | bye
[NAME] (ENG) | v | [NAME] (SCO) | 3 | 0
[NAME] (WAL) | v | bye
[NAME] (WAL) | v | [NAME] (ENG) | 0 | 3
[NAME] (ENG) | v | bye
Rhys Davies (WAL) | v | [NAME] (WAL) | 0 | 3
[NAME] (SCO) | v | bye
[NAME] (SCO) | v | [NAME] (SCO) | 3 | 1
[NAME] (SCO) | v | bye
[NAME] (SCO) | v | [NAME] (WAL) | 3 | 0
[NAME] (ENG) | v | bye
[NAME] (WAL) | v | [NAME] (ENG) | 2 | 3
Last 16 Round
[NAME] (ENG) [Holder] | v | Anesh [NAME] (ENG) | 3 | 1
[NAME] (SCO) | v | [NAME] (WAL) | 3 | 1
[NAME] (WAL) | v | [NAME] (ENG) | 0 | 3
[NAME] (WAL) | v | [NAME] (ENG) | 3 | 1
[NAME] (ENG) | v | [NAME] (WAL) | 2 | 3
[NAME] (SCO) | v | [NAME] (SCO) | 0 | 3
[NAME] (SCO) | v | [NAME] (SCO) | 3 | 1
[NAME] (ENG) | v | [NAME] (ENG) | 3 | 1
Quarter-finals
[NAME] (ENG) [Holder] | v | [NAME] (SCO) | 1 | 3
[NAME] (ENG) | v | [NAME] (WAL) | 3 | 1
[NAME] (WAL) | v | [NAME] (SCO) | 0 | 3
[NAME] (SCO) | v | [NAME] (ENG) | 2 | 3
Semi-finals
[NAME] (SCO) | v | [NAME] (ENG) | 3 | 2
[NAME] (SCO) | v | [NAME] (ENG) | 3 | 1
FINAL
[NAME] (SCO) | v | [NAME] (SCO) | 4 | 3