tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 853656d1703582220-trying-to-set-up-a-formula-that-enables-a-leapfrog-points-system-for-a-sports-ladder-tennis-ladder-v2
Sheet: Ladder

 | Men's Team  Tennis Ladder
Ranking | Player | Total Matches Played | Total Wins | Total Losses | Challenges made | Challenges Won |  | Points from challenges | Total Points
1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15
2 | Zak | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14
3 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13
4 | Martin | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12
5 | Clive | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11
6 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10
7 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9
8 | Ian | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8
9 | Julian | 1 | 0 | 0 | 1 | 1 | 1 | 3.003 | 7.003
10 | [NAME] | 3 | 0 | 0 | 2 | 2 | 1 | 2.002999999999999 | 7.002999999999999
11 | [NAME] | 4 | 1 | 0 | 1 | 1 | 1 | 1.002 | 7.002000000000001
12 | [NAME] | 2 | 0 | 2 | 1 | 0 | 0 | 0 | 7
13 | Nick | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
14 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
15 | Guy | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
RAW DATA
Player | [NAME] | Total Wins | Total Losses | Total Challenges | Challenges Won | Challenges Won (%) | Points Won | Total Points | Points
[NAME] |  |  |  |  |  |  |  |  | 15
Zak |  |  |  |  |  |  |  |  | 14
[NAME] |  |  |  |  |  |  |  |  | 13
Martin |  |  |  |  |  |  |  |  | 12
Clive |  |  |  |  |  |  |  |  | 11
[NAME] |  |  |  |  |  |  |  |  | 10
[NAME] |  |  |  |  |  |  |  |  | 9
Ian |  |  |  |  |  |  |  |  | 8
[NAME] |  |  |  |  |  |  |  |  | 7
[NAME] |  |  |  |  |  |  |  |  | 6
[NAME] |  |  |  |  |  |  |  |  | 5
Julian |  |  |  |  |  |  |  |  | 4
Nick |  |  |  |  |  |  |  |  | 3
[NAME] |  |  |  |  |  |  |  |  | 2
Guy |  |  |  |  |  |  |  |  | 1
Spreadsheet: fec43418-4ba0-456c-99c7-d6fde276c1e4
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
PNY | Test | PNY | Phenytoin, Total, Serum | Phenytoin, Total, S | Immunoassay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Red top [NAME]: 1 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Therapeutic concentration: 10.0-20.0 mcg/mL Toxic concentration: > or =30.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 1 day | 1 | 80185 |  |  |  |  | Rochester
PNY | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
PNY | Result | 8604 | Phenytoin, Total, S | Phenytoin, Total, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3968-5
Spreadsheet: 0acaf12e-4eef-4867-b84e-041aca2d41ab
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 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35
Center for Student Support and Education Options
Office of Quality School Choice and Funding
SF-6 JVS Form
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FY-20
Report to Certify the Excess Cost for Joint Vocational School Pupils
Who Were Provided Special Education and Related Services
To be filed by [NAME]
Section I
A.
 |  | Joint Vocational School District |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | County |  |  |  |  |  |  |  | IRN
B.
 |  | Resident District - City, Exempted Village, Local or Community School |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | County |  |  |  |  |  |  |  | IRN
C. |  |  |  |  | CAT. 1 |  |  |  | CAT. 2 |  |  |  |  | CAT. 3 |  |  |  | CAT. 4 |  |  |  |  | CAT. 5 |  |  |  | CAT. 6
 |  |  |  |  |  | J
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (major)
 |  |  |  |  |  |  |  |  | (minor)
Section II
Cost Per Pupil for Special Education and Related Services Provided by District A
 |  |  |  |  |  |  |  | Column E |  |  |  |  |  |  |  |  |  |  |  |  |  | Column F |  |  |  | Column G |  |  |  | Column H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Cost |  |  |  | Total FTE |  |  |  | Cost Per Pupil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Students
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Served
Line 1(a) |  |  | Salary-Special Education Teacher(s)
(b) |  |  | Salary-Regular Education Teacher(s)
Line 2 |  |  | Administrator/Supervisor Expense
Line 3 |  |  | Maintenance, Operation Utilities Expense
Line 4 |  |  | Supplies/Material Expense
Line 5 |  |  | Equipment Expense
Line 6 |  |  | Remodeling Expense
Line 7 |  |  | Related Services for ADM
 |  |  | (A)
 |  |  | (B)
 |  |  | (C)
 |  |  | (D)
