tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 81180d1281443935-copy-text-from-one-sheet-to-another-using-macro-request-form-template2
Sheet: October

 |  |  |  | Date | 2010-08-10 12:26:51 |  | October Total Hours
 |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Percentage
 | Year | Month | Date | Hours | Total Hours |  |  | Total Hours |  |  | 248 | 100
 | 2010 | October | 2010-10-01 00:00:00 | 0 | 0 |  |  | Total Hours Requested |  |  | 0 | 0
 |  |  | 2010-10-02 00:00:00 | 0 |  |  |  | Hours Not Requested |  |  | 248 | 100
 |  |  | 2010-10-03 00:00:00 | 0 |  |  |  |  |  |  |  |  |  | Key
 |  |  | 2010-10-04 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  | Hours Requested
 |  |  | 2010-10-05 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  | Left Over Hours
 |  |  | 2010-10-06 00:00:00 | 0
 |  |  | 2010-10-07 00:00:00 | 0
 |  |  | 2010-10-08 00:00:00 | 0
 |  |  | 2010-10-09 00:00:00 | 0
 |  |  | 2010-10-10 00:00:00 | 0
 |  |  | 2010-10-11 00:00:00 | 0
 |  |  | 2010-10-12 00:00:00 | 0
 |  |  | 2010-10-13 00:00:00 | 0
 |  |  | 2010-10-14 00:00:00 | 0
 |  |  | 2010-10-15 00:00:00 | 0
 |  |  | 2010-10-16 00:00:00 | 0
 |  |  | 2010-10-17 00:00:00 | 0
 |  |  | 2010-10-18 00:00:00 | 0
 |  |  | 2010-10-19 00:00:00 | 0
 |  |  | 2010-10-20 00:00:00 | 0
 |  |  | 2010-10-21 00:00:00 | 0
 |  |  | 2010-10-22 00:00:00 | 0
 |  |  | 2010-10-23 00:00:00 | 0
 |  |  | 2010-10-24 00:00:00 | 0
 |  |  | 2010-10-25 00:00:00 | 0
 |  |  | 2010-10-26 00:00:00 | 0
 |  |  | 2010-10-27 00:00:00 | 0
 |  |  | 2010-10-28 00:00:00 | 0
 |  |  | 2010-10-29 00:00:00 | 0
 |  |  | 2010-10-30 00:00:00 | 0
 |  |  | 2010-10-31 00:00:00 | 0
Spreadsheet: 865085d1712158684-top-performers-from-data-contained-in-a-table-top-5-performers
Sheet: Sheet1

Employees | Date | Concept |  | Sale |  | Visit
[NAME] | 2024-05-08 00:00:00 | Sale |  | Top 3 name | Number | Top 3 visit | Number
[NAME] | 2024-06-18 00:00:00 | Visit |  |  | 3 |  | 2
[NAME] | 2024-08-15 00:00:00 | Sale |  | [NAME] | 2 | [NAME] | 2
Tristan | 2024-09-19 00:00:00 | Sale |  | [NAME] | 2 | [NAME] | 2
[NAME] | 2024-06-09 00:00:00 | Sale
Pascal | 2024-07-21 00:00:00 | Visit
[NAME] | 2024-07-09 00:00:00 | Visit
[NAME] | 2024-05-03 00:00:00 | Visit
[NAME] | 2024-06-07 00:00:00 | Sale
[NAME] | 2024-04-18 00:00:00 | Sale
[NAME] | 2024-10-13 00:00:00 | Visit
[NAME] | 2024-06-08 00:00:00 | Visit
[NAME] | 2024-08-06 00:00:00 | Sale
Pascal | 2024-05-30 00:00:00 | Visit
[NAME] | 2024-03-08 00:00:00 | Sale
[NAME] | 2024-04-05 00:00:00 | Sale
[NAME] | 2024-09-21 00:00:00 | Visit
[NAME] | 2024-06-08 00:00:00 | Sale
Spreadsheet: 856700d1705920155-pivot-table-from-different-sheets-not-in-a-nice-large-data-table-attendance-missed-session-catch-up-log-test
Sheet: Learner10

 | Attendance |  |  |  | Additional support plans
