tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 349478d1412345282-formula-to-refer-to-array-in-another-sheet-that-shifts-based-on-date-vertex34
Sheet: Sheet2

 |  |  |  |  | Quarter | Quarter Start Date | End Date | Average Unit Price (cents)
 |  |  |  |  |  | 2011-07-01 00:00:00 | 2011-09-30 00:00:00
 |  |  |  |  |  | 2011-10-01 00:00:00 | 2011-12-31 00:00:00
 |  |  |  |  |  | 2012-01-01 00:00:00 | 2012-03-31 00:00:00
 |  |  |  |  |  | 2012-04-01 00:00:00 | 2012-06-30 00:00:00
 |  |  |  |  |  | 2012-07-01 00:00:00 | 2012-09-30 00:00:00
 |  |  |  |  |  | 2012-10-01 00:00:00 | 2012-12-31 00:00:00
 |  |  |  |  |  | 2013-01-01 00:00:00 | 2013-03-31 00:00:00
 |  |  |  |  |  | 2013-04-01 00:00:00 | 2013-06-30 00:00:00
 |  |  |  |  |  | 2013-07-01 00:00:00 | 2013-09-30 00:00:00
 |  |  |  |  |  | 2013-10-01 00:00:00 | 2013-12-31 00:00:00
 |  |  |  |  |  | 2014-01-01 00:00:00 | 2014-03-31 00:00:00
 |  |  |  |  |  | 2014-04-01 00:00:00 | 2014-06-30 00:00:00
 |  |  |  |  |  | 2014-07-01 00:00:00 | 2014-09-30 00:00:00 | 0
 |  |  |  |  |  | 2014-10-01 00:00:00 | 2014-12-31 00:00:00 | 0
