tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 61e0f246-20cb-4b9c-b576-d93be5c3a242
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-04-04 09:26:04.630000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 102 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
5.125 | 101.253 | 101.003 | 100.878 | 100.503
5 | 100.858 | 100.608 | 100.483 | 100.108 |  | Note: | Refer To Price [NAME]
4.875 | 100.354 | 100.104 | 99.979 | 99.604 |  |  | For all Price Adjs
4.75 | 99.395 | 99.145 | 99.02
4.625 | 98.256 | 98.006 | 97.881
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.375 | 101.267 | 101.017 | 100.892 | 100.517
4.25 | 100.731 | 100.481 | 100.356 | 99.981
4.125 | 99.646 | 99.396 | 99.271 | 98.896
4 | 99.308 | 99.058 | 98.933 | 98.558
3.875 | 98.892 | 98.642 | 98.517
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-03-28 09:32:41.950000
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-04-11 09:32:41.950000
30 DAY | 2011-04-26 09:32:41.950000
45 DAY | 2011-05-11 09:32:41.950000
60 DAY | 2011-05-26 09:32:41.950000
90 DAY | 2011-06-25 09:32:41.950000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 139204d1328127862-excel-2007-back-at-it-with-conditional-time-formulas-example
Sheet: Totals

Room | Instructor Station Total hours | % Usage Instructor | Total hours usage | % usage |  |  |  |  | Raw data |  | Room totals
3205 |  |  |  |  |  | Number of Training days | 10
3306 |  |  |  |  |  | Total training hours
3307 |  |  |  |  |  | Total 4 hour training sessions
3309
3319
4109
4116
4120 |  |  |  |  |  | Total availble asset hours
4313 |  |  |  |  |  | Total Logged on Hours
8331 |  |  |  |  |  | Total Asset Usage %
 |  |  |  |  |  |  |  | Total logged on hours
 |  |  |  |  |  |  |  |  |  | # of seats
 |  |  |  |  |  |  |  |  |  | 3205 | 14
 |  |  |  |  |  |  |  |  |  | 3306 | 26
 |  |  |  |  |  |  |  |  |  | 3307 | 2
 |  |  |  |  |  |  |  |  |  | 3309 | 2
 |  |  |  |  |  |  |  |  |  | 3319 | 1
 |  |  |  |  |  |  |  |  |  | 4109 | 11
 |  |  |  |  |  |  |  |  |  | 4116 | 11
 |  |  |  |  |  |  |  |  |  | 4120 | 13
 |  |  |  |  |  |  |  |  |  | 4313 | 11
 |  |  |  |  |  |  |  |  |  | 8331 | 15
 |  |  |  |  |  |  |  |  |  | Total WS
Spreadsheet: 546548d1510087313-key-word-through-filter-search-law-cases
Sheet: Key

 | Keyword List |  |  |  | Source
 | bias | reasonable apprehension of bias |  |  | O.D.C.
 | compel | power to compel production |  |  | S.C.C
 | evidence |  |  |  | O.C.A.
 | interest | conflict of interest
 | jurisdiction | jurisdiction issues/jurisdiction to adjourn
 | medical records | production of medical records
 | parties | parties of standing
 | publication | non-publication orders
 | proceedings | stay of proceedings
 | production | production of materials
 | proof | standard of proof
 | role | role of the coroner
 | scope | scope of the inquest
 | standing | standing issues
 | verdict | by what means verdict
 | warrant | use of coroner's warrants (section 16)
Spreadsheet: 324929d1402590135-sales-forecasting-help-with-autofil-using-dates-forecast-6-3-14-dgk-5
Sheet: Forecast

