tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 760634d1640352875-wanting-to-highlight-out-of-specification-cells-in-excel-based-different-specifications-demo-sheet
Sheet: Demo

 |  |  | Min | [NAME] | Min | Min | [NAME] | [NAME] |  |  |  |  |  | [NAME] | [NAME]
All others |  |  | 600 | 800 | 60 | 35 | 14 | 10 | - | - | - | - | - | - | 4 | -
Tesla |  |  | 550 | 850 | 80 | 35 | 12 | 6 | - | - | - | - | - | - | 2 | -
Renault |  |  | 700 | 900 | 60 | - | 14 | 8 | - | - | - | - | - | - | 1 | -
Euroshopper |  |  | 600 | 745 | 60 | 30 | 14 | 11 | - | - | - | - | - | - | 1 | -
Volvo |  |  | 500 | 800 | 60 | - | 14 | 10 | - | - | - | - | - | - | 1 | -
Ford |  |  | 600 | 740 | 60 | 25 | 14 | 11 | - | - | - | - | - | - | 1 | -
Date | Time | Customer | Density |  | Viscosity | Clump | Moisture | <0,5 | 0.5 - 1.0 | 1.00-2.00 | 2.0 - 2.8 | 2.8 - 4.0 | 4.0 - 5.6 | 5.6 - 6.7 | 6.7 - 10 | >10 | Total |  |  | Date | Time | Density 1 | Density 2 | Average |  | Cone 1 | +Sample 1 | Cone 2 | +Sample 2 | Cone 3 | +Sample 3 | +Water 1 | +Water 2 | +Water 3 | Result |  |  |  | Cone 1 | +Sample 1 | Cone 2 | +Sample 2 | Cone 3 | +Sample 3 | +Water 1 | +Water 2 | +Water 3 | Result |  |  |  | Moisture
 |  |  | G/L |  | % | % | % | % | % | % | % | % | % | % | %
2021-01-01 00:00:00 | 15:00:00 | Ford |  |  |  |  |  | 12.2 | 10 | 16 | 15 | 22 | 10.8 | 12 | 2 | 0 |  |  |  |  |  | 750 | 745 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 80 | 80 | 80 |  |  |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 70 | 65 | 60 |  |  |  |  | 5.5
2021-01-01 00:00:00 | 15:00:00 | Renault |  |  |  |  |  | 5.2 | 10 | 16 | 15 | 22 | 17.8 | 12 | 2 | 0 |  |  |  |  |  | 800 | 800 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 70 | 70 | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.5
2021-01-01 00:00:00 | 15:00:00 | Volvo |  |  |  |  |  | 11.2 | 10 | 10 | 15 | 22 | 17.8 | 12.5 | 1.5 | 0 |  |  |  |  |  | 300 | 300 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 80 | 80 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.5
2021-01-01 00:00:00 | 15:00:00 | Tesla |  |  |  |  |  | 6.2 | 15 | 10 | 15 | 22 | 17.8 | 12.5 | 1.5 | 0 |  |  |  |  |  | 900 | 900 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 80 | 80 | 80 |  |  |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 65 | 65 | 50 |  |  |  |  | 12
2021-01-01 00:00:00 | 15:00:00 | Spar |  |  |  |  |  | 11.2 | 10 | 10 | 15 | 22 | 17.8 | 12.5 | 1.5 | 0 |  |  |  |  |  | 900 | 900 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 80 | 80 | 80 |  |  |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 65 | 65 | 50 |  |  |  |  | 16
Spreadsheet: 684462d1593377253-numbers-afrter-icon-con-formatting-book1-1-1-_eh
Sheet: Sheet1

