tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 217144d1361992263-problems-with-index-and-match-formula-sample-worksheet
Sheet: A

 | Period | Yellow | Blue | Red | Green | Black
 | Q1 | 10 | 20 | 30 | 40 | 50
 | Q2 | 60 | 70 | 80 | 90 | 100
 | Q3 | 110 | 120 | 113 | 125 | 112
 | Q4 | 123 | 335 | 884 | 588 | 989
Spreadsheet: 144754d1331128608-highlighting-a-row-with-the-current-date-0180
Sheet: Visum

Fyll i vilket datum visumet går ut i resp. ruta för varje enskild person och land.
Land | [NAME] | Lars | Uffe | Billy | Anders | [NAME] | Magnus | Ralf | [NAME] | [NAME] | Per
A
[NAME]
Argentina
B
Belgien
Brasilien
C
Colombia
Costa Rica
Canada
D
Danmark
E
Egypten
Estland
F
[NAME]
Finland
Frankrike
Förenade Arabemiraten
G
Grekland
H
Holland
Hong Kong
I
Indien |  |  |  | 2012-12-19 00:00:00 |  | 2012-03-20 00:00:00 |  | 2012-10-18 00:00:00
Indonesien
Iran
Irak
Italien
J
Jemen
Jordanien
Japan
K
[NAME] |  |  | 2012-02-19 00:00:00 |  | 2012-02-19 00:00:00
Korea
Kroatien
Kuwait
L
M
Malaysia
Marocco
Mexico
N
Norge
O
P
Pakistan
Portugal
[NAME]
Q
Quatar
R
[NAME]
Ryssland |  | Har ej |  |  | Har ej |  | 2012 02 11 |  |  | 24.11.12
S
Saudi Arabia
Singapore
Spanien
[NAME]
T
Taiwan
Thailand
[NAME]
Tyskland
Tunisien
Turkiet
U
USA
UK
V
Venezuela |  |  |  |  |  |  | 2012-11-06 00:00:00
Vitryssland
X
Y
Z
Å
Ä
Ö
Österrike
Spreadsheet: andy_zipper__101__EOL Prospects2
Sheet: Product List

Products: (bold indicates commodity)
2EH
Acetic Acid
Acetone
Acrylonitrile
Alkylates
Ammonia
AMS
Benzene
Black Concentrate
Butadiene
Bunker Fuel
Caprolactam
Caustic Soda
Condensate
Cumene
Cyclohexane
DAP
Demethanized Mix
Diesel
DOP
EDC
[NAME]
Ethanol
Ethylbenzene
Ethylene
Ethylene Glycol
EVA
Fuel Oil
[NAME]
Heating Oil
Hexane
Isobutane
[NAME]
Light Cycle Oil
MAP
Methanol
[NAME]
MTBE
N-Butane
N-Butanol
Natural Gasoline
Naphtha
Orthoxylene
[NAME]
PET
Phenol
Polyethylene
[NAME]
Polystyrene
Potash
Propane
Propylene
[NAME]
PTA
PVC
PyGas
Raffinate
Raffinate (1 and 2)
Styrene
Titanium Dioxide
Toluene
Urea
VGO
VCM
Spreadsheet: 805162d1668557328-horizontal-middle-data-sequencing-horizontal-sequencing-example
Sheet: Sheet1

 | 01.02.21.01 | 01.02.22.01 | 01.02.23.01 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.02 | 01.02.22.02 | 01.02.23.02 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.03 | 01.02.22.03 | 01.02.23.03 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.04 | 01.02.22.04 | 01.02.23.04 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.05 | 01.02.22.05 | 01.02.23.05 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.06 | 01.02.22.06 | 01.02.23.06 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.07 | 01.02.22.07 | 01.02.23.07 | 24 | 25 | 26 | 27 | 28 | 29
 | 01.02.21.08 | 01.02.22.08 | 01.02.23.08 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  | G'day,
 |  |  |  |  |  | I have a numbering convention that needs to be adhered to and i am able to perform the sequencing vertically since its the last two digits that need to change vertically, but allowing the 3rd set of digits within the cell to sequence horizontally without changing the last set of digits doesn't seem to work for me. The example data is as follows:
 |  |  |  |  |  | 01.01.01.01  01.01.02.01  01.01.03.01
 |  |  |  |  |  | 01.01.01.02  01.01.02.03  01.01.03.02
 |  |  |  |  |  | 01.01.01.03  01.01.02.03  01.01.03.03
 |  |  |  |  |  | When I autofill vertically its fine but it wont let me begin the first cell in the row to sequence horizontally.
 |  |  |  |  |  | Any insight or solutions are greatly appreciated.
