tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 879354d1726838784-data-lookup-based-upon-date-range-test-document
Sheet: Report

From Date | 2024-09-20 00:00:00
To Date | 2024/9/31
ID | V1 COMMENTS | REJECTION REASON | V2 COMMENTS | REJECTION REASON
555624 |  |  | Test comment number 2 | [NAME]
Expected results
Date range set to 01/01/2024 to 20/09/2024
ID | V1 COMMENTS | REJECTION REASON | V2 COMMENTS | REJECTION REASON
555624 | Test comment | Incorrect Colour
Expected results
Date range set to 01/01/2024 to 31/09/2024
ID | V1 COMMENTS | REJECTION REASON | V2 COMMENTS | REJECTION REASON
555624 | Test comment | Incorrect Colour | Test comment number 2 | [NAME]
Expected results
Date range set to 21/09/2024 to 31/09/2024
ID | V1 COMMENTS | REJECTION REASON | V2 COMMENTS | REJECTION REASON
555624 |  |  | Test comment number 2 | [NAME]
Spreadsheet: 172996d1344405918-sum-values-based-on-month-and-product-trial-copy-1
Sheet: Sheet1

 |  |  |  |  |  | Budget For Apple | 10
DATE | Commodity | PRIZE |  |  |  | Budget For Orange | 10
2012-06-01 00:00:00 | Apple | 2 |  |  | Annual Epenses
2012-06-03 00:00:00 | Orange | 2
2012-07-08 00:00:00 | Grapes | 2 |  |  | Month | Commodity | Expenses | Above Budget | Below Budget
2012-07-10 00:00:00 | Water Melon | 5 |  | 6 | June | Apple
2012-07-16 00:00:00 | [NAME] | 5 |  | 7 | July | Apple
2012-07-16 00:00:00 | Kiwi | 20
2012-07-17 00:00:00 | Apple | 8
2012-07-17 00:00:00 | Orange | 0.3
2012-07-17 00:00:00 | Apple | 3
2012-07-17 00:00:00 | Orange | 5
2012-07-17 00:00:00 | Grapes | 2
2012-07-17 00:00:00 | Water Melon | 2
2012-07-21 00:00:00 | [NAME] | 4.8
2012-07-21 00:00:00 | Kiwi | 4.8
2012-07-22 00:00:00 | Apple | 10 |  |  |  |  | 2 |  | 8
 |  |  |  |  |  |  | 21 | 11
Spreadsheet: 77538d1277993678-monthly-template-book1
Sheet: Corporate Scorecard

1. Corporate Scorecard
Work category | Licences Issued | Target | % of licences issued within timescale | Pass or Fail
New Full Licence (excluding [NAME]) | 12 | 50% within 4 months (122 days) | 83.33333333333334 | PASS
New Hydropower | 2 | 35% within 6 months (184 days) | 500 | PASS
2. Total Licences Issued |  | (this list is only for full, renewals and hydropower applications)
[NAME] | Officer | Business Plan Hours | Unit Time Data
 |  | based on the info from data sheet. If full=100 hrs, if renewal=37 hrs, if [NAME]
Spreadsheet: darrell_schoolcraft__7310__imball0201
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -945 | -900
2 | -20011 | -20000
3 | -19998 | -20000
4 | -20411 | -20000
5 | -12817 | -9366
6 | -19992 | -19648
7 | -20005 | -19794
8 | -20572 | -20000
9 | -20237 | -20000
10 | -20998 | -20000
11 | -20735 | -20000
12 | -21003 | -20000
13 | -20001 | -20000
14 | -19998 | -20000
15 | -20002 | -19718
16 | -19993 | -19779
17 | -20493 | -20000
18 | -20182 | -20000
19 | -19793 | -19655
20 | -19798 | -19652
21 | -19806 | -19652
22 | -19910 | -19652
23 | -19862 | -20000
24 | -19794 | -19952
25 | -2538 | -19779
26 | -20129 | -19939
27 | -20003 | -19741
28 | -19991 | -20000
29 | -19903 | -20000
30
31
2001-12-31 00:00:00 |  |  | 186823
2002-01-29 00:00:00
CBS Dollars
 |  |  | 199813
