tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 742074d1627503241-formulas-not-remaining-with-correct-rows-after-sort-sample
Sheet: Cycle Time

 | CLICKING THE BUTTON ABOVE RUNS A MACRO TO REFRESH THE DATA |  |  |  |  |  |  |  |  | Hover over column headers to see additional information about the data in the cells in the each column
 | DEPARTMENT YTD TOTALS / AVERAGES |  |  |  |  | TOTAL |  |  |  | TOTAL | TOTAL | TOTAL | TOTAL | TOTAL | TOTAL | TOTAL | TOTAL | AVG | AVG | AVG | TOTAL | TOTAL | TOTAL | TOTAL |  |  |  | TOTAL | TOTAL | TOTAL | TOTAL
 |  |  |  |  | YTD Total # of Deployments
 | Primary County | Primary State | Primary Cat Code Being Handled | Primary Loss Type Being Handled | Claim Rep | Supervisor | 1st Day Claims Rec'd | (Arrive) 1st Work Day | ([NAME]) 1st Travel Day | Meeting, Training, Travel, PTO, Off Days During Tour | Count of Days                   Able to Inspect | Days Onsite to Date | Days Remaining Onsite | Count of Received | Count of Contacted | Count of Inspected | Count of Returned | Average Days to Contact | Average Days to Inspect | Average Days to Return | Contacted %                            of Received | Inspected %                                  of Received | Returned %                              of Inspected | Returned %                              of Received | Date of First Assignments Received | Date of First  Contact | Date of First Inspection | Count of Estimated                             Onsite | % of Claims                           Estimated Onsite | Count of Paid                             Onsite | % of Claims                                Paid Onsite | NOTES
1
2
3
4
5
6
Spreadsheet: 703870d1605200812-count-occurrances-with-crieria-from-other-column-s-samph
Sheet: report1605200133665

id: |  | status: | job: | Expected Value:
113062 |  | Complete | Job-12485 | 5
113062 |  | Complete | Job-124855 | 5
113062 |  | Complete | Job-124856 | 5
113062 |  | Complete | [NAME] | 5
113062 |  | Complete | Job-124858 | 5
113062 |  | Cancelled | [NAME] | 5
1144 |  | Complete | Job-138624 | 1
114443 |  | Cancelled | [NAME] | 0
11543 |  | Complete | Job-147 | 1
1155 |  | Complete | Job-150 | 2
1155 |  | Complete | Job-176 | 2
Spreadsheet: 838426d1690994795-i-need-to-count-employees-active-at-a-certain-time-based-on-start-and-end-dates-book1
Sheet: Sheet2

First Name | EFT | Start | End | In Range | Result |  | INSERT DATE HERE: | 2019-04-05 00:00:00
a | 1 | 2003-09-15 00:00:00
b | 1 | 2004-11-08 00:00:00 | 2022-01-31 00:00:00 |  |  |  | Total Employees:
c | 1 | 2005-05-25 00:00:00 |  |  |  |  | EFT:
d | 1 | 2006-06-19 00:00:00
e | 1 | 2007-09-10 00:00:00
f | 1 | 2010-04-01 00:00:00 | 2018-03-23 00:00:00 |  |  |  |  | Based on April 5, 2019 total employees is 12 but total EFT is only 11.8
g | 1 | 2010-08-09 00:00:00 | 2019-03-31 00:00:00
h | 1 | 2013-11-05 00:00:00 | 2020-07-30 00:00:00
i | 1 | 2015-03-16 00:00:00
j | 1 | 2016-09-20 00:00:00
k | 1 | 2017-09-25 00:00:00
l | 1 | 2018-04-09 00:00:00
m | 1 | 2018-06-11 00:00:00
n | 0.8 | 2019-04-01 00:00:00
o | 1 | 2019-08-12 00:00:00
p | 1 | 2021-03-01 00:00:00
q | 1 | 2021-09-20 00:00:00
r | 0.8 | 2022-02-01 00:00:00
s | 1 | 2023-05-01 00:00:00
Spreadsheet: 64144d1265028544-progress_tracker-progress_tracker
Sheet: Sheet2

 |  |  |  | Received Date
