{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Lookup_Table","Itemized Listing"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Lookup_Table","index":0,"n_rows":120,"n_cols":5,"rows_kept":120,"cut":false,"hidden":true,"merged":[]}
["Price","Item #","Table20.Brand","Table20.Description","Table20.Link"]
[111.6,7000,"Johnny's Selected Seeds","Moveable Caterpillar Tunnel Hoop Bender – 12'","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/benders/moveable-caterpillar-tunnel-hoop-bender-12-quick-hoops-7000.html"]
[94.5,7033,"Johnny's Selected Seeds","Sidewall Hand Crank","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/hardware-accessories/sidewall-hand-crank-7033.html"]
[9.4499999999999993,7035,"Johnny's Selected Seeds","Snap Clamps for 1-3/8 in. Top-Rail, 10 pack","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/hardware-accessories/snap-clamps-for-1%22-pvc-or-chain-link-fence-top-rail-7035.html"]
[24.51,181697,"Home Depot","10 ft length of 1-3/8\" top rail","https://www.homedepot.com/p/Everbilt-Chain-Link-Fence-1-3-8-in-Diameter-x-10-ft-Long-17-Gauge-Thick-Galvanized-Steel-Top-Rail-Post-328913DPTEB/312373065"]
[8.1,7036,"Johnny's Selected Seeds","Snap Clamps for 3/4\" PVC or 1\" EMT","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/hardware-accessories/snap-clamps-for-3-4%22-pvc-or-1%22-emt-7036.html"]
[31.97,623105,"Home Depot","8 ft length of 1-5/8 in. line post","https://www.homedepot.com/p/Everbilt-1-5-8-in-Dia-x-8-ft-16-Gauge-Galvanized-Steel-Chain-Link-Fence-Line-Post-328923DPTSEB/312373067"]
[2.5,7040,"Johnny's Selected Seeds","4 ft. length of Poly Latch (\"Wiggle\") Wire","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/hardware-accessories/poly-latch-wire-4-7040.html"]
[23.97,320858,"Home Depot","6 ft length of 1-5/8 in. line post","https://www.homedepot.com/p/Everbilt-1-5-8-in-Dia-x-6-ft-16-Gauge-Galvanized-Steel-Chain-Link-Fence-Line-Post-328921DPTSEB/312373050"]
[12.5,7041,"Johnny's Selected Seeds","8 ft. length of Poly Latch (\"Wiggle\") Channel","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/hardware-accessories/poly-latch-channel-8-7041.html"]
[247.5,7176,"Johnny's Selected Seeds","Tufflite IV Greenhouse Film, 28 x 65 ft.","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/greenhouse-film/tufflite/tufflite-iv-28-x-65-greenhouse-film-7176.html"]
[0.22,23,"www.boltdepot.com","Hex bolts, Zinc plated steel, 5/16\"-18 x 2\"","https://boltdepot.com/Product-Details?product=23"]
[305.10000000000002,7177,"Johnny's Selected Seeds","Tufflite IV Greenhouse Film, 28 x 100 ft.","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/greenhouse-film/tufflite/tufflite-iv-28-x-100-greenhouse-film-7177.html"]
[0.15,199,"www.boltdepot.com","1/4-20 x 2 in. hex head bolt","https://boltdepot.com/Product-Details?product=199"]
[350.1,7178,"Johnny's Selected Seeds","Tufflite IV Greenhouse Film, 28 x 125 ft.","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/greenhouse-film/tufflite/tufflite-iv-28-x-125-greenhouse-film-7178.html"]
[0.23,218,"www.boltdepot.com","Hex bolts, Zinc plated steel, 3/8\"-16 x 1\"","https://boltdepot.com/Product-Details?product=218"]
[193.5,7300,"Johnny's Selected Seeds","Gothic Tunnel Hoop Bender – 14'","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/benders/gothic-tunnel-hoop-bender-14-quick-hoops-7300.html"]
[1.21,859,"www.boltdepot.com","3/8 in. x 5 in. hex tap bolt (fully threaded)","https://boltdepot.com/Product-Details?product=859"]
[449.1,7301,"Johnny's Selected Seeds","Tufflite IV™ – 32' x 100'","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/greenhouse-film/tufflite/tufflite-iv-32-x-100-greenhouse-film-7301.html"]
[0.59,2032,"www.boltdepot.com","#10 x 4 in. wood screw","https://boltdepot.com/Product-Details?product=2032"]
[110.7,9018,"Johnny's Selected Seeds","Quick Hoops High Tunnel Bender","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/benders/high-tunnel-hoop-bender-12-quick-hoops-9018.html"]
[11.73,732050,"Home Depot","1 in. x 8 in. x 16 ft. ledger board ","https://www.homedepot.com/p/1-in-x-8-in-x-16-ft-Ledger-Common-Softwood-Boards-234611/202527794"]
[7.88,9150,"Johnny's Selected Seeds","Snap Clamps for ¾ in. EMT, 10 pack","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/hardware-accessories/snap-clamps-for-3-4%22-emt-or-1-2%22-pvc-9150.html"]
[7.0000000000000007E-2,2396,"www.boltdepot.com","Sheet metal screws, Self drilling, Hex washer head, Zinc plated steel, #6 x 1/2\"","https://boltdepot.com/Product-Details?product=2396"]
[34.65,9482,"Johnny's Selected Seeds","Ground Post Driver","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/hardware-accessories/ground-post-driver-9482.0.html"]
[5.17,2405,"www.boltdepot.com","#10 x 3/4 in. hex-head self-tapping screws, bag of 100","https://boltdepot.com/Product-Details?product=2405"]
[5.81,9542,"Johnny's Selected Seeds","Cross Connector for 1.315\" x 1.315\" Pipe, pkg of 2","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/hardware-accessories/cross-connectors-2-count-9542.html"]
[3.95,2520,"www.boltdepot.com","#8 x 3/4\" phillips-head self-tapping screws, bag of 100","https://boltdepot.com/Product-Details?product=2520"]
[35.1,9604,"Johnny's Selected Seeds","#9 Wire, Coil of 60 ft.","https://www.johnnyseeds.com/tools-supplies/row-covers-and-accessories/supports-anchors/coiled-%239-support-wire-60-9604.html"]
[0.12,2624,"www.boltdepot.com","1/4 -20 nylock lock nut","https://boltdepot.com/Product-Details?product=2624"]
[170.1,9630,"Johnny's Selected Seeds","Tufflite IV™ – 20' x 65'","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/greenhouse-film/tufflite/tufflite-iv-20-x-65-greenhouse-film-9630.html"]
[0.05,2648,"www.boltdepot.com","1/4 in. hex nut","https://boltdepot.com/Product-Details?product=2648"]
[310.5,9644,"Johnny's Selected Seeds","Tufflite IV™ – 20' x 125'","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/greenhouse-film/tufflite/tufflite-iv-20-x-125-greenhouse-film-9644.html"]
[197.1,9645,"Johnny's Selected Seeds","Tufflite IV Greenhouse Film, 24 x 65 ft.","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/greenhouse-film/tufflite/tufflite-iv-24-x-65-greenhouse-film-9645.html"]
[346.5,9701,"Johnny's Selected Seeds","Tufflite IV Greenhouse Film, 24 x 125 ft.","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/greenhouse-film/tufflite/tufflite-iv-24-x-125-greenhouse-film-9701.html"]
[71.55,9723,"Johnny's Selected Seeds","Anchoring Pins™ Fabric Staples – 500 Count","https://www.johnnyseeds.com/tools-supplies/row-covers-and-accessories/supports-anchors/anchoring-pins-fabric-staples-500-count-9723.html"]
[229,9724,"Johnny's Selected Seeds","Pro 5 Weed Barrier – 4' x 250'","https://www.johnnyseeds.com/tools-supplies/mulches-and-weed-barrier/fabric-mulch/pro-5-weed-barrier-4-x-250-landscape-fabric-9724.html"]
[114.3,9725,"Johnny's Selected Seeds","#9 Wire, Coil of 550 ft.","https://www.johnnyseeds.com/tools-supplies/row-covers-and-accessories/supports-anchors/coiled-%239-support-wire-550-9725.html"]
[7.0000000000000007E-2,2649,"www.boltdepot.com","5/16\"-18 hex nut","https://boltdepot.com/Product-Details?product=2649"]
[0.47,"BB138","Chain Link Fittings","1-3/8 in. brace band","https://chainlinkfittings.com/store/1-3-8-brace-bands-chain-link-fence.html"]
[0.06,2662,"www.boltdepot.com","3/8 in. hex jam nut","https://boltdepot.com/Product-Details?product=2662"]
[0.21,2691,"www.boltdepot.com","3/8 in. wing nut","https://boltdepot.com/Product-Details?product=2691"]
[0.11,2750,"www.boltdepot.com","Carriage bolts, Zinc plated steel, 1/4\"-20 x 1\"","https://boltdepot.com/Product-Details?product=2750"]
[0.09,2525,"www.boltdepot.com","Sheet metal screws, Self drilling, Phillips pan head, Zinc plated steel, #10 x 3/4\"","https://boltdepot.com/Product-Details?product=2525"]
[0.15,2753,"www.boltdepot.com","1/4 in. x 1.75 in. carriage bolt","https://boltdepot.com/Product-Details?product=2753"]
[3.85,161640,"Home Depot","2 in. x 4 in. x 8 ft. whitewood stud","https://www.homedepot.com/p/2-in-x-4-in-x-8-ft-Prime-Stud-058449/312528776"]
[27.98,101697,"Home Depot","26 in. x 8 ft. clear polycarbonate roofing panel","https://www.homedepot.com/p/Suntuf-26-in-x-8-ft-Corrugated-Polycarbonate-Roof-Panel-in-Clear-101697/100021329"]
[0.3,2760,"www.boltdepot.com","1/4 in. x 4 in. carriage bolt","https://boltdepot.com/Product-Details?product=2760"]
[0.1,2650,"www.boltdepot.com","Hex nuts, Zinc plated steel, 3/8\"-16","https://boltdepot.com/Product-Details?product=2650"]
[9.57,784261,"Home Depot","1 in. x 4 in. x 8 ft. board","https://www.homedepot.com/p/1-in-x-4-in-x-8-ft-Premium-Cedar-Square-Edge-Board-784261/202070415"]
[3.5,237042,"Home Depot","3 in. door hinge (with screws)","https://www.homedepot.com/p/Everbilt-3-in-Square-Corner-Satin-Brass-Door-Hinge-14989/202558080"]
[4.2699999999999996,241725,"Home Depot","5.75 in. zinc plated door pull (with screws)","https://www.homedepot.com/p/Everbilt-5-3-4-in-Zinc-Plated-Door-Pull-15181/202033999"]
[3.78,474206,"Home Depot","6 in. zinc plated hook-and-eye latch","https://www.homedepot.com/p/Everbilt-6-in-Zinc-Plated-Hook-and-Eye-15335/202034263"]
[12.72,161756,"Home Depot","2 in. x 6 in. x 12 ft. spruce/pine/fir board","https://www.homedepot.com/p/2-in-x-6-in-x-12-ft-KD-HT-SPF-Dimensional-Lumber-058445/312528843"]
[9.9700000000000006,134228,"Home Depot","#9 x 2-1/2 in. wood screws, 1 lb. box","https://www.homedepot.com/p/Grip-Rite-9-x-2-1-2-in-2-Phillips-Bugle-Head-Coarse-Thread-Sharp-Point-Polymer-Coated-Exterior-Screws-1-lb-Pack-PTN212S1/100173447"]
[5.41,203106,"Home Depot","10 ft length of 1/2 in. EMT","https://www.homedepot.com/p/1-2-in-x-10-ft-Electrical-Metallic-Tubing-EMT-Conduit-8511-103HD/330333257"]
[3.11,103659,"Home Depot","1/2 in. iron water pipe T fitting","https://www.homedepot.com/p/Southland-1-2-in-Black-Malleable-Iron-Tee-Fitting-520-603HN/100189151"]
[9.52,203114,"Home Depot","10 ft length of 3/4 in. EMT","https://www.homedepot.com/p/3-4-in-x-10-ft-Electric-Metallic-Tube-EMT-Conduit-8511-104HD/330385394"]
[5.24,403636,"Home Depot","3/4 in. EMT compression fittings, 5 pack","https://www.homedepot.com/p/3-4-in-Electric-Metallic-Tube-EMT-Compression-Coupling-5-Pack-20222/100178967"]
[null,"550C-WHT1000","The Paracord Store","White 550 Paracord","https://theparacordstore.com/products/white-paracord?variant=42776164499607"]
[12.41,727401,"Home Depot","#4 zinc plated steel screw eyes, pack of 25","https://www.homedepot.com/p/Everbilt-4-Zinc-Plated-Steel-Screw-Eye-25-Pack-803662/204273859"]
[13.73,372074,"Home Depot","3/8 x 8 in. hook and eye turnbuckle","https://www.homedepot.com/p/Lehigh-350-lb-3-8-in-x-8-in-Stainless-Steel-Hook-and-Eye-Turnbuckle-7112/100117143"]
[0.16,2769,"www.boltdepot.com","Carriage bolts, Zinc plated steel, 5/16\"-18 x 1\"","https://boltdepot.com/Product-Details?product=2769"]
[1.75,312373166,"Home Depot","1-3/8 in. Galvanized Steel Chain Link Fence Tension Band for Fence Rail","https://www.homedepot.com/p/Everbilt-1-3-8-in-Galvanized-Steel-Chain-Link-Fence-Tension-Band-for-Fence-Rail-328522EB/312373166"]
[7.98,205960892,"Home Depot","1-3/4 in. x 3-1/2 in. x 6 ft. Green Steel Fence T-Post with Anchor Plate","https://www.homedepot.com/p/Everbilt-1-3-4-in-x-3-1-2-in-x-6-ft-Green-Steel-Fence-T-Post-with-Anchor-Plate-901176EB/205960892"]
[5.75,205960881,"Home Depot","1-1/4 in. x 3/4 in. x 3 ft. 14-Gauge Green Steel U-Fence Post with Anchor Plate","https://www.homedepot.com/p/Everbilt-1-1-4-in-x-3-4-in-x-3-ft-14-Gauge-Green-Steel-U-Fence-Post-with-Anchor-Plate-901153EB/205960881"]
[5.98,461443,"Home Depot","1 in. x 2 in. x 1.5 ft. grade stakes, 12 pack","https://www.homedepot.com/p/Grade-Stakes-Pine-12-Pack-Common-1-in-x-2-in-x-1-1-2-ft-Actual-562-in-x-1-375-in-x-17-5-in-461443/203316903"]
[27.36,202719050,"Home Depot","30 in. earth anchors, 4 pack","https://www.homedepot.com/p/ShelterLogic-30-in-Earth-Anchor-Set-4-Piece-w-Heavy-Duty-Corrosion-Resistant-Steel-Construction-and-Spinnable-Corkscrew-Design-10075/202719050"]
[12.44,321922,"Home Depot","5/16-18 x 8-7/8 in. hook and hook turnbuckle, 5 pack","https://www.homedepot.com/p/Hardware-Essentials-5-16-18-in-x-8-7-8-in-Zinc-Plated-Hook-and-Hook-Turnbuckle-5-Pack-321922/203810235"]
[5.1100000000000003,103667,"Home Depot","3/4 in. iron water pipe T fitting","https://www.homedepot.com/p/Southland-3-4-in-Black-Malleable-Iron-FIP-x-FIP-x-FIP-Tee-Fitting-520-604HN/100073073"]
[5.35,106151,"Home Depot","1/2 in. x 2 ft. rebar","https://www.homedepot.com/p/1-2-in-x-2-ft-4-Rebar-05152/202094274"]
[3.28,117741,"Home Depot","1/4 in. x 7-3/4 in. Zinc-Plated Turnbuckles with Hook & Eye","https://www.homedepot.com/p/Everbilt-1-4-in-x-7-3-4-in-Zinc-Plated-Turnbuckle-Hook-Eye-807086/204276134"]
[16.48,580015,"Home Depot","10 ft length of 1 in. EMT for scissor doors","https://www.homedepot.com/p/1-in-x-10-ft-Electrical-Metallic-Tubing-EMT-Conduit-550210000/304229415"]
[3.68,120583,"Home Depot","6 in. 12-Gauge Heavy Strap Ties","https://www.homedepot.com/p/Simpson-Strong-Tie-HRS-6-in-12-Gauge-Galvanized-Heavy-Strap-Tie-HRS6/100374840"]
[9.98,202972266,"Home Depot","#2 x 15 ft. Zinc Plated Medium Dog Run Chain","https://www.homedepot.com/p/Everbilt-3-x-15-ft-Zinc-Plated-Steel-Double-Loop-Chain-803072/203958780"]
[9.9700000000000006,134380,"Home Depot","#10 x 3 in. Phillips Bugle-Head Wood Screws, 1 lb. box","https://www.homedepot.com/p/Grip-Rite-9-x-3-in-2-Phillips-Bugle-Head-Coarse-Thread-Sharp-Point-Polymer-Coated-Exterior-Screw-1-lb-Pack-PTN3S1/100115639?N=5yc1vZc2bl"]
[47.85,266795,"Home Depot","2 ft. x 25 ft. Hardware Cloth, 1/2 in. mesh","https://www.homedepot.com/p/Everbilt-Galvanized-Steel-1-2-in-Mesh-2-ft-x-25-ft-19-Gauge-Hardware-Cloth-308224EB/205960837"]
[6.15,161659,"Home Depot","2 in. x 4 in. x 10 ft. spruce, pine, or fir lumber","https://www.homedepot.com/p/2-in-x-4-in-x-10-ft-Standard-and-Better-Kiln-Dried-Heat-Treated-Spruce-Pine-Fir-Lumber-161659/100080482"]
[1.1000000000000001,423823,"Home Depot","1-3/8\" End Cap","https://www.homedepot.com/p/Everbilt-1-3-8-in-Chain-Link-Fence-Aluminum-Rail-End-328550EB/312373152"]
[17.63,161799,"Home Depot","2 in. x 6 in. x 16 ft. spruce, pine, or fir lumber","https://www.homedepot.com/p/Unbranded-2-in-x-6-in-x-16-ft-2-Better-Kiln-Dried-Heat-Treated-Spruce-Pine-Fir-Lumber-161799/202086799"]
[18.98,253944,"Home Depot","5/4 in. x 6 in. x 16 ft. deck boards","https://www.homedepot.com/p/WeatherShield-5-4-in-x-6-in-x-16-ft-Ground-Contact-Pressure-Treated-Premium-Southern-Yellow-Pine-Decking-Board-253944/206966950?keyword=1-1%2F4+in.+x+6+in.+x+16+ft.+Pressure-Treated+Decking+Board"]
[12.98,175544,"Home Depot","T-post anchor for ends","https://www.homedepot.com/p/Everbilt-6-1-2-ft-H-Green-Steel-T-Post-710249930/317766972"]
[0.98,208229,"Home Depot","2 in. x 4 in. 20-Gauge Framing Brackets","https://www.homedepot.com/p/Simpson-Strong-Tie-FB-ZMAX-Galvanized-Fence-Rail-Bracket-for-2x4-Nominal-Lumber-FB24Z/100375311?keyword=fb24z"]
[1.64,654167,"Home Depot","3/8 in. x 6 in. Carriage Bolt (fully threaded)","https://www.homedepot.com/p/Everbilt-3-8-in-16-x-6-in-Zinc-Plated-Carriage-Bolt-800316/204633673"]
[10.47,240664,"Home Depot","6 in. Zinc Plated Heavy Duty Barrel Bolt","https://www.homedepot.com/p/Everbilt-6-in-Zinc-Plated-Heavy-Duty-Barrel-Bolt-15149/202033963"]
[18.98,253942,"Home Depot","2 in. x 6 in. x 16 ft. spruce, pine, or fir lumber","https://www.homedepot.com/p/WeatherShield-5-4-in-x-6-in-x-16-ft-Ground-Contact-Pressure-Treated-Premium-Southern-Yellow-Pine-Decking-Board-253944/206966950?keyword=1-1%2F4+in.+x+6+in.+x+16+ft.+Pressure-Treated+Decking+Board"]
[8.65,914681,"Home Depot","1 in. x 4 in. x 8 ft. spruce, pine, or fir lumber","https://www.homedepot.com/p/1-in-x-4-in-x-8-ft-Premium-Kiln-Dried-Square-Edge-Whitewood-Common-Board-914681/100023465"]
[5.97,479652,"Home Depot","1.25 in. drywall screws, 1 lb. box","https://www.homedepot.com/p/Grip-Rite-6-x-1-1-4-in-2-Phillips-Bugle-Head-Coarse-Thread-Sharp-Point-Drywall-Screws-1-lb-Pack-114CDWS1/100152392"]
[9.98,292141,"Home Depot","3/32 in.-1/8 in. Cable Clamps, pack of 3","https://www.homedepot.com/p/Everbilt-3-32-in-x-1-8-in-Stainless-Steel-Clamp-Set-3-Piece-43074/205883048"]
[0.98,333431,"Home Depot","20-Gauge 1-1/4 in. x 9 in. Strap Ties","https://www.homedepot.com/p/Simpson-Strong-Tie-LSTA-1-1-4-in-x-9-in-20-Gauge-Galvanized-Strap-Tie-LSTA9/202255804?keyword=lsta9"]
[40.67,301878333,"Home Depot","5/16 in. x 6 in. Heavy Duty Wood Screws, pkg of 25","https://www.homedepot.com/p/GRK-Fasteners-5-16-in-x-6-in-Star-Drive-Low-Profile-Washer-Head-Wood-Screw-25-Pack-95300/311953212"]
[1.48,335216,"Home Depot","18-Gauge 3-1/4 in. Gusset Angle Corner Braces","https://www.homedepot.com/p/Simpson-Strong-Tie-GA-3-1-4-in-18-Gauge-Galvanized-Gusset-Angle-GA2/100375243?N=5yc1vZaqzs"]
[6.98,461393,"Home Depot","6 in. x 6 in. 14-Gauge L Straps","https://www.homedepot.com/p/Simpson-Strong-Tie-6-in-x-6-in-14-Gauge-Galvanized-L-Strap-66L/100374887"]
[4.25,711786,"Home Depot","4 in. Door Hinges","https://www.homedepot.com/p/Everbilt-4-in-Satin-Nickel-5-8-in-Radius-Door-Hinge-15002/202558089"]
[5.27,671223,"Home Depot","3/8 in. x 36 in. Zinc-plated Threaded Rod","https://www.homedepot.com/p/Everbilt-3-8-in-x-36-in-Zinc-Threaded-Rod-802237/204273970"]
[1.58,879282,"Home Depot","8 in. Wooden Shims, bundle of 12","https://www.homedepot.com/p/8-in-Pine-Shims-12-Pack-WSSHW08/300723328"]
[0.24,2772,"www.boltdepot.com","Carriage bolts, Zinc plated steel, 5/16\"-18 x 1-3/4\"","https://boltdepot.com/Product-Details?product=2772"]
[0.31,2777,"www.boltdepot.com","Carriage bolts, Zinc plated steel, 5/16\"-18 x 3\"","https://boltdepot.com/Product-Details?product=2777"]
[14.57,162330,"Home Depot","#10 x 3/4 in. External Hex Flange Hex-Head Self-Drilling Screws (150-Pack)","https://www.homedepot.com/p/Teks-10-x-3-4-in-External-Hex-Flange-Hex-Head-Self-Drilling-Screws-150-Pack-21320/100138326"]
[0.37,2779,"www.boltdepot.com","Carriage bolts, Zinc plated steel, 5/16\"-18 x 3-1/2\"","https://boltdepot.com/Product-Details?product=2779"]
[0.41,2780,"www.boltdepot.com","Carriage bolts, Zinc plated steel, 5/16\"-18 x 4\"","https://boltdepot.com/Product-Details?product=2780"]
[0.19,"BB158","Chain Link Fittings","Chain Link 1 5/8\" Brace Band [12 Gauge] - Rail End Band","https://chainlinkfittings.com/store/1-5-8-brace-bands-chain-link-fence.html"]
[0.63,2784,"www.boltdepot.com","Carriage bolts, Zinc plated steel, 5/16\"-18 x 6\"","https://boltdepot.com/Product-Details?product=2784"]
[5.1200000000000002E-2,"CB382","Chain Link Fittings","Chain Link 3/8\" x 2\" Carriage Bolt & Nut","https://chainlinkfittings.com/store/3-8-x-2-carriage-bolts-and-nuts.html"]
[0.05,2977,"www.boltdepot.com","5/16\" flat washers","https://boltdepot.com/Product-Details?product=2977"]
[0.32,"CB5162HDG","Chain Link Fittings","Chain Link 5/16\" x 2\" Carriage Bolt & Nut","https://chainlinkfittings.com/store/5-16-x-2-carriage-bolts-and-nuts.html"]
[0.08,3025,"www.boltdepot.com","5/16\" lock washers","https://boltdepot.com/Product-Details?product=3025"]
[0.19,"CB51614HDG","Chain Link Fittings","Chain Link 5/16\" x 1 1/4\" Carriage Bolt & Nut","https://chainlinkfittings.com/store/carriage-bolts-with-nut.html"]
[0.32,"ERC1313","Chain Link Fittings","Chain Link 1 3/8\" x 1 3/8\" End Rail Clamp - Rail Band, T Clamp","https://chainlinkfittings.com/store/1-3-8-x-1-3-8-end-rail-clamp-rail-bands-t-clamps.html"]
[13.893000000000001,"PTR","Chain Link Fittings","Chain Link 1 5/8\" Gate Pipe Track Safety Roller w/ 5\" Wheel","https://chainlinkfittings.com/store/pipe-track-roller-galvanized-chain-link-fence.html"]
[0.06,2978,"www.boltdepot.com","SAE flat washers, Zinc plated steel, 3/8\"","https://boltdepot.com/Product-Details?product=2978"]
[0.32,"LRC1313","Chain Link Fittings","Chain Link 1 3/8\" x 1 3/8\" Line Rail Clamp - Boulevard Clamp","https://chainlinkfittings.com/store/1-3-8-x-1-3-8-line-rail-clamps-for-chain-link-fencing.html"]
[0.09,3026,"www.boltdepot.com","Lock washers, Zinc plated steel, 3/8\"","https://boltdepot.com/Product-Details?product=3026"]
[0.19,7242,"www.boltdepot.com","Hex nylon insert lock nuts, Zinc plated steel, 3/8\"-16","https://boltdepot.com/Product-Details?product=7242"]
[8.24,7783,"www.boltdepot.com","#7 x 1.25 in. wood screw, box of 100","https://boltdepot.com/Product-Details?product=7783"]
[1.1499999999999999,12280,"www.boltdepot.com","Wire eye bolts (w/ nuts), Zinc plated steel, 5/16\"-18 x 1-3/4\"","https://boltdepot.com/Product-Details?product=12280"]
[1.69,12292,"www.boltdepot.com","Wire eye bolts (w/ nuts), Zinc plated steel, 3/8\"-16 x 2-1/2\"","https://boltdepot.com/Product-Details?product=12292"]
[2.4300000000000002,12492,"www.boltdepot.com","U-Bolts, Round bend, Zinc plated steel, 5/16\"-18, 1-3/8\" x 2-1/2\"","https://boltdepot.com/Product-Details?product=12492"]
[1.59,12528,"www.boltdepot.com","J-Bolts w/ nuts, Zinc plated steel, 5/16\"-18 x 5\"","https://boltdepot.com/Product-Details?product=12528"]
[1.83,12529,"www.boltdepot.com","5/16\"-18 x 7\" J-bolt","https://boltdepot.com/Product-Details?product=12529"]

