tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 34059d1231175825-summing-two-columns-with-conditions-test-file
Sheet: Sheet2

INSTALLED | Serial | Region | FSE | Install Date Complete | Power Assessment Date Complete | Days Since Install of P&A Form Completion | Power Assessment Form Rec'd Yes/No | FMI 15094 Yes/No
Y | E2-0502 | 6235 | MARSH MURDOCH | 2008-09-08 00:00:00 | 2008-11-25 00:00:00 | 78 | Yes | Yes
Y | E9-0513 | 6265 | OSCAR LIMPRICH | 2008-09-08 00:00:00 | 2008-09-12 00:00:00 | 4 | Yes | Yes
Y | ES-0530 | 6245 | [NAME] | 2008-09-08 00:00:00 | 2008-10-28 00:00:00 | 50 | Yes | Yes
Y | E9-0557 | 6245 | [NAME] | 2008-09-08 00:00:00 | 2008-12-08 00:00:00 | 91 | Yes | Yes
Y | E9-0538 | 6265 | MITCH DALBY | 2008-09-09 00:00:00 | 2008-09-09 00:00:00 | 0 | Yes | Yes
Y | ES-0522 | 6255 | [NAME] | 2008-09-09 00:00:00 | 2008-10-28 00:00:00 | 49 | Yes | Yes
Y | E2-0526 | 6235 | [NAME] | 2008-09-09 00:00:00 | 2008-12-08 00:00:00 | 90 | Yes | Yes
Y | E9-0478 | 6235 | RICH WITKOWSKI | 2008-09-09 00:00:00 | 2008-12-01 00:00:00 | 83 | Yes | Yes
Y | E9-0554 | 6265 | [NAME] | 2008-09-10 00:00:00 | 2008-09-09 00:00:00 | -1 | Yes | Yes
Y | ES-0214 | 6245 | [NAME] | 2008-09-10 00:00:00 | 2008-09-10 00:00:00 | 0 | Yes | Yes
Y | E2-0512 | 6245 | GENE REED | 2008-09-11 00:00:00 | 2008-12-02 00:00:00 | 82 | Yes | Yes
Y | E2-0541 | 6245 | [NAME] | 2008-09-12 00:00:00 | 2008-11-10 00:00:00 | 59 | Yes | Yes
Y | ES-0247 | 6245 | JAY GUIZAR | 2008-09-12 00:00:00 | 2008-09-12 00:00:00 | 0 | Yes | Yes
Y | E9-0515 | 6255 | TRENT REICHARDT | 2008-09-12 00:00:00 | 2008-12-12 00:00:00 | 91 | Yes | Yes
Y | E2-0388 | 6255 | [NAME] | 2008-09-12 00:00:00 | 2008-12-04 00:00:00 | 83 | Yes | Yes
Y | E2-0540 | 6265 | [NAME] | 2008-09-12 00:00:00 | 2008-11-10 00:00:00 | 59 | Yes | Yes
Y | E9-0468 | 6265 | [NAME] | 2008-09-13 00:00:00 | 2008-12-09 00:00:00 | 87 | Yes | Yes
Y | ES-0553 | 6236 | [NAME] | 2008-09-15 00:00:00 | 2008-09-15 00:00:00 | 0 | Yes | Yes
Y | ES-0187 | 6255 | [NAME] | 2008-09-16 00:00:00 | #N/A | #N/A | No | Yes
Y | E9-0563 | 6265 | ANDY AUPIU | 2008-09-17 00:00:00 | #N/A | #N/A | No | Yes
Y | E9-0562 | 6255 | [NAME] | 2008-09-17 00:00:00 | #N/A | #N/A | No | Yes
Y | E9-0534 | 6236 | [NAME] | 2008-09-18 00:00:00 | 2008-12-08 00:00:00 | 81 | Yes | Yes
Y | E9-0506 | 6245 | JIM SPILLMAN | 2008-09-19 00:00:00 | 2008-12-11 00:00:00 | 83 | Yes | Yes
 | 23