Spreadsheet: 756167d1637316109-derive-closed-form-expression-for-interest-series-example2
Sheet: Sheet1

x
 |  |  | Investment | 127500000 |  | Rate | -0.0065 |  | Periods | 2 |  | Target Cell
 | Simplified PV example: |  |  |  |  | Simplified XIRR example:
 | Periods | 0 |  |  |  | Periods | 2021-11-30 00:00:00
 | BoP | 0 |  |  |  | BoP | 0
 | Cash |  | 0 | 0 |  | Cash |  | 0 | 0
 | Interest Funding |  | 0 | 0 |  | Interest Funding |  | 0 | 0
 | Interest Charge | 0 |  |  |  | Interest Charge | 0
 | EoP |  |  |  |  | EoP
 | Check |  |  |  |  | Check
 | Check |  |  |  |  | Check
 | Extended XIRR Example: |  | WIP
 |  |  |  | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00
 |  | 0
 | Cash BoP | 0
 | Priv. Placement | 125000000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Overfunding |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Interest Funding | 1265827.839592573 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Interest Charge | 0
 | Cash EoP
 | Period Fraction/360 | 0
 | Check
 | Check
 | WIP:
 | Extended XIRR Example - Alternative Schedule:
 |  | 0
 | Cash BoP
 | Priv. Placement | 125000000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Overfunding |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Interest Funding |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Interest Charge
 | Cash EoP
 | Period Fraction/360 | 0
 | Check
 | Check
 | Interest Check
Spreadsheet: 848288d1699029520-golf-tournament-tracker-scottsdale-tournament-template-1-aligw
Sheet: Sheet1

2023 SCOTTSDALE OPEN |  |  |  |  |  |  |  |  |  |  | CURRENT
MATCH PLAY |  |  |  |  |  |  |  |  |  |  | STANDINGS
POS | PLAYER |  |  |  | R1 | R2 | R3 |  | TOTAL
 | PLAYER 1 |  |  |  | 70 | 71 | 72 |  |  |  |  | PLAYER 12
 | PLAYER 2 |  |  |  | 65 | 65 | 69 |  |  |  | 2 | PLAYER 11
 | PLAYER 3 |  |  |  | 74 | 73 | 72 |  |  |  | 3 | PLAYER 10
 | PLAYER 4 |  |  |  | 77 | 65 | 66 |  |  |  | 4 | PLAYER 2
 | PLAYER 5 |  |  |  | 66 | 67 | 68 |  |  |  | 5 | PLAYER 5
 | PLAYER 6 |  |  |  | 72 | 72 | 73 |  |  |  | 6 | PLAYER 4
 | PLAYER 7 |  |  |  | 74 | 74 | 75 |  |  |  | 7 | PLAYER 1
 | PLAYER 8 |  |  |  | 77 | 78 | 89 |  |  |  | 8 | PLAYER 6
 | PLAYER 9 |  |  |  | 81 | 78 | 76 |  |  |  | 9 | PLAYER 3
 | PLAYER 10 |  |  |  | 62 | 62 | 61 |  |  |  | 10 | PLAYER 7
 | PLAYER 11 |  |  |  | 62 | 61 | 61 |  |  |  | 11 | PLAYER 9
 | PLAYER 12 |  |  |  | 60 | 60 | 59 |  |  |  | 12 | PLAYER 8
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Sarah

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2017-08-31 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2017-08-31 00:00:00
Spreadsheet: a2ba6853-e0b7-45a3-abdb-225f281cac00
Sheet: Sheet1

