tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 723953d1615971402-formula-to-point-up-a-specified-gap-in-timeframe-location-date-and-time
Sheet: Sheet1

 |  | Date and Time
 |  | 15/03/2021 12:15:33
 |  | 15/03/2021 13:15:33
 |  | 15/03/2021 14:15:33
 |  | 15/03/2021 15:15:33
 |  | 15/03/2021 16:15:33
 |  | 15/03/2021 17:15:33
 |  | 15/03/2021 18:15:33
 |  | 15/03/2021 19:15:33
 |  | 15/03/2021 20:05:33
 |  | 15/03/2021 20:15:33
 |  | 15/03/2021 21:15:33
 |  | 15/03/2021 22:15:33
 |  | 15/03/2021 23:15:33
 |  | 15/03/2021 23:51:51
 |  | 15/03/2021 23:52:36
 |  | 15/03/2021 23:52:40
 |  | 16/03/2021 00:11:55
 |  | 16/03/2021 00:44:00
 |  | 16/03/2021 00:52:35
 |  | 16/03/2021 01:52:35
 |  | 16/03/2021 02:52:35
 |  | 16/03/2021 03:52:35
 |  | 16/03/2021 04:52:35
 |  | 16/03/2021 05:52:35
 |  | 16/03/2021 06:52:35
 |  | 16/03/2021 07:32:38
 |  | 16/03/2021 07:40:08
 |  | 16/03/2021 08:28:10
 |  | 16/03/2021 09:40:07
 |  | 16/03/2021 13:40:07
 |  | 16/03/2021 15:40:07
 |  | 17/03/2021 01:40:07
 |  | 17/03/2021 03:40:07
 |  | 17/03/2021 05:40:07
 |  | 17/03/2021 06:43:44
 |  | 17/03/2021 06:51:08
 |  | 17/03/2021 06:54:15
 |  | 17/03/2021 06:56:36
Spreadsheet: 884553d1733792503-summary-tabs-for-a-large-spreadsheet-equipment-list-excel-forum
Sheet: 4x4 Pickups

 | Model | Description | Brand | Operator | Status | Availability | Location | Specs/Details
1 | NAVARRA PROX4 | [NAME] | NISSAN | [NAME] | Operational | NO | Location 1 | 4x4 (white)
2 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 2 | 4x4 (meteor gray)
3 | RANGER SPORT | [NAME] | FORD | [NAME] | Non-operational | NO | Location 3 | 4x4 (meteor gray)
4 | NAVARRA PROX4 | [NAME] | NISSAN | [NAME] | Operational | NO | Location 4 | 4x4 (gray)
5 | RANGER | [NAME] | FORD | [NAME] | Operational | NO | Location 5 | 4x4 (silver)
 | RANGER | [NAME] | FORD | [NAME] | Operational | NO | Location 6 | 4x4 (black)
6 | RANGER | [NAME] | FORD | [NAME] | Operational | NO | Location 7 | 4x4 (black)
 | RANGER | [NAME] | FORD | [NAME] | Operational | NO | Location 8 | 4x4 (silver)
7 | RANGER | [NAME] | FORD | [NAME] | Operational | NO | Location 9 | 4x4 (silver)
 | RANGER | [NAME] | FORD | [NAME] | Operational | NO | Location 10 | 4x4 (silver)
10 | ISUZU DMAX | [NAME] | ISUZU | [NAME] | Operational | NO | Location 11 | 4x4 (Black)
11 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 12 | 4x4 (blue)
12 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 13 | 4x4 (blue)
13 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 14 | 4x4 (blue)
14 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 15 | 4x4 (blue)
15 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 16 | 4x4 (blue)
16 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 17 | 4x4 (blue)
17 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 18 | 4x4 (blue)
18 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 19 | 4x4 (blue)
19 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 20 | 4x4 (black)
20 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 21 | 4x4 (white)
21 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 22 | 4x4 (meteor gray)
22 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 23 | 4x4 (black)
23 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 24 | 4x4 (white)
24 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 25 | ++
25 | RANGER SPORT | [NAME] | FORD | [NAME] | Operational | NO | Location 26 | 4x4 (meteor gray)
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 375987d1423435845-taking-multiple-excel-documents-and-grouping-the-data-into-a-single-spreadsheet-apollo-ver1
Sheet: Sheet1

