tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 455422d1460338303-help-with-a-formula-to-give-multiple-answers-bank-statement-example
Sheet: Sheet1

 |  | STATEMENT |  |  |  |  | ADD ON
 |  | DATE | [NAME] | AMOUNT | BALANCE |  | TYPE | CATEGORY
 |  | 2016-04-15 00:00:00 | DIRECT CREDIT   X SALARY | 805 | 1208.3 |  |  | [NAME]
 |  | 2016-04-15 00:00:00 | VISA PURCHASE   DONS COFFEE SHOP EAST HATFIELD | -14.3 | 1194 |  |  | CARD PUCHASE
 |  | 2016-04-15 00:00:00 | VISA PURCHASE   VOOM CHEMIST CENTRAL STATION | -60.43 | 1133.57 |  |  | CARD PUCHASE
 |  | 2016-04-15 00:00:00 | INTERNET TRANSFER  FROM 111111110 REF NO 22222222 | -49.8 | 1083.77 |  |  | TRANSFER
 |  | 2016-04-15 00:00:00 | VISA PURCHASE   SUPERMARKET | -116.65 | 967.12 |  |  | CARD PURCHASE
 |  | 2016-04-15 00:00:00 | INTERNET TRANSFER CREDIT FROM 123123 | 200 | 1167.12 |  |  | INTERNET PURCHASE
 |  | 2016-04-15 00:00:00 | EFTPOS WDL  GENERAL STORE GREYFORD | -67.5 | 1099.62 |  |  | EFT PURCHASE
 |  | 2016-04-14 00:00:00 | DIRECT DEBIT   GVC NO [PHONE] | -85.4 | 1014.22 |  |  | GVC
 |  | 2016-04-12 00:00:00 | ATM OPERATOR FEE WITHDRAWAL | -1 | 1013.22 |  |  | FEE
 |  | 2016-04-12 00:00:00 | [NAME] | -150 | 863.2199999999999 |  |  | MONEY WDL
 |  | 2016-04-12 00:00:00 | [NAME]9997999 | -320 | 543.2199999999999 |  |  | CAR LOAN
 |  | 2016-04-12 00:00:00 | DIRECT DEBIT    HEALTH FUND 7877878 | -120 | 423.2199999999999 |  |  | HEALTH FUND
 |  |  | The above statement is what I get in Excel form from my bank
 |  |  | it has date description amount and balance like above
 |  |  | Column H I have added in a function to determine the type of transaction
 |  |  | what I also want is column I to categorize the descriptions so I can put them in another table
 |  |  | can someone help me with this formula or do I need a VBA for it!
 |  |  | I have very little knowledge of VBA's
Spreadsheet: 801403d1666187954-data-retrieval-from-multiple-sheets-for-multiple-variables-excel-file
Sheet: 2330300

 |  |  | Text | Tr.Prt | Clearing | Pstng Date | Doc. Date | Amount in local cur. | LCurr | Amount in doc. curr. | Curr. |  | Deals | Amount in doc currency
 |  |  | MM CXFLTL 8833 Start |  |  | 2020-06-26 00:00:00 | 2020-06-30 00:00:00 |  |  | -30000000 | USD
 |  |  | Val |  |  | 2022-08-31 00:00:00 | 2022-08-31 00:00:00 |  |  | 0 | USD
 |  |  | Val |  |  | 2022-09-30 00:00:00 | 2022-09-30 00:00:00 |  |  | 0 | USD
Spreadsheet: 440230d1452703184-vacation-tracking-from-an-anniversary-date-from-year-to-year-vacation-tracking-2015
Sheet: December

Employee Absence Schedule
December | Dates of Absence
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total Hours
A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
G |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
Spreadsheet: 692041d1598024069-complex-addition-different-activities-on-different-dates-adding-to-total-teste-rota
Sheet: Sheet1

Session type | Doctor
Theater | 3
Endoscopy | 4
Clinic | 2
Ward round | 7
Management | 3
Annual Leave
Study Leave
Other leave | 1
Date
2020-08-24 00:00:00 | T | T
2020-08-25 00:00:00 | E | E
2020-08-26 00:00:00 | E | T
2020-08-27 00:00:00 | W | W
2020-08-28 00:00:00 | W | O
2020-08-29 00:00:00
2020-08-30 00:00:00
2020-08-31 00:00:00 | C | C
2020-09-01 00:00:00 | W | M
2020-09-02 00:00:00 | W | M
2020-09-03 00:00:00 | W | M
2020-09-04 00:00:00 | W | E
2020-09-05 00:00:00
2020-09-06 00:00:00
Spreadsheet: 058d442e-1ed8-4b06-9762-fe685a632d9e
Sheet: Sheet1

