tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 708233d1607684765-create-an-advanced-report-to-show-average-price-per-brand-sorted-by-country-cat-of-item-dashboard
Sheet: UK

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 130778d1322578957-creating-a-drop-down-menu-copy-of-book1-1
Sheet: Sheet1

Item | Calories | Fat | Carbohydrates | Fiber | Protein | Total
apple
 |  |  |  |  |  |  | Lookup Table | Calories | Fat | Carbohydrates | Fiber | Protein
 |  |  |  |  |  |  | Chocolate Milk | 113 | 215 | 236 | 81 | 183
 |  |  |  |  |  |  | Hamburger | 177 | 109 | 103 | 243 | 173
 |  |  |  |  |  |  | [NAME] | 243 | 242 | 137 | 131 | 192
 |  |  |  |  |  |  | apple | 205 | 112 | 186 | 156 | 74
Spreadsheet: 704777d1605742854-help-with-date-formatting-project-air-monthly-consumer-register
Sheet: January 2020

MRN | Name | Date of Birth | Date of initial GCC referral | Date of 1st Appointment | date of 2nd appointment | date of 3rd appointment | date of final appointment | D/C complete | Service length 2 | Service D/C to | Evaluation  / feedback form completed
 |  |  |  | These cells will go red if appointment date is 72 hours after Date of initial GCC referral or green if appointment is within 72 hours  (example below) |  |  |  |  | This will total (in days) the total length of service from initial date of referral (D+E+F+G+H inlducing D/C date)
 |  |  | 2020-10-11 00:00:00 | 2020-10-15 00:00:00 | 2020-10-22 00:00:00 | 2020-11-15 00:00:00 | 2020-11-19 00:00:00 | 2020-11-24 00:00:00
 |  |  | 2020-10-11 00:00:00 | 2020-10-13 00:00:00
Spreadsheet: 161437d1339519360-pulling-data-from-one-database-into-another-with-multiple-criteria-help-please-
Sheet: Sheet1

Name | Position | Date | Account | Hours |  | Salary | Benefits | What I need to bring over
[NAME] | [PHONE] | 01/11 | 12216 | 110 |  | 1500.54 | 350
[NAME] | [PHONE] | 02/11 | 12216 | 120 |  | 750 | 150
[NAME] | [PHONE] | 03/11 | 12213 | 160 |  | 1700 | 400
[NAME] | [PHONE] | 04/11 | 12213 | 160 |  | 985 | 354
[NAME] | [PHONE] | 05/11 | 12216 | 50 |  | 789 | 134
JDoe | [PHONE] | 01/11 | 12213 | 75 |  | 2500 | 150
JDoe | [PHONE] | 02/11 | 12213 | 176 |  | 750 | 180
JDoe | [PHONE] | 03/11 | 12213 | 160 |  | 745 | 352
JDoe | [PHONE] | 04/11 | 12216 | 168 |  | 1200 | 456
JDoe | [PHONE] | 05/11 | 12216 | 120 |  | 1352 | 402
Spreadsheet: 751929d1634459461-generate-serial-number-and-skip-duplicate-barcodes-10-17
Sheet: Sheet1

Barcode | serial number
13080 | 1
94927 | 2
07676 | 3
31961
37505 | 4
29777 | 5
29852 | 6
31961
44343 | 7
44404 | 8
31961
44206 | 9
44428 | 10
43827 | 11
31695 | 12
48310 | 13
Spreadsheet: a12862f6-9f24-432e-a483-05d584fa9777
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-02-05 09:17:31.690000
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.783 | 102.658 | 102.533 | 102.158
4.5 | 101.882 | 101.757 | 101.632 | 101.257 |  | Note: | Refer To Price [NAME]
4.375 | 101.024 | 100.899 | 100.774 | 100.399 |  |  | For all Price Adjs
4.25 | 100.472 | 100.347 | 100.222 | 99.597
4.125 | 99.672 | 99.547 | 99.422 | 98.797
4 | 98.687 | 98.562 | 98.437 | 97.812
3.875 | 97.656 | 97.531 | 97.406 | 96.781
3.75 | 96.781 | 96.656 | 96.531 | 95.906
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.815 | 102.69 | 102.565 | 102.19
3.75 | 102.373 | 102.248 | 102.123 | 101.748
3.625 | 101.973 | 101.848 | 101.723 | 101.348
3.5 | 101.4 | 101.275 | 101.15 | 100.525
3.375 | 100.646 | 100.521 | 100.396 | 99.771
3.25 | 99.844 | 99.719 | 99.594 | 98.969 |  | 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-02-19 09:17:31.690000
30 DAY | 2014-03-06 09:17:31.690000
45 DAY | 2014-03-21 09:17:31.690000
60 DAY | 2014-04-05 09:17:31.690000
90 DAY | 2014-05-05 09:17:31.690000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 140377d1328725301-sum-of-data-from-consecutive-nonconsecutive-dates-example1
Sheet: Sheet1

