{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Information","Migration Model","Adjustments","Im_Family","Im_MLabor","Im_FLabor","Em_Family","Em_MLabor","Em_FLabor"],"not_rendered":{"charts":15,"images":6,"macros":1,"external_links":0,"defined_names":26,"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":"Information","index":0,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,0,3,10],[5,0,5,10]]}
["Purpose of template:"]
["To estimate an age and sex profile of migration following the Castro Model."]
["General description of the template:"]
["There are a total of three worksheets (Information (this sheet), Migration Model and Adjustments). The major worksheet is the Migration Model worksheet. It differentiates basically between two types of migration: 1. labor and 2. family migration. It also allows the user to distinguish between male and female migration flows and emigration- and immigration-dominated flows. The Adjustments worksheet allows the user to adjust the numbers by hand and obtain a corresponding graph. Helper sheets to this template are hidden, but must not be deleted."]
["Use:"]
["One only has to enter a value for the net flow (net migrants) and decide on the model one wants to use (always decide on the net value first and then choose the model). One should enter a positive number for immigration-dominated flows and a negative number for emigration-dominated flows. If one, by mistake, enters a positive net inflow number and decides on an emigration-dominated model, one will automatically be moved to the corresponding immigration-dominated model. The values that can be picked up for use in Abacus are given in the first range of cells highlighted (values in 1000)."]

{"sheet":"Migration Model","index":1,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[[11,1,11,2],[11,3,11,4],[0,13,0,15],[33,1,33,2],[33,3,33,4],[10,1,10,2]]}
["Migration by Age and Sex According to Castro",null,null,null,null,null,null,null,null,null,null,null,null,"Migration Model"]
[]
[]
["Net Migrants",2000]
[]
[]
[]
[]
[]
[]
[null,"Values in 1000"]
[null,"Migration Numbers",null,"Distribution"]
["Age","Male","Female","Male","Female"]
[" 0-4",{"$f":"+B36/1000","v":6.165814190382455E-2},6.160539432946139E-2,{"$f":"+D36","v":6.165814190382455E-2},6.1605394329461362E-2]
["5-9",2.6796518011277352E-2,2.677359400995603E-2,2.6796518011277352E-2,2.677359400995602E-2]
["  10-14",2.0542239536177419E-2,2.1899667327747355E-2,2.0542239536177419E-2,2.1899667327747344E-2]
["  15-19",0.10474084550865365,0.11578261881759325,0.10474084550865365,0.11578261881759319]
["  20-24",0.1885232686983386,0.20147584108663852,0.1885232686983386,0.20147584108663844]
["  25-29",0.18118330345580574,0.18654820106666797,0.18118330345580574,0.18654820106666789]
["  30-34",0.13722607638652248,0.13606213719564877,0.13722607638652248,0.13606213719564872]
["  35-39",9.5175019220968465E-2,9.0865983072568129E-2,9.5175019220968465E-2,9.0865983072568088E-2]
["  40-44",6.3909556871420026E-2,5.874915282082524E-2,6.3909556871420026E-2,5.8749152820825212E-2]
["  45-49",4.2410684767241469E-2,3.7536967080140628E-2,4.2410684767241469E-2,3.7536967080140607E-2]
["  50-54",2.8023447973658223E-2,2.3880835066395729E-2,2.8023447973658223E-2,2.3880835066395718E-2]
["  55-59",1.8488422233034495E-2,1.5169475496315671E-2,1.8488422233034495E-2,1.5169475496315664E-2]
["  60-64",1.219113267945059E-2,9.630696032572033E-3,1.219113267945059E-2,9.6306960325720278E-3]
["  65-69",8.0372946605622182E-3,6.113179798086202E-3,8.0372946605622182E-3,6.1131797980861994E-3]
["  70-74",5.2984885751997373E-3,3.8801981452344938E-3,5.2984885751997373E-3,3.880198145234492E-3]
["  75-79",3.4929209701450746E-3,2.4628402146762113E-3,3.4929209701450746E-3,2.4628402146762104E-3]
["  80+",2.3026385477199237E-3,1.5632184394726314E-3,2.3026385477199237E-3,1.5632184394726307E-3]
["TOTAL",1,1.0000000000000004,1,0.99999999999999978]
[]
[]
[null,"Migration Numbers",null,"Distribution"]
["Age","Male","Female","Male","Female"]
[2.5,61.65814190382455,61.60539432946139,6.165814190382455E-2,6.1605394329461362E-2]
[{"$f":"A36+5","v":7.5},26.796518011277353,26.773594009956032,2.6796518011277352E-2,2.677359400995602E-2]
[12.5,20.542239536177419,21.899667327747355,2.0542239536177419E-2,2.1899667327747344E-2]
[17.5,104.74084550865365,115.78261881759325,0.10474084550865365,0.11578261881759319]
[22.5,188.5232686983386,201.47584108663852,0.1885232686983386,0.20147584108663844]
[27.5,181.18330345580574,186.54820106666799,0.18118330345580574,0.18654820106666789]
[32.5,137.22607638652249,136.06213719564877,0.13722607638652248,0.13606213719564872]
[37.5,95.175019220968466,90.865983072568127,9.5175019220968465E-2,9.0865983072568088E-2]
[42.5,63.909556871420023,58.749152820825238,6.3909556871420026E-2,5.8749152820825212E-2]
[47.5,42.41068476724147,37.536967080140627,4.2410684767241469E-2,3.7536967080140607E-2]
[52.5,28.023447973658225,23.880835066395729,2.8023447973658223E-2,2.3880835066395718E-2]
[57.5,18.488422233034495,15.169475496315671,1.8488422233034495E-2,1.5169475496315664E-2]
[62.5,12.19113267945059,9.6306960325720325,1.219113267945059E-2,9.6306960325720278E-3]
[67.5,8.0372946605622175,6.1131797980862022,8.0372946605622182E-3,6.1131797980861994E-3]
[72.5,5.2984885751997375,3.8801981452344938,5.2984885751997373E-3,3.880198145234492E-3]
[77.5,3.4929209701450747,2.4628402146762114,3.4929209701450746E-3,2.4628402146762104E-3]
[82.5,2.3026385477199236,1.5632184394726314,2.3026385477199237E-3,1.5632184394726307E-3]
["TOTAL",{"$f":"SUM(B36:B52)","v":1000},{"$f":"SUM(C36:C52)","v":1000.0000000000005},{"$f":"SUM(D36:D52)","v":1},{"$f":"SUM(E36:E52)","v":0.99999999999999978}]

{"sheet":"Adjustments","index":2,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[23,1,23,2],[23,3,23,4]]}
[null,"Migration Numbers",null,"Distribution"]
["Age","Male","Female","Male","Female","Sex Ratio"]
[" 0-4",0.1578191025976334,0.15898166278570683,{"$f":"+(B3/$B$21)","v":0.11119073137560537},{"$f":"+(C3/$C$21)","v":6.160539432946139E-2},{"$f":"+B3/C3","v":0.99268745736015829}]
["  5-9",6.8587899257126245E-2,6.9093145832144584E-2,{"$f":"+(B4/$B$21)","v":4.8323292658429856E-2},{"$f":"+(C4/$C$21)","v":2.6773594009956023E-2},{"$f":"+B4/C4","v":0.99268745736015862}]
["  10-14",4.1193867751221594E-2,5.6515270523218981E-2,2.9022952279269761E-2,2.1899667327747351E-2,0.72889800172322139]
["  15-19",0.14052370936671613,0.29879385501314387,9.9005340690186378E-2,0.11578261881759323,0.47030321075557102]
["  20-24",0.24408545095272272,0.51993765441713158,0.17196929498941829,0.20147584108663846,0.46945138302466494]
["  25-29",0.23310021088773625,0.48141471243011086,0.16422969403454146,0.18654820106666792,0.48419835303969122]
["  30-34",0.17615242198402414,0.35112809598877098,0.12410738821601702,0.13606213719564875,0.50167566764482863]
["  35-39",0.12203522886596133,0.2344928595421113,8.5979365791927304E-2,9.0865983072568116E-2,0.52042193994416996]
["  40-44",8.1891315465872527E-2,0.15161071695696837,5.7696154078228375E-2,5.8749152820825233E-2,0.54014199727790824]
["  45-49",5.4320467460713645E-2,9.6869592464879029E-2,3.8271238438230069E-2,3.7536967080140621E-2,0.56075870743864265]
["  50-54",3.5883131322211284E-2,6.1627961461666395E-2,2.528129706792159E-2,2.3880835066395725E-2,0.58225406895100984]
["  55-59",2.3669564458455795E-2,3.9147033538879147E-2,1.6676284050275676E-2,1.5169475496315667E-2,0.60463239021542214]
["  60-64",1.5605687576824496E-2,2.4853409116314923E-2,1.0994916247308169E-2,9.6306960325720312E-3,0.62790933444137464]
["  65-69",1.0287616427321027E-2,1.5775947866028907E-2,7.2480933919761787E-3,6.1131797980862003E-3,0.65210765874003918]
["  70-74",6.7816360300270708E-3,1.0013414568347081E-2,4.7779708393372554E-3,3.8801981452344933E-3,0.67725509452731247]
["  75-79",4.4705038083284942E-3,6.3557166830353843E-3,3.149673137685985E-3,2.4628402146762113E-3,0.70338311653524743]
["  80+",2.9470244967813161E-3,4.0341121018648545E-3,2.076312713641382E-3,1.5632184394726309E-3,0.73052617834268685]
[]
["TOTAL",{"$f":"SUM(B3:B20)","v":1.4193548387096773},{"$f":"SUM(C3:C20)","v":2.580645161290323},1,1,0.54999999999999982]

