tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 134355d1325247057-lookup-one-value-in-a-range-and-then-lookup-another-value-beneath-it-lookup-3-
Sheet: Sheet1

 | Person/Project | Time (decimal) |  | List of persons
 | Person A | 7.101111111111111 | 1 | Person A | Project 1 (3,8) | Project 2 (2,1) | Project 3 (1,2)
 | Project 1 | 3.756388888888889 | 1.001 | Person B | Project 2 (17,2)
 | Project 2 | 2.118888888888889 | 1.002 | Person C | Project 1 (14,0) | Project 4 (1,0) | Project 5 (1,0)
 | Project 3 | 1.225833333333333 | 1.003 | Person D | Project 1 (1,5)
 | Person B | 17.16666666666667 | 2.003
 | Project 2 | 17.16666666666667 | 2.004
 | Person C | 16 | 3.004
 | Project 1 | 14 | 3.005
 | Project 4 | 1 | 3.006
 | Project 5 | 1 | 3.007
 | Person D | 1.5 | 4.007
 | Project 1 | 1.5 | 4.008
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0 | step 1
 |  |  | 0 | step 2
 |  |  | 0 | step 3, array formula
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: 43902d1242558253-top5-bottom5-from-a-column-of-values-top5bottom5
Sheet: Sheet1

Security Name | ROC
Australian Dollar / Japanese Yen | -0.3378
Australian Dollar / NewZealand Dollar | 0.1348
British Pound / Australian Dollar | 0.1255 |  |  |  |  | Top 5 | Security Name | ROC |  | Bottom 5 | Security Name | ROC
British Pound / Canadian Dollar | 0.6065 |  |  |  |  | 1 |  |  |  | 1
British Pound / Danish Krone | 0.457 |  |  |  |  | 2 |  |  |  | 2
British Pound / Euro | 0.4851 |  |  |  |  | 3 |  |  |  | 3
British Pound / Hong Kong Dollar | 1.0859 |  |  |  |  | 4 |  |  |  | 4
British Pound / Indian Rupee | 0.6922 |  |  |  |  | 5 |  |  |  | 5
British Pound / Japanese Yen | -0.1966
British Pound / New Zealand Dollar | 0.3104
British Pound / Singapore Dollar | 0.7359 |  |  |  | Note: | The number of rows will vary.
British Pound / Swedish Krona | 0.482
British Pound / Swiss Franc | 0.7398
British Pound / US Dollar | 1.0388
Canadian Dollar / Japanese Yen | -0.8491
Euro / Australian Dollar | -0.3409
Euro / Canadian Dollar | 0.1579
Euro / Hong Kong Dollar | 0.5086
Euro / Indian Rupee | 0.1983
Euro / Japanese Yen | -0.5819
Euro / New Zealand Dollar | -0.1463
Euro / Norwegian Krone | 0.2613
Euro / South African Rand | 0.0861
Euro / Swedish Krona | 0.0424
Euro / Swiss Franc | 0.1261
Euro / US Dollar | 0.5083
Gold | 1.0136
Hong Kong Dollar / Japanese Yen | -1.1803
Hong Kong Dollar / Singpore Dollar | -0.3173
[NAME] | -0.8571
New Taiwan Dollar / Japanese Yen | -1.2738
New Zealand Dollar / Japanese Yen | -0.9545
Palladium | -0.4283
Platinum | 1.3908
Silver | 1.9411
Singapore Dollar / Japanese Yen | -0.9055
Swiss Franc / Australian Dollar | -0.5137
Swiss Franc / Japanese Yen | -0.8194
Swiss Franc / Singapore Dollar | 0.0682
Thai Baht / Japanese Yen | -1.0536
US Dollar / Australian Dollar | 0.8571
US Dollar / Canadian Dollar | -0.4198
US Dollar / Chinese Yuan Renminbi | -0.0293
US Dollar / Danish Krone | -0.525
US Dollar / Hong Kong Dollar | 0.0026
US Dollar / Iceland Krona | -0.446
US Dollar / Indian Rupee | -0.3238
US Dollar / Isreali Shekel | 0.2205
US Dollar / Japanese Yen | -1.1484
US Dollar / New Zealand Dollar | 0.6153
US Dollar / Norwegian Krone | -0.2526
US Dollar / Russian Ruble | -0.7274
US Dollar / Singapore Dollar | -0.307
US Dollar / South African Rand | -0.431
US Dollar / Swedish Krona | -0.4667
US Dollar / Swiss Franc | -0.3605
US Dollar / Turkish Lira | -0.262
Spreadsheet: vkaminski__40923__Nordic_VAR_Module
Sheet: Sweden

