tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30140__200005_OA
Sheet: EAST-CON-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  | 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
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
FT-EAST
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 103867d1301532319-due-date-multiple-return-values-birthdaycardlist
Sheet: Sheet1

Name | Birthdate | 60 Days from now >>
Name1 |  |  |  |  |  | Days Until Birthday from Today!!
[NAME] |  |  |  |  |  | Row Labels | Sum of 60 Days from now >> | Filtered by Value less than 60 And Sorted Smallest to Largest
Name3 |  |  |  |  |  | Name19 | 12
Name4 |  |  |  |  |  | Name23 | 16
Name5 |  |  |  |  |  | Name1 | 20
Name6 |  |  |  |  |  | Name17 | 20
Name7 |  |  |  |  |  | Name14 | 21
Name8 |  |  |  |  |  | Name6 | 26
Name9 |  |  |  |  |  | Name11 | 32
Name10 |  |  |  |  |  | Name26 | 35
Name11 |  |  |  |  |  | Name32 | 45
Name12 |  |  |  |  |  | Name27 | 47
Name13 |  |  |  |  |  | Name22 | 51
Name14 |  |  |  |  |  | Name3 | 57
Name15
[NAME]
Name17
Name18
Name19
[NAME]
Name21
Name22
Name23
Name24
Name25
Name26
Name27
Name28
Name29
Name30
Name31
Name32
Name33
[NAME]
Name35
Name36
Name37
Name38
[NAME]
Name40
Spreadsheet: 45649d1244464241-grabbing-data-from-a-cell-on-another-worksheet-if-workbook_fault_example-1-
Sheet: Day 1

Holding | Sort | Security | Price
10000 | 1 | UNITED KINGDOM(GOVERNMENT OF) 4% STK 07/03/2009 GBP100 | 200
2000 | 2 | ELECTRIC & GENERAL INV TST PLC ORD GBP0.05 | 150
350 | 3 | MONKS INVESTMENT TRUST ORD GBP0.05 | 90
4000 | 6 | Pearson PLC | 500
5000 | 1 | UNITED KINGDOM(GOVERNMENT OF) 4% STK 07/03/2009 GBP100 | 700
1000 | 2 | ELECTRIC & GENERAL INV TST PLC ORD GBP0.05 | 450
Spreadsheet: 125129d1318887707-need-help-to-transpose-multiple-sets-of-data-into-rows-reformat-database
Sheet: Sheet1

[NAME], TX | 1 |  | OUTLET-Allen Premium Outlets | Store #: 780 | 820 W Stacy Rd | Suite 410 | [NAME], TX* 75013 | [PHONE]
OUTLET-Allen Premium Outlets | 1 |  | Watters Creek at Montgomery Farm | Store #: 689 | 827 Market Street |  | [NAME], TX* 75013 | [PHONE]
Store #: 780 | 1 |  | The Forum at Soncy | Store #: 430 | 3350 South Soncy Road | Suite 116 | Amarillo, TX* 79124 | [PHONE]
820 W Stacy Rd | 1
Suite 410 | 1
[NAME], TX* 75013 | 1
[PHONE] | 1
[NAME] | 1
 | 2
[NAME], TX | 2
Watters Creek at Montgomery Farm | 2
Store #: 689 | 2
827 Market Street | 2
[NAME], TX* 75013 | 2
[PHONE] | 2
[NAME] | 2
 | 3
Amarillo, TX | 3
The Forum at Soncy | 3
Store #: 430 | 3
3350 South Soncy Road | 3
Suite 116 | 3
Amarillo, TX* 79124 | 3
[PHONE] | 3
[NAME] (Formatted as a link) | 3
Spreadsheet: 713683d1610879954-subtraction-of-vlookup-in-two-sheets-but-across-a-number-of-columns-test-excel-forum_vlookup_test-when-ee-not-in-one-tab
Sheet: JAN 21

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43
EE ID | Gender | Other 1 | Other 2 | Other 3 | Other 4 | Other 5 | Other 6 | Other 7 | Other 8 | Other 9 | Other 10 | Other 11 | Other 12 | Other 13 | Other 14 | Other 15 | Other 16 | Other 17 | Other 18 | Other 19 | Other 20 | Other 21 | Other 22 | Other 23 | Other 24 | Other 25 | Other 26 | Other 27 | Other 28 | Other 29 | Other 30 | Other 31 | Other 32 | Other 33 | Other 34 | Other 35 | Other 36 | Other 37 | Other 38 | Other 39 | Other 40 | Other 41
100 | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | 1000000 | 1 | 50 | 49 |  |  |  | 40 |  |  |  |  |  | 60
101 | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | 150 |  |  |  | 2
150 | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | 20 |  |  |  |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 50 | 12 | 13 | 14 | 15 | 16 | 90 | 18 | 19 | 20 | 21 | 22 | 23
175 | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | 900500 |  |  |  |  |  | 5 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eg
100
101
150
175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | but how do I move this to populate from column T to AQ (col 20 - col 43)
Spreadsheet: lindy_donoho__21972__TW2010ProjCap&Rev
Sheet: Assumptions

 | Case 1 |  | Case 2 |  | Case 3
 | "Max Rates" |  | "Historical Average Rates" |  | "Future Curve Value"
 | 2002 - 2006 | 2007 - 2010 | 2002 - 2006 | 2007 - 2010 | 2002 - 2006 | 2007 - 2010