{"sheet":"Im_Family","index":3,"n_rows":69,"n_cols":13,"rows_kept":69,"cut":false,"hidden":true,"merged":[[49,0,50,0]]}
["Castro's model as a template"]
[]
[]
[]
[]
[]
["Input Parameters"]
["Number of net migrants",2000]
["SRAe",1]
["SRAi",1]
["Immigrant-Emigrant Ratio",0]
[]
[null,"Migration Numbers",null,"Distribution"]
["Age","Male","Female","Male","Female"]
[2.5,{"$f":"IF($B$8<0,$J$39*($J$37*J52-D52)/($J$37-1),$J$39*(J52-$J$37*D52)/(1-$J$37))","v":61.65814190382455},{"$f":"IF($B$8<0,$J$40*($J$38*M52-G52)/($J$38-1),$J$40*(M52-$J$38*G52)/(1-$J$38))","v":61.60539432946139},{"$f":"B15/ABS($B$32)","v":6.165814190382455E-2},{"$f":"C15/ABS($C$32)","v":6.1605394329461362E-2}]
[{"$f":"A15+5","v":7.5},26.796518011277353,26.773594009956032,2.6796518011277352E-2,2.677359400995602E-2]
[12.5,20.542239536177419,21.899667327747355,2.0542239536177419E-2,2.1899667327747344E-2]
[17.5,104.74084550865365,115.78261881759325,0.10474084550865365,0.11578261881759319]
[22.5,188.5232686983386,201.47584108663852,0.1885232686983386,0.20147584108663844]
[27.5,181.18330345580574,186.54820106666799,0.18118330345580574,0.18654820106666789]
[32.5,137.22607638652249,136.06213719564877,0.13722607638652248,0.13606213719564872]
[37.5,95.175019220968466,90.865983072568127,9.5175019220968465E-2,9.0865983072568088E-2]
[42.5,63.909556871420023,58.749152820825238,6.3909556871420026E-2,5.8749152820825212E-2]
[47.5,42.41068476724147,37.536967080140627,4.2410684767241469E-2,3.7536967080140607E-2]
[52.5,28.023447973658225,23.880835066395729,2.8023447973658223E-2,2.3880835066395718E-2]
[57.5,18.488422233034495,15.169475496315671,1.8488422233034495E-2,1.5169475496315664E-2]
[62.5,12.19113267945059,9.6306960325720325,1.219113267945059E-2,9.6306960325720278E-3]
[67.5,8.0372946605622175,6.1131797980862022,8.0372946605622182E-3,6.1131797980861994E-3]
[72.5,5.2984885751997375,3.8801981452344938,5.2984885751997373E-3,3.880198145234492E-3]
[77.5,3.4929209701450747,2.4628402146762114,3.4929209701450746E-3,2.4628402146762104E-3]
[82.5,2.3026385477199236,1.5632184394726314,2.3026385477199237E-3,1.5632184394726307E-3]
[null,{"$f":"SUM(B15:B31)","v":1000},{"$f":"SUM(C15:C31)","v":1000.0000000000005},{"$f":"SUM(D15:D31)","v":1},{"$f":"SUM(E15:E31)","v":0.99999999999999978}]
[]
["The section below includes all the calculations for the Castro model. Explanations can be found in Castro's appendix."]
[]
["Proportion child migrants",null,"Numbers of Migrants",null,"Sex Ratios",null,"Sex-specific migrant No.",null,"Sex-specific M Ratios",null,"K=",{"$f":"IF(B11=0,0,IF(B8<0,B11,1/B11))","v":0}]
["Wim",{"$f":"($B$38/($B$10*(1-$B$38)))/(1+($B$38/($B$10*(1-$B$38))))","v":0.1},"ET",{"$f":"IF(B11<>0,IF(B8<0,B8/(L36-1),D38-B8),IF(B8>0,0,D38-B8))","v":0},"Sre",{"$f":"B9*(1-$B$40)/(1-$B$39)","v":1},"Ef",{"$f":"D37/(F37+1)","v":0},"Km",{"$f":"IF(B8<0,H40/H38,H38/H40)","v":0},"pmue",20]
["Wif",0.1,"IT",{"$f":"IF(B11<>0,IF(B8<0,B8+D37,B8/(1-1/L36)),IF(B8<0,0,B8/(1-L36)))","v":2000},"Sri",{"$f":"B10*(1-$B$38)/(1-$B$37)","v":1},"Em",{"$f":"D37-H37","v":0},"Kf",{"$f":"IF(B8<0,H39/H37,H37/H39)","v":0},"plae",0.2]
["Wem",{"$f":"($B$40/($B$9*(1-$B$40)))/(1+($B$40/($B$9*(1-$B$40))))","v":0.1},null,null,null,null,"If",{"$f":"D38/(F38+1)","v":1000},"Nm",{"$f":"H40-H38","v":1000},"pmui",25]
["Wef",0.1,null,null,null,null,"Im",{"$f":"D38-H39","v":1000},"Nf",{"$f":"H39-H37","v":1000},"plai",0.2]
[]
["These are constants for the Castro model. They may be varied if desired."]
[null,"Net Emigration Country",null,null,null,"Net Immigration Country"]
[" ","Emigration",null,"Immigration",null,"Emigration",null,"Immigration"]
[null,"males","females","males","females","males","females","males","females"]
["Mean Child Migration Age",6,6,7,7,7,7,6,6]
["Mean Adult MigrationAge",32,31,35,33,35,33,32,31]
[]
[]
["Age",null,"MALES",null,null,"FEMALES",null,null,"MALES",null,null,"FEMALES"]
[null,"ae(x)","ce(x)","e(x)","ae(x)","ce(x)","e(x)","ai(x)","ci(x)","I(x)","ai(x)","ci(x)","I(x)"]
[2.5,0,{"$f":"IF($B$8<0,(1/$B$46)*EXP(-A52/$B$46),(1/$F$46)*EXP(-A52/$F$46))","v":9.9953219625018616E-2},{"$f":"($B$39*C52+(1-$B$39)*B52)*5/$D$69","v":5.5949848262754703E-2},0,{"$f":"IF($B$8<0,(1/$C$46)*EXP(-A52/$C$46),(1/$G$46)*EXP(-A52/$G$46))","v":9.9953219625018616E-2},{"$f":"($B$40*F52+(1-$B$40)*E52)*5/$G$69","v":5.6075620033075674E-2},0,{"$f":"IF($B$8<0,(1/$D$46)*EXP(-A52/$D$46),(1/$H$46)*EXP(-A52/$H$46))","v":0.10987343836674063},{"$f":"($B$37*I52+(1-$B$37)*H52)*5/$J$69","v":6.165814190382455E-2},0,{"$f":"IF($B$8<0,(1/$E$46)*EXP(-A52/$E$46),(1/$I$46)*EXP(-A52/$I$46))","v":0.10987343836674063},{"$f":"($B$38*L52+(1-$B$38)*K52)*5/$M$69","v":6.160539432946139E-2}]
[{"$f":"A52+5","v":7.5},0,4.893126501329223E-2,2.7389781570508646E-2,0,4.893126501329223E-2,2.7451352091676991E-2,0,4.7750799476698344E-2,2.6796518011277352E-2,0,4.7750799476698344E-2,2.677359400995603E-2]
[12.5,{"$f":"IF($B$8<0,(1/($B$47-$L$37))*EXP((-1*((A54-$L$37)/($B$47-$L$37)))-EXP(-$L$38*(A54-$L$37))),(1/($F$47-$L$39))*EXP((-1*((A54-$L$39)/($F$47-$L$39)))-EXP(-$L$40*(A54-$L$39))))","v":1.7868092802539951E-6},2.3953892678828151E-2,1.3417440789671196E-2,{"$f":"IF($B$8<0,(1/($C$47-$L$37))*EXP((-1*((A54-$L$37)/($C$47-$L$37)))-EXP(-$L$38*(A54-$L$37))),(1/($G$47-$L$37))*EXP((-1*((A54-$L$37)/($G$47-$L$37)))-EXP(-$L$38*(A54-$L$37))))","v":1.5496667814431579E-3},2.3953892678828151E-2,2.1263108108684071E-2,{"$f":"IF($B$8<0,(1/($D$47-$L$39))*EXP((-1*((A54-$L$39)/($D$47-$L$39)))-EXP(-$L$40*(A54-$L$39))),(1/($H$47-$L$37))*EXP((-1*((A54-$L$37)/($H$47-$L$37)))-EXP(-$L$40*(A54-$L$37))))","v":1.761489149293679E-3},2.0752411907353826E-2,2.0542239536177419E-2,{"$f":"IF($B$8<0,(1/($E$47-$L$39))*EXP((-1*((A54-$L$39)/($E$47-$L$39)))-EXP(-$L$40*(A54-$L$39))),(1/($I$47-$L$37))*EXP((-1*((A54-$L$37)/($I$47-$L$37)))-EXP(-$L$40*(A54-$L$37))))","v":2.0339691241906539E-3},2.0752411907353826E-2,2.1899667327747355E-2]
[17.5,2.3952344455393589E-3,1.1726428374842685E-2,1.8630804783053203E-2,1.7928512866990032E-2,1.1726428374842685E-2,9.7102815255891442E-2,1.9736321948105144E-2,9.0189610371369348E-3,0.10474084550865365,2.1942194283250647E-2,9.0189610371369348E-3,0.11578261881759325]
[22.5,2.4691249640196391E-2,5.7405752072962318E-3,0.12760398711236454,3.4603940729701764E-2,5.7405752072962318E-3,0.17794167380373438,3.6891627790177794E-2,3.9196243093348512E-3,0.1885232686983386,3.9490361094255889E-2,3.9196243093348512E-3,0.20147584108663852]
[27.5,4.2463272518319647E-2,2.8102507137912985E-3,0.21549636989267498,3.4561926445827576E-2,2.8102507137912985E-3,0.17608556995101393,3.5684573089433853E-2,1.7034617028577207E-3,0.18118330345580574,3.6778434861909674E-2,1.7034617028577207E-3,0.18654820106666797]
[32.5,3.7789830265774781E-2,1.3757347982005037E-3,0.19114931613103345,2.7090482348821051E-2,1.3757347982005037E-3,0.13755620464991802,2.7088166280544862E-2,7.4032140432238173E-4,0.13722607638652248,2.6880775648140495E-2,7.4032140432238173E-4,0.13606213719564877]
[37.5,2.639264010449572E-2,6.7347949622132504E-4,0.13333896604353074,1.9422937090839181E-2,6.7347949622132504E-4,9.8447503535516179E-2,1.8808669599302275E-2,3.2174235603795153E-4,9.5175019220968465E-2,1.7970895486403633E-2,3.2174235603795153E-4,9.0865983072568129E-2]
[42.5,1.6860486417882733E-2,3.2969627025776813E-4,8.5125035478246736E-2,1.3476234062213698E-2,3.2969627025776813E-4,6.8228733152440574E-2,1.2638397904905773E-2,1.398286515349403E-4,6.3909556871420026E-2,1.1626610321864076E-2,1.398286515349403E-4,5.874915282082524E-2]
[47.5,1.0423482457363228E-2,1.6140005929172552E-4,5.2602214168612542E-2,9.2380842757863822E-3,1.6140005929172552E-4,4.6735186310813581E-2,8.3904586989555479E-3,6.0769281455045536E-5,4.2410684767241469E-2,7.4318382311539394E-3,6.0769281455045536E-5,3.7536967080140628E-2]
[52.5,6.3667135774909608E-3,7.9012052878261945E-5,3.2118731660178118E-2,6.3047447340697366E-3,7.9012052878261945E-5,3.1878041476082211E-2,5.5456390196924584E-3,2.6410220852625209E-5,2.8023447973658223E-2,4.7294603848062108E-3,2.6410220852625209E-5,2.3880835066395729E-2]
[57.5,3.8715956967279638E-3,3.8679691491026108E-5,1.9526142890561062E-2,4.2957985022568845E-3,3.8679691491026108E-5,2.171190759822967E-2,3.6593866259261908E-3,1.1477834668827187E-5,1.8488422233034495E-2,3.0048150321232256E-3,1.1477834668827187E-5,1.5169475496315671E-2]
[62.5,2.3504742154758489E-3,1.8935320363667863E-5,1.1851919468506601E-2,2.9252258281854487E-3,1.8935320363667863E-5,1.4780579193374227E-2,2.4132599122320573E-3,4.9882463846127348E-6,1.219113267945059E-2,1.9079324601940062E-3,4.9882463846127348E-6,9.630696032572033E-3]
[67.5,1.4261331883835774E-3,9.2696281550725406E-6,7.1898239638266397E-3,1.9914936116864979E-3,9.2696281550725406E-6,1.0060585897321474E-2,1.5911236170304782E-3,2.1678829423446033E-6,8.0372946605622182E-3,1.2111899864102845E-3,2.1678829423446033E-6,6.113179798086202E-3]
[72.5,8.6510476321392858E-4,4.5378691505100649E-6,4.3608021514912445E-3,1.3556985365314593E-3,4.5378691505100649E-6,6.8476952570353999E-3,1.0489829678721001E-3,9.4215804299601768E-7,5.2984885751997373E-3,7.6882277091177946E-4,9.4215804299601768E-7,3.8801981452344938E-3]
[77.5,5.2473739031462345E-4,2.2214759947930001E-6,2.6447881171776954E-3,9.2285686564094055E-4,2.2214759947930001E-6,4.6609054803328836E-3,6.9154422996965778E-4,4.094601976166045E-7,3.4929209701450746E-3,4.8800830678055653E-4,4.094601976166045E-7,2.4628402146762113E-3]
[82.5,3.1827485548056004E-4,1.0875050451568976E-6,1.6040275158081914E-3,6.2820413297450905E-4,1.0875050451568976E-6,3.172518204859317E-3,4.5589697327644036E-4,1.7795066833913044E-7,2.3026385477199237E-3,3.0975862857357517E-4,1.7795066833913044E-7,1.5632184394726314E-3]
[null,{"$f":"SUM(B52:B68)","v":0.17674101634593956},{"$f":"SUM(C52:C68)","v":0.19580968578011898},{"$f":"($B$39*C69+(1-$B$39)*B69)*5","v":0.89323941644678739},{"$f":"SUM(E52:E68)","v":0.17629580681296833},{"$f":"SUM(F52:F68)","v":0.19580968578011898},{"$f":"($B$40*F69+(1-$B$40)*E69)*5","v":0.89123597354841699},{"$f":"SUM(H52:H68)","v":0.17640553780671833},{"$f":"SUM(I52:I68)","v":0.19432793224723},{"$f":"($B$37*I69+(1-$B$37)*H69)*5","v":0.89098888625384742},{"$f":"SUM(K52:K68)","v":0.17657506662096861},{"$f":"SUM(L52:L68)","v":0.19432793224723},{"$f":"($B$38*L69+(1-$B$38)*K69)*5","v":0.89175176591797367}]

