tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 471361d1468969718-excel-calculation-problem-of-the-pi-value-nnsw-roadbase-blends-2014-15-16-1-
Sheet: Boa BH 

[NAME]
 | % Passing Sieve |  |  |  |  |  |  | % Passing | Passing Specification |  | Deviation | % Retained | [NAME] |  | Deviation
Sieve mm | 20mm Roadbase | Man Sand | Kingsbrae Criethons Pit | Kingsbrae Straight Blend | [NAME] | [NAME] | ROSA | Blend Result | Lower | Upper | Passing | Blend Result | Lower | Upper | Retained
26.5 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
19 | 99 | 100 | 96 | 100 | 99 | 100 | 100 | 99.3 | 95 | 100 | 0 | 0.7000000000000028
13.2 | 85 | 100 | 96 | 98 | 89 | 100 | 100 | 89.5 | 78 | 92 | 0 | 9.799999999999997 | 6 | 18 | 0
9.5 | 67 | 100 | 96 | 94 | 75 | 100 | 100 | 76.9 | 50 | 100 | 0 | 12.59999999999999 | 7 | 17 | 0
6.7 | 52 | 100 | 94 | 91 | 59 | 100 | 100 | 66.4 | 50 | 70 |  |  | 10 | 21
4.75 | 40 | 97 | 93 | 90 | 45 | 99 | 100 | 57.1 | 44 | 64 | 0 | 19.8 | 13 | 25 | 0
2.36 | 26 | 62 | 90 | 86 | 26 | 74 | 100 | 36.8 | 30 | 100 | 0 | 20.3 | 7 | 19 | 1.300000000000004
0.425 | 0 | 18 | 46 | 30 | 8 | 25 | 100 | 5.4 | 14 | 23 | -8.6 | 31.4 | 14 | 30 | 1.399999999999999 |  | 14.67391304347826
0.6 | 17 | 20 | 11 | 10 | 3 | 10 | 100 | 17.9 | 15 | 50 | 0 | -12.5 | 6 | 13 | -18.5 |  | 331.4814814814815 | 3.314814814814814
0.0135 | 0 | 0 | 0 | 0 | 1 | 2 | 40 | 0 | 3 | 7 | -3 | 17.9 | 3 | 8 | 9.899999999999999 |  | 0
PI | 10 | 0 | 9 | 9 |  |  |  | 0 | 2 | 12 | -2
Ratio | 70 | 30 | 0 | 0 | 0 | 0 | 0 | 100
 |  | .
Spreadsheet: 771761d1646835477-calculate-value-if-certain-conditions-met-stylist-bonuses-2019-working-v2-help-file-2
Sheet: HR

Payroll Bonus Sheet
For HR to enter into Payroll
✔ | Name | Salon | Product Bonus | Employee Bonus | ✔ | Name | Salon | Product Bonus | Employee Bonus
 | [NAME] | GM | -
Spreadsheet: 861888d1709725968-countif-but-take-into-account-duplicates-football-table-updated
Sheet: Sheet1

