tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 805024d1668490203-not-solved-formula-to-match-1-or-2-columns-and-then-from-a-random-range-upon-matching-select-a-random-value-from-a-list-sub-list-of-matching-data-from-up-to-two-columns
Sheet: Transactions

First Name | Last Name | eMail | Phone | Address | City | Province | Country | PostalCode | Trx Amount | Card Type | Card Number | CVV | TRANSACTION-ROUTING NUMBER
Belle | Abbott | [EMAIL] | (187)525-7166 | 906-7925 Luctus Street | [NAME] | British Columbia | Canada | I0E 2Y3 | 2114.88 | Visa | 4916763263545 | 296 | 490060-90060 | Province matches to British Columbia, for demo purposes, no branch in Williams Lake, therefore, a random city would be chosen, let's say it is Vancouver, since there are multiple branches, let's say the branch in row 29 is now chosen
Bradley | Abbott | [EMAIL] | (283)237-1020 | Ap #306-825 Ante. St. | Nanaimo | British Columbia | Canada | A0B 4K5 | 2882.72 | Visa | 4929783393457 | 503
Byron | Abbott | [EMAIL] | (795)617-2119 | Ap #850-1869 Cursus, St. | Lloydminster | Saskatchewan | Canada | S3S 3B1 | 2900.31 | Visa | 4485484872232 | 409
[NAME] | Abbott | [EMAIL] | (282)786-2446 | 502-3617 At Road | Vancouver | British Columbia | Canada | E4S 6R8 | 1711.54 | Visa | 4539453925228540 | 176 | 404160-04160 | Here the Province of British Columbia is matched, the city Vancouver matches, there are 81 branches, let's say the Dunsmuir and Branch (row 26) randomly chosen.
[NAME] | Abbott | [EMAIL] | (255)405-2589 | 562-3661 Eget, Av. | Sparwood | British Columbia | Canada | E6V 4V9 | 1244.98 | Visa | 4916543265648230 | 276
Ishmael | Stanton | [EMAIL] | (442) 988-8845 | 194-157 A Avenue | [NAME] | Alberta | Canada | T6C 1B1 | 1685.58 | VISA | 4916 9167 8465 5649 | 688
Imogene | Stanton | [EMAIL] | (471) 133-8857 | P.O. Box 914, 2473 Feugiat Av. | Gold Bottom | Yukon | Canada | Y4A 1V0 | 2214.85 | VISA | 4556 9928 7395 1657 | 560
Athena | Stanton | [EMAIL] | (486) 343-6512 | 318-6648 Nulla. Rd. | St. Benedict | Saskatchewan | Canada | S6A 5M9 | 2540.36 | VISA | 4024 0071 5899 7616 | 242
Lewis | Stanton | [EMAIL] | (239) 624-6026 | 1779 [NAME]. St. | Pineview | Alberta | Canada | T5T 4V2 | 2557.14 | VISA | 4532 3547 5255 6413 | 976
Jessica | Stanton | [EMAIL] | (564) 236-8974 | 816-9375 Fermentum Rd. | Sokal | Saskatchewan | Canada | S0B 4T0 | 3857.46 | VISA | 4916 2733 3273 8869 | 818
[NAME] | Stanton | [EMAIL] | (211) 585-4527 | Ap #437-8270 Lectus Avenue | Aishihik | Yukon | Canada | Y6S 3J2 | 4039.64 | VISA | 4916 9534 3636 5277 | 882
Maite | Stanton | [EMAIL] | (777) 266-0635 | Ap #422-6132 Nunc. St. | South Touchwood | Saskatchewan | Canada | S7A 1C8 | 4296.76 | VISA | 4556 2542 7163 6657 | 344
Spreadsheet: 80867d1281031774-count-days-between-dates-open-jobs-count
Sheet: Sheet1

