tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 94018d1293793240-copying-data-from-a-table-to-another-one-example-fix-v2
Sheet: DEC.

P2
JANUARY | 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
 | W | W | WP | P | V | V | V | V | V | V | V | P | P | P | P | W | W | P | P | P | P | P | W | P | P | P | P | P | P | W | P
FEBRUARY | 2010-02-01 00:00:00 | 2010-02-02 00:00:00 | 2010-02-03 00:00:00 | 2010-02-04 00:00:00 | 2010-02-05 00:00:00 | 2010-02-06 00:00:00 | 2010-02-07 00:00:00 | 2010-02-08 00:00:00 | 2010-02-09 00:00:00 | 2010-02-10 00:00:00 | 2010-02-11 00:00:00 | 2010-02-12 00:00:00 | 2010-02-13 00:00:00 | 2010-02-14 00:00:00 | 2010-02-15 00:00:00 | 2010-02-16 00:00:00 | 2010-02-17 00:00:00 | 2010-02-18 00:00:00 | 2010-02-19 00:00:00 | 2010-02-20 00:00:00 | 2010-02-21 00:00:00 | 2010-02-22 00:00:00 | 2010-02-23 00:00:00 | 2010-02-24 00:00:00 | 2010-02-25 00:00:00 | 2010-02-26 00:00:00 | 2010-02-27 00:00:00 | 2010-02-28 00:00:00
[NAME] | 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
APRIL | 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
MAY | 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
[NAME] | 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
JULY | 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
AUGUST | 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
SEPTEMBER | 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
OCTOBER | 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
NOVEMBER | 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
DECEMBER | 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
Spreadsheet: 772362d1647243773-counting-days-sample
Sheet: Sheet1

No of Sheets | No of Persons | Days | Logic
120 | 2 |  | (30*2)+(60*2)
250 | 2
445 | 5
55 | 1
25 | 1
785 | 4
1002 | 6
4567 | 8
112 | 2
555 | 5
Spreadsheet: 882022d1730286513-conditional-format-of-zero-numbers-jk-1-
Sheet: Sheet1

NAME | HELP ROW | January | February | March | April | May | June | July | August | September | October | November | December
BENZ | A1 | 171.304347826087 | 34.60869565217391 | 29.47826086956522 | 49.1304347826087 | 19.65217391304348 | 0 | 0 | 0.8695652173913043 | 17.82608695652174 | 0 | 0 | 0
 | A2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A3 | 179 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BMW | B1 | 2210.173913043478 | 2657.913043478261 | 387.3043478260869 | 687.8260869565217 | 751.2173913043479 | 540.5217391304348 | 0 | 85.1304347826087 | 217.3913043478261 | 48.8695652173913 | 0 | 605.8260869565217
 | B2 | 2 | 15 | 0 | 0 | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 | B3 | 2273 | 858 | 256 | 1187 | 1316 | 125 | 0 | 85 | 107 | 84 | 0 | 608
FORD | C1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.043478260869565 | 0 | 0 | 0
 | C2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 1025f918-2487-420b-8dd1-e452d17e40e5
Sheet: 2. Analyze

 | Analyze data with Quick Analysis |  |  |  |  |  |  |  |  | Learn More
 | Select and play with your data using live previews
 | Company | Industry | Q1 Sales | Q2 Sales
 | A. Datum Corporation | Tech | 195449 | 746907
 | Adventure Works | Travel | 123721 | 733396
 | Blue Yonder Airlines | Travel | 934763 | 246554
 | City Power & Light | Utilities | 299293 | 674295
 | Coho Vineyard | Beverage | 228783 | 659385
 | Contoso, Ltd | Misc | 239219 | 287989
 | Contoso Pharmaceuticals | Medical | 371570 | 644368
 | [NAME] | Tech | 579825 | 448399
 | Fabrikam, Inc. | Utilities | 639630 | 635474
 | Fourth Coffee | Beverage | 876740 | 567216
 | Graphic Design Institute | Education | 788390 | 540282
 | Humongous Insurance | Financial | 682545 | 577599
 | Litware, Inc. | Tech | 902264 | 206331
 | Lucerne Publishing | Misc | 905906 | 443552
 | Margie's Travel | Travel | 289570 | 843834
Spreadsheet: 457161d1461228601-how-to-add-up-certain-columns-sum-up-1-
Sheet: Sheet2

 | 1st week |  |  |  |  |  |  |  | 2nd week |  |  |  |  |  |  |  | 3rd week |  |  |  |  |  |  |  | 4th week |  |  |  |  |  |  |  | 5th week
 | Plan | Actual | farmer visits | FM | MFM | [NAME] | Workshop | Field Day | DV Plan | DV Actual | farmer visits | FM | MFM | [NAME] | Workshop | Field Day | DV Plan | DV Actual | farmer visits | FM | MFM | [NAME] | Workshop | Field Day | DV Plan | DV Actual | farmer visits | FM | MFM | [NAME] | Workshop | Field Day | DV Plan | DV Actual | farmer visits | FM | MFM | [NAME] | Workshop | Field Day
Total
Spreadsheet: 865458d1712549380-pivot-columns-and-extract-without-powerquery-book1
Sheet: Sheet1

Name | Hours | Comment | Dept1ALevel1 | Hour - Dept1ALevel1 | Comment - Dept1ALevel1 | Dept2ALevel2 | Hour - Dept2ALevel2 | Comment - Dept1ALevel2
A | 1 | Ignore | Dept1A A | 1 | Ignore | Dept2A A | 0 | Ignore
B | 2 | Ignore | Dept1A B | 1 | Ignore | Dept2A B | 1 | Ignore
C | 3 | Ignore | Dept1A C | 1 | Ignore | Dept2A C | 2 | Ignore
D | 4 | Ignore | Dept1A D | 2 | Ignore | Dept2A D | 2 | Ignore
E | 5 | Ignore | Dept1A E | 3 | Ignore | Dept2A E | 2 | Ignore
RAW DATA
Name | Hours | Dept | Level | Hour
A | 1 | Dept1A | Level1 | 1
A | 1 | Dept2A | Level2 | 0
B | 2 | Dept1A | Level1 | 1
B | 2 | Dept2A | Level2 | 1
C | 3 | Dept1A | Level1 | 1
C | 3 | Dept2A | Level2 | 2
D | 4 | Dept1A | Level1 | 2
D | 4 | Dept2A | Level2 | 2
E | 5 | Dept1A | Level1 | 3
E | 5 | Dept2A | Level2 | 2
Spreadsheet: 31662d1227606325-listbox-problem-listbox
Sheet: Sheet2

Product Name | Product Code | Part Number |  | Product Name | Product Code | Part Number
Tiger | TG1 | 11 |  | Tiger | TG1 | 11
Tiger | TG2 | 12 |  | Tiger | TG2 | 12
Lion | LN1 | 13 |  | Lion | LN1 | 13
Rhino | RH1 | 14 |  | Rhino | RH1 | 14
Zebra | ZB1 | 15 |  | Zebra | ZB1 | 15
Zebra | ZB2 | 16 |  | Zebra | ZB2 | 16
Zebra | ZB3 | 17 |  | Zebra | ZB3 | 17
Hawk | HK1 | 21 |  | Hawk | HK1 | 21
Hawk | HK2 | 22 |  | Hawk | HK2 | 22
Hawk | HK3 | 23 |  | Hawk | HK3 | 23
Hawk | HK4 | 24 |  | Hawk | HK4 | 24
Other | N/A | N/A |  | Other | N/A | N/A
Spreadsheet: 773342d1647800890-pull-entire-line-by-id-example-v2
Sheet: Total Hours

 |  |  | 2021-12-15 00:00:00 | 2021-12-31 00:00:00 | 2022-01-15 00:00:00 | 2022-01-31 00:00:00 | 2022-02-14 00:00:00 | 2022-02-28 00:00:00 | 2022-03-15 00:00:00 | 2022-03-31 00:00:00 | 2022-04-15 00:00:00
1001 | [NAME], [NAME] | Total Hours:
2403 | Doe, [NAME] | Total Hours:
2050 | Fisher, Mary | Total Hours:
1920 | [NAME], [NAME] | Total Hours:
 | *[NAME] should pull Row15 from the "By [NAME]"
 | *Doe should be Row30 from the "By Employee" tab
Spreadsheet: 548080d1510859601-make-a-list-excluding-blank-cells-solved-sample
Sheet: Sheet1

Item | Quantity | Price
Item a | 3 | 12
Item b |  | 15
Item c | 2 | 10
Item d | 1 | 5
Idem e |  | 18
Item f |  | 12
Item g | 6 | 10
Item a | 3 | Total | 121
Item c | 2
Item d | 1
Item g | 6
Spreadsheet: 821051d1678419040-percentage-of-lumpsum-shipment-cost-per-item-based-on-shipment-percentage-of-shipping-version-2
Sheet: Sheet1 (Manual Values)

Item # | Item Description | Shipment # | Order Fee | Payment Fee | Handling Fee | Tax Fee | Total Fees | Item Cost | Total Cost of Item (incl fees) | Percentage of Lumpsum Shipment Cost (Col O) per Shipment # (Col N) | Lumpsum Shipment Cost per item (Col K x Col O) |  | Shipment # | Total Lumpsum Shipment Cost
1 | GS Ballpoint Pen | 12832613 | 370 | 200 | 300 | 0 |  | 3299 |  |  |  |  | 12832613 | 16800
2 | Seiko yacht timer 6M37-6000 | 12832613 | 900 | 200 | 300 | 3163 |  | 31637 |  |  |  |  | 12855295 | 17500
3 | 1995 No.1&2 Seiko Watch Catalog | 12832613 | 200 | 0 | 300 | 150 |  | 1500 |  |  |  |  | 12855296 | 20600
4 | 1996 No.1, 1997 No.1&2, 1998 No.1&2 Seiko Watch Catalog | 12855295 | 0 | 0 | 300 | 0 |  | 3500 |  |  |  |  | 13001545 | 11000
5 | 1993 No.1&2, 1994 No.1 Seiko Watch Catalog | 12855295 | 0 | 0 | 300 | 0 |  | 2600 |  |  |  |  | 13079770 | 35000
6 | 2003 No.1, 2011, 2019 No.2, 2021 [NAME], 2021 Alba Watch Catalog | 12832613 | 0 | 0 | 300 | 0 |  | 1200
7 | Seiko 1960s-70s Mechanical watch parts catalog | 12855295 | 1600 | 200 | 300 | 0 |  | 10000
8 | 2014 No.1&2 Seiko Watch Catalog | 12855296 | 1000 | 200 | 300 | 0 |  | 3108
9 | 2004 No.2 Seiko Watch Catalog | 12832613 | 0 | 0 | 300 | 0 |  | 3800
10 | Seiko WATCH NEWS watch news 1997 year 5,6 | 12855295 | 210 | 200 | 300 | 0 |  | 1200
11 | 2003 No.1 Seiko Watch Catalog | 12855295 | 210 | 200 | 300 | 0 |  | 3400
12 | 2021 Credor Watch Catalog | 12855296 | 0 | 0 | 300 | 0 |  | 301
13 | 1990 Summer and Autumn Seiko Watch Catalog | 12855296 | 810 | 200 | 300 | 0 |  | 5000
14 | 1970 Seiko Lordmatic Brochure | 13001545 | 210 | 0 | 300 | 0 |  | 2400
15 | 1989 No.1 Seiko Watch Catalog | 12855296 | 0 | 0 | 300 | 0 |  | 3000
16 | 1988 No.1 Seiko Watch Catalog | 12855296 | 0 | 0 | 300 | 0 |  | 3000
17 | 1973 Seiko Watch Catalog | 13001545 | 873 | 0 | 300 | 0 |  | 13500
18 | 2019 No.1 Seiko Catalog | 13001545 | 185 | 0 | 300 | 0 |  | 250
19 | 1994 No.3 Seiko Watch News | 13079770 | 0 | 0 | 300 | 0 |  | 1288
20 | 1979 No.2 Seiko Watch Catalog | 13001545 | 370 | 0 | 300 | 0 |  | 13000
21 | 1970 Seiko Expo 70 Brochure | 13079770 | 84 | 0 | 300 | 0 |  | 1800
22 | 1996 No.7 Seiko News | 13079770 | 0 | 0 | 300 | 0 |  | 1288
23 | Seiko Bellmatic Brochure | 13001545 | 0 | 0 | 300 | 0 |  | 1680
24 | 2014 Vol.2, 2015 Vol.1 Seiko Watch Catalog | 13079770 | 0 | 0 | 300 | 0 |  | 2000
25 | 2013 Vol.1 Seiko Watch Catalog | 13079770 | 370 | 0 | 300 | 0 |  | 5800
Spreadsheet: phillip_m_love__30152__9905_OA
Sheet: TX-CON-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM) / HPL
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 51725492 | 120477378
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 71127 | 159944
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 51796619 | 120637322
 | Purchases:
6 |  | 3rd Party / Inter Enron | -57689353 | -132145289
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -2052275 | -4472679
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -59741628 | -136617968
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 32997274 | 74244674.74
12 |  | Purchases | -33022074 | -74302953
 | Total Intra CTS Sales / Purchases |  | -24800 | -58278.26000000536
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 1209207 | 2766943.12644562
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 1209207 | 2766943.12644562
 | Storage:
17 |  | Injection (Sales to Stg) | 7337145 | 16945465
18 |  | W/D (Purchase from Stg) | -576543 | -1293657
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -576543 | -1293657
 | Total Storage: |  | 6760602 | 15651808
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 0 | 0
23 | Fuel: |  | 0 | 0
 | Transport Expense:
24 |  | Commodity | 0 | -992568.27
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -992568.27
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 250999.06
31 |  | Prior Month Book Balance | 0 | -1054678
 |  | Total MTM Income | 0 | -803678.94
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 1019748.41
34 |  | Originations | 0 | 81200
35 |  | Broker Fees | 0 | -4060
36 |  | Asset Group Demand Charges | 0 | -108300
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
FT-Texas
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 29981fc1-eafa-4d77-93f1-b0f05ebbcb61
Sheet: Sheet1

Unnamed: 0 | 類 | 書名 | 著者名 | 出版社 | 出版年
 | E え | 江戸に水がやってきた～玉川兄弟ものがたり | 小沢　長治・さく　田中　良・え | 岩崎書店 | 1983
◎ | ゼロ90 | 玉川上水-その歴史と役割-　第三版 | 羽村市郷土博物館編 | 羽村市教育委員会 | 2004
 | 281 | きょう土につくした人びと　ふるさと歴史新聞3　川とたたかう |  | [NAME] | 1996
 | 210 | 「物づくり」に見る日本人の歴史４．日本人はどのように水を利用してきたか |  | あすなろ書房 | 2000
 |  | 『日本の伝説5　東京』 |  | [NAME]
◎ | 210 | 楽しく調べる東京の歴史 | 東京都小学校社会科研究会編 | [NAME] | 2007
 |  | 玉川上水と分水　新訂増補版 | 小坂克信 | [NAME] | 1995
 | 213 | おはなし東京の歴史 | 東京都小学校社会科研究会編 | [NAME] | 2008
 |  | 玉川上水散策絵地図　改訂 | 村松昭 | アトリエ77 | 2006
 |  | 東京を築いた人々（さ・え・ら伝記ライブラリー26） | 磯村英一 | さ・え・ら書房
 | ゼロ90 | 玉川上水―親と子の歴史散歩― | 肥留間博 | けやき出版 | 1991
 | 307 | 発展学習・自由研究アイディア101④社会〔社会のしくみとはたらき〕 |  | 学習研究社 | 2005
 | [NAME] | [NAME] | 羽村市郷土博物館 | 羽村市教育委員会 | 2003
 | [NAME] | [NAME] | 江戸東京たてもの園 | 江戸東京たてもの園 | 2007
 | 参考図書 | 教科書に出る人物学習事典 |  | 学習研究社
 | 参考図書 | 総合百科事典ポプラディア |  | [NAME] | 2002
 | 参考図書 | [NAME]　関東地方 |  | 旺文社
◎ | 210.5 | [NAME]聞き書きによる知恵シリーズ１３・４８ |  | 農文協 | 1991
 | 517 | 図解　武蔵野の水路　玉川上水とその分水路の造形を明かす | 渡部一二著 | 東海大学出版 | 2004
 | web | 郷土学習資料　玉川上水 | http://www.education.ne.jp/kyoiku-center-mi/tamagawa/index.htm | 三鷹市教育センター
 | web | クローズアップ都市・東京情報「玉川上水」の巻 | http://www.library.metro.tokyo.jp/16/16t60.html | 東京都立図書館
 | web | 新宿区広報ビデオ　no.68 | http://www.city.shinjuku.tokyo.jp/koho/video/No68/68_Bband_wmv.html#top | 新宿区
 | web | 江戸東京博物館＞トップ > 江戸博の紹介 > 図書室> 小中学生のページ＞Ｑ５　江戸東京の水道について調べたい | http://www.edo-tokyo-museum.or.jp/about/shisetsu/library/school_student.html#q5 | 江戸東京博物館
 | web | 多摩川地域学習プログラム・羽村取水堰　玉川上水の歴史と羽村取水堰見学 | http://www.tamariver.net/04siraberu/kanri/04siryou/program/4_4/75.pdf | 国土交通省京浜河川事務所　河川環境課
Spreadsheet: 122429d1316793781-nested-if-statements-or-something-different-minor-surgery-calcs
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Monthly total | Actual activity | [NAME] |  | Calculation |  | Desired figure
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 5 | 10 | 15 |  | O-N |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 2 | 5 | 15 | 10 |  | P-N |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 3 | 10 | 5 | 15 |  | O-N |  | -5
 |  |  |  |  |  |  |  |  |  |  |  | 4 | 10 | 15 | 5 |  | P-N |  | -5
 |  |  |  |  |  |  |  |  |  |  |  | 5 | 15 | 5 | 10 |  | O-N |  | -10
 |  |  |  |  |  |  |  |  |  |  |  | 6 | 15 | 10 | 5 |  | P-N |  | -10
Spreadsheet: 810369d1671720108-sum-constant-52-previous-cells-in-one-column-ignoring-clear-cells-book1-28-ans
Sheet: (4)

ssp | (Sick)
B | (Basic)
t
9.2 | Rate
 |  |  |  |  | (1) | (2) | (3) | (4)
Week No | Basic Hr | W/E Hr | Total Hours inc Hol Hrs | Days worked W & W/E | Code | Total Money  [NAME] | Other Paymts | [NAME] | SSP | Total Money | Total Pay 52 W | Total Hours 52w | Rate for Holiday Pay
1  2021 | 20 |  |  | 6 | b |  |  | 9.2 |  |  |  |  |  | FORMULA
1  20_21 | 39 | 48 |  |  | b | 1046.1
2 | 39 | 18 |  |  | b | 621.9
3 | 39 | 26.5 |  |  | b | 742.09
4 | 39 | 37 |  |  | b | 890.56
5 | 39 | 56 |  |  | b | 1159.22
6 | 39 | 18.5 |  |  | b | 628.97
7 | 39 | 11.25 |  |  | b | 526.46
8 | 39 | 3.5 |  |  | b | 416.87
9 | 39 | 6.5 |  |  | b | 459.29
10 | 39 | 0 |  |  | b | 367.38
11 | 39 | 4 |  |  | b | 423.94
12 | 39 | 0 |  |  | b | 367.38
13 | 39 | 8.5 |  |  | b | 487.57
14 | 39 | 2.75 |  |  | b | 406.27
15 | 39 | 5.5 |  |  | b | 445.15
16 | 39 | 3 |  |  | b | 409.8
17 | 39 | 15.5 |  |  | b | 586.55
18 | 39 | 19 |  |  | b | 636.04
19 | 39 | 45.5 |  |  | b | 1010.75
20 | 39 | 49 |  |  | b | 1060.24
21 | 39 | 0 |  |  | b | 367.38
22 | 39 | 50 |  |  | b | 1074.38
23 | 39 | 13.5 |  |  | b | 558.27
24 | 39 | 49.25 |  |  | b | 1063.78
25 | 39 | 56.5 |  |  | b | 1166.29
26 | 39 | 39.5 |  |  | b | 925.91
27 | 39 | 47 |  |  | b | 1042.81
28 | 39 | 19.5 |  |  | b | 643.11
29 | 39 | 56.5 |  |  | b | 1166.29
30 | 39 | 23 |  |  | b | 705.4
31 | 39 | 2 |  |  | b | 329.72
32 | 39 | 2 |  |  | b | 406.44
33 | 39 | 10 |  |  | b | 519.63
34 | 39 | 8 |  |  | b | 491.42
35 | 39 | 5.75 |  |  | b | 525.62
36 | 39 | 0 |  |  | b | 380.18
37 | 39 | 1.5 |  |  | b | 401.39
38 | 39 | 0 |  |  | b | 392.98
39 | 39 | 1.5 |  |  | b | 414.35
40 | 39 | 0 |  |  | b | 406.02
41 | 39 | 0 |  |  | b | 378.72
42 | 39 | 0 |  |  | b | 378.79
43 | 39 | 0.5 |  |  | b | 385.65
44 | 39 | 1.5 |  |  | b | 398.74
45 | 39 | 1.5 |  |  | b | 399.65
46 | 39 | 4 |  |  | b | 435
47 | 39 | 2 |  |  | b | 397.23
48 | 39 | 3 |  |  | b | 420.79
49 | 39 | 4 |  |  | b | 423.94
50 | 39 | 7 |  |  | ssp | 466.36
51 | 29.5 | 0 |  |  | ssp | 297.06
52 | 39 | 34 |  |  | b | 848.14
1 21_22 | 39 | 19 |  |  | b | 636.04 |  |  |  |  |  |  |  |  |  | Why  [NAME] not added to sum in L62
2 | 39 | 14.5 |  |  | b | 572.41
3 | 39 | 17.25 |  |  | b | 668.81
4 | 39 | 20.5 |  |  | b | 657.25
5 | 39 | 28 |  |  | b | 763.3
6 | 39 | 55 |  |  | b | 1145.08
7 | 39 | 10.25 |  |  | b | 512.32
8 | 39 | 20.5 |  |  | b | 798.65
9 | 39 | 35.25 |  |  | b | 865.82
10 | 39 | 34.5 |  |  | b | 965.18 |  |  |  |  |  |  |  |  |  |  | needs add 2 weeks adding
11 | 39 | 3 |  |  | b | 409.8 |  |  |  |  |  |  |  |  |  |  | so there are 52 weeks of figures | 416.87
12 | 39 | 11.5 |  |  | b | 529.99 |  |  |  |  |  |  |  |  |  |  |  | 459.29
13 | 39 | 15.5 |  |  | b | 586.55
Spreadsheet: sara_shackleton__36837__Merrill copy
Sheet: Power Swap Final

Transact | Counterparty | TradeDate | B/S | Beg Time | End Time | Volume Rate | Block | Location | Price
113089 | ENRO | Dec  4 2000 12:00AM | SELL | 2001-07-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE A | 81
116429 | ENRO | Feb  8 2001  5:11PM | BUY | 2001-07-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE A | 80
117292 | ENRO | Feb 26 2001  6:10PM | BUY | 2001-07-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE A | 73
117293 | ENRO | Feb 26 2001 12:00AM | BUY | 2001-07-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE A | 73
107394 | ENRO | Aug 28 2000 12:00AM | BUY | 2003-01-01 00:00:00 | 2004-01-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 43.31401
116032 | ENRO | Feb  5 2001  3:57PM | BUY | 2001-07-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 126
116207 | ENRO | Feb  6 2001  4:53PM | BUY | 2001-07-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 126
116431 | ENRO | Feb  8 2001 12:00AM | BUY | 2001-07-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 126
117296 | ENRO | Feb 27 2001 12:00AM | BUY | 2001-07-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 126
114324 | ENRO | Jan  5 2001 12:00AM | SELL | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 57.5
115036 | ENRO | Jan 22 2001  4:20PM | SELL | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 57.5
117795 | ENRO | Mar  6 2001  6:21PM | SELL | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 84.75
107831 | ENRO | Sep  6 2000 12:00AM | BUY | 2003-01-01 00:00:00 | 2006-01-01 00:00:00 | 100 | 5x16 | NYIS/ZONE J | 38.19508
Spreadsheet: 05f4773a-a1b5-47eb-a9e7-9596fc4daab1
Sheet: Figure 7a data

year | cpreallogdev10 | fbalt0errorcomb
1977 | -41.47236 | -7.234262
1978 | -40.94496 | -1.89263
1979 | -10.01986 | -4.710392
1980 | -8.13662 | -6.563248
1981 | -37.09442 | -2.474469
1982 | -56.55609 | -1.422639
1983 | -48.64074 | 0.0787787
1984 | -57.7227 | -0.5751269
1985 | -45.51056 | -0.770126
1986 | -45.91908 | -2.051005
1987 | -16.99178 | -2.28352
1988 | 20.14834 | -2.713611
1989 | 23.93608 | -5.343116
1990 | 14.28492 | 0.6963379
1991 | 0.7502 | -0.2420529
1992 | -3.37493 | -0.7422547
1993 | -24.49258 | -1.110361
1994 | -6.87847 | -0.1944679
1995 | 13.02171 | -1.130906
1996 | -17.96439 | -0.4418205
1997 | -22.27801 | 0.4317812
1998 | -54.87712999999999 | -0.1053034
1999 | -55.09581 | 0.6513158
2000 | -35.48304 | -0.0693719
2001 | -45.33184 | 0.6623793
2002 | -42.11939 | 1.327657
2003 | -25.29696 | 0.0737995
2004 | 22.55794 | -1.802472
2005 | 44.54062 | -3.027666
2006 | 102.1922 | -4.617418
2007 | 90.64305 | -8.341913
2008 | 70.90269 | 0.2286541
2009 | 28.33156 | 8.096022
Spreadsheet: 140619d1328821171-inventory-yfeb-food-total-values
Sheet: 2-5-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 |  | 1 | Cup | Chobani Peach
 | Daily Total | 18 | Pieces | Pretzels
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 |  | 1 | Serving | [NAME] | 1.31 | 8
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
 |  | 1 | Piece | English Muffin
 |  | 1 | Stick | Carrot
 |  | 29 | Gram | Turkey
 |  | 24 | Gram | [NAME]
Spreadsheet: 7dc88048-eb24-4860-beeb-a9f76eb5d419
Sheet: Sheet1

Country | Unnamed: 1 | Amount | Foreign buy | Foreign sell | [NAME] buy | Banknotes sell
Australia |  | AUD | 1.3322 | 1.2972 | 1.3766 | 1.27
Bulgaria |  | BGN | 0 | 0 | 2.0096 | 1.8629
Canada |  | CAD | 1.3408 | 1.3056 | 1.3848 | 1.2788
Czech Republic |  | CZK | 26.368 | 25.674 | 26.842 | 25.278
Denmark |  | DKK | 7.5517 | 7.3535 | 7.7582 | 7.2216
United Kingdom |  | GBP | 0,8600 | 0,8374 | 0,8819 | 0,8266
Croatia |  | HRK | 7.6845 | 7.4573 | 7.817 | 7.1734
Hungary |  | HUF | 294.49 | 286.78 | 304.71 | 278.59
Switzerland |  | CHF | 1.2675 | 1.2343 | 1.2901 | 1.2243
Japan |  | [NAME] | 133.6 | 130.09 | 137.83 | 127.58
Norway |  | NOK | 7.5876 | 7.3887 | 7.7835 | 7.2451
Poland |  | PLN | 4.2374 | 4.126 | 4.3451 | 3.9891
Romania |  | RON | 4.4163 | 4.2857 | 0 | 0
[NAME] |  | RUB | 40.804 | 39.733 | 0 | 0
Sweden |  | SEK | 8.6702 | 8.4426 | 8.9269 | 8.2715
Turkey |  | TRY | 2.4389 | 2.3199 | 0 | 0
USA |  | USD | 1.3021 | 1.2679 | 1.3207 | 1.2402
Spreadsheet: 146939d1332432691-sumproduct-sumproduct-gl
Sheet: SAP 41170190 - 42115150

DocumentNo | Profit Ctr | Product | Text | Reference | Type | Order | G/L | G/L Descript | User Name | Document Header Text | Pstng Date | Doc. Date | Curr. | Amount in doc. curr. | Amount in local cur. | LCurr
 | BSKG |  |  |  |  |  | 42111010 |  |  |  |  |  |  |  | 4192.55 | GBP
 | BSKG |  |  |  |  |  | 42111010 |  |  |  |  |  |  |  | -171.43 | GBP
 | BSKG |  |  |  |  |  | 42111010 |  |  |  |  |  |  |  | 3457.36 | GBP
 | BSKG |  |  |  |  |  | 42111010 |  |  |  |  |  |  |  | 12413.92 | GBP
 | BSKG |  |  |  |  |  | 42111010 |  |  |  |  |  |  |  | 12737.5 | GBP
 | BSKG |  |  |  |  |  | 42111010 |  |  |  |  |  |  |  | 13560.28 | GBP
 | BSKG |  |  |  |  |  | 42111010 |  |  |  |  |  |  |  | 13337.89 | GBP
 | BSKG |  |  |  |  |  | 42111010 |  |  |  |  |  |  |  | 13434.84 | GBP
 | BSKG |  |  |  |  |  | 42112010 |  |  |  |  |  |  |  | 6945.69 | GBP
 | BSKG |  |  |  |  |  | 42112010 |  |  |  |  |  |  |  | 645 | GBP
 | BSKG |  |  |  |  |  | 42112010 |  |  |  |  |  |  |  | 1761.07 | GBP
 | BSKG |  |  |  |  |  | 42112010 |  |  |  |  |  |  |  | 634.92 | GBP
 | BSKG |  |  |  |  |  | 42112010 |  |  |  |  |  |  |  | 2139.86 | GBP
 | BSKG |  |  |  |  |  | 42112050 |  |  |  |  |  |  |  | 2693.07 | GBP
 | BSKG |  |  |  |  |  | 42112050 |  |  |  |  |  |  |  | 4792.49 | GBP
 | BSKG |  |  |  |  |  | 42112050 |  |  |  |  |  |  |  | 300 | GBP
 | BSKG |  |  |  |  |  | 42115110 |  |  |  |  |  |  |  | 722.59 | GBP
 | BSKG |  |  |  |  |  | 42115110 |  |  |  |  |  |  |  | -135.48 | GBP
 | BSKG |  |  |  |  |  | 42115110 |  |  |  |  |  |  |  | 385.74 | GBP
 | BSKG |  |  |  |  |  | 42115110 |  |  |  |  |  |  |  | 883.93 | GBP
 | BSKG |  |  |  |  |  | 42115110 |  |  |  |  |  |  |  | 2048.9 | GBP
 | BSKG |  |  |  |  |  | 42115110 |  |  |  |  |  |  |  | 924 | GBP
 | BSKG |  |  |  |  |  | 42115110 |  |  |  |  |  |  |  | 1201.29 | GBP
 | BSKG |  |  |  |  |  | 42115110 |  |  |  |  |  |  |  | 1866.67 | GBP
 | BSKG |  |  |  |  |  | 42115110 |  |  |  |  |  |  |  | 1400 | GBP