tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1073__Reconstructed Consolidated 2000 Peaker 8-15-00
Sheet: Tax

GENCO FEDERAL TAXES
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
STATE TAXES
Total State Taxes Utilizing NOLs
FEDERAL TAXES
Pretax Book Income
Plus Book Depreciation & Amortization
Less: Tax Depreciation
Less: State Taxes
Federal Taxable Income
Federal Tax Rate
Federal Tax Expense/ (Benefit)
NOL Carryforward
NOL Utilization
Fed Cash Taxes Payable/(Benefit)
Spreadsheet: jonathan_mckay__16833__ T&E form
Sheet: QuickStart

[NAME]
MACROS MUST BE ENABLED IN ORDER TO USE THIS FILE.
If you disabled the macros, close this file, open it again and ENABLE the macros.
This excel file consists of the following 5 tabs (spreadsheets):
[NAME] | The Quick Start sheet provides instruction for completing your T&E reports.
Guidance | The Guidance sheet provides information regarding the T&E Policy.
Data Entry | The Data Entry Sheet is where all the T&E Information will be entered.
Report | The Report Sheet processes the information entered in the Data Entry Sheet and populates a report that can be printed.
Sample T&E Entry Sheet | The Sample T&E Entry Sheet provides you with an example of how to complete the data entry sheet correctly.
Data Entry Sheet
1 | The "Tab" key can be used to move from cell to cell.
2 | All fields highlighted in TEAL must be completed before the data can be processed.
3 | Only select one checkbox for Employee Classification.
4 | Begin entering expense information in cell [NAME].
5 | Every record must have at least an expense description and G/L Code.  Otherwise the
 | information will not be processed.
6 | Use the drop-down boxes to select a G/L Code.  To remove a G/L Code select
 | the blank entry at the bottom of the list.
7 | Do not leave any rows empty between expense information.  Begin entering data in row 20.
 | If you leave blank rows between your information, some information will not be processed.
8 | Once all your information has been entered, click the "Populate Report" button to process
 | your data.  The button will alert you to any omissions or errors in your data.
9 | Print the data entry sheet and report sheets and send them together to the A/P
 | department.
10 | This file must be saved as Microsoft Excel 97 or greater.  If prompted by Excel, DO
 | NOT use the suggested Excel 95 format.
11 | If you wish to clear your entries, click on the "Clear All Fields" button.
12 | Scroll down to row 71 to see total expenses entered and to enter any comments if
 | necessary.
Report Sheet
1 | Once you click the "Populate Report" button, the report will be automatically completed.
2 | You can not make any changes in the Report Sheet.  If there is an error, clear the report
 | by clicking on the "Clear Report" button and then go back to the Data Entry sheet to
 | make any corrections or adjustments.
3 | You must clear the report before processing the same information or new information.
4 | Once the information is correct, click on the "Print Report" button to print the report.
Spreadsheet: 703574d1605061008-some-help-needed-for-an-if-formula-book2
Sheet: Sheet1

