{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["C1 Food Packages","C2-C4 + W Food Packages","Food Item Substition Maximums","Notes","C1 Food Packages - edits","C2-C4 + W Food Packages-edits","Infant 6-11 mo Food Packages","Legend","Food Package II","Food Package IV-A","Food Package IV-B","Food Package V-A","Food Package V-B","Food Package VI","Food Package VII","CVB-->Infant F V","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":7,"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":"C1 Food Packages","index":0,"n_rows":72,"n_cols":9,"rows_kept":72,"cut":false,"hidden":true,"merged":[[38,0,38,8]]}
["Total Food Packages: 6 (or 12 if want to keep Nut/Seed butter completely separate)"]
["Food Package IV.a."]
[]
["C1 Food Packages",null,null,null,null,"C1 Food Packages (Food Package III)"]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Whole Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*",null,"Whole Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Peanut Butter/Legumes","Y","Nut/Seed Butter",null,null,"Peanut Butter/Legumes","Y","Nut/Seed Butter"]
[null,null,null,null,null,"Formula","N"]
[]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Plant-based Beverage","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*",null,"Plant-based Beverage","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Peanut Butter/Legumes","Y","Nut/Seed Butter",null,null,"Peanut Butter/Legumes","Y","Nut/Seed Butter"]
[null,null,null,null,null,"Formula","N"]
[]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["2% Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*",null,"2% Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Peanut Butter/Legumes","Y","Nut/Seed Butter",null,null,"Peanut Butter/Legumes","Y","Nut/Seed Butter"]
[null,null,null,null,null,"Formula","N"]
["*Yogurt must be whole fat and low fat only. "]
[]
["If need to create separate food packages for nut/seed butter"]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Whole Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*",null,"Whole Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Nut/Seed Butter","N",null,null,null,"Nut/Seed Butter","N"]
[null,null,null,null,null,"Formula","N"]
[]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Plant-based Beverage","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*",null,"Plant-based Beverage","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Nut/Seed Butter","N",null,null,null,"Nut/Seed Butter","N"]
[null,null,null,null,null,"Formula","N"]
[]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["2% Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*",null,"2% Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Nut/Seed Butter","N",null,null,null,"Nut/Seed Butter","N"]
[null,null,null,null,null,"Formula","N"]
["*Yogurt must be whole fat and low fat only. "]

{"sheet":"C2-C4 + W Food Packages","index":1,"n_rows":97,"n_cols":9,"rows_kept":97,"cut":false,"hidden":true,"merged":[[51,0,51,8]]}
["Total Food Packages per category: 7 (or 14 if want to keep Nut/Seed butter completely separate)"]
["Total: 35 (70)"]
["Food Package IV.b., V.a., V.b., VI, and VII"]
[]
["C2-C4 & Women Food Packages",null,null,null,null,"C2-C4 & Women Food Packages (Food Package III)"]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["1%, 1/2%, or Skim Milk","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt",null,"1%, 1/2%, or Skim Milk","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Peanut Butter/Legumes","Y","Nut/Seed Butter",null,null,"Peanut Butter/Legumes","Y","Nut/Seed Butter"]
[null,null,null,null,null,"Formula","N"]
[]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Plant-based Beverage","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt",null,"Plant-based Beverage","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Peanut Butter/Legumes","Y","Nut/Seed Butter",null,null,"Peanut Butter/Legumes","Y","Nut/Seed Butter"]
[null,null,null,null,null,"Formula","N"]
[]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["2% Milk","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt",null,"2% Milk","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Peanut Butter/Legumes","Y","Nut/Seed Butter",null,null,"Peanut Butter/Legumes","Y","Nut/Seed Butter"]
[null,null,null,null,null,"Formula","N"]
[]
[null,null,null,null,null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
[null,null,null,null,null,"Whole Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
[null,null,null,null,null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
[null,null,null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
[null,null,null,null,null,"Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu"]
[null,null,null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
[null,null,null,null,null,"Whole Grains","N"]
[null,null,null,null,null,"Fish","N"]
[null,null,null,null,null,"Peanut Butter/Legumes","Y","Nut/Seed Butter"]
[null,null,null,null,null,"Formula","N"]
[]
[null,null,null,null,null,"*Yogurt must be whole fat and low fat only. "]
[]
["If need to create separate food packages for nut/seed butter"]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["1%, 1/2%, or Skim Milk","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt",null,"1%, 1/2%, or Skim Milk","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Nut/Seed Butter","N",null,null,null,"Nut/Seed Butter","N"]
[null,null,null,null,null,"Formula","N"]
[]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Plant-based Beverage","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt",null,"Plant-based Beverage","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Nut/Seed Butter","N",null,null,null,"Nut/Seed Butter","N"]
[null,null,null,null,null,"Formula","N"]
[]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["2% Milk","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt",null,"2% Milk","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Nut/Seed Butter","N",null,null,null,"Nut/Seed Butter","N"]
[null,null,null,null,null,"Formula","N"]
[]
[null,null,null,null,null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
[null,null,null,null,null,"Whole Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
[null,null,null,null,null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
[null,null,null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
[null,null,null,null,null,"Eggs","Y","Nut/Seed Butter\nTofu"]
[null,null,null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
[null,null,null,null,null,"Whole Grains","N"]
[null,null,null,null,null,"Fish","N"]
[null,null,null,null,null,"Nut/Seed Butter","N"]
[null,null,null,null,null,"Formula","N"]
[]
[null,null,null,null,null,"*Yogurt must be whole fat and low fat only. "]

{"sheet":"Food Item Substition Maximums","index":2,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Client Category","Food Item","Eligible Substitutions","Starting Value","Unit of Measure","Increment Levels","Maximum (MMA)","Notes/Potential System Rules due to Policy"]
["BE","Milk","Cheese (16 oz=3 QT)\nYogurt (1 QT=1 QT)\nTofu (1 lb=1 QT)",16,"Quarts","16, 15, 14, 13, 12….0",16,"Exchange rate, dangling qt functionality "]
["BP, PG, NPP","Milk","Cheese (16 oz=3 QT)\nYogurt (1 QT=1 QT)\nTofu (1 lb=1 QT)",16,"Quarts","16, 15, 14, 13, 12….0",16]
["C1","Milk","Cheese (16 oz=3 QT)\nYogurt (1 QT=1 QT)\nTofu (1 lb=1 QT)",12,"Quarts","12, 11, 10, 9, 8….0",12]
["C2-C4","Milk","Cheese (16 oz=3 QT)\nYogurt (1 QT=1 QT)\nTofu (1 lb=1 QT)",14,"Quarts","14, 13, 12, 11, 10….0",14]
["BE","Cheese","Milk",32,"Ounces","0, 16, 32",32]
["BP, PG, NPP, C1, C2-C4","Cheese","Milk",16,"Ounces","0, 16",16]
["BE, BP, PG, NPP, C1, C2-C4","Yogurt","Milk",32,"Ounces","0, 32, 64",64]
["BE","Tofu","Milk\nEggs",0,"Lbs","0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16",16]
["BP, PG, NPP","Tofu","Milk\nEggs",0,"Lbs"," 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16",16]
["C1","Tofu","Milk\nEggs",0,"Lbs","0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12",12]
["C2-C4","Tofu","Milk\nEggs",0,"Lbs"," 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14",14]
["BE","Eggs","Legumes\nTofu",2,"Dozen","2, 1, 0",2]
["BP, PG, NPP, C1, C2-C4","Eggs","Legumes\nTofu",1,"Dozen","1, 0",1]
["BE, BP, PG, NPP, C1, C2-C4","Breakfast Cereal","Infant Cereal",36,"Ounces","36, 0",36,"System rule may be needed for infant cereal substitution \n(i.e. pop up SFFR required, currently we require expiration date entered)"]
["BE, BP, PG, NPP, C1, C2-C4","Infant Cereal","Breakfast Cereal",0,"Ounces","0, 32",32]
["BE, BP, PG, NPP, C1, C2-C4","Juice","CVB",64,"Ounces","64, 0",64]
["BE, BP","CVB","Juice","X","$$$","X + Y","X + Y"]
["PG, NPP","CVB","Juice","X","$$$","X + Y","X + Y"]
["C1-C4","CVB","Juice","X","$$$","X + Y","X + Y"]
["IBE, IBP, IFF","CVB","Infant F/V","X","$$$","0, X, X*2","X*2","System rule may be needed to remind that CVB only issued after nutrition assessment (i.e. pop up)"]
["IBE, IBP, IFF","Infant F/V","CVB",128,"Ounces","128, 64, 0",128]
["BE, BP, PG, NPP","Infant F/V","CVB",0,"Ounces","0, 32, 64, 96, 128, 160","X * 6.25 ounces","System rule may be needed for infant F/V substitution \n(i.e. pop up SFFR required, currently we require expiration date entered)"]
["C1, C2-C4","Infant F/V","CVB",0,"Ounces","0, 32, 64, 96, 128 ","X * 6.25 ounces","System rule may be needed for infant F/V substitution \n(i.e. pop up SFFR required, currently we require expiration date entered)"]
["BE","Fish","None",20,"Ounces","None",20]
["PG","Fish","None",10,"Ounces","None",10]
["BP, NPP","Fish","None",15,"Ounces","None",15]
["C1, C2-C4","Fish","None",6,"Ounces","None",6]
["BE, BP, PG, NPP","Whole grains","None",48,"Ounces","None",48]
["C1, C2-C4","Whole grains","None",24,"Ounces","None",24]
["IBE","Infant Meat","None",40,"Ounces","None",40]
["All Categories","Formula","None"]

{"sheet":"Notes","index":3,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
["This document will go through the various permutations of food packages. "]
[]
["Food Package I: food packages are already created for each infant category (IBE, IBP, and IFF) and for each formula."]
["Food Package II: food packages are already created for each infant category (IBE, IBP, and IFF) and for each infant formula. \n**However, would like to be able to use new substitution functionality for infant fruits/vegetables-->CVB and only have one 6-11 month food package for each permutation."]
[]
["The remaining food packages categories contain the same core food items for children and women categories."]

{"sheet":"C1 Food Packages - edits","index":4,"n_rows":73,"n_cols":9,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
["Total Food Packages: 2 "]
["Food Package IV.a."]
[]
["C1 Food Packages",null,null,null,null,"C1 Food Packages (Food Package III)"]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Whole Milk","Y","Cheese\nYogurt*\nTofu\nPlant-based beverage**\n2% Milk**","Cheese\nYogurt*",null,"Whole Milk","Y","Cheese\nYogurt*\nTofu\nPlant-based beverage**\n2% Milk**","Cheese\nYogurt*"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter/Legumes\nTofu",null,null,"Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter/Legumes\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Peanut Butter/Legumes","Y","Nut/Seed Butter/Legumes",null,null,"Peanut Butter/Legumes","Y","Nut/Seed Butter/Legumes"]
["*Yogurt must be whole fat and low fat only. ",null,null,null,null,"**must have formula**"]
["**must replace all milk remaining."]
[null,null,null,null,null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Plant-based Beverage","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
["Plant-based Beverage","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Cereal","N",null,null,null,"Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu"]
["Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu",null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Whole Grains","N"]
["Whole Grains","N",null,null,null,"Fish","N"]
["Fish","N",null,null,null,"Peanut Butter/Legumes","Y","Nut/Seed Butter"]
["Peanut Butter/Legumes","Y","Nut/Seed Butter",null,null,"Formula","N"]
[]
[null,null,null,null,null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"2% Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
["2% Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Cereal","N",null,null,null,"Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu"]
["Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu",null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Whole Grains","N"]
["Whole Grains","N",null,null,null,"Fish","N"]
["Fish","N",null,null,null,"Peanut Butter/Legumes","Y","Nut/Seed Butter"]
["Peanut Butter/Legumes","Y","Nut/Seed Butter",null,null,"Formula","N"]
[]
["*Yogurt must be whole fat and low fat only. "]
[]
["If need to create separate food packages for nut/seed butter",null,null,null,null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Whole Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
["Whole Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Cereal","N",null,null,null,"Eggs","Y","Nut/Seed Butter\nTofu"]
["Eggs","Y","Nut/Seed Butter\nTofu",null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Whole Grains","N"]
["Whole Grains","N",null,null,null,"Fish","N"]
["Fish","N",null,null,null,"Nut/Seed Butter","N"]
["Nut/Seed Butter","N",null,null,null,"Formula","N"]
[]
[null,null,null,null,null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Plant-based Beverage","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
["Plant-based Beverage","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Cereal","N",null,null,null,"Eggs","Y","Nut/Seed Butter\nTofu"]
["Eggs","Y","Nut/Seed Butter\nTofu",null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Whole Grains","N"]
["Whole Grains","N",null,null,null,"Fish","N"]
["Fish","N",null,null,null,"Nut/Seed Butter","N"]
["Nut/Seed Butter","N",null,null,null,"Formula","N"]
[]
[null,null,null,null,null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"2% Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
["2% Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Cereal","N",null,null,null,"Eggs","Y","Nut/Seed Butter\nTofu"]
["Eggs","Y","Nut/Seed Butter\nTofu",null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Whole Grains","N"]
["Whole Grains","N",null,null,null,"Fish","N"]
["Fish","N",null,null,null,"Nut/Seed Butter","N"]
["Nut/Seed Butter","N",null,null,null,"Formula","N"]
[]
["*Yogurt must be whole fat and low fat only. "]

{"sheet":"C2-C4 + W Food Packages-edits","index":5,"n_rows":97,"n_cols":9,"rows_kept":97,"cut":false,"hidden":true,"merged":[[51,0,51,8]]}
["Total Food Packages per category: 3"]
["Total: 15"]
["Food Package IV.b., V.a., V.b., VI, and VII"]
[]
["C2-C4 & Women Food Packages",null,null,null,null,"C2-C4 & Women Food Packages (Food Package III)"]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["1%, 1/2%, or Skim Milk","Y","Cheese\nYogurt\nTofu\nPlant-based beverage**\n2% Milk**","Cheese\nYogurt",null,"1%, 1/2%, or Skim Milk","Y","Cheese\nYogurt\nTofu\nPlant-based beverage**\n2% Milk**","Cheese\nYogurt"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter/Legumes\nTofu",null,null,"Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter/Legumes\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Peanut Butter/Legumes","Y","Nut/Seed Butter/Legumes",null,null,"Peanut Butter/Legumes","Y","Nut/Seed Butter/Legumes"]
["**must replace all milk remaining.",null,null,null,null,"**must have formula**"]
[]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Plant-based Beverage","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt",null,"Plant-based Beverage","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Peanut Butter/Legumes","Y","Nut/Seed Butter",null,null,"Peanut Butter/Legumes","Y","Nut/Seed Butter"]
[null,null,null,null,null,"Formula","N"]
[]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["2% Milk","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt",null,"2% Milk","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Peanut Butter/Legumes","Y","Nut/Seed Butter",null,null,"Peanut Butter/Legumes","Y","Nut/Seed Butter"]
[null,null,null,null,null,"Formula","N"]
[]
[null,null,null,null,null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
[null,null,null,null,null,"Whole Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
[null,null,null,null,null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
[null,null,null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
[null,null,null,null,null,"Eggs","Y","Peanut Butter/Legumes or Nut/Seed Butter\nTofu"]
[null,null,null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
[null,null,null,null,null,"Whole Grains","N"]
[null,null,null,null,null,"Fish","N"]
[null,null,null,null,null,"Peanut Butter/Legumes","Y","Nut/Seed Butter/Legumes"]
[null,null,null,null,null,"**must have formula**"]
[null,null,null,null,null,"*Yogurt must be whole fat and low fat only. "]
[null,null,null,null,null,"**must replace all milk remaining."]
[]
["If need to create separate food packages for nut/seed butter"]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["1%, 1/2%, or Skim Milk","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt",null,"1%, 1/2%, or Skim Milk","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Nut/Seed Butter","N",null,null,null,"Nut/Seed Butter","N"]
[null,null,null,null,null,"Formula","N"]
[]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Plant-based Beverage","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt",null,"Plant-based Beverage","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Nut/Seed Butter","N",null,null,null,"Nut/Seed Butter","N"]
[null,null,null,null,null,"Formula","N"]
[]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions",null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["2% Milk","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt",null,"2% Milk","Y","Cheese\nYogurt\nTofu","Cheese\nYogurt"]
["Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)",null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
["Cereal","N",null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
["Eggs","Y","Nut/Seed Butter\nTofu",null,null,"Eggs","Y","Nut/Seed Butter\nTofu"]
["Fruits and Vegetables (CVB)","N",null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables"]
["Whole Grains","N",null,null,null,"Whole Grains","N"]
["Fish","N",null,null,null,"Fish","N"]
["Nut/Seed Butter","N",null,null,null,"Nut/Seed Butter","N"]
[null,null,null,null,null,"Formula","N"]
[]
[null,null,null,null,null,"Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
[null,null,null,null,null,"Whole Milk","Y","Cheese\nYogurt*\nTofu","Cheese\nYogurt*"]
[null,null,null,null,null,"Juice","Y","Fruits and Vegetables (CVB)","Fruits and Vegetables (CVB)"]
[null,null,null,null,null,"Cereal","Y","Infant Cereal","Infant Cereal"]
[null,null,null,null,null,"Eggs","Y","Nut/Seed Butter\nTofu"]
[null,null,null,null,null,"Fruits and Vegetables (CVB)","Y","Infant Fruit/Vegetables","Infant Fruit/Vegetables"]
[null,null,null,null,null,"Whole Grains","N"]
[null,null,null,null,null,"Fish","N"]
[null,null,null,null,null,"Nut/Seed Butter","N"]
[null,null,null,null,null,"Formula","N"]
[]
[null,null,null,null,null,"*Yogurt must be whole fat and low fat only. "]

{"sheet":"Infant 6-11 mo Food Packages","index":6,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Total Food Packages: "]
["Food Package II/III"]
[]
["Infant 6-11 month Food Packages"]
["Core Food Item","Allowable Substitution?","Substitutions","Default Substitutions"]
["Formula (IBP/IFF only)*","N"]
["Infant Cereal","N"]
["Infant Fruits/Vegetables","Y","Fruits and Vegetables (CVB)"]
["Infant Meat (IBE only)","N"]
[]
["* All formulas will have individual food packages created per client category"]
[]
["Note:  All infant food packages (IBE, IBP, and IFF) are already created but will need to be modified with the new functionality"]

{"sheet":"Legend","index":7,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[5,0,6,0],[7,0,8,0],[9,0,11,0],[13,0,13,1]]}
["Food Package Category","Eligible Client Categories"]
["Food Package II","IBE, IBP, and IFF (6-11 months of age)"]
["Food Package IV-A","C1"]
["Food Package IV-B","C2-C4"]
["Food Package V-A","PG"]
["Food Package V-B","·     BP"]
[null,"·     PG expecting two or more fetuses."]
["Food Package VI","·     NPP"]
[null,"·     BP receiving more than the maximum amount of formula for partially breastfed infants (up to 6 months)."]
["Food Package VII","·     BE"]
[null,"·     BP with multiple IBPs under 1 year old from the same pregnancy."]
[null,"·     PG and breastfeeding an infant under 1 year old."]
[]
["Note: Each sheet shows functionality of both the Display and Customize pop-ups in one. \nThe display pop-up will display any and all customizations/substitutions made to the food package. \nThe customization screen will only show substitutitions and their quantities in the bottom grid."]

{"sheet":"Food Package II","index":8,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[0,1,0,3],[0,7,0,9],[1,7,1,9],[11,1,11,3],[11,7,11,9]]}
[null,"Food Package II (IBE)",null,null,null,null,null,"Food Package II (IBP/IFF)"]
[]
[null,"Quantity","Package Size","Description",null,null,null,"Quantity","Package Size","Description"]
[null,16,"OZ","Infant Cereal",null,null,null,8,"OZ","Infant Cereal"]
[null,40,"OZ","Infant Meat",null,null,null,"xx","units","Formula"]
[null,{"$f":"128-F13","v":128},"OZ","Infant Fruits/Vegetables",null,null,null,{"$f":"128-L13","v":128},"OZ","Infant Fruits/Vegetables"]
[null,{"$f":"B13","v":0},"$$$","FRUITS AND VEGETABLES",null,null,null,{"$f":"H13","v":0},"$$$","FRUITS AND VEGETABLES"]
[null,"Conditional formatting to \"hide\" substitutions that equal 0.",null,null,null,null,null,"Conditional formatting to \"hide\" substitutions that equal 0."]
[]
[null,"Substitutions",null,null,null,null,null,"Substitutions"]
[null,"Substitution Amt","Package Size","Description",null,null,null,"Substitution Amt","Package Size","Description"]
[null,"Infant Fruits/Vegetables Substitutions",null,null,null,null,null,"Infant Fruits/Vegetables Substitutions"]
[null,0,"$$$","Fruit and vegetable CVB",null,{"$f":"ROUNDUP(B13*5.8, 0)","v":0},null,0,"$$$","Fruit and vegetable CVB",null,{"$f":"ROUNDUP(H13*5.8, 0)","v":0}]
[]
[]
[null,"Note: The order of the food items does not reflect the order in MI-WIC."]

{"sheet":"Food Package IV-A","index":9,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[38,7,38,9],[40,7,40,9],[32,7,32,9],[33,1,33,3],[36,7,36,9],[23,7,23,9],[27,1,27,3],[29,1,29,3],[29,7,29,9],[0,1,0,3],[0,7,0,9],[1,7,1,9],[21,1,21,3]]}
[null,"Food Package IV-A",null,null,null,null,null,"Food Package IV-A (Infant Foods)"]
[null,null,null,null,null,null,null,"Functioning as Food Package III (must have formula assigned)"]
[null,"Quantity","Package Size","Description",null,null,null,"Quantity","Package Size","Description"]
[null,{"$f":"16-SUM(E23:E27)","v":12},"QT","Whole Milk",null,null,null,{"$f":"16-SUM(K25:K29)","v":12},"QT","Whole Milk"]
[null,{"$f":"B26","v":0},"QT","Plant-based Beverage",null,null,null,{"$f":"H28","v":0},"QT","Plant-based Beverage"]
[null,{"$f":"B27","v":0},"QT","2% Milk",null,null,null,{"$f":"H29","v":0},"QT","2% Milk"]
[null,{"$f":"B23","v":16},"OZ","CHEESE ($8.00 MAX PER LB.)",null,null,null,{"$f":"H25","v":16},"OZ","CHEESE ($8.00 MAX PER LB.)"]
[null,{"$f":"B24","v":32},"OZ","Whole Fat or Low Fat Yogurt",null,null,null,{"$f":"H26","v":32},"OZ","Whole Fat or Low Fat Yogurt"]
[null,{"$f":"B25+B31","v":0},"LB","TOFU",null,null,null,{"$f":"H27+H34","v":0},"LB","TOFU"]
[null,{"$f":"IF(E29=3, 0, 1)","v":0},"BTL","Juice 64 oz",null,null,null,{"$f":"1-K31-K32","v":0},"BTL","Juice 64 oz"]
[null,36,"OZ","CEREAL",null,null,null,{"$f":"36-K40","v":0},"OZ","CEREAL"]
[null,{"$f":"1-E31-E32-E33","v":1},"DOZ","EGGS",null,null,null,{"$f":"H40","v":32},"OZ","Infant Cereal"]
[null,{"$f":"26+E29","v":29},"$$$","FRUITS AND VEGETABLES",null,null,null,{"$f":"1-K34-K35-K36","v":1},"DOZ","EGGS"]
[null,24,"OZ","WHOLE GRAINS",null,null,null,{"$f":"26+H31-K42","v":0},"$$$","FRUITS AND VEGETABLES"]
[null,6,"OZ","FISH",null,null,null,{"$f":"H42+L32","v":181},"OZ","Infant Fruits/Vegetables"]
[null,{"$f":"1+E32-E35","v":1},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean",null,null,null,24,"OZ","WHOLE GRAINS"]
[null,{"$f":"E33+E35","v":0},"JAR","Nut & Seed Butter/Legumes",null,null,null,6,"OZ","FISH"]
[null,"Conditional formatting to \"hide\" substitutions that equal 0.",null,null,null,null,null,{"$f":"1+K35-K38","v":1},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean"]
[null,"Conditional formatting to display food item row with negative qty in red.",null,null,null,null,null,{"$f":"K36+K38","v":0},"JAR","Nut & Seed Butter/Legumes"]
[null,"Substitutions",null,null,null,null,null,"Conditional formatting to \"hide\" substitutions that equal 0."]
[null,"Substitution Amt","Package Size","Description",null,null,null,"Conditional formatting to display food item row with negative qty in red."]
[null,"Milk Substitutions",null,null,null,null,null,"Substitutions"]
[null,16,"OZ","Cheese",{"$f":"(B23/16)*3","v":3},null,null,"Substitution Amt","Package Size","Description"]
[null,32,"OZ","Whole Fat/Low Fat Yogurt",{"$f":"B24/32","v":1},null,null,"Milk Substitutions"]
[null,0,"LB","Tofu",{"$f":"B25","v":0},null,null,16,"OZ","Cheese",{"$f":"(H25/16)*3","v":3}]
[null,0,"QT","Plant-based Beverage",{"$f":"B26","v":0},null,null,32,"OZ","Whole Fat/Low Fat Yogurt",{"$f":"H26/32","v":1}]
[null,0,"QT","2% Milk",{"$f":"B27","v":0},null,null,0,"LB","Tofu",{"$f":"H27","v":0}]
[null,"Juice Substitutions",null,null,null,null,null,0,"QT","Plant-based Beverage",{"$f":"H28","v":0}]
[null,3,"$$$","Fruit and Vegetable CVB",{"$f":"B29","v":3},null,null,0,"QT","2% Milk",{"$f":"H29","v":0}]
[null,"Eggs Substitutions",null,null,null,null,null,"Juice Substitutions"]
[null,0,"LB","Tofu",{"$f":"B31","v":0},null,null,0,"$$$","Fruit and Vegetable CVB",{"$f":"H31/3","v":0}]
[null,0,"JAR","Peanut Butter/Legumes",{"$f":"B32","v":0},null,null,18,"OZ","Infant Fruits/Vegetables",{"$f":"ROUNDUP(H32/6.25,0)/3","v":1},{"$f":"IF(H32=18, H32+1, 0)","v":19}]
[null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"B33","v":0},null,null,"Eggs Substitutions"]
[null,"Peanut Butter/Legumes Substitutions",null,null,null,null,null,0,"LB","Tofu",{"$f":"H34","v":0}]
[null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"B35","v":0},null,null,0,"JAR","Peanut Butter/Legumes",{"$f":"H35","v":0}]
[null,null,null,null,null,null,null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"H36","v":0}]
[null,null,null,null,null,null,null,"Peanut Butter/Legumes Substitutions"]
[null,null,null,null,null,null,null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"H38","v":0}]
[null,null,null,null,null,null,null,"Cereal Substitutions"]
[null,null,null,null,null,null,null,32,"OZ","Infant Cereal",{"$f":"(H40/32)*36","v":36}]
[null,null,null,null,null,null,null,"Fruits and Vegetable Substitutions"]
[null,null,null,null,null,null,null,162,"OZ","Infant Fruits/Vegetables",{"$f":"ROUNDUP(H42/6.25,0)","v":26}]
[]
[]
[null,"Note: The order of the food items does not reflect the order in MI-WIC."]

{"sheet":"Food Package IV-B","index":10,"n_rows":46,"n_cols":22,"rows_kept":46,"cut":false,"hidden":false,"merged":[[38,7,38,9],[40,7,40,9],[32,7,32,9],[32,14,32,16],[33,1,33,3],[34,14,34,16],[36,7,36,9],[36,14,36,16],[23,7,23,9],[25,14,25,16],[27,1,27,3],[28,14,28,16],[29,1,29,3],[29,7,29,9],[21,1,21,3],[21,14,21,16],[0,1,0,3],[0,7,0,9],[0,14,0,16],[1,7,1,9],[1,14,1,16]]}
[null,"Food Package IV-B",null,null,null,null,null,"Food Package IV-B (Infant Foods)",null,null,null,null,null,null,"Food Package IV-B (Whole Milk/Infant Foods)"]
[null,null,null,null,null,null,null,"Functioning as Food Package III (must have formula assigned)",null,null,null,null,null,null,"Functioning as Food Package III with Whole Milk (Must have formula assigned)"]
[null,"Quantity","Package Size","Description",null,null,null,"Quantity","Package Size","Description",null,null,null,null,"Quantity","Package Size","Description"]
[null,{"$f":"16-SUM(E23:E27)","v":12},"QT","1%, 1/2% or Skim Milk",null,null,null,{"$f":"16-SUM(K25:K29)","v":12},"QT","1%, 1/2% or Skim Milk",null,null,null,null,{"$f":"16-SUM(R23:R25)","v":12},"QT","Whole Milk"]
[null,{"$f":"B26","v":0},"QT","Plant-based Beverage",null,null,null,{"$f":"H28","v":0},"QT","Plant-based Beverage",null,null,null,null,{"$f":"O23","v":16},"OZ","CHEESE ($8.00 MAX PER LB.)"]
[null,{"$f":"B27","v":0},"QT","2% Milk",null,null,null,{"$f":"H29","v":0},"QT","2% Milk",null,null,null,null,{"$f":"O24","v":32},"OZ","Whole Fat or Low Fat Yogurt"]
[null,{"$f":"B23","v":16},"OZ","CHEESE ($8.00 MAX PER LB.)",null,null,null,{"$f":"H25","v":16},"OZ","CHEESE ($8.00 MAX PER LB.)",null,null,null,null,{"$f":"O25+O30","v":0},"LB","TOFU"]
[null,{"$f":"B24","v":32},"OZ","Low Fat or Non Fat Yogurt",null,null,null,{"$f":"H26","v":32},"OZ","Low Fat or Non Fat Yogurt",null,null,null,null,{"$f":"1-R27-R28","v":0},"BTL","Juice 64 oz",null,null,null,null," "]
[null,{"$f":"B25+B31","v":0},"LB","TOFU",null,null,null,{"$f":"H27+H34","v":0},"LB","TOFU",null,null,null,null,{"$f":"36-R36","v":0},"OZ","CEREAL"]
[null,{"$f":"IF(E29=3, 0, 1)","v":0},"BTL","Juice 64 oz",null,null,null,{"$f":"1-K31-K32","v":0},"BTL","Juice 64 oz",null,null,null,null,{"$f":"O36","v":32},"OZ","Infant Cereal"]
[null,36,"OZ","CEREAL",null,null,null,{"$f":"36-K40","v":0},"OZ","CEREAL",null,null,null,null,{"$f":"1-R30-R31-R32","v":1},"DOZ","EGGS"]
[null,{"$f":"1-E31-E32-E33","v":1},"DOZ","EGGS",null,null,null,{"$f":"H40","v":32},"OZ","Infant Cereal",null,null,null,null,{"$f":"26+O27-R38","v":0},"$$$","FRUITS AND VEGETABLES"]
[null,{"$f":"26+E29","v":29},"$$$","FRUITS AND VEGETABLES",null,null,null,{"$f":"1-K34-K35-K36","v":1},"DOZ","EGGS",null,null,null,null,{"$f":"O38+S28","v":181},"OZ","Infant Fruits/Vegetables"]
[null,24,"OZ","WHOLE GRAINS",null,null,null,{"$f":"26+H31-K42","v":0},"$$$","FRUITS AND VEGETABLES",null,null,null,null,24,"OZ","WHOLE GRAINS"]
[null,6,"OZ","FISH",null,null,null,{"$f":"H42+L32","v":181},"OZ","Infant Fruits/Vegetables",null,null,null,null,6,"OZ","FISH"]
[null,{"$f":"1+E32-E35","v":1},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean",null,null,null,24,"OZ","WHOLE GRAINS",null,null,null,null,{"$f":"1+R31-R34","v":1},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean"]
[null,{"$f":"E33+E35","v":0},"JAR","Nut & Seed Butter/Legumes",null,null,null,6,"OZ","FISH",null,null,null,null,{"$f":"R32+R34","v":0},"JAR","Nut & Seed Butter/Legumes"]
[null,"Conditional formatting to \"hide\" substitutions that equal 0.",null,null,null,null,null,{"$f":"1+K35-K38","v":1},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean",null,null,null,null,"Conditional formatting to \"hide\" substitutions that equal 0."]
[null,"Conditional formatting to display food item row with negative qty in red.",null,null,null,null,null,{"$f":"K36+K38","v":0},"JAR","Nut & Seed Butter/Legumes",null,null,null,null,"Conditional formatting to display food item row with negative qty in red."]
[null,"Substitutions",null,null,null,null,null,"Conditional formatting to \"hide\" substitutions that equal 0.",null,null,null,null,null,null,"Substitutions"]
[null,"Substitution Amt","Package Size","Description",null,null,null,"Conditional formatting to display food item row with negative qty in red.",null,null,null,null,null,null,"Substitution Amt","Package Size","Description"]
[null,"Milk Substitutions",null,null,null,null,null,"Substitutions",null,null,null,null,null,null,"Milk Substitutions"]
[null,16,"OZ","Cheese",{"$f":"(B23/16)*3","v":3},null,null,"Substitution Amt","Package Size","Description",null,null,null,null,16,"OZ","Cheese",{"$f":"(O23/16)*3","v":3}]
[null,32,"OZ","Low Fat or Non Fat Yogurt",{"$f":"B24/32","v":1},null,null,"Milk Substitutions",null,null,null,null,null,null,32,"OZ","Whole Fat/Low Fat Yogurt",{"$f":"O24/32","v":1}]
[null,0,"LB","Tofu",{"$f":"B25","v":0},null,null,16,"OZ","Cheese",{"$f":"(H25/16)*3","v":3},null,null,null,0,"LB","Tofu",{"$f":"O25","v":0}]
[null,0,"QT","Plant-based Beverage",{"$f":"B26","v":0},null,null,32,"OZ","Low Fat or Non Fat Yogurt",{"$f":"H26/32","v":1},null,null,null,"Juice Substitutions"]
[null,0,"QT","2% Milk",{"$f":"B27","v":0},null,null,0,"LB","Tofu",{"$f":"H27","v":0},null,null,null,0,"$$$","Fruit and Vegetable CVB",{"$f":"O27/3","v":0}]
[null,"Juice Substitutions",null,null,null,null,null,0,"QT","Plant-based Beverage",{"$f":"H28","v":0},null,null,null,18,"OZ","Infant Fruits/Vegetables",{"$f":"ROUNDUP(O28/6.25,0)/3","v":1},{"$f":"IF(O28=18, O28+1, 0)","v":19}]
[null,3,"$$$","Fruit and Vegetable CVB",{"$f":"B29","v":3},null,null,0,"QT","2% Milk",{"$f":"H29","v":0},null,null,null,"Eggs Substitutions"]
[null,"Eggs Substitutions",null,null,null,null,null,"Juice Substitutions",null,null,null,null,null,null,0,"LB","Tofu",{"$f":"O30","v":0}]
[null,0,"LB","Tofu",{"$f":"B31","v":0},null,null,0,"$$$","Fruit and Vegetable CVB",{"$f":"H31/3","v":0},null,null,null,0,"JAR","Peanut Butter/Legumes",{"$f":"O31","v":0}]
[null,0,"JAR","Peanut Butter/Legumes",{"$f":"B32","v":0},null,null,18,"OZ","Infant Fruits/Vegetables",{"$f":"ROUNDUP(H32/6.25,0)/3","v":1},{"$f":"IF(H32=18, H32+1, 0)","v":19},null,null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"O32","v":0}]
[null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"B33","v":0},null,null,"Eggs Substitutions",null,null,null,null,null,null,"Peanut Butter/Legumes Substitutions"]
[null,"Peanut Butter/Legumes Substitutions",null,null,null,null,null,0,"LB","Tofu",{"$f":"H34","v":0},null,null,null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"O34","v":0}]
[null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"B35","v":0},null,null,0,"JAR","Peanut Butter/Legumes",{"$f":"H35","v":0},null,null,null,"Cereal Substitutions"]
[null,null,null,null,null,null,null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"H36","v":0},null,null,null,32,"OZ","Infant Cereal",{"$f":"(O36/32)*36","v":36}]
[null,null,null,null,null,null,null,"Peanut Butter/Legumes Substitutions",null,null,null,null,null,null,"Fruits and Vegetable Substitutions"]
[null,null,null,null,null,null,null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"H38","v":0},null,null,null,162,"OZ","Infant Fruits/Vegetables",{"$f":"ROUNDUP(O38/6.25,0)","v":26}]
[null,null,null,null,null,null,null,"Cereal Substitutions"]
[null,null,null,null,null,null,null,32,"OZ","Infant Cereal",{"$f":"(H40/32)*36","v":36}]
[null,null,null,null,null,null,null,"Fruits and Vegetable Substitutions"]
[null,null,null,null,null,null,null,162,"OZ","Infant Fruits/Vegetables",{"$f":"ROUNDUP(H42/6.25,0)","v":26}]
[]
[]
[]
[null,"Note: The order of the food items does not reflect the order in MI-WIC."]

{"sheet":"Food Package V-A","index":11,"n_rows":48,"n_cols":19,"rows_kept":48,"cut":false,"hidden":false,"merged":[[38,7,38,9],[40,7,40,9],[32,7,32,9],[32,14,32,16],[33,1,33,3],[34,14,34,16],[36,7,36,9],[36,14,36,16],[23,7,23,9],[25,14,25,16],[27,1,27,3],[28,14,28,16],[29,1,29,3],[29,7,29,9],[21,1,21,3],[21,14,21,16],[0,1,0,3],[0,7,0,9],[0,14,0,16],[1,7,1,9],[1,14,1,16]]}
[null,"Food Package V-A",null,null,null,null,null,"Food Package V-A (Infant Foods)",null,null,null,null,null,null,"Food Package V-A (Whole Milk/Infant Foods)"]
[null,null,null,null,null,null,null,"Functioning as Food Package III (must have formula assigned)",null,null,null,null,null,null,"Functioning as Food Package III with Whole Milk (Must have formula assigned)"]
[null,"Quantity","Package Size","Description",null,null,null,"Quantity","Package Size","Description",null,null,null,null,"Quantity","Package Size","Description"]
[null,{"$f":"22-SUM(E23:E27)","v":18},"QT","1%, 1/2% or Skim Milk",null,null,null,{"$f":"22-SUM(K25:K29)","v":18},"QT","1%, 1/2% or Skim Milk",null,null,null,null,{"$f":"22-SUM(R23:R25)","v":18},"QT","Whole Milk"]
[null,{"$f":"B26","v":0},"QT","Plant-based Beverage",null,null,null,{"$f":"H28","v":0},"QT","Plant-based Beverage",null,null,null,null,{"$f":"O23","v":16},"OZ","CHEESE ($8.00 MAX PER LB.)"]
[null,{"$f":"B27","v":0},"QT","2% Milk",null,null,null,{"$f":"H29","v":0},"QT","2% Milk",null,null,null,null,{"$f":"O24","v":32},"OZ","Whole Fat or Low Fat Yogurt"]
[null,{"$f":"B23","v":16},"OZ","CHEESE ($8.00 MAX PER LB.)",null,null,null,{"$f":"H25","v":16},"OZ","CHEESE ($8.00 MAX PER LB.)",null,null,null,null,{"$f":"O25+O30","v":0},"LB","TOFU"]
[null,{"$f":"B24","v":32},"OZ","Low Fat or Non Fat Yogurt",null,null,null,{"$f":"H26","v":32},"OZ","Low Fat or Non Fat Yogurt",null,null,null,null,{"$f":"1-R27-R28","v":0},"BTL","Juice 64 oz"]
[null,{"$f":"B25+B31","v":0},"LB","TOFU",null,null,null,{"$f":"H27+H34","v":0},"LB","TOFU",null,null,null,null,{"$f":"36-R36","v":0},"OZ","CEREAL"]
[null,{"$f":"IF(E29=3, 0, 1)","v":0},"BTL","Juice 64 oz",null,null,null,{"$f":"1-K31-K32","v":0},"BTL","Juice 64 oz",null,null,null,null,{"$f":"O36","v":32},"OZ","Infant Cereal"]
[null,36,"OZ","CEREAL",null,null,null,{"$f":"36-K40","v":0},"OZ","CEREAL",null,null,null,null,{"$f":"1-R30-R31-R32","v":1},"DOZ","EGGS"]
[null,{"$f":"1-E31-E32-E33","v":1},"DOZ","EGGS",null,null,null,{"$f":"H40","v":32},"OZ","Infant Cereal",null,null,null,null,{"$f":"47+O27-S38","v":0},"$$$","FRUITS AND VEGETABLES"]
[null,{"$f":"47+E29","v":50},"$$$","FRUITS AND VEGETABLES",null,null,null,{"$f":"1-K34-K35-K36","v":1},"DOZ","EGGS",null,null,null,null,{"$f":"O38+S28","v":312},"OZ","Infant Fruits/Vegetables"]
[null,48,"OZ","WHOLE GRAINS",null,null,null,{"$f":"47+H31-L42","v":0},"$$$","FRUITS AND VEGETABLES",null,null,null,null,48,"OZ","WHOLE GRAINS"]
[null,10,"OZ","FISH",null,null,null,{"$f":"H42+L32","v":312},"OZ","Infant Fruits/Vegetables",null,null,null,null,10,"OZ","FISH"]
[null,{"$f":"2+E32-E35","v":2},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean",null,null,null,48,"OZ","WHOLE GRAINS",null,null,null,null,{"$f":"2+R31-R34","v":2},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean"]
[null,{"$f":"E33+E35","v":0},"JAR","Nut & Seed Butter/Legumes",null,null,null,10,"OZ","FISH",null,null,null,null,{"$f":"R32+R34","v":0},"JAR","Nut & Seed Butter/Legumes"]
[null,"Conditional formatting to \"hide\" substitutions that equal 0.",null,null,null,null,null,{"$f":"2+K35-K38","v":2},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean",null,null,null,null,"Conditional formatting to \"hide\" substitutions that equal 0."]
[null,"Conditional formatting to display food item row with negative qty in red.",null,null,null,null,null,{"$f":"K36+K38","v":0},"JAR","Nut & Seed Butter/Legumes",null,null,null,null,"Conditional formatting to display food item row with negative qty in red."]
[null,"Substitutions",null,null,null,null,null,"Conditional formatting to \"hide\" substitutions that equal 0.",null,null,null,null,null,null,"Substitutions"]
[null,"Substitution Amt","Package Size","Description",null,null,null,"Conditional formatting to display food item row with negative qty in red.",null,null,null,null,null,null,"Substitution Amt","Package Size","Description"]
[null,"Milk Substitutions",null,null,null,null,null,"Substitutions",null,null,null,null,null,null,"Milk Substitutions"]
[null,16,"OZ","Cheese",{"$f":"(B23/16)*3","v":3},null,null,"Substitution Amt","Package Size","Description",null,null,null,null,16,"OZ","Cheese",{"$f":"(O23/16)*3","v":3}]
[null,32,"OZ","Low Fat or Non Fat Yogurt",{"$f":"B24/32","v":1},null,null,"Milk Substitutions",null,null,null,null,null,null,32,"OZ","Whole Fat/Low Fat Yogurt",{"$f":"O24/32","v":1}]
[null,0,"LB","Tofu",{"$f":"B25","v":0},null,null,16,"OZ","Cheese",{"$f":"(H25/16)*3","v":3},null,null,null,0,"LB","Tofu",{"$f":"O25","v":0}]
[null,0,"QT","Plant-based Beverage",{"$f":"B26","v":0},null,null,32,"OZ","Low Fat or Non Fat Yogurt",{"$f":"H26/32","v":1},null,null,null,"Juice Substitutions"]
[null,0,"QT","2% Milk",{"$f":"B27","v":0},null,null,0,"LB","Tofu",{"$f":"H27","v":0},null,null,null,0,"$$$","Fruit and Vegetable CVB",{"$f":"O27/3","v":0}]
[null,"Juice Substitutions",null,null,null,null,null,0,"QT","Plant-based Beverage",{"$f":"H28","v":0},null,null,null,18,"OZ","Infant Fruits/Vegetables",{"$f":"ROUNDUP(O28/6.25,0)/3","v":1},{"$f":"IF(O28=18, O28+1, 0)","v":19}]
[null,3,"$$$","Fruit and Vegetable CVB",{"$f":"B29","v":3},null,null,0,"QT","2% Milk",{"$f":"H29","v":0},null,null,null,"Eggs Substitutions"]
[null,"Eggs Substitutions",null,null,null,null,null,"Juice Substitutions",null,null,null,null,null,null,0,"LB","Tofu",{"$f":"O30","v":0}]
[null,0,"LB","Tofu",{"$f":"B31","v":0},null,null,0,"$$$","Fruit and Vegetable CVB",{"$f":"H31/3","v":0},null,null,null,0,"JAR","Peanut Butter/Legumes",{"$f":"O31","v":0}]
[null,0,"JAR","Peanut Butter/Legumes",{"$f":"B32","v":0},null,null,18,"OZ","Infant Fruits/Vegetables",{"$f":"ROUNDUP(H32/6.25,0)/3","v":1},{"$f":"IF(H32=18, H32+1, 0)","v":19},null,null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"O32","v":0}]
[null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"B33","v":0},null,null,"Eggs Substitutions",null,null,null,null,null,null,"Peanut Butter/Legumes Substitutions"]
[null,"Peanut Butter/Legumes Substitutions",null,null,null,null,null,0,"LB","Tofu",{"$f":"H34","v":0},null,null,null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"O34","v":0}]
[null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"B35","v":0},null,null,0,"JAR","Peanut Butter/Legumes",{"$f":"H35","v":0},null,null,null,"Cereal Substitutions"]
[null,null,null,null,null,null,null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"H36","v":0},null,null,null,32,"OZ","Infant Cereal",{"$f":"(O36/32)*36","v":36}]
[null,null,null,null,null,null,null,"Peanut Butter/Legumes Substitutions",null,null,null,null,null,null,"Fruits and Vegetable Substitutions"]
[null,null,null,null,null,null,null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"H38","v":0},null,null,null,293,"OZ","Infant Fruits/Vegetables",{"$f":"ROUNDUP(O38/6.25,0)","v":47},{"$f":"IF(R38=24,23.5, IF(R38=47,47,0))","v":47}]
[null,null,null,null,null,null,null,"Cereal Substitutions"]
[null,null,null,null,null,null,null,32,"OZ","Infant Cereal",{"$f":"(H40/32)*36","v":36}]
[null,null,null,null,null,null,null,"Fruits and Vegetable Substitutions"]
[null,null,null,null,null,null,null,293,"OZ","Infant Fruits/Vegetables",{"$f":"ROUNDUP(H42/6.25,0)","v":47},{"$f":"IF(K42=24,23.5, IF(K42=47,47,0))","v":47}]
[]
[]
[]
[]
[]
[null,"Note: The order of the food items does not reflect the order in MI-WIC."]

{"sheet":"Food Package V-B","index":12,"n_rows":47,"n_cols":21,"rows_kept":47,"cut":false,"hidden":false,"merged":[[38,7,38,9],[40,7,40,9],[32,7,32,9],[33,1,33,3],[36,7,36,9],[32,15,32,17],[34,15,34,17],[36,15,36,17],[23,7,23,9],[27,1,27,3],[29,1,29,3],[29,7,29,9],[25,15,25,17],[28,15,28,17],[21,1,21,3],[0,1,0,3],[0,7,0,9],[1,7,1,9],[0,15,0,17],[1,15,1,17],[21,15,21,17]]}
[null,"Food Package V-B",null,null,null,null,null,"Food Package V-B (Infant Foods)",null,null,null,null,null,null,null,"Food Package V-B (Whole Milk/Infant Foods)"]
[null,null,null,null,null,null,null,"Functioning as Food Package III (must have formula assigned)",null,null,null,null,null,null,null,"Functioning as Food Package III with Whole Milk (Must have formula assigned)"]
[null,"Quantity","Package Size","Description",null,null,null,"Quantity","Package Size","Description",null,null,null,null,null,"Quantity","Package Size","Description"]
[null,{"$f":"22-SUM(F23:F27)","v":18},"QT","1%, 1/2% or Skim Milk",null,null,null,{"$f":"22-SUM(L25:L29)","v":18},"QT","1%, 1/2% or Skim Milk",null,null,null,null,null,{"$f":"22-SUM(T23:T25)","v":18},"QT","Whole Milk"]
[null,{"$f":"B26","v":0},"QT","Plant-based Beverage",null,null,null,{"$f":"H28","v":0},"QT","Plant-based Beverage",null,null,null,null,null,{"$f":"P23","v":16},"OZ","CHEESE ($8.00 MAX PER LB.)"]
[null,{"$f":"B27","v":0},"QT","2% Milk",null,null,null,{"$f":"H29","v":0},"QT","2% Milk",null,null,null,null,null,{"$f":"P24","v":32},"OZ","Whole Fat or Low Fat Yogurt"]
[null,{"$f":"B23","v":16},"OZ","CHEESE ($8.00 MAX PER LB.)",null,null,null,{"$f":"H25","v":16},"OZ","CHEESE ($8.00 MAX PER LB.)",null,null,null,null,null,{"$f":"P25+P30","v":0},"LB","TOFU"]
[null,{"$f":"B24","v":32},"OZ","Low Fat or Non Fat Yogurt",null,null,null,{"$f":"H26","v":32},"OZ","Low Fat or Non Fat Yogurt",null,null,null,null,null,{"$f":"1-T27-T28","v":0},"BTL","Juice 64 oz"]
[null,{"$f":"B25+B31","v":0},"LB","TOFU",null,null,null,{"$f":"H27+H34","v":0},"LB","TOFU",null,null,null,null,null,{"$f":"36-T36","v":0},"OZ","CEREAL"]
[null,{"$f":"IF(F29=3, 0, 1)","v":0},"BTL","Juice 64 oz",null,null,null,{"$f":"1-L31-L32","v":0},"BTL","Juice 64 oz",null,null,null,null,null,{"$f":"P36","v":32},"OZ","Infant Cereal"]
[null,36,"OZ","CEREAL",null,null,null,{"$f":"36-L40","v":0},"OZ","CEREAL",null,null,null,null,null,{"$f":"1-T30-T31-T32","v":1},"DOZ","EGGS"]
[null,{"$f":"1-F31-F32-F33","v":1},"DOZ","EGGS",null,null,null,{"$f":"H40","v":32},"OZ","Infant Cereal",null,null,null,null,null,{"$f":"52+P27-U38","v":0},"$$$","FRUITS AND VEGETABLES"]
[null,{"$f":"52+F29","v":55},"$$$","FRUITS AND VEGETABLES",null,null,null,{"$f":"1-L34-L35-L36","v":1},"DOZ","EGGS",null,null,null,null,null,{"$f":"S38+U28","v":343},"OZ","Infant Fruits/Vegetables"]
[null,48,"OZ","WHOLE GRAINS",null,null,null,{"$f":"52+H31-M42","v":0},"$$$","FRUITS AND VEGETABLES",null,null,null,null,null,48,"OZ","WHOLE GRAINS"]
[null,15,"OZ","FISH",null,null,null,{"$f":"K42+M32","v":343},"OZ","Infant Fruits/Vegetables",null,null,null,null,null,15,"OZ","FISH"]
[null,{"$f":"2+F32-F35","v":2},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean",null,null,null,48,"OZ","WHOLE GRAINS",null,null,null,null,null,{"$f":"2+T31-T34","v":2},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean"]
[null,{"$f":"F33+F35","v":0},"JAR","Nut & Seed Butter/Legumes",null,null,null,15,"OZ","FISH",null,null,null,null,null,{"$f":"T32+T34","v":0},"JAR","Nut & Seed Butter/Legumes"]
[null,"Conditional formatting to \"hide\" substitutions that equal 0.",null,null,null,null,null,{"$f":"2+L35-L38","v":2},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean",null,null,null,null,null,"Conditional formatting to \"hide\" substitutions that equal 0."]
[null,"Conditional formatting to display food item row with negative qty in red.",null,null,null,null,null,{"$f":"L36+L38","v":0},"JAR","Nut & Seed Butter/Legumes",null,null,null,null,null,"Conditional formatting to display food item row with negative qty in red."]
[null,"Substitutions",null,null,null,null,null,"Conditional formatting to \"hide\" substitutions that equal 0.",null,null,null,null,null,null,null,"Substitutions"]
[null,"Substitution Amt","Package Size","Description",null,null,null,"Conditional formatting to display food item row with negative qty in red.",null,null,null,null,null,null,null,"Substitution Amt","Package Size","Description"]
[null,"Milk Substitutions",null,null,null,null,null,"Substitutions",null,null,null,null,null,null,null,"Milk Substitutions"]
[null,16,"OZ","Cheese",null,{"$f":"(B23/16)*3","v":3},null,"Substitution Amt","Package Size","Description",null,null,null,null,null,16,"OZ","Cheese",null,{"$f":"(P23/16)*3","v":3}]
[null,32,"OZ","Low Fat or Non Fat Yogurt",null,{"$f":"B24/32","v":1},null,"Milk Substitutions",null,null,null,null,null,null,null,32,"OZ","Whole Fat/Low Fat Yogurt",null,{"$f":"P24/32","v":1}]
[null,0,"LB","Tofu",null,{"$f":"B25","v":0},null,16,"OZ","Cheese",null,{"$f":"(H25/16)*3","v":3},null,null,null,0,"LB","Tofu",null,{"$f":"P25","v":0}]
[null,0,"QT","Plant-based Beverage",null,{"$f":"B26","v":0},null,32,"OZ","Low Fat or Non Fat Yogurt",null,{"$f":"H26/32","v":1},null,null,null,"Juice Substitutions"]
[null,0,"QT","2% Milk",null,{"$f":"B27","v":0},null,0,"LB","Tofu",null,{"$f":"H27","v":0},null,null,null,0,"$$$","Fruit and Vegetable CVB",null,{"$f":"P27/3","v":0}]
[null,"Juice Substitutions",null,null,null,null,null,0,"QT","Plant-based Beverage",null,{"$f":"H28","v":0},null,null,null,18,"OZ","Infant Fruits/Vegetables",null,{"$f":"ROUNDUP(P28/6.25,0)/3","v":1},{"$f":"IF(P28=18, P28, 0)","v":18}]
[null,3,"$$$","Fruit and Vegetable CVB",null,{"$f":"B29","v":3},null,0,"QT","2% Milk",null,{"$f":"H29","v":0},null,null,null,"Eggs Substitutions"]
[null,"Eggs Substitutions",null,null,null,null,null,"Juice Substitutions",null,null,null,null,null,null,null,0,"LB","Tofu",null,{"$f":"P30","v":0}]
[null,0,"LB","Tofu",null,{"$f":"B31","v":0},null,0,"$$$","Fruit and Vegetable CVB",null,{"$f":"H31/3","v":0},null,null,null,0,"JAR","Peanut Butter/Legumes",null,{"$f":"P31","v":0}]
[null,0,"JAR","Peanut Butter/Legumes",null,{"$f":"B32","v":0},null,18,"OZ","Infant Fruits/Vegetables",null,{"$f":"ROUNDUP(H32/6.25,0)/3","v":1},{"$f":"IF(H32=18, H32, 0)","v":18},null,null,0,"JAR","Nut or Seed Butter/Legumes",null,{"$f":"P32","v":0}]
[null,0,"JAR","Nut or Seed Butter/Legumes",null,{"$f":"B33","v":0},null,"Eggs Substitutions",null,null,null,null,null,null,null,"Peanut Butter/Legumes Substitutions"]
[null,"Peanut Butter/Legumes Substitutions",null,null,null,null,null,0,"LB","Tofu",null,{"$f":"H34","v":0},null,null,null,0,"JAR","Nut or Seed Butter/Legumes",null,{"$f":"P34","v":0}]
[null,0,"JAR","Nut or Seed Butter/Legumes",null,{"$f":"B35","v":0},null,0,"JAR","Peanut Butter/Legumes",null,{"$f":"H35","v":0},null,null,null,"Cereal Substitutions"]
[null,null,null,null,null,null,null,0,"JAR","Nut or Seed Butter/Legumes",null,{"$f":"H36","v":0},null,null,null,32,"OZ","Infant Cereal",null,{"$f":"(P36/32)*36","v":36}]
[null,null,null,null,null,null,null,"Peanut Butter/Legumes Substitutions",null,null,null,null,null,null,null,"Fruits and Vegetable Substitutions"]
[null,null,null,null,null,null,null,0,"JAR","Nut or Seed Butter/Legumes",null,{"$f":"H38","v":0},null,null,null,325,"OZ","Infant Fruits/Vegetables",{"$f":"IF(P38=325,325, IF(P38=162,163))","v":325},{"$f":"ROUNDUP(P38/6.25,0)","v":52},{"$f":"IF(T38=26,26, IF(T38=52,52,0))","v":52}]
[null,null,null,null,null,null,null,"Cereal Substitutions"]
[null,null,null,null,null,null,null,32,"OZ","Infant Cereal",null,{"$f":"(H40/32)*36","v":36}]
[null,null,null,null,null,null,null,"Fruits and Vegetable Substitutions"]
[null,null,null,null,null,null,null,325,"OZ","Infant Fruits/Vegetables",{"$f":"IF(H42=325,325, IF(H42=162,163))","v":325},{"$f":"ROUNDUP(H42/6.25,0)","v":52},{"$f":"IF(L42=26,26, IF(L42=52,52,0))","v":52}]
[]
[]
[]
[]
[null,"Note: The order of the food items does not reflect the order in MI-WIC."]

{"sheet":"Food Package VI","index":13,"n_rows":47,"n_cols":19,"rows_kept":47,"cut":false,"hidden":false,"merged":[[38,7,38,9],[40,7,40,9],[32,7,32,9],[32,14,32,16],[33,1,33,3],[34,14,34,16],[36,7,36,9],[36,14,36,16],[23,7,23,9],[25,14,25,16],[27,1,27,3],[28,14,28,16],[29,1,29,3],[29,7,29,9],[21,1,21,3],[21,14,21,16],[0,1,0,3],[0,7,0,9],[0,14,0,16],[1,7,1,9],[1,14,1,16]]}
[null,"Food Package VI",null,null,null,null,null,"Food Package VI (Infant Foods)",null,null,null,null,null,null,"Food Package VI (Whole Milk/Infant Foods)"]
[null,null,null,null,null,null,null,"Functioning as Food Package III (must have formula assigned)",null,null,null,null,null,null,"Functioning as Food Package III with Whole Milk (Must have formula assigned)"]
[null,"Quantity","Package Size","Description",null,null,null,"Quantity","Package Size","Description",null,null,null,null,"Quantity","Package Size","Description"]
[null,{"$f":"16-SUM(F23:F27)","v":12},"QT","1%, 1/2% or Skim Milk",null,null,null,{"$f":"16-SUM(K25:K29)","v":12},"QT","1%, 1/2% or Skim Milk",null,null,null,null,{"$f":"16-SUM(R23:R25)","v":12},"QT","Whole Milk"]
[null,{"$f":"B26","v":0},"QT","Plant-based Beverage",null,null,null,{"$f":"H28","v":0},"QT","Plant-based Beverage",null,null,null,null,{"$f":"O23","v":16},"OZ","CHEESE ($8.00 MAX PER LB.)"]
[null,{"$f":"B27","v":0},"QT","2% Milk",null,null,null,{"$f":"H29","v":0},"QT","2% Milk",null,null,null,null,{"$f":"O24","v":32},"OZ","Whole Fat or Low Fat Yogurt"]
[null,{"$f":"B23","v":16},"OZ","CHEESE ($8.00 MAX PER LB.)",null,null,null,{"$f":"H25","v":16},"OZ","CHEESE ($8.00 MAX PER LB.)",null,null,null,null,{"$f":"O25+O30","v":0},"LB","TOFU"]
[null,{"$f":"B24","v":32},"OZ","Low Fat or Non Fat Yogurt",null,null,null,{"$f":"H26","v":32},"OZ","Low Fat or Non Fat Yogurt",null,null,null,null,{"$f":"1-R27-R28","v":0},"BTL","Juice 64 oz"]
[null,{"$f":"B25+B31","v":0},"LB","TOFU",null,null,null,{"$f":"H27+H34","v":0},"LB","TOFU",null,null,null,null,{"$f":"36-R36","v":0},"OZ","CEREAL"]
[null,{"$f":"IF(F29=3, 0, 1)","v":0},"BTL","Juice 64 oz",null,null,null,{"$f":"1-K31-K32","v":0},"BTL","Juice 64 oz",null,null,null,null,{"$f":"O36","v":32},"OZ","Infant Cereal"]
[null,36,"OZ","CEREAL",null,null,null,{"$f":"36-K40","v":0},"OZ","CEREAL",null,null,null,null,{"$f":"1-R30-R31-R32","v":1},"DOZ","EGGS"]
[null,{"$f":"1-F31-F32-F33","v":1},"DOZ","EGGS",null,null,null,{"$f":"H40","v":32},"OZ","Infant Cereal",null,null,null,null,{"$f":"47+O27-S38","v":0},"$$$","FRUITS AND VEGETABLES"]
[null,{"$f":"47+F29","v":50},"$$$","FRUITS AND VEGETABLES",null,null,null,{"$f":"1-K34-K35-K36","v":1},"DOZ","EGGS",null,null,null,null,{"$f":"O38+S28","v":312},"OZ","Infant Fruits/Vegetables"]
[null,48,"OZ","WHOLE GRAINS",null,null,null,{"$f":"47+H31-L42","v":0},"$$$","FRUITS AND VEGETABLES",null,null,null,null,48,"OZ","WHOLE GRAINS"]
[null,10,"OZ","FISH",null,null,null,{"$f":"H42+L32","v":312},"OZ","Infant Fruits/Vegetables",null,null,null,null,10,"OZ","FISH"]
[null,{"$f":"1+F32-F35","v":1},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean",null,null,null,48,"OZ","WHOLE GRAINS",null,null,null,null,{"$f":"1+R31-R34","v":1},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean"]
[null,{"$f":"F33+F35","v":0},"JAR","Nut & Seed Butter/Legumes",null,null,null,10,"OZ","FISH",null,null,null,null,{"$f":"R32+R34","v":0},"JAR","Nut & Seed Butter/Legumes"]
[null,"Conditional formatting to \"hide\" substitutions that equal 0.",null,null,null,null,null,{"$f":"1+K35-K38","v":1},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean",null,null,null,null,"Conditional formatting to \"hide\" substitutions that equal 0."]
[null,"Conditional formatting to display food item row with negative qty in red.",null,null,null,null,null,{"$f":"K36+K38","v":0},"JAR","Nut & Seed Butter/Legumes",null,null,null,null,"Conditional formatting to display food item row with negative qty in red."]
[null,"Substitutions",null,null,null,null,null,"Conditional formatting to \"hide\" substitutions that equal 0.",null,null,null,null,null,null,"Substitutions"]
[null,"Substitution Amt","Package Size","Description",null,null,null,"Conditional formatting to display food item row with negative qty in red.",null,null,null,null,null,null,"Substitution Amt","Package Size","Description"]
[null,"Milk Substitutions",null,null,null,null,null,"Substitutions",null,null,null,null,null,null,"Milk Substitutions"]
[null,16,"OZ","Cheese",null,{"$f":"(B23/16)*3","v":3},null,"Substitution Amt","Package Size","Description",null,null,null,null,16,"OZ","Cheese",{"$f":"(O23/16)*3","v":3}]
[null,32,"OZ","Low Fat or Non Fat Yogurt",null,{"$f":"B24/32","v":1},null,"Milk Substitutions",null,null,null,null,null,null,32,"OZ","Whole Fat/Low Fat Yogurt",{"$f":"O24/32","v":1}]
[null,0,"LB","Tofu",null,{"$f":"B25","v":0},null,16,"OZ","Cheese",{"$f":"(H25/16)*3","v":3},null,null,null,0,"LB","Tofu",{"$f":"O25","v":0}]
[null,0,"QT","Plant-based Beverage",null,{"$f":"B26","v":0},null,32,"OZ","Low Fat or Non Fat Yogurt",{"$f":"H26/32","v":1},null,null,null,"Juice Substitutions"]
[null,0,"QT","2% Milk",null,{"$f":"B27","v":0},null,0,"LB","Tofu",{"$f":"H27","v":0},null,null,null,0,"$$$","Fruit and Vegetable CVB",{"$f":"O27/3","v":0}]
[null,"Juice Substitutions",null,null,null,null,null,0,"QT","Plant-based Beverage",{"$f":"H28","v":0},null,null,null,18,"OZ","Infant Fruits/Vegetables",{"$f":"ROUNDUP(O28/6.25,0)/3","v":1},{"$f":"IF(O28=18, O28+1, 0)","v":19}]
[null,3,"$$$","Fruit and Vegetable CVB",null,{"$f":"B29","v":3},null,0,"QT","2% Milk",{"$f":"H29","v":0},null,null,null,"Eggs Substitutions"]
[null,"Eggs Substitutions",null,null,null,null,null,"Juice Substitutions",null,null,null,null,null,null,0,"LB","Tofu",{"$f":"O30","v":0}]
[null,0,"LB","Tofu",null,{"$f":"B31","v":0},null,0,"$$$","Fruit and Vegetable CVB",{"$f":"H31/3","v":0},null,null,null,0,"JAR","Peanut Butter/Legumes",{"$f":"O31","v":0}]
[null,0,"JAR","Peanut Butter/Legumes",null,{"$f":"B32","v":0},null,18,"OZ","Infant Fruits/Vegetables",{"$f":"ROUNDUP(H32/6.25,0)/3","v":1},{"$f":"IF(H32=18, H32+1, 0)","v":19},null,null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"O32","v":0}]
[null,0,"JAR","Nut or Seed Butter/Legumes",null,{"$f":"B33","v":0},null,"Eggs Substitutions",null,null,null,null,null,null,"Peanut Butter/Legumes Substitutions"]
[null,"Peanut Butter/Legumes Substitutions",null,null,null,null,null,0,"LB","Tofu",{"$f":"H34","v":0},null,null,null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"O34","v":0}]
[null,0,"JAR","Nut or Seed Butter/Legumes",null,{"$f":"B35","v":0},null,0,"JAR","Peanut Butter/Legumes",{"$f":"H35","v":0},null,null,null,"Cereal Substitutions"]
[null,null,null,null,null,null,null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"H36","v":0},null,null,null,32,"OZ","Infant Cereal",{"$f":"(O36/32)*36","v":36}]
[null,null,null,null,null,null,null,"Peanut Butter/Legumes Substitutions",null,null,null,null,null,null,"Fruits and Vegetable Substitutions"]
[null,null,null,null,null,null,null,0,"JAR","Nut or Seed Butter/Legumes",{"$f":"H38","v":0},null,null,null,293,"OZ","Infant Fruits/Vegetables",{"$f":"ROUNDUP(O38/6.25,0)","v":47},{"$f":"IF(R38=24,23.5, IF(R38=47,47,0))","v":47}]
[null,null,null,null,null,null,null,"Cereal Substitutions"]
[null,null,null,null,null,null,null,32,"OZ","Infant Cereal",{"$f":"(H40/32)*36","v":36}]
[null,null,null,null,null,null,null,"Fruits and Vegetable Substitutions"]
[null,null,null,null,null,null,null,293,"OZ","Infant Fruits/Vegetables",{"$f":"ROUNDUP(H42/6.25,0)","v":47},{"$f":"IF(K42=24,23.5, IF(K42=47,47,0))","v":47}]
[]
[]
[]
[]
[null,"Note: The order of the food items does not reflect the order we prefer in MI-WIC."]

{"sheet":"Food Package VII","index":14,"n_rows":48,"n_cols":21,"rows_kept":48,"cut":false,"hidden":false,"merged":[[32,15,32,17],[34,15,34,17],[36,15,36,17],[0,15,0,17],[1,15,1,17],[21,15,21,17],[25,15,25,17],[28,15,28,17],[1,7,1,9],[38,7,38,9],[40,7,40,9],[0,7,0,9],[23,7,23,9],[29,7,29,9],[32,7,32,9],[36,7,36,9],[21,1,21,3],[27,1,27,3],[29,1,29,3],[33,1,33,3],[0,1,0,3]]}
[null,"Food Package VII",null,null,null,null,null,"Food Package VII (Infant Foods)",null,null,null,null,null,null,null,"Food Package VII (Whole Milk/Infant Foods)"]
[null,null,null,null,null,null,null,"Functioning as Food Package III (must have formula assigned)",null,null,null,null,null,null,null,"Functioning as Food Package III with Whole Milk (Must have formula assigned)"]
[null,"Quantity","Package Size","Description",null,null,null,"Quantity","Package Size","Description",null,null,null,null,null,"Quantity","Package Size","Description"]
[null,{"$f":"24-SUM(F23:F27)","v":16},"QT","1%, 1/2% or Skim Milk",null,null,null,{"$f":"24-SUM(L25:L29)","v":16},"QT","1%, 1/2% or Skim Milk",null,null,null,null,null,{"$f":"24-SUM(T23:T25)","v":16},"QT","Whole Milk"]
[null,{"$f":"B26","v":0},"QT","Plant-based Beverage",null,null,null,{"$f":"H28","v":0},"QT","Plant-based Beverage",null,null,null,null,null,{"$f":"P23","v":32},"OZ","CHEESE ($8.00 MAX PER LB.)"]
[null,{"$f":"B27","v":0},"QT","2% Milk",null,null,null,{"$f":"H29","v":0},"QT","2% Milk",null,null,null,null,null,{"$f":"P24","v":64},"OZ","Whole Fat or Low Fat Yogurt"]
[null,{"$f":"B23","v":32},"OZ","CHEESE ($8.00 MAX PER LB.)",null,null,null,{"$f":"H25","v":32},"OZ","CHEESE ($8.00 MAX PER LB.)",null,null,null,null,null,{"$f":"P25+P30","v":0},"LB","TOFU"]
[null,{"$f":"B24","v":64},"OZ","Low Fat or Non Fat Yogurt",null,null,null,{"$f":"H26","v":64},"OZ","Low Fat or Non Fat Yogurt",null,null,null,null,null,{"$f":"1-T27-T28","v":0},"BTL","Juice 64 oz"]
[null,{"$f":"B25+B31","v":0},"LB","TOFU",null,null,null,{"$f":"H27+H34","v":0},"LB","TOFU",null,null,null,null,null,{"$f":"36-T36","v":0},"OZ","CEREAL"]
[null,{"$f":"IF(F29=3, 0, 1)","v":0},"BTL","Juice 64 oz",null,null,null,{"$f":"1-L31-L32","v":0},"BTL","Juice 64 oz",null,null,null,null,null,{"$f":"P36","v":32},"OZ","Infant Cereal"]
[null,36,"OZ","CEREAL",null,null,null,{"$f":"36-L40","v":0},"OZ","CEREAL",null,null,null,null,null,{"$f":"2-T30-T31-T32","v":2},"DOZ","EGGS"]
[null,{"$f":"2-F31-F32-F33","v":2},"DOZ","EGGS",null,null,null,{"$f":"H40","v":32},"OZ","Infant Cereal",null,null,null,null,null,{"$f":"52+P27-U38","v":0},"$$$","FRUITS AND VEGETABLES"]
[null,{"$f":"52+F29","v":55},"$$$","FRUITS AND VEGETABLES",null,null,null,{"$f":"2-L34-L35-L36","v":2},"DOZ","EGGS",null,null,null,null,null,{"$f":"S38+U28","v":343},"OZ","Infant Fruits/Vegetables"]
[null,48,"OZ","WHOLE GRAINS",null,null,null,{"$f":"52+H31-M42","v":0},"$$$","FRUITS AND VEGETABLES",null,null,null,null,null,48,"OZ","WHOLE GRAINS"]
[null,20,"OZ","FISH",null,null,null,{"$f":"K42+M32","v":343},"OZ","Infant Fruits/Vegetables",null,null,null,null,null,20,"OZ","FISH"]
[null,{"$f":"2+F32-F35","v":2},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean",null,null,null,48,"OZ","WHOLE GRAINS",null,null,null,null,null,{"$f":"2+T31-T34","v":2},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean"]
[null,{"$f":"F33+F35","v":0},"JAR","Nut & Seed Butter/Legumes",null,null,null,20,"OZ","FISH",null,null,null,null,null,{"$f":"T32+T34","v":0},"JAR","Nut & Seed Butter/Legumes"]
[null,"Conditional formatting to \"hide\" substitutions that equal 0.",null,null,null,null,null,{"$f":"2+L35-L38","v":2},"JAR","16-18ozPnutBtr,lb Dry,15-16ozCnBean",null,null,null,null,null,"Conditional formatting to \"hide\" substitutions that equal 0."]
[null,"Conditional formatting to display food item row with negative qty in red.",null,null,null,null,null,{"$f":"L36+L38","v":0},"JAR","Nut & Seed Butter/Legumes",null,null,null,null,null,"Conditional formatting to display food item row with negative qty in red."]
[null,"Substitutions",null,null,null,null,null,"Conditional formatting to \"hide\" substitutions that equal 0.",null,null,null,null,null,null,null,"Substitutions"]
[null,"Substitution Amt","Package Size","Description",null,null,null,"Conditional formatting to display food item row with negative qty in red.",null,null,null,null,null,null,null,"Substitution Amt","Package Size","Description"]
[null,"Milk Substitutions",null,null,null,null,null,"Substitutions",null,null,null,null,null,null,null,"Milk Substitutions"]
[null,32,"OZ","Cheese",null,{"$f":"(B23/16)*3","v":6},null,"Substitution Amt","Package Size","Description",null,null,null,null,null,32,"OZ","Cheese",null,{"$f":"(P23/16)*3","v":6}]
[null,64,"OZ","Low Fat or Non Fat Yogurt",null,{"$f":"B24/32","v":2},null,"Milk Substitutions",null,null,null,null,null,null,null,64,"OZ","Whole Fat/Low Fat Yogurt",null,{"$f":"P24/32","v":2}]
[null,0,"LB","Tofu",null,{"$f":"B25","v":0},null,32,"OZ","Cheese",null,{"$f":"(H25/16)*3","v":6},null,null,null,0,"LB","Tofu",null,{"$f":"P25","v":0}]
[null,0,"QT","Plant-based Beverage",null,{"$f":"B26","v":0},null,64,"OZ","Low Fat or Non Fat Yogurt",null,{"$f":"H26/32","v":2},null,null,null,"Juice Substitutions"]
[null,0,"QT","2% Milk",null,{"$f":"B27","v":0},null,0,"LB","Tofu",null,{"$f":"H27","v":0},null,null,null,0,"$$$","Fruit and Vegetable CVB",null,{"$f":"P27/3","v":0}]
[null,"Juice Substitutions",null,null,null,null,null,0,"QT","Plant-based Beverage",null,{"$f":"H28","v":0},null,null,null,18,"OZ","Infant Fruits/Vegetables",null,{"$f":"ROUNDUP(P28/6.25,0)/3","v":1},{"$f":"IF(P28=18, P28, 0)","v":18}]
[null,3,"$$$","Fruit and Vegetable CVB",null,{"$f":"B29","v":3},null,0,"QT","2% Milk",null,{"$f":"H29","v":0},null,null,null,"Eggs Substitutions"]
[null,"Eggs Substitutions",null,null,null,null,null,"Juice Substitutions",null,null,null,null,null,null,null,0,"LB","Tofu",null,{"$f":"P30","v":0}]
[null,0,"LB","Tofu",null,{"$f":"B31","v":0},null,0,"$$$","Fruit and Vegetable CVB",null,{"$f":"H31/3","v":0},null,null,null,0,"JAR","Peanut Butter/Legumes",null,{"$f":"P31","v":0}]
[null,0,"JAR","Peanut Butter/Legumes",null,{"$f":"B32","v":0},null,18,"OZ","Infant Fruits/Vegetables",null,{"$f":"ROUNDUP(H32/6.25,0)/3","v":1},{"$f":"IF(H32=18, H32, 0)","v":18},null,null,0,"JAR","Nut or Seed Butter/Legumes",null,{"$f":"P32","v":0}]
[null,0,"JAR","Nut or Seed Butter/Legumes",null,{"$f":"B33","v":0},null,"Eggs Substitutions",null,null,null,null,null,null,null,"Peanut Butter/Legumes Substitutions"]
[null,"Peanut Butter/Legumes Substitutions",null,null,null,null,null,0,"LB","Tofu",null,{"$f":"H34","v":0},null,null,null,0,"JAR","Nut or Seed Butter/Legumes",null,{"$f":"P34","v":0}]
[null,0,"JAR","Nut or Seed Butter/Legumes",null,{"$f":"B35","v":0},null,0,"JAR","Peanut Butter/Legumes",null,{"$f":"H35","v":0},null,null,null,"Cereal Substitutions"]
[null,null,null,null,null,null,null,0,"JAR","Nut or Seed Butter/Legumes",null,{"$f":"H36","v":0},null,null,null,32,"OZ","Infant Cereal",null,{"$f":"(P36/32)*36","v":36}]
[null,null,null,null,null,null,null,"Peanut Butter/Legumes Substitutions",null,null,null,null,null,null,null,"Fruits and Vegetable Substitutions"]
[null,null,null,null,null,null,null,0,"JAR","Nut or Seed Butter/Legumes",null,{"$f":"H38","v":0},null,null,null,325,"OZ","Infant Fruits/Vegetables",{"$f":"IF(P38=325,325, IF(P38=162,163))","v":325},{"$f":"ROUNDUP(P38/6.25,0)","v":52},{"$f":"IF(T38=26,26, IF(T38=52,52,0))","v":52}]
[null,null,null,null,null,null,null,"Cereal Substitutions"]
[null,null,null,null,null,null,null,32,"OZ","Infant Cereal",null,{"$f":"(H40/32)*36","v":36}]
[null,null,null,null,null,null,null,"Fruits and Vegetable Substitutions"]
[null,null,null,null,null,null,null,325,"OZ","Infant Fruits/Vegetables",{"$f":"IF(H42=325,325, IF(H42=162,163))","v":325},{"$f":"ROUNDUP(H42/6.25,0)","v":52},{"$f":"IF(L42=26,26, IF(L42=52,52,0))","v":52}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"**Applying 1.5x this food package should not result in decimal quantities issued."]
[null,"Note: The order of the food items does not reflect the order we prefer in MI-WIC."]
[null,null,null,null,null,null,null,"**Applying 1.5x this food package should not result in decimal quantities issued."]

{"sheet":"CVB-->Infant F V","index":15,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Food Package Category","CVB Max","CVB: All Substituted for Infant F/V (ounces)","CVB: Half Substituted for Infant F/V (ounces)","CVB + Juice Substitution Max","CVB+Juice: All Substituted for Infant F/V (ounces)","CVB+Juice:Half Substituted for Infant F/V (ounces)"]
["Food Package IV.a.",26,{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB Max]]*6.25, 0)","v":162},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB: All Substituted for Infant F/V (ounces)]]/2,0)","v":81},{"$f":"Table1[[#This Row],[CVB Max]]+3","v":29},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB + Juice Substitution Max]]*6.25, 0)","v":181},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB+Juice: All Substituted for Infant F/V (ounces)]]/2,0)","v":90}]
["Food Package IV.b.",26,{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB Max]]*6.25, 0)","v":162},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB: All Substituted for Infant F/V (ounces)]]/2,0)","v":81},{"$f":"Table1[[#This Row],[CVB Max]]+3","v":29},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB + Juice Substitution Max]]*6.25, 0)","v":181},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB+Juice: All Substituted for Infant F/V (ounces)]]/2,0)","v":90}]
["Food Package V.a.",47,{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB Max]]*6.25, 0)","v":293},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB: All Substituted for Infant F/V (ounces)]]/2,0)","v":146},{"$f":"Table1[[#This Row],[CVB Max]]+3","v":50},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB + Juice Substitution Max]]*6.25, 0)","v":312},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB+Juice: All Substituted for Infant F/V (ounces)]]/2,0)","v":156}]
["Food Package V.b.",52,{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB Max]]*6.25, 0)","v":325},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB: All Substituted for Infant F/V (ounces)]]/2,0)","v":162},{"$f":"Table1[[#This Row],[CVB Max]]+3","v":55},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB + Juice Substitution Max]]*6.25, 0)","v":343},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB+Juice: All Substituted for Infant F/V (ounces)]]/2,0)","v":171}]
["Food Package VI.",47,{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB Max]]*6.25, 0)","v":293},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB: All Substituted for Infant F/V (ounces)]]/2,0)","v":146},{"$f":"Table1[[#This Row],[CVB Max]]+3","v":50},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB + Juice Substitution Max]]*6.25, 0)","v":312},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB+Juice: All Substituted for Infant F/V (ounces)]]/2,0)","v":156}]
["Food Package VII.",52,{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB Max]]*6.25, 0)","v":325},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB: All Substituted for Infant F/V (ounces)]]/2,0)","v":162},{"$f":"Table1[[#This Row],[CVB Max]]+3","v":55},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB + Juice Substitution Max]]*6.25, 0)","v":343},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB+Juice: All Substituted for Infant F/V (ounces)]]/2,0)","v":171}]
["Food Package VII. x1.5",78,{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB Max]]*6.25, 0)","v":487},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB: All Substituted for Infant F/V (ounces)]]/2,0)","v":243},82.5,{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB + Juice Substitution Max]]*6.25, 0)","v":515},{"$f":"ROUNDDOWN(Table1[[#This Row],[CVB+Juice: All Substituted for Infant F/V (ounces)]]/2,0)","v":257}]

{"sheet":"Sheet1","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}