tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 789329d1659038364-conditional-occurrences-count-test-ronyn-
Sheet: Sheet1

long_code | product_name | bonus_group | company_name | document_date | document_number | incoming/outgoing | document_type | quantity | test | Test2 | Helper |  | Start Date: | 2021-12-19 00:00:00
0634.349.853:000 | O-RING | T11 | A | 2022-06-16 00:00:00 | [PHONE] | Outgoing | credit | 1 |  |  | 1
0634.349.853:000 | O-RING | T11 | B | 2022-05-26 00:00:00 | [PHONE] | Outgoing | invoice | -2 |  |  | 1
0634.349.853:000 | O-RING | T11 | A | 2022-05-26 00:00:00 | [PHONE] | Outgoing | credit | 1 |  |  | 1
0634.349.853:000 | O-RING | T11 | A | 2022-05-11 00:00:00 | [PHONE] | Outgoing | invoice | -1 |  |  | 1
0634.349.853:000 | O-RING | T11 | A | 2022-05-11 00:00:00 | [PHONE] | Outgoing | invoice | -1 |  |  | 2
0634.349.853:000 | O-RING | T11 | A | 2021-10-06 00:00:00 | [PHONE] | Outgoing | invoice | -1 |  |  | 1
0634.349.853:000 | O-RING | T11 | C | 2021-06-25 00:00:00 | [PHONE] | Outgoing | invoice | -10 |  |  | 1
Spreadsheet: 857101d1706173930-changing-column-input-also-need-to-be-dynamic-changing-columns
Sheet: Sheet1

Sl. No. | [NAME] | YY_BB | CC ZZ | AM S | YZ X |  |  | CC ZZ |  |  |  | Tried and found this formula but not sure how to column input this result to countif formula
1 | 64 | 36 | 63 | 41 | 48
2 | 82 | 94 | 94 | 83 | 48
3 | 74 | 30 | 30 | 43 | 65
4 | 24 | 79 | 30 | 42 | 54 |  |  |  | Hello
5 | 50 | 78 | 64 | 46 | 83
6 | 11 | 22 | 89 | 31 | 18 |  |  |  | Please refer the attached excel file.
7 | 82 | 39 | 82 | 12 | 58
8 | 42 | 32 | 30 | 98 | 41 |  |  |  | I need to countif for the specific text "CC ZZ" and when I am generating report every time the column of `CC ZZ' will change (Currently it is D)
9 | 99 | 11 | 93 | 69 | 53
10 | 36 | 71 | 13 | 65 | 23 |  |  |  | If we are using `D:D' then next time this formula need to be remodified, is there any way to input the formula instead of `DD' so that every time excel will find the column position and countif automatically.
11 | 95 | 31 | 50 | 65 | 92
12 | 16 | 28 | 30 | 68 | 59 |  |  |  | thanks in Advance.
13 | 98 | 72 | 68 | 61 | 79
14 | 48 | 17 | 30 | 81 | 71
15 | 68 | 84 | 51 | 23 | 45
16 | 92 | 18 | 57 | 99 | 75
17 | 91 | 55 | 19 | 30 | 33
18 | 42 | 45 | 30 | 79 | 91
19 | 99 | 82 | 84 | 76 | 55
20 | 41 | 34 | 74 | 60 | 63
Spreadsheet: 882380d1730765865-have-saturday-dates-automatically-generate-by-month-and-adjust-for-number-of-weeks-pages-sample
Sheet: ben's

DATE  W/ ENDING | PAID |  | Pressing 'TAB' in Last row off paid inserts a new row with correct date
2025-01-04 00:00:00 | 2
 | 2
 | 2
 | 0
 | 2
 | 2
 | 2
 | 2
Spreadsheet: 224698d1364708743-simple-databse-but-i-dont-know-how-sample
Sheet: Sheet1

