{"product_id":"shop-ac-heat-calculator-spreadsheet","title":"Shop A\/C \u0026 Heat Calculator: What Size Mini Split for Your Garage or Shop","description":"\u003cp\u003e\u003cstrong\u003eI googled \"what size mini split for my garage\" and got everything from 30,000 to 72,000 BTU for the same 1,500 sq ft shop.\u003c\/strong\u003e None of them asked how often my big door goes up, or what happens when I pull in a hot truck.\u003c\/p\u003e\n\u003cp\u003eIf you're trying to cool or heat a garage or shop, you know how this goes:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe square foot rules of thumb\u003c\/strong\u003e don't know if you've got R-19 walls or bare steel. Big difference.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe guy at the big box store\u003c\/strong\u003e says get the bigger one to be safe. Bigger isn't better. An oversized A\/C cools fast, shuts off before it pulls the water out, and leaves you cold and clammy.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWindow units are loud.\u003c\/strong\u003e Like can't-hear-the-radio loud.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eHotel style units\u003c\/strong\u003e need a giant hole in your wall.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMini splits cost more and need installing,\u003c\/strong\u003e so you really want to buy the right size the first time.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eI've been limping along with a 10,000 BTU window unit in my 30x50 shop since 2023. Before I spent real money on a mini split I wanted a real answer, so I built a spreadsheet that does a simplified version of the load calc HVAC pros use (Manual J). Pick your state and county and it pulls the EPA design temps for where you live. Then tell it about the shop: size, insulation, slab, doors, windows, how often the big door goes up, hot vehicles, people, lights, compressor and welder. It adds it all up and tells you what size to buy and why.\u003c\/p\u003e\n\u003cp\u003eFor my shop it came out to about 24,600 BTU\/hr of cooling and 28,300 of heating. That's a 24k mini split plus a heater for the coldest mornings. The 24k Senville Aura I'd already bought was the right size.\u003c\/p\u003e\n\u003cp\u003e\u003cem\u003eIt's for garages and small shops. If you've got 42 bays and 30 techs, that's commercial. Call an engineer.\u003c\/em\u003e\u003c\/p\u003e\n\u003ch3\u003eWhat you get\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eResults tab.\u003c\/strong\u003e Your cooling and heating size in big numbers, my pick for your shop and how it'll do on the worst afternoon, plus the cheapest way to cool and the simplest way to heat. One page. Print it and take it to the store.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWhere your heat comes from.\u003c\/strong\u003e Summer and winter breakdowns: roof, walls, big door, windows, air leaks, door openings, hot vehicles, people and tools. In my shop, opening the big door is almost a quarter of the summer load.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eOptions tab.\u003c\/strong\u003e 12 ways to cool or heat it, sized for your shop: window unit, hotel style (PTAC), portable, DIY mini split, pro installed mini split, central, gas or propane unit heater, electric unit heater, infrared, radiant floor, swamp cooler and dehumidifier. Each one has a rough price, the circuit it needs, how loud it is and a monthly power bill for how you actually run it (work hours only, or on a thermostat all the time). Never seen a PTAC? Each one links to a real example so you can see what it looks like.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWhat If tab.\u003c\/strong\u003e Insulate the door, beef up the ceiling, spray foam the walls, seal the leaks, go with a light roof, open the door half as often. It shows what each one saves and whether it gets you into a smaller unit.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eUnit Types tab.\u003c\/strong\u003e The good, the bad and who should buy each one, the way I'd explain it in the shop.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eYour county's weather.\u003c\/strong\u003e EPA design temps for every county in the US. Know your spot better? Type your own.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eHow It Works.\u003c\/strong\u003e Every number explained in plain English with your numbers plugged in, including the hot car math. Nerd knobs at the bottom if you want to change the assumptions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eThe boring stuff\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eExcel file (.xlsx). Instant download after checkout. Nothing ships.\u003c\/li\u003e\n\u003cli\u003eYou get a blank workbook. The pictures are my shop.\u003c\/li\u003e\n\u003cli\u003eMade for Excel. Plain formulas, no macros.\u003c\/li\u003e\n\u003cli\u003eAbout 10 minutes. Every box starts with a normal number, so change what you know and leave the rest.\u003c\/li\u003e\n\u003cli\u003eUS only, since the weather comes from EPA county data.\u003c\/li\u003e\n\u003cli\u003eFor garages and small shops up to about 5,000 sq ft. A big or chopped-up building deserves a pro load calc.\u003c\/li\u003e\n\u003cli\u003eThe sizes are estimates. Good enough to buy the right size for a garage or shop, but it's no stamped engineering report. Prices and power bills are rough too, so shop around.\u003c\/li\u003e\n\u003cli\u003eRefrigerant work needs a licensed tech unless you buy a DIY kit with pre-charged lines. Check your local code before you wire anything.\u003c\/li\u003e\n\u003cli\u003eThe formulas are locked so a stray click can't break anything. No password if you want to change something.\u003c\/li\u003e\n\u003cli\u003eQuestions or ideas? Email me at CreativeEntLLC@gmail.com\u003c\/li\u003e\n\u003c\/ul\u003e\n","brand":"Creative Enterprises LLC","offers":[{"title":"Default Title","offer_id":67633052352828,"sku":"DIG-SHOP-AC-HEAT","price":14.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0667\/9802\/7068\/files\/1-what-size-do-i-need_db7204ff-2ba4-4f4d-99db-b5c2082ec2d7.jpg?v=1791260910","url":"https:\/\/creativeenterprisesllc.com\/products\/shop-ac-heat-calculator-spreadsheet","provider":"Creative Enterprises LLC","version":"1.0","type":"link"}