tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 3a4a7a78-c418-43e1-b16e-1dfebd1730ed
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
SFMON | Test | SFMON | [NAME] and [NAME] for Therapeutic Monitoring, Blood | Hb S/F Therapeutic Monitoring, B | Cation Exchange/High-Performance Liquid Chromatography (HPLC) |  |  |  | 6 | mL | Container/Tube: Preferred: Lavender top (EDTA) Acceptable: ACD, heparin [NAME]: 6 mL Collection Instructions: Do not transfer blood to other containers. Additional Information: Patient's age is required. Forms: If not ordering electronically, please submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | HEMOGLOBIN F 1-30 days: 22.8-92.0% 1-2 months: 7.6-89.8% 3-5 months: 1.6-42.2% 6-8 months: 0.0-16.7% 9-12 months: 0.0-10.5% 13-17 months: 0.0-7.9% 18-23 months: 0.0-6.3% > or =24 months: 0.0-0.9%  HEMOGLOBIN S All ages: 0.0% | Monday through Saturday; 7 a.m. and 1 p.m. | Same day/1 day | 2 days | 1 | 83021 |  |  |  |  | Rochester
SFMON | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 7 days
SFMON | Result | 32245 | [NAME] | [NAME] | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 4576-5
SFMON | Result | 32246 | [NAME] | [NAME] | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 4625-0
SFMON | Result | 32247 | Hb S/F Interpretation | Hb S/F Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59466-3
SFMON | [NAME] | SDEX | [NAME], Screen, Blood | [NAME], Scrn, B | [NAME] | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Container/Tube: Preferred: Lavender top (EDTA) Acceptable: ACD (solution B), heparin [NAME]: 1 mL  Additional Information: 1. Patient's age is required. 2. Include recent transfusion information. Forms: If not ordering electronically, please submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | Negative Precautions: The procedure does not distinguish hemoglobin S trait from homozygous sickle cell disease nor any of the following combinations: S/C, S/D, S/G, S/E, S/thalassemia, S/O-Arab, S/New York and C-Georgetown trait (Hb C-Harlem). | Monday through Saturday | 1 day | 4 days | 1 | 85660 |  |  | No | Yes
SDEX | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 7 days
SDEX | Result | 9180 | [NAME], Scrn, B | [NAME], Scrn, B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4621-9
Spreadsheet: 768905d1645196352-how-to-reduce-operator-available-hours-based-on-time-required-for-process-step-to-complete-hourly-production-schedule
Sheet: Operators

 | Operators | Hours Available
 | [NAME] | 7.75
 | [NAME] | 7.75
 | [NAME] | 7.75
 | [NAME] | 7.75
 | [NAME] | 7.75
 | Gavin | 7.75
 | Andjelika | 7.75
 | Jeanette | 7.75
 | [NAME] | 7.75
 | Sepp | 7.75
 | [NAME] | 7.75
Spreadsheet: 48044d1247225638-update-spreadsheet-by-1-year-book2
Sheet: Sheet1

Thu | 2008-01-09 00:00:00 | D3 |  | Fri | 2009-01-09 00:00:00 | D2
 |  |  |  | Mon | 1900-12-31 00:00:00 | D3
 |  |  |  | Mon | 1900-12-31 00:00:00 | D1
 |  |  |  | Mon | 1900-12-31 00:00:00 | D2
 |  |  |  | Mon | 1900-12-31 00:00:00 | D3
 |  |  |  | Mon | 1900-12-31 00:00:00 | D1
 |  |  |  | Mon | 1900-12-31 00:00:00 | D2
 |  |  |  | Mon | 1900-12-31 00:00:00 | D3
Spreadsheet: 85802d1285844848-lookup-help-excel-20help-1-
Sheet: Sheet1

 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00
