{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["DATA","PIVOT","DATA TEMPLATE","PIVOT TEMPLATE","DP FOOD STORAGE"],"not_rendered":{"charts":60,"images":0,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":30},"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":"DATA","index":0,"n_rows":249,"n_cols":26,"rows_kept":249,"cut":false,"hidden":false,"merged":[[1,25,29,31],[20,1,21,5],[20,7,21,8],[20,9,21,9],[20,11,21,12],[20,13,21,13]]}
[null,null,null,"."]
[null,null,null,null,null,null,null,null,"   WELCOME TO INKYS FOOD STORAGE PLANNER by SCOTTY THE BACKYARD RENEGADE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THANK YOU FOR DOWNLOADING INKYS FOOD STORAGE PLANNER, A LONG OR SHORT TERM PROVISIONS / INVENTORY PLANNER.      TO START, IN THE YELLOW BOXES                                                       ADJUST \"ADULTS SERVED\", \"MONTHS\" AND \"REQUIRED SERVINGS FOR ONE ADULT PER WEEK\" TO ESTABLISH YOUR GOALS.                                                                                                                                                                                                                                                 ON THE LEFT SIDE OF THE TABLE                                                             ENTER YOUR CATERGORY, CLASS, ITEM, PACKAGE SIZE, AND SERVING SIZE. NEW ITEMS WITH EXISING \"CATERGORY\" AND \"CLASS\" WILL BE DISPLAYED IN THE \"OVERVIEW\" AND \"CLASS\" CHARTS. EXPERIENCED USERS MAY ADD A PIVOT CHART FOR A NEW \"CATERGORY\" ON THE \"PIVOT\" SHEET AND COPY TO THE \"DATA\" SHEET. NEXT                                                                                   ENTER AMOUNT OF PACKS \"STORED\" HOW MANY \"SVG/PAK, AND ALLOCATED \"SVG/WK\" FOR EACH ADULT.                                                 IN COLUMN X,                                                                                                     FILL IN \"REQUIRED\" SERVINGS FOR ONE ADULT PER WEEK\". WHEN YOUR ALLOCATION (COLUMN J) IS EQUAL TO OR EXCEEDS YOUR REQUIREMENTS, THE TEXT IN THE \"TOTAL\" ROW WILL TURN FROM RED AND THE BOX WILL TURN GREEN, AS WILL THE \"REQUIRED SERVINGS FOR ONE ADULT PER WEEK\" (COLUMN X)  YOU CAN SEE THE PROGRESS OF EACH ITEM IN COLUMN N - Q AS YOU ADD \"STORED\" PACKS. THE \"TOTAL\" ROW AT THE BOTTOM OF EACH CATERGORY WILL ALSO SHOW SOLID GREEN WHEN YOU HAVE STORED ENGOUH PRODUCT TO MEET YOUR PLAN.                            THIS IS A PROTECTED DATA SHEET / NO PASSWORD                           BEST VIEWED AT 130%                                                                               THANKS FOR DOWNLOADING AND LET ME KNOW WHAT CHANGES  OR UPDATES YOU WOULD LIKE TO SEE!                                              THANKS, SCOTTY. THE BACKYARD RENEGADE."]
[null,null,null,null,null,null,null,"                FOR BEST FULL SCREEN VIEWING SET ZOOM TO 130%  PROTECTED SHEET / NO PASSWORD SET"]
[null,null,"        PLEASE STOP BY ",null,{"$f":"HYPERLINK(\"http://www.backyardrenegade.com/downloads/index.htm\",\"WWW.BACKYARDRENEGADE.COM/DOWNLOADS\")","v":"WWW.BACKYARDRENEGADE.COM/DOWNLOADS"},null,null,null,null,"FOR UPDATES ON THIS AND ALL OF MY OTHER PROJECTS, I EXPECT THIS PROGRAM TO GO THROUGH A LOT OF CHANGES SO STAY IN TOUCH!"]
[null,null,"I AM PREPARING MANY PROJECTS INCLUDING BUT NOT LIMITED TO SILK SCREEN, LEATHER WORK, DESIGN AND BUILD A SMALL FAMILY BOAT, WELDING, AUTO AND MOTOR DIAGNOSTICS AND REPAIR."]
[null,null,"FROM SOFTWARE TO WEBSITES TO BOAT PLANS, I HAVE ALWAYS TRIED TO MAKE SOMETHING AVAILABLE FOR EVERYONE. INKYS FOOD STORAGE PROGRAM IS FREEWARE AND I AM HAPPY TO FREELY PASS IT ALONG…"]
[null,null,"HOWEVER IF YOU WOULD LIKE TO HELP WITH THE BOAT BUILD FUND OR SUPPORT ANY OF MY OTHER ON LINE PROJECTS CHECK OUT THE LINKS OVER THERE.>>>>>>>>>>>>>>>>>>>>>>>>"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"     FILL IN ADULTS SERVED",null,null,null,"           FILL IN MONTHS"]
[null,"V 3_1 2022 0802 1600 COPYRIGHT 2022",null,null,null,null,null,"ADULTS  SERVED",null,4,null,"MONTHS",null,24]
[]
[null,null,"  ENTER CATERGORY, CLASS, DISC, PACKAGE INFO",null,null,null,null,"  STOCK, PACK, SVGS/WK/1",null,null,"      \"REFRESH ALL\" 2 UPDATE CHARTS OR \"AUTO REFRESH\" SEE NOTES.*"]
[null,"LINE","CATERGORY","CLASS","ITEM","PAK","SVG","STORED","SVG/PAK","SVG/WK2","QUOTA","STORED2","DEFICIT","25%","50%","75%","100%",null," "]
[null,1,"BEVERAGES","General","GATORAID PURPLE","8x16oz","1CAN",60,8,3,{"$f":"IFERROR((J25/I25)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":154.28571428571428},{"$f":"IFERROR(H25,0)","v":60},{"$f":"IFERROR(K25-L25,0)","v":94.285714285714278},{"$f":"IFERROR(L25/K25,0)*4","v":1.5555555555555556},{"$f":"IFERROR(L25/K25,0)*2","v":0.77777777777777779},{"$f":"IFERROR(L25/K25,0)*1.34","v":0.52111111111111119},{"$f":"IFERROR(L25/K25,0)","v":0.3888888888888889},null,"   Required servings for one adult per week",null,null,null,null,48]
[null,2,"BEVERAGES","General","GATORAID ORANGE","8x16oz","1CAN",104,8,3,{"$f":"IFERROR((J26/I26)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":154.28571428571428},{"$f":"IFERROR(H26,0)","v":104},{"$f":"IFERROR(K26-L26,0)","v":50.285714285714278},2.6962962962962966,{"$f":"IFERROR(L26/K26,0)*2","v":1.3481481481481483},0.90325925925925943,0.67407407407407416,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X25","v":4608}]
[null,3,"BEVERAGES","General","GATORAID PUNCH","8x16oz","1CAN",78,8,3,154.28571428571428,{"$f":"IFERROR(H27,0)","v":78},76.285714285714278,2.0222222222222221,1.0111111111111111,0.6774444444444444,0.50555555555555554]
[null,4,"BEVERAGES","General","GATORAID FROST","8x16oz","1CAN",16,8,1,51.428571428571423,16,35.428571428571423,1.2444444444444445,0.62222222222222223,0.41688888888888892,0.31111111111111112]
[null,5,"BEVERAGES","General","SODA GINGER","24x12oz","1CAN",17,24,3,51.428571428571423,17,34.428571428571423,1.3222222222222224,0.6611111111111112,0.44294444444444453,0.3305555555555556]
[null,6,"BEVERAGES","General","MUSCLE MILK","2lbs","1SCOOP",10,32,2,25.714285714285712,10,15.714285714285712,1.5555555555555558,0.7777777777777779,0.52111111111111119,0.38888888888888895]
[null,7,"BEVERAGES","General","MJSCLE MILK CHOC","2lbs","1SCOOP",20,32,2,25.714285714285712,20,5.7142857142857117,3.1111111111111116,1.5555555555555558,1.0422222222222224,0.7777777777777779]
[null,8,"BEVERAGES","General","MUSCLE MILK STRAW","1LB","1SCOOP",24,32,5,64.285714285714292,24,40.285714285714292,1.4933333333333332,0.74666666666666659,0.50026666666666664,0.37333333333333329,null,null,null,null,null,null,null,null,"SOCIAL MEDIA AND DOWNLOADS"]
[null,9,"BEVERAGES","General","WATER (FRESH)","5GAL","80Z",24,180,25,57.142857142857153,24,33.142857142857153,1.6799999999999997,0.83999999999999986,0.56279999999999997,0.41999999999999993,null,null,null,null,null,null,null,null,"BACKYARDRENEGADE.COM"]
[null,10,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"TWITCH.TV/BACKYARDRENEGADE"]
[null,11,null,null,null,null,null,0,0,0,{"$f":"IFERROR((J35/I35)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(H35,0)","v":0},{"$f":"IFERROR(K35-L35,0)","v":0},{"$f":"IFERROR(L35/K35,0)*4","v":0},{"$f":"IFERROR(L35/K35,0)*2","v":0},{"$f":"IFERROR(L35/K35,0)*1.34","v":0},{"$f":"IFERROR(L35/K35,0)","v":0},null,null,null,null,null,null,null,null,"YOUTUBE.COM/BACKYARDRENEGADE"]
[null,12,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"http://www.backyardrenegade.com/downloads/index.htm\",\"CLICK HERE FOR UPDATES AND DOWNLOADS\")","v":"CLICK HERE FOR UPDATES AND DOWNLOADS"}]
[null,13,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,14,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"DONATIONS ARE ACCEPTED… :)"]
[null,15,"BEVERAGES",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H25:H38)","v":353},null,{"$f":"SUBTOTAL(109,J25:J38)","v":47},{"$f":"SUM(K25:K38)*1.0001","v":738.64528571428559},{"$f":"SUM(L25:L38)*1.0001","v":353.03530000000001},{"$f":"SUBTOTAL(109,M25:M38)","v":385.57142857142861},1.9117988394584142,0.95589941972920711,0.64045261121856878,0.47794970986460356,null,null,null,null,null,null,null,null,"CASHAPP AT [$BACKYARDRENEGADE]"]
[null,16,null,null,null,null,null,null,null,0,null,null,null," "," ","  "," ",null,null,null,null,null,null,null,null,"VENMO AT [@BACKYARDRENEGADE]"]
[null,17,"BREAD","BAKING","BREAD MIX","1 loaf",5,40,8,2,{"$f":"IFERROR((J41/I41)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":102.85714285714285},{"$f":"IFERROR(H41,0)","v":40},{"$f":"IFERROR(K41-L41,0)","v":62.857142857142847},{"$f":"IFERROR(L41/K41,0)*4","v":1.5555555555555558},{"$f":"IFERROR(L41/K41,0)*2","v":0.7777777777777779},{"$f":"IFERROR(L41/K41,0)*1.34","v":0.52111111111111119},{"$f":"IFERROR(L41/K41,0)","v":0.38888888888888895},null,"   Required servings for one adult per week",null,null,null,null,14,null,"AND THE BOAT BUILDING FUND IS AT:"]
[null,18,"BREAD","DINNER","STICKY RICE","5 lbs","1CAN",90,8,3,{"$f":"IFERROR((J42/I42)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":154.28571428571428},{"$f":"IFERROR(H42,0)","v":90},{"$f":"IFERROR(K42-L42,0)","v":64.285714285714278},2.3333333333333335,1.1666666666666667,0.78166666666666673,0.58333333333333337,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X41","v":1344},null,"STREAMLABS.COM/BACKYARDRENEGADE1"]
[null,19,"BREAD","BAKING","FLOUR","5 lbs","1CAN",50,8,1,51.428571428571423,50,1.4285714285714235,3.8888888888888893,1.9444444444444446,1.302777777777778,0.97222222222222232]
[null,20,"BREAD","SNACKS","POP CORN KERNELS","1 lb","1CAN",24,24,1,17.142857142857142,24,-6.8571428571428577,5.6000000000000005,2.8000000000000003,1.8760000000000003,1.4000000000000001]
[null,21,"BREAD","DINNER","RICE FLOWER","9 CAN","1CAN",40,32,3,38.571428571428569,40,-1.4285714285714306,4.1481481481481488,2.0740740740740744,1.38962962962963,1.0370370370370372]
[null,22,"BREAD","BAKING","YEAST PACKETS","1 PAK","8/pack",8,32,1,12.857142857142856,8,4.8571428571428559,2.4888888888888889,1.2444444444444445,0.83377777777777784,0.62222222222222223]
[null,23,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,24,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,25,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,26,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,27,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,28,null,null,null,null,null,0,0,0,{"$f":"IFERROR((J52/I52)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(H52,0)","v":0},{"$f":"IFERROR(K52-L52,0)","v":0},{"$f":"IFERROR(L52/K52,0)*4","v":0},{"$f":"IFERROR(L52/K52,0)*2","v":0},{"$f":"IFERROR(L52/K52,0)*1.34","v":0},{"$f":"IFERROR(L52/K52,0)","v":0}]
[null,29,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,30,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,31,"BREAD",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H41:H54)","v":252},null,{"$f":"SUBTOTAL(109,J40:J54)","v":11},{"$f":"SUM(K41:K54)*1.0001","v":377.1805714285714},{"$f":"SUM(L41:L54)*1.0001","v":252.02519999999998},{"$f":"SUBTOTAL(109,M41:M54)","v":125.14285714285712},2.6727272727272728,1.3363636363636364,0.89536363636363647,0.66818181818181821]
[null,32,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,33,"CONDIMENTS","DAILY","MAYONAISE","2 CAN",5,30,64,4,{"$f":"IFERROR((J57/I57)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":25.714285714285712},{"$f":"IFERROR(H57,0)","v":30},{"$f":"IFERROR(K57-L57,0)","v":-4.2857142857142883},{"$f":"IFERROR(L57/K57,0)*4","v":4.666666666666667},{"$f":"IFERROR(L57/K57,0)*2","v":2.3333333333333335},{"$f":"IFERROR(L57/K57,0)*1.34","v":1.5633333333333335},{"$f":"IFERROR(L57/K57,0)","v":1.1666666666666667},null,"   Required servings for one adult per week",null,null,null,null,21]
[null,34,"CONDIMENTS","DAILY","KETSUP","3 CAN","1CAN",20,50,3,{"$f":"IFERROR((J58/I58)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":24.685714285714287},{"$f":"IFERROR(H58,0)","v":20},{"$f":"IFERROR(K58-L58,0)","v":4.6857142857142868},3.2407407407407405,1.6203703703703702,1.0856481481481481,0.81018518518518512,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X57","v":2016}]
[null,35,"CONDIMENTS","DAILY","MUSTARD","4 CAN","1CAN",5,100,1,4.1142857142857139,5,-0.88571428571428612,4.8611111111111116,2.4305555555555558,1.6284722222222225,1.2152777777777779]
[null,36,"CONDIMENTS","DAILY","RELISH","5 CAN","1CAN",16,42,2,19.591836734693878,16,3.591836734693878,3.2666666666666666,1.6333333333333333,1.0943333333333334,0.81666666666666665]
[null,37,"CONDIMENTS","DAILY","BLUE CHEESE DRES","9 CAN","1CAN",35,32,2,25.714285714285712,35,-9.2857142857142883,5.4444444444444446,2.7222222222222223,1.8238888888888891,1.3611111111111112]
[null,38,"CONDIMENTS","DAILY","SALT IODIZED","11 CAN","1CAN",24,100,7,28.8,24,4.8000000000000007,3.333333333333333,1.6666666666666665,1.1166666666666667,0.83333333333333326]
[null,39,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,40,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,41,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,42,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,43,null,null,null,null,null,0,0,0,{"$f":"IFERROR((J67/I67)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(H67,0)","v":0},{"$f":"IFERROR(K67-L67,0)","v":0},{"$f":"IFERROR(L67/K67,0)*4","v":0},{"$f":"IFERROR(L67/K67,0)*2","v":0},{"$f":"IFERROR(L67/K67,0)*1.34","v":0},{"$f":"IFERROR(L67/K67,0)","v":0}]
[null,44,null,null,null,null,null,0,0,0,{"$f":"IFERROR((J68/I68)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(H68,0)","v":0},{"$f":"IFERROR(K68-L68,0)","v":0},{"$f":"IFERROR(L68/K68,0)*4","v":0},{"$f":"IFERROR(L68/K68,0)*2","v":0},{"$f":"IFERROR(L68/K68,0)*1.34","v":0},{"$f":"IFERROR(L68/K68,0)","v":0}]
[null,45,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,46,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,47,"CONDIMENTS",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H57:H70)","v":130},null,{"$f":"SUBTOTAL(109,J57:J70)","v":19},{"$f":"SUM(K57:K70)*1.0001","v":128.63327020408161},{"$f":"SUM(L57:L70)*1.0001","v":130.01300000000001},{"$f":"SUBTOTAL(109,M57:M70)","v":-1.3795918367346971},4.0429042904290435,2.0214521452145218,1.3543729372937297,1.0107260726072609]
[null,48,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,49,"DAIRY","BAKING","MILK POWDER","2 CAN",5,10,50,2,{"$f":"IFERROR((J73/I73)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":16.457142857142856},{"$f":"IFERROR(H73,0)","v":10},{"$f":"IFERROR(K73-L73,0)","v":6.4571428571428555},{"$f":"IFERROR(L73/K73,0)*4","v":2.4305555555555558},{"$f":"IFERROR(L73/K73,0)*2","v":1.2152777777777779},{"$f":"IFERROR(L73/K73,0)*1.34","v":0.81423611111111127},{"$f":"IFERROR(L73/K73,0)","v":0.60763888888888895},null,"   Required servings for one adult per week",null,null,null,null,10]
[null,50,"DAIRY","BAKING","CONDENSED MILK","3 CAN","1CAN",48,12,2,{"$f":"IFERROR((J74/I74)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":68.571428571428569},{"$f":"IFERROR(H74,0)","v":48},{"$f":"IFERROR(K74-L74,0)","v":20.571428571428569},2.8000000000000003,1.4000000000000001,0.93800000000000017,0.70000000000000007,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X73","v":960}]
[null,51,"DAIRY","BAKING","SWEET CONDENSED","4 CAN","1CAN",34,12,1,34.285714285714285,34,0.2857142857142847,3.9666666666666668,1.9833333333333334,1.3288333333333335,0.9916666666666667]
[null,52,"DAIRY","COFFEE","BUTTER PECAN SYRUP","5 CAN","1CAN",17,30,7,96,17,79,0.70833333333333337,0.35416666666666669,0.23729166666666671,0.17708333333333334]
[null,53,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,54,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,55,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,56,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,57,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,58,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,59,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,60,null,null,null,null,null,0,0,0,{"$f":"IFERROR((J84/I84)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(H84,0)","v":0},{"$f":"IFERROR(K84-L84,0)","v":0},{"$f":"IFERROR(L84/K84,0)*4","v":0},{"$f":"IFERROR(L84/K84,0)*2","v":0},{"$f":"IFERROR(L84/K84,0)*1.34","v":0},{"$f":"IFERROR(L84/K84,0)","v":0}]
[null,61,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,62,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,63,"DAIRY",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H73:H86)","v":109},null,{"$f":"SUBTOTAL(109,J73:J86)","v":12},{"$f":"SUM(K73:K86)*1.0001","v":215.33581714285714},{"$f":"SUM(L73:L86)*1.0001","v":109.01089999999999},{"$f":"SUBTOTAL(109,M73:M86)","v":106.31428571428572},2.0249469214437368,1.0124734607218684,0.67835721868365184,0.5062367303609342]
[null,64,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,65,"HOME GOODS","Grooming","LAUNDRY DET","2 CAN",5,6,60,1,{"$f":"IFERROR((J89/I89)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":6.8571428571428568},{"$f":"IFERROR(H89,0)","v":6},{"$f":"IFERROR(K89-L89,0)","v":0.85714285714285676},{"$f":"IFERROR(L89/K89,0)*4","v":3.5},{"$f":"IFERROR(L89/K89,0)*2","v":1.75},{"$f":"IFERROR(L89/K89,0)*1.34","v":1.1725000000000001},{"$f":"IFERROR(L89/K89,0)","v":0.875},null,"   Required servings for one adult per week",null,null,null,null,14]
[null,66,"HOME GOODS","Grooming","TOOTH PASTE","3 CAN","1CAN",49,40,7,{"$f":"IFERROR((J90/I90)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":72},{"$f":"IFERROR(H90,0)","v":49},{"$f":"IFERROR(K90-L90,0)","v":23},2.7222222222222223,1.3611111111111112,0.91194444444444456,0.68055555555555558,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X89","v":1344}]
[null,67,"HOME GOODS","Household","DISHWASHER LIQ","4 CAN","1CAN",12,60,2,13.714285714285714,12,1.7142857142857135,3.5,1.75,1.1725000000000001,0.875]
[null,68,"HOME GOODS","Grooming","SHAMPOO","5 CAN","1CAN",14,24,1,17.142857142857142,14,3.1428571428571423,3.2666666666666666,1.6333333333333333,1.0943333333333334,0.81666666666666665]
[null,69,"HOME GOODS","Grooming","SOAP BARS","9 CAN","1CAN",19,24,4,68.571428571428569,19,49.571428571428569,1.1083333333333334,0.5541666666666667,0.37129166666666669,0.27708333333333335]
[null,70,"HOME GOODS","grooming","RAZOR SHAVE","11 CAN","1CAN",19,4,0.25,25.714285714285712,19,6.7142857142857117,2.9555555555555557,1.4777777777777779,0.99011111111111128,0.73888888888888893]
[null,71,"HOME GOODS","grooming","TOILET PAPER","pack","serving",27,16,1,25.714285714285712,27,-1.2857142857142883,4.2,2.1,1.4070000000000003,1.05]
[null,72,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,73,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,74,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,75,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,76,null,null,null,null,null,0,0,0,{"$f":"IFERROR((J100/I100)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(H100,0)","v":0},{"$f":"IFERROR(K100-L100,0)","v":0},{"$f":"IFERROR(L100/K100,0)*4","v":0},{"$f":"IFERROR(L100/K100,0)*2","v":0},{"$f":"IFERROR(L100/K100,0)*1.34","v":0},{"$f":"IFERROR(L100/K100,0)","v":0}]
[null,77,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,78,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,79,"HOME GOODS",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H89:H102)","v":146},null,{"$f":"SUBTOTAL(109,J89:J102)","v":16.25},{"$f":"SUM(K89:K102)*1.0001","v":229.73725714285715},{"$f":"SUM(L89:L102)*1.0001","v":146.0146},{"$f":"SUBTOTAL(109,M89:M102)","v":83.714285714285694},2.5422885572139302,1.2711442786069651,0.85166666666666668,0.63557213930348255]
[null,80,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,81,"PASTA","DINNER","PASTA ","2 CAN",5,86,8,2,{"$f":"IFERROR((J105/I105)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":102.85714285714285},{"$f":"IFERROR(H105,0)","v":86},{"$f":"IFERROR(K105-L105,0)","v":16.857142857142847},{"$f":"IFERROR(L105/K105,0)*4","v":3.3444444444444446},{"$f":"IFERROR(L105/K105,0)*2","v":1.6722222222222223},{"$f":"IFERROR(L105/K105,0)*1.34","v":1.1203888888888891},{"$f":"IFERROR(L105/K105,0)","v":0.83611111111111114},null,"   Required servings for one adult per week",null,null,null,null,15]
[null,82,"PASTA","DINNER","PASTA SAUCE","3 CAN","1CAN",14,25,2,{"$f":"IFERROR((J106/I106)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":32.914285714285711},{"$f":"IFERROR(H106,0)","v":14},{"$f":"IFERROR(K106-L106,0)","v":18.914285714285711},1.7013888888888891,0.85069444444444453,0.56996527777777783,0.42534722222222227,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X105","v":1440}]
[null,83,"PASTA","DINNER","Ramen Noodles, beef","4 CAN","1CAN",14,8,2,102.85714285714285,14,88.857142857142847,0.54444444444444451,0.27222222222222225,0.18238888888888893,0.13611111111111113]
[null,84,"PASTA","DINNER","Ramen Noodles, chicken","5 CAN","1CAN",24,8,1,51.428571428571423,24,27.428571428571423,1.8666666666666669,0.93333333333333346,0.62533333333333341,0.46666666666666673]
[null,85,"PASTA","DINNER","STICKY RICE","5LBS","1CUP",17,60,2,13.714285714285714,17,-3.2857142857142865,4.9583333333333339,2.479166666666667,1.661041666666667,1.2395833333333335]
[null,86,"PASTA","DINNER","Spaghetti and Macaroni","11 CAN","1CAN",23,24,2,34.285714285714285,23,11.285714285714285,2.6833333333333336,1.3416666666666668,0.89891666666666681,0.67083333333333339]
[null,87,"PASTA","DINNER","Spaghetti w/ sauce, canned","PACK","1/2PK",20,24,2,34.285714285714285,20,14.285714285714285,2.3333333333333335,1.1666666666666667,0.78166666666666673,0.58333333333333337]
[null,88,"PASTA","DINNER","Rice, wild","PACK","1/2PK",43,20,2,41.142857142857146,43,-1.8571428571428541,4.1805555555555554,2.0902777777777777,1.4004861111111111,1.0451388888888888]
[null,89,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,90,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,91,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,92,null,null,null,null,null,0,0,0,{"$f":"IFERROR((J116/I116)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(H116,0)","v":0},{"$f":"IFERROR(K116-L116,0)","v":0},{"$f":"IFERROR(L116/K116,0)*4","v":0},{"$f":"IFERROR(L116/K116,0)*2","v":0},{"$f":"IFERROR(L116/K116,0)*1.34","v":0},{"$f":"IFERROR(L116/K116,0)","v":0}]
[null,93,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,94,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,95,"PASTA",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H105:H118)","v":241},null,{"$f":"SUBTOTAL(109,J105:J118)","v":15},{"$f":"SUM(K105:K118)*1.0001","v":413.52706285714282},{"$f":"SUM(L105:L118)*1.0001","v":241.0241},{"$f":"SUBTOTAL(109,M105:M118)","v":172.48571428571424},2.3313985627418465,1.1656992813709233,0.78101851851851867,0.58284964068546163]
[null,96,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,97,"PROTIEN","DINNER","JERKEY","2 CAN",5,16,40,4,{"$f":"IFERROR((J121/I121)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":41.142857142857146},{"$f":"IFERROR(H121,0)","v":16},{"$f":"IFERROR(K121-L121,0)","v":25.142857142857146},{"$f":"IFERROR(L121/K121,0)*4","v":1.5555555555555554},{"$f":"IFERROR(L121/K121,0)*2","v":0.77777777777777768},{"$f":"IFERROR(L121/K121,0)*1.34","v":0.52111111111111108},{"$f":"IFERROR(L121/K121,0)","v":0.38888888888888884},null,"   Required servings for one adult per week",null,null,null,null,9]
[null,98,"PROTIEN","DINNER","CANNED HAM","3 CAN","1CAN",22,8,0.5,{"$f":"IFERROR((J122/I122)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":25.714285714285712},{"$f":"IFERROR(H122,0)","v":22},{"$f":"IFERROR(K122-L122,0)","v":3.7142857142857117},3.4222222222222225,1.7111111111111112,1.1464444444444446,0.85555555555555562,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X121","v":864}]
[null,99,"PROTIEN","DINNER","CANNED TUNA","4 CAN","1CAN",201,2,1,205.71428571428569,201,4.714285714285694,3.9083333333333337,1.9541666666666668,1.309291666666667,0.97708333333333341]
[null,100,"PROTIEN","DINNER","CANNED CHICKEN","5 CAN","1CAN",36,12,1,34.285714285714285,36,-1.7142857142857153,4.2,2.1,1.4070000000000003,1.05]
[null,101,"PROTIEN","DINNER","CANNED BEEF","9 CAN","1CAN",3,12,0.5,17.142857142857142,3,14.142857142857142,0.70000000000000007,0.35000000000000003,0.23450000000000004,0.17500000000000002]
[null,102,"PROTIEN","DINNER","SPAM","11 CAN","1CAN",34,6,0.5,34.285714285714285,34,0.2857142857142847,3.9666666666666668,1.9833333333333334,1.3288333333333335,0.9916666666666667]
[null,103,"PROTIEN","DINNER","DEHYDRAED EGGS","pack","serving",175,1,1,411.42857142857139,175,236.42857142857139,1.7013888888888891,0.85069444444444453,0.56996527777777783,0.42534722222222227]
[null,104,"PROTIEN","DAILY","EGG BEATERS","pack","serving",15,6,0.25,17.142857142857142,15,2.1428571428571423,3.5,1.75,1.1725000000000001,0.875]
[null,105,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,106,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,107,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,108,null,null,null,null,null,0,0,0,{"$f":"IFERROR((J132/I132)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(H132,0)","v":0},{"$f":"IFERROR(K132-L132,0)","v":0},{"$f":"IFERROR(L132/K132,0)*4","v":0},{"$f":"IFERROR(L132/K132,0)*2","v":0},{"$f":"IFERROR(L132/K132,0)*1.34","v":0},{"$f":"IFERROR(L132/K132,0)","v":0}]
[null,109,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,110,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,111,"PROTIEN",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H121:H134)","v":502},null,{"$f":"SUBTOTAL(109,J121:J134)","v":8.75},{"$f":"SUM(K121:K134)*1.0001","v":786.93582857142849},{"$f":"SUM(L121:L134)*1.0001","v":502.05020000000002},{"$f":"SUBTOTAL(109,M121:M134)","v":284.85714285714283},2.5519244734931013,1.2759622367465506,0.85489469862018896,0.63798111837327531]
[null,112,null,null,null,null,null,null,null,0,null,null,null," "," ","  "," "]
[null,113,"SUGARS","BAKING","SUGAR","5LBS",1,3,400,6,{"$f":"IFERROR((J137/I137)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":6.1714285714285717},{"$f":"IFERROR(H137,0)","v":3},{"$f":"IFERROR(K137-L137,0)","v":3.1714285714285717},{"$f":"IFERROR(L137/K137,0)*4","v":1.9444444444444444},{"$f":"IFERROR(L137/K137,0)*2","v":0.97222222222222221},{"$f":"IFERROR(L137/K137,0)*1.34","v":0.65138888888888891},{"$f":"IFERROR(L137/K137,0)","v":0.4861111111111111},null,"   Required servings for one adult per week",null,null,null,null,11]
[null,114,"SUGARS","COFFEE","HONEY","5LBS","1CAN",6,200,7,{"$f":"IFERROR((J138/I138)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":14.4},{"$f":"IFERROR(H138,0)","v":6},{"$f":"IFERROR(K138-L138,0)","v":8.4},{"$f":"IFERROR(L138/K138,0)*4","v":1.6666666666666665},{"$f":"IFERROR(L138/K138,0)*2","v":0.83333333333333326},{"$f":"IFERROR(L138/K138,0)*1.34","v":0.55833333333333335},{"$f":"IFERROR(L138/K138,0)","v":0.41666666666666663},null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X137","v":1056}]
[null,115,"SUGARS","DINNER","BROWN SUGAR","4 CAN","1CAN",16,60,1,6.8571428571428568,16,-9.1428571428571423,9.3333333333333339,4.666666666666667,3.1266666666666669,2.3333333333333335]
[null,116,"SUGARS","DINNER","MAPLE SYRUP","5 CAN","1CAN",14,32,2,25.714285714285712,14,11.714285714285712,2.177777777777778,1.088888888888889,0.72955555555555573,0.54444444444444451]
[null,117,"SUGARS","DINNER","SUGAR LT BRN","1LB","1CUP",7,60,1,6.8571428571428568,7,-0.14285714285714324,4.0833333333333339,2.041666666666667,1.3679166666666669,1.0208333333333335]
[null,118,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,119,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,120,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,121,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,122,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,123,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,124,null,null,null,null,null,0,0,0,{"$f":"IFERROR((J148/I148)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(H148,0)","v":0},{"$f":"IFERROR(K148-L148,0)","v":0},{"$f":"IFERROR(L148/K148,0)*4","v":0},{"$f":"IFERROR(L148/K148,0)*2","v":0},{"$f":"IFERROR(L148/K148,0)*1.34","v":0},{"$f":"IFERROR(L148/K148,0)","v":0}]
[null,125,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,126,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,127,"SUGARS",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H137:H150)","v":46},null,{"$f":"SUBTOTAL(109,J137:J150)","v":17},{"$f":"SUM(K137:K150)*1.0001","v":60.005999999999993},{"$f":"SUM(L137:L150)*1.0001","v":46.004599999999996},{"$f":"SUBTOTAL(109,M137:M150)","v":14},3.0666666666666669,1.5333333333333334,1.0273333333333334,0.76666666666666672]
[null,128,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,129,"SNACKS","MISC","PEANUT BUTTER","2 CAN",5,18,32,4,{"$f":"IFERROR((J153/I153)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":51.428571428571423},{"$f":"IFERROR(H153,0)","v":18},{"$f":"IFERROR(K153-L153,0)","v":33.428571428571423},{"$f":"IFERROR(L153/K153,0)*4","v":1.4000000000000001},{"$f":"IFERROR(L153/K153,0)*2","v":0.70000000000000007},{"$f":"IFERROR(L153/K153,0)*1.34","v":0.46900000000000008},{"$f":"IFERROR(L153/K153,0)","v":0.35000000000000003},null,"   Required servings for one adult per week",null,null,null,null,14]
[null,130,"SNACKS","MISC","ALMONDS","3 CAN","1CAN",5,22,1,{"$f":"IFERROR((J154/I154)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":18.701298701298704},{"$f":"IFERROR(H154,0)","v":5},{"$f":"IFERROR(K154-L154,0)","v":13.701298701298704},{"$f":"IFERROR(L154/K154,0)*4","v":1.0694444444444442},{"$f":"IFERROR(L154/K154,0)*2","v":0.5347222222222221},{"$f":"IFERROR(L154/K154,0)*1.34","v":0.35826388888888883},{"$f":"IFERROR(L154/K154,0)","v":0.26736111111111105},null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X153","v":1344}]
[null,131,"SNACKS","MISC","SCOTT CHIPS","4 CAN","1CAN",56,4,1,102.85714285714285,56,46.857142857142847,2.177777777777778,1.088888888888889,0.72955555555555573,0.54444444444444451]
[null,132,"SNACKS","MISC","JESSI CHIPS","BAG","1/4 BAG",204,4,4,411.42857142857139,204,207.42857142857139,1.9833333333333336,0.99166666666666681,0.66441666666666677,0.4958333333333334]
[null,133,"SNACKS","MISC","SALSA","8JARS","1/8JAR",100,8,2,102.85714285714285,100,2.857142857142847,3.8888888888888893,1.9444444444444446,1.302777777777778,0.97222222222222232]
[null,134,"SNACKS","MISC","CHEESE DIP","CAN","2022-01-08",105,8,2,102.85714285714285,105,-2.142857142857153,4.0833333333333339,2.041666666666667,1.3679166666666669,1.0208333333333335]
[null,135,"SNACKS","MISC","OTHER DIP","CAN",0.125,80,8,2,102.85714285714285,80,22.857142857142847,3.1111111111111116,1.5555555555555558,1.0422222222222224,0.7777777777777779]
[null,136,"SNACKS","MISC","CHOCOLATE","CAN","1BAR",34,16,2,51.428571428571423,34,17.428571428571423,2.6444444444444448,1.3222222222222224,0.88588888888888906,0.6611111111111112]
[null,137,"SNACKS","MISC","WHITE CHOCOLATE","PACK","1BAR",40,16,2,51.428571428571423,40,11.428571428571423,3.1111111111111116,1.5555555555555558,1.0422222222222224,0.7777777777777779]
[null,138,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,139,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,140,null,null,null,null,null,0,0,0,{"$f":"IFERROR((J164/I164)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(H164,0)","v":0},{"$f":"IFERROR(K164-L164,0)","v":0},{"$f":"IFERROR(L164/K164,0)*4","v":0},{"$f":"IFERROR(L164/K164,0)*2","v":0},{"$f":"IFERROR(L164/K164,0)*1.34","v":0},{"$f":"IFERROR(L164/K164,0)","v":0}]
[null,141,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,142,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,143,"SNACKS",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H153:H166)","v":642},null,{"$f":"SUBTOTAL(109,J153:J166)","v":20},{"$f":"SUM(K153:K166)*1.0001","v":995.94374025974037},{"$f":"SUM(L153:L166)*1.0001","v":642.06420000000003},{"$f":"SUBTOTAL(109,M153:M166)","v":353.84415584415575},2.5787167449139279,1.2893583724569639,0.86387010954616594,0.64467918622848197]
[null,144,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,145,"CEREALS","DAILY","BREAKFAST BARS","PACK","BAR",39,32,1,{"$f":"IFERROR((J169/I169)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":12.857142857142856},{"$f":"IFERROR(H169,0)","v":39},{"$f":"IFERROR(K169-L169,0)","v":-26.142857142857146},{"$f":"IFERROR(L169/K169,0)*4","v":12.133333333333335},{"$f":"IFERROR(L169/K169,0)*2","v":6.0666666666666673},{"$f":"IFERROR(L169/K169,0)*1.34","v":4.0646666666666675},{"$f":"IFERROR(L169/K169,0)","v":3.0333333333333337},null,"   Required servings for one adult per week",null,null,null,null,14]
[null,146,"CEREALS","DAILY","CREAM OF WHEAT","PACK","1/2CUP",34,16,1,{"$f":"IFERROR((J170/I170)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":25.714285714285712},{"$f":"IFERROR(H170,0)","v":34},{"$f":"IFERROR(K170-L170,0)","v":-8.2857142857142883},5.2888888888888896,2.6444444444444448,1.7717777777777781,1.3222222222222224,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X169","v":1344}]
[null,147,"CEREALS","DAILY","OATS ROLLED","PACK","1/2 CUP",36,16,1,25.714285714285712,36,-10.285714285714288,5.6000000000000005,2.8000000000000003,1.8760000000000003,1.4000000000000001]
[null,148,"CEREALS","DAILY","JESSI CEREAL","PACK","2CUPS",76,12,2,68.571428571428569,76,-7.4285714285714306,4.4333333333333336,2.2166666666666668,1.4851666666666667,1.1083333333333334]
[null,149,"CEREALS","DAILY","DADS CEREAL","PACK","2cups",57,12,2,68.571428571428569,57,11.571428571428569,3.3250000000000002,1.6625000000000001,1.1138750000000002,0.83125000000000004]
[null,150,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,151,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,152,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,153,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,154,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,155,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,156,null,null,null,null,null,0,0,0,{"$f":"IFERROR((J180/I180)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(H180,0)","v":0},{"$f":"IFERROR(K180-L180,0)","v":0},{"$f":"IFERROR(L180/K180,0)*4","v":0},{"$f":"IFERROR(L180/K180,0)*2","v":0},{"$f":"IFERROR(L180/K180,0)*1.34","v":0},{"$f":"IFERROR(L180/K180,0)","v":0}]
[null,157,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,158,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,159,"CEREALS",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H169:H182)","v":242},null,{"$f":"SUBTOTAL(109,J169:J182)","v":7},{"$f":"SUM(K169:K182)*1.0001","v":201.44871428571423},{"$f":"SUM(L169:L182)*1.0001","v":242.02420000000001},{"$f":"SUBTOTAL(109,M169:M182)","v":-40.571428571428584},4.8056737588652494,2.4028368794326247,1.6099007092198587,1.2014184397163123]
[null,160,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,161,"SOUP","DINNER","SINGLE SERVE DRY","24CANS","1CAN",23,20,0.5,{"$f":"IFERROR((J185/I185)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":10.285714285714286},{"$f":"IFERROR(H185,0)","v":23},{"$f":"IFERROR(K185-L185,0)","v":-12.714285714285714},{"$f":"IFERROR(L185/K185,0)*4","v":8.9444444444444446},{"$f":"IFERROR(L185/K185,0)*2","v":4.4722222222222223},{"$f":"IFERROR(L185/K185,0)*1.34","v":2.9963888888888892},{"$f":"IFERROR(L185/K185,0)","v":2.2361111111111112},null,"   Required servings for one adult per week",null,null,null,null,4]
[null,162,"SOUP","DINNER","BEEF BROTH","24CANS","1CAN",4,60,0.5,{"$f":"IFERROR((J186/I186)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":3.4285714285714284},{"$f":"IFERROR(H186,0)","v":4},{"$f":"IFERROR(K186-L186,0)","v":-0.57142857142857162},4.666666666666667,2.3333333333333335,1.5633333333333335,1.1666666666666667,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X185","v":384}]
[null,163,"SOUP","DINNER","CHICKEN BROTH","24CANS","1CAN",1,40,0.5,5.1428571428571432,1,4.1428571428571432,0.77777777777777768,0.38888888888888884,0.26055555555555554,0.19444444444444442]
[null,164,"SOUP","DINNER","CHICKEN SOUP","24CANS","1CAN",2,24,0.5,8.5714285714285712,2,6.5714285714285712,0.93333333333333335,0.46666666666666667,0.3126666666666667,0.23333333333333334]
[null,165,"SOUP","DINNER","VEG SOUP","24CANS","1CAN",3,24,0.5,8.5714285714285712,3,5.5714285714285712,1.4000000000000001,0.70000000000000007,0.46900000000000008,0.35000000000000003]
[null,166,"SOUP","DINNER","BEEF STEW","24CANS","1CAN",16,4,0.5,51.428571428571423,16,35.428571428571423,1.2444444444444445,0.62222222222222223,0.41688888888888892,0.31111111111111112]
[null,167,"SOUP","DINNER","RAVIOLI","24CANS","1CAN",3,16,0.5,12.857142857142856,3,9.8571428571428559,0.93333333333333346,0.46666666666666673,0.3126666666666667,0.23333333333333336]
[null,168,"SOUP","DINNER","CANNED SPAGHETTI","24CANS","1CAN",14,8,0.5,25.714285714285712,14,11.714285714285712,2.177777777777778,1.088888888888889,0.72955555555555573,0.54444444444444451]
[null,169,"SOUP","DINNER","OTHER","24CANS","1CAN",0,0,0,0,0,0,0,0,0,0]
[null,170,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,171,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,172,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,173,null,null,null,null,null,0,0,0,{"$f":"IFERROR((J197/I197)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(H197,0)","v":0},{"$f":"IFERROR(K197-L197,0)","v":0},{"$f":"IFERROR(L197/K197,0)*4","v":0},{"$f":"IFERROR(L197/K197,0)*2","v":0},{"$f":"IFERROR(L197/K197,0)*1.34","v":0},{"$f":"IFERROR(L197/K197,0)","v":0}]
[null,174,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,175,"SOUP",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H185:H196)","v":66},null,{"$f":"SUBTOTAL(109,J185:J196)","v":4},{"$f":"SUM(K185:K196)*1.0001","v":126.01259999999998},{"$f":"SUM(L185:L196)*1.0001","v":66.006600000000006},{"$f":"SUBTOTAL(109,M185:M196)","v":59.999999999999986},2.0952380952380958,1.0476190476190479,0.70190476190476214,0.52380952380952395]
[null,176,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,177,"VEGGIE","DINNER","MUSHROOMS","BAG",5,8,20,1,{"$f":"IFERROR((J201/I201)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":20.571428571428573},{"$f":"IFERROR(H201,0)","v":8},{"$f":"IFERROR(K201-L201,0)","v":12.571428571428573},{"$f":"IFERROR(L201/K201,0)*4","v":1.5555555555555554},{"$f":"IFERROR(L201/K201,0)*2","v":0.77777777777777768},{"$f":"IFERROR(L201/K201,0)*1.34","v":0.52111111111111108},{"$f":"IFERROR(L201/K201,0)","v":0.38888888888888884},null,"   Required servings for one adult per week",null,null,null,null,10]
[null,178,"VEGGIE","DINNER","INSTANT POTATO","BAG","1CAN",4,60,2,{"$f":"IFERROR((J202/I202)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":13.714285714285714},{"$f":"IFERROR(H202,0)","v":4},{"$f":"IFERROR(K202-L202,0)","v":9.7142857142857135},1.1666666666666667,0.58333333333333337,0.39083333333333337,0.29166666666666669,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X201","v":960}]
[null,179,"VEGGIE","DINNER","CANNED POTATO","CAN","1CAN",4,40,0.5,5.1428571428571432,4,1.1428571428571432,3.1111111111111107,1.5555555555555554,1.0422222222222222,0.77777777777777768]
[null,180,"VEGGIE","DINNER","GREEN BEANS","5 CAN","1CAN",2,24,0.5,8.5714285714285712,2,6.5714285714285712,0.93333333333333335,0.46666666666666667,0.3126666666666667,0.23333333333333334]
[null,167,"VEGGIE","DINNER","CORN","6 CAN","1CAN",3,24,0.5,8.5714285714285712,3,5.5714285714285712,1.4000000000000001,0.70000000000000007,0.46900000000000008,0.35000000000000003]
[null,168,"VEGGIE","DINNER","PEAS","7 CAN","1CAN",16,4,0.5,51.428571428571423,16,35.428571428571423,1.2444444444444445,0.62222222222222223,0.41688888888888892,0.31111111111111112]
[null,183,"VEGGIE","DINNER","BAKED BEANS","8 CAN","serving",32,16,1,25.714285714285712,32,-6.2857142857142883,4.9777777777777779,2.4888888888888889,1.6675555555555557,1.2444444444444445]
[null,184,"VEGGIE","DINNER","GARLIC FRESH","BAG","serving",16,14,4,117.55102040816325,16,101.55102040816325,0.54444444444444451,0.27222222222222225,0.18238888888888893,0.13611111111111113]
[null,185,"VEGGIE","DINNER","POTATO FRESH","5LBS","serving",14,8,2,102.85714285714285,14,88.857142857142847,0.54444444444444451,0.27222222222222225,0.18238888888888893,0.13611111111111113]
[null,186,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,187,null,null,null,null,null,0,0,0,{"$f":"IFERROR((J211/I211)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(H211,0)","v":0},{"$f":"IFERROR(K211-L211,0)","v":0},{"$f":"IFERROR(L211/K211,0)*4","v":0},{"$f":"IFERROR(L211/K211,0)*2","v":0},{"$f":"IFERROR(L211/K211,0)*1.34","v":0},{"$f":"IFERROR(L211/K211,0)","v":0}]
[null,188,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,189,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,190,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,191,"VEGGIE",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H201:H214)","v":99},null,{"$f":"SUBTOTAL(109,J201:J214)","v":12},{"$f":"SUM(K201:K214)*1.0001","v":354.15786122448975},{"$f":"SUM(L201:L214)*1.0001","v":99.009900000000002},{"$f":"SUBTOTAL(109,M201:M214)","v":255.12244897959181},1.1182572614107886,0.55912863070539431,0.3746161825726142,0.27956431535269716]
[null,192,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,193,"FRUIT","SNACKS","APPLE SLICES","PACK","SERVING",56,2,0.5,{"$f":"IFERROR((J217/I217)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":102.85714285714285},{"$f":"IFERROR(H217,0)","v":56},{"$f":"IFERROR(K217-L217,0)","v":46.857142857142847},{"$f":"IFERROR(L217/K217,0)*4","v":2.177777777777778},{"$f":"IFERROR(L217/K217,0)*2","v":1.088888888888889},{"$f":"IFERROR(L217/K217,0)*1.34","v":0.72955555555555573},{"$f":"IFERROR(L217/K217,0)","v":0.54444444444444451},null,"   Required servings for one adult per week",null,null,null,null,14]
[null,194,"FRUIT","SNACKS","APPLESAUCE","PACK","SERVING",24,8,0.5,{"$f":"IFERROR((J218/I218)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":25.714285714285712},{"$f":"IFERROR(H218,0)","v":24},{"$f":"IFERROR(K218-L218,0)","v":1.7142857142857117},3.7333333333333338,1.8666666666666669,1.2506666666666668,0.93333333333333346,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X217","v":1344}]
[null,195,"FRUIT","SNACKS","BLUEBERRIES","PACK","SERVING",40,4,0.5,51.428571428571423,40,11.428571428571423,3.1111111111111116,1.5555555555555558,1.0422222222222224,0.7777777777777779]
[null,196,"FRUIT","SNACKS","CHERRIES","PACK","SERVING",30,4,0.5,51.428571428571423,30,21.428571428571423,2.3333333333333335,1.1666666666666667,0.78166666666666673,0.58333333333333337]
[null,197,"FRUIT","SNACKS","FRUIT SALAD","PACK","SERVING",17,4,0.5,51.428571428571423,17,34.428571428571423,1.3222222222222224,0.6611111111111112,0.44294444444444453,0.3305555555555556]
[null,198,"FRUIT","SNACKS","FRUIT JUICE","PACK","SERVING",167,4,5,514.28571428571433,167,347.28571428571433,1.2988888888888888,0.64944444444444438,0.43512777777777778,0.32472222222222219]
[null,199,"FRUIT","SNACKS","MANDARIN ORANGES","PACK","SERVING",32,2,0.5,102.85714285714285,32,70.857142857142847,1.2444444444444445,0.62222222222222223,0.41688888888888892,0.31111111111111112]
[null,200,"FRUIT","SNACKS","PEACHES","PACK","SERVING",0,0,0,0,0,0,0,0,0,0]
[null,201,"FRUIT","SNACKS","PIE FILLING","PACK","SERVING",0,0,0,0,0,0,0,0,0,0]
[null,167,"FRUIT","SNACKS","PINEAPPLE","PACK","SERVING",0,0,0,0,0,0,0,0,0,0]
[null,168,"FRUIT","SNACKS","STRAWBERRIES","PACK","SERVING",0,0,0,0,0,0,0,0,0,0]
[null,204,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,203.18492224476,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[" ",204.17190092184899,null,null,null,"PACK","SERVING",0,0,0,0,0,0,0,0,0,0]
[" ",205.158879598939,"FRUIT",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H217:H230)","v":366},null,{"$f":"SUBTOTAL(109,J217:J230)","v":8},{"$f":"SUM(K217:K230)*1.0001","v":900.09},{"$f":"SUM(L217:L230)*1.0001","v":366.03660000000002},{"$f":"SUBTOTAL(109,M217:M230)","v":534},1.6266666666666667,0.81333333333333335,0.54493333333333338,0.40666666666666668]
["   ",206.14585827602801,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,207.13283695311699,null,null,null,null,null,0,0,0,{"$f":"IFERROR(J233/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(#REF!*H233,0)","v":0},{"$f":"IFERROR(L233/K233,0)*(SUMPRODUCT(30*$N$21))","v":0},{"$f":"IFERROR(L233/K233,0)*4","v":0},{"$f":"IFERROR(L233/K233,0)*2","v":0},{"$f":"IFERROR(L233/K233,0)*1.34","v":0},{"$f":"IFERROR(L233/K233,0)","v":0},null,"   Required servings for one adult per week"]
[null,207.13283695311699,null,null,null,null,null,0,0,0,{"$f":"IFERROR(J234/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(#REF!*H234,0)","v":0},{"$f":"IFERROR(L234/K234,0)*(SUMPRODUCT(30*$N$21))","v":0},{"$f":"IFERROR(L234/K234,0)*4","v":0},{"$f":"IFERROR(L234/K234,0)*2","v":0},{"$f":"IFERROR(L234/K234,0)*1.34","v":0},{"$f":"IFERROR(L234/K234,0)","v":0},null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X233","v":0}]
[null,208.11981563020399,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H235,0)","v":0},0,0,0,0,0]
[null,209.10679430729499,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H236,0)","v":0},0,0,0,0,0]
[null,210.093772984384,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H237,0)","v":0},0,0,0,0,0]
[null,217.00262372400701,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H238,0)","v":0},0,0,0,0,0]
[null,217.98960240109599,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H239,0)","v":0},0,0,0,0,0]
[null,218.97658107818501,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H240,0)","v":0},0,0,0,0,0]
[null,219.96355975527399,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H241,0)","v":0},0,0,0,0,0]
[null,220.950538432363,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H242,0)","v":0},0,0,0,0,0]
[null,221.93751710945199,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H243,0)","v":0},0,0,0,0,0]
[null,222.924495786541,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H244,0)","v":0},0,0,0,0,0]
[null,223.91147446362999,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H245,0)","v":0},0,0,0,0,0]
[null,224.898453140719,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H246,0)","v":0},0,0,0,0,0]
[null,225.88543181780801,"VEGGIE",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H238:H246)","v":0},null,{"$f":"SUBTOTAL(109,J238:J246)","v":0},{"$f":"SUM(K238:K246)*1.0001","v":0},{"$f":"SUM(L238:L246)*1.0001","v":0},{"$f":"SUBTOTAL(109,M238:M246)","v":0},0,0,0,0]
[null,226.872410494897,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,227.85938917198601]

{"sheet":"PIVOT","index":1,"n_rows":311,"n_cols":8,"rows_kept":311,"cut":false,"hidden":false,"merged":[[17,7,23,13]]}
[]
[null,"HEADER"]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"SNACKS",1991.7878961038962,1284]
[null,"FRUIT",1800.09,732]
[null,"PROTIEN",1573.7929714285713,1004]
[null,"BEVERAGES",1477.216714285714,706]
[null,"PASTA",827.01277714285709,482]
[null,"BREAD",754.32342857142851,504]
[null,"VEGGIE",708.28031020408139,198]
[null,"HOME GOODS",459.45154285714284,292]
[null,"DAIRY",430.65010285714288,218]
[null,"CEREALS",402.87728571428562,484]
[null,"CONDIMENTS",257.25367836734688,260]
[null,"SOUP",252.01259999999996,132]
[null,"SUGARS",120.006,92]
[null,"Grand Total",11054.755307532467,6388]
[null,null,null,null,null,null,null,"PIVOT CHARTS ON DATA TAB ARE COPIED FROM HERE. DATA TAB AND PIVOT TAB ARE COPIED TO TEMPLATES. DO NOT EDIT TEMPLATES. IN CASE OF CORRUPTED FILE, DELETE DATA OR PIVOT TAB AND COPY TEMPLATE TO NEW TAB AND REMOVE \"TEMPLATE\" FROM THE TAB TITLE."]
[]
[]
[]
[]
[]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"DINNER",1895.6081632653058,1060]
[null,"MISC",995.84415584415581,642]
[null,"SNACKS",917.14285714285722,390]
[null,"General",738.57142857142844,353]
[null,"DAILY",347.19183673469388,387]
[null,"BAKING",292.62857142857143,193]
[null,"Grooming",216,134]
[null,"COFFEE",110.4,23]
[null,"Household",13.714285714285714,12]
[null,"Grand Total",5527.1012987012982,3194]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","BEVERAGES"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",738.64528571428559,353]
[null,"GATORAID PUNCH",154.28571428571428,78]
[null,"GATORAID ORANGE",154.28571428571428,104]
[null,"GATORAID PURPLE",154.28571428571428,60]
[null,"MUSCLE MILK STRAW",64.285714285714292,24]
[null,"WATER (FRESH)",57.142857142857153,24]
[null,"SODA GINGER",51.428571428571423,17]
[null,"GATORAID FROST",51.428571428571423,16]
[null,"MJSCLE MILK CHOC",25.714285714285712,20]
[null,"MUSCLE MILK",25.714285714285712,10]
[null,"Grand Total",1477.216714285714,706]
[]
[]
[]
[null,"CATERGORY","BREAD"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",377.1805714285714,252]
[null,"STICKY RICE",154.28571428571428,90]
[null,"BREAD MIX",102.85714285714285,40]
[null,"FLOUR",51.428571428571423,50]
[null,"RICE FLOWER",38.571428571428569,40]
[null,"POP CORN KERNELS",17.142857142857142,24]
[null,"YEAST PACKETS",12.857142857142856,8]
[null,"Grand Total",754.32342857142851,504]
[]
[]
[]
[]
[null,"CATERGORY","CONDIMENTS"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",128.63327020408161,130]
[null,"SALT IODIZED",28.8,24]
[null,"BLUE CHEESE DRES",25.714285714285712,35]
[null,"MAYONAISE",25.714285714285712,30]
[null,"KETSUP",24.685714285714287,20]
[null,"RELISH",19.591836734693878,16]
[null,"MUSTARD",4.1142857142857139,5]
[null,"Grand Total",257.25367836734694,260]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","DAIRY"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",215.33581714285714,109]
[null,"BUTTER PECAN SYRUP",96,17]
[null,"CONDENSED MILK",68.571428571428569,48]
[null,"SWEET CONDENSED",34.285714285714285,34]
[null,"MILK POWDER",16.457142857142856,10]
[null,"Grand Total",430.65010285714283,218]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","HOME GOODS"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",229.73725714285715,146]
[null,"TOOTH PASTE",72,49]
[null,"SOAP BARS",68.571428571428569,19]
[null,"RAZOR SHAVE",25.714285714285712,19]
[null,"TOILET PAPER",25.714285714285712,27]
[null,"SHAMPOO",17.142857142857142,14]
[null,"DISHWASHER LIQ",13.714285714285714,12]
[null,"LAUNDRY DET",6.8571428571428568,6]
[null,"Grand Total",459.45154285714284,292]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","PASTA"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",413.52706285714282,241]
[null,"PASTA ",102.85714285714285,86]
[null,"Ramen Noodles, beef",102.85714285714285,14]
[null,"Ramen Noodles, chicken",51.428571428571423,24]
[null,"Rice, wild",41.142857142857146,43]
[null,"Spaghetti and Macaroni",34.285714285714285,23]
[null,"Spaghetti w/ sauce, canned",34.285714285714285,20]
[null,"PASTA SAUCE",32.914285714285711,14]
[null,"STICKY RICE",13.714285714285714,17]
[null,"Grand Total",827.01277714285709,482]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","SUGARS"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",60.005999999999993,46]
[null,"MAPLE SYRUP",25.714285714285712,14]
[null,"HONEY",14.4,6]
[null,"SUGAR LT BRN",6.8571428571428568,7]
[null,"BROWN SUGAR",6.8571428571428568,16]
[null,"SUGAR",6.1714285714285717,3]
[null,"Grand Total",120.006,92]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","FRUIT"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",900.09,366]
[null,"FRUIT JUICE",514.28571428571433,167]
[null,"APPLE SLICES",102.85714285714285,56]
[null,"MANDARIN ORANGES",102.85714285714285,32]
[null,"BLUEBERRIES",51.428571428571423,40]
[null,"CHERRIES",51.428571428571423,30]
[null,"FRUIT SALAD",51.428571428571423,17]
[null,"APPLESAUCE",25.714285714285712,24]
[null,"PEACHES",0,0]
[null,"STRAWBERRIES",0,0]
[null,"PIE FILLING",0,0]
[null,"PINEAPPLE",0,0]
[null,"Grand Total",1800.0900000000001,732]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","PROTIEN"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",786.93582857142849,502]
[null,"DEHYDRAED EGGS",411.42857142857139,175]
[null,"CANNED TUNA",205.71428571428569,201]
[null,"JERKEY",41.142857142857146,16]
[null,"SPAM",34.285714285714285,34]
[null,"CANNED CHICKEN",34.285714285714285,36]
[null,"CANNED HAM",25.714285714285712,22]
[null,"CANNED BEEF",17.142857142857142,3]
[null,"EGG BEATERS",17.142857142857142,15]
[null,"Grand Total",1573.7929714285713,1004]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","SNACKS"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",995.94374025974037,642]
[null,"JESSI CHIPS",411.42857142857139,204]
[null,"CHEESE DIP",102.85714285714285,105]
[null,"SCOTT CHIPS",102.85714285714285,56]
[null,"SALSA",102.85714285714285,100]
[null,"OTHER DIP",102.85714285714285,80]
[null,"WHITE CHOCOLATE",51.428571428571423,40]
[null,"PEANUT BUTTER",51.428571428571423,18]
[null,"CHOCOLATE",51.428571428571423,34]
[null,"ALMONDS",18.701298701298704,5]
[null,"Grand Total",1991.7878961038962,1284]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","CEREALS"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",201.44871428571423,242]
[null,"DADS CEREAL",68.571428571428569,57]
[null,"JESSI CEREAL",68.571428571428569,76]
[null,"OATS ROLLED",25.714285714285712,36]
[null,"CREAM OF WHEAT",25.714285714285712,34]
[null,"BREAKFAST BARS",12.857142857142856,39]
[null,"Grand Total",402.87728571428568,484]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","SOUP"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",126.01259999999998,66]
[null,"BEEF STEW",51.428571428571423,16]
[null,"CANNED SPAGHETTI",25.714285714285712,14]
[null,"RAVIOLI",12.857142857142856,3]
[null,"SINGLE SERVE DRY",10.285714285714286,23]
[null,"VEG SOUP",8.5714285714285712,3]
[null,"CHICKEN SOUP",8.5714285714285712,2]
[null,"CHICKEN BROTH",5.1428571428571432,1]
[null,"BEEF BROTH",3.4285714285714284,4]
[null,"OTHER",0,0]
[null,"Grand Total",252.01259999999999,132]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","VEGGIE"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",354.15786122448975,99]
[null,"GARLIC FRESH",117.55102040816325,16]
[null,"POTATO FRESH",102.85714285714285,14]
[null,"PEAS",51.428571428571423,16]
[null,"BAKED BEANS",25.714285714285712,32]
[null,"MUSHROOMS",20.571428571428573,8]
[null,"INSTANT POTATO",13.714285714285714,4]
[null,"CORN",8.5714285714285712,3]
[null,"GREEN BEANS",8.5714285714285712,2]
[null,"CANNED POTATO",5.1428571428571432,4]
[null,"Grand Total",708.28031020408162,198]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"END"]

{"sheet":"DATA TEMPLATE","index":2,"n_rows":249,"n_cols":26,"rows_kept":249,"cut":false,"hidden":false,"merged":[[1,25,29,31],[20,1,21,5],[20,7,21,8],[20,9,21,9],[20,11,21,12],[20,13,21,13]]}
[null,null,null,"."]
[null,null,null,null,null,null,null,null,"   WELCOME TO INKYS FOOD STORAGE PLANNER by SCOTTY THE BACKYARD RENEGADE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THANK YOU FOR DOWNLOADING INKYS FOOD STORAGE PLANNER, A LONG OR SHORT TERM PROVISIONS / INVENTORY PLANNER.      TO START, IN THE YELLOW BOXES                                                       ADJUST \"ADULTS SERVED\", \"MONTHS\" AND \"REQUIRED SERVINGS FOR ONE ADULT PER WEEK\" TO ESTABLISH YOUR GOALS.                                                                                                                                                                                                                                                 ON THE LEFT SIDE OF THE TABLE                                                             ENTER YOUR CATERGORY, CLASS, ITEM, PACKAGE SIZE, AND SERVING SIZE. NEW ITEMS WITH EXISING \"CATERGORY\" AND \"CLASS\" WILL BE DISPLAYED IN THE \"OVERVIEW\" AND \"CLASS\" CHARTS. EXPERIENCED USERS MAY ADD A PIVOT CHART FOR A NEW \"CATERGORY\" ON THE \"PIVOT\" SHEET AND COPY TO THE \"DATA\" SHEET. NEXT                                                                                   ENTER AMOUNT OF PACKS \"STORED\" HOW MANY \"SVG/PAK, AND ALLOCATED \"SVG/WK\" FOR EACH ADULT.                                                 IN COLUMN X,                                                                                                     FILL IN \"REQUIRED\" SERVINGS FOR ONE ADULT PER WEEK\". WHEN YOUR ALLOCATION (COLUMN J) IS EQUAL TO OR EXCEEDS YOUR REQUIREMENTS, THE TEXT IN THE \"TOTAL\" ROW WILL TURN FROM RED AND THE BOX WILL TURN GREEN, AS WILL THE \"REQUIRED SERVINGS FOR ONE ADULT PER WEEK\" (COLUMN X)  YOU CAN SEE THE PROGRESS OF EACH ITEM IN COLUMN N - Q AS YOU ADD \"STORED\" PACKS. THE \"TOTAL\" ROW AT THE BOTTOM OF EACH CATERGORY WILL ALSO SHOW SOLID GREEN WHEN YOU HAVE STORED ENGOUH PRODUCT TO MEET YOUR PLAN.                            THIS IS A PROTECTED DATA SHEET / NO PASSWORD                           BEST VIEWED AT 130%                                                                               THANKS FOR DOWNLOADING AND LET ME KNOW WHAT CHANGES  OR UPDATES YOU WOULD LIKE TO SEE!                                              THANKS, SCOTTY. THE BACKYARD RENEGADE."]
[null,null,null,null,null,null,null,"                FOR BEST FULL SCREEN VIEWING SET ZOOM TO 130%  PROTECTED SHEET / NO PASSWORD SET"]
[null,null,"        PLEASE STOP BY ",null,{"$f":"HYPERLINK(\"http://www.backyardrenegade.com/downloads/index.htm\",\"WWW.BACKYARDRENEGADE.COM/DOWNLOADS\")","v":"WWW.BACKYARDRENEGADE.COM/DOWNLOADS"},null,null,null,null,"FOR UPDATES ON THIS AND ALL OF MY OTHER PROJECTS, I EXPECT THIS PROGRAM TO GO THROUGH A LOT OF CHANGES SO STAY IN TOUCH!"]
[null,null,"I AM PREPARING MANY PROJECTS INCLUDING BUT NOT LIMITED TO SILK SCREEN, LEATHER WORK, DESIGN AND BUILD A SMALL FAMILY BOAT, WELDING, AUTO AND MOTOR DIAGNOSTICS AND REPAIR."]
[null,null,"FROM SOFTWARE TO WEBSITES TO BOAT PLANS, I HAVE ALWAYS TRIED TO MAKE SOMETHING AVAILABLE FOR EVERYONE. INKYS FOOD STORAGE PROGRAM IS FREEWARE AND I AM HAPPY TO FREELY PASS IT ALONG…"]
[null,null,"HOWEVER IF YOU WOULD LIKE TO HELP WITH THE BOAT BUILD FUND OR SUPPORT ANY OF MY OTHER ON LINE PROJECTS CHECK OUT THE LINKS OVER THERE.>>>>>>>>>>>>>>>>>>>>>>>>"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"     FILL IN ADULTS SERVED",null,null,null,"           FILL IN MONTHS"]
[null,"V 3_1 2022 0802 1600 COPYRIGHT 2022",null,null,null,null,null,"ADULTS  SERVED",null,4,null,"MONTHS",null,24]
[]
[null,null,"  ENTER CATERGORY, CLASS, DISC, PACKAGE INFO",null,null,null,null,"  STOCK, PACK, SVGS/WK/1",null,null,"      \"REFRESH ALL\" 2 UPDATE CHARTS OR \"AUTO REFRESH\" SEE NOTES.*"]
[null,"LINE","CATERGORY","CLASS","ITEM","PAK","SVG","STORED","SVG/PAK","SVG/WK2","QUOTA","STORED2","DEFICIT","25%","50%","75%","100%",null," "]
[null,1,"BEVERAGES","General","GATORAID PURPLE","8x16oz","1CAN",60,8,3,{"$f":"IFERROR((J25/I25)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":154.28571428571428},{"$f":"IFERROR(H25,0)","v":60},{"$f":"IFERROR(K25-L25,0)","v":94.285714285714278},{"$f":"IFERROR(L25/K25,0)*4","v":1.5555555555555556},{"$f":"IFERROR(L25/K25,0)*2","v":0.77777777777777779},{"$f":"IFERROR(L25/K25,0)*1.34","v":0.52111111111111119},{"$f":"IFERROR(L25/K25,0)","v":0.3888888888888889},null,"   Required servings for one adult per week",null,null,null,null,48]
[null,2,"BEVERAGES","General","GATORAID ORANGE","8x16oz","1CAN",104,8,3,{"$f":"IFERROR((J26/I26)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":154.28571428571428},{"$f":"IFERROR(H26,0)","v":104},{"$f":"IFERROR(K26-L26,0)","v":50.285714285714278},2.6962962962962966,{"$f":"IFERROR(L26/K26,0)*2","v":1.3481481481481483},0.90325925925925943,0.67407407407407416,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X25","v":4608}]
[null,3,"BEVERAGES","General","GATORAID PUNCH","8x16oz","1CAN",78,8,3,154.28571428571428,{"$f":"IFERROR(H27,0)","v":78},76.285714285714278,2.0222222222222221,1.0111111111111111,0.6774444444444444,0.50555555555555554]
[null,4,"BEVERAGES","General","GATORAID FROST","8x16oz","1CAN",16,8,1,51.428571428571423,16,35.428571428571423,1.2444444444444445,0.62222222222222223,0.41688888888888892,0.31111111111111112]
[null,5,"BEVERAGES","General","SODA GINGER","24x12oz","1CAN",17,24,3,51.428571428571423,17,34.428571428571423,1.3222222222222224,0.6611111111111112,0.44294444444444453,0.3305555555555556]
[null,6,"BEVERAGES","General","MUSCLE MILK","2lbs","1SCOOP",10,32,2,25.714285714285712,10,15.714285714285712,1.5555555555555558,0.7777777777777779,0.52111111111111119,0.38888888888888895]
[null,7,"BEVERAGES","General","MJSCLE MILK CHOC","2lbs","1SCOOP",20,32,2,25.714285714285712,20,5.7142857142857117,3.1111111111111116,1.5555555555555558,1.0422222222222224,0.7777777777777779]
[null,8,"BEVERAGES","General","MUSCLE MILK STRAW","1LB","1SCOOP",24,32,5,64.285714285714292,24,40.285714285714292,1.4933333333333332,0.74666666666666659,0.50026666666666664,0.37333333333333329,null,null,null,null,null,null,null,null,"SOCIAL MEDIA AND DOWNLOADS"]
[null,9,"BEVERAGES","General","WATER (FRESH)","5GAL","80Z",24,180,25,57.142857142857153,24,33.142857142857153,1.6799999999999997,0.83999999999999986,0.56279999999999997,0.41999999999999993,null,null,null,null,null,null,null,null,"BACKYARDRENEGADE.COM"]
[null,10,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"TWITCH.TV/BACKYARDRENEGADE"]
[null,11,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"YOUTUBE.COM/BACKYARDRENEGADE"]
[null,12,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"http://www.backyardrenegade.com/downloads/index.htm\",\"CLICK HERE FOR UPDATES AND DOWNLOADS\")","v":"CLICK HERE FOR UPDATES AND DOWNLOADS"}]
[null,13,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,14,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"DONATIONS ARE ACCEPTED… :)"]
[null,15,"BEVERAGES",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H25:H38)","v":353},null,{"$f":"SUBTOTAL(109,J25:J38)","v":47},{"$f":"SUM(K25:K38)*1.0001","v":738.64528571428559},{"$f":"SUM(L25:L38)*1.0001","v":353.03530000000001},{"$f":"SUBTOTAL(109,M25:M38)","v":385.57142857142861},1.9117988394584142,0.95589941972920711,0.64045261121856878,0.47794970986460356,null,null,null,null,null,null,null,null,"CASHAPP AT [$BACKYARDRENEGADE]"]
[null,16,null,null,null,null,null,null,null,0,null,null,null," "," ","  "," ",null,null,null,null,null,null,null,null,"VENMO AT [@BACKYARDRENEGADE]"]
[null,17,"BREAD","BAKING","BREAD MIX","1 loaf",5,40,8,2,{"$f":"IFERROR((J41/I41)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":102.85714285714285},{"$f":"IFERROR(H41,0)","v":40},{"$f":"IFERROR(K41-L41,0)","v":62.857142857142847},{"$f":"IFERROR(L41/K41,0)*4","v":1.5555555555555558},{"$f":"IFERROR(L41/K41,0)*2","v":0.7777777777777779},{"$f":"IFERROR(L41/K41,0)*1.34","v":0.52111111111111119},{"$f":"IFERROR(L41/K41,0)","v":0.38888888888888895},null,"   Required servings for one adult per week",null,null,null,null,14,null,"AND THE BOAT BUILDING FUND IS AT:"]
[null,18,"BREAD","DINNER","STICKY RICE","5 lbs","1CAN",90,8,3,{"$f":"IFERROR((J42/I42)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":154.28571428571428},{"$f":"IFERROR(H42,0)","v":90},{"$f":"IFERROR(K42-L42,0)","v":64.285714285714278},2.3333333333333335,1.1666666666666667,0.78166666666666673,0.58333333333333337,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X41","v":1344},null,"STREAMLABS.COM/BACKYARDRENEGADE1"]
[null,19,"BREAD","BAKING","FLOUR","5 lbs","1CAN",50,8,1,51.428571428571423,50,1.4285714285714235,3.8888888888888893,1.9444444444444446,1.302777777777778,0.97222222222222232]
[null,20,"BREAD","SNACKS","POP CORN KERNELS","1 lb","1CAN",24,24,1,17.142857142857142,24,-6.8571428571428577,5.6000000000000005,2.8000000000000003,1.8760000000000003,1.4000000000000001]
[null,21,"BREAD","DINNER","RICE FLOWER","9 CAN","1CAN",40,32,3,38.571428571428569,40,-1.4285714285714306,4.1481481481481488,2.0740740740740744,1.38962962962963,1.0370370370370372]
[null,22,"BREAD","BAKING","YEAST PACKETS","1 PAK","8/pack",8,32,1,12.857142857142856,8,4.8571428571428559,2.4888888888888889,1.2444444444444445,0.83377777777777784,0.62222222222222223]
[null,23,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,24,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,25,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,26,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,27,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,28,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,29,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,30,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,31,"BREAD",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H41:H54)","v":252},null,{"$f":"SUBTOTAL(109,J40:J54)","v":11},{"$f":"SUM(K41:K54)*1.0001","v":377.1805714285714},{"$f":"SUM(L41:L54)*1.0001","v":252.02519999999998},{"$f":"SUBTOTAL(109,M41:M54)","v":125.14285714285712},2.6727272727272728,1.3363636363636364,0.89536363636363647,0.66818181818181821]
[null,32,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,33,"CONDIMENTS","DAILY","MAYONAISE","2 CAN",5,30,64,4,{"$f":"IFERROR((J57/I57)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":25.714285714285712},{"$f":"IFERROR(H57,0)","v":30},{"$f":"IFERROR(K57-L57,0)","v":-4.2857142857142883},{"$f":"IFERROR(L57/K57,0)*4","v":4.666666666666667},{"$f":"IFERROR(L57/K57,0)*2","v":2.3333333333333335},{"$f":"IFERROR(L57/K57,0)*1.34","v":1.5633333333333335},{"$f":"IFERROR(L57/K57,0)","v":1.1666666666666667},null,"   Required servings for one adult per week",null,null,null,null,21]
[null,34,"CONDIMENTS","DAILY","KETSUP","3 CAN","1CAN",20,50,3,{"$f":"IFERROR((J58/I58)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":24.685714285714287},{"$f":"IFERROR(H58,0)","v":20},{"$f":"IFERROR(K58-L58,0)","v":4.6857142857142868},3.2407407407407405,1.6203703703703702,1.0856481481481481,0.81018518518518512,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X57","v":2016}]
[null,35,"CONDIMENTS","DAILY","MUSTARD","4 CAN","1CAN",5,100,1,4.1142857142857139,5,-0.88571428571428612,4.8611111111111116,2.4305555555555558,1.6284722222222225,1.2152777777777779]
[null,36,"CONDIMENTS","DAILY","RELISH","5 CAN","1CAN",16,42,2,19.591836734693878,16,3.591836734693878,3.2666666666666666,1.6333333333333333,1.0943333333333334,0.81666666666666665]
[null,37,"CONDIMENTS","DAILY","BLUE CHEESE DRES","9 CAN","1CAN",35,32,2,25.714285714285712,35,-9.2857142857142883,5.4444444444444446,2.7222222222222223,1.8238888888888891,1.3611111111111112]
[null,38,"CONDIMENTS","DAILY","SALT IODIZED","11 CAN","1CAN",24,100,7,28.8,24,4.8000000000000007,3.333333333333333,1.6666666666666665,1.1166666666666667,0.83333333333333326]
[null,39,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,40,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,41,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,42,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,43,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,44,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,45,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,46,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,47,"CONDIMENTS",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H57:H70)","v":130},null,{"$f":"SUBTOTAL(109,J57:J70)","v":19},{"$f":"SUM(K57:K70)*1.0001","v":128.63327020408161},{"$f":"SUM(L57:L70)*1.0001","v":130.01300000000001},{"$f":"SUBTOTAL(109,M57:M70)","v":-1.3795918367346971},4.0429042904290435,2.0214521452145218,1.3543729372937297,1.0107260726072609]
[null,48,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,49,"DAIRY","BAKING","MILK POWDER","2 CAN",5,10,50,2,{"$f":"IFERROR((J73/I73)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":16.457142857142856},{"$f":"IFERROR(H73,0)","v":10},{"$f":"IFERROR(K73-L73,0)","v":6.4571428571428555},{"$f":"IFERROR(L73/K73,0)*4","v":2.4305555555555558},{"$f":"IFERROR(L73/K73,0)*2","v":1.2152777777777779},{"$f":"IFERROR(L73/K73,0)*1.34","v":0.81423611111111127},{"$f":"IFERROR(L73/K73,0)","v":0.60763888888888895},null,"   Required servings for one adult per week",null,null,null,null,10]
[null,50,"DAIRY","BAKING","CONDENSED MILK","3 CAN","1CAN",48,12,2,{"$f":"IFERROR((J74/I74)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":68.571428571428569},{"$f":"IFERROR(H74,0)","v":48},{"$f":"IFERROR(K74-L74,0)","v":20.571428571428569},2.8000000000000003,1.4000000000000001,0.93800000000000017,0.70000000000000007,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X73","v":960}]
[null,51,"DAIRY","BAKING","SWEET CONDENSED","4 CAN","1CAN",34,12,1,34.285714285714285,34,0.2857142857142847,3.9666666666666668,1.9833333333333334,1.3288333333333335,0.9916666666666667]
[null,52,"DAIRY","COFFEE","BUTTER PECAN SYRUP","5 CAN","1CAN",17,30,7,96,17,79,0.70833333333333337,0.35416666666666669,0.23729166666666671,0.17708333333333334]
[null,53,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,54,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,55,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,56,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,57,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,58,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,59,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,60,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,61,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,62,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,63,"DAIRY",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H73:H86)","v":109},null,{"$f":"SUBTOTAL(109,J73:J86)","v":12},{"$f":"SUM(K73:K86)*1.0001","v":215.33581714285714},{"$f":"SUM(L73:L86)*1.0001","v":109.01089999999999},{"$f":"SUBTOTAL(109,M73:M86)","v":106.31428571428572},2.0249469214437368,1.0124734607218684,0.67835721868365184,0.5062367303609342]
[null,64,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,65,"HOME GOODS","Grooming","LAUNDRY DET","2 CAN",5,6,60,1,{"$f":"IFERROR((J89/I89)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":6.8571428571428568},{"$f":"IFERROR(H89,0)","v":6},{"$f":"IFERROR(K89-L89,0)","v":0.85714285714285676},{"$f":"IFERROR(L89/K89,0)*4","v":3.5},{"$f":"IFERROR(L89/K89,0)*2","v":1.75},{"$f":"IFERROR(L89/K89,0)*1.34","v":1.1725000000000001},{"$f":"IFERROR(L89/K89,0)","v":0.875},null,"   Required servings for one adult per week",null,null,null,null,14]
[null,66,"HOME GOODS","Grooming","TOOTH PASTE","3 CAN","1CAN",49,40,7,{"$f":"IFERROR((J90/I90)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":72},{"$f":"IFERROR(H90,0)","v":49},{"$f":"IFERROR(K90-L90,0)","v":23},2.7222222222222223,1.3611111111111112,0.91194444444444456,0.68055555555555558,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X89","v":1344}]
[null,67,"HOME GOODS","Household","DISHWASHER LIQ","4 CAN","1CAN",12,60,2,13.714285714285714,12,1.7142857142857135,3.5,1.75,1.1725000000000001,0.875]
[null,68,"HOME GOODS","Grooming","SHAMPOO","5 CAN","1CAN",14,24,1,17.142857142857142,14,3.1428571428571423,3.2666666666666666,1.6333333333333333,1.0943333333333334,0.81666666666666665]
[null,69,"HOME GOODS","Grooming","SOAP BARS","9 CAN","1CAN",19,24,4,68.571428571428569,19,49.571428571428569,1.1083333333333334,0.5541666666666667,0.37129166666666669,0.27708333333333335]
[null,70,"HOME GOODS","grooming","RAZOR SHAVE","11 CAN","1CAN",19,4,0.25,25.714285714285712,19,6.7142857142857117,2.9555555555555557,1.4777777777777779,0.99011111111111128,0.73888888888888893]
[null,71,"HOME GOODS","grooming","TOILET PAPER","pack","serving",27,16,1,25.714285714285712,27,-1.2857142857142883,4.2,2.1,1.4070000000000003,1.05]
[null,72,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,73,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,74,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,75,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,76,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,77,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,78,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,79,"HOME GOODS",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H89:H102)","v":146},null,{"$f":"SUBTOTAL(109,J89:J102)","v":16.25},{"$f":"SUM(K89:K102)*1.0001","v":229.73725714285715},{"$f":"SUM(L89:L102)*1.0001","v":146.0146},{"$f":"SUBTOTAL(109,M89:M102)","v":83.714285714285694},2.5422885572139302,1.2711442786069651,0.85166666666666668,0.63557213930348255]
[null,80,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,81,"PASTA","DINNER","PASTA ","2 CAN",5,86,8,2,{"$f":"IFERROR((J105/I105)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":102.85714285714285},{"$f":"IFERROR(H105,0)","v":86},{"$f":"IFERROR(K105-L105,0)","v":16.857142857142847},{"$f":"IFERROR(L105/K105,0)*4","v":3.3444444444444446},{"$f":"IFERROR(L105/K105,0)*2","v":1.6722222222222223},{"$f":"IFERROR(L105/K105,0)*1.34","v":1.1203888888888891},{"$f":"IFERROR(L105/K105,0)","v":0.83611111111111114},null,"   Required servings for one adult per week",null,null,null,null,15]
[null,82,"PASTA","DINNER","PASTA SAUCE","3 CAN","1CAN",14,25,2,{"$f":"IFERROR((J106/I106)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":32.914285714285711},{"$f":"IFERROR(H106,0)","v":14},{"$f":"IFERROR(K106-L106,0)","v":18.914285714285711},1.7013888888888891,0.85069444444444453,0.56996527777777783,0.42534722222222227,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X105","v":1440}]
[null,83,"PASTA","DINNER","Ramen Noodles, beef","4 CAN","1CAN",14,8,2,102.85714285714285,14,88.857142857142847,0.54444444444444451,0.27222222222222225,0.18238888888888893,0.13611111111111113]
[null,84,"PASTA","DINNER","Ramen Noodles, chicken","5 CAN","1CAN",24,8,1,51.428571428571423,24,27.428571428571423,1.8666666666666669,0.93333333333333346,0.62533333333333341,0.46666666666666673]
[null,85,"PASTA","DINNER","STICKY RICE","5LBS","1CUP",17,60,2,13.714285714285714,17,-3.2857142857142865,4.9583333333333339,2.479166666666667,1.661041666666667,1.2395833333333335]
[null,86,"PASTA","DINNER","Spaghetti and Macaroni","11 CAN","1CAN",23,24,2,34.285714285714285,23,11.285714285714285,2.6833333333333336,1.3416666666666668,0.89891666666666681,0.67083333333333339]
[null,87,"PASTA","DINNER","Spaghetti w/ sauce, canned","PACK","1/2PK",20,24,2,34.285714285714285,20,14.285714285714285,2.3333333333333335,1.1666666666666667,0.78166666666666673,0.58333333333333337]
[null,88,"PASTA","DINNER","Rice, wild","PACK","1/2PK",43,20,2,41.142857142857146,43,-1.8571428571428541,4.1805555555555554,2.0902777777777777,1.4004861111111111,1.0451388888888888]
[null,89,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,90,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,91,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,92,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,93,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,94,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,95,"PASTA",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H105:H118)","v":241},null,{"$f":"SUBTOTAL(109,J105:J118)","v":15},{"$f":"SUM(K105:K118)*1.0001","v":413.52706285714282},{"$f":"SUM(L105:L118)*1.0001","v":241.0241},{"$f":"SUBTOTAL(109,M105:M118)","v":172.48571428571424},2.3313985627418465,1.1656992813709233,0.78101851851851867,0.58284964068546163]
[null,96,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,97,"PROTIEN","DINNER","JERKEY","2 CAN",5,16,40,4,{"$f":"IFERROR((J121/I121)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":41.142857142857146},{"$f":"IFERROR(H121,0)","v":16},{"$f":"IFERROR(K121-L121,0)","v":25.142857142857146},{"$f":"IFERROR(L121/K121,0)*4","v":1.5555555555555554},{"$f":"IFERROR(L121/K121,0)*2","v":0.77777777777777768},{"$f":"IFERROR(L121/K121,0)*1.34","v":0.52111111111111108},{"$f":"IFERROR(L121/K121,0)","v":0.38888888888888884},null,"   Required servings for one adult per week",null,null,null,null,9]
[null,98,"PROTIEN","DINNER","CANNED HAM","3 CAN","1CAN",22,8,0.5,{"$f":"IFERROR((J122/I122)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":25.714285714285712},{"$f":"IFERROR(H122,0)","v":22},{"$f":"IFERROR(K122-L122,0)","v":3.7142857142857117},3.4222222222222225,1.7111111111111112,1.1464444444444446,0.85555555555555562,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X121","v":864}]
[null,99,"PROTIEN","DINNER","CANNED TUNA","4 CAN","1CAN",201,2,1,205.71428571428569,201,4.714285714285694,3.9083333333333337,1.9541666666666668,1.309291666666667,0.97708333333333341]
[null,100,"PROTIEN","DINNER","CANNED CHICKEN","5 CAN","1CAN",36,12,1,34.285714285714285,36,-1.7142857142857153,4.2,2.1,1.4070000000000003,1.05]
[null,101,"PROTIEN","DINNER","CANNED BEEF","9 CAN","1CAN",3,12,0.5,17.142857142857142,3,14.142857142857142,0.70000000000000007,0.35000000000000003,0.23450000000000004,0.17500000000000002]
[null,102,"PROTIEN","DINNER","SPAM","11 CAN","1CAN",34,6,0.5,34.285714285714285,34,0.2857142857142847,3.9666666666666668,1.9833333333333334,1.3288333333333335,0.9916666666666667]
[null,103,"PROTIEN","DINNER","DEHYDRAED EGGS","pack","serving",175,1,1,411.42857142857139,175,236.42857142857139,1.7013888888888891,0.85069444444444453,0.56996527777777783,0.42534722222222227]
[null,104,"PROTIEN","DAILY","EGG BEATERS","pack","serving",15,6,0.25,17.142857142857142,15,2.1428571428571423,3.5,1.75,1.1725000000000001,0.875]
[null,105,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,106,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,107,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,108,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,109,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,110,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,111,"PROTIEN",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H121:H134)","v":502},null,{"$f":"SUBTOTAL(109,J121:J134)","v":8.75},{"$f":"SUM(K121:K134)*1.0001","v":786.93582857142849},{"$f":"SUM(L121:L134)*1.0001","v":502.05020000000002},{"$f":"SUBTOTAL(109,M121:M134)","v":284.85714285714283},2.5519244734931013,1.2759622367465506,0.85489469862018896,0.63798111837327531]
[null,112,null,null,null,null,null,null,null,0,null,null,null," "," ","  "," "]
[null,113,"SUGARS","BAKING","SUGAR","5LBS",1,3,400,6,{"$f":"IFERROR((J137/I137)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":6.1714285714285717},{"$f":"IFERROR(H137,0)","v":3},{"$f":"IFERROR(K137-L137,0)","v":3.1714285714285717},{"$f":"IFERROR(L137/K137,0)*4","v":1.9444444444444444},{"$f":"IFERROR(L137/K137,0)*2","v":0.97222222222222221},{"$f":"IFERROR(L137/K137,0)*1.34","v":0.65138888888888891},{"$f":"IFERROR(L137/K137,0)","v":0.4861111111111111},null,"   Required servings for one adult per week",null,null,null,null,11]
[null,114,"SUGARS","COFFEE","HONEY","5LBS","1CAN",6,200,7,{"$f":"IFERROR((J138/I138)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":14.4},{"$f":"IFERROR(H138,0)","v":6},{"$f":"IFERROR(K138-L138,0)","v":8.4},1.6666666666666665,0.83333333333333326,0.55833333333333335,0.41666666666666663,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X137","v":1056}]
[null,115,"SUGARS","DINNER","BROWN SUGAR","4 CAN","1CAN",16,60,1,6.8571428571428568,16,-9.1428571428571423,9.3333333333333339,4.666666666666667,3.1266666666666669,2.3333333333333335]
[null,116,"SUGARS","DINNER","MAPLE SYRUP","5 CAN","1CAN",14,32,2,25.714285714285712,14,11.714285714285712,2.177777777777778,1.088888888888889,0.72955555555555573,0.54444444444444451]
[null,117,"SUGARS","DINNER","SUGAR LT BRN","1LB","1CUP",7,60,1,6.8571428571428568,7,-0.14285714285714324,4.0833333333333339,2.041666666666667,1.3679166666666669,1.0208333333333335]
[null,118,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,119,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,120,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,121,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,122,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,123,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,124,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,125,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,126,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,127,"SUGARS",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H137:H150)","v":46},null,{"$f":"SUBTOTAL(109,J137:J150)","v":17},{"$f":"SUM(K137:K150)*1.0001","v":60.005999999999993},{"$f":"SUM(L137:L150)*1.0001","v":46.004599999999996},{"$f":"SUBTOTAL(109,M137:M150)","v":14},3.0666666666666669,1.5333333333333334,1.0273333333333334,0.76666666666666672]
[null,128,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,129,"SNACKS","MISC","PEANUT BUTTER","2 CAN",5,18,32,4,{"$f":"IFERROR((J153/I153)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":51.428571428571423},{"$f":"IFERROR(H153,0)","v":18},{"$f":"IFERROR(K153-L153,0)","v":33.428571428571423},{"$f":"IFERROR(L153/K153,0)*4","v":1.4000000000000001},{"$f":"IFERROR(L153/K153,0)*2","v":0.70000000000000007},{"$f":"IFERROR(L153/K153,0)*1.34","v":0.46900000000000008},{"$f":"IFERROR(L153/K153,0)","v":0.35000000000000003},null,"   Required servings for one adult per week",null,null,null,null,14]
[null,130,"SNACKS","MISC","ALMONDS","3 CAN","1CAN",5,22,1,{"$f":"IFERROR((J154/I154)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":18.701298701298704},{"$f":"IFERROR(H154,0)","v":5},{"$f":"IFERROR(K154-L154,0)","v":13.701298701298704},1.0694444444444442,0.5347222222222221,0.35826388888888883,0.26736111111111105,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X153","v":1344}]
[null,131,"SNACKS","MISC","SCOTT CHIPS","4 CAN","1CAN",56,4,1,102.85714285714285,56,46.857142857142847,2.177777777777778,1.088888888888889,0.72955555555555573,0.54444444444444451]
[null,132,"SNACKS","MISC","JESSI CHIPS","BAG","1/4 BAG",204,4,4,411.42857142857139,204,207.42857142857139,1.9833333333333336,0.99166666666666681,0.66441666666666677,0.4958333333333334]
[null,133,"SNACKS","MISC","SALSA","8JARS","1/8JAR",100,8,2,102.85714285714285,100,2.857142857142847,3.8888888888888893,1.9444444444444446,1.302777777777778,0.97222222222222232]
[null,134,"SNACKS","MISC","CHEESE DIP","CAN","2022-01-08",105,8,2,102.85714285714285,105,-2.142857142857153,4.0833333333333339,2.041666666666667,1.3679166666666669,1.0208333333333335]
[null,135,"SNACKS","MISC","OTHER DIP","CAN",0.125,80,8,2,102.85714285714285,80,22.857142857142847,3.1111111111111116,1.5555555555555558,1.0422222222222224,0.7777777777777779]
[null,136,"SNACKS","MISC","CHOCOLATE","CAN","1BAR",34,16,2,51.428571428571423,34,17.428571428571423,2.6444444444444448,1.3222222222222224,0.88588888888888906,0.6611111111111112]
[null,137,"SNACKS","MISC","WHITE CHOCOLATE","PACK","1BAR",40,16,2,51.428571428571423,40,11.428571428571423,3.1111111111111116,1.5555555555555558,1.0422222222222224,0.7777777777777779]
[null,138,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,139,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,140,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,141,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,142,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,143,"SNACKS",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H153:H166)","v":642},null,{"$f":"SUBTOTAL(109,J153:J166)","v":20},{"$f":"SUM(K153:K166)*1.0001","v":995.94374025974037},{"$f":"SUM(L153:L166)*1.0001","v":642.06420000000003},{"$f":"SUBTOTAL(109,M153:M166)","v":353.84415584415575},2.5787167449139279,1.2893583724569639,0.86387010954616594,0.64467918622848197]
[null,144,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,145,"CEREALS","DAILY","BREAKFAST BARS","PACK","BAR",39,32,1,{"$f":"IFERROR((J169/I169)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":12.857142857142856},{"$f":"IFERROR(H169,0)","v":39},{"$f":"IFERROR(K169-L169,0)","v":-26.142857142857146},{"$f":"IFERROR(L169/K169,0)*4","v":12.133333333333335},{"$f":"IFERROR(L169/K169,0)*2","v":6.0666666666666673},{"$f":"IFERROR(L169/K169,0)*1.34","v":4.0646666666666675},{"$f":"IFERROR(L169/K169,0)","v":3.0333333333333337},null,"   Required servings for one adult per week",null,null,null,null,14]
[null,146,"CEREALS","DAILY","CREAM OF WHEAT","PACK","1/2CUP",34,16,1,{"$f":"IFERROR((J170/I170)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":25.714285714285712},{"$f":"IFERROR(H170,0)","v":34},{"$f":"IFERROR(K170-L170,0)","v":-8.2857142857142883},5.2888888888888896,2.6444444444444448,1.7717777777777781,1.3222222222222224,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X169","v":1344}]
[null,147,"CEREALS","DAILY","OATS ROLLED","PACK","1/2 CUP",36,16,1,25.714285714285712,36,-10.285714285714288,5.6000000000000005,2.8000000000000003,1.8760000000000003,1.4000000000000001]
[null,148,"CEREALS","DAILY","JESSI CEREAL","PACK","2CUPS",76,12,2,68.571428571428569,76,-7.4285714285714306,4.4333333333333336,2.2166666666666668,1.4851666666666667,1.1083333333333334]
[null,149,"CEREALS","DAILY","DADS CEREAL","PACK","2cups",57,12,2,68.571428571428569,57,11.571428571428569,3.3250000000000002,1.6625000000000001,1.1138750000000002,0.83125000000000004]
[null,150,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,151,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,152,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,153,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,154,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,155,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,156,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,157,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,158,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,159,"CEREALS",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H169:H182)","v":242},null,{"$f":"SUBTOTAL(109,J169:J182)","v":7},{"$f":"SUM(K169:K182)*1.0001","v":201.44871428571423},{"$f":"SUM(L169:L182)*1.0001","v":242.02420000000001},{"$f":"SUBTOTAL(109,M169:M182)","v":-40.571428571428584},4.8056737588652494,2.4028368794326247,1.6099007092198587,1.2014184397163123]
[null,160,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,161,"SOUP","DINNER","SINGLE SERVE DRY","24CANS","1CAN",23,20,0.5,{"$f":"IFERROR((J185/I185)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":10.285714285714286},{"$f":"IFERROR(H185,0)","v":23},{"$f":"IFERROR(K185-L185,0)","v":-12.714285714285714},{"$f":"IFERROR(L185/K185,0)*4","v":8.9444444444444446},{"$f":"IFERROR(L185/K185,0)*2","v":4.4722222222222223},{"$f":"IFERROR(L185/K185,0)*1.34","v":2.9963888888888892},{"$f":"IFERROR(L185/K185,0)","v":2.2361111111111112},null,"   Required servings for one adult per week",null,null,null,null,4]
[null,162,"SOUP","DINNER","BEEF BROTH","24CANS","1CAN",4,60,0.5,{"$f":"IFERROR((J186/I186)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":3.4285714285714284},{"$f":"IFERROR(H186,0)","v":4},{"$f":"IFERROR(K186-L186,0)","v":-0.57142857142857162},4.666666666666667,2.3333333333333335,1.5633333333333335,1.1666666666666667,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X185","v":384}]
[null,163,"SOUP","DINNER","CHICKEN BROTH","24CANS","1CAN",1,40,0.5,5.1428571428571432,1,4.1428571428571432,0.77777777777777768,0.38888888888888884,0.26055555555555554,0.19444444444444442]
[null,164,"SOUP","DINNER","CHICKEN SOUP","24CANS","1CAN",2,24,0.5,8.5714285714285712,2,6.5714285714285712,0.93333333333333335,0.46666666666666667,0.3126666666666667,0.23333333333333334]
[null,165,"SOUP","DINNER","VEG SOUP","24CANS","1CAN",3,24,0.5,8.5714285714285712,3,5.5714285714285712,1.4000000000000001,0.70000000000000007,0.46900000000000008,0.35000000000000003]
[null,166,"SOUP","DINNER","BEEF STEW","24CANS","1CAN",16,4,0.5,51.428571428571423,16,35.428571428571423,1.2444444444444445,0.62222222222222223,0.41688888888888892,0.31111111111111112]
[null,167,"SOUP","DINNER","RAVIOLI","24CANS","1CAN",3,16,0.5,12.857142857142856,3,9.8571428571428559,0.93333333333333346,0.46666666666666673,0.3126666666666667,0.23333333333333336]
[null,168,"SOUP","DINNER","CANNED SPAGHETTI","24CANS","1CAN",14,8,0.5,25.714285714285712,14,11.714285714285712,2.177777777777778,1.088888888888889,0.72955555555555573,0.54444444444444451]
[null,169,"SOUP","DINNER","OTHER","24CANS","1CAN",0,0,0,0,0,0,0,0,0,0]
[null,170,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,171,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,172,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,173,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,174,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,175,"SOUP",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H185:H196)","v":66},null,{"$f":"SUBTOTAL(109,J185:J196)","v":4},{"$f":"SUM(K185:K196)*1.0001","v":126.01259999999998},{"$f":"SUM(L185:L196)*1.0001","v":66.006600000000006},{"$f":"SUBTOTAL(109,M185:M196)","v":59.999999999999986},2.0952380952380958,1.0476190476190479,0.70190476190476214,0.52380952380952395]
[null,176,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,177,"VEGGIE","DINNER","MUSHROOMS","BAG",5,8,20,1,{"$f":"IFERROR((J201/I201)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":20.571428571428573},{"$f":"IFERROR(H201,0)","v":8},{"$f":"IFERROR(K201-L201,0)","v":12.571428571428573},{"$f":"IFERROR(L201/K201,0)*4","v":1.5555555555555554},{"$f":"IFERROR(L201/K201,0)*2","v":0.77777777777777768},{"$f":"IFERROR(L201/K201,0)*1.34","v":0.52111111111111108},{"$f":"IFERROR(L201/K201,0)","v":0.38888888888888884},null,"   Required servings for one adult per week",null,null,null,null,10]
[null,178,"VEGGIE","DINNER","INSTANT POTATO","BAG","1CAN",4,60,2,{"$f":"IFERROR((J202/I202)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":13.714285714285714},{"$f":"IFERROR(H202,0)","v":4},{"$f":"IFERROR(K202-L202,0)","v":9.7142857142857135},1.1666666666666667,0.58333333333333337,0.39083333333333337,0.29166666666666669,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X201","v":960}]
[null,179,"VEGGIE","DINNER","CANNED POTATO","CAN","1CAN",4,40,0.5,5.1428571428571432,4,1.1428571428571432,3.1111111111111107,1.5555555555555554,1.0422222222222222,0.77777777777777768]
[null,180,"VEGGIE","DINNER","GREEN BEANS","5 CAN","1CAN",2,24,0.5,8.5714285714285712,2,6.5714285714285712,0.93333333333333335,0.46666666666666667,0.3126666666666667,0.23333333333333334]
[null,167,"VEGGIE","DINNER","CORN","6 CAN","1CAN",3,24,0.5,8.5714285714285712,3,5.5714285714285712,1.4000000000000001,0.70000000000000007,0.46900000000000008,0.35000000000000003]
[null,168,"VEGGIE","DINNER","PEAS","7 CAN","1CAN",16,4,0.5,51.428571428571423,16,35.428571428571423,1.2444444444444445,0.62222222222222223,0.41688888888888892,0.31111111111111112]
[null,183,"VEGGIE","DINNER","BAKED BEANS","8 CAN","serving",32,16,1,25.714285714285712,32,-6.2857142857142883,4.9777777777777779,2.4888888888888889,1.6675555555555557,1.2444444444444445]
[null,184,"VEGGIE","DINNER","GARLIC FRESH","BAG","serving",16,14,4,117.55102040816325,16,101.55102040816325,0.54444444444444451,0.27222222222222225,0.18238888888888893,0.13611111111111113]
[null,185,"VEGGIE","DINNER","POTATO FRESH","5LBS","serving",14,8,2,102.85714285714285,14,88.857142857142847,0.54444444444444451,0.27222222222222225,0.18238888888888893,0.13611111111111113]
[null,186,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,187,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,188,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,189,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,190,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,191,"VEGGIE",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H201:H214)","v":99},null,{"$f":"SUBTOTAL(109,J201:J214)","v":12},{"$f":"SUM(K201:K214)*1.0001","v":354.15786122448975},{"$f":"SUM(L201:L214)*1.0001","v":99.009900000000002},{"$f":"SUBTOTAL(109,M201:M214)","v":255.12244897959181},1.1182572614107886,0.55912863070539431,0.3746161825726142,0.27956431535269716]
[null,192,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,193,"FRUIT","SNACKS","APPLE SLICES","PACK","SERVING",56,2,0.5,{"$f":"IFERROR((J217/I217)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":102.85714285714285},{"$f":"IFERROR(H217,0)","v":56},{"$f":"IFERROR(K217-L217,0)","v":46.857142857142847},{"$f":"IFERROR(L217/K217,0)*4","v":2.177777777777778},{"$f":"IFERROR(L217/K217,0)*2","v":1.088888888888889},{"$f":"IFERROR(L217/K217,0)*1.34","v":0.72955555555555573},{"$f":"IFERROR(L217/K217,0)","v":0.54444444444444451},null,"   Required servings for one adult per week",null,null,null,null,14]
[null,194,"FRUIT","SNACKS","APPLESAUCE","PACK","SERVING",24,8,0.5,{"$f":"IFERROR((J218/I218)/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":25.714285714285712},{"$f":"IFERROR(H218,0)","v":24},{"$f":"IFERROR(K218-L218,0)","v":1.7142857142857117},3.7333333333333338,1.8666666666666669,1.2506666666666668,0.93333333333333346,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X217","v":1344}]
[null,195,"FRUIT","SNACKS","BLUEBERRIES","PACK","SERVING",40,4,0.5,51.428571428571423,40,11.428571428571423,3.1111111111111116,1.5555555555555558,1.0422222222222224,0.7777777777777779]
[null,196,"FRUIT","SNACKS","CHERRIES","PACK","SERVING",30,4,0.5,51.428571428571423,30,21.428571428571423,2.3333333333333335,1.1666666666666667,0.78166666666666673,0.58333333333333337]
[null,197,"FRUIT","SNACKS","FRUIT SALAD","PACK","SERVING",17,4,0.5,51.428571428571423,17,34.428571428571423,1.3222222222222224,0.6611111111111112,0.44294444444444453,0.3305555555555556]
[null,198,"FRUIT","SNACKS","FRUIT JUICE","PACK","SERVING",167,4,5,514.28571428571433,167,347.28571428571433,1.2988888888888888,0.64944444444444438,0.43512777777777778,0.32472222222222219]
[null,199,"FRUIT","SNACKS","MANDARIN ORANGES","PACK","SERVING",32,2,0.5,102.85714285714285,32,70.857142857142847,1.2444444444444445,0.62222222222222223,0.41688888888888892,0.31111111111111112]
[null,200,"FRUIT","SNACKS","PEACHES","PACK","SERVING",0,0,0,0,0,0,0,0,0,0]
[null,201,"FRUIT","SNACKS","PIE FILLING","PACK","SERVING",0,0,0,0,0,0,0,0,0,0]
[null,167,"FRUIT","SNACKS","PINEAPPLE","PACK","SERVING",0,0,0,0,0,0,0,0,0,0]
[null,168,"FRUIT","SNACKS","STRAWBERRIES","PACK","SERVING",0,0,0,0,0,0,0,0,0,0]
[null,204,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,203.18492224476,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[" ",204.17190092184899,null,null,null,"PACK","SERVING",0,0,0,0,0,0,0,0,0,0]
[" ",205.158879598939,"FRUIT",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H217:H230)","v":366},null,{"$f":"SUBTOTAL(109,J217:J230)","v":8},{"$f":"SUM(K217:K230)*1.0001","v":900.09},{"$f":"SUM(L217:L230)*1.0001","v":366.03660000000002},{"$f":"SUBTOTAL(109,M217:M230)","v":534},1.6266666666666667,0.81333333333333335,0.54493333333333338,0.40666666666666668]
["   ",206.14585827602801,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,207.13283695311699,null,null,null,null,null,0,0,0,{"$f":"IFERROR(J233/7,0)*(SUMPRODUCT($N$21*30))*$J$21","v":0},{"$f":"IFERROR(#REF!*H233,0)","v":0},{"$f":"IFERROR(L233/K233,0)*(SUMPRODUCT(30*$N$21))","v":0},{"$f":"IFERROR(L233/K233,0)*4","v":0},{"$f":"IFERROR(L233/K233,0)*2","v":0},{"$f":"IFERROR(L233/K233,0)*1.34","v":0},{"$f":"IFERROR(L233/K233,0)","v":0},null,"   Required servings for one adult per week"]
[null,207.13283695311699,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H234,0)","v":0},0,0,0,0,0,null,"   Total servings to meet plans goal",null,null,null,null,{"$f":"IFERROR($J$21*$N$21,0)*X233","v":0}]
[null,208.11981563020399,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H235,0)","v":0},0,0,0,0,0]
[null,209.10679430729499,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H236,0)","v":0},0,0,0,0,0]
[null,210.093772984384,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H237,0)","v":0},0,0,0,0,0]
[null,217.00262372400701,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H238,0)","v":0},0,0,0,0,0]
[null,217.98960240109599,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H239,0)","v":0},0,0,0,0,0]
[null,218.97658107818501,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H240,0)","v":0},0,0,0,0,0]
[null,219.96355975527399,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H241,0)","v":0},0,0,0,0,0]
[null,220.950538432363,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H242,0)","v":0},0,0,0,0,0]
[null,221.93751710945199,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H243,0)","v":0},0,0,0,0,0]
[null,222.924495786541,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H244,0)","v":0},0,0,0,0,0]
[null,223.91147446362999,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H245,0)","v":0},0,0,0,0,0]
[null,224.898453140719,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(#REF!*H246,0)","v":0},0,0,0,0,0]
[null,225.88543181780801,"VEGGIE",null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,H238:H246)","v":0},null,{"$f":"SUBTOTAL(109,J238:J246)","v":0},{"$f":"SUM(K238:K246)*1.0001","v":0},{"$f":"SUM(L238:L246)*1.0001","v":0},{"$f":"SUBTOTAL(109,M238:M246)","v":0},0,0,0,0]
[null,226.872410494897,null,null,null,null,null,null,null,null,null,null,null," "," ","  "," "]
[null,227.85938917198601]

{"sheet":"PIVOT TEMPLATE","index":3,"n_rows":311,"n_cols":8,"rows_kept":311,"cut":false,"hidden":false,"merged":[[17,7,23,13]]}
[]
[null,"HEADER"]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"SNACKS",1991.7878961038962,1284]
[null,"FRUIT",1800.09,732]
[null,"PROTIEN",1573.7929714285713,1004]
[null,"BEVERAGES",1477.216714285714,706]
[null,"PASTA",827.01277714285709,482]
[null,"BREAD",754.32342857142851,504]
[null,"VEGGIE",708.28031020408139,198]
[null,"HOME GOODS",459.45154285714284,292]
[null,"DAIRY",430.65010285714288,218]
[null,"CEREALS",402.87728571428562,484]
[null,"CONDIMENTS",257.25367836734688,260]
[null,"SOUP",252.01259999999996,132]
[null,"SUGARS",120.006,92]
[null,"Grand Total",11054.755307532467,6388]
[null,null,null,null,null,null,null,"PIVOT CHARTS ON DATA TAB ARE COPIED FROM HERE. DATA TAB AND PIVOT TAB ARE COPIED TO TEMPLATES. DO NOT EDIT TEMPLATES. IN CASE OF CORRUPTED FILE, DELETE DATA OR PIVOT TAB AND COPY TEMPLATE TO NEW TAB AND REMOVE \"TEMPLATE\" FROM THE TAB TITLE."]
[]
[]
[]
[]
[]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"DINNER",1895.6081632653058,1060]
[null,"MISC",995.84415584415581,642]
[null,"SNACKS",917.14285714285722,390]
[null,"General",738.57142857142844,353]
[null,"DAILY",347.19183673469388,387]
[null,"BAKING",292.62857142857143,193]
[null,"Grooming",216,134]
[null,"COFFEE",110.4,23]
[null,"Household",13.714285714285714,12]
[null,"Grand Total",5527.1012987012982,3194]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","BEVERAGES"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",738.64528571428559,353]
[null,"GATORAID PUNCH",154.28571428571428,78]
[null,"GATORAID ORANGE",154.28571428571428,104]
[null,"GATORAID PURPLE",154.28571428571428,60]
[null,"MUSCLE MILK STRAW",64.285714285714292,24]
[null,"WATER (FRESH)",57.142857142857153,24]
[null,"SODA GINGER",51.428571428571423,17]
[null,"GATORAID FROST",51.428571428571423,16]
[null,"MJSCLE MILK CHOC",25.714285714285712,20]
[null,"MUSCLE MILK",25.714285714285712,10]
[null,"Grand Total",1477.216714285714,706]
[]
[]
[]
[null,"CATERGORY","BREAD"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",377.1805714285714,252]
[null,"STICKY RICE",154.28571428571428,90]
[null,"BREAD MIX",102.85714285714285,40]
[null,"FLOUR",51.428571428571423,50]
[null,"RICE FLOWER",38.571428571428569,40]
[null,"POP CORN KERNELS",17.142857142857142,24]
[null,"YEAST PACKETS",12.857142857142856,8]
[null,"Grand Total",754.32342857142851,504]
[]
[]
[]
[]
[null,"CATERGORY","CONDIMENTS"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",128.63327020408161,130]
[null,"SALT IODIZED",28.8,24]
[null,"BLUE CHEESE DRES",25.714285714285712,35]
[null,"MAYONAISE",25.714285714285712,30]
[null,"KETSUP",24.685714285714287,20]
[null,"RELISH",19.591836734693878,16]
[null,"MUSTARD",4.1142857142857139,5]
[null,"Grand Total",257.25367836734694,260]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","DAIRY"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",215.33581714285714,109]
[null,"BUTTER PECAN SYRUP",96,17]
[null,"CONDENSED MILK",68.571428571428569,48]
[null,"SWEET CONDENSED",34.285714285714285,34]
[null,"MILK POWDER",16.457142857142856,10]
[null,"Grand Total",430.65010285714283,218]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","HOME GOODS"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",229.73725714285715,146]
[null,"TOOTH PASTE",72,49]
[null,"SOAP BARS",68.571428571428569,19]
[null,"RAZOR SHAVE",25.714285714285712,19]
[null,"TOILET PAPER",25.714285714285712,27]
[null,"SHAMPOO",17.142857142857142,14]
[null,"DISHWASHER LIQ",13.714285714285714,12]
[null,"LAUNDRY DET",6.8571428571428568,6]
[null,"Grand Total",459.45154285714284,292]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","PASTA"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",413.52706285714282,241]
[null,"PASTA ",102.85714285714285,86]
[null,"Ramen Noodles, beef",102.85714285714285,14]
[null,"Ramen Noodles, chicken",51.428571428571423,24]
[null,"Rice, wild",41.142857142857146,43]
[null,"Spaghetti and Macaroni",34.285714285714285,23]
[null,"Spaghetti w/ sauce, canned",34.285714285714285,20]
[null,"PASTA SAUCE",32.914285714285711,14]
[null,"STICKY RICE",13.714285714285714,17]
[null,"Grand Total",827.01277714285709,482]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","SUGARS"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",60.005999999999993,46]
[null,"MAPLE SYRUP",25.714285714285712,14]
[null,"HONEY",14.4,6]
[null,"SUGAR LT BRN",6.8571428571428568,7]
[null,"BROWN SUGAR",6.8571428571428568,16]
[null,"SUGAR",6.1714285714285717,3]
[null,"Grand Total",120.006,92]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","FRUIT"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",900.09,366]
[null,"FRUIT JUICE",514.28571428571433,167]
[null,"APPLE SLICES",102.85714285714285,56]
[null,"MANDARIN ORANGES",102.85714285714285,32]
[null,"BLUEBERRIES",51.428571428571423,40]
[null,"CHERRIES",51.428571428571423,30]
[null,"FRUIT SALAD",51.428571428571423,17]
[null,"APPLESAUCE",25.714285714285712,24]
[null,"PEACHES",0,0]
[null,"STRAWBERRIES",0,0]
[null,"PIE FILLING",0,0]
[null,"PINEAPPLE",0,0]
[null,"Grand Total",1800.0900000000001,732]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","PROTIEN"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",786.93582857142849,502]
[null,"DEHYDRAED EGGS",411.42857142857139,175]
[null,"CANNED TUNA",205.71428571428569,201]
[null,"JERKEY",41.142857142857146,16]
[null,"SPAM",34.285714285714285,34]
[null,"CANNED CHICKEN",34.285714285714285,36]
[null,"CANNED HAM",25.714285714285712,22]
[null,"CANNED BEEF",17.142857142857142,3]
[null,"EGG BEATERS",17.142857142857142,15]
[null,"Grand Total",1573.7929714285713,1004]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","SNACKS"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",995.94374025974037,642]
[null,"JESSI CHIPS",411.42857142857139,204]
[null,"CHEESE DIP",102.85714285714285,105]
[null,"SCOTT CHIPS",102.85714285714285,56]
[null,"SALSA",102.85714285714285,100]
[null,"OTHER DIP",102.85714285714285,80]
[null,"WHITE CHOCOLATE",51.428571428571423,40]
[null,"PEANUT BUTTER",51.428571428571423,18]
[null,"CHOCOLATE",51.428571428571423,34]
[null,"ALMONDS",18.701298701298704,5]
[null,"Grand Total",1991.7878961038962,1284]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","CEREALS"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",201.44871428571423,242]
[null,"DADS CEREAL",68.571428571428569,57]
[null,"JESSI CEREAL",68.571428571428569,76]
[null,"OATS ROLLED",25.714285714285712,36]
[null,"CREAM OF WHEAT",25.714285714285712,34]
[null,"BREAKFAST BARS",12.857142857142856,39]
[null,"Grand Total",402.87728571428568,484]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","SOUP"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",126.01259999999998,66]
[null,"BEEF STEW",51.428571428571423,16]
[null,"CANNED SPAGHETTI",25.714285714285712,14]
[null,"RAVIOLI",12.857142857142856,3]
[null,"SINGLE SERVE DRY",10.285714285714286,23]
[null,"VEG SOUP",8.5714285714285712,3]
[null,"CHICKEN SOUP",8.5714285714285712,2]
[null,"CHICKEN BROTH",5.1428571428571432,1]
[null,"BEEF BROTH",3.4285714285714284,4]
[null,"OTHER",0,0]
[null,"Grand Total",252.01259999999999,132]
[]
[]
[]
[]
[]
[]
[]
[null,"CATERGORY","VEGGIE"]
[]
[null,"Row Labels","Sum of QUOTA","Sum of STORED"]
[null,"TOTAL",354.15786122448975,99]
[null,"GARLIC FRESH",117.55102040816325,16]
[null,"POTATO FRESH",102.85714285714285,14]
[null,"PEAS",51.428571428571423,16]
[null,"BAKED BEANS",25.714285714285712,32]
[null,"MUSHROOMS",20.571428571428573,8]
[null,"INSTANT POTATO",13.714285714285714,4]
[null,"CORN",8.5714285714285712,3]
[null,"GREEN BEANS",8.5714285714285712,2]
[null,"CANNED POTATO",5.1428571428571432,4]
[null,"Grand Total",708.28031020408162,198]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"END"]

{"sheet":"DP FOOD STORAGE","index":4,"n_rows":581,"n_cols":12,"rows_kept":581,"cut":false,"hidden":false,"merged":[]}
[null,"Unit","Target","Quantity","Amount","Unit",null,"Minimum","Expire","Date","Date to","1 Adult Share"]
["Item","Measure","Amount","On Hand","Needed","Cost","Extended","Shelf Life*","Date","Bought","Rotate","Per Week"]
[]
["     BREAD, CEREAL, RICE and PASTA GROUP"]
["Wheat, Grain, Flour  - Select 242 pounds, per adult serve, for 6 months"]
["Bread Mix","lb",{"$f":"L6*$C$521*$B$524","v":52},0,{"$f":"C6-D6","v":52},0,{"$f":"D6*F6","v":0},"2 yrs. w/o yeast",null,null,null,2]
["Cornmeal/Polenta","lb",{"$f":"L7*$C$521*$B$524","v":39},0,39,0,0,"1 year",null,null,null,1.5]
["Flour, White, enriched","lb",45.994,0,45.994,0,0,"1 year",null,null,null,1.7689999999999999]
["Popcorn Kernels","pkg",4.0039999999999996,0,4.0039999999999996,0,0,"2 years",null,null,null,0.154]
["Tortillas, Corn","pkg",2.0019999999999998,0,2.0019999999999998,0,0,"6 months",null,null,null,7.6999999999999999E-2]
["Tortillas, Flour ","pkg",10.4,0,10.4,0,0,"6 months",null,null,null,0.4]
["Wheat, raw, whole","lb",78,0,78,0,0,"25 years",null,null,null,3]
["Other","lb",13,0,13,0,0,null,null,null,null,0.5]
["Other","lb",13,0,13,0,0,null,null,null,null,0.5]
[]
["Rice & Pasta - Select 40 pounds, per adult serve, for 6 months"]
["Ramen Noodles, beef","serving",{"$f":"L17*$C$521*$B$524","v":10.4},0,{"$f":"C17-D17","v":10.4},0,{"$f":"D17*F17","v":0},"2 years",null,null,null,0.4]
["Ramen Noodles, chicken","serving",10.4,0,10.4,0,0,"2 years",null,null,null,0.4]
["Rice, brown","lb",2.99,0,2.99,0,0,"1 year",null,null,null,0.115]
["Rice, jasmine","lb",4.0039999999999996,0,4.0039999999999996,0,0,"8 months",null,null,null,0.154]
["Rice, white enriched ","lb",17.004000000000001,0,17.004000000000001,0,0,"2 years",null,null,null,0.65400000000000003]
["Rice, wild","pkg",2.0019999999999998,0,2.0019999999999998,0,0,"8 months",null,null,null,7.6999999999999999E-2]
["Spaghetti and Macaroni","lb",10.4,0,10.4,0,0,"2 years",null,null,null,0.4]
["Spaghetti w/ sauce, canned","can",5.2,0,5.2,0,0,"2 years",null,null,null,0.2]
["Other","serving",0,0,0,0,0]
["Other","serving",0,0,0,0,0]
[]
["Cereals, Processed & Prepared - Select 37 pounds, per adult serve, for 6 months"]
["Breakfast Bars","box",{"$f":"L29*$C$521*$B$524","v":10.4},0,{"$f":"C29-D29","v":10.4},0,{"$f":"D29*F29","v":0},"6 months",null,null,null,0.4]
["Cream of Wheat","box",1.196,0,1.196,0,0,"1 year",null,null,null,4.5999999999999999E-2]
["Mini-wheats","box",1.196,0,1.196,0,0,"1 year",null,null,null,4.5999999999999999E-2]
["Oats, rolled","lb",15.6,0,15.6,0,0,"18 months",null,null,null,0.6]
["Other","box",0,0,0,0,0]
["Other","box",0,0,0,0,0]
[]
["     MEAT, POULTRY, FISH, DRIED BEANS, EGGS and NUT GROUP"]
["Meats & Fish - Select 350 servings, per adult serve, for 6 months"]
["Anchovies","jar",{"$f":"L38*$C$521*$B$524","v":3.12},0,{"$f":"C38-D38","v":3.12},0,{"$f":"D38*F38","v":0},"1-2 years",null,null,null,0.12]
["Beef, corned, canned","can",1.976,0,1.976,0,0,"1-2 years",null,null,null,7.5999999999999998E-2]
["Caviar","jar",1.8200000000000003,0,1.8200000000000003,0,0,"1 year",null,null,null,7.0000000000000007E-2]
["Chicken, canned, single serve","can",26,0,26,0,0,"1-2 years",null,null,null,1]
["Clams, canned","can",2.0019999999999998,0,2.0019999999999998,0,0,"1-2 years",null,null,null,7.6999999999999999E-2]
["Crab, canned","can",10.4,0,10.4,0,0,"1-2 years",null,null,null,0.4]
["Ham, canned, single serve","can",26,0,26,0,0,"1-2 years",null,null,null,1]
["Jerky","lb",5.0179999999999998,0,5.0179999999999998,0,0,"6 months",null,null,null,0.193]
["Leg Ham, canned, single serve","can",18.2,0,18.2,0,0,"5 years",null,null,null,0.7]
["Oysters, canned","can",2.08,0,2.08,0,0,"1-2 years",null,null,null,0.08]
["Salmon, canned, single serve","can",5.2,0,5.2,0,0,"2-3 years",null,null,null,0.2]
["Shrimp, canned, single serve","can",26,0,26,0,0,"1-2 years",null,null,null,1]
["Spam, serves 2","can",10.4,0,10.4,0,0,"5 years",null,null,null,0.4]
["Tuna w/chili","can",5.2,0,5.2,0,0,"1-2 years",null,null,null,0.2]
["Tuna, serves 2","can",52,0,52,0,0,"1.5 years",null,null,null,2]
["Turkey, canned, single serve","can",26,0,26,0,0,"1-2 years",null,null,null,1]
["TVP-Textured Vegetable Protein","can",{"$f":"L54*$C$521*$B$524","v":10.4},0,{"$f":"C54-D54","v":10.4},0,{"$f":"D54*F54","v":0},"2-3 years",null,null,null,0.4]
["Other","can",{"$f":"L55*$C$521*$B$524","v":26},0,{"$f":"C55-D55","v":26},0,{"$f":"D55*F55","v":0},null,null,null,null,1]
["Other","can",{"$f":"L56*$C$521*$B$524","v":26},0,{"$f":"C56-D56","v":26},0,{"$f":"D56*F56","v":0},null,null,null,null,1]
[]
["Legumes, Beans, Peas - Select 40 pounds, per adult serve, for 6 months"]
["Bean Dip","can",{"$f":"L59*$C$521*$B$524","v":1.04},0,{"$f":"C59-D59","v":1.04},0,{"$f":"D59*F59","v":0},null,null,null,null,0.04]
["Beans, Borlotti, dry","lb",4.0039999999999996,0,4.0039999999999996,0,0,"1 year",null,null,null,0.154]
["Beans, Chick Peas, dry","lb",4.0039999999999996,0,4.0039999999999996,0,0,"1 year",null,null,null,0.154]
["Beans, Kidney, dry","lb",4.0039999999999996,0,4.0039999999999996,0,0,"1 year",null,null,null,0.154]
["Beans, Pinto or Pink, dry","lb",4.0039999999999996,0,4.0039999999999996,0,0,"1 year",null,null,null,0.154]
["Beans, Mexe (Old El Paso)","can",23.088000000000001,0,23.088000000000001,0,0,"2 years",null,null,null,0.88800000000000001]
["Beans, Refried (Old El Paso)","can",4.0039999999999996,0,4.0039999999999996,0,0,"2 years",null,null,null,0.154]
["Beans, 4-Bean Mix","can",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Lentils, dry","lb",4.0039999999999996,0,4.0039999999999996,0,0,"1 year",null,null,null,0.154]
["Other","lb",4.0039999999999996,0,4.0039999999999996,0,0,null,null,null,null,0.154]
["Other","lb",4.0039999999999996,0,4.0039999999999996,0,0,null,null,null,null,0.154]
[]
["Nuts - Select 25 pounds minimum, per adult serve, for 6 months"]
["Peanut Butter","pint",{"$f":"L72*$C$521*$B$524","v":10.14},0,{"$f":"C72-D72","v":10.14},0,{"$f":"D72*F72","v":0},"9 months",null,null,null,0.39]
["Pecans","lb",{"$f":"L73*$C$521*$B$524","v":5.0179999999999998},0,{"$f":"C73-D73","v":5.0179999999999998},0,{"$f":"D73*F73","v":0},"1 year",null,null,null,0.193]
["Other","lb",{"$f":"L74*$C$521*$B$524","v":5.0179999999999998},0,{"$f":"C74-D74","v":5.0179999999999998},0,{"$f":"D74*F74","v":0},null,null,null,null,0.193]
["Other","lb",{"$f":"L75*$C$521*$B$524","v":5.0179999999999998},0,{"$f":"C75-D75","v":5.0179999999999998},0,{"$f":"D75*F75","v":0},null,null,null,null,0.193]
[]
["Eggs - Select 12 dozen minimum, per adult serve, for 6 months"]
["Egg Replacer","box of 60 \"eggs\"",{"$f":"L78*$C$521*$B$524","v":2.08},0,{"$f":"C78-D78","v":2.08},0,{"$f":"D78*F78","v":0},"2 years",null,null,null,0.08]
["Eggs, Dehydrated","dozen",{"$f":"L79*$C$521*$B$524","v":10.4},0,{"$f":"C79-D79","v":10.4},0,{"$f":"D79*F79","v":0},null,null,null,null,0.4]
["Other",null,{"$f":"L80*$C$521*$B$524","v":0},0,{"$f":"C80-D80","v":0},0,{"$f":"D80*F80","v":0}]
[]
["     VEGETABLE GROUP"]
["Vegetables - Select 500 servings, per adult serve, for 6 months"]
["Artichoke Hearts","can/jar",{"$f":"L84*$C$521*$B$524","v":3.9779999999999998},0,{"$f":"C84-D84","v":3.9779999999999998},0,{"$f":"D84*F84","v":0},"3-4 years",null,null,null,0.153]
["Asparagus","can",9.984,0,9.984,0,0,"2 years",null,null,null,0.38400000000000001]
["Bamboo Shoots","can",3.9779999999999998,0,3.9779999999999998,0,0,"3-4 years",null,null,null,0.153]
["Bean, Green","can",9.984,0,9.984,0,0,"2 years",null,null,null,0.38400000000000001]
["Beans, Corn, Peppers","can",9.984,0,9.984,0,0,"2 years",null,null,null,0.38400000000000001]
["Beans Lima","can",9.984,0,9.984,0,0,"4 years",null,null,null,0.38400000000000001]
["Beans, Wax","can",9.984,0,9.984,0,0,"2 years",null,null,null,0.38400000000000001]
["Capers","jar",3.9779999999999998,0,3.9779999999999998,0,0,"3-4 years",null,null,null,0.153]
["Carrots","can",9.984,0,9.984,0,0,"8 years",null,null,null,0.38400000000000001]
["Corn","can",9.984,0,9.984,0,0,"2 years",null,null,null,0.38400000000000001]
["Corn, creamed","can",5.0179999999999998,0,5.0179999999999998,0,0,"2 years",null,null,null,0.193]
["Corn/Peas","can",9.984,0,9.984,0,0,"2 years",null,null,null,0.38400000000000001]
["Enchilada Sauce","jar",9.984,0,9.984,0,0,"2 years",null,null,null,0.38400000000000001]
["Fajita Sauce","jar",9.984,0,9.984,0,0,"2 years",null,null,null,0.38400000000000001]
["Jalapenos, sliced","jar",20.02,0,20.02,0,0,"2 years",null,null,null,0.77]
["Mushrooms","can",20.02,0,20.02,0,0,"3-4 years",null,null,null,0.77]
["Onions, Cocktail","jar",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Peas","can",20.02,0,20.02,0,0,"8 years",null,null,null,0.77]
["Peas & Carrots","can",9.984,0,9.984,0,0,"8 years",null,null,null,0.38400000000000001]
["Popcorn, unpopped","pkg",5.0179999999999998,0,5.0179999999999998,0,0,"3 years",null,null,null,0.193]
["Potatoes, flaked","pkg 20-3/4 C serves",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Pumpkin","can",5.0179999999999998,0,5.0179999999999998,0,0,"4 years",null,null,null,0.193]
["Salsa, Chunky","jar",9.984,0,9.984,0,0,"2 years",null,null,null,0.38400000000000001]
["Spaghetti Sauce","bottles",{"$f":"L107*$C$521*$B$524","v":20.02},0,{"$f":"C107-D107","v":20.02},0,0,"2 years",null,null,null,0.77]
["Taco Sauce","bottle",20.02,0,20.02,0,0,"2 years",null,null,null,0.77]
["Tiny Taters","can",9.984,0,9.984,0,0,"2 years",null,null,null,0.38400000000000001]
["Tomato Paste","jar",9.984,0,9.984,0,0,"2 years",null,null,null,0.38400000000000001]
["Tomatoes, Italian","can",9.984,0,9.984,0,0,"2 years",null,null,null,0.38400000000000001]
["Tomatoes, peeled","can",20.02,0,20.02,0,0,"2 years",null,null,null,0.77]
["Water Chestnuts","can",5.0179999999999998,0,5.0179999999999998,0,0,"3-4 years",null,null,null,0.193]
["Other","can",5.0179999999999998,0,5.0179999999999998,0,0,null,null,null,null,0.193]
["Other","can",0,0,0,0,0]
[]
["Soup - Select 125 servings, per adult serve, for 6 months (depending on variety can be meat, vegetable, starch and/or milk)"]
["Dry Soup Mix, single serve","pkg",{"$f":"L118*$C$521*$B$524","v":26},0,{"$f":"C118-D118","v":26},0,{"$f":"D118*F118","v":0},"1 year",null,null,null,1]
["Soup, condensed, serves 2","can",{"$f":"L119*$C$521*$B$524","v":26},0,{"$f":"C119-D119","v":26},0,{"$f":"D119*F119","v":0},"2 - 3 years",null,null,null,1]
["Soup, ready to eat, single serve","can",{"$f":"L120*$C$521*$B$524","v":40.04},0,{"$f":"C120-D120","v":40.04},0,{"$f":"D120*F120","v":0},"2 - 3 years",null,null,null,1.54]
["Other","pkg",{"$f":"L121*$C$521*$B$524","v":5.0179999999999998},0,{"$f":"C121-D121","v":5.0179999999999998},0,{"$f":"D121*F121","v":0},null,null,null,null,0.193]
["Other","pkg",{"$f":"L122*$C$521*$B$524","v":5.0179999999999998},0,{"$f":"C122-D122","v":5.0179999999999998},0,{"$f":"D122*F122","v":0},null,null,null,null,0.193]
[]
["Bouillon -  Select 1 pound, per adult serve, for 6 months"]
["Broth, Beef, powdered","can",{"$f":"L125*$C$521*$B$524","v":7.8},0,{"$f":"C125-D125","v":7.8},0,{"$f":"D125*F125","v":0},"2 years",null,null,null,0.3]
["Broth, Chicken, powdered","can",{"$f":"L126*$C$521*$B$524","v":7.8},0,{"$f":"C126-D126","v":7.8},0,{"$f":"D126*F126","v":0},"2 years",null,null,null,0.3]
["Other","can",{"$f":"L127*$C$521*$B$524","v":7.8},0,{"$f":"C127-D127","v":7.8},0,{"$f":"D127*F127","v":0},null,null,null,null,0.3]
[null,null,{"$f":"L128*$C$521*$B$524","v":0},0,{"$f":"C128-D128","v":0},0,{"$f":"D128*F128","v":0}]
[]
["     FRUIT GROUP"]
["Fruits - Select 625 servings, per adult serve, for 6 months"]
["Apple Slices, canned","can",{"$f":"L132*$C$521*$B$524","v":10.01},0,{"$f":"C132-D132","v":10.01},0,{"$f":"D132*F132","v":0},"2 years",null,null,null,0.38500000000000001]
["Applesauce","jar",10.01,0,10.01,0,0,"3 years",null,null,null,0.38500000000000001]
["Banana, Dried Chips","pound",5.0179999999999998,0,5.0179999999999998,0,0,"8 months",null,null,null,0.193]
["Blueberries, canned","can",5.0179999999999998,0,5.0179999999999998,0,0,"2 years",null,null,null,0.193]
["Cherries, jar","jars ",5.0179999999999998,0,5.0179999999999998,0,0,"2 years",null,null,null,0.193]
["Fruit Salad/Cocktail, canned","can",10.01,0,10.01,0,0,"2 years",null,null,null,0.38500000000000001]
["Fruit Juice","can",10.01,0,10.01,0,0,"2 years",null,null,null,0.38500000000000001]
["Oranges, Mandarin","can",20.02,0,20.02,0,0,"2 years",null,null,null,0.77]
["Peach, slices, canned","servings",10.01,0,10.01,0,0,"18 months",null,null,null,0.38500000000000001]
["Pear halves, canned","can",10.01,0,10.01,0,0,"3 years+",null,null,null,0.38500000000000001]
["Pie Filling","can",10.01,0,10.01,0,0,"2-3 years",null,null,null,0.38500000000000001]
["Pineapple, Crushed","can",10.01,0,10.01,0,0,"3 years+",null,null,null,0.38500000000000001]
["Pineapple Juice","can",10.01,0,10.01,0,0,"1-2 years",null,null,null,0.38500000000000001]
["Pineapple, Pieces","can",10.01,0,10.01,0,0,"18 months",null,null,null,0.38500000000000001]
["Pineapple, Slices","can",10.01,0,10.01,0,0,"2 years",null,null,null,0.38500000000000001]
["Raspberries, canned","can",10.01,0,10.01,0,0,"2 years",null,null,null,0.38500000000000001]
["Strawberries, canned","can",{"$f":"L148*$C$521*$B$524","v":10.01},0,{"$f":"C148-D148","v":10.01},0,{"$f":"D148*F148","v":0},"2 years",null,null,null,0.38500000000000001]
["Other","can",{"$f":"L149*$C$521*$B$524","v":10.01},0,{"$f":"C149-D149","v":10.01},0,{"$f":"D149*F149","v":0},null,null,null,null,0.38500000000000001]
["Other","can",{"$f":"L150*$C$521*$B$524","v":10.01},0,{"$f":"C150-D150","v":10.01},0,{"$f":"D150*F150","v":0},null,null,null,null,0.38500000000000001]
[]
["     MILK, CHEESE and YOGURT"]
["Milk and Dairy - Select 75 pounds minimum, per adult serve, for 6 months"]
["Cheese, Processed","lb",{"$f":"L154*$C$521*$B$524","v":6.0060000000000002},0,{"$f":"C154-D154","v":6.0060000000000002},0,{"$f":"D154*F154","v":0},"9 months",null,null,null,0.23100000000000001]
["Coffee Mate","can",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Milk, Full Cream, powdered","can",6.0060000000000002,0,6.0060000000000002,0,0,"2 years",null,null,null,0.23100000000000001]
["Milk, Non-fat, dry","lb",40.04,0,40.04,0,0,"2 years",null,null,null,1.54]
["Milk, Shelf Stable ","boxes",{"$f":"L158*$C$521*$B$524","v":20.02},0,{"$f":"C158-D158","v":20.02},0,0,"6 months",null,null,null,0.77]
["Parmesan, grated","can",6.0060000000000002,0,6.0060000000000002,0,0,"9 months",null,null,null,0.23100000000000001]
["Other","lb",6.0060000000000002,0,6.0060000000000002,0,0,null,null,null,null,0.23100000000000001]
["Other","lb",6.0060000000000002,0,6.0060000000000002,0,0,null,null,null,null,0.23100000000000001]
[]
["Canned Milk - Select 12 cans minimum, per adult serve, for 6 months"]
["Evaporated milk (cans)","can",{"$f":"L164*$C$521*$B$524","v":6.0060000000000002},0,{"$f":"C164-D164","v":6.0060000000000002},0,{"$f":"D164*F164","v":0},"1 year",null,null,null,0.23100000000000001]
["Sweetened Condensed Milk","can",{"$f":"L165*$C$521*$B$524","v":6.0060000000000002},0,{"$f":"C165-D165","v":6.0060000000000002},0,{"$f":"D165*F165","v":0},"1 year",null,null,null,0.23100000000000001]
[]
["     FATS, OILS and SWEETS GROUP"]
["Oils, Fats and Shortening - Select 7.5 gallons/30 pounds, per adult serve, for 6 months"]
["Corn Oil","quart",{"$f":"L169*$C$521*$B$524","v":1.04},0,{"$f":"C169-D169","v":1.04},0,{"$f":"D169*F169","v":0},"2 years",null,null,null,0.04]
["Crisco, solid, butter flavor","3 pound",1.04,0,1.04,0,0,"18 months",null,null,null,0.04]
["Crisco, solid, plain","3 pound",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Mayonnaise","quart",1.04,0,1.04,0,0,"6 months",null,null,null,0.04]
["Olive Oil ","gallon",4.03,0,4.03,0,0,"6-9 months",null,null,null,0.155]
["Pure & Simple/Pam","cans",2.0019999999999998,0,2.0019999999999998,0,0,"18 months",null,null,null,7.6999999999999999E-2]
["Salad Dressing","bottle",4.03,0,4.03,0,0,"1 year",null,null,null,0.155]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[]
["Honey, Sugar and Syrup - Select 50 pounds minimum, per adult serve, for 6 months"]
["Equal","box (500 ct.)",{"$f":"L180*$C$521*$B$524","v":1.04},0,{"$f":"C180-D180","v":1.04},0,{"$f":"D180*F180","v":0},"2 years",null,null,null,0.04]
["Corn Syrup","quart",6.0060000000000002,0,6.0060000000000002,0,0,"1 year",null,null,null,0.23100000000000001]
["Honey","pound",6.0060000000000002,0,6.0060000000000002,0,0,"1 year",null,null,null,0.23100000000000001]
["Maple Syrup","bottles",6.0060000000000002,0,6.0060000000000002,0,0,"2 years",null,null,null,0.23100000000000001]
["Molasses","bottles",6.0060000000000002,0,6.0060000000000002,0,0,"1 year",null,null,null,0.23100000000000001]
["Sugar, brown ","pound",10.01,0,10.01,0,0,"6 months",null,null,null,0.38500000000000001]
["Sugar, granulated","pound",20.02,0,20.02,0,0,"2 years",null,null,null,0.77]
["Sugar, powdered","pound",6.0060000000000002,0,6.0060000000000002,0,0,"2 years",null,null,null,0.23100000000000001]
["Other",null,0,0,0,0,0]
["Other",null,0,0,0,0,0]
[]
["     MISCELLANEOUS  FOOD  ITEMS"]
[]
["COMFORT FOODS - Select as desired"]
["Cake/Brownie Mix","box",{"$f":"L194*$C$521*$B$524","v":2.0019999999999998},0,{"$f":"C194-D194","v":2.0019999999999998},0,{"$f":"D194*F194","v":0},"9 months",null,null,null,7.6999999999999999E-2]
["Chewing Gum, Bubblegum Extra","pkg",10.01,0,10.01,0,0,"12 months",null,null,null,0.38500000000000001]
["Chewing Gum, Juicy Fruit","pkg",10.01,0,10.01,0,0,"12 months",null,null,null,0.38500000000000001]
["Chewing Gum, Wrigley's Spearmint","pkg",10.01,0,10.01,0,0,"12 months",null,null,null,0.38500000000000001]
["Chocolate Bars, depending on ingredients","each",10.01,0,10.01,0,0,"1 year +/-",null,null,null,0.38500000000000001]
["Chocolate Chips","pkg",4.992,0,4.992,0,0,"2 years",null,null,null,0.192]
["Chocolate Melts","pkg",2.0019999999999998,0,2.0019999999999998,0,0,"18 months",null,null,null,7.6999999999999999E-2]
["Crackers, Misc.","box",2.0019999999999998,0,2.0019999999999998,0,0,"8 months",null,null,null,7.6999999999999999E-2]
["Crackers, Ritz","box",2.0019999999999998,0,2.0019999999999998,0,0,"8 months",null,null,null,7.6999999999999999E-2]
["Hard Candy","bag",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Muffin Mix","box of 12",2.0019999999999998,0,2.0019999999999998,0,0,"9 months",null,null,null,7.6999999999999999E-2]
["Pancake Mix","box",2.0019999999999998,0,2.0019999999999998,0,0,"6-9 months",null,null,null,7.6999999999999999E-2]
["Pudding, canned","each",20.02,0,20.02,0,0,"1-2 years",null,null,null,0.77]
["Pudding, Vanilla/Chocolate","box",4.992,0,4.992,0,0,"1 year",null,null,null,0.192]
["Saltines, Regular","box",4.992,0,4.992,0,0,"8 months",null,null,null,0.192]
["Saltines, Wholemeal","box",4.992,0,4.992,0,0,"8 months",null,null,null,0.192]
["Toaster Pastries","box",{"$f":"L210*$C$521*$B$524","v":4.992},0,{"$f":"C210-D210","v":4.992},0,{"$f":"D210*F210","v":0},"2-3 months",null,null,null,0.192]
["Other",null,{"$f":"L211*$C$521*$B$524","v":0},0,{"$f":"C211-D211","v":0},0,{"$f":"D211*F211","v":0}]
["Other",null,{"$f":"L212*$C$521*$B$524","v":0},0,{"$f":"C212-D212","v":0},0,{"$f":"D212*F212","v":0}]
[]
["     BAKING ITEMS"]
[]
["LEAVENING AGENTS - Select 1 pound, per adult serve, for 6 months"]
["Baking Powder","box",{"$f":"L217*$C$521*$B$524","v":2.0019999999999998},0,{"$f":"C217-D217","v":2.0019999999999998},0,{"$f":"D217*F217","v":0},"2 years",null,null,null,7.6999999999999999E-2]
["Baking Soda","box",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Bread Improver","box = 15 loaves",2.0019999999999998,0,2.0019999999999998,0,0,"18 months",null,null,null,7.6999999999999999E-2]
["Yeast, Dry","packets",208,0,208,0,0,"18 months",null,null,null,8]
["Other",null,0,0,0,0,0]
["Other",null,0,0,0,0,0]
[]
["THICKENERS - Select 2.5 pounds, per adult serve, for 6 months"]
["Cornstarch/Cornflour","box",{"$f":"L225*$C$521*$B$524","v":2.0019999999999998},0,{"$f":"C225-D225","v":2.0019999999999998},0,{"$f":"D225*F225","v":0},"18 months",null,null,null,7.6999999999999999E-2]
["Gelatin","box",{"$f":"L226*$C$521*$B$524","v":0.98799999999999999},0,{"$f":"C226-D226","v":0.98799999999999999},0,{"$f":"D226*F226","v":0},"18 mos-indefinite",null,null,null,3.7999999999999999E-2]
["Other",null,{"$f":"L227*$C$521*$B$524","v":0},0,{"$f":"C227-D227","v":0},0,{"$f":"D227*F227","v":0}]
["Other",null,{"$f":"L228*$C$521*$B$524","v":0},0,{"$f":"C228-D228","v":0},0,{"$f":"D228*F228","v":0}]
[]
["     SPICES, FLAVORINGS and CONDIMENTS"]
[]
["CONDIMENTS - Select as needed "]
["BBQ Sauce","bottle",{"$f":"L233*$C$521*$B$524","v":2.0019999999999998},0,{"$f":"C233-D233","v":2.0019999999999998},0,{"$f":"D233*F233","v":0},"2 years",null,null,null,7.6999999999999999E-2]
["Chicken Tonight","jar",{"$f":"L234*$C$521*$B$524","v":10.01},0,{"$f":"C234-D234","v":10.01},0,0,"2 years",null,null,null,0.38500000000000001]
["Hollandaise Sauce","pkg",0.59799999999999998,0,0.59799999999999998,0,0,"2 years",null,null,null,2.3E-2]
["Horseradish","jar",0.96199999999999997,0,0.96199999999999997,0,0,"18 months",null,null,null,3.6999999999999998E-2]
["Jams","jar",2.0019999999999998,0,2.0019999999999998,0,0,"18 months",null,null,null,7.6999999999999999E-2]
["Ketchup","bottle",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Lemon Juice","bottle",0.96199999999999997,0,0.96199999999999997,0,0,"1 year",null,null,null,3.6999999999999998E-2]
["Lime Juice","bottle",0.96199999999999997,0,0.96199999999999997,0,0,"1 year",null,null,null,3.6999999999999998E-2]
["Liquid Smoke","bottle",0.96199999999999997,0,0.96199999999999997,0,0,"2 years",null,null,null,3.6999999999999998E-2]
["Mustard, American","jar",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Mustard, Dijon","jar",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Mustard, English","jar",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Olives, pitted","jar",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Olives, sliced","jar",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Pickle Relish","jar",{"$f":"L247*$C$521*$B$524","v":2.0019999999999998},0,{"$f":"C247-D247","v":2.0019999999999998},0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Pickles","jar",{"$f":"L248*$C$521*$B$524","v":2.0019999999999998},0,{"$f":"C248-D248","v":2.0019999999999998},0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Vinegar","quart",{"$f":"L249*$C$521*$B$524","v":2.0019999999999998},0,{"$f":"C249-D249","v":2.0019999999999998},0,{"$f":"D249*F249","v":0},"1 year",null,null,null,7.6999999999999999E-2]
["Other",null,{"$f":"L250*$C$521*$B$524","v":0},0,{"$f":"C250-D250","v":0},0,{"$f":"D250*F250","v":0}]
["Other",null,{"$f":"L251*$C$521*$B$524","v":0},0,{"$f":"C251-D251","v":0},0,{"$f":"D251*F251","v":0}]
[]
["SALT - Select 2.5 pounds, per adult serve, for 6 months"]
["Salt","pound",{"$f":"L254*$C$521*$B$524","v":2.496},0,{"$f":"C254-D254","v":2.496},0,{"$f":"D254*F254","v":0},"indefinite",null,null,null,9.6000000000000002E-2]
[]
["SPICES - Select 2 pound minimum, per adult serve, for 6 months"]
["Bacon Bits","bottle",{"$f":"L257*$C$521*$B$524","v":1.04},0,{"$f":"C257-D257","v":1.04},0,{"$f":"D257*F257","v":0},"2 years",null,null,null,0.04]
["Basil Leaves (Sweet)","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Bay Leaf","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Cayenne","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Chili Flakes, Red Pepper, Crushed","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Chili Powder","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Chili Powder, Mexican","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Chilies, ground","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Cinnamon, ground","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Cumin","bottle",1.04,0,1.04,0,0,"3 years",null,null,null,0.04]
["Dill","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Garlic, fresh, minced","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Garlic Powder","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Garlic Salt","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Garlic, minced","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Marjoram Leaves","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Meat Tenderizer","bottle",1.04,0,1.04,0,0,"1.5 years",null,null,null,0.04]
["Mexican Seasoning","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Nutmeg","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Onion Powder","bottle",1.04,0,1.04,0,0,"4 years",null,null,null,0.04]
["Onion, chopped, dried","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Oregano Leaves","bottle",1.04,0,1.04,0,0,"Indefinite",null,null,null,0.04]
["Paprika","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Parsley Leaves","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Pepper, garlic","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Pepper, ground","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Peppercorn, whole","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Pizza","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Rosemary","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Sage","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Seasoned Salt","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Sesame Seed","bottle",1.04,0,1.04,0,0,"2 years",null,null,null,0.04]
["Taco Seasoning","pkgs.",26,0,26,0,{"$f":"D289*F289","v":0},"2 years",null,null,null,1]
["Tarragon","bottle",1.04,0,1.04,0,{"$f":"D290*F290","v":0},"2 years",null,null,null,0.04]
["Thyme","bottle",1.04,0,1.04,0,{"$f":"D291*F291","v":0},"2 years",null,null,null,0.04]
["Other","bottle",0,0,0,0,{"$f":"D292*F292","v":0}]
["Other","bottle",0,0,0,0,{"$f":"D293*F293","v":0}]
[]
["FLAVORINGS and EXTRACTS - 1/2 pound minimum, per adult serve, for 6 months"]
["Almond","bottle",{"$f":"L296*$C$521*$B$524","v":1.04},0,{"$f":"C296-D296","v":1.04},0,{"$f":"D296*F296","v":0},"1-2 years",null,null,null,0.04]
["Cocoa, powdered","box",1.04,0,1.04,0,0,"1-2 years",null,null,null,0.04]
["Lemon","bottle",1.04,0,1.04,0,0,"1-2 years",null,null,null,0.04]
["Orange","bottle",1.04,0,1.04,0,0,"1-2 years",null,null,null,0.04]
["Vanilla","bottle",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Other","bottle",0,0,0,0,0]
["Other","bottle",0,0,0,0,0]
[]
[]
["     WET YOUR WHISTLE"]
[]
["BEVERAGES - Select 350 servings minimum, per adult serve, for 6 months"]
["Coffee, auto drip","pound",{"$f":"L308*$C$521*$B$524","v":10.01},0,{"$f":"C308-D308","v":10.01},0,{"$f":"D308*F308","v":0},"3 months",null,null,null,0.38500000000000001]
["Coffee, instant, decaf","jar",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Coffee, instant, regular","jar",4.992,0,4.992,0,0,"2 years",null,null,null,0.192]
["Cranberry Juice","jug",4.992,0,4.992,0,0,"2 years",null,null,null,0.192]
["Gator Aide/Stamina Aid","can",2.0019999999999998,0,2.0019999999999998,0,0,"2 years",null,null,null,7.6999999999999999E-2]
["Hot Cocoa","serves",20.02,0,20.02,0,0,"8 months",null,null,null,0.77]
["Ovaltine","serves",20.02,0,20.02,0,0,"18 months",null,null,null,0.77]
["Powdered Drink/Kool Aid","quart",20.02,0,20.02,0,0,"2 years",null,null,null,0.77]
["Tang","quart",10.01,0,10.01,0,0,"2 years",null,null,null,0.38500000000000001]
["Tea, Cinnamon Apple (24 count)","box",4.992,0,4.992,0,0,"18 months",null,null,null,0.192]
["Tea, Earl Grey (100 count)","box",1.04,0,1.04,0,0,"3 years",null,null,null,0.04]
["Tea, Strawberry Kiwi (24 count)","box",4.992,0,4.992,0,0,"18 months",null,null,null,0.192]
["Water, drinking (tap water)","gallon",183.04,0,183.04,0,0,"6 months",null,null,null,7.04]
["Other",null,0,0,0,0,0,"N/A"]
["Other",null,0,0,0,0,0,"N/A"]
[]
["BOOZE - Select as desired "]
["Wine, red","bottle",{"$f":"L325*$C$521*$B$524","v":10.01},0,{"$f":"C325-D325","v":10.01},0,{"$f":"D325*F325","v":0},"7-10 years",null,null,null,0.38500000000000001]
["Wine, red, cooking","box",1.04,0,1.04,0,0,"7-10 years",null,null,null,0.04]
["Wine, white","bottle",10.01,0,10.01,0,0,"5-7 years",null,null,null,0.38500000000000001]
["Wine, white, cooking","box",1.04,0,1.04,0,0,"5-7 years",null,null,null,0.04]
["Other","bottle",0,0,0,0,0,"N/A"]
["Other","bottle",0,0,0,0,0,"N/A"]
[]
["    FUR, FIN and FEATHER"]
[]
["PET SUPPLIES"]
["Cat Box","each",1,0,{"$f":"C335-D335","v":1},0,{"$f":"D335*F335","v":0},"indefinite",null,null,null,3.7999999999999999E-2]
["Cat Box Liners","each",{"$f":"L336*$B$525*$B$524","v":26},0,26,0,0,"indefinite",null,null,null,1]
["Cat Cage for Transportation","each",0.98799999999999999,0,{"$f":"C337-D337","v":0.98799999999999999},0,0,"indefinite",null,null,null,3.7999999999999999E-2]
["Cat Food, Canned","each",{"$f":"L338*$B$525*$B$524","v":13},0,{"$f":"C338-D338","v":13},0,0,"18 months",null,null,null,0.5]
["Cat Food, Dry","pound",13,0,13,0,0,"18 months",null,null,null,0.5]
["Cat Food, Foil Pouches","each",26,0,{"$f":"C340-D340","v":26},0,0,"12 months",null,null,null,1]
["Cat Leash","each",0.98799999999999999,0,{"$f":"C341-D341","v":0.98799999999999999},0,0,"indefinite",null,null,null,3.7999999999999999E-2]
["Cat Litter","bag",13,0,13,0,0,"indefinite",null,null,null,0.5]
["Cat Water (1 pint per cat, per day)","gallons",22.88,0,22.88,0,0,"indefinite",null,null,null,0.88]
["Catnip Toys","each",{"$f":"L344*$B$525*$B$524","v":2.0019999999999998},0,{"$f":"C344-D344","v":2.0019999999999998},0,0,"18 months",null,null,null,7.6999999999999999E-2]
["Dog Bones","each",{"$f":"L345*$B$525*$B$524","v":26},0,26,0,0,"18 months",null,null,null,1]
["Dog Chewies","each",{"$f":"L346*$B$525*$B$524","v":52},0,52,0,0,"N/A",null,null,null,2]
["Dog Food Bowl","each",{"$f":"L347*$B$525*$B$524","v":0.98799999999999999},0,0.98799999999999999,0,0,"indefinite",null,null,null,3.7999999999999999E-2]
["Dog Food, Dry (depends on animal size)","pounds",{"$f":"L348*$B$525*$B$524","v":229.97000000000003},0,229.97000000000003,0,0,"indefinite",null,null,null,8.8450000000000006]
["Dog Water Bowl","each",{"$f":"L349*$B$525*$B$524","v":0.98799999999999999},0,0.98799999999999999,0,0,"indefinite",null,null,null,3.7999999999999999E-2]
["Dog, Leash","each",0.98799999999999999,0,0.98799999999999999,0,0,"indefinite",null,null,null,3.7999999999999999E-2]
["Dog, Muzzle","each",0.98799999999999999,0,0.98799999999999999,0,0,"indefinite",null,null,null,3.7999999999999999E-2]
["Dog, Water (1 gal/med. dog/day)","gallons",183.04,0,183.04,0,0,"indefinite",null,null,null,7.04]
["Fish Food, (how many fish?)","can",0,0,0,0,0,"12 months"]
["Hair Ball Medicine","tube",2.0019999999999998,0,{"$f":"C354-D354","v":2.0019999999999998},0,0,null,null,null,null,7.6999999999999999E-2]
["Tennis Balls","each",0.98799999999999999,0,0.98799999999999999,0,0,"indefinite",null,null,null,3.7999999999999999E-2]
["Other","each",{"$f":"L356*$C$521*$B$524","v":0},0,{"$f":"C356-D356","v":0},0,0,"N/A"]
["Other","each",{"$f":"L357*$C$521*$B$524","v":0},0,{"$f":"C357-D357","v":0},0,0,"N/A"]
[]
["     HOUSEHOLD ITEMS"]
[]
["PAPER, PLASTIC and ALUMINUM"]
["Aluminum Foil, long","roll",{"$f":"L362*$C$521*$B$524","v":2.0019999999999998},0,{"$f":"C362-D362","v":2.0019999999999998},0,{"$f":"D362*F362","v":0},"indefinite",null,null,null,7.6999999999999999E-2]
["Aluminum Foil, short","roll",2.0019999999999998,0,{"$f":"C363-D363","v":2.0019999999999998},0,0,"indefinite",null,null,null,7.6999999999999999E-2]
["Baking Cups","pkg (100 ct.)",0.96199999999999997,0,0.96199999999999997,0,0,"indefinite",null,null,null,3.6999999999999998E-2]
["Brown Paper Bags, lunch size","pkg (300)",0.46799999999999997,0,0.46799999999999997,0,0,"indefinite",null,null,null,1.7999999999999999E-2]
["Coffee Filters","box (40 ct)",2.0019999999999998,0,2.0019999999999998,0,0,"indefinite",null,null,null,7.6999999999999999E-2]
["Kleenex","box",4.992,0,4.992,0,0,"indefinite",null,null,null,0.192]
["Oven Bags, large","box (4 ct.)",0.46799999999999997,0,0.46799999999999997,0,0,"indefinite",null,null,null,1.7999999999999999E-2]
["Oven Bags, small","box (5 ct)",0.46799999999999997,0,0.46799999999999997,0,0,"indefinite",null,null,null,1.7999999999999999E-2]
["Paper Bowls","each",20.02,0,20.02,0,0,"indefinite",null,null,null,0.77]
["Paper Cups","each",78,0,78,0,0,"indefinite",null,null,null,3]
["Paper Napkins","pkg (100 ct.)",2.99,0,2.99,0,0,"indefinite",null,null,null,0.115]
["Paper Plates","each",47.97,0,47.97,0,0,"indefinite",null,null,null,1.845]
["Paper Platters","each",10.01,0,10.01,0,0,"indefinite",null,null,null,0.38500000000000001]
["Paper Towels","roll",10.01,0,10.01,0,0,"indefinite",null,null,null,0.38500000000000001]
["Plastic Forks, Knives & Spoons","sets",5.2,0,5.2,0,0,"indefinite",null,null,null,0.2]
["Plastic Wrap","roll",2.0019999999999998,0,2.0019999999999998,0,0,"indefinite",null,null,null,7.6999999999999999E-2]
["Styrofoam Cups","each",36.035999999999994,0,{"$f":"C378-D378","v":36.035999999999994},0,0,"indefinite",null,null,null,1.3859999999999999]
["Toilet Paper","each",36.035999999999994,0,{"$f":"C379-D379","v":36.035999999999994},0,0,"indefinite",null,null,null,1.3859999999999999]
["Toothpicks","box (350 ct.)",0.59799999999999998,0,0.59799999999999998,0,0,"indefinite",null,null,null,2.3E-2]
["Trash bags, clear","sack/box (15 ct.)",10.01,0,10.01,0,0,"indefinite",null,null,null,0.38500000000000001]
["Trash bags, large","sack/box (15 ct.)",10.01,0,10.01,0,0,"indefinite",null,null,null,0.38500000000000001]
["Trash bags, x-large","sack/box (20 ct.)",10.01,0,10.01,0,0,"indefinite",null,null,null,0.38500000000000001]
["Wax Paper","roll",0.96199999999999997,0,0.96199999999999997,0,0,"indefinite",null,null,null,3.6999999999999998E-2]
["Zip Loc, 1 qt.","box (15 ct.)",0.96199999999999997,0,0.96199999999999997,0,0,"indefinite",null,null,null,3.6999999999999998E-2]
["Zip Loc, 1/2 gal.","box (12 ct.)",0.96199999999999997,0,0.96199999999999997,0,0,"indefinite",null,null,null,3.6999999999999998E-2]
["Zip Loc, gallon","box (12 ct.)",0.96199999999999997,0,0.96199999999999997,0,0,"indefinite",null,null,null,3.6999999999999998E-2]
["Zip Loc, snack size","box (50)",0.96199999999999997,0,0.96199999999999997,0,0,"indefinite",null,null,null,3.6999999999999998E-2]
["Other",null,0,0,0,0,0,"N/A"]
["Other",null,0,0,0,0,0,"N/A"]
[]
[]
["BATTERIES, LIGHTBULBS, PEST CONTROL and FIRE ITEMS"]
["Batteries, 6 Volt Lantern","each",{"$f":"L394*$C$521*$B$524","v":1.0009999999999999},0,{"$f":"C394-D394","v":1.0009999999999999},0,{"$f":"D394*F394","v":0},"4 years",null,null,null,3.85E-2]
["Batteries, AA","each",20.02,0,20.02,0,0,"4 years",null,null,null,0.77]
["Batteries, AAA","each",10.01,0,10.01,0,0,"4 years",null,null,null,0.38500000000000001]
["Batteries, C","each",10.01,0,10.01,0,0,"4 years",null,null,null,0.38500000000000001]
["Batteries, D","each",20.02,0,20.02,0,0,"4 years",null,null,null,0.77]
["Bic Lighters","each",4.0039999999999996,0,4.0039999999999996,0,0,"N/A",null,null,null,0.154]
["Dust Masks","each",20.02,0,20.02,0,0,"indefinite",null,null,null,0.77]
["Firestarters (kerosene soaked)","pkg. (24 ct.)",10.01,0,10.01,0,0,null,null,null,null,0.38500000000000001]
["Flashlight (one per person)","each",{"$f":"L402*$C$521*$B$524","v":0},0,0,0,0,"indefinite"]
["Flashlight Replacement Bulbs","each",{"$f":"L403*$C$521*$B$524","v":4.16},0,4.16,0,0,"indefinite",null,null,null,0.16]
["Gas Match","each",4.0039999999999996,0,4.0039999999999996,0,0,null,null,null,null,0.154]
["Lightbulbs, 100W","each",4.0039999999999996,0,4.0039999999999996,0,0,"indefinite",null,null,null,0.154]
["Lightbulbs, 60W","each",4.0039999999999996,0,4.0039999999999996,0,0,"indefinite",null,null,null,0.154]
["Lightbulbs, 60W Reflector Floods","each",{"$f":"L407*$C$521*$B$524","v":4.0039999999999996},0,{"$f":"C407-D407","v":4.0039999999999996},0,0,"indefinite",null,null,null,0.154]
["Lightbulbs, 75W","each",4.0039999999999996,0,4.0039999999999996,0,0,"indefinite",null,null,null,0.154]
["Matches","pkg (10 boxes)",10.01,0,10.01,0,0,"indefinite",null,null,null,0.38500000000000001]
["Mouse Traps (figured as 1/week)","each",26,0,26,0,0,"indefinite"]
["Needles, assorted sizes","pkg",{"$f":"L411*$C$521*$B$524","v":1.0009999999999999},0,1.0009999999999999,0,0,"indefinite",null,null,null,3.85E-2]
["OFF/Bug Repellent","can",1.0009999999999999,0,{"$f":"C412-D412","v":1.0009999999999999},0,0,"5 years",null,null,null,3.85E-2]
["Raid House and Garden","can",{"$f":"L413*$C$521*$B$524","v":2.0019999999999998},0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Raid/Black Flag Ant & Roach Killer","can",{"$f":"L414*$C$521*$B$524","v":2.0019999999999998},0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Rat Sack","bag",{"$f":"L415*$C$521*$B$524","v":2.0019999999999998},0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Rat Traps (figured as 1/month)","each",5,0,5,0,0,null,null,null,null,8.8999999999999996E-2]
["Razors, Single Edge","each",{"$f":"L417*$C$521*$B$524","v":6.5},0,6.5,0,0,"indefinite",null,null,null,0.25]
["Safety Pins, assorted sizes","pkg",{"$f":"L418*$C$521*$B$524","v":2.0019999999999998},0,2.0019999999999998,0,0,"indefinite",null,null,null,7.6999999999999999E-2]
["Other",null,{"$f":"L419*$C$521*$B$524","v":0},0,{"$f":"C419-D419","v":0},0,0,"N/A"]
["Other",null,{"$f":"L420*$C$521*$B$524","v":0},0,{"$f":"C420-D420","v":0},0,0,"N/A"]
[]
["CLEANSERS"]
["Ammonia","quart",{"$f":"L423*$C$521*$B$524","v":2.0019999999999998},0,{"$f":"C423-D423","v":2.0019999999999998},0,{"$f":"D423*F423","v":0},null,null,null,null,7.6999999999999999E-2]
["Bleach","gallons",4.0039999999999996,0,{"$f":"C424-D424","v":4.0039999999999996},0,0,null,null,null,null,0.154]
["Cleanser (Ajax)","can",2.0019999999999998,0,{"$f":"C425-D425","v":2.0019999999999998},0,0,null,null,null,null,7.6999999999999999E-2]
["Dishwasher Soap ","box",2.0019999999999998,0,{"$f":"C426-D426","v":2.0019999999999998},0,0,null,null,null,null,7.6999999999999999E-2]
["Dishwashing Liquid","bottle",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Disinfectant (Pine Sol)","bottle",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Fabric Softener, refill","each",2.0019999999999998,0,{"$f":"C429-D429","v":2.0019999999999998},0,0,null,null,null,null,7.6999999999999999E-2]
["Furniture Polish","bottle",0.59799999999999998,0,0.59799999999999998,0,0,null,null,null,null,2.3E-2]
["Kleenex","box",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Laundry Soap","pound",1.0009999999999999,0,1.0009999999999999,0,0,null,null,null,null,3.85E-2]
["Lysol, spray","cans",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Soap, bars","each",5.2,0,5.2,0,0,null,null,null,null,0.2]
["Soft Wash Liquid Soap Dispensers","bottle",0.80600000000000005,0,0.80600000000000005,0,0,null,null,null,null,3.1E-2]
["Soft Wash Liquid Soap Refill","bottle",1.599,0,1.599,0,0,null,null,null,null,6.1499999999999999E-2]
["Sponges","each",4.0039999999999996,0,4.0039999999999996,0,0,null,null,null,null,0.154]
["Spray & Wipe/Fantastic","bottle",1.196,0,1.196,0,0,null,null,null,null,4.5999999999999999E-2]
["Steel Pads","each",{"$f":"L439*$C$521*$B$524","v":40.04},0,40.04,0,{"$f":"D439*F439","v":0},null,null,null,null,1.54]
["Windex","bottle",{"$f":"L440*$C$521*$B$524","v":2.0019999999999998},0,2.0019999999999998,0,{"$f":"D440*F440","v":0},null,null,null,null,7.6999999999999999E-2]
["Other",null,{"$f":"L441*$C$521*$B$524","v":0},0,0,0,{"$f":"D441*F441","v":0}]
["Other",null,{"$f":"L442*$C$521*$B$524","v":0},0,0,0,{"$f":"D442*F442","v":0}]
[]
["     HEALTH and HYGIENE"]
[]
["HYGIENE/PERSONAL"]
["After Shave/Men's Cologne","bottle",{"$f":"L447*$C$521*$B$524","v":1.0009999999999999},0,{"$f":"C447-D447","v":1.0009999999999999},0,{"$f":"D447*F447","v":0},null,null,null,null,3.85E-2]
["ChapStick","each",2.0019999999999998,0,{"$f":"C448-D448","v":2.0019999999999998},0,0,null,null,null,null,7.6999999999999999E-2]
["Cosmetic Items (make your own list)","each",0,0,0,0,0,null,null,null,null,0]
["Cottonballs","bags (180 ct.)",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Cream Rinse/Conditioner","each",7.0200000000000005,0,7.0200000000000005,0,0,null,null,null,null,0.27]
["Dental Floss","roll",4.992,0,4.992,0,0,null,null,null,null,0.192]
["Deodorant ","each",2.99,0,2.99,0,0,null,null,null,null,0.115]
["Foot Exfoliating Cream","each",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Hair Color  (depends on no. of women)","each",6.032,0,6.032,0,0,null,null,null,null,0.23200000000000001]
["Hand Lotion","bottle",2.99,0,2.99,0,0,null,null,null,null,0.115]
["Heel Softener","tube",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Heel Stone","each",1.0009999999999999,0,1.0009999999999999,0,0,null,null,null,null,3.85E-2]
["Mouthwash","bottle",2.99,0,{"$f":"C459-D459","v":2.99},0,0,null,null,null,null,0.115]
["Panty Liners (depends on no. of women)","each",0,0,{"$f":"C460-D460","v":0},0,0]
["Perfume","bottle",1.0009999999999999,0,{"$f":"C461-D461","v":1.0009999999999999},0,0,null,null,null,null,3.85E-2]
["Plax","bottle",2.99,0,{"$f":"C462-D462","v":2.99},0,0,null,null,null,null,0.115]
["Q-Tips","box (100 ct.)",2.0019999999999998,0,{"$f":"C463-D463","v":2.0019999999999998},0,0,null,null,null,null,7.6999999999999999E-2]
["Razor Blades","each",26,0,26,0,0,null,null,null,null,1]
["Razors, disposables","pkg (10 ct)",2.99,0,2.99,0,0,null,null,null,null,0.115]
["Sanitary Pads  (depends on no. of women)","each",0,0,0,0,0]
["Shampoo","bottle",7.0200000000000005,0,7.0200000000000005,0,0,null,null,null,null,0.27]
["Shave Cream","can",9.1,0,9.1,0,0,null,null,null,null,0.35]
["Tampons (depends on no. of women)","each",0,0,0,0,0]
["Toothbrush","each",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Toothpaste","tube",2.6,0,2.6,0,0,null,null,null,null,0.1]
["Other",null,0,0,0,0,0]
["Other",null,0,0,0,0,0]
[]
["MEDICATIONS/HEALTH "]
["Antifungal","tube",{"$f":"L476*$C$521*$B$524","v":0.59799999999999998},0,{"$f":"C476-D476","v":0.59799999999999998},0,{"$f":"D476*F476","v":0},null,null,null,null,2.3E-2]
["Aspirin (Anacin, Bayer, Bufferin)","box (24 count)",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Aspirin Extra Strength","box (16 count)",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Band-Aids","each",0.80600000000000005,0,0.80600000000000005,0,0,null,null,null,null,3.1E-2]
["Benadryl","box",1.17,0,1.17,0,0,null,null,null,null,4.4999999999999998E-2]
["Betadine Spray","bottle (75 ml)",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Betadine/Neosporin Ointment","tube (25g)",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Birth Control","months",5.98,0,5.98,0,0,null,null,null,null,0.23]
["Chlor Trimeton","pkg (10 dose)",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Crepe Bandages","rolls",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Daquil","box (48 ct.)",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Epson Salts","box (375g)",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Eyedropper","each",0.59799999999999998,0,0.59799999999999998,0,0,null,null,null,null,2.3E-2]
["Ibuprofen (Advil/Motrin)","box (48 count)",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Leukostrips/Butterfly bandages","box (9 ct.)",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Merthiolate","bottle 50 ml",0.20020000000000002,0,0.20020000000000002,0,0,null,null,null,null,7.7000000000000002E-3]
["Moleskin","pkg.",0.59799999999999998,0,0.59799999999999998,0,0,null,null,null,null,2.3E-2]
["Mylanta Tablets","box (100 count)",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Nyquil","bottle 20-10ml dose",{"$f":"L494*$C$521*$B$524","v":2.0019999999999998},0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Prep H, ointment","tube",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Prep H, suppositories","box (12 ct.) ",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Robitussin-Ex","bottle 10-20ml dose",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Solarcaine","can",0.96199999999999997,0,0.96199999999999997,0,0,null,null,null,null,3.6999999999999998E-2]
["Sudafed (Daytime/Nightime)","box (24 count)",2.0019999999999998,0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Sudafed 12 hour Sinus","box (18 ct.)",{"$f":"L500*$C$521*$B$524","v":2.99},0,2.99,0,0,null,null,null,null,0.115]
["Sudafed 6 hour Antihistamine","box (30 ct.)",{"$f":"L501*$C$521*$B$524","v":2.6},0,2.6,0,0,null,null,null,null,0.1]
["Surgical Tape","rolls",0.96199999999999997,0,0.96199999999999997,0,0,null,null,null,null,3.6999999999999998E-2]
["TeaTree Oil","bottle (10 ml)",{"$f":"L503*$C$521*$B$524","v":0.59799999999999998},0,0.59799999999999998,0,0,null,null,null,null,2.3E-2]
["Throat Lozenges (Chloraseptic, Sucrets)","pkg.",{"$f":"L504*$C$521*$B$524","v":2.0019999999999998},0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Tylenol","bottle (100 ct.)",{"$f":"L505*$C$521*$B$524","v":2.0019999999999998},0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Tylenol 3","box (24 count)",{"$f":"L506*$C$521*$B$524","v":2.0019999999999998},0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Vitamin, Echinacea","bottle (60 ct.) ",{"$f":"L507*$C$521*$B$524","v":2.0019999999999998},0,2.0019999999999998,0,0,null,null,null,null,7.6999999999999999E-2]
["Vitamin, Multi","bottle (60 ct.) ",2.99,0,2.99,0,{"$f":"D508*F508","v":0},null,null,null,null,0.115]
["Zantac","box (6 ct.)",5.98,0,5.98,0,{"$f":"D509*F509","v":0},null,null,null,null,0.23]
["Other",null,0,0,0,0,{"$f":"D510*F510","v":0}]
["Other",null,0,0,0,0,{"$f":"D511*F511","v":0}]
["Other",null,0,0,0,0,{"$f":"D512*F512","v":0}]
[]
["Ages of Persons to Feed","No. of Persons","Serves"]
["Children Aged 1-6 years",0,{"$f":"B515*0.5","v":0}]
["Children Aged 7-11 years",0,{"$f":"B516*0.75","v":0}]
["Females aged 12-18 years",0,{"$f":"B517*1.25","v":0}]
["Males aged 12-18 years",0,{"$f":"B518*1.5","v":0}]
["Females aged over 18 years",1,{"$f":"B519*1","v":1}]
["Males aged over 18 years",1,{"$f":"B520*1","v":1}]
[null,"Adult Serves",{"$f":"SUM(C515:C520)","v":2}]
[]
[null,"Weeks"]
["Number of Weeks to Provide Supply for...",13]
["Number of Pets",2]
[]
[]
["Foods are categorized by food group. You can use this sheet one of two ways:"]
["METHOD 1: You can use the suggested amount of foods to select at the beginning of each category and"]
["plug in the amount of each food you want to fulfill the amounts. To use this method, multiply the number "]
["of Adult Portions by the suggested of amount of pounds needed as in lines 5, 16, 29, 38 and so on.  For example, "]
["if you need 5 adult portions for Leavening Agents, multiply 5 x 1 pound or 5 pounds salt for 6 months. If you need to "]
["figure this amount for 1 year, multiply the total by 2 to = 10 pounds. For only 3 months,  divide the suggested"]
["amount to select for each category in half."]
[]
["METHOD 2: You can use the suggested amounts of Adults Shares found in Column L."]
["To use this method, scroll down to B515 and fill in the number of family members for each lines 515 - 520."]
["The number of Adult Shares needed will automatically be figured into the suggested amounts figured in Column C, "]
["Target Amount. As you add to your stored items, fill in the amounts in Column D, Quantity On Hand. The worksheet"]
["will automatically fill in the amounts still needed in Column E, Amount Needed. If you want to keep track of how much "]
["you're spending, drop in the cost per item in Column F, Unit Cost. The worksheet will automatically calculate the"]
["extended cost in Column G."]
[]
["SHELF LIFE: For most products, Column H will give you the recommended MINIMUM shelf life. Many food products list"]
["the expiration date right on the package. For those that do not, you can keep track when you purchase items on this sheet"]
["by using any of the Column I, J or K. For products not marked with an expiration date, be sure to write on the product"]
["with a permanent marker the date of purchase."]
[]
["The last column, L, is where you can change the suggested weekly amount per Adult Share. For example, if your family "]
["wants to store more Green Beans, change the Adult Share in L87 to the quantity desired."]
[]
["This worksheet's food group information is based on the USDA (United States Dept. of Agriculture) recommended amounts. "]
["However any quantity can be adjusted up or down to fit personal needs, budget or taste. These are suggestions only."]
[]
["ADDING ITEMS: Adding extra items is very easy in Excel, but for your convenience, for each category, 2 extra lines are "]
["already provided where you can insert products."]
[]
["Suggested quantities are padded a bit to plan for unexpected circumstances. If the budget allows, it is always better to "]
["have too much than not enough!  With continued rotating of food into your normal diet, nothing will ever go to waste."]
[]
["SPECIALTY ITEMS: A few items like mouse and rat traps are not based on the Adult Share formula but on a per week use. "]
["Change these amounts to suit. Items that are gender-dependent like sanitary napkins, etc., you will been to fill in the amounts"]
["since this worksheet does not differentiate between male and female except in food quantities needed."]
[]
["This sheet does not cover all items needed except for most food and water. For additional items to stock, please check"]
["both the General Supplies List and First Aid List. These items too may be added to this worksheet to help keep track of progress."]
[]
["There are certain items that are not age-dependent like flashlights. If you plug in the value for one 4 year old child, the formula "]
["comes up with half a flashlight! Not too practical. Some of these items you will need to fill in by hand."]
[]
["* SHELF LIFE: can be greatly increased by vacuum or nitrogen packing or other method of hermetically sealing foods"]
["stored in the dark, freezing the items and leaving packaging unopened from time of purchase to usage. Storing foods at a "]
["constant 68 degrees F (20 degrees C) or lower will greatly lengthen shelf life. Many foods can be safely consumed months "]
["after the expiration date as long as the container is intact, but using foods by their expiration date will insure finest nutritional "]
["quality and taste. (See article on Extending Shelf Life in the Food section of Long Term Storage.)"]
[]
["GENERAL NOTE:  These quantities are suggested guidelines. If you have severe allergies, you may need to store more antihistamines."]
["Suggested amounts might change due to different circumstances. If you have no running water, you may need or want more paper "]
["plates and styrofoam cups. Tailor this Food Planner to work for you! "]
[]
["You can easily print this program out in black and white, but we used the different colors to distinguish the different food categories."]