Entry Price | Stop Price | Current Price | Current Points | Current Profit/Loss | Latest Stop | Stop Distance | Value Per Pip/Point | Long/Short | Risk Taken | Status
426.87 | 354.84 | 437.02 |  |  |  | 72.03 | 0.03 | Long | 0.01
1061 | 889 | 1012 |  |  |  | 172 | 1.16 | Long | 0.01
246.2 | 309.76 | 265.39 |  |  |  | 6356 | 0.03 | Short | 0.01
Spreadsheet: a2f079b1-49b8-44f6-abe5-4ea879f7de2b
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
BETA2 | Test | BETA2 | [NAME]: Detection of Spinal Fluid in Other Body Fluid | [NAME], BF | Electrophoresis/Immunofixation-Peroxidase Antisera/Dimethylformamide Visualization | Varies: Var |  |  | 0.5 | mL | Sources: Nasal, Otic, etc Collection Container/Tube: Pipet, syringe, test tube, or microcollection device Submission Container/Tube: Plastic vial [NAME]: 0.5 mL Collection Instructions: 1. If submitting a syringe, remove needle. Add cap to end of syringe. 2. If direct collection is not feasible, specimen may be collected using a cotton swab. a. Place cotton swab in as small a container as possible (for example, a tightly-stoppered test tube). b. Do NOT add any additional fluid to swab including, but not limited to, saline or microcollection fluids. c. Tightly seal container. Additional Information:  1. Although results may be obtainable on smaller specimens (perhaps as little as 0.05 mL, depending on the protein concentrations and percentage of spinal fluid in the specimen), reliable results are best obtained with an adequate specimen volume. 2. Indicate specimen type. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK-note to lab Lipemia	NA Icterus	NA Other	NA | Negative, no beta-2 transferrin (spinal fluid) detected | Monday through Saturday; 1 p.m. | 1 day | 3 days | 1 | 86335 |  |  |  |  | Rochester
BETA2 | [NAME] | BODYFL | Body Fluid |  |  |  | Frozen
BETA2 | Result | 80351 | [NAME], BF | [NAME], BF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13876-8 | Beta-2 transferrin:ACnc:Pt:Body fld:[NAME]:
Spreadsheet: 466537d1466261110-look-up-data-from-two-sheets-and-give-a-result-on-a-third-sheet-service-plan-quotes-vs-car-sales-ndm
Sheet: Results

Registration | Plan Quoted | [NAME] | Sales Exec Code
Spreadsheet: 788087d1658259110-implementing-a-few-restrictions-on-a-calendar-excel-shared-prototype-1
Sheet: JAN CAUSAUL (2)

 | Employee Work Availability Schedule
 | Absence Type Key | A | First Choice |  |  | B | Second Choice |  |  | C | Third Choice |  |  | D | Available
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | January | Dates of Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022
 | Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total Days
 | [NAME] |  |  | A |  |  |  | D | D | B | D |  |  |  |  |  | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Online, Individual ExcelSheets
 | [NAME] |  |  | B |  |  |  |  | D | A | D |  |  |  |  | D | C |  |  |  |  |  | D |  | D | D |  |  |  |  |  |  |  |  |  |  | This loads DATA from Online Excel Sheet or CUSTOM WEBSITE DATABASE
 | [NAME] |  |  | C |  |  |  | D | D | B | D |  |  |  |  | D | A |  |  |  |  |  |  |  |  |  | D | D | D | D
 | Jan |  |  | B |  |  |  |  |  | C |  |  |  |  |  |  | A |  |  |  |  |  | D | B | D | D | D |  | D | D
 | [NAME] |  |  | D |  |  |  |  |  | D |  |  |  |  |  | D | D |  |  |  |  |  | D |  | A | B | C | D | D
 | Actual Allocated Person |  |  | SM |  |  |  | SA | CD | CD | SM |  |  |  |  | JM | TS |  |  |  |  |  | TS | JM | SA | CD | SA | SM | TS | JM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Fairness |  |  |  | Compliance
 |  | 1. Count Number of times Initials Appears |  |  |  |  |  |  |  |  |  |  |  | SM |  |  |  | SM |  |  |  | ! Cannot be two consequtive days
 | ! Cannot do two days in a row |  |  |  |  |  |  |  |  |  |  |  |  | CD |  |  |  | CD |  |  |  | ! Cannot Exceed 40 hours weekly (SUN to SAT)
 | ! 40 Hours or LESS per Week | 16 | + | 16 | = | 32 |  |  |  |  |  |  |  | TS |  |  |  | TS
 | ![NAME] is SUN to SAT | 24 | + | 16 | = |  |  |  |  |  |  |  |  | JM |  |  |  | JM
 |  | 24 | + | 24 | = |  |  |  |  |  |  |  |  | SA |  |  |  | SA
 |  | e.g. Sun 1/2 + Sat 1/8
Spreadsheet: 199657d1355276383-combining-multiple-rows-of-data-into-a-single-row-grocery
Sheet: Sheet4

