tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 870c96aa-704c-46a9-9a51-3be7b74db9a9
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
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Housing Units Completed: United States
 |  | Seasonally Adjusted Single-family Units [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: December 21, 2014 (4:48 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008
2009
2010
2011
2012
Spreadsheet: b3ef69e7-c3d9-485c-87ad-4e95b26eac59
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
7542 | 29863 | Romana | [NAME] | AUT | 57 | 00:23:47 | 00:00:44 | 00:39:23 | [NAME] | 00:32:31 | 1 | 01:37:22
7542 | 28253 | Margarita | Ovsyannikva | RUS | 56 | 00:25:25 | 00:00:36 | [NAME] | [NAME] | 00:35:58 | 2 | 01:40:47
7542 | 28247 | Tone | Dalen | NOR | 58 | 00:26:04 | 00:00:49 | 00:44:40 | 00:00:56 | 00:33:42 | 3 | 01:46:14
7542 | 56046 | Pauliina | Oksanen | FIN | 59 | 00:26:31 | 00:01:01 | 00:46:53 | 00:01:03 | [NAME] | 4 | 01:52:29
7542 | 46580 | [NAME] | Nevenchenko | RUS | 60 | 00:26:28 | [NAME] | 00:46:31 | 00:01:21 | 00:39:28 | 5 | 01:54:31
Spreadsheet: 837057d1689807732-starting-and-end-dates-from-a-calendar-start_end-dates
Sheet: 3. 2024 Calendar

 |  | Week number | Column3 | Column4 | Column5 | Column1 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Column2
 |  |  |  |  |  |  | 2024-01-01 00:00:00
 |  |  |  |  |  |  |  | Program001
 |  |  |  |  |  |  |  | Program001
 |  |  |  |  |  |  |  |  | Program001
 |  |  |  |  |  |  |  |  | Program001
 |  |  |  |  |  |  |  | Program001
 |  |  |  |  |  |  |  | Program001
 |  |  |  |  |  |  |  |  |  | Program001
 |  |  |  |  |  |  |  |  |  | Program001
 |  |  |  |  |  |  |  | Program001 |  | Program002
 |  |  |  |  |  |  |  | Program002 |  | Program002
 |  |  |  |  |  |  |  | Program002
 |  |  |  |  |  |  |  | Program002
 |  |  |  |  |  |  |  |  |  | Program002
 |  |  |  |  |  |  |  |  |  | Program003
 |  |  |  |  |  |  |  |  |  | Program003
 |  |  |  |  |  |  |  | Program003
 |  |  |  |  |  |  |  |  |  | Program003
 |  |  |  |  |  |  |  |  |  | Program003
 |  |  |  |  |  |  |  | Program003
 |  |  |  |  |  |  |  | Program004
 |  |  |  |  |  |  |  | Program004
 |  |  |  |  |  |  |  | Program004
 |  |  |  |  |  |  |  | Program004
 |  |  |  |  |  |  |  |  |  |  | Program004
 |  |  |  |  |  |  |  |  |  |  | Program004
 |  |  |  |  |  |  | Commencement of Term 4
 |  |  |  |  |  |  |  |  | Program005
 |  |  |  |  |  |  |  |  | Program005
 |  |  |  |  |  |  |  |  | Program005
 |  |  |  |  |  |  |  |  |  |  | Program005
 |  |  |  |  |  |  |  |  |  | Program005
 |  |  |  |  |  |  |  | Program005
 |  |  |  |  |  |  |  |  |  |  | Program005
 |  |  |  |  |  |  |  | Program005
Spreadsheet: 202370d1356532164-conditional-formatting-formula-ror-excel-forum
Sheet: Edited Data

Loan Number | [NAME] | Investor | [NAME] | Funded | Processor | Branch | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Date of Transaction |  |  | Date NRTC signed |  |  | Proper 3-day Rescission / Midnight Date |  |  |  | Actual Funding Date |  |  | Q7 | Q8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-11-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-11-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-12-25 00:00:00
Spreadsheet: 845067d1696610476-need-to-adapt-sum-product-to-measure-calendar-and-work-days-each-week-between-dates-sumproduct-gannts-by-week-number-and-months
Sheet: WEEK AND MONTH GANTTS

ACTIVITY | Category | Start date | End Date | Checksum
Activity 01 | Planned | 2023-01-03 00:00:00 | 2023-01-10 00:00:00
 | Actual | 2023-02-14 00:00:00 | 2023-06-28 00:00:00
Activity 02 | Planned | 2023-02-23 00:00:00 | 2023-07-06 00:00:00
 | Actual | 2023-03-19 00:00:00 | 2023-05-12 00:00:00
Activity 03 | Planned | 2023-03-11 00:00:00 | 2023-05-24 00:00:00
 | Actual | 2023-03-16 00:00:00 | 2023-06-25 00:00:00
Activity 04 | Planned | 2023-04-09 00:00:00 | 2023-09-23 00:00:00
 | Actual | 2023-05-11 00:00:00 | 2023-10-05 00:00:00
 |  |  | TOTAL:
(A) GANTT BY WEEK NUMBERS:
ACTIVITY | WEEK: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47
Activity 01 | Planned
 | Actual
Activity 02 | Planned
 | Actual
Activity 03 | Planned
 | Actual
Activity 04 | Planned
 | Actual
 | Worked
 | Cum
(B) GANTT BY MONTHS:
ACTIVITY | MONTH: |  |  |  |  |  |  |  |  |  |  |  |  | Checksum
Activity 01 | Planned
 | Actual
Activity 02 | Planned
 | Actual
Activity 03 | Planned
 | Actual
Activity 04 | Planned
 | Actual
 | Worked
 | Cum
Spreadsheet: 767351d1644422015-extract-some-characters-in-a-mixed-string-c_udma
Sheet: Sheet1

FI | PR1971.0140/1 |  | Sylla, [NAME] omi: First visit of Bishop Légal and Father ? |  | 1907 | Open |  | Box 1
FI | PR1971.0140/2 |  | Sylla, [NAME] omi: [NAME] and Lukasz Kapica of Calgary with the Polish Father…in England. |  | 1914 | Open |  | Box 1
FI | PR1971.0140/3 |  | Sylla, [NAME] omi: [The group of Polish parishioners in Edmonton with Father [NAME]] |  | [19--?] | Open |  | Box 1
FI | PR1971.0140/4 |  | Sylla, [NAME] omi: Polish delegation to Legislature |  | 1919 | Open |  | Box 1
FI | PR1971.0140/5 |  | Sylla, [NAME] omi: [NAME] and [NAME] visiting Polish soldiers in Scotland |  | 1941 | Open |  | Box 1
FI | [NAME] |  | Sylla, [NAME] omi: Church of St. Cosimir in Krokow built built ca. 1906 by Father [NAME] of Pozuran |  | [19--?] | Open |  | Box 1
FI | PR1971.0140/7 |  | Sylla, [NAME] omi: The house in Wostok where Father [NAME] said mass for the Polish people in 1899 |  | [1900?] | Open |  | Box 1
FI | [NAME] |  | Sylla, [NAME] omi: Thankgiving at Tide Lake, Alberta |  | [19--?] | Open |  | Box 1
FI | PR1971.0140/9 |  | Sylla, [NAME] omi: Polish teachers and candidates for teaching profession in Winnipeg |  | [19--?] | Open |  | Box 1
Spreadsheet: eric_saibi__9865__Market briefs
Sheet: Sheet1

Market Briefs | Monday, October 15
Stocks | Close | Change | % Change
DJIA | 9347.62 | 3.460000000000946 | 0.0003702847553981253
DJ 15 Util. | 313.76 | -2.420000000000016 | -0.007653868049845075
NASDAQ | 1696.31 | -7.090000000000146 | -0.004162263707878446
S&P 500 | 1089.18 | -1.659999999999854 | -0.001521763044992716
Market Vols | Close | Change | % Change
AMEX (000) | 130611 | -61043 | -0.3185062665010905
NASDAQ (000) | 1583452 | -598572 | -0.2743196225156094
NYSE (000) | 1027400 | -310682 | -0.2321845746374288
Commodities | Close | Change | % Change
Crude Oil (Nov) | 22.32 | -0.18 | -0.007999999999999988
Heating Oil (Nov) | 0.6315 | -0.006900000000000017 | -0.01080827067669176
Nat. Gas (Henry) | 2.39 | -0.04 | -0.01646090534979425
Propane (Nov) | 40.5 | -0.25 | -0.006134969325153374
Palo Verde (Nov) | 34 | 0 | 0
COB (Nov) | 31.5 | 0 | 0
PJM (Nov) | 28.9 | 0 | 0
Dollar US $ | Close | Change | % Change
Australia $ | 1.94 | -0.04500000000000015 | -0.02267002518891695
Canada $ | 1.558 | -0.008999999999999897 | -0.005743458838544925
Germany Dmark | 2.154 | 0.004000000000000004 | 0.001860465116279071
Euro | 0.9082 | -0.002000000000000002 | -0.002197319270490004
Japan ¥en | 120.9 | -0.5 | -0.004118616144975288
Mexico NP | 9.27 | -0.04000000000000092 | -0.004296455424275072
[NAME] | 0.6905 | 0.001299999999999968 | 0.001886244921648241
Foreign Indices | Close | Change | % Change
Arg MerVal | 231.52 | -1.449999999999989 | -0.006223977336137651
[NAME]. | 3133.9 | -25.09999999999991 | -0.007945552389996806
[NAME] | 11329.32 | 544.6 | 0.05049737035361145
Can TSE 300 | 6955.6 | -75.39999999999964 | -0.01072393685108799
Germany DAX | 4505.13 | -120 | -0.02594521667499076
[NAME] | 10130.59 | -143.5399999999991 | -0.01397101263075307
Japan Nikkei 225 | 10452.54 | -179.8099999999995 | -0.01691159527291704
[NAME] | 5500.1 | -171 | -0.03015288039357444
UK FTSE 100 | 5067.3 | -78.19999999999982 | -0.015197745602954
Source:  Yahoo! & TradingDay.com
Spreadsheet: 235823d1368616655-baseball-team-standings-softball-league
Sheet: Scoreboard

 | # | Teams | P | W | L | % | F | A | T | 58 |  | Abu Dhabi Mudcrabs
 | 1 | [NAME] | 1 | 1 | 0 | 181.8181818181818 | 22 | 4 | 2 | 11 |  | [NAME]
 | 2 | Millennium Falcons | 1 | 1 | 0 | 177.7777777777778 | 9 | 2 | 2 | 12 |  | Ballbarians
 | 3 | Mother Falcons | 1 | 1 | 0 | 122.2222222222222 | 9 | 7 | 2 | 13 |  | Benchwarmers
 | 4 | Ballbarians | 1 | 1 | 0 | 107.1428571428571 | 14 | 13 | 2 | 14 |  | Blue Jays
 | 5 | Abu Dhabi Mudcrabs | 1 | 0 | 1 | 92.3076923076923 | 13 | 14 | 0 | 55 |  | [NAME]
 | 6 | Blue Jays | 1 | 0 | 1 | 71.42857142857143 | 7 | 9 | 0 | 56 |  | Millennium Falcons
 | 7 | [NAME] | 1 | 0 | 1 | -250 | 2 | 9 | 0 | 57 |  | Mother Falcons
 | 8 | Benchwarmers | 1 | 0 | 1 | -350 | 4 | 22 | 0 | 58
Spreadsheet: eric_saibi__9868__Market briefs
Sheet: Sheet1

Market Brief | Wednesday, October 17
Stocks | Close | Change | % Change
DJIA | 9232.97 | -151.26 | -0.01611853076917341
DJ 15 Util. | 314.97 | -3.559999999999945 | -0.01117634131792907
NASDAQ | 1646.34 | -75.73 | -0.04397614498829898
S&P 500 | 1076.28 | -21.26 | -0.01937059241576616
Market Vols | Close | Change | % Change
AMEX (000) | 219425 | 82234 | 0.5994124979043814
NASDAQ (000) | 2289678 | 444835 | 0.2411234993980517
NYSE (000) | 1443498 | 239133 | 0.1985552552589954
Commodities | Close | Change | % Change
Crude Oil (Nov) | 21.79 | -0.2100000000000009 | -0.009545454545454584
Heating Oil (Nov) | 0.621 | -0.005700000000000038 | -0.009095260890378232
Nat. Gas (Henry) | 2.44 | -0.1520000000000001 | -0.05864197530864203
Propane (Nov) | 40.4 | -0.1000000000000014 | -0.002469135802469171
Palo Verde (Nov) | 28 | 0.75 | 0.02752293577981652
COB (Nov) | 29 | 0 | 0
PJM (Nov) | 27.25 | 0.25 | 0.009259259259259259
Dollar US $ | Close | Change | % Change
Australia $ | 1.948 | -0.002000000000000002 | -0.001025641025641027
Canada $ | 1.568 | 0.004000000000000004 | 0.00255754475703325
Germany Dmark | 2.169 | 0.01800000000000024 | 0.008368200836820196
Euro | 0.9034 | -0.004400000000000071 | -0.004846882573254098
Japan ¥en | 121.3 | 0 | 0
Mexico NP | 9.24 | 0.04000000000000092 | 0.004347826086956622
[NAME] | 0.6917 | 0.00109999999999999 | 0.001592817839559789
Foreign Indices | Close | Change | % Change
Arg MerVal | 251.61 | 8.460000000000008 | 0.03479333744602101
[NAME]. | 3170 | 24.19999999999982 | 0.007692796744866112
[NAME] | 11271.49 | 13.63999999999942 | 0.001211599017574352
Can TSE 300 | 6956.8 | -70.09000000000015 | -0.009974540657388993
Germany DAX | 4706.07 | 79.59000000000015 | 0.01720314364268302
[NAME] | 10260.81 | 112.32 | 0.01106765637055362
Japan Nikkei 225 | 10755.45 | 117.630000000001 | 0.01105771671263483
[NAME] | 5541.88 | -0.7299999999995634 | -0.0001317069034262853
UK FTSE 100 | 5203.4 | 120.7999999999993 | 0.02376736316058696
Source:  Yahoo! & TradingDay.com
Spreadsheet: 53613d1253558500-excel-2007-pushing-certain-data-to-sheet2-from-sheet1-test2
Sheet: Sheet2

These are the 'A' enteries
a | 7 | to
a | 13 | without
a | 19 | the
These are the 'B' entries
b | 2 | of
b | 8 | pull
b | 14 | adding
b | 20 | cooresponding
These are the 'C' enteries
c | 3 | the
c | 9 | data
c | 15 | blank
c | 21 | spreadsheet
These are the 'D' enteries
d | 4 | ability
d | 10 | from
d | 16 | line
These are the 'E' Entries
e | 5 | of
e | 11 | a
e | 17 | entries
These are the 'F' entries
f | 6 | excel
f | 12 | spreadsheet
f | 18 | to
Spreadsheet: 22623d1211655607-create-custom-date-fill-for-a-calendar-planner
Sheet: Sheet1 (2)

2008-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2008-06-01 00:00:00
2008-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2008-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2008-06-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2008-06-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2008-06-03 00:00:00
2008-06-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2008-06-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2008-06-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2008-06-04 00:00:00
2008-06-02 00:00:00
2008-06-03 00:00:00
2008-06-03 00:00:00
2008-06-04 00:00:00
2008-06-04 00:00:00
2008-06-05 00:00:00
2008-06-05 00:00:00
2008-06-06 00:00:00
2008-06-06 00:00:00
2008-06-07 00:00:00
2008-06-07 00:00:00
2008-06-01 00:00:00
2008-06-01 00:00:00
2008-06-02 00:00:00
2008-06-02 00:00:00
2008-06-03 00:00:00
2008-06-03 00:00:00
2008-06-04 00:00:00
2008-06-04 00:00:00
2008-06-05 00:00:00
2008-06-05 00:00:00
2008-06-06 00:00:00
2008-06-06 00:00:00
2008-06-07 00:00:00
2008-06-07 00:00:00
2008-06-01 00:00:00
2008-06-01 00:00:00
2008-06-02 00:00:00
2008-06-02 00:00:00
2008-06-03 00:00:00
2008-06-03 00:00:00
2008-06-04 00:00:00
2008-06-04 00:00:00
2008-06-05 00:00:00
2008-06-05 00:00:00
2008-06-06 00:00:00
2008-06-06 00:00:00
2008-06-07 00:00:00
2008-06-07 00:00:00
2008-06-01 00:00:00
2008-06-01 00:00:00
2008-06-02 00:00:00
2008-06-02 00:00:00
2008-06-03 00:00:00
2008-06-03 00:00:00
2008-06-04 00:00:00
2008-06-04 00:00:00
2008-06-05 00:00:00
2008-06-05 00:00:00
2008-06-06 00:00:00
2008-06-06 00:00:00
2008-06-07 00:00:00
2008-06-07 00:00:00
Spreadsheet: 738254d1624933753-char-64-column-for-columns-past-z-plus-linking-that-to-another-formula-ians-testing-sheet
Sheet: master sheet

 |  |  | Heading 1 |  | Heading 2 |  |  |  |  |  |  |  |  | Heading 3 |  |  |  |  |  |  | Heading 4 |  |  | OVERALL |  | Test 1 | test 2
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
Spreadsheet: 840416d1692716054-available-recipes-from-ingredient-stock-list-recipe-stock-aligw
Sheet: Hoja1

RECETA | B_INGREDIENTE | CANTIDAD |  | E_INGREDIENTE | STOCK |  | H_RECETA | DISPONIBILIDAD
ALBONDIGAS | CARNE | 1 |  | CONEJO | 0 |  | ALBONDIGAS
ALBONDIGAS | TOMATE | 2 |  | TOMATE | 2 |  | POLLO FRITO | Si
POLLO FRITO | POLLO | 1 |  | POLLO | 2 |  | CONEJO AL AJILLO | No
POLLO FRITO | PATATAS | 3 |  | PATATAS | 4
CONEJO AL AJILLO | CONEJO | 1 |  | CARNE | 2
CONEJO AL AJILLO | AJO | 2 |  | AJO | 3
Hello Friends,  I need to solve this problem  I have 3 tables.  Table 1 : Recipe (A) , B_Ingredient (B) , Ammount (C). Table 2 : E_Ingredient (E), Stock (F). Table 3 : H_Recipe (H), Available (I).  I need a formula in Column I to show if i can make any recipe with the stock available in column F.  [ATTACH]840411[/ATTACH]  Thanks.
Spreadsheet: 830830d1685151487-need-formula-same-booking-with-multiple-payment-and-remittance-booking-details
Sheet: Sheet1

Booking ID | Remittance# | Amt |  | Result should be
2100 | 55 | 100 | Need formula | For Booking# 2100 paid $ 100 via remittance# 55, Paid $ 10 via remittnce# 56
1000 | 4 | 5 | Need formula | For Booking# 1000 paid $ 5 via remittance# 4
999 | 44 | 10
2100 | 56 | 10
Spreadsheet: 07e9cbb3-f092-409f-905b-5582c5a9739f
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
42351948 | 2014-07-18 16:32:15 | ALLIES | 1 | 7 | 2 | 828272 | hester24 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42352131 | 2014-07-18 16:52:43 | AXIS | 1 | 7 | 5 | 828272 | hester24 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42410638 | 2014-07-22 20:39:42 | ALLIES | 0 | 2 | 7 | 1450594 | Blondo | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42411020 | 2014-07-22 21:00:36 | AXIS | 0 | 6 | 7 | 1450594 | Blondo | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42452223 | 2014-07-25 22:29:50 | AXIS | 1 | 5 | 1 | 225841 | sacas | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42452489 | 2014-07-25 22:52:05 | ALLIES | 1 | 5 | 2 | 225841 | sacas | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
Spreadsheet: chris_germany__2311__NewPowerPPAS012001
Sheet: NewPowerPPAS012001

Billing_Period | Sitara # | Delivery_Start_Date | Delivery_End_Date | Pipeline_Id | Point_Name | Item_Description | Quantity | Quantity_Unit_Id | Unit_Price | Statement_Amount
May-00 | 249252 | 5/1/00 [NAME] | 5/31/00 [NAME] | MICH | MICH. CON. (WILLOW RUN) DEL | Cost of Gas | 59179 | MMBtu | 2.745 | 162446.36
Jun-00 | 249252 | 6/1/00 [NAME] | 6/30/00 [NAME] | MICH | MICH. CON. (WILLOW RUN) DEL | Cost of Gas | 55770 | MMBtu | 2.7525 | 153506.93
Jul-00 | 249252 | 7/1/00 00:00:00 | 7/31/00 [NAME] | MICH | BELLE RIVER MILLS | Cost of Gas | 46934 | MMBtu | 2.7725 | 130124.52
Jul-00 | 220818 | 7/1/00 00:00:00 | 7/31/00 [NAME] | MICH | BELLE RIVER MILLS | Cost of Gas | 930 | MMBtu | 4.4865 | 4172.45
Aug-00 | 249252 | [NAME] | 8/31/00 00:00:00 | MICH | BELLE RIVER MILLS | Cost of Gas | 32457 | MMBtu | 2.79 | 90555.03
Aug-00 | 220818 | [NAME] | 8/31/00 00:00:00 | MICH | BELLE RIVER MILLS | Cost of Gas | 775 | MMBtu | 3.9425 | 3055.44
Sep-00 | 380445 | 9/1/00 00:00:00 | 9/30/00 00:00:00 | SNAT | ENRON STORAGE | Reverse Item 268 of Stmt 16541 |  |  | 0.173 | -23321.27
Sep-00 | 380445 | 9/1/00 00:00:00 | 9/30/00 00:00:00 | SNAT | ENRON STORAGE | Transportation Adjustment |  |  | 0.173 | 24040.95
Sep-00 | 380445 | 9/1/00 00:00:00 | 9/30/00 00:00:00 | SNAT | ENRON STORAGE | Cost of Gas | 138965 | MMBtu | 4.633 | 643824.85
Sep-00 | 380445 | 9/1/00 00:00:00 | 9/30/00 00:00:00 | SNAT | ENRON STORAGE | [NAME] 53 of Stmt 16541 | -134805 | MMBtu | 4.633 | -624551.56
Spreadsheet: darrell_schoolcraft__7818__imbalsumm0109
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -20562 | -12552
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -1381896 | -1322019
58710 | -2 | -506
60921 | 725660 | 598111
78026 |  | 39947
500084 | -5999 | -11000
500085
500097 | -3741
INDEX
2001-08-31 00:00:00 |  |  | 129217.63
2001-09-11 00:00:00
CBS Volume
 |  |  | 7128
Spreadsheet: geir_solberg__11285__12-26act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 108333d1305366629-index-and-match-formula-question
Sheet: Person A

 | % needed | 1 | 814.4473133887211 | 887.7475715937061 | 967.6448530371397 | 1054.732889810482
 |  | 0.99 | 775.6641079892581 | 845.4738777082914 | 921.5665267020377 | 1004.507514105221
 |  | 0.98 | 738.7277218945316 | 805.2132168650395 | 877.6824063828931 | 956.6738229573535
 |  | 0.97 | 703.5502113281252 | 766.8697303476565 | 835.8880060789456 | 911.1179266260508
 |  | 0.96 | 670.0478203125002 | 730.3521241406253 | 796.0838153132817 | 867.7313586914771
 |  | 0.95 | 638.1407812500001 | 695.5734515625002 | 758.1750622031252 | 826.4108178014066
 |  | 0.94 | 607.7531250000001 | 662.4509062500001 | 722.0714878125002 | 787.0579217156253
 |  | 0.93 | 578.8125 | 630.9056250000001 | 687.6871312500001 | 749.5789730625002
 |  | 0.92 | 551.25 | 600.8625000000001 | 654.9401250000001 | 713.8847362500002
 |  | 0.91 | 525 | 572.25 | 623.7525 | 679.8902250000001
 |  | 0.9 | 500 | 545 | 594.0500000000001 | 647.5145000000001
 |  |  | 2 | 3 | 4 | 5
 |  |  | Height
 | Input data |  | % needed | Height
 |  | Person A | 1 | 2 | 814.4473133887211
 |  | Person B | 0.993 | 3 | #N/A
 |  | Person C | 0.92 | 3 | 600.8625000000001
Spreadsheet: 786066d1656958954-large-numbers-of-criteria-and-relevant-formula-test-file-1-bsb-
Sheet: Sheet1

Inspector [NAME] | AOM |  |  | Inspector Name | AOM
JOHN MISKIEWICZ | [NAME] |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  | [NAME] | [NAME]
RAYMOND HARRISON | [NAME] |  |  | [NAME] | [NAME]
RAYMOND HARRISON | [NAME] |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  | [NAME] | [NAME]
[NAME] |  |  |  | [NAME]
MATTHEW HAYNES |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
MARC BULLETT |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
ALEX NEVES |  |  |  | [NAME]
[NAME] TOBIN |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
PAUL MCQUEEN |  |  |  | Trevor Barker
MATTHEW HAYNES |  |  |  | [NAME]
ALEX NEVES
Spreadsheet: 467185d1466609201-data-capture-from-a-production-line-eol-data-capture-21-6-16
Sheet: Total Faults

Date | Total Faults | Faults going to VIP | vans in VIP
2016-06-06 00:00:00 | 518 | 87 | 85
2016-06-07 00:00:00 | 479 | 62 | 89
2016-06-08 00:00:00 | 430 | 86 | 91
2016-06-09 00:00:00 | 690 | 79 | 99
2016-06-10 00:00:00 | 690 | 79 | 58
2016-06-13 00:00:00 | 631 | 223 | 57
2016-06-14 00:00:00 | 580 | 121 | 65
2016-06-15 00:00:00 | 736 | 346 | 78
2016-06-16 00:00:00 | 338 | 29 | 91
2016-06-17 00:00:00 | 332 | 27 | 85
2016-06-20 00:00:00 |  | 111
2016-06-21 00:00:00
2016-06-22 00:00:00
2016-06-23 00:00:00
2016-06-24 00:00:00
Spreadsheet: d09f4af6-c944-429f-9638-bf7edaea7c42
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
42398558 | 2014-07-21 20:51:49 | ALLIES | 1 | 4 | 1 | 1608594 | player1608594 | 6151 | western | 1944-07-21 | 1944-07-21 | [NAME] | [NAME]
42399001 | 2014-07-21 21:17:00 | AXIS | 1 | 4 | 1 | 1600928 | davidahlbinprof1 | 6151 | western | 1944-07-21 | 1944-07-21 | [NAME] | [NAME]
Spreadsheet: 875145d1721724383-covert-column-days-into-rows-to-map-a-call-schedule-in-the-format-we-require-call-schedule-challenge
Sheet: CURRENT

BDR | AccountId | Name | Outlet Status | Monday1 | Tuesday1 | Wednesday1 | Thursday1 | Friday1 | Saturday1 | Monday2 | Tuesday2 | Wednesday2 | Thursday2 | Friday2 | Saturday2 | Monday3 | Tuesday3 | Wednesday3 | Thursday3 | Friday3 | Saturday3 | Monday4 | Tuesday4 | Wednesday4 | Thursday4 | Friday4 | Saturday4
Rodger Federer | 1231 | ABC Outlet | OPEN |  |  | 1 |  | 1 |  |  | 1 |  |  |  | 1 | 1 |  | 1 | 1 |  |  | 1 |  |  |  | 1
Rodger Federer | 1232 | BDE Outlet | OPEN | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  | 1
Rodger Federer | 1233 | AMD Outlet | OPEN |  | 1 |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  | 1
Rodger Federer | 1234 | GCD Outlet | OPEN |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
Rodger Federer | 1235 | APE Outlet | OPEN |  |  |  | 1 |  | 1 |  |  |  | 1 | 1 |  |  |  | 1 | 1 |  | 1 |  | 1 |  | 1 |  | 1