Date | Score |  | Date | Score |  |  | Non Consecutive |  |  | Consecutive
2011-12-27 00:00:00 | 106 | non-con | 2011-12-28 00:00:00 | 101 | con |  | Sum: | 1815 |  | Sum: | 396
2011-12-31 00:00:00 | 84 | con | 2011-12-30 00:00:00 | 105 | non
2012-01-02 00:00:00 | 100 | non-con | 2012-01-05 00:00:00 | 109 | non |  | sum: | 1509 |  | sum: | 702
2012-01-03 00:00:00 | 74 | con | 2012-01-07 00:00:00 | 109 | con
2012-01-06 00:00:00 | 102 | con | 2012-01-12 00:00:00 | 111 | con
2012-01-09 00:00:00 | 106 | non-con | 2012-01-14 00:00:00 | 93 | non |  |  | 1509 |  |  | 702
2012-01-11 00:00:00 | 84 | non-con | 2012-01-16 00:00:00 | 93 | non
2012-01-20 00:00:00 | 76 | non-con | 2012-01-18 00:00:00 | 92 | non
2012-01-25 00:00:00 | 97 | non-con | 2012-01-21 00:00:00 | 121 | con
2012-01-27 00:00:00 | 83 | non-con | 2012-02-02 00:00:00 | 77 | non
2012-01-29 00:00:00 | 107 | non-con | 2012-02-04 00:00:00 | 87 | non
2012-01-31 00:00:00 | 94 | non-con
Spreadsheet: 40957d1239364990-copy-cell-based-on-data-in-another-cell-scorekeeping
Sheet: Whomever

Whomever | Points | EK's | Deaths | TK | Assists | Shot/K | Purple H | Medic | Primary Weapon | 2nd Weapon | Extra Weapons | Drive | Fly | Boat | Parachuting | Extra Awards | Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Points | With TK's
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EK's
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TK's
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Deaths
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assists
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shots/Kill
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Purple H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medic
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drive
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fly
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parachuting
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 770750d1646239680-replace-multiple-specific-values-sample-search-and-replace-multiple-specific-values
Sheet: Sheet1

Title | Slug | Parent [NAME]
Sun | a-1111 | a-1111/b-1111
[NAME] | a-2222 | a-2222/b-2222
Stars | a-3333 | a-3333/b-3333
Details | b-1111
Details | b-2222
Details | b-3333
Spreadsheet: 16ff7b85-0041-45e5-a69d-4a1abd185b2e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Number of Subcontractors in district/fiscal agent | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
IRN:
District/Fiscal Agent:
Contact Name: |  |  |  |  |  | Contact Phone/E-mail |  | _______________________ |  | ________________
[NAME] | Subcontractor         Site Name                   (if different from subcontractor name) | Site Contact       First Name | Site Contact        Last Name | Site Contact E-mail Address | Site Contact Phone Number | Site Address | City | State | Zip | County
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
 |  |  |  |  | (    )
Spreadsheet: 703613d1605085503-count-values-in-a-column-based-on-data-with-blanks-in-another-column-excel-question
Sheet: ProductBatch

 |  |  |  |  | A-011
DOM | Product Batch No. | RawBatch No. | [NAME]
2020-12-15 00:00:00 |  | A-011 | 2021-01-01 00:00:00
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-012 | 2021-03-01 00:00:00
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
Spreadsheet: 739939d1626096695-needs-formula-to-count-a-filtered-list-help-me
Sheet: Q8 - 1