Contract data |  |  |  | LTA Terms COMMA separated (leave blank if none) | Project Start (SOP) | Contract Months | Project End (EOP) | Year Fraction (SOP) | Year Fraction (EOP) | Pieces per unit sales | Quoted Volume | Piece Price [NAME] | LTA terms |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual pricing policy |  |  |  |  |  |  |  |  |  |  |  | Sales per year
# | Customer | Platform | Component |  |  |  |  |  |  |  |  |  | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year |  |  |  |  |  |  |  |  |  |  |  |  | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  | Program A | [NAME]/LH | 0,1,1,1,1.652 | 2010-07-01 00:00:00 | 72 |  |  |  | 1 | 130000 | 0.702 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | [NAME] (carry over) | 1.1,2.2,3.3,1 | 2010-07-01 00:00:00 | 72 |  |  |  | 2 | 130000 | 0.702 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Program B | Overhead Lens | 0,1 | 2010-01-01 00:00:00 | 12 |  |  |  | 1 | 100000 | 2 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | [NAME] | 0,1,2 | 2011-07-01 00:00:00 | 48 |  |  |  | 1 | 600000 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 30798 | 34047
2 | 24115 | 24172
3 | 37822 | 39203
4 | 39167 | 39366
5 | 39156 | 39366
6 | 34815 | 35213
7 | 30553 | 36280
8 | 35129 | 36266
9 | 32847 | 32215
10 | 33580 | 32597
11 | 32586 | 30924
12 | 33197 | 32768
13 | 59586 | 59154
14 | 38353 | 39156
15 | 57137 | 56013
16 | 45140 | 44567
17 | 59683 | 59766
18 | 59831 | 59765
19 | 53903 | 59870
20 | 32912 | 36832
21 | 49704 | 54101
22 | 48338 | 47175
23 | 48257 | 47946
24 | 48198 | 40987
25 | 41382 | 40987
26 | 41978 | 48568
27 | 55659 | 56391
28 | 27465 | 27203
29 | 44260 | 44439
30 | 63138 | 62648
31
2001-10-31 00:00:00 |  |  | -2992.94
2001-11-30 00:00:00
CBS Volume
 |  |  | -1673
Spreadsheet: 473698d1470334824-generate-combinations-before-sheet
Sheet: Sheet1

BMW | Black | Maroon | Orange
Jaguar | Grey | Green | Cream
Subaru | Blue | [NAME] | Purple
Ferrari | Red | Pink | Turquoise
Lexus | White | Yellow | Teal
Spreadsheet: 834506d1687876021-how-to-pass-vlookup-with-more-than-one-result-passed-to-validated-drop-list-book1
Sheet: Sheet1

 |  | A | QQQ |  |  |  |  |  |  |  |  |  | B
 |  | A | WWW |  |  |  |  |  |  |  |  |  | C
 |  | B | EEE |  |  |  |  |  |  |  |  |  | D
 |  | B | RRR
 |  | B | TTT
 |  | B | YYY
 |  | C | UUU
 |  | C | III
 |  | D | OOO
Spreadsheet: 809850d1671374303-how-to-only-show-data-on-page-soa-mo-10-lf-there-is-data-in-gl-mo-10-oktober-2022-nuut-01-1-
Sheet: SOA MO 5

Statement of Activity
 | Cash Beginning of Period
 | Revenue:
 |  | Total Revenue:
 | Expenses:
 |  | Total Expenses:
 | Net : Income Gain / (Loss)
 | Cash End of Period
Spreadsheet: 270896d1381740294-excel-formula-to-get-the-desired-value-from-the-table-excel2
Sheet: Sheet2

