tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 181135d1347941448-count-2-different-variables-from-different-columns-excel-testing1
Sheet: Sheet1

product 1 | Character | product 2 | Character | product 3 | Character
[NAME] | High Quality | Fender | Versatile | Squier | Affordable
Fender | Versatile | [NAME] | High Quality | Squier | Affordable |  |  | What are the top 3 guitar brands known for?
Fender | Versatile | Squier | Affordable | [NAME] | High Quality |  |  |  | [NAME] | Fender | Squier
[NAME] | High Quality | Fender | Versatile | Squier | Affordable |  |  | Versatile
Fender | Versatile | Squier | Affordable | [NAME] | High Quality |  |  | High Quality
 |  |  |  |  |  |  |  | Affordable
Spreadsheet: darron_c_giron__8030__Sched_C Form
Sheet: Schedule C

SCHEDULE C
DOCUMENTATION FORM
ITEM |  | DATA
Transaction or Book Name |  | GD-NEW
Amount |  | 30000000
Entry Date |  | 2000-11-27 00:00:00
Reason for Using Schedule C (e.g., income adjustment) |  | Liquidity risk due to West positions
Removal Date
(If amortization is required, attach the appropriate
amortization schedule)
Methodology for Removal (e.g., amortization or one time removal)
Individual Using Schedule
Trader/Structuring |  | Business Analysis & Reporting
Energy Operations |  | [NAME]
Spreadsheet: larry_campbell__21326__brcmtram
Sheet: Sheet1

 |  |  |  |  | price
 | # shares | symbol | buy/sell | date | per share
 | 7 | BRCM | buy | 2000-10-19 00:00:00 | 226
 | 16 | BRCM | buy | 2000-10-19 00:00:00 | 226
 | 23 | BRCM | sold | 2000-10-20 00:00:00 | 234
 | 225 | BRCM | buy | 2000-12-21 00:00:00 | 85.1875
 | 100 | BRCM | sold | 2000-12-21 00:00:00 | 84.4375
 | 125 | BRCM | sold | 2000-12-21 00:00:00 | 84.4375
Spreadsheet: 161475d1339527537-data-sorter-example
Sheet: Sheet1

 |  |  |  |  | Q1 |  | Q2 |  | D1 |  | D2 |  | M1 |  | M2
 | [NAME] |  | 0 | 0
 | [NAME] |  | 25 | 5
 | [NAME] |  | 25 | 5
 | Autopsy Q1 |  | 52 | 4
 | Autopsy Q1 |  | 52 | 4
 | [NAME] Q2 |  | 0 | 0
 | Autopsy M2 |  | 28 | 1.7
 | Autopsy M2 |  | 28 | 2
 | Autopsy M1 |  | 22 | 25
Spreadsheet: 41420d1239889154-sorting-by-week-2nd-post-no-one-can-reply-on-first-example_spreadsheet
Sheet: Sheet1

