{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Wilhelm0904","Mira09","Wilhelm08","J-M","Text modules","Macro modules"],"not_rendered":{"charts":1,"images":28,"macros":1,"external_links":1,"defined_names":162,"comments":4,"pivot_tables":0},"unopened":[{"sheet":"Text modules","index":4,"reason":"part_missing"},{"sheet":"Macro modules","index":5,"reason":"part_missing"}],"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":"Wilhelm0904","index":0,"n_rows":43,"n_cols":34,"rows_kept":43,"cut":false,"hidden":false,"merged":[[35,0,38,0],[0,17,0,18]]}
["Breeding Cycle Analyser Wilhelm: Deterministic simulator for gain prediction for a program with balance among grandparents, but among and within family selection.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meaning of cell font and colour:"]
[null,"TroubleSolver","Get started","Aim ","How to run","Swedish pine plans","Breeding plan","Math explained","Assumptions","Initial settings","Results","Costs and time","Correlation","Literature","About"," 090501, last edit Dag",null,"Input","Results","Not relevant for Wilhelm but working"]
[]
["Genetic parameters",null,null,null,null,"Diversity loss, rotation, BP size "]
[null,"Variance components","Standard deviations","ruCVAm=",11,"Diversity loss per cycle",0.01]
["sA2=",1,{"$f":"SQRT(B6)","v":1}," sP2=sA2+sD2+sE2=",{"$f":"B6+B7+B8","v":8},"Weight for group coancestry=",0]
["sD2=",0.25,{"$f":"SQRT(B7)","v":0.5},"h2=",{"$f":"B6/E6","v":0.125}," Rotation age=",70]
["sE2=",6.75,{"$f":"SQRT(B8)","v":2.598076211353316},"H2=",{"$f":"(B6+B7)/E6","v":0.15625},"BP size",{"$f":"D17*G9","v":300}]
[null,null,null,null,null,"Number of grandparents",50]
[null,null,"Constraint: annual budget per grandparent",50]
[null,null,"ANNUAL budget for the whole population ",{"$f":"G9*D10","v":2500}]
[null,null,"Total budget for a cycle and whole population ",{"$f":"D11*D28","v":50000}]
[null,null,"Total budget per cycle and grandparent",{"$f":"D10*D28","v":1000}]
[null,null,"plants in field trials ",{"$f":"G9*D20*D17/2","v":30000}]
[]
[null,"Optimization box","Parameters","Values","number per fam with SPM"]
[null,null,"Parents selected per grandparent (PGP) =",6,{"$f":"D17*2","v":12}]
[null,null,"Proportion of plants in tests which become parents",{"$f":"G8/D14","v":0.01}]
[null,null,"Selection intensity AMONG =",{"$f":"SelBurr(2,(D17*2))","v":1.3708240510201635}]
[null,null,"Offspring family size (m) =",{"$f":"4*($D$13-D22)/(D17*2)-2*$D$24","v":200}]
[null,null,"Selection intensity WITHIN =",{"$f":"SelBurr((D17*2),D20)","v":1.9657533549936552}]
[null,null,"Fixed cost (Cfixed)=",100]
[null,null,"Cost per test plant (Cm)=",1]
[null,null,"Cost per parent (Cp)=",50]
[null,null,"Total cost per cycle and grandparent =",{"$f":"D22+(D17*2*(2*D24+D20))/4","v":1000}]
[null,null,"Time not used for testing =",5]
[null,null,"Testing time=",15]
[null,null,"Cycle duration=",{"$f":"D26+D27","v":20}]
[null,null,"sf",{"$f":"(0.25*(1+1/$D$20)*SQRT($B$6)*(SQRT(1-1/($D$17*2)*$B$6)))/(SQRT(0.25*$B$6*(1+1/$D$20)+0.25*$B$7+(0.75*$B$7+$B$8)/$D$20))","v":0.40752039207278568}]
[null,null,"sw",{"$f":"(0.5*(1-1/$D$20)*$B$6)/(SQRT((0.5*$B$6+0.75*$B$7)*(1-1/$D$20)+$B$8))","v":0.18246517210318361}]
[null,null," J-M correlation function",6]
[null,null,"function name",{"$f":"rname(D31)","v":"Jansson 2003 south&mid Sw"}]
[null,null,"rjm =",{"$f":"rr(D31,D27/$G$7)","v":0.54556871292059106}]
[null,null,"Genetic gain among (%)=",{"$f":"$D$33*$D$19*$D$29*E5","v":3.3525340904889402}]
[null,null,"Genetic gain within (%)=",{"$f":"$D$33*$D$21*$D$30*E5","v":2.1525395927560949}]
["Result",null,"Total genetic gain per cycle (%)=",{"$f":"D35+D34","v":5.5050736832450351}]
[null,null,"Gain/(cost per grandparent)=",{"$f":"D36/D13","v":5.5050736832450353E-3}]
[null,null,"Gain/time=",{"$f":"D36/D28","v":0.27525368416225177},null,"Facilititate analyses with Macros"]
[null,null,"Annual group merit progress=",{"$f":"(D36-G5*G6)/D28","v":0.27525368416225177}]
[]
[]
["The below area is for copying the results"]
["Constraint: annual budget per grandparent","ANNUAL budget for the whole population ","Total budget for a cycle and whole population ","Total budget per cycle and grandparent","plants in field trials ",null,"Parameters","Candidate parents selected per grandparent (p) =","Selection intensity AMONG =","Offspring family size (m) =","Selection intensity WITHIN =","Initiation cost (CIN)=","Cost per test plant (Cm)=","Cost per parent (Cp)=","Total cost per cycle and grandparent =","Time not used for testing =","Testing time=","Cycle duration=","ramong","rwithin"," J-M correlation function","function name","rjm =","Genetic gain among (%)=","Genetic gain within (%)=","Total genetic gain per cycle (%)=","Gain/(cost per grandparent)=","Gain/time=","Group merit/time=","Diversity loss per cycle","Weight for group coancestry="," Rotation age=","BP size","Number of grandparents"]

{"sheet":"Mira09","index":1,"n_rows":42,"n_cols":34,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,16,0,17],[34,0,36,0]]}
["Breeding Cycle Analyser Mira: Deterministic simulator for gain prediction from a program with balance among grandparents, but parental and within family selection.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meaning of cell font and colour:",null,"A presentation of Mira is on:  http://daglindgren.upsc.se/Foradlrevision07/ToDelp3BreedingPrinc/RetrospectiveBalanceDagAfterPresentationMay08.ppt"]
[null,"TroubleSolver","Specific aim","General aim ","Get started","Specific difficulties","Breeding plan","Assumptions","Initial settings","Results","Costs","Timing","How to run","Correlation","Literature","About","Input","Results","Last edit DL 090408"]
[]
["Genetic parameters in BP",null,null,null,null,"Diversity loss, rotation, BP size "]
[null,"Variance components","Standard deviations","CVAm=",14," Rotation age=",60]
["sA2=",1,{"$f":"SQRT(B6)","v":1}," sP2=sA2+sD2+sE2=",{"$f":"B6+B7+B8","v":10},"BP size",{"$f":"2*D16*12.5","v":100}]
["sD2=",{"$f":"B6*0.25","v":0.25},{"$f":"SQRT(B7)","v":0.5},"h2=",{"$f":"B6/E6","v":0.1},"Number of founders",50]
["sE2=",8.75,{"$f":"SQRT(B8)","v":2.9580398915498081},"H2=",{"$f":"(B6+B7)/E6","v":0.125}]
[]
[null,null,"Constraint: annual budget per founder",20,"Insert annual budget"]
[null,null,"ANNUAL budget for the whole BP ",{"$f":"G7*D10","v":1000}]
[null,null,"Total budget for a cycle and whole BP",{"$f":"D11*D27","v":18000}]
[null,null,"Total budget per cycle and grandparent",{"$f":"D10*D27","v":360}]
[]
[null,"Optimization box","Parameters","Values"]
[null,null,"Candidate parents selected per family (p) =",4,"This is the main cell to change while optimising"]
[null,null,"Selection intensity AMONG =",{"$f":"SelBurr(2,D16)","v":0.67255314614233597}]
[null,null,"Offspring family size (m) =",{"$f":"4*$D$13/$D$16-2*$D$22","v":310}]
[null,null,"Selection intensity WITHIN =",{"$f":"SelBurr(D16,D18)","v":2.5299123160664805}]
[null,null,"Initiation cost (CIN)=",0,"Suggest to keep at 0"]
[null,null,"Cost per test plant (CP)=",1,"Suggest to keep at 1"]
[null,null,"Cost per parent (CG)=",25,"Put a relelvant value for your program"]
[null,null,"Total cost per cycle and founder=",{"$f":"D20+(D16*(2*D22+D18))/4","v":360}]
[null,null,"Time before =",6,"Put a relevant value for your program"]
[null,null,"Testing time=",12,"Put a relevant value for your program"]
[null,null,"Time after=",0,"Put a relevant value for your program"]
[null,null,"Cycle duration=",{"$f":"D24+D25+D26","v":18}]
[null,null,"rAmong",{"$f":"(0.5*(1+1/$D$18)*SQRT($B$6)*(SQRT(1-1/$D$16)))/(SQRT(0.25*$B$6*(1+1/$D$18)+0.25*$B$7+(0.75*$B$7+$B$8)/$D$18))","v":0.74267575826915}]
[null,null,"rWithin",{"$f":"(0.7071*(1-1/$D$18)*SQRT($B$6))/(SQRT((0.5*$B$6+0.75*$B$7)*(1-1/$D$18)+$B$8))","v":0.22945639944270749}]
[null,null," J-M correlation function",1,"Choose a relevant function for your program"]
[null,null,"function name",{"$f":"rname(D30)","v":"Lambeth 2001"}]
[null,null,"rY (or R)=",{"$f":"rr(D30,D25/$G$5)","v":0.76615154138993702}]
[null,null,"Genetic gain among (%)=",{"$f":"$D$32*$D$17*$D$28*E5/2","v":2.6787894298909238}]
[null,null,"Genetic gain within (%)=",{"$f":"$D$32*$D$19*$D$29*0.7071*E5","v":4.4028024183104986}]
["Result",null,"Total genetic gain per cycle (%)=",{"$f":"D34+D33","v":7.0815918482014224},"Can be maximized as a function of budget, parents selected and cost per parent (large fat fonts)"]
[null,null,"Gain/(cost per grandparent)=",{"$f":"D35/D13","v":1.9671088467226174E-2}]
[null,null,"Gain/time=",{"$f":"D35/D27","v":0.39342176934452344}]
[null,null,null,null,"Facilititate analyses with Macros"]
[]
[]
["The area below is for copying results"]
["Constraint: annual budget per founder","ANNUAL budget for the whole BP ","Total budget for a cycle and whole BP","Total budget per cycle and grandparent",null,"Parameters","Candidate parents selected per family (p) =","Selection intensity AMONG =","Offspring family size (m) =","Selection intensity WITHIN =","Initiation cost (CIN)=","Cost per test plant (CP)=","Cost per parent (CG)=","Total cost per cycle and founder=","Time before =","Testing time=","Time after=","Cycle duration=","ramong","rwithin"," J-M correlation function","function name","rY (or R)=","Genetic gain among (%)=","Genetic gain within (%)=","Total genetic gain per cycle (%)=","Gain/(cost per grandparent)=","Gain/time=","Group merit/time=","Diversity loss per cycle","Weight for group coancestry="," Rotation age=","BP size","Number of founders"]