Name | P3 | P6 | P9 | P12 | Declared but Declined | University Learning Support Plan from DDSS | Departmental Support plan | Return to Learning Support Plan | Functional Skills training and progress
Learner10
Session missed | Module | Tutor(s) | How missed work was caught up |  |  | Auto completed by Att spreadsheet
2023-09-05 00:00:00 | MGT61102 | Tutor 1 | Video recording uploaded onto blackboard |  |  | PS to link
2023-10-31 00:00:00 | MGT61104 | Tutor 4 | (tutor to complete) |  |  | PS to complete
 |  |  |  |  |  | tutor to complete
Spreadsheet: 870312d1716858749-adjustment-of-formulas-from-google-sheets-to-excel-file-below-pic-west123-
Sheet: Sheet1

Time Normal | Tournament | Buy In | Entry | [NAME] | action-sold | Total Prize | Duration | Rank | Result |  |  | Time Normal | Tournament | Buy In | Entry | [NAME] | action-sold | Total Prize | Duration | Rank | Result | Count |  |  | Time Normal | Tournament | Buy In | Entry | [NAME] | action-sold | Total Prize | Duration | Rank | Result
May 25, 19:30 | [NAME] Special $2.50 |  | 1 | 1.1 up to 60% | 1 |  |  |  | 0
May 25, 19:10 | Speed Racer Bounty $3.21 [10 BB] |  | 1 | 1.1 up to 60% | 0.8333 |  |  |  | 0
May 25, 17:05 | Micro Madness $1.88 [Hyper] |  | 3 | 1.1 up to 60% | 0.5 |  |  |  | 0
May 25, 14:10 | Speed Racer Bounty $1.08 [10 BB] |  | 1 | 1.1 up to 60% | 1 |  |  |  | 0
May 25, 12:30 | [NAME] $3.21 |  | 1 | 1.01 up to 50% | 0 |  |  |  | 0
May 25, 09:10 | Speed Racer Bounty $3.21 [10 BB] |  | 1 | 1.1 up to 50% | 1 |  |  |  | 0.75
May 24, 21:05 | Daily Special $3 |  | 2 | 1.01 up to 50% | 1 |  |  |  | 0
May 24, 19:10 | Speed Racer Bounty $3.21 [10 BB] |  | 2 | 1.01 up to 50% | 1 |  |  |  | 0
May 24, 14:10 | Speed Racer Bounty $1.08 [10 BB] |  | 6 | 1.1 up to 30% | 0 |  |  |  | 0
May 25, 19:30 | [NAME] Special $2.50 | 2.5 | 1160 |  |  | 2691.2 | 0.209247685 | 974 / 1,160 | 0
May 25, 19:10 | Speed Racer Bounty $3.21 [10 BB] | 3.21 | 557 |  |  | 1671 | 0.052604167 | 538 / 557 | 0
May 25, 17:05 | Micro Madness $1.88 [Hyper] | 1.88 | 788 |  |  | 1363.24 | 0.139479167 | 787 / 788 | 0
May 25, 17:05 | Micro Madness $1.88 [Hyper] | 1.88 | 788 |  |  | 1363.24 | 0.139479167 | 764 / 788 | 0
May 25, 17:05 | Micro Madness $1.88 [Hyper] | 1.88 | 788 |  |  | 1363.24 | 0.139479167 | 740 / 788 | 0
Spreadsheet: 767655d1644575016-calculating-time-difference-of-warehouse-picking-rate-using-line-data-sample-data-7-ans2
Sheet: Data

