tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 739934d1626095170-extracting-year-from-a-string-sample2
Sheet: sample

QWE1770LALFI_EC___2011M0000DEGD000P4_N | 2011
QWE1770LALFI_LQ___2019M0000DEGD000P2_N | 2019
QWE1770LALFI_LQ_CE2019M5038OIIPNFNP2_N | 2019
QWE1770LALHG______2018O0000DEGD000G2_N | 2018
QWE1770LALHG_MRTED2019M4183OIIPPNNG2_N | 2019
QWE1770LALVBGB_MRT2019M5078OIIPNFNP2_N | 2019
QWE1774LALLQ_439_C2016M5078OIIPNNNP2_N | 2016
[NAME] | 2020
QWE1770LALLQ_ELGM_2020O4421GBGIPNNP2_N | 2020
QWE1773LALTV_LQ___2010O0000ATGD000P2_N | 2010
QWE1773LALTV_LQ___2013O0000ATGD000P2_N | 2013
QWE1773LALTV_LQ_CE2019M4756OIIPPNNP2_N | 2019
QWE1773LALTV_LQ_CE2020M4756OIIPPNNP4_N | 2020
QWE1775LALKT______2017O0000FRGD000P2_N | 2017
Spreadsheet: 800334d1665603531-nested-xlookup-nestedxlookup
Sheet: Sheet1

 |  | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032
Category | Item | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10
US | A | 0.064 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037
India | B | 0.09 | 0.0538 | 0.0538 | 0.0538 | 0.0538 | 0.0538 | 0.0538 | 0.0538 | 0.0538 | 0.0538
Paris | C | 0.064 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037
France | D | 0.064 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037
Italy | E | 0.064 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037
Japan | F | 0.058 | 0.057 | 0.057 | 0.057 | 0.057 | 0.057 | 0.057 | 0.057 | 0.057 | 0.057
Dubai | G | 0.064 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037 | 0.037
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: HR

 | Human Resources
 | 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 |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other |  | 19
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  |  |  | Total |  |  |  |  | 2206762
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 30000
ENARENT | Rent |  |  |  |  |  |  | Admins |  | 1
ENATECH | Technology |  |  |  |  |  |  | Staff | 41000
ENATRANS | Transportation |  |  |  |  |  |  | Analysts |  | 1
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Associate |  | 2
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist |  | 3
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialst |  | 1
 |  |  |  |  |  |  |  | Managers |  | 4
 | Headcount |  |  | 84 |  |  |  | Directors |  | 1
 |  |  |  |  |  |  |  | General Counsel Asst
 | A&A Headcount |  |  |  |  |  |  | Vice President |  | 1
 |  |  |  |  |  |  |  | [NAME]
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 180700.52 |  | 240934.0266666666 |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 107369d1304547238-re-countifs-with-multiple-criteria-montreal_mayl_2011
Sheet: Monthly by Group

 | Interactions
WCBB
WCSE
WCLE
OCSE
WCCE
LCBE
[NAME]
RCAB
WBSE
BCBE
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 27

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  |  | 6.3
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Mon 20 Nov Glucose mmol/L
Tue 21 Nov Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Wed 22 Nov Glucose mmol/L
Thu 23 Nov Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Fri 24 Nov Glucose mmol/L
Sat 25 Nov Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sun 26 Nov Glucose mmol/L
 |  |  |  |  |  | 6.4
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Mon 27 Nov Glucose mmol/L
Spreadsheet: 161839d1339648943-sumproduct-multiple-criteria-sample-16-
Sheet: Sheet2

 |  | Name | Count | Defects | Sum of Fatal | Sum of Non Fatal | Average Error | Average Quality
 |  | ABC
 |  | DEF
 |  | GHI
 |  | JKL
 |  | MNO
 |  | PQR
 |  | STU
 |  | VW
 |  | XYZ
Spreadsheet: 829054d1683886940-update-added-data-in-rows-of-sheet1-to-sheet2-automatically-sample-3-
Sheet: Sheet2

Number | UPDATED QUESTIONS FROM SHEET 1
Spreadsheet: 1145a829-4fb9-4408-951a-ab6724c5550c
Sheet: Sheet1