Unnamed: 0 | MINISTÈRE DE LA CULTURE ET DE LA COMMUNICATION | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | DIRECTION DES ARCHIVES DE FRANCE
 | Département du réseau institutionnel et professionnel
 | Bureau du réseau et de la politique territoriale
 | 56 rue des Francs-Bourgeois
 | 75 141 Paris Cedex 03
 | Tel : 01.40.27.67.15
 | [NAME]
 | sur l’activité des services d’archives contrôlés
 |  | COMMUNE
 | 2008
Commune :
Département :
Population :
Structure intercommunale (oui / non ) :
Si "oui", [NAME] structure :
Chef de service (NOM, Prénom) :
[NAME] (A /B ou C):
[NAME] :
 |  | A retourner au plus tard  le 27 février 2009 à l'adresse courriel suivante :
 |  | [EMAIL]
Spreadsheet: michelle_lokay__26566__imbalsumm0012
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1 | 17996 | 25998
2 | 27242 | 40000
3 | 30344 | 39999
4 | 29336 | 38306
5 | 23080
6 | 31559 | 38450
7 | 30721 | 31076
8 | 25834 | 26000
9 | 26005 | 26000
10 | 25879 | 26000
11 | 27732 | 26000
12 | 33840 | 26000
13 | 28685 | 29986
14 | 30565 | 35963
15 | 24896 | 25999
16 | 24310 | 26000
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  | -557795.86
2000-12-16 00:00:00
Spreadsheet: 763324d1642101056-wanting-to-highlight-out-of-specification-cells-in-excel-based-different-specifications-index-match-formulas-for-conditional-fomatting-celtic1888-1
Sheet: Demo

Date | Time | Customer | Density | Absorption (W) | Absorption (O) | Moisture | <0,5 | 0.5 - 1.0 | 1.00-2.00 | 2.0 - 2.8 | 2.8 - 4.0 | 4.0 - 5.6 | 5.6 - 6.7 | 6.7 - 10 |  |  |  |  |  |  | Date | Time | Density 1 | Density 2 | Average |  | Cone 1 | +Sample 1 | Cone 2 | +Sample 2 | Cone 3 | +Sample 3 | +Water 1 | +Water 2 | +Water 3 | Result |  |  |  | Cone 1 | +Sample 1 | Cone 2 | +Sample 2 | Cone 3 | +Sample 3 | +Water 1 | +Water 2 | +Water 3 | Result |  |  |  | Moisture
 |  |  | G/L | % | % | % | % | % | % | % | % | % | % | %
2021-01-01 00:00:00 | 15:00:00 | Ford |  |  |  |  | 12.2 | 10 | 16 | 15 | 22 | 10.8 | 12 | 2 |  |  |  |  |  |  |  |  | 750 | 745 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 80 | 80 | 80 |  |  |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 70 | 65 | 60 |  |  |  |  | 5.5
2021-01-01 00:00:00 | 15:00:00 | Renault |  |  |  |  | 5.2 | 10 | 16 | 15 | 22 | 17.8 | 12 | 2 |  |  |  |  |  |  |  |  | 800 | 800 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 70 | 70 | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.5
2021-01-01 00:00:00 | 15:00:00 | Volvo |  |  |  |  | 11.2 | 10 | 10 | 15 | 22 | 17.8 | 12.5 | 1.5 |  |  |  |  |  |  |  |  | 300 | 300 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 80 | 80 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.5
2021-01-01 00:00:00 | 15:00:00 | Tesla |  |  |  |  | 6.2 | 15 | 10 | 15 | 22 | 17.8 | 12.5 | 1.5 |  |  |  |  |  |  |  |  | 900 | 900 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 80 | 80 | 80 |  |  |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 65 | 65 | 50 |  |  |  |  | 12
2021-01-01 00:00:00 | 15:00:00 | Spar |  |  |  |  | 11.2 | 10 | 10 | 15 | 22 | 17.8 | 12.5 | 1.5 |  |  |  |  |  |  |  |  | 900 | 900 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 80 | 80 | 80 |  |  |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 65 | 65 | 50 |  |  |  |  | 16
2022-01-02 00:00:00 | 18:00:00 | ford |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 900 | 900
2022-01-02 00:00:00 | 0.75 | ford |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 700 | 700
2022-01-02 00:00:00 | 0.75 | ford
2022-01-02 00:00:00 | 0.75 | ford
2022-01-02 00:00:00 | 0.75 | ford
Spreadsheet: 473853d1470433983-how-to-search-filter-data-by-from-other-sheets-ef949_syllabus-book
Sheet: Sheet1

