tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30154__9903_OA
Sheet: SE-CON-VAR

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:  ECTR (EGM) / LRC
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | 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: 756538d1637619052-retrieve-hours-worked-based-on-day-of-week-in-rota-rota
Sheet: April

 | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 | 2021-04-01 00:00:00 | 2021-04-02 00:00:00 | 2021-04-03 00:00:00 | 2021-04-04 00:00:00 | 2021-04-05 00:00:00 | 2021-04-06 00:00:00 | 2021-04-07 00:00:00 | 2021-04-08 00:00:00 | 2021-04-09 00:00:00 | 2021-04-10 00:00:00 | 2021-04-11 00:00:00 | 2021-04-12 00:00:00 | 2021-04-13 00:00:00 | 2021-04-14 00:00:00 | 2021-04-15 00:00:00 | 2021-04-16 00:00:00 | 2021-04-17 00:00:00 | 2021-04-18 00:00:00 | 2021-04-19 00:00:00 | 2021-04-20 00:00:00 | 2021-04-21 00:00:00 | 2021-04-22 00:00:00 | 2021-04-23 00:00:00 | 2021-04-24 00:00:00 | 2021-04-25 00:00:00 | 2021-04-26 00:00:00 | 2021-04-27 00:00:00 | 2021-04-28 00:00:00 | 2021-04-29 00:00:00 | 2021-04-30 00:00:00 |  | Total Hours
[NAME]
Scott
Adam
 | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 | 2021-04-01 00:00:00 | 2021-04-02 00:00:00 | 2021-04-03 00:00:00 | 2021-04-04 00:00:00 | 2021-04-05 00:00:00 | 2021-04-06 00:00:00 | 2021-04-07 00:00:00 | 2021-04-08 00:00:00 | 2021-04-09 00:00:00 | 2021-04-10 00:00:00 | 2021-04-11 00:00:00 | 2021-04-12 00:00:00 | 2021-04-13 00:00:00 | 2021-04-14 00:00:00 | 2021-04-15 00:00:00 | 2021-04-16 00:00:00 | 2021-04-17 00:00:00 | 2021-04-18 00:00:00 | 2021-04-19 00:00:00 | 2021-04-20 00:00:00 | 2021-04-21 00:00:00 | 2021-04-22 00:00:00 | 2021-04-23 00:00:00 | 2021-04-24 00:00:00 | 2021-04-25 00:00:00 | 2021-04-26 00:00:00 | 2021-04-27 00:00:00 | 2021-04-28 00:00:00 | 2021-04-29 00:00:00 | 2021-04-30 00:00:00
[NAME]
Scott
Adam
Spreadsheet: 23832d1213634121-indexing-and-lookup-sumproductexamplea
Sheet: Sheet2

 |  | July 1-5 |  |  |  |  |  | July 8-12 |  |  |  |  |  | July 15-19 |  |  |  |  |  | July 22-26 |  |  |  |  |  | July 28-2