Spreadsheet: a382e70e-98b5-432c-924c-3914ce0005b7
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
PFR | Test | PFR | Porphyrins, Fractionation, [NAME] | Porphyrins, Fractionation | Only orderable as part of a reflex test. For further information see PEE/88886 [NAME], Erythrocytes. |  |  |  |  |  | Only orderable as part of a reflex test. For further information see PEE/88886 [NAME], Erythrocytes. | Whole blood: 3 mL Washed & resus |  | Only orderable as part of a reflex test. For further information see PEE/88886 [NAME], Erythrocytes. | Monday through Friday; 8 a.m. | 2 days (not reported on Saturday or Sunday) | 3 days | 1 | 82492 |  |  |  |  | Rochester
PFR | [NAME] | WRBC | Washed RBC |  |  |  | Frozen | 21 days
PFR | Result | 2340 | Uroporphyrin | Uroporphyrin | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 14180-4
PFR | Result | 2341 | Heptacarboxyl Porphyrins | Heptacarboxyl Porphyrins | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 9446-6
PFR | Result | 2346 | Hexacarboxyl Porphyrins | Hexacarboxyl Porphyrins | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 16963-1
PFR | Result | 2347 | Pentacarboxyl Porphyrins | Pentacarboxyl Porphyrins | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 18250-1
PFR | Result | 2329 | Coproporphyrin | Coproporphyrin | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 18257-6
PFR | Result | 2328 | Protoporphyrin | Protoporphyrin | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 2896-9
PFR | Result | 29355 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
Spreadsheet: 762493d1641577292-lookup-multiple-criteria-multiple-results-excel-q
Sheet: Phoenix_P5

Phoenix Centralized Training ASC office
Zone | Attendees | Global ID | Position | [NAME] | Needs Room | RoomNight
[NAME] | [NAME] |  |  |  |  |  | Confirmed room
Phoenix | Nikki Ridenour |  | FTM | M |  | No
 | [NAME] |  | FTM | L |  | No
 | Jorge Estrada Valdes |  |  | L
Tucson | [NAME] |  | CSS | Large | Y
 | [NAME] | 71098502 | FTM |  |  |  |  | 71098502
El Paso
 | [NAME] | 80051540 | RSA | XL | Y | 2
 | Narciso Quinonez |  | CSS | L | Y | 2
 | [NAME]
Spreadsheet: 788087d1658259110-implementing-a-few-restrictions-on-a-calendar-excel-shared-prototype-1
Sheet: September

 | Absence Type Key | V | Vacation |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 | September | Dates of Absence
 | Employee Name | 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 | Total Days
 | Employee 1
 | Employee 2
 | Employee 3
 | Employee 4
 | Employee 5
Spreadsheet: b2884b65-ecfa-4b52-aa88-c1fbb0f51496
Sheet: Departamentos