Total | 10 |  |  | Won | 6 |  |  | Lost | 4
Date | Time | League | Home | Away | Prediction | When | % | 1.5 odds | 2.5 odds | Opin | Result
2024-03-03 00:00:00 | 13:00:00 | GERMANY10  Germany - Oberliga Hamburg | Alsterbruder | HEBC | 2.5 | Last 8 | 0.88 | X | 1.28 |  | Lost
2024-03-05 00:00:00 | 15:00:00 | QATAR  Qatar - Stars League   stats | [NAME] | [NAME] | 2.5 | All Season | 0.73 | x | 1.33 | no | Lost
2024-03-05 00:00:00 | 17:00:00 | QATAR  Qatar - Stars League   stats | [NAME] | [NAME] | 2.5 | All Season | 0.79 | x | 1.33 | no | Lost
2024-03-05 00:00:00 | 18:30:00 | GERMANY20  Germany - Oberliga Rheinland-P/S   stats | [NAME] | Karbach | 1.5 | All Season | 0.96 | 1.08 | x | N | Lost
2024-03-05 00:00:00 | 18:30:00 | GERMANY20  Germany - Oberliga Rheinland-P/S   stats | [NAME] | Karbach | 1.5 | Last 8 | 1 | 1.08 | x | N | Lost
2024-03-03 00:00:00 | 14:00:00 | GERMANY21  Germany - Oberliga Bayern Nord | Ammerthal | Donaustauf | 2.5 | Last 8 | 0.88 | x | 1.3 |  | Won
2024-03-03 00:00:00 | 17:00:00 | ITALY  Italy - Serie A | Atalanta | [NAME] | 1.5 | Last 8 | 1 | 1.33 | X |  | Won
2024-03-04 00:00:00 | 23:30:00 | [NAME]  Chile - Primera B | [NAME] | [NAME] | 1.5 | Last 8 | 1 | x | x | x | Won
2024-03-05 00:00:00 | 15:45:00 | SAUDIARABIA2  Saudi Arabia - Division 1   stats | [NAME] | [NAME] | 2.5 | All Season | 0.78 | x | 1.8 | x | Won
2024-03-05 00:00:00 | 19:45:00 | ENGLAND5  England - National League   stats | [NAME] | Dorking | 2.5 | Last 8 | 0.75 | x | 1.5 | yes | Won
2024-03-05 00:00:00 | 18:30:00 | GERMANY20  Germany - Oberliga Rheinland-P/S   stats | [NAME] | Karbach | 2.5 | All Season | 0.82 | x | 1.36 |  | Won
2024-03-05 00:00:00 | 18:30:00 | GERMANY20  Germany - Oberliga Rheinland-P/S   stats | [NAME] | Karbach | 2.5 | Last 8 | 0.88 | x | 1.36 |  | Won
 |  |  |  |  |  |  |  |  |  | I only want one of these rows counted where there are duplicates as they are the same match, just slightly different information on rest of row due to it being different sources. But L:L will always be the same.
 |  |  |  |  |  |  |  |  |  | I don’t want the row removed, only that only one of the rows are counted in the calculations on cells F1 and J1.
Spreadsheet: 680018d1590747784-complex-nested-if-issue-sample
Sheet: Sheet1

 |  |  | this is wrong | this is right
 | Values | Delta % | Formula 1 | Formula 2 | Expected Output
 | 85/100 |  |  |  | Below -10%
 | -85/100 |  |  |  | Below -10%
 | 85/-100 |  |  |  | Above 10%
 | -85/-100 |  |  |  | Above 10%
 | 98/100 |  |  |  | -3% to 3%
 | -98/100 |  |  |  | Below -10%
 | 98/-100 |  |  |  | Above 10%
 | -98/-100 |  |  |  | -3% to 3%
 | 102/100 |  |  |  | -3% to 3%
 | -102/100 |  |  |  | Below -10%
 | 102/-100 |  |  |  | Above 10%
 | -102/-100 |  |  |  | -3% to 3%
 | 94/100 |  |  |  | -3% to -10%
 | -94/100 |  |  |  | Below -10%
 | 94/-100 |  |  |  | Above 10%
 | -94/-100 |  |  |  | 3% to 10%
Spreadsheet: 859901d1708112488-solved-extracting-text-left-and-right-of-a-word-extract-numbers
Sheet: Sheet1

 |  |  |  |  | Temperatures |  |  |  | Year of Occurrence
 |  |  |  |  | Warmest High | Coldest High | Warmest Low | Coldest Low | Warmest High | Coldest High | Warmest Low | Coldest Low
2024-06-20 00:00:00 | 102 in 1933 | 59 in 1946 | 72 in 1988 | 42 in 1992
2024-06-21 00:00:00 | 102 in 1988 | 61 in 1906 | 74 in 1943 | 40 in 1992
2024-06-22 00:00:00 | 97 in 1995 | 59 in 1992 | 75 in 1983 | 44 in 1902
2024-06-23 00:00:00 | 98 in 2005 | 61 in 1969 | 75 in 2005 | 42 in 1972
2024-06-24 00:00:00 | 97 in 1874 | 59 in 1957 | 78 in 1937 | 44 in 1887
2024-06-25 00:00:00 | 97 in 1983 | 63 in 1968 | 77 in 1954 | 45 in 1974
2024-06-26 00:00:00 | 100 in 1931 | 55 in 1968 | 77 in 1943 | 42 in 1926
2024-06-27 00:00:00 | 99 in 1933 | 62 in 1968 | 79 in 1991 | 44 in 1992
2024-12-22 00:00:00 | 59 in 1877 | -7 in 1989 | 50 in 1877 | -23 in 1983
2024-12-23 00:00:00 | 59 in 1877 | -18 in 1983 | 49 in 1877 | -28 in 1872
2024-12-24 00:00:00 | 61 in 1889 | -10 in 1983 | 41 in 2023 | -37 in 1872
2024-12-25 00:00:00 | 55 in 1936 | -11 in 1884 | 50 in 2023 | -26 in 2000
2024-12-26 00:00:00 | 54 in 1936 | 0 in 1925 | 49 in 1936 | -24 in 1914
2024-12-27 00:00:00 | 51 in 1936 | 5 in 1993 | 40 in 2003 | -23 in 1880
Spreadsheet: 883809d1732537479-data-compilation-from-2-sheets-stock
Sheet: Parts

