tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 681173d1591375984-need-help-in-creating-a-labor-burden-chart-test-payroll
Sheet: Sheet1

Employee | Rate/hr | Hours Worked | Gross Pay | Health Ins. Rate | Hlth Ins Deduc | NECA/Hr | [NAME] | NEBF Rate | NEBF Deduc | Training Fund Rate $/Hr | Training Fund Deduc | Annuity Rate | Annuity Deduc | Total Deductions | Net Pay
A | 42.39 | 40 |  | 0.16206652512385 |  | 0.13 |  | 0.03 |  | 0.19 |  | 0.0875
Spreadsheet: 49029d1248295609-possible-formula-example1
Sheet: Sheet1

Company |  |  |  |  |  |  |  |  |  | TRADE SUMMARY REPORT
PURCHASE AND SALE |  |  |  |  |  |  |  |  |  | 2009-07-21 00:00:00
Logan Investments Ltd. |  |  |  |  |  |  |  |  |  | To
~ FIAG # 123456789 |  |  |  |  |  |  |  |  |  | 2009-07-21 00:00:00
From 07-21-08 To 07-21-08
 |  |  |  |  |  |  |  |  |  | Trade | Trade | Trade
Trade | Settle |  |  | Unit |  |  |  |  |  |  | Date | Security | Completion Time | Account | Shares
Date | Date | Quantity | Security | Price | Amount |  |  |  |  |  | ----------- | ----------------------------- | --------------------- | -------------------------------------- | ------------
-------- | -------- | ------------- | -------------------------------- | ---------- | ------------- |  |  |  |  | Company1
 |  |  |  |  |  |  |  |  |  | ---------------------------
PURCHASES |  |  |  |  |  |  |  |  |  | BUY
--------- |  |  |  |  |  |  |  |  |  | ---
2009-07-21 00:00:00 | 2009-07-24 00:00:00 | 3 | Company1 | 123 | 654321
2009-07-21 00:00:00 | 2009-07-24 00:00:00 | 4 | Company2 | 112 | 412341 |  |  |  |  |  |  |  | YoMamma Securities, Inc - 132456789 | 21 | 123456
 |  |  |  |  | -------------
 |  |  |  |  | 6462345
SALES
----- |  |  |  |  |  |  |  |  |  | Company1
2009-07-21 00:00:00 | 2009-07-24 00:00:00 | 2 | Company3 | 33 | 451226 |  |  |  |  | ---------------------------
2009-07-21 00:00:00 | 2009-07-24 00:00:00 | 1 | Company4 | 22 | 134234
 |  |  |  |  | ------------- |  |  |  |  | BUY
 |  |  |  |  | 425642 |  |  |  |  | ---
Company
PURCHASE AND SALE |  |  |  |  |  |  |  |  |  |  |  |  | Logan Investments Ltd. - 123456789 | 21 | 654321
YoMamma Securities Inc.
~ FIAG # 132456789
From 07-21-08 To 07-21-08
Trade | Settle |  |  | Unit
Date | Date | Quantity | Security | Price | Amount
-------- | -------- | ------------- | -------------------------------- | ---------- | -------------
PURCHASES
---------
2009-07-21 00:00:00 | 2009-07-24 00:00:00 | 4 | Company1 | 114 | 123456
2009-07-21 00:00:00 | 2009-07-24 00:00:00 | 6 | Company2 | 223 | 6234523
 |  |  |  |  | -------------
 |  |  |  |  | 623464
SALES
-----
2009-07-21 00:00:00 | 2009-07-24 00:00:00 | 3 | Company3 | 114 | 1367463
2009-07-21 00:00:00 | 2009-07-24 00:00:00 | 7 | Company4 | 25 | 4646244
 |  |  |  |  | -------------
 |  |  |  |  | 6432346
Spreadsheet: 1b7d0b45-842f-4ca2-80d6-6b983a53b8fe
Sheet: Sheet1

