tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 678798d1590067273-sumproduct-vlookup-combined-help-needed-oee-file-sample
Sheet: summary

Date | Shift | OLIVIA      T2 (hh:[NAME]) |  |  | OLIVIA      T1 (hh:[NAME]) |  |  | 103   T 4 (hh:[NAME]) |  |  | 104 T 3 (hh:[NAME]) |  |  | 101 T 5 (Div) (hh:[NAME]) |  |  | Manual  (Amazon) |  |  | Manual 1 (1 -2) |  |  | Manual 2 (1 - 2)
 |  | total hours of operation | manhours used new process | manhours used old process | total hours of operation | manhours used new process | manhours used old process | total hours of operation | manhours used new process | manhours used old process | total hours of operation | manhours used new process | manhours used old process | total hours of operation | manhours used new process | manhours used old process | total hours of operation | manhours used new process | manhours used old process | total hours of operation | manhours used new process | manhours used old process | total hours of operation | manhours used new process | manhours used old process
2020-05-01 00:00:00 | Earlies
2020-05-01 00:00:00 | Lates
2020-05-01 00:00:00 | Nights
2020-05-02 00:00:00 | Earlies
2020-05-02 00:00:00 | Lates
2020-05-02 00:00:00 | Nights
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Authorization

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Eligibility Determination
Activity Name | Authorization
Activity Description / Purpose | The worker must complete an authorization form to support their benefit issuance recommendation
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Complete full data entry into WMS
Write payment lines
Correct 'fatal' errors
Process eligibility in WMS
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 330b26c4-e866-42b9-9335-012549b95654
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 |  |  | STARTUP EXPENSES
 |  |  | Enter your company name here
SOURCES OF CAPITAL
Owners' Investment (name and percent ownership)
Your name and percent ownership | 0
Other investor | 0
Other investor | 0
Other investor | 0
Total Investment | 0
Bank Loans
Bank 1 | 0
Bank 2 | 0
Bank 3 | 0
Bank 4 | 0
Total Bank Loans | 0
Other Loans
Source 1 | 0
Source 2 | 0
Total Other Loans | 0
STARTUP EXPENSES
Buildings/Real Estate
Purchase | 0
Construction | 0
Remodeling | 0
Other | 0
Total Buildings/Real Estate | 0
Leasehold Improvements
Item 1 | 0
Item 2 | 0
Item 3 | 0
Item 4 | 0
Total Leasehold Improvements | 0
Capital Equipment List
Furniture | 0
Equipment | 0
Fixtures | 0
Machinery | 0
Other | 0
Total Capital Equipment | 0
Location and Admin Expenses
Rental | 0
Utility deposits | 0
Legal and accounting fees | 0
Prepaid insurance | 0
Pre-opening salaries | 0
Other | 0
Total Location and Admin Expenses | 0
Opening Inventory
Category 1 | 0
Category 2 | 0
Category 3 | 0
Category 4 | 0
Category 5 | 0
Total Inventory | 0
Advertising and Promotional Expenses
Advertising | 0
Signage | 0
Printing | 0
Travel/entertainment | 0
Other/additional categories | 0
Total Advertising/Promotional Expenses | 0
Other Expenses
Other expense 1 | 0
Other expense 2 | 0
Total Other Expenses | 0
Reserve for Contingencies | 0
Working Capital | 0
SUMMARY STATEMENT
Sources of Capital
Owners' and other investments | 0
Bank loans | 0
Other loans | 0
Total Source of Funds | 0
Startup Expenses
Buildings/real estate | 0
Leasehold improvements | 0
Capital equipment | 0
Location/administration expenses | 0
Opening inventory | 0
Advertising/promotional expenses | 0
Other expenses | 0
Contingency fund | 0
Working capital | 0
Total Startup Expenses | 0
SECURITY AND COLLATERAL FOR LOAN PROPOSAL
Collateral for Loans | Value | Description
Real estate | 0
Other collateral | 0
Other collateral | 0
Other collateral | 0
Owners
Your name here
Other owner
Other owner
Loan Guarantors (other than owners)
Loan guarantor 1
Loan guarantor 2
Loan guarantor 3
Spreadsheet: 271751d1382034673-auto-populate-cells-based-on-data-validation-and-free-form-entry-budget-temp-basic-
Sheet: Sheet1

 | VARIABLE COSTS/CONSUMABLES
 | Account Number | Expense Sub-Category | Payment Occurrence | Month | Description | Unit Cost (USD$) | Number of Payments | Total Annual Cost |  | January | February | March | April | May | June | July | August | September | October | November | December
 | 6010005 | Fuel - Non Vehicle | Monthly | May |  | 24 | 12 | 288 |  | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24
 | 6010010 | Oil- ALL | Monthly |  |  | 50 | 12 | 600 |  | False
 | 6010015 | Coolant- ALL | Quarterly |  |  |  | 4
 | 6010020 | Filters- ALL
 |  |  |  |  |  | 74 |  | 888 |  | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24
