{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Mimetic Model Preparation","Instructions","Inputs"],"not_rendered":{"charts":1,"images":6,"macros":1,"external_links":0,"defined_names":1,"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":"Mimetic Model Preparation","index":0,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,16,1,17]]}
[null,null,{"$f":"MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,255)","v":"Mimetic Model Preparation"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Units"]
[{"$f":"VLOOKUP($Q$3,MassUnits[],2,)","v":1E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mass of Homogenate:","mg"]
[{"$f":"VLOOKUP($Q$4,MassUnits[],2,)","v":9.9999999999999995E-7},null,"Preparation Date:",null,null,null,null,null,null,null,null,null,null,null,null,"Final Concentration:","µg","/g"]
[{"$f":"VLOOKUP($Q$5,MassUnits[],2,)","v":1E-3},null,"Tissue homogenized:",null,null,null,null,null,null,null,null,null,null,null,null,"Stock Concentration:","mg","/mL"]
[{"$f":"A5/A4","v":1000.0000000000001},null,"Homogenization method:",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum Dispensable Volume (µL):",1]
[{"$f":"A4/A5","v":1E-3},null,"Number of Calibration Levels:",7,null,null,null,null,null,null,null,null,null,null,null,"Max % vol:",0.02]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"**this plot is solely for visualizing the separation of the calibration points**"]
[null,null,"Calibration Level(s) ------->","1","2","3","4","5","6","7","8","9","10"]
[null,null,{"$f":"CONCATENATE(\"Final Concentration (\",$Q$4,$R$4,\")\")","v":"Final Concentration (µg/g)"}]
[null,null,{"$f":"CONCATENATE(\"Mass of empty vial (\",$Q$3,\")\")","v":"Mass of empty vial (mg)"}]
[null,null,{"$f":"CONCATENATE(\"Mass of vial and \",$D$5,\" homogenate (\",$Q$3,\")\")","v":"Mass of vial and  homogenate (mg)"}]
[null,null,{"$f":"CONCATENATE(\"Mass of \",$D$5,\" homogenate (\",$Q$3,\")\")","v":"Mass of  homogenate (mg)"},{"$f":"IF(OR(D12=\"\",D13=\"\"),\"\",D13-D12)","v":""},{"$f":"IF(OR(E12=\"\",E13=\"\"),\"\",E13-E12)","v":""},"","","","","","","",""]
[null,null,"Max volume (µL)",{"$f":"IF(D14=\"\",\"\",D14*$Q$7*$A$3*1000)","v":""},"","","","","","","","",""]
[null,null,{"$f":"\"Estimated Stock Concentration Range (\"&$Q$5&\"/mL)\"","v":"Estimated Stock Concentration Range (mg/mL)"},{"$f":"IF(D15=\"\",\"\",ROUND(D11*D14/D15*$A$7,4)&\" - \"&ROUND(D11*D14/$Q$6*$A$7,4))","v":""},"","","","","","","","",""]
[null,null,"Leverage",{"$f":"IF(D11=\"\",\"\",(1/COUNTA($D11:$M11))+(1/(COUNTA($D11:$M11)-1))*((D11-AVERAGE($D11:$M11))/_xlfn.STDEV.S($D$11:$M$11))^2)","v":""},{"$f":"IF(E11=\"\",\"\",(1/COUNTA($D$11:$M$11))+(1/(COUNTA($D$11:$M$11)-1))*((E$11-AVERAGE($D$11:$M$11))/_xlfn.STDEV.S($D$11:$M$11))^2)","v":""},"","","","","","","",""]
[]
[null,null,{"$f":"CONCATENATE(\"Stock concentration (\",$Q$5,$R$5,\")\")","v":"Stock concentration (mg/mL)"},"Volume (µL)","Volume (µL)","Volume (µL)","Volume (µL)","Volume (µL)","Volume (µL)","Volume (µL)","Volume (µL)","Volume (µL)","Volume (µL)"]
[null,null,null,{"$f":"IFERROR(IF(AND(((D11*D14)/($C20*$A$6)*$A$3*1000)>=$Q$6,((D11*D14)/($C20*$A$6)*$A$3*1000)<=((D14*$Q$7*$A$3*1000))),((D11*D14)/($C20*$A$6)*$A$3*1000),\"\"),\"\")","v":""},"","","","","","","","",""]
[null,null,null,{"$f":"IFERROR(IF(AND(((D11*D14)/($C21*$A$6)*$A$3*1000)>=$Q$6,((D11*D14)/($C21*$A$6)*$A$3*1000)<=((D14*$Q$7*$A$3*1000))),((D11*D14)/($C21*$A$6)*$A$3*1000),\"\"),\"\")","v":""},"","","","","","","","",""]
[null,null,null,{"$f":"IFERROR(IF(AND(((D11*D14)/($C22*$A$6)*$A$3*1000)>=$Q$6,((D11*D14)/($C22*$A$6)*$A$3*1000)<=((D14*$Q$7*$A$3*1000))),((D11*D14)/($C22*$A$6)*$A$3*1000),\"\"),\"\")","v":""},"","","","","","","","",""]
[null,null,null,{"$f":"IFERROR(IF(AND(((D11*D14)/($C23*$A$6)*$A$3*1000)>=$Q$6,((D11*D14)/($C23*$A$6)*$A$3*1000)<=((D14*$Q$7*$A$3*1000))),((D11*D14)/($C23*$A$6)*$A$3*1000),\"\"),\"\")","v":""},"","","","","","","","",""]
[null,null,null,{"$f":"IFERROR(IF(AND(((D11*D14)/($C24*$A$6)*$A$3*1000)>=$Q$6,((D11*$D14)/($C24*$A$6)*$A$3*1000)<=((D14*$Q$7*$A$3*1000))),((D11*D14)/($C24*$A$6)*$A$3*1000),\"\"),\"\")","v":""},"","","","","","","","",""]
[]
[]
[null,null,"Additional comments:"]

{"sheet":"Instructions","index":1,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,"Instructions on the use of the Mimetic Model Calculations spreadsheet"]
[]
[null,null,null,"Cells with this color indicate that there is a dropdown list available."]
[null,null,null,"Cells with this color indicate that there is a formula in the cell and these cells should not be deleted or cleared."]
[]
[null,1,"a.","Fill in the preparation date."]
[]
[null,null,"b.","Select the tissue type for the homogenate.  A dropdown list is available which populates from the table on the \"Inputs\" tab or you can type free text."]
[]
[null,null,"c.","Select the method of homogenization.  A dropdown list is available which populates from the table on the \"Inputs\" tab or you can type free text."]
[]
[null,null,"d.","Select the number of desired levels for the Mimetic Tissue Model.  Default is 7."]
[]
[null,2,"a.","Select the desired units for the mass of the tissue homogenate.  This will automatically adjust calculations to reflect the selected units."]
[]
[null,null,"b.","Select the desired units for the final tissue concentration of the standard.  This is presented as (_)g of analyte per g of tissue.  This will automatically adjust the calculations to reflect the selected units."]
[]
[null,null,"c.","Select the desired units for the standard stock concentration which is used to spike the homogenates.  This is presented as (_)g of analyte per mL of solution.  This will automatically adjust the calculations to reflect the selected units."]
[]
[null,null,"d.","Select the smallest volume which can accurately be dispensed based on the pipettes that are available.  The default is 1 µL.  This will adjust the minimum allowable volume of stock standard solution which can be spiked into the homogenates."]
[]
[null,null,"e.","Select the maximum allowable spiking volume.  This is based on the spiked standard solution volume and the volume of the homogenate (calculated from the mass of homogenate and assuming a density of 1 g/mL) such that the ratio % must be less than or equal to this setting.  This will adjust the maximum allowable volume of stock standard solution which can be spiked into the homogenates.  The default setting is 2% but can be adjusted higher if necessary.  If this value is set too high (> 3%), it can start to impact the tissue morphology. "]
[]
[null,3,"a.","Populate first row of the calibration table with the desired tissue concentration of the standard.  The displayed units are determined from the selection in step 2b."]
[]
[null,null,"b.","Once the target tissue concentrations are populated, the leverage (h) will be calculated for each calibration point.  The leverage value will be highlighted orange if the leverage is moderately high (2≤ħ≥3) and red if the leverage value is too high (ħ>3) where ħ is the average of all leverage values  "]
[]
[null,null,"c.","Additionally, the plot at right will aid in visually determining how \"evenly spaced\" the selected calibration points are by plotting the tissue concentration against a linear response factor.  It is important to note that this is not the actual calibration curve."]
[]
[null,4,"a.","Weigh and record the mass of an empty homogenization vial"]
[]
[null,null,"b.","Add minimally 250 mg of tissue homogenate to each vial and record the mass of the vial with homogenate.  The mass of the homogenate will be calculated automatically."]
[]
[null,null,"c.","The mass of the pre-weighed vial will be subtracted from the mass of the vial and homogenate to yield the amount of tissue homogenate for each calibration level."]
[]
[null,null,"d.","From the mass of the tissue homogenate and the Max % vol selection, the maximum volume of standard which can be added will be calculated"]
[]
[null,null,"e.","Given the target final tissue concentration (3a), the mass of the tissue homogenate (4c), and the minimum (2d) and maximum (4d) allowable volume of standard  which can be added, an estimated range of stock standard concentrations will be calculated for each calibration level."]
[]
[null,null,"f.","Stock solutions of the standard can then be prepared.  When selecting concentrations for the standard solutions, refer to the ranges given in 4e as there may be overlap between several calibration levels (i.e. one standard solution can be used for multiple calibration levels)."]
[]
[null,null,"g.","When the stock solutions are prepared and their concentrations are entered in the rows in 4f, the blue portion of the table (4g) will populate with the volume of standard solution which can be added to the homogenate to yield the desired tissue concentration (3a).  In the example shown, for calibration level 5 (18 µg/g) one could add 1.01 µL of the 5 mg/mL solution, 2.51 µL of the 2 mg/mL solution, or 5.03 µL of the 1 mg/mL solution."]

{"sheet":"Inputs","index":2,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tissues",null,"Homogenisation Method",null,"Calibration Levels",null,"Units","Column1"]
[null,"Liver",null,"Ultra Turrax",null,1,null,"g",1]
[null,"Lung",null,"Precellys",null,2,null,"mg",1E-3]
[null,"Heart",null,"FastPrep",null,3,null,"µg",9.9999999999999995E-7]
[null,"Spleen",null,null,null,4,null,"ng",1.0000000000000001E-9]
[null,"Brain",null,null,null,5,null,"pg",9.9999999999999998E-13]
[null,"GI Tract",null,null,null,6,null,"fg",1.0000000000000001E-15]
[null,"Duodenum",null,null,null,7]
[null,"Jejunum",null,null,null,8]
[null,"Ileum",null,null,null,9]
[null,"Caecum",null,null,null,10]
[null,"Heart"]
[null,"Testes"]
[null,"Ovaries"]
[null,"Muscle"]
[null,"Skin"]