tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 62548d1263476772-filtering-data-excel-example
Sheet: Sheet1

Case No | Adjusted Case Name | Owner name | Amount
171398 | Dianthus | Harriet | 2544442065
169583 | Dianthus | [NAME] | 1814014469.52
169583 | Dianthus | Becky | 1539032278.04
169615 | Dianthus | Becky | 1285979834.24
171398 | Dianthus | Yvette | 1078571393
171398 | Dianthus | Yvette | 889807703
171398 | Dianthus | Yvette | 315000000
169590 | Dianthus | Yvette | 271700032
171160 | Lily | Harriet | 187000000
171216 | Dianthus | Harriet | 161296240.22
171216 | Dianthus | George | 74682158.51
171216 | Dianthus | George | 60698084.36
169591 | Dianthus | Yvette | 50335102.53
171398 | Dianthus | Yvette | 48675000
169615 | Dianthus | Harriet | 44763923.58
164663 | Hyacinth | George | 41532639.51
164620 | Jasmine | George | 34227480.98
171217 | Dianthus | Harriet | 33687228.42
43998 | Mantle | George | 33330989.43
169564 | Dianthus | Harriet | 30508319.96
171485 | Dianthus | Yvette | 28970000
169583 | Dianthus | Harriet | 22873394.26
166109 | Bellflower | George | 22317836.12
169601 | Celandine | Harriet | 21549431.09
171160 | Lily | Ricky | 20829329.49
169588 | Dianthus | Harriet | 20265301.01
Spreadsheet: 853427d1703275191-conditional-formatting-and-protected-locked-cells-not-working-test-workbook
Sheet: NY

Unit # | Tenant | Voucher | Rent Increase Date | Notice Serve Date | 90 Days Prior | Actual Served Date |  | Rent Increase | Current Rent | Rent Increase Amount | Proposed Rent | Blend
 | [NAME] | No | 2023-12-01 00:00:00 |  |  |  |  | 0.1 | 750
 | [NAME] | No | 2025-03-01 00:00:00 |  |  |  |  | 0.1 | 790
 | George | Yes | 2025-02-01 00:00:00 |  |  |  |  | 0.1 | 880
 | Ringo | No | 2024-03-04 00:00:00 |  |  |  |  | 0.075 | 800
 | Ringo | No | 2024-01-01 00:00:00 |  |  |  |  | 0.07 | 801
 | Ringo | No | 2024-01-01 00:00:00 |  |  |  |  | 0.07 | 802
Spreadsheet: 811260d1672387174-sumif-formula-lookup-two-dimensions-and-sumif-based-on-date-range-example-movers
Sheet: Sheet1

RAW DATA | Date of Sale | SKU | Colour | Units Sold |  | WEEK OUTPUT NEEDED |  |  | SKU | Colour | Units Sold
 | 2022-01-01 00:00:00 | SKU030 |  | 5 |  | 2022-01-03 00:00:00 | 2022-01-09 00:00:00 |  | SKU030 | Red
 | 2022-01-02 00:00:00 | SKU019 |  | 6 |  |  |  |  | SKU019 | White | 19
 | 2022-01-03 00:00:00 | SKU042 |  | 9 |  |  |  |  | SKU042 | Black | 13
 | 2022-01-04 00:00:00 | SKU035 |  | 3 |  |  |  |  | SKU035 | Black | 5
 | 2022-01-05 00:00:00 | SKU036 |  | 2 |  |  |  |  | SKU036 | Black | 2
 | 2022-01-06 00:00:00 | SKU030 |  | 1
 | 2022-01-07 00:00:00 | SKU019 |  | 19
 | 2022-01-08 00:00:00 | SKU042 |  | 4
 | 2022-01-09 00:00:00 | SKU035 |  | 2
 | 2022-01-10 00:00:00 | SKU036 |  | 0
 | 2022-01-11 00:00:00 | SKU030 |  | 2
 | 2022-01-12 00:00:00 | SKU019 |  | 1
 | 2022-01-13 00:00:00 | SKU042 |  | 4
 | 2022-01-14 00:00:00 | SKU035 |  | 5
 | 2022-01-15 00:00:00 | SKU036 |  | 6
