tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 140488d1328778148-excel-2007-getting-price-to-autofill-after-picking-product-from-dropdown-list-0135
Sheet: Com IVA

 |  |  |  | Div
 |  |  |  | Inox
 |  |  |  | [NAME] |  |  |  |  |  | 0
 |  |  |  | PVC |  | Cliente
 |  |  |  |  |  |  |  |  |  |  |  | The problem is here
 |  |  |  |  |  |  |  | DATA | 2012-02-03 00:00:00
 |  |  |  |  |  |  |  |  | Preço por |  |  | When I pick [NAME] product in A12
Tipo Prod. | Material Empregue |  |  |  |  |  |  | Qaunt. | Unidade | Preço |  | and then Material in B:H12
Div | Electrodes Normal 2.5 |  |  |  |  |  |  | 18 | 0.3 | 5.399999999999999 |  | The price per unit should show automaticly
Inox | [NAME] 125 INOX |  |  |  |  |  |  | 7 | 2.5 | 17.5 |  | Please help! Thanks
[NAME] | União Niquelada 15x1/2 M. |  |  |  |  |  |  | 10 | 1.38 | 13.8
PVC | Lata Cola PVC 1/4 TANGITT |  |  |  |  |  |  | 5 | 9.5 | 47.5
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 | Mão de OBRA
 | DESLOCAÇÃO
 |  |  |  |  |  |  |  |  | TOTAL | 84.19999999999999
 |  |  |  |  |  |  |  |  | IVA 23% | 19.366
 |  |  |  |  |  |  |  |  | TOTAL | 103.566
 |  |  |  |  |  |  |  |  | RETENÇÃO | 0
 |  |  |  |  |  |  |  |  | TOTAL | 103.566
Spreadsheet: 4ae59e3a-f931-4fd5-8684-f3cac7ceae40
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Note:  Completed forms should be sent | Unnamed: 8
 |  |  |  |  |  |  |  | to the Business Office
[NAME] OF THE WOODS COLLEGE
CHARGE CARD EXPENSE SHEET
DATE: |  |  | Name: |  |  |  |  | Ext#:
Total Purchases from CC statement
This box must be zero! |  |  | 0
[NAME]: |  |  |  |  |  | ACCOUNT NUMBER |  | AMOUNT
 |  |  |  |  |  |  |  | 0
APPROVALS:
 |  |  |  |  |  | Business Office Use Only
Requested By:
 |  |  |  |  |  | Date Processed
Department Head:
 |  |  |  |  |  | Invoice Document Number:
Cabinet Member:
 |  |  |  |  |  | Audited By:
Office of the Controller:
Spreadsheet: 702937d1604618454-lookup-anther-sheet-as-reference-book1
Sheet: finalsheet

 | Contractor Tracking | date | due in 1 year
 | nome | 1st train | training Due | name | Outstanding
 | shoveler | 2020-01-09 00:00:00 |  | Hick | 0
 | barreller | 2020-05-23 00:00:00 |  | [NAME] | 0
 | wonderer | 2020-10-15 00:00:00 |  | [NAME] | 0
 | ? | 2020-02-23 00:00:00 |  | [NAME] |  | typed in here would update month tabs
Spreadsheet: 2d1077de-fc10-470c-a55e-c0a5342745ec
Sheet: September

FEDERAL COLLEGE WORK-STUDY PROGRAM
 | MASTER SHEET FOR STUDENT WORK HOURS
