tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 748596d1632233016-check-if-time-range-is-within-another-time-range-example2-1-kvs-2-
Sheet: Sheet1

 |  | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-05 00:00:00 | 2021-09-06 00:00:00 | 2021-09-07 00:00:00 |  | Question:
Test | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 |  | How to shorten the formula. If I would put lets say 40 more rows I will reach the max of 9000~ characters in 1 cell
Different | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00
Test | Name | HOL | HOL | HOL | HOL | HOL | HOL | HOL
Different | Name | 16:00-24:00 | 16:00-24:00 | 16:00-24:00 | 16:00-24:00 | 16:00-24:00 | 16:00-24:00 | 16:00-24:00
Different | Name | HOL | HOL | HOL | HOL | HOL | HOL | HOL
Test | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00
Different | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00
Different | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00
Test | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00
 |  |  |  |  |  |  |  |  |  | in C3 | Result | [NAME]
 | 08:00-09:00 |  |  |  |  |  |  |  |  | IF A2 contains "Test"  and time in C2 falls in B13 | 1
 | 09:00-10:00 |  |  |  |  |  |  |  |  | IF A3 contains "Test"  and time in C3 falls in B13 | False
 | 10:00-11:00 |  |  |  |  |  |  |  |  | IF A4 contains "Test"  and time in C4 falls in B13 | 0
 | 11:00-12:00 |  |  |  |  |  |  |  |  | IF A5 contains "Test"  and time in C5 falls in B13 | False
 | 12:00-13:00 |  |  |  |  |  |  |  |  | A6 etc.. | False
 | 13:00-14:00 |  |  |  |  |  |  |  |  | A7 etc.. | 1
 | 14:00-15:00 |  |  |  |  |  |  |  |  | A8 etc.. | False
 | 15:00-16:00 |  |  |  |  |  |  |  |  | A9 etc.. | False
 | 16:00-17:00 |  |  |  |  |  |  |  |  | A10 etc.. | 1
 | 17:00-18:00
 | 18:00-19:00 |  |  |  |  |  |  |  |  | All those formulas above in 1 cell like in C13 | 3
 | 19:00-20:00
 | 20:00-21:00
 | 21:00-22:00
 | 22:00-23:00
 | 23:00-24:00
Spreadsheet: 79919d1280174542-time-sheets-decimal-to-hh-mm-timesheet-2
Sheet: Sheet1

EMPLOYEE TIME CARD |  |  |  |  | Employee: |  | [NAME]
DATE | IN | LUNCH | RETURN | OUT | HOURS |  | Break Out | Break In | MIN | Break Out | Break In | MIN | TOTAL
2010-07-12 00:00:00 | 08:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  | 10:00:00 | 10:10:00 |  | 14:15:00 | 14:20:00
2010-07-13 00:00:00 | 09:15:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  | 10:00:00 | 10:10:00 |  | 15:09:00 | 15:15:00
2010-07-14 00:00:00 | 08:30:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  | 10:05:00 | 10:20:00 |  | 14:00:00 | 14:05:00
2010-07-15 00:00:00 | 09:00:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  | 09:55:00 | 10:15:00 |  | 14:00:00 | 14:15:00
2010-07-16 00:00:00 | 08:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  | 11:01:00 | 11:10:00 |  | 14:30:00 | 14:40:00
 |  |  | Total: |  |  |  |  |  |  | Total Break Hours:Minutes
 |  |  |  |  |  |  |  | Please turn timesheets in to [NAME] on
Employee Signature |  |  |  | Date |  |  |  | the 14th and 30th/31st of each month.
Supervisor Signature |  |  |  | Date
Enter Time as 9:00 AM or 5:00 PM; AM and PM is crucial for correct formula, along with a space between the time and AM/PM
Spreadsheet: jonathan_mckay__17192__June Index Summary
Sheet: Tenn TX

EOL Transaction Summary Report
Criteria: | Traders
 | [NAME]
 | Product:
 | US Gas Phy Fwd