E L   S A L V A D O R
CENSO DE POBLACIÓN Y VIVIENDA - 2007
HOGARES CON SUMINISTRO DE AGUA
MUNICIPIO | TOTAL HOGARES | CAÑERIA DENTRO DE LA VIVIENDA | CAÑERIA FUERA DE LA VIVIENDA PERO DENTRO DE LA PROPIEDAD | CAÑERIA DEL VECINO | PILA O CHORRO PUBLICO | POZO PUBLICO | POZO PRIVADO | CAMION, CARRETA O PIPA | OJO DE AGUA, RIO O QUEBRADA | AGUA LLUVIA | OTRO
TOTAL PAÍS | 1406485 | 799583 | 243044 | 48750 | 54393 | 37894 | 109763 | 28472 | 63883 | 6854 | 13849
Ahuachapán | 72371 | 22131 | 25860 | 4942 | 2791 | 1942 | 6214 | 1285 | 5596 | 98 | 1512
Santa Ana | 132378 | 82138 | 19627 | 3952 | 4016 | 3117 | 6480 | 6514 | 3761 | 1501 | 1272
Sonsonate | 102357 | 45539 | 24663 | 4202 | 4006 | 2582 | 10801 | 802 | 8322 | 263 | 1177
Chalatenango | 45001 | 24869 | 7813 | 1056 | 821 | 1862 | 5052 | 27 | 2862 | 34 | 605
La Libertad | 162129 | 102825 | 23638 | 3892 | 6724 | 3861 | 8324 | 1392 | 8691 | 1369 | 1413
San Salvador | 410096 | 341220 | 28891 | 4500 | 12623 | 1875 | 5659 | 8684 | 4468 | 596 | 1580
Cuscatlán | 51471 | 22588 | 11685 | 3472 | 4348 | 1156 | 1928 | 1249 | 4472 | 53 | 520
La Paz | 74426 | 25882 | 14936 | 4531 | 5329 | 2898 | 14420 | 856 | 4423 | 47 | 1104
Cabañas | 31053 | 15521 | 3174 | 1036 | 1819 | 2236 | 2473 | 218 | 4341 | 31 | 204
San Vicente | 37897 | 14372 | 9668 | 2956 | 2584 | 2031 | 2545 | 847 | 2246 | 48 | 600
Usulután | 84076 | 23445 | 25968 | 5692 | 4419 | 2944 | 16650 | 1280 | 1832 | 518 | 1328
[NAME] | 106452 | 50172 | 21383 | 3998 | 2027 | 4396 | 13681 | 4164 | 3363 | 2079 | 1189
Morazán | 39682 | 10507 | 13599 | 2123 | 626 | 2466 | 4239 | 345 | 5163 | 59 | 555
La Unión | 57096 | 18374 | 12139 | 2398 | 2260 | 4528 | 11297 | 809 | 4343 | 158 | 790
FUENTE: DIGESTYC - VI CENSO DE POBLACIÓN Y V DE VIVIENDA
Spreadsheet: 122652d1317047095-multiple-transpose-function-from-rows-into-columns-book1
Sheet: Sheet2

 | 1
 | 2
 | 3
Spreadsheet: 872074d1718434227-how-to-cf-a-cell-and-the-one-directly-above-it-forum-cf-two-cells
Sheet: Sheet1

 | 2024-05-05 00:00:00 |  |  |  |  | 2024-05-06 00:00:00 | 2024-06-12 00:00:00 | 2024-06-12 00:00:00
 | True | False | False | False | False | True | True | True
 |  | 2024-05-06 00:00:00 | 2024-05-06 00:00:00
 | False | True | True | False | False | False | False | False
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: RELIG

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | [NAME] | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
1 | RELIG 100 | 1 | X | 1 | X | 1 | 2 | 1 | 1 | 1
1 | RELIG 101 | 1 | X | 1 | X | 1 | 2 | 1 | 1 | 1
4 | RELIG 101H | 1 | X | 1 | X | 1
5 | RELIG 110 | 1
1 | RELIG 135 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
5 | RELIG 175 | 1
5 | RELIG 176 | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 799444d1665085050-count-and-numbering-count1-1-
Sheet: Sheet1

 | count | range C4:C15 |  | expected result | result with a formula and CF |  | Result
 | 3 | 18 |  | 1
 | 2 | 3
 |  | 5
 | 5 | 4 |  | 2
 | 6 | 7
 | 7 |  |  | 3
 | 12 | 23 |  | 4
 | 11
 |  | 10
 | 10 |  |  | 5
 | 1
 | 25 | 12
Spreadsheet: 171049d1343599936-sum-of-products-by-number-of-days-book1
Sheet: Sheet1

