{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Signup Directions","Event Signup"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Signup Directions","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,26,8]]}
["MEC Registration Directions\n\n1.       Select the \"Event Signup\" sheet in this document.\n   \n2.       Under “Team Name:” enter the name of your school or group.\n\n3.       Under “Participant Names” fill in the names of all individuals from your school who will be  \n          participating in the MEC.\n\n4.       For each event under the “Drill Teams,” “Athletic Events,” and “Combat Skills Events” put \n          the names of those individuals who wish to compete in each specific event in the \n          appropriate box.\n\n5.       For team events, if individuals wish to make a team of their peers there are multiple boxes \n          to allow for multiple teams per school. Please see the SOPs for each event for the \n          minimum and maximum number of members allowed per team. If you would like to add more teams than \n          prescribed number of teams, please contact MIDN Wunderley (jmw6591@psu.edu) when submitting this \n          document\n\n6.       The cost for each event will be calculated for each event based on the number of \n          participants or teams, depending on the event. The total cost of all events will be calculated \n          into the total cost for your school, shown next to “Event Cost.”\n\n7.       Once you have finished filling out the document and are ready to submit it, email the completed \n           document and any additional questions you have to jmw6591@psu.edu to reserve your spot. You \n           should receive a reply confirming that the form is fiilled out  correctly or if there are any discpreancies.\n\n8.     Once your form is correctly submitted and you have received a confirmation email, please mail a check \n        payable to “Future Naval Officers” to 315 Wagner Building University Park, PA 16802 ATTN MIDN \n        Supply Officer for the total cost for your school listed on the document.  "]

{"sheet":"Event Signup","index":1,"n_rows":35,"n_cols":27,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,2,1,6],[1,8,1,19],[1,21,1,25]]}
["Team Name: ",null,"Event Cost: ",{"$f":"AA34","v":0}]
["Penn State",null,"Drill Teams",null,null,null,null,null,"Athletic Events",null,null,null,null,null,null,null,null,null,null,null,null,"Combat Skills Events"]
["Participant Names:",null,"Platoon Basic","Squad Basic","Color Guard","Platoon Trick","2-Man Trick",null,"5k Run","100 Run","400 Run","4x400 Run ","4x200 Run","T-shirt Relay","4x50 Freestyle Swim","4x50 IM Swim","50 Backstroke Swim","50 Butterfly Swim","50 Breaststroke Swim","Ultimate Frisbee",null,"CFT","ISMT","Mogadishu Mile","Corpsman Challenge","Athletic Skills Challenge"]
[null,null,null,null,"Team 1",null,"Team 1",null,null,null,null,"Team 1","Team 1","Team 1","Team 1","Team 1",null,null,null,"Team 1",null,null,"Team 1","Team 1","Team 1","Team 1"]
[]
[]
[null,null,null,null,null,null,"Team 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Team 2","Team 2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Team 2","Team 2","Team 2","Team 2","Team 2",null,null,null,null,null,null,"Team 2","Team 2"]
[null,null,null,null,null,null,"Team 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Team 3","Team 3"]
[null,null,null,null,"Team 2"]
[]
[null,null,null,null,null,null,"Team 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Team 4","Team 4"]
[null,null,null,null,null,null,null,null,null,null,null,"Team 3","Team 3","Team 3","Team 3","Team 3",null,null,null,null,null,null,"Team 3","Team 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Team 2"]
[null,null,null,null,null,null,"Team 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Team 5","Team 5"]
[]
[null,null,null,null,"Team 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Team 4","Team 4"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Total Cost:"]
[null,null,{"$f":"IF(COUNTA(C4:C33)>0, 50, 0)","v":0},{"$f":"IF(COUNTA(D4:D13)>0, 25, 0)","v":0},{"$f":"IF(COUNTA(E5:E10)>0, 25, 0)+IF(COUNTA(E12:E17)>0, 25, 0)+IF(COUNTA(E19:E24)>0, 25, 0)","v":0},{"$f":"IF(COUNTA(F4:F28)>0, 50, 0)","v":0},{"$f":"IF(COUNTA(G5:G6)>0, 15, 0)+IF(COUNTA(G8:G9)>0, 15, 0)+IF(COUNTA(G11:G12)>0, 15, 0)+IF(COUNTA(G14:G15)>0, 15, 0)+IF(COUNTA(G17:G18)>0, 15, 0)","v":0},null,{"$f":"COUNTA(I4:I23) * 5","v":0},{"$f":"COUNTA(J4:J13) * 5","v":0},{"$f":"COUNTA(K4:K13) * 5","v":0},{"$f":"IF(COUNTA(L5:L8)>0, 15, 0)+IF(COUNTA(L10:L13)>0, 15, 0)+IF(COUNTA(L15:L18)>0, 15, 0)","v":0},{"$f":"IF(COUNTA(M5:M8)>0, 15, 0)+IF(COUNTA(M10:M13)>0, 15, 0)+IF(COUNTA(M15:M18)>0, 15, 0)","v":0},{"$f":"IF(COUNTA(N5:N8)>0, 20, 0)+IF(COUNTA(N10:N13)>0, 20, 0)+IF(COUNTA(N15:N18)>0, 20, 0)","v":0},{"$f":"IF(COUNTA(O5:O8)>0, 20, 0)+IF(COUNTA(O10:O13)>0, 20, 0)+IF(COUNTA(O15:O18)>0, 20, 0)","v":0},0,{"$f":"COUNTA(Q4:Q10) * 5","v":0},{"$f":"COUNTA(R4:R10) * 5","v":0},0,{"$f":"IF(COUNTA(T5:T14)>0, 20, 0)+IF(COUNTA(T16:T25)>0, 20, 0)","v":0},null,{"$f":"COUNTA(V4:V18) * 10","v":0},{"$f":"IF(COUNTA(W5:W8)>0, 25, 0)+IF(COUNTA(W10:W13)>0, 25, 0)+IF(COUNTA(W15:W18)>0, 25, 0)+IF(COUNTA(W20:W23)>0, 25, 0)","v":0},{"$f":"IF(COUNTA(X5:X8)>0, 25, 0)+IF(COUNTA(X10:X13)>0, 25, 0)+IF(COUNTA(X15:X18)>0, 25, 0)+IF(COUNTA(X20:X23)>0, 25, 0)","v":0},{"$f":"IF(COUNTA(Y5:Y6)>0, 15, 0)+IF(COUNTA(Y8:Y9)>0, 15, 0)+IF(COUNTA(Y11:Y12)>0, 15, 0)+IF(COUNTA(Y14:Y15)>0, 15, 0)+IF(COUNTA(Y17:Y18)>0, 15, 0)","v":0},{"$f":"IF(COUNTA(Z5:Z6)>0, 15, 0)+IF(COUNTA(Z8:Z9)>0, 15, 0)+IF(COUNTA(Z11:Z12)>0, 15, 0)+IF(COUNTA(Z14:Z15)>0, 15, 0)+IF(COUNTA(Z17:Z18)>0, 15, 0)","v":0},{"$f":"SUM(C34:Z34)","v":0}]
[null,null,"$50 for 1 team","$25 for 1 team","$25 Per Team","$50 for 1 team","$15 per team",null,"$5 per competitior","$5 per competitior","$5 per competitior","$15 per team","$15 per team","$20 per team","$20 per team","$20 per team","$5 per competitor","$5 per competitor","$5 per competitor","$20 per team",null,"$10 per competitor","$25 per team","$25 per team","$15 per team","$15 per team"]