tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0dba874b-c63f-48cf-9ffc-73da54a4b38d
Sheet: 3.3

Table 3.3: Family composition by country, residence and year (percent)
Country | Census/Survey | Family compostion | Year | Urban | Rural | Total
Bahrain
 | Census |  | 2001
 |  | Living alone |  | … | … | 8.720087379604806
 |  | Nuclear family (father, mother and children) |  | … | … | 62.92721676099692
 |  | Extended family (nuclear family + relatives) |  | … | … | 22.99473736471056
 |  | Other |  | … | … | 5.357958494687717
Lebanon
 | Survey |  | 2004
 |  | Living alone |  | … | … | 72.90309849097619
 |  | Nuclear family (father, mother and children) |  | … | … | 26.67810804228541
 |  | Extended family (nuclear family + relatives) |  | … | … | 0.1772125898859344
 |  | Other |  | … | … | 0.2415808768524705
 | Survey |  | 2007
 |  | Living alone |  | … | … | 67.2
 |  | Nuclear family (father, mother and children) |  | … | … | 32.2
 |  | Extended family (nuclear family + relatives) |  | … | … | 0.2
 |  | Other |  | … | … | 0.4
Palestine
 | Survey |  | 2000
 |  | Living alone |  | … | … | 3.7
 |  | Nuclear family (father, mother and children) |  | … | … | 77.5
 |  | Extended family (nuclear family + relatives) |  | … | … | 18.6
 |  | Other |  | … | … | 0.2
 | Survey |  | 2006
 |  | Living alone |  | … | … | 3.5
 |  | Nuclear family (father, mother and children) |  | … | … | 78.1
 |  | Extended family (nuclear family + relatives) |  | … | … | 18.3
 |  | Other |  | … | … | 0.1
 | Survey |  | 2010
 |  | Living alone |  | … | … | 3.1
 |  | Nuclear family (father, mother and children) |  | … | … | 85.9
 |  | Extended family (nuclear family + relatives) |  | … | … | 11
 |  | Other |  | … | … | 0
Spreadsheet: hunter_shively__12534__west impact report
Sheet: west

 | PEPL |  |  |  |  |  |  |  | ANR
 |  | pipe | name | r/d/bi | capacity | mtr# |  |  |  | pipe | name | r/d/bi | capacity | mtr#
 |  | tw | sneed | r | 80000 | 07011 |  |  |  | tw | roberts red deer | bi | 45000 | 25935
 |  | cig | [NAME] | r | 185000 | 06204 |  |  |  | cig | beaver | bi | 150000 | 16454 | d
 |  |  | [NAME] | r | 65000 | 06235 |  |  |  |  |  |  |  | 16435 | r
 |  | kn | grant #1 | r | 50000 | 09223 |  |  | total receipts |  | 195000
 |  |  | aledo |  | 198000 | 06132
 |  |  |  |  |  |  |  |  | total deliveries |  | 195000
 |  | pony exp | pony exp | bi | 79000 | pnyex
 | total receipts |  | 657000 |  |  |  |  |  | NGPL
 |  |  |  |  |  |  |  |  |  | pipe | name | r/d/bi | capacity | mtr# | zone
 | total deliveries |  | 79000
 |  |  |  |  |  |  |  |  |  | trailblazer | gage | r | 725000 | 902900 | am
 | NNG |  |  |  |  |  |  |  |  | cig | [NAME] | r | 228000 | 905207 | mc
 |  | pipe | name | r/d/bi | capacity | mtr# | mid
 |  |  |  |  |  |  |  |  |  | kn | barton | r | 32000 | 5421 | mc
 |  | el paso | [NAME] | d | 180000 | 57100 | 3 |  |  |  | hemphill | r | 96000 | 903971 | mc
 |  |  | [NAME] | d | 80000 | 169 | 4
 |  |  | plains | d | 50000 | 2618 | 6 |  |  | tw | eddy | bi | 150000 | 903080 | p
 |  |  | dumas | r | 250000 | 186 | 10 |  |  |  | gray | r | 75000 |  | mc
 |  |  |  |  |  |  |  |  |  |  | hansford | r | 75000 |  | mc
 |  | tw | gray | bi | 40000 | 60667 | 8
 |  |  | linam ranch | bi | 50000 | 62960 | 5 |  |  | el paso | moore | r | 100000 | 3251 | mc
 |  |  | [NAME] | bi | 150000 | 60749 | 4 |  |  |  | parmer | d | 15000 | 5058 | p
 |  |  | ward | bi | 50000 | 1635 | 4 |  |  |  | [NAME] | r | 100000 | 3324 | p
 |  |  | beaver | r | 80000 | 3531 | 11 |  |  |  | jal | d | 393000 | 3083 | p
 |  |  |  |  |  |  |  |  |  |  | washita | r | 120000 |  | mc
 |  | cig | dumas | r | 150000 | 360 | 10
 |  |  | garden city | r | 80000 | 22966 | 15
 |  |  |  |  |  |  |  |  | total receipts |  | 1710000
 |  | kn | fillmore | d | 24000 | 210 | 17 abc
 |  |  |  |  |  |  |  |  | total deliveries |  | 558000
 |  | pony exp | tescott - pony exp | r | 70000 | 71214 | 16a
 |  | trailblazer | beatrice | r | 325000 | 1318 | 17 abc
 | total receipts |  | 955000
 | total deliveries |  | 624000
 | VARIABLE COSTS
 | El Paso Permian to M/C |  |  | .04 - .05
 | TW Central & Panhandle Pool to M/C |  |  | .04 - .05
 | CIG to M/C |  |  | 0.095
 | Trailblazer to M/C |  |  | 0.005
