tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 3f69e7b0-080c-4fd6-980e-01c6d76e757a
Sheet: Sheet1

Commercial Construction Permits | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Entries made in the last 7 day(s)
Permit |  | Permit Type |  |  | Date Recorded | [NAME] | Job Address | Project |  | Contractor |  | Est Value
13-2298 |  | Commercial Canopy |  |  | 2014-10-27 00:00:00 |  | 611 LOVELL RD KNOXVILLE 37932 | SPEEDWAY CONVENIENCE STORE CANOPIES |  | Shaub Construction Company, Inc. |  | 385140
14-2985 |  | Commercial Improvement Minor |  |  | 2014-10-27 00:00:00 | 103 | 2210 AWARD WINNING WAY KNOXVILLE TN 37932 | VISUAL TOURS - INTERIOR DEMOLITION |  | Tillman Companies, Llc |  | 5000
14-2974 |  | Commercial Improvement Minor |  |  | 2014-10-29 00:00:00 | 047 | 229 E EMORY RD POWELL TN 37849 | MAX AIR TRAMPOLINE PARK LLC - INTERIOR DEMO |  | [NAME] |  | 1600
14-2943 |  | Commercial Interior |  |  | 2014-10-29 00:00:00 | 038 | 6925 #E MAYNARDVILLE PIKE KNOXVILLE TN 37918 | 7 LIL MONKEYS DISCOUNT STORE |  | [NAME], Trinity Auction, Inc |  | 500
14-2996 |  | Sign |  |  | 2014-10-29 00:00:00 |  | 6840 MAYNARDVILLE PIKE KNOXVILLE TN 37918 | KARM STORES |  | Southern Signs |  | 7000
14-2944 |  | Commercial Interior |  |  | 2014-10-30 00:00:00 | 038 | 6925 #D MAYNARDVILLE PIKE KNOXVILLE TN 37918 | TRINITY AUCTION |  | [NAME], Trinity Auction, Inc |  | 500
14-2919 |  | Commercial Interior |  |  | 2014-10-30 00:00:00 | 017 | 1955 E RACCOON VALLEY DR HEISKELL TN 37754 | SLAPPY'S BAR-B-QUE, LLC |  | [NAME], [NAME] Bar-B-Que Llc |  | 1000
14-2989 |  | Commercial Interior |  |  | 2014-10-31 00:00:00 | 062 | 8534 ASHEVILLE HWY KNOXVILLE TN 37924 | PUPS PIT BBQ, LLC |  | [NAME] |  | 100
 | Total |  | 8 |  |  |  |  |  |  | Sum | 400840
Spreadsheet: 873501d1720006554-staff-loan-deduction-loan-dedution
Sheet: Sheet1

 | EMPLOYEE 1 |  |  |  |  |  | EMPLOYEE 2
Month | Loan Amount | Repayment | Advance | Once-Off Dedution | Total Deduction | Balance | Loan Amount | Repayment | Advance | Once-Off Dedution | Total Deduction | Balance
2024-07-01 00:00:00 | 9250 | 500 | 200 | 200 |  |  | 11950 | 500 | 500 | 500
2024-08-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2024-09-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2024-10-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2024-11-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2024-12-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-01-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-02-01 00:00:00 |  | 500 |  |  |  |  |  | 500 | 500 | 500
2025-03-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-04-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-05-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-06-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-07-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-08-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-09-01 00:00:00 |  | 500 | 700 | 700 |  |  |  | 500
2025-10-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-11-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-12-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2026-01-01 00:00:00 |  |  |  |  |  |  |  | 501
2026-02-01 00:00:00 |  |  |  |  |  |  |  | 502
2026-03-01 00:00:00 |  |  |  |  |  |  |  | 503
2026-04-01 00:00:00 |  |  |  |  |  |  |  | 504
2026-05-01 00:00:00 |  |  |  |  |  |  |  | 505
2026-06-01 00:00:00
Spreadsheet: 788204d1658324390-help-with-staff-rota-formula-staff-rota-sample-workbook
Sheet: BEFORE