Reservations: |  | 0
Name | Date | # | Guest Name | Date | # Of Guests | Service Provided | Res. ID | Add-On Detail | Revised | *Payments /POA | **Sent
Vince | 2015-02-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 | 4 | Tram | 24263819 | - | - | 43 | E
Vince | 2015-02-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 | 2 | Tram | 24263845 | - | - | 17 | D
Vince | 2015-02-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 | 5 | Tram | 24264127 | - | - | 43 | E
Vince | 2015-02-07 00:00:00 | 1 | [NAME] | 2015-02-08 00:00:00 | 2 | Tram | 24264460 | - | - | 23 | E
Spreadsheet: 147630d1332893260-need-help-populating-data-on-new-spreadsheet-from-extracted-pdf-information-ef69_for-forum-help
Sheet: Example of Excel data pull

ID | CLIENT | YR | LOAN_NUMBER | TYPE | date_dt_fmt | TIME | USER_ID | COMMENT
1 | 515 | 2011 | [PHONE] | FOR | 08/16/2011 | 103219 | OKF | 08/14/11 PROPERTY IS VACANT AND NOT SECURE.       CONTRACTOR COMPLETED WINTERIZATION.
1 | 515 | 2011 | [PHONE] | FOR | 08/18/2011 | 143423 | REF | 8/7/11 PROPERTY IS VACANT AND SECURE              CONTRACTOR COMPLETED RESECURE                     WINTERIZATION INTACT
1 | 515 | 2011 | [PHONE] | FOR | 08/18/2011 | 175144 | FYS | TRANSFER TO RIZ FROM QUY VIA SCRIPT
1 | 515 | 2011 | [PHONE] | HAZ | 08/19/2011 | 083437 | ZSH | [NAME], ALLSTATE INSURANCE, POLICY NO: 011598241.  ISSUED: 8/13/2011  EFFECTIVE:     8/13/2011 FORECLOSURE AND FORCED PLACE COVERAGE   IS ALREADY IN PLACE. HIPC.
1 | 515 | 2011 | [PHONE] | FOR | 08/22/2011 | 092620 | REF | 7/19/11 CONTRACTOR COMPLETED INITIAL SECURE       BID #796472 WAS SUBMITTED INTO HUD:               EXT DEBRIS; $850.00                               INT DEBRIS: $2,250.00                             INSTALL PLYWOOD DOOR: $250.0
Spreadsheet: 798569d1664555435-a-way-to-display-a-next-date-based-on-either-weeks-or-months-date_v2
Sheet: Domestic

Totals
Unpaid
Paid
Date | Address | Frequency Weeks | PCM | Price | Next Clean Date | Next Date | Paid? | Notes | Last Operator | Per Calendar Month Test
2022-10-05 00:00:00 | 74 [NAME] |  | 3 | 10 |  |  | N
 | 98 Glenheadon Rise | 4 |  | 15 |  |  | Y