{"sheet":"Wilhelm08","index":2,"n_rows":43,"n_cols":34,"rows_kept":43,"cut":false,"hidden":false,"merged":[[35,0,38,0],[0,17,0,18]]}
["Breeding Cycle Analyser Wilhelm: Deterministic simulator for gain prediction for a program with balance among grandparents, but between and within family selection.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meaning of cell font and colour:"]
[null,"TroubleSolver","Get started","Aim ","How to run","Swedish pine plans","Breeding plan","Assumptions","Initial settings","Results","Costs and time","Correlation","Literature","About",null,null," 081208, last edit Darius","Input","Results"]
[]
["Genetic parameters",null,null,null,null,"Diversity loss, rotation, BP size "]
[null,"Variance components","Standard deviations","ruCVAm=",11,"Diversity loss per cycle",0.01]
["sA2=",1,{"$f":"SQRT(B6)","v":1}," sP2=sA2+sD2+sE2=",{"$f":"B6+B7+B8","v":8},"Weight for group coancestry=",0]
["sD2=",0.25,{"$f":"SQRT(B7)","v":0.5},"h2=",{"$f":"B6/E6","v":0.125}," Rotation age=",70]
["sE2=",6.75,{"$f":"SQRT(B8)","v":2.598076211353316},"H2=",{"$f":"(B6+B7)/E6","v":0.15625},"BP size",{"$f":"D17*G9","v":300}]
[null,null,null,null,null,"Number of grandparents",50]
[null,null,"Constraint: annual budget per grandparent",50]
[null,null,"ANNUAL budget for the whole population ",{"$f":"G9*D10","v":2500}]
[null,null,"Total budget for a cycle and whole population ",{"$f":"D11*D28","v":50000}]
[null,null,"Total budget per cycle and grandparent",{"$f":"D10*D28","v":1000}]
[null,null,"plants in field trials ",{"$f":"G9*D20*D17/2","v":30000}]
[]
[null,"Optimization box","Parameters","Values","number per fam with SPM"]
[null,null,"Parents selected per grandparent (PGP) =",6,{"$f":"D17*2","v":12}]
[null,null,"Proportion of plants in tests which become parents",{"$f":"G8/D14","v":0.01}]
[null,null,"Selection intensity AMONG =",{"$f":"SelBurr(2,(D17*2))","v":1.3708240510201635}]
[null,null,"Offspring family size (m) =",{"$f":"4*($D$13-D22)/(D17*2)-2*$D$24","v":200},null,"Facilititate analyses with Macros"]
[null,null,"Selection intensity WITHIN =",{"$f":"SelBurr((D17*2),D20)","v":1.9657533549936552}]
[null,null,"Fixed cost (Cfixed)=",100]
[null,null,"Cost per test plant (Cm)=",1]
[null,null,"Cost per parent (Cp)=",50]
[null,null,"Total cost per cycle and grandparent =",{"$f":"D22+(D17*2*(2*D24+D20))/4","v":1000}]
[null,null,"Time not used for testing =",5]
[null,null,"Testing time=",15]
[null,null,"Cycle duration=",{"$f":"D26+D27","v":20}]
[null,null,"rf",{"$f":"(0.25*(1+1/$D$20)*SQRT($B$6)*(SQRT(1-1/($D$17*2)*$B$6)))/(SQRT(0.25*$B$6*(1+1/$D$20)+0.25*$B$7+(0.75*$B$7+$B$8)/$D$20))","v":0.40752039207278568}]
[null,null,"rw",{"$f":"(0.5*(1-1/$D$20)*$B$6)/(SQRT((0.5*$B$6+0.75*$B$7)*(1-1/$D$20)+$B$8))","v":0.18246517210318361}]
[null,null," J-M correlation function",6]
[null,null,"function name",{"$f":"rname(D31)","v":"Jansson 2003 south&mid Sw"}]
[null,null,"rjm =",{"$f":"rr(D31,D27/$G$7)","v":0.54556871292059106}]
[null,null,"Genetic gain among (%)=",{"$f":"$D$33*$D$19*$D$29*E5","v":3.3525340904889402}]
[null,null,"Genetic gain within (%)=",{"$f":"$D$33*$D$21*$D$30*E5","v":2.1525395927560949}]
["Result",null,"Total genetic gain per cycle (%)=",{"$f":"D35+D34","v":5.5050736832450351}]
[null,null,"Gain/(cost per grandparent)=",{"$f":"D36/D13","v":5.5050736832450353E-3}]
[null,null,"Gain/time=",{"$f":"D36/D28","v":0.27525368416225177}]
[null,null,"Group merit/time=",{"$f":"(D36-G5*G6)/D28","v":0.27525368416225177}]
[]
[]
["The below area is for copying the results"]
["Constraint: annual budget per grandparent","ANNUAL budget for the whole population ","Total budget for a cycle and whole population ","Total budget per cycle and grandparent","plants in field trials ",null,"Parameters","Candidate parents selected per grandparent (p) =","Selection intensity AMONG =","Offspring family size (m) =","Selection intensity WITHIN =","Initiation cost (CIN)=","Cost per test plant (Cm)=","Cost per parent (Cp)=","Total cost per cycle and grandparent =","Time not used for testing =","Testing time=","Cycle duration=","ramong","rwithin"," J-M correlation function","function name","rjm =","Genetic gain among (%)=","Genetic gain within (%)=","Total genetic gain per cycle (%)=","Gain/(cost per grandparent)=","Gain/time=","Group merit/time=","Diversity loss per cycle","Weight for group coancestry="," Rotation age=","BP size","Number of grandparents"]