NAME |  |  |  |  |  |  |  | ASU ID #
PAY PERIOD BEGINNING |  |  | 2012-09-01 00:00:00 |  |  |  |  | PAY PERIOD ENDING |  |  | 2012-09-30 00:00:00
HOURLY RATE |  |  | 7.25 |  | TOTAL Hours |  |  |  |  | DEPARTMENT
TIME
WORKED | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
IN
OUT
IN
OUT
IN
OUT
TOTAL
TIME
WORKED | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
IN
OUT
IN
OUT
IN
OUT
TOTAL
Student's Signature
[NAME]'s  (Print Name ) |  |  |  |  |  |  |  |  | [NAME]'s Signature
Department Head's (Print Name) |  |  |  |  |  |  |  |  | Department Head's Signature
Note:  This Master [NAME] should reflect the time and hours the student actually worked.  The total hours per day should reflect in the total column.
Students are not authorized to work no more than 20 hours per week.  No EXCEPTIONS!!!
Spreadsheet: 788061d1658245019-sumifs-with-derived-criteria-sumifs_derived_criteria_exampleand-indexaggregate
Sheet: Sales

Sales Rep | Sale Amount | Sale Area |  | Rep | Region | Total Sales |  | criteria
[NAME] | 100 | Area 1 |  | [NAME] | North
[NAME] | 300 | Area 2
Cath | 500 | Area 3
[NAME] | 700 | Area 4
[NAME] | 200 | Area 5
[NAME] | 400 | Area 6
Cath | 600 | Area 7
[NAME] | 800 | Area 1
[NAME] | 250 | Area 2
[NAME] | 350 | Area 3
Cath | 450 | Area 4
[NAME] | 550 | Area 5
[NAME] | 100 | Area 6
[NAME] | 300 | Area 7
Cath | 500 | Area 1
[NAME] | 700 | Area 2
[NAME] | 200 | Area 3
[NAME] | 400 | Area 4
Cath | 600 | Area 5
[NAME] | 800 | Area 6
[NAME] | 250 | Area 7
[NAME] | 350 | Area 1
Cath | 450 | Area 2
[NAME] | 550 | Area 3
[NAME] | 100 | Area 4
[NAME] | 300 | Area 5
Cath | 500 | Area 6
[NAME] | 700 | Area 7
[NAME] | 200 | Area 1
[NAME] | 400 | Area 2
Cath | 600 | Area 3
[NAME] | 800 | Area 4
[NAME] | 250 | Area 5
[NAME] | 350 | Area 6
Cath | 450 | Area 7
[NAME] | 550 | Area 8
Spreadsheet: 686449d1594637384-rank-a-set-of-cells-and-conditional-format-them-to-certain-rules-rank-and-conditional-formatting-gmw2020
Sheet: Sheet1

BIO | BRNK | JT | JTRNK | SR | SRRNK | con | conrnk | OR | ORRNK | TOT | TOTRNK | MERIT | MRNK | RAJU | RAJURNK |  | RNKTOL | FNK
41 |  | 2.3 |  | 51 |  | 100.5 |  | 100.5 |  | 32.3 |  | 0 |  | 0
47 |  | 2.3 |  | 46 |  | 214.5 |  | 214.5 |  | 43.8 |  | 0 |  | 0
31 |  | 3.65 |  | 42 |  | 95 |  | 95 |  | 30.6 |  | 0 |  | 0
48 |  | 4.1 |  | 41 |  | 114.5 |  | 114.5 |  | 28.1 |  | 0 |  | 0
39 |  | 3.35 |  | 39 |  | 77.5 |  | 77.5 |  | 31.4 |  | 0 |  | 0
 |  | 2 |  | 37 |  | 41.5 |  | 41.5 |  | 28 |  | 0 |  | 0 |  |  |  |  |  | this is coming blank because one cell is blank the total needs to accommodate this
