tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 879636d1727206327-extracting-data-from-profit-and-loss-statement-p-and-ls-qtr-2
Sheet: KODAK QTR2

 |  |  |  |  | Apr - Jun 24
 | Ordinary Income/Expense
 |  | Income |  |  |  |  |  | Payroll | 64865 | Total Exp | 88926
 |  |  | MISC INCOME |  | 11467.34 |  |  |  |  |  | 11467
 |  | Total Income |  |  |  |  |  | Benefit | 7592 |  |  |  |  | 11467.34
 |  | Expense |  |  |  |  |  |  |  |  |  |  |  | 4169
 |  |  | Advertising and Promotion |  | 789.65 |  |  | Rent | 12300 |  | 84757
 |  |  | Bank Service Charges
 |  |  |  | Mastercard/Visa Transaction Fee | 246.96
 |  |  | Total Bank Service Charges
 |  |  | Billing Expense |  | 1244.85
 |  |  | Cable, Internet & Telephone |  | 1118.55
 |  |  | Clinical Expense |  | 4012.92
 |  |  | Computer Software |  | 109.57
 |  |  | Copier Service Agreement |  | 95.57
 |  |  | Gifts/Flowers |  | 20
 |  |  | Health Insurance |  | 7126.77
 |  |  | Health Savings Account |  | 465
 |  |  | Insurance Expense
 |  |  |  | Cyber | 136.33
 |  |  |  | Liability | 1745.46
 |  |  |  | Life | 226.11
 |  |  |  | Workers Comp. | 261.54
 |  |  | Total Insurance Expense
 |  |  | Internet |  | 423.79
 |  |  | Lawn Services |  | 720
 |  |  | Meals and Entertainment |  | 257.73
 |  |  | Mileage Expense |  | 146.79
 |  |  | Payroll Expenses |  | 64864.74
 |  |  | Professional Development |  | 19.95
 |  |  | Professional Fees
 |  |  |  | Accounting | 435
 |  |  |  | Shredding Service | 40
 |  |  | Total Professional Fees
 |  |  | Rent Expense |  | 12300
 |  |  | Taxes
 |  |  |  | Franchise Tax | 983
 |  |  | Total Taxes
 |  |  | Telephone Expense |  | 58.82
 |  |  | Travel Expense |  | 719.46
 |  |  | Uniforms |  | 45.85
 |  |  | Utilities
 |  |  |  | Electric | 784.44
 |  |  |  | Gas | 303.64
 |  |  |  | Water | 262.02
 |  |  |  | Utilities - Other | 352.63
 |  |  | Total Utilities
 |  |  | Water
 |  |  |  | Bottled | 40.03
 |  |  |  | Water - Other | 35.94
 |  |  | Total Water |  |  |  |  |  | 100393
 |  | Total Expense
 | Net Ordinary Income
Net Income
Spreadsheet: 103568d1301331870-if-next-formula-example-day92
Sheet: Sheet1

Location | (All)
 | Data
Name | Sum of Acct # | Sum of Charges | Sum of Tip | Sum of Tax | Sum of Total
[NAME] | 1134 | 4 | 1 | 0.24 | 5.24
[NAME] | 2222 | 10 | 2 | 0.6 | 12.6
Grand Total | 3356 | 14 | 3 | 0.84 | 17.84
Spreadsheet: 868584d1715274516-records-processed-on-time-dates
Sheet: Sheet1

Record # | Date Received | Due Date | Date processed
1 | 2024-01-03 00:00:00 | 2024-01-06 00:00:00 | 2024-01-06 00:00:00
2 | 2024-01-10 00:00:00 | 2024-01-12 00:00:00 | 2024-01-12 00:00:00
3 | 2024-01-10 00:00:00 | 2024-01-15 00:00:00 | 2024-01-06 00:00:00
4 | 2024-01-14 00:00:00 | 2024-01-20 00:00:00 | 2024-01-19 00:00:00
5 | 2024-01-25 00:00:00 | 2024-01-29 00:00:00 | 2024-01-28 00:00:00
6 | 2024-02-04 00:00:00 | 2024-02-08 00:00:00 | 2024-02-06 00:00:00
7 | 2024-02-07 00:00:00 | 2024-02-13 00:00:00 | 2024-02-13 00:00:00
 | Month | 2024-01-24 00:00:00 | 2024-02-24 00:00:00
 | Records Received
 | Records processed on time
