tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 94877d1294652765-inserting-new-line-into-grouped-data-example-grouping
Sheet: Sheet1

fig | detail
A
A | 1
A | 1
A | 1
A | 2
A | 2
A | 2
A | 2
A | 3
A | 3
B
B
B
B
B
B
B
B
B
B
C
C
C
C
C
C
C
C
C
Spreadsheet: darrell_schoolcraft__7304__imball0201
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -51956 | -24732
9238 | -7340 | -14000 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -1508663 | -1497057
58710 | -119091 | -107740
60921 | -425371 | -438883
78026
500084 | -32722 | -42000
500085 | -1
500097 | -47556 | -56000
INDEX
2001-12-31 00:00:00 |  |  | 766914.32
2002-01-14 00:00:00
CBS Volume
 |  |  | 307322
Spreadsheet: 839767d1692208028-identify-clients-in-a-column-that-fit-multi-row-criteria-client-visits-by-id
Sheet: Sheet1

Employee ID | Client Name Name | Client code | Territory | Visited within last year? | Client status (can a formula go here to generate the answer automatically?) | Explanations
[NAME] | ABC Sign Company | 100 | NYC | No
[NAME] | ABC Sign Company | 100 | NYC | No
[NAME] | ABC Sign Company | 100 | NYC | No
Edna | ABC Sign Company | 100 | NYC | Yes | Satisfied | For any give client, I need at least one 'Yes' in column E. ABC Sign is fine, because Edna visited within the last year
[NAME] | Bones Archaeology | 115 | Philadelphia | No
Zachary | Bones Archaeology | 115 | Philadelphia | No
[NAME] | Bones Archaeology | 115 | Philadelphia | No | Follow-up needed | Nobody visited Bones Archaeology within the last year. Follow-up needed
Timothy | File Cabinet Mfg. | 295 | Denver | Yes
[NAME] | File Cabinet Mfg. | 295 | Denver | Yes
[NAME] | File Cabinet Mfg. | 295 | Denver | No | Satisfied | Timothy and [NAME] visited File Cabinet Mfg, so it's okay that [NAME] did not. No follow-up needed.
[NAME] | Wheels and Tires Inc. | 890 | Columbus | Yes
[NAME] | Wheels and Tires Inc. | 890 | Columbus | Yes | Satisfied | [NAME] and [NAME] both visitied Wheels and Tires Inc. No follow-up needed.
[NAME] | Xylophone Music Store | 901 | Seattle | No | Follow-up needed | [NAME] is the only employee assigned to Xylophone Music Store. He didn’t visit, so follow up is needed.
[NAME] | Yarn and Thread | 953 | Boston | Yes | Satisfied | [NAME] is the only employee assigned to [NAME] and Thread. He visited within the past year. No follow-up needed.
Spreadsheet: 116529d1311881717-counting-weekends-off-master
Sheet: Sheet2

VAC | 8
Training | 8
PER | 8
OFF | 0
9:00 - 10:00 | 1 | Meeting
8:00 - 4:00 | 7
8:00 - 4:30 | 7.5
8:00 - 5:00 | 8
8:30 - 4:30 | 7
8:30 - 5:00 | 7.5
8:30 - 5:30 | 8.5
8:30 - 6:00 | 9
8:30 - 6:30 | 9.5
8:30 - 7:30 | 10
8:30 - 8:00 | 10.5
8:30 - CL | 11
9:00 - 5:00 | 7
9:00 - 5:30 | 7.5
9:00 - 6:00 | 8
9:00 6:30 | 8.5
9:00 - 7:00 | 9
9:00 - 7:30 | 9.5
9:00 - 8:00 | 10
9:00 - CL | 10.5
9:30 - 5:30 | 7
9:30 - 6:00 | 7.5
9:30 - 6:30 | 8
9:30 - 7:00 | 8.5
9:30 - 7:30 | 9
9:30 - 8:00 | 9.5
9:30 - CL | 10
10:00 - 6:00 | 7
10:00 - 6:30 | 7.5
10:00 - 7:00 | 8
10:00 - 7:30 | 8.5
10:00 - 8:00 | 9
10:00 - CL | 9.5
10:30 - 6:30 | 7
10:30 - 7:00 | 7.5
10:30 - 7:30 | 8
10:30 - 8:00 | 8.5
10:30 - CL | 9
10:30 - 12:00 | 1.5
11:00 - 7:00 | 7.5 | Sunday
11:00 - 8:00 | 8
11:30 - CL | 8
11:30 - 8:00 | 7.5
11:30 - 6:30 | 7
11:45 - 6:00 | 5.75 | Sunday
12:00 - 9:00 | 8
Spreadsheet: 274663d1383174962-copy-paste-function-im-lost-with-test-database-2
Sheet: Sheet1