Model | Part code | Min qty
Model 1 | 2147302CK | 8
Model 1 | 2147141BK | 2
Model 1 | 2147305AK | 2
Model 1 | 814706KKIN | 1
Model 1 | 8147059K0IN | 1
Model 1 | 8147K6GKIN | 1
Model 1 | 8147K7JKIN | 1
Model 1 | 2147301BK | 1
Model 1 | 2147320CK | 1
Model 1 | 2147319BK | 1
Model 1 | 2447309A10 | 2
Model 2 | 114K5KK | 1
Model 2 | FEEDLXLLELLUBBELIN | 2
Model 2 | AICKUALXLLELLUBBEL | 2
Model 2 | 234K05AKIN | 18
Model 2 | 8145K2K0IN | 1
Model 2 | 214K72K0IN | 6
Model 3 | 4A22K39 | 2
Model 3 | 3K6T040 | 4
Model 3 | 31421017 | 1
Model 3 | 3K8K01 | 2
Model 3 | FF60D10A0Z0 | 4
Model 3 | LYF0B3121Z0IN | 2
Model 3 | 31430661IN | 2
Model 3 | 31431241IN | 2
Model 3 | 3143T090IN | 2
Model 3 | DBE0A108AZ0 | 4
Model 3 | MLX0A1671Z0 | 2
Model 3 | MLX0A1591Z0 | 4
Model 3 | FLJ0A1021Z0IN | 1
Model 3 | 31420934IN | 1
Model 3 | LYF0A1661Z0IN | 2
Model 3 | 31430417IN | 2
Model 3 | 31430841IN | 2
Model 3 | 31430792IN | 2
Model 3 | 31431326IN | 2
Model 3 | 31430656IN | 2
Model 3 | 5A12S025012 | 4
Model 4 | 11330172 | 6
Model 4 | KNJ0J1241Z0 | 4
Model 4 | FEED LXLLEL USF51 | 2
Model 4 | KV40J1141Z0IN | 1
Model 4 | 4A120120 | 1
Model 4 | 3390TK2 | 2
Model 4 | KV40J1151Z0IN | 1
Model 5 | DBE0A3490Z0 | 4
Model 5 | KNJ0J1241Z0 | 4
Model 5 | KNJ0J1221Z0 | 4
Model 5 | KV40J3161Z0IN | 2
Model 5 | KNJ0J1231Z0IN | 2
Model 5 | FEED LXLLEL USF51 | 2
Model 5 | KV40J1181Z0 | 1
Model 5 | KV40J1141Z0IN | 1
Model 5 | 4A120120 | 1
Model 5 | 3K8T023 | 2
Model 5 | 3390TK2 | 2
Model 5 | KV40J1151Z0IN | 1
Model 6 | JB50B10C0Z0 | 1
Model 6 | JB50B10D0Z0 | 1
Model 6 | H6M0606KY0 | 3
Model 6 | 3K4K14 | 2
Model 6 | H810F2291Z0 | 12
Model 6 | 3K4K01 | 2
Model 6 | [NAME] | 3
Model 6 | 1133K49 | 4
Model 6 | FDF0B2020Z0 | 16
Model 6 | DJD1S3K2Z0IN | 2
Model 6 | 3K8K38 | 2
Model 6 | DJD1E12A0Z0 | 18
Model 6 | 1133K50 | 4
Model 6 | 3K5K73 | 2
Model 6 | FDF0N2080Z0 | 2
Model 6 | 31420761IN | 1
Model 6 | 31431022IN | 2
Model 6 | JB50D1191Z0 | 4
Model 6 | 31430484IN | 6
Model 6 | 31431201IN | 2
Model 6 | 32440384 | 4
Model 6 | 31420934IN | 1
Model 6 | [NAME] | 1
Model 6 | 3143T206IN | 2
Model 6 | 31430751IN | 2
Model 6 | 3K8K58IN | 2
Model 6 | 31430973IN | 2
Model 6 | JB50B2082Z0IN | 12
Model 6 | 3K8K14IN | 2
Model 6 | 3K5K07IN | 2
Model 6 | 3K8K16IN | 2
Model 7 | QH10A21A0Z0 | 4
Model 7 | N140BKF0Z0 | 4
Model 7 | 11330184 | 5
Model 7 | MLX0A32B0Z0 | 1
Model 7 | JA20B81F0Z0 | 1
Model 7 | 31421117 | 3
Model 7 | QH10C31A1Z0 | 2
Model 7 | N140BK04Z0 | 2
Model 7 | QH10A22M1Z0 | 1
Model 7 | 31420943 | 1
Model 7 | QH10C1151Z0 | 2
Model 7 | 11330176 | 10
Model 7 | 31430530IN | 2
Model 7 | N140BK03Z0 | 3
Model 7 | 1133T028 | 3
Model 7 | 11330187 | 1
Model 7 | 31431530IN | 2
Model 7 | 31430528IN | 2
Model 7 | 31K1299 | 1
Model 7 | 3K8K91 | 2
Model 7 | 31421574 | 1
Model 7 | 5A14S03K25A | 2
Model 7 | H810F2307Z0IN | 2
Model 7 | 3143T221IN | 2
Model 7 | 31431K2IN | 2
Model 7 | 31431K2IN | 6
Model 7 | 31430714IN | 2
Model 7 | 31430714IN | 2
Model 7 | 31431063IN | 2
Model 7 | 31421195IN | 1
Model 7 | 31421139IN | 1
Model 7 | J610J5211Z0IN | 2
Model 7 | 4A120120 | 1
Spreadsheet: 884570d1733803974-stuck-with-formula-to-look-up-to-row-based-on-conditions-bulk-barcodes-copy
Sheet: Barcode data