AGE GROUP |  |  |  |  | Q8 - 1 MICROSOFT WORD
2 |  |  |  |  | 7
5 |  |  |  |  | 4
3 |  |  |  |  | 4
2 |  |  |  |  | 7
2 |  |  |  |  | 6
3 |  |  |  |  | 7
3 |  |  |  |  | 5
4 |  |  |  |  | 5
2 |  |  |  |  | 7
2 |  |  |  |  | 5
4 |  |  |  |  | 5
3 |  |  |  |  | 6
2 |  |  |  |  | 6
1 |  |  |  |  | 7
3 |  |  |  |  | 5
4 |  |  |  |  | 3
2 |  |  |  |  | 7
2 |  |  |  |  | 7
2 |  |  |  |  | 6
2 |  |  |  |  | 6
2 |  |  |  |  | 5
4 |  |  |  |  | 4
4 |  |  |  |  | 4
2 |  |  |  |  | 6
4 |  |  |  |  | 4
3 |  |  |  |  | 7
3 |  |  |  |  | 4
4 |  |  |  |  | 4
2 |  |  |  |  | 4
2 |  |  |  |  | 6
2 |  |  |  |  | 6
3 |  |  |  |  | 6
2 |  |  |  |  | 6
2 |  |  |  |  | 6
5 |  |  |  |  | 4
2 |  |  |  |  | 4
3 |  |  |  |  | 6
2 |  |  |  |  | 4
2 |  |  |  |  | 6
2 |  |  |  |  | 4
2 |  |  |  |  | 7
5 |  |  |  |  | 4
2 |  |  |  |  | 6
1 |  |  |  |  | 7
3 |  |  |  |  | 7
2 |  |  |  |  | 4
3 |  |  |  |  | 4
3 |  |  |  |  | 5
4 |  |  |  |  | 6
4 |  |  |  |  | 5
2 |  |  |  |  | 6
3 |  |  |  |  | 6
2 |  |  |  |  | 6
2 |  |  |  |  | 5
2 |  |  |  |  | 6
3 |  |  |  |  | 3
3 |  |  |  |  | 7
3 |  |  |  |  | 6
2 |  |  |  |  | 6
2 |  |  |  |  | 6
5 |  |  |  |  | 5
4 |  |  |  |  | 5
2 |  |  |  |  | 5
2 |  |  |  |  | 7
2 |  |  |  |  | 6
4 |  |  |  |  | 5
2 |  |  |  |  | 6
2 |  |  |  |  | 6
2 |  |  |  |  | 6
2 |  |  |  |  | 6
2 |  |  |  |  | 7
4 |  |  |  |  | 5
3 |  |  |  |  | 4
2 |  |  |  |  | 4
2 |  |  |  |  | 6
5 |  |  |  |  | 6
4 |  |  |  |  | 3
4 |  |  |  |  | 3
4 |  |  |  |  | 6
4 |  |  |  |  | 7
2 |  |  |  |  | 7
4 |  |  |  |  | 5
3 |  |  |  |  | 7
3 |  |  |  |  | 4
2 |  |  |  |  | 6
 |  |  |  |  | Total group |  |  |  | filter group 1 - 18 to 24 |  |  | filter group 2 - 25 to 34 |  |  | filter group 3 - 35 to 44 |  |  | filter group 4 - 45 to 54 |  |  | filter group 5 - 55 to 64 |  |  | excluding Group 2 and 1 |  |  | Only Group 2 and 1
 |  |  |  |  | 1= |  |  |  | 1= | 0 |  | 1= | 0 |  | 1= | 0 |  | 1= | 0 |  | 1= | 0 |  | 1= | 0 |  | 1= | 0
 |  |  |  |  | 2= |  |  |  | 2= | 0 |  | 2= | 0 |  | 2= | 0 |  | 2= | 0 |  | 2= | 0 |  | 2= | 0 |  | 2= | 0
 |  |  |  |  | 3= |  |  |  | 3= | 0 |  | 3= | 0 |  | 3= | 1 |  | 3= | 2 |  | 3= | 0 |  | 3= | 3 |  | 3= | 0
 |  |  |  |  | 4= |  |  |  | 4= | 0 |  | 4= | 5 |  | 4= | 5 |  | 4= | 4 |  | 4= | 3 |  | 4= | 12 |  | 4= | 5
 |  |  |  |  | 5= |  |  |  | 5= | 0 |  | 5= | 4 |  | 5= | 3 |  | 5= | 7 |  | 5= | 1 |  | 5= | 11 |  | 5= | 4
 |  |  |  |  | 6= |  |  |  | 6= | 0 |  | 6= | 23 |  | 6= | 6 |  | 6= | 7 |  | 6= | 1 |  | 6= | 8 |  | 6= | 23
 |  |  |  |  | 7= |  |  |  | 7= | 2 |  | 7= | 8 |  | 7= | 5 |  | 7= | 1 |  | 7= | 0 |  | 7= | 6 |  | 7= | 10
