{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Table","Profit Grid","Template"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":0,"defined_names":9,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Profit Grid","index":2,"reason":"not_a_worksheet"}],"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":"Instructions","index":0,"n_rows":98,"n_cols":13,"rows_kept":98,"cut":false,"hidden":false,"merged":[[1,0,1,6],[84,3,84,5],[86,3,86,5],[76,3,76,5],[88,3,88,5],[78,3,78,5],[80,3,80,5],[82,3,82,5]]}
[]
["INSTRUCTIONS",null,null,null,null,null,null,null,null,null,null,null,"Now:"]
[]
[null,"This spreadsheet is a simple but powerful tool that will help you to analyse the profitability of your menu as"]
[null,"well as monitor wastage. Follow the step-by-step guidelines below to get the most out of the spreadsheet."]
[]
[null,"What does the Menu Profitability Analyser (MPA) Grid mean?"]
[null,"The information you put into the Table of sales, costs and gross profit is sorted so it charts on a Profit Grid (below). "]
[null,"Each corner has a name - the higher your item on the grid, the more Gross Profit (NOT %) the item makes "]
[null,"relative to the other items you sell. The further to the RIGHT it is on the grid, the more popular it is in relation"]
[null,"to the other items on your menu Obviously you want a menu with plenty of items that are both profitable AND popular!"]
[null,"These we call BIG WINNERS. Items that are big sellers but don't make so much profit per item are the STEADY WINNERS."]
[null,"The USEFULS give you good profit per item but don't sell so many. Finally, you don't want the LOSERS on your menu -"]
[null,"they don't sell and they make very little money! "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["1.  Cautions"]
[]
[null,"Experienced spreadsheet users will be familiar with these cautions.  They are included here to help less"]
[null,"experienced users."]
[]
[null,"Do not use the move command (cut and paste, drag and drop, Lotus 1-2-3 /M, etc.) to"]
[null,"move any input data or formulas from one cell to another cell unless you are an experienced"]
[null,"spreadsheet user and understand all of the implications of moving cells.  Briefly, if a cell is"]
[null,"moved, formulas that reference that cell will point to the new cell location.  This can corrupt the"]
[null,"spreadsheet.  "]
[]
[null,"Do not delete or insert rows  into the table as this will cause confusion when the table is sorted."]
[]
[null,"If you suspect that either of the above have happened, you can use the 'Undo' command to return"]
[null,"the spreadsheet to a prior state.  If you are unable to undo the spreadsheet, you will need to close"]
[null,"(do not save) the spreadsheet and then open an uncorrupted copy."]
[]
[null,"The spreadsheet has been protected to prevent accidentally changing the formulas. If you need to"]
[null,"make modifications to any of the sheets (e.g. change column widths, cell colors etc), you can change"]
[null,"it by going to TOOLS > PROTECTION > UNPROTECT.  The password you must use to have access to"]
[null,"changes is \"getHOHT\"."]
[]
[null,"After you have made changes, it is a good idea to reprotect the sheet TOOLS > PROTECTION > PROTECT."]
[]
["2.  Instructions"]
[]
["1.","It is suggested that you create a new folder in which to save the spreadsheet."]
[null,"Open the spreadsheet and go to the \"Instructions\" sheet (tab at the bottom of the screen)."]
[null,"Now enter the relevant GST Rate in the box below.  This will enable the spreadsheet to calculate"]
[null,"all the columns without GST."]
[]
[null,null,null,"GST Rate:",15]
[]
["2.","Go to the \"Table\" sheet (tab at the bottom of the screen) and start inputting the relevant"]
[null,"information in the yellow cells.  The program initially contains some examples for illustration purposes."]
[null,"You simply replace these with your information."]
[null,"You can input and change the information in any of the yellow cells. As you do this, the other"]
[null,"grey columns will calculate automatically.  The grey cells are protected and should not be changed."]
[null,"You can input up to 100 menu items."]
[null,"The table column headings are explained below:"]
[]
[null,"Number Sold",null,"Enter the total number of servings sold (from your sales register or dockets).  This column is plotted on the horizontal axis of the Profit Grid."]
[]
[null,"Cost of Item",null,"Enter the food cost of each serving (from your recipe cards or purchase invoices)."]
[]
[null,"Selling Price    (inc GST)",null,"Enter the price at which you sell each serving (ie the price on your menu)."]
[]
[null,"Net Selling Price (without GST)",null,"This calculates the selling price less GST for each serving."]
[]
[null,"Total Gross Sales (inc GST)",null,"This calculates your total gross revenue per serving for each item.  It is the \"Number Sold\" multiplied by the \"Selling Price (inc GST)\"."]
[]
[null,"Gross Profit per Item (without GST)",null,"This calculates gross profit you are making on each serving sold.  It is the \"Cost of item\" multiplied by the \"Net Selling Price\".  This column is plotted on the verticle axis of the Profit Grid."]
[]
[null,"Total Gross Profit (without GST)",null,"This calculates total gross profit you are making on this item.  It is the \"Number Sold\" multiplied by the \"Gross Profit per Item\"."]
[]
["3.","Once all your menu information has been inputted, click on the \"Profit Grid\" (tab at the bottom of the screen)"]
[null,"to view the profitability matrix for your winelist."]
[]
["4.","You can now also use the \"Sort by\" buttons at the top of the table to sort the table by the relevant columns."]
[]
["5.","The overall totals for some of the columns are displayed in the grey boxes at the top of the table."]
[null,"The \"Gross Profit Percentage\" is also displayed.  This figure is an indication of the overall (average)"]
[null,"profitability of your menu."]

{"sheet":"Table","index":1,"n_rows":110,"n_cols":28,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
["Menu Profitability Analysis"]
[]
["Totals:",{"$f":"SUM(B11:B110)","v":255},null,null,null,{"$f":"SUM(F11:F110)","v":2416.1000000000004},null,{"$f":"SUM(H11:H110)","v":1517.0665217391304}]
[]
[null,null,null,null,null,null,"Gross Profit %",{"$f":"IF(F3=0,0,H3/F3)","v":0.62789889563309886}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(B11:B110)","v":33},{"$f":"MAX(G11:G110)","v":10.243478260869566}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,100]
[{"$f":"\"Menu Item\"&TEXT(NOW(),\"\")","v":"Menu Item"},"Number Sold","Cost of Item","Selling Price    (inc GST)","Net Selling Price (without GST)","Total Gross Sales        (inc GST)","Gross Profit per Item (without GST)","Total Gross Profit (without GST)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# prop","GP prop"]
["Chocolate Macadamia Brownie",33,1.23,8.5,{"$f":"D11*(100/(100+Instructions!$E$67))","v":7.3913043478260869},{"$f":"B11*D11","v":280.5},{"$f":"IF(ISBLANK(D11),0,E11-C11)","v":6.1613043478260874},{"$f":"IF(G11=\"\",\"\",B11*G11)","v":203.32304347826087},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(B11),NA(),B11*(AA$9/AA$8))","v":100},{"$f":"IF(ISBLANK(C11),NA(),G11*(AB$9/AB$8))","v":60.148556876061122}]
["Lemon crush Cake",23,1.3,6.5,{"$f":"D12*(100/(100+Instructions!$E$67))","v":5.6521739130434785},149.5,4.3521739130434787,100.10000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69.696969696969703,42.487266553480474]
["Chocolate hazelnut Mousse",22,1.5,5.8,{"$f":"D13*(100/(100+Instructions!$E$67))","v":5.0434782608695645},127.6,3.5434782608695645,77.956521739130423,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66.666666666666671,34.592529711375199]
["Chicken Caesar Salad ",19,2.7,10.5,{"$f":"D14*(100/(100+Instructions!$E$67))","v":9.1304347826086953},199.5,6.4304347826086952,122.17826086956521,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57.575757575757578,62.775891341256354]
["Mixed Gypsy Grill",18,5.8,17.5,{"$f":"D15*(100/(100+Instructions!$E$67))","v":15.217391304347826},315,9.4173913043478272,169.5130434782609,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54.545454545454547,91.935483870967744]
["Nachos ",16,1.5,10,{"$f":"D16*(100/(100+Instructions!$E$67))","v":8.695652173913043},160,7.195652173913043,115.13043478260869,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48.484848484848484,70.246179966044139]
["Pumpkin Soup ",16,0.6,6,{"$f":"D17*(100/(100+Instructions!$E$67))","v":5.2173913043478262},96,4.6173913043478265,73.878260869565224,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48.484848484848484,45.07640067911715]
["Mango with liqueur",15,1.8,6.5,{"$f":"D18*(100/(100+Instructions!$E$67))","v":5.6521739130434785},97.5,3.8521739130434787,57.782608695652179,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45.454545454545453,37.606112054329373]
["Chilli chicken breast with kumera",12,3.3,14.5,{"$f":"D19*(100/(100+Instructions!$E$67))","v":12.608695652173912},174,9.3086956521739133,111.70434782608696,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36.36363636363636,90.874363327674018]
["Fettuccine - chicken & mushroom ",12,2.6,11.5,{"$f":"D20*(100/(100+Instructions!$E$67))","v":10},138,7.4,88.800000000000011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36.36363636363636,72.241086587436328]
["Strawberry Coppa Gelato",12,1.2,8.5,{"$f":"D21*(100/(100+Instructions!$E$67))","v":7.3913043478260869},102,6.1913043478260867,74.295652173913041,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36.36363636363636,60.44142614601018]
["Bruschetta",10,1.5,6.5,{"$f":"D22*(100/(100+Instructions!$E$67))","v":5.6521739130434785},65,4.1521739130434785,41.521739130434781,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30.303030303030305,40.534804753820033]
["Caesar Salad ",8,2.2000000000000002,8.9,{"$f":"D23*(100/(100+Instructions!$E$67))","v":7.7391304347826084},71.2,5.5391304347826082,44.313043478260866,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24.242424242424242,54.07470288624787]
["Grilled Snapper with fennel",7,6.5,15.5,{"$f":"D24*(100/(100+Instructions!$E$67))","v":13.478260869565217},108.5,6.9782608695652169,48.847826086956516,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21.212121212121211,68.123938879456688]
["Chicken Focaccia",7,3.7,7.9,{"$f":"D25*(100/(100+Instructions!$E$67))","v":6.8695652173913047},55.300000000000004,3.1695652173913045,22.18695652173913,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21.212121212121211,30.94227504244482]
["Sirloin Steak with Parisian Butter",6,5.2,15,{"$f":"D26*(100/(100+Instructions!$E$67))","v":13.043478260869565},90,7.8434782608695643,47.060869565217388,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.18181818181818,76.570458404074685]
["Penne Arrabiata ",5,2,9.9,{"$f":"D27*(100/(100+Instructions!$E$67))","v":8.608695652173914},49.5,6.608695652173914,33.04347826086957,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.151515151515152,64.516129032258064]
["Mediterranean Focaccia",5,3,7.9,{"$f":"D28*(100/(100+Instructions!$E$67))","v":6.8695652173913047},39.5,3.8695652173913047,19.347826086956523,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.151515151515152,37.775891341256369]
["Toscana Focaccia",5,1.5,7.5,{"$f":"D29*(100/(100+Instructions!$E$67))","v":6.5217391304347823},37.5,5.0217391304347823,25.10869565217391,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.151515151515152,49.023769100169773]
["Prawn Caesar Salad",4,2.8,15,{"$f":"D30*(100/(100+Instructions!$E$67))","v":13.043478260869565},60,10.243478260869566,40.973913043478262,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.121212121212121,100]
[null,null,null,null,{"$f":"D31*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D32*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D33*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D34*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D35*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D36*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D37*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D38*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D39*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D40*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D41*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D42*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D43*(100/(100+Instructions!$E$67))","v":0},{"$f":"B43*D43","v":0},{"$f":"IF(ISBLANK(D43),0,E43-C43)","v":0},{"$f":"IF(G43=\"\",\"\",B43*G43)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(B43),NA(),B43*(AA$9/AA$8))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C43),NA(),G43*(AB$9/AB$8))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"D44*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D45*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D46*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D47*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D48*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D49*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D50*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D51*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D52*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D53*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D54*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D55*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D56*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D57*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D58*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D59*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D60*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D61*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D62*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D63*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D64*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D65*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D66*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D67*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D68*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D69*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D70*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D71*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D72*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D73*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D74*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D75*(100/(100+Instructions!$E$67))","v":0},{"$f":"B75*D75","v":0},{"$f":"IF(ISBLANK(D75),0,E75-C75)","v":0},{"$f":"IF(G75=\"\",\"\",B75*G75)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(B75),NA(),B75*(AA$9/AA$8))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C75),NA(),G75*(AB$9/AB$8))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"D76*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D77*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D78*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D79*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D80*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D81*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D82*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D83*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D84*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D85*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D86*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D87*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D88*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D89*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D90*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D91*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D92*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D93*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D94*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D95*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D96*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D97*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D98*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D99*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D100*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D101*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D102*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D103*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D104*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D105*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D106*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D107*(100/(100+Instructions!$E$67))","v":0},0,0,{"$f":"IF(G107=\"\",\"\",B107*G107)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D108*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D109*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D110*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Template","index":3,"n_rows":110,"n_cols":28,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
["Menu Profitability Analysis"]
[]
["Totals:",{"$f":"SUM(B11:B110)","v":0},null,null,null,{"$f":"SUM(F11:F110)","v":0},null,{"$f":"SUM(H11:H110)","v":0}]
[]
[null,null,null,null,null,null,"Gross Profit %",{"$f":"IF(F3=0,0,H3/F3)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(B11:B110)","v":0},{"$f":"MAX(G11:G110)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,100]
[{"$f":"\"Menu Item\"&TEXT(NOW(),\"\")","v":"Menu Item"},"Number Sold","Cost of Item","Selling Price    (inc GST)","Net Selling Price (without GST)","Total Gross Sales        (inc GST)","Gross Profit per Item (without GST)","Total Gross Profit (without GST)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# prop","GP prop"]
[null,null,null,null,{"$f":"D11*(100/(100+Instructions!$E$67))","v":0},{"$f":"B11*D11","v":0},{"$f":"IF(ISBLANK(D11),0,E11-C11)","v":0},{"$f":"IF(G11=\"\",\"\",B11*G11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(B11),NA(),B11*(AA$9/AA$8))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C11),NA(),G11*(AB$9/AB$8))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"D12*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D13*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D14*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D15*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D16*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D17*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D18*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D19*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D20*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D21*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D22*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D23*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D24*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D25*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D26*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D27*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D28*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D29*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D30*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D31*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D32*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D33*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D34*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D35*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D36*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D37*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D38*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D39*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D40*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D41*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D42*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D43*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D44*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D45*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D46*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D47*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D48*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D49*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D50*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D51*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D52*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D53*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D54*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D55*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D56*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D57*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D58*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D59*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D60*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D61*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D62*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D63*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D64*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D65*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D66*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D67*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D68*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D69*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D70*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D71*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D72*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D73*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D74*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D75*(100/(100+Instructions!$E$67))","v":0},{"$f":"B75*D75","v":0},{"$f":"IF(ISBLANK(D75),0,E75-C75)","v":0},{"$f":"IF(G75=\"\",\"\",B75*G75)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(B75),NA(),B75*(AA$9/AA$8))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C75),NA(),G75*(AB$9/AB$8))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"D76*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D77*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D78*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D79*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D80*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D81*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D82*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D83*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D84*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D85*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D86*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D87*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D88*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D89*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D90*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D91*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D92*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D93*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D94*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D95*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D96*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D97*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D98*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D99*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D100*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D101*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D102*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D103*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D104*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D105*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D106*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D107*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D108*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D109*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"D110*(100/(100+Instructions!$E$67))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]