{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Summary","Correlation matrix","Numerical derivation","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Summary","index":0,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Correlation of Geomag Reference Terms, Well to Well"]
[]
["The range of possible relationships"]
[null,"IGRF","Standard","HD #1","HD #2","IFR1 #1","IFR1 #2","IFR2 #1","IFR2 #2"]
["IGRF"]
["Standard"]
["HD #1"]
["HD #2"]
["IFR1 #1"]
["IFR1 #2"]
["IFR2 #1"]
["IFR2 #2"]
[]
[]
["ISCWSA MWD error model assumption (correlation coefficient 3 for Global terms)"]
[null,"IGRF","Standard","HD #1","HD #2","IFR1 #1","IFR1 #2","IFR2 #1","IFR2 #2"]
["IGRF",1,1,1,1,1,1,1,1]
["Standard",null,1,1,1,1,1,1,1]
["HD #1",null,null,1,1,1,1,1,1]
["HD #2",null,null,null,1,1,1,1,1]
["IFR1 #1",{"$nulls":4},1,1,1,1]
["IFR1 #2",{"$nulls":5},1,1,1]
["IFR2 #1",{"$nulls":6},1,1]
["IFR2 #2",{"$nulls":7},1]
[]
[]
["Current common practice (ignores coefficient 3, and sums covariance matrices)"]
[null,"IGRF","Standard","HD #1","HD #2","IFR1 #1","IFR1 #2","IFR2 #1","IFR2 #2"]
["IGRF",0,0,0,0,0,0,0,0]
["Standard",null,0,0,0,0,0,0,0]
["HD #1",null,null,0,0,0,0,0,0]
["HD #2",null,null,null,0,0,0,0,0]
["IFR1 #1",{"$nulls":4},0,0,0,0]
["IFR1 #2",{"$nulls":5},0,0,0]
["IFR2 #1",{"$nulls":6},0,0]
["IFR2 #2",{"$nulls":7},0]
[]
[]
["Estimate of average actual correlation (Stefan's analysis)"]
[null,"IGRF","Standard","HD #1","HD #2","IFR1 #1","IFR1 #2","IFR2 #1","IFR2 #2"]
["IGRF",0.54531330287768709,0.65540142105402632,0.33504372112965197,0.33504372112965197,2.6563659570056301E-2,2.6563659570056301E-2,2.620766259061701E-2,2.620766259061701E-2]
["Standard",null,0.7877289817159765,0.40267699103502091,0.40267699103502091,3.1897179601139594E-2,3.1897179601139594E-2,3.1478764552706553E-2,3.1478764552706553E-2]
["HD #1",null,null,0.68289242981828224,0.49106871357719162,3.9004182018562476E-2,3.9004182018562476E-2,3.8421511868909228E-2,3.8421511868909228E-2]
["HD #2",null,null,null,0.68289242981828224,3.9004182018562476E-2,3.9004182018562476E-2,3.8421511868909228E-2,3.8421511868909228E-2]
["IFR1 #1",{"$nulls":4},0.38692033333333326,7.7384066666666668E-2,0.39078207777777779,7.8156415555555553E-2]
["IFR1 #2",{"$nulls":5},0.38692033333333326,7.8156415555555553E-2,0.39078207777777779]
["IFR2 #1",{"$nulls":6},0.44183589765432096,8.836717953086419E-2]
["IFR2 #2",{"$nulls":7},0.44183589765432096]