18 |  | 3.6 |  | 36 |  | 93 |  | 93 |  | 42.6 |  | 0 |  | 0 |  |  |  |  |  | in the total and ranking
32 |  | 3.15 |  | 36 |  | 68.5 |  | 68.5 |  | 28.1 |  | 0 |  | 0 |  |  |  |  |  | because if one cell is blank all others are ignored
35 |  | 2.3 |  | 35 |  | 99 |  | 99 |  | 33.8 |  | 0 |  | 0
42 |  | 2.35 |  | 33 |  | 70.5 |  | 70.5 |  | 21.4 |  | 0 |  | 0
-12 |  | 2.55 |  | 0 |  | 78.5 |  | 78.5 |  | 33.5 |  | 0 |  | 0
 |  | 1.6 |  | 0 |  | 52 |  | 52 |  | 27.6 |  | 0 |  | 0
 |  |  |  |  |  |  | Need to add the each of the shaded columns and find a total, problrm if cell is blank no total
 |  |  |  |  |  |  | the totals column must be ranked from highest to lowest in column T
 |  |  |  |  |  | A conditional formatting to show top 3 as green,next two as yellow and next three as red
Spreadsheet: 183549d1348860006-matching-last-2-columns-with-date-precentcomplete
Sheet: Sheet1

Name | Date | % Complete |  |  | Name | Date | % Complete
a | 2012-01-01 00:00:00 | 0.1 |  |  | a
b | 2012-01-05 00:00:00 | 0.2 |  |  | b
a | 2012-01-06 00:00:00 | 0.2 |  |  | c
b | 2012-02-01 00:00:00 | 0.3
c | 2012-02-01 00:00:00 | 0.1
a | 2012-02-03 00:00:00 | 0.3
Spreadsheet: 166573d1341646512-how-to-calculate-points-for-hockey-team-based-on-scores-in-regular-time-v-ot-socal-spring-12-schedule-revised-5-3-12-spencer101
Sheet: Bad Company

Game # | Week | DAY | DATE | TIME | DIVISION | TEAM | SCORE | vs | SCORE |  | TEAM | W/L/T | Game Points
1 | 2 | Sun | 2012-05-06 00:00:00 | 11:00:00 | Copper | Bad Company | 6 | vs | 3 |  | Whittier | W | 2
2 | 3 | Sat | 2012-05-12 00:00:00 | 11:00:00 | Copper | Bad Company | 4 | vs | 3 | OT | [NAME] | OTW | 2
3 | 4 | Sun | 2012-05-20 00:00:00 | 15:20:00 | Copper | Bad Company | 2 | vs | 6 |  | Upland Hitmen | L | 0
4 | 5 | Sun | 2012-05-27 00:00:00 | 13:00:00 | [NAME] | Bad Company | 5 | vs | 6 |  | [NAME] | L | 0
5 | 6 | Sun | 2012-06-03 00:00:00 | 17:20:00 | Copper | Bad Company | 9 | vs | 1 |  | Thunder | W | 2
6 | 7 | Sun | 2012-06-10 00:00:00 | 08:00:00 | Copper | Bad Company | 1 | vs | 1 |  | Degenerates | T | 1
7 | 8 | Sat | 2012-06-16 00:00:00 | 09:00:00 | Copper | Bad Company | 5 | vs | 1 |  | Upland Hitmen | W | 2
8 | 9 | Sun | 2012-06-17 00:00:00 | 16:20:00 | Copper | Bad Company | 2 | vs | 3 |  | Monarchs | L | 0
9 | 10 | Sun | 2012-06-24 00:00:00 | 11:00:00 | Copper | Bad Company |  | vs |  |  | Whittier
 |  |  | Total W | Total L | Total T | Total Pts
 |  |  | 4 | 3 | 1 | 9
Spreadsheet: f2b1473d-0539-4f2a-b821-6cc045ed0d8b
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
BHSF | Test | BHSF | [NAME], Beta-Subunit (Quantitative), [NAME] | [NAME] QN,CSF | Immunoenzymatic Assay | Varies: Var |  |  | 0.5 | mL | Container/Tube: Sterile vial [NAME]: 0.5 mL | 0.1 mL | Hemolysis	N/A Thawing	Warm Ok; Cold Ok Lipemia	N/A Icterus	N/A Other	N/A | <1.5 IU/L Tumor markers are not specific for malignancy, and values may vary by method. | Monday through Saturday; Continuously | 1 day | 3 days | 1 | 84702 |  |  |  |  | Rochester
BHSF | [NAME] | CSF | CSF |  |  |  | Refrigerated | 7 days
BHSF | Result | BHSF | [NAME] QN,CSF | [NAME] QN,CSF | Numeric |  |  |  |  | IU/L |  |  |  |  |  |  |  |  |  | 14041-8
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 4