colleges | addresses | quantity | date needed | month
college 1 |  | 100 | 2009-04-15 00:00:00 | 4
college 2 |  | 100 | 2009-04-16 00:00:00 | 4
college 3 |  | 100 | 2009-04-17 00:00:00 | 4
college 4 |  | 100 | 2009-04-18 00:00:00 | 4
college 5 |  | 100 | 2009-04-19 00:00:00 | 4
college 6 |  | 100 | 2009-04-20 00:00:00 | 4
college 7 |  | 100 | 2009-04-21 00:00:00 | 4
college 8 |  | 100 | 2009-04-22 00:00:00 | 4
college 9 |  | 100 | 2009-04-23 00:00:00 | 4
college 10 |  | 100 | 2009-04-24 00:00:00 | 4
college 11 |  | 100 | 2009-04-25 00:00:00 | 4
college 12 |  | 100 | 2009-04-26 00:00:00 | 4
college 13 |  | 100 | 2009-04-27 00:00:00 | 4
college 14 |  | 100 | 2009-04-28 00:00:00 | 4
college 15 |  | 100 | 2009-04-29 00:00:00 | 4
college 16 |  | 100 | 2009-04-30 00:00:00 | 4
college 17 |  | 100 | 2009-05-01 00:00:00 | 5
college 18 |  | 100 | 2009-05-02 00:00:00 | 5
college 19 |  | 100 | 2009-05-03 00:00:00 | 5
college 20 |  | 100 | 2009-05-04 00:00:00 | 5
college 21 |  | 100 | 2009-05-05 00:00:00 | 5
college 22 |  | 100 | 2009-05-06 00:00:00 | 5
college 23 |  | 100 | 2009-05-07 00:00:00 | 5
college 24 |  | 100 | 2009-05-08 00:00:00 | 5
college 25 |  | 100 | 2009-05-09 00:00:00 | 5
college 26 |  | 100 | 2009-05-10 00:00:00 | 5
college 27 |  | 100 | 2009-05-11 00:00:00 | 5
college 28 |  | 100 | 2009-05-12 00:00:00 | 5
college 29 |  | 100 | 2009-05-13 00:00:00 | 5
college 30 |  | 100 | 2009-05-14 00:00:00 | 5
college 31 |  | 100 | 2009-05-15 00:00:00 | 5
college 32 |  | 100 | 2009-05-16 00:00:00 | 5
college 33 |  | 100 | 2009-05-17 00:00:00 | 5
college 34 |  | 100 | 2009-05-18 00:00:00 | 5
college 35 |  | 100 | 2009-05-19 00:00:00 | 5
college 36 |  | 100 | 2009-05-20 00:00:00 | 5
college 37 |  | 100 | 2009-05-21 00:00:00 | 5
Spreadsheet: 185223d1349576219-recap-of-depreciation-current-year-depreciation
Sheet: Cover

 |  |  | Date |  |  | 2012
Number | Asset Description | [NAME] | Date Acquired | Asset GL # | Acc. Depr GL # | Cost Basis | [NAME]. | METHOD | Life | Rate | Current Depreciation | Current Depreciation
 | Buildings | [NAME]
1 | Rental House - Cove | Cove | 1994-06-11 00:00:00 | 15530 | 16530
 | Total Buildings
 | Appliances
23 | Refrigerator | Refrig | 2006-08-01 00:00:00 | 15310 | 16501 |  |  |  |  |  | 0 | 0
25 | Washer Dryer | Washer | 2007-04-25 00:00:00 | 15310 | 16501 | 400 |  |  |  |  | 17.05 | 0
 | Total Buildings
Spreadsheet: ad2c5e3e-146e-4ba9-a057-5c6aba544449
Sheet: Age 6-9

 | SCHOOL-BASED SERVICES
 | PERSONAL CARE SERVICES (PCS) ASSESSMENT ALLOCATION TOOL
 | Ages 6 to 9 years old
 | Name: |  |  |  |  | MID #:
 | Date of Birth: |  |  |  |  | Age:
 | Instructions:
 | 1) Enter the number response for each question in the "Assessment Score" column. The total score will automatically calculate in the "Allocation Score" column.
 | 2) Use the "Allocation Grid" to determine the number of hours based on the total points scored.
 | 3) If it is determined that the child requires assistance in areas that are considered age appropriate, the nurse must ensure the reason is documented in the comment sections of the assessment.
 | Weighted Score:  The assessment score is weighted by 1.5 for questions 1, 4, 5, 6, 8, 9, and 10.
 | STEP 1:
 |  |  | Question # | Assessment Score | Weighted Score | Allocation Score
 | Grooming |  | 1
 | Dressing upper body |  | 2 |  | n/a
 | Dressing lower body |  | 3 |  | n/a
 | Toileting |  | 4
 | Continence-bladder |  | 5
 | Continence-bowel |  | 6
 | Adaptive Devices |  | 7 |  | n/a
 | Transferring |  | 8
 | Mobility/Ambulation |  | 9
 | Eating/Feeding |  | 10
 | Medication Assist |  | 11 |  | n/a
 | Total Points
 | STEP 2:
 | Allocation Grid
 | Points | Hours | (Please round up if received a .5)
 | 0-3 | 0 hrs/wk
 | 4-9 | 5 hrs/wk
 | 10-15 | 10 hrs/wk
 | 16-20 | 15 hrs/wk
 | 21-30 | 20 hrs/wk |  | Points
 | 31-40 | 25 hrs/wk
 | 41-50 | 30 hrs/wk |  | Hours |  | HRS/WK
 | 51+ | 35 hrs/wk
 | RN Signature:
 | Date:
