tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: d3cec970-5789-42be-acf9-ef5bfdc90e47
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
FPANC | Test | FPANC | Pancreatic Elastase Stool | Pancreatic Elastase in Stool | ELISA |  |  |  |  |  | Collect 1 gm random formed stool, ship frozen. Separate specimens must be submitted when multiple tests are ordered.   Note:  1)    Pancreatic enzyme supplementation therapy should be discontinued prior to sample collection. 2)       A watery, diarrheal stool is not recommended for this test as some dilutions during the assay may give lower E1 concentrations than are actually present. | 1 gm | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | 200 to >500 ug Elastase/g stool = Normal 100 to 200 ug Elastase/g stool = Moderate to slight exocrine                                                                 pancreatic insufficiency <100 ug Elastase/g stool = Severe exocrine pancreatic                                                       insufficiency   Test Performed By: [NAME], Inc.                                         2451 Wehrle Drive                                         Williamsville, NY 14221 | Set up 1 time per week | 1 day | 10 days | 1 | 82656 |  |  |  |  | Joli Diagnostics, Inc.
FPANC | [NAME] | FECAL | Fecal |  |  |  | Frozen | 365 days
FPANC | Result | Z0947 | Patient Value: | Patient Value: | Alphanumeric |  |  |  |  | ug E/g stool |  |  |  |  |  |  |  |  |  | In Process
FPANC | Result | Z0945 | Interpretation: | Interpretation: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 208441d1358833732-question-highlight-a-cell-once-a-certain-condition-has-been-satisfied-medaninvoices
Sheet: Sheet1

 | CUSTOMER ABC INVOICES |  |  |  | [NAME] PAYMENTS
 | DATE | INV NO. | AMOUNT (USD) |  | DATE | AMOUNT PAID (USD)
 | 04/01 | 0083 | 500 |  | 18/01 | 300
 | 08/01 | 0284 | 100 |  | 19/01 | 400
 | 09/01 | 0329 | 200 |  | 20/01 | 200
 | 14/01 | 0549 | 800
 | 22/01 | 0829 | 300
 | TOTAL |  |  |  | TOTAL
 | What I would like to do is to have invoice number cell highlighted, once the total amount paid has covered the particular invoice amount. In this case invoice number 0083, 0284 and 0329 should be automatically highlighted, as they have been paid for in full. Thank you!!!
Spreadsheet: darrell_schoolcraft__7779__imbalsumm0106
Sheet: by type

If index is high - payback should be done on Dollar Valued payables
- payback should be done on Volumetric receivable
- payback should not be done on Dollar valued receivables
- payback should not be done on Volumetric payables
TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES
Positive = due [NAME]
Negative = due operator |  |  |  |  |  |  |  |  |  |  |  |  |  | index
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SJ
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments |  |  |  |  |  |  |  | AVG
NNG |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  |  |  |  | NTXPH
[NAME] |  |  |  | Dollar Valued | [NAME] | Keystone - to be cashed out
PNM |  |  |  | Dollar Valued | [NAME]
Red Cedar |  |  |  | Dollar Valued | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
[NAME] |  |  |  | Dollar Valued | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME] | being reconciled with CIG
PG&E TX/EPFS |  |  |  | Dollar Valued | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | ending 5/31/01 bal of $295,327 invoiced
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Continental |  |  |  | Dollar Valued | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Citizens Communications |  |  |  | Dollar Valued | [NAME]
$ valued totals
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments
[NAME] |  |  |  | Volumetric | [NAME] | [NAME], Valverde, [NAME], and Milagro
NGPL |  |  |  | Volumetric | [NAME]
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
Lonestar |  |  |  | Volumetric | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
Northwest |  |  |  | Volumetric | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
volumetric totals
Net $ valued/volumetric
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: vkaminski__40901__CASH_EPE_0400MyCopy
Sheet: Avail Penalty

APPENDIX II - AVAILABILITY PENALTY CALCULATION
 |  | Average Availability Calculation For Penalties
 |  | Monthly | 12 Month | Deficiency | P&T Cap | [NAME] | [NAME] | Total [NAME] | Monthly | (Multiply By) | Monthly
 |  | Guarant | Rolling | Below PPA | Revenues | Revenues | Revenues | Revenues | Penalty | Current | Penalty | Annual