FILTER TITLE | FILTER VALUE
Department
Level
Term
Subject
Subject Code
[NAME]
Credit Hour | 2
Contact Hour | 2
Course Content:
Course Content:
Course Content:
Course Content:
Course Content:
Course Content:
Course Content:
Course Content:
Course Content:
Course Content:
Course Content:
Course Content:
Spreadsheet: 721848d1614893977-if-formula-based-on-text-selection-of-another-cell-interview-grid-ddi-level-competency-selection
Sheet: Interview Grid

 |  |  |  | Interview Summary
 |  |  |  | Candidate Name :
 |  |  |  |  |  |  |  | Recruiter A | Hiring Manager A | Hiring Manager B | Global Rating
 |  |  |  | Communication
 |  |  |  | Organizational Fit
INTERVIEW GRID
TARGETED SELECTION
 |  |  |  | Comments :
Planned Behavioral Questions
 | Question 1
Score
Situation/Task |  | Action | Result
 | Question 2
Score
Situation/Task |  | Action | Result
 | Question 3
Score
Situation/Task |  | Action | Result
 | Question 4
Score
Situation/Task |  | Action | Result
 | Question 5
Score
Situation/Task |  | Action | Result
 | Question 6
Score
Situation/Task |  | Action | Result
 | Question 7
Score
Situation/Task |  | Action | Result
 | Question 8
Score
Situation/Task |  | Action | Result
 | Question 9
Score
Situation/Task |  | Action | Result
 | Question 10
Score
Situation/Task |  | Action | Result
 | Question 11
Score
Situation/Task |  | Action | Result
 | Question 12
Score
Situation/Task |  | Action | Result
 | Question 13
Score
Situation/Task |  | Action | Result
 | Question 14
Score
Situation/Task |  | Action | Result
 | Question 15
Score
Situation/Task |  | Action | Result
 | Question 16
Score
Situation/Task |  | Action | Result
 | Question 17
Score
Situation/Task |  | Action | Result
 | Question 18
Score
Situation/Task |  | Action | Result
Guiding Principles
 | Question 19
Score
Situation/Task |  | Action | Result
 | Question 20
Score
Situation/Task |  | Action | Result
 | Question 21
Score
Situation/Task |  | Action | Result
 | Question 22
Score
Situation/Task |  | Action | Result
 | Question 23
Score
Situation/Task |  | Action | Result
 | Question 24
Score
Situation/Task |  | Action | Result
 | Question 25
Score
Situation/Task |  | Action | Result
 | Question 26
Score
Situation/Task |  | Action | Result
Spreadsheet: 151285d1334851368-how-to-calculate-time-passed-during-business-hours-time-shet
Sheet: Sheet3

 | Working Hours | Starting Time | 08:30:00 | 8 | 30
 |  | Leaving Time | 17:00:00 | 17 | 0
 | VM Left |  |  | Hide |  |  | VM Returned |  |  | Hide |  |  | Time Lapsed
 | Hour | Minute | AM/PM | String | Hours | Minutes | Hour | Minute | AM/PM | String | Value | Minutes
 | 9 | 00 | AM | 9:00:00 AM | 9 | 0 | 4 | 00 | PM | 4:00:00 PM | 16 | 0 | 7
Spreadsheet: 38516d1236687050-multi-conditional-average-example8
Sheet: 10 Mar09