Project | Role | M | T | W | Th | F | Total | M | T | W | Th | F | Total | M | T | W | Th | F | Total | M | T | W | Th | F | Total | M | T | W | Th | F | Total
lookup from first sheet |  | sum up hours for each role from specific project for specific date
abc | IA | 0 | 4 | 1 | 0 | 0 | 5
abc | BA | 0 | 0 | 0 | 0 | 0 | 0
def | CD | 0 | 0 | 0 | 3 | 0 | 3
Spreadsheet: john_griffith__16221__2_1_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 57 | 540 | 640 | 46.4 | 55 | 1.82 | 2002-02-01 10:32:00
 | [NAME] | 64 | 870 | 970 | 45.4 | 50.7 | 1.93 | 2002-02-01 10:32:00
 | [NAME] | 64 | 1090 | 1190 | 45.2 | 49.4 | 1.9 | 2002-02-01 10:32:00
 | [NAME] | 65 | 1240 | 1340 | 43 | 46.5 | 1.83 | 2002-02-01 10:32:00
 | HU N2 | 64 | 1310 | 1410 | 41.6 | 44.8 | 1.74 | 2002-02-01 10:32:00
 | [NAME] | 63 | 1340 | 1440 | 39.4 | 42.3 | 1.62 | 2002-02-01 10:32:00
 | HU U2 | 61 | 1350 | 1450 | 37.8 | 40.7 | 1.51 | 2002-02-01 10:32:00
 | [NAME] | 58 | 1320 | 1450 | 36.6 | 40.2 | 1.4 | 2002-02-01 10:32:00
 | [NAME] | 58 | 1310 | 1440 | 34.1 | 37.5 | 1.31 | 2002-02-01 10:32:00
 | [NAME] | 58 | 1320 | 1450 | 32.9 | 36.1 | 1.26 | 2002-02-01 10:32:00
 | HU F3 |  |  |  | 33.8 | 38.6 | 1.32 | 2002-01-31 15:11:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | HU H3
 | [NAME]
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU M3
Spreadsheet: darron_c_giron__8011__EMW 0921
Sheet: P&L

Enron Midwest P&L With Sharing
 |  |  |  | NSS1 |  | NSS2 |  | MEH |  | TP-NSS |  | EMW Total
CURRENT BOOK VALUE
 | Physical
 |  | Physical
 |  | Other |  | 0 |  | 0 |  | 0 |  | 0
 |  | Prompt
 |  | Reversal
 |  | TOTAL
 | Financial
 |  | Price Swaps
 |  | Options
 |  | Basis
 |  | Index
 |  | Gas Daily
 |  | Gas Daily Options
 |  | Broker Fees
 |  | TOTAL
 | Omicron
 |  | Physical |  | 0 |  | 0 |  | 0 |  | 0
 |  | Financial |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL
 | Transport - Accrued
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | 3rd Party Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL
 | Transport - MTM
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | 3rd Party Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL
 | Other
 |  | People's Share of P&L
 |  | Origination
 |  | Flash to Actual |  | 0 |  | 0 |  | 0 |  | 0
 |  | Origination's Share of P&L
 |  | TOTAL
NET CURRENT MONTH P&L
DAILY CHANGE
 | Physical
 |  | Physical
 |  | Other
 |  | Prompt
 |  | Reversal
 |  | TOTAL
 | Financial
 |  | Price Swaps
 |  | Options
 |  | Basis
 |  | Index
 |  | Gas Daily
 |  | Gas Daily Options
 |  | Broker Fees
 |  | TOTAL
 | Omicron
 |  | Physical
 |  | Financial
 |  | TOTAL
 | Transport - Accrued
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges
 |  | 3rd Party Demand Reimbursements
 |  | Transport Book Demand Charges
 |  | Transport Book Demand Reimbursements
 |  | TOTAL
 | Transport - MTM
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges
 |  | 3rd Party Demand Reimbursements
 |  | Transport Book Demand Charges
 |  | Transport Book Demand Reimbursements
 |  | TOTAL
 | Other
 |  | People's Share of P&L
 |  | Origination
 |  | Flash to Actual
 |  | Origination's Share of P&L
 |  | TOTAL
NET DAILY CHANGE P&L
MONTH TO DATE
YEAR TO DATE
 |  |  |  | NSS1 |  | NSS2 |  | MEH |  | TP-NSS |  | EMW Total
 |  | Physical:
 |  | Curve Shift
 |  | New Deals
 |  | Changed Deals
 |  | Trans. Reversal
 |  | Liquidated Day
 |  | New Financial Deals:
 |  | Price
 |  | Basis
 |  | Index
 |  | Gas Daily
Spreadsheet: 704513d1605609265-extract-and-return-a-values-in-a-summary-sheet-from-various-sheets-book1
Sheet: Summary

 |  |  |  |  |  |  |  |  |  | desired results