name | number | letter
[NAME] | 2 | s
[NAME] | 6 | d
[NAME] | 8 | h
len | 3 | t
tom | 9 | e
DAVE | 2 | A
Spreadsheet: 157333d1337701847-help-please-in-students-progress-tracking-excel-sheet-sample-report-card
Sheet: Sheet1

 | Students |  | Score |  |  |  |  |  |  |  | Entry Date
 | Y |  | 71 |  |  |  |  |  | 0 |  | 2012-01-01 00:00:00
 | Z | 0 | 86 |  |  |  | 0 | 0 | 0 |  | 2012-05-11 00:00:00
 | Z | 0 | 89 |  |  |  | 0 | 0 | 0 |  | 2012-05-14 00:00:00
 | X | 0 | 60 |  | 0 |  | 0 | 0 | 0 |  | 2012-05-17 00:00:00
 | X | 0 | 85 |  | 0 |  | 0 | 0 | 0 |  | 2012-05-18 00:00:00
 | X | 0 | 75 |  | 0 |  | 0 | 0 | 0 |  | 2012-05-21 00:00:00
Spreadsheet: 164320d1340726482-last-price-paid-vloopup-index-match-sample-resin-log
Sheet: Sheet1

Vendor |  | Material | Car ID | Net Weight | Price $/Lb | PO #
X |  | Enable | XOMX717092 | 45000 | 0.5 | 13426
X |  | EVA | ACFX069704 | 45000 | 2 | 13426
X |  | EVA | ACFX069704 | 45000 | 3 | 13426
X |  | LLDPE | FPAX200617 | 191800 | 4 | 13500
X |  | EVA | [NAME] | 201150 | 2.5 | 13501
Y |  | LLDPE | NCIX834 | 189024 | 0.2 | 13520
X |  | LLDPE | CCBX058015 | 188900 | 1.5 | 13527
X |  | LLDPE | CCBX071295 | 177824 | 0.75 | 13527
Z |  | LLDPE | CCBX059649 | 189994 | 0.9 | 13527
Z |  | LDPE | PLCX042417 | 198600 | 0.55 | 13527
Q |  | EVA | ACFX069704 | 45000 | 0.86 | 13527
 | Cost Sampling
 | EVA | 0.86
 | LDPE | 0.55
 | [NAME] | #N/A
 | Butene | #N/A
 | 1018Met | #N/A
 | Enable | 0.5
 | Repro | #N/A
 | Slip | #N/A
 | A/B | #N/A
Sample Formulation
Material | % | Cost/Lb | Cost
EVA |  | 0.86 | 0
LDPE |  | 0.55 | 0
[NAME] |  | #N/A | #N/A
Butene |  | #N/A | #N/A
1018Met |  | #N/A | #N/A
Enable |  | 0.5 | 0
Repro |  | #N/A | #N/A
Slip |  | #N/A | #N/A
A/B |  | #N/A | #N/A
Total | 0 |  | #N/A
Spreadsheet: 062a1dae-9b7a-4568-8dbb-52718f8b2b52
Sheet: Page 1

Council on Occupational Education
REIMBURSEMENT POLICY
1 | SCANNED COPIES OF ORIGINAL RECEIPTS ARE REQUIRED.  Attach all scanned receipts for airline travel, car rentals, hotel bills,
 | and meals. PRINT THIS FILE AND RECEIPTS IN PDF FORMAT and submit via email to: [EMAIL].
 | (See item 5 below for individual meals.)
