tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 109892d1306710424-monthly-rollup-of-data-5-28-11
Sheet: GWG(DO NOT ENTER INFO)

DATE | P |  |  |  |  |  | PLANT
 | L | Propane | Propane | Butane | Butane | Sulfur | Sulfur | Gasoline | Condensate | Inlet | Plant | Mobile | Acid | Inlet |  | N2 | High | Field
 | A | Prod. | Delivered | Prod. | Delivered | Prod. | [NAME] | Prod. | Sales | Gas | Inj. Discharge | Sales Gas | Gas | Sulfur | Dupont | Vent | Press. Fuel | Fuel | Flare | Shrinkage | GWG
 | N | (gals) | (bbls) | (gals) | (bbls) | (L-ton) | (L-ton) | (gals) | (bbls) | (mcfd) | (mcfd) | (mcfd) | (mcfd) | (ltpd) | (lb/hr) | (mcfd) | (mcfd) | (mcfd) | (mcfd)
 | 130282
2011-05-28 00:00:00 |  | 12391 | 1998 | 8858 | 0 | 0 | 0 | 8274 | 0 | 18350 | 5794 | 5679 | 380 | 0 | 0 | 1301 | 1951 | 286 | 185 | 938.844124 | 9133.844124
 | O
 | N
 |  |  |  |  |  |  |  |  |  |  |  | 5679 |  |  |  | 1301 | 1951
Spreadsheet: 94115d1293973095-search-for-string-in-worksheet-s-and-return-results-in-sequential-order-sample-workbook-2-
Sheet: Facilties

Status | Name | ID | Hire Date | ACTIVE
Active | [NAME] | 58.88855863405411 | 2001-05-13 00:00:00 | 4
Inactive | [NAME] | 280.8997048636497 | 1999-02-07 00:00:00
Active | [NAME] | 732.5559100162666 | 2006-05-30 00:00:00 | 5
Active | [NAME] | 943.6884675896359 | 1997-07-18 00:00:00 | 6
Inactive | [NAME] | 358.1255816510792 | 1984-11-03 00:00:00
Inactive | [NAME] | 817.0125171234417 | 2009-04-30 00:00:00
Inactive | [NAME] | 823.3920114019417 | 2002-01-06 00:00:00
Spreadsheet: 122779d1317143959-excel-2007-summing-a-column-based-on-multiple-criteria-in-2-other-columns-example
Sheet: Summary

Owner | AA
Hardware | 16
Software | 17
Lease | 45
Total
Owner | BB
Hardware | 22
Software | 8
Lease | 0
Total | 30
Owner | CC
Hardware | 14
Software | 16
Lease | 15
Total
Owner | DD
Hardware | 0
Software | 16
Lease | 3
Total
Owner | Total
Hardware
Software
Lease
Total
Spreadsheet: 298351d1392762738-2010-excel-why-does-format-to-text-not-work-at-least-not-as-expected-testexcelforum
Sheet: Sheet1

1799760 | 1799760
1667638 | 1667638
1797451 | 1797451
1791264 | 1791264
1800806 | 1800806
1667657 | 1667657
1667657 | 1667657
1667657 | 1667657
1667672 | 1667672
1667657 | 1667657
1667657 | 1667657
1667664 | 1667664
1667679 | 1667679
1667676 | 1667676
1803575 | 1803575
Spreadsheet: john_arnold__15462__autotrader2
Sheet: Sheet3

 |  |  |  |  |  |  | Long/Short = [NAME] larger than specified desired
 |  |  |  |  |  |  | Case | Buy Side Outcome | Sell Side Outcome
 |  |  |  |  |  |  | Long and Price above WAB | Accelerate | Normal
 |  |  |  |  |  |  | Long and Price below WAB | Accelerate | Accelerate
 |  |  |  |  |  |  | Short and Price above WAS | Accelerate | Accelerate
 |  |  |  |  |  |  | Short and Price below WAS | Normal | Accelerate
 |  |  |  |  |  |  | Long/Short not outside limits | Normal | Normal
 |  |  |  |  |  |  | Summarised Cases | Buy Side Outcome | Sell Side Outcome
 |  |  |  |  |  |  | Long | Accelerate
 |  |  |  |  |  |  | Short and Price above WAS | Accelerate
 |  |  |  |  |  |  | else | normal
 |  |  |  |  |  |  | Short |  | Accelerate
 |  |  |  |  |  |  | Long and Price below WAB |  | Accelerate
 |  |  |  |  |  |  | else |  | normal
