tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e1d61d6c-0383-40c4-add7-c8b4238f22e7
Sheet: Sheet1

Item | Quantity | Reference | Part | Footprint
1 | 2 | C4,C7 | 220uf | RC100\200+
2 | 11 | C5,C6,C21,C24,C28,C29,C30,C31,C32,C33,C34 | .1uf | AC100\125
3 | 5 | C8,C9,C10,C11,C12 | 1uf | RC100\200+
4 | 2 | C13,C14 | 27pf | AC100\125
5 | 1 | C15 | 10uf | RC100\200+
6 | 4 | C16,C17,C18,C19 | .001UF | AC100\125
7 | 2 | C22,C23 | .22UF | AC100\125
8 | 1 | C25 | .1UF | AC200\125
9 | 2 | C26,C27 | 1000UF | CYL/D.725/LS.300/.040
10 | 9 | D4,D5,D7,D9,D11,D14,D15,D16,D21 | 1N4007 | H_DIODE
11 | 4 | D6,D8,D10,D12 | DIODE ZENER1 | H_DIODE
12 | 4 | D13,D17,D18,D19 | LED | LED
13 | 1 | D20 | 1N914 | H_DIODE
14 | 4 | D22,D23,D24,D25 | BYV27/20 | H_DIODE LARGE
15 | 2 | JP5,JP9 | HEADER 2 | 5_08_T_BLOCK2
16 | 2 | JP6,JP8 | HEADER 2 | 3_81_T_BLOCK2
17 | 1 | JP11 | HEADER 5X2 | J\10P
18 | 1 | [NAME] | HEADER 10 | 3_81_T_BLOCK10
19 | 1 | [NAME] | HEADER 3 | MOLEX\3P\100
20 | 2 | J4,J5 | CON2 | SOLDER
21 | 1 | J6 | CON2 | SOLDER_REV2
22 | 1 | J7 | [NAME] | SIP\1P
23 | 4 | Q2,Q3,Q4,Q5 | MOSFET N | TO220FET GDS
24 | 2 | R1,R21 | 1K,1/4w | AC100\100
25 | 2 | R2,R3 | 4.7K,1/4w | AC100\100
26 | 4 | R4,R6,R8,R10 | 22,1/4w | AC100\100
27 | 4 | R5,R7,R9,R11 | 270,1/4w | AC100\100
28 | 4 | R13,R15,R16,R27 | 10K,1/4w | AC100\100
29 | 3 | R14,R23,R24 | 470,1/4w | AC100\100
30 | 5 | [NAME] | .1,5W | CURRENT SHUNT
31 | 1 | R18 | 100, 1/4w | AC100\100
32 | 3 | [NAME] | 1.2K,1/4w | AC100\100
33 | 1 | R20 | 3.3K,1/4w | AC100\100
34 | 1 | R22 | 5K, POT | TRIMPOT
35 | 1 | R25 | 560,1/4w | AC100\100
36 | 1 | R26 | 22K,1/4w | AC100\100
37 | 1 | R32 | 1.8K,2W | AC450\220
38 | 1 | U1 | AT90S2313 | DIP20
39 | 1 | U6 | HCPL2231 | DIP8
40 | 1 | U8 | MAX232 | DIP16
41 | 1 | U9 | DS1233 | TO-92A
42 | 1 | U10 | TL082 | DIP8
43 | 1 | U11 | 74HC14 | DIP14
44 | 1 | U12 | 4013 | DIP14
45 | 2 | U13,U14 | IR2184 | DIP8
46 | 1 | U15 | LM7805 | TO220AB
47 | 1 | Y1 | 24Mhz | CRYSTAL
Spreadsheet: 732755d1621222493-convert-formula-from-columns-to-row-row-list-example
Sheet: Example 1

 | List1 |  | List2 |  | Missing data in List 2
 | II |  | DD
 | KK |  | GG
 | HH |  | EE
 | EE |  | MM |  |  | "=INDEX($B$3:$B$18, SMALL(IF(ISERROR(MATCH($B$3:$B$18, $[NAME], 0)), (ROW($B$3:$B$18)-MIN(ROW($B$3:$B$18))+1), ""), ROWS($A$1:A1)))"
 | FF |  |  |  |  |  |  | THIS FORMULA WORKS ON COLUMN LIST
 | JJ
 | BB
 | BB |  |  |  |  |  |  | How do I convert it to A Row List
 | NN
 | EE |  |  |  |  |  | List 1 |  | II | KK | HH | EE | JJ | BB | DD
 | NN |  |  |  |  |  | List 2 |  | II | CC | DD | MM | RR | PP | JJ |  | Missing Data | KK | HH | EE | BB
 | FF
 | EE
 | EE
 | JJ
 | JJ