Last Name | First Name | Original Price | Monthly Due | Date
Lingga | [NAME] | 4000 | 400 | 2013-02-03 00:00:00
Lingga | [NAME] | 4000 | 600 | 2013-02-05 00:00:00
[NAME] | [NAME] | 90000 | 8000 | 2013-02-09 00:00:00
[NAME] | Ellis | 7000 | 800 | 2013-02-21 00:00:00
Lingga | [NAME] | 4000 | 400 | 2013-02-22 00:00:00
Lingga | [NAME] | 4000 | 600 | 2/30/2013
Lingga | [NAME] | 4000 | 400 | 2013-03-03 00:00:00
Lingga | [NAME] | 4000 | 600 | 2013-03-05 00:00:00
[NAME] | [NAME] | 90000 | 8000 | 2013-03-09 00:00:00
[NAME] | [NAME] | 90000 | 8000 | 2013-03-15 00:00:00
[NAME] | Ellis | 7000 | 2000 | 2013-03-21 00:00:00
Spreadsheet: 538127d1505413575-help-with-sum-of-one-column-based-on-data-in-2nd-column-quarterly-capex-project-tracker-q4-2017-autosaved-
Sheet: Main

2018 Quarterly CAPEX Forecaster
Q1 | Q2 | Q3 | Q4
Quarterly Budget | Quarterly Budget | Quarterly Budget | Quarterly Budget
250000 | 500000 | 251978 | 272979
Total Submitted Amounts | Total Submitted Amounts | Total Submitted Amounts | Total Submitted Amounts
FOT Monthly Quota | FOT Monthly Quota | FOT Monthly Quota | FOT Monthly Quota
10000 | 20000 | 7500 | 1500
FOT Submitted Amounts | FOT Submitted Amounts | FOT Submitted Amounts | FOT Submitted Amounts
FOT NAME | BU NUMBER | SITE NAME | PROJECTED SOW (JOB DESCRIPTION) | SUSTAINING CAPEX CODES | PROJECTED COST OF PROJECT | QUOTE REQUESTED | QUOTE EXPIRATION DATE | POTENTIAL BIDDERS(PLEASE LIST THREE | ESTIMATED QUARTER OF COMPLETION | ESTIMATED DATE OF COMPLETION | PRIORITY LEVEL | COMMENTS (If project is urgent, please explain)
[NAME] | 873009 | Ward Peak | Shelter & HVAC Upgrade | RR-SHELTER | 10000 | YES |  |  | Q3 |  | MID | 109000
[NAME] | 845854 | [NAME] | [NAME] | RR-TWR | 49000 | YES |  |  | Q4 |  | high
[NAME] | 856928 | HWY 101 & Grand Ave | Rebranch | RR-STEALTH | 20000 | YES |  |  | Q1 |  | low | 11000
[NAME] | 845868 | West Truckee | Rebranch | RR-STEALTH | 30000 | YES |  |  | Q1 |  |  | 25000
[NAME] | 818311 | [NAME] | [NAME] | RR-TWR | 79000 | YES |  |  | Q4
[NAME] | 815023 | HWY 12 | Add drainage and culverts | [NAME] | 18500 | YES |  |  | Q4
[NAME] | 815779 | Rodeo | Add drainage and culverts | [NAME] | 19439 | YES |  |  | Q4
[NAME] | 845495 | [NAME] | Add drainage and culverts | [NAME] | 19889 | YES |  |  | Q4
[NAME] | 845488 | Martinez Cummings Skyway | Tower Corrosion | RR-TWR | 19999 | YES |  |  | Q1
[NAME] | 871814 | Park Place | HVAC Upgrade | RR-SHELTER | 0 | YES |  |  | Q4 |  |  | 19845
[NAME] | 818311 | [NAME] | [NAME] | RR-TWR | 50000 |  |  |  | Q2
[NAME] | 818311 | [NAME] | [NAME] | RR-TWR | 10000 |  |  |  | Q2
[NAME] | 818311 | [NAME] | [NAME] | RR-TWR | 5000 |  |  |  | Q3
[NAME] | 818311 | [NAME] | [NAME] | RR-TWR | 100000 |  |  |  | Q1
Spreadsheet: 115288d1310927849-transferring-results-and-drop-down-lists-example-worksheet1
Sheet: Input Tab 2011

 |  | HOSPITAL
 |  | NUMBER | HOSPITAL NAME |  |  |  |  | Result 1 | Result 2
 |  |  | . | ID # | DATE |  | Data 1 | 2010 | 2010 | Data 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMMENTS
 | 1 | 000001 | Hospital A | 11 | 2011-12-31 00:00:00 | Y
 | 2 | 000002 | Hospital B | 22 | 2011-12-31 00:00:00 | Y
 | 3 | 000003 | Hospital C | 33 | 2011-12-31 00:00:00
 | 4 | 000004 | Hospital D | 44 | 2011-12-31 00:00:00
 | 5 | 000005 | Hospital E | 55 | 2011-12-31 00:00:00 | Y
 | 6 | 000006 | Hospital F | 66 | 2011-12-31 00:00:00 | Y
 | 7 | 000007 | Hospital G | 77 | 2011-12-31 00:00:00 | Y
Spreadsheet: 854560d1704386232-help-with-dependent-drop-down-list-dependent-dropdown-list
Sheet: Sheet1

 | Division | Overhead | Operations | Production | Income |  |  |  | RLTR
 | Overhead | Alternative Power | Cattle Trailer Operation | Branding Equipment | Packaged Beef Sales
 | Operations | Business License | Cattle Truck Operation | Cattle Support | [NAME] |  |  |  | 1
 | Production | Container | Communications | [NAME] | Cow Sales |  |  |  | 20 | Division | Category | Transaction Type | Description | Amount | Quantity | Total | Transaction Date
 | Income | Dogs | Delivery Truck Operation | [NAME] Loan | Horse Training |  |  | 0.1 |  | Overhead |  | Purchase | WIRE | 75 | 2 |  | 2024-04-04 00:00:00
 |  | Farm Equipment | Equipment Rental | [NAME] | Leather-work |  |  |  |  | Operations |  | Purchase | Pivot Pump | 1095 | 1 |  | 2024-01-05 00:00:00
 |  | Horses | Freezer Storage Operation | Presentation | [NAME] |  |  |  |  | Production |  | Purchase | TRACTOR | 176000 | 1 |  | 2024-01-15 00:00:00
 |  | Insurance | Guns and Ammunition |  | Rodeo |  |  |  |  | Income |  | Purchase | Fence wire for Pasture A | 75 | 1 |  | 2024-01-24 00:00:00
 |  | Irrigation Equipment | Marketing |  | Steer Sales |  |  |  |  |  |  | Income | [NAME] 152023 | 1700 | 1 |  | 2024-01-19 00:00:00
 |  | Office Equipment | Office Operation |  | Bull Stud Service
 |  | Property Lease | Pasture Irrigation
 |  | Property Purchase | Structures Maintenance
 |  | Storage | Vehicle Three Operation
 |  | Tack | Vehicle Two Operation
 |  | Taxes
 |  | Tractor Implements |  |  |  |  | When a dropdown from the Division column is selected, the dropdown in the Category column is intended to show the items listed under the selected Division.  For example, if Operations is selected in the Division column, when the dropdown list is selected in the category column, only the Operations items are listed.
 |  | Utilities
 |  | Vehicle Lease
 |  | Vehicle License
 |  | Vehicle Purchase
Spreadsheet: 675735d1588443673-use-data-in-multiple-cells-to-return-result-example
Sheet: Jun - Inv

 | Month | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
 | Year | 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Day
Child's Name | Parent's Name | Address
 |  |  | 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
Spreadsheet: 2490fdc4-1030-4599-9afc-7f3aadb06f4c
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
09/04/2004 | Football | EAST CAROLINA | 12:00 AM | W, 56-23
09/11/2004 | Football | at Central Florida | 12:00 AM | W, 45-20
09/18/2004 | Football | MARYLAND | 12:00 AM | W, 19-16 (OT)
09/25/2004 | Football | [NAME] | 12:00 AM | W, 45-10
10/02/2004 | Football | at Virginia Tech | 12:00 AM | L, 13-19
10/13/2004 | Football | at Connecticut | 12:00 AM | W, 31-19
10/21/2004 | Football | SYRACUSE | 12:00 AM | W, 27-6
10/30/2004 | Football | at Rutgers | 12:00 AM | W, 35-30
11/06/2004 | Football | TEMPLE | 12:00 AM | W, 42-21
11/13/2004 | Football | BOSTON COLLEGE | 12:00 AM | L, 17-36
11/25/2004 | Football | at Pitt | 12:00 AM | L, 13-16
01/01/2005 | Football | Florida State (Gator Bowl) | 12:00 AM | L, 18-30
Spreadsheet: 110189d1306932470-help-with-data-arrangement-timetablesummary
Sheet: Data

Departing From | Arriving at | Passengers
SYD | CPT | 10224
SYD | LHR | 125743
SYD | MUC | 354
SYD | FRA | 4574
HKG | CPT | 3673
HKG | LHR | 236
HKG | MUC | 8354
HKG | FRA | 3783
LAX | CPT | 5724
LAX | LHR | 8244
LAX | MUC | 2536
LAX | FRA | 665
MIA | CPT | 38
MIA | LHR | 485
MIA | MUC | 236
MIA | FRA | 132
CDG | CPT | 7553
CDG | LHR | 8846
CDG | MUC | 4534
CDG | FRA | 33464
ORY | CPT | 2234
ORY | LHR | 23553
ORY | MUC | 53445
ORY | FRA | 43756
CPT | SYD | 45367
Spreadsheet: 121220d1315927555-dynamic-named-range-in-chart-dynamic-named-range
Sheet: Hours

Contractor | Rate | 2011-08-12 00:00:00 | 2011-08-19 00:00:00 | 2011-08-26 00:00:00 | 2011-09-02 00:00:00 | 2011-09-09 00:00:00 | 2011-09-16 00:00:00 | 2011-09-23 00:00:00 | 2011-09-30 00:00:00 | 2011-10-07 00:00:00 | 2011-10-14 00:00:00 | 2011-10-21 00:00:00 | 2011-10-28 00:00:00 | 2011-11-04 00:00:00 | 2011-11-11 00:00:00 | 2011-11-18 00:00:00 | 2011-11-25 00:00:00 | 2011-12-02 00:00:00 | 2011-12-09 00:00:00 | 2011-12-16 00:00:00 | 2011-12-23 00:00:00 | 2011-12-30 00:00:00 | 2012-01-06 00:00:00 | 2012-01-13 00:00:00 | 2012-01-20 00:00:00 | 2012-01-27 00:00:00 | 2012-02-03 00:00:00 | 2012-02-10 00:00:00 | 2012-02-17 00:00:00 | 2012-02-24 00:00:00 | 2012-03-02 00:00:00 | 2012-03-09 00:00:00 | 2012-03-16 00:00:00 | 2012-03-23 00:00:00 | 2012-03-30 00:00:00 | 2012-04-06 00:00:00 | 2012-04-13 00:00:00 | 2012-04-20 00:00:00 | 2012-04-27 00:00:00 | 2012-05-04 00:00:00 | 2012-05-11 00:00:00 | 2012-05-18 00:00:00 | 2012-05-25 00:00:00 | 2012-06-01 00:00:00 | 2012-06-08 00:00:00 | 2012-06-15 00:00:00 | 2012-06-22 00:00:00 | 2012-06-29 00:00:00 | 2012-07-06 00:00:00 | 2012-07-13 00:00:00 | 2012-07-20 00:00:00 | 2012-07-27 00:00:00 | 2012-08-03 00:00:00 | 2012-08-10 00:00:00
Name | 40
Name | 40
Name | 40 | 7 | 2
Name | 30 | 1.25 | 1.25
Name | 30 | 23 | 15.5
Name | 30 | 50 | 44
Name | 30
Name | 30 | 49 | 44
Spreadsheet: 109522d1306352632-need-to-always-pull-info-from-same-line-in-a-different-worksheet-copy-of-rabies-certificates
Sheet: Certificate

CERTIFICATE OF VACCINATION
 |  |  | Year [NAME]
Date of Rabies Vaccination: |  |  | 2011-06-05 00:00:00 |  | Tag No: | 1-1001
Next Rabies Vaccination Due: |  |  | 2012-06-04 00:00:00
VETERINARY CLINIC |  |  |  |  | OWNER OF ANIMAL
XYZ |  |  |  |  | [NAME]
123 Main Street |  |  |  |  | 101 Main St.
Asheville, NC 28803 |  |  |  |  | Asheville, NC 28803
[PHONE] |  |  |  |  | [PHONE]
This is to certify...
THAT I HAVE VACCINATED AGAINST RABIES THE ANIMAL DESCRIBED BELOW:
Patient information...
PATIENT: | Smoky |  |  |  | TAG NO: | 1-1001
SPECIES: | Canine |  |  |  | SIZE: | 50 lbs
SEX: | Neutered Male |  |  |  | AGE: | 3Y
COLOR: | Black |  |  |  | BREED: | Lab Mix
SIGNED:
 |  | [NAME], DVM |  |  |  | License: | 12345
Rabies Vaccine Information...
MFG BY: |  |  |  |  | SER NO:
LOT EXP |  |  |  |  | ADM:
Spreadsheet: james_steffes__12812__Origination Summary 08-30-01
Sheet: International Origin Summary

 |  |  |  |  |  |  | EES Canada - Risk Analysis
 |  |  |  |  |  |  | 3Q/2001 MTM Origination Summary
 |  |  |  |  |  | Origination |  |  |  |  |  |  | Risk Management
Deals | Silo | State | Region | Type | Channel | TCV | Sales Orig. O-K | Credit Reserve | Implementation Premium | Consumption Premium | Net Orig. Value O-K               (MTM @ Offer) |  | Hedge Mngmt | Valuation Prudencies | NET RM |  | Total Value
Thousands of US Dollars (FX Rate 1.54) |  |  |  |  |  |  |  |  |  |  |  |  | M-O |  | RM |  | (MTM)
ENRON DIRECT CANADA
DIRECT SALES:
GAS DEALS
Boardwalk Equities Inc. - 2.5% |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
Boardwalk 2.5% Hedge |  |  |  |  |  | 98.789 | 98.789 | 0 | 0 | 0
Calgary Winter Club |  |  |  |  |  | 130.251 | 7.874 | -1.119 | 0 | 0
Point on the Bow Condo |  |  |  |  |  | 47.143 | 4.629 | -0.46 | -0.32 | 0
Telus Convention Center |  |  |  |  |  | 199.202 | 23.416 | -1.951 | -1.527 | 0
TOTAL GAS DEALS
POWER DEALS
Kawneer Company Canada |  |  |  |  |  | 26.246 | 12.518 | -1.252 | 0 | 0
Frank Sissions Casino |  |  |  |  |  | 262.946 | 44.383 | -2.488 | -1.823 | 0
Capri Centre |  |  |  |  |  | 172.304 | 13.848 | -1.712 | -0.995 | 0
TOTAL POWER DEALS
TOTAL ENRON DIRECT CANADA:
TOTAL ENRON DIRECT CANADA Q3:
1Q 2001 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 2597.022
2Q 2001 |  |  |  |  |  | 6810.055 | 2519.768 | -347.888 | -10.732 | 0 | 2161.148 |  | 0 | 0 | 0 |  | 2597.022
3Q 2001
4Q 2001 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0
YTD 2001
 |  |  |  |  |  |  | EES Europe
 |  |  |  |  |  |  | 3Q/2001 MTM Origination Summary
 |  |  |  |  |  | Origination |  |  |  |  |  |  | Risk Management
Deals | Silo | State | Region | Type | Channel | TCV | Sales Orig. O-K | Credit Reserve | Neta / Renewables Provision | Consumption Premium | Net Orig. Value O-K               (MTM @ Offer) |  | Hedge Mngmt | Valuation Prudencies | NET RM |  | Total Value
($000's US$) |  |  |  |  |  |  |  |  |  |  |  |  | M-O |  | RM |  | (MTM)
Middle Market (Crossley Cooke)
Enron Direct |  |  |  |  |  | 29696 | 10302 | -84 | -466 | 0 |  |  | 0 | 0
Enron Directo |  |  |  |  |  | 7546 | -282 | 0 | 0 | 0
Enron Direct, Netherlands |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
Energy Portfolio Mgmt (Rexrode)
Taylor Woodrow Property Management Ltd |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 | 0
Taylor Woodrow Construction Ltd |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
TOTAL Europe Q3:
1Q 2001 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 2597.022
2Q 2001 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 2597.022
3Q 2001
4Q 2001 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0
YTD 2001
Spreadsheet: 73918d1274453034-excel-2007-issue-with-pulling-in-data-2010-05-19
Sheet: Summary

Verification Rep | Total | Verified | % | Rejected | % | Repitch | Total Check | Does Not Want
astingel
cbernsdorf
csimon
fmorgan
[NAME]
[NAME]
jheredia
[NAME]
jwhittaker
kherring
lcormany
madams
molms
mwatkins
ngriffith
rmoore
shenderson
(blank)
Verifier Totals
New
Total Records
Total Check
Spreadsheet: 599306d1542963612-conditional-formatting-highest-value-closest-to-that-of-a-cell-excel-sample-ans2
Sheet: Φύλλο1

 |  |  | 1570 |  |  | 1670 |  |  | 1770 |  |  | 1870 |  |  | 1960 |  |  | 2070 |  |  | 2160
1 | 2 | 3 |  |  |  |  |  |  | 4 | 5 |  |  |  |  | 6 | 7 |  |  |  |  | 8
8 | 23,5 | 26,2 |  |  |  |  |  |  | 37,4 | 40,3 |  |  |  |  | 41,4 | 44,7 |  |  |  |  | 49,2
9 | 29,7 | 33,1 |  |  |  |  |  |  | 47,3 | 51,0 |  |  |  |  | 52,4 | 56,5 |  |  |  |  | 62,3
10 | 36,7 | 40,9 |  |  |  |  |  |  | 58,4 | 63,0 |  |  |  |  | 64,7 | 69,8 |  |  |  |  | 76,9
11 | 44,4 | 49,5 |  |  |  |  |  |  | 70,7 | 76,2 |  |  |  |  | 78,3 | 84,4 |  |  |  |  | 93,0
12 | 52,8 | 58,9 |  |  |  |  |  |  | 84,1 | 90,7 |  |  |  |  | 93,1 | 100 |  |  |  |  | 111
13 | 62,0 | 69,1 |  |  |  |  |  |  | 98,7 | 106 |  |  |  |  | 109 | 118 |  |  |  |  | 130
14 | 71,9 | 80,2 |  |  |  |  |  |  | 114 | 124 |  |  |  |  | 127 | 137 |  |  |  |  | 151
16 | 94,0 | 105 |  |  |  |  |  |  | 150 | 161 |  |  |  |  | 166 | 179 |  |  |  |  | 197
18 | 119 | 133 |  |  |  |  |  |  | 189 | 204 |  |  |  |  | 210 | 226 |  |  |  |  | 249
20 | 147 | 164 |  |  |  |  |  |  | 234 | 252 |  |  |  |  | 259 | 279 |  |  |  |  | 308
22 | 178 | 198 |  |  |  |  |  |  | 283 | 305 |  |  |  |  | 313 | 338 |  |  |  |  | 372
24 | 211 | 236 |  |  |  |  |  |  | 336 | 363 |  |  |  |  | 373 | 402 |  |  |  |  | 443
26 | 248 | 276 |  |  |  |  |  |  | 395 | 426 |  |  |  |  | 437 | 472 |  |  |  |  | 520
28 | 288 | 321 |  |  |  |  |  |  | 458 | 494 |  |  |  |  | 507 | 547 |  |  |  |  | 603
29
30 |  | 370 |  |  |  |  |  |  |  | 570 |  |  |  |  |  | 631 |  |  |  |  | 695
31
32 | 376 | 419 |  |  |  |  |  |  | 598 | 645 |  |  |  |  | 662 | 715 |  |  |  |  | 787
33
34 |  | 475 |  |  |  |  |  |  |  | 731 |  |  |  |  |  | 810 |  |  |  |  | 892
35
36 | 476 | 530 |  |  |  |  |  |  | 757 | 817 |  |  |  |  | 838 | 904 |  |  |  |  | 997
37
38 |  | 592 |  |  |  |  |  |  |  | 914 |  |  |  |  |  | 1012 |  |  |  |  | 1114
39
40 | 587 | 654 |  |  |  |  |  |  | 935 | 1010 |  |  |  |  | 1 040 | 1120 |  |  |  |  | 1230
41
42 |  | 723 |  |  |  |  |  |  |  | 1115 |  |  |  |  |  | 1235 |  |  |  |  | 1360
43
44 | 711 | 792 |  |  |  |  |  |  | 1130 | 1220 |  |  |  |  | 1 250 | 1350 |  |  |  |  | 1490
48 | 846 | 942 |  |  |  |  |  |  | 1 350 | 1450 |  |  |  |  | 1 490 | 1610 |  |  |  |  | 1770
52 | 992 | 1 110 |  |  |  |  |  |  | 1 580 | 1700 |  |  |  |  | 1 750 | 1890 |  |  |  |  | 2080
56 | 1 150 | 1 280 |  |  |  |  |  |  | 1 830 | 1980 |  |  |  |  | 2 030 | 2190 |  |  |  |  | 2410
60 | 1 320 | 1 470 |  |  |  |  |  |  | 2 100 | 2270 |  |  |  |  | 2 330 | 2510 |  |  |  |  | 2770
Vessel | 45
[NAME]
Column | F | I | L | O | R | U | W
Number
Spreadsheet: d4573494-18be-4cb4-aa5d-1911830778bc
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
PNEFS | Test | PNEFS | Neuroimmunology Antibody Follow-up, Serum | Neuroimmunology Ab Follow-up, S | This follow-up evaluation is used to monitor patients who tested positive for 1 or more antibodies in the Neuroimmunology Laboratory in the past 15 months. | Serum Gel Tube: SGT |  |  | 4 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 4 mL | 0.8 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | NEURONAL NUCLEAR ANTIBODIES Antineuronal Nuclear Antibody-Type 1 (ANNA-1) <1:240   Antineuronal Nuclear Antibody-Type 2 (ANNA-2)   <1:240  Antineuronal Nuclear Antibody-Type 3 (ANNA-3) <1:240   NEURONAL AND MUSCLE CYTOPLASMIC ANTIBODIES Purkinje Cell Cytoplasmic Antibody, Type 1 (PCA-1)  <1:240 Purkinje Cell Cytoplasmic Antibody, Type 2 (PCA-2) <1:240 Purkinje Cell Cytoplasmic Antibody, Type Tr (PCA-Tr) <1:240 Amphiphysin Antibody <1:240  CRMP-5-IgG <1:240 Striational (Striated Muscle) Antibodies <1:60 Paraneoplastic Autoantibody Western Blot Confirmation Negative CRMP-5-IgG Western Blot Negative   CATION CHANNEL ANTIBODIES N-Type Calcium Channel Antibody < or =0.03 nmol/L P/Q-Type Calcium Channel Antibody < or =0.02 nmol/L ACh Receptor (Muscle) Binding Antibody < or =0.02 nmol/L AChR Ganglionic Neuronal Antibody < or =0.02 nmol/L ACh Receptor (Muscle) Modulating Antibodies 0-20% (reported as __% loss of AChR)   GAD65 ANTIBODY ASSAY < or =0.02 nmol/L   Neuron-restricted patterns of IgG staining that do not fulfill criteria for amphiphysin, ANNA-1, ANNA-2, ANNA-3, PCA-1, PCA-2, PCA-Tr, or CRMP-5-IgG may be reported as "unclassified antineuronal IgG." Complex patterns that include non-neuronal elements may be reported as "uninterpretable." Note: Titers lower than 1:240 are detectable by recombinant CRMP-5 Western blot analysis. CRMP-5 Western blot analysis will be done on request on stored serum (held 4 weeks). This supplemental testing is recommended in cases of chorea, vision loss, and cranial neuropathy and myelopathy. Call the Neuroimmunology Laboratory at [PHONE] or [PHONE] to request CRMP-5 Western blot. | ANNA-1: Monday through Friday; 11:30 a.m. ANNA-2: Monday through Friday; 11:30 a | Varies | Varies |  |  |  |  |  |  | Rochester
PNEFS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PNEFS | Result | 84300 | Neuroimmunology Ab Follow-up, S | Neuroimmunology Ab Follow-up, S | Alphanumeric |  |  |  |  | nmols/L |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 726652d1617353788-help-on-nested-if-formula-if-1-
Sheet: Sheet1

 |  |  | Header | Price | Price Band
 |  |  | FT | 1499
 |  |  | FT | 1501
 |  |  | FT | 1550
 |  |  | FT | 1600
 |  |  | FT | 2001
 |  |  | FT | 2050
 |  |  | FT | 2999
 |  |  | FT | 3001
 |  |  | SO |  | =IF(F3<=500,"Up to 500",IF(AND(F3>500,F3<=750),"501-750",IF(AND(F3>750,F3<=1000),"751-1000",IF(AND(F3>1000,F3<=1300),"1001-1300",IF(AND(F3>1300,F3<=1600),"1301-1600",IF(AND(F3>1600,F3<=2000),"1601-2000","2000+"))))))
 |  |  | TI |  | =IF(F3<=2000,"<2K",IF(AND(F3>2000,F3<=3000),"2K-3K",IF(AND(F3>3000,F3<=5000),"3K-5K",">5K")))
 |  |  | SO-S |  | =IF(F3<=500,"Up to 500",IF(AND(F3>500,F3<=750),"501-750",IF(AND(F3>750,F3<=1000),"751-1000",IF(AND(F3>1000,F3<=1300),"1001-1300",IF(AND(F3>1300,F3<=1600),"1301-1600",IF(AND(F3>1600,F3<=2000),"1601-2000","2000+"))))))
 |  |  | FT-T |  | T
 |  |  | ZP |  | ZP
 |  |  |  |  | =IF(E3="TI",IF(F3<=2000,"<2K",IF(AND(F3>2000,F3<=3000),"2K-3K",IF(AND(F3>3000,F3<=5000),"3K-5K",">5K"))),IF(E3="FT",IF(F3<=1500,"<=1500",IF(AND(F3>1500,F3<=2000),"1501-2000",IF(AND(F3>2000,F3<=3000),"2001-3000",IF(AND(F3>3000,F3<=4000),"3001-4000",">4000")))),IF(E3="SO",IF(F3<=500,"Up to 500",IF(AND(F3>500,F3<=750),"501-750",IF(AND(F3>750,F3<=1000),"751-1000",IF(AND(F3>1000,F3<=1300),"1001-1300",IF(AND(F3>1300,F3<=1600),"1301-1600",IF(AND(F3>1600,F3<=2000),"1601-2000","2000+")))))))))
Spreadsheet: 853934d1703875247-next-row-down-progressive-subtraction-help-needed-samplefile2
Sheet: Sheet1

1 | 25.345 | manual | new formula
2 | 49.139664
3 | 60.179838
4 | 52.24716
5 | 46.426695
1 | 52.4741
2 | 36.4878
3 | 75.142
4 | 66.1454
5 | 78.1425