Total:Day:MWH | Total:Night:MWH
Spreadsheet: 785112d1656157579-count-how-many-times-a-set-of-numbers-appear-together-numbers-in-rows
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 2 | 6 | 8
 | 1 | 8 | 7 | 6 | 4 | 5 | 9 |  | the 3 above numbers appear 2 times in different rows (highlighted) - im trying to count how many times this happens
 | 1 | 2 | 3 | 6 | 8 | 7 | 4
 | 2 | 4 | 6 | 7 | 10 | 8 | 4
 | 2 | 2 | 4 | 4 | 6 | 6 | 8
Spreadsheet: 819677d1677627318-help-with-complicated-formula-cant-figure-out-why-it-works-so-inconsistently-testing
Sheet: OUTPUT

 | Datum | Opis | Konto | Stranka | Analitika | [NAME] | Zapadlost | [NAME] | Veza | DE | Breme originalna DE | Dobro originalna DE | Breme domača DE | Dobro domača DE | ID transakcije
Spreadsheet: 167189d1341924579-excel-2007-complex-lookup-required-copy-of-demo2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Demo
Time | Company | User | [NAME] | Contract | Event | Price | Volume | Logged
 | Champ |  | xyz@xyz | xyz | Logged in | 200 | 10
 | Champ |  | xyz@xyz | xyz | Logging in | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer cancelled | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer back on market | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer modified | 200 | 10
 | xyz |  | xyz@xyz | xyz | Bid back on market | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer back on market | 200 | 10
 | xyz |  | xyz@xyz | xyz | Bid back on market | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer modified | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer back on market | 200 | 10
 | xyz |  | xyz@xyz | xyz | Bid back on market | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer back on market | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer modified | 200 | 10
 | xyz |  | xyz@xyz | xyz | Bid modified | 200 | 10
 | [NAME] |  | xyz@xyz | xyz | Logged in | 200 | 10
 | xyz |  | xyz@xyz | xyz | Bid modified | 200 | 10
 | [NAME] |  | xyz@xyz | xyz | Logged out | 200 | 10
 | [NAME] |  | xyz@xyz | xyz | Logged in | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer modified | 200 | 10
 | [NAME] |  | xyz@xyz | xyz | Logged out | 200 | 10
 | xyz |  | xyz@xyz | xyz | Bid modified | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer modified | 200 | 10
 | xyz |  | xyz@xyz | xyz | Bid modified | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer modified | 200 | 10
 | [NAME] |  | xyz@xyz | xyz | Logged in | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer back on market | 200 | 10
 | xyz |  | xyz@xyz | xyz | Bid back on market | 200 | 10
 | xyz |  | xyz@xyz | xyz | Bid modified | 200 | 10
 | xyz |  | xyz@xyz | xyz | Block registered deal | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer modified | 200 | 10
 | xyz |  | xyz@xyz | xyz | Bid modified | 200 | 10
 | xyz |  | xyz@xyz | xyz | Block registered deal | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer modified | 200 | 10
 | xyz |  | xyz@xyz | xyz | Bid modified | 200 | 10
 | xyz |  | xyz@xyz | xyz | Offer modified | 200 | 10
 | [NAME] |  | xyz@xyz | xyz | Logged in | 200 | 10
Spreadsheet: 76525d1277093206-conditional-count-sample
Sheet: Sheet1

a | 11
b | 11 |  | 11
c | 11
a | 12 | 12
c | 12
d | 12
a | 13 | 13
b | 13 |  | 13
d | 13
Spreadsheet: 67689d1268249973-analyse-answers-from-a-questionnaire-training-evaluation-compilation-intro-to-cmmi
Sheet: Instructions

Worksheet | Instructions
Key to Q | This sheet shows the questions that appear on the survey.
 | The first column is the question number as it appears on the survey.
 | The second column is an abbreviation for the question used to report survey results.
 | The third column is the survey question as it appears on the survey.
 | Review the survey and ensure that the questions in this worksheet match the survey.
Data Entry | This sheet is for entering the answers from each individual survey.
 | For proper control of the survey data, divide the surveys into two piles, one for each site.  For each site, number the surveys sequentially.  This is so that if you need to go back later and check data entered into this spreadsheet against a survey, you will be able to trace back to which survey you need to check.
 | For each survey, record the answers in the appropriate column.  If the respondant did not answer a question, enter an "N" in the box.  If the respondant marked in between two ratings, enter the higher rating.
