tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 860398d1708510853-re-arrange-of-row-depend-on-no-of-task-rearrange-row-with-space-glenn
Sheet: Reposition

Person | Task (Eash person may have different number of tasks) |  |  | Person | task |  | Desire result
A | task 1;task 2;task 3;task 4;task 5 |  | 1 | A | Task 1 |  | Want to rearrange the column A & B to Column E & F. The no. of task may change, In column F expend each task depend on column B.
B | task 1;task 2;task 3;task 4;task 5;task 6;task 7 |  | 2 |  | Task 2
C | task 1;task 2;task 3;task 4;task 5;task 6;task 7;task 8 |  | 3 |  | Task 3
D | task 1;task 2;task 3;task 4 |  | 4 |  | Task 4
E | task 1;task 2;task 3;task 4;task 5;task 6 |  | 5 |  | Task 5
F | task 1;task 2;task 3;task 4;task 5;task 6;task 7 |  | 6 | B | Task 1
G | task 1;task 2;task 3;task 4 |  | 7 |  | Task 2
H | task 1;task 2;task 3;task 4;task 5;task 6 |  | 8 |  | Task 3
I | task 1;task 2;task 3;task 4;task 5;task 6;task 7 |  | 9 |  | Task 4
J | task 1;task 2;task 3;task 4 |  | 10 |  | Task 5
K | task 1;task 2;task 3;task 4;task 5;task 6 |  | 11 |  | Task 6
L | task 1;task 2;task 3;task 4;task 5;task 6;task 7;task 8 |  | 12 |  | Task 7
 |  |  | 13 | C | Task 1
 |  |  | 14 |  | Task 2
 |  |  | 15 |  | Task 3
 |  |  | 16 |  | Task 4
 |  |  | 17 |  | Task 5
 |  |  | 18 |  | Task 6
 |  |  | 19 |  | Task 7
 |  |  | 20 |  | Task 8
 |  |  | 21 | D | Task 1
 |  |  | 22 |  | Task 2
 |  |  | 23 |  | Task 3
 |  |  | 24 |  | Task 4
 |  |  | 25 | E | Task 1
 |  |  | 26 |  | Task 2
 |  |  | 27 |  | Task 3
 |  |  | 28 |  | Task 4
 |  |  | 29 |  | Task 5
 |  |  | 30 |  | Task 6
 |  |  | 31 | F | Task 1
 |  |  | 32 |  | Task 2
 |  |  | 33 |  | Task 3
 |  |  | 34 |  | Task 4
 |  |  | 35 |  | Task 5
 |  |  | 36 |  | Task 6
 |  |  | 37 |  | Task 7
 |  |  | 38 | G | Task 1
 |  |  | 39 |  | Task 2
 |  |  | 40 |  | Task 3
 |  |  | 41 |  | Task 4
 |  |  | 42 | H | Task 1
 |  |  | 43 |  | Task 2
 |  |  | 44 |  | Task 3
 |  |  | 45 |  | Task 4
 |  |  | 46 |  | Task 5
 |  |  | 47 |  | Task 6
 |  |  | 48 | I | Task 1
 |  |  | 49 |  | Task 2
 |  |  | 50 |  | Task 3
 |  |  | 51 |  | Task 4
 |  |  | 52 |  | Task 5
 |  |  | 53 |  | Task 6
 |  |  | 54 |  | Task 7
 |  |  | 55 | J | Task 1
 |  |  | 56 |  | Task 2
 |  |  | 57 |  | Task 3
 |  |  | 58 |  | Task 4
 |  |  | 59 | K | Task 1
 |  |  | 60 |  | Task 2
 |  |  | 61 |  | Task 3
 |  |  | 62 |  | Task 4
 |  |  | 63 |  | Task 5
 |  |  | 64 |  | Task 6
 |  |  | 65 | L | Task 1
 |  |  | 66 |  | Task 2
 |  |  | 67 |  | Task 3
 |  |  | 68 |  | Task 4
 |  |  | 69 |  | Task 5
 |  |  | 70 |  | Task 6
 |  |  | 71 |  | Task 7
 |  |  | 72 |  | Task 8
 |  |  | 73
 |  |  | 74
 |  |  | 75
 |  |  | 76
 |  |  | 77
 |  |  | 78
 |  |  | 79
 |  |  | 80
 |  |  | 81
 |  |  | 82
 |  |  | 83
 |  |  | 84
 |  |  | 85
 |  |  | 86
 |  |  | 87
 |  |  | 88
 |  |  | 89
 |  |  | 90