Spreadsheet: 54577d1254589542-excel-2007-trying-to-display-a-drop-down-list-when-a-number-is-entered-into-a-cell-book1
Sheet: DA

TO | Dive Academy |  |  | Invoice No.
 | Bophut |  |  | SPA
 | [NAME] |  |  | 59/9 Moo 4 |  | SPA offers compreshensive servicing of all of your dive related equipment.
 | [NAME], 84320 |  |  | Bophut, Koh Samui
 |  |  |  | [NAME], 84320 |  | We can service the following:-
DAY | QUANTITY | [NAME] |  | UNIT PRICE | TOTAL THB | Aqualung Regulators
1 |  | Scubapro BCD Service
2 |  | Scubapro BCD Service
3 |  | [NAME] |  |  |  | Scubapro Regulators
4 |  | Aqualung Unbalanced Reg Service
5 |  | Aqualung Unbalanced Reg Service
6 |  | Aqualung Unbalanced Reg Service |  |  |  | Air Cyclinder Cleaning  - 200 BHT
7 |  | Scubapro Unbalanced Reg Service |  |  |  | Clean and roll tank with cleaning media - removes entrained oil residues.
8 |  | Aqualung Unbalanced Reg Service
9 |  | Aqualung Unbalanced Reg Service |  |  |  | Visual Inspection of Air Cyclinder
10 |  | Aqualung Unbalanced Reg Service |  |  |  | Check air cyclinder for signs of structural damage and contamination.
11 |  | Aqualung Unbalanced Reg Service
12 |  | Aqualung Unbalanced Reg Service |  |  |  | Oxygen Cleaning Air Cylinder for EAN Use
13 |  | Aqualung Unbalanced Reg Service |  |  |  | We inspect, dismantle and clean the entire cyclinder and valve. We only use
14 |  | Aqualung Unbalanced Reg Service |  |  |  | oxygen compatiblr lubricants.
15 |  | Aqualung Unbalanced Reg Service
16 |  | Aqualung Unbalanced Reg Service |  |  |  | Valve cleaning and servicing
17 |  | Aqualung Unbalanced Reg Service |  |  |  | We can dismantle and service all valve types. We always replace all O-rings and
18 |  | Aqualung Unbalanced Reg Service |  |  |  | replace high pressure seat if required at extra cost.
19 |  | Aqualung Unbalanced Reg Service
20 |  | Aqualung Unbalanced Reg Service |  |  |  | Clean and replace O-rings only |  |  | 120 BHT
21 |  | Aqualung Unbalanced Reg Service |  |  |  | Clean replace O-rings and HP Seat |  |  | 320 BHT
22 |  | Aqualung Unbalanced Reg Service
23 |  | Aqualung Unbalanced Reg Service |  |  |  | BCD Servicing
24 |  | Aqualung Unbalanced Reg Service |  |  |  | We can completely service all brands of BCD. Please ask us for details about pricing.
25 |  | Aqualung Unbalanced Reg Service
26 |  | Aqualung Unbalanced Reg Service
27 |  | Aqualung Unbalanced Reg Service
28 |  | Aqualung Unbalanced Reg Service
29 |  | Aqualung Unbalanced Reg Service
30 |  | Aqualung Unbalanced Reg Service
31 |  | Aqualung Unbalanced Reg Service
 |  |  | Subtotal
 |  |  | Total
 | Thankyou for you business
Spreadsheet: 125001d1318795559-excel-2007-match-using-index-or-vloopup-for-value-volume-sells
Sheet: Main

 | Type | Error | Stock
