{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["BID_INFO","INSTRUCTIONS","KEY","Specifications"],"not_rendered":{"images":3,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"BID_INFO","index":0,"n_rows":45,"n_cols":4,"rows_kept":45,"merged":[[32,0,34,3],[37,0,41,3],[44,0,47,3]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
["Bid Title:","Robertson County School District Milk Bid"]
["Bid Number:",1298]
["Bid Opens:","May 26, 2105 @ 10:00  AM"]
[]
["Operator:","Robertson County School Dist"]
[null,"2121 Woodland St."]
[null,"Springfield, TN 37172"]
[]
["Contact:","Patsi Gregory (Patsi.Gregory@rcstn.net)"]
[null,"Robertson County School Dist"]
[null,"800 M.S. Couts Blvd."]
[null,"Suite 1"]
[null,"Springfield, TN 37172"]
[null,"ph: (615) 384-2076"]
[]
["Bid Shipment Type:"]
["Bid Award Type:","Blanket"]
[]
["Bid Issued:","2015-05-07","Contract Starts:","7/1/2015"]
["Bid Opens:","2015-05-26","Contract Ends:","6/30/2016"]
[]
["Response Mailing Address"]
[null,"Robertson County Finance Dept"]
[null,"523 South Brown Street, Springfield, TN  37172"]
[]
["Operator Notes"]
[]
[]
[]
[]
["General Proposal Requirements:"]
["Proposals shall be submitted through the Interflex BidAdvantage system.  Bidders should complete the Specifications tab of this Excel file for those items they wish to bid on and upload the file into the Interflex BidAdvantage system.  You may also be required to send a printed copy and any other required documents to the operator - please refer to the bid documents provided by the operator to determine if a hard copy or printed copy must be returned.  Please follow all instructions provided by the operator pertaining to this bid - failure to do so may disqualify your bid.  Please use the Instructions and Key tabs included in this file to guide you in completing your quotes."]
[]
[]
[]
[]
[]
["Help:"]
["If you have a bid related question, please contact the Operator contact(s) listed above.   If you have technical or web site related questions please contact Interflex at 800-293-2909 or custserv@interflex.net."]

{"sheet":"INSTRUCTIONS","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[1,5,1,9],[2,5,2,9],[9,1,9,9],[11,1,11,9],[13,1,13,9],[15,1,15,9],[17,1,17,9],[19,1,19,9],[21,1,21,9]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":5},"VENDOR BIDDING INSTRUCTIONS"]
[{"$nulls":5},"VERSION 1.0"]
[]
[]
[]
[]
["GENERAL BIDDING INSTRUCTIONS"]
[]
["1. ","Please confirm that you have downloaded all bid documents from the opportunity that you have received.  All documents required by the operator must be returned with your completed bid response."]
[]
["2. ","Please use the \"Specifications\" tab on this excel document to enter your bids for this opportunity.  You will then upload this information into the Interflex BidAdvantage system to submit your bid response.  PLEASE NOTE:  Making modifications to the \"Specifications\" tab may cause your upload process to error - this includes adding or deleting columns, fields, modifying headers, etc.  Do NOT, under any circumstances, remove or edit the System ID in column A.  You may alter the width and height of rows to make the file easier to look at or print."]
[]
["3.","Bids are to be entered in the green tinted columns of the excel document (to the right of the specifications). "]
[]
["4.","If you would like to provide multiple bids for one specification, please copy and paste the entire row. To do this, right click on the row number so that the entire row is highlighted and choose copy.  Then highlight the next corresponding row number, right click and choose Insert Copied Cell.  You must create a new row for each bid you make on a single specification (i.e. 3 bids, 3 rows)."]
[]
["5.","Prices may be expressed to a maximum of five (5) decimal places only (e.g. $0.00000).  The system will automatically round all prices down to the nearest fifth decimal place when uploaded if you have entered more than five (5) decimal places."]
[]
["6.","The \"key\" tab will designate which fields are mandatory.  All mandatory fields should be filled out on items that are being bid. If you do not wish to bid on a line item, please leave that row completely blank.  Entering the word \"none\" or the value \"0\" will result in errors on the upload of your bids.  If any mandatory fields are left blank on the items you are quoting on, you will be required to fill that information in during the upload process.  Please note:  operators may add up to 10 custom fields to the bid and may designate which of these fields are required or not.  These custom fields will not show up on the \"key\" tab.  Please refer to the operator's bid documents and instructions for guidance."]
[]
["7.","Please read the operator's bid instructions carefully.  In addition to uploading the \"Specifications\" tab of this file into Interflex, the operator may also require you to upload any supporting bid documentation into Interflex, return a printed copy of the \"Specifications\" tab, and a printed hard copy of supporting bid documentation.  Please return all bid information as instructed by the operator."]

{"sheet":"KEY","index":2,"n_rows":64,"n_cols":11,"rows_kept":64,"merged":[[4,0,4,2],[5,1,5,2],[57,1,57,2]],"flags":["formulas_cached_only"]}
[]
[null,null,"EXCEL FIELDS KEY"]
[null,null,"Version 1.0"]
[]
["SPECIFICATION - COLUMN KEY"]
[null,"*denotes a required field"]
["Column","Title","Field Description"]
[]
["A","System ID","Unique Identifier for the specification's location in the database.  DO NOT ALTER OR REMOVE!"]
[]
["B","Interflex #","Line item number assigned to the specification by Interflex "]
[]
["C","Operator #","Line item number assigned to the specification by the Operator."]
[]
["D","Product Category","Category with which the specification has been associated."]
[]
["E","Description","Specification defined by the Operator."]
[]
["F","Pack","Type of packaging specified by the Operator (i.e. if a case is packed as 96/4 oz)."]
[]
["G","Quantity","Forecasted quantity of Bid Units (i.e. 450 Cases)."]
[]
["H","Approved Products","Manufacturer(s) or Brand(s) that have been pre-approved to meet the specification of the operator.  Approved vendors' product code(s) will be listed in parentheses if provided by the Operator."]
[]
["I","Alternate Type","Indicator of the Operator's preferences regarding the Approved Products."]
[]
["Column","Title","Field Description"]
[]
["J","Product Manufacturer","Product Manufacturer or Brand that will be supplied by the bidding vendor."]
[]
["K","Manufacturer Code","SKU/code of item in Column J."]
[]
["L","Distributor Code","Distributors code of item in Column J."]
[]
["M","*Pack Number","Number of individual units in a case.  If a case is packed as 96/2 oz., indicate 96 here.  Either the pack number or pack size is required."]
[]
["N","*Pack Size","Size of each individual unit in a case (i.e. if case pack is 96/2 oz, indicate 2 here) Either the pack number or pack size is required."]
[]
["O","*Pack Unit","Unit of measure of each individual unit in a case.  Use the drop down menu to select your pack size unit (i.e. if packaging is 6/5lb per case, indicate pounds here). "]
[]
["P","Quantity","Total Quantity of bid units needed to equal operator forecasted quantity."]
[]
["Q","*Bid Unit","Unit of Measure on which the bid price is based. (i.e Cases, pounds, servings, etc.)"]
[]
["R","*Unit Price","Price per Bid Unit (i.e. case price)."]
[]
["S","Extended Price","Total forecasted price: this column will automatically calculate based on Column R (Quantity) and Column T (Unit Price)."]
[]
["T","Notes","Use for additional notes or comments regarding the bid."]
[]
["Column","Title","Field Description"]
[]
["U","Price Per Serving"]
[]
["V","Servings Per Case"]
[]
[]
[null,"*denotes a required field"]
[]
["EXAMPLE:"]
["Product Manufacturer","Manufacturer Code","Distributor Code","Pack Number ","Pack Size ","Pack Unit","Quantity","Bid Unit","Unit Price","Extended Price","Notes"]
["Manufacturer A","12345-0761",null,200,null,"Count",500,"Cases",20,10000]
["Manufacturer B","2564-032",12345,6,10,"Cans",250,"Cases",13.2,3300,"Special Order only"]
["Brand 1",45899,null,2,5,"Pounds",1000,"Pounds",3.25,3250]

{"sheet":"Specifications","index":3,"n_rows":6,"n_cols":22,"rows_kept":6,"flags":["formulas_cached_only"]}
["System ID","Interflex #","Operator #","Product Category","Description","Pack","Quantity","Approved Products","Alternate Type","Product Manufacturer","Manufacturer Code","Distributor Code","Pack Number","Pack Size","Pack Unit","Quantity","Bid Unit","Unit Price","Extended Price","Notes","Price Per Serving","Servings Per Case"]
["96709E238981B17DC6E07738E91AE531",1,"Milk","Dairy & Non-Dairy / Milk","Milk. 1/2 gal. Fat Free Milk Grade A. No Artificial Growth Hormones.","1.0 - 64.0 Ounces","150 Each",{"$nulls":11},0]
["7532235AD158284E36B94662F6BAE03F",2,"Milk","Dairy & Non-Dairy / Milk","Milk: fluid, 0%, low fat, white, buttermilk, grade a, carton, cultured, pasteurized.","1.0 - 0.5 Gallons","300 Each",{"$nulls":11},0]
["948AF4CD5B1251E63DFF86A174D6FBAE",3,"Milk","Dairy & Non-Dairy / Milk","Milk: fluid, 1%, white, grade a, carton. No Artificial Growth Hormones.","1.0 - 8.0 Ounces","467,000 Each",{"$nulls":11},0]
["B78FBAFA30A6FCD3CBBD5F69AA17A9E4",4,"Milk","Dairy & Non-Dairy / Milk","Milk: fluid, non fat, strawberry, grade a, carton. No Trans Fat, No High Fructose Corn Syrup, No Artificial Growth Hormones.","1.0 - 8.0 Ounces","251,000 Each",{"$nulls":11},0]
["9629A11976CD46FDE56767EC91D1F765",5,"Milk","Dairy & Non-Dairy / Milk","Milk: fluid, skim, chocolate, grade a, carton. 1/2 pint chocolate, fat-free milk. No Trans Fat, No High Fructose Corn Syrup, No Artificial Growth Hormones.","1.0 - 8.0 Ounces","1,309,400 Each",{"$nulls":11},0]