tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 767301d1644400875-problem-with-formula-refernces-customer-complaint-log-2022-cleaned
Sheet: Chart Complaint type Actual2021

 |  |  | Periods
Complaint Type - Key | Quantity 2021 | Quantity 2020 | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | JUN |  | JUL |  | AUG |  | SEP |  | OCT |  | NOV |  | DEC
 |  |  | 2021 | 2020 | 2021 | 2020 | 2021 | 2020 | 2021 | 2020 | 2021 | 2020 | 2021 | 2020 | 2021 | 2020 | 2021 | 2020 | 2021 | 2020 | 2021 | 2020 | 2021 | 2020 | 2021 | 2020
Product not comparable
Cross contamination
Damaged/poor/late delivery
Foreign body
Incorrect labelling
Not justified
Order picking error
Order Processing error
Short Delivery
Product taint
Incorrect pallet type
Mould growth
Incorrect documentation
Incorrect packaging
Incorrect weight bag
Other
Microbiological profile
Extraneous Vegetable Matter
Poor quality print on labels
Infestation - Supplier
Unable to assign
Shelf Life
Pack seal failure
Supplier Issue
TBA under investigation
Quality
Total
Justified Total
Production batches |  | 7730 |  | 970 |  | 683 |  | 959 |  | 1062 |  | 773 |  | 844 |  | 780 |  | 776 |  | 883
complaints per 1000 batches
% increase / decrease
Average % increase / decrease
Spreadsheet: 540173d1506567995-if-formula-and-index-match-or-vlookup-excel-questions
Sheet: dashboard 

 |  |  | caelder due date
 | Name | response 20 days | Extension 10 days | 30 day adjustment |  | Please recommend best formula here to structure data from sheet 1 possibly a [NAME], vlookup or mabey a index match
 | formula here | formula here | formula here | formula here
 | formula here | formula here | formula here | formula here
 | formula here | formula here | formula here | formula here
 | formula here | formula here | formula here | formula here
 | formula here | formula here | formula here | formula here
 | formula here | formula here | formula here | formula here
 |  |  |  |  |  | Please recommend the best If formula needed to solve the below
 |  |  |  | I want 30 day adjustment to go blank when adjustment needed is No and to show the date when Yes, so far I have it working on Yes.
 |  |  |  |  |  | results sent | adjustment needed | 30 day adjustment
 |  |  |  |  |  |  | No
Spreadsheet: 806070d1669095219-retrieving-multiple-column-header-based-on-cell-value-book1
Sheet: Sheet1

 |  |  | Cross-Sectional Area ( mm2 )
 |  |  | Bar Diameter( [NAME] )
 |  | No. of Bars | 10 | 12 | 16 | 20 | 24 | 28 | 32 | 36 | 40
 |  | 1 | 78 | 113 | 201 | 314 | 452 | 615 | 804 | 1018 | 1256
 |  | 2 | 156 | 226 | 402 | 628 | 904 | 1230 | 1608 | 2036 | 2512
 |  | 3 | 234 | 339 | 603 | 942 | 1356 | 1845 | 2412 | 3054 | 3768
 |  | 4 | 312 | 452 | 804 | 1256 | 1808 | 2460 | 3216 | 4072 | 5024
 |  | 5 | 390 | 565 | 1005 | 1570 | 2260 | 3075 | 4020 | 5090 | 6280
 |  | 6 | 468 | 678 | 1206 | 1884 | 2712 | 3690 | 4824 | 6108 | 7536
 |  | 7 | 546 | 791 | 1407 | 2198 | 3164 | 4305 | 5628 | 7126 | 8792
 |  | 8 | 624 | 904 | 1608 | 2512 | 3616 | 4920 | 6432 | 8144 | 10048
 |  | 9 | 702 | 1017 | 1809 | 2826 | 4068 | 5535 | 7236 | 9162 | 11304
 |  | 10 | 780 | 1130 | 2010 | 3140 | 4520 | 6150 | 8040 | 10180 | 12560
 | As,req = | 1256 |  |  |  |  |  |  |  |  |  |  | Bar diameter | No of Bars | Area Steel
 | Asmin = | 195 |  | Use As |  | mm2/m |  |  |  |  |  | Provide |  |  |  | mm2/m