Spreadsheet: bf76ff53-d62d-4e04-883c-de61f3c4a971
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
L3AFP | Test | L3AFP | Alpha-Fetoprotein (AFP) L3% and Total, Hepatocellular Carcinoma Tumor Marker, Serum | AFP-L3% and Total AFP, S | Isotachophoresis with Laser-Induced Fluorescence | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Collection Container/Tube: Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 0.5 mL | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | <10% | Monday, Wednesday, Friday; 10 a.m. | Same day/1 day |  | 1 | 82107 |  |  |  |  | Rochester
L3AFP | [NAME] | SERUM | Serum |  |  |  | Frozen | 90 days
L3AFP | Result | TAFP | Total AFP, S | Total AFP, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 1834-1 | Alpha-1-Fetoprotein:MCnc:Pt:Ser/Plas:Qn:
L3AFP | Result | L3 | %L3 | %L3 | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 42332-7 | Alpha-1-Fetoprotein.L3/Alpha-1-Fetoprotein.total:MFr:Pt:Ser/Plas:Qn:
L3AFP | Result | INT67 | Interpretation | Interpretation | Alphanumeric
Spreadsheet: 159592d1338767004-vlookup-to-return-value-from-table-question2
Sheet: Sheet1

FR
Write a formula in column B to look up the owner from the Reference Table.
 |  |  |  |  |  | Reference Table
ID | Owner |  |  |  |  | ID | Owner
OP123457 |  |  |  |  |  | OP123455 | Kathi
OP123461 |  |  |  |  |  | OP123456 | [NAME]
OP123468 |  |  |  |  |  | OP123457 | [NAME]
OP123459 |  |  |  |  |  | OP123458 | [NAME]
OP123455 |  |  |  |  |  | OP123459 | [NAME]
OP123482 |  |  |  |  |  | OP123460 | [NAME]
OP123489 |  |  |  |  |  | OP123461 | Kirstin
OP123492 |  |  |  |  |  | OP123462 | Wellsley
OP123468 |  |  |  |  |  | OP123463 | [NAME]
OP123484 |  |  |  |  |  | OP123464 | Emily
OP123462 |  |  |  |  |  | OP123465 | [NAME]
OP123485 |  |  |  |  |  | OP123466 | [NAME]
OP123479 |  |  |  |  |  | OP123467 | [NAME]
OP123491 |  |  |  |  |  | OP123468 | [NAME]
OP123456 |  |  |  |  |  | OP123469 | LouAnne
OP123461 |  |  |  |  |  | OP123470 | Brett
OP123463 |  |  |  |  |  | OP123471 | Scott
OP123468 |  |  |  |  |  | OP123468 | Rathika
OP123468 |  |  |  |  |  | OP123473 | Rachel
OP123459 |  |  |  |  |  | OP123474 | Kathi
OP123455 |  |  |  |  |  | OP123475 | [NAME]
OP123482 |  |  |  |  |  | OP123476 | [NAME]
OP123489 |  |  |  |  |  | OP123477 | [NAME]
OP123492 |  |  |  |  |  | OP123478 | [NAME]
OP123481 |  |  |  |  |  | OP123479 | [NAME]
OP123468 |  |  |  |  |  | OP123480 | Kirstin
OP123484 |  |  |  |  |  | OP123481 | Wellsley
OP123462 |  |  |  |  |  | OP123482 | [NAME]
OP123485 |  |  |  |  |  | OP123483 | Emily
OP123479 |  |  |  |  |  | OP123484 | [NAME]
OP123491 |  |  |  |  |  | OP123485 | [NAME]
OP123456 |  |  |  |  |  | OP123486 | [NAME]
OP123461 |  |  |  |  |  | OP123487 | [NAME]
OP123456 |  |  |  |  |  | OP123488 | LouAnne
OP123461 |  |  |  |  |  | OP123489 | Brett
OP123463 |  |  |  |  |  | OP123490 | Scott
OP123468 |  |  |  |  |  | OP123491 | Rathika
OP123489 |  |  |  |  |  | OP123492 | Rachel
Spreadsheet: 390278d1429580902-if-function-confusion-receivables-overdue
Sheet: Documentation

