{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Recalculations"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":3,"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":"1904","formulas":"cached_only"}

{"sheet":"Recalculations","index":0,"n_rows":212,"n_cols":12,"rows_kept":212,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Recalculation of an EDS/WDS mica analysis using stoichiometry to place limits on Fe+3"]
[]
["Enter the analysis (wt% of the oxides) by replacing the red numbers."]
["The analysis already present is from DHZ (v.3, p.18, muscovite #13.)"]
[]
["Oxygens per formula =",null,11]
[]
[null,null,null,"Mole","Oxygen","Normaliz.","Atom"]
["Oxide","GFW","Wt.%","Units","Units","Ox Units","Units"]
[]
["SiO2",60.084,48.42,0.8058717795086878,1.6117435590173756,6.687576965347168,3.343788482673584,"Si","Fe+3",null,"Sum K","Oxygens"]
["TiO2",79.866,0.87,0.010893246187363835,0.02178649237472767,0.09039827939487348,0.04519913969743674,"Ti",0.3813791295883797,"All Ferric",6.90208717995012,11.999999999999998]
["Al2O3",101.961,27.16,0.2663763595884701,0.7991290787654104,3.315811122427477,2.2105407482849846,"Al",0.3482042566825396,"Sum Si=3",6.301698099333659,11.043147425612668]
["Fe2O3",159.688,{"$nulls":4},0,"Fe+3",0,"Sum Mg=6",7.038352796060539,12.022715063078495]
["FeO",71.844,6.72,0.09353599465508602,0.09353599465508602,0.3881071277043307,0.3881071277043307,"Fe+2",0.3482042566825396,"Sum Si=4",7.301698099333659,13.043147425612668]
["MnO",70.937,0,0,0,0,0,"Mn",0.4158640892738571,"Sum Al=6",7.526185825314176,12.786706956583892]
["MgO",40.304,0,0,0,0,0,"Mg",0,"All Ferrous",7.023848508612635,11.999999999999998]
["CaO",56.077,0,0,0,0,0,"Ca",0.3745437703101547,"A-Site full",6.778382860588152,11.80284985142835]
["Na2O",61.979,0.35,0.005647074008938511,0.005647074008938511,0.023431297027681028,0.046862594055362056,"Na",0,"Sum Mg=7",8.211411595403963,13.859834240258246]
["K2O",94.196,11.23,0.11921949976644444,0.11921949976644444,0.4946752080984681,0.9893504161969362,"K"]
["H2O",18.015,{"$nulls":4},2,"H",null,null,"Should be","Should be"]
[{"$nulls":10},"6 to 8",12]
["Totals",null,94.75,1.3015439537149907,2.651061698587983,10.999999999999998,9.023848508612634]
[]
[{"$nulls":5},"Sum Si =",3.343788482673584]
[{"$nulls":5},"Sum Al =",5.599528370656006,null,"The \"Sum\" values are summations of the column of \"Atom Units\" "]
[{"$nulls":5},"Sum Mg =",5.987635498360336,null,"down to the element listed.  For example, \"Sum Mg\" would be the"]
["Fe+3 lower bound",null,"All Ferrous Iron",null,null,"Sum Ca =",5.987635498360336,null,"sum of the \"Atom Units\" for Si, Ti, Al, Fe+3, Fe+2, Mn, and Mg."]
[{"$nulls":5},"Sum Na =",6.034498092415698,null,"The choice of \"Sums\" is based on cation sizes and site occupancies."]
[{"$nulls":5},"Sum K =",7.023848508612635]
[]
["Oxygens per formula =",null,11]
[]
[null,null,"FeO only","Fe2O3 only","Mole","Oxygen","Normaliz.","Atom"]
["Oxide","GFW","Wt.%","Wt.%","Units","Units","Ox Units","Units"]
[{"$nulls":9},"Wt% Fe2O3 = Wt%FeO*159.692/(2*71.846) = Wt%FeO*(1.111349275)"]
["SiO2",60.084,48.42,48.42,0.8058717795086878,1.6117435590173756,6.571645043433559,3.2858225217167796,"Si"]
["TiO2",79.866,0.87,0.87,0.010893246187363835,0.02178649237472767,0.08883118770796875,0.04441559385398437,"Ti","Mole#Fe2O3 = Wt%Fe2O3/159.692 = Wt%FeO/(2*71.846)"]
["Al2O3",101.961,27.16,27.16,0.2663763595884701,0.7991290787654104,3.25833016062062,2.1722201070804132,"Al"]
["Fe2O3",159.688,null,7.468287957240688,0.04676799732754301,0.14030399198262905,0.5720686943825696,0.3813791295883797,"Fe+3"]
["FeO",71.844,6.72,{"$nulls":4},0,"Fe+2"]
["MnO",70.937,0,0,0,0,0,0,"Mn"]
["MgO",40.304,0,0,0,0,0,0,"Mg"]
["CaO",56.077,0,0,0,0,0,0,"Ca"]
["Na2O",61.979,0.35,0.35,0.005647074008938511,0.005647074008938511,0.023025105770156307,0.046050211540312615,"Na"]
["K2O",94.196,11.23,11.23,0.11921949976644444,0.11921949976644444,0.48609980808512515,0.9721996161702503,"K"]
["H2O",18.015,{"$nulls":5},2,"H"]
[]
["Totals",null,94.75,95.49828795724069,1.2547759563874477,2.697829695915526,10.999999999999998,8.90208717995012]
[]
[{"$nulls":6},"Sum Si =",3.2858225217167796]
[{"$nulls":6},"Sum Al =",5.502458222651177]
[{"$nulls":6},"Sum Mg =",5.883837352239557]
["Fe+3 upper bound",null,"All Ferric Iron",null,null,null,"Sum Ca =",5.883837352239557]
[{"$nulls":6},"Sum Na =",5.906862458009714]
[{"$nulls":6},"Sum K =",6.90208717995012]
[]
["Oxygens per formula =",null,11,null,"Cations per formula =",null,3,null,null,"Final"]
[{"$nulls":9},"Oxygen"]
[null,null,null,"Mole","Cation","Normaliz.","Oxygen","Atom",null,"Units"]
["Oxide","GFW","Wt.%","Units","Units","Cat Units","Units","Units"]
[]
["SiO2",60.084,48.42,0.8058717795086878,0.8058717795086878,3.0000000000000004,6.000000000000001,3.0000000000000004,"Si",6.000000000000001]
["TiO2",79.866,0.87,0.010893246187363835,0.010893246187363835,0.04055203246106374,0.08110406492212748,0.04055203246106374,"Ti",0.08110406492212748]
["Al2O3",101.961,27.16,0.2663763595884701,0.5327527191769402,1.9832660705717025,2.9748991058575536,1.9832660705717025,"Al",2.9748991058575536]
["Fe2O3",159.688,{"$nulls":5},0.3482042566825396,"Fe+3",0.5223063850238094]
["FeO",71.844,6.72,0.09353599465508602,0.09353599465508602,0.3482042566825396,0.3482042566825396,0,"Fe+2",0]
["MnO",70.937,0,0,0,0,0,0,"Mn",0]
["MgO",40.304,0,0,0,0,0,0,"Mg",0]
["CaO",56.077,0,0,0,0,0,0,"Ca",0]
["Na2O",61.979,0.35,0.005647074008938511,0.011294148017877021,0.042044460316364496,0.021022230158182248,0.042044460316364496,"Na",0.021022230158182248]
["K2O",94.196,11.23,0.11921949976644444,0.23843899953288888,0.8876312793019887,0.44381563965099435,0.8876312793019887,"K",0.44381563965099435]
["H2O",18.015,{"$nulls":5},2,"H",1]
[]
["Totals",null,94.75,1.3015439537149907,0.8058717795086878,6.301698099333659,9.869045297271398,8.30169809933366,null,11.043147425612668]
[]
[{"$nulls":6},"Sum Si =",3.0000000000000004]
[{"$nulls":6},"Sum Al =",5.023818103032767]
["Fe+3 lower bound",null,"No phengite component",null,null,null,"Sum Mg =",5.372022359715306]
[{"$nulls":6},"Sum Ca =",5.372022359715306]
[null,null,"Sum Si = 3",null,null,null,"Sum Na =",5.41406682003167]
[{"$nulls":6},"Sum K =",6.301698099333659]
[]
["Oxygens per formula =",null,11,null,"Cations per formula =",null,4]
[{"$nulls":9},"Final"]
[null,null,null,"Mole","Cation","Normaliz.","Oxygen","Atom",null,"Oxygen"]
["Oxide","GFW","Wt.%","Units","Units","Cat Units","Units","Units",null,"Units"]
[]
["SiO2",60.084,48.42,0.8058717795086878,0.8058717795086878,4,8,4,"Si",8]
["TiO2",79.866,0.87,0.010893246187363835,0.010893246187363835,0.04055203246106374,0.08110406492212748,0.04055203246106374,"Ti",0.08110406492212748]
["Al2O3",101.961,27.16,0.2663763595884701,0.5327527191769402,1.9832660705717025,2.9748991058575536,1.9832660705717025,"Al",2.9748991058575536]
["Fe2O3",159.688,{"$nulls":5},0.3482042566825396,"Fe+3",0.5223063850238094]
["FeO",71.844,6.72,0.09353599465508602,0.09353599465508602,0.3482042566825396,0.3482042566825396,0,"Fe+2",0]
["MnO",70.937,0,0,0,0,0,0,"Mn",0]
["MgO",40.304,0,0,0,0,0,0,"Mg",0]
["CaO",56.077,0,0,0,0,0,0,"Ca",0]
["Na2O",61.979,0.35,0.005647074008938511,0.011294148017877021,0.042044460316364496,0.021022230158182248,0.042044460316364496,"Na",0.021022230158182248]
["K2O",94.196,11.23,0.11921949976644444,0.23843899953288888,0.8876312793019887,0.44381563965099435,0.8876312793019887,"K",0.44381563965099435]
["H2O",18.015,{"$nulls":5},2,"H",1]
[]
["Totals",null,94.75,1.3015439537149907,0.8058717795086878,7.301698099333659,11.869045297271398,9.30169809933366,null,13.043147425612668]
[]
[{"$nulls":6},"Sum Si =",4]
[{"$nulls":6},"Sum Al =",6.023818103032767]
["Fe+3 lower bound",null,"Maximum Si (no tetrahedral Al)",null,null,null,"Sum Mg =",6.372022359715306]
[{"$nulls":6},"Sum Ca =",6.372022359715306]
[null,null,"Sum Si = 4",null,null,null,"Sum Na =",6.41406682003167]
[{"$nulls":6},"Sum K =",7.301698099333659]
[]
["Oxygens per formula =",null,11,null,"Cations per formula =",null,6]
[{"$nulls":9},"Final"]
[null,null,null,"Mole","Cation","Normaliz.","Oxygen","Atom",null,"Oxygen"]
["Oxide","GFW","Wt.%","Units","Units","Cat Units","Units","Units",null,"Units"]
[]
["SiO2",60.084,48.42,0.8058717795086878,0.8058717795086878,3.582932270006712,7.165864540013424,3.582932270006712,"Si",7.165864540013424]
["TiO2",79.866,0.87,0.010893246187363835,0.010893246187363835,0.04843172857303498,0.09686345714606996,0.04843172857303498,"Ti",0.09686345714606996]
["Al2O3",101.961,27.16,0.2663763595884701,0.5327527191769402,2.3686360014202537,3.5529540021303805,2.3686360014202537,"Al",3.5529540021303805]
["Fe2O3",159.688,{"$nulls":5},0,"Fe+3",0]
["FeO",71.844,6.72,0.09353599465508602,0.09353599465508602,0.4158640892738571,0.4158640892738571,0.4158640892738571,"Fe+2",0.4158640892738571]
["MnO",70.937,0,0,0,0,0,0,"Mn",0]
["MgO",40.304,0,0,0,0,0,0,"Mg",0]
["CaO",56.077,0,0,0,0,0,0,"Ca",0]
["Na2O",61.979,0.35,0.005647074008938511,0.011294148017877021,0.05021415121417298,0.02510707560708649,0.05021415121417298,"Na",0.02510707560708649]
["K2O",94.196,11.23,0.11921949976644444,0.23843899953288888,1.0601075848261452,0.5300537924130726,1.0601075848261452,"K",0.5300537924130726]
["H2O",18.015,{"$nulls":5},2,"H",1]
[]
["Totals",null,94.75,1.3015439537149907,1.3495177448729918,7.526185825314176,11.786706956583892,9.526185825314176,null,12.786706956583892]
[]
[{"$nulls":6},"Sum Si =",3.582932270006712]
[{"$nulls":6},"Sum Al =",6.000000000000001]
["Fe+3 upper bound",null,"Al fills the dioctahdral sites",null,null,null,"Sum Mg =",6.415864089273858]
[{"$nulls":6},"Sum Ca =",6.415864089273858]
[null,null,"Sum Al = 6",null,null,null,"Sum Na =",6.466078240488031]
[{"$nulls":6},"Sum K =",7.526185825314176]
[]
["Oxygens per formula =",null,11,null,"Cations per formula =",null,6]
[{"$nulls":9},"Final"]
[null,null,null,"Mole","Cation","Normaliz.","Oxygen","Atom",null,"Oxygen"]
["Oxide","GFW","Wt.%","Units","Units","Cat Units","Units","Units",null,"Units"]
[]
["SiO2",60.084,48.42,0.8058717795086878,0.8058717795086878,3.350693425064956,6.701386850129912,3.350693425064956,"Si",6.701386850129912]
["TiO2",79.866,0.87,0.010893246187363835,0.010893246187363835,0.0452924761801023,0.0905849523602046,0.0452924761801023,"Ti",0.0905849523602046]
["Al2O3",101.961,27.16,0.2663763595884701,0.5327527191769402,2.2151055276063376,3.3226582914095064,2.2151055276063376,"Al",3.3226582914095064]
["Fe2O3",159.688,{"$nulls":5},0,"Fe+3",0]
["FeO",71.844,6.72,0.09353599465508602,0.09353599465508602,0.38890857114860516,0.38890857114860516,0.38890857114860516,"Fe+2",0.38890857114860516]
["MnO",70.937,0,0,0,0,0,0,"Mn",0]
["MgO",40.304,0,0,0,0,0,0,"Mg",0]
["CaO",56.077,0,0,0,0,0,0,"Ca",0]
["Na2O",61.979,0.35,0.005647074008938511,0.011294148017877021,0.04695936558081565,0.023479682790407824,0.04695936558081565,"Na",0.023479682790407824]
["K2O",94.196,11.23,0.11921949976644444,0.23843899953288888,0.9913934304797228,0.4956967152398614,0.9913934304797228,"K",0.4956967152398614]
["H2O",18.015,{"$nulls":5},2,"H",1]
[]
["Totals",null,94.75,1.3015439537149907,1.4430537395280778,7.038352796060539,11.022715063078495,9.03835279606054,null,12.022715063078495]
[]
[{"$nulls":6},"Sum Si =",3.350693425064956]
[{"$nulls":6},"Sum Al =",5.611091428851395]
["Fe+3 upper bound",null,"No trioctahedral substitutions",null,null,null,"Sum Mg =",6.000000000000001]
[{"$nulls":6},"Sum Ca =",6.000000000000001]
[null,null,"Sum Mg = 6",null,null,null,"Sum Na =",6.0469593655808165]
[{"$nulls":6},"Sum K =",7.038352796060539]
[]
["Oxygens per formula =",null,11,null,"Cations per formula =",null,7]
[{"$nulls":9},"Final"]
[null,null,null,"Mole","Cation","Normaliz.","Oxygen","Atom",null,"Oxygen"]
["Oxide","GFW","Wt.%","Units","Units","Cat Units","Units","Units",null,"Units"]
[]
["SiO2",60.084,48.42,0.8058717795086878,0.8058717795086878,3.909142329242448,7.818284658484896,3.909142329242448,"Si",7.818284658484896]
["TiO2",79.866,0.87,0.010893246187363835,0.010893246187363835,0.052841222210119346,0.10568244442023869,0.052841222210119346,"Ti",0.10568244442023869]
["Al2O3",101.961,27.16,0.2663763595884701,0.5327527191769402,2.584289782207394,3.876434673311091,2.584289782207394,"Al",3.876434673311091]
["Fe2O3",159.688,{"$nulls":5},0,"Fe+3",0]
["FeO",71.844,6.72,0.09353599465508602,0.09353599465508602,0.45372666634003933,0.45372666634003933,0.45372666634003933,"Fe+2",0.45372666634003933]
["MnO",70.937,0,0,0,0,0,0,"Mn",0]
["MgO",40.304,0,0,0,0,0,0,"Mg",0]
["CaO",56.077,0,0,0,0,0,0,"Ca",0]
["Na2O",61.979,0.35,0.005647074008938511,0.011294148017877021,0.05478592651095159,0.027392963255475796,0.05478592651095159,"Na",0.027392963255475796]
["K2O",94.196,11.23,0.11921949976644444,0.23843899953288888,1.1566256688930099,0.5783128344465049,1.1566256688930099,"K",0.5783128344465049]
["H2O",18.015,{"$nulls":5},2,"H",1]
[]
["Totals",null,94.75,1.3015439537149907,1.4430537395280778,8.211411595403963,12.859834240258246,10.211411595403963,null,13.859834240258246]
[]
[{"$nulls":6},"Sum Si =",3.909142329242448]
["Fe+3 lower bound",null,"Octahedral sites full",null,null,null,"Sum Al =",6.546273333659961]
[{"$nulls":6},"Sum Mg =",7.000000000000001]
[null,null,"Sum Mg = 7",null,null,null,"Sum Ca =",7.000000000000001]
[{"$nulls":6},"Sum Na =",7.054785926510952]
[{"$nulls":6},"Sum K =",8.211411595403963]
[]
["Oxygens per formula =",null,11,null,"Cations per formula =",null,1]
[{"$nulls":9},"Final"]
[null,null,null,"Mole","Cation","Normaliz.","Oxygen","Atom",null,"Oxygen"]
["Oxide","GFW","Wt.%","Units","Units","Cat Units","Units","Units",null,"Units"]
[]
["SiO2",60.084,48.42,0.8058717795086878,0.8058717795086878,3.2269315764134587,6.4538631528269175,3.2269315764134587,"Si",6.4538631528269175]
["TiO2",79.866,0.87,0.010893246187363835,0.010893246187363835,0.04361954467878338,0.08723908935756676,0.04361954467878338,"Ti",0.08723908935756676]
["Al2O3",101.961,27.16,0.2663763595884701,0.5327527191769402,2.1332879691857562,3.199931953778634,2.1332879691857562,"Al",3.199931953778634]
["Fe2O3",159.688,{"$nulls":5},0.3745437703101547,"Fe+3",0.561815655465232]
["FeO",71.844,6.72,0.09353599465508602,0.09353599465508602,0.3745437703101547,0.3745437703101547,0,"Fe+2",0]
["MnO",70.937,0,0,0,0,0,0,"Mn",0]
["MgO",40.304,0,0,0,0,0,0,"Mg",0]
["CaO",56.077,0,0,0,0,0,0,"Ca",0]
["Na2O",61.979,0.35,0.005647074008938511,0.011294148017877021,0.04522486553604639,0.022612432768023195,0.04522486553604639,"Na",0.022612432768023195]
["K2O",94.196,11.23,0.11921949976644444,0.23843899953288888,0.9547751344639537,0.47738756723197684,0.9547751344639537,"K",0.47738756723197684]
["H2O",18.015,{"$nulls":5},2,"H",1]
[]
["Totals",null,94.75,1.3015439537149907,0.2497331475507659,6.778382860588152,10.615577966273273,8.778382860588152,null,11.80284985142835]
[]
[{"$nulls":6},"Sum Si =",3.2269315764134587]
["Fe+3 upper bound",null,"A-site full",null,null,null,"Sum Al =",5.403839090277998]
[{"$nulls":6},"Sum Mg =",5.778382860588152]
[null,null,"K+Na+Ca = 1",null,null,null,"Sum Ca =",5.778382860588152]
[{"$nulls":6},"Sum Na =",5.823607726124199]
[{"$nulls":6},"Sum K =",6.778382860588152]