Spreadsheet: e1bd90a3-97bf-48c3-95d3-bf5cc2ab4ac7
Sheet: 24

Uke: | 24 |  |  |  |  | Navn:
 |  | Mandag |  | Tirsdag |  | Onsdag |  | Torsdag |  | Fredag |  | Lørdag |  | Søndag |  | Sum
Kvalitet | Form | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | Trent | Diff. | Feedback
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
AKKUMULERT
Kvalitet | Form | Plan |  | Trent
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
Spreadsheet: 824420d1680572896-comparing-two-lists-with-multiple-columns-s666-pq-ists-difference
Sheet: Sheet7

17 | 13 | Laplante | [NAME] | v
 | 13 | Angers-Trottier | Anne-Marie | v
17 | 13 | Belvedere | Calista | v
17 | 13 | Belvedere | [NAME] | v
17 | 13 | Hudon | Sandra | v
17 | 13 | [NAME] | Sylvie | v
17 | 13 | [NAME] | Alain | v
 | 13 | Charbonneau | [NAME] | v
17 | 13 | Lafleur | [NAME]
17 | 13 | Lafleur | [NAME]
 |  | Amal | Diabi
17 |  | Dupont | [NAME]
 |  | George | hebert
Spreadsheet: 329022d1404163030-dynamic-top-5-customer-per-month-dluhut-oeldere-328983d1404152066-dynamic-top-5-customer-per-month-dynamic-top-5-customer-ans
Sheet: Desired Result (new data)

Helper Columns |  |  |  | Desired Correct Helper Columns
 |  | OK |  | Customer A | 162 |  |  |  | [NAME] | Kolomlabels
 |  |  |  | Customer B | 25 |  |  |  | Rijlabels | 1 | 2 | 3 | 4 | 5 | Eindtotaal
 |  |  |  | Customer C | 9 |  |  |  | Customer A | 43408 | 39947 | 46707 | 17213 | 147275 | 147275
 |  |  |  | Customer D | 5 |  |  |  | Customer B | 1812 | 1822 | 2038 | 1055 | 6727 | 6727
 |  |  |  | Customer E | 3 |  |  |  | Customer C |  |  |  | 536 | 2144 | 2144
 |  | OK |  | Customer A | 201 |  |  |  | Customer E | 991 | 899 | 1425 | 470 | 3785 | 3785
 |  |  |  | Customer B | 16 |  |  |  | Customer O |  | 621 | 717 |  | 2079 | 2079
 |  |  |  | Customer C | 14 |  |  |  | Eindtotaal | 43408 | 39947 | 46707 | 17213 | 147275 | 147275
 |  |  |  | Customer D | 5
 |  |  |  | Customer I | 4
 |  | Duplicates of Customer S |  | Customer A | 144
 |  |  |  | Customer C | 10
 |  |  |  | Customer B | 8
 |  |  |  | Customer S | 7
 |  |  |  | Customer X | 7
 |  | Duplicates of Customer B |  | Customer A | 89
 |  |  |  | Customer C | 13
 |  |  |  | Customer B | 7
 |  |  |  | Customer E | 7
 |  |  |  | Customer I | 7
ABOVE HAS FORMULA
Spreadsheet: 012c1cd2-f97b-452c-ac14-d79434d1f676
Sheet: Sheet1