Spreadsheet: 841053d1693312565-help-required-to-restructure-an-excel-file-bom-bill-of-material-zone_1_test_bom_upload_anonymous
Sheet: Sheet1

Item | Part Number | BOM Structure | Description | QTY | REV | Vendor | Manufacturer | Assembly Number | On Hold | Spares | Order By | Notes | Illustrative
1 | Zone 1 |  |  | 1
1.1 | Assembly ABC |  | Assembly ABC | 1
1.1.1 | Part B |  | CLAMP | 4 |  |  |  | Assembly ABC
1.1.2 | Part C |  | HANGER | 2 |  |  |  | Assembly ABC
1.1.3 | Part D |  | PACKING | 5 |  |  |  | Assembly ABC
1.1.4 | Part E |  | CLAMP | 1 |  |  |  | Assembly ABC
1.1.5 | Part F |  | HAND VALVE | 1 |  |  |  | Assembly ABC
1.1.6 | Part G |  | HOSE | 1 |  |  |  | Assembly ABC
1.1.7 | Part H |  | SANITARY PIPE | 1 |  |  |  | Assembly ABC
1.1.8 | Part I |  | SANITARY PIPE | 1 |  |  |  | Assembly ABC
1.1.9 | Part J |  | PLATE | 1 |  |  |  | Assembly ABC
1.1.10 | Part K |  | PLATE | 1 |  |  |  | Assembly ABC
1.1.11 | Part L |  | HOLDER | 1 |  |  |  | Assembly ABC
1.2 | Assembly DEF |  | Assembly DEF | 1
1.2.1 | Part N |  | BRACKET | 2 |  |  |  | Assembly DEF
1.2.2 | Part O |  | PLATE | 2 |  |  |  | Assembly DEF
Spreadsheet: 860857d1708878969-change-column-displayed-based-on-drop-down-example-book-1-aligw
Sheet: Lines

Room: | 3
Line | Camera | Slot
 | AAAA | 301
2 | BBBB | 302
3 | CCCC | 303
4 | DDDD | 304
5 | EEEE | 305
6 | FFFF | 306
7 | GGGG | 307
8 | HHHH | 308
9 | IIII | 309
10 | JJJJ | 310
11 | KKKK | 311
12 | LLLL | 312
13 | MMMM | 313
14 | NNNN | 314
15 | OOOO | 315
16 | PPPP | 316
17 | QQQQ | 317
18 | RRRR | 318
19 | SSSS | 319
20 | TTTT | 320
21 | UUUU | 321
22 | VVVV | 322
23 | [NAME] | 323
24 | XXXX | 324
25 | [NAME] | 325
26 | ZZZZ | 326
Spreadsheet: 766133d1643766857-essentially-best-of-5-count-dynamic-range-eba
Sheet: Sheet1

Date | [NAME]
2022-01-01 00:00:00 | Apples |  | Apples
2022-01-02 00:00:00 | Bananas |  | Bananas
2022-01-03 00:00:00 | Apples |  | 2022-01-20 00:00:00
2022-01-04 00:00:00 | Apples
2022-01-05 00:00:00
2022-01-06 00:00:00 | Grapes
2022-01-07 00:00:00 | Bananas
2022-01-08 00:00:00 | Apples
2022-01-09 00:00:00 | Grapes
2022-01-10 00:00:00 | Apples
2022-01-11 00:00:00 | Apples
2022-01-12 00:00:00 | Bananas
2022-01-13 00:00:00 | Bananas
2022-01-14 00:00:00 | Bananas
2022-01-15 00:00:00 | Apples
2022-01-16 00:00:00 | Grapes
2022-01-17 00:00:00
2022-01-18 00:00:00
2022-01-19 00:00:00 | Apples
2022-01-20 00:00:00
2022-01-21 00:00:00
2022-01-22 00:00:00
2022-01-23 00:00:00
2022-01-24 00:00:00
2022-01-25 00:00:00
2022-01-26 00:00:00
2022-01-27 00:00:00
2022-01-28 00:00:00
2022-01-29 00:00:00
2022-01-30 00:00:00
2022-01-31 00:00:00
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R25