Work Area | These are hidden sheets with formulas to collate the answers by each question.
 | There is no need to modify these pages.
Frequency | This sheet shows the number of answers in each rating category for each question by site and for both sites combined.
Charts | This sheet shows three bar graphs for each question showing the number of answers in each rating for each site and both combined.
 | This sheet is formatted to print a three-page report showing all the charts.
Spreadsheet: jonathan_mckay__16914__Lindsay- Buy
Sheet: EDC-Lindsay Park

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | [NAME] |  |  |  |  | Deal Date: |  | 2001-07-27 00:00:00 |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  |  | Deal ID #: |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  |  | Unit of Measure: |  | GJ |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  |  | Volume (Monthly/Daily): |  | Monthly |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  |  | Price: |  | 4.72 |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  |  | Buy/Sell: |  | Sell |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Rate 11 Fuel | Rate 13 Fuel | Rate 11 Total |  | Rate 13 Total
 | January |  | 6869
 | February |  | 5642
 | March |  | 5136
 | April |  | 3905
 | May |  | 2415
 | June |  | 1840
 | July |  | 1443
 | August |  | 1399
 | September |  | 1897
 | October |  | 3371
 | November |  | 3968
 | December |  | 4791
 | TOTAL:
Spreadsheet: 785698d1656557498-ranking-the-1st-places-2nd-places-and-3rd-places-test
Sheet: Sheet1

 |  | RANK | Team Name | Point | Won | Lost | Draw | Score For | Score against | [NAME] |  |  |  | Group Rankings
 |  |  | Team A | 3 | 1 | 1 | 0 | 12 | 8 | 4 |  |  |  |  | Group 1 | Group 2 | Group 3
 |  |  | Team B | 3 | 1 | 1 | 0 | 4 | 12 | -8 |  |  |  | 1st
 |  |  | Team C | 3 | 1 | 1 | 0 | 7 | 3 | 4 |  |  |  | 2nd
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd
 |  | RANK | Team Name | Point | Won | Lost | Draw | Score For | Score against | [NAME] |  |  |  | Ranking of 1st Places |  |  | Ranking of 2nd Places
 |  |  | Team D | 4 | 1 | 0 | 1 | 6 | 0 | 6 |  |  |  | 1st |  |  | 1st
 |  |  | Team E | 2 | 0 | 0 | 2 | 3 | 3 | 0 |  |  |  | 2nd |  |  | 2nd
 |  |  | Team F | 0 | 0 | 2 | 0 | 0 | 3 | -3 |  |  |  | 3rd |  |  | 3rd
 |  | RANK | Team Name | Point | Won | Lost | Draw | Score For | Score against | [NAME] |  |  |  | Ranking of 3rd Places
 |  |  | Team G | 4 | 1 | 0 | 1 | 7 | 1 | 6 |  |  |  | 1st
 |  |  | Team H | 1 | 0 | 1 | 1 | 2 | 3 | -1 |  |  |  | 2nd
 |  |  | Team I | 1 | 0 | 1 | 1 | 2 | 4 | -2 |  |  |  | 3rd
Spreadsheet: 829013d1683843728-if-b6-no-input-complete-reason-in-b7-then-if-c7-has-text-make-b7-blank-email-again-new-checklist-for-disclosures-under-the-utaa
Sheet: Client Care

Client Care
ITEM | [NAME] | REASON WHY ANSWER IS NO / ANY COMMUNICATION YOU NEED TO RECORD???  Acm TO LOOK HERE??
Confirm that payment has been received | Yes
If request was from the Agent – check if owner name and unit number is correct from Strataware and that it is in fact a request for a Pre-Contract Disclosure Statement. | N/A
Agent must confirm that they act on behalf of the owner and has provided a copy of agent agreement or authorization from owner. | No | TESTING ON THIS ONE WHEN I TYPE THE DATA IN THIS CELL AND HIT ENTER THEN THE FALSE replaces the Complete Reason
If request was from the Owner – check if owner name and unit number is correct from Strataware and that it is in fact a request for a Pre-Contract Disclosure Statement.
Check notes in front screen of Strataware and refer to previous Pre-Contract Disclosure Statement. Check Vision or Strataware for the correct Accessory Unit/s. Any questions please always check with Account Manager. | No | Here I typed in a Reason or anything for that matter - the text triggers the "complete reason" to disappear as soon as you hit enter.
Print out owner statement & also go into the levies prepare screen and click on preview of all cost centers which shows all levy instalments or any discounts and special levy amounts.
- Highlight any debt collection charges and penalty interest (color code)
Attachments: - | No |  | Here you can see if no data in colum C then the Complete Reason is as I want it.
-  Request for Pre-Contract Disclosure Statement
- Owner Statement printout (to ACMs only)
- Latest Financial Accounts (Balance Sheet of all Cost Centers) of the BC
- Latest Approved Budget
Double check the document if the information written are correct and check for spelling and grammatical errors.
Save the following documents on X:Drive:
- Email requesting S146
- All levy workings
- Word & PDF versions of S146
Completed By: |  | Click on the Dropdown Arrow and Select your Name
Spreadsheet: 1aed33c6-9f44-4f82-8be9-a9496fd18825
Sheet: Sheet1