Invoice 1 | 0 | 0 | 0 | 0 | 5
Invoice 2 | 0 |  | 2
Invoice 3 |  | 3
Invoice 4 |  |  |  | 4
Invoice 5 |  | 0 |  |  | 4
Invoice 6 | 1
Invoice 7 |  | 3
Invoice 8 |  |  | 4
Invoice 9 |  | 0 | 0 | 5
Invoice 10 |  |  |  |  | 5
Invoice 2 | 5
Invoice 5 | 2
Invoice 3 | 3
Invoice 4 | 4
Invoice 1 | 4
Invoice 6 | 1
Invoice 7 | 3
Invoice 9 | 4
Invoice 8 | 5
Invoice 10 | 5
Spreadsheet: 743167d1628264356-return-value-of-the-columns-based-upon-highest-value-in-another-example
Sheet: Sheet1

ID | Item | Value |  | Example Results required: | Item | ID | Value |  | Item | ID | Value
1 | A1 | 300 |  |  | A1 | 2 | 350
2 | A1 | 350 |  |  | A2 | 3 | 250
1 | A2 | 125 |  |  | A5 | 1 | 175
2 | A3 | 500 |  |  | A6 | 4 | 750
2 | A4 | 1000
3 | A4 | 250
4 | A4 | 200
1 | A5 | 175
2 | A6 | 200
3 | A2 | 250
1 | A3 | 1000
4 | A5 | 150
4 | A6 | 750
Spreadsheet: 737101d1624144959-2-x-lookups-to-calculate-commission-sample-1906
Sheet: Sample

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMMISSION LOOKUP
 | Month | Count | Sales | Banked | Balance | [NAME] | Count | Paid | Av Paid | Commission |  |  |  |  | Tier | [NAME] |  | % Comm
 | May '21 | SALES |  |  |  |  | RECEIPTS |  |  | COMMISSION |  | NAME | TIER |  | 1 | 2100 | 2499 | 0.027
 | Alana |  |  |  |  |  |  |  |  |  |  | Alana | 1 |  | 1 | 2500 | 2799 | 0.037
 | Anna | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 |  | Anna | 1 |  | 1 | 2800 | 3299 | 0.047
 | Cate | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 |  | Cate | 2 |  | 1 | 3300 | 9999 | 0.052
 | [NAME] | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 |  | Lydia | 2 |  | 2 | 2100 | 2499 | 0.025
 | Lauren | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 |  | Rachel | 2 |  | 2 | 2500 | 2799 | 0.035
 | Lydia | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 |  | [NAME] | 2 |  | 2 | 2800 | 3299 | 0.045
 | Rachel | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 |  | Tamara | 2 |  | 2 | 3300 | 9999 | 0.05
 | [NAME] | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 |  | [NAME] | 3 |  | 3 | 2100 | 2499 | 0.023
 | Tamara | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 |  | Lauren | 3 |  | 3 | 2500 | 2799 | 0.033
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 |  |  |  |  | 3 | 2800 | 3299 | 0.043
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 |  |  |  |  | 3 | 3300 | 9999 | 0.048
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 |  |  |  |  | 3 | 2500 | 2699 | 0.04
 | TOTALS |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2700 | 3299 | 0.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3300 | 9999 | 0.055
 | '=SUMIFS(P$7:P$17,O$7:O$17,B7) |  |  |  |  |  |  |  |  | =IFS(A7,R6:R25)(I7*LOOKUP(G7,$S$6:$T$25,$U$6:$U$25)) |  |  |  |  | 4 | 0 | 2299
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2300 | 2499
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2500 | 2699
 | Name in B = Tier in P |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2700 | 3299
 | Tier in R = Tier determined in P |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3300 | 9999
 | Percentage in U = Tier in R
 | Commission calculation in K is:
 | Average sale in G = % Comm in U,
 | Commission in K = Banked revenue in I x % Comm in U
Spreadsheet: 13a232d0-f914-4c75-b1a4-490a99df6a70
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Preceptor Credit Reporting Form | Unnamed: 4 | Unnamed: 5
Department Reporting Credit:
Reporting Period Start Date:
Reporting Period End Date:
Submitted by:
AOA# | Total Hours | Physician Name
 |  |  |  | For each physician, provide the physician's name, AOA number and the number of hours received during the reporting period.
 |  |  |  | Send the completed form to
 |  |  |  | The Office of Professional
 |  |  |  | and Continuing
 |  |  |  | Education
 |  |  |  | Total hours this report:
 |  |  |  |  | 0
 | 0