Spreadsheet: 144898d1331199858-how-to-cross-check-data-based-on-time-format-test
Sheet: Sheet1

Driver | Vehicle | start time | end time |  | Vehicle | Time | if F=B , and G between C&D , then copy A to H
[NAME] | BMW | 18:14:00 | 18:50:00 |  | Renault | 16:55:00
Richi | Renault | 16:54:00 | 17:56:00 |  | Infinity
[NAME] | Benz | 16:50:00 | 16:51:00 |  | BMW | 18:30:00
Bernard | Infinity | 16:47:00 | 16:48:00 |  | Benz | 16:51:00
[NAME] | Infinity1 | 16:36:00 | 16:41:00 |  | Infinity2 | 15:20:00
[NAME] | Infinity2 | 15:06:00 | 15:20:00 |  | Benz
[NAME] | BMW | 14:05:00 | 14:07:00 |  | Infinity1
Ray | X6 | 13:57:00 | 14:50:00 |  | X6 | 14:39:00
[NAME] | BMW | 13:17:00 | 13:36:00
Richi | Benz | 13:06:00 | 13:07:00
[NAME] | Benz | 10:49:00 | 10:53:00
Ray | Benz | 10:32:00 | 10:33:00
[NAME] | Infinity | 10:07:00 | 10:09:00
Annette | Infinity | 09:34:00 | 09:36:00
[NAME] | Infinity2 | 07:36:00 | 07:52:00
[NAME] | Renault | 06:52:00 | 06:54:00
[NAME] | Renault | 16:59:00 | 17:05:00
Spreadsheet: 782417d1654026299-problem-with-if-and-or-formula-sample-book3
Sheet: data

 |  |  | tried 2 different formula formats
Type | Name | Cost 3 | Missing? | Missing? |  |  | Should be
 | Arizona |  |  |  | good |  | n/a
 | Arizona |  |  |  | good |  | n/a
 | Arizona |  |  |  | good |  | n/a
 | Arizona |  |  |  | good |  | n/a
 | Arizona |  |  |  | good |  | n/a
 | Arizona |  |  |  | good |  | n/a
New | Arizona |  |  |  | wrong |  | n/a |  |  | for any New on Arizona, Colorado or California, I want it to be n/a.
 | Arizona |  |  |  | good |  | n/a
 | Arizona |  |  |  | good |  | n/a
 | Arizona |  |  |  | good |  | n/a
New | Texas |  |  |  | good |  | Missing
New | Texas | 21076 |  |  | good |  | n/a
 | Colorado |  |  |  | good |  | n/a
New | Colorado |  |  |  | wrong |  | n/a
 | Colorado |  |  |  | good |  | n/a
 | Colorado |  |  |  | good |  | n/a
New | Colorado |  |  |  | wrong |  | n/a
 | Texas |  |  |  | good |  | n/a
 | Texas |  |  |  | good |  | n/a
 | Texas |  |  |  | good |  | n/a
 | Texas |  |  |  | good |  | n/a
 | Texas |  |  |  | good |  | n/a
 | California |  |  |  | good |  | n/a
New | Texas |  |  |  | good |  | Missing
New | California |  |  |  | wrong |  | n/a
 | California |  |  |  | good |  | n/a
New | California |  |  |  | wrong |  | n/a
 | California |  |  |  | good |  | n/a
 | California | 48496.87 |  |  | good |  | n/a
 | California |  |  |  | good |  | n/a
 | California |  |  |  | good |  | n/a
New | Texas |  |  |  | good |  | Missing
 | Texas |  |  |  | good |  | n/a
New | Texas |  |  |  | good |  | Missing
 | Texas |  |  |  | good |  | n/a
 | Texas |  |  |  | good |  | n/a
New | Texas |  |  |  | good |  | Missing
New | Texas |  |  |  | good |  | Missing
Spreadsheet: 713589d1610818125-rotating-column-based-on-date-not-even-sure-what-to-call-it-task-rotation-nitram22-
Sheet: Sheet1

NAME |  |  |  | NAME | Monday | Tuesday | Wednesd. | Thursday | Friday | Saturday | Sunday |  | Dates
2021-01-11 00:00:00 |  |  |  | 2021-01-25 00:00:00 |  |  |  |  |  |  |  |  | 2021-01-11 00:00:00
Employee 1 |  |  | 1 |  | Data | Data | Data | Data | Data | Data | Data
Employee 2 |  |  | 2 |  | Data | Data | Data | Data | Data | Data | Data
Employee 3 |  |  | 3 |  | Data | Data | Data | Data | Data | Data | Data
Employee 4 |  |  | 4 |  | Data | Data | Data | Data | Data | Data | Data
Employee 5 |  |  | 5 |  | Data | Data | Data | Data | Data | Data | Data
Employee 6 |  |  | 6 |  | Data | Data | Data | Data | Data | Data | Data
Employee 7 |  |  | 7 |  | Data | Data | Data | Data | Data | Data | Data
Employee 8 |  |  | 8 |  | Data | Data | Data | Data | Data | Data | Data
Employee 9 |  |  | 9 |  | Data | Data | Data | Data | Data | Data | Data
Employee 10 |  |  | 10 |  | Data | Data | Data | Data | Data | Data | Data
Spreadsheet: 94830d1294592130-extend-index-match-want2learn_billingstatement
Sheet: Billing Statement

[Street Address] |  |  | STATEMENT NO. | [100]
[City, ST Post Code] |  |  | DATE | 2011-01-09 00:00:00
[Phone] [Fax] |  | CUSTOMER ID |  | [NAME]
[e-mail]
BILL TO | [Name] |  | COMMENTS
 | [Company Name]
 | [Street Address]
 | [City, ST  ZIP Code]
 | [Phone]
DATE | Reference |  | RECEIVED | AMOUNT | BALANCE
2010-09-24 00:00:00 | 662 |  | 2010-08-31 00:00:00 | 200 |  |  | 107
2011-01-08 00:00:00 | 670 |  |  | 16.5 | 16.5 |  | 1
2011-01-08 00:00:00 | 671 |  |  | 16.5 | 16.5 |  | 1
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
CURRENT | 1-30 DAYS PAST DUE | 31-60 DAYS  PAST DUE | 61-90 DAYS  PAST DUE | OVER 90 DAYS  PAST DUE | AMOUNT DUE
33 | 33 | 0 | 0 | 0 | 66
REMITTANCE
Statement # | [100]
Date
Amount Due | 66
Amount Enclosed
Spreadsheet: 753444bd-60f9-48c8-9a3a-104e6abd7fdb
Sheet: Sheet1

Table 9--U.S. cotton textile exports, by destination | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | 2011 |  |  | 2010
Region/country | Oct. | Nov. | Dec. |  | Dec.
 | 1,000 pounds 1/
North America | 140807.85 | 125623.54 | 87950.605 | 140807.85 | 123264.673
Bahamas | 103.13 | 135.4 | 98.627 | 103.13 | 104.037
Canada | 9897.117 | 9230.716 | 9691.865 | 9897.117 | 9801.709
Costa Rica | 306.655 | 228.64 | 261.792 | 306.655 | 277.259
Dominican Republic | 34394.069 | 24335.106 | 11010.487 | 34394.069 | 21604.558
El Salvador | 11261.603 | 10068.071 | 9406.705 | 11261.603 | 7280.683
Guatemala | 2683.541 | 2127.018 | 2088.943 | 2683.541 | 3963.386
Haiti | 580.342 | 418.148 | 375.105 | 580.342 | 358.039
Honduras | 54403.113 | 50126.639 | 31956.136 | 54403.113 | 56657.902
Jamaica | 122.793 | 225.613 | 90.872 | 122.793 | 152.165
Mexico | 24710.495 | 26112.497 | 21179.906 | 24710.495 | 20821.877
Nicaragua | 1748.855 | 1930.286 | 1269.447 | 1748.855 | 1730.909
Panama | 334.812 | 398.302 | 262.625 | 334.812 | 158.118
South America | 2070.925 | 2559.182 | 3225.197 | 2070.925 | 2979.873
Brazil | 511.418 | 539.447 | 716 | 511.418 | 486.325
Chile | 173.989 | 320.617 | 219.056 | 173.989 | 391.41
Colombia | 438.077 | 893.928 | 1677.824 | 438.077 | 378.578
Peru | 210.325 | 101.417 | 178.089 | 210.325 | 339.303
Venezuela | 473.356 | 373.535 | 192.048 | 473.356 | 1129.297
Europe | 3171.65 | 3060.166 | 3261.747 | 3171.65 | 3945.628
Belgium | 258.674 | 280.1 | 470.046 | 258.674 | 401.216
France | 78.914 | 87.759 | 117.32 | 78.914 | 106.998
Germany | 626.382 | 537.47 | 601.336 | 626.382 | 563.765
Italy | 113.687 | 144.153 | 250.401 | 113.687 | 166.014
Netherlands | 265.299 | 488.75 | 311.247 | 265.299 | 404.526
Russia | 158.56 | 110.978 | 97.16 | 158.56 | 77.974
Turkey | 49.883 | 48.965 | 75.464 | 49.883 | 562.153
United Kingdom | 1052.286 | 1001.382 | 835.589 | 1052.286 | 1017.785
Asia | 8061.117 | 8622.479 | 7657.762 | 8061.117 | 8345.628
Bangladesh | 8 | 0 | 0 | 8 | 13
China | 4423.972 | 5315.291 | 3624.351 | 4423.972 | 4466.213
Hong Kong | 530.577 | 442.716 | 660.812 | 530.577 | 450.694
India | 313.998 | 192.206 | 162.194 | 313.998 | 217.909
Israel | 190.199 | 101.04 | 168.242 | 190.199 | 276.194
Japan | 777.573 | 815.848 | 910.597 | 777.573 | 758.355
Pakistan | 53.206 | 91.763 | 47.079 | 53.206 | 267.731
Saudi Arabia | 114.839 | 151.413 | 145.446 | 114.839 | 150.069
Singapore | 179.078 | 246.113 | 150.603 | 179.078 | 151.513
South Korea | 621.97 | 498.29 | 672.779 | 621.97 | 565.636
Taiwan | 87.968 | 81.617 | 152.559 | 87.968 | 76.866
United Arab Emirates | 204.003 | 245.715 | 349.463 | 204.003 | 376.627
Oceania | 908.178 | 838.933 | 887.932 | 908.178 | 635.599
Australia | 686 | 645 | 772 | 686 | 514
Africa | 280.42 | 290.413 | 259.123 | 280.42 | 262.93
South Africa | 73.191 | 40.677 | 77.87 | 73.191 | 55.358
World 2/ | 155334.733 | 141046.938 | 103289.754 | 155334.733 | 139436.039
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Last update: 03/12/12.
Sources: USDA, Economic Research Service; and USDC,
U.S. Census Bureau.
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: ECON

Old course number | New course number
ECON-301 | ECON-2301
ECON-302 | ECON-2302
ECON-310 | ECON-3311
ECON-350 | ECON-3501
ECON-410 | ECON-3302
ECON-420 | ECON-3404
ECON-430 | ECON-3511
ECON-435 | ECON-3701
ECON-470 | ECON-4800
ECON-520 | ECON-5025
ECON-601 | [NAME]
ECON-650 | ECON-6505
ECON-701 | ECON-6600
ECON-702 | ECON-6700
ECON-703 | [NAME]
ECON-704 | ECON-7200
ECON-705 | ECON-7300
ECON-706 | ECON-7125
ECON-707 | ECON-7135
ECON-801 | ECON-7500
ECON-810 | ECON-8820
ECON-815 | ECON-8810
ECON-841 | ECON-7145
ECON-842 | ECON-7155
ECON-843 | ECON-8165
ECON-870 | [NAME]
ECON-890 | ECON-8999
Spreadsheet: 94115d1293973095-search-for-string-in-worksheet-s-and-return-results-in-sequential-order-sample-workbook-2-
Sheet: HR

Status | Name | ID | Hire Date | ACTIVE
Active | [NAME] | 780.6069371775324 | 2001-05-13 00:00:00 | 7
Inactive | [NAME] | 31.00591356508782 | 1999-02-07 00:00:00
Active | [NAME] | 155.4330631863325 | 2006-05-30 00:00:00 | 8
Active | [NAME] | 335.5980033769903 | 1997-07-18 00:00:00 | 9
Inactive | [NAME] | 960.6474696229312 | 1984-11-03 00:00:00
Inactive | [NAME] | 653.7679716269221 | 2009-04-30 00:00:00
Inactive | [NAME] | 962.1323388857961 | 2002-01-06 00:00:00
Spreadsheet: 198649d1354841612-rookie-trying-to-make-a-list-with-multiple-selection-capabilities-book3
Sheet: Sheet1

 |  |  | Session 1 | Session 2 | Session 3 | Session 4 | Session 5 | Session 6 | Session 7 | Session 8 | Session 9
 | Billy | Atlanta
 | [NAME] | New York
 | [NAME] | Atlanta
 | [NAME] | Boston
 | [NAME] | London
 | [NAME] | Boston
 | [NAME] | Philadelphia
 | Shawn | London
 | Kaite | Boston
Spreadsheet: 270620d1381554527-can-anyone-suggest-something-other-than-if-function-for-this-figuring-bonus-rate
Sheet: Sheet1

Annualized Premium | Policy Type: | Bonus Rate:
600 | Term 10
600 | Term 10
600 | Term 5
600 | Term 10
600 | [NAME]
600 | [NAME]
 | A | B
2 | Product Type | Bonus Facor
3 | [NAME] | 0.1667
4 | Universal Life | 0.1
5 | UL Increase | 0.1
6 | Term ROP | 0.1
7 | Term 5 | 0.1
8 | Term 10 | 0.1
9 | Term 20 | 0.1
10 | Term 30 | 0.1
11 | Single Prem | 0.02
12 | Annuity | 0.01
13 | 15 Pay | 0.1
14 | 20 Pay | 0.1
Spreadsheet: 129824d1321909405-need-to-count-cells-that-have-a-certain-ship-date-and-have-a-receive-date-example
Sheet: Sheet1

SHIPPED DATE | CLOSED / RECEIVED DATE
2010-01-07 00:00:00 | 2010-01-13 00:00:00
2009-10-13 00:00:00 | 2010-01-13 00:00:00
2009-12-21 00:00:00 | 2010-01-14 00:00:00
2009-12-22 00:00:00 | 2010-01-14 00:00:00 |  | Number of printers that have been received that shipped in 2009
2009-12-29 00:00:00 | 2010-01-14 00:00:00
2010-01-06 00:00:00 | 2010-01-14 00:00:00
2009-12-15 00:00:00 | 2010-01-14 00:00:00
2009-12-21 00:00:00 | 2010-01-15 00:00:00
2009-12-29 00:00:00 | 2010-01-15 00:00:00
2009-12-30 00:00:00 | 2010-01-15 00:00:00
2009-12-31 00:00:00
2010-01-06 00:00:00
2010-01-06 00:00:00
2010-01-06 00:00:00
2010-01-11 00:00:00
2009-12-18 00:00:00
2009-12-21 00:00:00
2009-12-31 00:00:00
Spreadsheet: darrell_schoolcraft__7406__ONEOKRECAP2002
Sheet: Feb 02

INTERNAL REPORT ONLY |  |  | FEBRUARY ONEOK IMBALANCE SUMMARY |  |  |  |  |  |  |  | POI 420 |  | 78109 |  | POI 78108 |  | POI 78107 |  | 65, 62867,61491 | POI 71410 |  | POI 61491
 | SUBLETTE | HOLCOMB | HUGOTON |  | BUSHTON PVR |  | MULLINVILLE |  | BUSHTON PROD. |  | DELHI BEAVER |  | ELLIS CO #1/#2 |  | WWD CO #1 |  | CLARK CO #1 |  | HEMPHILL/CANADIAN |  |  |  |  | ONEOK
 | 103132 | 103134 | TOTAL DEVIATION |  | 103135 |  | 103133 |  | 103138 |  | 106901 |  | 107444 |  | 107445 |  | 107446 |  | 108308 | 108307 |  | 108309 |  | TOTAL DEVIATION |  |  | SUBLETTE | HOLCOMB | HUGO | PVR | MULL | BUSHTON | D.BVR | ELL 1 | WWD 1 | CLK 1 | HEMP/CAN |  |  |  |  |  |  |  |  |  | ONEOK
2002-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 103132 | 103134 | TOTAL | 103135 | 103133 | 103138 | 106901 | 107444 | 107445 | 107446 | 104307 |  |  |  |  |  |  |  |  |  | TOTAL DEVIATION
(EST) BEGINNING BALANCE | 155028 | -366102 |  |  | 76862 |  | 9718 |  | -11807 |  | 7422 |  | 37353 |  | -9522 |  | 6043 |  | -21584 | 27401 |  | -22219
2002-02-01 00:00:00
2002-02-02 00:00:00
2002-02-03 00:00:00
2002-02-04 00:00:00
2002-02-05 00:00:00
2002-02-06 00:00:00
2002-02-07 00:00:00
2002-02-08 00:00:00
2002-02-09 00:00:00
2002-02-10 00:00:00
2002-02-11 00:00:00
2002-02-12 00:00:00
2002-02-13 00:00:00
2002-02-14 00:00:00
2002-02-15 00:00:00
2002-02-16 00:00:00
2002-02-17 00:00:00
2002-02-18 00:00:00
2002-02-19 00:00:00
2002-02-20 00:00:00
2002-02-21 00:00:00
2002-02-22 00:00:00
2002-02-23 00:00:00
2002-02-24 00:00:00
2002-02-25 00:00:00
2002-02-26 00:00:00
2002-02-27 00:00:00
2002-02-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
VOLUME ADJ. | 0 | -69 |  |  | 0 |  | -60 |  | 273 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0
December CUMULATIVE
EST ENDING BALANCE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | BAD DAS
 |  |  | 3161324
 |  |  | 3162595
Spreadsheet: 51932116-45da-457b-a0e9-3ab98e5e534e
Sheet: training_budget

 |  | TRAINING BUDGET TEMPLATE
 |  | Training Title:
 |  | Country
 |  | Local Coordinator
 |  | PROJECT STAFF PARTICIPANTS
 | Ref. | ITEM Description |  | number days | daily cost | Total cost
 | 1 | Fees/Personel
 | 1.2 | Training local coordination: x days X Euro
 | 1.3 | External Trainers:  days x Euro
 | 1.4 | Translation fees:  days x  Euro
 | 1.5 | Facilitation fees :  days X  Euro
 | Sub-total 1
 | Ref. | ITEM Description |  | number days | daily cost | Total cost
 | 2 | Rent of facilities & insurence
 | 2.1 | Meeting room  and equipment
 | 2.2 | Translation cabine (  days x euro)
 | 2.3 | Translation cabine transport
 | 2.4 | Insurance participants & Lecturers ( pers. X  days)
 | Sub-total 2
 | Ref. | ITEM Description |  |  |  | Total cost
 | 3 | Travel costs
 | 3.1 | Local travel costs for participants, lecturers & translator
 | 3.2 | International travel costs lecturers: (Nº  lectures x [NAME] )
 | 3.3 | Travel costs translater: Nº translater x Euro
 | 3.4 | Local transport ( part x  Euro public transport)
 | 3.5 | Local transport (Nº lecture + Nº translater x  Euro public transport)
 | Sub-total 3
 | Ref. | ITEM Description | number participants |  |  | Total cost
 | 4 | Board and Lodging
 | 4.1 | External Trainers: Nº person x Nº days x  Euro
 | 4.2 | Participants: Nº participants x  days x  Euro
 |  | Participants not sleeping in the hotel
 | 4.3 | [NAME]:  days x  Euro
 | Sub-total 4
 | Ref. | ITEM Description |  | Number items | cost | Total cost
 | 7 | Printing
 | 7.1 | Documentation: Nº pax x  Euro
 | 7.2 | Certificates: Nº0 x  Euro
 | Sub-total 6
 | GRAND TOTAL
Spreadsheet: dan_hyvl__4891__Peoples Energy Resources
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY: | [NAME]
DATE: | 2000-09-28 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | Peoples Energy Resources Corp. | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
INCORPORATION STATE: |  | S&P RATING: | N/A
STRUCTURE | COUNTERPARTY | ENA
COLLATERAL
THRESHOLD  in $ | $10MM | $10MM
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | Peoples Energy Corp. (A+) | Enron Corp. (BBB+)
LIMIT in $[NAME] | $10MM | $10MM
Incorporation State: |  | Oregon
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change
-Below = | BBB- | BBB- | S&P
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth
-Cash Flow/CMLTD
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty
-Guarantor ($[NAME]) | $50MM | $100MM
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO: X
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES: | NO: X
OTHER COMMENTS
Worksheet prepared per [NAME] request.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x6-6002
Spreadsheet: 462623d1464117959-profit-margin-calculation-and-bridge-illustration-book10
Sheet: Sheet1

 |  |  | Budget |  |  |  |  |  |  |  | Actual
 | Product |  | Volume | Sales | Cost | Margin | Margin % | Average Sell Price | Mix % |  | Volume | Sales | Cost | Margin | Margin % | Average Sell Price | Mix % |  | Mix | Volume | Sell Price | Cost | Margin
 | Product 1 |  | 10 | 100 | 80 |  |  |  |  |  | 20 | 180 | 150
 | Product 2 |  | 20 | 300 | 150 |  |  |  |  |  | 25 | 250 | 150
 | Product 3 |  | 30 | 240 | 200 |  |  |  |  |  | 25 | 200 | 200
 | Product 4 |  | 40 | 240 | 180 |  |  |  |  |  | 40 | 250 | 200
 | Product 5 |  | 50 | 300 | 210 |  |  |  |  |  | 55 | 300 | 200
 | Total
Spreadsheet: 886646d1736725779-insert-blank-cell-using-hstack-spill-array-stack
Sheet: Sheet1

Table 1
USPS | GEOID | ANSICODE | NAME | [NAME] | AWATER | ALAND_SQMI | AWATER_SQMI | INTPTLAT | INTPTLONG
AL | 1001 | 161526 | Autauga County | 1539631459 | 25677536 | 594.455 | 9.914 | 32.532237 | -86.64644
AL | 1003 | 161527 | Baldwin County | 4117781416 | 1132830835 | 1589.884 | 437.388 | 30.659218 | -87.746067
Table 2
USPS | GEOID | ANSICODE | NAME | FUNCSTAT | [NAME] | AWATER | ALAND_SQMI | AWATER_SQMI | INTPTLAT | INTPTLONG
AL | 100190171 | 161593 | [NAME] | S | 478151753 | 13897907 | 184.615 | 5.366 | 32.457413 | -86.729003
AL | 100190315 | 165647 | Billingsley CCD | S | 386865285 | 1575402 | 149.37 | 0.608 | 32.606138 | -86.748985
[NAME] (SHOULD LOOK LIKE THIS)
USPS | GEOID | ANSICODE | NAME | FUNCSTAT | [NAME] | AWATER | ALAND_SQMI | AWATER_SQMI | INTPTLAT | INTPTLONG
AL | 1001 | 161526 | Autauga County |  | 1539631459 | 25677536 | 594.455 | 9.914 | 32.532237 | -86.64644
AL | 1003 | 161527 | Baldwin County |  | 4117781416 | 1132830835 | 1589.884 | 437.388 | 30.659218 | -87.746067
AL | 100190171 | 161593 | [NAME] | S | 478151753 | 13897907 | 184.615 | 5.366 | 32.457413 | -86.729003
AL | 100190315 | 165647 | Billingsley CCD | S | 386865285 | 1575402 | 149.37 | 0.608 | 32.606138 | -86.748985
HSTACK is a start, but how to deal with the #N/A errors?  Converted table 1 is only "clean" in row 1…
 | 1001 | 161526 | Autauga County |  | 1539631459 | 25677536 | 594.455 | 9.914 | 32.532237 | -86.64644
AL | 1003 | 161527 | Baldwin County | #N/A | 4117781416 | 1132830835 | 1589.884 | 437.388 | 30.659218 | -87.746067
 | 1001 | 161526 | Autauga County |  | 1539631459 | 25677536 | 594.455 | 9.914 | 32.532237 | -86.64644
AL | 1003 | 161527 | Baldwin County |  | 4117781416 | 1132830835 | 1589.884 | 437.388 | 30.659218 | -87.746067
Spreadsheet: 768263d1644911027-dynamic-range-excluding-blanks-and-hidden-cells-book1
Sheet: Sheet1

Filter | Value
2 | 1
1 | 2
3
3 | 4
1 | 5
3 | 6
2 | 7
1
1 | 9
3 | 10
4
1 | 12
1 | 13
2
4 | 15
3
4 | 15
1
2 | 19
 |  |  |  |  |  |  |  |  |  | Ordinary |  | Dynamic |  | Dynamic II