Spreadsheet: 84850d1284950687-selecting-entries-from-a-data-base-vegas-test-pay-sheet
Sheet: Teddy Wilkie

[NAME]
Date | Name | Rep | Pod | 1st TO | 2nd TO | Gross | Down | 649 | Net | Exit | [NAME] | P Exit | TO Pay | Pod Pay | Rep Pay | Total
2010-08-07 00:00:00 | Jones | [NAME] | [NAME] | [NAME] | [NAME] |  |  | 0 | 0 | 995 | 0 | 0 | 0 | 0 | 0 | 0
2010-08-10 00:00:00 | Sprinkle | [NAME] | [NAME] | [NAME] | [NAME] | 5644 | 5644 | 649 | 4995 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-08-20 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | 3544 | 799 | 649 | 799 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-08-29 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | 4995 | 4995 | 649 | 4346 |  | 0 | 0 | 0 | 130.38 | 0 | 130.38
2010-09-07 00:00:00 | [NAME] | Coy Smile | [NAME] | [NAME] | [NAME] | 4644 | 4644 | 649 | 3995 |  | 0 | 0 | 399.5 | 0 | 0 | 399.5
2010-09-07 00:00:00 | Palmer | [NAME] | [NAME] | [NAME] | [NAME] | 3544 | 799 | 649 | 799 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-08 00:00:00 | Musall | [NAME] | [NAME] | [NAME] | [NAME] | 5500 | 5500 | 649 | 4851 |  | 0 | 0 | 0 | 145.53 | 0 | 145.53
2010-09-10 00:00:00 | Isaacs | [NAME] | [NAME] | [NAME] | [NAME] | 2500 | 2500 | 649 | 1851 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-10 00:00:00 | Rega | [NAME] | [NAME] | [NAME] | [NAME] |  |  | 0 | 0 | 995 | 0 | 0 | 0 | 0 | 0 | 0
2010-09-11 00:00:00 | Walker | [NAME] | [NAME] | [NAME] | [NAME] | 3544 | 799 | 649 | 799 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-12 00:00:00 | Rover | [NAME] | [NAME] | Coy Smile | Debroa Barker | 2995 | 2995 | 649 | 2346 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-12 00:00:00 | DeYoung | [NAME] | [NAME] | Debroa Barker | [NAME] | 3544 | 3544 | 649 | 2895 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-13 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | 5544 | 999 | 649 | 999 |  | 0 | 0 | 99.9 | 0 | 0 | 99.9
2010-09-13 00:00:00 | Birks | [NAME] | [NAME] | [NAME] | [NAME] | 1995 | 1995 | 649 | 1346 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-16 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | 2995 | 2995 | 649 | 2346 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-16 00:00:00 | Bekgevin | [NAME] | [NAME] | [NAME] | [NAME] |  |  | 0 | 0 | 995 | 0 | 0 | 0 | 0 | 0 | 0
2010-09-16 00:00:00 | Carver | [NAME] | [NAME] | [NAME] | [NAME] | 1995 | 1995 | 649 | 1346 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-17 00:00:00 | [NAME] | [NAME] | [NAME] | Debroa Barker | [NAME] | 3644 | 3644 | 649 | 2995 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 499.4 | 275.91 | 0 | 775.31
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Total | 775.31
Spreadsheet: 134419d1325272463-how-do-i-write-a-formula-to-tally-class-participation-speech
Sheet: Speech Competions

Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May
Barker | [NAME] | Helton | [NAME] | [NAME] | Helton | Helton | [NAME] | Chambers
Chambers | Bain | [NAME] | Bain | Barker | [NAME] | [NAME] | Helton | Bain
[NAME] | Barker | Martin | Barker | Martin | Martin | Barker | [NAME] | Barker
Bain | Chambers | Chambers | Martin | Chambers | Orr | North | North | Orr
Dart | Dart | Dart | North | Dart | Park | Quinn | Chambers | Park
Gant | Gant | Gant | Gant | Orr | Chambers | Gant | Gant | Gant
Fox | Fox | Fox | Fox | Fox | Fox | Fox | Fox | Fox
Helton | North | North | Park | Quinn | Star | Star | Quinn | Star
[NAME] | Orr | Orr | Quinn | Star | [NAME] |  | Star | [NAME]
Martin | Park | Park | Star
North | Quinn | Quinn | [NAME]
Orr | Star | Star
Park | [NAME]
Quinn
Star
[NAME]
Spreadsheet: larry_may__21893__NG Open
Sheet: Sheet4

Dates | NG - Open
 | Natural Gas Futures (USD/MMBTU)
2001-07-02 00:00:00 | 3.06
2001-07-03 00:00:00 | 3.2
2001-07-05 00:00:00 | 3.26
2001-07-06 00:00:00 | 3.16
2001-07-09 00:00:00 | 3.17
2001-07-10 00:00:00 | 3.23
2001-07-11 00:00:00 | 3.305
2001-07-12 00:00:00 | 3.43
2001-07-13 00:00:00 | 3.32
2001-07-16 00:00:00 | 3.145
2001-07-17 00:00:00 | 3.15
2001-07-18 00:00:00 | 3.16
2001-07-19 00:00:00 | 3.04
2001-07-20 00:00:00 | 2.96
2001-07-23 00:00:00 | 2.98
2001-07-24 00:00:00 | 2.98
2001-07-25 00:00:00 | 3.03
2001-07-26 00:00:00 | 3.29
2001-07-27 00:00:00 | 3.08
2001-07-30 00:00:00 | 3.245
2001-07-31 00:00:00 | 3.38
2001-08-01 00:00:00 | 3.25
2001-08-02 00:00:00 | 3.13
2001-08-03 00:00:00 | 3.09
2001-08-06 00:00:00 | 3.01
2001-08-07 00:00:00 | 3.095
2001-08-08 00:00:00 | 3.03
2001-08-09 00:00:00 | 3.02
2001-08-10 00:00:00 | 2.95
2001-08-13 00:00:00 | 2.995
2001-08-14 00:00:00 | 3.03
2001-08-15 00:00:00 | 3.14
2001-08-16 00:00:00 | 3.58
2001-08-17 00:00:00 | 3.29
2001-08-20 00:00:00 | 3.18
2001-08-21 00:00:00 | 3.15
2001-08-22 00:00:00 | 3.18
2001-08-23 00:00:00 | 2.86
2001-08-24 00:00:00 | 2.8
2001-08-27 00:00:00 | 2.605
2001-08-28 00:00:00 | 2.51
2001-08-29 00:00:00 | 2.39
2001-08-30 00:00:00 | 2.46
2001-08-31 00:00:00 | 2.29
2001-09-04 00:00:00 | 2.29
2001-09-05 00:00:00 | 2.39
2001-09-06 00:00:00 | 2.445
2001-09-07 00:00:00 | 2.43
2001-09-10 00:00:00 | 2.48
2001-09-14 00:00:00 | 2.7
2001-09-17 00:00:00 | 2.425
2001-09-18 00:00:00 | 2.26
2001-09-19 00:00:00 | 2.175
2001-09-20 00:00:00 | 2.11
2001-09-21 00:00:00 | 2.11
2001-09-24 00:00:00 | 2
2001-09-25 00:00:00 | 1.95
2001-09-26 00:00:00 | 1.88
2001-09-27 00:00:00 | 2.29
2001-09-28 00:00:00 | 2.24
2001-10-01 00:00:00 | 2.175
2001-10-02 00:00:00 | 2.21
2001-10-03 00:00:00 | 2.3
2001-10-04 00:00:00 | 2.37
2001-10-05 00:00:00 | 2.36
2001-10-08 00:00:00 | 2.23
2001-10-09 00:00:00 | 2.28
Sum | 189.92
Average | 2.7929
Average (+) | 2.7929
Average (-) | #N/A
Percent (+) | 100
Percent (-) | 0
Maximum | 3.58
Minimum | 1.88
Std Deviation | 0.4491
Zstat | 6.2191
[NAME] | 0.2017
Last | 2.28
Spreadsheet: 734857d1622550778-need-to-get-quarter-wise-value-specific-cost-example123
Sheet: Sheet1