2022-10-05 00:00:00 | 38 Cleveland Lawn | 8 |  | 25 |  |  | N
2022-10-05 00:00:00 | 19 Woodlands Crescent | 8 |  | 8 |  |  | N
2022-10-05 00:00:00 | 64 Apple Tree Farm | 8 |  | 30 |  |  | N
2022-10-05 00:00:00 | 19 Woodlands Crescent | 8 |  | 12 |  |  | N
2022-10-04 00:00:00 | 27 Wheatfield Road North | 4 |  | 25 |  |  | N
2022-10-04 00:00:00 | 27 Parkland Coppice | 4 |  | 20 |  |  | Y
2022-10-04 00:00:00 | 89 Russet Row | 4 |  | 10 |  |  | Y
2022-10-04 00:00:00 | 31 Camp Gait | 8 |  | 8 |  |  | Y
2022-10-04 00:00:00 | [NAME] | 8 |  | 40 |  |  | Y
2022-10-05 00:00:00 | 74 [NAME] | 4 |  | 12 |  |  | N
2022-10-05 00:00:00 | 98 Glenheadon Rise | 4 |  | 12 |  |  | N
2022-10-05 00:00:00 | 38 Cleveland Lawn | 8 |  | 8 |  |  | Y
2022-10-05 00:00:00 | 19 Woodlands Crescent | 4 |  | 10 |  |  | Y
2022-10-05 00:00:00 | 64 Apple Tree Farm | 4 |  |  |  |  | Y
Spreadsheet: 707988d1607574285-find-the-column-number-of-the-first-instance-of-a-column-with-data-demo-file
Sheet: Worksheet

Concat | Employee | Pay Date | Type | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri2 | Sat2 | Sun2 | Mon2 | Tue2 | Wed2 | Thu2
 | Employee 1 | 2020-02-20 00:00:00 |  |  |  |  | 8 | 8.5 | 8 | 9 | 7 | 5 |  | 4 | 8 | 4
 | Employee 1 | 2020-05-15 00:00:00 |  |  |  |  |  |  | 6 | 4 |  | 3 |  | 5 | 7 | 4 | 6
 | Employee 2 | 2020-05-15 00:00:00 |  |  |  | 8 | 7 | 7 |  | 6
 | Employee 1 | 2020-05-29 00:00:00 |  |  |  |  |  | 8 |  |  |  |  |  | 8 | 8 | 8 | 8
 | Employee 2 | 2020-05-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 8 | 8
Employee: | Employee 2
Date: | 2020-05-15 00:00:00
 |  |  |  |  |  |  | Concat |  | Expected Column Number
 |  |  |  |  |  |  | Employee 1 - 43881
 |  |  |  |  |  |  | Employee 1 - 43966
 |  |  |  |  |  |  | Employee 2 - 43966
Get the first column number in $[NAME] with data in it. |  |  |  |  |  |  | Employee 1 - 43980
 |  |  |  |  |  |  | Employee 2 - 43980
=INDEX(Worksheet,MATCH(B10&" - "&B11,Worksheet[Concat],0),???)
Spreadsheet: 105438d1302788973-excel-2007-schedule-help-schedule
Sheet: Schedule by name

 | 7,00-8,00 | 8,00-9,00 | 9,00-10,00 | 10,00-11,00 | 11,00-12,00 | 12,00-13,00 | 13,00-14,00 | 14,00-15,00 | 15,00-16,00 | 16,00-17,00 | 17,00-18,00 | 18,00-19,00 | 19,00-20,00 | 20,00-21,00 | 21,00-22,00 |  | MORNING SHIFT | AFTERNOON SHIFT
2011-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
2011-04-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 7
2011-04-03 00:00:00
2011-04-04 00:00:00
2011-04-05 00:00:00
2011-04-06 00:00:00
2011-04-07 00:00:00
2011-04-08 00:00:00
2011-04-09 00:00:00
2011-04-10 00:00:00
2011-04-11 00:00:00
2011-04-12 00:00:00
2011-04-13 00:00:00
2011-04-14 00:00:00
2011-04-15 00:00:00
2011-04-16 00:00:00
2011-04-17 00:00:00
2011-04-18 00:00:00
2011-04-19 00:00:00
2011-04-20 00:00:00
2011-04-21 00:00:00
2011-04-22 00:00:00
2011-04-23 00:00:00
2011-04-24 00:00:00
2011-04-25 00:00:00
2011-04-26 00:00:00
2011-04-27 00:00:00
2011-04-28 00:00:00
2011-04-29 00:00:00
2011-04-30 00:00:00
Spreadsheet: 675696d1588432394-incorrect-value-displayed-in-referenced-cells-excel-sample-emanexcel-
Sheet: Sheet1

 | Dishwasher | Cooktop | Oven | Rangehood |  | Dishwasher | Cooktop | Oven | Rangehood
 |  |  |  |  |  | 1500 | 1400 | 1400 | 1500
 | Project Allocation | Total | DIFF
