tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 270363d1381446710-sum-adjacent-cell-to-a-reference-throughout-workbook-copy-of-xl0000036
Sheet: WE 5th Jan

Date | 07.01.14 |  |  | 07.01.14 |  |  | 07.01.14
Co./Code/Price | Blackwoods | Dept | Price | Inverell Bearing Cente | Dept | Price | L&H | Dept | Price
Item 1 | 1x ladder | 1C | 654.3 | 2x A84 v-belts | 1A | 19 | 1x box L36W/865 fluro tubes | 1B | 35.75
Item 2 | 1x box cutting discs | 1C | 49 | 2x 3525-4" t/lock | 1A | 38.99 | 1x box - phillips S10 starters | 1B | 13.7
Item 3
Item 4
Item 5
Item 6
Item 7
Item 8
Item 9
Item 10
Item 11
Item 12
Item 13
Item 14
Item 15
Item 16
Item 17
Item 18
Item 19
Item 20
Freight (Price inc) |  |  |  |  |  | 8
Notes
[NAME]. #
Req'd By
Invoice total (inc) | 703.3 |  |  | 65.99000000000001 |  |  | 49.45 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Other….
Spreadsheet: 692119d1598099548-calculating-ltd-and-etc-using-multiple-data-excel-issues-4-sumproduct-new
Sheet: Sheet1

 | LTD | ETC |  |  |  |  |  |  |  |  | A | A | A | A | A | F | F | F | F
1 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
2 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
3 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
4 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
5 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
6 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | H | 100
7 |  |  |  |  |  |  |  |  | 1 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | H | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 2 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 3 |  | 100 | H | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 3 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 4 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 5 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 5 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 5 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 6 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 7 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  | 7 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Spreadsheet: 705352d1606051184-developing-basic-scenarios-using-basic-if-then-or-other-recommendations-if-then
Sheet: VC&clusters tool calc-output

 | Data validation |  | MAX SCORE | 1
 | Short
 | Intervention | MAX SCORE | A | B | C
 | Short | 1 | 0.6875 | 0.6875 | 0.3125
 | Medium | 1 | 0.875 | 0.75 | 0.8125
 | Fixed | 1 | 1 | 1 | 1
 | Fixed | 1 | 1 | 1 | 1
 | Long | 1 | 0.5625 | 0.6875 | 0.875
 | Medium | 1 | 0.8125 | 0.4375 | 0.625
 | Fixed | 1 | 1 | 0.625 | 0.9375
 | Fixed | 1 | 0.75 | 0 | 0.25
 | Fixed | 1 | 0 | 1 | 0.5
 | Short | 1 | 0 | 1 | 0
 | Long | 1 | 0 | 1 | 0
 | Medium | 1 | 0.875 | 0.8125 | 0.5
 | Long | 1 | 0 | 0 | 1
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: IT Infra

 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 |  |  | 2002 |  |  | Per HC | New HC | Adj Comp |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  |  | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Analyst & Associate | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  |  | 2200800 |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  | 0
ENACONTR | Charitable Contributions |  |  |  |  |  | 0 |  | [NAME] | 49200 | 0
ENARENT | Rent |  |  |  |  |  | 2130374.4 |  | [NAME] | 57600 | 1
ENATECH | Technology |  |  |  |  |  |  |  | Staff | 60000 | 2
ENATRANS | Transportation |  |  |  |  |  | 0 |  | Specialist | 78000 | 9
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Sr. Specialist | 102000 | 25
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Analyst | 0 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | IT Consultants | 192000 | 0
 |  |  |  |  |  |  |  |  | Manager | 144000 | 15
 | Headcount |  |  | 111 | 40 |  |  |  | Director | 168000 | 2
 |  |  |  |  |  |  |  |  | Sr. Director | 216000 | 4
 | A&A Headcount |  |  |  |  |  | 1 |  | VP | 222000 | 1
 |  |  |  |  |  |  |  |  | MD | 300000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  | 0 |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance |  |  |  |  |  |  |  | Consultants | 192000 | 8
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure |  |  | 0
ENACORRN | Corporate Rent |  |  | 0
ENAOTHAL | Other Allocated Direct  Expenses |  |  | 0 |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 24143776.43 |  | 0 |  |  |  | Based on information from ENW accounting.
 | Infrastructure costs include amounts for desktop support, e-mail administration, security,
 | communications (long distance, trading turrets, phones, cables), licenses (Microsoft, etc),
 | market data feeds, T1 lines, internet access, WAN, LAN, etc.
