tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0e4bba8e-2264-4c3a-bef1-240d9520122b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-07-22 09:18:54.560000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 101.373 | 101.248 | 101.123 | 100.748
4.625 | 100.502 | 100.377 | 100.252 | 99.877 |  | Note: | Refer To Price [NAME]
4.5 | 100.025 | 99.9 | 99.775 | 99.4 |  |  | For all Price Adjs
4.375 | 99.402 | 99.277 | 99.152
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.672 | 101.547 | 101.422 | 101.047
4 | 101.326 | 101.201 | 101.076 | 100.701
3.875 | 100.933 | 100.808 | 100.683 | 100.308
3.75 | 100.379 | 100.254 | 100.129 | 99.754
3.625 | 99.455 | 99.33 | 99.205
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-08-05 09:18:54.560000
30 DAY | 2011-08-20 09:18:54.560000
45 DAY | 2011-09-04 09:18:54.560000
60 DAY | 2011-09-19 09:18:54.560000
90 DAY | 2011-10-19 09:18:54.560000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: tracy_geaccone__40425__enron corp infomation request - Nov 2001
Sheet: Europe Burn

 |  |  |  | YTD |  | Forecast Cash Expenditures
 |  | Headcount Actual (9/30) |  | Cash Expenditures |  | October |  | November |  | December |  | January |  | February |  | March |  | Comments
Metals
Credit
Gas Trading
Continental Power Power Trading
Bilaterial Power Trading
Corp  Finance Origination
Asset Management
Continental Europe
Australia
Scandinavia
SE Europe
Switzerland/Austria
Germany
Spain/Portugal
Benelux/Italy
Japan
Teesside
ETOL
Other
Analysts/Associates
Total
Depreciation & Amortization |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Taxes Other Than Income |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total Expenses net of Capitalized Expense
Plus:  Capital Expenditures |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Cash Payments |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Less: DD&A
 |  |  |  |  |  | 0
Total Cash Burn Rate
Spreadsheet: 219541d1362778808-autopopulate-formula-from-two-columns-of-data-grocery-list
Sheet: Sheet1

Groceries List | Price |  | Groceries with a Price | Price
a | 1
b
c | 3
d | 8
e
f
g | 6
h | 6
i | 6
j | 6
Spreadsheet: 036b3b9b-f639-46af-87a5-69089346419e
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
 | 5625.0 Private New Capital Expenditure and Expected Expenditure, Australia
 | TABLE 10A. Actual and Expected Capital Expenditure by Asset - Western Australia:Current Prices $m
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Actual Expenditure ;  Western Australia ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3516679C | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Actual Expenditure ;  Western Australia ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3516721W | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Actual Expenditure ;  Western Australia ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3516763V | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  Western Australia ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3516681R | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  Western Australia ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3516723A | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  Western Australia ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3516765X | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  Western Australia ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3516680L | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  Western Australia ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3516722X | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  Western Australia ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3516764W | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 803046d1667231615-need-help-with-if-formula-based-on-date-and-time-labor-cost
Sheet: HoursEarningsByRangeExport_10_2

