tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 49578d1248940083-trade-signal-analysis-worksheet-spx20year-new-model
Sheet: SPX 20 YEAR PL

Date | PX_LAST | MOV_AVG_200D |  |  |  | TRADE SIGNAL | TRs | PROFIT/LOSS
1992-04-09 00:00:00 | 400.64 | 394.78 | -1 | 1 | -1 | BUY | 1 | 53.94999999999999
1994-10-04 00:00:00 | 454.59 | 460.87 | -1 | 2 | 2 | SELL | 1 | 11.20000000000005
1994-10-11 00:00:00 | 465.79 | 460.62 | -1 | 1 | -1 | BUY | 1 | 161.08
1996-07-23 00:00:00 | 626.87 | 633.43 | -1 | 2 | 2 | SELL | 1 | 415.7199999999999
1998-08-27 00:00:00 | 1042.59 | 1058.74 | -1 | 2 | 2 | SELL | 1 | 0.1300000000001091
1998-09-24 00:00:00 | 1042.72 | 1064.56 | -1 | 2 | 2 | SELL | 1 | 43.21000000000004
1998-10-29 00:00:00 | 1085.93 | 1073.81 | -1 | 1 | -1 | BUY | 1 | 194.48
1999-09-23 00:00:00 | 1280.41 | 1302.35 | -1 | 2 | 2 | SELL | 1 | 44.99000000000001
1999-10-06 00:00:00 | 1325.4 | 1307.74 | -1 | 1 | -1 | BUY | 1 | -39.85000000000014
1999-10-13 00:00:00 | 1285.55 | 1310.25 | -1 | 2 | 2 | SELL | 1 | 56.8900000000001
1999-10-28 00:00:00 | 1342.44 | 1312.27 | -1 | 1 | -1 | BUY | 1 | 3.649999999999864
2000-02-18 00:00:00 | 1346.09 | 1361.88 | -1 | 2 | 2 | SELL | 1 | 46.05000000000018
2000-03-15 00:00:00 | 1392.14 | 1365.68 | -1 | 1 | -1 | BUY | 1 | -35.58000000000015
2000-04-14 00:00:00 | 1356.56 | 1383.42 | -1 | 2 | 2 | SELL | 1 | 44.88000000000011
2000-04-17 00:00:00 | 1401.44 | 1383.47 | -1 | 1 | -1 | BUY | 1 | 6.369999999999891
2000-05-11 00:00:00 | 1407.81 | 1387.62 | -1 | 1 | -1 | BUY | 1 | -33.95000000000005
2000-05-23 00:00:00 | 1373.86 | 1391.96 | -1 | 2 | 2 | SELL | 1 | 48.59000000000015
2000-05-30 00:00:00 | 1422.45 | 1393.82 | -1 | 1 | -1 | BUY | 1 | -290.5800000000002
2002-03-25 00:00:00 | 1131.87 | 1143.53 | -1 | 2 | 2 | SELL | 1 | -267.6399999999999
2003-03-24 00:00:00 | 864.23 | 891.76 | -1 | 2 | 2 | SELL | 1 | 29.35000000000002
2003-04-17 00:00:00 | 893.58 | 880.24 | -1 | 1 | -1 | BUY | 1 | 200.3000000000001
2004-07-21 00:00:00 | 1093.88 | 1105.01 | -1 | 2 | 2 | SELL | 1 | 37.61999999999989
2004-10-01 00:00:00 | 1131.5 | 1118.42 | -1 | 1 | -1 | BUY | 1 | 11.72000000000003
2005-04-28 00:00:00 | 1143.22 | 1155.06 | -1 | 2 | 2 | SELL | 1 | 142.3599999999999
2006-08-15 00:00:00 | 1285.58 | 1271.95 | -1 | 1 | -1 | BUY | 1 | 147.48
2007-08-03 00:00:00 | 1433.06 | 1450.65 | -1 | 2 | 2 | SELL | 1 | 34.61000000000013
2007-08-06 00:00:00 | 1467.67 | 1451.17 | -1 | 1 | -1 | BUY | 1 | -35.31000000000017
2007-08-28 00:00:00 | 1432.36 | 1457.23 | -1 | 2 | 2 | SELL | 1 | 41.63000000000011
2007-08-31 00:00:00 | 1473.99 | 1458.49 | -1 | 1 | -1 | BUY | 1 | -6.039999999999964
2007-12-14 00:00:00 | 1467.95 | 1486.67 | -1 | 2 | 2 | SELL | 1 | -525.08
2009-06-01 00:00:00 | 942.87 | 926.89 | -1 | 1 | -1 | BUY | 1 | -942.87
Spreadsheet: 847914d1698758551-conditional-formatting-of-referenced-cells-conditional-formatting-example-aligw
Sheet: Item 3

 | Goal | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | YTD
