tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 756667d1637688912-vlookup-right-function-eh_is_output
Sheet: DS288715-NPD Xmas Tracker 2021 

 |  |  |  | '00786959
 |  |  |  | '00291606
 |  |  |  | '00607292
 |  |  |  | '29198030
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE] |  |  |  |  |  |  | TSCFNODFF BT US GM JT HNYVC800
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE] |  |  |  |  |  |  | FNSTGFFFXM A+C+H S+3P/RST+C RW
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '29197781
 |  |  |  | '00934091 |  |  |  |  |  |  | [NAME]   TY 729G
 |  |  |  | '29203697
 |  |  |  | '29200153
 |  |  |  | '29101627
 |  |  |  | '29101610 |  |  |  |  |  |  | ST M XM LG SSGE RLL       610G
 |  |  |  | '29193127
 |  |  |  | '00012195 |  |  |  |  |  |  | ST M TC LG SSG RLL GRLND  630G
 |  |  |  | '29200085
 |  |  |  | '00897082 |  |  |  |  |  |  | STMXM LG TRKY+BCN+CRNBRY RL130
 |  |  |  | '29197910
 |  |  |  | '29203888
 |  |  |  | '29197903
 |  |  |  | '29204762
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE] |  |  |  |  |  |  | [NAME]   347G
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE] |  |  |  |  |  |  | ALDI SS SPN MT SLCTN      120G
 |  |  |  | '[PHONE] |  |  |  |  |  |  | [NAME] SLCTN     100G
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE] |  |  |  |  |  |  | TSC XM ANTIPST VG PLTTR   550G
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE] |  |  |  |  |  |  | ALDISS B+O+C STF D/C HM JNT900
 |  |  |  | '[PHONE] |  |  |  |  |  |  | [NAME]       500G
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '29192809
 |  |  |  | '29198047
 |  |  |  | '29192632
 |  |  |  | '00435338 |  |  |  |  |  |  | JSBYXM PK SG WRP BCN+DP12P502G
 |  |  |  | '00435239 |  |  |  |  |  |  | JSTTDGFXM PK+TR [NAME] BC10P210
 |  |  |  | '00435321 |  |  |  |  |  |  | JSBYGFXM PK+J+CSG WRS/BC12P260
 |  |  |  | '00435314
 |  |  |  | '00435307
 |  |  |  | '00439749
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
 |  |  |  | '[PHONE]
Spreadsheet: 682830d1592345884-engineer-project-allocation-app-xlf-sanitised-tracker
Sheet: Staff

 | Days in Month
 | Person | Mgr | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21
 | Engineer 1 | M1
 | Engineer 2 | M2
 | Vmware Engineer 3 | M2
 | Vmware Engineer 4 | M2
 | Vmware Engineer 5 | M2
 | Vmware Engineer 6 | M2
 | Network Engineer 7 | M1
 | Network Engineer 8 | M1
 | Network Engineer 9 | M1
 | Network Engineer 10 | M1
 | Network Engineer 11 | M1
 | Network Engineer 12 | M1
 | Storage Engineer 13 | M1
 | Storage Engineer 14 | M1
 | Storage Engineer 15 | M1
 | Automation Engineer 16 | M2
 | Automation Engineer 17 | M2
 | Automation Engineer 18 | M2
 | Automation Engineer 19 | M2
 | Backup Engineer 20 | M1
 | Skill | Column1 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 | Usage by [NAME]
 | Skill | Column1 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
Spreadsheet: 57fc1478-223e-4ed1-97e5-3751d703627b
Sheet: EQUIP_MASTER