EnronOnline Report | All Counterparties
Product | Date-Time | Volume | Price
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/29/2001 01:37 pm | 2000 | 3.645
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/29/2001 02:37 pm | 5000 | 3.635
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/29/2001 02:38 pm | 4480 | 3.6375
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/29/2001 02:50 pm | 10000 | 3.64
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/29/2001 02:56 pm | 5000 | 3.635
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/29/2001 03:04 pm | 2900 | 3.615
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/30/2001 01:23 pm | 2500 | 3.65
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/30/2001 01:23 pm | 7500 | 3.65
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/30/2001 01:25 pm | 5000 | 3.66
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/30/2001 01:51 pm | 10000 | 3.71
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/30/2001 03:07 pm | 205 | 3.8
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/30/2001 03:45 pm | 1000 | 3.85
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/30/2001 07:58 am | 2500 | 3.55
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/30/2001 08:21 am | 4000 | 3.54
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/30/2001 09:41 am | 9000 | 3.54
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/30/2001 09:57 am | 3255 | 3.54
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/30/2001 10:31 am | 10000 | 3.55
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/30/2001 10:37 am | 10000 | 3.56
US Gas Phy       TENN Z-0                Jun01           USD/MM | 05/30/2001 11:32 am | 5000 | 3.525
 | TOTAL VOLUME
Weighted Average
Spreadsheet: 77872d1278369359-all-cells-add-up-to-given-number-meals
Sheet: Sheet1

calories | number of meals |  | av per meal | if first meal greater than average enter value here |  |  | meal 1 | 333.3333333333333
2000 | 6 |  | 333.3333333333333 | 0 |  |  | meal 2 | 333.3333333333333
 |  |  |  |  |  |  | meal 3 | 333.3333333333333
 |  |  |  |  |  |  | meal 4 | 333.3333333333333
 |  |  |  |  |  |  | meal 5 | 333.3333333333333
 |  |  |  |  |  |  | meal 6 | 333.3333333333333
 |  |  |  |  |  |  | meal 7
 |  |  |  |  |  |  | meal 8
 |  |  |  |  |  |  | total | 2000
Spreadsheet: 586457d1534399537-allocating-contract-costs-by-fiscal-month-allocating-contract-costs-by-fiscal-month
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN
 |  |  |  |  |  |  |  |  | 2018-02-04 00:00:00 | 2018-03-04 00:00:00 | 2018-04-08 00:00:00 | 2018-05-06 00:00:00 | 2018-06-03 00:00:00 | 2018-07-08 00:00:00 | 2018-08-05 00:00:00 | 2018-09-02 00:00:00 | 2018-10-07 00:00:00 | 2018-11-04 00:00:00 | 2018-12-02 00:00:00 | 2019-01-06 00:00:00
 | SPEND | START | END | EOY | TOTAL DAYS | FISCAL DAYS | COST/DAY |  | 2018-03-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-02-02 00:00:00
 | 40161.44 | 2018-06-11 00:00:00 | 2018-10-19 00:00:00 | 2019-02-02 00:00:00
 | 10462.32 | 2018-06-25 00:00:00 | 2018-07-18 00:00:00 | 2019-02-02 00:00:00
 | 63406.61 | 2018-04-02 00:00:00 | 2019-07-01 00:00:00 | 2019-02-02 00:00:00
Spreadsheet: 819262d1677353710-autocomplete-from-a-custom-list-sample
Sheet: Sheet1

NAMES | ← DATA ARRAY |  |  |  | [NAME]
[NAME]
[NAME]
[NAME] |  |  | AFTER I CREATE A DATA ARRAY (A2:A8),
[NAME] |  |  | AUTOFILL E1 AS I TYPE A NAME
[NAME] |  |  | FOR EXAMPLE,
[NAME]
[NAME] |  |  | WHAT I TYPE IN CELL E1 |  |  | DESIRED DISPLAY IN CELL E1
 |  |  | J |  |  | J
 |  |  | J. |  |  | J.
 |  |  | J.(space bar) |  |  | J.(space)
 |  |  | J.(space bar)P |  |  | J. P
 |  |  | J.(space bar)PA |  |  | [NAME]