UI | Name | Area | Last Date
001 | Name 1 | Area 1 | 2020-01-01 00:00:00
002 | Name 2 | Area 1 | 2021-01-01 00:00:00
003 | Name 3 | Area 1 | 2022-01-01 00:00:00
004 | Name 4 | Area 2
005 | Name 5 | Area 2
006 | Name 6 | Area 2
007 | Name 7 | Area 3 | 2021-01-01 00:00:00
008 | Name 8 | Area 3
009 | Name 9 | Area 3
Spreadsheet: 166136d1341483374-looking-up-one-value-then-returning-multiple-matches-across-a-row-book1
Sheet: ROLE_PERMISSION

 |  | ROLE NAME | PERMISSION ID
 |  | Name1 | 3
 |  | [NAME] | 3
 |  | Name3 | 3
 |  | Name4 | 3
 |  | Ross1 | 4
 |  | Ross2 | 4
 |  | [NAME] | 5
 |  | [NAME] | 6
 |  | [NAME] | 7
 |  | [NAME] | 8
Spreadsheet: 864437d1711607724-merging-multiple-tables-based-on-unique-id-query
Sheet: X7

Sr. No. | Description | X1 | X2 | X3 | X4 | X5 | X6 |  |  | Sr. No. | Description | x1 | x2 | [NAME] | x4 | x5 | x6
1 | AAA | 1 | 1 | 1 | 3 | 1 | 1 |  |  | 1 | AAA | 1 | 1 | 1 | 3 | 1 | 1
2 | BBB | 2 | 2 | 2 | 2 | 2 | 2 |  |  | 2 | BBB | 2 | 2 | 2 | 2 | 2 | 2
3 | CCC | 1 | 1 | 3 | 1 | 1 | 1 |  |  | 3 | CCC | 1 | 1 | 3 | 1 | 1 | 1
4 | DDD | 3 | 0 | 4 | 1 | 3 | 2 |  |  | 4 | DDD | 3 | 0 | 4 | 1 | 3 | 2
5 | EEE | 1 | 2 | 3 | 2 | 0 | 1 |  |  | 5 | EEE | 1 | 2 | 3 | 2 | 0 | 1
6 | FFF | 0 | 1 | 2 | 1 | 1 | 3 |  |  | 6 | FFF | 0 | 1 | 2 | 1 | 1 | 3
7 | GGG | 2 | 3 | 1 | 3 | 2 | 2 |  |  | 7 | GGG | 2 | 3 | 1 | 3 | 2 | 2
8 | HHH | 1 | 1 | 4 | 2 | 4 | 1 |  |  | 8 | HHH | 1 | 1 | 4 | 2 | 4 | 1
9 | III | 0 | 4 | 1 | 1 | 2 | 1 |  |  | 9 | III | 0 | 4 | 1 | 1 | 2 | 1
10 | JJJ | 1 | 2 | 2 | 0 | 1 | 2 |  |  | 10 | JJJ | 1 | 2 | 2 | 0 | 1 | 2
11 | KKK | 2 | 1 | 2 | 4 | 0 | 1 |  |  | 11 | KKK | 2 | 1 | 2 | 4 | 0 | 1
12 | LLL | 1 | 0 | 0 | 2 | 1 | 0 |  |  | 12 | LLL | 1 | 0 | 0 | 2 | 1 | 0
Spreadsheet: 491017d1480265359-adding-cumulative-weekly-totals-avk-excel-forum-question1
Sheet: 11-1-16

 | DAILY HEARING ROSTER
 | MEETINGS TODAY:
Rank | Stenographer | Notes | Time In | Time Out | Time In | Time Out | Subtotal | Total Hours | NewRank | Cumulative | Cum_rank | Judge | Employee Name | Board No.
1 | Stacy |  | 09:00:00 | 10:00:00 |  |  |  |  |  |  |  |  | Pretend Employee
2 | [NAME]
3 | [NAME] |  | 13:00:00 | 16:00:00 |  |  |  |  |  |  |  |  | Pretend Employee
4 | [NAME]
5 | [NAME]
6 | [NAME]
 | Travel
 |  |  |  | TOTAL TIME (Today): |  |  |  |  |  |  |  | TOTAL HEARINGS (Today):
 |  |  |  | TIME (Week End Total): |  |  |  |  |  |  |  | Hearings (Week End Total):