Spreadsheet: 676460d1588808443-conditional-formatting-progress-bar-if-date-is-in-cell-test-ghantt-chart-excel-forum
Sheet: Sheet1

Range Start Date |  | 2019-11-18 00:00:00
 |  |  | Plan
 |  |  | Forecast
 |  |  | Complete
 |  |  |  | Plan |  |  |  |  | Forecast |  |  |  |  | Complete |  |  |  |  | Plan |  |  |  |  | Forecast |  |  |  |  | Complete |  |  |  |  | Plan |  |  |  |  | Forecast |  |  |  |  | Complete |  |  |  |  | Plan |  |  |  |  | Forecast |  |  |  |  | Complete |  |  |  |  | Plan |  |  |  |  | Forecast |  |  |  |  | Complete
 |  |  |  | 2019-11-19 00:00:00 |  |  |  |  | 2019-11-19 00:00:00 |  |  |  |  | 2020-11-19 00:00:00 |  |  |  |  | 2019-11-25 00:00:00 |  |  |  |  | 2019-12-09 00:00:00 |  |  |  |  | 2019-12-09 00:00:00 |  |  |  |  | 2019-12-01 00:00:00 |  |  |  |  | 2019-12-20 00:00:00 |  |  |  |  | 2019-12-20 00:00:00 |  |  |  |  | 2020-01-08 00:00:00 |  |  |  |  | 2020-01-20 00:00:00 |  |  |  |  |  |  |  |  |  | 2020-01-15 00:00:00 |  |  |  |  | 2020-01-28 00:00:00
Spreadsheet: 0478c1d9-8971-42cb-9381-88acdb976c25
Sheet: 17 Annual Report

17 | Annual report:  Submit a written annual report of chapter accomplishments to the lodge executive committee and/or district committee.
 |  | Written report submitted to the lodge executive committee and district committee and/or executive |  |  | [NAME] | 25
 |  | Written and verbal report given to Scoutmasters at roundtable by the chapter chief |  |  | Silver | 50
 |  | Written and verbal report given to the lodge executive committee and district committee and/or executive by the chapter chief |  |  | Gold | 100
 | Chapters should present and submit a written report of their accomplishments to the lodge executive committee and/or district committee.  This Southern Region Annual Report Template should provide the chapter with a method of organizing concepts for the annual report.  Use this template to help form the annual report, identify the chapter's strengths and weaknesses, and plan for the next year.
 |  | What is the chapter's goal regarding when the written report is completed? |  |  |  |  | Date Goal Made
 | Set the Goal
 |  | List the steps, in back-dater format, to submitting the written report by the goal stated above.
 | Plan Acheivement
 |  |  |  |  | By Chapter Chief?
 |  |  |  | Y/N | Y/N |  | Date
 | Written report submitted to LEC
 | Verbal report given to LEC
 | Written report submitted to district committee and/or district executive
 | Verbal report given to district committee and/or district executive
 | Written report submitted to Scoutmasters at roundtable
 | Verbal report given to Scoutmasters at roundtable
Spreadsheet: 462919d1464248749-div-0-error-work-around-required-test-calc
Sheet: Workings

HD
LD
GRADE | LENGTH |  | WIDTH |  | THICKNESS |  | QTY
 | X |  | Y |  | Z |  |  |  |  |  |  |  |  |  | Length | [NAME]
 |  | x |  | x |  | [NAME] |  | STACKS | SLABS | PIECES | VOLUME |  |  | [NAME] | 1210 | 1210
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XYZ
GRADE | LENGTH |  | WIDTH |  | THICKNESS |  | QTY |  |  |  |  |  |  | No. of pieces per pack
 |  | x |  | x |  | [NAME] |  | STACKS | SLABS | PIECES | VOLUME |  |  | No. of Packs/Labels
