tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 779159d1651605560-formula-to-assist-in-populating-cells-between-2-worksheets-for-help
Sheet: Courses

 |  |  |  |  |  |  | HOME
 | AY 15 HR STIPEND | 30088 |  |  |  | SEM Tuition | 10400 |  | # END TA's (12 MAX): |  |  |  | AY Rate | 30088 |  |  | AY Rate | 40117
 | AY 20 HR  STIPEND | 40117 |  |  |  | AY SHP | 3420 |  | # STATE TA's (6 MAX): |  |  |  | Fall | 1659.26 |  |  | Fall | 2212.33
 |  |  |  |  |  | SEM SHP | 1920 |  |  |  |  |  | Spring | 1684.03 |  |  | Spring | 2245.35
 | TA APPOINTMENTS - 15 Hour |  |  |  |  |  |  | FALL |  |  |  |  |  |  |  | SPRING
Term | Name (PULLED FROM [NAME]) | Field | CU ID | Net ID | I-9 | Offer | Acc | Type | Course | SHP | SHP Item Type | Tuition | Tuition Item Type | Stipend Account | Stipend Amount | Type2 | Course2 | SHP2 | SHP Item Type2 | Tuition2 | Tuition Item Type2 | Stipend Account2 | Stipend Amount2 | Notes
S | Maine, Lori |  |  |  | N | 2022-04-04 00:00:00 | 2022-04-06 00:00:00 |  |  |  |  |  |  |  |  | [NAME] | BioMG 1350 (MBG): INTRODUCTORY BIOLOGY: CELL AND DEVELOPMENTAL BIOLOGY
AY | Doe, [NAME] |  |  |  | M | 2022-03-29 00:00:00 | 2022-03-29 00:00:00 | End TA | BioG 1440 (NBB): INTRODUCTORY BIOLOGY: COMPARATIVE PHYSIOLOGY |  |  |  |  |  |  | End TA | BioG 1440 (NBB): INTRODUCTORY BIOLOGY: COMPARATIVE PHYSIOLOGY
AY | Doe, [NAME] |  |  |  | Y | 2022-04-08 00:00:00 | 2022-04-11 00:00:00 | End TA | BioG 1440 (NBB): INTRODUCTORY BIOLOGY: COMPARATIVE PHYSIOLOGY |  |  |  |  |  |  | End TA | BioG 1440 (NBB): INTRODUCTORY BIOLOGY: COMPARATIVE PHYSIOLOGY
F | Subway, [NAME] |  |  |  | M | 2022-02-28 00:00:00 | 2022-04-01 00:00:00 | [NAME] | BioG 1140 (Plant Bio): FOUNDATIONS OF BIOLOGY (FALL)
F | Spaulding, [NAME] |  |  |  | M | 2022-03-28 00:00:00 | 2022-04-01 00:00:00 | [NAME] | BioG 1140 (Plant Bio): FOUNDATIONS OF BIOLOGY (FALL)
 | Open | Course
 |  | BioEE 1610 (Ecology): ECOLOGY AND THE ENVIRONMENT
 |  | End BioEE 1610 (Ecology): ECOLOGY AND THE ENVIRONMENT
 |  | BioG 1140 (Plant Bio): FOUNDATIONS OF BIOLOGY (FALL)
 |  | BioG 1440 (NBB): INTRODUCTORY BIOLOGY: COMPARATIVE PHYSIOLOGY
 |  | BioMG 1350 (MBG): INTRODUCTORY BIOLOGY: CELL AND DEVELOPMENTAL BIOLOGY
Spreadsheet: 70642d1271347308-require-help-with-counting-based-on-multiple-criteria-array-example
Sheet: Summary

 | Number of Critical Incidents
Site | 2010-04-15 00:00:00 | 2010-04-14 00:00:00 | 2010-04-13 00:00:00 | 2010-04-12 00:00:00 | 2010-04-11 00:00:00 | 2010-04-10 00:00:00 | 2010-04-09 00:00:00 | 2010-04-08 00:00:00 | 2010-04-07 00:00:00 | 2010-04-06 00:00:00 | 2010-04-05 00:00:00 | 2010-04-04 00:00:00 | 2010-04-03 00:00:00 | 2010-04-02 00:00:00
Alpha
Beta
Delta
Omega
 | If we look at the data sheet, we can see there was only one critical incident on April 15, and that it was in site alpha
 | So the data should look like this:
Site | 2010-04-15 00:00:00
Alpha | 1
Beta | 0
Delta | 0
Omega | 0
Spreadsheet: 80200d1280400603-formula-syntax-query-excell-2010-739374_matt_cox
Sheet: Sheet1

Meeting Count | 0 | 5 | 10 | 15
Commission | 100 | 125 | 175 | 225
Increase | 100 | 25 | 50 | 50
OTE | 500 | 625 | 875 | 1125
 | Meetings | Commission
 | 3 | 300
Spreadsheet: 749571d1632906509-sum-multiple-values-from-cells-beneath-a-certain-number-book1-57-
Sheet: Sheet1

 | 2021-09-13 00:00:00 | Start | 08:00:00 | 10:00:00 | 10:30:00 | 13:00:00
 |  | Slut | 10:00:00 | 10:30:00 | 12:30:00 | 17:00:00
 |  | Aktivitet |  |  |  |  |  |  |  |  |  | 123
 |  | [NAME]. | 123 | 112576 | 123 | 123 |  |  |  |  | SUM:
 |  | Intervall
 |  | Total tid
 | 2021-09-14 00:00:00 | Start | 09:00:00 | 11:00:00 | 12:30:00 | 15:00:00 | 16:00:00
 |  | Slut | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 | 17:30:00
 |  | Aktivitet
 |  | [NAME]. | 112576 | 123 | 123 | 112576 | D0014827
 |  | Intervall
 |  | Total tid
 | 2021-09-15 00:00:00 | Start | 08:00:00 | 13:00:00
 |  | Slut | 12:30:00 | 17:00:00
 |  | Aktivitet
 |  | [NAME]. | D0014827 | D0014827
 |  | Intervall
 |  | Total tid
 | 2021-09-16 00:00:00 | Start | 08:00:00 | 11:00:00 | 14:00:00
 |  | Slut | 11:00:00 | 13:00:00 | 17:30:00
 |  | Aktivitet
 |  | [NAME]. | D0014827 | 112576 | D0014827
 |  | Intervall
 |  | Total tid
 | 2021-09-17 00:00:00 | Start | 08:00:00 | 15:00:00 | 17:30:00
 |  | Slut | 13:00:00 | 16:30:00 | 20:00:00
 |  | Aktivitet
 |  | [NAME]. | 123 | 6096461 | D0014827
 |  | Intervall
 |  | Total tid
 | 2021-09-18 00:00:00 | Start
 |  | Slut
 |  | Aktivitet
 |  | [NAME].
 |  | Intervall
 |  | Total tid
 | 2021-09-19 00:00:00 | Start | 15:30:00
 |  | Slut | 17:30:00
 |  | Aktivitet
 |  | [NAME]. | D0014827
 |  | Intervall
 |  | Total tid