Date |  | Availability | Average | 0.92 | R$ 000 | R$ 000 | R$ 000 | R$ 000 | R$ 000 | Exch Rate | US$ 000 | Penalty
 |  |  | 0.92
1
Spreadsheet: 809069d1670870870-index-and-match-from-2nd-sheet-formula
Sheet: Sheet1

Code | Mall cost | Store cost | Metro station | Online Shops | cheapset Place to buy from
Azb123 | 10 | 15 | 25 | 11 | Mall
987KUH | 25 | 0 | 12 | 14 | Metro station
BU7663 | 18 | 0 | 0 | 7 | Online shops
BU7664 | 25 | 10 | 8 | 0 | Metro station
BU7665 | 11 | 15 | 12 | 0 | Mall
BU7666 | 15 | 0 | 0 | 8 | Online shops
BU7667 | 20 | 25 | 26 | 0 | Mall
Spreadsheet: 133845d1324685662-printing-only-rows-with-values-scrap-quotes
Sheet: Clients

Name | Address | City | Zip Code | Telephone | Customer Number
Retail | 12351 Main St | Any City, GA | 1111 | 1111111111 | 1001
[NAME]'s Metal Pick Up Service | 12352 Main St | Any City, GA | 22222 | 2222222222 | 1002
General Metals | 12353 Main St | Any City, GA | 33333 | 3333333333 | 1003
Mobile Scrap | 12354 Main St | Any City, GA | 44444 | 4444444444 | 1004
[NAME]'s Recylcing | 12355 Main St | Any City, GA | 55555 | 5555555555 | 1005
[NAME] | 12356 Main St | Any City, GA | 66666 | 6666666666 | 1006
[NAME] | 12357 Main St | Any City, GA | 77777 | 7777777777 | 1007
Spreadsheet: louise_kitchen__22838__Hot List Update 5-18-01
Sheet: E-Commerce

Deal Description Sheet - 5/17/01
E-Commerce
YTD P & L | 1317000
Project Name | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
[NAME] | Applied Terravision Systems | 2MM warrants at strike of CDN $0.85, 18 month term.  1MM warrants at strike of CDN $1.10, 24 month term. | 981688 |  |  | Executed
Peoples | Peoples Production Company | Outsourcing- scheduling, balancing, settlement, deal confirmations and measurement & accounting. | 50000 | 2001-05-10 00:00:00 | 0.8 | 2001-05-01 00:00:00 | ATS will close in May.  ENA will close in May providing proposal on 5/1/01.
Andex | Andex | Outsourcing- scheduling, balancing, settlement, deal confirmations and measurement & accounting. | 50000 | 2001-05-11 00:00:00 | 0.8 | 2001-06-01 00:00:00 | ATS will close in May 2001.  ENA will close in June 2001.  ENA will put the systems proposed out the first week in May.  Next meeting 5/10/2001.
[NAME] | EOTT | Back office accounting services. | *$500,000 | 2001-05-14 00:00:00 | 0.5 | 2001-06-01 00:00:00 | EOTT meeting set up for May 14, 2001 with HMS.
Columbia Natural Resources | Columbia Natural Resources | Application Service Provider, gas and liquids, E&P accounting, forecasting. | *$250,000 | 2001-04-16 00:00:00 | 0.35 | 2001-09-30 00:00:00 | ENA missed the supply deal, but is working on the outsourcing.  Lost to AEP who hid 3 1/4 for the pool gas.  ENA bid 1/4. CMR will start trading this summer.
Columbia Gas Transmission | Columbia Gas Transmission | Application Service Provider, transportation and storage, meter finance. | *$500,000 | 2001-01-26 00:00:00 | 0.35 | 2001-09-01 00:00:00 | Follow meeting is Wednesday, May 16, 2001.
Project Deep Blue Sea | Ocean Energy | Integrated outsourcing products. | *$500,000 | 2001-04-30 00:00:00 | 0.25 | 2001-09-01 00:00:00 | Meeting with manager of operations set up for May 22, 2001.
Mariner | Mariner | Integrated outsourcing products. | *$100,000 | 2001-01-17 00:00:00 | 0.25 | 2001-09-01 00:00:00 | Follow up meeting in May, 2001.
Running Man | Marathon | Integrated outsourcing products. | *$1,000,000 | 2001-04-04 00:00:00 | 0.2 | 2001-09-01 00:00:00 | Meeting set third week in May.
[NAME] | Pure Resources | Integrated outsourcing products. | *$250,000 | 2001-04-23 00:00:00 | 0.25 | 2001-12-01 00:00:00 | ATS to meet with Pure May 2, 2001.  ENA to follow up.
Gather Company | Gather Company | Monetization and metering services. | 100000 | 2001-05-10 00:00:00 | 0.25 | 2001-12-01 00:00:00 | Follow up meeting in May, 2001.
Greenway | Occidental Petroleum Corp. | Total outsourcing including measurement and folder/accounting. | *$2,000,000 | 2001-05-01 00:00:00 | 0.2 | 2001-12-01 00:00:00 | Response to proposal due 5/16/2001.
 |  |  |  |  |  |  | * Accrual
Spreadsheet: 856984d1706106368-countifs-not-working-with-2-criteria-sample-count
Sheet: Jan

 |  |  |  | January
 |  | Code |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  |  |  |  |  | Plan List |  | Code
 |  | Apple |  | APP |  |  |  |  |  |  |  |  |  | APP |  | APP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APP |  | Apple
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORA |  | Orange
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BAN |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APP
Spreadsheet: larry_campbell__20990__PCB Graphs
Sheet: 0.55B

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Lab
PGE Mile pt. |  |  | 1999-11-03 00:00:00 |  |  | 14 |  | Sherwood
0.55 B side |  |  | 1999-11-18 00:00:00 |  |  | 26 |  | Sherwood
 |  |  | 1999-11-24 00:00:00 |  |  | 44 |  | Sherwood
 |  |  | 1999-12-01 00:00:00 |  |  | 47 |  | Sherwood
 |  |  | 1999-12-08 00:00:00 |  |  | 30 |  | Sherwood
 |  |  | 1999-12-14 00:00:00 |  |  | 21 |  | Sherwood
 |  |  | 1999-12-29 00:00:00 |  |  | 29 |  | Sherwood
 |  |  | 2000-01-05 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-01-19 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-02-09 00:00:00 |  |  | 29 |  | Sherwood
 |  |  | 2000-03-01 00:00:00 |  |  | 23 |  | Sherwood
 |  |  | 2000-03-22 00:00:00 |  |  | 10 |  | Sherwood
 |  |  | 2000-04-05 00:00:00 |  |  | 20 |  | Sherwood
 |  |  | 2000-04-19 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-05-03 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-05-17 00:00:00 |  |  | 11 |  | Sherwood
 |  |  | 2000-05-31 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-06-14 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2000-06-21 00:00:00 |  |  | 18 |  | Sherwood
 |  |  | 2000-06-27 00:00:00 |  |  | 19 |  | Sherwood
 |  |  | 2000-07-05 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-08-09 00:00:00 |  |  | 13 |  | Sherwood
 |  |  | 2000-09-20 00:00:00 |  |  | 8 |  | Sherwood
 |  |  | 2000-10-04 00:00:00 |  |  | 5 |  | Sherwood
 |  |  | 2000-10-18 00:00:00 |  |  | 5 |  | Sherwood
 |  |  | 2000-12-13 00:00:00 |  |  | 4 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: 170283d1343226075-calculation-of-similar-values-test1
Sheet: Sheet1

 |  | 19 | 45 | 22 | 0 | 2 | 15
 |  | 2012-07-25 19:45:40 | 2013-02-28 00:00:00 | Target Date 28-02-2013 10:PM
 |  |  |  |  |  |  | Budget For Apple | 10
DATE | Month |  | Commodity | PRIZE |  |  | Budget For Orange | 10
2012-06-01 00:00:00 | Jun | Apple | Apple | 2 |  | Annual Epenses
2012-06-03 00:00:00 | Jun | Orang | Orange | 2
2012-07-08 00:00:00 | Jul | Grape | Grapes | 2 |  | Month | Commodity | Expenses | Above Budget | Below Budget
2012-07-10 00:00:00 | Jul | Water | Water Melon | 5 |  | Jun | Apple | 2 |  | -8 | 14.7 | 1
2012-07-16 00:00:00 | Jul | Banan | [NAME] | 5 |  | Jun | Orange | 2 |  | -8 | 7.3
2012-07-16 00:00:00 | Jul | Kiwi | Kiwi | 20 |  | Jul | Grapes | 4 |  |  | 4
2012-07-17 00:00:00 | Jul | Apple | Apple | 2 |  | Jul | Water Melon | 7 |  |  | 7
2012-07-17 00:00:00 | Jul | Orang | Orange | 0.3 |  | Jul | [NAME] | 9.8 |  |  | 9.8
2012-07-17 00:00:00 | Jul | Apple | Apple | 0.7 |  | Jul | Kiwi | 24.8 |  |  | 24.8
2012-07-17 00:00:00 | Jul | Orang | Orange | 5 |  | Jul | Rambutan | 2.7 |  | -7.3 | 5
2012-07-17 00:00:00 | Jul | Grape | Grapes | 2 |  | Jul | Apple.gala | 5.3 |  | -4.7 | 14.7
2012-07-17 00:00:00 | Jul | Water | Water Melon | 2 |  | Jul |  | 5 |  |  | 0
2012-07-21 00:00:00 | Jul | Banan | [NAME] | 4.8
2012-07-21 00:00:00 | Jul | Kiwi | Kiwi | 4.8
2012-07-22 00:00:00 | Jul | [NAME] | Rambutan | 5
2012-07-22 00:00:00 |  | Apple | Apple.gala | 10 |  |  | Days | Hours | minutes
 |  |  |  |  |  | Time Remaining | 277 | 2 | 15
 |  |  |  |  |  | 2 | 28
 |  |  |  |  |  | 7 | 25 |  |  | name | name
 |  |  |  |  |  |  |  |  |  | Apple | Apple
 |  |  |  |  |  |  |  |  |  | Orange | Orange
 |  |  |  |  |  |  |  |  |  | Grapes | Grapes
 |  |  |  |  |  |  |  |  |  | Water Melon | Water Melon
 |  |  |  |  |  | 1 | 31 | 31 |  | [NAME] | [NAME]
 |  |  |  |  |  | 2 | 28 | 59 |  | Kiwi | Kiwi
 |  |  |  |  |  | 3 | 31 | 90 |  | Apple | Rambutan
 |  |  |  |  |  | 4 | 30 | 120 |  | Orange | Apple.gala
 |  |  |  |  |  | 5 | 31 | 151 |  | Apple
 |  |  |  |  |  | 6 | 30 | 181 |  | Orange
 |  |  |  |  |  | 7 | 31 | 212 |  | Grapes
 |  |  |  |  |  | 8 | 31 | 243 |  | Water Melon
 |  |  |  |  |  | 9 | 30 | 273 |  | [NAME]
 |  |  |  |  |  | 10 | 31 | 304 |  | Kiwi
 |  |  |  |  |  | 11 | 30 | 334 |  | Rambutan
 |  |  |  |  |  | 12 | 31 | 365 |  | Apple.gala
Spreadsheet: 104880d1302297104-excel-2007-count-using-multiple-criteria-and-date-range-samplepvt
Sheet: Sheet1

Type | Received
CASH TRANS. | 2010-07-27 00:00:00
FHA | 2010-08-17 00:00:00 |  | Count of Received | Column Labels
FHA | 2010-08-30 00:00:00 |  | Row Labels | CASH TRANS. | CONV. UNINS. | FHA | Grand Total
CASH TRANS. | 2010-07-09 00:00:00 |  | 2010
CASH TRANS. | 2010-09-22 00:00:00 |  | Jul | 2 |  |  | 2
CASH TRANS. | 2010-09-24 00:00:00 |  | Aug |  |  | 2 | 2
CASH TRANS. | 2010-09-24 00:00:00 |  | Sep | 4 | 1 |  | 5
CONV. UNINS. | 2010-09-28 00:00:00 |  | Oct | 6 |  | 1 | 7
CASH TRANS. | 2010-11-10 00:00:00 |  | Nov | 1 |  |  | 1
CASH TRANS. | 2010-10-14 00:00:00 |  | Grand Total | 13 | 1 | 3 | 17
CASH TRANS. | 2010-10-18 00:00:00
CASH TRANS. | 2010-10-19 00:00:00
CASH TRANS. | 2010-10-19 00:00:00
CASH TRANS. | 2010-10-21 00:00:00
FHA | 2010-10-22 00:00:00
CASH TRANS. | 2010-10-28 00:00:00
CASH TRANS. | 2010-02-11 00:00:00
CASH TRANS. | 2010-02-11 00:00:00
FHA | 2010-02-11 00:00:00
CASH TRANS. | 2010-03-11 00:00:00
FHA | 2010-03-11 00:00:00
CASH TRANS. | 2010-09-11 00:00:00
Spreadsheet: 877140d1723816122-filter-function-to-extract-selected-columns-kerahjoy-filter-by-selected-columns-365-aligw
Sheet: Sheet1

Data | County | Region | Support Coordinator | Supervisor |  | Criteria | Select Column names |  | Derised outcome |  | Supervisor
 | Walker | Region 1 | Diane Parsons | [NAME] |  |  | Support Coordinator |  |  | Diane Parsons | [NAME]
 | [NAME] | Region 3 | [NAME] | [NAME] |  |  | Supervisor |  |  | [NAME] | [NAME]
 | Fulton | Region 3 | [NAME] | [NAME] |  |  |  |  |  | [NAME] | [NAME]
 | Newton | Region 3 | [NAME] | [NAME] |  |  |  |  |  | [NAME] | [NAME]
 | [NAME] | Region 3 | [NAME] | [NAME] |  |  |  |  |  | [NAME] | [NAME]
 | [NAME] | Region 3 | [NAME] | [NAME] |  |  |  |  |  | [NAME] | [NAME]
Spreadsheet: 193577d1352881114-filtering-problem-fx
Sheet: Sheet2

Project | Total Cost
1 | 903790955
2 | 903790955
3 | 903790955
5 | 948863332
6 | 948863332
9 | 948863332
4 | 873161482
8 | 873161482
6 | 873161482
3 | 1028357159
2 | 1028357159
5 | 1028357159
9 | 1054349474
7 | 1054349474
4 | 1054349474
5 | 1015440456
6 | 1015440456
3 | 1015440456
2 | 928265311
1 | 928265311
4 | 928265311
5 | 926816014
6 | 926816014
9 | 926816014
8 | 976100958
3 | 976100958
9 | 976100958
6 | 817998734
8 | 817998734
7 | 817998734
4 | 903590367
5 | 903590367
6 | 903590367
3 | 897683641
2 | 897683641
1 | 897683641
5 | 730085416
9 | 730085416
8 | 730085416
6 | 771550706
7 | 771550706
4 | 771550706
8 | 782815062
5 | 782815062
6 | 782815062
9 | 638409071
8 | 638409071
7 | 638409071
4 | 671578974
5 | 671578974
6 | 671578974
3 | 703465702
2 | 703465702
1 | 703465702
2 | 423461537
3 | 423461537
6 | 423461537
9 | 62550780
8 | 62550780
7 | 62550780
9 | 314512815
8 | 314512815
7 | 314512815
4 | 344816923
5 | 344816923
6 | 344816923
3 | 598077259
2 | 598077259
6 | 598077259
5 | 618844132
9 | 618844132
7 | 618844132
4 | 2375200000
5 | 334733255
6 | 334733255
5 | 121129846
2 | 1725919
3 | 1725919
6 | 1725919
9 | 842306599
6 | 842306599
5 | 842306599
2 | 919776361
3 | 113490000
6 | 113490000
5 | 113490000
4 | 225040000
1 | 225040000
2 | 225040000
6 | 225040000
9 | 225040000
7 | 225040000
8 | 1075435806
5 | 1075435806
6 | 1075435806
2 | 1126965207
5 | 1126965207
5 | 1126965207
3 | 984885728
6 | 984885728
Spreadsheet: 849542d1699976261-use-email-address-as-the-unique-identifier-to-merge-records-sample-workbook-mep
Sheet: Sheet1

Customer ID | Display Name | Product Type | Period Start Date | Period End Date | [NAME]
2397380 | Customer 1 | Product A | 2023-11-07 10:13:20 | 2026-12-01 11:53:38 | [EMAIL]
2895208 | Customer 2 | Product A | 2023-11-07 10:11:14 | 2026-11-07 04:31:41 | [EMAIL]
2454853 | Customer 3 | Product A | 2023-11-07 10:10:12 | 2026-11-29 00:00:00 | [EMAIL]
2904938 | Customer 4 | Product A | 2023-11-07 10:02:23 | 2027-02-11 04:32:26 | [EMAIL]
2747145 | Customer 5 | Product A | 2023-11-07 09:59:08 | 2026-11-20 12:29:26 | [EMAIL]
2442989 | Customer 6 | Product B | 2023-11-07 09:55:30 | 2027-03-05 00:00:00 | [EMAIL]
2499123 | Customer 7 | Product C | 2023-11-07 09:47:37 | 2026-12-01 00:00:00 | [EMAIL]
2458372 | Customer 8 | Product C | 2023-11-07 09:46:43 | 2026-12-13 00:00:00 | [EMAIL]
2393642 | Customer 9 | Product B | 2023-11-07 09:46:42 | 2027-01-04 09:18:38 | [EMAIL]
2468490 | Customer 10 | Product A | 2023-11-07 09:45:12 | 2026-11-17 10:29:09 | [EMAIL]
Spreadsheet: 192015d1352289262-merge-multiple-sheets-into-one-sheet-advfilterrep-copy
Sheet: a

Date | Region | Rep | Item | Units | Cost | Total
2012-01-02 00:00:00 | Ontario | [NAME] | Clipboards | 20 | 4.99 | 99.80000000000001
2012-02-20 00:00:00 | Ontario | [NAME] | Pens | 29 | 1.99 | 57.71
2012-02-20 00:00:00 | Ontario | [NAME] | Pens | 30 | 1.99 | 59.7
2012-02-20 00:00:00 | Ontario | [NAME] | Pens | 10 | 1.29 | 12.9
2012-02-28 00:00:00 | Ontario | [NAME] | Pens | 10 | 1.29 | 12.9
Spreadsheet: 673496d1587407903-help-with-sumifs-calculating-between-a-date-range-and-another-argument-ledger-project
Sheet: Data for Lists

Transaction Type | Report Catagories
Deposit | Income 1 - Dues paid by Members
[NAME] | Income 2 - Fundraising Revenue
Check | Income 3 - Product Donations
[NAME] | Income 4 - Donations - all others
Debit Card | Income 5 - Motorcycle Raffle Money In
 | Income 6 - Patch Deposit from Member
 | Income 7 - Patch Refund from National
 | Expenditure 1 - POW-MIA Issues
 | Expenditure 2 - Veteran's Issues
 | Expenditure 3 - Chapter Products
 | Expenditure 4 - Fundraising
 | Expenditure 5 - Permits & License Fee
 | Expenditure 6 - NewsLetter/Web Site
 | Expenditure 7 - Advertising
 | Expenditure 8 - Rent & Heat/AC/PO Box
 | Expenditure 9 - Telephone
 | Expenditure 10- Office Supplies
 | Expenditure 11 - Postage
 | Expenditure 12 - Dues Paid to National
 | Expenditure 13 - Accountant Fees
 | Expenditure 14 - Legal Fees
 | Expenditure 15 - State Liaison (Travel/Lodge)
 | Expenditure 16 - Donations made by Chapter
 | Expenditure 17 - Chapter Insurance
 | Expenditure 18 - Patch Money to National
 | Expenditure 19 - Bike Raffle Money to National
 | Expenditure 20 - Patch Deposit Refund to Member
Spreadsheet: kay_mann__19198__MDEA - Credit Work Sheets
Sheet: EPMI&MDEA-EEI Credit Worksheet

POWER MASTER AGREEMENT INFORMATION SHEET
 |  | LEGAL CONTACT:
DATE: |  | EPMI CONTACT: | [NAME]  x5-3363
COUNTERPARTY: | Mississipi Delta Energy Agency, agent for | CONTACT:  Clarksdale | [NAME] (General Mgr)
ADDRESS: | Clarksdale Public Utilities Commission of | PHONE: | [PHONE]
 | the City of Clarksdale, Mississippi and Public | CONTACT:  Yazoo City | [NAME] (GM) / [NAME] (Finance)
 | Service Commission of Yazoo City of the | PHONE: | [PHONE]
 | City of Yazoo City, Mississippi
 |  | S&P RATING:  Clarksdale | not rated
 |  | MOODY'S RATING:  Clarksdale | A3 (Electric Revenue Bond)
 |  | S&P RATING:  Yazoo | not rated
ENTITY TYPE: |  | MOODY'S RATING:  Yazoo | Baa1 (Utility Revenue Bond)
TYPE OF AGREEMENT:
Bilateral (Purch & Sale) | X | Power Marketing
Unilateral - EPMI Purch only |  | Industrial Producer - EPMI Purch only
Unilateral - EPMI Sale only
Transaction Specific |  | Power Supply Agreement
TRANSACTION TENOR LIMITS | open
COVER PROVISIONS
(Failure to Deliver/Receive) | X
STANDARD TRIGGER EVENTS
Non-Payment | X
Representations | X
Other Covenants | X
Bankruptcy | X
TERMS SPECIFIC TO: | COUNTERPARTY | EPMI
COLLATERAL THRESHOLD | n/a | n/a
Applies to [NAME] to Market only
Applies to MTM and [NAME] | X | X
Collateral Multiple | n/a | n/a
COLLATERAL THRESHOLD TYPE
In a form acceptable...
Cash | X | X
US Treasuries
Letter of Credit | X | X
ADDITIONAL TRIGGER EVENTS
Cross Default 3rd Party Debt: |  | Enron Corp.
-Counterparty | $250,000 for MDEA, Clarksdale PUC or PSC of Yazoo (individually)
-Guarantor |  | 200000000
Material Adverse Change:
-Counterparty | X
-Guarantor |  | X
Non-Specific
-Bilateral
-Unilateral
Debt Ratings Change | X | X
-Below Moody's | Baa2 | Baa3
-Type of debt | Existing and Future electric revenue and utility revenue bonds of Clarksdale PUC or PSC of Yazoo | Sr. Unsecured Debt
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net Worth - Clarksdale PUC | Not less than $24MM ($27.5MM at 9/30/00)
-Minimum Net Worth - PSC of Yazoo City | Not less than $18.5MM ($21.2MM at 9/30/00)
-Interest Coverage (EBIT/Interest)
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
Counterparty - Event of Default | at any time Clarksdale PUC or PSC of Yazoo City no longer has the ability to charge users for electric expenses incurred pursuant to its operations in providing goods or services to its general public customers.
Ownership Change
-Less than 51% owned by:
COLLATERAL TYPE
In a form and amount acceptable
to non-defaulting party | X | X
Other
GUARANTOR BREACH
GUARANTOR (RATING) |  | Enron Corp. (BBB+/Baa1)
$ LIMIT |  | 10000000 | ENE gty to cover both EPMI and ENA physical gas transactions.
Incorporation State:
FINANCIAL STATEMENTS
-Counterparty | X - Financial statements for MDEA, Clarksdale PUC and PSC of Yazoo City
-Guarantor |  | X
-Parent
OTHER COMMENTS:
Cross Default language to the Energy Management Services Agreement and ENA physical gas agreements shall be incorporated in the EEI.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | 5-7712
Spreadsheet: 123939d1317932747-splitting-address-into-multiple-columns-copy-of-addresstranspose
Sheet: Sheet1

 | Address line 1 | Address line 2 | City | State | [NAME]
170 S. 29th Street San Jose, CA 95116 |  |  |  |  |  |  |  |  | Street
1305 [NAME]. [NAME], TX 75006-6980 |  |  |  |  |  |  |  |  | Hwy
25800 Northwestern Hwy.,Suite 250 Southfield, MI 48075 |  |  |  |  |  |  |  |  | Rd
150 [NAME]., Ste. 2500 Detroit, MI 48226 |  |  |  |  |  |  |  |  | Ave