1 | PC | Harddrive
2 | MAC | Harddrive
3 | PC | Monitor
4 | MAC | Monitor
5 | PC | Keyboard
6 | PC | Touchpad
7 | PC | Sound
Spreadsheet: 271167d1381850836-converting-time-to-hours-blank-billing-worksheet
Sheet: September 2013 BASC Billing

Name | Total $ | Rate | Total hrs | 2013-10-01 00:00:00 | 2013-10-02 00:00:00 | 2013-10-03 00:00:00 | 2013-10-07 00:00:00 | 2013-10-08 00:00:00 | 2013-10-09 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | 2013-10-15 00:00:00 | 2013-10-16 00:00:00 | 2013-10-17 00:00:00 | 2013-10-18 00:00:00 | 2013-10-21 00:00:00 | 2013-10-22 00:00:00 | 2013-10-23 00:00:00 | 2013-10-24 00:00:00 | 2013-10-25 00:00:00 | 2013-10-28 00:00:00 | 2013-10-29 00:00:00 | 2013-10-30 00:00:00 |  |  | [NAME], Amt
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
 |  | 12
Late pickups (Carpool)
Late pickups (After School)
Total
Spreadsheet: jane_tholt__13055__June 12 With SOH Upgrade But No EOC Advantage
Sheet: Basin Allocations

Calculate Pooling Area Market Shares Based on Receipt Capacity
Supply Area | DRN | Design Limit |  | Shippers with Permian Only |  | Adjusted Percentages to Eliminate |  | Shippers with SJ Only
BONDADST | 20 |  |  |  |  | Keystone to Waha Constraint
BONDAD ML | 216747
BLANCO | 216748 |  |  |  |  | Adjustment | 0.1010978260295798
ANADARKO | 216749
PLAINS | 216751
[NAME] | 216750 |  |  |  |  | decrease by adjustment
WAHA | 216752 |  |  |  |  | increase by adjustment
 | Total
Spreadsheet: 149065d1333670575-need-to-pull-multiple-reference-points-into-one-spread-sheet-project-20sample-1-
Sheet: April

April | COST | LABOR | UNITS | TIME
ABC | 1 | 5 | 4 | 4
DEF | 3 | 13 | 5 | 5
GHI | 5 | 4 | 6 | 6
JKL | 13 | 5 | 2 | 9
MNO | 5 | 9 | 8 | 8
PQR | AprilCOST | AprilLABOR | AprilUNITS | AprilTIME
STU | 8 | 2 | 2 | 2
VWX | 1 | 4 | 4 | 5
YZA | 1 | 8 | 5 | 8
BCD | 5 | 9 | 6 | 8
EFG | 185 | 63 | 5 | 8
HIJ | 2 | 2 | 52 | 9
KLM | 8 | 4 | 2 | 65
Spreadsheet: 881437d1729519443-search-multiple-values-against-list-example
Sheet: Sheet1

No. | Description | Quantity
10000361 | part 1 | 1
10002891 | part 2 | 1
10005079 | part 3 | 1
10005105 | part 4 | 1
10005163 | part 5 | 2
10005302 | part 6 | 1
10005354 | part 7 | 1
10005417 | part 8 | 1
10005489 | part 9 | 1
10005513 | part 10 | 1
Spreadsheet: 770578d1646161171-using-columns-searching-of-mins-and-maxs-number-and-using-them-in-a-formula-allocate-points
Sheet: Sheet1

Given HCP |  |  |  | Use this col. |  |  |  |  |  |  |  |  | Example:
-2 | Hole HCP -> | 17 | 15 | 1 | 5 | 13 | 7 | 3 | 11 | 9 |  |  | Because the given hcp is -2 in a nine hole play (as this is) the hcp 1 would be used.
Par |  | 4 | 4 | 4 | 4 | 4 | 5 | 3 | 5 | 3 | score |  | This person would get -1 on there score making the point from 1 to 2 points.
Score |  | 4 | 6 | 5 | 3 | 2 | 5 | 4 | 5 | 3 |  |  | All without changing their score posted.
 |  |  |  |  |  |  |  |  |  |  | Total points
