tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 779804d1652110509-sum-two-or-more-columns-based-on-single-or-more-criteria-working-sum-aligw
Sheet: Entities (2)

 |  | Vessel | S/O Company | Bank balances as of 31.03.2021
 |  |  |  |  | Requested sum
98 | 1 | Tasman | Tasman Marine LLC
A6 | 2 | Dimitris Y | Hudson Marine LLC
A7 | 3 | [NAME] | Drake Marine LLC
T148 | 4 | MSC Qingdao | Global Ship Lease 52 LLC
T149 | 5 | GSL Matisse (Sold Vessel) | Global Ship Lease 37 LLC
T150 | 6 | GSL Ningbo | Global Ship Lease 43 LLC
T151 | 7 | CMA CGM Utrillo (Sold Vessel) | Global Ship Lease 39 LLC
T152 | 8 | CMA CGM Jamaica | Global Ship Lease 50 LLC
T153 | 9 | CMA CGM America | Global Ship Lease 51 LLC
T154 | 10 | CMA CGM Berlioz | Global Ship Lease 48 LLC
T155 | 11 | CMA CGM Alcazar | GSL Alcazar Inc.
T156 | 12 | CMA CGM Thalassa | Global Ship Lease 54 LLC
T157 | 13 | [NAME] | Global Ship Lease 44 LLC
T158 | 14 | CMA CGM Chateau d' If | Global Ship Lease 47 LLC
T159 | 15 | CMA CGM Sambhar | Global Ship Lease 49 LLC
T160 | 16 | [NAME] | Global Ship Lease 40 LLC
T161 | 17 | Kumasi | Global Ship Lease 45 LLC
T162 | 18 | [NAME] | Global Ship Lease 41 LLC
T163 | 19 | [NAME] | Global Ship Lease 38 LLC
T165 | 20 | MSC Tianjin | Global Ship Lease 53 LLC
T166 | 21 | GSL La Tour | Global Ship Lease 46 LLC
T184 | 22 | GSL Christen (ex NYK Lynx) | Global Ship Lease 36 LLC
T185 | 23 | GSL Nicoletta (ex NYK Libra) | Global Ship Lease 35 LLC
Spreadsheet: 876296d1722974168-attendance-tracking-with-occurrence-points-over-6-month-rolling-period-attendance-tracker
Sheet: March

 | 2024-03-01 00:00:00
 |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  | Weekends
 | V | S | U | N | T | L
Employee | Vacation | Sick | Unexcused | NC-NS | Tardy | Late Return | Total Points
Spreadsheet: 1c3d9950-0a75-4c1d-8b02-475658707053
Sheet: Sheet1

Table 4--U.S. fiber demand | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Feb. | Mar. | Apr. |  | Apr.
Item | 2013 | 2013 | 2013 |  | 2012
 | 1,000 480-lb. [NAME]
Cotton:
All consumed by mills 1/ | 281 | 304 | 305 |  | 234
Total since August 1 | 1976 | 2280 | 2584 |  | 2446
Daily rate | 14.1 | 14.5 | 13.9 |  | 11.1
Upland consumed by mills 1/ | 280 | 302 | 303 |  | 233
Total since August 1 | 1967 | 2269 | 2572 |  | 2433
Daily Rate | 14 | 14.4 | 13.8 |  | 11.1
Upland exports | 1733 | 1492 | 1494 |  | 1221
Total since August 1 | 6604 | 8097 | 9590 |  | 8083
Sales for next season | 368 | 293 | 229 |  | 245
Total since August 1 | 977 | 1270 | 1499 |  | 1151
Extra-long staple exports | 66 | 85.9 | 87.4 |  | 66.4
Total since August 1 | 434.1 | 520 | 607.5 |  | 457.4
Sales for next season | 35.3 | 18.8 | 4.1 |  | 5.2
Total since August 1 | 39.8 | 58.6 | 62.7 |  | 47.2
 | Jan. | Feb. | Mar. |  | Mar.
 | 2013 | 2013 | 2013 |  | 2012
 | Million pounds
Manmade:
Raw fiber exports | 51.2 | 53.1 | 54.6 |  | 59.8
Noncellulosic | 50.7 | 52.5 | 54.2 |  | 59.3
Cellulosic | 0.5 | 0.6 | 0.4 |  | 0.5
Total since January 1 | 51.2 | 104.3 | 158.9 |  | 168
Total since January 1
 | 1,000 pounds
Wool and mohair:
Raw wool exports, clean | 665.2 | 1016.2 | 772.8 |  | 873.5
Total since January 1 | 665.2 | 1681.4 | 2454.2 |  | 1475
Wool top exports | 232.8 | 198.4 | 183.1 |  | 55.8
Total since January 1 | 232.8 | 431.2 | 614.3 |  | 97.5
Mohair exports, clean | 1.7 | 0 | 2.3 |  | 42.2
Total since January 1 | 1.7 | 1.7 | 4 |  | 42.2
1/  Estimated by USDA.
Sources: USDA, Farm Service Agency; USDA, Foreign Agricultural Service,
U.S. Export Sales; U.S. Dept. of Commerce, U.S. Census Bureau; and [NAME].
Last update: 06/14/13.
Spreadsheet: errol_mclaughlin_jr__10066__Bkrqs777
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | Book Request # 777
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  | Type Of Transactions |  |  | Book Mapping
Short Name | [NAME] | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
LT-PLANT-HDG | Long Term Plant Hedge | X |  |  | =P | DESK |  | X |  |  |  | NG/MMBTU/USD | [NAME] | MTM | [NAME] | ASAP
FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  | I7 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  | I8 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
FIN-ECTI-ST | Financial ECTI-ST |  |  |  | I3 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  | QM | DESK | X | - | - | - |  | TN10/CNTR/USD
UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  | V# | DESK | X | - | - | - |  | TN10/CNTR/USD
(Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag.
*A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
***Please provide login names for book administrators.***
IT SECURITY | Book |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
Access List | Administrator*
trohaue | [NAME] |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC |  | Y | JV
emclaug |  |  |  |  |  |  |  |  |  |  |  | Hierarchy |  | Y | JV
[NAME] |  |  |  |  |  |  |  |  |  |  |  | Master booklist |  | Y | JV
kloibl |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP |  | Y | JV
bbajwa |  |  |  |  |  |  |  |  |  |  |  | Sent to TAGG/ERMS |  | Y | JV
spalmer |  |  |  |  |  |  |  |  |  |  |  | Active/Inactive Book List
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Any questions, please contact me:
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x52526)
Spreadsheet: 80520d1280760769-updating-monthly-total-test1
Sheet: January

Items | Requested | Total
A | 1 | 1
B | 2 | 2
F | 3 | 3
H | 4 | 4
Y | 5 | 5
Z | 6 | 6
M | 7 | 7
P | 8 | 8
 | 9 | 9
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Spreadsheet: 275205d1383392651-how-to-findout-missing-service-between-a-and-b-column-compare-findout-missing-service_winon_rev_b
Sheet: Sheet2

Customer Requested |  |  |  |  | Given services |  |  |  |  | SERVICE/S NOT GIVEN | REMARK/S
Service 1 | Service 2 | Service 3 | Service 4 | Service 5 | Service 1 | Service 2 | Service 3 | Service 4 | Service 5
MI_C_V_199_30d_D2GB_FU_2G |  |  |  |  | MI_C_V_199_30D_R2GB_FU_2G | www|portalnmms|iphone |  |  |  |  | Service given. [NAME]
V2O@30P(BR50p)@Rs.30 | [NAME]) |  |  |  | V2O@30P(BR50p)@Rs.30 | VF2VF-10p(BR-30)Rs.48 |  |  |  |  | Check Service!
 |  |  |  |  | 3G Service Rental
V2O@30P(BR50p)@Rs.30 |  |  |  |  | V2O@30P(BR50p)@Rs.30
VF2VF-10p(BR-30)Rs.48 | V2O@30P(BR50p)@Rs.30 |  |  |  | V2O@30P(BR50p)@Rs.30 | VF2VF-10p(BR-30)Rs.48
 |  |  |  |  | 3G Service Rental
MI_C_V_199_30d_D2GB_FU_2G |  |  |  |  | MI_C_V_199_30D_R2GB_FU_2G | portalnmms|www|iphone |  |  |  |  | customer requested service already given, see given service
V2O@30P(BR50p)@Rs.30 |  |  |  |  | V2O@30P(BR50p)@Rs.30
V2O@30P(BR50p)@Rs.30 |  |  |  |  | V2O@30P(BR50p)@Rs.30
V2O@30P(BR50p)@Rs.30 |  |  |  |  | V2O@30P(BR50p)@Rs.30 | [NAME]
 |  |  |  |  | 3G Service Rental