Open Jobs in Days: | <35 Days | 36-60 Days | 61-90 Days
Legal | 3 | 0 | 0
Finance | 2 | 0 | 0
HR | 1 | 0 | 0
TOTAL JOBS | 6 | 0 | 0
Department | Date of Posting
Legal | 2010-06-07 00:00:00
Finance | 2010-07-10 00:00:00
Legal | 2010-07-15 00:00:00
Finance | 2010-07-20 00:00:00
HR | 2010-07-25 00:00:00
Legal | 2010-08-01 00:00:00
Legal | 2010-08-01 00:00:00
Spreadsheet: 272d6f03-c0f0-4504-83c9-a5d152a4e77f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Mortgage Payment Calculator
 | Loan Amount | 350000
 |  |  |  | Note: This calculates the principal and interest portion of a mortgage payment only. Your actual payment may also include property taxes, homeowners insurance and/or PMI.
 | Term (in years) | 30
 | Interest Rate (%) | 0.0625 |  | Monthly Payment | 2155.010201492377
 |  |  |  | (Principal & Interest)
 | Disclaimer:
 | This is an analysis based on the information you have provided in the input section. These are general estimates and should not be used as the sole basis for making financial decisions. Before making saving and investing decisions, consider all of your assets, including, for example, equity in a home, savings accounts, and other investments you may own.
 | ©1999-2010 Financial Finesse, Inc. All rights reserved.
 | This document contains confidential and proprietary information of Financial Finesse, Inc. and is intended solely for use of the intended recipient.
 | Unauthorized reproduction or distribution is strictly prohibited. The information contained in this document is not to be construed as advice.
 | If you have questions about your financial situation, you should contact a financial professional.
Spreadsheet: 216158d1361623736-formula-to-get-the-count-of-items-that-satisfy-two-conditions-book1
Sheet: Sheet1

Product Name | Material Key | Material | Quantity | Amount | Unit Price
TECNIS CL | Z900200210 | TECNIS CL mono 13mm 21.0 | 1 | 364 | 364
TECNIS CL | Z900200220 | TECNIS CL mono 13mm 22.0 | 1 | 364 | 364 |  |  | Product Name | Unit Cost | Units Sold
TECNIS TORIC | ZCT3000210 | TECNIS TORIC 1-PIECE 6.0MM 21.0D | 1 | 740 | 740 |  |  | TECNIS CL | 364 |  | 7
TECNIS CL | Z900200210 | TECNIS CL mono 13mm 21.0 | 1 | 364 | 364 |  |  | TECNIS CL | 220 |  | 6
TECNIS CL | [NAME] | TECNIS CL mono 13mm 22.5 | 1 | 364 | 280 |  |  | TECNIS TORIC | 740 |  | 5
OPO70 | OPO70 | NEXT GENERATION PHACO A-PACK | 24 | 1656 | 69
CARTRIDGES | 1VIPR30 | ONE SERIES ULTRA CARTRIDGE 30/BOX | 2 | 0 | 0
CARTRIDGES | EMERALDC30 | [NAME], 30 bx | 2 | 0 | 0
ENDOSOL | 15020 | [NAME] (10/Box) | 2 | 170 | 85 |  |  | To get a formula to find- how many units of TECNIS CL were sold for 364, how many units of TECNIS CL were sold for 220
CARTRIDGES | PSCST30 | SILVER CARTRIDGE THERMOFORMED TR, 30 BX | 1 | 0 | 0
INSERTER | SILVERT | Silver Series Handpiece (Twist) | 1 | 0 | 0
TECNIS CL | Z900200210 | TECNIS CL mono 13mm 21.0 | 1 | 364 | 364
TECNIS CL | Z900200215 | TECNIS CL mono 13mm 21.5 | 2 | 728 | 364
TECNIS CL | [NAME] | TECNIS CL mono 13mm 22.5 | 1 | 364 | 364
TECNIS CL | Z900200190 | TECNIS CL mono 13mm 19.0 | 1 | 220 | 220
TECNIS CL | Z900200200 | TECNIS CL mono 13mm 20.0 | 1 | 220 | 220
TECNIS CL | Z900200210 | TECNIS CL mono 13mm 21.0 | 2 | 440 | 220
TECNIS CL | [NAME] | TECNIS CL mono 13mm 22.5 | 2 | 440 | 220
TECNIS TORIC | ZCT2250270 | TECNIS TORIC 1-PIECE 6.0MM 27.0D | 1 | 740 | 740
TECNIS TORIC | ZCT2250270 | TECNIS TORIC 1-PIECE 6.0MM 27.0D | 2 | 1400 | 700
TECNIS TORIC | ZCT2250270 | TECNIS TORIC 1-PIECE 6.0MM 27.0D | 4 | 2960 | 740
Spreadsheet: 880385d1728051120-formula-to-count-number-of-entries-upload-2
Sheet: Sheet1

 | Resource | Name of PC | Hours
 | AFBP1 | [NAME]
 | AFBP10 | [NAME]
 | AFBP10 | bushmoob
 | [NAME] | Nobfook Coustab
 | AFBP12 | Caoadonian Soaapabs Main/Banking/Paybooo
 | [NAME] | oCHS
 | AFBP14 | CoS TSA Intabnao
 | AFBP15 | WMCH
 | AFBP16 | Sandwaoo
 | AFBP17 | Basingstoka & Habts
 | AFBP17 | Mid Sussax
 | AFBP2 | Caoadonian Soaapabs
 | AFBP2 | baio Ovabhaads
 | AFBP2 | TCS BD
 | AFBP2 | TCS [NAME]
 | AFBP3 | Mabsay baio
 | AFBP3 | Nobthab Isoas Fabbias
 | AFBP3 | Stockhoom
 | AFBP4 | oambath
 | AFBP4 | MSB
 | AFBP5 | Caoadonian Soaapabs Main/Banking/Paybooo
 | AFBP6 | bTS
 | AFBP7 | bichmond
 | AFBP7 | Wandswobth
 | AFBP8 | Caoadonian Soaapabs Main/Banking/Paybooo
 | AFBP9 | Chabnwood
 | AFBP9 | Windsob
 | AFBP9 | Windsob & Maindanhaad
 | AFBP9 | Woking
 | R2R1 | CSo TSA Intabnao
 | R2R1 | Nobfook
 | R2R1 | baio [NAME]
 | R2R1 | TCS BD
 | R2R1 | TCS BU
 | R2R1 | TCS MD
 | R2R1 | (boank)
 | R2R10 | Mid Suffook & Bababg
 | R2R10 | Nobthoink Fabbias
 | R2R10 | SIT baio Ovabhaads
 | R2R10 | TCS BU
 | R2R10 | (boank)
 | R2R11 | aaoing pabking sabvicas
 | R2R11 | [NAME]
 | R2R11 | Hammabsmith & Fuoham
 | R2R11 | Hounsoow pabking sabvicas
 | R2R11 | [NAME]
 | R2R11 | TCS BU
 | R2R11 | Windsob [NAME]
 | R2R11 | WoA
 | R2R11 | (boank)
 | R2R12 | [NAME]
 | R2R12 | oondon Bobough of bichmond
 | R2R12 | bichmond
 | R2R12 | Sandwaoo
 | R2R12 | TCS BU
 | R2R12 | (boank)
