tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 71907d1272572526-percentages-off-2-text-based-fields-education-database
Sheet: Reports

Total Number of Staff = | 12 |  | Clinical Staff completed Course 1 | 1 |  |  | Course 1 | Course 2 | Course 3
Number of Administration Staff = | 1 |  | Clinical Staff completed Course 2 | 0.5 |  | Administration | 1 | 1 | 1
Number of Allied Health Staff = | 1 |  | Clinical Staff completed Course 3 | 0.5 |  | Allied Health | 1 | 0 | 0
Number of Catering Staff = | 1 |  |  |  |  | Catering | 1 | 1 | 1
Number of Executive Staff = | 1 |  | Non Clinical Staff completed Course 1 | 0.75 |  | Executive | 1 | 1 | 0
Number of Housekeeping Staff = | 1 |  | Non Clinical Staff completed Course 2 | 0.375 |  | Housekeeping | 1 | 1 | 1
Number of ICU Staff = | 1 |  | Non Clinical Staff completed Course 3 | 0.75 |  | ICU | 1 | 0 | 0
Number of Maintenance Staff = | 1 |  |  |  |  | Maintenance | 0 | 0 | 1
Number of Maternity Staff = | 2 |  | Course 1 Completed % = | 0.9166666666666666 |  | Maternity | 1 | 1 | 1
Number of Medical Staff = | 1 |  | Course 2 Completed % = | 0.5833333333333334 |  | Medical | 1 | 0 | 1
Number of Operating Theatre Staff = | 2 |  | Course 3 Completed % = | 0.5833333333333334 |  | Operating Theatre | 1 | 0.5 | 0
Number of Rehab Staff = | 0 |  |  |  |  | Rehab | #N/A | #N/A | #N/A
Number of Surgical Staff = | 0 |  |  |  |  | Surgical | #N/A | #N/A | #N/A
Number of Wards General Staff= | 0 |  |  |  |  | Wards General | #N/A | #N/A | #N/A
Spreadsheet: 67130d1267730457-excel-2007-excel-two-category-multi-data-stacked-chart-pt-2003
Sheet: Data

Month | A | B | C | Type
1 | 14 | 12 | 11 | Planned
1 | 20 | 10 | 14 | Actual
2 | 12 | 14 | 14 | Planned
2 | 20 | 15 | 18 | Actual
3 | 17 | 19 | 10 | Planned
3 | 20 | 16 | 18 | Actual
4 | 16 | 20 | 12 | Planned
4 | 19 | 17 | 16 | Actual
5 | 20 | 20 | 12 | Planned
5 | 17 | 15 | 20 | Actual
6 | 19 | 20 | 19 | Planned
6 | 12 | 12 | 11 | Actual
7 | 11 | 10 | 14 | Planned
7 | 13 | 17 | 13 | Actual
8 | 20 | 19 | 13 | Planned
8 | 18 | 11 | 20 | Actual
9 | 18 | 20 | 10 | Planned
9 | 16 | 10 | 11 | Actual
10 | 10 | 17 | 19 | Planned
10 | 20 | 20 | 19 | Actual
11 | 19 | 13 | 11 | Planned
11 | 17 | 15 | 14 | Actual
12 | 11 | 14 | 19 | Planned
12 | 13 | 12 | 15 | Actual
Spreadsheet: 825913d1681638342-using-mod-and-if-to-find-cell-value-vs-reference-and-show-if-divisible-but-i-have-an-issue-newsample_ceepeebee
Sheet: Scenario 1 - working

Week Date | 2023-05-04 00:00:00
Name | Team | Starting Weight | Starting Height | Starting BMI | Concurrent Week Losses | Hat-Trick | 2023-04-06 00:00:00
 |  |  |  |  |  |  | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg)