Spreadsheet: 606160d1547508495-how-to-choose-last-value-book3
Sheet: AFTER

Savings & Insurances |  |  |  |  | Total in Bank |  | 5700
Date | Deposit | Prev Balance | New Balance
12/25/18 | 2000 | 4700
2019-01-11 00:00:00 | 150
12/25/19 | -150
2019-01-12 00:00:00 | 1000
12/25/20 | 3500
2019-01-13 00:00:00 | -500
12/25/21 | -5000
Spreadsheet: sally_beck__33736__NA GAS AND POWER-REGION BREAKOUT 07-26-00 EM
Sheet: NORTH AMERICAN GAS CHARTS

ENRON - North American Gas
AVERAGE EOL AND NON-EOL TRANSACTIONS PER DAY
REGION BREAKOUT
As of July 26, 2000
 |  | AVERAGE DEALS PER DAY
MONTH | DAYS | EOL | NON-EOL | TOTAL
1999-11-01 00:00:00 | 2 | 53 | 619 | 672
1999-12-01 00:00:00 | 21 | 225 | 605 | 830
2000-01-01 00:00:00 | 20 | 492 | 647 | 1139
2000-02-01 00:00:00 | 20 | 777 | 644 | 1421
2000-03-01 00:00:00 | 23 | 1039 | 610 | 1649
2000-04-01 00:00:00 | 19 | 1079 | 639 | 1718
2000-05-01 00:00:00 | 22 | 1582 | 730 | 2311
2000-06-01 00:00:00 | 22 | 1952 | 668 | 2620
2000-07-01 00:00:00 | 16 | 1835 | 682 | 2517
TOTAL AVERAGE | 165 | 1101 | 652 | 1753
REGION BREAKOUT (Region breakout based on deal locations and pub code)
Spreadsheet: 852373d1702427939-vlook-up-not-finding-what-i-am-looking-for-problem
Sheet: Sheet2

Cust No | Stock no. | Item | Quantity | Price
C2 | 106PB-7 |  | 2
C4 | 102Bkl |  | 5
C1 | 50ht |  | 2
C1 | 102Bkl |  | 4
 |  | 50mm Hook and Tail
 |  | How to I find the value in B8 the formula works the other way around in C2 to c5
 |  | I can not work out how to find the value in C8 using the same formula it is not working the other way around
 |  | What am I doing Wrong?
Spreadsheet: 765952d1643694301-connection-to-be-built-in-2-dynamic-values-in-different-columns-sample-file
Sheet: Sheet1

S. No | Column 1 | Column 2 | Column 3 | Column 4
1 | A
2 | B
3 | C
4 | D
5 | E
6 | F
7 | G
8 | H
9 | I
10 | J
Spreadsheet: 454930d1460034696-comparing-multiple-sets-of-data-and-returning-appropriate-cell-ets3
Sheet: 24HR Staffing

24 HOUR STAFFING SHEET
Nurse Date: | 2016-05-01 00:00:00 |  | PCA Date: | 2016-05-01 00:00:00
7A-3 |  |  | 3P-7 |  |  | 7P-11 |  |  | 11P-7
CENSUS: __________ |  | CODE | CENSUS: __________ |  | CODE | CENSUS: __________ |  | CODE | CENSUS: __________ |  | CODE
 | RN |  |  | RN |  |  | RN |  |  | RN
 | RN |  |  | RN |  |  | RN |  |  | RN
 | RN |  |  | RN |  |  | RN |  |  | RN
 | RN |  |  | RN |  |  | RN |  |  | RN
 | RN |  |  | RN |  |  | RN |  |  | RN
 | RN |  |  | RN |  |  | RN |  |  | RN
 | RN |  |  | RN |  |  | RN |  |  | RN
 | RN |  |  | RN |  |  | RN |  |  | RN
 | RN |  |  | RN |  |  | RN |  |  | RN
 | RN |  |  | RN |  |  | RN |  |  | RN
 | PCA |  |  | PCA |  |  | PCA |  |  | PCA
 | PCA |  |  | PCA |  |  | PCA |  |  | PCA
 | PCA |  |  | PCA |  |  | PCA |  |  | PCA
 | PCA |  |  | PCA |  |  | PCA |  |  | PCA
 | PCA |  |  | PCA |  |  | PCA |  |  | PCA
 | US |  |  | US |  |  | US |  |  | US