Circle | Frequency | Due Date |  | State 1 | State 2 | State 3 | State 4 | State 5 | State 6 | State 7 | State 8 | State 9 | State 10 | State 11
Rent Mgmt Report | Weekly | 2010-02-03 00:00:00 |  | 2010-02-03 00:00:00 |  |  |  | 2010-02-19 00:00:00
Corporate Review | Monthly | 2010-02-15 00:00:00 |  | 2010-02-17 00:00:00 |  |  |  | 2010-02-19 00:00:00
BIUTR Report | Monthly | 2010-02-15 00:00:00 |  | 2010-02-18 00:00:00 |  |  |  | 2010-02-19 00:00:00
Energy Calculator | Monthly | 2010-02-10 00:00:00 |  | 2010-02-19 00:00:00 |  |  |  | 2010-02-19 00:00:00
Energy Review | Quarterly | 2010-02-10 00:00:00 |  | 2010-02-19 00:00:00 |  |  |  | 2010-02-03 00:00:00
EC Meeting | Monthly | 2010-02-10 00:00:00 |  | 2010-02-19 00:00:00 |  |  |  | 2010-02-03 00:00:00
Log Card Compliance Report | Monthly | 2010-02-15 00:00:00 |  | 2010-02-15 00:00:00 |  |  |  | 2010-02-17 00:00:00
Risk Mitigation Report | Monthly | 2010-02-20 00:00:00 |  | 2010-02-22 00:00:00 |  |  |  | 2010-02-17 00:00:00
[NAME] | Monthly | 2010-02-20 00:00:00 |  | 2010-02-22 00:00:00 |  |  |  | 2010-02-19 00:00:00
 |  |  |  | No. of Reports (Count)
 |  |  |  | State 1 | State 2 | State 3 | State 4 | State 5 | State 6 | State 7 | State 8 | State 9 | State 10 | State 11
 | On-Due Date |  |  | 2
 | Due Date + Tolerance level (2days) |  |  | 3
 | Exceed Due date |  |  | 4
I need to calculate the count of reports for each circle that sends their report on due date, exceed due date & also within the tolerance level of 2 days.
Spreadsheet: 147930d1333039358-data-validation-and-vlookup-counts
Sheet: Physical Therapist-65

Physical Therapist: | 65
Job Title | Count |  | Employed Type | Count
BS | 1 |  | Independent - Retail | 0
ccht | 1 |  | Chain - Retail | 0
cDweWuCqug | 1 |  | Hospital | 0
cpht | 3 |  | Consultant | 0
CPhT, MPT | 1 |  | Institutional - Other | 0
DPT | 2 |  | Retired | 0
DR. | 1 |  | Unemployed | 0
EdDD | 1
hlogowj | 1
LMT | 1
massagetherapist | 1
MD | 1
MD(PT), PhD, FRHS, MIMA, MICA | 1
ms. | 1
MSPT | 1
MT | 1
P.T. | 2
Ph.D. | 1
pharmacy tech | 1
Pharmacy tech R/Cert | 1
Pharmacy Technician | 2
PHarmacy Technicians | 1
Phys. Therapist | 1
Physical Therapist | 1
Physical Therapist | 1
PT | 15
PTA | 6
r.ph | 2
R.Ph. | 2
RN | 1
RPH | 5
RPT | 1
Senor | 1
TECHNICIAN | 1
WDreuDgcLy | 1
Spreadsheet: 168198d1342292030-hello-all-would-like-some-help-trying-to-match-two-rows-from-two-different-sets-of-data-sort-by-description
Sheet: Sheet1