Assessment  Date | Building Portfolio | Building Site | Building ID | Building Abbr | Building Name | Floor | Room | Keyword | EQ_Type | Equipment Group/Keyword | Equipment Type | Status | Condition  (at assessment) | Field Notes | Area Serviced (Bldg/Floor/Wing/Room) | Criticality | EQ_Group | Nomenclature | len | Old EQ_ID (If Existing) | EQ_ID |  | In-Field Reference Name/Nomenclature | Parent [NAME] | State_ID | MFR | Manufacturer | [NAME] No | Mfr Serial No | Mfr Part No/Date/Code | Acquisition Date | Acquisition Vendor | Acquisition Comments | Warranty Vendor | Warranty Expiration Date | Warranty Usage Expiration | Warranty Comments | Current Replacement Cost | Spec (FILTER) | Spec (BELTs) | Spec (MOTOR) | Spec (REFRIGERANT) | Spec (MECH COUPLINGS  & SEALS) | Spec (TONS) | Spec (CFM) | Spec  (BTU/Hr) | Spec  (STATIC PRESSURE) | Spec  (HP) | Spec  (RPM) | Spec  (HERTZ) | Spec  (PHASE) | Spec  (AIR TEMP IN/OUT) (SUMMER/WINTER) | Spec  (WATER TEMP IN/OUT) (SUMMER/WINTER) | [NAME](HEAD-FEET or TOTAL [NAME] HEAD (TDH) | Spec  (GPM) | Spec (IMPELLER DIAMETER) | Spec  (PSI) | Spec (GALLONS) | Spec  (KVA) | Spec (AMPS) + (MAIN LUG or BREAKER) (OPEN or CLOSED) | Spec (CIRCUITS) | Spec  (VOLTS) | Spec (WATTS) | Spec  (WIRE) | Spec  (POLES) | Spec  (MCA) | Spec  (MAX FUSE) | Spec (OTHER)
Example: |  |  |  |  | UNIVERSITY HALL | 0 | 001 |  |  | AIR HANDLING UNIT | AIR HANDLER, HVAC > 30K CFM | ACTIVE | VERYGOOD | UNIT INCLUDES COMBINED HRU | 1st & 2nd floor |  |  |  |  |  |  | 001 | AHU-1 |  |  |  | HAW'S PRODUCTS | [NAME] | 472010C08248-04 | MFR DATE: 11/15/2010 | 2012-01-10 00:00:00 | -VENDOR- |  | -VENDOR- | 2015-01-10 00:00:00 |  | 3 YEARS PARTS ONLY |  | PRE FILTER: MERV8, 16X20X2 ([NAME]), FINAL FILTER: MERV11, 20X20X2 (X9) |  |  | R410A, 4.2LBS |  |  | 7500 RETURN CFM 7500 SUPPLY CFM |  | 8.5" |  |  | 60 | 3 | 70.9IN,110.4OUT | 180IN,136.3OUT |  |  |  |  |  |  |  |  | 460
Example: |  |  |  |  | UNIVERSITY HALL | 0 | 001 |  |  | FAN | FAN, SUPPLY, BELT | ACTIVE | VERYGOOD | GREASE FITTING ON MOTOR | 1st floor commons |  |  |  |  |  |  |  | AHU-1-SF | 182AHUHVLG-001 |  |  | GREENHECK | 22-QEP-4-60-11 | [PHONE] |  |  | -VENDOR- |  | -VENDOR- |  |  | 1 Year Manufacturer's Warranty for Defects |  |  | (X1) 4L490 (A47) | RI Motor, Frame: 284T, Model: RIM-22ANGEBBCA, Serial: [PHONE] |  | A33 |  | 7500 [NAME] |  | 8.5" | 15 | 1750 | 60 | 3 |  |  |  |  |  |  |  |  |  |  | 460
Spreadsheet: 888331d1738833678-distinct-count-with-multiple-criteria-powerpivot-measure
Sheet: Sheet1

ContactID | Name | Ref# | Year-Quarter | Year-Month | Within 3 days
1386123 | [NAME] | 10340901 | 2024-4Q | 2024/11 | 1 |  |  |  | measure 1 | Column Labels
1386123 | [NAME] | 10340903 | 2024-4Q | 2024/11 | 1 |  |  |  | Row Labels | 2024-4Q |  | Measure
1043300 | [NAME] | 10340620 | 2024-4Q | 2024/11 | 1 |  |  |  | [NAME] | 1 |  | 1
1359798 | [NAME] | 10341301 | 2024-4Q | 2024/11 | 1 |  |  |  | [NAME] | 3 |  | 3
1359798 | [NAME] | 10341815 | 2024-4Q | 2024/11 | 1 |  |  |  | Fanny | 0 |  | 0
1359798 | [NAME] | 10341819 | 2024-4Q | 2024/11 | 0 |  |  |  | George | 1 |  | 1
1422173 | [NAME] | 10341334 | 2024-4Q | 2024/11 | 1 |  |  |  | [NAME] | 0 |  | 0
1422173 | [NAME] | 10341814 | 2024-4Q | 2024/11 | 0 |  |  |  | Kelly | 0 |  | 0
1417558 | Fanny | 10340506 | 2024-4Q | 2024/11 | 0 |  |  |  | [NAME] | 2 |  | 2
1427137 | Fanny | 10341574 | 2024-4Q | 2024/11 | 0 |  |  |  | [NAME] | 3 |  | 3
1032860 | George | 10340483 | 2024-4Q | 2024/11 | 1 |  |  |  | [NAME] | 3 |  | 3
1032860 | George | 10341714 | 2024-4Q | 2024/11 | 1 |  |  |  | [NAME] | 2 |  | 2
1053487 | [NAME] | 10339831 | 2024-4Q | 2024/11 | 0 |  |  |  | Shelly | 2 |  | 2
1388526 | Kelly | 10340211 | 2024-4Q | 2024/11 | 0 |  |  |  | [NAME] | 1 |  | 1
1388526 | Kelly | 10341542 | 2024-4Q | 2024/11 | 0 |  |  |  | Grand Total | 18
1000499 | [NAME] | 10341582 | 2024-4Q | 2024/11 | 1
1032874 | [NAME] | 10340323 | 2024-4Q | 2024/11 | 0
1379008 | [NAME] | 10341578 | 2024-4Q | 2024/11 | 1
1395771 | [NAME] | 10340963 | 2024-4Q | 2024/11 | 1
1395771 | [NAME] | 10341067 | 2024-4Q | 2024/11 | 1
1403510 | [NAME] | 10341732 | 2024-4Q | 2024/11 | 1
1423740 | [NAME] | 10340357 | 2024-4Q | 2024/11 | 1
1429002 | [NAME] | 10340358 | 2024-4Q | 2024/11 | 0
1046933 | [NAME] | 10341055 | 2024-4Q | 2024/11 | 1
1046933 | [NAME] | 10341132 | 2024-4Q | 2024/12 | 1
1358709 | [NAME] | 10342012 | 2024-4Q | 2024/11 | 0
1391956 | [NAME] | 10341623 | 2024-4Q | 2024/11 | 1
1365420 | [NAME] | 10339878 | 2024-4Q | 2024/11 | 1
1365420 | [NAME] | 10340129 | 2024-4Q | 2024/11 | 1
1365420 | [NAME] | 10340585 | 2024-4Q | 2024/12 | 1
1365420 | [NAME] | 10341904 | 2024-4Q | 2024/12 | 1
1397903 | Shelly | 10341780 | 2024-4Q | 2024/11 | 1 |  |  |  | distictcount [ContactID] for each [Year-Month] where [Within 3 days] =1
1429685 | Shelly | 10342049 | 2024-4Q | 2024/12 | 1
1398005 | [NAME] | 10341192 | 2024-4Q | 2024/11 | 1
1398005 | [NAME] | 10341193 | 2024-4Q | 2024/11 | 1
Spreadsheet: 7620f5df-a44e-43c7-99b7-6139c07423df
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | Mitchelson | [NAME] | [EMAIL] | [PHONE] | [PHONE] | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University | Young | Jon | [EMAIL] | [PHONE] | [PHONE] | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Whitehead, Jr. | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | Akinleye | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Arden | Warwick | [EMAIL] | [PHONE] | [PHONE] |  |  | Raleigh | NC | 27695
UNC Asheville | Urgo | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Chapel Hill | NC | 27599
UNC Charlotte | Lorden | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | Dunn | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Post Office Box 26170 |  | Greensboro | NC | 27402
UNC Pembroke | Kitts | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Battles | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University | Morrison-Shetlar | [NAME] | [EMAIL] | [PHONE] |  |  |  | Cullowhee | NC | 28723
Winston-Salem State University | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics | Warshaw | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: rick_buy__32789__Risk Pool Report Template091701
Sheet: Current Risk Pool

EIM RISK POOL
as of 9/17/2001
 |  |  |  |  | Exposure
 | COUNTERPARTY NAME | TRADER / ORIGINATOR | DEAL DATE | Credit Approved Exposure | A/R | MTM | Committed | Total Risk Pool Exposure | Total Counterparty Exposure | COMMENTS
 | [NAME], Inc. | [NAME] | 2001-07-06 00:00:00 | 50000 | 78115 | 0 | 0 |  |  | Placed in Risk Pool because exposure exceeded credit line of $50,000 approved for customer & customer is past due on invoices.
 | Linden Trading Company, Inc. | [NAME] | 2001-07-27 00:00:00 | 100000 | 84593 | 0 | 0 |  |  | Placed in Risk Pool because credit line of $100,000 was used up by prior transactions & customer still has outstanding receivables on them.
 | Stellar Printing Inc. | [NAME] | 2001-08-03 00:00:00 | 100000 | 393043 | 0 | 0 |  |  | Placed in Risk Pool because exposure exceeded credit line of $100,000 approved for customer & credit is awaiting financials.
 | Michigan Web Offset | [NAME] | 2001-08-22 00:00:00 | 0 | 0 | 1360 | 21000 |  |  | Placed in Risk Pool because customer has poor payment history.
 | Enterprise NewsMedia, Inc. | [NAME] | 2001-08-30 00:00:00 | 400000 | 132135 | 485199 |  |  |  | Placed in Risk Pool because exposure exceeded credit line of $400,000 approved for customer.
 | Tribune Review Publishing Company | [NAME] | 2001-09-07 00:00:00 | 100000 | 0 | 0 | 99000 |  |  | Placed in Risk Pool because exposure exceeded credit line of $100,000 approved for customer.
 | Asia Pacific Resources International Holdings Ltd. | Om Bhatia | 2001-09-12 00:00:00 | 0 | 0
 | [NAME] | [NAME] | 2001-09-14 00:00:00 | 100000 | 0 | 0 | 9380 |  |  | Placed in Risk Pool because exposure exceeded credit line of $100,000 approved for customer.
 | Casey Printing | [NAME] | 2001-09-17 00:00:00 | 100000 | 0 | 0 | 22640 |  |  | Placed in Risk Pool because exposure exceeded credit line of $100,000 approved for customer.
Total Forest Products
Remaining Forest Products Risk Pool Balance
Steel
 | JIT | [NAME] | 2001-07-16 00:00:00 | 0 | 258235 | 5310 | 0 |  |  | Transaction in full has been placed in the Risk Pool because credit did not approve transacton, CP has credit issues.  This shipment was delivered to the CP before a dealt ticket was issued.
 | Metron Steel, division of Primary Steel | [NAME] | 2001-07-31 00:00:00 | 25000 | 0 |  |  |  |  | Transaction placed in the Risk Pool because it exceeds credit line of $25,000 by $11,000.
 | Ispat Karmat | London/Bruce Garner | July | 0 |  |  | 1100000 |  |  | Enron has posted a documentary LC by which Enron is exposed to 80% of it's value is paid prior to physical receipt of steel.
 | Sunbelt Steel | [NAME] | 2001-08-13 00:00:00 | 2000000 | 952742 | 12566 | 0 |  |  | Transaction exceeds credit line.  It has been place into the risk pool entirely.  We have outstandon receivables with this Couonterparty of $900K
 | Steel Coil Services | [NAME] | 2001-08-27 00:00:00 | 100000 | 0 | 0 |  | 143750 |  | Transaction exceeds credit line. I$143,750 in excess of credit line have been placed in risk pool
Total Steel
Remaining Steel Risk Pool Balance
Spreadsheet: 736969d1623988380-copy-selected-data-to-different-sheets-grant-management-latest-detailed
Sheet: 29000

 | Persidangan |  |  |  |  |  |  |  | Penerbitan |  |  |  |  |  |  |  | Bengkel |  |  |  |  |  |  |  | Upah
 | Bil. | tarikh | Jenis tuntutan /pembayaran | No resit  (jika ada) | Bil. unit | Harga seunit | [NAME] |  | Bil. | tarikh | Jenis tuntutan /pembayaran | No resit  (jika ada) | Bil. unit | Harga seunit | [NAME] |  | Bil. | tarikh | Jenis tuntutan /pembayaran | No resit  (jika ada) | Bil. unit | Harga seunit | [NAME] |  | Bil. | tarikh | Jenis tuntutan /pembayaran | No resit  (jika ada) | Bil. unit | Harga seunit | [NAME]
Spreadsheet: 3382308c-a11e-44da-83ef-d94ed21ee737
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40897497 | 2014-04-08 09:14:26 | ALLIES | 1 | 6 | 0 | 1024653 | [NAME] | 12508 | pacific | 1942-08-20 | 1942-08-21 | Tenaru | Tenaru
40925788 | 2014-04-10 10:56:49 | ALLIES | 1 | 6 | 2 | 1024653 | [NAME] | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
40931800 | 2014-04-10 21:11:05 | ALLIES | 1 | 6 | 3 | 901544 | manu76 | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40932203 | 2014-04-10 21:39:41 | AXIS | 0 | 3 | 6 | 901544 | manu76 | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
Spreadsheet: 167845d1342117617-list-of-names-from-duplicate-data-take-first-word-of-cell-only-test-table
Sheet: Sheet1

PASTE DATA BELOW THIS LINE |  |  |  |  |  | Name | Instances
 | Adam |  |  |  |  | Adam | 7
 | Adam
 | Adam
 | Adam
 | Adam
 | Adam
 | Adam
 | [NAME] |  |  |  |  | [NAME] | 8
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] |  |  |  |  | [NAME] | 3
 | [NAME]
 | [NAME]
 | [NAME] |  |  |  |  | [NAME] | 7
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] |  |  |  |  | [NAME] | 8
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] |  |  |  |  | [NAME] | 3
 | [NAME]
 | [NAME]
Spreadsheet: 675174d1588182886-using-pivot-tables-and-extracting-proper-columns-when-double-clicking-2020-04-29-oeldere2-althepal78-pt-675097d1588163486-using-pivot-tables-and-extracting-proper
Sheet: MAIN TABLE

Position | RANK | LNAME | FNAME | RIFLE DATE | Rifle Needs | SWIM DATE | Years To Take | Swim Needs
 | CAP | OAKLEY | [NAME] | 2019-01-06 00:00:00 |  | 2019-01-06 00:00:00 | 3
 | 1LT | XAVIER | [NAME] | 2019-02-04 00:00:00 |  | 2012-02-04 00:00:00 | 1
 | 2LT | MAGNUS | ULTRA | 2019-02-04 00:00:00 |  | 2019-02-04 00:00:00 | 3
 | GYSGT | PRIME | AUTOMUS | 2019-09-07 00:00:00 |  | 2019-09-07 00:00:00 | 4
 | SSGT | BEE | BUMBLE | 2019-01-06 00:00:00 |  | 2019-01-06 00:00:00 | 2
 | SGT | MORRIS | NATHANIEL | 2018-02-05 00:00:00 |  | 2018-02-05 00:00:00 | 3
 | SGT | [NAME] | [NAME] | 2017-06-19 00:00:00 |  | 2017-06-19 00:00:00 | 2
 | CPL | EWING | PATRICK | 2019-02-19 00:00:00 |  | 2019-02-19 00:00:00 | 3
 | CPL | WITHERSPOON | REESE | 2017-06-19 00:00:00 |  | 2017-06-19 00:00:00 | 2
 | [NAME] | CUPPERPUT | CHESTER | 2019-09-07 00:00:00 |  | 2019-09-07 00:00:00 | 4
 | [NAME] | MASON | ANTHONY | 2018-02-05 00:00:00 |  | 2018-02-05 00:00:00 | 1
 | [NAME] | STARKS | [NAME] | 2019-02-20 00:00:00 |  | 2019-02-20 00:00:00 | 3
 | PFC | AMERICA | CAPTAIN | 2014-05-14 00:00:00 |  | 2014-05-14 00:00:00 | 1
 | PFC | [NAME] | BLACK | 2019-02-18 00:00:00 |  | 2019-02-18 00:00:00 | 2
 | PVT | BANNER | BRUCE | 2018-07-16 00:00:00 |  | 2015-10-20 00:00:00 | 3
 | PVT | JONES | JESSICA | 2018-10-28 00:00:00 |  | 2018-10-20 00:00:00 | 4
 | PVT | STARKS | [NAME] | 2019-02-15 00:00:00 |  | 2019-02-15 00:00:00 | 2
Spreadsheet: phillip_m_love__30657__9911_OA
Sheet: TX-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | 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 |  |  |  |  |  |  |  | 0
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
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 |  |  |  |  |  |  |  | 0
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 |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 698831d1602191653-need-help-with-if-and-and-else-formula-rate-plan-cleanup
Sheet: Hotel 16

Rate Center Audit / 2021 CleanUp
Hotel | LNRs | Rate Plans | Rate Buckets | BAR 2021-2024 | Selling Limit Buckets | GTD/CXL Policies | STAR compset | Special Event Review | CTA/LOS settings | check in Feb 2021 SED LFF TIERS
site num
AUDIT NOTES
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A22

TABLE A22 FREQUENCY OF PRICE SPIKES IN CALIFORNIA ISO LOAD REPLACEMENT MARKET SP15
PRICE EQUALS OR EXCEEDS | FY 00/99 | FY 99/98
 | # of hours
 | % of available hours
100 | 147 | 142
 | 0.0167 | 0.0162
250 | 83 | 61
 | 0.00945 | 0.00696
500 | 64 | 0
 | 0.00729 | 0
750 | 10 | 0
 | 0.00114 | 0
1000 | 0 | 0
 | 0 | 0
Source: CAISO website (www.caiso.com)
FY 00/99: 8/1/1999-7/31/2000
FY 99/98: 8/1/1998-7/31/1999
Spreadsheet: 115554d1311116048-counting-with-conditions-recontest
Sheet: Sheet2

