{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["P&CExample","P&C(cont.)","If-Statements","If-Statements (cont.)","For Loops","For Loops (cont.)","Arrays","Arrays (cont.)","2-D Arrays","2-D Arrays (cont.)","Select","Macro Recorder","Tuition Report","List"],"not_rendered":{"macros":1,"external_links":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"P&CExample","index":0,"n_rows":20,"n_cols":11,"rows_kept":20}
["Property & Casualty Example",{"$nulls":9},"x"]
[]
["Base Rates:","Price Per Month (Annual Policy):"]
["$20,000 Coverage (A)",null,{"v":100,"d":"$100.00"}]
["$50,000 Coverage (B)",null,{"v":150,"d":"$150.00"}]
["$100,000 Coverage (C)",null,{"v":200,"d":"$200.00"}]
[]
["Risk Factor Tables:","Age of Driver",null,null,"Model Type",null,null,"Model Year"]
[null,"Under 18",1.3,null,"Sedan",1,null,"Last 5 Years",1.2]
[null,"19-30",1,null,"SUV",0.9,null,"6-14 Years Ago",1]
[null,"31-64",0.8,null,"Truck",1.1,null,"15 Years or Older",0.95]
[null,"65+",1.2]
[]
["Given Examples:",null,"CovA:","CovB:","CovC:"]
[null,null,100,150,200,"<--- coverages will print here after running sub Q1"]
[]
["Q1: Find the price per month of a $20,000 coverage on a driver age 17 covering a sedan with a model year of 2010."]
["Answer found by taking base coverage and multiplying by appropriate risk factors (e.g. $100*1.3*1*1=$130)."]
["Answer:","Excel","VBA"]
[null,{"$f":"$C$4*C9*F9*I10","v":{"v":130,"d":"$130.00"}}]

{"sheet":"P&C(cont.)","index":1,"n_rows":21,"n_cols":1,"rows_kept":21}
["Property & Casualty Example"]
[]
["All the questions pertain to the information on sheet \"P&CExample\""]
["(This is to show that you can use information from other sheets on this sheet)"]
[]
["Open the module P&CQs and edit subs Q2, Q3, and Q4 to answer questions."]
[]
["Q2: Find the price per month of coverage C for a driver age40 driving a 1995 pickup."]
["(e.g. $200*0.8*1.1*0.95)"]
[]
["Answer:"]
[]
["Q3: Find the price per month of coverage B for a driver age 72 driving a 2020 SUV."]
["(e.g. $150*1.2*0.9*1.2)"]
[]
["Answer:"]
[]
["Q: Find the annual price of coverage C for a driver age 22 driving a 2013 sedan."]
["(e.g. $200*1*1*1*12)"]
[]
["Answer:"]

{"sheet":"If-Statements","index":2,"n_rows":16,"n_cols":13,"rows_kept":16}
["Example 1:"]
[null,"Losses Per Policy (Thousands)"]
[null,"January","February","March","April","May","June","July","August","September","October","November","December"]
["Policy A",{"v":128.0666185123511,"d":"$128.07"},{"v":77.65596883405823,"d":"$77.66"},{"v":70.10267215682586,"d":"$70.10"},{"v":19.879501354462036,"d":"$19.88"},{"v":193.24353371435757,"d":"$193.24"},{"v":56.41279085886841,"d":"$56.41"},{"v":5.704449491968577,"d":"$5.70"},{"v":60.76625668949029,"d":"$60.77"},{"v":54.75378671840681,"d":"$54.75"},{"v":94.91235092467033,"d":"$94.91"},{"v":32.30750604269961,"d":"$32.31"},{"v":91.01332064256886,"d":"$91.01"}]
["Policy B",{"v":173.4355171625415,"d":"$173.44"},{"v":85.17038184687983,"d":"$85.17"},{"v":187.5665658695607,"d":"$187.57"},{"v":33.76342958892244,"d":"$33.76"},{"v":111.74868044816711,"d":"$111.75"},{"v":32.71604464694355,"d":"$32.72"},{"v":134.67603057424353,"d":"$134.68"},{"v":92.09283560476345,"d":"$92.09"},{"v":119.69657215848719,"d":"$119.70"},{"v":81.0243677788862,"d":"$81.02"},{"v":123.908218250136,"d":"$123.91"},{"v":157.49965030041045,"d":"$157.50"}]
[]
[]
[]
["Term:","Q1",{"$nulls":3},"Q3 Loss Report"]
[{"$nulls":6},"Policy A","Policy B"]
[{"$nulls":5},"Total Losses"]
[{"$nulls":5},"Avg Losses:"]
[{"$nulls":5},"Median Losses:"]
[{"$nulls":5},"Min Losses:"]
[{"$nulls":5},"Max Losses:"]
["Click the button to run the macro."]

{"sheet":"If-Statements (cont.)","index":3,"n_rows":27,"n_cols":12,"rows_kept":27}
[]
["Here, we will be using if statements to create a report.",{"$nulls":5},"3 Year Summary Report",null,null,"Answers for PA, 2015"]
["By using VBA, the report can be created repeatedly and quickly.",{"$nulls":5},"Average Premium",null,null,{"v":109000,"d":"$109,000.00"}]
["The macro will create the correct report depending on the inputs in cells B11 and B12.",{"$nulls":5},"Average NWP",null,null,{"v":101166.67,"d":"$101,166.67"}]
[{"$nulls":6},"Average Expenses",null,null,{"v":30350,"d":"$30,350.00"}]
["Question 1: Create the report consisting of the means of Premiums, Net Written Premiums, ",{"$nulls":5},"Average Reserves",null,null,{"v":60700,"d":"$60,700.00"}]
["expenses, reserves, and losses for the last 3 years for business done in Pennsylvania",{"$nulls":5},"Average Losses",null,null,{"v":50583.33,"d":"$50,583.33"}]
["or New Jersey, depending on the inputs. To do so, edit the sub report_ex in module"]
["IfStatementsCont by placing the appropriate if statement(s) in the correct place."]
[]
["State:","PA"]
["Start Year:",2015]
[]
[]
[]
[]
[]
[null,"(You can link buttons to macros. In Developer, click insert,"]
[null,"then button, and draw out size. Then assign the macro you"]
[null,"want to run when button is pressed.)"]
[{"$nulls":3},"PA",{"$nulls":5},"NJ"]
[null,2015,2016,2017,2018,2019,null,2015,2016,2017,2018,2019]
["Premiums",{"v":110000,"d":"$110,000.00"},{"v":97000,"d":"$97,000.00"},{"v":120000,"d":"$120,000.00"},{"v":150000,"d":"$150,000.00"},{"v":143000,"d":"$143,000.00"},null,{"v":475500,"d":"$475,500.00"},{"v":500000,"d":"$500,000.00"},{"v":505500,"d":"$505,500.00"},{"v":455750,"d":"$455,750.00"},{"v":525250,"d":"$525,250.00"}]
["NWP:",{"v":105000,"d":"$105,000.00"},{"v":95000,"d":"$95,000.00"},{"v":103500,"d":"$103,500.00"},{"v":12000,"d":"$12,000.00"},{"v":121500,"d":"$121,500.00"},null,{"v":440500,"d":"$440,500.00"},{"v":467390,"d":"$467,390.00"},{"v":475820,"d":"$475,820.00"},{"v":418630,"d":"$418,630.00"},{"v":501500,"d":"$501,500.00"}]
["Expenses:",{"v":31500,"d":"$31,500.00"},{"v":28500,"d":"$28,500.00"},{"v":31050,"d":"$31,050.00"},{"v":3600,"d":"$3,600.00"},{"v":36450,"d":"$36,450.00"},null,{"v":132150,"d":"$132,150.00"},{"v":140217,"d":"$140,217.00"},{"v":142746,"d":"$142,746.00"},{"v":125589,"d":"$125,589.00"},{"v":150450,"d":"$150,450.00"}]
["Reserves:",{"v":63000,"d":"$63,000.00"},{"v":57000,"d":"$57,000.00"},{"v":62100,"d":"$62,100.00"},{"v":7200,"d":"$7,200.00"},{"v":72900,"d":"$72,900.00"},null,{"v":264300,"d":"$264,300.00"},{"v":280434,"d":"$280,434.00"},{"v":285492,"d":"$285,492.00"},{"v":251178,"d":"$251,178.00"},{"v":300900,"d":"$300,900.00"}]
["Losses:",{"v":52500,"d":"$52,500.00"},{"v":47500,"d":"$47,500.00"},{"v":51750,"d":"$51,750.00"},{"v":6000,"d":"$6,000.00"},{"v":60750,"d":"$60,750.00"},null,{"v":220250,"d":"$220,250.00"},{"v":233695,"d":"$233,695.00"},{"v":237910,"d":"$237,910.00"},{"v":209315,"d":"$209,315.00"},{"v":250750,"d":"$250,750.00"}]

{"sheet":"For Loops","index":4,"n_rows":4,"n_cols":4,"rows_kept":4}
["Example1:"]
[]
["Example2:"]
[{"$nulls":3},"Example3:"]

{"sheet":"For Loops (cont.)","index":5,"n_rows":34,"n_cols":12,"rows_kept":34}
["Example 4:"]
[]
[]
[]
[]
[]
["Question 1:"]
["Use a nested loop to recreate this:"]
[{"$nulls":11},"In this box (numbers should appear in smaller boxes starting from topright):"]
[{"$nulls":9},20]
[]
[]
[{"$nulls":6},14]
[]
[]
[{"$nulls":3},8]
[]
[]
[2]
[]
[]
["Question 2:"]
["Use a nested loop to recreate this:",{"$nulls":10},"In this box (populate cells from top right, populating each column top to bottom,"]
[{"$nulls":11}," then moving to the next column to the left)"]
[3,4,5,6,7,8,9,10,11,12]
[5,6,7,8,9,10,11,12,13,14]
[7,8,9,10,11,12,13,14,15,16]
[9,10,11,12,13,14,15,16,17,18]
[11,12,13,14,15,16,17,18,19,20]
[13,14,15,16,17,18,19,20,21,22]
[15,16,17,18,19,20,21,22,23,24]
[17,18,19,20,21,22,23,24,25,26]
[19,20,21,22,23,24,25,26,27,28]
[21,22,23,24,25,26,27,28,29,30]

{"sheet":"Arrays","index":6,"n_rows":13,"n_cols":17,"rows_kept":13}
["Arrays:",null,null,"Age:",20,25,23,18,27,29,35,22,40,43]
[]
[{"$nulls":4},"How Old?",{"$nulls":10},"VBA","Excel"]
["Brandon",{"$nulls":13},"Average Age",null,{"$f":"AVERAGE($E$1:$N$1)","v":28.2}]
["Akash",{"$nulls":13},"Max Age",null,{"$f":"MAX($E$1:$N$1)","v":43}]
["Nikki",{"$nulls":13},"Min Age",null,{"$f":"MIN($E$1:$N$1)","v":18}]
["Aidan",{"$nulls":13},"Median Age",null,{"$f":"MEDIAN($E$1:$N$1)","v":26}]
["Noah",{"$nulls":13},"Total Age",null,{"$f":"SUM($E$1:$N$1)","v":282}]
["Vince"]
["Marceli"]
["Alexis"]
["Lucas"]
["Ayo"]

{"sheet":"Arrays (cont.)","index":7,"n_rows":20,"n_cols":9,"rows_kept":20}
["Lets go back to that P&C example again. One of the problems we ran into"]
["was declaring and assigning values to all those variables. There's a faster and more efficient way. Let's use arrays!"]
["Base Rates:","Price Per Month (Annual Policy):"]
["$20,000 Coverage (A)",null,{"v":100,"d":"$100.00"}]
["$50,000 Coverage (B)",null,{"v":150,"d":"$150.00"}]
["$100,000 Coverage (C)",null,{"v":200,"d":"$200.00"}]
[]
["Risk Factor Tables:","Age of Driver",null,null,"Model Type",null,null,"Model Year"]
[null,"Under 18",1.3,null,"Sedan",1,null,"Last 5 Years",1.2]
[null,"19-30",1,null,"SUV",0.9,null,"6-14 Years Ago",1]
[null,"31-64",0.8,null,"Truck",1.1,null,"15 Years or Older",0.95]
[null,"65+",1.2]
[]
[]
[]
[]
["Q1: Find the price per month of a $20,000 coverage on a driver age 17 covering a sedan with a model year of 2010."]
["Answer found by taking base coverage and multiplying by appropriate risk factors (e.g. $100*1.3*1*1=$130)"]
["Answer:","Excel","VBA"]
[null,{"$f":"$C$4*C9*F9*I10","v":{"v":130,"d":"$130.00"}}]

{"sheet":"2-D Arrays","index":8,"n_rows":23,"n_cols":27,"rows_kept":23}
["2-D Arrays"]
["Up until now, we only saw 1-D arrays in which there is one list of elements denoted by integer values."]
["Now, we will see that you can create an array that is a \"table\" of elements where there are two components (integer values) that correspond to one element"]
[]
["Life Table (tPx)","(tPx denotes probability of someone aged x surviving t number of years)"]
[null,"e.g. 5P40 is the probaility someone age 40 lives to the age of 45"]
["x|t",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[40,1,0.9875,0.975,0.9625,0.95,0.9375,0.925,0.9125,0.9,0.8875,0.875,0.8625,0.85,0.8375,0.825,0.8125,0.8,0.7875,0.775,0.7625,0.75,0.7375,0.725,0.7125,0.7,0.6875]
[41,1,0.9873417721518988,0.9746835443037974,0.9620253164556962,0.9493670886075949,0.9367088607594937,0.9240506329113924,0.9113924050632911,0.8987341772151899,0.8860759493670887,0.8734177215189873,0.8607594936708861,0.8481012658227848,0.8354430379746836,0.8227848101265822,0.810126582278481,0.7974683544303798,0.7848101265822784,0.7721518987341772,0.759493670886076,0.7468354430379747,0.7341772151898734,0.7215189873417722,0.7088607594936709,0.6962025316455696,0.6835443037974683]
[42,1,0.9871794871794872,0.9743589743589743,0.9615384615384616,0.9487179487179487,0.9358974358974359,0.9230769230769231,0.9102564102564102,0.8974358974358975,0.8846153846153846,0.8717948717948718,0.858974358974359,0.8461538461538461,0.8333333333333334,0.8205128205128205,0.8076923076923077,0.7948717948717949,0.782051282051282,0.7692307692307692,0.7564102564102564,0.7435897435897436,0.7307692307692308,0.717948717948718,0.7051282051282051,0.6923076923076923,0.6794871794871795]
[43,1,0.987012987012987,0.974025974025974,0.961038961038961,0.948051948051948,0.935064935064935,0.922077922077922,0.9090909090909091,0.8961038961038961,0.8831168831168831,0.8701298701298701,0.8571428571428572,0.8441558441558441,0.8311688311688312,0.8181818181818181,0.8051948051948052,0.7922077922077921,0.7792207792207793,0.7662337662337663,0.7532467532467533,0.7402597402597403,0.7272727272727273,0.7142857142857143,0.7012987012987013,0.6883116883116883,0.6753246753246753]
[44,1,0.9868421052631579,0.9736842105263158,0.9605263157894737,0.9473684210526316,0.9342105263157895,0.9210526315789473,0.9078947368421053,0.8947368421052632,0.881578947368421,0.868421052631579,0.8552631578947368,0.8421052631578947,0.8289473684210527,0.8157894736842105,0.8026315789473684,0.7894736842105263,0.7763157894736842,0.7631578947368421,0.75,0.736842105263158,0.7236842105263157,0.7105263157894737,0.6973684210526316,0.6842105263157895,0.6710526315789473]
[45,1,0.9866666666666667,0.9733333333333334,0.96,0.9466666666666667,0.9333333333333333,0.92,0.9066666666666666,0.8933333333333333,0.88,0.8666666666666667,0.8533333333333333,0.84,0.8266666666666667,0.8133333333333334,0.8,0.7866666666666666,0.7733333333333333,0.76,0.7466666666666666,0.7333333333333334,0.72,0.7066666666666667,0.6933333333333334,0.6799999999999999,0.6666666666666667]
[46,1,0.9864864864864865,0.972972972972973,0.9594594594594594,0.9459459459459459,0.9324324324324325,0.9189189189189189,0.9054054054054054,0.8918918918918919,0.8783783783783784,0.8648648648648649,0.8513513513513513,0.8378378378378378,0.8243243243243243,0.8108108108108107,0.7972972972972973,0.7837837837837838,0.7702702702702703,0.7567567567567568,0.7432432432432432,0.7297297297297297,0.7162162162162162,0.7027027027027026,0.6891891891891893,0.6756756756756757,0.6621621621621622]
[47,1,0.9863013698630136,0.9726027397260274,0.9589041095890412,0.9452054794520548,0.9315068493150684,0.9178082191780822,0.904109589041096,0.8904109589041096,0.8767123287671232,0.863013698630137,0.8493150684931507,0.8356164383561644,0.821917808219178,0.8082191780821918,0.7945205479452055,0.7808219178082192,0.7671232876712328,0.7534246575342466,0.7397260273972603,0.726027397260274,0.7123287671232876,0.6986301369863014,0.6849315068493151,0.6712328767123288,0.6575342465753424]
[48,1,0.9861111111111112,0.9722222222222222,0.9583333333333334,0.9444444444444444,0.9305555555555556,0.9166666666666666,0.9027777777777778,0.8888888888888888,0.875,0.8611111111111112,0.8472222222222222,0.8333333333333334,0.8194444444444444,0.8055555555555556,0.7916666666666666,0.7777777777777778,0.7638888888888888,0.75,0.7361111111111112,0.7222222222222222,0.7083333333333333,0.6944444444444444,0.6805555555555556,0.6666666666666667,0.6527777777777778]
[49,1,0.9859154929577465,0.971830985915493,0.9577464788732395,0.9436619718309859,0.9295774647887324,0.9154929577464789,0.9014084507042254,0.8873239436619719,0.8732394366197183,0.8591549295774648,0.8450704225352113,0.8309859154929577,0.8169014084507042,0.8028169014084507,0.7887323943661972,0.7746478873239436,0.7605633802816901,0.7464788732394366,0.7323943661971831,0.7183098591549295,0.704225352112676,0.6901408450704225,0.676056338028169,0.6619718309859155,0.647887323943662]
[50,1,0.9857142857142858,0.9714285714285714,0.9571428571428572,0.9428571428571428,0.9285714285714286,0.9142857142857143,0.9,0.8857142857142857,0.8714285714285714,0.8571428571428572,0.8428571428571429,0.8285714285714285,0.8142857142857143,0.8,0.7857142857142857,0.7714285714285715,0.7571428571428571,0.7428571428571429,0.7285714285714286,0.7142857142857143,0.7,0.6857142857142857,0.6714285714285715,0.6571428571428571,0.6428571428571428]
[]
["We will now create the 2D array P(x,t) and assign the correct values of the table to the elements of the array and use to answers questions."]
["Example1:"]
["What is the probability that a 47 year old survives the next 13 years?",{"$nulls":8},"(run macro Arrays2D_Ex for answer)"]
["Answer:"]

{"sheet":"2-D Arrays (cont.)","index":9,"n_rows":17,"n_cols":4,"rows_kept":17}
["Answer the following questions using 2-D arrays in a VBA macro and the Table on Sheet \"2-D Arrays\""]
["Ex2: Calculate e42:2͞1Ι",null,null,"(defined as the term curtate life expectancy of someone age 42 for a term of 21 years)"]
[{"$nulls":3},"(formula: Σ tP42  from t=1 to t=21)"]
["In other words, use 2d Array to find the summation of P(42,1),P(42,2),…,P(42,21))."]
["Answer:"]
[]
["In Excel",{"$f":"SUM('2-D Arrays'!C10:W10)","v":18.038461538461544}]
[]
[]
["Q1: Calculate A4¹0:8͞ Ι",null,null,"(defined as expected value for term life of someone age 40 for a term of 8 years)"]
["Given: delta=0.05",null,null,"(formula: Σ (v^t+1)*(tP40)*(1-1P40+t) from t=0 to t=7"]
["v=e^-0.05"]
["*NOTE:VBA function for e^ is Exp()"]
["In other words, calculate (e^-0.05)*P(40,0)*(1-P(40,1))+(e^-0.05*2)*P(40,1)*(1-P(41,1))+…+(e^-0.05*8)*P(40,7)*(1-P(47,1))"]
["Answer:"]
[]
["If done right, answer will be 0.0844976583188943"]

{"sheet":"Select","index":10,"n_rows":5,"n_cols":6,"rows_kept":5}
["We will compare the same action using code with select and without."]
[]
[]
[{"$nulls":3},"Using Select:",null,"Without Select:"]
[null,"COPY THIS CELL"]

{"sheet":"Macro Recorder","index":11,"n_rows":23,"n_cols":11,"rows_kept":23}
[{"$nulls":10},"Using the macro recorder, recreate the format of the table. Then, find the macro created and see what"]
[{"$nulls":10},"the corresponding code is. (Note the use of select)"]
[]
[null,"California Rate Change"]
[null,2013,2014,2015,2016,2017,2018,2019]
[null,{"v":0.025522030718083344,"d":"2.55%"},{"v":0.09759794857997488,"d":"9.76%"},{"v":0.06571987903815672,"d":"6.57%"},{"v":0.039517953496039995,"d":"3.95%"},{"v":0.050707398585370544,"d":"5.07%"},{"v":0.014785593649766272,"d":"1.48%"},{"v":0.08693870980313058,"d":"8.69%"}]
[null,{"v":0.014561362712408954,"d":"1.46%"},{"v":0.0572194267212619,"d":"5.72%"},{"v":0.04535474904908532,"d":"4.54%"},{"v":0.06403142391870652,"d":"6.40%"},{"v":0.07309136254342283,"d":"7.31%"},{"v":0.0897870086074446,"d":"8.98%"},{"v":0.017917502131628772,"d":"1.79%"}]
[null,{"v":0.04462774758398601,"d":"4.46%"},{"v":0.09626866154945582,"d":"9.63%"},{"v":0.009213951525903864,"d":"0.92%"},{"v":0.011169215767352325,"d":"1.12%"},{"v":0.004167468701773358,"d":"0.42%"},{"v":0.013421627391603875,"d":"1.34%"},{"v":0.0832814879796826,"d":"8.33%"}]
[null,{"v":0.0657910195445555,"d":"6.58%"},{"v":0.009280428375530747,"d":"0.93%"},{"v":0.03941912819721009,"d":"3.94%"},{"v":0.0513896500098749,"d":"5.14%"},{"v":0.021901241888791546,"d":"2.19%"},{"v":0.025215409301452295,"d":"2.52%"},{"v":0.04357009737764324,"d":"4.36%"}]
[null,{"v":0.06269848977236048,"d":"6.27%"},{"v":0.07202499089624217,"d":"7.20%"},{"v":0.03274465792649177,"d":"3.27%"},{"v":0.09968416852473065,"d":"9.97%"},{"v":0.09143955532652909,"d":"9.14%"},{"v":0.08449739546681406,"d":"8.45%"},{"v":0.04538349201512979,"d":"4.54%"}]
[null,{"v":0.07833323528972196,"d":"7.83%"},{"v":0.06076522099195587,"d":"6.08%"},{"v":0.08197826084680301,"d":"8.20%"},{"v":0.005382866604666603,"d":"0.54%"},{"v":0.06843157841636754,"d":"6.84%"},{"v":0.06901831208559875,"d":"6.90%"},{"v":0.04870111142806029,"d":"4.87%"}]
[null,{"v":0.010876977276639532,"d":"1.09%"},{"v":0.02109002246357471,"d":"2.11%"},{"v":0.09905760723940985,"d":"9.91%"},{"v":0.03856937263182031,"d":"3.86%"},{"v":0.062439807088404645,"d":"6.24%"},{"v":0.032836311773079815,"d":"3.28%"},{"v":0.03955544081854885,"d":"3.96%"}]
[null,{"v":0.0801044989067966,"d":"8.01%"},{"v":0.0465367379724144,"d":"4.65%"},{"v":0.031079269682277512,"d":"3.11%"},{"v":0.027941373015930436,"d":"2.79%"},{"v":0.005134373288449123,"d":"0.51%"},{"v":0.05741520189182457,"d":"5.74%"},{"v":0.02343561322857184,"d":"2.34%"}]
[null,{"v":2.2659069566199562E-3,"d":"0.23%"},{"v":0.02376473634601479,"d":"2.38%"},{"v":0.08049860675582751,"d":"8.05%"},{"v":0.05177782743064881,"d":"5.18%"},{"v":0.028689965005947216,"d":"2.87%"},{"v":0.030914193586488857,"d":"3.09%"},{"v":0.014222200885237301,"d":"1.42%"}]
[null,{"v":0.09005208090417749,"d":"9.01%"},{"v":0.05424326432148842,"d":"5.42%"},{"v":0.09037453892924543,"d":"9.04%"},{"v":0.07594230656848242,"d":"7.59%"},{"v":0.08427188038009945,"d":"8.43%"},{"v":0.063045083352139,"d":"6.30%"},{"v":0.07855788424466256,"d":"7.86%"}]
[null,{"v":0.00795882700266678,"d":"0.80%"},{"v":0.05266364925238787,"d":"5.27%"},{"v":0.006882798642774035,"d":"0.69%"},{"v":0.01855239875593976,"d":"1.86%"},{"v":0.04017409444841128,"d":"4.02%"},{"v":0.08509795157553446,"d":"8.51%"},{"v":0.04635828678770805,"d":"4.64%"}]
[null,{"v":0.02082861411966528,"d":"2.08%"},{"v":0.08006914171672057,"d":"8.01%"},{"v":0.05107168532069335,"d":"5.11%"},{"v":0.06875635041991598,"d":"6.88%"},{"v":0.04096212414722755,"d":"4.10%"},{"v":0.022896113898116754,"d":"2.29%"},{"v":0.09685473407383052,"d":"9.69%"}]
[null,{"v":0.08022326739571264,"d":"8.02%"},{"v":0.020695256664849903,"d":"2.07%"},{"v":0.038901279576139494,"d":"3.89%"},{"v":0.061482552181136296,"d":"6.15%"},{"v":0.012268770684411946,"d":"1.23%"},{"v":0.012021309701852223,"d":"1.20%"},{"v":0.0765752641129434,"d":"7.66%"}]
[null,{"v":0.06600643061300024,"d":"6.60%"},{"v":0.0393998097646678,"d":"3.94%"},{"v":0.00539225126112729,"d":"0.54%"},{"v":0.0815608905166341,"d":"8.16%"},{"v":0.0421131181506935,"d":"4.21%"},{"v":0.02811412382155749,"d":"2.81%"},{"v":0.003432951954714647,"d":"0.34%"}]
[null,{"v":0.00856942770982987,"d":"0.86%"},{"v":0.0748056034148932,"d":"7.48%"},{"v":0.053008447548303125,"d":"5.30%"},{"v":0.02522706212876168,"d":"2.52%"},{"v":0.008860775105217555,"d":"0.89%"},{"v":0.02931011450625053,"d":"2.93%"},{"v":0.04466580190724456,"d":"4.47%"}]
[null,{"v":0.045395413757923886,"d":"4.54%"},{"v":0.09108352717008862,"d":"9.11%"},{"v":0.04832590536775646,"d":"4.83%"},{"v":1.5807923125167544E-3,"d":"0.16%"},{"v":0.07345635007819426,"d":"7.35%"},{"v":0.024073693817736642,"d":"2.41%"},{"v":0.030332343941425775,"d":"3.03%"}]
[null,{"v":0.05269090420783751,"d":"5.27%"},{"v":0.055757744339869963,"d":"5.58%"},{"v":0.02173136610265326,"d":"2.17%"},{"v":0.06970996421909106,"d":"6.97%"},{"v":0.023954619201905836,"d":"2.40%"},{"v":0.05952248093099186,"d":"5.95%"},{"v":0.09119595837343653,"d":"9.12%"}]
[null,{"$f":"AVERAGE(B$6:B$22)","v":{"v":0.044500366733646234,"d":"4.45%"}},{"$f":"AVERAGE(C$6:C$22)","v":{"v":0.05607448062008186,"d":"5.61%"}},{"v":0.047103199000579896,"d":"4.71%"},{"v":0.046604480500132266,"d":"4.66%"},{"v":0.04306261664948337,"d":"4.31%"},{"v":0.04364540737401483,"d":"4.36%"},{"v":0.05123405182727054,"d":"5.12%"}]

{"sheet":"Tuition Report","index":12,"n_rows":19,"n_cols":12,"rows_kept":19}
["Living Situation:","Off-Campus",{"$nulls":3},{"$f":"\"Tuition Rates & Living Costs for \"&B1&\" \"&IF(B1=\"Public\",B2,\"\")&\" Colleges in \"&B3&\" \"&B4","v":"Tuition Rates & Living Costs for Off-Campus  Colleges in New York 2025"}]
["College Type:","Out-Of-State"]
["State:","New York",null,null,"Living Costs (Per Year)",null,null,"Tuition (Per Semester)",null,null,"Total"]
["Start Year (yyyy):",2025,"<- for projections",null,{"$f":"INDEX([1]!tuit_tbl,MATCH($B$3,[1]!states,0),MATCH($B$1,[1]!Table2[#Headers],0))","v":{"v":15998,"d":"$15,998.00"}},{"v":15998,"d":"$15,998.00"},null,{"$f":"INDEX([1]!tuit_tbl,MATCH($B$3,[1]!states,0),MATCH($B$2,[1]!Table2[#Headers],0))","v":{"v":14183,"d":"$14,183.00"}},{"v":14183,"d":"$14,183.00"},null,{"$f":"$E$4+$H$4","v":{"v":30181,"d":"$30,181.00"}},{"v":30181,"d":"$30,181.00"}]
["(up to 2025)",{"$nulls":3},"Excel",null,null,"Excel",null,null,"Excel"]
[]
["Factors:",null,"                             Total Cost (With Expected Price Increase)"]
["Reputation:","Low",null,1,null,{"$f":"$K$4*(1.03)^(INDEX(List!$B$16:$B$24,MATCH('Tuition Report'!$B$4,List!$A$16:$A$24,0)))*INDEX(List!$A$8:$C$8,MATCH('Tuition Report'!$B$8,List!$A$7:$C$7,0))*INDEX(List!$A$13:$B$13,MATCH('Tuition Report'!$B$9,List!$A$12:$B$12,0))","v":{"v":33063.70804044364,"d":"$33,063.71"}},{"v":33063.70804044365,"d":"$33,063.71"}]
["Region:","Urban","Years at College",2,null,{"$f":"$K$4*(1.03)^(INDEX(List!$B$16:$B$24,MATCH('Tuition Report'!$B$4,List!$A$16:$A$24,0))+1)*INDEX(List!$A$8:$C$8,MATCH('Tuition Report'!$B$8,List!$A$7:$C$7,0))*INDEX(List!$A$13:$B$13,MATCH('Tuition Report'!$B$9,List!$A$12:$B$12,0))","v":{"v":34055.61928165695,"d":"$34,055.62"}},{"v":34055.61928165696,"d":"$34,055.62"}]
["(higher reputation means higher cost,",null,null,3,null,{"$f":"$K$4*(1.03)^(INDEX(List!$B$16:$B$24,MATCH('Tuition Report'!$B$4,List!$A$16:$A$24,0))+2)*INDEX(List!$A$8:$C$8,MATCH('Tuition Report'!$B$8,List!$A$7:$C$7,0))*INDEX(List!$A$13:$B$13,MATCH('Tuition Report'!$B$9,List!$A$12:$B$12,0))","v":{"v":35077.28786010666,"d":"$35,077.29"}},{"v":35077.28786010667,"d":"$35,077.29"}]
[" urban area is higher cost than rural)",null,null,4,null,{"$f":"$K$4*(1.03)^(INDEX(List!$B$16:$B$24,MATCH('Tuition Report'!$B$4,List!$A$16:$A$24,0))+3)*INDEX(List!$A$8:$C$8,MATCH('Tuition Report'!$B$8,List!$A$7:$C$7,0))*INDEX(List!$A$13:$B$13,MATCH('Tuition Report'!$B$9,List!$A$12:$B$12,0))","v":{"v":36129.60649590986,"d":"$36,129.61"}},{"v":36129.60649590987,"d":"$36,129.61"}]
[{"$nulls":3},"4 year total:",null,{"$f":"SUM($F$8:$F$11)","v":{"v":138326.22167811712,"d":"$138,326.22"}},{"v":138326.22167811714,"d":"$138,326.22"}]
[{"$nulls":5},"Excel","VBA"]
[{"$nulls":3},"(Total cost formula in excel is long and"]
[{"$nulls":3},"complicated. VBA can use variables"]
[{"$nulls":3},"to make calculation easier without printing."]
[{"$nulls":3},"Other workbooks don't need to be open."]
[{"$nulls":3},"Using Excel formulas that use other workbooks"]
[{"$nulls":3},"often fail when the other workbook isn’t open.)"]

{"sheet":"List","index":13,"n_rows":60,"n_cols":11,"rows_kept":60,"hidden":true}
[null,null,"Living Situation","In or Out of State:","State:","Year:","Reputation:","Region"]
[null,null,"On-Campus","In-State","Alaska",null,"Low","Urban"]
[null,null,"Off-Campus","Out-Of-State","Alabama",null,"Medium","Rural"]
[{"$nulls":3},"Private","Arkansas",null,"High"]
[{"$nulls":4},"American Samoa"]
["Reputation",{"$nulls":3},"Arizona",{"$nulls":4},"Q1","PA"]
["Low","Medium","High",null,"California",null,"File Location",null,null,"Q2","NJ"]
[0.9,1,1.1,null,"Colorado",null,"C:\\Users\\bcraw\\Documents\\Director of Technology\\",null,null,"Q3"]
[{"$nulls":4},"Connecticut",{"$nulls":4},"Q4"]
[{"$nulls":4},"District of Columbia",{"$nulls":4},"Annual"]
["Region",{"$nulls":3},"Delaware"]
["Rural","Urban",null,null,"Florida",null,"DO NOT EDIT THIS PAGE"]
[0.95,1.05,null,null,"Federated States of Micronesia"]
[{"$nulls":4},"Georgia"]
["Years After 2020",null,{"$f":"INDEX(List!$B$16:$B$24,MATCH('Tuition Report'!$B$4,List!$A$16:$A$24,0))","v":5},null,"Guam"]
[2020,0,null,null,"Hawaii"]
[2021,1,null,null,"Iowa"]
[2022,2,null,null,"Idaho"]
[2023,3,null,null,"Illinois"]
[2024,4,null,null,"Indiana"]
[2025,5,null,null,"Kansas"]
[{"$nulls":4},"Kentucky"]
[{"$nulls":4},"Louisiana"]
[{"$nulls":4},"Massachusetts"]
[{"$nulls":4},"Maryland"]
[{"$nulls":4},"Maine"]
[{"$nulls":4},"Marshall Islands"]
[{"$nulls":4},"Michigan"]
[{"$nulls":4},"Minnesota"]
[{"$nulls":4},"Missouri"]
[{"$nulls":4},"Northern Marianas"]
[{"$nulls":4},"Mississippi"]
[{"$nulls":4},"Montana"]
[{"$nulls":4},"North Carolina"]
[{"$nulls":4},"North Dakota"]
[{"$nulls":4},"Nebraska"]
[{"$nulls":4},"New Hampshire"]
[{"$nulls":4},"New Jersey"]
[{"$nulls":4},"New Mexico"]
[{"$nulls":4},"Nevada"]
[{"$nulls":4},"New York"]
[{"$nulls":4},"Ohio"]
[{"$nulls":4},"Oklahoma"]
[{"$nulls":4},"Oregon"]
[{"$nulls":4},"Pennsylvania"]
[{"$nulls":4},"Puerto Rico"]
[{"$nulls":4},"Palau"]
[{"$nulls":4},"Rhode Island"]
[{"$nulls":4},"South Carolina"]
[{"$nulls":4},"South Dakota"]
[{"$nulls":4},"Tennessee"]
[{"$nulls":4},"Texas"]
[{"$nulls":4},"Utah"]
[{"$nulls":4},"Virginia"]
[{"$nulls":4},"Virgin Islands"]
[{"$nulls":4},"Vermont"]
[{"$nulls":4},"Washington"]
[{"$nulls":4},"Wisconsin"]
[{"$nulls":4},"West Virginia"]
[{"$nulls":4},"Wyoming"]