Disposition |  | 12 | 18 | 99 | 100 | 100 | 100 | 88 | 99 | 100 |  |  |  | 79.55555555555556
Source Code |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting results from Source Code tab, line 4
Template |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting results from Template tab, line 4
Submittal |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting results from Submittal tab, line 4
Spreadsheet: 169219d1342729632-creating-a-data-summary-from-a-matrix-ef129_example-2-
Sheet: Summary

Day | Mon
Name | Value
Spreadsheet: 773756d1648036696-compare-2-lists-to-identify-matches-existing-values-test1v2
Sheet: Sheet1

ID | Sheet2 Column H = ABC | Expected | Sheet2 Column H = ABC AND Sheet2 Column J = XYZ | Expected
[PHONE] |  | Yes
[PHONE] |  | Yes
[PHONE]
[PHONE]
[PHONE]
[PHONE] |  | Yes |  | Yes
[PHONE] |  | Yes |  | Yes
[PHONE]
[PHONE]
[PHONE] |  | Yes |  | Yes
[PHONE] |  | Yes
[PHONE] |  | Yes
[PHONE]
Spreadsheet: 777330d1650333089-show-first-to-the-last-day-of-the-month-first_lastmonth
Sheet: Sheet1

 | Month | Day
 | 2022-04-01 00:00:00
Spreadsheet: 596719ca-3281-48d5-a5c2-5b1c3261de84
Sheet: Sheet1

Title | Upload Date | Module | Authors | Print Publication Date | DOI | ISBN | Sub-discipline | LINK | Site Module Name
Going Over: The Mesolithic-Neolithic Transition in North-West Europe | Feb-12 | Archaeology | [NAME], Cummings | 2007 | 10.5871/bacad/[PHONE].001.0001 | 9780197264140 | Archaeology, Prehistoric Archaeology | http://www.britishacademypublications.com/view/10.5871/bacad/[PHONE].001.0001/bacad-[PHONE] | archaeology
Images and Artefacts of the Ancient World | Feb-12 | Archaeology | [NAME], [NAME] | 2005 | 10.5871/bacad/[PHONE].001.0001 | 9780197262962 | Archaeology, Methodology and Techniques | http://www.britishacademypublications.com/view/10.5871/bacad/[PHONE].001.0001/bacad-[PHONE] | archaeology
The Lost Woodlands of Ancient Nasca | [NAME] | Archaeology | Beresford-Jones | 2011 | 10.5871/bacad/[PHONE].001.0001 | 9780197264768 | Archaeology, Prehistoric Archaeology | [NAME] | archaeology
Mediterranean Urbanization 800-600 BC | Feb-12 | Archaeology | Osborne, [NAME] | 2005 | 10.5871/bacad/[PHONE].001.0001 | 9780197263259 | Archaeology, Historical Archaeology | http://www.britishacademypublications.com/view/10.5871/bacad/[PHONE].001.0001/bacad-[PHONE] | archaeology
The Speciation of Modern Homo Sapiens | Feb-12 | Archaeology | Crow | 2004 | 10.5871/bacad/[PHONE].001.0001 | 9780197263112 | Archaeology, Prehistoric Archaeology | http://www.britishacademypublications.com/view/10.5871/bacad/[PHONE].001.0001/bacad-[PHONE] | archaeology
Spreadsheet: acc39e1d-2806-4f65-bb20-c84d1af89679
Sheet: 1

 | Jun 28 | Jul 5 | Jul 12 | Jul 19 | Jul 26