Ime artikla
Spreadsheet: 832178d1686164597-need-help-creating-a-multiple-tab-invoice-from-a-raw-data-file-billing-data
Sheet: Hours - Davidson

ROUSH
PROJECT TITLE |  |  | SUV Backup Drivers |  |  |  | INVOICE PERIOD
DTNA REF# |  |  |  |  |  |  | START | END
PURCHASE ORDER# |  |  |  |  |  |  | 2023-05-01 00:00:00 | 2023-05-31 00:00:00
REF# |  |  | 130440
 |  | EXPENSE DESCRIPTION |  |  |  | RATE | QTY | TOTAL
Vehicle
NO ID |  | TYPE | DATE
 |  | REG Hours | 2023-05-01 00:00:00 | [NAME] |  | 51 | 10.25
 |  | REG Hours | 2023-05-02 00:00:00 | [NAME] |  | 51 | 8
 |  | REG Hours | 2023-05-03 00:00:00 | [NAME] |  | 51 | 2
 |  | REG Hours | 2023-05-05 00:00:00 | [NAME] |  | 51 | 7
 |  | REG Hours | 2023-05-08 00:00:00 | [NAME] |  | 51 | 10.5
 |  | REG Hours | 2023-05-15 00:00:00 | [NAME] |  | 51 | 13.5
 |  | REG Hours | 2023-05-16 00:00:00 | [NAME] |  | 51 | 9.75
 |  | REG Hours | 2023-05-17 00:00:00 | [NAME] |  | 51 | 12.25
 |  | REG Hours | 2023-05-18 00:00:00 | [NAME] |  | 51 | 4.5
 |  | REG Hours | 2023-05-29 00:00:00 | [NAME] |  | 51 | 10
 |  | REG Hours | 2023-05-30 00:00:00 | [NAME] |  | 51 | 9.5
 |  | REG Hours | 2023-05-31 00:00:00 | [NAME] |  | 51 | 10
 |  |  |  |  |  | TOTAL
 |  | EXPENSE DESCRIPTION |  |  |  | RATE | QTY | TOTAL
Vehicle
NO ID |  | TYPE | DATE
 |  | OT Hours | 2023-05-18 00:00:00 | [NAME] |  | 73.95 | 2.5
 |  |  | 2023-05-19 00:00:00 | [NAME] |  | 73.95 | 9.75
 |  |  |  |  |  | TOTAL
 |  |  |  |  | MONTH TOTAL
Spreadsheet: susan_bailey__39380__Select Energy
Sheet: New

DEAL # | EOL # | COUNTERPARTY | DEAL DATE | FLOW START | FLOW END | PRICE | VOLUME | TRADER | DELIVERY POINT | DEAL TYPE | CATEGORY | BUY/SALE | PHYSICAL/FINANCIAL | FIRMNESS
870133.2 |  | Select Energy, Inc. | 2002-01-02 00:00:00 | 2002-01-02 00:00:00 | 2002-01-31 00:00:00 | 32 | 17600 | [NAME] | PJM-Western Hub | FORWARD | CMDTY | S | P | Firm
870137.2 |  | Select Energy, Inc. | 2002-01-02 00:00:00 | 2002-01-02 00:00:00 | 2002-01-31 00:00:00 | 32 | 17600 | [NAME] | PJM-Western Hub | FORWARD | CMDTY | S | P | Firm
870133.3 |  | Select Energy, Inc. | 2002-01-30 00:00:00 | 2002-02-01 00:00:00 | 2002-02-28 00:00:00 | 32 | 16000 | [NAME] | PJM-Western Hub | FORWARD | CMDTY | S | P | Firm
870137.3 |  | Select Energy, Inc. | 2002-01-30 00:00:00 | 2002-02-01 00:00:00 | 2002-02-28 00:00:00 | 32 | 16000 | [NAME] | PJM-Western Hub | FORWARD | CMDTY | S | P | Firm
 |  | These are exercise of options
Spreadsheet: 125075d1318863944-summarizing-for-pivot-table-copy-of-testdatals
Sheet: LeaderScriptMaster