Spreadsheet: 790442d1659707364-using-lookup-to-find-the-1st-2nd-3rd-and-4th-value-test-how-to-return-nth-value-in-lookup
Sheet: Sheet2

School name | Subject name | Price
St Marys School | Maths | 50
St Peters School | Maths | 50
London Free School | English | 15
St Pauls Academy | Science | 100
St Marys School | Science | 25
St Marys School | English | 75
St Pauls Academy | Maths | 25
St Pauls Academy | Science | 15
St Pauls Academy | English | 90
St Pauls Academy | History | 75
Spreadsheet: 53361d1253240726-calendar-and-buttons-3m-brookings
Sheet: Ethyl Acetate

Ethyl Acetate 99%
414 Lbs./Drum
[NAME]
Lot # | CB6033
PO | USMMMFR067
Rel. | 6 | 2009-06-01 00:00:00
Ethyl Acetate 99%
414 Lbs./Drum
[NAME]
Lot # | CB6033
PO | USMMMFR067
Rel. | 6 | 2009-06-01 00:00:00
Spreadsheet: 873570d1720075710-convert-customer-po-to-data-file-marumaru-po-to-data-aligw
Sheet: original po

 | PO-01 | PO-02 | PO-03 | PO-04 | PO-05
Item Number | Quantity | Quantity | Quantity | Quantity | Quantity
ab001 | 123 |  |  | 25
ab002 |  | 12 |  | 23 | 25
ab003 | 45 |  | 12 | 24
ab004 | 121 |  | 24 |  | 25
ab005 |  | 45 |  | 16
ab006 |  | 123 | 24 |  | 25
ab007 |  | 123 | 24
ab008 | 12 |  |  | 16
ab009 | 12 |  | 24 |  | 25
Spreadsheet: andy_zipper__648__11_21_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL F2 | 19 | 246 | 252 | 64.8 | 66.4 | 0.78 | 2001-11-21 14:43:00
 | CL G2 | 19 | 340 | 355 | 57.7 | 60.3 | 0.7 | 2001-11-21 14:43:00
 | CL H2 | 19.5 | 415 | 430 | 55.9 | 58 | 0.7 | 2001-11-21 14:43:00
 | CL J2 | 19.5 | 460 | 475 | 53.8 | 55.5 | 0.67 | 2001-11-21 14:43:00
 | CL K2 | 19.5 | 495 | 515 | 51.2 | 53.3 | 0.64 | 2001-11-21 14:43:00
 | CL M2 | 20 | 520 | 540 | 48.1 | 49.9 | 0.62 | 2001-11-21 14:43:00
 | CL N2 | 20 | 530 | 550 | 45.3 | 47 | 0.58 | 2001-11-21 14:43:00
 | CL Q2 | 20 | 535 | 555 | 42.9 | 44.5 | 0.55 | 2001-11-21 14:43:00
 | CL U2 | 20 | 540 | 560 | 41 | 42.5 | 0.52 | 2001-11-21 14:43:00
 | [NAME] | 20 | 550 | 575 | 39.6 | 41.4 | 0.51 | 2001-11-21 14:43:00
 | CL X2 | 20 | 555 | 580 | 38.3 | 40 | 0.49 | 2001-11-21 14:43:00
 | [NAME] | 20.5 | 555 | 585 | 35.9 | 37.9 | 0.48 | 2001-11-21 14:43:00
 | CL M3 | 21 | 570 | 600 | 30.1 | 31.7 | 0.41 | 2001-11-21 14:43:00
 | CL Z3 | 21 | 570 | 600 | 26.8 | 28.2 | 0.36 | 2001-11-21 14:43:00
 | CL M4 | 21.5 | 570 | 600 | 23.9 | 25.2 | 0.33 | 2001-11-21 14:43:00