Spreadsheet: 726808d1617479810-dynamic-array-spill-and-sort-into-2-columns-spill-and-sort
Sheet: Sheet1

 | NOTE: There will name be more than 10 Unique Names
 | SOURCE TABLE |  |  |  |  | CURRENT FUNCTION |  |  |  | WHAT I'D LIKE (SPILT INTO TWO COLUMNS AND SORTED BY TOTAL) |  |  |  |  |  |  | WHAT SHOULD HAPPEN IF THERE ARE 5 OR LESS UNIQUE NAMES
 | Name | Dividend Date | Total |  |  | Name | Total |  |  | Name | Total |  | Name | Total |  |  | Name | Total |  | Name | Total
 | Arizona | 2021-01-31 00:00:00 | 345 |  |  |  |  |  |  | Florida | 987 |  | Georgia | 414 |  |  | Florida | 987
 | Maine | 2020-04-15 00:00:00 | 216 |  |  |  |  | 589 |  | Illinois | 933 |  | Arizona | 345 |  |  | Illinois | 933
 | Georgia | 2020-03-15 00:00:00 | 267 |  |  |  |  | 933 |  | Maine | 787 |  | Washington | 237 |  |  | Maine | 787
 | California | 2021-08-09 00:00:00 | 589 |  |  |  |  | 987 |  | Alabama | 753 |  |  |  |  |  | Alabama | 753
 | Illinois | 2021-09-07 00:00:00 | 246 |  |  |  |  | 753 |  | California | 589
 | Florida | 2021-12-01 00:00:00 | 987 |  |  |  |  | 787 |  | BREAK AT 5 UNIQUE NAMES |  |  |  |  |  |  | LESS THAN 5 UNIQUE NAMES
 | Georgia | 2020-02-28 00:00:00 | 147
 | Alabama | 2021-04-15 00:00:00 | 753
 | Maine | 2021-06-12 00:00:00 | 23
 | Arizona | 2020-12-12 00:00:00 | 237 |  |  |  |  |  |  |  | 987 |  | Arizona | 345
 | Illinois | 2021-03-13 00:00:00 | 687 |  |  |  |  |  |  | Illinois | 933
 | Washington | 2020-11-23 00:00:00 | 237 |  |  |  |  |  |  | Maine | 787
 | New York | 2020-02-09 00:00:00 | 975 |  |  |  |  |  |  | Alabama | 753
 | Maine | 2021-11-06 00:00:00 | 764 |  |  |  |  |  |  | California | 589
Spreadsheet: 75398d1275987663-using-getpivotdata-for-multiple-dates-book3
Sheet: Sheet2

Sum of Total Pax | Source2
Extract Date | Great Britain - Post | Great Britain - Telephone | Great Britain - Web | IRELAND - Web | Israel - Post | New Zealand - Post | Saudi Arabia - Telephone | USA - Web | Grand Total
2010-06-04 00:00:00 | 4 | 67 | 16 | 2 | 0 | 1 | 2 | 1 | 93
2010-06-05 00:00:00 |  | 25 | 8 |  |  |  |  | 1 | 34
2010-06-06 00:00:00 |  |  | 11 |  |  |  |  |  | 11
Grand Total | 4 | 92 | 35 | 2 | 0 | 1 | 2 | 2 | 138
From | To
2010-06-04 00:00:00 | 2010-06-06 00:00:00
SUMIF | 92
[NAME] | 67
Basically I'm trying to get the formula highlighted in Green to add up the data for the dates specified in A14 and B14.
I used to use SUMIFs however the pivot is going to change as more countries book so where "Great Britain - Telephone"
for example is currently in column C that may change in future so the SUMIF would be wrong. I've now tried using
GETPIVOTDATA formulas but can only get it to work for one date in this case 4th June but don't know how to do it for multiple dates!
Spreadsheet: 700422d1603191861-dynamic-table_array-value-for-vlookup-function-funding-rate-data-exemple
Sheet: Sheet1