Proj | 4652
Act
Spreadsheet: 270070d1381360022-attrition-and-skip-months-security-company
Sheet: Sheet1

 | Projected
 | Month |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36
 | 30 day Installs |  | 5 | 7 | 9 | 11 | 20 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
 | [NAME] |  | 0
 | Online
 | 30 day P&L
 | YTD Investment
 | Net Worth
 | Varibles
 | Monitoring
 | Monitor Fee | 4
 | Monitor charge | 34.95
 | # free months | 3
 | attrition | 0.06
 | Expenses
 | Sales | 0
 | install | 75
 | cell | 0
 | panel | 354
 | Profit
 | down payment | 199
 | upsale | 25
 | Assets
 | Multiples | 42
Spreadsheet: 155911d1337101609-how-to-add-rank-to-pivot-table-pe_list-test-edited-
Sheet: Total

Company | Opportunities | People | Rewards and Recognition | Work | Work Environment |  | Company | Opportunities | People | Rewards and Recognition | Work | Work Environment
Rank Importance | Rank Importance | Rank Importance | Rank Importance | Rank Importance | Rank Importance |  | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction
mno.stu
Company | Opportunities | People | Rewards and Recognition | Work | Work Environment |  | Company | Opportunities | People | Rewards and Recognition | Work | Work Environment
Rank Importance | Rank Importance | Rank Importance | Rank Importance | Rank Importance | Rank Importance |  | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction
jkl.vwx
Company | Opportunities | People | Rewards and Recognition | Work | Work Environment |  | Company | Opportunities | People | Rewards and Recognition | Work | Work Environment
Rank Importance | Rank Importance | Rank Importance | Rank Importance | Rank Importance | Rank Importance |  | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction
abc.xyz
Company | Opportunities | People | Rewards and Recognition | Work | Work Environment |  | Company | Opportunities | People | Rewards and Recognition | Work | Work Environment
Rank Importance | Rank Importance | Rank Importance | Rank Importance | Rank Importance | Rank Importance |  | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction
def.ghi
Company | Opportunities | People | Rewards and Recognition | Work | Work Environment |  | Company | Opportunities | People | Rewards and Recognition | Work | Work Environment
Rank Importance | Rank Importance | Rank Importance | Rank Importance | Rank Importance | Rank Importance |  | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction
bvd.huy
Company | Opportunities | People | Rewards and Recognition | Work | Work Environment |  | Company | Opportunities | People | Rewards and Recognition | Work | Work Environment
Rank Importance | Rank Importance | Rank Importance | Rank Importance | Rank Importance | Rank Importance |  | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction | Rate Satisfaction
ELM - HRT
ELM - Exit
Onboarding
Scheduling
Screening
Spreadsheet: darrell_schoolcraft__7864__Griffith1001
Sheet: Allocation

 | Citizens Arizona Gas
 | Balance Tracking Report |  |  |  |  |  |  | 2001-10-01 00:00:00
 | Imbalance Between Citizens Receipts and Deliveries
 | Plant Inlet from Transwestern |  |  |  |  |  |  | Plant Inlet from El Paso |  |  |  |  |  |  | Total
 |  |  |  |  | Physical Imabalance |  |  |  |  |  |  | Physical Imabalance |  |  |  |  | Physical Imabalance |  |  | Delivery Allocation |  | Pipeline Allocation to Shippers |  |  |  | Net Del. Alloc.
 | Total |  |  | Scheduled | Day | Cummulative |  | Total |  |  | Scheduled | Day | Cummulative |  |  | Scheduled | Day | Cummulative |  | Dth |  | DETM (Dth) |  | PPL (Dth) |  | Dth