[NAME] | Punch Time In | Punch Time Out | 2022-10-27 04:00:00 | 2022-10-27 05:00:00 | 2022-10-27 06:00:00 | 2022-10-27 07:00:00 | 2022-10-27 08:00:00 | 2022-10-27 09:00:00 | 2022-10-27 10:00:00 | 2022-10-27 11:00:00 | 2022-10-27 12:00:00 | 2022-10-27 13:00:00 | 2022-10-27 14:00:00 | 2022-10-27 15:00:00 | 2022-10-27 16:00:00 | 2022-10-27 17:00:00 | 2022-10-27 18:00:00 | 2022-10-27 19:00:00 | 2022-10-27 20:00:00 | 2022-10-27 21:00:00 | 2022-10-27 22:00:00 | 2022-10-27 23:00:00 | 2022-10-28 00:00:00 | 2022-10-28 01:00:00 | 2022-10-28 02:00:00 | 2022-10-28 03:00:00
20 | 2022-10-27 00:01:00 | 2022-10-27 06:00:00
17 | 2022-10-27 07:47:00 | 2022-10-27 16:00:00
19 | 2022-10-27 07:53:00 | 2022-10-27 15:07:00
43.27 | 2022-10-27 07:58:00 | 2022-10-27 16:58:00
20 | 2022-10-27 08:01:00 | 2022-10-27 15:44:00
19 | 2022-10-27 08:03:00 | 2022-10-27 16:05:00
20 | 2022-10-27 08:10:00 | 2022-10-27 16:06:00
18 | 2022-10-27 08:15:00 | 2022-10-27 16:05:00
17 | 2022-10-27 08:27:00 | 2022-10-27 16:13:00
9.24 | 2022-10-27 09:43:00 | 2022-10-27 15:20:00
18 | 2022-10-27 09:55:00 | 2022-10-27 20:29:00
20 | 2022-10-27 10:07:00 | 2022-10-27 16:23:00
10 | 2022-10-27 10:14:00 | 2022-10-27 22:09:00
43.27 | 2022-10-27 09:45:00 | 2022-10-27 20:17:00
12.5 | 2022-10-27 13:03:00 | 2022-10-28 00:52:00
9.24 | 2022-10-27 14:53:00 | 2022-10-27 21:04:00
9.24 | 2022-10-27 14:56:00 | 2022-10-27 21:46:00
9.24 | 2022-10-27 14:57:00 | 2022-10-27 21:51:00
9.24 | 2022-10-27 15:00:00 | 2022-10-27 22:33:00
18 | 2022-10-27 15:07:00 | 2022-10-28 00:47:00
18 | 2022-10-27 15:55:00 | 2022-10-27 21:04:00
18 | 2022-10-27 15:57:00 | 2022-10-27 23:10:00
17 | 2022-10-27 15:59:00 | 2022-10-27 22:58:00
18 | 2022-10-27 16:02:00 | 2022-10-27 20:21:00
21 | 2022-10-27 16:03:00 | 2022-10-27 22:59:00
18 | 2022-10-27 16:03:00 | 2022-10-27 22:57:00
9.24 | 2022-10-27 16:07:00 | 2022-10-27 22:37:00
19 | 2022-10-27 16:08:00 | 2022-10-27 22:59:00
17 | 2022-10-27 16:12:00 | 2022-10-27 23:15:00
33.65 | 2022-10-27 16:13:00 | 2022-10-27 23:07:00
17 | 2022-10-27 16:18:00 | 2022-10-28 00:47:00
18 | 2022-10-27 16:22:00 | 2022-10-27 23:02:00
11.5 | 2022-10-27 16:25:00 | 2022-10-27 23:00:00
20 | 2022-10-27 16:40:00 | 2022-10-27 22:58:00
18 | 2022-10-27 16:40:00 | 2022-10-27 23:04:00
9.24 | 2022-10-27 16:52:00 | 2022-10-27 22:18:00
19 | 2022-10-27 16:54:00 | 2022-10-28 00:52:00
9.24 | 2022-10-27 16:55:00 | 2022-10-28 00:04:00
18 | 2022-10-27 16:58:00 | 2022-10-27 21:19:00
17 | 2022-10-27 17:03:00 | 2022-10-27 20:00:00
20 | 2022-10-27 17:27:00 | 2022-10-27 21:43:00
17 | 2022-10-27 17:51:00 | 2022-10-27 23:02:00
9.24 | 2022-10-27 17:53:00 | 2022-10-28 00:15:00
9.24 | 2022-10-27 17:55:00 | 2022-10-28 00:55:00
17 | 2022-10-27 18:01:00 | 2022-10-27 22:43:00
9.24 | 2022-10-27 18:01:00 | 2022-10-27 22:16:00
Spreadsheet: 140795d1328891134-add-an-if-statement-to-the-formula-i-have-upload
Sheet: Sheet1