Service PO | PO Validity Start | PO Validity End | PO value (USD) | PO Month | [NAME] | JAS'19 | OND'19 | JFM'20
93455444 | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | 2879.3289 |  |  |  |  | 0  - "not fall as per Po start & end Date"
454444343 | 2020-02-06 00:00:00 | 2020-02-06 00:00:00 | 9671.56800364959
44444444 | 2020-07-01 00:00:00 | 2020-12-31 00:00:00 | 13781.98807401486
55454545 | 2020-08-26 00:00:00 | 2020-08-26 00:00:00 | 11855
345555444 | 2020-10-01 00:00:00 | 2020-12-31 00:00:00 | 5200.467203540903
77666666 | 2019-08-13 00:00:00 | 2019-08-13 00:00:00 | 31814.2872
23434343 | 2019-08-11 00:00:00 | 2019-08-11 00:00:00 | 32615.72508760061
Spreadsheet: 835564d1688657452-formula-to-sum-values-until-level-is-or-lower-bom-sample-bom
Sheet: Planilha1

 | Lvl | Pn | Value |  | Pn | Total
 | 1 | 123456 | 0 |  | 45678
 | 2 | xxxx | 100 |  | 6868
 | 2 | 6868 | 100
 | 3 | xxxx | 100
 | 4 | xxxx | 100
 | 5 | xxxx | 100
 | 1 | 45678 | 0
 | 2 | xxxx | 100
 | 3 | xxxx | 200
 | 3 | xxxx | 300
Spreadsheet: 841364d1693552207-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-copy-of-ef-file-
Sheet: 1-24 Day

 | CR1 | Priority | Headcount
1 | Alinity RV | 17 | 0.25
2 | Alinity RV | 16 | 0.25
3 | Alinity RV | 15 | 0.25
4 | Alinity RV | 14 | 0.25
5 | Alinity RV | 13 | 0.25
12 | [NAME] | 20 | 0.25
13 | [NAME] | 21 | 0.25
9 | Architect RV | 12 | 0.25
15 | Architect SC | 18 | 0.25
16 | Architect RV | 11 | 0.25
17 | Alinity RV | 19 | 0.25
50 | Baxter SIV Assy | 22 | 2
31 | Architect RV | 10 | 0.25
8 | Alinity RV | 9 | 0.25
10 | Architect RV | 8 | 0.25
11 | [NAME] | 24 | 0.25
18 | Architect RV | 7 | 0.25
19 | Architect RV | 6 | 0.25
20 | Siemens | 23 | 0.5
21 | Architect RV | 5 | 0.25
22 | Architect RV | 4 | 0.25
23 | Architect RV | 3 | 0.25
30 | Architect RV | 2 | 0.25
7 | Architect SC | 1 | 0.25
Total
 | CR2 | Priority
73 | PP1 | 5 | 0.25
74 | 6ul | 4 | 0.25
77 | PCR Tube | 3 | 0.25
78 | Side Cassette A mold | 2 | 0.25
79 | E/O Piston | 1 | 0.25
87 | [NAME] | 6 | 0.25
52 | Architect RV | 11 | 0.25
53 | Architect RV | 10 | 0.25
61 | [NAME] | 16 | 0.25
66 | [NAME] | 17 | 0.5
83 | Ceph OM#1
84 | Ceph MB#1 | 9 | 0.25
86 | [NAME] | 11 | 0.25
62 | NP227 | 13 | 0.25
63 | NP Birdcage | 14 | 0.25
64 | Siemens 1ML | 15 | 0.25
67 | [NAME]
69
88 | [NAME] | 8 | 0.25
89 | Top Frame B mold | 7 | 0.25
106 | Key 4 Calm Blue | 12 | 2
107
108
109
Total
Spreadsheet: 346345d1411090944-auto-populate-sheets-based-on-master-sheet-example-2-
Sheet: Vancouver

First Name | Last Name | City | Skills
Spreadsheet: 804351d1668011506-sum-quantities-in-column-based-on-criteria-until-target-reached-average-cost-test
Sheet: Sheet1

