{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet1","index":0,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,"January offer ",{"$nulls":8},"Current offer"]
["Enter current step",null,15]
["Now enter your salary amounts per step in grey boxes in both charts"]
["To enter salary for a half step, in the cell, type    =average( lower salary amount,higher salary amount) "]
["Year","Step","Salary","Gross Paycheck","# of check","Total income","School year income",null,"Year","Step","Salary","Gross Paycheck","# of checks","Total income","School year income","Difference"]
[23,{"$f":"C2","v":15},90387,{"$f":"C6/24","v":3766.125},8,{"$f":"E6*D6","v":30129},null,null,"19/20",{"$f":"C2","v":15},41233,{"$f":"K6/24","v":1718.0416666666667},24,{"$f":"M6*L6","v":41233},{"$f":"N6+N10","v":41681.184782608696},{"$f":"O6-G7","v":-20822.148550724633}]
[20,{"$f":"B6+1.5","v":16.5},{"$f":"AVERAGE(46922,50201)","v":48561.5},{"$f":"C7/24","v":2023.3958333333333},16,{"$f":"E7*D7","v":32374.333333333332},{"$f":"SUM(F6:F7)","v":62503.333333333328},null,"20/21",{"$f":"J6+2.5","v":17.5},{"$f":"AVERAGE(50703,53778)","v":52240.5},{"$f":"K7/24","v":2176.6875},24,{"$f":"M7*L7","v":52240.5},{"$f":"N7","v":52240.5},{"$f":"O7-G8","v":517}]
["20/21",{"$f":"B7+1","v":17.5},{"$f":"AVERAGE(50201,53246)","v":51723.5},{"$f":"C8/24","v":2155.1458333333335},24,51723.5,{"$f":"F8","v":51723.5},null,21,{"$f":"J7+1","v":18.5},{"$f":"AVERAGE(53778,56303)","v":55040.5},{"$f":"K8/24","v":2293.3541666666665},6,13760.125]
[21,{"$f":"B8+1","v":18.5},{"$f":"AVERAGE(53246,55746)","v":54496},{"$f":"C9/24","v":2270.6666666666665},8,18165.333333333332,null,null,22,{"$f":"J8+0.5","v":19},56303,{"$f":"K9/24","v":2345.9583333333335},18,42227.25,{"$f":"N8+N9","v":55987.375},{"$f":"O9-G10","v":658.04166666667152}]
[22,{"$f":"B9+0.5","v":19},55746,{"$f":"C10/24","v":2322.75},16,37164,{"$f":"F9+F10","v":55329.333333333328},null,"Furlough payment",{"$nulls":4},{"$f":"(K6/184)*2","v":448.18478260869563}]
[null,null,null,{"$f":"F11/E11","v":2354.9467592592591},{"$f":"SUM(E6:E10)","v":72},{"$f":"SUM(F6:F10)","v":169556.16666666666},{"$f":"SUM(G7:G10)","v":169556.16666666666},null,null,null,"avg check",{"$f":"N11/M11","v":2075.8454861111113},{"$f":"SUM(M6:M9)","v":72},{"$f":"SUM(N6:N9)","v":149460.875},{"$f":"SUM(O6:O9)","v":149909.0597826087},{"$f":"SUM(P6:P9)","v":-19647.106884057961}]
["Enter in values for the grey boxes only"]
{"$rows_empty":19}
["Paychecks"]
["Jan",2]
["Feb",2]
["Mar",2]
["Apr",2]
["May",2]
["Jun",2]
["Jul",2]
["Aug",2]
["Sep",2]
["Oct",2]
["Nov",2]
["Dec",2]
[null,{"$f":"SUM(B33:B44)","v":24}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}