Code | EmpID | [NAME] | sumproduct
1 | 22094 | 64
1 | 512354 | 77
4 | 512354 | 3
1 | 623427 | 77.55
4 | 623427 | 2.45
1 | 633917 | 80
1 | 28189 | 62
4 | 28189 | 18
1 | 150264 | 72
4 | 150264 | 8
1 | 193856 | 80
1 | 604690 | 80
1 | 742510 | 80
1 | 555145 | 72
4 | 555145 | 8
1 | 22094 | 80
1 | 614594 | 80
1 | 47744 | 80
1 | 410273 | 72
4 | 410273 | 8
1 | 766846 | 80
1 | 394976 | 76.5
4 | 394976 | 3.5
1 | 733320 | 80
1 | 889956 | 80
1 | 238052 | 71.2
2 | 238052 | 0
4 | 238052 | 8.8
1 | 665077 | 80
1 | 197921 | 80
1 | 313908 | 80
1 | 334406 | 72
4 | 334406 | 8
1 | 661249 | 48
4 | 661249 | 32
1 | 768883 | 80
1 | 865073 | 80
1 | 701447 | 80
1 | 574067 | 80
1 | 909540 | 77.92
4 | 909540 | 2.08
4 | 594045 | 8
1 | 594045 | 72
1 | 631746 | 80
2 | 631746 | 0
1 | 585203 | 80
1 | 299335 | 74
4 | 299335 | 6
1 | 631624 | 80
1 | 193001 | 80
1 | 132861 | 72
4 | 132861 | 8
1 | 49667 | 80
1 | 867524 | 80
2 | 867524 | 0
1 | 459207 | 80
1 | 165945 | 62
Spreadsheet: 346ea164-5757-4ab3-9d88-d2bedbb6bb8a
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42319543 | 2014-07-16 02:27:34 | ALLIES | 1 | 6 | 1 | 1009110 | HO-SA-KAI | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42319674 | 2014-07-16 02:42:46 | AXIS | 1 | 6 | 3 | 1009110 | HO-SA-KAI | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
Spreadsheet: eric_saibi__9722__010802
Sheet: Scherer 02

Owner Name |  | Oglethorpe Power Company.
Station Name |  | [NAME]
Unit Name |  | Scherer 02
NERC Region |  | SERC
State |  | GA
Fuel Type |  | Coal
Capacity |  | 891 MW
Start Date |  | 2002-01-08 00:00:00
End Date |  | 2002-01-10 00:00:00
Comments |  | Unit is down with a boiler leak.
SIC |  | 4911
Plant ID |  | 1014200
Unit ID |  | 1005653
Outage ID |  | 19402
Spreadsheet: 697889d1601585092-struggling-with-a-lookup-problem-claires-test-sheet
Sheet: Sheet1

 |  |  |  |  | RATE LOOKUP TABLE
 |  |  |  |  | Employee | Year
 |  | Year | 2 |  |  | 1 | 2 | 3 | 4 | 5
 |  |  | Value updated from External Sheet |  | [NAME] | 30.11 | 30.95 | 31.82 | 32.71 | 33.63
 |  |  |  |  | [NAME] | 38.22 | 39.29 | 40.39 | 41.52 | 42.68
 |  |  |  |  | [NAME] | 52.14 | 53.6 | 55.1 | 56.64 | 58.23
 |  |  |  |  | [NAME] | 45.88 | 47.16 | 48.48 | 49.84 | 51.24
 |  |  |  |  |  |  | Challenge: Use the rate data in the coumn matching  the Year in the Rate Lookup Table and assing the appropriate rate to each employee in the Pay Table to allow the calculation of Pay
 | Pay Table | Rate | Employee | Hours | Pay
 |  | 30.95 | [NAME] | 10
 |  | 39.29 | [NAME] | 14
 |  | 53.6 | [NAME] | 4
 |  | 30.95 | [NAME] | 17
 |  | 39.29 | [NAME] | 22
 |  | 47.16 | [NAME] | 5
 |  | 53.6 | [NAME] | 17
 |  |  | Values updated from External Sheet