Spreadsheet: 768494d1644999814-formula-for-column-to-auto-sum-sample
Sheet: Sheet1

1 | 2021-12-01 00:00:00 | Investment Profit |  | CREDIT |  |  |  | 0
2 | 2021-12-01 00:00:00 | Transfer | SELF | CREDIT
3 | 2021-12-01 00:00:00 | Salf Trade | Salf Trade | CREDIT
4 | 2021-12-01 00:00:00 | Initial Deposit | Gavin | CREDIT
5 | 2021-12-01 00:00:00 | Initial Deposit | [NAME] | CREDIT
6 | 2021-12-01 00:00:00 | Initial Deposit | Olivia | CREDIT
Spreadsheet: 857509d1706523241-formula-to-populate-row-with-days-of-the-month-npv
Sheet: Sheet1

2024-02-01 00:00:00
 | 2024-02-02 00:00:00 | 2024-02-03 00:00:00 | 2024-02-04 00:00:00 | 2024-02-05 00:00:00 | 2024-02-06 00:00:00 | 2024-02-07 00:00:00 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 | 2024-02-10 00:00:00 | 2024-02-11 00:00:00 | 2024-02-12 00:00:00 | 2024-02-13 00:00:00 | 2024-02-14 00:00:00 | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 2024-02-17 00:00:00 | 2024-02-18 00:00:00 | 2024-02-19 00:00:00 | 2024-02-20 00:00:00 | 2024-02-21 00:00:00 | 2024-02-22 00:00:00 | 2024-02-23 00:00:00 | 2024-02-24 00:00:00 | 2024-02-25 00:00:00 | 2024-02-26 00:00:00 | 2024-02-27 00:00:00 | 2024-02-28 00:00:00 | 2024-02-29 00:00:00
Spreadsheet: 88562d1288357231-calculating-days-with-workdays-workday-sheet
Sheet: Sheet1

Project number | Days to complete | Tentative start Date
Project #1 | 0.25 | 2010-03-15 00:00:00
Project #2 | 0.25 | 2010-03-15 00:00:00
Project #3 | 0.25 | 2010-03-15 00:00:00
Project #4 | 0.25 | 2010-03-15 00:00:00 |  |  |  |  |  | Holidays
Project #5 | 0.5 | 2010-03-15 00:00:00 |  |  |  |  |  | 2010-03-18 00:00:00
Project #6 | 0.5 | 2010-03-15 00:00:00 |  |  |  |  |  | 2010-03-23 00:00:00
Project #7 | 0.5 | 2010-03-15 00:00:00 |  |  |  |  |  | 2010-03-30 00:00:00
Project #8 | 0.5 | 2010-03-15 00:00:00
Project #9 | 1 | 2010-03-15 00:00:00
Project #10 | 1 | #N/A
Project #11 | 1 | #N/A
Project #12 | 1 | #N/A
Project #13 | 1 | #N/A
Project #14 | 2 | #N/A
Project #15 | 2 | #N/A
Project #16 | 2 | #N/A
Project #17 | 2 | #N/A
Project #18 | 0.5 | #N/A
Project #19 | 0.5 | #N/A
Project #20 | 0.5 | #N/A
Project #21 | 0.5 | #N/A
Project #22 | 0.25 | #N/A
Project #23 | 0.25
Project #24 | 0.25
Project #25 | 0.25
Project #26 | 0.33
Project #27 | 0.33
Project #28 | 0.33
Project #29 | 0.33
Project #30 | 0.33
Spreadsheet: d0c2824c-2c28-4d73-be5a-64d0bb2a2a57
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
[NAME] via ofícios em papel
UF | 2001 |  |  |  |  |  |  |  |  |  |  |  | Total
 | Jan | Fev | Mar | Abr | Mai | Jun | Jul | Ago | Set | Out | Nov | Dez