कार्यक्रम PROGRAM |  |  | पदोन्नति पूर्य प्रतिक्षण – अधीनस्थ कमयचारी से एसडब्ल्यूओ (अ.तप.र्/सामान्य पीडब्ल्यूडी) PRE-PROMOTION TRAINING SUB-STAFF TO SWO (OBC/Gen PWD) | PROG CODE
 |  |  |  | AIT 0130
तर्षर् समूह/SUBJECT GROUP |  |  | HR, MARKETING, CUSTOMER SERVICE & COMPLIANCE
उद्देश्य/OBJECTIVE |  |  | TO IMPART KNOWLEDGE AND EMPOWER THE CANDIDATES TO COME OUT WITH BETTER PERFORMANCE IN THE PROMOTION PROCESS
लतक्षि समूह/TARGET GROUP |  |  | SUBSTAFF (OBC/Gen PWD)
अर्तध/DURATION |  |  | 5 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | General Banking & Demand Deposit
 | II | KYC/AML
 | III | Term Deposit
 | IV | Financial Inclusion
Day 2 | I | Priority Sector Lending
 | II | Government Sponsored Scheme
 | III | Agricultural Advances
 | IV | Retail Lending
Day 3 | I | Legal Aspect of Banking
 | II | General Banking – Cash / Securities
 | III | General Banking – Customer Service
 | IV | General Banking – Digital Banking
Day 4 | I | General Banking – Death Claim/Nomination/SDL/SCA
 | II | General Advances
 | III | Non Resident Deposits
 | IV | NPA & Recovery
Day 5 | I | General English
 | II | General English
 | III | General English
 | IV | Official Language,  Interview Tips
Spreadsheet: 719479d1613676446-need-to-count-items-in-one-sheet-based-on-searching-for-that-criteria-in-another-sheet-updated-searchtest
Sheet: type

TICKET NUMBER | TYPE
54279 | CHEVY
79217 | FORD
77788 | DODGE
61368 | DODGE
74268 | TOYOTA
77720 | AUDI
50590 | HONDA
78664 | HONDA
53408 | CHEVY
92811 | DODGE
74475 | FORD
89336 | KIA
60643 | CHRYSLER
Spreadsheet: 37962d1236075878-random-selections-student
Sheet: Sheet10

name
student 1001
student 1002
student 1003
student 1004
student 1005
student 1006
student 1007
student 1008
student 1009
student 1010
student 1011
student 1012
student 1013
student 1014
student 1015
student 1016
student 1017
student 1018
student 1019
student 1020
Spreadsheet: 114366d1310113941-multiple-workbook-problem-briansummary
Sheet: Summary

Summary | THIS IS THE WORKBOOK THAT NEEDS TO WORK. In the end all I want to do is change the value in A2, the worksheet should then grab the dates from brianFormulas.xlsx and place them in cells B4:X4. After that the worksheet should grab the correct ending balance from BrianFormulas.xlsx using the date that was found in the last formula and looking up the value through all worksheets in BrianFormulas.xlsx
march
US Dollar cash balance:
Ending balance
Jan
Feb
March
April
May
June
July
THIS IS THE WORKBOOK THAT NEEDS TO WORK. In the end all I want to do is change the value in A2, the worksheet should then grab the dates from brianFormulas.xlsx and place them in cells B4:X4. After that the worksheet should grab the correct ending balance from BrianFormulas.xlsx using the date that was found in the last formula and looking up the value through all worksheets in BrianFormulas.xlsx
Spreadsheet: 674633d1587968244-need-formula-to-post-payments-with-different-dates-frequency-than-column-headers-date-range2
Sheet: CASH FLOW FORECAST