{"sheet":"J-M","index":3,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Comparison of functions for Juvenile-Mature genetic correlations"]
["Try different J-M genetic correlation functions. Use the one you believe best fit your situation "]
["How to use","Aim","Advice","Acknowledgements",null,"This sheet was created by Darius Danusevicius and last edited by Dag Lindgren 2008-07-08"]
[]
[]
[]
["Function","rj-m"]
["Lambeth (1980)",{"$f":"rg0(B13)","v":0.80651066838753682}]
["Lambeth & Dill (2001)",{"$f":"_rg1(B13)","v":0.97291560463601623}]
["Gwaze et al (2000)",{"$f":"_rg2(B13)","v":0.88097335617961181}]
["Jansson et al (2003) south&middle Sw",{"$f":"_rg6(B13)","v":0.79552158173481613}]
["Custom",{"$f":"_rg3(B13)","v":{"$error":"#NAME?"}}]
["Choose Q=",0.5]
[]
[]
["Custom design box."]
["Q","rj-m"]
[0,0.1]
[0.1,0.4]
[0.5,0.85]
[1,1]
[]
[]
[]
[]
[]
[]
["Box for plot (illustrates the difference between the functions)"]
["Ratio selection","J-M correlation coefficient (rj-m)"]
["over rotation age (Q)","Lambeth (1980)","Lambeth & Dill (2001)","Gwaze et al (2000)","Jansson et al (2003)s","Jansson et al (2003)m","Jansson et al (2003)S&M","Custom function"]
[0,{"$f":"rg0(A31)","v":0},{"$f":"_rg1(A31)","v":0},{"$f":"_rg2($A31)","v":0},{"$f":"_rg4($A31)","v":0},{"$f":"_rg5($A31)","v":0},{"$f":"_rg6($A31)","v":0},{"$f":"_rg3(A31)","v":{"$error":"#NAME?"}}]
[0.1,0.31080379135783404,0.50041398517311708,0.53494420500628026,0.50033903482029218,2.8309090756512847E-2,{"$f":"_rg6($A32)","v":0.32073739756675662},{"$error":"#NAME?"}]
[0.2,0.52429312297029718,0.76615154138993702,0.68397084882666848,0.65075197300180021,0.32081720095280969,{"$f":"_rg6($A33)","v":0.52521581583194044},{"$error":"#NAME?"}]
[0.3,0.64917637626761171,0.877944049671467,0.77114584706992373,0.73873790146127183,0.49192347657445495,0.64482802272384887,{"$error":"#NAME?"}]
[0.4,0.73778245458276026,0.93772030687878949,0.83299749264705669,0.80116491118330835,0.6133253111491066,0.72969423409712431,{"$error":"#NAME?"}]
[0.5,0.80651066838753682,0.97291560463601623,0.88097335617961181,0.84958706181849186,0.70749188980370314,0.79552158173481613,{"$error":"#NAME?"}]
[0.6,0.86266570788007491,0.99442760384620055,0.92017249089031206,0.88915083964277997,0.78443158677075198,0.84930644098903274,{"$error":"#NAME?"}]
[0.7,0.91014411726687039,1,0.95331488705317258,0.92260153716529503,0.84948317365785486,0.89478089153807394,{"$error":"#NAME?"}]
[0.8,0.95127178619522346,1,0.98202413646744491,0.95157784936481649,0.90583342134540346,0.93417265236230818,{"$error":"#NAME?"}]
[0.9,0.98754896117738955,1,1,0.9771367681022517,0.95553786239239735,0.96891864788094129,{"$error":"#NAME?"}]
[1,1,1,1,1,1,1,{"$error":"#NAME?"}]