Table 6--U.S. textile imports, by fiber | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Feb. | Mar. | Apr. | Apr.
Item | 2012 | 2012 | 2012 | 2011
 | 1,000 pounds 1/
[NAME], thread, and fabric: | 213268.822 | 242921.086 | 257007.501 | 242352.064
Cotton | 47266.068 | 51989.653 | 57811.868 | 56120.108
Linen | 16580.406 | 21000.697 | 19569.314 | 17319.608
Wool | 3149.176 | 3389.626 | 4281.361 | 3747.165
Silk | 603.801 | 542.11 | 617.086 | 704.867
Manmade | 145669.371 | 165999 | 174727.872 | 164460.316
Apparel: | 758790.887 | 731395.024 | 766288.216 | 803502.434
Cotton | 443759.827 | 428684.612 | 430643.195 | 484928.251
Linen | 10180.045 | 9380.834 | 10937.316 | 11272.143
Wool | 14730.791 | 15136.753 | 17084.64 | 14588.791
Silk | 8653.147 | 8615.782 | 9899.293 | 10550.025
Manmade | 281467.077 | 269577.043 | 297723.772 | 282163.224
Home furnishings: | 164412.593 | 173995.144 | 197216.507 | 175354.2
Cotton | 100501.3 | 108380.899 | 111389.632 | 107329.696
Linen | 649.515 | 630.188 | 772.843 | 555.298
Wool | 340.677 | 304.546 | 8447.64 | 182.973
Silk | 86.452 | 144.768 | 1491.392 | 135.448
Manmade | 62834.649 | 64534.743 | 75115 | 67150.785
Floor coverings: | 50710.122 | 57505.64 | 46698.066 | 60018.861
Cotton | 6144.344 | 7337.125 | 6025.162 | 6702.893
Linen | 12955.836 | 15256.777 | 14290.639 | 17097.306
Wool | 7203.939 | 9226.035 | 226.753 | 9789.779
Silk | 1571.43 | 1648.353 | 202.512 | 1335.33
Manmade | 22834.573 | 24037.35 | 25953 | 25093.553
Total imports: 2/ | 1187836.767 | 1206201.169 | 1267631.108 | 1291056.124
Cotton | 597884.075 | 596652.049 | 606140.921 | 659358.531
Linen | 40365.803 | 46268.496 | 45570.112 | 46937.072
Wool | 25433.599 | 28058.779 | 30049.913 | 28592.132
Silk | 10914.83 | 10951.013 | 12210.283 | 12725.778
Manmade | 513238.46 | 524270.832 | 573659.879 | 543442.611
1/ Raw-fiber equivalent.  2/ Includes headgear.
Last update:  07/12/12.
Sources: USDA, Economic Research Service; and USDC,
U.S. Census Bureau.
Spreadsheet: 121037d1315787616-converting-column-info-to-row-info-do-it-like-this
Sheet: Sheet1

Customer # | Equipment 1 | Equipment 2 | Equipment 3 | Equipment 4 |  |  | Customer Number | Equipment Type | helper
AM100 | Computer | Cell Phone | [NAME] |  |  |  | AM100 | Computer | AM100-1
[NAME] | Computer |  |  |  |  |  | AM100 | Cell Phone | AM100-2
AM102 | [NAME] | Cup | Computer | Remote |  |  | AM100 | [NAME] | AM100-3
AM103 | [NAME] | Cell Phone |  |  |  |  | [NAME] | Computer | AM101-1
AM104 | Cup |  |  |  |  |  | AM102 | [NAME] | AM102-1
 |  |  |  |  |  |  | AM102 | Cup | AM102-2
 |  |  |  |  |  |  | AM102 | Computer | AM102-3
 |  |  |  |  |  |  | AM102 | Remote | AM102-4
 |  |  |  |  |  |  | AM103 | [NAME] | AM103-1
 |  |  |  |  |  |  | AM103 | Cell Phone | AM103-2
 |  |  |  |  |  |  | AM104 | Cup | AM104-1