Points
Given HCP |  | Use this col. | Use this col. |  |  |  |  |  |  |  |  |  | Example:
4 | Hole HCP -> | 17 | 15 | 1 | 5 | 13 | 7 | 3 | 11 | 9 |  |  | Because the given hcp is 4 in a nine hole play (as this is) the hcp 17 and hcp 15 would be used.
Par |  | 4 | 4 | 4 | 4 | 4 | 5 | 3 | 5 | 3 | score |  | This person would get +1 on each said hole their score making the point from 2 to 1 points and 1 to 0 respectfully.
Score |  | 4 | 5 | 5 | 3 | 2 | 5 | 4 | 6 | 3 |  |  | All without changing their score posted.
 |  |  |  |  |  |  |  |  |  |  | Total points
Points |  |  |  |  |  |  |  |  |  |  |  |  | I need to be able to change the "Given HCP" at will changing the holes used based on HCP.
Spreadsheet: 8f4da84b-f6e2-44b1-8b45-addfb4274bc9
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
[NAME] | 706301667620 | Chanticleer | Wondrous Love: A World Folk Song Collection | 2008-07-01 | Compact Disc | Classical | 16.99 | Y | Available
[NAME] | 745099087821 | Chanticleer | Where The Sun Will Never Go Down: Spituals And Traditional Gospel Music | 2008-07-01 | Compact Disc | Classical | 16.99 | Y | Available
[NAME] | 825646029020 | Chanticleer | Purcell: [NAME], Anthems & Sacred Songs | 2008-07-01 | Compact Disc | Classical | 17.99 | Y | Available
[NAME] | 809274855626 | Chanticleer | Our American Journey | 2008-07-01 | Compact Disc | Classical | 17.99 | Y | Available
Spreadsheet: 145543d1331645831-time-card-workbook-pivot-tables-best-way-copy-of-2012-hour-log
Sheet: Data Sheet

Employee | Date | Week | Month | Year | Hours | Pay Rate |  |  |  |  |  |  |  | Pay Rate
Francisco | 2012-01-02 00:00:00 |  |  |  | 2 |  |  |  |  |  |  |  |  | Francisco | 11.5
Martin | 2012-01-02 00:00:00 |  |  |  | 3 |  |  |  |  |  |  |  |  | Martin | 10.5
[NAME] | 2012-01-02 00:00:00 |  |  |  | 5 |  |  |  |  |  |  |  |  | [NAME] | 9.75
[NAME] | 2012-01-02 00:00:00 |  |  |  | 8 |  |  |  |  |  |  |  |  | [NAME] | 9.75
[NAME] | 2012-01-02 00:00:00 |  |  |  | 9 |  |  |  |  |  |  |  |  | [NAME] | 9.75
[NAME] | 2012-01-02 00:00:00 |  |  |  | 6 |  |  |  |  |  |  |  |  | [NAME] | 8.5
[NAME] | 2012-01-02 00:00:00 |  |  |  | 3 |  |  |  |  |  |  |  |  | [NAME] | 8.5
[NAME] | 2012-01-02 00:00:00 |  |  |  | 2 |  |  |  |  |  |  |  |  | [NAME] | 13
[NAME] | 2012-01-02 00:00:00 |  |  |  | 4 |  |  |  |  |  |  |  |  | [NAME] | 10.5
Manuel P | 2012-01-02 00:00:00 |  |  |  | 7 |  |  |  |  |  |  |  |  | Manuel P | 10
[NAME] | 2012-01-02 00:00:00 |  |  |  | 8 |  |  |  |  |  |  |  |  | [NAME] | 13
[NAME] | 2012-01-02 00:00:00 |  |  |  | 9 |  |  |  |  |  |  |  |  | [NAME] | 9.5
[NAME] | 2012-01-02 00:00:00 |  |  |  | 2 |  |  |  |  |  |  |  |  | [NAME] | 8.5
Natividad | 2012-01-02 00:00:00 |  |  |  | 5 |  |  |  |  |  |  |  |  | Natividad | 8.5
Shadrik | 2012-01-02 00:00:00 |  |  |  | 6 |  |  |  |  |  |  |  |  | Shadrik | 8.5
[NAME] | 2012-01-02 00:00:00 |  |  |  | 1 |  |  |  |  |  |  |  |  | [NAME]
[NAME] | 2012-01-02 00:00:00 |  |  |  | 1 |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 804611d1668182046-substitute-if-formula-for-specified-and-unspecified-text-in-cells-test
Sheet: Sheet1