ID | Username | First Name | Last Name | Address | City | State | Zip | Grad Year | School | Degree | Category | Position | Activity | Start Date | End Date | Description | Hours | Submit Date | UniqPerCat
5409 | Jfrank | [NAME] | Franklin | 2800S State St. | [NAME] | AK | 44444 | 2010 | Arizona School of Health Sciences | Occupational Therapy | Leadership | President | Student Occupational Therapy Association | 2008-01-01 00:00:00 | 2009-01-01 00:00:00 | Organized events by creating emails, power points and schedules for participants. | 4 | 2009-09-20 01:06:00
5834 | Msmith | Misty | Smith | 4 Main St. | Birmingham | AL | 35023 | 2011 | School of Osteopathic Medicine in Arizona | Doctorate of Osteopathy | Leadership | Student Ambassador | Student Ambassadors | 2007-08-01 00:01:00 | 2011-07-31 23:59:00 | Attended health fairs and guest spoke at premedical club meetings at various undergraduate universities. | 1 | 2008-08-29 10:28:00
7649 | Msmith | Misty | Smith | 4 Main St. | Birmingham | AL | 35023 | 2011 | School of Osteopathic Medicine in Arizona | Doctorate of Osteopathy | Leadership | Class Representative | OSMA Graduation Committee | 2010-04-01 00:01:00 | 2011-06-01 23:59:00 | Class of 2011 representative to the ATSU-SOMA Graduation Committee. | 5 | 2010-07-11 11:06:00
6187 | Rlake | [NAME] | Lake | 6360 Iron Road | Bishop | ND | 55555 | 2011 | Kirksville College of Osteopathic Medicine | DO | Development | Member | Student Osteopathic Medical Association | 2007-09-01 00:00:00 | 2011-06-30 00:00:00 | Active member of HHR | 1 | 2009-01-05 14:24:00
3537 | [NAME] | [NAME] | Nair | 404 [NAME] | Main | AK | 41110 | 2009 | Kirksville College of Osteopathic Medicine | Doctor of Osteopathic Medicine | Development | Attendee | American Medical Student Association | 2005-10-21 00:01:00 | 2005-10-21 23:59:00 | Attended a presentation on educating patients on diabetes care. Presenters included a nurse and a dietician. | 8 | 2006-05-29 11:27:00
3539 | [NAME] | [NAME] | Nair | 404 [NAME] | Main | MO | 63501 | 2009 | Kirksville College of Osteopathic Medicine | Doctor of Osteopathic Medicine | Service | [NAME] | Roadside Clean-up | 2005-11-16 00:01:00 | 2005-11-16 23:59:00 | [NAME] has adopted a road near campus which we clean-up periodically. | 12 | 2006-05-29 11:30:00
3543 | [NAME] | [NAME] | Nair | 404 [NAME] | Main | MO | 63501 | 2009 | Kirksville College of Osteopathic Medicine | Doctor of Osteopathic Medicine | Development | Attendee | Presentation on Choosing a Residency | 2006-01-11 00:01:00 | 2006-01-11 23:59:00 | Two residents presented information regarding choosing and being accepted into a residency. | 1 | 2006-05-29 11:39:00
Spreadsheet: 35979d1233710756-how-can-i-auto-sort-book1
Sheet: Sheet3

 |  | [NAME]
 |  | Hours to Date
Date |  | Hours |  | Total
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Spreadsheet: 297031d1392262998-trying-to-create-a-cross-reference-sheet-within-a-workbook-testbook
Sheet: Sheet1

 | [NAME] | OEM2 | [NAME] | OEM4 | OEM5 | OEM6 | OEM7 | OEM8
Client1 | X |  |  | X | X | X | X
Client2 |  | X | X
Client3 |  | X |  | X |  |  |  | X
Client4 |  |  |  |  | X | X | X
Client5 | X |  |  | X |  |  |  | X
Client6 |  |  | X | X
Client7 |  | X |  |  | X |  | X | X
Client8
Client9 |  |  | X |  |  | X | X
Client10 |  | X |  |  | X
Client11 |  |  |  |  | X | X | x | X
Spreadsheet: 850647d1701060617-kind-of-reverse-index-match-mosom-8-3-
Sheet: Sheet1 (3)

 |  |  |  |  | Role 1 | Role 2 | Role 3 | Role 4 | Role 5