1913 - 8th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: Jardin des Tuileries, Paris, France |  |  |  |  | 1913-10-12 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | USA | Upson | [NAME] | Preston | R.A.L. | Goodyear | Bampton, Bridlington, [NAME], England | 618 | 1900-01-01 19:30:00
2 | USA | Honeywell | [NAME] | Wade | J.H. | [NAME] |  | 483 | 1900-01-01 05:35:00
3 | ITA | Pastine | Giovanni | Tullio | Benigni | Roma |  | 457 | 1900-01-01 08:25:00
4 | SUI | [NAME] | Capt. [NAME] | Seiffert | H. | Helvetia | Bolazec/France | 442 | 1900-01-01 06:00:00
5 | SUI | Beauclair | [NAME] | Biehly | Dr. H. | Zürich | Kergavacu/France | 438 | 1900-01-01 05:55:00
6 | FRA | Rumpelmayer | René | Goldschmidt | Gustave | Stella |  | 437
7 | BEL | Demuyter | Ernest | Vleminkx | A. | Belgica | St.Michel-en-Greve/ France | 435 | 1900-01-01 08:00:00
8 | AUT | Sigmundt | Dr. [NAME] |  |  | Astarte |  | 425
9 | FRA | Leblanc | Alfred | Dubonnet | Emile | Ile de France |  | 422
10 | BEL | Gerard | [NAME] | Nuffel | (van) | Patrie |  | 415
11 | GBR | Francia | [NAME] | Welby-Jourdan |  | Honeymoon |  | 377
12 | ITA | Agostini |  | Valle | [NAME] di | B.A. |  | 364
13 | FRA | Bienaime | [NAME] | Schneider | [NAME] | La Picardie |  | 363
14 | GBR | Dunville | [NAME] | Corbet | Capt. | Banshee |  | 362
15 | GER | Pohl | [NAME] | Perlewitz | Dr. [NAME] | [NAME] |  | 347 | 1900-01-01 05:10:00
16 | GER | [NAME] | Hugo | Schmitz | [NAME] | Duisburg |  | 318 | 1900-01-01 04:00:00
17 | AUT | [NAME] | F.W. | [NAME] | . | Frankfurt |  | 289
18 | GER | Berliner | Hans | [NAME] | [NAME] | Metzeler |  | 274 | 1900-01-01 01:10:00
19 | USA | Watts | [NAME] | [NAME] |  | Kansas City |  | no start
20 | AUT | Hans | Dr. |  |  | [NAME] |  | no start
21 | SUI | Palmarini |  |  |  | Azurea |  | no start
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: TEAM RESULT

No | TEAM COMPETITION |  |  |  | TOTAL | S/I 1 | S/1 2 | S/I 3 |  |  |  | No | PLAYER | PLAYER | PLAYER | PLAYER | TOTAL | S/I 1 | S/I 2 | S/1/3
1st |  |  |  |  |  |  |  |  |  |  |  | 1
2nd |  |  |  |  |  |  |  |  |  |  |  | 2
3rd |  |  |  |  |  |  |  |  |  |  |  | 3
4th |  |  |  |  |  |  |  |  |  |  |  | 4
5th |  |  |  |  |  |  |  |  |  |  |  | 5
6th |  |  |  |  |  |  |  |  |  |  |  | 6
7th |  |  |  |  |  |  |  |  |  |  |  | 7
8th |  |  |  |  |  |  |  |  |  |  |  | 8
9th |  |  |  |  |  |  |  |  |  |  |  | 9
10th |  |  |  |  |  |  |  |  |  |  |  | 10
11th |  |  |  |  |  |  |  |  |  |  |  | 11
Spreadsheet: 453844d1459474131-using-large-amount-of-formulas-based-on-conditions-sample-
Sheet: Sheet1

 | Contract | [NAME] to be used |  |  | Contract | Premiums | Claims | Commissions | Refund
 | A | =Premium + Claims*2 |  |  | A | 1000 | 200 | 20 |  | *
 | B | =Premium/2 + Claims |  |  | B | 500 | 50 | 0 |  | *
 | C | =(Premiums+Claims)/100
 | D | =(Premiums-Commissions)+Claims
 |  |  |  |  | * to fill up the refund conlumn I should be able to use the formulas in the yellow box according to the contract ID (A,B,C etc).  - Is there a way I can lookup the formula so whenever A appears it automatically uses the specific formula for A and so on. Note: The formulas are much more complex and there are over 200 contracts
Spreadsheet: 479295d1473305032-converting-rows-to-columns-sample-data
Sheet: Division Emp