Spreadsheet: 848398d1699115081-formula-for-weight-gain-and-loss-help-puppies-weight-1-
Sheet: Sheet1

 | Name | Spot
 | Time | 09:19:00
 | Weight | 349 | 360 | 375
 | Sex | Male
 | Colour | Black and white
 | Description | Black spot on the nose, half Arrow on neck
 | Name | Chip
 | Time | 09:55:00
 | Weight | 290
 | Sex | Male
 | Colour | [NAME]
 | Description
 | Name | [NAME]
 | Time | 09:55:00
 | Weight | 245
 | Sex | Male
 | Colour | Red
 | Description
 | Name | Pig
 | Time | 10:10:00
 | Weight | 306
 | Sex | Female
 | Colour | Black and White
 | Description | Trolley fore head
 | Name | Shortbread
 | Time | 11:15:00
 | Weight | 316
 | Sex | Female
 | Colour | Red`
 | Description
 | Name | [NAME]
 | Time | 11:56:00
 | Weight | 281
 | Sex | Male
 | Colour | Black and white
 | Description | White stripe
 | Name | Bigdog
 | Time | 13:00:00
 | Weight | 306
 | Sex | Female
 | Colour | Black and White
 | Description | White stripe
 | Name | Bourbon
 | Time | 14:35:00
 | Weight | 343
 | Sex | Male
 | Colour | [NAME]
 | Description | Brown spot in white
Spreadsheet: 002b290e-3715-4341-8c84-11d07db9cdbd
Sheet: SR_DALOCSUM

Day Ahead Energy Market Locational Settlement Report |  |  |  |  |  |  |  | Day Ahead Energy Market Locational Settlement Report |  |  |  |  |  |  |  | Day Ahead Energy Market Locational Settlement Report
SR_DALOCSUM_<customer id>_<settlement date>_<version>.CSV |  |  |  |  |  |  |  | SR_DALOCSUM_<customer id>_<settlement date>_<version>.CSV |  |  |  |  |  |  |  | SR_DALOCSUM_<customer id>_<settlement date>_<version>.CSV
<customer name> |  |  |  |  |  |  |  | <customer name> |  |  |  |  |  |  |  | <customer name>
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 | [NAME] |  |  | Day-ahead Generation Obligation |  |  |  | Day-ahead Load Obligation |  |  |  | Day-ahead Adjusted Load Obligation |  |  |  | LMP Components
Trading Interval | Location Id | Location Name | Location Type | Day Ahead Cleared Generation (A) | Day Ahead Cleared Increments (B) | Day Ahead Cleared Imports (C) | Day Ahead  Generation Obligation (D) | Day Ahead Cleared Demand Bids (E) | Day Ahead Cleared Decrements (F) | Day Ahead Cleared Exports (G) | Day Ahead Load Obligation (H) | Day Ahead Internal Bilateral For Purchases (I) | Day Ahead Internal Bilateral For Sales (J) | Day Ahead Adjusted Load Obligation (K) | Day Ahead Adjusted Net Interchange (L) | Day Ahead Energy Component | Day Ahead Congestion Component | Day Ahead Marginal Loss Component | Day Ahead Energy Charge / Credit | Day Ahead Congestion Charge / Credit | Day Ahead Loss Charge / Credit | Day Ahead Cleared Asset Related Demand Bids
Hour End | Number | String | String | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | $ | $ | $ | $ | $ | $ | MWh
Spreadsheet: 827236d1682574095-a-formula-to-generate-three-more-words-in-separate-columns-from-a-list-provided-test
Sheet: 工作表1

abandoned
absolute
abstract
absurd
academic
accessible
Spreadsheet: 142822d1330020499-excel-2007-creating-a-usable-work-sheet-for-orders-cabinet-order-john-b1
Sheet: Sheet1

Citywide Cabinetry - Order Sheet |  |  |  |  |  |  |  | Job Name - John Black |  |  |  |  |  |  | Item # | LO | HY | CH | SC | WH | MO | RO | WS/YC | BC
(440) 235-3631 |  | 25271 Sprague Rd Columbia Station 44028 |  |  |  |  |  | Phone # |  |  |  |  |  |  | MW3030 | 243.76 | 353.6 | 505.64 | 316.48 | 282.68 | 309.72 | 323.28 | 332.3 | 530.92
Cabinet Styles |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MW3036
 | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | Bristol Chocolate |  |  | Hickory |  | MW3042
 | [NAME] |  |  | Tuscany Rope |  |  | [NAME] |  |  | Arlington White |  |  | [NAME] |  | W0930
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W0936
Base Cabinets |  |  |  |  |  |  | Upper Cabinets
Size |  | Retail |  | Your Price |  |  | Size |  |  | Retail | Your Price
db18 |  | 547 |  |  |  |  | W3630 |  |  | 477.4
lz 36 |  | 987 |  |  |  |  | WR3612 |  |  | 383
SB36 |  | 499.32 |  |  |  |  | W30X30 |  |  | 399.56
B30 |  | 470.08 |  |  |  |  | W12X30 X2 |  |  | 398
B09 |  | 256.76 |  |  |  |  | W 30X12 |  |  | 230
B24X2 |  | 768.96 |  |  |  |  | W42X30 |  |  | 546
PANTRY 1884 |  | 933.16 |  |  |  |  | W24D |  |  | 524
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | [NAME]
 |  | 0 |  |  |  |  |  |  |  | 0
Trim/ Molding |  |  |  |  | Total |  | Trim/ Molding |  |  |  |  | Total
LCM X5 CROWN |  | 890 |  |  |  |  | TOE KICKSX8 |  |  | 336
[NAME] SCIBE |  | 228 |  |  |  |  |  |  |  | 0
TF 396 TALL FILLER |  | 125 |  |  |  |  |  |  |  | 0
BASE FILLER X2 |  | 60 |  |  |  |  |  |  |  | 0
IS3696 ISLAND PANEL |  | 243 |  |  |  |  |  |  |  | 0
 |  |  |  |  | Total |  |  |  |  |  |  | Total
Customer Signature
X_________________________________________________ |  |  |  |  |  |  | Date  _______________ |  |  |  | Discounter |  | Total Cost
Management |  |  |  |  |  |  |  |  |  |  | 0.45
X_________________________________________________ |  |  |  |  |  |  | Date  _______________
Spreadsheet: 48605d1247829646-searching-values-from-two-different-tables-book1
Sheet: Sheet2

Diameter | Thickness | Drift Value
1 | 0.3 | 1.5
1 | 0.4 | 2.5
1 | 0.5 | 3.5
1 | 0.6 | 4.5
1.5 | 0.3 | 8.2
1.5 | 0.5 | 9.6
Spreadsheet: 582691d1532003016-need-to-fill-a-table-from-a-data-sheet-by-a-reference-no-online
Sheet: Sheet1

Return Gate Pass
Ceylon Steel Coporation Ltd.
 |  |  |  |  | NO:
Date: |  |  |  | Taken By:
Dept/Mill: |  |  |  | Emp/ID No:
Delivery To: |  |  |  | Vehicle No:
 |  |  |  | Return Date:
S/ No. | Description |  |  | Identification No. | UOM | Qty
1.
2.
3.
4.
5.
6.
7.
Requested By:
date | NO | mill/dept | description | identfctn no | uom | qty | place | Requested By: | Taken By: | id | vehicle | Return Date:
2018-07-17 00:00:00 | 1 | rm | spare part | sd54fs3 | nos | 10 | [NAME] | [NAME] | kasun | 5385 | [NAME] | 22/7/18
2018-07-17 00:00:00 | 1 | rm | spare part | 654as54as | nos | 10 | [NAME] | [NAME] | kasun | 5385 | [NAME] | 22/7/18
18/07/2018 | 2 | pm | machine | a5s4d54 | nos | 6 | hardware | gamini | pradeep | 5468 | wl-7954 | 30/07/2018
2018-07-19 00:00:00 | 3 | pm | hard disk | a45sd4 | nos | 4 | hardware | gamini | pradeep | 5468 | wl-7954 | 30/07/2018
Spreadsheet: 702926d1604609428-different-commission-rate-after-specific-sales-level-obtained-commissions-example
Sheet: Nov20

COMMISSIONS
Sales | 100000
NET SALES - OCTOBER |  | NET SALES - YTD
NAME | NOVEMBER | % | PAYMENT
Under $4 million net |  | 0.02 |  |  | **Should show $50,000
Over $4 million net |  | 0.03 |  |  | **Should show $50,000
Spreadsheet: 100969d1299168816-different-from-pivot-table-ptgroupbyyear2
Sheet: Pivot

 | Column Labels
 | 2011 |  | 2010
Row Labels | Sum of Total Charge | Sum of Total Charge2 | Sum of Total Charge | Sum of Total Charge2
Facility A | 160 | 0.06666666666666667 | 150
Facility B | 180 | 0 | 180
Facility C | 200 | -0.09090909090909091 | 220
Facility D | 210 | -0.1923076923076923 | 260
Spreadsheet: 731337d1620297021-find-the-correct-row-find-the-relevant-rows
Sheet: Renewal

Customer | [NAME] | Premium | Turnover | Vlookup premium | [NAME] turnover
 |  | 15000 | 85000000
Customer 1 | 2019-12-31 00:00:00 | 15000 | 85000000
Customer 1 | 2021-12-31 00:00:00 | 15000 | 85000000
Customer 2 | 2020-12-31 00:00:00 | 857321.9999999999 | 34709400000
Customer 2 | 2018-12-31 00:00:00 | 800000 | 31187900000
Customer 2 | 2019-12-31 00:00:00 | 800000 | 32438000000
Customer 2 | 2021-12-31 00:00:00 | 867000 | 19 320 500 000
Customer 3 | 2020-12-31 00:00:00 | 15000 | 75000000
Customer 3 | 2021-12-31 00:00:00 | 15000 | 75000000
Customer 4 | 2020-12-31 00:00:00 | 32000 | 160000000
Customer 4 | 2019-12-31 00:00:00 | 25600 | 128000000
Customer 4 | 2021-12-31 00:00:00 | 23000 | 115000000
Customer 5 | 2020-12-31 00:00:00 | 34908 | 120000000
Customer 5 | 2019-12-31 00:00:00 | 32000 | 110000000
Customer 5 | 2021-12-31 00:00:00 | 33455 | 115000000
Customer 6 | 2020-12-31 00:00:00 | 5000 | 15000000
Customer 6 | 2021-12-31 00:00:00 | 5000 | 15000000
Customer 7 | 2021-02-28 00:00:00 | 8000 | 1640923
Customer 7 | 2020-02-29 00:00:00 | 8000 | 1640923
Customer 8 | 2019-10-31 00:00:00 | 7499.999999999999 | 18000000
Customer 9 | 2021-09-01 00:00:00 | 39000 | 30000000
Customer 10 | 2020-11-30 00:00:00 | 20000 | 165000000
Customer 10 | 2021-11-30 00:00:00 | 20000 | 165000000
Customer 11 | 2018-12-31 00:00:00 | 13315.06849315068 | 30000000
Customer 11 | 2019-12-31 00:00:00 | 20700 | 30000000
Customer 11 | 2020-12-31 00:00:00 | 20700 | 30000000
Customer 11 | 2021-12-31 00:00:00 | 13800 | 20000000
Spreadsheet: 470521d1468509943-how-to-group-1-to-many-relationship-csh8428-1147704-pivot
Sheet: Sheet1

Boss | Employee | Boss Email
[NAME] | [NAME] | [EMAIL]
[NAME] | [NAME] | [EMAIL]
[NAME] | Scott | [EMAIL]
[NAME] | Tyler | [EMAIL]
 |  |  |  |  | Boss | Boss Email | Employee
 |  |  |  |  | [NAME] | [EMAIL] | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  | [NAME] | [EMAIL] | Scott
 |  |  |  |  |  |  | Tyler
Spreadsheet: 778053d1650816490-vlookup-with-if-extract-only-seleted-stocks-copy
Sheet: Extracted

3P -SR / 3P-S / 3P-R / VDP | Industry
 |  |  | In "A COLUMN"- I have only those stocks from sheet 2 where 3P-SR, 3P-S, 3P-R, VDP is mentioned in Criteria 1 in column "C"  & Criteria 2 "Pending" is mentioned in coloumn "D" in sheet 2
 |  |  | B3:B16 are brought by vlookup from sheet 2 "C" Coloumn
 |  |  | But I want formula in B3:B23 that to take value from Sheet 2 "C" coloumn but if its blank then vlookup will take value from Sheet 2 'D" coloumn and if Sheet 2 "D" coloumn is also blanks then BLANK cell to be displayed
Spreadsheet: 848420d1699160518-placement-of-new-numbers-new
Sheet: Sheet1

cod
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | NEW | UPDATE
66612283 | T | 0 | 2890 | 0 | 0 | 8845 | 0 | 0 | 0
 | F | 0 | 0 | 365 | 1447 | 940 | 2390 | 4516 | 60 | 60
66612217 | T | 0 | 0 | 0 | 0 | 9984 | 0 | 0 | 0
 | F | 0 | 0 | 0 | 0 | 1272 | 6390 | 1800 | 95 | 108
66612210 | T | 0 | 0 | 0 | 0 | 4944 | 4800 | 4936 | 0
 | F | 0 | 0 | 0 | 0 | 1310 | 2582 | 1738 | 453 | 468
Spreadsheet: 805854d1668960815-sum-dates-acording-to-list-sumpruduct-hours-aligw
Sheet: October

 | Absence Type Key | V | Vacation |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 | October | Dates of Absence
 | Employee 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 | Total hours | Vacation hours | Personal hours
 | Employee 1
 | Employee 2
 | Employee 3 |  |  |  | v | v |  |  |  |  | p |  |  |  |  |  |  |  |  | p | p |  |  |  |  |  |  | p
 | Employee 4
 | Employee 5
 |  |  |  |  | Mon | 5 |  |  |  |  | For Employee 3 vacation hours should be 11 and Personal hours should be 13, Total should be 24
 |  |  |  |  | Tue | 7
 |  |  |  |  | Wed | 4
 |  |  |  |  | Thu | 2
 |  |  |  |  | Fri | 5
Spreadsheet: 25c77ac1-c12b-4dff-9d41-6bb368478ea7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Business, Management and Administration: Business Analysis
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Business Analysis Pathway of the Business, Management and Administration Career Cluster) can serve as a guide, along with other career planning materials, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for              Business Analysis Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Budget Analyst ►Business Analyst ►Business Consultant ►E-Commerce Analyst ►Marketing Analyst ►Operations Research Analyst ►Price Analyst ►Product Manager ►Requirements Specialist ►Systems Analyst
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 27660d1221087149-change-from-foot-to-meters-conversion
Sheet: Data

[NAME] From |  |  | [NAME] To
Currency | Value |  | Currency | Value #1 | Value #2
GBP | 50.76 |  | USD | 89.0838 | 89.0838
CAD | 40.72 |  | CAD | 40.72 | 40.72
USD | 89.41 |  | USD | 89.41 | 89.41
AUD | 54.54 |  | GBP | 24.97932 | 24.97932
GBP | 69.17 |  | USD | 121.39335 | 121.39335
GBP | 11.35 |  | EUR | 14.2102 | 14.2102
EUR | 9.65 |  | AUD | 16.83925 | 16.83925
GBP | 8.12 |  | USD | 14.2506 | 14.2506
USD | 54.18 |  | CAD | 58.13514 | 58.13514
GBP | 13.02 |  | CAD | 24.52968 | 24.52968
USD | 16.94 |  | CAD | 18.17662 | 18.17662
GBP | 7.19 |  | AUD | 15.70296 | 15.70296
GBP | 9.91 |  | EUR | 12.40732 | 12.40732
EUR | 35.18 |  | AUD | 61.38910000000001 | 61.38910000000001
GBP | 0.32 |  | USD | 0.5616 | 0.5616
EUR | 66.86 |  | CAD | 100.6243 | 100.6243
USD | 99.77 |  | GBP | 56.86889999999999 | 56.86889999999999
Spreadsheet: 269103d1380962603-find-the-first-higher-value-than-a-value-or-find-the-first-lower-value-than-a-value-example-egotajcs-oeldere-
Sheet: example

 |  | min. | 10 |  |  | column D | Column E
CHANGE THESE ==>> |  | [NAME]. | -10
Column D | Column E |  | volatile | sum
 |  |  | 2.66
 |  |  | -3
 |  |  | -0.21
 |  |  | 0.95
 |  |  | 3.61
 |  |  | 1.14
 |  |  | -3
 |  |  | -3
 |  |  | -3
 |  |  | -3
 |  |  | 1.52
 |  |  | 5.13
 |  |  | 0.24
 |  |  | 4.94
 |  |  | 4.86
 |  |  | 0.38
 |  |  | 2.76
 |  |  | 0
 |  |  | 3.42
 |  |  | -3
 |  |  | -3
 |  |  | 5.25
 |  |  | -3
 |  |  | -3
 |  |  | -3
 |  |  | -3
 |  |  | 1.33
 |  |  | -3
 |  |  | -3
 |  |  | -3
 |  |  | 0.81
 |  |  | -3
 |  |  | 0.68
 |  |  | -3
 |  |  | 3.61
 |  |  | 3.42
 |  |  | 2.41
 |  |  | -3
 |  |  | -3
 |  |  | 1.9
 |  |  | -3
 |  |  | -3
 |  |  | -3
 |  |  | 1.14
 |  |  | 5.51
 |  |  | -3
 |  |  | -0.4
 |  |  | 4.18
 |  |  | 2.85
 |  |  | 3.5
 |  |  | -3
 |  |  | -3
 |  |  | -3
 |  |  | -3
 |  |  | -3
 |  |  | -3
 |  |  | 0.21
 |  |  | -3
 |  |  | 9.57
 |  |  | -3
 |  |  | 2.38
 |  |  | -3
 |  |  | -3
 |  |  | 17.73
 |  |  | -3
 |  |  | 6.11
 |  |  | -3
 |  |  | -3
 |  |  | 10.31
 |  |  | -1.03
 |  |  | -3
 |  |  | 6.4
 |  |  | -3
 |  |  | 1.47
 |  |  | 4.94
 |  |  | -3
 |  |  | 1.14
 |  |  | 2.44
 |  |  | -1.01
 |  |  | 1.61
 |  |  | 1.98
 |  |  | -3
 |  |  | -3
 |  |  | -0.55
Spreadsheet: 766069d1643738748-if-row-in-table-contains-both-x-and-y-then-z-andtable
Sheet: Sheet1

Thing | Month | Person | Contact
Bins Out | January | [NAME] | [EMAIL]
Washing Up | January | [NAME] | [EMAIL] |  | Person | Work?
Recylcing | February | [NAME] | [EMAIL] |  | [NAME]
Hoovering | March | [NAME] | [EMAIL] |  | [NAME]
Walk Dog | March | [NAME] | [EMAIL] |  | [NAME]
Clean out Hamster | March | [NAME] | [EMAIL] |  | [NAME]
[NAME] | April | [NAME] | [EMAIL]
Have a party | May | [NAME] | [EMAIL]
Stop caring | May | [NAME] | [EMAIL]
Start caring | June | [NAME] | [EMAIL]
Eat a caterpillar cake | July | [NAME] | [EMAIL]
Have 20 mountains | August | [NAME] | [EMAIL]
Lie to someones face | August | [NAME] | [EMAIL]
Destroy Capitalism | September | [NAME] | [EMAIL]
Make 12 fruitcakes | September | [NAME] | [EMAIL]
Become a Milkman | September | [NAME] | [EMAIL]
Pick up some lint | September | [NAME] | [EMAIL]
Carve a Pumpkin | October | [NAME] | [EMAIL]
Start November | November | [NAME] | [EMAIL]
End November | November | [NAME] | [EMAIL]
Have a christmas time | December | [NAME] | [EMAIL]
Spreadsheet: 49764d1249075944-vlookup-functions-excel-forum-vlookup-box-or-bag
Sheet: Supplier B

Part Name | Helper | Part Number | Package Type | Cost
101 | [NAME] | AB | Bag | 0.56
101 | ABBox | AB | Box | 0.58
102 | [NAME] | AC | Bag | 2.45
102 | ACBox | AC | Box | 2.66
103 | ADBag | AD | Bag | 2.77
103 | ADBox | AD | Box | 2.89
104 | AEBag | AE | Bag | 2.99
104 | AEBox | AE | Box | 4.25
Spreadsheet: mark_taylor__24700__CFDdiagram
Sheet: Sheet1

Contract for Differences
- Structural Diagram
Gas Daily/Index Swap
 |  | (1)* |  | (1) |  | (1) |  | (1)
 |  | NYMEX+.5287 |  | NYMEX+.5287 |  | NYMEX+.5287 |  | NYMEX+.5287
 |  | EPME |  | EPME |  | EPME |  | EPME
 |  | NYMEX |  | NYMEX |  | NYMEX |  | NYMEX
 | EPME |  | Mesquite |  | ECPH |  | DESK |  | [NAME]
 | El Paso |  | EPME |  | ENA |  | ENA |  | BANK
 |  | (2c) |  | (2b) |  | (2a) |  | (3a)
 |  | $350 MM |  | 51% ECP |  | $350 MM |  | $350 MM
 |  | value |  | 157.9 MM |  | value |  | cash
 |  |  |  | Sub Notes
 | (1) | NYMEX swap between EPME & Mesquite that is approx. $347.6 million "out of the money" - fully assignable
 |  | - notional 300,000 MMbtus/day
 |  | - calculated on monthly index settle but cash settled on a quarterly basis
 | (2a) | Consideration paid by ENA desk to ECPH/ENA for the "in the money" EPME contract
 | (2b) | Consideration paid by ECPH/ENA to [NAME] for the "in the money" EPME contract
 | (2c) | Consideration paid by Mesquite to EPME for the "in the money" EPME contract
 | (3a) | Consideration paid to ENA for "in the money" EPME contract
 | * | initial contract subject to assignment
Spreadsheet: 781382d1653299029-budget-calendar-calendar-1-
Sheet: Sheet1

 | Month | Year
 | January | 2022
Due Date | [NAME] | Amount | Paid? |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1 | rent | 1100
1 | storage unit | 86.46
5 | Insurance | 150 |  |  |  |  |  |  |  |  | storage unit
5 | Phone | 147
 |  |  |  |  |  |  |  | Phone
 |  |  |  |  |  |  | storage unit |  |  |  | Phone
Spreadsheet: 744968d1629618355-vlookup-n-a-error-naerrorhelp_updated
Sheet: PoleValue

 | Pole size (m) |  |  |  | Strength 2 |  |  |  | For unharvestable pole value calculation for SOLVER sheet
Tree | 8 | Length | KN | Price | D-Line | HEAD |  |  | Length | KN | Price | D-Line | HEAD
 |  | 8 | 8 | 26 | 24.5 | 17.5 |  |  | 9.5
 |  | 9.5 | 8 | 43 | 26.5 | 18.5 |  |  | 11
 |  | 9.5 | 12 | 62 | 29.9 | 21.4 |  |  | 12.5
 |  | 11 | 8 | 65 | 28 | 18.5 |  |  | 14
 |  | 11 | 12 | 93 | 32 | 22 |  |  | 15.5
 |  | 12.5 | 8 | 91 | 29.5 | 18.5 |  |  | 17
 |  | 12.5 | 12 | 129 | 33.5 | 21.5 |  |  | 18.5
 |  | 14 | 8 | 122 | 30.5 | 18.5 |  |  | 20
 |  | 14 | 12 | 178 | 35 | 21.5
 |  | 14 | 20 | 251 | 42 | 26
 |  | 15.5 | 8 | 157 | 32 | 19.5
 |  | 15.5 | 12 | 246 | 36.5 | 23
 |  | 15.5 | 20 | 386 | 43.5 | 28.5
 |  | 17 | 8 | 204 | 33 | 20
 |  | 17 | 12 | 314 | 38 | 23.5
 |  | 17 | 20 | 481 | 45 | 28.5
 |  | 18.5 | 8 | 251 | 35 | 21
 |  | 18.5 | 12 | 397 | 39 | 24
 |  | 18.5 | 20 | 606 | 46.5 | 29
 |  | 20 | 8 | 314 | 35 | 21.5
 |  | 20 | 12 | 491 | 40 | 25
 |  | 20 | 20 | 742 | 47.5 | 29.5
Spreadsheet: 740672d1626448147-correction-needed-for-outbound-quantity-example_avg_cost-warehouse-approach-v4-
Sheet: Version9

Limits: |  |  |  |  | TRANSACTION
 |  |  |  |  |  |  |  |  | OUTBOUND |  |  | OUTSTANDING |  |  | P/L
Trade Symbol | Transaction | Date | Sale Portion | [NAME] | Quantity (Units Purchased(+) or Sold(-)) | Price | Fees | Amount | Units Sold (Quantity Sold) | Price (Is this needed anymore?) | Amount (Cost of Goods Sold) | Units Remaing  (Quantity Left Over) | Price (Is this needed anymore?) | Amount (Inventory Value) | Gain(+) /     Loss(-) | Gain(+) /     Loss(-) per Sales Only |  |  |  | Total Cost | Needed for correct cumulative average cost value |  | Cumulative Units | Cumulative Average Cost | Current Balance (FIFO) | Sales Only -  Separated for RAW data |  | Gain (Loss) P & L | Notes
 | Purchase | 2021-02-22 00:00:00 |  |  | 3.514923 | 14.21 | 0
 | Purchase |  |  |  | 1.95554 | 12.8 | 0
 | Purchase | 2021-02-23 00:00:00 |  |  | 2.121327 | 11.78 | 0
 | Purchase | 2021-03-24 00:00:00 |  |  | 374.242645 | 13.45 | 0
 | Sale | 2021-03-29 00:00:00 | All | Short | -381.834442 | 13.34 | 0
 | Purchase | 2021-04-17 00:00:00 |  |  | 13.380624 | 37.72 | 0
 | Purchase |  |  |  | 12.706329 | 39.39 | 0
 | Purchase | 2021-04-27 00:00:00 |  |  | 28.600846 | 35.18 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 74.626678 | 67.52 | 0
 | Purchase |  |  |  | 270.208195 | 74.56 | 0
 | Sale | 2021-05-04 00:00:00 | All | Short | -399.522672 | 78.52 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 179.734944 | 84.04 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 49.622456 | 101.4 | 0
 | Purchase |  |  |  | 246.20782 | 102.55 | 0
 | Purchase |  |  |  | 165.37101 | 103.4 | 0
 | Sale | 2021-05-05 00:00:00 | All | Short | -640.93623 | 104.18 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 30.301633 | 99.03 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 276.819944 | 145.41 | 0
 | Sale | 2021-05-06 00:00:00 | All | Short | -307.121577 | 168.49 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 277.1079 | 182.23 | 0
 | Purchase |  |  |  | 138.149505 | 182.77 | 0
 | Sale | 2021-05-08 00:00:00 | Partial | Short | -107.381606 | 127.43 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Should be a negative number … here is where things get complicated…
 | Sale | 2021-06-30 00:00:00 | Partial | Short | -100 | 50 | 0
 | Sale | 2021-07-01 00:00:00 | Partial | Short | -100 | 50 | 0
 | Purchase | 2021-07-02 00:00:00 |  |  | 60 | 100 | 0
 | Purchase | 2021-07-03 00:00:00 |  |  | 60 | 100 | 0
 | Sale | 2021-07-04 00:00:00 | Partial | Short | -75 | 10 | 0
 | Sale | 2021-07-05 00:00:00 | Partial | Short | -50 | 10 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How do we get Q26 to show a value that represents a portion of the loss based on the fact that this partial sale was done to minimize some of the losses when the price dropped $55 per share? That value should equate to somewhere around $5000.00
Totals: |  |  |  | Purchase
 |  |  |  | Sale