{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["Mauna_Loa Data","Calculations","Al2O3 vs P2O5","Al2O3 Conserved","P2O5 Conserved","Ternary Data","Ternary Plot"],"not_rendered":{"charts":4,"images":0,"macros":0,"external_links":3,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Al2O3 vs P2O5","index":2,"reason":"not_a_worksheet"},{"sheet":"Al2O3 Conserved","index":3,"reason":"not_a_worksheet"},{"sheet":"P2O5 Conserved","index":4,"reason":"not_a_worksheet"},{"sheet":"Ternary Plot","index":6,"reason":"not_a_worksheet"}],"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":"Mauna_Loa Data","index":0,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["1868 Mauna Loa Picrites",null,null,null,"Data from Mike Rhodes"]
[{"$nulls":9},"G -> Groundmass"]
[]
["Oxide","HAW5","ML88","ML120","ML87","ML84","ML85","ML86","ML83","ML85G","ML88G"]
["SiO2",48.22,48.86,47.48,47.93,47.44,47.42,51.3,51.53,51.44,51.81]
["TiO2",1.416,1.601,1.316,1.51,1.315,1.334,2.065,2.062,1.992,2.077]
["Al2O3",9.05,10.21,8.5,9.51,8.39,8.65,12.96,12.85,12.87,13.28]
["Fe2O3",1.26,1.24,1.26,1.27,1.27,1.27,1.23,1.22,1.19,1.2]
["FeO",10.2,10.06,10.18,10.28,10.3,10.26,9.93,9.89,9.68,9.71]
["MnO",0.16,0.16,0.17,0.15,0.16,0.16,0.17,0.16,0.16,0.17]
["MgO",21.26,17.2,22.45,19.24,22.47,22.16,9.07,9.28,10.02,8.52]
["CaO",7.07,8,6.65,7.55,6.66,6.74,10.16,10.07,10.05,10.35]
["Na2O",1.5,1.55,1.5,1.51,1.17,1.22,2.09,2.11,1.92,1.88]
["K2O",0.273,0.329,0.275,0.287,0.254,0.26,0.407,0.408,0.389,0.411]
["P2O5",0.17,0.19,0.15,0.18,0.15,0.15,0.23,0.24,0.24,0.26]
[null,"-------","-------","-------","-------","-------","-------","-------","-------","-------","-------"]
["Totals",100.579,99.39999999999999,99.93100000000001,99.41700000000002,99.57900000000001,99.62400000000001,99.612,99.81999999999998,99.95099999999998,99.66799999999999]

{"sheet":"Calculations","index":1,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["1868 Mauna Loa Picrites",null,null,null,"Data from Mike Rhodes"]
[{"$nulls":9},"G -> Groundmass"]
["Weight ","Percent"]
["Oxide","HAW5","ML88","ML120","ML87","ML84","ML85","ML86","ML83","ML85G","ML88G"]
["SiO2",48.22,48.86,47.48,47.93,47.44,47.42,51.3,51.53,51.44,51.81]
["TiO2",1.416,1.601,1.316,1.51,1.315,1.334,2.065,2.062,1.992,2.077]
["Al2O3",9.05,10.21,8.5,9.51,8.39,8.65,12.96,12.85,12.87,13.28]
["Fe2O3",1.26,1.24,1.26,1.27,1.27,1.27,1.23,1.22,1.19,1.2]
["FeO",10.2,10.06,10.18,10.28,10.3,10.26,9.93,9.89,9.68,9.71]
["MnO",0.16,0.16,0.17,0.15,0.16,0.16,0.17,0.16,0.16,0.17]
["MgO",21.26,17.2,22.45,19.24,22.47,22.16,9.07,9.28,10.02,8.52]
["CaO",7.07,8,6.65,7.55,6.66,6.74,10.16,10.07,10.05,10.35]
["Na2O",1.5,1.55,1.5,1.51,1.17,1.22,2.09,2.11,1.92,1.88]
["K2O",0.273,0.329,0.275,0.287,0.254,0.26,0.407,0.408,0.389,0.411]
["P2O5",0.17,0.19,0.15,0.18,0.15,0.15,0.23,0.24,0.24,0.26]
[null,"-------","-------","-------","-------","-------","-------","-------","-------","-------","-------"]
["Totals",100.579,99.39999999999999,99.93100000000001,99.41700000000002,99.57900000000001,99.62400000000001,99.612,99.81999999999998,99.95099999999998,99.66799999999999]
[]
[]
[]
["Mole Units (moles per 100 grams)"]
["SiO2",0.8025297495215111,0.8131813264541898,0.7902138636931014,0.7977032537238912,0.789548140134809,0.7892152783556629,0.8537904635100274,0.8576183739702089,0.8561204959640509,0.8622784388782558]
["FeO",0.1419703254182557,0.14002171310859338,0.14169195223116107,0.14308381816663418,0.14336219135372882,0.14280544497953956,0.13821228739247834,0.1376555410182891,0.13473262255379562,0.13515018233443754]
["MgO",0.5273994691275334,0.42668254322641463,0.5569199474088958,0.47728907742303583,0.5574160899010195,0.5497258812731016,0.22500062017811517,0.23021011634541438,0.24856738855399269,0.21135670164471235]
["CaO",0.1260721482194761,0.14265589614650762,0.11858271367178445,0.13463150198826654,0.11876103354196758,0.12018759250343267,0.18117298810606466,0.17956810927441644,0.17921146953405018,0.18456106563954422]
["Al2O3",0.08875942762428772,0.10013632663469367,0.0833652082659056,0.09327095654220731,0.08228636439422918,0.08483635900000981,0.1271074234266043,0.12602857955492786,0.12622473298614176,0.1302458783260266]
["P2O5",0.001197646975941386,0.0013385466201697842,0.0010567473317129874,0.001268096798055585,0.0010567473317129874,0.0010567473317129874,0.001620345908626581,0.0016907957307407799,0.0016907957307407799,0.0018316953749691783]
[]
[]
["(CaO+Al2O3) - (SiO2) - (MgO+FeO) Ternary in Mole Units"]
["MF/Sum",39.684439721553424,34.92401599316888,41.31906627871044,37.69021618101452,41.432489568397436,41.05664067607555,23.812808587546627,24.02653580044288,24.811363327606674,22.742756807350602]
["S/Sum",47.57899703444293,50.11354217471056,46.73682057965762,48.463767993239784,46.680877468562976,46.7885377472393,55.975843527767424,56.01392288962808,55.41746950693809,56.595091590763666]
["CA/Sum",12.736563244003657,14.962441832120556,11.944113141631941,13.846015825745702,11.886632963039588,12.15482157668514,20.211347884685946,19.959541309929044,19.771167165455246,20.662151601885736]
["Total",100.00000000000001,100,100,100,100,99.99999999999999,100,100,100,100]
[]
[]
["(CaO) - (SiO2) - (MgO+FeO) Ternary in Mole Units"]
["MF/Sum",41.88871416037965,37.220940393108265,43.462001702378025,39.95426280469053,43.55128610983858,43.23094715758392,25.97761757192585,26.181637444745153,27.018988534633394,24.868682105168304]
["S/Sum",50.22177510372862,53.4094694761698,49.16073760949013,51.374980541577,49.06806884330649,49.26639806919698,61.06457585984893,61.03818849020763,60.34831514318037,61.885432509601934]
["C/Sum",7.889510735891738,9.369590130721932,7.377260688131845,8.67075665373248,7.380645046854925,7.502654773219094,12.957806568225227,12.780174065047222,12.632696322186243,13.245885385229764]
["Total",100,99.99999999999999,99.99999999999999,100.00000000000001,99.99999999999999,100,100,100,100.00000000000001,100]
[]
[]
["Plotting Coordinates for P2O5 Normalied (Pearce type) Graph"]
["(M+F)/P",558.9040910988355,423.3728192919616,661.0964406293858,489.21572591375394,663.1464875513684,655.3423940328743,224.1576355004691,217.56954472704538,226.69800031956257,189.1727678708478]
["S/P",670.0887370342992,607.5106493870525,747.7793792127819,629.0554908324318,747.1494050095698,746.8344179079638,526.9186406214384,507.22766705500544,506.34176583173837,470.75428079451547]
[]
[]
["Plotting Coordinates for Al2O3 Normalied (Pearce type) Graph"]
["(M+F)/A",7.5413937703517355,5.659327392769221,8.380137399905863,6.651297666374169,8.516335439215183,8.163142954456132,2.8575271040744816,2.9189066373899277,3.0366474306574363,2.6604057528161222]
["S/A",9.041628264194784,8.120742529539239,9.478940677177919,8.552536430382931,9.595127284420172,9.302795259701934,6.717077889656319,6.8049515197180135,6.782509859284429,6.620389450788092]

{"sheet":"Ternary Data","index":5,"n_rows":77,"n_cols":11,"rows_kept":77,"cut":false,"hidden":false,"merged":[[10,1,10,3],[6,1,6,3],[7,1,7,3],[8,1,8,4]],"flags":["formulas_cached_only"]}
["Ternary Plotting Template"]
[{"$nulls":8},"Instructions (Scroll right for more)"]
["Test for Olivine Fractionation",{"$nulls":4},"Calculated by",null,null,"(1) Enter the a title for your triangle.",null,"This spreadsheet is set up to plot 3 data sets of 30 points"]
[{"$nulls":5},"spreadsheet",null,null,"(2) Enter labels for the three corners.",null,"each.  If you wish to add additional data sets: "]
["Enter Triangle",{"$nulls":7},"(3) Enter data for your data points in the box.",null,"(1) Create more data boxes like the three that are present."]
["Labels for apices in these boxes",{"$nulls":4},"x-value","y-value",null,"(4) Fill down the x-value and y-value formulas (Cols F&G) to",null,"(2) Switch to the Triangle Sheet."]
["MgO+FeO","Label at origin",null,null,null,0,0,null,"      match the number of data points to plot.  (Delete extra",null,"(3) Select \"Source Data\" from the \"Chart\" menu."]
["SiO2","Label at upper vertex",null,null,null,0.5000000000000001,0.8660254037844386,null,"      x-value and y-value formulas, which say #DIV/0!)",null,"(4) Choose the Series Tab and press the Add button."]
["CaO+Al2O3","Label at right basal vertex",null,null,null,1,0,null,"(5) Repeat (4) for up to 3 data sets of 30 points using",null,"(5) Define the x-values and y-values data ranges following"]
[{"$nulls":5},0,0,null,"      the appropriate data box (scroll down to see boxes).",null,"      the examples already defined."]
[null,"Enter Data below",{"$nulls":6},"(6) Look at the Triangle sheet and print if you wish."]
["Mauna Loa Data","MgO+FeO","SiO2","CaO+Al2O3",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"(7) Do not change the size of the triangle.  It is adjusted"]
["Mauna Loa Data",39.684439721553424,47.57899703444293,12.736563244003657,null,0.3652606176122512,0.4120462011841204,null,"      to be equilateral."]
[null,34.92401599316888,50.11354217471056,14.962441832120556,null,0.4001921291947584,0.43399600596922205,null,"(8) If you want to improve the plot, print it to a file:"]
[null,41.31906627871044,46.73682057965762,11.944113141631941,null,0.3531252343146076,0.40475273914098847,null,"       Destination: File"]
[null,37.69021618101452,48.463767993239784,13.846015825745702,null,0.380778998223656,0.41970854245260836,null,"       Options: Save as File"]
[null,41.432489568397436,46.680877468562976,11.886632963039588,null,0.35227071697321083,0.40426825758724155,null,"       Format: EPS Mac Standard Preview"]
[null,41.05664067607555,46.7885377472393,12.15482157668514,null,0.35549090450304804,0.40520062295036374,null,"       Postscript Level: Level 1 Compatible"]
[null,23.812808587546627,55.975843527767424,20.211347884685946,null,0.48199269648569665,0.48476502493309337,null,"       Font Inclusion: All"]
[null,24.02653580044288,56.01392288962808,19.959541309929044,null,0.4796650275474309,0.4850948018804056,null,"(9) You should be able to open this file in Illustrator.  You"]
[null,24.811363327606674,55.41746950693809,19.771167165455246,null,0.47479901918924294,0.4799293640645787,null,"      will have to ungroup the objects to work with them."]
[null,22.742756807350602,56.595091590763666,20.662151601885736]
{"$rows_empty":20}
["Olivine",{"$nulls":4},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Olivine",2,1,0,null,0.16666666666666669,0.28867513459481287]
[{"$nulls":5},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
{"$rows_empty":27}
["Orthopyroxene",{"$nulls":4},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Orthopyroxene",1,1,0,null,0.25000000000000006,0.4330127018922193]
[{"$nulls":5},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]