Barcode | [NAME]
Spreadsheet: 718298d1613074626-automated-employee-department-rotation-rotation-example-1-
Sheet: Sheet1

 | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-03 00:00:00 | 2021-02-04 00:00:00 | 2021-02-05 00:00:00 | 2021-02-06 00:00:00 | 2021-02-07 00:00:00 | 2021-02-08 00:00:00 | 2021-02-09 00:00:00 | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | 2021-02-12 00:00:00 | 2021-02-13 00:00:00 | 2021-02-14 00:00:00 | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2021-02-20 00:00:00 | 2021-02-21 00:00:00 | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 | 2021-02-24 00:00:00 | 2021-02-25 00:00:00 | 2021-02-26 00:00:00 | 2021-02-27 00:00:00 | 2021-02-28 00:00:00
[NAME] | station 1 | station 1 | station 1 | station 2 | station 2 | Off | Off | station 2 | station 3 | station 3 | station 3 | station 4 | Off | Off | station 4 | station 4 | station 1 | station 1 | station 1 | Off | Off | station 2 | station 2 | station 2 | station 3 | station 3 | Off | Off
[NAME] | station 2 | station 2 | station 2 | station 3 | station 3 | Off | Off | station 3 | station 4 | station 4 | station 4 | station 1 | Off | Off | station 1 | station 1 | station 2 | station 2 | station 2 | Off | Off | station 3 | station 3 | station 3 | station 4 | station 4 | Off | Off
[NAME] | station 3 | station 3 | station 3 | station 4 | station 4 | Off | Off | station 4 | station 1 | station 1 | station 1 | station 2 | Off | Off | station 2 | station 2 | station 3 | station 3 | station 3 | Off | Off | station 4 | station 4 | station 4 | station 1 | station 1 | Off | Off
[NAME] | station 4 | station 4 | station 4 | station 1 | station 1 | Off | Off | station 1 | station 2 | station 2 | station 2 | station 3 | Off | Off | station 3 | station 3 | station 4 | station 4 | station 4 | Off | Off | station 1 | station 1 | station 1 | station 2 | station 2 | Off | Off
Spreadsheet: cara_semperger__1438__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (13)

 |  |  | To Portland General Electric : [NAME], [NAME], and [NAME]
 |  |  | Phone 464-7067
 |  |  | From Enron: Cara, [NAME], and [NAME] |  |  |  |  |  | DAILY COLSTRIP = 0
 |  |  | Phone 464-3814, 3902, 3831 |  |  |  |  |  | MONTH LONG COLSTRIP = 47 ATC
 |  |  |  |  |  |  |  |  | DAILY MIDC = 2 LLH
 |  |  |  |  |  |  |  |  | MIDC PARKING DEAL=50 [NAME]
 |  |  |  |  | Mid Columbia Paths
