tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7338__Gas Sales Confirmation
Sheet: West Texas

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | Lokay |  |  | Company: |  |  | Astra Power
Deal Date: |  |  | 2002-03-20 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 03/21/2002 |  |  | FAX Number: |  |  | Fax: [PHONE]
Total Quantity |  |  | 30000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 3.1
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
03/21/2002 | 03/21/2002 |  | 30000 | 30000 |  | 30000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
West Texas Pool |  |  | 58646 |  | 22900 |  |  |  | 22948
Central Pool |  |  | 58649 |  | 7100 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | 'Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Please acknowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME],  Fax [PHONE],  Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 73400d1274071899-how-to-combine-if-vlookup-and-match-lookup
Sheet: Data Source

Date | 20100920 | Campaign | Forecast QTY
2010-04-15 00:00:00 | F4081033 | C9 | 9226
2010-04-30 00:00:00 | [NAME] | C10 | 388
2010-04-30 00:00:00 | [NAME] | C11 | 93650
2010-04-30 00:00:00 | F4081033 | C12 | 16000
2010-03-30 00:00:00 | F4081033 | C13 | 5850
2010-03-30 00:00:00 | F4081033 | C14 | 52360
2010-04-30 00:00:00 | F4081033 | C15 | 8378
2010-04-15 00:00:00 | F4081036 | C16 | 388
2010-03-15 00:00:00 | F4081036 | C17 | 388
2010-04-30 00:00:00 | F4081033 | C18 | 65000
2010-04-15 00:00:00 | F4081036 | C19 | 10400
2010-04-15 00:00:00 | F4081036 | C20 | 51000
2010-04-15 00:00:00 | F4081036 | C21 | 159800
2010-03-30 00:00:00 | F4081033 | C22 | 25568
2010-04-30 00:00:00 | F4081033 | C23 | 127840
2010-04-30 00:00:00 | F4081033 | C24 | 388
2010-03-15 00:00:00 | F4081033 | C1 | 12784
2010-04-30 00:00:00 | F4081037 | C2 | 388
2010-04-30 00:00:00 | F4081037 | [NAME] | 388
2010-03-15 00:00:00 | F4081037 | C4 | 388
2010-03-15 00:00:00 | F4081033 | C5 | 388
2010-03-15 00:00:00 | F4081033 | C6 | 388
2010-03-15 00:00:00 | F4081033 | C7 | 388
2010-04-30 00:00:00 | F4081033 | C8 | 388
2010-04-15 00:00:00 | F4081034 | C9 | 5850
2010-04-15 00:00:00 | F4081034 | C10 | 38000
2010-04-15 00:00:00 | F4081033 | C11 | 70000
2010-04-30 00:00:00 | F4081034 | C12 | 13280
2010-04-15 00:00:00 | F4081034 | C13 | 2500
2010-04-30 00:00:00 | F4081034 | C14 | 49160
2010-04-30 00:00:00 | F4081034 | C15 | 7866
2010-03-30 00:00:00 | F4081034 | C16 | 5850
2010-04-30 00:00:00 | [NAME] | C17 | 5850
2010-03-30 00:00:00 | [NAME] | C18 | 2500
2010-03-30 00:00:00 | [NAME] | C19 | 70000
2010-03-30 00:00:00 | F4081034 | C20 | 11200
2010-03-30 00:00:00 | F4081034 | C21 | 24200
2010-04-30 00:00:00 | F4081034 | C22 | 116200
2010-04-30 00:00:00 | F4081036 | C23 | 92960
Spreadsheet: 189717d1351291490-divide-and-distribute-costs-to-multiple-participants-based-on-individual-amount-owed-vacation-cost-calculator
Sheet: Family10

Family10 |  |  |  |  | Receipts for Group Items | Cost | Total Paid
Family Members at Parker | 4 |  |  |  | Gas for boat | 100 | 275
Family Days at Parker | 8 |  |  |  | Gas for boat | 75
 |  |  |  |  | Gas for boat | 100
Family Members: | Days at Parker
Family_Member1 | 2
Family_Member2 | 2
Family_Member3 | 2
Family_Member4 | 2
Spreadsheet: 106873d1304017169-vlookup-or-similar-to-return-multiple-instances-with-a-twist-example
Sheet: Sheet2

Student | Test A | Test B | Test C | Test D
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 855251d1704892145-help-to-find-latest-previous-related-value-book1-247-aligw
Sheet: Sheet1

7
No. | Name | Point
1 | [NAME] | 10
2 | [NAME] | 8
3 | [NAME] | 6
4 |  | 10
5 | [NAME] | 7
6 | [NAME] | 6
7 | [NAME] | 10
Spreadsheet: 77499d1277955903-compare-columns-from-2-sheets-map
Sheet: Sheet2

S.no | Campus | No. of Registrations | Drop Out | Net Registrations | Total Fee Due | Amount Paid In The Month Of  June'10 |  | Cumulative Amount Paid Till Date | Remaining Amt. | Bank Loan
 |  |  |  |  |  | Reg Amount | Balance Fee
1 | Vijayawada | 2 | 0 | 2 | 328840 | 0 | 0 | 40000 | 288840 | 0
2 | Bangalore | 71 | 1 | 70 | 16142000 | 200000 | 871500 | 3097100 | 13054900 | 27
3 | Chennai | 27 | 3 | 24 | 5534400 | 130000 | 682400 | 1743300 | 3821100 | 7
4 | Hyderabad | 21 | 0 | 21 | 4467580 | 40000 | 289270 | 917810 | 3549770 | 11
5 | BHUBANESWAR | 23 | 0 | 23 | 3980200 | 20000 | 77210 | 799870 | 3180330 | 7
6 | Kolkata | 61 | 13 | 48 | 10098160 | 155000 | 1173430 | 2768430 | 7459730 | 15
 | Expected Result
1 | Vijayawada
2 | Bangalore
3 | Chennai
4 | Hyderabad
5 | BHUBANESWAR
6 | Kolkata
Spreadsheet: 773772d1648043413-how-to-match-date-with-the-right-date-range-vraag-excel
Sheet: Amount

Number | date | Amount
123456/1 | 2022-01-31 00:00:00 | ?
123456/1 | 2021-11-30 00:00:00 | ?
123456/1 | 2021-03-25 00:00:00 | ?
89516/2 | 2022-01-31 00:00:00 | ?
89516/2 | 2021-09-16 00:00:00 | ?
89516/2 | 2021-06-30 00:00:00 | ?
Spreadsheet: 727286d1617818063-find-and-match-a-text-value-for-a-corresponding-number-tvs
Sheet: Adobe TV Category on PLP

 | Attribute1 | Attribute2 | Attribute3 | Attribute4 | Attribute5 | Attribute6 | Attribute7 | Attribute8 | Attribute9 | Attribute10
SKU ID | Screen size | Backlight type | Number of HDMI Inputs | Resolution | Refresh rate | LED panel type | High Dynamic Range format | Motion Enhancement Technology | Smart Platform | Model Year
5734900
5872505
5900969
Spreadsheet: 799121d1664940022-creating-weekly-matchup-calendar-for-nba-s666-pq-creating-weekly-matchup-calendar-for-nba
Sheet: Sheet3

Attribute | 17/10/2022 | 18/10/2022 | 19/10/2022 | 20/10/2022 | 21/10/2022 | 22/10/2022 | 23/10/2022
ATL |  |  | HOU |  | ORL |  | CHA
BKN |  |  | NOP |  | TOR
BOS |  | PHI |  |  | @MIA | @ORL
CHA |  |  | @SAS |  | NOP |  | @ATL
CHI |  |  | @MIA |  | @WAS | CLE
CLE |  |  | @TOR |  |  | @CHI | WAS
DAL |  |  | @PHX |  |  | MEM
DEN |  |  | @UTA |  | [NAME] | OKC
DET |  |  | ORL |  | @NYK | @IND
[NAME] |  | LAL |  |  | DEN |  | SAC
HOU |  |  | @ATL |  | MEM | @MIL
IND |  |  | WAS |  | SAS | DET
LAC |  |  |  | @LAL |  | @SAC | PHX
LAL |  | [NAME] |  | LAC |  |  | POR
MEM |  |  | NYK |  | @HOU | @DAL
MIA |  |  | CHI |  | BOS | TOR
MIL |  |  |  | @PHI |  | HOU
MIN |  |  | OKC |  | UTA |  | @OKC
NOP |  |  | @BKN |  | [NAME] |  | UTA
NYK |  |  | @MEM |  | DET
OKC |  |  | @MIN |  |  | @DEN | MIN
ORL |  |  | @DET |  | @ATL | BOS
PHI |  | @BOS |  | MIL |  | SAS
PHX |  |  | DAL |  | @POR |  | @LAC
POR |  |  | @SAC |  | PHX |  | @LAL
SAC |  |  | POR |  |  | LAC | [NAME]
SAS |  |  | CHA |  | @IND | @PHI
TOR |  |  | CLE |  | @BKN | @MIA
UTA |  |  | DEN |  | @MIN |  | @NOP
WAS |  |  | @IND |  | CHI |  | [NAME]
Spreadsheet: 0e3b9e20-5e70-4c5e-a6f4-df96b3a0ca17
Sheet: Project Summary

Project Name | << the name from the AGIT project form>>
Costs
Implementation and Year 1
Year 2
Year 3
Year 4
Year 5
Five Year Total Costs
5 Year New Budget Costs
Total 5 Year New Budget Costs
5 Year Personnel Opportunity Costs
Total Project Cost to UI
Desried Project Outcomes
Positive Features
Areas of Concern
Spreadsheet: 42560d1241102258-highlighting-where-the-minimum-value-falls-in-sample
Sheet: Inventory

 |  | Sysco | NY | Car | USA | Best Choice | Total
 | Apples | 20 | 15 | 7 | 13
 | [NAME] | 14 | 5 | 14 | 12
 | Grand Total
Spreadsheet: 838598d1691158381-maximum-drawdown-in-percentage-max-dd-aligw
Sheet: Sheet1

Total R2 | [NAME] DD%
-0.005
-0.01
0
0.01
0.005
0.015
0.025
0.035
0.04500000000000001
0.02
0.01
0.025
0.015
Spreadsheet: 830283d1684845468-simple-example-but-excel-solver-cant-find-feasible-solution-sample_problem
Sheet: using countif

 | [ Airfare ]
 |  |  | To
 |  |  | A | B | C | D
 | From | A | 0 | 100 | 130 | 320
 |  | B | 80 | 0 | 45 | 190
 |  | C | 120 | 10 | 0 | 250
 |  | D | 300 | 200 | 250 | 0
 | [ Accommodation Cost ]
 |  |  | A | B | C | D
 |  |  | 0 | 6 | 3 | 7
 | [ Travel/Stay Plan ]
 |  |  | To
 |  |  | A | B | C | D | From count |  |  | necessary? |  | Total Airfare | Total Accom. Cost | Total Expense
 | From | A | 0 | 0 | 9 | 0 |  | = | 1
 |  | B | 1 | 0 | 0 | 0 |  | <= | 1
 |  | C | 0 | 1 | 0 | 0 |  | <= | 1
 |  | D | 0 | 0 | 0 | 0 |  | <= | 1
 |  | To count
 |  |  | = | <= | <= | <=
 |  |  | 1 | 1 | 1 | 1
 |  | Total Stay |  | = | 10
 |  | Total City |  | = | 2
Spreadsheet: 784291d1655588896-ranking-based-on-combination-three-columns-in-excel-ranking-based-on-combination-three-columns-in-excel
Sheet: Sheet1

 |  |  |  |  |  | 1 | combination 1-2 | combination 1-2-3
 | Name | Score 1 | Score 2 | Score 3 |  | Rank 1 | Rank 1-2 | Rank 1-2-3
 | [NAME] | 80 | 89 | 60
 | [NAME] | 64 | 150 | 45
 | [NAME] | 65 | 78 | 47
 | [NAME] | 89 | 85 | 35
 | [NAME] | 76 | 52 | 38 |  |  |  |  |  | Rank 1, the winner | (1) [NAME] - (2) [NAME] - (3) [NAME]
 | [NAME] | 94 | 84 | 44 |  |  |  |  |  | Rank combination 1-2, the winner | (1) [NAME]2) [NAME] (3) [NAME]
 | [NAME] | 92 | 85 | 50 |  |  |  |  |  | Rank combination 1-2-3, the winner | (1) [NAME]2) [NAME] (3) [NAME]
 | [NAME] | 62 | 45 | 100
 | [NAME] | 45 | 99 | 54
 | [NAME] | 61 | 88 | 53
 | [NAME] | 72 | 83 | 62
Spreadsheet: 736432d1623636813-conditional-formatting-only-working-with-1-formula-in-progress-formatting
Sheet: Sheet1

Training Frequency | 3 Y | 5 Y
Personal Information | Equipment
Full Name | Ride-On | Scissor
A N Other | 2018-04-26 00:00:00 | 2017-05-26 00:00:00
A N Other B | 2016-06-12 00:00:00 | 2016-06-12 00:00:00
A N Other C | 2019-06-12 00:00:00 | 2019-06-12 00:00:00
A N Other D | 2018-05-12 00:00:00 | 2015-05-12 00:00:00
A N Other E | 2018-04-12 00:00:00 | 2018-04-12 00:00:00
Spreadsheet: 1604520a-1b85-488d-b05a-6c5a6678dd30
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
REIT Name: | Maxus Realty Trust, Inc.
 |  |  |  |  | Data requested by ICI and SIFMA by
Primary Layout Report Date: | 2006-12-27 00:00:00 |  |  |  | 2007-01-09 00:00:00
This spreadsheet and the accompanying instructions do not constitute, and should not be considered a substitute for, legal advice.  The rules governing the proper tax characterization of distributions by REITs can be complex.  Each REIT should consult its
Please list Securities in [NAME] (Skip Rows Between Entries)
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
 |  |  |  |  |  |  |  |  |  | Year Included in Shareholders' Income |  |  |  | Form 1099 Box 1a Breakdown |  | Box 1a Total |  | Form 1099 Box 1b Breakdown |  | Box 1b Total | Box 2a | Box 2b | Box 2c | Box 2d | Box 3 | Box 6 | Box 8 | Box 9 |  | Alternative
 |  |  |  |  |  |  |  |  | Total |  |  |  |  |  | Foreign | Ordinary | Qualified | Qualified | Qualified | Qualified | Total Capital | Unrecap |  |  |  | Foreign | Cash | Noncash | Exempt | Minimum
Security |  | Ticker | Estimated | Reclass | Corrected | Record | Ex-Dividend | Payable | Distribution | 2005 | 2007 | 2006 | Income | Short-term | Tax | Dividends | Income | Short-term | Foreign Tax | Dividends | [NAME]. | Sec. 1250 | Section 1202 | Collectibles | Nondividend | Tax | Liquidation | Liquidation | Interest | Tax
Description | CUSIP | Symbol | (E) | (R) | (C) | Date | Date | Date | Per Share | (Prior Year) | (Next Year) | (Current Year) | Dividends | Capital Gain | Paid | (14+15) | Dividends | Gains | Paid | -18 |  | Gain | Gain | (28%) Gain | Distributions | Paid | Distr | Distr | Dividends | %of Column 30
 |  |  |  |  |  |  |  |  | (11+12+13) |  |  | (14+15+22+26)
Maxus Realty Trust, Inc. | 57774B109 | MRTI
Spreadsheet: 220907d1363298975-inventory-problem-inventory
Sheet: Blad1

 |  |  |  | sales
 | Average sales/month | Stock 01/01/2012 | Delivery date | january | february | march | april | may | june | july | august | september | october | november | december
Product 1 | 250 | 500 | 60 days | 250 | 250
Product 2 | 20 | 100 | 30 days | 20 | 20 | 20 | 20 | 20
Product 3 | 140 | 840 | 30 days | 140 | 140 | 140 | 140 | 140 | 140
Product 1000 | 100 | 1000 | 20 days | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Spreadsheet: 114750d1310477579-chart-range-update-every-month-chart-range-update
Sheet: Sheet1

 |  |  |  | fruits | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00
 |  |  |  | apple | 1 | 2 | 5 | 8
 |  |  |  | orange | 2 | 4 | 6 | 9
 |  |  |  | banana | 5 | 6 | 3 | 2
Spreadsheet: 240274d1370277120-alphanumeric-sort-alphanum-oeldere-
Sheet: Sheet2

Current Format: | helpcolumn 0 | helpcolumn 1 | helpcolumn 2 |  |  |  |  |  | Desired Format:
[NAME] |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | ZLM3-ZLX3
[NAME] |  |  |  |  |  |  |  |  | ZLM3-ZLF4
ZLM3-ZLX3 |  |  |  |  |  |  |  |  | ZLM3-ZLH4
ZLM3-ZLF4 |  |  |  |  |  |  |  |  | ZLM3-ZLF5
[NAME] |  |  |  |  |  |  |  |  | ZLM3-ZLH5
ZLM3-ZLH4 |  |  |  |  |  |  |  |  | [NAME]
ZLN3-ZLH4 |  |  |  |  |  |  |  |  | [NAME]
ZLM3-ZLF5 |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | ZLN3-ZLH4
ZLM3-ZLH5 |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 136593d1326735018-two-columns-combined-into-one-column-w-no-duplicates-two-columns-into-one-removing-duplicates
Sheet: Sheet1

 | Committed | Opportunity | Result |  | Issue
 | [NAME] | [NAME] | [NAME] |  | I am looking for an equation that takes two columns of Names and removes duplicates in a separate third column.
 | [NAME] | [NAME] | Mandy
 | [NAME] | [NAME] |  |  | Details
 | [NAME] | [NAME] |  |  | I would like to compare the list in Column C to Column B and have Column D only show those names that show up in Column C and not in Column B
 |  | [NAME] |  |  | -As you see [NAME] and [NAME] show up in column C but not column B so they need to show in the results in column D
 |  | Mandy
Spreadsheet: 95118d1294789657-referencing-the-next-cell-in-an-array-that-is-not-a-particular-value-sample
Sheet: Sheet2

What I'd like to see returned…
100100 | 103 | 203 | 300
100101 | 104 | 204 | 301
100102 | 105 | 205 | 302
100103 | 106 | 206 | 306
100104 | 107 | 207 | 307
100105 | 108 | 208 | 308
100106 | 109 | 209 | 309
100107 | 110 | 210 | 310
100108 | 111 | 211 | 311
100109 | 112 | 212 | 312
 | 115 | 215 | 315
 | 116 | 216 | 316
 | 117 | 217 | 317
 | 118 | 218 | 318
 | 119 | 219 | 319
 | 120 | 220 | 320
 | 121 | 221 | 321
 | 122 | 222 | 322
 | 123 | 223 | 323
 | 124 | 224 | 324
 | 127 | 227 | 327
 | 128 | 228 | 328
 | 129 | 229 | 329
 | 130 | 230 | 330
 | 131 | 231 | 331
 | 132 | 232 | 332
 | 133 | 233 | 333
 | 136 | 236 | 336
100101 blue | 137 | 237 | 337
100127 red | 138 | 238 | 338
Spreadsheet: 2d1e63da-0ad0-453e-be42-4ece030618fc
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
ASPAG | Test | ASPAG | Aspergillus (Galactomannan) Antigen, Serum | Aspergillus Ag, S | Enzyme Immunoassay (EIA) | Serum Gel Tube: SGT |  |  | 1.5 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 1.5 mL Collection Instructions:  1. Avoid exposure of specimen to atmosphere.  2. Send specimen in original tube. Do not aliquot. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <0.5 index | Monday through Friday 9:00 a.m. and 4:00 p.m.; Sunday 8:00 a.m. | 1 day | 4 days | 1 | 87305 |  |  |  |  | Rochester
ASPAG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ASPAG | Result | 84356 | Aspergillus Ag, S | Aspergillus Ag, S | Numeric |  |  |  |  | index |  |  |  |  |  |  |  |  |  | 44357-2 | Galactomannan Ag:ACnc:Pt:Ser/Plas:Qn:EIA
Spreadsheet: 707676d1607419862-sumifs-with-criteria-range-by-column-and-in-rows-2-rows-one-row-is-by-date-sample-problem-1-
Sheet: Sheet4

 |  |  |  |  |  |  |  |  |  | EXPECTED RESULT
 | DATE = | DD/MM/YYY
 | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-04-03 00:00:00 | 2021-04-05 00:00:00 |  |  |  | JANUARY | FEBRUARY | APRIL
Name 1 | 8 | 10 | 3 | 3 | 4 | 4 |  |  | Name 2 | 2 | 5
Name 2 | 1 | 1 | 3 | 2 |  |  |  |  | Name 1 | 18 | 6 | 8
Name 3 | 2 |  |  |  |  |  |  |  | Name 4 | 1
Name 4 | 1 |  |  |  |  |  |  |  | Name 3 | 1
Name 5 | 1 |  |  |  |  |  |  |  | Name 5 | 1
Spreadsheet: 77fe1ff2-432c-490e-b8fd-5371d95fcd32
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
FSCA6 | Test | FSCA6 | [NAME] (SCA) Type 6 | SCA 6 DNA | Polymerase Chain Reaction (PCR)/Fragment Analysis by Capillary Electrophoresis | EDTA (lavender-top) tube: EDTA |  |  | 20 | mL | 20 mL whole blood collected in a lavender-top (EDTA) tube(s). Send EDTA whole blood at ambient temperature.   Note:  Collection date is required. | 10 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | A final report will be attached in MayoAccess.    Test Performed By:  Athena Diagnostics                                          377 Plantation St.                                         Four Biotech Park                                         Worcester, MA  01605 | Wednesday | 7-14 days | 8-15 days | 1 | 81401 |  |  |  |  | Athena Diagnostics
FSCA6 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
FSCA6 | Result | Z0097 | SCA 6 DNA | SCA 6 DNA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 167183d1341923191-copy-data-with-3-horisontal-or-vertical-criterias-index-and-match-try4
Sheet: Data Source

Cars | Q1/10 | Q2/10 | Q3/10 | Q4/10 | Q1/11 | Q2/11 | Q3/11 | Q4/11 | Q1/12 | [NAME] | Q3/12 | Q4/12
Europe | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909 | 1909
Eurasia | 1353 | 1953 | 2553 | 3153 | 3753 | 4353 | 4953 | 5553 | 6153 | 6753 | 7353 | 7953
MEA | 797 | 707 | 617 | 527 | 437 | 347 | 257 | 167 | 77 | 99 | 8803 | 9193
SEAP | 241 | 261 | 281 | 301 | 321 | 341 | 361 | 381 | 401 | 421 | 441 | 461
India | 8989 | 8766 | 8543 | 8320 | 8097 | 7874 | 7651 | 7428 | 7205 | 6982 | 6759 | 6536
NA | 1433 | 185 | 698 | 777 | 856 | 935 | 1014 | 1093 | 1172 | 1251 | 1330 | 1409
LATAM | 3399 | 3398 | 3397 | 3396 | 3395 | 3394 | 3393 | 3392 | 3391 | 3390 | 3389 | 3388
China | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377
World TOTAL | 21498 | 20556 | 21375 | 21760 | 22145 | 22530 | 22915 | 23300 | 23685 | 24182 | 33361 | 34226
Boats | Q1/10 | Q2/10 | Q3/10 | Q4/10 | Q1/11 | Q2/11 | Q3/11 | Q4/11 | Q1/12 | [NAME] | Q3/12 | Q4/12
Europe | 2083 | 235 | 876 | 1517 | 2158 | 2799 | 3440 | 4081 | 4722 | 5363 | 6004 | 6645
Eurasia | 1953 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225 | 225
MEA | 1823 | 215 | 888 | 1561 | 2234 | 2907 | 3580 | 4253 | 4926 | 5599 | 6272 | 6945
SEAP | 1693 | 205 | 999 | 1793 | 2587 | 3381 | 4175 | 4969 | 5763 | 6557 | 7351 | 8145
India | 1563 | 195 | 876 | 1557 | 2238 | 2919 | 3600 | 4281 | 4962 | 5643 | 6324 | 7005
NA | 1433 | 185 | 698 | 777 | 856 | 935 | 1014 | 1093 | 1172 | 1251 | 1330 | 1409
LATAM | 3399 | 3398 | 3397 | 3396 | 3395 | 3394 | 3393 | 3392 | 3391 | 3390 | 3389 | 3388
China | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377 | 3377
World TOTAL | 17324 | 8035 | 11336 | 14203 | 17070 | 19937 | 22804 | 25671 | 28538 | 31405 | 34272 | 37139
Spreadsheet: 880563d1728367614-summing-specific-cells-based-on-criiteria-test
Sheet: Systems Build

TITLE
TASK ID | TASK DESCRIPTION | HRS
1 | PLANNING |  | [NAME] should sum all cells below within the same subset of cell A3 e.g. 1.1, 1.2…. So if I add a new row with 2.6 it will then auto sum the new row
1.1 | Parts Ordering | 2
1.2 | [NAME] | 1
1.3
1.4
1.5
2 | FIT-OUT |  | As above, C9 should sum all cells below within the same subset of cell A9 e.g. 2.1, 2.2 ...So if I add a new row with 2.6 it will then auto sum the new row
2.1 | Electrical | 1
2.2 | Air Con | 2
2.3 | Penetrations | 4
2.4 | Shelves | 6
2.5
3 | INTEGRATION
3.1 | Equipment
3.2 | Peripheral equipment, components, sub-assemblies
3.3 | Signal/Electrical Wiring
3.4 | Plumbing
3.5
 | TOTAL HRS |  | C21 to sum all grey cells above e.g. [NAME], C9, C15 … If I add in extra subset e.g. 4 (4.1, 4.2 etc) it will also then auto sum those new cells
Spreadsheet: 34787d1232130590-values-formula-copy-of-new-order-entry-in-progress-2-
Sheet: Quotation

 | Customer: | 0 |  |  |  |  |  |  |  | Quotation No.: | 0
 |  | #N/A |  |  |  |  |  |  |  | Cutomer Inquiry: | #N/A
 |  | #N/A
 | Attn.: | #N/A |  |  |  | PH: | #N/A |  |  | Shipment: | Our Truck
 | Ship to: | 0 |  |  |  | FX: | #N/A |  |  | F.O.B. Point: | Delivered
 |  | 0 |  |  |  |  |  |  |  | Terms: | Net 30 Days
 | Lot#: | 0
Date Required: |  |  | 1900-01-01 00:00:00 |  |  |  |  | Date Received: | 1900-01-01 00:00:00
Item |  | Beam |  |  |  |  |  |  |  | Unit Price | Total
No. | Qty. | Type |  |  | Length |  | Paint |  |  | ($) | ($)
1 | 2 | [NAME] |  |  | 7'-11" |  | 0 |  |  |  | 290.4065040650406
2 | 2 | [NAME] |  |  | 7'-11" |  | 0 |  |  |  | 290.4065040650406
3 | 2 | [NAME] |  |  | 7'-11" |  | 0 |  |  |  | 290.4065040650406
4 | 2 | [NAME] |  |  | 7'-11" |  | 0 |  |  |  | 290.4065040650406
0 | 0 | 0 |  |  | 0 |  | 0 |  |  |  | #N/A
0 | 0 | 0 |  |  | 0 |  | 0 |  |  |  | #N/A
0 | 0 | 0 |  |  | 0 |  | 0 |  |  |  | #N/A
0 | 0 | 0 |  |  | 0 |  | 0 |  |  |  | #N/A
0 |  | 0 | 0 | 0 | 0 | 0 | 0
Item |  | [NAME]
No. | Qty. | Length |  |  | Size | Sch
0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  | 0
0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  | 0
0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  | 0
Item
No. | Qty. | Additional Work
0 | 16 | 1/4" X 4" X 4" |  |  |  |  |  |  |  |  | 0
0 | 32 | 1/8" X 4" X 4" |  |  |  |  |  |  |  |  | 0
0 | 0 | Splice Plate |  |  |  |  |  |  |  |  | 0
0 | 0 | Measure |  |  |  |  |  |  |  |  | 0
0 | 0 | Extra Work |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | Total = | #N/A
Special Instructions:
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | Authorized By:
 |  |  |  |  | Quote does not include sales tax