Type | Item # | Lead Time | Result
Bag | D7530 | 19 | On Time | #N/A
Sack | AUV0002VW | 6 | On Time
Sack | AUV0002VW | 9 | On Time
Sack | TRW0001VP-T | 0 | On Time
Sack | TRW0001VP | 0 | On Time
Sack | AUV0003VW | 37 | On Time
Bag | ADB0016VF | 0 | On Time
Sack | RIV0008VF | -4 | Late
Sack | WST0014VF | -32 | Late
Sack | ADB0017VF | -33 | Late
Bag | FUR0002VS | 59 | On Time
Sack | FUR0003VS | 4 | On Time
Sack | FUR0003VS-U | 13 | On Time
Sack | REA0001OM | 0 | On Time
Bag | [NAME] | 8 | On Time
Bag | LAU0008OM | -3 | Late
Bag | MIN0003VF | -10 | Late
Bag | MIN0005VF | -7 | Late
Bag | RIV0002VF | 0 | On Time
Sack | MUD0022VF | -23 | Late
Sack | RIV0045VF | -1 | Late
Sack | WST0015VF | -14 | Late
Sack | RIV0046VF | 0 | On Time
Bag | RIV0009VF | 19 | On Time
Spreadsheet: 850400d1700746400-optimize-consecutive-formula-for-integer-numbers-consecutive-integer-numbers-solved
Sheet: Sheet1

Reward | AGGREGATE
NO
2
4
NO
NO
NO
2
NO
NO
4
2
3
2
2
NO
Spreadsheet: 680919d1591255252-adding-a-formula-with-relative-cell-address-to-data-cells-quickly-excel-forum-case-1-1-
Sheet: Sheet1

 |  |  |  |  | % of original
 | July | Aug | Sep |  | July | Aug | Sep
Expense budget |  | 1000 | 1500 |  | 0.5 | 0.3 | 0.2
 | 600 | 900 | 400
 | 700 | 750 | 1500
 | 720 | 1100 | 1000
 | 350 | 800 | 1200
 | 200 |  | 1350
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
Spreadsheet: 545308d1509395040-variable-list-depending-on-the-value-of-one-column-expected-outcome
Sheet: Expected Output

 | Data Source |  |  |  |  |  | Expected Outcome
 | Cost Center | Family Code |  |  |  |  | Cost Center | Family Code choice |  |  |  |  | 100
 |  |  |  |  |  |  | CCI | 300 |  |  |  |  | 200
 | CCI | 400;300 |  |  |  |  | PROCESS | 300 |  |  |  |  | 300 | 400
 | PROCESS | 100;300;500 |  |  |  |  | TOOLS | 100 |  |  |  |  | 100 | 300 | 500
 | TOOLS | 100 |  |  |  |  | ACI | 200
 | ACI | 200 |  |  |  |  | AGIF | 100
 | AGIF | 100
Spreadsheet: 3d5c0e29-2dc6-4c18-995b-c9e0e93a847a
Sheet: Sheet1