Csgno | Pick Start Date | Start Pick Time | Pack End Date | Pack End Time | Packer | Total Time Taken | Num Of Lines | Total per packer | Num Of Lines per packer
4071990 | 2022-02-08 00:00:00 | 06:47:21 | 2022-02-08 00:00:00 | 08:04:35 | BBE
4071995 | 2022-02-08 00:00:00 | 06:47:23 | 2022-02-08 00:00:00 | 07:29:45 | BBE
4072040 | 2022-02-08 00:00:00 | 06:47:22 | 2022-02-08 00:00:00 | 07:40:25 | BBE
4072177 | 2022-02-08 00:00:00 | 09:00:24 | 2022-02-08 00:00:00 | 10:45:12 | ACU
4072177 | 2022-02-08 00:00:00 | 09:00:24 | 2022-02-08 00:00:00 | 10:45:12 | ACU
4072177 | 2022-02-08 00:00:00 | 09:00:24 | 2022-02-08 00:00:00 | 10:45:12 | ACU
4072177 | 2022-02-09 00:00:00 | 09:00:24 | 2022-02-09 00:00:00 | 10:45:12 | ACU
4072177 | 2022-02-09 00:00:00 | 09:00:24 | 2022-02-09 00:00:00 | 10:45:12 | ACU
4072224 | 2022-02-08 00:00:00 | 19:47:30 | 2022-02-08 00:00:00 | 19:55:31 | CGR
4072224 | 2022-02-08 00:00:00 | 19:47:30 | 2022-02-08 00:00:00 | 19:55:31 | CGR
4072470 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:11:05 | CGR
4072478 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:20:34 | CGR
4072478 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:20:34 | CGR
4072487 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:27:39 | CGR
4072499 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:29:02 | CGR
 |  | NOTE: For starting time and end time, ignore number of seconds in formulations and please just consider hours and minutes
 |  | BBE has packed 3 lines. He started packing at 6.47 and finished the last line at 8.04. Therefore he took 1 hour and 17 mins to complete all those lines
 |  | ACU packed 3 lines, started at 9 and finished at 10.45, so took 1 hr 45 minutes to pack all 3 lines, but he did this over 2 different days, so each day requires it’s own separate data
 |  | CGR packed 5 lines, but the first 2 were started at 19.47 and finished at 19.55, so took 8 minutes, but the other 5 started at 11.10 and finished at 11.29 and so took 19 minutes. Therefore he packed a total of 7 lines and took a total 27 minutes to pack them
 | Table Required to show answers, ideally placed into a separate tab. Could this be done in a Pivot table so it was automated??
 | Packer | Date | Number of Lines Picked | Total Time Taken
 | BBE | 2022-02-08 00:00:00 | 3 | 1:17:00
 | ACU | 2022-02-08 00:00:00 | 2 | 1:45:00
 | ACU | 2022-02-09 00:00:00 | 2 | 1:45:00
 | CGR | 2022-02-08 00:00:00 | 7 | 0:27:00
Spreadsheet: 12bb7937-4c85-4133-92c3-e67cf9f647e1
Sheet: Sheet1

UNIVERSITY OF MARYLAND | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
SCHOOL OF MEDICINE
JOURNAL VOUCHER
 | COMPLETE MAILING ADDRESS |  |  |  |  |  |  | COMPLETE MAILING ADDRESS
 | CHARGE (DR) DEPT. |  |  |  |  |  |  | CREDIT (CR) DEPT.
 |  |  |  |  |  |  |  | Photo and Graphics Group
 |  |  |  |  |  |  |  | Room 357, MSTF
 |  |  |  |  |  |  |  | 6-7808
 |  |  |  |  |  |  |  | [NAME]
 |  | PCBU | PROJECT ID | OWNER DEPT | PROG | FUND | ACCOUNT | TX DEPT | AMOUNT | REFERENCE | JOURNAL LINE DESCRIPTION
 | DEBIT
 | CREDIT | 00135 | 00390663 | 10102070 | 102 | 135 | 0514 | 10415020
 | DEBIT
 | CREDIT
 |  |  |  |  |  | TOTAL - MUST EQUAL ZERO
 | [NAME] OF ITEM OR SERVICE
 | CHARGE APPROVED BY: |  |  |  |  |  |  | CREDIT APPROVED BY:
Spreadsheet: 02cab991-e691-43e3-a138-fe787a57ae70
Sheet: Sheet1

Fort Hays State University | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Ramada Hays Room Reservation Form
Reservation Form Required to receive Special Room Rate - $45.00 Per Night
(Completed Credit Card Agreement Must Already Be on File with Hotel)
Telephone ~ [PHONE] . . .  FAX ~[PHONE]
Attn:  [NAME]
Use the TAB key to complete the form below . . .
Check In Date: |  |  | ** Cancellation:  Deadline 6:00P
Check Out Date:
Guest Name:
Bed Type:
Smoking Preference:
Confirmation #:
Guest Name:
Bed Type:
Smoking Preference:
Confirmation #:
Guest Name:
Bed Type:
Smoking Preference:
Confirmation #:
FHSU Contact (Individual Making Reservation):
Name: |  |  | FHSU FAX #:
Department: |  |  | FHSU Phone #:
College: |  |  | BPC Last 5 Digits:
 |  |  | [NAME] Personally:
Please Print and FAX The Form To  ~ [PHONE]
Ramada Hays:     Please Confirm Reservation
Limited To Bed Rate And Lodging Taxes Only
No Additional Charges Allowed
FHSU is Exempt from Sales Tax ~ [NAME]
Spreadsheet: 814574d1674494118-help-required-in-formulae-which-merge-data-using-formulae-sample
Sheet: Sheet1

Key | OrdType | Order# | PO's |  |  |  | I am doing this as I want to send PRO data only. | Key | OrdType | Order# | PO's
[PHONE] | PrO | 422724 |  | Key should be same |  |  |  | [PHONE] | PrO | 422724 | 456794,457956,435964
[PHONE] | PO | 456794 |  | next line of pro is PO then only display |  |  |  | 2010641422 | PrO | 433914 | 461604,126364,312591,396328
[PHONE] | PO | 457956 |  |  |  |  |  | 2010642420 | PrO | 433935 | 433936
[PHONE] | PO | 435964
200855-010GX4210 | PrO | 451704
[PHONE] | PrO | 456798
201020-00950421 | PrO | 427495
201056-010GX421 | PrO | 433204
2010641421 | PrO | 434164
2010641422 | PrO | 433914
[PHONE] | PO | 461604
[PHONE] | PO | 126364
[PHONE] | PO | 312591
[PHONE] | PO | 396328
2010642420 | PrO | 433934
2010642420 | PrO | 433935 | 433936
2010642420 | PO | 433936
Spreadsheet: 170368d1343244731-need-formula-to-pull-data-from-aanther-sheet-cells-not-exact-match-sample-chrystalblaker-oeldere-
Sheet: Sheet1

School Name | Address | Phone | Principal 2011 | Principal 2012 | Date of Contact
Adams | main st | 123-4567 | Smith | [NAME] | 2011-01-24 00:00:00
Byant | oak st | 123-4568 | [NAME] | Marks | 2011-01-25 00:00:00
[NAME] | elm st | 123-4569 | [NAME] | Murphey | 2011-01-26 00:00:00
Washington | birch st | 123-4570 | [NAME] | [NAME] | 2011-01-27 00:00:00
Spreadsheet: 800634d1665764909-create-dropdown-list-where-you-select-a-value-and-it-shows-related-values-in-two-columns-test
Sheet: Sheet1

Category
Full Stack Developer
Front End Developer
UX Designer
UI Designer
Digital Production Manager
Digital Product Manager
[NAME] Full Stack Developer | Technical skills Full Stack Developer | Soft Skills Front End Developer | Technical  Skills Front End Developer | [NAME] | Technical Skills UX Designer | [NAME] UI Designer | Technical Skills UI Designer | Soft Skills Digital Production Manager | Technical Skills Digital Production Manager | Soft Skills Digital Product Manager | Technical Skills Digital Product Manager
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Spreadsheet: 138502d1327685304-adding-values-of-multiple-excel-sheets-and-populating-the-master-sheet-ptsumofsheets
Sheet: Master

