Spreadsheet: chris_stokley__3840__Mock Table to Sort Data
Sheet: Cust Extract

SETLMT_ENTITY_CD | Prod_mo | COUNTERPARTY_SHORT_NM | TRANSACTION_TYPE_CD | LEDGER_DT | SumOfSETLMT_AMT | Revenue/Expense | Absolute Value
CAISO | 08/2000 |  | E | 2000-08-01 00:00:00 | 0
CAISO | 08/2000 | ARCO | A | 2000-11-01 00:00:00 | -509867.297109888
CAISO | 08/2000 | ARCO | E | 2000-08-01 00:00:00 | -320469.6353651436
CAISO | 08/2000 | AVISTA-WWP | A | 2000-11-01 00:00:00 | -1472096.917913446
CAISO | 08/2000 | AVISTA-WWP | E | 2000-08-01 00:00:00 | -1501920.972376046
CAISO | 08/2000 | AVISTA-WWP | M | 2000-11-01 00:00:00 | -0.0002
CAISO | 08/2000 | CRC | A | 2000-11-01 00:00:00 | -4673.718513340001
CAISO | 08/2000 | CRC | E | 2000-08-01 00:00:00 | -4731.588586659999
CAISO | 08/2000 | CSU | A | 2000-11-01 00:00:00 | -27063.6993
CAISO | 08/2000 | CSU | E | 2000-08-01 00:00:00 | -23223.0759654
CAISO | 08/2000 | DELANO | A | 2000-11-01 00:00:00 | -162511.5551748191
CAISO | 08/2000 | DELANO | E | 2000-08-01 00:00:00 | -11913.93819049259
CAISO | 08/2000 | DELANO | M | 2000-11-01 00:00:00 | -0.3222
CAISO | 08/2000 | ECTltCA | A | 2000-11-01 00:00:00 | -1895430.352583461
CAISO | 08/2000 | ECTltCA | E | 2000-08-01 00:00:00 | -1897727.01185346
CAISO | 08/2000 | ECTltNW | A | 2000-11-01 00:00:00 | -4977084.755950647
CAISO | 08/2000 | ECTltNW | E | 2000-08-01 00:00:00 | -4915869.824058495
CAISO | 08/2000 | ECTltNW | M | 2000-11-01 00:00:00 | -151.9672
CAISO | 08/2000 | ECTltSW | A | 2000-11-01 00:00:00 | -8645894.933636002
CAISO | 08/2000 | ECTltSW | E | 2000-08-01 00:00:00 | -8628297.983451692
CAISO | 08/2000 | ECTltSW | M | 2000-11-01 00:00:00 | -21025.66930000003
CAISO | 08/2000 | ECTltWM | A | 2000-11-01 00:00:00 | -3386942.394206728
CAISO | 08/2000 | ECTltWM | E | 2000-08-01 00:00:00 | -3427464.47675192
CAISO | 08/2000 | ECTltWM | M | 2000-11-01 00:00:00 | 2518.429
CAISO | 08/2000 | ECTltWTTRA | A | 2000-11-01 00:00:00 | -7571151.975360575
CAISO | 08/2000 | ECTltWTTRA | E | 2000-08-01 00:00:00 | -7581439.68900557
CAISO | 08/2000 | ECTRT | A | 2000-11-01 00:00:00 | -6318186.279391249
CAISO | 08/2000 | ECTRT | E | 2000-08-01 00:00:00 | -4808363.325729039
CAISO | 08/2000 | ECTRT | M | 2000-11-01 00:00:00 | 461.524899999997
CAISO | 08/2000 | ECTstBOM | A | 2000-11-01 00:00:00 | -925772.3479621517
CAISO | 08/2000 | ECTstBOM | E | 2000-08-01 00:00:00 | -744692.6508864326
CAISO | 08/2000 | ECTstBOM | M | 2000-11-01 00:00:00 | -13345.122
CAISO | 08/2000 | ECTstCA | A | 2000-11-01 00:00:00 | -40608637.35150415
CAISO | 08/2000 | ECTstCA | E | 2000-08-01 00:00:00 | -49476157.75246517
CAISO | 08/2000 | ECTstCA | M | 2000-11-01 00:00:00 | 1439.6987
CAISO | 08/2000 | ECTstCA2 | A | 2000-11-01 00:00:00 | -11205103.0406692
CAISO | 08/2000 | ECTstCA2 | M | 2000-11-01 00:00:00 | 52.88560000000001
CAISO | 08/2000 | ECTstNW | A | 2000-11-01 00:00:00 | -10046438.46272827
CAISO | 08/2000 | ECTstNW | E | 2000-08-01 00:00:00 | -9995407.540979233
CAISO | 08/2000 | ECTstNW | M | 2000-11-01 00:00:00 | 508.2214999999999
CAISO | 08/2000 | ECTstSW | A | 2000-11-01 00:00:00 | -7364249.094296836
CAISO | 08/2000 | ECTstSW | E | 2000-08-01 00:00:00 | -7293646.019850668
CAISO | 08/2000 | ECTstSW | M | 2000-11-01 00:00:00 | -19095.77279999997
CAISO | 08/2000 | EES | A | 2000-11-01 00:00:00 | 2048225.500206242
CAISO | 08/2000 | EES | E | 2000-08-01 00:00:00 | 3712088.315920292
CAISO | 08/2000 | EES | M | 2000-11-01 00:00:00 | 366094.2946000018
CAISO | 08/2000 | [NAME] | A | 2000-11-01 00:00:00 | -237465.6597470619
CAISO | 08/2000 | EES_2 | A | 2000-11-01 00:00:00 | -328071.1495965643
CAISO | 08/2000 | EES_3 | A | 2000-11-01 00:00:00 | -99985.95914780635
CAISO | 08/2000 | EPE | A | 2000-11-01 00:00:00 | -135420.15200535
CAISO | 08/2000 | EPE | E | 2000-08-01 00:00:00 | -128009.8943242002
CAISO | 08/2000 | EPE | M | 2000-11-01 00:00:00 | -0.0001
CAISO | 08/2000 | EWEB | A | 2000-11-01 00:00:00 | -418907.6326468066
CAISO | 08/2000 | EWEB | E | 2000-08-01 00:00:00 | -456758.5614749878
CAISO | 08/2000 | HARBOR | A | 2000-11-01 00:00:00 | -2033138.063062862
CAISO | 08/2000 | HARBOR | E | 2000-08-01 00:00:00 | -2017988.151235902
CAISO | 08/2000 | HARBOR | M | 2000-11-01 00:00:00 | 0.07400000000000001
CAISO | 08/2000 | LP | A | 2000-11-01 00:00:00 | -18736.94162960656
CAISO | 08/2000 | LV COGEN | A | 2000-11-01 00:00:00 | 1540.86781169096
CAISO | 08/2000 | LV COGEN | E | 2000-08-01 00:00:00 | 2239.702211690959
CAISO | 08/2000 | PAC | A | 2000-11-01 00:00:00 | -81260.8399470667
CAISO | 08/2000 | PGES | A | 2000-11-01 00:00:00 | -8467027.393338874
CAISO | 08/2000 | PGES | E | 2000-08-01 00:00:00 | 2168131.824430301
CAISO | 08/2000 | PGES | M | 2000-11-01 00:00:00 | 951313.4324000023
CAISO | 08/2000 | SAGUARO | A | 2000-11-01 00:00:00 | -8.057560015650722e-05
CAISO | 08/2000 | SAGUARO | E | 2000-08-01 00:00:00 | -51.27448057560017
CAISO | 08/2000 | SCL | A | 2000-11-01 00:00:00 | -2670446.338186482
CAISO | 08/2000 | SCL | E | 2000-08-01 00:00:00 | -2158588.27264763
CAISO | 08/2000 | SCL | M | 2000-11-01 00:00:00 | -151.0001
CAISO | 08/2000 | SNOHOMISH | A | 2000-11-01 00:00:00 | -2852.65
CAISO | 08/2000 | SNOHOMISH | E | 2000-08-01 00:00:00 | -2822.44372078
CAISO | 08/2000 | TACOMA | A | 2000-11-01 00:00:00 | -395694.3005032823
CAISO | 08/2000 | TACOMA | E | 2000-08-01 00:00:00 | -382163.2066108731
CAISO | 08/2000 | TOSCO | A | 2000-11-01 00:00:00 | -71686.37909878242
CAISO | 08/2000 | TOSCO | E | 2000-08-01 00:00:00 | 110191.1178485033
CAISO | 08/2000 | TOSCO | M | 2000-11-01 00:00:00 | 0.075
CAISO | 08/2000 | TRANSALTA | A | 2000-11-01 00:00:00 | -89427.22489999999
CAISO | 08/2000 | TRANSALTA | E | 2000-08-01 00:00:00 | -93572.1
CAISO | 08/2000 | VEA | A | 2000-11-01 00:00:00 | -385591.1017157599
CAISO | 08/2000 | VEA | E | 2000-08-01 00:00:00 | -390152.9838718715
CAISO | 08/2000 | VEA | M | 2000-11-01 00:00:00 | -64.0827
CAISO | 08/2000 | Wheelabrat | A | 2000-11-01 00:00:00 | -384967.4589911751
CAISO | 08/2000 | Wheelabrat | E | 2000-08-01 00:00:00 | -377809.9391882428
CAISO | 08/2000 | Wheelabrat | M | 2000-11-01 00:00:00 | 0.0009
CAISO | 08/2000 | WheelSHAST | A | 2000-11-01 00:00:00 | -15389.93981257276
CAISO | 08/2000 | [NAME] | A | 2000-11-01 00:00:00 | -5643.34138811718
CAISO | 08/2000 | [NAME] | E | 2000-08-01 00:00:00 | -5730.677394171518