{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Info Sheet","4th","ScoreSheet","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Info Sheet","index":0,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,"Period",4]
[null,"Team",{"$f":"CONCATENATE($C$1,\"-\",1)","v":"4-1"},"EVALS"]
[1]
[1]
[1]
[1,null,null,null,{"$f":"COUNTA(C3:C6)","v":0}]
[null,"Team",{"$f":"CONCATENATE($C$1,\"-\",2)","v":"4-2"}]
[2]
[2]
[2]
[2,null,null,null,{"$f":"COUNTA(C8:C11)","v":0}]
[null,"Team",{"$f":"CONCATENATE($C$1,\"-\",3)","v":"4-3"}]
[3]
[3]
[3]
[3,null,null,null,{"$f":"COUNTA(C13:C16)","v":0}]
[null,"Team",{"$f":"CONCATENATE($C$1,\"-\",4)","v":"4-4"}]
[4]
[4]
[4]
[4,null,null,null,{"$f":"COUNTA(C18:C21)","v":0}]
[null,"Team",{"$f":"CONCATENATE($C$1,\"-\",5)","v":"4-5"}]
[5]
[5]
[5]
[5,null,null,null,{"$f":"COUNTA(C23:C26)","v":0}]
[null,"Team",{"$f":"CONCATENATE($C$1,\"-\",6)","v":"4-6"}]
[6]
[6]
[6]
[6,null,null,null,{"$f":"COUNTA(C28:C31)","v":0}]
[null,"Team",{"$f":"CONCATENATE($C$1,\"-\",7)","v":"4-7"}]
[7]
[7]
[7]
[7,null,null,null,{"$f":"COUNTA(C33:C36)","v":0}]
[null,"Team",{"$f":"CONCATENATE($C$1,\"-\",8)","v":"4-8"}]
[8]
[8]
[8]
[8,null,null,null,{"$f":"COUNTA(C38:C41)","v":0}]
[null,"Team",{"$f":"CONCATENATE($C$1,\"-\",9)","v":"4-9"}]
[9]
[9]
[9]
[9,null,null,null,{"$f":"COUNTA(C43:C46)","v":0}]

{"sheet":"4th","index":1,"n_rows":126,"n_cols":16,"rows_kept":126,"cut":false,"hidden":false,"merged":[[125,5,125,8],[125,9,125,11],[122,15,124,15],[123,1,123,2],[123,6,123,8],[123,9,123,11],[123,13,123,14],[124,1,124,2],[124,6,124,8],[124,9,124,11],[124,13,124,14],[119,0,121,0],[121,5,121,11],[121,12,124,12],[121,13,121,14],[122,0,124,0],[122,1,122,2],[122,6,122,8],[122,9,122,11],[122,13,122,14],[114,10,116,10],[114,11,116,11],[114,12,116,12],[114,13,116,13],[114,14,116,14],[114,15,116,15],[114,0,118,0],[114,1,114,2],[114,6,116,6],[114,7,116,7],[114,8,116,8],[114,9,116,9],[115,1,115,2],[116,1,116,2],[117,1,117,2],[118,1,118,2],[111,5,111,8],[111,9,111,11],[112,1,112,4],[113,0,113,4],[113,5,113,11],[113,12,113,15],[108,15,110,15],[109,1,109,2],[109,6,109,8],[109,9,109,11],[109,13,109,14],[110,1,110,2],[110,6,110,8],[110,9,110,11],[110,13,110,14],[105,0,107,0],[107,5,107,11],[107,12,110,12],[107,13,107,14],[108,0,110,0],[108,1,108,2],[108,6,108,8],[108,9,108,11],[108,13,108,14],[100,10,102,10],[100,11,102,11],[100,12,102,12],[100,13,102,13],[100,14,102,14],[100,15,102,15],[100,0,104,0],[100,1,100,2],[100,6,102,6],[100,7,102,7],[100,8,102,8],[100,9,102,9],[101,1,101,2],[102,1,102,2],[103,1,103,2],[104,1,104,2],[97,5,97,8],[97,9,97,11],[98,1,98,4],[99,0,99,4],[99,5,99,11],[99,12,99,15],[94,15,96,15],[95,1,95,2],[95,6,95,8],[95,9,95,11],[95,13,95,14],[96,1,96,2],[96,6,96,8],[96,9,96,11],[96,13,96,14],[91,0,93,0],[93,5,93,11],[93,12,96,12],[93,13,93,14],[94,0,96,0],[94,1,94,2],[94,6,94,8],[94,9,94,11],[94,13,94,14],[86,10,88,10],[86,11,88,11],[86,12,88,12],[86,13,88,13],[86,14,88,14],[86,15,88,15],[86,0,90,0],[86,1,86,2],[86,6,88,6],[86,7,88,7],[86,8,88,8],[86,9,88,9],[87,1,87,2],[88,1,88,2],[89,1,89,2],[90,1,90,2],[83,5,83,8],[83,9,83,11],[84,1,84,4],[85,0,85,4],[85,5,85,11],[85,12,85,15],[80,15,82,15],[81,1,81,2],[81,6,81,8],[81,9,81,11],[81,13,81,14],[82,1,82,2],[82,6,82,8],[82,9,82,11],[82,13,82,14],[77,0,79,0],[79,5,79,11],[79,12,82,12],[79,13,79,14],[80,0,82,0],[80,1,80,2],[80,6,80,8],[80,9,80,11],[80,13,80,14],[72,10,74,10],[72,11,74,11],[72,12,74,12],[72,13,74,13],[72,14,74,14],[72,15,74,15],[72,0,76,0],[72,1,72,2],[72,6,74,6],[72,7,74,7],[72,8,74,8],[72,9,74,9],[73,1,73,2],[74,1,74,2],[75,1,75,2],[76,1,76,2],[69,5,69,8],[69,9,69,11],[70,1,70,4],[71,0,71,4],[71,5,71,11],[71,12,71,15],[66,15,68,15],[67,1,67,2],[67,6,67,8],[67,9,67,11],[67,13,67,14],[68,1,68,2],[68,6,68,8],[68,9,68,11],[68,13,68,14],[63,0,65,0],[65,5,65,11],[65,12,68,12],[65,13,65,14],[66,0,68,0],[66,1,66,2],[66,6,66,8],[66,9,66,11],[66,13,66,14],[58,10,60,10],[58,11,60,11],[58,12,60,12],[58,13,60,13],[58,14,60,14],[58,15,60,15],[58,0,62,0],[58,1,58,2],[58,6,60,6],[58,7,60,7],[58,8,60,8],[58,9,60,9],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[55,5,55,8],[55,9,55,11],[56,1,56,4],[57,0,57,4],[57,5,57,11],[57,12,57,15],[52,15,54,15],[53,1,53,2],[53,6,53,8],[53,9,53,11],[53,13,53,14],[54,1,54,2],[54,6,54,8],[54,9,54,11],[54,13,54,14],[49,0,51,0],[51,5,51,11],[51,12,54,12],[51,13,51,14],[52,0,54,0],[52,1,52,2],[52,6,52,8],[52,9,52,11],[52,13,52,14],[44,10,46,10],[44,11,46,11],[44,12,46,12],[44,13,46,13],[44,14,46,14],[44,15,46,15],[44,0,48,0],[44,1,44,2],[44,6,46,6],[44,7,46,7],[44,8,46,8],[44,9,46,9],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[42,1,42,4],[43,0,43,4],[43,5,43,11],[43,12,43,15],[41,5,41,8],[41,9,41,11],[38,15,40,15],[39,1,39,2],[39,6,39,8],[39,9,39,11],[39,13,39,14],[40,1,40,2],[40,6,40,8],[40,9,40,11],[40,13,40,14],[35,0,37,0],[37,5,37,11],[37,12,40,12],[37,13,37,14],[38,0,40,0],[38,1,38,2],[38,6,38,8],[38,9,38,11],[38,13,38,14],[30,10,32,10],[30,11,32,11],[30,12,32,12],[30,13,32,13],[30,14,32,14],[30,15,32,15],[30,0,34,0],[30,1,30,2],[30,6,32,6],[30,7,32,7],[30,8,32,8],[30,9,32,9],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[27,5,27,8],[27,9,27,11],[28,1,28,4],[29,0,29,4],[29,5,29,11],[29,12,29,15],[24,15,26,15],[25,1,25,2],[25,6,25,8],[25,9,25,11],[25,13,25,14],[26,1,26,2],[26,6,26,8],[26,9,26,11],[26,13,26,14],[23,5,23,11],[23,12,26,12],[23,13,23,14],[24,0,26,0],[24,1,24,2],[24,6,24,8],[24,9,24,11],[24,13,24,14],[21,0,23,0],[16,11,18,11],[16,12,18,12],[16,13,18,13],[16,14,18,14],[16,15,18,15],[17,1,17,2],[18,1,18,2],[10,15,12,15],[14,1,14,4],[15,0,15,4],[15,5,15,11],[15,12,15,15],[16,0,20,0],[16,1,16,2],[16,6,18,6],[16,7,18,7],[16,8,18,8],[16,9,18,9],[16,10,18,10],[11,1,11,2],[12,1,12,2],[19,1,19,2],[20,1,20,2],[13,9,13,11],[13,5,13,8],[10,6,10,8],[11,6,11,8],[12,6,12,8],[10,9,10,11],[11,9,11,11],[12,9,12,11],[2,6,4,6],[2,7,4,7],[2,8,4,8],[2,9,4,9],[2,10,4,10],[2,11,4,11],[9,5,9,11],[0,1,0,4],[1,0,1,4],[9,13,9,14],[10,13,10,14],[11,13,11,14],[12,13,12,14],[9,12,12,12],[2,0,6,0],[7,0,9,0],[10,0,12,0],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[10,1,10,2],[2,12,4,12],[2,13,4,13],[2,14,4,14],[1,12,1,15],[2,15,4,15],[1,5,1,11]]}
["Group:",{"$f":"'Info Sheet'!C2","v":"4-1"}]
["Group Grade",null,null,null,null,"Individual Grade",null,null,null,null,null,null,"Points Pay"]
["Packet","Slogan, Team Name",null,4,null,null,"Evaluation","Total","Inventory","Total","Overall","Final Score","Packet Pay","Eval Pay","Ad pay","Total Pay"]
[null,"Logo",null,4]
[null,"Research",null,4]
[null,"Inventory",null,4,null,{"$f":"N10","v":0},{"$f":"'Info Sheet'!D3","v":0},100,null,{"$f":"I6*4","v":0},{"$f":"(G6+J6)/116","v":0},{"$f":"VLOOKUP(K6,score,2,TRUE)","v":0},{"$f":"$E$14*80","v":0},{"$f":"IF(L6>=0.8,M6,IF(L6<0.8,M6*L6))","v":0},{"$f":"$J$14","v":{"$error":"#N/A"}},{"$f":"N6+O6","v":{"$error":"#N/A"}}]
[null,"Checklists",null,4,null,{"$f":"N11","v":0},{"$f":"'Info Sheet'!D4","v":0},100,null,0,0,{"$f":"VLOOKUP(K7,score,2,TRUE)","v":0},{"$f":"$E$14*80","v":0},0,{"$f":"$J$14","v":{"$error":"#N/A"}},{"$f":"N7+O7","v":{"$error":"#N/A"}}]
["Ads","Ad 1",null,4,null,{"$f":"N12","v":0},{"$f":"'Info Sheet'!D5","v":0},100,null,{"$f":"I8*4","v":0},{"$f":"(G8+J8)/116","v":0},{"$f":"VLOOKUP(K8,score,2,TRUE)","v":0},0,{"$f":"IF(L8>=0.8,M8,IF(L8<0.8,M8*L8))","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ad 2",null,4,null,{"$f":"N13","v":0},{"$f":"'Info Sheet'!D6","v":0},100,null,0,0,{"$f":"VLOOKUP(K9,score,2,TRUE)","v":0},0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ad 3",null,4,null,"Ad Type Pay",null,null,null,null,null,null,"Group Names:",{"$f":"'Info Sheet'!C3","v":0},null,"# Members"]
["Presentation","Preparation",null,4,null,{"$f":"C8","v":0},{"$f":"VLOOKUP(F11,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E8=4,G11*12,E8*G11)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C4","v":0},null,{"$f":"'Info Sheet'!E6","v":0}]
[null,"Attention",null,4,null,{"$f":"C9","v":0},{"$f":"VLOOKUP(F12,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E9=4,G12*12,E9*G12)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C5","v":0}]
[null,"Audience",null,4,null,0,{"$f":"VLOOKUP(F13,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},null,null,null,{"$f":"'Info Sheet'!C6","v":0}]
[null,null,"Total:",55,{"$f":"SUM(E3:E13)","v":0},null,null,null,null,{"$f":"SUM(J11:J13)","v":{"$error":"#N/A"}},null,null,null,null,"Extra Ads"]
["Group:",{"$f":"'Info Sheet'!C7","v":"4-2"}]
["Group Grade",null,null,null,null,"Individual Grade",null,null,null,null,null,null,"Points Pay"]
["Packet","Slogan, Team Name",null,4,null,null,"Evaluation","Total","Inventory","Total","Overall","Final Score","Packet Pay","Eval Pay","Ad pay","Total Pay"]
[null,"Logo",null,4]
[null,"Research",null,4]
[null,"Inventory",null,4,null,{"$f":"N24","v":0},{"$f":"'Info Sheet'!D8","v":0},100,null,{"$f":"I20*4","v":0},{"$f":"(G20+J20)/116","v":0},{"$f":"VLOOKUP(K20,score,2,TRUE)","v":0},{"$f":"$E$28*80","v":0},{"$f":"IF(K20>=0.8,(M20+O20),(M20+O20)*K20)","v":{"$error":"#N/A"}},{"$f":"$J$28","v":{"$error":"#N/A"}},{"$f":"N20","v":{"$error":"#N/A"}}]
[null,"Checklists",null,4,null,{"$f":"N25","v":0},{"$f":"'Info Sheet'!D9","v":0},100,null,0,0,{"$f":"VLOOKUP(K21,score,2,TRUE)","v":0},{"$f":"$E$28*80","v":0},{"$f":"IF(K21>=0.8,(M21+O21),(M21+O21)*K21)","v":{"$error":"#N/A"}},{"$f":"$J$28","v":{"$error":"#N/A"}},{"$f":"N21","v":{"$error":"#N/A"}}]
["Ads","Ad 1",null,4,null,{"$f":"N26","v":0},{"$f":"'Info Sheet'!D10","v":0},100,null,{"$f":"I22*4","v":0},{"$f":"(G22+J22)/116","v":0},{"$f":"VLOOKUP(K22,score,2,TRUE)","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ad 2",null,4,null,{"$f":"N27","v":0},{"$f":"'Info Sheet'!D11","v":0},100,null,0,0,{"$f":"VLOOKUP(K23,score,2,TRUE)","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ad 3",null,4,null,"Ad Type Pay",null,null,null,null,null,null,"Group Names:",{"$f":"'Info Sheet'!C8","v":0},null,"# Members"]
["Presentation","Preparation",null,4,null,{"$f":"C22","v":0},{"$f":"VLOOKUP(F25,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E22=4,G25*12,E22*G25)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C9","v":0},null,{"$f":"'Info Sheet'!E11","v":0}]
[null,"Attention",null,4,null,{"$f":"C23","v":0},{"$f":"VLOOKUP(F26,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E23=4,G26*12,E23*G26)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C10","v":0}]
[null,"Audience",null,4,null,0,{"$f":"VLOOKUP(F27,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},null,null,null,{"$f":"'Info Sheet'!C11","v":0}]
[null,null,"Total:",{"$f":"SUM(D17:D27)","v":44},{"$f":"SUM(E17:E27)","v":0},null,null,null,null,{"$f":"SUM(J25:J27)","v":{"$error":"#N/A"}},null,null,null,null,"Extra Ads"]
["Group:",{"$f":"'Info Sheet'!C12","v":"4-3"}]
["Group Grade",null,null,null,null,"Individual Grade",null,null,null,null,null,null,"Points Pay"]
["Packet","Slogan, Team Name",null,4,null,null,"Evaluation","Total","Inventory","Total","Overall","Final Score","Packet Pay","Eval Pay","Ad pay","Total Pay"]
[null,"Logo",null,4]
[null,"Research",null,4]
[null,"Inventory",null,4,null,{"$f":"N38","v":0},{"$f":"'Info Sheet'!D13","v":0},100,null,{"$f":"I34*4","v":0},{"$f":"(G34+J34)/116","v":0},{"$f":"VLOOKUP(K34,score,2,TRUE)","v":0},{"$f":"$E$42*80","v":0},{"$f":"IF(L34>=0.8,M34,IF(L34<0.8,M34*L34))","v":0},{"$f":"$J$42","v":{"$error":"#N/A"}},{"$f":"N34+O34+$P$42","v":{"$error":"#N/A"}}]
[null,"Checklists",null,4,null,{"$f":"N39","v":0},{"$f":"'Info Sheet'!D14","v":0},100,null,0,0,{"$f":"VLOOKUP(K35,score,2,TRUE)","v":0},{"$f":"$E$42*80","v":0},0,{"$f":"$J$42","v":{"$error":"#N/A"}},{"$f":"N35+O35+$P$42","v":{"$error":"#N/A"}}]
["Ads","Ad 1",null,4,null,{"$f":"N40","v":0},{"$f":"'Info Sheet'!D15","v":0},100,null,{"$f":"I36*4","v":0},{"$f":"(G36+J36)/116","v":0},{"$f":"VLOOKUP(K36,score,2,TRUE)","v":0},0,{"$f":"IF(L36>=0.8,M36,IF(L36<0.8,M36*L36))","v":0},{"$error":"#N/A"},{"$f":"N36+O36+$P$42","v":{"$error":"#N/A"}}]
[null,"Ad 2",null,4,null,{"$f":"N41","v":0},{"$f":"'Info Sheet'!D16","v":0},100,null,0,0,{"$f":"VLOOKUP(K37,score,2,TRUE)","v":0},0,0,{"$error":"#N/A"},{"$f":"N37+O37+$P$42","v":{"$error":"#N/A"}}]
[null,"Ad 3",null,4,null,"Ad Type Pay",null,null,null,null,null,null,"Group Names:",{"$f":"'Info Sheet'!C13","v":0},null,"# Members"]
["Presentation","Preparation",null,4,null,{"$f":"C36","v":0},{"$f":"VLOOKUP(F39,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E36=4,G39*12,E36*G39)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C14","v":0},null,{"$f":"'Info Sheet'!E16","v":0}]
[null,"Attention",null,4,null,{"$f":"C37","v":0},{"$f":"VLOOKUP(F40,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E37=4,G40*12,E37*G40)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C15","v":0}]
[null,"Audience",null,4,null,0,{"$f":"VLOOKUP(F41,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},null,null,null,{"$f":"'Info Sheet'!C16","v":0}]
[null,null,"Total:",55,{"$f":"SUM(E31:E41)","v":0},null,null,null,null,{"$f":"SUM(J39:J41)+P42","v":{"$error":"#N/A"}},null,null,null,null,"Extra Ads"]
["Group:",{"$f":"'Info Sheet'!C17","v":"4-4"}]
["Group Grade",null,null,null,null,"Individual Grade",null,null,null,null,null,null,"Points Pay"]
["Packet","Slogan, Team Name",null,4,null,null,"Evaluation","Total","Inventory","Total","Overall","Final Score","Packet Pay","Eval Pay","Ad pay","Total Pay"]
[null,"Logo",null,4]
[null,"Research",null,4]
[null,"Inventory",null,4,null,{"$f":"N52","v":0},{"$f":"'Info Sheet'!D18","v":0},100,null,{"$f":"I48*4","v":0},{"$f":"(G48+J48)/116","v":0},{"$f":"VLOOKUP(K48,score,2,TRUE)","v":0},{"$f":"$E$56*80","v":0},{"$f":"IF(K48>=0.8,(M48+O48),(M48+O48)*K48)","v":{"$error":"#N/A"}},{"$f":"$J$56","v":{"$error":"#N/A"}},{"$f":"N48","v":{"$error":"#N/A"}}]
[null,"Checklists",null,4,null,{"$f":"N53","v":0},{"$f":"'Info Sheet'!D19","v":0},100,null,0,0,{"$f":"VLOOKUP(K49,score,2,TRUE)","v":0},{"$f":"$E$56*80","v":0},{"$f":"IF(K49>=0.8,(M49+O49),(M49+O49)*K49)","v":{"$error":"#N/A"}},{"$f":"$J$56","v":{"$error":"#N/A"}},{"$f":"N49","v":{"$error":"#N/A"}}]
["Ads","Ad 1",null,4,null,{"$f":"N54","v":0},{"$f":"'Info Sheet'!D20","v":0},100,null,{"$f":"I50*4","v":0},{"$f":"(G50+J50)/116","v":0},{"$f":"VLOOKUP(K50,score,2,TRUE)","v":0},0,{"$error":"#N/A"},{"$f":"$J$56","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,"Ad 2",null,4,null,{"$f":"N55","v":0},{"$f":"'Info Sheet'!D21","v":0},100,null,0,0,{"$f":"VLOOKUP(K51,score,2,TRUE)","v":0},0,{"$error":"#N/A"},{"$f":"$J$56","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,"Ad 3",null,4,null,"Ad Type Pay",null,null,null,null,null,null,"Group Names:",{"$f":"'Info Sheet'!C18","v":0},null,"# Members"]
["Presentation","Preparation",null,4,null,{"$f":"C50","v":0},{"$f":"VLOOKUP(F53,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E50=4,G53*12,E50*G53)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C19","v":0},null,{"$f":"'Info Sheet'!E21","v":0}]
[null,"Attention",null,4,null,{"$f":"C51","v":0},{"$f":"VLOOKUP(F54,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E51=4,G54*12,E51*G54)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C20","v":0}]
[null,"Audience",null,4,null,0,{"$f":"VLOOKUP(F55,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},null,null,null,{"$f":"'Info Sheet'!C21","v":0}]
[null,null,"Total:",55,{"$f":"SUM(E45:E55)","v":0},null,null,null,null,{"$f":"SUM(J53:J55)","v":{"$error":"#N/A"}},null,null,null,null,"Extra Ads"]
["Group:",{"$f":"'Info Sheet'!C22","v":"4-5"}]
["Group Grade",null,null,null,null,"Individual Grade",null,null,null,null,null,null,"Points Pay"]
["Packet","Slogan, Team Name",null,4,null,null,"Evaluation","Total","Inventory","Total","Overall","Final Score","Packet Pay","Eval Pay","Ad pay","Total Pay"]
[null,"Logo",null,4]
[null,"Research",null,4]
[null,"Inventory",null,4,null,{"$f":"N66","v":0},{"$f":"'Info Sheet'!D23","v":0},100,null,{"$f":"I62*4","v":0},{"$f":"(G62+J62)/116","v":0},{"$f":"VLOOKUP(K62,score,2,TRUE)","v":0},{"$f":"$E$70*80","v":0},{"$f":"IF(K62>=0.8,(M62+O62),(M62+O62)*K62)","v":{"$error":"#N/A"}},{"$f":"$J$70","v":{"$error":"#N/A"}},{"$f":"N62","v":{"$error":"#N/A"}}]
[null,"Checklists",null,4,null,{"$f":"N67","v":0},{"$f":"'Info Sheet'!D24","v":0},100,null,0,0,{"$f":"VLOOKUP(K63,score,2,TRUE)","v":0},{"$f":"$E$70*80","v":0},{"$f":"IF(K63>=0.8,(M63+O63),(M63+O63)*K63)","v":{"$error":"#N/A"}},{"$f":"$J$70","v":{"$error":"#N/A"}},{"$f":"N63","v":{"$error":"#N/A"}}]
["Ads","Ad 1",null,4,null,{"$f":"N68","v":0},{"$f":"'Info Sheet'!D25","v":0},100,null,{"$f":"I64*4","v":0},{"$f":"(G64+J64)/116","v":0},{"$f":"VLOOKUP(K64,score,2,TRUE)","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ad 2",null,4,null,{"$f":"N69","v":0},{"$f":"'Info Sheet'!D26","v":0},100,null,0,0,{"$f":"VLOOKUP(K65,score,2,TRUE)","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ad 3",null,4,null,"Ad Type Pay",null,null,null,null,null,null,"Group Names:",{"$f":"'Info Sheet'!C23","v":0},null,"# Members"]
["Presentation","Preparation",null,4,null,{"$f":"C64","v":0},{"$f":"VLOOKUP(F67,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E64=4,G67*12,E64*G67)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C24","v":0},null,{"$f":"'Info Sheet'!E26","v":0}]
[null,"Attention",null,4,null,{"$f":"C65","v":0},{"$f":"VLOOKUP(F68,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E65=4,G68*12,E65*G68)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C25","v":0}]
[null,"Audience",null,4,null,0,{"$f":"VLOOKUP(F69,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},null,null,null,{"$f":"'Info Sheet'!C26","v":0}]
[null,null,"Total:",55,{"$f":"SUM(E59:E69)","v":0},null,null,null,null,{"$f":"SUM(J67:J69)","v":{"$error":"#N/A"}},null,null,null,null,"Extra Ads"]
["Group:",{"$f":"'Info Sheet'!C27","v":"4-6"}]
["Group Grade",null,null,null,null,"Individual Grade",null,null,null,null,null,null,"Points Pay"]
["Packet","Slogan, Team Name",null,4,null,null,"Evaluation","Total","Inventory","Total","Overall","Final Score","Packet Pay","Eval Pay","Ad pay","Total Pay"]
[null,"Logo",null,4]
[null,"Research",null,4]
[null,"Inventory",null,4,null,{"$f":"N80","v":0},{"$f":"'Info Sheet'!D28","v":0},100,null,16,{"$f":"(G76+J76)/116","v":0.13793103448275862},{"$f":"VLOOKUP(K76,score,2,TRUE)","v":0},{"$f":"$E$84*80","v":0},{"$f":"IF(K76>=0.8,(M76+O76),(M76+O76)*K76)","v":{"$error":"#N/A"}},{"$f":"$J$84","v":{"$error":"#N/A"}},{"$f":"N76","v":{"$error":"#N/A"}}]
[null,"Checklists",null,4,null,{"$f":"N81","v":0},{"$f":"'Info Sheet'!D29","v":0},100,null,12,0.10344827586206896,{"$f":"VLOOKUP(K77,score,2,TRUE)","v":0},{"$f":"$E$84*80","v":0},{"$f":"IF(K77>=0.8,(M77+O77),(M77+O77)*K77)","v":{"$error":"#N/A"}},{"$f":"$J$84","v":{"$error":"#N/A"}},{"$f":"N77","v":{"$error":"#N/A"}}]
["Ads","Ad 1",null,4,null,{"$f":"N82","v":0},{"$f":"'Info Sheet'!D30","v":0},100,null,16,{"$f":"(G78+J78)/116","v":0.13793103448275862},{"$f":"VLOOKUP(K78,score,2,TRUE)","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ad 2",null,4,null,{"$f":"N83","v":0},{"$f":"'Info Sheet'!D31","v":0},100,null,16,0.13793103448275862,{"$f":"VLOOKUP(K79,score,2,TRUE)","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ad 3",null,4,null,"Ad Type Pay",null,null,null,null,null,null,"Group Names:",{"$f":"'Info Sheet'!C28","v":0},null,"# Members"]
["Presentation","Preparation",null,4,null,{"$f":"C78","v":0},{"$f":"VLOOKUP(F81,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E78=4,G81*12,E78*G81)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C29","v":0},null,{"$f":"'Info Sheet'!E31","v":0}]
[null,"Attention",null,4,null,{"$f":"C79","v":0},{"$f":"VLOOKUP(F82,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E79=4,G82*12,E79*G82)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C30","v":0}]
[null,"Audience",null,4,null,0,{"$f":"VLOOKUP(F83,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},null,null,null,{"$f":"'Info Sheet'!C31","v":0}]
[null,null,"Total:",55,{"$f":"SUM(E73:E83)","v":0},null,null,null,null,{"$f":"SUM(J81:J83)","v":{"$error":"#N/A"}},null,null,null,null,"Extra Ads"]
["Group:",{"$f":"'Info Sheet'!C32","v":"4-7"}]
["Group Grade",null,null,null,null,"Individual Grade",null,null,null,null,null,null,"Points Pay"]
["Packet","Slogan, Team Name",null,4,null,null,"Evaluation","Total","Inventory","Total","Overall","Final Score","Packet Pay","Eval Pay","Ad pay","Total Pay"]
[null,"Logo",null,4]
[null,"Research",null,4]
[null,"Inventory",null,4,null,{"$f":"N94","v":0},{"$f":"'Info Sheet'!D33","v":0},100,null,{"$f":"I90*4","v":0},{"$f":"(G90+J90)/116","v":0},{"$f":"VLOOKUP(K90,score,2,TRUE)","v":0},{"$f":"$E$98*80","v":0},{"$f":"IF(K90>=0.8,(M90+O90),(M90+O90)*K90)","v":{"$error":"#N/A"}},{"$f":"$J$98","v":{"$error":"#N/A"}},{"$f":"N90","v":{"$error":"#N/A"}}]
[null,"Checklists",null,4,null,{"$f":"N95","v":0},{"$f":"'Info Sheet'!D34","v":0},100,null,0,0,{"$f":"VLOOKUP(K91,score,2,TRUE)","v":0},{"$f":"$E$98*80","v":0},{"$f":"IF(K91>=0.8,(M91+O91),(M91+O91)*K91)","v":{"$error":"#N/A"}},{"$f":"$J$98","v":{"$error":"#N/A"}},{"$f":"N91","v":{"$error":"#N/A"}}]
["Ads","Ad 1",null,4,null,{"$f":"N96","v":0},{"$f":"'Info Sheet'!D35","v":0},100,null,{"$f":"I92*4","v":0},{"$f":"(G92+J92)/116","v":0},{"$f":"VLOOKUP(K92,score,2,TRUE)","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ad 2",null,4,null,{"$f":"N97","v":0},{"$f":"'Info Sheet'!D36","v":0},100,null,0,0,{"$f":"VLOOKUP(K93,score,2,TRUE)","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ad 3",null,4,null,"Ad Type Pay",null,null,null,null,null,null,"Group Names:",{"$f":"'Info Sheet'!C33","v":0},null,"# Members"]
["Presentation","Preparation",null,4,null,{"$f":"C92","v":0},{"$f":"VLOOKUP(F95,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E92=4,G95*12,E92*G95)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C34","v":0},null,{"$f":"'Info Sheet'!E36","v":0}]
[null,"Attention",null,4,null,{"$f":"C93","v":0},{"$f":"VLOOKUP(F96,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E93=4,G96*12,E93*G96)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C35","v":0}]
[null,"Audience",null,4,null,0,{"$f":"VLOOKUP(F97,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},null,null,null,{"$f":"'Info Sheet'!C36","v":0}]
[null,null,"Total:",55,{"$f":"SUM(E87:E97)","v":0},null,null,null,null,{"$f":"SUM(J95:J97)","v":{"$error":"#N/A"}},null,null,null,null,"Extra Ads"]
["Group:",{"$f":"'Info Sheet'!C37","v":"4-8"}]
["Group Grade",null,null,null,null,"Individual Grade",null,null,null,null,null,null,"Points Pay"]
["Packet","Slogan, Team Name",null,4,null,null,"Evaluation","Total","Inventory","Total","Overall","Final Score","Packet Pay","Eval Pay","Ad pay","Total Pay"]
[null,"Logo",null,4]
[null,"Research",null,4]
[null,"Inventory",null,4,null,{"$f":"N108","v":0},{"$f":"'Info Sheet'!D38","v":0},100,null,16,{"$f":"(G104+J104)/116","v":0.13793103448275862},{"$f":"VLOOKUP(K104,score,2,TRUE)","v":0},{"$f":"$E$112*80","v":0},{"$f":"IF(K104>=0.8,(M104+O104),(M104+O104)*K104)","v":{"$error":"#N/A"}},{"$f":"$J$112","v":{"$error":"#N/A"}},{"$f":"N104","v":{"$error":"#N/A"}}]
[null,"Checklists",null,4,null,{"$f":"N109","v":0},{"$f":"'Info Sheet'!D39","v":0},100,null,12,0.10344827586206896,{"$f":"VLOOKUP(K105,score,2,TRUE)","v":0},{"$f":"$E$112*80","v":0},{"$f":"IF(K105>=0.8,(M105+O105),(M105+O105)*K105)","v":{"$error":"#N/A"}},{"$f":"$J$112","v":{"$error":"#N/A"}},{"$f":"N105","v":{"$error":"#N/A"}}]
["Ads","Ad 1",null,4,null,{"$f":"N110","v":0},{"$f":"'Info Sheet'!D40","v":0},100,null,16,{"$f":"(G106+J106)/116","v":0.13793103448275862},{"$f":"VLOOKUP(K106,score,2,TRUE)","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ad 2",null,4,null,{"$f":"N111","v":0},{"$f":"'Info Sheet'!D41","v":0},100,null,16,0.13793103448275862,{"$f":"VLOOKUP(K107,score,2,TRUE)","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ad 3",null,4,null,"Ad Type Pay",null,null,null,null,null,null,"Group Names:",{"$f":"'Info Sheet'!C38","v":0},null,"# Members"]
["Presentation","Preparation",null,4,null,{"$f":"C106","v":0},{"$f":"VLOOKUP(F109,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E106=4,G109*12,E106*G109)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C39","v":0},null,{"$f":"'Info Sheet'!E41","v":0}]
[null,"Attention",null,4,null,{"$f":"C107","v":0},{"$f":"VLOOKUP(F110,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E107=4,G110*12,E107*G110)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C40","v":0}]
[null,"Audience",null,4,null,0,{"$f":"VLOOKUP(F111,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},null,null,null,{"$f":"'Info Sheet'!C41","v":0}]
[null,null,"Total:",55,{"$f":"SUM(E101:E111)","v":0},null,null,null,null,{"$f":"SUM(J109:J111)+P112","v":{"$error":"#N/A"}},null,null,null,null,"Extra Ads"]
["Group:",{"$f":"'Info Sheet'!C42","v":"4-9"}]
["Group Grade",null,null,null,null,"Individual Grade",null,null,null,null,null,null,"Points Pay"]
["Packet","Slogan, Team Name",null,2,null,null,"Evaluation","Total","Inventory","Total","Overall","Final Score","Packet Pay","Eval Pay","Ad pay","Total Pay"]
[null,"Logo",null,5]
[null,"Research",null,2]
[null,"Inventory",null,5,null,{"$f":"N122","v":0},{"$f":"'Info Sheet'!D43","v":0},100,null,5,{"$f":"(G118/2)+I118","v":0},{"$f":"K118/55","v":0},{"$f":"$E$126*80","v":0},{"$f":"IF(L118>=0.8,M118,IF(L118<0.8,M118*L118))","v":0},{"$f":"$J$126","v":{"$error":"#N/A"}},{"$f":"N118+O118+$P$126","v":{"$error":"#N/A"}}]
[null,"Checklists",null,5,null,{"$f":"N123","v":0},{"$f":"'Info Sheet'!D44","v":0},100,null,5,{"$f":"(G119/2)+I119","v":0},{"$f":"K119/55","v":0},{"$f":"$E$126*80","v":0},0,{"$f":"$J$126","v":{"$error":"#N/A"}},{"$f":"N119+O119+$P$126","v":{"$error":"#N/A"}}]
["Ads","Ad 1",null,10,null,{"$f":"N124","v":0},{"$f":"'Info Sheet'!D45","v":0},100,null,5,0,0,0,{"$f":"IF(L120>=0.8,M120,IF(L120<0.8,M120*L120))","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ad 2",null,10,null,{"$f":"N125","v":0},{"$f":"'Info Sheet'!D46","v":0},100,null,5,0,0,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ad 3",null,10,null,"Ad Type Pay",null,null,null,null,null,null,"Group Names:",{"$f":"'Info Sheet'!C43","v":0},null,"# Members"]
["Presentation","Preparation",null,2,null,{"$f":"C120","v":0},{"$f":"VLOOKUP(F123,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E120=4,G123*12,E120*G123)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C44","v":0},null,{"$f":"'Info Sheet'!E46","v":0}]
[null,"Attention",null,2,null,{"$f":"C121","v":0},{"$f":"VLOOKUP(F124,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(E121=4,G124*12,E121*G124)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Info Sheet'!C45","v":0}]
[null,"Audience",null,2,null,0,{"$f":"VLOOKUP(F125,adpay,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},null,null,null,{"$f":"'Info Sheet'!C46","v":0}]
[null,null,"Total:",55,{"$f":"SUM(E115:E125)","v":0},null,null,null,null,{"$f":"SUM(J123:J125)","v":{"$error":"#N/A"}},null,null,null,null,"Extra Ads"]

{"sheet":"ScoreSheet","index":2,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,3,0,5],[0,6,0,9]]}
[null,null,"Individual","Group",null,null,"Pay"]
["Group #","Name","Individual","Packet","Present","Adverts","Raw Pay","Extra","Total","Rounded"]
[{"$f":"'Info Sheet'!A44","v":9},{"$f":"'Info Sheet'!C44","v":0},{"$f":"'4th'!L119","v":0},{"$f":"VLOOKUP(SUM('4th'!$E$115:$E$119)/19,score,2,TRUE)","v":0},{"$f":"VLOOKUP(SUM('4th'!E124:E126)/6,score,2,TRUE)","v":0},{"$f":"VLOOKUP(SUM('4th'!E121:E123)/30,score,2,TRUE)","v":0},{"$f":"'4th'!P119","v":{"$error":"#N/A"}},{"$f":"'4th'!P127","v":0},{"$f":"'4th'!P109","v":0},{"$f":"ROUND(I3,-2)","v":0}]
[{"$f":"'Info Sheet'!A45","v":9},{"$f":"'Info Sheet'!C45","v":0},{"$f":"'4th'!L120","v":0},{"$f":"VLOOKUP(SUM('4th'!$E$115:$E$119)/19,score,2,TRUE)","v":0},{"$f":"VLOOKUP(SUM('4th'!E125:E127)/6,score,2,TRUE)","v":0},{"$f":"VLOOKUP(SUM('4th'!E122:E124)/30,score,2,TRUE)","v":0},{"$f":"'4th'!P120","v":{"$error":"#N/A"}},{"$f":"'4th'!P128","v":0},{"$f":"'4th'!P110","v":0},0]
[{"$f":"'Info Sheet'!A46","v":9},{"$f":"'Info Sheet'!C46","v":0},{"$f":"'4th'!L121","v":0},{"$f":"VLOOKUP(SUM('4th'!$E$115:$E$119)/19,score,2,TRUE)","v":0},{"$f":"VLOOKUP(SUM('4th'!E126:E128)/6,score,2,TRUE)","v":0},{"$f":"VLOOKUP(SUM('4th'!E123:E125)/30,score,2,TRUE)","v":0},{"$f":"'4th'!P121","v":{"$error":"#N/A"}},{"$f":"'4th'!P129","v":0},{"$f":"'4th'!P111","v":0},0]
[{"$f":"'Info Sheet'!A30","v":6},{"$f":"'Info Sheet'!C30","v":0},{"$f":"'4th'!L78","v":0},{"$f":"AVERAGE('4th'!$E$73:$E$77)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$81:$E$83)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$78:$E$80),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P78","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$84","v":0},{"$f":"G6+H6","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A19","v":4},{"$f":"'Info Sheet'!C19","v":0},{"$f":"'4th'!L49","v":0},{"$f":"AVERAGE('4th'!$E$45:$E$49)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$53:$E$55)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$50:$E$52)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P49","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$56","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A21","v":4},{"$f":"'Info Sheet'!C21","v":0},{"$f":"'4th'!L51","v":0},{"$f":"AVERAGE('4th'!$E$45:$E$49)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$53:$E$55)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$50:$E$52)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P51","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$56","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A20","v":4},{"$f":"'Info Sheet'!C20","v":0},{"$f":"'4th'!L50","v":0},{"$f":"AVERAGE('4th'!$E$45:$E$49)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$53:$E$55)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$50:$E$52)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P50","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$56","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A18","v":4},{"$f":"'Info Sheet'!C18","v":0},{"$f":"'4th'!L48","v":0},{"$f":"AVERAGE('4th'!$E$45:$E$49)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$53:$E$55)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$50:$E$52)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P48","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$56","v":0},{"$error":"#N/A"},{"$error":"#N/A"},null,0,0,0.2,0]
[{"$f":"'Info Sheet'!A10","v":2},{"$f":"'Info Sheet'!C10","v":0},{"$f":"'4th'!L22","v":0},{"$f":"VLOOKUP(SUM('4th'!$E$17:$E$21)/19,score,2,TRUE)","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$25:$E$27),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$22:$E$24),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P22","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$28","v":0},{"$error":"#N/A"},{"$error":"#N/A"},null,0.5,1,0.5,1]
[{"$f":"'Info Sheet'!A9","v":2},{"$f":"'Info Sheet'!C9","v":0},{"$f":"'4th'!L21","v":0},{"$f":"VLOOKUP(SUM('4th'!$E$17:$E$21)/19,score,2,TRUE)","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$25:$E$27),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$22:$E$24),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P21","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$28","v":0},{"$error":"#N/A"},{"$error":"#N/A"},null,0.7,2,0.6,2]
[{"$f":"'Info Sheet'!A8","v":2},{"$f":"'Info Sheet'!C8","v":0},{"$f":"'4th'!L20","v":0},{"$f":"AVERAGE('4th'!$E$17:$E$21)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$25:$E$27),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$22:$E$24),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P20","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$28","v":0},{"$error":"#N/A"},{"$error":"#N/A"},null,0.8,3,0.7,3]
[{"$f":"'Info Sheet'!A11","v":2},{"$f":"'Info Sheet'!C11","v":0},{"$f":"'4th'!L23","v":0},{"$f":"VLOOKUP(SUM('4th'!$E$17:$E$21)/19,score,2,TRUE)","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$25:$E$27),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$22:$E$24),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P23","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$28","v":0},{"$error":"#N/A"},{"$error":"#N/A"},null,0.9,4,0.8,4]
[{"$f":"'Info Sheet'!A6","v":1},{"$f":"'Info Sheet'!C6","v":0},{"$f":"'4th'!L9","v":0},{"$f":"AVERAGE('4th'!$E$3:$E$7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$11:$E$13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$8:$E$10)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P9","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$14","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A5","v":1},{"$f":"'Info Sheet'!C5","v":0},{"$f":"'4th'!L8","v":0},{"$f":"AVERAGE('4th'!$E$3:$E$7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$11:$E$13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$8:$E$10)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P8","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$14","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A3","v":1},{"$f":"'Info Sheet'!C3","v":0},{"$f":"'4th'!L6","v":0},{"$f":"AVERAGE('4th'!$E$3:$E$7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$11:$E$13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$8:$E$10)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P6","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$14","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A4","v":1},{"$f":"'Info Sheet'!C4","v":0},{"$f":"'4th'!L7","v":0},{"$f":"AVERAGE('4th'!$E$3:$E$7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$11:$E$13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$8:$E$10)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P7","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$14","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A16","v":3},{"$f":"'Info Sheet'!C16","v":0},{"$f":"'4th'!L37","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$31:$E$35),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$39:$E$41),1)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$36:$E$38)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P37","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$42","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A26","v":5},{"$f":"'Info Sheet'!C26","v":0},{"$f":"'4th'!L65","v":0},{"$f":"AVERAGE('4th'!$E$59:$E$63)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$67:$E$69),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$64:$E$66),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P65","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$70","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A29","v":6},{"$f":"'Info Sheet'!C29","v":0},{"$f":"'4th'!L77","v":0},{"$f":"AVERAGE('4th'!$E$73:$E$77)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$81:$E$83)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$78:$E$80),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P77","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$84","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A28","v":6},{"$f":"'Info Sheet'!C28","v":0},{"$f":"'4th'!L76","v":0},{"$f":"AVERAGE('4th'!$E$73:$E$77)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$81:$E$83)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$78:$E$80),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P76","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$84","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A31","v":6},{"$f":"'Info Sheet'!C31","v":0},{"$f":"'4th'!L79","v":0},{"$f":"AVERAGE('4th'!$E$73:$E$77)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$81:$E$83)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$78:$E$80),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P79","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$84","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A25","v":5},{"$f":"'Info Sheet'!C25","v":0},{"$f":"'4th'!L64","v":0},{"$f":"AVERAGE('4th'!$E$59:$E$63)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$67:$E$69),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$64:$E$66),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P64","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$70","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A23","v":5},{"$f":"'Info Sheet'!C23","v":0},{"$f":"'4th'!L62","v":0},{"$f":"AVERAGE('4th'!$E$59:$E$63)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$67:$E$69),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$64:$E$66),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P62","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$70","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A24","v":5},{"$f":"'Info Sheet'!C24","v":0},{"$f":"'4th'!L63","v":0},{"$f":"AVERAGE('4th'!$E$59:$E$63)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$67:$E$69),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$64:$E$66),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P63","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$70","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A14","v":3},{"$f":"'Info Sheet'!C14","v":0},{"$f":"'4th'!L35","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$31:$E$35),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$39:$E$41),1)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$36:$E$38)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P35","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$42","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A15","v":3},{"$f":"'Info Sheet'!C15","v":0},{"$f":"'4th'!L36","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$31:$E$35),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$39:$E$41),1)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$36:$E$38)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P36","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$42","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A13","v":3},{"$f":"'Info Sheet'!C13","v":0},{"$f":"'4th'!L34","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$31:$E$35),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$39:$E$41),1)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('4th'!$E$36:$E$38)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P34","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$42","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A41","v":8},{"$f":"'Info Sheet'!C41","v":0},{"$f":"'4th'!L107","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$101:$E$105),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$109:$E$111),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$106:$E$108),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P107","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$112","v":0},{"$f":"'4th'!P107","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A43","v":9},{"$f":"'Info Sheet'!C43","v":0},{"$f":"'4th'!L118","v":0},{"$f":"VLOOKUP(SUM('4th'!$E$115:$E$119)/19,score,2,TRUE)","v":0},{"$f":"VLOOKUP(SUM('4th'!E123:E125)/6,score,2,TRUE)","v":0},{"$f":"VLOOKUP(SUM('4th'!E120:E122)/30,score,2,TRUE)","v":0},{"$f":"'4th'!P118","v":{"$error":"#N/A"}},{"$f":"'4th'!P126","v":0},{"$f":"'4th'!P108","v":"# Members"},{"$error":"#VALUE!"}]
[{"$f":"'Info Sheet'!A39","v":8},{"$f":"'Info Sheet'!C39","v":0},{"$f":"'4th'!L105","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$101:$E$105),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$109:$E$111),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$106:$E$108),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P105","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$112","v":0},{"$f":"'4th'!P105","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A34","v":7},{"$f":"'Info Sheet'!C34","v":0},{"$f":"'4th'!L91","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$87:$E$91),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$95:$E$97),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$92:$E$94),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P91","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$98","v":0},{"$f":"G33+H33","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A35","v":7},{"$f":"'Info Sheet'!C35","v":0},{"$f":"'4th'!L92","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$87:$E$91),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$95:$E$97),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$92:$E$94),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P92","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$98","v":0},{"$f":"G34+H34","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A40","v":8},{"$f":"'Info Sheet'!C40","v":0},{"$f":"'4th'!L106","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$101:$E$105),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$109:$E$111),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$106:$E$108),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P106","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$112","v":0},{"$f":"'4th'!P106","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A38","v":8},{"$f":"'Info Sheet'!C38","v":0},{"$f":"'4th'!L104","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$101:$E$105),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$109:$E$111),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$106:$E$108),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P104","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$112","v":0},{"$f":"'4th'!P104","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A36","v":7},{"$f":"'Info Sheet'!C36","v":0},{"$f":"'4th'!L93","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$87:$E$91),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$95:$E$97),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$92:$E$94),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P93","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$98","v":0},{"$f":"G37+H37","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'Info Sheet'!A33","v":7},{"$f":"'Info Sheet'!C33","v":0},{"$f":"'4th'!L90","v":0},{"$f":"ROUND(AVERAGE('4th'!$E$87:$E$91),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$95:$E$97),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE('4th'!$E$92:$E$94),1)","v":{"$error":"#DIV/0!"}},{"$f":"'4th'!P90","v":{"$error":"#N/A"}},{"$f":"'4th'!$P$98","v":0},{"$f":"G38+H38","v":{"$error":"#N/A"}},{"$error":"#N/A"}]

{"sheet":"Sheet2","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["CHOOSE",1]
["Billboard",200]
["PowerPoint",300]
["Radio",400]
["Brochure",500]
["Flyer",500]
["Website",700]
["Commercial",800]
["Youtube",1000]