Spreadsheet: 725970d1617005001-need-help-to-simplify-the-formula-eosb-computation-v2
Sheet: EOSB Computation 

 | Nature of Leaving | Basic Salary per month | Joining Date | Leaving Date | Years of Service | Calculated EOSB
 | Resignation | 5000 | 2019-11-01 00:00:00
Row # | Nature of Leaving | Year of Service | Entitlement
A9 | Termination | upto 1 Year | No end of service benefits
A10 | Termination | 1 to 5 Years | 21 days of salary for every completed years of service
A11 | Termination | 5 years and above | 31 days of salary for every completed years of service
A12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Resignation
A13 | Resignation | upto 1 Year | No end of service benefits |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Termination
A14 | Resignation | 1 to 3 Years | One third of total entitlement computed as per above slabs ([NAME] and A11)
A15 | Resignation | 3 to 5 Years | Two third of total entitlement computed as per above slabs (Rows 9,10 and 11)
A16 | Resignation | 5 years and above | Full entitlement as per the computation done in accordance with above slabs ([NAME] and A11)
 | Term | Salary per month | Days for computation | Years of Service | Termination | Resignation
 | 1-5 years | 5000 | 21
 | 5 and above Years | 5000 | 31
Spreadsheet: 735176d1622738714-index-match-reference-look_up-data
Sheet: Lookup

ProjectName | TaskFinishDate | TaskIsMilestone | TaskName | Complete | MilestoneType
Project 1 | 2021-04-01 00:00:00 | False | Idea Review Board Complete | No
Project 2 | 2021-04-02 00:00:00 | False | Idea Review Board Complete | No
Project 3 | 2021-04-03 00:00:00 | True | Idea Review Board Complete | No
Project 4 | 2021-04-04 00:00:00 | False | Idea Review Board Complete | No
Project 5 | 2021-04-05 00:00:00 | True | Idea Review Board Complete | No
Project 6 | 2021-04-06 00:00:00 | True | Idea Review Board Complete | No
Project 7 | 2021-04-07 00:00:00 | True | Idea Review Board Complete | No
Project 8 | 2021-04-08 00:00:00 | False | Idea Review Board Complete | No
Project 9 | 2021-04-09 00:00:00 | True | Idea Review Board Complete | Yes
Project 10 | 2021-04-10 00:00:00 | True | Idea Review Board Complete | No
Project 11 | 2021-04-11 00:00:00 | True | Idea Review Board Complete | No
Project 1 | 2021-04-12 00:00:00 | False | Idea Review Board Complete | No
Project 2 | 2021-06-12 00:00:00 | False | Qualify Demand Board Complete | No
Project 3 | 2021-06-13 00:00:00 | False | Qualify Demand Board Complete | No
Project 4 | 2021-06-14 00:00:00 | True | Qualify Demand Board Complete | Yes
Project 5 | 2021-06-15 00:00:00 | False | Qualify Demand Board Complete | No
Project 6 | 2021-06-16 00:00:00 | True | Qualify Demand Board Complete | Yes
Project 7 | 2021-06-17 00:00:00 | False | Qualify Demand Board Complete | No
Project 8 | 2021-06-18 00:00:00 | False | Qualify Demand Board Complete | No
Project 9 | 2021-06-19 00:00:00 | False | Qualify Demand Board Complete | No
Project 10 | 2021-06-20 00:00:00 | False | Qualify Demand Board Complete | No
Project 11 | 2021-06-21 00:00:00 | False | Qualify Demand Board Complete | No
Spreadsheet: 120369d1315242768-latitude-and-longitude-to-eastings-and-northings-utmconversions1
Sheet: Convert UTM to Lat, Long

 | Symbol | Value |  | Northing | 2900000
