{"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":213,"n_cols":11,"rows_kept":213,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Recalculation of an EDS/WDS amphibole 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 the worked example in Appendix 2 (by John Schumacher) in the "]
["Leake et al. (1997) paper: American Mineralogist, v.82, 1019-1037."]
[]
["Oxygens per formula =",null,23]
[]
[null,null,null,"Mole","Oxygen","Normaliz.","Atom"]
["Oxide","GFW","Wt.%","Units","Units","Ox Units","Units"]
[]
["SiO2",60.084,43.55,0.7248185873110977,1.4496371746221954,12.78967328314454,6.39483664157227,"Si"]
["TiO2",79.866,1.28,0.016026844965316905,0.03205368993063381,0.28279919203842796,0.14139959601921398,"Ti","Upper",1.1517865853289904,"All Ferric"]
["Al2O3",101.961,13.62,0.13358048665666283,0.4007414599699885,3.5356104504992905,2.3570736336661935,"Al","Bounds",1.0627014249211997,"Sum Al = 8"]
["Fe2O3",159.688,{"$nulls":4},0,"Fe+3","to Fe+3",1.1371993565982794,"A-site \"empty\""]
["FeO",71.844,9.62,0.13390123044373922,0.13390123044373922,1.181366634056413,1.181366634056413,"Fe+2",null,0.8861031030577635,"Sum Mg=13"]
["MnO",70.937,0,0,0,0,0,"Mn"]
["MgO",40.304,14.53,0.3605101230647082,0.3605101230647082,3.1806625616272,3.1806625616272,"Mg",null,0,"Sum Si=8"]
["CaO",56.077,10.25,0.18278438575530076,0.18278438575530076,1.6126466787662375,1.6126466787662375,"Ca","Lower",0,"Sum Ca=15"]
["Na2O",61.979,2.51,0.04049758789267332,0.04049758789267332,0.35729693399847456,0.7145938679969491,"Na","Bounds",0,"All Ferrous"]
["K2O",94.196,0.64,0.006794343708862372,0.006794343708862372,0.05994426586941348,0.11988853173882696,"K","to Fe+3",0,"A-site full"]
["H2O",18.015,{"$nulls":4},2,"H"]
[]
["Totals",null,96,1.5989135897983615,2.606919995388102,22.999999999999996,17.702468145443305]
[]
[{"$nulls":5},"Sum Si =",6.39483664157227,null,"The \"Sum\" values are summations of the column of \"Atom Units\" "]
[{"$nulls":5},"Sum Al =",8.893309871257678,null,"down to the element listed.  For example, \"Sum Mg\" would be the"]
[{"$nulls":5},"Sum Mg =",13.255339066941291,null,"sum of the \"Atom Units\" for Si, Ti, Al, Fe+3, Fe+2, Mn, and Mg."]
["Fe+3 lower bound",null,"All Ferrous Iron",null,null,"Sum Ca =",14.867985745707529,null,"The choice of \"Sums\" is based on cation sizes and site occupancies."]
[{"$nulls":5},"Sum Na =",15.582579613704478]
[{"$nulls":5},"Sum K =",15.702468145443305]
[]
["Oxygens per formula =",null,23]
[]
[null,null,"FeO only","Fe2O3 only","Mole","Oxygen","Normaliz.","Atom"]
["Oxide","GFW","Wt.%","Wt.%","Units","Units","Ox Units","Units"]
[]
["SiO2",60.084,43.55,43.55,0.7248185873110977,1.4496371746221954,12.469434715356138,6.234717357678069,"Si","Wt% Fe2O3 = Wt%FeO*159.692/(2*71.846) = Wt%FeO*(1.111349275)"]
["TiO2",79.866,1.28,1.28,0.016026844965316905,0.03205368993063381,0.27571822865295537,0.13785911432647768,"Ti"]
["Al2O3",101.961,13.62,13.62,0.13358048665666283,0.4007414599699885,3.4470828703289844,2.2980552468859896,"Al","Mole#Fe2O3 = Wt%Fe2O3/159.692 = Wt%FeO/(2*71.846)"]
["Fe2O3",159.688,null,10.691209843549913,0.06695061522186961,0.20085184566560882,1.7276798779934854,1.1517865853289904,"Fe+3"]
["FeO",71.844,9.62,{"$nulls":4},0,"Fe+2"]
["MnO",70.937,0,0,0,0,0,0,"Mn"]
["MgO",40.304,14.53,14.53,0.3605101230647082,0.3605101230647082,3.1010224644328446,3.1010224644328446,"Mg"]
["CaO",56.077,10.25,10.25,0.18278438575530076,0.18278438575530076,1.572267878516709,1.572267878516709,"Ca"]
["Na2O",61.979,2.51,2.51,0.04049758789267332,0.04049758789267332,0.34835063366024366,0.6967012673204873,"Na"]
["K2O",94.196,0.64,0.64,0.006794343708862372,0.006794343708862372,0.05844333105863554,0.11688666211727108,"K"]
["H2O",18.015,{"$nulls":5},2,"H"]
[]
["Totals",null,96,97.07120984354992,1.5319629745764918,2.673870610609972,22.999999999999996,17.309296576606837]
[]
[{"$nulls":6},"Sum Si =",6.234717357678069]
[{"$nulls":6},"Sum Al =",8.670631718890537]
[{"$nulls":6},"Sum Mg =",12.923440768652371]
["Fe+3 upper bound",null,"All Ferric Iron",null,null,null,"Sum Ca =",14.49570864716908]
[{"$nulls":6},"Sum Na =",14.844059280829324]
[{"$nulls":6},"Sum K =",15.309296576606837]
[]
["Oxygens per formula =",null,23,null,"Cations per formula =",null,8]
[{"$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,43.55,0.7248185873110977,0.7248185873110977,8,16,8,"Si",16]
["TiO2",79.866,1.28,0.016026844965316905,0.016026844965316905,0.17689220719101742,0.35378441438203484,0.17689220719101742,"Ti",0.35378441438203484]
["Al2O3",101.961,13.62,0.13358048665666283,0.26716097331332567,2.948720995739676,4.423081493609514,2.948720995739676,"Al",4.423081493609514]
["Fe2O3",159.688,{"$nulls":5},0,"Fe+3",0]
["FeO",71.844,9.62,0.13390123044373922,0.13390123044373922,1.4779006254845701,1.4779006254845701,1.4779006254845701,"Fe+2",1.4779006254845701]
["MnO",70.937,0,0,0,0,0,0,"Mn",0]
["MgO",40.304,14.53,0.3605101230647082,0.3605101230647082,3.979038389753374,3.979038389753374,3.979038389753374,"Mg",3.979038389753374]
["CaO",56.077,10.25,0.18278438575530076,0.18278438575530076,2.017435964862731,2.017435964862731,2.017435964862731,"Ca",2.017435964862731]
["Na2O",61.979,2.51,0.04049758789267332,0.08099517578534664,0.8939635622294866,0.4469817811147433,0.8939635622294866,"Na",0.4469817811147433]
["K2O",94.196,0.64,0.006794343708862372,0.013588687417724744,0.1499816660953522,0.0749908330476761,0.1499816660953522,"K",0.0749908330476761]
["H2O",18.015,{"$nulls":5},2,"H",1]
[]
["Totals",null,96,1.5989135897983615,0.7248185873110977,19.64393341135621,28.77321350225464,21.64393341135621,null,29.77321350225464]
[]
[{"$nulls":6},"Sum Si =",8]
[{"$nulls":6},"Sum Al =",11.125613202930692]
["Fe+3 lower bound",null,"No Al or Ti in T-sites",null,null,null,"Sum Mg =",16.582552218168637]
[{"$nulls":6},"Sum Ca =",18.599988183031368]
[null,null,"Sum Si = 8",null,null,null,"Sum Na =",19.493951745260855]
[{"$nulls":6},"Sum K =",19.64393341135621]
[]
["Oxygens per formula =",null,23,null,"Cations per formula =",null,8]
[{"$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,43.55,0.7248185873110977,0.7248185873110977,5.752491915065068,11.504983830130136,5.752491915065068,"Si",11.504983830130136]
["TiO2",79.866,1.28,0.016026844965316905,0.016026844965316905,0.1271963739630428,0.2543927479260856,0.1271963739630428,"Ti",0.2543927479260856]
["Al2O3",101.961,13.62,0.13358048665666283,0.26716097331332567,2.120311710971888,3.180467566457832,2.120311710971888,"Al",3.180467566457832]
["Fe2O3",159.688,{"$nulls":5},1.0627014249211997,"Fe+3",1.5940521373817995]
["FeO",71.844,9.62,0.13390123044373922,0.13390123044373922,1.0627014249211997,1.0627014249211997,0,"Fe+2",0]
["MnO",70.937,0,0,0,0,0,0,"Mn",0]
["MgO",40.304,14.53,0.3605101230647082,0.3605101230647082,2.8611732708487265,2.8611732708487265,2.8611732708487265,"Mg",2.8611732708487265]
["CaO",56.077,10.25,0.18278438575530076,0.18278438575530076,1.4506605096292944,1.4506605096292944,1.4506605096292944,"Ca",1.4506605096292944]
["Na2O",61.979,2.51,0.04049758789267332,0.08099517578534664,0.6428147705109862,0.3214073852554931,0.6428147705109862,"Na",0.3214073852554931]
["K2O",94.196,0.64,0.006794343708862372,0.013588687417724744,0.10784604020268779,0.053923020101343894,0.10784604020268779,"K",0.053923020101343894]
["H2O",18.015,{"$nulls":5},2,"H",1]
[]
["Totals",null,96,1.5989135897983615,1.0080064055897404,14.125196016112893,20.689709755270112,16.125196016112895,null,22.221060467730712]
[]
[{"$nulls":6},"Sum Si =",5.752491915065068]
[{"$nulls":6},"Sum Al =",7.999999999999998]
["Fe+3 upper bound",null,"No Al or Ti in M-sites",null,null,null,"Sum Mg =",11.923874695769925]
[{"$nulls":6},"Sum Ca =",13.37453520539922]
[null,null,"Sum Al = 8",null,null,null,"Sum Na =",14.017349975910205]
[{"$nulls":6},"Sum K =",14.125196016112893]
[]
["Oxygens per formula =",null,23,null,"Cations per formula =",null,13]
[{"$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,43.55,0.7248185873110977,0.7248185873110977,6.271652193927821,12.543304387855642,6.271652193927821,"Si",12.543304387855642]
["TiO2",79.866,1.28,0.016026844965316905,0.016026844965316905,0.13867579991478488,0.27735159982956975,0.13867579991478488,"Ti",0.27735159982956975]
["Al2O3",101.961,13.62,0.13358048665666283,0.26716097331332567,2.311669062776471,3.4675035941647065,2.311669062776471,"Al",3.4675035941647065]
["Fe2O3",159.688,{"$nulls":5},0.8861031030577635,"Fe+3",1.3291546545866453]
["FeO",71.844,9.62,0.13390123044373922,0.13390123044373922,1.1586098375284504,1.1586098375284504,0.27250673447068685,"Fe+2",0.27250673447068685]
["MnO",70.937,0,0,0,0,0,0,"Mn",0]
["MgO",40.304,14.53,0.3605101230647082,0.3605101230647082,3.1193931058524713,3.1193931058524713,3.1193931058524713,"Mg",3.1193931058524713]
["CaO",56.077,10.25,0.18278438575530076,0.18278438575530076,1.5815820868925299,1.5815820868925299,1.5815820868925299,"Ca",1.5815820868925299]
["Na2O",61.979,2.51,0.04049758789267332,0.08099517578534664,0.7008285670435113,0.35041428352175563,0.7008285670435113,"Na",0.35041428352175563]
["K2O",94.196,0.64,0.006794343708862372,0.013588687417724744,0.1175791056519832,0.0587895528259916,0.1175791056519832,"K",0.0587895528259916]
["H2O",18.015,{"$nulls":5},2,"H",1]
[]
["Totals",null,96,1.5989135897983615,1.5024177590981878,15.399989759588022,22.55694844847112,17.399989759588024,null,24]
[]
[{"$nulls":6},"Sum Si =",6.271652193927821]
[{"$nulls":6},"Sum Al =",8.721997056619077]
["Fe+3 upper bound",null,"Only Ca and Na in M(4)",null,null,null,"Sum Mg =",13]
[{"$nulls":6},"Sum Ca =",14.58158208689253]
[null,null,"Sum Mg = 13",null,null,null,"Sum Na =",15.28241065393604]
[{"$nulls":6},"Sum K =",15.399989759588022]
[]
["Oxygens per formula =",null,23,null,"Cations per formula =",null,15]
[{"$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,43.55,0.7248185873110977,0.7248185873110977,6.451617002072888,12.903234004145776,6.451617002072888,"Si",12.903234004145776]
["TiO2",79.866,1.28,0.016026844965316905,0.016026844965316905,0.142655096430971,0.285310192861942,0.142655096430971,"Ti",0.285310192861942]
["Al2O3",101.961,13.62,0.13358048665666283,0.26716097331332567,2.378002313810424,3.567003470715636,2.378002313810424,"Al",3.567003470715636]
["Fe2O3",159.688,{"$nulls":5},0,"Fe+3",0]
["FeO",71.844,9.62,0.13390123044373922,0.13390123044373922,1.1918561003438013,1.1918561003438013,1.1918561003438013,"Fe+2",1.1918561003438013]
["MnO",70.937,0,0,0,0,0,0,"Mn",0]
["MgO",40.304,14.53,0.3605101230647082,0.3605101230647082,3.2089039659041996,3.2089039659041996,3.2089039659041996,"Mg",3.2089039659041996]
["CaO",56.077,10.25,0.18278438575530076,0.18278438575530076,1.6269655214377148,1.6269655214377148,1.6269655214377148,"Ca",1.6269655214377148]
["Na2O",61.979,2.51,0.04049758789267332,0.08099517578534664,0.7209388146641751,0.36046940733208754,0.7209388146641751,"Na",0.36046940733208754]
["K2O",94.196,0.64,0.006794343708862372,0.013588687417724744,0.12095303337249916,0.06047651668624958,0.12095303337249916,"K",0.06047651668624958]
["H2O",18.015,{"$nulls":5},2,"H",1]
[]
["Totals",null,96,1.5989135897983615,1.6852021448534886,15.84189184803667,23.204219179427408,17.84189184803667,null,24.204219179427408]
[]
[{"$nulls":6},"Sum Si =",6.451617002072888]
["Fe+3 lower bound",null,"No Na in M(4)",null,null,null,"Sum Al =",8.972274412314283]
[{"$nulls":6},"Sum Mg =",13.373034478562282]
[null,null,"Sum Ca = 15",null,null,null,"Sum Ca =",14.999999999999996]
[{"$nulls":6},"Sum Na =",15.720938814664171]
[{"$nulls":6},"Sum K =",15.84189184803667]
[]
["Oxygens per formula =",null,23,null,"Cations per formula =",null,15]
[{"$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,43.55,0.7248185873110977,0.7248185873110977,6.155755465495753,12.311510930991506,6.155755465495753,"Si",12.311510930991506]
["TiO2",79.866,1.28,0.016026844965316905,0.016026844965316905,0.13611314640246408,0.27222629280492816,0.13611314640246408,"Ti",0.27222629280492816]
["Al2O3",101.961,13.62,0.13358048665666283,0.26716097331332567,2.268950673218324,3.403426009827486,2.268950673218324,"Al",3.403426009827486]
["Fe2O3",159.688,{"$nulls":5},1.1371993565982794,"Fe+3",1.705799034897419]
["FeO",71.844,9.62,0.13390123044373922,0.13390123044373922,1.1371993565982794,1.1371993565982794,0,"Fe+2",0]
["MnO",70.937,0,0,0,0,0,0,"Mn",0]
["MgO",40.304,14.53,0.3605101230647082,0.3605101230647082,3.061748414392719,3.061748414392719,3.061748414392719,"Mg",3.061748414392719]
["CaO",56.077,10.25,0.18278438575530076,0.18278438575530076,1.5523553083739319,1.5523553083739319,1.5523553083739319,"Ca",1.5523553083739319]
["Na2O",61.979,2.51,0.04049758789267332,0.08099517578534664,0.6878776355185269,0.34393881775926344,0.6878776355185269,"Na",0.34393881775926344]
["K2O",94.196,0.64,0.006794343708862372,0.013588687417724744,0.11540630759882795,0.05770315379941397,0.11540630759882795,"K",0.05770315379941397]
["H2O",18.015,{"$nulls":5},2,"H",1]
[]
["Totals",null,96,1.5989135897983615,1.7661973206388353,14.999999999999996,22.14010828454753,17.115406307598825,null,23.708707962846667]
[]
[{"$nulls":6},"Sum Si =",6.155755465495753]
["Fe+3 upper bound",null,"A-site empty (except for K)",null,null,null,"Sum Al =",8.56081928511654]
[{"$nulls":6},"Sum Mg =",12.759767056107538]
[null,null,"Sum Na = 15",null,null,null,"Sum Ca =",14.31212236448147]
[{"$nulls":6},"Sum Na =",14.999999999999996]
[{"$nulls":6},"Sum K =",15.115406307598825]
[]
["Oxygens per formula =",null,23,null,"Cations per formula =",null,16]
[{"$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,43.55,0.7248185873110977,0.7248185873110977,6.516006612301123,13.032013224602245,6.516006612301123,"Si",13.032013224602245]
["TiO2",79.866,1.28,0.016026844965316905,0.016026844965316905,0.1440788489651512,0.2881576979303024,0.1440788489651512,"Ti",0.2881576979303024]
["Al2O3",101.961,13.62,0.13358048665666283,0.26716097331332567,2.4017356882588596,3.6026035323882892,2.4017356882588596,"Al",3.6026035323882892]
["Fe2O3",159.688,{"$nulls":5},0,"Fe+3",0]
["FeO",71.844,9.62,0.13390123044373922,0.13390123044373922,1.2037512809976778,1.2037512809976778,1.2037512809976778,"Fe+2",1.2037512809976778]
["MnO",70.937,0,0,0,0,0,0,"Mn",0]
["MgO",40.304,14.53,0.3605101230647082,0.3605101230647082,3.2409300572791246,3.2409300572791246,3.2409300572791246,"Mg",3.2409300572791246]
["CaO",56.077,10.25,0.18278438575530076,0.18278438575530076,1.6432032608674563,1.6432032608674563,1.6432032608674563,"Ca",1.6432032608674563]
["Na2O",61.979,2.51,0.04049758789267332,0.08099517578534664,0.7281340603304501,0.36406703016522507,0.7281340603304501,"Na",0.36406703016522507]
["K2O",94.196,0.64,0.006794343708862372,0.013588687417724744,0.12216019100015676,0.06108009550007838,0.12216019100015676,"K",0.06108009550007838]
["H2O",18.015,{"$nulls":5},2,"H",1]
[]
["Totals",null,96,1.5989135897983615,1.77978600805656,15.999999999999998,23.4358061797304,18,null,24.4358061797304]
[]
[{"$nulls":6},"Sum Si =",6.516006612301123]
[{"$nulls":6},"Sum Al =",9.061821149525134]
["Fe+3 lower bound",null,"A-site full",null,null,null,"Sum Mg =",13.506502487801935]
[{"$nulls":6},"Sum Ca =",15.14970574866939]
[{"$nulls":6},"Sum Na =",15.877839808999841]
[{"$nulls":6},"Sum K =",15.999999999999998]