AC | 1 | 0 | 1 | 0 | 2 | 0 | 1 | 0 | 0 | 1 | 2 | 0 | 8
AL | 4 | 2 | 6 | 8 | 3 | 3 | 3 | 3 | 5 | 5 | 2 | 4 | 48
AM | 29 | 14 | 36 | 11 | 26 | 34 | 49 | 12 | 17 | 11 | 12 | 13 | 264
AP | 0 | 1 | 2 | 0 | 1 | 0 | 0 | 1 | 21 | 4 | 23 | 2 | 55
BA | 237 | 260 | 339 | 271 | 388 | 356 | 248 | 416 | 299 | 464 | 349 | 276 | 3903
CE | 20 | 18 | 43 | 38 | 40 | 34 | 22 | 24 | 26 | 22 | 18 | 17 | 322
DF | 26 | 30 | 45 | 40 | 40 | 32 | 37 | 25 | 69 | 55 | 50 | 38 | 487
ES | 84 | 34 | 39 | 65 | 60 | 75 | 48 | 52 | 46 | 46 | 66 | 23 | 638
GO | 115 | 86 | 226 | 168 | 180 | 156 | 131 | 92 | 158 | 161 | 111 | 126 | 1710
MA | 79 | 75 | 133 | 162 | 151 | 119 | 166 | 125 | 139 | 136 | 96 | 102 | 1483
MG | 346 | 334 | 678 | 402 | 536 | 435 | 428 | 557 | 542 | 474 | 545 | 430 | 5707
MS | 111 | 110 | 157 | 123 | 130 | 85 | 144 | 161 | 208 | 170 | 99 | 191 | 1689
MT | 2 | 3 | 5 | 6 | 8 | 9 | 13 | 7 | 11 | 4 | 2 | 7 | 77
PA | 99 | 89 | 98 | 88 | 136 | 126 | 108 | 92 | 105 | 117 | 102 | 88 | 1248
PB | 36 | 28 | 21 | 17 | 21 | 17 | 15 | 25 | 20 | 27 | 22 | 18 | 267
PE | 467 | 383 | 731 | 680 | 630 | 559 | 467 | 637 | 492 | 805 | 752 | 638 | 7241
PI | 7 | 15 | 8 | 4 | 8 | 3 | 18 | 15 | 19 | 10 | 5 | 12 | 124
PR | 279 | 191 | 372 | 275 | 466 | 253 | 348 | 289 | 431 | 381 | 332 | 204 | 3821
RJ | 417 | 314 | 416 | 305 | 376 | 283 | 454 | 514 | 461 | 373 | 177 | 455 | 4545
RN | 18 | 16 | 18 | 17 | 36 | 23 | 12 | 8 | 3 | 7 | 9 | 6 | 173
RO | 2 | 5 | 3 | 3 | 3 | 1 | 4 | 2 | 1 | 3 | 3 | 0 | 30
RR | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 5
RS | 363 | 392 | 754 | 585 | 714 | 558 | 505 | 653 | 915 | 797 | 606 | 664 | 7506
SC | 186 | 229 | 369 | 252 | 331 | 295 | 245 | 232 | 367 | 262 | 243 | 186 | 3197
SE | 0 | 1 | 2 | 2 | 2 | 4 | 5 | 2 | 2 | 0 | 1 | 2 | 23
SP | 2858 | 2493 | 3672 | 3618 | 3879 | 3411 | 4030 | 3841 | 2716 | 1441 | 1342 | 2696 | 35997
TO | 2 | 0 | 0 | 0 | 6 | 0 | 4 | 2 | 3 | 0 | 0 | 1 | 18
Total | 5788 | 5124 | 8174 | 7140 | 8174 | 6871 | 7505 | 7788 | 7076 | 5777 | 4970 | 6199 | 80586
Assunto | 2001 |  |  |  |  |  |  |  |  |  |  |  | Total
 | Jan | Fev | Mar | Abr | Mai | Jun | Jul | Ago | Set | Out | Nov | Dez