Spreadsheet: 672c6b6b-958f-46b7-821b-4e3f9ae05387
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259185 | 42957 | Christiane | Gottner | GER |  | 00:45:07 | 00:08:06 | 03:38:32 | 00:01:27 | 01:55:30 | 1 | 06:28:42
259185 | 60795 | Monserrat | [NAME] | ESP | 613 | [NAME] | [NAME] | 03:48:48 | 00:01:32 | 02:08:33 | 2 | [NAME]
259185 | 8127 | [NAME] | Sills | GBR | 615 | 00:45:56 | 00:05:38 | 03:49:20 | 00:01:35 | 02:30:06 | 3 | 07:12:36
Spreadsheet: 696563d1600883322-should-i-use-average-or-what-to-solve-this-exmple
Sheet: Sheet1

 |  |  |  | Monthly payments |  | 500
 |  |  |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12
 | PRICE |  |  | Account
Stock 1 | 10
Stock 2 | 120 |  |  | Stock 1 | 11 | 2 | 14 | 11 | 14 | 12 | 14 | 11 | 14 | 11 | 15 | 11
Stock 3 | 150 |  |  | Amount
 |  |  |  | Stock 2 | 2 | 2 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1
 |  |  |  | Amount
 |  |  |  | Stock 3 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2
 |  |  |  | Amount
 |  |  |  | Dividends
 |  |  |  | TOTAL LEFT
Spreadsheet: 804369d1668020497-dynamic-array-horizontal-lookup-across-2d-range-index_match_of_dynamic_2d_array-1-
Sheet: Sheet1

Phase1 |  | Phase2 |  | Phase3 |  | Phase4 |  | Phase5 |  | Phase6 |  | Phase with most recent date/time |  | Dynamic array: Phase with most recent date/time
2020-02-13 10:48:40 |  | 2020-02-14 10:48:40 |  | 2020-02-10 00:00:00 |  | 2020-02-11 00:00:00 |  | 2020-02-19 00:00:00 |  | 2020-02-17 00:00:00
2020-02-26 11:39:33 |  | 2020-02-27 11:39:33 |  | 2020-02-14 00:00:00 |  | 2020-02-21 00:00:00 |  |  |  | 2020-02-24 00:00:00 |  | Phase2
2020-02-26 11:39:33 |  |  |  | 2020-02-14 00:00:00 |  | 2020-02-21 00:00:00 |  | 2020-02-25 00:00:00 |  | 2020-02-24 00:00:00 |  | Phase1
2020-02-29 07:50:18 |  | 2020-02-28 07:50:18 |  | 2020-02-14 00:00:00 |  | 2020-02-21 00:00:00 |  | 2020-02-25 00:00:00 |  | 2020-02-24 00:00:00 |  | Phase1
2020-02-26 12:24:40 |  | 2020-02-27 11:24:40 |  |  |  | 2020-02-21 00:00:00 |  | 2020-02-25 00:00:00 |  | 2020-02-28 00:00:00 |  | Phase6
2020-02-26 12:00:21 |  | 2020-02-27 12:00:21 |  | 2020-02-27 00:00:00 |  | 2020-02-24 00:00:00 |  | 2020-03-04 00:00:00 |  | 2020-03-02 00:00:00 |  | Phase5
 |  |  |  |  |  |  |  |  |  |  |  | Phase1
2020-03-04 12:27:31 |  | 2020-03-05 12:27:31 |  | 2020-02-27 00:00:00 |  |  |  | 2020-03-04 00:00:00 |  | 2020-03-03 00:00:00 |  | Phase2
 |  | 2020-03-06 09:31:49 |  | 2020-02-27 00:00:00 |  | 2020-03-03 00:00:00 |  | 2020-03-04 00:00:00 |  |  |  | Phase2