a) Raw data
 |  | Item | Mar | Apr | May | Jun
 |  | [NAME] | 306000 | 0 | 0 | 0
 |  | Apple | 0 | 0 | 0 | 0
 |  | Orange | 22000 | 22000 | 22000 | 0
 |  | Cabbage | 0 | 0 | 0 | 0
 |  | Brocoli | 65000 | 65000 | 65000 | 0
 |  | Carrot | 6000 | 6000 | 6000 | 0
 |  | Sugar | 65000 | 0 | 0 | 0
 |  | Salt | 3300 | 3300 | 3300 | 0
 |  | Vinegar | 0 | 24333 | 30605 | 0
 |  | SUB TOTAL | 467300 | 120633 | 126905 | 0
 |  | TAX | 23365 | 4815 | 4815 | 0
 |  | TOTAL | 490665 | 125448 | 131720 | 0
 |  | RECEIPT | 490665 | 0 | 0 | 0
b) Desired outcome (Rows of data grouped and summed by their category name)
Preset Categories |  | Item | Mar | Apr | May | Jun
 |  | [NAME] | 306000 | 0 | 0 | 0
Fruits |  | Apple | 0 | 0 | 0 | 0
 |  | Orange | 22000 | 22000 | 22000 | 0
 |  | Cabbage | 0 | 0 | 0 | 0
Vegetables |  | Brocoli | 65000 | 65000 | 65000 | 0
 |  | Carrot | 6000 | 6000 | 6000 | 0
 |  | Sugar | 65000 | 0 | 0 | 0
Seasonings |  | Salt | 3300 | 3300 | 3300 | 0
 |  | Vinegar | 0 | 24333 | 30605 | 0
 |  | SUB TOTAL | 467300 | 120633 | 126905 | 0
 |  | TAX | 23365 | 4815 | 4815 | 0
 |  | TOTAL | 490665 | 125448 | 131720 | 0
 |  | RECEIPT | 490665 | 0 | 0 | 0
c) Final Product
 |  | Item | Mar | Apr | May | Jun
 |  | Fruits | 328000 | 22000 | 22000 | 0
 |  | Vegetables | 71000 | 71000 | 71000 | 0
 |  | Seasonings | 68300 | 27633 | 33905 | 0
 |  | SUB TOTAL | 467300 | 120633 | 126905 | 0
 |  | TAX | 23365 | 4815 | 4815 | 0
 |  | TOTAL | 490665 | 125448 | 131720 | 0
 |  | RECEIPT | 490665 | 0 | 0 | 0
Spreadsheet: 241410d1370599867-highlighting-a-variable-number-of-duplicates-example-1-
Sheet: Data

ID | Amount
9087 | 0
9087 | 145
6754 | 0 | duplicate
6754 | 0 | duplicate
6754 | 0 | duplicate
1356 | 0 | duplicate
1356 | 9
1356 | 0 | duplicate
1356 | 0 | duplicate
1356 | 0 | duplicate
123 | 0
Spreadsheet: 103517d1301301583-nested-formula-collection_test
Sheet: BKNG

CUSTOMERWISE BOOKING DETAILS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Executive
Sales Officer |  | [NAME]
Booking Date Range |  | From | 2011-02-01 00:00:00 | To | 2011-02-28 00:00:00 |  |  |  |  |  |  | Report run on
Total Sales for the period
Row Ref | Customer | Address | BKNG Date | Tower | Type | SqFt | Rate | Car Park No | Total Adv | Balance | Installments | Due | AGM
Spreadsheet: 81bfdb9a-5023-4a14-870a-c2abe0d6c923
Sheet: Sheet1

BT Events and/or Submissions to the State Health and Environmental Testing Laboratory from Sentinel Laboratories that Qualify for Reporting to US CDC, Maine, 2001-2011 | Unnamed: 1
Year | Number of Events
2001 | 384*
2002 | 81*
2003 | 36*
2004 | 17
2005 | 10
2006 | 9
2007 | 11
2008 | 7
2009 | 8
2010 | 7
2011 | 10
Data Source:  Maine Health and Environmental Testing Laboratory ([NAME]).
Events included are those that qualified for entry in the US CDC's Laboratory Response Network biological messenger module
Sentinal laboratories are private laboratories that receive substances for public health-related tests, and are required to send certain types of isolates to the Maine HETAl for further testing.  The US CDC provides guidelines as to which of these tests are reported to them.
*In 2003 [NAME] made a concerted effort to provide first responders with guidelines which defined what should be sent for screening and eliminate the “nuisance white powders”. During this same time, sentinel labs were given rule in/ rule out guidelines to determine if they needed to send isolates to [NAME] for further identification of potential bioterrorism agents. These efforts explain the reduction of submissions.
Spreadsheet: 121546d1316136461-how-do-i-automatically-attach-data-to-terms-i-copy-into-excel-team_stats
Sheet: Roster

 | PLAYERS |  |  | PITCHERS
# | Name |  | # | Name
1 | Player 1 |  | 1 | Pitcher 1
2 | Player 2 |  | 2 | Pitcher 2
3 | Player 3 |  | 3 | Pitcher 3
4 | Player 4
5 | Player 5
6 | Player 6
7 | Player 7
8 | Player 8
9 | Player 9
10 | Player 10
11 | Player 11
12 | Player 12
Spreadsheet: 4fded039-c5a0-4a68-8e42-c1c0fd960a5d
Sheet: Sheet1

THE AWESOME W-T-F-ARE-THEY TRAINING TIMETABLE OF AWESOMENESS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Nas/Anya | [NAME] | Eldinot | Dian | [NAME] | Odneis
10th (3h) | Magic (Pt) | Melding (Pl, 1/2) | Study | Magic (Po) | Melding (Pl, 2/2) | Study
13th (3h) | Study | Break | Magic (Po) | Melding (Pl,1/2) | Magic (Pt) | Melding (Pl, 2/2)
16th (1h) | LUNCH BREAK
17th (3h) | Melding (Pl) | Magic (Pt*) | Break | Break | Break | Magic (Po)
20th (3h) | [NAME]
23rd (1h) | DINNER BREAK
24th (3h) | MEETING TIMES
27th (3h) | Break | Study | Melding (Pl, 1/2) | Study | Study | Break
30th (10h) | SLEEP
Studys begin at 10th hour, but breakfast will begin a half hour beforehand.
Aliana, Eldinot, and [NAME] eat alone.
* Plotian is technically assigned to her but since Malis already knows higher spell language, he does not oversee her sessions.
 | MEETING TIME COMBINATIONS
 | Nasanya | [NAME] | Eldinot | Dian | [NAME] | Odneis
Nasanya |  | 1 | 2 | 3 | 4 | 5
[NAME] | 1 |  | 6 | 7 | 8 | 9
Eldinot | 2 | 6 |  | 10 | 11 | 12
Dian | 3 | 7 | 10 |  | 13 | 14
[NAME] | 4 | 8 | 11 | 13 |  | 15
Odneis | 5 | 9 | 12 | 14 | 15
1 | Malis/Nasanya | Eldinot/Dian | [NAME]/Odneis | 1, 10, 15
2 | Eldinot/Nasanya | Aliana/Dian | [NAME]/Odneis | 2, 13, 9
3 | Dian/Nasanya | Aliana/Malis | Eldinot/Odneis | 3, 8, 12
4 | Aliana/Nasanya | Odneis/Dian | Eldinot/Malis | 4, 14, 6
5 | Odneis/Nasanya | Malis/Dian | Eldinot/Aliana | 5, 7, 11
Spreadsheet: phillip_m_love__30654__9902_OA
Sheet: SE-LRC-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  |  |  | 0
 |  | TOTAL
Spreadsheet: 781704d1653496020-years-of-service-for-9-month-employees-fy22-seniority-list
Sheet: Sheet1