RESUBSCRIPTION RATES (4)
West | [NAME] | [NAME] | Hist Ave | See Rates tab* | Curve | Curve
San Juan | [NAME] | [NAME] | Hist Ave | Hist Ave | Hist Ave | Hist Ave
[NAME] to Blanco | Hist Ave | Hist Ave | Hist Ave | Hist Ave | Hist Ave | Hist Ave
East | Hist Ave | Hist Ave | Hist Ave | Hist Ave | Hist Ave | Hist Ave
FUEL
 | 24,000/d @ future |  | 24,000/d @ future | *add-in 2.5% fuel value | 24,000/d @ future
 | price curve (see |  | price curve (see | to west hist ave rate | price curve (see
 | Fuel Price tab) |  | Fuel Price tab) |  | Fuel Price tab)
[NAME] (3)
West | 1 | 1 | 1 | 1 | 1 | 1
San Juan | 1 | 1 | 1 | 1 | 1 | 1
[NAME] to Blanco | 1 | 1 | 54% (1) | 54% (1) | 1 | 1
East | 1 | 1 | reduce by 200,000/d (2) | reduce by 200,000/d (2) | 1 | 1
 | (1)  To reflect capturing "incremental" San Juan rate only for volumes delivered off-system to EP/Blanco and not on volumes
 | continuing on Transwestern's system.  54% is the two year historical average volume delivered to EP/Blanco.
 | (2)  To reflect resubscribing the 400,000/d East deal at 1/2 the current rate, assumed 1/2 the volume.  ([NAME].
 | The annual weighted average volume for 2003 is 151,000/d)
 | (3) See Summary Ctrc's & Resubscription tab for resubscription volumes
 | (4) See Rates tab for Max & Hist Ave rates
Spreadsheet: 148031d1333110578-excel-2007-if-functions-to-generate-revenue-bc-drafting
Sheet: Apprenticeship Pipeline 

 |  |  |  |  |  |  | TARGET
Apprenticeship Pipeline |  |  |  |  |  |  | Sign Ups Pipeline
 |  |  |  |  |  |  | Sign Ups Booked
 |  |  |  |  |  |  | Job Spec
 |  |  |  |  |  |  | Booked on Induction
 |  |  |  |  |  |  | Revenue Pipeline
 |  |  |  |  |  |  | Revenue Generated
Sign up Date | Company Name | Centre | Telesales Rep | Sign ups Pipeline | Sign Ups  Booked | Job Spec | Booked on Induction | Course | Revenue Pipeline | Revenue Generated
2012-02-25 00:00:00 | A2B Transport | Middlesbrough |  | 22 |  |  |  | Warehouse & Storage 19+
Spreadsheet: ce7323b7-280d-4740-b5ff-e8c981492df9
Sheet: Sheet1

Note: All Presentations Are One Hour and | Unnamed: 1 | Unnamed: 2
One PDU Unless Otherwise Noted
Region / Date | Topic | Program Number
Lehigh Valley Region
2009-03-05 00:00:00 | Wilderness Survival Requires a High Performance Team | C082-L0000309
2009-05-07 00:00:00 | The Project Manager and the Importance of Soft Skills | C082-L0000509
2009-09-10 00:00:00 | The Importance of Communicating a Compelling Story when Leading Projects | C082-L0000909
2009-11-05 00:00:00 | Establishing a Project Management System | C082-L0001109
Mid-State Region
NEPA Region
2009-02-12 00:00:00 | Project Management Best Practices Discussion | C082-N0000209
2009-03-26 00:00:00 | Introduction to Leadership | C082-N0000309
 | Scope, Cost, and Schedule Management for a Multi-Million Dollar Expansion Project | C082-N0000409
