{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["836","836 (an)","837","837 (an)","838","838 (an)","839","839 (an)","840","840 (an)","841","841 (an)","842","842 (an)","843","843 (an)","844","844 (an)","845","845 (an)","846","846 (an)","847","848","847 (an)","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":2,"pivot_tables":1},"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":"836","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Lookup Value","data1",null,"Lookup Value","Solves problem if cell D2 has an extra space"]
["x2",0.22,null,"x2 "]
["GOOG ",0.13,null,null,{"$f":"ShowFormulaTop","v":" "}]
[2,4.2500000000000003E-2,null,"Lookup Value","Solves problem if cell in 1st column in table has extra spaces, Enter formula with Ctrl + Shift + Enter"]
["77",0.25750000000000001,null,"GOOG"]
[null,null,null,null,{"$f":"ShowFormulaTop","v":" "}]
[null,null,null,"Lookup Value","Solves problem if cell D8 is a number stored as text and the number in the lookup table is a number"]
[null,null,null,"2"]
[null,null,null,null,{"$f":"ShowFormulaTop","v":" "}]
[null,null,null,"Lookup Value","Solves problem if cell in 1st column in table has number stored as text, but D11 is a number"]
[null,null,null,77]
[null,null,null,null,{"$f":"ShowFormulaTop","v":" "}]
[null,null,null,null," =VLOOKUP(D11,A2:B5+0,2,0), Ctrl + Shift + Enter"]

{"sheet":"836 (an)","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Lookup Value","data1",null,"Lookup Value","Solves problem if cell D2 has an extra space"]
["x2",0.22,null,"x2 ",{"$f":"VLOOKUP(TRIM(D2),A2:B5,2,0)","v":0.22}]
["GOOG ",0.13,null,null,{"$f":"ShowFormulaTop","v":" =VLOOKUP(TRIM(D2),A2:B5,2,0)"}]
[2,4.2500000000000003E-2,null,"Lookup Value","Solves problem if cell in 1st column in table has extra spaces, Enter formula with Ctrl + Shift + Enter"]
["77",0.25750000000000001,null,"GOOG",{"$f":"--VLOOKUP(D5,TRIM(A2:B5),2,0)","v":0.13}]
[null,null,null,null,{"$f":"ShowFormulaTop","v":" =--VLOOKUP(D5,TRIM(A2:B5),2,0)"}]
[null,null,null,"Lookup Value","Solves problem if cell D8 is a number stored as text and the number in the lookup table is a number"]
[null,null,null,"2",{"$f":"VLOOKUP(D8+0,A2:B5,2,0)","v":4.2500000000000003E-2}]
[null,null,null,null,{"$f":"ShowFormulaTop","v":" =VLOOKUP(D8+0,A2:B5,2,0)"}]
[null,null,null,"Lookup Value","Solves problem if cell in 1st column in table has number stored as text, but D11 is a number"]
[null,null,null,77,{"$f":"VLOOKUP(D11&\"\",A2:B5,2,0)","v":0.25750000000000001}]
[null,null,null,null,{"$f":"ShowFormulaTop","v":" =VLOOKUP(D11&\"\",A2:B5,2,0)"}]
[null,null,null,null," =VLOOKUP(D11,A2:B5+0,2,0), Ctrl + Shift + Enter"]
[null,null,null,null,{"$f":"VLOOKUP(D11,A2:B5+0,2,0)","v":0.25750000000000001}]