Result I need |  |  |  |  |  | Basically I have a bunch of equipment in one column and I need to match it with a customer number and cascade it in a row. Is this possible?
Customer # | Equipment 1 | Equipment 2 | Equipment 3 | Equipment 4
AM100 | Computer | Cell Phone | [NAME]
[NAME] | Computer
AM102 | [NAME] | Cup | Computer | Remote
AM103 | [NAME] | Cell Phone
AM104 | Cup
Spreadsheet: 735924d1623259579-how-to-sumif-a-box-example-sum-box
Sheet: Sheet1

 |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
 |  | Client
 |  | 1 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 3 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 3 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 3 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 3 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 3 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 3 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 4 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 4 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 4 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 4 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 4 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 4 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 5 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 5 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 5 |  |  | x | x | x | x | x | x | x | x | x | x | x | x
Spreadsheet: 70120d1270781685-workbook-to-workbook-data-entry-needed-test
Sheet: Sheet1

 | My Business Spreadsheet
 | My Invoice # | 1 | 2
 | Date | 2010-04-08 00:00:00 | 2010-04-09 00:00:00
 | Name | [NAME] | [NAME]
 | Address | Brooklyn, NY | Brooklyn, NY
 | Phone | [PHONE] | [PHONE]
1 | Description | Candle | Candle
1 | Serial # | 23 | 23
1 | Size | large | large
1 | Color | blue | blue
1 | Price | 12 | 12
1 | Quantity | 2 | 6
1 | Total | 24 | 72
2 | Description | soap | soap
2 | Serial # | na | na
2 | Size | na | na
2 | Color | white | white
2 | Price | 4 | 4
2 | Quantity | 12 | 10
2 | Total | 48 | 40
3 | Description
3 | Serial #
3 | Size
3 | Color
3 | Price
3 | Quantity
3 | Total
4 | Description
4 | Serial #
4 | Size
4 | Color
4 | Price
4 | Quantity
4 | Total
5 | Description
5 | Serial #
5 | Size
5 | Color
5 | Price
5 | Quantity
5 | Total
 | Sub Total | 72 | 112
 | Tax | 4.86 | 7.56
 | Total | 76.86 | 119.56
Spreadsheet: tracy_geaccone__40573__EA Alloc to Other BUs - Support
Sheet: Treasury

Treasury
Analysis of I/C Billings
 |  | 2001 Forecast |  |  |  |  |  | 2002 Plan
 |  | $ |  | % |  | HC |  | $ |  | % |  | HC
Total Direct Expense |  |  |  | 1 |  | 16 |  |  |  | 1 |  | 20
Allocation to other business units
EGM |  |  |  |  |  |  |  | 0
EPI |  |  |  |  |  |  |  | 0
Total
Net to ENA
Spreadsheet: 43f52aff-944c-4b1f-9842-d7c9b73ecbe0
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
DAND | Test | DAND | Dandelion, IgE | Dandelion, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
DAND | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
DAND | Result | DAND | Dandelion, IgE | Dandelion, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6097-0
Spreadsheet: 35625d1233212080-returning-multiple-results-for-one-lookup-value-multivalue-return
Sheet: PO

DATE: |  | 2009-01-29 12:23:15
 |  |  |  |  |  |  |  |  |  |  |  | Cutting | XS-XL
 | STYLE: | 2750 |  |  |  |  |  |  |  |  |  | CO: | USA
COLOR |  |  |  |  | QTY |  |  | Cost
RED PEPPER |  |  |  |  | 250 |  |  | 5.71
CAVE |  |  |  |  | ? |  |  | ?
 |  |  |  | TOTAL UNITS | 250
 |  |  |  | TYPE OF PRE-PACK | 14 ppk
NEED FORMULA TO GET THE OTHER COLORS, please note that there is more data than just the 11 rows shown.  It's about 100 rows but sorted
Spreadsheet: 845137d1696664414-generate-a-receipt-from-repeat-customer-file-hotel
Sheet: Reservations