2 | TRAVEL BY COMMON CARRIER (airplane, train, bus, boat, etc.)  will be reimbursed at the NORMAL ECONOMY RATE
 | or actual cost, whichever is less, plus the necessary expense to and from the place of departure of the common carrier.
3 | PERSONAL AUTOMOBILE usage, if requested, is authorized at the current IRS-approved rate by the most direct route.
 | The maximum allowable reimbursement including en route expenses, may not exceed the published tourist airfare
 | to and from the site of the meeting. |  |  | Fill out worksheet below.  Totals will be carried to front.
4 | CAR RENTAL required advance authorization by the Council or institution.
5 | MEALS- Scan original receipts for all individual and/or group meal expenses.
 |  |  | Fill out worksheet below.  Totals will be carried to front.
6 | NON-REIMBURSABLE EXPENSES include items not directly related to COE business, such as telephone
 | calls, lodging and meals for family members and guests, movies, entertainment, etc.
 | PAYMENT OF NON-REIMBURSABLE EXPENSES:  If you are authorized to sign the hotel bill on check
 | out, pay for non-reimbursable expenses at that time and have the hotel deduct this from the final bill sent to
 | COE.  In other cases, non-reimbursable expenses are to be deducted from the total of expenses.
 | PERSONAL MILEAGE WORKSHEET
 | Rate per mile |  | 0.56
 | DATE
 | Mileage
 | TOTAL
 | Note:  If mileage is to and from airport, use date of departure with mileage
 | and date of return with mileage
 | MEALS WORKSHEET
 | DATE
 | BREAKFAST
 | LUNCH
 | DINNER
 | TOTAL
Spreadsheet: 537147d1504837074-how-to-setup-a-record-in-a-table-that-may-have-multiple-rows-of-data-in-a-certain-field-how-to-setup-a-record-in-a-table-that-may-have-multiple-rows-of-data-in-a-certain-fiel
Sheet: Sheet1

[NAME] | Customer | Item | Quantity | helper | Sorted > | [NAME] | Customer | Item | Quantity |  | [NAME] | [NAME] | Customer | Item | Quantity |  |  | Sorting > | [NAME] | Customer | Item | Quantity |  | [NAME] | [NAME] | Customer | Item | Quantity
1 | AAAA | Product1 | 2 |  | By formula |  |  |  |  |  | Applied to |  |  |  |  |  |  | Manually | 1 | AAAA | Product1 | 2 |  | Applied to
1 | AAAA | Product2 | 1 |  |  |  |  |  |  |  | G:J |  |  |  |  |  |  |  | 1 | AAAA | Product2 | 1 |  | T:W
2 | BBBB | Product3 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | BBBB | Product3 | 4
2 | BBBB | Product1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | BBBB | Product1 | 2
2 | BBBB | Product4 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | BBBB | Product4 | 1
3 | CCCC | Product1 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | CCCC | Product1 | 3
4 | DDDD | Product3 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | CCCC | Product2 | 3
5 | DDDD | Product1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | DDDD | Product3 | 5
3 | CCCC | Product2 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | DDDD | Product1 | 2
Spreadsheet: 744534d1629292607-apurar-valores-movimentoviaturas
Sheet: Folha1

Data | Viatura | [NAME] | [NAME]
2021-08-01 00:00:00 | Viatura A | 10:00:00 | 10:20:00
2021-08-01 00:00:00 | Viatura B | 10:05:00 | 10:45:00
2021-08-01 00:00:00 | Viatura C | 10:10:00 | 10:45:00
2021-08-01 00:00:00 | Viatura A | 10:30:00 | 11:00:00
2021-08-01 00:00:00 | Viaura D | 10:35:00 | 11:25:00
2021-08-01 00:00:00 | Viatura E | 10:45:00 | 13:00:00
2021-08-01 00:00:00 | Viatura B | 11:00:00 | 11:30:00
2021-08-01 00:00:00 | Viatura C | 12:00:00 | 14:00:00
2021-08-01 00:00:00 | Viatura A | 12:30:00 | 14:00:00
2021-08-01 00:00:00 | Viatura D | 13:00:00 | 13:10:00
2021-08-01 00:00:00 | Viatura E | 13:30:00 | 15:00:00
2021-08-01 00:00:00 | Viatura A | 15:00:00 | 18:00:00
2021-08-01 00:00:00 | Viatura B | 15:50:00 | 16:00:00
2021-08-01 00:00:00 | Viatura C | 17:00:00 | 17:15:00
2021-08-01 00:00:00 | Viatura D | 17:30:00 | 18:00:00
Spreadsheet: 99858d1298403281-calculating-fuel-economy-from-a-list-of-purchases-samplefile
Sheet: Fleet report