Unnamed: 0 | 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 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30
 | GridPP3 Goal
 | To provide UK computing for the Large Hadron Collider
 |  |  | K |  | 1.1 |  | I |  | K |  | 1.2 |  | I |  |  | K |  | 1.3 |  | I |  | K |  | 1.4 |  | I
 |  |  | ATLAS |  |  |  |  |  | LHCb |  |  |  |  |  |  | CMS |  |  |  |  |  | Other experiments
 | H | 2 |  |  |  |  | H | 3 |  |  |  |  | H | 4 |  |  |  |  | H | 5 |  |  |  |  | H | 6
 | Grid services |  |  |  |  |  | Tier-1 |  |  |  |  |  | Tier-2 |  |  |  |  |  | Management |  |  |  |  |  | External
 |  | K |  | 2.1 |  | I |  | K |  | 3.1 |  | I |  | K |  | 4.1 |  | I |  | K |  | 5.1 |  | I |  | K |  | 6.1 |  | I
 |  | Operations |  |  |  |  |  | Front end systems |  |  |  |  |  | NorthGrid |  |  |  |  |  | Planning |  |  |  |  |  | Outreach &
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | engagement
 |  | K |  | 2.2 |  | I |  | K |  | 3.2 |  | I |  | K |  | 4.199999999999999 |  | I |  | K |  | 5.199999999999999 |  | I |  | K |  | 6.199999999999999 |  | I
 |  | Security |  |  |  |  |  | Resource delivery |  |  |  |  |  | SouthGrid |  |  |  |  |  | Deployment |  |  |  |  |  | National Grid
 |  |  |  |  |  |  |  | & tracking |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Infrastructure
 |  | K |  | 2.3 |  | I |  | K |  | 3.3 |  | I |  | K |  | 4.299999999999999 |  | I |  |  |  |  |  |  |  | K |  | 6.299999999999999 |  | I
 |  | Network |  |  |  |  |  | Hardware procurement |  |  |  |  |  | ScotGrid |  |  |  |  |  |  |  |  |  |  |  | LCG
 |  |  |  |  |  |  |  | & deployment
 |  | K |  | 2.4 |  | I |  | K |  | 3.4 |  | I |  | K |  | 4.399999999999999 |  | I |  |  |  |  |  |  |  | K |  | 6.399999999999999 |  | I
 |  | Data and storage |  |  |  |  |  | Storage systems |  |  |  |  |  | London |  |  |  |  |  |  |  |  |  |  |  | EGEE
 |  | management
 |  | K |  | 2.5 |  | I |  |  |  |  |  |  |  | K |  | 0.1 |  | I
 |  | Middleware |  |  |  |  |  |  |  |  |  |  |  | GridPP2+ |  |  |  |  |  |  |  |  | Navigate down |  |  |  | K
 |  | support |  |  |  |  |  |  |  |  |  |  |  | transition |  |  |  |  |  |  |  |  | External link |  |  |  | I
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Link to goals |  |  |  | H
Spreadsheet: bee1b971-864b-46ac-a2f6-2ba5aff7cba8
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2005-06 |  |  | FY 2006-07
 | General Fund |  |  |  | 300000
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ | 300000 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
 | The additional revenues provided by this ordinance will go towards the maintenance of Land Trust lots located throughout the city of Kansas City, Missouri.
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2005-06 |  |  | FY 2006-07
 | General Fund |  |  |  | 300000
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ | 300000 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
 | The additional appropriations provided by this ordinance will go towards the maintenance of Land Trust lots located throughout the city of Kansas City, Missouri.
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 675553d1588352687-using-index-match-and-if-function-2020-sales-sheet-v10
Sheet: Delivery Charges

