{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Trial","Meeting (M)","M/U BHA (B)","Drilling (D)","Work String Free (S)","Cut Pipe (C)","POOH (P)","WOW (W)","NPT (N)","Total Time (Hours)"]
[1,2,16,40,0,3,4,10,6,{"$f":"SUM(Table1[[#This Row],[Meeting (M)]:[NPT (N)]])","v":81}]
[2,2,8,60,2,6,2,10,6,{"$f":"SUM(Table1[[#This Row],[Meeting (M)]:[NPT (N)]])","v":96}]
[3,2,16,30,2,6,9,10,6,{"$f":"SUM(Table1[[#This Row],[Meeting (M)]:[NPT (N)]])","v":81},null,"P0","P10","P50","P90","P100"]
[4,2,16,60,0,3,4,10,12,{"$f":"SUM(Table1[[#This Row],[Meeting (M)]:[NPT (N)]])","v":107},null,{"$f":"MIN(Table1[Total Time (Hours)])","v":66},{"$f":"SMALL(Table1[Total Time (Hours)],2)","v":69},{"$f":"MEDIAN(Table1[Total Time (Hours)])","v":96},{"$f":"LARGE(Table1[Total Time (Hours)],2)","v":104},{"$f":"MAX(Table1[Total Time (Hours)])","v":107}]
[5,2,8,60,2,6,4,10,12,{"$f":"SUM(Table1[[#This Row],[Meeting (M)]:[NPT (N)]])","v":104}]
[6,2,8,60,2,6,4,10,12,{"$f":"SUM(Table1[[#This Row],[Meeting (M)]:[NPT (N)]])","v":104}]
[7,2,6,60,0,3,9,10,6,{"$f":"SUM(Table1[[#This Row],[Meeting (M)]:[NPT (N)]])","v":96}]
[8,2,16,30,0,3,2,10,6,{"$f":"SUM(Table1[[#This Row],[Meeting (M)]:[NPT (N)]])","v":69}]
[9,2,8,60,2,3,2,10,12,{"$f":"SUM(Table1[[#This Row],[Meeting (M)]:[NPT (N)]])","v":99}]
[10,2,6,30,2,6,4,10,6,{"$f":"SUM(Table1[[#This Row],[Meeting (M)]:[NPT (N)]])","v":66}]
[11,2,16,40,2,3,4,10,6,{"$f":"SUM(Table1[[#This Row],[Meeting (M)]:[NPT (N)]])","v":83},null,{"$f":"_xlfn.PERCENTILE.INC(J2:J12, 0.1)","v":69}]
[]
[]
[]
[null,2,6,30,0,3,2,10,6]
[null,2,8,40,1,3,4,10,6]
[null,2,16,60,2,6,9,10,12]

{"sheet":"Sheet2","index":1,"n_rows":53,"n_cols":1,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Monte Carlo Exercise"]
["Scenario: Estimating Well Duration"]
["You are planning to drill a well and need to build a time estimate for the well duration based on uncertain drilling operations, weather, and unexpected nonproductive time. Since all these factors vary, we will use a Monte Carlo simulation to model different outcomes. "]
["We will be using 100% probability for all events for simplicity."]
[]
["Step 1: Define the Variables"]
["We assume:"]
["1. Meeting time (M): The time of the planning meeting in hours (deterministic)."]
["2. M/U BHA (B) The BHA operations in hours (random)."]
["3. Drilling (D): The drilling time in hours (random)."]
["4. Work String Free (S): The time working the string free in hours (random)."]
["5. Cut Pipe (C): The time cutting pipe and fishing in hours (random)."]
["6. POOH (P): The time pulling out of hole in hours (random)."]
["7. Waiting on Weather (W): The time spent waiting on weather to clear (deterministic)."]
["8. Nonproductive Time (N): Nonproductive time (random)."]
[]
[]
["Step 2: Assign Probability "]
["We assume:"]
["1. Meeting time (M) à 2 hours"]
["2. M/U BHA (B) à 6,8,16 hours"]
["3. Drilling (D) à 30,40,60 hours"]
["4. Work String Free (S) à 0,1,2 hours"]
["5. Cut Pipe (C) à 3,6 hours"]
["6. POOH (P) à 2,4,9 hours "]
["7. Waiting on Weather (W) à 10 hours"]
["8. Nonproductive Time (N) à 6,12 hours"]
[]
[]
["Step 3: Generate Random Samples (Simulating 10 Trials)"]
["To generate randomness:"]
["Roll a 6-sided die for M/U BHA (B)"]
["1-2 → 6 hours"]
["3-4 → 8 hours"]
["5-6 → 16 hours"]
["Roll a 6-sided die for Drilling (D)"]
["1-2 → 30 hours"]
["3-4 → 40 hours"]
["5-6 → 60 hours"]
["Roll a 6-sided die for Work String Free (S)"]
["1-3 → 0 hours"]
["4-5 → 1 hour"]
["6 → 2 hours"]
["Roll a 6-sided die for Cut Pipe (C)"]
["1-3 → 3 hours"]
["4-6 → 6 hours"]
["Roll a 6-sided die for POOH (P)"]
["1-2 → 2 hours"]
["3-4 → 4 hours"]
["5-6 → 9 hours"]
["Roll a 6-sided die for Nonproductive Time (N)"]
["1-3 → 6 hours"]
["4-6 → 12 hours"]