{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Welcome","Calculations","Output","Licence","Globals","Ticks"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":1,"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":"Welcome","index":0,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[13,1,13,9],[14,1,14,9],[16,1,16,9],[17,1,17,9]]}
[null,"Inform Racing - In Running Trading Tool"]
[null,"http://www.informracing.com"]
[]
[]
[]
[]
[]
[null,"1. Click the Run Application button above"]
[null,"2. Select which of today's races you would like to see"]
[null,"3. The application will import results and perform analysis within 'Output' sheets"]
[null,"4. Running application again will automatically clear previous data from 'Output' sheet"]
[]
[]
[null,"The information presented herein represents the view of the author as of the date of \nrelease/publication. Because of the rate with which conditions change, the author reserves the right to alter and update his opinions based on the new conditions. The report is for informational purposes only, no responsibility for any losses incurred using the information herein will be taken and you are advised to only bet with money that you can afford to lose. While every attempt has been made to verify the information provided , neither the author nor his affiliates/partners assume any responsibility for errors, inaccuracies or omissions. You should be aware of any laws which govern sports betting or other business practices in your country and state. You may get better or worse results than advertised on the website or by any promotional information.\n"]
[null,"No part of this publication may be reproduced or transmitted in any form or by any means electronic or mechanical without permission in writing from the publisher and copyright holder. It is not to be shared, given away, copied or re sold at any time. \n"]
[]
[]
[]
[]
[null,"© copyright informracing.com"]

{"sheet":"Calculations","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Back Calculation 1"]
[]
[null,"Price","Stake","Profit Aim",null,"2nd Price","Ticks"]
[null,14,10,3,null,{"$f":"IFERROR(IF(AND(B5<>\"\",C5<>\"\",D5<>\"\"),INDEX(Ticks!A:A,MATCH(B5 * C5 / (C5 + D5),Ticks!A:A,1)+1,1),\"\"),\"Error\")","v":11},{"$f":"IFERROR(IF(AND(B5<>\"\",C5<>\"\",D5<>\"\"),MATCH(B5,Ticks!A:A,0)-MATCH(F5,Ticks!A:A,0),\"\"),\"Error\")","v":6}]
[]
[]
[null,"Back Calculation 2"]
[]
[null,"Price","Percentage",null,null,"2nd Price","Ticks"]
[null,{"$f":"B5","v":14},0.9,null,null,{"$f":"IFERROR(IF(AND(B11<>\"\",C11<>\"\"),INDEX(Ticks!A:A,MATCH(((B11-1)*C11)+1,Ticks!A:A,1)+1,1),\"\"),\"Error\")","v":13},{"$f":"IFERROR(IF(AND(B11<>\"\",C11<>\"\"),MATCH(B11,Ticks!A:A,0)-MATCH(F11,Ticks!A:A,0),\"\"),\"Error\")","v":2}]
[]
[]
[null,"Lay Calculation"]
[]
[null,"Price","Percentage",null,null,"2nd Price","Ticks"]
[null,7.2,0.5,null,null,{"$f":"IFERROR(IF(AND(B17<>\"\",C17<>\"\"),INDEX(Ticks!A:A,MATCH(((B17-1))+((B17-1)*C17)+1,Ticks!A:A,1)+1,1),\"\"),\"Error\")","v":10.5},{"$f":"IFERROR(IF(AND(B17<>\"\",C17<>\"\"),MATCH(F17,Ticks!A:A,0)-MATCH(B17,Ticks!A:A,0),\"\"),\"Error\")","v":15}]

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