Ward Consulting
Author | [NAME]
Date | 2015-04-01 00:00:00
Purpose | To age Accounts Receivable and prepare summary reports
Data Definition Table
Field | Description | Data Type | Notes
Invoice Nbr | Invoice number | Number
Company | Name of company | Text
Sales Rep | Name of sales representative | Text
Sales Rep Commission | Commission for sales rep | Number | Lookup up commission rate using sales rep name
Invoice Date | Date of invoice | Date | Enter dates using [NAME]/dd/yyyy
Invoice Amount | Amount of invoice | Number | Accounting format with two decimal places
Days Past Due | Number of days invoice past due | Number | Invoice past due if (current date - invoice date)  - 30 is greater than 30 days. Enter 0 if invoice not overdue
Current | Invoice amount is current | Number | Accounting format with two decimal places
1-30 days | Invoice amount is overdue 1-30 days | Number | Accounting format with two decimal places
31-60 days | Invoice amount is overdue 31-60 days | Number | Accounting format with two decimal places
61-90 days | Invoice amount is overdue 61-90 days | Number | Accounting format with two decimal places
Over 90 days | Invoice amount is overdue over 90 days | Number | Accounting format with two decimal places
Spreadsheet: 871659d1718087623-filter-unique-value-and-sort-from-filtered-data-in-multiple-sheet-consolidated-ledger-report-2024-25
Sheet: Old Data Customer List

Sl. No. | Name | Amtt. DR | Amtt. CR | Balance | Ledger
 | [NAME] (Caterer)
 | [NAME]
 | Amit Dwivedi
 | Anand Tripathi
 | [NAME]
 | [NAME] (Inspector)
 | [NAME]
 | Deepak [NAME] ([NAME])
 | Dinesh Pandey (Volkswagen)
 | Guddu (Tile Mistri)
 | [NAME]
 | [NAME]
 | M/s Abhilasha Enterprises,Rudrapur (Abhinav Mishra AGL)
 | M/s Anjneya Construction ([NAME])
 | M/s Indian Builder-Vikki
 | M/s Prabha Marbles
 | M/s Rassian Contractor
 | M/s Redbeam Industries Pvt. Ltd.
 | M/s Rosette Interior Designers ([NAME])
 | M/s Shambhavi Infotech
 | [NAME] Associate
 | [NAME]
 | O P Tiwari
 | [NAME]
 | [NAME]
 | Pratyam Bajpai (Dinesh Pandey)
 | Raju Prasad (Masterji)
 | [NAME]
 | [NAME]
 | Ravindra Chaudhary (Vidhayakji)
 | Shailu
 | [NAME]
 | UPRNN
 | Uttam Singh
 | [NAME]
 | 0
Spreadsheet: darrell_schoolcraft__7585__imball0112
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -4662 | -5000
2 | -17042 | -16843
3 | -17090 | -16843
4 | -10627 | -10000
5
6
7 | -9835 | -9656
8
9 | -12907 | -13000
10 | -6318 | -6000
11 | -5383 | -4262
12
13
14
15 |  | 10000
16 | -12589
17 | -25789 | -25000
18 | -6724 | -6666
19 | -12435 | -12000
20 | -22170 | -22000
21
22
23
24
25
26 |  | -6000
27 | -37828 | -33834
28 | -3761 | -5760
29 | -12221 | -12131
30
31
2001-11-30 00:00:00 |  |  | -85517.91
2001-12-29 00:00:00
CBS Volume
 |  |  | -41313
Spreadsheet: danny_mccarty__4630__Cunn Base Gas Alt
Sheet: Alternatives

 |  |  |  |  |  | Privileged & Confidential
 |  |  |  |  |  | Subject to Litigation
CUNNINGHAM BASE GAS ALTERNATIVES
 |  | Recommendation
 |  | Alternative "A" |  | Alternative "B" |  | Alternative "C"
 |  | Buy $25 million of Base Gas, Extend SBA for remainder |  | Buy All Base Gas and Buy Out of SBA's |  | Buy -0- Base Gas and Extend SBA's
Pre-Pay in 2001: | Gas Purchases
 | SBA Expenses
2002 Impacts: | Gas Purchases | -25000000 |  |  |  | 0
 | SBA Expenses |  |  | 0 |  | -14500000
 | (Less Stretch Objective for 2002) | 3000000
 | Net SBA Expense
[NAME]: |  |  |  |  |  | 0
(Original Rate Base = $20.1 million)
Rate Case Effect: |  | ---------------------(To Be Discussed)-------------------
Spreadsheet: 466504d1466226133-interactive-dashboard-functionality-help-for-marcel
Sheet: Sheet1

How to start a marketing campaign |  |  | Step 1 |  |  |  | How to start a marketing campaign | Logic on tech users | How to create a new rider account
Logic on tech users |  |  | Step 2 |  |  |  | How to start info 1 | Logic on Tech info 1 | How to Create info 1
How to create a new rider account |  |  |  |  |  |  | How to start info 2 | Logic on Tech info 2 | How to Create info 2
 |  |  |  |  |  |  | How to start info 3 | Logic on Tech info 3 | How to Create info 3
 |  |  |  |  |  |  | How to start info 4 | Logic on Tech info 4 | How to Create info 4
 |  |  |  |  |  |  | How to start info 5 | Logic on Tech info 5 | How to Create info 5
 |  |  |  |  |  |  | How to start info 6 | Logic on Tech info 6 | How to Create info 6
Spreadsheet: 100531d1298895862-inserting-rows-and-copy-paste-inserting-rows-and-data
Sheet: Sheet1

 |  | Country | Base | Product | Class | Plan & Actual | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | Total | Diff Oct-10 | Diff Nov-10 | Diff Dec-10 | Diff Jan-11 | Diff Feb-11 | Diff Mar-11 | Diff Apr-11 | Diff May-11 | [NAME] | Diff Jul-11 | Diff Aug-11 | Diff Sep-11 | Diff Total
 |  | UK | BFS | Apples | A | Plan | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 3
 |  | UK | BFS | Apples | A | Actual | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | UK | BRS | Apples | A | Plan | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 4
 |  | UK | BRS | Apples | A | Actual | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 |  | UK | EDI | Apples | A | Plan | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 3
 |  | UK | EDI | Apples | A | Actual | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 |  | UK | GLA | Apples | A | Plan | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2
 |  | UK | GLA | Apples | A | Actual | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 |  | UK | LGW | Apples | A | Plan | 3 | 1 | 1 | 1 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 44
 |  | UK | LGW | Apples | A | Actual | 2 | 2 | 5 | 6 | 7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 23
 |  | UK | LTN | Apples | A | Plan | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 10
 |  | UK | LTN | Apples | A | Actual | 2 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 5
 |  | UK | LPL | Apples | A | Plan | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 |  | UK | LPL | Apples | A | Actual | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | UK | MAN | Apples | A | Plan | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 4
 |  | UK | MAN | Apples | A | Actual | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
 |  | UK | NCL | Apples | A | Plan | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 3
 |  | UK | NCL | Apples | A | Actual | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 3e0495be-c307-4df7-8b49-b8ca0ae395a8