Staffing Instructions: |  |  |  |  |  | Available Staff: |  |  | SITTERS:
0700-1500: |  |  |  |  |  |  |  |  | 7A-3P
1500-1900:
1900-2300: |  |  |  |  |  |  |  |  | 3P-7P
2300-0700:
Additional Instructions: |  |  |  |  |  |  |  |  | 7P-11P
Guide: Write code next to staff name |  |  |  |  |  | Potential Discharges:
CX = CANCELLED |  |  | C/O = CALL OFF |  |  |  |  |  | 11P-7A
ET = EXTRA SHIFT |  |  | OT = OVERTIME
OS = ORIENTATION SHIFT |  |  | FET = FLEX EXTRA SHIFT |  |  |  |  |  | Notes:
CHG = CHARGE |  |  | CLD = CLERICAL DAY
Spreadsheet: 694669d1599740562-matching-1-column-to-another-column-exactly-book1
Sheet: Master data

Material | Component
50000500001 | 201250
50000500001 | 201251
50000500001 | 201252
50000500001 | 201253
50000500002 | 201350
50000500002 | 201251
50000500002 | 201252
50000500003 | 201253
50000500003 | 201251
50000500003 | 201252
50000500003 | 201566
50000500003 | 201567
50000500004 | 201250
50000500004 | 201251
50000500004 | 201252
50000500004 | 201253
50000500005 | 201257
50000500005 | 201251
50000500005 | 201252
50000500005 | 201567
Spreadsheet: 752807d1634979069-nested-sumif-formula-is-this-the-best-way-sample
Sheet: Data

Sl.No | Item | Qty. |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Data
1 | Dummy1 | 10 |  |  |  |  |  |  |  | Data1
 | Dummy1 | 10 |  |  |  |  |  |  |  | Data3
 | Dummy1
 | Dummy1
 | Dummy5
 | Dummy6
 | Dummy7
 | Dummy7
 | Dummy7
 | Dummy10
 | Dummy11
 | Dummy11
