tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 56994d1257181395-sorting-data-and-referring-to-the-labels-sorting1
Sheet: Sheet1

 | Item 1 | 1 org row | Item 2 | 2 org row | Item 3 | 3 org row | Item 4 | 4 org row | Item 5 | 5 org row
Feature 1 | 10 | 6 | 15 | 18 | 131 | 14 | 36 | 20 | 183 | 20
Feature 2 | 26 | 5 | 22 | 11 | 136 | 6 | 51 | 18 | 216 | 6
Feature 3 | 37 | 18 | 62 | 19 | 223 | 20 | 81 | 4 | 282 | 10
Feature 4 | 81 | 9 | 86 | 14 | 327 | 15 | 246 | 2 | 308 | 12
Feature 5 | 160 | 4 | 184 | 3 | 527 | 7 | 409 | 19 | 465 | 14
Feature 6 | 382 | 19 | 364 | 6 | 548 | 2 | 429 | 7 | 617 | 17
Feature 7 | 580 | 16 | 441 | 16 | 551 | 5 | 443 | 16 | 715 | 7
Feature 8 | 732 | 8 | 446 | 4 | 560 | 1 | 465 | 3 | 748 | 18
Feature 9 | 883 | 20 | 702 | 9 | 630 | 18 | 532 | 12 | 903 | 2
Feature 10 | 1060 | 2 | 762 | 17 | 696 | 9 | 533 | 1 | 936 | 5
Feature 11 | 1135 | 1 | 933 | 15 | 794 | 13 | 814 | 5 | 957 | 1
Feature 12 | 1171 | 17 | 981 | 12 | 866 | 3 | 842 | 6 | 1007 | 9
Feature 13 | 1256 | 3 | 984 | 20 | 972 | 12 | 844 | 10 | 1196 | 19
Feature 14 | 1326 | 12 | 1076 | 8 | 1006 | 11 | 1399 | 9 | 1230 | 16
Feature 15 | 1439 | 14 | 1171 | 2 | 1217 | 4 | 1427 | 15 | 1302 | 13
Feature 16 | 1504 | 13 | 1176 | 5 | 1303 | 19 | 1558 | 17 | 1477 | 15
Feature 17 | 1628 | 11 | 1284 | 10 | 1451 | 10 | 1597 | 13 | 1619 | 8
Feature 18 | 1811 | 15 | 1466 | 13 | 1697 | 8 | 1623 | 11 | 1620 | 11
Feature 19 | 1949 | 7 | 1823 | 7 | 1878 | 17 | 1744 | 8 | 1659 | 3
Feature 20 | 1959 | 10 | 1855 | 1 | 1902 | 16 | 1943 | 14 | 1989 | 4
Spreadsheet: rick_buy__32711__0806 summary of issues
Sheet: summary 0716

SUMMARY BY WEEK FOR  06/11-06/15
TOTAL ISSUES
Category |  | Description
A |  | Deal Capture
B |  | Deal Valuation
C |  | Breakdown in Officializing Process- Human |  |  |  |  |  |  |  | 9
D1 |  | Breakdown in Officializing Process- IT (UK) |  |  |  |  |  |  |  | 5
D2 |  | Breakdown in Officializing Process- IT (US)
E |  | Curve Issues
F |  | Uncontrollable-System Needs to Change
G |  | Miscellaneous |  |  |  |  |  |  |  | 1
H |  | Not identified |  |  |  |  |  |  |  | 1
Breakdown By Group |  |  |  |  |  |  |  | # of Issues |  | Biggest Problem
EIM
EGM |  |  |  |  |  |  |  | 1
EEL |  |  |  |  |  |  |  | 5
EA-CAN
EA - GAS |  |  |  |  |  |  |  | 3 |  | Book not officialized and attribute mismatch prevented data capture for other books.
EA - POWER |  |  |  |  |  |  |  | 1 |  | Book not officialized
EES |  |  |  |  |  |  |  | 2 |  | Credit MTM file not submitted
EBS
Other |  |  |  |  |  |  |  | 3 |  | Ennovate book not officialized and attribute mismatch
TOTAL ISSUES
Spreadsheet: phillip_platter__31426__SCH estate
Sheet: SP15

SP15
CounterParty | Total | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500 | 1600 | 1700 | 1800 | 1900 | 2000 | 2100 | 2200 | 2300 | 2400
PX - Purchase
PX - Sale
CA Imbalance - Purchase (Decrease Load) |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CA Imbalance - Sale (Increase Load) |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Generation
Generation
Generation
Generation
Generation
Generation
Generation
Generation
Generation
Generation
EES2 LOAD(SELL MORE TO EES)
EES LOAD(SELL TO EES)
EES Buy FROM EES (+)
STCA to RT
West Services to realtime
Additional Sale EES @ 46$ fixed price
West Services to realtime
Load9
Load10
MEGA
PNM
SC Customer4
SC Customer5
SC Customer6
Daily Trades
Line Losses
IDACORPENE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
west services |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EESI |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24.5 | 24.5 | 24.5 | 24.5 | 24.5 | 24.5 | 24.5 | 24.5 | 24.5 | 24.5 | 24.5 | 24.5 | 0 | 0 | 0
EDISONMISM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PGET |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Reliant |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other SP15 Trade |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other SP15 Trade |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total SP15
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
Spreadsheet: 119038d1314161273-lookup-function-question-lookup-workbook
Sheet: Sheet1

 | 2011-05-01 00:00:00 |  | 2011-06-01 00:00:00 |  | 2011-07-01 00:00:00 |  | 2011-08-01 00:00:00 |  | 2011-09-01 00:00:00 |  |  | 2011-07-01 00:00:00
 | Fcst | Act | Fcst | Act | Fcst | Act | Fcst | Act | Fcst | Act |  | Fcst | Act
A | 5 | 4 | 3 | 4 | 2 | 3 | 8 | 7 | 7
B | 4 | 4 | 2 | 3 | 4 | 5 | 6 | 7 | 5
C | 3 | 5 | 1 | 1 | 6 | 6 | 4 | 5 | 9
Spreadsheet: 808092d1670282859-filtered-data-error-excel-help-6
Sheet: Tim

 | Name | Position | State | Clinic | Hiring Manager | Entity | Employment Type | Start Date
 | [NAME] | MR | SA | PRA | [NAME] | 1 | Casual | 2022-09-12 00:00:00
 | [NAME] | MR | SA | PRA | [NAME] | 1 | PPT | 2022-10-14 00:00:00
 | [NAME] | MR | SA | PRA | [NAME] | 1 | PFT | 2022-09-19 00:00:00
 | Mathias Friedman | MR | SA | PRA | [NAME] | 1 | Fixed Casual | 2022-06-02 00:00:00
 | [NAME] | MR | SA | PRA | [NAME] | 1 | Casual | 2022-09-12 00:00:00
 | [NAME] | MR | SA | PRA | [NAME] | 1 | PFT | 2022-08-29 00:00:00
 | [NAME] | MR | SA | PRA | [NAME] | 1 | Fixed Casual | 2022-09-19 00:00:00
Spreadsheet: 190295d1351609678-how-could-i-set-this-spreadsheet-up-example
Sheet: Sheet1

Natural Habitat m² | Mounds/m² | Mounds/m² | Mixture of Soil/Rock/Plant = p  Plant Vegetation = t | [NAME] | Mounds | Mounds/m² | [NAME] = p  Fescue Grass = t   Formal Landscaping= n
 | 5 |  | t |  |  |  | p
 |  |  | p |  |  |  | t
 |  |  | t |  |  |  | n
 |  |  | t |  |  |  | p
 |  |  | t |  |  |  | t
 |  |  | t |  |  |  | n
 |  |  | t |  |  |  | p
 | 2 |  | t |  |  |  | t
 |  |  | t |  |  |  | n
 |  |  | t |  |  |  | p
 |  |  | t |  |  |  | t
 |  |  | t |  |  |  | n
 |  |  | t |  |  |  | p
 | 5 |  | t |  |  |  | t
 |  |  | t |  |  |  | n
 |  |  | p |  |  |  | p
 |  |  | p |  |  |  | t
 |  |  | t |  |  |  | n
 |  |  | t |  |  |  | p
Spreadsheet: 802676d1666967203-copy-information-from-multiple-tables-to-a-sheet-bwp-invoices
Sheet: Table 9

 |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  | Invoice #
 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-10-25 00:00:00 |  |  |  | 80041
 | [NAME] |  |  |  |  |  |  |  |  | Ship To
 | BW Papersystems Company P.O. Box 4717 [EMAIL] Timonium, MD 21094-4717 |  |  |  |  |  |  |  |  | BW Papersystems Co. 10615 Beaver Dam Road Hunt Valley, MD 21030-2204
P.O. Number |  |  | Terms |  | Rep |  | Ship |  | Via |  | F.O.B. |  |  | Project
P420825 |  |  | 2%10NET45 |  | HOUSE |  | 2022-10-25 00:00:00 |  | UPS |  | Richmond, VA
Quantity |  | Item Code |  | Description |  |  |  |  |  |  |  | Price Each |  |  |  | Amount
2 2 |  | 88426 30MATERIAL |  | ADJUSTING FLEXIBLE ROD 10 FT LONG MOD 33 & 335 Material Surcharge |  |  |  |  |  |  |  | 150.00 30.00 |  |  |  | 300.00 60.00
 |  |  |  |  |  |  |  |  |  |  |  | Total                              $360.00
Payments/Credits                 $0.00 |  |  |  |  |  |  |  | Balance Due |  |  |  |  |  |  | 360
Spreadsheet: 7ba54eab-c6aa-4fe7-bcfd-55a736be2c7e
Sheet: Sheet1

INSTITUTO DAS COMUNICAÇÕES DE PORTUGAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | STATEMENT OF PROFTIS AND LOSSES AS PER FUNCTION
 | FOR THE FISCAL YEAR ENDING ON DECEMBER 31ST 2000
 | (sums expressed in PTE 1,000 and Euros 1,000) |  |  | )
 |  |  | 2000
 |  |  | PTE 1,000 |  | Euros 1,000
OPERATING ACTIVITIES
 | Sales and services provisions |  | 11677445 |  | 58247
 | Cost of sales and services provisions |  | -4357230 |  | -21734
 | Gross Results |  | 7320215 |  | 36513
 | Other operating incomes and earnings |  | 79007 |  | 394
 | Distribution Costs |  |  |  | 0
 | Administrative Costs |  | -1131001 |  | -5641
 | Other operating costs and losses |  | -875373 |  | -4366
 | Operating Results |  | 5392848 |  | 26900
 | Net Financing Cost |  | 408265 |  | 2036
 | Earnings (losses) in subsidiaries |  |  |  | 0
 | Earnings (losses) in other investments |  |  |  | 0
 | Current Results |  | 5801113 |  | 28936
 | Taxes on current results |  |  |  | 0
 | Current Results after taxes |  | 5801113 |  | 28936
 | [NAME] |  | 87507 |  | 436
 | Taxes on extraordinary results |  |  |  | 0
 | Net Results |  | 5888620 |  | 29372
Spreadsheet: jeff_dasovich__14105__Response to 10-12 Workshop Questions
Sheet: Q7

QUESTION 7
Q. How much of Line 401 costs are phased into on-system rates during each year of the
Gas Accord?
A. As included in the Gas Accord Settlement Agreement.
Gas [NAME] 401 Phase-In
To On-System Redwood Path Rates
 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 |  | Units
On-System Phase-In | 200 | 250 | 300 | 325 | 350 | 375 |  | MMcf/d
Percent Phase-In |  |  |  |  |  |  |  | %
Remaining Capacity |  |  |  |  |  |  |  | MMcf/d
Line 401 Cost of Service |  |  |  |  |  |  |  | $ Million
Costs Phased-In |  |  |  |  |  |  |  | $ Million
Remaining Costs |  |  |  |  |  |  |  | $ Million
Line 401 Firm Capacity in MMcf/d    = |  |  | 813
Spreadsheet: 831335d1685553825-need-help-with-counting-cells-for-time-sheet-test-time-sheet
Sheet: Sheet1

 |  | DATE: |  |  |  |  |  |  |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTES:
 |  | A shift week one |  |  |  |  |  |  |  |  |  |  | A shift week two
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | these two collums add week one and week two ST and OT cells
 | Name | M | T | W | T | F | S | S | Total Hrs. | ST | OT |  | M | T | W | T | F | S | S | Total Hrs. | ST | OT | total ST | total OT | DT | Hol | Vac | Berv
 | Bell, Fraa | 16 | 12 | 12 | 11 |  |  |  |  |  |  |  | 12 | 12 | 12 | 12 |  |  |  |  | 0 | 0
 |  | 12 | 12 | 12 | 12 |  |  |  |  | 40 | 8 |  | 0 | 0 | 12 | 12 |  |  | 12 |  | 24 | 12
 | Bell, Fraa | 14 | 12 | 12 | 11 |  | 12 |  |  |  |  |  | 0 | 12 | 12 | 16 |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | This collum  I need to add M-T any number over 12 and F-S |  |  |  |  |  |  |  |  |  |  | This collum  I need to add M-T any number over 12 and F-S
 |  |  |  |  |  | this adds total hrs for the week
 |  |  |  |  |  |  |  |  |  | This collum I need to add up to 40 hours M-T |  |  |  |  |  |  |  |  |  |  | This collum I need to add up to 40 hours M-T
 |  |  |  |  |  |  |  | cells ST should add M-T 12 hrs only a day to 40 and stops
 |  |  |  |  |  |  |  | then cell OT adds M-T anything over 12 plus any hours F-S
 |  |  |  |  |  |  |  | I have no idea how to make ST and OT collum work???
Spreadsheet: 683330d1592643972-convert-text-to-time-not-as-simple-as-it-sounds-mock-sample-data
Sheet: Sheet3

BEFORE
ANALYSTS | 06/01/2020 | 07/01/2020 | 08/01/2020 | 09/01/2020 | 10/01/2020
[NAME] | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm
[NAME]
[NAME] | 7:30am-4:00pm | 7:30am-4:00pm | 7:30am-4:00pm | 7:30am-4:00pm | 7:30am-4:00pm
[NAME] | TRAINING | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm
[NAME] | SICK | SICK | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm
[NAME] | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm
AFTER
ANALYSTS | 06/01/2020 | 07/01/2020 | 08/01/2020 | 09/01/2020 | 10/01/2020
[NAME] | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm
START | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
FINISH | 16:30:00 | 16:30:00 | 16:30:00 | 16:30:00 | 16:30:00
[NAME]
START | NO DATA | NO DATA | NO DATA | NO DATA | NO DATA
FINISH | NO DATA | NO DATA | NO DATA | NO DATA | NO DATA
[NAME] | 7:30am-4:00pm | 7:30am-4:00pm | 7:30am-4:00pm | 7:30am-4:00pm | 7:30am-4:00pm
START | 07:30:00 | 07:30:00 | 07:30:00 | 07:30:00 | 07:30:00
FINISH | 16:00:00 | 16:00:00 | 16:00:00 | 16:00:00 | 16:00:00
[NAME] | TRAINING | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm
START | TRAINING | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
FINISH | TRAINING | 16:30:00 | 16:30:00 | 16:30:00 | 16:30:00
[NAME] | SICK | SICK | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm
START | SICK | SICK | 08:00:00 | 08:00:00 | 08:00:00
FINISH | SICK | SICK | 16:30:00 | 16:30:00 | 16:30:00
[NAME] | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm | 8:00am-4:30pm
START | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
FINISH | 16:30:00 | 16:30:00 | 16:30:00 | 16:30:00 | 16:30:00
Spreadsheet: 191264d1352023208-finding-repeating-multiple-characters-from-a-string-in-cell-book1
Sheet: Sheet1

NESVJIQURFYQWGKRZVGIDCATRKVJVTPXZEXGNEJWJCUMUYIXXUMFEBLPZHPLOLEUFOFBLTTGCLBLZCTPUQWNUVFIQXDSEBEQRRGNEZBMDYCBIKIWENFTMWDGRZKWWLETIRBLPSAEVCTSOSNZVHEUWPISEEOTDFVXTTUPLAPJKVFEQJSKFPIOSEZOFRBSCZOEIQRVGFUVZXSKDFGIVEARFFNXSKYPLVKAKOQCMNFJGFAIVCOQVVHMYYTBCTIONINJMPQONIZAWEADZYQWOUOSSIVCKDBXIMYYTFMMVJUNFRAWFXEEYQQZLSFMMVLRHPLZWZLPFININZSPCQXFJEIZAWAKCURKPPYWFIMSYNITEWWPNITJVYQLBPOWRENEURJPPNEUFWOLMOPUXMYIHTFIWEUDFMMPZVTIVNMYKSTVIROYAHRKMEEOGYQWXONEYMTTIKFUCTENEEFKYXKNURVHMKCBDMEMYOSSMHTTMFUQXLZIPEELTIHTFWRMKCBDMQLZESZIPTFEEZVXSKSIRXIZLANFVSWUGVVBLPCOSKPCUASUZKIHGSPEMSQZHPJMYYXETVZZPJMFEELZZHJESQZXEFRAMWEAMFCHENAOKWLTSSFCNPPZUTGZSNKEENQXSSEUYWHSKSBZLRZSEUYWHYULPXQGYULPXQGYUSVTKIDYTIVVXLQIOXBLPJODLUIYZHFIIRENRPLOLTZFSFUFPMIOEQRRZOFELATZHPLBYYJESJBEYJIOXQXTTTIVTILYTUYMHZIUNVVXNUNURQRPJAILVHCKDMZVIDCHJTPAPXEEZDMOKDJEBSSGLGRLSKKNQRZERXAQYALFSSBZLXSKJVUOILLTFIIPTZTMVZIQREDKQSYZOUIGIGKRZGIVLMRBGPSYKAGKMVENEPKPICCOVCLFPZOMFAIAXEDZWYDZINVIROHEPWVSFYEJYIHMKTUVZWPREDKWRPUFUYMWPVASROVLVHTRVHEGKFKPIZTEXYQGSOSMZSIWETPGZSGKTIVUSDZIOKMVPYTJEO
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
Spreadsheet: 708987d1608119956-finding-highest-value-across-sheets-book1-1-
Sheet: Wk3

 |  |  |  |  |  |  |  |  |  |  |  | Value | Date
 |  |  |  |  |  |  |  |  |  |  | Day total
 |  |  |  |  |  |  |  |  |  |  | Week total
 | 2020-11-22 00:00:00 |  |  |  |  |  |  |  |  | 968
 | 2020-11-16 00:00:00 |  |  |  |  |  |  |  |  | 627
 | 2020-11-19 00:00:00 |  |  |  |  |  |  |  |  | 333
 | 2020-11-18 00:00:00 |  |  |  |  |  |  |  |  | 556
 | 2020-11-17 00:00:00 |  |  |  |  |  |  |  |  | 1200
 | 2020-11-18 00:00:00 |  |  |  |  |  |  |  |  | 383
 | 2020-11-17 00:00:00 |  |  |  |  |  |  |  |  | 577
 | 2020-11-22 00:00:00 |  |  |  |  |  |  |  |  | 465
 | 2020-11-17 00:00:00 |  |  |  |  |  |  |  |  | 244
 | 2020-11-21 00:00:00 |  |  |  |  |  |  |  |  | 487
 | 2020-11-21 00:00:00 |  |  |  |  |  |  |  |  | 643
 | 2020-11-16 00:00:00 |  |  |  |  |  |  |  |  | 222
 | 2020-11-19 00:00:00 |  |  |  |  |  |  |  |  | 1780
 | 2020-11-22 00:00:00 |  |  |  |  |  |  |  |  | 160
 | 2020-11-16 00:00:00 |  |  |  |  |  |  |  |  | 422
 | 2020-11-16 00:00:00 |  |  |  |  |  |  |  |  | 460
 | 2020-11-19 00:00:00 |  |  |  |  |  |  |  |  | 56
 | 2020-11-21 00:00:00 |  |  |  |  |  |  |  |  | 339
 | 2020-11-19 00:00:00 |  |  |  |  |  |  |  |  | 25
 | 2020-11-18 00:00:00 |  |  |  |  |  |  |  |  | 626
 | 2020-11-19 00:00:00 |  |  |  |  |  |  |  |  | 530
 | 2020-11-16 00:00:00 |  |  |  |  |  |  |  |  | 451
 | 2020-11-21 00:00:00 |  |  |  |  |  |  |  |  | 718
 | 2020-11-16 00:00:00 |  |  |  |  |  |  |  |  | 461
 | 2020-11-16 00:00:00 |  |  |  |  |  |  |  |  | 693
 | 2020-11-21 00:00:00 |  |  |  |  |  |  |  |  | 434
 | 2020-11-22 00:00:00 |  |  |  |  |  |  |  |  | 1600
 | 2020-11-16 00:00:00 |  |  |  |  |  |  |  |  | 335
 | 2020-11-17 00:00:00 |  |  |  |  |  |  |  |  | 277
 | 2020-11-20 00:00:00 |  |  |  |  |  |  |  |  | 465
Spreadsheet: 370d4c5b-1c71-4c2c-bdca-04d3aeb20ae9
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688614829 | Downhere | Downhere | 2001-10-03 | Compact Disc | Ac Pop | 11.99 | N | To Be Retired
Word Records | 80688625429 | Downhere | So Much For Substitutes | 2003-05-24 | Compact Disc | Ac Pop | 16.99 | N | To Be Retired
Spreadsheet: 836218d1689177514-need-a-functio-to-do-matching-process-and-return-the-corresponding-reason-book5
Sheet: Sheet1

 |  |  |  | List A |  | List B |  | List C
 |  |  |  | Name | Reason | Name |  | Name | Reason
 |  |  |  | Name 1 | A1 | Name 3 |  | Name 5
 |  |  |  | Name 2 | A3 | Name 2 |  | Name 3 | A3
 |  |  |  | Name 3 | A3 | Name 6 |  | Name 6 | A2
 |  |  |  | Name 4 | A4 | Name 12 |  | Name 20
 |  |  |  | Name 5 | A5 | Name 25 |  | Name 25 | A1
 |  |  |  | Name 6 | A2 |  |  | Name 30
 |  |  |  | Name 7 | A2
 |  |  |  | Name 8 | A6
 |  |  |  | Name 9 | A6
 |  |  |  | Name 10 | A8
 |  |  |  | Name 25 | A1
 |  |  |  | I have three lists; List A (name and [NAME]), List B (Name) and [NAME] (Name). I need a function to match each name in List C with names of the list A and B and return the corresponding rason in List A if it is matched and blank if it is not matched.
Spreadsheet: 874118d1720683571-filter-by-one-value-then-display-as-a-grouped-list-excel-help-2-filters-and-date-range
Sheet: Sheet1

Date | Status | Stage | Ticket |  | OUTPUT
2024-01-01 00:00:00 | Done | Project | hdfhsdjfs
2024-01-08 00:00:00 | In Progess | Bug | sfsdlfjdslkfsjdlk |  | 2025-01-01 00:00:00 | 2024-03-01 00:00:00
2024-01-08 00:00:00 | Done | Bug | sdjflsjfdlks
2024-02-01 00:00:00 | Done | Feature | sdfsdfhsdjfkhsdl |  | 2024-01-01 00:00:00 | Done | Project | hdfhsdjfs
2024-02-28 00:00:00 | In Progess | Feature | sdfjskdoiuew |  | 2024-03-01 00:00:00 | Done | Project | sdfhddhf
2024-03-01 00:00:00 | Done | Project | sdfhddhf
2024-03-14 00:00:00 | Done | Project | [NAME] |  | 2024-01-08 00:00:00 | Done | Bug | sdjflsjfdlks
2024-07-11 00:00:00 | Done | Feature | weeuroiwehd
2024-07-18 00:00:00 | In Progess | Bug | DASASD |  | 2024-02-01 00:00:00 | Done | Feature | sdfsdfhsdjfkhsdl
 |  |  |  |  | Hi
 |  |  |  |  | I need to extract rows based on done, then group by project type and sort by date, oldest to newest
Spreadsheet: 457260d1461272272-convert-listing-into-calendar-and-fills-specified-colours-calendar-apr-20
Sheet: Sheet1

 | JANUARY |  |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  |  | [NAME]
 | Su | Mo | [NAME] | We | Th | Fr | Sa |  | Su | Mo | [NAME] | We | Th | Fr | Sa |  | Su | Mo | [NAME] | We | Th | Fr | Sa
 | APRIL |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  | [NAME]
 | Su | Mo | [NAME] | We | Th | Fr | Sa |  | Su | Mo | [NAME] | We | Th | Fr | Sa |  | Su | Mo | [NAME] | We | Th | Fr | Sa
 | JULY |  |  |  |  |  |  |  | AUGUST |  |  |  |  |  |  |  | SEPTEMBER
 | Su | Mo | [NAME] | We | Th | Fr | Sa |  | Su | Mo | [NAME] | We | Th | Fr | Sa |  | Su | Mo | [NAME] | We | Th | Fr | Sa
 | OCTOBER |  |  |  |  |  |  |  | NOVEMBER |  |  |  |  |  |  |  | DECEMBER
 | Su | Mo | [NAME] | We | Th | Fr | Sa |  | Su | Mo | [NAME] | We | Th | Fr | Sa |  | Su | Mo | [NAME] | We | Th | Fr | Sa
Spreadsheet: benjamin_rogers__1227__UAE with 2 LM's & debt structure 04-21-00
Sheet: IS

INCOME STATEMENT
('000 $)
 |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 | 2023-12-31 00:00:00 | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 2026-12-31 00:00:00 | 2027-12-31 00:00:00 | 2028-12-31 00:00:00 | 2029-12-31 00:00:00 | 2030-12-31 00:00:00 | 2031-12-31 00:00:00
Revenue
Capacity Revenue
Energy Revenue
Ancillary Services |  | 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
Total Revenue
Expense
Fuel
Fixed Operating Expenses
Variable Operating Expenses
Major [NAME]
Insurance
SG&A
Start Charge
Property Tax
Franchise Tax
[NAME] |  | 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
Debt Service Reserve [NAME]
Marketing Fee
Administrative Fee
O&M Fees
Total Expense
Total Expense w/o Energy Exp.
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
Pretax Book Income
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Net Income
Spreadsheet: 219081d1362663759-trying-to-create-a-match-value-on-increments-related-to-data-example
Sheet: Creative

DFA_CREATIVE_ID | MESSAGE_NAME | SIZE
123451 | INDICES | 300x250
123452 | INDICES | 300x600
123453 | INDICES | 160x600
123454 | INDICES | 728x90
123455 | INDICES | 468x120
123456 | INSIGHT | 300x250
123457 | INSIGHT | 300x600
123458 | INSIGHT | 160x600
123459 | INSIGHT | 728x90
123460 | INSIGHT | 468x120
123461 | HERITAGE | 300x250
123462 | HERITAGE | 300x600
123463 | HERITAGE | 160x600
123464 | HERITAGE | 728x90
123465 | HERITAGE | 468x120
Spreadsheet: 703690d1605115013-extract-data-from-a-table-and-plot-graph-excel-help-1
Sheet: Sheet1

Test Readings
Category | Date | Time | Type | Reading | Notes |  |  | Fasting | PP1 | PP2 | PP3
Fasting | 2020-11-08 00:00:00 | 06:45:00 | FBS | 139 |  |  | 2020-11-08 00:00:00 | 139 | 239 | 103 | 231
PP1 | 2020-11-08 00:00:00 | 11:45:00 | PPBS | 239 |  |  | 2020-11-09 00:00:00 | 129 | 203 | 146 | 224
PP2 | 2020-11-08 00:00:00 | 15:30:00 | PPBS | 103 |  |  | 2020-11-10 00:00:00 | 133 | 157 | 178 | 193
PP3 | 2020-11-08 00:00:00 | 22:15:00 | PPBS | 231 |  |  | 2020-11-11 00:00:00 | 164 | 174 | 167 | 185
Fasting | 2020-11-09 00:00:00 | 05:30:00 | FBS | 129
PP1 | 2020-11-09 00:00:00 | 10:45:00 | PPBS | 203
PP2 | 2020-11-09 00:00:00 | 15:45:00 | PPBS | 146 |  |  | [NAME] to get above data
PP3 | 2020-11-09 00:00:00 | 22:30:00 | PPBS | 224 |  |  |  | Fasting | PP1 | PP2 | PP3
Fasting | 2020-11-10 00:00:00 | 05:30:00 | FBS | 133 |  |  | 2020-11-08 00:00:00
PP1 | 2020-11-10 00:00:00 | 11:10:00 | PPBS | 157 |  |  | 2020-11-09 00:00:00
PP2 | 2020-11-10 00:00:00 | 15:30:00 | PPBS | 178 |  |  | 2020-11-10 00:00:00
PP3 | 2020-11-10 00:00:00 | 22:20:00 | PPBS | 193 |  |  | 2020-11-11 00:00:00
Fasting | 2020-11-11 00:00:00 | 06:45:00 | FBS | 164
PP1 | 2020-11-11 00:00:00 | 11:30:00 | PPBS | 174
PP2 | 2020-11-11 00:00:00 | 15:45:00 | PPBS | 167
PP3 | 2020-11-10 00:00:00 | 22:20:00 | PPBS | 185