Date | Ref | Description | Man Hours | Plant Hours | Tender-Labour | Tender-Plant | Actual-Labour | Actual-Plant |  | Date | Ref | Description | Man Hours | Plant Hours | Tender-Labour | Tender-Plant | Actual-Labour | Actual-Plant
 |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00 | C001.1 | Labour -Site Related Activities | 20 | 0 | 0 | 0 | 219.2 | 0
 |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00 | C001.1 | Labour -Site Related Activities | 30 | 0 | 0 | 0 | 328.8 | 0
 |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00 | A022 | Backfilling for Utilites | 20 | 2 | 525.6 | 333 | 219.2 | 320
 |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00 | A021 | Excavation for Utilities | 50 | 35 | 936 | 2644.8 | 548 | 2825
 |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00 | A021 | Excavation for Utilities | 40 | 28 | 780 | 2204 | 438.4 | 2580
 |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00 | A045 | Other-General Works | 40 | 0 | 0 | 0 | 438.4 | 0
 |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00 | A032 | 1400mm dia. Pipe laying | 44 | 8 | 354.0802993527508 | 477.1475323624596 | 482.24 | 1240
 |  |  |  |  |  |  |  |  |  | 2020-11-02 00:00:00 | C001.1 | Labour -Site Related Activities | 20 | 0 | 0 | 0 | 219.2 | 0
 |  |  |  |  |  |  |  |  |  | 2020-11-02 00:00:00 | C001.1 | Labour -Site Related Activities | 30 | 0 | 0 | 0 | 328.8 | 0
 |  |  |  |  |  |  |  |  |  | 2020-11-02 00:00:00 | A022 | Backfilling for Utilites | 20 | 2 | 525.6 | 333 | 219.2 | 320
 |  |  |  |  |  |  |  |  |  | 2020-11-02 00:00:00 | A021 | Excavation for Utilities | 50 | 35 | 936 | 2644.8 | 548 | 2825
 |  |  |  |  |  |  |  |  |  | 2020-11-02 00:00:00 | A021 | Excavation for Utilities | 40 | 28 | 780 | 2204 | 438.4 | 2580
 |  |  |  |  |  |  |  |  |  | 2020-11-02 00:00:00 | A045 | Other-General Works | 40 | 0 | 0 | 0 | 438.4 | 0
 |  |  |  |  |  |  |  |  |  | 2020-11-02 00:00:00 | A032 | 1400mm dia. Pipe laying | 44 | 8 | 354.0802993527508 | 477.1475323624596 | 482.24 | 1240
