tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5d5a8c9c-17dc-4d3e-96f7-2d28ff1d86dd
Sheet: Sheet1

 |  | TRAFFIC REGULATION FACT SHEET
Regulation
Number |  | Action/Restriction/Location
61037 | Remove: | Speed Limit Thirty Five Miles Per Hour: North Gower Drive from Northwest 64th
 |  | Street to Northwest Waukomis Drive
61043 | Install: | Speed Limit 40 Miles Per Hour: North Gower Drive, from Northwest 64th Street to
 |  | Northwest Waukomis Drive
 | Reason: | Traffic Study and new roadway geometrics and width warrant change
 |  | in speed limit
61038 | Remove: | One Way Street: Northbound, McGee Street, from 6th Street to Truman Road
61044 | Install: | One Way Street: Northbound, McGee Street, from 6th Street to 7th Street/
 |  | Admiral Boulevard
 | Reason: | Two way conversion project
61039 | Remove: | Two Hour Parking 7:00 AM to 6:00 PM Monday through Saturday: Wornall Road,
 |  | east side, from a point 114 feet north of 47th Street then north 150 feet
61048 | Install: | Two Hour Parking 7:00 AM to 6:00 PM Monday through Saturday: Wornall Road,
 |  | east side, from a point 165 feet north of 47th Street then north 100 feet
61050 | Install: | No Parking Loading Zone: Wornall Road, east side, from a point 115 feet north of
 |  | 47th Street then north 50 feet
 | Reason: | Highwoods Properties requested a loading zone at 4639 Wornall Road
61046 | Install: | No Parking Anytime: Walnut Street, east side, from a point 175 feet south of
 |  | 12th Street then south 36 feet
61047 | Install: | Two Hour Parking 9:00 AM to 4:00 PM Monday through Friday: Walnut Street,
 |  | east side, from a point 211 feet south of 12th Street then south 186 feet
61049 | Install: | No Parking Loading Zone 6:00 PM to 7:00 AM: Walnut Street, east side, from a
 |  | point 211 feet south of 12th Street then south 114 feet
 | Reason: | Cosentino's Market requested a loading zone
61040 | Remove: | Handicapped Parking: 32nd Street, north side, from a point 346 feet west of
 |  | Indiana Avenue then west 25 feet
 | Reason: | Resident at 3218 E. 32nd Street has relocated
61041 | Remove: | Traffic Signal: McGee Street and 13th Street
 | Reason: | Non MUTCD Compliance
61042 | Remove: | Traffic Signal: McGee Street and 14th Street
 | Reason: | Non MUTCD Compliance
61045 | Install: | No Parking Anytime: Indiana Avenue, west side, from 39th Street south 145 feet
 | Reason: | Property owner requested this restriction
Spreadsheet: john_griffith__15671__05_11_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 425 | 34.5 | 35.5
N01-P/C | 435 | 63 | 65
Q01-P/C | 440 | 83 | 86
U01-P/C | 445 | 100 | 103
V01-P/C | 445 | 116 | 118
X01-P/C | 465 | 134 | 137
[NAME]-P/C | 480 | 153 | 154.5
F02-P/C | 485 | 168 | 172
G02-P/C | 475 | 172 | 177
H02-P/C | 455 | 158 | 163
J02-P/C | 425 | 116 | 126
K02-P/C | 415 | 110 | 120
M02-P/C | 420 | 113 | 123
U02-P/C | 425
Spreadsheet: 0c1f4102-6b35-44f4-852b-428f6e0a9765
Sheet: CSRM300SAL

CLASS SIZE REDUCTION - M-300 SALARY
 | POS | POS | $ | POS | $ | POS | $
AT-RISK KINDERGARTEN:
# POSITIONS/SALARIES
AVG STARTING SALARY
1ST GRADE @ 16 TO 1
# PUPILS
# POSITIONS @ 25.5
# POSITIONS @ 16.0
# REQUIRED
NEW FY POSITIONS/SALARIES
TOTAL POSITIONS/SALARIES
2ND GRADE @ 16 TO 1
# PUPILS
# POSITIONS @ 25.7
# POSITIONS @ 16.0
# REQUIRED
NEW FY POSITIONS/SALARIES
TOTAL POSITIONS/SALARIES
3RD GRADE @ 19 TO 1
# PUPILS
# POSITIONS @ 26.9
# POSITIONS @ 19.0
# REQUIRED
NEW FY POSITIONS/SALARIES
TOTAL POSITIONS/SALARIES
TOTAL POSITIONS AND SALARIES
PERS Rate Change (23.75%-21.5%*.50)
TOTAL SALARIES LESS PERS RATE CHANGE
FRINGE BENEFITS
[NAME]
WORKER'S COMP
UNEMP INS
MEDICARE
MEDICAL INS
OTHER
 | TOTAL SALARIES AND FRINGE