Line 8 |  |  | Contract Services
Line 9 |  |  | Total (add lines 1-8) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Treasurer Signature
Spreadsheet: 796233d1663166592-multiple-if-formula-with-percentage-calculation-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  | % RENT |  | AMOUNT | TAX |  | TOTAL AMT
 |  |  |  | SALES | CUMULATIVE | % | % | OWING | BREAKPOINT | OWING | AMOUNT | Billed | OWING
 |  |  |  |  | SALES |  |  |  |  |  | 0.13
 |  |  | 2021-09-01 00:00:00 | 184507.95 | 184507.95 | 0.12 | 0.15 | IF(e9>0.01,if(e9*g9,if(f9>n15,if(f9-n15)*h9)0,)0,) | 8333 | 13807.95 | 1795.03 |  | 15602.99
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500000
Spreadsheet: 49679d1249017390-vlookup-401-ded-worksheet-upload-mod-2
Sheet: Export

1 | Doe, [NAME] | 231548649 | 40 | 1000
2 | [NAME], [NAME] | 456898794 | 100 | 1600
4 | [NAME], [NAME] | 907599084 | 40 | 2000
6 | Thompson, Jake | 135829934 | 40 | 1000
7 | Garner, [NAME] | 158364959 | 80 | 800
8 | Holland, Maria | 180899664 | 90 | 800
9 | Graft, Scott | 203449809 | 110 | 600
10 | Topper, [NAME] | 225999954 | 0 | 0
11 | [NAME], [NAME] | 248550099 | 40 | 200
12 | Trully, [NAME] | 271040244 | 120 | 800
13 | Fanta, [NAME] | 293750389 | 40 | 600
14 | Shelton, [NAME] | 311100534 | 40 | 1000
15 | Edwards, [NAME] | 336450679 | 32 | 800
16 | Earhardt, Dale | 361800824 | 75 | 800
17 | [NAME], [NAME] | 383750969 | 55 | 800
18 | Frontal, [NAME] | 406201114 | 32 | 480
19 | Edon, [NAME] | 428781259 | 65 | 320
20 | [NAME], [NAME] | 451301404 | 100 | 1200
21 | Bing, [NAME] | 473821549 | 45 | 1280
22 | [NAME], [NAME] | 496341694 | 76.93 | 1923.2
23 | [NAME], [NAME] | 518861839 | 14.4 | 600
Spreadsheet: 68937d1269466587-rolling-average-of-multiple-cities-rollingtest
Sheet: Sheet2

 |  | 5998 | 0 |  | 775067 | 71
 |  | 67834 | 0 |  | 5182 | 0
 |  | 80352 | 5 |  | 109831 | 24
 |  | 9952 | 0 |  | 127608 | 1
 |  | 46399 | 1 |  | 101995 | 12
 |  | 6687 | 0 |  | 1818 | 0
 |  | 2753 | 1 |  | 4813 | 0
 |  | 4002 | 0 |  | 2736 | 0
 |  | 11704 | 0 |  | 10721 | 3
 |  | 5774 | 0 |  | 1409 | 0
 |  | 2773 | 2 |  | 4952 | 0
 |  | 4002 | 0 |  | 2649 | 0
 |  | 10167 | 1 |  | 10266 | 1
 |  | 6051 | 1 |  | 1266 | 0
 |  | 20685.83333333333 | 0.75 |  | 95731.75 | 9.25
 |  | 21033.25 | 0.8333333333333334 |  | 31998.33333333333 | 3.416666666666667
Spreadsheet: 805789d1668920827-find-the-highest-value-and-return-adjacent-cell-until-value-changes-in-another-cell-book-hd
Sheet: Sheet1

