tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 866063d1713000196-need-formula-that-extracts-every-third-value-in-col-b-based-on-value-1-2-3-in-col-a-transcript-365-aligw
Sheet: Step3

TIME | PERSON/POC | COMMENT
0:0:0.0 --> 0:0:1.470 | [NAME] | Umm I have about one minute.
0:0:2.990 --> 0:0:3.640 | [NAME] | We can start the meeting.
0:0:4.210 --> 0:0:4.750 | [NAME] | Sounds good.
0:0:5.630 --> 0:0:6.220 | [NAME] | Thanks, [NAME].
0:0:6.230 --> 0:0:11.900 | [NAME] | So I still see we don't have anyone from Organization X.
0:0:14.0 --> 0:0:21.870 | [NAME] | We can expect other participants as well.
0:0:22.400 --> 0:0:24.230 | [NAME] | So let's give it a minute.
0:0:31.740 --> 0:0:32.440 | [NAME] | We certainly do.
0:0:32.450 --> 0:0:36.770 | [NAME] | Do you know whether someone from Organization Y will join?
0:0:36.780 --> 0:0:41.530 | [NAME] | Anybody else from your team will be joining this meeting.
0:0:42.170 --> 0:0:44.250 | [NAME] | IT Help Desk should join.
0:0:44.260 --> 0:0:51.120 | [NAME] | I believe [NAME] is on a telephone call, so I'm not sure if he'll be able to make it in, but I think we're good.
Spreadsheet: 723888d1615930820-how-to-determine-the-position-of-the-greatest-value-on-an-arbitrary-range-question-1-
Sheet: Sheet1

408
222
403
426
432
396
390
364
364
15
400
340
275
275
253
230
870
221
221
221
300
350
19
22
400
Spreadsheet: 802648d1666957774-index-match-match-not-working-on-all-instances-mismatched-index-match-match-aligw
Sheet: Sheet1