2001-11-13 00:00:00
 | HLH
 | DAY | 50 | PSEI(G) MIDC-CKFG | X | SCL | ENRON | PGE | X | PARKING
 | DAY | 10 | PSPL(G)MIDC | X | PINWEST | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 12 | GCPD(T)MIDC | X | BP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH | 25 | AVISTA(G)CHELAN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | LLH
 | DAY | 2 | AVISTA (G) AT CHPD | X | AVISTA | ENRON | PGE | X | PGE (L) MIDC
 | DAY | 2 | BPA C#10440-CLATSKANPE-BPA(T)BPAP/PGE #10649NF | X | CLATSKANPE | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 20 | AVISTA (G) AT CHPD | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | MONTH | 25 | WWP(G)MIDC | X | WWP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH COLSTRIP PATHS
 | ALL HOURS
 | MONTH | 6 |  | X | PGE | ENRON | ASHGROVE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 6 |  | X | PGE | ENRON | EXPRESS PIPE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 7 |  | X | PGE | ENRON | HOLNAM | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 8 |  | X | PGE | ENRON | LOUISIANA P | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 5 |  | X | PGE | ENRON | LUZENAC | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 15 |  | X | PGE | ENRON | SMURFIT | X | MPCO NETWORK TRANSMISSION TO LOAD
Spreadsheet: 34787d1232130590-values-formula-copy-of-new-order-entry-in-progress-2-
Sheet: Shop Order

 |  |  |  |  |  |  |  |  |  |  | Quotation No.: | 0
 |  |  |  |  |  |  |  |  |  |  | Shop No.: | 0
 |  | Date Required: | 1900-01-01 00:00:00
 |  | Date Received: | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | Customer Inquiry: |  |  | #N/A
Customer: |  | 0
 | Attn.: | #N/A |  |  | PH: | #N/A |  |  |  |  | Shipment: | Our Truck
 | Ship to: | 0 |  |  |  |  |  |  |  |  | F.O.B. Point: | Delivered
 |  | 0 |  |  |  |  |  |  |  |  | Terms: | Net 30 Days
 | Lot#: | 0
 |  | Beam |  |  |  |  |  |  | Beam Used From Inventory |  |  | [NAME]
 | Qty. | Size |  |  | Length |  | Primer
 | 2 | [NAME] |  |  | 7'-11" |  | YES |  |  |  |  | 290.4065040650406
 | 2 | [NAME] |  |  | 7'-11" |  | YES |  |  |  |  | 290.4065040650406
 | 2 | [NAME] |  |  | 7'-11" |  | YES |  |  |  |  | 290.4065040650406
 | 2 | [NAME] |  |  | 7'-11" |  | YES |  |  |  |  | 290.4065040650406
 | 0 | 0 |  |  | 0 |  | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  | 0 |  | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  | 0 |  | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  | 0 |  | 0 |  |  |  |  | #N/A
 | 8
Item |  | [NAME]
No. | Qty. | Length |  |  | Size | Sch
 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | 0
 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | 0
 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | 0
Item
No. | Qty. | Additional Work
 | 16 | 1/4" X 4" X 4" |  |  |  |  |  |  |  |  |  | 0
 | 32 | 1/8" X 4" X 4" |  |  |  |  |  |  |  |  |  | 0
 | 0 | Splice Plate
 | 0 | Measure |  | 0
 | Directions |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0 | 2009-01-16 00:00:00
 | 0 |  |  |  |  |  |  |  |  |  | Authorized By: | Date:
 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | Issued By: | Date:
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | Completed By: | Date:
Spreadsheet: 539360d1506077658-execel-get-minimum-date-for-year-excelforum
Sheet: Before