ID | Name | Location |  |  | Location | ID | Name | ID | Name | ID | Name | ID | Name
109585 | [NAME] | 0001 |  |  | 0001 | 109585 | [NAME] | 110504 | [NAME] | 112264 | [NAME]
110504 | [NAME] | 0001 |  |  | 0006 | 113079 | [NAME] | 115254 | Aundrea McCadams | 115540 | [NAME]
112264 | [NAME] | 0001 |  |  | 0008 | 126861 | [NAME] | 132071 | [NAME]
113079 | [NAME] | 0006 |  |  | 0010 | 310832 | [NAME]
115254 | Aundrea McCadams | 0006 |  |  | 0011 | 367207 | [NAME]
115540 | [NAME] | 0006 |  |  | 0013 | 384484 | [NAME] | 383678 | [NAME] | 384484 | [NAME] | 114102 | [NAME]
126861 | [NAME] | 0008
132071 | [NAME] | 0008 |  |  | What I need it to look like.
310832 | [NAME] | 0010
367207 | [NAME] | 0011
383678 | [NAME] | 0013
384484 | [NAME] | 0013
114102 | [NAME] | 0013
Raw Data is Above
Spreadsheet: 780208d1652349386-get-a-list-of-people-who-are-less-than-150-or-taller-than-185-filter-outside-range-aligw
Sheet: Page1

[NAME] | 200 |  | Answer: |  |  | Or: |  | 149
Yulia | 149 |  |  | [NAME] |  |  | [NAME] | 187
Leo | 180 |  |  | Mark |  |  | Mark | 148
[NAME] | 187
Mark | 148
 |  |  |  | =
Spreadsheet: 536583d1504595545-excel-template-for-monthly-work-recording-pay-by-day-v3
Sheet: Calculations

 |  | Date from | Date to | Sick Days Count | Holidays Count |  |  |  |  | Staff | Role | Daily rate |  | Work day
 |  | 2017-08-01 00:00:00 | 2017-08-15 00:00:00 |  |  |  |  |  |  | [NAME] | Driver | 600 |  | Normal
Staff | Role | Days worked | Payment due |  |  |  |  |  |  | [NAME] | Driver | 600 |  | Sick
[NAME] | Driver |  |  |  |  |  |  |  |  | [NAME] | Helper | 250 |  | Holiday
[NAME] | Driver |  |  |  |  |  |  |  |  | [NAME] | Helper | 250
[NAME] | Helper |  |  |  |  |  |  |  |  | [NAME] | Driver | 600
[NAME] | Helper
[NAME] | Driver
Spreadsheet: 103051d1300896145-copy-but-cant-paste-xl-2003-copy-of-939-2011-03-latin-america-test
Sheet: PCSplit

Split by Profit Center
 | Current Exhg | 0.15598 | P&L Rate
 | TTD | USD | DM | WF
Account | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | 001 | 056
30010-001 | 4133689.52 | 644772.8913296 | 644772.8913296
30010-056 | 2054273.44 | 320425.5711712 |  | 320425.5711712
30020-001 | 693995 | 108249.3401 | 108249.3401
41010-001 | -3032385.55 | -478734.0515764914 | -478734.0515764914
41010-056 | -1439086.2 | -224468.665476 |  | -224468.665476
41020-001 | -1014152.02 | -158187.4320796 | -158187.4320796
61000-001 | -583594.75 | -91029.10910500001 | -91029.10910500001
61000-056 | -61438.37 | -9583.1569526 |  | -9583.1569526
71000-001 | -60139.86 | -9380.615362800001 | -9380.615362800001
71000-056 | -29887.04 | -4661.7804992 |  | -4661.7804992
76000-001 | -441639.95 | -68886.99940100001 | -68886.99940100001
76000-056 | -219476.87 | -34234.0021826 |  | -34234.0021826
81800-082 | 9788.79 | 18230.44907671107 | 18230.44907671107
84020-001 | -386214.77 | -60241.77982460001 | -60241.77982460001
84020-056 | -164341.87 | -25634.0448826 |  | -25634.0448826
91200-001 | -24072.06 | -3754.7599188 | -3754.7599188
81850-082 | 0 | 0 | 0
81290-082 | 666080.1 | 103895.173998 | 103895.173998
Total | 101397.5399999998 | 26777.02841421963 | 4933.10723601967 | 21843.92117820003
Trial Balance | 101397.5399999997
Check figure | 0
 |  | 13388.51420710982 | 2466.553618009835 | 10921.96058910001
 |  |  | PC1931010142 | PC1931010143