2009-05-21 00:00:00 | The Project of obtaining your next job/ Understanding Professional Development Units | C082-N0000509
2009-09-10 00:00:00 | Process Oriented Project Planning | C082-N0000909
2009-09-23 00:00:00 | How to Identify, Prioritize and Manage Project Risks (Bloomsburg) | C082-N0092309
2009-10-22 00:00:00 | Crucial Conversations (Bloomsburg) | C082-N0102209
2009-10-27 00:00:00 | Crucial Conversations | C082-N0001009
2009-12-10 00:00:00 | What Being a Project Manager Means to Me (Bloomsburg) | C082-N0121009
2009-12-15 00:00:00 | Lessons Learned in Project Management | C082-N0001209
Susquehanna
Valley Region
2009-02-11 00:00:00 | The Power of Incremental Advantage | C082-S0000209
2009-03-17 00:00:00 | Harness the Power of the PM/BA Partnership | C082-S0000309
2009-04-08 00:00:00 | Medieval Project Management | C082-S0000409
2009-05-13 00:00:00 | The PM Survivors Guide to FISMA Compliance for Federal Information Systems | C082-S0000509
2009-07-22 00:00:00 | An Evening with the Harrisburg Senators | C082-S0000709
2009-09-09 00:00:00 | Process Oriented Project Planning | C082-S0000909
Annual Dinner
Meeting
2009-06-10 00:00:00 | Politically (In) Correct Managers | C082-S0000609
Professional
Development Events
2009-10-03 00:00:00 | Professional Development Day | C082-S0001009
Harrisburg
University
2009-04-02 00:00:00 | Enterprise Project Management Event
Spreadsheet: 684421d1593356693-how-to-format-a-cell-to-make-it-red-when-a-value-is-deleted-from-a-column-example
Sheet: Setjes

R |  |  |  |  | G |  |  |  | EXPIRY DATE |  | G-NR | PROD. DATE | PROD. DATUM + 3 JR
 | R1215 | R1252 | R1253 |  | PHASE 1 |  | PHASE 2 |  |  |  |  | 2018-02-01 00:00:00
SET 1 |  |  |  |  | 56236 |  |  |  |  |  |  | 2017-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 13245 | 2016-02-01 00:00:00
SET 2
SET 3
SET 4
SET 5
SET 6
Spreadsheet: 732442d1620959750-formula-to-look-for-a-value-in-a-column-and-return-the-value-of-another-cell-in-that-row-building-maintenance-record-test
Sheet: WR 2020

 | WORKS REQUEST REGISTER