Spreadsheet: 724808d1616400140-sumproduct-adding-date-to-time-range-only-works-for-same-date-production_plan_test_2
Sheet: Production scedule

start date | run time |  |  | working week | [NAME] | fri
2021-02-01 06:30:00 |  | = 11 modules in 74 working hours |  | start work | 06:30:00 | 06:30:00 | start break | break time
 | using sumproduct | using sumifs |  | morning break start | 09:00:00 | 09:00:00 | 09:00:00 | 20
due date before breaks | counting breaks [min] | counting breaks [min] |  | morning break end | 09:20:00 | 09:20:00 | 12:00:00 | 25
 |  |  |  | lunch break start | 12:00:00
 |  |  |  | lunch break end | 12:25:00
 |  |  |  | end work | 15:15:00 | 11:50:00
 |  |  |  | Manually created scedule with correct due dates and times
 |  |  |  | mandag | tirsdag | onsdag | torsdag | fredag |  |  | mandag | tirsdag | onsdag | torsdag | fredag
 |  |  |  | 2021-02-01 06:30:00 | 2021-02-02 06:30:00 | 2021-02-03 06:30:00 | 2021-02-04 06:30:00 | 2021-02-05 06:30:00 |  |  | 2021-02-08 06:30:00 | 2021-02-09 06:30:00 | 2021-02-10 06:30:00 | 2021-02-11 06:30:00 | 2021-02-12 06:30:00
 |  |  |  | 2021-02-01 09:00:00 | 2021-02-02 09:00:00 | 2021-02-03 09:00:00 | 2021-02-04 09:00:00 | 2021-02-05 09:00:00 |  |  | 2021-02-08 09:00:00 | 2021-02-09 09:00:00 | 2021-02-10 09:00:00 | 2021-02-11 09:00:00 | 2021-02-12 09:00:00
 |  |  |  | 2021-02-01 09:20:00 | 2021-02-02 09:20:00 | 2021-02-03 09:20:00 | 2021-02-04 09:20:00 | 2021-02-05 09:20:00 |  |  | 2021-02-08 09:20:00 | 2021-02-09 09:20:00 | 2021-02-10 09:20:00 | 2021-02-11 09:20:00 | 2021-02-12 09:20:00
 |  |  |  | 2021-02-01 12:00:00 | 2021-02-02 12:00:00 | 2021-02-03 12:00:00 | 2021-02-04 12:00:00 |  |  |  | 2021-02-08 12:00:00 | 2021-02-09 12:00:00 | 2021-02-10 12:00:00 | 2021-02-11 12:00:00
 |  |  |  | 2021-02-01 12:25:00 | 2021-02-02 12:24:59.995000 | 2021-02-03 12:24:59.995000 | 2021-02-04 12:24:59.995000 |  |  |  | 2021-02-08 12:24:59.995000 | 2021-02-09 12:24:59.995000 | 2021-02-10 12:24:59.995000 | 2021-02-11 12:24:59.995000
 |  |  |  | 2021-02-01 15:15:00 | 2021-02-02 15:15:00 | 2021-02-03 15:15:00 | 2021-02-04 15:15:00 | 2021-02-05 11:50:00 |  |  | 2021-02-08 15:14:59.995000 | 2021-02-09 15:14:59.995000 | 2021-02-10 15:14:59.995000 | 2021-02-11 15:15:00 | 2021-02-12 11:50:00
 | expected results