Route ID | Route | Weight | Rate | In the Rate CELL (column D), I want the value from the below table. For example 1 in D2 cell, for Sydney-NSW3, the rate should come as 3.21
911.64 | Sydney-NSW3 | 71
1194.12 | Albury -Newcastle | 93
3364.08 | Canberra-NSW2 | 262
4185.84 | Newcastle-NSW5 | 326
2311.2 | Wollongong-NSW7 | 180
Destination | Sydney | Albury | Canberra | Newcastle | [NAME] | NSW1 | NSW2 | NSW3 | NSW4 | NSW5 | NSW6 | NSW7
Source
Sydney | 0.9823080000000001 | 2.879334 | 2.712612 | 1.978134 | 1.721292 | 1.23915 | 2.464782 | 3.208272 | 3.609306 | 3.767016 | 3.298392 | 3.298392
Albury | 2.879334 | 0.9913200000000001 | 1.640184 | 4.848456 | 4.605132 | 4.118484 | 5.33961 | 6.087606 | 6.497652 | 6.664374 | 6.164207999999999 | 6.164207999999999
Canberra | 2.712612 | 1.640184 | 0.9823080000000001 | 4.681734000000001 | 4.451928000000001 | 3.933738 | 5.195418 | 5.92539 | 6.344448 | 6.497652 | 6.001992 | 6.001992
Newcastle | 1.978134 | 4.848456 | 4.681734000000001 | 0.9913200000000001 | 3.69492 | 3.208272 | 4.451928000000001 | 5.195418 | 5.582934 | 5.758668 | 5.258502 | 5.258502
[NAME] | 1.721292 | 4.605132 | 4.451928000000001 | 3.69492 | 0.9913200000000001 | 2.960442 | 4.199592 | 4.938576 | 5.33961 | 5.515344 | 5.019684000000001 | 5.019684000000001
NSW1 | 1.23915 | 4.118484 | 3.933738 | 3.208272 | 2.960442 | 0.9913200000000001 | 3.69492 | 4.451928000000001 | 4.848456 | 5.019684000000001 | 4.519518 | 4.519518
NSW2 | 2.464782 | 5.33961 | 5.195418 | 4.451928000000001 | 4.199592 | 3.69492 | 1.640184 | 5.664042 | 6.087606 | 6.254328 | 5.758668 | 5.758668
NSW3 | 3.208272 | 6.087606 | 5.92539 | 5.195418 | 4.938576 | 4.451928000000001 | 5.664042 | 1.978134 | 6.831096000000001 | 7.002324 | 6.497652 | 6.497652
NSW4 | 3.609306 | 6.497652 | 6.344448 | 5.582934 | 5.33961 | 4.848456 | 6.087606 | 6.831096000000001 | 1.978134 | 7.41237 | 6.898686000000001 | 6.898686000000001
NSW5 | 3.767016 | 6.664374 | 6.497652 | 5.758668 | 5.515344 | 5.019684000000001 | 6.254328 | 7.002324 | 7.41237 | 2.122326 | 7.078926 | 7.078926
NSW6 | 3.298392 | 6.164207999999999 | 6.001992 | 5.258502 | 5.019684000000001 | 4.519518 | 5.758668 | 6.497652 | 6.898686000000001 | 7.078926 | 2.122326 | 6.583266
NSW7 | 3.298392 | 6.164207999999999 | 6.001992 | 5.258502 | 5.019684000000001 | 4.519518 | 5.758668 | 6.497652 | 6.898686000000001 | 7.078926 | 6.583266 | 2.122326
Spreadsheet: 23914d1213796619-complex-problem-automating-avg-calculations-sumandmediancountif
Sheet: Sheet1

Project | Hours
1 | 3
2 | 9
1 | 7
2 | 8
1 | 9
2 | 5
1 | 5
2 | 1
1 | 9
2 | 1
Spreadsheet: 887995d1738311195-incentive-data-calculation-incentive-new-final
Sheet: emp

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15
 |  |  | Target |  |  |  | ACHIEVEMENT |  |  |  | COLLECTION
 |  |  | April'24 | May'24 | June'24 | Target Q1FY24 | April'24 | May'24 | June'24 | [NAME] | April'24 | May'24 | June'24 | Q1FY25
