{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Program WAM Calculator","Droplist"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Program WAM Calculator","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,22,22],[24,1,24,22],[26,1,26,22],[3,1,3,22]]}
[]
[null,"Overall program WAM target calculator"]
[]
[null,"You can use this calculator to work out future course marks to end up with a particular WAM at the end of your studies. To use it, you will need to know your current WAM, the total uoc required for your program, how many uoc you have completed already, and how many (if any) of the courses in your program are non-graded (e.g. are pass/fail courses, exchange credits). You can find that information on your transcript from myUNSW and the online Handbook if necessary."]
[]
[null,null,"Information Required"]
[1,null,"<-- In this field enter the number of total uoc required for your program e.g. a Bachelor of Arts requires 144 uoc in total"]
[2,null,"<-- If you have had credits transferred from another university add the total number of uoc here (add a zero if you have not had a credit transfer)"]
[3,null,"<-- If you have gone on exchange, or will go on exchange, enter the total number of credits from exchange you will have by the end of your degree (add a zero if you will not go on exchange)"]
[4,null,"<-- In this field, enter the total amount of uoc you will have at the end of your studies of any other kind that will not have a numerical mark e.g. pass/fail courses, Professional Experience courses, or Social Work Placements. (Enter a zero if there are none)"]
[5,null,"<-- In this field, enter the total amount of already completed, graded uocs (i.e. do not count any already completed exchange courses, credit transfer from other universities or already completed pass/fail only courses)"]
[6,null,"<-- In this field, enter the current overall wam for your program, taken from your transcript (NB: this will automatically factor in previously failed courses)"]
[7,null,"<-- In this field, enter the number of the final WAM that you hope to achieve"]
[]
[null,{"$f":"B7-(B11+B10+B9+B8)","v":0},"uoc (of graded courses) are left to complete"]
[null,{"$f":"IFERROR((B13-((B11/(B7-(B8+B9+B10)))*B12))/(B15/(B7-(B8+B9+B10))), )","v":0},"is the average mark required for those remaining courses to reach that WAM"]
[null,{"$f":"IF(B16<0,\"ERROR IN WAMS\",IF(AND(B16>100),\"WAM NOT ACHIEVABLE\",\"\"))","v":""}]
[]
[]
[]
[null,"NOTE:  This calculator is only intended for use in single degree programs."]
[]
[null,"DISCLAIMER:  The WAM Calculator is intended to assist students in calculating future course marks in order to achieve a hypothetical WAM. UNSW accepts no responsibility for the use of this calculator and it cannot be submitted as formal evidence for advice from the university or its staff."]

{"sheet":"Droplist","index":1,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["List 1","List 2","List 3","List 4"]
[24,0,6,"Yes"]
[30,6,12,"No"]
[36,12,18]
[42,18,24]
[48,24,30]
[54,30,36]
[60,36,42]
[66,42,48]
[72,48,54]
[78,54,60]
[84,60,66]
[90,66,72]
[96,72,78]
[102,78,84]
[108,84,90]
[114,90,96]
[120,96,102]
[126,102,108]
[132,108,114]
[138,114,120]
[144,120,126]
[150,126,132]
[156,132,138]
[162,138,144]
[168,144,150]
[174,150,156]
[180,156,162]
[186,162,168]
[192,168,174]
[198,174,180]
[204,180,186]
[210,186,192]
[216,192,198]
[222,198,204]
[228,204,210]
[234,210,216]
[240,216,222]
[246,222,228]
[252,228,234]
[258,234,240]
[264,240,246]
[270,246,252]
[276,252,258]
[282,258,264]
[288,264,270]
[null,270,276]
[null,276,282]
[null,282]