due date incl. Breaks  using sumproduct | break minutes | expected due date
 | 45
 | 45
 | 20
 | 45
 | 25
 | 40
 | 25
 | 45
 | 45
 | 45
 | 20
Spreadsheet: 675174d1588182886-using-pivot-tables-and-extracting-proper-columns-when-double-clicking-2020-04-29-oeldere2-althepal78-pt-675097d1588163486-using-pivot-tables-and-extracting-proper
Sheet: Oeldere

Position | RANK | LNAME | FNAME | column | date | activity | need / don't |  | activity | Fifle
1 | CAP | OAKLEY | [NAME] | 3 | 2019-01-06 00:00:00 | Fifle | Need
2 | 1LT | XAVIER | [NAME] | 1 | 2019-02-04 00:00:00 | Fifle | Need |  | Aantal van date
3 | 2LT | MAGNUS | ULTRA | 3 | 2019-02-04 00:00:00 | Fifle | Need |  | Position | RANK | Totaal
11 | PVT | STARKS | [NAME] | 2 | 2019-02-15 00:00:00 | Fifle | Need |  | 1 | CAP | 1
6 | SSGT | BEE | BUMBLE | 2 | 2019-01-06 00:00:00 | Fifle | Need |  | 2 | 1LT | 1
7 | SGT | MORRIS | NATHANIEL | 3 | 2018-02-05 00:00:00 | Fifle | Need |  | 3 | 2LT | 1
7 | SGT | [NAME] | [NAME] | 2 | 2017-06-19 00:00:00 | Fifle | Need |  | 6 | SSGT | 1
8 | CPL | EWING | PATRICK | 3 | 2019-02-19 00:00:00 | Fifle | Need |  | 7 | SGT | 2
8 | CPL | WITHERSPOON | REESE | 2 | 2017-06-19 00:00:00 | Fifle | Need |  | 8 | CPL | 2
11 | PVT | JONES | JESSICA | 4 | 2018-10-28 00:00:00 | Fifle | Need |  | 9 | [NAME] | 2
9 | [NAME] | MASON | ANTHONY | 1 | 2018-02-05 00:00:00 | Fifle | Need |  | 10 | PFC | 2
9 | [NAME] | STARKS | [NAME] | 3 | 2019-02-20 00:00:00 | Fifle | Need |  | 11 | PVT | 3
10 | PFC | AMERICA | CAPTAIN | 1 | 2014-05-14 00:00:00 | Fifle | Need |  | Eindtotaal |  | 15
10 | PFC | [NAME] | BLACK | 2 | 2019-02-18 00:00:00 | Fifle | Need
11 | PVT | BANNER | BRUCE | 3 | 2018-07-16 00:00:00 | Fifle | Need
1 | CAP | OAKLEY | [NAME] | 3 | 2019-01-06 00:00:00 | Swim | don't need
2 | 1LT | XAVIER | [NAME] | 1 | 2012-02-04 00:00:00 | Swim | Need
3 | 2LT | MAGNUS | ULTRA | 3 | 2019-02-04 00:00:00 | Swim | don't need
11 | PVT | STARKS | [NAME] | 2 | 2019-02-15 00:00:00 | Swim | don't need
6 | SSGT | BEE | BUMBLE | 2 | 2019-01-06 00:00:00 | Swim | don't need
7 | SGT | MORRIS | NATHANIEL | 3 | 2018-02-05 00:00:00 | Swim | don't need
7 | SGT | [NAME] | [NAME] | 2 | 2017-06-19 00:00:00 | Swim | Need
8 | CPL | EWING | PATRICK | 3 | 2019-02-19 00:00:00 | Swim | don't need
8 | CPL | WITHERSPOON | REESE | 2 | 2017-06-19 00:00:00 | Swim | Need
11 | PVT | JONES | JESSICA | 4 | 2018-10-20 00:00:00 | Swim | don't need
9 | [NAME] | MASON | ANTHONY | 1 | 2018-02-05 00:00:00 | Swim | Need
9 | [NAME] | STARKS | [NAME] | 3 | 2019-02-20 00:00:00 | Swim | don't need
10 | PFC | AMERICA | CAPTAIN | 1 | 2014-05-14 00:00:00 | Swim | Need
10 | PFC | [NAME] | BLACK | 2 | 2019-02-18 00:00:00 | Swim | don't need
11 | PVT | BANNER | BRUCE | 3 | 2015-10-20 00:00:00 | Swim | Need
Spreadsheet: 42486d1241038072-making-a-calculation-based-on-two-input-variables-weightloss-calculator
Sheet: Sheet1