Cust | Code | Desc | Ordered
Cust1 | P001 | xyz | 20 |  | Row Labels | Sum of Ordered
Cust1 | P002 | bbb | 90 |  | P001 | 30
Cust1 | P006 | vvv | 8 |  | P002 | 90
Cust3 | P001 | xyz | 10 |  | P006 | 13
Cust3 | P009 | nnn | 3 |  | P009 | 3
Cust3 | P006 | vvv | 5 |  | Grand Total | 136
Spreadsheet: 766187d1643794003-read-partial-text-from-another-cell-chas-data-2
Sheet: Sheet1

Project ID | Project Manager | Phase | ParentTaskName | TaskName | [NAME] | New Detail | TaskEarlyStart | TaskFinishDate | TaskDuration | Complete
1 | A | #N/A | Design Phase | SG3 Board (is booked) |  |  | 2022-01-19 08:00:00 | 2022-01-19 08:00:00 | 0 | Yes
2 | B | #N/A | Handover & Closure | SG5 - Project Closure |  |  | 2022-01-12 17:00:00 | 2022-01-12 17:00:00 | 0 | Yes
3 | C | #N/A | Build Phase | Build Phase Complete - SG4 |  |  | 2022-01-21 17:00:00 | 2022-01-21 17:00:00 | 0 | No
4 | D | #N/A | Transition (Handover and Closure) Phase | Warranty |  |  | 2022-01-24 08:00:00 | 2022-02-18 17:00:00 | 160 | No
5 | E | #N/A | Milestones | Go Live |  |  | 2022-01-25 17:00:00 | 2022-01-25 17:00:00 | 0 | No
6 | G | #N/A | Delivery Phase SG4 | Build Phase Complete - SG4 |  |  | 2022-01-13 17:00:00 | 2022-01-13 17:00:00 | 0 | No
7 | G | #N/A | Build Phase | Build Phase Complete - SG4 |  |  | 2022-01-27 17:00:00 | 2022-01-27 17:00:00 | 0 | No
Spreadsheet: 107642d1304770208-combine-data-form-3-columns-to-one-dynamic-column-book1
Sheet: Sheet1

Remarks | Holiday | Leaves |  | RESULT SHOULD BE
2011-01-22 00:00:00 | 2011-01-01 00:00:00 | 2011-04-25 00:00:00 |  | 2011-01-22 00:00:00
2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-05-22 00:00:00 |  | 2011-01-25 00:00:00
2011-02-12 00:00:00 | 2011-03-02 00:00:00 | 2011-05-23 00:00:00 |  | 2011-02-12 00:00:00
2011-02-14 00:00:00 | 2011-03-20 00:00:00 |  |  | 2011-02-14 00:00:00
2011-02-16 00:00:00 | 2011-04-04 00:00:00 |  |  | 2011-02-16 00:00:00
2011-02-17 00:00:00 | 2011-05-01 00:00:00 |  |  | 2011-02-17 00:00:00
2011-04-28 00:00:00 | 2011-08-15 00:00:00 |  |  | 2011-04-28 00:00:00
2011-05-03 00:00:00 | 2011-08-22 00:00:00 |  |  | 2011-05-03 00:00:00
 | 2011-08-31 00:00:00 |  |  | 2011-01-01 00:00:00
 | 2011-09-01 00:00:00 |  |  | 2011-01-26 00:00:00
 | 2011-10-02 00:00:00 |  |  | 2011-03-02 00:00:00
 | 2011-10-06 00:00:00 |  |  | 2011-03-20 00:00:00
 | 2011-10-26 00:00:00 |  |  | 2011-04-04 00:00:00
 | 2011-10-28 00:00:00 |  |  | 2011-05-01 00:00:00
 | 2011-12-25 00:00:00 |  |  | 2011-08-15 00:00:00
 |  |  |  | 2011-08-22 00:00:00
 |  |  |  | 2011-08-31 00:00:00
 |  |  |  | 2011-09-01 00:00:00
 |  |  |  | 2011-10-02 00:00:00
 |  |  |  | 2011-10-06 00:00:00
 |  |  |  | 2011-10-26 00:00:00
 |  |  |  | 2011-10-28 00:00:00
 |  |  |  | 2011-12-25 00:00:00
 |  |  |  | 2011-04-25 00:00:00
 |  |  |  | 2011-05-22 00:00:00
 |  |  |  | 2011-05-23 00:00:00