Vehicle: | Gallons: | Start Miles | End Miles | [NAME]: | Miles per gallon:
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
Spreadsheet: 802512d1666889102-need-a-formula-that-will-only-perform-a-calculation-every-2-columns-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | 20 Year Cost Calculation
Apple |  |  |  |  |  |  |  |  |  |  |  |  | Average Cost Increase |  |  | 0.02
 |  | Hardware | Model | MSRP | [NAME] | Cost | Quantity | Total Cost
 |  | Ipad | 10th G, 256GB | 599 | 0.02 |  | 5000
 |  | Wifi Cellular |  | 150 | 0.02 |  | 5000 |  |  |  |  | Year
 |  | Apple Pencil |  | 99 | 0.02 |  | 5000 |  |  |  |  | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 22 | 23 | 24
 |  | Keyboard |  | 249 | 0.02 |  | 5000
 |  | Total
 |  | MDM |  | MSRP |  | Cost | Quantity | Total Cost |  |  |  | 12 Year Total Cost
 |  | XYZ |  | 84 | 0 |  | 5000 |  |  |  |  | 24 Year Total Cost
 |  | Of course. See attached. So in my head, what I would like to do is tell excel for every 3 columns or nth columns perform this calculation, otherwise the value is $0.
Lenovo
 |  | Hardware | Model | MSRP | [NAME] | Cost | Quantity | Total Cost
 |  | Thinkpad | [NAME] | 1399 | 0.15 |  | 5000
 |  |  |  |  |  |  |  |  |  |  |  | Year
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 22 | 23 | 24
 |  | MDM |  | MSRP |  | Cost | Quantity | Total Cost |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
 |  | XYZ |  | 84 | 0 |  | 5000
 |  |  |  |  |  |  |  |  |  |  |  | 12 Year Total Cost
 |  |  |  |  |  |  |  |  |  |  |  | 20 Year Total Cost
Spreadsheet: 2047a074-374d-4a16-916f-3e82e3d8267e
Sheet: FA 26 - Data