Topic 1 | Module 1 | Area 1 | Focus 1 |  | Yes | Yes | Yes | Yes | No
Topic 1 | Module 1 | Area 1 |  |  | No | Yes | Yes | No | No
Topic 1 | Module 1 | Area 1 |  |  | No | Yes | No | No | Yes
Topic 1 | Module 1 | Area 2 | Focus 1 |  | Yes | Yes | No | No | Yes
Topic 1 | Module 1 | Area 2 | Focus 2 |  | No | N/A | Yes | Yes | No
Topic 1 | Module 1 | Summary |  |  | text field 1 | text field 2 | text field 3 | text field 4 | text field 5 |  |  |  |  | NEW SCENARIO
Topic 1 | Module 2 | Area 1 | Focus 1 |  | Yes | No | No | Yes | Yes |  |  |  |  | List all text fields and the info
Topic 1 | Module 2 | Area 1 | Focus 2 |  | N/A | No | Yes | Yes | Yes |  |  |  |  | eg | text field 1 |  | Topic 1 | Module 1 | Summary |  | Role 1
Topic 1 | Module 2 | Area 2 | Focus 1 |  | N/A | Yes | Yes | Yes | No |  |  |  | repeat of text field |  | text field 1 |  | Topic 1 | Module 2 | Summary |  | Role 4
Topic 1 | Module 2 | Area 3 | Focus 1 |  | No | Yes | Yes | Yes | No |  |  |  | also shows up |  | text field 2 |  | Topic 1 | Module 1 | Summary |  | Role 2
Topic 1 | Module 2 | Area 3 | Focus 2 |  | Yes | N/A | Yes | No | Yes |  |  |  |  |  | text field 3 |  | Topic 1 | Module 1 | Summary |  | Role 3
Topic 1 | Module 2 | Summary |  |  | text field 6 | text field 7 | text field 8 | text field 1 | text field 10 |  |  |  |  |  | text field 4 |  | Topic 1 | Module 1 | Summary |  | Role 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 5 |  | Topic 1 | Module 1 | Summary |  | Role 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 6 |  | Topic 1 | Module 2 | Summary |  | Role 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 7 |  | Topic 1 | Module 2 | Summary |  | Role 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 8 |  | Topic 1 | Module 2 | Summary |  | Role 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 10 |  | Topic 1 | Module 2 | Summary |  | Role 5
Spreadsheet: 06983388-369a-4c45-8485-fcb99c0ed6a6
Sheet: 1ED OUT OF 120

ANON# | RANK
601717 | 11
601718 | 21
601724 | 7
601725 | 16
601726 | 1
601729 | 23
601735 | 29
601749 | 20
601751 | 17
601752 | 19
601753 | 26
601755 | 27
601759 | 2
601764 | 15
601765 | 13
601767 | 10
601772 | 11
601776 | 30
601781 | 3
601783 | 4
601785 | 25
601792 | 24
601793 | 18
601794 | 9
601795 | 22
601817 | 6
601819 | 5
601824 | 27
602072 | 14
604140 | 8
Spreadsheet: 584363d1533139256-single-line-totaling-without-using-pivot-book2
Sheet: Sheet1

Name | Qty | Pur | Dam | Per Vol | Result
[NAME] | 1 | 10016800 | -624000 | 3120
[NAME] | 2 | 13536366.54 | -443466.54 | 2964
[NAME] | 4 | 62162480.29 | -2291438.29 | 15315.3
[NAME] | 8 | 372469.75 | -26130 | 130.65
[NAME] | 5 | 113601137.26 | -25910034.96 | 29057.73
[NAME] | 7 | 1224876.54 | -89945.79 | 337.788
[NAME] | 6 | 386860.17 | -11910.17 | 79.2
[NAME] |  |  |  |  | 3359.890671071797
Spreadsheet: sally_beck__35471__headcount summary
Sheet: Summary 111901

 | Employee Headcount | Contractors | Total
Development (Excluding EES & ETS) | 552 | 222
Infrastructure (Excluding EES & ETS) | 392 | 192
EBS | 50 | 4
EOL | 121 | 8
EES | 144 | 66
ETS | 189 | 70
Totals
Spreadsheet: 691579d1597764683-return-site-based-on-client-example1-6-ans
Sheet: report

 |  | Client | Apple
 |  |  |  |  |  |  | Unwanted spaces in column A should be removed