Spreadsheet: joe_parks__14806__bridgeline 6-18
Sheet: Sheet1

b/s | contract | price | volume | time | cm | account | cti | order # | trader | reference | trade #
S | NGN2 | 3355 | 10 | 08:29:27 | 905 | 97563 | 4C | 3384 | [NAME] | EO-3384 | 1623 | 0 | N
S | NGN2 | 3355 | 10 | 08:33:31 | 905 | 97563 | 4C | 3403 | [NAME] | EO-3403 | 1634 | 0 | N
Spreadsheet: 718075d1612974843-averaging-formula-with-multiple-criteria-speed-average-example-aligw
Sheet: Sheet1

Player ID | SPEED
0 | 1
0 | 0.24
0 | 0.67
0 | 0.12
1 | 0 |  | average ID 1
1 | 0.89
1 | 3.2 |  | excluding values 0-0,2
1 | 0.45
1 | 0
2 | 0.29
2 | 0.12
2 | 2.16
3 | 1.45
3 | 0
3 | 0
3 | 1.21
3 | 0.48
3 | 0.12
3 | 0.96
Spreadsheet: 849529d1699973485-combine-3-sheets-data-into-1-final-sheet-book1-2-1-2-
Sheet: Sheet3

Squad | Class/Yd | Category | Name | 1 | 2 | Total
 | AA |  | [NAME] | 45 | 45
 | B |  | WILLY DOE | 44 | 44
 | C |  | MARK DOE | 41 | 41
 | D |  | [NAME] | 40 | 40
 | A |  | KATHY DOE | 38 | 42
Spreadsheet: 143474d1330438075-excel-2007-rows-from-multiple-sheets-into-one-exclude-those-without-values-safety-tour
Sheet: (25) Garage

Date: | 1/16 & 1/17 |  | Back to Department Listing
DEPARTMENT/LOCATION: |  | Garage
 |  | 0
ITEM # | ISSUES FOUND | [NAME] | STATUS | INTERIM SOLUTION
x | safety link needs replacing on dip tank | dip tank labeled [NAME] | carryover
x | [NAME] needed on red safety cans | under desk near fencing | carryover
x | fire extinguisher blocked |  | complete
ENVIRONMENT: PROPER HOUSEKEEPING, INSPECTION AND MAINTENANCE, STANDARD OPERATING PROCEDURES - Overall housekeeping okay
ESCORT:
Spreadsheet: 773326d1647795691-sumproduct-excluding-items-example1
Sheet: Sheet1

Job | WC | Op |  | Machine | Op | Total
12345X123 | Machine-A | 030 |  | A | 30
9870X1234 | Machine-A | 030
9870X1235 | Machine-A | 030
9871X1234 | Machine-A | 030
12345X123 | Machine-A | 030 |  |  | [ =SUMPRODUCT((Sheet5!C:C="030")-(Sheet5!A:A="12345X123")) ]
9870X1236 | Machine-A | 030 |  |  | The answer I want to get is 6.
9871X1235 | Machine-A | 030 |  |  | Parts have a Prefix I.E. 9870X,9871X,12345X the remainder increments and carry through other operations.
9871X1236 | Machine-A | 030
12345X124 | Machine-B | 050 |  |  |  | Parts Id like to exclude.
12345X124 | Machine-C | 060 |  |  |  | Parts Im attempting to add up.
Spreadsheet: 40471d1238776613-excel-2007-need-to-disable-table-formula-fill-down-autofill-example
Sheet: Sheet1

 | Item Number | Qty | Cost | Extended Cost
 | 211-1604 | 5 | 2
Spreadsheet: 9c04e76f-d2de-4282-afd1-c33719df28f2
Sheet: Sheet1

