{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":35,"n_cols":16,"rows_kept":35,"merged":[[0,3,0,8],[1,3,1,8]],"flags":["formulas_cached_only"]}
["EQUITIES AS OF 05/31/2017",{"$nulls":12},"Ratio","Actual"]
["Jim's Attempt  3/23/17",null,null,"           Current Portfolio",{"$nulls":6},"Total","Total","Johns","Johns","John's Net","Johns"]
[{"$nulls":4},"Proportion","Proposed","Proposed ",null,"Market","Unrealized","Unrealized","Unrealized","Unrealized","Unrealized",null,"Market"]
[null,"Date","Amount*","Shares","Shares","to John","remaining","Market","Value","Gain(Loss)","Loss","Gain","Loss","Gain",null,"Value"]
["Aetna Inc New","2013-05-07",{"v":465.75,"d":"$465.75 "},9,{"v":1.490055122836308,"d":"1.490"},9,0,144.86,{"v":1303.74,"d":"$1,303.74 "},{"v":837.99,"d":"$837.99 "},null,{"v":837.99,"d":"$837.99 "},null,{"v":837.99,"d":"837.99 "},{"v":837.99,"d":"837.99 "},{"v":1303.7400000000002,"d":"1,303.74 "}]
["Apple Inc","2008-02-19",{"v":2439.99,"d":"$2,439.99 "},315,{"v":52.151929299270776,"d":"52.152"},0,315,152.76,{"v":48119.4,"d":"$48,119.40 "},{"v":41644.92,"d":"$41,644.92 "},null,{"v":41644.92,"d":"$41,644.92 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
["Avnet Inc","2011-01-25",{"v":7107.99,"d":"$7,107.99 "},200,{"v":33.11233606302906,"d":"33.112"},50,150,36.68,{"v":7336,"d":"$7,336.00 "},{"v":228.01,"d":"$228.01 "},null,{"v":228.01,"d":"$228.01 "},null,{"v":57.0025,"d":"57.00 "},{"v":57.0025,"d":"57.00 "},{"v":1834,"d":"1,834.00 "}]
["Citigroup Inc Com (Citicorp)    C","2011-05-09",null,12,{"v":1.986740163781744,"d":"1.987"},12,0,60.54,{"v":726.48,"d":"$726.48 "},{"v":-2266.03,"d":"($2,266.03)"},{"v":-2266.03,"d":"($2,266.03)"},null,{"v":-2266.03,"d":"(2,266.03)"},{"v":0,"d":"0.00 "},{"v":-2266.03,"d":"(2,266.03)"},{"v":726.48,"d":"726.48 "}]
["CREE Inc.","2013-11-19",{"v":5504.94,"d":"$5,504.94 "},100,{"v":16.55616803151453,"d":"16.556"},0,100,{"v":23.845,"d":"23.85"},{"v":2384.5,"d":"$2,384.50 "},{"v":-3120.45,"d":"($3,120.45)"},{"v":-3120.45,"d":"($3,120.45)"},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
["Dawson Geophysical Co","2008-10-24",{"v":2493.99,"d":"$2,493.99 "},176,{"v":29.138855735465576,"d":"29.139"},76,100,3.85,{"v":677.6,"d":"$677.60 "},{"v":-1836.39,"d":"($1,836.39)"},{"v":-1836.39,"d":"($1,836.39)"},null,{"v":-792.986590909091,"d":"(792.99)"},{"v":0,"d":"0.00 "},{"v":-792.986590909091,"d":"(792.99)"},{"v":292.6,"d":"292.60 "}]
["Ford Motor Co","2009-05-19",{"v":2734.99,"d":"$2,734.99 "},600,{"v":99.33700818908719,"d":"99.337"},100,500,11.12,{"v":6672,"d":"$6,672.00 "},{"v":2255.02,"d":"$2,255.02 "},null,{"v":2255.02,"d":"$2,255.02 "},null,{"v":375.83666666666664,"d":"375.84 "},{"v":375.83666666666664,"d":"375.84 "},{"v":1112,"d":"1,112.00 "}]
["General Electric Co","2008-10-24",{"v":4015.99,"d":"$4,015.99 "},300,{"v":49.66850409454359,"d":"49.669"},50,250,27.38,{"v":8214,"d":"$8,214.00 "},{"v":1483.37,"d":"$1,483.37 "},null,{"v":1483.37,"d":"$1,483.37 "},null,{"v":247.22833333333332,"d":"247.23 "},{"v":247.22833333333332,"d":"247.23 "},{"v":1369,"d":"1,369.00 "}]
["Kraft Heinz Co   -  KRFT->KHC","2015-07-06",null,33,{"v":5.463535450399795,"d":"5.464"},33,0,{"v":92.2,"d":"92.20"},{"v":3042.6,"d":"$3,042.60 "},{"v":645.48,"d":"$645.48 "},null,{"v":645.48,"d":"$645.48 "},null,{"v":645.48,"d":"645.48 "},{"v":645.48,"d":"645.48 "},{"v":3042.6,"d":"3,042.60 "}]
["Medtronic PLC                MDT","2015-01-27",{"v":30494.49,"d":"$30,494.49 "},400,{"v":66.22467212605812,"d":"66.225"},100,300,84.28,{"v":33712,"d":"$33,712.00 "},{"v":3217.51,"d":"$3,217.51 "},null,{"v":3217.51,"d":"$3,217.51 "},{"v":0,"d":"0.00 "},{"v":532.6963620307832,"d":"532.70 "},{"v":804.3775,"d":"804.38 "},{"v":8428,"d":"8,428.00 "}]
["Merck & Co","1999-02-16",null,50,{"v":8.278084015757265,"d":"8.278"},0,50,65.11,{"v":3255.5,"d":"$3,255.50 "},{"v":2137.45,"d":"$2,137.45 "},null,{"v":2137.45,"d":"$2,137.45 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
["Mondelez Intl Inc Com (KFT)","2012-10-02",{"v":2427.98,"d":"$2,427.98 "},100,{"v":16.55616803151453,"d":"16.556"},100,0,46.59,{"v":4659,"d":"$4,659.00 "},{"v":2231,"d":"$2,231.00 "},null,{"v":2231,"d":"$2,231.00 "},null,{"v":2231,"d":"2,231.00 "},{"v":2231,"d":"2,231.00 "},{"v":4659,"d":"4,659.00 "}]
["Pepsico Inc. (PBG->PEP)","2010-03-04",{"v":2023.74,"d":"$2,023.74 "},57,{"v":9.437015777963284,"d":"9.437"},0,57,116.87,{"v":6661.59,"d":"$6,661.59 "},{"v":3936.11,"d":"$3,936.11 "},null,{"v":3936,"d":"$3,936.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
["RPM Incorporated Ohio","2001-07-17",{"v":1714.95,"d":"$1,714.95 "},200,{"v":33.11233606302906,"d":"33.112"},0,200,54.23,{"v":10846,"d":"$10,846.00 "},{"v":9131.05,"d":"$9,131.05 "},null,{"v":9131.05,"d":"$9,131.05 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
["Staples Inc","2005-04-15",{"v":1308.99,"d":"$1,308.99 "},225,{"v":37.2513780709077,"d":"37.251"},55,170,9.08,{"v":2043,"d":"$2,043.00 "},{"v":-1682.98,"d":"($1,682.98)"},{"v":-1682.98,"d":"($1,682.98)"},null,{"v":-411.3951111111111,"d":"(411.40)"},{"v":0,"d":"0.00 "},{"v":-411.3951111111111,"d":"(411.40)"},{"v":499.4,"d":"499.40 "}]
["Stratasys LTD","2015-02-17",{"v":6709.99,"d":"$6,709.99 "},100,{"v":16.55616803151453,"d":"16.556"},0,100,{"v":26.9,"d":"26.90"},{"v":2690,"d":"$2,690.00 "},{"v":-4019.99,"d":"($4,019.99)"},{"v":-4019.99,"d":"($4,019.99)"},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
["Sysco Corporation","2000-12-18",{"v":2080.58,"d":"$2,080.58 "},100,{"v":16.55616803151453,"d":"16.556"},0,100,54.56,{"v":5456,"d":"$5,456.00 "},{"v":3375.42,"d":"3,375.42 "},null,{"v":3375.42,"d":"3,375.42 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
["Teva Parmaceutical_ADR Shrs","2008-12-23",{"v":635.85,"d":"$635.85 "},15,{"v":2.4834252047271796,"d":"2.483"},15,0,27.86,{"v":417.9,"d":"$417.90 "},{"v":-217.95,"d":"($217.95)"},{"v":-217.95,"d":"($217.95)"},null,{"v":-217.95,"d":"(217.95)"},{"v":0,"d":"0.00 "},{"v":-217.95,"d":"(217.95)"},{"v":417.9,"d":"417.90 "}]
["Thompson Reuters Corp","2009-07-21",{"v":3159.99,"d":"$3,159.99 "},100,{"v":16.55616803151453,"d":"16.556"},0,100,43.66,{"v":4366,"d":"$4,366.00 "},{"v":1206.01,"d":"$1,206.01 "},null,{"v":1206.01,"d":"$1,206.01 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
["Verizon Communications","2012-12-28",{"v":3990.83,"d":"$3,990.83 "},100,{"v":16.55616803151453,"d":"16.556"},0,100,46.64,{"v":4664,"d":"$4,664.00 "},{"v":673.17,"d":"$673.17 "},null,{"v":673.17,"d":"$673.17 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
["Wells Fargo & Co (Norwest)","2006-08-17",{"v":2877.49,"d":"$2,877.49 "},300,{"v":49.66850409454359,"d":"49.669"},0,300,51.14,{"v":15342,"d":"$15,342.00 "},{"v":11152.01,"d":"$11,152.01 "},null,{"v":11152.01,"d":"$11,152.01 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[" Touchstone   OBFVX->TFFYX","2012-04-13",{"v":3019.99,"d":"$3,019.99 "},138.976,{"v":23.009100083477634,"d":"23.009"},138.976,0,42.96,{"v":5970.41,"d":"$5,970.41 "},{"v":2950.42,"d":"2,950.42 "},null,{"v":2950.42,"d":"2,950.42 "},null,{"v":2950.42,"d":"2,950.42 "},{"v":2950.42,"d":"2,950.42 "},{"v":5970.40896,"d":"5,970.41 "}]
["TOTAL LISTED W/E*TRADE"]
[{"$nulls":8},{"v":178559.72,"d":"$178,559.72"},{"v":73961.15,"d":"$73,961.15 "}]
["TOTAL (sum of eq.)",{"$nulls":7},{"v":178559.72,"d":"$178,559.72 "},{"v":73961.15000000001,"d":"$73,961.15 "},{"v":-13143.79,"d":"($13,143.79)"},{"v":87104.82999999999,"d":"$87,104.83 "},{"v":-3688.361702020202,"d":"($3,688.36)"},{"v":7877.653862030784,"d":"$7,877.65 "},{"v":4460.973297979798,"d":"$4,460.97 "},{"v":29655.128960000002,"d":"$29,655.13 "}]
[{"$nulls":12},"losss","Gain","net"]
[null,null,"Johns Shares",239.98,null,null,"Komper","TARGETS",{"v":29562.64727980186,"d":"$29,562.65"},{"v":12245.13227204051,"d":"$12,245.13"},{"v":-2176.107958109404,"d":"-$2,176.11"},{"v":14421.222018365077,"d":"$14,421.22"},{"v":-1512.2537439107978,"d":"(1,512.25)"},{"v":-6543.568156334293,"d":"(6,543.57)"},{"v":-7784.158974060711,"d":"(7,784.16)"},{"v":92.4816801981433,"d":"$92.48"}]
[{"$nulls":4},{"v":0.16556168031514532,"d":"0.16556"},"'=  Jshare",{"$nulls":6},"Excess loss","Short on  “Gain”","net on net","Equity Difference"]
[null,null,"Total Jig",1449.49,{"$nulls":3},"Cash Share",{"v":2542.3818267987936,"d":"$2,542.38 "},"Net","losss","Gain"]
[{"$nulls":7},"difference",{"v":92.4816801981433,"d":"$92.48 "},{"$nulls":6},"Actual"]
[null,null,"June Jig",1439.02,{"v":0.1667662714903198,"d":"16.68%"},{"v":15245.18,"d":"$15,245.18 "},null,"Actual Cash",{"v":2449.9001466006503,"d":"$2,449.90 "}]