Days | To | From | Products Produced | Every 22 Products Sum | # remaining
7 | 2012-07-01 00:00:00 | 2012-07-07 00:00:00
7 | 2012-07-08 00:00:00 | 2012-07-14 00:00:00 |  |  |  | <-- so here is would be "1" in Column E representing that 22 products are made and the remaining would be 13.3 in colum F
7 | 2012-07-15 00:00:00 | 2012-07-21 00:00:00
10 | 2012-07-22 00:00:00 | 2012-07-31 00:00:00
4 | 2012-08-01 00:00:00 | 2012-08-04 00:00:00
7 | 2012-08-05 00:00:00 | 2012-08-11 00:00:00
7 | 2012-08-12 00:00:00 | 2012-08-18 00:00:00
7 | 2012-08-19 00:00:00 | 2012-08-25 00:00:00
6 | 2012-08-26 00:00:00 | 2012-08-31 00:00:00
6 | 2012-09-01 00:00:00 | 2012-09-08 00:00:00
7 | 2012-09-09 00:00:00 | 2012-09-15 00:00:00
7 | 2012-09-16 00:00:00 | 2012-09-22 00:00:00
8 | 2012-09-23 00:00:00 | 2012-09-30 00:00:00
6 | 2012-10-01 00:00:00 | 2012-10-06 00:00:00
7 | 2012-10-07 00:00:00 | 2012-10-13 00:00:00
7 | 2012-10-14 00:00:00 | 2012-10-20 00:00:00
7 | 2012-10-21 00:00:00 | 2012-10-27 00:00:00
4 | 2012-10-28 00:00:00 | 2012-10-31 00:00:00
10 | 2012-11-01 00:00:00 | 2012-11-10 00:00:00
7 | 2012-11-11 00:00:00 | 2012-11-17 00:00:00
5 | 2012-11-18 00:00:00 | 2012-11-24 00:00:00
6 | 2012-11-25 00:00:00 | 2012-11-30 00:00:00
8 | 2012-12-01 00:00:00 | 2012-12-08 00:00:00
7 | 2012-12-09 00:00:00 | 2012-12-15 00:00:00
7 | 2012-12-16 00:00:00 | 2012-12-22 00:00:00
6 | 2012-12-23 00:00:00 | 2012-12-31 00:00:00
5 | 2013-01-01 00:00:00 | 2013-01-05 00:00:00
7 | 2013-01-06 00:00:00 | 2013-01-12 00:00:00
7 | 2013-01-13 00:00:00 | 2013-01-19 00:00:00
7 | 2013-01-20 00:00:00 | 2013-01-26 00:00:00
5 | 2013-01-27 00:00:00 | 2013-01-31 00:00:00
9 | 2013-02-01 00:00:00 | 2013-02-09 00:00:00
7 | 2013-02-10 00:00:00 | 2013-02-16 00:00:00
7 | 2013-02-17 00:00:00 | 2013-02-23 00:00:00
5 | 2013-02-24 00:00:00 | 2013-02-28 00:00:00
9 | 2013-03-01 00:00:00 | 2013-03-09 00:00:00
7 | 2013-03-10 00:00:00 | 2013-03-16 00:00:00
7 | 2013-03-17 00:00:00 | 2013-03-23 00:00:00
8 | 2013-03-24 00:00:00 | 2013-03-31 00:00:00
6 | 2013-04-01 00:00:00 | 2013-04-06 00:00:00
7 | 2013-04-07 00:00:00 | 2013-04-13 00:00:00
7 | 2013-04-14 00:00:00 | 2013-04-20 00:00:00
10 | 2013-04-21 00:00:00 | 2013-04-30 00:00:00
11 | 2013-05-01 00:00:00 | 2013-05-11 00:00:00
7 | 2013-05-12 00:00:00 | 2013-05-18 00:00:00
7 | 2013-05-19 00:00:00 | 2013-05-25 00:00:00
6 | 2013-05-26 00:00:00 | 2013-05-31 00:00:00
Spreadsheet: f09f517f-48cc-4e81-be60-3f6921c900cf
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
44035976 | 2014-11-15 19:15:43 | ALLIES | 0 | 0 | 6 | 16722 | Yerone | 12503 | eastern | 1941-07-22 | 1941-07-22 | Lipovec | Lipovec
44050670 | 2014-11-16 17:48:24 | ALLIES | 1 | 6 | 5 | 959187 | 253117587 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
44051173 | 2014-11-16 18:14:47 | AXIS | 1 | 6 | 4 | 959187 | 253117587 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
Spreadsheet: 492975d1481377112-basic-increment-cell-reference-comp-book-template-2016-_-as
Sheet: TEMPLATE

ACCOUNT#: |  |  |  |  |  | SITUS:
PARCEL#: |  |  |  |  |  | CITY:
 |  |  |  |  |  | NBHD:
SALE DATE: |  |  |  |  |  | SUBDIVISION:
SALE PRICE:
 |  |  |  |  |  | ACRES:
 |  |  |  |  |  | YEAR BUILT:
 |  |  |  |  |  | HEATED AREA:
 |  |  |  |  |  | BATH:
 |  |  |  |  |  | BEDROOM:
 |  |  |  |  |  | STORIES:
ACCOUNT#: |  |  |  |  |  | SITUS:
PARCEL#: |  |  |  |  |  | CITY:
 |  |  |  |  |  | NBHD:
SALE DATE: |  |  |  |  |  | SUBDIVISION:
SALE PRICE:
 |  |  |  |  |  | ACRES:
 |  |  |  |  |  | YEAR BUILT:
 |  |  |  |  |  | HEATED AREA:
 |  |  |  |  |  | BATH:
 |  |  |  |  |  | BEDROOM:
 |  |  |  |  |  | STORIES:
Spreadsheet: 494350d1482337918-i-would-like-a-formula-to-return-the-closest-value-when-i-dont-have-an-exact-match-sample-vlookup
Sheet: Sheet1

 | 500 | 100 |  |  | 4001 | I would like 3999 and 4001 entered in F3 to both return 700
 | 1000 | 200
 | 1500 | 300
 | 2000 | 400
 | 2500 | 500
 | 3000 | 600
 | 3500 | 700
 | 4000 | 800
 | 4500 | 900
 | 5000 | 1000
 | 5500 | 1100
 | 6000 | 1200
 | 6500 | 1300
 | 7000 | 1400
 | 7500 | 1500
 | 8000 | 1600
Spreadsheet: 134587d1325495822-how-to-associate-cell-contents-with-other-cells-sample-8-
Sheet: Sheet1

ID | Group | Date | Collected | Tank | N | P | SE | SL | Notes | W1 | [NAME] | W3
SH11 |  | 15/12/2011 |  |  | 200 | 0 | 2 | 3
SB19 |  | 15/12/2011 |  |  | 100 | 0 | 6 | 7
SH6 |  | 15/12/2011 |  |  | 125 | 0 | 7 | 8
SH9 |  | 15/12/2011 |  |  | 200 | 0 | 7 | 8
SB20 |  | 15/12/2011 |  |  | 240 | 10 | 7 | 8
SB21 |  | 15/12/2011 |  |  | 230 | 0 | 8 | 8
SB25 |  | 15/12/2011 |  |  | 150 | 5 | 6 | 7
SB27 |  | 15/12/2011 |  |  | 160 | 0 | 7 | 8
SB24 |  | 15/12/2011 |  |  | 150 | 0 | 5 | 6
SB24 |  | 21/12/2011 |  |  | 20 | 20 | 7 | 8
SB20 |  | 21/12/2011 |  |  | 40 | 10 | 7 | 8
Spreadsheet: 6f32d256-28ca-45ff-9669-efd40e4efa0e
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Bilverksteder
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Best (Gressvik Service Senter) | Storv. 5 | 1624 | Gressvik | 911 85 005 | 69 32 84 30
Bjørnars Auto | Grunnfjord | 9130 | Hansnes | 77 74 84 44 | 77 74 84 66
Norsk Kjøretøykontroll AS | Ulefossv. 20 | 3730 | Skien | 35 52 26 60 | 35 53 35 32
[NAME] A/S | Merkurv. 1 | 7652 | Verdal | 74 04 90 00
Florø Bil & Havneservice AS | Strandav. 19 | 6900 | Florø | 57 74 05 30 | 57 74 05 31
[NAME] | [NAME]. 4 | 7670 | Inderøy | 74 15 60 60 | 74 15 60 61
Ernstsen MC & Scooter AS | Lagerv. 7 | 8250 | [NAME] | 75 69 46 76
Bilkilden AS | Torgv. 15 | 4016 | Stavanger | 51 82 70 00 | 51 58 48 48
Tau Auto AS | Ryfylkev. 1970 | 4120 | Tau | 51 74 65 90
[NAME] og Tuning AS | Gamle Isevei 59 | 1738 | Borgenhaugen | 476 77 399
Skattøra Bil & Lakk AS | Ringv. 17 | 9018 | Tromsø | 77 60 62 10 | 77 60 62 11
Holmen Motorservice AS | [NAME]. 8 | 2500 | Tynset | 62 48 09 80
Bjørn Myhrens Verksted AS |  | 7250 | Melandsjø | 72 44 49 30 | 72 44 49 31
[NAME] (Hagen Bilservice AS) | Industriv. 40 | 2680 | Vågå | 61 23 79 50 | 61 23 21 61
[NAME] | Dikterv. 8 | 5538 | Haugesund | 52 70 60 00
[NAME] | [NAME]. 2B | 4700 | Vennesla | 38 13 94 01
Bil Body AS | Gate 1 nr 1 | 6700 | [NAME] | 57 85 05 34 | 57 85 06 74
[NAME] | [NAME]. 9 | 3550 | Gol | 32 07 60 30 | 32 07 60 19
[NAME] avd Årnes | [NAME]. 15A | 2150 | Årnes | 63 90 06 20 | 63 90 06 21
Sandberg Auto AS | Løxav. 5 | 1351 | Rud | 67 17 22 00 | 67 17 22 01
Fosnavåg Bilverksted AS |  | 6092 | Fosnavåg | 70 08 16 00 | 70 08 92 92
Bil og Mekaniske AS | Blindheim | 6040 | [NAME] | 70 18 36 35
Vest Bilskadesenter | Briskev. 17 | 3229 | Sandefjord | 33 46 09 00
Diesel-Elektro AS | Halbrendslia 24 | 6814 | [NAME] | 57 82 21 77
Engeland Skade & Lakk | Sagmyra 19 | 4624 | Kristiansand | 958 35 000
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 864327d1711545235-how-can-i-enhance-this-sumproduct-formula-to-only-counts-cells-greater-than-zero-sumproduct-question
Sheet: SUMPRODUCT Question

Year | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2025 | 2025 | 2025 | 2025
Month | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00
Users | 25 |  | 26 | 21 | 29 | 34 | 33 | 35 | 31 | 27 | 27 | 25 | 23 | 22 | 27 | 29 | 31
Hours | 501 |  | 612 | 574 | 773 | 809 | 768 | 811 | 809 | 639 | 622 | 611 | 634 | 620 | 799 | 632 | 733
Avg of Monthly Hours
Year Selected ([NAME]) | 2024
Spreadsheet: 824361d1680525904-summary-of-timsesheets-tabs-john-timesheet-test
Sheet: W02

 | Name |  |  | Company |  | Week Nr. | From |  |  | Period Nr. | Till
 | [NAME] |  |  | HUB |  | 2
 | Project No. |  |  | Description | Mon | Tue | Wed | Thu | Fri | Sat | Total | Travel I | Travel II
 | 202202 |  |  | Job BBB | 2 | 3 | 5 |  | 1
 | 202301 |  |  | Job CCC |  | 5 | 1 | 6
 | General
 | Holiday
 | National Holiday
 | Leave on own account
 | Illness
 | Signature Client Representative: |  |  |  |  |  |  |  | Total
 | Date:
 | Day | Month | Year
 |  |  | 2023
Spreadsheet: 739104d1625511368-macro-to-compare-references-and-values-and-extract-items-not-matching-to-a-seperate-sheet-macro-to-compare-ref-numbers-and-extract-items-that-do-not-match
Sheet: Manual Recon