Client | Reservation ID | Direct ou Booking | Room No. | [NAME] | Depart Date | Duration | Price per day | Price per stay | No. Adults | No. Children | Cleaning? | Towels? | Tax Rate | Total Tax | Total Price | Deposit 1 | Payment Method | Deposit 2 | Payment Method | Total Deposit | Total to be Paid
1 [NAME] | 1 | Direct | 12 | 2024-01-01 00:00:00 | 2024-01-10 00:00:00 |  |  |  | 2 | 1 | 30 | 0 | 1 |  |  | 118 | BACS
1 [NAME] | 2 | Direct | 1 | 2024-01-11 00:00:00 | 2024-01-20 00:00:00 |  |  |  | 2 | 1 | 0 | 0 | 1 |  |  | 118 | BACS
4 Karen Douglas | 1 | Direct | 10 | 2024-01-03 00:00:00 | 2024-01-18 00:00:00 |  |  |  | 4 | 0 | 0 | 15 | 1 |  |  | 400 | BACS | 100
5 [NAME] | 1 | Booking | 9 | 2024-01-03 00:00:00 | 2024-01-18 00:00:00 |  |  |  | 4 | 0 | 0 | 15 | 1 |  |  | 400 | BACS | 100
Spreadsheet: 199412d1355211811-need-help-fo-voltage-drop-calculator-in-excel-test-vd
Sheet: Sheet1

13.8
AMPS | 41.83 | 41.83 | 41.83 | 41.83 | 41.83 | 41.83 | 41.83 | 41.83 | 41.83 | 41.83 | 41.83 | 41.83
KVA | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
CABLE [NAME] | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |  | R | 0.387
LENGTH | 1 | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 |  | X | 0.355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1907.4
VOLTAGE DROP
VD IN VOLTS
TOTAL VOLTAGE AFTER DROP |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.8
Spreadsheet: 134451d1325287991-how-do-i-write-a-formula-to-tally-class-participation-copy_of_speech
Sheet: School Points

School | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
Points | 16 | 12 | 10 | 13 | 14 | 13 | 11 | 7 |  |  | VLOOKUP
 |  |  |  |  |  |  |  |  |  |  | Code | School
 |  |  |  |  |  |  |  |  |  |  | 1 | School 1
 |  |  |  |  |  |  |  |  |  |  | 2 | School 2
 |  |  |  |  |  |  |  |  |  |  | 3 | School 3
 |  |  |  |  |  |  |  |  |  |  | 4 | School 4
 |  |  |  |  |  |  |  |  |  |  | 5 | School 5
 |  |  |  |  |  |  |  |  |  |  | 6 | School 6
 |  |  |  |  |  |  |  |  |  |  | 7 | School 7
 |  |  |  |  |  |  |  |  |  |  | 8 | School 8
Spreadsheet: 20db7227-fb63-40d1-bf3d-2b123f3bdc17
Sheet: API

