tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 853525d1703371040-make-formula-dynamic-dropdown-list-showing-blanks-dropdownlist-v2_2
Sheet: D

Dropdown | Cond | Values
[0 - 10] |  | 3
[10 - 20] |  | 10
[20 - 30] |  | 10
[0 - 10] |  | 10
[40 - 50] |  | 40
[20 - 30] |  | 20
[60 - 70] |  | 60
[50 - 60] |  | 50
[50 - 60] |  | 50
[50 - 60] |  | 50
[50 - 60] |  | 50
[50 - 60] |  | 50
[50 - 60] |  | 50
[50 - 60] |  | 50
[70 - 80] |  | 70
[50 - 60] |  | 50
[50 - 60] |  | 50
[50 - 60] |  | 50
[50 - 60] |  | 50
[50 - 60] |  | 50
Spreadsheet: 0ea7032e-95da-4f02-9f7d-8e8e79588649
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
FBISB | Test | FBISB | Bismuth, Blood | Bismuth, Blood | Inductively Coupled Plasma/Mass Spectrometry (ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 2 | mL | Draw blood in an EDTA metal-free royal blue top tube(s). Send 2 mL metal-free EDTA whole blood refrigerated. | 0.2 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Normal (Unexposed Population):              	<50.0 ng/mL      Exposed:     100.0 ng/mL      Toxic:       	200.0 ng/mL      Test Performed by: Medtox Laboratories, Inc.                              402 W County Road D                              St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 83018 |  |  |  |  | Medtox Laboratories, Inc.
FBISB | [NAME] | WBEDTAMF | [NAME] EDTA - Metal Free (ERB) |  |  |  | Refrigerated | 14 days
FBISB | Result | Z1205 | Bismuth | Bismuth | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 804049d1667856170-if-and-then-formula-issue-sample-workbook
Sheet: Sheet1

Single Nozzle
Nozzle Information | Input |  | Fabrication Information
[NAME] in inches | 8 |  | Pipe Cut Length
Pipe size (inches, in shortest decimal form, ie.: 0.5, 0.75, 1, 1.25, 1.5, 2, 2.5, etc… | 6 |  | Flange OD (inches)
Pipe type (Sch or OD) | OD |  | Flange ID (inches)
End Flange Type (150# or PL) |  |  | Flange BC (inches)
If plate, thickness? (inches in decimal, ie.: 0.25) |  |  | # of bolts in flange
If plate, bolt size? (inches in decimal, ie.: 0.5) |  |  | Degree of bolt spacing
Wall Flange Type (150# or PL) |  |  | 150# flange bolt hole diameter
If plate, thickness? (inches in decimal, ie.: 0.25) |  |  | 150# flange bolt diameter
If plate, bolt size? (inches in decimal, ie.: 0.5) |  |  | End flange plate bolt hole diameter
Material Type |  |  | End flange plate bolt diameter
If other material type, specify |  |  | Wall flange plate bolt hole diameter
Material Finish |  |  | Wall flange plate bolt diameter
If other material finish, specify (if powder coat, specify color)
Backer flange required?  (If yes, copy "Wall Flange" requirements/dims/etc…)
Spreadsheet: andy_zipper__174__DYNEGY-ICE VOL Apr20
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-20-01 thru Apr-20-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Spreadsheet: 64596d1265396127-compare-cell-data-and-add-to-next-cell-level-account
Sheet: AccountSheet

Level Account |  |  |  |  |  |  |  |  | GOLD |  |  | 50
NAME | BLOW, JOE
DATE | LEVEL | POINTS AWARDED | POINTS USED | BALANCE
2009-11-30 00:00:00 | NEW ACCOUNT |  |  | 50
2009-12-07 00:00:00 | BRONZE | 0 |  | 50
2009-12-14 00:00:00 | BRONZE | 0 |  | 50
2009-12-21 00:00:00 | SILVER | 100 | 150 | 0
2009-12-28 00:00:00 | SILVER | 100 | 50 | 50
2010-01-04 00:00:00 | GOLD | 150 | 200 | 0
2010-01-11 00:00:00 | GOLD | 150 | 100 | 50
Spreadsheet: 163012d1340144919-count-cells-in-a-column-with-certain-criteria-hhh-niko79542-oeldere2-
Sheet: Sheet1

 | 2 | 2
 | B | C
 | 1 | 4
 | 2 | 4
 | 3 | 4
 | 4 | 4
 | 0 | 0
 | 0 | 4
 | 5 | 4
 | 5 | 4
 | 0 | 4 |  |  |  | C | 4
 |  |  |  |  |  | B | 0
 |  |  |  |  |  |  | Gegevens
 | 0 |  |  |  |  |  | Count  B | count  C
 | 3 |  |  |  |  | Totaal | 2 | 2
0
 | 2
Spreadsheet: 134395d1325265532-formula-to-pull-cell-info-from-workbook-auto-filter301211
Sheet: 6450

[NAME] Record |  |  | RO NUMBER | 6446
 | TOTAL PARTS/SERVICE | 2319.96 | VEHICLE MAKE: | Nissan
 | TOTAL RECIVABLE | 0 | MODEL: | Pathfinder | OWNER NAME:
 | DEDUCTABLE | 500 | YEAR: | 1999 | VIN NO:
 | CUSTOMER PAY | 0 | LICENSE NO: |  | INSURANCE:
 | BALANCE DUE | -500
 | [NAME] | OPEN |  | IN | OUT | DATE
 |  | OPEN | MILEAGE |  |  | DROPPED OFF | PICKED UP
 |  | CLOSED |  |  |  | 2011-11-01 00:00:00 | 2011-11-15 00:00:00
DATE | INVOICE No. | SUPPLIER | PART DESCRIPTION | USED/NEW/SVC | CHECK NO. | AMOUNT PAID | CUST PAY | DEDUCT | PYMNT RCVD
2011-11-01 00:00:00 |  | rolando towing | towing services | service |  | 60
2011-11-03 00:00:00 | 198522 | universal city nissan | apron, [NAME], over fender, duct, mudguard, extenion | new | 21800 | 707.13
2011-11-03 00:00:00 | 31741308 | lkq | l-fender | used | 21789 | 210
2011-11-03 00:00:00 | 198522 | universal city nissan | bumper fr | new | 21806 | 219.65
2011-11-03 00:00:00 | 335 | rsr wheel repair | wheel repair and refinish, mount and balance | service | 21830 | 99
2011-11-03 00:00:00 | 31741320 | lkq | L- knee | used | 21866 | 100
2011-11-03 00:00:00 | 747493-1 | universal city nissan | [NAME] - turn | new | 21868 | 38.48
2011-11-08 00:00:00 | 747763 | universal city nissan | [NAME] | new | 21868 | 147.32
2011-11-08 00:00:00 | 747974 | universal city nissan | SLIDER BUMPER | new | 21878 | 11.39
2011-11-08 00:00:00 | 748010 | universal city nissan | sensor assy | new | 21901 | 113.88
2011-11-08 00:00:00 | 748254 | universal city nissan | clip, bmpr front, protector, over fender assy | new | 21963 | 268.11
2011-11-08 00:00:00 | 88274 | american tire depot | tire, balance, installation | sublet service |  | 195
2011-11-08 00:00:00 | 96557 | prime auto parts & sal | undercarriage crossmember | used |  | 150
2011-11-15 00:00:00 |  |  | deductable |  |  |  |  | 500
2011-11-15 00:00:00 |  |  | vehicle pu
 |  |  |  |  |  | 2319.96 | 0 | 500 | 0
Spreadsheet: 750661d1633573537-cell-contains-a-date-then-returns-a-certain-text-permit-register-example-7-10-2021
Sheet: To Approve

ABC Job Number | Address | Description | Client | Permit  Number | BP | OP
 | Address 4 | Description 4 | Client 4 | 001/001/004 | 2021-05-04 00:00:00 | APPROVE
ABC-21022 | Address 22 | Description 22 | Client 22 | 001/001/022 | APPROVE | APPROVE
Spreadsheet: 139174d1328114814-list-boxes-in-combination-assets
Sheet: Sheet1

Asset Type | Asset Class
Water Mains |  |  | Water Mains | General Assets | Pumping | Treatment Systems | Storage, Civil and Concrete Structures. | Network Services | Control Systems | Water Quality meters
General Assets |  |  | Unlined Cast Iron | Plant inlet [NAME] | Pumps less than 5kW | Flouride metering systems and pipework | Concrete Tanks and Storages | Water Services | PLC Units | Turbidimeters/Turbidity meters
Pumping |  |  | Insitu Lined Cast Iron with Lead Jointing |  | Pump/Motor Units 5kW-20kW | Sulphuric Acid Systems | Dams and [NAME] |  | Printed circuit control cards | Aluminium analysers
Treatment Systems |  |  | DICL with Rubber Ring Jointing |  | Pump/Motor Units 20kW-50kW | Alum Dosing Systems | Steel and lined Timber tanks |  | Computers | [NAME]
Storage, Civil and Concrete Structures. |  |  | [NAME] |  | Pump/Motor Units 50kW-200kW | Lime Dosing Systems | Evaporation Basins (Rehabilitation Cycle) |  | Chemical dosing control systems (General) | pH meters
Network Services |  |  | PVC |  | Pump/Motor Units 200kW-1200kW | Potassium Permanganate Systems | Manholes |  | Telemetry Systems (Central)
Electrical Assets |  |  | HDPE, MDPE, PE (Assume appropriate selection) |  | Pump Motor Units Greater than 1200kW | Activated Carbon | Filter structure |  | Telemetry Systems RTUs
Control Systems |  |  |  |  | Flocculators | Poly electrolyte systems | Storage tank roofs
Water Quality meters |  |  |  |  | Instrument air compressors | Sand Filtration underdrain | Building Roofs
 |  |  |  |  | Air blowers
 |  |  |  |  | Cranes and fixed lifting equipments
Spreadsheet: 77544d1277994986-move-cells-around-based-on-a-template-20100701
Sheet: Sheet2

id | dog | cat | train | water | red | hollow | duck
1 |  | cat |  | water |  |  | duck
2 |  |  | train |  | red
3 | dog |  |  |  |  |  | duck
4 |  |  |  |  |  |  | duck
5 |  |  |  |  | red
Spreadsheet: 050a56dd-3478-497f-bba1-309e87024b46
Sheet: Sheet1

Table 1--U.S. cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  | 2012/13
Item | 2011/12 |  | Aug. |  | Sep. |  | Oct.
 | Million acres
Upland:
Planted | 14.428 |  | 12.4 |  | 12.121 |  | 12.121
Harvested | 9.156 |  | 10.577 |  | 10.206 |  | 10.206
 | Pounds
Yield/harvested acre | 772 |  | 771 |  | 774 |  | 782
 | Million 480-lb. [NAME]
Beginning stocks | 2.572 |  | 3.032 |  | 3.081 |  | 3.081
Production | 14.722 |  | 16.988 |  | 16.452 |  | 16.63
Total supply   1/ | 17.307 |  | 20.025 |  | 19.538 |  | 19.716
[NAME] use | 3.278 |  | 3.375 |  | 3.375 |  | 3.375
Exports | 11.12 |  | 11.375 |  | 11.075 |  | 10.875
Total use | 14.398 |  | 14.75 |  | 14.45 |  | 14.25
Ending stocks  2/ | 3.081 |  | 5.319 |  | 5.124 |  | 5.424
 | Percent
Stocks-to-use ratio | 21.4 |  | 36.1 |  | 35.5 |  | 38.1
 | 1,000 acres
Extra-long staple:
Planted | 307.4 |  | 235 |  | 239 |  | 239
Harvested | 304.9 |  | 233.4 |  | 237.4 |  | 237.4
 | Pounds
Yield/harvested acre | 1340 |  | 1363 |  | 1328 |  | 1328
 | 1,000 480-lb. [NAME]
Beginning stocks | 28 |  | 268 |  | 269 |  | 269
Production | 851 |  | 663 |  | 657 |  | 657
Total supply   1/ | 885 |  | 931 |  | 926 |  | 926
[NAME] use | 22 |  | 25 |  | 25 |  | 25
Exports | 594 |  | 725 |  | 725 |  | 725
Total use | 616 |  | 750 |  | 750 |  | 750
Ending stocks  2/ | 269 |  | 181 |  | 176 |  | 176
 | Percent
Stocks-to-use ratio | 43.7 | 30.2 | 24.1 |  | 23.5 |  | 23.5
1/ Includes imports.  2/ Includes unaccounted.
Last update:  10/12/12.
Sources: USDA, World Agricultural Outlook Board; and USDC,
U.S. Census Bureau.
Spreadsheet: 857030d1706119476-vlookup-and-indirect-maybe-cant-har_test_chopped_down-1-
Sheet: DATABASE

Hull | HAR NUMBER | Column2 | [NAME] | [NAME] | System | Sub-System | Casual Factor | Mishap | Effects | Event | Phase | Risk Matrix (7 X) | Initial Risk | Current Risk | Target Risk | Software Contribution to Risk | Legacy Hars
CVN-78 | [NAME] | 138 |  |  |  |  |  |  |  |  |  | Seven | 1C High | 2B High (Footnote 2) | 6A Serious
CVN-78 | [NAME] | 267 |  |  |  |  |  |  |  |  |  | Seven | 2A High | 1G Serious | 7B Medium
CVN-79 | [NAME] |  |  |  |  |  |  |  |  |  |  | Eight | 2C High | 1B High (Footnote 2) | 2E Serious
CVN-79 | [NAME] |  |  |  |  |  |  |  |  |  |  | Seven | 4F Medium | 2C High
Spreadsheet: 4547bdc9-d899-42f0-b282-9085d641ac92
Sheet: 16. Disposition by Method

 | FY 2013 Federal Real Property Charts
 | Dispositions by Method†
 | Disposition Method | Number of Assets | SF | Acres | Disposition Value | FY 13 Annual Operating Costs
 | Demolition | 5412 | 13881269.58 |  | 5402890.28 | 60964010.823
 | Federal Transfer | 411 | 1531994 | 2814.36 | 590337.08 | 3009965.567
 | Health or Educational Use | 7 | 33220 |  |  | 487557.68
 | [NAME] | 4 | 62324.29 |  |  | 336935.53
 | Law Enforcement and Emergency Management Response | 4 | 168 | 4.49 |  | 1260
 | Lease Expiration | 238 | 2191788.94 | 565.228 |  | 62943553.23
 | Lease Termination | 2659 | 9413359.73 | 1161.853 |  | 165232063.24
 | Negotiated Sale | 363 | 1158098 | 279.216 | 594733759.031 | 15593160.26
 | Negotiated Sales to Public Agencies | 4 | 14178 |  |  | 36771.16
 | Other | 9398 | 24470061.81 | 9088.615 | 10231515.98 | 79778545.07100001
 | Public Benefit Conveyance | 619 | 1191428.76 | 1228.165 |  | 3643218.1
 | [NAME] and Public Recreational Area | 8 | 37543 |  |  | 523533.47
 | Public Sale | 57 | 862349.44 | 18.75 | 33754496.85 | 2756614.93
 | Sale | 2279 | 6552958 | 1025.748 | 1752832431.49 | 16020870.06
 | Total
 | † All real property data from the CFO Act agencies required to submit data to the FRPP
 | *Agencies can report one disposal method  from Public Building Conveyance, Federal Transfer, Sale, Demolition, Lease Termination or Other.  Subcategories found in FRPP Data Dictionary
 | **Has optional subcategories: [NAME], Public Sale
 | ***A disposition where disposal costs are greater than the sales price will result in a negative Net Proceeds.
 | ****Examples of "Other" include abandonment, loss due to natural disaster, and loss due to natural deterioration. Air Force, Army, Navy, and Transportation together comprise 97% of all "Other" disposed assets reported by CFO Act Agencies.
Spreadsheet: 64783d1265630755-lookup-tracker
Sheet: Pallet Check

Current Pallet References | Status | Duplicates
Manually Enter Here | Return 'Pallet Reference Verified' or 'Not Found' here | No Duplicates Found Return 'No', If Duplicates Found Return The Sheets Duplicated (e.g. Sheet3; Sheet 87)
Manually Enter Here | Return 'Pallet Reference Verified' or 'Not Found' here | No Duplicates Found Return 'No', If Duplicates Found Return The Sheets Duplicated (e.g. Sheet3; Sheet 87)
Manually Enter Here | Return 'Pallet Reference Verified' or 'Not Found' here | No Duplicates Found Return 'No', If Duplicates Found Return The Sheets Duplicated (e.g. Sheet3; Sheet 87)
Manually Enter Here | Return 'Pallet Reference Verified' or 'Not Found' here | No Duplicates Found Return 'No', If Duplicates Found Return The Sheets Duplicated (e.g. Sheet3; Sheet 87)
Manually Enter Here | Return 'Pallet Reference Verified' or 'Not Found' here | No Duplicates Found Return 'No', If Duplicates Found Return The Sheets Duplicated (e.g. Sheet3; Sheet 87)
Manually Enter Here | Return 'Pallet Reference Verified' or 'Not Found' here | No Duplicates Found Return 'No', If Duplicates Found Return The Sheets Duplicated (e.g. Sheet3; Sheet 87)
Manually Enter Here | Return 'Pallet Reference Verified' or 'Not Found' here | No Duplicates Found Return 'No', If Duplicates Found Return The Sheets Duplicated (e.g. Sheet3; Sheet 87)
Manually Enter Here | Return 'Pallet Reference Verified' or 'Not Found' here | No Duplicates Found Return 'No', If Duplicates Found Return The Sheets Duplicated (e.g. Sheet3; Sheet 87)
Spreadsheet: 0459b515-2f6d-45a1-9508-f0010f0b7636
Sheet: Sheet1

Área | Perfil | Nombre
[NAME] | Empresas | 2014 - Subvenciones para el desarrollo y produccion de obras audiovisuales (Desarrollo)
[NAME] | Empresas | 2014 - Subvenciones para el desarrollo y produccion de obras audiovisuales (Largometrajes)
[NAME] | Empresas | 2014 - Subvenciones para el desarrollo y produccion de obras audiovisuales (Unidad Documental)
[NAME] | Empresas | 2014 - Subvenciones para el sector profesional del flamenco en Andalucía (Asistencia Festivales)
[NAME] | Empresas | Tramitación electrónica del Depósito Legal de Andalucía
[NAME] | Empresas | Tramitación electrónica del Registro de la Propiedad Intelectual en Andalucía
Spreadsheet: 777446d1650382995-attendance-rolling-12-month-calculator-attendance-example
Sheet: Sheet1

 | Employee Name | Total Points  this year | Total Points | 4/11/2022 | 4/12/2022 | 4/13/2022 | 4/14/2022 | 4/15/2022 | 4/16/2022 | 4/17/2022 | 4/18/2022 | 4/19/2022 | 4/20/2022 | 4/21/2022 | 4/22/2022 | 4/23/2022 | 4/24/2022 | 4/25/2022 | 4/26/2022 | 4/27/2022 | 4/28/2022 | 4/29/2022 | 4/30/2022 | 5/1/2022 | 5/2/2022 | 5/3/2022 | 5/4/2022 | 5/5/2022 | 5/6/2022
 | Employee A |  |  |  |  |  | 1 | 1
 | Employee B |  |  |  | 0.5 | 0.5 |  |  | 3
Spreadsheet: 683594d1592841404-formula-aggregate-and-rank-not-with-pivot-service-pilot-2
Sheet: Data

DATA
month | service | cost (EUR)
1 | car | 600
1 | car | 800
1 | train | 500
1 | car | 600
2 | train | 300
2 | car | 500
2 | train | 700
3 | bus | 699
3 | train | 600
3 | bike | 700
RESULTS
criteria for rank | service/month
1
Top service
2nd top service
3
Top service
2nd top service
 |  |  | should be formula for cells D25:D29, having references to citeria1 and [NAME] (just where exists) and of course to raw data
criteria description | criteria 1 | criteria 2 | result
input overall rank -->>result is service | 1 |  | car
input overall rank-->> result is service | 4 |  | bike
input rank and month -->> result is service | 1 | 2 | train
input service-->> result is rank | train |  | 2
input service and month--> result is rank | bike | 3 | 1
Spreadsheet: 472000d1469391633-help-on-price-increase-on-product-list-test-
Sheet: Sheet1

£ amount | 13
total items | 10
unit cost | 1.3 | 1.6 |  | 6.5 | 1.45 | 8 | 0.55 | 0.5 | 1
Product | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 | 5
 | 5
Spreadsheet: 34947d1232399649-average-lookup-average-20lookup-1-
Sheet: Sheet1

Report Number | Month Raised | Customer | Days open
1 | 2008-02-12 00:00:00 | A | 5
2 | 2008-02-01 00:00:00 | B | 3
3 | 2008-04-12 00:00:00 | A | 4
4 | 2008-04-01 00:00:00 | C | 8
5 | 2008-06-12 00:00:00 | B | 9
6 | 2008-07-12 00:00:00 | A | 2
7 | 2008-08-12 00:00:00 | B | 12
8 | 2008-09-12 00:00:00 | C | 1
9 | 2008-10-12 00:00:00 | A | 2
10 | 2008-11-12 00:00:00 | A | 6
11 | 2008-12-12 00:00:00 | B | 4
12 | 2008-12-01 00:00:00 | C | 2
Spreadsheet: 206498d1358202151-dropdown-list-containing-dd-mm-yyyy-nova-planilha-rh_1-new
Sheet: Horas Extras (Overtime)

Mês/Ano (das [NAME]): |  | 2013-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] preencher todos os campos necessários, salve este arquivo usando seu nome (Save As…) e envie [NAME]) supervisor(a).
Funcionário: |  |  |  | (Seu nome completo)
ATTUID: |  |  |  | (Seu ATTUID)
Cargo: |  |  |  | (Seu cargo)
Horário de Trabalho:
Supervisor: |  |  |  | (Nome completo do supervisor)
Localidade: |  | [NAME] |  | (Selecione seu local de trabalho)
 |  | Horário Normal |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | Para ser preenchido por RH
 |  | Início | [NAME] | Início | [NAME] | Início | [NAME] | Início | [NAME] | Motivo | Cliente | Servi�o | [NAME]o | Motivo: | Data | Total de Horas | Total de Horas/ 50% | Total de Horas/ 100% | Total de Horas/ Adicional Noturno
[NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A Compensar  Folga
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-02 00:00:00
RECONHEÇO A EXATIDÃO DESTAS ANOTAÇÕES
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total de Horas:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location: | OT Codes: | Services: | Region:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOCALIDADE | Holiday | AVPN | APAC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Americana - SP | Intrusive LMAC | CS | CALA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | LAN Migration | EVPN | EMEA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | GMIS | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Campinas - SP | Other - Customer | MLAN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Curitiba - SC | Other - Internal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Guarulhos – SP | PMACD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hortol�ndia - SP | Rack & Stack
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Joinville - SC | T&T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Time Zone
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rio de Janeiro - RJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S�o Paulo - SP
 |  | ______________________________________________________________________
 |  | ASSINATURA DO EMPREGADO
Spreadsheet: 146849d1332376531-drop-down-menus-and-associated-formulas-example-sheet-1-
Sheet: Sheet1

Activity | Reference | Quantity | Length | [NAME] | SqFt | Height | Volume | Cost/Unit | Material | Cost/Unit | Labor | Quantity | Unit | Cost/Unit | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drop down menu here
Activity | Reference | Quantity | Length | [NAME] | SqFt | Height | Volume | Cost/Unit | Material | Cost/Unit | Labor | Quantity | Unit | Cost/Unit | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is the table as it would be used.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I didn’t include a drop down here because its just the example
Example | [NAME]
Activity | Reference | Quantity | Length | Pounds/LF | Total Pounds | N/A | Total Tons | Cost/Unit | Material | Cost/Unit | Labor | Quantity | Unit | Cost/Unit | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Example | Each
Activity | Reference | Quantity | N/A | N/A | N/A | N/A | N/A | Cost/Unit | Material | Cost/Unit | Labor | Quantity | Unit | Cost/Unit | Total |  | These are the values that I would want the table above to show given a certain drop down option.
 |  |  |  |  |  |  |  |  |  |  |  |  | Each
Example | Square Feet
Activity | Reference | Quantity | Length | [NAME] | SqFt | Height | Volume | Cost/Unit | Material | Cost/Unit | Labor | Quantity | Unit | Cost/Unit | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | Square Feet