SKU | Description | Units | Price |  | SKU | Description | Units | Price
2222 | Baseball | 200 | 1 |  | 1111 | Disc | 100 | 10
6666 | Baseball | 50 | 3 |  | 4444 | Disc Golf | 500 | 2
3333 | Basketball | 300 | 5 |  | 6666 | Home Run | 50 | 3
5555 | Basketball | 400 | 9 |  | 2222 | Hoops | 200 | 1
1111 | Frisbee | 100 | 10 |  | 5555 | Lakers | 400 | 9
4444 | Frisbee | 500 | 2 |  | 3333 | Nerf | 300 | 5
 |  |  |  |  | Hi [NAME],
 |  |  |  |  | Try this:
 |  |  |  |  | Right Click on B2 and then on SORT.
 |  |  |  |  | Then click on Sort A->Z
 |  |  |  |  | This will sort your entire table by [NAME].
 |  |  |  |  | If you want to copy and paste this (using values only)
 |  |  |  |  | to another location in you sheet it would remain sorted.
Spreadsheet: fa8d433a-3504-4b1c-9a26-2b7a868bdac2
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: |  |  | 2012-07-13 09:31:40.450000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.913 | 101.788 | 101.663 | 101.288
3.75 | 101.484 | 101.359 | 101.234 | 100.859 |  | Note: | Refer To Price [NAME]
3.625 | 101.049 | 100.924 | 100.799 | 100.424 |  |  | For all Price Adjs
3.5 | 100.464 | 100.339 | 100.214 | 99.589
3.375 | 99.578 | 99.453 | 99.328 | 98.703
3.25 | 98.621 | 98.496 | 98.371 | 97.746
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.102 | 101.977 | 101.852 | 101.477
3.25 | 101.519 | 101.394 | 101.269 | 100.894
3.125 | 101.172 | 101.047 | 100.922 | 100.547
3 | 100.862 | 100.737 | 100.612 | 100.237
2.875 | 100.255 | 100.13 | 100.005 | 99.38
2.75 | 99.612 | 99.487 | 99.362 | 98.737
 |  |  |  |  |  | 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:
 |  |  |  |  |  | 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 | 2012-07-27 09:31:40.450000
30 DAY | 2012-08-11 09:31:40.450000
45 DAY | 2012-08-26 09:31:40.450000
60 DAY | 2012-09-10 09:31:40.450000
90 DAY | 2012-10-10 09:31:40.450000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 708357d1607758480-how-can-i-add-alternate-cells-in-a-row-if-the-adjacent-column-meets-a-certain-criteria-testbook
Sheet: Sheet1

