{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Hidden","Check Sheet","Scope of Work","Paint Calculator"],"not_rendered":{"charts":0,"images":65,"macros":1,"external_links":0,"defined_names":29,"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":"Hidden","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Facilities",null,"Facilities"]
["Remodel",null,"Remodel"]
["N/A",null,"N/A"]
[]
[]
["Yes"]
["No"]
["N/a"]
[]
[]
[]
[{"$f":"IF('Check Sheet'!E72=TRUE, 1, \"\")","v":""},{"$f":"IF('Check Sheet'!F72=TRUE, 1, \"\")","v":""},{"$f":"IF('Check Sheet'!F30=TRUE, 1, \"\")","v":""},{"$f":"IF('Check Sheet'!F31=TRUE, 1, \"\")","v":""}]

{"sheet":"Check Sheet","index":1,"n_rows":93,"n_cols":6,"rows_kept":93,"cut":false,"hidden":false,"merged":[[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[58,0,61,2],[32,0,33,0],[39,1,39,2],[24,1,24,2],[47,1,47,2],[54,0,57,2],[50,0,53,2],[60,4,60,5],[61,4,61,5],[0,0,0,5],[1,0,1,5],[19,1,19,2],[9,4,9,5],[18,1,18,2],[17,4,17,5],[16,3,16,5],[8,4,8,5],[16,0,16,2],[7,0,7,5],[2,0,2,2],[20,4,20,5],[13,3,15,5],[90,3,93,5],[77,1,77,2],[62,0,62,2],[90,0,93,2],[62,3,62,5],[89,0,89,2],[89,3,89,5],[74,1,74,2],[79,0,84,2],[86,3,88,5],[85,0,85,5],[68,1,68,2],[80,3,84,5],[36,5,37,5],[32,1,33,1],[32,2,33,2],[32,3,33,3],[32,4,33,4],[36,3,37,3],[36,4,37,4],[36,1,36,2],[34,0,35,2],[32,5,33,5]]}
[]
["REMODEL Check Sheet 2019"]
["Store Number:"]
["Street Address:"]
["City, State:"]
["Date Prepared:"]
["Prepared By:"]
["EXTERIOR BUILDING & PARKING LOT"]
["Are all Pylon signs fully functional?",false,false,"Pavement Type:"]
["Are all Building signs fully functional?",false,false,"General Parking Lot Condition:"]
["Are all pole lights functioning properly?",false,false,"Are there any large potholes/cracks in the pavement?",false,false]
["Are Canopy lights functioning properly?",false,false,"Is parking striping visible?",false,false]
["Number of bollards that need to be repainted? ",null,"#","How many missing or damaged handicap signs?",null,"#"]
["Is there a security light above receiving door?",false,false,"Comments: "]
["Are all exterior security lights working properly?",false,false]
["Is there a door buzzer at receiving area door?",false,false]
["SALES FLOOR",null,null,"ELECTRICAL"]
["Is there existing window tint or covering?",false,false,"Existing Phasing"]
["Are bulbs T-8 or T-12?",null,null,"Existing Amperage",null,"amps"]
["Select bulb row configuration:",null,null,"Is the electrical panel labeled legibly and correct?",false,false]
["Number of ballasts to replace:",null,"#","What is the Brand of Elec. Panels?"]
["Number of bulbs to replace:",null,"#","List number of open circuits. (existing)",null,"#"]
["Number of Security Mirrors attached to wall.",null,"#","Are breaker locks installed?",false,false]
["Are cash-wrap counter tops stainless steel?",false,false,"Emergency lights repaired/replaced-",null,"#"]
["Ceiling Type:",null,null,"Exit lights that need to be repaired/replaced-",null,"#"]
["Ceiling Tile Size:",false,false,"Exit combo lights repaired/replaced-",null,"#"]
["Ceiling Height:",null,"FT","Does store have operational EMS?",false,false]
["Amount of ceiling tile to replace:",null,"SF","Is EMS DG specified model?",false,false]
["Number of linear feet of ceiling grid to replace:",null,"LF","Is there an exterior outlet for ice machine?",false,false]
["Number of diffusers that require cleaning:",null,"#","Is there an exterior outlet for soda machine?",false,false]
["List # of thermostats/temp sensors to relocate (<7'AFF a/o attached to power poles).",null,"#","Is there an interior Ice Machine?",false,false]
["Is there pegboard on any walls? If so, list location and amount in comments section below.",false,false,"Number of Cash Registers",null,"(1-4)"]
["Are there any large holes in the walls? (Baseball size or larger)",false,false,"Select power source and # of circuits for existing pole at Register (Circuit nearest registers)"]
[]
["Comments:",null,null,"Select power source and # of circuits for existing pole at Low Drink Coolers (Circuit nearest drink coolers) Panduit supplied by pole"]
[null,null,null,"Select power source and # of circuits for existing pole at Island Register (Circuit nearest island register)"]
["Type of wall covering:",null,null,"Select power source and # of circuits for existing pole at Low Drink Cooler (Circuit nearest island register)"]
["Sales Floor paint required:(From Paint Calc. Doc cell O22) ",{"$f":"'Paint Calculator'!O22","v":0},"SF"]
["Number of columns in the sales area?",null,"#","Number of DG Cooler Doors?",{"$f":"SUM(F41:F46)","v":0},"#"]
["Floor Finish?",null,null,"Number of DG Freezer Doors?",{"$f":"SUM(F47:F52)","v":0},"#"]
["Amount of floor tile to replace:",null,"SF","Cooler unit 1 Power Source"]
["Amount of cove base to replace:",null,"LF","Cooler unit 2 Power Source"]
["Are there existing automatic doors?",false,false,"Cooler unit 3 Power Source"]
["Number of cart guards missing. (Should be one per side of each store front door in use)",null,"#","Cooler unit 4 Power Source"]
["How many sets of Single door seals and sweeps need to be replaced? (exterior doors only)",null,"#","Cooler unit 5 Power Source"]
["How many sets of Double door seals and sweeps need to be replaced? (exterior doors only)",null,"#","Cooler unit 6 Power Source"]
["Are there any active roof leaks?",false,false,"Freezer unit 1 Power Source"]
["Type of subfloor:",null,null,"Freezer unit 2 Power Source"]
["Number of exposed gypsum (drywall) corners.",null,"#","Freezer unit 3 Power Source"]
["How many doors/frames visible from sales floor? (Exclude Store Front doors)",null,"#","Freezer unit 4 Power Source"]
["Sales Floor Comments: ",null,null,"Freezer unit 5 Power Source"]
[null,null,null,"Freezer unit 6 Power Source"]
[null,null,null,"Open Air Cooler Unit (1 unit=1 door, 2 units = 2 doors, etc.)"]
[null,null,null,"Gatorade Cooler unit(1 unit = 1 door, 2 units = 2 doors) Power Source"]
["Electric Section Comments:",null,null,"Dr. Pepper and Coke vendor cooler unit Power Source"]
[null,null,null,"End Cap Coke vendor cooler unit Power Source"]
[null,null,null,"End Cap Mountain Dew cooler unit Power Source"]
[null,null,null,"Starbucks Vendor cooler unit  (Over ICB) Power Source,     (1 unit =1door, 2 units = 2 doors)"]
["Refrigeration Comments:",null,null,"Diner/Desert/Done freezer unit Power Source"]
[null,null,null,"Ice Cream Bunker (ICB) Power Source"]
[null,null,null,"End Cap Snack Shack","Source"]
[null,null,null,"End Cap Health & Beauty Aids","Source"]
["RECEIVING ROOM",null,null,"RESTROOMS"]
["Are there any dead bolts, slide locks, or door bar brackets installed on receiving a/o egress doors?",false,false,"How many paper towel holders are needed? (standard = 1 per sink)",null,"#"]
["Is Detex DDH2250 installed on receiving doors on top and bottom?",false,false,"How many double roll toilet paper holders are needed? (standard = 1 per toilet)",null,"#"]
["How many sets of Single door seals and sweeps need to be replaced? (exterior doors only)",null,"#","How many 2'X3' ADA compliant restroom mirrors are needed? (standard = 1 per sink)",null,"#"]
["How many sets of Double door seals and sweeps need to be replaced? (exterior doors only)",null,"#","How many 36\" grab bars needed? (standard = 1 per toilet)",null,"#"]
["How many thresholds need to be replaced?",null,"#","How many 42\" grab bars needed? (standard = 1 per toilet)",null,"#"]
["Deliver/Receiving Door Type",null,null,"How many ADA compliant levered door handles are needed? (standard = 1 per restroom door)",null,"#"]
["Is there a 2\" Door Scope?",false,false,"How many ADA compliant toilets need to be replaced?",null,"#"]
["Are there pull handles on the receiving door?",false,false,"How many ADA compliant wall mounted sinks need to be replaced?",null,"#"]
["Is there a mop sink?",false,false,"How many ADA compliant pipe boots are needed? (standard = 1 per sink)",null,"#"]
["Is the mop sink fully functional?",false,false,"How many ADA compliant restroom signs are needed? (standard = 1 Men's and 1 Women's)",null,"#"]
["Is FRP board installed to 4'AFF around mop sink?",false,false,"How many ADA compliant lever handles needed for faucets? (standard = every restroom sink)",null,"#"]
["Are bulbs T-8, T-12 or Other?",null,null,"How many exhaust fans need to be installed? (standard = one per restroom)",null,"#"]
["Number of ballasts to replace:",null,"#","How many exhaust fans need to be repaired/replaced?",null,"#"]
["Number of bulbs to replace:",null,"#","Number of ballasts to replace:",null,"#"]
["Floor Finish?",null,null,"Number of bulbs to replace:",null,"#"]
["Are there any active roof leaks?",false,false,"Restroom paint required:(From Paint Calc. Doc cell O54)",{"$f":"'Paint Calculator'!O54","v":0},"SF"]
["Comments:  ",false,null,"Restroom hall/other paint required visible from sales floor: (From Paint Calc. Doc cell O62)",{"$f":"'Paint Calculator'!O62","v":0},"SF"]
[null,null,null,"Comments:"]
[]
[]
[]
[]
["DOORS MISC."]
["How many restroom, break room, a/o utility doors are missing 4\" kick downs?",null,"#","Comments: "]
["How many receiving a/o stock room doors are missing 8\" kick downs?",null,"#"]
["How many doors are missing closers?",null,"#"]
["OFFICE",null,null,"BREAK ROOM"]
["Comments:",null,null,"Comments: ",null,"#"]
[null,null,null,"How many double roll toilet paper holders are needed?",null,"#"]
[null,false,null,"How many soap dispensers are needed?",null,"#"]

{"sheet":"Scope of Work","index":2,"n_rows":213,"n_cols":8,"rows_kept":213,"cut":false,"hidden":false,"merged":[[4,1,4,6],[5,1,5,6],[6,1,6,6],[0,1,0,6],[1,1,1,6],[2,1,2,6],[3,1,3,6]]}
[]
[null,"REMODEL Scope of Work 2019",null,null,null,null,null,{"$f":"'Check Sheet'!B47+'Check Sheet'!B67","v":0}]
[null,{"$f":"CONCATENATE(\"Store: \",'Check Sheet'!D3)","v":"Store: "}]
[null,{"$f":"CONCATENATE(\"Store Address: \",'Check Sheet'!D4)","v":"Store Address: "}]
[null,{"$f":"CONCATENATE(\"City, ST: \",'Check Sheet'!D5)","v":"City, ST: "}]
[null,{"$f":"CONCATENATE(\"Date Prepared: \",TEXT('Check Sheet'!D6,\"mm-dd-yyyy\"))","v":"Date Prepared: 01-00-1900"}]
[null,{"$f":"CONCATENATE(\"Prepared By: \",'Check Sheet'!D7)","v":"Prepared By: "}]
[null,"SOW","Section","Item",null,"Qty.","Unit"]
[1,"Remodel",1,0,"Summary","a"]
[2,"Remodel",1,{"$f":"OFFSET(D10,-1,0)+1","v":1},"Tenant shall complete, at its own expense, all items listed below that are designated as Tenant's. Should Tenant's work require architectural or engineered plans, Tenant shall be responsible for such plans at its own expense. All work must meet or exceed specifications contained herein and Dollar General Criteria Set as well as requirements of all applicable local, state, and federal codes, ordinances, regulations, and laws, to include, but not limited to fire, building, health, etc. All systems, equipment, etc., provided by Tenant must be totally functional, in good working order and in compliance with all applicable local, state, and federal codes, ordinances, regulations, and laws. ","a"]
[3,"Remodel",2,0,"Quality Requirements","a"]
[4,"Remodel",2,{"$f":"OFFSET(D12,-1,0)+1","v":1},"Provide Demised Premises in broom-clean condition; remove and dispose of all trash.","a"]
[5,"Remodel",2,{"$f":"OFFSET(D13,-1,0)+1","v":2},"All extra paint, ceiling tiles, floor tiles, and / or cove base purchased for this job are to be left at the job site in the receiving area after job completion.","a"]
[6,"Facilities",3,0,"Parking Areas & Drives","a"]
[7,"Remodel",3,0,"Parking Areas & Drives","a"]
[8,"Remodel",3,{"$f":"OFFSET(D16,-1,0)+1","v":1},"Fill pot holes in parking area and drives. ",{"$f":"IF('Check Sheet'!E11=TRUE,1,\"\")","v":""},"Store"]
[9,{"$f":"IF(F17=1,\"Facilities\",\"N/a\")","v":"N/a"},3,{"$f":"OFFSET(D17,-1,0)+1","v":2},"Re-pave parking lot. ",{"$f":"IF('Check Sheet'!E10=\"Poor\",1,\"\")","v":""},"Store"]
[10,{"$f":"IF(F18=1,\"Remodel\",\"N/a\")","v":"N/a"},3,{"$f":"OFFSET(D18,-1,0)+1","v":3},"Re-stripe parking lot. (To be applied per DG Criteria Set and all applicable codes.)",{"$f":"IF('Check Sheet'!F12=TRUE,1,\"\")","v":""},"Store"]
[11,{"$f":"IF(F19<\"\",\"Facilities\",\"N/a\")","v":"N/a"},3,4,"Add or replace handicap signage on building and/or bollard (To be applied per DG Criteria Set and all applicable codes.)",{"$f":"IF('Check Sheet'!E13<>0,'Check Sheet'!E13,\"\")","v":""},"Ea."]
[12,{"$f":"IF(F20>0,\"Facilities\",\"N/a\")","v":"N/a"},3,5,"Repair/replace damaged bollard.",null,"Ea."]
[13,{"$f":"IF(F21>0,\"Facilities\",\"N/a\")","v":"N/a"},3,6,"Provide and install new parking bollard (steel shell-concrete filled)(To be applied per DG Criteria Set and all applicable codes.)",null,"Ea."]
[14,{"$f":"IF(F22>0,\"Facilities\",\"N/a\")","v":"N/a"},3,7,"Provide and install new parking bollard (steel shell-concrete filled) with handicap signage included. (To be applied per DG Criteria Set and all applicable codes.)",null,"Ea."]
[15,{"$f":"IF(F23<\"\",\"Remodel\",\"N/a\")","v":"N/a"},3,8,"Paint bollard safety yellow.",{"$f":"IF('Check Sheet'!B13<>0,'Check Sheet'!B13,\"\")","v":""},"Ea."]
[16,{"$f":"IF(F24=1,\"Facilities\",\"N/a\")","v":"N/a"},3,9,"Repair pole lighting to fully operable condition.",{"$f":"IF('Check Sheet'!C11=TRUE,1,\"\")","v":""},"Store"]
[17,"Facilities",4,0,"Receiving Drive & Docks","a"]
[18,"Remodel",4,0,"Receiving Drive & Docks","a"]
[19,{"$f":"IF(F27>0,\"Facilities\",\"N/a\")","v":"N/a"},4,{"$f":"OFFSET(D27,-1,0)+1","v":1},"Repair deterioration to pavement in the delivery area.",null,"Store"]
[20,{"$f":"IF(F29>0,\"Facilities\",\"N/a\")","v":"N/a"},4,{"$f":"OFFSET(D28,-1,0)+1","v":2},"Provide and install concrete ramp at receiving door for smooth transition and access of Tenant's rolltainers.  Ramp to be constructed to a minimum 1:12 slope.",null,"LF"]
[21,{"$f":"IF(F29>0,\"Facilities\",\"N/a\")","v":"N/a"},4,{"$f":"OFFSET(D29,-1,0)+1","v":3},"Repair rails on delivery dock. ",null,"LF"]
[22,{"$f":"IF(F30>0,\"Facilities\",\"N/a\")","v":"N/a"},4,{"$f":"OFFSET(D30,-1,0)+1","v":4},"Repair or replace safety chain on delivery dock.",null,"LF"]
[23,"Facilities",5,0,"Building Exterior Repairs","a"]
[24,"Remodel",5,0,"Building Exterior Repairs","a"]
[25,{"$f":"IF(F33>0,\"Facilities\",\"N/a\")","v":"N/a"},5,{"$f":"OFFSET(D33,-1,0)+1","v":1},"Seal all exterior wall rodent penetrations or weather penetrations.",null,"Store"]
[26,{"$f":"IF(F34>0,\"Facilities\",\"N/a\")","v":"N/a"},5,2,"Remove graffiti from exterior walls.",null,"Store"]
[27,{"$f":"IF(F35>0,\"Facilities\",\"N/a\")","v":"N/a"},5,3,"Repair all damaged gutters, down spouts, and splash blocks as required.",null,"Store"]
[28,{"$f":"IF(F36>0,\"Facilities\",\"N/a\")","v":"N/a"},5,4,"Repair rodent and/or weather penetrations in the canopy over store front door ",null,"Ea."]
[29,{"$f":"IF(F37>0,\"Facilities\",\"N/a\")","v":"N/a"},5,5,"Replace damaged metal paneling on building and/or canopy.",null,"Store"]
[30,{"$f":"IF(F38=1,\"Facilities\",\"N/a\")","v":"N/a"},5,6,"Repair canopy lighting to fully operable condition",{"$f":"IF('Check Sheet'!C12=TRUE,1,\"\")","v":""},"Store"]
[31,{"$f":"IF(F39>0,\"Facilities\",\"N/a\")","v":"N/a"},5,7,"Re-paint exterior door(s) for with rust preventative/inhibiting enamel paint to match existing color. (Receiving or Egress)",null,"Ea."]
[32,{"$f":"IF(F40>0,\"Facilities\",\"N/a\")","v":"Facilities"},5,8,"Pressure wash storefront and sidewalk ",1,"Store"]
[33,"Facilities",6,0,"Roof","a"]
[34,{"$f":"IF(F42=1,\"Facilities\",\"N/a\")","v":"N/a"},6,{"$f":"OFFSET(D42,-1,0)+1","v":1},"Repair active roof leaks",{"$f":"IF(OR('Check Sheet'!B49=TRUE,'Check Sheet'!B79=TRUE),1,\"\")","v":""},"Store"]
[35,"Facilities",7,0,"Windows","a"]
[36,{"$f":"IF(F44>0,\"Facilities\",\"N/a\")","v":"N/a"},7,{"$f":"OFFSET(D44,-1,0)+1","v":1},"Replace broken and/or cracked store front windows/door glazing. ",null,"Ea."]
[37,"Facilities",8,0,"Exterior Signage","a"]
[38,{"$f":"IF(F46=\"\",\"N/a\",\"Facilities\")","v":"N/a"},8,{"$f":"OFFSET(D46,-1,0)+1","v":1},"Repair building sign to fully operable condition.",{"$f":"IF('Check Sheet'!C10=TRUE,1,\"\")","v":""},"Store"]
[39,{"$f":"IF(F47=\"\",\"N/a\",\"Facilities\")","v":"N/a"},8,{"$f":"OFFSET(D47,-1,0)+1","v":2},"Repair pylon to fully operable condition.",{"$f":"IF('Check Sheet'!C9=TRUE,1,\"\")","v":""},"Store"]
[40,{"$f":"IF(F48>0,\"Facilities\",\"N/a\")","v":"N/a"},8,{"$f":"OFFSET(D48,-1,0)+1","v":3},"Repaint pylon sign pole to match existing",null,"Ea."]
[41,"Facilities",9,0,"Restrooms & Plumbing","a"]
[42,"Remodel",9,0,"Restrooms & Plumbing","a"]
[43,{"$f":"IF(F51<\"\",\"Facilities\",\"N/a\")","v":"N/a"},9,{"$f":"OFFSET(D51,-1,0)+1","v":1},"Provide & install single roll paper towel dispenser.  ",{"$f":"IF('Check Sheet'!E64<>0,'Check Sheet'!E64,\"\")","v":""},"Ea."]
[44,{"$f":"IF(F52=\"\",\"N/a\",\"Facilities\")","v":"N/a"},9,2,"Provide & install double roll toilet paper dispenser. ",{"$f":"IF('Check Sheet'!E65<>0,'Check Sheet'!E65,\"\")","v":""},"Ea."]
[45,{"$f":"IF(F53=\"\",\"N/a\",\"Facilities\")","v":"N/a"},9,3,"Provide & install 24X36 angle frame mirror (or larger if required by code) in restrooms above sink.",{"$f":"IF('Check Sheet'!E66<>0,'Check Sheet'!E66,\"\")","v":""},"Ea."]
[46,"N/a",9,4,"Provide & install  36\" grab bar.   (To be installed per all applicable codes.)",{"$f":"IF('Check Sheet'!E67<>0,'Check Sheet'!E67,\"\")","v":""},"Ea."]
[47,"N/a",9,5,"Provide & install  42\" grab bar.   (To be installed per all applicable codes.)",{"$f":"IF('Check Sheet'!E68<>0,'Check Sheet'!E68,\"\")","v":""},"Ea."]
[48,{"$f":"IF(F56<>\"\",\"Facilities\",\"N/a\")","v":"N/a"},9,6,"Provide & install pedestal mop sink & faucet set.",{"$f":"IF('Check Sheet'!C72=TRUE,\"1\",\"\")","v":""},"Ea."]
[49,{"$f":"IF(F57<>\"\",\"Facilities\",\"N/a\")","v":"N/a"},9,7,"Repair/replace mop sink & faucet set.",{"$f":"IF('Check Sheet'!C73=TRUE,1,\"\")","v":""},"Ea."]
[50,{"$f":"IF(F58=\"\",\"N/a\",\"Facilities\")","v":"N/a"},9,8,"Provide & install FRP (Fiber-Reinforced Plastic) to 4' 0\" AFF around mop sink",{"$f":"IF('Check Sheet'!C74=TRUE,1,\"\")","v":""},"Sheet"]
[51,"N/a",9,9,"Provide & install 10 gallon water heater. ",null,"Ea."]
[52,{"$f":"IF(F60=\"\",\"N/a\",\"Facilities\")","v":"N/a"},9,10,"Provide & install  Storeroom Leverset.  (To be installed per all applicable codes.)",{"$f":"IF('Check Sheet'!E69<>0,'Check Sheet'!E69,\"\")","v":""},"Ea."]
[53,"N/a",9,11,"Provide & install ADA compliant toilet",{"$f":"IF('Check Sheet'!E70<>0,'Check Sheet'!E70,\"\")","v":""},"Ea."]
[54,"N/a",9,12,"Provide & install ADA compliant wall mounted sink ",{"$f":"IF('Check Sheet'!E71<>0,'Check Sheet'!E71,\"\")","v":""},"Ea."]
[55,"N/a",9,13,"Provide & install ADA compliant pipe boot for sink",{"$f":"IF('Check Sheet'!E72<>0,'Check Sheet'!E72,\"\")","v":""},"Ea."]
[56,"N/a",9,14,"Provide & install ADA compliant signage",{"$f":"IF('Check Sheet'!E73<>0,'Check Sheet'!E73,\"\")","v":""},"Ea."]
[57,"N/a",9,15,"Provide & install ADA compliant faucet",{"$f":"IF('Check Sheet'!E74<>0,'Check Sheet'!E74,\"\")","v":""},"Ea."]
[58,{"$f":"IF(F66=\"\",\"N/a\",\"Remodel\")","v":"N/a"},9,16,"Provide & install exhaust fan per restroom",{"$f":"IF('Check Sheet'!E75<>0,'Check Sheet'!E75,\"\")","v":""},"Ea."]
[59,{"$f":"IF(F67=\"\",\"N/a\",\"Facilities\")","v":"N/a"},9,17,"Repair/replace existing exhaust fan per restroom",{"$f":"IF('Check Sheet'!E76<>0,'Check Sheet'!E76,\"\")","v":""},"Ea."]
[60,{"$f":"IF(F68>0,\"Facilities\",\"N/a\")","v":"N/a"},9,18,"Provide & install ADA compliant water fountain ",null,"Ea."]
[61,{"$f":"IF(F69>0,\"Facilities\",\"N/a\")","v":"N/a"},9,19,"Remove existing paint from restroom hardware.",null,"Store"]
[62,{"$f":"IF(F70>0,\"Facilities\",\"N/a\")","v":"N/a"},9,20,"Modify sprinkler head",null,"Ea."]
[63,"Remodel",10,0,"Register Assembly","a"]
[64,"Facilities",10,0,"Register Assembly","a"]
[65,{"$f":"IF(F73>0,\"Remodel\",\"N/a\")","v":"N/a"},10,{"$f":"OFFSET(D73,-1,0)+1","v":1},"Unhook existing registers, break down and remove old register counters, take old register counters outside to DG POD, unload and uncrate NEW register counter, install NEW register counters and install all registers in the NEW register counter and Install safe",null,"Per Store"]
[66,{"$f":"IF(F74=\"\",\"N/a\",\"Facilities\")","v":"N/a"},10,{"$f":"OFFSET(D74,-1,0)+1","v":2},"Unhook existing registers, break down and remove old register counters, take old register counters outside to DG POD, unload and uncrate Refurbished register counter, install Refurbished register counters and install all registers in the Refurbished register counter and relocate safe.",{"$f":"IF('Check Sheet'!C24=TRUE,1,\"\")","v":""},"Per Store"]
[67,{"$f":"IF(F75>0,\"Remodel\",\"N/a\")","v":"N/a"},10,{"$f":"OFFSET(D75,-1,0)+1","v":3},"Install new stand-alone register counter (3rd with \"Shift\" or 4th with \"CCS\")",null,"Ea."]
[68,{"$f":"IF(F76=\"\",\"N/a\",\"Facilities\")","v":"N/a"},10,{"$f":"OFFSET(D76,-1,0)+1","v":4},"Shift existing registers to new location per fixture plan",{"$f":"IF('Check Sheet'!B24=TRUE,1,\"\")","v":""},"Per Store"]
[69,"Facilities",11,0,"Electrical","a"]
[70,"Remodel",11,0,"Electrical","a"]
[71,{"$f":"IF(F79=1,\"Remodel\",\"N/a\")","v":"Remodel"},11,{"$f":"OFFSET(D79,-1,0)+1","v":1},"Ensure electrical service is adequate to support anticipated load demands. (Electrical Survey Site Visit / Engineer's Letter)",{"$f":"IF('Check Sheet'!E19<400,1,\"\")","v":1},"Per Store"]
[72,{"$f":"IF(F80=\"\",\"N/a\",\"Remodel\")","v":"N/a"},11,2,"Demo existing conduits where registers, coolers or freezers are relocated.",{"$f":"IF(SUM(COUNTIF('Check Sheet'!$E$33:$E$62,\"Conduit\")+COUNTIF('Check Sheet'!$E$33:$E$62,\"Power Pole used as Conduit\"))=0,\"\",SUM(COUNTIF('Check Sheet'!$E$33:$E$62,\"Conduit\")+COUNTIF('Check Sheet'!$E$33:$E$62,\"Power Pole used as Conduit\")))","v":""},"Ea."]
[73,{"$f":"IF(F81=\"\",\"N/a\",\"Remodel\")","v":"N/a"},11,3,"Provide & install D & P Custom Lights & Wiring Systems single circuit power pole for specialty use.  (To include circuit, conduit, J Boxes, cable kit & all associated wiring) [Gatorade Cooler, Stand-Alone Cooler, a/o Ice Cream Cooler] (Color = Black)",null,"Ea."]
[74,{"$f":"IF(F82=\"\",\"N/a\",\"Remodel\")","v":"N/a"},11,4,"Provide & install D & P Custom Lights & Wiring Systems 6 circuit power pole (To include circuit, conduit, J Boxes, cable kit & all associated wiring) [Register] (Color = Black)",null,"Ea."]
[75,"N/a",11,5,"Provide & install D & P Custom Lights & Wiring Systems  stand-alone three circuit power pole (To include circuit, conduit, J Boxes, cable kit & all associated wiring) [Stand-Alone Register] (Color = Black)",null,"Ea."]
[76,"N/a",11,6,"Provide & install D & P Custom Lights & Wiring Systems  eight circuit register power pole (To include circuit, conduit, J Boxes, cable kit & all associated wiring) [CCS Register] (Color = Black)",null,"Ea."]
[77,"N/a",11,7,"Provide & install D & P Custom Lights & Wiring Systems  two circuit 120/120 volt power pole (To include circuit, conduit, J Boxes, cable kit & all associated wiring) [Cooler/Cooler]  (Color = Black)",null,"Ea."]
[78,"N/a",11,8,"Provide & install D & P Custom Lights & Wiring Systems  two circuit 120/250 volt power pole (To include circuit, conduit, J Boxes, cable kit & all associated wiring) [Cooler/Freezer] (Color = Black)",null,"Ea."]
[79,"N/a",11,9,"Provide & install D & P Custom Lights & Wiring Systems  two circuit 250/250 volt power pole (To include circuit, conduit, J Boxes, cable kit & all associated wiring) [Freezer/Freezer] (Color = Black)",null,"Ea."]
[80,"N/a",11,10,"Provide & install D & P Custom Lights & Wiring Systems single circuit 250 volt power pole.  (To include circuit, conduit, J Boxes, & all associated wiring) [Freezer] (Color = Black)",null,"Ea."]
[81,{"$f":"IF(F89=\"\",\"N/a\",\"Facilities\")","v":"N/a"},11,11,"Reuse & relocate existing power pole. (Indicate which unit from X to X)",{"$f":"IF(COUNTIF('Check Sheet'!$E$33:$E$62,\"Power Pole\")=0,\"\",COUNTIF('Check Sheet'!$E$33:$E$62,\"Power Pole\"))","v":""},"Ea."]
[82,{"$f":"IF(F90=1,\"Remodel\",\"N/a\")","v":"N/a"},11,12,"Rewire existing register power pole to be used for two circuit 120/120 volt power pole [Cooler/Cooler] ",null,"Ea."]
[83,{"$f":"IF(F91<>\"\",\"Facilities\",\"N/a\")","v":"N/a"},11,13,"Provide & install exterior outlet for ice and/or soda machine",{"$f":"IF('Check Sheet'!F29=TRUE,1,\"\")","v":""},"Ea."]
[84,{"$f":"IF(F92>0,\"Facilities\",\"N/a\")","v":"N/a"},11,14,"Repair/replace exterior outlet for ice and/or soda machine",null,"Ea."]
[85,"Remodel",11,15,"Reconnect all registers & components. (Ensure full operation of each register component & complete connectivity for all low voltage connections.) (Any extension of existing cabling must be properly terminated via industry standard(s)) [NO splicing allowed] ",1,"Per Store"]
[86,"N/a",11,16,"Provide & install receptacle/light switch on existing breaker",null,"Ea."]
[87,"N/a",11,17,"Provide & install receptacle/light switch on new breaker",null,"Ea."]
[88,{"$f":"IF(F96=1,\"Remodel\",\"N/a\")","v":"N/a"},11,18,"Provide & install breaker locks on electrical panel breakers controlling the night lights, alarm circuit, and exterior stockroom receiving door light",{"$f":"IF('Check Sheet'!F23=TRUE,1,\"\")","v":""},"Per Store"]
[89,{"$f":"IF(F97=1,\"Remodel\",\"N/a\")","v":"Remodel"},11,19,"Provide & install electrical subpanel.",{"$f":"IF(OR('Check Sheet'!E22<12,'Check Sheet'!E21=\"Cutler Hammer\" ),1,\"\")","v":1},"Per Store"]
[90,{"$f":"IF(F98=1,\"Remodel\",\"N/a\")","v":"N/a"},11,20,"Clearly & legibly label all circuits within electrical panel(s)",{"$f":"IF('Check Sheet'!F20=TRUE,1,\"\")","v":""},"Per Store"]
[91,"Remodel",11,{"$f":"OFFSET(D99,-1,0)+1","v":21},"Provide & install duplex receptacle on new breaker in 1/2\" EMT, single gang J-box, stand-off straps,  exposed conduit painted per décor scheme (115V/60Hz/1-20Amp-NEMA-5-15P) [End Cap Cooler Power Supply]",null,"Ea."]
[92,"Remodel",11,22,"Provide & install receptacle on new breaker in 1/2\" EMT painted per décor scheme 115/60/1 NEMA-5-15R (To include circuit, conduit, J Boxes, & all associated wiring) [Circuit in exposed Conduit for DG Cooler/DG Single Door Freezer]",null,"Ea."]
[93,"Remodel",11,23,"Provide & install receptacle on new breaker in 1/2\" EMT painted per décor scheme 115/208-230/1 NEMA-14-20R   (To include circuit, conduit, J Boxes, & all associated wiring) [Circuit in exposed Conduit For DG Freezer]",null,"Ea."]
[94,"Remodel",11,24,"Provide & install white SO cord with a 2 Gang box on the SO & 4 outlets inserted into the top (To include circuit,  gang boxes, mounting structure & all associated wiring) [Fixture Cooler Power Supply] {Mt. Dew/Pepsi Stack Cooler(s)}           ",null,"Ea."]
[95,"Remodel",11,25,"Provide and install McCue Electrical Panel Protection Rail (min 3’-0” off panel face)",null,"Ea."]
[96,"Remodel",11,26,"Provide & install new wire (10/3 gauge) on new double pole 30amp breaker. Install supplied disconnect box max 18\" above each unit. {Zero Zone 3 DR low temp Freezer}",null,"Ea."]
[97,"Remodel",11,27,"Provide & install new wire (8/3 gauge) on new double pole 40amp breaker. Install supplied disconnect box max 18\" above each unit. {Zero Zone 4DR low Temp Freezer}",null,"Ea."]
[98,"Remodel",11,28,"Provide & install new wire (8/3 gauge) on new double pole 40amp breaker. Install supplied disconnect box max 18\" above each unit. {Zero Zone 5DR low Temp Freezer }",null,"Ea."]
[99,"Remodel",11,29,"Provide & install new wire (12/3 gauge) on new double pole 15amp breaker. Install supplied disconnect box max 18\" above each unit. {Zero Zone 4DR Med Temp Cooler }",null,"Ea."]
[100,"Remodel",11,30,"Provide & install new wire (12/3 gauge) on new double pole 15amp breaker. Install supplied disconnect box max 18\" above each unit. {Zero Zone 5DR Med Temp Cooler }",null,"Ea."]
[101,"Remodel",11,31,"Provide & Install new wire (10/4 gauge) on new double pole 30amp breaker.  Install supplied disconnect box max 18' above each unit. {Hussmann 3 DR low temp freezer}.",null,"Ea."]
[102,"Remodel",11,32,"Provide & Install new wire (8/4 gauge) on new double pole 40amp breaker.  Install supplied disconnect box max 18' above each unit. {Hussmann 4 DR low temp freezer}.",null,"Ea."]
[103,"Remodel",11,33,"Provide & Install new wire (8/4 gauge) on new double pole 40amp breaker.  Install supplied disconnect box max 18' above each unit. {Hussmann 5 DR low temp freezer}.",null,"Ea."]
[104,"Remodel",11,34,"Provide & Install new wire (12/4 gauge) on new double pole 15amp breaker.  Install supplied disconnect box max 18' above each unit. {Hussmann 4 DR Med Temp Cooler}.",null,"Ea."]
[105,"Remodel",11,35,"Provide & Install new wire (12/4 gauge) on new double pole 15amp breaker.  Install supplied disconnect box max 18' above each unit. {Hussmann 5 DR Med Temp Cooler}.",null,"Ea."]
[106,"Remodel",11,36,"Provide & install duplex receptacle on new breaker in 1/2\" EMT, single gang J box, stand-off straps,  exposed conduit painted per décor scheme (120V/60Hz/1-15Amp-NEMA-5-15P) (12/2 Gauge Wire){Legacy 2DR Med Temp Reach in cooler}",null,"Ea."]
[107,"Remodel",11,37,"Provide & install duplex receptacle on new breaker in 1/2\" EMT, single gang J box, stand-off straps,  exposed conduit painted per décor scheme (120V/60Hz/1-15Amp-NEMA-5-15P) (12/2 Gauge Wire){Legacy 2DR Low  Temp Reach in freezer}",null,"Ea."]
[108,"Remodel",11,38,"Install wiring for produce cooler",null,"Ea."]
[109,"Remodel",11,39,"Provide & install duplex receptacle on new breaker in 1/2\" EMT, single gang J box, stand-off straps,  exposed conduit painted per décor scheme (208V/60Hz/1-15Amp-NEMA-5-15P) (12/3 Gauge Wire){Legacy 3DR Low Temp Reach in Freezer}",null,"Ea."]
[110,"Remodel",11,40,"Provide & install duplex receptacle on new breaker in 1/2\" EMT, single gang J box, stand-off straps,  exposed conduit painted per décor scheme (120V/60Hz/1-15Amp-NEMA-5-15P) (12/2 Gauge Wire){Legacy 3DR Med Temp Reach in cooler}",null,"Ea."]
[111,"Facilities",12,0,"Lights & Lighting Items","a"]
[112,"Remodel",12,0,"Lights & Lighting Items","a"]
[113,{"$f":"IF(F122<>\"\",\"Facilities\",\"N/a\")","v":"N/a"},12,{"$f":"OFFSET(D121,-1,0)+1","v":1},"Repair/replace ballasts(s) as required to repair fixture",{"$f":"IF('Check Sheet'!B26+'Check Sheet'!B76+'Check Sheet'!E77>0,'Check Sheet'!B26+'Check Sheet'!B76+'Check Sheet'!E77,\"\")","v":""},"Ea."]
[114,{"$f":"IF(F121<>\"\",\"Facilities\",\"N/a\")","v":"N/a"},12,{"$f":"OFFSET(D122,-1,0)+1","v":2},"Replace bulbs(s) as required ",{"$f":"IF('Check Sheet'!B$22+'Check Sheet'!B$77+'Check Sheet'!E$78>0,'Check Sheet'!B$22+'Check Sheet'!B$77+'Check Sheet'!E$78,\"\")","v":""},"Ea."]
[115,{"$f":"IF(F123<\"\",\"Facilities\",\"N/a\")","v":"N/a"},12,{"$f":"OFFSET(D123,-1,0)+1","v":3},"Repair/replace existing emergency light to fully operable condition",{"$f":"IF('Check Sheet'!E$24<>0,'Check Sheet'!E$24,\"\")","v":""},"Ea."]
[116,{"$f":"IF(F124<\"\",\"Facilities\",\"N/a\")","v":"N/a"},12,4,"Repair/replace existing emergency exit sign to fully operable condition",{"$f":"IF('Check Sheet'!E$25<>0,'Check Sheet'!E$25,\"\")","v":""},"Ea."]
[117,{"$f":"IF(F125<\"\",\"Facilities\",\"N/a\")","v":"N/a"},12,5,"Repair/replace existing exit combo light to fully operable condition",{"$f":"IF('Check Sheet'!E$26<>0,'Check Sheet'!E$26,\"\")","v":""},"Ea."]
[118,{"$f":"IF(F126<\"\",\"Facilities\",\"N/a\")","v":"N/a"},12,6,"Relocate existing emergency/exit light",null,"Ea."]
[119,{"$f":"IF(F127=1,\"Remodel\",\"N/a\")","v":"N/a"},12,7,"Provide & install new 150 W LED wall pack and wiring",{"$f":"IF('Check Sheet'!C$14=TRUE,1,\"\")","v":""},"Ea."]
[120,{"$f":"IF(F128=1,\"Facilities\",\"N/a\")","v":"N/a"},12,8,"Repair exterior security lighting to fully operable condition.",{"$f":"IF('Check Sheet'!C$15=TRUE,1,\"\")","v":""},"Ea."]
[121,"Facilities",13,0,"Walls & Painting","a"]
[122,"Remodel",13,0,"Walls & Painting","a"]
[123,"Remodel",13,{"$f":"OFFSET(D131,-1,0)+1","v":1},"Repair/Replacement of damaged drywall, small areas",{"$f":"IF('Check Sheet'!B$33=TRUE,50,\"\")","v":""},"Per Store"]
[124,{"$f":"IF(F132>0,\"Remodel\",\"N/a\")","v":"N/a"},13,2,"10' - sheetrock one side only",null,"LF"]
[125,{"$f":"IF(F133>0,\"Remodel\",\"N/a\")","v":"N/a"},13,3,"Provide stud wall ",null,"LF"]
[126,{"$f":"IF(F134<\"\",\"Facilities\",\"N/a\")","v":"N/a"},13,4,"Remove security mirror when needed and prep walls for paint",{"$f":"IF('Check Sheet'!B$23<>0,'Check Sheet'!B$23,\"\")","v":""},"Ea."]
[127,{"$f":"IF(F135=0,\"N/a\",\"Facilities\")","v":"N/a"},13,5,"Remove existing wall graphics & repair wall as needed for painting",null,"Per store"]
[128,{"$f":"IF(F136=1,\"Facilities\",\"N/a\")","v":"N/a"},13,6,"Remove existing pegboard from sales floor walls as needed per fixture plan.",{"$f":"IF('Check Sheet'!B$32=TRUE,1,\"\")","v":""},"Per store"]
[129,{"$f":"IF(F137=0,\"N/a\",\"Remodel\")","v":"N/a"},13,7,"Build 48\" half wall at CCS registers. Construction to be 3 5/8\" metal studs with 5/8\" sheetrock on both sides.  Length per fixture plan with 1\" top cap.",null,"Per Store"]
[130,{"$f":"IF(F138=0,\"N/a\",\"Remodel\")","v":"N/a"},13,8,"Provide & install nominal 2x12 (Top edge at 81” A.F.F.) and nominal 2x4 (Top edge at 12” A.F.F.)  white pine, grade 2 or better, for drink fixture anchoring",null,"LF"]
[131,"Remodel",13,{"$f":"OFFSET(D139,-1,0)+1","v":9},"Prime wall area",null,"SF"]
[132,"Remodel",13,10,"Prepare walls to paint (To include masking when necessary & patching of nail holes, hairline cracks, etc.",{"$f":"IF('Check Sheet'!B$38<>0,'Check Sheet'!B$38,\"\")","v":""},"SF"]
[133,"Remodel",13,11,"Paint sales floor walls - two coats (Per Décor Plan as specified below)",{"$f":"IF('Check Sheet'!B$38<>0,'Check Sheet'!B$38,\"\")","v":""},"SF"]
[134,"Remodel",13,12,"Paint sales floor walls - two coats (Sherwin-Williams PURE WHITE SW7005) Areas as Indicated on Décor Plan"]
[135,"Remodel",13,13,"Paint sales floor walls - two coats  (Sherwin-Williams BLACK MAGIC SW6991) Areas as Indicated on Décor  Plan"]
[136,"Remodel",13,14,"Paint sales floor walls - two coats (Sherwin-Williams DAISY SW6910) Areas as Indicated on Décor  Plan"]
[137,"Remodel",13,15,"Paint restrooms walls - two coats (Sherwin-Williams PURE WHITE SW7005) Areas as Indicated on Décor Plan",{"$f":"IF('Check Sheet'!E$79<>0,'Check Sheet'!E$79,\"\")","v":""},"SF"]
[138,"Remodel",13,16,"Paint restroom hallway walls - two coats (Areas & Colors as Indicated on Décor Plan)",{"$f":"IF('Check Sheet'!E$80<>0,'Check Sheet'!E$80,\"\")","v":""},"SF"]
[139,"Remodel",13,17,"Prepare & paint doors & frames visible from sales floor - two coats (Sherwin-Williams BLACK MAGIC SW6991) Areas as Indicated on Décor Plan",{"$f":"IF('Check Sheet'!B$50<>0,'Check Sheet'!B$50,\"\")","v":""},"Ea."]
[140,{"$f":"IF(F148<\"\",\"Remodel\",\"N/a\")","v":"N/a"},13,18,"Prepare & paint existing power pole black (Krylon brand - finish to match new black wall)",{"$f":"IF(COUNTIF('Check Sheet'!$E$33:$E$62,\"Power Pole\")=0,\"\",COUNTIF('Check Sheet'!$E$33:$E$62,\"Power Pole\"))","v":""},"Ea."]
[141,{"$f":"IF(F149<\"\",\"Remodel\",\"N/a\")","v":"N/a"},13,19,"Prepare & paint columns on sales floor - two coats (Sherwin-Williams PURE WHITE SW7005)",{"$f":"IF('Check Sheet'!B$39<>0,'Check Sheet'!B$39,\"\")","v":""},"Ea."]
[142,"Remodel",13,20,"Wrap column with tight loop carpet (Black) from base to 48” A.F.F.",null,"Ea."]
[143,{"$f":"IF(F151=\"\",\"N/a\",\"Remodel\")","v":"N/a"},13,21,"Provide & install 2' x 3' one-way glass in manager's office",null,"Ea."]
[144,"Facilities",14,0,"Doors & Door Items"]
[145,"Remodel",14,0,"Doors & Door Items","a"]
[146,{"$f":"IF(F154>0,\"Remodel\",\"N/a\")","v":"N/a"},14,{"$f":"OFFSET(D154,-1,0)+1","v":1},"Provide & install 3'-0\" solid-core restroom door (w/ hardware, 4\" kick down, and door closer)",null,"Ea."]
[147,"N/a",14,2,"Provide & install 4'-0\" solid-core stockroom door (w/ hardware, 8\" kick down, interior & exterior pull handles, 2 - 8\" kick plates, and door closer)",null,"Ea."]
[148,"N/a",14,3,"Provide & install 3'-0\" fire-rated emergency egress door (w/hardware: panic bar w/ hardware, and door closer) ",null,"Ea."]
[149,"N/a",14,4,"Provide & install 4'-0\" fire-rated receiving door (w/hardware: interior pull handle, panic bar w/ hardware, 8\" kick down, 2\" 180 deg. peep viewer, door closer, and double door holder) ",null,"Ea."]
[150,"N/a",14,5,"Provide & install 6'-0\" X 7'-0\" solid core double stockroom doors (w/ hardware: push plate and pull handle, 8\" kick down, interior  & exterior 8\" kick plate, and door closer) [Per Door] ",null,"Ea."]
[151,"N/a",14,6,"Provide & install 6'-0\" X 7'-0\" fire rated double receiving doors with heavy duty low profile threshold (w/ hardware: push plate and pull handle, panic bar w/ hardware, 8\" kick down, 2\" 180 deg. door scope,  door closer, and double door holder) [Per Door] ",null,"Ea."]
[152,{"$f":"IF(F160<>\"\",\"Remodel\",\"N/a\")","v":"N/a"},14,7,"Provide & install  Double Door Holder ",{"$f":"IF('Check Sheet'!C65=TRUE,2,\"\")","v":""},"Ea."]
[153,{"$f":"IF(F161=\"\",\"N/a\",\"Remodel\")","v":"N/a"},14,8,"Provide & install pull plate & push plate on stock room door (1  pull plate & 1 push plate per door) [Remove lockset if existing]",null,"Door"]
[154,{"$f":"IF(F162=\"\",\"N/a\",\"Facilities\")","v":"N/a"},14,9,"Demo any dead bolts, slide locks, bar brackets installed on receiving a/o egress door(s).",{"$f":"IF('Check Sheet'!B64=TRUE,1,\"\")","v":""},"Store"]
[155,{"$f":"IF(F163>0,\"Remodel\",\"N/a\")","v":"N/a"},14,10,"Provide & install  door viewer in manager's office door (180 degree viewing angle)",null,"Ea."]
[156,{"$f":"IF(F164=\"\",\"N/a\",\"Remodel\")","v":"N/a"},14,11,"Provide & install  2\" door scope in receiving exit door (180 degree viewing angle)",{"$f":"IF('Check Sheet'!C70=TRUE,1,\"\")","v":""},"Ea."]
[157,{"$f":"IF(F165=\"\",\"N/a\",\"Facilities\")","v":"N/a"},14,12,"Provide & install  4\" kick down type door holder (1 each door: restroom, break room)",{"$f":"IF('Check Sheet'!B87<>0,'Check Sheet'!B87,\"\")","v":""},"Ea."]
[158,{"$f":"IF(F166=\"\",\"N/a\",\"Facilities\")","v":"N/a"},14,13,"Provide & install  8\" kick down type door stop (1 each per door: stockroom, receiving)",{"$f":"IF('Check Sheet'!B88<>0,'Check Sheet'!B88,\"\")","v":""},"Ea."]
[159,{"$f":"IF(F167=\"\",\"N/a\",\"Facilities\")","v":"N/a"},14,14,"Provide & install  door closer (1 per door) ",{"$f":"IF('Check Sheet'!B89<>0,'Check Sheet'!B89,\"\")","v":""},"Ea."]
[160,"N/a",14,15,"Provide & install Von Duprin Guard-X Exit Alarm Lock &  Rim Cylinder ",null,"Ea."]
[161,"N/a",14,16,"Provide & install Von Duprin Guard-X Double Door Strike (Double Door Only)",null,"Ea."]
[162,"N/a",14,17,"Provide & install  8\" kick plate on \"push\" side of stockroom/receiving door",null,"Ea."]
[163,{"$f":"IF(F171<>\"\",\"Facilities\",\"N/a\")","v":"N/a"},14,18,"Replace seals & sweeps for 3' & 4' single door openings",{"$f":"IF('Check Sheet'!B45+'Check Sheet'!B66>0,'Check Sheet'!B45+'Check Sheet'!B66,\"\")","v":""},"Ea."]
[164,{"$f":"IF(F172<>\"\",\"Facilities\",\"N/a\")","v":"N/a"},14,19,"Replace seals & sweeps for double door openings",{"$f":"IF('Check Sheet'!B46+'Check Sheet'!B67>0,'Check Sheet'!B46+'Check Sheet'!B67,\"\")","v":""},"Ea."]
[165,{"$f":"IF(F173<\"\",\"Facilities\",\"N/a\")","v":"N/a"},14,20,"Provide & install HD threshold for receiving doors",{"$f":"IF('Check Sheet'!B68<>0,'Check Sheet'!B68,\"\")","v":""},"Ea."]
[166,{"$f":"IF(F174=1,\"Remodel\",\"N/a\")","v":"N/a"},14,21,"Provide & install standard door buzzer",{"$f":"IF('Check Sheet'!C16=TRUE,1,\"\")","v":""},"Ea."]
[167,{"$f":"IF(F175>0,\"Facilities\",\"N/a\")","v":"N/a"},14,22,"Repair/replace standard door buzzer",null,"Ea."]
[168,{"$f":"IF(F176<>\"\",\"Remodel\",\"N/a\")","v":"N/a"},14,23,"Provide & install McCue black vertical trim on corners mounted on top of cove base",{"$f":"IF('Check Sheet'!B49<>0,'Check Sheet'!B49,\"\")","v":""},"Ea."]
[169,{"$f":"IF(F177<\"\",\"Facilities\",\"N/a\")","v":"N/a"},14,24,"Provide & install cart guard(s)on storefront door. [3/8\" X 2\" Aluminum flat stock. Finished to match existing door]",{"$f":"IF('Check Sheet'!B44<>0,'Check Sheet'!B44,\"\")","v":""},"Ea."]
[170,{"$f":"IF(F178>0,\"Remodel\",\"N/a\")","v":"N/a"},14,25,"Provide & install McCue cart corral trim kit: Complete Package (2 vertical trim pieces, 4 bumper guards and floor mounted cart stop).",null,"Per Store"]
[171,"Facilities",15,0,"Ceilings","a"]
[172,"Remodel",15,0,"Ceilings","a"]
[173,{"$f":"IF(F181<\"\",\"Facilities\",\"N/a\")","v":"N/a"},15,{"$f":"OFFSET(D181,-1,0)+1","v":1},"Demo & provide & install new ceiling tile to match existing",{"$f":"IF('Check Sheet'!B28<>0,'Check Sheet'!B28,\"\")","v":""},"SF"]
[174,{"$f":"IF(F182<\"\",\"Facilities\",\"N/a\")","v":"N/a"},15,{"$f":"OFFSET(D182,-1,0)+1","v":2},"Repair/replace existing ceiling grid to match existing ",{"$f":"IF('Check Sheet'!B29<>0,'Check Sheet'!B29,\"\")","v":""},"LF"]
[175,{"$f":"IF(F183>0,\"Facilities\",\"N/a\")","v":"N/a"},15,{"$f":"OFFSET(D183,-1,0)+1","v":3},"Provide & install ceiling insulation (labor & materials)",null,"SF"]
[176,{"$f":"IF(F184>0,\"Facilities\",\"N/a\")","v":"N/a"},15,{"$f":"OFFSET(D184,-1,0)+1","v":4},"Prep & paint ceiling (labor & materials)",null,"SF"]
[177,"Facilities",16,0,"Floors","a"]
[178,"Remodel",16,0,"Floors","a"]
[179,{"$f":"IF(F187<>\"\",\"Facilities\",\"N/a\")","v":"N/a"},16,{"$f":"OFFSET(D187,-1,0)+1","v":1},"Provide & install new floor tile, to include removal of existing carpet/tile, preparation of floor (sanding, patching, leveling, sweeping), installation of new tiles. {To match existing}",{"$f":"IF('Check Sheet'!B40<>\"VCT\",\"\",'Check Sheet'!B41+45)","v":""},"SF"]
[180,{"$f":"IF(F188<>\"\",\"Facilities\",\"N/a\")","v":"Facilities"},16,{"$f":"OFFSET(D188,-1,0)+1","v":2},"Provide & install black cove base (labor & materials)",{"$f":"'Check Sheet'!B42+60","v":60},"LF"]
[181,{"$f":"IF(F189<>\"\",\"Facilities\",\"N/a\")","v":"N/a"},16,{"$f":"OFFSET(D189,-1,0)+1","v":3},"Scrape floors where excessive buildup is located",null,"Per Store"]
[182,"Facilities",17,0,"HVAC","a"]
[183,"Remodel",17,0,"HVAC","a"]
[184,{"$f":"IF(F192<\"\",\"Facilities\",\"N/a\")","v":"N/a"},17,{"$f":"OFFSET(D192,-1,0)+1","v":1},"Clean diffusers.",{"$f":"IF('Check Sheet'!B30<>0,'Check Sheet'!B30,\"\")","v":""},"Ea."]
[185,{"$f":"IF(F193<\"\",\"Facilities\",\"N/a\")","v":"N/a"},17,{"$f":"OFFSET(D193,-1,0)+1","v":2},"Paint diffusers.",null,"Ea."]
[186,{"$f":"IF(F194<\"\",\"Facilities\",\"N/a\")","v":"N/a"},17,{"$f":"OFFSET(D194,-1,0)+1","v":3},"Relocate temperature sensor/thermostat above fixture line (labor & material - estimate)",{"$f":"IF('Check Sheet'!B31<>0,'Check Sheet'!B31,\"\")","v":""},"Ea."]
[187,{"$f":"IF(F195<\"\",\"Facilities\",\"N/a\")","v":"N/a"},17,{"$f":"OFFSET(D195,-1,0)+1","v":4},"Replace air filters in store",null,"Per Store"]
[188,"Facilities",18,0,"Additional Items","a"]
[189,"Remodel",18,0,"Additional Items","a"]
[190,{"$f":"IF(F198<\"\",\"Facilities\",\"N/a\")","v":"N/a"},18,{"$f":"OFFSET(D198,-1,0)+1","v":1},"Demo any unused cable/wires hanging from ceiling"]
[191,{"$f":"IF(F199<\"\",\"Facilities\",\"N/a\")","v":"N/a"},18,{"$f":"OFFSET(D199,-1,0)+1","v":2}]
[192,"N/a",18,3]
[193,"N/a",18,4]
[194,"N/a",18,5]
[195,"N/a",18,6]
[196,"N/a",18,7]
[197,"N/a",18,8]
[198,"N/a",18,9]
[199,"N/a",18,10]
[200,"N/a",18,11]
[201,"N/a",18,12]
[202,"N/a",18,13]
[203,"N/a",18,14]
[204,"N/a",18,15]
[205,"N/a",18,16]

{"sheet":"Paint Calculator","index":3,"n_rows":64,"n_cols":16,"rows_kept":64,"cut":false,"hidden":false,"merged":[[10,7,10,9],[0,2,0,15],[2,2,2,5],[2,7,2,9],[3,2,3,5],[3,7,3,9],[4,2,4,5]]}
[null,null,"PAINT ESTIMATION FORMULA (revision 4/17/2019)"]
[]
[null,null,"City/ST:",null,null,null,null,{"$f":"'Check Sheet'!D5","v":0}]
[null,null,"Store number:",null,null,null,null,{"$f":"'Check Sheet'!D3","v":0}]
[null,null,"SF Per Paint Calculator:",null,null,null,null,{"$f":"IF(H7=0,\"\",H7)","v":""},"SF"]
[]
[null,null,null,null,null,"Total Square Footage:",null,{"$f":"O64","v":0},"SF"]
[]
[null,null,"Sales Area"]
[]
[null,null,null,"Wall height (floor to ceiling) is "]
[]
[null,null,null,"Side wall length (LF) ",null,"X",{"$f":"E11-6","v":-6},"Painted top of fixture to ceiling",null,null,null,null,null,null,{"$f":"G13*E13","v":0},"SF"]
[null,null,null,"Side wall length (LF) ",null,"X",{"$f":"E11-6","v":-6},"Painted top of fixture to ceiling",null,null,null,null,null,null,{"$f":"G14*E14","v":0},"SF"]
[null,null,null,"Rear wall length (LF) ",null,"X",{"$f":"E11-6","v":-6},"Painted top of fixture to ceiling",null,null,null,null,null,null,{"$f":"G15*E15","v":0},"SF"]
[null,null,null,"Front wall length (LF) ",null,"X",{"$f":"E11","v":0},"Painted floor to ceiling",null,null,null,"=",{"$f":"G16*E16","v":0},"SF"]
[null,null,null,"Deduct  - glass front width ",null,"X",null," (glass height)",null,null,null,"=",{"$f":"(-G17*E17)","v":0},"SF"]
[null,null,null,"Total front wall ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M16,M17)","v":0},"SF"]
[]
[null,null,null,"Deduct - other non-painted areas (SF)  ",null,null,null,null,null,null,null,null,null,null,{"$f":"-(E20)","v":0},"SF"]
[null,null,null,"(additional windows, doors, etc.) "]
[null,null,null,null,null,null,null,null,null,null,null,"Total Sales Area SF =",null,null,{"$f":"SUM(O13:O15,O18,O20)","v":0},"SF"]
[null,null,"Doors"]
[]
[null,null,null,"Door height is "]
[null,null,null,"LF of walls to paint ",null,"X",{"$f":"E25","v":0},"Painted floor to ceiling",null,null,null,null,null,null,{"$f":"G26*E26","v":0},"SF"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Door Area SF = ",null,null,{"$f":"SUM(O26)","v":0},"SF"]
[]
[null,null,"Office"]
[]
[null,null,null,"Wall height (floor to ceiling) is "]
[null,null,null,"LF of walls to paint ",null,"X",{"$f":"E33","v":0},"Painted floor to ceiling",null,null,null,null,null,null,{"$f":"G34*E34","v":0},"SF"]
[]
[null,null,null,"Deduct - other non-painted areas (SF) ",null,null,null,null,null,null,null,null,null,null,{"$f":"(-E36)","v":0},"SF"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Office Area SF = ",null,null,{"$f":"SUM(O34,O36)","v":0},"SF"]
[null,null,"Break room"]
[]
[null,null,null,"Wall height (floor to ceiling) is "]
[null,null,null,"LF of walls to paint ",null,"X",{"$f":"E41","v":0},"Painted floor to ceiling",null,null,null,null,null,null,{"$f":"G42*E42","v":0},"SF"]
[]
[null,null,null,"Deduct - other non-painted areas (SF) ",null,null,null,null,null,null,null,null,null,null,{"$f":"(-E44)","v":0},"SF"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Break room Area SF = ",null,null,{"$f":"SUM(O42,O44)","v":0},"SF"]
[null,null,"Restrooms"]
[]
[null,null,null,"Wall height (floor to ceiling) is "]
[null,null,null,"LF of walls to paint ",null,"X",{"$f":"E49","v":0},"Painted floor to ceiling",null,null,null,null,null,null,{"$f":"G50*E50","v":0},"SF"]
[]
[null,null,null,"Deduct - other non-painted areas (SF) ",null,null,null,null,null,null,null,null,null,null,{"$f":"(-E52)","v":0},"SF"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Restroom Area SF = ",null,null,{"$f":"SUM(O50,O52)","v":0},"SF"]
[null,null,"Hall and/or additional areas"]
[]
[null,null,null,"Wall height (floor to ceiling) is "]
[null,null,null,"LF of walls to paint ",null,"X",{"$f":"E57","v":0},"Painted floor to ceiling",null,null,null,null,null,null,{"$f":"G58*E58","v":0},"SF"]
[]
[null,null,null,"Deduct - other non-painted areas (SF) ",0,null,null,null,null,null,null,null,null,null,{"$f":"(-E60)","v":0},"SF"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Hall and/or additional Area SF = ",null,null,{"$f":"SUM(O58,O60)","v":0},"SF"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Painted Area SF = ",null,null,{"$f":"SUM(O62,O54,O46,O38,O22,O29)","v":0},"SF"]