Datum Constants |  |  |  | Easting | 781496 | E' | -281496
Polar Axis | b | 6356583.8 |  | Zone CM | -123
[NAME] | a | 6378206.4
ecc | e | 0.0822718542230039 |  |  | Decimal | dd | [NAME] | ss
e'2 | e1sq | 0.006814784945915193 |  | Latitude | 26.19340116922286 | 26 | 11 | 36.24420920229402
Scale | k0 | 0.9996 |  | Longitude | -120.1833426483097 | -120 | -11 | 0.03353391483306156
Calculate Footprint Latitude
Arc Length |  | 2901160.464185674
 | mu | 0.4556271956753057
 | e1 | 0.001697915682976889
 | C1 | 0.002546869394350326
 | C2 | 3.783815152380242e-06 |  | Footprint Lat
 | [NAME] | 7.699350197089746e-09 |  | Dec | dd | [NAME] | ss
 | C4 | 1.780742589097072e-11 |  | 26.22104596484999 | 26 | 13 | 15.76547345997139
footprint lat |  | 0.4576435854034057
Constants for [NAME]
sin1" | sin1 | 0
C1 |  | 0.005484412678721791 |  | Delta-Long |  |  | -0.04915994468750003
T1 |  | 0.2425733337600449 |  | D-Long-dec | dd | [NAME] | ss
N1 |  | 6382424.557869688 |  | -2.816657351690325 | -3 | 11 | 0.03353391483146284
R1 |  | 6347611.636132878
D |  | -0.04412251815967844
Coefficients for Calculating Latitude
 | Fact1 | 0.4952185119772496
 | Fact2 | 0.0009733983043755767
 | Fact3 | 9.034628000201809e-07
 | [NAME] | 8.751226333863993e-10
Coefficients for Calculating Longitude
 | LoFact1 | -0.04412251815967844
 | LoFact2 | -2.134026427529225e-05
 | LoFact3 | -1.84612551901197e-08
Spreadsheet: 59748d1260311211-conditionally-populating-a-sheet-from-mulitple-sheets-draft-workbook
Sheet: Refference

1 | January | a |  |  |  | Beging Balance
2 | Febuary | b |  |  | 1 | 150000
3 | March | c |  |  | 2 | 10000
4 | April | d |  |  | 3 | 25000
 | May | e |  |  | 4 | 5000
 | June | f
 | July | g
 | August
 | September
 | October
 | November
 | December
Spreadsheet: 100245d1298648869-graph-dynamic-to-pick-up-only-names-766017
Sheet: Summary Graph

 |  |  | True | True
 |  |  |  |  | select tick mark to illustrate a particular metric on the graph.
 |  |  | ISE Performance |  |  |  |  |  |  |  |  |  |  |  |  |  | Error checker
 |  | ISE Name | YTD Purge Performance | YTD Purge Budget |  |  |  |  |  |  |  |  |  |  |  |  | YTD Purge Performance | YTD Purge Budget
 |  | [NAME] | 12222 | 15000
 |  | [NAME] | 14560 | 17000
 |  | [NAME] | 7500 | 9000
 |  |  | #N/A | #N/A
 |  | 0 | #N/A | #N/A
 |  | 0 | #N/A | #N/A
 |  | 0 | #N/A | #N/A
 |  | 0 | #N/A | #N/A
 |  | 0 | #N/A | #N/A
Spreadsheet: 59911d1260442048-formula-query-possible-if-function-costing-example
Sheet: All Works

Project No. | Month Work Completed | Date | Site | Cost | Site Start Date | Site Completion Date
J16022 | January | 2008-12-18 00:00:00 | High Street, Tenterden, [NAME] | 695
J16023 | December | 2008-12-19 00:00:00 | Royal Hospital | 995 | 2008-12-24 00:00:00
J16024 | December | 2008-12-19 00:00:00 | Kingsland House | 795
[NAME] | January | 2008-12-22 00:00:00 | 43 [NAME] | 495 | 2009-01-08 00:00:00 | 2009-01-08 00:00:00
J16026 | January | 2008-12-22 00:00:00 | 900 Kingsbury Road | 495 | 2009-01-08 00:00:00 | 2009-01-08 00:00:00
J16027 | January | 2008-12-22 00:00:00 | Crewe First Class Lounge | 750 | 2009-01-06 00:00:00 | 2009-01-06 00:00:00
J16028 | January | 2008-12-22 00:00:00 | 242 Fairway Court |  | 2009-01-05 00:00:00
J16029 | January | 2008-12-23 00:00:00 | [NAME] | 3000 | 2009-01-07 00:00:00 | 2009-01-09 00:00:00
[NAME] | January | 2008-12-23 00:00:00 | Albion Street | 2485 | 2009-01-13 00:00:00 | 2009-01-15 00:00:00
J16031 | January | 2008-12-23 00:00:00 | Travel Shop | 1125 | 2009-01-12 00:00:00 | 2009-01-12 00:00:00
J16032 | January | 2008-12-23 00:00:00 | BUPA Offices | 10453 | 2009-01-12 00:00:00 | 2009-01-23 00:00:00
J16033 | January | 2008-12-23 00:00:00 | 49 Jenkin Road | 595 | 2009-01-12 00:00:00 | 2009-01-12 00:00:00
J16034 | January | 2008-12-23 00:00:00 | [NAME] | 2200 | 2009-01-19 00:00:00 | 2009-01-20 00:00:00
 |  |  |  | 21598