V2O@30P(BR50p)@Rs.30
Spreadsheet: darrell_schoolcraft__7319__imball0202
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 182397 | 183686 |  | -2731 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 175528 | 177265 |  | -2777 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 182010 | 183753 |  | -2998 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 180954 | 183876 |  | -2864 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 177596 | 179509 |  | -3150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 173864 | 175668 |  | -2646 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 191389 | 193580 |  | -2646 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 200987 | 204150 |  | -2646 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 167359 | 168959 |  | -2646 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 167917 | 168981 |  | -2646 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2002-01-31 00:00:00 |  |  |  | -35191
 | 2002-02-10 00:00:00
 | CBS Dollars
 |  |  |  | -533965.98
Spreadsheet: 745067d1629723206-help-with-nested-vlookup-and-hlookup-room-prices-aligw
Sheet: STAFF ROOMS

HOUSE | ROOM | PRICE |  |  |  |  | Compston | 1 | 2 | 3 | 4 | 5 |  |  |  | COMPSTON | KIRKWOOD | BRINWOOD
BRINWOOD | 1 |  |  |  |  |  |  | 70 | 80 | 90 | 100 | 110 |  |  |  | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2
 |  |  |  |  |  |  | Kirkwood | 1 | 2 | 3 | 4 | 5 | 6 |  |  | 3 | 3 | 3
 |  |  |  |  |  |  |  | 71 | 72 | 73 | 74 | 75 | 76 |  |  | 4 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5
 |  |  |  |  |  |  | Brinwood | 1 | 2 | 3 | 4 | 5 | 6 |  |  | 6 | 6 | 6
 |  |  |  |  |  |  |  | 72 | 73 | 74 | 75 | 76 | 77 |  |  |  | 7 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Spreadsheet: 6668fd87-7b59-4cd9-98ae-a02a8b67c99d
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
[NAME] | Test | [NAME] | Id, Histoplasma/Blastomyces PCR ([NAME] Only) | Id, Histoplasma/Blastomyces PCR |  |  |  |  |  |  | This test is for billing purposes only. This is not an orderable test. |  |  | This test is for billing purposes only. This is not an orderable test. |  |  |  | 2 | 87150 |  |  |  |  | Rochester
60214 | Test | 60214 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 87150 |  |  |  |  | Rochester
[NAME] | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 777039d1650093110-how-to-vlookup-table-array-with-wildcard-condition-lookup
Sheet: Sheet2

Table Array (Non-OGL) |  | AC Value | AC Format | Lookup Attribute | IG Lookup | สูตรสำหรับ OGL Format / ถ้าไม่ใช่ "" | สูตรสำหรับ Non_OGL Fix Value | FI AC | FI PRD
 |  | D* | DI | DI/FI ใช้ Symbol |  |  | [NAME] วางค่า / ถ้าไม่ใช่ ""
 |  | F* | FI | MM/RP/FX/GL ใช้ CTPY
 |  | M* | MM
 |  | R* | RP
 |  | Specific | FX |  |  | ถ้า AC & HKD, เปลียน บข, ถ้าไม่ใข่ ตัวเดิม
 |  | ที่เหลือ | GL
Spreadsheet: 43999d1242665561-need-formula-help-converting-military-time-in-time-card-abc-timecard
Sheet: OCTOBER

 | NAME: | xxx |  |  |  | EMPLOYEE #: |  | xxx |  | MONTH/YR: | 2009-10-01 00:00:00
 | Day | Date | Time In | Time Out | Time In | Time Out | REG HRS | Trng Hours | OT Hours | OT PAY | Comp Time | VAC Used | SICK Used | COMP Used | Sub
SEPT
 | Fri | 25 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 26 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 27 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 28 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 29 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 30 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
OCT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Thu | 1 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 2 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 3 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 4 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 5 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 6 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 7 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 8 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 9 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 10 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 11 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 12 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 13 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 14 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 15 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 16 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 17 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 18 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 19 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 20 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 21 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 22 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 23 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 24 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | TOTALS: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | OT Pay | C | V | S | CU
NOTES: |  |  |  |  |  |  |  |  |  | Vac |  | Sick |  | Comp
 |  |  |  |  |  |  |  |  | Balance Forward | 60 |  | 120 |  | 0
 |  |  |  |  |  |  |  |  | Used this month | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  | Accumulated |  |  |  |  | 0 |  | *
 |  |  |  |  |  |  |  |  | New Balance Forward | 60 |  | 120 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *this # includes time & a half
 |  |  |  |  |  |  |  | I CERTIFY THAT THE ABOVE HOURS ARE CORRECT.
Personal Day Off |  |  |  |  |  |  |  | EMPLOYEE: |  |  |  |  | DATE:
Initial for Pay ________ |  |  |  |  |  |  |  | SUPERVISOR: |  |  |  |  | DATE:
Spreadsheet: 839587d1692103051-cell-formatting-causing-vlookup-issues-ef1614_lookup-fails
Sheet: Sheet3

 | 575020001 |  | 10042057
 | 575024035 |  | 57507001
 | 575024036 |  | 575010001
 | 575024402 |  | 575020001
 | 575030005 |  | 575024035
 | 575030006 |  | 575024036
 | 575030006 |  | 575024402
 | 575030015 |  | 575030005
 | 575030016 |  | 575030006
 | 575030018 |  | 575030006
 | 575030034 |  | 575030015
 | 575030035 |  | 575030016
 | 575030038 |  | 575030018
 | 575030042 |  | 575030034
 | 575030044 |  | 575030035
 | 575032002 |  | 575030038
 | 575032004 |  | 575030042
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: summary

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Duke Energy Field Service SW |  |  |  | Dollar Valued | [NAME]
Duke Energy Trading &Mktg, L.L.C. |  |  |  | Dollar Valued | [NAME]
NNG |  |  |  | Dollar Valued | [NAME]
PNM |  |  |  | Dollar Valued | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
[NAME] |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
NGPL |  |  |  | Volumetric | [NAME]
[NAME] |  |  |  | Volumetric | [NAME]
Dominion Gas Ventures |  |  |  | Dollar Valued | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
Red Cedar |  |  |  | Volumetric | [NAME] |  |  |  |  |  | DEFS,LP | 23995 | -1023166 | Hobbs plant
[NAME] |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DEFS,LP | 22051 | -527215 | Artesia plant
Agave |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DEFS,LP | 22864 | -58339.66 | inactive
Amarillo Nat Gas |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DEFS,LP | 20379 | -51695.87 | inactive
El Paso Field Services |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DEFS,LP | 26357 | 44144.84 | inactive
Calpine |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DEFS,LP | 21544 | 61340.16 | inactive
Citizens-Griffith |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DEFS,LP | 24532 | -956477
El Paso |  |  |  | Volumetric | [NAME] |  |  |  |  |  | DEFSSW | 24268 | 1481856.66
[NAME] |  |  |  | Dollar Valued | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
CIG |  |  |  | Volumetric | [NAME] |  |  |  |  |  | DE T&M | 24693 | 275313.72
Continental |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DE T&M | 24361 | 811179.69
Lonestar |  |  |  | Volumetric | [NAME] |  |  |  |  |  | DE T&M | 21665 | 73449
Panhandle Eastern |  |  |  | Volumetric | [NAME] |  |  |  |  |  | DE T&M | 22664 | 23612
TransColorado |  |  |  | Dollar Valued | [NAME]
Receivable imbalances
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Duke Energy Field Services LP |  |  |  | Dollar Valued | [NAME]
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
MaVida/Richardson Gas Treating |  |  |  | Dollar Valued | [NAME]
Crosstex Energy Serv |  |  |  | Dollar Valued | [NAME]
EPFS / PG&E TX |  |  |  | Dollar Valued | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
WTG Gas Marketing |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: phillip_platter__31378__RT-STCA August
Sheet: Aug19

DATE | FERC FILE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | SUPPLY | MW PER HR | TOTAL MW | SCHEDULE ID | PRICE | MARKET | PRICE | FEES | CONG | A_S CHARGE | BASIS | FERC ADJ | ENPOWER DEALS | TMM | LINE LOSSES | P_L | FILE SOURCE | TAG NO
2001-08-19 00:00:00 |  |  | 1 | 1 |  | SP15 | EES | 52 |  |  | 33 | STCALI | 33 |  |  |  |  |  |  | 738636,738638 | 1
2001-08-19 00:00:00 |  |  | 2 | 2 |  | SP15 | EES | 52 | 35 |  | 33 | STCALI | 33 |  |  |  |  |  |  | 738636,738638 | 1
2001-08-19 00:00:00 |  |  | 3 | 3 |  | SP15 | EES | 52 |  |  | 33 | STCALI | 33 |  |  |  |  |  |  | 738636,738638 | 1
2001-08-19 00:00:00 |  |  | 4 | 4 |  | SP15 | EES | 52 |  |  | 33 | STCALI | 33 |  |  |  |  |  |  | 738636,738638 | 1
2001-08-19 00:00:00 |  |  | 5 | 5 |  | SP15 | EES | 52 |  |  | 33 | STCALI | 33 |  |  |  |  |  |  | 738636,738638 | 1
2001-08-19 00:00:00 |  |  | 6 | 6 |  | SP15 | EES | 52 |  |  | 33 | STCALI | 33 |  |  |  |  |  |  | 738636,738638 | 1
2001-08-19 00:00:00 |  |  | 7 | 7 |  | SP15 | EES | 52 |  |  | 33 | STCALI | 33 |  |  |  |  |  |  | 738636,738638 | 1
2001-08-19 00:00:00 |  |  | 8 | 8 |  | SP15 | EES | 52 |  |  | 33 | STCALI | 33 |  |  |  |  |  |  | 738636,738638 | 1
2001-08-19 00:00:00 |  |  | 9 | 9 |  | SP15 | EES | 52 |  |  | 33 | STCALI | 33 |  |  |  |  |  |  | 738636,738638 | 1
2001-08-19 00:00:00 |  |  | 10 | 10 |  | SP15 | EES | 28 |  |  | 33 | STCALI | 33 |  |  |  |  |  |  | 738636,738638 | 1
2001-08-19 00:00:00 |  |  | 10 | 10 |  | SP15 | CORAL | 24 |  |  | 38 | STCALI | 38 |  |  |  |  |  |  | 738637,738638 | 1
2001-08-19 00:00:00 |  |  | 11 | 11 |  | SP15 | EES | 3 |  |  | 33 | STCALI | 33 |  |  |  |  |  |  | 738636,738638 | 1
2001-08-19 00:00:00 |  |  | 11 | 11 |  | SP15 | CORAL | 49 |  |  | 39 | STCALI | 39 |  |  |  |  |  |  | 738637,738638 | 1
2001-08-19 00:00:00 |  |  | 12 | 20 |  | SP15 | CORAL | 52 |  |  | 39 | STCALI | 39 |  |  |  |  |  |  | 738637,738638 | 1
2001-08-19 00:00:00 |  |  | 21 | 21 |  | SP15 | RELIANT | 27 |  |  | 45 | STCALI | 45 |  |  |  |  |  |  | 738694,738638 | 1
2001-08-19 00:00:00 |  |  | 21 | 21 |  | SP15 | TRANSALTA | 25 |  |  | 45 | STCALI | 45 |  |  |  |  |  |  | 738695,738638 | 1
2001-08-19 00:00:00 |  |  | 22 | 22 |  | SP15 | SEMPRA | 26 |  |  | 39 | STCALI | 39 |  |  |  |  |  |  | [NAME] | 1
2001-08-19 00:00:00 |  |  | 22 | 22 |  | SP15 | WESCO | 26 |  |  | 43 | STCALI | 43 |  |  |  |  |  |  | 738697,738638 | 1
2001-08-19 00:00:00 |  |  | 23 | 23 |  | SP15 | WESCO | 52 |  |  | 42 | STCALI | 42 |  |  |  |  |  |  | 738697,738638 | 1
2001-08-19 00:00:00 |  |  | 24 | 24 |  | SP15 | WESCO | 17 |  |  | 42 | STCALI | 42 |  |  |  |  |  |  | 738697,738638 | 1
2001-08-19 00:00:00 |  |  | 24 | 24 |  | SP15 | EES | 35 |  |  | 38 | STCALI | 38 |  |  |  |  |  |  | 738636,738638 | 1
Spreadsheet: 586006d1534156500-advanced-filter-using-and-logic-does-not-return-expected-values-for-non-numeric-values-todowithadvancedfiltering
Sheet: FilterText

Action | Notes | Priority | Status | Date Started | Date Completed
 |  |  | Complete
Action | Notes | Priority | Status | Date Started | Date Completed
Task 1 | Do Task 1 | 4 | Not Started
Task 2 | Do Task 2 | 1 | Complete
Task 3 | Do Task 3 | 2 | Complete
Task 4 | Do Task 4 | 4 | Complete
Spreadsheet: 844945d1696534171-show-a-list-of-values-from-one-column-with-a-value-match-in-another-column-excel
Sheet: Sheet1

Store | Apple | Pear | Orange | [NAME] | Lemon
Wal-Mart | Yes | No | No | Yes | Yes
Target | Yes | Yes | Yes | No | No
Kroger | No | No | Yes | No | Yes
Aldi | Yes | No | Yes | Yes | Yes
[NAME]'s | Yes | Yes | No | Yes | No
Item | Pear
Store
Item | Orange
Store
Items
Store:
Spreadsheet: 49908d1249335845-how-to-average-dynamic-data-for-specific-categoris-from-a-different-worksheet-average-8-3-09
Sheet: Jan

Category | Days to Close | Agent Name
401K | 6 | [NAME]
401K | 5 | [NAME]
COBRA | 6 | [NAME]
COBRA | 4 | Yolanda
Paychecks | 5 | Yolanda
Paychecks | 4 | Yolanda
Paychecks | 2 | [NAME]