tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 703931d1605243899-cant-apportion-multi-month-costs-by-month-monthly-subtotals
Sheet: COSTINGS

CATEGORY | Role/Element | Name/Product | Day Rate | Cost | From | To | Total |  |  | Month | Employee | Software | TOTAL
Employee | Developer |  | 100 |  | 2020-01-02 00:00:00 | 2020-02-12 00:00:00 |  |  |  | 2020-01-01 00:00:00
Employee | Manager |  | 200 |  | 2020-01-03 00:00:00 | 2020-01-17 00:00:00 |  |  |  | 2020-02-01 00:00:00
Software | MS Excel |  |  | 125 | 2020-01-11 00:00:00 |  |  |  |  | 2020-03-01 00:00:00
Employee | QA |  | 125 |  | 2020-01-21 00:00:00 | 2020-04-14 00:00:00 |  |  |  | 2020-04-01 00:00:00
Employee | Analyst |  | 130 |  | 2020-02-01 00:00:00 | 2020-04-14 00:00:00 |  |  |  | 2020-05-01 00:00:00
Employee | QA |  | 125 |  | 2020-03-11 00:00:00 | 2020-04-14 00:00:00 |  |  |  | 2020-06-01 00:00:00
Employee | Developer |  | 100 |  | 2020-01-22 00:00:00 | 2020-02-12 00:00:00 |  |  |  | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00
Need formulae in [NAME] that sums costs for each month based on dates in Cols F - G and values in Col D |  |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  | S/be: |  |  |  |  |  | Made up as:
 |  |  |  |  |  |  |  |  |  | Month | Employee | Software | TOTAL |  |  |  | Jan | Feb | Mar | Apr | Total
 |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | 8375 | 125 |  |  |  | Employee | 3000 | 1200 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  |  | Employee | 3000 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  | Software | 125 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  |  | Employee | 1375 | 3625 | 3875 | 1750
 |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  |  | Employee | 0 | 3770 | 4030 | 1820
 |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00 |  |  |  |  |  | Employee | 0 | 0 | 2625 | 1750
 |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00 |  |  |  |  |  | Employee | 1000 | 1200 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 2020-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 819676d1677626721-rri-function-help-rri-example
Sheet: Sheet5

 | 818 | 1180 | 1016 | 899 | 801 | 698 | 703 | 583 | 487 | 483 | 421 | 470
 | 56 | 71 | 64 | 72 | 61 | 71 | 0 | 0 | 0 | 0 | 0 | 0
 | 602 | 605 | 535 | 860 | 763 | 725 | 780 | 727 | 0 | 0 | 0 | 0
 | 349 | 415 | 307 | 284 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 445 | 312 | 472 | 439 | 445 | 368 | 296 | 390 | 424 | 520 | 0 | 0
Spreadsheet: 53d9eeed-b095-4414-aca6-d0146f4db50e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23
 | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c | c
 | Turistas nacionales en [NAME] y Canarias, por meses. FRONTUR CANARIAS.
 | 2009-2012
 | [NAME] |  |  |  |  |  |  | PERFIL DEL CLIENTE
 |  |  |  |  |  |  |  | Por grupo de edad
 | Año 2009 |  |  |  |  |  |  | [NAME]
 | Año 2010 |  |  |  |  |  |  | Por sexo del turista
 | Año 2011 |  |  |  |  |  |  | Paquete turístico
 | Año 2012 |  |  |  |  |  |  | Tipo de alojamiento
 | Año 2013
 | Acumulado 2010
 | Acumulado 2011
 | Acumulado 2012
 | Acumulado 2013
 | Turistas nacionales, por CC.AA. e isla de destino principal 2009-2010
 | Turistas nacionales, por CC.AA. e isla de destino principal 2011
 | Turistas nacionales, por CC.AA. e isla de destino principal 2012
 | Turistas nacionales, por CC.AA. e isla de destino principal 2013
Spreadsheet: 87428d1287299993-how-to-add-leading-and-ending-zeroes-to-existing-values-sample
Sheet: Sheet1

 |  |  | after time formatting
 |  | HAVE |  | WANT
 |  | 0:04:15 | 00:04:15 | 00:04:15
 |  | 0:01:00 | 00:01:00 | 00:01:00
 |  | 1:01:18 | 01:01:18 | 01:01:18
 |  | 6:03:45 | 06:03:45 | 06:03:45
 |  | 1:29:36 | 01:29:36 | 01:29:36
 |  | 15:45:55 | 15:45:55 | 15:45:55
 |  | 0:12:23 | 00:12:23 | 00:12:23
 |  | 16:15:37 | 16:15:37 | 16:15:37
 |  | 8:18:28 | 08:18:28 | 08:18:28
 |  | 1:52:11 | 01:52:11 | 01:52:11
 |  | 00:43:08:02 | #N/A | 00:43:08:02
 |  | 2:07:55 | 02:07:55 | 02:07:55
 |  | 00:35:11:24 | #N/A | 00:35:11:24
Spreadsheet: sally_beck__35759__MgmtSum-Q1-0331-PRELIM-C
Sheet: CapChrg-AllocExp

PLAN2000
CAP_CHRG | ENRON NORTH AMERICA
TOT_ALLOCATION | 1ST QUARTER 2000 CAPITAL CHARGE & ALLOCATED EXPENSES
2000-03-01 00:00:00
M.QTD
ENA
 |  |  | Capital Charge |  |  |  |  |  |  | Allocated Expenses
 | Business Team |  | Forecast | Plan | [NAME] | Explanation |  |  |  | Forecast | Plan | [NAME] | Explanation
[NAME] | Gas Trading
[NAME] | Power Trading
IR_FX | Financial Drift
[NAME] | Financial Trading
CANADA | Canada |  | 193
COAL | Coal |  | 618
WEATHER | GRM -  Weather
SO2 | Emissions
INSURANCE | GRM - New Products |  |  |  |  |  |  |  |  | 480 |  |  | Plan only includes BA&R allocation
EXEC_TRD | Executive Trading
 | Total Trading & Risk Mgmt
E_ORG | East Midstream
W_ORIG | West Midstream |  | 892 |  |  | Big Horn investment
PAPER | Industrial Downstream - Paper |  | 285 |  |  | Merlin (City Forest, Oconto Falls) & Repap sale 2 months early
CHEMICALS | Industrial Downstream - Chemicals |  | 16 |  |  | Lower 1999 investing activity
MDSTRM_IPP_ORIG | Midstream IPP
MEXICO | Mexico
 | Total Origination
GENCOS | Genco
N_BS_DEV | Generation Investments |  | 5758 |  |  | Merlin (ECP)
ASST_ORIG | Gas Assets |  | 8582 |  |  | Hurricane delay & Nahanni credit
ASST_TRD | Gas Assets - Trading
 | Total Assets
EQUITY | Principal Investing |  | 974 |  |  | Condor (Quanta)
PROD_FIN | Energy Investments |  | 2921 |  |  | Merlin (HV Marine, LSI, Ridgelake)
ASST_MGT_AND_RESTRCT | Special Assets |  |  |  |  | Merlin (CanFibre, Heartland, Kafus Bridge) & Condor (Heartland)
CTG_ASSETS | CTG Assets |  | 3257
 | Total Investing
CTG | Commercial Transactions Group
OF_CHAIR | Office of the Chairman |  |  |  |  |  |  |  |  | 4110
 | Capital Charge Offset
 | Total Commercial
GROUP | Group
 | Total
Spreadsheet: 82272d1282256938-cant-get-regress-function-to-work-in-vba-example
Sheet: Copy From

Category | Quality Score | Either 1 or 0
Apples | 5 |  |  | Regression:  y-axis = B2:B29
Apples | 3 |  |  |  | x-axis = C2:C29
Apples | 8 |  |  |  | Want to see the degree to which apples affects the quality score
Apples | 4
Apples | 6
Apples | 2
Apples | 6
Apples | 8
Apples | 4
Apples | 5
Oranges | 6
Oranges | 3
Oranges | 1
Oranges | 8
Oranges | 9
Bananas | 7
Bananas | 8
Bananas | 0
Bananas | 3
Bananas | 1
Bananas | 2
Bananas | 3
Bananas | 6
Bananas | 4
Bananas | 6
Bananas | 2
Bananas | 2
Bananas | 3
Spreadsheet: 845684d1697095416-pulling-specific-customer-data-froma-lookup-sheet-into-another-sheet-how-to-excel-book
Sheet: RESULT SHEET

 | HOW TO LOOK UP DATA IN BELOW COLUMNS FROM DATA SHEET
 |  | A/C TITLE | A/C NUMBER | AMOUNT USD |  |  | SECURITY CODE | MATURITY DATE | ISSUE DATE
 | DEBIT | SETTLE A/C USD CERTIFICATES | [PHONE]
 |  | CUSTOMER NAME | CUSTOMER A/C # | AMOUNT TO BE CREDITED
1 | CREDIT |  |  |  |  |  | 371200-865
 | CREDIT |  |  |  |  |  | 371200-857
 | CREDIT |  |  |  |  |  | 371200-857
 | CREDIT |  |  |  |  |  | 372200-767
 | CREDIT |  |  |  |  |  | 373100-582
Spreadsheet: 777920d1650665490-conditional-formatting-when-all-rows-of-a-type-meet-a-condition-example
Sheet: Sheet1

INVOICE | STATUS
1214 | [NAME]
1214 | ORDERED
1664 | [NAME]
1664 | [NAME]
1664 | [NAME]
1664 | [NAME]
1664 | [NAME]
1684 | ORDERED
1684 | [NAME]
1684 | [NAME]
1684 | [NAME]
Spreadsheet: 761189d1640709328-searching-text-for-x-or-y-or-z-and-returning-true-or-false-excel-forum-example
Sheet: Sheet2

Customer_Name | Speed | Secondary | Primary | XGS Logic | Template Prefix | Service Template | Version
Captain [NAME] | 150 | SFFD016F |  |  |  |  |  |  |  | The formula is in E1 and I've hilighted the two rows where the information has to change to "YES"
Hawkeye | 500 | DNHA024A
Daredevil | 150 | BRLN002F
Dr Strange | 1G | NHA006G
Hulk | 150 | WHAR044E
[NAME] | 150 | BLFD005E
[NAME] | 1G | NNEW040D
Iron Man | 500 | WWND007B
Thor | 500 | NFFD109E
Black Panther | 500 | SSTN079C
Spiderman | 1G | SSTN075H
[NAME] | 150 | BRLN001F
Spreadsheet: 02057380-5a0f-4e49-b94e-e56c19e2edd6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 |  | Explore Lissajous Figures
 |  |  |  |  |  |  | vertical wave
 |  |  |  |  |  |  | [NAME]) = a1 cos( ω1t+φ )
 |  | Hi, please press [F9] ! |  |  |  |  | amplitude a1
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | smaller | larger
 |  |  |  |  |  |  | angular speed ω1
 |  |  |  |  |  |  |  | 12 | °
 |  |  |  |  |  |  | slower | faster
 |  |  | horizontal wave |  |  |  | phase shift φ
 |  |  | y(t) = a2 cos( ω2t ) |  |  |  |  | 0 | °
 |  |  | amplitude a2
 |  |  |  |  | 4 |  | curve tail length
 |  |  | smaller | larger
 |  |  | angular speed ω2 |  |  |  | shorter | longer
 |  |  |  |  | 8 | °
 |  |  | slower | faster
init= | 0 |  |  |  |  |  |  |  |  |  | This is the Lissajous figure.
t= | 0
Spreadsheet: 149191d1333737762-chart-formatting-error-sample
Sheet: February 2012 Chart

OCR Bed Loss March 2012 by Division, By Reason
[NAME] | Northeast | Northeast | Mideast | Central | Southeast | West | Total
 | Pricing  (right axis) | All other