{"sheet":"837","index":2,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Probability that Pete Catch Fish on particular Day",0.8,"Catch Fish","F"]
["Probability that Pete NOT Catch Fish on particular Day",{"$f":"1-B1","v":0.19999999999999996},"Not Catch Fish","NF"]
["Days gone fishing",3]
[]
["Sample Space",null,null,"Multiply"]
["Day 1","Day 2","Day 3","Pr","Count F (F = Success)",null,"Successes","Pr","Pr",null,null,1]
["F","F","F",null,{"$f":"COUNTIF(A7:C7,$D$1)","v":3},null,0,{"$f":"\"P(x=\"&G7&\")\"","v":"P(x=0)"},{"$f":"SUMIF($E$7:$E$14,G7,$D$7:$D$14)","v":0},"Add these","P(X<=1) =",{"$f":"SUM(I7:I8)","v":0}]
["NF","F","F",null,{"$f":"COUNTIF(A8:C8,$D$1)","v":2},null,1,{"$f":"\"P(x=\"&G8&\")\"","v":"P(x=1)"},{"$f":"SUMIF($E$7:$E$14,G8,$D$7:$D$14)","v":0},"Two"]
["F","NF","F",null,2,null,2,{"$f":"\"P(x=\"&G9&\")\"","v":"P(x=2)"},{"$f":"SUMIF($E$7:$E$14,G9,$D$7:$D$14)","v":0}]
["F","F","NF",null,2,null,3,{"$f":"\"P(x=\"&G10&\")\"","v":"P(x=3)"},{"$f":"SUMIF($E$7:$E$14,G10,$D$7:$D$14)","v":0}]
["NF","NF","F",null,1]
["NF","F","NF",null,1]
["F","NF","NF",null,1,null,null,"Or:"]
["NF","NF","NF",null,0,null,1,"Fixed # Trials?",null,null,"Yes"]
[null,null,null,null,null,null,2,"2 Outcomes on each trial?",null,null,"Yes"]
[null,null,null,null,null,null,3,"Pr same each Trial?",null,null,"Yes"]
[null,null,null,null,null,null,4,"Independent?",null,null,"Yes"]
[]
[null,null,null,null,null,null,2,{"$f":"H7","v":"P(x=0)"},{"$f":"BINOMDIST(G7,$B$3,$B$1,0)","v":7.9999999999999967E-3}]
[null,null,null,null,null,null,null,{"$f":"H8","v":"P(x=1)"},{"$f":"BINOMDIST(G8,$B$3,$B$1,0)","v":9.599999999999996E-2}]
[null,null,null,null,null,null,null,"Add",{"$f":"SUM(I19:I20)","v":0.10399999999999995}]
[]
[null,null,null,null,null,null,3,"P(X<=1) =",{"$f":"BINOMDIST(G8,B3,B1,1)","v":0.10399999999999998}]

{"sheet":"837 (an)","index":3,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Probability that Pete Catch Fish on particular Day",0.8,"Catch Fish","F"]
["Probability that Pete NOT Catch Fish on particular Day",{"$f":"1-B1","v":0.19999999999999996},"Not Catch Fish","NF"]
["Days gone fishing",3]
[]
["Sample Space",null,null,"Multiply"]
["Day 1","Day 2","Day 3","Pr","Count F (F = Success)",null,"Successes","Pr","Pr",null,null,1]
["F","F","F",{"$f":"PRODUCT(SUMIF($D$1:$D$2,A7:C7,$B$1:$B$2))","v":0.51200000000000012},{"$f":"COUNTIF(A7:C7,$D$1)","v":3},null,0,{"$f":"\"P(x=\"&G7&\")\"","v":"P(x=0)"},{"$f":"SUMIF($E$7:$E$14,G7,$D$7:$D$14)","v":7.999999999999995E-3},"Add these","P(X<=1) =",{"$f":"SUM(I7:I8)","v":0.10399999999999995}]
["NF","F","F",{"$f":"PRODUCT(SUMIF($D$1:$D$2,A8:C8,$B$1:$B$2))","v":0.12799999999999997},{"$f":"COUNTIF(A8:C8,$D$1)","v":2},null,1,{"$f":"\"P(x=\"&G8&\")\"","v":"P(x=1)"},{"$f":"SUMIF($E$7:$E$14,G8,$D$7:$D$14)","v":9.599999999999996E-2},"Two"]
["F","NF","F",{"$f":"PRODUCT(SUMIF($D$1:$D$2,A9:C9,$B$1:$B$2))","v":0.12799999999999997},2,null,2,{"$f":"\"P(x=\"&G9&\")\"","v":"P(x=2)"},{"$f":"SUMIF($E$7:$E$14,G9,$D$7:$D$14)","v":0.38399999999999995}]
["F","F","NF",{"$f":"PRODUCT(SUMIF($D$1:$D$2,A10:C10,$B$1:$B$2))","v":0.128},2,null,3,{"$f":"\"P(x=\"&G10&\")\"","v":"P(x=3)"},{"$f":"SUMIF($E$7:$E$14,G10,$D$7:$D$14)","v":0.51200000000000012}]
["NF","NF","F",{"$f":"PRODUCT(SUMIF($D$1:$D$2,A11:C11,$B$1:$B$2))","v":3.1999999999999987E-2},1]
["NF","F","NF",{"$f":"PRODUCT(SUMIF($D$1:$D$2,A12:C12,$B$1:$B$2))","v":3.1999999999999987E-2},1]
["F","NF","NF",{"$f":"PRODUCT(SUMIF($D$1:$D$2,A13:C13,$B$1:$B$2))","v":3.1999999999999987E-2},1,null,null,"Or:"]
["NF","NF","NF",{"$f":"PRODUCT(SUMIF($D$1:$D$2,A14:C14,$B$1:$B$2))","v":7.999999999999995E-3},0,null,1,"Fixed # Trials?",null,null,"Yes"]
[null,null,null,null,null,null,2,"2 Outcomes on each trial?",null,null,"Yes"]
[null,null,null,null,null,null,3,"Pr same each Trial?",null,null,"Yes"]
[null,null,null,null,null,null,4,"Independent?",null,null,"Yes"]
[]
[null,null,null,null,null,null,2,{"$f":"H7","v":"P(x=0)"},{"$f":"BINOMDIST(G7,$B$3,$B$1,0)","v":7.9999999999999967E-3}]
[null,null,null,null,null,null,null,{"$f":"H8","v":"P(x=1)"},{"$f":"BINOMDIST(G8,$B$3,$B$1,0)","v":9.599999999999996E-2}]
[null,null,null,null,null,null,null,"Add",{"$f":"SUM(I19:I20)","v":0.10399999999999995}]
[]
[null,null,null,null,null,null,3,"P(X<=1) =",{"$f":"BINOMDIST(G8,B3,B1,1)","v":0.10399999999999998}]

{"sheet":"838","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Dept","Sales","Comission","Comission"]
["Oper",4360]
["Oper",624]
["Oper",6522]
["Acc",2946]
["Fin",8275]
["Acc",7697]
["Oper",175]
[]
["Dept/Sales",0,500,2500,5000]
["Acc",2.1999999999999999E-2,2.8000000000000001E-2,0.03,0.04]
["Fin",1.4E-2,0.02,2.9000000000000001E-2,3.2000000000000001E-2]
["Oper",0.02,2.1999999999999999E-2,2.9000000000000001E-2,3.1E-2]

{"sheet":"838 (an)","index":5,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Dept","Sales","Comission","Comission"]
["Oper",4360,{"$f":"VLOOKUP(A2,$A$11:$E$13,MATCH(B2,$A$10:$E$10),0)*B2","v":126.44000000000001},{"$f":"INDEX($B$11:$E$13,MATCH(A2,$A$11:$A$13,0),MATCH(B2,$B$10:$E$10))*B2","v":126.44000000000001}]
["Oper",624,{"$f":"VLOOKUP(A3,$A$11:$E$13,MATCH(B3,$A$10:$E$10),0)*B3","v":13.728},{"$f":"INDEX($B$11:$E$13,MATCH(A3,$A$11:$A$13,0),MATCH(B3,$B$10:$E$10))*B3","v":13.728}]
["Oper",6522,202.18199999999999,202.18199999999999]
["Acc",2946,88.38,88.38]
["Fin",8275,264.8,264.8]
["Acc",7697,307.88,307.88]
["Oper",175,3.5,3.5]
[]
["Dept/Sales",0,500,2500,5000]
["Acc",2.1999999999999999E-2,2.8000000000000001E-2,0.03,0.04]
["Fin",1.4E-2,0.02,2.9000000000000001E-2,3.2000000000000001E-2]
["Oper",0.02,2.1999999999999999E-2,2.9000000000000001E-2,3.1E-2]

{"sheet":"839","index":6,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Date","Percentage","STDEV","STDEV"]
["2009-08-19",0.26750000000000002]
["2009-08-19",0.26790000000000003]
["2009-08-19",0.28139999999999998]
["2009-08-19",0.26569999999999999]
["2009-08-19",0.26400000000000001]
["2009-08-19",0.25540000000000002]
["2009-08-19",0.2661]
["2009-09-16",0.3654]
["2009-09-16",0.37269999999999998]
["2009-09-16",0.37919999999999998]
["2009-09-16",0.37840000000000001]
["2009-09-16",0.371]
["2009-09-16",0.32329999999999998]
["2009-09-16",0.31640000000000001]
["2009-09-16",0.32819999999999999]
["2009-09-16",0.315]
["2009-09-16",0.32800000000000001]
["2009-09-16",0.33689999999999998]
["2009-09-16",0.32990000000000003]
["2009-09-16",0.32990000000000003]
["2009-09-16",0.31619999999999998]
["2009-09-16",0.29520000000000002]
["2009-09-16",0.2903]
["2009-09-16",0.28570000000000001]
["2009-09-16",0.30149999999999999]
["2009-10-14",0.20200000000000001]
["2009-10-14",0.1953]
["2009-10-14",0.33360000000000001]
["2009-10-14",0.32990000000000003]
["2009-10-14",0.31369999999999998]
["2009-10-14",0.32229999999999998]
["2009-10-14",0.32029999999999997]
["2009-10-14",0.33479999999999999]
["2009-10-14",0.33169999999999999]
["2009-10-14",0.33679999999999999]

{"sheet":"839 (an)","index":7,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Date","Percentage","STDEV","STDEV"]
["2009-08-19",0.26750000000000002,{"$f":"IF(A1<>A2,_xlfn.STDEV.S(IF($A$2:$A$36=A2,$B$2:$B$36)),\"\")","v":7.6848025658562196E-3},{"$f":"IF(A1<>A2,_xlfn.STDEV.S(B2:INDEX($B$2:$B$36,MATCH(A2,$A$2:$A$36))),\"\")","v":7.6848025658562196E-3}]
["2009-08-19",0.26790000000000003,{"$f":"IF(A2<>A3,_xlfn.STDEV.S(IF($A$2:$A$36=A3,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A2<>A3,_xlfn.STDEV.S(B3:INDEX($B$2:$B$36,MATCH(A3,$A$2:$A$36))),\"\")","v":""}]
["2009-08-19",0.28139999999999998,{"$f":"IF(A3<>A4,_xlfn.STDEV.S(IF($A$2:$A$36=A4,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A3<>A4,_xlfn.STDEV.S(B4:INDEX($B$2:$B$36,MATCH(A4,$A$2:$A$36))),\"\")","v":""}]
["2009-08-19",0.26569999999999999,{"$f":"IF(A4<>A5,_xlfn.STDEV.S(IF($A$2:$A$36=A5,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A4<>A5,_xlfn.STDEV.S(B5:INDEX($B$2:$B$36,MATCH(A5,$A$2:$A$36))),\"\")","v":""}]
["2009-08-19",0.26400000000000001,{"$f":"IF(A5<>A6,_xlfn.STDEV.S(IF($A$2:$A$36=A6,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A5<>A6,_xlfn.STDEV.S(B6:INDEX($B$2:$B$36,MATCH(A6,$A$2:$A$36))),\"\")","v":""}]
["2009-08-19",0.25540000000000002,{"$f":"IF(A6<>A7,_xlfn.STDEV.S(IF($A$2:$A$36=A7,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A6<>A7,_xlfn.STDEV.S(B7:INDEX($B$2:$B$36,MATCH(A7,$A$2:$A$36))),\"\")","v":""}]
["2009-08-19",0.2661,{"$f":"IF(A7<>A8,_xlfn.STDEV.S(IF($A$2:$A$36=A8,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A7<>A8,_xlfn.STDEV.S(B8:INDEX($B$2:$B$36,MATCH(A8,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.3654,{"$f":"IF(A8<>A9,_xlfn.STDEV.S(IF($A$2:$A$36=A9,$B$2:$B$36)),\"\")","v":3.0440663378581357E-2},{"$f":"IF(A8<>A9,_xlfn.STDEV.S(B9:INDEX($B$2:$B$36,MATCH(A9,$A$2:$A$36))),\"\")","v":3.0440663378581357E-2}]
["2009-09-16",0.37269999999999998,{"$f":"IF(A9<>A10,_xlfn.STDEV.S(IF($A$2:$A$36=A10,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A9<>A10,_xlfn.STDEV.S(B10:INDEX($B$2:$B$36,MATCH(A10,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.37919999999999998,{"$f":"IF(A10<>A11,_xlfn.STDEV.S(IF($A$2:$A$36=A11,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A10<>A11,_xlfn.STDEV.S(B11:INDEX($B$2:$B$36,MATCH(A11,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.37840000000000001,{"$f":"IF(A11<>A12,_xlfn.STDEV.S(IF($A$2:$A$36=A12,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A11<>A12,_xlfn.STDEV.S(B12:INDEX($B$2:$B$36,MATCH(A12,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.371,{"$f":"IF(A12<>A13,_xlfn.STDEV.S(IF($A$2:$A$36=A13,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A12<>A13,_xlfn.STDEV.S(B13:INDEX($B$2:$B$36,MATCH(A13,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.32329999999999998,{"$f":"IF(A13<>A14,_xlfn.STDEV.S(IF($A$2:$A$36=A14,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A13<>A14,_xlfn.STDEV.S(B14:INDEX($B$2:$B$36,MATCH(A14,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.31640000000000001,{"$f":"IF(A14<>A15,_xlfn.STDEV.S(IF($A$2:$A$36=A15,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A14<>A15,_xlfn.STDEV.S(B15:INDEX($B$2:$B$36,MATCH(A15,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.32819999999999999,{"$f":"IF(A15<>A16,_xlfn.STDEV.S(IF($A$2:$A$36=A16,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A15<>A16,_xlfn.STDEV.S(B16:INDEX($B$2:$B$36,MATCH(A16,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.315,{"$f":"IF(A16<>A17,_xlfn.STDEV.S(IF($A$2:$A$36=A17,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A16<>A17,_xlfn.STDEV.S(B17:INDEX($B$2:$B$36,MATCH(A17,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.32800000000000001,{"$f":"IF(A17<>A18,_xlfn.STDEV.S(IF($A$2:$A$36=A18,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A17<>A18,_xlfn.STDEV.S(B18:INDEX($B$2:$B$36,MATCH(A18,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.33689999999999998,{"$f":"IF(A18<>A19,_xlfn.STDEV.S(IF($A$2:$A$36=A19,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A18<>A19,_xlfn.STDEV.S(B19:INDEX($B$2:$B$36,MATCH(A19,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.32990000000000003,{"$f":"IF(A19<>A20,_xlfn.STDEV.S(IF($A$2:$A$36=A20,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A19<>A20,_xlfn.STDEV.S(B20:INDEX($B$2:$B$36,MATCH(A20,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.32990000000000003,{"$f":"IF(A20<>A21,_xlfn.STDEV.S(IF($A$2:$A$36=A21,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A20<>A21,_xlfn.STDEV.S(B21:INDEX($B$2:$B$36,MATCH(A21,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.31619999999999998,{"$f":"IF(A21<>A22,_xlfn.STDEV.S(IF($A$2:$A$36=A22,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A21<>A22,_xlfn.STDEV.S(B22:INDEX($B$2:$B$36,MATCH(A22,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.29520000000000002,{"$f":"IF(A22<>A23,_xlfn.STDEV.S(IF($A$2:$A$36=A23,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A22<>A23,_xlfn.STDEV.S(B23:INDEX($B$2:$B$36,MATCH(A23,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.2903,{"$f":"IF(A23<>A24,_xlfn.STDEV.S(IF($A$2:$A$36=A24,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A23<>A24,_xlfn.STDEV.S(B24:INDEX($B$2:$B$36,MATCH(A24,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.28570000000000001,{"$f":"IF(A24<>A25,_xlfn.STDEV.S(IF($A$2:$A$36=A25,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A24<>A25,_xlfn.STDEV.S(B25:INDEX($B$2:$B$36,MATCH(A25,$A$2:$A$36))),\"\")","v":""}]
["2009-09-16",0.30149999999999999,{"$f":"IF(A25<>A26,_xlfn.STDEV.S(IF($A$2:$A$36=A26,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A25<>A26,_xlfn.STDEV.S(B26:INDEX($B$2:$B$36,MATCH(A26,$A$2:$A$36))),\"\")","v":""}]
["2009-10-14",0.20200000000000001,{"$f":"IF(A26<>A27,_xlfn.STDEV.S(IF($A$2:$A$36=A27,$B$2:$B$36)),\"\")","v":5.4989578810696667E-2},{"$f":"IF(A26<>A27,_xlfn.STDEV.S(B27:INDEX($B$2:$B$36,MATCH(A27,$A$2:$A$36))),\"\")","v":5.4989578810696667E-2}]
["2009-10-14",0.1953,{"$f":"IF(A27<>A28,_xlfn.STDEV.S(IF($A$2:$A$36=A28,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A27<>A28,_xlfn.STDEV.S(B28:INDEX($B$2:$B$36,MATCH(A28,$A$2:$A$36))),\"\")","v":""}]
["2009-10-14",0.33360000000000001,{"$f":"IF(A28<>A29,_xlfn.STDEV.S(IF($A$2:$A$36=A29,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A28<>A29,_xlfn.STDEV.S(B29:INDEX($B$2:$B$36,MATCH(A29,$A$2:$A$36))),\"\")","v":""}]
["2009-10-14",0.32990000000000003,{"$f":"IF(A29<>A30,_xlfn.STDEV.S(IF($A$2:$A$36=A30,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A29<>A30,_xlfn.STDEV.S(B30:INDEX($B$2:$B$36,MATCH(A30,$A$2:$A$36))),\"\")","v":""}]
["2009-10-14",0.31369999999999998,{"$f":"IF(A30<>A31,_xlfn.STDEV.S(IF($A$2:$A$36=A31,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A30<>A31,_xlfn.STDEV.S(B31:INDEX($B$2:$B$36,MATCH(A31,$A$2:$A$36))),\"\")","v":""}]
["2009-10-14",0.32229999999999998,{"$f":"IF(A31<>A32,_xlfn.STDEV.S(IF($A$2:$A$36=A32,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A31<>A32,_xlfn.STDEV.S(B32:INDEX($B$2:$B$36,MATCH(A32,$A$2:$A$36))),\"\")","v":""}]
["2009-10-14",0.32029999999999997,{"$f":"IF(A32<>A33,_xlfn.STDEV.S(IF($A$2:$A$36=A33,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A32<>A33,_xlfn.STDEV.S(B33:INDEX($B$2:$B$36,MATCH(A33,$A$2:$A$36))),\"\")","v":""}]
["2009-10-14",0.33479999999999999,{"$f":"IF(A33<>A34,_xlfn.STDEV.S(IF($A$2:$A$36=A34,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A33<>A34,_xlfn.STDEV.S(B34:INDEX($B$2:$B$36,MATCH(A34,$A$2:$A$36))),\"\")","v":""}]
["2009-10-14",0.33169999999999999,{"$f":"IF(A34<>A35,_xlfn.STDEV.S(IF($A$2:$A$36=A35,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A34<>A35,_xlfn.STDEV.S(B35:INDEX($B$2:$B$36,MATCH(A35,$A$2:$A$36))),\"\")","v":""}]
["2009-10-14",0.33679999999999999,{"$f":"IF(A35<>A36,_xlfn.STDEV.S(IF($A$2:$A$36=A36,$B$2:$B$36)),\"\")","v":""},{"$f":"IF(A35<>A36,_xlfn.STDEV.S(B36:INDEX($B$2:$B$36,MATCH(A36,$A$2:$A$36))),\"\")","v":""}]

{"sheet":"840","index":8,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Sales",null,"Lower Limit To Class","Upper Limit To Class","Frequency","Total"]
[71.05,null,0,25,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--($A$2:$A$17>=C2),--($A$2:$A$17<D2),$A$2:$A$17)","v":96.54}]
[90.14,null,{"$f":"D2","v":25},50,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--($A$2:$A$17>=C3),--($A$2:$A$17<D3),$A$2:$A$17)","v":83.330000000000013}]
[13.74,null,{"$f":"D3","v":50},75,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--($A$2:$A$17>=C4),--($A$2:$A$17<D4),$A$2:$A$17)","v":127.58}]
[56.53,null,75,100,null,null,null,null,null,null,{"$f":"SUMPRODUCT(--($A$2:$A$17>=C5),--($A$2:$A$17<D5),$A$2:$A$17)","v":466.4}]
[20.59]
[98.33]
[7.57]
[20.5]
[22.55]
[98.73]
[80.45]
[39.590000000000003]
[98.75]
[0.48]
[43.74]
[11.11]

{"sheet":"840 (an)","index":9,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Sales",null,"Lower Limit To Class","Upper Limit To Class","Frequency","Total"]
[71.05,null,0,25,{"$f":"COUNTIFS($A$2:$A$17,\">=\"&C2,$A$2:$A$17,\"<\"&D2)","v":7},{"$f":"SUMIFS($A$2:$A$17,$A$2:$A$17,\">=\"&C2,$A$2:$A$17,\"<\"&D2)","v":96.54},null,null,null,null,{"$f":"SUMPRODUCT(--($A$2:$A$17>=C2),--($A$2:$A$17<D2),$A$2:$A$17)","v":96.54}]
[90.14,null,{"$f":"D2","v":25},50,{"$f":"COUNTIFS($A$2:$A$17,\">=\"&C3,$A$2:$A$17,\"<\"&D3)","v":2},{"$f":"SUMIFS($A$2:$A$17,$A$2:$A$17,\">=\"&C3,$A$2:$A$17,\"<\"&D3)","v":83.330000000000013},null,null,null,null,{"$f":"SUMPRODUCT(--($A$2:$A$17>=C3),--($A$2:$A$17<D3),$A$2:$A$17)","v":83.330000000000013}]
[13.74,null,{"$f":"D3","v":50},75,2,127.58,null,null,null,null,{"$f":"SUMPRODUCT(--($A$2:$A$17>=C4),--($A$2:$A$17<D4),$A$2:$A$17)","v":127.58}]
[56.53,null,75,100,5,466.4,null,null,null,null,{"$f":"SUMPRODUCT(--($A$2:$A$17>=C5),--($A$2:$A$17<D5),$A$2:$A$17)","v":466.4}]
[20.59]
[98.33,null,"Sales","Frequency","Sum of Sales"]
[7.57,null,"0-25",7,96.54]
[20.5,null,"25-50",2,83.330000000000013]
[22.55,null,"50-75",2,127.58]
[98.73,null,"75-100",5,466.4]
[80.45,null,"Grand Total",16,773.85]
[39.590000000000003]
[98.75]
[0.48]
[43.74]
[11.11]

{"sheet":"841","index":10,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Vaules",null,"Mean","STDEV","Value 1 STDEV","Number > 1 STDEV"]
[{"$f":"RANDBETWEEN(0,120)","v":44}]
[39]
[93,null,"Mean = 1 Typical Value"]
[78,null,"Standard Deviation = Variation = How Fairly Your Mean Represents Its Data Points"]
[63]
[111,null,"Video on What Standard Deviation means:"]
[80,null,"Excel 2010 Statistics #30: Standard Deviation: How fairly does the mean represent its data points?"]
[0,null,"http://www.youtube.com/watch?v=Ur_C64ifCoU"]
[10]
[42,null,"Playlist of many Stats Videos:"]
[111,null,"http://www.youtube.com/watch?v=4AZ8G_MqyiM&feature=results_main&playnext=1&list=PLFAD0C5745D4A1F60"]
[60]
[90]
[64]
[106]
[118]
[16]
[55]

{"sheet":"841 (an)","index":11,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Vaules",null,"Mean","STDEV","Value 1 STDEV","Number > 1 STDEV"]
[{"$f":"RANDBETWEEN(0,120)","v":57},null,{"$f":"AVERAGE(A2:A19)","v":82.944444444444443},{"$f":"_xlfn.STDEV.S(A2:A19)","v":31.470756214810375},{"$f":"SUM(C2:D2)","v":114.41520065925482},{"$f":"COUNTIF(A2:A19,\">\"&E2)","v":3}]
[96]
[91,null,"Mean = 1 Typical Value"]
[56,null,"Standard Deviation = Variation = How Fairly Your Mean Represents Its Data Points"]
[94]
[66,null,"Video on What Standard Deviation means:"]
[103,null,"Excel 2010 Statistics #30: Standard Deviation: How fairly does the mean represent its data points?"]
[119,null,"http://www.youtube.com/watch?v=Ur_C64ifCoU"]
[102]
[32,null,"Playlist of many Stats Videos:"]
[103,null,"http://www.youtube.com/watch?v=4AZ8G_MqyiM&feature=results_main&playnext=1&list=PLFAD0C5745D4A1F60"]
[105]
[104]
[52]
[10]
[69]
[115]
[119]

{"sheet":"842","index":12,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Names","Duplicate?"]
["Joe"]
["Jo"]
["Joe"]
["Jo"]
["Phil"]
["Phil "]

{"sheet":"842 (an)","index":13,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Names","Duplicate?"]
["Joe",{"$f":"IF(COUNTIF(A$2:A2,A2)>1,\"Dup\",\"\")","v":""}]
["Jo",{"$f":"IF(COUNTIF(A$2:A3,A3)>1,\"Dup\",\"\")","v":""}]
["Joe",{"$f":"IF(COUNTIF(A$2:A4,A4)>1,\"Dup\",\"\")","v":"Dup"}]
["Jo",{"$f":"IF(COUNTIF(A$2:A5,A5)>1,\"Dup\",\"\")","v":"Dup"}]
["Phil",{"$f":"IF(COUNTIF(A$2:A6,A6)>1,\"Dup\",\"\")","v":""}]
["Phil ",{"$f":"IF(COUNTIF(A$2:A7,A7)>1,\"Dup\",\"\")","v":""}]

{"sheet":"843","index":14,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Date","Product","Customer","Sales","Dup?"]
["2011-12-14","Carlota","GIFT",186]
["2011-12-15","Bellen","PCC",144]
["2011-12-15","Bellen","PCC",202]
["2011-12-15","Bellen","WFM",150]
["2011-12-15","Bellen","PCC",202]
["2011-12-15","Bellen","WFM",271]
["2011-12-15","Bellen","WFM",271]
["2011-12-15","Carlota","WFM",271]

{"sheet":"843 (an)","index":15,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Date","Product","Customer","Sales","Dup?"]
["2011-12-14","Carlota","GIFT",186,{"$f":"IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2,C$2:C2,C2,D$2:D2,D2)>1,\"Dup\",\"\")","v":""}]
["2011-12-15","Bellen","PCC",144,{"$f":"IF(COUNTIFS(A$2:A3,A3,B$2:B3,B3,C$2:C3,C3,D$2:D3,D3)>1,\"Dup\",\"\")","v":""}]
["2011-12-15","Bellen","PCC",202,{"$f":"IF(COUNTIFS(A$2:A4,A4,B$2:B4,B4,C$2:C4,C4,D$2:D4,D4)>1,\"Dup\",\"\")","v":""}]
["2011-12-15","Bellen","WFM",150,{"$f":"IF(COUNTIFS(A$2:A5,A5,B$2:B5,B5,C$2:C5,C5,D$2:D5,D5)>1,\"Dup\",\"\")","v":""}]
["2011-12-15","Bellen","PCC",202,{"$f":"IF(COUNTIFS(A$2:A6,A6,B$2:B6,B6,C$2:C6,C6,D$2:D6,D6)>1,\"Dup\",\"\")","v":"Dup"}]
["2011-12-15","Bellen","WFM",271,{"$f":"IF(COUNTIFS(A$2:A7,A7,B$2:B7,B7,C$2:C7,C7,D$2:D7,D7)>1,\"Dup\",\"\")","v":""}]
["2011-12-15","Bellen","WFM",271,{"$f":"IF(COUNTIFS(A$2:A8,A8,B$2:B8,B8,C$2:C8,C8,D$2:D8,D8)>1,\"Dup\",\"\")","v":"Dup"}]
["2011-12-15","Carlota","WFM",271,{"$f":"IF(COUNTIFS(A$2:A9,A9,B$2:B9,B9,C$2:C9,C9,D$2:D9,D9)>1,\"Dup\",\"\")","v":""}]

{"sheet":"844","index":16,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Date","Y/N",null,"Criteria"]
["2011-10-27","Y",null,"N",null,"Y"]
["2011-10-28",null,null,{"$f":"\"Lookup Last Date for \"&D2","v":"Lookup Last Date for N"}]
["2011-10-29","N",null,null,null,"N"]
["2011-10-30",null,null,"2007 or 2010"]
["2011-10-31","N",null,{"$f":"IF(ISERROR(LOOKUP(9.99999999999999E+307,A2:A9/(B2:B9=D2))),\"\",LOOKUP(9.99999999999999E+307,A2:A9/(B2:B9=D2)))","v":"2011-11-02"},null,"N"]
["2011-11-01","Y",null,"2003 or earlier",null,"Y"]
["2011-11-02","N",null,null,null,"N"]
["2011-11-03"]

{"sheet":"844 (an)","index":17,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Date","Y/N",null,"Criteria"]
["2011-10-27",null,null,"N"]
["2011-10-28","N",null,{"$f":"\"Lookup Last Date for \"&D2","v":"Lookup Last Date for N"}]
["2011-10-29","n",null,{"$f":"IFERROR(LOOKUP(9.99999999999999E+307,A2:A9/(B2:B9=D2),A2:A9),\"\")","v":"2011-10-31"}]
["2011-10-30",null,null,"2007 or 2010"]
["2011-10-31","n",null,{"$f":"IF(ISERROR(LOOKUP(9.99999999999999E+307,A2:A9/(B2:B9=D2))),\"\",LOOKUP(9.99999999999999E+307,A2:A9/(B2:B9=D2)))","v":"2011-10-31"}]
["2011-11-01","y",null,"2003 or earlier"]
["2011-11-02","Y"]
["2011-11-03"]

{"sheet":"845","index":18,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["End Of Month (EOM) Method for Cash Discounts"]
[]
["Rule:"]
[{"$f":"\"Situation 1 for \"&$B$14&\":\"","v":"Situation 1 for 3/15 EOM:"}]
["If Invoice Date is before the 26th of the month (25, 24, 23…),"]
["Final Date To Take Discount =",{"$f":"\"the \"&MID(B14,SEARCH(\"/\",B14)+1,2)&\"th of next month.\"","v":"the 15th of next month."}]
["Invoice Due Date = Final Date To Take Discount + 20 (20 because net day is not given)"]
[{"$f":"\"Situation 2 for \"&$B$14&\":\"","v":"Situation 2 for 3/15 EOM:"}]
["If Invoice Date is after the 25th of the month (26, 27, 28…),"]
["Final Date To Take Discount =",{"$f":"\"the \"&MID(B14,SEARCH(\"/\",B14)+1,2)&\"th of two months ahead.\"","v":"the 15th of two months ahead."}]
["Invoice Due Date = Final Date To Take Discount + 20 (20 because net day is not given)"]
[]
["Invoice Date","2011-10-26"]
["Terms","3/15 EOM"]
["Days Past End Of Month",null,null," =MID(Terms,SEARCH(\"/\",Terms)+1,2)"]
["Day Of The Month",null,null," =DAY(Invoice Date)"]
["Past 25th of month?",null,null," =(Day Of The Month>25)+0"]
["End Of Month",null,null," =EOMONTH(Invoice Date,Past 25th of month?)"]
["Final Date To Take Discount",null,null," End Of Month + Days Past End Of Month"]
["Invoice Due Date",null,null," Final Date To Take Discount + 20"]
[]
["Final Date To Take Discount",null,null," =EOMONTH(InvoiceDate,(DAY(InvoiceDate)>25)+0)+Days Past End Of Month"]
["Invoice Due Date",null,null," =Final Date To Take Discount + 20"]

{"sheet":"845 (an)","index":19,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["End Of Month (EOM) Method for Cash Discounts"]
[]
["Rule:"]
[{"$f":"\"Situation 1 for \"&$B$14&\":\"","v":"Situation 1 for 3/15 EOM:"}]
["If Invoice Date is before the 26th of the month (25, 24, 23…),"]
["Final Date To Take Discount =",{"$f":"\"the \"&MID(B14,SEARCH(\"/\",B14)+1,2)&\"th of next month.\"","v":"the 15th of next month."}]
["Invoice Due Date = Final Date To Take Discount + 20 (20 because net day is not given)"]
[{"$f":"\"Situation 2 for \"&$B$14&\":\"","v":"Situation 2 for 3/15 EOM:"}]
["If Invoice Date is after the 25th of the month (26, 27, 28…),"]
["Final Date To Take Discount =",{"$f":"\"the \"&MID(B14,SEARCH(\"/\",B14)+1,2)&\"th of two months ahead.\"","v":"the 15th of two months ahead."}]
["Invoice Due Date = Final Date To Take Discount + 20 (20 because net day is not given)"]
[]
["Invoice Date","2011-10-26"]
["Terms","3/15 EOM"]
["Days Past End Of Month",{"$f":"MID(B14,3,2)+0","v":15},{"$f":"LEN(B15)","v":2}," =MID(Terms,SEARCH(\"/\",Terms)+1,2)"]
["Day Of The Month",{"$f":"DAY(B13)","v":26},null," =DAY(Invoice Date)"]
["Past 25th of month?",{"$f":"(B16>25)+0","v":1},null," =(Day Of The Month>25)+0"]
["End Of Month",{"$f":"EOMONTH(B13,B17)","v":"2011-11-30"},null," =EOMONTH(Invoice Date,Past 25th of month?)"]
["Final Date To Take Discount",{"$f":"B18+B15","v":"2011-12-15"},null," End Of Month + Days Past End Of Month"]
["Invoice Due Date",{"$f":"B19+20","v":"2012-01-04"},null," Final Date To Take Discount + 20"]
[]
["Final Date To Take Discount",{"$f":"EOMONTH(B13,(DAY(B13)>25)+0)+MID(B14,3,2)","v":"2011-12-15"},null," =EOMONTH(InvoiceDate,(DAY(InvoiceDate)>25)+0)+Days Past End Of Month"]
["Invoice Due Date",{"$f":"B22+20","v":"2012-01-04"},null," =Final Date To Take Discount + 20"]

{"sheet":"846","index":20,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Fill Tom"]
["Dill Pat"]
[]
["Fill Tom",{"$f":"REPLACE(A4,1,SEARCH(\" \",A4),\"\")&\" \"&LEFT(A4,SEARCH(\" \",A4)-1)","v":"Tom Fill"}]
["Dill Pat",{"$f":"REPLACE(A5,1,SEARCH(\" \",A5),\"\")&\" \"&LEFT(A5,SEARCH(\" \",A5)-1)","v":"Pat Dill"}]
[]
["Fill Tom",{"$f":"RIGHT(A7,LEN(A7)-FIND(\" \",A7,1))&\" \"&LEFT(A7,FIND(\" \",A7,1))","v":"Tom Fill "}]
["Dill Pat",{"$f":"RIGHT(A8,LEN(A8)-FIND(\" \",A8,1))&\" \"&LEFT(A8,FIND(\" \",A8,1))","v":"Pat Dill "}]

{"sheet":"846 (an)","index":21,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Fill Tom",{"$f":"MID(A1&\" \"&A1,SEARCH(\" \",A1)+1,LEN(A1))","v":"Tom Fill"}]
["Dill Pat",{"$f":"MID(A2&\" \"&A2,SEARCH(\" \",A2)+1,LEN(A2))","v":"Pat Dill"}]
[]
["Fill Tom",{"$f":"REPLACE(A4,1,SEARCH(\" \",A4),\"\")&\" \"&LEFT(A4,SEARCH(\" \",A4)-1)","v":"Tom Fill"}]
["Dill Pat",{"$f":"REPLACE(A5,1,SEARCH(\" \",A5),\"\")&\" \"&LEFT(A5,SEARCH(\" \",A5)-1)","v":"Pat Dill"}]
[]
["Fill Tom",{"$f":"RIGHT(A7,LEN(A7)-FIND(\" \",A7,1))&\" \"&LEFT(A7,FIND(\" \",A7,1))","v":"Tom Fill "}]
["Dill Pat",{"$f":"RIGHT(A8,LEN(A8)-FIND(\" \",A8,1))&\" \"&LEFT(A8,FIND(\" \",A8,1))","v":"Pat Dill "}]

{"sheet":"847","index":22,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"\"Find Second To Last '\"&B2&\"'\"","v":"Find Second To Last 'Y'"}]
[null,"Y"]
[]
["Text","SUBSTITUTE"]
["OYYEQXHRYEWKSRVRSK"]
["TNUGJCYGVOFYKDMQYJM"]
["POEYKJRILXCPHMTYYSY"]
["TYWDMKLIPYYCGVCEYHJO"]
["EHQKWWXGLLIITOTSRYDQ"]

{"sheet":"848","index":23,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[[0,2,0,3],[1,2,1,3]]}
[null,null,"Starting Balance",null,30000]
[null,null,"Account Balance",null,{"$f":"SUM(H:H)+E1","v":29575}]
[]
[]
[]
[]
["Date","Stock","Shares","Price","Risk %","Risk Amount","Close Price","Profit/Loss","Risk Amount?"]
["2011-11-01","A",100,25,0.01,"ACCTBAL on 11/1 * .01 = 300",32,{"$f":"IF(G8=\"\",\"\",(G8-D8)*C8)","v":700},{"$f":"IF(G8=\"\",\"\",SUM(H7:H$7,E$1)*E8)","v":300}]
["2011-11-18","ABC",75,45,0.01,"ACCTBAL on 11/18 * .01 = 307",32,{"$f":"IF(G9=\"\",\"\",(G9-D9)*C9)","v":-975},{"$f":"IF(G9=\"\",\"\",SUM(H$7:H8,E$1)*E9)","v":307}]
["2011-12-01","DEF",200,20,0.01,"ACCTBAL on 12/1 * .01 = 297",26,1200,{"$f":"IF(G10=\"\",\"\",SUM(H$7:H9,E$1)*E10)","v":297.25}]
["2011-12-05","Z",90,47,0.01,"ACCTBAL on 12/5 * .01 = 309",32,-1350,{"$f":"IF(G11=\"\",\"\",SUM(H$7:H10,E$1)*E11)","v":309.25}]
["2011-12-12","Z",100,35,0.01," = ACCTBAL on 12/12 * .01",null,"",{"$f":"IF(G12=\"\",\"\",SUM(H$7:H11,E$1)*E12)","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(G13=\"\",\"\",SUM(H$7:H12,E$1)*E13)","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(G14=\"\",\"\",SUM(H$7:H13,E$1)*E14)","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(G15=\"\",\"\",SUM(H$7:H14,E$1)*E15)","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(G16=\"\",\"\",SUM(H$7:H15,E$1)*E16)","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(G17=\"\",\"\",SUM(H$7:H16,E$1)*E17)","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(G18=\"\",\"\",SUM(H$7:H17,E$1)*E18)","v":""}]

{"sheet":"847 (an)","index":24,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"\"Find Second To Last '\"&B2&\"'\"","v":"Find Second To Last 'Y'"}]
[null,"Y"]
[]
["Text","SUBSTITUTE"]
["OYYEQXHRYEWKSRVRSK",{"$f":"IFERROR(SEARCH(\"#\",SUBSTITUTE(A5,$B$2,\"#\",LEN(A5)-LEN(SUBSTITUTE(A5,$B$2,\"\"))-1)),\"No \"&$B$2)","v":3},{"$f":"LEN(A5)-LEN(SUBSTITUTE(A5,$B$2,\"\"))-1","v":2}]
["TNUGJCYGVOFYKDMQYJM",{"$f":"IFERROR(SEARCH(\"#\",SUBSTITUTE(A6,$B$2,\"#\",LEN(A6)-LEN(SUBSTITUTE(A6,$B$2,\"\"))-1)),\"No \"&$B$2)","v":12},{"$f":"LEN(A6)-LEN(SUBSTITUTE(A6,$B$2,\"\"))-1","v":2}]
["POEYKJRILXCPHMTYYSY",17,3]
["TYWDMKLIPYYCGVCEYHJO",11,3]
["EHQKWWXGLLIITOTSRYDQ","No Y",0]

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