Each Payment= | 500
 | Year
 | Date: FROM | 2019-11-01 00:00:00
 | TO Date
Pay Frequency | Start Date
Weekly | 2019-12-02 00:00:00
Bi-Weekly | 2019-12-02 00:00:00
Monthly | 2019-12-02 00:00:00
[NAME] | 2019-12-02 00:00:00
Quarterly | 2019-12-02 00:00:00
 |  |  | ^^^ Not working
Spreadsheet: daren_farmer__6605__Jan AA-1
Sheet: Sheet1

Last_Name | First_Name | Reference Identity | Company | RC | Title | NAME
Rostant | Justin | 182 | 413 | 366 | Analyst | Group
Shimeall | [NAME] | 183 | 413 | 366 | Analyst | Group
[NAME] | Sheetal | 179 | 413 | 463 | Analyst | Group
Walker | [NAME] | 170 | 413 | 463 | Analyst | Group
[NAME] | Tobin | 185 | 413 | 469 | Analyst | Group
Scott | [NAME] | 190 | 413 | 469 | Analyst | Group
Day | Misti | 167 | 413 | 476 | Analyst | Group
Rodriguez | [NAME] | 169 | 413 | 476 | Analyst | Group
LaFuze | Molly | 168 | 413 | 719 | Analyst | Group
Versen | Victoria | 166 | 413 | 719 | Analyst | Group
[NAME] | [NAME] | 164 | 413 | 720 | Analyst | Group
Zhang | Michelle | 159 | 413 | 720 | Analyst | Group
Bui | Hang | 160 | 413 | 726 | Analyst | Group
Kolman | [NAME] | 176 | 413 | 771 | Analyst | Group
[NAME] | Binh | 156 | 413 | 771 | Analyst | Group
Mathews | [NAME] | 155 | 413 | 1893 | Analyst | Group
Betzer | [NAME] | 113 | 413 | 825 | Associate | Group
Broido | [NAME] | 59 | 413 | 825 | Analyst | Group
Chaxel | [NAME] | 7 | 413 | 825 | Associate | Group
[NAME] | [NAME] | 36 | 413 | 825 | Associate | Group
[NAME] | [NAME] | 55 | 413 | 825 | Associate | Group
[NAME] | [NAME] | 132 | 413 | 825 | Associate | Group
Swain | Stephen | 41 | 413 | 825 | Associate | Group
Reside | [NAME] | 181 | 413 | 2655 | Analyst | Group
Bucalo | [NAME] | 174 | 413 | 849 | Analyst | Group
Parker | Yvette | 144 | 413 | 1275 | Analyst | Group
Eslick | Tara | 184 | 413 | 1631 | Analyst | Group
[NAME] | [NAME] | 186 | 413 | 1638 | Analyst | Group
Hull | [NAME] | 161 | 413 | 1638 | Analyst | Group
[NAME] | Purvi | 178 | 413 | 2839 | Analyst | Group
Stokley | [NAME] | 165 | 413 | 1869 | Analyst | Group
Milligan | [NAME] | 70 | 413 | 1891 | Associate | Group
Slone | Jeanne | 48 | 413 | 1891 | Associate | Group
Guggenheim | Victor | 187 | 413 | 1892 | Analyst | Group
Landry | Chad | 162 | 413 | 1840 | Analyst | Group
Etter | [NAME] | 151 | 413 | 1892 | Analyst | Group
Hyde | Crystal | 175 | 413 | 1893 | Analyst | Group
Perkins | Alicia | 180 | 413 | 1893 | Analyst | Group
Rodriguez | [NAME] | 13 | 413 | 1991 | Associate | Group
[NAME] | Simone | 177 | 413 | 2047 | Analyst | Group
Horner | [NAME] | 163 | 413 | 2182 | Analyst | Group
[NAME] | [NAME] | 191 | 413 | 2306 | Analyst | Group
Hiernstra | [NAME] | 153 | 413 | 2374 | Analyst | Group
Gillette | [NAME] | 152 | 413 | 2662 | Analyst | Group
Southard | Carrie | 157 | 413 | 2662 | Analyst | Group
Travis | [NAME] |  | 413 | 2372 | Analyst | Group
Alon | Heather |  | 413 | 1728 | Analyst | Group
Martin | Greg |  | 413 | 1631 | Analyst | Group
Monroy | [NAME] |  | 413 | 0758 | Analyst | Group
Waldhauser | Michelle |  | 413 | 1840 | Analyst | Group
Malone | Lynette |  | 413 | 2372 | Analyst | Group
Spreadsheet: 737283d1624338641-multiple-criteria-lookup-with-index-and-match-match-ans-2
Sheet: Matrix-2