Sheet: Ref Growth Change History

Referendum Growth Change - End of Session Projections vs November Actual Results
($ in thousands)
 | End of Session | [NAME] | Difference | % Change
FY 2012
Nov10 Forecast
Aid
[NAME] | 810052.5 | 745759.1
Revenue | 886727 | 822570.4
FY 2011
[NAME]
Aid
[NAME] | 824714.4 | 735598.9
Revenue | 894402.8 | 803496.6
FY 2010
[NAME]
Aid
[NAME] | 736370.5 | 714983.4
Revenue | 810892.9 | 786060.4
FY 2009
Nov07 Forecast
Aid
[NAME] | 641744.7 | 635306.7
Revenue | 727996.3 | 723111.9
FY 2008
Nov06 Forecast
Aid
[NAME] | 569022.14 | 538202.214
Revenue | 670233.654 | 641010.78
FY 2007
Nov05 Forecast
Aid
[NAME] | 523019.175 | 474335.984
Revenue | 633987.659 | 585561.344
Spreadsheet: 886466d1736488034-creating-a-data-base-ppe-register
Sheet: FIND

 |  | Enter employee number below
 | Emp No | 9
 | Name
 | PPE | History
 |  | Shoe | Helmet | Jacket | Overall | Goggle | Spectacle
 | Issue Dates
Spreadsheet: 145d192e-b3f6-4abc-8069-52f213d489ca
Sheet: Publishers (Fiction)