District | Candidates | Votes
D 1 | N1 | 7 |  |  | N3
D 1 | N2 | 11 |  | D 2 | [NAME]
D 1 | N3 | 15 |  | D 3 | N8, N9
D 1 | N4 | 13
D 2 | N5 | 12
D 2 | [NAME] | 16
D 3 | N7 | 18
D 3 | N8 | 20
D 3 | N9 | 20
Spreadsheet: 756963d1637912227-formula-highest-value-sample_screenshot
Sheet: Sheet1

Date | Actual Value | Look up |  |  | Higher value | 100
2020-02-02 00:00:00 | 95 | 1 |  |  | Result | 16
2020-02-03 00:00:00 | 91 | 2
2020-02-04 00:00:00 | 88 | 3
2020-02-05 00:00:00 | 71 | 4
2020-02-06 00:00:00 | 74 | 5
2020-02-07 00:00:00 | 77 | 6
2020-02-08 00:00:00 | 81 | 7
2020-02-09 00:00:00 | 83 | 8
2020-02-10 00:00:00 | 80 | 9
2020-02-11 00:00:00 | 85 | 10
2020-02-12 00:00:00 | 89 | 11
2020-02-13 00:00:00 | 92 | 12
2020-02-15 00:00:00 | 90 | 13
2020-02-16 00:00:00 | 94 | 14
2020-02-17 00:00:00 | 98 | 15
2020-02-18 00:00:00 | 104 | 16
2020-02-19 00:00:00 | 112 | 17
2020-02-20 00:00:00 | 98 | 18
2020-02-21 00:00:00 | 89 | 19
2020-02-22 00:00:00 | 91 | 20
2020-02-23 00:00:00 | 100 | 21
2020-02-24 00:00:00 | 102 | 22
2020-02-25 00:00:00 | 104 | 23
2020-02-26 00:00:00 | 105 | 24
2020-02-27 00:00:00 | 108 | 25
2020-02-28 00:00:00 | 101 | 26
Spreadsheet: 693870d1599193130-summing-multiple-arrays-with-multiple-criteria-inventory_tracker_example
Sheet: Depletion Sheet

 | Product | Current Inventory | Total Weekly Depletions | End of Week Inventory
 | Grain - Silo 1 | 55000
 | Grain - Silo 2 | 36000
 | Grain - Bags | 4000
 | Grain 3 | 2200
 | Grain 4 | 1100
 | Grain 5 | 500
 | Grain 6 | 250
 | Grain 7 | 1150
 | Grain 8 | 55
Spreadsheet: 6af3ad94-ae41-467c-b897-09a4d5440ca5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Determining Family Day Care Home Sponsor’s Monitoring Staff Ratio
Record each staff person’s name whose job description contains monitoring functions. The job description must identify the duties and specific % of time spent on monitoring functions.  (Note: staff time for the annual update of enrollment forms may also be included in the calculation of monitoring functions.)  Record their job title and their FTE (full time equivalent) as a number (1.0 FTE = 40 hrs/week; 0.50 FTE = 20 hrs/week).  Record the % of their job spent on monitoring functions (record in decimal format: if 50%, record as 0.50).
Staff name | Job title (indicate if an active provider) | Total working days per year | Total anticipated monitoring miles for the year | Number of homes with language/literacy barriers needing accommodations | Total number of homes assigned | CACFP FTE (consistent with budget) | Monitoring function percentage. Enter decimal format (.50=50%) | Monitoring FTE
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Totals |  |  | 0 | 0 | 0 |  |  | 0
Highest number of claiming homes during current federal fiscal year |  |  |  |  |  | 0
Divide highest number of claiming homes by total monitoring FTE = staffing ratio |  |  |  |  |  | 0 | Homes per FTE
Sponsors must illustrate that they employ the equivalent of one full time staff person for each 50-150 day care homes. 7CFR 226.16(b)(1)
Spreadsheet: 729550d1619161339-extracting-and-arranging-data-salary-2-
Sheet: Expected Result

 |  |  | Salary | PF | GT | Salary | PF | GT | Salary | PF | GT
Spreadsheet: 27342d1220531661-cross-referencing-multiple-names-in-a-table-perm-access-list
Sheet: Daily Access Request