Data |  |  |  |  |  |  |  |  |  |  | Result 1 |  |  |  |  |  |  |  |  |  |  | Result 2
Match 1 Column | Match 2 Column |  | Match 3 Column |  | Invisible |  |  |  | Match 1 Row > |  | Pol | [NAME] | BOP | Poly | Ink | Red | Chem | Tol | Wov | Pfilm |  | Pol | [NAME] | BOP | Poly | Ink | Red | Chem | Tol | Wov | Pfilm
 |  | Pull 1 |  | PN | Pull 2 | x | y |  |  | PN | Pull 1 i.e C Column Data |  |  |  |  |  |  |  |  |  |  | Pull 1 i.e F Column Data
2077.4.1 | Pol |  |  |  |  | x | y | Match 3 Column | Match 2 Column
 | [NAME] |  |  |  |  | x | y
 | BOP | 1110 | PBS |  |  | x | y
 | Poly | 6500 | PLR | 5850 |  | x | y |  | PLR
 | Ink | 1010 | PBS | 999 | 1010 | x | y |  | PBS
 | Red | 140 | PBS |  | 140 | x | y
 | Red | 1040 | PLR |  | 1040 | x | y
 | Chem | 780 | PLR |  | 780 | x | y
Spreadsheet: 076d0a0e-e660-4e39-ad0b-52787e268be8
Sheet: Sheet1

10-047 Electrical Services | Richardson Ready Electric | Environmental Lighting | Unnamed: 3 | Grove Electrical Service | Unnamed: 5
Labor Charge for licensed Master [NAME] | 45 | 64.99 |  | 44.5
Overtime Charge for Master Electrician | 45 | 97.49 |  | 69.5
Weekend Charge for Master [NAME] | 45 | 97.49 |  | 69.5
Holiday Charge for Master Electrician | 45 | 97.49 |  | 69.5
Labor Charge for licensed [NAME] | 45 | 43.99 |  | 44.5
Overtime Charge for [NAME] | 67.5 | 65.99 |  | 69.5
Weekend Charge for [NAME] | 67.5 | 65.99 |  | 69.5
Holiday Charge for Journeyman Electrician | 67.5 | 65.99 |  | 69.5
Labor Charge for Electricians Helper | 26 | 29.99 |  | 22
Overtime Charge for Electricians Helper | 39 | 44.99 |  | 32
Weekend Charge for Electricians Helper | 39 | 44.99 |  | 32
Holiday Charge for Electricians Helper | 39 | 44.99 |  | 32
Equipment Charge for 30 ft. Aerial Bucket Truck | 26 | 34.98 | 43.99 | 20
Equipment Charge for 50 ft. Aerial Bucket Truck | 26 | 34.98 | 43.99 | 25
 | 622.5 | 834.34 |  | 669
Parts Discount
wholesale |  |  | 0.35 | 0.1
retail | 0.15
trip charge |  | 75
Backhoe |  |  |  | 65 | hr
Trencher |  |  |  | 65 | hr
Directional Boring Machine |  |  |  | 10 | per ft
[NAME] 50 ft lift TZ50 |  |  |  | 20 | hr
[NAME] 25 ft lift awp25 |  |  |  | 49 | day
Spreadsheet: 146798d1332355501-count-if-sum-if-count_if_example
Sheet: Sheet1