400831669 | CAR |  |  |  | REJECTED | PROCESSED
400831670 | CAR |  |  | CAR | 2 | 11
400831671 | CAR |  |  | TRUCK | 3 | 9
400831672 | CAR
400831673 | CAR |  |  |  | *I need a formula that would display these results
400831674 | CAR |  |  |  | *Their status is on another worksheet so I'm having a hard time working on a formula
400831675 | CAR
400831676 | CAR
400831677 | CAR
400831678 | CAR
400831679 | CAR
400831680 | CAR
400831681 | CAR
400831682 | TRUCK
400831683 | TRUCK
400831684 | TRUCK
400831685 | TRUCK
400831686 | TRUCK
400831687 | TRUCK
400831688 | TRUCK
400831689 | TRUCK
400831690 | TRUCK
400831691 | TRUCK
400831692 | TRUCK
400831693 | TRUCK
Spreadsheet: 69816d1270492228-gain-loss-on-account-data-accounting-data
Sheet: Sheet1

 | Account Summary
 | Starting Balance | Day1 | Day2 | Day3 | Day4 | Day5
Account 1 | 500 | 1000 | 300 |  | 500 | 1000
Account 2 | 300 |  | 600 | 100
Account 3 | 1000 |  | 1500 | 2000
Account 4 | 200 |  | -500 | -200
Account 5 | 300 |  | 800
 | Increase / Decrease on Account
 | Starting Balance | Day1 | Day2 | Day3 | Day4 | Day5
Account 1 | 500
Account 2 | 300
Account 3 | 1000
Account 4 | 200
Account 5 | 300
Spreadsheet: gerald_nemec__11416__Equity valuation - for condor
Sheet: summary

 | Fort  Union Gas Gathering and Lost Creek Gas Gathering
 | Valuation Summary
 |  | Fort Union Gas Gathering
 |  | NPV EBITDAs yrs. 1 - 5
 |  | Fort Union Terminal Value
 |  | 2005 Cash Flow: |  | 7728720.25932737
 |  | Steady State Period (Years) |  | 10
 |  | Annual Decline Rate after steady-state period |  | 0.3
 |  | TOTAL FUGG
 |  | ENA % |  |  |  |  | 42700000
 |  | Lost Creek Gas Gathering
 |  | NPV EBITDAs yrs. 1 - 5
 |  | Lost Creek Terminal Value
 |  | 2005 Cash Flow:
 |  | Steady State Period (Years) |  | 10
 |  | Annual Decline Rate after steady-state period |  | 0.3
 |  | TOTAL LCGG |  |  |  |  | 26599730
 |  | ENA %
Spreadsheet: 716017d1611970638-nested-ifs-performance-matrix-ef1503_nested-ifs-formulae-
Sheet: Matrix_1

 |  |  |  |  |  | Performance Range Matrix
 |  | TABLE A |  |  |  | TABLE B |  |  |  | TABLE C |  |  |  | TABLE D |  |  |  | TABLE E
 |  | < Range > |  | Result |  | < Range > |  | Result |  | < Range > |  | Result |  | < Range > |  | Result |  | < Range > |  | Result
 | Between | 64.8 | 72 |  |  | 63.9 | 71 |  |  | 50.32 | 62.9 |  |  | 39.456 | 49.32 |  |  | 30.7648 | 38.456
 | This number changes
 | Start here | 72
 |  | Current formulae does not work |  |  |  | =IF($C$12>=C6, $C$12, IF($C$12>=G6,$C$12, IF($C$12>=K6,$C$12,IF($C$12>=O6,$C$12,IF($C$12>=S6,$C$12,"")))))
 | Example - Expected Outcome
 | Start Here No  >>>>>>>>>>>>>>>> |  |  | 67 |  |  |  | 70 |  |  |  | 54 |  |  |  | 44 |  |  |  | 33
 | (as woule be entered in C12)
 |  | < Range > |  | Result
 | Reslt in Yellow | 64.8 | 72 | 67
 |  |  |  |  |  | < Range > |  | Result
 |  |  |  |  |  | 63.9 | 71 | 70
 |  |  |  |  |  |  |  |  |  | < Range > |  | Result
 | Only one [NAME] will present a vaue based on the input in C12 |  |  |  |  |  |  |  |  | 50.32 | 62.9 | 54
 |  |  |  |  |  |  |  |  |  |  |  |  |  | < Range > |  | Result
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 39.456 | 49.32 | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < Range > |  | Result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30.7648 | 38.456 | 33