Name | Balance | Unit | Status
Spreadsheet: 07296c68-386c-439e-ae6d-c17a93d8cce3
Sheet: 33

THE ALLSTATE CORPORATION
PROPERTY-LIABILITY
HISTORICAL PRIOR YEAR RESERVE REESTIMATES (1)
($ in millions)
 |  |  |  | Twelve months ended December 31,
 |  |  |  | 2012 |  |  | 2011 |  |  | 2010 |  |  | 2009 |  |  | 2008
Allstate brand |  |  | $ | -671 |  | $ | -371 |  | $ | -181 |  | $ | -126 |  | $ | 155
Encompass brand |  |  |  | -45 |  |  | 15 |  |  | -6 |  |  | -10 |  |  | -3
Esurance brand |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | Allstate Protection |  |  | -716 |  |  | -356 |  |  | -187 |  |  | -136 |  |  | 152
 | Discontinued Lines and Coverages |  |  | 51 |  |  | 21 |  |  | 28 |  |  | 24 |  |  | 18
 |  | Property-Liability | $ | -665 |  | $ | -335 |  | $ | -159 |  | $ | -112 |  | $ | 170
Effect of Property-Liability prior year reserve reestimates
on the combined ratio |  |  |  | -2.5 |  |  | -1.3 |  |  | -0.6 |  |  | -0.4 |  |  | 0.7
(1) | Favorable reserve reestimates are shown in parentheses.
Spreadsheet: 52350d1252051184-conditional-formatting-to-highlight-2-days-before-the-expiry-date-excel-forum-conditional-format-today-2
Sheet: Sheet1

item | [NAME] | [NAME] | francis | status
apple | 2009-09-04 00:00:00 | 2009-09-08 00:00:00 | 2009-09-05 00:00:00 | eat now!!!
orange | 2009-09-08 00:00:00 | 2009-09-08 00:00:00 | 2009-09-09 00:00:00 | don’t worry
candy | 2009-09-07 00:00:00 | 2009-09-06 00:00:00 | 2009-09-07 00:00:00 | don’t worry
mango | 2009-09-05 00:00:00 | 2009-09-09 00:00:00 | 2009-09-03 00:00:00 | eat now!!!
banana | 2009-09-07 00:00:00 | 2009-09-05 00:00:00 | 2009-09-09 00:00:00 | don’t worry
kiwi | 2009-09-05 00:00:00 | 2009-09-03 00:00:00 | 2009-09-08 00:00:00 | eat now!!!
Conditional Formatting to highlight 2 days before the expiry date - Excel Help Forum
Spreadsheet: 887966d1738277737-highlight-the-cells-with-different-day-and-months-after-looking-at-the-day-and-month-in-row-highlight-the-cells-with-different-day-and-months-dharmeshchauhan-
Sheet: Sheet4