Spreadsheet: 877737d1724596571-apply-sum-function-only-for-level-1-parent-row-5copy
Sheet: TDSheet

 |  | Group 1 |  |  |  |  |  |  | 416
 |  | Company 2 |  |  |  |  |  |  | 115
 |  | Company 3 |  |  |  |  |  |  | 25
 |  | Company 4 |  |  |  |  |  |  | 276
 |  | Group 2 |  |  |  |  |  |  | 372221.37
 |  | Company 5 |  |  |  |  |  |  | 372221.37
 |  | Group 3 |  |  |  |  |  |  | 36845.89 |  | I 'm simply using SUM function for each of these cells (J2, J7, J10) separetely by selecting range underneath. Is there any way to do it automatically for all of them(J29, [NAME], J38, J48….)?
 |  | Company 6 |  |  |  |  |  |  | 253 |  | 1. The parent's name (level 1) could be different everytime
 |  | Company 7 |  |  |  |  |  |  | 70 |  | 2. The child's name (level 2) could be different everytime
 |  | Company 8 |  |  |  |  |  |  | 115
 |  | Company 9 |  |  |  |  |  |  | 96
 |  | Company 10 |  |  |  |  |  |  | 311
 |  | Company 11 |  |  |  |  |  |  | 30
 |  | Company 12 |  |  |  |  |  |  | 2835
 |  | Company 13 |  |  |  |  |  |  | 64
 |  | Company 14 |  |  |  |  |  |  | 610
 |  | Company 15 |  |  |  |  |  |  | 1274
 |  | Company 16 |  |  |  |  |  |  | 95.17
 |  | Company 17 |  |  |  |  |  |  | 602
 |  | Company 18 |  |  |  |  |  |  | 54.8
 |  | Company 19 |  |  |  |  |  |  | 108.42
 |  | Company 20 |  |  |  |  |  |  | 15
 |  | Company 21 |  |  |  |  |  |  | 27545
 |  | Company 22 |  |  |  |  |  |  | 2767.5
 |  | Group 4
 |  | Company 23 |  |  |  |  |  |  | 408
 |  | Company 24 |  |  |  |  |  |  | 300
 |  | Company 25 |  |  |  |  |  |  | 50
 |  | Group 5
 |  | Company 26 |  |  |  |  |  |  | 84461.03
 |  | Company 27 |  |  |  |  |  |  | 59.1
 |  | Group 6
 |  | Company 28 |  |  |  |  |  |  | 35632.66
 |  | Company 29 |  |  |  |  |  |  | 12
 |  | Company 30 |  |  |  |  |  |  | 15
 |  | Company 31 |  |  |  |  |  |  | 80
 |  | Company 32 |  |  |  |  |  |  | 125
 |  | Company 33 |  |  |  |  |  |  | 29.98
 |  | Company 34 |  |  |  |  |  |  | 32
 |  | Group 7
 |  | Company 35 |  |  |  |  |  |  | 65771.16
 |  | Company 36 |  |  |  |  |  |  | 45
 |  | Company 37 |  |  |  |  |  |  | 25
 |  | Company 38 |  |  |  |  |  |  | 126.82
 |  | Group 8
 |  | Company 2 |  |  |  |  |  |  | 2710.9
 |  | Group 9
 |  | Company 2 |  |  |  |  |  |  | 33863.95
 |  | Group 10
 |  | Company 2 |  |  |  |  |  |  | 4662.36
 |  | Company 2 |  |  |  |  |  |  | 815.95
 |  | Company 2 |  |  |  |  |  |  | 2894.96
 |  | Group 11
 |  | Company 2 |  |  |  |  |  |  | 200
 |  | Company 2 |  |  |  |  |  |  | 4884
 |  | Group 12
 |  | Company 2 |  |  |  |  |  |  | 10866.26
 |  | Group 13
 |  | Company 2 |  |  |  |  |  |  | 4003.07
 |  | Group 14
 |  | Company 2 |  |  |  |  |  |  | 476.49
 |  | Company 2 |  |  |  |  |  |  | 12
 |  | Company 2 |  |  |  |  |  |  | 87288.84
 |  | Company 2 |  |  |  |  |  |  | 56.71
 |  | Company 2 |  |  |  |  |  |  | 43.78
 |  | Company 2 |  |  |  |  |  |  | 814.3
 |  | Group 15
 |  | Company 2 |  |  |  |  |  |  | 24183.25
 |  | Company 2 |  |  |  |  |  |  | 17.72
Spreadsheet: 0c9e5ea4-0eb7-47a7-b290-bf6eeaa56235
Sheet: Sheet1

COPPIN STATE UNIVERSITY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
INDIVIDUAL REQUEST FOR TRAVEL
 |  | In State |  |  | Out of State
 |  |  |  |  |  |  | TF#: | ______________
Name: |  |  |  |  |  |  |  | (Procurement Office only)
Title:
Destination:
Purpose of Travel:
Departure Date: |  |  |  |  | Return Date:
Method of Travel: |  | State Car: |  | Private Car: |  | Plane: |  | Other:
Estimated Cost:
 |  | Registration |  |  | P-Card |  | Req./P.O. |  | Reimburse
 |  | Lodging |  |  | P-Card |  | Req./P.O. |  | Reimburse
 |  | Meals |  |  | P-Card |  | Req./P.O. |  | Reimburse
 |  | Transportation |  |  | P-Card |  | Req./P.O. |  | Reimburse
 |  | Other |  |  | P-Card |  | Req./P.O. |  | Reimburse
 |  | TOTAL |  | 0
Department or [NAME]: |  |  |  |  |  |  | PS #:
I have approved the above travel.
Department Head: |  |  |  |  |  |  | Date:
Area Vice President: |  |  |  |  |  |  | Date:
Budget Office: |  |  |  |  |  |  | Date:
Vice President for
Administration & Finance: |  |  |  |  |  |  | Date:
Spreadsheet: 738754d1625227887-index-aggregate-formula-help-example-data-1-
Sheet: Mar2021

