{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions For Use","INPUT","overview","Disclaimer","choices"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":"Instructions For Use","index":0,"n_rows":105,"n_cols":4,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
["Instructions for use"]
["Enable Macro"]
["Click on \"enable content\" ",null,null,"when following message appears by opening the file"]
[]
[]
["File Save"]
["Save the file as a Excel Macro Enabled Worksheet (*.xlsm) in order to preserve the macro code"]
[]
["Data Input"]
["Identification elements of a specific run"]
["Operator: Free text"]
["Lot Number assay: Free Text"]
["Lot Number CAL/RVC: Free text"]
["Test Number: Free Text"]
["Test Date: Free Text"]
[]
["Identification of the INNOTEST type"]
["Possibility to check one of the five \"radio buttons\".  \n"]
["Each radio button corresponds to a possible INNOTEST."]
["One radio button has to be checked in order to progress with the calculations"]
[]
["Specification of the sample dilution factor"]
["This dilution factor only applies to samples"]
["This dilution factor doesn't apply  to CAL, RVC or blank because these have a automaticaly a dilution factor of 1:1"]
["Generic: When this radio button is checked, all samples will have the same dilution factor. If checked, a pop-up text will ask to fill in the factor in cell O2"]
["The area \"Dilution 1/x\" will be filled in during calculation and will be available on the test specific worksheet."]
["Individual: When this radio button is checked, a sample dilution factor for each of the samples has to be provided into the dilution plate frame (C20:N27)"]
["Exceptions"]
["When nothing is checked the 1:1 dilution is used by default"]
["When the \"Generic\" button is checked and no dilution factor is provided, the dilution factor 1:1 will be used by default"]
["When the \"Generic\" button is checked and the dilution factor is provided, the individual value provided into the dilution plate frame will overrule the generic value for that particular sample"]
[]
["CAL values"]
["CAL values have to be filled in correctly and the CAL values series are lot specific!"]
["In the absence of CAL values, the calculations will not work."]
["The CAL values are provided by Fujirebio Europe and have to be filled into R9-R16"]
["According to the test type, 6 or 8 CAL values have to be filled in. In case of 6 CAL values for INNOTEST β-Amyloid(1-40), rename the selected calibrators to CAL 1 (highest calibrator) to CAL6 (lowest calibrator). "]
["The CAL values are filled in from high concentration to low concentration. So CAL1 contains the highest concentration"]
[]
["RVC values"]
["RVC values have to be filled in correctly and the RVC values  are lot specific!"]
["The RVC range values are provided by Fujirebio Europe and have to be filled into Q20-R21"]
["A RVC range contains two values: an upper and a lower range value.  Put these values in the corresponding cell."]
[]
["SampleID"]
["Region: C9:N16"]
["Select two adjacent cells with the left mouse button."]
["Put the cursor on the selected cells and push the right mouse button: a sample selection window with five possibilities pops up"]
["1)","Calibrator No: accepts a number from 1-8 --> enter --> fills in CAL+number into the selected cells"]
["2)","Run Validation Control No: accepts a number from 1-2 --> enter --> fills in RVC + number into the selected cells"]
["3)","SampleID: Free text --> enter --> fills in SampleID into the selected cells. Do not use \"RVC\" as (part of) sampleID. "]
["4)","Blank:by selection fills in \"blank\" into the selected cells"]
["5)","Undo: by selection clear the selected cells"]
["Two adjacent cells must be selected"]
["A name (CAL, RVC, sampleID and blank) can only be introduced once as a duplo. "]
["In those cases where a blank has to be introduced more than once, there is a possibility to introduce an extra blank as sampleID but with a different name than \"blank\"."]
[]
["Dilution 1:x"]
["Region: C20:N27"]
["Fill in the denominator (x) of the dilution fraction (1:x)"]
["The denominator must be greater than 0"]
["When not filled in, the denominator is put to the default value of 1. This is not visible in the INPUT sheet, only on the test specific output sheet."]
["The value for CAL and RVC are always 1, no matter what has been filled in in this section"]
["The value in this section overrules the value of O2 (generic dilution factor)"]
[]
["Optical Density"]
["Region: C31:N38"]
["Fill in the OD's from the reader by using three methods"]
["1)","put in manually"]
["2)","copy/paste the values from another excel sheet with comparable lay-out (paste special: values!)"]
["3)","import an output file from a particular elisa plate reader by using the \"Import data from file\" button"]
[]
["Start Calculation"]
["When all data, mentioned above, is provided, the \"calculate\" button can be selected launching the calculation macro"]
[]
["Data Output"]
["Test-type worksheet"]
["The application creates another worksheet, similar to the \"INPUT\" worksheet but with calculated data in place"]
["The name of the new worksheet is the name of the test type followed by a consecutive number"]
["The CAL and RVC sections have two extra columns: \"Average OD\" and \"% Difference\""]
["The RVC section has a third column with the calculated concentration from the mean OD"]
["The concentration section is filled in. The dilution factor is taken into account!"]
["When the sample OD value exceeds the highest or lowest average CAL OD value, the concentration is not calculated and will be represented respectively by \">\" or \"<\" + respective CAL concentration value"]
["When selecting the \"Merge/Unmerge\" button, the concentration of the average OD's are viewed instead of the individual concentrations and vice versa"]
["Out of range OD values will be omitted in this average calculation"]
["An overview of the sigmoïdal curve fitting parameters and a representation of the curve fitting itself is presented at the bottom of this worksheet"]
["Visual inspection of the plotted data points and fitted curve, together with the calculated R-square value allow a quick evaluation of the fitted result."]
["If the observed curve does not match the data-points and the calculated R-square value is below 0.98, then the accuracy of the converted OD-values is doubtful."]
["Run acceptance criteria should be verified with the corresponding product package inserts."]
[]
["Overview worksheet"]
["The overview worksheet is a representation of all sample values for all test types performed."]
["Only the latest calculation of a particular test type is stored in this worksheet. The test type name and consecutive number is mentioned on top of the particular columns"]
[]
["Color indications"]
[null,"An entry field in the \"INPUT\" worksheet"]
[null,"When the %Difference between duplo values (CAL, RVC and Samples) is higher than 20%, the respective OD cell will be red"]
[null,"When the calculated concentration of the RVC is out of range, the respective cell will be orange"]
[null,"When the measured OD of the sample is higher than the mean OD of the highest calibrator or lower than the mean OD of the lowest calibrator, the cell will be brown"]
[null,"When the OD of the \"Blank\" is above 0,100 OD, the cell will be yellow - For hTAU Ag the reference value will be 0,200 OD"]
["Data Print"]
["The calculated worksheets per test type can be printed by the \"Print\" button on the respective worksheet"]
["The \"Overview\" worksheet can be printed by the default excel print facilities"]
["Copy Sample ID's"]
["This button will transfer all Sample ID's from a test-type worksheet to the \"INPUT\" worksheet"]

{"sheet":"INPUT","index":1,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[[17,16,17,17],[1,2,1,6],[2,2,2,6],[3,2,3,6],[4,2,4,6],[7,16,7,17],[5,2,5,6],[1,16,1,18]]}
[null,null,"INNOTEST "]
["Operator:",null,null,null,null,null,null,null,null,null,null,null,null,"1:"]
["Lot Number assay:"]
["Lot Number CAL/RVC:"]
["Test Number:",null,null,null,null,null,null,null,null,null,null,null,"Default value = 1:1"]
["Test Date:"]
[null,"SampleID (select adjacent cells / right mouse click / only duplo's accepted)"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,null,null,"Concentration pg/ml"]
[null,"A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAL1"]
[null,"B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAL2"]
[null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAL3"]
[null,"D",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAL4"]
[null,"E",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAL5"]
[null,"F",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAL6"]
[null,"G",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAL7"]
[null,"H",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAL8"]
[]
[null,"Dilution 1:x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Concentration range pg/ml"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,null,null,"low","high"]
[null,"A",null,null,null,null,null,null,null,null,null,null,null,null,null,"RVC1"]
[null,"B",null,null,null,null,null,null,null,null,null,null,null,null,null,"RVC2"]
[null,"C"]
[null,"D"]
[null,"E"]
[null,"F"]
[null,"G"]
[null,"H"]
[]
[null,"Optical Density (copy - paste from reader output / paste values only!)"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"A"]
[null,"B"]
[null,"C"]
[null,"D"]
[null,"E"]
[null,"F"]
[null,"G"]
[null,"H"]
[]
[null,"Concentration (taking into account the dilution factor)"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"A"]
[null,"B"]
[null,"C"]
[null,"D"]
[null,"E"]
[null,"F"]
[null,"G"]
[null,"H"]

{"sheet":"overview","index":2,"n_rows":96,"n_cols":17,"rows_kept":96,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,4,0,6],[0,7,0,9],[0,10,0,12],[0,13,0,15]]}
[null,"hTAU Ag",null,null,"PHOSPHO-TAU",null,null,"β-Amyloid(1-42)",null,null,"β-Amyloid(1-40)",null,null,"β-Amyloid(1-42)HS_1",null,null,"Ratio"]
["SampleID","Average OD","%Dif","Concentration","Average OD","%Dif","Concentration","Average OD","%Dif","Concentration","Average OD","%Dif","Concentration","Average OD","%Dif","Concentration","b-Amyloid(1-42) / β-Amyloid(1-40)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J3<>\"\",IF(M3<>\"\",J3/M3,\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J35<>\"\",IF(M35<>\"\",J35/M35,\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J67<>\"\",IF(M67<>\"\",J67/M67,\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Disclaimer","index":3,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,1,5,12],[7,1,13,12],[15,1,16,12],[20,1,22,12],[24,1,25,12]]}
[null,"Disclaimers :"]
[]
["-","For research use only, not for use in diagnostic procedures."]
[]
["-","Fujirebio Europe shall not be liable for any special, incidental or consequential damages, including, without limitation, lost revenue and/or savings, and/or lost or loss of prospective economic advantage, resulting from the use or misuse of the above-mentioned macro."]
[]
[]
["-","Fujirebio Europe DOES NOT WARRANT THAT THE MACROS WILL BE ERROR FREE OR WILL MEET CUSTOMER’S NEED OR EXPECTATIONS.  Fujirebio Europe MAKES NO WARRANTY AND ASSUMES NO LIABILITY OF ANY KIND WITH RESPECT TO THE DATA, INCLUDING, BUT NOT LIMITED TO, ITS CORRECTNESS, COMPLETENESS, RELIABILITY, CURRENTNESS OR SEARCHABILITY.  ALL MACROS ARE PROVIDED ON AN “AS IS” BASIS, WITHOUT ANY EXPRESS OR IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE AND Fujirebio Europe HEREBY EXPRESSLY DISCLAIMS ALL WARRANTIES, OTHER THAN THE WARRANTY OF TITLE AND THOSE WHICH ARE INCAPABLE OF EXCLUSIONS, RESTRICTION OR MODIFICATION UNDER THE LAWS APPLICABLE TO THIS AGREEMENT I.E. BELGIAN LAW"]
[]
[]
[]
[]
[]
[]
[]
["-","The macros are not supported by Fujirebio Europe. The macros are made available through the generous efforts of Fujirebio Europe.  Although Fujirebio Europe is interested in your feedback, they are under no obligation to address bugs, enhancements, or questions."]
[]
[]
["-","You are expressly prohibited from reselling or transferring the macros to third parties without the prior approval of Fujirebio Europe."]
[]
["-","The spreadsheet is protected, except for the tables, where input is possible. This is only taken as a measure to prevent unauthorized access to the data and graphs. As it is known that Excel passwords are easy to crack, Fujirebio Europe cannot take any responsibility for the quality and correctness of the sigmoïdal curve fitting."]
[]
[]
[]
["-","This template and macros have been developed on an English version of Microsoft Excel 2010 and Windows 7. No guarantee can be given that the template and macros will work for other languages or different regional settings, Excel versions or Windows versions."]
[]
[]
["-","This macro can only be used with results obtained with INNOTEST assays from Fujirebio Europe."]

{"sheet":"choices","index":4,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":true,"merged":[[19,3,20,3],[19,4,20,4],[19,5,20,5]]}
["Innotest",0]
["Dilution mode",0]
[]
["hTAU Ag",0]
["PHOSPHO-TAU",0]
["b-Amyloid(1-42)",0]
["b-Amyloid(1-40)",0]
["b-Amyloid(1-42)HS",0]
[]
[null,null,null,"Average OD","%Difference"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Average OD","% Difference","concentration"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"For Correct Usage"]
[]
[null,null,null,"Signature:"]