Total Interest Rate* | 327659186 | 400176292 | 407544951 | 409603188 | 415233742
Cleared** | 195477507 | 195999899 | 199995874 | 202237153 | 206005881
Uncleared | 132181678 | 204176394 | 207549077 | 207366035 | 209227861
Total Cross-Currency | 9289339 | 16205406 | 16388810 | 16351629 | 16491326
Cleared | N/A*** | N/A | N/A | N/A | N/A
Uncleared | 9289339 | 16205406 | 16388810 | 16351629 | 16491326
Total Credit | 20241959 | 20428492 | 20551759 | 20494037 | 20664345
Cleared | 2890797 | 3037409 | 2924048 | 2920233 | 2949205
Uncleared | 17351162 | 17391083 | 17627711 | 17573804 | 17715140
Total Equity | 5753449 | N/A | N/A | N/A | N/A
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 5753449 | N/A | N/A | N/A | N/A
Total Other Commodity | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 366034933 | 439901190 | 447576520 | 449539854 | 455480413
Weekly snapshot, estimated gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 02f40137-0d81-4f98-8b76-203b78ef2722
Sheet: Figure 3

State Charter School Policies
Figure 3
State Policies | Yes | No | Partial
Charter schools received their funding directly from the state | X
Charter schools are eligible for local funding |  | X
[NAME] on funding a charter school can receive |  |  | 1
District public school receive differential funding (e.g. more funding for 9-12 vs. K-8 schools) | 2
Charter schools receive differential funding | 3
State allows districts to withhold funding from charter schools for providing adminstrative services | 4
State "holds harmless" ditrict funding for charter enrollment |  | X
School is considered LEA if authorized by non-district organization | X
School is considered LEA if authorized by district | X
[NAME] on number of charter schools | 5
[NAME] on number of charters schools authorized per year |  | X
[NAME] on number of studens attending charter schools |  | X
Charter schools have an open enrollment policy | 6
1. Internet- or computer-based Community Schools receive only the formula amount and the special education weighted amount
2. The amount of state funds available to a school is based on a number of variables, including a cost-of-doing business factor for a community, six special education factors, and a Disadvantaged Pupil Impact Aid (DPIA) adjustment factor.  [NAME] receive one-half the funding for kindergarten students.
3. See two above
4. The state allows sponsors to charge up to a 3 percent admnistrative fee (of per-pupil funding) to provide sponsorship.  Sponsors may also sell additional services to schools.
5. Ohio law allows 30 start-up charters authorized by non-district entities and 30 start-up charters authorized by districts above the number open as of May 5, 2005. Operators of charter schools with a track record of success are not subject to these restrictions, though. Ohio law also has a moratorium in place on new virtual schools.
6,  There are three open enrollment policies in Ohio.  Two are concerned with intradistrict transfers which allow students in low-performing schools to attend different schools within the school district.  The third is an interdistrict  (voluntary) policy which requires districts to determine whether they will admint nonresident students.  "E-schools" are a good example of schools operating under the state's open enrollment policies.
Spreadsheet: 149342d1333861405-split-a-dollar-figure-into-the-minimum-pieces-of-currency-for-refund-copy-of-denominator-sample-2
Sheet: Sheet1

0.41
10.41
20.41
30.41
40.41
40.05
50.05
31.91
40.16
40.15
 | 20 | 10 | 5 | 1 | 0.25 | 0.1 | 0.05 | 0.01 | Denom Total
Spreadsheet: 110818d1307413793-search-and-match-database
Sheet: Database 1

COST_CENTRE | SUPPLIER | MODEL | SERIAL | REMARKS | QUANTITY | UNIT_PRICE | DELIVERY_DATE | ITEM_STATUS | COUNTRY | BUILDING | FLOOR | FACING
206 | dfg | COMPAQ EVO D510 ULTRASLIM | 7312KPBZ0401 | [TG] OA PC. | 1 | 1187.01 | 01-03-2003 | Personal | SIN | CONNECTION ONE TOWER FIVE | 11 | NW
206 | dfg | TREK | T2MG3M256040800013 | Control Label No: C02080. [TG] | 1 | 0 | 29-03-2004 | Personal | SIN | CONNECTION ONE TOWER FIVE | 11 | NW
206 | abc | VIEWSONIC VX724 | PSN053528364 | [TG] OA PC. | 1 | 464 | 21-03-2006 | Personal | SIN | CONNECTION ONE TOWER FIVE | 11 | NW
206 | abc | HP ELITEBOOK 6930p | 2CE901019J | [TG] | 1 | 1830.21 | 19-11-2008 | Personal | SIN | CONNECTION ONE TOWER FIVE | 11 | NW
Spreadsheet: 61643d1262593055-matching-prices-for-shopping-items-example
Sheet: Part 1 of attempt - Calculation