{"sheet":"Im_MLabor","index":4,"n_rows":69,"n_cols":13,"rows_kept":69,"cut":false,"hidden":true,"merged":[[49,0,50,0],[74,0,75,0]]}
["Castro's model as a template"]
[]
[]
[]
[]
[]
["Input Parameters"]
["Number of net migrants",2000]
["SRAe",1]
["SRAi",2]
["Immigrant-Emigrant Ratio",0]
[]
[null,"Migration Numbers",null,"Distribution"]
["Age","Male","Female","Male","Female"]
[2.5,{"$f":"IF($B$8<0,$J$39*($J$37*J52-D52)/($J$37-1),$J$39*(J52-$J$37*D52)/(1-$J$37))","v":42.72641021442039},{"$f":"IF($B$8<0,$J$40*($J$38*M52-G52)/($J$38-1),$J$40*(M52-$J$38*G52)/(1-$J$38))","v":42.486478847904401},{"$f":"B15/ABS($B$32)","v":3.2606997268899769E-2},{"$f":"C15/ABS($C$32)","v":6.1605394329461376E-2}]
[{"$f":"A15+5","v":7.5},{"$f":"IF($B$8<0,$J$39*($J$37*J53-D53)/($J$37-1),$J$39*(J53-$J$37*D53)/(1-$J$37))","v":18.568821335125623},18.464547593073121,1.4170942597859027E-2,2.6773594009956023E-2]
[12.5,20.399780338795729,15.103218846722312,1.556825341644937E-2,2.1899667327747351E-2]
[17.5,141.65450211219462,79.850081943167751,0.108104751611938,0.11578261881759323]
[22.5,259.75262724372448,138.94885592181964,0.19823226815968445,0.20147584108663846]
[27.5,250.44187165850545,128.65393177011583,0.19112669152885942,0.18654820106666795]
[32.5,189.89551493447405,93.835956686654313,0.14492026139736178,0.13606213719564875]
[37.5,131.77918069269677,62.666195222460772,0.10056832210758437,9.0865983072568116E-2]
[42.5,88.518710627286978,40.516657117810503,6.7553752847140061E-2,5.8749152820825226E-2]
[47.5,58.753888053976482,25.887563503545259,4.4838493514876787E-2,3.7536967080140621E-2]
[52.5,38.827790730520732,16.469541425100502,2.9631735031186872E-2,2.3880835066395725E-2]
[57.5,25.618881346933915,10.461707238838393,1.9551251554239039E-2,1.5169475496315669E-2]
[62.5,16.893909490830445,6.6418593328082975,1.2892720400896918E-2,9.6306960325720312E-3]
[67.5,11.138148132825492,4.2159860676456562,8.5001656803141909E-3,6.1131797980862011E-3]
[72.5,7.342877821084322,2.6759987208513749,5.6037751792485614E-3,3.8801981452344933E-3]
[77.5,4.8407253544652207,1.6985104928801456,3.6942377705129312E-3,2.4628402146762108E-3]
[82.5,3.1911874983461277,1.078081682394918,2.4353799329483606E-3,1.5632184394726309E-3]
[null,{"$f":"SUM(B15:B31)","v":1310.344827586207},{"$f":"SUM(C15:C31)","v":689.65517241379314},{"$f":"SUM(D15:D31)","v":1},{"$f":"SUM(E15:E31)","v":1.0000000000000002}]
[]
["The section below includes all the calculations for the Castro model. Explanations can be found in Castro's appendix."]
[]
["Proportion child migrants",null,"Numbers of Migrants",null,"Sex Ratios",null,"Sex-specific migrant No.",null,"Sex-specific M Ratios",null,"K=",{"$f":"IF(B11=0,0,IF(B8<0,B11,1/B11))","v":0}]
["Wim",{"$f":"($B$38/($B$10*(1-$B$38)))/(1+($B$38/($B$10*(1-$B$38))))","v":5.2631578947368425E-2},"ET",{"$f":"IF(B11<>0,IF(B8<0,B8/(L36-1),D38-B8),IF(B8>0,0,D38-B8))","v":0},"Sre",{"$f":"B9*(1-$B$40)/(1-$B$39)","v":1},"Ef",{"$f":"D37/(F37+1)","v":0},"Km",{"$f":"IF(B8<0,H40/H38,H38/H40)","v":0},"pmue",20]
["Wif",0.1,"IT",{"$f":"IF(B11<>0,IF(B8<0,B8+D37,B8/(1-1/L36)),IF(B8<0,0,B8/(1-L36)))","v":2000},"Sri",{"$f":"B10*(1-$B$38)/(1-$B$37)","v":1.9000000000000001},"Em",{"$f":"D37-H37","v":0},"Kf",{"$f":"IF(B8<0,H39/H37,H37/H39)","v":0},"plae",0.2]
["Wem",{"$f":"($B$40/($B$9*(1-$B$40)))/(1+($B$40/($B$9*(1-$B$40))))","v":0.1},null,null,null,null,"If",{"$f":"D38/(F38+1)","v":689.65517241379303},"Nm",{"$f":"H40-H38","v":1310.344827586207},"pmui",25]
["Wef",0.1,null,null,null,null,"Im",{"$f":"D38-H39","v":1310.344827586207},"Nf",{"$f":"H39-H37","v":689.65517241379303},"plai",0.2]
[]
["These are constants for the Castro model. They may be varied if desired."]
[null,"Net Emigration Country",null,null,null,"Net Immigration Country"]
[" ","Emigration",null,"Immigration",null,"Emigration",null,"Immigration"]
[null,"males","females","males","females","males","females","males","females"]
["Mean Child Migration Age",6,6,7,7,7,7,6,6]
["Mean Adult MigrationAge",32,31,35,33,35,33,32,31]
[]
[]
["Age",null,"MALES",null,null,"FEMALES",null,null,"MALES",null,null,"FEMALES"]
[null,"ae(x)","ce(x)","e(x)","ae(x)","ce(x)","e(x)","ai(x)","ci(x)","I(x)","ai(x)","ci(x)","I(x)"]
[2.5,0,{"$f":"IF($B$8<0,(1/$B$46)*EXP(-A52/$B$46),(1/$F$46)*EXP(-A52/$F$46))","v":9.9953219625018616E-2},{"$f":"($B$39*C52+(1-$B$39)*B52)*5/$D$69","v":5.5949848262754703E-2},0,{"$f":"IF($B$8<0,(1/$C$46)*EXP(-A52/$C$46),(1/$G$46)*EXP(-A52/$G$46))","v":9.9953219625018616E-2},{"$f":"($B$40*F52+(1-$B$40)*E52)*5/$G$69","v":5.6075620033075674E-2},0,{"$f":"IF($B$8<0,(1/$D$46)*EXP(-A52/$D$46),(1/$H$46)*EXP(-A52/$H$46))","v":0.10987343836674063},{"$f":"($B$37*I52+(1-$B$37)*H52)*5/$J$69","v":3.2606997268899769E-2},0,{"$f":"IF($B$8<0,(1/$E$46)*EXP(-A52/$E$46),(1/$I$46)*EXP(-A52/$I$46))","v":0.10987343836674063},{"$f":"($B$38*L52+(1-$B$38)*K52)*5/$M$69","v":6.160539432946139E-2}]
[{"$f":"A52+5","v":7.5},0,4.893126501329223E-2,2.7389781570508646E-2,0,4.893126501329223E-2,2.7451352091676991E-2,0,4.7750799476698344E-2,1.4170942597859029E-2,0,4.7750799476698344E-2,2.677359400995603E-2]
[12.5,{"$f":"IF($B$8<0,(1/($B$47-$L$37))*EXP((-1*((A54-$L$37)/($B$47-$L$37)))-EXP(-$L$38*(A54-$L$37))),(1/($F$47-$L$39))*EXP((-1*((A54-$L$39)/($F$47-$L$39)))-EXP(-$L$40*(A54-$L$39))))","v":1.7868092802539951E-6},2.3953892678828151E-2,1.3417440789671196E-2,{"$f":"IF($B$8<0,(1/($C$47-$L$37))*EXP((-1*((A54-$L$37)/($C$47-$L$37)))-EXP(-$L$38*(A54-$L$37))),(1/($G$47-$L$37))*EXP((-1*((A54-$L$37)/($G$47-$L$37)))-EXP(-$L$38*(A54-$L$37))))","v":1.5496667814431579E-3},2.3953892678828151E-2,2.1263108108684071E-2,{"$f":"IF($B$8<0,(1/($D$47-$L$39))*EXP((-1*((A54-$L$39)/($D$47-$L$39)))-EXP(-$L$40*(A54-$L$39))),(1/($H$47-$L$37))*EXP((-1*((A54-$L$37)/($H$47-$L$37)))-EXP(-$L$40*(A54-$L$37))))","v":1.761489149293679E-3},2.0752411907353826E-2,1.556825341644937E-2,{"$f":"IF($B$8<0,(1/($E$47-$L$39))*EXP((-1*((A54-$L$39)/($E$47-$L$39)))-EXP(-$L$40*(A54-$L$39))),(1/($I$47-$L$37))*EXP((-1*((A54-$L$37)/($I$47-$L$37)))-EXP(-$L$40*(A54-$L$37))))","v":2.0339691241906539E-3},2.0752411907353826E-2,2.1899667327747355E-2]
[17.5,2.3952344455393589E-3,1.1726428374842685E-2,1.8630804783053203E-2,1.7928512866990032E-2,1.1726428374842685E-2,9.7102815255891442E-2,1.9736321948105144E-2,9.0189610371369348E-3,0.108104751611938,2.1942194283250647E-2,9.0189610371369348E-3,0.11578261881759325]
[22.5,2.4691249640196391E-2,5.7405752072962318E-3,0.12760398711236454,3.4603940729701764E-2,5.7405752072962318E-3,0.17794167380373438,3.6891627790177794E-2,3.9196243093348512E-3,0.19823226815968445,3.9490361094255889E-2,3.9196243093348512E-3,0.20147584108663852]
[27.5,{"$f":"IF($B$8<0,(1/($B$47-$L$37))*EXP((-1*((A57-$L$37)/($B$47-$L$37)))-EXP(-$L$38*(A57-$L$37))),(1/($F$47-$L$39))*EXP((-1*((A57-$L$39)/($F$47-$L$39)))-EXP(-$L$40*(A57-$L$39))))","v":4.2463272518319647E-2},2.8102507137912985E-3,0.21549636989267498,3.4561926445827576E-2,2.8102507137912985E-3,0.17608556995101393,3.5684573089433853E-2,1.7034617028577207E-3,0.19112669152885942,3.6778434861909674E-2,1.7034617028577207E-3,0.18654820106666797]
[32.5,3.7789830265774781E-2,1.3757347982005037E-3,0.19114931613103345,2.7090482348821051E-2,1.3757347982005037E-3,0.13755620464991802,2.7088166280544862E-2,7.4032140432238173E-4,0.14492026139736178,2.6880775648140495E-2,7.4032140432238173E-4,0.13606213719564877]
[37.5,{"$f":"IF($B$8<0,(1/($B$47-$L$37))*EXP((-1*((A59-$L$37)/($B$47-$L$37)))-EXP(-$L$38*(A59-$L$37))),(1/($F$47-$L$39))*EXP((-1*((A59-$L$39)/($F$47-$L$39)))-EXP(-$L$40*(A59-$L$39))))","v":2.639264010449572E-2},6.7347949622132504E-4,0.13333896604353074,1.9422937090839181E-2,6.7347949622132504E-4,9.8447503535516179E-2,1.8808669599302275E-2,3.2174235603795153E-4,0.10056832210758437,1.7970895486403633E-2,3.2174235603795153E-4,9.0865983072568129E-2]
[42.5,1.6860486417882733E-2,3.2969627025776813E-4,8.5125035478246736E-2,1.3476234062213698E-2,3.2969627025776813E-4,6.8228733152440574E-2,1.2638397904905773E-2,1.398286515349403E-4,6.7553752847140061E-2,1.1626610321864076E-2,1.398286515349403E-4,5.874915282082524E-2]
[47.5,1.0423482457363228E-2,1.6140005929172552E-4,5.2602214168612542E-2,9.2380842757863822E-3,1.6140005929172552E-4,4.6735186310813581E-2,8.3904586989555479E-3,6.0769281455045536E-5,4.4838493514876787E-2,7.4318382311539394E-3,6.0769281455045536E-5,3.7536967080140628E-2]
[52.5,6.3667135774909608E-3,7.9012052878261945E-5,3.2118731660178118E-2,6.3047447340697366E-3,7.9012052878261945E-5,3.1878041476082211E-2,5.5456390196924584E-3,2.6410220852625209E-5,2.9631735031186872E-2,4.7294603848062108E-3,2.6410220852625209E-5,2.3880835066395729E-2]
[57.5,3.8715956967279638E-3,3.8679691491026108E-5,1.9526142890561062E-2,4.2957985022568845E-3,3.8679691491026108E-5,2.171190759822967E-2,3.6593866259261908E-3,1.1477834668827187E-5,1.9551251554239039E-2,3.0048150321232256E-3,1.1477834668827187E-5,1.5169475496315671E-2]
[62.5,2.3504742154758489E-3,1.8935320363667863E-5,1.1851919468506601E-2,2.9252258281854487E-3,1.8935320363667863E-5,1.4780579193374227E-2,2.4132599122320573E-3,4.9882463846127348E-6,1.2892720400896918E-2,1.9079324601940062E-3,4.9882463846127348E-6,9.630696032572033E-3]
[67.5,1.4261331883835774E-3,9.2696281550725406E-6,7.1898239638266397E-3,1.9914936116864979E-3,9.2696281550725406E-6,1.0060585897321474E-2,1.5911236170304782E-3,2.1678829423446033E-6,8.5001656803141909E-3,1.2111899864102845E-3,2.1678829423446033E-6,6.113179798086202E-3]
[72.5,8.6510476321392858E-4,4.5378691505100649E-6,4.3608021514912445E-3,1.3556985365314593E-3,4.5378691505100649E-6,6.8476952570353999E-3,1.0489829678721001E-3,9.4215804299601768E-7,5.6037751792485614E-3,7.6882277091177946E-4,9.4215804299601768E-7,3.8801981452344938E-3]
[77.5,5.2473739031462345E-4,2.2214759947930001E-6,2.6447881171776954E-3,9.2285686564094055E-4,2.2214759947930001E-6,4.6609054803328836E-3,6.9154422996965778E-4,4.094601976166045E-7,3.6942377705129312E-3,4.8800830678055653E-4,4.094601976166045E-7,2.4628402146762113E-3]
[82.5,3.1827485548056004E-4,1.0875050451568976E-6,1.6040275158081914E-3,6.2820413297450905E-4,1.0875050451568976E-6,3.172518204859317E-3,4.5589697327644036E-4,1.7795066833913044E-7,2.4353799329483606E-3,3.0975862857357517E-4,1.7795066833913044E-7,1.5632184394726314E-3]
[null,{"$f":"SUM(B52:B68)","v":0.17674101634593956},{"$f":"SUM(C52:C68)","v":0.19580968578011898},{"$f":"($B$39*C69+(1-$B$39)*B69)*5","v":0.89323941644678739},{"$f":"SUM(E52:E68)","v":0.17629580681296833},{"$f":"SUM(F52:F68)","v":0.19580968578011898},{"$f":"($B$40*F69+(1-$B$40)*E69)*5","v":0.89123597354841699},{"$f":"SUM(H52:H68)","v":0.17640553780671833},{"$f":"SUM(I52:I68)","v":0.19432793224723},{"$f":"($B$37*I69+(1-$B$37)*H69)*5","v":0.88674410862319997},{"$f":"SUM(K52:K68)","v":0.17657506662096861},{"$f":"SUM(L52:L68)","v":0.19432793224723},{"$f":"($B$38*L69+(1-$B$38)*K69)*5","v":0.89175176591797367}]