Spreadsheet: 683475d1592754354-if-find-spec-gross-weight-calculation-gross-weight-v1
Sheet: PI

Shipping details |  |  |  | Packaging and other details
 |  |  |  |  |  |  | IBC | 56.5
 |  |  |  |  |  |  | Drums | 15
 |  |  |  |  |  |  | HDPE Drums | 10
 |  | Est Gross Weight:
 |  | Total Pallets:
 |  | CAS N°:
Item | Item description | IBC | Qty Net / Weight KG | Unit price | Amount
 |  | 40 | 20000
[NAME] down formula:
Gross Weight= Net Weight + Packaging Weight
Gross Weight= | (Number of package x Weight of package) | + Pallets weight | Comments
Solution 1:
Solution 2: |  |  | if in case of IBC Packaging Cell "C15" is multiplied by 56.5. or cell i2.
Solution 3: |  |  | if in case IBC Packaging Cell "C15" is not multiplied by 56.5 or cell i2.
Spreadsheet: 856548d1705759318-match-and-extract-lambda-map-filter-extract
Sheet: L3

 |  |  |  |  | Match |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<< Extract >> | <<< Extract >> |  |  | <<< Extract >>
 |  |  |  |  | B-1/2/3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ABC,US | Apple |  |  | 133.05
 |  |  |  |  | Lon-2/5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apps,ND | Jasmine |  |  | 36.12
 |  |  |  |  | Lon-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apps,ND | Lily |  |  | 44
 |  |  |  |  | S-4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME],Matrix | Rose |  |  | 101.36
Spreadsheet: 799706d1665223470-averageif-of-last-5-entries-leadtimetest
Sheet: Feuil1

 |  | (Ctrl + ;) (Ctrl + Shift + ;) |  |  | Lead-time ouvrable |  |  |  |  |  |  |  |  | Business hours |  |  | Holidays
Projet |  | Demande reçue | Rendez-vous | # of options | [NAME] | Ouvrable |  |  | All requests |  |  |  |  | Start | 8:00:00 |  | 2022-10-10 00:00:00
522-231 Bezos |  | 2022-09-20 13:00:00 | 2022-09-20 13:30:00 | 1 |  |  |  |  | Last 10 |  |  |  |  | End | 16:00:00 |  | 2022-12-25 00:00:00
122-210 Musk |  | 2022-09-21 13:00:00 | 2022-09-21 13:33:30 | 10 |  |  |  |  | Current week |  |  |  |  |  |  |  | 2022-12-26 00:00:00
522-234  Jobs |  | 2022-09-22 12:59:59.995000 | 2022-09-22 13:37:00 | 10 |  |  |  |  | Time/options (weekly) |  |  |  |  | Month |  |  | 2023-01-01 00:00:00
122-210 Edison |  | 2022-09-23 12:59:59.995000 | 2022-09-23 13:40:30 | 4 |  |  |  |  | Current month |  |  |  |  | 2022-10-01 00:00:00 | 2022-10-31 00:00:00 |  | 2023-01-02 00:00:00
5 |  | 2022-09-24 12:59:59.995000 | 2022-09-24 13:44:00 | 10 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-10 00:00:00
5 |  | 2022-09-25 12:59:59.995000 | 2022-09-25 13:47:30 | 10 |  |  |  |  | Elon |  |  |  |  | Week |  |  | 2023-05-22 00:00:00
5 |  | 2022-09-26 12:59:59.995000 | 2022-09-26 13:51:00 | 10 |  |  |  |  | Last 5 |  |  |  |  | 2022-10-03 00:00:00 | 2022-10-08 00:00:00 |  | 2023-06-24 00:00:00
5 |  | 2022-09-27 12:59:59.995000 | 2022-09-27 13:54:30 | 10 |  |  |  |  | Current week |  |  |  |  |  |  |  | 2023-07-01 00:00:00
5 |  | 2022-09-28 12:59:59.995000 | 2022-09-28 13:58:00 | 10 |  |  |  |  | Time/options (weekly) |  |  |  |  | Reference | Colleague |  | 2023-09-04 00:00:00
5 |  | 2022-09-29 12:59:59.995000 | 2022-09-29 14:01:30 | 24 |  |  |  |  | Current month |  |  |  |  | 1 | Elon |  | 2023-10-09 00:00:00
5 |  | 2022-09-30 12:59:59.995000 | 2022-09-30 14:05:00 | 10 |  |  |  |  |  |  |  |  |  | 5 | [NAME] |  | 2023-12-25 00:00:00
1 |  | 2022-10-01 12:59:59.995000 | 2022-10-01 14:08:30 | 10 |  |  |  |  | [NAME] |  |  |  |  |  |  |  | 2023-12-26 00:00:00
1 |  | 2022-10-02 12:59:59.995000 | 2022-10-02 14:12:00 | 10 |  |  |  |  | Last 5
1 |  | 2022-10-03 12:59:59.995000 | 2022-10-03 14:15:30 | 1 |  |  |  |  | Current week
1 |  | 2022-10-04 12:59:59.995000 | 2022-10-04 14:19:00 | 1 |  |  |  |  | Time/options (weekly)
1 |  | 2022-10-05 12:59:59.995000 | 2022-10-05 14:22:30 | 1 |  |  |  |  | Current month
1 | [NAME] | 2022-10-06 12:59:59.995000 | 2022-10-06 14:26:00 | 1
1 |  | 2022-10-07 12:59:59.995000 | 2022-10-07 14:29:30 | 1
1 | [NAME] | 2022-10-08 12:59:59.995000 | 2022-10-08 14:33:00 | 1
Spreadsheet: 717083d1612468620-separation-of-unsold-products-from-all-duplicate-products-kkk
Sheet: Sheet1