Form for Providing 1999 Year-End Tax Reporting Information: Ramco-Gershenson Properties Trust | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | Income
 | Allocations |  |  |  |  |  |  |  | Cash | Taxable |  |  |  |  | Unrecaptured |  | Exempt- | Alternative | Foreign
 | F=Final | Security |  | Ticker | Issuer | Declaration | Record | Payable | Distribution | Ordinary | Short-term | Return of | 28 Percent | 20 Percent | Section 1250 | Section 1202 | Interest | Minimum | Tax
Status | E=Estimated | Description | CUSIP | Symbol | Class. | Date | Date | Date | Per Share | Dividend | Capital  Gain | Capital | Rate  Gain | Rate Gain | Gain | Gain | Dividend | Tax Percent | Gross Up
 |  | Common Shares | 751452202 | RPT | 1 | 1999-03-10 00:00:00 | 1999-03-31 00:00:00 | 1999-04-20 00:00:00 | 0.42 | 0.2768 | 0 | 0.1432 | 0 | 0 | 0
 |  | Common Shares | 751452202 | RPT | 1 | 1999-06-09 00:00:00 | 1999-06-30 00:00:00 | 1999-07-20 00:00:00 | 0.42 | 0.2768 | 0 | 0.1432 | 0 | 0 | 0
 |  | Common Shares | 751452202 | RPT | 1 | 1999-09-08 00:00:00 | 1999-09-30 00:00:00 | 1999-10-19 00:00:00 | 0.42 | 0.2768 | 0 | 0.1432 | 0 | 0 | 0
 |  | Common Shares | 751452202 | RPT | 1 | 1999-12-08 00:00:00 | 1999-12-31 00:00:00 | 2000-01-18 00:00:00 | 0.42 | 0.2768 | 0 | 0.1432 | 0 | 0 | 0
 |  | Totals for 1999 |  |  |  |  |  |  | 1.68 | 1.1072 | 0 | 0.5728 | 0 | 0 | 0
Spreadsheet: 101363d1299516481-making-a-print-list-from-select-data-in-database-main-list-print-list
Sheet: Database

In this row I make a indication for what "lines" I want to be listed in the "Print-List" page
V
Move to print list | First to last | Name | Address | Address | Mobile | Remarks | Notes |  |  | This is the trick, how do I make Excel make a copy of that line if i tick or select it?
 | 1 | [NAME] | Street 1 | Town 1234 | 12345678 |  |  |  |  | (Looking for a function, macro or something to tell it to move it IF I select it)
v | 2 | Doe John | Street 100 | Town 1234 | 12345679 |  |  |  |  | v | When i make a "tick" or select this line, it will automaticly move it to the "Print-List" page.
v | 3 | [NAME] | Street 19 | Town 1234 | 12345680 |  |  |  |  |  | If I tick all lines, then all lines are moved to "Print-List" page.
 | 4 | Doe Sam | Street 21 | Town 1235 | 12345681 |  |  |  |  |  | If I select only 2 this week, then only 2 will be moved to "Print-List" page.
v | 5 | [NAME] | Street 51 | Town 1236 | 12345682
 | 6 | Doe [NAME] | Street 71 | Town 1237 | 12345683
v | 7 | [NAME] | Street 881 | Town 1238 | 12345684
 | 8 | Doe [NAME] | Street 11 | Town 1239 | 12345685
 | ^          This is the number by GPS position and at what time I need to be there.
THIS IS THE LIST I USE AS MY DATABASE AND FROM THIS I GENERATE A "PRINT-LIST" ON THE PRINT-LIST PAGE TO PRINT.
This is the main database. I put in all the new people as a get a new person on my lists.
From this list I select the ones I want to put in my Print-List.
So a few of the people I do not visited this week. But maybe next week.
So  I need the person on the list so that I don't have to look up on GPS and put in the list on the right place.
Here I have made 4 selections and then in the "Print-List" page you can see the result of this "function" that i dont know :p
v | = | 4 diffrent people to be automaticly be moved to my "Print-List" page.
Spreadsheet: 153355d1335883664-auto-filter-and-summaries-training-master-sheet
Sheet: Validation Sheet