DistrictCountyNumber | DistrictNumber | DistrictType | DistrictName | DemographicGroup | DemographicCategory | DemographicDescription | FourYearCount_2011 | FourYearPercent_2011 | FourYearCount_2012 | FourYearPercent_2012 | Percent_Increase
19 | 0191 | 01 | BURNSVILLE PUBLIC SCHOOL DISTRICT | Ethnicity | C | Asian/Pacific Islander | 47 | 62.67 | 55 | 74.32 | 11.65
55 | 0535 | 01 | ROCHESTER PUBLIC SCHOOL DISTRICT | Ethnicity | C | Asian/Pacific Islander | 68 | 68 | 96 | 76.8 | 8.8
19 | 0196 | 01 | ROSEMOUNT-APPLE VALLEY-EAGAN | Ethnicity | C | Asian/Pacific Islander | 105 | 84 | 130 | 89.66 | 5.66
62 | 4000 | 07 | CITY ACADEMY | Ethnicity | C | Asian/Pacific Islander | 26 | 56.52 | 27 | 61.36 | 4.84
27 | 0001 | 03 | MINNEAPOLIS PUBLIC SCHOOL DIST. | Ethnicity | C | Asian/Pacific Islander | 181 | 62.41 | 209 | 67.2 | 4.79
82 | 0833 | 01 | SOUTH WASHINGTON COUNTY SCHOOL DIST | Ethnicity | C | Asian/Pacific Islander | 89 | 89.9 | 102 | 93.58 | 3.68
27 | 0281 | 01 | ROBBINSDALE PUBLIC SCHOOL DISTRICT | Ethnicity | C | Asian/Pacific Islander | 47 | 73.44 | 68 | 76.4 | 2.96
02 | 0011 | 01 | ANOKA-HENNEPIN PUBLIC SCHOOL DIST. | Ethnicity | C | Asian/Pacific Islander | 165 | 78.2 | 165 | 80.88 | 2.68
62 | 0621 | 01 | MOUNDS VIEW PUBLIC SCHOOL DISTRICT | Ethnicity | C | Asian/Pacific Islander | 59 | 89.39 | 78 | 91.76 | 2.37
70 | 0720 | 01 | SHAKOPEE PUBLIC SCHOOL DISTRICT | Ethnicity | C | Asian/Pacific Islander | 33 | 78.57 | 44 | 80 | 1.43
62 | 0625 | 01 | ST. PAUL PUBLIC SCHOOL DISTRICT | Ethnicity | C | Asian/Pacific Islander | 802 | 69.8 | 793 | 70.3 | 0.5
62 | 4103 | 07 | HMONG COLLEGE PREP ACADEMY | Ethnicity | C | Asian/Pacific Islander | 59 | 62.11 | 56 | 61.54 | -0.57
27 | 0271 | 01 | BLOOMINGTON PUBLIC SCHOOL DISTRICT | Ethnicity | C | Asian/Pacific Islander | 63 | 85.14 | 61 | 82.43 | -2.71
27 | 0279 | 01 | OSSEO PUBLIC SCHOOL DISTRICT | Ethnicity | C | Asian/Pacific Islander | 161 | 80.9 | 186 | 78.15 | -2.75
62 | 0622 | 01 | NORTH ST PAUL-MAPLEWOOD SCHOOL DIST | Ethnicity | C | Asian/Pacific Islander | 99 | 80.49 | 92 | 76.67 | -3.82
27 | 0284 | 01 | WAYZATA PUBLIC SCHOOL DISTRICT | Ethnicity | C | Asian/Pacific Islander | 76 | 92.68 | 63 | 87.5 | -5.18
62 | 0623 | 01 | ROSEVILLE PUBLIC SCHOOL DISTRICT | Ethnicity | C | Asian/Pacific Islander | 76 | 58.91 | 46 | 50.55 | -8.36
27 | 0272 | 01 | EDEN PRAIRIE PUBLIC SCHOOL DISTRICT | Ethnicity | C | Asian/Pacific Islander | 71 | 86.59 | 44 | 74.58 | -12.01
Spreadsheet: 109214d1306153735-indirect-help-777051-indirect-help
Sheet: February

February
Account Number | Account Name | Country | Total Market Value | Cash Value | % Cash
111 | Murphy | UK | 110 | 70 | 0.6363636363636364
222 | Jones | US | 300 | 200 | 0.6666666666666666
333 | Smith | SCO | 500 | 150 | 0.3
Spreadsheet: 75359d1275932977-order-horizontal-lines-by-skipping-empty-cells-example_hlines
Sheet: Sheet1

1 | RICHARD
2 |  | TOM | MIKE
3 | SANDRA | SAM | [NAME] | [NAME]
4 |  |  | PETER
5 | [NAME] | NICK |  | STEVE
6 | TEST1 | TEST2 | TEST3 | TEST4
Spreadsheet: errol_mclaughlin_jr__10032__bookentrytemplate2
Sheet: Book Data Fields