Spreadsheet: 39858d1238112099-inserting-a-line-on-my-reference-sheet-test-for-help
Sheet: Flyers to Schools

Flyers to Schools
Sponsor Company Name | Sponsor Company Contact Name | Sponsor Contact Email | Sponsor Address | Sponsor Phone | Description | Quantity | Column1 | Column2
1 | 1 | 1 | 1 | 1 | Recognition in Flyers | 1
3 | 3 | 3 | 3 | 3 | Recognition in Flyers | 1
4 | 4 | 4 | 4 | 4 | Recognition in Flyers | 1
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: harry_arora__12146__Staffing Report 12-8-2000
Sheet: Interviews

ENRON NET WORKS STAFFING REPORT
Name: | Schedulers
Week: | December 8th - 31st
 |  |  |  |  |  | phone to | [NAME]
 |  |  |  |  | phone | [NAME] | only
# of Candidates Interviewed by Mgrs
Stock |  |  |  | 0 |  | 1
[NAME] |  |  |  |  | 6 | 2
[NAME] |  |  |  |  |  | 1
Burchfield |  |  |  |  | 2 |  | 1
Internet |  |  |  |  |  |  | 1
Hanz |  |  |  |  | 14 | 3 | 4
[NAME]
Gubser |  |  |  |  | 2 |  | 1
McAuliffe |  |  |  | 0 | 2 | 2 | 6
Dziadek |  |  |  | 0 | 6
[NAME] |  |  |  |  |  |  | 14
Rub - Projects & Oversight
Webb |  |  |  |  | 10 |  | 6
[NAME] |  |  |  |  | 1 |  | 2
Montagne |  |  |  |  | 2 | 1 | 1
Elrod |  |  |  |  | 5 |  | 5
Pavetto |  |  |  |  | 3 |  | 2
Garner |  |  |  |  |  |  | 1
[NAME]
Forster |  |  |  |  |  |  | 1
Piper
Kinneman |  |  |  |  |  |  | 1
Monk
Hotte |  |  |  |  |  |  | 5
[NAME] |  |  |  |  | 1 |  | 6
Spreadsheet: 683853d1592988348-saved-my-worksheet-and-now-i-cant-see-anything-global-grant-worksheet-d9210-june-2020
Sheet: Grant Reports Due

 |  | Overdue Global Grant Reports
2020-05-31 00:00:00
Club Name | GG # | Status | Due Since | Report sent | Comments
Avondale | 1528457 | Late report | 2019-09-05 00:00:00
Beira | 1529455 | Awaiting acceptance | 2020-03-14 00:00:00 | 2020-04-23 00:00:00
Beira | 1981813 | Late report | 2020-05-15 00:00:00
Bulawayo | 1979184 | Late report | 2020-06-20 00:00:00
Bulawayo South | 1532701 | Awaiting acceptance | 2020-03-06 00:00:00 | 2020-05-05 00:00:00
Bulawayo South | 1745812 | Late report | 2020-05-23 00:00:00
[NAME] | 1523994 | Awaiting acceptance | 2019-07-18 00:00:00 | 2020-06-15 00:00:00
[NAME] | 1641720 | Late report | 2019-10-31 00:00:00
[NAME] | 1743384 | Awaiting acceptance | 2020-03-04 00:00:00 | 2020-04-23 00:00:00
Harare West | 1529212 | Late report | 2019-11-15 00:00:00
[NAME] | 1867162 | Awaiting acceptance | 2020-03-22 00:00:00 | 2020-05-18 00:00:00
[NAME] | 1528425 | Missing documents ?? | 2019-05-21 00:00:00 | 2019-12-24 00:00:00
[NAME] | 1637228 | Report incomplete | 2018-09-30 00:00:00 | 2020-04-11 00:00:00
[NAME] | 1749802 | Late report | 2019-06-18 00:00:00
[NAME] | 1874305 | Late report | 2019-09-11 00:00:00
Limbe | 1748670 | Awaiting acceptance | 2020-03-14 00:00:00 | 2020-04-02 00:00:00
Limbe | 1634114 | Awaiting acceptance | 2020-04-29 00:00:00 | 2020-05-05 00:00:00
Lusaka Central | 1868877 | Awaiting acceptance | 2019-10-17 00:00:00 | 2020-04-11 00:00:00
Lusaka Central | 1864758 | Late report | 2020-06-26 00:00:00
Marondera | 1642698 | Awaiting acceptance | 2020-01-11 00:00:00 | 2020-04-19 00:00:00
Mzuzu | 1873373 | Awaiting acceptance | 2019-08-24 00:00:00 | 2020-04-20 00:00:00
Spreadsheet: 884518d1733756173-search-an-array-but-return-only-certain-cells-leetest
Sheet: Data

