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

{"sheet":"BID_INFO","index":0,"n_rows":43,"n_cols":4,"rows_kept":43,"merged":[[30,0,32,3],[35,0,39,3],[42,0,45,3]]}
[]
[]
[]
[]
[]
[]
["Bid Title:","Fluid Milk, Non-Frozen Juice and No Calorie Tea Bid 2020"]
["Bid Number:",""]
["Bid Opens:"]
[]
["Operator:","Robertson County School Dist"]
[null,"800 M.S. Couts Blvd."]
[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:","Line Item"]
[]
["Bid Issued:",null,"Contract Starts:","7/1/2020"]
["Bid Opens:",null,"Contract Ends:","6/30/2021"]
[]
["Response Mailing Address"]
[]
["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]]}
[]
[{"$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 that require a signature must be mailed back 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 higlighted 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."]
[]
["7.","Please include the following items when submitting your bid to the Operator (in addition to the upload of your quotes into the Interflex BidAdvantage system):\na.) All completed bid documents as instructed by the Operator.\nb.) A printed copy of the \"Specifications\" tab of this Excel file."]

{"sheet":"KEY","index":2,"n_rows":57,"n_cols":11,"rows_kept":57,"merged":[[4,0,4,2],[5,1,5,2],[50,1,50,2]]}
[]
[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 Indentifier 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 specifcation 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","Quantitiy","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 P (Quantity) and Column R (Unit Price)."]
[]
["T","Notes","Use for additional notes or comments regarding the bid."]
[]
[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,{"$f":"I55*G55","v":10000}]
["Manufacturer B","2564-032",12345,6,10,"Cans",250,"Cases",13.2,{"$f":"I56*G56","v":3300},"Special Order only"]
["Brand 1",45899,null,2,5,"Pounds",1000,"Pounds",3.25,3250]

{"sheet":"Specifications","index":3,"n_rows":8,"n_cols":20,"rows_kept":8}
["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"]
["68557DDB7BB3F8BBB4C0F53449B1975E",1,"","Dairy & Non-Dairy: Milk","MIlk: 1 gallon Dairy Belle 1% MIlk Grade A No Artificial Growth Hormones, Buy American Compliant","1 / 128.0 Ounces","850 Each",{"$nulls":11},{"$f":"P2 * R2","v":0}]
["30E94A47CB148B1C147B725AC9974927",2,"","Dairy & Non-Dairy: Milk","MIlk: fluid, 1%, white, Grade A, Carton  NO Artificial Growth Hormones, Buy American Compliant","1 / 8.0 Ounces","436,719 Each",{"$nulls":11},0]
["0CBB583D74FBBD800759F9B5E45A700E",3,"","Dairy & Non-Dairy: Milk","MIlk: fluid, non fat, chocolate, Grade A, Carton  NO Artificial Growth Hormones, NO High Fructose Corn Syrup, No Trans Fat,  BUy American Compliant","1 / 8.0 Ounces","1,144,330 Each",{"$nulls":11},0]
["3A750F697F6D8E6ABA2C643DFE98FDC1",4,"","Dairy & Non-Dairy: Milk","MIlk: fluid, non fat, strawberry, Grade A, Carton  NO Artificial Growth Hormones, NO High Fructose Corn Syrup, No Trans Fat,  Buy American Compliant","1 / 8.0 Ounces","239,000 Each",{"$nulls":11},0]
["84356118D830C5AF849F41E99EE2401B",5,"","Beverages & Mixes: Juices & Drinks","Juice: 100% Pure Apple Juice, From Concentrate, Pasteurized, No Added Sugars, Buy American Compliant","1 / 4.0 Ounces","130,900 Each",{"$nulls":11},0]
["798443890CFCF72C29937D435B16A5AC",6,"","Beverages & Mixes: Juices & Drinks","Juice: 100% Pure Orange Juice, From Concentrate, Pasteurized, No Added Sugars","1 / 4.0 Ounces","230,000 Each",{"$nulls":11},0]
["73A58B3E676108206FDCC53AFADA08C6",7,"","Beverages & Mixes: Tea: Ready To Drink Tea","Tea: Iced Tea, Sweet Tea, Zero Calorie, Ready Leaf","1 / 8.0 Ounces","40,000 Each",{"$nulls":11},0]