LIST_MATERIALS
Excel Usage
=LIST_MATERIALS()Returns (list[list]): Column of all valid material IDs.
Examples
Example 1: List all materials
Inputs:
|
|| | |
Excel formula:
=LIST_MATERIALS()Expected output:
| ACr 90 |
|---|
| ACrZ 20 |
| ACrZ 60 |
| AZS 33 |
| AZS 41 |
| Asbestos/cement shingles |
| Ash |
| Asphalt |
| Asphalt (bitumen with inert fill), 1600 kg/m^3 |
| Asphalt (bitumen with inert fill), 1900 kg/m^3 |
| Asphalt (bitumen with inert fill), 2300 kg/m^3 |
| Asphalt roll roofing |
| Asphalt shingles |
| Bauxite |
| Bauxite P5 |
| Birch |
| Bitumen, felt or sheet |
| Bitumen, pure |
| Board, Asbestos/cement |
| Board, Cement |
| Board, Fiber/cement, 1000 kg/m^3 |
| Board, Fiber/cement, 1400 kg/m^3 |
| Board, Fiber/cement, 300 kg/m^3 |
| Board, Fiber/cement, 400 kg/m^3 |
| Brick, fired clay, 1120 kg/m^3 |
| Brick, fired clay, 1280 kg/m^3 |
| Brick, fired clay, 1440 kg/m^3 |
| Brick, fired clay, 1600 kg/m^3 |
| Brick, fired clay, 1760 kg/m^3 |
| Brick, fired clay, 1920 kg/m^3 |
| Brick, fired clay, 2080 kg/m^3 |
| Brick, fired clay, 2240 kg/m^3 |
| Brick, fired clay, 2400 kg/m^3 |
| Built-up roofing |
| Calcitic, dolomitic, limestone, marble, and granite, 1600 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 1920 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 2240 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 2560 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 2880 kg/m^3 |
| California redwood |
| Carbon, anthracite |
| Carbon, graphite |
| Carpet and rebounded urethane pad |
| Carpet and rubber pad, one-piece |
| Cellular glass |
| Cement fiber slabs, shredded wood, with Portland cement binder |
| Cement fiber slabs, shredded wood, with magnesia oxysulfide binder |
| Cement plaster, sand aggregate |
| Clay tile, hollow, 1 cell deep |
| Clay tile, hollow, 2 cells deep |
| Clay tile, hollow, 3 cells deep |
| Concrete blocks, Limestone aggregate, 200 mm, 16 kg, 2200 kg/m^3, 2 cores with perlite-filled cores |
| Concrete blocks, Limestone aggregate, 300 mm, 25 kg, 2200 kg/m^3, 2 cores with perlite-filled cores. |
| Concrete blocks, low-mass aggregate, 150 mm, 7.5 kg, 1400 kg/m^3, 2 or 3 cores |
| Concrete blocks, low-mass aggregate, 150 mm, 7.5 kg, 1400 kg/m^3, with perlite-filled cores |
| Concrete blocks, low-mass aggregate, 150 mm, 7.5 kg, 1400 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3 |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with UF foam-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with molded EPS inserts in cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with molded-EPS-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with perlite-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, low-mass aggregate, 300 mm, 16 kg, 1400 kg/m^3, 2 or 3 cores |
| Concrete blocks, low-mass aggregate, 300 mm, 16 kg, 1400 kg/m^3, with perlite-filled cores |
| Concrete blocks, low-mass aggregate, 300 mm, 16 kg, 1400 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, 2 or 3 cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with molded EPS inserts in cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with molded-EPS-filled cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with perlite-filled cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2000 kg/m^3, 2 cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2100 kg/m^3, 2 or 3 cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2100 kg/m^3, with perlite-filled cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2100 kg/m^3, with vermiculite-filled cores |
| Concrete, Aerated concrete (oven-dried) |
| Concrete, Cement/lime, mortar, and stucco, 1280 kg/m^3 |
| Concrete, Cement/lime, mortar, and stucco, 1600 kg/m^3 |
| Concrete, Cement/lime, mortar, and stucco, 1920 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 1280 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 1600 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 640 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 960 kg/m^3 |
| Concrete, Foam concretes and cellular concretes, 320 kg/m^3 |
| Concrete, Foam concretes and cellular concretes, 640 kg/m^3 |
| Concrete, Foam concretes and cellular concretes, 960 kg/m^3 |
| Concrete, Foam concretes, 1120 kg/m^3 |
| Concrete, Foam concretes, 1280 kg/m^3 |
| Concrete, Foam concretes, 1600 kg/m^3 |
| Concrete, Foam concretes, 1920 kg/m^3 |
| Concrete, Gypsum/fiber concrete (87.5% gypsum, 12.5% wood chips) |
| Concrete, Low-mass aggregate or limestone |
| Concrete, Perlite, vermiculite, and polystyrene beads, 320 kg/m^3 |
| Concrete, Perlite, vermiculite, and polystyrene beads, 480 kg/m^3 |
| Concrete, Perlite, vermiculite, and polystyrene beads, 640 kg/m^3 |
| Concrete, Perlite, vermiculite, and polystyrene beads, 800 kg/m^3 |
| Concrete, Polymer cement |
| Concrete, Polymer concrete, 1950 kg/m^3 |
| Concrete, Polymer concrete, 2200 kg/m^3 |
| Concrete, Polystyrene concrete (oven-dried) |
| Concrete, Sand and gravel or stone aggregate concretes, 2080 kg/m^3 |
| Concrete, Sand and gravel or stone aggregate concretes, 2240 kg/m^3 |
| Concrete, Sand and gravel or stone aggregate concretes, 2400 kg/m^3 |
| Concrete, Slag concrete, 1280 kg/m^3 |
| Concrete, Slag concrete, 1600 kg/m^3 |
| Concrete, Slag concrete, 2000 kg/m^3 |
| Concrete, Slag concrete, 960 kg/m^3 |
| Concrete, high density |
| Concrete, medium density 1800 kg/m^3 |
| Concrete, medium density 2000 kg/m^3 |
| Concrete, medium density 2200 kg/m^3 |
| Concrete, reinforced with 1% steel |
| Concrete, reinforced with 2% steel |
| Corundum 90% |
| Corundum 99% |
| Corundum P10 |
| Corundum Spinel |
| Dolomite P10 |
| Douglas fir/larch |
| Eastern white cedar |
| Eastern white pine |
| Expanded polystyrene, extruded |
| Expanded polystyrene, molded beads |
| Expanded rubber |
| Fireclay |
| Floor covering, Linoleum |
| Floor covering, carpet / textile flooring |
| Floor covering, plastic |
| Floor covering, rubber |
| Floor covering, tiles, cork |
| Floor covering, underlay, cellular or plastic |
| Floor covering, underlay, cork |
| Floor covering, underlay, felt |
| Floor covering, underlay, wool |
| Fused silica |
| Gases, air |
| Gases, argon |
| Gases, carbon dioxide |
| Gases, krypton |
| Gases, sulphur hexafluoride |
| Gases, xenon |
| Glass fiber board |
| Glass, glass mosaic |
| Glass, quartz |
| Glass, soda lime |
| Glass-fiber batts, 50 mm |
| Glass-fiber batts, 90 mm |
| Gypsum or plaster board |
| Gypsum partition tile, 100 by 300 by 760 mm, 3 cells |
| Gypsum partition tile, 75 by 300 by 760 mm, solid, 3 cells |
| Gypsum partition tile, 75 by 300 by 760 mm, with 4 cells |
| Gypsum plaster, 1120 kg/m^3 |
| Gypsum plaster, 1280 kg/m^3 |
| Gypsum, 1200 kg/m^3 |
| Gypsum, 1500 kg/m^3 |
| Gypsum, 600 kg/m^3 |
| Gypsum, 900 kg/m^3 |
| Gypsum, plasterboard |
| Hardboard, high density, service-tempered grade and service grade |
| Hardboard, high density, standard-tempered grade |
| Hardboard, medium density |
| Hem/fir, spruce/pine/fir |
| High-duty fireclay |
| L1260 |
| L1400 |
| L1540 |
| L1760 |
| L1870 |
| Lightweight aggregate |
| Lightweight brick, 770 kg/m^3 |
| Lightweight brick, 800 kg/m^3 |
| Limestone, 2400 kg/m^3 |
| Limestone, 2600 kg/m^3 |
| Linoleum/cork tile |
| Loose fill, Cellulosic |
| Loose fill, Mineral fiber, 170 to 220 mm |
| Loose fill, Mineral fiber, 190 to 250 mm |
| Loose fill, Mineral fiber, 260 to 350 mm |
| Loose fill, Mineral fiber, 90 mm |
| Loose fill, Mineral fiber, 95 to 130 mm |
| Loose fill, Perlite, expanded, 100 kg/m^3 |
| Loose fill, Perlite, expanded, 150 kg/m^3 |
| Loose fill, Perlite, expanded, 50 kg/m^3 |
| Loose fill, Vermiculite, exfoliated, 120 kg/m^3 |
| Loose fill, Vermiculite, exfoliated, 80 kg/m^3 |
| Magnesia |
| Magnesite Chrome |
| Magnesite Graphite H15 |
| Magnesite P5 |
| Magnesite Spinel |
| Maple |
| Mastic asphalt (heavy, 20% grit) |
| Metals, aluminium alloys |
| Metals, brass |
| Metals, bronze |
| Metals, copper |
| Metals, iron, cast |
| Metals, lead |
| Metals, stainless steel |
| Metals, steel |
| Metals, zinc |
| Mineral fiber |
| Mineral fiberboard, wet felted |
| Mineral fiberboard, wet felted, acoustical tile, 290 kg/m^3 |
| Mineral fiberboard, wet felted, acoustical tile, 335 kg/m^3 |
| Mineral fiberboard, wet felted, core or roof insulation |
| Mineral fiberboard, wet-molded, acoustical tile |
| Mineral wool, felted, 100 kg/m^3 |
| Mineral wool, felted, 32 kg/m^3 |
| Mullite |
| Oak |
| Oriented strand board (OSB) |
| PVC/Rubber floor covering, Rubber tile |
| PVC/Rubber floor covering, Terrazzo |
| Particleboard, high density |
| Particleboard, low density |
| Particleboard, medium density |
| Particleboard, underlayment |
| Perlite aggregate |
| Perlite board |
| Perlite plaster, 400 kg/m^3 |
| Perlite plaster, 600 kg/m^3 |
| Phenolic foam board with facers, aged |
| Pile carpet with rubber pad |
| Pine (oven-dried) |
| Plasters and renders, cement sand |
| Plasters and renders, gypsum insulating plaster |
| Plasters and renders, gypsum plastering, 1000 kg/m^3 |
| Plasters and renders, gypsum plastering, 1300 kg/m^3 |
| Plasters and renders, gypsum sand |
| Plasters and renders, lime sand |
| Plastics, Polyvinylchloride (PVC) |
| Plastics, acrylic |
| Plastics, epoxy resin |
| Plastics, phenolic resin |
| Plastics, polyacetate |
| Plastics, polyamide (nylon) |
| Plastics, polyamide 6.6 with 25% glass fibre |
| Plastics, polycarbonates |
| Plastics, polyester resin |
| Plastics, polyethylene / polythene, high density |
| Plastics, polyethylene / polythene, low density |
| Plastics, polymethylmethacrylate (PMMA) |
| Plastics, polypropylene |
| Plastics, polypropylene with 25% glass fibre |
| Plastics, polystyrene |
| Plastics, polytetrafluoroethylene (PTFE) |
| Plastics, polyurethane (PU) |
| Plywood (douglas fir) |
| Plywood/wood panels |
| Polyisocyanurate, aged, unfaced |
| Polyisocyanurate, aged, with facers |
| Pulpboard or paper plaster |
| Quartzitic and sandstone, 1920 kg/m^3 |
| Quartzitic and sandstone, 2240 kg/m^3 |
| Quartzitic and sandstone, 2560 kg/m^3 |
| Reed thatch |
| Roofing felt |
| Rubber, butadiene |
| Rubber, butyl (isobutene), solid melt |
| Rubber, ethylene propylene diene monomer (EPDM) |
| Rubber, foam rubber |
| Rubber, hard rubber (ebonite), solid |
| Rubber, natural |
| Rubber, neoprene (polychloroprene) |
| Rubber, polyisobutylene |
| Rubber, polysulfide |
| SIC 40% |
| SIC 70% |
| SIC 90% |
| Sand aggregate |
| Sand/cement plaster, conditioned |
| Sand/cement/lime plaster, conditioned |
| Sand/gypsum (3:1) plaster, conditioned |
| Sealant, elastomeric foam, flexible |
| Sealant, polyethylene foam |
| Sealant, polyurethane (PU) foam |
| Sealant, polyvinylchloride (PVC) flexible, with 40% softner |
| Sealant, silica gel (dessicant) |
| Sealant, silicone foam |
| Sealant, silicone, filled |
| Sealant, silicone, pure |
| Sealant, urethane / polyurethane (thermal break) |
| Shingles, Asbestos/cement |
| Shingles, Siding, Asbestos/cement, lapped |
| Shingles, Siding, Asphalt roll siding |
| Shingles, Wood, 400 mm, 190 mm exposure |
| Shingles, Wood, double, 400 mm, 300 mm exposure |
| Shingles, Wood, plus ins. backer board |
| Siding, Aluminum, steel, or vinyl, over sheathing foil-backed |
| Siding, Aluminum, steel, or vinyl, over sheathing, hollow-backed |
| Siding, Aluminum, steel, or vinyl, over sheathing, insulating-board-backed |
| Siding, Architectural (soda-lime float) glass |
| Siding, Asphalt insulating siding |
| Siding, Hardboard siding |
| Siding, Wood, bevel, 200 mm, lapped |
| Siding, Wood, bevel, 250 mm, lapped |
| Siding, Wood, drop, 200 mm |
| Siding, Wood, plywood, lapped |
| Silica |
| Silica special |
| Sillimanite |
| Sillimanite P5 |
| Slag wool, 120 kg/m^3 |
| Slag wool, 255 kg/m^3 |
| Slag wool, 305 kg/m^3 |
| Slag wool, 350 kg/m^3 |
| Slag wool, 400 kg/m^3 |
| Slate |
| Solids, clay or silt |
| Solids, sand and gravel |
| Southern cypress |
| Southern pine |
| Southern yellow pine |
| Spray-applied Cellulosic fiber |
| Spray-applied Glass fiber |
| Spray-applied Polyurethane foam, 40 kg/m^3 |
| Spray-applied Polyurethane foam, 7 kg/m^3 |
| Spray-applied Polyurethane foam, aged and dry, 120 mm |
| Spray-applied Polyurethane foam, aged and dry, 40 mm |
| Spray-applied Polyurethane foam, aged and dry, 50 mm |
| Spray-applied Ureaformaldehyde foam, dry |
| Spruce |
| Spruce (oven-dried) |
| Stone, artificial stone |
| Stone, basalt |
| Stone, gneiss |
| Stone, granite |
| Stone, lime, or sand |
| Stone, limestone, extra hard |
| Stone, limestone, extra soft |
| Stone, limestone, hard |
| Stone, limestone, semi-hard |
| Stone, limestone, soft |
| Stone, marble |
| Stone, natural pumice |
| Stone, natural, crystalline rock |
| Stone, natural, porous |
| Stone, natural, sedimentary rock |
| Stone, natural, sedimentary rock, light |
| Stone, sandstone (silica) |
| Stone, slate |
| Straw thatch |
| Tiles, ceramic or porcelain |
| Tiles, clay |
| Tiles, concrete |
| Tiles, plastic |
| Timber, 500 kg/m^3 |
| Timber, 700 kg/m^3 |
| Vegetable fiber board, Homogeneous board from repulped paper |
| Vegetable fiber board, Laminated paperboard |
| Vegetable fiber board, Nail-base sheathing |
| Vegetable fiber board, Sheathing, intermediate density |
| Vegetable fiber board, Sheathing, regular density |
| Vegetable fiber board, Shingle backer |
| Vegetable fiber board, Sound deadening board |
| Vegetable fiber board, Tile and lay-in panels, plain or acoustic |
| Vermiculite aggregate, 480 kg/m^3 |
| Vermiculite aggregate, 600 kg/m^3 |
| Vermiculite aggregate, 720 kg/m^3 |
| Vermiculite aggregate, 840 kg/m^3 |
| Vermiculite aggregate, 960 kg/m^3 |
| Waferboard |
| Water at 10°C |
| Water at 40°C |
| Water at 80°C |
| Water, ice at -10 °C |
| Water, ice at 0 °C |
| Water, snow, compacted (<200 mm) |
| Water, snow, freshly fallen (<30 mm) |
| Water, snow, slightly compacted (70 mm to 100 mm) |
| Water, snow, soft (30 mm to 70 mm) |
| West coast woods, cedars |
| Western red cedar |
| Wood shingles, plain and plastic-film-faced |
| Wood, cement-bonded particleboard |
| Wood, fibreboard, 250 kg/m^3 |
| Wood, fibreboard, 400 kg/m^3 |
| Wood, fibreboard, 600 kg/m^3 |
| Wood, fibreboard, 800 kg/m^3 |
| Wood, oriented strand board |
| Wood, particleboard, 300 kg/m^3 |
| Wood, particleboard, 600 kg/m^3 |
| Wood, particleboard, 900 kg/m^3 |
| Wood, plywood 1000 kg/m^3 |
| Wood, plywood 300 kg/m^3 |
| Wood, plywood 500 kg/m^3 |
| Wood, plywood 700 kg/m^3 |
| Zircon |
| Zirconia |
| a/b-Alumina |
Example 2: List all materials (duplicate 1)
Inputs:
|
|| | |
Excel formula:
=LIST_MATERIALS()Expected output:
| ACr 90 |
|---|
| ACrZ 20 |
| ACrZ 60 |
| AZS 33 |
| AZS 41 |
| Asbestos/cement shingles |
| Ash |
| Asphalt |
| Asphalt (bitumen with inert fill), 1600 kg/m^3 |
| Asphalt (bitumen with inert fill), 1900 kg/m^3 |
| Asphalt (bitumen with inert fill), 2300 kg/m^3 |
| Asphalt roll roofing |
| Asphalt shingles |
| Bauxite |
| Bauxite P5 |
| Birch |
| Bitumen, felt or sheet |
| Bitumen, pure |
| Board, Asbestos/cement |
| Board, Cement |
| Board, Fiber/cement, 1000 kg/m^3 |
| Board, Fiber/cement, 1400 kg/m^3 |
| Board, Fiber/cement, 300 kg/m^3 |
| Board, Fiber/cement, 400 kg/m^3 |
| Brick, fired clay, 1120 kg/m^3 |
| Brick, fired clay, 1280 kg/m^3 |
| Brick, fired clay, 1440 kg/m^3 |
| Brick, fired clay, 1600 kg/m^3 |
| Brick, fired clay, 1760 kg/m^3 |
| Brick, fired clay, 1920 kg/m^3 |
| Brick, fired clay, 2080 kg/m^3 |
| Brick, fired clay, 2240 kg/m^3 |
| Brick, fired clay, 2400 kg/m^3 |
| Built-up roofing |
| Calcitic, dolomitic, limestone, marble, and granite, 1600 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 1920 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 2240 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 2560 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 2880 kg/m^3 |
| California redwood |
| Carbon, anthracite |
| Carbon, graphite |
| Carpet and rebounded urethane pad |
| Carpet and rubber pad, one-piece |
| Cellular glass |
| Cement fiber slabs, shredded wood, with Portland cement binder |
| Cement fiber slabs, shredded wood, with magnesia oxysulfide binder |
| Cement plaster, sand aggregate |
| Clay tile, hollow, 1 cell deep |
| Clay tile, hollow, 2 cells deep |
| Clay tile, hollow, 3 cells deep |
| Concrete blocks, Limestone aggregate, 200 mm, 16 kg, 2200 kg/m^3, 2 cores with perlite-filled cores |
| Concrete blocks, Limestone aggregate, 300 mm, 25 kg, 2200 kg/m^3, 2 cores with perlite-filled cores. |
| Concrete blocks, low-mass aggregate, 150 mm, 7.5 kg, 1400 kg/m^3, 2 or 3 cores |
| Concrete blocks, low-mass aggregate, 150 mm, 7.5 kg, 1400 kg/m^3, with perlite-filled cores |
| Concrete blocks, low-mass aggregate, 150 mm, 7.5 kg, 1400 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3 |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with UF foam-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with molded EPS inserts in cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with molded-EPS-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with perlite-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, low-mass aggregate, 300 mm, 16 kg, 1400 kg/m^3, 2 or 3 cores |
| Concrete blocks, low-mass aggregate, 300 mm, 16 kg, 1400 kg/m^3, with perlite-filled cores |
| Concrete blocks, low-mass aggregate, 300 mm, 16 kg, 1400 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, 2 or 3 cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with molded EPS inserts in cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with molded-EPS-filled cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with perlite-filled cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2000 kg/m^3, 2 cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2100 kg/m^3, 2 or 3 cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2100 kg/m^3, with perlite-filled cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2100 kg/m^3, with vermiculite-filled cores |
| Concrete, Aerated concrete (oven-dried) |
| Concrete, Cement/lime, mortar, and stucco, 1280 kg/m^3 |
| Concrete, Cement/lime, mortar, and stucco, 1600 kg/m^3 |
| Concrete, Cement/lime, mortar, and stucco, 1920 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 1280 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 1600 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 640 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 960 kg/m^3 |
| Concrete, Foam concretes and cellular concretes, 320 kg/m^3 |
| Concrete, Foam concretes and cellular concretes, 640 kg/m^3 |
| Concrete, Foam concretes and cellular concretes, 960 kg/m^3 |
| Concrete, Foam concretes, 1120 kg/m^3 |
| Concrete, Foam concretes, 1280 kg/m^3 |
| Concrete, Foam concretes, 1600 kg/m^3 |
| Concrete, Foam concretes, 1920 kg/m^3 |
| Concrete, Gypsum/fiber concrete (87.5% gypsum, 12.5% wood chips) |
| Concrete, Low-mass aggregate or limestone |
| Concrete, Perlite, vermiculite, and polystyrene beads, 320 kg/m^3 |
| Concrete, Perlite, vermiculite, and polystyrene beads, 480 kg/m^3 |
| Concrete, Perlite, vermiculite, and polystyrene beads, 640 kg/m^3 |
| Concrete, Perlite, vermiculite, and polystyrene beads, 800 kg/m^3 |
| Concrete, Polymer cement |
| Concrete, Polymer concrete, 1950 kg/m^3 |
| Concrete, Polymer concrete, 2200 kg/m^3 |
| Concrete, Polystyrene concrete (oven-dried) |
| Concrete, Sand and gravel or stone aggregate concretes, 2080 kg/m^3 |
| Concrete, Sand and gravel or stone aggregate concretes, 2240 kg/m^3 |
| Concrete, Sand and gravel or stone aggregate concretes, 2400 kg/m^3 |
| Concrete, Slag concrete, 1280 kg/m^3 |
| Concrete, Slag concrete, 1600 kg/m^3 |
| Concrete, Slag concrete, 2000 kg/m^3 |
| Concrete, Slag concrete, 960 kg/m^3 |
| Concrete, high density |
| Concrete, medium density 1800 kg/m^3 |
| Concrete, medium density 2000 kg/m^3 |
| Concrete, medium density 2200 kg/m^3 |
| Concrete, reinforced with 1% steel |
| Concrete, reinforced with 2% steel |
| Corundum 90% |
| Corundum 99% |
| Corundum P10 |
| Corundum Spinel |
| Dolomite P10 |
| Douglas fir/larch |
| Eastern white cedar |
| Eastern white pine |
| Expanded polystyrene, extruded |
| Expanded polystyrene, molded beads |
| Expanded rubber |
| Fireclay |
| Floor covering, Linoleum |
| Floor covering, carpet / textile flooring |
| Floor covering, plastic |
| Floor covering, rubber |
| Floor covering, tiles, cork |
| Floor covering, underlay, cellular or plastic |
| Floor covering, underlay, cork |
| Floor covering, underlay, felt |
| Floor covering, underlay, wool |
| Fused silica |
| Gases, air |
| Gases, argon |
| Gases, carbon dioxide |
| Gases, krypton |
| Gases, sulphur hexafluoride |
| Gases, xenon |
| Glass fiber board |
| Glass, glass mosaic |
| Glass, quartz |
| Glass, soda lime |
| Glass-fiber batts, 50 mm |
| Glass-fiber batts, 90 mm |
| Gypsum or plaster board |
| Gypsum partition tile, 100 by 300 by 760 mm, 3 cells |
| Gypsum partition tile, 75 by 300 by 760 mm, solid, 3 cells |
| Gypsum partition tile, 75 by 300 by 760 mm, with 4 cells |
| Gypsum plaster, 1120 kg/m^3 |
| Gypsum plaster, 1280 kg/m^3 |
| Gypsum, 1200 kg/m^3 |
| Gypsum, 1500 kg/m^3 |
| Gypsum, 600 kg/m^3 |
| Gypsum, 900 kg/m^3 |
| Gypsum, plasterboard |
| Hardboard, high density, service-tempered grade and service grade |
| Hardboard, high density, standard-tempered grade |
| Hardboard, medium density |
| Hem/fir, spruce/pine/fir |
| High-duty fireclay |
| L1260 |
| L1400 |
| L1540 |
| L1760 |
| L1870 |
| Lightweight aggregate |
| Lightweight brick, 770 kg/m^3 |
| Lightweight brick, 800 kg/m^3 |
| Limestone, 2400 kg/m^3 |
| Limestone, 2600 kg/m^3 |
| Linoleum/cork tile |
| Loose fill, Cellulosic |
| Loose fill, Mineral fiber, 170 to 220 mm |
| Loose fill, Mineral fiber, 190 to 250 mm |
| Loose fill, Mineral fiber, 260 to 350 mm |
| Loose fill, Mineral fiber, 90 mm |
| Loose fill, Mineral fiber, 95 to 130 mm |
| Loose fill, Perlite, expanded, 100 kg/m^3 |
| Loose fill, Perlite, expanded, 150 kg/m^3 |
| Loose fill, Perlite, expanded, 50 kg/m^3 |
| Loose fill, Vermiculite, exfoliated, 120 kg/m^3 |
| Loose fill, Vermiculite, exfoliated, 80 kg/m^3 |
| Magnesia |
| Magnesite Chrome |
| Magnesite Graphite H15 |
| Magnesite P5 |
| Magnesite Spinel |
| Maple |
| Mastic asphalt (heavy, 20% grit) |
| Metals, aluminium alloys |
| Metals, brass |
| Metals, bronze |
| Metals, copper |
| Metals, iron, cast |
| Metals, lead |
| Metals, stainless steel |
| Metals, steel |
| Metals, zinc |
| Mineral fiber |
| Mineral fiberboard, wet felted |
| Mineral fiberboard, wet felted, acoustical tile, 290 kg/m^3 |
| Mineral fiberboard, wet felted, acoustical tile, 335 kg/m^3 |
| Mineral fiberboard, wet felted, core or roof insulation |
| Mineral fiberboard, wet-molded, acoustical tile |
| Mineral wool, felted, 100 kg/m^3 |
| Mineral wool, felted, 32 kg/m^3 |
| Mullite |
| Oak |
| Oriented strand board (OSB) |
| PVC/Rubber floor covering, Rubber tile |
| PVC/Rubber floor covering, Terrazzo |
| Particleboard, high density |
| Particleboard, low density |
| Particleboard, medium density |
| Particleboard, underlayment |
| Perlite aggregate |
| Perlite board |
| Perlite plaster, 400 kg/m^3 |
| Perlite plaster, 600 kg/m^3 |
| Phenolic foam board with facers, aged |
| Pile carpet with rubber pad |
| Pine (oven-dried) |
| Plasters and renders, cement sand |
| Plasters and renders, gypsum insulating plaster |
| Plasters and renders, gypsum plastering, 1000 kg/m^3 |
| Plasters and renders, gypsum plastering, 1300 kg/m^3 |
| Plasters and renders, gypsum sand |
| Plasters and renders, lime sand |
| Plastics, Polyvinylchloride (PVC) |
| Plastics, acrylic |
| Plastics, epoxy resin |
| Plastics, phenolic resin |
| Plastics, polyacetate |
| Plastics, polyamide (nylon) |
| Plastics, polyamide 6.6 with 25% glass fibre |
| Plastics, polycarbonates |
| Plastics, polyester resin |
| Plastics, polyethylene / polythene, high density |
| Plastics, polyethylene / polythene, low density |
| Plastics, polymethylmethacrylate (PMMA) |
| Plastics, polypropylene |
| Plastics, polypropylene with 25% glass fibre |
| Plastics, polystyrene |
| Plastics, polytetrafluoroethylene (PTFE) |
| Plastics, polyurethane (PU) |
| Plywood (douglas fir) |
| Plywood/wood panels |
| Polyisocyanurate, aged, unfaced |
| Polyisocyanurate, aged, with facers |
| Pulpboard or paper plaster |
| Quartzitic and sandstone, 1920 kg/m^3 |
| Quartzitic and sandstone, 2240 kg/m^3 |
| Quartzitic and sandstone, 2560 kg/m^3 |
| Reed thatch |
| Roofing felt |
| Rubber, butadiene |
| Rubber, butyl (isobutene), solid melt |
| Rubber, ethylene propylene diene monomer (EPDM) |
| Rubber, foam rubber |
| Rubber, hard rubber (ebonite), solid |
| Rubber, natural |
| Rubber, neoprene (polychloroprene) |
| Rubber, polyisobutylene |
| Rubber, polysulfide |
| SIC 40% |
| SIC 70% |
| SIC 90% |
| Sand aggregate |
| Sand/cement plaster, conditioned |
| Sand/cement/lime plaster, conditioned |
| Sand/gypsum (3:1) plaster, conditioned |
| Sealant, elastomeric foam, flexible |
| Sealant, polyethylene foam |
| Sealant, polyurethane (PU) foam |
| Sealant, polyvinylchloride (PVC) flexible, with 40% softner |
| Sealant, silica gel (dessicant) |
| Sealant, silicone foam |
| Sealant, silicone, filled |
| Sealant, silicone, pure |
| Sealant, urethane / polyurethane (thermal break) |
| Shingles, Asbestos/cement |
| Shingles, Siding, Asbestos/cement, lapped |
| Shingles, Siding, Asphalt roll siding |
| Shingles, Wood, 400 mm, 190 mm exposure |
| Shingles, Wood, double, 400 mm, 300 mm exposure |
| Shingles, Wood, plus ins. backer board |
| Siding, Aluminum, steel, or vinyl, over sheathing foil-backed |
| Siding, Aluminum, steel, or vinyl, over sheathing, hollow-backed |
| Siding, Aluminum, steel, or vinyl, over sheathing, insulating-board-backed |
| Siding, Architectural (soda-lime float) glass |
| Siding, Asphalt insulating siding |
| Siding, Hardboard siding |
| Siding, Wood, bevel, 200 mm, lapped |
| Siding, Wood, bevel, 250 mm, lapped |
| Siding, Wood, drop, 200 mm |
| Siding, Wood, plywood, lapped |
| Silica |
| Silica special |
| Sillimanite |
| Sillimanite P5 |
| Slag wool, 120 kg/m^3 |
| Slag wool, 255 kg/m^3 |
| Slag wool, 305 kg/m^3 |
| Slag wool, 350 kg/m^3 |
| Slag wool, 400 kg/m^3 |
| Slate |
| Solids, clay or silt |
| Solids, sand and gravel |
| Southern cypress |
| Southern pine |
| Southern yellow pine |
| Spray-applied Cellulosic fiber |
| Spray-applied Glass fiber |
| Spray-applied Polyurethane foam, 40 kg/m^3 |
| Spray-applied Polyurethane foam, 7 kg/m^3 |
| Spray-applied Polyurethane foam, aged and dry, 120 mm |
| Spray-applied Polyurethane foam, aged and dry, 40 mm |
| Spray-applied Polyurethane foam, aged and dry, 50 mm |
| Spray-applied Ureaformaldehyde foam, dry |
| Spruce |
| Spruce (oven-dried) |
| Stone, artificial stone |
| Stone, basalt |
| Stone, gneiss |
| Stone, granite |
| Stone, lime, or sand |
| Stone, limestone, extra hard |
| Stone, limestone, extra soft |
| Stone, limestone, hard |
| Stone, limestone, semi-hard |
| Stone, limestone, soft |
| Stone, marble |
| Stone, natural pumice |
| Stone, natural, crystalline rock |
| Stone, natural, porous |
| Stone, natural, sedimentary rock |
| Stone, natural, sedimentary rock, light |
| Stone, sandstone (silica) |
| Stone, slate |
| Straw thatch |
| Tiles, ceramic or porcelain |
| Tiles, clay |
| Tiles, concrete |
| Tiles, plastic |
| Timber, 500 kg/m^3 |
| Timber, 700 kg/m^3 |
| Vegetable fiber board, Homogeneous board from repulped paper |
| Vegetable fiber board, Laminated paperboard |
| Vegetable fiber board, Nail-base sheathing |
| Vegetable fiber board, Sheathing, intermediate density |
| Vegetable fiber board, Sheathing, regular density |
| Vegetable fiber board, Shingle backer |
| Vegetable fiber board, Sound deadening board |
| Vegetable fiber board, Tile and lay-in panels, plain or acoustic |
| Vermiculite aggregate, 480 kg/m^3 |
| Vermiculite aggregate, 600 kg/m^3 |
| Vermiculite aggregate, 720 kg/m^3 |
| Vermiculite aggregate, 840 kg/m^3 |
| Vermiculite aggregate, 960 kg/m^3 |
| Waferboard |
| Water at 10°C |
| Water at 40°C |
| Water at 80°C |
| Water, ice at -10 °C |
| Water, ice at 0 °C |
| Water, snow, compacted (<200 mm) |
| Water, snow, freshly fallen (<30 mm) |
| Water, snow, slightly compacted (70 mm to 100 mm) |
| Water, snow, soft (30 mm to 70 mm) |
| West coast woods, cedars |
| Western red cedar |
| Wood shingles, plain and plastic-film-faced |
| Wood, cement-bonded particleboard |
| Wood, fibreboard, 250 kg/m^3 |
| Wood, fibreboard, 400 kg/m^3 |
| Wood, fibreboard, 600 kg/m^3 |
| Wood, fibreboard, 800 kg/m^3 |
| Wood, oriented strand board |
| Wood, particleboard, 300 kg/m^3 |
| Wood, particleboard, 600 kg/m^3 |
| Wood, particleboard, 900 kg/m^3 |
| Wood, plywood 1000 kg/m^3 |
| Wood, plywood 300 kg/m^3 |
| Wood, plywood 500 kg/m^3 |
| Wood, plywood 700 kg/m^3 |
| Zircon |
| Zirconia |
| a/b-Alumina |
Example 3: List all materials (duplicate 2)
Inputs:
|
|| | |
Excel formula:
=LIST_MATERIALS()Expected output:
| ACr 90 |
|---|
| ACrZ 20 |
| ACrZ 60 |
| AZS 33 |
| AZS 41 |
| Asbestos/cement shingles |
| Ash |
| Asphalt |
| Asphalt (bitumen with inert fill), 1600 kg/m^3 |
| Asphalt (bitumen with inert fill), 1900 kg/m^3 |
| Asphalt (bitumen with inert fill), 2300 kg/m^3 |
| Asphalt roll roofing |
| Asphalt shingles |
| Bauxite |
| Bauxite P5 |
| Birch |
| Bitumen, felt or sheet |
| Bitumen, pure |
| Board, Asbestos/cement |
| Board, Cement |
| Board, Fiber/cement, 1000 kg/m^3 |
| Board, Fiber/cement, 1400 kg/m^3 |
| Board, Fiber/cement, 300 kg/m^3 |
| Board, Fiber/cement, 400 kg/m^3 |
| Brick, fired clay, 1120 kg/m^3 |
| Brick, fired clay, 1280 kg/m^3 |
| Brick, fired clay, 1440 kg/m^3 |
| Brick, fired clay, 1600 kg/m^3 |
| Brick, fired clay, 1760 kg/m^3 |
| Brick, fired clay, 1920 kg/m^3 |
| Brick, fired clay, 2080 kg/m^3 |
| Brick, fired clay, 2240 kg/m^3 |
| Brick, fired clay, 2400 kg/m^3 |
| Built-up roofing |
| Calcitic, dolomitic, limestone, marble, and granite, 1600 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 1920 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 2240 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 2560 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 2880 kg/m^3 |
| California redwood |
| Carbon, anthracite |
| Carbon, graphite |
| Carpet and rebounded urethane pad |
| Carpet and rubber pad, one-piece |
| Cellular glass |
| Cement fiber slabs, shredded wood, with Portland cement binder |
| Cement fiber slabs, shredded wood, with magnesia oxysulfide binder |
| Cement plaster, sand aggregate |
| Clay tile, hollow, 1 cell deep |
| Clay tile, hollow, 2 cells deep |
| Clay tile, hollow, 3 cells deep |
| Concrete blocks, Limestone aggregate, 200 mm, 16 kg, 2200 kg/m^3, 2 cores with perlite-filled cores |
| Concrete blocks, Limestone aggregate, 300 mm, 25 kg, 2200 kg/m^3, 2 cores with perlite-filled cores. |
| Concrete blocks, low-mass aggregate, 150 mm, 7.5 kg, 1400 kg/m^3, 2 or 3 cores |
| Concrete blocks, low-mass aggregate, 150 mm, 7.5 kg, 1400 kg/m^3, with perlite-filled cores |
| Concrete blocks, low-mass aggregate, 150 mm, 7.5 kg, 1400 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3 |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with UF foam-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with molded EPS inserts in cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with molded-EPS-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with perlite-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, low-mass aggregate, 300 mm, 16 kg, 1400 kg/m^3, 2 or 3 cores |
| Concrete blocks, low-mass aggregate, 300 mm, 16 kg, 1400 kg/m^3, with perlite-filled cores |
| Concrete blocks, low-mass aggregate, 300 mm, 16 kg, 1400 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, 2 or 3 cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with molded EPS inserts in cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with molded-EPS-filled cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with perlite-filled cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2000 kg/m^3, 2 cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2100 kg/m^3, 2 or 3 cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2100 kg/m^3, with perlite-filled cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2100 kg/m^3, with vermiculite-filled cores |
| Concrete, Aerated concrete (oven-dried) |
| Concrete, Cement/lime, mortar, and stucco, 1280 kg/m^3 |
| Concrete, Cement/lime, mortar, and stucco, 1600 kg/m^3 |
| Concrete, Cement/lime, mortar, and stucco, 1920 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 1280 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 1600 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 640 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 960 kg/m^3 |
| Concrete, Foam concretes and cellular concretes, 320 kg/m^3 |
| Concrete, Foam concretes and cellular concretes, 640 kg/m^3 |
| Concrete, Foam concretes and cellular concretes, 960 kg/m^3 |
| Concrete, Foam concretes, 1120 kg/m^3 |
| Concrete, Foam concretes, 1280 kg/m^3 |
| Concrete, Foam concretes, 1600 kg/m^3 |
| Concrete, Foam concretes, 1920 kg/m^3 |
| Concrete, Gypsum/fiber concrete (87.5% gypsum, 12.5% wood chips) |
| Concrete, Low-mass aggregate or limestone |
| Concrete, Perlite, vermiculite, and polystyrene beads, 320 kg/m^3 |
| Concrete, Perlite, vermiculite, and polystyrene beads, 480 kg/m^3 |
| Concrete, Perlite, vermiculite, and polystyrene beads, 640 kg/m^3 |
| Concrete, Perlite, vermiculite, and polystyrene beads, 800 kg/m^3 |
| Concrete, Polymer cement |
| Concrete, Polymer concrete, 1950 kg/m^3 |
| Concrete, Polymer concrete, 2200 kg/m^3 |
| Concrete, Polystyrene concrete (oven-dried) |
| Concrete, Sand and gravel or stone aggregate concretes, 2080 kg/m^3 |
| Concrete, Sand and gravel or stone aggregate concretes, 2240 kg/m^3 |
| Concrete, Sand and gravel or stone aggregate concretes, 2400 kg/m^3 |
| Concrete, Slag concrete, 1280 kg/m^3 |
| Concrete, Slag concrete, 1600 kg/m^3 |
| Concrete, Slag concrete, 2000 kg/m^3 |
| Concrete, Slag concrete, 960 kg/m^3 |
| Concrete, high density |
| Concrete, medium density 1800 kg/m^3 |
| Concrete, medium density 2000 kg/m^3 |
| Concrete, medium density 2200 kg/m^3 |
| Concrete, reinforced with 1% steel |
| Concrete, reinforced with 2% steel |
| Corundum 90% |
| Corundum 99% |
| Corundum P10 |
| Corundum Spinel |
| Dolomite P10 |
| Douglas fir/larch |
| Eastern white cedar |
| Eastern white pine |
| Expanded polystyrene, extruded |
| Expanded polystyrene, molded beads |
| Expanded rubber |
| Fireclay |
| Floor covering, Linoleum |
| Floor covering, carpet / textile flooring |
| Floor covering, plastic |
| Floor covering, rubber |
| Floor covering, tiles, cork |
| Floor covering, underlay, cellular or plastic |
| Floor covering, underlay, cork |
| Floor covering, underlay, felt |
| Floor covering, underlay, wool |
| Fused silica |
| Gases, air |
| Gases, argon |
| Gases, carbon dioxide |
| Gases, krypton |
| Gases, sulphur hexafluoride |
| Gases, xenon |
| Glass fiber board |
| Glass, glass mosaic |
| Glass, quartz |
| Glass, soda lime |
| Glass-fiber batts, 50 mm |
| Glass-fiber batts, 90 mm |
| Gypsum or plaster board |
| Gypsum partition tile, 100 by 300 by 760 mm, 3 cells |
| Gypsum partition tile, 75 by 300 by 760 mm, solid, 3 cells |
| Gypsum partition tile, 75 by 300 by 760 mm, with 4 cells |
| Gypsum plaster, 1120 kg/m^3 |
| Gypsum plaster, 1280 kg/m^3 |
| Gypsum, 1200 kg/m^3 |
| Gypsum, 1500 kg/m^3 |
| Gypsum, 600 kg/m^3 |
| Gypsum, 900 kg/m^3 |
| Gypsum, plasterboard |
| Hardboard, high density, service-tempered grade and service grade |
| Hardboard, high density, standard-tempered grade |
| Hardboard, medium density |
| Hem/fir, spruce/pine/fir |
| High-duty fireclay |
| L1260 |
| L1400 |
| L1540 |
| L1760 |
| L1870 |
| Lightweight aggregate |
| Lightweight brick, 770 kg/m^3 |
| Lightweight brick, 800 kg/m^3 |
| Limestone, 2400 kg/m^3 |
| Limestone, 2600 kg/m^3 |
| Linoleum/cork tile |
| Loose fill, Cellulosic |
| Loose fill, Mineral fiber, 170 to 220 mm |
| Loose fill, Mineral fiber, 190 to 250 mm |
| Loose fill, Mineral fiber, 260 to 350 mm |
| Loose fill, Mineral fiber, 90 mm |
| Loose fill, Mineral fiber, 95 to 130 mm |
| Loose fill, Perlite, expanded, 100 kg/m^3 |
| Loose fill, Perlite, expanded, 150 kg/m^3 |
| Loose fill, Perlite, expanded, 50 kg/m^3 |
| Loose fill, Vermiculite, exfoliated, 120 kg/m^3 |
| Loose fill, Vermiculite, exfoliated, 80 kg/m^3 |
| Magnesia |
| Magnesite Chrome |
| Magnesite Graphite H15 |
| Magnesite P5 |
| Magnesite Spinel |
| Maple |
| Mastic asphalt (heavy, 20% grit) |
| Metals, aluminium alloys |
| Metals, brass |
| Metals, bronze |
| Metals, copper |
| Metals, iron, cast |
| Metals, lead |
| Metals, stainless steel |
| Metals, steel |
| Metals, zinc |
| Mineral fiber |
| Mineral fiberboard, wet felted |
| Mineral fiberboard, wet felted, acoustical tile, 290 kg/m^3 |
| Mineral fiberboard, wet felted, acoustical tile, 335 kg/m^3 |
| Mineral fiberboard, wet felted, core or roof insulation |
| Mineral fiberboard, wet-molded, acoustical tile |
| Mineral wool, felted, 100 kg/m^3 |
| Mineral wool, felted, 32 kg/m^3 |
| Mullite |
| Oak |
| Oriented strand board (OSB) |
| PVC/Rubber floor covering, Rubber tile |
| PVC/Rubber floor covering, Terrazzo |
| Particleboard, high density |
| Particleboard, low density |
| Particleboard, medium density |
| Particleboard, underlayment |
| Perlite aggregate |
| Perlite board |
| Perlite plaster, 400 kg/m^3 |
| Perlite plaster, 600 kg/m^3 |
| Phenolic foam board with facers, aged |
| Pile carpet with rubber pad |
| Pine (oven-dried) |
| Plasters and renders, cement sand |
| Plasters and renders, gypsum insulating plaster |
| Plasters and renders, gypsum plastering, 1000 kg/m^3 |
| Plasters and renders, gypsum plastering, 1300 kg/m^3 |
| Plasters and renders, gypsum sand |
| Plasters and renders, lime sand |
| Plastics, Polyvinylchloride (PVC) |
| Plastics, acrylic |
| Plastics, epoxy resin |
| Plastics, phenolic resin |
| Plastics, polyacetate |
| Plastics, polyamide (nylon) |
| Plastics, polyamide 6.6 with 25% glass fibre |
| Plastics, polycarbonates |
| Plastics, polyester resin |
| Plastics, polyethylene / polythene, high density |
| Plastics, polyethylene / polythene, low density |
| Plastics, polymethylmethacrylate (PMMA) |
| Plastics, polypropylene |
| Plastics, polypropylene with 25% glass fibre |
| Plastics, polystyrene |
| Plastics, polytetrafluoroethylene (PTFE) |
| Plastics, polyurethane (PU) |
| Plywood (douglas fir) |
| Plywood/wood panels |
| Polyisocyanurate, aged, unfaced |
| Polyisocyanurate, aged, with facers |
| Pulpboard or paper plaster |
| Quartzitic and sandstone, 1920 kg/m^3 |
| Quartzitic and sandstone, 2240 kg/m^3 |
| Quartzitic and sandstone, 2560 kg/m^3 |
| Reed thatch |
| Roofing felt |
| Rubber, butadiene |
| Rubber, butyl (isobutene), solid melt |
| Rubber, ethylene propylene diene monomer (EPDM) |
| Rubber, foam rubber |
| Rubber, hard rubber (ebonite), solid |
| Rubber, natural |
| Rubber, neoprene (polychloroprene) |
| Rubber, polyisobutylene |
| Rubber, polysulfide |
| SIC 40% |
| SIC 70% |
| SIC 90% |
| Sand aggregate |
| Sand/cement plaster, conditioned |
| Sand/cement/lime plaster, conditioned |
| Sand/gypsum (3:1) plaster, conditioned |
| Sealant, elastomeric foam, flexible |
| Sealant, polyethylene foam |
| Sealant, polyurethane (PU) foam |
| Sealant, polyvinylchloride (PVC) flexible, with 40% softner |
| Sealant, silica gel (dessicant) |
| Sealant, silicone foam |
| Sealant, silicone, filled |
| Sealant, silicone, pure |
| Sealant, urethane / polyurethane (thermal break) |
| Shingles, Asbestos/cement |
| Shingles, Siding, Asbestos/cement, lapped |
| Shingles, Siding, Asphalt roll siding |
| Shingles, Wood, 400 mm, 190 mm exposure |
| Shingles, Wood, double, 400 mm, 300 mm exposure |
| Shingles, Wood, plus ins. backer board |
| Siding, Aluminum, steel, or vinyl, over sheathing foil-backed |
| Siding, Aluminum, steel, or vinyl, over sheathing, hollow-backed |
| Siding, Aluminum, steel, or vinyl, over sheathing, insulating-board-backed |
| Siding, Architectural (soda-lime float) glass |
| Siding, Asphalt insulating siding |
| Siding, Hardboard siding |
| Siding, Wood, bevel, 200 mm, lapped |
| Siding, Wood, bevel, 250 mm, lapped |
| Siding, Wood, drop, 200 mm |
| Siding, Wood, plywood, lapped |
| Silica |
| Silica special |
| Sillimanite |
| Sillimanite P5 |
| Slag wool, 120 kg/m^3 |
| Slag wool, 255 kg/m^3 |
| Slag wool, 305 kg/m^3 |
| Slag wool, 350 kg/m^3 |
| Slag wool, 400 kg/m^3 |
| Slate |
| Solids, clay or silt |
| Solids, sand and gravel |
| Southern cypress |
| Southern pine |
| Southern yellow pine |
| Spray-applied Cellulosic fiber |
| Spray-applied Glass fiber |
| Spray-applied Polyurethane foam, 40 kg/m^3 |
| Spray-applied Polyurethane foam, 7 kg/m^3 |
| Spray-applied Polyurethane foam, aged and dry, 120 mm |
| Spray-applied Polyurethane foam, aged and dry, 40 mm |
| Spray-applied Polyurethane foam, aged and dry, 50 mm |
| Spray-applied Ureaformaldehyde foam, dry |
| Spruce |
| Spruce (oven-dried) |
| Stone, artificial stone |
| Stone, basalt |
| Stone, gneiss |
| Stone, granite |
| Stone, lime, or sand |
| Stone, limestone, extra hard |
| Stone, limestone, extra soft |
| Stone, limestone, hard |
| Stone, limestone, semi-hard |
| Stone, limestone, soft |
| Stone, marble |
| Stone, natural pumice |
| Stone, natural, crystalline rock |
| Stone, natural, porous |
| Stone, natural, sedimentary rock |
| Stone, natural, sedimentary rock, light |
| Stone, sandstone (silica) |
| Stone, slate |
| Straw thatch |
| Tiles, ceramic or porcelain |
| Tiles, clay |
| Tiles, concrete |
| Tiles, plastic |
| Timber, 500 kg/m^3 |
| Timber, 700 kg/m^3 |
| Vegetable fiber board, Homogeneous board from repulped paper |
| Vegetable fiber board, Laminated paperboard |
| Vegetable fiber board, Nail-base sheathing |
| Vegetable fiber board, Sheathing, intermediate density |
| Vegetable fiber board, Sheathing, regular density |
| Vegetable fiber board, Shingle backer |
| Vegetable fiber board, Sound deadening board |
| Vegetable fiber board, Tile and lay-in panels, plain or acoustic |
| Vermiculite aggregate, 480 kg/m^3 |
| Vermiculite aggregate, 600 kg/m^3 |
| Vermiculite aggregate, 720 kg/m^3 |
| Vermiculite aggregate, 840 kg/m^3 |
| Vermiculite aggregate, 960 kg/m^3 |
| Waferboard |
| Water at 10°C |
| Water at 40°C |
| Water at 80°C |
| Water, ice at -10 °C |
| Water, ice at 0 °C |
| Water, snow, compacted (<200 mm) |
| Water, snow, freshly fallen (<30 mm) |
| Water, snow, slightly compacted (70 mm to 100 mm) |
| Water, snow, soft (30 mm to 70 mm) |
| West coast woods, cedars |
| Western red cedar |
| Wood shingles, plain and plastic-film-faced |
| Wood, cement-bonded particleboard |
| Wood, fibreboard, 250 kg/m^3 |
| Wood, fibreboard, 400 kg/m^3 |
| Wood, fibreboard, 600 kg/m^3 |
| Wood, fibreboard, 800 kg/m^3 |
| Wood, oriented strand board |
| Wood, particleboard, 300 kg/m^3 |
| Wood, particleboard, 600 kg/m^3 |
| Wood, particleboard, 900 kg/m^3 |
| Wood, plywood 1000 kg/m^3 |
| Wood, plywood 300 kg/m^3 |
| Wood, plywood 500 kg/m^3 |
| Wood, plywood 700 kg/m^3 |
| Zircon |
| Zirconia |
| a/b-Alumina |
Example 4: List all materials (duplicate 3)
Inputs:
|
|| | |
Excel formula:
=LIST_MATERIALS()Expected output:
| ACr 90 |
|---|
| ACrZ 20 |
| ACrZ 60 |
| AZS 33 |
| AZS 41 |
| Asbestos/cement shingles |
| Ash |
| Asphalt |
| Asphalt (bitumen with inert fill), 1600 kg/m^3 |
| Asphalt (bitumen with inert fill), 1900 kg/m^3 |
| Asphalt (bitumen with inert fill), 2300 kg/m^3 |
| Asphalt roll roofing |
| Asphalt shingles |
| Bauxite |
| Bauxite P5 |
| Birch |
| Bitumen, felt or sheet |
| Bitumen, pure |
| Board, Asbestos/cement |
| Board, Cement |
| Board, Fiber/cement, 1000 kg/m^3 |
| Board, Fiber/cement, 1400 kg/m^3 |
| Board, Fiber/cement, 300 kg/m^3 |
| Board, Fiber/cement, 400 kg/m^3 |
| Brick, fired clay, 1120 kg/m^3 |
| Brick, fired clay, 1280 kg/m^3 |
| Brick, fired clay, 1440 kg/m^3 |
| Brick, fired clay, 1600 kg/m^3 |
| Brick, fired clay, 1760 kg/m^3 |
| Brick, fired clay, 1920 kg/m^3 |
| Brick, fired clay, 2080 kg/m^3 |
| Brick, fired clay, 2240 kg/m^3 |
| Brick, fired clay, 2400 kg/m^3 |
| Built-up roofing |
| Calcitic, dolomitic, limestone, marble, and granite, 1600 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 1920 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 2240 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 2560 kg/m^3 |
| Calcitic, dolomitic, limestone, marble, and granite, 2880 kg/m^3 |
| California redwood |
| Carbon, anthracite |
| Carbon, graphite |
| Carpet and rebounded urethane pad |
| Carpet and rubber pad, one-piece |
| Cellular glass |
| Cement fiber slabs, shredded wood, with Portland cement binder |
| Cement fiber slabs, shredded wood, with magnesia oxysulfide binder |
| Cement plaster, sand aggregate |
| Clay tile, hollow, 1 cell deep |
| Clay tile, hollow, 2 cells deep |
| Clay tile, hollow, 3 cells deep |
| Concrete blocks, Limestone aggregate, 200 mm, 16 kg, 2200 kg/m^3, 2 cores with perlite-filled cores |
| Concrete blocks, Limestone aggregate, 300 mm, 25 kg, 2200 kg/m^3, 2 cores with perlite-filled cores. |
| Concrete blocks, low-mass aggregate, 150 mm, 7.5 kg, 1400 kg/m^3, 2 or 3 cores |
| Concrete blocks, low-mass aggregate, 150 mm, 7.5 kg, 1400 kg/m^3, with perlite-filled cores |
| Concrete blocks, low-mass aggregate, 150 mm, 7.5 kg, 1400 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3 |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with UF foam-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with molded EPS inserts in cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with molded-EPS-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with perlite-filled cores |
| Concrete blocks, low-mass aggregate, 200 mm, 9 kg, 1250 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, low-mass aggregate, 300 mm, 16 kg, 1400 kg/m^3, 2 or 3 cores |
| Concrete blocks, low-mass aggregate, 300 mm, 16 kg, 1400 kg/m^3, with perlite-filled cores |
| Concrete blocks, low-mass aggregate, 300 mm, 16 kg, 1400 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, 2 or 3 cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with molded EPS inserts in cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with molded-EPS-filled cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with perlite-filled cores |
| Concrete blocks, medium-weight aggregate, 200 mm, 13 kg, 1650 kg/m^3, with vermiculite-filled cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2000 kg/m^3, 2 cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2100 kg/m^3, 2 or 3 cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2100 kg/m^3, with perlite-filled cores |
| Concrete blocks, normal-weight aggregate, 300 mm, 23 kg, 2100 kg/m^3, with vermiculite-filled cores |
| Concrete, Aerated concrete (oven-dried) |
| Concrete, Cement/lime, mortar, and stucco, 1280 kg/m^3 |
| Concrete, Cement/lime, mortar, and stucco, 1600 kg/m^3 |
| Concrete, Cement/lime, mortar, and stucco, 1920 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 1280 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 1600 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 640 kg/m^3 |
| Concrete, Expanded shale, clay, or slate; expanded slags; cinders; pumice; scoria; 960 kg/m^3 |
| Concrete, Foam concretes and cellular concretes, 320 kg/m^3 |
| Concrete, Foam concretes and cellular concretes, 640 kg/m^3 |
| Concrete, Foam concretes and cellular concretes, 960 kg/m^3 |
| Concrete, Foam concretes, 1120 kg/m^3 |
| Concrete, Foam concretes, 1280 kg/m^3 |
| Concrete, Foam concretes, 1600 kg/m^3 |
| Concrete, Foam concretes, 1920 kg/m^3 |
| Concrete, Gypsum/fiber concrete (87.5% gypsum, 12.5% wood chips) |
| Concrete, Low-mass aggregate or limestone |
| Concrete, Perlite, vermiculite, and polystyrene beads, 320 kg/m^3 |
| Concrete, Perlite, vermiculite, and polystyrene beads, 480 kg/m^3 |
| Concrete, Perlite, vermiculite, and polystyrene beads, 640 kg/m^3 |
| Concrete, Perlite, vermiculite, and polystyrene beads, 800 kg/m^3 |
| Concrete, Polymer cement |
| Concrete, Polymer concrete, 1950 kg/m^3 |
| Concrete, Polymer concrete, 2200 kg/m^3 |
| Concrete, Polystyrene concrete (oven-dried) |
| Concrete, Sand and gravel or stone aggregate concretes, 2080 kg/m^3 |
| Concrete, Sand and gravel or stone aggregate concretes, 2240 kg/m^3 |
| Concrete, Sand and gravel or stone aggregate concretes, 2400 kg/m^3 |
| Concrete, Slag concrete, 1280 kg/m^3 |
| Concrete, Slag concrete, 1600 kg/m^3 |
| Concrete, Slag concrete, 2000 kg/m^3 |
| Concrete, Slag concrete, 960 kg/m^3 |
| Concrete, high density |
| Concrete, medium density 1800 kg/m^3 |
| Concrete, medium density 2000 kg/m^3 |
| Concrete, medium density 2200 kg/m^3 |
| Concrete, reinforced with 1% steel |
| Concrete, reinforced with 2% steel |
| Corundum 90% |
| Corundum 99% |
| Corundum P10 |
| Corundum Spinel |
| Dolomite P10 |
| Douglas fir/larch |
| Eastern white cedar |
| Eastern white pine |
| Expanded polystyrene, extruded |
| Expanded polystyrene, molded beads |
| Expanded rubber |
| Fireclay |
| Floor covering, Linoleum |
| Floor covering, carpet / textile flooring |
| Floor covering, plastic |
| Floor covering, rubber |
| Floor covering, tiles, cork |
| Floor covering, underlay, cellular or plastic |
| Floor covering, underlay, cork |
| Floor covering, underlay, felt |
| Floor covering, underlay, wool |
| Fused silica |
| Gases, air |
| Gases, argon |
| Gases, carbon dioxide |
| Gases, krypton |
| Gases, sulphur hexafluoride |
| Gases, xenon |
| Glass fiber board |
| Glass, glass mosaic |
| Glass, quartz |
| Glass, soda lime |
| Glass-fiber batts, 50 mm |
| Glass-fiber batts, 90 mm |
| Gypsum or plaster board |
| Gypsum partition tile, 100 by 300 by 760 mm, 3 cells |
| Gypsum partition tile, 75 by 300 by 760 mm, solid, 3 cells |
| Gypsum partition tile, 75 by 300 by 760 mm, with 4 cells |
| Gypsum plaster, 1120 kg/m^3 |
| Gypsum plaster, 1280 kg/m^3 |
| Gypsum, 1200 kg/m^3 |
| Gypsum, 1500 kg/m^3 |
| Gypsum, 600 kg/m^3 |
| Gypsum, 900 kg/m^3 |
| Gypsum, plasterboard |
| Hardboard, high density, service-tempered grade and service grade |
| Hardboard, high density, standard-tempered grade |
| Hardboard, medium density |
| Hem/fir, spruce/pine/fir |
| High-duty fireclay |
| L1260 |
| L1400 |
| L1540 |
| L1760 |
| L1870 |
| Lightweight aggregate |
| Lightweight brick, 770 kg/m^3 |
| Lightweight brick, 800 kg/m^3 |
| Limestone, 2400 kg/m^3 |
| Limestone, 2600 kg/m^3 |
| Linoleum/cork tile |
| Loose fill, Cellulosic |
| Loose fill, Mineral fiber, 170 to 220 mm |
| Loose fill, Mineral fiber, 190 to 250 mm |
| Loose fill, Mineral fiber, 260 to 350 mm |
| Loose fill, Mineral fiber, 90 mm |
| Loose fill, Mineral fiber, 95 to 130 mm |
| Loose fill, Perlite, expanded, 100 kg/m^3 |
| Loose fill, Perlite, expanded, 150 kg/m^3 |
| Loose fill, Perlite, expanded, 50 kg/m^3 |
| Loose fill, Vermiculite, exfoliated, 120 kg/m^3 |
| Loose fill, Vermiculite, exfoliated, 80 kg/m^3 |
| Magnesia |
| Magnesite Chrome |
| Magnesite Graphite H15 |
| Magnesite P5 |
| Magnesite Spinel |
| Maple |
| Mastic asphalt (heavy, 20% grit) |
| Metals, aluminium alloys |
| Metals, brass |
| Metals, bronze |
| Metals, copper |
| Metals, iron, cast |
| Metals, lead |
| Metals, stainless steel |
| Metals, steel |
| Metals, zinc |
| Mineral fiber |
| Mineral fiberboard, wet felted |
| Mineral fiberboard, wet felted, acoustical tile, 290 kg/m^3 |
| Mineral fiberboard, wet felted, acoustical tile, 335 kg/m^3 |
| Mineral fiberboard, wet felted, core or roof insulation |
| Mineral fiberboard, wet-molded, acoustical tile |
| Mineral wool, felted, 100 kg/m^3 |
| Mineral wool, felted, 32 kg/m^3 |
| Mullite |
| Oak |
| Oriented strand board (OSB) |
| PVC/Rubber floor covering, Rubber tile |
| PVC/Rubber floor covering, Terrazzo |
| Particleboard, high density |
| Particleboard, low density |
| Particleboard, medium density |
| Particleboard, underlayment |
| Perlite aggregate |
| Perlite board |
| Perlite plaster, 400 kg/m^3 |
| Perlite plaster, 600 kg/m^3 |
| Phenolic foam board with facers, aged |
| Pile carpet with rubber pad |
| Pine (oven-dried) |
| Plasters and renders, cement sand |
| Plasters and renders, gypsum insulating plaster |
| Plasters and renders, gypsum plastering, 1000 kg/m^3 |
| Plasters and renders, gypsum plastering, 1300 kg/m^3 |
| Plasters and renders, gypsum sand |
| Plasters and renders, lime sand |
| Plastics, Polyvinylchloride (PVC) |
| Plastics, acrylic |
| Plastics, epoxy resin |
| Plastics, phenolic resin |
| Plastics, polyacetate |
| Plastics, polyamide (nylon) |
| Plastics, polyamide 6.6 with 25% glass fibre |
| Plastics, polycarbonates |
| Plastics, polyester resin |
| Plastics, polyethylene / polythene, high density |
| Plastics, polyethylene / polythene, low density |
| Plastics, polymethylmethacrylate (PMMA) |
| Plastics, polypropylene |
| Plastics, polypropylene with 25% glass fibre |
| Plastics, polystyrene |
| Plastics, polytetrafluoroethylene (PTFE) |
| Plastics, polyurethane (PU) |
| Plywood (douglas fir) |
| Plywood/wood panels |
| Polyisocyanurate, aged, unfaced |
| Polyisocyanurate, aged, with facers |
| Pulpboard or paper plaster |
| Quartzitic and sandstone, 1920 kg/m^3 |
| Quartzitic and sandstone, 2240 kg/m^3 |
| Quartzitic and sandstone, 2560 kg/m^3 |
| Reed thatch |
| Roofing felt |
| Rubber, butadiene |
| Rubber, butyl (isobutene), solid melt |
| Rubber, ethylene propylene diene monomer (EPDM) |
| Rubber, foam rubber |
| Rubber, hard rubber (ebonite), solid |
| Rubber, natural |
| Rubber, neoprene (polychloroprene) |
| Rubber, polyisobutylene |
| Rubber, polysulfide |
| SIC 40% |
| SIC 70% |
| SIC 90% |
| Sand aggregate |
| Sand/cement plaster, conditioned |
| Sand/cement/lime plaster, conditioned |
| Sand/gypsum (3:1) plaster, conditioned |
| Sealant, elastomeric foam, flexible |
| Sealant, polyethylene foam |
| Sealant, polyurethane (PU) foam |
| Sealant, polyvinylchloride (PVC) flexible, with 40% softner |
| Sealant, silica gel (dessicant) |
| Sealant, silicone foam |
| Sealant, silicone, filled |
| Sealant, silicone, pure |
| Sealant, urethane / polyurethane (thermal break) |
| Shingles, Asbestos/cement |
| Shingles, Siding, Asbestos/cement, lapped |
| Shingles, Siding, Asphalt roll siding |
| Shingles, Wood, 400 mm, 190 mm exposure |
| Shingles, Wood, double, 400 mm, 300 mm exposure |
| Shingles, Wood, plus ins. backer board |
| Siding, Aluminum, steel, or vinyl, over sheathing foil-backed |
| Siding, Aluminum, steel, or vinyl, over sheathing, hollow-backed |
| Siding, Aluminum, steel, or vinyl, over sheathing, insulating-board-backed |
| Siding, Architectural (soda-lime float) glass |
| Siding, Asphalt insulating siding |
| Siding, Hardboard siding |
| Siding, Wood, bevel, 200 mm, lapped |
| Siding, Wood, bevel, 250 mm, lapped |
| Siding, Wood, drop, 200 mm |
| Siding, Wood, plywood, lapped |
| Silica |
| Silica special |
| Sillimanite |
| Sillimanite P5 |
| Slag wool, 120 kg/m^3 |
| Slag wool, 255 kg/m^3 |
| Slag wool, 305 kg/m^3 |
| Slag wool, 350 kg/m^3 |
| Slag wool, 400 kg/m^3 |
| Slate |
| Solids, clay or silt |
| Solids, sand and gravel |
| Southern cypress |
| Southern pine |
| Southern yellow pine |
| Spray-applied Cellulosic fiber |
| Spray-applied Glass fiber |
| Spray-applied Polyurethane foam, 40 kg/m^3 |
| Spray-applied Polyurethane foam, 7 kg/m^3 |
| Spray-applied Polyurethane foam, aged and dry, 120 mm |
| Spray-applied Polyurethane foam, aged and dry, 40 mm |
| Spray-applied Polyurethane foam, aged and dry, 50 mm |
| Spray-applied Ureaformaldehyde foam, dry |
| Spruce |
| Spruce (oven-dried) |
| Stone, artificial stone |
| Stone, basalt |
| Stone, gneiss |
| Stone, granite |
| Stone, lime, or sand |
| Stone, limestone, extra hard |
| Stone, limestone, extra soft |
| Stone, limestone, hard |
| Stone, limestone, semi-hard |
| Stone, limestone, soft |
| Stone, marble |
| Stone, natural pumice |
| Stone, natural, crystalline rock |
| Stone, natural, porous |
| Stone, natural, sedimentary rock |
| Stone, natural, sedimentary rock, light |
| Stone, sandstone (silica) |
| Stone, slate |
| Straw thatch |
| Tiles, ceramic or porcelain |
| Tiles, clay |
| Tiles, concrete |
| Tiles, plastic |
| Timber, 500 kg/m^3 |
| Timber, 700 kg/m^3 |
| Vegetable fiber board, Homogeneous board from repulped paper |
| Vegetable fiber board, Laminated paperboard |
| Vegetable fiber board, Nail-base sheathing |
| Vegetable fiber board, Sheathing, intermediate density |
| Vegetable fiber board, Sheathing, regular density |
| Vegetable fiber board, Shingle backer |
| Vegetable fiber board, Sound deadening board |
| Vegetable fiber board, Tile and lay-in panels, plain or acoustic |
| Vermiculite aggregate, 480 kg/m^3 |
| Vermiculite aggregate, 600 kg/m^3 |
| Vermiculite aggregate, 720 kg/m^3 |
| Vermiculite aggregate, 840 kg/m^3 |
| Vermiculite aggregate, 960 kg/m^3 |
| Waferboard |
| Water at 10°C |
| Water at 40°C |
| Water at 80°C |
| Water, ice at -10 °C |
| Water, ice at 0 °C |
| Water, snow, compacted (<200 mm) |
| Water, snow, freshly fallen (<30 mm) |
| Water, snow, slightly compacted (70 mm to 100 mm) |
| Water, snow, soft (30 mm to 70 mm) |
| West coast woods, cedars |
| Western red cedar |
| Wood shingles, plain and plastic-film-faced |
| Wood, cement-bonded particleboard |
| Wood, fibreboard, 250 kg/m^3 |
| Wood, fibreboard, 400 kg/m^3 |
| Wood, fibreboard, 600 kg/m^3 |
| Wood, fibreboard, 800 kg/m^3 |
| Wood, oriented strand board |
| Wood, particleboard, 300 kg/m^3 |
| Wood, particleboard, 600 kg/m^3 |
| Wood, particleboard, 900 kg/m^3 |
| Wood, plywood 1000 kg/m^3 |
| Wood, plywood 300 kg/m^3 |
| Wood, plywood 500 kg/m^3 |
| Wood, plywood 700 kg/m^3 |
| Zircon |
| Zirconia |
| a/b-Alumina |
Python Code
import ht.insulation
def list_materials():
"""
List all valid material IDs for property lookups.
See: https://ht.readthedocs.io/en/latest/ht.insulation.html
This example function is provided as-is without any representation of accuracy.
Returns:
list[list]: Column of all valid material IDs.
"""
try:
# Combine all available material dictionaries
materials = set()
if hasattr(ht.insulation, 'building_materials'):
materials.update(ht.insulation.building_materials.keys())
if hasattr(ht.insulation, 'refractories'):
materials.update(ht.insulation.refractories.keys())
if hasattr(ht.insulation, 'ASHRAE'):
materials.update(ht.insulation.ASHRAE.keys())
sorted_materials = sorted(list(materials))
return [[m] for m in sorted_materials]
except Exception as e:
return f"Error: {str(e)}"