OPP | NAME | % |  | IN | DUE | OUT | VALUE |  |  |  |  |  |  |  |  |  |  | INITIALS
[NAME] | A COMPANY | 100 | Y | 6.11 | 3.12 | 3.12 | £120K | [NAME] | 14 1 |  | * |  |  |  | * |  | London Central North | MTK
OPP1347769 | B COMPANY | 100 | Y | 27.11 | 4.12 | 4.12 | circa £56 | [NAME] | 7 1,1,1 | 16.1 - | * |  |  |  |  | * | [NAME] | MFR
OPP1353878 | C COMPANY | 50 | Y | 25.11 | 5.12 | 5.12 | 63K circa | [NAME] | 8 | 16 | * |  |  |  | * |  | Teeside | CR
[NAME] | B COMPANY | 30 | Y | 24.11 | 5.12 | 5.12 |  | clsroom block | 1 | 2 | * |  |  |  | * |  | Reading | CR
OPP1354564 | A COMPANY | 10 | Y | 28.11 | 3.12 | 2.12 | £57k | DX322 | 4 | 7..6 | * |  |  |  | * |  | LE - Thameside | JW
[NAME] | B COMPANY | 100 | Y | 6.11 | 3.12 | 3.12 | £120K | [NAME] | 14 1 |  | * |  |  |  | * |  | London Central North | [NAME]
OPP1347769 | A COMPANY | 100 | Y | 27.11 | 4.12 | 4.12 | circa £56 | [NAME] | 7 1,1,1 | 16.1 - | * |  |  |  |  | * | [NAME] | MFR
OPP1353878 | B COMPANY | 50 | Y | 25.11 | 5.12 | 5.12 | 63K circa | [NAME] | 8 | 16 | * |  |  |  | * |  | Teeside | MFR
[NAME] | A COMPANY | 30 | Y | 24.11 | 5.12 | 5.12 |  | clsroom block | 1 | 2 | * |  |  |  | * |  | Reading | CR
OPP1354564 | Z COMPANY | 10 | Y | 28.11 | 3.12 | 2.12 | £57k | DX322 | 4 | 7..6 | * |  |  |  | * |  | LE - Thameside | JW
[NAME] | A COMPANY | 100 | Y | 6.11 | 3.12 | 3.12 | £120K | [NAME] | 14 1 |  | * |  |  |  | * |  | London Central North | [NAME]
OPP1347769 | B COMPANY | 100 | Y | 27.11 | 4.12 | 4.12 | circa £56 | [NAME] | 7 1,1,1 | 16.1 - | * |  |  |  |  | * | [NAME] | MFR
OPP1353878 | A COMPANY | 50 | Y | 25.11 | 5.12 | 5.12 | 63K circa | [NAME] | 8 | 16 | * |  |  |  | * |  | Teeside | CR
[NAME] | B COMPANY | 30 | Y | 24.11 | 5.12 | 5.12 |  | clsroom block | 1 | 2 | * |  |  |  | * |  | Reading | MT
OPP1354564 | A COMPANY | 10 | Y | 28.11 | 3.12 | 2.12 | £57k | DX322 | 4 | 7..6 | * |  |  |  | * |  | LE - Thameside | JW
[NAME] | B COMPANY | 100 | Y | 6.11 | 3.12 | 3.12 | £120K | [NAME] | 14 1 |  | * |  |  |  | * |  | London Central North | [NAME]
OPP1347769 | A COMPANY | 100 | Y | 27.11 | 4.12 | 4.12 | circa £56 | [NAME] | 7 1,1,1 | 16.1 - | * |  |  |  |  | * | [NAME] | MFR
OPP1353878 | B COMPANY | 50 | Y | 25.11 | 5.12 | 5.12 | 63K circa | [NAME] | 8 | 16 | * |  |  |  | * |  | Teeside | MFR
[NAME] | A COMPANY | 30 | Y | 24.11 | 5.12 | 5.12 |  | clsroom block | 1 | 2 | * |  |  |  | * |  | Reading | CR
OPP1354564 | B COMPANY | 10 | Y | 28.11 | 3.12 | 2.12 | £57k | DX322 | 4 | 7..6 | * |  |  |  | * |  | LE - Thameside | JW
Spreadsheet: 168442d1342458132-allocate-months-across-periods-in-which-they-fall-example
Sheet: Sheet1