Job Number (e.g.BM# /GG#) | Number | Officers Initials | Priority Ranking | Date | Time | Requested By | Description of Work
BM04 | WR21-001 | AH | Medium | 2021-04-20 00:00:00 | 05:30:00 | [NAME] | [NAME]
 | WR21-002
 | WR21-003
 | WR21-004
 | WR21-005
 | WR21-006
Spreadsheet: 67517d1268137625-i-dont-want-blank-cell-in-drop-down-cell-test-for-dropdown
Sheet: Sheet1

 |  |  | FIRST | SECOND | THIRD | FOURTH
 |  | [NAME] | 50 | 4587 | 587 | 7878
 |  | KHALID | 4587 | 57487 | 457 | 0
 |  | [NAME] | 878 | 4548 | 548 | 548
 |  | IQBAL | 45 | 545 | NEXT | PRE
 |  | RAMZAN | OUT | MAR | DEC | 285
 |  | [NAME] | 50 | 4587 | 587 | 7878
 |  | KABPPOOR | 4587 | 57487 | 457 | 0
 |  | VIJAUY | 878 | 4548 | 548 | 548
 |  | MABINDA | 878 | 4548 | 548 | 548
 |  | MICHLE | 878 | 4548 | 548 | 548
 |  | [NAME] | 50 | 4587 | 587 | 7878
 |  | RASH | 4587 | 57487 | 457 | 0
 |  | MINSH | 4587 | 57487 | 457 | 0
 |  | MIHSA | 878 | 4548 | 548 | 548
 |  | MAI | 878 | 4548 | 548 | 548
 |  | [NAME]
 |  | RAJA
 |  | [NAME]
Spreadsheet: 683662d1592886776-inventory-with-ability-to-exclude-transactions-by-date-chemical-inventory-m_buskirk-
Sheet: Inventory

Product | Alliance | Scottsbluff | Torrington | TOTAL
Amine 4
[NAME]
Bedliner
Choice Weathermaster (2x2.5 gal)
[NAME] (2x2.5 gal)
Ethofumesate 4SC (2x2.5 gal)
Glystar Plus (2x2.5 gal)
Intensity One (2x2.5 gal)
LI 700 (2x2.5 gal)
Mad Dog 5.4 (Bulk)
Maximizer (2x2.5 gal)
[NAME] (2x2.5 gal)
Outlook (2x2.5 gal)
Roundup Powermax (Bulk)
[NAME] (2.5 gal)
[NAME] (2x2.5 gal)
[NAME] (4x1 gal)
[NAME] (2x2.5 gal)
Spreadsheet: 216102d1361582281-data-validation-question-excel-help_dependent-validation-lists
Sheet: Table2

Fruit1 | Fruit2 | Fruit3 | Fruit4 | Fruit5 | Fruit6 | Vegetable1 | Vegetable2 | Vegetable3 | Vegetable4 | Vegetable5 | Mineral1 | Mineral2 | Mineral3 | Mineral4
Fruit1_Subtype1 | Fruit2_Subtype1 | Fruit3_Subtype1 | Fruit4_Subtype1 | Fruit5_Subtype1 | Fruit6_Subtype1 | Vegetable1_Subtype1 | Vegetable2_Subtype1 | Vegetable3_Subtype1 | Vegetable4_Subtype1 | Vegetable5_Subtype1 | Mineral1_Subtype1 | Mineral2_Subtype1 | Mineral3_Subtype1 | Mineral4_Subtype1
Fruit1_Subtype2 | Fruit2_Subtype2 | Fruit3_Subtype2 | Fruit4_Subtype2 | Fruit5_Subtype2 | Fruit6_Subtype2 | Vegetable1_Subtype2 | Vegetable2_Subtype2 | Vegetable3_Subtype2 | [NAME] | Vegetable5_Subtype2 | [NAME] | Mineral2_Subtype2 | Mineral3_Subtype2 | Mineral4_Subtype2
Fruit1_Subtype3 | Fruit2_Subtype3 | Fruit3_Subtype3 | Fruit4_Subtype3 | Fruit5_Subtype3 | Fruit6_Subtype3 | Vegetable1_Subtype3 | Vegetable2_Subtype3 | Vegetable3_Subtype3 | Vegetable4_Subtype3 | Vegetable5_Subtype3 | Mineral1_Subtype3 | Mineral2_Subtype3 | Mineral3_Subtype3 | Mineral4_Subtype3
Fruit1_Subtype4 | Fruit2_Subtype4 | Fruit3_Subtype4 | Fruit4_Subtype4 | Fruit5_Subtype4 | Fruit6_Subtype4 | Vegetable1_Subtype4 | Vegetable2_Subtype4 | Vegetable3_Subtype4 | [NAME] | Vegetable5_Subtype4 | Mineral1_Subtype4 | Mineral2_Subtype4 | Mineral3_Subtype4 | Mineral4_Subtype4
Fruit1_Subtype5 | Fruit2_Subtype5 | Fruit3_Subtype5 | Fruit4_Subtype5 | Fruit5_Subtype5 | Fruit6_Subtype5 | Vegetable1_Subtype5 | Vegetable2_Subtype5 | Vegetable3_Subtype5 | Vegetable4_Subtype5 | Vegetable5_Subtype5 | Mineral1_Subtype5 | Mineral2_Subtype5 | Mineral3_Subtype5 | Mineral4_Subtype5
Fruit1_Subtype6 | Fruit2_Subtype6 | Fruit3_Subtype6 | Fruit4_Subtype6 | Fruit5_Subtype6 | Fruit6_Subtype6 | Vegetable1_Subtype6 | Vegetable2_Subtype6 | Vegetable3_Subtype6 | Vegetable4_Subtype6 | Vegetable5_Subtype6 | Mineral1_Subtype6 | Mineral2_Subtype6 | Mineral3_Subtype6 | Mineral4_Subtype6
Fruit1_Subtype7 | Fruit2_Subtype7 | Fruit3_Subtype7 | Fruit4_Subtype7 | Fruit5_Subtype7 | Fruit6_Subtype7 | Vegetable1_Subtype7 | Vegetable2_Subtype7 | Vegetable3_Subtype7 | Vegetable4_Subtype7 | Vegetable5_Subtype7 | Mineral1_Subtype7 | Mineral2_Subtype7 | Mineral3_Subtype7 | Mineral4_Subtype7
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 14

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  |  | 5.8
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Wed 9 Aug Glucose mmol/L
 |  |  | 7 |  | 6.2
Thu 10 Aug Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 6.3
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Fri 11 Aug Glucose mmol/L
Sat 12 Aug Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 6.9 | 6.6
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sun 13 Aug Glucose mmol/L
Mon 14 Aug Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 5.6
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Tue 15 Aug Glucose mmol/L
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Spreadsheet: 477145d1472146395-formula-to-add-row-data-if-blank-then-data-from-different-sheet-with-reference-criteria-sumofthings
Sheet: Historic

 |  | Historic | Historic | Historic | Historic | Historic | Historic | Historic | Historic | Historic | Historic | Historic | Historic
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | R Holcom | 14.4869776845 | 28.973955369 | 57.947910738 | 96.57985123 | 217.3046652675 | 289.73955369 | 618.111047872 | 57.947910738 | 57.947910738 | 96.57985123 | 154.527761968 | 676.05895861
 | A Ivanson | 19.315970246 | 57.947910738 | 96.57985123 | 154.527761968 | 386.31940492 | 618.111047872 | 618.111047872 | 82.0928735455 | 82.0928735455 | 135.211791722 | 193.15970246 | 676.05895861
 | B Risuto | 19.315970246 | 82.0928735455 | 135.211791722 | 193.15970246 | 434.609330535 | 676.05895861 | 618.111047872 | 57.947910738 | 57.947910738 | 96.57985123 | 154.527761968 | 676.05895861
 | M Franklin | 19.315970246 | 82.0928735455 | 135.211791722 | 193.15970246 | 434.609330535 | 676.05895861 | 618.111047872 | 82.0928735455 | 82.0928735455 | 135.211791722 | 193.15970246 | 676.05895861
Spreadsheet: 683899d1593030925-combine-2-spreadsheets-and-align-per-common-column-data-plus-a-couple-columns-practice-vlookup
Sheet: Sheet1

Code | CODE | ALTERNATE DESCRIPTION | EVENT CATEGORY | LOGBOOK
710000
710001 | 710001 | ENGINE ([NAME]) - REMOVAL / INSTALLATION | PART | Airframe
710002 | 710002 | ENGINE (RIGHT) - REMOVAL / INSTALLATION | PART | Airframe
710003 | 710003 | TREND MONITORING, ENG | LUBRICATION/SERVICING | ENG
710004
710005
710006
710007
710008
710009 | 710009 | ENGINE MID-LIFE / MOD UPDATE | LUBRICATION/SERVICING | ENG
710010
710011 | 710011 | ENGINE CALENDAR LIFE | LUBRICATION/SERVICING | ENG
710012
710013 | 710013 | ENGINE OVERHAUL | OVERHAUL | ENG
710014
710015 | 710015 | POWERPLANT (EXTERNAL) LEFT - GENERAL INSPECTION | SPECIAL INSPECTION | Airframe
710016 | 710016 | POWERPLANT (EXTERNAL) RIGHT - GENERAL INSPECTION | SPECIAL INSPECTION | Airframe
710017
710018
Spreadsheet: 736180d1623400691-conditional-formatting-with-wildcard-highlight-row-eh-cf_close
Sheet: Master (2)

 |  |  |  |  |  |  |  | Status
Priority | DS268022 |  |  | Moy Park | PMA Changes not actioned from last month |  | Closed
Priority | DS267246 |  |  | Moy Park | Missing products from database | Ticket actioned and closed | Closed
Priority | DS267242 |  |  | Moy Park | CMA Change | Ticket actioned and closed | Closed
Priority | DS266940 | 2020-05-02 00:00:00 |  | Hilton | Amend dropdown on WPO following feedback of posting report of new contract | Ticket actioned and closed | Closed
Priority | DS267929 / DS268803 / DS269480 | 2020-03-03 00:00:00 |  | IPN | Filter not applied - report Error | Ticket actioned and closed | Closed
Priority | DS267438 | 18/2/2020 | 26/3/20 | Cranswick | New product coding for Cranswick, to help align the universes with EPOS, not actioned | Ticket actioned and closed | Closed
Priority | DS268699 | 18/2/2020 | 26/3/20 | Cranswick | New product coding for Cranswick, to help align the universes with EPOS, not actioned - CW09 | Ticket actioned and closed | Closed
Priority | DS268696 |  | 26/3/20 | Cranswick | New product coding for Cranswick, to help align the universes with EPOS, not actioned - CW08 database | Ticket actioned and closed | Closed
Priority | DS269017 | 2020-03-04 00:00:00 |  | Multiple Affected | Red Tractor Coding in Poultry | Ticket actioned and closed | Closed
Priority | DS269366 | 2020-04-16 00:00:00 |  | Addo | Missing Sausage Roll SKUs from database | Ticket actioned and closed | Closed
Priority | DS269372 | 16/4/20 |  | Addo | Missing Hot Pie SKUS | Ticket actioned and closed | Closed
Priority | DS269274 | 14/3/20 |  | [NAME] | Hide Dairy report please from the client | Actioned and ticket closed 20/04 | Closed
Priority | DS266575 / DS268782 | 27/01/2020 |  | Cranswick | Products incorrectly coded in databases - had been told actioned but incorrect | Coding changes actioned for P6 | Closed
Priority | DS269041 | 2020-06-04 00:00:00 |  | Butchers | Barcodes missing from database - High priority for the client to get resolved as they are now #2 brand | Ticket actioned and closed | Closed
Priority | DS269648 |  | 24/4/2020 | ABP | Amend 1 itemisation - no attributes added. Just combine standard and Standard line | Actioned | Closed
Priority | DS263885 / DS269690 |  | 27/04/20 | IPN | Incorrect version of store itemisation on IPN reports | Are the reports impacted the same as other IPN ticket? | Closed
Spreadsheet: 196184d1353903301-help-merging-similar-rows-into-columns-output-example
Sheet: Sheet1

assign_num | hou_add |  | str_nme |  | nam_fam | [NAME] | nam_gv2 | res_ad1 | res_ad2 | nam1_fam | nam1_gv1 | nam1_gv2 | res_ad3 | pst_ad1 | pst_ad2 | [NAME]
1 | 6 | 6 | Excel Place, POINT CARL | Excel Place, POINT CARL | Ceravolo | Salvatore |  | 6 Jones Place | POINT [NAME]  61019 | Ceravolo | Vincenzo |  |  |  |  |  | 6 Jones Place | POINT [NAME]  61019
3 | 7 | 7 | Excel Place, POINT CARL | Excel Place, POINT CARL | McCall | Charlotte | Therese | 7 Savill Place | POINT [NAME]  61019 |  |  |  |  |  |  |  | 7 Savill Place | POINT [NAME]  61019
4 | 8 | 8 | Excel Place, POINT CARL | Excel Place, POINT CARL | Kingwest Pty Ltd |  |  | 15 [NAME] | KARA WA  61522 |  |  |  |  |  |  |  | 15 [NAME] | KARA WA  61522
5 | 40 | 40 | Word Avenue,  PARKVIEW | Word Avenue,  PARKVIEW | Angus | Terrance | Reynolds | 40 First Avenue | VICTORIA  WG  61002 | Angus | Rosemary |  |  |  |  |  | 40 First Avenue | VICTORIA  WG  61002
7 | 42 | 42 | Word Avenue,  PARKVIEW | Word Avenue,  PARKVIEW | McCabe | [NAME] |  | PO Box 11111 | VICTORIA  WG  61002 |  |  |  |  |  |  |  | PO Box 11111 | VICTORIA  WG  61002
8 | 43 | 43 | Word Avenue,  PARKVIEW | Word Avenue,  PARKVIEW | Pardoe | Betty |  | 43 Second Avenue | VICTORIA  WG  61002 |  |  |  |  |  |  |  | 43 Second Avenue | VICTORIA  WG  61002
Spreadsheet: 175127d1345412429-vlookup-help-no-it-doesnt
Sheet: Date Log

# | Date | Day | Start Time | End Time | Total Time | Week # | Warm Up Min | [NAME] | Total Points | # of Routes Climbed | # of Attempts | # of Routes Tried | % Complete | Gym Popularity | Temp. | Hardest Route Climbed | Climbing Concentration (Attempts per hour) | Hard Climbing Concentration (points per hour) | Exercise 1 | Exercise 2 | Exercise 3 | Exercise 4 | Assessment |  | Use find and replace to change week name (command f)
Highest
AVG
Sum
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43