{"sheet":"Licence","index":3,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Reference","8F5S-45DT-VJYL-9HME"]
["Length",365]
["Start","2016-05-10"]

{"sheet":"Globals","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Column T Gold",75]
["Column T Green",50]
["Short In Run",0.1]
["Short In Run Low",3.1]
["Short In Run BSP",5]
[]
["Defaults"]
["Column T Gold","75"]
["Column T Green","50"]
["Short In Run","0.1"]
["Short In Run Low","3.1"]
["Short In Run BSP","5"]

{"sheet":"Ticks","index":5,"n_rows":351,"n_cols":8,"rows_kept":351,"cut":false,"hidden":true,"merged":[]}
["Price","Percent","Number"]
[1.01,99.009900990099013,350]
[1.02,98.039215686274503,349]
[1.03,97.087378640776691,348]
[1.04,96.153846153846146,347]
[1.05,95.238095238095241,346]
[1.06,94.339622641509436,345]
[1.07,93.457943925233636,344]
[1.08,92.592592592592581,343]
[1.0900000000000001,91.743119266055032,342]
[1.1000000000000001,90.909090909090907,341]
[1.1100000000000001,90.090090090090087,340]
[1.1200000000000001,89.285714285714278,339]
[1.1299999999999999,88.495575221238951,338]
[1.1399999999999999,87.719298245614041,337]
[1.1499999999999999,86.956521739130437,336]
[1.1599999999999999,86.206896551724142,335]
[1.17,85.470085470085479,334]
[1.18,84.745762711864415,333]
[1.19,84.033613445378151,332]
[1.2,83.333333333333343,331]
[1.21,82.644628099173559,330]
[1.22,81.967213114754102,329]
[1.23,81.300813008130078,328]
[1.24,80.645161290322577,327]
[1.25,80,326]
[1.26,79.365079365079367,325]
[1.27,78.740157480314963,324]
[1.28,78.125,323]
[1.29,77.519379844961236,322]
[1.3,76.92307692307692,321]
[1.31,76.33587786259541,320]
[1.32,75.757575757575751,319]
[1.33,75.187969924812023,318]
[1.34,74.626865671641781,317]
[1.35,74.074074074074076,316]
[1.36,73.529411764705884,315]
[1.37,72.992700729926995,314]
[1.38,72.463768115942031,313]
[1.39,71.942446043165475,312]
[1.4,71.428571428571431,311]
[1.41,70.921985815602838,310]
[1.42,70.422535211267615,309]
[1.43,69.930069930069934,308]
[1.44,69.444444444444443,307]
[1.45,68.965517241379317,306]
[1.46,68.493150684931507,305]
[1.47,68.02721088435375,304]
[1.48,67.567567567567565,303]
[1.49,67.114093959731548,302]
[1.5,66.666666666666671,301]
[1.51,66.225165562913901,300]
[1.52,65.78947368421052,299]
[1.53,65.359477124183002,298]
[1.54,64.935064935064929,297]
[1.55,64.516129032258064,296]
[1.56,64.102564102564102,295]
[1.57,63.694267515923563,294]
[1.58,63.291139240506325,293]
[1.59,62.893081761006286,292]
[1.6,62.5,291]
[1.61,62.11180124223602,290]
[1.62,61.728395061728392,289]
[1.63,61.349693251533743,288]
[1.64,60.975609756097562,287]
[1.65,60.606060606060609,286]
[1.66,60.24096385542169,285]
[1.67,59.880239520958085,284]
[1.68,59.523809523809526,283]
[1.69,59.171597633136095,282]
[1.7,58.82352941176471,281]
[1.71,58.479532163742689,280]
[1.72,58.139534883720934,279]
[1.73,57.80346820809249,278]
[1.74,57.47126436781609,277]
[1.75,57.142857142857146,276]
[1.76,56.81818181818182,275]
[1.77,56.497175141242934,274]
[1.78,56.179775280898873,273]
[1.79,55.865921787709496,272]
[1.8,55.555555555555557,271]
[1.81,55.248618784530386,270]
[1.82,54.945054945054942,269]
[1.83,54.644808743169399,268]
[1.84,54.347826086956516,267]
[1.85,54.054054054054049,266]
[1.86,53.763440860215049,265]
[1.87,53.475935828876999,264]
[1.88,53.191489361702132,263]
[1.89,52.910052910052912,262]
[1.9,52.631578947368425,261]
[1.91,52.356020942408378,260]
[1.92,52.083333333333336,259]
[1.93,51.813471502590673,258]
[1.94,51.546391752577321,257]
[1.95,51.282051282051285,256]
[1.96,51.020408163265309,255]
[1.97,50.761421319796952,254]
[1.98,50.505050505050505,253]
[1.99,50.251256281407038,252]
[2,50,251]
[2.02,49.504950495049506,250]
[2.04,49.019607843137251,249]
[2.06,48.543689320388346,248]
[2.08,48.076923076923073,247]
[2.1,47.61904761904762,246]
[2.12,47.169811320754718,245]
[2.14,46.728971962616818,244]
[2.16,46.296296296296291,243]
[2.1800000000000002,45.871559633027516,242]
[2.2000000000000002,45.454545454545453,241]
[2.2200000000000002,45.045045045045043,240]
[2.2400000000000002,44.642857142857139,239]
[2.2599999999999998,44.247787610619476,238]
[2.2799999999999998,43.859649122807021,237]
[2.2999999999999998,43.478260869565219,236]
[2.3199999999999998,43.103448275862071,235]
[2.34,42.73504273504274,234]
[2.36,42.372881355932208,233]
[2.38,42.016806722689076,232]
[2.4,41.666666666666671,231]
[2.42,41.32231404958678,230]
[2.44,40.983606557377051,229]
[2.46,40.650406504065039,228]
[2.48,40.322580645161288,227]
[2.5,40,226]
[2.52,39.682539682539684,225]
[2.54,39.370078740157481,224]
[2.56,39.0625,223]
[2.58,38.759689922480618,222]
[2.6,38.46153846153846,221]
[2.62,38.167938931297705,220]
[2.64,37.878787878787875,219]
[2.66,37.593984962406012,218]
[2.68,37.31343283582089,217]
[2.7,37.037037037037038,216]
[2.72,36.764705882352942,215]
[2.74,36.496350364963497,214]
[2.76,36.231884057971016,213]
[2.78,35.971223021582738,212]
[2.8,35.714285714285715,211]
[2.82,35.460992907801419,210]
[2.84,35.211267605633807,209]
[2.86,34.965034965034967,208]
[2.88,34.722222222222221,207,null,null,null,null,{"$f":"MATCH(E157,A:A,0)","v":189}]
[2.9,34.482758620689658,206]
[2.92,34.246575342465754,205]
[2.94,34.013605442176875,204]
[2.96,33.783783783783782,203]
[2.98,33.557046979865774,202]
[3,33.333333333333336,201]
[3.05,32.786885245901644,200]
[3.1,32.258064516129032,199]
[3.15,31.746031746031747,198]
[3.2,31.25,197]
[3.25,30.76923076923077,196,null,"1st Price","2nd Price","Ticks"]
[3.3,30.303030303030305,195,null,5.8,5.0999999999999996,{"$f":"MATCH(E157,A:A,0)-MATCH(F157,A:A,0)","v":7}]
[3.35,29.850746268656717,194]
[3.4,29.411764705882355,193,null,null,null,{"$f":"VLOOKUP(E157,A:C,3,0)-VLOOKUP(F157,A:C,3,0)","v":-7}]
[3.45,28.985507246376809,192]
[3.5,28.571428571428573,191]
[3.55,28.169014084507044,190]
[3.6,27.777777777777779,189]
[3.65,27.397260273972602,188]
[3.7,27.027027027027025,187]
[3.75,26.666666666666668,186]
[3.8,26.315789473684212,185]
[3.85,25.974025974025974,184]
[3.9,25.641025641025642,183]
[3.95,25.316455696202532,182]
[4,25,181]
[4.0999999999999996,24.390243902439025,180]
[4.2,23.80952380952381,179]
[4.3,23.255813953488374,178]
[4.4000000000000004,22.727272727272727,177]
[4.5,22.222222222222221,176]
[4.5999999999999996,21.739130434782609,175]
[4.7,21.276595744680851,174]
[4.8,20.833333333333336,173]
[4.9000000000000004,20.408163265306122,172]
[5,20,171]
[5.0999999999999996,19.607843137254903,170]
[5.2,19.23076923076923,169]
[5.3,18.867924528301888,168]
[5.4,18.518518518518519,167]
[5.5,18.181818181818183,166]
[5.6,17.857142857142858,165]
[5.7,17.543859649122805,164]
[5.8,17.241379310344829,163]
[5.9,16.949152542372879,162]
[6,16.666666666666668,161]
[6.2,16.129032258064516,160]
[6.4,15.625,159]
[6.6,15.151515151515152,158]
[6.8,14.705882352941178,157]
[7,14.285714285714286,156]
[7.2,13.888888888888889,155]
[7.4,13.513513513513512,154]
[7.6,13.157894736842106,153]
[7.8,12.820512820512821,152]
[8,12.5,151]
[8.1999999999999993,12.195121951219512,150]
[8.4,11.904761904761905,149]
[8.6,11.627906976744187,148]
[8.8000000000000007,11.363636363636363,147]
[9,11.111111111111111,146]
[9.1999999999999993,10.869565217391305,145]
[9.4,10.638297872340425,144]
[9.6,10.416666666666668,143]
[9.8000000000000007,10.204081632653061,142]
[10,10,141]
[10.5,9.5238095238095237,140]
[11,9.0909090909090917,139]
[11.5,8.695652173913043,138]
[12,8.3333333333333339,137]
[12.5,8,136]
[13,7.6923076923076925,135]
[13.5,7.4074074074074074,134]
[14,7.1428571428571432,133]
[14.5,6.8965517241379306,132]
[15,6.666666666666667,131]
[15.5,6.4516129032258061,130]
[16,6.25,129]
[16.5,6.0606060606060606,128]
[17,5.882352941176471,127]
[17.5,5.7142857142857144,126]
[18,5.5555555555555554,125]
[18.5,5.4054054054054053,124]
[19,5.2631578947368425,123]
[19.5,5.1282051282051286,122]
[20,5,121]
[21,4.7619047619047619,120]
[22,4.5454545454545459,119]
[23,4.3478260869565215,118]
[24,4.166666666666667,117]
[25,4,116]
[26,3.8461538461538463,115]
[27,3.7037037037037037,114]
[28,3.5714285714285716,113]
[29,3.4482758620689653,112]
[30,3.3333333333333335,111]
[32,3.125,110]
[34,2.9411764705882355,109]
[36,2.7777777777777777,108]
[38,2.6315789473684212,107]
[40,2.5,106]
[42,2.3809523809523809,105]
[44,2.2727272727272729,104]
[46,2.1739130434782608,103]
[48,2.0833333333333335,102]
[50,2,101]
[55,1.8181818181818181,100]
[60,1.6666666666666667,99]
[65,1.5384615384615385,98]
[70,1.4285714285714286,97]
[75,1.3333333333333333,96]
[80,1.25,95]
[85,1.1764705882352942,94]
[90,1.1111111111111112,93]
[95,1.0526315789473684,92]
[100,1,91]
[110,0.90909090909090906,90]
[120,0.83333333333333337,89]
[130,0.76923076923076927,88]
[140,0.7142857142857143,87]
[150,0.66666666666666663,86]
[160,0.625,85]
[170,0.58823529411764708,84]
[180,0.55555555555555558,83]
[190,0.52631578947368418,82]
[200,0.5,81]
[210,0.47619047619047616,80]
[220,0.45454545454545453,79]
[230,0.43478260869565216,78]
[240,0.41666666666666669,77]
[250,0.4,76]
[260,0.38461538461538464,75]
[270,0.37037037037037035,74]
[280,0.35714285714285715,73]
[290,0.34482758620689657,72]
[300,0.33333333333333331,71]
[310,0.32258064516129031,70]
[320,0.3125,69]
[330,0.30303030303030304,68]
[340,0.29411764705882354,67]
[350,0.2857142857142857,66]
[360,0.27777777777777779,65]
[370,0.27027027027027029,64]
[380,0.26315789473684209,63]
[390,0.25641025641025639,62]
[400,0.25,61]
[410,0.24390243902439024,60]
[420,0.23809523809523808,59]
[430,0.23255813953488372,58]
[440,0.22727272727272727,57]
[450,0.22222222222222221,56]
[460,0.21739130434782608,55]
[470,0.21276595744680851,54]
[480,0.20833333333333334,53]
[490,0.20408163265306123,52]
[500,0.2,51]
[510,0.19607843137254902,50]
[520,0.19230769230769232,49]
[530,0.18867924528301888,48]
[540,0.18518518518518517,47]
[550,0.18181818181818182,46]
[560,0.17857142857142858,45]
[570,0.17543859649122806,44]
[580,0.17241379310344829,43]
[590,0.16949152542372881,42]
[600,0.16666666666666666,41]
[610,0.16393442622950818,40]
[620,0.16129032258064516,39]
[630,0.15873015873015872,38]
[640,0.15625,37]
[650,0.15384615384615385,36]
[660,0.15151515151515152,35]
[670,0.14925373134328357,34]
[680,0.14705882352941177,33]
[690,0.14492753623188406,32]
[700,0.14285714285714285,31]
[710,0.14084507042253522,30]
[720,0.1388888888888889,29]
[730,0.13698630136986301,28]
[740,0.13513513513513514,27]
[750,0.13333333333333333,26]
[760,0.13157894736842105,25]
[770,0.12987012987012986,24]
[780,0.12820512820512819,23]
[790,0.12658227848101267,22]
[800,0.125,21]
[810,0.12345679012345678,20]
[820,0.12195121951219512,19]
[830,0.12048192771084337,18]
[840,0.11904761904761904,17]
[850,0.11764705882352941,16]
[860,0.11627906976744186,15]
[870,0.11494252873563218,14]
[880,0.11363636363636363,13]
[890,0.11235955056179775,12]
[900,0.1111111111111111,11]
[910,0.10989010989010989,10]
[920,0.10869565217391304,9]
[930,0.10752688172043011,8]
[940,0.10638297872340426,7]
[950,0.10526315789473684,6]
[960,0.10416666666666667,5]
[970,0.10309278350515463,4]
[980,0.10204081632653061,3]
[990,0.10101010101010101,2]
[1000,0.1,1]