{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Lookup_Table","Itemized Listing"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":0,"defined_names":2,"comments":0,"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":121,"n_cols":5,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
["Price","Item #","Table20.Brand","Table20.Description","Table20.Link"]
[120,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"]
[99,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.9499999999999993,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"]
[21.97,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.75,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"]
[28.77,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"]
[21.57,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,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"]
[269,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"]
[329,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"]
[379,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"]
[207,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"]
[491,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.68,2032,"www.boltdepot.com","#10 x 4 in. wood screw","https://boltdepot.com/Product-Details?product=2032"]
[440,7302,"Johnny's Selected Seeds","Tufflite IV™ – 32' x 125'","https://www.johnnyseeds.com/tools-supplies/greenhouse-and-tunnel-supplies/greenhouse-film/tufflite/tufflite-iv-32-x-125-greenhouse-film-7302.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"]
[107.1,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"]
[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"]
[8.5,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"]
[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"]
[37.75,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"]
[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"]
[6.25,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"]
[0.12,2624,"www.boltdepot.com","1/4 -20 nylock lock nut","https://boltdepot.com/Product-Details?product=2624"]
[37.950000000000003,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.06,2648,"www.boltdepot.com","1/4 in. hex nut","https://boltdepot.com/Product-Details?product=2648"]
[186,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"]
[345,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"]
[219,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"]
[335.7,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"]
[79,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"]
[225,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"]
[123,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"]
[0.09,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.08,2662,"www.boltdepot.com","3/8 in. hex jam nut","https://boltdepot.com/Product-Details?product=2662"]
[0.25,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.15,2753,"www.boltdepot.com","1/4 in. x 1.75 in. carriage bolt","https://boltdepot.com/Product-Details?product=2753"]
[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"]
[3.65,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"]
[26.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"]
[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"]
[0.1,2650,"www.boltdepot.com","Hex nuts, Zinc plated steel, 3/8\"-16","https://boltdepot.com/Product-Details?product=2650"]
[3.18,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"]
[4.7300000000000004,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"]
[10.84,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"]
[6.98,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"]
[11.78,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"]
[4.47,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"]
[57,"550C-WHT1000","The Paracord Store","White 550 Paracord","https://theparacordstore.com/products/white-paracord?variant=42776164499607"]
[10.76,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"]
[12.48,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.55,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.64,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"]
[4.9800000000000004,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"]
[30.89,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"]
[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"]
[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"]
[4.5,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"]
[2.98,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"]
[3.28,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"]
[20.420000000000002,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"]
[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"]
[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"]
[6.12,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"]
[39.479999999999997,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"]
[14.68,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"]
[0.98,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"]
[12.58,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"]
[18.68,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"]
[0.88,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"]
[10.93,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"]
[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"]
[18.68,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.8699999999999992,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"]
[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"]
[7.28,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"]
[0.88,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"]
[1.28,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"]
[36.97,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"]
[6.28,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"]
[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"]
[12.67,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.41,2780,"www.boltdepot.com","Carriage bolts, Zinc plated steel, 5/16\"-18 x 4\"","https://boltdepot.com/Product-Details?product=2780"]
[0.63,2784,"www.boltdepot.com","Carriage bolts, Zinc plated steel, 5/16\"-18 x 6\"","https://boltdepot.com/Product-Details?product=2784"]
[0.49,"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.05,2977,"www.boltdepot.com","5/16\" flat washers","https://boltdepot.com/Product-Details?product=2977"]
[0.44109999999999999,"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.08,3025,"www.boltdepot.com","5/16\" lock washers","https://boltdepot.com/Product-Details?product=3025"]
[0.315,"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.18509999999999999,"CB51614HDG","Chain Link Fittings","Chain Link 5/16\" x 1 1/4\" Carriage Bolt & Nut","https://chainlinkfittings.com/store/carriage-bolts-with-nut.html"]
[1.25,"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"]
[1.4750000000000001,"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.06,2978,"www.boltdepot.com","SAE flat washers, Zinc plated steel, 3/8\"","https://boltdepot.com/Product-Details?product=2978"]
[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"]
[9.4499999999999993,7783,"www.boltdepot.com","#7 x 1.25 in. wood screw, box of 100","https://boltdepot.com/Product-Details?product=7783"]
[1.3,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.9,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":94,"n_cols":16,"rows_kept":94,"cut":false,"hidden":false,"merged":[[85,3,85,4],[84,3,84,4],[86,3,86,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[58,3,58,4],[59,3,59,4],[79,3,79,4],[57,3,57,4],[69,3,69,4],[70,3,70,4],[83,3,83,4],[73,1,73,5],[62,3,62,4],[63,3,63,4],[64,3,64,4],[65,3,65,4],[73,6,73,7],[82,1,82,5],[82,6,82,7],[76,3,76,4],[77,3,77,4],[78,3,78,4],[80,3,80,4],[81,3,81,4],[75,3,75,4],[74,3,74,4],[71,3,71,4],[67,3,67,4],[68,3,68,4],[52,6,52,7],[52,1,52,5],[61,6,61,7],[45,3,45,4],[23,6,24,6],[28,6,28,7],[48,3,48,4],[53,3,53,4],[60,3,60,4],[35,3,35,4],[36,3,36,4],[33,3,33,4],[34,3,34,4],[39,3,39,4],[51,3,51,4],[47,6,47,7],[87,3,87,4],[49,3,49,4],[50,3,50,4],[72,3,72,4],[29,3,29,4],[42,3,42,4],[41,3,41,4],[44,3,44,4],[30,3,30,4],[31,1,31,5],[47,1,47,5],[40,3,40,4],[43,3,43,4],[46,3,46,4],[61,1,61,5],[66,3,66,4],[37,3,37,4],[38,3,38,4],[16,1,16,4],[15,1,15,4],[21,1,21,5],[20,1,20,5],[19,1,19,5],[17,1,17,4],[19,6,21,6],[15,6,17,6],[27,3,27,4],[32,3,32,4],[28,1,28,5],[93,0,93,10],[92,0,92,10],[31,6,31,7],[1,1,1,9],[13,3,13,4],[4,1,4,8],[2,1,2,8],[8,1,8,2],[10,1,10,2],[3,1,3,8],[6,1,6,4],[9,1,9,2],[13,1,13,2],[12,1,12,2],[12,5,12,8],[12,3,12,4]]}
[]
[]
[null,"Quick Hoops Stationary Traditional 12-ft-Wide High Tunnel Calculator"]
[null,"***Fill in the items below and the calculator will do the rest.***"]
[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,"Dimensions, Spec's",null,null,null,null,null,"Square Feet",{"$f":"12*D9","v":0}]
[]
[null,"Length",null,null,"feet",null,null,"Cost / Sq. Ft.",{"$f":"IFERROR(I90/I7,0)","v":0},null,null,null,null,null,{"$f":"_xlfn._xlws.FILTER(_xlfn.SEQUENCE(3,,4),MOD($D$9/_xlfn.SEQUENCE(3,,4),1)=0=TRUE,\"Length must be divisable by 4,5 or 6\")","v":4}]
[null,"Spacing",null,null,"feet",null,null,null,null,null,null,null,null,null,5]
[null,"Grnd Posts",null,null,"feet",null,null,null,null,null,null,null,null,null,6]
[]
[null,"# Segments",null,{"$f":"IFERROR(D9/D10,\"\")","v":""},null,{"$f":"IF(D11=3,\"\",IF(D11=4,\"\", IF(D11=\"\",\"\",\"***Please enter only 3 or 4 for Ground Post Height.***\")))","v":""}]
[null,"# Bows",null,{"$f":"IF($D$13=\"\",\"\",D13+1)","v":""}]
[]
[null,{"$f":"IF($A$17=1,\"x\",\"\")","v":"x"}]
[1,{"$f":"IF($A$17=2,\"x\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF($A$17=3,\"x\",\"\")","v":""}]
[]
[null,{"$f":"IF($A$21=1,\"x\",\"\")","v":"x"}]
[1,{"$f":"IF($A$21=3,\"x\",\"\")","v":""}]
[null,{"$f":"IF($A$21=2,\"x\",\"\")","v":""}]
[]
[null,null," # Cable Purlins for Trellising",null,null,null,{"$f":"IF(B24=\"x\",\"Enter the quantity of Cable Purlins you would like\n(e.g.: 1, 2, or 3), or select No Purlins.\", IF(AND(B24>0, B25=FALSE),\"\", IF(AND(B24=\"\",B25=TRUE),\"\", \"Enter the quantity of Cable Purlins you would like\n(e.g.: 1, 2, or 3), or select No Purlins.\")))","v":"Enter the quantity of Cable Purlins you would like\n(e.g.: 1, 2, or 3), or select No Purlins."}]
[null,false," No Purlins"]
[]
[]
[null,"Qty","Unit","Part#",null,"Vendor","Description","Price","Ext"]
[null,"Special Tools",null,null,null,null,"Subtotal:",null,{"$f":"SUM(I30:I31)","v":0}]
[null,{"$f":"IF($I$7=0,\"\",1)","v":""},{"$f":"IF($I$7=0,\"\",\"each\")","v":""},{"$f":"IF($O30=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O30,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O30))","v":""},null,{"$f":"IF(D30=\"\",\"\",_xlfn.XLOOKUP($D30,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D30=\"\",\"\",_xlfn.XLOOKUP($D30,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D30=\"\",\"\",_xlfn.XLOOKUP($D30,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H30=\"\",\"\",B30*H30)","v":""},null,null,null,null,null,{"$f":"IF(I7=0,\"\",9018)","v":""}]
[null,{"$f":"IF($I$7=0,\"\",1)","v":""},{"$f":"IF($I$7=0,\"\",\"each\")","v":""},{"$f":"IF($O31=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O31,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O31))","v":""},null,{"$f":"IF(D31=\"\",\"\",_xlfn.XLOOKUP($D31,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D31=\"\",\"\",_xlfn.XLOOKUP($D31,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D31=\"\",\"\",_xlfn.XLOOKUP($D31,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(B31=\"\",\"\", B31*H31)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",9482)","v":""}]
[null,"Frame Components",null,null,null,null,"Subtotal:",null,{"$f":"SUM(I33:I47)","v":0}]
[null,{"$f":"IF(OR($I$7=0,$D$10=\"\"),\"\",D9*2/D10+2)","v":""},{"$f":"IF(B33=\"\",\"\",\"each\")","v":""},{"$f":"IF($O33=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O33,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O33))","v":""},null,{"$f":"IF(D33=\"\",\"\",_xlfn.XLOOKUP($D33,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D33=\"\",\"\",_xlfn.XLOOKUP($D33,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D33=\"\",\"\",_xlfn.XLOOKUP($D33,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(B33=\"\",\"\", B33*H33)","v":""},null,null,null,null,null,{"$f":"IF(OR($I$7=0,$D$10=\"\"),\"\",181697)","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(B16=\"x\",ROUNDUP(D9/10+0.5,0),ROUNDUP(D9/10,0)))","v":""},{"$f":"IF(B34=\"\",\"\",\"each\")","v":""},{"$f":"IF($O34=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O34,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O34))","v":""},null,{"$f":"IF(D34=\"\",\"\",_xlfn.XLOOKUP($D34,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D34=\"\",\"\",_xlfn.XLOOKUP($D34,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D34=\"\",\"\",_xlfn.XLOOKUP($D34,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",181697)","v":""}]
[null,{"$f":"IF(OR($I$7=0,$D$10=\"\",$D$11=\"\"),\"\",B33/2)","v":""},"",{"$f":"IF($O35=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O35,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O35))","v":""},null,{"$f":"IF(D35=\"\",\"\",_xlfn.XLOOKUP($D35,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D35=\"\",\"\",_xlfn.XLOOKUP($D35,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D35=\"\",\"\",_xlfn.XLOOKUP($D35,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(D11=3,320858, IF(D11=4,623105,\"\")))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",ROUNDUP(D14/2,0))","v":""},"",{"$f":"IF($O36=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O36,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O36))","v":""},null,{"$f":"IF(D36=\"\",\"\",_xlfn.XLOOKUP($D36,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D36=\"\",\"\",_xlfn.XLOOKUP($D36,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D36=\"\",\"\",_xlfn.XLOOKUP($D36,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",9542)","v":""}]
[null,{"$f":"IF($I$7=0,\"\",ROUNDUP(2.1*D14/100,0))","v":""},"",{"$f":"IF($O37=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O37,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O37))","v":""},null,{"$f":"IF(D37=\"\",\"\",_xlfn.XLOOKUP($D37,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D37=\"\",\"\",_xlfn.XLOOKUP($D37,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D37=\"\",\"\",_xlfn.XLOOKUP($D37,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",2405)","v":""}]
[null,{"$f":"IF($I$7=0,\"\",2*D14)","v":""},"",{"$f":"IF($O38=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O38,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O38))","v":""},null,{"$f":"IF(D38=\"\",\"\",_xlfn.XLOOKUP($D38,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D38=\"\",\"\",_xlfn.XLOOKUP($D38,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D38=\"\",\"\",_xlfn.XLOOKUP($D38,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",12529)","v":""}]
[null,{"$f":"IF($I$7=0,\"\",B38)","v":""},"",{"$f":"IF($O39=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O39,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O39))","v":""},null,{"$f":"IF(D39=\"\",\"\",_xlfn.XLOOKUP($D39,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D39=\"\",\"\",_xlfn.XLOOKUP($D39,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D39=\"\",\"\",_xlfn.XLOOKUP($D39,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",2649)","v":""}]
[null,{"$f":"IF($I$7=0,\"\",B38)","v":""},"",{"$f":"IF($O40=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O40,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O40))","v":""},null,{"$f":"IF(D40=\"\",\"\",_xlfn.XLOOKUP($D40,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D40=\"\",\"\",_xlfn.XLOOKUP($D40,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D40=\"\",\"\",_xlfn.XLOOKUP($D40,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",3025)","v":""}]
[null,{"$f":"IF($I$7=0,\"\",B38)","v":""},"",{"$f":"IF($O41=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O41,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O41))","v":""},null,{"$f":"IF(D41=\"\",\"\",_xlfn.XLOOKUP($D41,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D41=\"\",\"\",_xlfn.XLOOKUP($D41,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D41=\"\",\"\",_xlfn.XLOOKUP($D41,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(B41=\"\",\"\", B41*H41)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",2977)","v":""}]
[null,{"$f":"IF($I$7=0,\"\",4*ROUNDUP(D9/14,0))","v":""},"",{"$f":"IF($O42=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O42,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O42))","v":""},null,{"$f":"IF(D42=\"\",\"\",_xlfn.XLOOKUP($D42,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D42=\"\",\"\",_xlfn.XLOOKUP($D42,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D42=\"\",\"\",_xlfn.XLOOKUP($D42,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(B42=\"\",\"\", B42*H42)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",732050)","v":""}]
[null,{"$f":"IF($I$7=0,\"\",2*D14)","v":""},"",{"$f":"IF($O43=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O43,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O43))","v":""},null,{"$f":"IF(D43=\"\",\"\",_xlfn.XLOOKUP($D43,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D43=\"\",\"\",_xlfn.XLOOKUP($D43,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D43=\"\",\"\",_xlfn.XLOOKUP($D43,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(B43=\"\",\"\", B43*H43)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",2760)","v":""}]
[null,{"$f":"IF($I$7=0,\"\",B43)","v":""},"",{"$f":"IF($O44=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O44,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O44))","v":""},null,{"$f":"IF(D44=\"\",\"\",_xlfn.XLOOKUP($D44,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D44=\"\",\"\",_xlfn.XLOOKUP($D44,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D44=\"\",\"\",_xlfn.XLOOKUP($D44,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H44=\"\",\"\",B44*H44)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",2648)","v":""}]
[null,{"$f":"IF($I$7=0,\"\",ROUNDUP(8*B42/100,0))","v":""},"",{"$f":"IF($O45=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O45,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O45))","v":""},null,{"$f":"IF(D45=\"\",\"\",_xlfn.XLOOKUP($D45,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D45=\"\",\"\",_xlfn.XLOOKUP($D45,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D45=\"\",\"\",_xlfn.XLOOKUP($D45,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H45=\"\",\"\",B45*H45)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",7783)","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(D11=4,D14*2,\"\"))","v":""},"",{"$f":"IF($O46=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O46,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O46))","v":""},null,{"$f":"IF(D46=\"\",\"\",_xlfn.XLOOKUP($D46,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D46=\"\",\"\",_xlfn.XLOOKUP($D46,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D46=\"\",\"\",_xlfn.XLOOKUP($D46,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(B46=\"\",\"\", B46*H46)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(D11=4,199,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",B46)","v":""},"",{"$f":"IF($O47=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O47,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O47))","v":""},null,{"$f":"IF(D47=\"\",\"\",_xlfn.XLOOKUP($D47,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D47=\"\",\"\",_xlfn.XLOOKUP($D47,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D47=\"\",\"\",_xlfn.XLOOKUP($D47,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(B47=\"\",\"\", B47*H47)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(D11=4,2624,\"\"))","v":""}]
[null,"Covering",null,null,null,null,"Subtotal:",null,{"$f":"SUM(I49:I52)","v":0}]
[null,{"$f":"IF($I$7=0,\"\",IF(OR(G49=\"\",G49=\"Online Sources\"),\"\",1))","v":""},{"$f":"IF(B49=\"\",\"\",\"each\")","v":""},{"$f":"IF($O49=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O49,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O49))","v":""},null,{"$f":"IF(D49=\"\",\"\",_xlfn.XLOOKUP($D49,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D49=\"\",\"\",_xlfn.XLOOKUP($D49,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D49=\"\",\"\",_xlfn.XLOOKUP($D49,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(B49=\"\",\"\", B49*H49)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(OR(D9=\"\", D11=\"\"),\"\", IF(AND(D9<51,D11=3),9645, IF(AND(D9<51,D11=4),7176, IF(AND(D9<76,D11=4),7177, IF(AND(D9<101,D11=3),9701, IF(AND(D9<101,D11=4),7178,””)))))))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(B51>0,ROUNDUP((B51*2+6),0)))","v":""},"",{"$f":"IF($O50=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O50,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O50))","v":""},null,{"$f":"IF(D50=\"\",\"\",_xlfn.XLOOKUP($D50,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D50=\"\",\"\",_xlfn.XLOOKUP($D50,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D50=\"\",\"\",_xlfn.XLOOKUP($D50,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H50=\"\",\"\",B50*H50)","v":""},null,null,"Bows","Knee Rails","Sides",{"$f":"IF($I$7=0,\"\",7040)","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"X\",B18=\"\"),ROUNDUP((D9*2+24*2+1)/8,0),ROUNDUP((D9*2+1)/8,0)))","v":""},"",{"$f":"IF($O51=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O51,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O51))","v":""},null,{"$f":"IF(D51=\"\",\"\",_xlfn.XLOOKUP($D51,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D51=\"\",\"\",_xlfn.XLOOKUP($D51,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D51=\"\",\"\",_xlfn.XLOOKUP($D51,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H51=\"\",\"\",B51*H51)","v":""},null,null,{"$f":"D8*25*2","v":0},{"$f":"15*2","v":30},{"$f":"D8*16*2","v":0},{"$f":"IF($I$7=0,\"\",7041)","v":""}]
[null,{"$f":"IF($I$7=0,\"\",ROUNDUP((B51*8/1.5)/86,0))","v":""},"",{"$f":"IF($O52=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O52,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O52))","v":""},null,{"$f":"IF(D52=\"\",\"\",_xlfn.XLOOKUP($D52,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D52=\"\",\"\",_xlfn.XLOOKUP($D52,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D52=\"\",\"\",_xlfn.XLOOKUP($D52,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H52=\"\",\"\",B52*H52)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",2520)","v":""}]
[null,"Scissor Doors",null,null,null,null,"Subtotal:",null,{"$f":"SUM(I54:I61)","v":0}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),5,\"\"))","v":""},{"$f":"IF(B54=\"\",\"\",\"each\")","v":""},{"$f":"IF($O54=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O54,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O54))","v":""},null,{"$f":"IF(D54=\"\",\"\",_xlfn.XLOOKUP($D54,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D54=\"\",\"\",_xlfn.XLOOKUP($D54,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D54=\"\",\"\",_xlfn.XLOOKUP($D54,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H54=\"\",\"\",B54*H54)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),181697,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),4,\"\"))","v":""},"",{"$f":"IF($O55=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O55,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O55))","v":""},null,{"$f":"IF(D55=\"\",\"\",_xlfn.XLOOKUP($D55,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D55=\"\",\"\",_xlfn.XLOOKUP($D55,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D55=\"\",\"\",_xlfn.XLOOKUP($D55,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),\"BB138\",\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),4,\"\"))","v":""},"",{"$f":"IF($O56=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O56,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O56))","v":""},null,{"$f":"IF(D56=\"\",\"\",_xlfn.XLOOKUP($D56,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D56=\"\",\"\",_xlfn.XLOOKUP($D56,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D56=\"\",\"\",_xlfn.XLOOKUP($D56,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),2753,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),4,\"\"))","v":""},"",{"$f":"IF($O57=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O57,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O57))","v":""},null,{"$f":"IF(D57=\"\",\"\",_xlfn.XLOOKUP($D57,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D57=\"\",\"\",_xlfn.XLOOKUP($D57,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D57=\"\",\"\",_xlfn.XLOOKUP($D57,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),2648,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),2,\"\"))","v":""},"",{"$f":"IF($O58=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O58,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O58))","v":""},null,{"$f":"IF(D58=\"\",\"\",_xlfn.XLOOKUP($D58,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D58=\"\",\"\",_xlfn.XLOOKUP($D58,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D58=\"\",\"\",_xlfn.XLOOKUP($D58,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),7035,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),2,\"\"))","v":""},"",{"$f":"IF($O59=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O59,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O59))","v":""},null,{"$f":"IF(D59=\"\",\"\",_xlfn.XLOOKUP($D59,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D59=\"\",\"\",_xlfn.XLOOKUP($D59,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D59=\"\",\"\",_xlfn.XLOOKUP($D59,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),859,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),2,\"\"))","v":""},"",{"$f":"IF($O60=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O60,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O60))","v":""},null,{"$f":"IF(D60=\"\",\"\",_xlfn.XLOOKUP($D60,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D60=\"\",\"\",_xlfn.XLOOKUP($D60,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D60=\"\",\"\",_xlfn.XLOOKUP($D60,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),2662,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),2,\"\"))","v":""},"",{"$f":"IF($O61=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O61,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O61))","v":""},null,{"$f":"IF(D61=\"\",\"\",_xlfn.XLOOKUP($D61,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D61=\"\",\"\",_xlfn.XLOOKUP($D61,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D61=\"\",\"\",_xlfn.XLOOKUP($D61,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"X\",B17=\"\",B18=\"\"),2691,\"\"))","v":""}]
[null,"End Walls with Doors",null,null,null,null,"Subtotal:",null,{"$f":"SUM(I63:I73)","v":0}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),16,\"\"))","v":""},{"$f":"IF(B63=\"\",\"\",\"each\")","v":""},{"$f":"IF($O63=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O63,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O63))","v":""},null,{"$f":"IF(D63=\"\",\"\",_xlfn.XLOOKUP($D63,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D63=\"\",\"\",_xlfn.XLOOKUP($D63,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D63=\"\",\"\",_xlfn.XLOOKUP($D63,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H63=\"\",\"\",B63*H63)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),161640,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),2,\"\"))","v":""},"",{"$f":"IF($O64=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O64,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O64))","v":""},null,{"$f":"IF(D64=\"\",\"\",_xlfn.XLOOKUP($D64,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D64=\"\",\"\",_xlfn.XLOOKUP($D64,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D64=\"\",\"\",_xlfn.XLOOKUP($D64,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H64=\"\",\"\",B64*H64)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),101697,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),16,\"\"))","v":""},"",{"$f":"IF($O65=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O65,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O65))","v":""},null,{"$f":"IF(D65=\"\",\"\",_xlfn.XLOOKUP($D65,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D65=\"\",\"\",_xlfn.XLOOKUP($D65,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D65=\"\",\"\",_xlfn.XLOOKUP($D65,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),2032,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),2,\"\"))","v":""},"",{"$f":"IF($O66=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O66,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O66))","v":""},null,{"$f":"IF(D66=\"\",\"\",_xlfn.XLOOKUP($D66,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D66=\"\",\"\",_xlfn.XLOOKUP($D66,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D66=\"\",\"\",_xlfn.XLOOKUP($D66,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),784261,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),4,\"\"))","v":""},"",{"$f":"IF($O67=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O67,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O67))","v":""},null,{"$f":"IF(D67=\"\",\"\",_xlfn.XLOOKUP($D67,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D67=\"\",\"\",_xlfn.XLOOKUP($D67,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D67=\"\",\"\",_xlfn.XLOOKUP($D67,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),237042,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),2,\"\"))","v":""},"",{"$f":"IF($O68=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O68,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O68))","v":""},null,{"$f":"IF(D68=\"\",\"\",_xlfn.XLOOKUP($D68,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D68=\"\",\"\",_xlfn.XLOOKUP($D68,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D68=\"\",\"\",_xlfn.XLOOKUP($D68,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),241725,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),2,\"\"))","v":""},"",{"$f":"IF($O69=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O69,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O69))","v":""},null,{"$f":"IF(D69=\"\",\"\",_xlfn.XLOOKUP($D69,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D69=\"\",\"\",_xlfn.XLOOKUP($D69,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D69=\"\",\"\",_xlfn.XLOOKUP($D69,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),474206,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),2,\"\"))","v":""},"",{"$f":"IF($O70=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O70,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O70))","v":""},null,{"$f":"IF(D70=\"\",\"\",_xlfn.XLOOKUP($D70,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D70=\"\",\"\",_xlfn.XLOOKUP($D70,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D70=\"\",\"\",_xlfn.XLOOKUP($D70,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),161756,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),4,\"\"))","v":""},"",{"$f":"IF($O71=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O71,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O71))","v":""},null,{"$f":"IF(D71=\"\",\"\",_xlfn.XLOOKUP($D71,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D71=\"\",\"\",_xlfn.XLOOKUP($D71,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D71=\"\",\"\",_xlfn.XLOOKUP($D71,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),2760,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),4,\"\"))","v":""},"",{"$f":"IF($O72=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O72,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O72))","v":""},null,{"$f":"IF(D72=\"\",\"\",_xlfn.XLOOKUP($D72,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D72=\"\",\"\",_xlfn.XLOOKUP($D72,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D72=\"\",\"\",_xlfn.XLOOKUP($D72,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H72=\"\",\"\",B72*H72)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),2648,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),1,\"\"))","v":""},"",{"$f":"IF($O73=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O73,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O73))","v":""},null,{"$f":"IF(D73=\"\",\"\",_xlfn.XLOOKUP($D73,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D73=\"\",\"\",_xlfn.XLOOKUP($D73,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D73=\"\",\"\",_xlfn.XLOOKUP($D73,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H73=\"\",\"\",B73*H73)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B16=\"\",B17=\"x\",B18=\"\"),134228,\"\"))","v":""}]
[null,"Roll-up Sides",null,null,null,null,"Subtotal:",null,{"$f":"SUM(I75:I82)","v":0}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"X\",B21=\"\", B22=\"\"),D9*2/10+2,\"\"))","v":""},{"$f":"IF(B75=\"\",\"\",\"each\")","v":""},{"$f":"IF($O75=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O75,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O75))","v":""},null,{"$f":"IF(D75=\"\",\"\",_xlfn.XLOOKUP($D75,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D75=\"\",\"\",_xlfn.XLOOKUP($D75,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D75=\"\",\"\",_xlfn.XLOOKUP($D75,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H75=\"\",\"\",B75*H75)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"X\",B21=\"\", B22=\"\"),203106,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"X\",B21=\"\", B22=\"\"),2,\"\"))","v":""},"",{"$f":"IF($O76=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O76,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O76))","v":""},null,{"$f":"IF(D76=\"\",\"\",_xlfn.XLOOKUP($D76,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D76=\"\",\"\",_xlfn.XLOOKUP($D76,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D76=\"\",\"\",_xlfn.XLOOKUP($D76,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H76=\"\",\"\",B76*H76)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"X\",B21=\"\", B22=\"\"),103659,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"\",B21=\"x\",B22=\"\"),D9*2/10+2,\"\"))","v":""},"",{"$f":"IF($O77=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O77,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O77))","v":""},null,{"$f":"IF(D77=\"\",\"\",_xlfn.XLOOKUP($D77,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D77=\"\",\"\",_xlfn.XLOOKUP($D77,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D77=\"\",\"\",_xlfn.XLOOKUP($D77,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H77=\"\",\"\",B77*H77)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"\",B21=\"x\", B22=\"\"),203114,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"\",B21=\"x\",B22=\"\"),ROUNDUP(B77/5,0),\"\"))","v":""},"",{"$f":"IF($O78=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O78,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O78))","v":""},null,{"$f":"IF(D78=\"\",\"\",_xlfn.XLOOKUP($D78,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D78=\"\",\"\",_xlfn.XLOOKUP($D78,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D78=\"\",\"\",_xlfn.XLOOKUP($D78,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"\",B21=\"x\", B22=\"\"),403636,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"\",B21=\"x\",B22=\"\"),2,\"\"))","v":""},"",{"$f":"IF($O79=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O79,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O79))","v":""},null,{"$f":"IF(D79=\"\",\"\",_xlfn.XLOOKUP($D79,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D79=\"\",\"\",_xlfn.XLOOKUP($D79,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D79=\"\",\"\",_xlfn.XLOOKUP($D79,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"\",B21=\"x\", B22=\"\"),7033,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"\",B21=\"x\",B22=\"\"),ROUNDUP(D9/10,0),\"\"))","v":""},"",{"$f":"IF($O80=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O80,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O80))","v":""},null,{"$f":"IF(D80=\"\",\"\",_xlfn.XLOOKUP($D80,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D80=\"\",\"\",_xlfn.XLOOKUP($D80,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D80=\"\",\"\",_xlfn.XLOOKUP($D80,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"\",B21=\"x\", B22=\"\"),9150,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"\",B21=\"x\",B22=\"\"),ROUNDUP(4*D9/1000,0),\"\"))","v":""},"",{"$f":"IF($O81=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O81,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O81))","v":""},null,{"$f":"IF(D81=\"\",\"\",_xlfn.XLOOKUP($D81,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D81=\"\",\"\",_xlfn.XLOOKUP($D81,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D81=\"\",\"\",_xlfn.XLOOKUP($D81,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"\",B21=\"x\", B22=\"\"),\"550C-WHT1000\",\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"\",B21=\"x\",B22=\"\"),ROUNDUP(2*D14/25,0),\"\"))","v":""},"",{"$f":"IF($O82=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O82,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O82))","v":""},null,{"$f":"IF(D82=\"\",\"\",_xlfn.XLOOKUP($D82,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D82=\"\",\"\",_xlfn.XLOOKUP($D82,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D82=\"\",\"\",_xlfn.XLOOKUP($D82,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B20=\"\",B21=\"x\", B22=\"\"),727401,\"\"))","v":""}]
[null,"Cable Purlins for Trellising",null,null,null,null,"Subtotal:",null,{"$f":"SUM(I84:I88)","v":0}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B24>0,B25=FALSE),B24*D14,\"\"))","v":""},{"$f":"IF(B84=\"\",\"\",\"each\")","v":""},{"$f":"IF($O84=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O84,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O84))","v":""},null,{"$f":"IF(D84=\"\",\"\",_xlfn.XLOOKUP($D84,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D84=\"\",\"\",_xlfn.XLOOKUP($D84,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D84=\"\",\"\",_xlfn.XLOOKUP($D84,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H84=\"\",\"\",B84*H84)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B24>0, B25=FALSE),\"BB138\",\"\"))","v":""},{"$f":"IF($B$25=\"False\",\"BB138\",\"\")","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B24>0,B25=FALSE),ROUNDUP(2*B84/100,0),\"\"))","v":""},"",{"$f":"IF($O85=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O85,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O85))","v":""},null,{"$f":"IF(D85=\"\",\"\",_xlfn.XLOOKUP($D85,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D85=\"\",\"\",_xlfn.XLOOKUP($D85,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D85=\"\",\"\",_xlfn.XLOOKUP($D85,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H85=\"\",\"\",B85*H85)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B24>0, B25=FALSE),2405,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B24>0,B25=FALSE),B24,\"\"))","v":""},"",{"$f":"IF($O86=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O86,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O86))","v":""},null,{"$f":"IF(D86=\"\",\"\",_xlfn.XLOOKUP($D86,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D86=\"\",\"\",_xlfn.XLOOKUP($D86,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D86=\"\",\"\",_xlfn.XLOOKUP($D86,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H86=\"\",\"\",B86*H86)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B24>0, B25=FALSE),372074,\"\"))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(D87=9604,ROUNDUP(B24*(D9+5)/60,0),IF(D87=9725,ROUNDUP(B24*(D9+5)/550,0),\"\")))","v":""},"",{"$f":"IF($O87=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O87,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O87))","v":""},null,{"$f":"IF(D87=\"\",\"\",_xlfn.XLOOKUP($D87,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D87=\"\",\"\",_xlfn.XLOOKUP($D87,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D87=\"\",\"\",_xlfn.XLOOKUP($D87,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H87=\"\",\"\",B87*H87)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B24>0, B25=FALSE, B24*D9<50),9604, IF(AND(B24>0, B25=FALSE, B24*D9>49),9725,\"\")))","v":""}]
[null,{"$f":"IF($I$7=0,\"\",IF(AND(B24>0,B25=FALSE),ROUNDUP(2*B84/100,0),\"\"))","v":""},"",{"$f":"IF($O88=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($O88,Lookup_Table!$B$2:$B$121,Lookup_Table!$E$2:$E$121),$O88))","v":""},null,{"$f":"IF(D88=\"\",\"\",_xlfn.XLOOKUP($D88,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF(D88=\"\",\"\",_xlfn.XLOOKUP($D88,Lookup_Table[Item '#],Lookup_Table[Table20.Description]))","v":""},{"$f":"IF(D88=\"\",\"\",_xlfn.XLOOKUP($D88,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(H88=\"\",\"\",B88*H88)","v":""},null,null,null,null,null,{"$f":"IF($I$7=0,\"\",IF(AND(B24>0, B25=FALSE),2405,\"\"))","v":""}]
[]
[null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(I29+I32+I48+I53+I62+I74+I83)","v":0}]
[]
[null,null,null,null,null,null,null,null,"(PRICING: JUL24)"]
["© JOHNNY SELECTED SEEDS.   ALL RIGHTS RESERVED.   |  955 BENTON AVENUE   WINSLOW   MAINE   04901"]
["JOHNNY'S SELECTED SEEDS IS A PRIVATELY HELD, EMPLOYEE-OWNED COMPANY."]