Spreadsheet: 218858d1362594983-help-using-offset-function-working-hours
Sheet: WEEKLY HOURS

NAME
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16
Tech 1
Tech 2
Tech 3
Tech 4
Tech 5
Tech 6
Tech 7
Tech 8
Tech 9
Tech 10
Tech 11
Tech 12
Tech 13
Tech 14
Tech 15
Tech 16
Tech 17
Tech 18
Tech 19
Tech 20
Tech 21
Tech 22
Tech 23
Tech 24
Tech 25
Tech 26
Spreadsheet: 790157d1659553732-im-calculating-days-open-in-excel-but-44776-pops-up-when-cell-is-empty-maintanace-tickets
Sheet: Issue Log

Maintanance Tickets
 |  |  |  | Date
# | Issue | Priority | Type of Issue | Open | Close | Days open | Submitted By | Currently Worked on by | Comments
1 |  |  |  | 2022-04-22 00:00:00
2 |  |  |  | 2022-04-23 00:00:00
3 |  |  |  | 2022-04-24 00:00:00
4 |  |  |  | 2022-04-25 00:00:00
5 |  |  |  | 2022-04-26 00:00:00
6 |  |  |  | 2022-04-27 00:00:00
7 |  |  |  | 2022-04-28 00:00:00
8 |  |  |  | 2022-04-29 00:00:00
9 |  |  |  | 2022-04-30 00:00:00
10 |  |  |  | 2022-05-01 00:00:00
11 |  |  |  | 2022-05-02 00:00:00
12 |  |  |  | 2022-05-03 00:00:00
13 |  |  |  | 2022-05-04 00:00:00
14 |  |  |  | 2022-05-05 00:00:00
15 |  |  |  | 2022-05-06 00:00:00
16 |  |  |  | 2022-05-07 00:00:00
17 |  |  |  | 2022-05-08 00:00:00
18 |  |  |  | 2022-05-09 00:00:00
19 |  |  |  | 2022-05-10 00:00:00
20 |  |  |  | 2022-05-11 00:00:00
21 |  |  |  | 2022-05-12 00:00:00
22 |  |  |  | 2022-05-13 00:00:00
23 |  |  |  | 2022-05-14 00:00:00
24 |  |  |  | 2022-05-15 00:00:00
25 |  |  |  | 2022-05-16 00:00:00
26 |  |  |  | 2022-05-17 00:00:00
27 |  |  |  | 2022-05-18 00:00:00
28 |  |  |  | 2022-05-19 00:00:00
29 |  |  |  | 2022-05-20 00:00:00
30 |  |  |  | 2022-05-21 00:00:00
31 |  |  |  | 2022-05-22 00:00:00
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
Spreadsheet: 41098d1239609331-guidance-in-analysing-a-database-indiadata
Sheet: Sheet2

 | 4 to 5 | 49
 | 5 to 7 | 40
 | 7 to 10 | 48
 | >10000 | 33
 | upto 4000 | 29
 |  |  |  | 3115
 |  |  |  |  |  |  |  |  |  | 0.68
 |  |  |  |  |  |  |  |  |  | 0.47
 |  |  |  |  |  |  |  |  |  | 0.56 |  |  |  |  | 51.00000000000001
 |  |  |  |  |  |  |  |  |  | 0.36 |  |  |  |  | 35.25
 |  |  |  |  |  |  |  |  |  | 0.66 |  |  |  |  | 42.00000000000001
 |  |  |  |  |  |  |  | 71.25 |  |  |  |  |  |  | 27
 |  |  | 0.47 | 58.75 | 6.4625 |  |  |  |  |  |  |  |  |  | 49.5
 |  |  | 0.06 | 7.5 | 1.275 |  |  |  |  |  |  |  |  |  | 0
 |  |  | 0.1 | 12.5 | 7.5
 |  |  | 0.58 | 72.5 | 18.85
 |  |  | 0.98 | 122.5 | 44.1
 |  |  | 0.12 | 15 | 1.2
 |  |  |  |  |  | 0.05 | 6.25
 |  |  |  |  |  | 0.01 | 1.25
 |  |  |  |  |  | 0.06 | 7.5
 |  |  |  |  |  | 0.15 | 18.75
 |  |  |  |  |  | 0.35 | 43.75
 |  |  |  |  |  | 0.01 | 1.25
