{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Hidden","Survey Review Sheet","Paint Calculator","SOW","GC Bid","Additional Billing","Contract Costs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Facilities",null,"Facilities",null,null,"DGTP",null,null,null,null,"GC Database Info"]
["Remodel",null,"Remodel",null,null,"DGP",null,null,null,null,"Advanced Energy Inc."]
["N/A",null,"N/A",null,null,"DGT",null,null,null,null,"Ameritech"]
[null,null,null,null,null,"DGH",null,null,null,null,"Associated Contract Services"]
[null,null,null,null,null,"DGHP",null,null,null,null,"Brandpoint"]
["Yes",null,"2x2",null,null,"DGM",null,null,null,null,"C&C Builders LLC"]
["No",null,"2x4",null,null,"DGPM",null,null,null,null,"Concept Construction"]
["N/a",null,null,null,null,null,null,null,null,null,"DiMarco Construction"]
[null,null,null,null,null,null,null,null,null,null,"Dooley Mack Constructors"]
[null,null,null,null,null,null,null,null,null,null,"Dorsey Development"]
["Leased",null,"Zero Zone",null,null,null,null,null,null,null,"Echelberger Construction Inc"]
["Owned",null,"Hussmann",null,null,null,null,null,null,null,"Falling Design Construction"]
[null,null,"True Mfg",null,null,null,null,null,null,null,"Ferrandino & Son Inc."]
[null,null,null,null,null,null,null,null,null,null,"FHS Design Build LLC"]
[null,null,null,null,null,null,null,null,null,null,"Front Street Retail"]
[null,null,null,null,null,null,null,null,null,null,"Joe R Jones Construction Inc (JRJ)"]
[null,null,null,null,null,null,null,null,null,null,"Jones Builders"]
[null,null,null,null,null,null,null,null,null,null,"Legacy Retail Services"]
[null,null,null,null,null,null,null,null,null,null,"Madewell Construction INC"]
[null,null,null,null,null,null,null,null,null,null,"Mann Construction"]
[null,null,null,null,null,null,null,null,null,null,"Mid Town Electric Company"]
[null,null,null,null,null,null,null,null,null,null,"Mike Rozier"]
[null,null,null,null,null,null,null,null,null,null,"Murray Builders"]
[null,null,null,null,null,null,null,null,null,null,"Newco Construction"]
[null,null,null,null,null,null,null,null,null,null,"P&H Builders"]
[null,null,null,null,null,null,null,null,null,null,"PennTex Ventures"]
[null,null,null,null,null,null,null,null,null,null,"Powerhouse Retail Services"]
[null,null,null,null,null,null,null,null,null,null,"RCI Kimba"]
[null,null,null,null,null,null,null,null,null,null,"RD Lange"]
[null,null,null,null,null,null,null,null,null,null,"Rhetson Company"]
[null,null,null,null,null,null,null,null,null,null,"Rhino Construction"]
[null,null,null,null,null,null,null,null,null,null,"Singleton Construction"]
[null,null,null,null,null,null,null,null,null,null,"SLE"]
[null,null,null,null,null,null,null,null,null,null,"Southwestern Services"]
[null,null,null,null,null,null,null,null,null,null,"Structure Craft"]
[null,null,null,null,null,null,null,null,null,null,"The Hatch Group"]
[null,null,null,null,null,null,null,null,null,null,"The Patton Group"]
[null,null,null,null,null,null,null,null,null,null,"TMS"]
[null,null,null,null,null,null,null,null,null,null,"Vito Construction"]
[null,null,null,null,null,null,null,null,null,null,"Wright Construction"]

{"sheet":"Survey Review Sheet","index":1,"n_rows":115,"n_cols":8,"rows_kept":115,"cut":false,"hidden":false,"merged":[[38,7,39,7],[114,2,114,3],[115,2,115,3],[90,2,90,3],[97,2,97,3],[98,2,98,3],[101,2,101,3],[102,2,102,3],[103,2,103,3],[91,2,91,3],[99,2,99,3],[57,2,57,3],[58,2,58,3],[81,2,81,3],[82,2,82,3],[89,2,89,3],[59,2,59,3],[83,2,83,3],[50,2,50,3],[28,2,28,3],[29,2,29,3],[42,2,42,3],[43,2,43,3],[48,2,48,3],[49,2,49,3],[0,2,0,3],[11,2,11,3],[12,2,12,3],[30,2,30,3],[44,2,44,3]]}
[null,null,"2023 Remodel Survey Checklist"]
[]
[null,null,"Dollar General Store #:"]
[null,null,"Address:"]
[null,null,"City/State:"]
[null,null,"Date Prepared:"]
[null,null,"Survey Prepared By:"]
[null,null,"Format Type:"]
[null,null,"Cooler Vendor:"]
[null,null,"LL Responsible/DG Responsible:"]
[]
[null,null,"Survey Questionnaire"]
[null,null,"Restrooms & Plumbing"]
[null,null,"How many paper towel holders are needed? (standard = 1 per sink)"]
[null,null,"How many double roll toilet paper holders are needed? (standard = 1 per toilet)"]
[null,null,"How many 2'X3' ADA compliant restroom mirrors are needed? (standard = 1 per sink)"]
[null,null,"How many 36\" grab bars needed? (standard = 1 per toilet)"]
[null,null,"How many 42\" grab bars needed? (standard = 1 per toilet)"]
[null,null,"How many toilet tank lids are needed? "]
[null,null,"Does this store have a fully functional mop sink?"]
[null,null,"Is FRP board installed to 4'AFF around mop sink?"]
[null,null,"How many ADA compliant levered door handles are needed? (1 per restroom door)"]
[null,null,"How many ADA compliant toilets need to be replaced?"]
[null,null,"How many ADA compliant wall mounted sinks need to be replaced?"]
[null,null,"How many ADA compliant pipe boots are needed? (standard = 1 per sink)"]
[null,null,"How many ADA compliant restroom signs are needed? (standard = 1 Men's and 1 Women's)"]
[null,null,"How many ADA compliant lever handles needed for faucets? (standard = every restroom sink)"]
[null,null,"How many exhaust fans need to be installed? (standard = one per restroom)"]
[null,null,"Additional Commments - Restrooms & Plumbing"]
[]
[null,null,"Electrical"]
[null,null,"How many existing coolers, freezers, or registers are being powered by a power pole or conduit?"]
[null,null,"Is there an exterior outlet for ice machine?"]
[null,null,"Are breaker locks installed?"]
[null,null,"What is the Brand of Elec. Panels?"]
[null,null,"List number of open circuits. (existing)"]
[null,null,"Is the electrical panel labeled legibly and correct?"]
[null,null,"Existing Phasing"]
[null,null,"Existing Amperage",null,null,null,null,{"$f":"IF(AND(D39<400,D39<>\"\"),\"PLEASE CONTACT REMODEL COORDINATOR\",\"\")","v":""}]
[null,null,"Is there an exisitng McCue Electrical rail installed in front of the electrical panel?"]
[null,null,"Is there an existing backroom cooler unit(s)?"]
[null,null,"Is there an existing backroom freezer unit(s)?"]
[null,null,"Additional Commments - Electrical"]
[]
[null,null,"Lights & Lighting Items"]
[null,null,"Emergency lights repaired/replaced-"]
[null,null,"Exit lights that need to be repaired/replaced-"]
[null,null,"Exit combo lights repaired/replaced-"]
[null,null,"Additional Commments - Lights & Lighting Items"]
[]
[null,null,"Walls & Painting"]
[null,null,"Are there any large holes in the walls? (Baseball size or larger)"]
[null,null,"Number of columns in the sales area?"]
[null,null,"Number of Security Mirrors attached to wall."]
[null,null,"Are there any graphics on the walls? "]
[null,null,"How many doors/frames visible from sales floor? (Exclude Store Front doors)"]
[null,null,"Are there any unused cables or wires hanging from the ceiling?"]
[null,null,"Additional Commments - Wall & Painting"]
[]
[null,null,"Doors & Door Items"]
[null,null,"What are the dimensions of the front door? "]
[null,null,"Front door type?"]
[null,null,"Does the store have a vestibule?"]
[null,null,"If Yes, what is the dimensions of the inner door? "]
[null,null,"Receiving room door type?"]
[null,null,"What are the dimension of the rear receiving room door?"]
[null,null,"What are the dimensions of the interior stockroom door?"]
[null,null,"Is Detex DDH2250 installed on receiving doors on top and bottom?"]
[null,null,"Is there an operational door viewer in the manager's office door?"]
[null,null,"Is there a 2\" Door Scope in the receiving room door?"]
[null,null,"How many restroom, break room, a/o utility doors are missing 4\" kick downs?"]
[null,null,"How many receiving and/or stock room doors are missing 8\" kick downs?"]
[null,null,"How many doors are missing closers?"]
[null,null,"How many receiving and/or stock room doors are missing 8\" kick plates?"]
[null,null,"How many sets of Single door seals and sweeps need to be replaced? (Sales floor and Receiving room exterior doors only)"]
[null,null,"How many sets of Double door seals and sweeps need to be replaced? (Sales floor and Receiving room exterior doors only)"]
[null,null,"How many thresholds need to be replaced?"]
[null,null,"Is there an operational door buzzer at receiving area door?"]
[null,null,"Number of exposed gypsum (drywall) corners."]
[null,null,"Number of cart guards missing. (Should be one per side of each store front door in use)"]
[null,null,"Are there any dead bolts, slide locks, or door bar brackets installed on receiving a/o egress doors?"]
[null,null,"Additional Commments - Doors & Door Items"]
[]
[null,null,"Ceilings"]
[null,null,"Ceiling Height (ft) - if Open, height to lights"]
[null,null,"Ceiling Type"]
[null,null,"Ceiling Tile Size"]
[null,null,"Amount of ceiling tile to replace"]
[null,null,"Number of linear feet of ceiling grid to replace"]
[null,null,"Additional Commments - Ceilings"]
[]
[null,null,"Floors"]
[null,null,"Are Seismic Brackets required per codes? "]
[null,null,"If Yes, how many?"]
[null,null,"Floor Type"]
[null,null,"Amount of floor tile to replace (SF)"]
[null,null,"Amount of cove base to replace (LF)"]
[null,null,"Additional Commments - Floors"]
[]
[null,null,"HVAC"]
[null,null,"List # of thermostats/temp sensors to relocate (<7'AFF a/o attached to power poles)."]
[null,null,"Additional Commments - HVAC"]
[]
[null,null,"Exterior"]
[null,null,"Building Sign Verbiage"]
[null,null,"Are all Building signs fully functional?"]
[null,null,"Are all Pylon signs fully functional?"]
[null,null,"Is the Pylon pole painted black?"]
[null,null,"Are Canopy lights functioning properly?"]
[null,null,"How many missing or damaged handicap signs?"]
[null,null,"Is parking striping visible? (If Yes, leave Blank, if No, please enter # of parking spaces)."]
[null,null,"Number of bollards that need to be repainted? "]
[null,null,"Are there any large potholes/cracks in the pavement?"]
[null,null,"General Parking Lot Condition"]
[null,null,"Additional Commments - Exterior"]

{"sheet":"Paint Calculator","index":2,"n_rows":65,"n_cols":16,"rows_kept":65,"cut":false,"hidden":false,"merged":[[11,7,11,9],[1,2,1,15],[3,2,3,5],[3,7,3,9],[4,2,4,5],[4,7,4,9],[5,2,5,5]]}
[]
[null,null,"PAINT CALCULATOR"]
[]
[null,null,"City/ST:",null,null,null,null,{"$f":"'Survey Review Sheet'!D5","v":0}]
[null,null,"Store number:",null,null,null,null,{"$f":"'Survey Review Sheet'!D3","v":0}]
[null,null,"SF Per Paint Calculator:",null,null,null,null,{"$f":"IF(H8=0,\"\",H8)","v":""},"SF"]
[]
[null,null,null,null,null,"Total Square Footage:",null,{"$f":"O65","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":"E12-6","v":-6},"Painted top of fixture to ceiling",null,null,null,null,null,null,{"$f":"G14*E14","v":0},"SF"]
[null,null,null,"Side wall length (LF) ",null,"X",{"$f":"E12-6","v":-6},"Painted top of fixture to ceiling",null,null,null,null,null,null,{"$f":"G15*E15","v":0},"SF"]
[null,null,null,"Rear wall length (LF) ",null,"X",{"$f":"E12-6","v":-6},"Painted top of fixture to ceiling",null,null,null,null,null,null,{"$f":"G16*E16","v":0},"SF"]
[null,null,null,"Front wall length (LF) ",null,"X",{"$f":"E12","v":0},"Painted floor to ceiling",null,null,null,"=",{"$f":"G17*E17","v":0},"SF"]
[null,null,null,"Deduct  - glass front width ",null,"X",null," (glass height)",null,null,null,"=",{"$f":"(-G18*E18)","v":0},"SF"]
[null,null,null,"Total front wall ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M17,M18)","v":0},"SF"]
[]
[null,null,null,"Deduct - other non-painted areas (SF)  ",null,null,null,null,null,null,null,null,null,null,{"$f":"-(E21)","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(O14:O16,O19,O21)","v":0},"SF"]
[null,null,"Doors"]
[]
[null,null,null,"Door height is "]
[null,null,null,"LF of walls to paint ",null,"X",{"$f":"E26","v":0},"Painted floor to ceiling",null,null,null,null,null,null,{"$f":"G27*E27","v":0},"SF"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Door Area SF = ",null,null,{"$f":"SUM(O27)","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":"E34","v":0},"Painted floor to ceiling",null,null,null,null,null,null,{"$f":"G35*E35","v":0},"SF"]
[]
[null,null,null,"Deduct - other non-painted areas (SF) ",null,null,null,null,null,null,null,null,null,null,{"$f":"(-E37)","v":0},"SF"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Office Area SF = ",null,null,{"$f":"SUM(O35,O37)","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":"E42","v":0},"Painted floor to ceiling",null,null,null,null,null,null,{"$f":"G43*E43","v":0},"SF"]
[]
[null,null,null,"Deduct - other non-painted areas (SF) ",null,null,null,null,null,null,null,null,null,null,{"$f":"(-E45)","v":0},"SF"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Break room Area SF = ",null,null,{"$f":"SUM(O43,O45)","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":"E50","v":0},"Painted floor to ceiling",null,null,null,null,null,null,{"$f":"G51*E51","v":0},"SF"]
[]
[null,null,null,"Deduct - other non-painted areas (SF) ",null,null,null,null,null,null,null,null,null,null,{"$f":"(-E53)","v":0},"SF"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Restroom Area SF = ",null,null,{"$f":"SUM(O51,O53)","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":"E58","v":0},"Painted floor to ceiling",null,null,null,null,null,null,{"$f":"G59*E59","v":0},"SF"]
[]
[null,null,null,"Deduct - other non-painted areas (SF) ",0,null,null,null,null,null,null,null,null,null,{"$f":"(-E61)","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(O59,O61)","v":0},"SF"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Painted Area SF = ",null,null,{"$f":"SUM(O63,O55,O47,O39,O23,O30)","v":0},"SF"]

{"sheet":"SOW","index":3,"n_rows":224,"n_cols":5,"rows_kept":224,"cut":false,"hidden":false,"merged":[[16,1,17,1],[16,2,17,2],[16,3,17,4],[0,1,0,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[2,2,2,4],[6,2,6,4],[5,2,5,4],[4,2,4,4],[3,2,3,4],[7,2,7,4],[1,0,1,4],[9,1,9,4],[10,1,10,4]]}
[null,"Dollar General Remodel Scope of Work 2023 (revision 8/9/2023)"]
[]
[null,"Dollar General Store #:",{"$f":"IF('Survey Review Sheet'!D3=\"\",\"\",'Survey Review Sheet'!D3)","v":""}]
[null,"Address:",{"$f":"IF('Survey Review Sheet'!D4=\"\",\"\",'Survey Review Sheet'!D4)","v":""}]
[null,"City/State:",{"$f":"IF('Survey Review Sheet'!D5=\"\",\"\",'Survey Review Sheet'!D5)","v":""}]
[null,"Primary Format",{"$f":"IF('Survey Review Sheet'!D8=\"\",\"\",'Survey Review Sheet'!D8)","v":""}]
[null,"Cooler Vendor",{"$f":"IF('Survey Review Sheet'!D9=\"\",\"\",'Survey Review Sheet'!D9)","v":""}]
[null,"LL Responsible/DG Responsible",{"$f":"IF('Survey Review Sheet'!D10=\"\",\"\",'Survey Review Sheet'!D10)","v":""}]
[]
[null,"SOW Summary"]
[null,"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. "]
[null,"SOW Quality Requirements"]
[null,"Provide Demised Premises in broom-clean condition; remove and dispose of all trash."]
[null,"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."]
[]
[null,null,null,"CAPITAL (Remodel)","EXPENSE (SFM)"]
[null,"Item","Unit","Quantity"]
[]
[null,"Restrooms & Plumbing",null,"a"]
[null,"Provide & install single roll paper towel dispenser.  ","Ea.",null,{"$f":"IF('Survey Review Sheet'!D14=\"\",\"\",'Survey Review Sheet'!D14)","v":""}]
[null,"Provide & install double roll toilet paper dispenser. ","Ea.",null,{"$f":"IF('Survey Review Sheet'!D15=\"\",\"\",'Survey Review Sheet'!D15)","v":""}]
[null,"Provide & install 24X36 angle frame mirror (or larger if required by code) in restrooms above sink.","Ea.",{"$f":"IF('Survey Review Sheet'!D16=\"\",\"\",'Survey Review Sheet'!D16)","v":""}]
[null,"Provide & install 36\" grab bar.   (To be installed per all applicable codes.)","Ea.",{"$f":"IF('Survey Review Sheet'!D17=\"\",\"\",'Survey Review Sheet'!D17)","v":""}]
[null,"Provide & install 42\" grab bar.   (To be installed per all applicable codes.)","Ea.",{"$f":"IF('Survey Review Sheet'!D18=\"\",\"\",'Survey Review Sheet'!D18)","v":""}]
[null,"Provide and install Toilet Tank Lid.","Ea.",{"$f":"IF('Survey Review Sheet'!D19=\"\",\"\",'Survey Review Sheet'!D19)","v":""}]
[null,"Provide & install pedestal mop sink & faucet set.","Ea.",null,{"$f":"IF('Survey Review Sheet'!D20=\"No\",1,\"\")","v":""}]
[null,"Provide & install FRP (Fiber-Reinforced Plastic) to 4' 0\" AFF around mop sink","Ea.",null,{"$f":"IF('Survey Review Sheet'!D21=\"No\",1,\"\")","v":""}]
[null,"Provide & install Storeroom Leverset.  (To be installed per all applicable codes.)","Ea.",{"$f":"IF('Survey Review Sheet'!D22=\"\",\"\",'Survey Review Sheet'!D22)","v":""}]
[null,"Provide & install ADA compliant toilet","Ea.",{"$f":"IF('Survey Review Sheet'!D23=\"\",\"\",'Survey Review Sheet'!D23)","v":""}]
[null,"Provide & install ADA compliant wall mounted sink ","Ea.",{"$f":"IF('Survey Review Sheet'!D24=\"\",\"\",'Survey Review Sheet'!D24)","v":""}]
[null,"Provide & install ADA compliant pipe boot for sink","Ea.",{"$f":"IF('Survey Review Sheet'!D25=\"\",\"\",'Survey Review Sheet'!D25)","v":""}]
[null,"Provide & install ADA compliant signage","Ea.",{"$f":"IF('Survey Review Sheet'!D26=\"\",\"\",'Survey Review Sheet'!D26)","v":""}]
[null,"Provide & install ADA compliant faucet","Ea.",{"$f":"IF('Survey Review Sheet'!D27=\"\",\"\",'Survey Review Sheet'!D27)","v":""}]
[null,"Provide & install exhaust fan per restroom","Ea.",{"$f":"IF('Survey Review Sheet'!D28=\"\",\"\",'Survey Review Sheet'!D28)","v":""}]
[null,"Install Sky Sink as needed","Ea."]
[null,"Electrical",null,"a"]
[null,"Ensure electrical service is adequate to support anticipated load demands. (Electrical Survey Site Visit / Engineer's Letter)","Store",{"$f":"IF('Survey Review Sheet'!D39 < 400, 1, \"\")","v":1}]
[null,"Demo existing conduits where registers, coolers or freezers are relocated.","Ea.",{"$f":"IF('Survey Review Sheet'!D32=\"\",\"\",'Survey Review Sheet'!D32)","v":""}]
[null,"Provide & install 4 circuit power pole for registers or POS coolers (To include circuit, conduit, J Boxes, & all associated wiring)","Ea.",{"$f":"IF(OR(C6=\"DGTP\",C6=\"DGH\"),3, IF(OR(C6 =\"DGP\",C6=\"DGPM\",C6=\"DGM\"),2,\"\"))","v":""}]
[null,"Provide & install 8 circuit register power pole for CCS register layout.","Store",{"$f":"IF(OR(C6=\"DGPM\",C6=\"DGM\"),2,IF(OR(C6=\"DGHP\",C6=\"DGT\",C6=\"DGP\"),1,\"\"))","v":""}]
[null,"Exterior outlet for ice and/or soda machine","Ea.",{"$f":"IF('Survey Review Sheet'!D33 = \"No\",1,\"\")","v":""}]
[null,"Reconnect all registers & components. (Ensure full operation each register component & complete connectivity for all low voltage connections.) ","Ea.",{"$f":"IF(OR(C6=\"DGPM\",C6=\"DGM\"),4,IF(OR(C6=\"DGTP\",C6=\"DGP\",C6=\"DGH\"),3,IF(OR(C6=\"DGT\",C6=\"DGHP\"),1,\"\")))","v":""}]
[null,"Provide & install breaker locks on electrical panel breakers controlling the night lights, alarm circuit, and exterior stockroom receiving door light","Store",{"$f":"IF('Survey Review Sheet'!D34=\"No\",1,\"\")","v":""}]
[null,"Provide & install electrical subpanel.","Store",{"$f":"IF(OR('Survey Review Sheet'!D36<12,'Survey Review Sheet'!D35=\"Cutler Hammer\"),1,\"\")","v":1}]
[null,"Label electrical panel(s)","Store",{"$f":"IF('Survey Review Sheet'!D37=\"No\",1,\"\")","v":""}]
[null,"Provide & install new 150 W LED wall pack and wiring","Ea."]
[null,"Provide & Install duplex receptacle on new breaker on 1/2\" EMT, single gang J-box, stand-off straps, exposed conduit per decor scheme (115V/60Hz/1-20Amp-NEMA-5-15P) [ End Cap Cooler Power Supply]","Ea."]
[null,"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}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGTP\", $C$6=\"DGP\",$C$6=\"DGH\"),$C$7=\"Zero Zone\"),1,\"\")","v":""}]
[null,"Provide & Install new wire (8/3 gauge) on new double pole 40amp breaker.  Install supplied disconnect box max 18' above each unit. {Zero Zone 4 DR low temp freezer}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGTP\", $C$6=\"DGP\",$C$6=\"DGH\"),$C$7=\"Zero Zone\"),2, IF(AND($C$6=\"DGHP\",$C$7=\"Zero Zone\"),3,\"\"))","v":""}]
[null,"Provide & Install new wire (8/3 gauge) on new double pole 40amp breaker.  Install supplied disconnect box max 18' above each unit. {Zero Zone 5 DR low temp freezer}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGTP\", $C$6=\"DGP\"),$C$7=\"Zero Zone\"),1,\"\")","v":""}]
[null,"Provide & Install new wire (12/3 gauge) on new double pole 20amp breaker.  Install supplied disconnect box max 18' above each unit. {Zero Zone 4 DR Med Temp Cooler}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGP\",$C$6=\"DGH\"),$C$7=\"Zero Zone\"),3,IF(AND($C$6=\"DGHP\", $C$7=\"Zero Zone\"), 1,\"\"))","v":""}]
[null,"Provide & Install new wire (12/3 gauge) on new double pole 20amp breaker.  Install supplied disconnect box max 18' above each unit. {Zero Zone 5 DR Med Temp Cooler}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGP\",$C$6=\"DGHP\"),$C$7=\"Zero Zone\"),2,IF(AND($C$6=\"DGTP\", $C$7=\"Zero Zone\"), 4,\"\"))","v":""}]
[null,"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}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGTP\", $C$6=\"DGP\",$C$6=\"DGH\"),$C$7=\"Hussmann\"),1,\"\")","v":""}]
[null,"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}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGTP\", $C$6=\"DGP\",$C$6=\"DGH\"),$C$7=\"Hussmann\"),2, IF(AND($C$6=\"DGHP\",$C$7=\"Hussmann\"),3,\"\"))","v":""}]
[null,"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}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGTP\", $C$6=\"DGP\"),$C$7=\"Hussmann\"),1,\"\")","v":""}]
[null,"Provide & Install new wire (12/4 gauge) on new double pole 20amp breaker.  Install supplied disconnect box max 18' above each unit. {Hussmann 4 DR Med Temp Cooler}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGP\",$C$6=\"DGH\"),$C$7=\"Hussmann\"),3,IF(AND($C$6=\"DGHP\", $C$7=\"Hussmann\"), 1,\"\"))","v":""}]
[null,"Provide & Install new wire (12/4 gauge) on new double pole 20amp breaker.  Install supplied disconnect box max 18' above each unit. {Hussmann 5 DR Med Temp Cooler}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGP\",$C$6=\"DGHP\"),$C$7=\"Hussmann\"),2,IF(AND($C$6=\"DGTP\", $C$7=\"Hussmann\"), 4,\"\"))","v":""}]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (208-240/60, 5.3 AMP NEMA-L6-15P) {True Mfg Hybrid 2 DR Med Temp Cooler}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGTP\", $C$6=\"DGP\",$C$6=\"DGH\"),$C$7=\"True Mfg\"),1,\"\")","v":""}]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (208-240/60, 10.6 AMP NEMA-L6-15P) {True Mfg Hybrid 3 DR Med Temp Cooler}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGTP\", $C$6=\"DGP\",$C$6=\"DGH\"),$C$7=\"True Mfg\"),2, IF(AND($C$6=\"DGHP\",$C$7=\"True Mfg\"),3,\"\"))","v":""}]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (208-240/60, 10.6 AMP NEMA-L6-15P) {True Mfg Hybrid  4 DR Med Temp Cooler}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGTP\", $C$6=\"DGP\"),$C$7=\"True Mfg\"),1,\"\")","v":""}]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (208-240/60, 13.8 AMP NEMA-L6-20P) {True Mfg Hybrid 2 DR Low Temp Freezer}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGP\",$C$6=\"DGH\"),$C$7=\"True Mfg\"),3,IF(AND($C$6=\"DGHP\", $C$7=\"True Mfg\"), 1,\"\"))","v":""}]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (208-240/60, 13.8 AMP NEMA-L6-20P) {True Mfg Hybrid 3 DR Low Temp Freezer}.","Ea.",{"$f":"IF(AND(OR($C$6=\"DGP\",$C$6=\"DGHP\"),$C$7=\"True Mfg\"),2,IF(AND($C$6=\"DGTP\", $C$7=\"True Mfg\"), 4,\"\"))","v":""}]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (208-240/60, 19.6 AMP NEMA-L6-30P) {True Mfg Hybrid 4 DR Low Temp Freezer}.","Ea."]
[null,"Provide & Install single poll 120 volt drop painted per décor scheme for Pass through Cooler.","Ea."]
[null,"Provide & Install single poll 120 volt drop painted per décor scheme for ECO Atm.","Ea."]
[null,"Provide electrical and install Track Lighting per décor plan.","Track"]
[null,"Provide & Install single Black Channel Pole for center aisle coolers (DGPM only).","Ea."]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (230/60/1 , NEMA 6-15P) {Walk In Freezer}","Ea."]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (115/60/1 , NEMA 5-20) {Walk In Cooler}","Ea."]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (115/60/1 , NEMA 5-20) {Walk In Produce Cooler}","Ea."]
[null,"Provide & Install 2 single pole circuits on 20 amp breakers painted per décor scheme for Sales Floor Produce Cooler. Boxes should be mounted on top of cooler, 1 per side. DGPM Formats","Ea."]
[null,"Provide and Install McCue Electrical Panel Protection Rail (min 3'-0\" panel face)","Ea.",{"$f":"IF('Survey Review Sheet'!D40=\"No\",1,\"\")","v":""}]
[null,"Provide and install two 1/2 conduits to each side of units one side to be duplex receptacle on single pole 20 amp breaker the other side to l14r-20a receptacle on double pole 20 amp breaker both to be in single gang handy boxes with covers attached to units to plate supplied by manufacturers. Howard McCray Produce Cooler","Ea."]
[null,"Install Open Ceiling SO cord for Howard McCray Produce Cooler","Ea."]
[null,"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","Store",{"$f":"IF(OR(C6=\"DGPM\",C6=\"DGM\"),\"\",1)","v":1}]
[null,"Provide & install GFI cover for exposed exterior outlet","Ea."]
[null,"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 True Cooler/True Single Door Freezer (Labeled as Versa on FFP)]","Ea."]
[null,"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 True Freezer (Labeled as Versa on FFP)]","Ea."]
[null,"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)}           ","Ea."]
[null,"Scissor Lift Needed for ceiling heights over 10'","Store"]
[null,"Lights & Lighting Items",null,"a"]
[null,"Wiring of new lights (per light)","Ea."]
[null,"Remove existing lights","Ea."]
[null,"Repair/Replace - ballast(s), bulb(s) as required to repair fixture","Ea."]
[null,"Installation of new lighting","Ea."]
[null,"Provide 4' LED Strip light fixtures (fixture A)","Ea."]
[null,"Provide task light fixture (fixture B)","Ea."]
[null,"Repair/replace existing emergency light to fully operable condition","Ea.",null,{"$f":"IF('Survey Review Sheet'!D46<>0,'Survey Review Sheet'!D46,\"\")","v":""}]
[null,"Repair/replace existing emergency exit sign to fully operable condition","Ea.",null,{"$f":"IF('Survey Review Sheet'!D47<>0,'Survey Review Sheet'!D47,\"\")","v":""}]
[null,"Repair/replace existing exit combo light to fully operable condition","Ea.",null,{"$f":"IF('Survey Review Sheet'!D48<>0,'Survey Review Sheet'!D48,\"\")","v":""}]
[null,"Relocate existing emergency/exit lights","Ea."]
[null,"Walls & Painting",null,"a"]
[null,"Demo interior walls","LF"]
[null,"Repair/Replacement of damaged drywall, small areas","SF"]
[null,"10' - sheetrock one side only","LF"]
[null,"10' - sheetrock both sides, caulked to code","LF"]
[null,"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.","Store"]
[null,"Prepare walls to paint (includes masking and patching); enter SF","SF",{"$f":"SUM(D99,D101:D102)","v":0}]
[null,"Paint sales floor walls - two coats (Per Décor Plan as specified below)","SF",{"$f":"'Paint Calculator'!O23","v":0}]
[null,"Paint sales floor walls - two coats (Sherwin-Williams BLACK MAGIC SW6991, DAISY SW6910) Areas as Indicated on Décor Plan"]
[null,"Paint restroom walls - two coats (Sherwin-Williams PURE WHITE SW7005) Areas as indicated on Décor Plan","SF",{"$f":"'Paint Calculator'!O55","v":0}]
[null,"Paint restroom hallway walls - two coats (Areas & Colors as indicated on Décor Plan)","SF",{"$f":"'Paint Calculator'!O63","v":0}]
[null,"Prep and paint columns; enter number of columns","Ea.",{"$f":"IF('Survey Review Sheet'!D53<>0,'Survey Review Sheet'!D53,\"\")","v":""}]
[null,"Provide stud wall with finished drywall to 6’ A.F.F. & painted top cap","Store"]
[null,"Remove, remount, & adjust security mirror as needed for painting","Ea.",null,{"$f":"IF('Survey Review Sheet'!D54=\"\",\"\",'Survey Review Sheet'!D54)","v":""}]
[null,"Remove wall graphics & repair wall as needed for painting","Store",null,{"$f":"IF('Survey Review Sheet'!D55=\"Yes\",1,\"\")","v":""}]
[null,"Paint doors and frames visible from sales floor","Ea.",{"$f":"IF('Survey Review Sheet'!D56=\"\",\"\",'Survey Review Sheet'!D56)","v":""}]
[null,"Remove beverage board from sales floor walls as needed per fixture plan","Store"]
[null,"Remove any unused cables/wires hanging from ceiling","Store",null,{"$f":"IF('Survey Review Sheet'!D57=\"Yes\",1,\"\")","v":""}]
[null,"Wrap column with tight loop carpet (Black) from base to 48” A.F.F.","Ea."]
[null,"Build fixture/corner box per Final Fixture Plan as needed","Store"]
[null,"Install furring strips for 6' pre-paid wall as needed per Final Fixture Plan","Store"]
[null,"Install furring strips for 10' pre-paid wall as needed per Final Fixture Plan","Store"]
[null,"Doors & Door Items",null,"a"]
[null,"Provide & install 3'-0\" solid-core restroom door (w/ hardware, 4\" kick down, and door closer)","Ea."]
[null,"Provide & install 4'-0\" solid-core stockroom door (w/ hardware, 8\" kick down, interior & exterior pull handles, 2 - 8\" kick plates, and door closer)","Ea."]
[null,"Provide & install 3'-0\" fire-rated emergency egress door (w/hardware, panic bar w/ hardware, and door closer)","Ea."]
[null,"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) ","Ea."]
[null,"Provide & install 6'-0\" X 7'-0\" solid core double stockroom doors (w/ hardware, interior and exterior pull handles, door stops, interior and exterior 8\" kick plates, and 2-door closers)","Ea."]
[null,"Provide & install 6'-0\" X 7'-0\" fire rated double receiving doors with heavy duty low profile threshold (w/ hardware, interior pull handle, panic bar w/ hardware, 8\" kick down, 2\" 180 deg. door scope,  door closer, and double door holder) [Per Door] ","Ea."]
[null,"Provide & install Double Door Holder ","Ea.",{"$f":"IF('Survey Review Sheet'!D68=\"No\",1,\"\")","v":""}]
[null,"Provide & install pull plate & push plate on stock room door (1  pull plate & 1 push plate per door) [Remove lockset if existing]","Door"]
[null,"Provide & install door viewer in manager's office door (180 degree viewing angle)","Ea.",{"$f":"IF('Survey Review Sheet'!D69=\"No\",1,\"\")","v":""}]
[null,"Provide & install 2\" door scope in receiving exit door (180 degree viewing angle)","Ea.",{"$f":"IF('Survey Review Sheet'!D70=\"No\",1,\"\")","v":""}]
[null,"Provide & install 4\" kick down type door holder (1 each door: restroom, break room)","Ea.",null,{"$f":"IF('Survey Review Sheet'!D71=\"\",\"\",'Survey Review Sheet'!D71)","v":""}]
[null,"Provide & install 8\" kick down type door stop (1 each per door: stockroom, receiving)","Ea.",null,{"$f":"IF('Survey Review Sheet'!D72=\"\",\"\",'Survey Review Sheet'!D72)","v":""}]
[null,"Provide & install door closer (1 per door) ","Ea.",null,{"$f":"IF('Survey Review Sheet'!D73=\"\",\"\",'Survey Review Sheet'!D73)","v":""}]
[null,"Provide & install Von Duprin Guard-X Exit Alarm Lock &  Rim Cylinder ","Ea."]
[null,"Provide & install Von Duprin Guard-X Double Door Strike (Double Door Only)","Ea."]
[null,"Provide & install  8\" kick plate on \"push\" side of stockroom/receiving door","Ea."]
[null,"Replace seals & sweeps for 3' & 4' single door openings","Ea.",null,{"$f":"IF('Survey Review Sheet'!D75=\"\",\"\",'Survey Review Sheet'!D75)","v":""}]
[null,"Replace seals & sweeps for double door openings","Ea.",null,{"$f":"IF('Survey Review Sheet'!D76=\"\",\"\",'Survey Review Sheet'!D76)","v":""}]
[null,"Provide & install HD threshold for receiving doors","Ea.",null,{"$f":"IF('Survey Review Sheet'!D77=\"\",\"\",'Survey Review Sheet'!D77)","v":""}]
[null,"Provide & install standard door buzzer","Ea.",null,{"$f":"IF('Survey Review Sheet'!D78=\"No\",1,\"\")","v":""}]
[null,"Provide & install McCue black vertical trim on corners mounted on top of cove base","Ea.",{"$f":"IF('Survey Review Sheet'!D79<>0,'Survey Review Sheet'!D79,\"\")","v":""}]
[null,"Provide & install cart guard(s) on storefront door. [3/8\" X 2\" Aluminum flat stock. Finished to match existing door]","Ea.",null,{"$f":"IF('Survey Review Sheet'!D80<>0,'Survey Review Sheet'!D80,\"\")","v":""}]
[null,"Provide & install McCue cart corral trim kit: Complete Package (2 vertical trim pieces, 4 bumper guards and floor mounted cart stop).","Store"]
[null,"Demo any dead bolts, slide locks, bar brackets installed on receiving a/o egress door(s).","Store",null,{"$f":"IF('Survey Review Sheet'!D81=\"Yes\",1,\"\")","v":""}]
[null,"Ceilings",null,"a"]
[null,"Demo existing ceiling tile","SF",null,{"$f":"IF('Survey Review Sheet'!D88<>\"\",'Survey Review Sheet'!D88,\"\")","v":""}]
[null,"Demo existing ceiling grid","LF",null,{"$f":"IF('Survey Review Sheet'!D89<>\"\",'Survey Review Sheet'!D89,\"\")","v":""}]
[null,"Repair existing ceiling grid","LF"]
[null,"Provide/install ceiling grid (labor & material)","LF",null,{"$f":"IF('Survey Review Sheet'!D89<>\"\",'Survey Review Sheet'!D89,\"\")","v":""}]
[null,"Provide & install new ceiling tile ","SF",null,{"$f":"IF('Survey Review Sheet'!D88<>\"\",'Survey Review Sheet'!D88,\"\")","v":""}]
[null,"Floors",null,"a"]
[null,"Remove carpet or tile (per layer - labor only)","SF"]
[null,"Prepare floor for tile--includes sanding, patching, leveling & sweeping of floors (labor & materials)","SF",null,{"$f":"IF('Survey Review Sheet'!D96<>\"\",'Survey Review Sheet'!D96,\"\")","v":""}]
[null,"Provide 1/8\" floor tile","SF",null,{"$f":"IF('Survey Review Sheet'!D96<>\"\",'Survey Review Sheet'!D96,\"\")","v":""}]
[null,"Provide & install clear tile adhesive","SF",null,{"$f":"IF('Survey Review Sheet'!D96<>\"\",'Survey Review Sheet'!D96,\"\")","v":""}]
[null,"Provide/install black cove base (labor & material)","LF",null,{"$f":"IF('Survey Review Sheet'!D97<>\"\",'Survey Review Sheet'!D97,\"\")","v":""}]
[null,"install seismic straps as needed per code.","Store",{"$f":"IF('Survey Review Sheet'!D93=\"Yes\",1,\"\")","v":""}]
[null,"HVAC",null,"a"]
[null,"Relocate temperature sensor/thermostat above fixture line (labor & material)","Ea."]
[null,"Exterior",null,"a"]
[null,"Provide and install railing for receiving dock edge","Store"]
[null,"Repair building sign to fully operable condition.","Store",null,{"$f":"IF(AND('Survey Review Sheet'!D106=\"Yes\",$C$18=\"DG Responsible\"),1,\"\")","v":""}]
[null,"Repair pylon to fully operable condition.","Store",null,{"$f":"IF(AND('Survey Review Sheet'!D107=\"Yes\",$C$18=\"DG Responsible\"),1,\"\")","v":""}]
[null,"Repair canopy lighting to fully operable condition","Store",null,{"$f":"IF(AND('Survey Review Sheet'!D109=\"Yes\",$C$18=\"DG Responsible\"),1,\"\")","v":""}]
[null,"Power wash store front & sidewalk","Store",null,1]
[null,"Re-paint exterior door(s) for with rust preventative/inhibiting enamel paint to match existing color. (Receiving or Egress)","Ea."]
[null,"Repair exterior security lighting to fully operable condition","Ea."]
[null,"Repaint pylon pole black","Ea.",{"$f":"IF('Survey Review Sheet'!D108=\"No\",1,\"\")","v":""}]
[null,"Add or replace handicap signage on building and/or bollard (To be applied per DG Criteria Set and all applicable codes.)","Ea.",{"$f":"IF(AND('Survey Review Sheet'!D110<>\"\",$C$8=\"DG Responsible\"),'Survey Review Sheet'!D110,\"\")","v":""}]
[null,"Re-stripe parking lot. (To be applied per DG Criteria Set and all applicable codes.)","Ea.",{"$f":"IF(AND('Survey Review Sheet'!D111<>\"\",$C$8=\"DG Responsible\"),'Survey Review Sheet'!D111,\"\")","v":""}]
[null,"Paint bollard safety yellow","Ea.",{"$f":"IF(AND('Survey Review Sheet'!D112<>\"\",$C$8=\"DG Responsible\"),'Survey Review Sheet'!D112,\"\")","v":""}]
[null,"Fill pot holes in parking lot and drives.","Store",null,{"$f":"IF(AND('Survey Review Sheet'!D113<>\"\",$C$8=\"DG Responsible\"),1,\"\")","v":""}]
[null,"Re-pave parking lot.","Store",null,{"$f":"IF(AND('Survey Review Sheet'!D114=\"Poor\",$C$8=\"DG Responsible\"),1,\"\")","v":""}]
[null,"Install banner bolts (4 per pack)","Store",1]
[null,"LL RESPONSIBLE ITEMS",null,"a"]
[null,"Provide and install railing for receiving dock edge","Store"]
[null,"Repair building sign to fully operable condition.","Store",null,{"$f":"IF(AND('Survey Review Sheet'!D106=\"No\",$C$8=\"LL Responsible\"),1,\"\")","v":""}]
[null,"Repair pylon to fully operable condition.","Store",null,{"$f":"IF(AND('Survey Review Sheet'!D107=\"No\",$C$8=\"LL Responsible\"),1,\"\")","v":""}]
[null,"Repair canopy lighting to fully operable condition","Store",null,{"$f":"IF(AND('Survey Review Sheet'!D109=\"No\",$C$8=\"LL Responsible\"),1,\"\")","v":""}]
[null,"Repair exterior security lighting to fully operable condition","Ea."]
[null,"Add or replace handicap signage on building and/or bollard (To be applied per DG Criteria Set and all applicable codes.)","Ea.",{"$f":"IF(AND('Survey Review Sheet'!D110<>\"\",$C$8=\"LL Responsible\"),'Survey Review Sheet'!D110,\"\")","v":""}]
[null,"Re-stripe parking lot. (To be applied per DG Criteria Set and all applicable codes.)","Ea.",{"$f":"IF(AND('Survey Review Sheet'!D111<>\"\",$C$8=\"LL Responsible\"),'Survey Review Sheet'!D111,\"\")","v":""}]
[null,"Fill pot holes in parking lot and drives.","Store",null,{"$f":"IF(AND('Survey Review Sheet'!E113<>\"\",$C$8=\"LL Responsible\"),1,\"\")","v":""}]
[null,"Re-pave parking lot.","Store",null,{"$f":"IF(AND('Survey Review Sheet'!E114=\"Poor\",$C$8=\"LL Responsible\"),1,\"\")","v":""}]
[null,"Repair roof as needed","Store"]
[null,"Repair parking lot pole lighting as needed.","Store"]
[null,"Additional Items",null,"a"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Do not delete"]

{"sheet":"GC Bid","index":4,"n_rows":213,"n_cols":15,"rows_kept":213,"cut":false,"hidden":false,"merged":[[30,0,73,0],[5,2,5,7],[6,2,6,7],[0,0,0,5],[1,0,1,5],[2,0,2,1],[2,2,2,7],[3,2,3,7],[4,2,4,7],[3,0,3,1],[4,0,4,1],[5,0,5,1],[7,2,7,7],[8,2,8,7],[7,0,7,1],[6,0,6,1],[212,0,212,5],[7,9,7,10],[8,9,8,10],[204,6,204,7],[205,1,205,5],[207,1,207,5],[208,1,208,5],[209,1,209,5],[209,6,209,7],[9,0,9,5],[75,0,85,0],[10,2,10,7],[11,6,12,6],[190,0,191,0],[193,0,202,0],[8,0,8,1],[210,0,211,5],[11,7,12,7],[203,9,203,12],[109,0,132,0],[134,0,138,0],[205,0,209,0],[204,1,204,5],[165,0,169,0],[171,0,188,0],[87,0,107,0],[203,2,203,5],[140,0,145,0],[149,0,163,0],[208,9,208,12],[209,9,209,12],[13,0,28,0],[8,11,8,13],[7,11,7,13],[6,11,6,13],[11,14,12,14],[206,9,206,14],[11,13,12,13],[6,9,6,10],[209,13,209,14],[207,9,207,12],[10,9,10,14],[204,13,204,14],[204,9,204,12],[205,9,205,12]]}
["Dollar General Contractor Remodel Bid (revision 8/9/2023)"]
[]
["Dollar General Store No.:",null,{"$f":"IF('Survey Review Sheet'!D3=\"\",\"\",'Survey Review Sheet'!D3)","v":""}]
["Address:",null,{"$f":"IF('Survey Review Sheet'!D4=\"\",\"\",'Survey Review Sheet'!D4)","v":""}]
["City/State:",null,{"$f":"IF('Survey Review Sheet'!D5=\"\",\"\",'Survey Review Sheet'!D5)","v":""}]
["General Contractor:"]
["Format Type:",null,{"$f":"IF('Survey Review Sheet'!D8=\"\",\"\",'Survey Review Sheet'!D8)","v":""},null,null,null,null,null,null,"Invoice Number:"]
["Date of Estimate:",null,null,null,null,null,null,null,null,"Date of Invoice:"]
["Proposed Totals:",null,{"$f":"G210","v":3800.8},null,null,null,null,null,null,"Invoice Total",null,{"$f":"N210","v":0}]
[]
[null,null,"Estimated Costs",null,null,null,null,null,null,"Invoice"]
[null,null,"CAPITAL","EXPENSE",null,null,"Line Item - CAP","Line Item - EXP",null,"CAPITAL","EXPENSE",null,null,"Line Item - CAP","Line Item - EXP"]
[null,"Item","Quantity","Quantity","Unit","Price",null,null,null,"Quantity","Quantity","Unit","Price"]
["Restrooms & Plumbing","Provide & install Bobrick item # B253 single roll paper towel dispenser",{"$f":"IF(SOW!D20=\"\",\"\",SOW!D20)","v":""},{"$f":"IF(SOW!E20=\"\",\"\",SOW!E20)","v":""},"each",23,{"$f":"IF(C14=\"\",\"\",C14*F14)","v":""},{"$f":"IF(D14=\"\",\"\",D14*F14)","v":""},null,null,null,"each",23,{"$f":"IF(J14=\"\",\"\",J14*M14)","v":""},{"$f":"IF(K14=\"\",\"\",K14*M14)","v":""}]
[null,"Provide & install Bobrick item # B2740 double roll toilet paper dispenser",{"$f":"IF(SOW!D21=\"\",\"\",SOW!D21)","v":""},{"$f":"IF(SOW!E21=\"\",\"\",SOW!E21)","v":""},"each",28,{"$f":"IF(C15=\"\",\"\",C15*F15)","v":""},{"$f":"IF(D15=\"\",\"\",D15*F15)","v":""},null,null,null,"each",28,{"$f":"IF(J15=\"\",\"\",J15*M15)","v":""},{"$f":"IF(K15=\"\",\"\",K15*M15)","v":""}]
[null,"Provide & install Gamco item # A - 24X36 - 24\" x 36\" angle frame mirror (or larger if required by code) in restrooms above sink",{"$f":"IF(SOW!D22=\"\",\"\",SOW!D22)","v":""},{"$f":"IF(SOW!E22=\"\",\"\",SOW!E22)","v":""},"each",115,{"$f":"IF(C16=\"\",\"\",C16*F16)","v":""},"",null,null,null,"each",115,"",""]
[null,"Provide & install Gamco 1 1/2\" x 36\" grab bar",{"$f":"IF(SOW!D23=\"\",\"\",SOW!D23)","v":""},{"$f":"IF(SOW!E23=\"\",\"\",SOW!E23)","v":""},"each",86,"","",null,null,null,"each",86,"",""]
[null,"Provide & install Gamco 1 1/2\" x 42\" grab bar",{"$f":"IF(SOW!D24=\"\",\"\",SOW!D24)","v":""},{"$f":"IF(SOW!E24=\"\",\"\",SOW!E24)","v":""},"each",86,"","",null,null,null,"each",86,"",""]
[null,"Provide and install toilet tank lid",{"$f":"IF(SOW!D25=\"\",\"\",SOW!D25)","v":""},{"$f":"IF(SOW!E25=\"\",\"\",SOW!E25)","v":""},"each",75,"","",null,null,null,"each",75,"",""]
[null,"Provide & install pedestal mop sink, faucet set, and Gamco M5-1 Mop holder",{"$f":"IF(SOW!D26=\"\",\"\",SOW!D26)","v":""},{"$f":"IF(SOW!E26=\"\",\"\",SOW!E26)","v":""},"each",391,"","",null,null,null,"each",391,"",""]
[null,"Provide & install FRP (Fiber-Reinforced Plastic) to 4' 0\" AFF around mop sink",{"$f":"IF(SOW!D27=\"\",\"\",SOW!D27)","v":""},{"$f":"IF(SOW!E27=\"\",\"\",SOW!E27)","v":""},"sheet",144,"","",null,null,null,"sheet",144,"",""]
[null,"Provide & install Bass Security item # W581PD – DANE – 626 Falcon Storeroom Leverset. ",{"$f":"IF(SOW!D28=\"\",\"\",SOW!D28)","v":""},{"$f":"IF(SOW!E28=\"\",\"\",SOW!E28)","v":""},"each",86,"","",null,null,null,"each",86,"",""]
[null,"Provide & install ADA compliant toilet",{"$f":"IF(SOW!D29=\"\",\"\",SOW!D29)","v":""},{"$f":"IF(SOW!E29=\"\",\"\",SOW!E29)","v":""},"each",316,"","",null,null,null,"each",316,"",""]
[null,"Provide & install ADA compliant wall mounted sink ",{"$f":"IF(SOW!D30=\"\",\"\",SOW!D30)","v":""},{"$f":"IF(SOW!E30=\"\",\"\",SOW!E30)","v":""},"each",230,"","",null,null,null,"each",230,"",""]
[null,"Provide & install ADA compliant pipe boot for sink",{"$f":"IF(SOW!D31=\"\",\"\",SOW!D31)","v":""},{"$f":"IF(SOW!E31=\"\",\"\",SOW!E31)","v":""},"each",58,"","",null,null,null,"each",58,"",""]
[null,"Provide & install ADA compliant signage",{"$f":"IF(SOW!D32=\"\",\"\",SOW!D32)","v":""},{"$f":"IF(SOW!E32=\"\",\"\",SOW!E32)","v":""},"each",52,"","",null,null,null,"each",52,"",""]
[null,"Provide & install ADA compliant faucet",{"$f":"IF(SOW!D33=\"\",\"\",SOW!D33)","v":""},{"$f":"IF(SOW!E33=\"\",\"\",SOW!E33)","v":""},"each",98,"","",null,null,null,"each",98,"",""]
[null,"Provide & install exhaust fan per restroom",{"$f":"IF(SOW!D34=\"\",\"\",SOW!D34)","v":""},{"$f":"IF(SOW!E34=\"\",\"\",SOW!E34)","v":""},"each",184,"","",null,null,null,"each",184,"",""]
[null,"Install Sky Sink as needed",{"$f":"IF(SOW!D35=\"\",\"\",SOW!D35)","v":""},{"$f":"IF(SOW!E35=\"\",\"\",SOW!E35)","v":""},"each",833,{"$f":"IF(C29=\"\",\"\",C29*F29)","v":""},{"$f":"IF(D29=\"\",\"\",D29*F29)","v":""},null,null,null,"each",833,{"$f":"IF(J29=\"\",\"\",J29*M29)","v":""},{"$f":"IF(K29=\"\",\"\",K29*M29)","v":""}]
[null,null,null,null,null,null,{"$f":"SUM(G14:G29)","v":0},{"$f":"SUM(H14:H29)","v":0},null,null,null,null,null,{"$f":"SUM(N14:N29)","v":0},{"$f":"SUM(O14:O29)","v":0}]
["Electrical","Ensure electrical service is adequate to support anticipated load demands. (Electrical Survey Site Visit / Engineer's Letter)",{"$f":"IF(SOW!D37=\"\",\"\",SOW!D37)","v":1},{"$f":"IF(SOW!E37=\"\",\"\",SOW!E37)","v":""},"per store",1000,{"$f":"IF(C31=\"\",\"\",C31*F31)","v":1000},{"$f":"IF(D31=\"\",\"\",D31*F31)","v":""},null,null,null,"per store",1000,{"$f":"IF(J31=\"\",\"\",J31*M31)","v":""},{"$f":"IF(K31=\"\",\"\",K31*M31)","v":""}]
[null,"Demo existing conduits where registers, coolers or freezers are relocated.",{"$f":"IF(SOW!D38=\"\",\"\",SOW!D38)","v":""},{"$f":"IF(SOW!E38=\"\",\"\",SOW!E38)","v":""},"each",115,{"$f":"IF(C32=\"\",\"\",C32*F32)","v":""},{"$f":"IF(D32=\"\",\"\",D32*F32)","v":""},null,null,null,"each",115,{"$f":"IF(J32=\"\",\"\",J32*M32)","v":""},{"$f":"IF(K32=\"\",\"\",K32*M32)","v":""}]
[null,"Provide & install 4 circuit power pole for registers or POS coolers (To include circuit, conduit, J Boxes, & all associated wiring)",{"$f":"IF(SOW!D39=\"\",\"\",SOW!D39)","v":""},{"$f":"IF(SOW!E39=\"\",\"\",SOW!E39)","v":""},"each",1350,{"$f":"IF(C33=\"\",\"\",C33*F33)","v":""},{"$f":"IF(D33=\"\",\"\",D33*F33)","v":""},null,null,null,"each",1350,{"$f":"IF(J33=\"\",\"\",J33*M33)","v":""},{"$f":"IF(K33=\"\",\"\",K33*M33)","v":""}]
[null,"Provide & install 8 circuit register power pole for CCS register layout.",{"$f":"IF(SOW!D40=\"\",\"\",SOW!D40)","v":""},{"$f":"IF(SOW!E40=\"\",\"\",SOW!E40)","v":""},"per store",3105,"","",null,null,null,"per store",3105,"",""]
[null,"Exterior outlet for ice and/or soda machine",{"$f":"IF(SOW!D41=\"\",\"\",SOW!D41)","v":""},{"$f":"IF(SOW!E41=\"\",\"\",SOW!E41)","v":""},"per store",345,"","",null,null,null,"per store",345,"",""]
[null,"Reconnect all registers & components. (Ensure full operation each register component & complete connectivity for all low voltage connections.) ",{"$f":"IF(SOW!D42=\"\",\"\",SOW!D42)","v":""},{"$f":"IF(SOW!E42=\"\",\"\",SOW!E42)","v":""},"each",350,{"$f":"IF(C36=\"\",\"\",C36*F36)","v":""},"",null,null,null,"per store",350,"",""]
[null,"Provide & install breaker locks on electrical panel breakers controlling the night lights, alarm circuit, and exterior stockroom receiving door light",{"$f":"IF(SOW!D43=\"\",\"\",SOW!D43)","v":""},{"$f":"IF(SOW!E43=\"\",\"\",SOW!E43)","v":""},"per store",46,"","",null,null,null,"per store",46,"",""]
[null,"Provide & install electrical subpanel.",{"$f":"IF(SOW!D44=\"\",\"\",SOW!D44)","v":1},{"$f":"IF(SOW!E44=\"\",\"\",SOW!E44)","v":""},"per store",875,875,"",null,null,null,"per store",875,"",""]
[null,"Label electrical panel(s)",{"$f":"IF(SOW!D45=\"\",\"\",SOW!D45)","v":""},{"$f":"IF(SOW!E45=\"\",\"\",SOW!E45)","v":""},"per store",86,"","",null,null,null,"per store",86,"",""]
[null,"Provide & install new 150 W LED wall pack and wiring",{"$f":"IF(SOW!D46=\"\",\"\",SOW!D46)","v":""},{"$f":"IF(SOW!E46=\"\",\"\",SOW!E46)","v":""},"each",431,"","",null,null,null,"each",431,"",""]
[null,"Provide & Install duplex receptacle on new breaker on 1/2\" EMT, single gang J-box, stand-off straps, exposed conduit per decor scheme (115V/60Hz/1-20Amp-NEMA-5-15P) [End Cap Cooler Power Supply]",{"$f":"IF(SOW!D47=\"\",\"\",SOW!D47)","v":""},{"$f":"IF(SOW!E47=\"\",\"\",SOW!E47)","v":""},"each",350,"","",null,null,null,"each",350,"",""]
[null,"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}.",{"$f":"IF(SOW!D48=\"\",\"\",SOW!D48)","v":""},{"$f":"IF(SOW!E48=\"\",\"\",SOW!E48)","v":""},"each",805,"","",null,null,null,"each",805,"",""]
[null,"Provide & Install new wire (8/3 gauge) on new double pole 40amp breaker.  Install supplied disconnect box max 18' above each unit. {Zero Zone 4 DR low temp freezer}.",{"$f":"IF(SOW!D49=\"\",\"\",SOW!D49)","v":""},{"$f":"IF(SOW!E49=\"\",\"\",SOW!E49)","v":""},"each",863,"","",null,null,null,"each",863,"",""]
[null,"Provide & Install new wire (8/3 gauge) on new double pole 40amp breaker.  Install supplied disconnect box max 18' above each unit. {Zero Zone 5 DR low temp freezer}.",{"$f":"IF(SOW!D50=\"\",\"\",SOW!D50)","v":""},{"$f":"IF(SOW!E50=\"\",\"\",SOW!E50)","v":""},"each",863,"","",null,null,null,"each",863,"",""]
[null,"Provide & Install new wire (12/3 gauge) on new double pole 15amp breaker.  Install supplied disconnect box max 18' above each unit. {Zero Zone 4 DR Med Temp Cooler}.",{"$f":"IF(SOW!D51=\"\",\"\",SOW!D51)","v":""},{"$f":"IF(SOW!E51=\"\",\"\",SOW!E51)","v":""},"each",748,"","",null,null,null,"each",748,"",""]
[null,"Provide & Install new wire (12/3 gauge) on new double pole 15amp breaker.  Install supplied disconnect box max 18' above each unit. {Zero Zone 5 DR Med Temp Cooler}.",{"$f":"IF(SOW!D52=\"\",\"\",SOW!D52)","v":""},{"$f":"IF(SOW!E52=\"\",\"\",SOW!E52)","v":""},"each",748,"","",null,null,null,"each",748,"",""]
[null,"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}.",{"$f":"IF(SOW!D53=\"\",\"\",SOW!D53)","v":""},{"$f":"IF(SOW!E53=\"\",\"\",SOW!E53)","v":""},"each",805,"","",null,null,null,"each",805,"",""]
[null,"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}.",{"$f":"IF(SOW!D54=\"\",\"\",SOW!D54)","v":""},{"$f":"IF(SOW!E54=\"\",\"\",SOW!E54)","v":""},"each",863,"","",null,null,null,"each",863,"",""]
[null,"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}.",{"$f":"IF(SOW!D55=\"\",\"\",SOW!D55)","v":""},{"$f":"IF(SOW!E55=\"\",\"\",SOW!E55)","v":""},"each",863,"","",null,null,null,"each",863,"",""]
[null,"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}.",{"$f":"IF(SOW!D56=\"\",\"\",SOW!D56)","v":""},{"$f":"IF(SOW!E56=\"\",\"\",SOW!E56)","v":""},"each",748,"","",null,null,null,"each",748,"",""]
[null,"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}.",{"$f":"IF(SOW!D57=\"\",\"\",SOW!D57)","v":""},{"$f":"IF(SOW!E57=\"\",\"\",SOW!E57)","v":""},"each",748,"","",null,null,null,"each",748,"",""]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (208-240/60, 5.3 AMP NEMA-L6-15P) {True Mfg Hybrid 2 DR Med Temp Cooler}.",{"$f":"IF(SOW!D58=\"\",\"\",SOW!D58)","v":""},{"$f":"IF(SOW!E58=\"\",\"\",SOW!E58)","v":""},"each",825,"","",null,null,null,"each",825,"",""]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (208-240/60, 10.6 AMP NEMA-L6-15P) {True Mfg Hyrbid 3 DR Med Temp Cooler}.",{"$f":"IF(SOW!D59=\"\",\"\",SOW!D59)","v":""},{"$f":"IF(SOW!E59=\"\",\"\",SOW!E59)","v":""},"each",825,"","",null,null,null,"each",825,"",""]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (208-240/60, 10.6 AMP NEMA-L6-15P) {True Mfg Hyrbid 4 DR Med Temp Cooler}.",{"$f":"IF(SOW!D60=\"\",\"\",SOW!D60)","v":""},{"$f":"IF(SOW!E60=\"\",\"\",SOW!E60)","v":""},"each",825,"","",null,null,null,"each",825,"",""]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (208-240/60, 13.8 AMP NEMA-L6-20P) {True Mfg Hybrid 2 DR Low Temp Freezer}.",{"$f":"IF(SOW!D61=\"\",\"\",SOW!D61)","v":""},{"$f":"IF(SOW!E61=\"\",\"\",SOW!E61)","v":""},"each",905,"","",null,null,null,"each",905,"",""]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (208-240/60, 13.8 AMP NEMA-L6-20P) {True Mfg Hybrid 3 DR Low Temp Freezer}.",{"$f":"IF(SOW!D62=\"\",\"\",SOW!D62)","v":""},{"$f":"IF(SOW!E62=\"\",\"\",SOW!E62)","v":""},"each",905,"","",null,null,null,"each",905,"",""]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (208-240/60, 19.6 AMP NEMA-L6-30P) {True Mfg Hyrbid 4 DR Low Temp Freezer}.",{"$f":"IF(SOW!D63=\"\",\"\",SOW!D63)","v":""},{"$f":"IF(SOW!E63=\"\",\"\",SOW!E63)","v":""},"each",905,{"$f":"IF(C57=\"\",\"\",C57*F57)","v":""},{"$f":"IF(D57=\"\",\"\",D57*F57)","v":""},null,null,null,"each",905,{"$f":"IF(J57=\"\",\"\",J57*M57)","v":""},{"$f":"IF(K57=\"\",\"\",K57*M57)","v":""}]
[null,"Provide & Install single poll 120 volt drop painted per décor scheme for Pass through Cooler.",{"$f":"IF(SOW!D64=\"\",\"\",SOW!D64)","v":""},{"$f":"IF(SOW!E64=\"\",\"\",SOW!E64)","v":""},"each",350,"","",null,null,null,"each",350,"",""]
[null,"Provide & Install single poll 120 volt drop painted per décor scheme for ECO Atm.",{"$f":"IF(SOW!D65=\"\",\"\",SOW!D65)","v":""},{"$f":"IF(SOW!E65=\"\",\"\",SOW!E65)","v":""},"each",350,"","",null,null,null,"each",350,"",""]
[null,"Provide electrical and install Track Lighting per décor plan.",{"$f":"IF(SOW!D66=\"\",\"\",SOW!D66)","v":""},{"$f":"IF(SOW!E66=\"\",\"\",SOW!E66)","v":""},"track",750,"","",null,null,null,"track",750,"",""]
[null,"Provide & Install single Black Channel Pole for center aisle coolers (DGPM only).",{"$f":"IF(SOW!D67=\"\",\"\",SOW!D67)","v":""},{"$f":"IF(SOW!E67=\"\",\"\",SOW!E67)","v":""},"each",300,"","",null,null,null,"each",300,"",""]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (230/60/1 , NEMA 6-15P) {Walk In Freezer}",{"$f":"IF(SOW!D68=\"\",\"\",SOW!D68)","v":""},{"$f":"IF(SOW!E68=\"\",\"\",SOW!E68)","v":""},"each",1350,"","",null,null,null,"each",1350,"",""]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (115/60/1 , NEMA 5-20) {Walk In Cooler}",{"$f":"IF(SOW!D69=\"\",\"\",SOW!D69)","v":""},{"$f":"IF(SOW!E69=\"\",\"\",SOW!E69)","v":""},"each",1350,"","",null,null,null,"each",1350,"",""]
[null,"Provide & Install receptacle on new breaker in 1/2\" EMT painted per décor scheme (115/60/1 , NEMA 5-20) {Walk In Produce Cooler}",{"$f":"IF(SOW!D70=\"\",\"\",SOW!D70)","v":""},{"$f":"IF(SOW!E70=\"\",\"\",SOW!E70)","v":""},"each",1300,"","",null,null,null,"each",1300,"",""]
[null,"Provide & Install 2 single pole circuits on 20 amp breakers painted per décor scheme for Sales Floor Produce Cooler. Boxes should be mounted on top of cooler, 1 per side. DGPM",{"$f":"IF(SOW!D71=\"\",\"\",SOW!D71)","v":""},{"$f":"IF(SOW!E71=\"\",\"\",SOW!E71)","v":""},"each",1300,"","",null,null,null,"each",1300,"",""]
[null,"Provide and Install McCue Electrical Panel Protection Rail (min 3'-0\" panel face)",{"$f":"IF(SOW!D72=\"\",\"\",SOW!D72)","v":""},{"$f":"IF(SOW!E72=\"\",\"\",SOW!E72)","v":""},"each",362,"","",null,null,null,"each",362,"",""]
[null,"Provide and install two 1/2 conduits to each side of units one side to be duplex receptacle on single pole 20 amp breaker the other side to l14r-20a receptacle on double pole 20 amp breaker both to be in single gang handy boxes with covers attached to units to plate supplied by manufacturers. Howard McCray Produce Cooler",{"$f":"IF(SOW!D73=\"\",\"\",SOW!D73)","v":""},{"$f":"IF(SOW!E73=\"\",\"\",SOW!E73)","v":""},"each",748,"","",null,null,null,"each",748,"",""]
[null,"Install Open Ceiling SO cord for Howard McCray Produce Cooler",{"$f":"IF(SOW!D74=\"\",\"\",SOW!D74)","v":""},{"$f":"IF(SOW!E74=\"\",\"\",SOW!E74)","v":""},"each",200,"","",null,null,null,"each",200,"",""]
[null,"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.",{"$f":"IF(SOW!D75=\"\",\"\",SOW!D75)","v":1},{"$f":"IF(SOW!E75=\"\",\"\",SOW!E75)","v":""},"each",1150,1150,"",null,null,null,"each",1150,"",""]
[null,"Provide & install GFI cover for exposed exterior outlet",{"$f":"IF(SOW!D76=\"\",\"\",SOW!D76)","v":""},{"$f":"IF(SOW!E76=\"\",\"\",SOW!E76)","v":""},"each",40,"","",null,null,null,"each",40,"",""]
[null,"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/True Single Door Freezer (Labeled as Versa on FFP)]",{"$f":"IF(SOW!D77=\"\",\"\",SOW!D77)","v":""},{"$f":"IF(SOW!E77=\"\",\"\",SOW!E77)","v":""},"each",288,"","",null,null,null,"each",288,"",""]
[null,"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 (Labeled as Versa on FFP)]",{"$f":"IF(SOW!D78=\"\",\"\",SOW!D78)","v":""},{"$f":"IF(SOW!E78=\"\",\"\",SOW!E78)","v":""},"each",345,"","",null,null,null,"each",345,"",""]
[null,"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)}           ",{"$f":"IF(SOW!D79=\"\",\"\",SOW!D79)","v":""},{"$f":"IF(SOW!E79=\"\",\"\",SOW!E79)","v":""},"each",288,"","",null,null,null,"each",288,"",""]
[null,"Scissor Lift Needed for ceiling heights over 10'",{"$f":"IF(SOW!D80=\"\",\"\",SOW!D80)","v":""},{"$f":"IF(SOW!E80=\"\",\"\",SOW!E80)","v":""},"estimate",0,{"$f":"IF(C74=\"\",\"\",C74*F74)","v":""},{"$f":"IF(D74=\"\",\"\",D74*F74)","v":""},null,null,null,"estimate",0,"",""]
[null,null,null,null,null,null,{"$f":"SUM(G31:G74)","v":3025},{"$f":"SUM(H31:H74)","v":0},null,null,null,null,null,{"$f":"SUM(N31:N74)","v":0},{"$f":"SUM(O31:O74)","v":0}]
["Lights & Lighting Items","Wiring of new lights (per light)",{"$f":"IF(SOW!D82=\"\",\"\",SOW!D82)","v":""},{"$f":"IF(SOW!E82=\"\",\"\",SOW!E82)","v":""},"each",25,{"$f":"IF(C76=\"\",\"\",C76*F76)","v":""},{"$f":"IF(D76=\"\",\"\",D76*F76)","v":""},null,null,null,"each",25,{"$f":"IF(J76=\"\",\"\",J76*M76)","v":""},{"$f":"IF(K76=\"\",\"\",K76*M76)","v":""}]
[null,"Remove existing lights",{"$f":"IF(SOW!D83=\"\",\"\",SOW!D83)","v":""},{"$f":"IF(SOW!E83=\"\",\"\",SOW!E83)","v":""},"each",8,{"$f":"IF(C77=\"\",\"\",C77*F77)","v":""},{"$f":"IF(D77=\"\",\"\",D77*F77)","v":""},null,null,null,"each",8,{"$f":"IF(J77=\"\",\"\",J77*M77)","v":""},{"$f":"IF(K77=\"\",\"\",K77*M77)","v":""}]
[null,"Repair/Replace - ballast(s), bulb(s) as required to repair fixture",{"$f":"IF(SOW!D84=\"\",\"\",SOW!D84)","v":""},{"$f":"IF(SOW!E84=\"\",\"\",SOW!E84)","v":""},"each",58,"","",null,null,null,"each",58,"",""]
[null,"Installation of new lighting",{"$f":"IF(SOW!D85=\"\",\"\",SOW!D85)","v":""},{"$f":"IF(SOW!E85=\"\",\"\",SOW!E85)","v":""},"each",63,"","",null,null,null,"each",63,"",""]
[null,"Provide 4' LED Strip light fixtures (fixture A)",{"$f":"IF(SOW!D86=\"\",\"\",SOW!D86)","v":""},{"$f":"IF(SOW!E86=\"\",\"\",SOW!E86)","v":""},"each",36,"","",null,null,null,"each",36,"",""]
[null,"Provide task light fixture (fixture B)",{"$f":"IF(SOW!D87=\"\",\"\",SOW!D87)","v":""},{"$f":"IF(SOW!E87=\"\",\"\",SOW!E87)","v":""},"each",28,"","",null,null,null,"each",28,"",""]
[null,"Provide & install emergency lights ",{"$f":"IF(SOW!D88=\"\",\"\",SOW!D88)","v":""},{"$f":"IF(SOW!E88=\"\",\"\",SOW!E88)","v":""},"each",175,"","",null,null,null,"each",175,"",""]
[null,"Provide & install emergency exit lights",{"$f":"IF(SOW!D89=\"\",\"\",SOW!D89)","v":""},{"$f":"IF(SOW!E89=\"\",\"\",SOW!E89)","v":""},"each",175,"","",null,null,null,"each",175,"",""]
[null,"Repair emergency lights/exit lights",null,null,"each",25,{"$f":"IF(C84=\"\",\"\",C84*F84)","v":""},{"$f":"IF(D84=\"\",\"\",D84*F84)","v":""},null,null,null,"each",25,"",""]
[null,"Provide & install exit combo light",{"$f":"IF(SOW!D90=\"\",\"\",SOW!D90)","v":""},{"$f":"IF(SOW!E90=\"\",\"\",SOW!E90)","v":""},"each",190,"","",null,null,null,"each",190,"",""]
[null,"Relocate existing emergency/exit lights",{"$f":"IF(SOW!D91=\"\",\"\",SOW!D91)","v":""},{"$f":"IF(SOW!E91=\"\",\"\",SOW!E91)","v":""},"each",300,"","",null,null,null,"each",300,"",""]
[null,null,null,null,null,null,{"$f":"SUM(G76:G86)","v":0},{"$f":"SUM(H76:H86)","v":0},null,null,null,null,null,{"$f":"SUM(N76:N86)","v":0},{"$f":"SUM(O76:O86)","v":0}]
["Walls & Painting","Demo interior walls",{"$f":"IF(SOW!D93=\"\",\"\",SOW!D93)","v":""},{"$f":"IF(SOW!E93=\"\",\"\",SOW!E93)","v":""},"LF",16,{"$f":"IF(C88=\"\",\"\",C88*F88)","v":""},{"$f":"IF(D88=\"\",\"\",D88*F88)","v":""},null,null,null,"LF",16,{"$f":"IF(J88=\"\",\"\",J88*M88)","v":""},{"$f":"IF(K88=\"\",\"\",K88*M88)","v":""}]
[null,"Repair/Replacement of damaged drywall, small areas",{"$f":"IF(SOW!D94=\"\",\"\",SOW!D94)","v":""},{"$f":"IF(SOW!E94=\"\",\"\",SOW!E94)","v":""},"SF",2,{"$f":"IF(C89=\"\",\"\",C89*F89)","v":""},{"$f":"IF(D89=\"\",\"\",D89*F89)","v":""},null,null,null,"SF",2,{"$f":"IF(J89=\"\",\"\",J89*M89)","v":""},{"$f":"IF(K89=\"\",\"\",K89*M89)","v":""}]
[null,"10' - sheetrock one side only",{"$f":"IF(SOW!D95=\"\",\"\",SOW!D95)","v":""},{"$f":"IF(SOW!E95=\"\",\"\",SOW!E95)","v":""},"LF",30,"","",null,null,null,"LF",30,"",""]
[null,"10' - sheetrock both sides, caulked to code",{"$f":"IF(SOW!D96=\"\",\"\",SOW!D96)","v":""},{"$f":"IF(SOW!E96=\"\",\"\",SOW!E96)","v":""},"LF",35,"","",null,null,null,"LF",35,"",""]
[null,"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.",{"$f":"IF(SOW!D97=\"\",\"\",SOW!D97)","v":""},{"$f":"IF(SOW!E97=\"\",\"\",SOW!E97)","v":""},"per store",575,"","",null,null,null,"per store",575,"",""]
[null,"Prepare walls to paint (includes masking and patching); enter SF",{"$f":"IF(SOW!D98=\"\",\"\",SOW!D98)","v":0},{"$f":"IF(SOW!E98=\"\",\"\",SOW!E98)","v":""},"SF",0.16,0,"",null,null,null,"SF",0.16,"",""]
[null,"Prime or block-out wall area (new sheetrock and/or dark paint)",null,null,"SF",0.55000000000000004,{"$f":"IF(C94=\"\",\"\",C94*F94)","v":""},{"$f":"IF(D94=\"\",\"\",D94*F94)","v":""},null,null,null,"SF",0.55000000000000004,"",""]
[null,"Paint walls - first coat",{"$f":"IF(SOW!D99=\"\",\"\",SUM(SOW!D99,SOW!D101:D102))","v":0},{"$f":"IF(SOW!E99=\"\",\"\",SOW!E99)","v":""},"SF",0.6,{"$f":"IF(C95=\"\",\"\",C95*F95)","v":0},{"$f":"IF(D95=\"\",\"\",D95*F95)","v":""},null,null,null,"SF",0.6,"",""]
[null,"Paint walls - second coat (only if required by SOW); enter SF",{"$f":"IF(SOW!D99=\"\",\"\",SUM(SOW!D99,SOW!D101:D102))","v":0},{"$f":"IF(SOW!E100=\"\",\"\",SOW!E100)","v":""},"SF",0.52,0,"",null,null,null,"SF",0.52,"",""]
[null,"Prep and paint columns; enter number of columns",{"$f":"IF(SOW!D103=\"\",\"\",SOW!D103)","v":""},{"$f":"IF(SOW!E103=\"\",\"\",SOW!E103)","v":""},"each",55,"","",null,null,null,"each",55,"",""]
[null,"Provide stud wall with finished drywall to 6’ A.F.F. & painted top cap",{"$f":"IF(SOW!D104=\"\",\"\",SOW!D104)","v":""},{"$f":"IF(SOW!E104=\"\",\"\",SOW!E104)","v":""},"estimate",0,"","",null,null,null,"estimate",0,"",""]
[null,"Remove, remount, & adjust security mirror as needed for painting",{"$f":"IF(SOW!D105=\"\",\"\",SOW!D105)","v":""},{"$f":"IF(SOW!E105=\"\",\"\",SOW!E105)","v":""},"each",29,"","",null,null,null,"each",29,"",""]
[null,"Remove wall graphics & repair wall as needed for painting",{"$f":"IF(SOW!D106=\"\",\"\",SOW!D106)","v":""},{"$f":"IF(SOW!E106=\"\",\"\",SOW!E106)","v":""},"each",230,"","",null,null,null,"each",230,"",""]
[null,"Paint doors and frames visible from sales floor",{"$f":"IF(SOW!D107=\"\",\"\",SOW!D107)","v":""},{"$f":"IF(SOW!E107=\"\",\"\",SOW!E107)","v":""},"each",58,"","",null,null,null,"each",58,"",""]
[null,"Remove beverage board from sales floor walls as needed per fixture plan",{"$f":"IF(SOW!D108=\"\",\"\",SOW!D108)","v":""},{"$f":"IF(SOW!E108=\"\",\"\",SOW!E108)","v":""},"per store",115,"","",null,null,null,"per store",115,"",""]
[null,"Remove any unused cables/wires hanging from ceiling",{"$f":"IF(SOW!D109=\"\",\"\",SOW!D109)","v":""},{"$f":"IF(SOW!E109=\"\",\"\",SOW!E109)","v":""},"per store",58,"","",null,null,null,"per store",58,"",""]
[null,"Wrap column with tight loop carpet (Black) from base to 48” A.F.F.",{"$f":"IF(SOW!D110=\"\",\"\",SOW!D110)","v":""},{"$f":"IF(SOW!E110=\"\",\"\",SOW!E110)","v":""},"each",86,"","",null,null,null,"each",86,"",""]
[null,"Build fixture/corner box per Final Fixture Plan as needed",{"$f":"IF(SOW!D111=\"\",\"\",SOW!D111)","v":""},{"$f":"IF(SOW!E111=\"\",\"\",SOW!E111)","v":""},"per store",115,"","",null,null,null,"per store",115,"",""]
[null,"Demo existing soffitt - DGPM Only",null,null,"estimate",0,null,null,null,null,null,"estimate",0,{"$f":"IF(J106=\"\",\"\",J106*M106)","v":""},{"$f":"IF(K106=\"\",\"\",K106*M106)","v":""}]
[null,"Install furring strips for 6' pre-paid wall as needed per Final Fixture Plan",{"$f":"IF(SOW!D112=\"\",\"\",SOW!D112)","v":""},{"$f":"IF(SOW!E112=\"\",\"\",SOW!E112)","v":""},"per store",150,"","",null,null,null,"per store",150,"",""]
[null,"Install furring strips for 10' pre-paid wall as needed per Final Fixture Plan",{"$f":"IF(SOW!D113=\"\",\"\",SOW!D113)","v":""},{"$f":"IF(SOW!E113=\"\",\"\",SOW!E113)","v":""},"per store",150,"","",null,null,null,"per store",150,"",""]
[null,null,null,null,null,null,{"$f":"SUM(G88:G108)","v":0},{"$f":"SUM(H88:H108)","v":0},null,null,null,null,null,{"$f":"SUM(N88:N108)","v":0},{"$f":"SUM(O88:O108)","v":0}]
["Doors & Door Items","Provide & install 3'-0\" solid-core restroom door (w/ hardware, 4\" kick down, and door closer)",{"$f":"IF(SOW!D115=\"\",\"\",SOW!D115)","v":""},{"$f":"IF(SOW!E115=\"\",\"\",SOW!E115)","v":""},"each",590,{"$f":"IF(C110=\"\",\"\",C110*F110)","v":""},{"$f":"IF(D110=\"\",\"\",D110*F110)","v":""},null,null,null,"each",590,{"$f":"IF(J110=\"\",\"\",J110*M110)","v":""},{"$f":"IF(K110=\"\",\"\",K110*M110)","v":""}]
[null,"Provide & install 4'-0\" solid-core stockroom door (w/ hardware, 8\" kick down, interior & exterior pull handles, 2 - 8\" kick plates, and door closer)",{"$f":"IF(SOW!D116=\"\",\"\",SOW!D116)","v":""},{"$f":"IF(SOW!E116=\"\",\"\",SOW!E116)","v":""},"each",700,{"$f":"IF(C111=\"\",\"\",C111*F111)","v":""},{"$f":"IF(D111=\"\",\"\",D111*F111)","v":""},null,null,null,"each",700,{"$f":"IF(J111=\"\",\"\",J111*M111)","v":""},{"$f":"IF(K111=\"\",\"\",K111*M111)","v":""}]
[null,"Provide & install 3'-0\" fire-rated emergency egress door (w/hardware, panic bar w/ hardware, and door closer) - Location: Exterior Sales Floor Wall",{"$f":"IF(SOW!D117=\"\",\"\",SOW!D117)","v":""},{"$f":"IF(SOW!E117=\"\",\"\",SOW!E117)","v":""},"each",920,"","",null,null,null,"each",920,"",""]
[null,"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) - Location: Exterior Receiving Wall",{"$f":"IF(SOW!D118=\"\",\"\",SOW!D118)","v":""},{"$f":"IF(SOW!E118=\"\",\"\",SOW!E118)","v":""},"each",1275,"","",null,null,null,"each",1275,"",""]
[null,"Provide & install 6'-0\" X 7'-0\" solid core double stockroom doors (w/ hardware, interior and exterior pull handles, door stops, interior and exterior 8\" kick plates, and 2-door closers) - Location: Sales/Receiving Wall",{"$f":"IF(SOW!D119=\"\",\"\",SOW!D119)","v":""},{"$f":"IF(SOW!E119=\"\",\"\",SOW!E119)","v":""},"each",975,"","",null,null,null,"each",975,"",""]
[null,"Provide & install 6'-0\" X 7'-0\" fire rated double receiving doors with heavy duty low profile threshold (w/ hardware, interior pull handle, panic bar w/ hardware, 8\" kick down, 2\" 180 deg. door scope,  door closer, and double door holder) [Per Door] - Location: Exterior Receiving Wall",{"$f":"IF(SOW!D120=\"\",\"\",SOW!D120)","v":""},{"$f":"IF(SOW!E120=\"\",\"\",SOW!E120)","v":""},"each",2000,"","",null,null,null,"each",2000,"",""]
[null,"Provide & install Bass Security item # DDH-2250 Double Door Holder ",{"$f":"IF(SOW!D121=\"\",\"\",SOW!D121)","v":""},{"$f":"IF(SOW!E121=\"\",\"\",SOW!E121)","v":""},"each",161,"","",null,null,null,"each",161,"",""]
[null,"Provide & install pull plate & push plate on stock room door (1 Bass Security item # 33E-32D-26D-GRIP pull plate & 1 Bass Security item # 30S-US32D push plate per door) [Remove lockset if existing]",{"$f":"IF(SOW!D122=\"\",\"\",SOW!D122)","v":""},{"$f":"IF(SOW!E122=\"\",\"\",SOW!E122)","v":""},"each",23,"","",null,null,null,"each",23,"",""]
[null,"Provide & install Bass Security item # 1756 door viewer in manager's office door (180 degree viewing angle)",{"$f":"IF(SOW!D123=\"\",\"\",SOW!D123)","v":""},{"$f":"IF(SOW!E123=\"\",\"\",SOW!E123)","v":""},"each",29,"","",null,null,null,"each",29,"",""]
[null,"Provide & install Bass Security item # DS/1000MB 2\" door scope in receiving exit door (180 degree viewing angle)",{"$f":"IF(SOW!D124=\"\",\"\",SOW!D124)","v":""},{"$f":"IF(SOW!E124=\"\",\"\",SOW!E124)","v":""},"each",86,"","",null,null,null,"each",86,"",""]
[null,"Provide & install Bass Security item # 452B26D-4 4\" kick down type door holder (1 each door: bathroom)",{"$f":"IF(SOW!D125=\"\",\"\",SOW!D125)","v":""},{"$f":"IF(SOW!E125=\"\",\"\",SOW!E125)","v":""},"each",23,"","",null,null,null,"each",23,"",""]
[null,"Provide & install Bass Security item # 608Z 8\" kick down type door stop (1 each per door: stockroom, receiving)",{"$f":"IF(SOW!D126=\"\",\"\",SOW!D126)","v":""},{"$f":"IF(SOW!E126=\"\",\"\",SOW!E126)","v":""},"each",29,"","",null,null,null,"each",29,"",""]
[null,"Provide & install Bass Security item # 5400 Hager door closer (1 per door) on manager's office, break room, and restroom door",{"$f":"IF(SOW!D127=\"\",\"\",SOW!D127)","v":""},{"$f":"IF(SOW!E127=\"\",\"\",SOW!E127)","v":""},"each",98,"","",null,null,null,"each",98,"",""]
[null,"Provide & install Bass Security item # 5400 Hager door closer (1 per door) on stockroom and receiving door",{"$f":"IF(SOW!D128=\"\",\"\",SOW!D128)","v":""},{"$f":"IF(SOW!E128=\"\",\"\",SOW!E128)","v":""},"each",98,"","",null,null,null,"each",98,"",""]
[null,"Provide & install panic bar and hardware ",{"$f":"IF(SOW!D129=\"\",\"\",SOW!D129)","v":""},{"$f":"IF(SOW!E129=\"\",\"\",SOW!E129)","v":""},"each",340,"","",null,null,null,"each",340,"",""]
[null,"Provide & install Bass Security item #190S-32D-8X34 8\" kick plate on \"push\" side of stockroom/receiving door",{"$f":"IF(SOW!D130=\"\",\"\",SOW!D130)","v":""},{"$f":"IF(SOW!E130=\"\",\"\",SOW!E130)","v":""},"each",40,"","",null,null,null,"each",40,"",""]
[null,"Provide & install seals & sweeps for 3' & 4' single door openings",{"$f":"IF(SOW!D131=\"\",\"\",SOW!D131)","v":""},{"$f":"IF(SOW!E131=\"\",\"\",SOW!E131)","v":""},"each",75,"","",null,null,null,"each",75,"",""]
[null,"Provide & install seals & sweeps for double door openings",{"$f":"IF(SOW!D132=\"\",\"\",SOW!D132)","v":""},{"$f":"IF(SOW!E132=\"\",\"\",SOW!E132)","v":""},"each",150,"","",null,null,null,"each",150,"",""]
[null,"Provide & install Bass Security item #425HD-6FT National Guard HD threshold for receiving doors",{"$f":"IF(SOW!D133=\"\",\"\",SOW!D133)","v":""},{"$f":"IF(SOW!E133=\"\",\"\",SOW!E133)","v":""},"each",173,"","",null,null,null,"each",173,"",""]
[null,"Install standard door buzzer",{"$f":"IF(SOW!D134=\"\",\"\",SOW!D134)","v":""},{"$f":"IF(SOW!E134=\"\",\"\",SOW!E134)","v":""},"each",86,"","",null,null,null,"each",86,"",""]
[null,"Provide & install McCue item #CG - V175K - 401 black vertical trim on corners mounted on top of cove base",{"$f":"IF(SOW!D135=\"\",\"\",SOW!D135)","v":""},{"$f":"IF(SOW!E135=\"\",\"\",SOW!E135)","v":""},"per set",46,"","",null,null,null,"per set",46,"",""]
[null,"Provide & install cart guard on storefront door",{"$f":"IF(SOW!D136=\"\",\"\",SOW!D136)","v":""},{"$f":"IF(SOW!E136=\"\",\"\",SOW!E136)","v":""},"per door",46,"","",null,null,null,"per door",46,"",""]
[null,"Provide & install McCue cart corral trim kit package (to include 2 vertical trim pieces, 4 bumper guards and floor mounted cart stop).",{"$f":"IF(SOW!D137=\"\",\"\",SOW!D137)","v":""},{"$f":"IF(SOW!E137=\"\",\"\",SOW!E137)","v":""},"per store",564,"","",null,null,null,"per store",564,"",""]
[null,"Demo any deadbolts, slide locks, bar brackets installed on receiving a/o egress doors",{"$f":"IF(SOW!D138=\"\",\"\",SOW!D138)","v":""},{"$f":"IF(SOW!E138=\"\",\"\",SOW!E138)","v":""},"each",40,"","",null,null,null,"each",40,"",""]
[null,null,null,null,null,null,{"$f":"SUM(G110:G133)","v":0},{"$f":"SUM(H110:H133)","v":0},null,null,null,null,null,{"$f":"SUM(N110:N133)","v":0},{"$f":"SUM(O110:O133)","v":0}]
["Ceilings","Demo existing ceiling tile",{"$f":"IF(SOW!D140=\"\",\"\",SOW!D140)","v":""},{"$f":"IF(SOW!E140=\"\",\"\",SOW!E140)","v":""},"SF",0.16,{"$f":"IF(C135=\"\",\"\",C135*F135)","v":""},{"$f":"IF(D135=\"\",\"\",D135*F135)","v":""},null,null,null,"SF",0.16,{"$f":"IF(J135=\"\",\"\",J135*M135)","v":""},{"$f":"IF(K135=\"\",\"\",K135*M135)","v":""}]
[null,"Demo existing ceiling grid",{"$f":"IF(SOW!D141=\"\",\"\",SOW!D141)","v":""},{"$f":"IF(SOW!E141=\"\",\"\",SOW!E141)","v":""},"SF",0.16,{"$f":"IF(C136=\"\",\"\",C136*F136)","v":""},{"$f":"IF(D136=\"\",\"\",D136*F136)","v":""},null,null,null,"SF",0.16,{"$f":"IF(J136=\"\",\"\",J136*M136)","v":""},{"$f":"IF(K136=\"\",\"\",K136*M136)","v":""}]
[null,"Repair existing ceiling grid",{"$f":"IF(SOW!D142=\"\",\"\",SOW!D142)","v":""},{"$f":"IF(SOW!E142=\"\",\"\",SOW!E142)","v":""},"SF",1.55,{"$f":"IF(C137=\"\",\"\",C137*F137)","v":""},{"$f":"IF(D137=\"\",\"\",D137*F137)","v":""},null,null,null,"SF",1.55,{"$f":"IF(J137=\"\",\"\",J137*M137)","v":""},{"$f":"IF(K137=\"\",\"\",K137*M137)","v":""}]
[null,"Provide/install ceiling grid (labor & material)",{"$f":"IF(SOW!D143=\"\",\"\",SOW!D143)","v":""},{"$f":"IF(SOW!E143=\"\",\"\",SOW!E143)","v":""},"SF",1.27,{"$f":"IF(C138=\"\",\"\",C138*F138)","v":""},{"$f":"IF(D138=\"\",\"\",D138*F138)","v":""},null,null,null,"SF",1.27,{"$f":"IF(J138=\"\",\"\",J138*M138)","v":""},{"$f":"IF(K138=\"\",\"\",K138*M138)","v":""}]
[null,"Provide & install new ceiling tile ",{"$f":"IF(SOW!D144=\"\",\"\",SOW!D144)","v":""},{"$f":"IF(SOW!E144=\"\",\"\",SOW!E144)","v":""},"SF",1.04,{"$f":"IF(C139=\"\",\"\",C139*F139)","v":""},{"$f":"IF(D139=\"\",\"\",D139*F139)","v":""},null,null,null,"SF",1.04,{"$f":"IF(J139=\"\",\"\",J139*M139)","v":""},{"$f":"IF(K139=\"\",\"\",K139*M139)","v":""}]
[null,null,null,null,null,null,{"$f":"SUM(G135:G139)","v":0},{"$f":"SUM(H135:H139)","v":0},null,null,null,null,null,{"$f":"SUM(N135:N139)","v":0},{"$f":"SUM(O135:O139)","v":0}]
["Floors","Remove carpet or tile (per layer - labor only)",{"$f":"IF(SOW!D146=\"\",\"\",SOW!D146)","v":""},{"$f":"IF(SOW!E146=\"\",\"\",SOW!E146)","v":""},"SF",0.28999999999999998,{"$f":"IF(C141=\"\",\"\",C141*F141)","v":""},{"$f":"IF(D141=\"\",\"\",D141*F141)","v":""},null,null,null,"SF",0.28999999999999998,{"$f":"IF(J141=\"\",\"\",J141*M141)","v":""},{"$f":"IF(K141=\"\",\"\",K141*M141)","v":""}]
[null,"Install floor tile (labor only)",{"$f":"IF(SOW!D147=\"\",\"\",SOW!D147)","v":""},{"$f":"IF(SOW!E147=\"\",\"\",SOW!E147)","v":""},"SF",1,"","",null,null,null,"SF",1,"",""]
[null,"Provide 1/8\" floor tile (1 Add. Case Included)",{"$f":"IF(SOW!D148=\"\",\"\",(SOW!D148/45)+1)","v":""},{"$f":"IF(SOW!E148=\"\",\"\",ROUND(((SOW!E148/45)+1),0))","v":""},"cases",100,"","",null,null,null,"cases",100,"",""]
[null,"Provide & install clear tile adhesive",{"$f":"IF(SOW!D149=\"\",\"\",SOW!D149)","v":""},{"$f":"IF(SOW!E149=\"\",\"\",SOW!E149)","v":""},"SF",1,"",{"$f":"IF(D144=\"\",\"\",D144*F144)","v":""},null,null,null,"SF",1,"",{"$f":"IF(K144=\" \",\"\",K144*M144)","v":0}]
[null,"Provide/install black cove base (labor & material)",{"$f":"IF(SOW!D150=\"\",\"\",SOW!D150)","v":""},{"$f":"IF(SOW!E150=\"\",\"\",SOW!E150)","v":""},"LF",2,"","",null,null,null,"LF",2,"",""]
[null,"Install seismic straps as needed per code.",{"$f":"IF(SOW!D151=\"\",\"\",SOW!D151)","v":""},{"$f":"IF(SOW!E151=\"\",\"\",SOW!E151)","v":""},"per store",500,"","",null,null,null,"per store",500,{"$f":"IF(J146=\"\",\"\",J146*M146)","v":""},{"$f":"IF(K146=\"\",\"\",K146*M146)","v":""}]
[null,null,null,null,null,null,{"$f":"SUM(G141:G143)+SUM(G144:G146)","v":0},{"$f":"SUM(H141:H143)+SUM(H144:H146)","v":0},null,null,null,null,null,{"$f":"SUM(N141:N143)+SUM(N144:N146)","v":0},{"$f":"SUM(O141:O143)+SUM(O144:O146)","v":0}]
["HVAC","Relocate temperature sensor/thermostat above fixture line (labor & material)",{"$f":"IF(SOW!D153=\"\",\"\",SOW!D153)","v":""},{"$f":"IF(SOW!E152=\"\",\"\",SOW!E152)","v":""},"each",58,{"$f":"IF(C148=\"\",\"\",C148*F148)","v":""},{"$f":"IF(D148=\"\",\"\",D148*F148)","v":""},null,null,null,"each",58,{"$f":"IF(J148=\"\",\"\",J148*M148)","v":""},{"$f":"IF(K148=\"\",\"\",K148*M148)","v":""}]
[null,null,null,null,null,null,{"$f":"SUM(G148:G148)","v":0},{"$f":"SUM(H148:H148)","v":0},null,null,null,null,null,{"$f":"SUM(N148:N148)","v":0},{"$f":"SUM(O148:O148)","v":0}]
["Exterior","Provide and install railing for receiving dock edge",{"$f":"IF(SOW!D155=\"\",\"\",SOW!D155)","v":""},{"$f":"IF(SOW!E155=\"\",\"\",SOW!E155)","v":""},"LF",40,{"$f":"IF(C150=\"\",\"\",C150*F150)","v":""},{"$f":"IF(D150=\"\",\"\",D150*F150)","v":""},null,null,null,"LF",40,{"$f":"IF(J150=\"\",\"\",J150*M150)","v":""},{"$f":"IF(K150=\"\",\"\",K150*M150)","v":""}]
[null,"Repair building sign to fully operable condition.",{"$f":"IF(SOW!D156=\"\",\"\",SOW!D156)","v":""},{"$f":"IF(SOW!E156=\"\",\"\",SOW!E156)","v":""},"estimate",0,{"$f":"IF(C151=\"\",\"\",C151*F151)","v":""},{"$f":"IF(D151=\"\",\"\",D151*F151)","v":""},null,null,null,"estimate",0,{"$f":"IF(J151=\"\",\"\",J151*M151)","v":""},{"$f":"IF(K151=\"\",\"\",K151*M151)","v":""}]
[null,"Repair pylon to fully operable condition.",{"$f":"IF(SOW!D157=\"\",\"\",SOW!D157)","v":""},{"$f":"IF(SOW!E157=\"\",\"\",SOW!E157)","v":""},"estimate",0,"","",null,null,null,"estimate",0,"",""]
[null,"Repair canopy lighting to fully operable condition",{"$f":"IF(SOW!D158=\"\",\"\",SOW!D158)","v":""},{"$f":"IF(SOW!E158=\"\",\"\",SOW!E158)","v":""},"estimate",0,"","",null,null,null,"estimate",0,"",""]
[null,"Power wash store front & sidewalk",{"$f":"IF(SOW!D159=\"\",\"\",SOW!D159)","v":""},{"$f":"IF(SOW!E159=\"\",\"\",SOW!E159)","v":1},"per store",230,"",230,null,null,null,"per store",230,"",""]
[null,"Repair building sign to fully operable condition",null,null,"estimate",0,"","",null,null,null,"estimate",0,"",""]
[null,"Re-paint exterior door(s) for with rust preventative/inhibiting enamel paint to match existing color. (Receiving or Egress)",{"$f":"IF(SOW!D160=\"\",\"\",SOW!D160)","v":""},{"$f":"IF(SOW!E160=\"\",\"\",SOW!E160)","v":""},"estimate",0,"","",null,null,null,"estimate",0,"",""]
[null,"Repair exterior security lighting to fully operable condition",{"$f":"IF(SOW!D161=\"\",\"\",SOW!D161)","v":""},{"$f":"IF(SOW!E161=\"\",\"\",SOW!E161)","v":""},"estimate",0,"","",null,null,null,"estimate",0,"",""]
[null,"Repaint pylon pole black",{"$f":"IF(SOW!D162=\"\",\"\",SOW!D162)","v":""},{"$f":"IF(SOW!E162=\"\",\"\",SOW!E162)","v":""},"each",288,"","",null,null,null,"each",288,"",""]
[null,"Add or replace handicap signage on building and/or bollard (To be applied per DG Criteria Set and all applicable codes.)",{"$f":"IF(SOW!D163=\"\",\"\",SOW!D163)","v":""},{"$f":"IF(SOW!E163=\"\",\"\",SOW!E163)","v":""},"each",86,"","",null,null,null,"each",86,"",""]
[null,"Restripe parking lot ($25 per space)",{"$f":"IF(SOW!D164=\"\",\"\",SOW!D164)","v":""},{"$f":"IF(SOW!E164=\"\",\"\",SOW!E164)","v":""},"each",29,"","",null,null,null,"each",29,"",""]
[null,"Paint bollard safety yellow",{"$f":"IF(SOW!D165=\"\",\"\",SOW!D165)","v":""},{"$f":"IF(SOW!E165=\"\",\"\",SOW!E165)","v":""},"each",58,"","",null,null,null,"each",58,"",""]
[null,"Fill pot holes in parking lot and drives",{"$f":"IF(SOW!D166=\"\",\"\",SOW!D166)","v":""},{"$f":"IF(SOW!E166=\"\",\"\",SOW!E166)","v":""},"estimate",0,"","",null,null,null,"estimate",0,"",""]
[null,"Repave parking lot.",{"$f":"IF(SOW!D167=\"\",\"\",SOW!D167)","v":""},{"$f":"IF(SOW!E167=\"\",\"\",SOW!E167)","v":""},"estimate",0,"","",null,null,null,"estimate",0,"",""]
[null,"Install banner bolts (4 per pack)",{"$f":"IF(SOW!D168=\"\",\"\",SOW!D168)","v":1},{"$f":"IF(SOW!E168=\"\",\"\",SOW!E168)","v":""},"per store",50,50,"",null,null,null,"per store",50,"",""]
[null,null,null,null,null,null,{"$f":"SUM(G150:G164)","v":50},{"$f":"SUM(H150:H164)","v":230},null,null,null,null,null,{"$f":"SUM(N150:N164)","v":0},{"$f":"SUM(O150:O164)","v":0}]
["Fees","Site visit for bid",null,null,"per store",575,{"$f":"IF(C166=\"\",\"\",C166*F166)","v":""},{"$f":"IF(D166=\"\",\"\",D166*F166)","v":""},null,null,null,"per store",575,{"$f":"IF(J166=\"\",\"\",J166*M166)","v":""},{"$f":"IF(K166=\"\",\"\",K166*M166)","v":""}]
[null,"City & County Permits and Licenses (enter store square footage - estimate)",null,null,"SF",0.1,{"$f":"IF(C167=\"\",\"\",C167*F167)","v":""},{"$f":"IF(D167=\"\",\"\",D167*F167)","v":""},null,null,null,"SF",0.1,"",""]
[null,"Architectural / Engineering Fees",null,null,"estimate",1.1499999999999999,"","",null,null,null,"estimate",1.1499999999999999,"",""]
[null,"Dumpster Charges ",null,null,"estimate",0,"","",null,null,null,"estimate",0,"",""]
[null,"Expediter fees ",null,null,"each",400,"","",null,null,null,"each",400,"",""]
[null,null,null,null,null,null,{"$f":"SUM(G166:G170)","v":0},{"$f":"SUM(H166:H170)","v":0},null,null,null,null,null,{"$f":"SUM(N166:N170)","v":0},{"$f":"SUM(O166:O170)","v":0}]
["Additional Items","Additional Items Description","Quantity","Quantity","Unit","Unit Price","Total Line Item","Total Line Item",null,null,null,"Unit","Unit Price","Total Line Item","Total Line Item"]
[null,null,null,null,"each",null,{"$f":"IF(C173=\"\",\"\",C173*F173)","v":""},{"$f":"IF(D173=\"\",\"\",D173*F173)","v":""},null,null,null,"each",null,{"$f":"IF(J173>0,J173*M173,\" \")","v":" "},{"$f":"IF(K173>0,K173*M173,\" \")","v":" "}]
[null,null,null,null,"each",null,{"$f":"IF(C174=\"\",\"\",C174*F174)","v":""},{"$f":"IF(D174=\"\",\"\",D174*F174)","v":""},null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,"each",null,"","",null,null,null,"each",null," "," "]
[null,null,null,null,null,null,{"$f":"SUM(G173:G189)","v":0},{"$f":"SUM(H173:H189)","v":0},null,null,null,null,null,{"$f":"SUM(N173:N189)","v":0},{"$f":"SUM(O173:O189)","v":0}]
["Tax",null,"Cap Total","Exp Total","x","Tax Rate",null,"Total Line Item",null,"Bid Total","Bid Total","x","Tax Rate",null,"Total Line Item"]
[null,"Remodel Sales Tax if Required",{"$f":"SUM(G30,G75,G87,G109,G134,G140,G147,G149,G165,G171,G190)","v":3075},{"$f":"SUM(H30,H75,H87,H109,H134,H140,H147,H149,H165,H171,H190)","v":230},null,null,{"$f":"ROUND(SUM(C192+G208)*F192,1)","v":0},{"$f":"ROUND(SUM(D192+H208)*F192,1)","v":0},null,{"$f":"SUM(N30,N75,N87,N109,N134,N140,N147,N149,N165,N171,N190,N204)","v":0},{"$f":"SUM(O30,O75,O87,O109,O134,O140,O147,O149,O165,O171,O190,O204)","v":0},null,null,{"$f":"ROUND(SUM(J192+N208)*M192,1)","v":0},{"$f":"ROUND(SUM(K192+O208)*M192,1)","v":0}]
[null,null,"Capital","Expense",null,null,"Capital","Expense",null,"Capital","Expense",null,null,"Capital","Expense"]
["Change Orders","Change Orders  ","Quantity","Quantity","Unit","Unit Price","Total Line Item","Total Line Item",null,"Quantity","Quantity","Unit","Unit Price","Total Line Item","Total Line Item"]
[null,"Change Order # 1",null,null,"each",null,{"$f":"C195*F195","v":0},{"$f":"D195*F195","v":0},null,null,null,"Ea.",null,{"$f":"J195*M195","v":0},{"$f":"K195*M195","v":0}]
[null,"Change Order # 2",null,null,"each",null,0,0,null,null,null,"Ea.",null,{"$f":"J196*M196","v":0},{"$f":"K196*M196","v":0}]
[null,"Change Order # 3",null,null,"each",null,0,0,null,null,null,"Ea.",null,{"$f":"J197*M197","v":0},0]
[null,"Change Order # 4",null,null,"each",null,0,0,null,null,null,"Ea.",null,0,0]
[null,"Change Order # 5",null,null,"each",null,0,0,null,null,null,"Ea.",null,0,0]
[null,"Change Order # 6",null,null,"each",null,0,0,null,null,null,"Ea.",null,0,0]
[null,"Change Order # 7",null,null,"each",null,0,0,null,null,null,"Ea.",null,0,0]
[null,"Change Order # 8",null,null,"each",null,0,0,null,null,null,"Ea.",null,0,0]
[null,"Change Order # 9",null,null,"each",null,0,0,null,null,null,"Ea.",null,0,0]
[null,null,"Total Change Orders",null,null,null,{"$f":"SUM(G195:G203)","v":0},{"$f":"SUM(H195:H203)","v":0},null,"Total Change Orders",null,null,null,{"$f":"SUM(N195:N203)","v":0},{"$f":"SUM(O195:O203)","v":0}]
[null,null,null,null,null,null,"Proposal Totals",null,null,null,null,null,null,"Invoice Totals"]
["Totals","Subtotal less Sales Tax:",null,null,null,null,{"$f":"ROUND(SUM(G30,G75,G87,G109,G134,G140,G147,G149,G165,G171,G190),2)","v":3075},{"$f":"ROUND(SUM(H30,H75,H87,H109,H134,H140,H147,H149,H165,H171,H190),2)","v":230},null,"Subtotal less Sales Tax:",null,null,null,{"$f":"ROUND(SUM(N30,N75,N87,N109,N134,N140,N147,N149,N165,N171,N190),2)","v":0},{"$f":"ROUND(SUM(O30,O75,O87,O109,O134,O140,O147,O149,O165,O171,O190),2)","v":0}]
[]
[null,"15% Profit & Overhead On Project Cost:",null,null,null,null,{"$f":"IF((G206)>0,ROUND(SUM((G206)*15%),1),0)","v":461.3},{"$f":"IF((H206)>0,ROUND(SUM((H206)*15%),1),0)","v":34.5},null,"15% Profit & Overhead On Project Cost:",null,null,null,{"$f":"IF((N206)>0,ROUND(SUM((N206)*15%),1),0)","v":0},{"$f":"IF((O206)>0,ROUND(SUM((O206)*15%),1),0)","v":0}]
[null,"CAP/EXP Totals",null,null,null,null,{"$f":"ROUND(SUM(G192,G206,G208),2)","v":3536.3},{"$f":"ROUND(SUM(H192,H206,H208),2)","v":264.5},null,"CAP/EXP Inv Totals",null,null,null,{"$f":"ROUND(SUM(N192,N204,N206,N208),2)","v":0},{"$f":"ROUND(SUM(O192,O204,O206,O208),2)","v":0}]
[null,"Total Cost Estimate",null,null,null,null,{"$f":"G209+H209","v":3800.8},null,null,"Total Invoice Amount",null,null,null,{"$f":"SUM(N209,O209)","v":0}]
["Purple shade areas must have back-up documentation included with the invoice in order for payment to be made."]
[]
["All material purchases to include sales tax and to be paid at the time of purchase"]

{"sheet":"Additional Billing","index":5,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[28,0,28,6],[29,0,29,6],[22,0,22,6],[23,0,23,6],[24,0,24,6],[25,0,25,6],[26,0,26,6],[27,0,27,6],[21,0,21,6],[0,0,0,7],[1,0,1,7],[2,0,2,7],[4,3,4,4],[6,0,6,1],[6,3,6,5],[6,6,6,7],[8,2,8,3],[8,5,8,7],[18,0,18,6],[19,0,19,6],[20,0,20,6]]}
["Dollar General Contractor Invoice "]
[]
["Additional Billing"]
[]
["Contractor Project No.:"]
[]
["Invoice No.:",null,null,"Dollar General Store No.:"]
[]
[null,"Invoice Date:",null,null,"City/State:"]
[]
["Invoice Description:  Additional billing* for store."]
["*Please be sure to attach any required back-up information."]
[]
[]
[null,null,null,"Original Proposal:",{"$f":"'GC Bid'!C9","v":3800.8}]
[null,null,null,"Original Invoice:",{"$f":"'GC Bid'!L9","v":0}]
[]
["Description of Additions:",null,null,null,null,null,null,"Cap Amount","Exp Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(H19:H30)","v":0},{"$f":"SUM(I19:I30)","v":0}]
[null,null,null,null,null,"Sales Tax",null,{"$f":"H32*G33","v":0},{"$f":"I32*G33","v":0}]
[]
[null,null,null,null,null,"Profit & Overhead paid on Original Invoice:"]
[]
[]
[null,null,null,null,null,null,"15% Profit & Overhead (not incl. BOS):"]
[]
[null,null,null,null,null,null,"Additional Amount Due:",{"$f":"H32+H38+I32+I38","v":0}]
[]
[]
[]
[null,null,"Vendor No.:",null,null," "]
[null,null,"Invoice Date:",null,null,{"$f":"C9","v":"00:00:00"}]
[null,null,"Due Date:",null,null,{"$f":"F45+30","v":"1900-01-30"}]
[null,null,"Account No.:",null,null,"Leasehold Improvements - 171495","Project Code"]
[null,null,"Cost Center/Store No.:",null,null,{"$f":"+G7","v":0}]
[null,null,"Amount:",null,null,{"$f":"H40","v":0}]
[]
[null,null,"DG Approval:"]

{"sheet":"Contract Costs","index":6,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Process Date","Category","Description","Sign Type","Expense Fee","Capital Fee"]
[{"$f":"IF(C2=\"\", \"\",TODAY())","v":""},{"$f":"IF(C2=\"\",\"\",\"Initial\")","v":""},{"$f":"IF(OR('GC Bid'!H30>0, 'GC Bid'!G30>0), \"Restrooms and Plumbing\",\"\")","v":""},null,{"$f":"'GC Bid'!H30","v":0},{"$f":"'GC Bid'!G30","v":0}]
[{"$f":"IF(C3=\"\", \"\",TODAY())","v":"2023-08-15"},{"$f":"IF(C3=\"\",\"\",\"Initial\")","v":"Initial"},{"$f":"IF(OR('GC Bid'!H75>0, 'GC Bid'!G75>0), \"Electrical\",\"\")","v":"Electrical"},null,{"$f":"'GC Bid'!H75","v":0},{"$f":"'GC Bid'!G75","v":3025}]
["","",{"$f":"IF(OR('GC Bid'!H87>0, 'GC Bid'!G87>0), \"Lights and Lighting Items\",\"\")","v":""},null,{"$f":"'GC Bid'!H87","v":0},{"$f":"'GC Bid'!G87","v":0}]
["","",{"$f":"IF(OR('GC Bid'!H109>0, 'GC Bid'!G109>0), \"Walls and Painting\",\"\")","v":""},null,{"$f":"'GC Bid'!H109","v":0},{"$f":"'GC Bid'!G109","v":0}]
["","",{"$f":"IF(OR('GC Bid'!H134>0, 'GC Bid'!G134>0), \"Doors and Door Items\",\"\")","v":""},null,{"$f":"'GC Bid'!H134","v":0},{"$f":"'GC Bid'!G134","v":0}]
["","",{"$f":"IF(OR('GC Bid'!H140>0, 'GC Bid'!G140>0), \"Ceilings\",\"\")","v":""},null,{"$f":"'GC Bid'!H140","v":0},{"$f":"'GC Bid'!G140","v":0}]
["","",{"$f":"IF(OR('GC Bid'!H147>0,'GC Bid'!G147>0), \"Floors\",\"\")","v":""},null,{"$f":"'GC Bid'!H147","v":0},{"$f":"'GC Bid'!G147","v":0}]
["","",{"$f":"IF(OR('GC Bid'!H149>0, 'GC Bid'!G149>0), \"HVAC\",\"\")","v":""},null,{"$f":"'GC Bid'!H149","v":0},{"$f":"'GC Bid'!G149","v":0}]
["2023-08-15","Initial",{"$f":"IF(OR('GC Bid'!H165>0, 'GC Bid'!G165>0), \"Exterior\",\"\")","v":"Exterior"},null,{"$f":"'GC Bid'!H165","v":230},{"$f":"'GC Bid'!G165","v":50}]
["","",{"$f":"IF(OR('GC Bid'!H171>0, 'GC Bid'!G171>0), \"Fees\",\"\")","v":""},null,{"$f":"'GC Bid'!H171","v":0},{"$f":"'GC Bid'!G171","v":0}]
["","",{"$f":"IF(OR('GC Bid'!H190>0, 'GC Bid'!G190>0), \"Additional Items\",\"\")","v":""},null,{"$f":"'GC Bid'!H190","v":0},{"$f":"'GC Bid'!G190","v":0}]
["","",{"$f":"IF(OR('GC Bid'!H192>0, 'GC Bid'!G192>0), \"Remodel Sales Tax\",\"\")","v":""},null,{"$f":"'GC Bid'!H192","v":0},{"$f":"'GC Bid'!G192","v":0}]
["2023-08-15","Initial",{"$f":"IF(OR('GC Bid'!H208>0, 'GC Bid'!G208>0), \"OH&P\",\"\")","v":"OH&P"},null,{"$f":"'GC Bid'!H208","v":34.5},{"$f":"'GC Bid'!G208","v":461.3}]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]