Stephan | White | 129 | 180 |  | 0 |  | 128 | 128 | 124 | 125 | 124
Stephan has lost weight 3 times in total since starting. The 3rd of his losses comes on the current date. This should trigger a Hat Trick. Which is does.
Spreadsheet: 838389d1690980318-help-with-xlookup-formula-with-multiple-criteria-book1-182-aligw
Sheet: Projects

 | Absences/Holidays | Programme 1 | Programme 2 | Programme 3 | Programme 4 | Non Projects | Programme 5 | Training
 | Absence - Bank Holiday | Programme 1 - Task 1 | Area Department - Task 1 | Programme 3 - Task 1 | Programme 4 - Task 1 | Non Project Meetings - Non Project Meetings | Programme 5 - Task 1 | Training - e-learning
 | Absence - Holiday | Programme 1 - Task 2 | Area Department - Task 2 | Programme 3 - Task 2 | Programme 4 - Task 2 | Line Management - Line Management |  | Training - Induction
 | Absence - Other Authorised Absence | Programme 1 - 1234 - Project Name | Area Department - 1234 - Project Name |  |  | Managing Achievement - Managing Achievement |  | Training - Mentoring/Knowledge Transfer
 | Absence - Sickness | Programme 1 - 2345 - Project Name | Area Department - 2345 - Project Name |  |  |  |  | Training - Personal Development
 |  | Programme 1 - 3456 - Project Name |  |  |  |  |  | Training - Training Course
 |  | Programme 1 - 4567 - Project Name
Spreadsheet: 0a6a863c-3fea-4cb0-88be-61b518296a62
Sheet: Sheet1

Tolerances dimesions and form according to EN 1386 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Tolerances on pattern height
 | Pattern type |  | Range of thickness t |  | Raised pattern
 |  |  |  |  | Nominal height h | [NAME]. permissible deviation on nominal height h
 | Barley seed |  | 1,2 to 3,5 |  | 0,5 | ± 0,2
 | 2-bar/5-bar/Diamond |  | 1,2 to 1,5 |  | 0,5 | ± 0,3
 |  |  | > 1,5 to 2,5 |  | 1,0 | ± 0,4
 |  |  | >2,5 to 20,0 |  | 1,5 | ± 0,6
 | Almond               Standard height |  | 2,5 to 20,0 |  | 2,5 | ± 0,6
 | Almond               Reduced height |  | 2,5 to 20,0 |  | 1,0 | ± 0,4
 | Tolerances on specified thickness
 | Range of nominal thickness t |  | Maximum permissible deviation for nominal width
 |  |  | up to and including 1600 |  | over 1600 up to and icluding 2500
 | [NAME] 1,2 to 2,5 |  | ± 0,20 |  | ± 0,30
 | > 2,5 to 3,5 |  | ± 0,30 |  | ± 0,40
 | > 3,5 to 6,5 |  | ± 0,40 |  | ± 0,50
 | > 6,5 to12,5 |  | ± 0,50 |  | ± 0,60
 | > 12,5 to 20,0 |  | ± 1,0 |  | ± 1,0
 | Width and length tolerances
 | Nominal thickness t |  | [NAME] |  | Length
 |  |  | [NAME] 1500 | 1500<w≤2500 | [NAME] | 2000<w≤5000 | w > 5000
 | 1,2 ≤ t ≤ 3,0 |  | 0 / +8 | 0 / +8 | 0 / +8 | 0 / +10 | 0 / +12
 | 3,0 < t ≤ 8,0 |  | 0 / +8 | 0 / +10 | 0 / +8 | 0 / +10 | 0 / +12
 | t > 8,0 |  | 0 / +5 | 0 / +8 | 0 / +6 | 0 / +8 | 0 / +10
 | The maximum deviation from straightness for strip widht up to and including 25000 mm shall not exceed 5 mm
 | Flatness tolerances for sheets and plates
 | Nominal thickness t |  | Maximum total deviation
 |  |  | on length | on width
 | 1,2 ≤ t ≤ 3,0 |  | 0,4 % | 0,5 %
 | 3,0 < t ≤ 8,0 |  | 0,3 % | 0,4 %
 | t > 8,0 |  | 0,2 % | 0,4 %
 | Squareness tolerances for sheets and plates
 | Nominal length L |  | Squareness tolerance for nominal width
 | L > | L ≤ | [NAME] | 1000<w≤1500 | 1500<w≤2000 | 2000<w≤3500
 |  | 2000 | 6 | 7 | 8 | -
 | 2000 | 3000 | 7 | 7 | 9 | 10
 | 3000 | 3500 | 7 | 8 | 10 | 10
 | 3500 | 5000 | 8 | 10 | 10 | 12
 | 5000 | - | 12 | 12 | 15 | 15