{"sheet":"Im_FLabor","index":5,"n_rows":69,"n_cols":13,"rows_kept":69,"cut":false,"hidden":true,"merged":[[49,0,50,0]]}
["Castro's model as a template"]
[]
[]
[]
[]
[]
["Input Parameters"]
["Number of net migrants",2000]
["SRAe",1]
["SRAi",0.5]
["Immigrant-Emigrant Ratio",0]
[]
[null,"Migration Numbers",null,"Distribution"]
["Age","Male","Female","Male","Female"]
[2.5,{"$f":"IF($B$8<0,$J$39*($J$37*J52-D52)/($J$37-1),$J$39*(J52-$J$37*D52)/(1-$J$37))","v":78.909551298816709},{"$f":"IF($B$8<0,$J$40*($J$38*M52-G52)/($J$38-1),$J$40*(M52-$J$38*G52)/(1-$J$38))","v":79.490831392853408},{"$f":"B15/ABS($B$32)","v":0.11119073137560537},{"$f":"C15/ABS($C$32)","v":6.1605394329461376E-2}]
[{"$f":"A15+5","v":7.5},34.293949628563119,34.546572916072293,4.8323292658429856E-2,2.677359400995602E-2]
[12.5,20.596933875610798,28.25763526160949,2.9022952279269761E-2,2.1899667327747348E-2]
[17.5,70.261854683358067,149.39692750657193,9.9005340690186378E-2,0.11578261881759321]
[22.5,122.04272547636135,259.96882720856581,0.17196929498941829,0.20147584108663844]
[27.5,116.55010544386812,240.70735621505543,0.16422969403454146,0.18654820106666789]
[32.5,88.076210992012065,175.5640479943855,0.12410738821601701,0.13606213719564872]
[37.5,61.017614432980665,117.24642977105565,8.5979365791927304E-2,9.0865983072568102E-2]
[42.5,40.945657732936262,75.80535847848418,5.7696154078228375E-2,5.8749152820825219E-2]
[47.5,27.160233730356822,48.434796232439517,3.8271238438230069E-2,3.7536967080140614E-2]
[52.5,17.941565661105642,30.813980730833197,2.528129706792159E-2,2.3880835066395722E-2]
[57.5,11.834782229227898,19.573516769439575,1.6676284050275676E-2,1.5169475496315666E-2]
[62.5,7.8028437884122477,12.426704558157461,1.0994916247308167E-2,9.6306960325720295E-3]
[67.5,5.1438082136605132,7.8879739330144538,7.2480933919761778E-3,6.1131797980862003E-3]
[72.5,3.3908180150135356,5.0067072841735403,4.7779708393372554E-3,3.8801981452344925E-3]
[77.5,2.2352519041642469,3.177858341517692,3.1496731376859845E-3,2.4628402146762104E-3]
[82.5,1.473512248390658,2.0170560509324273,2.076312713641382E-3,1.5632184394726307E-3]
[null,{"$f":"SUM(B15:B31)","v":709.67741935483866},{"$f":"SUM(C15:C31)","v":1290.3225806451617},{"$f":"SUM(D15:D31)","v":1.0000000000000002},{"$f":"SUM(E15:E31)","v":1.0000000000000002}]
[]
["The section below includes all the calculations for the Castro model. Explanations can be found in Castro's appendix."]
[]
["Proportion child migrants",null,"Numbers of Migrants",null,"Sex Ratios",null,"Sex-specific migrant No.",null,"Sex-specific M Ratios",null,"K=",{"$f":"IF(B11=0,0,IF(B8<0,B11,1/B11))","v":0}]
["Wim",{"$f":"($B$38/($B$10*(1-$B$38)))/(1+($B$38/($B$10*(1-$B$38))))","v":0.18181818181818182},"ET",{"$f":"IF(B11<>0,IF(B8<0,B8/(L36-1),D38-B8),IF(B8>0,0,D38-B8))","v":0},"Sre",{"$f":"B9*(1-$B$40)/(1-$B$39)","v":1},"Ef",{"$f":"D37/(F37+1)","v":0},"Km",{"$f":"IF(B8<0,H40/H38,H38/H40)","v":0},"pmue",20]
["Wif",0.1,"IT",{"$f":"IF(B11<>0,IF(B8<0,B8+D37,B8/(1-1/L36)),IF(B8<0,0,B8/(1-L36)))","v":2000},"Sri",{"$f":"B10*(1-$B$38)/(1-$B$37)","v":0.55000000000000004},"Em",{"$f":"D37-H37","v":0},"Kf",{"$f":"IF(B8<0,H39/H37,H37/H39)","v":0},"plae",0.2]
["Wem",{"$f":"($B$40/($B$9*(1-$B$40)))/(1+($B$40/($B$9*(1-$B$40))))","v":0.1},null,null,null,null,"If",{"$f":"D38/(F38+1)","v":1290.3225806451612},"Nm",{"$f":"H40-H38","v":709.67741935483878},"pmui",25]
["Wef",0.1,null,null,null,null,"Im",{"$f":"D38-H39","v":709.67741935483878},"Nf",{"$f":"H39-H37","v":1290.3225806451612},"plai",0.2]
[]
["These are constants for the Castro model. They may be varied if desired."]
[null,"Net Emigration Country",null,null,null,"Net Immigration Country"]
[" ","Emigration",null,"Immigration",null,"Emigration",null,"Immigration"]
[null,"males","females","males","females","males","females","males","females"]
["Mean Child Migration Age",6,6,7,7,7,7,6,6]
["Mean Adult MigrationAge",32,31,35,33,35,33,32,31]
[]
[]
["Age",null,"MALES",null,null,"FEMALES",null,null,"MALES",null,null,"FEMALES"]
[null,"ae(x)","ce(x)","e(x)","ae(x)","ce(x)","e(x)","ai(x)","ci(x)","I(x)","ai(x)","ci(x)","I(x)"]
[2.5,0,{"$f":"IF($B$8<0,(1/$B$46)*EXP(-A52/$B$46),(1/$F$46)*EXP(-A52/$F$46))","v":9.9953219625018616E-2},{"$f":"($B$39*C52+(1-$B$39)*B52)*5/$D$69","v":5.5949848262754703E-2},0,{"$f":"IF($B$8<0,(1/$C$46)*EXP(-A52/$C$46),(1/$G$46)*EXP(-A52/$G$46))","v":9.9953219625018616E-2},{"$f":"($B$40*F52+(1-$B$40)*E52)*5/$G$69","v":5.6075620033075674E-2},0,{"$f":"IF($B$8<0,(1/$D$46)*EXP(-A52/$D$46),(1/$H$46)*EXP(-A52/$H$46))","v":0.10987343836674063},{"$f":"($B$37*I52+(1-$B$37)*H52)*5/$J$69","v":0.11119073137560535},0,{"$f":"IF($B$8<0,(1/$E$46)*EXP(-A52/$E$46),(1/$I$46)*EXP(-A52/$I$46))","v":0.10987343836674063},{"$f":"($B$38*L52+(1-$B$38)*K52)*5/$M$69","v":6.160539432946139E-2}]
[{"$f":"A52+5","v":7.5},0,4.893126501329223E-2,2.7389781570508646E-2,0,4.893126501329223E-2,2.7451352091676991E-2,0,4.7750799476698344E-2,4.8323292658429842E-2,0,4.7750799476698344E-2,2.677359400995603E-2]
[12.5,{"$f":"IF($B$8<0,(1/($B$47-$L$37))*EXP((-1*((A54-$L$37)/($B$47-$L$37)))-EXP(-$L$38*(A54-$L$37))),(1/($F$47-$L$39))*EXP((-1*((A54-$L$39)/($F$47-$L$39)))-EXP(-$L$40*(A54-$L$39))))","v":1.7868092802539951E-6},2.3953892678828151E-2,1.3417440789671196E-2,{"$f":"IF($B$8<0,(1/($C$47-$L$37))*EXP((-1*((A54-$L$37)/($C$47-$L$37)))-EXP(-$L$38*(A54-$L$37))),(1/($G$47-$L$37))*EXP((-1*((A54-$L$37)/($G$47-$L$37)))-EXP(-$L$38*(A54-$L$37))))","v":1.5496667814431579E-3},2.3953892678828151E-2,2.1263108108684071E-2,{"$f":"IF($B$8<0,(1/($D$47-$L$39))*EXP((-1*((A54-$L$39)/($D$47-$L$39)))-EXP(-$L$40*(A54-$L$39))),(1/($H$47-$L$37))*EXP((-1*((A54-$L$37)/($H$47-$L$37)))-EXP(-$L$40*(A54-$L$37))))","v":1.761489149293679E-3},2.0752411907353826E-2,2.9022952279269758E-2,{"$f":"IF($B$8<0,(1/($E$47-$L$39))*EXP((-1*((A54-$L$39)/($E$47-$L$39)))-EXP(-$L$40*(A54-$L$39))),(1/($I$47-$L$37))*EXP((-1*((A54-$L$37)/($I$47-$L$37)))-EXP(-$L$40*(A54-$L$37))))","v":2.0339691241906539E-3},2.0752411907353826E-2,2.1899667327747355E-2]
[17.5,2.3952344455393589E-3,1.1726428374842685E-2,1.8630804783053203E-2,1.7928512866990032E-2,1.1726428374842685E-2,9.7102815255891442E-2,1.9736321948105144E-2,9.0189610371369348E-3,9.900534069018635E-2,2.1942194283250647E-2,9.0189610371369348E-3,0.11578261881759325]
[22.5,2.4691249640196391E-2,5.7405752072962318E-3,0.12760398711236454,3.4603940729701764E-2,5.7405752072962318E-3,0.17794167380373438,3.6891627790177794E-2,3.9196243093348512E-3,0.17196929498941826,3.9490361094255889E-2,3.9196243093348512E-3,0.20147584108663852]
[27.5,4.2463272518319647E-2,2.8102507137912985E-3,0.21549636989267498,3.4561926445827576E-2,2.8102507137912985E-3,0.17608556995101393,3.5684573089433853E-2,1.7034617028577207E-3,0.16422969403454143,3.6778434861909674E-2,1.7034617028577207E-3,0.18654820106666797]
[32.5,3.7789830265774781E-2,1.3757347982005037E-3,0.19114931613103345,2.7090482348821051E-2,1.3757347982005037E-3,0.13755620464991802,2.7088166280544862E-2,7.4032140432238173E-4,0.12410738821601699,2.6880775648140495E-2,7.4032140432238173E-4,0.13606213719564877]
[37.5,2.639264010449572E-2,6.7347949622132504E-4,0.13333896604353074,1.9422937090839181E-2,6.7347949622132504E-4,9.8447503535516179E-2,1.8808669599302275E-2,3.2174235603795153E-4,8.597936579192729E-2,1.7970895486403633E-2,3.2174235603795153E-4,9.0865983072568129E-2]
[42.5,1.6860486417882733E-2,3.2969627025776813E-4,8.5125035478246736E-2,1.3476234062213698E-2,3.2969627025776813E-4,6.8228733152440574E-2,1.2638397904905773E-2,1.398286515349403E-4,5.7696154078228361E-2,1.1626610321864076E-2,1.398286515349403E-4,5.874915282082524E-2]
[47.5,1.0423482457363228E-2,1.6140005929172552E-4,5.2602214168612542E-2,9.2380842757863822E-3,1.6140005929172552E-4,4.6735186310813581E-2,8.3904586989555479E-3,6.0769281455045536E-5,3.8271238438230062E-2,7.4318382311539394E-3,6.0769281455045536E-5,3.7536967080140628E-2]
[52.5,6.3667135774909608E-3,7.9012052878261945E-5,3.2118731660178118E-2,6.3047447340697366E-3,7.9012052878261945E-5,3.1878041476082211E-2,5.5456390196924584E-3,2.6410220852625209E-5,2.5281297067921583E-2,4.7294603848062108E-3,2.6410220852625209E-5,2.3880835066395729E-2]
[57.5,3.8715956967279638E-3,3.8679691491026108E-5,1.9526142890561062E-2,4.2957985022568845E-3,3.8679691491026108E-5,2.171190759822967E-2,3.6593866259261908E-3,1.1477834668827187E-5,1.6676284050275672E-2,3.0048150321232256E-3,1.1477834668827187E-5,1.5169475496315671E-2]
[62.5,2.3504742154758489E-3,1.8935320363667863E-5,1.1851919468506601E-2,2.9252258281854487E-3,1.8935320363667863E-5,1.4780579193374227E-2,2.4132599122320573E-3,4.9882463846127348E-6,1.0994916247308166E-2,1.9079324601940062E-3,4.9882463846127348E-6,9.630696032572033E-3]
[67.5,1.4261331883835774E-3,9.2696281550725406E-6,7.1898239638266397E-3,1.9914936116864979E-3,9.2696281550725406E-6,1.0060585897321474E-2,1.5911236170304782E-3,2.1678829423446033E-6,7.2480933919761769E-3,1.2111899864102845E-3,2.1678829423446033E-6,6.113179798086202E-3]
[72.5,8.6510476321392858E-4,4.5378691505100649E-6,4.3608021514912445E-3,1.3556985365314593E-3,4.5378691505100649E-6,6.8476952570353999E-3,1.0489829678721001E-3,9.4215804299601768E-7,4.7779708393372545E-3,7.6882277091177946E-4,9.4215804299601768E-7,3.8801981452344938E-3]
[77.5,5.2473739031462345E-4,2.2214759947930001E-6,2.6447881171776954E-3,9.2285686564094055E-4,2.2214759947930001E-6,4.6609054803328836E-3,6.9154422996965778E-4,4.094601976166045E-7,3.1496731376859837E-3,4.8800830678055653E-4,4.094601976166045E-7,2.4628402146762113E-3]
[82.5,3.1827485548056004E-4,1.0875050451568976E-6,1.6040275158081914E-3,6.2820413297450905E-4,1.0875050451568976E-6,3.172518204859317E-3,4.5589697327644036E-4,1.7795066833913044E-7,2.0763127136413815E-3,3.0975862857357517E-4,1.7795066833913044E-7,1.5632184394726314E-3]
[null,{"$f":"SUM(B52:B68)","v":0.17674101634593956},{"$f":"SUM(C52:C68)","v":0.19580968578011898},{"$f":"($B$39*C69+(1-$B$39)*B69)*5","v":0.89323941644678739},{"$f":"SUM(E52:E68)","v":0.17629580681296833},{"$f":"SUM(F52:F68)","v":0.19580968578011898},{"$f":"($B$40*F69+(1-$B$40)*E69)*5","v":0.89123597354841699},{"$f":"SUM(H52:H68)","v":0.17640553780671833},{"$f":"SUM(I52:I68)","v":0.19432793224723},{"$f":"($B$37*I69+(1-$B$37)*H69)*5","v":0.89832077488860218},{"$f":"SUM(K52:K68)","v":0.17657506662096861},{"$f":"SUM(L52:L68)","v":0.19432793224723},{"$f":"($B$38*L69+(1-$B$38)*K69)*5","v":0.89175176591797367}]