[NAME]
Focus Area 26 - Substance Abuse - Pennsylvania
Objective Number | Objective Title | Baseline Data | Final Data | HP2010 Goal | Target Progress
26-01b | Alcohol-related Motor Vehicle Crash Injuries (rate per 100,000 population) | 87 (2004) | 78 (2008) | 65 | Moved toward target
26-02 | Cirrhosis Deaths (age-adjusted per 100,000 population) | 8.3 (1996) | 7.6 (2008) | 3 | Moved toward target
26-03 | Drug-induced Deaths (age-adjusted per 100,000 population) | 7.6 (1996) | 15.3 (2008) | 1 | Moved away from target
26-09a | Average Age of First Use of Alcohol among Adolescents (aged 12-17) | 13.3 ± 0.2 (2005) | 13.8 ± 0.2 (2008) | 16.1 | Moved toward target
26-09b | Average Age of First Use of [NAME] among Adolescents (aged 12-17) | 13.8 ± 0.3 (2005) | 14.2 ± 0.3 (2008) | 17.4 | Moved toward target
26-09c | High School Seniors who never Used any Alcoholic Beverages (percentage) | 17 ± 3 (2005) | 22 ± 4 (2007) | 29 | Moved toward target
26-10a | Adolescents (aged 12-17) not Using Alcohol or Illicit Drugs in the Past 30 Days (percentage) | 81 ± 2 (2005) | 84 ± 2 (2008) | 91 | Moved toward target
26-10b | Adolescents (aged 12-17) Using [NAME] in the Past 30 Days (percentage) | 5.7 ± 1.4 (2005) | 6.5 ± 1.6 (2008) | 0.7 | Moved away from target
26-10c | Adults Using Illicit Drugs in the Past 30 Days (percentage) | 6.8 ± 1.3 (2002) | 6.1 ± 1.1 (2008) | 3.2 | Exhibited no change
26-11a | High School Seniors who Engaged in Binge Drinking in the Past 2 Weeks (percentage) | 34 ± 4 (2005) | 26 ± 6 (2007) | 11 | Moved toward target
26-11c | Adults who Engaged in Binge Drinking in the Past Month (percentage) | 17 ± 1 (1996) | 17 ± 1 (2009) | 6 | Exhibited no change
26-15 | Adolescents (aged 12-17) who Used Inhalants in the Past Year (percentage) | 4.9 ± 1.2 (2005) | 3.4 ± 1.1 (2008) | 0.7 | Moved toward target
26-16a | 8th Graders who Disapprove of Drinking Alcohol Regularly (percentage) | 87 ± 2 (2005) | 86 ± 1 (2007) | 83 | Met or exceeded target
26-16b | 10th Graders who Disapprove of Drinking Alcohol Regularly (percentage) | 61 ± 3 (2005) | 69 ± 3 (2007) | 83 | Moved toward target
26-16c | 12th Graders who Disapprove of Drinking Alcohol Regularly (percentage) | 48 ± 2 (2005) | 63 ± 6 (2007) | 83 | Moved toward target
26-16d | 8th Graders who [NAME] they would never Use [NAME] (percentage) | 84 ± 2 (2005) | 87 ± 2 (2007) | 72 | Met or exceeded target
26-16e | 10th Graders who [NAME] they would never Use [NAME] (percentage) | 65 ± 4 (2005) | 67 ± 4 (2007) | 72 | Moved toward target
26-16f | 12th Graders who [NAME] they would never Use [NAME] (percentage) | 50 ± 5 (2005) | 59 ± 5 (2007) | 72 | Moved toward target
26-25 | State has a Maximum Blood Alcohol Concentration of 0.08% for Motor Vehicle Drivers (aged 21+) | No (2001) | Yes (2009) | Yes | Met or exceeded target
Note: The list of objectives above are limited to those for which Pennsylvania data were available.
Spreadsheet: 0da53fea-2803-4d2f-bb56-556a73e9173c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-06-25 09:27:13.260000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.654 | 102.529 | 102.404 | 102.029
4.5 | 102.615 | 102.49 | 102.365 | 101.99 |  | Note: | Refer To Price [NAME]
4.375 | 102.28 | 102.155 | 102.03 | 101.655 |  |  | For all Price Adjs
4.25 | 101.68 | 101.555 | 101.43 | 100.805
4.125 | 100.814 | 100.689 | 100.564 | 99.939
4 | 99.818 | 99.693 | 99.568 | 98.943
3.875 | 98.783 | 98.658 | 98.533 | 97.908
3.75 | 97.908 | 97.783 | 97.658 | 97.033
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.875 | 102.75 | 102.625 | 102.25
3.625 | 102.528 | 102.403 | 102.278 | 101.903
3.5 | 101.98 | 101.855 | 101.73 | 101.355
3.375 | 101.258 | 101.133 | 101.008 | 100.633
3.25 | 100.629 | 100.504 | 100.379 | 99.754
3.125 | 100.192 | 100.067 | 99.942 | 99.317
3 | 99.442 | 99.317 | 99.192 | 98.567 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-07-09 09:27:13.260000
30 DAY | 2014-07-24 09:27:13.260000
45 DAY | 2014-08-08 09:27:13.260000
60 DAY | 2014-08-23 09:27:13.260000
90 DAY | 2014-09-22 09:27:13.260000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: darrell_schoolcraft__7295__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | 2001-12-07 00:00:00
 |  |  | SoCal Gas Price |  | 2.35
 |  |  | San Juan Gas Price |  | 1.95
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
California Gas Day
he 6 | 07:00:00 |  | 0 | 0 | 0 | 545 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 545 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 545 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 545 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 545 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 545 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 545 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 545 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 545 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 545 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 545 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 545 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 545 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 545 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 545 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 545 | 7
he22 | 23:00:00 |  | 0 | 0 | 0 | 545 | 7
he23 | 12:00:00 |  | 0 | 0 | 0 | 545 | 7
he24 | 01:00:00 |  | 0 | 0 | 0 | 545 | 7
he1 | 02:00:00 |  | 0 | 0 | 0 | 545 | 7
he2 | 03:00:00 |  | 0 | 0 | 0 | 545 | 7
he3 | 04:00:00 |  | 0 | 0 | 0 | 545 | 7
he4 | 05:00:00 |  | 0 | 0 | 0 | 545 | 7
[NAME] | 06:00:00 |  | 0 | 0 | 0 | 545 | 7
Spreadsheet: 72439d1273124534-auto-fill-cell-with-text-based-on-colour-of-cell-excel-2007-audit-score-sample
Sheet: Sheet1