Spreadsheet: kim_ward__20941__pasadena 0301
Sheet: Invoice

City of Pasadena
March 2001 Invoice
# of Days | 31
[NAME] | 12.58
IFGMR EP San Juan | 4.83
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Gas Daily | Gas Daily | Gas Daily | Gas Daily
 |  |  |  |  |  | Gas Daily | SoCal | Pasadena |  | Fixed Price | KRS | Add'l | Pasadena | Purchases | Purchases | Sales | Sales
 | Border |  |  |  |  | Mid | Usage | Net Nom | APEA | Delivery | Delivery | Delivery | Imbalance | from EPMI | from EPMI | to EPMI | to EPMI
Pasadena | MMBtu | $/MMBtu | Amount Due |  | Date | $/MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | $ | MMBtu | $
Total Nomination |  |  |  |  | 2001-03-01 00:00:00 | 12.955 | 8481 |  |  | 1500 | 3944
APEA Nomination |  |  |  |  | 2001-03-02 00:00:00 | 23.95 | 8281
Net Nomination |  |  |  |  | 2001-03-03 00:00:00 | 27.79 | 8950
 |  |  |  |  | 2001-03-04 00:00:00 | 27.79 | 8996
Usage |  |  |  |  | 2001-03-05 00:00:00 | 27.79 | 9059
Less APEA Usage |  |  |  |  | 2001-03-06 00:00:00 | 31.31 | 7499
Net Usage |  |  |  |  | 2001-03-07 00:00:00 | 25.265 | 7649
 |  |  |  |  | 2001-03-08 00:00:00 | 14.28 | 9218
Enron Sales to Pasadena |  |  |  |  | 2001-03-09 00:00:00 | 12.825 | 8056
NGI Deliveries |  |  |  |  | 2001-03-10 00:00:00 | 12.505 | 7736
Fixed Price Deliveries |  | 7.63 |  |  | 2001-03-11 00:00:00 | 12.505 | 7454
Fixed Price Deliveries |  | 7.71 |  |  | 2001-03-12 00:00:00 | 12.505 | 7822
 |  |  |  |  | 2001-03-13 00:00:00 | 11.565 | 7658
Gas Daily Deliveries |  |  |  |  | 2001-03-14 00:00:00 | 10.92 | 8504
Gas Daily Purchases |  |  |  |  | 2001-03-15 00:00:00 | 9.535 | 8105
Net Usage |  |  |  |  | 2001-03-16 00:00:00 | 9.41 | 6977
 |  |  |  |  | 2001-03-17 00:00:00 | 9.025 | 6260
Enron Purchases from Pasadena |  |  |  |  | 2001-03-18 00:00:00 | 9.025 | 6171
Kern River Station Purchases | 123501 |  |  |  | 2001-03-19 00:00:00 | 9.025 | 9055
 |  |  |  |  | 2001-03-20 00:00:00 | 9.945 | 11121
El Paso Capacity |  |  |  |  | 2001-03-21 00:00:00 | 11.035 | 7417
Fixed (demand charge) |  | 7 |  |  | 2001-03-22 00:00:00 | 11.605 | 7577
Variable  (demand charge) | 113558 |  |  |  | 2001-03-23 00:00:00 | 10.995 | 6599
 |  |  |  |  | 2001-03-24 00:00:00 | 11.13 | 6595
Net Due Enron/(Pasadena) |  |  |  |  | 2001-03-25 00:00:00 | 11.13 | 7661
 |  |  |  |  | 2001-03-26 00:00:00 | 11.13 | 6748
 | $/MMBtu |  |  |  | 2001-03-27 00:00:00 | 10.25 | 4069
KRS NGI Delivery | 0.05 |  |  |  | 2001-03-28 00:00:00 | 10.78 | 5304
 |  |  |  |  | 2001-03-29 00:00:00 | 13.585 | 5859
KRS NGI Supply | 0.04 |  |  |  | 2001-03-30 00:00:00 | 14.015 | 4038
 |  |  |  |  | 2001-03-31 00:00:00 | 14.25 | 0
Fuel |  |  |  |  | Totals
Variable | 0.026
 |  |  | should be zero
 |  |  | should be zero
Spreadsheet: 866154d1713113980-trying-to-number-rows-that-start-with-a-specific-word-or-phrase-count-word-etaf
Sheet: Sheet1

 |  | published
 |  | published
 |  | published
 |  | published
 |  | published
 |  | published
 |  | published
 |  | published
Spreadsheet: 91879d1291585896-how-do-i-accomplish-variable-date-controlled-summation-of-data-attendance-book-forum-sample
Sheet: Summ

 | Marking Period |  |  |  |  |  |  |  |  |  | Marking Period |  |  |  |  |  |  |  |  |  | Marking Period
Students: | 1 |  |  | 2 |  |  | 3 |  |  |  | 1 |  |  | 2 |  |  | 3 |  |  |  | 1 |  |  | 2 |  |  | 3
K | A | L | Le | A | L | Le | A | L | Le | First | A | L | Le | A | L | Le | A | L | Le | 2nd | A | L | Le | A | L | Le | A | L | Le
Marking Periods
Start | 2010-08-15 00:00:00
End 1 | 2010-11-01 00:00:00
End 2 | 2011-01-01 00:00:00
End 3 | 2011-06-20 00:00:00
Spreadsheet: 70726d1271425828-sum-time-taken-to-run-report-with-date-range-cello-1-
Sheet: Sheet1

 | Date |  |  |  |  | report | Time | Month to report |  |  | Inst | [NAME] | idl | TOTALS
 | 2010-01-06 00:00:00 |  |  |  |  | inst | 1 | 2010-02-01 00:00:00 |  |  | 1 | 2 | 8 | 11 |  | 2010-01-01 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  | inst | 2.5 |  |  | Time to complete |  |  |  | 0 |  | 2010-02-01 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  | inst | 2 |  |  | average time |  |  |  | 0 |  | 2010-03-01 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  | inst | 3 |  |  |  |  |  |  |  |  | 2010-04-01 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  | [NAME] | 2 |  |  |  |  |  |  |  |  | 2010-05-01 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  | idl | 1.5 |  |  |  |  |  |  |  |  | 2010-06-01 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  | [NAME] | 2 |  |  |  |  |  |  |  |  | 2010-07-01 00:00:00
 | 2010-01-08 00:00:00 |  |  |  |  | [NAME] | 2 |  |  |  |  |  |  |  |  | 2010-08-01 00:00:00
 | 2010-01-08 00:00:00 |  |  |  |  | [NAME] | 2.5 |  |  |  |  |  |  |  |  | 2010-09-01 00:00:00
 | 2010-01-08 00:00:00 |  |  |  |  | [NAME] | 1 |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00
 | 2010-01-08 00:00:00 |  |  |  |  | [NAME] | 1 |  |  |  |  |  |  |  |  | 2010-11-01 00:00:00
 | 2010-02-08 00:00:00 |  |  |  |  | [NAME] | 1 |  |  |  |  |  |  |  |  | 2010-12-01 00:00:00
 | 2010-02-09 00:00:00 |  |  |  |  | [NAME] | 1
 | 2010-02-10 00:00:00 |  |  |  |  | idl | 2
 | 2010-02-11 00:00:00 |  |  |  |  | idl | 1.5
 | 2010-02-12 00:00:00 |  |  |  |  | idl | 3.25
 | 2010-02-13 00:00:00 |  |  |  |  | idl | 1
 | 2010-02-14 00:00:00 |  |  |  |  | inst | 1
 | 2010-02-15 00:00:00 |  |  |  |  | idl | 1.5
 | 2010-02-16 00:00:00 |  |  |  |  | idl | 2
 | 2010-02-17 00:00:00 |  |  |  |  | idl | 2
 | 2010-02-18 00:00:00 |  |  |  |  | idl | 1
 | 2010-03-13 00:00:00 |  |  |  |  | inst | 2
 | 2010-03-14 00:00:00 |  |  |  |  | inst | 2
 | 2010-03-15 00:00:00 |  |  |  |  | inst | 2.5
 | 2010-03-16 00:00:00 |  |  |  |  | inst | 2
 | 2010-03-17 00:00:00 |  |  |  |  | inst | 1.5
 | 2010-03-18 00:00:00 |  |  |  |  | inst | 1.5
 | 2010-03-19 00:00:00 |  |  |  |  | inst | 1.5
 | 2010-03-20 00:00:00 |  |  |  |  | inst | 2
 | 2010-03-21 00:00:00 |  |  |  |  | inst | 1
 | 2010-03-22 00:00:00 |  |  |  |  | inst | 2
 | 2010-03-23 00:00:00 |  |  |  |  | [NAME] | 2
 | 2010-03-24 00:00:00 |  |  |  |  | idl | 1.5
 | 2010-03-25 00:00:00 |  |  |  |  | idl | 2
Spreadsheet: 755641d1637003148-if-formula-to-ignore-result-if-both-index-functions-return-from-the-same-cell-georgie_t
Sheet: Sheet2

 | Score at: |  |  |  |  | Change?
 | 1 month | 6 months | 12 months
[NAME] | 4.666666666666667 | 0 | Insufficient data
Fred | 7.333333333333333 | Insufficient data | Insufficient data
[NAME] | 9 | 7 | 10
Greg | 6 | 10 | Insufficient data
Sara | 3.666666666666667 | Insufficient data | Insufficient data
Lara | 8 | Insufficient data | 8
[NAME] | 8.333333333333334 | Insufficient data | 7
[NAME] | Insufficient data | Insufficient data | Insufficient data |  |  |  | No change | No change
[NAME] to find value first cell containing data: |  |  |  |  | INDEX(B4:D4,MATCH(FALSE,B4:D4="data",0))
[NAME] to find value in last cell containing data: |  |  |  |  | INDEX(B4:D4,,COUNTIFS(B4:D4,"<>",B4:D4,"<>*data*"))
[NAME] to track change: |  |  |  |  | LET(First,[NAME]:D4,MATCH(FALSE,B4:D4="data",0)),Last,[NAME]:D4,,COUNTIFS(B4:D4,"<>",B4:D4,"<>*data*")),IFS(First>Last,"Gone down",First=Last,"No change",First<Last,"Gone up"))
Spreadsheet: 121712d1316314290-formula-or-vba-example
Sheet: raw data

date | id | idhex | number | query | numbcount | start | finish | duration | hold | wrap | wait | agent | type | empid | empname
2011-09-05 00:00:00 | 222 | 23452345 | [PHONE] | Connection | 3 | 2011-09-05 14:45:32 | 2011-09-05 15:07:01 | 1288 | 228 | 185 | 1 |  | high | 1234 | [NAME]
2011-09-08 00:00:00 | 223452 | 24522345 | [PHONE] | disconnection | 2 | 2011-09-08 15:16:44 | 2011-09-08 15:30:18 | 813 | 0 | 515 | 1 |  | high | 2345 | [NAME] bloggs
2011-09-08 00:00:00 | 2345234 | 234523 | [PHONE] | Complaints | 3 | 2011-09-08 16:07:23 | 2011-09-08 16:08:27 | 63 | 0 | 401 | 1 |  | high | 3456 | [NAME] doe
2011-09-09 00:00:00 | 23452345 | 23452345 | [PHONE] | other | 34 | 2011-09-09 11:18:00 | 2011-09-09 11:22:04 | 242 | 0 | 238 | 2 |  | high | 4567 | Billy jane
2011-09-09 00:00:00 | 234523452 | 23452345 | [PHONE] | Nothing said | 2 | 2011-09-09 09:29:32 | 2011-09-09 09:30:30 | 56 | 0 | 7 | 2 |  | high | 5678 | [NAME]
2011-09-09 00:00:00 | 234523452 | 2345234 | [PHONE] | general | 48 | 2011-09-09 16:13:31 | 2011-09-09 16:15:36 | 123 | 0 | 4 | 2 |  | high | 6789 | [NAME]
2011-09-09 00:00:00 | 2345234523 | 2345245 | [PHONE] | estate | 4 | 2011-09-09 10:28:48 | 2011-09-09 10:41:32 | 763 | 0 | 505 | 1 |  | high | 7890 | [NAME]
Spreadsheet: lynn_blair__24476__Oneok Est-Act OBA Variance-2001
Sheet: Procedures

PROCEDURES FOR UPDATING
KN/ONEOK Estimate -vs- Actual Report
 | Step | 1 |  | On Monday print the Confirmation Summary report from TMS for each point.  Use the
 |  |  |  | most recent date that has volumes in all three columes (Sched Qty, Actual and Estimated).
 |  |  |  | (This will be two days in the rear since actuals come in two days later.)
 | Step | 2 |  | Access the Excel spreadsheet.
 |  |  |  | (u:\common\south central\oba_tracking_south_central\oneok est-act oba variance.xls)
 | Step | 3 |  | Select the appropriate worksheet.  Using the Confirmation Summary reports update
 |  |  |  | each point with the month-to-date Scheduled, Estimated and Actual volumes.
 |  |  |  | (The report has formulas and will automatically update the other columns.)
 | Step | 4 |  | Once completed save the report and then print it.
 | Step | 5 |  | Make five copies.  One for Steve January, [NAME], [NAME], [NAME],
 |  |  |  | [NAME] and the original in the file folder.
Spreadsheet: 689848d1596704751-how-to-get-multiple-values-for-the-same-cell-value-vlookup-example
Sheet: Sheet1

Data I have |  |  | I wish to have
1 | red |  | 1 | red
1 | blue |  | 1 | blue
2 | green |  | 2 | green
2 | yellow |  | 2 | yellow
2 | violet |  | 2 | violet
3 | pink
3 | orange
Spreadsheet: 271524d1381961186-linking-multiple-columns-to-populate-on-a-separate-worksheet-book1
Sheet: Sheet1

 |  |  |  |  | Date: ____________________
Customer: | NUPLEX RESINS
Location:
Test | Method | Min | [NAME] | Typical | Results |  |  | Out of Spec/  Re-test
Appearance
Acid Value |  | 0 | 0.3 mg/KOH | 0.14
Gardner Color |  | 0 | 6 | 5
Iodine Value |  |  |  | 177-200
Special Requirements/Additional Tests:
QC Analyst/Technician: ______________________________
Spreadsheet: 860733d1708718151-issue-with-vstack-formula-kansas-scheduler-v4-
Sheet: Not in Production (Kitting)

[NAME] from date below↓ |  | DO NOT EDIT IN THIS REPORT
2024-02-21 00:00:00
Not in Production (Kitting)
Client | Job # | # of Stores | # of Pieces | Ship Date | Notes
 | HHGJ 188 | 69 | 89 | 2024-03-01 00:00:00 | [NAME]
E03055560- MENS Vans Q1 0226 | 0 | 18 | 5 | 2024-03-01 00:00:00 | 0
BASS 245365 [1] | 245365 | 34 | 34 | 2024-03-01 00:00:00 | 0
SAVERS FSC | 0 | 330 | 1975 | 2024-03-04 00:00:00 | 0
DXL | 244647 | 240 | 242 | 2024-03-04 00:00:00 | PLACEMARKER
DXL | 244653 | 2 | 2 | 2024-03-04 00:00:00 | 0
HHGJ | 166 | 69 | 145 | 2024-03-04 00:00:00 | PLACEMARKER- + 4pcs of Sintra- Nike Swim- E03074917
North American | 0 | 0 | 549 | 2024-03-06 00:00:00 | PLACEMARKER
NAC 244862 [11] | 244862 | 559 | 574 | 2024-03-11 00:00:00 | 0
Savers Endcap FSC Prints | 0 | 315 | 1769 | 2024-03-12 00:00:00 | [NAME]
Blast Media March All Gender Run Campaign | 0 | 92 | 185 | 2024-03-12 00:00:00 | [NAME]
HHG TMOB Prepaid Refresh | 0 | 4048 | 12875 | 2024-03-14 00:00:00 | PLACEMARKER
[NAME] | 0 | 145 | 995 | 2024-03-15 00:00:00 | PLACEMARKER
GGPM | 0 | ? | 0 | 2024-03-15 00:00:00 | PLACEMARKER
TMOB- APPLE NPI- SPRING | 0 | ? | 0 | 2024-03-15 00:00:00 | PLACEMARKER
[NAME] paper store | 0 | ? | 1100 | 2024-03-25 00:00:00 | PLACEMARKER
CKCC | 0 | ? | 0 | 2024-03-26 00:00:00 | PLACEMARKER
Hallmark- [NAME] | 0 | ? | 0 | 2024-03-27 00:00:00 | PLACEMARKER
GGPM | 0 | ? | 0 | 2024-05-03 00:00:00 | PLACEMARKER
GGPM | 0 | ? | 0 | 2024-09-04 00:00:00 | PLACEMARKER
TMOB- APPLE NPI- FALL | 0 | ? | 0 | 2024-09-14 00:00:00 | PLACEMARKER
Spreadsheet: dutch_quigley__9367__gbs0711pos
Sheet: Position

 |  |  |  | Ony Change the months in the light Green
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  | 2001-12-01 00:00:00 |  |  |  | 2001-10-01 00:00:00 |  |  | 2001-11-01 00:00:00 | 2002-03-01 00:00:00 |  |  | Jan |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  | Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
Spreadsheet: 865381d1712414320-scheduling-rules-help-excelforum-help-file
Sheet: MAY

Month: | Year:
APR | 2024 | CALLS | Off Request | Employees
Day | Date
Wednesday | 2024-05-01 00:00:00 |  | DD | AA
Thursday | 2024-05-02 00:00:00 |  | DD | BB
Friday | 2024-05-03 00:00:00 |  | DD | CC
Saturday | 2024-05-04 00:00:00 |  | DD | DD
Sunday | 2024-05-05 00:00:00 |  | DD | EE
Monday | 2024-05-06 00:00:00 |  | DD | FF
Tuesday | 2024-05-07 00:00:00 |  | DD | GG
Wednesday | 2024-05-08 00:00:00 |  | DD | HH
Thursday | 2024-05-09 00:00:00 |  | DD | II
Friday | 2024-05-10 00:00:00 |  | DD | JJ
Saturday | 2024-05-11 00:00:00 |  | DD
Sunday | 2024-05-12 00:00:00
Monday | 2024-05-13 00:00:00 |  | HH,FF
Tuesday | 2024-05-14 00:00:00 |  | HH,FF
Wednesday | 2024-05-15 00:00:00 |  | HH,FF
Thursday | 2024-05-16 00:00:00 |  | HH,FF
Friday | 2024-05-17 00:00:00 |  | HH,FF
Saturday | 2024-05-18 00:00:00 |  | HH,FF
Sunday | 2024-05-19 00:00:00 |  | JJ
Monday | 2024-05-20 00:00:00 |  | JJ
Tuesday | 2024-05-21 00:00:00
Wednesday | 2024-05-22 00:00:00
Thursday | 2024-05-23 00:00:00
Friday | 2024-05-24 00:00:00
Saturday | 2024-05-25 00:00:00 |  | BB,JJ,II
Sunday | 2024-05-26 00:00:00 |  | BB,JJ,II
Monday | 2024-05-27 00:00:00 |  | BB,JJ,II
Tuesday | 2024-05-28 00:00:00 |  | BB,JJ,II
Wednesday | 2024-05-29 00:00:00 |  | BB,JJ,II
Thursday | 2024-05-30 00:00:00 |  | BB,JJ,II
Friday | 2024-05-31 00:00:00 |  | BB,JJ,II
Spreadsheet: 795006d1662461716-right-forumla-in-vlookup-error-urmarire-porci-2022
Sheet: MARTIE

 | 8 morti | 1 viu
NR. CRT | DATA | NR. CAPETE | GREUTATE VIU | [NAME] | LOT | GREUTATE CARCASA CALAFAT | GREUTATE CARCASA DTS | GREUTATE CARCASA CU CAP | GREUTATE ORGANE
1 | 2022-03-02 00:00:00 | 4 | 405 |  |  |  |  |  | 11.8
2 | 2022-03-04 00:00:00 | 6 | 603 |  |  |  |  |  | 18
3 | 2022-03-08 00:00:00 | 7 | 711 |  |  |  | 274 |  | 22.3
4 | 2022-03-10 00:00:00 | 5 | 515 |  |  |  |  |  | 16
5 | 2022-03-11 00:00:00 | 7 | 725 |  |  |  |  |  | 21
6 | 2022-03-14 00:00:00 | 5 | 521 |  |  | 82.32 | 329.27 |  | 15.4
7 | 2022-03-16 00:00:00 | 6 | 631 |  |  |  |  |  | 19.1
8 | 2022-03-18 00:00:00 | 7 | 745 |  |  |  |  |  | 23.2
9 | 2022-03-19 00:00:00 | 6 | 647 |  |  |  |  |  | 19.8
10 | 2022-03-23 00:00:00 | 5 | 523 |  |  | 212 | 213 |  | 15.9
11 | 2022-03-25 00:00:00 | 8 | 864 |  |  | 387 | 387 |  | 29
12 | 2022-03-29 00:00:00 | 8 | 878 |  |  |  | 346.2 |  | 27
13 | 2022-03-31 00:00:00 | 7 | 768 |  |  |  |  |  | 24
Total
 |  |  |  |  |  |  |  | 10
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Little Sea

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2017-04-15 00:00:00 | £200 received 15/4/17 | see notes above
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2017-04-15 00:00:00
Spreadsheet: 772444d1647275954-recent-date-recent-location-date-location
Sheet: Sheet1

Input
Entiry | Date | Location
1 | 2022-01-01 00:00:00 | Location1
1 | 2022-01-02 00:00:00 | Location2
2 | 2022-02-05 00:00:00 | Location1
2 | 2022-02-05 00:00:00 | Location2
2 | 2022-02-06 00:00:00 | Location1
3 | 2022-02-02 00:00:00 | Location1
3 | 2022-02-03 00:00:00 | Location2
3 | 2022-02-04 00:00:00 | Location3
3 | 2022-02-05 00:00:00 | Location4
3 | 2022-02-06 00:00:00 | Location5
Desired Output
Entity | Last Date | Last Location
1 | 2022-01-02 00:00:00 | Location2
2 | 2022-02-06 00:00:00 | Location1
3 | 2022-02-06 00:00:00 | Location5
Spreadsheet: 789211d1658999084-removing-duplicates-and-counting-test-sheet
Sheet: Summary (Sales)

Summary
Order # | Sales person |  | Sales person | Order count
10001 | Adam |  | Adam | 2
10002 | [NAME] |  | [NAME] | 3
10003 | [NAME] |  | [NAME] | 3
10004 | [NAME] |  | [NAME] | 1
10005 | [NAME] |  | [NAME] | 1
10006 | Adam
10007 | [NAME]
10008 | [NAME]
10009 | [NAME]
10010 | [NAME]