TRAINING COURSE | VALIDITY PERIOD | [NAME] for data sheet | CONTRACT | Department | JOB TITLE | banding | Current Status | SITE | [NAME] for Summary Sheet
Health and Safety | 3 | 0 | NBT eXtra | Domestic Services | Assistant | 1 | Employed | SMD | <75
Fire | 1 | 30 | Substantive | Portering Services | Assistant Manager | 2 | LTS | FHY | >76<90
Infection Control | 3 | 45 | Agency | Catering Services | Manager | 3 | Maternity | CSM | >90
SID | 3 |  |  | Accommodation | Site Manager | 4 | Sabattical | TW
5 | 5 |  |  | Nurseries | Head of Service | 5 | Other LT [NAME] | BBH
6 | 1 |  |  | Repographics and Postal | Supervisor | 6 | Suspension | Community
7 | 2 |  |  | Transport & Logistics | Acting Supervisor | 7 | Left Trust
8 | 3 |  |  | Receipt & Distribution Services | Admin & Clerical Support | 8a
9 | 4 |  |  | Environmental Management Unit | Support Services Manager | 8b
10 | 5 |  |  | Training Department |  | 8c
11 | 1 |  |  | Volunteers |  | 8d
12 | 2 |  |  | Linen & laundry |  | 9
13 | 3
14 | 4
15 | 5
16 | 1
17 | 2
18 | 3
19 | 4
20 | 5
Spreadsheet: 29828d1225006790-finding-the-set-of-ordered-triplets-that-adds-up-to-a-target-triplet-excelforum_2003_upload
Sheet: Sheet1

a | b | c | d
4 | 0 | 0 | 0 |  | A2:D4 represent your results
-5 | 8 | 0 | 1
18 | 15 | 4 | -1
14 | 20 | 1 | 3 |  | A5:D5 represents variance between results & test criteria (ABS)
0 |  |  |  |  | A7:D7 represent test criteria
1
2
1 | 2 | 3 | 4 |  | A11:D12 show closest matches 1 through 4
c | d | a | b
Spreadsheet: 868441d1715175527-sort-function-broken-keep-dreaming-league-standings
Sheet: 3 - MAR

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W |  | L |  | PTS |  | PF |  | PA
JASON | 1 |  |  | 7 |  |  |  | 5 |  |  | 7 |  |  |  | 10 |  |  | 10
MOUNTNEY | 10 |  |  |  | 10 |  |  |  | 10 |  |  | 6 |  |  |  | 10 |  |  | 5
WAYNE |  | 10 |  |  | 5 |  |  | 10 |  |  |  |  | 10 |  |  |  | 10 |  |  | 10
PAUL |  | 4 |  |  |  | 7 |  |  | 3 |  |  |  |  | 10 |  |  |  | 4 |  |  | 2
MIKE |  |  | 10 |  |  | 10 |  |  |  | 10 |  | 10 |  |  | 7 |  |  |  |  | 7
[NAME] |  |  | 6 |  |  |  | 2 |  |  |  | 10 |  | 6 |  |  | 4 |  |  |  |  | 10
[NAME] |  |  |  | 10 |  |  | 10 |  |  | 5 |  |  |  | 7 |  |  | 7 |  | 10
 | 1-2 | 3-4 | 5-6 | 1-7 | 2-3 | 4-5 | 6-7 | 1-3 | 2-4 | 5-7 | 1-6 | 2-5 | 3-6 | 4-7 | 1-5 | 2-6 | 3-7 | 1-4 | 2-7 | 3-5 | 4-6
Spreadsheet: 777395d1650367297-transfer-data-from-sheet-1-to-sheet-2-using-formula-formula
Sheet: Sheet1

 |  |  | AA | Jan | Feb | Mar | Apr | May | Jun | Jul
 |  |  | Month | 0 | 2481.389578163772 | 2923.976608187134 | 9036.144578313253 | 2808.988764044944 | 0 | 5305.039787798408
 |  |  | Target | 2222 | 2222 | 2222 | 2222 | 2222 | 2222 | 2222