Date | Product | Variant | SKU | S/be |  |  |  |  | Product | Variant | SKU
2022-02-17 00:00:00 | Product 1 | Variant 1 |  |  |  |  |  |  | Product 1 | Variant 1 | SKU 1
2022-03-12 00:00:00 | Product 1 | Variant 1 |  |  |  |  |  |  | Product 1 | [NAME] | SKU 2
2022-02-06 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 1 | [NAME] | SKU 3
2022-02-17 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 1 | [NAME] | SKU 4
2022-02-24 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 2 | Variant 1 | SKU 5
2022-01-13 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 2 | [NAME] | SKU 6
2022-01-16 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 2 | [NAME] | SKU 7
2022-02-02 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 2 | [NAME] | SKU 8
2022-03-01 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 2 | Variant 5 | SKU 9
2022-03-17 00:00:00 | Product 1 | [NAME] |  |  |  |  |  |  | Product 3 | Variant 1 | SKU 10
2022-01-13 00:00:00 | Product 2 | Variant 1 |  |  |  |  |  |  | Product 3 | [NAME] | SKU 11
2022-02-26 00:00:00 | Product 2 | [NAME] |  | SKU 6 |  |  |  |  | Product 3 | [NAME] | SKU 12
2022-03-23 00:00:00 | Product 2 | [NAME] |  | SKU 6
2022-02-11 00:00:00 | Product 2 | [NAME] |  | SKU 7 |  |  |  |  | Set as Named Ranges (e.g. 'Product'=Sheet1!$J$2:$J$13, etc)
2022-03-30 00:00:00 | Product 2 | [NAME] |  | SKU 7
2022-02-01 00:00:00 | Product 2 | [NAME] |  | SKU 8
2022-03-10 00:00:00 | Product 2 | [NAME] |  | SKU 8
2022-03-24 00:00:00 | Product 2 | [NAME] |  | SKU 8
2022-03-19 00:00:00 | Product 2 | Variant 5 |  | SKU 9
2022-03-12 00:00:00 | Product 2 | Variant 5 |  | SKU 9
2022-01-10 00:00:00 | Product 3 | Variant 1
2022-02-08 00:00:00 | Product 3 | Variant 1
2022-02-11 00:00:00 | Product 3 | Variant 1
2022-03-13 00:00:00 | Product 3 | [NAME] |  | SKU 11
2022-03-10 00:00:00 | Product 3 | [NAME] |  | SKU 11
2022-01-10 00:00:00 | Product 3 | [NAME] |  | SKU 11
2022-01-18 00:00:00 | Product 3 | [NAME] |  | SKU 12
2022-02-11 00:00:00 | Product 3 | [NAME] |  | SKU 12
2022-02-19 00:00:00 | Product 3 | [NAME] |  | SKU 12
2022-03-16 00:00:00 | Product 3 | [NAME] |  | SKU 12
Spreadsheet: 814487d1674440722-count-how-many-groups-have-the-same-value-in-another-column-driver-load-grouping-calc-revised
Sheet: Sheet1

 | [NAME] |  |  |  |  |  |  |  |  |  | PRELIM. DRIVERS |  |  | TOTAL DRIVERS & SIZES
 |  |  |  |  |  |  |  | 1 | 0.625 | 0.375 | 96W | 60W
 | RUN# | RUN WATTAGE | Group Wattage | Group | Percent | Smallest |  |  |  |  |  |  |  | 288W | 192W | 96W | 60W
 |  |  |  | 0 | 80
 | 1 | 22
 | 2 | 22
 | 3 | 61.12
 | 4 | 61.12
 | 5 | 0
 | 6 | 0
 | 7 | 0
 | 8 | 0
 | 9 | 0
 | 10 | 0
 | 11 | 0
 | 12 | 0
 | 13 | 0
 | 14 | 0
 | 15 | 0
 | 16 | 0
 | 17 | 0
 | 18 | 0
 | 19 | 0
 | 20 | 0
 | 21 | 0
 | 22 | 0
 | 23 | 0
 | 24 | 0
 | 25 | 0
 | 26 | 0
 | 27 | 0
 | 28 | 0
 | 29 | 0
 | 30 | 0
 | 31 | 0
 | 32 | 0
 | 33 | 0
 | 34 | 0
 | 35 | 0
 | 36 | 0
 | 37 | 0
 | 38 | 0
 | 39 | 0
 | 40 | 0
 | 41 | 0
 | 42 | 0
 | 43 | 0
 | 44 | 0
 | 45 | 0
 | 46 | 0
 | 47 | 0
 | 48 | 0
 | 49 | 0
 | 50 | 0
 | 51 | 0
 | 52 | 0
 | 53 | 0
 | 54 | 0
 | 55 | 0
 | 56 | 0
 | 57 | 0
 | 58 | 0
 | 59 | 0
 | 60 | 0
 | 61 | 0
 | 62 | 0
 | 63 | 0
 | 64 | 0
 | 65 | 0
 | 66 | 0
 | 67 | 0
 | 68 | 0
 | 69 | 0
 | 70 | 0
 | 71 | 0
 | 72 | 0
 | 73 | 0
 | 74 | 0
 | 75 | 0
 | 76 | 0
 | 77 | 0
 | 78 | 0
 | 79 | 0
 | 80 | 0
 | 81 | 0
 | 82 | 0
 | 83 | 0
 | 84 | 0
 | 85 | 0
 | 86 | 0
 | 87 | 0
 | 88 | 0
 | 89 | 0
 | 90 | 0
 | 91 | 0
 | 92 | 0
 | 93 | 0
 | 94 | 0
 | 95 | 0
 | 96 | 0
 | 97 | 0
 | 98 | 0
 | 99 | 0
 | 100