2020-03-05 09:31:49 |  | 2020-03-06 09:31:49 |  | 2020-02-27 00:00:00 |  | 2020-03-03 00:00:00 |  | 2020-03-04 00:00:00 |  | 2020-03-17 00:00:00 |  | Phase6
2020-03-03 08:03:58 |  | 2020-03-04 08:03:58 |  | 2020-02-27 00:00:00 |  | 2020-03-03 00:00:00 |  | 2020-03-04 00:00:00 |  | 2020-03-05 00:00:00 |  | Phase6
Spreadsheet: 845149d1696671388-filter-between-two-365-workbooks-on-onedrive-etc-template-blank
Sheet: 08.03.23

 |  |  | 2023-08-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-08-01 00:00:00
Appt Time | Priority | Customer | Pickup # | Shipment | ETC | Status | Qty Picked | Left to Pick | Pick | Check | 1st Confirmation | 2ND CONFIRMATION | Load | SAP Stage | Actual Stage | Carrier | Trailer | Dock Door | SEAL | Trailer Arrival Time | Drive Arrival Time | TRAILER DEPARTURE | Notes | Shipment # | Customer2 | Load First City | PTS | PCS | Bins | Drops | Carrier2 | Pickup #2 | Load Time | SAP Door
 |  |  | Shipments | Pcs | Bins | Pcs Picked | Pcs Left
 |  | HD
 |  | LOWES
 |  | MENARDS
 |  | WS
 |  | YOW
 |  | GRAINGER
 |  | AMAZON
 |  | LTL
Billed
Not Picked
Picking
Picked
Confirming
Confirmed
Loading
Loaded
Ready to Load
Spreadsheet: mark_taylor__24799__Europe - ticker layout
Sheet: Iberian Power

Ticker Item | Update Frequency | Source | Input Responsibility | Ticker Text | Layout concept for Linked Page |  |  |  | Contact(s)
1 | Daily and intra-day (24 hourly prices) | http://www.omel.com (Spanish Electricity Market > public domain?) | Iberian Power Trading Desk | Iberian Power Avg. Day Ahead Price: 3,455 PTA/kWh  (equivalent of UK SMP) | Day Ahead Power Prices for DD-MM-YY:  Avg. :   3,500 H1: 3,431 H2: 3,641 .. H24 | PTA/kWh PTA/kWh PTA/kWh  PTA/kWh |  |  | Stuart Ffoulkes
2 | Temperatures - 6 standard cities used: - Madrid - Barcelona - St. Sebastian - 3 others (TBD by SF) | Internal:  [NAME] (Daily temp feed.) - confirm original source | auto-feed? | Spain Weather | Temperatures: Madrid       Barcelona St. Sebastian ... | 10 2.00 | deg. C CDD
3
Spreadsheet: 271870d1382092841-formula-for-forecasting-orders-purchase-order-log
Sheet: Orders