Table 9--U.S. vegetable oil and fats prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Marketing | Soybean | Cottonseed | Sunflowerseed | Canola | Peanut | Corn | Lard 6 | Edible
year | oil 2 | oil 3 | oil 4 | oil 4 | oil 5 | oil 6 |  | tallow 6
 | Cents/pound
2002/03 | 22.04 | 37.75 | 33.13 | 29.75 | 46.7 | 28.17 | 18.13 | 17.8
2003/04 | 29.97 | 31.21 | 33.42 | 33.76 | 60.84 | 28.43 | 26.13 | 22.37
2004/05 | 23.01 | 28.01 | 43.71 | 30.78 | 53.63 | 27.86 | 21.8 | 18.48
2005/06 | 23.41 | 29.47 | 40.64 | 31 | 44.48 | 25.18 | 21.74 | 18.16
2006/07 | 31.02 | 35.7 | 58.03 | 40.57 | 52.99 | 31.8 | 28.43 | 27.32
2007/08 | 52.03 | 73.56 | 91.15 | 65.64 | 94.53 | 69.4 | 40.85 | 41.68
2008/09 | 32.16 | 37.1 | 50.24 | 39.54 | 78.49 | 32.75 | 26.72 | 25.47
2009/10 | 35.95 | 40.27 | 52.8 | 42.88 | 59.62 | 39.29 | 31.99 | 32.26
2010/11 | 53.2 | 54.5 | 86.12 | 58.68 | 77.24 | 60.76 | 51.52 | 51.34
2011/12 | 51.9 | 53.22 | 83.2 | 57.19 | 100.15 | 56.09 | 48.11 | 50.33
2012/131 | 47.25 | 48.75 | 65.75 | 56.75 | 91.83 | 46.75 | 50 | 43.75
2013/141 | 43.0-47.0 | 46.0-50.0 | 68.0-72.0 | 54.0-58.0 | 87.0-91.0 | 47.0-51.0 | 38.0-42.0 | 37.0-41.0
2011/12
October | 51.73 | 51.56 | 92.5 | 56.81 | 97 | 54.24 | 61.1 | 52.09
November | 51.44 | 50.5 | 91 | 56.13 | 98.75 | 53.98 | 48.86 | 45.51
December | 50.17 | 51.1 | 91 | 55.4 | 96.1 | 53.36 | 48.71 | 50.78
January | 50.99 | 52.19 | 88.75 | 55.06 | 95.81 | 54 |  | 51.1
February | 52.36 | 54.56 | 86 | 56.94 | 95 | 56.3 | 52.55 | 53.17
March | 53.43 | 55.95 | 82 | 59.1 | 96.6 | 59.31 | 54.6 | 52.24
April | 54.96 | 56.88 | 79 | 60.94 | 102.38 | 60.75 | 52.59 | 49
May | 50.69 | 52 | 80 | 55.88 | 106.13 | 58.05 | 54.82 | 55.48
June | 48.65 | 50.05 | 80.2 | 54.1 | 111 | 52.9 | 54.83 | 49.88
July | 51.96 | 53.75 | 78 | 57.44 | 110 | 54.76 | 53 | 49.13
August | 52.65 | 54.65 | 75 | 58.75 | 110 | 57.26 |  | 48.36
September | 53.81 | 55.5 | 75 | 59.75 | 104.5 | 58.21 |  | 47.19
2012/13
October | 49.31 | 51.31 | 74 | 57.5 | 103 | 54.75 | 51.6 | 42.27
November | 46.27 | 49.05 | 70.3 | 58.2 | 99.9 | 51.93 | 57 | 37.15
December | 47.16 | 50.06 | 67.5 | 57.13 | 98.56 | 50.63 |  | 40.92
January | 48.85 | 50.94 | 65.25 | 57.19 | 96.75 | 52.06 | 52.45 | 43.5
February | 49.33 | 51.56 | 65 | 59.38 | 86 | 51.71 | 45.56 | 41.93
March | 48.62 | 50.2 | 64.6 | 58.95 | 79.05 | 47.76 |  | 45
April | 49.28 | 49.94 | 64 | 60.44 | 77.5 | 47.06 | 43.5 | 43.5
May | 49.31 | 49.75 | 64 | 60.45 | 80 | 45.23 | 44.5 | 43.86
June | 47.84 | 48.25 | 64 | 57.5 | 82.75 | 42.5 | 48.5 | 48.44
July | 45.19 | 46.19 | 64 | 53.25 | 84 | 38.91 | 53.25 | 49.13
August1 | 42.33 | 43.1 | 64 | 48.05 | 83 | 38.93 | 56.89 | 43.18
1 Preliminary.  2 Decatur, IL.  3 PBSY Greenwood, MS.  4 Midwest. 5 Southeast mills.  6 Chicago.
NA = Not available.
Sources: USDA, Agricultural Marketing Service,  Monthly Feedstuff Prices and Milling and Baking News.
Last update: | 2013-09-16 10:15:21.830000
Spreadsheet: 1e56d517-0720-49f4-975d-142e5729c36d
Sheet: Sheet1