Start | End | 2008-07-31 00:00:00 | 2009-07-31 00:00:00 | 2010-07-31 00:00:00 | 2011-07-31 00:00:00 | 2012-07-31 00:00:00 | 2013-07-31 00:00:00 | 2014-07-31 00:00:00 | 2015-07-31 00:00:00 | 2016-07-31 00:00:00 | 2017-07-31 00:00:00 | 2018-07-31 00:00:00 | 2019-07-31 00:00:00
2009-08-19 00:00:00 | 2014-09-19 00:00:00
2010-11-01 00:00:00 | 2015-11-01 00:00:00
2005-08-01 00:00:00 | 2015-08-01 00:00:00
2008-01-01 00:00:00 | 2012-10-01 00:00:00
2009-09-22 00:00:00 | 2014-09-21 00:00:00
Oct. 2009 | 2014-10-31 00:00:00
Spreadsheet: 43156d1241730457-formula-with-conditions-take-action
Sheet: Sheet1

name | Start Date (Sick) | End Date (Sick) | Days | action plan required?
[NAME] | 2009-01-01 00:00:00 | 2009-02-12 00:00:00 | 42 | Take Action
[NAME] | 2009-01-01 00:00:00 | 2009-01-03 00:00:00 | 2 | Take Action 2
[NAME] | 2009-01-07 00:00:00 | 2009-01-08 00:00:00 | 1 | Take Action 2
[NAME] | 2009-01-11 00:00:00 | 2009-01-15 00:00:00 | 4 | Take Action 2
[NAME] | 2009-01-18 00:00:00 | 2009-01-19 00:00:00 | 1 | Take Action 2
[NAME] the 2nd | 2009-01-01 00:00:00 | 2009-01-06 00:00:00 | 5 | No Action
[NAME] the 2nd | 2009-01-07 00:00:00 | 2009-01-16 00:00:00 | 9 | No Action
[NAME] the 2nd | 2009-01-19 00:00:00 | 2009-01-25 00:00:00 | 6 | No Action
Millie | 2009-01-18 00:00:00 | 2009-01-19 00:00:00 | 1 | No Action
Spreadsheet: 845679d1697094734-dynamic-array-help-book2_transpose
Sheet: Sheet1

1 | a |  | 1
1 | b |  | 2
2 | c |  | 3
2 | d
2 | e
3 | f
3 | g
Spreadsheet: 26665413-804d-4f17-8038-df4fbb8dbd0f
Sheet: Sheet1