year | id | x | count_x
2004 | 1 | 0
2004 | 1 | 0
2004 | 1 | 0
2004 | 1 | 0
2004 | 1 | 1
2004 | 1 | 0
2004 | 1 | 0
2004 | 1 | 0
2004 | 1 | 0
2005 | 1 | 1
2005 | 1 | 0
2005 | 1 | 0
2005 | 1 | 0
2005 | 1 | 0
2005 | 1 | 0
2005 | 1 | 0
2005 | 1 | 0
2005 | 1 | 0
2003 | 2 | 0
2003 | 2 | 1
2003 | 2 | 0
2003 | 2 | 0
2003 | 2 | 0
2004 | 2 | 0
2004 | 2 | 0
2004 | 2 | 1
2004 | 2 | 0
2004 | 2 | 0
2005 | 2 | 1
2005 | 2 | 0
2005 | 2 | 0
2005 | 2 | 0
2005 | 2 | 0
2003 | 3 | 0
2003 | 3 | 0
2003 | 3 | 0
2003 | 3 | 0
2003 | 3 | 0
2003 | 3 | 1
2003 | 3 | 0
2003 | 3 | 0
2003 | 3 | 0
2003 | 3 | 1
2003 | 3 | 0
2004 | 3 | 0
2004 | 3 | 0
2004 | 3 | 0
2004 | 3 | 0
2004 | 3 | 0
2004 | 3 | 0
2004 | 3 | 1
2004 | 3 | 0
2004 | 3 | 1
2004 | 3 | 0
2005 | 3 | 0
2005 | 3 | 0
2005 | 3 | 0
2005 | 3 | 0
2005 | 3 | 0
2005 | 3 | 1
2005 | 3 | 0
2005 | 3 | 0
2005 | 3 | 0
2005 | 3 | 1
2003 | 4 | 0
2003 | 4 | 0
2003 | 4 | 0
2003 | 4 | 0
2003 | 4 | 0
2003 | 4 | 0
2003 | 4 | 0
2003 | 4 | 1
2003 | 4 | 0
2003 | 4 | 0
2003 | 4 | 0
2004 | 4 | 0
2004 | 4 | 0
2004 | 4 | 1
Spreadsheet: 00cb7ae2-2a7f-4c81-87e2-c5645f108558
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
FCHOP | Test | FCHOP | Myxoid/Round Cell Liposarcoma 12q13 (DDIT3 or CHOP) Rearrangement, FISH, Tissue | DDIT3 (CHOP), 12q13, FISH | Fluorescence In Situ Hybridization (FISH) | Formalin-fixed, paraffin-embedded tissue: FFPET |  |  |  |  | Provide a pathology report with each tissue specimen. The laboratory will not reject a specimen that arrives without this information but will hold the specimen until a pathology report is received.   [NAME]: Tissue block and slide Collection Instructions: Submit formalin-fixed, paraffin-embedded tumor tissue block and include 1 hematoxylin-and-eosin stained slide. Forms: If not ordering electronically, submit a Cytogenetics Hematologic Disorders Request Form (Supply T607) with the specimen. | Paraffin-embedded whole tissue o | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Samples processed Monday through Sunday. Results reported Monday through Friday, 8 a.m.-5 p.m. CST. | 7 days | 10 days |  | Profile |  |  |  |  | Rochester
FCHOP | [NAME] | TISSUE | Tissue |  |  |  | Ambient
FCHOP | Order Question | CG061 | Reason For Referral |  | Plain Text
FCHOP | Result | 27388 | [NAME] | [NAME] | Alphanumeric
FCHOP | Result | 27389 | [NAME] | [NAME] | Alphanumeric
FCHOP | Result | 27390 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
FCHOP | Result | 27391 | Order Date | Order Date | Alphanumeric
FCHOP | Result | CG061 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
FCHOP | Result | 27393 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
FCHOP | Result | 27394 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCHOP | Result | 27395 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69965-2
FCHOP | Result | 27396 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCHOP | Result | 27397 | Consultant | Consultant | Alphanumeric
FCHOP | Result | 27398 | Released Date | Released Date | Alphanumeric
FCHOP | Billing Component | FCHOP |  | Cytogenetic Interp/Report |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88291
FCHOP | Billing Component | FCHOP |  | [NAME],each |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 88271
FCHOP | Billing Component | FCHOP |  | In situ hybrid, 100-300 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88275
Spreadsheet: 300637d1393523674-formatting-graphs-and-charts-with-data-in-cells-groom-workbook
Sheet: DIM. STATS