Wallet Balance
Date | Wallet | Grocery | Mode of Payment | Meds/Opd | Mode of Payment | Dine out | Mode pf Payment | Misc | Mode pf Payment | Total Cash Expenditure | Grand Total
2020-12-01 00:00:00 | 10000 | 200 | Card | 500 | Cash | 1000 | Card | 100 | Cash
2020-12-02 00:00:00 |  | 500 | Cash | 400 | PhonePe | 200 | Cash | 500 | PhonePe
2020-12-03 00:00:00
2020-12-04 00:00:00
2020-12-05 00:00:00
2020-12-06 00:00:00
2020-12-07 00:00:00
2020-12-08 00:00:00
2020-12-09 00:00:00
2020-12-10 00:00:00
2020-12-11 00:00:00
2020-12-12 00:00:00
2020-12-13 00:00:00
2020-12-14 00:00:00
2020-12-15 00:00:00
2020-12-16 00:00:00
2020-12-17 00:00:00
2020-12-18 00:00:00
2020-12-19 00:00:00
2020-12-20 00:00:00
2020-12-21 00:00:00
2020-12-22 00:00:00
2020-12-23 00:00:00
2020-12-24 00:00:00
2020-12-25 00:00:00
2020-12-26 00:00:00
2020-12-27 00:00:00
2020-12-28 00:00:00
2020-12-29 00:00:00
2020-12-30 00:00:00
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2 |  |  |  |  |  | [NAME] |  | Pecos Del |  |  |  | Imbalance
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  | Month | Measured | Scheduled | Measured | Scheduled | Imbalance | Index | Amount
1 | -57642 | -27902 | -1041 | -29999 |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -355592 | 0 | -350072 |  | 8.26
2 | -123929 | -22209 | -22574 | -122705 |  |  |  |  |  | 2001-02-01 00:00:00 | -609189 | -341536 | -52379 | -306771 |  | 5.63
3 | -123002 | -22209 | -23111 | -122705 |  |  |  |  |  | 2001-03-01 00:00:00 | -1830618 | -794902 | -918 | -1033307 |  | 5.03
4 | -130357 | -27245 |  | -102967 |  |  |  |  |  | 2001-04-01 00:00:00 | -3230259 | -1322613 |  | -2164184 |  | 4.99
5 | -69336 | -14843 |  | -53701 |  |  |  |  |  | 2001-05-01 00:00:00 | -3482702 | -2020658 | -252797 | -1732396 |  | 4.01
6 | -78158 | -13450 |  | -63506 |  |  |  |  |  | 2001-06-01 00:00:00 | -3938526 | -3382042 |  | -1643833 |  | 3.51
7 | -30604 | -4646 |  | -25100 |  |  |  |  |  | 2001-07-01 00:00:00 | -3894744 | -2543771 | -671221 | -1981645 |  | 2.94
8 | -33273 | -24646 |  | -8363 |  |  |  |  |  | 2001-08-01 00:00:00 | -4170940 | -3265860 | -1648101 | -2554228 |  | 2.85
9 | -41138 | -36201 |  | -5000 |  |  |  |  |  | 2001-09-01 00:00:00 | -3023464 | -2576525 | -92729 | -544473 |  | 1.96
10 | -41268 | -36201 |  | -5000 |  |  |  |  |  | 2001-10-01 00:00:00 | -2576641 | -1740603 | -37750 | -877765 |  | 2.15
11 | -41490 | -36201 |  | -5000 |  |  |  |  |  | 2001-11-01 00:00:00 | -2598109 | -1780898 | -233298 | -1038459 |  | 2.07
12 | -62634 | -41733 |  | -21410 |  |  |  |  |  | 2001-12-01 00:00:00 | -1166081 | -133483 |  | -1006789 |  | 2.26
13 | -95329 | -49783 |  | -45000 |  |  |  |  |  | 2002-01-01 00:00:00
14 | -69686 | -42233 |  | -27023
15 | -34928 | -29581 |  | -5000
16 | -29458 | -24385 |  | -5000
17 | -29186 | -24385 |  | -5000
18 | -29659 | -24385 |  | -5000 |  |  |  |  |  |  |  |  |  |  |  |  | -591014.35
19 | -44850 | -39321 |  | -4836
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2002-02-28 00:00:00 |  |  | 83533.44
 |  |  |  | 2002-03-19 00:00:00
 | CBS Volume
 |  |  |  | 67681
 |  |  |  |  |  |  | 179468
 |  |  |  |  |  |  | 82546
Spreadsheet: 749110d1632507157-indexmatch-with-multiple-criteria-and-columns-indexmatch-with-multiple-criteria
Sheet: Sheet1