Internal PO Number Log | Site | Lookup | Main Category | Sub Category | Cost Code | Rechargeable | Supplier | Goods/Commentary | Invoice Number | Order Number | Order Date | Delivery date | Period | Invoice Value | Manual Order Value
ABC123 | Home |  | Cleaning | Materials |  |  | [NAME] | Cleaning | ABC111 | 11111 | 2013-10-01 00:00:00 | 2013-10-22 00:00:00 | 7 | 15 | 15
ABC124 | Home |  | Cleaning | Materials |  |  | [NAME] | Cleaning | ABC112 | 11112 | 2013-10-02 00:00:00 | 2013-10-23 00:00:00 | 7 | 18 | 18
ABC125 | Home |  | Cleaning | Materials |  |  | [NAME] | Cleaning | ABC113 | 11113 | 2013-10-03 00:00:00 | 2013-10-24 00:00:00 | 7 | 20 | 20
ABC126 | Home |  | Cleaning | Materials |  |  | [NAME] | Cleaning | ABC114 | 11114 | 2013-10-04 00:00:00 | 2013-10-25 00:00:00 | 7 | 30 | 30
ABC127 | Home |  | Cleaning | Materials |  |  | [NAME] | Cleaning | ABC115 | 11115 | 2013-10-05 00:00:00 | 2013-10-26 00:00:00 | 7 | 60 | 60
ABC128 | Home |  | Cleaning | Materials |  |  | [NAME] | Cleaning | ABC116 | 11116 | 2013-10-06 00:00:00 | 2013-10-27 00:00:00 | 7 | 10 | 10
ABC129 | Home |  | Cleaning | Materials |  |  | [NAME] | Cleaning | ABC117 | 11117 | 2013-10-07 00:00:00 | 2013-10-28 00:00:00 | 7 | 5.99 | 5.99
ABC130 | Home |  | Cleaning | Materials |  |  | [NAME] | Cleaning | ABC118 | 11118 | 2013-10-08 00:00:00 | 2013-10-29 00:00:00 | 7 | 3.68 | 3.68
ABC131 | Home |  | Cleaning | Materials |  |  | [NAME] | Cleaning | ABC119 | 11119 | 2013-10-09 00:00:00 | 2013-10-30 00:00:00 | 7 | 2 | 2
ABC132 | Home |  | Cooking | Materials |  |  | ASDA | Catering | ABC120 | 11120 | 2013-10-10 00:00:00 | 2013-10-31 00:00:00 | 7 | 5 | 5
ABC133 | Home |  | Cooking | Materials |  |  | ASDA | Catering | ABC121 | 11121 | 2013-10-11 00:00:00 | 2013-10-01 00:00:00 | 7 | 10 | 10
ABC134 | Home |  | Cooking | Materials |  |  | ASDA | Catering | ABC122 | 11122 | 2013-10-12 00:00:00 | 2013-10-02 00:00:00 | 7 | 9 | 9
ABC135 | Home |  | Cooking | Materials |  |  | ASDA | Catering | ABC123 | 11123 | 2013-10-13 00:00:00 | 2013-10-05 00:00:00 | 7 | 8 | 8
ABC136 | Home |  | Cooking | Materials |  |  | ASDA | Catering | ABC124 | 11124 | 2013-10-14 00:00:00 | 2013-10-06 00:00:00 | 7 | 16 | 16
ABC137 | Home |  | Cooking | Materials |  |  | ASDA | Catering | ABC125 | 11125 | 2013-10-15 00:00:00 | 2013-10-07 00:00:00 | 7 | 20 | 20
Spreadsheet: 101991d1300058721-protected-sheets-and-macros-demo
Sheet: Sheet1