Spreadsheet: 737136d1624208617-find-value-within-two-column-min-max-table-and-return-corresponding-offset-value-exampletable
Sheet: Sheet3

Min | [NAME] | Payout |  |  | Actual % of Goal | Payout
0 | 0.96 | 0 |  |  | 1.17 | 550
0.97 | 0.99 | 150
1 | 1.03 | 300
1.04 | 1.07 | 400
1.08 | 1.11 | 450
1.12 | 1.15 | 500
1.16 | 1.19 | 550
1.2 | 1.23 | 600
1.24 | 1.27 | 650
1.28 | 1.31 | 700
1.32 | 1.35 | 705
1.36 | 1.39 | 710
1.4 | 1.43 | 715
1.44 | 1.47 | 720
1.48 | 1.51 | 725
1.52 | 1.55 | 730
1.56 | 1.59 | 735
1.6 | 1.63 | 740
1.64 | 1.67 | 745
1.68 | 1.71 | 750
1.72 | 1.75 | 755
1.76 | 1.79 | 760
1.8 | 1.83 | 765
1.84 | 1.87 | 770
1.88 | 1.91 | 775
1.92 | 1.95 | 780
1.96 | 1.99 | 785
2 | 2.03 | 1000
Spreadsheet: 106362d1303546026-drop-down-list-options-dependentlistsupdated
Sheet: Choices

On this page we use Validation List of |  |  |  |  |  | Sample Lists
Allow: =Animals
for both H5 and H19 versions. |  |  |  |  |  | Problematic
 |  |  |  |  |  |  | Classes | Types | Animals
Then, the validation list for I5 uses an INDIRECT formula |  |  |  |  |  |  | Feline | Tigers | Bengal
Allow:  =INDIRECT(H5)
so the word chosen becomes the active "list" and the animal
names are brought over. The same thing is used in the |  |  |  |  |  |  | NOTE: Problem if you make selections in the boxes above, and then go back and change an earlier box
validation list for J5: |  |  |  |  |  |  | it does not change the others, so you could end up with Canine - Tiger - Bald Eagle.
Allow:  =INDIRECT(I5)
This technique could go on indefinitely. |  |  |  |  |  |  | SOLUTION: A WorkSheet_change macro can be used to watch for changes in the earliest boxes and then
 |  |  |  |  |  |  | clear the previous made in later boxes that are now no longer valid.
The "LISTS" are on the next sheet.
 |  |  |  |  |  |  | Right-click on the sheetname tab and VIEW CODE to see the macro.
 |  |  |  |  |  | Better
 |  |  |  |  |  |  | Classes | Types | Animals
 |  |  |  |  |  |  | Canine | Universal | Polish
Spreadsheet: 725010d1616499871-daily-sales-spreadsheet-month-target-2021-22
Sheet: 2021 QTR1