Row | Product
1 | A |  | Result
2 | D |  | Unsalled |  | Salled |  | Please, without VBA & Helper column
3 | A |  | D |  | A
4 | E |  | E |  | H
5 | H |  | F |  | R
6 | D |  | k
7 | F |  | M
8 | R
9 | K
10 | A
11 | M
12 | F
Spreadsheet: 776856d1649947414-display-start-time-and-end-time-overlapping-overlapping-times-jbl0703-
Sheet: Feuil1

Start reference time | End reference time |  |  |  |  | Start reference time | End reference time
09:00:00 | 11:00:00 |  |  |  |  | 21:00:00 | 02:00:00 |  |  |  |  | SOLUTION FROM JetMc
Schedule |  |  |  |  |  | Schedule |  |  |  |  |  | What I need
Start time | End time |  | Start overlap time | End overlap time |  | Start time | End time |  | Start overlap time | End overlap time
07:00:00 | 08:00:00 |  |  |  |  | 19:00:00 | 20:00:00 |  |  |  |  | no overlap | no overlap |  | no overlap | no overlap
07:00:00 | 09:00:00 |  |  |  |  | 19:00:00 | 21:00:00 |  |  |  |  | no overlap | no overlap |  | no overlap | no overlap
07:00:00 | 10:00:00 |  |  |  |  | 19:00:00 | 22:00:00 |  |  |  |  | 09:00:00 | 10:00:00 |  | 21:00:00 | 22:00:00
07:00:00 | 11:00:00 |  |  |  |  | 19:00:00 | 00:00:00 |  |  |  |  | 09:00:00 | 11:00:00 |  | 21:00:00 | 00:00:00
07:00:00 | 13:00:00 |  |  |  |  | 19:00:00 | 01:00:00 |  |  |  |  | 09:00:00 | 11:00:00 |  | 21:00:00 | 01:00:00
09:00:00 | 13:00:00 |  |  |  |  | 19:00:00 | 02:00:00 |  |  |  |  | 09:00:00 | 11:00:00 |  | 21:00:00 | 02:00:00
10:00:00 | 13:00:00 |  |  |  |  | 19:00:00 | 04:00:00 |  |  |  |  | 10:00:00 | 11:00:00 |  | 21:00:00 | 02:00:00
11:00:00 | 13:00:00 |  |  |  |  | 21:00:00 | 04:00:00 |  |  |  |  | no overlap | no overlap |  | 21:00:00 | 02:00:00
12:00:00 | 13:00:00 |  |  |  |  | 22:00:00 | 04:00:00 |  |  |  |  | no overlap | no overlap |  | 22:00:00 | 02:00:00
 |  |  |  |  |  | 01:00:00 | 04:00:00 |  |  |  |  |  |  |  | 01:00:00 | 02:00:00
 |  |  |  |  |  | 02:00:00 | 04:00:00 |  |  |  |  |  |  |  | no overlap | no overlap
 |  |  |  |  |  | 03:00:00 | 04:00:00 |  |  |  |  |  |  |  | no overlap | no overlap
 |  |  | SOLUTION FROM JBL0703
 |  |  | hStart | hEnd |  |  |  |  |  |  |  | hStart | hEnd
 |  | Reference | 21:00:00 | 2:00:00 |  | Overlapping |  |  |  |  | Reference | 9:00:00 | 11:00:00 |  | Overlapping
 |  |  |  |  |  | hStart | hEnd |  |  |  |  |  |  |  | hStart | hEnd
 |  | Test schedule | 19:00:00 | 20:00:00 |  |  |  |  |  |  | Test schedule | 7:00:00 | 8:00:00
 |  |  | 19:00:00 | 21:00:00 |  |  |  |  |  |  |  | 7:00:00 | 9:00:00
 |  |  | 19:00:00 | 22:00:00 |  |  |  |  |  |  |  | 7:00:00 | 10:00:00
 |  |  | 19:00:00 | 0:00:00 |  |  |  |  |  |  |  | 7:00:00 | 11:00:00
 |  |  | 19:00:00 | 1:00:00 |  |  |  |  |  |  |  | 7:00:00 | 13:00:00
 |  |  | 19:00:00 | 2:00:00 |  |  |  |  |  |  |  | 9:00:00 | 13:00:00
 |  |  | 19:00:00 | 4:00:00 |  |  |  |  |  |  |  | 10:00:00 | 13:00:00
 |  |  | 21:00:00 | 4:00:00 |  |  |  |  |  |  |  | 11:00:00 | 13:00:00
 |  |  | 22:00:00 | 4:00:00 |  |  |  |  |  |  |  | 12:00:00 | 13:00:00
 |  |  | 1:00:00 | 4:00:00
 |  |  | 2:00:00 | 4:00:00
 |  |  | 3:00:00 | 4:00:00
