tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 200523d1355604317-how-can-i-transpose-multiple-rows-into-one-column-transpose
Sheet: Sheet1

 |  |  |  | How can I get this
Into this
1289.6 |  |  |  | 1289.6 | 2380.8 | 545.6 | 322.4 | 421.6
2380.8
545.6
322.4
421.6
66.3 |  |  |  | 66.3 | 122.4 | 28.05 | 16.575 | 21.675
122.4
28.05
16.575
21.675
198.9 |  |  |  | 198.9 | 367.2 | 84.15 | 49.725 | 65.025
367.2
84.15
49.725
65.025
132.6 |  |  |  | 132.6 | 244.8 | 56.1 | 33.15 | 43.35
244.8
56.1
33.15
43.35
530.4 |  |  |  | 530.4 | 979.1999999999999 | 224.4 | 132.6 | 173.4
979.1999999999999
224.4
132.6
173.4
1723.8 |  |  |  | 1723.8 | 3182.4 | 729.3 | 430.95 | 563.5500000000001
3182.4
729.3
430.95
563.5500000000001
2121.6 |  |  |  | 2121.6 | 3916.8 | 897.6 | 530.4 | 693.6
3916.8
897.6
530.4
693.6
Spreadsheet: 118462d1313701094-margin-of-error-do-not-change-point-if-within-5-of-previous-point-testspreadsheet
Sheet: Sheet1

1 | 564798
2 | 564832
3 | 554799
4 | 547644
5 | 584343
1 | 564798
2 | 564798
3 | 564798
4 | 564798
5 | 584343
Spreadsheet: 109110d1306025321-mirroring-a-single-table-across-worksheets-5-3-1
Sheet: Week 5

[NAME] 5/3/1 |  |  |  |  |  |  | Weight | Reps <12 | 1RM | 5RM | 90% 1RM
Linear Pre-Periodization |  |  |  |  |  | OHP | 100 | 5 | 112.5112511251125 | 100 | 100
 |  |  |  |  |  | Deadlift | 360 | 3 | 381.1944091486658 | 338.8055908513342 | 345
 |  |  |  |  |  | Bench | 95 | 3 | 100.5929690808979 | 89.40703091910207 | 90
 |  |  |  |  |  | Squat | 260 | 3 | 275.3070732740364 | 244.6929267259636 | 250
 |  |  |  |  |  | Set Interval | 0.125 | Generally 10-15%
Day | Exercise | Reps | Weight |  | Day | Exercise | Reps | Weight |  | Day | Exercise | Reps | Weight
Friday | Overhead Press | 5 | 25 |  | Sunday | Bench | 5 | 20 |  | [NAME] | Squat | 5 | 65
 |  | 5 | 30 |  |  |  | 5 | 25 |  |  |  | 5 | 75
 |  | 3 | 35 |  |  |  | 3 | 30 |  |  |  | 3 | 90
 |  | 5 | 40 |  |  |  | 5 | 35 |  |  |  | 5 | 100
 |  | 5 | 50 |  |  |  | 5 | 45 |  |  |  | 5 | 125
 |  | 5 | 60 |  |  |  | 5 | 55 |  |  |  | 5 | 150
 | Deadlift | 5 | 25 |  |  | Pullups | 15 | BW |  |  | [NAME] | 15 | 290
 |  | 5 | 30 |  |  |  | 14 | BW |  |  |  | 15 | 290
 |  | 5 | 35 |  |  |  | 11 | BW |  |  |  | 15 | 290
 |  | 5 | 40 |  |  |  | 13 | BW |  |  |  | 15 | 290
 |  | 5 | 50 |  |  |  | 10 | BW |  |  |  | 15 | 290
 |  | 5 | 60 |  |  | Skullcrushers | 12 | 0 |  |  | Hanging Leg Raise/Decline Situps | 10 | BW
 | Pullups | 15 | BW |  |  |  | 12 | 0 |  |  |  | 10 | BW
 |  | 14 | BW |  |  |  | 12 | 0 |  |  |  | 10 | BW
 |  | 10 | BW |  |  |  | 12 | 0 |  |  |  | 10 | BW
 |  | 12 | BW |  |  |  | 12 | 0 |  |  |  | 10 | BW
 |  | 10 | BW
 | Romanian Deadlift | 12 | 185
 |  | 12 | 185
 |  | 12 | 185
 |  | 12 | 185
 |  | 12 | 185
 | [NAME] | 15 | BW
 |  | 15 | BW
 |  | 15 | BW
 |  | 15 | BW
 |  | 15 | BW
Spreadsheet: 231564d1367136169-is-there-a-simplified-method-for-sorting-extracted-data-sample-sort-2
Sheet: MASTER

[NAME] | FRIDAY
 | 2013-04-05 00:00:00 |  |  |  |  |  |  |  |  | The help columns F & H thru M are hidden.
STAFF | avail | IN | OUT | Position | Hours
Name 2 | ANY | 09:00:00 | 16:00:00 | B |  |  |  |  |  | I am just assuming what those "help" columns are for
Name 11 | ANY | 10:00:00 | 16:00:00 | C |  |  |  |  |  | so I titled them by what they seem to do.
Name 1 | ANY | 08:00:00 | 14:00:00 | B
Name 5 | ANY | 18:00:00 | 01:00:00 | B |  |  |  |  |  | The "Extract Criteria" is based off "Position"(B,C,D,U), "AM or PM"(A or P) and sorted
Name 29 | ANY | 19:00:00 | 01:00:00 | U |  |  |  |  |  | by "IN" time from earliest to latest with the help of the "ROW VALUES" and "SORTING COLUMN"
Name 4 | ANY | 17:00:00 | 01:00:00 | B |  |  |  |  |  | Which is then extracted and sorted to its corresponding cells on the "FRIDAY" worksheet.
Name 9 | ANY | 09:00:00 | 15:00:00 | C
Name 24 | ANY | 10:00:00 | 19:00:00 | U | 8 |  |  |  |  | You will also notice that none of the data is in any order on this sheet. But when it is
Name 8 | ANY | 08:00:00 | 14:00:00 | C |  |  |  |  |  | extracted to the "FRIDAY" worksheet ,each position (AM BOX, PM BOX,ect…) is first sorted from
Name 12 | ANY | 14:00:00 | 21:00:00 | C |  |  |  |  |  | earliest to latest and is matched with the Staff name scheduled for that shift.
Name 17 | ANY | 09:00:00 | 16:00:00 | D
Name 7 | ANY | 07:00:00 | 12:00:00 | C
Name 14 | ANY | 17:00:00 | 01:00:00 | C |  |  |  |  |  | My question is: Is there a simplified method to accomplishing this without the use
Name 16 | ANY | 18:00:00 | 01:00:00 | C |  |  |  |  |  | of any or as many help columns (F,H thru M)
Name 19 | ANY | 16:30:00 | 01:00:00 | D
Name 15 | ANY | 17:00:00 | 01:00:00 | C
Name 23 | ANY | 10:00:00 | 18:00:00 | U
Name 13 | ANY | 16:00:00 | 01:00:00 | C
Name 20 | ANY | 17:00:00 | 01:00:00 | D
Name 18 | ANY | 09:30:00 | 16:00:00 | D
Name 22 | ANY | 09:00:00 | 16:00:00 | U
Name 28 | ANY | 18:00:00 | 01:00:00 | U
Name 10 | ANY | 09:00:00 | 16:00:00 | C
Name 3 | ANY | 10:00:00 | 17:00:00 | B
Name 21 | ANY | 08:00:00 | 16:00:00 | U
Name 6 | ANY | 18:30:00 | 01:00:00 | B
Name 27 | ANY | 17:00:00 | 01:00:00 | U
Name 25 | ANY | 11:30:00 | 18:30:00 | U
Name 26 | ANY | 16:00:00 | 22:00:00 | U
Name 30 | ANY | 19:30:00 | 01:00:00 | U
Spreadsheet: 63577d1264466883-multiple-fields-to-multiple-rows-for-want-of-a-better-description-sat-upload-
Sheet: Sales

 |  |  |  | Invoice Line 1 |  |  |  |  |  | Invoice Line 2 |  |  |  |  |  | Invoice Line 3 |  |  |  |  |  | Invoice Line 4 |  |  |  |  |  | Invoice Line 5
[NAME] | Invoice Number | Date | Customer | Product 1 | Unit Cost 1 | Price 1 | Qty 1 | Total 1 | Profit 1 | Product 2 | Unit Cost 2 | Price 2 | Qty 2 | Total 2 | Profit 2 | Product 3 | Unit Cost 3 | Price 3 | Qty 3 | Total 3 | Profit 3 | Product 4 | Unit Cost 4 | Price 4 | Qty 4 | Total 4 | Profit 4 | Product 5 | Unit Cost 5 | Price 5 | Qty 5 | Total 5 | Profit 5 | Invoice Total | Invoice Profit
 | AS00001 | 2010-01-18 00:00:00 | C000005, [NAME] | P00003, Panasonic 42" |  | 500 | 1 |  |  | P00008, 2.2m Dish |  | 100 | 1 |  |  | [NAME], Quad LMB |  | 30 | 1 |  |  | P00009, HD Sky+ |  | 200 | 1 |  |  | P00012, [NAME] |  | 250 | 1
 | AS00002 | 2010-01-19 00:00:00 | C000011, [NAME] | P00006, Digital Radio |  | 50 | 1 |  |  | P00012, [NAME] |  | 300 | 1
 | AS00003 | 2010-01-20 00:00:00 | C000006, [NAME] | [NAME], Quad LMB |  | 40 | 1
 | AS00004 | 2010-01-21 00:00:00 | C000003, [NAME] | P00004, 2m Dish |  | 100 | 1
 | AS00005 | 2010-01-22 00:00:00 | C000016, [NAME] | P00004, 2m Dish |  | 100 | 1 |  |  | P00002, Amstrad Sky+ Box |  | 100 | 1 |  |  | P00012, [NAME] |  | 300 | 1
 | AS00006 | 2010-01-22 00:00:00 | C000004, Blair Davies | P00009, HD Sky+ |  | 200 | 1 |  |  | P00008, 2.2m Dish |  | 200 | 1
 | AS00007 | 2010-01-22 00:00:00 | C000006, [NAME] | [NAME], Quad LMB |  | 50 | 1
 | AS00008 | 2010-01-23 00:00:00 | C000002, [NAME] | P00008, 2.2m Dish |  | 120 | 1
 | AS00009 | 2010-01-23 00:00:00 | C000012, [NAME] | P00006, Digital Radio |  | 60 | 1
 | AS00010 | 2010-01-23 00:00:00 | C000015, [NAME] | P00005, Sky+ Remote |  | 20 | 1
 | AS00011 | 2010-01-23 00:00:00 | C000013, [NAME] | P00003, Panasonic 42" |  | 500 | 1 |  |  | P00012, [NAME] |  | 300 | 1
 | AS00012 | 2010-01-23 00:00:00 | C000014, [NAME] | P00001, [NAME] |  | 15 | 1
 | AS00013 | 2010-01-24 00:00:00 | C000009, [NAME] | P00002, Amstrad Sky+ Box |  | 100 | 1
 | AS00014 | 2010-01-24 00:00:00 | C000001, [NAME] | P00006, Digital Radio |  | 60 | 2
 | AS00015 | 2010-01-24 00:00:00 | C000008, [NAME] | P00007, 1.8m Dish |  | 60 | 1
 | AS00016 | 2010-01-25 00:00:00 | C000007, [NAME] | P00002, Amstrad Sky+ Box |  | 100 | 1
 | AS00017 | 2010-01-25 00:00:00 | C000017, [NAME] | [NAME], Quad LMB |  | 40 | 1
 | AS00018 | 2010-01-25 00:00:00 | C000011, [NAME] | P00007, 1.8m Dish |  | 60 | 1
 | AS00019 | 2010-01-25 00:00:00 | C000003, [NAME] | P00012, [NAME] |  | 300 | 1
 | AS00020 | 2010-01-25 00:00:00 | C000010, [NAME] | P00009, HD Sky+ |  | 200
Spreadsheet: 767794d1644639274-sumif-range-len-split-range-iec_03_ans
Sheet: IE

1 |  | CDL-11
2 |  | CDT-11
3 |  | GE-11
4 |  | GE-12
5 |  | M-11
6 |  | M-12
7 |  | M-13
8 |  | SSTD-ADM12
9 |  | SSTD-EST13
10 |  | SSTD-EST15
11 |  | SSTD-PISC01
12 |  | SSTD-PISC02
13 |  | SSTD-PISC03
14 |  | SSTD-PISC04
15 |  | STD-AA11
16 |  | STD-AA12
17 |  | STD-AA13
18 |  | STD-AA14
19 |  | STD-AA21
20 |  | STD-AA22
21 |  | STD-AA31
22 |  | STD-AA32
23 |  | STD-AA33
24 |  | STD-AA41
25 |  | STD-AB11
26 |  | STD-AB12
27 |  | STD-AB13
28 |  | STD-AB14
29 |  | STD-AB21
30 |  | STD-AB22
31 |  | STD-AB31
32 |  | STD-AB32
33 |  | STD-AB33
34 |  | STD-AB34
35 |  | STD-AB41
36 |  | STD-AC11
37 |  | STD-AC12
38 |  | STD-AC13
39 |  | STD-AC14
40 |  | STD-AC21
41 |  | STD-AC22
42 |  | STD-AC31
43 |  | STD-AC32
44 |  | STD-AC33
45 |  | STD-AC41
46 |  | STD-ADM11
47 |  | STD-ADM12
48 |  | STD-ADM13
49 |  | STD-ADM14
50 |  | STD-ADM15
51 |  | STD-ADM21
52 |  | STD-ADM22
53 |  | STD-ADM23
54 |  | STD-ADM24
55 |  | STD-ADM31
56 |  | STD-ADM32
57 |  | STD-ADM33
58 |  | STD-ADM41
59 |  | STD-ADM42
60 |  | STD-ADM43
61 |  | STD-ADM44
62 |  | STD-ADM51
63 |  | STD-AUD11
64 |  | STD-AUD12
65 |  | STD-AUD13
66 |  | STD-AUD14
67 |  | STD-AUD15
68 |  | STD-AUD21
69 |  | STD-AUD31
70 |  | STD-AUD32
71 |  | STD-CAF11
72 |  | STD-CAF21
73 |  | STD-CAF31
74 |  | STD-CAF32
75 |  | STD-CAF33
76 |  | STD-CAF34
77 |  | STD-CIST01
78 |  | STD-CIST02
79 |  | STD-CIST03
80 |  | STD-EST11
81 |  | STD-EST12
82 |  | STD-EST13
83 |  | STD-EST14
84 |  | STD-EST15
85 |  | STD-INCD01
86 |  | STD-INCD02
87 |  | STD-INCD03
88 |  | STD-PISC01
89 |  | STD-PISC11
90 |  | STD-PISC21
91 |  | STD-T11
92 |  | STD-T12
93 |  | STD-T13
94 |  | STD-T14
95 |  | STD-T15
96 |  | STD-T16
97 |  | STD-T17
98 |  | STD-T18
99 |  | STD-T21
100 |  | STD-T22
101 |  | STD-T23
102 |  | STD-T24
103 |  | STD-T25
104 |  | STD-T26
105 |  | STD-T31
106 |  | STD-T32
107 |  | STD-T33
108 |  | STD-T34
109 |  | STD-T35
110 |  | STD-T36
111 |  | STD-T37
112 |  | STD-T41
113 |  | STD-VIV11
114 |  | TD-AA
115 |  | TD-AB
116 |  | TD-AC
117 |  | TD-ADM
118 |  | TD-AUD
119 |  | TD-CAF
120 |  | TD-CIST
121 |  | TD-EST
122 |  | TD-INCD01
123 |  | TD-PISC
124 |  | TD-SSEE
125 |  | TD-TALL
126 |  | TD-VIV
127 |  | TE-T33
128 |  | TE-T34
129 |  | TE-T35
130 |  | TE-T37
131 |  | [NAME]
132 |  | TG-12
133 |  | TGE-T31
134 |  | TTF-11
135 |  | TTF-12
Spreadsheet: 06d9b519-b8ee-437c-90d4-c969de3e8939
Sheet: Charges

FY 2014-15 General Fund Overhead
Fund | FY 2013-14  CAL Charge | Difference | FY 2014-15 CAL Charge | FY 2012-13 True-Up | FY 2014-15 Total Charge
100 - General Fund | 19855263 | 1385103 | 21240366 | 600980 | 21841346
200 - Transportation Operating Fund | 6564665 | -508470 | 6056195 | -450673 | 5605522
201 - Assessment Collection Fund | 12 | -12 | 0 | -14 | -14
202 - Emergency Communication Fund | 877412 | -127411 | 750001 | -93155 | 656846
203 - Development Services Fund | 1044982 | -65065 | 979917 | 46474 | 1026391
204 - Property Management License Fund | 0 | 25000 | 25000 | 0 | 25000
206 - MHCRC Agency Fund | 0 | 25000 | 25000 | 0 | 25000
209 - Convention and Tourism Fund | 56826 | -31826 | 25000 | 0 | 25000
213 - Housing Investment Fund | 218979 | -130730 | 88249 | 35960 | 124209
215 - Parks Local Option Levy Fund | 9633 | 4601 | 14234 | 34000 | 48234
216 - Children's Investment Fund | 25000 | 0 | 25000 | 0 | 25000
221 - Tax Increment Financing Reimbursement Fund | 835994 | -92863 | 743131 | -279718 | 463413
222 - Police Special Revenue Fund | 11137 | 12654 | 23791 | 365 | 24156
223 - Arts Education & Access Fund | 0 | 25000 | 25000 | 0 | 25000
400 - BFRES Facilities GO Bond Construction Fund | 46490 | -19388 | 27102 | 39842 | 66944
401 - Local Improvement District Fund | 48200 | -42685 | 5515 | -69738 | -64223
402 - Parks Capital Improvement Program Fund | 190847 | 2807 | 193654 | 31778 | 225432
403 - Public Safety GO Bond Fund | 40107 | 56916 | 97023 | 21384 | 118407
600 - Sewer System Operating Fund | 7072025 | -1594951 | 5477074 | -1784345 | 3692729
601 - Hydroelectric Power Operating Fund | 29624 | -11417 | 18207 | -23162 | -4955
602 - Water Fund | 4533246 | -92382 | 4440864 | -458039 | 3982825
603 - Golf Fund | 302239 | 4661 | 306900 | 19414 | 326314
604 - Portland International Raceway Fund | 63031 | 68328 | 131359 | 49739 | 181098
605 - Solid Waste Management Fund | 188043 | -20430 | 167613 | -20742 | 146871
606 - Parking Facilities Fund | 169525 | -32078 | 137447 | -75229 | 62218
607 - Spectator Facilities Operating Fund | 197855 | -51441 | 146414 | -41312 | 105102
608 - Environmental Remediation Fund | 170185 | -32116 | 138069 | 7324 | 145393
700 - Health Insurance Operating Fund | 88889 | 100096 | 188985 | 80298 | 269283
701 - Facilities Services Operating Fund | 870715 | -77586 | 793129 | -138454 | 654675
702 - CityFleet Operating Fund | 966077 | -61953 | 904124 | 60976 | 965100
703 - Printing & Distribution Services Operating Fund | 255395 | -14947 | 240448 | 10729 | 251177
704 - Insurance and Claims Operating Fund | 269709 | -41301 | 228408 | -46260 | 182148
705 - Workers' Comp. Self Insurance Operating Fund | 146759 | -3645 | 143114 | 1258 | 144372
706 - Technology Services Fund | 1788183 | -55392 | 1732791 | 82531 | 1815322
708 - EBS Services Fund | 210491 | -49149 | 161342 | -129971 | 31371
800 - Fire & Police Disability & Retirement Fund | 96883 | 20626 | 117509 | 15212 | 132721
PDC - Portland Development Commission | 146823 | 40288 | 187111 | -11032 | 176079
Grand Total | 47391244 | -1386158 | 46005086 | -2483580 | 43521506
 |  | Recovery Rate
Spreadsheet: 47137d1246038108-identifying-first-and-last-data-in-a-range-book1
Sheet: Sheet1

 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | [NAME] | End Mth
#1 | 0 | 1 | 0 | 3 | 2 | 2009-02-09 00:00:00 | 2009-05-01 00:00:00
#2 | 0 | 0 | 0 | 1 | 2 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00
#3 | 0 | 1 | 0 | 0 | 0 | 2009-02-01 00:00:00 | 2009-02-09 00:00:00
Spreadsheet: 732932d1621325162-extract-data-with-dependent-dropdown-from-multiple-tables-engine_workbook
Sheet: Engine A

 | level | type | Components | description | quantity |  | level | type | Components | description | quantity
 | 1 | Engine A | A022Q273A | Befestigungsgehaeuse | 1 |  | 1 | Engine A | A022Q273A | Befestigungsgehaeuse | 1
 | 1 | Engine A | 14170674N | BG Anschluss | 1 |  | 1 | Engine A | 14170674N | BG Anschluss | 1
 | 2 | Engine A | 10156293G | Anschluss Gussteil | 1 |  | 2 | Engine A | 10156293G | Anschluss Gussteil | 1
 | 2 | Engine A | 10155435D | Verbindungsstueck -1395- | 2 |  | 2 | Engine A | 10155435D | Verbindungsstueck -1395- | 2
 | 2 | Engine A | 02151472A | Dichtstopfen MB600-040 | 2 |  | 2 | Engine A | 02151472A | Dichtstopfen MB600-040 | 2
 | 2 | Engine A | 02151476B | O-Ring 5,3x1,8.HNBR 70 Shore A | 4 |  | 2 | Engine A | 02151476B | O-Ring 5,3x1,8.HNBR 70 Shore A | 4
Spreadsheet: 848953d1699545397-if-data-matches-from-list-to-data-range-in-another-coloumn-update-cell-in-same-row-store-keeper-jacc
Sheet: Stock

Category | Item Description | Part Number | UoM | MoQ | Quantity brought in | Quantity left in stock
Cable | 10mm 2491B Single Ins LSOH EARTH | CA-14-044 | M | 50 | 300
Cable | 10mm 6381Y Double Ins PVC EARTH | CA-14-052 | M | 50 | 300
Cable | 10mm Tri-Rated Single Ins PVC BLUE | CA-14-057 | M | 10 | 30
Cable | 10mm Tri-Rated Single Ins PVC EARTH | CA-14-059 | M | 10 | 30
Spreadsheet: 04ab9c1d-01c5-454c-a86f-3bf7ddc07122
Sheet: Sheet1

Table 5--Corn: Food, seed, and industrial use (million bushels), 7/13/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Mkt year and qtr 1/ |  | High-fructose corn syrup (HFCS) | Glucose and dextrose | Starch | Alcohol for fuel | Alcohol for beverages and manufacturing | Cereals and other products | Seed | Total food, seed, and industrial use
2010/11 | Q1 Sep-Nov | 126.248 | 65.111 | 66.286 | 1240.169 | 33.02 | 49.115 | 0 | 1579.949
 | [NAME] | 116.275 | 59.718 | 62.534 | 1257.314 | 34.588 | 48.575 | 0 | 1579.004
 | [NAME] | 138.897 | 70.856 | 64.409 | 1259.428 | 36.164 | 49.655 | 20.24 | 1639.649
 | [NAME] | 139.635 | 76.694 | 64.697 | 1264.303 | 31.228 | 49.655 | 2.76 | 1628.972
 | MY Sep-Aug | 521.055 | 272.379 | 257.926 | 5021.214 | 135 | 197 | 23 | 6427.574
2011/12 | Q1 Sep-Nov | 119.607 | 77.97 | 64.635 | 1268.06 | 33.02 | 50.1 | 0 | 1613.392
 | [NAME] | 114.999 | 71.005 | 62.018 | 1304.439 | 34.588 | 50.1 | 0 | 1637.149
 | [NAME] | 135.734 | 73.556 | 62.214 | 1252.416 | 36.164 | 49.899 | 23.401 | 1633.384
 | MY Sep-Aug | 495 | 300 | 250 | 5050 | 135 | 200.7 | 24.3 | 6455
2012/13 | MY Sep-Aug | 500 | 300 | 255 | 4900 | 135 | 205 | 25 | 6320
1/ September-August.  Latest data may be preliminary or projected. Source: Calculated by USDA, Economic Research Service.
Date run: 7/12/2012
Spreadsheet: 854417d1704299426-sum-with-index-match-holiday_test-sheet-hd
Sheet: Jan

 | JANUARY
Area | Name | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 | 2024-01-08 00:00:00 | 2024-01-09 00:00:00 | 2024-01-10 00:00:00 | 2024-01-11 00:00:00 | 2024-01-12 00:00:00 | 2024-01-13 00:00:00 | 2024-01-14 00:00:00 | 2024-01-15 00:00:00 | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 | 2024-01-18 00:00:00 | 2024-01-19 00:00:00 | 2024-01-20 00:00:00 | 2024-01-21 00:00:00 | 2024-01-22 00:00:00 | 2024-01-23 00:00:00 | 2024-01-24 00:00:00 | 2024-01-25 00:00:00 | 2024-01-26 00:00:00 | 2024-01-27 00:00:00 | 2024-01-28 00:00:00 | 2024-01-29 00:00:00 | 2024-01-30 00:00:00 | 2024-01-31 00:00:00 | Total A/L
1 | Adam | B/H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A/L | A/L
1 | [NAME] | B/H
2 | [NAME] | B/H
2 | Debs | B/H
2 | Elaine | B/H
3 | [NAME] | B/H
3 | George | B/H
3 | Helen | B/H
5 | Ian | B/H |  |  |  |  |  |  |  | A/L | A/L | A/L | A/L
Spreadsheet: tracy_geaccone__40345__2002 EREC Preliminary 1015
Sheet: Investing

DETAIL OF EQUITY INVESTMENTS
BUSINESS ACQUISITIONS, INTERCOMPANY INVESTING & OTHER INVESTING ACTIVITIES
Non-Merchant Activities
(Millions of Dollars)
 | Investing Activities
 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Total
Equity Investments
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
Total (line 124)
Cash Paid for Business Acquisitions
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
Total (line 126)
Other Investing Activity
Installment Note Collections | 0 |  | 0 |  | 2.6 |  | 0 |  | 0.9 |  | 0.3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0.6 |  | 0.7 |  | 5.1
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
Total (line 127)
Total Investing
G:\Cfp\9901Plan\Ect\[schedule.xls]Investing
1998-11-05 14:08:49.080000
Spreadsheet: 772800d1647465647-conditional-formatting-wont-highlight-rows-arielr-sample
Sheet: Goal Sample

% Completed |  |  | Goal | Started | Finished | Days to Completion | Completed? | Completed Link | # [NAME] | Total
 |  |  | INSERT BELOW
 |  |  | Test | 2022-03-02 00:00:00 |  |  |  | False
 |  |  | Test | 2022-03-01 00:00:00 | 2022-03-12 00:00:00 |  |  | True
 |  |  | Test | 2022-02-05 00:00:00 | 2022-03-06 00:00:00 |  |  | True
 |  |  | Test | 2022-01-18 00:00:00 | 2022-02-07 00:00:00 |  |  | True
 |  |  | Test | 2021-11-07 00:00:00 |  |  |  | True
 |  |  | Test | 2021-11-03 00:00:00 | 2021-11-15 00:00:00 |  |  | True
 |  |  | Test | 2021-10-14 00:00:00 |  |  |  | False
 |  |  | Test | 2021-09-30 00:00:00 | 2021-10-03 00:00:00 |  |  | True
 |  |  | Test | 2021-09-16 00:00:00 | 2021-09-25 00:00:00 |  |  | True
 |  |  | Test | 2021-09-08 00:00:00 | 2021-11-13 00:00:00 |  |  | True
 |  |  | Test | 2021-08-14 00:00:00 | 2021-08-30 00:00:00 |  |  | True
 |  |  | Test | 2021-07-23 00:00:00 | 2021-08-05 00:00:00 |  |  | True
 |  |  | Test | 2021-07-04 00:00:00 |  |  |  | False
 |  |  | Test | 2021-06-16 00:00:00 | 2021-06-17 00:00:00 |  |  | True
 |  |  | Test | 2021-06-13 00:00:00 | 2021-07-08 00:00:00 |  |  | True
 |  |  | Test | 2021-06-02 00:00:00 | 2021-06-22 00:00:00 |  |  | True
 |  |  | Test | 2021-05-28 00:00:00 | 2021-06-23 00:00:00 |  |  | True
 |  |  | Test | 2021-05-01 00:00:00 | 2021-05-06 00:00:00 |  |  | True
 |  |  | Test | 2021-04-25 00:00:00 | 2021-05-01 00:00:00 |  |  | True
 |  |  | Test | 2021-03-25 00:00:00 | 2021-04-18 00:00:00 |  |  | True
 |  |  | Test | 2021-03-16 00:00:00 | 2021-03-21 00:00:00 |  |  | True
 |  |  | Test | 2021-03-12 00:00:00 | 2021-05-27 00:00:00 |  |  | True
 |  |  | Test | 2021-02-27 00:00:00 | 2021-03-30 00:00:00 |  |  | True
 |  |  | Test | 2021-02-06 00:00:00 | 2021-02-07 00:00:00 |  |  | True
 |  |  | Test | 2021-01-31 00:00:00 | 2021-02-14 00:00:00 |  |  | True
Spreadsheet: 131829d1323348508-how-to-copy-information-from-non-consecutive-lines-into-consecutive-lines-example-v2
Sheet: Result from dilipandey's code

Customer A | 100
Customer A | 200
Customer A | 0
Customer B | 50
Customer B | 300
Customer B | 0
Customer C | 20
Customer C | 50
Customer C | 100
Customer D | 90
Customer D | 90
Customer E | 100
Customer E | 20
Customer E | 50
Customer E | 20
Spreadsheet: 170044d1343145831-looking-to-get-rows-in-order-top-8-then-alphabetical-copycopy
Sheet: Sat-14-07-12

sold | 530
 | 20 |  | 22 |  | 30
 | 12 |  | 27 |  | 32
 |  |  | 41 |  | 55
Totals
 | 4 |  | 3 |  | 5
 | 6 |  | 0 |  | 0
 | 13 |  | 7 |  | 9
 | 5 |  | 1 |  | 1
 | 2 |  | 1 |  | 2
 | 0 |  | 1 |  | 2
 | 0 |  | 0 |  | 0
 | 4 |  | 1 |  | 1
 | 6 |  | 1 |  | 2
 | 1 |  | 0 |  | 0
 | 1 |  | 0 |  | 0
Totals
 | 22
 | 0
 | 2 |  | 0 |  | 0
 | 1 |  | 0 |  | 0
 | 1 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
Page Totals
 | 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 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
Page Totals
 | 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 |  | 0
 | 0 |  | 0 |  | 0
Page Totals
Other Grand Totals