Spreadsheet: 97623d1296749661-looking-for-formula-that-will-catch-special-rule-abuse-for-the-same-id-copy-of-2011_02_03_reply
Sheet: Sheet1 (3)

ID | date | SLED |  | check
22 | 2010-01-27 00:00:00 | 2012-01-12 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-14 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-17 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-12 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-20 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-18 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-18 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-20 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-19 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-19 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-31 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-28 00:00:00 | 2012-02-20 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-21 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-29 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-29 00:00:00 | 2012-02-29 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00
Spreadsheet: 741358d1626986404-how-to-use-filter-on-two-columns-sample
Sheet: Sample

Data: |  |  |  |  | What I want it to look like:
DAN | GREG | 1 | 0 |  |  | 1 | 0.5 | 1 | 0
STEVE | TREVOR | 0.5 | 0.5 |  |  | 0.5 | 1 | 0.5
GREG | STEVE | 0 | 1 |  |  | 0 | 0 | 0
STEVE | DAN | 0.5 | 0.5 |  |  | 0.5 | 0 | 1
DAN | TREVOR | 1 | 0 |  |  | 1
DAN | BOB | 0 | 1
TREVOR | GREG | 1 | 0
Spreadsheet: 290360d1389858172-combining-several-rows-in-one-excel_list
Sheet: Лист1

 | What is now
 |  | Column1 | Column2 | Column3 | Column4
 |  | Name | A | [NAME] | YYY
 |  | Name | B | [NAME] | YYY
 |  | Name | C | [NAME] | YYY
 | Desired result
 |  | Column1 | Column2 | Column3 | Column4
 |  | Name | A B С | [NAME] | YYY
Spreadsheet: f225527e-e6ca-48d1-a6bf-2fd6014a75b7
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
35943905 | 2013-05-14 21:55:48 | AXIS | 0 | 3 | 6 | 954955 | [NAME] | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
35944131 | 2013-05-14 22:07:26 | ALLIES | 0 | 3 | 6 | 954955 | [NAME] | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
35944449 | 2013-05-14 22:24:21 | AXIS | 0 | 2 | 5 | 1161969 | primarette | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
35944628 | 2013-05-14 22:37:04 | ALLIES | 0 | 4 | 5 | 1161969 | primarette | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
Spreadsheet: 42277d1240880607-need-to-create-2-columns-from-one-help2
Sheet: Sheet1