Release: Regional and State Employment and Unemployment (Seasonally Adjusted) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=250
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-10-02 1:15 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Regional and State Employment and Unemployment (Seasonally Adjusted) | 2012-01-24 00:00:00 | Current
Link:
[NAME] | 2012-01-24 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2012-01-24 00:00:00 | Current
Notes:
Bureau of Labor Statistics data that is seasonally adjusted by the | 2012-01-24 00:00:00 | Current
Federal Reserve Bank of St. Louis.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2012-01-24 00:00:00
2012-03-13 00:00:00
2012-03-30 00:00:00
2012-04-20 00:00:00
2012-05-18 00:00:00
2012-06-15 00:00:00
2012-07-20 00:00:00
2012-07-23 00:00:00
2012-08-17 00:00:00
2012-09-21 00:00:00
2012-10-19 00:00:00
2012-11-20 00:00:00
2012-12-21 00:00:00
2013-01-18 00:00:00
2013-03-18 00:00:00
2013-03-29 00:00:00
2013-04-19 00:00:00
2013-05-16 00:00:00
2013-05-17 00:00:00
2013-06-20 00:00:00
2013-06-21 00:00:00
2013-07-19 00:00:00
2013-08-19 00:00:00
2013-09-20 00:00:00
2013-11-22 00:00:00
2013-12-20 00:00:00
2014-01-28 00:00:00
2014-03-17 00:00:00
2014-03-28 00:00:00
2014-04-18 00:00:00
2014-05-16 00:00:00
2014-06-20 00:00:00
2014-07-18 00:00:00
2014-08-18 00:00:00
2014-09-19 00:00:00
Spreadsheet: 824619d1680713852-uniformity-sample
Sheet: Sample

Week 22
LH2
 | 1693 | 2167 | 1847 | 1872 | 1891 | 1740 | 1832 | 1735 | 1676 | 1895
 | 2009 | 1717 | 2063 | 1860 | 1788 | 1688 | 1583 | 1550 | 1753 | 1893
 | 1583 | 1874 | 1669 | 1879 | 1885 | 1597 | 1687 | 1725 | 1744 | 1963
 | 1875 | 1829 | 1963 | 1696 | 1769 | 1910 | 1773 | 1979 | 1709 | 1884
 | 1660 | 1918 | 1762 | 1453 | 1751 | 1579 | 1579 | 1714 | 1898 | 1700
 | 1671 | 1849 | 1617 | 1897 | 1839 | 1695 | 1644 | 1681 | 1783 | 1949
 | 1487 | 1942 | 1817 | 1801 | 1683 | 1849 | 1808 | 1871 | 1957 | 1839
 | 1840 | 1582 | 1663 | 1911 | 1877 | 1574 | 1565 | 1832 | 1423 | 1724
 | 2007 | 1838 | 1776 | 1551 | 1790 | 1611 | 1838 | 1871 | 1621 | 1741
 | 1701 | 1667 | 1971 | 1544 | 1804 | 1743 | 1573 | 1772 | 1822 | 1548
 | 1742 | 1658 | 1664 | 1603 | 1759 | 1746 | 1564 | 1701 | 1673 | 1898
 | 1773 | 1702 | 1482 | 1559 | 1297 | 1889 | 1747 | 1529 | 1593 | 1782
 | 1782 | 1843 | 1822 | 1826 | 1658 | 1928 | 1678 | 1668 | 1650 | 2035
 | 1903 | 1494 | 1601 | 1909 | 1778 | 1753 | 2000 | 1660 | 1743 | 1394
 | 1858 | 1693 | 1619 | 1812 | 1911 | 1822 | 1950 | 1550 | 1723 | 1871
 | Average
 | If 10% above avg. is
 | & 10% below avg. is
 | What percentage of the array above fall within the 20% range (or 10% above & 10% below) ?
 | In Poultry parlance we call this the % Uniformity, which in an ideal world is 80% or higher
 | i.e. 80% of the chicken weights fall 10% either side of the average
Spreadsheet: 130480d1322351546-lookup-for-values-copy-of-example
Sheet: Sheet1

 | Sales | Procurement | Finance | Order | Warranty | Responsibility