MONTH | DAY | time | BTCUSDT | LTCUSDT | ETHUSDT | ETCUSDT | XRPUSDT | EOSUSDT | BCHUSDT | BSVUSDT
 |  | 2020-10-18 18:00:00
 |  | 2020-10-18 10:00:00
 |  | 2020-10-18 02:00:00
 |  | 2020-10-17 18:00:00
 |  | 2020-10-17 10:00:00
 |  | 2020-10-17 02:00:00
 |  | 2020-10-16 18:00:00
 |  | 2020-10-16 10:00:00
 |  | 2020-10-16 02:00:00
 |  | 2020-10-15 18:00:00
 |  | 2020-10-15 10:00:00
 |  | 2020-10-15 02:00:00
 |  | 2020-10-14 18:00:00
 |  | 2020-10-14 10:00:00
 |  | 2020-10-14 02:00:00
 |  | 2020-10-13 18:00:00
 |  | 2020-10-13 10:00:00
 |  | 2020-10-13 02:00:00
 |  | 2020-10-12 18:00:00
 |  | 2020-10-12 10:00:00
 |  | 2020-10-12 02:00:00
 |  | 2020-10-11 18:00:00
 |  | 2020-10-11 10:00:00
 |  | 2020-10-11 02:00:00
 |  | 2020-10-10 18:00:00
 |  | 2020-10-10 10:00:00
 |  | 2020-10-10 02:00:00
 |  | 2020-10-09 18:00:00
 |  | 2020-10-09 10:00:00
 |  | 2020-10-09 02:00:00
 |  | 2020-10-08 18:00:00
 |  | 2020-10-08 10:00:00
 |  | 2020-10-08 02:00:00
 |  | 2020-10-07 18:00:00
 |  | 2020-10-07 10:00:00
 |  | 2020-10-07 02:00:00
 |  | 2020-10-06 18:00:00
 |  | 2020-10-06 10:00:00
 |  | 2020-10-06 02:00:00
 |  | 2020-10-05 18:00:00
 |  | 2020-10-05 10:00:00
 |  | 2020-10-05 02:00:00
 |  | 2020-10-04 18:00:00
Spreadsheet: 868102d1714824423-better-alternatives-to-lookup-example
Sheet: my Excel list

name | Value 1 | Value 2 | Value 3 | ID to be filled in
Name 1 | 5.072604953302047 | 0.1059075749470872 | 1.869989914405472
Name 2 | 4.730521583948391 | 3.38241805874821 | 8.6049531615723 | ID_2
Name 3 | 3.326870396754086 | 6.243375702731935 | 5.694797711217494 | ID_3
Name 4 | 0.9168047754139697 | 4.950235758996103 | 4.475828261310513 | ID_4
Name 10 | 3.91058556548053 | 2.569317138655705 | 2.115327475795739 | ID_10
Name 6 | 0.09247156256424915 | 5.936467765715859 | 7.962131088758262 | ID_6
Name 7 | 2.653105531542714 | 8.842443432945375 | 4.37283550999722 | ID_7
Name 8 | 8.96429324924508 | 3.214170089112728 | 0.4279187336825885 | ID_8
Name 9 | 1.138353083164537 | 7.55693030997972 | 5.28772239127197 | ID_9
Name 5 | 0.477005220233 | 0.9157900946229336 | 3.614083382698237 | ID_5
Spreadsheet: 80028d1280261504-index-lowest-value-minus-match-value-month-diff
Sheet: Sheet1

Item # | Monthly Usage | Current Vendor | ABC | JKL | XYZ | Lowest Cost Vendor | Potential Monthly Savings vs Current
46799 | 114 | ABC | 17 | 19 | 12 | XYZ | 570
15494 | 76 | XYZ | 9 | 12 | 6 | XYZ | 0
74128 | 476 | ABC | 17 | 17 | 18 | ABC | 0
76697 | 57 | JKL | 9 | 20 | 11 | ABC | 627
71247 | 32 | ABC | 7 | 20 | 18 | ABC | 0
73330 | 118 | JKL | 13 | 17 | 11 | XYZ | 708
57624 | 461 | XYZ | 12 | 17 | 11 | XYZ | 0
Spreadsheet: phillip_m_love__30140__200005_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Market East-EGM |  | West |  | Denver |  | Texas-HPLR |  | Texas-EGM |  | Texas-HPLC |  | Storage |  | Ontario |  | Aruba |  | Sithe |  | MidMarket |  | BUG
 |  |  | 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 |  |  |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
2 |  | Liquidations |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  | 0 |  | 0
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  | 0 |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 3d77b2bd-5479-4ac7-834b-548f6f6e8efd
Sheet: Sheet1

Appendix table 5--Regional shares of specialized dairy farms, selected years1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
State | 1978 | 1982 | 1987 | 1992 | 1997
 | Percent
