{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":2,"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":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["change level at count",null,50,null,null,"Runs 150 samplings of 4 induviduals after the initial 25 to fill in the chart."]
["to a value of ",null,15,null,null,"Uses the R-Bar value to get X-Bar UCL and LCL."]
["change sigma at count",null,100,null,null,"Starts with PV=10 and sigma = 2.  Enter your changes in the yellow Column 3."]
["to a value of ",null,4,null,null,"Green bar in Row 9 turns red when the event happens."]
["Observation Pause =",null,0.2,null,null,null,null,null,null,"i=",150]
[null,null,null,"Average"]
[null,"Sample","Sample","Sample","X-Bar","X-Bar","X-Bar","Sample","Range","Range","Range"]
[null,"Time","Number","Value","UCL","LCL","Average","Range","UCL","LCL","Average"]
[]
[null,"07:30:00",1,12.689457100742091,{"$f":"$D$37+0.729*$H$37","v":21.768928341862491},{"$f":"$D$37-0.729*$H$37","v":9.1771087298044698},{"$f":"$D$37","v":15.47301853583348},3.8154584237403206,{"$f":"2.282*$H$37","v":19.708184056732787},0,{"$f":"$H$37","v":8.6363646173237445}]
[null,"08:30:00",2,16.560399412960955,{"$f":"$D$37+0.729*$H$37","v":21.768928341862491},{"$f":"$D$37-0.729*$H$37","v":9.1771087298044698},{"$f":"$D$37","v":15.47301853583348},12.027655012064525,{"$f":"2.28*$H$37","v":19.690911327498135},0,{"$f":"$H$37","v":8.6363646173237445}]
[null,"09:30:00",3,16.274435620965896,21.768928341862491,9.1771087298044698,15.47301853583348,4.813058483610309,19.690911327498135,0,8.6363646173237445]
[null,"10:30:00",4,16.87908233817188,21.768928341862491,9.1771087298044698,15.47301853583348,10.389182378463497,19.690911327498135,0,8.6363646173237445]
[null,"11:30:00",5,11.009884743431842,21.768928341862491,9.1771087298044698,15.47301853583348,6.628011182051889,19.690911327498135,0,8.6363646173237445]
[null,"12:30:00",6,15.423679160285648,21.768928341862491,9.1771087298044698,15.47301853583348,10.030089345359972,19.690911327498135,0,8.6363646173237445]
[null,"01:30:00",7,14.698397684185494,21.768928341862491,9.1771087298044698,15.47301853583348,8.9052015811992629,19.690911327498135,0,8.6363646173237445]
[null,"02:30:00",8,14.33412780020862,21.768928341862491,9.1771087298044698,15.47301853583348,8.2135863275009928,19.690911327498135,0,8.6363646173237445]
[null,"03:30:00",9,14.695008641340346,21.768928341862491,9.1771087298044698,15.47301853583348,5.8388031072620876,19.690911327498135,0,8.6363646173237445]
[null,"04:30:00",10,13.783317487728855,21.768928341862491,9.1771087298044698,15.47301853583348,9.8718999280227209,19.690911327498135,0,8.6363646173237445]
[null,"05:30:00",11,16.874526888845683,21.768928341862491,9.1771087298044698,15.47301853583348,12.585011973048601,19.690911327498135,0,8.6363646173237445]
[null,"06:30:00",12,16.969624260834866,21.768928341862491,9.1771087298044698,15.47301853583348,10.406197688438123,19.690911327498135,0,8.6363646173237445]
[null,"07:30:00",13,15.525924406144677,21.768928341862491,9.1771087298044698,15.47301853583348,8.8109969064804368,19.690911327498135,0,8.6363646173237445]
[null,"08:30:00",14,15.256856583373422,21.768928341862491,9.1771087298044698,15.47301853583348,6.213180132713509,19.690911327498135,0,8.6363646173237445]
[null,"09:30:00",15,15.612580086538447,21.768928341862491,9.1771087298044698,15.47301853583348,4.4985809240492305,19.690911327498135,0,8.6363646173237445]
[null,"10:30:00",16,13.628714804075349,21.768928341862491,9.1771087298044698,15.47301853583348,12.062337515413947,19.690911327498135,0,8.6363646173237445]
[null,"11:30:00",17,13.950998687142672,21.768928341862491,9.1771087298044698,15.47301853583348,9.2739435076981849,19.690911327498135,0,8.6363646173237445]
[null,"12:30:00",18,15.989659349121816,21.768928341862491,9.1771087298044698,15.47301853583348,3.5147139085828218,19.690911327498135,0,8.6363646173237445]
[null,"01:30:00",19,17.370531976673622,21.768928341862491,9.1771087298044698,15.47301853583348,9.4567878745757437,19.690911327498135,0,8.6363646173237445]
[null,"02:30:00",20,16.627834701512896,21.768928341862491,9.1771087298044698,15.47301853583348,14.717983945985463,19.690911327498135,0,8.6363646173237445]
[null,"03:30:00",21,14.539602196705264,21.768928341862491,9.1771087298044698,15.47301853583348,11.360385396425066,19.690911327498135,0,8.6363646173237445]
[null,"04:30:00",22,13.006751162262312,21.768928341862491,9.1771087298044698,15.47301853583348,8.1714807055616099,19.690911327498135,0,8.6363646173237445]
[null,"05:30:00",23,17.669133023194622,21.768928341862491,9.1771087298044698,15.47301853583348,9.5281713544792588,19.690911327498135,0,8.6363646173237445]
[null,"06:30:00",24,21.180424484307348,21.768928341862491,9.1771087298044698,15.47301853583348,11.96781657033544,19.690911327498135,0,8.6363646173237445]
[null,"06:30:00",25,16.2745107950823,21.768928341862491,9.1771087298044698,15.47301853583348,2.8085812600305804,19.690911327498135,0,8.6363646173237445]
[]
[]
[null,null,"Avg X-Bar",{"$f":"AVERAGE(D10:D34)","v":15.47301853583348},null,null,"Avg Range",{"$f":"AVERAGE(H10:H34)","v":8.6363646173237445}]
[]
[null,null,1,null,{"$f":"$D$37+0.73*$H$37","v":21.777564706479815},{"$f":"$D$37-0.73*$H$37","v":9.1684723651871458},{"$f":"$D$37","v":15.47301853583348},null,{"$f":"2.28*$H$37","v":19.690911327498135},0,{"$f":"$H$37","v":8.6363646173237445}]
[null,null,25,null,{"$f":"$D$37+0.73*$H$37","v":21.777564706479815},{"$f":"$D$37-0.73*$H$37","v":9.1684723651871458},{"$f":"$D$37","v":15.47301853583348},null,{"$f":"2.28*$H$37","v":19.690911327498135},0,{"$f":"$H$37","v":8.6363646173237445}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}