{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["MSBG Bread Zone 1","MSBG Bread Zone 2","MSBG Bread Zone 3","MSBG Bread Zone 4","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"MSBG Bread Zone 1","index":0,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1],[21,13,21,14]]}
["Enter Company name in this cell"]
["Line","Item","Description","Minimum Whole Grain Credit","Approx. Serving size","Approx. Pack Size","Base Pack Size","Projected Usage","Brand","Distributor Code","Pack Size Description","Actual Pack Size","Domestic Product","Price per Pack","Adjusted Projection","Extension","Vendor Comment"]
[1,"Bagel, approx. 3 oz.","Sliced ",2,"3.0 oz..","6 3-3.5 oz.",6,610,{"$nulls":6},{"$f":"IF(ISBLANK(L3),H3, (H3*G3)/L3)","v":610},{"$f":"O3*N3","v":0}]
[2,"Bread, 100% WW, sliced, approx. 4x4, untopped","Approx. 17 oz. and 16 slices",1,"1.0 oz","17 oz. loaf",null,1745,{"$nulls":6},{"$f":"IF(ISBLANK(L4),H4, (H4*G4)/L4)","v":1745},{"$f":"O4*N4","v":0}]
[3,"Bread, 100% WW, sliced, approx. 4x5, grain topped","Approx. 20 oz. and 15 slices",1,"1.33 oz.","20 oz. loaf",null,1425,{"$nulls":6},{"$f":"IF(ISBLANK(L5),H5, (H5*G5)/L5)","v":1425},{"$f":"O5*N5","v":0}]
[4,"Bread, club,wheat, sliced, approx. 4x4","Approx. 28 oz. and 26 slices",1,"1.0 oz.","28 oz. loaf",null,4740,{"$nulls":6},{"$f":"IF(ISBLANK(L6),H6, (H6*G6)/L6)","v":4740},{"$f":"O6*N6","v":0}]
[5,"Bread, french, wheat, unsliced","Approx.14 oz. and 22 inches","N/A","N/A","14 oz. loaf",null,1393,{"$nulls":6},{"$f":"IF(ISBLANK(L7),H7, (H7*G7)/L7)","v":1393},{"$f":"O7*N7","v":0}]
[6,"Bread, multigrain, or 5 grain, sliced","Approx. 20 oz. and 15 slices",1,"1.33 oz.","20 oz. loaf",null,1110,{"$nulls":6},{"$f":"IF(ISBLANK(L8),H8, (H8*G8)/L8)","v":1110},{"$f":"O8*N8","v":0}]
[7,"Bread, pita, approx. 7\", wheat or white wheat","Approx. 3.0 oz.",2,"3.0 oz.","4 3.0 oz.",4,540,{"$nulls":6},{"$f":"IF(ISBLANK(L9),H9, (H9*G9)/L9)","v":540},{"$f":"O9*N9","v":0}]
[8,"English muffins, wheat or white wheat","Approx. 2.0 oz. and 3.5 inch, sliced",2,"2.0 oz","12 2.0 oz.",12,943,{"$nulls":6},{"$f":"IF(ISBLANK(L10),H10, (H10*G10)/L10)","v":943},{"$f":"O10*N10","v":0}]
[9,"Panini, wheat, sliced. oat topped","Approx. 38 oz. and 20 slices",1,"2.0 oz.","38 oz. loaf",null,560,{"$nulls":6},{"$f":"IF(ISBLANK(L11),H11, (H11*G11)/L11)","v":560},{"$f":"O11*N11","v":0}]
[10,"Roll, bulkie, seedless, wheat or white wheat","Approx. 2.5 oz. and 4\", sliced",2,"2.5 oz.","12 2.50 oz.",6,4272,{"$nulls":6},{"$f":"IF(ISBLANK(L12),H12, (H12*G12)/L12)","v":4272},{"$f":"O12*N12","v":0}]
[11,"Roll, dinner, wheat or white wheat","1 oz, each, soft inside texture, pull-apart cluster ",1,"1.0 oz.","30 1.0 oz.",30,3358,{"$nulls":6},{"$f":"IF(ISBLANK(L13),H13, (H13*G13)/L13)","v":3358},{"$f":"O13*N13","v":0}]
[12,"Roll, dinner, honey wheat","1 oz., individuals","1,00","1.0 oz.","12 1.oz.",12,254,{"$nulls":6},{"$f":"IF(ISBLANK(L14),H14, (H14*G14)/L14)","v":254},{"$f":"O14*N14","v":0}]
[13,"Roll, French, 4\", wheat or white wheat","Sliced, but attached at one side",1,"1.5 oz.","12 1.5 oz.",12,314,{"$nulls":6},{"$f":"IF(ISBLANK(L15),H15, (H15*G15)/L15)","v":314},{"$f":"O15*N15","v":0}]
[14,"Roll, hamburger, wheat or white wheat","3.5 inch, 2 oz, sliced  ",2,"2.0 oz.","12 2.0 oz.",12,37666,{"$nulls":6},{"$f":"IF(ISBLANK(L16),H16, (H16*G16)/L16)","v":37666},{"$f":"O16*N16","v":0}]
[15,"Roll, hot dog, wheat or white wheat","New England Style, top sliced",2,"2.0 oz.","12 2.0 oz.",16,6075,{"$nulls":6},{"$f":"IF(ISBLANK(L17),H17, (H17*G17)/L17)","v":6075},{"$f":"O17*N17","v":0}]
[16,"Roll, sub 6\", wheat or white wheat","Sliced, but attached at one side",2,"2.0 oz.","12 2.0 oz.",6,16117,{"$nulls":6},{"$f":"IF(ISBLANK(L18),H18, (H18*G18)/L18)","v":16117},{"$f":"O18*N18","v":0}]
[17,"Roll, sub, 8\", wheat or white wheat","Sliced, but attached at one side",2,"3.0 oz.","6 3.0 oz.",6,1318,{"$nulls":6},{"$f":"IF(ISBLANK(L19),H19, (H19*G19)/L19)","v":1318},{"$f":"O19*N19","v":0}]
[18,"Wrap, 10\"  diameter, wheat","Round",2,"3.0 oz.","12 3.0 oz.",12,1068,{"$nulls":6},{"$f":"IF(ISBLANK(L20),H20, (H20*G20)/L20)","v":1068},{"$f":"O20*N20","v":0}]
[19,"Wrap, 8\" diameter, wheat","Round",2,"2.0 oz.","10 2.0 oz.",10,1104,{"$nulls":6},{"$f":"IF(ISBLANK(L21),H21, (H21*G21)/L21)","v":1104},{"$f":"O21*N21","v":0}]
[{"$nulls":13},"Grand Total:  ",null,{"$f":"SUM(P3:P21)","v":0}]

{"sheet":"MSBG Bread Zone 2","index":1,"n_rows":22,"n_cols":23,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1],[21,13,21,14]]}
["Fantini Bakery"]
["Line","Item","Description","Minimum Whole Grain Credit","Approx. Serving size","Approx. Pack Size","Base Pack Size","Projected Usage","Brand","Distributor Code","Pack Size Description","Actual Pack Size","Domestic Product","Price per Pack","Adjusted Projection","Extension","Vendor Comment",null,"17-18 price","17-18 Reference line","17-18 Brand","17-18 Reference item","17-18 Reference brand"]
[1,"Bagel, approx. 3 oz.","Sliced ",2,"3.0 oz.","6 3-3.5 oz.",6,1755,"Bagel Boy",2198," ",6,"X",1.89,{"$f":"IF(ISBLANK(L3),H3, (H3*G3)/L3)","v":1755},{"$f":"O3*N3","v":3316.95},null,null,1.72,20,"Duva 6043","3 oz. Whole Grain Bagel","Zeppy's"]
[2,"Bread, 100% WW, sliced, approx. 4x4, untopped","Approx. 17 oz. and 16 slices",1,"1.0 oz","17 oz. loaf",null,13458,"Fantini",144,null,null,"X",1.65,{"$f":"IF(ISBLANK(L4),H4, (H4*G4)/L4)","v":13458},{"$f":"O4*N4","v":22205.7},null,null,1.55,1,"Duva 144","100% Whole Wheat Bread, Sliced Loaf, Homestyle","Fantini"]
[3,"Bread, 100% WW, sliced, approx. 4x5, grain topped","Approx. 20 oz. and 15 slices",1,"1.33 oz.","20 oz. loaf",null,24,"Fantini",143,null,null,"X",1.79,{"$f":"IF(ISBLANK(L5),H5, (H5*G5)/L5)","v":24},{"$f":"O5*N5","v":42.96},null,null,1.55,2,"Duva 143","100% Whole Wheat sliced bread, large Teacher","Fantini As You Like it."]
[4,"Bread, club,wheat, sliced, approx. 4x4","Approx. 28 oz. and 26 slices",1,"1.0 oz.","28 oz. loaf",null,16552,"Gold Medal",133,null,null,"x",2.25,{"$f":"IF(ISBLANK(L6),H6, (H6*G6)/L6)","v":16552},{"$f":"O6*N6","v":37242},null,null,1.75,3,"Duva 7202","Whole Wheat Club, Sliced Loaf","Gold Medal"]
[5,"Bread, french, wheat, unsliced","Approx.14 oz. and 22 inches","N/A","N/A","14 oz. loaf",null,1286,"Fantini",31,null,null,"X",1.9,{"$f":"IF(ISBLANK(L7),H7, (H7*G7)/L7)","v":1286},{"$f":"O7*N7","v":2443.4},null,null,1.58,4,"Duva 31","French Bread, Unsliced, Multigrain","Fantini"]
[6,"Bread, multigrain, or 5 grain, sliced","Approx. 20 oz. and 15 slices",1,"1.33 oz.","20 oz. loaf",null,1100,"Fantini",142,null,null,"X",1.95,{"$f":"IF(ISBLANK(L8),H8, (H8*G8)/L8)","v":1100},{"$f":"O8*N8","v":2145},null,null,1.85,5,"Duva 142","Multi Grain Bread Sliced Loaf","Fantini As You Like it."]
[7,"Bread, pita, approx. 7\", wheat or white wheat","Approx. 3.0 oz.",2,"3.0 oz.","4 3.0 oz.",4,9449,"Josephs",213,null,4,"X",1.15,{"$f":"IF(ISBLANK(L9),H9, (H9*G9)/L9)","v":9449},{"$f":"O9*N9","v":10866.35},null,null,2.15,15,"Duva 6012","Syrian/Pita Bread, 7\" Whole Wheat","Joseph's"]
[8,"English muffins, wheat or white wheat","Approx. 2.0 oz. and 3.5 inch, sliced",2,"2.0 oz","12 2.0 oz.",12,4745,"Gold Medal",116,null,6,"X",1.62,{"$f":"IF(ISBLANK(L10),H10, (H10*G10)/L10)","v":9490},{"$f":"O10*N10","v":15373.8},null,null,1.83,18,"Duva 3104","English Muffin, Whole Wheat","Homestead"]
[9,"Panini, wheat, sliced. oat topped","Approx. 38 oz. and 20 slices",1,"2.0 oz.","38 oz. loaf",null,5475,"Fantini",1096,null,null,"X",3.75,{"$f":"IF(ISBLANK(L11),H11, (H11*G11)/L11)","v":5475},{"$f":"O11*N11","v":20531.25},null,null,1.52,19,"Duva 1096","Panini, Multigrain sliced","Fantini"]
[10,"Roll, bulkie, seedless, wheat or white wheat","Approx. 2.5 oz. and 4\", sliced",2,"2.5 oz.","12 2.50 oz.",6,5825,"Fantini",157,null,6,"X",1.42,{"$f":"IF(ISBLANK(L12),H12, (H12*G12)/L12)","v":5825},{"$f":"O12*N12","v":8271.5},null,null,1.6,8,"Duva 157","Bulkie Rolls, Whole Wheat, No seeds","Fantini"]
[11,"Roll, dinner, wheat or white wheat","1 oz, each, soft inside texture, pull-apart cluster ",1,"1.0 oz.","30 1.0 oz.",30,8550,"Fantini",168,null,30,"X",3.3,{"$f":"IF(ISBLANK(L13),H13, (H13*G13)/L13)","v":8550},{"$f":"O13*N13","v":28215},null,null,2.5,12,"Duva 168","Dinner Rolls, White Whole Wheat","Fantini"]
[12,"Roll, dinner, honey wheat","1 oz., individuals","1,00","1.0 oz.","12 1.oz.",12,7096,"Fantini",167,null,12,"X",1.9,{"$f":"IF(ISBLANK(L14),H14, (H14*G14)/L14)","v":7096},{"$f":"O14*N14","v":13482.4},null,null,null,13,"Duva 167","Dinner Rolls, Honey Whole Wheat","Fantini"]
[13,"Roll, French, 4\", wheat or white wheat","Sliced, but attached at one side",1,"1.5 oz.","12 1.5 oz.",12,3124,"Fantini",4867,null,12,"X",3.36,{"$f":"IF(ISBLANK(L15),H15, (H15*G15)/L15)","v":3124},{"$f":"O15*N15","v":10496.64},null,null,0.95,9,"Duva 4867","4\" French Rolls, Whole Wheat","Fantini"]
[14,"Roll, hamburger, wheat or white wheat","3.5 inch, 2 oz, sliced  ",2,"2.0 oz.","12 2.0 oz.",12,65906,"Fantini",155,null,12,"X",1.74,{"$f":"IF(ISBLANK(L16),H16, (H16*G16)/L16)","v":65906},{"$f":"O16*N16","v":114676.44},null,null,1.5,6,"Duva 155","Hamburg Rolls, Whole Wheat","Fantini"]
[15,"Roll, hot dog, wheat or white wheat","New England Style, top sliced",2,"2.0 oz.","12 2.0 oz.",16,11937,"Gold Medal",215,null,12,"X",2.45,{"$f":"IF(ISBLANK(L17),H17, (H17*G17)/L17)","v":15916},{"$f":"O17*N17","v":38994.2},null,null,1.85,7,"Duva 3016","Hot Dog Rolls, Whole Wheat","Gold Medal"]
[16,"Roll, sub 6\", wheat or white wheat","Sliced, but attached at one side",2,"2.0 oz.","12 2.0 oz.",6,34266,"Fantini",1061,null,6,"X",1.42,{"$f":"IF(ISBLANK(L18),H18, (H18*G18)/L18)","v":34266},{"$f":"O18*N18","v":48657.72},null,null,1.65,10,"Duva 1061","6\" Sub Rolls, Whole Wheat","Fantini"]
[17,"Roll, sub, 8\", wheat or white wheat","Sliced, but attached at one side",2,"3.0 oz.","6 3.0 oz.",6,2450,"Fantini",557,null,6,"X",1.8,{"$f":"IF(ISBLANK(L19),H19, (H19*G19)/L19)","v":2450},{"$f":"O19*N19","v":4410},null,null,1.45,11,"Duva 557","8\" Sur Roll, Whole Wheat'","Fantini"]
[18,"Wrap, 10\"  diameter, wheat","Round",2,"3.0 oz.","12 3.0 oz.",12,4527,"Josephs",9645,null,12,"X",2.89,{"$f":"IF(ISBLANK(L20),H20, (H20*G20)/L20)","v":4527},{"$f":"O20*N20","v":13083.03},null,null,3.25,17,"Duva 2267","Wrap. 11\" Diameter, Whole Wheat","Joseph's"]
[19,"Wrap, 8\" diameter, wheat","Round",2,"2.0 oz.","10 2.0 oz.",10,1852,"Josephs",9216,null,10,"X",1.85,{"$f":"IF(ISBLANK(L21),H21, (H21*G21)/L21)","v":1852},{"$f":"O21*N21","v":3426.2},null,null,null,16,"Duva 2467","Wrap. 8\" Diameter, Whole Wheat","Joseph's"]
[{"$nulls":13},"Grand Total:  ",null,{"$f":"SUM(P3:P21)","v":397880.54}]