Monthly Target | 2021-04-01 00:00:00 |  |  |  |  |  | HIDE ME |  | 2021-05-01 00:00:00 |  |  |  |  |  |  | 2021-06-01 00:00:00
35150 |  |  |  |  |  |  | Holidays
Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  | 2021-01-01 00:00:00 | Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  | Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target
 |  |  |  |  |  |  | 2021-04-02 00:00:00
 |  |  |  |  |  |  | 2021-04-05 00:00:00
 |  |  |  |  |  |  | 2021-05-03 00:00:00
 |  |  |  |  |  |  | 2021-05-31 00:00:00
 |  |  |  |  |  |  | 2021-08-30 00:00:00
 |  |  |  |  |  |  | 2021-12-27 00:00:00
 |  |  |  |  |  |  | 2021-12-28 00:00:00
 |  |  |  |  |  |  | 2022-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Target
 |  | Target
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Target
TOTAL |  |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  | TOTAL
Spreadsheet: mike_swerzbin__28076__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rockies | 2002-01-10 00:00:00 | 18 | 19.25 | 14.5 | 15.75
Mid-Columbia | 2002-01-10 00:00:00 | 18 | 19.25 | 14.5 | 15.75
COB | 2002-01-10 00:00:00 | 19.5 | 20.5 | 14.5 | 16
N. California | 2002-01-10 00:00:00 | 20.5 | 22.5 | 15 | 17
Midway/Sylmar | 2002-01-10 00:00:00 | NA | NA | NA | NA
S. California | 2002-01-10 00:00:00 | 20.5 | 22.75 | 15 | 17.5
Mead | 2002-01-10 00:00:00 | 19.25 | 21.5 | 14 | 15.75
Palo Verde | 2002-01-10 00:00:00 | 19 | 21.5 | 12.5 | 15
Inland SW | 2002-01-10 00:00:00 | 19 | 21.75 | 12.5 | 15.75
4-Corners | 2002-01-10 00:00:00 | 19 | 20.5 | 13 | 14.25
Central Rockies | 2002-01-10 00:00:00 | 17.75 | 20.5 | 13.75 | 15.5
Spreadsheet: 89196d1288945456-how-to-add-two-series-of-timestamp-values-to-the-same-chart-office-2010-example_3values
Sheet: Testaa aikajanan suhteutus

