{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Introduction","SASB","SBSA","WASB","WBSA","SBWA","SAWB","Data"],"not_rendered":{"charts":6,"images":18,"macros":1,"external_links":0,"defined_names":2,"comments":7,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Introduction","index":0,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Foreword"]
[]
["Welcome to the titration curve generator!"]
["You can generate and explore the shapes of various titration curves involving strong/weak acids/bases."]
["Each worksheet contains a specific type of titration curve."]
[]
["The values of all cells highlighted in yellow can be changed."]
["The values of cells highlighted in orange will be automatically updated based on your input  in the yellow boxes."]
["Place your mouse over cells with a small red arrow to view more information."]
["Please report bugs or send feedback to leong_jia_hui_grace@moe.edu.sg"]
[]
["Thank you! :)"]
["Grace Leong, MOE, 2016"]
[]
[]
["Legend",null,null,null,"Things to note"]
["SA","strong acid",null,null,"1. You need to click the graph after selecting the indicator for the graph to refresh."]
["SB","strong base",null,null,"2. The maximum data points allowed for certain excel functions is 255."]
["WA","weak acid",null,null,"2. If there are more than 255 data points the autoupdate features in cells D17-D20 will not work."]
["WB","weak base"]
[]
[]
["Version 1"]
["Last modified "]
[{"$f":"TODAY()","v":"2016-04-25"}]

{"sheet":"SASB","index":1,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Titration of","SA","against","SB",null,null,null,"Burette Vol","pH","Type of solution"]
["[acid] =",1,"moldm-3",null,null,null,null,0,{"$f":"pHSA(B2*IF(C6=\"diprotic\",2,1))","v":0},"SA"]
["[base] =",1,"moldm-3",null,null,null,null,1,3.4762106259211917E-2,"SA + Neutral Salt"]
[null,null,null,null,null,null,null,2,6.9635928141394424E-2,"SA + Neutral Salt"]
["Volume of",{"$f":"B1","v":"SA"},"in conical flask =",25,"cm3",null,null,3,0.104735350520013,"SA + Neutral Salt"]
[{"$f":"B5","v":"SA"},"is","monoprotic",null,null,null,null,4,0.14017870316503681,"SA + Neutral Salt"]
[{"$f":"D1","v":"SB"},"is","monoprotic",null,null,null,null,5,0.17609125905568127,"SA + Neutral Salt"]
["Volume of",{"$f":"D1","v":"SB"},"req for neutralisation =",{"$f":"B2*D5*IF(C6=\"monoprotic\",1,2)/(B3*IF(C7=\"monoprotic\",1,2))","v":25},"cm3",null,null,6,0.21260809288144372,"SA + Neutral Salt"]
[null,null,null,null,null,null,null,7,0.24987747321659989,"SA + Neutral Salt"]
["Stop titration at (auto titration only)",null,null,50,"cm3",null,null,8,0.28806501849961358,"SA + Neutral Salt"]
["Data points in increment units of",null,null,1,"cm3",null,null,9,0.32735893438633035,"SA + Neutral Salt"]
["Total data points (auto titration only)",null,null,{"$f":"INT(D10/D11)","v":50},null,null,null,10,0.36797678529459443,"SA + Neutral Salt"]
[null,null,null,null,null,null,null,11,0.41017446508904926,"SA + Neutral Salt"]
[null,null,"Choice of indicator",null,null,null,null,12,0.45425837176015821,"SA + Neutral Salt"]
[null,null,"none",null,null,null,null,13,0.50060235056918534,"SA + Neutral Salt"]
[null,null,null,null,null,null,null,14,0.54967192186827418,"SA + Neutral Salt"]
[null,null,"Current titre added",{"$f":"INDEX(H:H, COUNTA(H:H), 1)","v":50},null,null,null,15,0.6020599913279624,"SA + Neutral Salt"]
[null,null,"Current pH",{"$f":"INDEX(I:I, COUNTA(I:I), 1)","v":13.522878745280337},null,null,null,16,0.65854134728041058,"SA + Neutral Salt"]
[null,null,"Colour in flask",{"$f":"IF(C15=\"none\",\"NA\",IF(C15=\"phenolphthalein\",IF(D18>8,IF(D18>10,\"Red\",\"Pink\"),\"Colourless\"),IF(C15=\"screened methyl orange\",IF(D18>3,IF(D18>4,\"Green\",\"Grey\"),\"Purple\"))))","v":"NA"},null,null,null,17,0.72015930340595691,"SA + Neutral Salt"]
[null,null,"Type of Solution",{"$f":"INDEX(J:J, COUNTA(J:J), 1)","v":"xs SB + Neutral salt"},null,null,null,18,0.78837041556532972,"SA + Neutral Salt"]
[null,null,null,null,null,null,null,19,0.86530142610254379,"SA + Neutral Salt"]
[null,null,null,null,null,null,null,20,0.95424250943932487,"SA + Neutral Salt"]
[null,null,null,null,null,null,null,21,1.0606978403536116,"SA + Neutral Salt"]
[null,null,null,null,null,null,null,22,1.1949766032160551,"SA + Neutral Salt"]
[null,null,null,null,null,null,null,23,1.3802112417116061,"SA + Neutral Salt"]
[null,null,null,null,null,null,null,24,1.6901960800285136,"SA + Neutral Salt"]
[null,null,null,null,null,null,null,25,7,"Neutral Salt"]
[null,null,null,null,null,null,null,26,12.292429823902063,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,27,12.585026652029182,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,28,12.752845385118874,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,29,12.869666231504993,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,30,12.958607314841775,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,31,13.029963223377443,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,32,13.089223184341765,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,33,13.139661993429007,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,34,13.183390497797181,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,35,13.221848749616356,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,36,13.256062850147458,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,37,13.286789556549371,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,38,13.314602802853255,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,39,13.339948061694351,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,40,13.363177902412826,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,41,13.384576047114056,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,42,13.404374118677447,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,43,13.42276359239707,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,44,13.439904510215573,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,45,13.455931955649724,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,46,13.470960946014843,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,47,13.485090184390938,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,48,13.498404975897136,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,49,13.51097952198063,"xs SB + Neutral salt"]
[null,null,null,null,null,null,null,50,13.522878745280337,"xs SB + Neutral salt"]

{"sheet":"SBSA","index":2,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Titration of","SB","against","SA",null,null,null,"Burette Vol","pH","Type of solution"]
["[acid] =",1,"moldm-3",null,null,null,null,0,{"$f":"pHSB(B3*IF(C6=\"diprotic\",2,1))","v":14},"SB"]
["[base] =",1,"moldm-3",null,null,null,null,1,13.965237893740788,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,2,13.930364071858605,"SB + Neutral Salt"]
["Volume of",{"$f":"B1","v":"SB"},"in conical flask =",25,"cm3",null,null,3,13.895264649479987,"SB + Neutral Salt"]
[{"$f":"B5","v":"SB"},"is","monoprotic",null,null,null,null,4,13.859821296834964,"SB + Neutral Salt"]
[{"$f":"D1","v":"SA"},"is","monoprotic",null,null,null,null,5,13.823908740944319,"SB + Neutral Salt"]
["Volume of",{"$f":"D1","v":"SA"},"req for neutralisation =",{"$f":"B3*D5*IF(C6=\"monoprotic\",1,2)/(B2*IF(C7=\"monoprotic\",1,2))","v":25},"cm3",null,null,6,13.787391907118556,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,7,13.7501225267834,"SB + Neutral Salt"]
["Stop titration at (auto titration only)",null,null,24,"cm3",null,null,8,13.711934981500386,"SB + Neutral Salt"]
["Data points in increment units of",null,null,0.05,"cm3",null,null,9,13.67264106561367,"SB + Neutral Salt"]
["Total data points (auto titration only)",null,null,{"$f":"INT(D10/D11)","v":480},null,null,null,10,13.632023214705406,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,11,13.58982553491095,"SB + Neutral Salt"]
[null,null,"Choice of indicator",null,null,null,null,12,13.545741628239842,"SB + Neutral Salt"]
[null,null,"none",null,null,null,null,13,13.499397649430815,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,14,13.450328078131726,"SB + Neutral Salt"]
[null,null,"Current titre added",{"$f":"INDEX(H:H, COUNTA(H:H), 1)","v":26},null,null,null,15,13.397940008672037,"SB + Neutral Salt"]
[null,null,"Current pH",{"$f":"INDEX(I:I, COUNTA(I:I), 1)","v":1.7075701760979363},null,null,null,16,13.34145865271959,"SB + Neutral Salt"]
[null,null,"Colour in flask",{"$f":"IF(C15=\"none\",\"NA\",IF(C15=\"phenolphthalein\",IF(D18>8,IF(D18>10,\"Red\",\"Pink\"),\"Colourless\"),IF(C15=\"screened methyl orange\",IF(D18>3,IF(D18>4,\"Green\",\"Grey\"),\"Purple\"))))","v":"NA"},null,null,null,17,13.279840696594043,"SB + Neutral Salt"]
[null,null,"Type of Solution",{"$f":"INDEX(J:J, COUNTA(J:J), 1)","v":"xs SA + Neutral salt"},null,null,null,18,13.21162958443467,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,19,13.134698573897456,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,20,13.045757490560675,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,21,12.939302159646388,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,22,12.805023396783945,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,23,12.619788758288394,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24,12.309803919971486,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.05,12.287084600328036,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.1,12.26316103081291,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.15,12.237895390063315,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.2,12.211124877490022,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.25,12.18265502855807,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.3,12.152251127457927,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.35,12.119626213065381,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.4,12.084424288045406,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.45,12.046196386860533,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.5,12.004364805402449,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.55,11.95816886164104,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.6,11.906578328198263,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.65,11.848148778171833,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.7,11.780764859319522,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.75,11.701146923590294,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.8,11.603800659557685,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.85,11.478426109701498,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.9,11.30189944109644,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,24.95,11.000434505140582,"SB + Neutral Salt"]
[null,null,null,null,null,null,null,25,7,"Neutral Salt"]
[null,null,null,null,null,null,null,25.05,3.0004340708591246,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.1,2.6998377126400777,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.15,2.5241796915147336,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.2,2.3996737280814457,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.25,2.3031960574204891,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.3,2.2244467237489798,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.35,2.1579314173778736,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.4,2.1003705582659928,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.45,2.0496486633652848,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.5,2.0043213737826426,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.55,1.9633584638780692,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.6,1.9259992533596959,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.65,1.8916661061369744,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.7,1.859909925854393,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.75,1.8303747831935504,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.8,1.8027737187695265,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.85,1.7768720185123992,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.9,1.7524752859167034,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,25.95,1.729420589556844,"xs SA + Neutral salt"]
[null,null,null,null,null,null,null,26,1.7075701760979363,"xs SA + Neutral salt"]

{"sheet":"WASB","index":3,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Titration of","WA","against","SB",null,null,null,"Burette Vol","pH","Type of Solution "]
["[acid] =",1,"moldm-3",null,null,null,null,0,{"$f":"pHWA(B2,B4)","v":2.4430283238465815},"WA"]
["[base] =",1,"moldm-3"]
["Ka of WA =",1.2999999999999999E-5,"moldm-3"]
["Volume of",{"$f":"B1","v":"WA"},"in conical flask =",25,"cm3"]
[{"$f":"B5","v":"WA"},"is","monoprotic"]
[{"$f":"D1","v":"SB"},"is","monoprotic"]
["Volume of",{"$f":"D1","v":"SB"},"req for neutralisation =",{"$f":"B2*D5*IF(C6=\"monoprotic\",1,2)/(B3*IF(C7=\"monoprotic\",1,2))","v":25},"cm3"]
[]
["Stop titration at (auto titration only)",null,null,50,"cm3"]
["Data points in increment units of",null,null,1,"cm3"]
["Total data points (auto titration only)",null,null,{"$f":"INT(D10/D11)","v":50}]
[]
[null,null,"Choice of indicator"]
[null,null,"none"]
[]
[null,null,"Current titre added",{"$f":"INDEX(H:H, COUNTA(H:H), 1)","v":0}]
[null,null,"Current pH",{"$f":"INDEX(I:I, COUNTA(I:I), 1)","v":2.4430283238465815}]
[null,null,"Colour in flask",{"$f":"IF(C15=\"none\",\"NA\",IF(C15=\"phenolphthalein\",IF(D18>8,IF(D18>10,\"Red\",\"Pink\"),\"Colourless\"),IF(C15=\"screened methyl orange\",IF(D18>3,IF(D18>4,\"Green\",\"Grey\"),\"Purple\"))))","v":"NA"}]
[null,null,"Type of Solution",{"$f":"INDEX(J:J, COUNTA(J:J), 1)","v":"WA"}]

{"sheet":"WBSA","index":4,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Titration of","WB","against","SA",null,null,null,"Burette Vol","pH","Type of Solution "]
["[acid] =",1,"moldm-3",null,null,null,null,0,{"$f":"pHWB(B3,B4)","v":11.627636252551653},"WB"]
["[base] =",1,"moldm-3"]
["Kb of WB =",1.8E-5,"moldm-3"]
["Volume of",{"$f":"B1","v":"WB"},"in conical flask =",25,"cm3"]
[{"$f":"B5","v":"WB"},"is","monoprotic"]
[{"$f":"D1","v":"SA"},"is","monoprotic"]
["Volume of",{"$f":"D1","v":"SA"},"req for neutralisation =",{"$f":"B3*D5*IF(C6=\"monoprotic\",1,2)/(B2*IF(C7=\"monoprotic\",1,2))","v":25},"cm3"]
[]
["Stop titration at (auto titration only)",null,null,50,"cm3"]
["Data points in increment units of",null,null,1,"cm3"]
["Total data points (auto titration only)",null,null,{"$f":"INT(D10/D11)","v":50}]
[]
[null,null,"Choice of indicator"]
[null,null,"none"]
[]
[null,null,"Current titre added",{"$f":"INDEX(H:H, COUNTA(H:H), 1)","v":0}]
[null,null,"Current pH",{"$f":"INDEX(I:I, COUNTA(I:I), 1)","v":11.627636252551653}]
[null,null,"Colour in flask",{"$f":"IF(C15=\"none\",\"NA\",IF(C15=\"phenolphthalein\",IF(D18>8,IF(D18>10,\"Red\",\"Pink\"),\"Colourless\"),IF(C15=\"screened methyl orange\",IF(D18>3,IF(D18>4,\"Green\",\"Grey\"),\"Purple\"))))","v":"NA"}]
[null,null,"Type of Solution",{"$f":"INDEX(J:J, COUNTA(J:J), 1)","v":"WB"}]

{"sheet":"SBWA","index":5,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Titration of","SB","against","WA",null,null,null,"Burette Vol","pH","Type of Solution "]
["[acid] =",1,"moldm-3",null,null,null,null,0,{"$f":"pHSB(B3*IF(C6=\"diprotic\",2,1))","v":14},"SB"]
["[base] =",1,"moldm-3"]
["Ka of WA =",1.2999999999999999E-5,"moldm-3"]
["Volume of",{"$f":"B1","v":"SB"},"in conical flask =",25,"cm3"]
[{"$f":"B5","v":"SB"},"is","monoprotic"]
[{"$f":"D1","v":"WA"},"is","monoprotic"]
["Volume of",{"$f":"D1","v":"WA"},"req for neutralisation =",{"$f":"B3*D5*IF(C6=\"monoprotic\",1,2)/(B2*IF(C7=\"monoprotic\",1,2))","v":25},"cm3"]
[]
["Stop titration at (auto titration only)",null,null,50,"cm3"]
["Data points in increment units of",null,null,1,"cm3"]
["Total data points (auto titration only)",null,null,{"$f":"INT(D10/D11)","v":50}]
[]
[null,null,"Choice of indicator"]
[null,null,"none"]
[]
[null,null,"Current titre added",{"$f":"INDEX(H:H, COUNTA(H:H), 1)","v":0}]
[null,null,"Current pH",{"$f":"INDEX(I:I, COUNTA(I:I), 1)","v":14}]
[null,null,"Colour in flask",{"$f":"IF(C15=\"none\",\"NA\",IF(C15=\"phenolphthalein\",IF(D18>8,IF(D18>10,\"Red\",\"Pink\"),\"Colourless\"),IF(C15=\"screened methyl orange\",IF(D18>3,IF(D18>4,\"Green\",\"Grey\"),\"Purple\"))))","v":"NA"}]
[null,null,"Type of Solution",{"$f":"INDEX(J:J, COUNTA(J:J), 1)","v":"SB"}]

{"sheet":"SAWB","index":6,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Titration of","SA","against","WB",null,null,null,"Burette Vol","pH","Type of Solution "]
["[acid] =",1,"moldm-3",null,null,null,null,0,{"$f":"pHSA(B2*IF(C6=\"diprotic\",2,1))","v":0},"SA"]
["[base] =",1,"moldm-3"]
["Kb of WB =",1.8E-5,"moldm-3"]
["Volume of",{"$f":"B1","v":"SA"},"in conical flask =",25,"cm3"]
[{"$f":"B5","v":"SA"},"is","monoprotic"]
[{"$f":"D1","v":"WB"},"is","monoprotic"]
["Volume of",{"$f":"D1","v":"WB"},"req for neutralisation =",{"$f":"B2*D5*IF(C6=\"monoprotic\",1,2)/(B3*IF(C7=\"monoprotic\",1,2))","v":25},"cm3"]
[]
["Stop titration at (auto titration only)",null,null,50,"cm3"]
["Data points in increment units of",null,null,1,"cm3"]
["Total data points (auto titration only)",null,null,{"$f":"INT(D10/D11)","v":50}]
[]
[null,null,"Choice of indicator"]
[null,null,"none"]
[]
[null,null,"Current titre added",{"$f":"INDEX(H:H, COUNTA(H:H), 1)","v":0}]
[null,null,"Current pH",{"$f":"INDEX(I:I, COUNTA(I:I), 1)","v":0}]
[null,null,"Colour in flask",{"$f":"IF(C15=\"none\",\"NA\",IF(C15=\"phenolphthalein\",IF(D18>8,IF(D18>10,\"Red\",\"Pink\"),\"Colourless\"),IF(C15=\"screened methyl orange\",IF(D18>3,IF(D18>4,\"Green\",\"Grey\"),\"Purple\"))))","v":"NA"}]
[null,null,"Type of Solution",{"$f":"INDEX(J:J, COUNTA(J:J), 1)","v":"SA"}]

{"sheet":"Data","index":7,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["protic"]
["monoprotic"]
["diprotic"]
[]
["indicator"]
["none"]
["screened methyl orange"]
["phenolphthalein"]