Securities | % of Assets
Veresen Inc. | 3.28%
Capital Power Corp | 2.84%
BCE Inc. | 2.79%
Crescent Point Energy Crp | 2.74%
National Bank of Canada | 2.58%
Northland Power Inc | 2.57%
Canadian Oil Sands Ltd | 2.53%
Enbridge Income Fund Hld | 2.53%
Emera Inc. | 2.52%
Baytex Energy Corp. | 2.49%
Bank of Montreal | 2.35%
Rogers Communications Inc | 2.35%
Great-West Life Company | 2.33%
Pembina Pipeline Inc | 2.32%
Fortis Inc. | 2.32%
Inter Pipeline Ltd. | 2.31%
Cdn Imperial Bk of Commrc | 2.27%
Keyera Corp | 2.24%
Shaw Communicatn Cl B Nvs | 2.21%
Royal Bank of Canada | 2.20%
TransCanada Corp. | 2.18%
Freehold Royalties Ltd | 2.17%
Thomson Reuters Corp | 2.14%
Power Financial Corp. | 2.11%
Sun Life Financial Inc. | 2.05%
Bank of Nova Scotia | 2.04%
Power Corporation Canada | 2.04%
[NAME] Cl B Nvs | 2.03%
Potash Corp of Saskatchwn | 2.03%
IGM Financial Inc. | 1.99%
TELUS Corp. | 1.94%
Transcontinental Inc Cl A | 1.91%
Toronto-Dominion Bank | 1.90%
ARC Resources Ltd | 1.73%
Cineplex Inc. | 1.68%
Wajax Corporation | 1.67%
Genworth MI Canada Inc | 1.67%
Vermilion Energy Inc. | 1.65%
Enbridge Inc. | 1.58%
BROOKFIELD PROPERTY PTNER | 1.54%
Mullen Group Ltd. | 1.49%
AGF Management Ltd Cl B | 1.48%
Husky Energy Inc. | 1.41%
CI Financial Corp | 1.39%
Dorel Industries Inc Cl B | 1.27%
First Capital Realty Inc | 1.23%
Aimia Inc. | 1.16%
Ensign Energy Srvcs Inc | 0.93%
Teck Resources Ltd Cl B | 0.78%
Canexus Corporation | 0.58%
Cash | 0.47%
Total Holdings in Portfolio | 51
Spreadsheet: 854365d1704275932-checking-each-field-taking-data-from-latest-field-and-adding-to-one-specific-cell-dummy
Sheet: W7