{"sheet":"Correlation matrix","index":1,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[3,0,3,8],[4,0,4,8],[25,0,25,8],[26,0,26,8],[27,0,27,8],[23,0,23,8],[18,0,18,8],[19,0,19,8],[20,0,20,8],[21,0,21,8],[22,0,22,8],[24,0,24,8]]}
["Correlation of geomagnetic reference values integrated for two different wells"]
["The short scales of the crustal anomaly differ for 2 well paths. For standard models 90% of the crustal anomaly along 2 different well paths may be correlated. For HD models, where the long wavelength error is reduced, the correlation may drop to 80%, while for IFR models the remaining ommission error is more short scale, so the crustal omission error may be 70% correlated between two different well paths. "]
["The commission error for HD models is all long wavelength, so is 100% correlated for two different well paths. Since IFR models include very short scales, their commission error is different between two well paths and therefore may be only 70% correlated."]
[]
[]
[]
["Average correlation in %"]
[null,"IGRF","Standard","HD #1","HD #2","IFR1 #1","IFR1 #2","IFR2 #1","IFR2 #2"]
["IGRF",54.531330287768711,65.540142105402637,33.5043721129652,33.5043721129652,2.6563659570056299,2.6563659570056299,2.6207662590617011,2.6207662590617011]
["Standard",null,78.772898171597646,40.267699103502089,40.267699103502089,3.1897179601139594,3.1897179601139594,3.1478764552706555,3.1478764552706555]
["HD #1",null,null,68.289242981828224,49.106871357719164,3.9004182018562474,3.9004182018562474,3.8421511868909226,3.8421511868909226]
["HD #2",null,null,null,68.289242981828224,3.9004182018562474,3.9004182018562474,3.8421511868909226,3.8421511868909226]
["IFR1 #1",{"$nulls":4},38.692033333333328,7.7384066666666671,39.078207777777777,7.8156415555555556]
["IFR1 #2",{"$nulls":5},38.692033333333328,7.8156415555555556,39.078207777777777]
["IFR2 #1",{"$nulls":6},44.183589765432096,8.8367179530864188]
["IFR2 #2",{"$nulls":7},44.183589765432096]
[]
["Interpretation:"]
["The error of a yearly updated standard model (BGGM, MVSD) is dominated by the crustal omission. 2 Wells referenced with standard models (whether the same or different) therefore share a portion of the the same highly correlated crustal error"]
["The error of a 5-year updated model (IGRF, WMM) has the additional contribution of an uncorrelated main field error. Two such wells share a large part of the correlated crustal omission error but have large uncorrelated main field errors "]
["If one well is referenced with IGRF, the other with BGGM, they share a large correlated crustal omission error and have some additional uncorrelated main field errors."]
["The errors of high definition models (HDGM, MVHD) are still dominated by largely correlated crustal omission errors. Here the crustal commission error (of the model itself) becomes more important, so that correlations of the errors of 2 different models will be lower than if the same model is used for both wells. Also to consider here is that the HD and IFR models generally provide the large scale part of the crustal anomaly. This is highly correlated between different well trajectories in the same area. However, the crustal omission error is due to the small-scale crustal features that are not part of the model. Because they are small-scale, they can differ substantially between two wellbore trajectories in the same area. \n"]
["In IFR models, which are meant to represent the entire crustal field, the crustal omission error becomes small, while there is still significant commission error. That commission error is partly correlated between two wells using the same IFR1 method, but is uncorrelated between two different methods. For example, one well may have been referenced using a ground shot while the other was referenced using an aeromagnetic transformation. The errors between these very different IFR1 methods would be largely uncorrelated. "]
["By correcting for the disturbance field (IFR2), one reduces a source of uncorrelated error. Therefore two IFR2 wells sharing the same crustal correction have higher correlated errors than two IFR1 wells."]
["If one well is referenced with IFR1 and the other with IFR2 (additional disturbance field correction), but both share the same crustal correction, then this is denoted here by IFR1-#1 and IFR2-#1. They then share part of the crustal omission and commission errors, leading to partly correlated errors."]