Northeast | 22.84870691188503 | 22.19610272857594 | 22.708244463564 | 22.86089655415653 | 25.32956685499058
Lake States | 39.25331720678738 | 39.70223777243239 | 39.29188567792873 | 38.64141360702571 | 37.3241728860059
Corn Belt | 13.53206929671659 | 14.34506888257162 | 14.69803558646818 | 14.44644305717208 | 14.49977912627002
Northern Plains | 3.947446432594595 | 4.354666277911413 | 4.300453326199651 | 3.945790568899235 | 3.442142707679431
Appalachian | 7.492322104039936 | 7.162208129844255 | 7.204777638799517 | 6.692413501216802 | 6.051940201343842
Southeast | 1.641706093699975 | 1.404378356051218 | 1.341903391631902 | 1.595951045744718 | 1.441491711422659
Delta States | 2.243487128407622 | 2.108997254416017 | 1.90223481863337 | 2.132931259478715 | 1.933226383948292
Southern Plains | 2.765228321060557 | 2.539057754452462 | 2.543543174440211 | 3.385003350615455 | 3.168956778498524
Mountain | 2.825702868390784 | 2.837305926087907 | 2.524744958824678 | 2.515606814093747 | 2.728371811862082
Pacific | 3.450013636417535 | 3.349976917656778 | 3.484176963509771 | 3.783550241597009 | 4.080351537978657
United States | 100 | 100 | 100 | 100 | 100
1 Specialized means farms identified by SIC (Standard Industrial Classification) or [NAME] (North American Industrial
Classification System).
Source: Census of Agriculture, U.S. Summary and State Data, Volume 51, part 51, various years.
Spreadsheet: 80706d1280926977-dividing-a-range-of-cells-by-a-reference-cell-example
Sheet: prices

price (NOK) |  |  |  | Price (US $)
136.81 |  |  |  | 22.80166666666667
160.26 |  |  |  | #N/A
98.45 |  |  |  | #N/A
137.27 |  |  |  | #N/A
154.59 |  |  |  | #N/A
77.04 |  |  |  | #N/A
248.22 |  |  |  | #N/A
52.97 |  |  |  | #N/A
77.48 |  |  |  | #N/A
45.06 |  |  |  | #N/A
199.57 |  |  |  | #N/A
103.73 |  |  |  | #N/A
188.59 |  |  |  | #N/A
113.2 |  |  |  | #N/A
278.55 |  |  |  | #N/A
129.45 |  |  |  | #N/A
123.14 |  |  |  | #N/A
154.2 |  |  |  | #N/A
95.97 |  |  |  | #N/A
40.17 |  |  |  | #N/A
18.23 |  |  |  | #N/A
283.98 |  |  |  | #N/A
124.19 |  |  |  | #N/A
136.2 |  |  |  | #N/A
84.15 |  |  |  | #N/A
40.22 |  |  |  | #N/A
99.91 |  |  |  | #N/A
95.91 |  |  |  | #N/A
119.08 |  |  |  | #N/A
174.49 |  |  |  | #N/A
13.7 |  |  |  | #N/A
42.3 |  |  |  | #N/A
67.36 |  |  |  | #N/A
122.61 |  |  |  | #N/A
150.74 |  |  |  | #N/A
132.38 |  |  |  | #N/A
81.22 |  |  |  | #N/A
78.08 |  |  |  | #N/A
58.87 |  |  |  | #N/A
67.18 |  |  |  | #N/A
611.37 |  |  |  | #N/A
72.32 |  |  |  | #N/A
158.27 |  |  |  | #N/A
21.49 |  |  |  | #N/A
116.33 |  |  |  | #N/A
Spreadsheet: john_griffith__15640__Book1
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.25 | 0.39 | 0.43 | 0.5455999999999938 | 0.02669999999999706
 | N | 4.35 | 0.66 | 0.7 | 0.5341999999999969 | 0.01559999999999828
 | Q | 4.4 | 0.86 | 0.89 | 0.5391999999999975 | 0.01169999999999871
 | U | 4.45 | 1.04 | 1.08 | 0.5472999999999973 | 0.01349999999999851
 | V | 4.45 | 1.18 | 1.21 | 0.5540999999999972 | 0.01349999999999851
 | X | 4.65 | 1.37 | 1.4 | 0.5594999999999979 | 0.01109999999999878
 | Z | 4.85 | 1.56 | 1.6 | 0.5671999999999972 | 0.01349999999999851
 | F | 4.9 | 1.7 | 1.75 | 0.5734999999999976 | 0.009299999999998976
 | G | 4.8 | 1.73 | 1.8 | 0.5674999999999986 | 0.00389999999999957
 | H | 4.6 | 1.59 | 1.66 | 0.5170999999999978 | 0.01169999999999871
 | J | 4.3 | 1.23 | 1.245 | 0.4021999999999982 | 0.008399999999999075
 | K | 4.25 | 1.1 | 1.2 | 0.3673999999999999 | 0.003299999999999637
 |  |  | 2001-05-08 14:47:51.240000