2021-03-01 00:00:00
Number | Category | Member [NAME] | Species | Points
 | Open ExC | Person B | Mar aaa | 4
 | Open ExC | Person B | Mar bbb | 1
 | Open ExCat | Person C | [NAME] | 4
 | Open MinC | Person C | Mar ddd | 2
 | Open ExCat | Person B | Mar eee | 0
 | Open MinC | Person A | Mar fff | 0
Spreadsheet: 79951d1280216841-hiding-conditional-format-when-activating-cell-is-empty-new-plog-test
Sheet: Sheet1

 |  |  |  |  |  |  | Pilot Log Book
 | Page 1 |  | 2010-07-26 00:00:00
 |  | Aircraft |  | Captain |  | Holders Operating | Journey or Nature of flight |  | [NAME] | [NAME] | Single Engine |  |  |  |  |  |  |  |  | Name: - | [NAME]
 | Date | Type | Reg |  |  | Capacity | From | To | (GMT) | (GMT) | In Command | Dual | T.Off | LDGs | Remarks |  |  |  |  | Licence No. - | 12345/67
 | 2010-07-25 00:00:00 | PA28 | G-1234 | [NAME] |  | P1 | EGNR | EGCV | 2359 | 120 | 01:21:00 |  |  |  |  |  |  |  |  | [NAME] | 2011-11-01 00:00:00 |  | Alert
 | 2010-07-26 00:00:00 | PA29 | G-1235 | [NAME] |  | PUT | EGNR | EGCV | 1925 | 1955 |  | 00:30:00 |  |  |  |  |  |  |  | Revalidation |  |  | Alert
 |  |  |  |  |  | pic |  |  | 715 | 800 | 00:45:00
 |  |  |  |  |  | put |  |  | 600 | 700 |  | 01:00:00 |  |  |  |  |  |  |  | Medical | 2011-11-02 00:00:00 |  | Alert
 |  |  |  |  |  | p1 |  |  | 615 | 715 | 01:00:00 |  |  |  |  |  |  |  |  | Radio-Telephony licence |  |  | Alert
 |  |  |  |  |  | p1/s |  |  | 922 | 1123 |  | 02:01:00
 |  |  |  |  |  | put |  |  | 513 | 617 |  | 01:04:00 |  |  |  |  |  |  |  | Night Rating | 2011-11-01 00:00:00 |  | Alert
 |  |  |  |  |  | p1 |  |  |  |  |  |  |  |  |  |  |  |  |  | I.M.C. |  |  | Alert
 |  |  |  |  |  | p1
 |  |  |  |  |  | pic |  |  |  |  |  |  |  |  |  |  |  |  |  | Instrument Rating | 2011-11-02 00:00:00 |  | Alert
 |  |  |  |  |  | put |  |  |  |  |  |  |  |  |  |  |  |  |  | Instructor |  |  | Alert
 |  |  |  |  |  |  |  | Total hours |  |  | 03:06:00 | 04:35:00
 | Page 2
 |  |  |  |  |  |  | Total hours  Brought Forward |  |  |  | 03:06:00 | 04:35:00
 |  | Aircraft |  | Captain |  | Holders Operating | Journey or Nature of flight |  | [NAME] | [NAME] | Single Engine
 | Date | Type | Reg |  |  | Capacity | From | To | (GMT) | (GMT) | In Command | Dual | T.Off | LDGs | Remarks
 |  |  |  |  |  | p1 |  |  | 2359 | 120 | 01:21:00
 |  |  |  |  |  | put |  |  | 2100 | 10 |  | 03:10:00
 |  |  |  |  |  | p1 |  |  | 1643 | 1742 | 00:59:00
 |  |  |  |  |  | pic |  |  | 2356 | 115 | 01:19:00
 |  |  |  |  |  | put |  |  | 2155 | 205 |  | 04:10:00
 |  |  |  |  |  | put
 |  |  |  |  |  |  |  | Total hours | Carried Forward |  | 06:45:00 | 11:55:00
 |  |  |  |  |  |  |  | Grand Total |  |  | 18:40:00 | hours