Time (UTC) | Value1 | Time (UTC) | Value2 | Time (UTC) | Value3
00:00:02 | 10.5 | 00:00:21 | 8 | 00:00:02 | 32.3
00:00:21 | 10.2 | 00:00:31 | 7.7 | 00:00:11 | 31.7
00:01:12 | 9.9 | 00:01:12 | 7.4 | 00:00:41 | 32.6
00:03:01 | 10.2 | 00:03:11 | 8 | 00:00:51 | 33.5
00:03:11 | 10.5 | 00:03:31 | 8.3 | 00:01:01 | 34.7
00:03:21 | 10.8 | 00:06:21 | 8 | 00:01:12 | 36.2
00:06:11 | 10.5 | 00:06:42 | 7.7 | 00:01:23 | 37.7
00:06:32 | 10.2 | 00:07:11 | 7.4 | 00:01:32 | 38.6
00:06:52 | 9.9 | 00:07:31 | 7.1 | 00:01:41 | 39.2
00:07:31 | 9.6 | 00:09:42 | 7.4 | 00:01:51 | 39.5
00:08:21 | 9.3 | 00:09:51 | 7.7 | 00:02:21 | 39.2
00:09:37 | 9.9 | 00:10:01 | 8 | 00:02:32 | 38.6
00:09:42 | 10.2 | 00:10:11 | 8.3 | 00:02:42 | 38
00:09:51 | 10.5 | 00:10:21 | 8.6 | 00:02:52 | 36.8
00:10:01 | 10.8 | 00:10:52 | 8.3 | 00:03:01 | 35.6
00:11:11 | 10.5 | 00:11:01 | 8 | 00:03:11 | 34.1
00:14:49 | 10.2 | 00:15:55 | 7.1 | 00:03:21 | 32.6
00:15:55 | 9.3 | 00:16:45 | 7.4 | 00:03:31 | 32
00:16:30 | 9.6 | 00:16:55 | 8 | 00:03:41 | 31.7
00:16:36 | 9.9 | 00:17:06 | 8.3 | 00:04:02 | 32.3
00:16:45 | 10.2 | 00:17:59 | 8 | 00:04:12 | 32.9
00:16:55 | 10.8 |  |  | 00:04:21 | 34.1
00:18:42 | 10.5 |  |  | 00:04:31 | 35.6
 |  |  |  | 00:04:41 | 37.1
 |  |  |  | 00:04:51 | 38.3
 |  |  |  | 00:05:02 | 38.9
 |  |  |  | 00:05:12 | 39.5
 |  |  |  | 00:05:51 | 38.9
 |  |  |  | 00:06:01 | 38.3
 |  |  |  | 00:06:11 | 37.4
 |  |  |  | 00:06:21 | 35.9
 |  |  |  | 00:06:32 | 34.7
 |  |  |  | 00:06:42 | 33.2
 |  |  |  | 00:06:52 | 32
 |  |  |  | 00:07:01 | 31.7
 |  |  |  | 00:07:31 | 32.6
 |  |  |  | 00:07:41 | 33.5
 |  |  |  | 00:07:51 | 35
 |  |  |  | 00:08:02 | 36.8
 |  |  |  | 00:08:12 | 38
 |  |  |  | 00:08:21 | 38.9
 |  |  |  | 00:08:31 | 39.5
 |  |  |  | 00:08:41 | 39.8
 |  |  |  | 00:09:12 | 39.2
 |  |  |  | 00:09:22 | 38.6
 |  |  |  | 00:09:37 | 37.7
 |  |  |  | 00:09:42 | 36.8
 |  |  |  | 00:09:51 | 35
 |  |  |  | 00:10:01 | 33.5
 |  |  |  | 00:10:11 | 32.3
 |  |  |  | 00:10:21 | 31.7
 |  |  |  | 00:10:52 | 32
 |  |  |  | 00:11:01 | 33.2
 |  |  |  | 00:11:11 | 34.4
 |  |  |  | 00:11:23 | 35.9
 |  |  |  | 00:11:31 | 37.4
 |  |  |  | 00:11:42 | 38.6
 |  |  |  | 00:11:52 | 39.2
 |  |  |  | 00:12:02 | 39.5
 |  |  |  | 00:12:31 | 39.2
 |  |  |  | 00:12:41 | 38.6
 |  |  |  | 00:13:20 | 38
 |  |  |  | 00:13:56 | 36.8
 |  |  |  | 00:14:15 | 35.6
 |  |  |  | 00:14:46 | 34.1
 |  |  |  | 00:14:47 | 32.6
 |  |  |  | 00:14:49 | 31.7
 |  |  |  | 00:15:55 | 39.5
 |  |  |  | 00:16:05 | 38.9
 |  |  |  | 00:16:16 | 38
 |  |  |  | 00:16:30 | 36.8
 |  |  |  | 00:16:36 | 35.3
 |  |  |  | 00:16:45 | 33.8
 |  |  |  | 00:16:55 | 32.6
 |  |  |  | 00:17:06 | 31.7
 |  |  |  | 00:17:43 | 32
 |  |  |  | 00:17:59 | 32.9
 |  |  |  | 00:18:01 | 34.1
 |  |  |  | 00:18:05 | 35.6
 |  |  |  | 00:18:15 | 37.1
 |  |  |  | 00:18:42 | 38.3
 |  |  |  | 00:18:47 | 39.2
 |  |  |  | 00:18:58 | 39.5
 |  |  |  | 00:18:59 | 39.8
Spreadsheet: 581429d1531298856-compare-2-sheets-and-show-balance-bbsn
Sheet: QUARTER

 | Yum Nak
Spreadsheet: 364646aa-0add-4ffb-9cd6-20386de4fb04
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
TREE4 | Test | TREE4 | Tree Panel # 4 | Tree Panel # 4 | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel						 Specimen Volume: 0.5 mL		 Additional Information: See Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
TREE4 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
TREE4 | Result | TREE4 | Tree Panel # 4 | Tree Panel # 4 | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 30182-0 | (Olea europaea+Salix caprea+Pinus strobus+Eucalyptus spp+Acacia longifolia+Melaleuca leucadendron) Ab.IgE:ACnc:Pt:Ser:Qn:Multidisk
Spreadsheet: 150381d1334495077-how-to-pull-multiple-values-examplev2
Sheet: Sheet2

Consultant | 2012-04-06 00:00:00
AS
SB
DS
CC
KB
SS
Spreadsheet: 62458d1263397929-two-column-formula-hr157-2-column-formula
Sheet: sheet1

 | How I can calculate this using two different columns. One for dollars and one for cents?