Spreadsheet: kate_symes__19088__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-04-12 00:00:00 |  | 176.32 | 27632 | 107.12 | 14896
 | 2001-04-11 00:00:00 |  | 178.5 | 21120 | 115.45 | 16912
 | 2001-04-10 00:00:00 |  | 181.91 | 26368 | 109.27 | 11712
 | 2001-04-09 00:00:00 |  | 157.87 | 22000 | 113.76 | 15928
 | 2001-04-08 00:00:00 |  |  |  |  |  | 113.77 | 45888
 | 2001-04-07 00:00:00 |  | 161.06 | 25232 | 100.79 | 16136
 | 2001-04-06 00:00:00 |  | 161.06 | 25232 | 100.79 | 16136
 | 2001-04-05 00:00:00 |  | 224.86 | 22592 | 122.93 | 16784
 | 2001-04-04 00:00:00 |  | 237.5 | 23824 | 129.77 | 12120
 | 2001-04-03 00:00:00 |  | 232.96 | 14960 | 120.77 | 12904
 | 2001-04-02 00:00:00 |  | 224.92 | 23056 | 133.39 | 11728
 | 2001-04-01 00:00:00 |  |  |  |  |  | 133.75 | 35784
 | 2001-03-31 00:00:00 |  | 169.38 | 25360 | 94.21 | 6472
 | 2001-03-30 00:00:00 |  | 169.38 | 25360 | 94.21 | 6472
 | 2001-03-29 00:00:00 |  | 163.49 | 34064 | 92.05 | 9080
 | 2001-03-28 00:00:00 |  | 131.03 | 22992 | 87.22 | 10736
 | 2001-03-27 00:00:00 |  | 120.72 | 26752 | 75.21 | 10280
 | 2001-03-26 00:00:00 |  | 281.51 | 17824 | 146.38 | 12680
 | 2001-03-25 00:00:00 |  |  |  |  |  | 146.56 | 32640
 | 2001-03-24 00:00:00 |  | 237.5 | 15296 | 143.54 | 10280
 | 2001-03-23 00:00:00 |  | 237.5 | 15296 | 143.54 | 10280
 | 2001-03-22 00:00:00 |  | 279.47 | 27312 | 173.78 | 5920
 | 2001-03-21 00:00:00 |  | 395 | 15200 | 222.02 | 8392
 | 2001-03-20 00:00:00 |  | 379.17 | 18400 | 211.59 | 9640
 | 2001-03-19 00:00:00 |  | 313.9 | 18736 | 207.5 | 11648
 | 2001-03-18 00:00:00 |  |  |  |  |  | 196.24 | 29832
 | 2001-03-17 00:00:00 |  | 205.5 | 18592 | 148.56 | 7024
 | 2001-03-16 00:00:00 |  | 205.98 | 17600 | 148.56 | 7024
 | 2001-03-15 00:00:00 |  | 184.07 | 20192 | 129.29 | 6440
 | 2001-03-14 00:00:00 |  | 169.24 | 16576 | 110.08 | 7280
 | 2001-03-13 00:00:00 |  | 170.67 | 19648 | 104.69 | 3840
Spreadsheet: 736561d1623743813-if-a-value-of-zero-occurs-before-another-value-within-a-column-return-1-otherwise-0-sample_data
Sheet: Sheet1

 |  | Index | Erroneous Values | Minimum | Flag 1: Number of rows until erroneuous value exceeds minimum | Flag 2: Number of rows until erroneous value is 0 | Desired Output
 |  | 1 | 0 | 80
 |  |  | 78
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 4.834
 |  |  | 7.063000000000001
 |  |  | 20.18
 |  |  | 4.825
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 1
 |  |  | 1.489
 |  |  | 9.643
 |  |  | 15.036
 |  |  | 9.747
 |  |  | 18.951
 |  |  | 29.807
 |  |  | 43.322
 |  |  | 11.262
 |  |  | 6.715999999999999
 |  |  | 22.545
 |  |  | 4.971
 |  |  | 28.314
 |  |  | 43.763
 |  |  | 42.177
 |  |  | 81
 |  |  | 52.645
 |  |  | 62.848
 |  |  | 74.309
 |  |  | 79.813
 |  |  | 81.174
 |  |  | 81.121
 |  |  | 81.959
 |  |  | 80.55
 |  |  | 0
Spreadsheet: dd52efd5-ebb3-4f57-96d6-d7a536395a66
Sheet: Sheet1