Spreadsheet: benjamin_rogers__1098__ENA Peaker Plant Summaries
Sheet: Lincoln Center

 | PLANT LOCATION: |  | Chicago
 | Pipeline: |  | Northern Border
 | Delivery Point: |  | Manhattan Station
 | MW Output: |  | 600 MW
 | Heat Rate: |  | 12000
 | 16 Hour Gas Flow: |  | 115,000 [NAME]
 | Facility Costs: |  | 8000000 | +/-
 | Start Date: |  | June, 2000
 | [NAME]
 |  | Service: | Delivered Deal
 |  | Term: | 1 Year Term
 |  | Volume: | 115000 | MMBtu/day
 |  | Rate | GDA + $.10 Delivered to Plant Gate
 |  | Fuel: | 0
 |  | Receipt Points: | Delivered Deal to Plant Gate
 |  | Balancing: | Included as part of delivered price.  Additional cost if
 |  |  | 50% of plant burn is requested intra-day.
 | BACK-UP CONTRACT
 |  | ANR - IWS ($0.01) and IPLS ($0.03) for up to 115,000
 | BALANCING:
 |  | Delivered deal
Spreadsheet: 801488d1666220921-how-to-use-conditional-formatting-to-highlight-column-with-same-hd
Sheet: Sheet1

 |  |  |  | large b/c 2X3.. |  |  |  |  | order: t5vs..2X3 next & 0/1..all 0 like beow.3456(like t8(t9 below) than 6X3
 |  |  |  | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 |  |  |  | 0 | 0 | 0 | 2 | 2 | 2 | 0 | 3 | 3 | 7 | 6 | 6 | 8 | 8 | 11
 |  |  | all | 0 | 0 | 0 | 2 | 2 | 2 | 0 | 3 | 3 | 8 | 6 | 6 | 9 | 9 | 12
 |  |  | [NAME]) | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 3 | 4 | 9 | 6 | 7 | 10 | 11 | 14
 |  |  | all(s/fexp) | 0 | 0 | 1 | 3 | 3 | 3 | 2 | 4 | 5 | 11 | 10 | 9 | 16 | 15 | 19
 |  |  | all(s/fexp) | 0 | 0 | 1 | 3 | 3 | 3 | 3 | 4 | 6 | 12 | 13 | 12 | 21 | 19 | 26
 |  |  | all(s/fexp) | 0 | 0 | 1 | 3 | 5 | 4 | 3 | 4 | 6 | 13 | 16 | 15 | 28 | 22 | 32
 |  |  |  | 0 | 0 | 1 | 3 | 5 | 4 | 3 | 4 | 7 | 14 | 17 | 17 | 30 | 26 | 36
 |  |  |  | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 3 | 3 | 2 | 4 | 4 | 6
 |  |  | all | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 2 | 2 | 4 | 4 | 3 | 5 | 5 | 7
 |  |  | [NAME]) | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 2 | 4 | 4 | 5 | 5 | 7 | 7 | 9
 |  |  | all(s/fexp) | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 2 | 4 | 4 | 8 | 5 | 9 | 8 | 11
 |  |  | all(s/fexp) | 1 | 1 | 2 | 1 | 3 | 2 | 2 | 4 | 7 | 6 | 10 | 12 | 15 | 16 | 20
 |  |  | all(s/fexp) | 1 | 1 | 2 | 1 | 4 | 2 | 2 | 5 | 8 | 6 | 13 | 16 | 20 | 21 | 24
 |  |  |  | 1 | 1 | 2 | 1 | 4 | 2 | 2 | 5 | 8 | 6 | 13 | 16 | 20 | 21 | 24
 |  |  |  |  |  | EXCEL STUDY
 |  |  |  | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 |  |  |  | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 5 | 2 | 2 | 3 | 5 |  |  | False | False | False | False | False | False | False | False | True | False | True | True | True | False
 |  |  | all | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 5 | 2 | 2 | 3 | 5 |  | False | False | False | False | False | False | False | False | False | True | False | True | True | True | False
 |  |  | [NAME]) | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 7 | 2 | 2 | 5 | 6 |  | False | False | False | False | False | False | True | False | True | True | False | True | True | True | False
 |  |  | all(s/fexp) | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 7 | 2 | 4 | 7 | 8 |  | False | False | False | False | False | False | True | False | True | True | False | True | True | False | False
 |  |  | all(s/fexp) | 1 | 0 | 1 | 1 | 1 | 1 | 3 | 1 | 2 | 7 | 9 | 5 | 8 | 11 | 13 |  | False | False | False | False | False | False | True | True | True | False | False | False | False | False | False
 |  |  | all(s/fexp) | 1 | 0 | 1 | 1 | 1 | 1 | 4 | 2 | 3 | 9 | 10 | 8 | 12 | 13 | 18 |  | False | False | False | False | False | False | True | True | True | False | False | False | False | False | False
 |  |  |  | 1 | 0 | 1 | 1 | 1 | 1 | 4 | 2 | 3 | 9 | 10 | 8 | 12 | 13 | 18 |  | False | False | False | False | False | False | True | True | True | False | False | False | False | False | False
