{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Buffer","Data"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Buffer","index":0,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[16,1,16,2],[6,1,6,2]]}
[null,"pKa"]
[null,"Chad Jafvert, Purdue University"]
[]
[]
[]
[]
[null,"Input Values"]
[null,"1.  pH (activity-based) of your solution? ==> ",6.2]
[null,"2.  What is the pKa of the buffer? ==>",7.2]
[null,"3. Acid form of the buffer is neutral (0), minus 1 (-1),"]
[null,"     or minus 2 (-2) charged species? (0, 1, or 2)==>",1]
[null,"4.  What is the total concentration of the buffer (M)? ==>",0.04]
[null,"5.  Set the ionic strength at a given value (0),"]
[null,"     or let it float (1)?   (0 or 1) ==>",0]
[null," 6.  If set, what is the ionic strength (M)? ==>",0.15]
[]
[null,"Results (click the \"Calculate\" button to run the VBA program)"]
[null,"Ionic Strength (M) ==>",0.15]
[null,"Amount of acid form (HA) to add (M) ==>",3.266657349751538E-2]
[null,"Amount of base form (A-) to add (M) ==>",7.3334265024846239E-3]
[null,"NaCl to add to adjust Ionic Strength (M) ==>",9.5333146995030746E-2]

{"sheet":"Data","index":1,"n_rows":145,"n_cols":11,"rows_kept":145,"cut":false,"hidden":false,"merged":[[2,6,2,10],[20,6,20,8],[2,0,2,4]]}
[]
[]
["Lines",null,null,null,null,null,"Symbols"]
["pH","pH","pOH","p(HA)","p(A)",null,"pH","pH","pOH","p(HA)","p(A)"]
[0,0,14,1.3979400701962477,8.2466783032184683,null,0,0,14,1.3979400701962477,8.2466783032184683]
[0.1,0.1,13.9,1.3979400861264277,8.1466783191486485,null,1,1,13,1.3979406239137475,7.2466788569359668]
[0.2,0.2,13.8,1.3979401061813352,8.0466783392035559,null,2,2,12,1.3979461610499182,6.2466843940721386]
[0.30000000000000004,0.30000000000000004,13.7,1.3979401314289668,7.9466783644511869,null,3,3,11,1.3980015285291352,5.2467397615513551]
[0.4,0.4,13.6,1.3979401632138497,7.8466783962360704,null,4,4,10,1.3985548154385037,4.2472930484607243]
[0.5,0.5,13.5,1.3979402032286432,7.7466784362508632,null,5,5,9,1.4040492583225754,3.2527874913447961]
[0.60000000000000009,0.60000000000000009,13.4,1.3979402536042782,7.6466784866264987,null,6,6,8,1.4554785966319117,2.3042168296541323]
[0.70000000000000007,0.70000000000000007,13.3,1.397940317023437,7.546678550045657,null,7,7,7,1.7811532970159178,1.6298915300381389]
[0.8,0.8,13.2,1.3979403968634145,7.4466786298856356,null,8,8,6,2.5788246318208201,1.4275628648430412]
[0.9,0.9,13.1,1.3979404973759704,7.3466787303981906,null,9,9,5,3.5522566560266453,1.4009948890488662]
[1,1,13,1.3979406239137475,7.2466788569359668,null,10,10,4,4.5495082324812168,1.3982464655034377]
[1.1000000000000001,1.1000000000000001,12.9,1.3979407832153186,7.1466790162375391,null,11,11,3,5.5492324310659971,1.3979706640882184]
[1.2000000000000002,1.2000000000000002,12.8,1.3979409837640318,7.0466792167862522,null,12,12,2,6.5492048412888106,1.3979430743110313]
[1.3,1.3,12.7,1.3979412362397707,6.9466794692619906,null,13,13,1,7.5492020822146886,1.3979403152369108]
[1.4000000000000001,1.4000000000000001,12.6,1.3979415540876863,6.846679787109907,null,14,14,0,8.5492018063063142,1.3979400393285346]
[1.5,1.5,12.5,1.3979419542341731,6.746680187256394]
[1.6,1.6,12.4,1.3979424579882298,6.6466806910104506,null,"pKa and pH lines and symbles"]
[1.7000000000000002,1.7000000000000002,12.3,1.3979430921761822,6.5466813251984028,null,7.2,0,6.2]
[1.8,1.8,12.2,1.3979438905701944,6.4466821235924145,null,7.2,1,6.2]
[1.9000000000000001,1.9000000000000001,12.1,1.3979448956866181,6.3466831287088379,null,7.2,2,6.2]
[2,2,12,1.3979461610499182,6.2466843940721386,null,7.2,3,6.2]
[2.1,2.1,11.9,1.3979477540426892,6.1466859870649095,null,7.2,4,6.2]
[2.2000000000000002,2.2000000000000002,11.8,1.3979497594934613,6.0466879925156816,null,7.2,5,6.2]
[2.3000000000000003,2.3000000000000003,11.7,1.3979522841932328,5.9466905172154521,null,7.2,6,6.2]
[2.4000000000000004,2.4000000000000004,11.6,1.3979554625810628,5.8466936956032827,null,7.2,7,6.2]
[2.5,2.5,11.5,1.3979594639011963,5.7466976969234169,null,7.2,8,6.2]
[2.6,2.6,11.4,1.3979645012123736,5.6467027342345943,null,7.2,9,6.2]
[2.7,2.7,11.3,1.3979708427283453,5.5467090757505648,null,7.2,10,6.2]
[2.8000000000000003,2.8000000000000003,11.2,1.3979788260922876,5.4467170591145075,null,7.2,11,6.2]
[2.9000000000000004,2.9000000000000004,11.1,1.3979888763433606,5.346727109365581,null,7.2,12,6.2]
[3,3,11,1.3980015285291352,5.2467397615513551,null,7.2,13,6.2]
[3.1,3.1,10.9,1.3980174561632337,5.1467556891854542,null,7.2,14,6.2]
[3.2,3.2,10.8,1.3980375070359894,5.0467757400582096]
[3.3000000000000003,3.3000000000000003,10.7,1.3980627482730037,4.9468009812952234]
[3.4000000000000004,3.4000000000000004,10.6,1.3980945230218742,4.846832756044094]
[3.5,3.5,10.5,1.3981345217553529,4.7468727547775735]
[3.6,3.6,10.4,1.3981848719397583,4.6469231049619788]
[3.7,3.7,10.3,1.3982482507673011,4.5469864837895209]
[3.8000000000000003,3.8000000000000003,10.199999999999999,1.3983280268345937,4.4470662598568138]
[3.9000000000000004,3.9000000000000004,10.1,1.3984284381205618,4.3471666711427819]
[4,4,10,1.3985548154385037,4.2472930484607243]
[4.1000000000000005,4.1000000000000005,9.8999999999999986,1.3987138627825035,4.1474520958047236]
[4.2,4.2,9.8000000000000007,1.3989140087401011,4.0476522417623215]
[4.3,4.3,9.6999999999999993,1.3991658464891166,3.9479040795113369]
[4.4000000000000004,4.4000000000000004,9.6,1.3994826839233796,3.8482209169455999]
[4.5,4.5,9.5,1.3998812302313139,3.7486194632535343]
[4.6000000000000005,4.6000000000000005,9.3999999999999986,1.4003824508150373,3.6491206838372574]
[4.7,4.7,9.3000000000000007,1.4010126287383438,3.5497508617605642]
[4.8000000000000007,4.8000000000000007,9.1999999999999993,1.4018046777368067,3.4505429107590264]
[4.9000000000000004,4.9000000000000004,9.1,1.402799758772054,3.3515379917942743]
[5,5,9,1.4040492583225754,3.2527874913447961]
[5.1000000000000005,5.1000000000000005,8.8999999999999986,1.405617190605994,3.1543554236282141]
[5.2,5.2,8.8000000000000007,1.4075830853150086,3.0563213183372286]
[5.3000000000000007,5.3000000000000007,8.6999999999999993,1.4100454134728957,2.9587836464951156]
[5.4,5.4,8.6,1.4131255811210803,2.8618638141433004]
[5.5,5.5,8.5,1.4169724759591986,2.7657107089814192]
[5.6000000000000005,5.6000000000000005,8.3999999999999986,1.4217674756213132,2.6705057086435335]
[5.7,5.7,8.3000000000000007,1.4277297061119789,2.5764679391341994]
[5.8000000000000007,5.8000000000000007,8.1999999999999993,1.4351211636458545,2.4838593966680746]
[5.9,5.9,8.1,1.444251076773722,2.3929893097959423]
[6,6,8,1.4554785966319117,2.3042168296541323]
[6.1000000000000005,6.1000000000000005,7.8999999999999995,1.4692125974526731,2.2179508304748934]
[6.2,6.2,7.8,1.4859071260979149,2.1346453591201358]
[6.3000000000000007,6.3000000000000007,7.6999999999999993,1.5060509898262169,2.0547892228484366]
[6.4,6.4,7.6,1.5301502885233194,1.9788885215455396]
[6.5,6.5,7.5,1.5587035438956662,1.9074417769178871]
[6.6000000000000005,6.6000000000000005,7.3999999999999995,1.5921705055120121,1.8409087385342322]
[6.7,6.7,7.3,1.6309375383444633,1.779675771366684]
[6.8000000000000007,6.8000000000000007,7.1999999999999993,1.6752842288477172,1.7240224618699371]
[6.9,6.9,7.1,1.7253567818210749,1.6740950148432951]
[7,7,7,1.7811532970159178,1.6298915300381389]
[7.1000000000000005,7.1000000000000005,6.8999999999999995,1.8425239640658841,1.5912621970881045]
[7.2,7.2,6.8,1.9091861345300143,1.5579243675522347]
[7.3000000000000007,7.3000000000000007,6.6999999999999993,1.9807511644252516,1.5294893974474717]
[7.4,7.4,6.6,2.0567579060526815,1.505496139074902]
[7.5,7.5,6.5,2.1367072849661168,1.4854455179883379]
[7.6000000000000005,7.6000000000000005,6.3999999999999995,2.2200933620735732,1.4688315950957933]
[7.7,7.7,6.3,2.3064280238035995,1.4551662568258201]
[7.8000000000000007,7.8000000000000007,6.1999999999999993,2.3952582627562715,1.4439964957784914]
[7.9,7.9,6.1,2.486176425012133,1.4349146580343533]
[8,8,6,2.5788246318208201,1.4275628648430412]
[8.1,8.1,5.9,2.6728948889483348,1.4216331219705562]
[8.2000000000000011,8.2000000000000011,5.7999999999999989,2.7681263405016829,1.4168645735239025]
[8.3000000000000007,8.3000000000000007,5.6999999999999993,2.8643008777072585,1.4130391107294784]
[8.4,8.4,5.6,2.9612380070789301,1.4099762401011506]
[8.5,8.5,5.5,3.0587895944004684,1.4075278274226892]
[8.6,8.6,5.4,3.1568348661087957,1.4055730991310169]
[8.7000000000000011,8.7000000000000011,5.2999999999999989,3.2552758758863796,1.4040141089085996]
[8.8000000000000007,8.8000000000000007,5.1999999999999993,3.3540335253641294,1.4027717583863497]
[8.9,8.9,5.0999999999999996,3.453044152344682,1.4017823853669023]
[9,9,5,3.5522566560266453,1.4009948890488662]
[9.1,9.1,4.9000000000000004,3.6516301062539136,1.4003683392761346]
[9.2000000000000011,9.2000000000000011,4.7999999999999989,3.7511317751086066,1.3998700081308266]
[9.3000000000000007,9.3000000000000007,4.6999999999999993,3.8507355287094707,1.3994737617316912]
[9.4,9.4,4.5999999999999996,3.9504205211607824,1.3991587541830026]
[9.5,9.5,4.5,4.0501701388405715,1.3989083718627926]
[9.6000000000000014,9.6000000000000014,4.3999999999999986,4.1499711501714911,1.3987093831937107]
[9.7000000000000011,9.7000000000000011,4.2999999999999989,4.2498130228528499,1.3985512558750699]
[9.8000000000000007,9.8000000000000007,4.1999999999999993,4.349687376816088,1.3984256098383085]
[9.9,9.9,4.0999999999999996,4.4495875467099442,1.3983257797321649]
[10,10,4,4.5495082324812168,1.3982464655034377]
[10.100000000000001,10.100000000000001,3.8999999999999986,4.6494452206256813,1.3981834536479008]
[10.200000000000001,10.200000000000001,3.7999999999999989,4.7493951620136245,1.3981333950358441]
[10.3,10.3,3.6999999999999993,4.849355394932342,1.3980936279545622]
[10.4,10.4,3.5999999999999996,4.9493238042216756,1.3980620372438963]
[10.5,10.5,3.5,5.0492987091905412,1.3980369422127623]
[10.600000000000001,10.600000000000001,3.3999999999999986,5.1492787744653228,1.3980170074875424]
[10.700000000000001,10.700000000000001,3.2999999999999989,5.249262939098112,1.398001172120332]
[10.8,10.8,3.1999999999999993,5.3492503602073418,1.3979885932295615]
[10.9,10.9,3.0999999999999996,5.4492403681795931,1.3979786012018138]
[11,11,3,5.5492324310659971,1.3979706640882184]
[11.100000000000001,11.100000000000001,2.8999999999999986,5.6492261262891912,1.3979643593114108]
[11.200000000000001,11.200000000000001,2.7999999999999989,5.7492211181617314,1.3979593511839514]
[11.3,11.3,2.6999999999999993,5.84921714002353,1.3979553730457501]
[11.4,11.4,2.5999999999999996,5.9492139800500663,1.3979522130722868]
[11.5,11.5,2.5,6.0492114699775374,1.3979497029997585]
[11.600000000000001,11.600000000000001,2.3999999999999986,6.1492094761457201,1.3979477091679393]
[11.700000000000001,11.700000000000001,2.2999999999999989,6.2492078923822865,1.3979461254045069]
[11.8,11.8,2.1999999999999993,6.3492066343501588,1.3979448673723793]
[11.9,11.9,2.0999999999999996,6.4492056350571225,1.3979438680793432]
[12,12,2,6.5492048412888106,1.3979430743110313]
[12.100000000000001,12.100000000000001,1.8999999999999986,6.6492042107751956,1.3979424437974153]
[12.200000000000001,12.200000000000001,1.7999999999999989,6.7492037099397759,1.3979419429619957]
[12.3,12.3,1.6999999999999993,6.8492033121116487,1.397941545133869]
[12.4,12.4,1.5999999999999996,6.9492029961052753,1.397941229127496]
[12.5,12.5,1.5,7.0492027450923267,1.3979409781145475]
[12.600000000000001,12.600000000000001,1.3999999999999986,7.1492025457055526,1.3979407787277718]
[12.700000000000001,12.700000000000001,1.2999999999999989,7.2492023873269407,1.3979406203491613]
[12.8,12.8,1.1999999999999993,7.3492022615222972,1.3979404945445177]
[12.9,12.9,1.0999999999999996,7.4492021615920905,1.3979403946143114]
[13,13,1,7.5492020822146886,1.3979403152369108]
[13.100000000000001,13.100000000000001,0.89999999999999858,7.6492020191629706,1.3979402521851898]
[13.200000000000001,13.200000000000001,0.79999999999999893,7.7492019690792002,1.3979402021014209]
[13.3,13.3,0.69999999999999929,7.8492019292962452,1.3979401623184651]
[13.4,13.4,0.59999999999999964,7.9492018976955157,1.3979401307177375]
[13.5,13.5,0.5,8.0492018725941641,1.3979401056163858]
[13.600000000000001,13.600000000000001,0.39999999999999858,8.1492018526554535,1.3979400856776723]
[13.700000000000001,13.700000000000001,0.29999999999999893,8.2492018368175675,1.3979400698397886]
[13.8,13.8,0.19999999999999929,8.3492018242370882,1.3979400572593099]
[13.9,13.9,9.9999999999999645E-2,8.4492018142440592,1.3979400472662802]
[14,14,0,8.5492018063063142,1.3979400393285346]