Unique ID | Forename | Audiometry Remote | [NAME] | HAVS T2 | HAVS T2 Remote | Nightworker | Nightworker Remote | Respiratory Remote | [NAME] | Safety Critical | Skin Remote | [NAME] |  | Oldest Dates
89421 | [NAME] | 2027-03-27 00:00:00 |  |  | 2029-03-27 00:00:00 |  |  |  |  |  | 2027-03-27 00:00:00 | 2027-03-27 00:00:00
101534 | [NAME] | 2029-03-27 00:00:00 |  |  | 2028-03-28 00:00:00 |  |  |  |  |  | 2029-03-27 00:00:00 | 2029-03-27 00:00:00
216662 | [NAME] |  | 2024-10-10 00:00:00 | 1984-10-11 00:00:00 |  |  |  |  | 2024-10-10 00:00:00 | 2024-10-10 00:00:00 |  | 2024-10-10 00:00:00
229973 | [NAME] | 2024-05-23 00:00:00 |  | 2024-03-04 00:00:00 |  |  |  | 2024-05-23 00:00:00 |  |  |  | 2024-03-04 00:00:00
230044 | [NAME] | 2024-11-03 00:00:00 |  | 2024-03-04 00:00:00 |  |  |  | 2024-11-03 00:00:00 |  |  |  | 2024-03-04 00:00:00
231184 | Julian |  | 2024-11-21 00:00:00 | 2024-11-21 00:00:00 |  |  |  |  | 2024-11-21 00:00:00 | 2024-11-21 00:00:00 |  | 2024-11-21 00:00:00
254346 | [NAME] |  | 2024-04-11 00:00:00 | 2024-04-11 00:00:00 |  |  |  |  | 2024-04-11 00:00:00 | 2024-04-11 00:00:00 |  | 2024-04-11 00:00:00
405221 | [NAME] |  | 2025-02-05 00:00:00 | 2025-02-05 00:00:00 |  |  |  |  | 2025-02-05 00:00:00 |  |  | 2025-02-05 00:00:00
422440 | Wayne |  | 2025-02-09 00:00:00 | 2025-02-09 00:00:00 |  | 2024-03-04 00:00:00 |  |  | 2025-02-09 00:00:00 | 2025-02-09 00:00:00 |  | 2025-02-09 00:00:00
785250 | [NAME] | 2024-04-24 00:00:00 |  | 2024-04-24 00:00:00 |  |  |  | 2024-04-02 00:00:00 |  |  |  | 2024-04-24 00:00:00
817780 | [NAME] | 2022-08-31 00:00:00 |  | 2024-03-04 00:00:00 |  |  |  | 2022-08-31 00:00:00 |  |  |  | 2024-03-04 00:00:00
817791 | Stuart | 2025-01-04 00:00:00 |  | 2024-03-04 00:00:00 |  |  |  | 2025-01-04 00:00:00 |  |  |  | 2024-03-04 00:00:00
817818 | [NAME] |  | 2025-01-10 00:00:00 | 2025-01-10 00:00:00 |  |  |  |  | 2025-01-10 00:00:00 | 2025-01-10 00:00:00 |  | 2025-01-10 00:00:00
831779 | [NAME] |  | 2024-07-25 00:00:00 | 2024-03-04 00:00:00 |  |  |  | 2024-03-04 00:00:00 |  |  |  | 2024-07-25 00:00:00
831792 | [NAME] | 2024-04-21 00:00:00 |  | 2024-03-04 00:00:00 |  |  |  | 2024-04-21 00:00:00 |  |  |  | 2024-03-04 00:00:00
831807 | Alistair |  | 2024-07-06 00:00:00 | 2024-07-06 00:00:00 |  |  |  |  | 2024-07-06 00:00:00 |  |  | 2024-07-06 00:00:00
831819 | Adrian | 2024-06-15 00:00:00 |  | 2024-03-04 00:00:00 |  | 2024-03-04 00:00:00 |  | 2024-06-15 00:00:00 |  |  |  | 2024-03-04 00:00:00
836576 | [NAME] |  | 2024-06-01 00:00:00 | 2024-06-01 00:00:00 |  | 2024-06-01 00:00:00 |  |  | 2024-06-01 00:00:00 | 2024-06-01 00:00:00 |  | 2024-06-01 00:00:00
836588 | [NAME] |  | 2025-02-22 00:00:00 | 2025-02-22 00:00:00 |  | 2025-02-22 00:00:00 |  |  | 2025-02-22 00:00:00 | 2025-02-22 00:00:00 |  | 2025-02-22 00:00:00
Spreadsheet: 889569d1740429131-total-count-based-on-text-sample
Sheet: Sheet1

Count | Number | Number | Name | Statsus First half of the year | Status Second half of year | Group | First Inspection date YYYY-MM-DD |  | Total Inspected
780 |  | 676 | XXXXX | ABC |  |  | 2025-01-01 00:00:00
781 |  | 5291 | XXXXX | LHF |  |  | not inspected
782 |  | 5297 | XXXXX | LHF |  |  | 2025-02-02 00:00:00
783 |  | 5298 | XXXXX | ABC |  |  | 2025-02-03 00:00:00
784 |  | 5299 | XXXXX | LHF |  |  | 2025-02-16 00:00:00
785 |  | 5295 | XXXXX | LHF |  |  | not inspected
786 |  | 5296 | XXXXX | LHF |  |  | not inspected
787 |  | 5296 | XXXXX | ABC |  |  | not inspected
788 |  | 5300 | XXXXX | LHF |  |  | 2025-01-25 00:00:00
Spreadsheet: 856291d1705585761-formula-to-flag-duplicates-only-under-certain-conditions-test-flag-cancellations-if-already-ordered-aligw
Sheet: Sheet1