IDs (Week 7 data (Week 13 since letter)) |  |  |  |  |  |  |  |  | IDs (Week 5 data (Week 15 since letter)) |  |  |  |  |  |  |  |  |  | IDs (Week 3 data (Week 17 since letter)) |  |  |  |  |  |  |  |  |  | IDs (Week 1 data (Week 19 since letter))
Group 1 | Group 2 |  |  |  | Group 3 |  |  |  | Group 1 | Group 2 |  |  |  | Group 3 |  |  |  |  | Group 1 | Group 2 |  |  |  | Group 3 |  |  |  |  | Group 1 | Group 2 |  |  |  | Group 3
No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date SMS Scheduled | SMS Status | Opted out? | No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | Total Scheduled | Total Delivered | TotaloOpted out | Total Clicks | Total calls made | Total Successful | Total Rescheduled | Total Opt out of calls
 |  |  |  |  | 2931964268 | 2024-11-13 00:00:00 |  |  |  |  |  |  |  | 8855618068 | 2024-11-15 00:00:00 |  |  |  |  |  |  |  |  | 3732321505 | 2025-11-17 00:00:00 |  |  |  |  |  |  |  |  | 3456474363 | 2024-11-19 00:00:00
Spreadsheet: 69348d1269892065-excel-2007-concatenate-next-non-empty-cell-in-a-column-example
Sheet: Sheet1

 | Revenue Streams Hierarchy
 | Detail Level 1 of 4 |  | [NAME] of 4 | [NAME] 3 of 4 | Detail Level 4 of 4 |  | Output
 |  | Athletics Club |  |  |  |  | Athletics Club
 |  |  | Membership |  |  |  | Athletics Club - Membership
 |  |  | Training Fees |  |  |  | Athletics Club - Training Fees
 |  |  | Competition |  |  |  | Athletics Club - Competition
 |  |  |  | Entries |  |  | Athletics Club - Competition - Entries
 |  |  |  | Affiliations |  |  | Athletics Club - Competition - Affiliations
 |  |  |  | Transport |  |  | Athletics Club - Competition - Transport
 |  |  |  | Accommodation |  |  | Athletics Club - Competition - Accomodation
 |  |  |  | Physiotherapy |  |  | Athletics Club - Competition - Physiotherapy
 |  |  |  | Bonus Points Scheme |  |  | Athletics Club - Competition - Bonus Points Scheme
 |  |  |  | Officials Expenses |  |  | Athletics Club - Competition - Officials Expenses
 |  |  |  | Management |  |  | Athletics Club - Competition - Management
 |  |  |  |  | Honorarium Payments |  | Athletics Club - Competition - Management - Honorarium Payments
 |  |  |  |  | Expenses |  | Athletics Club - Competition - Management - Expenses
Spreadsheet: 740958d1626723346-return-a-value-if-specific-text-is-contained-in-range-test
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Return Value Here
 | High | High
 |  | High |  |  |  | High |  | High
Low | High | High |  |  |  | High |  | High
 | High | High |  |  |  | High
 | High | High
 | High | High |  |  |  | High | High
 | High | High |  |  |  |  |  | High
 |  | High |  |  |  | High
 | High | High |  |  |  |  | High
Low |  | High
 | High | High |  | High | High | High | High
 |  | High |  | High | High | High | High
 | High | High |  |  |  | High
Spreadsheet: 84462d1284512950-transpose-columns-of-data-in-rows-copy-of-excelhelptranspose-1-
Sheet: Original Data

Original Data
Store | Week 1 | Week 2 | Week 3 | Week 4
[NAME] | 49457 | 50278 | 48173 | 54061
Eglinton | 212394 | 206661 | 213128 | 197135 |  | 2
Eglinton5 | 233633 | 227327 | 234440 | 216848
Eglinton6 | 256996 | 250059 | 257884 | 238532
Eglinton7 | 282695 | 275064 | 283672 | 262385
Eglinton8 | 310964 | 302570 | 312039 | 288623
Eglinton9 | 342060 | 332827 | 343242 | 317485
Eglinton10 | 376266 | 366109 | 377566 | 349233
Eglinton11 | 413892 | 402719 | 415322 | 384156
Eglinton12 | 455281 | 442990 | 456854 | 422571
Eglinton13 | 500809 | 487289 | 502539 | 464828
Eglinton14 | 550889 | 536017 | 552792 | 511310
Eglinton15 | 605977 | 589618 | 608071 | 562441
Eglinton16 | 666574 | 648579 | 668878 | 618685
Spreadsheet: john_zufferli__16730__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to | Hedgeable | Current |  | AECO
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Volume | Gas Hedges |  | Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (cont/day) | (cont/day) | % Hedged | (cont/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 766283d1643827287-find-if-values-across-2-columns-exist-in-another-column-forum_question
Sheet: Sheet1

EDC Subject | EDC Date |  | Lab Subject | Specimen Collection Date | SMART Specimen Status
114-602 | 2021-06-25 00:00:00 |  | 103-601 | 2019-03-01 00:00:00 | Packaged - Referral Site
138-602 | 2018-07-17 00:00:00 |  | 103-601 | 2019-03-01 00:00:00 | Packaged - Referral Site
138-603 | 2018-07-17 00:00:00 |  | 103-601 | 2019-03-01 00:00:00 | Available
138-614 | 2018-08-03 00:00:00 |  | 103-601 | 2019-03-01 00:00:00 | Available
138-618 | 2018-08-07 00:00:00 |  | 103-601 | 2019-03-01 00:00:00 | Packaged - Referral Site
138-619 | 2018-08-07 00:00:00 |  | 103-602 | 2019-04-22 00:00:00 | Packaged - Referral Site
138-623 | 2018-08-13 00:00:00 |  | 103-602 | 2019-04-22 00:00:00 | Available
138-624 | 2018-08-13 00:00:00 |  | 103-602 | 2019-04-22 00:00:00 | Available
138-627 | 2018-08-15 00:00:00 |  | 103-602 | 2019-04-22 00:00:00 | Packaged - Referral Site
138-630 | 2018-08-15 00:00:00 |  | 103-602 | 2019-04-22 00:00:00 | Packaged - Referral Site
138-633 | 2018-08-20 00:00:00 |  | 103-603 | 2019-05-03 00:00:00 | Packaged - Referral Site
Spreadsheet: 881196d1729156947-need-help-creating-cocktail-costs-based-on-amount-and-bottles-used-alcohol-costs
Sheet: Liquor

Liquor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cost of bottle / oz in bottle x oz in drinks / profit percent
Vodka | Vendor | SIZE | BTL COST | 1.5oz P | 1oz P | .5oz P |  |  | 1.5oz | 1oz | .5oz
Barton Vodka | Southern | 1L | 6.33
[NAME] | Southern | 1L | 22.67
[NAME] | Southern | 1L | 33
Ketel One | Southern | 1L | 27.25
Tito's | [NAME] | 1L | 24.69
[NAME] | Vendor | SIZE | BTL COST | 1.5oz P | 1oz P | .5oz P |  |  | 1.5oz | 1oz | .5oz
[NAME] | Southern | 1L | 8.7
Patron Blanco | Southern | 750ML | 39.7
[NAME] | Southern | 1L | 22.75
[NAME] | Southern | 1L | 46.64
[NAME] | Southern | 1L | 44.33
Cazadores | Southern | 1L | 34.04 | 10
1800 Rep | [NAME] | 1L | 29.97 | 9
 |  |  | 25.33 | 8
[NAME] | Vendor | SIZE | BTL COST | 1.5oz P | 1oz P | .5oz P |  |  | 1.5oz | 1oz | .5oz
[NAME] | Southern | 1L | 6.92
[NAME] | Southern | 1L | 19
Captain | Southern | 1L | 19.5
Malibu | Southern | 1L | 17.75
Myers's Dark | Harbor | 1L | 26.63
Rumhaven | [NAME] | 1L | 21.8
Whiskey/Bourbon | Vendor | SIZE | BTL COST | 1.5oz P | 1oz P | .5oz P |  |  | 1.5oz | 1oz | .5oz
Mr [NAME] | Southern | 1L | 8
Crown Royal | Southern | 1L | 30.58
Jameson | Southern | 1L | 28.08
[NAME] | Southern | 1L | 20.25
[NAME] | Southern | 1L | 22.67
[NAME] | Southern | 1L | 32
Seagrams 7 | Southern | 1L | 15.19
Buffalo Trace | Harbor | 1L | 27.56
Seagrams VO | Harbor | 1L | 21.58
[NAME] | Harbor | 1L | 18.05
[NAME] | [NAME] | 1L | 29.36
[NAME] | [NAME] | 1L | 29.36
Woodford | [NAME] | 1L | 37.08
Brandy/Cognac | Vendor |  | BTL COST | 1.5oz P | 1oz P | .5oz P |  |  | 1.5oz | 1oz | .5oz
E&J | [NAME] | 1L | 10.5
Hennessy | Southern | 1L | 46
Spreadsheet: 273367d1382694530-rearranging-datewise-horizontally-in-a-specified-format-from-raw-data-vat1_sr_rev
Sheet: Result(Revised)

Date | Name of Party | Particulars | Reference No. | Taxable Purchase | Taxable Import | [NAME] | [NAME] in Custom | Excise Duty | Total
 |  |  | [NAME]. 610
 |  |  | [NAME]. 504
 |  |  | [NAME]. 4409
 |  |  | PP NO.55408
 |  |  | PP NO. 55253
 |  |  | RECEPT NO. 93198
Spreadsheet: 713534d1610769011-nested-if-or-and-statement-not-working-on-all-rows-copy-20200818-obsolete-tooling
Sheet: 20200910 Curtis (Oper Supplies)

Material | Short Text | Profit Center | Valuation Class | MRP Controller | MRP | Valuation Type (Batch) | Valuation Type (Batch) | Location | Del. flag: stge type | DF at plant level | Plant-sp.matl status | Total Stock (Qty in Inventory) | Total Value (Value Unrestricted) | Number of Years | Days since consumption | Moving price | Price Unit | OBSOLETE? (Yes / No) | Comments
78-5004-0589-9-00 | CURTAIN,LIGHT [NAME] | 619029705 | 7060 | 5 |  | C1 |  | FM21-3B1 |  |  |  | 3 | 7468.95 |  | 3840 | 248965 | 100 | Yes
78-5004-0589-9-00 | CURTAIN,LIGHT [NAME] | 619029705 | 7060 | 5 |  | C2 |  | FM21-3B1 |  |  |  | 1 | 2489.65 |  | 3840 | 248965 | 100 | Yes
Spreadsheet: 734519d1622213844-generate-a-range-of-values-between-specific-dates-test
Sheet: Sheet1

Holiday | Date |  |  |  |  | Date | Holiday | Holiday Value
New Year's Day | 2021-01-01 00:00:00 |  |  |  |  | 2021-01-31 00:00:00
Super Bowl | 2021-02-07 00:00:00 |  |  |  |  | 2021-02-01 00:00:00
President's Day | 2021-02-15 00:00:00 |  |  |  |  | 2021-02-02 00:00:00
Good Friday | 2021-04-02 00:00:00 |  |  |  |  | 2021-02-03 00:00:00
Easter | 2021-04-04 00:00:00 |  |  |  |  | 2021-02-04 00:00:00
Cinco de Mayo | 2021-05-05 00:00:00 |  |  |  |  | 2021-02-05 00:00:00
Memorial Day | 2021-05-31 00:00:00 |  |  |  |  | 2021-02-06 00:00:00
Independence Day | 2021-07-04 00:00:00 |  |  |  |  | 2021-02-07 00:00:00 |  | 1
Labor Day | 2021-09-06 00:00:00 |  |  |  |  | 2021-02-08 00:00:00
Veterans Day | 2021-11-11 00:00:00 |  |  |  |  | 2021-02-09 00:00:00
Thanksgiving | 2021-11-26 00:00:00 |  |  |  |  | 2021-02-10 00:00:00
Christmas | 2021-12-25 00:00:00 |  |  |  |  | 2021-02-11 00:00:00
 |  |  |  |  |  | 2021-02-12 00:00:00
 |  |  |  |  |  | 2021-02-13 00:00:00
 |  |  |  |  |  | 2021-02-14 00:00:00
 |  |  |  |  |  | 2021-02-15 00:00:00 |  | 1
 |  |  |  |  |  | 2021-02-16 00:00:00
 |  |  |  |  |  | 2021-02-17 00:00:00
 |  |  |  |  |  | 2021-02-18 00:00:00
 |  |  |  |  |  | 2021-02-19 00:00:00
 |  |  |  |  |  | 2021-02-20 00:00:00
 |  |  |  |  |  | 2021-02-21 00:00:00
 |  |  |  |  |  | 2021-02-22 00:00:00
 |  |  |  |  |  | 2021-02-23 00:00:00
Spreadsheet: 63455d1264379127-filter-info2
Sheet: Sheet2

ADDRESS | DATE | WORKSHOP  WAREHOUSE AREA (SQM) | RATE  $psqm | OTHER BUILDING AREAS | AREA (SQM) | RATE $psqm | SITE WORKS | AREA (SQM) | RATE |  |  | COMMENTS
J Road | 2009-08-27 00:00:00 |  |  | Store | 745 | 23 | Yard | 453 | 23 |  |  | J Road Building
 |  | 4895 | 63.08 | Office | 34 | 43 | Land | 23 | 23
 |  |  |  | Canopy | 423 | 23 | Carparks | 455 | 23
O Road | 2009-06-01 00:00:00 |  |  | Office | 23 | 43 | Yard | 24 | 345 | @ | 0.05 | O Road Building
 |  |  |  | Mezzanine Open | 124 | 43 | Conrete | 23 | 12 | @ | 0.03
 |  | 1231 | 75 | Mezzanine Office | 23 | 23 | Fences & Gate |  |  | @ | 0.05
 |  |  |  | Tool Room | 345 | 23 | Rear Yard | 234 | 12 | @ | 0.04
 |  |  |  |  |  |  | Drive Concrete |  |  | @ | 0.04
C Street | 2009-06-18 00:00:00 | 456 | 80 | Office | 56 | 23 | Carparks | 34 | 10 |  |  | C Street Building
B Street | 2009-08-05 00:00:00 | 867 | 65 | Office | 4312 | 43 | Sealed Yard | 543 | 5 | @ | 0.05 | B Street Building
S Place | 2009-01-01 00:00:00 |  |  | Packhouse | 3412 | 2 | Deck | 34 | 4 |  |  | S Place Building
 |  |  |  | Office | 523 | 4 | Sealed Yard | 54 | 34
 |  |  |  | Staffroom | 4 | 5 | Metal Yard | 34 | 5
 |  |  |  | Office | 4535 | 6
 |  |  |  | Office | 7567 | 8
 |  |  |  | Office | 568 | 9
 |  |  |  | Lockers | 7 | 0
 |  | 738 | 27.01 | Store | 696 | 5
 |  |  |  | Store | 9 | 4
 |  |  |  | Canopy | 67 | 23
 |  |  |  | Plantroom | 4 | 45
 |  |  |  | Plantroom | 35 | 324
 |  |  |  | [NAME] | 35 | 23
 |  |  |  | Extension | 4234 | 23
O Road | 2009-01-01 00:00:00 |  |  |  |  |  | Front Conrete |  | 23 | @ | 0.03 | O Road Building
 |  | 23 | 23 | Mezzanine | 43 | 23 | Front Land |  | 45 | @ | 0.03
 |  |  |  |  |  |  | Fencing |  | 3 | @ | 0.03
Spreadsheet: 39188d1237389383-calendar-and-buttons-waste-log-for-outlook
Sheet: Sheet1

Customer | City | Profile # | Pick Up Date | Driver | Quantity
Brand FX Body Co | Pocahontas | 2004080172 | 2009-03-04 00:00:00 | [NAME] | 3
CCL Label (1209) | [NAME] | 2006080123 | 2009-03-04 00:00:00 | Gene | 1
CCL Label (1209) | [NAME] | 2006080125 | 2009-03-04 00:00:00 | Gene | 2
CCL Label (1209) | [NAME] | 2006080122 | 2009-03-04 00:00:00 | Gene | 1
CCL Label (1209) | [NAME] | 2007110196 | 2009-03-04 00:00:00 | Gene | 1
Daktronics | Brookings | 2006030174 | 2009-03-04 00:00:00 | Gene | 5
Daktronics | Brookings | 2009010142 | 2009-03-04 00:00:00 | Gene | 2
Daktronics | Brookings | 98070450 | 2009-03-04 00:00:00 | Gene | 1
Deluxe Mfg Co | Kearney | 2001070227 | 2009-03-05 00:00:00 | [NAME] | 2
Good Samaritan Hosp | Kearney | 95120033 | 2009-03-05 00:00:00 | [NAME] | 1
HEG Painting | Cherokee | 2006010152 | 2009-03-05 00:00:00 | [NAME] | 2
International Sensor S | [NAME] | 97120119 | 2009-03-05 00:00:00 | [NAME] | 1
Spreadsheet: fad68b70-b0da-40c9-8846-39011746cdb2
Sheet: Sheet1

Soort materiaal | aantal | Unnamed: 2
Zoekkaart bodemdieren | 38 | 10
Zoekkaart waterdieren | 40 | 9
Zoekkaart waterdieren (andere uitgave) | 4 | 4
Zoekkaart knoppen bomen | 43 | 10
Zoekkaart bomen herkennen aan hun blad of aan hun knoppen | 40 | 7
Zoekkaart bomen herkennen aan hun blad of aan hun knoppen | 5 | 5
Determinatietabel bomen | 1 | 1
Zoekkaart ongewervelde zoetwaterdieren | 40 | 9
Zoekkaart paddestoelen | 29 | 10
Zoekkaart vruchten aan bomen | 28 | 10
Naamzoekkaart watervogels | 4 | 10
Zoekkaart amfibieën | 16 | 10
Zoekkaart vissen | 44 | 10
Het kabouterpad | 1 | 1
[NAME] tips voor gebruik materiaal | 1 | 1
Loeppotje (groot) | 75 | 30
Loeppotje (klein) | 18 | 0
Trieerbak wit | 12 | 7
Schepnet ([NAME]) | 20 | 10
Schepnet (groot) | 3 | 1
Schepnet (groot voor poelen) | 3 | 3
Schepnet (groot voor poelen) | 3 | 3
[NAME] (helderheidsmeter water) | 3 | 3
[NAME] | 3 | 1
Boomhoogtemeter | 15 | 5
[NAME] | 150 | 50
Binoculair Euromex AP8 | 2 | 1
Kompas | 35 | 10
[NAME] | 24 | 23
Prullenpakker | 6 | 4
zak voor prullenpakkers | 1 | 1
[NAME] | 150 | 50
Lintmeter | 10 | 3
Spiegeltje | 39 | 20
Spiegeltje (groter) | 2 | 2
Regenmeter | 3 | 2
[NAME] je dat | 40 | 5
Klembord | 25 | 15
Ganzenspel (scheldeganzen in actie) | 1 | 1
Aquarium | 1 | 3
Radio (op zonne-energie) | 1 | 1
Lespakket ‘Zorgen voor de natuur’ | 1 | 1
Veldwerkpakket ‘Geboeid door natuur’ | 1 | 1
Lespakket ‘Natuurkoningen en natuurkoninginnen’ | 1 | 1
Lespakket ‘met [NAME] en familie het bos in’ | 1 | 1
[NAME] en Niels de duif’ | 1 | 1
Lespakket ‘Oriëntatie in het landschap | 1 | 1
[NAME] waterkronkels | 1 | 1
Lespakket ‘Duik eens in een poel’ | 1 | 1
Waterthermometer | 18 | 4
Schietlood | 25 | 4
Rugzakje | 30 | 10
Rolmeter |  | 2
Pluchen pimpelmees | 1 | 1
pluchen  grote bonte specht | 1 | 1
pluchen merel | 1 | 1
houten koolmees | 1 | 1
pluchen roodborst | 1 | 1
Fuik | 12 | 11