Date | Name1 | [NAME] | Time in hours |  | [NAME]
2010-07-01 00:00:00 | [NAME] | Fred | 0.5 |  | Lemonade
2010-07-01 00:00:00 | [NAME] | [NAME] | 0.5
2010-07-01 00:00:00 | [NAME] | Crazy [NAME] | 0.5
2010-07-01 00:00:00 | [NAME] | [NAME] | 0.5
2010-07-01 00:00:00 | [NAME] | [NAME] | 0.5
2010-07-01 00:00:00 | [NAME] | Curly Fries | 0.5
2010-07-01 00:00:00 | [NAME] | Lemonade | 0.5
2010-07-01 00:00:00 | [NAME] | Jingo | 0.5
2010-07-01 00:00:00 | [NAME] | Reynastus | 0.5
2010-07-01 00:00:00 | [NAME] | [NAME] | 0.5
2010-07-01 00:00:00 | [NAME] | [NAME] | 0.5
2010-07-07 00:00:00 | Ish | Fred | 0.5
2010-07-07 00:00:00 | Ish | [NAME] | 0.5
2010-07-07 00:00:00 | Ish | Crazy [NAME] | 0.5
2010-07-07 00:00:00 | Ish | [NAME] | 0.5
2010-07-07 00:00:00 | Ish | [NAME] | 0.5
2010-07-07 00:00:00 | Ish | Curly Fries | 0.5
2010-07-07 00:00:00 | Ish | Lemonade | 0.5
2010-07-07 00:00:00 | Ish | Jingo | 0.5
2010-07-14 00:00:00 | Flail | Reynastus | 0.5
2010-07-14 00:00:00 | Flail | [NAME] | 0.5
2010-07-14 00:00:00 | Flail | [NAME] | 0.5
2010-07-14 00:00:00 | Flail | Fred | 0.5
2010-07-14 00:00:00 | Flail | [NAME] | 0.5
2010-07-14 00:00:00 | Flail | Crazy [NAME] | 0.5
2010-07-14 00:00:00 | Flail | [NAME] | 0.5
2010-07-14 00:00:00 | Flail | [NAME] | 0.5
2010-07-14 00:00:00 | Flail | Curly Fries | 0.5
2010-07-14 00:00:00 | Flail | Lemonade | 0.5
2010-07-14 00:00:00 | Flail | Jingo | 0.5
2010-07-14 00:00:00 | Flail | Reynastus | 0.5
2010-07-21 00:00:00 | Blah2 | [NAME] | 0.5
2010-07-21 00:00:00 | Blah2 | [NAME] | 0.5
2010-07-21 00:00:00 | Blah2 | Fred | 0.5
2010-07-21 00:00:00 | Blah2 | [NAME] | 0.5
2010-07-21 00:00:00 | Blah2 | Crazy [NAME] | 0.5
2010-07-21 00:00:00 | Blah2 | [NAME] | 0.5
2010-07-21 00:00:00 | Blah2 | [NAME] | 0.5
2010-07-21 00:00:00 | Blah2 | Curly Fries | 0.5
2010-07-21 00:00:00 | Blah2 | Lemonade | 0.5
2010-07-21 00:00:00 | Blah2 | Jingo | 0.5
2010-07-21 00:00:00 | Blah2 | Reynastus | 0.5
2010-08-04 00:00:00 | AndSoOn | [NAME] | 0.5
2010-08-04 00:00:00 | AndSoOn | [NAME] | 0.5
2010-08-04 00:00:00 | AndSoOn | Fred | 0.5
2010-08-04 00:00:00 | AndSoOn | [NAME] | 0.5
2010-08-04 00:00:00 | AndSoOn | Crazy [NAME] | 0.5
2010-08-04 00:00:00 | AndSoOn | [NAME] | 0.5
2010-08-04 00:00:00 | AndSoOn | [NAME] | 0.5
2010-08-04 00:00:00 | AndSoOn | Curly Fries | 0.5
2010-08-04 00:00:00 | AndSoOn | Lemonade | 0.5
2010-08-04 00:00:00 | AndSoOn | Jingo | 0.5
2010-08-04 00:00:00 | AndSoOn | Reynastus | 0.5
2010-08-04 00:00:00 | AndSoOn | [NAME] | 0.5
2010-08-04 00:00:00 | AndSoOn | [NAME] | 0.5
Spreadsheet: 193835d1352969999-exracting-column-data-using-a-date-range-accountsx
Sheet: Prof&Loss

Gross to Date
Fixed Costs
Accountant
Depreciate
Insure
[NAME]
Licences & Govt Fees
[NAME]
Rates
Other
Total
Variable Costs
Adverts
Paypal Fees
eBay Fees
Bank
Goods
Freight Travel
[NAME]
Mags
Power
Phone and Data
Print & Pack
Materials
Maint
Wages
Capital Items
Other
Total
Final Profit or Loss Total
Spreadsheet: e1cf5eb1-cda8-4ea6-bf84-f6808b25070b
Sheet: Sheet1

2013-01-01 00:00:00 | Units are no longer allowed to bring their own firewood to camp | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
CHARTS ARE UPDATED DAILY. FOR UP TO THE MINUTE AVAILABILITY CALL (716) 891-4073 OR E-MAIL [EMAIL] |  |  |  |  |  |  | 2013-01-25 00:00:00
SCHOELLKOPF |  |  |  | 2013 | 2013 | 2013 | 2013
 | Capacity | Code | FEE | JAN 4 - 6 | JAN 11 - 13 | JAN 18 - 20 | JAN 25 - 27