Jamal | X | X | X
Arif | X |  | X |  | X
[NAME] | X | X | X | X
Spreadsheet: 542892d1508157776-table-to-list-help-s666-1204910-table-to-list
Sheet: Before

 |  | A | B | C | D | E | F |  |  | Value | Attribute
 |  | 1 | 6 | 14 | 15 | 25 | 31 |  |  | 1 | A
 |  | 2 | 7 |  | 16 | 26 | 32 |  |  | 2 | A
 |  | 3 | 8 |  | 17 | 27 | 33 |  |  | 3 | A
 |  | 4 | 9 |  | 18 | 28 | 34 |  |  | 4 | A
 |  | 5 | 10 |  | 19 | 29 | 35 |  |  | 5 | A
 |  |  | 11 |  | 20 | 30 | 36 |  |  | 6 | B
 |  |  | 12 |  | 21 |  | 37 |  |  | 7 | B
 |  |  | 13 |  | 22 |  | 38 |  |  | 8 | B
 |  |  |  |  | 23 |  | 39 |  |  | 9 | B
 |  |  |  |  | 24 |  | 40 |  |  | 10 | B
 |  |  |  |  |  |  |  |  |  | 11 | B
 |  |  |  |  |  |  |  |  |  | 12 | B
 |  |  |  |  |  |  |  |  |  | 13 | B
 |  |  |  |  |  |  |  |  |  | 14 | C
 |  |  |  |  |  |  |  |  |  | 15 | D
 |  |  |  |  |  |  |  |  |  | 16 | D
 |  |  |  |  |  |  |  |  |  | 17 | D
 |  |  |  |  |  |  |  |  |  | 18 | D
 |  |  |  |  |  |  |  |  |  | 19 | D
 |  |  |  |  |  |  |  |  |  | 20 | D
 |  |  |  |  |  |  |  |  |  | 21 | D
 |  |  |  |  |  |  |  |  |  | 22 | D
 |  |  |  |  |  |  |  |  |  | 23 | D
 |  |  |  |  |  |  |  |  |  | 24 | D
 |  |  |  |  |  |  |  |  |  | 25 | E
 |  |  |  |  |  |  |  |  |  | 26 | E
 |  |  |  |  |  |  |  |  |  | 27 | E
 |  |  |  |  |  |  |  |  |  | 28 | E
 |  |  |  |  |  |  |  |  |  | 29 | E
 |  |  |  |  |  |  |  |  |  | 30 | E
 |  |  |  |  |  |  |  |  |  | 31 | F
 |  |  |  |  |  |  |  |  |  | 32 | F
 |  |  |  |  |  |  |  |  |  | 33 | F
 |  |  |  |  |  |  |  |  |  | 34 | F
 |  |  |  |  |  |  |  |  |  | 35 | F
 |  |  |  |  |  |  |  |  |  | 36 | F
 |  |  |  |  |  |  |  |  |  | 37 | F
 |  |  |  |  |  |  |  |  |  | 38 | F
 |  |  |  |  |  |  |  |  |  | 39 | F
 |  |  |  |  |  |  |  |  |  | 40 | F
Spreadsheet: 484485d1476286242-fill-the-form-in-sheet3-using-data-from-sheet1-school-reports-kk
Sheet: Report

 | Monthly Report for The Buses In the Schools |  |  |  |  |  |  | Month: |  |  |  | KG | B
 |  |  |  |  |  |  |  |  |  |  |  | Boys | C
 |  | School Type: | KG |  |  |  |  |  |  |  |  | Girls | D
 |  | School Name: | [NAME]
 | Serial No | Bus Number | Bus Type | Trip Type |  |  |  | Shared School Name |  | Driver Name
 |  |  |  | Large Bus |  | Small Bus
 |  |  |  | Double | Single | Double | Single
 |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: 824980d1680998246-formula-that-match-returns-one-or-more-value-depending-on-the-criteria-and-quantity-book1
Sheet: Sheet1