date
2013-03-14 00:00:00
2013-03-14 00:00:00
2013-03-14 00:00:00
2013-03-14 00:00:00
2013-03-14 00:00:00
2013-03-14 00:00:00
2013-03-15 00:00:00
2013-03-18 00:00:00
2013-03-19 00:00:00
2013-03-19 00:00:00
2014-02-18 00:00:00
2014-02-18 00:00:00
2014-02-19 00:00:00
2014-02-19 00:00:00
2014-02-19 00:00:00
2014-02-26 00:00:00
2014-03-04 00:00:00
2014-03-04 00:00:00
2014-03-04 00:00:00
2014-03-10 00:00:00
2015-02-20 00:00:00
2015-02-20 00:00:00
2015-02-20 00:00:00
2015-02-20 00:00:00
2015-02-20 00:00:00
2015-02-26 00:00:00
2015-02-26 00:00:00
2015-02-26 00:00:00
2015-02-26 00:00:00
2015-02-26 00:00:00
2015-02-26 00:00:00
2015-02-26 00:00:00
2015-02-26 00:00:00
2015-03-02 00:00:00
2015-03-02 00:00:00
2015-03-02 00:00:00
2015-03-02 00:00:00
2015-03-02 00:00:00
2016-02-01 00:00:00
2016-02-01 00:00:00
2016-02-24 00:00:00
2016-02-24 00:00:00
2016-02-24 00:00:00
2016-02-24 00:00:00
2016-03-01 00:00:00
2016-03-03 00:00:00
2016-03-22 00:00:00
2016-03-22 00:00:00
2016-03-22 00:00:00
2017-02-22 00:00:00
2017-02-22 00:00:00
2017-02-22 00:00:00
2017-02-22 00:00:00
2017-02-27 00:00:00
2017-02-27 00:00:00
Spreadsheet: 824808d1680856997-conditional-formatting-conditional_formatting
Sheet: Sheet1

[NAME] | Emp ID | Emp Name | Department
Group 1 | ABC32006 | A | Marketing
Group 1 | [NAME] | B
Group 1 | ABC32088 | C
Group 2 | ABC32020 | D | Finance
Group 2 | ABC32007 | E
Group 3 | ABC32026 | F | Research and Development
Group 3 | ABC32087 | G
Group 3 | ABC32048 | H
Group 4 | ABC32047 | I | HR
Group 4 | ABC32091 | J
Group 5 | ABC32024 | K | Operational Management
Group 5 | [NAME] | L
Group 5 | ABC32077 | M
Group 6 | ABC32033 | N | Information Technology
Group 6 | ABC32006 | O
Group 6 | ABC32059 | P
Spreadsheet: 453253d1459242562-want-to-match-time-in-out-by-employee-id-to-cell-from-punch-card-data-test-in-out-01-1-test-fill-more-data
Sheet: Personal

4900651 | AAA
4900652
4900653
4900654
4900655
4900656
4900657
4900658
4900659
4900660
4900661
4900662
4900663
4900664
4900665
4900666
4900667
4900668
4900669
4900670
4900671
4900672
4900673
4900674
4900675
4900676
4900677
4900678
4900679
4900680
4900681
4900682
4900683
4900684
4900685
4900686
4900687
4900688
4900689
4900690
4900691
4900692
4900693
4900694
4900765
4900822
4900831
4900842
5000913
5101102
5101103
5101104
5101166
5101218
5101219
5101246
5101312
5101313
5101340
5101428
5201506
5201513
5201514
5201518
5201548
5201772
5302807
5302828
5302966
5303017
5303057
5303255
5303370
5303660
5303929
5404086
5404314
5405257
5505792
5506454
5506571
5608196
5608226
5608375
5608448
5709387
5709388
5709539
5709581
5709802
5709803
5709804
5709852
5709853
5709888
5810076
5810077
5810078
5810079
5810080
5810227
5810500
Spreadsheet: 82636d1282677300-range-formula-besides-min-and-max-rangeif
Sheet: Sheet1