{"sheet":"Numerical derivation","index":2,"n_rows":104,"n_cols":21,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
[null,"5-year public models (IGRF, WMM)",null,null,null,"1-year Standard Definition (BGGM, MVSD)",null,null,null,"1-year High Definition (HDGM, MVHD)",null,null,null,"In-Field Referencing (IFR1)",null,null,null,"IFR1 + Disturbance field correction (IFR2)"]
["Error type","DECG","DBHG","MFIG","MDIG","DECG","DBHG","MFIG","MDIG","DECG","DBHG","MFIG","MDIG","DECG","DBHG","MFIG","MDIG","DECG","DBHG","MFIG","MDIG"]
["Main field error",{"$f":"SQRT(B7*B7-F7*F7+F3*F3)","v":0.23853720883753124},{"$f":"SQRT(C7*C7-G7*G7+G3*G3)","v":3405.707121876454},88.983144471298601,0.13416407864998736,0.04,500,13,0.02,0.04,500,13,0.02,0.04,500,13,0.02,0.04,500,13,0.02]
["Crustal commision error",{"$nulls":8},{"$f":"SQRT((J7*J7-J3*J3-J6*J6)*1/5)","v":0.1328909327230417},{"$f":"SQRT((K7*K7-K3*K3-K6*K6)*1/5)","v":1788.9842928321086},46.467192727772996,7.0427267446636035E-2,{"$f":"SQRT((N7*N7-N3*N3-N6*N6)*4/5)","v":0.12899612397277679},{"$f":"SQRT((O7*O7-O3*O3-O6*O6)*4/5)","v":1017.6050314341021},38.439562952770416,{"$f":"SQRT((Q7*Q7-Q3*Q3-Q6*Q6)*4/5)","v":8.5790442358108884E-2},{"$f":"SQRT((R7*R7-R3*R3-R6*R6)*4/5)","v":0.12930583900195691},1017.5558952706234,38.439562952770416,6.9282032302755092E-2]
["Crustal omission error",{"$f":"SQRT(B7*B7-B3*B3-B6*B6)","v":0.35763109484495337},4903.5089476822614,127.46372032857036,0.19798989873223333,{"$f":"SQRT(F7*F7-F3*F3-F6*F6)","v":0.35763109484495337},{"$f":"SQRT(G7*G7-G3*G3-G6*G6)","v":4903.5089476822614},127.46372032857036,0.19798989873223333,{"$f":"SQRT((J7*J7-J3*J3-J6*J6)*4/5)","v":0.2657818654460834},{"$f":"SQRT((K7*K7-K3*K3-K6*K6)*4/5)","v":3577.9685856642172},{"$f":"SQRT((L7*L7-L3*L3-L6*L6)*4/5)","v":92.934385455545993},{"$f":"SQRT((M7*M7-M3*M3-M6*M6)*4/5)","v":0.14085453489327207},{"$f":"SQRT((N7*N7-N3*N3-N6*N6)*1/5)","v":6.4498061986388397E-2},{"$f":"SQRT((O7*O7-O3*O3-O6*O6)*1/5)","v":508.80251571705105},19.219781476385208,{"$f":"SQRT((Q7*Q7-Q3*Q3-Q6*Q6)*1/5)","v":4.2895221179054442E-2},{"$f":"SQRT((R7*R7-R3*R3-R6*R6)*1/5)","v":6.4652919500978456E-2},508.7779476353117,19.219781476385208,3.4641016151377546E-2]
["Disturbance field error",0.01,840,22,0.02,0.01,840,22,0.02,0.01,840,22,0.02,0.01,840,22,0.02,0,135,3,0]
["Root Sum Square",0.43,6029,157,0.24,0.36,5000,130,0.2,0.3,4118,107,0.16,0.15,1500,50,0.1,0.15,1250,45,0.08]
[]
["Bold=ISCWSA/OWSG",null,"Blue=Assumptions based on earlier studies",{"$nulls":4},"Green = Computed from the black squared minus the blue squared values"]
[]
["Assumptions:"]
["For the 1-year models, the main field error is 1/10th of the total error"]
["For High Definition models, the crustal comission error is half as high as the crustal ommission error",{"$nulls":8},"Commission error is the error of the model in representing what it should be representing"]
["For IFR models, the crustal comission error is twice as high as the crustal ommission error",{"$nulls":8},"Omission error is the error due to the model not representing parts of the field (e.g. IGRF not having a crustal component)"]
["The short scales of the crustal anomaly differ for 2 well paths. For standard models 90% of the crustal anomaly along 2 different well paths may be correlated. For HD models, where the long wavelength error is reduced, the correlation may drop to 80%, while for IFR models the remaining ommission error is more short scale, so the crustal omission error may be 70% correlated. "]
["The commission error for HD models is all long wavelength, so is 100% correlated for two different well paths. Since IFR models include very short scales, their commission error may be different between two well paths and therefore maybe only 70% correlated."]
[]
[null,"IGRF","Standard","Highdef","IFR1","IFR2"]
["Crustal commission error correlation",null,null,1,0.7,0.7]
["Crustal ommission error correlation",0.9,0.9,0.8,0.7,0.7]
[]
["Error type","Between same model*",null,null,"Between different model/method"]
["Main field error","uncorrelated",null,null,"uncorrelated",{"$nulls":4},"Since the main field changes over time, main field errors would only correlated within the same model for a short time period"]
["Crust commision error","correlated",null,null,"uncorrelated",{"$nulls":4},"The crustal commission error is inherrently tied to the constant crustal part of a model, so correlated within model but uncorrelated to others"]
["Crust omission error","partly correlated",null,null,"partly correlated",{"$nulls":4},"The crustal omission error is correlated even between different models, as long as the same parts of the crust are omitted"]
["Disturbance field error","uncorrelated",null,null,"uncorrelated",{"$nulls":4},"The global portion of the disturbance field changes over time and is therefore uncorrelated, even within the same model "]
["*IFR1-#1 and IFR2-#1 are assumed here to have the same crustal model, the errors of which are therefore correlated, same for IFR1-#2 and IFR2-#2"]
[]
["Correlation = Square of correlated error / (sigmaA * sigmaB)"]
[]
["DECG"]
[null,"IGRF","Standard","Highdef","IFR1","IFR2"]
["Crustal commision error",{"$f":"B4","v":0},{"$f":"F4","v":0},{"$f":"J4","v":0.1328909327230417},{"$f":"E19*N4","v":9.0297286780943745E-2},{"$f":"F19*R4","v":9.0514087301369839E-2}]
["Correlated crustal omission",{"$f":"B20*B5","v":0.32186798536045802},{"$f":"C20*F5","v":0.32186798536045802},{"$f":"D20*J5","v":0.21262549235686673},{"$f":"E20*N5","v":4.5148643390471872E-2},{"$f":"F20*R5","v":4.5257043650684919E-2}]
["Root Sum Square",{"$f":"B7","v":0.43},{"$f":"F7","v":0.36},{"$f":"J7","v":0.3},{"$f":"N7","v":0.15},{"$f":"R7","v":0.15}]
[]
[null,"IGRF","Standard","HD #1","HD #2","IFR1 #1","IFR1 #2","IFR2 #1","IFR2 #2"]
["IGRF",{"$f":"B34*B34/(B35*B35)","v":0.56029745808545184},{"$f":"B34*C34/B35/C35","v":0.66924418604651181},{"$f":"D34*D34/B35/D35","v":0.35046201550387596},{"$f":"D38","v":0.35046201550387596},{"$f":"E34*E34/B35/E35","v":3.1603100775193793E-2},{"$f":"F38","v":3.1603100775193793E-2},{"$f":"F34*F34/B35/F35","v":3.1755038759689928E-2},{"$f":"H38","v":3.1755038759689928E-2}]
["Standard",null,{"$f":"C34*C34/C35/C35","v":0.79937500000000017},{"$f":"D34*D34/C35/D35","v":0.41860740740740737},0.41860740740740737,{"$f":"E34*E34/C35/E35","v":3.7748148148148142E-2},{"$f":"F39","v":3.7748148148148142E-2},{"$f":"F34*F34/C35/F35","v":3.7929629629629633E-2},{"$f":"H39","v":3.7929629629629633E-2}]
["HD #1",null,null,{"$f":"(D34*D34+D33*D33)/D35/D35","v":0.69855111111111112},{"$f":"D34*D34/D35/D35","v":0.50232888888888882},{"$f":"E34*E34/D35/E35","v":4.5297777777777777E-2},4.5297777777777777E-2,{"$f":"F34*F34/D35/F35","v":4.5515555555555559E-2},4.5515555555555559E-2]
["HD #2",null,null,null,{"$f":"D40","v":0.69855111111111112},{"$f":"F40","v":4.5297777777777777E-2},4.5297777777777777E-2,{"$f":"H40","v":4.5515555555555559E-2},4.5515555555555559E-2]
["IFR1 #1",{"$nulls":4},{"$f":"(E34*E34+E33*E33)/E35/E35","v":0.4529777777777777},{"$f":"E34*E34/E35/E35","v":9.0595555555555554E-2},{"$f":"(F34*F34+F33*F33)/E35/F35","v":0.45515555555555559},{"$f":"H43","v":9.1031111111111118E-2}]
["IFR1 #2",{"$nulls":5},{"$f":"F42","v":0.4529777777777777},{"$f":"F34*F34/E35/F35","v":9.1031111111111118E-2},{"$f":"H42","v":0.45515555555555559}]
["IFR2 #1",{"$nulls":6},{"$f":"(F34*F34+F33*F33)/F35/F35","v":0.45515555555555559},{"$f":"F34*F34/F35/F35","v":9.1031111111111118E-2}]
["IFR2 #2",{"$nulls":7},{"$f":"H44","v":0.45515555555555559}]
[]
["DBHG"]
[null,"IGRF","Standard","Highdef","IFR1","IFR2"]
[{"$f":"A33","v":"Crustal commision error"},{"$f":"C4","v":0},{"$f":"G4","v":0},{"$f":"K4","v":1788.9842928321086},{"$f":"E19*O4","v":712.3235220038714},{"$f":"F19*S4","v":712.28912668943633}]
[{"$f":"A34","v":"Correlated crustal omission"},{"$f":"B20*C5","v":4413.1580529140356},{"$f":"C20*G5","v":4413.1580529140356},{"$f":"D20*K5","v":2862.374868531374},{"$f":"E20*O5","v":356.1617610019357},{"$f":"F20*S5","v":356.14456334471816}]
["Root Sum Square",{"$f":"C7","v":6029},{"$f":"G7","v":5000},{"$f":"K7","v":4118},{"$f":"O7","v":1500},{"$f":"S7","v":1250}]
[]
[null,"IGRF","Standard","HD #1","HD #2","IFR1 #1","IFR1 #2","IFR2 #1","IFR2 #2"]
["IGRF",{"$f":"B50*B50/(B51*B51)","v":0.53580701513976747},{"$f":"B50*C50/B51/C51","v":0.64607609885553152},{"$f":"D50*D50/B51/D51","v":0.33000566422079586},{"$f":"D54","v":0.33000566422079586},{"$f":"E50*E50/B51/E51","v":1.4026781666390221E-2},{"$f":"F54","v":1.4026781666390221E-2},{"$f":"F50*F50/B51/F51","v":1.6830512522806432E-2},{"$f":"H54","v":1.6830512522806432E-2}]
["Standard",null,{"$f":"C50*C50/C51/C51","v":0.77903855999999994},{"$f":"D50*D50/C51/D51","v":0.39792082991743566},0.39792082991743566,{"$f":"E50*E50/C51/E51","v":1.6913493333333328E-2},{"$f":"F55","v":1.6913493333333328E-2},{"$f":"F50*F50/C51/F51","v":2.0294231999999995E-2},{"$f":"H55","v":2.0294231999999995E-2}]
["HD #1",null,null,{"$f":"(D50*D50+D49*D49)/D51/D51","v":0.67187791901886107},{"$f":"D50*D50/D51/D51","v":0.4831481664854731},{"$f":"E50*E50/D51/E51","v":2.0536053100210453E-2},2.0536053100210453E-2,{"$f":"F50*F50/D51/F51","v":2.4640883924235059E-2},2.4640883924235059E-2]
["HD #2",null,null,null,{"$f":"D56","v":0.67187791901886107},{"$f":"F56","v":2.0536053100210453E-2},2.0536053100210453E-2,{"$f":"H56","v":2.4640883924235059E-2},2.4640883924235059E-2]
["IFR1 #1",{"$nulls":4},{"$f":"(E50*E50+E49*E49)/E51/E51","v":0.28189155555555551},{"$f":"E50*E50/E51/E51","v":5.63783111111111E-2},{"$f":"(F50*F50+F49*F49)/E51/F51","v":0.33823719999999996},{"$f":"H59","v":6.7647439999999989E-2}]
["IFR1 #2",{"$nulls":5},{"$f":"F58","v":0.28189155555555551},{"$f":"F50*F50/E51/F51","v":6.7647439999999989E-2},{"$f":"H58","v":0.33823719999999996}]
["IFR2 #1",{"$nulls":6},{"$f":"(F50*F50+F49*F49)/F51/F51","v":0.40588463999999996},{"$f":"F50*F50/F51/F51","v":8.1176927999999982E-2}]
["IFR2 #2",{"$nulls":7},{"$f":"H60","v":0.40588463999999996}]
[]
["MFIG"]
[null,"IGRF","Standard","Highdef","IFR1","IFR2"]
[{"$f":"A49","v":"Crustal commision error"},{"$f":"D4","v":0},{"$f":"H4","v":0},{"$f":"L4","v":46.467192727772996},{"$f":"E19*P4","v":26.907694066939289},{"$f":"F19*T4","v":26.907694066939289}]
[{"$f":"A50","v":"Correlated crustal omission"},{"$f":"B20*D5","v":114.71734829571332},{"$f":"C20*H5","v":114.71734829571332},{"$f":"D20*L5","v":74.347508364436791},{"$f":"E20*P5","v":13.453847033469645},{"$f":"F20*T5","v":13.453847033469645}]
["Root Sum Square",{"$f":"D7","v":157},{"$f":"H7","v":130},{"$f":"L7","v":107},{"$f":"P7","v":50},{"$f":"T7","v":45}]
[]
[null,"IGRF","Standard","HD #1","HD #2","IFR1 #1","IFR1 #2","IFR2 #1","IFR2 #2"]
["IGRF",{"$f":"B66*B66/(B67*B67)","v":0.53389873828552881},{"$f":"B66*C66/B67/C67","v":0.64478539931406176},{"$f":"D66*D66/B67/D67","v":0.32904053812726941},{"$f":"D70","v":0.32904053812726941},{"$f":"E66*E66/B67/E67","v":2.3058089171974515E-2},{"$f":"F70","v":2.3058089171974515E-2},{"$f":"F66*F66/B67/F67","v":2.5620099079971686E-2},{"$f":"H70","v":2.5620099079971686E-2}]
["Standard",null,{"$f":"C66*C66/C67/C67","v":0.77870236686390537},{"$f":"D66*D66/C67/D67","v":0.39737972681524075},0.39737972681524075,{"$f":"E66*E66/C67/E67","v":2.7847076923076912E-2},{"$f":"F71","v":2.7847076923076912E-2},{"$f":"F66*F66/C67/F67","v":3.0941196581196571E-2},{"$f":"H71","v":3.0941196581196571E-2}]
["HD #1",null,null,{"$f":"(D66*D66+D65*D65)/D67/D67","v":0.67139068914315658},{"$f":"D66*D66/D67/D67","v":0.48279779893440466},{"$f":"E66*E66/D67/E67","v":3.3832897196261674E-2},3.3832897196261674E-2,{"$f":"F66*F66/D67/F67","v":3.7592107995846301E-2},3.7592107995846301E-2]
["HD #2",null,null,null,{"$f":"D72","v":0.67139068914315658},{"$f":"F72","v":3.3832897196261674E-2},3.3832897196261674E-2,{"$f":"H72","v":3.7592107995846301E-2},3.7592107995846301E-2]
["IFR1 #1",{"$nulls":4},{"$f":"(E66*E66+E65*E65)/E67/E67","v":0.36201199999999994},{"$f":"E66*E66/E67/E67","v":7.2402399999999978E-2},{"$f":"(F66*F66+F65*F65)/E67/F67","v":0.40223555555555546},{"$f":"H75","v":8.044711111111108E-2}]
["IFR1 #2",{"$nulls":5},{"$f":"F74","v":0.36201199999999994},{"$f":"F66*F66/E67/F67","v":8.044711111111108E-2},{"$f":"H74","v":0.40223555555555546}]
["IFR2 #1",{"$nulls":6},{"$f":"(F66*F66+F65*F65)/F67/F67","v":0.44692839506172827},{"$f":"F66*F66/F67/F67","v":8.9385679012345662E-2}]
["IFR2 #2",{"$nulls":7},{"$f":"H76","v":0.44692839506172827}]
[]
["MDIG"]
[null,"IGRF","Standard","Highdef","IFR1","IFR2"]
[{"$f":"A65","v":"Crustal commision error"},{"$f":"E4","v":0},{"$f":"I4","v":0},{"$f":"M4","v":7.0427267446636035E-2},{"$f":"E19*Q4","v":6.0053309650676213E-2},{"$f":"F19*U4","v":4.8497422611928562E-2}]
[{"$f":"A66","v":"Correlated crustal omission"},{"$f":"B20*E5","v":0.17819090885901001},{"$f":"C20*I5","v":0.17819090885901001},{"$f":"D20*M5","v":0.11268362791461767},{"$f":"E20*Q5","v":3.0026654825338107E-2},{"$f":"F20*U5","v":2.4248711305964281E-2}]
["Root Sum Square",{"$f":"E7","v":0.24},{"$f":"I7","v":0.2},{"$f":"M7","v":0.16},{"$f":"Q7","v":0.1},{"$f":"U7","v":0.08}]
[]
[null,"IGRF","Standard","HD #1","HD #2","IFR1 #1","IFR1 #2","IFR2 #1","IFR2 #2"]
["IGRF",{"$f":"B82*B82/(B83*B83)","v":0.55125000000000013},{"$f":"B82*C82/B83/C83","v":0.6615000000000002},{"$f":"D82*D82/B83/D83","v":0.33066666666666672},{"$f":"D86","v":0.33066666666666672},{"$f":"E82*E82/B83/E83","v":3.7566666666666672E-2},{"$f":"F86","v":3.7566666666666672E-2},{"$f":"F82*F82/B83/F83","v":3.0624999999999999E-2},{"$f":"H86","v":3.0624999999999999E-2}]
["Standard",null,{"$f":"C82*C82/C83/C83","v":0.79380000000000017},{"$f":"D82*D82/C83/D83","v":0.39679999999999999},0.39679999999999999,{"$f":"E82*E82/C83/E83","v":4.5080000000000002E-2},{"$f":"F87","v":4.5080000000000002E-2},{"$f":"F82*F82/C83/F83","v":3.6749999999999998E-2},{"$f":"H87","v":3.6749999999999998E-2}]
["HD #1",null,null,{"$f":"(D82*D82+D81*D81)/D83/D83","v":0.68975000000000009},{"$f":"D82*D82/D83/D83","v":0.49600000000000005},{"$f":"E82*E82/D83/E83","v":5.6350000000000011E-2},5.6350000000000011E-2,{"$f":"F82*F82/D83/F83","v":4.5937499999999999E-2},4.5937499999999999E-2]
["HD #2",null,null,null,{"$f":"D88","v":0.68975000000000009},{"$f":"F88","v":5.6350000000000011E-2},5.6350000000000011E-2,{"$f":"H88","v":4.5937499999999999E-2},4.5937499999999999E-2]
["IFR1 #1",{"$nulls":4},{"$f":"(E82*E82+E81*E81)/E83/E83","v":0.45080000000000015},{"$f":"E82*E82/E83/E83","v":9.0160000000000004E-2},{"$f":"(F82*F82+F81*F81)/E83/F83","v":0.36749999999999999},{"$f":"H91","v":7.3499999999999996E-2}]
["IFR1 #2",{"$nulls":5},{"$f":"F90","v":0.45080000000000015},{"$f":"F82*F82/E83/F83","v":7.3499999999999996E-2},{"$f":"H90","v":0.36749999999999999}]
["IFR2 #1",{"$nulls":6},{"$f":"(F82*F82+F81*F81)/F83/F83","v":0.45937499999999998},{"$f":"F82*F82/F83/F83","v":9.1874999999999998E-2}]
["IFR2 #2",{"$nulls":7},{"$f":"H92","v":0.45937499999999998}]
[]
["Average correlation in %"]
[null,"IGRF","Standard","HD #1","HD #2","IFR1 #1","IFR1 #2","IFR2 #1","IFR2 #2"]
["IGRF",{"$f":"100*(B86+B70+B54+B38)/4","v":54.531330287768711},{"$f":"100*(C86+C70+C54+C38)/4","v":65.540142105402637},33.5043721129652,33.5043721129652,2.6563659570056299,2.6563659570056299,2.6207662590617011,2.6207662590617011]
["Standard",null,78.772898171597646,{"$f":"100*(D87+D71+D55+D39)/4","v":40.267699103502089},{"$f":"100*(E87+E71+E55+E39)/4","v":40.267699103502089},{"$f":"100*(F87+F71+F55+F39)/4","v":3.1897179601139594},{"$f":"100*(G87+G71+G55+G39)/4","v":3.1897179601139594},{"$f":"100*(H87+H71+H55+H39)/4","v":3.1478764552706555},{"$f":"100*(I87+I71+I55+I39)/4","v":3.1478764552706555}]
["HD #1",null,null,{"$f":"100*(D88+D72+D56+D40)/4","v":68.289242981828224},{"$f":"100*(E88+E72+E56+E40)/4","v":49.106871357719164},{"$f":"100*(F88+F72+F56+F40)/4","v":3.9004182018562474},{"$f":"100*(G88+G72+G56+G40)/4","v":3.9004182018562474},{"$f":"100*(H88+H72+H56+H40)/4","v":3.8421511868909226},{"$f":"100*(I88+I72+I56+I40)/4","v":3.8421511868909226}]
["HD #2",null,null,null,{"$f":"100*(E89+E73+E57+E41)/4","v":68.289242981828224},{"$f":"100*(F89+F73+F57+F41)/4","v":3.9004182018562474},{"$f":"100*(G89+G73+G57+G41)/4","v":3.9004182018562474},{"$f":"100*(H89+H73+H57+H41)/4","v":3.8421511868909226},{"$f":"100*(I89+I73+I57+I41)/4","v":3.8421511868909226}]
["IFR1 #1",{"$nulls":4},{"$f":"100*(F90+F74+F58+F42)/4","v":38.692033333333328},{"$f":"100*(G90+G74+G58+G42)/4","v":7.7384066666666671},{"$f":"100*(H90+H74+H58+H42)/4","v":39.078207777777777},{"$f":"100*(I90+I74+I58+I42)/4","v":7.8156415555555556}]
["IFR1 #2",{"$nulls":5},38.692033333333328,{"$f":"100*(H91+H75+H59+H43)/4","v":7.8156415555555556},{"$f":"100*(I91+I75+I59+I43)/4","v":39.078207777777777}]
["IFR2 #1",{"$nulls":6},{"$f":"100*(H92+H76+H60+H44)/4","v":44.183589765432096},{"$f":"100*(I92+I76+I60+I44)/4","v":8.8367179530864188}]
["IFR2 #2",{"$nulls":7},{"$f":"100*(I93+I77+I61+I45)/4","v":44.183589765432096}]

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