Closed | 0 | 145 | 8 | 33 | 71 | 0 | 257
Collections | 0 | 140 | 0 | 233 | 168 | 0 | 541
JV | 0 | 0 | 246 | 0 | 359 | 0 | 605
Other | 0 | 17 | 73 | 104 | 0 | 747 | 941
Per Diem | 0 | 0 | 0 | 0 | 0 | 487 | 487
Pricing | 40 | 0 | 179 | 232 | 0 | 768 | 1219
Service | 0 | 804 | 707 | 87 | 382 | 463 | 2443
Sold/Under New Mgt. | 0 | 0 | 171 | 50 | 175 | 87 | 483
Total | 40 | 1106 | 1384 | 739 | 1155 | 2552 | 6976
Spreadsheet: 41afa2b0-e00a-49a7-82e2-6e1598faa79c
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688717025 | [NAME] | Surrounded | 2007-07-24 | Studio Series 3-Key CD Trax | Praise | 9.99 | N | To Be Retired
Word Records | 80688716929 | [NAME] | Thousand Hallelujahs, A | 2007-07-24 | Studio Series 3-Key CD Trax | Praise | 9.99 | N | To Be Retired
Word Records | 80688716820 | [NAME] | You Are | 2007-07-24 | Studio Series 3-Key CD Trax | Praise | 9.99 | N | To Be Retired
Spreadsheet: 386328d1427737200-exporting-from-sage-peachtree-quantum-book1
Sheet: 3H#22 Income Statement

xxx Company
Income Statement
For the Three Months Ending March 31, 2015
 | Current Month This Year | Current Month Last Year | Year to Date This Year | Year to Date Last Year
Revenues
SALES | 0 | 0 | 0 | 0
SALES | 0 | 0 | 0 | 0
SALES | 0 | 0 | 0 | 0
SALES | 0 | 0 | 0 | 0
Spreadsheet: 594791d1539968778-countifs-trouble-countifs
Sheet: Sheet1

N/U/C | Sales 1 | Sales 2 |  | New | Used
NEW | Smith, [NAME] |  |  | JACKS NEW SALES | JACKS USED SALES
NEW | Smith, [NAME] | Smith, [NAME] | Smith, [NAME]
NEW | Smith, [NAME] |  | [NAME]
NEW | [NAME] | Smith, [NAME] | jill
USED | JACK | [NAME]
NEW | JACK | [NAME]
NEW | [NAME] | jill
NEW | jill
NEW | jill | Smith, [NAME]
NEW
USED | Smith, [NAME] | jill
Spreadsheet: 120468d1315317632-excel-2007-creating-a-vlookup-formula-copy-of-sample-worksheet
Sheet: Carrier Data

 | SSN | Last Name | First Name | Tier | COBRA Start Date | SSN | Last Name | First Name | Tier | COBRA Start Date
 | 394095783 | WLODAWER | [NAME] | Employee Only | 2011-04-01 00:00:00
 | 294857123 | BERLAT | JESSICA | Employee Only | 2011-07-01 00:00:00
 | 876349023 | WITUCKI | STEVEN | Employee Only | 2011-07-01 00:00:00
 | 259427624 | QUEBBEMAN | RONALD | Employee + Spouse | 2011-03-01 00:00:00
Spreadsheet: 4b21f7e0-e782-435d-aab5-7e4b54907df9
Sheet: Hayward

REGIONAL DIRECTORY 2014/2015
HAYWARD UNIFIED SCHOOL DISTRICT
Dr. [NAME], [NAME] | [NAME], Assistant Superintendent Business | TBD, Director
24411 Amador Street | 24411 Amador Street | 24411 Amador Street
Hayward, CA, 94540 | Hayward, CA 94540 | Hayward, CA, 94540
O: [PHONE] x2640 | O: [PHONE] | O: [PHONE] x2506
F: [PHONE] | F: [PHONE] | c: [PHONE]
[NAME] | [NAME] | F: [PHONE]
[NAME], Director Business Services | [NAME], Fiscal Officer | [NAME], MEP Coordinator
24411 Amador Street | 24411 Amador Street | 27211 Tyrrell Avenue
Hayward, CA  94540 | Hayward, CA, 94540 | Hayward, CA, 94544
O:[PHONE] | O: [PHONE] | O: [PHONE] x30102
F:[PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | [NAME]
[NAME], [NAME] | [NAME], [NAME] | [NAME], PK Teacher (MESRP)
24411 Amador Street | 222 [NAME] Street | 222 [NAME] Street
Hayward, CA, 94540 | Hayward, CA, 94541 | Hayward, CA, 94541
O: [PHONE] x2607 | O: [PHONE] x30128 | O: [PHONE] ext. 30144
F: [PHONE] | c: [PHONE] | F: [PHONE]
[EMAIL] | F: [PHONE] | [EMAIL]
 | [EMAIL]
[NAME], PK Instructional Asst. (MESRP) | [NAME], School Community Liaison
222 [NAME] Street | 27211 Tyrrell Avenue
Hayward, CA, 94541 | Hayward, CA  94544
O: [PHONE] ext. 30144 | O: [PHONE], Ext. 38220  (am)
F: [PHONE] | O: [PHONE], Ext. 30144 (pm)
norma.lucha@@yahoo.com | F:[PHONE]
 | [EMAIL]
Spreadsheet: 112365d1308528602-summarizing-data-by-month-and-year-w-o-regard-to-day-sumif-sample
Sheet: Sheet1

 | Year | 2011
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year
 | Type 1
 | Type 2
 | Type 3
 | Type 4
 | Type 5
 | Date | Type | Count
 | 2011-01-01 00:00:00 | Type 1 | 5
 | 2011-01-03 00:00:00 | Type 1 | 8
 | 2011-01-05 00:00:00 | Type 2 | 9
 | 2011-01-06 00:00:00 | Type 3 | 10
 | 2011-01-07 00:00:00 | Type 4 | 8
 | 2011-01-08 00:00:00 | Type 5 | 7
 | 2011-02-01 00:00:00 | Type 2 | 5
 | 2011-02-03 00:00:00 | Type 3 | 4
 | 2011-03-05 00:00:00 | Type 1 | 10
Spreadsheet: 271016d1381784488-retrieve-data-from-a-mileage-matrix-mileage-matrix-example
Sheet: MILEAGE-TIME MATRIX

[NAME]
Rochester
Diversville |  |  |  |  |  | 85
 |  |  |  |  |  | 1 hr 50 min
 |  |  |  |  |  | 9.25
Fillsburgh |  |  |  |  |  | 110 |  |  | 195
 |  |  |  |  |  | 1 hr 40 min
Albany |  |  |  |  |  | 50 |  |  | 35 |  |  | 160
 |  |  |  |  |  | 50 min |  |  | 2 hr 15 min |  |  | 3 hr
 |  |  |  |  |  | 6.25 |  |  | 3.25
Shortstown |  |  |  |  |  | 180 |  |  | 165 |  |  | 290 |  |  | 130
 |  |  |  |  |  | 2 hr 40 min
LasVegas |  |  |  |  |  | 205 |  |  | 190 |  |  | 275 |  |  | 155 |  |  | 200
 |  |  |  |  |  | 2 hr 50 min |  |  | 4 hr 35 min |  |  |  |  |  | 2 hr 20 min
 |  |  |  |  |  | 2.5 |  |  | 8.65
Alantic City |  |  |  |  |  | 160 |  |  | 80 |  |  | 270 |  |  | 110 |  |  | 240
 |  |  |  |  |  | 3 hr 10 min |  |  |  |  |  |  |  |  | 3 hr 15 min
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.8
Springfield |  |  |  |  |  | 140 |  |  | 60 |  |  | 250 |  |  | 90 |  |  | 220
 |  |  |  |  |  | 2 hr 10 min
Boston |  |  |  |  |  | 275 |  |  | 190 |  |  | 385 |  |  | 225 |  |  | 365
 |  |  |  |  |  | 4 hr 5 min
Orlando |  |  |  |  |  | 210 |  |  | 245 |  |  | 320 |  |  | 210 |  |  | 145
Chicago |  |  |  |  |  | 178 |  |  | 163 |  |  | 288 |  |  | 131 |  |  | 55
 |  |  |  |  |  | 2 hr 50 min
Jennerstown |  |  |  |  |  | 145 |  |  | 125 |  |  | 250 |  |  | 90 |  |  | 40
 |  |  |  |  |  | 2 hr 25 min
Allentown |  |  |  |  |  | 205 |  |  | 190 |  |  | 275 |  |  | 155 |  |  | 200
 |  |  |  |  |  | 2 hr 50 min |  |  |  |  |  |  |  |  | 2 hr 15 min |  |  | 3 hr 20 min
Detroit |  |  |  |  |  | 235 |  |  | 260 |  |  | 205 |  |  | 225 |  |  | 270
 |  |  |  |  |  | 3 hr 45 min
Dallas |  |  |  |  |  | 110 |  |  | 135 |  |  | 220 |  |  | 100 |  |  | 230
 |  |  |  |  |  | 2 hr 15 min
Buffalo |  |  |  |  |  | 325 |  |  | 350 |  |  | 435 |  |  | 315 |  |  | 360
 |  |  |  |  |  | 5 hr
Spreadsheet: 729259d1618989933-average-from-different-sheets-in-workbook-2020-2021-pe-assessments-help
Sheet: Summary (2)

 | Autumn | Year 5 |  |  |  |  |  | Autumn | Year 5/6 |  |  |  |  |  | Autumn | Year 6
 |  | Effort | Object Control | Movement | Balance | Team Work |  |  | Effort | Object Control | Movement | Balance | Team Work |  |  | Effort | Object Control | Movement | Balance | Team Work
 | PP |  |  |  |  |  |  | PP |  |  |  |  |  |  | PP
 | Non PP |  |  |  |  |  |  | Non PP |  |  |  |  |  |  | Non PP
 | SEN |  |  |  |  |  |  | SEN |  |  |  |  |  |  | SEN
 | Non SEN |  |  |  |  |  |  | Non SEN |  |  |  |  |  |  | Non SEN
 | EAL |  |  |  |  |  |  | EAL |  |  |  |  |  |  | EAL
 | Non EAL |  |  |  |  |  |  | Non EAL |  |  |  |  |  |  | Non EAL
 | Cohort |  |  |  |  |  |  | Cohort |  |  |  |  |  |  | Cohort
 | Spring | Year 5 |  |  |  |  |  | Spring | Year 5/6 |  |  |  |  |  | Spring | Year 6
 |  | Effort | Object Control | Movement | Balance | Team Work |  |  | Effort | Object Control | Movement | Balance | Team Work |  |  | Effort | Object Control | Movement | Balance | Team Work
 | PP |  |  |  |  |  |  | PP |  |  |  |  |  |  | PP
 | Non PP |  |  |  |  |  |  | Non PP |  |  |  |  |  |  | Non PP
 | SEN |  |  |  |  |  |  | SEN |  |  |  |  |  |  | SEN
 | Non SEN |  |  |  |  |  |  | Non SEN |  |  |  |  |  |  | Non SEN
 | EAL |  |  |  |  |  |  | EAL |  |  |  |  |  |  | EAL
 | Non EAL |  |  |  |  |  |  | Non EAL |  |  |  |  |  |  | Non EAL
 | Cohort |  |  |  |  |  |  | Cohort |  |  |  |  |  |  | Cohort
 | Summer | Year 5 |  |  |  |  |  | Summer | Year 5/6 |  |  |  |  |  | Summer | Year 6
 |  | Effort | Object Control | Movement | Balance | Team Work |  |  | Effort | Object Control | Movement | Balance | Team Work |  |  | Effort | Object Control | Movement | Balance | Team Work
 | PP |  |  |  |  |  |  | PP |  |  |  |  |  |  | PP
 | Non PP |  |  |  |  |  |  | Non PP |  |  |  |  |  |  | Non PP
 | SEN |  |  |  |  |  |  | SEN |  |  |  |  |  |  | SEN
 | Non SEN |  |  |  |  |  |  | Non SEN |  |  |  |  |  |  | Non SEN
 | EAL |  |  |  |  |  |  | EAL |  |  |  |  |  |  | EAL
 | Non EAL |  |  |  |  |  |  | Non EAL |  |  |  |  |  |  | Non EAL
 | Cohort |  |  |  |  |  |  | Cohort |  |  |  |  |  |  | Cohort
Spreadsheet: 798911d1664809657-text-join-using-text-text-join-with-dates-aligw
Sheet: Sheet1

SAMPLE # | Date | Room | Description | Type | Time |  | Text Joined Cells
1 | 2022-09-30 00:00:00 | P4 | WALLS | NFCS
2 |  | P4 | DRAIN BY SINK | NFCS
3 |  | P4 | SINK | NFCS
4 |  | P4 | DRAINS | NFCS
5 |  | P4 | CURBING | NFCS
6 |  | P2 | WALLS | NFCS
7 |  | P2 | DRAINS | NFCS
8 |  | P2 | SINK | NFCS
9 |  | P2 | CURBING | NFCS
10 |  | P1 | WALLS | NFCS
11 |  | P1 | DRAIN #1 | NFCS
12 |  | P1 | DRAIN #2 | NFCS
13 |  | P1 | SINK | NFCS
14 |  | P1 | CURBING | NFCS
15 |  | P1-M6 | [NAME] | NFCS
16 |  | P1-M6 | 1ST LEG (OPERATOR SIDE) | NFCS
17 |  | P1-M6 | 2ND LEG (OPERATOR SIDE) | NFCS
18 |  | P1-M6 | 3RD LEG (OPERATOR SIDE) | NFCS
19 |  | P1-M6 | 4TH LEG (OPERATOR SIDE) | NFCS
20 |  | P1-M6 | 5TH LEG (PANEL SIDE) | NFCS
21 |  | P1 | FLOOR BY C2 DOOR | NFCS
22 |  | P1-M6 | 6TH LEG (PANEL SIDE) | NFCS
23 |  | P1-M6 | 7TH LEG (PANEL SIDE) | NFCS
24 |  | P1-M6 | 8TH LEG (PANEL SIDE) | NFCS
25 |  | P1-M6 | MULTI-VAC RAIL LEFT | FCS
26 |  | P1-M6 | MULTI-VAC RAIL RIGHT | FCS
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Spreadsheet: 55978d1256133136-excel-2007-excel-2007-chart-data-table-total-row-excel-2007-chart-problem
Sheet: Example

 | 2008-12-08 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00
Manager A | 10000000 | 11000000 | 12000000
Manager B | 15000000 | 16000000 | 25000000
Manager C | 45000000 | 40000000 | 48000000
Manager D | 2000000
Manager E | 35000000 | 36000000 | 37000000
Manager F |  | 10000000 | 12000000
Total | 107000000 | 113000000 | 134000000
Spreadsheet: phillip_m_love__30152__9905_OA
Sheet: TX-CON-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / HPL
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-South Texas
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 845002d1696580678-copy-date-in-transpose-format-horozontal-data-copy
Sheet: Sheet1

 | ID | Item |  |  |  | Output
 | 1 | Television
 | 1 | Home Theater |  |  | 1 | Television | Home Theater | Television | Cell Phone | Television | Home Theater | Television
 | 1 | Television |  |  | 2 | Television | Television | Home Theater
 | 1 | Cell Phone |  |  | 3 | Television | Home Theater
 | 1 | Television |  |  | 4 | Home Theater | Television | Desk | Video Games
 | 1 | Home Theater |  |  | 5 | Home Theater | Cell Phone | Cell Phone | Video Games
 | 1 | Television
 | 2 | Television
 | 2 | Television |  |  |  |  | Home Theater | Television | Cell Phone | Television | Home Theater | Television
 | 2 | Home Theater |  |  | 2 |  | Television | Home Theater
 | 3 | Television |  |  | 3 |  | Home Theater
 | 3 | Home Theater |  |  | 4 |  | Television | Desk | Video Games
 | 4 | Home Theater |  |  | 5 |  | Cell Phone | Cell Phone | Video Games
 | 4 | Television
 | 4 | Desk
 | 4 | Video Games
 | 5 | Home Theater
 | 5 | Cell Phone
 | 5 | Cell Phone
 | 5 | Video Games