{"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":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":62,"n_cols":17,"rows_kept":62,"cut":false,"hidden":false,"merged":[[55,1,55,2],[56,1,56,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[49,4,49,5],[47,4,47,5],[48,4,48,5],[44,4,44,5],[60,0,60,11],[50,4,50,5],[56,4,56,5],[55,4,55,5],[52,4,52,5],[54,4,54,5],[53,4,53,5],[51,4,51,5],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[42,4,42,5],[41,4,41,5],[46,4,46,5],[40,4,40,5],[43,4,43,5],[45,4,45,5],[39,4,39,5],[32,4,32,5],[31,4,31,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[33,4,33,5],[34,4,34,5],[36,4,36,5],[38,4,38,5],[19,2,19,6],[18,2,18,6],[17,2,17,6],[14,2,14,6],[15,2,15,6],[21,2,21,6],[22,2,22,6],[25,1,25,2],[24,1,24,2],[25,4,25,5],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[61,0,61,11],[6,1,6,9],[37,4,37,5],[3,1,3,9],[7,1,7,5],[10,1,10,3],[12,1,12,3],[24,4,24,5],[11,1,11,3],[14,7,15,7],[21,7,22,7],[17,7,19,7],[4,1,4,9],[5,1,5,9],[13,1,13,3],[35,4,35,5]]}
[]
[]
[]
[null,"Quick Hoops™ 14 ft. Wide Modular Moveable 'Cathedral' 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,null,"Square Feet",{"$f":"IFERROR(E12*E11,\"\")","v":""}]
[]
[null,"# Modules",null,null,null,{"$f":"IF(E10>0,\"\",\"Enter the # of modules here that you would like your tunnel to have.\")","v":"Enter the # of modules here that you would like your tunnel to have."},null,null,"Cost / Sq. Ft.",{"$f":"IFERROR(J58/J8,\"\")","v":""}]
[null,"Length",null,null,{"$f":"IF(OR(E10=\"\",E10=0),\"\",E10*16+E10-1)","v":""},"ft."]
[null,"Width",null,null,{"$f":"IF(OR(E10=\"\",E10=0),\"\",14)","v":""},"ft."]
[null,"Bow Spacing",null,null,{"$f":"IF(OR(E10=\"\",E10=0),\"\",\"5 ft. 4 in.\")","v":""}]
[null,"# Bows",null,null,{"$f":"IF(OR(E10=\"\",E10=0),\"\",4*E10)","v":""}]
[2,{"$f":"IF(A15=2,\"x\",\"\")","v":"x"},"Lower-cost 1\" EMT for Scissor Doors"]
[null,{"$f":"IF(A15=1,\"x\",\"\")","v":""},"Heavier-duty 1-3/8\" Top-Rail for Scissor Doors",null,null,null,null,null,null,null,null,null,null," "]
[]
[1,{"$f":"IF($A$18=1,\"x\",\"\")","v":"x"},"No roll-up sides at all"]
[null,{"$f":"IF($A$18=2,\"x\",\"\")","v":""},"Lower-cost manual roll-up sides"]
[null,{"$f":"IF($A$18=3,\"x\",\"\")","v":""},"Handcrank auto-stop roll-up sides"]
[]
[1,{"$f":"IF($A$22=1,\"x\",\"\")","v":"x"},"Lower-cost rebar anchors"]
[null,{"$f":"IF($A$22=2,\"x\",\"\")","v":""},"More secure earth auger anchors"]
[]
[null,"Qty",null,"Unit","Part#",null,"Vendor","Description","Price","Ext"]
[null,{"$f":"IF(E26=\"\",\"\",1)","v":""},null,{"$f":"IF($E26=\"\",\"\",\"each\")","v":""},{"$f":"IF($P26=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P26,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P26))","v":""},null,{"$f":"IF(E26=\"\",\"\",_xlfn.XLOOKUP($E26,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E26=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E26,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q26))","v":""},{"$f":"IF(E26=\"\",\"\",_xlfn.XLOOKUP($E26,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(I26=\"\",\"\",B26*I26)","v":""},null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",7300)","v":""}]
[null,{"$f":"IF(E27=\"\",\"\",E14*2)","v":""},null,{"$f":"IF($E27=\"\",\"\",\"each\")","v":""},{"$f":"IF($P27=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P27,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P27))","v":""},null,{"$f":"IF(E27=\"\",\"\",_xlfn.XLOOKUP($E27,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E27=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E27,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q27))","v":""},{"$f":"IF(E27=\"\",\"\",_xlfn.XLOOKUP($E27,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",181697)","v":""}," for side hoops"]
[null,{"$f":"IF(E28=\"\",\"\",E14/2)","v":""},null,"",{"$f":"IF($P28=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P28,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P28))","v":""},null,{"$f":"IF(E28=\"\",\"\",_xlfn.XLOOKUP($E28,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E28=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E28,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q28))","v":""},{"$f":"IF(E28=\"\",\"\",_xlfn.XLOOKUP($E28,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",181697)","v":""}," for peak sections"]
[null,{"$f":"IF(E29=\"\",\"\",2*E10)","v":""},null,"",{"$f":"IF($P29=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P29,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P29))","v":""},null,{"$f":"IF(E29=\"\",\"\",_xlfn.XLOOKUP($E29,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E29=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E29,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q29))","v":""},{"$f":"IF(E29=\"\",\"\",_xlfn.XLOOKUP($E29,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",181697)","v":""},"f or ridge poles"]
[null,{"$f":"IF(E30=\"\",\"\",4*E10)","v":""},null,"",{"$f":"IF($P30=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P30,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P30))","v":""},null,{"$f":"IF(E30=\"\",\"\",_xlfn.XLOOKUP($E30,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E30=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E30,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q30))","v":""},{"$f":"IF(E30=\"\",\"\",_xlfn.XLOOKUP($E30,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",181697)","v":""}," for bottom rails"]
[null,{"$f":"IF(E31=\"\",\"\",3)","v":""},null,"",{"$f":"IF($P31=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P31,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P31))","v":""},null,{"$f":"IF(E31=\"\",\"\",_xlfn.XLOOKUP($E31,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E31=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E31,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q31))","v":""},{"$f":"IF(E31=\"\",\"\",_xlfn.XLOOKUP($E31,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",181697)","v":""}," for knee rails"]
[null,{"$f":"IF(E32=\"\",\"\",4)","v":""},null,"",{"$f":"IF($P32=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P32,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P32))","v":""},null,{"$f":"IF(E32=\"\",\"\",_xlfn.XLOOKUP($E32,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E32=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E32,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q32))","v":""},{"$f":"IF(E32=\"\",\"\",_xlfn.XLOOKUP($E32,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",IF(AND(B15=\"X\",B16=\"\"),580015,IF(AND(B16=\"X\",B15=\"\"),181697,\"\")))","v":""}," for scissor doors"]
[null,{"$f":"IF(E33=\"\",\"\",4)","v":""},null,"",{"$f":"IF($P33=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P33,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P33))","v":""},null,{"$f":"IF(E33=\"\",\"\",_xlfn.XLOOKUP($E33,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E33=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E33,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q33))","v":""},{"$f":"IF(E33=\"\",\"\",_xlfn.XLOOKUP($E33,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",IF(AND(B15=\"X\",B16=\"\"),7036,IF(AND(B16=\"X\",B15=\"\"),7035,\"\")))","v":""}," for 1 in. EMT, 10 pack"]
[null,{"$f":"IF(E34=\"\",\"\",E14)","v":""},null,"",{"$f":"IF($P34=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P34,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P34))","v":""},null,{"$f":"IF(E34=\"\",\"\",_xlfn.XLOOKUP($E34,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E34=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E34,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q34))","v":""},{"$f":"IF(E34=\"\",\"\",_xlfn.XLOOKUP($E34,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",203114)","v":""}," for collar ties"]
[null,{"$f":"IF(E35=\"\",\"\",4)","v":""},null,"",{"$f":"IF($P35=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P35,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P35))","v":""},null,{"$f":"IF(E35=\"\",\"\",_xlfn.XLOOKUP($E35,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E35=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E35,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q35))","v":""},{"$f":"IF(E35=\"\",\"\",_xlfn.XLOOKUP($E35,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF(E11=\"\",\"\",203114)","v":""}," for end wall angle braces"]
[null,{"$f":"IF(E36=\"\",\"\",IF(B18=\"x\",\"\",E11*2/10+2))","v":""},null,"",{"$f":"IF($P36=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P36,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P36))","v":""},null,{"$f":"IF(E36=\"\",\"\",_xlfn.XLOOKUP($E36,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E36=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E36,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q36))","v":""},{"$f":"IF(E36=\"\",\"\",_xlfn.XLOOKUP($E36,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(B36=\"\",\"\",B36*I36)","v":""},null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",IF(B18=\"x\",\"\",203114))","v":""}," for roll-up sides"]
[null,{"$f":"IF(E37=\"\",\"\",IF(B36=\"\",\"\",ROUNDUP(B36/5,0)))","v":""},null,"",{"$f":"IF($P37=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P37,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P37))","v":""},null,{"$f":"IF(E37=\"\",\"\",_xlfn.XLOOKUP($E37,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E37=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E37,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q37))","v":""},{"$f":"IF(E37=\"\",\"\",_xlfn.XLOOKUP($E37,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(B37=\"\",\"\",B37*I37)","v":""},null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",IF(B36=\"\",\"\",403636))","v":""}," for roll-ups, 5 pack"]
[null,{"$f":"IF(E38=\"\",\"\",IF(B18=\"x\",\"\",E10))","v":""},null,"",{"$f":"IF($P38=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P38,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P38))","v":""},null,{"$f":"IF(E38=\"\",\"\",_xlfn.XLOOKUP($E38,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E38=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E38,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q38))","v":""},{"$f":"IF(E38=\"\",\"\",_xlfn.XLOOKUP($E38,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(B38=\"\",\"\",B38*I38)","v":""},null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",IF(B18=\"x\",\"\",9150))","v":""}," for ¾ in. EMT, 10 pack"]
[null,{"$f":"IF(E39=\"\",\"\",ROUNDUP(B40*2+25*(E10-1)/4,0))","v":""},null,"",{"$f":"IF($P39=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P39,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P39))","v":""},null,{"$f":"IF(E39=\"\",\"\",_xlfn.XLOOKUP($E39,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E39=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E39,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q39))","v":""},{"$f":"IF(E39=\"\",\"\",_xlfn.XLOOKUP($E39,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(I39=\"\",\"\",B39*I39)","v":""},null,null,"Bows","Knee Rails","Sides",{"$f":"IF(E10=\"\",\"\",7040)","v":""}]
[null,{"$f":"IF(E40=\"\",\"\",ROUNDUP((M40+N40+O40)/8,0))","v":""},null,"",{"$f":"IF($P40=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P40,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P40))","v":""},null,{"$f":"IF(E40=\"\",\"\",_xlfn.XLOOKUP($E40,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E40=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E40,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q40))","v":""},{"$f":"IF(E40=\"\",\"\",_xlfn.XLOOKUP($E40,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,{"$f":"E10*25*2","v":0},{"$f":"15*2","v":30},{"$f":"E10*16*2","v":0},{"$f":"IF(E10=\"\",\"\",7041)","v":""}]
[null,{"$f":"IF(E41=\"\",\"\",E10)","v":""},null,"",{"$f":"IF($P41=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P41,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P41))","v":""},null,{"$f":"IF(E41=\"\",\"\",_xlfn.XLOOKUP($E41,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E41=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E41,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q41))","v":""},{"$f":"IF(E41=\"\",\"\",_xlfn.XLOOKUP($E41,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",162330)","v":""}]
[null,{"$f":"IF(OR(E10=\"\",E10=0),\"\",IF(B18=\"x\",ROUNDUP((B40*8+B33*10)/150,0),ROUNDUP((B40*8+B38*10+B33*10)/150,0)))","v":""},null,"",{"$f":"IF($P42=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P42,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P42))","v":""},null,{"$f":"IF(E42=\"\",\"\",_xlfn.XLOOKUP($E42,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E42=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E42,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q42))","v":""},{"$f":"IF(E42=\"\",\"\",_xlfn.XLOOKUP($E42,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",162330)","v":""}]
[null,{"$f":"IF(E43=\"\",\"\",2)","v":""},null,"",{"$f":"IF($P43=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P43,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P43))","v":""},null,{"$f":"IF(E43=\"\",\"\",_xlfn.XLOOKUP($E43,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E43=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E43,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q43))","v":""},{"$f":"IF(E43=\"\",\"\",_xlfn.XLOOKUP($E43,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",461443)","v":""}]
[null,{"$f":"IF(E44=\"\",\"\",2*E14+20)","v":""},null,"",{"$f":"IF($P44=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P44,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P44))","v":""},null,{"$f":"IF(E44=\"\",\"\",_xlfn.XLOOKUP($E44,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E44=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E44,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q44))","v":""},{"$f":"IF(E44=\"\",\"\",_xlfn.XLOOKUP($E44,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",\"BB138\")","v":""}]
[null,{"$f":"IF(E45=\"\",\"\",B44-B46)","v":""},null,"",{"$f":"IF($P45=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P45,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P45))","v":""},null,{"$f":"IF(E45=\"\",\"\",_xlfn.XLOOKUP($E45,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E45=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E45,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q45))","v":""},{"$f":"IF(E45=\"\",\"\",_xlfn.XLOOKUP($E45,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",2769)","v":""}," for brace bands"]
[null,{"$f":"IF(E46=\"\",\"\",8)","v":""},null,"",{"$f":"IF($P46=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P46,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P46))","v":""},null,{"$f":"IF(E46=\"\",\"\",_xlfn.XLOOKUP($E46,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E46=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E46,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q46))","v":""},{"$f":"IF(E46=\"\",\"\",_xlfn.XLOOKUP($E46,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",2772)","v":""}," for end-wall angle braces and scissor doors"]
[null,{"$f":"IF(E47=\"\",\"\",E14)","v":""},null,"",{"$f":"IF($P47=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P47,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P47))","v":""},null,{"$f":"IF(E47=\"\",\"\",_xlfn.XLOOKUP($E47,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E47=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E47,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q47))","v":""},{"$f":"IF(E47=\"\",\"\",_xlfn.XLOOKUP($E47,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",2777)","v":""}," for ridge poles"]
[null,{"$f":"IF(E48=\"\",\"\",B45+B46+B47+4)","v":""},null,"",{"$f":"IF($P48=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P48,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P48))","v":""},null,{"$f":"IF(E48=\"\",\"\",_xlfn.XLOOKUP($E48,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E48=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E48,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q48))","v":""},{"$f":"IF(E48=\"\",\"\",_xlfn.XLOOKUP($E48,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",2649)","v":""}]
[null,{"$f":"IF(E49=\"\",\"\",2*E14+4)","v":""},null,"",{"$f":"IF($P49=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P49,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P49))","v":""},null,{"$f":"IF(E49=\"\",\"\",_xlfn.XLOOKUP($E49,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E49=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E49,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q49))","v":""},{"$f":"IF(E49=\"\",\"\",_xlfn.XLOOKUP($E49,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",\"ERC1313\")","v":""}]
[null,{"$f":"IF(E50=\"\",\"\",B49)","v":""},null,"",{"$f":"IF($P50=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P50,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P50))","v":""},null,{"$f":"IF(E50=\"\",\"\",_xlfn.XLOOKUP($E50,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E50=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E50,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q50))","v":""},{"$f":"IF(E50=\"\",\"\",_xlfn.XLOOKUP($E50,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",\"CB5162HDG\")","v":""}]
[null,{"$f":"IF(E51=\"\",\"\",1)","v":""},null,{"$f":"IF($E51=\"\",\"\",\"roll\")","v":""},{"$f":"IF($P51=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P51,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P51))","v":""},null,{"$f":"IF(E51=\"\",\"\",_xlfn.XLOOKUP($E51,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E51=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E51,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q51))","v":""},{"$f":"IF(E51=\"\",\"\",_xlfn.XLOOKUP($E51,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",IF(E11<35,7176,IF(E11<70,7177, IF(E11<95,7178,\"\"))))","v":""}]
[null,{"$f":"IF(E52=\"\",\"\",IF(AND(B19=\"X\",B20=\"\"),2*E10,\"\"))","v":""},null,{"$f":"IF($E52=\"\",\"\",\"each\")","v":""},{"$f":"IF($P52=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P52,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P52))","v":""},null,{"$f":"IF(E52=\"\",\"\",_xlfn.XLOOKUP($E52,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E52=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E52,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q52))","v":""},{"$f":"IF(E52=\"\",\"\",_xlfn.XLOOKUP($E52,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},"",null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",IF(AND(B19=\"X\",B20=\"\"),103667,\"\"))","v":""}]
[null,{"$f":"IF(E53=\"\",\"\",IF(AND(B20=\"X\",B19=\"\"),2,\"\"))","v":""},null,"",{"$f":"IF($P53=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P53,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P53))","v":""},null,{"$f":"IF(E53=\"\",\"\",_xlfn.XLOOKUP($E53,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E53=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E53,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q53))","v":""},{"$f":"IF(E53=\"\",\"\",_xlfn.XLOOKUP($E53,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(B53=\"\",\"\",B53*I53)","v":""},null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",IF(AND(B20=\"X\",B19=\"\"),7033,\"\"))","v":""}]
[null,{"$f":"IF(E54=\"\",\"\",IF(AND(B22=\"X\",B23=\"\"),4*E10,\"\"))","v":""},null,"",{"$f":"IF($P54=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P54,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P54))","v":""},null,{"$f":"IF(E54=\"\",\"\",_xlfn.XLOOKUP($E54,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E54=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E54,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q54))","v":""},{"$f":"IF(E54=\"\",\"\",_xlfn.XLOOKUP($E54,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(I54=\"\",\"\",B54*I54)","v":""},null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",IF(AND(B22=\"X\",B23=\"\"),106151,\"\"))","v":""}]
[null,{"$f":"IF(E55=\"\",\"\",IF(AND(B23=\"X\",B22=\"\"),E10,\"\"))","v":""},null,"",{"$f":"IF($P55=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P55,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P55))","v":""},null,{"$f":"IF(E55=\"\",\"\",_xlfn.XLOOKUP($E55,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E55=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E55,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q55))","v":""},{"$f":"IF(E55=\"\",\"\",_xlfn.XLOOKUP($E55,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(I55=\"\",\"\",B55*I55)","v":""},null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",IF(AND(B23=\"X\",B22=\"\"),202719050,\"\"))","v":""}]
[null,{"$f":"IF(E56=\"\",\"\",IF(B55=\"\",\"\",E10*4))","v":""},null,"",{"$f":"IF($P56=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P56,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P56))","v":""},null,{"$f":"IF(E56=\"\",\"\",_xlfn.XLOOKUP($E56,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E56=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E56,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q56))","v":""},{"$f":"IF(E56=\"\",\"\",_xlfn.XLOOKUP($E56,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(I56=\"\",\"\",B56*I56)","v":""},null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",IF(B55=\"\",\"\",12280))","v":""}]
[null,{"$f":"IF(E57=\"\",\"\",IF(B55=\"\",\"\",ROUNDUP(E10*4/5,0)))","v":""},null,"",{"$f":"IF($P57=\"\",\"\",HYPERLINK(_xlfn.XLOOKUP($P57,Lookup_Table!$B$2:$B$120,Lookup_Table!$E$2:$E$120),$P57))","v":""},null,{"$f":"IF(E57=\"\",\"\",_xlfn.XLOOKUP($E57,Lookup_Table[Item '#],Lookup_Table[Table20.Brand]))","v":""},{"$f":"IF($E57=\"\",\"\",CONCATENATE(_xlfn.XLOOKUP($E57,Lookup_Table[Item '#],Lookup_Table[Table20.Description]),$Q57))","v":""},{"$f":"IF(E57=\"\",\"\",_xlfn.XLOOKUP($E57,Lookup_Table[Item '#],Lookup_Table[Price]))","v":""},{"$f":"IF(I57=\"\",\"\",B57*I57)","v":""},null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",IF(B55=\"\",\"\",321922))","v":""}]
[null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(J26:J57)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"(PRICING:SEP25)"]
["© JOHNNY SELECTED SEEDS.   ALL RIGHTS RESERVED.   |  955 BENTON AVENUE   WINSLOW   MAINE   04901"]
["JOHNNY'S SELECTED SEEDS IS A PRIVATELY HELD, EMPLOYEE-OWNED COMPANY."]