{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Abstract of Bids"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":"Abstract of Bids","index":0,"n_rows":37,"n_cols":22,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,21],[8,3,8,4],[12,14,13,14],[14,14,15,14],[14,20,15,20],[14,11,15,11],[14,12,15,12],[12,5,13,5],[12,9,13,9],[12,13,13,13],[14,9,15,9],[12,10,13,10],[14,10,15,10],[14,6,15,6],[12,3,13,3],[34,0,34,21],[35,0,35,21],[33,0,33,21],[3,0,3,21],[31,0,31,21],[32,0,32,21],[1,0,1,21],[2,0,2,21],[14,2,15,2],[14,3,15,3],[14,17,15,17],[14,8,15,8],[14,7,15,7],[12,6,13,8],[12,2,13,2],[14,4,15,4],[12,16,12,21],[13,16,13,21],[12,11,13,12],[0,0,0,21],[6,3,6,4],[7,3,7,4],[12,15,15,15],[5,3,5,4],[12,0,13,0],[12,1,13,1],[14,0,15,0],[14,1,15,1],[14,16,15,16],[14,21,15,21],[14,19,15,19],[12,4,13,4],[14,18,15,18],[14,13,15,13],[14,5,15,5]]}
["Campus"]
["Address"]
["Phone:    ; Fax:    ; E-Mail:"]
["JOB ORDER CONTRACT\nABSTRACT OF BID PROPOSALS"]
[]
[null,null,"Bid Solicitation Number:","JOC-17.02",null,null,null,null,null,null,"INSTRUCTIONS FOR COMPLETING THIS FORM:"]
[null,null,"Bid Date:","2013-11-16",null,null,null,null,null,null,"Read the Notes below carefully, as they contain important information and instructions."]
[null,null,"Maximum Contract Amount:",3000000,null,null,null,null,null,null,"Blue cells are calculated fields; DO NOT input data into blue cells."]
[null,null,"Lowest Composite Score in $:",{"$f":"MIN(F17:F24)","v":2461740},null,null,null,null,null,null,"Yellow cells reflect the results and are calculated fields. DO NOT input data into yellow cells."]
[null,null,null,null,null,null,null,null,null,null,"Col. E formulas must be adjusted to reflect the Adjustment Factors in Campus bid documents."]
[null,null,null,null,null,null,null,null,null,null,"ENTER DATA into orange cells. Delete sample data shown below."]
["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V"]
["Bidder","Normal Working Hours","Other Than Normal Working Hours","Premium Working Hours","Composite Score 1","Composite Score in $ \n(Contract Award)","Small Business Preference",null,null,"SBE Adjusted Composite Score in $","Ranking (After Application of SBE Pref.)","DVBE \nIncentive",null,"Total $ SBE/DVBE Adjustments","Final Adjusted Composite Score in $","Final Ranking","Required Inclusions\n in Bids"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(if form submitted with bid, \nenter mark below)"]
["(enter bidding \nfirm name)","(enter factor for Normal Working Hours)","(enter factor for Other Than Normal Working Hours)","(enter factor for Premium Working Hours)","=(B * 0.8) +\n (C * 0.15) + \n(D * 0.05)","=(E * Maximum Contract Amount)","SBE \nType \n(enter SBE Type \"Small\" or \n\"Non-Small\", or leave blank if neither)","SBE \n% Amt.\n(enter 5%  for \"Small\" or \"Non-small\" only, and 0% for all others)","SBE \n$ Amt. \n(= N * Lowest Composite Score in $, NTE $50,000)","=(F - I)","(If an SBE is ranked low bidder below, follow instructions in \nNote 1-b)","Inc. % Amt Bid\n\n(see \nNote 2)\n","Inc. $\nAmt  Bid\n=(L * Lowest Composite Score in $)","=(I + M),  \nNTE $100,000\n(see Notes 1-a and 1-c below)","=( F - N)",null,"Bid Proposal","Bid Prop. Sign. Page","Certification","Bidder's Bond ","Noncollusion Declaration","Cert. of Approp. License, DIR PW Reg., & CA Co."]
[]
["Company 1",0.85699999999999998,0.86,0.87,{"$f":"($B$17*0.8)+($C$17*0.15)+($D$17*0.05)","v":0.85809999999999997},{"$f":"$E$17*$D$8","v":2574300},"Small",0.05,{"$f":"IF((D9*H17)>50000,50000,(SMALL($F$17:$F$24,COUNTIF($F$17:$F$24,0)+1)*H17))","v":50000},{"$f":"F17-I17","v":2524300},{"$f":"_xlfn.RANK.EQ(J17,$J$17:$J$24,1)","v":4},0.02,{"$f":"D9*L17","v":49234.8},{"$f":"MIN(I17+M17,100000)","v":99234.8},{"$f":"F17-N17","v":2475065.2000000002},{"$f":"_xlfn.RANK.EQ(O17,$O$17:$O$24,1)","v":4},"\u0097","\u0097","\u0097","\u0097","\u0097","\u0097"]
["Company 2",0.86,0.86499999999999999,0.87749999999999995,{"$f":"($B$18*0.8)+($C$18*0.15)+($D$18*0.05)","v":0.86162500000000009},{"$f":"$E$18*$D$8","v":2584875.0000000005},null,0,{"$f":"IF((D9*H18)>50000,50000,(SMALL($F$17:$F$24,COUNTIF($F$17:$F$24,0)+1)*H18))","v":0},2584875.0000000005,6,0,{"$f":"D9*L18","v":0},0,2584875.0000000005,{"$f":"_xlfn.RANK.EQ(O18,$O$17:$O$24,1)","v":7}]
["Company 3",0.85750000000000004,0.86099999999999999,0.86499999999999999,{"$f":"($B$19*0.8)+($C$19*0.15)+($D$19*0.05)","v":0.85840000000000005},{"$f":"$E$19*$D$8","v":2575200},"Non-Small",0.05,{"$f":"IF((D9*H19)>50000,50000,(SMALL($F$17:$F$24,COUNTIF($F$17:$F$24,0)+1)*H19))","v":50000},2525200,5,0.03,{"$f":"D9*L19","v":73852.2},100000,2475200,5]
["Company 4",0.82099999999999995,0.82499999999999996,0.80059999999999998,{"$f":"($B$20*0.8)+($C$20*0.15)+($D$20*0.05)","v":0.82058000000000009},2461740,null,0,{"$f":"IF((D9*H20)>50000,50000,(SMALL($F$17:$F$24,COUNTIF($F$17:$F$24,0)+1)*H20))","v":0},2461740,2,0.02,{"$f":"D9*L20","v":49234.8},49234.8,2412505.2000000002,1]
["Company 5",0.82750000000000001,0.82799999999999996,0.82850000000000001,{"$f":"($B$21*0.8)+($C$21*0.15)+($D$21*0.05)","v":0.82762500000000006},{"$f":"$E$21*$D$8","v":2482875},null,0,{"$f":"IF((D9*H21)>50000,50000,(SMALL($F$17:$F$24,COUNTIF($F$17:$F$24,0)+1)*H21))","v":0},2482875,3,0.01,{"$f":"D9*L21","v":24617.4},24617.4,2458257.6,3]
["Company 6",0.86499999999999999,0.86599999999999999,0.86699999999999999,{"$f":"($B$22*0.8)+($C$22*0.15)+($D$22*0.05)","v":0.86525000000000007},{"$f":"$E$22*$D$8","v":2595750},null,0,{"$f":"IF((D9*H22)>50000,50000,(SMALL($F$17:$F$24,COUNTIF($F$17:$F$24,0)+1)*H22))","v":0},2595750,7,0,{"$f":"D9*L22","v":0},0,2595750,8]
["Company 7",0.83250000000000002,0.83499999999999996,0.85350000000000004,{"$f":"($B$23*0.8)+($C$23*0.15)+($D$23*0.05)","v":0.83392500000000003},{"$f":"$E$23*$D$8","v":2501775},"Small",0.05,{"$f":"IF((D9*H23)>50000,50000,(SMALL($F$17:$F$24,COUNTIF($F$17:$F$24,0)+1)*H23))","v":50000},2451775,1,0.01,{"$f":"D9*L23","v":24617.4},74617.399999999994,2427157.6,2]
["Company 8",0.88,0.88249999999999995,0.88500000000000001,{"$f":"($B$24*0.8)+($C$24*0.15)+($D$24*0.05)","v":0.8806250000000001},{"$f":"$E$24*$D$8","v":2641875.0000000005},null,0,{"$f":"IF((D9*H24)>50000,50000,(SMALL($F$17:$F$24,COUNTIF($F$17:$F$24,0)+1)*H24))","v":0},2641875.0000000005,8,0.03,{"$f":"D9*L24","v":73852.2},73852.2,2568022.8000000003,6]
[]
[null,null,null,null," I certify that this is a true tabulation of bids received."]
[]
[]
[null,null,null,null,null,null,null,null,"(Print Name, Title above)",null,null,null,null,null,null,null,null,null,"(Signature)"]
[]
["Notes for Recorder/Announcer:"]
["1. Award formula for Small Business = Bidder's \"Composite Score in $\"  less 5% of \"Lowest Composite Score in $\" (NTE $50,000 on bids of $1,000,000 or more)."]
["a. The SBE preference calculation is based on the lowest bidder, unless that bidder is a CA certified SBE or a Non-Small business committing to subcontract 25% of its contract amount to small businesses."]
["b. If, after applying SBE preference (Col. K), the lowest bidder is a CA certified SBE, then: the low bidder SBE may only be displaced by another SBE; do not calculate the SBE preference for Non-Small businesses and other bidders—for them, replace the $50,000  \nb. preference with $0; the only bidders eligible for the DVBE incentive are other CA SBEs; for the other non-SBE bidders, replace incentive amount with $0.  Using this abstract for example, the figures in red above would be replaced with $0, and\nb. Company 7 would become low bidder."]
["c. The Small Business Preference combined with the DVBE Incentive may not exceed $100,000."]
["2. In its construction contracts, CSU grants a DVBE bid incentive for bid evaluation purposes only to bidders proposing to exceed the required 3% DVBE participation. The DVBE incentive is added to the required 3% participation as  \n2. follows:  1% (=total of 4.00% to 4.99% DVBE participation), 2% (=total of 5.00% to 5.99% DVBE participation) or 3% (=total of 6.00% or more DVBE participation) of the \"Lowest Composite Score in $\"."]
["3. \"Required Inclusions in Bids\" (Cols. Q-V) has been added so that the Campus Recorder/Announcer may check off these documents as the bid is opened."]