{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Sheet 1"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet 1","index":0,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[17,0,17,7],[17,9,17,15]],"flags":["formulas_cached_only"]}
["Hiring Risky Workers-- Spreadsheet Example"]
[null,"for Figure 13.1 in Kuhn, P. Personnel Economics"]
[]
["In this example, \"bad\" workers are detected after TWO periods"]
["Discount","Rate =",0.2,0.2]
["Quit ","Rate = ",0.2,0.2]
["Firing ","Cost =",0,0]
[]
[]
[null,null,"\"Safe\" Worker Characteristics:",{"$nulls":6},"\"Risky\" Worker Characteristics:"]
[{"$nulls":3},"actual",null,"base case",{"$nulls":5},"actual","base case"]
[null,null,"Sales:",100,null,100,{"$nulls":3},"Sales if","Bad:",-100,-100]
[{"$nulls":9},"Sales if","Good:",300,300]
[{"$nulls":9},"Probability (Good)",null,0.5,0.5]
[null,null,"Salary:",50,null,50,{"$nulls":3},"Salary:",null,50,50]
[{"$nulls":9},"Expected Sales:",null,100,100]
[]
["Safe Worker",{"$nulls":8},"Risky Worker"]
["(1)","(2)","(3)","(4)","(1)","(5)","(6)","(7)",null,"(1)","(2)","(3)","(4)","(5)","(6)","(7)"]
[{"$nulls":5},"Share of ","Sales-","EPV(Sales-",{"$nulls":5},"Sales -","Sales-","EPV(Sales-"]
[{"$nulls":5},"workers","Salary","Salary)",{"$nulls":5},"Salary -","Salary-FC","Salary-FC)"]
[{"$nulls":3}," Sales-",null," who haven't","after","after",null,"Sales ","Salary","Sales","Salary","Firing ","after","after"]
["Year","Sales","Salary","Salary","PV (Profits) if stay"," quit (R)","quits","quits",null,"If Bad ","if Bad","If Good","if Good","Costs)","quits","quits"]
[1,100,50,50,{"$error":"#REF!"},{"v":1,"d":"1.000"},{"v":50,"d":"50.0"},{"v":50,"d":"50.0"},null,-100,50,300,50,50,{"v":50,"d":"50.0"},{"v":50,"d":"50.0"}]
[2,100,50,50,{"$error":"#REF!"},{"v":0.8,"d":"0.800"},{"v":40,"d":"40.0"},{"v":33.333333333333336,"d":"33.3"},null,-100,50,300,50,50,{"v":40,"d":"40.0"},{"v":33.333333333333336,"d":"33.3"}]
[3,100,50,50,{"$error":"#REF!"},{"v":0.6400000000000001,"d":"0.640"},{"v":32.00000000000001,"d":"32.0"},{"v":22.22222222222223,"d":"22.2"},null,0,0,300,50,125,{"v":80.00000000000001,"d":"80.0"},{"v":55.555555555555564,"d":"55.6"}]
[4,100,50,50,{"$error":"#REF!"},{"v":0.5120000000000001,"d":"0.512"},{"v":25.600000000000005,"d":"25.6"},{"v":14.814814814814818,"d":"14.8"},null,0,0,300,50,125,{"v":64.00000000000001,"d":"64.0"},{"v":37.037037037037045,"d":"37.0"}]
[5,100,50,50,{"$error":"#REF!"},{"v":0.4096000000000002,"d":"0.410"},{"v":20.48000000000001,"d":"20.5"},{"v":9.87654320987655,"d":"9.9"},null,0,0,300,50,125,{"v":51.200000000000024,"d":"51.2"},{"v":24.69135802469137,"d":"24.7"}]
[6,100,50,50,{"$error":"#REF!"},{"v":0.3276800000000002,"d":"0.328"},{"v":16.38400000000001,"d":"16.4"},{"v":6.5843621399177,"d":"6.6"},null,0,0,300,50,125,{"v":40.96000000000002,"d":"41.0"},{"v":16.46090534979425,"d":"16.5"}]
[7,100,50,50,{"$error":"#REF!"},{"v":0.26214400000000015,"d":"0.262"},{"v":13.107200000000008,"d":"13.1"},{"v":4.389574759945133,"d":"4.4"},null,0,0,300,50,125,{"v":32.76800000000002,"d":"32.8"},{"v":10.973936899862833,"d":"11.0"}]
[8,100,50,50,{"$error":"#REF!"},{"v":0.20971520000000016,"d":"0.210"},{"v":10.485760000000008,"d":"10.5"},{"v":2.926383173296756,"d":"2.9"},null,0,0,300,50,125,{"v":26.21440000000002,"d":"26.2"},{"v":7.31595793324189,"d":"7.3"}]
[9,100,50,50,{"$error":"#REF!"},{"v":0.16777216000000014,"d":"0.168"},{"v":8.388608000000007,"d":"8.4"},{"v":1.950922115531171,"d":"2.0"},null,0,0,300,50,125,{"v":20.97152000000002,"d":"21.0"},{"v":4.877305288827928,"d":"4.9"}]
[10,100,50,50,{"$error":"#REF!"},{"v":0.13421772800000012,"d":"0.134"},{"v":6.710886400000006,"d":"6.7"},{"v":1.3006147436874473,"d":"1.3"},null,0,0,300,50,125,{"v":16.777216000000013,"d":"16.8"},{"v":3.2515368592186182,"d":"3.3"}]
[]
["SUM",1000,500,500,{"$error":"#REF!"},null,{"v":223.15645440000003,"d":"223"},{"v":147.39877051262513,"d":"147"},null,-200,100,3000,500,1100,{"v":422.89113600000013,"d":"423"},{"v":243.49692628156282,"d":"243"}]
[]
["Note: All magnitudes are in thousands of dollars.  \"base case\" parameter values are in bold.  "]