ID | Tasks | Responsibility | Start Date | Deadline | Priority |  | Status |  | Next Meeting & Action | 2019-11-01 00:00:00
1 | Purchase to Pay |  |  | 2020-03-31 00:00:00 | High |  | In progress
2 | GDPR - deletion of tenancies that have ended > 6 years ago |  |  | 2020-01-20 00:00:00 | Low |  | Completed
3 | Up-grade Cx to 19.8 agreed | Chandni |  | 2020-02-28 00:00:00 | Not set |  | Not started
4 | Up-grade latest tenant's portal versions agreed | Chandni |  | 2020-02-24 00:00:00
5 | Reviews arrears procedure against Cx | Chandni |  | 2020-03-26 00:00:00
6 | Void review
7 | Allocations (interconnected with [NAME])                 General allocations dates
8 | Communications + void
9 | CRM + voids
10 | Cases & Task Module
11 | Reports - purchase standard report | Chandni
12 | Interface repairs provider with CX | Chandni
13 | Data Cleansing
Spreadsheet: 865601d1712655742-sequential-incriment-test-sample
Sheet: Sheet1

Level | Seq
1 |  |  | 2
2 |  |  | 2.1
3 |  |  | 2.1.1
3 |  |  | 2.1.2
2 |  |  | 2.2
3 |  |  | 2.2.1
4 |  |  | 2.2.1.1
4 |  |  | 2.2.1.2
3 |  |  | 2.2.2
2 |  |  | 2.3
2 |  |  | 2.4
2 |  |  | 2.5
Spreadsheet: 800811d1665901004-need-help-to-correct-formulas-in-columns-n-to-r-formula-mistake-from-n-to-r-to-correct
Sheet: 2B

[NAME] of supplier | TALLY DATE | INVOICE DATE | Invoice number | VOUCHER NO. | Trade/Legal name | Invoice Value | 0 | 3 | 5 | 12 | 18 | 28 | 3 | 5 | 12 | 18 | 28 | 1.5 | 1.5 | 2.5 | 2.5 | 6 | 6 | 9 | 9 | 14 | 14 | 3 | 5 | 12 | 18 | 28 | Round Off | Filing Date
Spreadsheet: 748794d1632349567-count-unique-licence-plates-per-refuelling-test_book-tms
Sheet: Folha1