Business Unit | Region | Period | Project No. | Audit Score | Status
WAE | NSW | P1012 | EN02788 | 85 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BIF | ASIA | P1012
WAE | NSW | P1012 | EN02789 | 83 |  |  |  |  | I need to be able to also have the text of the colour in this cell. |  |  |  |  |  |  |  |  |  | MIN | CHI | P1013
 |  |  |  | 79 |  |  |  |  | eg: F2, F3 "Green" in the cell |  |  |  |  |  |  |  |  |  | PAE | EUR | P1101
 |  |  |  | 48 |  |  |  |  | F4 "Amber" |  |  |  |  |  |  |  |  |  | WAE | NSW | P1102
 |  |  |  |  |  |  |  |  | etc |  |  |  |  |  |  |  |  |  |  | NZ | P1103
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QLD | P1104
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEA | P1105
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WANT | P1106
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1107
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1108
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1109
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1110
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1112
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1113
Spreadsheet: 889675d1740579174-highlight-the-cells-where-text-isnt-found-in-a-list-planning-tool-master-12-monthly-recall-dates-option-
Sheet: Phased programme - James Versio

Name | ??????? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Consolidated recall |  |  | Unspecified Appt durations | Appt Durations |  |  |  |  | Total days due in programme =
Recalls as at | ??????? |  |  |  |  |  |  |  |  |  |  |  |  |  | Absolute recall - Due by |  |  | Due in plan |  | Block 1 | Block 2 | Block 3 |  | Block 1 | Block 2 | Block 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-30 00:00:00 | 2023-12-31 00:00:00 | 2024-12-31 00:00:00
Surname | Forename | Date Of Birth | Site | Audiometry surveillance | Biological Monitoring | FLT Driver | [NAME] (LGV/PSV) | [NAME] | Respiratory surveillance | Skin surveillance | Work at Heights
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days By | Days By | Days By
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | Count of Forename |  |  |  | Total Programme Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Newport Street | 608
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Coypool | 1124
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 372
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 394
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | South Yard | 405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Langage | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 2906
Spreadsheet: 173547d1344596586-create-a-deliminated-string-from-titles-of-array-of-data-depending-on-if-a-value-exists-example-data-variant-issue
Sheet: Sheet1