Spreadsheet: 124338d1318342139-conditional-formatting-test
Sheet: Sheet1

 |  |  |  |  | 0.3
 |  |  |  |  | 114.091889 | 97.071889 | 96.08188899999999 | L | 3292.751433 | 3275.731433 | 3274.741433 | 100.076239 | 83.056239 | 82.066239 | V | 3292.751633 | 3275.731633 | 3274.741633
 |  |  |  |  | 227.175953 | 210.155953 | 209.165953 | L | 3179.667369 | 3162.647369 | 3161.657369 | 201.123918 | 184.103918 | 183.113918 | T | 3193.683219 | 3176.663219 | 3175.673218999999
 |  |  |  |  | 364.234865 | 347.214865 | 346.224865 | H | 3066.583305 | 3049.563305 | 3048.573305 | 298.176682 | 281.156682 | 280.166682 | P | 3092.63554 | 3075.61554 | 3074.62554
 |  |  |  |  | 435.271979 | 418.251979 | 417.261979 | A | 2929.524393 | 2912.504393 | 2911.514393 | 2189.205764 | 2172.185764 | 2171.195764 | K | 2995.582776 | 2978.562776 | 2977.572776
 |  |  |  |  | 548.356043 | 531.336043 | 530.346043 | I | 2858.487279 | 2841.467279 | 2840.477279 | 2246.227228 | 2229.207228 | 2228.217228 | G | 1104.553694 | 1087.533694 | 1086.543694
 |  |  |  |  | 695.424457 | 678.404457 | 677.414457 | F | 2745.403215 | 2728.383215 | 2727.393215 | 2345.295642 | 2328.275642 | 2327.285642 | V | 1047.53223 | 1030.51223 | 1029.52223
 |  |  |  |  | 752.445921 | 735.425921 | 734.435921 | G | 2598.334801 | 2581.314801 | 2580.324801 | 2446.343321 | 2429.323321 | 2428.333321 | T | 948.463816 | 931.443816 | 930.453816
 |  |  |  |  | 881.488514 | 864.468514 | 863.478514 | E | 2541.313337 | 2524.293337 | 2523.303337 | 2575.385914 | 2558.365914 | 2557.375914 | E | 847.4161369999999 | 830.396137 | 829.406137
 |  |  |  |  | 3047.602843 | 3030.582843 | 3029.592843 | K | 2412.270744 | 2395.250744 | 2394.260744 | 2688.469978 | 2671.449978 | 2670.459978 | L | 718.373544 | 701.353544 | 700.363544
 |  |  |  |  | 3118.639957 | 3101.619957 | 3100.629957 | A | 246.156415 | 229.136415 | 228.146415 | 2789.517657 | 2772.497657 | 2771.507657 | T | 605.2894799999999 | 588.2694799999999 | 587.2794799999999
 |  |  |  |  | 3274.741068 | 3257.721068 | 3256.731068 | R | 175.119301 | 158.099301 | 157.109301 | 2860.554771 | 2843.534771 | 2842.544771 | A | 504.241801 | 487.221801 | 486.231801
 |  |  |  |  |  |  |  |  |  |  |  | 2989.597364 | 2972.577364 | 2971.587364 | E | 433.204687 | 416.1846870000001 | 415.194687
 |  |  |  |  |  |  |  |  |  |  |  | 3118.639957 | 3101.619957 | 3100.629957 | E | 304.162094 | 287.142094 | 286.152094
 |  |  |  |  |  |  |  |  |  |  |  | 3274.741068 | 3257.721068 | 3256.731068 | R | 175.119501 | 158.099501 | 157.109501
Spreadsheet: 06c9ccaa-ff41-42e3-8f60-23e9f86f9f11
Sheet: Sheet1

Currency Conversion Worksheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Click here for directions
*** Please review example by clicking on "example tab" below ***
Red triangle in cell denotes comments available
Step-by-Step Instructions
Indicate source of exchange rate. If using both Oanda and receipts, clarify in column #1 (see example page)
Oanda - indicate date used in conversion |  |  | Indicate rate:
If using rate from exchange receipt* enter yes |  |  | Indicate rate: |  | *Attach receipt
Column #1 - Enter currency
Column #2 - Enter BRIEF description
Column #3 - Enter foreign amount of receipt
Column #4 - Revise formula using correct exchange rate
Column #5 - Reference this receipt number on original receipt
**NOTE:  If below Oanda hyperlink fails to work, go to web and enter URL:  http://www.oanda.com**
# 1 | # 2 | # 3 | # 4 | # 5
Currency Used | Description of | Foreign | Oanda | Receipt | Miscellaneous
in Conversion | expense | Amount | Converter | Number | Notes
 |  |  | 0 | 1
 |  |  | 0 | 2
 |  |  | 0 | 3
 |  |  | 0 | 4
 |  |  | 0 | 5
 |  |  | 0 | 6
 |  |  | 0 | 7
 |  |  | 0 | 8
 |  |  | 0 | 9
 |  |  | 0 | 10
 |  |  | 0 | 11
 |  |  | 0 | 12
 |  |  | 0 | 13
 |  |  | 0 | 14
 |  |  | 0 | 15
 |  |  | 0 | 16
 |  |  | 0 | 17
 |  |  | 0 | 18
 |  |  | 0 | 19
 |  |  | 0 | 20
 |  |  | 0 | 21
 |  |  | 0 | 22
 |  |  | 0 | 23
 |  |  | 0 | 24
 |  |  | 0 | 25
 |  |  | 0 | 26
 |  |  | 0 | 27
 |  |  | 0 | 28
 |  |  | 0 | 29
 |  |  | 0 | 30