Date | Onramp | CR Number | Name | DC | Date of Request | Times | CR approved by | Access granted by | Notes
2008-09-02 00:00:00 | y | 446140 | addelosr, bruttenb, apunsala | SJCK | 2008-09-02 00:00:00 | 5pm-11pm pst | davhunte | rasolomo
2008-09-02 00:00:00 | y | 444837 | cyrill | SJC12 | 2008-09-02 00:00:00 | 10am-5pm pst | davhunte | dastarne
2008-09-02 00:00:00 | y | 445904 | addelosr, bruttenb, apunsala | SJCK | 2008-09-02 00:00:00 | 6pm-11:30pm pst | davhunte | dastarne
2008-09-02 00:00:00 | y | HD8640393 | thaong2, rcarlisl | SJCK | 2008-09-02 00:00:00 | 5pm-8pm pst | Break-Fix | dastarne
2008-09-02 00:00:00 | y | 445675 | [NAME], eridavis, mosako, wng, jlira, [NAME], [NAME],  elatchfo, wora, cmallik | RCDN9 | 2-Sep-1-Oct | 5am-5am pst | davhunte | dastarne
2008-09-02 00:00:00 | y | 445549 | stharald, guribe | SJC12 | 2008-09-02 00:00:00 | 5pm-12am pst | davhunte | dastarne
2008-09-02 00:00:00 | y | 444717 | palannin, gematthe, jtheilen, [NAME] or maintain long-term access | SJC20 | 2-Sep-5-Sep | 8am-5pm pst | davhunte | dastarne
2008-09-03 00:00:00 | y | 446140 | addelosr, bruttenb, apunsala | SJCK | 2008-09-03 00:00:00 | 5pm-11pm pst | davhunte | lecrawfo
2008-09-03 00:00:00 | y | 446163 | [NAME], wmeyer, fowens, deaadams, alhar | SJC12 | 2008-09-03 00:00:00 | 5pm-9pm pst | davhunte | lecrawfo
2008-09-03 00:00:00 | y | 446160 | addelosr, brutenb, fowens. | SJC12 | 2008-09-03 00:00:00 | 6:30pm-11pm pst | davhunte | lecrawfo
2008-09-03 00:00:00 | y | 445547 | tomstubb | RCDN9 | 2008-09-03 00:00:00 | 3pm-6am pst | davhunte | lecrawfo
2008-09-03 00:00:00 | y | 445675 | [NAME], eridavis, mosako, wng, jlira, [NAME], [NAME],  elatchfo, wora, cmallik | RCDN9 | 2-Sep-1-Oct | 5am-5am pst | davhunte | lecrawfo
2008-09-03 00:00:00 | y | 445547 | [NAME] | RCDN9 | 2008-09-03 00:00:00 | 3pm-6am pst | davhunte | lecrawfo | CR44547 has been retracted and will be pushed forward a week. Please remove access.
Spreadsheet: 851371d1701605624-creat-title-from-data-bigfish-example
Sheet: Sheet1

 | Subtitles | Values
healthy | Fruit | Apple
healthy | Fruit | Orange | Fruit
healthy | Fruit | Plum | Apple
healthy | Meat | Chicken | Orange
healthy | Vegetables | Potato | Plum
healthy | Vegetables | Onion | Meat
unhealthy | Snack | Chips | Chicken
unhealthy | Snack | Pies | Vegetables
unhealthy | Snack | Biscuits | Potato
unhealthy | Snack | Soft Drink | Onion
 |  |  | unhealthy
 |  |  | Snack
 |  |  | Chips
 |  |  | Pies
 |  |  | Biscuits
 |  |  | Soft Drink
Spreadsheet: sally_beck__33704__basic standards
Sheet: Sheet1

FUNDAMENTAL OPERATING STANDARDS
Structural
Establish and implement business and controls infrastructure
 | - Business unit head has ultimate responsibility to ensure operating standards are met
 | (working in conjunction with Operations and RAC)
 | - Global databases are in place and updated to accommodate business counterparties
 | - Trading/Origination activities and trading limits have been approved and authorized by
 | Enron Management
 | - Credit limits have been defined and approved and capabilities to monitor credit exposure
 | by counterparty in place
 | - Transaction approval process has been defined and communicated
 | - Trader phone lines have taping mechanism in place