Day | Mcf | Btu | Dth | Dth | Dth | Dth |  | Mcf | Btu | Dth | Dth | Dth | Dth |  | Dth | Dth | Dth | Dth |  | DETM | PPL | TW | EPNG | TW | EPNG | DETM | PPL
1 | -91907 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 93082
 | -72877 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 73789
 | -66212 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 67333
 | -74784 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 76510
 | -77600 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 79372
 | -81189 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 82768
 | -77463 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 78642
 | -1022 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 966
 | -22383 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 22765
 | -84440 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  | 0 | 85760
 | -68327 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 69199
 | -78303 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 79127
 | -73788 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 74764
 | -73023 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 73989
 | -73889 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 74877
 | -73072 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 73988
 | -43594 | 1.017 |  |  |  |  |  |  | 1.014 |  |  |  |  |  |  |  |  |  |  |  |  | 43320
 |  | 1.017 |  |  |  |  |  |  | 1.014
 |  | 1.017 |  |  |  |  |  |  | 1.014
 |  | 1.017 |  |  |  |  |  |  | 1.014
 |  | 1.017 |  |  |  |  |  |  | 1.014
 |  | 1.017 |  |  |  |  |  |  | 1.014
 |  | 1.017 |  |  |  |  |  |  | 1.014
 |  | 1.017 |  |  |  |  |  |  | 1.014
 |  | 1.017 |  |  |  |  |  |  | 1.014
 |  | 1.017 |  |  |  |  |  |  | 1.014
 |  | 1.017 |  |  |  |  |  |  | 1.014
 |  | 1.017 |  |  |  |  |  |  | 1.014
 |  | 1.017 |  |  |  |  |  |  | 1.014
 |  | 1.017 |  |  |  |  |  |  | 1.014
 |  | 1.017 |  |  |  |  |  |  | 1.014
Total
Spreadsheet: 102151d1300177737-multi-criteria-sumproduct-name-range-query-2011-03-15-ns-sample
Sheet: Sample

 |  |  | Selection
 |  |  | # | Category | Include?
 |  |  | 1 | Electricals | Yes
 |  |  | 2 | Paper | Yes
 |  |  | 3 | Food | Yes
 |  |  | 4 | Beverages | No
 |  |  | 5 | Pets | No
 |  |  | 6 | Cosmetics | No
 |  | Sales
 |  | Year | Month | Category | Quantity
 |  | 2010 | 1 | Electricals | 5
 |  | 2010 | 1 | Paper | 434
 |  | 2010 | 2 | Electricals | 23
 |  | 2010 | 2 | Food | 13
 |  | 2010 | 3 | Beverages | 2323
 |  |  | Summary / Report
 |  |  | Year | Month | Quantity
 |  |  | 2010 | 1 | 439 | This quantity should be only for the selected categories in first sheet
 |  |  | 2010 | 2 | 36 | This quantity should be only for the selected categories in first sheet
 |  |  | 2010 | 3 | 2323 | This quantity should be only for the selected categories in first sheet
Spreadsheet: 00e4edac-16e7-4065-b2e0-d5be109c42e0
Sheet: Sheet1

Instructions: 1. Save this file into new circular directory. Do "save as" s:\shared\circular\0007. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
2. Update cells [NAME], D7, & E7  w/new months (ie change  Feb to March & March to April).
3.  Update prices.
4. On final sheet, replace "ERR" with "n/a"
NASS Agricultural Prices
 | Domestic | 2001 | 2002 |  | % Change | % Change
Commodity | units | Oct | Sep | [NAME] | Last Month | Last Year
 |  | Dollars/unit