Spreadsheet: 858760d1707325552-help-sumif-multiple-tabs-example1
Sheet: Progress

 |  |  |  |  |  |  | January Group
 |  |  |  |  |  |  | February Group
 |  |  |  |  |  |  | March Group
 |  | Total List |  | Sum of all "individuals" from tab January +February+March, collums B
 |  | Total Done |  | sum of L4 from January,February and March Tabs
 |  | Total Done This Month |  | sum of totals done(in Jan, Feb and [NAME]) where date from Colum G equals to current month
 |  | Total Done Last month |  | sum of totals done(in Jan, Feb and [NAME]) where date from Colum G equals to previous  month
 |  | Total Outstanding
 |  | Progress YTD  % |  | progress in % ( Total List (D4) being 100% and Total Done (D6) being the current progress
 |  | Target Threshold % |  | not required
Spreadsheet: 702636d1604448592-formula-to-return-1s-if-there-is-a-data-value-in-a-range-return-1s-and-0s
Sheet: Sheet1

Sales ID | Firm | Date | Sales Associates | Sales Year | Return Results (Correct) | Return Results (wrong)
777777777 | 3Wala | 1999 | [NAME] |  | 1
777777777 | 3Wala | 1999 | Peo |  | 1
777777777 | 3Wala | 1999 | Wilo |  | 1
777777777 | 3Wala | 1999 | [NAME] |  | 1
777777777 | 3Wala | 1999 | Coker |  | 1
777777777 | 3Wala | 1999 | [NAME] |  | 1
777777777 | 3Wala | 1999 | [NAME] |  | 1
777777777 | 3Wala | 1999 | Jamia |  | 1
777777777 | 3Wala | 1999 | Campus |  | 1
777777777 | 3Wala | 1999 | Dina |  | 1
777777777 | 3Wala | 2000 | [NAME] |  | 0
777777777 | 3Wala | 2000 | Peo |  | 0
777777777 | 3Wala | 2000 | Janice |  | 0
777777777 | 3Wala | 2000 | Wilo |  | 0
777777777 | 3Wala | 2000 | [NAME] |  | 0
777777777 | 3Wala | 2000 | Coker |  | 0
777777777 | 3Wala | 2000 | [NAME] |  | 0
777777777 | 3Wala | 2000 | Jamia |  | 0
777777777 | 3Wala | 2000 | Dina |  | 0
777777777 | 3Wala | 2000 | Lang |  | 0
777777777 | 3Wala | 2001 | [NAME] |  | 1
777777777 | 3Wala | 2001 | [NAME] |  | 1
777777777 | 3Wala | 2001 | Ganio |  | 1
777777777 | 3Wala | 2001 | Dina |  | 1
777777777 | 3Wala | 2001 | Lang |  | 1
777777777 | 3Wala | 2001 | Clarios |  | 1
777777777 | 3Wala | 2001 | Redio |  | 1
777777777 | 3Wala | 2001 | Credo |  | 1
777777777 | 3Wala | 2002 | [NAME] |  | 0
777777777 | 3Wala | 2002 | Ganio |  | 0
777777777 | 3Wala | 2002 | Lang |  | 0
777777777 | 3Wala | 2002 | Clarios |  | 0
777777777 | 3Wala | 2002 | Redio |  | 0
777777777 | 3Wala | 2002 | Credo |  | 0
777777777 | 3Wala | 2003 | [NAME] |  | 0
777777777 | 3Wala | 2003 | Ganio |  | 0
777777777 | 3Wala | 2003 | Lang |  | 0
777777777 | 3Wala | 2003 | Clarios |  | 0
777777777 | 3Wala | 2003 | Redio |  | 0
887333444 | Forg | 1999 | Forg, [NAME] |  | 0
887333444 | Forg | 1999 | Kart, [NAME] |  | 0
887333444 | Forg | 1999 | Zoome, [NAME] |  | 0
887333444 | Forg | 1999 | [NAME], [NAME] |  | 0
887333444 | Forg | 1999 | [NAME], [NAME] |  | 0
887333444 | Forg | 1999 | Yogurt, [NAME] |  | 0
887333444 | Forg | 1999 | Bakdoor, [NAME] |  | 0
887333444 | Forg | 1999 | Corrie, [NAME] |  | 0
887333444 | Forg | 1999 | Camp, [NAME] |  | 0
887333444 | Forg | 1999 | Door, Trial J. |  | 0
887333444 | Forg | 2000 | Forg, [NAME] |  | 1
887333444 | Forg | 2000 | Kart, [NAME] |  | 1
887333444 | Forg | 2000 | [NAME], [NAME] |  | 1
887333444 | Forg | 2000 | Zoome, [NAME] |  | 1
887333444 | Forg | 2000 | [NAME], [NAME] |  | 1
887333444 | Forg | 2000 | [NAME], [NAME] |  | 1
887333444 | Forg | 2000 | Yogurt, [NAME] |  | 1
887333444 | Forg | 2000 | Corrie, [NAME] |  | 1
887333444 | Forg | 2000 | Door, Trial J. |  | 1
887333444 | Forg | 2000 | Long, [NAME] | 2000 | 1
Spreadsheet: 869045d1715708910-occurance-number-book1-tms
Sheet: Sheet1

London | 1
London | 2 |  | 2
Washington |  |  | 1
Paris |  |  | 1
Paris |  |  | 2
Lisbon |  |  | 1
London | 3 |  | 3
Madrid |  |  | 1
London | 4 |  | 4
 | Would like to get the sheet to populate the occurance number of the specific location. Example with London is the last entry is 4 as there are 4 entries.
Spreadsheet: 127964d1320704349-max-in-list-that-input-value-800211-max-in-list-compare-with-list
Sheet: Sheet1

# units desired | Shipments | Number of units in shipment
902 | 1 | 10 | TMS | 846
how many shipments will take: | 2 | 22
11 | 3 | 38 | TMS | 11
with how many til next shipment needed: | 4 | 61
130 | 5 | 95 | NBVC | 11
 | 6 | 147
 | 7 | 227 | DaveGugg | 11
 | 8 | 349
 | 9 | 499
 | 10 | 667
 | 11 | 846
 | 12 | 1032
 | 13 | 1225
 | 14 | 1425
 | 15 | 1632
 | 16 | 1846
 | 17 | 2067
 | 18 | 2295
 | 19 | 2531
 | 20 | 2775
 | 21 | 3027
 | 22 | 3287
 | 23 | 3555
 | 24 | 3831
 | 25 | 4115
 | 26 | 4407
 | 27 | 4707
 | 28 | 5015
 | 29 | 5332
 | 30 | 5658
Spreadsheet: defdc38c-c0ed-4010-bcc1-9bc158ce18a4
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7699 | 30433 | Henri | Schoeman | RSA | 2 | 00:17:52 | 00:00:49 | 01:11:37 | 00:00:35 | 00:33:22 | 1 | 02:04:18
7699 | 10966 | [NAME] | Felgate | ZIM | 1 | 00:19:31 | 00:00:44 | 01:11:15 | 00:00:36 | [NAME] | 2 | 02:08:04
7699 | 11871 | [NAME] | Naude | RSA | 3 | 00:19:31 | 00:00:41 | 01:11:18 | 00:00:35 | 00:37:58 | 3 | 02:10:05
7699 | 34722 | Aidan | Nugent | RSA | 4 | 00:21:22 | 00:00:56 | 01:17:10 | 00:00:38 | [NAME] | 4 | [NAME]
Spreadsheet: 761916d1641299321-creating-3-dependent-drop-down-lists-example-dependent-drop-down-lists
Sheet: Sheet1

Dependent drop-down lists
Category | Drop-down 1
Level | Drop-down 2 (options in this list dependent on option selected from drop-down 1)
Type of work | Drop-down 3 (options in this list depend on options selected in both drop-downs 1 & 2
Category | Level
Formulation | C
Intervention | D
 | E
 | Well Manager
Type of work
AD | BD | AC | BC | AE | BE | Well Manager Formulation | Well Manager Intervention
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
3 | 3 | 3 | 3 | 3 | 3
4 | 4 | 4 | 4 | 4 | 4
 | 5 | 5 | 5 | 5 | 5
 | 6 |  | 6
 | 7
 | 8
 | 9
Spreadsheet: 229769d1366566706-terribly-slow-excelsheet-dummyrapportage-20130322-clean
Sheet: LEF

[NAME] |  |  |  |  |  | Stand per |  |  |  |  | Rapportagedatum:
Speerpunten
[NAME] (speerpuntnr. programmabegroting) |  |  | Beleidsprodukt | [NAME] | Financieel | Planning | Risico's | Toelichting (alleen bij kruisje; duimpje of resultaten)
3.1 Woningen (kwantitatief en kwalitatief)
Woningbouw (3.1) |  |  | 311
3.2 Aantrekkelijke leefomgeving
Milieu en duurzaamheid (3.12) |  |  | 326
4.2 Interne dienstverlening
Vorming Omgevingsdienst De Vallei (onderdeel [NAME]) |  |  | 422
Overig
Richtlijnen duurzame stedebouw en duurzaam bouwen (dubo) beleid
Actualisering bestemmingsplan Buitengebied en (laatste) bestemmingsplannen [NAME]
Financieel (x € 1.000)
Beleidsproduct - product
 |  |  | [NAME]cijfers t/m maand |  |  | [NAME]
 |  |  | cijfers deze maand | Begroting  Primitief | Begroting bijgesteld  t/m vorige maand | Voorgestelde mutaties begroting B&W akkoord Incidenteel | Voorgestelde mutaties begroting B&W akkoord Structureel | Begroting na voorgestelde mutaties | Aanvullende afwijkingen / nog niet geaccordeerd | Toelichting / link naar collegevoorstel
112
Subtotaal 112
113
Subtotaal 113
122
Subtotaal 122
123
Subtotaal 123
131
Subtotaal 131
132
Subtotaal 132
311
Subtotaal 311
422
Subtotaal 422
 | Totaal
Indicatoren
Subprogr | BP | Omschrijving |  |  | Plan | Actuele waarde | Toelichting |  |  |  |  | Rapportage-moment
 |  | Toename woningvoorraad |  |  | 300 | [NAME]
n.v.t. (i.v.m. [NAME] afdelingsindicatoren
Informatie college aan raad
Actuele informatie
Subprogr | BP | Omschrijving
Toezeggingen en moties
Datum | BP | Afspraak/toezegging |  | Status (wijziging, nieuw, afgedaan of vervallen) |  |  |  | Toelichting
Planning MJRA
Nr. | BP | Omschrijving |  | Planning    PB2013 | Vorige planning | Actuele    planning | Toelichting (wijziging, nieuw of vervallen)
Bedrijfsvoering
Omschrijving |  |  | Resultaat of afwijking
Standaard
 | Ziekteverzuim
 | [NAME] (in FTE) en verwachte invuldatum
OddV
[NAME]
Projectmatig werken
Ziekteverzuim
Ontwikkeling personeel
Integrale dienstverlening
[NAME] (in FTE) en verwachte invuldatum
Spreadsheet: phillip_m_love__30155__9902_OA
Sheet: TX-HPL-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  HPL
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
 |  | Fuel Allocation:
 |  | Storage Book |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book
 |  | Texas Desk
 |  | Total
 |  | 3rd Party Commidity exp. to transport book
 |  | 3rd Party Demand exp. to transport book
 |  | Total
Spreadsheet: 175531d1345561650-averaging-wind-directions-daddy_wind
Sheet: Sheet2

Date | Average Wind Direction
2005-01-01 00:00:00
Spreadsheet: 4d66333a-8b81-461a-a50f-b343c3ad2713
Sheet: New Table 9

Weekly Barge Rates for Major Grain Shipping Points on the Mississippi, Ohio, and Arkansas Rivers
Table 9
Weekly Barge Freight Rates:  Southbound Only
 |  | Twin         Cities | Mid-Mississippi | Lower Illinois         River | St. Louis | Cincinnati | Lower         Ohio | Cairo-Memphis
Rate1 | 2014-03-04 00:00:00 | -- | --
 |  | -- | -- |  |  |  |  |  |  |  | -
$[NAME] |  | -- | --
 |  | -- | --
Current week % change from the same week:
 | Last year | -- | --
 | 3-year avg. 2 | -- | --
Rate1 | April
 | June
1Rate = percent of 1976 tariff benchmark index (1976 = 100 percent); 24-week moving average; ton = 2,000 pounds; No rates reported on Illinois River due to ice.
Source:  Transportation & Marketing Programs/AMS/USDA
 |  | TWC | MM | ILL | ST LOUIS |  | LOH | CAR-MEM
[NAME] |  | 6.19 | 5.32 | 4.64 | 3.99 | 4.69 | 4.04 | 3.14
Spreadsheet: 123148d1317378182-formula-for-summing-multipe-values-and-sorting-by-value-sample
Sheet: Sheet1

Data |  |  |  |  | Result
Customer No | Inv No | Inv Value |  |  | Customer  No | Total
1234 | 4654 | 100 |  |  | 6759 | 1600
2345 | 4564647 | 120 |  |  | 12344 | 1000
3456 | 41654647 | 170 |  |  | 45679 | 900
6759 | 46546554 | 500 |  |  | 3456 | 170
45679 | 45454 | 900 |  |  | 2345 | 120
12344 | 457876 | 250 |  |  | 1234 | 100
12344 | 41587657 | 750
6759 | 15749674 | 1100
Spreadsheet: 50a6c56e-8fe5-4fb3-b112-db7d3be36c5c
Sheet: Page 1

Permit No.: |  |  | WQ0015053 |  |  | Facility Name: |  | Moyock Commons |  |  |  |  |  | County: | Currituck |  | Month: |  |  | Year:
Did infiltration occur at this facility? |  |  |  |  |  | Site Name: |  | 01 |  | Site Name: |  | 02 |  | Site Name: |  |  |  | Site Name:
 |  |  |  |  |  | Area (acres): |  | 0.63 |  | Area (acres): |  | 0.63 |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Rate (GPD/ft2): |  | 1.25 |  | Rate (GPD/ft2): |  | 1.25 |  | Rate (GPD/ft2): |  |  |  | Rate (GPD/ft2):
Day | Weather |  |  | Freeboard |  | Site Infiltrated? |  |  |  | Site Infiltrated? |  |  |  | Site Infiltrated? |  |  |  | Site Infiltrated?
 | Weather Code | Temperature | Precipitation | Storage           (if applicable) | 5-Day Upset       (if applicable) | Volume Applied | Time   Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time    Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time   Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time    Infiltrated | Daily   Loading | [NAME] (Basins Only)
 |  | ºF | in | ft | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft
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
Monthly Loading (GPD/ft2):
Year to Date Loading (GPD/ft2):
Spreadsheet: 166ae41c-3b35-49bf-bb0b-4610dd26ce92
Sheet: Sheet1

Unnamed: 0 | Permit No.: | WQ0014565 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Pilgrim's Pride Sanford Facility | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | County: | Unnamed: 13 | [NAME] | Unnamed: 15 | Month: | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
 |  | Field Name: |  | 01 North |  | Field Name: |  | 01 South |  | Field Name: |  | 02 North |  | Field Name: |  | 02 South |  | Field Name: |  | 03 North
 |  | Area (acres): |  | 2.1 |  | Area (acres): |  | 2.3 |  | Area (acres): |  | 2.5 |  | Area (acres): |  | 2.3 |  | Area (acres): |  | 2.8
 |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN
 |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]?
 | Date | Volume Applied | Average PAN Concentration | Monthly PAN Load | Cumulative PAN Load | Volume Applied | Average PAN Concentration | Monthly PAN Load | Cumulative PAN Load | Volume Applied | Average PAN Concentration | Monthly PAN Load | Cumulative PAN Load | Volume Applied | Average PAN Concentration | Monthly PAN Load | Cumulative PAN Load | Volume Applied | Average PAN Concentration | Monthly PAN Load | Cumulative PAN Load
 | Month | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac
 | 12 Month Floating PAN Load (lbs/ac/yr):
 | Annual PAN Load Limit (lbs/ac/yr):
Spreadsheet: 852751d1702674264-grouping-columns-sample-bsb-
Sheet: Sheet1

January | January | January | January |  | February | February | February | February |  | March | March | March | March |  | April | April | April | April |  | May | May | May | May |  | June | June | June | June
Spreadsheet: 82816d1282830742-data-range-belonging-cartel1
Sheet: Foglio1

data | error | data_max | data_min |  | range_belonging |  |  | range_id | [NAME] | range_min
6000 | 50 | 6050 | 5950 |  | 1 |  |  | 1 | 6000 | 5900
5850 | 70 | 5920 | 5780 |  | 1;2 |  |  | 2 | 5900 | 5800
5720 | 100 | 5820 | 5620 |  | 1;2;3 |  |  | 3 | 5800 | 5700
4760 | 50 | 4810 | 4710 |  | 12;13 |  |  | 4 | 5700 | 5600
3200 | 20 | 3220 | 3180 |  | 28;29 |  |  | 5 | 5600 | 5500
2010 | 110 | 2120 | 1900 |  | 39;40;41 |  |  | 6 | 5500 | 5400
 |  |  |  |  |  |  |  | 7 | 5400 | 5300
 |  |  |  |  |  |  |  | 8 | 5300 | 5200
 |  |  |  |  |  |  |  | 9 | 5200 | 5100
 |  |  |  |  |  |  |  | 10 | 5100 | 5000
 |  |  |  |  |  |  |  | 11 | 5000 | 4900
 |  |  |  |  |  |  |  | 12 | 4900 | 4800
 |  |  |  |  |  |  |  | 13 | 4800 | 4700
 |  |  |  |  |  |  |  | 14 | 4700 | 4600
 |  |  |  |  |  |  |  | 15 | 4600 | 4500
 |  |  |  |  |  |  |  | 16 | 4500 | 4400
 |  |  |  |  |  |  |  | 17 | 4400 | 4300
 |  |  |  |  |  |  |  | 18 | 4300 | 4200
 |  |  |  |  |  |  |  | 19 | 4200 | 4100
 |  |  |  |  |  |  |  | 20 | 4100 | 4000
 |  |  |  |  |  |  |  | 21 | 4000 | 3900
 |  |  |  |  |  |  |  | 22 | 3900 | 3800
 |  |  |  |  |  |  |  | 23 | 3800 | 3700
 |  |  |  |  |  |  |  | 24 | 3700 | 3600
 |  |  |  |  |  |  |  | 25 | 3600 | 3500
 |  |  |  |  |  |  |  | 26 | 3500 | 3400
 |  |  |  |  |  |  |  | 27 | 3400 | 3300
 |  |  |  |  |  |  |  | 28 | 3300 | 3200
 |  |  |  |  |  |  |  | 29 | 3200 | 3100
 |  |  |  |  |  |  |  | 30 | 3100 | 3000
 |  |  |  |  |  |  |  | 31 | 3000 | 2900
 |  |  |  |  |  |  |  | 32 | 2900 | 2800
 |  |  |  |  |  |  |  | 33 | 2800 | 2700
 |  |  |  |  |  |  |  | 34 | 2700 | 2600
 |  |  |  |  |  |  |  | 35 | 2600 | 2500
 |  |  |  |  |  |  |  | 36 | 2500 | 2400
 |  |  |  |  |  |  |  | 37 | 2400 | 2300
 |  |  |  |  |  |  |  | 38 | 2300 | 2200
 |  |  |  |  |  |  |  | 39 | 2200 | 2100
 |  |  |  |  |  |  |  | 40 | 2100 | 2000
 |  |  |  |  |  |  |  | 41 | 2000 | 1900