Weight loss calculator
 |  |  |  | [NAME] | [NAME]
Height (in) | 73.5 |  | Sedentary | 2677.44 | 2234.04 | Little to no exercise
Weight (lbs) | 225 |  | Light | 3067.9 | 2559.8375 | Light exer. 1-3 days a week
Age (years) | 25 |  | Moderate | 3458.36 | 2885.635 | Moderate exer. 3-5 days a week
 |  |  | Active | 3848.82 | 3211.4325 | Hard exercise 6-7 days a week
Male BMR | 2231.2 |  | Very Active | 4239.28 | 3537.23 | Very hard exercise plus physical job, etc.
Female BMR | 1861.7
 |  |  |  | Male | Female
Input your height, weight, and age into the above table to adjust the numbers. |  |  | Sedentary | 2177.44 | 1734.04 | Number of calories you should consume per day to lose 1 pound of body fat per week assuming that lifestyle.
 |  |  | Light | 2567.9 | 2059.8375
 |  |  | Moderate | 2958.36 | 2385.635
 |  |  | Active | 3348.82 | 2711.4325
 |  |  | Very Active | 3739.28 | 3037.23
 |  |  |  | Choose (M/F): | Male
 |  |  |  | Choose lifestyle: | Sedentary
 |  |  |  | Calories/Week:
Spreadsheet: 165634d1341308507-lock-protect-another-cell-a-range-of-cells-for-specific-value-of-one-cell-development_swing-ticket-20120703_beta
Sheet: SwingTicketData

PrintshopID | DateInSystem | CustOrgID | CustPONumber | POCtrlNo | ShippingMethodCode | VendorRefCode | Courier | CourierAcctNo | VendorRef | ShipToOrgName | ShipToContactName | ShipToAddress1 | ShipToAddress2 | ShipToAddress3 | ShipToCity | ShiptoState | ShiptoZip | ShipToCountryCode | ShipToCountryName | ShipToPhone | [NAME] | ShipToEmail | VendorRef | DetailCtrlNo | SBOrigCode | CustItemCode | Quantity | UOM | OrderWeight | ItemCtrlID | PrimarySize | SecondarySize | PantoneCode | MSRP | UPC | InforLine1 | Color | Story | StyleNumber | XPartSets
Z56 | 2012-06-01 00:00:00 |  | 1063710 |  | REGULAR | 05254 |  |  | 1063710 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 000000 | AQ | ANTARCTICA | 0 | 0 | 0 |  |  |  | ST/L2101OT | 20 |  |  |  | 8 | SHORT FIT | 2716C | 99.99 | 86535763 | [NAME] | BLUE MIX | Story Desc Test | T32/5089
Z56 | 2012-06-01 00:00:00 |  | 1063710 |  | REGULAR | 05254 |  |  | 1063710 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 000000 | AQ | ANTARCTICA | 0 | 0 | 0 |  |  |  | ST/L2101OT | 12 |  |  |  | 30 | MEDIUM/LONG | 702C |  | 77987689 | [NAME] | BLUE MIX |  | T32/5089 | 2 PART SET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | remark: print size X - Y onto left and right size block if there is "-", print "-" across the two upper size blocks
remark: Z56 refers to Brilliant |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | remark: texts print to next line after "/" within same size block |  |  |  | remark: Concatenate "Dept" + "/" + "SupplierCode" + "/" + "Stroke"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | remark: secondary size is printed at lower part size block. when there is "-", print size in cm on the left size block, print size in inch on the right size block |  |  |  |  |  |  | remark: concatenate "Dept" + "Stroke"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | remark: When there is "/", use two pantone colors on 4 size blocks, the former for the upper left, the later one for upper right size block.
Spreadsheet: 787448d1657802867-index-formula-to-pick-up-one-or-other-column-index-example-1-
Sheet: Sheet2

 | Desired Resutls | Current Formula