Spreadsheet: 740443d1626343385-increasing-the-reference-row-in-a-series-of-random-formulas-by-one-demo
Sheet: 2021-22 Q3

Performance Indicator | Current Year Q3 | Last Year Q3 | [NAME] Past 5 Years
Measure 1
Measure 2
Measure 3
Measure 4
Measure 5
Measure 6
Measure 7
Measure 8
Measure 9
Measure 10
Measure 11
Measure 12
Measure 13
Measure 14 | n/a | n/a | n/a
Measure 15
Measure 16
Measure 17
Measure 18
Measure 19 | n/a | n/a | n/a
Measure 20
Measure 21
Measure 22
Measure 23
Measure 24
Measure 25
Measure 26
Measure 27
Measure 28
Measure 29
Measure 30
Measure 31
Measure 32
Measure 33
Measure 34
Measure 35
Measure 36
Measure 37
Measure 38
Measure 39
Measure 40
Measure 41
Measure 42
Measure 43
Measure 44
Measure 45
Measure 46
Measure 47
Measure 48
Measure 49
Measure 50
Measure 51
Measure 52
Measure 53
Measure 54
Measure 55
Measure 56
Measure 57
Measure 58
Measure 59
Measure 60 | 0.8328 | n/a | n/a
Spreadsheet: darrell_schoolcraft__7326__imball0202
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 31118 | 31456
2 | 26432 | 31456
3 | 27387 | 31394
4 | 31954 | 31456
5 | 31066 | 34456
6 | 37507 | 36936
7 | 37808 | 38956
8 | 38181 | 39034
9 | 38435 | 39956
10 | 36511 | 39956
11 | 36351 | 34319
12 | 35353 | 39956
13 | 38142 | 39956
14 | 34878 | 37956
15 | 40870 | 37956
16 | 40485 | 39956
17 | 40144 | 39956
18 | 41271 | 40108
19 | 41202 | 40108
20 | 37059 | 40108
21 | 37880 | 40108
22 | 37247 | 40108
23 | 37136 | 37702
24 | 37826 | 40100
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 100916
2002-02-24 00:00:00
CBS Volume
 |  |  | 62232