COLOURS | Example | FORMULA | CONVERSION
Black | black animal print
Blue | blue spot
[NAME] | Brown leapard print
Cream | [NAME]
[NAME] | Black spot
Floral | blue spot
Gold | Blue Whale
Green | [NAME]
Grey
Khaki | Blue Spot
Orange | Brown leapard print
Pink | black animal print
Purple
Red
Silver
[NAME]
White
Yellow
Spreadsheet: 857576d1706559245-formula-for-a-specific-result-if-matching-name-found-sample-spreadsheet-etaf-new1
Sheet: Sheet2

 | [NAME] | Christi | [NAME] | [NAME] | [NAME]
 | [NAME] | Homer | [NAME] | Josiah | Steed
 | Raymi | Devron | Ty | Teneil | [NAME]
 | Chad | [NAME] | [NAME] | [NAME] | [NAME]
 | Sony | Dennis | [NAME] | Dane | Jakub
 |  |  | [NAME]
Spreadsheet: 133382d1324374255-trying-to-find-a-formula-to-extract-and-cross-specific-sells-in-an-array-find-and-extract
Sheet: Sheet1

1 | /indices/ | dfd |  |  |  |  |  |  | /indices/
 |  |  |  |  |  |  |  |  | /
 |  |  |  |  |  |  |  |  | /currencies/
 |  | 0.0779 |  |  |  |  |  |  | /commodities/
2 | /
 |  | 0.2547
3 | /currencies/
 |  | -0.006
4 | /commodities/
 |  | 0.0632
Spreadsheet: darrell_schoolcraft__7316__imball0202
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -13510 | -13500
2 | -19133 | -19000
3 | -17376 | -17500
4 |  | -2500
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
2002-01-31 00:00:00 |  |  | -135557
2002-02-04 00:00:00
CBS Volume
 |  |  | -67034
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 28

कार्यक्रम PROGRAM |  |  | आरएएच [NAME] कौिल सिंर्धयन UPSKILLING OF RAH HEADS | PROG CODE
 |  |  |  | IT 1780
तर्षर् समूह/SUBJECT GROUP |  |  | CREDIT
उद्देश्य/OBJECTIVE |  |  | EQUIPPING TRAINEES ABOUT RETAIL CREDIT MARKET AND RELEVANT TOOLS / STRATEGIES
लतक्षि समूह/TARGET GROUP |  |  | [NAME]
अर्तध/DURATION |  |  | 3 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Inauguration /Entry Test/ Problems faced by the RAHs
 | II | Roles & Responsibilities of RAH / Having eye on Advocate, Valuer/ HL & Vehicle loan Products, [NAME], ECS capturing in LAPS & Lodging in SAS, Use of Account Aggregator, Use of Perfios tie up
 | III | Credit Policy, CIR, CRR, CRG, [NAME], Delegation of Powers
 | IV | Pre-sanction formalities: KYC & Due-diligence, Leads Conversion, Cross sell opportunities (CIBIL scrutiny & HL takeover of new MSME & VL Loans), Retail Credit Marketing/I-LEAD/Prosper Leads, Tie-ups arrangement, Corporate Builder tie-up, Corporate DSA tie-up, Project approvals, Project activation, Capturing DSA ID, C-DSA ID & Corporate Builder ID.
Day 2 | I | Post-Sanction formalities: Documentation, Disbursement, Incentives to DSA/Builder/C-DSA/C-Builder/Vendor, EMT/Mortgage, CERSAI, Geo-Tagging of Property/Location
 | II | Take Over of Retail Lending loans, Data Analytic Tools & Competitive Analysis
 | III | Fraud Prevention on Retail Loans covering Preventive Vigilance, Incident Reporting, Whistle blower & Cyber Fraud
 | IV | Legal aspects of Mortgage & Valuation
Day 3 | I | Retail Customers – Building Lasting Relationships
 | II & III | Leadership, Motivation and Team Building
 | IV | Value & Ethics /Exit Test/Feedback & Valediction
