In this weeks tip we will walk through how to create an Excel production tracking tool. It's a great way for you to track units of production, create a graph that gives you or your subcontractor a visual letting them know if they are ahead or behind, it's a great scheduling tool thats simple to set up and start using.
In this week's tip we want to show you how to accurately figure concrete for a slab on metal deck pour. There is a formula and we want to show you what the formula is and how to set up an excel spreadsheet so you can quickly and accurately figure concrete for a slab on metal deck pour.
Step One: Enter description into A Column rows 1-10
Step Two: Understand the descriptions
So in column A of the spreadsheet the slab length (1) and slab width (2) are the overall dimensions of the slab you are going to place. #3-7 are shown above to help you figure out what dimensions you need. #8 is if you are pouring your slab to elevation (there is a link below to a free training course that guides explains the difference between pouring to thickness and pouring to elevation, it's free so check it out). #10 is what you are trying to calculate the total cubic yards for the slab placement, this will be shown in the video's below.
Step Three: Will show you two ways to enter the formula in excel.
So once you have completed step one above and created your spreadsheet and entered the descriptions in column A rows 1-10. Also, you understand the dimensions needed as shown in step two above, then go to step three option one then option two to enter the formula needed to calculate slab on metal deck,
Option One: Will show you the formula by entering text.
Option Two: Will show you the formula by clicking the cells to enter into the formula.
We hope you have now created a spreadsheet to help you figure concrete for slab on metal deck, and as talked about in the videos above the link for a free course on what you need to know before you place slab on metal deck is below, so check it out today!
Here is a free Spreadsheet to download and enter your S.O.M.D Quantities
Check out Construct-Ed newest Free Course on what you need to know before placing your next metal deck.
Construction How To's
Have and Idea for Tip? Send it here