[NAME] Size:Voltage:Amperage or [NAME] | Size | Voltage | Amperage | Type
 |  | 110v (16amp)
 |  | 240v (16amp)
 |  | 110v (16amp)
 |  | 240v (16amp)
 |  |  |  | 4x 110v 16A Sockets
 |  |  |  | 2x 110v 16A Sockets
 |  |  |  | 2x 230v 13A Sockets
 |  | 240v
 |  | 110v
 |  | 240v
 |  | 110v
 |  | 110v
 |  | 240v
 |  | 110v
 |  | 240v
 |  | 110v
 |  | 240v
 |  | 110v
 |  | 240v
 | 5ft | 110v
 | 5ft | 230v
 |  | 110v |  | Single head
 |  | 110v |  | Twin head
 |  | 240v |  | Single head
 |  | 240v |  | Twin head
 |  | 110v |  | Twin head
 |  | 110v |  | Single head
 |  | 240v |  | Twin head
 |  | 240v |  | Single head
 | 2ft | 110v
 |  | 110v |  | Without PTP
 |  | 230v |  | Without PTP
 |  | 110v |  | With PTP
 |  | 230v |  | With PTP
 |  | 110v |  | Without PTP
 |  | 230v |  | Without PTP
 |  | 110v |  | With PTP
 |  | 230v |  | Without PTP
 |  | 110v |  | Without PTP
 |  | 230v |  | With PTP
 |  | 110v |  | With PTP
 | 5ft length
 | 2ft length
 | 2ft | 230v
 |  | 110v
 |  | 240v
 |  | 110v
 |  | 240v
 |  | 110v
 |  | 240v
 |  | 240v
 |  | 240v |  | Single head
 |  | 240v |  | Twin head
 |  | 110v
 |  | 110v |  | Single head
 |  | 110v |  | Twin head
 |  | 240v
 |  | 110v
 |  | 240v
 |  | 110v
 |  | 110v
 |  | 240v
 |  | 110v
 |  | 240v
 |  | 110v
 |  | 240v
 |  | 110v
 |  | 240v
 | 14m x 1.5mm | 110v | 16amp
 | 10m x 1.5mm | 110v | 16amp
 | 14m x 2.5mm | 110v | 16amp
 | 10m x 2.5mm | 110v | 16amp
 | 14m x 1.5mm | 240v | 16amp
 | 10m x 1.5mm | 240v | 16amp
 | 10m x 2.5mm | 240v | 16amp
 | 14m x 2.5mm | 240v | 16amp
 | 14m x 1.5mm | 240v | 13amp
 | 10m x 1.5mm | 240v | 13amp
 | 14m x 2.5mm | 240v | 13amp
 | 25m x 1.5mm | 110v | 16amp
 | 25m x 2.5mm | 110v | 16amp
 | 25m x 2.5mm | 240v | 16amp
 | 14m x 2.5mm | 110v | 32amp
 | 25m x 1.5mm | 240v | 16amp
 | 14m x 2.5mm | 240v | 32amp
 | 14m x 4.0mm | 110v | 32amp
 | 14m x 4.0mm | 240v | 32amp
 | 25m x 2.5mm | 110v | 32amp
 | 25m x 2.5mm | 240v | 32amp
 | 25m x 4.0mm | 110v | 32amp
 |  | 240v
 |  | 240v
 |  | 110v
 |  | 110v
 | 1.5[NAME] cable
 | 2.5mm cable
 | 1.5[NAME] cable
 | 2.5mm cable
 | 1.5mm / 2-Core
 | 1.5mm / 2-Core
 | 2.5mm / 2-Core
 | 2.5mm / 2-Core
 | 1.5mm / 3-Core
 | 2.5mm / 3-Core
 | 1.5mm / 3-Core
 | 2.5mm / 3-Core
 | 4.0mm / 3-Core
 | 4.0mm / 3-Core
 | 1.0mm / 2-Core
 | 1.5mm / 2-Core
 | 2.5mm / 2-Core
 | 1.0mm / 3-Core
 | 1.5mm / 3-Core
 | 2.5mm / 3-Core
 | 4.0mm / 3-Core
 |  |  |  | 3m spacing / ES fittings
 |  |  |  | 5m spacing / ES fittings
 |  |  |  | 3m spacing / BC fittings
 |  |  |  | 5m spacing / BC fittings
 |  | 110v
 |  | 240v
 |  |  |  | ES fittings
 |  |  |  | BC fittings
Spreadsheet: 106023d1303254562-date-and-time-arrangement-date-and-time
Sheet: Sheet1

given | given | result
yyyymmdd | hhmm | [NAME]/dd/yyyy hh:[NAME]
20090101 | 53 | 2009-01-01 00:53:00
20090102 | 153
20090103 | 253
20090104 | 353
20090105 | 453
20090106 | 553
20090107 | 653
20090108 | 753
20090109 | 853
20090110 | 953
20090111 | 1008
20090112 | 1023
20090113 | 1051
20090114 | 1053
20090115 | 1153
20090116 | 1253