Location | Emp Code | Employee Name | Target | Target | Target
Mumbai | 123456 | Ram | 100 | 125 | 125 | 350 | 113.808902 | 134.466475 | 165.7670092 | 414.0423862 | 18.65469 | 16.21694 | 25 | 59.87163
Mumbai | 123457 | Chirag | 80 | 70 | 70 | 220 | 61.1469174 | 64.46875960000001 | 10.3896555 | 136.0053325 | 0 | 0 | 0 | 0
Mumbai | 123458 | Faheem | 160 | 150 | 150 | 460 | 122.4526524 | 104.1192216 | 58.0951542 | 284.6670282 | 0 | 0 | 0 | 0
Mumbai | 123458 | lalsh | 80 | 80 | 80 | 240 | 61.305735 | 39.650462 | 47.70549869999999 | 148.6616957 | 0 | 0 | 0 | 0
Mumbai | 123459 | Sayonee | 80 | 95 | 95 | 270 | 51.284575 | 105.59045 | 116.128878 | 273.003903 | 0 | 0 | 0 | 0
Mumbai | 123460 | Mathur | 180 | 220 | 220 | 620 | 165.093477 | 240.056925 | 281.8958871999999 | 687.0462891999999 | 18.65469 | 16.21694 | 25 | 59.87163
Mumbai | 123655 | Nilu | 340 | 370 | 370 | 1080 | 287.5461294 | 344.1761466 | 339.9910414 | 971.7133173999999 | 18.65469 | 16.21694 | 25 | 59.87163
Spreadsheet: 159094d1338492383-vlookup-help-sample
Sheet: Coaching

Store 2 | Sales | New Accounts | Total Boxes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store 1
2012-03-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store 2
2012-03-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store 3
2012-03-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store 5
Spreadsheet: louise_kitchen__23036__Logistics staff ranking
Sheet: Rank - scheduling function only

LOGISTICS SCHEDULING TEAM RANKING (does not include support teams and additional transport rate employees)
[NAME] | Director | Management |  |  | 1
[NAME] | Manager | Northeast Logistics |  |  | 2
[NAME] | Manager | Central Logistics |  |  | 3
[NAME] | Manager | West Logistics |  |  | 4
[NAME] | Sr. Specialist | Central Logistics |  |  | 5
[NAME] | Manager | Texas Logistics |  |  | 6
[NAME] | Manager | Upstream Logistics |  |  | 7
[NAME] | East Desk Lead | Northeast Logistics |  |  | 8
[NAME] | Sr. Specialist | Northeast Logistics |  |  | 9
[NAME] | [NAME]. Specialist | Central Logistics |  |  | 10
Meredith Homco | Sr. Specialist | Northeast Logistics |  |  | 11
[NAME] | Specialist | West Logistics |  |  | 12
[NAME] | Specialist | West Logistics |  |  | 13
[NAME] | Asset Mgmt. Lead | Northeast Logistics |  |  | 14
[NAME] | Specialist | Northeast Logistics |  |  | 15
[NAME] | Sr. Specialist | Central Logistics |  |  | 16
[NAME] | Manager | Transport Rates |  |  | 17
[NAME] | Sr. Specialist | Central Logistics |  |  | 18
[NAME] | Specialist | West Logistics |  |  | 19
[NAME] | Sr.Specialist | Southeast Logistics |  |  | 20
[NAME] | Specialist | Central Logistics |  |  | 21
[NAME] | Specialist | West Logistics |  |  | 22
[NAME] | Sr. Specialist | Northeast Logistics |  |  | 23
[NAME] | Specialist | Upstream Logistics |  |  | 24
[NAME] | Staff | West Logistics |  |  | 25
[NAME] | Specialist | Southeast Logistics |  |  | 26
[NAME] | Staff | Northeast Logistics |  |  | 27
[NAME] | Sr. Specialist | West Logistics |  |  | 28
[NAME] | Specialist | Northeast Logistics |  |  | 29
[NAME] | Analyst | Texas Logistics |  |  | 30
[NAME] | Sr. Specialist | Upstream Logistics |  |  | 31
[NAME] | Staff | Central Logistics |  |  | 32
[NAME] | Specialist | Southeast Logistics |  |  | 33
[NAME] | Staff | Central Logistics |  |  | 34
Margie Straight | Sr. Specialist | Upstream Logistics |  |  | 35
[NAME] | Specialist | Southeast Logistics |  |  | 36
[NAME] | Specialist | Southeast Logistics |  |  | 37
[NAME] | Specialist | Southeast Logistics |  |  | 38
[NAME] | Analyst | West Logistics |  |  | 39
[NAME] | Analyst | Central Logistics |  |  | 40
[NAME] | Staff | Texas Logistics |  |  | 41
[NAME] | Specialist | Central Logistics |  |  | 42
[NAME] | Staff | West Logistics |  |  | 43
[NAME] | Staff | Southeast Logistics |  |  | 44
[NAME] | Sr. Specialist | Upstream Logistics |  |  | 45
[NAME] Felling | Staff | Upstream Logistics |  |  | 46
[NAME] | Specialist | West Logistics |  |  | 47
[NAME] | Specialist | Central Logistics |  |  | 48
[NAME] | Staff | West Logistics |  |  | 49
[NAME] | Staff | Central Logistics |  |  | 50
[NAME] | Staff | West Logistics |  |  | 51
[NAME] | Sr. Specialist | Central Logistics |  |  | 52
[NAME] | Staff | West Logistics |  |  | 53
[NAME] | Specialist | Southeast Logistics |  |  | 54
[NAME] | Specialist | Northeast Logistics |  |  | 55
Spreadsheet: joe_parks__14610__POSTIONTRAX_NOV
Sheet: PERM_SWAP

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  | 3 DAY ROLL
 |  |  | ROLL VALUE
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 838556d1691129337-textsplit-function-is-it-possible-to-spill-an-empty-cell-with-zero-txtsplit-hd
Sheet: Sheet1

 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed |  |  | GK |  |  |  |  | AliGW |  |  |  |  | HD |  |  |  |  | HD (if table size > 32K)
 | 1 Smoke Wagon |  | 86 | 85/ 73 | 67 |  |  |  | 73 |  |  |  |  | 85 | 73 | 67 |  |  | 85 | 73 | 67 |  |  | 85 | 73 | 67 |  |  | 85 | 73 | 67
 | 2 Global Hysteria |  | No Starts Available |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 3 I Strong |  | 86 | [NAME] 75 * | 71* |  |  |  | 75 |  |  |  |  | 86 | 75 | 71 |  | 86 | 86 | 75 | 71 |  | 86 | 86 | 75 | 71 |  | 86 | 86 | 75 | 71
 | 4 Maluma |  | No Starts Available |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 5 Warrior's Cause |  | 93 | 91/ 65 | 66 |  |  |  | 65 |  |  |  |  | 91 | 65 | 66 |  | 93 | 91 | 65 | 66 |  | 93 | 91 | 65 | 66 |  | 93 | 91 | 65 | 66
 | 6 Exclusive Entry |  | No Starts Available |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 7 Bundaburg |  | No Starts Available |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 8 Imposter Syndrome |  | 85 | 87/ 75 | 72 |  |  |  | 75 |  |  |  |  | 87 | 75 | 72 |  | 85 | 87 | 75 | 72 |  | 85 | 87 | 75 | 72 |  | 85 | 87 | 75 | 72
 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed
 | 3 Protectthewitness |  | 95 | 85/ 57 * | 66* |  |  |  | 57 |  |  |  |  | 85 | 57 | 66 |  |  | 85 | 57 | 66 |  |  | 85 | 57 | 66 |  |  | 85 | 57 | 66
 | 2 R Girl Faith |  | 79 | 73/ 61 * | 63* |  |  |  | 61 |  |  |  |  | 73 | 61 | 63 |  | 79 | 73 | 61 | 63 |  | 79 | 73 | 61 | 63 |  | 79 | 73 | 61 | 63
 | 5 Vaccina |  | 88 | 81/ 55 * | 63* |  |  |  | 55 |  |  |  |  | 81 | 55 | 63 |  | 88 | 81 | 55 | 63 |  | 88 | 81 | 55 | 63 |  | 88 | 81 | 55 | 63
 | 1 Phancy Philly |  | 79 | 67/ 51 * | 54* |  |  |  | 51 |  |  |  |  | 67 | 51 | 54 |  | 79 | 67 | 51 | 54 |  | 79 | 67 | 51 | 54 |  | 79 | 67 | 51 | 54
 | 4 Sailor's Salute |  | 82 | 71/ 50 * | 53* |  |  |  | 50 |  |  |  |  | 71 | 50 | 53 |  | 82 | 71 | 50 | 53 |  | 82 | 71 | 50 | 53 |  | 82 | 71 | 50 | 53
 | 6 Calvary Kat |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Spreadsheet: bb3fc4c8-9c61-465b-ab59-c6e61a47f5fe
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
FVDRL | Test | FVDRL | VDRL, Serum | VDRL, Serum | Slide Micro-Flocculation |  |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 1 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	Mild OK; Gross reject Thawing:	Warm OK; Cold OK Lipemia:	Mild OK; Gross reject Icterus:	NA Other:	NA | Reference Range: Non-Reactive  The VDRL is a non-treponemal-specific test; therefore, a treponemal-specific confirmatory test should be performed unless prior syphilis infection has been documented for this patient.   Test Performed by:	Focus Diagnostics 			5785 Corporate Avenue 			Cypress, CA 90630-4750 | Monday through Friday | 1- 4 days | 3 - 7 days | 1 | 86592 |  |  |  |  | Focus Diagnositics, Inc.
FVDRL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FVDRL | Result | FVDRL | VDRL, Serum | VDRL, Serum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 157459d1337753767-automatically-sort-the-data-and-ranking-based-on-the-sorted-data-schedule-calculator
Sheet: Sheet1

 | 9:30 Shift Schedule
 | Month | 2011 | 2012
 | Jan | Sandeep | [NAME]
 | Feb | Mawsumi | Vijender
 | Mar | [NAME] | Nasrin
 | Apr | Rajeev | Sandeep
 | May | [NAME] | Mawsumi
 | Jun | [NAME] | [NAME]
 | Jul | vijender | Rajeev
 | Aug | sandeep | [NAME]
 | Sep | Nasrin | Vijender
 | Oct | [NAME] | Nasrin
 | Nov | Mawsumi | Sandeep
 | Dec | Rajeev | Mawsumi