Date | Description |  |  |  |  |  | A |  |  |  |  | B |  |  |  | OTHERS
 |  |  |  |  |  | CT | IN |  | OUT |  |  | IN |  | OUT |  | IN |  | OUT
 |  |  |  |  |  |  | 20 | 1
 |  |  |  |  |  |  | 43 | 98
 |  |  |  |  |  |  | 17 | 1
 |  |  |  |  |  |  | 100
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 987 | 50
 |  |  |  |  |  |  | 32 | 49
 |  |  |  |  |  |  | 1 | 1
TOTAL |  |  |  |  |  |  | 1206 | 00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | $ | 1206 | 00
Spreadsheet: 288562d1389230471-team-list-drop-down-team-list-test-ndm
Sheet: Sheet1

Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7
T1 Agent1 | [NAME] | T3 Agent1 | [NAME] | [NAME] | T6 Agent1 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Team 1
T1 Agent2 | T2 Agent2 | T3 Agent2 | T4 Agent2 | T5 Agent2 | T6 Agent2 | T7 Agent2 |  |  |  |  |  |  |  |  |  |  |  |  | Team 2
T1 Agent3 | T2 Agent3 | T3 Agent3 | T4 Agent3 | T5 Agent3 | T6 Agent3 | T7 Agent3 |  |  |  |  |  |  |  |  |  |  |  |  | Team 3
T1 Agent4 | T2 Agent4 | T3 Agent4 | T4 Agent4 |  | T6 Agent4 | T7 Agent4 |  |  |  |  |  |  |  |  |  |  |  |  | Team 4
T1 Agent5 | T2 Agent6 | T3 Agent5 | T4 Agent5 |  | T6 Agent5 | T7 Agent5 |  |  |  |  |  |  |  |  |  |  |  |  | Team 5
T1 Agent6 |  | T3 Agent6 | [NAME] Agent6 |  | T6 Agent6 |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 6
T1 Agent7 |  | T3 Agent7 | T4 Agent7 |  | T6 Agent7 |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 7
T1 Agent8 |  | T3 Agent8 |  |  | T6 Agent8 |  |  |  | Team Name: | Team 1 | <- Data Validation list of Cells A1 through G1
T1 Agent9 |  | T3 Agent9 |  |  | T6 Agent9 |  |  |  | Agent 1
T1 Agent10 |  | T3 Agent10 |  |  | T6 Agent10 |  |  |  | Agent 2
T1 Agent11 |  |  |  |  | T6 Agent11 |  |  |  | Agent 3
T1 Agent 12 |  |  |  |  | [NAME] |  |  |  | Agent 4
T1 Agent13 |  |  |  |  | T6 Agent13 |  |  |  | Agent 5
[NAME] |  |  |  |  |  |  |  |  | Agent 6
T1 Agent15 |  |  |  |  |  |  |  |  | Agent 7
[NAME] |  |  |  |  |  |  |  |  | Agent 8 |  | <- List auto fills from Column based on team selected above
 |  |  |  |  |  |  |  |  | Agent 9 |  |  | *Example shows selecting Team 2 in drop down which
 |  |  |  |  |  |  |  |  | Agent 10 |  |  | then auto fills K10 through K29 with data from Column B
 |  |  |  |  |  |  |  |  | Agent 11 |  |  | down to Row 21
 |  |  |  |  |  |  |  |  | Agent 12
 |  |  |  |  |  |  |  |  | Agent 13
 |  |  |  |  |  |  |  |  | Agent 14
 |  |  |  |  |  |  |  |  | Agent 15
 |  |  |  |  |  |  |  |  | Agent 16
 |  |  |  |  |  |  |  |  | Agent 17
 |  |  |  |  |  |  |  |  | Agent 18
 |  |  |  |  |  |  |  |  | Agent 19
 |  |  |  |  |  |  |  |  | Agent 20