STACKS MANAGEMENT STUDENT EMPLOYEE TRAINING CHECKLIST | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
NAME: |  | ACADEMIC YEAR:
GENERAL INFORMATION | BASIC | SLF.TRN.GUIDE | REVIEW | APPROVED
ACTIVITY LOG
LOCATION & USE OF MANUALS
ATTENDANCE RULES
CONDUCT WHILE WORKING
IDENTIFICATION BADGES
PRIVACY RULES
BULLETIN BOARD & STAND-UP NOTICES
DAILY DUTIES CHART
ASSIGNMENT PRIORITIES
TRAINING GUIDES
SELF-GUIDED TOUR
INTRODUCTION TO PERIODICALS
INTRODUCTION TO THE EMC
INTRODUCTION TO CALL NUMBERS
LC CALL NUMBER CARD TEST
LC CALL NUMBER WRITTEN TEST
ADDITIONAL PROJECTS
DAILY DUTIES/ASSIGNMENTS | BASIC | SLF.TRN.GUIDE | REVIEW | APPROVED
BOOKDROP NEWSPAPERS
PICKUP: STATISTICS LOG
PICKUP: FIRST FLOOR
PICKUP: SECOND FLOOR SOUTH
PICKUP: SECOND FLOOR NORTH
PICKUP: THIRD FLOOR
CURRENT PERIODICALS
MAIN COLLECTION CLEANUP
SEARCH BOX
MAIN COLLECTION
EMC
GOVERNMENT DOCUMENTS
LEISURE READING
BOUND PERIODICALS
QUARTOS: SHELVING & CLEANUP
LEISURE READING: SHELV. & CLEANUP
MICROFORMS: SHELVING
MICROFORMS & COMPACT STORAGE
OTHER DUTIES | BASIC | SELF-TRAINING | REVIEW | APPROVED
SHELVING: BOOKS
SHELVING: EMC
END OF THE MONTH NEWSPAPERS
SHELVING: NEWSPAPERS
STAGING: LOCATION & USE
ORGANIZING BOOK TRUCKS
ORGANIZING  EMC TRUCKS
SHELFREADING PERIODICALS
SHELFREADING BOOKS
SHELFSCANNING BOOKS
PERIODICAL USE STUDY
SHIFTING PERIODICALS
SHIFTING BOOKS
Spreadsheet: 489555d1479321510-custom-list-based-on-value-fifa-17
Sheet: Pivot Lookups

Row Labels |  | Position | CB |  | Position | CM |  | Position | GK |  | Position | LB |  | Position | RB |  | Position | ST |  | Position | W
CB
CM |  | Row Labels |  |  | Row Labels |  |  | Row Labels |  |  | Row Labels |  |  | Row Labels |  |  | Row Labels |  |  | Row Labels
GK |  | [NAME] |  |  | [NAME] |  |  | Darlow |  |  | [NAME] |  |  | Gamez |  |  | [NAME] |  |  | Aarons
LB |  | Good |  |  | Colback |  |  | [NAME] |  |  | [NAME] |  |  | Yedlin |  |  | Gayle |  |  | Barlaser
RB |  | Hanley |  |  | Diame |  |  | Krul |  |  | Haidara |  |  |  |  |  | Mitrovic |  |  | Gouffran
ST |  | Lascelles |  |  | Hayden |  |  | Sels |  |  | Lazaar |  |  |  |  |  | Murphy |  |  | [NAME]
W |  | Mbemba |  |  | [NAME] |  |  | Woodman |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  | Shelvey |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  | Tiote
Spreadsheet: joe_parks__14563__Tenaska IV Est Imbalance0302
Sheet: Sheet1