How to return a value from more than one criteria
Status | IT Customer # | Casino Client | # Reps | Rep(s) | Rep 1 | Helper | % | Rep 2 | Helper | % | Rep 3 | Helper | % | Rep 4 | Helper | % | Rep 5 | Helper | %
Active | 13057 | ABC Company | 5 | Peggy Jones/Autumn Kennedy/Brett Marker/[NAME][NAME] | [NAME] | 1 | 0.05 | Autumn [NAME] | 1 | 0.03 | [NAME] | 1 | 0.1 | [NAME] Son | 1 | 0.06 | [NAME] | 1 | 0.07
Inactive | 18841 | DEF Company | 5 | [NAME]/[NAME]/[NAME]Suzy Rutledge | [NAME] | 1 | 0.02 | [NAME] | 1 | 0.08 | [NAME] | 1 | 0.05 | [NAME] | 1 | 0.04 | [NAME] | 1 | 0.08
Inactive | 10202 | GHI Company | 5 | Peggy Jones/Autumn Kennedy/Brett Marker/[NAME][NAME] | [NAME] | 1 | 0.03 | Autumn [NAME] | 1 | 0.01 | [NAME] | 1 | 0.03 | [NAME] Son | 1 | 0.02 | [NAME] | 1 | 0.06
Inactive | 10756 | KLM Company | 5 | [NAME]/[NAME]/[NAME]Suzy Rutledge | [NAME] | 1 | 0.06 | [NAME] | 1 | 0.02 | [NAME] | 1 | 0.01 | [NAME] | 1 | 0.09 | [NAME] | 1 | 0.03
Inactive | 11420 | NOP Company | 5 | Peggy Jones/Autumn Kennedy/Brett Marker/[NAME][NAME] | [NAME] | 1 | 0.05 | Autumn [NAME] | 1 | 0.03 | [NAME] | 1 | 0.1 | [NAME] Son | 1 | 0.06 | [NAME] | 1 | 0.07
Inactive | 11195 | QRS Company | 5 | [NAME]/[NAME]/[NAME]Suzy Rutledge | [NAME] | 1 | 0.02 | [NAME] | 1 | 0.08 | [NAME] | 1 | 0.05 | [NAME] | 1 | 0.04 | [NAME] | 1 | 0.08
Inactive | 56324 | TUV Company | 5 | Peggy Jones/Autumn Kennedy/Brett Marker/[NAME][NAME] | [NAME] | 1 | 0.03 | Autumn [NAME] | 1 | 0.01 | [NAME] | 1 | 0.03 | [NAME] Son | 1 | 0.02 | [NAME] | 1 | 0.09
Inactive | 96478 | WXYZ Company | 5 | [NAME]/[NAME]/[NAME]Suzy Rutledge | [NAME] | 1 | 0.06 | [NAME] | 1 | 0.02 | [NAME] | 1 | 0.01 | [NAME] | 1 | 0.09 | [NAME] | 1 | 0.03
 | Lookup % using indexmatch from the list above based on Rep Name and Client, then and insert the reps corresponding % in column D below highlighted in yellow
 | Rep | Client | % | Comments
 | [NAME] | KLM Company |  | Should be 6%
 | [NAME] | NOP Company |  | Should be 10%
 | [NAME] | TUV Company |  | Should be 9%
Spreadsheet: 120371d1315243153-latitude-and-longitude-to-eastings-and-northings-projectionandtransformationcalculations
Sheet: local & line sf from E,N

Local scale factor from Easting and Northing
Easting | 651409.903 |  |  |  |  | This is the input data
Northing | 313177.27
factor | 1.000377315460587 |  |  |  |  | This is the result of the calculation
 | ° | ' | " | [NAME] | Radians | These values are intermediate calculation steps
j' | 52 | 42 | 57.27844507529517 | 52.71591067918758 | 0.9200662095390635
n | 6388523.341478047 |  |  |  |  | The radians value of j' is computed using a user defined function
r | 6372819.309368817 |  |  |  |  | To see the Visual Basic code of the function -
h2 | 0.00246422051950268 |  |  |  |  | Menu = Tools, Macro, Visual Basic Editor,
XXI | 1.228111826258791e-14 |  |  |  |  | then view the code in "Module 1".
XXII | 2.538542309216239e-29
factor | 1.000377315460587 |  |  |  |  | This is the result of the calculation using a user defined function.
 |  |  |  |  |  | To see the Visual Basic code of the function -
 |  |  |  |  |  | Menu = Tools, Macro, Visual Basic Editor,
 |  |  |  |  |  | then view the code in "Module 1".
Notes
Local scale factor is the scale distortion inherent in the map projection at a point
For a long line the scale factor at the mid point should be calculated. For lines up to 30km in length this will give a result with an error not exceeding 1 to 2 ppm.
If still greater accuracy is required compute a line scale factor using Simpson's Rule as shown below.
The line scale factor between Point 1 (East1, North1) and Point 2 (East2, North2)
is the projected distance between the points divided by the true (geodesic) distance.
Line scale factor = (1/6)(F1 + 4Fm + F2)
Where F1 = scale factor at Point 1; F2 = scale factor at Point 2 and  Fm = scale factor at mid point between Point 1 and Point 2.
e.g.: - | 1.000377315460587
 | 1.000229694590194
 | 1.000301559824402
 | 1.000302208224731