District/Council Events |  |  |  |  |  | KLONDIKE
**Phillip (Lower) | 8 | S,W,E | 48 |  | T513 | T139 W
**Schoellkopf (Upper) | 12 | S,W,E | 72 |  | T513 W | T54 1/4W
Schwartz | 14 | S,W | 70 |  | T523 | T173 W
Score | 18 | S,W,E | 108 |  | [NAME] | T457 W | [NAME]
**Self | 12 | S,W,E | 72 |  |  | T445 W
Sikes | 16 | S,W,E,C | 96 | P325 W | [NAME] | T431 W | [NAME]
**Toulmin | 18 | S,W,E | 108 |  | T37 1/4W | T468 W
Lean-To's
**Art Wood (Flats) | 12 | W | 48 |  |  | T352 W
**[NAME] (Flats) | 12 | W | 48 |  |  | T93
**[NAME] (Northwoods) | 12 | W | 48
**Seibel (Northwoods) | 12 | W | 48 |  |  | T664 W
**[NAME] (Meyer Village) | 12 | W | 48 |  | T554 W | T618
**[NAME] (Meyer Village) | 12 | W | 48 |  | T554 W | T618
**Faso (Meyer Village) | 12 | W | 48 |  | T554 W | [NAME]
Troop 7 Shelter | 20 | S,W,E | 96 |  |  | T565 W | T864/128 W
**Szymkowiak lean-to | 12 | W, E | 72 |  | T256 W | T107 | T156 (S) W
McCormick - Klondike Host |  |  |  |  |  | T261 W
Tenting $2 per person, per night
Tenting $2 per person, per night
Tenting $2 per person, per night
Day Hike $2 per person
**SEASONAL [NAME] MAY BE CLOSED FOR VEHICLE TRAFFIC, PLEASE CONTACT THE RANGER AT [PHONE]
SCOUTHAVEN |  |  |  | 2013 | 2013 | 2013 | 2013
 | Capacity | CODE | FEE | JAN 4 - 6 | JAN 11 - 13 | JAN 18 - 20 | JAN 25 - 27
District/Council Events |  |  |  |  |  | KLONDIKE
[NAME] | 20 | S,W,E | 120 |  | P420 W
Loegler 1 | 20 | C,S,W,E | 120 |  | T735 W | [NAME] | T411 W
Loegler 2 | 20 | C,S,W,E | 120 |  | P539 W | [NAME] | P411 W
[NAME] | 30 | C,S,W,E | 180 | [NAME] | P539 W | T230 W | P529 W
Lean-To's
#1 Eagle | 12 | W | 48 |  |  | [NAME] | T500 W
#2 Whitetail | 12 | W | 48 |  |  | T285 W
#3 Dziedzic | 12 | W | 48 |  |  | T285 W | T429 W
Moose | 10 | W | 40 |  |  | T48
Boss | 12 | W | 48 | P416 |  | T8113 W
Tenting $2 per person, per night
Tenting $2 per person, per night
Day Hike $2 per person
 |  |  |  | 2013 | 2013 | 2013 | 2013
[NAME] | Capacity | CODE | FEE | JAN 4 - 6 | JAN 11 - 13 | JAN 18 - 20 | JAN 25 - 27
District/Council Events |  |  |  |  |  | KLONDIKE
Cabin #1  (Porch) | 24 | S,W,E | 144 |  |  | T286 W
Cabin #2 | 24 | S,W,E | 144 |  | P3044 | T833 1/4W
Leader's Lodge | 28 | S,W,E | 168 |  | T440 W | T829 W
[NAME] | 30 | C,S,W,E | 180 |  | P3044 W | T450 W | P620 W
Stone Lean-To | 6 | [NAME] | 24 |  |  | T229
Troop 107 Lean-To | 8 | W | 30 |  |  | T539 W
Tenting $2 per person, per night
Tenting $2 per person, per night
Tenting $2 per person, per night
Day Hike $2 per person
Code: S=Cooking Stove; W=Wood Heating Stove; E=Electricity; C=Co-Ed Ready
Firewood is $50.00 per 1/2 face cord.
Spreadsheet: 39508d1237749643-how-to-choose-a-range-that-for-chitest-that-includes-multiple-columns-chitest
Sheet: Sheet1