Votre recherche : HAGION OROS, ATHOS, [NAME], 0597 %28Lambros 6104%29 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Folios | Auteur | Oeuvre | CPG | Siècle
Item 4 | GREGORIVS NAZIANZENVS | CARMINA MORALIA 30-33 | 3035.30-33 | 17
Item 6 | CATO MARCVS PORCIVS [PSEVDO] | CATONIS DISTICHA |  | 17
Item 6 | CATO MARCVS PORCIVS [PSEVDO] | CATONIS DISTICHA
Item 7 | HOMERVS | BATRACHOMYOMACHIA |  | 17
Spreadsheet: c5cbbde2-5b09-4d7a-bcdf-ad686c559741
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
FBEN | Test | FBEN | Benzene, Occupational Exposure, Blood | Benzene, Blood | Headspace Gas Chromatography/Flame Ionization Detection (GC-FID) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 20 | mL | Draw blood in a green-top (sodium heparin) tube(s) and send  20 mL in two tubes of sodium heparin whole blood refrigerated.  Blood should be drawn at end of shift.   [NAME] should be filled to  prevent loss of volatile compound into headspace. | 5 mL (in two tubes)   Note: Subm | Specimens other than	Whole blood Anticoagulants other than	Sodium heparin Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Reporting Limit: 0.02 mg/L   Normal (unexposed population):   None detected Exposed (end-of-shift):   Blood benzene concentrations of >0.1 mg/L correlate   with exposure to >10 ppm benzene in air. Toxic:   Blood benzene concentrations >0.90 mg/L have been   observed in fatal cases of benzene exposure.      Test Performed By:  Medtox Laboratories                                         402 W. County Road D                                          St. Paul, MN  55112 | Monday through Sunday | 7 days | 9 - 11 days | 1 | 84600 |  |  |  |  | Medtox Laboratories, Inc
FBEN | [NAME] | WBNAH | WB Sodium Heparin |  |  |  | Refrigerated
FBEN | Result | Z1153 | Benzene | Benzene | Alphanumeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 9906a32d-b20f-446f-8210-3ad5fe6b5757
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
MPC | Test | MPC | Mycoplasma Pneumoniae Culture | Mycoplasma Pneumoniae Culture |  | Throat swab or sputum in mycoplasma transport media: ThtSwbORSpt |  |  |  | Varies | 3 mL Sputum, Bronchial Washings, Tracheal Aspirate, Broncoalveolar Lavage, Nasopharyngeal Aspirate, [NAME], 1 Throat Swab or 1 Nasopharyngeal Swab.   Collect respiratory specimen in mycoplasma transport media (Supply T187) supplied, [NAME] transport medium, M4 or M5. Specimen must be placed in transport media within 2 hours of collection.  Send specimen frozen.  Note: 1. Specimen source is required.           2. Separate specimens must be submitted when multiple tests are ordered. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	-Unacceptable:M4-RT -Unacceptable: [NAME], [NAME] (Pleural Fluid, Pericardial Fluid, or others) Due to stability (Refrigerate 48 hours\Frozen NO\Ambient NO) | Culture methods for M. pneumoniae are relatively insensitive and a negative result does not exclude mycoplasma infection. Molecular detection with PCR is more sensitive in the acute phase of illness.   Test Performed by: Focus Diagnostics, Inc.                             5785 Corporate Avenue                             Cypress, CA   90630-4750 | Monday through Sunday | 28-30 days | 30-32 days | 1 | 87109 |  |  |  |  | Focus Diagnositics, Inc.
MPC | [NAME] | VARIES | Varies |  |  |  | Frozen | 30 days
MPC | Order Question | Z2074 | Source |  | Plain Text
MPC | Result | Z2074 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MPC | Result | Z0352 | Culture Status | Culture Status | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MPC | Result | Z0353 | M Pneumoniae Culture | M Pneumoniae Culture | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 199943d1355368580-help-a-teacher-day-how-to-pull-data-from-a-sheet-to-enter-in-a-calendar-example1
Sheet: Friday

Date: Friday |  | 2012-12-15 00:00:00 |  | Daily Student Tracking Report
Student | On Time |  | On Task |  | Response |  | Talking |  | Disruption |  | Gum/food |  | Homework |  | Classwork |  | Absent |  | Tardy |  | Total (day)
Student1 | 0.5 | 0.7 | 0.5 | 2 | 0.5 | 0.5 | -0.5 | -0.5 | -0.5 | -1 | -1.5 | -0.5 | 2 | 1 | 1 | 1 | -0.5 | -0.5 | -0.5 | -2
Student2
Student3
Student4
Student5
Student6
Student7
Student8
Student9
Student10
Student11
Student12
Student13
Student14
Student15
Student16
Student17
Student18
Notes for Principal / Parent   |        Nòt pou Direktè / Paran              |        Notas para el Director / Padres  √
Name | Time | Reason      |      Rezon ki fè      |      Razón
Spreadsheet: 867402d1714231080-count-reg-with-condition-and-unique-dates-criteria-excel_help
Sheet: Sheet1

Reg | Date | Condition
GBE2889P | 2023-06-04 00:00:00 | YES
GBE2910H | 2023-06-04 00:00:00 | YES
GBE29P | 2023-01-02 00:00:00 | YES |  | GBE29P | 2
GBE29P | 2023-03-03 00:00:00 | YES |  | GBE7089T | 1
GBE3013Y | 2023-02-03 00:00:00 | NO |  | GBF2643Z | 1
GBE4342J | 2023-07-07 00:00:00 | YES |  | GBF963B | 2
GBE4801K | 2023-07-30 00:00:00 | NO |  | GBG57E | 1
GBE7089T | 2023-08-03 00:00:00 | YES
GBF963B | 2023-04-12 00:00:00 | YES
GBF2461T | 2023-05-05 00:00:00 | YES
GBE29P | 2023-01-02 00:00:00 | YES
GBF2643Z | 2023-08-05 00:00:00 | YES
GBG57E | 2023-08-08 00:00:00 | NO
[NAME]T | 2023-06-04 00:00:00 | YES
GBF963B | 2023-09-12 00:00:00 | YES
GBF2661E | 2023-07-03 00:00:00 | YES
GBG57E | 2023-08-08 00:00:00 | YES
YN963T | 2023-03-06 00:00:00 | YES
GBF2643Z | 2023-04-20 00:00:00 | NO
GBE7089T | 2023-08-03 00:00:00 | YES
Spreadsheet: 212956d1360295013-excel-report-from-many-categaories-and-have-a-summary-help
Sheet: lists

years |  | properties |  | categories
2011 |  | unclaimed |  | rental income
2012 |  | Unit 37 |  | **Purchased amount**
2013 |  | Unit 61 |  | advertising for tenants
2014 |  | Unit ## |  | body corporate fees and charges
2015 |  | Budget |  | cleaning
 |  |  |  | council rates
 |  |  |  | insurance
 |  |  |  | interest on loan(s)
 |  |  |  | legal expenses
 |  |  |  | property agent fees/commission
 |  |  |  | repairs and maintenance
 |  |  |  | capital works (special building write-off) deduction
 |  |  |  | water charges
 |  |  |  | Renovations
 |  |  |  | Furniture
 |  |  |  | Bathroom Renovation
 |  |  |  | Kitchem Renovation
 |  |  |  | Living and Bedroon Renovation
 |  |  |  | Buying Costs
Spreadsheet: 847783d1698657883-conditional-formatting-training-certificate-expiration-dates-course-matrix-august-2023
Sheet: First Aid

 |  | First Aid
 |  | (3 Years)
 | Name | Course | Date of course | Date of renewal
 | [NAME] | First Aid at work | N/A | Not required |  |  | Key
 | [NAME] | First Aid at work | 2022-02-14 00:00:00 | 2025-02-14 00:00:00 |  |  |  | Not due
 | [NAME] | First Aid at work | N/A | Not required |  |  |  | Overdue
 | [NAME] | First Aid at work | N/A | Not required |  |  |  | Due within the next week
 | [NAME] | First Aid at work | N/A | Not required |  |  |  | Required
 | [NAME] | First Aid at work | N/A | Not required |  |  |  | Not Required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | 2022-02-14 00:00:00 | Not required
 | Greg Love | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] Parkinson | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | 2022-02-14 00:00:00 | 2025-02-14 00:00:00
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | 2021-10-21 00:00:00 | 2024-10-21 00:00:00
 | [NAME] | First Aid at work | N/A | Not required
 | [NAME] | First Aid at work | N/A | Not required
Spreadsheet: michelle_lokay__26650__TW Supply
Sheet: Sheet1

 | Major [NAME] |  | MMbtu/d
Agave
 | Bitter Lakes |  | 35000
 | Red Bluff |  | 35000
 | Atoka |  | 110000
Arco
 | Abo Plant |  | 22000
Conoco
 | Maljamar Plant |  | 50000
Duke Energy Field Services
 | Artesia |  | 23000
 | Zia |  | 36000
 | Hobbs |  | 45000
 | Crawford Compressor |  | 60000
 | WT-1 Compressor |  | 6000
EOG Resources
 | Pronghorn |  | 30000
 | Pure Gold |  | 1500
 | Pitchfork |  | 10000
 | Triste Draw |  | 9500
Piblic Service New Mexico
 | Maljamar |  | 12000
[NAME]
 | Kermit Plant |  | 75000
Total
Spreadsheet: 115511d1311097833-countif-with-dates-copy-of-book2
Sheet: Sheet1

Due Date | Actual Date
2011-01-01 00:00:00 | 2010-12-29 00:00:00
2011-01-02 00:00:00 | 2010-12-31 00:00:00
2011-01-03 00:00:00 | 2011-01-02 00:00:00
2011-01-04 00:00:00 | 2011-01-04 00:00:00
2011-01-05 00:00:00 | 2011-01-06 00:00:00
2011-01-06 00:00:00 | 2011-01-08 00:00:00
2011-01-07 00:00:00 | 2011-01-10 00:00:00
2011-01-08 00:00:00 | 2011-01-12 00:00:00
2011-01-09 00:00:00 | 2011-01-09 00:00:00
2011-01-10 00:00:00 | 2011-01-09 00:00:00
2011-01-11 00:00:00 | 2011-01-18 00:00:00
2011-01-12 00:00:00 | 2011-01-20 00:00:00
Spreadsheet: 784486d1655759286-pull-associated-value-from-hierachical-tree-using-formula-2022-06-20-oeldere-mancolt-genus-species-data
Sheet: Sheet1

Data/Tree | Order | Family | Genus |  | Order | Family | Genus | Help 1
Pelecaniformes
Threskiomithidae
Geronticus
Geronticus eremita | Pelecaniformes | Threskiomithidae | Geronticus
Geronticus calvus | Pelecaniformes | Threskiomithidae | Geronticus
Bostrychia
Bostrychia olivacea | Pelecaniformes | Threskiomithidae | Bostrychia
Bostrychia bocagei | Pelecaniformes | Threskiomithidae | Bostrychia
Bostrychia rara | Pelecaniformes | Threskiomithidae | Bostrychia
Bostrychia hagedash | Pelecaniformes | Threskiomithidae | Bostrychia
Bostrychia carunculata | Pelecaniformes | Threskiomithidae | Bostrychia
Theristicus
Theristicus caerulescens | Pelecaniformes | Threskiomithidae | Theristicus
Theristicus caudatus | Pelecaniformes | Threskiomithidae | Theristicus
Theristicus melanopis | Pelecaniformes | Threskiomithidae | Theristicus
Aelecaniformes
Ahreskiomithidae
Aeronticus
aeronticus eremita
aeronticus calvus
Spreadsheet: 708911d1608069994-sum-of-selective-cells-by-logic-in-a-row-test7
Sheet: Test

 | Code-10 | Code-20 | Name | Code | Name | Length | Name | Code |  | Length | Name | Code |  | Length | Name | Code |  | Length | Name | Code | Length
 | 700 | 300 | ABC | 10 |  | 100 | ABC | 10 |  | 200 | BCA | 20 |  | 250 | ABC | 10 |  | 400 | BCA | 20 | 50
Q1 | SUM of cells before the code ABC=300+100+250 =650
Solution
Function |  | SUMPRODUCT
 | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name
 | 100000 | BAT-Bulk | 100 | ABC | 120000 | CAT | 400 | ABC | 103000 | BAT-Bulk | 50 | ABC | 100400 | BAT-Bulk | 200 | ABC | 100600 | RAT | 100 | ABC
Q2 | SUM of cells before the code ABC & has BAT in the cell before=100+50+200 =350
Spreadsheet: 140445d1328748531-schedule-making-find-first-and-last-occurance-of-value-schedules
Sheet: CopyMe

 | # of Days | 2012-03-01 00:00:00
 | 00:00:00 | Employee A
 | 00:30:00 | Employee A
 | 01:00:00 | Employee A
 | 01:30:00 | Employee A
 | 02:00:00 | Employee A
 | 02:30:00 | Employee A
 | 03:00:00 | Employee A
 | 03:30:00 | Employee A
 | 04:00:00 | Employee A
 | 04:30:00 | Employee A
 | 05:00:00 | Employee A
 | 05:30:00 | Employee A
 | 06:00:00 | Employee A
 | 06:30:00 | Employee A
 | 07:00:00 | Employee A
 | 07:30:00 | Employee A
 | 08:00:00 | Employee B
 | 08:30:00 | Employee B
 | 09:00:00 | Employee B
 | 09:30:00 | Employee B
 | 10:00:00 | Employee B
 | 10:30:00 | Employee B
 | 11:00:00 | Employee B
 | 11:30:00 | Employee B
 | # of Days
 | 12:00:00 | Employee B
 | 12:30:00 | Employee B
 | 13:00:00 | Employee B
 | 13:30:00 | Employee B
 | 14:00:00 | Employee B
 | 14:30:00 | Employee B
 | 15:00:00 | Employee B
 | 15:30:00 | Employee B
 | 16:00:00 | Employee B
 | 16:30:00 | Employee B
 | 17:00:00 | Employee C
 | 17:30:00 | Employee C
 | 18:00:00 | Employee C
 | 18:30:00 | Employee C
 | 19:00:00 | Employee C
 | 19:30:00 | Employee C
 | 20:00:00 | Employee C
 | 20:30:00 | Employee C
 | 21:00:00 | Employee C
 | 21:30:00 | Employee C
 | 22:00:00 | Employee A
 | 22:30:00 | Employee A
 | 23:00:00 | Employee A
 | 23:30:00 | Employee A
 | # of Days
*IHSS | Employee A
C4C | Employee B
C4C | Employee C
C4C | Employee D
C4C
C4C
C4C
 | Staff | First Half | Second Half | Total
*IHSS
C4C
C4C
C4C
C4C
C4C
 | Total
 | Hours/Day
 | C4C Hours
 | IHSS Hours
Spreadsheet: 644931d1570814445-freight-cost-calculation-based-on-weight-and-distance-sample-freight-analysis
Sheet: CalcSheet

 |  |  | OID | Weight | Distance (Miles) | Current Fuel Rate | Cost | Cost + FuelChg
 |  |  | 3634 | 138 | 74.666448
 |  |  | 3676 | 368 | 1052.471069 | 2.45
 |  |  | 3718 | 270 | 732.056664 | 2.05
 |  |  | 3760 | 213 | 279.1653
 |  |  | 3802 | 100 | 1512 | 3.3
 |  |  | 3886 | 348 | 2142.846402 | 3
 |  |  | 3928 | 333 | 437.544117
Spreadsheet: 848316d1699039270-sumifs-index-match-two-criteria-indirect-formula-help-budgets
Sheet: Summary

 | 2023
 | B | C | D
3 | Department | GL Code
4 | 604 | 535110
5 | 605 | 535110
6 | 611 | 535110
 | 604 | 535130
 | 605 | 535130
 | 611 | 535130
 | 604 | 535210
 | 605 | 535210
 | 611 | 535210
 | 604 | 535220
 | 605 | 535220
 | 611 | 535220
 | 604 | 536010
 | 605 | 536010
 | 611 | 536010
 | 604 | 536020
 | 605 | 536020
 | 611 | 536020
 | 604 | 536030
 | 605 | 536030
 | 611 | 536030
Spreadsheet: 90184d1289941884-a-word-to-a-number-equipmentstatus
Sheet: Sheet1

Item | Status
[NAME] | being repaired |  |  |  |  | Total | Available | broken | on site | being repaired
VCR2 | Available |  |  |  | VCR
VCR3 | broken |  |  |  | Radio
VCR4 | on site |  |  |  | TV
VCR5 | being repaired
VCR6 | broken
Radio1 | Available
Radio2 | Available
Radio3 | Available
Radio4 | on site
Radio5 | being repaired
[NAME] | Available
TV2 | Available
TV3 | Available
TV4 | broken
TV5 | being repaired
TV6 | on site
TV7 | Available
TV8 | on site
Spreadsheet: 74204d1274782176-copy-and-paste-to-a-new-line-invoicingtool
Sheet: Running Total

Date | Invoice # | Customer Name | For | Sub-Total | PST | GST | Total
2010-05-25 00:00:00 | 1 | Devstudios | Landscaping | 3573.32 | 178.67 | 178.67 | 3930.66
2010-05-25 00:00:00 | 2 | Devstudios | Landscaping | 3573.32 | 178.67 | 178.67 | 3930.66
2010-05-25 00:00:00 | 3 | Devstudios | Landscaping | 3573.32 | 178.67 | 178.67 | 3930.66
2010-05-25 00:00:00 | 4 | Devstudios | Landscaping | 3573.32 | 178.67 | 178.67 | 3930.66