{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Intro","Explanation","Start","Forecasts","MC Data","User Calculations"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"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":"Intro","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,13,16],[22,4,26,12],[15,1,21,16]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Welcome to The Monte Carlo Tool.\n\nThis tool provides an easy way to implement Monte Carlo analysis following the simulation segment of ASTM E1369. The user can enter equations and models where variables within the model are drawn from random sampling. \n\n"]

{"sheet":"Explanation","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,0,2,13]]}
["What is Monte Carlo Analysis"]

{"sheet":"Start","index":2,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,19,9],[17,1,17,9],[0,0,6,9],[13,1,13,9],[15,1,15,9],[9,1,9,9],[11,1,11,9]]}
["Instructions"]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 1: ","Navigate to the \"User Calculations\" tab or add a new tab by clicking the \"+\" symbol next to the tabs below. "]
[]
["Step 2: ","Enter the desired model and/or calculations. For instance, if the user is examining costs, then they would enter the price and quantity calculations. The equations to the right can be used for creating randomly sampled variables within these calculations. "]
[]
["Step 3: ","Navigate to the \"Forecasts\" tab."]
[]
["Step 4: ","Enter the number of desired trials."]
[]
["Step 5: ","Enter the variables to be forecasted sequentially in columns \"B\" and \"C\" by entering \"=\" and selecting the cells with the forecasted variable. Use column \"C\" to provide a name of the forecasted variable."]
[]
["Step 6: ","Click the \"Start Simulation\" button in the \"Forecasts\" tab. The results will be shown in a tab labeled \"MC Data.\" The user can use this data to calculate summary statistics, such as the average, maximum, and minimum values. "]

{"sheet":"Forecasts","index":3,"n_rows":1012,"n_cols":10,"rows_kept":1012,"cut":false,"hidden":false,"merged":[[4,9,18,16],[0,0,4,2]]}
["Trials and Forecasts"]
[]
[null,null,null,null,"Simulation Progress"]
[null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"In this tab, the user selects the number of trials and indicates what is to be forecasted. Typically, 1000 or more trials are selected. The variables to be forecasted must be entered sequentially (Do not leave blank cells in between) in columns \"B\" and \"C\" to the left, starting with cells B12 and C12. For instance, if the user types 'User Calculations'!E11 into cell B12, then the value in cell E11 in the \"User Calculations\" tab will be forecasted. A maximum of 1,000 forecast variables can be entered. \n\nOnce the user has entered the forecast variables, the simulation can be started by clicking the \"Start Simulation\" button.\n\nThe simulation results will be revealed in a tab titled \"MC Data.\" "]
[]
[null,"User Selected Total"]
["Trials",10000,null,{"$f":"MAX(A12:A1048576)","v":0}]
[null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(\"Error: Do not leave blank spaces\",A12:A1012,1,FALSE),0)","v":0}]
[]
["ID","Simulated Forecast Values","Name"]
[{"$f":"IF(B12=\"\",\"\",1)","v":""}]
[{"$f":"IF(B13=\"\",\"\",IF(ISNUMBER(A12)=TRUE,A12+1,\"Error: Do not leave blank spaces\"))","v":""}]
[{"$f":"IF(B14=\"\",\"\",IF(ISNUMBER(A13)=TRUE,A13+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B78=\"\",\"\",IF(ISNUMBER(A77)=TRUE,A77+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B142=\"\",\"\",IF(ISNUMBER(A141)=TRUE,A141+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B206=\"\",\"\",IF(ISNUMBER(A205)=TRUE,A205+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B270=\"\",\"\",IF(ISNUMBER(A269)=TRUE,A269+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B334=\"\",\"\",IF(ISNUMBER(A333)=TRUE,A333+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B398=\"\",\"\",IF(ISNUMBER(A397)=TRUE,A397+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B462=\"\",\"\",IF(ISNUMBER(A461)=TRUE,A461+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B526=\"\",\"\",IF(ISNUMBER(A525)=TRUE,A525+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B590=\"\",\"\",IF(ISNUMBER(A589)=TRUE,A589+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B654=\"\",\"\",IF(ISNUMBER(A653)=TRUE,A653+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B718=\"\",\"\",IF(ISNUMBER(A717)=TRUE,A717+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B782=\"\",\"\",IF(ISNUMBER(A781)=TRUE,A781+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B846=\"\",\"\",IF(ISNUMBER(A845)=TRUE,A845+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B910=\"\",\"\",IF(ISNUMBER(A909)=TRUE,A909+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B974=\"\",\"\",IF(ISNUMBER(A973)=TRUE,A973+1,\"Error: Do not leave blank spaces\"))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"MC Data","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"User Calculations","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}