tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30654__9902_OA
Sheet: SE-CON-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | 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 | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
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
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 852297d1702385923-my-index-and-match-formula-is-returning-duplicate-entries-sample
Sheet: Summary 2

 | [NAME]
 |  |  |  |  |  | 2023
 |  | 2024 |  |  |  | 2023 |  | 2022 |  | 2021
 | Client | Fees (£) | Cost (£) | MP % |  | Fees (£) | MP % | Fees (£) | MP % | Fees (£) | MP %
Spreadsheet: 03b6d2a8-1167-4fb7-b3bb-d4e9c392e67c
Sheet: Sheet1

Kilometerregistratie | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Kenteken: |  |  | Merk en type: |  |  |  |  |  |  |  |  | Totaal zakelijk | Totaal    privé
Periode: |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Datum | Ritnr. | Beginstand kilometerteller | Eindstand kilometerteller | Van - naar | Gereden route (indien afwijkend) | Bezoekadres | Begintijd | Eindtijd | Duur | Karakter rit Z/P |  | Kilometers zakelijk | [NAME] privé
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00
Spreadsheet: f5666334-8211-47f2-9db5-7cfbc6bf2389
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8442 | 41151 | [NAME] | Wersy | FRA | 36 | [NAME] | [NAME] | 00:36:43 | 00:01:03 | [NAME] | 1 | 01:20:55
8442 | 47645 | Santiago | [NAME] | ESP | 35 | 00:16:10 | 00:02:44 | 00:40:37 | 00:00:21 | 00:26:48 | 2 | 01:26:40
8442 | 63065 | Raphaël | [NAME] | FRA | 34 | 00:17:05 | 00:02:21 | 00:40:29 | 00:01:04 | 00:28:33 | 3 | 01:29:31
8442 | 49498 | [NAME] | Pacheco  Salas | ESP | 33 | 00:17:11 | 00:02:56 | [NAME] | [NAME] | 00:33:55 | 4 | 01:34:10
8442 | 49383 | Valeriano | [NAME] | ESP | 32 | 00:17:47 | 00:03:14 | 00:42:39 | 00:00:34 | 00:32:08 | 5 | 01:36:21
8442 | 12645 | Santos | Caballero | ESP | 31 | 00:24:56 | 00:03:09 | 00:46:57 | 00:01:10 | 00:50:45 | 6 | 02:06:54
Spreadsheet: 215735d1361466264-excel-newbie-needs-help-food-order-ver-1
Sheet: Sheet1

Daily Online Orders
Product | HEB | S | P | T | C | Product | HEB | S | P | T | C
Bread Products **note: default for bread is NO slice** |  |  |  |  |  | [NAME]
White Sandwich Loaf |  |  |  |  |  | Chocolate Pecan (Vegan) Cake
WS loaf (small) |  |  |  |  |  | New York Cheese Cake
White (WS) Buns ½ dz |  |  |  |  |  | [NAME]
WS Dinner Rolls ½ dz |  |  |  |  |  | Red Velvet Cake
[NAME] |  |  |  |  |  | St. Honores
Hot dog buns [NAME] dz |  |  |  |  |  | Coconut Tres Leches
12” Pizza Crust |  |  |  |  |  | [NAME]
8” Pizza Crust |  |  |  |  |  | Choc Cookies & Cream
[NAME] (WF) Loaf |  |  |  |  |  | Triple Chocolate Cake (6”)
WF Loaf (small) |  |  |  |  |  | Creamy Vanilla Cake (6”)
WF Buns ½ doz.
WF Dinner Rolls ½ doz.
WF Hot dog buns [NAME] dz |  |  |  |  |  | Pastry Items
12” WF Pizza Crust |  |  |  |  |  | Small eclairs (cream puffs)
8” WF Pizza Crust |  |  |  |  |  | Choc eclairs 1pk
[NAME] |  |  |  |  |  | [NAME]
[NAME] (small)
[NAME] buns ½ doz |  |  |  |  |  | Pies & Quiches
Cran dinner rolls ½ doz |  |  |  |  |  | Beef Pie
Glazed [NAME] |  |  |  |  |  | [NAME]
Rye Loaf |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Spinach & Feta Pie
Cookie Products |  |  |  |  |  | Quiche Lorraine
Anzac Cookies 1pk
Anzac Cookies 2pk |  |  |  |  |  | [NAME]
Choc Chip 2pk |  |  |  |  |  | Chocolate Pecan
Chocolate [NAME] 1pk |  |  |  |  |  | Apple
Double Choc Chip 2pk |  |  |  |  |  | Pumpkin
Ginger 2pk |  |  |  |  |  | Pie crst - pressed
Hungerbuster 1pk
Hungerbuster 2pk |  |  |  |  |  | Flour Blends & Mixes
[NAME] 2pk |  |  |  |  |  | All Purpose [NAME] lb
[NAME] 2pk |  |  |  |  |  | [NAME]
Snicker-doodle 2pk |  |  |  |  |  | Choc Cake Mix
Peanut Butter 2pk |  |  |  |  |  | [NAME]
Merchandise |  |  |  |  |  | Guar Gum 8 oz
Medium Boomerang |  |  |  |  |  | [NAME] flour (Green Label)
Large Boomerang |  |  |  |  |  | [NAME] flour (Red Label)
[NAME] keychain |  |  |  |  |  | Tapioca Starch
RESERVATIONS
Orders for Shipping
Customer Details |  |  |  |  |  |  |  | Order Details
Name: |  |  |  |  |  |  |  | [NAME] flour (Green Label)
Street: |  |  | City:
State: | Zip: |  | Phone:
Comment:
Name:
Street: |  |  | City:
State: | Zip: |  | Phone:
Comment:
Name:
Street: |  |  | City:
State: |  | Zip: | Phone:
Comment:
Name:
Street: |  |  | City:
State: |  | Zip: | Phone:
Comment:
Name:
Street: |  |  | City:
State: |  | Zip: | Phone:
Comment:
Name:
Street: |  |  | City:
State: |  | Zip: | Phone:
Comment:
Name:
Name:
Street: |  |  | City:
State: |  | Zip: | Phone:
Comment:
Spreadsheet: 56396d1256591926-how-to-solve-day-calculation-rain-days
Sheet: Sheet1

Date | Rain | Amount |  |  |  | Days | # of times | total amt
2009-10-12 00:00:00 | Yes | 0.15 |  |  |  | Mon
2009-10-13 00:00:00 | No | 0 |  |  |  | Tue
2009-10-14 00:00:00 | No | 0 |  |  |  | Wed
2009-10-15 00:00:00 | Yes | 0.05 |  |  |  | Thu
2009-10-16 00:00:00 | Yes | 0.45 |  |  |  | Friday
2009-10-17 00:00:00 | No | 0 |  |  |  | Sat
2009-10-18 00:00:00 | No | 0 |  |  |  | Sun
2009-10-19 00:00:00 | No | 0
2009-10-20 00:00:00 | Yes | 0.98
2009-10-21 00:00:00 | Yes | 0.85
2009-10-22 00:00:00 | No | 0
2009-10-23 00:00:00 | No | 0
2009-10-24 00:00:00 | No | 0 |  |  |  |  | Desired output but want calculation to be done automatically
2009-10-25 00:00:00 | Yes | 1.35 |  |  |  | Days | # of times | total amt
2009-10-26 00:00:00 | Yes | 0.55 |  |  |  | Mon | 2 | 0.7000000000000001
2009-10-27 00:00:00 | Yes | 0.5 |  |  |  | Tue | 2 | 1.48
 |  |  |  |  |  | Wed | 1 | 0.85
 |  |  |  |  |  | Thu | 1 | 0.05
 |  |  |  |  |  | Friday | 1 | 0.45
 |  |  |  |  |  | Sat | 0 | 0
 |  |  |  |  |  | Sun | 1 | 1.35
Spreadsheet: 763081d1641983657-need-to-add-own-month-from-to-end-date-new-sample
Sheet: Order List

# No | Order Date | Card | Month
 | 2021-01-14 00:00:00 | Credit card A | Dec