BENEFIT/SALARY RATIO
 |  |  | NET |  |  | NET
SUMMARY | M200 | M300 | DIFF | M200 | M300 | DIFF
SALARIES
[NAME]
WORKER'S COMP
UNEMP INS
MEDICARE
MEDICAL INS
OTHER
Spreadsheet: 727207d1617773082-text-to-columns-change-general-to-numbers-not-working-test-text-to-columns
Sheet: Sheet2

 | Symbol | Trade Date | Trade Type | Quantity
 | GODREJCP | 2020-03-06 | sell | 20 | 20
 | PIDILITIND | 2020-03-06 | sell | 20 | 20 |  |  |  |  | 1.the figures shown in col E .
 | SRF | 2020-03-06 | buy | 5 | 5 |  |  |  |  | 2.they are shown as general. Left aligned. Assumes it is text.
 | INFY | 2020-03-06 | buy | 10 | 10 |  |  |  |  | 3. I selected all the contents in col E. pressed data-text to columns. But nothing has happened.
 | JUBLFOOD | 2020-03-06 | buy | 5 | 5 |  |  |  |  | [NAME] want to format all the contents in col E as numbers. What to do?
 | NIITTECH | 2020-03-06 | buy | 5 | 5
 | GENUSPAPER | 2020-03-06 | buy | 200 | 200
 | GENUSPAPER | 2020-03-06 | buy | 200 | 200
 | BAJFINANCE | 2020-03-06 | buy | 2 | 2
 | BATAINDIA | 2020-03-06 | buy | 5 | 5
 | ASTRAL | 2020-03-06 | buy | 1 | 1
 | ASTRAL | 2020-03-06 | buy | 3 | 3
 | GENUSPAPER | 2020-03-13 | buy | 200 | 200
 | NLCINDIA | 2020-03-13 | buy | 10 | 10
 | JKPAPER | 2020-03-13 | buy | 3 | 3
 | JAGRAN | 2020-03-13 | buy | 20 | 20
 | GENUSPAPER | 2020-03-13 | buy | 9 | 9
Spreadsheet: eric_saibi__9692__122101R
Sheet: Lacygne 01

Owner Name |  | Kansas City Power and Light
Station Name |  | Lacygne Power Station
Unit Name |  | Lacygne 01
NERC Region |  | SPP
State |  | KS
Fuel Type |  | Coal
Capacity |  | 893 MW
Start Date |  | 2001-11-04 00:00:00
End Date |  | 2001-12-26 00:00:00
Prv. Start Date |  | 2001-11-04 00:00:00
Prv. End Date |  | 2001-12-20 00:00:00
Comments |  | Having problems bringing it back on-line; should have it on-line right after the holidays.
SIC |  | 4911
Plant ID |  | 1014955
Unit ID |  | 1006085
Outage ID |  | 18542
Spreadsheet: vkaminski__40853__ModelingProject
Sheet: GBM 

 | GBM Model
 | Input Parameters
 | S0 | 100
 | s | 0.3
 | Dt |  | (hourly)
 | m | 0.05
 | dS = (r-d)Sdt + sSdz
 | St = St-1 * exp[(m-0.5s2)Dt + (se(Dt)0.5)]
 | Time | e | Return | St
 | 0 |  |  | 100
Spreadsheet: 125798d1319219057-track-rental-availability-master-template
Sheet: DATA

UNIT | STATUS | COMP2 | TYPE
1 | Available | [NAME] | 8" x 40" [NAME]
 | On-Location | Bellatrix | 400 BBL Tank
 |  | Harvest
 |  | Petrobakken
 |  | Skywest
 |  | Quattro
 |  | Nu-Vista
 |  | PennWest
Spreadsheet: tracy_geaccone__40401__GPM 101021  101073 Recalculation
Sheet: Mar 2001

KN Processing |  | GPM Agency Agreement |  |  | Prepared by [NAME]
Bushton Plant |  | TFDV Volume & Dollar Calculation
 |  | For
 |  | 2001-03-01 00:00:00
Contract #101021 |  |  | NNG Numbers |  |  | Oneok Numbers |  |  | Difference
 | Total Deliveries |  |  | 4432724 |  |  | 3479050
 |  | Deliveries to Inlet | 4240963 |  |  | 3337210
 |  | Deliveries to PVR
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 4421920 |  |  | 3479649
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
Contract #101073
 | Total Deliveries |  |  | 973747 |  |  | 1330289
 |  | Deliveries to Inlet | 0
 |  | Deliveries to PVR | 930564 |  |  | 1273566
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 998325 |  |  | 1319413
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
 |  | Total Both Contracts
 |  | Index |  | 5.088
 |  | Total Revenue Due
Total Revenue Billed |  | 101021 |  | 41741.61
 |  | 101073
 |  |  |  |  |  |  | 45596.23
 |  | Amount Due NNG (GPM)
Charge given by NNG on prior reconciliation
 |  | Amount Due NNG (GPM)
Spreadsheet: 112648d1308700501-index-match-multiple-criteria-multiple-sheets-index-match-multiple-criteria-multiple-sheets2
Sheet: Compare

 | Row# | ID | Phasing Data | Patt | S1/CL | S2/CL | S3/CL | S4/CL | S5/CL | S6/CL | S7/CL | S8/CL
 |  | 1 | MinGreen | AM
 |  | 2 | AllRed | MD
 |  | 3 | Yellow | PM
 |  | 4 | Walk | PO
 |  | 5 | DontWalk | WA
Spreadsheet: 543381d1508360253-dropdown-box-printing-tool
Sheet: Lookups

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
Spreadsheet: 235185d1368402051-help-merging-two-tables-book1
Sheet: Sheet1

Location | Funds | Item Code | Abrievated Descripton
New York | 964514 | 64609 | [NAME]
Cairo | 962815 | 32096 | JPMC
Istanbul | 918972 | 75725 | BACH
Istanbul | 891598 | 32096 | JPMC
Kyoto | 885163 | 38800 | BYOKF
Cairo | 841572 | 38800 | BYOKF
Tokyo | 800242 | 12730 | HSBC
Rome | 788344 | 72769 | BACP
London | 777137 | 64609 | [NAME]
Xi'an | 776375 | 59987 | BKEA
Beijing | 730819 | 28954 | DB
Istanbul | 716150 | 75748 | BAC
London | 683717 | 28954 | DB
Istanbul | 665690 | 28954 | DB
Kyoto | 584675 | 59987 | BKEA
Kyoto | 532414 | 28954 | DB
Rome | 465684 | 12730 | HSBC
Tokyo | 410101 | 32096 | JPMC
Kyoto | 388173 | 64502 | CG
Istanbul | 387248 | 63791 | BKQN
Rome | 372860 | 28954 | DB
New York | 372049 | 12730 | HSBC
[NAME] | 369584 | 64609 | [NAME]
Baghdad | 281152 | 12730 | HSBC
Tokyo | 277527 | 28954 | DB
Kyoto | 180425 | 94231 | FENB
New York | 147870 | 59987 | BKEA
Tokyo | 126717 | 94231 | FENB
Spreadsheet: 167641d1342046157-how-is-grand-total-of-an-average-column-calculated-in-a-pivot-table-pt-total-average-marvinp-oeldere-
Sheet: Sheet1

Name | Amt
[NAME] | 5
[NAME] | 6 |  | Rijlabels | Average of Amt
[NAME] | 7 |  | [NAME] | 8
[NAME] | 9 |  | [NAME] | 9
[NAME] | 9 |  | Eindtotaal | 8.4 | <<This is the average of all the Amts
[NAME] | 8
[NAME] | 9
Spreadsheet: 172987d1344402838-automatically-display-filtered-data-on-other-sheets-based-on-the-first-sheet-fruitextract
Sheet: Data

Index | First Name | Surname | Age | State | Fruit
1 | [NAME] | Smith | 18 | ACT | Apples
1 | [NAME] | Evans | 25 | NSW | Pears
1 | [NAME] | Clifford | 43 | QLD | Oranges
1 | [NAME] | Lean | 24 | QLD | Lemons
1 | Kylie | [NAME] | 56 | SA | Grapes
1 | [NAME] | Kennet | 12 | VIC | Bananas
2 | [NAME] | [NAME] | 34 | WA | Apples
2 | [NAME] | [NAME] | 52 | WA | Pears
2 | [NAME] | [NAME] | 27 | NT | Oranges
3 | Julie | [NAME] | 65 | NT | Apples
3 | Jeremy | [NAME] | 41 | WA | Pears
Spreadsheet: 830745d1685072884-calculate-time-in-excel-pacecalcuator_v2
Sheet: Table 1 (3)

 |  | 2400 | 400 | 10000 | 21097.5 | 42195 | 1000 | 400
No. | Name | 2.4K | 400m | 10K | half-Marathan | Marathon | Marathon Per Km | Marathon  400 m
Original | [NAME] | 00:08:49.978000 | 01:28.3 | 00:41:06.029000 | 01:27:12.989000 | 02:59:54.038000
1 | [NAME] | 00:08:50
2 | [NAME] | 00:10:16.032000 |  |  |  |  |  |  |  | 400 m/h
3 | TSANG KIM CHOI [NAME] | 00:10:58.022000 |  |  |  |  |  |  |  | 10 k/h
4 | [NAME] MEI Anna |  |  |  |  |  |  |  |  | 21.0975 km | Half-Marathon
5 | LEUNG Racheal |  |  |  |  |  |  |  |  | 42.195 km/h | Maraathon
6 | [NAME] | 00:12:34.013000 |  |  |  |  |  |  |  | Reference : | https://en.run-motion.com/average-speed-calculator-pace/
7 | CHEUNG SHU LUN Joe | 00:12:36 |  |  |  |  |  |  |  |  | [NAME] time into Ｍinute in Excel,.multiple by 1440
8 | KWAN Kenny | 00:12:36 |  |  |  |  |  |  |  |  | [NAME] time into Second in Excel,.multiple by 86401
9 | LAM SHEK KAI Steve | 00:12:37.037000
10 | FOK LOK SANG Wilson | 00:13:09.005000 |  |  |  |  |  |  |  | Pace | time/distance
11 | HO SIU TAO | 00:13:45.034000 |  |  |  |  |  |  |  | Running time | pace*distance
12 | [NAME] | 00:13:49.008000
13 | JIANG Cidney | 00:13:56.006000
14 | [NAME] HUNG Wilson | 00:14:04.042000
15 | LAU KA KI Daniel | 00:14:24
16 | CHAN CHI HO | 00:14:36.010000
17 | CHEUNG PAK LUN Dickson | 00:14:39.984000
18 | LAM [NAME] | 00:15:00.029000
19 | [NAME] | 00:15:00.979000
20 | WONG LUNG Emily | 00:15:02.016000
21 | CHEUNG PUI HANG Amber | 00:15:12.989000
22 | LAW WANG CHAK Waltery | 00:15:12.989000
23 | LI [NAME] | 00:15:47.030000
24 | CHAN Ivy | 00:15:56.966000
25 | WAN NGAN TING Bonita | 00:16:03.014000
26 | YOUNG [NAME] [NAME] | 00:16:06.989000
27 | TSOI YUK Helen | 00:16:08.026000
28 | LAM TZE HING | 00:16:13.037000
29 | [NAME] | 00:16:17.011000
30 | CHOY KIT YEE Catherine | 00:16:18.998000
31 | HUNG SHUI HUNG | 00:16:45.005000
32 | TSANG WAN LING Winnie | 00:17:09.024000
33 | CHEUNG HOI YIN Jenny | 00:17:56.026000
34 | [NAME] KEUNG | 00:18:10.022000
35 | WONG LAM FAI Phillip | 00:18:57.024000
36 | HO SUK CHING Helen | 00:19:51.974000
37 | [NAME] | 00:20:00.010000
38 | KU MAN KIT | 00:20:36.038000
39 | HUANG YU SUEN Samuel | 00:21:34.963000
40 | HO KWAI MUI | 00:21:49.997000
41 | CHEUNG CHI WAN Doris | 00:22:10.992000
42 | CHENG LAI KUEN Alice | 00:25:39.994000
43 | KONG [NAME] | 00:26:04.013000
44 | MAU CHI TING Jenna
45 | TSOI MAN [NAME]
Spreadsheet: 114888d1310570782-sumproduct-sump-for-forum
Sheet: example

this page demonstrates what I need to do but obviously this is not a sensible way to approach the task. Currently the formula looks at col a abd b but does not accont for multiple instances as in col c
 |  |  |  | What I need is a formula which gives me the sum of … see k5:K19
Cancellation Date | Number Of Days | Count of [NAME] |  | Dates
2009-12-01 00:00:00 | 1 | 1 |  | 2009-12-01 00:00:00 | 1
2009-12-02 00:00:00 | 7 | 1 |  | 2009-12-02 00:00:00 |  | 1 | 2 | 1 | 2
2009-12-02 00:00:00 | 7 | 2 |  | 2009-12-03 00:00:00 |  | 1 | 2 | 1 | 2
2009-12-02 00:00:00 | 13 | 1 |  | 2009-12-04 00:00:00 |  | 1 | 2 | 1 | 2
2009-12-02 00:00:00 | 8 | 2 |  | 2009-12-05 00:00:00 |  | 1 | 2 | 1 | 2
2009-12-02 00:00:00 | 7 | 1 |  | 2009-12-06 00:00:00 |  | 1 | 2 | 1 | 2
2009-12-02 00:00:00 | 2 | 1 |  | 2009-12-07 00:00:00 |  | 1 | 2 | 1 | 2
2009-12-03 00:00:00 | 1 | 1 |  | 2009-12-08 00:00:00 |  | 1 | 2 | 1 | 2
2009-12-03 00:00:00 | 2 | 3 |  | 2009-12-09 00:00:00 |  |  |  | 1 | 2
2009-12-04 00:00:00 | 10 | 1 |  | 2009-12-10 00:00:00 |  |  |  | 1
2009-12-04 00:00:00 | 7 | 1 |  | 2009-12-11 00:00:00 |  |  |  | 1
2009-12-04 00:00:00 | 7 | 1 |  | 2009-12-12 00:00:00 |  |  |  | 1
2009-12-04 00:00:00 | 4 | 1 |  | 2009-12-13 00:00:00 |  |  |  | 1
2009-12-04 00:00:00 | 4 | 1 |  | 2009-12-14 00:00:00 |  |  |  | 1
2009-12-05 00:00:00 | 7 | 1 |  | 2009-12-15 00:00:00
2009-12-06 00:00:00 | 2 | 1 |  | 2009-12-16 00:00:00
2009-12-06 00:00:00 | 14 | 1 |  | 2009-12-17 00:00:00
2009-12-06 00:00:00 | 7 | 1 |  | 2009-12-18 00:00:00
2009-12-08 00:00:00 | 5 | 1 |  | 2009-12-19 00:00:00
2009-12-08 00:00:00 | 5 | 1 |  | 2009-12-20 00:00:00
2009-12-08 00:00:00 | 10 | 1 |  | 2009-12-21 00:00:00
2009-12-08 00:00:00 | 21 | 1 |  | 2009-12-22 00:00:00
2009-12-13 00:00:00 | 2 | 1 |  | 2009-12-23 00:00:00
2009-12-14 00:00:00 | 7 | 1 |  | 2009-12-24 00:00:00
2009-12-14 00:00:00 | 7 | 1 |  | 2009-12-25 00:00:00
 |  |  |  | 2009-12-26 00:00:00
 |  |  |  |  | 2009-12-01 00:00:00 | 2009-12-02 00:00:00 | 2009-12-02 00:00:00 | 2009-12-02 00:00:00 | 2009-12-02 00:00:00 | 2009-12-02 00:00:00 | 2009-12-02 00:00:00 | 2009-12-03 00:00:00 | 2009-12-03 00:00:00 | 2009-12-04 00:00:00 | 2009-12-04 00:00:00 | 2009-12-04 00:00:00 | 2009-12-04 00:00:00 | 2009-12-04 00:00:00 | 2009-12-05 00:00:00 | 2009-12-06 00:00:00 | 2009-12-06 00:00:00 | 2009-12-06 00:00:00 | 2009-12-08 00:00:00 | 2009-12-08 00:00:00 | 2009-12-08 00:00:00 | 2009-12-08 00:00:00 | 2009-12-13 00:00:00 | 2009-12-14 00:00:00 | 2009-12-14 00:00:00