Tenaska IV Cleburne Plant
TXU Lone Star Pipeline
March 2002
Estimated Usages*
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
RECEIVED | 24875 | 34650 | 34650 | 34650 | 34650 | 0 | 0 | 0 | 0 | 0
DELIVERED | 7645.192999999999 | 32484 | 31317 | 32907 | 27270 | 0 | 0 | 0 | 0 | 0
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
RECEIVED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DELIVERED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
RECEIVED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DELIVERED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
*These numbers are based on estimates and are subject to change
Spreadsheet: 815662d1675130938-help-understanding-formua-l
Sheet: Sheet1 (2)

A | B | C | D | E | F | G | H | I | J | K | L | M | N
 | LEVEL |  |  |  | FLOOR TIME WKLD | FLOOR PROJ WKLD | Total | BACKUPS | Shortage (-) | Shortage (-) | TOTAL PERSONNEL | PERSONS AVAIL FOR FLOOR | STANDBYE STAFF
 | 1 | 2 | 3 | 4 |  |  | FLOOR | Available | or Excess | or Excess
DEPT/DIV |  |  |  |  |  |  | Workload | Workload | FLOOR | BACKUPS
TOOLS | 2 | 2 | 0 | 0 |  | 412.95
ELECTRONICS | 2 | 2 | 2 | 2 |  | 0
AUTO | 5 | 6 | 3 | 6 |  | 0 |  |  |  |  |  |  | 1
Spreadsheet: 740597d1626414942-working-with-adding-subtracting-hours-and-minutes-sample-49-ans
Sheet: Sheet1

 |  |  |  | Route Time |  |  |  |  |  | Route + Prep
 |  |  | First Route | 1.3 | <-- is saying 1.3 hours (1 hour, 18 minutes)
 |  |  | Second Route | 1.3 |  |  |  |  |  |  |  | Prep Time | 0.75 | <-- is saying 0.75 hours (45 minutes)
 |  |  | Third Route | 1.3
 |  |  | Fourth Route | 1.3
 |  |  | Fifth Route | 1.3
 |  |  | Sixth Route | 1.3
 |  |  |  |  |  |  |  |  |  |  |  | 1.) Route time is added to "prep time" for each individual "route"
 |  |  |  |  |  |  |  |  |  |  |  | 2.) Each Route *can* be a different length, but I kept it all 1.3 for an easy example
 |  |  |  |  |  |  |  |  |  |  |  | 3.) The prep time remains constant, but influences all results of each route time
 |  |  |  |  |  |  |  |  |  |  |  | 4.) Origin through 4th route are all working "backwards" from desired depature, while final stretch goes forward
 |  | Origin |  | <-- this result should be 20:06
 |  | Second Route |  | <-- this result should be 22:09
 |  | Third Route |  | <-- why does it go negative?  This should be 00:12
 |  | Fourth Route |  | <-- this is just fine
 |  | Desired Depature | 4:00:00
 |  | Final Stretch |  | <-- this is just fine
Spreadsheet: 761521d1640975681-combine-multiple-sheets-into-one-example-sheet
Sheet: Master Sheet

Export Origin | Data Heading | Data Heading | Data Heading
Export 1 | Data from export | Data from export | Data from export
Export 1 | Data from export | Data from export | Data from export
Export 1 | Data from export | Data from export | Data from export
Export 1 | Data from export | Data from export | Data from export
Export 2 | Data from export | Data from export | Data from export
Export 2 | Data from export | Data from export | Data from export
Export 2 | Data from export | Data from export | Data from export
Export 2 | Data from export | Data from export | Data from export
Export 2 | Data from export | Data from export | Data from export
Export 2 | Data from export | Data from export | Data from export
Export 2 | Data from export | Data from export | Data from export
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: East Power Orig w Analyst

 | East Power Origination
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | of Total |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  |  | 0
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 33600 | 1
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  |  |  | Sr. Specialist | 78000 | 1
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Associate | 97200 | 1
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Manager | 120000 | 5
 |  |  |  |  |  |  |  |  | Director | 156000 | 7
 | Headcount |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  | VP | 216000 | 1
 | Analyst & Associate Headcount |  |  |  |  |  |  |  | MD | 240000
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 524067
 |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 685647d1594125028-finding-data-across-multiple-sheets-excelforum__help_file