Co-Acct | Trading Partner | Profit Center | Cost Center | Amount
1102-460200 | 614100 | 1931010142 |  | -2466.553618009835
1102-460200 | 614100 | 1931010143 |  | -10921.96058910001
1102-170500 | 614100 | 1931010142 |  | 13388.51420710982 |  | Doc # 100002602
Spreadsheet: 147584d1332869261-excel-validation-rule-help-with-date-ranges-data-validation-in-date-ranges_edit
Sheet: Sheet1

NO. | Account | Sub-account | Start Date | End Date | Assignment | CONFLICT?
1 | PET | DOG | 2012-01-01 00:00:00 | 2012-01-31 00:00:00 | HOUSE1
2 | PET | DOG | 2012-01-15 00:00:00 | 2012-01-30 00:00:00 | HOUSE1
3 | PET | DOG | 2012-02-01 00:00:00 | 2012-02-29 00:00:00 | HOUSE3
4 | PET | CAT | 2012-02-01 00:00:00 | 2012-02-29 00:00:00 | HOUSE3
5 | PET | DOG | 2012-01-01 00:00:00 | 2012-01-31 00:00:00 | HOUSE2
6 | PET | CAT | 2012-02-15 00:00:00 | 2012-02-29 00:00:00 | HOUSE1
7 | PET | CAT | 2012-02-15 00:00:00 | 2012-03-15 00:00:00 | HOUSE2
Spreadsheet: 933d801c-07bc-4140-9ce3-0d6bc2ef8d7f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3376 | 13944 | Clare | Carney | GBR | 0 |  |  |  |  |  | 1 | 2:09:39
3376 | 10069 | [NAME] | Overbye | DEN | 0 |  |  |  |  |  | 2 | 2:10:23
3376 | 18689 | Melinda | Walsh | AUS | 0 |  |  |  |  |  | 3 | 2:12:20
3376 | 14219 | Kristie | Otto | CAN | 0 |  |  |  |  |  | 4
3376 | 5435 | Virginia | [NAME] | ESP | 0 |  |  |  |  |  | 5
3376 | 5387 | Erika | Molnar | HUN | 0 |  |  |  |  |  | 6
3376 | 14392 | Nicolett | Pecsi | HUN | 0 |  |  |  |  |  | 7
3376 | 5312 | Anja | Dittmer | GER | 0 |  |  |  |  |  | 8
3376 | 10510 | [NAME] | Evans | NZL | 0 |  |  |  |  |  | 9
3376 | 15263 | Helena | Edmonston | AUS | 0 |  |  |  |  |  | 10
Spreadsheet: 790119d1659540062-lookup-a-value-in-tab-and-insert-corresponding-data-into-new-tabs-resource-db-excelforum-separate-tab
Sheet: P & GM

 | Name | Surname | [NAME] |  |  |  | Project & General Management
1 |  | surname30 | email30
2 | [NAME] | surname39 | email39
3 | name56 | surname56 | email56
4 | name84 | surname84 | email84
5 | name90 | surname90 | email90
6 | name91 | surname91 | email91
7 | name118 | surname118 | email118
etc… | name129 | surname129 | email129
 | name132 | [NAME] | email132
 | name134 | surname134 | email134
 | name135 | surname135 | email135
 | name137 | surname137 | email137
 | name153 | surname153 | email153
 | name158 | surname158 | email158
 | name168 | surname168 | email168
 | name172 | surname172 | email172
 | [NAME] | surname186 | email186
 | name187 | [NAME] | email187
 | name191 | surname191 | email191
 | name193 | surname193 | email193
 | name195 | surname195 | email195
Spreadsheet: 61611d1262551205-water-tank-level-formula-last-5-days-water-tank-level-4-
Sheet: Numbers