{"sheet":"MSBG Bread Zone 3","index":2,"n_rows":22,"n_cols":23,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1],[21,13,21,14]]}
["Fantini Bakery"]
["Line","Item","Description","Minimum Whole Grain Credit","Approx. Serving size","Approx. Pack Size","Base Pack Size","Projected Usage","Brand","Distributor Code","Pack Size Description","Actual Pack Size","Domestic Product","Price per Pack","Adjusted Projection","Extension","Vendor Comment",null,"17-18 price","17-18 Reference line","17-18 Brand","17-18 Reference item","17-18 Reference brand"]
[1,"Bagel, approx. 3 oz.","Sliced ",2,"3.0 oz.","6 3-3.5 oz.",6,254,"Bagel Boy",2198,null,6,"X",1.89,{"$f":"IF(ISBLANK(L3),H3, (H3*G3)/L3)","v":254},{"$f":"O3*N3","v":480.06},null,null,1.72,20,"Duva 6043","3 oz. Whole Grain Bagel","Zeppy's"]
[2,"Bread, 100% WW, sliced, approx. 4x4, untopped","Approx. 17 oz. and 16 slices",1,"1.0 oz","17 oz. loaf",null,1792,"Fantini",144,null,null,"X",1.65,{"$f":"IF(ISBLANK(L4),H4, (H4*G4)/L4)","v":1792},{"$f":"O4*N4","v":2956.8},null,null,1.55,1,"Duva 144","100% Whole Wheat Bread, Sliced Loaf, Homestyle","Fantini"]
[3,"Bread, 100% WW, sliced, approx. 4x5, grain topped","Approx. 20 oz. and 15 slices",1,"1.33 oz.","20 oz. loaf",null,1047,"Fantini",143,null,null,"X",1.79,{"$f":"IF(ISBLANK(L5),H5, (H5*G5)/L5)","v":1047},{"$f":"O5*N5","v":1874.13},null,null,1.55,2,"Duva 143","100% Whole Wheat sliced bread, large Teacher","Fantini As You Like it."]
[4,"Bread, club,wheat, sliced, approx. 4x4","Approx. 28 oz. and 26 slices",1,"1.0 oz.","28 oz. loaf",null,4676,"Gold Medal",133,null,null,"X",2.25,{"$f":"IF(ISBLANK(L6),H6, (H6*G6)/L6)","v":4676},{"$f":"O6*N6","v":10521},null,null,1.75,3,"Duva 7202","Whole Wheat Club, Sliced Loaf","Gold Medal"]
[5,"Bread, french, wheat, unsliced","Approx.14 oz. and 22 inches","N/A","N/A","14 oz. loaf",null,716,"Fantini",31,null,null,"X",1.9,{"$f":"IF(ISBLANK(L7),H7, (H7*G7)/L7)","v":716},{"$f":"O7*N7","v":1360.4},null,null,1.58,4,"Duva 31","French Bread, Unsliced, Multigrain","Fantini"]
[6,"Bread, multigrain, or 5 grain, sliced","Approx. 20 oz. and 15 slices",1,"1.33 oz.","20 oz. loaf",null,718,"Fantini",142,null,null,"X",1.95,{"$f":"IF(ISBLANK(L8),H8, (H8*G8)/L8)","v":718},{"$f":"O8*N8","v":1400.1},null,null,1.85,5,"Duva 142","Multi Grain Bread Sliced Loaf","Fantini As You Like it."]
[7,"Bread, pita, approx. 7\", wheat or white wheat","Approx. 3.0 oz.",2,"3.0 oz.","4 3.0 oz.",4,2790,"Josephs",213,null,4,"X",1.15,{"$f":"IF(ISBLANK(L9),H9, (H9*G9)/L9)","v":2790},{"$f":"O9*N9","v":3208.5},null,null,2.15,15,"Duva 6012","Syrian/Pita Bread, 7\" Whole Wheat","Joseph's"]
[8,"English muffins, wheat or white wheat","Approx. 2.0 oz. and 3.5 inch, sliced",2,"2.0 oz","12 2.0 oz.",12,700,"Gold Medal",116,null,6,"X",1.62,{"$f":"IF(ISBLANK(L10),H10, (H10*G10)/L10)","v":1400},{"$f":"O10*N10","v":2268},null,null,1.83,18,"Duva 3104","English Muffin, Whole Wheat","Homestead"]
[9,"Panini, wheat, sliced. oat topped","Approx. 38 oz. and 20 slices",1,"2.0 oz.","38 oz. loaf",null,114,"Fantini",1096,null,null,"X",3.75,{"$f":"IF(ISBLANK(L11),H11, (H11*G11)/L11)","v":114},{"$f":"O11*N11","v":427.5},null,null,1.52,19,"Duva 1096","Panini, Multigrain sliced","Fantini"]
[10,"Roll, bulkie, seedless, wheat or white wheat","Approx. 2.5 oz. and 4\", sliced",2,"2.5 oz.","12 2.50 oz.",6,3815,"Fantini",157,null,6,"X",1.42,{"$f":"IF(ISBLANK(L12),H12, (H12*G12)/L12)","v":3815},{"$f":"O12*N12","v":5417.3},null,null,1.6,8,"Duva 157","Bulkie Rolls, Whole Wheat, No seeds","Fantini"]
[11,"Roll, dinner, wheat or white wheat","1 oz, each, soft inside texture, pull-apart cluster ",1,"1.0 oz.","30 1.0 oz.",30,2957,"Fantini",168,null,30,"X",3.3,{"$f":"IF(ISBLANK(L13),H13, (H13*G13)/L13)","v":2957},{"$f":"O13*N13","v":9758.1},null,null,2.5,12,"Duva 168","Dinner Rolls, White Whole Wheat","Fantini"]
[12,"Roll, dinner, honey wheat","1 oz., individuals","1,00","1.0 oz.","12 1.oz.",12,578,"Fantini",167,null,12,"X",1.9,{"$f":"IF(ISBLANK(L14),H14, (H14*G14)/L14)","v":578},{"$f":"O14*N14","v":1098.2},null,null,null,13,"Duva 167","Dinner Rolls, Honey Whole Wheat","Fantini"]
[13,"Roll, French, 4\", wheat or white wheat","Sliced, but attached at one side",1,"1.5 oz.","12 1.5 oz.",12,0,"Fantini",4867,null,12,"X",3.36,{"$f":"IF(ISBLANK(L15),H15, (H15*G15)/L15)","v":0},{"$f":"O15*N15","v":0},null,null,0.95,9,"Duva 4867","4\" French Rolls, Whole Wheat","Fantini"]
[14,"Roll, hamburger, wheat or white wheat","3.5 inch, 2 oz, sliced  ",2,"2.0 oz.","12 2.0 oz.",12,45617,"Fantini",155,null,12,"X",1.74,{"$f":"IF(ISBLANK(L16),H16, (H16*G16)/L16)","v":45617},{"$f":"O16*N16","v":79373.58},null,null,1.5,6,"Duva 155","Hamburg Rolls, Whole Wheat","Fantini"]
[15,"Roll, hot dog, wheat or white wheat","New England Style, top sliced",2,"2.0 oz.","12 2.0 oz.",16,5328,"Gold Medal",215,null,12,"X",2.45,{"$f":"IF(ISBLANK(L17),H17, (H17*G17)/L17)","v":7104},{"$f":"O17*N17","v":17404.8},null,null,1.85,7,"Duva 3016","Hot Dog Rolls, Whole Wheat","Gold Medal"]
[16,"Roll, sub 6\", wheat or white wheat","Sliced, but attached at one side",2,"2.0 oz.","12 2.0 oz.",6,14517,"Fantini",1061,null,6,"X",1.42,{"$f":"IF(ISBLANK(L18),H18, (H18*G18)/L18)","v":14517},{"$f":"O18*N18","v":20614.14},null,null,1.65,10,"Duva 1061","6\" Sub Rolls, Whole Wheat","Fantini"]
[17,"Roll, sub, 8\", wheat or white wheat","Sliced, but attached at one side",2,"3.0 oz.","6 3.0 oz.",6,null,"Fantini",557,null,6,"X",1.8,{"$f":"IF(ISBLANK(L19),H19, (H19*G19)/L19)","v":0},{"$f":"O19*N19","v":0},null,null,1.45,11,"Duva 557","8\" Sur Roll, Whole Wheat'","Fantini"]
[18,"Wrap, 10\"  diameter, wheat","Round",2,"3.0 oz.","12 3.0 oz.",12,2910,"Josephs",9645,null,12,"X",2.89,{"$f":"IF(ISBLANK(L20),H20, (H20*G20)/L20)","v":2910},{"$f":"O20*N20","v":8409.9},null,null,3.25,17,"Duva 2267","Wrap. 11\" Diameter, Whole Wheat","Joseph's"]
[19,"Wrap, 8\" diameter, wheat","Round",2,"2.0 oz.","10 2.0 oz.",10,727,"Josephs",9216,null,10,"X",1.85,{"$f":"IF(ISBLANK(L21),H21, (H21*G21)/L21)","v":727},{"$f":"O21*N21","v":1344.95},null,null,null,16,"Duva 2467","Wrap. 8\" Diameter, Whole Wheat","Joseph's"]
[{"$nulls":13},"Grand Total:  ",null,{"$f":"SUM(P3:P21)","v":167917.46}]