Color = required field | Note that all fields have a fixed text size
[NAME] 20 | Size 1 | Size 1 | Size 1 | [NAME] 15 | [NAME] 30, Dropdown | [NAME] 15 | Size 10 | [NAME] | Size 1 | [NAME] 15 | [NAME] 15 | Size 10 | [NAME] 128
BOOK ID | Portfolio Type Code | Book Code | Book Type Code (D, P, I, M Y) | Region Code As specified in the WHERE CLAUSE | Trading Location | Database ID ERMS or POWER or CANADA | NT user-id of Book Administrator | Commodity Code | Book Purpose (lowercase t for Trading or h for Hedging.) | Group ID (GAS or POWER) | Benchmark ID NG-NYMEX for Gas POWER for Power | Portfolio Code (POWER only) | Book Comments
Spreadsheet: benjamin_rogers__1098__ENA Peaker Plant Summaries
Sheet: Wheatland

 | PLANT LOCATION: |  | Wheatland, IN
 | Pipeline: |  | Midwestern Gas Transmission ("MGT")
 | Delivery Point: |  | Plant-Gate
 | MW Output: |  | 475 MW
 | Heat Rate: |  | 11305
 | 16 Hour Gas Flow: |  | 85,920 MMBtu/day
 | Facility Costs: |  | 1400000 | Estimated. (Paid by ENA)
 | Start Date: |  | 2000-05-01 00:00:00
 | TRANSPORTATION ARRANGEMENT:
 |  | [NAME] CONTRACT
 |  | Term: | 8 years (Apr - Oct)
 |  | Volume: | 85,920 MMBtu/d
 |  | CONTRACT - INTERRUPTIBLE
 |  | Rate:  1st 3 Bcf | 0.0708 | MMBtu/day or Maximum Tariff Rate whichever is less.
 |  | Rate:  3 to 5 Bcf | 0.0422 | MMBtu/day
 |  | Rate:  5 Bcf & up | Maximum Tariff Rate
 |  | Volume Commit: | None
 |  | Receipt Points: | MGT-Joliet & TGP-Portland
 |  | Fuel: | 0.05% on Backhaul; 1.0% on forward haul
 |  | BACK-UP CONTRACT
 |  | None in place; however, capacity release or seasonal firm can be utilized
 |  | under the terms of this deal.
 | BALANCING:
 |  | Free via OBA. Subject to tariff imbalance parameters (5% end of month;
 |  | 10% daily imbalance limit if daily variance implemented)
 |  | Allows for uneven hourly flow at plant delivery point with even 24 hour supply
 |  | subject to pipeline operating conditions.
Spreadsheet: john_griffith__15672__Book1
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.25 | 0.345 | 0.35 | 0.5063 | -0.01019999999999888
 | N | 4.35 | 0.63 | 0.66 | 0.5226 | -0.0008999999999999009
 | Q | 4.4 | 0.83 | 0.86 | 0.5305000000000004 | 0.004649999999999488
 | U | 4.45 | 1 | 1.04 | 0.5335000000000008 | -0.005399999999999405
 | V | 4.45 | 1.15 | 1.19 | 0.5484000000000008 | 0.0008999999999999009
 | X | 4.65 | 1.32 | 1.37 | 0.5487000000000011 | -0.004799999999999471
 | Z | 4.8 | 1.525 | 1.555 | 0.562600000000001 | -0.00389999999999957
 | F | 4.85 | 1.66 | 1.72 | 0.5714000000000006 | -0.00689999999999924
 | G | 4.75 | 1.72 | 1.78 | 0.5722999999999998 | 0
 | H | 4.55 | 1.58 | 1.64 | 0.5203999999999995 | -0.006599999999999273
 | J | 4.25 | 1.17 | 1.27 | 0.4031000000000002 | -0.001799999999999802
 | K | 4.15 | 1.11 | 1.22 | 0.3823999999999994 | 0.001499999999999835
 |  |  | 2001-05-11 14:49:09.510000
Spreadsheet: darrell_schoolcraft__7310__imball0201
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 152595 | 150415
2 | 151711 | 150642
3 | 130476 | 128588
4 | 157869 | 157685
5 | 153621 | 153806
6 | 157371 | 156381
7 | 161938 | 164999
8 | 162302 | 164696
9 | 107614 | 148440
10 | 147290 | 144402
11 | 154336 | 162333
12 | 158290 | 147089
13 | 161306 | 160161
14 | 157262 | 155672
15 | 156903 | 162380
16 | 152612 | 154600
17 | 156495 | 159452
18 | 150502 | 148158
19 | 154145 | 156105
20 | 155501 | 153285
21 | 157693 | 160639
22 | 154004 | 152079
23 | 151528 | 150251
24 | 161428 | 160315
25 | 157617 | 153986
26 | 152621 | 150470
27 | 150227 | 148271
28 | 157109 | 155336
29 | 153376 | 152497
30
31
2001-12-31 00:00:00 |  |  | -30210
2002-12-29 00:00:00
CBS Dollars
 |  |  | 272582