Establish segregation of the following duties and define functional responsibilities across
 | offices before the first trade of a particular product is conducted:
 | - Execution
 | - Controls
 | - Review
Transactional
Transactions are recorded accurately and timely
 | - Transactions are recorded with 100% accuracy and valued appropriately in an approved
 | risk system for the applicable product
 | - Transactions are input into appropriate risk system on date of trade
Daily Management P&L and Position reporting is accurate and timely
 | - Reports are 100% accurate at time of issuance (no revisions)
 | - Daily positions and P&L have been approved and signed off by Trading
 | - Reports issued on next day of trading at a commercially pre-determined time
 | - Trading limit violations noted and communicated to management on next day of trading
Timely confirmation and execution of transactions
 | - Confirmation of all brokered trades with brokers by COB on trade date
 | - Confirms sent to/received from counterparties within 24 hours of trade execution and agreed
 | to risk system data
 | - Confirms executed with counterparty within 7 days of trade date with exceptions noted and
 | communicated to management with the associated level of risk for non-execution
 | (I.e. Master Agreement in place, number of trades unexecuted)
Settlements with counterparties occurs accurately and timely
 | - Invoices/Payments agree with contractual terms
 | - All invoices/payments sent to counterparties by/on contractual invoice/payment date
 | - Discrepancies with counterparties are resolved within 30 days of dispute date
 | with material exceptions noted and communicated to management
 | - Overdue cash collections followed up with counterparties within 48 hours of due date
Operating system data matches Risk Systems and General Ledger data
 | - Flash to Actual variances and prior month adjustments cleared within 30 days of identification
 | - All General Ledger accounts are reconciled and outstanding items cleared within 7 workdays
 | subsequent to month-end
Spreadsheet: 112835d1308828897-counting-the-number-of-instances-example
Sheet: Report

Supplier | No. of Order lines delivered | On time to 5 days early | 1 to 2 days late | 3 to 7 days late | Over 7 days late
AAL002 | 6 | 2 | 3 | 1
ALA001 | 1 |  |  | 1
ALD001 | 8 | 5 |  | 3
ALL001 | 3 | 1 | 1 | 1
ALN001 | 1 |  |  | 1
AMB002 | 1 |  |  |  | 1
AND002 | 35 | 10 | 15 | 0 | 10
APP002 | 1 | 1
ATL004 | 17 | 5 | 3 | 9
BAT001 | 1 | 1
BEL002 | 100 | 31 | 66 | 3
CCP001 | 1
CEN001 | 1
[NAME] | 5
CSM001 | 2
DIA001 | 2
ECW001 | 43
ELA001 | 4
FEC001 | 4
GDR001 | 1
GEM001 | 3
HAR006 | 1
HAY003 | 3
HER001 | 29
HIL001 | 4
HIW001 | 1
MET002 | 38
MET004 | 20
MET005 | 3
MID004 | 1
MMG002 | 8
MOR002 | 2
PAR001 | 1
PRE001 | 4
REF001 | 1
REL003 | 2
RIC001 | 5
RON001 | 3
RSC001 | 8
RYC001 | 5
SCH001 | 14
SEV001 | 2
SHA002 | 1
SSS002 | 1
STE001 | 18
TPS001 | 1
TUN001 | 1
TVH001 | 131
WHE001 | 16
Spreadsheet: 7f4470f9-ad8c-462c-8ecd-82ec6ce9f76a
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
TOBPK | Test | TOBPK | Tobramycin, [NAME], Serum | Tobramycin, Peak, S | Enzyme-Multiplied Immunoassay Technique (EMIT) | Plain, Red-Top Tube: Red OR |  |  | 1 | mL | Collection Container/Tube: Red top  Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Serum for a peak level should be drawn 30 to 60 minutes after last dose.  2. Spin down within 2 hours of draw. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | 5.0-12.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 2 days | 1 | 80200 |  |  |  |  | Rochester
TOBPK | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
TOBPK | Result | 6799 | Tobramycin, Peak, S | Tobramycin, Peak, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 4057-6 | Tobramycin^peak:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 753458d1635447585-rank-function-over-multiple-years-test-rank
Sheet: Sheet1