# | Data | Samples | [NAME] |  | Sample Range
1 | 0.0445 | 1 | 0.04523333333333333 | 1 | 0.0012
2 | 0.0455 | 1 | 0.04459999999999999 | 2 |  | In F6 I want the same formula as D6, but instead of Averageif, I need a rangeif
3 | 0.0457 | 1 | 0.04416666666666667 | 3 |  | basically E2 is the number I am looking for in column C, if they match
4 | 0.0435 | 2 | 0.04550000000000001 | 4 |  | then I need the range of the data in column B
5 | 0.0453 | 2 | 0.04496666666666668 | 5
6 | 0.045 | 2 | 0.04566666666666667 | 6
7 | 0.0438 | 3 | 0.04566666666666667 | 7
8 | 0.0459 | 3 | 0.04509999999999999 | 8
9 | 0.0428 | 3 | 0.04433333333333334 | 9
10 | 0.0449 | 4 | 0.04446666666666666 | 10
11 | 0.0449 | 4 | 0.04523333333333333 | 11
12 | 0.0467 | 4 | 0.04459999999999999 | 12
13 | 0.0433 | 5 | 0.04416666666666667 | 13
14 | 0.0461 | 5 | 0.04550000000000001 | 14
15 | 0.0455 | 5 | 0.04496666666666668 | 15
16 | 0.0454 | 6 | 0.04566666666666667 | 16
17 | 0.0461 | 6 | 0.04566666666666667 | 17
18 | 0.0455 | 6 | 0.04509999999999999 | 18
19 | 0.0454 | 7 | 0.04433333333333334 | 19
20 | 0.0461 | 7 | 0.04446666666666666 | 20
21 | 0.0455 | 7 | 0.04523333333333333 | 21
22 | 0.0458 | 8 | 0.04459999999999999 | 22
23 | 0.0445 | 8 | 0.04416666666666667 | 23
24 | 0.045 | 8 | 0.04550000000000001 | 24
25 | 0.0451 | 9 | 0.04496666666666668 | 25
26 | 0.0436 | 9 | 0.04566666666666667 | 26
27 | 0.0443 | 9 | 0.04566666666666667 | 27
28 | 0.045 | 10 | 0.04509999999999999 | 28
29 | 0.0441 | 10 | 0.04433333333333334 | 29
30 | 0.0443 | 10 | 0.04446666666666666 | 30
31 | 0.0445 | 11
32 | 0.0455 | 11
33 | 0.0457 | 11
34 | 0.0435 | 12
35 | 0.0453 | 12
36 | 0.045 | 12
37 | 0.0438 | 13
38 | 0.0459 | 13
39 | 0.0428 | 13
40 | 0.0449 | 14
41 | 0.0449 | 14
42 | 0.0467 | 14
43 | 0.0433 | 15
44 | 0.0461 | 15
45 | 0.0455 | 15
46 | 0.0454 | 16
47 | 0.0461 | 16
48 | 0.0455 | 16
49 | 0.0454 | 17
50 | 0.0461 | 17
51 | 0.0455 | 17
52 | 0.0458 | 18
53 | 0.0445 | 18
54 | 0.045 | 18
55 | 0.0451 | 19
56 | 0.0436 | 19
57 | 0.0443 | 19
58 | 0.045 | 20
59 | 0.0441 | 20
60 | 0.0443 | 20
61 | 0.0445 | 21
62 | 0.0455 | 21
63 | 0.0457 | 21
64 | 0.0435 | 22
65 | 0.0453 | 22
66 | 0.045 | 22
67 | 0.0438 | 23
68 | 0.0459 | 23
69 | 0.0428 | 23
70 | 0.0449 | 24
71 | 0.0449 | 24
72 | 0.0467 | 24
73 | 0.0433 | 25
74 | 0.0461 | 25
75 | 0.0455 | 25
76 | 0.0454 | 26
77 | 0.0461 | 26
78 | 0.0455 | 26
79 | 0.0454 | 27
80 | 0.0461 | 27
81 | 0.0455 | 27
82 | 0.0458 | 28
83 | 0.0445 | 28
84 | 0.045 | 28
85 | 0.0451 | 29
86 | 0.0436 | 29
87 | 0.0443 | 29
88 | 0.045 | 30
89 | 0.0441 | 30
90 | 0.0443 | 30
Spreadsheet: 799373d1665059290-date-condition-with-weekdays-next-workday-aligw
Sheet: Sheet1