{"sheet":"Em_Family","index":6,"n_rows":69,"n_cols":13,"rows_kept":69,"cut":false,"hidden":true,"merged":[[49,0,50,0]]}
["Castro's model as a template"]
[]
[]
[]
[]
[]
["Input Parameters"]
["Number of net migrants",2000]
["SRAe",1]
["SRAi",1]
["Immigrant-Emigrant Ratio",0]
[]
[null,"Migration Numbers",null,"Distribution"]
["Age","Male","Female","Male","Female"]
[2.5,{"$f":"IF($B$8<0,$J$39*($J$37*J52-D52)/($J$37-1),$J$39*(J52-$J$37*D52)/(1-$J$37))","v":61.65814190382455},{"$f":"IF($B$8<0,$J$40*($J$38*M52-G52)/($J$38-1),$J$40*(M52-$J$38*G52)/(1-$J$38))","v":61.60539432946139},{"$f":"B15/ABS($B$32)","v":6.165814190382455E-2},{"$f":"C15/ABS($C$32)","v":6.1605394329461362E-2}]
[{"$f":"A15+5","v":7.5},26.796518011277353,26.773594009956032,2.6796518011277352E-2,2.677359400995602E-2]
[12.5,20.542239536177419,21.899667327747355,2.0542239536177419E-2,2.1899667327747344E-2]
[17.5,104.74084550865365,115.78261881759325,0.10474084550865365,0.11578261881759319]
[22.5,188.5232686983386,201.47584108663852,0.1885232686983386,0.20147584108663844]
[27.5,181.18330345580574,186.54820106666799,0.18118330345580574,0.18654820106666789]
[32.5,137.22607638652249,136.06213719564877,0.13722607638652248,0.13606213719564872]
[37.5,95.175019220968466,90.865983072568127,9.5175019220968465E-2,9.0865983072568088E-2]
[42.5,63.909556871420023,58.749152820825238,6.3909556871420026E-2,5.8749152820825212E-2]
[47.5,42.41068476724147,37.536967080140627,4.2410684767241469E-2,3.7536967080140607E-2]
[52.5,28.023447973658225,23.880835066395729,2.8023447973658223E-2,2.3880835066395718E-2]
[57.5,18.488422233034495,15.169475496315671,1.8488422233034495E-2,1.5169475496315664E-2]
[62.5,12.19113267945059,9.6306960325720325,1.219113267945059E-2,9.6306960325720278E-3]
[67.5,8.0372946605622175,6.1131797980862022,8.0372946605622182E-3,6.1131797980861994E-3]
[72.5,5.2984885751997375,3.8801981452344938,5.2984885751997373E-3,3.880198145234492E-3]
[77.5,3.4929209701450747,2.4628402146762114,3.4929209701450746E-3,2.4628402146762104E-3]
[82.5,2.3026385477199236,1.5632184394726314,2.3026385477199237E-3,1.5632184394726307E-3]
[null,{"$f":"SUM(B15:B31)","v":1000},{"$f":"SUM(C15:C31)","v":1000.0000000000005},{"$f":"SUM(D15:D31)","v":1},{"$f":"SUM(E15:E31)","v":0.99999999999999978}]
[]
["The section below includes all the calculations for the Castro model. Explanations can be found in Castro's appendix."]
[]
["Proportion child migrants",null,"Numbers of Migrants",null,"Sex Ratios",null,"Sex-specific migrant No.",null,"Sex-specific M Ratios",null,"K=",{"$f":"IF(B11=0,0,IF(B8<0,B11,1/B11))","v":0}]
["Wim",{"$f":"($B$38/($B$10*(1-$B$38)))/(1+($B$38/($B$10*(1-$B$38))))","v":0.1},"ET",{"$f":"IF(B11<>0,IF(B8<0,B8/(L36-1),D38-B8),IF(B8>0,0,D38-B8))","v":0},"Sre",{"$f":"B9*(1-$B$40)/(1-$B$39)","v":1},"Ef",{"$f":"D37/(F37+1)","v":0},"Km",{"$f":"IF(B8<0,H40/H38,H38/H40)","v":0},"pmue",20]
["Wif",0.1,"IT",{"$f":"IF(B11<>0,IF(B8<0,B8+D37,B8/(1-1/L36)),IF(B8<0,0,B8/(1-L36)))","v":2000},"Sri",{"$f":"B10*(1-$B$38)/(1-$B$37)","v":1},"Em",{"$f":"D37-H37","v":0},"Kf",{"$f":"IF(B8<0,H39/H37,H37/H39)","v":0},"plae",0.2]
["Wem",{"$f":"($B$40/($B$9*(1-$B$40)))/(1+($B$40/($B$9*(1-$B$40))))","v":0.1},null,null,null,null,"If",{"$f":"D38/(F38+1)","v":1000},"Nm",{"$f":"H40-H38","v":1000},"pmui",25]
["Wef",0.1,null,null,null,null,"Im",{"$f":"D38-H39","v":1000},"Nf",{"$f":"H39-H37","v":1000},"plai",0.2]
[]
["These are constants for the Castro model. They may be varied if desired."]
[null,"Net Emigration Country",null,null,null,"Net Immigration Country"]
[" ","Emigration",null,"Immigration",null,"Emigration",null,"Immigration"]
[null,"males","females","males","females","males","females","males","females"]
["Mean Child Migration Age",6,6,7,7,7,7,6,6]
["Mean Adult MigrationAge",32,31,35,33,35,33,32,31]
[]
[]
["Age",null,"MALES",null,null,"FEMALES",null,null,"MALES",null,null,"FEMALES"]
[null,"ae(x)","ce(x)","e(x)","ae(x)","ce(x)","e(x)","ai(x)","ci(x)","I(x)","ai(x)","ci(x)","I(x)"]
[2.5,0,{"$f":"IF($B$8<0,(1/$B$46)*EXP(-A52/$B$46),(1/$F$46)*EXP(-A52/$F$46))","v":9.9953219625018616E-2},{"$f":"($B$39*C52+(1-$B$39)*B52)*5/$D$69","v":5.5949848262754703E-2},0,{"$f":"IF($B$8<0,(1/$C$46)*EXP(-A52/$C$46),(1/$G$46)*EXP(-A52/$G$46))","v":9.9953219625018616E-2},{"$f":"($B$40*F52+(1-$B$40)*E52)*5/$G$69","v":5.6075620033075674E-2},0,{"$f":"IF($B$8<0,(1/$D$46)*EXP(-A52/$D$46),(1/$H$46)*EXP(-A52/$H$46))","v":0.10987343836674063},{"$f":"($B$37*I52+(1-$B$37)*H52)*5/$J$69","v":6.165814190382455E-2},0,{"$f":"IF($B$8<0,(1/$E$46)*EXP(-A52/$E$46),(1/$I$46)*EXP(-A52/$I$46))","v":0.10987343836674063},{"$f":"($B$38*L52+(1-$B$38)*K52)*5/$M$69","v":6.160539432946139E-2}]
[{"$f":"A52+5","v":7.5},0,4.893126501329223E-2,2.7389781570508646E-2,0,4.893126501329223E-2,2.7451352091676991E-2,0,4.7750799476698344E-2,2.6796518011277352E-2,0,4.7750799476698344E-2,2.677359400995603E-2]
[12.5,{"$f":"IF($B$8<0,(1/($B$47-$L$37))*EXP((-1*((A54-$L$37)/($B$47-$L$37)))-EXP(-$L$38*(A54-$L$37))),(1/($F$47-$L$39))*EXP((-1*((A54-$L$39)/($F$47-$L$39)))-EXP(-$L$40*(A54-$L$39))))","v":1.7868092802539951E-6},2.3953892678828151E-2,1.3417440789671196E-2,{"$f":"IF($B$8<0,(1/($C$47-$L$37))*EXP((-1*((A54-$L$37)/($C$47-$L$37)))-EXP(-$L$38*(A54-$L$37))),(1/($G$47-$L$37))*EXP((-1*((A54-$L$37)/($G$47-$L$37)))-EXP(-$L$38*(A54-$L$37))))","v":1.5496667814431579E-3},2.3953892678828151E-2,2.1263108108684071E-2,{"$f":"IF($B$8<0,(1/($D$47-$L$39))*EXP((-1*((A54-$L$39)/($D$47-$L$39)))-EXP(-$L$40*(A54-$L$39))),(1/($H$47-$L$37))*EXP((-1*((A54-$L$37)/($H$47-$L$37)))-EXP(-$L$40*(A54-$L$37))))","v":1.761489149293679E-3},2.0752411907353826E-2,2.0542239536177419E-2,{"$f":"IF($B$8<0,(1/($E$47-$L$39))*EXP((-1*((A54-$L$39)/($E$47-$L$39)))-EXP(-$L$40*(A54-$L$39))),(1/($I$47-$L$37))*EXP((-1*((A54-$L$37)/($I$47-$L$37)))-EXP(-$L$40*(A54-$L$37))))","v":2.0339691241906539E-3},2.0752411907353826E-2,2.1899667327747355E-2]
[17.5,2.3952344455393589E-3,1.1726428374842685E-2,1.8630804783053203E-2,1.7928512866990032E-2,1.1726428374842685E-2,9.7102815255891442E-2,1.9736321948105144E-2,9.0189610371369348E-3,0.10474084550865365,2.1942194283250647E-2,9.0189610371369348E-3,0.11578261881759325]
[22.5,2.4691249640196391E-2,5.7405752072962318E-3,0.12760398711236454,3.4603940729701764E-2,5.7405752072962318E-3,0.17794167380373438,3.6891627790177794E-2,3.9196243093348512E-3,0.1885232686983386,3.9490361094255889E-2,3.9196243093348512E-3,0.20147584108663852]
[27.5,4.2463272518319647E-2,2.8102507137912985E-3,0.21549636989267498,3.4561926445827576E-2,2.8102507137912985E-3,0.17608556995101393,3.5684573089433853E-2,1.7034617028577207E-3,0.18118330345580574,3.6778434861909674E-2,1.7034617028577207E-3,0.18654820106666797]
[32.5,3.7789830265774781E-2,1.3757347982005037E-3,0.19114931613103345,2.7090482348821051E-2,1.3757347982005037E-3,0.13755620464991802,2.7088166280544862E-2,7.4032140432238173E-4,0.13722607638652248,2.6880775648140495E-2,7.4032140432238173E-4,0.13606213719564877]
[37.5,2.639264010449572E-2,6.7347949622132504E-4,0.13333896604353074,1.9422937090839181E-2,6.7347949622132504E-4,9.8447503535516179E-2,1.8808669599302275E-2,3.2174235603795153E-4,9.5175019220968465E-2,1.7970895486403633E-2,3.2174235603795153E-4,9.0865983072568129E-2]
[42.5,1.6860486417882733E-2,3.2969627025776813E-4,8.5125035478246736E-2,1.3476234062213698E-2,3.2969627025776813E-4,6.8228733152440574E-2,1.2638397904905773E-2,1.398286515349403E-4,6.3909556871420026E-2,1.1626610321864076E-2,1.398286515349403E-4,5.874915282082524E-2]
[47.5,1.0423482457363228E-2,1.6140005929172552E-4,5.2602214168612542E-2,9.2380842757863822E-3,1.6140005929172552E-4,4.6735186310813581E-2,8.3904586989555479E-3,6.0769281455045536E-5,4.2410684767241469E-2,7.4318382311539394E-3,6.0769281455045536E-5,3.7536967080140628E-2]
[52.5,6.3667135774909608E-3,7.9012052878261945E-5,3.2118731660178118E-2,6.3047447340697366E-3,7.9012052878261945E-5,3.1878041476082211E-2,5.5456390196924584E-3,2.6410220852625209E-5,2.8023447973658223E-2,4.7294603848062108E-3,2.6410220852625209E-5,2.3880835066395729E-2]
[57.5,3.8715956967279638E-3,3.8679691491026108E-5,1.9526142890561062E-2,4.2957985022568845E-3,3.8679691491026108E-5,2.171190759822967E-2,3.6593866259261908E-3,1.1477834668827187E-5,1.8488422233034495E-2,3.0048150321232256E-3,1.1477834668827187E-5,1.5169475496315671E-2]
[62.5,2.3504742154758489E-3,1.8935320363667863E-5,1.1851919468506601E-2,2.9252258281854487E-3,1.8935320363667863E-5,1.4780579193374227E-2,2.4132599122320573E-3,4.9882463846127348E-6,1.219113267945059E-2,1.9079324601940062E-3,4.9882463846127348E-6,9.630696032572033E-3]
[67.5,1.4261331883835774E-3,9.2696281550725406E-6,7.1898239638266397E-3,1.9914936116864979E-3,9.2696281550725406E-6,1.0060585897321474E-2,1.5911236170304782E-3,2.1678829423446033E-6,8.0372946605622182E-3,1.2111899864102845E-3,2.1678829423446033E-6,6.113179798086202E-3]
[72.5,8.6510476321392858E-4,4.5378691505100649E-6,4.3608021514912445E-3,1.3556985365314593E-3,4.5378691505100649E-6,6.8476952570353999E-3,1.0489829678721001E-3,9.4215804299601768E-7,5.2984885751997373E-3,7.6882277091177946E-4,9.4215804299601768E-7,3.8801981452344938E-3]
[77.5,5.2473739031462345E-4,2.2214759947930001E-6,2.6447881171776954E-3,9.2285686564094055E-4,2.2214759947930001E-6,4.6609054803328836E-3,6.9154422996965778E-4,4.094601976166045E-7,3.4929209701450746E-3,4.8800830678055653E-4,4.094601976166045E-7,2.4628402146762113E-3]
[82.5,3.1827485548056004E-4,1.0875050451568976E-6,1.6040275158081914E-3,6.2820413297450905E-4,1.0875050451568976E-6,3.172518204859317E-3,4.5589697327644036E-4,1.7795066833913044E-7,2.3026385477199237E-3,3.0975862857357517E-4,1.7795066833913044E-7,1.5632184394726314E-3]
[null,{"$f":"SUM(B52:B68)","v":0.17674101634593956},{"$f":"SUM(C52:C68)","v":0.19580968578011898},{"$f":"($B$39*C69+(1-$B$39)*B69)*5","v":0.89323941644678739},{"$f":"SUM(E52:E68)","v":0.17629580681296833},{"$f":"SUM(F52:F68)","v":0.19580968578011898},{"$f":"($B$40*F69+(1-$B$40)*E69)*5","v":0.89123597354841699},{"$f":"SUM(H52:H68)","v":0.17640553780671833},{"$f":"SUM(I52:I68)","v":0.19432793224723},{"$f":"($B$37*I69+(1-$B$37)*H69)*5","v":0.89098888625384742},{"$f":"SUM(K52:K68)","v":0.17657506662096861},{"$f":"SUM(L52:L68)","v":0.19432793224723},{"$f":"($B$38*L69+(1-$B$38)*K69)*5","v":0.89175176591797367}]