Spreadsheet: 43824d1242422021-problem-with-displaying-selected-celss-my-imp-guard-army
Sheet: Data2

1 | Add Bolt Pistol/Boltgun to Company Commander | Found in summary
0 | Add Plasma Pistol to Company Commander | #N/A
1 | Add Power Weapon to Company Commander | #N/A
0 | Add Power Fist to Company Commander | #N/A
0 | Add Meltabombs to Company Commander | #N/A
0 | Add Medi Pack to Veteran | #N/A
0 | Add Regimental Standard to Veteran | #N/A
0 | Add Vox Caster to Veteran | #N/A
0 | Add Heavy Flamer to Veteran | #N/A
0 | Add Mortar to 2 Veterans | #N/A
0 | Add Auto Cannon or Heavy Bolter to 2 Veterans | #N/A
0 | Add Missile Launcher to 2 Veterans | #N/A
0 | Add Lascannon to 2 Veterans | #N/A
0 | [NAME] to Veteran | #N/A
0 | Add Grenade Launcher to Veteran | #N/A
0 | Add Sniper Rifle to Veteran | #N/A
0 | Add Meltagun to Veteran | #N/A
0 | Add Plasma Gun to Veteran | #N/A
0 | Add Krak Grenades to Entire Squad | #N/A
0 | Add Carapace Armor to Entire Squad | #N/A
0 | Add Camo Cloaks to Entire Squad | #N/A
Spreadsheet: 13f0fd07-3ae8-484f-97df-a2911e244a83
Sheet: Sheet1

Smoking Prevalence: 1992-2010 | Unnamed: 1 | Unnamed: 2
Prevalence of Cigarette Smoking by Socio-Economic Group, Adults Aged 16 and Over, Great Britain
Year | Socio-Economic Classification | % Who Smoked Cigarettes
1992 | Manual | 0.33
 | Non-manual | 0.23
1998 | Manual | 0.33
 | Non-manual | 0.22
2002 | Manual | 0.31
 | Non-manual | 0.2
2007 | Manual | 0.25
 | Non-manual | 0.16
2008 | Manual | 0.27
 | Non-manual | 0.16
2009 | Manual | 0.26
 | Non-manual | 0.16
2010* | Manual | 0.28
 | Non-manual | 0.13
*Figures for 2010 are for Routine & Manual and Managerial & Professional groups
Prepared by Cancer Research UK
Original data sources:
1. Office for National Statistics. General [NAME]. Accessed March 2012.
http://www.ons.gov.uk/ons/rel/ghs/general-lifestyle-survey/2010/index.html
2. Office for National Statistics. General [NAME], 2009 Report. Accessed March 2012.
http://www.ons.gov.uk/ons/rel/ghs/general-lifestyle-survey/2009-report/index.html
Spreadsheet: 49568d1248926190-separate-header-rows-to-their-own-row-raw-data
Sheet: Sheet1