Spreadsheet: 732198d1620822030-multiple-nested-ifs-test-31-ans
Sheet: Sheet1

New / Used | coat | hat | shoe | shirt | jumper | Deposit Return |  |  |  | New | Used
N | No | Yes | Yes | Yes | Yes |  |  |  | Coat | 10 | 5
 |  |  |  |  |  |  |  |  | hat | 5 | 3
 |  |  |  |  |  |  |  |  | shoe | 2 | 1
 |  |  |  |  |  |  |  |  | shirt | 4 | 1
 |  |  |  |  |  |  |  |  | jumper | 10 | 2
Spreadsheet: 726399d1617210273-sum-of-different-employers-per-type-book1
Sheet: Sheet1

Type | Scheme No | Employer |  | Type
A | 555 | 7
A | 556 | 53 |  | B
A | 557 | 3 |  | C
B | 558 | 27
B | 559 | 53
B | 560 | 2
B | 561 | 53
B | 562 | 3
C | 563 | 4
C | 564 | 65
C | 565 | 65
C | 566 | 2
C | 567 | 7
Spreadsheet: 70865d1271610165-voedselgenerator-voedselgenerator-help-
Sheet: drinken

 | drinken
 | ochtend
 |  | [NAME] | [NAME] | totaal | totaal aantal glazen | aantal in verpakking | aantal [NAME]
 | aantal mensen
 | aantal glazen | 2 | 2 |  |  | 5
 | melk | 0.15 | 0.2 |  |  | 5
 | yogho | 0.45 | 0.4 |  |  | 5
 | chocomel | 0.4 | 0.4 |  |  | 5
 | middag
 |  | [NAME] | [NAME] | totaal | totaal aantal glazen
 | aantal mensen
 | aantal glazen | 3 | 3 |  |  | 5
 | melk | 0.15 | 0.2 |  |  | 5
 | yogho | 0.45 | 0.4 |  |  | 5
 | chocomel | 0.4 | 0.4 |  |  | 5
 | avond
 |  | [NAME] | [NAME] | totaal | totaal aantal glazen
 | aantal mensen
 | aantal glazen | 3 | 4 |  |  | 5
 | sinas | 0.3 | 0.325 |  |  | 5
 | cola | 0.3 | 0.325 |  |  | 5
 | cassis | 0.15 | 0.175 |  |  | 5
 | 7up | 0.15 | 0.175 |  |  | 5
 | ranja | 0.1 | 0 |  |  | 30
 | bier |  | 0.75 |  |  | 24
 | extra drinken overdag
 |  | [NAME] | [NAME] | totaal | totaal aantal glazen
 | aantal mensen
 | aantal glazen | 4 | 3
 | ranja | 1 | 1 |  |  | 40
 | totaal
 | product | aantal | [NAME]
 | melk
 | yogho
 | chocomelk
 | sinas
 | cola
 | cassis
 | 7 up
 | ranja
 | bier
Spreadsheet: 743240d1628323786-how-to-create-multiple-dependent-drop-downs-using-array-formulas-in-excel-arraydependentdropdown
Sheet: Temp

Laptop Brand | Model | RAM | Processor | Price
Spreadsheet: 122911d1317237376-drop-down-menu-need-a-choice-added-project1
Sheet: pulldown list

 | Range A |  |  |  | Range D
 | case |  |  |  | Customer
 | A1 | no trouble found |  |  | ABC
 | A2 | damage box |  |  | BCC
 | A3 | missing item
 | Range B
 | action
 | X1 | ok to accept
 | Y1 | reject
 | Range C
 | Product code
 | GB1234
 | GB1235
Spreadsheet: 775313d1649009799-conditional-formatting-alternate-row-color-when-value-changes-sample
Sheet: Sheet1

Value | Data | Data2 | Data3 | Data4 | Data5
1 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
1 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
1 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
1 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
23 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
23 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
3 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
7 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
7 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
7 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
5 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
5 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
5 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
5 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
5 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
6 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
6 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
6 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
6 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]