{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Ski Jumping","VBA Application"],"not_rendered":{"charts":0,"images":1,"macros":1,"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":"Ski Jumping","index":0,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[22,2,22,6],[21,8,21,11],[21,0,21,7]]}
["Ski Jumping"]
[]
["Ski jumper get points for jump length and style."]
["\"Normal\" jump to K-point is 60 points worth, every additional meter gives bonus points according to this table:"]
[]
[null,"m","points"]
["K-point",125,60]
["Meter value",1,1.8]
["Wind Factor",null,9.36]
["Every meter less than K-point reduce number of points, so for example 110m jump gives 42 points."]
["Wind factor adds or reduces total points."]
["There are 5 jury members, who give style points in range 0...20."]
["Highest and lowest style points will be ignored, three middle values are added together."]
[null,"(so the maximum value of style points is 60)"]
["Fill columns I:L with formulas to calculate jump length, style and total points for every sportsman."]
[]
[]
[]
[]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B20-$B$7)*$C$8","v":87},{"$f":"SUM(C20:G20)-MIN(C20:G20)-MAX(C20:G20)","v":55},{"$f":"-$C$9*H20","v":1.7784},{"$f":"SUM(I20:K20)","v":143.7784}]
[]
[null,null,null,null,null,null,null,null,"Points"]
["Name","Length (m)","Jury points",null,null,null,null,"Wind","Jump","Style","Wind","Total"]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B24-$B$7)*$C$8","v":87},{"$f":"SUM(C24:G24)-MIN(C24:G24)-MAX(C24:G24)","v":55},{"$f":"-$C$9*H24","v":1.7784},{"$f":"SUM(I24:K24)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B25-$B$7)*$C$8","v":87},{"$f":"SUM(C25:G25)-MIN(C25:G25)-MAX(C25:G25)","v":55},{"$f":"-$C$9*H25","v":1.7784},{"$f":"SUM(I25:K25)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B26-$B$7)*$C$8","v":87},{"$f":"SUM(C26:G26)-MIN(C26:G26)-MAX(C26:G26)","v":55},{"$f":"-$C$9*H26","v":1.7784},{"$f":"SUM(I26:K26)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B27-$B$7)*$C$8","v":87},{"$f":"SUM(C27:G27)-MIN(C27:G27)-MAX(C27:G27)","v":55},{"$f":"-$C$9*H27","v":1.7784},{"$f":"SUM(I27:K27)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B28-$B$7)*$C$8","v":87},{"$f":"SUM(C28:G28)-MIN(C28:G28)-MAX(C28:G28)","v":55},{"$f":"-$C$9*H28","v":1.7784},{"$f":"SUM(I28:K28)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B29-$B$7)*$C$8","v":87},{"$f":"SUM(C29:G29)-MIN(C29:G29)-MAX(C29:G29)","v":55},{"$f":"-$C$9*H29","v":1.7784},{"$f":"SUM(I29:K29)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B30-$B$7)*$C$8","v":87},{"$f":"SUM(C30:G30)-MIN(C30:G30)-MAX(C30:G30)","v":55},{"$f":"-$C$9*H30","v":1.7784},{"$f":"SUM(I30:K30)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B31-$B$7)*$C$8","v":87},{"$f":"SUM(C31:G31)-MIN(C31:G31)-MAX(C31:G31)","v":55},{"$f":"-$C$9*H31","v":1.7784},{"$f":"SUM(I31:K31)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B32-$B$7)*$C$8","v":87},{"$f":"SUM(C32:G32)-MIN(C32:G32)-MAX(C32:G32)","v":55},{"$f":"-$C$9*H32","v":1.7784},{"$f":"SUM(I32:K32)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B33-$B$7)*$C$8","v":87},{"$f":"SUM(C33:G33)-MIN(C33:G33)-MAX(C33:G33)","v":55},{"$f":"-$C$9*H33","v":1.7784},{"$f":"SUM(I33:K33)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B34-$B$7)*$C$8","v":87},{"$f":"SUM(C34:G34)-MIN(C34:G34)-MAX(C34:G34)","v":55},{"$f":"-$C$9*H34","v":1.7784},{"$f":"SUM(I34:K34)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B35-$B$7)*$C$8","v":87},{"$f":"SUM(C35:G35)-MIN(C35:G35)-MAX(C35:G35)","v":55},{"$f":"-$C$9*H35","v":1.7784},{"$f":"SUM(I35:K35)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B36-$B$7)*$C$8","v":87},{"$f":"SUM(C36:G36)-MIN(C36:G36)-MAX(C36:G36)","v":55},{"$f":"-$C$9*H36","v":1.7784},{"$f":"SUM(I36:K36)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B37-$B$7)*$C$8","v":87},{"$f":"SUM(C37:G37)-MIN(C37:G37)-MAX(C37:G37)","v":55},{"$f":"-$C$9*H37","v":1.7784},{"$f":"SUM(I37:K37)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B38-$B$7)*$C$8","v":87},{"$f":"SUM(C38:G38)-MIN(C38:G38)-MAX(C38:G38)","v":55},{"$f":"-$C$9*H38","v":1.7784},{"$f":"SUM(I38:K38)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B39-$B$7)*$C$8","v":87},{"$f":"SUM(C39:G39)-MIN(C39:G39)-MAX(C39:G39)","v":55},{"$f":"-$C$9*H39","v":1.7784},{"$f":"SUM(I39:K39)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B40-$B$7)*$C$8","v":87},{"$f":"SUM(C40:G40)-MIN(C40:G40)-MAX(C40:G40)","v":55},{"$f":"-$C$9*H40","v":1.7784},{"$f":"SUM(I40:K40)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B41-$B$7)*$C$8","v":87},{"$f":"SUM(C41:G41)-MIN(C41:G41)-MAX(C41:G41)","v":55},{"$f":"-$C$9*H41","v":1.7784},{"$f":"SUM(I41:K41)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B42-$B$7)*$C$8","v":87},{"$f":"SUM(C42:G42)-MIN(C42:G42)-MAX(C42:G42)","v":55},{"$f":"-$C$9*H42","v":1.7784},{"$f":"SUM(I42:K42)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B43-$B$7)*$C$8","v":87},{"$f":"SUM(C43:G43)-MIN(C43:G43)-MAX(C43:G43)","v":55},{"$f":"-$C$9*H43","v":1.7784},{"$f":"SUM(I43:K43)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B44-$B$7)*$C$8","v":87},{"$f":"SUM(C44:G44)-MIN(C44:G44)-MAX(C44:G44)","v":55},{"$f":"-$C$9*H44","v":1.7784},{"$f":"SUM(I44:K44)","v":143.7784}]
["Kamil STOCH",140,18.5,18,18.5,18.5,18,-0.19,87,55,1.7784,143.7784]
["Kamil STOCH",138,18.5,18,18.5,18.5,18,-0.19,{"$f":"$C$7+(B46-$B$7)*$C$8","v":83.4},{"$f":"SUM(C46:G46)-MIN(C46:G46)-MAX(C46:G46)","v":55},{"$f":"-$C$9*H46","v":1.7784},{"$f":"SUM(I46:K46)","v":140.17840000000001}]
["Anssi KOIVURANTA",138.5,18.5,18.5,18.5,19,19,0.43,{"$f":"$C$7+(B47-$B$7)*$C$8","v":84.3},{"$f":"SUM(C47:G47)-MIN(C47:G47)-MAX(C47:G47)","v":56},{"$f":"-$C$9*H47","v":-4.0247999999999999},{"$f":"SUM(I47:K47)","v":136.27520000000001}]
["Noriaki KASAI",132,18.5,18.5,18,18.5,19,-0.5,72.599999999999994,55.5,4.68,132.78]
["Peter PREVC",136,18.5,18.5,18,18.5,18.5,0.36,79.8,55.5,-3.3695999999999997,131.93040000000002]
["Severin FREUND",138.5,14.5,15.5,15.5,15,13.5,-0.22,84.3,45,2.0591999999999997,131.35920000000002]
["Dimitry VASSILIEV",136.5,18.5,18.5,18,18.5,18,0.52,80.7,55,-4.8671999999999995,130.83279999999999]

{"sheet":"VBA Application","index":1,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["1. Create a VBA userform  as shown below to enter the values in the Ski Jumping worksheet"]
["2. Create a button in Ski Jumping worksheet that opens the created userform"]
["3. Create an exit button on a userfom that hides the userform"]
["4. The user needs to enter skier name using a combobox that contains a range of skier names provided in Ski Jumping worksheet"]
["5. The user needs to enter a length using a combobox that contains a range of values between 120 and 140 with an interval of 0,5"]
["6. The user needs to use a text box to enter wind value."]
["7. For each judge, the user needs to use a combobox to select sytle points that ranges between 10 and 20 with an inteval of 0,5"]
["8. The add record button should insert all the entered data in the top of the list of results in Ski Jumping worksheet."]