Spreadsheet: 206f99a8-add5-4147-beba-c3a97b5fec89
Sheet: Sheet1

AGCO CORP /DE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
8-K
04/30/2013
4205 River Green Parkway
Nominee |  | For |  |  |  | Against |  |  |  | Abstain
[NAME] |  |  | 71702146 |  |  |  | 1773722 |  |  |  | 813172
[NAME] |  |  | 71183638 |  |  |  | 2290845 |  |  |  | 814557
Luiz F. Furlan |  |  | 71554872 |  |  |  | 1921046 |  |  |  | 813122
[NAME] |  |  | 73321810 |  |  |  | 152446 |  |  |  | 814784
[NAME] |  |  | 69815313 |  |  |  | 2621391 |  |  |  | 1852336
[NAME] |  |  | 73317630 |  |  |  | 157938 |  |  |  | 813472
Mallika Srinivasan |  |  | 71886105 |  |  |  | 1583620 |  |  |  | 819315
[NAME] |  |  | 71181613 |  |  |  | 2292410 |  |  |  | 815017
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 762626d1641668547-formual-help-using-an-if-statement-or-something-better-excel-help-mileage-form
Sheet: Sheet1

 |  | Actual Expenses Deduction Use Only |  |  |  | Actual Expenses Deduction Use Only
 |  | [NAME] | 426559 |  |  | [NAME]
 |  | End Odometer | 427135 |  |  | End Odometer | 0
 |  | Total Miles |  |  |  | Total Miles
 |  | % Business |  |  |  | % Business
 |  | [NAME] |  |  |  | Feb Tab
 |  | I would like the Feb Tab to look at the Jan tab and place the End Odometer of Jan into the Start Odometer of Feb.  That's easy enough.  But I do not want the total miles of the Feb odometer to calculate until I input a number into the Feb Odometer End miles.  Currently, it is caculating into a negative number - changing other aspects of my spreadsheet.  I tried an IF Statement like this: =IF(h7>0,0,h7-h6) - I probably wrote it incorrectly. I tried several things but the Total Miles  continues to show as negative. I need it to show zero until I input my final miles for February.  I have [NAME] for all the months and I hope to duplicate this across all [NAME] for the year. I hope this is simple and look forward to an answer.   Thank you all!  Happy New Year!
Spreadsheet: 635dcff7-1e0b-4f49-94b4-2be0621728b0
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261297 | 32652 | [NAME] | Fisher | USA | 3010 | 00:14:05 | 00:02:28 | 00:36:03 | 00:02:05 | 00:28:21 | 1 | 01:23:01
261297 | 51374 | [NAME] | Lesicko | USA | 3008 | 00:14:45 | 00:02:28 | 00:45:39 | 00:02:01 | 00:39:35 | 2 | 01:44:25
261297 | 69956 | [NAME] | [NAME] | USA | 3007 | [NAME] | [NAME] | 00:47:42 | 00:02:24 | 00:36:47 | 3 | 02:03:09
261297 | 60938 | Allysa | Seely | USA | 3009 | 00:13:48 | 00:01:38 | 00:39:20 | 00:01:37 | 00:30:46 | DQ | 00:00:00
Spreadsheet: 684768d1593529449-power-query-join-two-tables-using-not-equal-criteria-pq-example-document-aligw
Sheet: Tables