Spreadsheet: 6248d26f-b4de-4736-b3b4-b70fb9458313
Sheet: Sheet1

Princeton Physics Department Requisition | 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 | Princeton Phyiscs Department Requisition
All Orders Over $5,000.00 require either [NAME] or 3 Competitive Bids/Quotes
All Combined Orders Over $5,000.00, if on a xxx-4xxx or xxx-6xxx account, also require a completed EARF form with Physics Grant Department approval
Vendor Information | NAME |  |  |  |  |  |  |  | Requesterr Information | Requestor |  |  |  |  | Date
 | STREET |  |  |  |  |  |  |  |  | Phone |  |  |  |  | [NAME]
 | CITY |  |  | STATE |  | ZIP |  |  |  | *Principal Investigator
 | Ship via |  |  | Website |  |  |  |  |  | *Description of Equipment
 | Quoter |  |  | PHONE # |  |  |  |  |  | *Purpose of Equipment
 |  |  |  |  |  |  |  |  |  | Comments
 | [NAME] |  |  |  |  |  |  |  |  | Is Receipt Inspection Required? |  |  |  | Yes |  | No
*DELIVERY LOCATION:
*THESE ITEMS ARE REQUIRED TO PROCESS THIS REQUEST.
QTY | CATALOGUE # |  | [NAME] |  |  |  |  |  |  |  |  |  | PROJECT GRANT # |  | UNIT PRICE | TOTAL COST
8.20.2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL $
EQUIPMENT REQUEST APPROVAL FORM (EARF)
SOLE SOURCE JUSTIFICATION FORM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Spreadsheet: benjamin_rogers__1264__NewCo-7-15-00
Sheet: Devel_Schedule

 | NewCo Development - Project Schedule
 | Turbine Delivered |  |  | Turbine Used
 | Year | [NAME] |  | Project | Turbine used
 | 2000 | 1 |  | Doswell CT | 1
 | 2001 | 5 |  | [NAME] | 3
 | 2002 | 14 |  | Pecan | 2
 | 2003 | 12 |  | IDC | 3
 | 2004 | 12 |  | Phili | 3
 | Total |  |  | [NAME] | 2
 |  |  |  | Hope | 2
 |  |  |  | Total
 | Development Schedule
 |  | 2001 | 2002 | 2003 | 2004 | 2005
 | Wind | 485
 | Doswell CT | 170
 | Moore | 453
 | [NAME] |  | 750
 | Pecan |  | 250
 | [NAME] |  | 220
 | Hope |  | 500
 | IDC |  |  | 500
 | Phili |  |  | 750
 | [NAME] |  |  | 500
 | Pastoria |  |  | 750 |  |  |  | Total
 | Projects
 | Turbine | 0 | 0 | 1750 | 3000 | 3000
 | Total MW by 2005
 | Development
 | ENA | 3094
 | FPLE
 | Total
Spreadsheet: 872582d1718958763-dashboard-with-tables-linking-to-specific-person-hr-dashboard-anon
Sheet: Data

Absences
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  | January | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 |  |  | January
 |  | February | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 |  |  | February
 |  | March | 0 | 0 | 2 | 0 | 0 | 1 | 1 | 1 | 1 | 0 |  |  | March
 |  | April | 1 | 0 | 2 | 0 | 0 | 0 | 1 | 1 | 0 | 1 |  |  | April
 |  | May | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 |  |  | May
 |  | June | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 |  |  | June
 |  | July | 5 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 2 |  |  | July
 |  | August | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 |  |  | August
 |  | September | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 |  |  | September
 |  | October | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 |  |  | October
 |  | November | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 |  |  | November
 |  | December | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 |  |  | December
 |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 0ccbfd08-570f-4dba-9469-c80d6872e4a6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Risk Parity II MV Fund
 | [NAME]
 | Inception Date | 2012-11-05 00:00:00
 |  |  |  | 60/40
 |  |  |  | Blended
 |  | Class I | Class N | S&P / Barc
 | Date | QRMIX | QRMNX | Custom Index
** | 2012-11-30 00:00:00 | 0.01500000000000012 | 0.01500000000000012 | 0.001828994995952371
 | 2012-12-31 00:00:00 | 0.0026150309460653 | 0.001970443349753603 | 0.005037693446102942
 | 2013-01-31 00:00:00 | 0.02066929133858264 | 0.01966568338249752 | 0.02801006894224467
 | 2013-02-28 00:00:00 | -0.0009643201542912649 | -0.0009643201542911539 | 0.01032291530777552
 | 2013-03-31 00:00:00 | 0.0212355212355213 | 0.0212355212355213 | 0.02273670456072008
 | 2013-04-30 00:00:00 | 0 | 0 | 0.01583695293272869
 | 2013-05-31 00:00:00 | -0.035 | -0.0359 | 0.00685636198123496
 | 2013-06-30 00:00:00 | -0.06758080313418224 | -0.0676470588235294 | -0.01402606676892149
 | 2013-07-31 00:00:00 | 0.02100840336134469 | 0.02208201892744488 | 0.0308725677342685
 | 2013-08-31 00:00:00 | -0.005144032921810759 | -0.006172839506172867 | -0.0193464938695751
 | 2013-09-30 00:00:00 | 0.0237849018 | 0.0227743271 | 0.02262840795755561
 | 2013-10-31 00:00:00 | 0.0242424242 | 0.024291498 | 0.03081525070913016
 | 2013-11-30 00:00:00 | -0.0009861932938856066 | -0.0009881422924901129 | 0.01674754374759413
 | 2013-12-31 00:00:00 | -0.010305906 | -0.010326287 | 0.01291297287858573
 | 2014-01-31 00:00:00 | 0.0009990009990010762 | 0 | -0.01493082791052591
 | 2014-02-28 00:00:00 | 0.03692614770459 | 0.03703703703704 | 0.02956716534582782
 | 2014-03-31 00:00:00 | -0.005774783446 | -0.005791505792 | 0.004494505097759838
 | * annualized for periods 1 year or greater
 | ** partial month return, inception date 11/5/2012
 | Risk Parity II MV Fund
 | [NAME]
 |  |  |  | 60/40
 |  |  |  | Blended
 | Month-end Returns as of | Class I | Class N | S&P / Barc
 | March 31, 2014 | QRMIX | QRMNX | Custom Index
 | 1 Year | -0.02210775927888298 | -0.02494467266854583 | 0.1275361062399001
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.03629454797546394 | 0.0316085363166787 | 0.2059458826859579
 | Since Inception Annualized Return | 0.02579230783561881 | 0.02247693361990954 | 0.143118621115121
* | Since Inception Annualized Monthly Volatility | 0.08629769559817241 | 0.08661858026196519 | 0.05581173792570589
 | Since Inception [NAME] | 0.2894674161258141 | 0.2501195087841793
 |  |  |  | 60/40
 |  |  |  | Blended
 | Quarter-end Returns as of | Class I | Class N | S&P / Barc
 | March 31, 2014 | QRMIX | QRMNX | Custom Index
 | 1 Year | -0.02210775927888298 | -0.02494467266854583 | 0.1275361062399001
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.03629454797546394 | 0.0316085363166787 | 0.2059458826859579
 | Since Inception Annualized Return | 0.02579230783561881 | 0.02247693361990954 | 0.143118621115121
