{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Calculator","Instructions","Info","404","Quote","Project Pricing","Variables","Settings"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":895,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[37,0,37,7],[38,0,38,7],[39,0,39,8],[41,0,41,10],[0,0,0,10],[1,0,1,10],[2,0,2,10],[4,0,4,10],[36,0,36,8]]}
[]
[]
["Import CSV button will import data from STACK. Reset From button deletes everything. Gray data fields from STACK are locked, white fields are editable."]
["Project Notes"]
[]
[]
[]
["Material"]
["Name","Cost Type","Unit Cost","Qty","Unit","Waste","Adjusted Qty","Adjusted Cost","Markup","Total","Notes"]
["Ice & Water Shield","Material",80,505,"Roll",0,{"$f":"ROUND($D10*(1+$F10),2)","v":505},{"$f":"(1+$F10)*$C10*$G10","v":40400},0,{"$f":"$H10*(1+$I10)","v":40400}]
["Seam Plate. 2-3/8\" Dia. - 1000 Count","Material",45,10,"Pails",0,10,450,0,450]
["4 in #14 All Purpose Fasteners - 1000 Count","Material",136.94999999999999,10,"Pails",0,10,1369.5,0,1369.5]
["Single Ply LVOC Splice Wash 3 Gal","Material",131.22,13,"Pails",0,13,1705.86,0,1705.86]
["Single-Ply LVOC Bonding Adhesive 5 Gal","Material",120,450,"Pails",0,450,54000,0,54000]
["Insulation Plate. 3\" Dia. - 1000 Count","Material",115.28,30,"Pails",0,30,3458.4,0,3458.4]
["TPO 10'x100' .060 mil","Material",104,101,"Rolls",0,101,10504,0,10504]
["4 in #12 All Purpose Fasteners - 1000 Count","Material",118,30,"Pails",0,30,3540,0,3540]
["Fiber Glass Reinforced Base Sheet (CA) (HA)","Material",41.37,681,"Rolls",0,681,28172.969999999998,0,28172.969999999998]
["Polyiso Board 4' x 8' x 3\"","Material",29.33,3160,"Boards",0,3160,92682.799999999988,0,92682.799999999988]
["Insulation Adhesive 5-Gal Box","Material",350,92,"Boxes",0,92,32200,0,32200]
["Glass-Mat Roof Board 4'x8'x0.25\"","Material",18.149999999999999,3160,"Sheets",0,3160,57353.999999999993,0,57353.999999999993]
["Glass-Mat Roof Board 4'x8'x0.5\"","Material",21.34,3160,"Sheets",0,3160,67434.399999999994,0,67434.399999999994]
[null,null,null,null,null,null,null,"Tax",0,{"$f":"SUM($J8:$J22)*$I23","v":0}]
[null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM($J8:$J23)","v":393271.92999999993}]
["Labor"]
["Name","Cost Type","Unit Cost","Qty","Unit","Waste","Adjusted Qty","Adjusted Cost","Markup","Total","Notes"]
["TPO Roof - Area","Labor",45,917.3792201,"Squares",0,{"$f":"ROUND($D27*(1+$F27),2)","v":917.38},{"$f":"(1+$F27)*$C27*$G27","v":41282.1},0,{"$f":"$H27*(1+$I27)","v":41282.1}]
[null,null,null,null,null,null,null,"Tax",0,{"$f":"SUM($J25:$J27)*$I28","v":0}]
[null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM($J25:$J28)","v":41282.1}]
["Miscellaneous"]
["Name","Cost Type","Unit Cost","Qty","Unit","Waste","Adjusted Qty","Adjusted Cost","Markup","Total","Notes"]
[null,null,null,null,null,null,{"$f":"ROUND($D32*(1+$F32),2)","v":0},{"$f":"(1+$F32)*$C32*$G32","v":0},null,{"$f":"$H32*(1+$I32)","v":0}]
[null,null,null,null,null,null,null,"Tax",0,{"$f":"SUM($J30:$J32)*$I33","v":0}]
[null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM($J30:$J33)","v":0}]
[]
[]
["Subtotal",null,null,null,null,null,null,null,null,{"$f":"$J24 + $J29 + $J34","v":434554.02999999991}]
["Overhead",null,null,null,null,null,null,null,0.1,{"$f":"$J37*$I38","v":43455.402999999991}]
["Profit Margin",null,null,null,null,null,null,null,0.15,{"$f":"($J37+$J38)*$I39/(1-$I39)","v":84354.605823529389}]
["Total Project Cost",null,null,null,null,null,null,null,null,{"$f":"SUM($J37:$J39)","v":562364.03882352926}]
[]
["STACK Construction Technologies is not responsible for ensuring the accuracy and completeness of this report. Results are not guaranteed."]

{"sheet":"Instructions","index":1,"n_rows":113,"n_cols":1,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
["Getting Started Guide"]
[]
["STACK Project Cost Calculator Version # 1.4.2"]
[]
["Support Resources:"]
["STACK Support Page"]
["Phone: 866-702-6078"]
["Free Trial of STACK"]
[]
["Introduction:"]
["The STACK Project Cost Calculator is used by contractors and construction estimators to estimate the total project cost including project specific pricing, markup, overhead, and profit. "]
[]
["The STACK Project Cost Calculator spreadsheet will import any CSV file exported from the STACK Reports page using the Export to Excel button.  We recommend using the Items by Type Report as the best starting point for most STACK Pro users.  This report displays unit cost grouped by cost types including material, labor and equipment and can be further organized by area or phase using label groups.  "]
[]
["If you're a STACK Plus user or you're just looking for a simpler estimate based on the price per foot method, the Takeoff Quantity Report is a good starting point.  This report displays cost for each takeoff condition and is the simplest method for calculating project cost."]
[]
["Getting Started:"]
["After completing your takeoff using STACK Plus or Pro go to the reports page, select a report and click the Export To Excel button.  This creates a CSV file in your downloads folder with a name like ItemCostByTypeReport.csv which can be imported into the Project Cost Calculator Spreadsheet."]
[]
["Open the STACK Project Cost Calculator spreadsheet.  When prompted, click the Enable Macros button.  Macros are necessary for the spreadsheet work properly.  "]
[]
["Click the Enable Content button when the Security Warning appears.  This gives excel permission to display your takeoff report data in this sheet."]
[]
["If you're starting fresh and you want to be sure your estimate is based on new pricing data, click the Reset Form button at the top of the spreadsheet.  This will erase all the information in the form and reset all you values to zero."]
[]
["Click the Import CSV button at the top of the page, navigate to your downloads folder and select the report.  This will populate the spreadsheet with the takeoff quantities and cost information from the selected STACK Report."]
[]
["If your QTYs change in STACK, simply re-export the file and repeat the Import CSV process to update your values in the spreadsheet."]
[]
["The Round Up button found on the Calculator page above the Adjusted Qty column gives you the opportunity to round these quantities up to the nearest whole number. This will update your Adjusted Cost and Total amounts."]
[]
["The Quote tab offers a template project cost proposal. Clicking the Update Quote button below the Total Project Cost on the Calculator tab will pull data from the Calculator tab over to the Quote. However, Overhead and Profit Margin will not be present. These costs are distributed amongst the items to keep the same project total."]
[]
["Use the Export Quote button on the bottom of the Quote tab to save your quote separately. Currently only saving to PDF is supported."]
[]
["Information about your company can be entered into the Info tab. This information will be used to populate the Quote with your information and will not be erased by the Reset Form button."]
[]
["You may upload your company logo to replace the Stack logo on the Quote tab by clicking the Upload Your Logo button on the Info tab."]
[]
["You may set a custom color by clicking the Set Custom Color button on the info tab. Note: This will update the Quote tab and overwrite any customization that has been done by the user. It is recommended that any color choice be made prior to customizing your Quote."]
[]
["Frequently Asked Questions"]
["Q: How do I enter a fraction of a percent?  "]
["A: Excel treats whole numbers as a percentage so the number 10 is understood as 10%.  In cases where you would like to have a fraction of a percent you must enter a leading zero and a decimal.  For example, if you enter 0.15 it will be treated as 0.15%.  "]
[]
["Q: How do I clear my project pricing and other data?"]
["A: Clicking the Reset Form button will clear the page and remove all stored data."]
["Clicking the Import CSV button will update QTYs from the selected STACK report file."]
[]
["Q: How do I update my QTYs without effecting the prices I’ve already entered?"]
["A: Clicking the Import CSV button will update QTYs from the selected STACK report file without overwriting the project prices you’ve already entered."]
[]
["Q: Why can’t I change my item name, label group or QTY, etc?"]
["A: The grey columns are locked to prevent changes to data provided from  your STACK Report.  White columns are open for changes."]
[]
["Q: What’s wrong with my waste factor?"]
["A: If you add a waste factor in the assembly settings during your takeoff, you should leave the waste factor in the spreadsheet at zero.  Having the waste factor set in both locations inflate your costs.  "]
[]
["Q: How do I manage my project pricing in the spreadsheet?"]
["A: STACK Catalog pricing data will be imported from STACK and will appear under Unit Cost in the Project Cost Calculator spreadsheet where available.  In cases where there are no prices stored in STACK, the Unit Cost will appear as $0.00."]
["Prices entered on the Project Cost Calculator spreadsheet are stored locally and have no effect on your STACK items database.  Prices only need to be entered once per item to appear everywhere in the sheet.  The Project Cost Calculator Spreadsheet will remember your project prices even when you update the QTYs from STACK.  "]
["Manually entered Unit Costs are displayed in bold."]
[]
["Column Headings and Definition of Terms:"]
["Label1 (Optional) - If you group your report in STACK the primary grouping label will appear here."]
[]
["Label 2 (Optional) -  If you group your report in STACK the secondary grouping label will appear here."]
[]
["Name - On the Takeoff Quantity Report, the name of the Takeoff Condition will appear in this column.  For any of the Item reports the name of the Item will appear in this column."]
[]
["Cost Type - Only the Item Cost by Type Report will include a cost type column.  Cost types include Material, Labor, Subcontractor, Equipment and other.  You can create custom cost types in your STACK Account Settings and the custom cost types will appear here."]
[]
["Unit Cost -  The purchase price for materials and services expressed in dollars.  Defaults to zero if there are no STACK Catalog Prices available.  Unit cost is an editable field, the spreadsheet will remember your prices and update all occurrences when you refresh the CSV file.  To clear the Unit Cost, click the Reset Form button."]
[]
["QTY - Measured values from your STACK Takeoff.  You can re-import the STACK report to update QTYs on the Project Cost Calculator Spreadsheet by clicking the Import CSV button."]
[]
["Units - The units of measure associated with the QTY."]
[]
["Waste - The percentage of additional material needed in excess of the estimated quantitiy required for construction.  Only use the Project Cost Calculator Spreadsheet waste factor if you have NOT already used the waste factor on your Assembly.  Entering the waste factor in both places will result in excessive project totals."]
[]
["Adjusted QTY - Combines the QTY and the Waste factor."]
[]
["Adjusted Cost - Unit Cost times the Adjusted QTY."]
[]
["Markup - The percent difference between cost and the sale price for goods and services required for construction.    "]
[]
["Total - Adjusted Cost including Markup."]
[]
["Overhead - The ongoing cost of running your business that can’t be easily traced back to a project. For example the rent for office space or payroll services.  Overhead is calculated as a percentage of the subtotal of the project cost."]
[]
["Profit - The income generated for the business owner over and above the project cost.  "]
[]
["Tax - Mandatory charges imposed by the government.  Expressed as a percentage of material cost."]
[]
["Insurance - Workers' compensation is a form of insurance providing wage replacement and medical benefits to employees injured in the course of employment.  Expressed as a percentage of labor cost."]
[]
["Supported file types:"]
["The Project Cost Calculator spreadsheet currently supports any CSV Export from STACK but we recommend Basic and Plus accounts use the Takeoff Quantity Report and Pro accounts use the Item Cost by Type Report."]
[]
["Takeoff Quantity Report provides a list of Takeoff Conditions with their primary quantities and units and can be used to do simple estimates based on cost per foot calculations. This is the recommended file format to use for both Basic and Plus accounts."]
[]
["Item Cost By Type Report provides a list of items (material and labor) with their quantities and units"]
[]
["Takeoff Summary Report is similar to the Takeoff Quantity report but includes 5 different QTYs for each Takeoff Condition.  This report is useful for some trades  which may need more than one measurment for the same takeoff condition, for example the area for a mulch bed and the perimeter for the edging.  It’s not suitable for the Project Cost Calculator because there is not enough information provided to resolve which of the 5 QTYs should be used to calculate the cost."]
[]
["Geometry by Takeoff Report is a detail report based on the Takeoff Summary Report and includes a clickable link for each geometry associated with a Takeoff Condition.  This level of detail is usually not recommended for calculating project cost."]
[]
["Item list report - is an out-dated format developed on the way to Item Cost by Type Report.  "]
["It should be a report that you could send to a supplier but it doesn’t really do that.  Needs to be broken out by the cost type to be effective."]
[]
["Item Cost Report is an out-dated format that was replaced by the Item Cost by Type Report. It's not recommended for calculating project cost because it combines material and labor into a single line item.  "]
[]
["Item Cost by Takeoff Report rolls up your cost to each individual condition rather than the project as a whole. Lacks important information from the Takeoff Quantity Report including the QTY and Units for the Takeoff Condition."]

{"sheet":"Info","index":2,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,0,7,2],[0,0,2,2],[19,0,19,1],[21,2,21,8],[8,0,8,1],[9,0,17,0],[18,0,18,1]],"read":"row_number_cap"}
["Quote Information:"]
[]
[]
["Data stored here will be preserved and populated on your Quote every time you use the \"Update Quote\" button on the Calculator Tab. Use the upload button below to replace the StackCT Logo with your own, and the Set Custom Color button to replace the default Stack CT green with your own custom color!"]
[]
[]
[]
[]
["Quote Title",null,"Quote from Your Company"]
["Prepared By:","Name"]
[null,"Company Name","Stack CT"]
[null,"Street Address","6398 Thornberry Ct"]
[null,"City","Mason"]
[null,"State","Ohio"]
[null,"Zip Code",45040]
[null,"Country","United States"]
[null,"Phone Number","(000) 111-2222"]
[null,"Fax","(000) 111-2222"]
["Terms & Conditions",null,"This Quote operates under ___ terms and ___ conditions."]
["Footer Text",null,"--optional footer text--"]

{"sheet":"404","index":3,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[[3,0,3,8],[1,0,1,8],[2,0,2,8]]}
[]
["This spreadsheet requires macros and therefore is not supported for use with Excel Online."]
["If you are using a desktop version of Excel, enable macros and reopen this workbook."]

{"sheet":"Quote","index":4,"n_rows":80,"n_cols":6,"rows_kept":80,"cut":false,"hidden":false,"merged":[[26,1,26,5],[27,1,27,5],[28,1,28,5],[29,1,29,5],[66,1,66,5],[0,1,0,5],[6,1,6,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[24,1,24,5],[25,1,25,5],[67,1,67,5],[68,1,68,5],[69,1,69,5],[70,1,70,5],[71,1,71,5],[79,1,79,5]]}
[null,"Quote from Your Company"]
[null,null,null,null,"Date:","2018-08-08"]
[null,null,null,null,"Quote #:"]
[null,null,null,null,"Customer ID:"]
[null,null,null,null,"Expires:"]
[]
[null,"Project Title"]
[]
[]
[null,"Prepared By:",null,null,"Customer Information:"]
[]
[]
[null,"Stack CT"]
[null,"6398 Thornberry Ct"]
[null,"Mason, Ohio 45040"]
[null,"United States"]
[]
[null,"T: (000) 111-2222"]
[null,"F: (000) 111-2222"]
[]
[]
[]
[null,"Description of Work"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Itemized Cost"]
[]
[null,"Material"]
[null,"Name","Cost Type","Qty","Unit","Total"]
[null,"Ice & Water Shield","Material",505,"Roll",52282.352938988966]
[null,"Seam Plate. 2-3/8\" Dia. - 1000 Count","Material",10,"Pails",582.35294115210479]
[null,"4 in #14 All Purpose Fasteners - 1000 Count","Material",10,"Pails",1772.2941175729056]
[null,"Single Ply LVOC Splice Wash 3 Gal","Material",13,"Pails",2207.5835293193986]
[null,"Single-Ply LVOC Bonding Adhesive 5 Gal","Material",450,"Pails",69882.352938252574]
[null,"Insulation Plate. 3\" Dia. - 1000 Count","Material",30,"Pails",4475.5764704009762]
[null,"TPO 10'x100' .060 mil","Material",101,"Rolls",13593.41176413713]
[null,"4 in #12 All Purpose Fasteners - 1000 Count","Material",30,"Pails",4581.1764703965582]
[null,"Fiber Glass Reinforced Base Sheet (CA) (HA)","Material",681,"Rolls",36459.137645533367]
[null,"Polyiso Board 4' x 8' x 3\"","Material",3160,"Boards",119942.44705380511]
[null,"Insulation Adhesive 5-Gal Box","Material",92,"Boxes",41670.58823355061]
[null,"Glass-Mat Roof Board 4'x8'x0.25\"","Material",3160,"Sheets",74222.823526306267]
[null,"Glass-Mat Roof Board 4'x8'x0.5\"","Material",3160,"Sheets",87268.04705517221]
[null,null,null,"Tax",0,0]
[null,null,null,null,"Subtotal",508940.14]
[null,"Labor"]
[null,"Name","Cost Type","Qty","Unit","Total"]
[null,"TPO Roof - Area","Labor",917.3792201,"Squares",53423.894115411786]
[null,null,null,"Tax",0,0]
[null,null,null,null,"Subtotal",53423.89]
[null,"Miscellaneous"]
[null,"Name","Cost Type","Qty","Unit","Total"]
[null,null,null,null,null,0]
[null,null,null,"Tax",0,0]
[null,null,null,null,"Subtotal",0]
[]
[]
[null,"Total Project Cost",null,null,null,562364.03882352926]
[]
[null,"Terms & Conditions"]
[]
[null,"This Quote operates under ___ terms and ___ conditions."]
[]
[]
[]
[]
[]
[]
[null,"Acceptance"]
[]
[]
[null,"X"]
[null,"Signature",null,null,null,"Date"]
[]
[null,"--optional footer text--"]

{"sheet":"Project Pricing","index":5,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Overhead",0,0,0.1,false]
["Profit Margin",0,0,0.15,false]

{"sheet":"Variables","index":6,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[43,"numrows","Name",1]
[11,"numcols","Cost Type",2]
[10,"extcol","Unit Cost",4]
[3,"unitcostcol","Qty",5]
[4,"qtycol","Unit",10]
[8,"subtotalcol","Waste"]
[6,"wastecol","Adjusted Qty"]
[9,"markupcol","Adjusted Cost"]
[11,"notescol","Markup"]
[9,"last_overhead_col","Total"]
[9,"last_profitmargin_col","Notes"]
[7,"modqtycol"]
[1,"namecol"]
["/Users/justinogilby/Desktop/TradeSpecificPCCs/CSVs/ROOF TPO  ItemCostByTypeReport.csv","strFile"]
[37,"bottom_section_row_start"]
[5,"uomcol"]
[33,"add_item_button_row"]
[41,"bid_report_button_row"]

{"sheet":"Settings","index":7,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
["data_start",8]
["bordergray",239,239,239]
["blue",6,136,148]
["darkgray",64,64,64]
["lightgray",172,172,172]
["white",255,255,255]
["green",14,140,98]
["green-defaultStackCT",14,140,98]