School | Subject | Sales rep | Opportunity created date | Outcome | Concat (columns a-d) | Cancelled but already ordered?
[NAME] | Maths | [NAME] | 2024-01-15 00:00:00 | Closed won
London Free School | English | [NAME] | 2024-01-15 00:00:00 | Closed won
[NAME] | Science | [NAME] | 2024-01-01 00:00:00 | Closed won
London Free School | English | [NAME] | 2024-01-01 00:00:00 | Closed lost
London Free School | English | [NAME] | 2024-01-15 00:00:00 | Closed lost
London Free School | English | [NAME] | 2024-01-15 00:00:00 | Closed lost
[NAME] | Maths | [NAME] | 2024-01-15 00:00:00 | Closed lost
[NAME] | Maths | [NAME] | 2024-01-15 00:00:00 | Closed lost
[NAME] | Maths | [NAME] | 2024-01-15 00:00:00 | Closed lost
[NAME] | French | [NAME] | 2024-01-01 00:00:00 | Open
Spreadsheet: 97757d1296841955-lookup-with-hours-and-minutes-feed-time-example
Sheet: Sheet1

Run Speed (Minute) |  |  | Feed Time |  | Run Time
2010-01-28 05:36:00 | 1702 |  | 2010-01-28 05:36:21 | 1 | 25 |  | #N/A
2010-01-28 05:37:00 | 1704 |  | 2010-01-28 05:36:46 | 0
2010-01-28 05:38:00 | 1700 |  | 2010-01-28 05:36:48 | 1 | 25
2010-01-28 05:39:00 | 1701 |  | 2010-01-28 05:37:13 | 0
2010-01-28 05:40:00 | 1702 |  | 2010-01-28 05:37:15 | 1 | 26
2010-01-28 05:41:00 | 1708 |  | 2010-01-28 05:37:41 | 0
2010-01-28 05:42:00 | 1702 |  | 2010-01-28 05:37:42 | 1 | 26
2010-01-28 05:43:00 | 1701 |  | 2010-01-28 05:38:08 | 0
2010-01-28 05:44:00 | 1701 |  | 2010-01-28 05:38:09 | 1 | 51
2010-01-28 05:45:00 | 1706 |  | 2010-01-28 05:39:00 | 0
2010-01-28 05:46:00 | 1702 |  | 2010-01-28 05:39:01 | 1 | 25
2010-01-28 05:47:00 | 1700 |  | 2010-01-28 05:39:26 | 0
2010-01-28 05:48:00 | 1704 |  | 2010-01-28 05:39:28 | 1 | 25
2010-01-28 05:49:00 | 1699 |  | 2010-01-28 05:39:53 | 0
Spreadsheet: 866500d1713432520-a-formula-to-select-the-highest-cell-in-a-column-that-then-shows-the-entire-row-walks
Sheet: Dam P

 | # | Date | Name | Distance in        Miles | Total Elevation in Feet | Total Time HH:MM | Moving Time HH:MM | Stoped Time HH:MM | Avarage Speed MPH | Average Moving Speed MPH
 |  |  | 2017
 |  |  | 2018
 |  | 2018-03-18 00:00:00 | Swineford - via The Cotswold Way. | 10.1 | 1306 |  | 04:36:00 | 01:09:00
 |  | 2018-06-24 00:00:00 | Avon Three Peaks | 17.9 | 2541 |  | 07:29:00 | 01:48:00
 |  |  | 2019
 |  | 2019-05-27 00:00:00 | Tresham, [NAME] and Ozleworth | 9.2 | 1298 |  | 03:58:00 | 01:30:00
 |  | 2019-07-22 00:00:00 | Yorkshire Three Peaks | 24.2 | 5345 | 09:15:00 | 08:45:00 | 00:30:00
 |  |  | 2020
 |  | 2020-01-19 00:00:00 | Four Waterfall Walk | 5.9 | 1836 |  | 02:58:00 | 00:43:00
 |  |  | 2021
 |  |  | 2022