Grapefruit   2/ | Box | 6.53 | 5.81 | 5.1 | -0.1222030981067126 | -0.2189892802450231
Lemons   2/ | Box | 19.12 | 15.97 | 16.82 | 0.05322479649342515 | -0.1202928870292887
Limes   2/ | Box | 0 | 0 | 0
Oranges   2/ | Box | 4.99 | 6.31 | 4.71 | -0.2535657686212361 | -0.05611222444889784
Tangelos   2/ | Box | 0 | 0 | 0
Tangerines   2/ | Box | 8.23 | 0 | 8.37 |  | 0.01701093560145793
Temples   2/ | Box | 0 | 0 | 0
Apples, fresh  3/ | [NAME]. | 0.248 | 0.3 | 0.301 | 0.003333333333333337 | 0.2137096774193548
Grapes | Ton | 640 | 650 | 640 | -0.01538461538461539 | 0
Peaches | [NAME]. | 0 | 0.278 | 0 | -1
Pears, fresh  3/ | Ton | 390 | 474 | 458 | -0.03375527426160337 | 0.1743589743589744
Strawberries, fresh | [NAME]. | 0.807 | 0.584 | 0.69 | 0.1815068493150685 | -0.1449814126394053
Asparagus  4/ | [NAME]. | 137 | 0 | 0 |  | -1
Broccoli   4/ | [NAME]. | 24.2 | 40.6 | 23 | -0.4334975369458128 | -0.04958677685950411
Cantaloupes | [NAME]. | 15.7 | 14 | 15 | 0.07142857142857142 | -0.04458598726114645
Carrots   4/ | [NAME]. | 17.5 | 19 | 17.3 | -0.08947368421052627 | -0.01142857142857139
Cauliflower   4/ | [NAME]. | 21.7 | 23 | 19.6 | -0.1478260869565217 | -0.096774193548387
Celery   4/ | [NAME]. | 8.22 | 11.7 | 9.58 | -0.1811965811965811 | 0.1654501216545011
[NAME]4/ | [NAME]. | 23.8 | 20.7 | 19 | -0.08212560386473426 | -0.2016806722689076
Cucumbers   4/ | [NAME]. | 14.2 | 17.7 | 13.3 | -0.2485875706214689 | -0.06338028169014075
Lettuce   4/ | [NAME]. | 11.5 | 14.3 | 12.3 | -0.1398601398601398 | 0.0695652173913044
Onions   4/ | [NAME]. | 9.2 | 11 | 10.6 | -0.0363636363636364 | 0.1521739130434783
Snap Beans  4/ | [NAME]. | 63.1 | 68.1 | 52 | -0.2364170337738619 | -0.1759112519809826
Tomatoes   4/ | [NAME]. | 28.6 | 22.2 | 23.5 | 0.05855855855855859 | -0.1783216783216784
1/  Preliminary
2/  Equivalent on-tree returns.
3/  Equivalent packinghouse-door returns for CA and NY (apples only), OR (pears only), and
WA (apples,  peaches, and pears).  Prices as sold for other states.
4/  Fresh-market, FOB shipping point.
Note: Zeroes indicate insufficient information or insufficient sales to establish a price.
Source:  National Agricultural Statistics Service (NASS), USDA.
Spreadsheet: 09229d0d-d2e0-42c5-9381-aa2d36b0dae8
Sheet: Location Summary

Summary of Sample Locations for Distribution System Water Quality Changes - City of Longview, WA
No | Location | Test Location | Zone ID | Zone | Frequency | Site Condition | Pipe Material
1 | 136 Tanglewood Drive | [NAME]. | 653 | [NAME] | Weekly for 2 weeks | Control Area | Ductile Iron
 | 1824 Coal Creek Rd. | [NAME]. | 502 | Upper Coal Creek | Weekly for 2 weeks | Control Area | Lined Cast lron
 | 1051 Coal Creek Rd. | [NAME]. | 415 | Niemi | Weekly for 2 weeks | Control Area | Lined Cast lron
 | 150 Clark Creek Ln. | [NAME]. | 395 | [NAME] | Weekly for 2 weeks | Control Area | Lined Cast lron
 | 2770 48th Avenue | [NAME]. | 244 | Main | Weekly | Control Area | Lined Cast lron
 | 16 Clearview Drive | [NAME]. | 488 | Lower Columbia View | Weekly for 2 weeks | Control Area | Ductile Iron
 | 188 Curtis Drive | [NAME]. | 660 | - | Weekly for 2 weeks | Control Area | Ductile Iron
 | 3747 Sunset Way | [NAME]. | 318 | Lower Ammons | Weekly for 2 weeks | Control Area | Lined Cast lron
 | 3170 N. Ammons Dr. | [NAME]. | 506 | [NAME] | Weekly for 2 weeks | Control Area | Lined Cast lron
 | 3544 [NAME] | [NAME]. | 463 | Ammons | Weekly for 2 weeks | Control Area | Lined Cast lron
 | 2302 Cedar Place | [NAME]. | 286 | Lower Hillcrest | Weekly for 2 weeks | Control Area | Lined Cast lron
 | 2430 Park Hill Dr. | [NAME]. | 481 | Hillcrest | Weekly for 2 weeks | Control Area | Lined Cast lron
 | 1155 Weber Ave (MFRWTP) | Finished Water SA-22 (Lab) | 244 | Main | Weekly | Point of Entry | Ductile Iron
 | 2853 Florida St. | Hydrant | 244 | Main | Weekly | Known Problem Area | Unlined Cast Iron
 | 2105 Larch St. | Hydrant | 244 | Main | Weekly | Known Problem Area | Unlined Cast Iron
 | 345 19th Ave. | Hydrant | 244 | Main | Weekly | Known Problem Area | Unlined Cast Iron
 | 640 17th Ave. | Hydrant | 244 | Main | Weekly | Known Problem Area | Unlined Cast Iron
 | 1110 Commerce | Hydrant | 244 | Main | Weekly | Emerging Problem Area | Unlined Cast Iron
 | 101 Fishers Ln (BHWSD Intertie) | Hydrant | 244 | Main | Weekly | Point of Entry (BHWSD) | Steel
 | Hillside PS (BHWSD Intertie) | Pump Suction | 244 | Main | Weekly | Point of Entry (BHWSD) | Lined Cast lron
 | Maplewood Dr. x [NAME]. | Hydrant | 481 | Hillcrest | Weekly for 2 weeks | Point of Entry (BHWSD) | Lined Cast lron
 | 7337 Willow Grove | Hydrant | 244 | Main | Weekly | Control Area | Ductile Iron
 | 5403 Oriole Dr. | [NAME]. | 244 | Main | Weekly | Control Area | Ductile Iron
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
Spreadsheet: 59624d1260217146-excel-2007-checking-a-range-of-dates-with-if-or-select-case-example1
Sheet: TA2009-15

FLEXIBLE SCHEDULE CERTIFICATION FORM
NAME: |  |  |  |  |  |  |  |  |  |  |  | Established Hours:
 |  |  |  |  |  |  |  |  |  |  |  | M |  |  | M:
ORG: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  |  |  |  |  |  |  |  |  |  |  | W |  |  | W:
PP Ending: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  | PP | 09-15 |  |  |  |  |  |  |  |  | F: |  |  | F:
 |  | Working Hours |  | Time in Duty Status |  |  |  | *Telework Hours |  | Credit Hours |  |  | [NAME]
Date |  | Arrive | [NAME] | Regular | Overtime | Comp | Holiday | Worked | Code | Earned | Used | Balance | Annual | Sick | Comp | LWOP | Other | Remarks
Previous Balance
S
M
T
W
T
F
S
S
M
T
W
T
F
S
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PAYABLE HRS.
Totals
 | Employee Signature: |  |  |  |  |  |  |  |  |  | Supervisor Signature:
 |  |  |  |  |  |  |  |  |  |  |  | *Telework Indicator Codes
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | "Fixed" Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | C | 3 or more days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | F | 2 or fewer days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | “As Needed” Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | I | Work performed at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | The Telework columns are to be left blank for those employees who did not work at an alternate worksite during the Pay Period.
MOST EMPLOYEES SHOULD HAVE NO BALANCE IN LWOP.