tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0b0d7d38-36d0-462c-a611-af2d95ec2710
Sheet: Attractions Listings

"POINT IN TIME"
EXPLORE MINNESOTA TOURISM ATTRACTIONS DATABASE | November 2010 | June 2012
Total "Active" Attractions listings | 1918 | 2216
Attractions Listing by Subcategory* ** +
[NAME] | 109 | 118
Canoe & Wilderness Outfitters | 61 | 61
Canoe / Kayak / Rowboat Rentals | 137 | 139
Casinos | 19 | 19
Downhill Ski Areas, Snowboarding, [NAME] tubing | 19 | 20
Fishing Guides & Charters | 151 | 216
Golf Courses | 277 | 284
[NAME], Sites & Tours | 322 | 334
Outdoors & Nature | 855 | 1038
Waterparks (indoor and/or outdoor) | 35 | 37
Wineries and Breweries | 26 | 39
*Select categories shown for comparison purposes only; not all subcategories are listed here due to the complex, hierarchical structure of the database.
**Database categories were reorganized in December 2010. Those shown here are ones that remained comparable.
+Many attractions are listed in multiple categories.
Spreadsheet: 150515d1334585392-subset-a-range-for-array-multiplication-2-list-sample
Sheet: Simple_Unsorted

Dataset1 |  |  |  | Dataset2
City | Response | Value1 |  | City | Response | Value2
Toronto | Yes | 30 |  | New York | Yes | 65
Orlando | Maybe | 79 |  | Detroit | No | 7
New York | Yes | 40 |  | Toronto | Yes | 46
Boston | Maybe | 10 |  | Vancouver | Yes | 24
Detroit | No | 85
Vancouver | Yes | 15
Spreadsheet: ebdce46f-43e8-48c3-ba6e-439a3a80adc9
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
EEEP | Test | EEEP | Eastern Equine Encephalitis Antibody, IgG and IgM, Serum | East [NAME], IgG and IgM, S | Immunofluorescence Assay (IFA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | IgG: <1:10 IgM: <1:10 | Monday through Friday; 9 a.m. | Same day/1 day | 4 days |  | Profile |  |  |  |  | Rochester
EEEP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EEEP | Result | 83354 | East [NAME], IgG, S | East [NAME], IgG, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29811-7
EEEP | Result | 83355 | East [NAME], IgM, S | East [NAME], IgM, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23046-6
Spreadsheet: bff339f2-129e-4b55-922d-4c24f8083b70
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | State Senate District 2 - Democratic
2012-09-11 00:00:00 | Lamb, Jr., d | [NAME], r | [NAME]
[NAME] | 96
Ashland | 116 | 1 | 1
Bridgewater | 82 | 1
Bristol | 157 |  | 2
Campton | 188 | 2 | 1
Center Harbor | 68
Danbury | 102 |  | 1
Dorchester | 16
Ellsworth | 6
[NAME] | 101 |  | 1
[NAME] | 34
Haverhill | 88 | 7
Hebron | 48 | 1
Hill | 57
Holderness | 204 | 1
Meredith | 385 | 3 | 2
New Hampton | 152
Orange | 30 | 2
Orford | 105
Piermont | 45
Plymouth | 326 | 3 | 2
Rumney | 100 | 1
Sanbornton | 252 | 2
[NAME] | 241 | 2 | 1
[NAME] | 44 | 2
Wentworth | 31 | 3
Wilmot | 153
Totals | 3227 | 31 | 11
Spreadsheet: 98904d1297718744-add-checkbox-cashnew
Sheet: Sheet1

 |  |  |  | Balance | 140000
Number | Details | Amount Debit | Amount Credit
1 | Sales |  | 24000000 | 24140000
2 | Payvender | 12000 |  | 24128000
3 | Payvender | 1300000 |  | 22828000
4 | Sales |  | 24800000 | 47628000
5 | Pay vender | 13456 |  | 47614544
6 | Sales |  | 180000000 | 227614544
7 | Pay vender | 14673 |  | 227599871
 |  |  |  | 227599871
Spreadsheet: 72805d1273531771-repeating-values-using-vlookup-function-example
Sheet: Data

NAME | VALUE
[NAME] | 300
ABC5 | 200
ABC9 | 35
ABC10 | 9000
ABC14 | 38
ABC15 | 57
ABC19 | 133
ABC20 | 132
ABC23 | 122
ABC25 | 211
Spreadsheet: 1f6f3cd3-7427-4536-88f8-0b2884f7016d
Sheet: Sheet1

Sex Offenses | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | 1993
Age Group | Total | Male | Female
12 and under | 7.574579789086322 | 13.18686383641678 | 1.689208584106976
13-14 | 92.51017563079405 | 164.2593420601744 | 17.15885492924401
15 | 98.95789225010422 | 177.3020693377385 | 16.39835948000008
16 | 93.11994742506222 | 167.4698809120816 | 14.28079219621318
17 | 88.21399471329059 | 159.1150262725085 | 12.73209111961049
18 | 91.56202448575455 | 164.8420863945593 | 14.51578034568361
19 | 78.19184850666281 | 138.2004925814546 | 15.61438112766385
20 | 79.52104750830466 | 139.5753539090179 | 16.83467456412259
21 | 79.67427236935171 | 135.9691245841544 | 20.91997991945355
22 | 81.03051402271328 | 139.7523065325896 | 20.27566000764041
23 | 79.31712960974188 | 136.5269857604724 | 20.34982969179514
24 | 81.30997763301595 | 140.8615971709311 | 20.18492034716338
25-29 | 77.76885291884457 | 135.9906246711262 | 19.1161655190607
30-34 | 71.70142064875105 | 129.4140965094453 | 14.30624144826336
35-39 | 58.45502398061891 | 109.1071978626454 | 8.361017991100239
40-44 | 43.64517022384092 | 83.06331203769868 | 5.164233664611723
45-49 | 35.05137572430795 | 69.03630107825579 | 2.290702809868409
50-54 | 27.60406247176218 | 55.39378526505433 | 1.309857317360961
55-59 | 21.42203043243099 | 44.1304540518376 | 0.4992980471228156
60-64 | 16.74427108875472 | 35.17117755312371 | 0.4441375578396066
65 and over | 7.246661770626294 | 17.70328819057982 | 0.1176017028883629
Spreadsheet: joe_parks__14706__CASHFLOWS
Sheet: Sheet1

 | Volume | 1006885
 | Sale Price | 3.13
 |  | 1000000 | 0.09
 |  | 100000 | 0.185
 | Monthly Fees
 | Pre-Petition Fees |  | oct | 108500
 |  |  | nov | 108500
 |  |  | 2 days
 |  | TOTAL
 | Post_Petition |  | 2 days
 |  |  | dec3+
 |  |  | jan | 108500
 |  |  | feb | 108500
 |  |  | [NAME]
 |  | TOTAL
 |  | Net received from Duke
 |  | Escrow Amounts |  | -224000
 |  | Escrow Fees |  | -4250
 |  | Total Escrow Dollars
 | NET
Spreadsheet: 93784d1293558046-macro-hide-unhide-upon-open-based-on-cell-value-hide-test-data
Sheet: FTE Test

[NAME]
Calculated FTEs
Department / Job Title
Week Ending Date | 2010-12-22 00:00:00
[NAME]
Servers | 10
Cooks | 3
Manager | 1
Supervisor | 2
Dishwasher | 3
Total Café
Spreadsheet: 5f70fd63-2d4c-4064-8d24-258aa78023b6
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0000884 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Mt. Olive Turkey Processing Facility | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Duplin | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Estimate
Monthly Limit:
Daily Limit:
Sample Frequency: |  |  | Monthly
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 6b72b3f0-9c43-486a-b2c7-e7ac9b899086
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Libby High School
2008
Varsity Football Schedule
Day | Date | Opponent | Site | Time
Saturday | 2008-08-30 00:00:00 | Timberlake | [NAME] | 19:00:00
Friday | 2008-09-05 00:00:00 | Frenchtown | [NAME] | 19:00:00
Friday | 2008-09-12 00:00:00 | Browning | Browning | 19:00:00
Friday | 2008-09-19 00:00:00 | [NAME] | [NAME] | 19:00:00
Friday | 2008-09-26 00:00:00 | Polson | [NAME] | 19:00:00
Friday | 2008-10-03 00:00:00 | [NAME] | [NAME] | 19:00:00
Friday | 2008-10-10 00:00:00 | Whitefish | Whitefish | 19:00:00
Friday | 2008-10-17 00:00:00 | [NAME] | [NAME] | 19:00:00
Friday | 2008-10-24 00:00:00 | Bigfork | Bigfork | 19:00:00
Saturday | Nov. 1 | 1st Round
Playoffs
 | TBA | TBA
Saturday
 | 2008-11-08 00:00:00 | Qtr. Final
Playoffs | TBA | TBA
Saturday
 | 2008-11-15 00:00:00 | Semi-Final
Round | TBA | TBA
Saturday
 | 2008-11-22 00:00:00 | State Football
Play-off
5.29.08 dmc
Libby High School
2008
JV Football Schedule
Day | Date | Opponent | Site | Time
Tuesday | 2008-09-02 00:00:00 | [NAME] | [NAME] | 16:30:00
Monday | 2008-09-08 00:00:00 | Lakeland | [NAME] | 17:00:00
Monday | 2008-09-29 00:00:00 | Polson | Polson | 16:30:00
Monday | 2008-10-06 00:00:00 | [NAME] | [NAME] | 16:30:00
Monday | 2008-10-13 00:00:00 | Whitefish | [NAME] | 17:30:00
Monday | 2008-10-20 00:00:00 | [NAME] | [NAME] | 16:30:00
05.30.08 dmc
Libby High School
2008
Freshman Football Schedule
Day | Date | Opponent | Site | Time
Saturday | 2008-08-30 00:00:00 | Timberlake | [NAME] | 16:00:00
Saturday | 2008-09-06 00:00:00 | Flathead | Flathead | 11:00:00
Saturday | 2008-09-13 00:00:00 | Sandpoint | [NAME] | 10:00:00
Saturday | 2008-09-20 00:00:00 | Glacier | [NAME] | 10:00:00
Friday | 2008-09-26 00:00:00 | Polson | [NAME] | 16:00:00
Friday | 2008-10-03 00:00:00 | [NAME] | [NAME] | 16:00:00
Friday | 2008-10-10 00:00:00 | Whitefish | Whitefish | 16:00:00
Friday | 2008-10-17 00:00:00 | [NAME] (Fr/So) | [NAME] | 16:00:00
Saturday | 2008-10-25 00:00:00 | Bigfork (Fr/So) | [NAME] | 12:00:00
Spreadsheet: 162383d1339839867-excel-2007-offset-function-help-needed-order-quiz
Sheet: ORDER

CATEGORY | [NAME] | PRODUCT | QUANT
 |  | OTVOD | 531
 |  | PIPE  PVC | 110
 |  | VENT | 862
 |  | VENT | 126
 |  | PIPE STAL | 765
 |  | [NAME] | 678
 |  | OTVOD | 173
 |  | PIPE  PVC | 511
 |  | VENT | 180
 |  | VENT | 181
 |  | PIPE STAL | 118
 |  | [NAME] | 86
 |  | OTVOD | 26
 |  | PIPE  PVC | 24
 |  | VENT | 18
 |  | VENT | 6
 |  | PIPE STAL | 20
 |  | [NAME] | 12
 |  | OTVOD | 13
 |  | PIPE  PVC | 16
 |  | VENT | 16
 |  | VENT | 4
 |  | PIPE STAL | 7
 |  | [NAME] | 1
 |  | OTVOD | 3
 |  | PIPE  PVC | 5
 |  | VENT | 9
 |  | VENT | 4
 |  | PIPE STAL | 3
 |  | [NAME] | 8
 |  | OTVOD | 2
 |  | PIPE  PVC | 1
 |  | VENT | 1
 |  | VENT | 12
 |  | PIPE STAL | 13
 |  | [NAME] | 16
 |  | OTVOD | 16
 |  | PIPE  PVC | 4
 |  | VENT | 25
 |  | VENT | 5
 |  | PIPE STAL | 1
 |  | [NAME] | 6
 |  | OTVOD | 6
 |  | PIPE  PVC | 2
 |  | VENT | 1
 |  | VENT | 1
Spreadsheet: louise_kitchen__23035__volume management key personnel
Sheet: Sheet1

gas volume management |  |  |  | mus keep
1 | [NAME] | Rita |  | *
2 | Schumack | Sherlyn |  | *
3 | Spears | [NAME] |  | *
4 | McClure | Mark
5 | Anastas | [NAME] |  | *
6 | Chance | [NAME]
7 | [NAME] | [NAME]
8 | Barkowsky | Gloria
9 | Calub | [NAME]
10 | Trabulsi | [NAME]
11 | Swisher | Stephen
12 | Randolph | [NAME]
13 | Ogunbunmi | Hakeem
14 | [NAME] | [NAME]
15 | Daily | Leonard
16 | Hu | Ming-Min
17 | Beale | [NAME]
18 | Nguyen | Nina
19 | [NAME] | [NAME]
Spreadsheet: 215342d1361353347-using-if-with-time-staff-requirements
Sheet: Formula

Order Reference | Qty | [NAME] | Tool | Machine | Customer | Product | Start Date | End Date |  |  |  | Machine 1 | Machine 2 | Machine 3 | Machine 4 | Machine 5 | Machine 6 | Machine 7 |  | Start Time
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHIFT 1 | 06:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHIFT 2 | 14:00:00
Spreadsheet: 082ef921-c924-4b9a-ab49-e4d6b5d87f81
Sheet: Sheet1

Unnamed: 0 | BELKNAP COUNTY OFFICES | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
2004-11-02 00:00:00 | Sheriff |  | Attorney |  | Treasurer |  | Reg. ofDeeds
 | Collis, r&d | [NAME] | Noether, r&d | [NAME] | Corbin, r&d | [NAME] | Normandin, r&d | [NAME]
Alton | 2619 | 10 | 2606 | 3 | 2590 | 3 | 2628 | 2
Barnstead | 1908 | 5 | 1873 | 6 | 1923 | 2 | 1930 | 2
Belmont | 2976 | 4 | 2924 | 6 | 2924 | 0 | 2982 | 0
Center Harbor | 570 | 0 | 555 | 0 | 553 | 0 | 559 | 0
Gilford | 4004 | 5 | 3940 | 8 | 3884 | 3 | 3969 | 0
Gilmanton | 1775 | 6 | 1758 | 8 | 1745 | 3 | 1760 | 2
[NAME] | 1407 | 0 | 1361 | 0 | 1367 | 0 | 1393 | 0
[NAME] | 1069 | 3 | 1060 | 2 | 1054 | 1 | 1084 | 3
[NAME] 3 | 1089 | 0 | 1062 | 0 | 1063 | 0 | 1085 | 0
[NAME] | 1142 | 5 | 1112 | 3 | 1126 | 1 | 1146 | 1
[NAME] | 986 | 2 | 955 | 6 | 962 | 1 | 982 | 1
[NAME] 6 | 1418 | 1 | 1385 | 5 | 1389 | 0 | 1414 | 0
Meredith | 3075 | 19 | 3041 | 18 | 3017 | 7 | 3040 | 7
New Hampton | 1076 | 3 | 1071 | 10 | 1066 | 0 | 1068 | 1
Sanbornton | 1479 | 6 | 1469 | 7 | 1444 | 3 | 1481 | 2
[NAME] | 1587 | 2 | 1584 | 1 | 1567 | 1 | 1595 | 0
TOTALS | 28180 | 71 | 27756 | 83 | 27674 | 25 | 28116 | 21
 |  |  |  | COUNTY COMMISSIONERS
 | Reg. Of Probate |  |  | Dist. 1 |  | District No. 2 |  | District No. 3
 | Brickner, r&d | [NAME] |  |  | [NAME], r | [NAME], d | [NAME] | Boothby, r | [NAME]
Alton | 2602 | 2 |  | NO ELECTION |  |  |  | 2343 | 10
Barnstead | 1918 | 3 |  |  | 1137 | 897 | 0
Belmont | 2916 | 0 |  |  | 1887 | 1171 | 1
Center Harbor | 541 | 1 |  |  |  |  |  | 521 | 3
Gilford | 3863 | 1 |  |  |  |  |  | 3337 | 36
Gilmanton | 1770 | 2 |  |  | 1124 | 673 | 0
[NAME] | 1359 | 0
[NAME] | 1054 | 2
[NAME] 3 | 1050 | 0
[NAME] | 1121 | 1
[NAME] | 953 | 2
[NAME] 6 | 1385 | 2
Meredith | 3015 | 8 |  |  |  |  |  | 2566 | 32
New Hampton | 1064 | 0 |  |  |  |  |  | 837 | 14
Sanbornton | 1440 | 1 |  |  | 842 | 719 | 4
[NAME] | 1585 | 0 |  |  | 872 | 734 | 0
TOTALS | 27636 | 25 |  |  | 5862 | 4194 | 5 | 9604 | 95
Spreadsheet: 115823d1311318311-if-date-then-sample-1-
Sheet: 01-01

Date | 2011-01-02 12:19:38 | Select Date |  |  |  |  |  |  |  | Hide this column
Case IDs | Completed By | Time Taken
 |  |  |  | Note: Array formula in column A & K and should be confirmed through Ctrl+Shift+Enter
 |  |  |  | Note: it is recommended to enter time in time format and display through custom format as desired
Spreadsheet: 614686d1552066557-autofill-hyperlink-and-increment-column-letter-hyperlink-help-
Sheet: Sheet2

PPE_Face Protection | PPE_Fall Protection | PPE_Foot Protection | PPE_Hard Hats | PPE_Hearing Protection | PPE_High Visibility Clothing | Contractor
N/A | N/A | Safe | Safe | N/A | N/A | 1
N/A | N/A | Safe | Safe | N/A | Safe | 1
N/A | N/A | Safe | Safe | N/A | N/A | 1
N/A | Safe | Safe | Safe | N/A | N/A | 3
N/A | N/A | Safe | Safe | N/A | At Risk | 3
N/A | N/A | N/A | Safe | N/A | Safe | 3
N/A | Safe | Safe | Safe | Safe | Safe | 3
N/A | Safe | Safe | Safe | N/A | Safe | 2
N/A | Safe | Safe | Safe | N/A | Safe | 2
Safe | Safe | Safe | Safe | Safe | Safe | 2
Safe | N/A | Safe | Safe | Safe | Safe | 2
N/A | Safe | Safe | Safe | N/A | Safe | 4
N/A | Safe | Safe | Safe | N/A | Safe | 4
N/A | Safe | N/A | Safe | N/A | Safe | 4
N/A | Safe | Safe | Safe | N/A | Safe | 5
Safe | Safe | Safe | Safe | Safe | Safe | 5
N/A | N/A | N/A | Safe | N/A | Safe | 5
N/A | N/A | N/A | Safe | N/A | Safe | 5
N/A | N/A | N/A | Safe | N/A | Safe | 5
Safe | Safe | Safe | Safe | Safe | Safe | 5
N/A | N/A | N/A | Safe | N/A | N/A | 5
Safe | Safe | Safe | Safe | N/A | Safe | 5
Safe | N/A | Safe | Safe | Safe | Safe | 6
Safe | Safe | Safe | Safe | Safe | Safe | 7
Safe | Safe | Safe | Safe | N/A | Safe | 7
Safe | N/A | Safe | Safe | N/A | Safe | 7
Count of Safe Behavior
PPE_Face Protection | PPE_Fall Protection | PPE_Foot Protection | PPE_Hard Hats | PPE_Hearing Protection | PPE_High Visibility Clothing
Spreadsheet: 93489d1293050779-defined-name-does-not-work-as-a-chart-title-example
Sheet: datasheet

DATA TABLE
Table 1
All OEMs | all data |  | data per 100k units
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13
client 1 | 9833551 | 169 | 1.7
client 2 | 442087 | 27 | 6.1
client 3 | 1618146 | 79 | 4.9
client 4 | 10711370 | 434 | 4.1
client 5 | 13682232 | 263 | 1.9
client 6 | 19566491 | 542 | 2.8
client 7 | 4189637 | 85 | 2
client 8 | 27183 | 0 | 0
client 9 | 338109 | 7 | 2.1
client 10 | 1508350 | 37 | 2.5
client 11 | 1429708 | 18 | 1.3
client 12 | 558261 | 6 | 1.1
client 13 | 5728918 | 229 | 4
client 14 | 1233456 | 12 | 1
client 15 | 13168244 | 302 | 2.3
client 16 | 1747934 | 98 | 5.6
Totals
Spreadsheet: 717132d1612499859-formula-for-last-3-characters-excel-help
Sheet: Merge1

Column1 | Column2 | [NAME]
010 | Accounting/Admin | 5001191.26
011 | Dispatch | 2147094.3
052 | HH Customer Service | 781140.1000000001
012 | Safety | 119999.88
050 | Sales | 1391985.92
015 | [NAME] | 69999.8
016 | HH Claims | 48500.14
017 | Fleet Admin | 34320
018 | Training
020 | EL Trailer Drivers | 3152142.24
021 | EL S/T Drivers | 1286836.98
051 | Customer Service | 1100064.16
022 | EL Trailer Drivers | 52000
055 | Information Technology | 764404.1599999998
023 | HH S/T Drivers
027 | Telecobuy Dedicated Trailer Drivers | 147680
046 | EL Warehouse | 3759856.88
030 | EL Helpers | 294112
031 | HH Helpers | 178880
032 | EL Summer Helpers
033 | HH [NAME]
035 | Corporate Facilities | 395047.9
039 | LF Installer | 1838184.4
040 | HH Warehouse | 141398.4
045 | P/T Warehouse | 101836.8
048 | EL Warehouse(Chicago) | 391560
056 | Billing | 335484.76
053 | Marketing
054 | MTS Protection One
057 | TAG TONNAGEACCEPTANCEGROUP
058 | Business Development | 149999.98
060 | Shop | 265760.3
Spreadsheet: 801133d1666097763-how-to-use-averageifs-and-offset-to-get-rolling-average-sampleaver
Sheet: Sheet1

1 | 1.1 | 2022-07-16 00:00:00 | 26 |  |  |  | 7 | 0.25
2 | 0.25 | 2022-07-18 00:00:00 | 7 | 2022-08-05 00:00:00 |  |  | 14 | 0.5
3 | 0.5 | 2022-07-18 00:00:00 | 14 | 2022-08-19 00:00:00 |  |  | 24 | 1
4 | 1 | 2022-07-18 00:00:00 | 24
5 | 1.2 | 2022-07-18 00:00:00 | 30
6 | 1 | 2022-07-19 00:00:00 | 24 | 2022-09-19 00:00:00
7 | 1.1 | 2022-07-19 00:00:00 | 28
8 | 1.2 | 2022-07-19 00:00:00 | 32
9 | 1 | 2022-07-20 00:00:00 | 24
10 | 1.1 | 2022-07-20 00:00:00 | 26
11 | 1 | 2022-07-20 00:00:00 | 24 | 2022-10-14 00:00:00
12 | 1.2 | 2022-07-21 00:00:00 | 32
13 | 1.25 | 2022-07-21 00:00:00 | 35
14 | 1.2 | 2022-07-21 00:00:00 | 32
15 | 1 | 2022-07-22 00:00:00 | 24 | 2022-10-04 00:00:00
16 | 1.2 | 2022-07-22 00:00:00 | 32
17 | 1.25 | 2022-07-22 00:00:00 | 35
18 | 1 | 2022-07-23 00:00:00 | 24
19 | 1.3 | 2022-07-23 00:00:00 | 36
20 | 0.25 | 2022-07-25 00:00:00 | 7 | 2022-08-18 00:00:00
21 | 1 | 2022-07-25 00:00:00 | 24
22 | 1.1 | 2022-07-25 00:00:00 | 28
23 | 1.2 | 2022-07-26 00:00:00 | 32
24 | 0.25 | 2022-07-26 00:00:00 | 7
25 | 1 | 2022-07-26 00:00:00 | 24
26 | 1.1 | 2022-07-26 00:00:00 | 27
27 | 1.2 | 2022-07-26 00:00:00 | 32
28 | 1.2 | 2022-07-27 00:00:00 | 31
29 | 1 | 2022-07-27 00:00:00 | 24
30 | 1.1 | 2022-07-27 00:00:00 | 27
31 | 1.2 | 2022-07-27 00:00:00 | 31
32 | 0.3 | 2022-07-28 00:00:00 | 9 | 2022-08-25 00:00:00
33 | 1 | 2022-07-28 00:00:00 | 24
34 | 1.1 | 2022-07-28 00:00:00 | 28
35 | 1.25 | 2022-07-28 00:00:00 | 35
36 | 0.25 | 2022-07-29 00:00:00 | 8 | 2022-08-26 00:00:00
37 | 1.1 | 2022-07-29 00:00:00 | 26
38 | 1 | 2022-07-29 00:00:00 | 24
39 | 1.2 | 2022-07-29 00:00:00 | 33
40 | 1.25 | 2022-07-29 00:00:00 | 35
41 | 1.2 | 2022-07-29 00:00:00 | 33
42 | 1.3 | 2022-08-01 00:00:00 | 35
43 | 1 | 2022-08-01 00:00:00 | 24
44 | 1.1 | 2022-08-01 00:00:00 | 28
45 | 1.25 | 2022-08-01 00:00:00 | 34
46 | 0.25 | 2022-08-02 00:00:00 | 7 | 2022-08-25 00:00:00
47 | 1 | 2022-08-02 00:00:00 | 24
48 | 1.1 | 2022-08-02 00:00:00 | 28
49 | 0.3 | 2022-08-02 00:00:00 | 9 | 2022-09-08 00:00:00
50 | 1.2 | 2022-08-02 00:00:00 | 35
51 | 1 | 2022-08-02 00:00:00 | 24
52 | 1 | 2022-08-03 00:00:00 | 24
53 | 1.1 | 2022-08-03 00:00:00 | 28
54 | 1.15 | 2022-08-03 00:00:00 | 30
55 | 1.2 | 2022-08-04 00:00:00 | 33
56 | 1.1 | 2022-08-04 00:00:00 | 27
57 | 1.2 | 2022-08-04 00:00:00 | 33
58 | 0.25 | 2022-08-05 00:00:00 | 7 | 2022-08-26 00:00:00
59 | 0.3 | 2022-08-05 00:00:00 | 8 | 2022-09-05 00:00:00
60 | 0.5 | 2022-08-05 00:00:00 | 14 | 2022-09-20 00:00:00
61 | 1.2 | 2022-08-05 00:00:00 | 33
62 | 1.25 | 2022-08-06 00:00:00 | 35
63 | 1.2 | 2022-08-08 00:00:00 | 27
64 | 1.2 | 2022-08-08 00:00:00 | 32
3102
3103
3104
3105
3106
3108
3109
3110
3112
3113
3114
3115
3116
3117
3118
3120
3121
3122
3124
3125
3126
3127
3129
3130
3131
3132
3133
3134
3136
3137
3138
3141
3142
3143
3144
3145
3146
3147
3148
3150
3151
3153
3154
3156
3157
3158
3159
3160
3161
3162
3163
3166
3167
3168
3169
3173
3174
3175
3176
3177
3178
3179
3183
3185
Spreadsheet: daren_farmer__6365__CES INFO
Sheet: ETXG

Purchase
 | From [NAME] and some Co-workers
 | Some of the vols comes off of Koch Gathering System
 | At Carthage Hub
 | For IF (Basket of Indeces) for base vols and GDA Carthage for swing vols
Sale
 | Firm Sales | To | Point | Price | Term | Volume | Sitara #
 |  | KN LP | Tailgate | I-.0325 | Thru 3/00 | 10000 | 142877
 |  | KN LP | Tailgate | Trig-.1075 | Thru 3/00 | 10000 | 142914
 |  | Western | Tailgate | I-.04 | Thru 3/00 | 10000 | 142823
 |  | East Ohio | TGT | I-.0375 | Thru 3/00 |  | 139282
 |  | Altra | Tailgate | Trig-.07 | Thru 3/00 | 10000 | 139281
 |  | TXU Lonestar | Lonestar | I-.0275 | Thru 2/00 | 10000 | 142910
 |  | TXU Lonestar | Lonestar | I-.025 | Thru 2/00 | 3500 | 142904
 | Swing Sales
 |  | TXU Lonestar | LS - Call | GD+.02 | Thru 3/00 | 20000 | 149978 | 159483
 |  | Remaining volumes are sold mostly as baseload
Other
 | [NAME] nominates these volumes 3-6673
 | We are using HPL's Cartwheel agreement
 | Some gas is transported off [NAME]
 |  | All of the gas is given at the tailgate
 | TXU Lonestar Call Gas
 |  | Duke En Field Services determines if the TXU call gas will operationally flow
 |  |  | [NAME]
 |  | [NAME] [PHONE]
 |  |  | He will determine if they call on the gas
 |  |  | GD Carthage+.02
 |  |  | 11/99 - 3/31/00
 |  |  | No [NAME]
 |  |  | Min is 300,000 for term
 |  |  | Either at LS at the Header or [NAME]
 |  |  | The gas has been called on 5 times but was not taken because
 |  |  |  | DEFS couldn't move the gas. It still counts toward
 |  |  |  | the minimum
Deal Numbers
 | Purchase |  | Sale |  | Meters
 | 139257 | 142805 | 139281 |  | 4609001 | ETGS/Lonestar - Panola
 | 142574 | 142806 | 139282 |  | 4607001 | Eastrans/HPL-Carthage Hub
 | 142577 | 142807 | 142823
 | 142580 | 142808 | 142877
 | 142582 | 142809 | 142904
 | 142583 | 142810 | 142910
 | 142590 | 142811 | 142914
 | 142608 | 143567
 | 142611 | 144905
 | 142613 | 144909
 | 142625 | 144912
 | 142795 | 144914
 | 142796 | 144917
 | 142797 | 144918
 | 142798 | 144922
 | 142799 | 144927
 | 142801 | 144932
 | 142802 | 144933
 | 142803 | 144936
 | 142804 | 145111
Spreadsheet: 274657d1383173110-searching-for-values-within-a-range-format-in-range
Sheet: Sheet1

 | Search for: | 29
Spreadsheet: 829801d1684449521-index-match-with-2-inputs-1-string-1-number-but-needs-to-find-equal-or-less-than-test
Sheet: Sheet5

model | type | load |  | wall
FXSQ05TAVJU | DUCTED | 5800 |  | 200
FXFQ07TVJU | CASSETTE | 7200
FXSQ07TAVJU | DUCTED | 7500
FXAQ07PVJU | WALL | 7500
FXFQ09TVJU | CASSETTE | 9500
FXSQ09TAVJU | DUCTED | 9500
FXAQ09PVJU | WALL | 9500
FXFQ12TVJU | CASSETTE | 12000
FXSQ12TAVJU | DUCTED | 12000
FXAQ12PVJU | WALL | 12000
FXFQ15TVJU | CASSETTE | 14000
FXSQ15TAVJU | DUCTED | 15000
FXFQ18TVJU | CASSETTE | 18000
FXSQ18TAVJU | DUCTED | 18000
FXAQ18PVJU | WALL | 18000
FXFQ24TVJU | CASSETTE | 23000
FXSQ24TAVJU | DUCTED | 24000
FXAQ24PVJU | WALL | 24000
FXFQ30TVJU | CASSETTE | 30000
FXSQ30TAVJU | DUCTED | 30000
FXFQ36TVJU | CASSETTE | 36000
FXSQ36TAVJU | DUCTED | 36000
FXFQ48TVJU | CASSETTE | 48000
FXSQ48TAVJU | DUCTED | 48000
FXSQ54TAVJU | DUCTED | 54000