Spreadsheet: 746712d1630962588-problems-with-dataset-index-formula-sheet1
Sheet: Ark1

Storename | Product |  | Storename | 1 | 2 | 3 | 4 | 5
Foodstore 1 | Apple |  | Foodstore 1 |  | Pear | [NAME] | Lemon
Foodstore 1 | Pear |  | Foodstore 2 | Grass | Blueberry
Foodstore 1 | [NAME]
Foodstore 1 | Lemon |  | Storename | Product 1 | Product 2 | Product 3 | Product 4
Foodstore 2 | Grass |  | Foodstore 1 | Apple | Pear | [NAME] | Lemon
Foodstore 2 | Blueberry |  | Foodstore 2 | Grass | Blueberry
Spreadsheet: 356634d1415171194-concatenate-as-long-there-are-values-in-the-next-cells-concatenation_need-help
Sheet: Sheet1

 | Client 1 | Client 2 | Client 3 | Client 4
CONCATENATED VERSION  It will concatenate the values, and will stop concatenating if the next cell is blank | [PHONE],[PHONE],[PHONE],[PHONE],[PHONE],[PHONE] | [PHONE],[PHONE] | [PHONE],[PHONE],[PHONE],[PHONE],[PHONE],[PHONE] | [NAME]
 | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 | [PHONE] |  | [PHONE] | [PHONE]
 | [PHONE] |  | [PHONE] | [PHONE]
 | [PHONE] |  | [PHONE] | [PHONE]
 | [PHONE] |  | [PHONE] | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