Item | Date | Quantity | Cost | Cumulative Stock | Target | Stock for Cost Avg | Weighted Average Cost
1 | 2022-06-01 00:00:00 | 3000 | 0.22 |  | 5372
1 | 2022-05-01 00:00:00 | 6000 | 0.21 |  | 5372
1 | 2022-02-01 00:00:00 | 3000 | 0.23 |  | 5372
1 | 2022-01-01 00:00:00 | 3000 | 0.25 |  | 5372
1 | 2021-12-01 00:00:00 | 2000 | 0.27 |  | 5372
1 | 2021-02-01 00:00:00 | 5000 | 0.3 |  | 5372
2 | 2022-05-01 00:00:00 | 5000 | 0.35 |  | 9982
2 | 2022-02-01 00:00:00 | 6000 | 0.33 |  | 9982
2 | 2022-01-01 00:00:00 | 10000 | 0.25 |  | 9982
2 | 2021-12-01 00:00:00 | 2000 | 0.3 |  | 9982
3 | 2022-07-01 00:00:00 | 4440 | 1.64 |  | 15101
3 | 2022-05-01 00:00:00 | 2004 | 1.6 |  | 15101
3 | 2022-04-01 00:00:00 | 4800 | 1.57 |  | 15101
3 | 2022-03-01 00:00:00 | 3000 | 1.75 |  | 15101
3 | 2022-02-01 00:00:00 | 6000 | 1.8 |  | 15101
3 | 2022-01-01 00:00:00 | 4008 | 1.8 |  | 15101
4 | 2022-09-01 00:00:00 | 5400 | 4.92 |  | 7500
4 | 2022-08-01 00:00:00 | 2004 | 4.99 |  | 7500
4 | 2022-02-01 00:00:00 | 1320 | 5.2 |  | 7500
4 | 2022-01-01 00:00:00 | 9240 | 5.5 |  | 7500
4 | 2021-12-01 00:00:00 | 2004 | 6 |  | 7500
Spreadsheet: 769628d1645622620-combining-like-items-help-022322
Sheet: Current

 |  |  | Count Sheet
Select Row
New Cont | True |  |  |  |  |  |  |  |  |  |  | Data Mapping
Contact Load | True |  |  |  |  |  |  |  |  |  | Picture Link:
 |  |  | Item Number | 90771133 |  | Description | FLM, PNT BUTTER CREAM 10G |  |  |  | Contact Name | 4 |  | Address | 5
 |  |  | I-Spot (mm) | 63.5 |  | Full | 5 |  |  |  | City: | 6 |  | State: | 7
 |  |  | Stated Repeats | 982670 |  | Partial | 1 | Actual Repeats | 982680 |  | Phone #: | 9 |  | [NAME] | 8
Hide Row -> |  |  | E5 | H5 | E7 | H7 | H9 | E9 | M4
 |  |  | Number | Containers |  |  | Units per | Total per
 |  |  |  |  |  |  | Container | Pallet
 |  |  | 1 | 9 |  |  | 18897.6 | 170078.4 | -
 |  |  | 2 | 9 |  |  | 18897.6 | 170078.4 | -
 |  |  | 3 | 9 |  |  | 18897.6 | 170078.4 | -
 |  |  | 4 | 9 |  |  | 18897.6 | 170078.4 | -
 |  |  | 5 | 9 |  |  | 18897.6 | 170078.4 | -
 |  |  | 6 | 6 |  |  | 18897.6 | 113385.6 | -
 |  |  | 6 | 2 |  |  | 9451.2 | 18902.4 | -
 |  |  | - | - |  |  |  | - | -
 |  |  | - | - |  |  |  | - | -
 |  |  | - | - |  |  |  | - | -
 |  |  | - | - |  |  |  | - | -
 |  |  | - | - |  |  |  | - | -
 |  |  | - | - |  |  |  | - | -
 |  |  | - | - |  |  |  | - | -
 |  |  | - | - |  |  |  | - | -
 |  |  | - | - |  |  |  | - | -
 |  |  | - | - |  |  |  | - | -
 |  |  | - | - |  |  |  | - | -
 |  |  | - | - |  |  |  | - | -
