Latest / Mid Mod Remodel / Essential Remodel Planning Spreadsheets

Transcript

Essential Remodel Planning Spreadsheets · Mid Mod Remodel

• 0:00
  Speaker 1: Okay, now that you've got your style guide, all set, you haven't done your homework and created your style guide.
• 0:05
  Speaker 1: Right?
• 0:06
  Speaker 1: Good.
• 0:06
  Speaker 1: Now you're ready to take it to the next level with the essential remodel planning spreadsheets.
• 0:11
  Speaker 1: Let's talk about what you should be tracking to plan a remodel that will fit your life and budget.
• 0:17
  Speaker 1: Okay.
• 0:17
  Speaker 1: There, welcome back to mid Mo remodel.
• 0:19
  Speaker 1: This is the show about a dating MCM homes, helping you match a mid-century home to your modern life.
• 0:25
  Speaker 1: I'm your host Della Hansman architect, and mid-century ranch enthusiast.
• 0:29
  Speaker 1: You're listening to season eight, episode four.
• 0:32
  Speaker 1: All right.
• 0:32
  Speaker 1: So the new thing I wanted to do this week, or this season is a resource of the week.
• 0:37
  Speaker 1: This week's resource is the Idaho modern feel, guide the history care and keeping of your mid-century home.
• 0:44
  Speaker 1: And this was put together by preservation, Idaho and Idaho modern a few years ago.
• 0:49
  Speaker 1: It's Idaho specific, obviously that's in the name, but basically it's talking about what homes were like in the postwar building.
• 0:57
  Speaker 1: Boom.
• 0:58
  Speaker 1: And it points out something that I think is really valuable, which is that mid century homes were mid-century modern.
• 1:03
  Speaker 1: In fact, most of them were not, they were mid-century vintage, mid-century traditional, mid-century colonial builder basic.
• 1:11
  Speaker 1: And then it goes into a bunch of the different parts of a house windows, doors, roofing, and talks about the materials, the choices you might make in colors in pro in fixtures, in built-ins in choosing to add or update a garage or carport things you can do to make your house more vintage appropriate, or just knowledge you might wanna have about what your house might have been like when it was originally built before all of the intervening, remodels and updates took over its style.
• 1:40
  Speaker 1: I think this is a great read and a high recommend you check it out.
• 1:44
  Speaker 1: In addition to going through my resources list, which I hope you've already downloaded.
• 1:47
  Speaker 1: You can find it also by just going through the website of my friends mid-century homes in Boise, their website is mid dash century homes.com.
• 1:56
  Speaker 1: And you can find this under the media tab, the field guide, if you wanna just go straight to it, Boise mid-century homes is a rate resource in general, if you're looking to purchase a mid-century style home in Boise, well, of course they are your guys and gals, but actually they're just a wonderful account to follow on the internet.
• 2:13
  Speaker 1: And I should say friends of mine, internet, friends of mine, we've been putting together a Q and a weekly series where we talk about the common questions that come up for them as they help people looking to buy and sell at century homes.
• 2:26
  Speaker 1: And I answer them from my perspective as an architect.
• 2:28
  Speaker 1: So check those out.
• 2:29
  Speaker 1: They're gonna be happening on Instagram Fridays, uh, for the foreseeable future.
• 2:34
  Speaker 1: We're really having a fun time doing them.
• 2:36
  Speaker 1: So I don't know how we'd stop this next week.
• 2:38
  Speaker 1: We're gonna be talking about updating front doors.
• 2:40
  Speaker 1: So I hope you'll be there to check that out.
• 2:42
  Speaker 1: Or, you know, you don't have to be live.
• 2:43
  Speaker 1: It'll just stay on the internet forever.
• 2:46
  Speaker 1: You can find their Instagram handle their website and the Idaho hope preservation resource in the links in my show notes, that will be as always atmo-midwest.com/ 8 0 4.
• 2:58
  Speaker 1: And, um, you can also get a download of the entire mid-century essential resources list.
• 3:04
  Speaker 1: It's a great checklist of books, articles, blogs, product suppliers, and concepts, people to follow that will get you up to speed and ready to have the most fun managing your mid-century house, diving into today's topic.
• 3:21
  Speaker 1: I talk often about how important it is that before you start picking out all of the individual products you're going to use in your home remodel, you need to have a style guide because unless you start from your style guide, you will get overwhelmed today.
• 3:36
  Speaker 1: We're going to actually talk about the more advanced version of this technique, what you do after your style guide, plan it all out with a spreadsheet.
• 3:44
  Speaker 1: And I am so excited to talk about this because I have a huge spreadsheet nerd, but believe me, you do not just wanna jump into making a list of the cool products from the entire internet.
• 3:54
  Speaker 1: That is the fastest route to complete remodeling overwhelm.
• 3:58
  Speaker 1: So start from your style guide and everything in your remodel will go better.
• 4:02
  Speaker 1: You can listen to more content on how to prepare a style guide, and you can grab my free style guide starting resource by going to episode 4 0 7, uh, or to mid mod-midwest.com/style guide to download that resource.
• 4:17
  Speaker 1: This will all be in the show notes, basically in that at episode, I walk you through why it's so important to take the big picture of you first, it has innumerable benefits, basically, as you create a style guide for your house, focusing on what are the stain colors, the metal types, the color scheme for your home.
• 4:38
  Speaker 1: You can simplify, you can focus with all of the resources that are available on the internet, trying to do anything else is just a recipe for complete overwhelm, but building out a style guide, which as I say in that episode is more than just a collection of Pinterest boards.
• 4:52
  Speaker 1: It's really a process of focusing what you want, distilling what you love into the specific types of material choices you're gonna make.
• 5:01
  Speaker 1: Again and again, through your house remodel project.
• 5:03
  Speaker 1: This is something we go over extensively inside of ready to remodel because it's both a simple process and kind of challenging to do.
• 5:13
  Speaker 1: A lot of people struggle with indecision in their remodel.
• 5:16
  Speaker 1: A lot of people worry that they can't trust their own choices and their own opinions.
• 5:20
  Speaker 1: A lot of people worry that they're gonna be, make an incorrect choice for their mid-century home.
• 5:24
  Speaker 1: And we work through the process of how to feel confident about your choices, how to assess that they're gonna work together, how to make enough of, uh, to create enough variety in your style guide so that you aren't rigidly locked into.
• 5:39
  Speaker 1: There's only one product you could actually pick that will work, but at the same time to narrow your options down to not being overwhelmed in the plumbing island, home Depot, or as you confront the internet on your smartphone or your computer, once you've got those things in hand, however, once you've got a style guide, you need to go a little bit further in order to plan a remodel.
• 5:59
  Speaker 1: You can't just show your style guide to a contractor and trust that they're going to completely choose every product for you the way you want.
• 6:06
  Speaker 1: You wanna be involved in some of these detailed decisions.
• 6:09
  Speaker 1: So the next step beyond the style guide is to then turn those bigger picture choices into product selections.
• 6:18
  Speaker 1: This is also where the rubber starts to meet the road.
• 6:21
  Speaker 1: In terms of your budget.
• 6:22
  Speaker 1: For example, you might choose to repaint your house, dark gray, or black, a fun current moment.
• 6:29
  Speaker 1: And by the way, if you're working in paint, you can do something.
• 6:31
  Speaker 1: That's a little trendy because you can feel confident that if someone else doesn't like that trend in the future, they can reap, paint it in any color of their choice.
• 6:38
  Speaker 1: This is why I recommend painting your siding and not painting your brick, because that is a permanent choice that nobody could undo.
• 6:45
  Speaker 1: But if we're thinking about exterior, so you've got a dramatic dark sided house.
• 6:51
  Speaker 1: Now you want something to make it pop.
• 6:52
  Speaker 1: You would like to have a Cedar as an accent.
• 6:55
  Speaker 1: You wanna have this beautiful wood.
• 6:56
  Speaker 1: It's got a nice grain.
• 6:58
  Speaker 1: It's got a gorgeous color, warm Amber mid-century appropriate.
• 7:01
  Speaker 1: Great.
• 7:01
  Speaker 1: You're gonna put Cedar as the detail around your house.
• 7:04
  Speaker 1: This is what happens in your style guide.
• 7:06
  Speaker 1: I want this tone of wood to happen outside now where the rubber meets the road is you start to price it out.
• 7:12
  Speaker 1: You talk to a contractor, you find out that right now, still in this moment now more than a year into the pandemic, um, it's really hard to get your hands on Cedar.
• 7:22
  Speaker 1: So shoot.
• 7:23
  Speaker 1: What are you gonna do?
• 7:25
  Speaker 1: You can worry about supply line issues.
• 7:27
  Speaker 1: You can extend out your planning window, or you can start to explore what are other options.
• 7:32
  Speaker 1: If the style guide visual was that Amber tone would, could you do Cedar treated pine?
• 7:38
  Speaker 1: Could you get another type of wood and stain it are you open to the possibility of a faux wood, a low maintenance decking solution that could be used in place of wood, like a TRX or another.
• 7:50
  Speaker 1: There's a bunch of brands out there.
• 7:52
  Speaker 1: They're all relatively comparable.
• 7:55
  Speaker 1: Basically you go from, I want it to look like this, to here's, how we're going to practically solve that problem.
• 8:01
  Speaker 1: And you might compare one product against another and think about what it feels like to touch.
• 8:05
  Speaker 1: Always get samples, always get samples, um, what it costs, what availability it has, where it will be supplied from.
• 8:13
  Speaker 1: If your contractor perhaps has a deal with a particular company that might weigh in the favor of that product, they might have an easier ability to twist the arm of the person.
• 8:22
  Speaker 1: Who's going to get it to them and make sure that it comes on time.
• 8:25
  Speaker 1: These are all considerations that you start to bring in in the later decision making phases, as you start to make this decision for one material and then another, and then another, it adds up.
• 8:36
  Speaker 1: You will not hold all of this in your head and you certainly won't be able to keep track of the links to the websites and the budget numbers and how one budget item compares to another all in your head or even on paper.
• 8:48
  Speaker 1: So this is where we turn to my dear friend.
• 8:51
  Speaker 1: This spreadsheet, let's talk about spreadsheets for a minute.
• 8:57
  Speaker 1: I have found in my life that you are either a spreadsheet person or you're not.
• 9:02
  Speaker 1: Now I am one.
• 9:04
  Speaker 1: So take this advice with that perspective.
• 9:07
  Speaker 1: I have spreadsheets that track my business log movies and TV shows that I wanna check out later, record budget information for past track.
• 9:15
  Speaker 1: I once made a list of the chronological birth and death dates of all my favorite fictional characters.
• 9:20
  Speaker 1: I was trying to figure out, you know, where do the Jane Austin stories that I love stack up against the Victorian era?
• 9:26
  Speaker 1: How do these things time out?
• 9:27
  Speaker 1: So, yeah, super nerd.
• 9:29
  Speaker 1: I'm sorry.
• 9:30
  Speaker 1: Did you not know you were listening to a super nerd?
• 9:32
  Speaker 1: You are.
• 9:33
  Speaker 1: Okay.
• 9:34
  Speaker 1: So of course I use spreadsheets to keep track of my own and my clients remodeling work.
• 9:39
  Speaker 1: And this is actually something that contractors and architects worth their salt are going to do exactly the same thing.
• 9:45
  Speaker 1: I have a range of these available as a bonus that I share with my design clients.
• 9:49
  Speaker 1: So they can keep track of these things to themselves after we've done our master plan.
• 9:52
  Speaker 1: And these are available to my students inside of ready to remodel.
• 9:55
  Speaker 1: This set of sheets includes a project bid form, which you can use to either request that your contractor fill in, or they usually won't want to do that.
• 10:05
  Speaker 1: Contractors, especially small scale residential remodel error are not generally spreadsheet people we're talking about who is, and who is not a spreadsheet person, but you can work with them to fill in a spreadsheet with the data they give you.
• 10:17
  Speaker 1: And then you can use the bid comparison form to compare apples to apples and make sure that each contractor you've talked to is covering the same things and is giving you roughly the breakdown of numbers for the areas of work that you wanna do, or for the types of work electrical versus plumbing versus framing.
• 10:35
  Speaker 1: And then you can set a with an apples to apples comparison.
• 10:40
  Speaker 1: I love you contractor.
• 10:41
  Speaker 1: Number two, you are a great communicator and everything else about you is great, but your electrical bid is about twice as high as everyone else's.
• 10:47
  Speaker 1: Can you talk to me about that?
• 10:49
  Speaker 1: Are you seeing something that I'm not seeing, that the other contractors aren't seeing or what's going on?
• 10:53
  Speaker 1: Could we talk about a different electrical subcontractor?
• 10:56
  Speaker 1: This kind end of data takes the drama out of price and helps you control how these conversations go?
• 11:04
  Speaker 1: What else falls into this collection of spreadsheets that I keep handy, um, project scope.
• 11:08
  Speaker 1: Now that doesn't necessarily have to fall into a spreadsheet.
• 11:10
  Speaker 1: It could be a simple list, but when you put something into one spreadsheet, you can make another tab and another tab and keep them all together, a master list for your remodel.
• 11:20
  Speaker 1: In addition to scope, I actually sometimes just have to have like to have a call log for each of the contractors that I've been in communication with mark them down as a JC, an electrician, a plumber, HVAC, where they came from their contact information, their initial estimate, what they've told me about updated scope.
• 11:37
  Speaker 1: When I, to them, what we talked about.
• 11:39
  Speaker 1: If I have follow up information, putting all this stuff down somewhere, it might be for you a notebook for me.
• 11:46
  Speaker 1: I love the spreadsheet format allows me to go to one spot and get that information at a glance.
• 11:53
  Speaker 1: I should say before I go any further, I like to use Google spreadsheets for this.
• 11:58
  Speaker 1: Now, if you are a Mac person, you might like numbers.
• 12:01
  Speaker 1: If you're a PC Excel, these inbuilt spreadsheet programs are great and they might be what you have easiest access to.
• 12:08
  Speaker 1: But at some point during your remodel, you're going to need to share information with someone.
• 12:12
  Speaker 1: And it can be very helpful to share a document with a spouse or partner to share a document with a designer, or to share a contractors tracking log directly.
• 12:23
  Speaker 1: Then both of you can get access to the file at the same time, both of you can make edits to it.
• 12:27
  Speaker 1: Both of you can see what's happening in it.
• 12:29
  Speaker 1: It's really useful for any part of the project that you're tracking over time or that you're comparing one thing to another, or that you're aggregating multiple data points together.
• 12:38
  Speaker 1: It's very helpful to have a spreadsheet.
• 12:41
  Speaker 1: One of the most useful places to use a spreadsheet is for what architects and contractors call a schedule.
• 12:47
  Speaker 1: Um, in this case they don't actually mean when something they will happen.
• 12:50
  Speaker 1: They mean a spreadsheet.
• 12:51
  Speaker 1: And honestly, for the life of me, I have no, no idea why we call these schedules, but we do.
• 12:56
  Speaker 1: So we will, uh, for a detailed architecture design, prepare lighting schedules, fix your schedules, finish schedules, door and window schedules.
• 13:06
  Speaker 1: These mean basically separate spreadsheets, which are linked to a tag.
• 13:12
  Speaker 1: And then talk about the various tales of each product finish or appliance.
• 13:17
  Speaker 1: That's going to be included in the house.
• 13:20
  Speaker 1: Let's take for example, a finished schedule.
• 13:23
  Speaker 1: So in your style guide, you might say that all of the metal you're going to choose for the house is either going to be brass or white.
• 13:35
  Speaker 1: That's a fun set of choices that are both very contemporary and trendy, and also tie back to the mid-century era of your house, win, win.
• 13:45
  Speaker 1: So now you know that as you start to look for other things that you need to pick out for your remodel, you're gonna start to make choices.
• 13:53
  Speaker 1: So for example, you're gonna have to pick a kitchen sink faucet.
• 13:57
  Speaker 1: You might choose a brass one.
• 13:59
  Speaker 1: That's a great choice.
• 14:00
  Speaker 1: It's not just going to look snazzy.
• 14:02
  Speaker 1: It's going to dramatically narrow down the number of possibilities you have when you go to home Depot, or when you go online to a website like build.com and start selecting from all possible kitchen sink faucets.
• 14:14
  Speaker 1: As you make your choices, you, you might be comparing one to another and still keep a couple of options open.
• 14:18
  Speaker 1: Or you might just pick one and you might say, I'm gonna pick a moan faucet.
• 14:22
  Speaker 1: It's gonna be a pull down spray style.
• 14:24
  Speaker 1: It's from the align line.
• 14:26
  Speaker 1: And it's actually gonna be brushed gold, but it's gonna look bras because moan is crazy and they call brush gold something.
• 14:32
  Speaker 1: It looks like bras, and I'm gonna choose just one of them.
• 14:35
  Speaker 1: I only have one kitchen's sink and the price will be this.
• 14:37
  Speaker 1: Then you can put all of that data, the object it's a kitchen sink faucet.
• 14:42
  Speaker 1: The manufacturer moan the specification align, pull down spray faucet, product number 7, 5, 6, 5 BG, finish brushed gold.
• 14:51
  Speaker 1: There's one in the unit.
• 14:53
  Speaker 1: Count the price there.
• 14:54
  Speaker 1: You've got it.
• 14:55
  Speaker 1: And a link to that purchase spot.
• 14:58
  Speaker 1: All of this is put together.
• 15:00
  Speaker 1: You can go ahead and do that for all the different plumbing fixtures, all the different appliances, all the different flooring and wall materials, all the different paint, colors, all the different other surfaces, counters, mirror, uh, shelves, cabinet faces, and hardware.
• 15:16
  Speaker 1: You can make all of the choices at once.
• 15:18
  Speaker 1: You can make a list of all the things you'll need to choose and choose them over time.
• 15:21
  Speaker 1: You can fill in the blanks as you go, and you can use your spreadsheet to highlight and yellow.
• 15:25
  Speaker 1: I haven't chosen this yet.
• 15:26
  Speaker 1: And at some point soon, the contractor's gonna need that choice for me.
• 15:30
  Speaker 1: The, what you can often do.
• 15:32
  Speaker 1: If you're making choices like this, if you have specificity like this, before you talk to your contractor is show them that, you know, these things about your remodel.
• 15:40
  Speaker 1: This will actually really help them to price with more confidence.
• 15:44
  Speaker 1: Most contractor pricing is based on labor and materials and their labor cost will be their estimate of how long they think it's gonna take them to do it.
• 15:51
  Speaker 1: And their material cost will be the price that they think they can get for all of the various raw materials.
• 15:57
  Speaker 1: But they'll often leave a third category known as an allowance for specific choices like your kitchen sink faucet, like the light fixtures you're gonna choose, not necessarily the can lights or the, um, sort of functional, but for any beautiful surface Mount fixture you're gonna choose.
• 16:15
  Speaker 1: And those things can actually add up to a lot of the cost of a remodel, which you don't see in the contractor's bottom line, because they've left that out as an allowance.
• 16:23
  Speaker 1: It's not a trick.
• 16:24
  Speaker 1: It's just the, the necessary way that this planning process goes.
• 16:27
  Speaker 1: But for you, you can fill in that blank even before you've talked to a contractor, perhaps, or only as you go along the way with your own confident list, your allowance pricing, and the more that you've made confident decisions about materiality, about some of the things that will be wrapped into the contractor's number, the more that they know that you're gonna be the kind of person to work with, who's going to be clear, concise, and decisive, and they can then give you a really tight price.
• 16:53
  Speaker 1: That's accurate as much as possible, rather than one, that's got a little bit more squish in it.
• 16:57
  Speaker 1: And the squish is for the contractor's sake, always gonna have to make the price go up.
• 17:01
  Speaker 1: There's a lot.
• 17:02
  Speaker 1: You can win both in your own piece of mind, your own organization, and in the way that you relate to the people that are gonna do the work on your house for you, or if you're gonna do it, the simplicity doing the work on the day with the decisions made in advance, rather than realizing it's time to install a faucet and then realizing you have to go and pick one while your brain was in production mode, that's never a great place to be.
• 17:27
  Speaker 1: Once you've got your style guide in place, you can start to create a spreadsheet, a schedule, um, that put together all of the details that you're going to do, keep track of what you want to do.
• 17:38
  Speaker 1: And then what you've decided to do as you go through the remodel in the end, basically all of this can add up to the budget of what you spent in your remodel.
• 17:47
  Speaker 1: It's useful at every stage of the process.
• 17:50
  Speaker 1: The one thing I just wanna keep emphasizing as I talk about how wonderful and useful it is to make spreadsheets to track your remodel is you have to start from the big picture and then focus in to get to your confident product, byproduct decisions, start with your style guide, and then work your way down to spreadsheets to track it.
• 18:08
  Speaker 1: Every product you choose.
• 18:10
  Speaker 1: I hope I've gotten you thinking a little bit more positive and in control thoughts about how you're going to run your remodel, keeping track of things in a spreadsheet.
• 18:20
  Speaker 1: If you're not a spreadsheet, person can feel tedious, but if you are one and even if you aren't, it is so empowering to see all of the data laid out in front of you, pulling everything together in one place also helps externalize it.
• 18:32
  Speaker 1: So if you're the kind of person who's been holding your whole remodel in your head, it can often be very hard to then share that information with your partner or with your team putting it onto, well, I was gonna say putting it on paper, keeping a digital record of it is gonna allow you to make this information so much more available to everyone that's involved in the process.
• 18:50
  Speaker 1: If you're curious about the exact way in which I use spreadsheets, and I advise my students and clients to manage their remodels with spreadsheets, you'll want to know more about the next launch of ready to remodel.
• 19:01
  Speaker 1: Enrollment is gonna be reopening in March.
• 19:05
  Speaker 1: Feels like moments from now.
• 19:06
  Speaker 1: Um, so put your name on the wait list for the ready to remodel reopen.
• 19:11
  Speaker 1: I'm gonna be talking about this and so much more ways to cleverly manage your remodel so you can plan and execute the exact right remodel for you, your family and your house, total sidebar.
• 19:22
  Speaker 1: If you happen to know why a remodeling spreadsheet is called a schedule, send me a DM on Instagram and let me know I am fast and it, by this and a cursory, Google did not answer the question for me.
• 19:34
  Speaker 1: So, um, it remains a mystery to me.
• 19:37
  Speaker 1: I love them no matter what they're called, I hope that you will try using spreadsheets more to manage your remodel.
• 19:43
  Speaker 1: Give me a shout out and let me know if you prefer to manage your details on paper in an old fashioned notebook, or if you have another method for keeping track data outside of spreadsheets or something I've mentioned, I would love to hear about it Next week on the podcast, we're gonna be taking our focus from this sort of middle development phase of the remodel all the way back to the beginning and talking about how you can meet yourself, where you are, whether you're planning a giant change, everything contract or remodel, or whether you're thinking, can I change my house?
• 20:14
  Speaker 1: How could I change my house?
• 20:15
  Speaker 1: What one thing could I change about my house?
• 20:17
  Speaker 1: I'm really excited to talk about this with you, because I feel like it's so important to emphasize the accessibility of home improvement at whatever level you're ready to get started.
• 20:26
  Speaker 1: You can make a change to your home that will transform the way you feel about it and empower you to make more changes in the future.
• 20:32
  Speaker 1: So we'll talk about that next week.