Spreadsheet: 4b6cfa60-f10f-4c99-8a7b-90d9b72b9fb5
Sheet: ID-CPA-019

 |  |  | Prescribed Grazing - 528 |  |  |  |  |  |  |  |  |  |  |  | ID-CPA-019
 |  |  | Upland Wildlife Habitat Management - 645
 |  |  | Plant Height |  |  |  |  |  |  |  |  |  |  |  | Idaho
Natural Resources Conservation Service |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January 2014
Observer |  |  |  |  | Location
 | Plot # |  | Line # |  |  | Recorder |  |  |  |  | Line Length
 | Direction |  | Date
 | Woody Plant Species |  |  |  | Plant Height |  |  |  | Herbaceous Plant Species |  |  |  | Plant Height
Pt. |  |  |  |  |  |  |  | Pt.
3 |  |  |  |  |  |  |  | 3
6 |  |  |  |  |  |  |  | 6
9 |  |  |  |  |  |  |  | 9
12 |  |  |  |  |  |  |  | 12
15 |  |  |  |  |  |  |  | 15
18 |  |  |  |  |  |  |  | 18
21 |  |  |  |  |  |  |  | 21
24 |  |  |  |  |  |  |  | 24
27 |  |  |  |  |  |  |  | 27
30 |  |  |  |  |  |  |  | 30
33 |  |  |  |  |  |  |  | 33
36 |  |  |  |  |  |  |  | 36
39 |  |  |  |  |  |  |  | 39
42 |  |  |  |  |  |  |  | 42
45 |  |  |  |  |  |  |  | 45
48 |  |  |  |  |  |  |  | 48
51 |  |  |  |  |  |  |  | 51
54 |  |  |  |  |  |  |  | 54
57 |  |  |  |  |  |  |  | 57
60 |  |  |  |  |  |  |  | 60
63 |  |  |  |  |  |  |  | 63
66 |  |  |  |  |  |  |  | 66
69 |  |  |  |  |  |  |  | 69
72 |  |  |  |  |  |  |  | 72
75 |  |  |  |  |  |  |  | 75
78 |  |  |  |  |  |  |  | 78
81 |  |  |  |  |  |  |  | 81
84 |  |  |  |  |  |  |  | 84
87 |  |  |  |  |  |  |  | 87
90 |  |  |  |  |  |  |  | 90
93 |  |  |  |  |  |  |  | 93
96 |  |  |  |  |  |  |  | 96
99 |  |  |  |  |  |  |  | 99
Average Height Woody Species (inches) |  |  |  |  |  |  |  | Average Height Herbaceous Species (inches)
Plant Height |  |  |  | [NAME] to nearest: |  |  |  |  |  |  |  | Unknown Species Codes: AF# [NAME] annual forb PF# = perennial forb AG# = annual graminoid PG# = perennial graminoid SH# = shrub TR# = tree
0 ' to 2 feet : |  |  |  | 0.5 Inch
2'1" to 5 feet : |  |  |  | Inch
5'1" to 15 feet |  |  |  | Foot (in inches)
> 15' 1" |  |  |  | 5 Feet (in inches)
Spreadsheet: 680856d1591222587-adding-a-formula-with-relative-cell-address-to-data-cells-quickly-excel-forum-case-1
Sheet: Sheet1

 |  |  |  |  | % of original
 | July | Aug | Sep |  | July | Aug | Sep
Expense budget |  | 1000 | 1500 |  | 0.5 | 0.3 | 0.2
How do I apply the same formula to data cells B5:D5 quickly (if you have many rows & columns to do), so that:
Cell B5 | =500*F5
Cell C5 | =1000*G5
Cell D5 | =1500*H5