Spreadsheet: 1493f6ce-3404-427e-afd7-e81940f3ab62
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/05/2013 | Women's Swimming & Diving | Gold-Blue Meet | 12:00 AM | Gold 231.5-199.5
10/11/2013 | Women's Swimming & Diving | West Virginia State Games (Morgantown, W.Va.) | 12:00 AM | 1st Place
10/12/2013 | Women's Swimming & Diving | West Virginia State Games (Morgantown, W.Va.) | 12:00 AM | 1st Place
10/18/2013 | Women's Swimming & Diving | at Penn State | 12:00 AM | L 102-152
10/25/2013 | Women's Swimming & Diving | WVU Invite (Morgantown, W.Va.) | 12:00 AM | 3rd Place
10/26/2013 | Women's Swimming & Diving | WVU Invite (Morgantown, W.Va.) | 12:00 AM | 3rd Place
11/08/2013 | Women's Swimming & Diving | Big 12/ACC Challenge (Charlottesville, Va.) | 12:00 AM | Results
11/09/2013 | Women's Swimming & Diving | Big 12/ACC Challenge (Charlottesville, Va.) | 12:00 AM | Results
11/21/2013 | Women's Swimming & Diving | Mizzou Invite (Columbia, Mo.) | 12:00 AM | Results
11/22/2013 | Women's Swimming & Diving | Mizzou Invite (Columbia, Mo.) | 12:00 AM | Results
11/23/2013 | Women's Swimming & Diving | Mizzou Invite (Columbia, Mo.) | 12:00 AM | Results
01/03/2014 | Women's Swimming & Diving | Orange Bowl Swim Classic (Key Largo, Fla.) | 12:00 AM | 4th Place
01/11/2014 | Women's Swimming & Diving | Pitt | 12:00 AM | L 119-179
01/18/2014 | Women's Swimming & Diving | at TCU | 12:00 AM | L 121-164
02/01/2014 | Women's Swimming & Diving | at Ohio | 12:00 AM | L 96.5-197.5
02/01/2014 | Women's Swimming & Diving | vs. Iowa State (Athens, Ohio) | 12:00 AM | L 93-200
[NAME] | Women's Swimming & Diving | Big 12 Championships (Austin, Texas) | 12:00 AM | Results
02/27/2014 | Women's Swimming & Diving | Big 12 Championships (Austin, Texas) | 12:00 AM | Results
02/28/2014 | Women's Swimming & Diving | Big 12 Championships (Austin, Texas) | 12:00 AM | Results
03/01/2014 | Women's Swimming & Diving | Big 12 Championships (Austin, Texas) | 12:00 AM | Results
03/10/2014 | Women's Swimming & Diving | [NAME] "A" Diving Championships (Blacksburg, Va.) | 09:00 AM | 9 a.m.
03/11/2014 | Women's Swimming & Diving | [NAME] "A" Diving Championships (Blacksburg, Va.) | 09:00 AM | 9 a.m.
03/20/2014 | Women's Swimming & Diving | Women's [NAME] (Minneapolis, Minn.) | 11:00 AM | 11 a.m.
03/21/2014 | Women's Swimming & Diving | Women's [NAME] (Minneapolis, Minn.) | 11:00 AM | 11 a.m.
[NAME] | Women's Swimming & Diving | Women's [NAME] (Minneapolis, Minn.) | 11:00 AM | 11 a.m.
Spreadsheet: 803741d1667657404-add-roundup-and-rounddown-to-my-formula-roundup-and-rounddown-1-
Sheet: Sheet1

Wave | Time
A | 9.1
B | 5
C | 8
D | 4
E | 7
F | 9
G | 6
 | Average |  | [NAME] |  | > | RoundUp
 |  |  | Min |  | > | RoundDown
Spreadsheet: 875142d1721722926-sum-column-data-in-arrays-from-multiple-sheets-test
Sheet: 3

151-26 | 150-66 | 150-74 | 153-11 | 150-19 | 153-14 | 152-16 | 153-20 | 153-19 | 152-14
56 | 333 | 60 | 86 | 572 | 173 | 670 | 209 | 274 | 975
280 | 424 | 152 | 99 | 530 | 619 | 33 | 896 | 840 | 525
165 | 149 | 571 | 709 | 543 | 673 | 541 | 680 | 36 | 201
408 | 756 | 829 | 243 | 820 | 666 | 265 | 874 | 373 | 613
808 | 6 | 898 | 947 | 398 | 968 | 84 | 978 | 871 | 249
452 | 300 | 473 | 926 | 849 | 114 | 632 | 307 | 229 | 54
37 | 540 | 157 | 97 | 30 | 141 | 629 | 914 | 617 | 365
263 | 525 | 389 | 208 | 474 | 99 | 517 | 972 | 392 | 585
243 | 284 | 677 | 497 | 629 | 245 | 201 | 494 | 381 | 444
255 | 659 | 737 | 88 | 676 | 693 | 71 | 808 | 8 | 493
263 | 718 | 819 | 621 | 9 | 39 | 909 | 516 | 277 | 471
464 | 70 | 148 | 912 | 147 | 527 | 498 | 398 | 620 | 583
37 | 66 | 414 | 557 | 911 | 139 | 165 | 957 | 158 | 970
772 | 590 | 561 | 743 | 799 | 135 | 275 | 58 | 81 | 946
968 | 697 | 763 | 575 | 986 | 496 | 27 | 439 | 205 | 280
104 | 725 | 405 | 746 | 254 | 70 | 436 | 813 | 576 | 355
262 | 804 | 494 | 626 | 987 | 35 | 792 | 839 | 282 | 67
Spreadsheet: 116598d1311939209-function-that-copy-certain-numbers-to-another-sheet-something-like-this-maybe
Sheet: two

stuff | 0,1,2or>2 | data 1 | data 2 | data 3 | data 4 | data 5
NEW002 | 2 | 14 | 26 | 38 | 50 | 62
NEW005 | 2 | 11 | 20 | 29 | 38 | 47
Spreadsheet: 866421d1713337126-how-to-automatically-match-cell-info-from-one-sheet-to-another-if-it-matches-a-cell-in-she-complete-list-mock-up-v1
Sheet: Example_1

Client Names | Notes
2 Winter
Vehicle Details | Make & Model | Vehicle Reg | MOT | Service
 | Renault Traffic Passenger | gbfd | 2025-03-25 00:00:00
OCC Approved  Drivers
Drivers Name | Driving Licence | [NAME] | Endorsements | [NAME]
summer | 1941 | autumn | 2 | 1905-07-15 00:00:00
2011 | February | 1903-04-14 00:00:00 | 103 | 2029-07-17 00:00:00
lisa | 12368 | January |  | 2032-06-07 00:00:00
liz | 1040 | 1996-03-02 00:00:00 | 1 | 2025-11-16 00:00:00
Spreadsheet: 698889d1602228713-looping-through-data-and-evaluate-with-dates-and-logic-samp1a
Sheet: report1602174991843

id |  | Available Date | Created Date |  |  | Type of Change | Count: | Count1 | Count2
1139582 |  | 2019-03-25 00:00:00 | 2019-03-26 00:00:00 |  |  | A
1139582 |  | 2019-03-25 00:00:00 | 2019-03-26 00:00:00 |  |  | B
1139583 |  | 2019-03-24 00:00:00 | 2019-04-01 00:00:00 |  |  | C
1139583 |  | 2019-03-24 00:00:00 | 2019-04-01 00:00:00 |  |  | C
1139621 |  | 2019-01-31 00:00:00 | 2019-02-13 00:00:00 |  |  | A
1139621 |  | 2019-01-31 00:00:00 | 2019-02-13 00:00:00 |  |  | A
1139621 |  | 2019-01-31 00:00:00 | 2019-01-29 00:00:00 |  |  | B
1139621 |  | 2019-01-31 00:00:00 | 2019-01-29 00:00:00 |  |  | B
1139621 |  | 2019-01-31 00:00:00 | 2019-01-29 00:00:00 |  |  | B
1139631 |  | 2019-03-11 00:00:00 | 2019-03-11 00:00:00 |  |  | E
1139736 |  | 2019-02-05 00:00:00 | 2019-02-06 00:00:00 |  |  | F
1139736 |  | 2019-02-05 00:00:00 | 2019-01-29 00:00:00 |  |  | F
1139736 |  | 2019-02-05 00:00:00 | 2019-01-29 00:00:00 |  |  | F
1139736 |  | 2019-02-05 00:00:00 | 2019-01-29 00:00:00 |  |  | F
1139736 |  | 2019-02-05 00:00:00 | 2019-01-29 00:00:00 |  |  | F
1139736 |  | 2019-02-05 00:00:00 | 2019-01-29 00:00:00 |  |  | F
1139736 |  | 2019-02-05 00:00:00 | 2019-01-31 00:00:00 |  |  | F
1139736 |  | 2019-02-05 00:00:00 | 2019-01-31 00:00:00 |  |  | F
1139855 |  | 2019-01-29 00:00:00 | 2019-02-22 00:00:00 |  |  | A
1139855 |  | 2019-01-29 00:00:00 | 2019-03-06 00:00:00 |  |  | B
1139855 |  | 2019-01-29 00:00:00 | 2019-03-06 00:00:00 |  |  | D
1139855 |  | 2019-01-29 00:00:00 | 2019-01-29 00:00:00 |  |  | D
1139855 |  | 2019-01-29 00:00:00 | 2019-01-29 00:00:00 |  |  | D
1140017 |  | 2019-02-13 00:00:00 | 2019-02-22 00:00:00 |  |  | D
1140017 |  | 2019-02-13 00:00:00 | 2019-03-15 00:00:00 |  |  | D
1140017 |  | 2019-02-13 00:00:00 | 2019-03-07 00:00:00 |  |  | D
Spreadsheet: 860683d1708690726-needing-best-solution-for-a-cost-report-cr2022
Sheet: Action List 021023

 | 7529GB-IM-18906-040 | 6600964356
 | 7529GB-IM-18906-040 | 6601022452
 | 7529GB-IM-18901-040 | 6601007980
 | 7529GB-IM-18906-090 | 6600587266
 | 7529GB-IM-18901-090 | 6600846665
 | 7529GB-IM-18906-090 | 6600779691
 | 7529GB-IM-18906-090 | 6601030064
 | 7529GB-IM-18901-050 | 6600516256
 | 7529GB-IM-18901-040 | 6600549249
 | 7529GB-IM-18906-090 | 6601029777
 | 7529GB-IM-18906-060 | 6600866585
 | 7529GB-IM-18901-030 | 6600771880
 | 7529GB-IM-18907-901 | 6600619734
 | 7529GB-IM-18906-090 | 6600639900
 | 7529GB-IM-18906-090 | 6601091760
 | 7529GB-IM-18906-090 | 6600789291
 | 7529GB-IM-18906-090 | 6600639900
 | 7529GB-IM-18906-090 | 6600789636
 | Pos closed in November / December