{"sheet":"Itemized Listing","index":1,"n_rows":113,"n_cols":23,"rows_kept":113,"cut":false,"hidden":false,"merged":[[18,3,18,8],[17,3,17,8],[111,3,111,11],[68,3,68,4],[67,3,67,4],[66,3,66,4],[65,3,65,4],[64,3,64,4],[63,3,63,4],[62,3,62,4],[61,3,61,4],[60,3,60,4],[76,6,76,7],[77,6,77,7],[38,6,38,7],[40,6,40,7],[39,6,39,7],[63,6,63,7],[70,6,70,7],[61,6,61,7],[62,6,62,7],[57,6,57,7],[99,6,99,7],[105,6,105,7],[13,1,18,1],[33,6,33,7],[48,6,48,7],[50,6,50,7],[34,6,34,7],[42,6,42,7],[45,6,45,7],[37,6,37,7],[31,6,31,7],[35,3,35,4],[34,3,34,4],[33,3,33,4],[32,3,32,4],[31,3,31,4],[30,3,30,4],[29,3,29,4],[27,3,27,4],[26,3,26,4],[40,3,40,4],[39,3,39,4],[38,3,38,4],[37,3,37,4],[21,3,21,8],[20,3,20,8],[95,6,95,7],[86,6,86,7],[93,6,93,7],[59,9,59,10],[102,9,102,10],[25,9,25,10],[28,3,28,8],[28,9,28,10],[52,3,52,8],[36,6,36,7],[51,6,51,7],[32,6,32,7],[56,6,56,7],[96,6,96,7],[73,3,73,8],[73,9,73,10],[44,6,44,7],[74,6,74,7],[29,6,29,7],[54,6,54,7],[87,6,87,7],[92,6,92,7],[89,6,89,7],[90,6,90,7],[107,6,107,7],[108,6,108,7],[59,3,59,8],[72,6,72,7],[66,6,66,7],[64,6,64,7],[100,6,100,7],[101,6,101,7],[60,6,60,7],[65,6,65,7],[102,3,102,8],[103,6,103,7],[104,6,104,7],[75,6,75,7],[67,6,67,7],[94,6,94,7],[82,6,82,7],[98,6,98,7],[97,6,97,7],[68,6,68,7],[69,6,69,7],[106,6,106,7],[78,6,78,7],[79,6,79,7],[20,9,21,11],[58,6,58,7],[49,6,49,7],[46,3,46,8],[46,9,46,10],[1,3,1,11],[7,3,7,5],[24,6,24,7],[30,6,30,7],[17,9,18,11],[2,3,2,11],[5,3,5,7],[10,3,10,5],[10,8,10,11],[10,6,10,7],[11,3,11,5],[8,3,8,5],[47,6,47,7],[43,6,43,7],[27,6,27,7],[25,3,25,8],[26,6,26,7],[35,6,35,7],[52,9,52,10],[91,6,91,7],[55,6,55,7],[41,9,41,10],[83,6,83,7],[88,6,88,7],[84,6,84,7],[85,6,85,7],[41,3,41,8],[80,6,80,7],[81,6,81,7],[71,6,71,7],[53,6,53,7],[58,3,58,4],[57,3,57,4],[56,3,56,4],[55,3,55,4],[54,3,54,4],[53,3,53,4],[72,3,72,4],[71,3,71,4],[70,3,70,4],[69,3,69,4],[82,3,82,4],[81,3,81,4],[36,3,36,4],[45,3,45,4],[44,3,44,4],[43,3,43,4],[42,3,42,4],[51,3,51,4],[50,3,50,4],[49,3,49,4],[48,3,48,4],[47,3,47,4],[77,3,77,4],[76,3,76,4],[75,3,75,4],[74,3,74,4],[83,3,83,4],[100,3,100,4],[99,3,99,4],[98,3,98,4],[97,3,97,4],[96,3,96,4],[95,3,95,4],[94,3,94,4],[93,3,93,4],[92,3,92,4],[112,3,112,11],[14,3,14,4],[13,3,13,4],[101,3,101,4],[13,9,15,9],[24,3,24,4],[3,3,3,11],[108,3,108,4],[107,3,107,4],[106,3,106,4],[105,3,105,4],[104,3,104,4],[103,3,103,4],[91,3,91,4],[90,3,90,4],[89,3,89,4],[88,3,88,4],[87,3,87,4],[86,3,86,4],[85,3,85,4],[84,3,84,4],[80,3,80,4],[79,3,79,4],[78,3,78,4]]}
[]
[null,null,null,"Quick Hoops™ Fixed Traditional 14 ft. Wide Gothic High Tunnel Calculator"]
[null,null,null,"***Change the items in white boxes below to meet your needs and the calculator will do the rest.***"]
[null,null,null,"All prices are estimations. Prices will vary and do not include shipping costs or tax. Vendors and part#'s for pipe and other accessories are provided for your convenience only. Johnny's has no affiliation with these companies, other than purchasing these supplies from them and finding their prices competitive."]
[]
[null,null,null,"Dimensions, Spec's",null,null,null,null,null,null,"Square Feet",{"$f":"14*G8","v":0}]
[]
[null,null,null,"Length",null,null,null,"feet","Enter length here. Must be divisible by spacing. ",null,"Cost / Sq. Ft.",{"$f":"IF(OR($G$8=\"\",G8=0),\"\",L110/L6)","v":""},null,null,null,null,null,{"$f":"_xlfn._xlws.FILTER(_xlfn.SEQUENCE(3,,4),MOD($G$8/_xlfn.SEQUENCE(3,,4),1)=0=TRUE,\"Length must be divisable by 4,5 or 6\")","v":4}]
[null,null,null,"Spacing",null,null,null,"feet",null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,"# Segments",null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",G8/G9)","v":""}]
[null,"Condition",null,"# Bows",null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",G11+1)","v":""}]
[]
[null,{"$f":"IF(A16=TRUE,4,IF(AND(D14=2,D15=\"\",A16=FALSE, D18=\"x\",D19=\"\"),1,IF(AND(D14=1,D15=1,A16=FALSE, D18=\"x\",D19=\"\"),2,IF(AND(D14=\"\",D15=2,A16=FALSE, D18=\"x\",D19=\"\"),3,IF(AND(D14=\"\",D15=\"\",A16=FALSE, D18=\"\",D19=\"x\"),1,IF(AND(D14=2,D15=\"\",A16=FALSE, D18=\"\",D19=\"x\"),5,IF(AND(D14=1,D15=1,A16=FALSE, D18=\"\",D19=\"x\"),6,7)))))))","v":7},null,null,null," # Low cost scissor doors",null,null,null,{"$f":"IF(AND(D14=\"\", D15=\"\", D16=\"x\"),\"\", IF(AND((D14+D15)=2,D16=\"\"),\"\", \"Select '1' or '2' from the drop-down next to your choice for End Wall Options. You may choose 1 of each kind, 2 of one kind or the other, or select No end walls, and the calculator will not calculate them.\"))","v":"Select '1' or '2' from the drop-down next to your choice for End Wall Options. You may choose 1 of each kind, 2 of one kind or the other, or select No end walls, and the calculator will not calculate them."},null,null,null,null,null,null,null,{"$f":"2-SUM(D14:E15)","v":2},{"$f":"IFERROR(_xlfn._xlws.FILTER(_xlfn.SEQUENCE(2),_xlfn.SEQUENCE(2)<=$R$14),\"Plese select up to 2 doors options total\")","v":1}]
[null,null,null,null,null," # End walls with doors (per our instructions)",null,null,null,null,null,null,null,null,null," ",null,null,2]
[false,null,null,null,null," No end walls (do not calculate them)"]
[]
[1,null,null,{"$f":"IF($A$18=1,\"x\",\"\")","v":"x"},null,null,null,null,null,{"$f":"IF(AND(D18=\"x\",D19=\"\"),\"\",IF(AND(D18=\"\",D19=\"x\"),\"\", \"Type 'X' next to your choice for Roll-up Sides.               Please make only one choice.\"))","v":""},null,null,null,null,null,null,null,{"$f":"IF($A$16=TRUE,TRUE,FALSE)","v":false}]
[null,null,null,{"$f":"IF($A$18=2,\"x\",\"\")","v":""}]
[]
[1,null,null,{"$f":"IF($A$21=1,\"x\",\"\")","v":"x"},null,null,null,null,null,{"$f":"IF(AND(D21=\"x\",D22=\"\"),\"\",IF(AND(D21=\"\",D22=\"x\"),\"\", \"Type 'X' next to your choice for Weed Barrier.               Please make only one choice.\"))","v":""}]
[null,null,null,{"$f":"IF($A$21=2,\"x\",\"\")","v":""}]
[]
[]
[null,null,null,"Qty",null,"Unit","Part#",null,"Vendor","Description","Price","Ext"]
[null,null,null,"Special Tools",null,null,null,null,null,"Subtotal:",null,{"$f":"SUM(L27:L28)","v":0}]
[null,null,null,{"$f":"IF($G27=\"\",\"\",1)","v":""},null,{"$f":"IF($G27=\"\",\"\",\"each\")","v":""},{"$f":"IF($R27=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R27,Lookup_Table!B:B,Lookup_Table!E:E),$R27))","v":""},null,{"$f":"IF($G27=\"\",\"\",_xlfn.XLOOKUP($G27,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G27=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G27,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S27))","v":""},{"$f":"IF($G27=\"\",\"\",_xlfn.XLOOKUP($G27,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},{"$f":"IF($G27=\"\",\"\",$D27*$K27)","v":""},null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",7300)","v":""},""]
[null,null,null,{"$f":"IF($G28=\"\",\"\",1)","v":""},null,{"$f":"IF($G28=\"\",\"\",\"each\")","v":""},{"$f":"IF($R28=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R28,Lookup_Table!B:B,Lookup_Table!E:E),$R28))","v":""},null,{"$f":"IF($G28=\"\",\"\",_xlfn.XLOOKUP($G28,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G28=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G28,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S28))","v":""},{"$f":"IF($G28=\"\",\"\",_xlfn.XLOOKUP($G28,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},{"$f":"IF($G28=\"\",\"\",$D28*$K28)","v":""},null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",9482)","v":""},""]
[null,null,null,"Frame Components",null,null,null,null,null,"Subtotal:",null,{"$f":"SUM(L30:L41)","v":0},null,null,null,null,null,null,""]
[null,null,null,{"$f":"IF($G30=\"\",\"\",G12*2)","v":""},null,{"$f":"IF($G30=\"\",\"\",\"each\")","v":""},{"$f":"IF($R30=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R30,Lookup_Table!B:B,Lookup_Table!E:E),$R30))","v":""},null,{"$f":"IF($G30=\"\",\"\",_xlfn.XLOOKUP($G30,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G30=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G30,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S30))","v":""},{"$f":"IF($G30=\"\",\"\",_xlfn.XLOOKUP($G30,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},{"$f":"IF($G30=\"\",\"\",$D30*$K30)","v":""},null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",181697)","v":""},"for side hoops"]
[null,null,null,{"$f":"IF($G31=\"\",\"\",ROUNDUP(G12/2,0))","v":""},null,"",{"$f":"IF($R31=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R31,Lookup_Table!B:B,Lookup_Table!E:E),$R31))","v":""},null,{"$f":"IF($G31=\"\",\"\",_xlfn.XLOOKUP($G31,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G31=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G31,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S31))","v":""},{"$f":"IF($G31=\"\",\"\",_xlfn.XLOOKUP($G31,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",181697)","v":""},"for peak sections"]
[null,null,null,{"$f":"IF($G32=\"\",\"\",IF($A$16=TRUE,ROUNDUP(G8/10,0),IF(D14>0,ROUNDUP(G8/10+0.5,0),ROUNDUP(G8/10,0))))","v":""},null,"",{"$f":"IF($R32=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R32,Lookup_Table!B:B,Lookup_Table!E:E),$R32))","v":""},null,{"$f":"IF($G32=\"\",\"\",_xlfn.XLOOKUP($G32,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G32=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G32,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S32))","v":""},{"$f":"IF($G32=\"\",\"\",_xlfn.XLOOKUP($G32,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",181697)","v":""},"for ridge pole"]
[null,null,null,{"$f":"IF($G33=\"\",\"\",4)","v":""},null,"",{"$f":"IF($R33=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R33,Lookup_Table!B:B,Lookup_Table!E:E),$R33))","v":""},null,{"$f":"IF($G33=\"\",\"\",_xlfn.XLOOKUP($G33,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G33=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G33,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S33))","v":""},{"$f":"IF($G33=\"\",\"\",_xlfn.XLOOKUP($G33,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",181697)","v":""},"for angle braces"]
[null,null,null,{"$f":"IF($G34=\"\",\"\",G12)","v":""},null,"",{"$f":"IF($R34=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R34,Lookup_Table!B:B,Lookup_Table!E:E),$R34))","v":""},null,{"$f":"IF($G34=\"\",\"\",_xlfn.XLOOKUP($G34,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G34=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G34,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S34))","v":""},{"$f":"IF($G34=\"\",\"\",_xlfn.XLOOKUP($G34,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",623105)","v":""},"for ground posts"]
[null,null,null,{"$f":"IF($G35=\"\",\"\",G12)","v":""},null,"",{"$f":"IF($R35=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R35,Lookup_Table!B:B,Lookup_Table!E:E),$R35))","v":""},null,{"$f":"IF($G35=\"\",\"\",_xlfn.XLOOKUP($G35,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G35=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G35,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S35))","v":""},{"$f":"IF($G35=\"\",\"\",_xlfn.XLOOKUP($G35,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",203114)","v":""},"for collar ties"]
[null,null,null,{"$f":"IF($G36=\"\",\"\",G12*2)","v":""},null,"",{"$f":"IF($R36=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R36,Lookup_Table!B:B,Lookup_Table!E:E),$R36))","v":""},null,{"$f":"IF($G36=\"\",\"\",_xlfn.XLOOKUP($G36,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G36=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G36,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S36))","v":""},{"$f":"IF($G36=\"\",\"\",_xlfn.XLOOKUP($G36,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",23)","v":""},"for ground posts"]
[null,null,null,{"$f":"IF($G37=\"\",\"\",D36)","v":""},null,"",{"$f":"IF($R37=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R37,Lookup_Table!B:B,Lookup_Table!E:E),$R37))","v":""},null,{"$f":"IF($G37=\"\",\"\",_xlfn.XLOOKUP($G37,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G37=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G37,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S37))","v":""},{"$f":"IF($G37=\"\",\"\",_xlfn.XLOOKUP($G37,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",2649)","v":""},"for ground posts"]
[null,null,null,{"$f":"IF($G38=\"\",\"\",ROUNDUP((8*G12+16+G8/10)*1.1/100,0))","v":""},null,"",{"$f":"IF($R38=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R38,Lookup_Table!B:B,Lookup_Table!E:E),$R38))","v":""},null,{"$f":"IF($G38=\"\",\"\",_xlfn.XLOOKUP($G38,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G38=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G38,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S38))","v":""},{"$f":"IF($G38=\"\",\"\",_xlfn.XLOOKUP($G38,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",2405)","v":""},""]
[null,null,null,{"$f":"IF($G39=\"\",\"\",2*G12+12)","v":""},null,"",{"$f":"IF($R39=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R39,Lookup_Table!B:B,Lookup_Table!E:E),$R39))","v":""},null,{"$f":"IF($G39=\"\",\"\",_xlfn.XLOOKUP($G39,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G39=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G39,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S39))","v":""},{"$f":"IF($G39=\"\",\"\",_xlfn.XLOOKUP($G39,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",\"BB138\")","v":""},""]
[null,null,null,{"$f":"IF($G40=\"\",\"\",4)","v":""},null,"",{"$f":"IF($R40=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R40,Lookup_Table!B:B,Lookup_Table!E:E),$R40))","v":""},null,{"$f":"IF($G40=\"\",\"\",_xlfn.XLOOKUP($G40,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G40=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G40,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S40))","v":""},{"$f":"IF($G40=\"\",\"\",_xlfn.XLOOKUP($G40,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",\"BB158\")","v":""},""]
[null,null,null,{"$f":"IF($G41=\"\",\"\",D39+D40)","v":""},null,"",{"$f":"IF($R41=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R41,Lookup_Table!B:B,Lookup_Table!E:E),$R41))","v":""},null,{"$f":"IF($G41=\"\",\"\",_xlfn.XLOOKUP($G41,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G41=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G41,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S41))","v":""},{"$f":"IF($G41=\"\",\"\",_xlfn.XLOOKUP($G41,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",\"CB51614HDG\")","v":""},""]
[null,null,null,"Hipboards",null,null,null,null,null,"Subtotal:",null,{"$f":"SUM(L43:L46)","v":0},null,null,null,null,null,null,""]
[null,null,null,{"$f":"IF($G43=\"\",\"\",2.5*(ROUNDUP(G8/16,0)))","v":""},null,{"$f":"IF($G43=\"\",\"\",\"each\")","v":""},{"$f":"IF($R43=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R43,Lookup_Table!B:B,Lookup_Table!E:E),$R43))","v":""},null,{"$f":"IF($G43=\"\",\"\",_xlfn.XLOOKUP($G43,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G43=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G43,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S43))","v":""},{"$f":"IF($G43=\"\",\"\",_xlfn.XLOOKUP($G43,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},{"$f":"IF($G43=\"\",\"\",$D43*$K43)","v":""},null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",253944)","v":""},""]
[null,null,null,{"$f":"IF($G44=\"\",\"\",2*G12+2*4*(ROUNDUP(G8/16,0)))","v":""},null,"",{"$f":"IF($R44=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R44,Lookup_Table!B:B,Lookup_Table!E:E),$R44))","v":""},null,{"$f":"IF($G44=\"\",\"\",_xlfn.XLOOKUP($G44,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G44=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G44,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S44))","v":""},{"$f":"IF($G44=\"\",\"\",_xlfn.XLOOKUP($G44,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",2777)","v":""},""]
[null,null,null,{"$f":"IF($G45=\"\",\"\",D44)","v":""},null,"",{"$f":"IF($R45=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R45,Lookup_Table!B:B,Lookup_Table!E:E),$R45))","v":""},null,{"$f":"IF($G45=\"\",\"\",_xlfn.XLOOKUP($G45,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G45=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G45,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S45))","v":""},{"$f":"IF($G45=\"\",\"\",_xlfn.XLOOKUP($G45,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",2977)","v":""},""]
[null,null,null,{"$f":"IF($G46=\"\",\"\",D44)","v":""},null,"",{"$f":"IF($R46=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R46,Lookup_Table!B:B,Lookup_Table!E:E),$R46))","v":""},null,{"$f":"IF($G46=\"\",\"\",_xlfn.XLOOKUP($G46,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G46=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G46,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S46))","v":""},{"$f":"IF($G46=\"\",\"\",_xlfn.XLOOKUP($G46,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",2649)","v":""},""]
[null,null,null,"Baseboards",null,null,null,null,null,"Subtotal:",null,{"$f":"SUM(L48:L52)","v":0},null,null,null,null,null,null,""]
[null,null,null,{"$f":"IF($G48=\"\",\"\",2.5*(ROUNDUP(G8/16,0)))","v":""},null,{"$f":"IF($G48=\"\",\"\",\"each\")","v":""},{"$f":"IF($R48=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R48,Lookup_Table!B:B,Lookup_Table!E:E),$R48))","v":""},null,{"$f":"IF($G48=\"\",\"\",_xlfn.XLOOKUP($G48,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G48=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G48,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S48))","v":""},{"$f":"IF($G48=\"\",\"\",_xlfn.XLOOKUP($G48,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},{"$f":"IF($G48=\"\",\"\",$D48*$K48)","v":""},null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",253944)","v":""},""]
[null,null,null,{"$f":"IF($G49=\"\",\"\",2*G12)","v":""},null,"",{"$f":"IF($R49=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R49,Lookup_Table!B:B,Lookup_Table!E:E),$R49))","v":""},null,{"$f":"IF($G49=\"\",\"\",_xlfn.XLOOKUP($G49,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G49=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G49,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S49))","v":""},{"$f":"IF($G49=\"\",\"\",_xlfn.XLOOKUP($G49,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",12529)","v":""},""]
[null,null,null,{"$f":"IF($G50=\"\",\"\",2*2*(ROUNDUP(G8/16,0)))","v":""},null,"",{"$f":"IF($R50=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R50,Lookup_Table!B:B,Lookup_Table!E:E),$R50))","v":""},null,{"$f":"IF($G50=\"\",\"\",_xlfn.XLOOKUP($G50,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G50=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G50,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S50))","v":""},{"$f":"IF($G50=\"\",\"\",_xlfn.XLOOKUP($G50,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",2777)","v":""},""]
[null,null,null,{"$f":"IF($G51=\"\",\"\",D49+D50)","v":""},null,"",{"$f":"IF($R51=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R51,Lookup_Table!B:B,Lookup_Table!E:E),$R51))","v":""},null,{"$f":"IF($G51=\"\",\"\",_xlfn.XLOOKUP($G51,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G51=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G51,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S51))","v":""},{"$f":"IF($G51=\"\",\"\",_xlfn.XLOOKUP($G51,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",2977)","v":""},""]
[null,null,null,{"$f":"IF($G52=\"\",\"\",D49+D50)","v":""},null,"",{"$f":"IF($R52=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R52,Lookup_Table!B:B,Lookup_Table!E:E),$R52))","v":""},null,{"$f":"IF($G52=\"\",\"\",_xlfn.XLOOKUP($G52,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G52=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G52,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S52))","v":""},{"$f":"IF($G52=\"\",\"\",_xlfn.XLOOKUP($G52,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",2649)","v":""},""]
[null,null,null,"Covering",null,null,null,null,null,"Subtotal:",null,{"$f":"SUM(L54:L59)","v":0},null,null,null,null,null,null,""]
[null,null,null,{"$f":"IF($G54=\"\",\"\",IF(J54=\"Online sources\",\"\",1))","v":""},null,{"$f":"IF($G54=\"\",\"\",\"each\")","v":""},{"$f":"IF($R54=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R54,Lookup_Table!B:B,Lookup_Table!E:E),$R54))","v":""},null,{"$f":"IF($G54=\"\",\"\",_xlfn.XLOOKUP($G54,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G54=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G54,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S54))","v":""},{"$f":"IF($G54=\"\",\"\",_xlfn.XLOOKUP($G54,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},{"$f":"IF($G54=\"\",\"\",$D54*$K54)","v":""},null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(OR(G8=\"\",G9= \"\"),\"\", IF(G8<80,7301, IF(G8<105,7302,\"\"))))","v":""},""]
[null,null,null,{"$f":"IF($G55=\"\",\"\",ROUNDUP(W80/4,0))","v":""},null,"",{"$f":"IF($R55=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R55,Lookup_Table!B:B,Lookup_Table!E:E),$R55))","v":""},null,{"$f":"IF($G55=\"\",\"\",_xlfn.XLOOKUP($G55,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G55=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G55,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S55))","v":""},{"$f":"IF($G55=\"\",\"\",_xlfn.XLOOKUP($G55,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",7040)","v":""},""]
[null,null,null,{"$f":"IF($G56=\"\",\"\",ROUNDUP(V80/8,0))","v":""},null,"",{"$f":"IF($R56=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R56,Lookup_Table!B:B,Lookup_Table!E:E),$R56))","v":""},null,{"$f":"IF($G56=\"\",\"\",_xlfn.XLOOKUP($G56,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G56=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G56,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S56))","v":""},{"$f":"IF($G56=\"\",\"\",_xlfn.XLOOKUP($G56,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",7041)","v":""},""]
[null,null,null,{"$f":"IF($G57=\"\",\"\",IF(AND(D14=\"\",D15=\"\",A16=FALSE),4,IF(OR(B14=1,B14=2),ROUNDUP((D56*8+D73*10+D107*10)*1.1/100,0), IF(AND(OR(B14=3,B14=4), A16=FALSE),ROUNDUP((D56*8+D107*10)*1.1/100,0), IF(OR(B14=5,B14=6),ROUNDUP((D56*8+D73*10)*1.1/100,0),IF(OR(B14=7),ROUNDUP((D56*8)*1.1/100,0),IF(AND(OR(B14=3,B14=4), A16=TRUE),ROUNDUP((D56*8)*1.1/100,0),\"\")))))))","v":""},null,"",{"$f":"IF($R57=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R57,Lookup_Table!B:B,Lookup_Table!E:E),$R57))","v":""},null,{"$f":"IF($G57=\"\",\"\",_xlfn.XLOOKUP($G57,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G57=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G57,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S57))","v":""},{"$f":"IF($G57=\"\",\"\",_xlfn.XLOOKUP($G57,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",2525)","v":""},""]
[null,null,null,{"$f":"IF($G58=\"\",\"\",IF(G58=9724,ROUNDUP((G8+32)/250,0),\"\"))","v":""},null,"",{"$f":"IF($R58=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R58,Lookup_Table!B:B,Lookup_Table!E:E),$R58))","v":""},null,{"$f":"IF($G58=\"\",\"\",_xlfn.XLOOKUP($G58,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G58=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G58,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S58))","v":""},{"$f":"IF($G58=\"\",\"\",_xlfn.XLOOKUP($G58,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(AND(D21=\"x\",D22=\"\"),9724,\"\"))","v":""},""]
[null,null,null,{"$f":"IF($G59=\"\",\"\",IF(G59=9723,ROUNDUP(((G8+32))/500,0),\"\"))","v":""},null,"",{"$f":"IF($R59=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R59,Lookup_Table!B:B,Lookup_Table!E:E),$R59))","v":""},null,{"$f":"IF($G59=\"\",\"\",_xlfn.XLOOKUP($G59,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G59=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G59,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S59))","v":""},{"$f":"IF($G59=\"\",\"\",_xlfn.XLOOKUP($G59,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(AND(D21=\"x\",D22=\"\"),9723,\"\"))","v":""},""]
[null,null,null,"Scissor Door(s)",null,null,null,null,null,"Subtotal:",null,{"$f":"SUM(L61:L73)","v":0},null,null,null,null,null,null,""]
[null,null,null,{"$f":"IF($G61=\"\",\"\",IF(AND(OR(D14=1, D14=2),$A$16=FALSE),D14,\"\"))","v":""},null,{"$f":"IF($G61=\"\",\"\",\"each\")","v":""},{"$f":"IF($R61=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R61,Lookup_Table!B:B,Lookup_Table!E:E),$R61))","v":""},null,{"$f":"IF($G61=\"\",\"\",_xlfn.XLOOKUP($G61,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G61=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G61,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S61))","v":""},{"$f":"IF($G61=\"\",\"\",_xlfn.XLOOKUP($G61,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},{"$f":"IF($G61=\"\",\"\",$D61*$K61)","v":""},null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(AND(OR(D14=1, D14=2),$A$16=FALSE),161799,\"\"))","v":""},""]
[null,null,null,{"$f":"IF($G62=\"\",\"\",IF(OR(D14=1, D14=2),3*D14,\"\"))","v":""},null,"",{"$f":"IF($R62=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R62,Lookup_Table!B:B,Lookup_Table!E:E),$R62))","v":""},null,{"$f":"IF($G62=\"\",\"\",_xlfn.XLOOKUP($G62,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G62=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G62,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S62))","v":""},{"$f":"IF($G62=\"\",\"\",_xlfn.XLOOKUP($G62,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D14=1, D14=2),859,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G63=\"\",\"\",IF(OR(D14=1, D14=2),4*D14,\"\"))","v":""},null,"",{"$f":"IF($R63=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R63,Lookup_Table!B:B,Lookup_Table!E:E),$R63))","v":""},null,{"$f":"IF($G63=\"\",\"\",_xlfn.XLOOKUP($G63,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G63=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G63,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S63))","v":""},{"$f":"IF($G63=\"\",\"\",_xlfn.XLOOKUP($G63,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D14=1, D14=2),2662,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G64=\"\",\"\",IF(OR(D14=1, D14=2),2*D14,\"\"))","v":""},null,"",{"$f":"IF($R64=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R64,Lookup_Table!B:B,Lookup_Table!E:E),$R64))","v":""},null,{"$f":"IF($G64=\"\",\"\",_xlfn.XLOOKUP($G64,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G64=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G64,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S64))","v":""},{"$f":"IF($G64=\"\",\"\",_xlfn.XLOOKUP($G64,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D14=1, D14=2),3026,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G65=\"\",\"\",IF(OR(D14=1, D14=2),4*D14,\"\"))","v":""},null,"",{"$f":"IF($R65=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R65,Lookup_Table!B:B,Lookup_Table!E:E),$R65))","v":""},null,{"$f":"IF($G65=\"\",\"\",_xlfn.XLOOKUP($G65,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G65=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G65,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S65))","v":""},{"$f":"IF($G65=\"\",\"\",_xlfn.XLOOKUP($G65,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D14=1, D14=2),2691,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G66=\"\",\"\",IF(OR(D14=1, D14=2),4*D14,\"\"))","v":""},null,"",{"$f":"IF($R66=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R66,Lookup_Table!B:B,Lookup_Table!E:E),$R66))","v":""},null,{"$f":"IF($G66=\"\",\"\",_xlfn.XLOOKUP($G66,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G66=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G66,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S66))","v":""},{"$f":"IF($G66=\"\",\"\",_xlfn.XLOOKUP($G66,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D14=1, D14=2),2978,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G67=\"\",\"\",IF(OR(D14=1, D14=2),2*D14,\"\"))","v":""},null,"",{"$f":"IF($R67=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R67,Lookup_Table!B:B,Lookup_Table!E:E),$R67))","v":""},null,{"$f":"IF($G67=\"\",\"\",_xlfn.XLOOKUP($G67,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G67=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G67,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S67))","v":""},{"$f":"IF($G67=\"\",\"\",_xlfn.XLOOKUP($G67,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D14=1, D14=2),181697,\"\")))","v":""},"for scissor doors"]
[null,null,null,{"$f":"IF($G68=\"\",\"\",IF(OR(D14=1, D14=2),2*D14,\"\"))","v":""},null,"",{"$f":"IF($R68=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R68,Lookup_Table!B:B,Lookup_Table!E:E),$R68))","v":""},null,{"$f":"IF($G68=\"\",\"\",_xlfn.XLOOKUP($G68,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G68=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G68,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S68))","v":""},{"$f":"IF($G68=\"\",\"\",_xlfn.XLOOKUP($G68,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D14=1, D14=2),\"BB138\",\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G69=\"\",\"\",IF(OR(D14=1, D14=2),2*D14,\"\"))","v":""},null,"",{"$f":"IF($R69=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R69,Lookup_Table!B:B,Lookup_Table!E:E),$R69))","v":""},null,{"$f":"IF($G69=\"\",\"\",_xlfn.XLOOKUP($G69,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G69=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G69,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S69))","v":""},{"$f":"IF($G69=\"\",\"\",_xlfn.XLOOKUP($G69,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D14=1, D14=2),2753,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G70=\"\",\"\",IF(OR(D14=1, D14=2),2*D14,\"\"))","v":""},null,"",{"$f":"IF($R70=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R70,Lookup_Table!B:B,Lookup_Table!E:E),$R70))","v":""},null,{"$f":"IF($G70=\"\",\"\",_xlfn.XLOOKUP($G70,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G70=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G70,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S70))","v":""},{"$f":"IF($G70=\"\",\"\",_xlfn.XLOOKUP($G70,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D14=1, D14=2),2648,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G71=\"\",\"\",IF(OR(D14=1, D14=2),2*D14,\"\"))","v":""},null,"",{"$f":"IF($R71=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R71,Lookup_Table!B:B,Lookup_Table!E:E),$R71))","v":""},null,{"$f":"IF($G71=\"\",\"\",_xlfn.XLOOKUP($G71,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G71=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G71,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S71))","v":""},{"$f":"IF($G71=\"\",\"\",_xlfn.XLOOKUP($G71,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D14=1, D14=2),2977,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G72=\"\",\"\",IF(OR(D14=1, D14=2),D14,\"\"))","v":""},null,"",{"$f":"IF($R72=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R72,Lookup_Table!B:B,Lookup_Table!E:E),$R72))","v":""},null,{"$f":"IF($G72=\"\",\"\",_xlfn.XLOOKUP($G72,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G72=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G72,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S72))","v":""},{"$f":"IF($G72=\"\",\"\",_xlfn.XLOOKUP($G72,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D14=1, D14=2),654167,\"\")))","v":""},"",null,null,"Totals in feet"]
[null,null,null,{"$f":"IF($G73=\"\",\"\",IF(OR(D14=1, D14=2),D14,\"\"))","v":""},null,"",{"$f":"IF($R73=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R73,Lookup_Table!B:B,Lookup_Table!E:E),$R73))","v":""},null,{"$f":"IF($G73=\"\",\"\",_xlfn.XLOOKUP($G73,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G73=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G73,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S73))","v":""},{"$f":"IF($G73=\"\",\"\",_xlfn.XLOOKUP($G73,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D14=1, D14=2),7035,\"\")))","v":""},"for 1-3/8 in. Top-Rail",null,null,"Channel","Wire"]
[null,null,null,"End Wall(s) with Doors",null,null,null,null,null,"Subtotal:",null,{"$f":"SUM(L75:L102)","v":0},null,null,null,null,null,null,""]
[null,null,null,{"$f":"IF($G75=\"\",\"\",IF(AND(OR(D15=1, D15=2),$A$16=FALSE),D15,\"\"))","v":""},null,{"$f":"IF($G75=\"\",\"\",\"each\")","v":""},{"$f":"IF($R75=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R75,Lookup_Table!B:B,Lookup_Table!E:E),$R75))","v":""},null,{"$f":"IF($G75=\"\",\"\",_xlfn.XLOOKUP($G75,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G75=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G75,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S75))","v":""},{"$f":"IF($G75=\"\",\"\",_xlfn.XLOOKUP($G75,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},{"$f":"IF($G75=\"\",\"\",$D75*$K75)","v":""},null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1, D15=2),253942,\"\")))","v":""},"",null,null,{"$f":"G8*2+G9*4+16","v":16},{"$f":"V75","v":16}]
[null,null,null,{"$f":"IF($G76=\"\",\"\",IF(OR(D15=1, D15=2),2*D15,\"\"))","v":""},null,"",{"$f":"IF($R76=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R76,Lookup_Table!B:B,Lookup_Table!E:E),$R76))","v":""},null,{"$f":"IF($G76=\"\",\"\",_xlfn.XLOOKUP($G76,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G76=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G76,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S76))","v":""},{"$f":"IF($G76=\"\",\"\",_xlfn.XLOOKUP($G76,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1, D15=2),2779,\"\")))","v":""},"",null,null,{"$f":"(25+2*2-2*0.5-4*0.5)*2","v":52},{"$f":"2*V76","v":104}]
[null,null,null,{"$f":"IF($G77=\"\",\"\",IF(OR(D15=1, D15=2),2*D15,\"\"))","v":""},null,"",{"$f":"IF($R77=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R77,Lookup_Table!B:B,Lookup_Table!E:E),$R77))","v":""},null,{"$f":"IF($G77=\"\",\"\",_xlfn.XLOOKUP($G77,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G77=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G77,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S77))","v":""},{"$f":"IF($G77=\"\",\"\",_xlfn.XLOOKUP($G77,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1, D15=2),2780,\"\")))","v":""},"",null,"x",{"$f":"IF(ISTEXT(D14),0,D14*14)","v":0},{"$f":"V77","v":0}]
[null,null,null,{"$f":"IF($G78=\"\",\"\",IF(OR(D15=1, D15=2),4*D15,\"\"))","v":""},null,"",{"$f":"IF($R78=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R78,Lookup_Table!B:B,Lookup_Table!E:E),$R78))","v":""},null,{"$f":"IF($G78=\"\",\"\",_xlfn.XLOOKUP($G78,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G78=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G78,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S78))","v":""},{"$f":"IF($G78=\"\",\"\",_xlfn.XLOOKUP($G78,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1, D15=2),2784,\"\")))","v":""},"",null,null,{"$f":"(14+((85*2+82*4+24.5*4))/12)*IF(ISTEXT(D15),0,D15)","v":0},{"$f":"V78","v":0}]
[null,null,null,{"$f":"IF($G79=\"\",\"\",IF(OR(D15=1, D15=2),D76+D77+D78,\"\"))","v":""},null,"",{"$f":"IF($R79=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R79,Lookup_Table!B:B,Lookup_Table!E:E),$R79))","v":""},null,{"$f":"IF($G79=\"\",\"\",_xlfn.XLOOKUP($G79,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G79=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G79,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S79))","v":""},{"$f":"IF($G79=\"\",\"\",_xlfn.XLOOKUP($G79,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1, D15=2),2649,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G80=\"\",\"\",IF(OR(D15=1, D15=2),D76+D77+D78,\"\"))","v":""},null,"",{"$f":"IF($R80=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R80,Lookup_Table!B:B,Lookup_Table!E:E),$R80))","v":""},null,{"$f":"IF($G80=\"\",\"\",_xlfn.XLOOKUP($G80,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G80=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G80,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S80))","v":""},{"$f":"IF($G80=\"\",\"\",_xlfn.XLOOKUP($G80,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1, D15=2),2977,\"\")))","v":""},"",null,"x",{"$f":"V75+V76+IF(ISTEXT(D14),0,D14)*V77+IF(ISTEXT(D15),0,D15)*V78","v":68},{"$f":"W75+W76+IF(ISTEXT(D14),0,D14)*W77+IF(ISTEXT(D15),0,D15)*W78","v":120}]
[null,null,null,{"$f":"IF($G81=\"\",\"\",IF(OR(D15=1, D15=2),2*D15,\"\"))","v":""},null,"",{"$f":"IF($R81=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R81,Lookup_Table!B:B,Lookup_Table!E:E),$R81))","v":""},null,{"$f":"IF($G81=\"\",\"\",_xlfn.XLOOKUP($G81,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G81=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G81,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S81))","v":""},{"$f":"IF($G81=\"\",\"\",_xlfn.XLOOKUP($G81,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1, D15=2),161659,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G82=\"\",\"\",IF(OR(D15=1, D15=2),11*D15,\"\"))","v":""},null,"",{"$f":"IF($R82=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R82,Lookup_Table!B:B,Lookup_Table!E:E),$R82))","v":""},null,{"$f":"IF($G82=\"\",\"\",_xlfn.XLOOKUP($G82,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G82=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G82,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S82))","v":""},{"$f":"IF($G82=\"\",\"\",_xlfn.XLOOKUP($G82,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1, D15=2),161640,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G83=\"\",\"\",IF(OR(D15=1, D15=2),D15,\"\"))","v":""},null,"",{"$f":"IF($R83=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R83,Lookup_Table!B:B,Lookup_Table!E:E),$R83))","v":""},null,{"$f":"IF($G83=\"\",\"\",_xlfn.XLOOKUP($G83,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G83=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G83,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S83))","v":""},{"$f":"IF($G83=\"\",\"\",_xlfn.XLOOKUP($G83,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1, D15=2),914681,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G84=\"\",\"\",IF(OR(D15=1, D15=2),1,\"\"))","v":""},null,"",{"$f":"IF($R84=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R84,Lookup_Table!B:B,Lookup_Table!E:E),$R84))","v":""},null,{"$f":"IF($G84=\"\",\"\",_xlfn.XLOOKUP($G84,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G84=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G84,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S84))","v":""},{"$f":"IF($G84=\"\",\"\",_xlfn.XLOOKUP($G84,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1, D15=2),479652,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G85=\"\",\"\",IF(OR(D15=1, D15=2),3*D15,\"\"))","v":""},null,"",{"$f":"IF($R85=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R85,Lookup_Table!B:B,Lookup_Table!E:E),$R85))","v":""},null,{"$f":"IF($G85=\"\",\"\",_xlfn.XLOOKUP($G85,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G85=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G85,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S85))","v":""},{"$f":"IF($G85=\"\",\"\",_xlfn.XLOOKUP($G85,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1, D15=2),333431,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G86=\"\",\"\",IF(OR(D15=1, D15=2),1,\"\"))","v":""},null,"",{"$f":"IF($R86=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R86,Lookup_Table!B:B,Lookup_Table!E:E),$R86))","v":""},null,{"$f":"IF($G86=\"\",\"\",_xlfn.XLOOKUP($G86,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G86=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G86,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S86))","v":""},{"$f":"IF($G86=\"\",\"\",_xlfn.XLOOKUP($G86,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1, D15=2),134380,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G87=\"\",\"\",IF(OR(D15=1, D15=2),ROUNDUP(D15*16/25,0),\"\"))","v":""},null,"",{"$f":"IF($R87=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R87,Lookup_Table!B:B,Lookup_Table!E:E),$R87))","v":""},null,{"$f":"IF($G87=\"\",\"\",_xlfn.XLOOKUP($G87,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G87=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G87,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S87))","v":""},{"$f":"IF($G87=\"\",\"\",_xlfn.XLOOKUP($G87,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),301878333,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G88=\"\",\"\",IF(OR(D15=1, D15=2),2*D15,\"\"))","v":""},null,"",{"$f":"IF($R88=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R88,Lookup_Table!B:B,Lookup_Table!E:E),$R88))","v":""},null,{"$f":"IF($G88=\"\",\"\",_xlfn.XLOOKUP($G88,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G88=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G88,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S88))","v":""},{"$f":"IF($G88=\"\",\"\",_xlfn.XLOOKUP($G88,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),335216,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G89=\"\",\"\",IF(OR(D15=1, D15=2),D15,\"\"))","v":""},null,"",{"$f":"IF($R89=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R89,Lookup_Table!B:B,Lookup_Table!E:E),$R89))","v":""},null,{"$f":"IF($G89=\"\",\"\",_xlfn.XLOOKUP($G89,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G89=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G89,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S89))","v":""},{"$f":"IF($G89=\"\",\"\",_xlfn.XLOOKUP($G89,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),320858,\"\")))","v":""},"for baseboard posts"]
[null,null,null,{"$f":"IF($G90=\"\",\"\",IF(OR(D15=1, D15=2),4*D15,\"\"))","v":""},null,"",{"$f":"IF($R90=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R90,Lookup_Table!B:B,Lookup_Table!E:E),$R90))","v":""},null,{"$f":"IF($G90=\"\",\"\",_xlfn.XLOOKUP($G90,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G90=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G90,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S90))","v":""},{"$f":"IF($G90=\"\",\"\",_xlfn.XLOOKUP($G90,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),208229,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G91=\"\",\"\",IF(OR(D15=1, D15=2),8*D15,\"\"))","v":""},null,"",{"$f":"IF($R91=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R91,Lookup_Table!B:B,Lookup_Table!E:E),$R91))","v":""},null,{"$f":"IF($G91=\"\",\"\",_xlfn.XLOOKUP($G91,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G91=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G91,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S91))","v":""},{"$f":"IF($G91=\"\",\"\",_xlfn.XLOOKUP($G91,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),461393,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G92=\"\",\"\",IF(OR(D15=1, D15=2),4*D15,\"\"))","v":""},null,"",{"$f":"IF($R92=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R92,Lookup_Table!B:B,Lookup_Table!E:E),$R92))","v":""},null,{"$f":"IF($G92=\"\",\"\",_xlfn.XLOOKUP($G92,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G92=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G92,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S92))","v":""},{"$f":"IF($G92=\"\",\"\",_xlfn.XLOOKUP($G92,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),711786,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G93=\"\",\"\",IF(OR(D15=1, D15=2),1,\"\"))","v":""},null,"",{"$f":"IF($R93=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R93,Lookup_Table!B:B,Lookup_Table!E:E),$R93))","v":""},null,{"$f":"IF($G93=\"\",\"\",_xlfn.XLOOKUP($G93,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G93=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G93,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S93))","v":""},{"$f":"IF($G93=\"\",\"\",_xlfn.XLOOKUP($G93,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),9604,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G94=\"\",\"\",IF(OR(D15=1, D15=2),ROUNDUP(8*D15/4,0),\"\"))","v":""},null,"",{"$f":"IF($R94=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R94,Lookup_Table!B:B,Lookup_Table!E:E),$R94))","v":""},null,{"$f":"IF($G94=\"\",\"\",_xlfn.XLOOKUP($G94,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G94=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G94,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S94))","v":""},{"$f":"IF($G94=\"\",\"\",_xlfn.XLOOKUP($G94,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),292141,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G95=\"\",\"\",IF(OR(D15=1, D15=2),2*D15,\"\"))","v":""},null,"",{"$f":"IF($R95=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R95,Lookup_Table!B:B,Lookup_Table!E:E),$R95))","v":""},null,{"$f":"IF($G95=\"\",\"\",_xlfn.XLOOKUP($G95,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G95=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G95,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S95))","v":""},{"$f":"IF($G95=\"\",\"\",_xlfn.XLOOKUP($G95,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),117741,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G96=\"\",\"\",IF(OR(D15=1, D15=2),2*D15,\"\"))","v":""},null,"",{"$f":"IF($R96=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R96,Lookup_Table!B:B,Lookup_Table!E:E),$R96))","v":""},null,{"$f":"IF($G96=\"\",\"\",_xlfn.XLOOKUP($G96,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G96=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G96,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S96))","v":""},{"$f":"IF($G96=\"\",\"\",_xlfn.XLOOKUP($G96,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),240664,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G97=\"\",\"\",IF(OR(D15=1, D15=2),2*D15,\"\"))","v":""},null,"",{"$f":"IF($R97=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R97,Lookup_Table!B:B,Lookup_Table!E:E),$R97))","v":""},null,{"$f":"IF($G97=\"\",\"\",_xlfn.XLOOKUP($G97,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G97=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G97,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S97))","v":""},{"$f":"IF($G97=\"\",\"\",_xlfn.XLOOKUP($G97,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),120583,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G98=\"\",\"\",IF(OR(D15=1, D15=2),1,\"\"))","v":""},null,"",{"$f":"IF($R98=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R98,Lookup_Table!B:B,Lookup_Table!E:E),$R98))","v":""},null,{"$f":"IF($G98=\"\",\"\",_xlfn.XLOOKUP($G98,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G98=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G98,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S98))","v":""},{"$f":"IF($G98=\"\",\"\",_xlfn.XLOOKUP($G98,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),879282,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G99=\"\",\"\",IF(OR(D15=1, D15=2),D15,\"\"))","v":""},null,"",{"$f":"IF($R99=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R99,Lookup_Table!B:B,Lookup_Table!E:E),$R99))","v":""},null,{"$f":"IF($G99=\"\",\"\",_xlfn.XLOOKUP($G99,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G99=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G99,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S99))","v":""},{"$f":"IF($G99=\"\",\"\",_xlfn.XLOOKUP($G99,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),671223,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G100=\"\",\"\",IF(OR(D15=1, D15=2),4*D15,\"\"))","v":""},null,"",{"$f":"IF($R100=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R100,Lookup_Table!B:B,Lookup_Table!E:E),$R100))","v":""},null,{"$f":"IF($G100=\"\",\"\",_xlfn.XLOOKUP($G100,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G100=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G100,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S100))","v":""},{"$f":"IF($G100=\"\",\"\",_xlfn.XLOOKUP($G100,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),7242,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G101=\"\",\"\",IF(OR(D15=1, D15=2),2*D15,\"\"))","v":""},null,"",{"$f":"IF($R101=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R101,Lookup_Table!B:B,Lookup_Table!E:E),$R101))","v":""},null,{"$f":"IF($G101=\"\",\"\",_xlfn.XLOOKUP($G101,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G101=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G101,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S101))","v":""},{"$f":"IF($G101=\"\",\"\",_xlfn.XLOOKUP($G101,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(A16=TRUE,\"\",IF(OR(D15=1,D15=2),2978,\"\")))","v":""},""]
[null,null,null,{"$f":"IF($G102=\"\",\"\",IF(OR(D15=1, D15=2),2*D15,\"\"))","v":""},null,"",{"$f":"IF($R102=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R102,Lookup_Table!B:B,Lookup_Table!E:E),$R102))","v":""},null,{"$f":"IF($G102=\"\",\"\",_xlfn.XLOOKUP($G102,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G102=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G102,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S102))","v":""},{"$f":"IF($G102=\"\",\"\",_xlfn.XLOOKUP($G102,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(ISTEXT(D15),\"\",IF(AND(OR(D15=1, D15=2),$A$16=FALSE),9673.5,\"\")))","v":""},""]
[null,null,null,"Roll-up Sides",null,null,null,null,null,"Subtotal:",null,{"$f":"SUM(L104:L109)","v":0},null,null,null,null,null,null,""]
[null,null,null,{"$f":"IF($G104=\"\",\"\",IF(AND(D18=\"x\",D19=\"\"),ROUNDUP(G8*2/10,0)+5,\"\"))","v":""},null,{"$f":"IF($G104=\"\",\"\",\"each\")","v":""},{"$f":"IF($R104=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R104,Lookup_Table!B:B,Lookup_Table!E:E),$R104))","v":""},null,{"$f":"IF($G104=\"\",\"\",_xlfn.XLOOKUP($G104,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G104=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G104,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S104))","v":""},{"$f":"IF($G104=\"\",\"\",_xlfn.XLOOKUP($G104,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},{"$f":"IF($G104=\"\",\"\",$D104*$K104)","v":""},null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(AND(D18=\"x\",D19=\"\"),203114,\"\"))","v":""},"for roll-up sides"]
[null,null,null,{"$f":"IF($G105=\"\",\"\",IF(AND(D18=\"x\",D19=\"\"),ROUNDUP(D104/5,0),0))","v":""},null,"",{"$f":"IF($R105=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R105,Lookup_Table!B:B,Lookup_Table!E:E),$R105))","v":""},null,{"$f":"IF($G105=\"\",\"\",_xlfn.XLOOKUP($G105,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G105=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G105,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S105))","v":""},{"$f":"IF($G105=\"\",\"\",_xlfn.XLOOKUP($G105,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(AND(D18=\"x\",D19=\"\"),403636,\"\"))","v":""},"for roll-ups"]
[null,null,null,{"$f":"IF($G106=\"\",\"\",IF(AND(D18=\"x\",D19=\"\"),2,\"\"))","v":""},null,"",{"$f":"IF($R106=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R106,Lookup_Table!B:B,Lookup_Table!E:E),$R106))","v":""},null,{"$f":"IF($G106=\"\",\"\",_xlfn.XLOOKUP($G106,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G106=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G106,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S106))","v":""},{"$f":"IF($G106=\"\",\"\",_xlfn.XLOOKUP($G106,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(AND(D18=\"x\",D19=\"\"),7033,\"\"))","v":""},""]
[null,null,null,{"$f":"IF($G107=\"\",\"\",IF(AND(D18=\"x\",D19=\"\"),ROUNDUP(G8/10,0),\"\"))","v":""},null,"",{"$f":"IF($R107=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R107,Lookup_Table!B:B,Lookup_Table!E:E),$R107))","v":""},null,{"$f":"IF($G107=\"\",\"\",_xlfn.XLOOKUP($G107,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G107=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G107,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S107))","v":""},{"$f":"IF($G107=\"\",\"\",_xlfn.XLOOKUP($G107,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(AND(D18=\"x\",D19=\"\"),9150,\"\"))","v":""},"for ¾ in. EMT"]
[null,null,null,{"$f":"IF($G108=\"\",\"\",IF(AND(D18=\"x\",D19=\"\"),ROUNDUP(4*G8/1000,0),\"\"))","v":""},null,"",{"$f":"IF($R108=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R108,Lookup_Table!B:B,Lookup_Table!E:E),$R108))","v":""},null,{"$f":"IF($G108=\"\",\"\",_xlfn.XLOOKUP($G108,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G108=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G108,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S108))","v":""},{"$f":"IF($G108=\"\",\"\",_xlfn.XLOOKUP($G108,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(AND(D18=\"x\",D19=\"\"),\"550C-WHT1000\",\"\"))","v":""},"for lacing"]
[null,null,null,{"$f":"IF($G109=\"\",\"\",IF(AND(D18=\"x\",D19=\"\"),ROUNDUP((2*G12+8)/25,0),\"\"))","v":""},null,"",{"$f":"IF($R109=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($R109,Lookup_Table!B:B,Lookup_Table!E:E),$R109))","v":""},null,{"$f":"IF($G109=\"\",\"\",_xlfn.XLOOKUP($G109,Lookup_Table!$B:$B,Lookup_Table!C:C))","v":""},{"$f":"IF($G109=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($G109,Lookup_Table!$B:$B,Lookup_Table!D:D),\" \",$S109))","v":""},{"$f":"IF($G109=\"\",\"\",_xlfn.XLOOKUP($G109,Lookup_Table!$B:$B,Lookup_Table!$A:$A))","v":""},"",null,null,null,null,null,{"$f":"IF(OR($G$8=\"\",$G$8=0,$G$9=\"\",$G$9=0),\"\",IF(AND(D18=\"x\",D19=\"\"),727401,\"\"))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(L26+L29+L42+L47+L53+L60+L74+L103)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"(PRICING: SEP25)"]
[null,null,null,"© JOHNNY SELECTED SEEDS.   ALL RIGHTS RESERVED.   |  955 BENTON AVENUE   WINSLOW   MAINE   04901"]
[null,null,null,"JOHNNY'S SELECTED SEEDS IS A PRIVATELY HELD, EMPLOYEE-OWNED COMPANY."]