Spreadsheet: 140464d1328759149-count-or-sum-multiple-columns-when-the-criteria-is-met-count-and-sum-multiple-criterias
Sheet: Sheet1

A | 1 | 2 | 1 | 4
B | 2 | 2 | 1 | 5
A | 3 | 2 | 1 | 4
C | 3 | 1 | 3 | 6
B | 2 | 3 | 2 | 5
A | 1 | 2 | 3 | 4
I want to count from collum B to E when collum A is B?
I want to sum from collum B to E when collum A is B?
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 38

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
38 | 2007-02-19 00:00:00 | 7.3 | 0.9 | 4.2 | 2 | 3.1 | 5.6 |  |  |  | 2 |  | 2.489979919597747 | 2.3 | 0.1 | 9 |  |  |  |  | 0.3
Well #38 | 2013-10-11 00:00:00 | 8 | 1.23 | 6.46 | 2.76 | 2.9 | 5.8 |  |  | 1 | 5 |  | 1.4 | 3.5 | 0.04 | 12.5 |  | <0.10 | <0.02 |  | 1.1
Well - 38 | 2014-02-05 00:00:00 | 7.7 | 1.3 | 6.81 | 2.72 | 2.8 | 5.2 |  |  | 0.9 | 5.7 |  | 1.3 | 3.2 | 0.04 | 12.4 |  | <0.10 | <0.02 |  | 0.8
Well 38 | 2015-04-02 00:00:00 | 7.7 | 1.32 | 7.35 | 3.12 | 3.4 | 5.4 |  |  | 1.1 | 6 |  | 1.5 | 3.9 | <0.05 | 12.3 |  | <0.10 | <0.02 |  | 0.9
Well 38 | 2016-04-04 00:00:00 | 7.86 | 1.417 | 8.95 | 3.72 | 3.55 | 5.067540564303413 | 5.067540564303413 | 0 | 1.174 | 8.196 | 908.8 | 1.41 | 3.43 | 0.031 | 12.18797 | 0.021 | 0 | 0.001 | 0.017
Well 38 | 2017-05-03 00:00:00 | 7.91 | 1.491 | 9.72 | 3.86 | 3.32 | 5.245384062025418 | 5.245384062025418 | 0 | 1.07 | 9.5964 | 954 | 1.27 | 3.16 | 0.03 | 9.8758 | 0 | 0.457 | 0.099 | 0.014
W38 | 2018-05-29 00:00:00 | 8.03 | 1.299 | 7.94 | 3.32 | 3.65 |  | 5.423227559747422 | 0 | 1.19 | 6.906 | 831.3599999999999 |  |  | 0.032 | 10.098 | 0.04 | 0 | 0 | 0.003
Spreadsheet: 860587d1708621642-average-dates-between-a-min-and-max-with-while-sorting-names-and-years-total-productive-maintenance-log
Sheet: TPM Log

Date Entered | Year | Unit | [NAME] | Date Down | Time Down | How long Down(Hrs and Min) | Total Downtime (Days:Hrs) | Completed By | Brief Descirption of Trigger | Mean Time to Repair Cost |  |  |  | PPP- | 30R- | 18R- | Shim- | WT- | WF- | Skive- |  |  | PPP- | 30R- | 18R- | Shim- | WT- | WF- | Skive-
2024-01-01 00:00:00 |  | PPP- | Breakdown | 2024-01-01 00:00:00 | 07:30:00 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024
2024-01-03 00:00:00 |  | 18R- | Breakdown | 2024-01-03 00:00:00 | 07:45:00 | 2 |  |  |  |  |  | Millwrights |  |  |  |  |  |  |  |  |  | 2025
2024-01-04 00:00:00 |  | PPP- | Breakdown | 2024-01-04 00:00:00 | 08:35:00 | 0.75 |  |  |  |  |  | Electricians
2024-01-08 00:00:00 |  | 30R- | Breakdown | 2024-01-08 00:00:00 |  |  |  |  |  |  |  | Mill & Elec
2024-01-10 00:00:00 |  | PPP- | Breakdown | 2024-01-10 00:00:00
2025-01-02 00:00:00 |  | 30R- |  | 2025-01-02 00:00:00
2025-01-03 00:00:00 |  | WT- |  | 2025-01-03 00:00:00
2025-01-04 00:00:00 |  | WF- |  | 2025-01-04 00:00:00
2025-01-05 00:00:00 |  | PPP- |  | 2025-01-05 00:00:00
2025-01-06 00:00:00 |  | [NAME] |  | 2025-01-06 00:00:00
2025-01-07 00:00:00 |  | PPP- |  | 2025-01-07 00:00:00
Spreadsheet: 753222d1635317892-translating-dynamic-array-formula-for-ranking-into-power-query-m-code-conditional_rank_power_query
Sheet: Rank

Batch | Step Text | Control recipe | Rank pasted values | Rank with dynamic array formula | Control recipe numbervalue | Alternative rank formula
14384960 | Printing reference sample labels | 100000000000395235 | 1
14384960 | Printing reference sample labels | 100000000000395235 | 1
14384960 | Printing reference sample labels | 100000000000395235 | 1
14384960 | Taking of reference samples | 100000000000395237 | 1
14384960 | Taking of reference samples | 100000000000395237 | 1
14384960 | Taking of reference samples | 100000000000395237 | 1
14384960 | Taking of reference samples | 100000000000395237 | 1
14733213 | Logbook | 100000000000401798 | 1
14733213 | Logbook | 100000000000401798 | 1
14733213 | Logbook | 100000000000403402 | 2
14733213 | Logbook | 100000000000403402 | 2
14733213 | Within requirements | 100000000000403570 | 1
14384960 | Printing reference sample labels | 100000000000400354 | 2
14384960 | Printing reference sample labels | 100000000000400354 | 2
14384960 | Taking of reference samples | 100000000000400938 | 2
14384960 | Taking of reference samples | 100000000000400938 | 2
14384960 | Taking of reference samples | 100000000000400938 | 2
14384960 | Taking of reference samples | 100000000000400938 | 2
14384960 | Number approved | 100000000000400940 | 1
14733213 | Logbook | 100000000000403756 | 3
14733213 | Logbook | 100000000000403756 | 3
14733213 | Logbook | 100000000000403756 | 3
14733213 | Logbook | 100000000000403756 | 3
14733213 | Within requirements | 100000000000404116 | 2
14733213 | Logbook | 100000000000404597 | 4
14733213 | Logbook | 100000000000404597 | 4
14733213 | Logbook | 100000000000404597 | 4
14733213 | Logbook | 100000000000404597 | 4
14733213 | Within requirements | 100000000000404979 | 3
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: DEN-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  DENVER
 |  |  | Total |  | Reclasses |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | 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 | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 429161 | 417307.71 | -86654 |  | 5
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: holden_salisbury__12323__PrePay Accounting_1220
Sheet: Mona- Sun

Hour
Ending |  |  |  |  |  |  |  | hourly non-firm | hourly non-firm
Pacific | Mona physical | PNM |  |  |  | AEP | PAC | PAC(t) | PAC(t) | LDWP | Balance
Standard | position | Purchase |  |  |  |  | Sale | [NAME]/RB | [NAME]/RB | Sale
(PST)
100
200
300
400
500
600
700 |  |  |  |  |  | -25
800 |  |  |  |  |  | -25
900 |  |  |  |  |  | -25
1000 |  |  |  |  |  | -25
1100 |  |  |  |  |  | -25
1200 |  |  |  |  |  | -25
1300 |  |  |  |  |  | -25
1400 |  |  |  |  |  | -25
1500 |  |  |  |  |  | -25
1600 |  |  |  |  |  | -25
1700 |  |  |  |  |  | -25
1800 |  |  |  |  |  | -25
1900 |  |  |  |  |  | -25
2000 |  |  |  |  |  | -25
2100 |  |  |  |  |  | -25
2200 |  |  |  |  |  | -25
2300
2400
Spreadsheet: 0293789a-41ac-490a-9f14-6c5d27ffed2f
Sheet: Chart Titles

 |  |  | TITLE BOX
 | COMPLETES CHART TITLE
 | RESPONSE RATES CHART TITLE
 | TOTAL EMPLOYED CHART TITLE
 | MEDIAN HOURLY WAGE CHART TITLE
 | TOTAL IN MILITARY CHART TITLE
 | CONTINUING EDUCATION CHART TITLE
 | TOTAL APPRENTICESHIPS CHART TITLE
 | STATE LICENSING EXAM CHART TITLE (TOOK AND PASSED IN ONE CHART)
 | INSTRUCTIONAL [NAME]
 | RESPONSE RATES WITH PROGRAM COMPLETES CHART TITLE
Spreadsheet: 862099d1709870540-populate-new-or-dropped-data-excel1-1-
Sheet: Sheet1 (2)

Date Table |  |  |  |  |  | Correct Results
Month | Product ID | Product Name | Branch Name |  |  | Month | Product ID | Product Name | Branch Name | Status
Dec | 123456 | Product1 | Branch 1 |  |  | Jan | 123460 | Product5 | Branch 5 | [NAME]
Dec | 123457 | Product2 | Branch 2 |  |  | Jan | 123461 | Product6 | Branch 5 | New
Dec | 123458 | Product3 | Branch 3 |  |  | Feb | 123462 | Product7 | Branch 5 | New
Dec | 123459 | Product4 | Branch 4 |  |  | Mar | 123462 | Product8 | Branch 5 | New
Dec | 123460 | Product5 | Branch 5 |  |  | Apr | 123457 | Product2 | Branch 2 | [NAME]
Dec | 123456 | Product1 | Branch 1
Jan | 123457 | Product2 | Branch 2
Jan | 123458 | Product3 | Branch 3
Jan | 123459 | Product4 | Branch 4
Jan | 123461 | Product6 | Branch 5
Feb | 123457 | Product2 | Branch 2
Feb | 123458 | Product3 | Branch 3
Feb | 123459 | Product4 | Branch 4
Feb | 123462 | Product7 | Branch 5
Mar | 123457 | Product2 | Branch 2
Mar | 123458 | Product3 | Branch 3
Mar | 123459 | Product4 | Branch 4
Mar | 123462 | Product7 | Branch 5
Mar | 123462 | Product8 | Branch 5
Apr | 123458 | Product3 | Branch 3
Apr | 123459 | Product4 | Branch 4
Apr | 123462 | Product7 | Branch 5
Apr | 123462 | Product8 | Branch 5
Spreadsheet: 552900d1513840874-concatenate-random-text-from-a-column-sample-excel-2003-with-vba
Sheet: Example

Ref | Status | Names |  |  | ELEC | DEF | MDF
MDP | CM | [NAME] |  | CO
DEF |  |  |  | CM
DEF |  |  |  | ZLP
MDP
ELEC
ELEC | CM | Petrica
ELEC
DEF
ELEC
DEF
MDP
MDP
DEF
DEF
ELEC | CO | Buzatu
MDP | ZLP | Simovici
MDP
MDP
MDP
MDP
MDP
MDP | ZLP | Teo
ELEC
MAC
ELEC | CO | Bercovici
MDP
MDP
MDP
MDP
MDP
ELEC
MAC
MDP
MDP
MDP
MDP | ZLP | Eusebiu
MDP
ELEC
MAC
DEF
DEF
MDP
MDP | CM | [NAME]
ELEC
MDP
MDP
ELEC
DEF | CO | Fanaca
DEF