Spreadsheet: 66705d1267389964-return-values-and-calculate-durations-from-a-table-of-data-interesting-problem-machine-order-book
Sheet: Sheet2

This is my table of machine orders
machine | shift date | client | location
colmar3 | 2010-01-19 00:00:00 | a | b
colmar2 | 2010-02-21 00:00:00 | c | d
colmar3 | 2010-03-01 00:00:00 | e | f
colmar3 | 2010-03-02 00:00:00 | e | f
colmar3 | 2010-03-03 00:00:00 | e | f
colmar1 | 2010-03-09 00:00:00 | v | d
colmar2 | 2010-03-10 00:00:00 | c | f
This table contains the formulas ive made so far. This should match and returns values but im stuck after this
machine | start date | end date | duration | client | location
colmar3 | 2010-03-09 00:00:00 |  |  | v | d
 | 2010-03-10 00:00:00 |  |  | c | f
This is how i want the results table to look. There could be 100s of orders per machine so id like to be able to filter out per machine or dates etc
 | start date | end date | duration | client | location
colmar3 | 2010-03-09 00:00:00 | 2010-01-19 00:00:00 | 1 | a | b
colmar3 | 2010-03-01 00:00:00 | 2010-03-03 00:00:00 | 3 | e | f |  | for concecutive shifts the client & location will be the same for the duration
colmar2 | 2010-02-21 00:00:00 | 2010-02-21 00:00:00 | 1 | c | d
colmar2 | 2010-03-10 00:00:00 | 2010-03-10 00:00:00 | 1 | c | f
colmar1 | 2010-03-09 00:00:00 | 2010-03-09 00:00:00 | 1 | v | d
Spreadsheet: vkaminski__40643__VolCurveGeneratorNew
Sheet: CrossEFACorrelation

 |  |  | CORRELATION MATRIX FOR DERIVING BASKET VOL FROM EFA FWD FWD VOLATILITIES
 | 0.94 |  | [NAME] |  |  | PEAK |  |  |  |  | [NAME]
 |  |  | WD1 | WD2 | WD3 | WD4 | WD5 | WD6 | WE1 | WE2 | WE3 | WE4 | WE5 | WE6
 | [NAME] | WD1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 |  | WD2 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 |  | WD3 |  |  | 1 | 1 | 1 | 1
 | PEAK | WD4 |  |  | 1 | 1 | 1 | 1
 |  | WD5 |  |  | 1 | 1 | 1 | 1
 |  | WD6 |  |  | 1 | 1 | 1 | 1
 |  | WE1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 |  | WE2 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME] | WE3 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 |  | WE4 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 |  | WE5 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 |  | WE6 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 758996d1639221363-distribution-of-values-up-to-10-quoziente
Sheet: Foglio1

 |  |  |  | 15 | 23 | 32 | 36 | 33 | 19 | 14
 |  |  |  | 10
 |  |  |  | 5 | 5
 |  |  |  |  | 10
 |  |  |  |  | 8 | 2
 |  |  |  |  | 0 | 10
 |  |  |  |  | 0 | 10
 |  |  |  |  | 0 | 0 | 10
 |  |  |  |  | 0 | 0 | 6 | 4
 |  |  |  |  | 0 | 0 | 0 | 10
 |  |  |  |  | 0 | 0 | 0 | 9 | 1
 |  |  |  |  | 0 | 0 | 0 | 0 | 10
 |  |  |  |  | 0 | 0 | 0 | 0 | 8 | 2
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 10
Spreadsheet: 204859d1357666099-how-do-i-automatically-highlight-a-cell-example-2
Sheet: Master List

Employee Number | Jan | Feb | Mar | Apr
1 | 1 | 1 | 1 | 1
2 |  |  | 1 | 1
3 | 1 | 1
4 | 1 |  | 1 | 1
5