tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 29bc68c7-de75-4331-a4da-0e244634f1cd
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 36. Value of Building Approved - Northern Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  Northern Territory ;  Total residential building ;  New ; |  |  | Original | A420418X | 1970-07-01 00:00:00 | 2012-03-01 00:00:00 | 501 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420430R | 1973-07-01 00:00:00 | 2012-03-01 00:00:00 | 465 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420442X | 1973-07-01 00:00:00 | 2012-03-01 00:00:00 | 465 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | [NAME] | 1970-07-01 00:00:00 | 2012-03-01 00:00:00 | 501 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total building ;  Total (Type of work) ; |  |  | Original | A422768K | 1973-07-01 00:00:00 | 2012-03-01 00:00:00 | 465 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 13b31b74-9531-4033-8ce8-0c29146d3b50
Sheet: Sheet1

Table 5--Corn: Food, seed, and industrial use (million bushels), 12/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 | 1242.658 | 33.02 | 49.115 | 0 | 1582.438
 | [NAME] | 116.276 | 59.709 | 62.688 | 1254.872 | 34.588 | 48.575 | 0 | 1576.708
 | [NAME] | 138.904 | 70.832 | 64.577 | 1257.794 | 36.164 | 49.655 | 20.24 | 1638.166
 | [NAME] | 139.621 | 76.705 | 64.824 | 1263.417 | 31.228 | 49.655 | 2.76 | 1628.21
 | MY Sep-Aug | 521.049 | 272.357 | 258.375 | 5018.741 | 135 | 197 | 23 | 6425.522
2011/12 | Q1 Sep-Nov | 119.636 | 77.965 | 64.652 | 1266.691 | 33.302 | 50.732 | 0 | 1612.978
 | [NAME] | 115.001 | 71.002 | 62.025 | 1304.805 | 34.93 | 50.732 | 0 | 1638.495
 | [NAME] | 136.829 | 72.977 | 62.138 | 1247.777 | 36.586 | 50.531 | 23.452 | 1630.29
 | [NAME] | 141.894 | 72.327 | 65.153 | 1191.752 | 31.682 | 51.234 | 0.958 | 1555
 | MY Sep-Aug | 513.36 | 294.271 | 253.968 | 5011.025 | 136.5 | 203.229 | 24.41 | 6436.763