91-92
92-93
93-94
94-95
95-96
96-97
97-98
98-99
99-00
00-01
01-02
02-03
03-04
04-05
05-06
06-07
07-08
08-09
09-10
10-11
11-12
12-13
13-14
14-15
15-16
16-17
17-18
18-19
19-20
20-21
21-22
Spreadsheet: 830202d1684774844-excel-help-for-roulette-elad-excel-explained
Sheet: Foglio1

6 | no bet |  |  |  | waiting for 2 numbers from 2 differents splits | the system must track 18 splits
8 | no bet |  |  |  | now excel must create 16 groups of 3 splits each | here they are
17 |  | 1/4 | 3/6 | 8/11 | group 1
 |  | 2/5 | 3/6 | 8/11 | group 2 | 1/4
 |  | 7/10 | 3/6 | 8/11 | group 3 | 2/5
 |  | 9/12 | 3/6 | 8/11 | group 4 | 3/6
 |  | 13/16 | 3/6 | 8/11 | group 5 | 7/10
 |  | 14/17 | 3/6 | 8/11 | group 6 | 8/11
 |  | 15/18 | 3/6 | 8/11 | group 7 | 9/12
 |  | 19/22 | 3/6 | 8/11 | group 8 | 13/16
 |  | 20/23 | 3/6 | 8/11 | group 9 | 14/17
 |  | 21/24 | 3/6 | 8/11 | group 10 | 15/18
 |  | 25/28 | 3/6 | 8/11 | group 11 | 19/22
 |  | 26/29 | 3/6 | 8/11 | group 12 | 20/23
 |  | 27/30 | 3/6 | 8/11 | group 13 | 21/24
 |  | 31/34 | 3/6 | 8/11 | group 14 | 25/28
 |  | 32/35 | 3/6 | 8/11 | group 15 | 26/29
 |  | 33/36 | 3/6 | 8/11 | group 16 | 27/30
 |  |  |  |  |  | 31/34
 |  |  |  |  | now the magic of excel must work | 32/35
 |  |  |  |  | i insert a number in A3 | 33/36
 |  |  |  |  | excel must cancel the group for the number
 |  |  |  |  | lets say 17 is extracted
 |  |  |  |  | group 6 must be canceled
 |  |  |  |  | and so on with each number inserted in excel
Spreadsheet: 96aa30ae-c47e-4e1f-aff8-2934d93fe51f
Sheet: Table 2.5

2.5 Implicit price deflator for non-farm GDP
Quarter | 2010-11 | 2011-12 | 2012-13 | 2013-14 | 2014-15
Index (a) (b)
September | 97.2 | 101.2 | 99.7 | 101.1 | 101.1
December | 97.7 | 100.1 | 99.4 | 101.9
March | 98.9 | 99.8 | 99.9 | 101.8
June | 100.4 | 100.4 | 100.9 | 101.4
Annual average | 98.6 | 100.4 | 100 | 101.5
Quarterly change (b) – per cent
September | 1.039501039501039 | 0.7968127490039812 | -0.6972111553784888 | 0.1982160555004843 | -0.2958579881656916
December | 0.51440329218107 | -1.086956521739139 | -0.3009027081243703 | 0.7912957467853723
March | 1.22824974411464 | -0.2997002997002969 | 0.5030181086519114 | -0.09813542688911533
June | 1.516683518705763 | 0.6012024048096278 | 1.001001001001001 | -0.3929273084479288
Annual change (b) – per cent
September | 7.52212389380531 | 4.115226337448563 | -1.48221343873518 | 1.404212637913727 | 0
December | 6.427015250544676 | 2.456499488229258 | -0.6993006993006867 | 2.515090543259557
March | 6.0021436227224 | 0.9100101112234471 | 0.1002004008016089 | 1.901901901901892
June | 4.365904365904361 | 0 | 0.4980079681274896 | 0.4955401387512381
Annual average | 6.135629709364898 | 1.825557809330647 | -0.3984063745020028 | 1.49999999999999
(a) Ratio of current price non-farm gross domestic product to chain volume
non-farm gross domestic product. Base: 2012-13 = 100.0.
(b) Quarterly figures are seasonally adjusted.
Source:
ABS, Australian national accounts: National income, expenditure and product,
Cat. no. 5206.0
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 4th March 2015
Spreadsheet: d27703ae-64ba-4622-9852-f7f172a3e87b
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
HTR2O | Test | HTR2O | Serotonin Receptor [NAME] (HTR2A and HTR2C), Saliva | Serotonin Receptor 2A/2C, Saliva | Polymerase Chain Reaction (PCR) with Allele-Specific Primer Extension (ASPE) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME] DNA Self-Collection Kit (Supply T651) |  |  | 4 | mL | Multiple saliva genotype tests can be performed on a single specimen after a single extraction. See Multiple Saliva Genotype Tests in Special Instructions for a list of tests that can be ordered together.  Container/Tube: [NAME] DNA Self-Collection Kit (Supply T651)  [NAME]: Full tube  Collection Instructions:  1. Fill tube to line. 2. Send specimen in original container per kit instructions. Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Wednesday; 8 a.m | 2 days | 8 days | 1 | 81479 |  |  |  |  | Rochester
HTR2O | [NAME] | SALIVA | Saliva |  |  |  | Ambient
HTR2O | Result | 32936 | HTR2A -1438G>A | HTR2A -1438G>A | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HTR2O | Result | 32937 | HTR2A 74C>A | HTR2A 74C>A | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HTR2O | Result | 32938 | HTR2A 102 T>C | HTR2A 102 T>C | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HTR2O | Result | 32939 | HTR2A IVS2 A>G | HTR2A IVS2 A>G | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HTR2O | Result | 32940 | HTR2A 1354 C>T | HTR2A 1354 C>T | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HTR2O | Result | 32941 | HTR2C -759 C>T | HTR2C -759 C>T | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HTR2O | Result | 32942 | HTR2C 796 G>C | HTR2C 796 G>C | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HTR2O | Result | 32943 | Reviewed By | Reviewed By | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HTR2O | Result | 32944 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 31b08c7b-c3b8-4808-ab1c-79a1b151b6f3
Sheet: Sheet1

CODIGO SISIN | PROYECTO | LOCALIZACION | DISTRITO | DIST | MONTO
BO5-41809-00000 | CONST. CANCHA DE CESPED SINTETICO U.E. EDUARDO AVAROA I | DISTRITAL D -9 | DISTRITAL | DISTRITAL | 180000
FECHA: | EL ALTO - 2012
 | 2012-05-30 00:00:00
 | LOCALIZACION: | DISTRITAL - 9
 | OFICIALÍA MAYOR DE DESARROLLO HUMANO Y SOCIAL | LIC. ELMER ACOSTA GUZMAN
 | DIRECCION DE EDUCACION | SR. [NAME]
 | RESPONSABLE DE AREA | ARQ. MARIA SHARESKA VASQUEZ SALGUEIRO
 | RESPONSABLE (s)  DE PROYECTO | ARQ.  JUAN CARLOS FLORES CALLEJAS
BO5-41811-00000 | CONST. CANCHA DE CESPED SINTETICO U.E. EDUARDO AVAROA I | POMAMAYA BAJA | DISTRITAL | DISTRITO - 9 | 180000
Spreadsheet: 135626d1326143518-multiple-subtotals-in-pivot-are-not-showing-pivotmultiplesubtotals
Sheet: pivot

SA | (All)
Count of Activity | Column Labels
Row Labels | 1 | 2 | 3 | Grand Total
Blue | 2 | 2 | 3 | 7
Green |  | 1 | 2 | 3
Red | 4 | 3 |  | 7
Grand Total | 6 | 6 | 5 | 17
Desirable Format
Count of Activity | Column Labels
Row Labels | 1 | 2 | 3 | Grand Total | [NAME] | Average
Blue | 2 | 2 | 3 | 7 | 3 | 2.333333333333333
Green |  | 1 | 2 | 3 | 2 | 1.5
Red | 4 | 3 |  | 7 | 4 | 3.5
Grand Total | 6 | 6 | 5 | 17 | 17 | 17