Purchase.Reference | Purchase.Date Processed | Purchase.Balance |  | Reference | Date Processed | Balance
9285 | 03-MAY-2021 | 411.21 |  | 9285 | 2021-05-03 00:00:00 | 411.21
9290 | 03-MAY-2021 | 198.09 |  | 9290 | 2021-05-03 00:00:00 | 198.09
9305 | 03-MAY-2021 | 38.89 |  | 9305 | 2021-05-03 00:00:00 | 38.89
9320 | 04-MAY-2021 | 365.44 |  | 9320 | 2021-05-04 00:00:00 | 365.44
9321 | 05-MAY-2021 | 1046.95 |  | 9321 | 2021-05-05 00:00:00 | 1046.95
9327 | 05-MAY-2021 | 910.47 |  | 9327 | 2021-05-05 00:00:00 | 910.47
9334 | 06-MAY-2021 | 150.53 |  | 9334 | 2021-05-06 00:00:00 | 150.53
9338 | 06-MAY-2021 | 1225.6 |  | 9338 | 2021-05-06 00:00:00 | 1225.6
634985 | 03-MAY-2021 | 620.75 |  | 634985 | 2021-05-03 00:00:00 | 620.75
634654 | 03-MAY-2021 | 400.35 |  | 634654 | 2021-05-03 00:00:00 | 400.35
9285 | 03-MAY-2021 | 415.75 |  | 9285 | 2021-05-03 00:00:00 | 415.75
635080 | 06-MAY-2021 | 88.5 |  | 635080 | 2021-05-06 00:00:00 | 88.5
634958 | 03-MAY-2021 | 705.65 |  | 634958 | 2021-05-03 00:00:00 | 705.65
635146 | 03-MAY-2021 | 730.25 |  | 635146 | 2021-05-03 00:00:00 | 730.25
635196 | 06-MAY-2021 | 801.75 |  | 635196 | 2021-05-06 00:00:00 | 801.75
Spreadsheet: 842844d1694820390-feed-single-array-via-vstack-and-reduce-issue-extract-values-solution-
Sheet: Feuil1

ID;PST||ee;gg||ff;20
aa;PST||Puy;gg||Primary;20 |  |  | alternative solution |  | test |  | EXPECTED RESULT (spilling array)
bb;PST||Puy;gg||Secondary;20 |  |  |  |  |  |  | ID
 |  |  | ee |  | ee |  | ee
 |  |  | ff |  | ff |  | ff
 |  |  | aa |  | aa |  | aa
 |  |  | Puy |  | Puy |  | Puy
 |  |  | Primary |  | Primary |  | Primary
 |  |  | bb |  | bb |  | bb
 |  |  | Puy |  | Puy |  | Puy
 |  |  | Secondary |  | Secondary |  | Secondary
Spreadsheet: 29065d1223800652-return-majority-value-in-cell-test
Sheet: test

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Count Majority | Majority
I | B | B | B | B | I | B | B | I | I | 4 | Should Return "B"
M | M | M | M | M | M | M | M | M | M | 10 | "M"
N | N | N | N | O | N | N | N | N | N | 9 | "N"
N | N | N | N | N | N | N | N | N | N | 10 | "N"
C | A | A | A | C | C | C | C | C | C | 7
T | C | C | T | C | T | C | C | C | C | 3
W | W | W | W | W | W | W | W | W | W | 10
H | H | H | H | H | M | H | H | H | M | 8
D | D | D | D | D | D | D | D | D | D | 10
S | P | P | P | P | P | P | P | P | P | 1
S | G | G | G | G | G | G | G | G | G | 1
D | D | A | A | D | D | A | A | D | D | 6
S | N | S | N | S | S | S | S | S | S | 8
N | N | N |  | N | N | C | N | N | N | 8
Spreadsheet: 214116d1360804909-workday-function-and-conditional-formatting-release
Sheet: Sheet1