Connect Cerritos
ADAPTER
4000K42218 | 1
BLUETOOTH HEADSET
40000JBA03 | 2
4WEP350RED | 1
40BL091010 | 0
40BL091009 | 2
40000BKPAJ | 7
4000BT2010 | 0
4000BT3010 | 1
4000BT3030 | 2
400JAJB203 | 6
400000H710 | 5
40000PL520 | 1
40000PL925 | 3
4000PL925P | 2
[PHONE] | 1
[PHONE] | 2
4000WEP301 | 1
4000WEP350 | 2
4000WEP500 | 1
Connect [NAME]
ADAPTER
4000K42218 | 1
BLUETOOTH HEADSET
40000JBA03 | 2
4WEP350RED | 1
40BL091010 | 0
40BL091009 | 2
40000BKPAJ | 7
4000BT2010 | 0
4000BT3010 | 1
4000BT3030 | 2
400JAJB203 | 6
400000H710 | 5
40000PL520 | 1
40000PL925 | 3
4000PL925P | 2
[PHONE] | 1
[PHONE] | 2
4000WEP301 | 1
4000WEP350 | 2
4000WEP500 | 1
Connect Ventura
ADAPTER
4000K42218 | 1
BLUETOOTH HEADSET
40000JBA03 | 2
4WEP350RED | 1
40BL091010 | 0
40BL091009 | 2
40000BKPAJ | 7
4000BT2010 | 0
4000BT3010 | 1
4000BT3030 | 2
400JAJB203 | 6
400000H710 | 5
40000PL520 | 1
40000PL925 | 3
4000PL925P | 2
[PHONE] | 1
[PHONE] | 2
4000WEP301 | 1
4000WEP350 | 2
4000WEP500 | 1
Spreadsheet: 179236d1347092357-auto-range-change-clarity-needed-trail-gap
Sheet: Sheet1

Loan Number | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GAP Days | GAP Status
1 | CB |  |  | RNR
2 |  | CB |  |  | RNR
3 |  |  | CB |  |  | RNR
4 |  |  |  | CB |  |  | RNR
5 |  |  |  |  | CB
6
7
8 |  |  |  | RNR
9
10 |  |  |  | RNR
11
12
13
14
15
Spreadsheet: 483250d1475578279-ranking-duplicate-values-by-date-book1
Sheet: Sheet1

Patient | Date | Visit
a | 2016-10-10 00:00:00 | 1
b | 2016-10-11 00:00:00 | 1
c | 2016-10-12 00:00:00 | 1
d | 2016-10-13 00:00:00 | 1
d | 2016-10-14 00:00:00 | 2
c | 2016-10-15 00:00:00 | 2
b | 2016-10-16 00:00:00 | 2
b | 2016-10-17 00:00:00 | 3
b | 2016-10-18 00:00:00 | 4
a | 2016-10-19 00:00:00 | 2
a | 2016-10-20 00:00:00 | 3
c | 2016-10-21 00:00:00 | 3
c | 2016-10-22 00:00:00 | 4
b | 2016-10-23 00:00:00 | 4
b | 2016-10-24 00:00:00 | 5
v | 2016-10-25 00:00:00 | 1
b | 2016-10-26 00:00:00 | 6
b | 2016-10-27 00:00:00 | 7
g | 2016-10-28 00:00:00 | 1
g | 2016-10-29 00:00:00 | 2
h | 2016-10-30 00:00:00 | 1
h | 2016-10-31 00:00:00 | 2
a | 2016-11-01 00:00:00 | 4
a | 2016-11-02 00:00:00 | 5
c | 2016-11-03 00:00:00 | 5
c | 2016-11-04 00:00:00 | 6
w | 2016-11-05 00:00:00 | 1
e | 2016-11-06 00:00:00 | 1
r | 2016-11-07 00:00:00 | 1
Spreadsheet: 35996d1233747903-multiple-vlookup-excelexample
Sheet: Sheet2

 | BDOT-ALMOND | BDOT-DEWBERRY | BDOT-MELON | BDOT-NOUGAT | BF-BLUEBERRY | BF-NEOPOLITAN | BF-RASPBERRY | BST-AUTUMN
DA-102/1
DA-103/2
DA-103/3 |  |  | DA-102/1 | DA-102/1
DA-105/1/2 | DA-102/1
[NAME]
[NAME]
[NAME] |  | DA-102/1 |  |  | DA-102/1
DA-111/2
DA-111/3
DA-111/4
[NAME] |  |  | DA-102/1
DC-103/11
DC-103/13
DC-103/14
DC-103/15
DC-103/16
DC-103/17
DC-103/7
DC-105/1 |  |  |  |  |  |  | DA-102/1
DC-105/2
DC-105/3
DC-105/4
[NAME]
[NAME] |  |  |  |  |  | DA-102/1
DC-107/2
DC-107/3
DC-107/4
DC-108/2
[NAME]
DC-110/2 |  |  |  |  |  |  |  | DA-102/1
DC-110/3
[NAME]
DC-111/1 | DA-102/1
DC-111/2
DC-111/3
Spreadsheet: 122113d1316618384-automatically-populate-row-based-on-unique-name-testsheet
Sheet: Sheet2

 |  |  |  |  |  |  | 0