License plate | Liters | Segment |  | =UNIQUE(A2:A6) | =SUMIF($A$2:$A$6,$E2#,$B$2:$B$6) |  | =UNIQUE($C$2:$C$6) | =COUNTA(UNIQUE(FILTER($A$2:$A$6,$C$2:$C$6=$H2))) | =SUMIF($C$2:$C$6,$H2#,$B$2:$B$6)
12-AB-34 | 20 | A
12-AB-34 | 30 | A |  | 04-XY-33 | 33 |  | F |  | 33
12-AB-34 | 25 | A |  | 04-BG-52 | 23
04-XY-33 | 33 | F
04-BG-52 | 23 | A
Spreadsheet: 110788d1307391274-variable-cell-reference-dummyworkbook
Sheet: JGH Report

 |  | Est. Cost |  | Act. Revenue |  | ($) Diff.
 | [NAME] | 0 |  | 1674.94 |  | 1674.94
 | [NAME] | 0 |  | 749 |  | 749
 | [NAME] | 0 |  | 1134.76 |  | 1134.76
 | [NAME] | 0 |  | 1301.57 |  | 1301.57
 | Beatriz | 0 |  | 1094.04 |  | 1094.04
 | [NAME] | 0 |  | 1142.64 |  | 1142.64
 | Lynch | 0 |  | 995.93 |  | 995.93
 | [NAME] | 0 |  | 368.55 |  | 368.55
 | [NAME] | 0 |  | 441.31 |  | 441.31
 | [NAME] | 0 |  | 1075.19 |  | 1075.19
 | [NAME] | 0 |  | 1211.74 |  | 1211.74
 | [NAME] | 0 |  | 490.39 |  | 490.39
 | Paule | 0 |  | 416.67 |  | 416.67
 | Pam | 0 |  | 1443.61 |  | 1443.61
 | Will | 0 |  | 832.4 |  | 832.4
 | Bermz | 0 |  | 1658.6 |  | 1658.6
 | [NAME] | 0 |  | 1566.94 |  | 1566.94
 | Craigory | 0 |  | 1270.12 |  | 1270.12
 | Luna | 0 |  | 1470.28 |  | 1470.28
 | Rickard | 0 |  | 588.34 |  | 588.34
 | [NAME] | 0 |  | 1704.12 |  | 1704.12
 | Grigory | 0 |  | 3028.98 |  | 3028.98
 | [NAME] | 0 |  | 2319.24 |  | 2319.24
 | Johnathon | 0 |  | 840.29 |  | 840.29
 | [NAME] | 0 |  | 1466.06 |  | 1466.06
 | Kathy | 0 |  | 475.51 |  | 475.51
 | Grigory | 0 |  | 1475.03 |  | 1475.03
 | Kimbersonly | 0 |  | 1546.49 |  | 1546.49
 | Rich | 0 |  | 252.6 |  | 252.6
 | [NAME] | 0 |  | 623.43 |  | 623.43
TOTAL |  | 0 |  | 34658.77 |  | 34658.77
 | % Profit =
 | Estimated Bonus =
Spreadsheet: 862783d1710407573-like-vlookup-but-with-concatenate-results-sample-of-excel-aligw
Sheet: Sheet1

 |  |  |  |  | Account Description | Note
All amounts in NOK 1000 | Note | 2023-03-01 00:00:00 |  |  | Sales revenues | 2.1
Sales revenues |  | 238001.45254 |  |  | Other operating income | 2.2
Other operating income |  | 50446.37224 |  |  | Other revenues | 2.2
Other revenues |  | 51020.1236 |  |  | Revenues | 1.5
Revenues |  | 239467.94838 |  |  | Cost of sales | 2.3
Cost of sales |  | 181987.24508 |  |  | Gross profit | 1.5
Gross profit |  | 107480.7033 |  |  | [NAME] and personnel expenses | 2.4
[NAME] and personnel expenses |  | 126332.75118 |  |  | Other operating expenses | 2.5
Other operating expenses |  | 135409.27006 |  |  | Impairment losses | 2.6
Impairment losses |  | 50027.2359 |  |  | Operating expenses | 1.5
Operating expenses |  | 211769.25714 |  |  | EBITDA | 1.5
EBITDA |  | -54288.55383999999 |  |  | Depreciation and amortisation | 3.2
Depreciation and amortisation |  | 83488.31904 |  |  | EBIT | 1.5
EBIT |  | -87776.87288000001 |  |  | Financial income | 2.7
Financial income |  | 53341.85239 |  |  | Financial expense | 2.7
Financial expense |  | 51942.5634 |  |  | Taxes | 2.8
Net Financial items |  | 51399.28899 |  |  | Depreciation and amortisation | 3.3 | Changed 'z' to 's'.
Profit before tax |  | -86377.58389000001 |  |  | Depreciation and amortisation | 3.4
Taxes |  | 49426.1191
Net result |  | -85803.70298999999
Spreadsheet: sally_beck__33762__Office Models
Sheet: Office List

Metals Trading Offices
 | London
 | New York
 | Hamburg
Metals Agency Offices |  | Trading Office for which agent
 | Montreal | London
 | St Louis | [Hamburg/New York] | Note 1
 | Chicago recycling | [Hamburg/New York] | Note 1
 | Chicago primary | London
 | Tokyo | London
 | Sydney | London
Note 1 | All of the St Louis activity and part of the Chicago activity is trading recycled materials
 | The Metals strategy for the Recycled materials business is not yet settled
 | One Commercial suggestion is that Hamburg should take close ownership of all recycled business
 | The current systems and controls infrastructure in the Hamburg scrapyard is not of a standard suitable for handling Agency offices
 | Once a Commercial strategy is articulated and agreed we will build the appropriate control infrastructure
Spreadsheet: 107648d1304781844-get-data-in-one-sheet-sample-sheet
Sheet: Agent wise Leave or Off Tracker

Input
Enter Id here | From | To | Type of Request
101 | 2011-05-01 00:00:00 | 2011-05-31 00:00:00 | Leave
 |  |  |  |  | Total Number of Request | 13
Output
Dates
2011-05-01 00:00:00
2011-05-02 00:00:00
2011-05-05 00:00:00
2011-05-06 00:00:00
2011-05-07 00:00:00
2011-05-08 00:00:00
2011-05-09 00:00:00
2011-05-10 00:00:00
2011-05-11 00:00:00
2011-05-12 00:00:00
2011-05-13 00:00:00
2011-05-14 00:00:00
2011-05-15 00:00:00
Spreadsheet: 0954cba4-8627-4005-92c3-019b37599992
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
36283306 | 2013-06-06 23:09:46 | AXIS | 0 | 3 | 7 | 1330438 | Death Dealer | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
36330072 | 2013-06-10 01:41:46 | AXIS | 0 | 2 | 6 | 1340988 | Unrealik200 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
36330235 | 2013-06-10 02:03:39 | ALLIES | 0 | 5 | 6 | 1340988 | Unrealik200 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
Spreadsheet: 543381d1508360253-dropdown-box-printing-tool
Sheet: Students

 | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 | Q11 | Q12 | Q13 | Q14 | Q15 | Q16 | Q17 | Q18 | Q19 | Q20 | [NAME] | Q22 | [NAME] | Q24 | Q25 | Q26 | Q27 | Q28 | Q29 | Q30
 | Time and Angles | Properties of Number | Money Problem | Averages | Properties of Quadrilaterals | Shape and area | Bar Charts and Pictograms | Pie Charts | Fraction, Decimals and Percentages | Decimal time and distance problem | Substitution | Percentages problem | Averages and Range Problem | Index numbers | Sequences | [NAME] | Distance Time Graph | Four Rules problem | Area | Nth term of a sequence | Inequalities | Volume of a Cylinder
 | 5 | 4 | 3 | 2 | 3 | 4 | 5 | 3 | 3 | 4 | 4 | 4 | 2 | 2 | 6 | 3 | 4 | 3 | 2 | 2 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 1 | 0 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Dappy Donut | 3 | 1 | 3 | 2 | 3 | 2 | 3 | 2 | 2 | 3 | 3 | 4 | 2 | 2 | 5 | 3 | 2 | 3 | 1 | 1 | 1 | 1
Spreadsheet: 837919d1690511109-working-out-relevant-fee-fees
Sheet: Sheet1

Category | [NAME] | Cost
1 | 80 | 1.71 |  | 6 | 5901
2 | 60 | 1.81
2 | 210 | 1.98
2 | 460 | 2.11
3 | 960 | 2.58
4 | 960 | 2.79
5 | 150 | 2.79
5 | 400 | 2.81
5 | 900 | 2.85
5 | 1400 | 3.02
5 | 1900 | 3.31
5 | 3900 | 5.3
6 | 150 | 2.81
6 | 400 | 2.92
6 | 900 | 3.15
6 | 1400 | 3.36
6 | 1900 | 3.68
6 | 2900 | 5.38
6 | 3900 | 5.68
6 | 5900 | 5.84
6 | 8900 | 6.66
6 | 11900 | 7.04
7 | 760 | 5.06
7 | 1260 | 5.87
7 | 1760 | 6.05
7 | 100000 | 6.06
8 | 760 | 6.01
8 | 1760 | 6.35
8 | 2760 | 6.5
8 | 3760 | 6.53
8 | 4760 | 6.56
8 | 9760 | 7.85
8 | 19760 | 8.4
Spreadsheet: 543588d1508469507-rearrange-database-like-dataset-into-table-for-large-dataset-better-option-index-match-dataset
Sheet: Answer Table

user_id | Question ID ---> | 19 | 43 | 45 | 4 | 40 | 1 | 3 | 26 | 2 | 49 | 37 | 15 | 28 | 22 | 21 | 29 | 27 | 23 | 11 | 33 | 36 | 25 | 16 | 41 | 30 | 44 | 6 | 8 | 47 | 31 | 34 | 46 | 9 | 38 | 17 | 24 | 35 | 20 | 5 | 10 | 12 | 39 | 7 | 32 | 13 | 48 | 14 | 42 | 18 | 103 | 104 | 105 | 106
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 869937d1716470413-conditional-formating-to-highlight-cell-text-word-if-not-included-in-a-table-of-words-conditional
Sheet: Sheet1

Fruit | rows that should highlight |  | Aloud fruit
Apple |  |  | Apple
Apples |  |  | Orange
Orange |  |  | Pear
Orange |  |  | [NAME]
Pear |  |  | Kiwi
[NAME] |  |  | Lemon
Grapes |  |  | Papaya
Kiwi
Lemon
Tomato
Papaya
Apple
Tomato
Grapes
Spreadsheet: 835337d1688521860-use-of-indirect-i-think-11-for-test-hd
Sheet: Harry

Name | [NAME]
Current Position | [NAME] polisher
Start Date | 2010-08-11 00:00:00
Current Length of Employment
Round 1
Date | 2023-06-03 00:00:00
Time | 1245-1300
Attendees | Prancer, [NAME]
Explanation of scheduled catch ups | Done
General check in | Good
Talk about current training plans | Loving shiney handrails
Anything else to raise | No
Current level of job satisfaction out of 0-10 | 3
Key action points | More dirty handrails please
Round 2
Date | 2023-07-03 00:00:00
Time | 1245-1300
Attendees | Prancer, [NAME]
General check in | Done
Talk about current training plans | Hating dirty handrails
Update on any points from last catch up | Good
Anything else to raise | Would like to do this for free
Current level of job satisfaction out of 0-10 | 9
Key action points | less dirty handrails
Round 3
Date | TBC
Time
Attendees
General check in
Talk about current training plans
Update on any points from last catch up
Anything else to raise
Current level of job satisfaction out of 0-10 | ?
Key action points
Round 4
Date | TBC
Time
Attendees
General check in
Talk about current training plans
Update on any points from last catch up
Anything else to raise
Current level of job satisfaction out of 0-10 | ?
Key action points
Round 5
Date | TBC
Time
Attendees
General check in
Talk about current training plans
Update on any points from last catch up
Anything else to raise
Current level of job satisfaction out of 0-10 | ?
Key action points
Round 6
Date | TBC
Time
Attendees
General check in
Talk about current training plans
Update on any points from last catch up
Anything else to raise
Current level of job satisfaction out of 0-10 | ?
Key action points
Spreadsheet: 134111d1325017050-simplified-report-for-equipment-maintenance-equipment-cost-report
Sheet: 1006

AMC No. | 09-04 | EQUIPMENT COST REPORT
Unit Number | OME 1006 |  | Start Date | 24/07/2011 |  |  |  | [NAME]
Employee Name: |  |  | End Date | 06/08/2011 |  |  |  | Hour [NAME] |  | c
Date | Receipt Number | Vendor | Fuel |  | [NAME] |  | Motor Oil |  | [NAME]. Cost | Total Cost | Odometer | PRINT NAME
 |  |  | Quantity | Cost | Quantity | Cost | Quantity | Cost
 |  |  |  |  |  | Hour [NAME] |  |  |  | Odometer End
Service Record
[NAME] | [NAME] | Vendor | Receipt Number
Filter Changed |  |  |  |  |  | NOTES
Oil Changed
Greased
Other
Supervisor Signature: __________________________________________
Spreadsheet: 691976d1597990026-how-to-auto-extract-data-by-person-name-and-auto-generate-save-in-individual-file-2020-09-19-oeldere2-feidifeidi-691653d1597817853-how-to-auto-extract-data-by-person-name-and-
Sheet: Amy

[NAME]
ID | Name | Cusotomer | Invoice No. | Invoice Date | Currency | Amount | VAT | Total
Spreadsheet: 691816d1597892414-calculate-days-in-date-range-sample-vendor-wrksht
Sheet: Sheet1

Vendor | Begin Dt | End Dt | # [NAME] | Amount | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | Apr Amt | May Amt | Jun Amt | Jul Amt | Total Amt
ABC, Inc | 2020-04-10 00:00:00 | 2020-05-10 00:00:00 |  | 4000
DEF,Inc | 2020-05-01 00:00:00 | 2020-05-31 00:00:00 |  | 3500
GHI, Inc | 2020-06-05 00:00:00 | 2020-07-04 00:00:00 |  | 2000
JKL, Inc | 2020-07-05 00:00:00 | 2020-08-05 00:00:00 |  | 1500
Spreadsheet: 821584d1678806097-additional-criteria-to-a-maxifs-formula-last-checked-example-workbook-1-
Sheet: Data

 | Date checked | Check type | Name | Pass/fail
 | 2023-03-01 00:00:00 | Check 1 | [NAME] | Pass
 | 2023-03-06 00:00:00 | Check 3 | [NAME] | Pass
 | 2023-03-06 00:00:00 | Check 4 | [NAME] | Fail
 | 2023-03-07 00:00:00 | Check 4 | [NAME] | Pass
 | 2023-03-01 00:00:00 | Check 2 | [NAME] | Fail
 | 2023-03-04 00:00:00 | Check 4 | [NAME] | Fail
 | 2023-03-05 00:00:00 | Check 4 | [NAME] | Fail
 | 2023-03-01 00:00:00 | Check 3 | [NAME] | Pass
 | 2023-03-01 00:00:00 | Check 4 | [NAME] | Pass
 | 2023-03-05 00:00:00 | Check 2 | [NAME] | Fail
Spreadsheet: 587902d1535381513-non-volatile-alternative-to-sumifs-indirect-formulas-dummy-workbook
Sheet: DataSheet2

 | 2014-06-30 00:00:00 | 100
 | 2014-07-07 00:00:00
 | 2014-07-14 00:00:00
 | 2014-07-21 00:00:00
 | 2014-07-28 00:00:00
 | 2014-08-04 00:00:00
 | 2014-08-11 00:00:00
 | 2014-08-18 00:00:00
 | 2014-08-25 00:00:00
 | 2014-09-01 00:00:00
 | 2014-09-08 00:00:00
 | 2014-09-15 00:00:00
 | 2014-09-22 00:00:00
 | 2014-09-29 00:00:00
 | 2014-10-06 00:00:00
 | 2014-10-13 00:00:00
 | 2014-10-20 00:00:00
 | 2014-10-27 00:00:00
 | 2014-11-03 00:00:00
 | 2014-11-10 00:00:00
 | 2014-11-17 00:00:00
 | 2014-11-24 00:00:00
 | 2014-12-01 00:00:00
 | 2014-12-08 00:00:00
 | 2014-12-15 00:00:00
 | 2014-12-22 00:00:00
 | 2014-12-29 00:00:00
 | 2015-01-05 00:00:00
 | 2015-01-12 00:00:00
 | 2015-01-19 00:00:00
 | 2015-01-26 00:00:00
 | 2015-02-02 00:00:00
 | 2015-02-09 00:00:00
 | 2015-02-16 00:00:00
 | 2015-02-23 00:00:00
 | 2015-03-02 00:00:00
 | 2015-03-09 00:00:00
 | 2015-03-16 00:00:00
 | 2015-03-23 00:00:00
 | 2015-03-30 00:00:00
 | 2015-04-06 00:00:00
 | 2015-04-13 00:00:00
 | 2015-04-20 00:00:00
 | 2015-04-27 00:00:00
 | 2015-05-04 00:00:00
 | 2015-05-11 00:00:00
 | 2015-05-18 00:00:00
 | 2015-05-25 00:00:00
 | 2015-06-01 00:00:00
 | 2015-06-08 00:00:00
 | 2015-06-15 00:00:00
 | 2015-06-22 00:00:00
 | 2015-06-29 00:00:00
 | 2015-07-06 00:00:00
 | 2015-07-13 00:00:00
 | 2015-07-20 00:00:00
 | 2015-07-27 00:00:00
Spreadsheet: 161716d1339605057-shift-schedule-problem-sample-sheet
Sheet: Main Sheet

NAME | 2012-06-01 00:00:00 | 2012-06-02 00:00:00 | 2012-06-03 00:00:00 | 2012-06-04 00:00:00 | 2012-06-05 00:00:00 | 2012-06-06 00:00:00 | 2012-06-07 00:00:00 | 2012-06-08 00:00:00 | 2012-06-09 00:00:00 | 2012-06-10 00:00:00 | 2012-06-11 00:00:00 | 2012-06-12 00:00:00 | 2012-06-13 00:00:00 | 2012-06-14 00:00:00 | 2012-06-15 00:00:00 | 2012-06-16 00:00:00 | 2012-06-17 00:00:00 | 2012-06-18 00:00:00 | 2012-06-19 00:00:00 | 2012-06-20 00:00:00 | 2012-06-21 00:00:00 | 2012-06-22 00:00:00 | 2012-06-23 00:00:00 | 2012-06-24 00:00:00 | 2012-06-25 00:00:00 | 2012-06-26 00:00:00 | 2012-06-27 00:00:00 | 2012-06-28 00:00:00 | 2012-06-29 00:00:00 | 2012-06-30 00:00:00
 | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
MANGESH KUMAR | A | G | G | G | G | G | OFF | A | G | G | G | G | G | OFF | A | G | G | G | G | G | OFF | A | G | G | G | G | G | OFF | A | A
PRAVEEN K.CHAUHAN | A | A | A | A | A | OFF | A | A | A | A | A | A | OFF | A | A | A | A | A | A | OFF | A | A | A | A | A | A | OFF | A | A | A
KULDEEP | B | B | OFF | G | A | A | A | A | A | OFF | G | B | B | B | B | B | OFF | G | A | A | A | A | B | OFF | G | A | A | A | A | A
SANDEEP | A | A | G | OFF | B | B | B | B | B | G | OFF | A | A | A | A | A | G | OFF | B | B | B | B | A | G | OFF | B | B | B | B | B
RAM PRASAD | OFF | C | C | C | C | C | C | OFF | B | B | B | B | B | B | OFF | A | A | A | A | A | A | OFF | C | C | C | C | C | C | OFF | B
SUNIL BALUNI | C | OFF | B | B | B | B | B | B | OFF | A | A | A | A | A | A | OFF | C | C | C | C | C | C | OFF | B | B | B | B | B | B | OFF
Spreadsheet: 698747d1602158260-solved-conditional-formatting-formula-to-highlight-duplicate-values-only-if-conditions-condformatex
Sheet: Temp

Visit Date | Client Name | Billing Codes | Units | Service | Client ID
10/07/2020 | Doe, [NAME] |  | 3 | IHCS Level 2 (1:1) | 1450
10/07/2020 | Doe, [NAME] |  | 5 | IHCS Level 2 (1:1) | 1450
2020-10-07 00:00:00 | [NAME], [NAME] |  | 11 | IHCS Level 2 (1:1) | 1220
2020-10-09 00:00:00 | [NAME], [NAME] |  | 6 | Companion (1:1) | 1220
2020-10-10 00:00:00 | Doe, [NAME] |  | 9 | IHCS Level 2 (1:1) | 1450
2020-10-11 00:00:00 | [NAME], [NAME] |  | 33 | Companion (1:1) | 1220
Spreadsheet: 156493d1337314895-split-cell-contents-help
Sheet: Photos

 | I have tired to write the code to make this work a few times but I just can't get it hoping someone can help me out. To stat of with I have a list of jpeg files ( below in orange ) I need to break the files apart into different cells. I have tried to get this work work but i just can't get it any help would be much appreciated.
This is the info I will have to start with | This is what I need it to look like
Starting info | Image 1 jpg Poduct Code | Image 1 [NAME] | subsequent jpeg product codes here | subsequent image files | Image Numbers
129440C_CONVERSE_PRO_LEATHER_MID_NATURAL_1.jpg | 129440C | 129440C_CONVERSE_PRO_LEATHER_MID_NATURAL_1.jpg |  |  | 1
129440C_CONVERSE_PRO_LEATHER_MID_NATURAL_2.jpg |  |  | 129440C | 129440C_CONVERSE_PRO_LEATHER_MID_NATURAL_2.jpg | 2
129440C_CONVERSE_PRO_LEATHER_MID_NATURAL_3.jpg |  |  | 129440C | 129440C_CONVERSE_PRO_LEATHER_MID_NATURAL_3.jpg | 3
129440C_CONVERSE_PRO_LEATHER_MID_NATURAL_4.jpg |  |  | 129440C | 129440C_CONVERSE_PRO_LEATHER_MID_NATURAL_4.jpg | 4
129440C_CONVERSE_PRO_LEATHER_MID_NATURAL_5.jpg |  |  | 129440C | 129440C_CONVERSE_PRO_LEATHER_MID_NATURAL_5.jpg | 5
303864101_NIKE_AIR_MAX_1_BLACK_1.jpg | 303864101 | 303864101_NIKE_AIR_MAX_1_BLACK_1.jpg |  |  | 1
303864101_NIKE_AIR_MAX_1_BLACK_2.jpg |  |  | 303864101 | 303864101_NIKE_AIR_MAX_1_BLACK_2.jpg | 2
303864101_NIKE_AIR_MAX_1_BLACK_3.jpg |  |  | 303864101 | 303864101_NIKE_AIR_MAX_1_BLACK_3.jpg | 3
303864101_NIKE_AIR_MAX_1_BLACK_4.jpg |  |  | 303864101 | 303864101_NIKE_AIR_MAX_1_BLACK_4.jpg | 4
303864101_NIKE_AIR_MAX_1_BLACK_5.jpg |  |  | 303864101 | 303864101_NIKE_AIR_MAX_1_BLACK_5.jpg | 5
303864101_NIKE_AIR_MAX_1_BLACK_6.jpg |  |  | 303864101 | 303864101_NIKE_AIR_MAX_1_BLACK_6.jpg | 6
303864101_NIKE_AIR_MAX_1_BLACK_7.jpg |  |  | 303864101 | 303864101_NIKE_AIR_MAX_1_BLACK_7.jpg | 7
303864101_NIKE_AIR_MAX_1_BLACK_8.jpg |  |  | 303864101 | 303864101_NIKE_AIR_MAX_1_BLACK_8.jpg | 8
303864101_NIKE_AIR_MAX_1_BLACK_9.jpg |  |  | 303864101 | 303864101_NIKE_AIR_MAX_1_BLACK_9.jpg | 9
303864101_NIKE_AIR_MAX_1_BLACK_10.jpg |  |  | 303864101 | 303864101_NIKE_AIR_MAX_1_BLACK_10.jpg | 10
Spreadsheet: 600254d1543570746-calculate-cost-of-service-over-5-years-based-on-services-due-frequency-copy-of-komatsu-830e-lcc-example-v2
Sheet: Assumptions-Drivers

Number of Komatsu dump truck | 6
Shift hours | 10.5
Number of shifts per day | 2
Minimum operating activities | 0.85
Revenue per hour | 689.5
Oils & Lubricants | 10.1
Fuel Per hour | 160
Overhead cost | 0.05
Insurance | 0.0025
Corporate tax | 0.3
Operating hours
Spreadsheet: 261ec12c-0467-4291-9076-f27043865dbf
Sheet: EPR GO

Gaming Operations
 |  | Second Quarters |  |  |  | Six Months
Periods Ended March 31, | 2014 | 2013 | % Change |  |  | 2014 | 2013 | % Change
(In millions, unless otherwise noted)
Revenue | 230.4 | 254.3 | -0.09398348407392856 |  |  | 453.4 | 496.9 | -0.08754276514389213
Gross profit | 140.4 | 156.7 | -0.1040204211869817 |  |  | 276.6 | 309.8 | -0.1071659134925758
Gross margin | 0.609375 | 0.6162013370035392 | -0.01107809508615198 |  |  | 0.6100573445081605 | 0.6234654860132823 | -0.02150582799837002
Installed base ('000) | 53.40000000000001 | 56.7 | -0.05820105820105803 |  |  | 53.40000000000001 | 56.7 | -0.05820105820105803
Yield (average revenue per unit per day - $0.00) | 47 | 49.26 | -0.0458790093382054 |  |  | 46.11 | 47.99 | -0.0391748280891853
Spreadsheet: 126754d1319868526-counting-cells-meeting-certain-criteria-book1
Sheet: Sheet1

 |  | L |  |  | how to stop panic attacks
 |  | H |  |  | what is anxiety
 |  | M |  |  | anxiety symptoms in men
 |  | H |  |  | what causes anxiety
 |  | M |  |  | what causes panic attacks
 |  | H |  |  | hypochondria
 |  | H |  |  | anxiety during pregnancy
 | L: |  |  | 1 word:
 | M: |  |  | 2 words:
 | H: |  |  | 3 words:
 |  |  |  | 4 words:
 |  |  |  | 5 words: