tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 63967d1264802661-count-non-blank-non-numeric-non-zero-non-space-non-error-text-cells-2007-for-excel-forum
Sheet: Sheet1

 | Table1 |  |  |  |  | Table2 |  |  |  |  | Column With Irregularly Spaced
 |  |  |  |  |  |  |  |  |  |  | Valid Row Names
 | C10 |  |  | C21 | C22 | C23 | C24 | C25 |  |  | (interspersed by non-text pollution)
 | 1 |  |  | 1 | 2 | 3 | 4 | 5 |  |  | SumProduct of C10*C21 |  |  |  |  |  | 0
 | 1 |  |  | 1 | 2 | 3 | 4 | 5 |  |  | 0 |  |  |  |  |  | 0
 | 1 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  |  |  | 1
 | 1 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  |  |  | 1
 | 1 |  |  | 1 | 2 | 3 | 4 | 5 |  |  | SumProduct of C10*C22 |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | SumProduct of C10*C23 |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  | Contiguous data columns |  |  |  |  | SumProduct of C10*C24 |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ^^^ |  | ^^^
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | shg's |  | desired
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula |  | output
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | column
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | offset
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Peter Peltz

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
We have to do better than last session's battle with clear description of bargaining rights and financial impact. Can this be better
implemented without polarizing the education community?
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
The concessions made in '08 helped significantly.
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
You support for health care reform is critical. "Grandfathered" protection is secure, but support for single pipeline administration is crucial.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
Attracting and supporting young teachers is complex and primarily is effected by the host school.
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
Relicensing as currently coordinated by peer review should be looked at considering the wide array of offerings and delivery models.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | PO Box 41, [NAME], VT 05681 | State Rep | Yes |  | Washington
Spreadsheet: 89654d1289414766-compare-multiple-values-test3
Sheet: Variation

 | 196253 | 139_5_84_35/CT
 | [NAME] | 0.24439968 | Kgs per Case | 45.73392
 | [NAME] per Sock | 0.01018332 | Cases Shipped | 19
 | Socks per Kg | 98.19980124360228
 | [NAME] | 868.94448
 | Dz [NAME] | 3555.423967821889
 |  | PKM TYPE |  | [NAME]. | Kgs per dz. | [NAME] | Kgs Used | JDE Type |  | [NAME]. | Kgs Used
3 |  | 148689 | LN323 LYRCA ELASTIC | 0.016 | 0.0072576 | 0.02969561989606533 | 105.5805187177992 | 148689 | LN323 LYRCA ELASTIC | 0.0388 | 137.9504499514893 |  | 31
5 |  | 196313 | 6/1 OE COTTON | 0.0624 | 0.02830464 | 0.1158129175946548 | 411.764022999417 |  |  |  |  |  | 33
7 |  | 134277 | 10/1 OE COTTON | 0.0408 | 0.01850688 | 0.0757238307349666 | 269.230322730388 | 134277 | 10/1 OE COTTON | 0.0668 | 237.5023210505022 |  | 35
9 |  | 196309 | 14/1 OE COTTON | 0.278 | 0.1261008 | 0.5159613956941351 | 1834.461512721761 |  |  |  |  |  | 37
 |  | 196368 | McMicheals 20-1/150/68 (3297) | 0.0712 | 0.03229632 | 0.1321455085374907 | 469.8333082942066
 |  | 134361 | 14/1 90/10 Gray | 0.0696 | 0.03157056 | 0.1291759465478842 | 459.2752564224265
29 |  | 196004 | 2/100/34 SEAMING(884) | 0.0008 | 0.00036288 | 0.001484780994803266 | 5.279025935889961 | 196004 | 2/100/34 SEAMING(884) | 0.0014 | 4.977593554950644 |  | 57
13 |  |  |  |  |  |  |  | 125590 | 6/1 OE (WRONG JDE #) | 0.1156 | 411.0070106802103 |  | 41
15 |  |  |  |  |  |  |  | 130283 | 2/70/34 (WRONGJDE #) | 0.0018 | 6.3997631420794 | 6.3997631420794 | 43
17 |  |  |  |  |  |  |  | 125591 | 14/1 (WRONG JDE #) | 0.4912 | 1746.424252994112 |  | 45
21 |  |  |  |  |  |  |  | 135839 | 1/150/48 (Polyester-P55038A) | 0.1508 | 536.1579343475407 |  | 49
23 |  |  |  |  |  |  |  | 125592 | 12/1 (WRONG JDE #) | 0.1336 | 475.0046421010043 |  | 51
 |  |  |  | 0.5388000000000001 | 0.24439968 | 1 |  |  |  | 1
 |  |  |  |  | 1st Comparison . . . . If equal . . .then compare E8 to K8(2nd Comparison)
 |  |  | If the 1st Comparison does not mach, VLOOKUP($B$1,'StyleDetail'!$A:$BF,33,FALSE)
 |  |  | If 1st Comparison matches and 2nd Comparison does not then,VLOOKUP($B$1,'StyleDetail'!$A:$BF,33,FALSE)
 |  |  | If both criteria match then do nothing.
Spreadsheet: 764346d1642691754-compare-information-on-different-sheets-and-highlight-differences-rooms
Sheet: Merge1

FILTER | Building No | Room No | Room Name | Area (m2) | Height (m) | Table1.Area (m2) | Table1.Height (m) | difference Areia | Difference Height
 | B | B.ST.01 | Staircase | 11.8240000000003 | 10.4 | 11.8240000000003 | 1 | 0 | 9.4
 | B | B.0.01 | Process Room | 79.2995475476171 | 4.34 | 79.2995475476171 | 4.34 | 0 | 0
 | B | B.0.03 | Process Tanks | 28.6411345671637 | 5.38061630251183 | 10 | 5.38061630251183 | 18.6411345671637 | 0
 | B | [NAME] | Big Bag Station | 11.844399999997 | 9.91999999999999 | 11.844399999997 | 9.91999999999999 | 0 | 0
 | B | B.0.02 | Candle Filter room | 44.2998000000182 | 4.34 | 44.2998000000182 | 4.34 | 0 | 0
Spreadsheet: 100276d1298661635-copy-a-row-the-number-of-times-listed-in-a-cell-copy-of-book1-1
Sheet: Sheet2

INJECTION
Spreadsheet: 886359d1736383700-excel-formula-to-derrive-data-with-logical-reference-to-other-data-in-the-same-sheet-excel-formula-to-derrive-data-with-logical-reference-to-other-data-in-the-same-sheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Closing stocks as % of next month's sales | 0.5
 | Sales Plan (Bahrain) --> Qty Cases |  |  |  | January'25 |  |  |  |  | February'25 |  |  |  | March'25 |  |  |  | April'25 |  |  |  |  | May IMS
 | ITEM CODE | [NAME] | PTD | PTT | Opening Stock | SIT | Sales Plan | Purchase Plan | Closing Stock | Opening Stock | Sales Plan | Purchase Plan | Closing Stock | Opening Stock | Sales Plan | Purchase Plan | Closing Stock | Opening Stock | Sales Plan | Purchase Plan | Closing Stock
 |  | BARISTA WHOLE MILK 6X1LTR (OOH) | 18.72 | 24 | 164.0003333333333 |  | 0 | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | BARISTA LOW FAT 6X1LTR (OOH) | 18.72 | 24 |  |  | 0 | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | UHT MILK FF 12X1 LTR | 46.8 | 60 | 1859.834000007667 | 2400 | 7441 | 12000 |  |  | 6225 |  |  |  | 7000 |  |  |  | 5200 |  |  |  | 6000
 |  | UHT MILK FF MULTI 4X3X1 LTR | 46.8 | 60 | 1887.414266670667 | 0 | 16460 | 22000 |  |  | 16100 |  |  |  | 25245 |  |  |  | 14000 |  |  |  | 18000
 |  | SKIMMED MILK 12X1 LTR | 46.8 | 60 | 59.91766666733334 | 0 | 75 | 75 |  |  | 25 |  |  |  | 76 |  |  |  | 60 |  |  |  | 50
 |  | GOLD MILK  6X1 LTR | 28.08 | 36 | 198.8394000003333 | 0 | 265 | 292 |  |  | 150 |  |  |  | 400 |  |  |  | 313 |  |  |  | 400
 |  | UHT MILK LOW FAT 4X3X1 LTR | 46.8 | 60 | 99.16766666900001 | 180 | 385.1 | 424 |  |  | 800 |  |  |  | 440 |  |  |  | 360 |  |  |  | 450
 |  | UHT MILK 1 LITRE TOTAL
 |  |  |  |  |  |  |  |  | How to auto derrive Purchase plan based on the below factors.
 |  |  |  |  |  |  |  |  | 1 | Closing stock should not exceed the sales plan for the next month
 |  |  |  |  |  |  |  |  | 2 | Opening stock + Purchase plan should exceed Sales plan
Spreadsheet: 837261d1689966004-lookup-from-string-text-and-return-match-sample
Sheet: Sheet1

Look up for? |  |  | Vendor | Check
South Carolina Counties |  |  | ,,>><<nystic Polk County, FL)
Maryland Criminal |  |  | ,,>><<nystic South Dakota Counties)
IL - Judici > 7 years |  |  | ,,>><<nystic Cuyahoga County, OH)
Colorado Statewide |  |  | ,,>><<nystic Kern County, CA)
New Mexico Counties |  |  | ,,>><<nystic Stark County, OH)
Missouri Counties NEW |  |  | ,,>><<nystic Taylor County, TX)
Indiana Counties via Doxpop |  |  | ,,>><<nystic Genesee County, MI)
Hillsborough County, FL |  |  | ,,>><<nystic Hamilton County, OH)
Washington Statewide |  |  | ,,>><<nystic Summit County, OH)
Erath county, TX |  |  | ,,>><<nystic Portage County, OH)
Virginia Online |  |  | ,,>><<nystic Dallas County, TX)
Wisconsin Criminal |  |  | ,,>><<nystic Denton County, TX)
Idaho Criminal |  |  | ,,>><<nystic Peoria County, IL)
Shelby County, TN |  |  | ,,>><<nystic Lake County, IL)
Pasco - FL |  |  | ,,>><<nystic Orange County, CA)
North Carolina Counties |  |  | ,,>><<nystic Hamilton County, OH)
Nebraska Criminal |  |  | ,,>><<nystic Richland County, OH)
North Carolina Statewide |  |  | ,,>><<nystic Columbiana County, OH)
Lake County, OH |  |  | ,,>><<nystic Kings County, CA)
Bexar County, TX |  |  | ,,>><<nystic Lake County, IL)
Duval County, FL |  |  | ,,>><<nystic Polk County, FL)
Utah Criminal |  |  | ,,>><<nystic Trumbull County, OH)
Colorado Counties |  |  | ,,>><<nystic Select Counties, IL via Emagnus)
IL-via Emagnus |  |  | ,,>><<nystic Columbiana County, OH)
Pennsylvania Counties |  |  | ,,>><<nystic Jefferson County, OH)
Arkansas Counties |  |  | ,,>><<nystic Polk County, FL)
Texas Statewide |  |  | ,,>><<nystic Trumbull County, OH)
 |  |  | ,,>><<nystic Allen County, OH)
 |  |  | ,,>><<nystic Indiana Counties via Doxpop)
 |  |  | ,,>><<nystic Indiana Counties via Doxpop)
 |  |  | ,,>><<nystic Portage County, OH)
 |  |  | ,,>><<nystic Collier County, FL)
 |  |  | ,,>><<nystic Peoria County, IL)
 |  |  | ,,>><<nystic Gwinnett County, GA)
 |  |  | ,,>><<nystic Hamilton County, OH)
 |  |  | ,,>><<nystic Missouri Counties NEW)
 |  |  | ,,>><<nystic Maryland Criminal)
Spreadsheet: 870680d1717149874-summarise-multiple-tables-into-master-table-summary-formula-request
Sheet: StockB

 | Date | Stamp | FX | Comm |  | Year | Stamp | FX | Comm
 | 2019-01-27 00:00:00 |  | 4.93 | 4.95 |  | 2008
 | 2020-02-26 00:00:00 |  | 9.93 | 4.95 |  | 2009
 | 2021-02-26 00:00:00 |  | 4.99 | 4.95 |  | 2010
 | 2021-05-28 00:00:00 |  | 9.98 | 4.95 |  | 2011
 | 2021-08-31 00:00:00 |  | 35.97 | 4.95 |  | 2012
 | 2021-08-31 00:00:00 |  | 4.99 | 4.95 |  | 2013
 | 2021-09-10 00:00:00 |  | 6.19 | 9.95 |  | 2014
 | 2021-11-19 00:00:00 |  |  |  |  | 2015
 | 2021-11-19 00:00:00 |  |  |  |  | 2016
 | 2021-12-31 00:00:00 |  |  |  |  | 2017
 | 2022-01-24 00:00:00 | 10 |  | 4.95 |  | 2018
 | 2022-02-28 00:00:00 |  |  |  |  | 2019
 | 2022-05-04 00:00:00 | 9.99 |  | 9.95 |  | 2020
 | 2022-05-20 00:00:00 | 9.99 |  | 9.95 |  | 2021
 | 2022-05-31 00:00:00 |  |  |  |  | 2022
 | 2022-08-31 00:00:00 |  | 67 |  |  | 2023
 | 2022-08-31 00:00:00 |  |  |  |  | 2024
 | 2023-05-30 00:00:00 | 24.94 |  | 9.95 |  | 2025
 | 2023-06-21 00:00:00 | 14.96 |  | 9.95 |  | 2026
 | 2023-06-28 00:00:00 | 29.97 |  | 9.95 |  | 2027
 | 2023-08-18 00:00:00 |  |  |  |  | 2028
 | 2023-08-22 00:00:00 | 1.51 |  | 1.5 |  | 2029
 | 2023-11-03 00:00:00 |  |  |  |  | 2030
 | 2023-11-07 00:00:00 | 1.51 |  | 1.5 |  | 2031
 | 2024-02-01 00:00:00 |  |  |  |  | 2032
 | 2024-02-05 00:00:00 | 1.53 |  | 1.5 |  | 2033
 | 2024-05-02 00:00:00 |  |  |  |  | 2034
 | 2024-05-07 00:00:00 | 1.66 |  | 1.5 |  | 2035
 | 2023-08-31 00:00:00 |  |  |  |  | 2036
 | 2023-09-04 00:00:00 | 1.91 |  | 1.5 |  | 2037
 | 2023-12-01 00:00:00 |  |  |  |  | 2038
 | 2023-12-01 00:00:00 |  |  |  |  | 2039
 | 2023-12-05 00:00:00 | 1.95 |  | 1.5 |  | 2040
 | 2023-12-31 00:00:00 |  |  |  |  | 2041
 | 2024-03-01 00:00:00 |  |  |  |  | 2042
 | 2024-03-05 00:00:00 | 1.99 |  | 1.5 |  | 2043
 | 2024-05-07 00:00:00 |  |  | 5 |  | 2044
Spreadsheet: 844709d1696420737-return-code-of-a-cell-matched-by-location-and-part-of-the-name-do-not-use-same-results-excel-formula-help2-edited
Sheet: Sheet1

Name Part | Location |  |  | Matched Code | [NAME] | Code must be |  |  | Name | Location | Code
apple | London |  |  |  |  | N5 |  |  | apple pie | Rome | N1
melon | Rome |  |  |  |  | N10 |  |  | apple juice | Madrid | N2
pear | Madrid |  |  |  |  | N8 |  |  | 555apple | Rome | N3
apple | London |  |  |  |  | N13 |  |  | apple4 | Madrid | N4
melon | London |  |  |  |  | N9 |  |  | apple5 | London | N5
melon | London |  |  |  |  |  |  |  | pear1 | London | [NAME]
melon | Rome |  |  |  |  | N16 |  |  | pear2 | Rome | N7
pear | Madrid |  |  |  |  |  |  |  | pear3 | Madrid | N8
apple | Madrid |  |  |  |  | N2 |  |  | melon1 | London | N9
pear | Rome |  |  |  |  | N7 |  |  | [NAME] | Rome | N10
apple | london |  |  |  |  | [NAME] |  |  | apple6 | Madrid | N11
apple | london |  |  |  |  | N15 |  |  | [NAME] | Rome | N12
apple | london |  |  |  |  |  |  |  | apple543 | London | N13
apple | london |  |  |  |  |  |  |  | apple5433 | London | [NAME]
apple | london |  |  |  |  |  |  |  | apple 43 | London | N15
apple | london |  |  |  |  |  |  |  | melon33 | Rome | N16
apple | london
Spreadsheet: bd987126-8206-4a0a-893d-f9e33aa2e658
Sheet: Summer 2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
[NAME]
Summer 2016
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 858902d1707400707-help-sumif-multiple-tabs-example2
Sheet: August

Name | NHS | 1st | 2nd | 3rd | Seen | Comments |  |  | Month Summary
Name 92
Name 93
Name 94 |  |  |  |  |  |  |  |  | Done Totals
Name 95 |  |  |  |  |  |  |  |  | Outstanding Totals
Name 96
Name 97 |  |  |  |  | dd
Name 98
Name 99
Name 100
Name 101 |  |  |  |  | dddd
Name 102
Name 103
Spreadsheet: 0622202b-6048-43db-9891-814522047e4a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
0.125 |  | 0.25 | 0.125 |  | Total offerings |  |  | +
0.25 |  | 0.5 | 0.25 |  | Total oz equivalents |  |  | -
0.375 |  | 0.75 | 0.375 |  |  |  |  | *
0.5 |  | 1 | 0.5 |  |  |  |  | /
0.625 |  | 1.25 | 0.625
0.75 |  | 1.5 | 0.75
0.875 |  | 1.75 | 0.875
1 |  | 2 | 1
1.125 |  |  | 1.125
1.25 |  |  | 1.25
1.375 |  |  | 1.375
1.5 |  |  | 1.5
1.625 |  |  | 1.625
1.75 |  |  | 1.75
1.875 |  |  | 1.875
2 |  |  | 2
 |  |  | 2.125
 |  |  | 2.25
 |  |  | 2.375
 |  |  | 2.5
 |  |  | 2.625
 |  |  | 2.75
 |  |  | 2.875
 |  |  | 3
Spreadsheet: 54643d1254694144-excel-accounting-help-701934-excel-accounting-help
Sheet: Sales