Year | State | Class | Type | Units | Rank  these for the year
2005 | AK | 1 | Recreational | 1000
2005 | AK | 2 | Recreational | 5000
2005 | AK | 3 | Recreational | 1000
2005 | AK |  | Commercial | 5000
2005 | PA | 1 | Recreational | 2800
2005 | PA | 2 | Recreational | 3000
2005 | PA | 3 | Recreational | 500
2005 | PA | 4 | Recreational | 4000
2005 | PA |  | Commercial | 450
2005 | AL | 1 | Recreational | 1500
2005 | AL | 2 | Recreational | 1500
2005 | AL | 3 | Recreational | 1500
2005 | AL |  | Commercial | 3000
2006 | AK | 1 | Recreational | 500
2006 | AK | 2 | Recreational | 40000
2006 | AK | 3 | Recreational | 1000
2006 | AK |  | Commercial | 5000
2006 | PA | 1 | Recreational | 500
2006 | PA | 2 | Recreational | 100
2006 | PA | 3 | Recreational | 100
2006 | PA | 4 | Recreational | 100
2006 | PA |  | Commercial | 450
2006 | AL | 1 | Recreational | 1500
2006 | AL | 2 | Recreational | 1500
2006 | AL | 3 | Recreational | 1500
2006 | AL |  | Commercial | 3000
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: test

Well | Date | pH | EC
 | Sampled | unit | dS/m
1 | 2007-02-20 00:00:00 | 7.4 | 1.92
MTTR Well 1A #2  1000gpm | 2012-03-29 00:00:00 | 7.6 | 2.29
Well #1 | 2013-10-11 00:00:00 | 7.2 | 2.43
Well - 1 | 2014-01-27 00:00:00 | 7.9 | 2.56
Well 1 | 2016-04-01 00:00:00 | 7.64 | 3.06
Well 1 | 2017-05-03 00:00:00 | 7.21 | 3.498
W1 | 2018-05-29 00:00:00 | 7.7 | 3.457
 |  |  |  | absolute references
 |  |  |  | relative references
Spreadsheet: 98038d1297121761-problem-using-formula-to-find-row-numbers-inventory-20test
Sheet: Lists

 | Heads |  | HeadType
 | Carbite |  | Driver
 | Dynacraft |  | Wood
 | Golfsmith |  | Hybrid
 | [NAME] |  | Iron
 | Hyrico |  | Wedge
 | KZG |  | Putter
 | La Jolla
 | [NAME]
 | Makser
 | Maltby
 | Mars
 | SMT
 | Tour Golf
 | U. Tech
 | Wishon
 | Zero Tolarence
 | Infinity
Spreadsheet: 272908d1382544866-filling-alternate-information-duplicate-grendeb
Sheet: Sheet1

Helper Column | COMPANY | FIRST NAME | LAST NAME | TITLE | [NAME] | PHONE NUMBER | EXT | COUNTRY | PARTS TYPE | STATUS
 | ABC | [NAME] | Junior |  |  | [PHONE] | 333 |  | Washer
 | ABC | [NAME] | Junior |  | [EMAIL] |  | 333 | USA
 | ABC | [NAME] | Junior | President |  |  | 333 |  |  | Prospect
 | XYZ | [NAME] | [NAME] |  |  | [PHONE] | 222 | UK
 | XYZ | [NAME] | [NAME] | Senior Engineer
 | XYZ | [NAME] | [NAME] |  | [EMAIL] |  |  |  | Bearings | Customer
 | XYZ | [NAME] | [NAME] | CEO | [EMAIL] |  |  | UK |  | Customer
 | MNO | [NAME] | Cash | Sales | [EMAIL] |  |  | CAD |  | Contact
 | MNO | [NAME] | Cash |  |  | [PHONE] | 444 |  | Bolts
 | EFG | [NAME] | Young | Self Employed | [EMAIL] |  |  | MX |  | Prospect
 |  |  |  | Résultat finale [NAME]
 | COMPANY | FIRST NAME | LAST NAME | TITLE | [NAME] | PHONE NUMBER | EXT | COUNTRY | PARTS TYPE | STATUS
Spreadsheet: 300504d1393496230-how-to-concatenate-start-and-last-values-of-rows-based-on-breaking-of-sequence-book1
Sheet: Sheet1

Apple | 2004 |  | o/p: | Apple | 2004-2007
Apple | 2005
Apple | 2006
Apple | 2007
[NAME] | 2003 |  |  | [NAME] | 2003 | 2001
[NAME] | 2001
Pineapple | 2003 |  |  | Pineapple | 2003-2004
Pineapple | 2004
Water | 1958 |  |  | water | 1958-1960 | 1979-1993 | 1996
Water | 1959
Water | 1960
Water | 1979
Water | 1980
Water | 1981
Water | 1982
Water | 1983
Water | 1984
Water | 1985
Water | 1986
Water | 1987
Water | 1988
Water | 1989
Water | 1990
Water | 1991
Water | 1992
Water | 1993
Water | 1996
Pencil | 2003 |  |  | pencil | 2003-2006 | 2009-2010 | 2012
Pencil | 2004
Pencil | 2005
Pencil | 2006
Pencil | 2009
Pencil | 2010
Pencil | 2012
orange | 1963 |  |  | orange | 1963-1989 | 1994 | 1996
orange | 1964
orange | 1965
orange | 1966
orange | 1967
orange | 1968
orange | 1969
orange | 1970
orange | 1971
orange | 1972
orange | 1973
orange | 1974
orange | 1975
orange | 1976
orange | 1977
orange | 1978
orange | 1979
orange | 1980
orange | 1981
orange | 1982
orange | 1983
orange | 1984
orange | 1985
orange | 1986
orange | 1987
orange | 1988
orange | 1989
orange | 1994
orange | 1996
Yellow | 2007 |  |  | yellow | 2007 | 1996 | 2001
Yellow | 1996
Yellow | 2001
White | 2001 |  |  | white | 2001-2003
White | 2002
White | 2003
Spreadsheet: lynn_blair__24475__PSWE1021
Sheet: Summary

Count of Calls by Pipeline, by Category, by Type
Pipeline | (All)
Count of Type | Type
Category | Adhoc | Internet | Outage | P/S | Password | Printer | Request For Setup | Software | Software - Other | [NAME] | Grand Total
Contracts |  |  |  |  |  |  |  |  |  | 1 | 1
FGT BIZ |  |  |  |  |  |  |  |  |  | 3 | 3
FGT CR |  |  |  |  |  |  |  |  |  | 3 | 3
FGT TM |  |  |  | 18 |  |  | 1 |  |  | 10 | 29
Flow Gas |  |  |  |  | 3 | 2 | 2 |  |  | 2 | 9
HotTap | 1 | 1 | 26 |  | 11 | 5 | 8 |  |  | 15 | 67
LAN/PC |  |  |  |  |  |  |  | 1 |  |  | 1
NNG CR |  |  |  |  |  |  | 1 |  |  |  | 1
NNG TM |  |  |  | 9 |  | 1 | 1 |  |  | 10 | 21
RAS |  |  |  |  | 1 |  |  |  |  | 2 | 3
Software - User |  |  |  |  |  |  |  |  | 1 |  | 1
TW CR |  |  |  |  |  |  |  |  |  | 1 | 1
TW TM |  |  |  | 3 |  |  |  |  |  | 3 | 6
Grand Total | 1 | 1 | 26 | 30 | 15 | 8 | 13 | 1 | 1 | 50 | 146
Spreadsheet: 74138d1274727468-transfering-data-between-workbooks-transferring-data-example
Sheet: Sheet 1

 |  |  |  | Monthly Volume
 | Customer Part Number | Location | Jan | Feb | Mar | April
 | 123AAA | SanMex | 2342 | 1234 | 678 | 732
 | 123BBB | Findlay | 2578 | 1456 | 2156 | 235
 | 123CCC | MtVernon | 3451 | 2321 | 678 | 763