Spreadsheet: 09eec516-9640-48ac-9740-65ff05b9f8d7
Sheet: ethnic

AY07-08 | AY08-09 | [NAME] | AY10-11 | AY11-12
2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  |  | White |  | White
 |  |  |  |  |  | Hispanic |  | Hispanic
 |  |  |  |  | B | African American |  | African American
 |  |  |  |  |  | Asian |  | Asian
 |  |  |  |  |  | Native American |  | Native American
 |  |  |  |  |  | Filipino |  | Filipino
 |  |  |  |  |  | Pacific Islander |  | Pacific Islander
 |  |  |  |  |  | Multi-Race |  | Multi-Race
 |  |  |  |  |  | Unknown |  | Unknown
Spreadsheet: 132239d1323633204-extract-data-into-master-work-sheet-given-format
Sheet: MW-2

LOW FLOW SAMPLING
FIELD DATA SHEETS
 |  |  | Client:
 | Site:
 | Date: |  |  | 2011-11-15 00:00:00
 |  |  | Monitoring Well #: | MW-2 |  |  |  | Well Depth: | 16.4 |  | ft |  |  | Screened/Open Interval: | 3.2-18.2 |  | ft
 |  |  | Well Permit #: |  |  |  |  | Well Diameter: | 2 |  | inches
 | PID Readings (ppm)
 |  |  |  | Background: |  | 0 |  |  | Pump Intake Depth: |  |  | 10 |  |  | ft below TOC
 |  |  |  | [NAME]: |  | 0 |  |  |  |  |  |  | Depth to Water Before Pump Installation: | 3.25 |  | ft below TOC
 |  |  |  | Beneath Inner Cap: |  | 0 |  |  |  |  |  |  | [NAME] | stainless steel submersible pump
 | TIME | Purging | Sampling |  |  |  |  | Specific |  | Dissolved |  | Redox |  |  |  |  | Depth to
 |  |  |  | pH |  | Temperature |  | Conductivity |  | [NAME] |  | Potential |  | Turbidity |  | Pumping | Water
 |  |  |  | (pH units) |  | (oC) |  | (uS/cm) |  | (mg/L) |  | (mV) |  | (NTU) |  | Rate | (ft below
 |  |  |  | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | (ml/min) | TOC)
 | 1220 | x |  | 6.79 | NA | 18.22 | NA | 1388 | NA | 0.42 | NA | 190.1 | NA | 50.9 | NA | 220 | 3.44
 | 1225 | x |  | 6.79 |  | 18.38 |  | 1390 |  | 0.19 |  | 191.6 |  | 32.2 |  | 220 | 3.46
 | 1230 | x |  | 6.79 |  | 18.48 |  | 1391 |  | 0.16 |  | 190.3 |  | 20.5 |  | 220 | 3.48
 | 1235 | x |  | 6.77 |  | 18.4 |  | 1392 |  | 0.13 |  | 187.4 |  | 18 |  | 220 | 3.48
 | 1240 | x |  | 6.77 |  | 18.32 |  | 1390 |  | 0.12 |  | 184.7 |  | 13.3 |  | 220 | 3.48
 | 1245 | x |  | 6.78 |  | 18.33 |  | 1390 |  | 0.1 |  | 182.3 |  | 11.3 |  | 220 | 3.48
 | 1250 | x |  | 6.78 |  | 18.32 |  | 1390 |  | 0.09 |  | 179.8 |  | 8.62 |  | 220 | 3.48
 | 1255 | x |  | 6.77 |  | 18.31 |  | 1390 |  | 0.08 |  | 177.8 |  | 8.4 |  | 220 | 3.48
 | 1300 | x |  | 6.77 | 0 | 18.31 | 0 | 1389 | -1 | 0.08 | 0 | 175.9 | -1.9 | 8.3 | -0.1 | 220 | 3.48
 | Comments:
 |  | Purge start: |  |  | 12:13:00 |  |  | Sample time: |  | 13:02:00
 |  | Purge end: |  |  | 13:00:00
 | *INDICATOR PARAMETERS HAVE STABILIZED WHEN 3 CONSECUTIVE READINGS ARE WITHIN: + 0.1 for pH; + 3% for Specific Conductivity and
 | Temperature; + 10 mV for Redox Potential; and + 10% for [NAME] and Turbidity
Spreadsheet: 25540283-e8ce-4419-a424-3731f5f33a52
Sheet: Sheet1

SUBJECT: | Staff Scoring for Missouri Applications for 2013-14 STP/BR Funding | Unnamed: 2 | Unnamed: 3
This spreadsheet contains nine worksheets, which can be reached by clicking on the tabs
at the bottom of this page. The contents of the tabs are in sequential order as follows:
 | Notes (This tab)
 | All Projects -- Summary scores for all applications received in both Kansas
 |  |  | and Missouri sorted by score.
 | All Projects - MO Only -- Summary scores for all Missouri applications sorted by score
 | Bridge -- Detailed scoring for Kansas and Missouri applications in the [NAME] category
 | LC BP O -- Detailed scoring for Kansas and Missouri applications in the
 |  |  | Livable Communities, Bicycle/Pedestrian, Other category
 | Transit -- Detailed scoring for Kansas and Missouri applications in the Public
 |  |  | Transportation category
 | Capacity -- Detailed scoring for Kansas and Missouri applications in the Capacity category
 | Operations -- Detailed scoring for Kansas and Missouri applications in the
 |  |  | Transportation Operations and Management category
 | Safety -- Detailed scoring for Kansas and Missouri applications in the Transportation
 |  |  | Safety category
BACKGROUND:
The Mid-America Regional Council (MARC)initiated a project solicitation for 2013-14 Surface Transportation
Program (STP) and Bridge Restoration and Rehabilitation Program (BR) funds on July 7, 2010. Applications
were accepted until August 20, 2010 through the use of an on-line application system.  Following the
close of the application period, MARC staff developed a preliminary score using a scoring criteria previously
approved by both the Kansas and Missouri STP/BR Priorities Committees. On September 17, 2010, preliminary
staff scores were made available to project applicants.  Project applicants were provided the opportunity to
review and comment on the preliminary staff scores until September 28, 2010.  Any modifications made
during this time are reflected in this spreadsheet.
USE:
The scoring information contained in this spreadsheet is intended for the use of the Missouri STP/BR Priorities
Committee. The scores were developed to aid the committee in the project prioritization process and should not
be considered as the determining factor in the development of a funding recommendation for 2013-14 STP/BR
funding through MARC.
LAST UPDATE:
The information contained in this spreadsheet is current as of October 5, 2010.
Spreadsheet: 687246d1595062106-if-formula-for-several-date-ranges-2020-07-18-oeldere-pmc001-687191d1595014098-if-formula-for-several-date-ranges-accrual-date-
Sheet: Oeldere

 | £ | Accrual Date | Accrual Date Category > |  | Vlookup table |  |  |  |  |  |  | PO Accrual > 18 Months | 2018-12-31 00:00:00
 | 1 | 2017-01-01 00:00:00 |  |  | 1980-12-31 00:00:00 | 18 |  | 31/12/2018 |  |  |  | PO Accrual > 15 Months < 18 Months | 2019-01-01 00:00:00 | 2019-03-31 00:00:00
 | 2 | 2019-03-01 00:00:00 |  |  | 2019-01-01 00:00:00 | 15 |  | 01/01/2019-31/03/2019 |  |  |  | PO Accrual > 12 Months < 15 Months | 2019-04-01 00:00:00 | 2019-06-30 00:00:00
 | 3 | 2019-03-30 00:00:00 |  |  | 2019-04-01 00:00:00 | 12 |  | 01/01/2019-31/03/2019 |  |  |  | PO Accrual < 12 Months | 2019-07-01 00:00:00
 | 4 | 2019-04-02 00:00:00 |  |  | 2019-07-01 00:00:00 | 0 |  | 01/01/2019-31/03/2019
 | 5 | 2019-05-30 00:00:00 |  |  |  |  |  | 01/04/2019-30/06/2019
 | 6 | 2019-06-30 00:00:00 |  |  |  |  |  | 01/04/2019-30/06/2019
 |  |  |  |  | accrual > | Som van £
 |  |  |  |  | 12 | 15
 |  |  |  |  | 15 | 5
 |  |  |  |  | 18 | 1
 |  |  |  |  | Eindtotaal | 21