3283B62209210221622G50-0NN144WUP00075 |  |  |  |  |  |  | 3283B62209210221622G50-0NN144WUP00075
7.23 |  |  |  |  |  |  | 7.23
9 |  |  |  |  |  |  | 9
300 |  | Move all the characters to the next cell after the spaces |  |  |  |  | 300
70 |  |  |  |  |  |  | 70
71 |  |  |  |  |  |  | 71
28 |  |  |  |  |  |  | 28
13.2 |  |  |  |  |  |  | 13.2
9 |  |  |  |  |  |  | 9
321 |  |  |  |  |  |  | 321
21 |  |  |  |  |  |  | 21
00415  3283B62209210211622G48+0NN144WUP00075" |  |  |  |  |  |  | 415
7.21 |  |  |  |  |  |  | 3283B62209210211622G48+0NN144WUP00075" |  |  |  |  |  | I want the output look like this
5 |  |  |  |  |  |  | 7.21 |  |  |  |  |  | in columnA
31 |  |  |  |  |  |  | 5
69 |  |  |  |  |  |  | 31
78 |  |  |  |  |  |  | 69
37 |  |  |  |  |  |  | 78
13.2 |  |  |  |  |  |  | 37
7.8 |  |  |  |  |  |  | 13.2
245 |  |  |  |  |  |  | 7.8
16 |  |  |  |  |  |  | 245
00253  3283B62209210201622G48-0NN144WUP00075" |  |  |  |  |  |  | 16
7.21 |  |  |  |  |  |  | 253
5 |  |  |  |  |  |  | 3283B62209210201622G48-0NN144WUP00075"
231
76 |  |  |  |  |  |  | and so on….
85
33
13.2
7.2
306
14
00522  3283B62209210191622G48-0NN144WUP00075"
7.2
5
285
78
100
30
13.6
8.6
343
16
00653  3283B62209210181622G48-0NN144WUP00075"
7.2
6
305
72
84
33
13.3
10.2
28
14
00763  3283B62209210171622G49-0NN144WUP00075"
7.2
6
297
72
90
35
13.2
10.4
293
12
00805  3283B62209210161622G48+0NN144WUP00075"
7.2
5
4
72
85
38
13.1
14.6
61
11
00636  3283B62209210151622G48+0NN144WUP00075"
7.2
3
13
63
63
48
12.6
20.7
51
9
00141  3283B62209210141622G47+0NN144WUB00075"
7.2
3
359
60
55
53
12.6
21.4
18
8
00094  3283B62209210131622G46+0NN144WUB00075"
7.2
3
37
55
49
61
12.6
23.7
344
7
00021  3283B62209210121622G47+0NN144WUB00075
7.2
2
70
52
45
60
12.5
23.9
93
4
00000  3283B62209210111622G47+0NN144WUP00075"
7.2
2
61
52
45
62
12.6
24.5
59
4
00000  3283B62209210101622G47+0NN144WUB00075"
7.2
2
67
51
45
61
12.6
24.5
46
4
00000  3283B62209210091622G47+0NN144WUB00075"
7.2
2
74
54
46
59
12.6
25.6
59
5
00000  3283B62209210081622G48+0NN144WUP00075"
7.2
2
69
53
45
58
12.6
25.6
116
5
00000  3283B62209210071622G48+0NN144WUP00075"
7.2
2
60
55
48
70
12.6
24.9
56
10
00000  3283B62209210061622G48-0NN144WUP00075"
7.2
3
38
55
49
68
12.7
23.2
310
10
00000  3283B62209210051622G49+0NN144WUB00075"
7.2
3
36
52
50
85
12.7
22.1
50
5
00000  3283B62209210041622G48+0NN144WUB00075"
7.2
4
48
53
49
81
12.7
20.1
57
12
00000  3283B62209210031622G48+0NN144WUP00075
7.2
5
36
53
52
90
12.7
17
35
16
00000  3283B62209210021622G49+0NN144WUP00075"
7.2
5
32
53
53
93
12.8
12.2
350
13
00004  3283B62209210011622G49+0NN144WUB00075"
7.14
6
13
58
53
70
12.8
8.6
298
15
00021  3283B62209210001622G49-0NN144WUB00075"
7.1
3
11
68
69
34
12.9
8.4
43
14
86
Spreadsheet: 722199d1615110114-convert-repeated-block-data-in-a-column-to-rows-in-a-table-pq-modulo-rows-to-columns-aligw
Sheet: Sheet1

Input |  |  |  | Output Required |  |  |  |  |  |  | 0 | 1 | 2 | 3 | 4 | 5
[NAME] |  |  |  | [NAME] | Grant | Male | 50-60 | Sydney | Non-Smoker |  | [NAME] | Grant | Male | 50-60 | Sydney | Non-Smoker
Grant |  |  |  | [NAME] | Grant | Female | 40-50 | Sydney | Non-Smoker |  | [NAME] | Grant | Female | 40-50 | Sydney | Non-Smoker
Male |  |  |  | Tyron | Talbot | Male | 20-30 | Melbourne | Smoker |  | Tyron | Talbot | Male | 20-30 | Melbourne | Smoker
50-60 |  |  |  | [NAME] | Wood | Male | 60-70 | Sydney | Smoker |  | [NAME] | Wood | Male | 60-70 | Sydney | Smoker
Sydney
Non-Smoker
[NAME]
Grant
Female |  |  |  | I tried to adapt this formula by substituting my cells references but it didn’t work
40-50 |  |  |  | =INDEX($B$3:$B$14,COLUMNS($E$11:$G$14)*(ROW()-ROW($E$11:$G$14))+(COLUMN()-COLUMN($E$11:$G$14)+1),1)
Sydney
Non-Smoker |  |  |  |  | [NAME] | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
Tyron |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
Talbot |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
Male |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
20-30 |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
Melbourne |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
Smoker |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
[NAME] |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
Wood
Male
60-70
Sydney
Smoker
Spreadsheet: 110715d1307345909-creat-top-10-list-example
Sheet: Sheet1

Fault
Issue on exit of HBS
Check-in E-stop active
PEC pos missing
Bag jam
Safety group contactor
Technical error
PEC pos blockage
PPI error
PEC trigg jam
PEC pos blockage
B11 Pendulum switch
PPI error
Controlled stop
Cart jam to next mod
E Stop active
E Stop active
Runtime motor
HBS machine flushing
Controlled stop
PEC pos blockage
PEC trigg 2 blockage
Load too long
B35 Pendulum switch
Controlled stop
E stop active
SCADA CCTV icon link (UDI) not working
PEC pos blockage
Baggage on belt
PEC cart trigger
B51 Pendulum switch
PEC pos blockage
Load too long
Runtime motor
Open bag
Load too long
Height error
PEC pos missings
PEC trigg blockage
Induct error
No PSS stop detect
PEC pos blockage
Amber threshold
Controlled stop
Controlled stop
Runtime motor
Contour above
PEC pos missings
Load too long
Mis-sort
PEC pos missings
Runtime motor
PEC pos blockage
Overlength
B11 Pendulum switch
Contour tilting side
PEC exit blockage
PEC pos missings
Mis-sort
PEC entry blockage
Runtime motor
B23 Pendulum switch
Check-in E-stop (B9)
Emergency stop
B34 Pendulum switch
B46 Pendulum switch
PEC blocked
PEC trigg 2 blockage
PEC pos blockage
Induct error
PEC trigg jam
B37 Pendulum switch
Thermal overload
E-stop active
Contour above
B35 Pendulum switch
PEC pos blockage
Overlength
B11 Pendulum switch
PEC pos blockage
Controlled stop
Controlled stop
Communication Error
B35 Pendulum switch
Runtime motor
PEC pos blockage
Controlled stop
Controlled stop
Check-in E-stop active (D6)
LPM (in warning)
Offline
Controlled stop
B11 Pendulum switch
Runtime motor
Emergency stop
PEC trigg jam
Runtime motor
Controlled stop
PEC pos blockage
Contour top of bag
Contour above
Controlled stop
B34 Pendulum switch
B37 Pendulum switch
PPM
PEC pos 2 blockage
Check-in E-stop active (H14)
Runtime motor
PEC pos blockage
No alarm on SCADA
Spreadsheet: 69220d1269735611-all-worksheets-grand-total-of-a-cell-on-a-new-sheet-book-1
Sheet: WS01

 | [NAME]
 | Material | Description | Book Bal.
WS0150100198D000010 | 50100198D000010 | FR. [NAME] | 0
WS0150100198D100010 | 50100198D100010 | BODY COMPLETE FRAME (WELDED) CD/SS | 0
WS0150100198D110010 | 50100198D110010 | BODY COMPLETE FRAME (WELDED) CD/SS | 0
[NAME] | 50100KCC6900060 | FRAME BODY Y2K5 (PAS PLUS) | 45
WS0150100KCC7100060 | 50100KCC7100060 | FRAME BODY  - Y2K5 (SPL PLUS) | 72
WS0150100KCC7310060 | 50100KCC7310060 | FRAME BODY COMP.(WELDED) PAS (OLD) | 0
[NAME] | 50100KCC8300010 | BODY COMPLETE FRAME (WELDED) SPP | 0
WS0150100KCC8300050 | 50100KCC8300050 | FRAME BODY (W/O FINE BORING) -SPL MMC | 0
WS0150100KCC8300060 | 50100KCC8300060 | FRAME BODY (UPTO FINE BORING) -SPL MMC | 0
WS0150100KCC8310060 | 50100KCC8310060 | FRAME BODY  -SPL MMC | 0
WS0150100KCC9000010 | 50100KCC9000010 | FRAME BODY SPL(WELDED) - PRE Y-2K | 0
WS0150100KCC9400010 | 50100KCC9400010 | BODY COMPLETE FRAME (WELDED) KCC | 0
WS0150100KST8700060 | 50100KST8700060 | BODY COMP.FRAME DLX CND WELDED (SELF) | 6
WS0150100KST9000010 | 50100KST9000010 | BODY COMPLETE FRAME (WELDED) CDN | 0
WS0150100KST9000060 | 50100KST9000060 | FRAME BODY (UPTO FINE BORING) -CDN | 0
WS0150100KST9200060 | 50100KST9200060 | BODY COMP.FRAME STD CDDWELDED | 0
WS0150100KST9300060 | 50100KST9300060 | BODY COMP.FRAME DLX CDD WELDED | 0
WS0150100KST9400060 | 50100KST9400060 | BODY COMP.FRAME STD CNS WELDED(CDN3 -ST) | 0
WS0150100KST9500060 | 50100KST9500060 | BODY COMP.FRAME DLX CND WELDED(CDN3 -DX) | 146
WS0150100KTC9000060 | 50100KTC9000060 | FRAME BODY(WELDED)-SPS | 0
WS0150100KTC9200060 | 50100KTC9200060 | FRAME BODY(WELDED) -SPS SS | 0
WS0150100KTCA000060 | 50100KTCA000060 | FRAME BODY(WELDED) -SPS SS MMC | 5
 |  | Grand Total
Spreadsheet: darrell_schoolcraft__7792__imbalsumm0107
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 44045 | 39043
2 | 48392 | 43656
3 | 60040 | 58397
4 | 52770 | 47992
5 | 46964 | 48492
6 | 54280 | 54491
7 | 50994 | 46207 | -1
8 | 50704 | 46207
9 | 49822 | 46207
10 | 51841 | 47207
11 | 44580 | 46492
12 | 61177 | 56491
13 | 48700 | 43898
14 | 34688 | 29491
15 | 33733 | 28660
16 | 34395 | 29491
17 | 37131 | 37990
18 | 39400 | 39492
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00
2001-07-18 00:00:00
Spreadsheet: 721835d1614882859-index-formula-to-pull-data-from-two-separate-worksheets-adgrissom-index-
Sheet: Results

ZipCode | Company Name | Address Line 1 | City | State | Postal Code | CTM
70002 | Brouillard Vineyards & Winery, LLC | 3636 N Causeway Blvd | [NAME] | Louisiana | 70002
70005 | Three Bourbon LLC | 1520 Gardenia Dr | [NAME] | Louisiana | 70005
70030 | The Fishermen's Wharf | 4381 Highway 306 | Des Allemands | Louisiana | 70030
70053 | [NAME] | 89 New England Ct | Gretna | Louisiana | 70053
70058 | New Orleans Distillers | 501 [NAME] Ave | Harvey | Louisiana | 70058
70068 | [NAME], LLC | 2165 Colonial Dr | La Place | Louisiana | 70068
70072 | Fbn Trading Company, Inc | 5200 Taravella Rd | Marrero | Louisiana | 70072
70112 | Seven Three Distilling Company, LLC | 301 N Claiborne Ave | New Orleans | Louisiana | 70112
70115 | Nola Distilling Company | 3715 [NAME] | New Orleans | Louisiana | 70115
70115 | [NAME], LLC | 1527 [NAME] | New Orleans | Louisiana | 70115
70118 | Bootleg Distillation LLC | 1524 Broadway St | New Orleans | Louisiana | 70118
70118 | River Basin Distillery, LLC | 8019 [NAME] | New Orleans | Louisiana | 70118
70119 | Cajun Spirits Distillery LLC | 2532 [NAME] | New Orleans | Louisiana | 70119
70121 | [NAME], LLC | 355 Iris Ave | [NAME] | Louisiana | 70121
70122 | Celebration Distillation Corporation | 2815 Frenchmen St | New Orleans | Louisiana | 70122
70123 | The Old Alker Distillery LLC | 116 Haroleans St | New Orleans | Louisiana | 70123
70124 | Brewed & Distilled LLC | 347 22Nd St | New Orleans | Louisiana | 70124
70125 | [NAME], LLC | 1001 S Broad St | New Orleans | Louisiana | 70125
70125 | Ike N Tina, L.L.C. | 3940 Thalia St | New Orleans | Louisiana | 70125
70125 | Roulaison Distilling Co | 2727 S [NAME] 103 | New Orleans | Louisiana | 70125
70125 | The Cidery LLC | 3235 [NAME] | New Orleans | Louisiana | 70125
70126 | Dixie Brewing Company, LLC | 3501 [NAME] | New Orleans | Louisiana | 70126
70130 | Wetlands Sake LLC | 634 Orange St | New Orleans | Louisiana | 70130
70131 | Smallman Brewing, LLC | 3709 Inwood Ave | New Orleans | Louisiana | 70131
70301 | Donner-Peltier Distillers LLC | 408 [NAME] | [NAME] | Louisiana | 70301
70360 | Bayou Terrebonne Distillers, LLC | 8043 Main St | [NAME] | Louisiana | 70360
70403 | Miel Brewing Company LLC | 42040 [NAME] | Hammond | Louisiana | 70403
70420 | The Abita Band Inc | 72056 Pine St | [NAME] | Louisiana | 70420
70422 | Louisiana Lightning | 10571 Highway 16 | Amite | Louisiana | 70422
70431 | Distinctive Wines of Louisiana, Inc | 81250 Highway 1082 | [NAME] | Louisiana | 70431
70433 | Milicevic Familiy Vineyards | 111 N Polk St | Covington | Louisiana | 70433
70435 | [NAME] | 12375 Arc Rd | Covington | Louisiana | 70435
70443 | Amato's Winery, Inc | 12415 W Black Cat Rd | Independence | Louisiana | 70443
Spreadsheet: 356631d1415169897-concatenate-as-long-there-are-values-in-the-next-cells-concatenation_need-help
Sheet: Sheet1

 | Client 1 | Client 2 | Client 3 | Client 4
CONCATENATED VERSION | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE]
 | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 | [PHONE] |  | [PHONE] | [PHONE]
 | [PHONE] |  | [PHONE] | [PHONE]
 | [PHONE] |  | [PHONE] | [PHONE]
 | [PHONE] |  | [PHONE] | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]