How to make these ?
Sample Delivery | Material Description | Days of Analysis | Release
2013-02-10 00:00:00 | A | 3 |  | when it release on Saturday and Sunday , it will be change automatically to Monday.
2013-02-11 00:00:00 | B | 2
2013-02-12 00:00:00 | C | 1
2013-02-13 00:00:00 | A | 3
2013-02-14 00:00:00 | B | 2
2013-02-15 00:00:00 | C | 1
2013-02-16 00:00:00 | C | 1
2013-02-17 00:00:00 | B | 2
2013-02-18 00:00:00 | A | 3
2013-02-19 00:00:00 | A | 3
Sample Delivery | Material Description | Days of Analysis | Release
2013-02-10 00:00:00 | A | 3 |  | When it's time to release today, the cell will be fill with red colour automatically
2013-02-11 00:00:00 | B | 2
2013-02-12 00:00:00 | C | 1
2013-02-13 00:00:00 | A | 3
2013-02-14 00:00:00 | B | 2
2013-02-15 00:00:00 | C | 1
2013-02-16 00:00:00 | C | 1
2013-02-17 00:00:00 | B | 2
2013-02-18 00:00:00 | A | 3
2013-02-19 00:00:00 | A | 3
Spreadsheet: 45708e5c-eae2-4002-a608-c2894bbb812a
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
10/05/2013 | Rifle | Ohio State | W, 4657-4648
10/13/2013 | Rifle | at Nebraska* | W, 4656-4650
10/26/2013 | Rifle | Army* | W, 4695-4669
11/02/2013 | Rifle | Mississippi* | W, 4681-4614
11/03/2013 | Rifle | Akron | W, 4690-4605
11/16/2013 | Rifle | at Navy* | W, 4678-4627
01/19/2014 | Rifle | [NAME]* | All Day
01/24/2014 | Rifle | at Winthrow Invitational (Murray, Ky.) | All Day
01/25/2014 | Rifle | at Memphis* | All Day
02/06/2014 | Rifle | Alaska-Fairbanks | All Day
02/08/2014 | Rifle | Kentucky* | All Day
[NAME] | Rifle | [NAME] (Murray, Ky.) | All Day
03/01/2014 | Rifle | GARC Championships (Oxford, Miss.) | All Day
03/02/2014 | Rifle | GARC Championships (Oxford, Miss.) | All Day
03/14/2014 | Rifle | [NAME] (Murray, Ky.) | All Day
03/15/2014 | Rifle | [NAME] (Murray, Ky.) | All Day
Spreadsheet: 27028cf3-90ca-46c0-a0f6-86a246da2097
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
RMALA | Test | RMALA | Id MALDI-TOF Mass Spec Anaerobe | Id MALDI-TOF Mass Spec Anaerobe |  |  |  |  |  | mL | **For billing purposes only |  |  |  |  |  |  | 1 | 87076 |  |  |  |  | Rochester
RMALA | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 811824d1672822680-resource-allocation-based-on-week-numbers-resource-allocation-1-ans
Sheet: Sheet1

Status | Name | Start date | Weeks in total | Week number | Week number | Week number | Week number | Week number | Week number
Active | Name 1 | 2023-01-01 00:00:00 | 2 |  | 2
Active | Name 2 | 2023-02-02 00:00:00 | 4 |  | 7 | 8 | 9
Active | Name 3 | 2023-03-03 00:00:00 | 3 |  | 11 | 12
Active | Name 4 | 2023-04-04 00:00:00 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 4
Spreadsheet: joe_parks__14984__bridgeline 5-21
Sheet: Sheet1

b/s | contract | price | volume | time | cm | account | cti | order # | trader | reference | trade #
B | NGM2 | 3426 | 35 | 08:49:08 | 905 | 97563 | 4C | 2036 | amk | EO-2036 | 2104 | 0 | N
B | NGM2 | 3435 | 15 | 07:58:38 | 905 | 97563 | 4C | 2035 | amk | EO-2035 | 1868 | 0 | N
B | NGM2 | 3447 | 15 | 16:56:24 | 905 | 97563 | 4C | 2029 | amk | EO-2029 | 602 | 0 | Y
S | NGV2 | 3670 | 15 | 15:17:01 | 905 | 97563 | 4C | 778 | ebc | EO-778 | 46 | 0 | Y