{"sheet":"Em_MLabor","index":7,"n_rows":69,"n_cols":13,"rows_kept":69,"cut":false,"hidden":true,"merged":[[49,0,50,0]]}
["Castro's model as a template"]
[]
[]
[]
[]
[]
["Input Parameters"]
["Number of net migrants",-2000]
["SRAe",2]
["SRAi",1]
["Immigrant-Emigrant Ratio",0]
[]
[null,"Migration Numbers",null,"Distribution"]
["Age","Male","Female","Male","Female"]
[2.5,{"$f":"IF($B$8<0,$J$39*($J$37*J52-D52)/($J$37-1),$J$39*(J52-$J$37*D52)/(1-$J$37))","v":-42.72641021442039},{"$f":"IF($B$8<0,$J$40*($J$38*M52-G52)/($J$38-1),$J$40*(M52-$J$38*G52)/(1-$J$38))","v":-42.486478847904401},{"$f":"B15/ABS($B$32)","v":-3.2606997268899769E-2},{"$f":"C15/ABS($C$32)","v":-6.1605394329461376E-2}]
[{"$f":"A15+5","v":7.5},-18.568821335125623,-18.464547593073121,-1.4170942597859027E-2,-2.6773594009956023E-2]
[12.5,-20.399780338795729,-15.103218846722312,-1.556825341644937E-2,-2.1899667327747351E-2]
[17.5,-141.65450211219462,-79.850081943167751,-0.108104751611938,-0.11578261881759323]
[22.5,-259.75262724372448,-138.94885592181964,-0.19823226815968445,-0.20147584108663846]
[27.5,-250.44187165850545,-128.65393177011583,-0.19112669152885942,-0.18654820106666795]
[32.5,-189.89551493447405,-93.835956686654313,-0.14492026139736178,-0.13606213719564875]
[37.5,-131.77918069269677,-62.666195222460772,-0.10056832210758437,-9.0865983072568116E-2]
[42.5,-88.518710627286978,-40.516657117810503,-6.7553752847140061E-2,-5.8749152820825226E-2]
[47.5,-58.753888053976482,-25.887563503545259,-4.4838493514876787E-2,-3.7536967080140621E-2]
[52.5,-38.827790730520732,-16.469541425100502,-2.9631735031186872E-2,-2.3880835066395725E-2]
[57.5,-25.618881346933915,-10.461707238838393,-1.9551251554239039E-2,-1.5169475496315669E-2]
[62.5,-16.893909490830445,-6.6418593328082975,-1.2892720400896918E-2,-9.6306960325720312E-3]
[67.5,-11.138148132825492,-4.2159860676456562,-8.5001656803141909E-3,-6.1131797980862011E-3]
[72.5,-7.342877821084322,-2.6759987208513749,-5.6037751792485614E-3,-3.8801981452344933E-3]
[77.5,-4.8407253544652207,-1.6985104928801456,-3.6942377705129312E-3,-2.4628402146762108E-3]
[82.5,-3.1911874983461277,-1.078081682394918,-2.4353799329483606E-3,-1.5632184394726309E-3]
[null,{"$f":"SUM(B15:B31)","v":-1310.344827586207},{"$f":"SUM(C15:C31)","v":-689.65517241379314},{"$f":"SUM(D15:D31)","v":-1},{"$f":"SUM(E15:E31)","v":-1.0000000000000002}]
[]
["The section below includes all the calculations for the Castro model. Explanations can be found in Castro's appendix."]
[]
["Proportion child migrants",null,"Numbers of Migrants",null,"Sex Ratios",null,"Sex-specific migrant No.",null,"Sex-specific M Ratios",null,"K=",{"$f":"IF(B11=0,0,IF(B8<0,B11,1/B11))","v":0}]
["Wim",{"$f":"($B$38/($B$10*(1-$B$38)))/(1+($B$38/($B$10*(1-$B$38))))","v":0.1},"ET",{"$f":"IF(B11<>0,IF(B8<0,B8/(L36-1),D38-B8),IF(B8>0,0,D38-B8))","v":2000},"Sre",{"$f":"B9*(1-$B$40)/(1-$B$39)","v":1.9000000000000001},"Ef",{"$f":"D37/(F37+1)","v":689.65517241379303},"Km",{"$f":"IF(B8<0,H40/H38,H38/H40)","v":0},"pmue",20]
["Wif",0.1,"IT",{"$f":"IF(B11<>0,IF(B8<0,B8+D37,B8/(1-1/L36)),IF(B8<0,0,B8/(1-L36)))","v":0},"Sri",{"$f":"B10*(1-$B$38)/(1-$B$37)","v":1},"Em",{"$f":"D37-H37","v":1310.344827586207},"Kf",{"$f":"IF(B8<0,H39/H37,H37/H39)","v":0},"plae",0.2]
["Wem",{"$f":"($B$40/($B$9*(1-$B$40)))/(1+($B$40/($B$9*(1-$B$40))))","v":5.2631578947368425E-2},null,null,null,null,"If",{"$f":"D38/(F38+1)","v":0},"Nm",{"$f":"H40-H38","v":-1310.344827586207},"pmui",25]
["Wef",0.1,null,null,null,null,"Im",{"$f":"D38-H39","v":0},"Nf",{"$f":"H39-H37","v":-689.65517241379303},"plai",0.2]
[]
["These are constants for the Castro model. They may be varied if desired."]
[null,"Net Emigration Country",null,null,null,"Net Immigration Country"]
[" ","Emigration",null,"Immigration",null,"Emigration",null,"Immigration"]
[null,"males","females","males","females","males","females","males","females"]
["Mean Child Migration Age",6,6,7,7,7,7,6,6]
["Mean Adult MigrationAge",32,31,35,33,35,33,32,31]
[]
[]
["Age",null,"MALES",null,null,"FEMALES",null,null,"MALES",null,null,"FEMALES"]
[null,"ae(x)","ce(x)","e(x)","ae(x)","ce(x)","e(x)","ai(x)","ci(x)","I(x)","ai(x)","ci(x)","I(x)"]
[2.5,0,{"$f":"IF($B$8<0,(1/$B$46)*EXP(-A52/$B$46),(1/$F$46)*EXP(-A52/$F$46))","v":0.10987343836674063},{"$f":"($B$39*C52+(1-$B$39)*B52)*5/$D$69","v":3.2606997268899769E-2},0,{"$f":"IF($B$8<0,(1/$C$46)*EXP(-A52/$C$46),(1/$G$46)*EXP(-A52/$G$46))","v":0.10987343836674063},{"$f":"($B$40*F52+(1-$B$40)*E52)*5/$G$69","v":6.160539432946139E-2},0,{"$f":"IF($B$8<0,(1/$D$46)*EXP(-A52/$D$46),(1/$H$46)*EXP(-A52/$H$46))","v":9.9953219625018616E-2},{"$f":"($B$37*I52+(1-$B$37)*H52)*5/$J$69","v":5.5949848262754703E-2},0,{"$f":"IF($B$8<0,(1/$E$46)*EXP(-A52/$E$46),(1/$I$46)*EXP(-A52/$I$46))","v":9.9953219625018616E-2},{"$f":"($B$38*L52+(1-$B$38)*K52)*5/$M$69","v":5.5271245010220738E-2}]
[{"$f":"A52+5","v":7.5},0,4.7750799476698344E-2,1.4170942597859029E-2,0,4.7750799476698344E-2,2.677359400995603E-2,0,4.893126501329223E-2,2.7389781570508646E-2,0,4.893126501329223E-2,2.7057577008082423E-2]
[12.5,{"$f":"IF($B$8<0,(1/($B$47-$L$37))*EXP((-1*((A54-$L$37)/($B$47-$L$37)))-EXP(-$L$38*(A54-$L$37))),(1/($F$47-$L$39))*EXP((-1*((A54-$L$39)/($F$47-$L$39)))-EXP(-$L$40*(A54-$L$39))))","v":1.761489149293679E-3},2.0752411907353826E-2,1.556825341644937E-2,{"$f":"IF($B$8<0,(1/($C$47-$L$37))*EXP((-1*((A54-$L$37)/($C$47-$L$37)))-EXP(-$L$38*(A54-$L$37))),(1/($G$47-$L$37))*EXP((-1*((A54-$L$37)/($G$47-$L$37)))-EXP(-$L$38*(A54-$L$37))))","v":2.0339691241906539E-3},2.0752411907353826E-2,2.1899667327747355E-2,{"$f":"IF($B$8<0,(1/($D$47-$L$39))*EXP((-1*((A54-$L$39)/($D$47-$L$39)))-EXP(-$L$40*(A54-$L$39))),(1/($H$47-$L$37))*EXP((-1*((A54-$L$37)/($H$47-$L$37)))-EXP(-$L$40*(A54-$L$37))))","v":1.7868092802539951E-6},2.3953892678828151E-2,1.3417440789671196E-2,{"$f":"IF($B$8<0,(1/($E$47-$L$39))*EXP((-1*((A54-$L$39)/($E$47-$L$39)))-EXP(-$L$40*(A54-$L$39))),(1/($I$47-$L$37))*EXP((-1*((A54-$L$37)/($I$47-$L$37)))-EXP(-$L$40*(A54-$L$37))))","v":3.0528483973657543E-6},2.3953892678828151E-2,1.3261004385435728E-2]
[17.5,1.9736321948105144E-2,9.0189610371369348E-3,0.108104751611938,2.1942194283250647E-2,9.0189610371369348E-3,0.11578261881759325,2.3952344455393589E-3,1.1726428374842685E-2,1.8630804783053203E-2,3.6115053033308315E-3,1.1726428374842685E-2,2.4457899958170246E-2]
[22.5,3.6891627790177794E-2,3.9196243093348512E-3,0.19823226815968445,3.9490361094255889E-2,3.9196243093348512E-3,0.20147584108663852,2.4691249640196391E-2,5.7405752072962318E-3,0.12760398711236454,3.2854623032183311E-2,5.7405752072962318E-3,0.16668329519806771]
[27.5,3.5684573089433853E-2,1.7034617028577207E-3,0.19112669152885942,3.6778434861909674E-2,1.7034617028577207E-3,0.18654820106666797,4.2463272518319647E-2,2.8102507137912985E-3,0.21549636989267498,4.9863191116897444E-2,2.8102507137912985E-3,0.24971013468400782]
[32.5,2.7088166280544862E-2,7.4032140432238173E-4,0.14492026139736178,2.6880775648140495E-2,7.4032140432238173E-4,0.13606213719564877,3.7789830265774781E-2,1.3757347982005037E-3,0.19114931613103345,3.9161087076777831E-2,1.3757347982005037E-3,0.19565529751469851]
[37.5,1.8808669599302275E-2,3.2174235603795153E-4,0.10056832210758437,1.7970895486403633E-2,3.2174235603795153E-4,9.0865983072568129E-2,2.639264010449572E-2,6.7347949622132504E-4,0.13333896604353074,2.4136584987016246E-2,6.7347949622132504E-4,0.12049392724090832]
[42.5,1.2638397904905773E-2,1.398286515349403E-4,6.7553752847140061E-2,1.1626610321864076E-2,1.398286515349403E-4,5.874915282082524E-2,1.6860486417882733E-2,3.2969627025776813E-4,8.5125035478246736E-2,1.3607435263204341E-2,3.2969627025776813E-4,6.7902982458536987E-2]
[47.5,8.3904586989555479E-3,6.0769281455045536E-5,4.4838493514876787E-2,7.4318382311539394E-3,6.0769281455045536E-5,3.7536967080140628E-2,1.0423482457363228E-2,1.6140005929172552E-4,5.2602214168612542E-2,7.4239015976120528E-3,1.6140005929172552E-4,3.7036079010862095E-2]
[52.5,5.5456390196924584E-3,2.6410220852625209E-5,2.9631735031186872E-2,4.7294603848062108E-3,2.6410220852625209E-5,2.3880835066395729E-2,6.3667135774909608E-3,7.9012052878261945E-5,3.2118731660178118E-2,4.0017307933234939E-3,7.9012052878261945E-5,1.9959265847586484E-2]
[57.5,3.6593866259261908E-3,1.1477834668827187E-5,1.9551251554239039E-2,3.0048150321232256E-3,1.1477834668827187E-5,1.5169475496315671E-2,3.8715956967279638E-3,3.8679691491026108E-5,1.9526142890561062E-2,2.1475127201806476E-3,3.8679691491026108E-5,1.070900161293481E-2]
[62.5,2.4132599122320573E-3,4.9882463846127348E-6,1.2892720400896918E-2,1.9079324601940062E-3,4.9882463846127348E-6,9.630696032572033E-3,2.3504742154758489E-3,1.8935320363667863E-5,1.1851919468506601E-2,1.1505736601738461E-3,1.8935320363667863E-5,5.7365768601176899E-3]
[67.5,1.5911236170304782E-3,2.1678829423446033E-6,8.5001656803141909E-3,1.2111899864102845E-3,2.1678829423446033E-6,6.113179798086202E-3,1.4261331883835774E-3,9.2696281550725406E-6,7.1898239638266397E-3,6.1607305231060081E-4,9.2696281550725406E-6,3.0711613553482801E-3]
[72.5,1.0489829678721001E-3,9.4215804299601768E-7,5.6037751792485614E-3,7.6882277091177946E-4,9.4215804299601768E-7,3.8801981452344938E-3,8.6510476321392858E-4,4.5378691505100649E-6,4.3608021514912445E-3,3.2980255738763661E-4,4.5378691505100649E-6,1.6438509523092973E-3]
[77.5,6.9154422996965778E-4,4.094601976166045E-7,3.6942377705129312E-3,4.8800830678055653E-4,4.094601976166045E-7,2.4628402146762113E-3,5.2473739031462345E-4,2.2214759947930001E-6,2.6447881171776954E-3,1.7653894080607691E-4,2.2214759947930001E-6,8.7981685366559726E-4]
[82.5,4.5589697327644036E-4,1.7795066833913044E-7,2.4353799329483606E-3,3.0975862857357517E-4,1.7795066833913044E-7,1.5632184394726314E-3,3.1827485548056004E-4,1.0875050451568976E-6,1.6040275158081914E-3,9.4496130464038984E-5,1.0875050451568976E-6,4.7088404904749054E-4]
[null,{"$f":"SUM(B52:B68)","v":0.17640553780671833},{"$f":"SUM(C52:C68)","v":0.19432793224723},{"$f":"($B$39*C69+(1-$B$39)*B69)*5","v":0.88674410862319997},{"$f":"SUM(E52:E68)","v":0.17657506662096861},{"$f":"SUM(F52:F68)","v":0.19432793224723},{"$f":"($B$40*F69+(1-$B$40)*E69)*5","v":0.89175176591797367},{"$f":"SUM(H52:H68)","v":0.17674101634593956},{"$f":"SUM(I52:I68)","v":0.19580968578011898},{"$f":"($B$37*I69+(1-$B$37)*H69)*5","v":0.89323941644678739},{"$f":"SUM(K52:K68)","v":0.17917810908006573},{"$f":"SUM(L52:L68)","v":0.19580968578011898},{"$f":"($B$38*L69+(1-$B$38)*K69)*5","v":0.90420633375035531}]

{"sheet":"Em_FLabor","index":8,"n_rows":69,"n_cols":13,"rows_kept":69,"cut":false,"hidden":true,"merged":[[49,0,50,0]]}
["Castro's model as a template"]
[]
[]
[]
[]
[]
["Input Parameters"]
["Number of net migrants",-2000]
["SRAe",0.5]
["SRAi",1]
["Immigrant-Emigrant Ratio",0]
[]
[null,"Migration Numbers",null,"Distribution"]
["Age","Male","Female","Male","Female"]
[2.5,{"$f":"IF($B$8<0,$J$39*($J$37*J52-D52)/($J$37-1),$J$39*(J52-$J$37*D52)/(1-$J$37))","v":-78.909551298816709},{"$f":"IF($B$8<0,$J$40*($J$38*M52-G52)/($J$38-1),$J$40*(M52-$J$38*G52)/(1-$J$38))","v":-79.490831392853408},{"$f":"B15/ABS($B$32)","v":-0.11119073137560537},{"$f":"C15/ABS($C$32)","v":-6.1605394329461376E-2}]
[{"$f":"A15+5","v":7.5},-34.293949628563119,-34.546572916072293,-4.8323292658429856E-2,-2.677359400995602E-2]
[12.5,-20.596933875610798,-28.25763526160949,-2.9022952279269761E-2,-2.1899667327747348E-2]
[17.5,-70.261854683358067,-149.39692750657193,-9.9005340690186378E-2,-0.11578261881759321]
[22.5,-122.04272547636135,-259.96882720856581,-0.17196929498941829,-0.20147584108663844]
[27.5,-116.55010544386812,-240.70735621505543,-0.16422969403454146,-0.18654820106666789]
[32.5,-88.076210992012065,-175.5640479943855,-0.12410738821601701,-0.13606213719564872]
[37.5,-61.017614432980665,-117.24642977105565,-8.5979365791927304E-2,-9.0865983072568102E-2]
[42.5,-40.945657732936262,-75.80535847848418,-5.7696154078228375E-2,-5.8749152820825219E-2]
[47.5,-27.160233730356822,-48.434796232439517,-3.8271238438230069E-2,-3.7536967080140614E-2]
[52.5,-17.941565661105642,-30.813980730833197,-2.528129706792159E-2,-2.3880835066395722E-2]
[57.5,-11.834782229227898,-19.573516769439575,-1.6676284050275676E-2,-1.5169475496315666E-2]
[62.5,-7.8028437884122477,-12.426704558157461,-1.0994916247308167E-2,-9.6306960325720295E-3]
[67.5,-5.1438082136605132,-7.8879739330144538,-7.2480933919761778E-3,-6.1131797980862003E-3]
[72.5,-3.3908180150135356,-5.0067072841735403,-4.7779708393372554E-3,-3.8801981452344925E-3]
[77.5,-2.2352519041642469,-3.177858341517692,-3.1496731376859845E-3,-2.4628402146762104E-3]
[82.5,-1.473512248390658,-2.0170560509324273,-2.076312713641382E-3,-1.5632184394726307E-3]
[null,{"$f":"SUM(B15:B31)","v":-709.67741935483866},{"$f":"SUM(C15:C31)","v":-1290.3225806451617},{"$f":"SUM(D15:D31)","v":-1.0000000000000002},{"$f":"SUM(E15:E31)","v":-1.0000000000000002}]
[]
["The section below includes all the calculations for the Castro model. Explanations can be found in Castro's appendix."]
[]
["Proportion child migrants",null,"Numbers of Migrants",null,"Sex Ratios",null,"Sex-specific migrant No.",null,"Sex-specific M Ratios",null,"K=",{"$f":"IF(B11=0,0,IF(B8<0,B11,1/B11))","v":0}]
["Wim",{"$f":"($B$38/($B$10*(1-$B$38)))/(1+($B$38/($B$10*(1-$B$38))))","v":0.1},"ET",{"$f":"IF(B11<>0,IF(B8<0,B8/(L36-1),D38-B8),IF(B8>0,0,D38-B8))","v":2000},"Sre",{"$f":"B9*(1-$B$40)/(1-$B$39)","v":0.55000000000000004},"Ef",{"$f":"D37/(F37+1)","v":1290.3225806451612},"Km",{"$f":"IF(B8<0,H40/H38,H38/H40)","v":0},"pmue",20]
["Wif",0.1,"IT",{"$f":"IF(B11<>0,IF(B8<0,B8+D37,B8/(1-1/L36)),IF(B8<0,0,B8/(1-L36)))","v":0},"Sri",{"$f":"B10*(1-$B$38)/(1-$B$37)","v":1},"Em",{"$f":"D37-H37","v":709.67741935483878},"Kf",{"$f":"IF(B8<0,H39/H37,H37/H39)","v":0},"plae",0.2]
["Wem",{"$f":"($B$40/($B$9*(1-$B$40)))/(1+($B$40/($B$9*(1-$B$40))))","v":0.18181818181818182},null,null,null,null,"If",{"$f":"D38/(F38+1)","v":0},"Nm",{"$f":"H40-H38","v":-709.67741935483878},"pmui",25]
["Wef",0.1,null,null,null,null,"Im",{"$f":"D38-H39","v":0},"Nf",{"$f":"H39-H37","v":-1290.3225806451612},"plai",0.2]
[]
["These are constants for the Castro model. They may be varied if desired."]
[null,"Net Emigration Country",null,null,null,"Net Immigration Country"]
[" ","Emigration",null,"Immigration",null,"Emigration",null,"Immigration"]
[null,"males","females","males","females","males","females","males","females"]
["Mean Child Migration Age",6,6,7,7,7,7,6,6]
["Mean Adult MigrationAge",32,31,35,33,35,33,32,31]
[]
[]
["Age",null,"MALES",null,null,"FEMALES",null,null,"MALES",null,null,"FEMALES"]
[null,"ae(x)","ce(x)","e(x)","ae(x)","ce(x)","e(x)","ai(x)","ci(x)","I(x)","ai(x)","ci(x)","I(x)"]
[2.5,0,{"$f":"IF($B$8<0,(1/$B$46)*EXP(-A52/$B$46),(1/$F$46)*EXP(-A52/$F$46))","v":0.10987343836674063},{"$f":"($B$39*C52+(1-$B$39)*B52)*5/$D$69","v":0.11119073137560535},0,{"$f":"IF($B$8<0,(1/$C$46)*EXP(-A52/$C$46),(1/$G$46)*EXP(-A52/$G$46))","v":0.10987343836674063},{"$f":"($B$40*F52+(1-$B$40)*E52)*5/$G$69","v":6.160539432946139E-2},0,{"$f":"IF($B$8<0,(1/$D$46)*EXP(-A52/$D$46),(1/$H$46)*EXP(-A52/$H$46))","v":9.9953219625018616E-2},{"$f":"($B$37*I52+(1-$B$37)*H52)*5/$J$69","v":5.5949848262754703E-2},0,{"$f":"IF($B$8<0,(1/$E$46)*EXP(-A52/$E$46),(1/$I$46)*EXP(-A52/$I$46))","v":9.9953219625018616E-2},{"$f":"($B$38*L52+(1-$B$38)*K52)*5/$M$69","v":5.5271245010220738E-2}]
[{"$f":"A52+5","v":7.5},0,4.7750799476698344E-2,4.8323292658429842E-2,0,4.7750799476698344E-2,2.677359400995603E-2,0,4.893126501329223E-2,2.7389781570508646E-2,0,4.893126501329223E-2,2.7057577008082423E-2]
[12.5,{"$f":"IF($B$8<0,(1/($B$47-$L$37))*EXP((-1*((A54-$L$37)/($B$47-$L$37)))-EXP(-$L$38*(A54-$L$37))),(1/($F$47-$L$39))*EXP((-1*((A54-$L$39)/($F$47-$L$39)))-EXP(-$L$40*(A54-$L$39))))","v":1.761489149293679E-3},2.0752411907353826E-2,2.9022952279269758E-2,{"$f":"IF($B$8<0,(1/($C$47-$L$37))*EXP((-1*((A54-$L$37)/($C$47-$L$37)))-EXP(-$L$38*(A54-$L$37))),(1/($G$47-$L$37))*EXP((-1*((A54-$L$37)/($G$47-$L$37)))-EXP(-$L$38*(A54-$L$37))))","v":2.0339691241906539E-3},2.0752411907353826E-2,2.1899667327747355E-2,{"$f":"IF($B$8<0,(1/($D$47-$L$39))*EXP((-1*((A54-$L$39)/($D$47-$L$39)))-EXP(-$L$40*(A54-$L$39))),(1/($H$47-$L$37))*EXP((-1*((A54-$L$37)/($H$47-$L$37)))-EXP(-$L$40*(A54-$L$37))))","v":1.7868092802539951E-6},2.3953892678828151E-2,1.3417440789671196E-2,{"$f":"IF($B$8<0,(1/($E$47-$L$39))*EXP((-1*((A54-$L$39)/($E$47-$L$39)))-EXP(-$L$40*(A54-$L$39))),(1/($I$47-$L$37))*EXP((-1*((A54-$L$37)/($I$47-$L$37)))-EXP(-$L$40*(A54-$L$37))))","v":3.0528483973657543E-6},2.3953892678828151E-2,1.3261004385435728E-2]
[17.5,1.9736321948105144E-2,9.0189610371369348E-3,9.900534069018635E-2,2.1942194283250647E-2,9.0189610371369348E-3,0.11578261881759325,2.3952344455393589E-3,1.1726428374842685E-2,1.8630804783053203E-2,3.6115053033308315E-3,1.1726428374842685E-2,2.4457899958170246E-2]
[22.5,3.6891627790177794E-2,3.9196243093348512E-3,0.17196929498941826,3.9490361094255889E-2,3.9196243093348512E-3,0.20147584108663852,2.4691249640196391E-2,5.7405752072962318E-3,0.12760398711236454,3.2854623032183311E-2,5.7405752072962318E-3,0.16668329519806771]
[27.5,3.5684573089433853E-2,1.7034617028577207E-3,0.16422969403454143,3.6778434861909674E-2,1.7034617028577207E-3,0.18654820106666797,4.2463272518319647E-2,2.8102507137912985E-3,0.21549636989267498,4.9863191116897444E-2,2.8102507137912985E-3,0.24971013468400782]
[32.5,2.7088166280544862E-2,7.4032140432238173E-4,0.12410738821601699,2.6880775648140495E-2,7.4032140432238173E-4,0.13606213719564877,3.7789830265774781E-2,1.3757347982005037E-3,0.19114931613103345,3.9161087076777831E-2,1.3757347982005037E-3,0.19565529751469851]
[37.5,1.8808669599302275E-2,3.2174235603795153E-4,8.597936579192729E-2,1.7970895486403633E-2,3.2174235603795153E-4,9.0865983072568129E-2,2.639264010449572E-2,6.7347949622132504E-4,0.13333896604353074,2.4136584987016246E-2,6.7347949622132504E-4,0.12049392724090832]
[42.5,1.2638397904905773E-2,1.398286515349403E-4,5.7696154078228361E-2,1.1626610321864076E-2,1.398286515349403E-4,5.874915282082524E-2,1.6860486417882733E-2,3.2969627025776813E-4,8.5125035478246736E-2,1.3607435263204341E-2,3.2969627025776813E-4,6.7902982458536987E-2]
[47.5,8.3904586989555479E-3,6.0769281455045536E-5,3.8271238438230062E-2,7.4318382311539394E-3,6.0769281455045536E-5,3.7536967080140628E-2,1.0423482457363228E-2,1.6140005929172552E-4,5.2602214168612542E-2,7.4239015976120528E-3,1.6140005929172552E-4,3.7036079010862095E-2]
[52.5,5.5456390196924584E-3,2.6410220852625209E-5,2.5281297067921583E-2,4.7294603848062108E-3,2.6410220852625209E-5,2.3880835066395729E-2,6.3667135774909608E-3,7.9012052878261945E-5,3.2118731660178118E-2,4.0017307933234939E-3,7.9012052878261945E-5,1.9959265847586484E-2]
[57.5,3.6593866259261908E-3,1.1477834668827187E-5,1.6676284050275672E-2,3.0048150321232256E-3,1.1477834668827187E-5,1.5169475496315671E-2,3.8715956967279638E-3,3.8679691491026108E-5,1.9526142890561062E-2,2.1475127201806476E-3,3.8679691491026108E-5,1.070900161293481E-2]
[62.5,2.4132599122320573E-3,4.9882463846127348E-6,1.0994916247308166E-2,1.9079324601940062E-3,4.9882463846127348E-6,9.630696032572033E-3,2.3504742154758489E-3,1.8935320363667863E-5,1.1851919468506601E-2,1.1505736601738461E-3,1.8935320363667863E-5,5.7365768601176899E-3]
[67.5,1.5911236170304782E-3,2.1678829423446033E-6,7.2480933919761769E-3,1.2111899864102845E-3,2.1678829423446033E-6,6.113179798086202E-3,1.4261331883835774E-3,9.2696281550725406E-6,7.1898239638266397E-3,6.1607305231060081E-4,9.2696281550725406E-6,3.0711613553482801E-3]
[72.5,1.0489829678721001E-3,9.4215804299601768E-7,4.7779708393372545E-3,7.6882277091177946E-4,9.4215804299601768E-7,3.8801981452344938E-3,8.6510476321392858E-4,4.5378691505100649E-6,4.3608021514912445E-3,3.2980255738763661E-4,4.5378691505100649E-6,1.6438509523092973E-3]
[77.5,6.9154422996965778E-4,4.094601976166045E-7,3.1496731376859837E-3,4.8800830678055653E-4,4.094601976166045E-7,2.4628402146762113E-3,5.2473739031462345E-4,2.2214759947930001E-6,2.6447881171776954E-3,1.7653894080607691E-4,2.2214759947930001E-6,8.7981685366559726E-4]
[82.5,4.5589697327644036E-4,1.7795066833913044E-7,2.0763127136413815E-3,3.0975862857357517E-4,1.7795066833913044E-7,1.5632184394726314E-3,3.1827485548056004E-4,1.0875050451568976E-6,1.6040275158081914E-3,9.4496130464038984E-5,1.0875050451568976E-6,4.7088404904749054E-4]
[null,{"$f":"SUM(B52:B68)","v":0.17640553780671833},{"$f":"SUM(C52:C68)","v":0.19432793224723},{"$f":"($B$39*C69+(1-$B$39)*B69)*5","v":0.89832077488860218},{"$f":"SUM(E52:E68)","v":0.17657506662096861},{"$f":"SUM(F52:F68)","v":0.19432793224723},{"$f":"($B$40*F69+(1-$B$40)*E69)*5","v":0.89175176591797367},{"$f":"SUM(H52:H68)","v":0.17674101634593956},{"$f":"SUM(I52:I68)","v":0.19580968578011898},{"$f":"($B$37*I69+(1-$B$37)*H69)*5","v":0.89323941644678739},{"$f":"SUM(K52:K68)","v":0.17917810908006573},{"$f":"SUM(L52:L68)","v":0.19580968578011898},{"$f":"($B$38*L69+(1-$B$38)*K69)*5","v":0.90420633375035531}]