Stock Inventory |  |  |  |  |  | Order
Item Code | Location | Description | Qty | UOM |  | No | Item Number | Carton Quantity | Loose Quantity | UOM | Location 1 | Location 2 | Location 3
11157503 | [NAME] | MM OVAL #1 | 12 | ST
11157503 | [NAME] | MM OVAL #1 | 1 | ST |  | 1 | 11157503 | 13 |  | ST | [NAME] | [NAME]
11161451 | [NAME] | MM OVAL #2 | 9 | CT |  | 2 | 11161451 |  | 11 | CT | [NAME] | [NAME] | [NAME]
11161451 | [NAME] | MM OVAL #2 | 1 | CT |  | 3
11161451 | [NAME] | MM OVAL #2 | 1 | CT |  | 4
Spreadsheet: 720045d1613994709-how-do-print-following-cells-according-to-my-number-switch
Sheet: Sheet1

 |  |  |  | Time
 |  |  |  | 0
 | CHILLER  ROOM |  |  | 1
 | ON time (Min) | 2 |  | 2
 | OFF time (Min) | 6 |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
 |  |  |  | 11
 |  |  |  | 12
 |  |  |  | 13
 |  |  |  | 14
 |  |  |  | 15
 |  |  |  | 16
 |  |  |  | 17
 |  |  |  | 18
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  | 21
 |  |  |  | 22
 |  |  |  | 23
Spreadsheet: kimberly_watson__20661__Timberline Summary 010813
Sheet: Sheet1

Enron Corp |  |  |  |  |  |  | Standard Estimate Report |  |  |  |  |  |  |  | Page 9
 |  |  |  |  |  |  | Big Sandy Tie In Rev#1 |  |  |  |  |  |  |  | 8/13/2001  1:28:00 PM
 |  |  |  |  |  |  | Estimate Totals
 |  |  | Labor |  | 119707
 |  |  | Materials |  | 142969
 |  |  | Subcontract |  | 252
 |  |  |  |  |  |  | 262928
 |  |  | Freight  (%) |  | 7148 |  |  |  | 0.05
 |  |  |  |  |  |  |  |  | 0.075
 |  |  | Tax  (%) |  | 10723
 |  |  | Pipeline Right of Way  (LS) |  | 2500
 |  |  | Environmental  (LS) |  | 2000
 |  |  | CSUP - Survey (LS) |  | 10000
 |  |  | CSUP - Inspection (LS) |  | 25000
 |  |  | DLAB - District Labor (LS) |  | 2500
 |  |  | Engineering - Enron  (LS) |  | 5000
 |  |  | Engineering - Contract  (LS) |  | 10000
 |  |  | Engineering - AsBuiltDwg  (LS) |  | 13000
 |  |  | PROJECT MANAGEMENT  (LS) |  | 1500
 |  |  | CONTINGENCY  (%) |  |  |  |  |  | 0.1
 |  |  | OVERHEAD  (%) |  |  |  |  |  | 0.105
 |  |  | AFUDC (% of Current Total) |  |  |  |  |  | 0.0496
 |  |  | Tax Gross Up (% of Sub Total) |  |  |  |  |  | 0.3016
 |  |  |  |  | Total
 | Note:  This is a + 30% cost estimate.
Spreadsheet: 0b2c4dd4-7afd-435f-8458-fa7b5b183f8c
Sheet: 12a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis
 | FRA
 | Exotic
 | Inflation
 | IRS- [NAME]
 | OIS
 | VNS
 | Zero Coupon
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | N/A*** | N/A | N/A
Estimated swap dollar volumes, week ending December 28, by product type and cleared status (value of all trades in millions of USD), all participant types and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product 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: 581928d1531595703-how-to-manually-create-own-calendar-calendar-v1
Sheet: Sheet1

 | MONTHLY TIMETABLE
 | 2018-12-01 00:00:00 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Spreadsheet: 28680d1223063958-sorting-cells-merged-column-book8
Sheet: Sheet1

Sucontractors | Type | General Liablity | Automobile Liablity | Excess Liability | Workers Comp | Professional Liability | Equipment Floater | Notes
Apple | LIMIT
 | Effective Date
 | Expiration
 | Days
Bravo | LIMIT
 | Effective Date
 | Expiration
 | Days
[NAME] | LIMIT
 | Effective Date
 | Expiration
 | Days
Delta | LIMIT
 | Effective Date
 | Expiration
 | Days
Michale | LIMIT
 | Effective Date
 | Expiration
 | Days
[NAME] | LIMIT
 | Effective Date
 | Expiration
 | Days
Golf | LIMIT
 | Effective Date
 | Expiration
 | Days
Tango | LIMIT
 | Effective Date
 | Expiration
 | Days
Mango | LIMIT
 | Effective Date
 | Expiration
 | Days
Cargo | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
GZA | LIMIT
 | Effective Date
 | Expiration
 | Days