Date | Code | Item | Sold | Price | Total | Notes
2009-07-29 00:00:00 | [NAME] | 50mm x 35mm Keyring | 30 | 14.2 | 426.0000000000001
2009-07-29 00:00:00 | [NAME] | 50mm x 35mm Keyring | 12 | 14.6 | 175.2
2009-07-29 00:00:00 | [NAME] | 50mm x 35mm Keyring | 20 | 14.4 | 288.0000000000001
2009-07-29 00:00:00 | [NAME] | 50mm x 35mm Keyring | 7 | 14.8 | 103.6
2009-08-29 00:00:00 | [NAME] | 50mm x 35mm Keyring | 2 | 15 | 30
2009-08-29 00:00:00 | [NAME] | 50mm x 35mm Keyring | 2 | 15 | 30
2009-08-29 00:00:00 | [NAME] | 50mm x 35mm Keyring | 1 | 15 | 15
2009-08-29 00:00:00 | PG-Heart | Heart Photo Globe | 1 | 6 | 6
2009-08-29 00:00:00 | PG-Glitter | Glitter Photo Globe | 1 | 7.5 | 7.5
2009-08-29 00:00:00 | PG-Snow | Snow Photo Globe | 1 | 7.5 | 7.5
2009-09-29 00:00:00 | PG-Snow | Snow Photo Globe | 45 | 7.5 | 337.5
2009-09-29 00:00:00 | PG-Glitter | Glitter Photo Globe | 1 | 7.5 | 7.5
2009-09-29 00:00:00 | PG-Heart | Heart Photo Globe | 1 | 6 | 6
2009-09-29 00:00:00 | PG-Heart | Heart Photo Globe | 1 | 6 | 6 | Display Stock
2009-09-29 00:00:00 | PG-Snow | Snow Photo Globe | 1 | 7.5 | 7.5 | Display Stock
2009-09-29 00:00:00 | PG-Glitter | Glitter Photo Globe | 1 | 7.5 | 7.5 | Display Stock
2009-10-04 00:00:00 | [NAME] | 50mm x 35mm Keyring | 1 | 15 | 15 | Display Stock
2009-10-04 00:00:00 | PG-Snow | Snow Photo Globe | 1 | 7.5 | 7.5 | Damaged
2009-10-04 00:00:00 | MUG-Glass-Stein | [NAME] Beer Stein | 1 | 4.5 | 4.5 | Damaged
2009-10-04 00:00:00 | MUG-Glass-Stein | [NAME] Beer Stein | 1 | 4.5 | 4.5
2009-10-04 00:00:00 | DC-90S | 90mm Square Acrylic Drink Coaster | 2 | 33 | 66
2009-10-04 00:00:00 | DC-90S | 90mm Square Acrylic Drink Coaster | 4 | 33 | 132
2009-10-04 00:00:00 | [NAME] | 50mm x 35mm Keyring | 1 | 15 | 15
2009-10-04 00:00:00 | [NAME] | 50mm x 35mm Keyring | 1 | 15 | 15
2009-10-04 00:00:00 | [NAME] | 50mm x 35mm Keyring | 1 | 15 | 15
2009-10-04 00:00:00 | [NAME] | 50mm x 35mm Keyring | 20 | 14.4 | 288.0000000000001
2009-10-04 00:00:00 | [NAME] | 50mm x 35mm Keyring | 2 | 15 | 30 | Display Stock
2009-10-04 00:00:00 | DC-90S | 90mm Square Acrylic Drink Coaster | 28 | 32.19999999999999 | 901.5999999999997
2009-10-04 00:00:00 | DC-90S | 90mm Square Acrylic Drink Coaster | 3 | 33 | 99 | Display Stock
2009-10-04 00:00:00 | MP-DIY | Do It Yourself Mousepad | 2 | 22.5 | 45
2009-10-04 00:00:00 | MP-DIY | Do It Yourself Mousepad | 1 | 22.5 | 22.5
2009-10-04 00:00:00 | MP-DIY | Do It Yourself Mousepad | 1 | 22.5 | 22.5
2009-10-04 00:00:00 | MP-DIY | Do It Yourself Mousepad | 2 | 22.5 | 45
2009-10-04 00:00:00 | MP-DIY | Do It Yourself Mousepad | 21 | 21.9 | 459.9
2009-10-04 00:00:00 | MP-DIY | Do It Yourself Mousepad | 2 | 22.5 | 45 | Display Stock
2009-10-04 00:00:00 | MP-Printed | Printed Mousepad | 6 | 8.8 | 52.8
2009-10-04 00:00:00 | KR-BOB | Black Bottle Opener Keyring | 1 | 10.5 | 10.5
Spreadsheet: 784434d1655733722-amend-formula-to-look-at-cell-above-and-below-test1
Sheet: Info

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B&b | Morning/Night | First/Last | DormBnt Periods |  | Rest | Data Check | Data Check |  | HH | MM | SS
Spreadsheet: 2a1e181b-86ef-432c-9da5-35976cd5557e
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
HAZ | Test | HAZ | Hazelnut-Tree, IgE | Hazelnut-Tree, 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
HAZ | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
HAZ | Result | HAZ | Hazelnut-Tree, IgE | Hazelnut-Tree, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6137-4
Spreadsheet: 4503e02c-49d1-46ab-ab26-f100bc01fcf8
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
 |  | U.S. Census Bureau
 |  | Source: Manufactured Homes Survey
 |  | Total Homes: U.S. Total
 |  | Not Seasonally Adjusted Total Placements [Thousands of Units]
 |  | Period: 2000 to 2013
 |  | Data Extracted on: May 21, 2013 (9:32 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2000 | 18.5 | 23.6 | 30.4 | 25.3 | 28.7 | 27 | 23.7 | 25.9 | 22.9 | 22 | 17.3 | 15.5
2001 | 12.9 | 14.1 | 15.5 | 15 | 16.8 | 18.4 | 17.4 | 19 | 18.5 | 18.6 | 15.6 | 14.4
2002 | 11.4 | 12 | 13.2 | 14.8 | 18.9 | 16.4 | 15.5 | 16.9 | 14.6 | 15.9 | 12.6 | 12
2003 | 9.5 | 7.5 | 11.5 | 11.9 | 13 | 12.3 | 11.8 | 12.8 | 13 | 14.6 | 11.4 | 10.5
2004 | 8.2 | 7.4 | 9.8 | 11.4 | 11.6 | 12.7 | 12.2 | 10.7 | 10.7 | 10.9 | 8.8 | 9.9
2005 | 8.7 | 8 | 9.2 | 9.6 | 11.3 | 12.3 | 11.3 | 11.9 | 10.6 | 11.5 | 10 | 8.6
2006 | 8.3 | 7.6 | 9.4 | 9 | 11 | 11.8 | 9.9 | 10.5 | 9.6 | 8.8 | 8.7 | 7.8
2007 | 5.6 | 5.3 | 8.1 | 7.2 | 9.1 | 10 | 8.9 | 9 | 8.3 | 8.7 | 8.5 | 6.1
2008 | 4.8 | 5.9 | 6.7 | 7.1 | 7.9 | 7.9 | 7.6 | 7.6 | 7.2 | 7.2 | 5.4 | 5.3
2009 | 4 | 3.2 | 4.7 | 4.8 | 4.7 | 4.7 | 4.6 | 4.2 | 4.9 | 5.2 | 5.4 | 4
2010 | 2.8 | 2.8 | 4 | 5 | 5.4 | 5.9 | 4.7 | 4.8 | 3.8 | 4.4 | 3.4 | 3.6
2011 | 2.3 | 2.7 | 3.5 | 4 | 3.9 | 4.9 | 4.1 | 4.6 | 4 | 4.4 | 4.9 | 3.7
2012 | 2.9 | 3.2 | 4.4 | 4.4 | 4.9 | 4.6 | 4 | 5.1 | 4.4 | 4.7 | 4.9 | 3.9
2013 | 2.6 | 3
Spreadsheet: 725941d1616982904-two-way-xlookup-2way-xlookup
Sheet: Sheet1

Part ID | Part Name | Column Name |  | Part ID | Evolution | Eliminator TF | Eliminator BP | Channel Flow
710 | US-MADAC-18M | Evolution |  |  |  | BHMA18M-TF | BHMA18M | AG-MADAC-18M
710 | BHMA18M-TF | Eliminator TF |  | 711 | test | BHMA18M-TF
710 | BHMA18M | Eliminator BP |  | 712 | rwar712 |  | jklwejlk
710 | AG-MADAC-18M | Channel Flow
711 | test | Evolution
711 | BHMA18M-TF | Eliminator TF
712 | rwar712 | Evolution
712 | jklwejlk | Eliminator BP
Spreadsheet: 837358d1690092087-using-if-index-match-index-match-1-
Sheet: Sheet1

 |  | looking for response=2650(D8)
Im looking for the value in the below table based on A4 which needs to match $B$6,$C$6,or $[NAME] and A5 needs to match an item in column A9:A17
3
Invitee, Spouse
Adults 12 and up, Adults 12 and up, Adults 12 and up, Spouse, Invitee, Adults 12 and up
 | 3 | 2 | 4
[NAME] individually | 1600 | 1350 | 1850
Invitee & Spouse | 2400 | 2150 | 2650
Guest | 1200 | 2150 | 2650
Spouse | 1200 | 2150 | 2650
Adults 18+ | 750 | 500 | 1000
Adults 12 and up | 750 | 500 | 1000
Child 0 – 3 years | 0 | 0 | 0
Child 4 – 12 years | 550 | 400 | 650
extra room | 450 | 300 | 600
Invitee | 1200 | 2150 | 2650
what if now A5 has the values From A6 and I want to calc how much it cost for all, so I want to count how many of each category in A and mulitply I by the correct value in B,C,or D Depending on A4
So I need a way to count the  4 Adults and up,  1 Spouse, 1 Invitee and multiply them by the correct value in B,C, or D
looking for 4*1000+1200+1200 = 6400
Spreadsheet: 69fd386f-d48c-4f87-a60b-144a4c31aeef
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
 |  | U.S. Census Bureau
 |  | Source: Construction Spending
 |  | Total Construction: U.S. Total
 |  | Seasonally Adjusted Total Construction [Millions of Dollars]
 |  | Period: 2002 to 2012
 |  | Data Extracted on: October 24, 2014 (8:15 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012