Spreadsheet: theresa_staab__39637__Enron Statement_1001
Sheet: Enron Imbalance

 |  | Imbalance Statement |  |  | To:
 |  | Date: | 2001-11-14 00:00:00 | Crestone Gathering Services, [NAME] | Enron North America
 |  |  |  | 1400 16th Street | 1200 17th Street, [NAME] 2750
 |  |  |  | Suite 310 | Denver, CO  80202
 |  |  |  | Denver, CO  80202
 |  |  |  | Contact:  [NAME] | Contact:  [NAME]
 |  |  |  | Tel: (720) 946-3692 | Tel:  (303) 575-6465
 |  |  |  | Fax: (720) 946-3640 | Fax: (303) 534-0552
Crestone Gathering Services, L.L.C.
Contract # | PR-G-999
Delivery | Net Receipts | Deliveries | Prior Month | Current Month | Cumulative
Month | MMBtu | MMBtu | Adjustments | Imbalance | Imbalance
 |  |  |  |  | -3395
2001-01-01 00:00:00 | 1863469 | 1865719 |  | 2250 | -1145
2001-02-01 00:00:00 | 1805653 | 1813702 |  | 8049 | 6904
2001-03-01 00:00:00 | 2165432.412555468 | 2145758.893983581 |  | -19673.51857188717 | -12769.51857188717
2001-04-01 00:00:00 | 1799306 | 1814576.664621893 |  | 15270.66462189262 | 2501.146050005453
2001-05-01 00:00:00 | 1865355 | 1902183 |  | 36828 | 39329.14605000545
2001-06-01 00:00:00 | 1928972 | 1922877 |  | -6095 | 33234.14605000545
2001-07-01 00:00:00 | 2048450 | 2050050 |  | 1600 | 34834.14605000545
2001-08-01 00:00:00 | 2059534 | 2048268 |  | -11266 | 23568.14605000545
2001-09-01 00:00:00 | 1884328 | 1864923 |  | -19405 | 4163.146050005453
2001-10-01 00:00:00 | 1997145.432175079 | 1986907.09163754 |  | -10238.34053753875 | -6075.194487533299
* positive balance =  gas due Crestone Gathering Services, L.L.C.
* negative balance = gas owed by Crestone Gathering Services, L.L.C.
________________ | Agree
________________ | Disagree, we show _________________________________ imbalance ([NAME])
 | Signed
 | Title
 | Phone
 | Date
Spreadsheet: 104293d1301934474-excel-2007-transfer-only-data-with-a-value-book2
Sheet: Data

Materials Required
Item Description |  | Qty. |  | Unit |  | Total
 |  |  |  | Price |  | Price/Row
interior framing | 2x4x8 | 15 | pcs. | 2.99 | /pc.
framing | 1x2x8 | 0 | pcs. | 1.99 | /pc.
exterior framing | 2x6x10 | 200 | pcs. | 10.99 | /pc.
framing | 2x8x10 | 0 | pcs. | 12.99 | /pc.
framing | 2x12x10 | 1 | pcs. | 14.99 | /pc.
 |  | 0 | pcs. | 0 | /pc.
 |  |  | gal. | 9 | gal.
 |  | 0 | pcs. | 0 | /pc.
 |  | 0 | pcs. | 0 | /pc.
 |  | 0 | pcs. | 0 | /pc.
Spreadsheet: 40793d1239196260-vlookup-returning-multiple-values-comes-unstuck-with-duplicates-lookup
Sheet: data

name | client | Item-1 | Item-2 | Item-3
[NAME] | abc | 1234 | 987 | 1475
[NAME] | def | 7865 | 1200 | 1890
mary | ghi | 14496 | 1413 | 2305
[NAME] | jkl | 21127 | 1626 | 2720
[NAME] | mno | 27758 | 1839 | 3135
mary | pqr | 34389 | 2052 | 3550
[NAME] | [NAME] | 41020 | 2265 | 3965
[NAME] | vxc | 47651 | 2478 | 4380
[NAME] | dfr | 54282 | 2691 | 4795
mary | tgh | 60913 | 2904 | 5210
[NAME] | jkl | 67544 | 3117 | 5625
[NAME] | poi | 74175 | 3330 | 6040
mary | yyy | 80806 | 3543 | 6455
[NAME] | ttt | 87437 | 3756 | 6870
[NAME] | abc | 94068 | 3969 | 7285
[NAME] | def | 100699 | 4182 | 7700
Spreadsheet: 717266d1612545791-help-in-calculation-and-filter-help-in-calculation
Sheet: Data

Site | Date | Month | Year | Totalbatches | TotalRejection
Texas | 2019-12-01 00:00:00 | 12 | 2019 | 4 | 0
Boston | 2019-12-01 00:00:00 | 12 | 2019 | 5 | 4
Chicago | 2019-12-01 00:00:00 | 12 | 2019 | 6 | 0
New Jersey | 2019-12-01 00:00:00 | 12 | 2019 | 1 | 4
Chicago | 2020-01-01 00:00:00 | 1 | 2020 | 90 | 7
New Jersey | 2020-01-01 00:00:00 | 1 | 2020 | 6 | 5
New York | 2020-01-01 00:00:00 | 1 | 2020 | 0 | 3
Philadelphia | 2020-02-01 00:00:00 | 2 | 2020 | 10 | 0
Maryland | 2020-02-01 00:00:00 | 2 | 2020 | 15 | 2
Delawar | 2020-03-01 00:00:00 | 3 | 2020 | 30 | 0
Texas | 2020-03-01 00:00:00 | 3 | 2020 | 4 | 0
Boston | 2020-04-01 00:00:00 | 4 | 2020 | 3 | 0
Chicago | 2020-04-01 00:00:00 | 4 | 2020 | 7 | 2
New Jersey | 2020-05-01 00:00:00 | 5 | 2020 | 8 | 3
New York | 2020-05-01 00:00:00 | 5 | 2020 | 30 | 1
Philadelphia | 2020-06-01 00:00:00 | 6 | 2020 | 15 | 5
Ohio | 2020-06-01 00:00:00 | 6 | 2020 | 2 | 0
Maryland | 2020-06-01 00:00:00 | 6 | 2020 | 7 | 2
Delawar | 2020-07-01 00:00:00 | 7 | 2020 | 5 | 0
Texas | 2020-07-01 00:00:00 | 7 | 2020 | 4 | 0
Boston | 2020-08-01 00:00:00 | 8 | 2020 | 3 | 0
Chicago | 2020-08-01 00:00:00 | 8 | 2020 | 7 | 2
New Jersey | 2020-09-01 00:00:00 | 9 | 2020 | 8 | 3
New York | 2020-09-01 00:00:00 | 9 | 2020 | 2 | 1
Philadelphia | 2020-09-01 00:00:00 | 9 | 2020 | 5 | 5
Ohio | 2020-10-01 00:00:00 | 10 | 2020 | 10 | 0
Maryland | 2020-10-01 00:00:00 | 10 | 2020 | 15 | 2
Delawar | 2020-11-01 00:00:00 | 11 | 2020 | 5 | 0
Texas | 2020-11-01 00:00:00 | 11 | 2020 | 4 | 0
Boston | 2020-12-01 00:00:00 | 12 | 2020 | 3 | 0
Chicago | 2020-12-01 00:00:00 | 12 | 2020 | 7 | 2
New Jersey | 2020-12-01 00:00:00 | 12 | 2020 | 8 | 3
New York | 2020-12-01 00:00:00 | 12 | 2020 | 3 | 1
Philadelphia | 2020-12-01 00:00:00 | 12 | 2020 | 1 | 5
Spreadsheet: 10688e21-50c7-42b3-9f2f-b7d2c537a667
Sheet: Capstone

 | CAPSTONE |  | COURSES IN RED  ARE FALL 2012 |  | PURPLE  J-TERM |  | GREEN  BOTH FALL  & J-TERM
ASTU | ASTU 401
BIOL | BIOL 400 |  |  |  | HIST | HIST 401
 | BIOL 487-488
 | BIOL 496-498 |  |  |  | INST | INST 422
 |  |  |  |  |  | INST 448-449