2 | 1900-01-20 00:00:00 | Credit card A | Feb
3 | 2022-02-14 00:00:00 | Credit card A | Feb
4 | 2022-02-16 00:00:00 | Credit card A |  | [NAME] date every month 15th Eg: this blll generated 15th feb
5 | 2022-02-16 00:00:00 | Credit card B |  | this bill genrting 10th to next 9th
 |  |  |  |  |  | Credit card A
 |  |  |  |  |  | Credit card B
#N/A
#N/A
Spreadsheet: 89793d1289519132-conditional-formatting-sample
Sheet: Data

2010-01-02 00:00:00 |  | Blue |  |  | Green |  | [NAME] |  | Red |  | Gray |  | Yellow |  | Blue
2010-01-16 00:00:00 |  | Saturday | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Green
2010-01-30 00:00:00 |  | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 |  | 2010-01-04 00:00:00 |  | 2010-01-05 00:00:00 |  | 2010-01-06 00:00:00 |  | 2010-01-07 00:00:00 |  | 2010-01-08 00:00:00 |  | [NAME]
2010-02-13 00:00:00 |  |  | 2010-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Red
2010-02-27 00:00:00 |  |  | 2010-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Gray
2010-03-13 00:00:00 |  |  | 2010-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Yellow
2010-03-27 00:00:00 |  |  | 2010-01-31 00:00:00
2010-04-10 00:00:00 |  |  | 2010-02-07 00:00:00
2010-04-24 00:00:00 |  |  | 2010-02-14 00:00:00
2010-05-08 00:00:00 |  |  | 2010-02-21 00:00:00
2010-05-22 00:00:00 |  |  | 2010-02-28 00:00:00
2010-06-05 00:00:00 |  |  | 2010-03-07 00:00:00
2010-06-19 00:00:00 |  |  | 2010-03-14 00:00:00
2010-07-03 00:00:00 |  |  | 2010-03-21 00:00:00
2010-07-17 00:00:00 |  |  | 2010-03-28 00:00:00
2010-07-31 00:00:00 |  |  | 2010-04-04 00:00:00
2010-08-14 00:00:00 |  |  | 2010-04-11 00:00:00
2010-08-28 00:00:00 |  |  | 2010-04-18 00:00:00
2010-09-11 00:00:00 |  |  | 2010-04-25 00:00:00
2010-09-25 00:00:00 |  |  | 2010-05-02 00:00:00
2010-10-09 00:00:00 |  |  | 2010-05-09 00:00:00
2010-10-23 00:00:00 |  |  | 2010-05-16 00:00:00
2010-11-06 00:00:00 |  |  | 2010-05-23 00:00:00
2010-11-20 00:00:00 |  |  | 2010-05-30 00:00:00
2010-12-04 00:00:00 |  |  | 2010-06-06 00:00:00
2010-12-18 00:00:00 |  |  | 2010-06-13 00:00:00
 |  |  | 2010-06-20 00:00:00
 |  |  | 2010-06-27 00:00:00
 |  |  | 2010-07-04 00:00:00
 |  |  | 2010-07-11 00:00:00
 |  |  | 2010-07-18 00:00:00
 |  |  | 2010-07-25 00:00:00
 |  |  | 2010-08-01 00:00:00
 |  |  | 2010-08-08 00:00:00
 |  |  | 2010-08-15 00:00:00
 |  |  | 2010-08-22 00:00:00
 |  |  | 2010-08-29 00:00:00
 |  |  | 2010-09-05 00:00:00
 |  |  | 2010-09-12 00:00:00
 |  |  | 2010-09-19 00:00:00
 |  |  | 2010-09-26 00:00:00
 |  |  | 2010-10-03 00:00:00
 |  |  | 2010-10-10 00:00:00
 |  |  | 2010-10-17 00:00:00
 |  |  | 2010-10-24 00:00:00
 |  |  | 2010-10-31 00:00:00
 |  |  | 2010-11-07 00:00:00
 |  |  | 2010-11-14 00:00:00
 |  |  | 2010-11-21 00:00:00
 |  |  | 2010-11-28 00:00:00
 |  |  | 2010-12-05 00:00:00
 |  |  | 2010-12-12 00:00:00
 |  |  | 2010-12-19 00:00:00
 |  |  | 2010-12-26 00:00:00
 |  |  | 2011-01-02 00:00:00
 |  |  | 2011-01-09 00:00:00
 |  |  | 2011-01-16 00:00:00
 |  |  | 2011-01-23 00:00:00
 |  |  | 2011-01-30 00:00:00
 |  |  | 2011-02-06 00:00:00
 |  |  | 2011-02-13 00:00:00
 |  |  | 2011-02-20 00:00:00
 |  |  | 2011-02-27 00:00:00
Spreadsheet: 803219d1667318250-split-the-contents-of-a-cell-into-rows-split-text-to-lines-aligw
Sheet: Split

Object info |  | Result
SY001664 Mast normal SY001710 Mast normal SY001742 Building (SYV) normal SY002017 Mast normal SY002508 Building (SYV) normal SY003007 Building normal
SY002427 Mast normal |  |  |  |  | AliGW:
SY001217 Mast prioritized
 |  | SY001664
 |  | SY001710 |  |  | SY001710
 |  | SY001742 |  |  | SY001742
 |  | SY002017 |  |  | SY002017
 |  | SY002508 |  |  | SY002508
 |  | SY003007 |  |  | SY003007
 |  | SY002427 |  |  | SY002427
 |  | SY001217 |  |  | SY001217
Spreadsheet: 600599d1543865248-formula-doenst-read-numbers-in-imported-data-from-obi-sample-data
Sheet: Sheet1

 | 2,319,804 |  | 46,529 | 1,088,259 | 874,279 | -27,831 | 1,981,235
 | 3,155,525 |  | 40,749 | 95,372 | 116,623 | 380,287 | 633,031
 | 10,586 |  |  | 10,235 | -8 |  | 10,227
 | 2,400,014 |  | 28,331 | 57,709 | 75,304 | 174,220 | 335,563
 | 1,492,341 |  | 28,552 | 669,154 | 553,359 | 27,418 | 1,278,483
 | 3,284,093 |  | 28,750 | 51,860 | 21,232 | 4,870 | 106,712
Spreadsheet: 796344d1663232498-extracting-specific-multiple-text-in-cell-and-sorting-into-individual-cell-test-sheet
Sheet: Sorted

Order No. |  |  |  |  |  |  | Total PO | Received | Delivered
 | PL1001 | PL1348 | PL0083 | PL0059 |  |  |  |  | 2019-06-25 00:00:00
 | PL1332 | PL0010 | PL0055 |  |  |  |  |  | 2020-07-20 00:00:00
 | PL0067 |  |  |  |  |  |  |  | 2021-09-28 00:00:00
 |  |  |  |  |  |  |  |  | 2019-11-12 00:00:00
Spreadsheet: 153119d1335779274-how-to-calculate-the-average-cycle-time-dummy-spreadsheet
Sheet: Sheet1

Date | Time | Truck
2012-01-01 00:00:00 | 01:02:56 | Truck 1 |  |  | Average Cycle Time
2012-01-01 00:00:00 | 05:16:43 | Truck 1 |  |  | Truck 1
2012-01-01 00:00:00 | 11:46:56 | Truck 1 |  |  | Truck 2
2012-01-01 00:00:00 | 16:13:06 | Truck 1 |  |  | Truck 3
2012-01-01 00:00:00 | 20:43:27 | Truck 1
2012-01-01 00:00:00 | 01:02:56 | Truck 2
2012-01-01 00:00:00 | 05:16:43 | Truck 2
2012-01-01 00:00:00 | 11:46:56 | Truck 2
2012-01-01 00:00:00 | 16:13:06 | Truck 2
2012-01-01 00:00:00 | 20:43:27 | Truck 2
2012-01-01 00:00:00 | 05:16:43 | Truck 3
2012-01-01 00:00:00 | 11:46:56 | Truck 3
2012-01-01 00:00:00 | 16:13:06 | Truck 3
2012-01-01 00:00:00 | 20:43:27 | Truck 3
2012-01-02 00:00:00 | 01:32:41 | Truck 1
2012-01-02 00:00:00 | 07:55:28 | Truck 1
2012-01-02 00:00:00 | 13:40:10 | Truck 1
2012-01-02 00:00:00 | 18:23:30 | Truck 1
2012-01-02 00:00:00 | 23:50:00 | Truck 1
2012-01-02 00:00:00 | 01:32:41 | Truck 2
2012-01-02 00:00:00 | 07:55:28 | Truck 2
2012-01-02 00:00:00 | 13:40:10 | Truck 2
2012-01-02 00:00:00 | 18:23:30 | Truck 2
2012-01-02 00:00:00 | 23:50:00 | Truck 2
2012-01-02 00:00:00 | 01:32:41 | Truck 3
2012-01-02 00:00:00 | 07:55:28 | Truck 3
2012-01-02 00:00:00 | 13:40:10 | Truck 3
2012-01-02 00:00:00 | 18:23:30 | Truck 3
2012-01-02 00:00:00 | 23:50:00 | Truck 3
2012-01-03 00:00:00 | 05:31:51 | Truck 1
2012-01-03 00:00:00 | 09:12:23 | Truck 1
2012-01-03 00:00:00 | 05:31:51 | Truck 2
2012-01-03 00:00:00 | 09:12:23 | Truck 2
2012-01-03 00:00:00 | 05:31:51 | Truck 3
2012-01-03 00:00:00 | 09:12:23 | Truck 3
2012-01-04 00:00:00 | 00:14:55 | Truck 1
2012-01-04 00:00:00 | 04:00:18 | Truck 1
2012-01-04 00:00:00 | 09:41:56 | Truck 1
2012-01-04 00:00:00 | 13:21:40 | Truck 1
2012-01-04 00:00:00 | 18:25:03 | Truck 1
2012-01-04 00:00:00 | 22:16:30 | Truck 1
2012-01-04 00:00:00 | 00:14:55 | Truck 2
2012-01-04 00:00:00 | 04:00:18 | Truck 2
2012-01-04 00:00:00 | 09:41:56 | Truck 2
2012-01-04 00:00:00 | 13:21:40 | Truck 2
2012-01-04 00:00:00 | 18:25:03 | Truck 2
2012-01-04 00:00:00 | 22:16:30 | Truck 2
2012-01-04 00:00:00 | 00:14:55 | Truck 3
2012-01-04 00:00:00 | 04:00:18 | Truck 3
2012-01-04 00:00:00 | 09:41:56 | Truck 3
2012-01-04 00:00:00 | 13:21:40 | Truck 3
2012-01-04 00:00:00 | 18:25:03 | Truck 3
2012-01-04 00:00:00 | 22:16:30 | Truck 3
2012-01-05 00:00:00 | 02:20:37 | Truck 1
2012-01-05 00:00:00 | 02:20:37 | Truck 2
2012-01-05 00:00:00 | 02:20:37 | Truck 3
2012-01-07 00:00:00 | 10:51:59 | Truck 1
2012-01-07 00:00:00 | 14:56:49 | Truck 1
2012-01-07 00:00:00 | 19:34:06 | Truck 1
2012-01-07 00:00:00 | 23:22:09 | Truck 1
2012-01-07 00:00:00 | 10:51:59 | Truck 2
2012-01-07 00:00:00 | 14:56:49 | Truck 2
2012-01-07 00:00:00 | 19:34:06 | Truck 2
2012-01-07 00:00:00 | 23:22:09 | Truck 2
2012-01-07 00:00:00 | 10:51:59 | Truck 3
2012-01-07 00:00:00 | 14:56:49 | Truck 3
2012-01-07 00:00:00 | 19:34:06 | Truck 3
2012-01-07 00:00:00 | 23:22:09 | Truck 3
Spreadsheet: tracy_geaccone__40293__CAPITAL WORKSHEET
Sheet: IT

IT
2002 CAPITAL PLAN
($ [NAME])
 |  | 2002
 |  | NNG |  | TW |  | FGT |  | NBP |  | Midwestern |  | EOTT |  | Other |  | TOTAL
GROUP |  | [NAME] | Disc | [NAME] | Disc | [NAME] | Disc | [NAME] | Disc | [NAME] | Disc | [NAME] | Disc | [NAME] | Disc | [NAME] | Disc
INFRASTRUCTURE
Audit / Security Compliance Monitoring |  |  | 600000
Data Center Consolidation - System Rel |  |  | 1066142
Chair Upgrade IT Support |  |  | 30150 |  | 30150 |  | 30150
Blanket - IT depts
Blanket - IT ETS depts |  |  | 35000
Blanket - IT depts |  |  |  |  |  |  | 43000
[NAME] |  |  | 555000
Monitor Upgrade for IT Ops Support
Total IT
rev 8/27/01
Spreadsheet: errol_mclaughlin_jr__10038__NETCO Test Issues_0118
Sheet: Sheet1

NETCO Integration testing on Friday 01/18.
 | Outstanding issues
 | Area | Problem | Assigned | Status
 | EnPower | PortCalc - when try to calc., connection refused.  Connection is pointing to quark (estate hardware).  This should be neptune (netco)! | [NAME] | 4:00pm; In progress
 | ERMS | Post Ids - (per [NAME]) - Ramesh said that numbers for post_id 1 is not right. This is a data problem. | Jeremy | Jemery will check  where the data problem resides
 | Gas | Known Balancing issue per [NAME] | [NAME] | Fri 5:15pm; In progress
 | Global Replication | Contracts not going to Unify Gas - shadow tables not being populated | [NAME] | Fri 5:15pm; In progress
 | Global Replication | No Global replication info Unify financials | [NAME] | Fri 5:15pm; In progress
 | Power | EnPower deal replication to Unify - not able to load deals.  CRD_Desk not populated in EnPower oracle table | [NAME] [NAME] | Fri 5:15pm; In progress
 | Power Confirmations | TNS Server error 57541 | Schomer/ Kumaran | IT Fix in; not confirmed by user yet
 | TAGG | Tagg web reports need to be checked to make sure it goes to the NETCO url | [NAME] | Open
 | Resolved Issues
 | Area | Problem | Assigned | Status
 | EnPower | Power Contract not showing in EnPower | [NAME] | Resolved
 | EnPower | Curve managers do not launch | [NAME] | Resolved
 | EOL bridge to EnPower | EOL Physical Deal Entry (ORA-03114 not connected to oracle) | D. Poston & EOL | Resolved
 | Gas | Sitara to Unify - IM PB E 8 desk missing in Unify | Pena | Resolved
 | Gas | FTP Server down for EDI (Cross roads) | [NAME] | Resolved
 | Infrastructure | [NAME]Tagg/ ERMS) RunM application needed to be added to startup script | Justin | Resolved
 | Infrastructure | Terminal Server - not connecting to the NetCo platform. |  | Resolved
 | Tagg/ Erms | Tagg settlement report - cannot connect to database (ORA-12154) | [NAME] | Fri 5:15pm; In progress
 | Tagg/ Erms | Tagg settlement report - does not run (error behind scene?) | [NAME]
 | Infrastructure | Our RisktRAC application does not recognize network IDs that are greater than 10 characters in length. | Champion, [NAME] | Resolved
 | Infrastructure | When she attempted to run the RisktRAC application (Start/Programs/Business Applications/RisktRAC) she ran into script error messages indicating access was denied to a folder or directory, which means her ID was missing a network group for a directory that the install script is dependent on | Champion, [NAME] | Resolved
 | Request for next week
 | 1) To activate both phones in room:  2521.  We will need this for next week.
Spreadsheet: 679056d1590165714-look-up-and-return-data-within-a-table-between-sheets-excel-forums-examples
Sheet: Access Database

Pile No. | Pile Diameter ([NAME]) | Pile Thickness ([NAME]) | Final Embedment Depth (m) | Hammer Model | Hammer Weight (kg) | Installation Date | Installation Time | Depth (m) | Installation Date | Installation Time | Depth (m) | Installation Date | Installation Time | Depth (m) | Hammer Stroke (m) | Depth (m) | Hammer Stroke (m) | Depth (m) | Hammer Stroke (m) | Depth (m)
IID-2TA170-P-003 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-004 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-005 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-006 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-007 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-008 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-009 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-010 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-012 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-013 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-014 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-015 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-016 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-017 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-018 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-019 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-020 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-021 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-022 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-023 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-025 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-026 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-027 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-028 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-031 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-032 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-033 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-034 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-035 | 1524 | 25.4 |  | BSP CG240 | 16000
IID-2TA170-P-039 | 1524 | 25.4 |  | BSP CG240 | 16000
Spreadsheet: darrell_schoolcraft__7310__imball0201
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -14 |  | -54985 | -54900
2 |  |  | -45523 | -45012
3 | -19469 | -20000 | -31996 | -29900
4 | -10157 | -10000 | -65915 | -65318
5 | -29699 | -29869 | -63672 | -63430
6 | -29789 | -29869 | -64157 | -63430
7 | -29899 | -29869 | -83960 | -83430
8 | -10720 | -10152 | -104080 | -104207
9 | -14972 | -15000 | -57592 | -56846
10 | -14997 | -15000 | -93909 | -93216
11 | -613 |  | -79398 | -78955
12 | -5137 | -5000 | -58921 | -59382
13 | -5527 | -5000 | -59922 | -59382
14 | -5814 | -5000 | -57766 | -57060
15 |  |  | -88029 | -87799
16 | -4789 | -4155 | -81538 | -80882
17 | -22716 | -22154 | -91857 | -91315
18 | -324 |  | -65366 | -64929
19 |  |  | -70622 | -72649
20 |  |  | -72881 | -72649
21 |  |  | -61293 | -62649
22 |  |  | -72050 | -71395
23 | -11234 | -10000 | -29918 | -29430
24 | -10772 | -10000 | -62174 | -61769
25 | -10014 | -10000 | -57210 | -57075
26 | -10509 | -10000 | -37433 | -36900
27 | -10566 | -10000 | -43203 | -36900
28 | -12117 | -10000 | -27265 | -26900
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 9676
2002-01-28 00:00:00
CBS $
 |  |  | 19943.24
Spreadsheet: 794604d1662137115-getting-info-from-another-table-with-some-criteria-table
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 |  |  |  |  | name | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
 |  |  |  |  |  |  |  | a | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  | b | - | - | - | - | - | - | 1
 |  |  |  |  |  |  |  | c | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  | d | - | - | - | - | - | - | 1
 |  |  |  |  |  |  |  | e | - | - | - | - | - | - | 1
 |  |  |  |  |  |  |  | f | - | - | - | - | - | - | 1
 |  |  |  |  |  |  |  | g | - | - | - | - | - | - | 1
 |  |  |  |  |  |  |  | h | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  | i | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  | j | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  | k | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  | l | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  | m | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  | n | - | - | - | - | - | - | 1
Spreadsheet: 690627d1597209295-formula-for-producing-customers-statement-customers-statement
Sheet: Sales Data

Date | [NAME] | Customer  Name | VAT Number | Invoice Number | Product  I.D | Product Name | Quantity | Unit Price | Gross Amount | Discount % | Discount Amount | Net Amount | VAT % | [NAME] | Amount Including VAT
2020-08-01 00:00:00 | 100 | Ok Mart | 1000200 | 1 | A001 | Milk | 5000 | 2 |  | 0.01 |  |  | 0.15
2020-08-02 00:00:00 | 101 | [NAME] | 1000201 | 2 | A002 | [NAME] | 1200 | 20 |  | 0.01 |  |  | 0.15
2020-08-11 00:00:00 | 102 | Ok Mart | 1000200 | 3 | A003 | Milk | 4000 | 2 |  | 0.01 |  |  | 0.15
2020-08-11 00:00:00 | 103 | ZIMNAT | 1000203 | 4 | A004 | Chairs | 20 | 70 |  | 0.01 |  |  | 0.15