Date Range Spanning 5 Days | Upper Water Level | Lower Water Level
2010-01-01 00:00:00 | 40 | 100
2010-01-06 00:00:00 | 30 | 90
Average Change Per Day | -2 | -2
Projected Days Remaining | 15 | 45
Consecutive Entry Dates | Five Most Recent Water Level Entries Below
2010-01-02 00:00:00 | 60 | 90
2010-01-03 00:00:00 | 55 | 100
2010-01-04 00:00:00 | 45 | 90
2010-01-05 00:00:00 | 35 | 95
2010-01-06 00:00:00 | 30 | 90
Average Change Per Day | -7.5 | 0
Projected Days Remaining | 4 | Stable
Date | Upper Water Level | Lower Water Level
2010-01-01 00:00:00 | 40 | 100
2010-01-02 00:00:00 | 60 | 90
2010-01-03 00:00:00 | 55 | 100
2010-01-04 00:00:00 | 45 | 90
2010-01-05 00:00:00 | 35 | 95
2010-01-06 00:00:00 | 30 | 90
2010-01-07 00:00:00
2010-01-08 00:00:00
Spreadsheet: 218278d1362419222-lists-data-validation-sample-data
Sheet: Data

Project ID | Component | Element | Project Name | Project Manager
Project1 | Component1 | Element1 | Red | [NAME]
Project1 | Component2 | Element3 | Red | [NAME]
Project1 | Component3 | Element1 | Red | [NAME]
Project1 | Component6 | Element3 | Red | [NAME]
Project1 | Component7 | Element1 | Red | [NAME]
Project2 | Component8 | Element9 | Yellow | [NAME]
Project2 | Component9 | Element2 | Yellow | [NAME]
Project2 | Component1 | Element1 | Yellow | [NAME]
Project2 | Component2 | Element2 | Yellow | [NAME]
Project2 | Component4 | Element1 | Yellow | [NAME]
Project2 | Component3 | Element1 | Yellow | [NAME]
Project2 | Component1 | Element3 | Yellow | [NAME]
Project2 | Component2 | Element5 | Yellow | [NAME]
Project3 | Component4 | Element4 | Orange | Toby
Project3 | Component9 | Element3 | Orange | Toby
Project3 | Component1 | Element1 | Orange | Toby
Project4 | Component4 | Element1 | Blue | [NAME]
Project4 | Component9 | Element2 | Blue | [NAME]
Project4 | Component2 | Element3 | Blue | [NAME]
Project4 | Component9 | Element3 | Blue | [NAME]
Project4 | Component1 | Element3 | Blue | [NAME]
Project5 | Component3 | Element1 | Green | [NAME]
Project5 | Component9 | Element6 | Green | [NAME]
Project5 | Component4 | Element7 | Green | [NAME]
Project5 | Component3 | Element2 | Green | [NAME]
Project5 | Component3 | Element3 | Green | [NAME]
Project5 | Component2 | Element5 | Green | [NAME]
Project5 | Component7 | Element1 | Green | [NAME]
Project5 | Component8 | Element6 | Green | [NAME]
Project5 | Component9 | Element2 | Green | [NAME]
Project5 | Component6 | Element1 | Green | [NAME]
Project5 | Component6 | Element2 | Green | [NAME]
Spreadsheet: 295269d1391637497-sorting-data-in-excel-excel-problem-v2
Sheet: Sheet1

 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
participant | when t2 | t2 correct |  | participant | t2_correct_lag_1 | t2_correct_lag_2 | t2_correct_lag_3 | [NAME] | t2_correct_lag_5 | t2_correct_lag_6 | t2_correct_lag_7 | t2_correct_lag_8
607 | 1 | 1 |  | 607
607 | 2 | 1 |  | 607-2
607 | 3 | 1 |  | 209
607 | 4 | 1 |  | 209-2
607 | 5 | 0
607 | 6 | 0
607 | 7 | 0
607 | 8 | 1
607-2 | 7 | 1
607-2 | 4 | 1
607-2 | 5 | 1
607-2 | 8 | 1
607-2 | 2 | 1
607-2 | 1 | 0
607-2 | 3 | 1
209 | 1 | 1
209 | 2 | 1
209 | 3 | 1
209 | 4 | 1
209 | 5 | 0
209 | 6 | 0
209 | 7 | 0
209 | 8 | 1
209-2 | 7 | 1
209-2 | 4 | 1
209-2 | 5 | 1
209-2 | 8 | 1
209-2 | 2 | 1
209-2 | 1 | 0
209-2 | 3 | 1
Spreadsheet: 539133d1505979769-keeping-only-the-top-value-of-a-group-of-ids-keeping-only-the-top-value-of-a-group-of-ids
Sheet: Sheet1