Dim. # : | 260
Dim.
Dim. Type:
Dim. Feature 1
[NAME]
 |  |  |  |  |  | P1 | P2 | P3 |  | P1 | P2 | P3 |  | P1 | P2 | P3 |  | P1 | P2 | P3
 |  |  |  |  | Sample 1
 |  |  |  |  | Sample 2
 |  |  |  |  | Sample 3
 |  |  |  |  | Average
 |  |  |  |  | Range
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: Contents

Present Worth Workbook Contents
Input |  | 2Replace Costs Results 11-15 |  | 4Capital Costs |  | 5Replace Costs Results 16-20
Capital Costs |  | 2Replace Costs Results 16-20 |  | 4Replacement Costs - Entry |  | 5Yearly O&M 1-10
Replacement Costs - Entry |  | 2Yearly O&M Costs 1-10 |  | 4Replace Costs Results 1-5 |  | 5Yearly O&M 11-20
Replace Costs Results 1-5 |  | 2Yearly O&M Costs 11-20 |  | 4Replace Costs Results 6-10 |  | 5Inter O&M Entry
Replace Costs Results 6-10 |  | 2Inter O&M Entry |  | 4Replace Costs Results 11-15 |  | 5Inter O&M 1-10
Replace Costs Results 11-15 |  | 2Inter O&M 1-10 |  | 4Replace Costs Results 16-20 |  | 5Inter O&M 11-20
Replace [NAME] |  | 2Inter O&M 11-20 |  | 4Yearly O&M Costs 1-10 |  | 6Capital Costs
Yearly O&M Costs 1-10 |  | 3Capital Costs |  | 4Yearly O&M Costs 11-20 |  | 6Replacement Costs - Entry
Yearly O&M Costs 11-20 |  | 3Replacement Costs - Entry |  | 4Inter O&M Entry |  | 6Replace Costs Results 1-5
Inter O&M Entry |  | 3Replace Costs Results 1-5 |  | 4Inter O&M 1-10 |  | 6Replace Costs Results 6-10
Inter O&M 1-10 |  | 3Replace Costs Results 6-10 |  | 4Inter O&M 11-20 |  | 6Replace Costs Results 11-15
Inter O&M 11-20 |  | 3Replace Costs Results 11-15 |  | 5Capital Costs |  | 6Replace Costs Results 16-20
2Capital Costs |  | 3Replace Costs Results 16-20 |  | 5Replacement Costs - Entry |  | 6Yearly O&M 1-10
2Replacement Costs - Entry |  | 3Yearly O&M Costs 1-10 |  | 5Replace Costs Results 1-5 |  | 6Yearly O&M 11-20
2Replace Costs Results 1-5 |  | 3Yearly O&M Costs 11-20 |  | 5Replace Costs Results 6-10 |  | 6Inter O&M Entry
2Replace Costs Results 6-10 |  | 3Inter O&M Entry |  | 5Replace Costs Results 11-15 |  | 6Inter O&M 1-10
 |  | 3Inter O&M 1-10 |  |  |  | 6Inter O&M 11-20
 |  | 3Inter O&M 11-20 |  |  |  | Total Present Worth