2012/13 | MY Sep-Aug | 485 | 280 | 240 | 4500 | 135 | 202 | 25 | 5867
1/ September-August.  Latest data may be preliminary or projected. Source: Calculated by USDA, Economic Research Service.
Date run: 12/11/2012
Spreadsheet: 829261d1684072371-a-function-for-automatically-distributing-the-total-load-based-on-the-individual-load-transportation-optimization-eba-1-
Sheet: Sheet1

 |  |  |  |  | Trucks needed for destination (example
Amounts for delivery per destination [tons/day] |  |  |  |  | Alpha |  |  | Beta |  |  |  |  |  | Trucks [NAME]. capacity (assigned per destination) [tons]
Day | Alpha | Beta |  | fixed 0 | Alpha 1 | Alpha 2 | fixed 0 | Beta 1 | Beta 2 | Beta 3 | Beta 4 |  |  | Alpha 1 | 20
1 | 40 | 16 |  | 0 |  |  | 0 |  |  |  |  |  |  | Alpha 2 | 20
2 | 40 | 16 |  | 0 |  |  | 0 |  |  |  |  |  |  | Beta 1 | 30
3 | 30 | 54 |  | 0 |  |  | 0 |  |  |  |  |  |  | Beta 2 | 30
4 | 35 | 105 |  | 0 |  |  | 0 |  |  |  |  |  |  | Beta 3 | 35
5 | 30 | 60 |  | 0 |  |  | 0 |  |  |  |  |  |  | Beta 4 | 35
6 | 30 | 50 |  | 0 |  |  | 0
7 | 25 | 110 |  | 0 |  |  | 0
8 | 40 | 120 |  | 0 |  |  | 0 |  |  |  |  |  | Rule 1: The 2nd truck will be available only after the 1st truck is fully loaded.
9 | 40 | 100 |  | 0 |  |  | 0 |  |  |  |  |  | Rule 2: After the 1st truck is shipped at full capacity, the 2nd truck will carry the remaining load.
10 | 40 | 95 |  | 0 |  |  | 0 |  |  |  |  |  | Rule 3: When the load can be delivered by less than the available trucks, the rest should be marked with 0.
Spreadsheet: andy_zipper__162__DYNEGY-ICE VOL Apr4
Sheet: Enron Activity - Dynegy Direct

DYNEGY DIRECT
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Note: Total Activity for Dynegy Direct is not available, therefore Enron's percentage can not be calculated
Enron North America - Dynegy Direct |  |  |  |  | Enron Power Marketing - Dynegy Direct |  |  |  |  | Enron Global Liquids - Dynegy Direct
 |  | Data |  |  |  |  | Data |  |  |  |  | Data
Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume
Coal | [NAME] | 1 | 460 |  | Power | [NAME] | 5 | 103200 |  | Natural Gas Liquids | Wade Hicks | 2 | 20000
Coal Total |  | 1 | 460 |  |  | [NAME] | 5 | 4000 |  | Natural Gas Liquids Total |  | 2 | 20000
Power | Narsimha Misra | 1 | 800 |  |  | [NAME] | 1 | 800 |  | Grand Total |  | 2 | 20000
 | [NAME] | 1 | 49600 |  | Power Total |  | 11 | 108000
Power Total |  | 2 | 50400 |  | Grand Total |  | 11 | 108000
US Natural Gas | [NAME] | 2 | 10000
 | [NAME] | 4 | 3515000
 | [NAME] | 1 | 5000
 | [NAME] | 2 | 15000
US Natural Gas Total |  | 9 | 3545000
Grand Total |  | 12 | 3595860
Spreadsheet: 123678d1317804768-active-sales-rolling-3-month-back-positive-sales-rolling-last-three-month
Sheet: Sheet1

 |  |  | 13 | 13 | 11 | 10
 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00
AA | 7090.322580645161 | 26403.89006342492 | 337.7054651647891 |  | 9573.881661770876 | 12045.68416572007
BB |  |  | 15006.97538589903
CC |  | 2198.731501057081 |  | 28000 | 10229.96223248007
DD | 497.0925848345202 | 6961.522198731494 | 94.03420942845217 | 1221.924686192468 | 7406.059588753671 | 278.8965150574923
EE | 6900 | 12000 | 11000 | 6854.158995815897 | 6569.332773814519 | 5706.769694691404
FF |  | 4693.378435517967
GG |  | 15233.97885835094 |  | 604.1171548117152 | 746.0847671002937
HH |  | 897.8942917547561 |  | 2573.422594142258 | 28484.78388585816
II | 2414.930875576036 | 38000
JJJ | 533.724340175953 |  | 255.1188986232789 | 4115.17991631799
KK |  | 192.2706131078222 |  | 12000 | 2338.967687788502
LL | 40976.42228739002 | 1276.279069767441 | 1098.156028368794 | 6267.799163179913 | 5760.755350398656
MM | 531.2609970674486 | 4056.761099365747 | 21000 |  | 3090.692404532102 | 8336.07184997875
Spreadsheet: 3be55130-0854-41f9-b486-cdd87d400e51
Sheet: Sheet1

Index Investment Data | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
In U.S. Dollars and Futures Equivalent Contracts
 | 2012-09-28 00:00:00 | 2012-09-28 00:00:00 | 2012-09-28 00:00:00 | 2012-09-28 00:00:00 | 2012-09-28 00:00:00 | 2012-09-28 00:00:00
U.S. Futures Market1 | Notional Value (Billions US$) |  |  | Futures Equivalent Contracts3 (Thousands)
(Notional Value > 0.5 billion US$)2 | Long | Short | Net L (S) | Long | Short | Net L (S)
Cocoa | 1.2 | -0.3 | 0.9 | 47 | -13 | 35
Coffee | 4.3 | -1.6 | 2.7 | 66 | -25 | 41
Copper | 10.4 | -2.9 | 7.5 | 111 | -31 | 80
Corn | 20.4 | -6.5 | 13.9 | 544 | -172 | 372
Cotton | 3.8 | -1.4 | 2.5 | 108 | -39 | 69
[NAME] | 0.7 | -0.2 | 0.5 | 9 | -3 | 7
Gold | 25.9 | -5.2 | 20.7 | 146 | -29 | 117
Heating Oil | 10.6 | -2.5 | 8.1 | 81 | -19 | 62
[NAME] | 4.3 | -1.4 | 2.9 | 140 | -46 | 94
Live Cattle | 8.6 | -2.6 | 5.9 | 170 | -53 | 118
Natural Gas | 18.4 | -4.9 | 13.5 | 526 | -145 | 381
Platinum | 1.4 | -0.3 | 1.1 | 17 | -4 | 13
RBOB Unleaded Gas | 11.2 | -2.7 | 8.6 | 93 | -22 | 72
Silver | 7.3 | -1.4 | 5.8 | 42 | -8 | 34
Soybean Meal | 0.9 | -0.1 | 0.9 | 20 | -1 | 18
Soybean Oil | 4.9 | -1.4 | 3.5 | 153 | -44 | 109
Soybeans | 20.6 | -5.6 | 15 | 259 | -70 | 190
Sugar | 8.5 | -2.5 | 6 | 371 | -110 | 262
Wheat (CBOT) | 15.5 | -6.8 | 8.7 | 345 | -151 | 194
Wheat (KCBT) | 2.6 | -0.7 | 1.9 | 57 | -15 | 42
WTI Crude Oil | 49 | -14 | 35 | 529 | -151 | 378
Subtotal (>0.5 billion US$) | 230.5 | -64.9 | 165.5
Subtotal (<0.5 billion US$) | 0.8 | -0.2 | 0.7
Total Notional US Mkts | 231.3 | -65.1 | 166.2
Total Not'l Non-US Mkts | 63.4 | -15.1 | 48.4
Total All Markets | 294.7 | -80.2 | 214.6
1 Each listed U.S. futures market includes index investment for all futures and OTC markets related to or referenced to that U.S. futures market.  For example, the U.S. market listed as “WTI Crude Oil” includes (with the NYMEX’s Light “Sweet” crude oil futures market) investments held in the NYMEX “Crude Oil Financial” market and the ICE Futures-Europe WTI Light Sweet crude oil market, because both of those contracts’ settlement prices are determined by reference to the NYMEX Light “Sweet” crude oil futures contract.
2 US Futures Markets with 0.5 billion US dollars or more in reported net index investment notional value on the report date.
3Futures Equivalent Contracts: Futures plus delta-adjusted options, estimating what [NAME] would have been established absent offsets.
(See the Explanatory Notes for more details about this data)
Spreadsheet: d41bab1f-660b-4b14-bc5c-1935752eb47b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3317 | 16122 | Oriol | Martos | ESP | 16 | 00:15:29 | 00:00:00 | 01:15:43 | 00:00:00 | 00:38:47 | 1 | 02:10:00
Spreadsheet: chris_germany__2056__MCV Invoice Analysis 4-29-02
Sheet: Assumptions

1
 | Pricing Table |  |  |  |  |  |  |  |  |  | Volume Table (MMBtu/d)
 | MCV I |  | MCV II |  |  |  |  |  |  |  | MCV I |  | MCV II
 | Fixed Price |  | Fixed Price | IF-ANR/LA | IF-PAN/TX/OK | IF-TRUNKL/LA | IF-TRUNKL/TX | IF-HEHUB |  |  | IF-TRUNKL/LA |  | IF-ANR/LA | IF-PAN/TX/OK | IF-TRUNKL/LA | IF-TRUNKL/TX
2001-01-01 00:00:00 | 3.93 |  | 2.55 | 9.83 | 9.92 | 9.84 | 9.72 | 9.91 |  | 2001-01-01 00:00:00 | 5100 |  | 4000 | 5000 | 3000 | 3000
2001-02-01 00:00:00 | 3.93 |  | 2.55 | 6.12 | 6.22 | 6.13 | 6.01 | 6.22 |  | 2001-02-01 00:00:00 | 5100 |  | 4000 | 5000 | 3000 | 3000
2001-03-01 00:00:00 | 3.93 |  | 2.55 | 4.9 | 5.01 | 4.86 | 4.76 | 5.03 |  | 2001-03-01 00:00:00 | 6800 |  | 4000 | 5000 | 3000 | 3000
2001-04-01 00:00:00 | 3.93 |  | 2.55 | 5.29 | 5.31 | 5.29 | 5.19 | 5.35 |  | 2001-04-01 00:00:00 | 6800 |  | 4000 | 5000 | 3000 | 3000
2001-05-01 00:00:00 | 3.93 |  | 2.55 | 4.77 | 4.82 | 4.71 | 4.74 | 4.87 |  | 2001-05-01 00:00:00 | 6800 |  | 4000 | 5000 | 3000 | 3000
2001-06-01 00:00:00 | 3.93 |  | 2.55 | 3.64 | 3.65 | 3.57 | 3.63 | 3.73 |  | 2001-06-01 00:00:00 | 6800 |  | 4000 | 5000 | 3000 | 3000
2001-07-01 00:00:00 | 3.93 |  | 2.55 | 3.07 | 3.05 | 3.03 | 3.1 | 3.16 |  | 2001-07-01 00:00:00 | 6800 |  | 4000 | 5000 | 3000 | 3000
2001-08-01 00:00:00 | 3.93 |  | 2.55 | 3.07 | 3.08 | 3.09 | 3.06 | 3.19 |  | 2001-08-01 00:00:00 | 6800 |  | 4000 | 5000 | 3000 | 3000
2001-09-01 00:00:00 | 3.93 |  | 2.55 | 2.22 | 2.24 | 2.24 | 2.21 | 2.34 |  | 2001-09-01 00:00:00 | 6800 |  | 4000 | 5000 | 3000 | 3000
2001-10-01 00:00:00 | 3.93 |  | 2.55 | 1.74 | 1.75 | 1.74 | 1.73 | 1.86 |  | 2001-10-01 00:00:00 | 6800 |  | 4000 | 5000 | 3000 | 3000
2001-11-01 00:00:00 | 3.93 |  | 2.55 | 3.07 | 3.05 | 3.08 | 3.03 | 3.16 |  | 2001-11-01 00:00:00 | 6800 |  | 4000 | 5000 | 3000 | 3000
2001-12-01 00:00:00 | 3.93 |  | 2.55 | 2.22 | 2.24 | 2.23 | 2.2 | 2.28 |  | 2001-12-01 00:00:00 | 5100 |  | 4000 | 5000 | 3000 | 3000
2002-01-01 00:00:00 | 4.23 |  | 2.55 | 2.5 | 2.51 | 2.49 | 2.47 | 2.61 |  | 2002-01-01 00:00:00 | 5100 |  | 4000 | 5000 | 3000 | 3000
2002-02-01 00:00:00 | 4.23 |  | 2.55 | 1.94 | 1.9 | 1.93 | 1.89 | 2.03 |  | 2002-02-01 00:00:00 | 5100 |  | 4000 | 5000 | 3000 | 3000
2002-03-01 00:00:00 | 4.23 |  | 2.55 | 2.33 | 2.3 | 2.32 | 2.27 | 2.39 |  | 2002-03-01 00:00:00 | 6800 |  | 4000 | 5000 | 3000 | 3000
2002-04-01 00:00:00 | 4.23 |  | 2.55 | 3.31 | 3.29 | 3.33 | 3.28 | 3.4 |  | 2002-04-01 00:00:00 | 6800 |  | 4000 | 5000 | 3000 | 3000
Spreadsheet: 145814d1331750837-count-if-multiple-columns-example-countif
Sheet: Sheet1

 | Open | Title | Grade | Manager | Team | Offered | Filled
 |  |  | H |  |  |  | 1
 | 1 |  | G
 |  |  | I |  |  |  | 1
 | 1 |  | F
 |  |  | I |  |  |  | 1
 | 1 |  | I
 |  | Current I |  |  |  | Filled I
 |  | Current H |  |  |  | Filled  H
 |  | Current G |  |  |  | Filled G
 |  | Current F |  |  |  | Filled  F
Spreadsheet: 117279d1312614923-conditional-vlookup-to-find-entry-within-date-range-conditional-vlookup-test
Sheet: Sheet1

Operation data |  |  | Admission data
URN | Op date |  | URN | ADM date | DIS dates | Op date
189067 | 2011-05-13 00:00:00 |  | 189067 | 2011-05-12 00:00:00
389634 | 2011-02-28 00:00:00 |  | 389634 | 2011-02-24 00:00:00
900267 | 2011-03-06 00:00:00 |  | 900267 | 2011-03-06 00:00:00
862982 | 2011-03-26 00:00:00 |  | 862982 | 2011-03-24 00:00:00
6532 | 2011-05-04 00:00:00 |  | 6532 | 2011-05-01 00:00:00
678928 | 2011-05-09 00:00:00 |  | 678928 | 2011-05-08 00:00:00
 |  |  | 189067 | 2011-01-01 00:00:00
 |  |  | 389634 | 2011-12-09 00:00:00
 |  |  | 900267 | 2011-08-17 00:00:00
 |  |  | 862982 | 2011-09-03 00:00:00
 |  |  | 6532 | 2011-10-25 00:00:00
 |  |  | 678928 | 2011-10-01 00:00:00
Spreadsheet: larry_campbell__21307__PG&E ET Purchases
Sheet: West

PG&E Energy Services
Firm Physical Purchases - West
Transaction Type | Trade Type | RMS No. | Deal Date | Start Date | End Date | Price | Mo. Volume | Delivery Location | Pipeline | Point | LDC
Purchase from PG&E ET | Fixed Cash | 138508 | 1998-10-06 00:00:00 | 2000-07-01 00:00:00 | 2000-07-31 00:00:00 | 2.164 | 10850 | [NAME] 400 NGI | PGT | PGN R Pool | PG&E
Purchase from PG&E ET | Fixed Cash | 138547 | 1998-10-06 00:00:00 | 2000-08-01 00:00:00 | 2000-08-31 00:00:00 | 2.164 | 10850 | [NAME] 400 NGI | PGT | PGN R Pool | PG&E
Purchase from PG&E ET | Fixed Cash | 138575 | 1998-10-06 00:00:00 | 2000-09-01 00:00:00 | 2000-09-30 00:00:00 | 2.164 | 10500 | [NAME] 400 NGI | PGT | PGN R Pool | PG&E
Purchase from PG&E ET | Fixed Cash | 138596 | 1998-10-06 00:00:00 | 2000-10-01 00:00:00 | 2000-10-31 00:00:00 | 2.164 | 10850 | [NAME] 400 NGI | PGT | PGN R Pool | PG&E
Purchase from PG&E ET | Fixed Cash | 185417 | 1999-12-01 00:00:00 | 2000-07-01 00:00:00 | 2000-07-31 00:00:00 | 2.57 | 25916 | Northwest Stanfield IF | Northwest | 18511 | Northwest Natural
Purchase from PG&E ET | Fixed Cash | 185417 | 1999-12-01 00:00:00 | 2000-08-01 00:00:00 | 2000-08-31 00:00:00 | 2.57 | 26815 | Northwest Stanfield IF | Northwest | 18511 | Northwest Natural
Purchase from PG&E ET | Fixed Cash | 185417 | 1999-12-01 00:00:00 | 2000-09-01 00:00:00 | 2000-09-30 00:00:00 | 2.57 | 24510 | Northwest Stanfield IF | Northwest | 18511 | Northwest Natural
Purchase from PG&E ET | Fixed Cash | 185417 | 1999-12-01 00:00:00 | 2000-10-01 00:00:00 | 2000-10-31 00:00:00 | 2.57 | 38285 | Northwest Stanfield IF | Northwest | 18511 | Northwest Natural
Purchase from PG&E ET | Fixed Cash | 185417 | 1999-12-01 00:00:00 | 2000-11-01 00:00:00 | 2000-11-30 00:00:00 | 2.57 | 43110 | Northwest Stanfield IF | Northwest | 18511 | Northwest Natural
Spreadsheet: 204978d1357703788-duplicate-values-multiple-rows-to-be-highlited-cf-duplicates-in-table
Sheet: Sheet1

LAST NAME | FIRST NAME | MIDDLE NAME
BACALLA | CARMELIN | DATO-ON |  | I seleted your range from A1 to C5 and did a conditional formatting.  See the rule in CF.
DESCATIAR | AMALIA | LIBRADILLA
SABANAL | APOLINARIA | PANTINOPLE
ANCILING | MERALONA | PAGLINAWAN
GARBO | ROUGIE | LAPING
SELERIO | CATALINA | ELESTERIO
AMIT | MARICEL | TAMPUS
GARBO | ROUGIE | LAPING
TABORADA | ELENA | YBANEZ
LILO-AN | RODELYN | CORTA
DESCATIAR | AMALIA | LIBRADILLA
SUMALINOG | ARLINDA | BAAY
COSEDO | DIOGRACIA | INCIPIDO
TAC-AN | CHEERY | TERO
Spreadsheet: 141551d1329326267-help-with-matching-multiple-column-criteria-in-xls-format-ef44
Sheet: rtd

ref | date | ID | data 1 | data 2 | result
409281 | 2012-01-20 00:00:00 | 1 | 30 | 20 | 10
409282 | 2012-01-20 00:00:00 | 2 | 40 | 20 | 20
409291 | 2012-01-21 00:00:00 | 1 | 50 | 22 | 28
409293 | 2012-01-21 00:00:00 | 3 | 60 | 23 | 37
409302 | 2012-01-22 00:00:00 | 2 | 70 | 25 | 45
Spreadsheet: 545255d1509378249-can-anyone-help-on-this-golf-scorecard-challenge-golf-scorecard-tiebreaker
Sheet: Sheet1

 | Gross1 | Gross2 | Gross3 | Gross4 | Gross5 | Gross6 | Gross7 | Gross8 | Gross9 | Gross10 | Gross11 | Gross12 | Gross13 | Gross14 | Gross15 | Gross16 | Gross17 | Gross18 | Total | Rank
Player1
Player2
Player3
Player4
Player5
Player6
Player7
Player8
Player9
Player10
Spreadsheet: 09229d0d-d2e0-42c5-9381-aa2d36b0dae8
Sheet: Analyte Summary

Summary of Analyte Testing for Distribution System Water Quality Monitoring - City of Longview, WA
No | Analyte | Method | Test Location | Frequency | Notes/Comments
1 | Temperature |  | Field | Weekly
 | pH | E150.1 | Field | Weekly
 | Conductivity | A2510B | Field | Weekly
 | Free Chlorine |  | Field | Weekly
 | Total Chlorine |  | Field | Weekly
 | ORP |  | Field | Weekly | Hach HQ40d portable multi-meter
 | DO |  | Field | Weekly | Hach HQ40d portable multi-meter
 | Turbidity | [NAME] | MFRWTP Lab | Weekly
 | Total Iron | E200.7 | MFRWTP Lab | Weekly | Time sensitive, chill to prevent oxidation
 | Soluble Iron | E200.7 | MFRWTP Lab | Weekly | Time sensitive, test filtrate after using 0.45 μm filter
 | Total Manganese | E200.7 | MFRWTP Lab | Weekly
 | Soluble Manganese | E200.7 | MFRWTP Lab | Weekly | Test filtrate after using 0.45 μm filter
 | Total Arsenic | E200.8 | ALS Lab | Weekly
 | Soluble Arsenic | E200.8 | ALS Lab | Weekly | Test filtrate after using 0.45 μm filter
 | Hardness | A2340B | MFRWTP Lab | Weekly
 | Alkalinity | A2320B | MFRWTP Lab | Weekly
 | Apparent Color | A2120B | MFRWTP Lab | Weekly
 | True Color | A2120B | MFRWTP Lab | Weekly | Test filtrate after using 0.45 μm filter
 | Silica | A4500S1O2 | ALS Lab | Weekly
 | HPC's | [NAME] | ALS Lab | Weekly | 7-day incubation @ room temp
 | Iron Bacteria | BARTTM | ALS Lab | Weekly | Hach prepared kit
 | [NAME] | BARTTM | ALS Lab | Weekly | Hach prepared kit
To request water quality results, contact the City's Engineering department at (360)442-5200
Spreadsheet: lynn_blair__24309__FERC docket RM01-9_item3
Sheet: Item 3 - PQ3TRANSW080101

Seq # | PHS | Pipeline DUNS # | Pipeline Name | Filing Date | First Day of Reporting Period | Name of Contact Person | Phone Number of Contact Person | Original/ Revised Filing Indicator
Seq # | PDS | Pipeline DUNS # | Date | Maximum Peak Day Design Capacity | Daily Maximum Flowing Capacity | Daily Scheduled System Volume | Daily Delivered System Volume | Footnote
Seq # | PPS | Pipeline DUNS # | Date | [NAME] | Point ID Code | Daily Scheduled Volume at Point
Seq # | PFS | Pipeline DUNS # | Footnote | Footnote Text
1 | PHS | 007933047 | Transwestern Pipeline Company | 2001-09-30 00:00:00 | 2001-08-01 00:00:00 | [NAME] | (402) 398-7060 | O
2 | PDS | 007933047 | 2001-08-01 00:00:00 |  |  | 4915883 | 4915883
3 | PPS | 007933047 | 2001-08-01 00:00:00 | SOCAL NEEDLES | 208 | 801047
4 | PPS | 007933047 | 2001-08-01 00:00:00 | PG&E TOPOCK | 39815
5 | PPS | 007933047 | 2001-08-01 00:00:00 | SOCAL TOPOCK | 68283 | 40000
6 | PPS | 007933047 | 2001-08-01 00:00:00 | MOJAVE TOPOCK | 68288 | 20000
7 | PFS | 007933047
8 | PPS | 007933047
Spreadsheet: 688507d1595834172-running-total-on-filtered-table-example-2
Sheet: example 2

 | Profit/Loss | Bet P/L Units | Running Total $$ | Running Total Units | Column1
 | 5.411999999999999
 | -32.37
 | 5.310899999999998
 | 5.5
 | 5.472
 | 4.839
 | -18.61
 | 5.733000000000001
 | -14.46
 | 5.667699999999996
 | 6.276799999999998
 | 5.587
 | 5.432399999999999
 | 5.317599999999999
 | 5.312999999999999
 | 5.547
 | -37.95
 | 5.58
 | 5.508200000000001
 | 5.539999999999999
 | 5.322000000000006
Spreadsheet: 196443d1354014037-return-1st-2nd-3rd-4th-5th-6th-7th-or-tie-if-equal-value-rank-with-ties
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | return, 1st,2nd,3rd,4th,5th,6th,7th or tie if equal value
 |  |  |  |  |  |  |  |  | Result by Ranking |  | Result by Position | Score | [NAME]
 |  |  |  |  |  |  |  |  | Tied for 1st |  | Tied for 1st | 95 | 95
 |  |  |  |  |  |  |  |  | Tied for 4th |  | Tied for 3rd | 85 | 90
 |  |  |  |  |  |  |  |  | 3rd |  | 2nd | 90 | 85
 |  |  |  |  |  |  |  |  | Tied for 1st |  | Tied for 1st | 95 | 70
 |  |  |  |  |  |  |  |  | 7th |  | 5th | 60 | 60
 |  |  |  |  |  |  |  |  | 6th |  | 4th | 70
 |  |  |  |  |  |  |  |  | Tied for 4th |  | Tied for 3rd | 85
Spreadsheet: 804158d1667920140-index-not-working-with-floor-value-test
Sheet: Sheet1

 |  |  | X = | 120 | Change between 0 and 1000
 |  |  | ID | Low | High | Low Value | High Value
 |  |  | 136
 |  | Low and High Value Lookup
 | ID | 100 | 150 | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600 | 650 | 700 | 750 | 800 | 850 | 900 | 950 | 1000
 | 136 | 20 | 20 | 20 |  | 20 | 20 | 20 | 20 | 20 | 19.7 | 19.4 | 18.8 | 18.1 | 14.8 | 12 | 9.3 | 6.7 | 4 | 2.5
Spreadsheet: 697654d1601466790-the-number-that-appears-most-or-least-the-number-that-appears-most
Sheet: Sheet2

 | 6.2 |  | the number that appears most
 | 5.1 |  | All list | From 6 to 7 | greater than 5.3
 | 5.2
 | 5.4
 | 5.1
 | 5.5 |  | the number appears at least
 | 5.8 |  | All list | From 6 to 7 | less than 5.3
 | 5.1 |  | ? | ? | ?
 | 6.8
 | 5.1
 | 5.9
 | 6.2
 | 5.2
 | 5.2
 | 6.2
 | 6.8
Spreadsheet: michelle_lokay__26750__imball0112
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 |  | -7000
2 |  | -4786
3 | -20568 | -4786
4 | -6999 | -10000
5 | -5845 | -10000
6 | -8331 | -10000
7 | -8430 | -10000
8 | -35058 | -17270
9 | -565 | -17270
10 | -7231 | -17270
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00
2001-12-10 00:00:00 |  |  |  | 2.12
CBS Dollars
 |  |  | 159102
Spreadsheet: 61384d1262194094-if-vlookup-not-sure-what-to-do-employee
Sheet: Employee Name

Employee Name
Date of Birth |  | 1901-01-01 00:00:00 |  |  | Date of Hire |  | 2001-01-01 00:00:00 |  | Employee Number |  |  | 9999
Address |  | ## Street Name |  |  | Home Phone |  | 5555555555 |  | Emergency Contact Name |  |  | Significant Other
City, State, Zip |  | City, State, Zip |  |  | Cell Phone |  | 5555555555 |  | Emergency Contact Phone |  |  | 5555555555
Sick Time Permitted |  |  | 8 |  | Vacation Time Permitted |  |  | 80 |  | Holiday Time Permitted |  |  | 40
Sick Time Remaining |  |  |  |  | Vacation Time Remaining |  |  |  |  | Holiday Time Remaining
Date Not Worked |  |  |  | Reason |  |  | Hours Used |  | Notes
2009-11-09 00:00:00 |  |  |  | Sick |  |  | 4
2009-11-10 00:00:00 |  |  |  | Sick |  |  | 4
2009-11-11 00:00:00 |  |  |  | Holiday |  |  | 8