Reference | Owner | Owner
1 | [NAME]
2 | [NAME]
3 | Avengers
4 | [NAME]
5
6
Spreadsheet: 0ccbf756-47aa-4c14-9ffd-341f6061dd9e
Sheet: Exhibit B - % of Subcontracting

Attachment 7
DE-SOL-0003816
Percentage of Subcontracting - See FAR 52.219-14
Amendment 000004
Description | Base Year 1 | % of | Option Year 1 (Year 2) | % of | Option Year 2 (Year 3) | % of | Option Year 3 (Year 4) | % of | Option Year 4 (Year 5) | % of | Total Option | % of | Total Contract | % of
 |  | Total |  | Total |  | Total |  | Total |  | Total | Years | Total |  | Total
Total Proposal:
Prime Contractor Fully-Loaded Labor | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Teaming Partner(s) Fully-Loaded Labor (if applicable)
Subcontractor(s) Fully-Loaded Labor
Travel
Materials
Other Direct Costs
Total Proposal | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0
Proposed Fully-Loaded Labor, Exclusive of Fee:
Prime Contractor Fully-Loaded Labor | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Teaming Partner(s) Fully-Loaded Labor (if applicable)
Subcontractor(s) Fully-Loaded Labor
Total Proposed Labor | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0
Proposed Direct Productive Labor Hours (DPLH):
Prime Contractor DPLH | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Teaming Partner(s) [NAME] (if applicable)
Subcontractor(s) DPLH
Total Proposed DPLH | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 797713d1664093269-replace-spaces-of-more-than-one-with-a-comma-resolved-and-a-space-replace-spaces-in-address
Sheet: Sheet1

Address
House Manor                  off manor [NAME]Posherton                            Poshshire
24 House Way               Estate Place                   The Shire                    Middle Earth
13 Halloween Drive               Scaryville          Booshire
Spreadsheet: 633b082e-b02d-4781-acb2-21d7a13450b0
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
HG | Test | HG | Mercury, Blood | Mercury, B | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 1 | mL | Container/Tube: Royal blue-top (EDTA) [NAME] plastic trace element blood collection tube, catalog #368381 (Supply T183) [NAME]: Full tube Collection Instructions: 1. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 2. Send specimen in original tube. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	Green-top (heparin) tube | Normal: 0-9 ng/mL Reference values apply to all ages. | Monday through Friday; 8 a.m.-2 p.m., Saturday; 8 a.m.-3 p.m. Continuously | 1 day | 3 days | 1 | 83825 |  |  |  |  | Rochester
HG | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 21 days
HG | Result | 8618 | Mercury, B | Mercury, B | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 5685-3 | Mercury:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 62706d1263610617-league-spreadsheet-ccfsa_2010_league
Sheet: Results

Week | 2 | results |  |  |  |  |  |  | data entry |  | enter week number in B1
number of pairings |  | 6
team # | team name | rank | team members | previous average | Score | Spot | adj. Score | X's | points won | VS | team # | team name | rank | team members | previous average | Score | Spot | adjusted Score | x's | points won
 | 1
12 | Twisted_Up | 1 | [NAME] | 299 | 296 | 0.8 | 296.8 | 34 | 0 |  | 1 | McNellys_Rangers | 1 | [NAME] | 300 | 300 | 0 | 300 | 56 | 1
 |  | 2 | [NAME] | 294 | 295 | 4.800000000000001 | 299.8 | 29 | 0 |  |  |  | 2 | [NAME] | 300 | 300 | 0 | 300 | 52 | 1
 |  | 3 | Palmer Addison | 274 | 269 | 0 | 269 | 13 | 0 |  |  |  | 3 | [NAME] | 0 | 300 | 219.2 | 519.2 | 47 | 1
 | 2
11 | Rut_Necks | 1 | [NAME] | 300 | 0 | 0 | 0 | 0 | 0 |  | 2 | Spot_Smokers | 1 | [NAME] | 300 | 299 | 0 | 299 | 50 | 1
 |  | 2 | [NAME] | 0 | 258 | 240 | 498 | 8 | 1 |  |  |  | 2 | [NAME] | 300 | 300 | 0 | 300 | 47 | 0
 |  | 3 | [NAME] | 0 | 295 | 229.6 | 524.6 | 31 | 1 |  |  |  | 3 | [NAME] | 287 | 284 | 0 | 284 | 24 | 0
 | 3
3 | Killer_Vs | 1 | [NAME] | 295 | 293 | 4 | 297 | 25 | 0 |  | 10 | Fletched_Tite | 1 | [NAME] | 300 | 300 | 0 | 300 | 56 | 1
 |  | 2 | [NAME] | 281 | 300 | 0 | 300 | 48 | 0 |  |  |  | 2 | Don French | 0 | 230 | 224.8 | 454.8 | 12 | 1
 |  | 3 | [NAME] | 278 | 288 | 0 | 288 | 19 | 0 |  |  |  | 3 | [NAME] | 0 | 280 | 222.4 | 502.4 | 26 | 1
 | 4
9 | Spots_with_Speed | 1 | [NAME] | 289 | 281 | 8 | 289 | 20 | 0 |  | 4 | Passing_Time | 1 | [NAME] | 299 | 300 | 0 | 300 | 51 | 1
 |  | 2 | [NAME] | 280 | 244 | 15.2 | 259.2 | 12 | 1 |  |  |  | 2 | [NAME] | 299 | 0 | 0 | 0 | 0 | 0
 |  | 3 | [NAME] | 236 | 205 | 50.40000000000001 | 255.4 | 7 | 0 |  |  |  | 3 | [NAME] | 299 | 300 | 0 | 300 | 50 | 1
 | 5
5 | Lucky_Stables | 1 | [NAME] | 258 | 262 | 33.6 | 295.6 | 14 | 0 |  | 8 | Out_of_Towners | 1 | [NAME] | 300 | 300 | 0 | 300 | 47 | 1
 |  | 2 | Heather Ellis | 231 | 210 | 55.2 | 265.2 | 7 | 0 |  |  |  | 2 | [NAME] | 300 | 300 | 0 | 300 | 47 | 1
 |  | 3 | [NAME] | 0 | 295 | 0 | 295 | 36 | 0 |  |  |  | 3 | [NAME] | 0 | 300 | 0 | 300 | 1 | 1
 | 6
7 | RDs_Whitetails | 1 | [NAME] | 299 | 300 | 0 | 300 | 49 | 1 |  | 6 | Wise_Guys | 1 | [NAME] | 287 | 284 | 9.600000000000001 | 293.6 | 23 | 0
 |  | 2 | [NAME] | 298 | 300 | 0 | 300 | 48 | 1 |  |  |  | 2 | [NAME] | 277 | 252 | 16.8 | 268.8 | 11 | 0
 |  | 3 | [NAME] | 267 | 248 | 4.800000000000001 | 252.8 | 12 | 0 |  |  |  | 3 | [NAME] | 273 | 267 | 0 | 267 | 18 | 1
 | This sheet compares the results entered on the Scores Sheet for the week selected above and calculates who gets points
 | The points then need to be entered manually for each player in the Scores sheet.
 | No data entry here! All scores and points are entered on the Scores sheet!!
Spreadsheet: 103053d1300896531-delimited-break-out-into-rows-instead-of-columns-example
Sheet: Format i need

Zone | Event
02-01 | TTTTTTTTT2_607_RVR
02-01 | CARFAAILOMG00016845N
02-01 | COWRD0BDBB0000000D
06-01 | HELLOYOUS_888D_99N
06-01 | MOOOOOO_777D_11D
06-01 | ZZZYYYYYY_666D_11K
06-01 | ZZZZZZZZZ_999D_RVR
06-01 | ZYWXABCD_916B_99D
06-01 | ABCDEFGHI_082__RRR