BL | 1498 | 1228 | 1950 | 1734 | 2066 | 1442 | 1445 | 1397 | 1782 | 1685 | 1396 | 1323 | 18946
DB | 154 | 170 | 245 | 189 | 202 | 257 | 219 | 203 | 206 | 233 | 199 | 351 | 2628
FL | 127 | 43 | 117 | 56 | 76 | 92 | 70 | 58 | 78 | 45 | 35 | 48 | 845
EF | 7 | 6 | 0 | 6 | 2 | 5 | 5 | 5 | 4 | 2 | 1 | 4 | 47
SI | 4002 | 3677 | 5862 | 5155 | 5828 | 5075 | 5766 | 6125 | 5006 | 3812 | 3339 | 4473 | 58120
Total | 5788 | 5124 | 8174 | 7140 | 8174 | 6871 | 7505 | 7788 | 7076 | 5777 | 4970 | 6199 | 80586
BL | --> | Bloqueio
DB | --> | Desbloqueio
FL | --> | Comunicação de Falência
EF | --> | Comunicação de Extinção de Falência
SI | --> | Solicitação de Informações
Spreadsheet: 490551d1479919078-calculate-the-payment-on-tow-stage-book1
Sheet: Sheet2

 | Namber of Month | 6
 | Total monthly pay |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
NO | Name | Monthly Pay | Number of Pay Bake | Total Pay for 60 Month |  | 2016-12-01 00:00:00
1 | Person 1 | 300 | 1 |  |  |  | 0 | 0 | 0 | 0 | 0
2 | Person 2 | 800 | 1 |  |  | 2000 | 2800 | 0 | 0 | 0 | 0
3 | Person 3 | 200 | 2 |  |  | 0 | 600 | 0 | 0 | 0 | 600
4 | Person 4 | 600 | 1 |  |  | 0 | 400 | 3200 | 0 | 0 | 0
5 | Person 5 | 600 | 2 |  |  | 0 | 0 | 600 | 1200 | 0 | 1800
6 | Person 6 | 200 | 2 |  |  | 0 | 0 | 0 | 600 | 0 | 600
7 | Person 7 | 800 | 2 |  |  | 0 | 0 | 0 | 2000 | 2000 | 800
8 | Person 8 | 300 | 2 |  |  | 0 | 0 | 0 | 0 | 1800 | 0
Spreadsheet: 762967d1641919791-help-with-sort-filter-formula-to-produce-bank-statement-zwl-and-us-
Sheet: Bank Account

Kindly asking for SORT, FILTER function formula to produce bank statements as shown in the two desired outcome or any other formula using information on transactions sheet..
Relevant columns on transactions sheet are : Payment method, Date, [NAME], Debit ZWL, Credit ZWL, Debit US$, Credit US$
Disired outcome |  |  |  |  |  |  |  | Disired outcome
BANK |  |  | ZWL |  |  |  |  | BANK |  |  | US$
Date | Description | Reference | Debit | Credit |  |  |  | Date | Description | Reference | Debit | Credit
 | RK | 101 | 10000 | 0 |  |  |  |  | KO | 105 | 0 | 4000
2022-01-03 00:00:00 | HYO | 102 | 0 | 8000 |  |  |  | 2022-01-02 00:00:00 | AML | 107 | 7000 | 0
2022-01-01 00:00:00 | YT | 106 | 0 | 3000 |  |  |  | 2022-01-10 00:00:00 | AML | 109 | 4500 | 0
2022-01-11 00:00:00 | KO | 112 | 0 | 1200 |  |  |  | 2022-01-10 00:00:00 | RJ | 110 | 4300 | 0
2022-01-12 00:00:00 | HYO | 113 | 80000 | 0
Spreadsheet: darrell_schoolcraft__7655__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | 2002-01-14 00:00:00
 |  |  | SoCal Gas Price |  | 2.13
 |  |  | San Juan Gas Price |  | 1.995
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
California Gas Day
he 6 | 07:00:00 |  | 0 | 0 | 0 | 505 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 540 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 540 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 540 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 540 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 540 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 540 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 540 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 540 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 540 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 540 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 540 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 540 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 540 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 540 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 540 | 7
he22 | 23:00:00 |  | 0 | 0 | 0 | 540 | 7
he23 | 12:00:00 |  | 0 | 0 | 0 | 505 | 7
he24 | 01:00:00 |  | 0 | 0 | 0 | 505 | 7
he1 | 02:00:00 |  | 0 | 0 | 0 | 505 | 7
he2 | 03:00:00 |  | 0 | 0 | 0 | 505 | 7
he3 | 04:00:00 |  | 0 | 0 | 0 | 505 | 7
he4 | 05:00:00 |  | 0 | 0 | 0 | 505 | 7
[NAME] | 06:00:00 |  | 0 | 0 | 0 | 505 | 7
Spreadsheet: 771164d1646469089-name-check-data-validation-formula-doofus-writer-data-extraction2-aligw
Sheet: Sheet2

 | Written by: [NAME]
1
2
3
4
5 | Written by: [NAME]
1
2
3
4
5 | Written by: [NAME]
1
2
3
4
5
1
2
3
4
5 | Written by: [NAME]
1
2
3
4
5
Spreadsheet: 876973d1723670563-count-of-unique-values-based-on-multiple-criteria-example-count-of-unique-values-for-programs
Sheet: Summary

Acct Code | Program |  | 2024-04-01 00:00:00 |  |  | 2024-05-01 00:00:00
 |  |  | Group | Individual | Revenue | Group | Individual | Revenue
ACCOUNT 211
 | Zoo Troop
 |  | Toddler
 |  | PreK
 |  | Kindergarten
 |  | 1st-2nd
 |  | 3rd-4th
 |  | 5th-6th
 |  | 7th-8th
 |  | High School
 |  | Cancelled Programs
 |  | TOTAL
 | In-Person Camp
 |  | 4-K HD
 |  | 4-K FD
 |  | 1-2 HD
 |  | 1-2 FD
 |  | 3-4 FD
 |  | 5-6 (5-8) FD
 |  | 7-8 FD
 |  | Before Care
 |  | After Care
 |  | 5-6 Bowyer
 |  | 7-8 Bowyer
 |  | Cancelled Programs
 |  | TOTAL
Spreadsheet: 791207d1660211713-help-with-a-lookup-with-two-conditions-dummy-lookup-file
Sheet: WIP

Project Group | Department 1 | Department 2 | Department 3 | Department 4 | Department 5 | Department 6 | Department 7 | Department 8 | Department 9 | Department 10 | Department 11
Project 1 | 1 | 553.75 | -498.8 | 1180.5 | 1 | 0 | 624.5100000000002 | -2.25 | -0.2100000000000364 | -5011.379999999999 | -12.5
Project 2
Spreadsheet: 111085d1307563886-summing-certain-values-based-on-what-is-in-another-column-779158-summing-certain-values-example
Sheet: Sheet1

 | Sheet 2 with SUMPRODUCT |  |  |  |  |  | Sheet 3 with SUMPRODUCT
 | belt | gloves | shoes | tie |  |  | belt | gloves | shoes | tie
[NAME] |  |  |  |  |  | [NAME]
Dumbo |  |  |  |  |  | Dumbo
Goofy |  |  |  |  |  | Goofy
[NAME] |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  | [NAME]
Minnie |  |  |  |  |  | Minnie
[NAME] |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  | [NAME]
Zippy |  |  |  |  |  | Zippy
 | Sheet 2 with COUNTIFS |  |  |  |  |  | Sheet 3 with COUNTIFS
 | belt | gloves | shoes | tie |  |  | belt | gloves | shoes | tie
[NAME] |  |  |  |  |  | [NAME]
Dumbo |  |  |  |  |  | Dumbo
Goofy |  |  |  |  |  | Goofy
[NAME] |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  | [NAME]
Minnie |  |  |  |  |  | Minnie
[NAME] |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  | [NAME]
Zippy |  |  |  |  |  | Zippy
Spreadsheet: 734475d1622190941-formula-that-multiplies-value-of-one-column-based-of-value-of-other-column-example
Sheet: Sheet1

1 | 20 | 10
1 | 20 | 10
2 | 10 | 2
2 | 2 | 0
3 | 0 | 0
3 | 2 | 2
4 | 10 | 1
4 | 0 | 0
Total | 220 | 105
Spreadsheet: 746118d1630512817-vlookup-depending-on-cell-value-example-workbook
Sheet: Fuji Target

Product # | 2021 Target
AWES3 | 3.2
FWMLES3 | 1.03
HFINS5PK | 1.92
HFINS5PKGRINAGER | 2
HFINS5PRUPDQE | 5.25
HH11PDQGRAINGER | 2.94
HM07019VP | 2.94
TW10PK48BON-U | 2.94
[NAME] | 12.08
Spreadsheet: 606300d1547562522-problem-with-kpi-calculation-export-2018-limited-
Sheet: SLA planon 2018 (002)

NUMMER | HOOFDNR | STATUS | STATUS_BO | DATUM_STATUS | GEBOUW | RUIMTE | ORDERGROEP | OMSCHRIJVING | TOELICHTING | RUIMTE_VRIJE_INVOER | date time notification | day of the week | DAG_GEMELD | Month | year | AANVRAGER | AANVRAGER_AFDELING | AANGEMAAKT_DOOR | COORDINATOR_INTERN | STORINGSDATUM | DATUM_INVOER_WIJZIGBAAR | [NAME] | GEWENST_GEREED_GEBRUIKER | START_DATUM | EIND_DATUM | [NAME] | DATUM_OPDRACHT_GEREED | date job finished | DATUM_ADM_GEREED | NAAM_UITVOERDER | MILIEU_IMPACT | VEILIGHEIDSIMPACT
76974.00 | 76974 | Melding gereed | Gereed | 2018-01-10 16:39:00 | [NAME] | landschapskantoor 1E | Bouw & herstellingen (klusjesdienst) | Bouw en herstellingen (klusjesdienst) | Het slotje [NAME] het eerste damestoilet op 1E is kapot. 2/1/18: bpi:klus | Damestoiletten 1E. | 2018-01-01 16:47:00 | 1 | 1 | 1 | 2018 | fncbewaking |  | fncbewaking | De Pril, [NAME] |  | 2018-01-01 16:46:00 |  |  |  |  | 2018-01-02 07:43:00 | 2018-01-10 16:39:00 | 2018-01-10 16:39:00 | 2018-01-10 16:39:00
76974.01 | 76974 | Order administratief afgehandel | Administratief gereed | 2018-01-10 16:39:00 | [NAME] | landschapskantoor 1E | Bouw & herstellingen (klusjesdienst) | Bouw en herstellingen (klusjesdienst) | Het slotje [NAME] het eerste damestoilet op 1E is kapot. 2/1/18: bpi:klus | Damestoiletten 1E. | 2018-01-01 16:47:00 | 1 | 1 | 1 | 2018 | fncbewaking |  | fncbewaking | De Pril, [NAME] |  | 2018-01-01 16:47:00 |  |  | 2018-01-02 07:43:00 |  |  | 2018-01-02 07:43:00 | 2018-01-10 16:39:00 | 2018-01-10 16:39:00
76975.00 | 76975 | Melding gereed | Gereed | 2018-01-02 17:01:00 | [NAME] | landschapskantoor 1E | Bouw & herstellingen (klusjesdienst) | Bouw en herstellingen (klusjesdienst) | Het slotje [NAME] het vierde damestoilet op 1E is kapot.  2/1/18: bpi: klus | Damestoiletten 1E. | 2018-01-01 16:48:00 | 1 | 1 | 1 | 2018 | fncbewaking |  | fncbewaking | De Pril, [NAME] |  | 2018-01-01 16:48:00 |  |  |  |  | 2018-01-02 07:44:00 | 2018-01-02 17:01:00 | 2018-01-02 17:01:00 | 2018-01-02 17:01:00
76975.01 | 76975 | Order administratief afgehandel | Administratief gereed | 2018-01-02 17:01:00 | [NAME] | landschapskantoor 1E | Bouw & herstellingen (klusjesdienst) | Bouw en herstellingen (klusjesdienst) | Het slotje [NAME] het vierde damestoilet op 1E is kapot.  2/1/18: bpi: klus | Damestoiletten 1E. | 2018-01-01 16:48:00 | 1 | 1 | 1 | 2018 | fncbewaking |  | fncbewaking | De Pril, [NAME] |  | 2018-01-01 16:48:00 |  |  | 2018-01-02 07:44:00 |  |  | 2018-01-02 07:44:00 | 2018-01-02 17:01:00 | 2018-01-02 17:01:00
76976.00 | 76976 | Melding gereed | Gereed | 2018-02-05 12:28:00 | [NAME] | landschapskantoor 1G | Bouw & herstellingen (klusjesdienst) | Bouw en herstellingen (klusjesdienst) | Lek boven thermostaat 1G? Thermostaat zit vol vuile druppels.  2/1/18: bpi: klus | Landschapskantoor 1G | 2018-01-01 16:51:00 | 1 | 1 | 1 | 2018 | fncbewaking |  | fncbewaking | De Pril, [NAME] |  | 2018-01-01 16:50:00 |  |  |  |  | 2018-01-02 07:45:00 | 2018-02-05 12:28:00 | 2018-02-05 12:28:00 | 2018-02-05 12:28:00
Spreadsheet: 724797d1616394790-multiple-if-condition-to-get-the-value-status_update_sample
Sheet: Sheet1

Status | Closed on | Expected Result |  | if A="40-Closed" and B <> Blank, then "Yes" else "No"
40-Closed | 2021-03-18 00:00:00 | No
10-WIP | 2021-03-10 00:00:00 | Yes
25-In Progress | 2021-03-15 00:00:00 | Yes
10-WIP |  | No
25-In Progress |  | No
25-In Progress |  | No
40-Closed | 2021-03-18 00:00:00 | No
Spreadsheet: 725397d1616667206-comparison-of-array-for-matching-and-non-matching-values-sample-excel-worksheet
Sheet: Sheet1

category | Matching | Non Matching |  |  | [NAME] | 9,11,19,20,21,22,23,29,37,41,127,267,347,388,427,447,467
11,11
29,29
29,29,997
21
11
11
9
11
11
11
9
11
21
9,11,9,9,9,181
9,11
101111
9
11
Spreadsheet: 8bb34670-8ef3-4b98-8698-e949eadd00a2
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
CDOMB | Test | CDOMB | Cadmium for Occupational Monitoring, Blood | Cadmium Occupational Monitor, B | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 1 | mL | Container/Tube: Royal blue-top (EDTA) [NAME] plastic trace element blood collection tube, catalog #368381 (Supply T183) [NAME]: Full tube Collection Instructions: 1. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 2. Send specimen in original tube. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	Green-top (heparin) tube | 0.0-4.9 mcg/L Reference values apply to all ages. | Monday through Friday; 8 a.m.-2 p.m., Saturday; 8 a.m.-3 p.m. Continuously | 1 day | 3 days | 1 | 82300 |  |  |  |  | Rochester
CDOMB | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 21 days
CDOMB | Result | 89539 | Cadmium Occupational Monitor, B | Cadmium Occupational Monitor, B | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 5609-3 | Cadmium:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 727010d1617650622-extracting-data-by-matching-multiple-criteria-data-excel-forum
Sheet: Sheet1

Data
Building | Unit | Vehicle # | License Plate
2700 | A | 1 | ABC123
2700 | B | 1 | DEF456
2700 | C | 1 | GHI789
2700 | C | 2 | 123ABC
2715 | A | 1 | 456DEF
2715 | B | 1 | 789GHI
2715 | B | 2 | XYZ987
2715 | C | 1 | TUV654
2720 | A | 1 | LMN321
2720 | B | 1 | 987XYZ
2720 | C | 1 | 654TUV
2720 | D | 1 | 321LMN
Results
Building | Unit | Vehicle # | License Plate | Vehicle # | License Plate | Vehicle # | License Plate
2700 | A | 1
2700 | B | 1
2700 | C | 1 |  | 2
2715 | A | 1
2715 | B | 1 |  | 2
2715 | C | 1
2720 | A | 1
2720 | B | 1
2720 | C | 1
2720 | D | 1