Spreadsheet: 727108d1617720191-multi-tier-dependant-drop-down-school-condition-survey-template
Sheet: Template

7.00     SCHEDULE OF CONDITION
 | Condition grade | Definition |  | Summary
 | A   Good | Performing as intended |  | A
 | B   Satisfactory | Minor deterioration |  | B
 | C   Poor | Major defects |  | C
 | D   Bad | Life-expired |  | D
 | Priority rating | Definition
 | 4 | 5+ years |  | 4
 | 3 | 3-5 years |  | 3
 | 2 | 1-2 year |  | 2
 | 1 | Immediate |  | 1
Element | Sub element | Construction | Description | Condition grade | Priority rating | Comments | Unit | Quantity | Rate | Cost
Spreadsheet: 770432d1646064201-looking-for-help-on-graphically-showing-proportions-weighting-issue-weighted-avg
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod A | Prod B | Prod C | Prod D |  | Total
 | Q1 '21 Target | 0.8799999999999978 | Units |  | Units % | Gap % |  |  |  |  |  |  |  | Units | 439
 | Product A | -0.01692223198679977 | 439 |  |  |  |  |  |  |  |  |  |  | Hrs Per Unit | 100 | 100 | 100 | 100 |  | 100
 | Product B | 0.002045207892753737 | 9 |  |  |  |  |  |  |  |  |  |  | Total Capacity
 | Product C | -0.00997207758372228 | 16 |  |  |  | This is the problem - the gap of 32% is contributed by 3% of units |  |  |  |  |  |  | Target | 0.88 | 0.88 | 0.88 | 0.88 |  | 0.88
 | Product D | -0.005979919462883605 | 60
 | Q1 '21 Actual | 0.8491709788593549 |  |  |  |  |  |  |  |  |  |  |  | Target = Capacity @ 88%
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual - Delivered | 37741.2 | 886.3086263506603 | 883.9999999999998 | 4965.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Delivered %
 |  |  |  |  |  |  |  |  |  |  |  |  |  | GAP to Target (n)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | GAP to Target (%)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Proportion Gap %
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Proportion Units %
 |  |  |  |  |  |  |  |  |  | This is the Bridge - ie what Products drove the Gap to 88% |  |  |  | Target | 0.88
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod D
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual
Spreadsheet: 543867d1508627045-sub-total-how-to-get-customer-name-and-other-text-columns-subtotal_question
Sheet: Sub Total