{"sheet":"MSBG Bread Zone 4","index":3,"n_rows":22,"n_cols":23,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1],[21,13,21,14]]}
["Enter Company name in this cell"]
["Line","Item","Description","Minimum Whole Grain Credit","Approx. Serving size","Approx. Pack Size","Base Pack Size","Projected Usage","Brand","Distributor Code","Pack Size Description","Actual Pack Size","Domestic Product","Price per Pack","Adjusted Projection","Extension","Vendor Comment",null,"17-18 price","17-18 Reference line","17-18 Brand","17-18 Reference item","17-18 Reference brand"]
[1,"Bagel, approx. 3 oz.","Sliced ",2,"3.0 oz.","6 3-3.5 oz.",6,450,{"$nulls":6},{"$f":"IF(ISBLANK(L3),H3, (H3*G3)/L3)","v":450},{"$f":"O3*N3","v":0},null,null,1.72,20,"Duva 6043","3 oz. Whole Grain Bagel","Zeppy's"]
[2,"Bread, 100% WW, sliced, approx. 4x4, untopped","Approx. 17 oz. and 16 slices",1,"1.0 oz","17 oz. loaf",null,16154,{"$nulls":6},{"$f":"IF(ISBLANK(L4),H4, (H4*G4)/L4)","v":16154},{"$f":"O4*N4","v":0},null,null,1.55,1,"Duva 144","100% Whole Wheat Bread, Sliced Loaf, Homestyle","Fantini"]
[3,"Bread, 100% WW, sliced, approx. 4x5, grain topped","Approx. 20 oz. and 15 slices",1,"1.33 oz.","20 oz. loaf",null,695,{"$nulls":6},{"$f":"IF(ISBLANK(L5),H5, (H5*G5)/L5)","v":695},{"$f":"O5*N5","v":0},null,null,1.55,2,"Duva 143","100% Whole Wheat sliced bread, large Teacher","Fantini As You Like it."]
[4,"Bread, club,wheat, sliced, approx. 4x4","Approx. 28 oz. and 26 slices",1,"1.0 oz.","28 oz. loaf",null,4739,{"$nulls":6},{"$f":"IF(ISBLANK(L6),H6, (H6*G6)/L6)","v":4739},{"$f":"O6*N6","v":0},null,null,1.75,3,"Duva 7202","Whole Wheat Club, Sliced Loaf","Gold Medal"]
[5,"Bread, french, wheat, unsliced","Approx.14 oz. and 22 inches","N/A","N/A","14 oz. loaf",null,260,{"$nulls":6},{"$f":"IF(ISBLANK(L7),H7, (H7*G7)/L7)","v":260},{"$f":"O7*N7","v":0},null,null,1.58,4,"Duva 31","French Bread, Unsliced, Multigrain","Fantini"]
[6,"Bread, multigrain, or 5 grain, sliced","Approx. 20 oz. and 15 slices",1,"1.33 oz.","20 oz. loaf",null,45,{"$nulls":6},{"$f":"IF(ISBLANK(L8),H8, (H8*G8)/L8)","v":45},{"$f":"O8*N8","v":0},null,null,1.85,5,"Duva 142","Multi Grain Bread Sliced Loaf","Fantini As You Like it."]
[7,"Bread, pita, approx. 7\", wheat or white wheat","Approx. 3.0 oz.",2,"3.0 oz.","4 3.0 oz.",4,300,{"$nulls":6},{"$f":"IF(ISBLANK(L9),H9, (H9*G9)/L9)","v":300},{"$f":"O9*N9","v":0},null,null,2.15,15,"Duva 6012","Syrian/Pita Bread, 7\" Whole Wheat","Joseph's"]
[8,"English muffins, wheat or white wheat","Approx. 2.0 oz. and 3.5 inch, sliced",2,"2.0 oz","12 2.0 oz.",12,888,{"$nulls":6},{"$f":"IF(ISBLANK(L10),H10, (H10*G10)/L10)","v":888},{"$f":"O10*N10","v":0},null,null,1.83,18,"Duva 3104","English Muffin, Whole Wheat","Homestead"]
[9,"Panini, wheat, sliced. oat topped","Approx. 38 oz. and 20 slices",1,"2.0 oz.","38 oz. loaf",{"$nulls":8},{"$f":"IF(ISBLANK(L11),H11, (H11*G11)/L11)","v":0},{"$f":"O11*N11","v":0},null,null,1.52,19,"Duva 1096","Panini, Multigrain sliced","Fantini"]
[10,"Roll, bulkie, seedless, wheat or white wheat","Approx. 2.5 oz. and 4\", sliced",2,"2.5 oz.","12 2.50 oz.",6,7492,{"$nulls":6},{"$f":"IF(ISBLANK(L12),H12, (H12*G12)/L12)","v":7492},{"$f":"O12*N12","v":0},null,null,1.6,8,"Duva 157","Bulkie Rolls, Whole Wheat, No seeds","Fantini"]
[11,"Roll, dinner, wheat or white wheat","1 oz, each, soft inside texture, pull-apart cluster ",1,"1.0 oz.","30 1.0 oz.",30,17771,{"$nulls":6},{"$f":"IF(ISBLANK(L13),H13, (H13*G13)/L13)","v":17771},{"$f":"O13*N13","v":0},null,null,2.5,12,"Duva 168","Dinner Rolls, White Whole Wheat","Fantini"]
[12,"Roll, dinner, honey wheat","1 oz., individuals","1,00","1.0 oz.","12 1.oz.",12,{"$nulls":7},{"$f":"IF(ISBLANK(L14),H14, (H14*G14)/L14)","v":0},{"$f":"O14*N14","v":0},null,null,null,13,"Duva 167","Dinner Rolls, Honey Whole Wheat","Fantini"]
[13,"Roll, French, 4\", wheat or white wheat","Sliced, but attached at one side",1,"1.5 oz.","12 1.5 oz.",12,{"$nulls":7},{"$f":"IF(ISBLANK(L15),H15, (H15*G15)/L15)","v":0},{"$f":"O15*N15","v":0},null,null,0.95,9,"Duva 4867","4\" French Rolls, Whole Wheat","Fantini"]
[14,"Roll, hamburger, wheat or white wheat","3.5 inch, 2 oz, sliced  ",2,"2.0 oz.","12 2.0 oz.",12,28802,{"$nulls":6},{"$f":"IF(ISBLANK(L16),H16, (H16*G16)/L16)","v":28802},{"$f":"O16*N16","v":0},null,null,1.5,6,"Duva 155","Hamburg Rolls, Whole Wheat","Fantini"]
[15,"Roll, hot dog, wheat or white wheat","New England Style, top sliced",2,"2.0 oz.","12 2.0 oz.",16,13709,{"$nulls":6},{"$f":"IF(ISBLANK(L17),H17, (H17*G17)/L17)","v":13709},{"$f":"O17*N17","v":0},null,null,1.85,7,"Duva 3016","Hot Dog Rolls, Whole Wheat","Gold Medal"]
[16,"Roll, sub 6\", wheat or white wheat","Sliced, but attached at one side",2,"2.0 oz.","12 2.0 oz.",6,5650,{"$nulls":6},{"$f":"IF(ISBLANK(L18),H18, (H18*G18)/L18)","v":5650},{"$f":"O18*N18","v":0},null,null,1.65,10,"Duva 1061","6\" Sub Rolls, Whole Wheat","Fantini"]
[17,"Roll, sub, 8\", wheat or white wheat","Sliced, but attached at one side",2,"3.0 oz.","6 3.0 oz.",6,2484,{"$nulls":6},{"$f":"IF(ISBLANK(L19),H19, (H19*G19)/L19)","v":2484},{"$f":"O19*N19","v":0},null,null,1.45,11,"Duva 557","8\" Sur Roll, Whole Wheat'","Fantini"]
[18,"Wrap, 10\"  diameter, wheat","Round",2,"3.0 oz.","12 3.0 oz.",12,1540,{"$nulls":6},{"$f":"IF(ISBLANK(L20),H20, (H20*G20)/L20)","v":1540},{"$f":"O20*N20","v":0},null,null,3.25,17,"Duva 2267","Wrap. 11\" Diameter, Whole Wheat","Joseph's"]
[19,"Wrap, 8\" diameter, wheat","Round",2,"2.0 oz.","10 2.0 oz.",10,2795,{"$nulls":6},{"$f":"IF(ISBLANK(L21),H21, (H21*G21)/L21)","v":2795},{"$f":"O21*N21","v":0},null,null,null,16,"Duva 2467","Wrap. 8\" Diameter, Whole Wheat","Joseph's"]
[{"$nulls":13},"Grand Total:  ",null,{"$f":"SUM(P3:P21)","v":0}]

{"sheet":"Sheet2","index":4,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["X"]
["Exception"]