Spreadsheet: 02de5b7c-fb79-4784-b63c-b3409b1aa0e1
Sheet: EPR 1X PQY 

Third Quarter Ended June 30, 2012
 |  |  |  | Continuing Operations
 | Cost of  Interactive | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
GAAP measures | 20.5 | 207.1 | 95.5 | 46.89999999999999 | 0.16
% of revenue |  | 0.3887012012012012 | 0.1792417417417417
Acquisition-related charges: (b)
Contingent retention & earn-out | 0 | -26 | 26 | 16.6 | 0.06
Amortization of intangibles | -1.7 | -4.7 | 6.4 | 4.1 | 0.01
Professional fees | 0 | -0.1 | 0.1 | 0.1 | 0
Severance | 0 | -1.3 | 1.3 | 0.8 | 0
Total non-GAAP adjustments | -1.7 | -32.1 | 33.8 | 21.6 | 0.06999999999999999
Adjusted measures | 18.8 | 175 | 129.3 | 68.49999999999999 | 0.23
% of revenue |  | 0.3284534534534534 | 0.2426801801801802
Nine Months Ended June 30, 2012
 |  |  |  | Continuing Operations
 | Cost of  Interactive | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
GAAP measures | 42.5 | 554.6999999999999 | 313.4999999999998 | 159.5999999999998 | 0.54
% of revenue |  | 0.36503027112398 | 0.2063042906027901
Acquisition-related charges: (b)
Contingent retention & earn-out | 0 | -37.8 | 37.8 | 24.2 | 0.08
Amortization of intangibles | -4 | -8.6 | 12.6 | 8.100000000000001 | 0.03
Professional fees | 0 | -5.8 | 5.8 | 3.7 | 0.01
Distributor settlement | 0 | -3.1 | 3.1 | 2 | 0.01
Severance | 0 | -2.5 | 2.5 | 1.6 | 0
Total non-GAAP adjustments | -4 | -57.8 | 61.8 | 39.6 | 0.13
Adjusted measures | 38.5 | 496.8999999999999 | 375.2999999999998 | 199.1999999999998 | 0.67
% of revenue |  | 0.326993945775204 | 0.2469728876020004
(a) Adjustments tax effected at 36%
(b) Primarily related to DoubleDown
Spreadsheet: 156994d1337591384-find-value-and-count-how-many-times-after-every-nth-row-value-appears-test_clarification
Sheet: Sheet1

 |  |  | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220
150 | 1 | 100 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
150 | 2 | 150 | 0 | 0 | 0 | 1 | 0 | 1 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0
110 | 3 | 70 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 2 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
120 | 4 | 110 | 0 | 0 | 3 | 2 | 2 | 2 | 2 | 2 | 0 | 1 | 3 | 1 | 0 | 0 | 1 | 0 | 0 | 0
150 | 5 | 90 | 0 | 0 | 3 | 0 | 1 | 1 | 3 | 0 | 3 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
190 | 6 | 110 | 1 | 0 | 4 | 2 | 2 | 4 | 3 | 3 | 0 | 1 | 3 | 1 | 0 | 1 | 1 | 0 | 0 | 0
80 | 7 | 70 | 0 | 0 | 2 | 1 | 2 | 3 | 3 | 3 | 4 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0
100 | 8 | 140 | 0 | 0 | 4 | 2 | 4 | 1 | 5 | 0 | 2 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
50 | 9 | 110 | 1 | 0 | 5 | 4 | 2 | 6 | 3 | 3 | 2 | 1 | 4 | 1 | 0 | 1 | 1 | 0 | 0 | 0
130 | 10 | 90 | 0 | 0 | 4 | 1 | 1 | 3 | 5 | 1 | 3 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0
130 |  |  | 0
70 |  |  | 0
120 |  |  | 0
90 |  |  | 0
160
130
130
70
130
120
110
80
160
100
120
120
180
80
100
80
130
140
160
140
80
130
90
110
140
70
110
90
110
70
150
100
Spreadsheet: gerald_nemec__11542__KernscheduleA
Sheet: Sheet1

 |  |  | Schedule "A"
 |  | Enron Corp Limited Guarantee
 |  | Limited Liablility Amount
 |  | Package 1 | Package 2 | Total Liability