Customer | Customer Name | Rep | Region | Invoice | Invoice Date | Invoice Balance | Past due
200060 | Customer 1 | MS | NA | 1600000391 | 2017-06-30 00:00:00 | 235.08 | 0
200060 | Customer 1 | MS | NA | 1600000420 | 2017-07-31 00:00:00 | 530.14 | 0
200060 | Customer 1 | MS | NA |  |  | 113639.72 | 0
200065 | Customer 2 | KS | CA | 97022624 | 2017-10-04 00:00:00 | 3575.72 | 3575.72
200065 | Customer 2 | KS | CA |  |  | 3575.72 | 3575.72
200069 | Customer 3 | DV | EA | 1400001036 | 2015-12-12 00:00:00 | -7418.46 | 0
200069 | Customer 3 | DV | EA | 1400001530 | 2016-06-15 00:00:00 | -1097.46 | 0
200069 | Customer 3 | DV | EA | 97022046 | 2017-09-18 00:00:00 | 185715 | 185715
200069 | Customer 3 | DV | EA | 97022047 | 2017-09-18 00:00:00 | 715016.88 | 715016.88
200069 | Customer 3 | DV | EA | 97022049 | 2017-09-18 00:00:00 | 206990.83 | 206990.83
200069 | Customer 3 | DV | EA | 97022051 | 2017-09-18 00:00:00 | 1360.28 | 1360.28
200069 | Customer 3 | DV | EA | 97022054 | 2017-09-18 00:00:00 | 36592.98 | 36592.98
200069 | Customer 3 | DV | EA | 97022080 | 2017-09-19 00:00:00 | 1784.16 | 1784.16
200069 | Customer 3 | DV | EA | 97022810 | 2017-10-13 00:00:00 | 1489.51 | 1489.51
200069 | Customer 3 | DV | EA | 97022897 | 2017-10-17 00:00:00 | 185715 | 185715
200069 | Customer 3 | DV | EA | 97022898 | 2017-10-17 00:00:00 | 715016.88 | 715016.88
200069 | Customer 3 | DV | EA | 97022899 | 2017-10-17 00:00:00 | 206990.83 | 206990.83
200069 | Customer 3 | DV | EA | 97022900 | 2017-10-17 00:00:00 | 51868.36 | 51868.36
200069 | Customer 3 | DV | EA |  |  | 2300024.79 | 2308540.71
Spreadsheet: 25523b92-66e5-4ddd-a1fc-b7ca9901b8bf
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
FET | Test | FET | Iron, Liver Tissue | Iron, [NAME] | Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) | Metal-free specimen vial (blue label) for tissue metal collections: MFSV |  |  | 2 | mg | Container/Tube: Preferred: Mayo metal-free specimen vial (blue label) (Supply T173) Acceptable: Paraffin block, if not more than 1 or 2 cuts have been made to it for slides. [NAME]: 2 mg Collection Instructions: 1. Two mg of liver tissue is required. This is typically a piece of tissue from a 22-gauge needle biopsy at least 2 cm long. If an 18-gauge needle is used, the tissue must be at least 1 cm in length. 2. Any specimen vial other than a Mayo metal-free vial used should be plastic, leached with 10% nitric acid for 2 days, rinsed with redistilled water, and dried in clean air. Additional Information: 1. Patient's date of birth is required to calculate iron index. 2. If tissue is other than liver tissue, see [NAME]. 3. Paraffin blocks will be returned 3 days after analysis. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 2 cm (22-gauge needle), 1 cm (18 | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | IRON Males: 200-2,400 mcg/g dry weight Females: 400-1,600 mcg/g dry weight  IRON INDEX Reference values have not been established for patients that are <13 years of age. <1.0 mcmol/g/year (> or =13 years) | Monday through Friday; 11 a.m. | 2 days/ 3 days if repeat testing required | 5 days | 1 | 83540 |  |  |  |  | Rochester
FET | [NAME] | [NAME] | [NAME] |  |  |  | Refrigerated
FET | Result | 8350 | Iron, [NAME] | Iron, [NAME] | Numeric |  |  |  |  | mcg/g dry wt |  |  |  |  |  |  |  |  |  | 15357-7
FET | Result | 7770 | Hepatic Iron Index | Hepatic Iron Index | Numeric |  |  |  |  | mcmol/g/yr |  |  |  |  |  |  |  |  |  | 49061-5
Spreadsheet: 687185d1595011925-if-formula-for-several-date-ranges-accrual-date-range
Sheet: Sheet1

 | £ | Accrual Date | Accrual Date Category |  | PO Accrual > 18 Months | 2018-12-31 00:00:00
 | 0 | 2017-01-01 00:00:00 |  |  | PO Accrual > 15 Months < 18 Months | 2019-01-01 00:00:00 | 2019-03-31 00:00:00
 | 1 | 2019-03-01 00:00:00 |  |  | PO Accrual > 12 Months < 15 Months | 2019-04-01 00:00:00 | 2019-06-30 00:00:00
 | 1 | 2019-03-30 00:00:00 |  |  | PO Accrual < 12 Months | 2019-07-01 00:00:00
 | 1 | 2019-04-02 00:00:00
 | 1 | 2019-05-30 00:00:00
 | 1 | 2019-06-30 00:00:00