assetId | startLocationId | endLocationId |  | assetId | homeLocationId
1 | DepotA |  |  | 1 | DepotA |  |  |  |  |  | To get into the Power Query Editor the screenshot below will help…
1 | DepotA | DepotA |  | 2 | DepotB
1 | DepotA | DepotC |  | 3 | DepotA
1 | DepotB | DepotA
1 | DepotD
2 | DepotB | DepotB
2 | DepotB
2 | DepotB | DepotB |  |  | I want to be able to use Power Query to return just the rows from the blue table where the asset starts at its home location but doesn't end up at its home location.  You may wonder why I am using Power Query, as you can probably guess this is not the actual data I am working with and this query I am trying to perform is the last in a long series of queries to get to the data I want.  Moving out of Power Query is not really an option unless what I am asking to do is not possible.  Man I hope it is possible as the thought of redoing my worksheet fills me with dread!!!
2 | DepotA | DepotB
2 | DepotA
3 | DepotA | DepotB
3 | DepotA | DepotD
3 | DepotA | DepotA
3 | DepotB | DepotA
3 | DepotC
Spreadsheet: 9ec53cfb-0870-4507-a74c-938c5405f56a
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44312725 | 2014-12-05 11:45:10 | ALLIES | 1 | 8 | 4 | 679790 | Hermann | 15012 |  | 1945-03-21 |  |  | WWZ 9 : Objectif Tokyo
44316772 | 2014-12-05 19:30:29 | AXIS | 1 | 8 | 6 | 3120 | gonzalan | 15012 |  | 1945-03-21 |  |  | WWZ 9 : Objectif Tokyo
44317173 | 2014-12-05 20:09:47 | ALLIES | 0 | 6 | 8 | 3120 | gonzalan | 15012 |  | 1945-03-21 |  |  | WWZ 9 : Objectif Tokyo
44318551 | 2014-12-05 22:26:07 | ALLIES | 0 | 6 | 8 | 208140 | [NAME] | 15012 |  | 1945-03-21 |  |  | WWZ 9 : Objectif Tokyo
44319434 | 2014-12-05 23:25:08 | AXIS | 0 | 5 | 8 | 208140 | [NAME] | 15012 |  | 1945-03-21 |  |  | WWZ 9 : Objectif Tokyo
44375789 | 2014-12-09 21:24:20 | AXIS | 0 | 3 | 8 | 679790 | Hermann | 14386 | western | 1944-12-31 | 1945-01-01 | The Last Offensive (online version)
44376029 | 2014-12-09 21:40:47 | AXIS | 0 | 5 | 8 | 679790 | Hermann | 14386 | western | 1944-12-31 | 1945-01-01 | The Last Offensive (online version)
44402523 | 2014-12-11 22:00:53 | AXIS | 1 | 8 | 4 | 679790 | Hermann | 14386 | western | 1944-12-31 | 1945-01-01 | The Last Offensive (online version)
44473010 | 2014-12-16 22:00:55 | AXIS | 1 | 11 | 8 | 954304 | Aurelie in wonderland | 15242 | eastern | 1942-09-10 | 1942-11-18 | [Stalingrad] The last Docks | [Stalingrad] Le dernier débarcadère
44474253 | 2014-12-16 22:55:20 | ALLIES | 0 | 8 | 11 | 954304 | Aurelie in wonderland | 15242 | eastern | 1942-09-10 | 1942-11-18 | [Stalingrad] The last Docks | [Stalingrad] Le dernier débarcadère
44499793 | 2014-12-18 21:13:45 | AXIS | 1 | 6 | 4 | 679790 | Hermann | 15719 | western | 1940-05-13 |  |  | Débarquement à BJERKVIK
44500783 | 2014-12-18 22:52:22 | ALLIES | 0 | 6 | 10 | 971161 | mschoenh | 9956 | eastern | 1944-12-17 |  | [NAME]
44501406 | 2014-12-18 23:32:02 | AXIS | 0 | 7 | 10 | 971161 | mschoenh | 9956 | eastern | 1944-12-17 |  | [NAME]