tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 804944d1668442916-want-to-sum-values-across-multiple-sheets-with-multiple-criteria-chemical-usage
Sheet: 3-May-2022

Magnacide Application Spreadsheet
Date: |  |  | Application Method |  | Applicator |  | Certificate #
 |  |  | Injection |  | [NAME] |  | [NAME]
P.C.P. # | 10948 |  | Water Coordinator |  | [NAME]
Tank Serial # | C3430 |  |  |  | [NAME]
Location (County) |  |  | Start Time | am | End Time | am | Total Time (min)
 |  |  |  | pm |  | pm
Land Location |  |  |  | Pest Controlled
 |  |  | Algae |  | Submerged Aquatic
Location ID (Lateral) |  |  | Canal Flow (ft³/s) |  | Water Temperature
Precipitation (Y/N) |  |  | Orifice |  | Reg  |  PSI  |  Tank |  | Volume from Chart
Y | N
Start Wind Speed/Direction (km/h) |  |  | PPM Magnacide |  | PPM Acrolein |  | Treatment Rate (GPM)
End Wind Speed/Direction (km/h) |  |  | [NAME] |  | End Gal |  | Total Usage
 |  |  |  |  |  |  | 10
Notes
Date: |  |  | Application Method |  | Applicator |  | Certificate #
 |  |  | Injection |  | [NAME] |  | [NAME]
P.C.P. # | 10948 |  | Water Coordinator |  | [NAME]
Tank Serial # | AA954248 |  |  |  | [NAME]
Location (County) |  |  | Start Time | am | End Time | am | Total Time (min)
 |  |  |  | pm |  | pm
Land Location |  |  |  | Pest Controlled
 |  |  | Algae |  | Submerged Aquatic
Location ID (Lateral) |  |  | Canal Flow (ft³/s) |  | Water Temperature
Precipitation (Y/N) |  |  | Orifice |  | Reg  |  PSI  |  Tank |  | Volume from Chart
Y | N
Start Wind Speed/Direction (km/h) |  |  | PPM Magnacide |  | PPM Acrolein |  | Treatment Rate (GPM)
End Wind Speed/Direction (km/h) |  |  | [NAME] |  | End Gal |  | Total Usage
 |  |  |  |  |  |  | 10
Notes
Spreadsheet: 137288d1327040190-can-vlookup-return-multiple-non-empty-values-from-a-table-table_example
Sheet: Sheet1

Components | Product1 | Product2 | Product3 | Product4 | Product5
Comp1 | x | x
Comp2 |  | x |  | x
[NAME] |  |  | x
Comp4 |  |  |  | x | x
Comp5 |  | x |  |  | x
User select Component: | Comp2 | <-- VLOOKUP on this value, chosen from [NAME]-down
Component included in: | Product2 | Product4 | <-- Results could appear like this.
Spreadsheet: 65469d1266188555-pivot-percentage-of-subtotal-and-total-budget
Sheet: JAN

 | INCOME |  |  |  | EXPENSE |  |  |  | SPENDING
[NAME] | AMOUNT | DATE |  | [NAME] | AMOUNT | DATE |  | [NAME] | AMOUNT | DATE
INCOMEA | 1500 | 2010-01-05 00:00:00 |  | ELECTRIC | 114 | 2010-01-14 00:00:00 |  | GROCERY | 100 | 2010-01-02 00:00:00
INCOMEA | 1400 | 2010-01-10 00:00:00 |  | WATER | 50 | 2010-01-15 00:00:00 |  | FASTFOOD | 7 | 2010-01-05 00:00:00
INCOMEB | 800 | 2010-01-17 00:00:00 |  | WATER | 58 | 2010-01-17 00:00:00 |  | FASTFOOD | 15 | 2010-01-07 00:00:00
INCOMEC | 450 | 2010-01-25 00:00:00 |  | CABLE | 33 | 2010-01-20 00:00:00 |  | CLEANERS | 23 | 2010-01-26 00:00:00
TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
Spreadsheet: 200155d1355432371-finding-source-data-road-conditions-2012
Sheet: RoadData