Store | Week day | Date | [NAME]
METRO Constanta | Mon to Fri | 2022-10-01 00:00:00
METRO CONSTANTA2 | Mon to Fri | 2022-10-01 00:00:00
METRO Ploiesti | Mon to Fri | 2022-10-01 00:00:00
METRO Craiova | Mon to Fri | 2022-10-01 00:00:00
METRO BRASOV 2 | Mon to Fri | 2022-10-02 00:00:00
METRO Iasi | Tue to Sat | 2022-10-02 00:00:00
METRO Brasov | Mon to Fri | 2022-10-01 00:00:00
METRO Galati | Mon to Fri | 2022-10-01 00:00:00
METRO PITESTI | Mon to Fri | 2022-10-01 00:00:00
METRO Sibiu | Tue to Sat | 2022-10-03 00:00:00
METRO Oradea | Tue to Sat | 2022-10-03 00:00:00
METRO Punct Satu Mare | Tue to Sat | 2022-10-03 00:00:00
METRO Baia Mare | Tue to Sat | 2022-10-03 00:00:00
METRO Timisoara | Tue to Sat | 2022-10-03 00:00:00
METRO TIMISOARA 2 | Tue to Sat | 2022-10-03 00:00:00
METRO Cluj | Tue to Sat | 2022-10-02 00:00:00
METRO Punct Turda | Tue to Sat | 2022-10-02 00:00:00
Spreadsheet: 108108d1305207282-excel-2003-aut-increase-number-in-random-cell-in-one-column-example
Sheet: Sheet1

ACT | NUM | DATE
GB-E1TUH3 |  | 10.05.2011
GB-E1UMSZ |  | 10.05.2011
GB-E1UN0P |  | 10.05.2011
GB-E1UN0V |  | 10.05.2011
GB-E1UN4D | 7 | 10.05.2011
GB-E1UN7L |  | 10.05.2011
GB-E1UN7R |  | 10.05.2011
GB-E1VQOH |  | 10.05.2011
GB-E1VQON | 1 | 10.05.2011
GB-E1VQX1, GB-E1VQU3 |  | 10.05.2011
GB-E1VQX7 |  | 10.05.2011
GB-E1VR0F | 8 | 10.05.2011
[NAME] |  | 10.05.2011
GB-E1VR2Z |  | 10.05.2011
GB-E1VR5D |  | 10.05.2011
GB-E1VR5J |  | 10.05.2011
GB-E1VR8H | 2 | 10.05.2011
GB-E1VR8N |  | 10.05.2011
[NAME] |  | 10.05.2011
GB-E1VRB7 |  | 10.05.2011
GB-E1VRBD |  | 10.05.2011
GB-E1VRD7 |  | 10.05.2011
GB-E1VRDD |  | 10.05.2011
GB-E1WYMR |  | 10.05.2011
GB-E1WYO1 |  | 10.05.2011
GB-E1WYO7 |  | 10.05.2011
GB-E1WYPH |  | 10.05.2011
GB-E1WYPN | 5 | 10.05.2011
GB-E1WYR6 | 6 | 10.05.2011
GB-E1WYRC | 4 | 10.05.2011
GB-E1WYT6 |  | 10.05.2011
GB-E1WYY2 |  | 10.05.2011
GB-E1WYY8 |  | 10.05.2011
GB-E1WZ0M |  | 10.05.2011
GB-E1WZ0S |  | 10.05.2011
GB-E1WZ2W |  | 10.05.2011
GB-E1WZ5K |  | 10.05.2011
GB-E1WZ5Q |  | 10.05.2011
GB-E1WZ70 |  | 10.05.2011
GB-E1WZ76 | 3 | 10.05.2011
GB-E1WZ86 |  | 10.05.2011
GB-E1WZ9G |  | 10.05.2011
Spreadsheet: 725310d1616612722-formula-on-worksheet-that-changes-column-if-copied-on-new-worksheet-cocktail-box-stock-sheet
Sheet: Cocktail Box Sales

 | Cocktail box
 | Product | QTY sold (in single portion)
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25 | W26 | [NAME] | W28 | W29 | W30 | W31 | W32 | W33 | [NAME] | W35 | W36 | W37 | W38 | W39 | W40 | W41 | W42 | W43 | W44 | W45 | W46 | W47 | [NAME] | [NAME] | W50 | W51 | W52
 | Plumimg Around | 1 | 2 | 3 | 4
 | Tea Thyme | 1 | 2 | 3 | 4
 | [NAME] | 1 | 2 | 3 | 4
 | [NAME] | 1 | 2 | 3 | 4
 | Pornstar Martini | 1 | 2 | 3 | 4
 | Honest Margarita | 1 | 2 | 3 | 4
 | Gold Truffle | 1 | 2 | 3 | 4
 | Bartender's Choice | 1 | 2 | 3 | 4
 | Best of Britain | 1 | 2 | 3 | 4
 | The Classics | 1 | 2 | 3 | 4
 | Tea Thyme (pre batched) | 1 | 2 | 3 | 4