{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["PS#1","PS#2-I","PS#2-II","PS#6","PS#7","Sheet2","Sheet3"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":1,"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":"1904","formulas":"cached_only"}

{"sheet":"PS#1","index":0,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Geology 255: Problem set 1:  Geothermal Gradients"]
[]
["T(z)= Q*z/K + Ao*z(b-z/2)/K + Ts",null,null,"for z < b"]
["T(z)= Q*z/K + Ao*b^2/(2K) + Ts",null,null,"for b ≤ z ≤ 100 km"]
[]
[]
["Surface T (To)",15]
["Q",30]
["Ao",2]
["b",10]
["K",2.5]
[]
[]
["depth (z)","Temp(°C)","P(bars)","T","D (km)","T"]
[0,15,1000,279,3.7037037037037037,279,685]
[2,53.4,3733,506,13.825925925925926,506,506]
[4,88.6,11000,843,40.74074074074074,843]
[6,120.6]
[8,149.4,3733,506,13.825925925925926,506]
[10,175,1000,685,3.7037037037037037,685]
[12,199]
[14,223]
[16,247]
[18,271]
[20,295]
[25,355]
[30,415]
[35,475]
[40,535]
[45,595]
[50,655]
[55,715]
[60,775]
[65,835]
[70,895]
[75,955]
[80,1015]
[85,1075]
[90,1135]
[95,1195]
[100,1255]

{"sheet":"PS#2-I","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Minerals","Rock #1","Rock #2","Rock #3"]
["Quartz",20,20,5]
["Plagioclase",40,55,10]
["Orthoclase",25,2,65]
["Biotite",10,5,5]
["Hornblende","--",13,10]
["Cpx","--",5,"--"]
["Sphene","tr","tr",5]
["Zircon","tr","tr","--"]
["Muscovite",5,"--","--"]
["Epidote","--","tr","--"]
["Allanite","--","tr","--"]
["Total:",100,100,100]
[]
["Q",23.52941176470588,25.97402597402597,6.25]
["A",29.411764705882355,2.5974025974025974,81.25]
["P",47.05882352941176,71.42857142857143,12.5]
[]
["IUGS Name:","granite","tonalite","qtz syenite"]

{"sheet":"PS#2-II","index":2,"n_rows":139,"n_cols":17,"rows_kept":139,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["CIPW Norm:  Ol-Tholeiite (p.99 in Philpotts)",{"$nulls":7},"MgO+FeO=",0.3588965043025143,"D=",0.06425725635367097]
[{"$nulls":8},"MgO+FeO=",0.25886323901006003]
[{"$nulls":10},"en/fs=",2.5570931981479563,"hy=",0.25886323901006003,"ol=",0.06425725635367097]
[{"$nulls":12},"hy2=",0.1303487263027181]
[]
["Oxide",{"$nulls":9},"di=",0.1000332652924543,"hy",null,"ol"]
[null,"wt%","mol prop","ap","ilm","or","ab","an","mag","wo","en","fs","en","fs","fo","fa"]
["SiO2",49.2,0.818771842236645,null,null,0.7869247084786832,0.5739527820508032,0.39467251324129765,null,null,null,0.19460598265638906,null,-0.06425725635367097]
["TiO2",2.3,0.02878598247809762,null,0]
["Al2O3",13.3,0.1304433111023931,null,null,0.12513545547606614,0.0896401344047528,0]
["Fe2O3",1.3,0.008140772747197695,{"$nulls":5},0]
["FeO",9.7,0.1350034794711204,null,0.10903678089491171,null,null,null,0.10089600814771402,null,null,0.07277381406392172,null,0.036129082244528925,null,0]
["MnO",0.2,0.0028192839018889204]
["MgO",10.4,0.2580004961548003,{"$nulls":7},0.1860894249461383,null,0.092385430462813,null,0]
["CaO",10.9,0.1943651925820257,0.1896733996972071,null,null,null,0.1000332652924543,null,0]
["Na2O",2.2,0.035495321071313334,null,null,null,0]
["K2O",0.5,0.005307855626326964,null,null,0]
["P2O5",0.2,0.0014089468122578375,0]
["total:",100.20000000000002]
[]
["Mole Proportion of norm",null,null,0.0014089468122578375,0.02878598247809762,0.005307855626326964,0.035495321071313334,0.0896401344047528,0.008140772747197695,0.1000332652924543,0.071911071208662,0.028122194083792303,0.09370399448332531,0.036644731819392797,0.092385430462813,0.036129082244528925]
["Wt% of norm",null,null,0.4737020077492075,4.368272841051313,2.954723991507431,18.615876089060993,24.938781792746273,1.8849145218861543,11.620864429024415,7.219152438637578,3.710161065474719,9.406944006181028,4.834539468932492,6.4993150330588945,3.6811921898950524]
["sum Wt%:",100.20843987520554]
[]
["Density (g/cm^3)",null,null,3.2,4.7,2.57,2.62,2.76,5.18,2.9,3.4,3.9,3.4,3.9,3.2,4.39,"Totals"]
["Mode:",null,null,0.14803187742162735,0.929419753415173,1.1496980511702066,7.105296217198852,9.035790504618216,0.36388311233323445,4.007194630698074,2.1232801290110523,0.9513233501217228,2.766748237112067,1.2396255048544853,2.0310359478309046,0.8385403621628822,32.6898676779485]
["Normalized Mode:",null,null,0.45283718759585173,2.8431432105249197,3.516985943463316,21.735469495313524,27.640951605054866,1.1131373057796068,12.258216124261633,6.495223993957451,2.9101474484200924,8.463626296592274,3.7920786864814864,6.213044261421022,2.5651384411339593,100]
[]
["Q:",0]
["A:",6.649195315682464]
["P:",93.35080468431755]
[]
[]
["CIPW Norm:  Andesite (p.99 in Philpotts)",{"$nulls":7},"MgO+FeO=",0.16144665671323544,"D=",0.21722793218418734]
[{"$nulls":8},"MgO+FeO=",0.14537822242537846]
[{"$nulls":10},"en/fs=",1.4954476662831022,"hy=",0.14537822242537846]
[]
[]
["Oxide",{"$nulls":9},"di=",0.016068434287856995,"hy"]
[null,"wt%","mol prop","ap","ilm","or","ab","an","mag","wo","en","fs","en","fs","qtz"]
["SiO2",60,0.9985022466300548,null,null,0.9411774058657236,0.5636362635617546,0.39474302318527976,null,null,null,0.3626061546095658,null,0.21722793218418734,0]
["TiO2",1,0.012515644555694618,null,0]
["Al2O3",16,0.1569242840329541,null,null,0.14737014390556558,0.0844466201882374,0]
["Fe2O3",1.9,0.011898052476673554,{"$nulls":5},0]
["FeO",6.2,0.08629088378566459,null,0.07659452313185888,null,null,null,0.06469647065518533,null,null,0.05825737176925659,null,0]
["MnO",0.2,0.0028192839018889204]
["MgO",3.9,0.09675018605805011,{"$nulls":7},0.08712085065612185,null,0,null,0]
["CaO",5.9,0.10520684736091299,0.10051505447609439,null,null,null,0.016068434287856995,null,0]
["Na2O",3.9,0.06292352371732818,null,null,null,0]
["K2O",0.9,0.009554140127388535,null,null,0]
["P2O5",0.2,0.0014089468122578375,0]
["total:",100.10000000000004]
[]
["Mole Proportion of norm",null,null,0.0014089468122578375,0.012515644555694618,0.009554140127388535,0.06292352371732818,0.0844466201882374,0.011898052476673554,0.016068434287856995,0.009629335401928256,0.006439098885928739,0.08712085065612185,0.058257371769256605,0.21722793218418734]
["Wt% of norm",null,null,0.4737020077492075,1.8992490613266584,5.318503184713375,33.00087124878994,23.493894202569525,2.754875070448995,1.8666700112203471,0.9666889809995776,0.8495103160205786,8.746062197368072,7.6858950575180245,13.053226444947818]
["sum Wt%:",100.10914778367211]
[]
["Density (g/cm^3)",null,null,3.2,4.7,2.57,2.62,2.76,5.18,2.9,3.4,3.9,3.4,3.9,2.65,"Totals"]
["Mode:",null,null,0.14803187742162735,0.4040955449631188,2.069456492106372,12.595752385034329,8.512280508177366,0.5318291641793427,0.6436793142139128,0.28432028852928753,0.2178231579539945,2.572371234520021,1.9707423224405192,4.925745828282196,34.87612811782208]
["Normalized Mode:",null,null,0.4244504347544861,1.1586594234255654,5.933733484161785,36.1156844661256,24.407183272811466,1.5249088499235448,1.8456157519532272,0.8152289370218159,0.6245623287600108,7.375736279640262,5.650691257305734,14.123545514116536,100.00000000000006]
[]
["Q:",17.52732662572042]
["A:",7.363766044646988]
["P:",75.10890732963259]
[]
[]
["CIPW Norm:  Dacite (p.99 in Philpotts)",{"$nulls":7},"MgO+FeO=",0.03687634253537432,"D=",0.40591675623000073]
[{"$nulls":8},"MgO+FeO=",0.035703602804041015]
[{"$nulls":10},"en/fs=",1.5345651395899538,"hy=",0.035703602804041015]
[]
[]
["Oxide",{"$nulls":9},"di=",0.0011727397313333054,"hy"]
[null,"wt%","mol prop","ap","ilm","or","ab","an","mag","wo","en","fs","en","fs","qtz"]
["SiO2",69.7,1.1599267765019137,null,null,0.968843973954143,0.5332195789880249,0.44396583849670834,null,null,null,0.44162035903404173,null,0.40591675623000073,0]
["TiO2",0.4,0.0050062578222778474,null,0]
["Al2O3",15.2,0.1490780698313064,null,null,0.11723093607334462,0.04462687024565826,0]
["Fe2O3",1.1,0.006888346170705743,{"$nulls":5},0]
["FeO",1.9,0.02644398051496173,null,0.021437722692683882,null,null,null,0.014549376521978139,null,null,0.014086677926067112,null,0]
["MnO",0,0]
["MgO",0.9,0.02232696601339618,{"$nulls":7},0.0216169248779739,null,0,null,0]
["CaO",2.7,0.04814550641940086,0.04579960997699156,null,null,null,0.0011727397313333054,null,0]
["Na2O",4.5,0.07260406582768636,null,null,null,0]
["K2O",3,0.03184713375796178,null,null,0]
["P2O5",0.1,0.0007044734061289187,0]
["total:",99.50000000000001]
[]
["Mole Proportion of norm",null,null,0.0007044734061289187,0.0050062578222778474,0.03184713375796178,0.07260406582768636,0.04462687024565826,0.006888346170705743,0.0011727397313333054,0.0007100411354222793,0.00046269859591102614,0.021616924877973898,0.014086677926067116,0.40591675623000073]
["Wt% of norm",null,null,0.23685100387460375,0.7596996245306633,17.728343949044586,38.07792836398839,12.415641571044583,1.5949276723652077,0.1362371745889901,0.07128102958504262,0.061043825758541684,2.1701230884997997,1.8584554187860347,24.391537881860746]
["sum Wt%:",99.50207060392718]
[]
["Density (g/cm^3)",null,null,3.2,4.7,2.57,2.62,2.76,5.18,2.9,3.4,3.9,3.4,3.9,2.65,"Totals"]
["Mode:",null,null,0.07401593871081368,0.1616382179852475,6.89818830702124,14.533560444270378,4.498420859074125,0.3079010950511984,0.046978336065169,0.020965008701483125,0.01565226301501069,0.6382714966175882,0.47652703045795763,9.204353917683301,36.87647291465351]
["Normalized Mode:",null,null,0.20071317254802354,0.43832342198057045,18.706204150777456,39.41147104254435,12.198620159485477,0.8349526695890933,0.12739378891765252,0.056851990020857744,0.04244511955152574,1.7308366179563768,1.2922250768418833,24.959962789786736,100.00000000000003]
[]
["Q:",26.197463330718474]
["A:",19.633646949884465]
["P:",54.168889719397086]
[]
[]
[]
["CIPW Norm:  Example (p.91 in Philpotts)",{"$nulls":7},"MgO+FeO=",0.1926545090356282,"D=",0.11322321352211229]
[{"$nulls":8},"MgO+FeO=",0.1331696036787644]
[{"$nulls":10},"en/fs=",1.1184146743865409,"hy=",0.1331696036787644]
[]
[]
["Oxide",{"$nulls":9},"di=",0.05948490535686379,"hy"]
[null,"wt%","mol prop","ap","ilm","or","ab","an","mag","wo","en","fs","en","fs","qtz"]
["SiO2",53.8,0.8953236811449491,null,null,0.7997822798710638,0.5093660165603184,0.3653626279146043,null,null,null,0.2463928172008767,null,0.11322321352211229,0]
["TiO2",2,0.025031289111389236,null,0]
["Al2O3",13.9,0.13632797175362887,null,null,0.12040440487464799,0.07200169432285708,0]
["Fe2O3",2.6,0.01628154549439539,{"$nulls":5},0]
["FeO",9.3,0.1294363256784969,null,0.10722432046899658,null,null,null,0.09094277497460118,null,null,0.06286285933009231,null,0]
["MnO",0.2,0.0028192839018889204]
["MgO",4.1,0.10171173406102703,{"$nulls":7},0.07030674434867211,null,0,null,0]
["CaO",7.9,0.14087018544935806,0.13148659967972087,null,null,null,0.05948490535686379,null,0]
["Na2O",3,0.0484027105517909,null,null,null,0]
["K2O",1.5,0.01592356687898089,null,null,0]
["P2O5",0.4,0.002817893624515675,0]
["total:",98.7]
[]
["Mole Proportion of norm",null,null,0.002817893624515675,0.025031289111389236,0.01592356687898089,0.0484027105517909,0.07200169432285708,0.01628154549439539,0.05948490535686379,0.03140498971235492,0.02807991564450887,0.0703067443486721,0.06286285933009231,0.11322321352211229]
["Wt% of norm",null,null,0.947404015498415,3.7984981226533168,8.864171974522293,25.385285575992256,20.031591377562066,3.7698290437723085,6.910361455306867,3.1527469172233102,3.7045832709800552,7.058094065163192,8.29349703141908,6.803582900543728]
["sum Wt%:",98.71964575063689]
[]
[]
[]
["Mineral","density (g/cm^3)"]
["apatite",3.2]
["ilmenite",4.7]
["orthoclase",2.57]
["albite",2.62]
["anorthite",2.76]
["magnetite",5.18]
["wollastonite",2.9]
["enstatite",3.4]
["ferrosilite",3.9]
["forsterite",3.2]
["fayalite",4.39]
["quartz",2.65]

{"sheet":"PS#6","index":3,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["KFASH"]
[null,"St","Ms","Bt","Ky","Qtz","H2O"]
["SiO2",3.75,3,3,1,1,0]
["Al2O3",4.5,1.5,0.5,1,0,0]
["FeO",2,0,3,0,0,0]
["K2O",0,0.5,0.5,0,0,0]
["H2O",1,1,1,0,0,1]
[]
["Inverse:",0,0,3.700743415417188e-17,-2,1]
[null,0,0,-0.33333333333333337,0.6666666666666669,0.6666666666666664]
[null,0,0,0.3333333333333333,1.3333333333333333,-0.6666666666666665]
[null,0,1,0.3333333333333332,7.333333333333333,-5.166666666666666]
[null,1,-1,-0.33333333333333337,-5.833333333333333,1.4166666666666663]
["Solution:"]
["St",1]
["Ms",0.6666666666666664]
["Bt",-0.6666666666666665]
["Ky",-5.166666666666666]
["Qtz",1.4166666666666663]
["H2O",-1]
[]
[]
["Reaction:","1.0St + 0.7Ms + 1.4Qtz = 5.2Ky + 0.7Bt + 1.0 H2O"]
[]
[]
[]
["CFMAS"]
[]
[null,"Grt","an1","Opx","Cpx","an2","qtz"]
["SiO2",3,2.4,2,2,2.5,1]
["Al2O3",1,0.8,0,0,0.75,0]
["FeO",1.5,0,0.7,0.2,0,0]
["MgO",0.65,0,1.2,0.8,0,0]
["CaO",0.85,0.6,0.1,0.9,0.5,0]
[]
["Inverse:",0.06284367635506645,-0.3770620581303999,0.9426551453260016,-0.6755695208169664,0.2513747054202673]
[null,-3.423507462686566,10.541044776119397,-4.477611940298505,8.208955223880594,1.3059701492537312]
[null,-0.21013354281225421,1.260801256873526,-0.6520031421838174,1.6339355852317352,-0.8405341712490181]
[null,0.2641398271798896,-1.5848389630793387,0.21209740769834973,-0.6520031421838167,1.05655930871956]
[null,3.567949725058915,-9.407698350353492,3.519245875883737,-7.8554595443833435,-1.7282010997643362]
["Solution:"]
["Grt",0.06284367635506645]
["an1",-3.423507462686566]
["Opx",-0.21013354281225421]
["Cpx",0.2641398271798896]
["an2",3.567949725058915]
["qtz",-1]

{"sheet":"PS#7","index":4,"n_rows":65,"n_cols":8,"rows_kept":65,"cut":false,"hidden":false,"merged":[[15,5,15,6]],"flags":["formulas_cached_only"]}
["Part I.  AFM diagram."]
[]
["Matrix:","Al2O3","FeO","MgO","Ms","Qtz","Mineral","<- enter AFM mineral analysis here."]
["SiO2",0,0,0,3,1,2.71]
["Al2O3",1,0,0,1.5,0,0.865,"<- be sure to divide Al by 2."]
["FeO",0,1,0,0,0,1.09]
["MgO",0,0,1,0,0,1.27]
["K2O",0,0,0,0.5,0,0.405,"<- be sure to divide K by 2."]
[]
["Inverse:",0,1,0,0,-3]
[null,0,0,1,0,0]
[null,0,0,0,1,0]
[null,0,0,0,0,2]
[null,1,0,0,0,-6]
["Solution:"]
["Al2O3",-0.3500000000000001,null,null,null,"AFM Plotting Cordinates"]
["FeO",1.09,null,null,null,"A:",-0.1741293532338309,"<- if A is negative, F&M are renormalized to 1."]
["MgO",1.27,null,null,null,"F:",0.461864406779661]
["Ms",0.81,null,null,null,"M:",0.538135593220339]
["Qtz",0.2799999999999998]
[]
[null,null,"Grt","Bt","St","Crd"]
[null,"A:",0.260025873221216,-0.1741293532338309,0.7023110066588328,0.5]
[null,"F:",0.5821474773609314,0.461864406779661,0.2311006658832746,0.18090452261306533]
[null,"M:",0.15782664941785252,0.538135593220339,0.06658832745789268,0.31909547738693467]
[]
[]
["Cations:","Si",2.97,2.71,7.6,5.01]
[null,"Al",2.01,1.73,17.93,3.98]
[null,"Fe",2.25,1.09,2.95,0.72]
[null,"Mg",0.61,1.27,0.85,1.27]
[null,"K",0,0.81,0,0]
[]
["Cations/2:","Si",2.97,2.71,7.6,5.01]
[null,"Al/2",1.005,0.865,8.965,1.99]
[null,"Fe",2.25,1.09,2.95,0.72]
[null,"Mg",0.61,1.27,0.85,1.27]
[null,"K/2",0,0.405,0,0]
[]
[]
["Part III.  Balanced Reaction."]
[]
[null,"St","Bt","Ky","Ms","Grt","H2O","Qtz"]
["SiO2",7.6,2.71,1,3,2.97,0,1]
["Al2O3",8.965,0.865,1,1.5,1.005,0,0]
["FeO",2.95,1.09,0,0,2.25,0,0]
["MgO",0.85,1.27,0,0,0.61,0,0]
["K2O",0,0.405,0,0.5,0,0,0]
["H2O",2,1,0,1,0,1,0]
[]
["Inverse:",-0.2547938274492878,0.25479382744928786,0.24534044887453665,-0.08417399840960134,0.7643814823478635,0]
[null,0.013131306440650166,-0.013131306440650166,-0.2908526273478166,1.0305170399618195,-0.03939391932195078,0]
[null,1.9594824824304853,-0.9594824824304857,-2.5662717280996827,1.5061119840137396,-8.878447447291459,0]
[null,-0.01063635821692646,0.010636358216926526,0.23559062815173137,-0.8347188023690739,2.03190907465078,0]
[null,0.32770162975781797,-0.32770162975781797,0.26367779539077196,-0.38886679033335975,-0.9831048892734537,0]
[null,0.507092706674852,-0.5070927066748521,-0.4354188985529881,-0.027450240773542994,-3.5212781200245558,1]
[]
["Solution:"]
["St",-0.2547938274492878]
["Bt",0.013131306440650166]
["Ky",1.9594824824304853]
["Ms",-0.01063635821692646]
["Grt",0.32770162975781797]
["H2O",0.507092706674852]
["Qtz",-1]

{"sheet":"Sheet2","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

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