Part 1/2 of Attempt
Worksheet 1 - List of shopping items
 | Item list |  |  |  |  | Calculation |  |  |  |  |  |  |  |  |  | Data pull
 | Item Name | Quantity |  |  |  | Smallest difference | Price | Total Price |  |  |  | Relevant Quantity and price |  |  |  |  |  |  | Find closest quantity
 | B - qty |  |  |  |  |  |  |  |  |  |  | Qty | 20 | 40 | 60 | 80 | 100 |  | Closeness | 3 | 17 | 37 | 57 | 77
 | B | 23 |  |  |  | 3 | 1.12 | 25.76 |  |  |  | Price | 1.12 | 1 | 0.8 | 0.8 | 0.9 |  | Price | 1.12 | 1 | 0.8 | 0.8 | 0.9
 | A - qty |  |  |  |  |  |  |  |  |  |  | Qty | 10 | 20 | 0.8 | 40 | 50 |  | Closeness | 3 | 7 | 12.2 | 27 | 37
 | A | 13 |  |  |  | 3 | 1 | 13 |  |  |  | Price | 1 | 0.86 | 0.8 | 0.77 | 0.74 |  | Price | 1 | 0.86 | 0.8 | 0.77 | 0.74
 | A - qty |  |  |  |  |  |  |  |  |  |  | Qty | 10 | 20 | 0.8 | 40 | 50 |  | Closeness | 32 | 22 | 41.2 | 2 | 8
 | A | 42 |  |  |  | 2 | 0.77 | 32.34 |  |  |  | Price | 1 | 0.86 | 0.8 | 0.77 | 0.74 |  | Price | 1 | 0.86 | 0.8 | 0.77 | 0.74
 | C - qty |  |  |  |  |  |  |  |  |  |  | Qty | 100 | 200 | 300 | 400 | 500 |  | Closeness | 12 | 112 | 212 | 312 | 412
 | C | 88 |  |  |  | 12 | 2.3 | 202.4 |  |  |  | Price | 2.3 | 2.25 | 0.9 | 1.9 | 1.86 |  | Price | 2.3 | 2.25 | 0.9 | 1.9 | 1.86
 | B - qty |  |  |  |  |  |  |  |  |  |  | Qty | 20 | 40 | 60 | 80 | 100 |  | Closeness | 43 | 23 | 3 | 17 | 37
 | B | 63 |  |  |  | 3 | 0.8 | 50.40000000000001 |  |  |  | Price | 1.12 | 1 | 0.8 | 0.8 | 0.9 |  | Price | 1.12 | 1 | 0.8 | 0.8 | 0.9
 | D - qty |  |  |  |  |  |  |  |  |  |  | Qty | 5 | 10 | 15 | 20 | 30 |  | Closeness | 3 | 8 | 13 | 18 | 28
 | D | 2 |  |  |  | 3 | 12 | 24 |  |  |  | Price | 12 | 11.2 | 2 | 10.2 | 9.6 |  | Price | 12 | 11.2 | 2 | 10.2 | 9.6
 | A - qty |  |  |  |  |  |  |  |  |  |  | Qty | 10 | 20 | 0.8 | 40 | 50 |  | Closeness | 25 | 15 | 34.2 | 5 | 15
 | A | 35 |  |  |  | 5 | 0.77 | 26.95 |  |  |  | Price | 1 | 0.86 | 0.8 | 0.77 | 0.74 |  | Price | 1 | 0.86 | 0.8 | 0.77 | 0.74
 | D - qty |  |  |  |  |  |  |  |  |  |  | Qty | 5 | 10 | 15 | 20 | 30 |  | Closeness | 17 | 12 | 7 | 2 | 8
 | D | 22 |  |  |  | 2 | 10.2 | 224.4 |  |  |  | Price | 12 | 11.2 | 2 | 10.2 | 9.6 |  | Price | 12 | 11.2 | 2 | 10.2 | 9.6
 | D - qty |  |  |  |  |  |  |  |  |  |  | Qty | 5 | 10 | 15 | 20 | 30 |  | Closeness | 28 | 23 | 18 | 13 | 3
 | D | 33 |  |  |  | 3 | 9.6 | 316.8 |  |  |  | Price | 12 | 11.2 | 2 | 10.2 | 9.6 |  | Price | 12 | 11.2 | 2 | 10.2 | 9.6
 |  |  |  |  |  |  |  | 916.05