Date Entered | Entered By | Forest | Road No | Defect | Affected Length (m) | Notes | Harvest Year
2012-11-22 16:56:48 | [NAME] | Caberston | T251a | Patching | 50 | Entrance to Forest
2012-11-22 16:56:48 | [NAME] | Caberston | T251b | See Notes | 500 | Ditch Scrape and Patch
2012-11-22 16:56:48 | [NAME] | Caberston | T251 A | Rebuild | 400 | Road Gone
2012-11-22 16:56:48 | [NAME] | Caberston | T252a | See Notes | 150 | Widen Hairpin prior to [NAME]
2012-11-22 16:56:48 | [NAME] | Caberston | T252b | [NAME] | 1 | Replace 12m L 450dia Culvert
2012-11-22 16:56:48 | [NAME] | Caberston | T252b | See Notes | 1700 | Ditch Scrape and Spot Patch
2012-11-22 16:56:48 | [NAME] | Caberston | T254 | [NAME] | 800 | Not done on last Upgrade
2012-11-22 16:56:48 | [NAME] | Caberston | T253a | Upgrade | 2100 | 250m Patching to make more suitable for light Vehicles
2012-11-22 16:56:48 | [NAME] | Caberston | T253b | Road OK | 2100 | Upgraded 2008
2012-11-25 12:36:37 | [NAME] | [NAME] | T31 | Upgrade | 2100 | Due 2013 sections of widening also required | 2014
2012-11-25 12:36:37 | [NAME] | [NAME] | T32 | Rebuild | 430 | Road too Narrow and Steep | 2014
2012-11-25 12:36:37 | [NAME] | [NAME] | T33 | Upgrade | 1250 | Due 2013 sections of widening also required | 2014
2012-12-05 16:58:28 | [NAME] | [NAME] | T31 | [NAME] | 1 | 300dia 9m length
Spreadsheet: 793114d1661324494-return-date-in-cell-based-columns-a-c-find-the-date-1-ans-3
Sheet: Start Stop

EOS Report |  |  |  |  | Search Information
Build Date | Start # | Stop # | Shift |  | Shipping Date | Number |  | Return Date | Shift
2022-08-01 00:00:00 | 291 | 621 | 1 |  | 2022-08-08 00:00:00 | 354
2022-08-01 00:00:00 | 622 | 853 | 2
2022-08-02 00:00:00 | 854 | 7 | 1
2022-08-02 00:00:00 | 8 | 353 | 2
2022-08-03 00:00:00 | 354 | 701 | 1
2022-08-03 00:00:00 | 702 | 100 | 2
2022-08-04 00:00:00 | 101 | 369 | 1
2022-08-04 00:00:00 | 370 | 748 | 2
2022-08-05 00:00:00 | 749 | 10 | 1
2022-08-05 00:00:00 | 11 | 301 | 2
2022-08-08 00:00:00 | 302 | 599 | 1
2022-08-08 00:00:00 | 600 | 999 | 2
Spreadsheet: 24484d1214920315-colour-cells-based-on-condition-book3
Sheet: Sheet1

 |  | PO number | BCV/SSL | Start Date |  | Description | Value
2008-04-24 00:00:00 | 1 | B54794 | BCV | 2008-04-03 00:00:00 |  | ` | 180400
2008-04-24 00:00:00 | 2 | NA | BCV | 2008-05-01 00:00:00 |  | extension of body - [NAME] | 21600
2008-04-25 00:00:00 | 4 | NA | BCV | 2008-05-01 00:00:00 |  | extension of body - Brian Laws | 14937
2008-04-25 00:00:00 | 5 | NA | SSL | 2007-08-20 00:00:00 |  | New starter of Body - Bruce Littlewood | 50000 |  | [NAME] | 234 | A5 -H5 should go green  when data is entered in K5 and the same should happen as column K is populated
2008-04-25 00:00:00 | 6 | NA | SSL | 2008-05-03 00:00:00 |  | Extension of Body Bruce Little wood | 17822 | 0 | [NAME] | 234
2008-04-25 00:00:00 | 7 | NA | SSL | 2008-04-28 00:00:00 |  | New starter of Body - Carlton Stephenson | 7600
2008-04-25 00:00:00 | 8 | B71626 | BCV | 2008-04-21 00:00:00 | Griffens | New starter of [NAME] | 11550 | 1 | [NAME] | 2345
2008-04-25 00:00:00 | 9 | B53441 | BCV |  |  | Uplift for Data Alignment | 7500
2008-04-25 00:00:00 | 10 |  |  |  |  | AMIS Assessment for 3 days | 4450
2008-04-25 00:00:00 | 11 |  |  | [NAME] to Aug 08 |  | Annual Load Plan & Annex II Documents | 160670.8
2008-04-25 00:00:00 | 12 |  |  | 2008-09-22 00:00:00 |  | Enterprise workshop |  | 0 | [NAME] | 678
2008-04-25 00:00:00 | 13 |  |  |  |  | ecological work Rickmansworth to Chorleywood M036 EM10 | 4076.5
Spreadsheet: 83541e92-f40d-4e86-b209-359f36746c3c
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
38836922 | 2013-12-05 00:51:30 | AXIS | 0 | 6 | 10 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
38837267 | 2013-12-05 01:37:30 | ALLIES | 1 | 10 | 7 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
38837773 | 2013-12-05 02:01:34 | ALLIES | 0 | 2 | 6 | 923434 | [NAME] | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
38837934 | 2013-12-05 02:19:53 | AXIS | 0 | 4 | 6 | 923434 | [NAME] | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
38838875 | 2013-12-05 04:02:05 | ALLIES | 1 | 6 | 1 | 1456138 | player1456138 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
38839084 | 2013-12-05 04:33:02 | AXIS | 1 | 6 | 1 | 1456138 | player1456138 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 226055d1365232524-excel-sales-invoice-tracker-sales-invoice-tracker
Sheet: Invoices - Main

 | Invoices EUR
 | Invoice # | Company | Invoice Date | Project | Tax Rate | Other | Deposit | Detail Total | Invoice Total | Notes
 | 13-04-10-$008 | 1 - customer a | 2013-04-10 00:00:00 | project c
 | 13-04-01-$007 | 1 - customer a | 2013-04-01 00:00:00 | project c
 | 13-04-04-€006 | 99 - customer b | 2013-04-04 00:00:00 | project b |  |  |  |  |  | SENT
 | 13-03-27-$005 | 1 - customer a | 2012-03-27 00:00:00 | project c
 | 13-03-22-$004 | 1 - customer a | 2013-03-22 00:00:00 | project a
 | 13-03-21-$003 | 1 - customer a | 2013-03-21 00:00:00 | project y
 | Totals
Spreadsheet: 327857d1403704448-dates-in-gant-pivot-table-query-for-vidiotdave
Sheet: Sheet1

skilled person | start day | end day | total days (inc) |  | 2014-06-20 00:00:00 | 2014-06-21 00:00:00 | 2014-06-22 00:00:00 | 2014-06-23 00:00:00 | 2014-06-24 00:00:00 | 2014-06-25 00:00:00 | 2014-06-26 00:00:00 | 2014-06-27 00:00:00 | 2014-06-28 00:00:00 | 2014-06-29 00:00:00 | 2014-06-30 00:00:00 |  |  | DATE | Suppliers Booked on Day
plumber | 2014-06-25 00:00:00 | 2014-06-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-20 00:00:00
carpenter | 2014-06-20 00:00:00 | 2014-06-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-21 00:00:00
plumber | 2014-06-21 00:00:00 | 2014-06-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-22 00:00:00
roofer | 2014-06-21 00:00:00 | 2014-06-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-23 00:00:00
carpetlayer | 2014-06-21 00:00:00 | 2014-06-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-24 00:00:00
carpetlayer | 2014-06-21 00:00:00 | 2014-06-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-26 00:00:00
 |  |  |  |  |  |  |  |  | FORMULA PLEASE???? |  |  |  |  |  |  |  |  | 2014-06-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-29 00:00:00
 |  | total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-30 00:00:00
Spreadsheet: 835831d1688884593-help-to-modify-conditional-formatting-formulas-that-display-on-time-and-late-based-on-time-conditional-formatting-sample-hd
Sheet: Sheet1

Date/Scheduled Depart time | Start Time | Actual [NAME] time
2023-07-01 10:30:00 | 10:45:00 | 10:30:00
2023-07-01 10:30:00 | 10:00:00 | 10:30:00
2023-07-01 10:30:00 | 10:30:00 | 10:30:00
2023-07-02 01:30:00 | 22:00:00 | 01:30:00
2023-07-02 02:30:00 | 23:45:00 | 02:30:00
2023-07-02 03:30:00 | 03:29:00 | 03:30:00
Spreadsheet: 9e12236c-4e92-43b8-b8d9-52b91229f067
Sheet: ENGL 413

COURSE ASSESSMENT MATRIX
Engl 413 News Writing Prerequisites: Engl 113. This course is designed to provide students with the basic skills and knowledge they need in order to engage effectively in news gathering and news writing. Students will learn style rules and application, reporting methods, and journalistic ethics. 3 credits
Goal:  The goal of this course is to teach students how to write various types of news stories.
Objective | Assessment Method | Desired Result | Corrective Action
Learn the basic concepts of news gathering and news writing | Weekly Assignments                                                          Class Participation  Writing projects scored with Rubric | Weekly Assignments Completed                                       80% students pass writing assignments | [NAME] Weekly Assignments                      Revise Rubrics
Learn style rules and application | Weekly Assignments                                                          Class Participation  Writing projects scored with Rubric | Weekly Assignments Completed                                       80% students pass writing assignments | [NAME] Weekly Assignments                      Revise Rubrics
Understand reporting methods and ethics | Weekly Assignments                                                          Class Participation  Writing projects scored with Rubric | Weekly Assignments Completed                                       80% students pass writing assignments | [NAME] Weekly Assignments                      Revise Rubrics
Learn the basic forms of news writing, particularly the inverted pyramid news story | Weekly Assignments                                                          Class Participation  Writing projects scored with Rubric | Weekly Assignments Completed                                       80% students pass writing assignments | [NAME] Weekly Assignments                      Revise Rubrics
Date | Form of Assessment and Actions Taken
Spring 2011 | Syllabus Reviewed --Mainly looked to see that all sections on checklist were present.  Scheduled to review content during the Fall 2011 semester.
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Spreadsheet: larry_campbell__20970__PG&E Samples
Sheet: PG&E Page 5

CONFIDENTIAL
[NAME] and PG&E Samples and Analytical Results
Date | Sample ID |  | Volume Drained |  | Comments |  |  |  | PG&E PCB | TW PCB | Location of sample point
 |  |  |  |  |  |  |  |  |  |  | Filter Scrubbers Downstream of
1999-04-01 00:00:00 | SLX-TW | 4-1-99-L | 0 |  | No liquid for sample |  |  |  |  |  | Solexol Plant
 |  |  |  |  |  |  |  |  |  |  | TW's Filter Scrubber at TW/PG&E
1999-04-01 00:00:00 | PGE-TW2 | 4-1-99-L | 80 oz |  |  |  |  |  |  |  | Metering Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Seperator at PG&E's
1999-04-01 00:00:00 | PGE-Top3 | 4-1-99-L | 32 oz |  |  |  |  |  |  |  | Compressor Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line A TCS
1999-04-01 00:00:00 | PGE-A6 | 4-1-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | Downstream Scrubber
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line B TCS
1999-04-01 00:00:00 | PGE-B6 | 4-1-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | Downstream Scrubber
1999-04-01 00:00:00 | PGE 10.84A | 4-1-99-L | 3 oz |  |  |  |  |  |  |  | PG&E's 34" Line A
1999-04-01 00:00:00 | PGE 10.84B | 4-1-99-L | 2 oz |  |  |  |  |  |  |  | PG&E's 34" Line B
1999-04-01 00:00:00 | PGE 8.58A | 4-1-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | PG&E's 34" Line B
1999-04-01 00:00:00 | PGE-TW4 | 4-1-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 1st Siphon
1999-04-01 00:00:00 | PGE-TW5 | 4-1-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 2nd siphon
1999-04-01 00:00:00 | PGE-TW6 | 4-1-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 3rd Siphon
 |  |  |  |  |  |  |  |  |  |  | Filter Scrubbers Downstream of
1999-04-08 00:00:00 | SLX-TW | 4-8-99-L |  |  |  |  |  |  |  |  | Solexol Plant
 |  |  |  |  |  |  |  |  |  |  | TW's Filter Scrubber at TW/PG&E
1999-04-08 00:00:00 | PGE-TW2 | 4-8-99-L |  |  |  |  |  |  |  |  | Metering Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Seperator at PG&E's
1999-04-08 00:00:00 | PGE-Top3 | 4-8-99-L |  |  |  |  |  |  |  |  | Compressor Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line A TCS
1999-04-08 00:00:00 | PGE-A6 | 4-8-99-L |  |  |  |  |  |  |  |  | Downstream Scrubber
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line B TCS
1999-04-08 00:00:00 | PGE-B6 | 4-8-99-L |  |  |  |  |  |  |  |  | Downstream Scrubber
1999-04-08 00:00:00 | PGE 10.84A | 4-8-99-L |  |  |  |  |  |  |  |  | PG&Es 34" Line A
1999-04-08 00:00:00 | PGE 10.84B | 4-8-99-L |  |  |  |  |  |  |  |  | PG&E's 34" Line B
1999-04-08 00:00:00 | PGE 8.58A | 4-8-99-L |  |  |  |  |  |  |  |  | PG&E's 34" Line B
1999-04-08 00:00:00 | PGE-TW4 | 4-8-99-L |  |  |  |  |  |  |  |  | TW 20" 1st Siphon
1999-04-08 00:00:00 | PGE-TW5 | 4-8-99-L |  |  |  |  |  |  |  |  | TW 20" 2nd siphon
1999-04-08 00:00:00 | PGE-TW6 | 4-8-99-L |  |  |  |  |  |  |  |  | TW 20" 3rd Siphon
Spreadsheet: 701294d1603700551-how-to-divide-some-value-specific-number-of-times-in-different-number-of-cells-excel
Sheet: Sheet1

COMPANY |  |  |  |  |  |  |  |  |  |  |  |  |  | BUYER
2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | total kupovina | #months? | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | rate
 |  |  |  |  |  |  | 400 |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 200 |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  | 100 |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 100 |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
200 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 300 |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  | 100 | 100 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 50 |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 25 | 25 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 25 | 25 |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 50 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 | 75 | 75 |  |  |  |  |  |  |  |  | 75
Spreadsheet: 467817d1466958830-asking-for-help-to-rearrage-the-form-data-to-a-new-format-example
Sheet: Sheet1

goods_no | goods_desc | buyer 1 | buyer 2 | buyer 3
2 | rice |  | 3 | 1
3 | water | 1 | 3
5 | oil | 1 |  | 2
7 | snacks |  | 2 | 3
9 | drinks | 2 |  | 3
goods_no | goods_desc | buyer | quantity
Spreadsheet: 186697d1350155293-itemlist-orderlist-orderlist
Sheet: ItemList

 | Company | Retailer
 | OrderDate | 10-10-2012
 | OrderNR | 4556
 | ItemNr | ItemDesc | QtyOrder | Price | TotPrice
Sweets
 | 110001 | Item 1 | 5 | 2
 | 110002 | Item 2 |  | 5
 | 110003 | Item 3 |  | 2
 | 110004 | Item 4 | 5 | 1
 | 110005 | Item 5 |  | 3
 | 110006 | Item 6 | 10 | 1
 | 110007 | Item 7 |  | 5
Sodas
 | 110008 | Item 8 |  | 2
 | 110009 | Item 9 |  | 2
 | 110010 | Item 10 | 3 | 2
 | 110011 | Item 11 |  | 2
 | 110012 | Item 12 | 1 | 2
 | 110013 | Item 13 |  | 2
 | 110014 | Item 14 |  | 2
Snacks
 | 110015 | Item 15 |  | 6
 | 110016 | Item 16 |  | 4
 | 110017 | Item 17 | 1 | 2
 | 110018 | Item 18 |  | 5
 | 110019 | Item 19 | 10 | 4
 | 110020 | Item 20 |  | 3
Spreadsheet: 45568d1244332585-protecting-all-but-test01
Sheet: Sheet1

name | Quanity | [NAME]
previous | 0 | 0
aaa |  | 0
bbb |  | 0
[NAME] | 1 | 30
ddd |  | 0
eee |  | 0
[NAME] |  | 0
ggg |  | 0
hhh | 1 | 30
iii |  | 0
jjj |  | 0
kkk |  | 0
lll | 1 | 30
mmm |  | 0
nnn |  | 0
ooo |  | 0
ppp |  | 0
qqq |  | 0
 |  | 0
 |  | 0
 |  | 0
 | 3 | 90
 | 3 | 90
Spreadsheet: 43a55e33-11ae-4b11-a76d-0ba94cda2bb5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6515 | 35160 | [NAME] | Huber | GER | 114 | 00:21:02 | 00:01:33 | 01:15:36 | 00:01:00 | 00:46:38 | 1 | 02:25:50
6515 | 24957 | [NAME] | Dickinson | GBR | 113 | 00:22:07 | 00:00:43 | 01:19:27 | 00:01:09 | 00:43:04 | 2 | 02:26:32
6515 | 21752 | Kaarel | [NAME] | EST | 115 | 00:26:22 | 00:01:03 | 01:20:13 | 00:01:16 | 00:46:54 | 3 | [NAME]
Spreadsheet: 731657d1620486509-v-lookup-based-on-different-sheets-using-data-validation-list-test-sheets-ans
Sheet: Jun 21

Enter 1st of Month Here -> | 2021-06-01 00:00:00 | CO | VO 1 | VO 2 | VO 3 | VO 4 | VO 5 | VO 6
 | Morning | a june | v1am a june | v2am a june | v3am a june | v4am a june | v5am a june | v6am a june
 | Afternoon |  | v1pm a june | v2pm a june | v3pm a june | v4pm a june | v5pm a june | v6pm a june
 | Morning | b june | v1am b june | v2am b june | v3am b june | v4am b june | v5am b june | v6am b june
 | Afternoon |  | v1pm b june | v2pm b june | v3pm b june | v4pm b june | v5pm b june | v6pm b june
 | Morning | c june | v1am c june | v2am c june | v3am c june | v4am c june | v5am c june | v6am c june
 | Afternoon |  | v1pm c june | v2pm c june | v3pm c june | v4pm c june | v5pm c june | v6pm c june
 | Morning | d june | v1am d june | v2am d june | v3am d june | v4am d june | v5am d june | v6am d june
 | Afternoon |  | v1pm d june | v2pm d june | v3pm d june | v4pm d june | v5pm d june | v6pm d june
 | Morning | e june | v1am e june | v2am e june | v3am e june | v4am e june | v5am e june | v6am e june
 | Afternoon |  | v1pm e june | v2pm e june | v3pm e june | v4pm e june | v5pm e june | v6pm e june
 | Morning | f june | v1am f june | v2am f june | v3am f june | v4am f june | v5am f june | v6am f june
 | Afternoon |  | v1pm f june | v2pm f june | v3pm f june | v4pm f june | v5pm f june | v6pm f june
 | Morning | g june | v1am g june | [NAME] g june | v3am g june | v4am g june | v5am g june | v6am g june
 | Afternoon |  | v1pm g june | v2pm g june | v3pm g june | v4pm g june | v5pm g june | v6pm g june
 | Morning | h june | v1am h june | v2am h june | v3am h june | v4am h june | v5am h june | v6am h june
 | Afternoon |  | v1pm h june | v2pm h june | v3pm h june | v4pm h june | v5pm h june | v6pm h june
Sat |  |  | v1am i may | v2am i may | v3am i may | v4am i may | v5am i may | v6am i may
SUN |  |  | v1pm i may | v2pm i may | v3pm i may | v4pm i may | v5pm i may | v6pm i may
Spreadsheet: 65118d1265847665-vlookup-with-potential-for-multiple-matches-mail-test
Sheet: Mail

Assigned Date | Received Date | CN | ID | EIP Name | [NAME] | File Handler ID
2010-02-03 00:00:00 | 2010-01-29 00:00:00 | 156581530 | 6 |  |  | LD0P
2010-02-03 00:00:00 | 2010-02-01 00:00:00 | 156553737 | 1 |  |  | MKNB
 |  | 156581531 |  |  |  | LD0P
 |  | 156553738 |  |  |  | MKNB
Spreadsheet: 102239d1300217687-excel-2007-merging-sorting-and-conditional-formatting-student-proficiency-tracking
Sheet: Class Master

Student Name |  | 1st Mid-Quarter | 1st Quarter | 2nd Mid-Quarter | 2nd Quarter | 3rd Mid-Quarter | 3rd Quarter | 4th Mid-Quarter
[NAME] |  | 0.719
TERRA MILROY |  | 0.719
CALEB AKERS |  | 0.656
[NAME] |  | 0.625
BRANDON EDWARDS |  | 0.594
DAVIANNE' HOLTON |  | 0.563
JULIE SHANKLE |  | 0.563
[NAME] |  | 0.563
[NAME] |  | 0.531
JAROD ASHBY |  | 0.5
KAYLEE DUNN |  | 0.438
[NAME] |  | 0.438
DUKE WARD |  | 0.344
REED PARKER |  | 0.313
[NAME] |  | 0.25
Spreadsheet: 733645d1621679059-if-condition-not-working-as-expected-help-if_condition2
Sheet: Sheet1

Ticket | Status 1 | Status 2 | Actual Status | Expected Result
33333 | Closed | Closed |  | Closed | Correct
33334 |  | Closed |  | Closed | Correct
33337 | Open |  |  | Open | Correct
33338 | Closed | Open |  | Open | Not Correct
33339 | Open | Closed |  | Closed | Correct
33340 | Open | Open |  | Open | Correct
Spreadsheet: 177056d1346175987-lookup-for-multiple-outputs-book1
Sheet: Sheet1

Raw Data |  |  |  | Output |  |  |  |  | any way shape or form of this output….does not have to be a cell per supplier, could be all suppliers in one cell divided by comma's
Part No | Supplier |  |  | Part No
1 | a |  |  | 1 | a | b | c | d
1 | b |  |  | 2 | a | b | d
1 | c |  |  | 3 | c | d | e
1 | d |  |  | 4 | a | e | c
2 | a |  |  | 5 | c
2 | b
2 | d
3 | c
3 | d
3 | e
4 | a
4 | e
5 | c