Spreadsheet: 783222d1654677217-using-if-formula-to-match-against-different-codes-example-data-table-match-data
Sheet: Sheet1

 | Site | Code
 | 255 Lichfield Road | D33
 | Althea Park House | D70
 | [NAME], The Priory Hospital | 305
 | Arthur House | C17
 | Avesbury House | D03
 | Ayr Clinic | D04
 | [NAME] | 321
 | Beverley House | D06
 | Bristol, The Priory Hospital | 311
 | [NAME] | D25
 | Burton Park | D09
 | [NAME], The Priory Hospital | 290
 | [NAME], The Priory Hospital | 308
 | Cloisters Newbury, The Priory Hospital | 106
 | Dewsbury, The Priory Hospital | 345
 | Dorking, The Priory Hospital | D47
 | Elm Park Brain Injury Services Essex | D15
 | Glasgow, The Priory Hospital | 310
 | Grafton Manor Brain Injury Services | D18
 | [NAME], The Priory Hospital | 307
 | Hazelwood House Hospital | [NAME]
 | [NAME], The Priory Hospital | 101
 | Highbank Centre, The Priory | 110
 | [NAME] | D20
 | Kent House hospital | D21
 | Kneesworth House Hospital | D22
 | Lakeside View | [NAME]
 | [NAME] | 349
 | Llanarth Court Hospital | D34
 | Lombard House | D28
 | Marlow, The Priory Hospital | B99
 | [NAME], The Priory Hospital | 390
 | Mildmay Oaks | D39
 | [NAME] | D40
 | Mount Eveswell | 347
 | Nelson House Hospital | D42
 | North London, The Priory Hospital | 302
 | Oak Vale Gardens | C48
 | Penfold Lodge | D48
 | Preston, The Priory Hospital | 313
 | Princes Street | 333
 | Priory Hospital Arnold | D10
 | Priory Hospital Barnt Green (Lickey Hills) | C19
 | Priory Hospital Burgess Hill | D11
 | Priory Hospital East Midlands | D56
 | Priory Hospital Enfield | D43
 | Priory Hospital Lincolnshire | D37
 | Priory Hospital Norwich | D12
 | Richmond House | D29
 | Roehampton, The Priory Hospital | 301
 | Southampton, The Priory Hospital | 306
 | Stockton Hall Hospital | D51
 | Suttons Manor Clinic | D53
 | The Manor Clinic | D35
 | The Priory Clinic Nottingham | 316
 | The Priory Hospital Market Weighton | 330
 | Ticehurst House, The Priory | 303
 | [NAME] | D54
 | Woking, The Priory Hospital | 312
 | Woodbourne, The Priory Hospital | 309
 | Woodland View | D58
Spreadsheet: 777306d1650311848-auto-generate-based-off-criteria-book1
Sheet: In_Out

170 |  | Aircraft | Due In | Location | Due Out | Dest. | Flight # | VP# | Notes
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
170 |  | Aircraft | Due In | Location | Due Out | Dest. | Flight # | VP# | Notes
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 |  | Aircraft | Ticket # | DMI's | Time Remain | Description |  |  |  | Cleared By | Log Pg
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Spreadsheet: 54595d1254606412-converting-columns-of-non-standard-formatted-data-into-a-table-rows-excel_help_solution-
Sheet: Sheet1

Las Vegas | 1 | 2385419.71581 | 284.36
Las Vegas | 1 | 2635115.29029 | 296.94
Las Vegas | 1 | 2665235.02707 | 48.61
New York | 1 | 2385419.71581 | 432.33
New York | 1 | 2693935.32138 | 35.35
New York | 1 | 2693938.19184 | 21.21
New York | 1 | 2693939.62707 | 57.98
Seattle | 1 | 2665235.02707 | 432.33
Spreadsheet: 833384d1686930141-project-progress-employeename-timespent-automated-spreadsheet-example
Sheet: Sheet2

Task | Employee Name | Total Hours
Inception | [NAME] | 1.5
Delivery | [NAME] | 4 |  | Can sort by either Task or EE.  I did not sort as you did not indicate in your post.
[NAME] | [NAME] | 3.5
Phase 1 | [NAME] | 0.5
Phase 2 | [NAME] | 5.5
Inception | [NAME] | 1.5
Delivery | [NAME] | 1.66
[NAME] | [NAME] | 1
Phase 1 | [NAME] | 2
Delivery | [NAME] | 1.5