Spreadsheet: 166194d1341498212-need-to-create-a-dependant-drop-down-controlled-through-2-prior-drop-downs-electrical-price-list-testing-sheet
Sheet: Lighting

 |  |  |  | Price as shown in Cat |  |  |  |  |  |  |  | Price Per unit [NAME] |  |  |  |  |  | Cheapest
Cat | Manu | Ref | Item | 0 | 0 | 1 | 1 | 1 | 1 | VAT Factor | Unit | 0
 |  |  |  | Toolstation | ScrewFix | TLC Direct | Shop 4 Elec | EIS Ltd | Other |  | Qty | Toolstation | ScrewFix | TLC Direct | Shop 4 Elec | EIS Ltd | Other | Price | Store
Lighting | Wylex | TP R16BOHF | IP65 Round HF Polycarb Bulkhead  2D 16w Black/Opal Dia: 200 x 80mm |  |  | 9.95 |  |  |  | 1.2 | 1
Lighting | Volex | TP R16BPHF | IP65 Round HF Polycarb Bulkhead  2D 16w Black/Prismatic Dia: 200 x 80mm |  |  | 9.95 |  |  |  | 1.2 | 1
Lighting | MK Logic Plus | TP R16WOHF | IP65 Round HF Polycarb Bulkhead  2D 16w White/Opal Dia: 200 x 80mm |  |  | 9.95 |  |  |  | 1.2 | 1
Lighting | Telco | TP R16WPHF | IP65 Round HF Polycarb Bulkhead  2D 16w White/Prismatic Dia: 200 x 80mm |  |  | 9.95 |  |  |  | 1.2 | 1
Lighting | Telco | TP R28BOHF | IP65 Round HF Polycarb Bulkhead  2D 28w Black/Opal Dia: 200 x 80mm |  |  | 15.95 |  |  |  | 1.2 | 1
Lighting | Telco | TP R28BPHF | IP65 Round HF Polycarb Bulkhead  2D 28w Black/Prismatic Dia: 200 x 80mm |  |  | 15.95 |  |  |  | 1.2 | 1
Lighting | Telco | TP R28WOHF | IP65 Round HF Polycarb Bulkhead  2D 28w White/Opal Dia: 200 x 80mm |  |  | 15.95 |  |  |  | 1.2 | 1
Lighting | Generic | TP R28WPHF | IP65 Round HF Polycarb Bulkhead  2D 28w White/Prismatic Dia: 200 x 80mm |  |  | 15.95 |  |  |  | 1.2 | 1
Lighting | Generic | TP S28BOHF | IP65 Square HF Polycarb Bulkhead  2D 28w Black/Opal Dia: 200x200x80mm |  |  | 15.95 |  |  |  | 1.2 | 1
Lighting | Generic | TP S28BPHF | IP65 Square HF Polycarb Bulkhead  2D 28w Black/Prismatic Dia: 200x200x80mm |  |  | 15.95 |  |  |  | 1.2 | 1
Lighting | Generic | TP S28WOHF | IP65 Square HF Polycarb Bulkhead  2D 28w White/Opal Dia: 200x200x80mm |  |  | 15.95 |  |  |  | 1.2 | 1
Lighting | Generic | TP S28WPHF | IP65 Square HF Polycarb Bulkhead  2D 28w White/Prismatic Dia: 200x200x80mm |  |  | 15.95 |  |  |  | 1.2 | 1
Lighting |  |  |  |  |  |  |  |  |  | 1.2 | 1
Lighting
Lighting
Lighting
Lighting
Lighting
Lighting
Lighting
Lighting
Spreadsheet: 763145d1642008895-xlookup-with-multiple-criteria-book1-1-
Sheet: Sheet1

 | Region Formula | Main WorkCtr |  |  |  | Return Array | [NAME]
 |  | C10332SK |  |  |  | CARLYLE | WN
 |  | C10332SK |  |  |  | NORTH BATTLEFORD | NB
 |  | C10332SK |  |  |  | [NAME] | PA
 |  | WN07AM02 |  |  |  | REGINA | RE
 |  | WN07AM02 |  |  |  | SASKATOON | SK
 |  | WN07AM02 |  |  |  | SWIFT CURRENT | SC
 |  | WN07AM02 |  |  |  | WEYBURN | WN
 |  | WN07AM02 |  |  |  | YORKTON | YN
 |  | WN07AM02
 |  | YN07AM01
 |  | YN07AM01
 |  | YN07AM01
 |  | YN07AM01
 |  | YN07AM01
 |  | YN07AM01
 |  | YN07AM01
 |  | YN07AM01
 |  | NB07AM01
 |  | NB07AM01
 |  | NB07AM01
 |  | NB07AM01
 |  | NB07AM01
 |  | NB07AM01
 |  | NB07AM01
 |  | NB07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | WN07AM01
 |  | WN07AM01
 |  | WN07AM01
 |  | WN07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
Spreadsheet: 170229d1343213925-nested-if-sums-examnesifs
Sheet: Sheet1

Account Number |  |  | Export
120 |  |  | 189
189 |  |  | 45
45 |  |  | 12
30
89
189
12
27
45
30
89
189
12
27
45
30
89
189
12
27
45
30
89
189
12
45
30
89
189
30
89
189
12
45
Spreadsheet: 788593d1658565918-bifurcate-the-amount-as-per-date-day-difference-duty-exemption-1-2-
Sheet: Sheet1

 | Duty Amount | Debit | Credit | Duty Date
 | 2028.59 |  |  | 2019-04-18 00:00:00
 | 7514.71 |  |  | 2019-05-18 00:00:00
 | 8983.9 |  |  | 2019-06-20 00:00:00
 | 13777.19 |  |  | 2019-07-20 00:00:00
 | 10017.56 |  |  | 2019-08-14 00:00:00
 | 12514.5 |  |  | 2019-09-13 00:00:00
 | 16125.19 |  |  | 2019-10-18 00:00:00
 | 12128.63 |  |  | 2019-11-15 00:00:00
 | 11580.19 |  |  | 2019-12-13 00:00:00
 | 15710.72 |  |  | 2020-01-20 00:00:00
 | 9687.69 |  |  | 2020-02-13 00:00:00
 | 13626.72 |  |  | 2020-03-17 00:00:00
 | 17517.93 |  |  | 2020-05-22 00:00:00
 | 12616.13 |  |  | 2020-07-11 00:00:00
 | 10595 |  |  | 2020-08-13 00:00:00
 | 12114.33 |  |  | 2020-09-19 00:00:00
 | 8298.93 |  |  | 2020-10-15 00:00:00
 | 100 |  |  | 2020-11-03 00:00:00
 | 150 |  |  | 2020-11-06 00:00:00
 | 200 |  |  | 2020-12-04 00:00:00
Extra Duty Collection Date From | 2019-04-01 00:00:00 | To | 2019-08-08 00:00:00
Duty Relief Date From | 2019-12-01 00:00:00 | To | 2020-10-01 00:00:00
Spreadsheet: 120148d1315011196-array-to-count-how-many-days-within-a-range-are-greater-than-5-hmm-test
Sheet: Sheet1

1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula in am2 refers to a1
results
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lalala | 2011-09-03 00:00:00 | 2011-09-04 00:00:00 | 2011-09-05 00:00:00 | 2011-09-06 00:00:00
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-01 00:00:00 | 2011-09-02 00:00:00 | 2011-09-03 00:00:00 | 2011-09-04 00:00:00
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-28 00:00:00 | 2011-08-29 00:00:00 |  | 2011-08-31 00:00:00 | 2011-09-01 00:00:00
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-29 00:00:00 | 2011-08-30 00:00:00 | 2011-08-31 00:00:00 | 2011-09-01 00:00:00 | 2011-09-02 00:00:00
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-30 00:00:00 | 2011-08-31 00:00:00 | 2011-09-01 00:00:00 | 2011-09-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | above is double space
Spreadsheet: chris_germany__2011__Lonestarnom0602
Sheet: June 5, 2002

[NAME]
[NAME]
Dallas, TX  75201-5696
Attention: | Wilma Easter - Scheduling Department |  |  |  | From: | Enron Capital & Trade
Fax: | 214/875-3810 |  |  |  |  | [NAME]
Phone: | 214/875-3296 |  |  |  |  | 713/853-7750 (Phone)
Backup:  [NAME] 214/875-2674 |  |  |  |  |  | 713/345-7374 (Fax)
Contract #LS-MC-1671 |  |  | Start Date: |  | 2002-06-05 00:00:00 |  | End Date: | 2002-06-30 00:00:00
RECEIPT POINT INFORMATION:
 | STATION # | [NAME] | UPSTREAM K# | Previous Day Nom | NOM QUANTITY | FUEL % | NET QUANTITY | Changes
Cinergy | 17-1201-11 | [NAME] | 01T957 | 0 | 0 | 0.01 |  | **
Cinergy | 17-1954-50 | Conoco Sterling | Conoco | 7100 | 7100 | 0.01
Cinergy | 17-8060-00 | [NAME] | A10118 | 0 | 12900 | 0.01
Cinergy | 17-1240-50 | NNG Sprayberry | 107903 | 0 | 0 | 0.01
Cinergy |  |  |  | 0 | 0
 | 17-1240-50 | NNG Sprayberry | 108301 | 0 | 0 | 0.01
[NAME] | 17-2270-00 | HPL Interconnect | 9606506 | 0 | 5000 | 0.01
[NAME] | 17-1925-00 | Duke/Carthage Hub | 481 | 0 | 10000 | 0.01
[NAME] | 17-3000-00 | [NAME] | 2880600203 | 5000 | 5000 | 0.01
[NAME] | 17-1201-11 | [NAME] | REM | 0 | 0 | 0.01
[NAME] | 18-0006-00 | TW Pecos | 24198 | 5000 | 5000 | 0.01
DELIVERY POINT INFORMATION:
STATION # | [NAME] | UPSTREAM K# |  | Previous Day Nom | NOM QUANTITY | FUEL % | NET QUANTITY
25-0002-00 | Kleburne Plant | 1671 |  | 17100
FYI:  Buy/Sell Information
Cinergy | 17-1201-11 | [NAME] | #01T957 | 0 | 0 | 0 |  | sold to TXU K501 | K2704
Cinergy | 17-1201-11 | [NAME] | #01T957 | 0 | 0 | 0 |  | ** sold to TXU K1901
 |  |  |  |  |  | total sold TXU
Cuts:
Spreadsheet: 139413d1328226467-30-days-perfect-attendance-sample
Sheet: Sheet2

Total
Points
Date |  | Occurrence | Points | Rolloff | Lenient | Perfect Attendance | Rolling Total
2011-04-08 00:00:00 |  | late | 0.5 |  |  |  | 0
2011-06-10 00:00:00 |  | sent early | 0.5 |  |  |  | 0
2011-06-24 00:00:00 |  | late | 0.5 |  |  |  | 0
2011-06-26 00:00:00 |  | sent early | 0.25 |  |  |  | 0
2011-07-02 00:00:00 |  | late | 1 |  |  |  | 0
2011-07-03 00:00:00 |  | sent early | 0.5 |  |  |  | 0
2011-08-20 00:00:00 |  | late | 1 |  |  |  | 2
2011-09-24 00:00:00 |  | absent | 1 |  |  |  | 2
2011-10-30 00:00:00 |  | sent early | 1 |  |  |  | 0
2011-11-09 00:00:00 |  | absent | 1
2011-11-13 00:00:00 |  | absent | 1 |  |  |  | 0
2011-11-19 00:00:00 |  | sent early | 1 |  |  |  | 2
Spreadsheet: 672757d1586987227-payroll-project-for-ytd-payrolefinal
Sheet: Employee Information

ID | Employee Name | Date Started | Department | Address | City | Phone # | Dept Ext | Wage
1 | [NAME] | 2001-11-07 00:00:00 | Data Entry | 18794 [NAME] | Northville | [PHONE] | 245 | 10.5
2 | Mallory Hallas | 2015-12-15 00:00:00 | Engineer | 12345 Main Street | Plymouth | [PHONE] | 246 | 15
3 | [NAME] | 2010-10-19 00:00:00 | Sales | 1245 Main Street | Novi | [PHONE] | 247 | 20
4 | [NAME] | 1997-05-05 00:00:00 | Customer Service | 789 Main Street | West Bloomfield | [PHONE] | 248 | 15
5 | [NAME] Tally
6 | [NAME]
7 | [NAME]
8 | [NAME]
9 | Tanisha Witzel