Spreadsheet: 272566d1382433338-how-to-join-two-worksheets-into-one-based-on-the-data-they-contain-ef510_join_tables
Sheet: corrective actions

# defect | corrective action | responsible person | date of completion |  | Helper
23456 | aaa | A | 12.12.12 |  | 23456_1
23456 | bbb | V | 13.1.11 |  | 23456_2
23457 | [NAME] | W | 4.9.13 |  | 23457_1
23458 | aac | A | 23.5.12 |  | 23458_1
23459 | asdf | N | 5.7.12 |  | 23459_1
23460 | asde | P | 6.1.12 |  | 23460_1
23460 | jyjt | E | 3.6.13 |  | 23460_2
23460 | asd | B | 23.9.11 |  | 23460_3
23461 | nydz | N | 1.1.13 |  | 23461_1
23462 | afeef | P | 9.9.12 |  | 23462_1
23463 | kuud | A | 5.7.12 |  | 23463_1
23464 | sgfsgr | W | 7.3.13 |  | 23464_1
23465 | [NAME] | R | 13.1.11 |  | 23465_1
23466 | xcvcx | Z | 6.3.12 |  | 23466_1
23467 | ewgt | L | 25.2.12 |  | 23467_1
23468 | kggjy | P | 3.6.13 |  | 23468_1
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
Spreadsheet: mark_guzman__24559__Rogers_Calculator
Sheet: Calculations

 |  | cost |  |  |  | SPS or TNP
 | Copper mw | 70 | 0.15 | 10.5 | Trans | 0.15 | 11.7 |  |  |  | 0.15 | 0.4
 | GAS $ | 4.5 | Adder | Margin | 5.71 | Adder | Margin |  | Lambda | 19.3
 | Start |  |  |  |  |  |  |  | Trans | 5.71
 | 4 HR Run
 | 5 HR Run
 | 6 HR Run
 | 7 HR Run |  |  |  |  |  |  |  |  | Enter Blue Numbers
 | 8 HR Run
 | 9 HR Run
 | 10 HR Run |  |  |  |  |  |  |  |  | PNM's Contingent
 | 11 HR Run |  |  |  |  |  |  |  |  | Gross output | Station Services***  NET |  | % of cap
 | 12 HR Run |  |  |  |  |  |  |  | Rio 7* | 32 | 3
 | 13 HR Run |  |  |  |  |  |  |  | Rio 8* | 110 | 7
 | 14 HR Run
 | 15 HR Run |  |  |  |  |  |  |  | PNM's Contingent** |  | 70
 | 16 HR Run |  |  |  |  |  |  |  | Rio 7= .25
 |  |  |  |  |  |  |  |  | Rio 8 =.75 |  |  |  | 10
 |  |  |  |  |  |  |  |  | Current Maximum Take
 |  |  | Position |  |  |  |  |  | Current Maximum Increase or Decrease
 |  | Local | 385 | IID | 50 |  |  |  | **PNM's total contingent = 70 with Units @ 100%
 |  | Remote | 504 | TNP | 25 |  |  |  | *based on high numbers on Manual
 |  |  |  | PNM | 50 |  |  |  | ***Station Services Approximately 6%
 |  |  |  | Load | 764 |  |  |  | When taking a unit to zero it is important to take out Station Services for that unit
 | Purchase | a. | 200 | Ace | 3 |  |  |  | Sample
 |  | b. | 0 | Sales   a. | 100 |  |  |  | RG 7 entitlement = 0.25 * 70MW * ((48-3)/50) = 15.75 or  16 MW rounded.
 |  | c. | 0 | b. | 110 |  |  |  | RG 8 entitlement = 0.75 * 70 MW * ((100-5)/150) = 33.25 or 33 MW rounded.
 |  | d. | 0 | c. | 0
 |  |  |  | d. | 0 |  |  |  | Total of 49 MW's
 |  | Total |  | Total |  | Difference
 |  |  |  |  |  |  |  |  | The unit high numbers 50 and 150 came from [NAME].
 |  |  |  |  |  |  |  |  | At the time of the contract these were the net numbers for unit 7 and 8
 |  |  |  |  |  |  |  |  | This calculation is calculated using the current high numbers for unit 7 and 8