Sheet: JE_Jan

 |  | 1 | white
 |  | 2
 |  | 3 | red
 |  | 4 | blue
 |  | 5 | green
 |  | 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
Spreadsheet: 849571d1699995262-dependent-drop-down-lists-containing-unique-values-book3
Sheet: Sheet2

20698 | 20699 | 20703
2 | 21 | 18
4 | 21 | 18
11 | 21 | 17
8 | 21 | 17
3 | 21 | 18
4 | 21 | 17
3 | 21 | 18
14 | 21 | 17
6 | 21 | 18
3 | 21 | 17
9 | 21 | 17
4 | 21 | 18
9 | 21 | 18
9 |  | 18
 |  | 17
 |  | 18
 |  | 17
 |  | 18
 |  | 18
 |  | 18
 |  | 18
 |  | 17
 |  | 17
 |  | 18
Spreadsheet: 467222d1466619668-range-formula-help-needed-book6
Sheet: Median

Based on Median (Vented Core) |  |  |  |  |  |  |  | Based on Median ([NAME])
Frame | Poles | Motor Type | Horsepower |  |  |  |  | Frame | Poles | Motor Type | Horsepower
 |  | Vented Core | 0>700 | 701>1250 | 1251>3000 | 3001>18,000 |  |  |  | [NAME] | 0>700 | 701>1250 | 1251>3000 | 3001>18,000
500 | 2-pole | Yes |  |  | 6.09 |  |  | 500 | 2-pole | Yes | 2.71
 | 4-pole |  |  |  |  |  |  |  | 4-pole
 | 6-pole |  |  |  |  |  |  |  | 6-pole |  |  |  |  |  |  | ** Return column J from VSM tab if Criteria is met.
 | 8-pole |  |  |  |  |  |  |  | 8-pole
 | 10-pole |  |  |  |  |  |  |  | 10-pole
 | 12-pole |  |  |  |  |  |  |  | 12-pole
 | 16-pole |  |  |  |  |  |  |  | 16-pole
580 | 2-pole |  |  |  |  |  |  | 580 | 2-pole
 | 4-pole |  |  |  |  |  |  |  | 4-pole
 | 6-pole |  |  |  |  |  |  |  | 6-pole
 | 8-pole |  |  |  |  |  |  |  | 8-pole
 | 10-pole |  |  |  |  |  |  |  | 10-pole
 | 12-pole |  |  |  |  |  |  |  | 12-pole
 | 16-pole |  |  |  |  |  |  |  | 16-pole
680 | 2-pole |  |  |  |  |  |  | 680 | 2-pole
 | 4-pole |  |  |  |  |  |  |  | 4-pole
 | 6-pole |  |  |  |  |  |  |  | 6-pole
 | 8-pole |  |  |  |  |  |  |  | 8-pole
 | 10-pole |  |  |  |  |  |  |  | 10-pole
 | 12-pole |  |  |  |  |  |  |  | 12-pole
 | 16-pole |  |  |  |  |  |  |  | 16-pole
800 | 2-pole |  |  |  |  |  |  | 800 | 2-pole
 | 4-pole |  |  |  |  |  |  |  | 4-pole
 | 6-pole |  |  |  |  |  |  |  | 6-pole
 | 8-pole |  |  |  |  |  |  |  | 8-pole
 | 10-pole |  |  |  |  |  |  |  | 10-pole
 | 12-pole |  |  |  |  |  |  |  | 12-pole
 | 16-pole |  |  |  |  |  |  |  | 16-pole
630 | 2-pole |  |  |  |  |  |  | 630 | 2-pole
 | 4-pole |  |  |  |  |  |  |  | 4-pole
 | 6-pole |  |  |  |  |  |  |  | 6-pole
 | 8-pole |  |  |  |  |  |  |  | 8-pole
 | 10-pole |  |  |  |  |  |  |  | 10-pole
 | 12-pole |  |  |  |  |  |  |  | 12-pole
 | 16-pole |  |  |  |  |  |  |  | 16-pole
710 | 2-pole |  |  |  |  |  |  | 710 | 2-pole
 | 4-pole |  |  |  |  |  |  |  | 4-pole
 | 6-pole |  |  |  |  |  |  |  | 6-pole
 | 8-pole |  |  |  |  |  |  |  | 8-pole
 | 10-pole |  |  |  |  |  |  |  | 10-pole
 | 12-pole |  |  |  |  |  |  |  | 12-pole
 | 16-pole |  |  |  |  |  |  |  | 16-pole