Unnamed: 0 | Permit No.: | WQ0034201 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Cruse Meat Processing | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | County: | Unnamed: 13 | Cabarrus | Unnamed: 15 | Month: | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
 |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  | 3 |  | Field Name: |  |  |  | Field Name:
 |  | Area (acres): |  | 0.95 |  | Area (acres): |  | 0.95 |  | Area (acres): |  | 0.95 |  | Area (acres): |  |  |  | Area (acres):
 |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  |  |  | Load Type:
 |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]?
 | Date | Volume Applied | Average PAN Concentration | Monthly PAN Load | Cumulative PAN Load | Volume Applied | Average PAN Concentration | Monthly PAN Load | Cumulative PAN Load | Volume Applied | Average PAN Concentration | Monthly PAN Load | Cumulative PAN Load | Volume Applied | Average  Concentration | Monthly  Load | Cumulative  Load | Volume Applied | Average  Concentration | Monthly  Load | Cumulative  Load
 | Month | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac
 | 12 Month Floating PAN Load (lbs/ac/yr):
 | Annual PAN Load Limit (lbs/ac/yr):
Spreadsheet: 484496d1476289654-creating-columns-example-1
Sheet: Sheet1

Department
Dept. Total 10230A | Reg O/T Hours 3 Hours 4 |  | 40.00 8.00 0.00 9.75 | Reg    812.00 Earnings 3    0.00 Earnings 5    0.00 |  |  | O/T    243.60 Earnings 4    311.51 Gross    1,367.11 |  | FIT SS Med State | 166.32 79.43 18.57 47.53 | Total Deductions 1,055.26 | 1 Pay 0.00
Dept. Total 10230B | Reg O/T Hours 3 Hours 4 |  | 24.00 0.00 0.00 24.00 | Reg    487.20 Earnings 3    0.00 Earnings 5    0.00 |  |  | O/T    0.00 Earnings 4    499.20 Gross    986.40 |  | FIT SS Med State | 68.02 57.17 13.37 50.33 | Total Deductions 797.51 | 1 Pay 0.00
Dept. Total 10250A | Reg O/T Hours 3 Hours 4 |  | 40.00 20.00 0.00 0.00 | Reg    1,064.80 Earnings 3    0.00 Earnings 5    0.00 |  |  | O/T    798.60 Earnings 4    0.00 Gross    1,863.40 |  | FIT SS Med State | 295.48 111.57 26.09 60.85 | Total Deductions 1,369.41 | 1 Pay 0.00
Dept. Total 10250B | Reg O/T Hours 3 Hours 4 |  | 0.00 0.00 0.00 30.00 | Reg    0.00 Earnings 3    0.00 Earnings 5    0.00 |  |  | O/T    0.00 Earnings 4    744.00 Gross    744.00 |  | FIT SS Med State | 48.05 40.19 9.40 22.64 | Total Deductions 623.72 | 1 Pay 0.00
Dept. Total 10250C | Reg O/T Hours 3 Hours 4 |  | 40.00 8.00 0.00 0.00 | Reg    1,051.60 Earnings 3    0.00 Earnings 5    0.00 |  |  | O/T    315.48 Earnings 4    0.00 Gross    1,367.08 |  | FIT SS Med State | 211.57 80.40 18.80 45.56 | Total Deductions 1,010.75 | 1 Pay 0.00
Spreadsheet: 769285d1645453023-unable-to-lookup-values-lookup
Sheet: Sheet1

 |  |  |  |  | [NAME] |  |  | Values |  |  | Logical
 |  |  | 13660 |  |  |  | ‭13660‬ | 54
 |  |  | 13663J |  |  |  | ‭13663J‬ | 56
 |  |  | 13660Y |  |  |  | ‭13660Y‬ | 47
 |  |  | 14133 |  |  |  | ‭14133‬ | 45
 |  |  | 13663 |  |  |  | ‭13663‬ | 47