ACTUAL | # of Germinated Seeds | # of Non-Germinated Seeds | Total |  | actual | expected
Water | 12 | 13 | 25 |  | 12 | 7
Lettuce Extract | 9 | 16 | 25 |  | 9 | 7
Raddish Extract | 0 | 25 | 25 |  | 0 | 7
Total | 21 | 54 | 75 |  | 13 | 18
 |  |  |  |  | 16 | 18
 |  |  |  |  | 25 | 18
EXPECTED | # of Germinated Seeds | # of Non-Germinated Seeds | Total
Water | 7 | 18 | 25
Lettuce Extract | 7 | 18 | 25
Raddish Extract | 7 | 18 | 25
Total | 21 | 54 | 75
0.000435901072605806 | 22.41828379593716
0.00851012840210717 | 15.47619047619047
Spreadsheet: 886060d1736026735-calculate-rankings-of-subset-of-data-ranks
Sheet: Sheet1

Category | Rank | Value | Revised Rank | Gregb11
A | 3 | 78
A | 5 | 66
A | 8 | 53
A | 4 | 74
A | 7 | 59
A | 6 | 65
A |  | 0
A | 1 | 85
A | 2 | 82
A |  | 0
B | 3 | 65
B | 11 | 2
B |  | 0
B | 2 | 70
B | 7 | 48
B | 5 | 56
B |  | 0
B | 10 | 10
B | 8 | 38
B | 6 | 53
B | 4 | 57
B | 1 | 71
B | 9 | 21
C | 1 | 90
C | 3 | 80
C | 2 | 82
C | 4 | 79
C | 5 | 70
Spreadsheet: 1289a949-3ee6-4740-9f55-62ad0d0aa349
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 | 12.7m
 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 11.7m | 18.4m
 |  |  |  |  |  | Capacity = 60
 |  |  |  |  |  |  | G.07
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.7m
 |  |  |  |  |  |  | G.07a
 |  |  | Power - Can not be moved
 |  |  | 1600[NAME] table
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 12c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency TOTAL | 28343 | 3463 | 14158 | 13683 | 16236 | 12783 | 12087 | 687 | 101440
Spreadsheet: 231504d1367098248-two-misaligned-cells-16-team-planning-bracket
Sheet: 160

az160 | Aztec | 1
bl160 | Bloomfield
cib160 | Cibola
cle160 | Cleveland
far160 | Farmington
gal160 | Gallup
grt160 | Grants | 8
kc160 | [NAME]
miy160 | Miyamura | 5
new160 | Newcomb
pv160 | Piedra Vista
rr160 | Rio Rancho
sf160 | Santa Fe
ship160 | Shiprock
vv160 | [NAME] | 4
win160 | Wingate
 |  | 3
Paste Value - CTRL-N
 |  | 6
 |  | 7
 |  | 2
Spreadsheet: daren_farmer__6004__hpl0620
Sheet: Sheet1

HPLN0620.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective June 20, 2000
 |  |  |  |  |  | ** Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-06-20 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM | VOLUME
Enron (FM) |  | LS HPL [NAME] |  | HPL | 0 | 30
Enron (FM) |  | HPL - Katy (DBND) |  | HPL | 0 | 0
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | TOG 3 |  | Empire | 1.4 | 1.4
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 0.65 | 0.65
Empire (Enron) |  | Oasis Turbine |  | Empire | 7.95 | 7.95
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher