{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet1 (2)"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":115,"n_cols":15,"rows_kept":115,"merged":[[1,2,1,5],[1,12,1,15],[4,2,4,6],[5,2,5,6],[6,9,6,15],[7,9,7,15],[8,9,8,15],[9,9,9,15],[10,2,10,15],[13,0,13,15],[14,1,14,15],[25,14,25,15],[26,6,26,10],[26,14,26,15],[30,14,30,15],[32,12,32,15],[35,3,35,11],[35,14,35,15],[37,3,37,11],[38,3,38,11],[38,14,38,15],[39,2,39,5],[39,14,39,15],[40,2,40,5],[40,14,40,15],[41,2,41,5],[41,14,41,15],[44,5,44,11],[44,14,44,15],[45,2,45,3],[45,8,45,11],[45,14,45,15],[48,4,48,15],[51,0,52,15],[54,0,55,15],[58,2,58,15],[59,2,59,15],[64,3,64,15],[67,5,67,15],[70,5,70,15],[71,5,71,15],[72,5,72,15],[76,1,76,11],[76,14,76,15],[77,1,77,11],[77,14,77,15],[78,1,78,11],[78,14,78,15],[79,1,79,11],[79,14,79,15],[80,1,80,11],[80,14,80,15],[81,1,81,11],[81,14,81,15],[82,1,82,11],[82,14,82,15],[83,1,83,11],[83,14,83,15],[84,1,84,11],[84,14,84,15],[85,1,85,11],[85,14,85,15],[89,1,89,3],[89,5,98,5],[89,9,98,9],[89,13,89,14],[90,1,90,3],[90,13,90,14],[91,1,91,3],[91,13,91,14],[92,1,92,3],[92,13,92,14],[93,1,93,3],[93,13,93,14],[94,1,94,3],[94,13,94,14],[95,1,95,3],[95,13,95,14],[96,1,96,3],[96,13,96,14],[97,1,97,3],[97,13,97,14],[98,1,98,3],[98,13,98,14],[100,13,100,14],[103,1,103,3],[103,5,112,5],[103,13,103,14],[104,1,104,3],[104,13,104,14],[105,1,105,3],[105,13,105,14],[106,1,106,3],[106,13,106,14],[107,1,107,3],[107,13,107,14],[108,1,108,3],[108,13,108,14],[109,1,109,3],[109,13,109,14],[110,1,110,3],[110,13,110,14],[111,1,111,3],[111,13,111,14],[112,1,112,3],[112,13,112,14],[114,13,114,14]]}
[]
["Date of Request:",{"$nulls":10},"Name of Requestor: "]
[]
["BID REQUEST TYPE/INFO"]
["q","BPS Internal Bid?","---OR---",{"$nulls":4},"q","BPS 2015 Bond Bid?"]
["q","New bid?","---OR---",{"$nulls":4},"q","Renewal of Multiple Year Contract Bid?"]
[{"$nulls":8},"Former/In-Progress Bid #: "]
[{"$nulls":8},"Former/In-Progress Bid Title: "]
[{"$nulls":8},"Former/In-Progress Bid Completion Date: "]
[{"$nulls":8},"Renewal Start Date: "]
[null,"Bid Title: "]
[]
["SCHEDULE"]
["Based on the Board Resolution date inserted below, suggested project dates will populate below. \nAny and all dates CAN BE over-written (but formulas will disappear)."]
[null,"*PLEASE NOTE: The Purchasing Department will make every attempt to confirm the requested submitted dates, but may need to change dates/times based on room availability, etc. Purchasing will respond to each request by assigning a bid number and confirm the appropriate dates. *PLEASE REMEMBER: all dates are tentative and for planning purposes only. Some projects require significantly longer time periods in order to satisfy internal processing and vendor bidding needs."]
[]
["Tentative Time Line:"]
[null,"2018-07-01","Date of Board of Education Meeting where bid presented for ratification/resolution"]
[null,{"$f":"B18-14","v":"2018-06-17"},"Recommendations due to Board of Education for inclusion in Agenda (= the 2nd Wednesday before Board Mtg)"]
[null,{"$f":"B22-10","v":"2018-05-14"},"Date bid information due to purchasing to ensure bid advertised (= the 2nd Tuesday before Sunday of Ad)"]
[null,"2018-05-20","Notice of Advertisement for Bid in local newspaper (Always a Sunday)"]
[null,{"$f":"B23-9","v":"2018-05-24"},"Issuance of this RFB/Bid Release Date (= the Monday after the Sunday)"]
[null,{"$f":"B28-12","v":"2018-06-02"},"Pre-Bid Meeting Date",{"$nulls":10},"Pre-Bid Meeting Time: ",12.5]
[null,null,"Attendance at Pre-Bid Meeting Mandatory?",{"$nulls":6},"Yes","q","No","q"]
[null,"2018-06-11","Deadline for Questions/Requests for Clarification",{"$nulls":10},"?'s Deadline Time: ","12:00:00"]
[null,null,"Submit questions by:   ",{"$nulls":10},"Submit questions to: "]
[null,null,"q","Email Address:",{"$nulls":8},"q","Phone #: "]
[null,"2018-06-14","Bid Due Date & Opening",{"$nulls":10},"Bid Opening Time: ","12:00:00"]
[null,"Date","Post-Bid Review (range acceptable)"]
[null,{"$f":"B18","v":"2018-07-01"},"Bid Award (= Date of Board Resolution)"]
[null,"2018-08-01","Bid Project Start Date",{"$nulls":10},"Projected Project End Date: "]
[null,"Length of Contract:",null,"Year(s)","---OR---",null,"q","One-timer?"]
[null,null,"q","With","---OR---",null,"q","Without extension options of: "]
[]
["CONTACT INFORMATION"]
[null,"Name of Project Manager:",{"$nulls":11},"Phone/Email: "]
[]
[null,"Name of Consultant/Firm (if any):"]
[null,"Firm Address:",{"$nulls":11},"Firm Phone: "]
[null,"City:",{"$nulls":5},"State:",{"$nulls":5},"Zip: "]
[null,"Contact Name at Firm:",{"$nulls":11},"Contact Email: "]
[null,"Contact Work Phone:",{"$nulls":11},"Contact Cell Phone: "]
[]
["BUDGET INFORMATION"]
[null,"Budget Source (Fund): ",null,null,"Acct #: ",{"$nulls":8},"Budget Year: "]
[null,"Budget Amount:"]
[]
["SPECIFICATIONS/DESCRIPTION"]
[null,"Location(s)/Facility(ies)/School(s):"]
[null,"Prevailing Wage Requirements?",null,null,"q","Yes",null,"q","No"]
[null,"Bid/Project Description/Scope of Work:"]
[]
[]
[]
["Email, fax or mail completed form to Lauren Mbereko, Purchasing Coordinator, at (248) 203-3050 or lmbereko@birmingham.k12.mi.us. \nFeel free to contact Lauren with any questions."]
[]
["PURCHASING DEPT ONLY - Action Items"]
[]
[null,"Assigned Bid #: "]
[null,"Assigned Bid File Title: "]
[]
[null,null,"Date Legal Ad Published"]
[]
[null,null,"Date Advertised/Published to:"]
[null,null,"Other: ","insert web address"]
[]
[null,null,"BPS: ","https://bids.bpsecatalog.net/default"]
[{"$nulls":4},"BPS Class Codes: "]
[]
[null,null,"SIGMA: ","https://milogintp.michigan.gov/eai/tplogin/authenticate?URL=/uisecure/tpSelfService"]
[{"$nulls":4},"Commodity: "]
[{"$nulls":4},"Commodity Class Code(s): "]
[{"$nulls":4},"Commodity Class Item(s): "]
[]
[]
["Addendums:"]
[1,{"$nulls":12},"Date Posted:"]
[2,{"$nulls":12},"Date Posted:"]
[3,{"$nulls":12},"Date Posted:"]
[4,{"$nulls":12},"Date Posted:"]
[5,{"$nulls":12},"Date Posted:"]
[6,{"$nulls":12},"Date Posted:"]
[7,{"$nulls":12},"Date Posted:"]
[8,{"$nulls":12},"Date Posted:"]
[9,{"$nulls":12},"Date Posted:"]
[10,{"$nulls":12},"Date Posted:"]
[]
[]
["Contract(s) Awarded To (\"Vendor\") by BOE:",{"$nulls":5},"Yes","No","As Of:",null,"Yes","No","As of:",null,"Contract Amount (s): "]
[1,{"$nulls":4},"Contract on file? ",{"$nulls":3},"Performance Bond on file? ",{"$nulls":3},0]
[2,{"$nulls":12},0]
[3,{"$nulls":12},0]
[4,{"$nulls":12},0]
[5,{"$nulls":12},0]
[6,{"$nulls":12},0]
[7,{"$nulls":12},0]
[8,{"$nulls":12},0]
[9,{"$nulls":12},0]
[10,{"$nulls":12},0]
[]
["Total Award:",{"$nulls":12},{"$f":"SUM(N90:O99)","v":0}]
[]
["Change Orders:",{"$nulls":5},"Yes","No","As Of:",{"$nulls":5},"Amount of Change to Contract: "]
[1,{"$nulls":4},"CO on file? ",{"$nulls":7},0]
[2,{"$nulls":12},0]
[3,{"$nulls":12},0]
[4,{"$nulls":12},0]
[5,{"$nulls":12},0]
[6,{"$nulls":12},0]
[7,{"$nulls":12},0]
[8,{"$nulls":12},0]
[9,{"$nulls":12},0]
[10,{"$nulls":12},0]
[]
["NEW CONTRACT SUM:",{"$nulls":12},{"$f":"N101+SUM(N104:O113)","v":0}]

{"sheet":"Sheet1 (2)","index":1,"n_rows":24,"n_cols":13,"rows_kept":24}
["2017-06-06",{"$f":"A1","v":"2017-06-06"}]
[{"$f":"DATE(YEAR(A1),MONTH(A1),DAY(A1))-WEEKDAY(DATE(YEAR(A1), MONTH(A1),DAY(A1)))+1","v":"2017-06-04"},{"$f":"A2","v":"2017-06-04"}]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[]
["1 (Sunday) to 7 (Saturday)",{"$nulls":9},"DATE(YEAR(A12),MONTH(A12),DAY(A12))-WEEKDAY(DATE(YEAR(A12), MONTH(A12),DAY(A12)))-4"]
[1,2,3,4,5,6,7]
["Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"]
[]
["2017-06-06","Date of Board of Education Meeting where bid presented for ratification/resolution"]
[{"$f":"A12-7","v":"2017-05-30"},"Recommendations due to Board of Education for inclusion in Agenda (= the Wednesday before Board Meeting)",{"$nulls":9},"A12-7",{"$f":"DATE(YEAR(A12),MONTH(A12),DAY(A12))-WEEKDAY(DATE(YEAR(A12), MONTH(A12),DAY(A12)))-4","v":"2017-05-30"}]
[{"$f":"A16-10","v":"2017-04-22"},"Date bid information due to purchasing to ensure bid advertised (= the 2nd Tuesday before Sunday of Ad)",{"$nulls":9},"A16-10","DATE(YEAR(A12),MONTH(A12),DAY(A12))-WEEKDAY(DATE(YEAR(A12), MONTH(A12),DAY(A12)))-4"]
["Date","Notice of Advertisement for Bid in local newspaper (Always a Sunday)",{"$nulls":10},{"$f":" DATE(YEAR(A21),MONTH(A21),DAY(A21))-WEEKDAY(DATE(YEAR(A21), MONTH(A21)-14,DAY(A21)))-1","v":"2017-05-18"}]
[{"$f":"A20-9","v":"2017-05-02"},"Issuance of this RFB/Bid Release Date (= the Monday after the Sunday)",{"$nulls":8},{"$f":"DATE(YEAR(M20),MONTH(M20),DAY(M20)-14)-WEEKDAY(DATE(YEAR(M20), MONTH(M20),DAY(M20)))-2","v":"2017-04-20"},"A20-9",{"$f":"M15+1","v":"2017-05-19"}]
["Date","Deadline for Questions/Requests for Clarification",{"$nulls":10},"DATE(YEAR(A12),MONTH(A12),DAY(A12))-WEEKDAY(DATE(YEAR(A12), MONTH(A12),DAY(A12)))-4"]
[]
[]
[{"$f":"A21-12","v":"2017-05-11"},"Pre-Bid Meeting Date",null,"BUT MAKE IT DEFAULT TO A MON-FRI ONLY",{"$nulls":7},"A21-12",{"$f":"DATE(YEAR(A21),MONTH(A21),DAY(A21)-12)-WEEKDAY(DATE(YEAR(A21), MONTH(A21),DAY(A21)))","v":"2017-05-08"}]
[{"$f":"A12-14","v":"2017-05-23"},"Bid Due Date & Opening",{"$nulls":9},"A12-14",{"$f":"DATE(YEAR(A12),MONTH(A12),DAY(A12)-14)-WEEKDAY(DATE(YEAR(A12), MONTH(A12),DAY(A12)))+3","v":"2017-05-23"}]
[{"$f":"A21+1","v":"2017-05-24"},"Post-Bid Review (range acceptable)"]
[{"$f":"A12","v":"2017-06-06"},"Bid Award (= Date of Board Resolution)"]
["Date","Bid Project Start Date"]