CHEM | CHEM 400 |  |  |  |  | INST 452-453
 | CHEM 401 |  |  |  |  | INST 483-484
 | CHEM 442L |  |  |  |  | INST 493-494
 | CHEM 495 |  |  |  |  | INST 496-498
 | CHEM 496-498
CLAS | CLAS 401 |  |  |  | MATH | MATH 415
COMM | COMM 381 |  | Spring 2011 only
 | COMM 490
 |  |  |  |  | PHIL | PHIL 401
CSCI | CSCI 401
 | [NAME]
 | CSCI 485-486 |  |  |  | PHYS | PHYS 496-498
 |  |  |  |  |  | PHYS 499
ECON | ECON 440 |  | Economics & Economics/Business majors |  | PSCI | PSCI 401
& | ECON 450-451 |  | Economics, Econ/Business & Accounting majors
ECON- | ECON 455 |  | Economics, Econ/Business & Accounting majors |  | PSYC | PSYC 433
BUSN | ECON 491-492 |  | Economics & Economics/Business majors
& | ECON 496-498 |  | Economics & Economics/Business majors |  | RELS | RELS 401
ACCT | BUSN 425 |  | Accounting & Economics/Business majors
 | BUSN 450-451 |  | Accounting & Economics/Business majors |  | SOCI | SOCI 400
 | BUSN 452 |  | Accounting & Economics/Business majors |  |  | SOCI 410
 | BUSN 455 |  | Accounting & Economics/Business majors |  |  | SOCI 420
 | BUSN 491-492 |  | Accounting & Economics/Business majors |  |  | SOCI 430
 | BUSN 496-498 |  | Accounting & Economics/Business majors |  |  | SOCI 440
 |  |  |  |  |  | SOCI 450
EDUC | EDUC 426 |  |  |  |  | SOCI 451
 |  |  |  |  |  | SOCI 455
ENGL | ENGL 495 |  |  |  |  | SOCI 460
 |  |  |  |  |  | SOCI 496-498
EVST | EVST 405
 |  |  |  |  | SPAN | SPAN 452
FINA | FINA 481 |  | Arts capstone course |  |  | SPAN 453
 |  |  |  |  |  | SPAN 456
 |  |  |  |  |  | SPAN 458
FREN | FREN 435 |  |  |  |  | SPAN 462
 | FREN 437 |  |  |  |  | SPAN 464
 | FREN 443 |  |  |  |  | SPAN 467
 | FREN 445 |  |  |  |  | SPAN 495
 | FREN 447
 | FREN 495 |  |  |  | WMST | WMST 300 & 301
 |  |  |  |  |  | WMST 300 & 450
GERM | GERM 495 |  |  |  |  | WMST 300 & 455
Spreadsheet: 79920d1280176109-lookup-data-and-show-charted-by-month-sample-finished-
Sheet: DISPLAY SHEET

 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
Document title | MONTH REVIEW DUE
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
ABC123 |  |  | x
DEF456 |  | x
GHI789 |  |  |  | x
JKL123 |  |  | x
MNO456 |  |  |  |  |  | x
Name 6 |  |  |  |  |  |  |  |  |  |  |  | x
Name 7 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 8 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 9 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 10 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 11 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 12 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 13 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 14 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 15 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 16 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 17 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 18 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 19 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 20 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 21 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 22 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 23 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 24 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 25 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 26 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 27 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 28 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 29 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 30 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 31 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 32 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Name 33 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: tracy_geaccone__40591__CF_GPG_CONS
Sheet: AprYTD

Enron Gas Pipeline Group
Statement of Consolidated Cash Flows
For the 4 months ended April 30, 2000
 | CONSOLIDATED |  |  |  |  |  |  | HPLO | HPL | LRC | LIQUIDS | GATHER | LIQUIDS | SERVICE |  |  | TOTAL
(In Thousands) | GPG & EOTT |  | GPG | NNG | TW | EC | NP | 543 | 584 | 583 | DOMESTIC |  | GROUP | COS | OTHER |  | EOTT
Operating Cash Inflows (Outflows)
Net income before financing costs
Financing costs
NI after financing costs (excluding cons subs equity earn)
Depreciation, depletion and amortization
Deferred income taxes
Gains on sales of assets and investments
Dividends on pref securities of subsidiary cos.
Equity earnings
Equity/partnership distributions |  |  |  | 833 |  |  | 816
Other, net |  |  |  |  |  | 0 |  |  | 4 | -1 | 1137 |  |  | -3852 | -39
Funds Flow
Changes in components of working capital
Receivables |  |  |  | 30958 | -466 |  | -102 | 10 | -644 | 250 | 26 |  |  | -3384 | -23
A/R, A/P - Intercompany |  |  |  | 181 | -4884 |  |  | -10 | 1558 | -601 | 28 |  |  | 4065 | 184
Inventories |  |  |  | 25 | 115 |  |  |  |  |  | 173
Prepayments |  |  |  | 0 | 3
Payables |  |  |  | -12883 | 1035 |  | -92 |  | -1138 | -2 | -110 |  |  | -5476 | -88
Exchange Rec/Payable |  |  |  | -2906 | -819
Accrued taxes |  |  |  | 4488 | -946 |  |  |  | -2 | -1 | -1262 | -2735 |  | 0
Accrued interest |  |  |  | 6438 | -1246
Other working capital |  |  |  | -7433 | -234 |  | -710 |  |  | -1 | 3 |  |  | -2286
Total changes in components of working capital
Net Cash Provided by Operating Activities
Investing Cash Inflows (Outflows)
Proceeds from sale of assets and investments |  |  |  | 7293
Capital Expenditures |  |  |  | -9137 | -7452
Underground Storage,Salvage & Removal Costs
EOTT Revolver and API's
Other investing activities - intercompany
Other investing activities, net |  |  |  | -1839
Net Cash Provided by Investing Activities
Cash Flows From Financing Activities
Net increase (decrease) in short-term borrowings
Issuance of long-term debt |  |  |  | 0 | 150000
Repayment of long-term debt |  |  |  |  | -100000
Other financing activities - I/C
Other financing activities, net
Net Cash Provided by Financing Activities
INC (DEC) IN CASH & CASH EQUIV, I/C CASH FROM CORP
INC (DEC) IN CASH & CASH EQUIV |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
INC (DEC) INTERCOMPANY CASH FROM CORPORATE
Change in other obligations |  |  |  | -26 | -50000 | 0 | 0 | 173 | -436 | 262 | 0 | 0 |  | 0 | 0 |  | 0
Change in total obligations
Spreadsheet: 863993d1711370598-can-i-use-2-countifs-in-one-excel-row-excel-question
Sheet: Sheet3

Row Labels | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan2 | Feb2
Customer 1 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 75
Customer 2 | 0 | 25 | 0 | 0 | 10 | 0 | 0 | 0 | 60 | 0 | 0 | 0 | 0
Customer 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 75
Grand Total | 0 | 25 | 0 | 0 | 10 | 50 | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 150
Spreadsheet: 871740d1718169062-transposing-year-in-excel-book6-2-
Sheet: Sheet1

 | Existing format
 | YEAR | 2.018,00 | 2.019,00 | 2.020,00 | 2.021,00 | 2.022,00
 | [NAME] | AGE | AGE | AGE | AGE | AGE
 | AB DYNAMICS PLC | 5.564383561643836 | 6.564383561643836 | 7.567123287671233 | 8.567123287671233 | 9.567123287671233
 | Required format
 | [NAME] | YEAR | AGE |  | [NAME] | YEAR | AGE
 | AB DYNAMICS PLC | 2018 | 6 |  | AB DYNAMICS PLC | 2018 | 6
 | AB DYNAMICS PLC | 2019 | 7 |  | AB DYNAMICS PLC | 2019 | 7
 | AB DYNAMICS PLC | 2020 | 8 |  | AB DYNAMICS PLC | 2020 | 8
 | AB DYNAMICS PLC | 2021 | 9 |  | AB DYNAMICS PLC | 2021 | 9
 | AB DYNAMICS PLC | 2022 | 10 |  | AB DYNAMICS PLC | 2022 | 10