ID | [NAME] | Max of PROM |  |  |  | ID | [NAME] | Max of PROM |  |  |  |  | Row Labels | [NAME] of PROM | [NAME]
0002301 | CR | 12 |  |  |  | 0002301 | CR | 12 |  |  |  |  | 0002301 | 12
45646 | CR | 1 |  |  |  | 45646 | [NAME] | 9 |  |  |  |  | 123456 | 4
45646 | [NAME] | 9 |  |  |  | 54645564 | [NAME] | 10 |  |  |  |  | 444444 | 12
54645564 | [NAME] | 10 |  |  |  | 54888 | [NAME] | 10 |  |  |  |  | 456123 | 10
54888 | [NAME] | 10 |  |  |  | 123456 | CR | 4 |  |  |  |  | 45646 | 9
123456 | CR | 4 |  |  |  | 789456 | CR | 11 |  |  |  |  | 54645564 | 10
123456 | [NAME] | 2 |  |  |  | 456123 | CR | 10 |  |  |  |  | 54888 | 10
789456 | CR | 11 |  |  |  | 963963 | CR | 8 |  |  |  |  | 777777 | 8
789456 | [NAME] | 8 |  |  |  | 444444 | [NAME] | 12 |  |  |  |  | 789456 | 11
456123 | CR | 10 |  |  |  | 777777 | PA | 8 |  |  |  |  | 888888 | 29
456123 | PH | 1 |  |  |  | 888888 | CR | 29 |  |  |  |  | 963963 | 8
963963 | CR | 8
963963 | [NAME] | 2
444444 | [NAME] | 12
777777 | PA | 8
888888 | CR | 12
888888 | CR | 29
Spreadsheet: 679151d1590226219-deferred-revenue-various-billing-cycle-test-ml
Sheet: Sheet1

Customer | Invoice Date | Start Date | End Date | Amount | Monthly Value | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00
A | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-07-30 00:00:00 | 10000
B | 2019-02-01 00:00:00 | 2019-02-01 00:00:00 | 2020-05-30 00:00:00 | 15000
C | 2019-05-01 00:00:00 | 2019-05-01 00:00:00 | 2020-06-30 00:00:00 | 350000
D | 2019-05-01 00:00:00 | 2019-05-01 00:00:00 | 2020-12-31 00:00:00 | 50000
Spreadsheet: 711019d1609387850-find-first-and-last-columns-with-len-0-scheduling-help-find-first-and-last-column-of-len-greater-0
Sheet: Sheet1

 | Monday | Tuesday | Wednesday | Thursday | Friday
[NAME] | 2670-Fit | 2670-Fit | 2665-fit | 2665-Fit
Mark |  | 2670-Weld
Start with above data
Automatically translated into this all through equations so all cells are non-zero
2670 | Fit | Fit, Weld
2665 |  |  | Fit | Fit
Now I need for Quick Reference
 | start date | end date
2670
2665
Spreadsheet: 844648d1696400324-need-a-formulae-mentioned-in-enclosed-sheet-sample
Sheet: Sheet7

2023-09-22 00:00:00
DAY-1 | P | P | P | P | P | R | P | P | P | R | P | P | P | SD | P | P | R | P | R | P | P | P | P | R | P | P | P | P | P | P | R | P
DAY-2 | P | P | SD | P | P | R | P | P | P | SD | P | SD | P | SD | P | P | R | P | P | P | P | P | P | R | P | P | P | P | P | P | R | P
 |  |  | Number of Presents
 |  |  | September | October | 01 TO 07
 |  | Day-1 |  |  |  |  | NEED TO COUNT
 |  | Day-2 |  |  |  |  | IF | row one is equal to october
 |  |  |  |  |  |  | IF | B3:AG3 is >= 1 and <=7
 |  |  |  |  |  |  | IF | B4:AG4 is = P