{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Problem 1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":8,"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":"Problem 1","index":0,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["<Alt> + F11 to open VBA editor"]
[]
["<fn> + <alt> + F11 on Mac"]
[]
[]
["Modules:"]
["CallBackLib","Library for callback functions"]
["numLib","Simple library of numerical routines"]
["MainProg","Main program and the required cost functions"]
[]
[]
[]
["Input parameters and data:"]
["Parameter","Value",null,null,"The B(r;mu;sigma) function is implemented in VBA in the BackorderLib module:"]
["DD",30]
["C_OT",1000]
["C_PD",10000]
["Datapoints",25,null,null,"where"]
[null,35]
[null,28]
[null,41]
[null,22]
[null,31,null,null,"and D is N(mu,sigma^2)"]
[null,28]
[null,25]
["muHat",{"$f":"AVERAGE(B18:B25)","v":29.375},{"$f":"_xlfn.FORMULATEXT(B26)","v":"=AVERAGE(B18:B25)"}]
["sigmaHat",{"$f":"STDEV(B18:B25)","v":6.1629654272227468},{"$f":"_xlfn.FORMULATEXT(B27)","v":"=STDEV(B18:B25)"}]
["mu_0",{"$f":"muHat","v":29.375},"=muHat"]
["sigma",{"$f":"sigmaHat","v":6.1629654272227468},"=sigmaHat"]