Delivery charges |  | ZONE
No. of kilos |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | 1 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 25 | 40 | 50 | 130
2 | 2 | 13.27 | 17.14 | 19.1 | 19.1 | 23.34 | 25 | 36.23 | 51.75 | 72.45 | 134.55
3 | 3 | 14.95 | 17.4 | 19.34 | 20.24 | 29.27 | 37.5 | 37.64 | 57.5 | 72.45 | 134.55
4 | 6 | 16.73 | 19.66 | 21.85 | 22.58 | 31.37 | 39.73 | 47.05 | 67.28 | 72.45 | 165.6
7 | 10 | 21.93 | 24.57 | 27.31 | 28.23 | 36.38 | 45.43 | 50.57 | 67.62 | 72.82 | 166.43
11 | 15 | 27.13 | 29.48 | 32.78 | 33.87 | 41.4 | 51.12 | 54.1 | 67.95 | 73.18 | 167.26
16 | 20 | 32.91 | 35.76 | 39.75 | 41.08 | 53.49 | 66.05 | 69.49 | 87.01 | 93.52 | 181.96
21 | 25 | 38.68 | 42.03 | 46.73 | 48.29 | 65.58 | 80.98 | 84.87 | 106.07 | 113.85 | 190
26 | 35 | 44.05 | 47.87 | 53.22 | 55 | 67.22 | 83.01 | 87 | 108.72 | 116.7 | 190
36 | 45 | 51.24 | 57.76 | 64.28 | 68.94 | 93.1 | 120 | 130 | 150 | 160 | 190
46 | 56 | 57.5 | 64.82 | 72.13 | 77.36 | 97.33 | 125.45 | 135.9 | 156.81 | 167.26 | 198.62
57 | 112 | 82.46 | 91.64 | 101.95 | 107.81 | 146.85 | 186.45 | 199.96 | 237.42 | 253.94 | 371.04
113 | 168 | 132.61 | 137.92 | 159.14 | 175.05 | 212.18 | 222.79 | 371.31 | 403.14 | 424.35 | 450.88
169 | 224 | 148.53 | 164.44 | 175.05 | 190.96 | 254.61 | 281.14 | 477.4 | 525.14 | 541.05 | 583.49
225 | 280 | 164.44 | 185.66 | 190.96 | 201.57 | 307.66 | 339.48 | 583.49 | 636.53 | 668.36 | 716.1
281 | 336 | 185.66 | 190.96 | 196.27 | 212.18 | 350.09 | 381.92 | 663.05 | 694.88 | 742.62 | 795.66
337 | 392 | 190.96 | 201.57 | 212.18 | 238.7 | 392.53 | 430.72 | 689.57 | 742.62 | 795.66 | 848.7
393 | 448 | 206.88 | 233.4 | 244.01 | 286.44 | 424.35 | 466.79 | 742.62 | 769.14 | 822.18 | 875.23
449 | 504 | 228.09 | 259.92 | 270.53 | 318.27 | 456.18 | 498.62 | 769.14 | 795.66 | 848.7 | 901.75
505 | 560 | 249.31 | 286.44 | 297.05 | 350.09 | 477.4 | 530.44 | 795.66 | 838.1 | 891.14 | 944.18
561 | 616 | 265.22 | 312.96 | 323.57 | 381.92 | 503.92 | 562.27 | 827.49 | 869.92 | 938.88 | 1103.31
617 | 672 | 286.44 | 339.48 | 350.09 | 413.75 | 530.44 | 594.09 | 859.31 | 901.75 | 1018.44 | 1156.36
673 | 728 | 307.66 | 366.01 | 376.62 | 445.57 | 556.96 | 625.92 | 922.97 | 976.01 | 1092.71 | 1251.84
729 | 784 | 328.88 | 381.92 | 403.14 | 509.22 | 583.49 | 657.75 | 976.01 | 1039.66 | 1166.97 | 1347.32
785 | 840 | 339.48 | 392.53 | 413.75 | 509.22 | 610.01 | 689.57 | 1007.84 | 1060.88 | 1273.05 | 1368.53
841 | 896 | 344.79 | 392.53 | 419.05 | 509.22 | 636.53 | 721.4 | 1034.36 | 1166.97 | 1379.14 | 1395.06
897 | Full | 344.79 | 392.53 | 419.05 | 509.22 | 663.05 | 753.23 | 1060.88 | 1273.05 | 1432.19 | 1909.58
Spreadsheet: 109001d1305909764-sumifs-with-criteria-that-has-different-size-ranges-m-and-i-breakout
Sheet: Sheet1

 |  | Actaul | Actaul | Actaul | Actual | Actual | Projection | Projection | Projection | Projection | Projection | Projection | Projection | Total |  | Total | Plan |  | Actual | YTD | 5 | Actaul | Period | 5
Orgs |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total |  | M | I |  | M | I |  | M | I
M |  | 100
I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Split total plan |  |  | Split YTD Actuals |  |  | Split Current Period
M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | between M & I |  |  | between M & I |  |  | Actuals between M
M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | & I
M
I
M
I
M
I
I
M
M
Spreadsheet: 8e8f77d4-124e-4a32-a557-0a6f0414e779
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
[NAME] | Test | [NAME] | Beta-Galactosidase, Blood | Beta-Galactosidase, B | Fluorometric Enzyme Assay | EDTA (lavender-top) tube: EDTA |  |  | 2 | mL | Container/Tube:  Preferred: Lavender top (EDTA) Acceptable: Yellow top (ACD) [NAME]: 2 mL Additional Information: Provide a reason for referral with each specimen. Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 0.5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | > or =5.0 nmol/h/mL An interpretive report will be provided. | Friday; morning | 8 days | 15 days | 1 | 82657 |  |  |  |  | Rochester
[NAME] | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 7 days
[NAME] | Result | 60987 | Beta-Galactosidase, B | Beta-Galactosidase, B | Numeric |  |  |  |  | nmol/h/mL |  |  |  |  |  |  |  |  |  | 16454-1 | Beta galactosidase:CCnc:Pt:[NAME]:Qn:
[NAME] | Result | 34428 | Interpretation | Interpretation | Alphanumeric
[NAME] | Result | 34427 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
[NAME] | Result | 34432 | Reviewed By | Reviewed By | Numeric