Company
Hunt Oil Co. of Canada |  | x | 800000 | 800000
Petro-Canada |  | x | 800000 | 800000
Patina |  | 450000 | 800000
JM Huber |  | 450000 | 800000
Cannon |  | 450000 | 800000
FM Steel |  | 450000 | 800000
[NAME] |  | 450000 | 800000
ENA |  | 450000 | 800000
Notes to Legal | [NAME], Enron is providing the guarantee to each of these parties seperatly and up to the $ amount as stated above.
 | The $ amount as calculated represents the demand charge, multiplied by the term multiplied by the allocated capacity.
 | In the event that the term, tariff of volume changes so too will our guarantee need to be adjusted.
 | Proper names to be verified.
BT
Spreadsheet: 0b106858-f810-4a98-959f-8ed217704ea5
Sheet: Income&Expense Summary

INCOME / EXPENSE SUMMARY
INCOME SUMMARY
Gross Monthly Income From All Sources
Mandatory Deductions
Gross Monthly Income Less Mandatory Deductions
Voluntary Deductions
Net Monthly Income
EXPENSE SUMMARY
Necessities that I pay for myself
Necessities that I pay for the other party
Expenses that I pay for my child(ren) (of this relationship)
Mandatory support (child & spousal) to the Other Party
Mandatory support of others (including children NOT of this relationship)
Total Necessities for which I pay
Discretionary Expenses that I pay for myself
Discretionary Expenses that I pay for the other party
Discretionary support of others
Total Discretionary Expenses that I pay for
Total Expenses that I pay for
INCOME / EXPENSE SUMMARY
Monthly Deficit / Surplus
If you have a monthly deficit, provide an explanation below of how your meet that deficit each month:
Spreadsheet: 119620d1314624379-call-in-multiple-entries-from-master-sheet-copy-of-example
Sheet: Master-Database

Company/Lot | COMPANY | UNITS | PACKAGING |  | PKG TYPE | BRAND | LOT | A | B | C | D | E | F | G
A_1 | A | 10 |  |  |  |  | 1
A_2 | A | 20 |  |  |  |  | 2
B_1 | B | 30 |  |  |  |  | 1
B_2 | B | 40 |  |  |  |  | 2
B_3 | B | 50 |  |  |  |  | 3
C_1 | C | 60 |  |  |  |  | 1
C_2 | C | 70 |  |  |  |  | 2
D_1 | D | 80 |  |  |  |  | 1
D_2 | D | 90 |  |  |  |  | 2
Spreadsheet: 678519d1589931578-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example
Sheet: 16 March 20 - 21 March 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-03-16 00:00:00 | 2020-03-17 00:00:00 | 2020-03-18 00:00:00 | 2020-03-19 00:00:00 | 2020-03-20 00:00:00 | 2020-03-21 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 16/03/2020 - 21/03/2020
Dameon | ✓ | ✓ | ✓ | AWAY | ✓ |  |  |  |  | Dameon | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ❌
[NAME] | AWAY | ✓ | AWAY | ✓ | ✓ |  |  |  |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | AWAY |  |  |  |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | ❌ |  |  |  |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | AWAY | AWAY |  |  |  |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
Nathan | ✓ | ✓ | AWAY | ✓ | ✓ |  |  |  |  | Nathan | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ❌ |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ❌
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Tyson | ✓
Will | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | ✓ | ✓ | ✓ | ✓ | [NAME] |  |  |  |  |  | ❌
 | ✓ | AWAY | AWAY | AWAY | AWAY |  |  |  |  |  | ✓
 | ✓ | ✓ | ✓ | ✓ | ❌ |  |  |  |  |  | ❌
Edge Protection [NAME] |  |  | 16/03/2020 - 21/03/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 16/03/2020 - 21/03/2020
8 Cable Street |  |  | ❌ |  |  |  |  |  |  | Dameon | ✓
Northlink |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
Canterbury Linen Services |  |  | ❌ |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Nathan | ✓
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | ✓
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