Publisher (Fiction) | Titles | Percentage
AmazonCrossing | 24
[NAME] | 19
Europa Editions | 10
[NAME] | 10
Penguin | 9
Open Letter | 8
FSG | 7
Archipelago | 6
[NAME] | 6
Houghton [NAME] | 6
New Directions | 6
Yale University Press | 6
[NAME] | 5
[NAME] | 5
Other Press | 5
Bitter Lemon | 4
Melville House | 4
Pegasus | 4
And Other Stories | 3
Atria | 3
Black Cat | 3
Glas | 3
Grove | 3
K A Nitz | 3
Knopf | 3
Minotaur | 3
[NAME] | 2
Biblioasis | 2
Crown | 2
DISQUIET | 2
Indiana University Press | 2
Pantheon | 2
Random House | 2
Simon & Schuster | 2
Soho Press | 2
Stockholm Text | 2
Talonbooks | 2
Two Lines Press | 2
University of Nebraska | 2
University of Texas | 2
[NAME] | 2
American University at Cairo | 1
Aqueduct Press | 1
Arsenal Pulp Press | 1
Bellevue Literary Press | 1
Black Balloon | 1
Coach House Books | 1
Columbia University Press | 1
Counterpath Press | 1
[NAME] | 1
[NAME] | 1
[NAME] and [NAME] | 1
Feminist Press | 1
Frisch & Co. | 1
[NAME] | 1
Graywolf | 1
HarperCollins | 1
[NAME] | 1
House of Anansi | 1
Interlink | 1
Last Gasp | 1
Le French | 1
[NAME] | 1
[NAME]'s Books | 1
New Vessel Press | 1
New York Review Books | 1
Northwestern University Press | 1
Overlook | 1
Persea | 1
Picador | 1
Pleasure Boat Studio | 1
Process | 1
Quercus | 1
Santa Fe Writers Project | 1
[NAME] | 1
Serpent's Tail | 1
Seven Stories Press | 1
Small Beer | 1
St. Martin's | 1
Strategic Book Publishing | 1
Syracuse University Press | 1
Telegram | 1
Tin House | 1
Tor | 1
Ugly Duckling | 1
University of Chicago | 1
University of Minnesota Press | 1
University of Oklahoma Press | 1
Verso | 1
Vertical | 1
Vintage | 1
W.W. Norton | 1
Spreadsheet: 105a75f7-d0ea-45f4-bba4-74789bf804a1
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
WPIN | Test | WPIN | White Pine, IgE | White Pine, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel			 [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
WPIN | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
WPIN | Result | WPIN | White Pine, IgE | White Pine, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6282-8 | Pinus [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 206434d1358186971-conditional-formatting-for-standard-deviation-sd_conditional_formatting
Sheet: Sheet1

 |  | Baseline QC |  | Ongoing QC
 |  | #1: | #2: | #1: | #1 Diff: | #2: | #2 Diff: |  |  | #1: |  | #2:
Mean: |  | 5.59 | 4 |  |  |  |  |  | +/- 1 SD
Standard Deviation: |  | 0.16 | 0.13 |  |  |  |  |  | +/- 2 SD
Covariance: |  | 0.0294 | 0.0315 |  |  |  |  |  | +/- 3 SD
Test #: | Date: | #1: | #2:
1 | 2012-10-25 00:00:00 | 5.44 | 3.96
2 | 2012-11-20 00:00:00 | 5.4 | 3.95
3 | 2012-12-28 00:00:00 | 5.72 | 4.03
4 | 2013-01-10 00:00:00 | 5.41 | 3.81
5 | 2013-01-11 00:00:00 | 5.5 | 3.98
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: 82163d1282175824-drop-down-lists-worksheet_dogdays2010_stage2
Sheet: Sheet2

 | [NAME] | ODL | NOVA | DECO
BWD03 2236 |  | 2324
BWD03 836-2 |  | 2747
BWD03 848-2 |  | 2856
BWD03 2248 |  | 2409
BWD03 2064 |  | 3091
BWD03 2264 |  | 3126
BWD03 1/2 MN |  | 1751
BWD03 SM OVAL |  | 2228
BWD03 LG OVAL |  | 3020
BWD03 836 |  | 1500
BWD03 848 |  | 1554
BWD03 764 |  | 1691
BWD09 2236 |  | 2190
BWD09 836-2 |  | 2512
BWD09 848-2 |  | 2774
BWD09 2248 |  | 2441
BWD09 2064 |  | 3080
BWD09 2264 |  | 3080
BWD09 1/2 MN |  | 1617
[NAME] |  | 2267
[NAME] |  | 3107
[NAME] 0836 |  | 1382
BWD09 0848 |  | 1513
BWD09 0764 |  | 1595
BWD16 2236 |  | 2133
BWD16 836-2 |  | 2569
BWD16 848-2 |  | 2725
BWD16 2248 |  | 2398
BWD16 2064 |  | 2944
BWD16 2264 |  | 2998
BWD16 836 |  | 1421
BWD16 848 |  | 1489
BWD16 764 |  | 1546
BWD17A 2236 |  | 2338
BWD17A 836-2 |  | 2622
BWD17A 848-2 |  | 3020
BWD17A 2248 |  | 2747
BWD17A 2064 |  | 3293
BWD17A 2264 |  | 3293
BWD17A 1/2 MN |  | 1737
BWD17A SM OVAL |  | 2324
BWD17A LG OVAL |  | 2747
BWD17A 836 |  | 1437
BWD17A 848 |  | 1636
BWD17A 764 |  | 1704
BWD20 2236 |  | 2351
BWD20 836-2 |  | 2665
BWD20 848-2 |  | 2780
BWD20 2248 |  | 2799
BWD20 2064 |  | 3167
BWD20 2264 |  | 3167
BWD20 836 |  | 1459
BWD20 848 |  | 1516
BWD20 764 |  | 1541
BWD21 2236 |  | 2133
BWD21 836-2 |  | 2491
BWD21 848-2 |  | 2589
BWD21 2248 |  | 2409
BWD21 2064 |  | 2826
BWD21 2264 |  | 2826
BWD21 836 |  | 1371
BWD21 848 |  | 1421
BWD21 764 |  | 1546
BWD29 2236 |  | 2280
BWD29 836-2 |  | 2938
BWD29 848-2 |  | 3020
BWD29 2248 |  | 2515
BWD29 2064 |  | 2914
BWD29 2264 |  | 2914
BWD29 836 |  | 1595
BWD29 848 |  | 1636
BWD29 764 |  | 1661
BWD11 2064 |  | 2720
BWD11 2264 |  | 2747
BWD11 764 |  | 1609
BWD23 2064 |  | 3498
BWD23 2264 |  | 3498
BWD23 764 |  | 1732
BWD28 2064 |  | 3498
BWD28 2264 |  | 3498
BWD28 764 |  | 1658
BWD31 2064 |  | 3282
BWD31 2264 |  | 3282
BWD31 764 |  | 1704
BWD40 2064 |  | 3790
BWD40 2264 |  | 3790
BWD40 764 |  | 1794
BWD41 848-2 |  | 3156
BWD41 2248 |  | 2747
BWD41 2064 |  | 2987
BWD41 2264 |  | 2987
BWD41 SM OVAL |  | 2242
BWD41 [NAME] |  | 2952
BWD41 848 |  | 1704
BWD41 764 |  | 1841
BWD42 2064 |  | 3118
BWD42 2264 |  | 3118
BWD42 764 |  | 1598
BWD43 2064 |  | 3948
BWD43 2264 |  | 3948
BWD43 764 |  | 1841
Spreadsheet: tracy_geaccone__40328__CorpCharge_Model_Hyp_Actual - NEW
Sheet: Total

Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O:\Corporate\GPGFin\Cfp\0103Plan\[capcharge.xls]Capital Charge Template
CAPITAL CHARGE CALCULATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-03-05 14:25:06.610000
2001
(Millions of Dollars)
EGSVC4 |  |  |  |  |  | EGSVC4 |  | EGSVC4 |  | EGSVC4 |  | EGSVC4 |  | EGSVC4 |  | EGSVC4 |  | EGSVC4 |  | EGSVC4 |  | EGSVC4 |  | EGSVC4 |  | EGSVC4
PY_R |  |  |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL
2000-12-31 00:00:00 |  |  |  | 2001-01-31 00:00:00 |  | 2001-02-28 00:00:00 |  | 2001-03-01 00:00:00 |  | 2001-04-01 00:00:00 |  | 2001-05-01 00:00:00 |  | 2001-06-01 00:00:00 |  | 2001-07-01 00:00:00 |  | 2001-08-01 00:00:00 |  | 2001-09-01 00:00:00 |  | 2001-10-01 00:00:00 |  | 2001-11-01 00:00:00 |  | 2001-12-01 00:00:00
Theoretical Debt at 12/31/00:
 | Equity (A)  [(DR) / CR] |  |  | 3318.3
 | Third Party Debt (B)  [(DR) / CR] |  |  | 117.6
 | Company Obligated Preferred Stock of Subs (G) |  |  | 0
 | Net Intercompany balance (C)  [(DR) / CR] |  |  | -184.0000000000011
 |  | [NAME] |  | -2177.2
 |  | 51 |  | -1926.4
 |  | 52 |  | 0
 |  | 37 |  | -2445.1
 |  | 38 |  | 0
 |  | 486 |  | 3294.1
 |  | 516 |  | 93
 |  | 517 |  | 0
 |  | 660 |  | 804.6
 |  | 661 |  | 0
 |  | 878 |  | 2177.7
 | Adjustment for Net PRM |  |  | -587
 | Adjustment for EGF allocation |  | 204.5 | 204.5
 | Adjustment for Off B/S Items |  | 19 | 19
 |  | Total Capital
 | Theoretical [NAME] |  | 0.5 | 0.5
 |  |  |  | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | JUN |  | JUL |  | AUG |  | SEP |  | OCT |  | NOV |  | DEC |  | TOTAL
Theoretical Debt Balance - Beginning of Month
Net Intercompany Activity
 | Theoretical Debt %
Theoretical Debt Portion of Monthly Cash Flow
Total Theoretical Debt Balance
Interest Rate (7.5% annual) |  |  |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625
Total Capital Charge
Adjustments
 | Third Party Interest (Expense) (E)
 | Intercompany Interest Income/(Expense) (F)
Total Capital Charge booked by Corporate