Total Cost of Item (Total M2*Rate)
Total Cost of Item £ Added Indivdually
OST Price Check (OST * Rate)
Difference
Total Metres on Sheet
Total Metres on OST |  |  |  |  |  | 680 |  | 5250 |  | 50 |  | 200 |  | 600 |  | 100 |  | 200 |  | 100
Difference
PLOT TYPE
Rate Applied
 |  |  |  |  |  | 1
Client |  |  |  | No of Units
Contract
Date
By
 |  |  | Unit
 |  |  | Alpha | 1 | M2 | 20 |  | 100 |  | 50 |  | 100 |  | 500 |  |  |  | 100
 |  |  | Bravo | 1 | M2 | 50 |  | 5000
 |  |  | [NAME] | 1 | M2 | 40
 |  |  | Delta | 1 | M2 | 5 |  | 50 |  | 30 |  |  |  | 80 |  |  |  | 90
 |  |  | Echo | 1 | M2 | 50 |  | 12 |  | 40 |  | 60 |  | 30 |  | 30
 |  |  | Foxtrot | 1 | M2 | 25 |  |  |  | 30 |  | 32 |  | 66
Spreadsheet: 99143d1297874182-conditional-formatting-following-a-drop-down-box-entry-appointment_sheet-v2
Sheet: Sheet1

 |  |  |  | Notes
Business Name | Contact | Appointment Date | Call Back Date | Pauline | [NAME] | [NAME] | Status |  |  | Won
 |  |  |  |  |  |  | Lost |  |  | Lost
 |  |  |  |  |  |  | Won |  |  | In Progress
 |  |  |  |  |  |  | In Progress |  |  | Scheduled
 |  |  |  |  |  |  | Scheduled
 |  |  |  |  |  |  | In Progress
 |  |  |  |  |  |  | In Progress
 |  |  |  |  |  |  | Scheduled
 |  |  |  |  |  |  | Scheduled
 |  |  |  |  |  |  | Lost
 |  |  |  |  |  |  | Won
Spreadsheet: 695824d1600418971-using-if-and-and-score-predictions-calcs
Sheet: Sheet1

 |  |  |  |  |  |  | 2020-09-18 00:00:00
 |  |  |  |  |  |  | Milan | Inter | goal difference
 |  |  |  |  |  |  | 3 | 2
 |  | Milan | Inter | points
 | [NAME] | 3 | 2 | 3
 | [NAME] | 4 | 1 | 1
 | [NAME] | 2 | 1 | 2
 | Juan | 0 | 0 | 0
 | [NAME] | 1 | 2 | 0
 | Jumana | 4 | 3 | 2
 | Jasmine | 3 | 2 | 2
 | [NAME] | 1 | 1 | 0
Spreadsheet: 608a00ea-b76e-47f2-8ea5-1e12231ab2a2
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FELBA | Test | FELBA | Felbamate (Felbatol), Serum | Felbamate (Felbatol), S | High-Turbulence Liquid Chromatography Mass Spectrometry (HTLC-MS/MS) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL Collection Instructions: Draw specimen immediately before next scheduled dose. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | 30.0-60.0 mcg/mL | Monday through Sunday | Same day/1 day | 2 days | 1 | 80299 |  |  |  |  | Rochester
FELBA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FELBA | Result | 80782 | Felbamate (Felbatol), S | Felbamate (Felbatol), S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 6899-9 | Felbamate:MCnc:Pt:Ser/Plas:Qn: