{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["ControlPanel","Data","RepControl","RepCombined","RepSE","RepSS","RepEE","RepSummary","Macro_MUM","ReadMe","DateTime","Work"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":155,"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":"ControlPanel","index":0,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,7,0,8],[0,10,0,11],[4,0,5,0],[7,0,8,0],[60,0,61,0],[63,0,64,0],[66,0,67,0],[0,0,2,0],[22,0,24,0],[13,0,14,0],[16,0,17,0],[19,0,20,0],[10,0,11,0],[27,0,29,0],[31,0,33,0],[35,0,37,0]]}
[null,null,"Status","Date","Sheet","Contains",null,"Samples",null,null,"Loci"]
[null,null,"Clear","2021-05-09T18:19:06.080","Data","Comma-separated-string allele lists for all samples",null,"Type","#",null,"Locus","#"]
[null,null,"Clear","2021-05-09T18:19:06.080","RepCombined","Combined allele lists",null,"Blank",0]
[null,null,"Clear","2021-05-09T18:19:06.090","RepSE","Detailed breakdown of Standard alleles shared with Evidence",null,"Control",0]
[null,null,"Clear","2021-05-09T18:19:06.110","RepSS","Detailed breakdown of Standard alleles shared with other Standards",null,"Disabled",0]
[null,null,"Clear","2021-05-09T18:19:06.120","RepEE","Detailed breakdown of Evidence alleles shared with other Evidence",null,"Evidence",0]
[null,null,"Clear","2021-05-09T18:19:06.140","RepControl","Detailed breakdown of Control alleles shared with all other samples",null,"Suspect",0]
[null,null,"Clear","2021-05-09T18:19:06.150","RepSummary","Summary of all comparisons",null,"Victim",0]
[null,null,null,null,null,null,null,"Xclude",0]
[null,null,null,null,null,null,null,"Unassigned",0]
[]
[null,null,null,null,null,null,null,"Total",0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Engineering"]
[]
[]
[]
[]
[]
[]
["########..#######"]

{"sheet":"Data","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"RepControl","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"RepCombined","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"RepSE","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

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

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

{"sheet":"RepSummary","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Macro_MUM","index":8,"n_rows":297,"n_cols":35,"rows_kept":297,"cut":false,"hidden":false,"merged":[]}
["MUM_Globals","Parameter","Value","MUM_Exit","MUM_ConRestore","MUM_DoAll","MUM_Cancel","MUM_DataClear","MUM_RepClear","MUM_DisSum","MUM_DataFetch","MUM_DataFetch_Basic","MUM_DataFetch_BodeData","MUM_DataFetch_Standard","MUM_ControlAdd","MUM_DataCheck","MUM_AllelesList","MUM_DataParam","MUM_RepCombined","MUM_AllelesCol","MUM_RepStdEvi","MUM_RepStdStd","MUM_RepEviEvi","MUM_RepControl","MUM_RepSummary","MUM_Print","MUM_Zoom","MUM_ReadMe","MUM_GetStarted",null,"Utility_CleanUpNames","Atmp1","Utility_ResetHeaders","Utility_UnHide","Utility_FormatButtons"]
[{"$f":"SET.NAME(\"Asyst\",\"mixSTR\")","v":true},"R1C1 mode",true,"! Exit - Invoked from Auto_Close","! Return to the control sheet","! Do everything","! User interruption","! Clear the data","! Clear the reports","! Display summary of current data","! Drive the data fetch","! Fetch standard format","! Fetch Bode format","! Fetch standard format","! Fetch the controls","! Check the data","! Check the alleles","! Store data structure","! Make the combined allele lists","! Make allele lists","! Report allele matches for all standards in all Evidence","! Report allele matches for all Standards in other Standards","! Report allele matches for all Standards in other Standards","! Report allele matches for all standards in all controls","! Make summary re;port","! Print any \"Complete\" Reports","! Set the default zoom","! Go to Readme","! Make sure all is ready after coming from ReadMe",null,"! Get rid of all the transcients","Atmp2","! Reset Page Headers of visible files","! Unhide all the hidden stuff","! Format the ControlPanel"]
[{"$f":"SET.NAME(\"Adate\",\"7-May-2021\")","v":true},"Calculation mode",3,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&D$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&E$1)","v":true},{"$f":"OPTIONS.CALCULATION(3)","v":true},{"$f":"DLD_ScreenUpdateOn()","v":false},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&H$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&I$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&J$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&K$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&L$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&M$1)","v":false},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&N$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&O$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&P$1)","v":true},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&R$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&S$1)","v":true},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&U$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&V$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&W$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&X$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&Y$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\" \"&Z$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\" \"&AA$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&AB$1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&AC$1)","v":true},null,null,"Atmp3",{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0}]
[{"$f":"MESSAGE(FALSE)","v":true},"Start datetime","2021-05-09T18:19:13.940",{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"CANCEL.KEY(TRUE,MUM_Cancel)","v":true},null,{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":false},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},null,{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},null,{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},null,{"$f":"SET.NAME(\"Atmp1\",COUNTA(NAMES()))","v":true},"Atmp4"]
[{"$f":"DLD_ScreenUpdateOff()","v":0},"Stop datetime",44325.763502199072,null,null,null,{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},{"$f":"CANCEL.KEY(TRUE,MUM_Cancel)","v":true},{"$f":"CANCEL.KEY(TRUE,MUM_Cancel)","v":true},null,{"$f":"CANCEL.KEY(TRUE,MUM_Cancel)","v":true},{"$f":"CANCEL.KEY(TRUE,MUM_Cancel)","v":true},{"$f":"CANCEL.KEY(TRUE,MUM_Cancel)","v":true},{"$f":"CANCEL.KEY(TRUE,MUM_Cancel)","v":true},{"$f":"CANCEL.KEY(TRUE,MUM_Cancel)","v":true},{"$f":"CANCEL.KEY(TRUE,MUM_Cancel)","v":true},{"$f":"ACTIVATE(S0wrk)","v":true},null,{"$f":"SET.NAME(\"RepR\",3)","v":true},{"$f":"ACTIVATE(S0wrk)","v":true},{"$f":"SET.NAME(\"RepR\",4)","v":true},{"$f":"SET.NAME(\"RepR\",5)","v":true},{"$f":"SET.NAME(\"RepR\",6)","v":true},{"$f":"SET.NAME(\"RepR\",7)","v":true},{"$f":"SET.NAME(\"RepR\",8)","v":true},null,null,null,null,null,{"$f":"FOR(\"Atmp2\",Atmp1,1,-1)","v":true},"MUM_AllelesCol","! Reset ControlPanel",{"$f":"ERROR(FALSE)","v":true},"! Format the ReadMe"]
[null,"User","Duewer, David L. Dr. (Fed)","! Restore calculation and RC states",{"$f":"ACTIVATE(S0con)","v":true},"! Setup the ControlPanel",{"$f":"dld_msgbar(WB_0&\" has been interrupted!\",TRUE)","v":false},null,null,"! Setup",null,null,null,null,null,null,{"$f":"dld_clearcols(3,7,FALSE)","v":0},"! Store structure on the Work sheet",null,{"$f":"dld_clearcols(2,10,FALSE)","v":0},null,null,null,null,null,"! Update ControlPanel","! Update ControlPanel","! Update ControlPanel","! Set pointer on ReadMe back to top",null,{"$f":"  SET.NAME(\"Atmp3\",INDEX(NAMES(),Atmp2))","v":true},"MUM_AllelesList",{"$f":"ACTIVATE(S0con)","v":true},{"$f":"  WORKBOOK.UNHIDE(MID(S0dti,FIND(\"]\",S0dti)+1,100))","v":true},{"$f":"ERROR(FALSE)","v":true}]
["! Set the major sheetnames","Number invocations",3,{"$f":"ACTIVATE(S0con)","v":true},{"$f":"DLD_ScreenUpdateOn()","v":0},{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},{"$f":"ALERT(WB_0&\" has been interrupted!\"&Acar&Acar&\"Go do what you need to do and try again.\",2)","v":false},"! Check for old data","! Reset the status",{"$f":"ACTIVATE(S0con)","v":true},"! Blank any old data","! Find data","! Get rows (loci) and columns (samples)","! Find data","! Check that the data have been defined","! Tell user that the checking has begun",null,{"$f":"ACTIVATE(S0wrk)","v":true},"! Make the combined allele lists",null,{"$f":"SET.NAME(\"Atitle\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&1&Acol&1,FALSE)))","v":true},{"$f":"SET.NAME(\"Atitle\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&1&Acol&1,FALSE)))","v":true},{"$f":"SET.NAME(\"Atitle\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&1&Acol&1,FALSE)))","v":true},{"$f":"SET.NAME(\"Atitle\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&1&Acol&1,FALSE)))","v":true},{"$f":"SET.NAME(\"Nstd\",SUM(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&12&Asep&Arow&5&Acol&12,FALSE)))","v":true},{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},{"$f":"ERROR(FALSE)","v":true},null,{"$f":"  SET.NAME(\"Atmp4\",MATCH(Atmp3,AF:AF,0))","v":true},"MUM_Cancel",{"$f":"PAGE.SETUP(\"&L&\"\"Arial,Regular\"\"&8Built by: David Lee Duewer, NIST&C&\"\"Arial,Bold\"\"&16\"&Asyst&\"  &\"\"Arial,Regular\"\"&12<Version \"&Adate&\">\nA summariziation tool for mixed-source evidence&R&\"\"Arial,Regular\"\"&8Paid for, in part, by: NIJ\",\"&L&\"\"Arial,Regular\"\"&8&F!&A&C&\"\"Arial,Regular\"\"&8&D &T&R&\"\"Arial,Regular\"\"&8&P / &N\",0.5,0.5,1.5,0.8,FALSE,FALSE,TRUE,TRUE,2,1,TRUE,\"Auto\",1,FALSE,,0.75,0.5,FALSE,FALSE)","v":true},{"$f":"  WORKBOOK.UNHIDE(MID(S0rme,FIND(\"]\",S0rme)+1,100))","v":true},{"$f":"  WORKBOOK.UNHIDE(MID(S0rme,FIND(\"]\",S0rme)+1,100))","v":true}]
[{"$f":"SET.NAME(\"Dir_0\",GET.DOCUMENT(2))","v":true},null,null,{"$f":"SET.NAME(\"Atmp1\",DEREF(INDIRECT(\"'\"&S0mac&\"'!\"&Arow&2&Acol&3,FALSE)))","v":true},{"$f":"dld_setcolwidth(3,-1,TRUE)","v":0},{"$f":"FORMULA.GOTO(Arow&23&Acol&1,FALSE)","v":true},null,{"$f":"SET.NAME(\"Atitle\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&1&Acol&1,FALSE)))","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"FORMULA(\"Status\",INDIRECT(\"'\"&S0con&\"'!\"&\"\"&Arow&1&Acol&3,FALSE))","v":true},{"$f":"SET.NAME(\"IsFetch\",TRUE)","v":true},{"$f":"SET.NAME(\"Atype\",\"Basic\")","v":true},{"$f":"SET.NAME(\"Atype\",\"Bode\")","v":false},{"$f":"SET.NAME(\"Atype\",\"Standard\")","v":true},{"$f":"SET.NAME(\"Nrow\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&1,FALSE)))","v":true},{"$f":"FORMULA(\"Checking...\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&3,FALSE))","v":true},"! Make list",{"$f":"dld_clearcols(3,5,FALSE)","v":0},{"$f":"MUM_Reportsetup(S0rp1)","v":0},{"$f":"FOR(\"Ityp\",1,2,1)","v":true},{"$f":"SET.NAME(\"Irow0\",MIN(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&13&Asep&Arow&5&Acol&13,FALSE)))","v":true},{"$f":"SET.NAME(\"Irow0\",MIN(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&13&Asep&Arow&5&Acol&13,FALSE)))","v":true},{"$f":"SET.NAME(\"Irow0\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&6&Acol&13,FALSE)))","v":true},{"$f":"SET.NAME(\"Irow0\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&2&Acol&13,FALSE)))","v":true},{"$f":"SET.NAME(\"Nevi\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&6&Acol&12,FALSE)))","v":true},{"$f":"FORMULA.GOTO(Arow&23&Acol&1,FALSE)","v":true},{"$f":"FORMULA.GOTO(Arow&28&Acol&1,FALSE)","v":true},{"$f":"FORMULA.GOTO(Arow&32&Acol&1,FALSE)","v":true},{"$f":"  WORKBOOK.UNHIDE(MID(S0rme,FIND(\"]\",S0rme)+1,100))","v":{"$error":"#VALUE!"}},null,{"$f":"  IF(ISERROR(Atmp4),DELETE.NAME(Atmp3))","v":false},"MUM_ConRestore",{"$f":"FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},{"$f":"  WORKBOOK.UNHIDE(MID(S0wrk,FIND(\"]\",S0wrk)+1,100))","v":true},{"$f":"ERROR(TRUE)","v":true}]
[{"$f":"dld_GetDefaultPath(Dir_0)","v":0},"CurZoom",95,{"$f":"IF(ISERROR(Atmp1),SET.NAME(\"Atmp1\",TRUE))","v":false},{"$f":"dld_setcolwidth(3,-1,TRUE)","v":0},{"$f":"DLD_ScreenUpdateOff()","v":0},{"$f":"HALT()","v":true},{"$f":"SET.NAME(\"Nrow\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&1,FALSE)))","v":true},{"$f":"dld_clearrange(3,3,Nrepsht+1,6,FALSE)","v":0},{"$f":"FORMULA(\"Date\",INDIRECT(\"'\"&S0con&\"'!\"&\"\"&Arow&1&Acol&4,FALSE))","v":true},{"$f":"RUN(\"MUM_DataClear\",FALSE)","v":{"$error":"#N/A"}},{"$f":"ACTIVATE(S1dat)","v":true},{"$f":"SET.NAME(\"Nrows\",MATCH(\"Generate CMF\",INDIRECT(\"'\"&S1dat&\"'!\"&\"\"&Acol&1,FALSE),0)-1)","v":false},{"$f":"ACTIVATE(S1dat)","v":true},{"$f":"SET.NAME(\"Nloc\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4,FALSE))-2)","v":true},null,{"$f":"SET.NAME(\"Anew\",SUBSTITUTE(Atmp,\",,\",\",\"))","v":true},null,null,{"$f":"  SET.NAME(\"Anew\",EVALUATE(\"Atmp\"&Ityp))","v":true},{"$f":"SET.NAME(\"Irow1\",MAX(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&14&Asep&Arow&5&Acol&14,FALSE)))","v":true},{"$f":"SET.NAME(\"Irow1\",MAX(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&14&Asep&Arow&5&Acol&14,FALSE)))","v":true},{"$f":"SET.NAME(\"Irow1\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&6&Acol&14,FALSE)))","v":true},{"$f":"SET.NAME(\"Irow1\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&2&Acol&14,FALSE)))","v":true},{"$f":"SET.NAME(\"Ncon\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&2&Acol&12,FALSE)))","v":true},null,null,null,{"$f":"ERROR(TRUE)","v":true},null,{"$f":"NEXT()","v":true},"MUM_ControlAdd",null,{"$f":"ERROR(TRUE)","v":true},{"$f":"ACTIVATE(S0rme)","v":true}]
[{"$f":"SET.NAME(\"WB_0\",GET.DOCUMENT(88))","v":true},null,null,{"$f":"A1.R1C1(NOT(Atmp1))","v":true},null,null,null,{"$f":"IF(AND(LEN(Atitle)>5.5,Nrow>4.5))","v":true},null,{"$f":"FORMULA(\"Sheet\",INDIRECT(\"'\"&S0con&\"'!\"&\"\"&Arow&1&Acol&5,FALSE))","v":true},null,{"$f":"SET.NAME(\"Nrow\",dld_findrowlast())","v":true},{"$f":"SET.NAME(\"Ncols\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&1,FALSE))+1)","v":true},{"$f":"SET.NAME(\"Nrows\",GET.DOCUMENT(10))","v":true},{"$f":"ACTIVATE(S0con)","v":true},"! Validate the inputs",{"$f":"WHILE(NOT(ISERROR(FIND(\",,\",Anew))))","v":true},{"$f":"FORMULA(\"Type\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&11,FALSE))","v":true},"! Format the header line",{"$f":"  IF(RIGHT(Anew,1)<>\",\",SET.NAME(\"Anew\",Anew&\",\"))","v":true},{"$f":"SET.NAME(\"Jrow0\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&6&Acol&13,FALSE)))","v":true},{"$f":"SET.NAME(\"Icol0\",MIN(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&16,FALSE)))","v":true},{"$f":"SET.NAME(\"Icol0\",MIN(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&16,FALSE)))","v":true},{"$f":"SET.NAME(\"Jrow0\",MIN(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&13&Asep&Arow&6&Acol&13,FALSE)))","v":true},{"$f":"SET.NAME(\"Nloc\",MAX(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&16,FALSE))-MIN(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&16,FALSE))+1)","v":true},"! Loop over Reports","! Get current Zoom","! Go to top of ReadMe",{"$f":"ACTIVATE(S0rme)","v":true},null,null,"MUM_DataCheck","! Reset the Data sheet",null,{"$f":"SELECT(\"Button 2\")","v":true}]
[{"$f":"SET.NAME(\"S0con\",\"[\"&WB_0&\"]ControlPanel\")","v":true},null,null,{"$f":"SET.NAME(\"Atmp2\",DEREF(INDIRECT(\"'\"&S0mac&\"'!\"&Arow&3&Acol&3,FALSE)))","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&E$1&\"> Finished.\")","v":true},"! Had checking begun?",null,{"$f":"  ACTIVATE(S0dat)","v":true},"! Mealy-mouth the data sheet",{"$f":"FORMULA(\"Contains\",INDIRECT(\"'\"&S0con&\"'!\"&\"\"&Arow&1&Acol&6,FALSE))","v":true},"! Point to the right button if things abort",{"$f":"SET.NAME(\"Ncol\",dld_findcolumnlast())","v":true},null,{"$f":"FOR(\"Irow\",1,Nrows,1)","v":true},{"$f":"DLD_ScreenUpdateOn()","v":0},{"$f":"ACTIVATE(S0dat)","v":true},{"$f":"  SET.NAME(\"Anew\",SUBSTITUTE(Anew,\",,\",\",\"))","v":true},{"$f":"FORMULA(\"#\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&12,FALSE))","v":true},{"$f":"FORMAT.NUMBER(\"0\")","v":true},{"$f":"  SET.NAME(\"Anew\",SUBSTITUTE(Anew,\"*\",\"\"))","v":true},{"$f":"SET.NAME(\"Jrow1\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&6&Acol&14,FALSE)))","v":true},{"$f":"SET.NAME(\"Icol1\",MAX(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&16,FALSE)))","v":true},{"$f":"SET.NAME(\"Icol1\",MAX(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&16,FALSE)))","v":true},{"$f":"SET.NAME(\"Jrow1\",MAX(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&14&Asep&Arow&6&Acol&14,FALSE)))","v":true},{"$f":"SET.NAME(\"Nblk\",6)","v":true},{"$f":"SET.NAME(\"Npnt\",0)","v":true},{"$f":"SET.NAME(\"CurZoom\",DEREF(INDIRECT(\"'\"&S0mac&\"'!\"&Arow&9&Acol&3,FALSE)))","v":true},{"$f":"ERROR(FALSE)","v":true},{"$f":"FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},null,{"$f":"dld_removehiddennames()","v":0},"MUM_DataClear",{"$f":"ACTIVATE(S0dat)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"FORMAT.SIZE(706,36)","v":true}]
[{"$f":"SET.NAME(\"S0dat\",\"[\"&WB_0&\"]Data\")","v":true},null,null,{"$f":"IF(ISERROR(Atmp2),SET.NAME(\"Atmp2\",3))","v":false},{"$f":"RETURN()","v":true},{"$f":"SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&3,FALSE)))","v":true},null,{"$f":"  dld_msgbar(\"There already is data on sheet: \"&S0dat,TRUE)","v":0},{"$f":"SET.NAME(\"Nall\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&\"\"&Acol&1&Asep&Acol&256,FALSE)))","v":true},{"$f":"SELECT(Acol&3)","v":true},{"$f":"  ACTIVATE(S0con)","v":true},{"$f":"COPY(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&1&Acol&1&Asep&Arow&Nrow&Acol&Ncol,FALSE),INDIRECT(\"'\"&S0dat&\"'!\"&Arow&1&Acol&1,FALSE))","v":true},"! Make Title",{"$f":"  SET.NAME(\"Ntmp\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow,FALSE)))","v":true},{"$f":"IF(OR(Nrow<2.5,Nloc<1.5))","v":true},{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},{"$f":"NEXT()","v":true},{"$f":"FORMULA(\"Rfst\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&13,FALSE))","v":true},{"$f":"FONT.PROPERTIES(\"Arial\",\"Regular\",10,,,,,,,1)","v":true},{"$f":"  SET.NAME(\"Nchr\",LEN(Anew))","v":true},{"$f":"SET.NAME(\"Icol0\",MIN(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&16,FALSE)))","v":true},{"$f":"SET.NAME(\"Nloc\",Icol1-Icol0+1)","v":true},{"$f":"SET.NAME(\"Nloc\",Icol1-Icol0+1)","v":true},{"$f":"SET.NAME(\"Icol0\",MIN(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&16,FALSE)))","v":true},null,{"$f":"FOR(\"Irep\",1,Nrepsht,1)","v":true},{"$f":"IF(ISERROR(1/CurZoom),SET.NAME(\"CurZoom\",0))","v":false},{"$f":"  WORKBOOK.UNHIDE(MID(S0rme,FIND(\"]\",S0rme)+1,100))","v":true},{"$f":"ERROR(FALSE)","v":true},null,null,"MUM_DataFetch",{"$f":"PAGE.SETUP(\"&L&\"\"Arial,Regular\"\"&8Built by: David Lee Duewer, NIST&C&\"\"Arial,Bold\"\"&16\"&Asyst&\"  &\"\"Arial,Regular\"\"&12<Version \"&Adate&\">\nA summariziation tool for mixed-source evidence&R&\"\"Arial,Regular\"\"&8Paid for, in part, by: NIJ\",\"&L&\"\"Arial,Regular\"\"&8&F!&A&C&\"\"Arial,Regular\"\"&8&D &T&R&\"\"Arial,Regular\"\"&8&P / &N\",0.5,0.5,1.5,0.8,FALSE,FALSE,TRUE,TRUE,2,TRUE,{1,#N/A},\"Auto\",1,FALSE,,0.75,0.5,FALSE,FALSE)","v":true},{"$f":"FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},{"$f":"FORMAT.MOVE(2,2,Arow&184&Acol&2)","v":true}]
[{"$f":"SET.NAME(\"S0dti\",\"[\"&WB_0&\"]DateTime\")","v":true},null,null,{"$f":"OPTIONS.CALCULATION(Atmp2)","v":true},null,{"$f":"IF(NOT(Atmp=\"Checking...\"))","v":true},null,{"$f":"  SET.NAME(\"Atmp1\",ALERT(\"There already is data on sheet: \"&S0dat&\".\"&Acar&\"Do not proceed until this data has been safely tucked away someplace!\"&Acar&Acar&\"Click 'OK' to proceed, 'Cancel' to abort.\",1))","v":true},{"$f":"IF(Nall<0.5)","v":true},{"$f":"FORMAT.NUMBER(\"0\")","v":true},{"$f":"  FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},null,{"$f":"ACTIVATE(S0dat)","v":true},{"$f":"  IF(Ntmp>0.5)","v":true},{"$f":"  dld_msgbar(\"A valid Data sheet is required.\",TRUE)","v":false},{"$f":"DLD_ScreenUpdateOn()","v":0},{"$f":"IF(LEFT(Anew,1)=\",\",SET.NAME(\"Anew\",MID(Anew,2,LEN(Anew))))","v":false},{"$f":"FORMULA(\"Rlst\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&14,FALSE))","v":true},{"$f":"ALIGNMENT(4,FALSE,2,0)","v":true},{"$f":"  SET.NAME(\"Nall\",0)","v":true},{"$f":"SET.NAME(\"Icol1\",MAX(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&16,FALSE)))","v":true},{"$f":"SET.NAME(\"Nstd\",SUM(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&12&Asep&Arow&5&Acol&12,FALSE)))","v":true},{"$f":"SET.NAME(\"Nevi\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&6&Acol&12,FALSE)))","v":true},{"$f":"SET.NAME(\"Icol1\",MAX(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&16,FALSE)))","v":true},"! Make summary re;port",{"$f":"  SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&2+Irep&Acol&3,FALSE)))","v":true},{"$f":"IF(OR(CurZoom<30,CurZoom>200),SET.NAME(\"CurZoom\",75))","v":false},{"$f":"ERROR(TRUE)","v":true},{"$f":"  WORKBOOK.HIDE(MID(S0dti,FIND(\"]\",S0dti)+1,100))","v":true},null,"! Restore globals","MUM_DataFetch_Basic",{"$f":"FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},null,{"$f":"dld_setcolwidth(13,-1,FALSE)","v":0}]
[{"$f":"SET.NAME(\"S0mac\",\"[\"&WB_0&\"]Macro_MUM\")","v":true},null,null,{"$f":"OPTIONS.VIEW(TRUE,TRUE)","v":true},null,null,null,null,{"$f":"  FORMULA(\"Clear\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&3,FALSE))","v":true},{"$f":"ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"  FORMULA.GOTO(Arow&11&Acol&1,FALSE)","v":true},{"$f":"ACTIVATE(S0dat)","v":true},{"$f":"FORMULA(\"Data from: \"&Dir_1&\"\\\"&S1dat,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&1&Acol&1,FALSE))","v":false},{"$f":"    SET.NAME(\"Irow0\",Irow)","v":true},{"$f":"  ALERT(\"You must first create a valid Data sheet\",2)","v":true},null,{"$f":"IF(RIGHT(Anew,1)<>\",\",SET.NAME(\"Anew\",Anew&\",\"))","v":true},{"$f":"FORMULA(\"Col\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&16,FALSE))","v":true},{"$f":"FORMULA(Atitle,Arow&1&Acol&1)","v":true},{"$f":"  SET.NAME(\"Ichr0\",0)","v":true},{"$f":"SET.NAME(\"Nloc\",Icol1-Icol0+1)","v":true},null,null,{"$f":"SET.NAME(\"Nloc\",Icol1-Icol0+1)","v":true},{"$f":"MUM_Reportsetup(S0rp6)","v":0},{"$f":"  IF(Atmp=\"Complete\")","v":true},null,{"$f":"ACTIVATE(S0rme)","v":true},null,null,{"$f":"RUN(MUM_Globals,FALSE)","v":{"$error":"#N/A"}},"MUM_DataFetch_BodeCODIS",null,{"$f":"ACTIVATE(S0mac)","v":true}]
[{"$f":"SET.NAME(\"S0rme\",\"[\"&WB_0&\"]ReadMe\")","v":true},null,null,null,null,"! Clear the old reports",null,"! Don't do anything",{"$f":"  FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&4,FALSE))","v":true},{"$f":"SELECT(Acol&4)","v":true},null,{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},{"$f":"SELECT(Arow&1&Acol&1&Asep&Arow&1&Acol&2+Nrows)","v":false},{"$f":"    BREAK()","v":true},{"$f":"  dld_gotocell_RC(1,1,1,14,TRUE)","v":false},"! Get maxium rows&cols",{"$f":"SET.NAME(\"Nchr\",LEN(Anew))","v":true},{"$f":"FORMULA(\"Locus\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&17,FALSE))","v":true},{"$f":"SELECT(Arow&1&Acol&1&Asep&Arow&1&Acol&9)","v":true},{"$f":"  SET.NAME(\"Ichr1\",0)","v":true},{"$f":"SET.NAME(\"Nstd\",SUM(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&12&Asep&Arow&5&Acol&12,FALSE)))","v":true},"! Report allele matches for all Standards in other Standards","! Report allele matches for all Standards in other Standards",{"$f":"SET.NAME(\"Nstd\",SUM(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&12&Asep&Arow&6&Acol&12,FALSE)))","v":true},null,{"$f":"    SET.NAME(\"S0tmp\",EVALUATE(\"S0rp\"&Irep))","v":true},"! Ask for new zoom",{"$f":"FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},{"$f":"  WORKBOOK.HIDE(MID(S0rme,FIND(\"]\",S0rme)+1,100))","v":true},null,null,"MUM_DataFetch_BodeData","! Do all the report sheets",{"$f":"FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},"! Format the ControlPanel"]
[{"$f":"SET.NAME(\"S0wrk\",\"[\"&WB_0&\"]Work\")","v":true},null,null,"! Restore screensize",null,{"$f":"  RUN(\"MUM_RepClear\",FALSE)","v":{"$error":"#N/A"}},null,{"$f":"  IF(NOT(Atmp1))","v":true},{"$f":"END.IF()","v":true},{"$f":"FORMAT.NUMBER(\"mm/dd/yy hh:mm:ss\")","v":true},"! Find the new  file",null,{"$f":"FONT.PROPERTIES(\"Arial\",\"Bold\",14,,,,,,,1)","v":true},{"$f":"  END.IF()","v":false},{"$f":"  HALT()","v":true},{"$f":"SET.NAME(\"Nrows\",GET.DOCUMENT(10))","v":true},{"$f":"SET.NAME(\"Nall\",0)","v":true},{"$f":"SELECT(Arow&1&Acol&12&Asep&Arow&1&Acol&14)","v":true},{"$f":"FONT.PROPERTIES(\"Arial\",\"Bold\",14,,,,,,,1)","v":true},{"$f":"  FOR(\"Ichr\",1,Nchr,1)","v":true},{"$f":"SET.NAME(\"Nevi\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&6&Acol&12,FALSE)))","v":true},{"$f":"MUM_Reportsetup(S0rp3)","v":0},{"$f":"MUM_Reportsetup(S0rp4)","v":0},{"$f":"SET.NAME(\"Ncon\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&2&Acol&12,FALSE)))","v":true},"! Format the header lines",{"$f":"    ACTIVATE(S0tmp)","v":true},{"$f":"SET.NAME(\"Atmp1\",CurZoom)","v":true},null,{"$f":"  WORKBOOK.HIDE(MID(S0wrk,FIND(\"]\",S0wrk)+1,100))","v":true},null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&AE$1&\"> Finished.\")","v":true},"MUM_DataFetch_Standard",{"$f":"FOR(\"Itmp\",1,Nrepsht,1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&AH$1&\"> Finished.\")","v":true},{"$f":"ACTIVATE(S0con)","v":true}]
[null,"AlngDat","dd-mmm-yy",{"$f":"FULL.SCREEN(FALSE)","v":true},null,null,null,{"$f":"    dld_msgbar(\"Data sheet clearance aborted by user.\",TRUE)","v":0},{"$f":"SET.NAME(\"Ntmp\",LEN(WB_0))","v":true},{"$f":"ALIGNMENT(4,FALSE,3,0)","v":true},{"$f":"DLD_ScreenUpdateOn()","v":0},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&L$1&\"> Finished.\")","v":true},{"$f":"ALIGNMENT(2,FALSE,3,0)","v":false},{"$f":"NEXT()","v":false},{"$f":"END.IF()","v":false},{"$f":"IF(Nrows<5.5)","v":true},null,{"$f":"ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"ALIGNMENT(7,FALSE,3,0)","v":true},{"$f":"    SET.NAME(\"Ichr1\",FIND(\",\",Anew,Ichr0+1))","v":true},null,null,null,null,{"$f":"FORMAT.NUMBER(\"0\")","v":true},{"$f":"    dld_setcolwidth(1,-1,TRUE)","v":0},{"$f":"ZOOM(Atmp1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&AB$1&\"> Finished.\")","v":true},{"$f":"ERROR(TRUE)","v":true},null,{"$f":"HALT()","v":true},"MUM_DataParam",{"$f":"  SET.NAME(\"S0rep\",EVALUATE(\"S0rp\"&Itmp))","v":true},null,{"$f":"dld_selectcols(1,-1,FALSE)","v":0}]
["! Set the report sheetnames","AlngTim","h:mm:ss",{"$f":"WINDOW.MAXIMIZE()","v":true},null,"! Fetch the data",null,{"$f":"    ACTIVATE(S0con)","v":true},{"$f":"FORMULA(MID(S0dat,Ntmp+3,100),INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&5,FALSE))","v":true},{"$f":"SELECT(Acol&5&Asep&Acol&6)","v":true},{"$f":"SET.NAME(\"Afile\",OPEN.DIALOG(,,\"Please select the desired file.\"))","v":true},{"$f":"RETURN()","v":true},null,{"$f":"FOR(\"Irow\",Nrows,Irow0,-1)","v":true},null,{"$f":"  dld_gotocell_RC(1,1,1,1,TRUE)","v":false},"! Check if this was a blank",{"$f":"BORDER(1)","v":true},{"$f":"FORMULA(\"Alleles\",Arow&3&Acol&2)","v":true},{"$f":"    IF(ISERROR(Ichr1),BREAK())","v":true},"! Report allele matches for all standards in all Evidence","! Format the header line","! Format the header line","! Report allele matches for all standards in all controls",{"$f":"FONT.PROPERTIES(\"Arial\",\"Regular\",10,,,,,,,1)","v":true},{"$f":"    DLD_ScreenUpdateOn()","v":0},{"$f":"DLD_ScreenUpdateOn()","v":0},{"$f":"RETURN()","v":true},null,null,null,"MUM_DisSum",{"$f":"  ACTIVATE(S0rep)","v":true},{"$f":"HALT()","v":true},{"$f":"ROW.HEIGHT(12.75)","v":true}]
[{"$f":"SET.NAME(\"S0rp1\",\"[\"&WB_0&\"]RepCombined\")","v":true},"AlngDatTim","dd-mmm-yy h:mm:ss",null,null,{"$f":"  RUN(\"MUM_DataFetch\",FALSE)","v":{"$error":"#N/A"}},null,{"$f":"    FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},{"$f":"FORMULA(\"Comma-separated-string allele lists for all samples\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&6,FALSE))","v":true},{"$f":"FORMAT.NUMBER(\"0\")","v":true},{"$f":"IF(ISERROR(Afile),SET.NAME(\"Afile\",FALSE))","v":false},null,"! Make labels",{"$f":"  SET.NAME(\"Ntmp\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow,FALSE)))","v":true},"! Find the new  file",{"$f":"  dld_msgbar(\"There must be more rows on sheet: \"&S0dat&\".\",TRUE)","v":false},{"$f":"IF(Nchr<1.5)","v":true},{"$f":"SELECT(Arow&1&Acol&11)","v":true},{"$f":"SELECT(Arow&3&Acol&2&Asep&Arow&3&Acol&6)","v":true},{"$f":"    SET.NAME(\"Nall\",Nall+1)","v":true},{"$f":"MUM_Reportsetup(S0rp2)","v":0},{"$f":"FORMAT.NUMBER(\"0\")","v":true},{"$f":"FORMAT.NUMBER(\"0\")","v":true},{"$f":"MUM_Reportsetup(S0rp5)","v":0},{"$f":"ALIGNMENT(4,FALSE,2,0)","v":true},{"$f":"    SET.NAME(\"Atmp1\",PRINT?(1))","v":true},{"$f":"  SET.NAME(\"CurZoom\",Atmp1)","v":true},null,"! Update ControlPanel",null,null,"MUM_DoAll",{"$f":"  PAGE.SETUP(\"&L&\"\"Arial,Regular\"\"&8Built by: David Lee Duewer, NIST&C&\"\"Arial,Bold\"\"&16\"&Asyst&\"  &\"\"Arial,Regular\"\"&12<Version \"&Adate&\">\nA summariziation tool for mixed-source evidence&R&\"\"Arial,Regular\"\"&8Paid for, in part, by: NIJ\",\"&L&\"\"Arial,Regular\"\"&8&F!&A&C&\"\"Arial,Regular\"\"&8&D &T&R&\"\"Arial,Regular\"\"&8&P / &N\",0.5,0.5,1.5,0.8,FALSE,FALSE,TRUE,TRUE,2,TRUE,{1,#N/A},\"Auto\",1,FALSE,,0.75,0.5,FALSE,FALSE)","v":true}]
[{"$f":"SET.NAME(\"S0rp2\",\"[\"&WB_0&\"]RepSE\")","v":true},"Acol","C","! Hide the optional worksheets",null,null,null,{"$f":"    IF(ISERROR(IsFetch),SET.NAME(\"IsFetch\",FALSE))","v":false},null,{"$f":"ALIGNMENT(2,FALSE,3,0)","v":true},{"$f":"IF(Afile=FALSE)","v":true},null,{"$f":"FOR(\"Irow\",2,Nrows,1)","v":true},{"$f":"  IF(Ntmp>0.5)","v":true},{"$f":"DLD_ScreenUpdateOn()","v":0},{"$f":"  ALERT(\"There must be at least three header rows and at least two Evidence, Suspect, and/or Victim rows on sheet: \"&S0dat&\".\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":false},{"$f":"  SET.NAME(\"Anew\",\"\")","v":true},{"$f":"ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"ALIGNMENT(7,FALSE,3,0)","v":true},{"$f":"    SET.NAME(\"Aall\",MID(Anew,Ichr0+1,Ichr1-Ichr0-1))","v":true},null,{"$f":"FONT.PROPERTIES(\"Arial\",\"Regular\",10,,,,,,,1)","v":true},{"$f":"FONT.PROPERTIES(\"Arial\",\"Regular\",10,,,,,,,1)","v":true},null,{"$f":"FORMULA(Atitle,Arow&1&Acol&1)","v":true},{"$f":"    DLD_ScreenUpdateOff()","v":0},{"$f":"  SET.NAME(\"Atmp1\",INPUT(\"Current 'ZOOM' is \"&CurZoom&\"%.\"&Acar&\"Valid ZOOMs are from 30 to 200%.\"&Acar&Acar&\"What ZOOM do you want?\",1,\"% ZOOM?\",CurZoom,5*72))","v":true},null,{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},null,null,"MUM_DoAnalysis",{"$f":"  FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},null,{"$f":"SELECT(\"CmdBut01\")","v":true}]
[{"$f":"SET.NAME(\"S0rp3\",\"[\"&WB_0&\"]RepSS\")","v":true},"Adcp",".",{"$f":"ERROR(FALSE)","v":true},null,"! Add the controls",null,{"$f":"    FORMULA.GOTO(IF(IsFetch,Arow&10&Acol&1,Arow&5&Acol&1),FALSE)","v":true},"! Clear all the report sheets",{"$f":"SELECT(Arow&1&Acol&3&Asep&Arow&1&Acol&6)","v":true},{"$f":"  ACTIVATE(S0con)","v":true},null,{"$f":"  SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow&Acol&1,FALSE)))","v":true},{"$f":"    SET.NAME(\"Irow1\",Irow)","v":true},{"$f":"SET.NAME(\"Afile\",OPEN.DIALOG(,,\"Please select the desired Control file.\"))","v":true},{"$f":"  HALT()","v":true},{"$f":"ELSE()","v":true},{"$f":"BORDER(0,0,0,0,1)","v":true},{"$f":"FORMULA(\"Alleles In...\",Arow&3&Acol&8)","v":true},{"$f":"    FORMULA(Aall,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Nall&Acol&4+Ityp,FALSE))","v":true},"! Format the header line",{"$f":"FORMULA(Atitle,Arow&1&Acol&1)","v":true},{"$f":"FORMULA(Atitle,Arow&1&Acol&1)","v":true},"! Format the header line",{"$f":"SELECT(Arow&1&Acol&1&Asep&Arow&1&Acol&Nblk*5)","v":true},{"$f":"    IF(Atmp1)","v":true},{"$f":"  IF(ISERROR(1/Atmp1),SET.NAME(\"Atmp1\",CurZoom))","v":false},null,null,null,null,"MUM_Exit",{"$f":"NEXT()","v":true},null,{"$f":"FORMAT.SIZE(89,36)","v":true}]
[{"$f":"SET.NAME(\"S0rp4\",\"[\"&WB_0&\"]RepEE\")","v":true},"Agnl","General",{"$f":"  WORKBOOK.HIDE(MID(S0dti,FIND(\"]\",S0dti)+1,100))","v":true},null,{"$f":"  RUN(\"MUM_ControlAdd\",FALSE)","v":{"$error":"#N/A"}},null,{"$f":"    SET.NAME(\"IsFetch\",FALSE)","v":true},{"$f":"FOR(\"Itmp\",1,Nrepsht,1)","v":true},{"$f":"ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"  dld_msgbar(\"Browsing aborted by user.\",TRUE)","v":0},null,{"$f":"  FORMULA(Atmp,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Irow+2,FALSE))","v":true},{"$f":"    BREAK()","v":true},{"$f":"IF(ISERROR(Afile),SET.NAME(\"Afile\",FALSE))","v":false},{"$f":"END.IF()","v":false},{"$f":"  SET.NAME(\"Ichr0\",0)","v":true},{"$f":"SELECT(Arow&1&Acol&11)","v":true},{"$f":"SELECT(Arow&3&Acol&8&Asep&Arow&3&Acol&9)","v":true},{"$f":"    SET.NAME(\"Ichr0\",Ichr1)","v":true},{"$f":"FORMAT.NUMBER(\"0\")","v":true},{"$f":"ALIGNMENT(4,FALSE,2,0)","v":true},{"$f":"ALIGNMENT(4,FALSE,2,0)","v":true},{"$f":"FORMAT.NUMBER(\"0\")","v":true},{"$f":"FONT.PROPERTIES(\"Arial\",\"Bold\",14,,,,,,,1)","v":true},{"$f":"      SET.NAME(\"Npnt\",Npnt+1)","v":true},{"$f":"  IF(OR(Atmp1<30,Atmp1>500),SET.NAME(\"Atmp1\",CurZoom))","v":false},null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&AC$1&\"> Finished.\")","v":true},null,null,"MUM_GetStarted",null,null,{"$f":"FORMAT.MOVE(2,2,Arow&1&Acol&1)","v":true}]
[{"$f":"SET.NAME(\"S0rp5\",\"[\"&WB_0&\"]RepControl\")","v":true},"Alsp",",",{"$f":"  WORKBOOK.HIDE(MID(S0rme,FIND(\"]\",S0rme)+1,100))","v":true},null,{"$f":"END.IF()","v":true},null,{"$f":"    HALT()","v":true},{"$f":"  SET.NAME(\"S0rep\",EVALUATE(\"S0rp\"&Itmp))","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"  ALERT(\"No data file was specified.\",2)","v":true},null,{"$f":"NEXT()","v":true},{"$f":"  END.IF()","v":false},{"$f":"IF(Afile=FALSE)","v":true},{"$f":"SET.NAME(\"Ncols\",GET.DOCUMENT(12))","v":true},{"$f":"  SET.NAME(\"Ichr1\",0)","v":true},{"$f":"ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"ALIGNMENT(7,FALSE,3,0)","v":true},{"$f":"  NEXT()","v":true},{"$f":"FONT.PROPERTIES(\"Arial\",\"Regular\",10,,,,,,,1)","v":true},{"$f":"SELECT(Arow&1&Acol&1&Asep&Arow&1&Acol&IF(Nstd<0.5,1,2+Nstd*5))","v":true},{"$f":"SELECT(Arow&1&Acol&1&Asep&Arow&1&Acol&IF(Nevi<0.5,1,2+Nevi*5))","v":true},{"$f":"FONT.PROPERTIES(\"Arial\",\"Regular\",10,,,,,,,1)","v":true},{"$f":"ALIGNMENT(7,FALSE,3,0)","v":true},{"$f":"      FORMULA(\"Printed\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2+Irep&Acol&3,FALSE))","v":true},{"$f":"IF(ABS(Atmp1-CurZoom)>0.5,GOTO(AA$17))","v":false},null,{"$f":"RETURN()","v":true},null,null,"MUM_Globals","! Reset Readme",null,{"$f":"SELECT(\"CmdBut02\")","v":true}]
[{"$f":"SET.NAME(\"S0rp6\",\"[\"&WB_0&\"]RepSummary\")","v":true},"Arow","R",{"$f":"  WORKBOOK.HIDE(MID(S0wrk,FIND(\"]\",S0wrk)+1,100))","v":true},null,null,null,{"$f":"  END.IF()","v":true},{"$f":"  SET.NAME(\"Arep\",EVALUATE(\"S0rp\"&Itmp&\"_txt\"))","v":true},{"$f":"dld_clearrange(13,8,-1,9,FALSE)","v":0},{"$f":"  HALT()","v":true},null,{"$f":"FOR(\"Icol\",2,Ncols,1)","v":true},{"$f":"NEXT()","v":true},{"$f":"  dld_msgbar(\"Browsing aborted by user.\",TRUE)","v":0},{"$f":"IF(Ncols<3.5)","v":true},{"$f":"  FOR(\"Ichr\",1,Nchr,1)","v":true},{"$f":"BORDER(0,0,0,0,1)","v":true},null,{"$f":"NEXT()","v":true},{"$f":"FORMULA(Atitle,Arow&1&Acol&1)","v":true},{"$f":"FONT.PROPERTIES(\"Arial\",\"Bold\",14,,,,,,,1)","v":true},{"$f":"FONT.PROPERTIES(\"Arial\",\"Bold\",14,,,,,,,1)","v":true},{"$f":"FORMULA(Atitle,Arow&1&Acol&1)","v":true},null,{"$f":"    END.IF()","v":true},{"$f":"DLD_ScreenUpdateOff()","v":0},null,null,null,null,"MUM_Print",{"$f":"ERROR(FALSE)","v":true},null,{"$f":"FORMAT.SIZE(83,24)","v":true}]
[{"$f":"SET.NAME(\"S0rp1_txt\",\"Combined allele lists\")","v":true},null,null,{"$f":"ERROR(TRUE)","v":true},null,"! Check the data",null,{"$f":"END.IF()","v":true},{"$f":"  FORMULA(\"Clear\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&Itmp+2&Acol&3,FALSE))","v":true},{"$f":"dld_clearrange(3,11,-1,12,FALSE)","v":0},{"$f":"END.IF()","v":false},null,{"$f":"  SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&1&Acol&Icol,FALSE)))","v":true},null,{"$f":"  ALERT(\"No Control file was specified.\",2)","v":true},{"$f":"  dld_gotocell_RC(1,1,1,1,TRUE)","v":false},{"$f":"    SET.NAME(\"Ichr1\",FIND(\",\",Anew,Ichr0+1))","v":true},{"$f":"SELECT(Arow&1&Acol&17)","v":true},{"$f":"FORMULA(\"Locus\",Arow&4&Acol&1)","v":true},null,{"$f":"ALIGNMENT(4,FALSE,2,0)","v":true},{"$f":"ALIGNMENT(7,FALSE,3,0)","v":true},{"$f":"ALIGNMENT(7,FALSE,3,0)","v":true},{"$f":"ALIGNMENT(4,FALSE,2,0)","v":true},{"$f":"FORMULA(\"Standard by Evidence\",Arow&3&Acol&0*Nblk+1)","v":true},{"$f":"  END.IF()","v":true},null,null,null,null,null,"MUM_ReadMe",{"$f":"  WORKBOOK.UNHIDE(MID(S0rme,FIND(\"]\",S0rme)+1,100))","v":true},null,{"$f":"FORMAT.MOVE(8,2,Arow&5&Acol&1)","v":true}]
[{"$f":"SET.NAME(\"S0rp2_txt\",\"Detailed breakdown of Standard alleles shared with Evidence\")","v":true},null,null,null,null,{"$f":"RUN(\"MUM_DataCheck\",FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"  FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&Itmp+2&Acol&4,FALSE))","v":true},{"$f":"dld_clearcols(13,-1,FALSE)","v":0},null,null,{"$f":"  FORMULA(\"S\"&TEXT(Icol-1,\"00\")&\":\"&Atmp,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&3+Icol&Acol&2,FALSE))","v":true},{"$f":"SET.NAME(\"Ncols\",GET.DOCUMENT(12))","v":true},{"$f":"  dld_gotocell_RC(1,1,14,1,TRUE)","v":0},{"$f":"  dld_msgbar(\"There must be more columns on sheet: \"&S0dat&\".\",TRUE)","v":false},{"$f":"    IF(ISERROR(Ichr1),BREAK())","v":true},{"$f":"ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"FORMULA(\"Xclude\",Arow&4&Acol&2)","v":true},"! Get alleles in at least one reference that aren't in target",{"$f":"SELECT(Arow&1&Acol&1&Asep&Arow&1&Acol&IF(Nstd*Nevi<0.5,1,2+Nevi*5))","v":true},null,null,{"$f":"SELECT(Arow&1&Acol&1&Asep&Arow&1&Acol&IF(Nstd<0.5,1,2+Nstd*5))","v":true},{"$f":"FORMULA(\"Evidence by Standard\",Arow&3&Acol&1*Nblk+1)","v":true},{"$f":"NEXT()","v":true},"! Store as new default",null,null,null,null,"MUM_RepClear",{"$f":"ERROR(TRUE)","v":true},null,{"$f":"SELECT(\"CmdBut03\")","v":true}]
[{"$f":"SET.NAME(\"S0rp3_txt\",\"Detailed breakdown of Standard alleles shared with other Standards\")","v":true},null,null,"! Update ControlPanel",null,null,null,"! Clear the data",{"$f":"  FORMULA(MID(S0rep,Ntmp+3,100),INDIRECT(\"'\"&S0con&\"'!\"&Arow&Itmp+2&Acol&5,FALSE))","v":true},null,"! Open the file",null,{"$f":"NEXT()","v":true},{"$f":"FOR(\"Icol\",1,Ncols,1)","v":true},{"$f":"  HALT()","v":true},{"$f":"  ALERT(\"There must be at least 4 columns on sheet: \"&S0dat&\".\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":false},{"$f":"    SET.NAME(\"Aall\",MID(Anew,Ichr0+1,Ichr1-Ichr0-1))","v":true},{"$f":"BORDER(0,0,0,0,1)","v":true},{"$f":"FORMULA(\"Victim\",Arow&4&Acol&3)","v":true},{"$f":"SET.NAME(\"Nall\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&5,FALSE)))","v":true},{"$f":"FONT.PROPERTIES(\"Arial\",\"Bold\",14,,,,,,,1)","v":true},"! Are there Standards?","! Is there Evidence?",{"$f":"FONT.PROPERTIES(\"Arial\",\"Bold\",14,,,,,,,1)","v":true},{"$f":"FORMULA(\"Standard by Standard\",Arow&3&Acol&2*Nblk+1)","v":true},null,{"$f":"FORMULA(CurZoom,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&9&Acol&3,FALSE))","v":true},null,null,null,null,"MUM_RepCombined",{"$f":"ACTIVATE(S0rme)","v":true},null,{"$f":"FORMAT.SIZE(83,24)","v":true}]
[{"$f":"SET.NAME(\"S0rp4_txt\",\"Detailed breakdown of Evidence alleles shared with other Evidence\")","v":true},null,null,{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},null,"MUM_DoAnalysis",null,{"$f":"dld_clearworksheet(S0dat)","v":0},{"$f":"  FORMULA(Arep,INDIRECT(\"'\"&S0con&\"'!\"&Arow&Itmp+2&Acol&6,FALSE))","v":true},"! Is there data?",{"$f":"ERROR(FALSE)","v":true},null,null,{"$f":"  SET.NAME(\"Ntmp\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Acol&Icol,FALSE)))","v":true},{"$f":"END.IF()","v":false},{"$f":"  HALT()","v":true},{"$f":"    SET.NAME(\"Nall\",Nall+1)","v":true},null,{"$f":"FORMULA(\"Suspect\",Arow&4&Acol&4)","v":true},{"$f":"SET.NAME(\"Imis\",0)","v":true},{"$f":"ALIGNMENT(7,FALSE,3,0)","v":true},{"$f":"IF(Nstd<0.5)","v":true},{"$f":"IF(Nevi<0.5)","v":true},{"$f":"ALIGNMENT(7,FALSE,3,0)","v":true},{"$f":"FORMULA(\"Evidence by Evidence\",Arow&3&Acol&3*Nblk+1)","v":true},"! Back to Control",null,null,null,null,null,"MUM_RepControl",{"$f":"FORMULA(\"\"&Asyst&\" <Version \"&TEXT(Adate,AlngDat)&\">\",INDIRECT(\"'\"&S0rme&\"'!\"&Arow&2&Acol&2,FALSE))","v":true},null,{"$f":"FORMAT.MOVE(8,2,Arow&8&Acol&1)","v":true}]
[{"$f":"SET.NAME(\"S0rp5_txt\",\"Detailed breakdown of Control alleles shared with all other samples\")","v":true},null,null,null,null,"! Make the reports",null,{"$f":"FORMULA(\"Clear\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&3,FALSE))","v":true},{"$f":"  dld_clearworksheet(S0rep)","v":0},{"$f":"SET.NAME(\"Nrows\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&\"\"&Arow&5&Acol&1&Asep&Arow&65536&Acol&1,FALSE)))","v":true},{"$f":"  SET.NAME(\"Atmp1\",OPEN(Afile,0,FALSE,,,,,,,,1))","v":true},null,{"$f":"FORMULA(\"Sample\",Arow&3&Acol&1)","v":true},{"$f":"  IF(Ntmp>0.5)","v":true},null,{"$f":"END.IF()","v":false},null,"! Get the numbers",{"$f":"FORMULA(\"Standard\",Arow&4&Acol&5)","v":true},{"$f":"FOR(\"Iall\",1,Nall,1)","v":true},null,{"$f":"  FORMULA(\"Unavailable\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&3,FALSE))","v":true},{"$f":"  FORMULA(\"Unavailable\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&3,FALSE))","v":true},null,{"$f":"FORMULA(\"Controls by Samples\",Arow&3&Acol&4*Nblk+1)","v":true},{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},"! Set all the user-viewable sheets to the same zoom",null,null,null,null,"MUM_RepEviEvi",{"$f":"PAGE.SETUP(\"&L&\"\"Arial,Regular\"\"&8Built by: David Lee Duewer, NIST&C&\"\"Arial,Bold\"\"&16\"&Asyst&\"  &\"\"Arial,Regular\"\"&12<Version \"&Adate&\">\nA summariziation tool for mixed-source evidence&R&\"\"Arial,Regular\"\"&8Paid for, in part, by: NIJ\",\"&L&\"\"Arial,Regular\"\"&8&F!&A&C&\"\"Arial,Regular\"\"&8&D &T&R&\"\"Arial,Regular\"\"&8&P / &N\",0.5,0.5,1.5,0.8,FALSE,FALSE,TRUE,TRUE,1,1,{1,#N/A},\"Auto\",1,FALSE,,0.75,0.5,FALSE,FALSE)","v":true},null,{"$f":"SELECT(\"CmdBut04\")","v":true}]
[{"$f":"SET.NAME(\"S0rp6_txt\",\"Summary of all comparisons\")","v":true},null,null,"! Tell user how much time s/he has wasted",null,{"$f":"RUN(\"MUM_RepCombined\",FALSE)","v":{"$error":"#N/A"}},null,{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&4,FALSE))","v":true},{"$f":"NEXT()","v":true},{"$f":"IF(Nrows<0.5)","v":true},{"$f":"ERROR(TRUE)","v":true},null,{"$f":"SELECT(Arow&3&Acol&1&Asep&Arow&3&Acol&2)","v":true},{"$f":"    SET.NAME(\"Icol0\",Icol)","v":true},"! Open the file",null,"! Take care of () to * and correct sort order",{"$f":"SET.NAME(\"Nctl\",0)","v":true},{"$f":"FORMULA(\"Evidence\",Arow&4&Acol&6)","v":true},{"$f":"  SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iall&Acol&5,FALSE)))","v":true},"! Are there Standards and Evidence?",{"$f":"  FORMULA(\"Standards comparison is not possible: #Stds = \"&Nstd&\".\",Arow&3&Acol&1)","v":true},{"$f":"  FORMULA(\"Evidence comparison is not possible: #Evi = \"&Nevi&\".\",Arow&3&Acol&1)","v":true},"! Are there controls?",{"$f":"FORMULA(\"Standard\",Arow&4&Acol&0*Nblk+1)","v":true},{"$f":"FORMULA.GOTO(Arow&23&Acol&1,FALSE)","v":true},{"$f":"FOR(\"Itmp\",1,Nrepsht,1)","v":true},null,null,null,null,"MUM_RepStdEvi",{"$f":"FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},null,{"$f":"FORMAT.SIZE(83,24)","v":true}]
[{"$f":"SET.NAME(\"Nrepsht\",6)","v":true},null,null,{"$f":"SET.NAME(\"Atmp1\",NOW())","v":true},null,{"$f":"RUN(\"MUM_RepStdEvi\",FALSE)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"IF(Atmp1=FALSE)","v":true},null,{"$f":"ALIGNMENT(2,FALSE,3,0)","v":false},{"$f":"    BREAK()","v":true},{"$f":"ERROR(FALSE)","v":true},"! Sort into standard order",{"$f":"    IF(OR(NOT(ISERROR(FIND(\"(\",Aall))),NOT(ISERROR(FIND(\")\",Aall))),NOT(ISERROR(FIND(\"*\",Aall)))))","v":true},{"$f":"SET.NAME(\"Nevi\",0)","v":true},{"$f":"FORMULA(\"Standards Not Evidence\",Arow&4&Acol&8)","v":true},{"$f":"  SET.NAME(\"Irtmp\",MATCH(Atmp,INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&6,FALSE),0))","v":true},{"$f":"IF(OR(Nstd<0.5,Nevi<0.5))","v":true},{"$f":"  SELECT(Acol&1)","v":true},{"$f":"  SELECT(Acol&1)","v":true},{"$f":"IF(Ncon<0.5)","v":true},{"$f":"FORMULA(\"Evidence\",Arow&4&Acol&0*Nblk+2)","v":true},null,{"$f":"  SET.NAME(\"S0tmp\",EVALUATE(\"S0rp\"&Itmp))","v":true},null,null,null,null,"MUM_RepStdStd",null,null,{"$f":"FORMAT.MOVE(8,2,Arow&11&Acol&1)","v":true}]
[null,null,null,{"$f":"FORMULA(Atmp1,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&5&Acol&3,FALSE))","v":true},null,{"$f":"RUN(\"MUM_RepStdStd\",FALSE)","v":{"$error":"#N/A"}},null,"! Clear the worksheet","! Update ControlPanel","! No",{"$f":"  ACTIVATE(S0con)","v":true},null,{"$f":"FORMULA(\"Loci\",Arow&3&Acol&4)","v":true},{"$f":"  END.IF()","v":false},{"$f":"  SET.NAME(\"Atmp1\",OPEN(Afile,0,FALSE,,,,,,,,1))","v":true},{"$f":"SELECT(Arow&5&Acol&1&Asep&Arow&Nrows&Acol&Ncols)","v":true},{"$f":"      SET.NAME(\"Aall\",SUBSTITUTE(Aall,\"(\",\"\"))","v":true},{"$f":"SET.NAME(\"Nsus\",0)","v":true},{"$f":"FORMULA(\"Evidence Not Standards\",Arow&4&Acol&9)","v":true},{"$f":"  IF(ISERROR(Irtmp))","v":true},{"$f":"  FORMULA(\"Unavailable\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&3,FALSE))","v":true},{"$f":"  ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"  ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"  FORMULA(\"Unavailable\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&3,FALSE))","v":true},{"$f":"FORMULA(\"Evidence\",Arow&4&Acol&1*Nblk+1)","v":true},"! Tell about nothing printed",{"$f":"  ACTIVATE(S0tmp)","v":true},null,null,null,null,"MUM_RepSummary","! Reset Macro page as well",null,{"$f":"SELECT(\"CmdBut05\")","v":true}]
["! Country-Version dependencies that can be automatically determined",null,null,{"$f":"SET.NAME(\"Atmp2\",DEREF(INDIRECT(\"'\"&S0mac&\"'!\"&Arow&4&Acol&3,FALSE)))","v":true},null,{"$f":"RUN(\"MUM_RepEviEvi\",FALSE)","v":{"$error":"#N/A"}},null,{"$f":"ACTIVATE(S0wrk)","v":true},{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},{"$f":"  FORMULA.ARRAY(0,INDIRECT(\"'\"&S0con&\"'!\"&Arow&3&Acol&9&Asep&Arow&10&Acol&9,FALSE))","v":true},{"$f":"  dld_msgbar(\"File (\"&Afile&\") could not be opened.\",TRUE)","v":false},null,{"$f":"SELECT(Arow&3&Acol&4&Asep&Arow&3&Acol&2+Nrows)","v":true},{"$f":"NEXT()","v":false},{"$f":"ERROR(TRUE)","v":true},{"$f":"SORT(1,Arow&5&Acol&1,2,,,,,2)","v":true},{"$f":"      SET.NAME(\"Aall\",SUBSTITUTE(Aall,\")\",\"\"))","v":true},{"$f":"SET.NAME(\"Nvic\",0)","v":true},{"$f":"SELECT(\"(\"&Arow&4&Acol&2&Asep&Arow&4&Acol&6&Alsp&Arow&4&Acol&8&Asep&Arow&4&Acol&9&\")\")","v":true},{"$f":"    SET.NAME(\"Imis\",Imis+1)","v":true},{"$f":"  FORMULA(\"Standards Vs Evidence comparison is not possible: #Stds = \"&Nstd&\", #Evi =\"&Nevi&\".\",Arow&3&Acol&1)","v":true},{"$f":"ELSE.IF(Nstd<1.5)","v":true},{"$f":"ELSE.IF(Nevi<1.5)","v":true},{"$f":"  FORMULA(\"Controls comparison is not possible: #con = \"&Ncon&\".\",Arow&3&Acol&1)","v":true},{"$f":"FORMULA(\"Standard\",Arow&4&Acol&1*Nblk+2)","v":true},{"$f":"IF(Npnt<0.5)","v":true},{"$f":"  ZOOM(CurZoom)","v":true},null,null,null,null,"MUM_Zoom",{"$f":"ERROR(FALSE)","v":true},null,{"$f":"FORMAT.SIZE(83,24)","v":true}]
[{"$f":"SET.NAME(\"Acar\",CHAR(10))","v":true},null,null,{"$f":"SET.NAME(\"Atmp3\",24*(Atmp1-Atmp2))","v":true},null,{"$f":"RUN(\"MUM_RepControl\",FALSE)","v":{"$error":"#N/A"}},null,{"$f":"dld_clearrange(2,12,-1,20,FALSE)","v":0},{"$f":"FORMULA.GOTO(Arow&11&Acol&1,FALSE)","v":true},{"$f":"  FORMULA(0,INDIRECT(\"'\"&S0con&\"'!\"&Arow&12&Acol&9,FALSE))","v":true},{"$f":"  ALERT(\"File (\"&Afile&\") could not be opened.\",2)","v":false},null,{"$f":"ALIGNMENT(2,FALSE,3,0)","v":false},{"$f":"FOR(\"Icol\",Ncols,Icol0,-1)","v":true},{"$f":"IF(Atmp1=FALSE)","v":true},null,{"$f":"      SET.NAME(\"Aall\",SUBSTITUTE(Aall,\"*\",\"\"))","v":true},{"$f":"SET.NAME(\"Nxcl\",0)","v":true},{"$f":"ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"    FORMULA(Atmp,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Imis&Acol&7,FALSE))","v":true},{"$f":"  SELECT(Acol&1)","v":true},{"$f":"  FORMULA(\"Unneeded\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&3,FALSE))","v":false},{"$f":"  FORMULA(\"Unneeded\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&3,FALSE))","v":true},{"$f":"  SELECT(Acol&1)","v":true},{"$f":"FORMULA(\"Standard\",Arow&4&Acol&2*Nblk+1)","v":true},{"$f":"  dld_msgbar(TEXT(NOW(),AlngDatTim)&\" \"&Z$1&\" > Error… None of the reports are 'Finished'.\",TRUE)","v":0},{"$f":"  FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},null,null,null,null,"Utility_CleanUpNames",{"$f":"  WORKBOOK.UNHIDE(MID(S0mac,FIND(\"]\",S0mac)+1,100))","v":{"$error":"#VALUE!"}},null,{"$f":"FORMAT.MOVE(8,2,Arow&14&Acol&1)","v":true}]
[{"$f":"SET.NAME(\"Acol\",INDEX(GET.WORKSPACE(37),7))","v":true},null,null,null,null,{"$f":"RUN(\"MUM_RepSummary\",FALSE)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"  dld_gotocell_RC(1,1,1,11,TRUE)","v":false},null,{"$f":"FORMULA(\"Type\",Arow&4&Acol&1)","v":true},{"$f":"  SET.NAME(\"Ntmp\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Acol&Icol,FALSE)))","v":true},{"$f":"  ACTIVATE(S0con)","v":true},"! Check for blanks",{"$f":"      SET.NAME(\"Aall\",IF(ISERROR(Aall*1),Aall&\"*\",TEXT(Aall,\"000.0\")&\"*\"))","v":true},{"$f":"SET.NAME(\"Nrows\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&1,FALSE))+3)","v":true},{"$f":"BORDER(1)","v":true},{"$f":"  END.IF()","v":true},{"$f":"  ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"  FORMULA(\"Standard self-comparison not useful: #Stds = \"&Nstd&\".\",Arow&3&Acol&1)","v":false},{"$f":"  FORMULA(\"Evidence self-comparison is not needed: #Evi = \"&Nevi&\".\",Arow&3&Acol&1)","v":true},{"$f":"  ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"FORMULA(\"Standard\",Arow&4&Acol&2*Nblk+2)","v":true},{"$f":"  dld_msgbar(\"Nothing has been printed.\",TRUE)","v":0},{"$f":"NEXT()","v":true},null,null,null,null,"Utility_FormatButtons",{"$f":"ERROR(TRUE)","v":true},null,{"$f":"SELECT(\"CmdBut06\")","v":true}]
[{"$f":"SET.NAME(\"Adcp\",INDEX(GET.WORKSPACE(37),3))","v":true},null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  Wall-clock time this session of \"&WB_0&\": \"&TEXT(Atmp3,\"0\"&Adcp&\"000\")&\" hours.\")","v":true},null,null,null,"! Clear the Reports",{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&I$1&\"> Finished.\")","v":true},"! Yes",{"$f":"  HALT()","v":true},null,{"$f":"FORMULA(\"Description\",Arow&4&Acol&2)","v":true},{"$f":"  IF(Ntmp>0.5)","v":true},{"$f":"  dld_msgbar(\"File (\"&Afile&\") could not be opened.\",TRUE)","v":false},{"$f":"SET.NAME(\"Nrows\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&1,FALSE))+1)","v":true},{"$f":"    ELSE()","v":true},{"$f":"FOR(\"Irow\",5,Nrows,1)","v":true},{"$f":"SELECT(Arow&4&Acol&1)","v":true},{"$f":"NEXT()","v":true},{"$f":"ELSE()","v":true},{"$f":"  SELECT(Acol&1)","v":false},{"$f":"  SELECT(Acol&1)","v":true},{"$f":"ELSE()","v":true},{"$f":"FORMULA(\"Evidence\",Arow&4&Acol&3*Nblk+1)","v":true},{"$f":"  ALERT(\"Nothing has been printed; things haven't been generated, have already been printed, or you Canceled.\"&Acar&Acar&\"Please generate any (new) ones you want and try again.\",2)","v":true},null,null,null,null,null,"Utility_ResetHeaders",{"$f":"ACTIVATE(S0mac)","v":true},null,{"$f":"FORMAT.SIZE(83,24)","v":true}]
[{"$f":"SET.NAME(\"Agnl\",INDEX(GET.WORKSPACE(37),26))","v":true},null,null,{"$f":"RETURN()","v":true},null,"! Update ControlPanel",null,{"$f":"RUN(MUM_RepClear,0)","v":{"$error":"#N/A"}},{"$f":"RETURN()","v":true},{"$f":"ELSE()","v":true},{"$f":"END.IF()","v":false},null,{"$f":"SELECT(Arow&4&Acol&4&Asep&Arow&4&Acol&2+Nrows)","v":false},{"$f":"    SET.NAME(\"Icol1\",Icol)","v":true},{"$f":"  ALERT(\"File (\"&Afile&\") could not be opened.\",2)","v":false},{"$f":"FOR(\"Irow\",5,Nrows,1)","v":true},{"$f":"      IF(NOT(ISERROR(Aall*1)),SET.NAME(\"Aall\",TEXT(Aall,\"000.0\")))","v":true},{"$f":"  SET.NAME(\"Atmp\",UPPER(LEFT(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&1,FALSE),2)))","v":true},{"$f":"ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"SET.NAME(\"Atmp1\",\"\")","v":true},null,{"$f":"  ALIGNMENT(3,FALSE,3,0)","v":false},{"$f":"  ALIGNMENT(3,FALSE,3,0)","v":true},null,{"$f":"FORMULA(\"Evidence\",Arow&4&Acol&3*Nblk+2)","v":true},{"$f":"ELSE()","v":true},{"$f":"ACTIVATE(S0dat)","v":true},null,null,null,null,"Utility_UnHide",{"$f":"PAGE.SETUP(\"&L&\"\"Arial,Regular\"\"&8Built by: David Lee Duewer, NIST&C&\"\"Arial,Bold\"\"&16\"&Asyst&\"  &\"\"Arial,Regular\"\"&12<Version \"&Adate&\">\nA summariziation tool for mixed-source evidence&R&\"\"Arial,Regular\"\"&8Paid for, in part, by: NIJ\",\"&L&\"\"Arial,Regular\"\"&8&F!&A&C&\"\"Arial,Regular\"\"&8&D &T&R&\"\"Arial,Regular\"\"&8&P / &N\",0.5,0.5,1.5,0.8,FALSE,FALSE,TRUE,TRUE,1,1,TRUE,\"Auto\",1,FALSE,,0.75,0.5,FALSE,FALSE)","v":true},null,{"$f":"FORMAT.MOVE(8,2,Arow&17&Acol&1)","v":true}]
[{"$f":"SET.NAME(\"Alsp\",INDEX(GET.WORKSPACE(37),5))","v":true},null,null,null,null,{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},null,null,null,{"$f":"  SET.NAME(\"Nrows\",GET.DOCUMENT(10))","v":true},null,null,{"$f":"ALIGNMENT(3,FALSE,3,0)","v":false},{"$f":"    BREAK()","v":true},{"$f":"  dld_gotocell_RC(1,1,1,14,TRUE)","v":false},{"$f":"  SET.NAME(\"Ntmp\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&4&Asep&Arow&Irow&Acol&Ncols,FALSE)))","v":true},{"$f":"    END.IF()","v":true},{"$f":"  IF(Atmp=\"CO\",SET.NAME(\"Nctl\",Nctl+1))","v":false},{"$f":"BORDER(0,0,0,0,1)","v":true},{"$f":"IF(Imis>0.5)","v":true},"! Loop over Standards",{"$f":"ELSE()","v":true},{"$f":"ELSE()","v":true},"! Loop over all Controls",{"$f":"FORMULA(\"Control\",Arow&4&Acol&4*Nblk+1)","v":true},{"$f":"  FORMULA.GOTO(Arow&36&Acol&1,FALSE)","v":true},{"$f":"ZOOM(CurZoom)","v":true},null,null,null,null,null,{"$f":"FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},null,{"$f":"SELECT(\"CmdBut07\")","v":true}]
[{"$f":"SET.NAME(\"Arow\",INDEX(GET.WORKSPACE(37),6))","v":true},null,null,null,null,{"$f":"FORMULA.GOTO(Arow&23&Acol&1,FALSE)","v":true},null,"! Update ControlPanel",null,null,"! Get file info",null,{"$f":"BORDER(1)","v":true},{"$f":"  END.IF()","v":false},{"$f":"  HALT()","v":true},{"$f":"  IF(Ntmp<0.5,FORMULA(\"Blank\",INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&1,FALSE)))","v":false},{"$f":"    FORMULA(\"'\"&Aall,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Nall&Acol&3,FALSE))","v":true},{"$f":"  IF(Atmp=\"EV\",SET.NAME(\"Nevi\",Nevi+1))","v":false},null,{"$f":"  SET.NAME(\"Atmp1\",\"'\"&INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&7,FALSE))","v":true},{"$f":"  FOR(\"Irow\",Irow0,Irow1,1)","v":true},null,null,{"$f":"  FOR(\"Irow\",Irow0,Irow1,1)","v":true},{"$f":"FORMULA(\"Sample\",Arow&4&Acol&4*Nblk+2)","v":true},{"$f":"END.IF()","v":true},{"$f":"FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},null,null,null,null,null,null,null,{"$f":"FORMAT.SIZE(83,24)","v":true}]
[{"$f":"SET.NAME(\"Asep\",\":\")","v":true},null,null,null,null,null,null,{"$f":"RUN(MUM_DisSum,FALSE)","v":{"$error":"#N/A"}},null,"! Do profile types",{"$f":"SET.NAME(\"Dir_1\",GET.DOCUMENT(2))","v":true},null,{"$f":"SELECT(Arow&4&Acol&1&Asep&Arow&4&Acol&2)","v":false},{"$f":"NEXT()","v":true},{"$f":"END.IF()","v":false},{"$f":"NEXT()","v":true},{"$f":"    SET.NAME(\"Ichr0\",Ichr1)","v":true},{"$f":"  IF(Atmp=\"SU\",SET.NAME(\"Nsus\",Nsus+1))","v":false},"!  Make composites",{"$f":"  FOR(\"Iall\",2,Imis,1)","v":true},{"$f":"    MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&U$1&\"> Standard \"&Irow-Irow0+1&\" of \"&Irow1-Irow0+1)","v":true},"! Loop over Standards","! Loop over Evidence",{"$f":"    MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&X$1&\"> Control \"&Irow-Irow0+1&\" of \"&Irow1-Irow0+1)","v":true},null,null,null,null,null,null,null,null,"! Hide worksheet",null,{"$f":"FORMAT.MOVE(8,2,Arow&20&Acol&1)","v":true}]
[null,null,null,null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&F$1&\"> Finished.\")","v":true},null,{"$f":"FORMULA.GOTO(Arow&8&Acol&1,FALSE)","v":true},null,{"$f":"  FOR(\"Itmp\",1,8,1)","v":true},{"$f":"SET.NAME(\"WB_1\",GET.DOCUMENT(88))","v":true},null,{"$f":"ALIGNMENT(3,FALSE,3,0)","v":false},null,null,null,{"$f":"  NEXT()","v":true},{"$f":"  IF(Atmp=\"VI\",SET.NAME(\"Nvic\",Nvic+1))","v":false},{"$f":"SET.NAME(\"Nloc\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&4&Asep&Arow&4&Acol&256,FALSE)))","v":true},{"$f":"    SET.NAME(\"Atmp1\",Atmp1&\",\"&INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iall&Acol&7,FALSE))","v":true},null,{"$f":"  FOR(\"Irow\",Irow0,Irow1,1)","v":true},{"$f":"  FOR(\"Irow\",Irow0,Irow1,1)","v":true},null,{"$f":"FOR(\"Itmp\",1,5,1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\" \"&Z$1&\" > Finished!\")","v":true},{"$f":"ACTIVATE(S0rme)","v":true},null,null,null,null,null,{"$f":"ERROR(FALSE)","v":true}]
["! Store a few workspace parameters",null,null,null,null,{"$f":"RETURN()","v":true},null,null,null,{"$f":"    SET.NAME(\"Ntmp\"&Itmp,0)","v":true},{"$f":"SET.NAME(\"Asht\",GET.WORKBOOK(38))","v":true},null,{"$f":"BORDER(1)","v":true},"! Get where the loci start","! Get file info","! Check row/column recognition",null,{"$f":"  IF(Atmp=\"XC\",SET.NAME(\"Nxcl\",Nxcl+1))","v":false},{"$f":"FOR(\"Icol\",4,Nloc+3,1)","v":true},{"$f":"  NEXT()","v":true},{"$f":"    SET.NAME(\"Jrtr\",3+(Irow-Irow0)*(Nloc+5))","v":true},{"$f":"    MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&V$1&\"> Standard \"&Irow-Irow0+1&\" of \"&Irow1-Irow0+1)","v":true},{"$f":"    MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&W$1&\"> Evidence \"&Irow-Irow0+1&\" of \"&Irow1-Irow0+1)","v":true},{"$f":"    SET.NAME(\"Jrtr\",3+(Irow-Irow0)*(Nloc+5))","v":true},{"$f":"  SELECT(Arow&3&Acol&(Itmp-1)*Nblk+1&Asep&Arow&3&Acol&Itmp*Nblk-1)","v":true},{"$f":"RETURN()","v":true},{"$f":"ZOOM(CurZoom)","v":true},null,null,null,null,null,{"$f":"  WORKBOOK.HIDE(MID(S0dti,FIND(\"]\",S0dti)+1,100))","v":true},null,{"$f":"SELECT(\"CmdBut11\")","v":true}]
[{"$f":"FORMULA(GET.WORKSPACE(4),INDIRECT(\"'\"&S0mac&\"'!\"&Arow&2&Acol&3,FALSE))","v":true},null,null,null,null,null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&H$1&\"> Finished.\")","v":true},null,{"$f":"  NEXT()","v":true},{"$f":"SET.NAME(\"S1dat\",\"[\"&WB_1&\"]\"&Asht)","v":true},null,null,{"$f":"SET.NAME(\"Icol2\",MATCH(1,INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow0+1,FALSE),0))","v":true},{"$f":"SET.NAME(\"Dir_1\",GET.DOCUMENT(2))","v":true},{"$f":"SET.NAME(\"Atitle\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&1&Acol&1,FALSE)))","v":true},"! Sort",{"$f":"NEXT()","v":true},{"$f":"  SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Icol,FALSE)))","v":true},{"$f":"END.IF()","v":true},{"$f":"    SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&2,FALSE)))","v":true},null,null,{"$f":"    SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&2,FALSE)))","v":true},{"$f":"  ALIGNMENT(7,FALSE,3,0)","v":true},null,{"$f":"FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},null,null,null,null,null,null,null,{"$f":"FORMAT.SIZE(89,36)","v":true}]
[{"$f":"FORMULA(GET.DOCUMENT(14),INDIRECT(\"'\"&S0mac&\"'!\"&Arow&3&Acol&3,FALSE))","v":true},null,null,null,null,null,null,{"$f":"RETURN()","v":true},null,{"$f":"  FOR(\"Irow\",1,Nrows,1)","v":true},null,null,"! Copy the data",{"$f":"IF(ISERROR(Icol2))","v":true},{"$f":"SET.NAME(\"WB_2\",GET.DOCUMENT(88))","v":true},{"$f":"IF(LEN(Atitle)<4.5)","v":true},{"$f":"  ACTIVATE(S0wrk)","v":true},null,{"$f":"  FORMULA(Asam,INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Icol+1&Acol&1,FALSE))","v":true},null,{"$f":"    SET.NAME(\"Istd\",Irow-Irow0+1)","v":true},{"$f":"    SET.NAME(\"Jrtr\",3+(Irow-Irow0)*(Nloc+5))","v":true},{"$f":"    SET.NAME(\"Jrtr\",3+(Irow-Irow0)*(Nloc+5))","v":true},{"$f":"    SET.NAME(\"Istd\",Irow-Irow0+1)","v":true},{"$f":"  FORMULA(\"'%A\",Arow&4&Acol&(Itmp-1)*Nblk+3)","v":true},null,null,null,null,null,null,null,{"$f":"  WORKBOOK.HIDE(MID(S0rme,FIND(\"]\",S0rme)+1,100))","v":true},null,{"$f":"FORMAT.MOVE(2,2,Arow&23&Acol&1)","v":true}]
[{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0mac&\"'!\"&Arow&4&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Atmp\",LEFT(CLEAN(UPPER(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4+Irow&Acol&1,FALSE))),2))","v":true},{"$f":"ACTIVATE(S1dat)","v":true},null,{"$f":"ACTIVATE(S1dat)","v":false},{"$f":"  FORMULA.GOTO(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&1&Acol&1,FALSE),TRUE)","v":true},{"$f":"SET.NAME(\"Asht\",GET.WORKBOOK(38))","v":true},{"$f":"  dld_gotocell_RC(1,1,1,1,TRUE)","v":0},{"$f":"  dld_selectcols(3,3,FALSE)","v":0},"! Record the numbers",null,"! Get alleles in at least one Evidence that aren't in Standard",{"$f":"    FORMULA(\"Locus\",Arow&Jrtr+1&Acol&1)","v":true},{"$f":"    SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&2,FALSE)))","v":true},{"$f":"    SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&2,FALSE)))","v":true},{"$f":"    FORMULA(\"Locus\",Arow&Jrtr+1&Acol&1)","v":true},{"$f":"  FORMULA(\"'%P\",Arow&4&Acol&(Itmp-1)*Nblk+4)","v":true},null,{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"  WORKBOOK.HIDE(MID(S0wrk,FIND(\"]\",S0wrk)+1,100))","v":true},null,{"$f":"SELECT(\"CmdBut12\")","v":true}]
[null,null,null,null,null,null,null,null,null,{"$f":"    IF(LEN(Atmp)>1.5)","v":true},{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},null,{"$f":"COPY(Arow&2&Acol&2&Asep&Arow&Nrows&Acol&Ncols)","v":false},{"$f":"  ACTIVATE(S1dat)","v":true},{"$f":"SET.NAME(\"S2dat\",\"[\"&WB_2&\"]\"&Asht)","v":true},{"$f":"  dld_msgbar(\"Row1Col4 must hold a dataset Title of at least five characters.\",TRUE)","v":0},{"$f":"  SORT(1,Acol&3,1,,,,,2)","v":true},{"$f":"FORMULA(\"Control\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&2&Acol&11,FALSE))","v":true},"! Loop over Xclude, Victim, Suspect, and Evidence",{"$f":"  SET.NAME(\"Nall\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&6,FALSE)))","v":true},{"$f":"    FORMULA(Asam,Arow&Jrtr+1&Acol&2)","v":true},{"$f":"    SET.NAME(\"Istd\",Irow-Irow0+1)","v":true},{"$f":"    SET.NAME(\"Istd\",Irow-Irow0+1)","v":true},{"$f":"    FORMULA(Asam,Arow&Jrtr+1&Acol&2)","v":true},{"$f":"  FORMULA(\"'%In\",Arow&4&Acol&(Itmp-1)*Nblk+5)","v":true},null,{"$f":"ACTIVATE(S0con)","v":true},null,null,null,null,null,{"$f":"ERROR(TRUE)","v":true},null,{"$f":"FORMAT.SIZE(89,36)","v":true}]
["! Is this the first time for a new user?",null,null,null,null,null,null,null,null,{"$f":"      IF(Atmp=\"BL\")","v":true},{"$f":"ZOOM(75)","v":true},null,{"$f":"ACTIVATE(S0dat)","v":false},{"$f":"  SELECT(Arow&Irow0+1)","v":true},{"$f":"ACTIVATE(S2dat)","v":true},{"$f":"  ALERT(S0dat&\"!Row1Col4 must hold a dataset Title of at least five characters.\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":true},{"$f":"  ACTIVATE(S0wrk)","v":true},{"$f":"IF(Nctl>0.5)","v":true},{"$f":"  FOR(\"Ityp\",1,4,1)","v":true},{"$f":"  SET.NAME(\"Imis\",0)","v":true},{"$f":"    SELECT(Arow&Jrtr&Asep&Arow&Jrtr+1)","v":true},{"$f":"    FORMULA(\"Locus\",Arow&Jrtr+1&Acol&1)","v":true},{"$f":"    FORMULA(\"Locus\",Arow&Jrtr+1&Acol&1)","v":true},{"$f":"    SELECT(Arow&Jrtr&Asep&Arow&Jrtr+1)","v":true},{"$f":"  SELECT(Arow&4&Acol&(Itmp-1)*Nblk+1&Asep&Arow&4&Acol&Itmp*Nblk-1)","v":true},null,{"$f":"ZOOM(CurZoom)","v":true},null,null,null,null,null,null,null,{"$f":"FORMAT.MOVE(2,2,Arow&28&Acol&1)","v":true}]
[{"$f":"SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0mac&\"'!\"&Arow&6&Acol&3,FALSE)))","v":true},null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Ntmp1\",Ntmp1+1)","v":true},{"$f":"FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},null,{"$f":"SELECT(Arow&5&Acol&4)","v":false},{"$f":"  dld_msgbar(\"Specified data sheet (\"&S1dat&\") does not have expected structure.\",TRUE)","v":0},{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},{"$f":"  HALT()","v":true},"! Get unique list",{"$f":"  SET.NAME(\"Irow\",MATCH(\"Control\",INDIRECT(\"'\"&S0dat&\"'!\"&Acol&1,FALSE),0))","v":true},{"$f":"    SET.NAME(\"Ntmp\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&2+Ityp&Acol&12,FALSE)))","v":true},{"$f":"  FOR(\"Iall\",1,Nall,1)","v":true},{"$f":"    ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"    FORMULA(Asam,Arow&Jrtr+1&Acol&2)","v":true},{"$f":"    FORMULA(Asam,Arow&Jrtr+1&Acol&2)","v":true},{"$f":"    ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"  ALIGNMENT(3,FALSE,3,0)","v":true},null,{"$f":"FORMULA.GOTO(Arow&28&Acol&1,FALSE)","v":true},null,null,null,null,null,"! Reset counter",null,{"$f":"SELECT(\"CmdBut13\")","v":true}]
[{"$f":"SET.NAME(\"Atmp1\",GET.WORKSPACE(26))","v":true},null,null,null,null,null,null,null,null,{"$f":"      ELSE.IF(Atmp=\"CO\")","v":true},null,null,{"$f":"PASTE.SPECIAL(1,1,FALSE,TRUE)","v":true},{"$f":"  ALERT(\"Expected allele indices (1 and 2) on row \"&Irow0+1&\" as marker for Loci.\"&Acar&Acar&\"Correct structure or try a different sheet.\",2)","v":true},null,{"$f":"END.IF()","v":false},{"$f":"  FOR(\"Iall\",1,Nall,1)","v":true},{"$f":"  FORMULA(Nctl,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&2&Acol&12,FALSE))","v":true},{"$f":"    IF(Ntmp>0)","v":true},{"$f":"    SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iall&Acol&6,FALSE)))","v":true},{"$f":"    SELECT(Arow&Jrtr+1&Acol&1&Asep&Arow&Jrtr+1&Acol&2)","v":true},{"$f":"    SELECT(Arow&Jrtr&Asep&Arow&Jrtr+1)","v":true},{"$f":"    SELECT(Arow&Jrtr&Asep&Arow&Jrtr+1)","v":true},{"$f":"    SELECT(Arow&Jrtr+1&Acol&1&Asep&Arow&Jrtr+1&Acol&2)","v":true},{"$f":"  BORDER(1)","v":true},null,null,null,null,null,null,null,{"$f":"ACTIVATE(S0mac)","v":true},null,{"$f":"FORMAT.SIZE(89,36)","v":true}]
[{"$f":"FORMULA(Atmp1,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&6&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Ntmp2\",Ntmp2+1)","v":true},"! Is this the right sheet?",null,{"$f":"BORDER(0,0,0,0,0)","v":true},{"$f":"  HALT()","v":true},{"$f":"ZOOM(75)","v":true},{"$f":"IF(COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&2,FALSE))>0)","v":true},{"$f":"    IF(NOT(ISBLANK(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iall&Acol&3,FALSE))))","v":true},{"$f":"  FORMULA(Irow,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&2&Acol&13,FALSE))","v":true},{"$f":"      SET.NAME(\"Irow1\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&2+Ityp&Acol&13,FALSE)))","v":true},{"$f":"    SET.NAME(\"Irtmp\",MATCH(Atmp,INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&5,FALSE),0))","v":true},{"$f":"    BORDER(0,0,0,0,1)","v":true},{"$f":"    ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"    ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"    BORDER(0,0,0,0,1)","v":true},{"$f":"NEXT()","v":true},null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\" \"&AA$1&\" > Finished!\")","v":true},null,null,null,null,null,{"$f":"dld_clearrange(6,3,7,3,FALSE)","v":0},null,{"$f":"FORMAT.MOVE(2,2,Arow&32&Acol&1)","v":true}]
[{"$f":"IF(Atmp=Atmp1)","v":true},null,null,null,null,null,null,null,null,{"$f":"      ELSE.IF(Atmp=\"DI\")","v":true},{"$f":"dld_msgbar(\"Is this the right sheet?\",TRUE)","v":0},null,{"$f":"PATTERNS(0)","v":true},{"$f":"END.IF()","v":false},{"$f":"FORMULA.GOTO(Arow&1&Acol&1,TRUE)","v":true},{"$f":"  dld_SELECTrows(2,2,TRUE)","v":false},{"$f":"      SET.NAME(\"Aall\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iall&Acol&3,FALSE)))","v":true},{"$f":"  FORMULA(Irow+Nctl-1,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&2&Acol&14,FALSE))","v":true},{"$f":"      SET.NAME(\"Irow2\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&2+Ityp&Acol&14,FALSE)))","v":true},{"$f":"    IF(ISERROR(Irtmp))","v":true},null,{"$f":"    SELECT(Arow&Jrtr+1&Acol&1&Asep&Arow&Jrtr+1&Acol&2)","v":true},{"$f":"    SELECT(Arow&Jrtr+1&Acol&1&Asep&Arow&Jrtr+1&Acol&2)","v":true},null,null,null,{"$f":"RETURN()","v":true},null,null,null,null,null,null,null,{"$f":"SELECT(\"CmdBut14\")","v":true}]
[{"$f":"  SET.NAME(\"Atmp2\",DEREF(INDIRECT(\"'\"&S0mac&\"'!\"&Arow&7&Acol&3,FALSE)))","v":true},null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Ntmp3\",Ntmp3+1)","v":true},{"$f":"SET.NAME(\"Atmp1\",ALERT(\"Is this the right sheet?\"&S1dat&\".\"&Acar&Acar&\"Click 'OK' if 'Yes', 'Cancel' for 'No'.\",1))","v":true},null,null,{"$f":"SET.NAME(\"Ntmp\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow0&Acol&Icol2,FALSE)))","v":true},null,{"$f":"  dld_msgbar(\"Row2 is expected to be <EMPTY>.\",TRUE)","v":false},{"$f":"      SET.NAME(\"Itmp\",MATCH(Aall,INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&3,FALSE),1))","v":true},{"$f":"END.IF()","v":true},{"$f":"      SET.NAME(\"Atmp\",\"\"&INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow1&Acol&Icol,FALSE))","v":true},{"$f":"      SET.NAME(\"Imis\",Imis+1)","v":true},"! Report the Standard and its total number of alleles",{"$f":"    BORDER(0,0,0,0,1)","v":true},{"$f":"    BORDER(0,0,0,0,1)","v":true},"! Report the sample and its total number of alleles",{"$f":"DLD_ScreenUpdateOn()","v":0},null,null,null,null,null,null,null,"! Restore globals",null,{"$f":"FORMAT.SIZE(89,36)","v":true}]
[{"$f":"  IF(ISERROR(Atmp2),SET.NAME(\"Atmp2\",0))","v":false},null,null,null,null,null,null,null,null,{"$f":"      ELSE.IF(Atmp=\"EV\")","v":true},{"$f":"IF(Atmp1=FALSE)","v":true},null,"! Do the work",{"$f":"IF(Ntmp<0.5)","v":true},"! Is this the right sheet?",{"$f":"  ALERT(S0dat&\"!Row2 is expected to be <EMPTY>.\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":false},{"$f":"      FORMULA(Itmp-Iall+1,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iall&Acol&4,FALSE))","v":true},null,{"$f":"      FOR(\"Irow\",Irow1+1,Irow2,1)","v":true},{"$f":"      FORMULA(Atmp,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Imis&Acol&8,FALSE))","v":true},{"$f":"    SET.NAME(\"Ntmp\",0)","v":true},null,null,{"$f":"    SET.NAME(\"Ntmp\",0)","v":true},{"$f":"dld_gotocell_RC(1,1,1,1,FALSE)","v":0},null,null,null,null,null,null,null,{"$f":"RUN(MUM_Globals,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"FORMAT.MOVE(2,2,Arow&36&Acol&1)","v":true}]
[{"$f":"  SET.NAME(\"Atmp2\",Atmp2+1)","v":true},null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Ntmp4\",Ntmp4+1)","v":true},{"$f":"  dld_msgbar(\"Activate the desired sheet, save the file, and try again!\",TRUE)","v":0},null,{"$f":"DLD_CleanAlleles()","v":false},{"$f":"  FORMULA.GOTO(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&1&Acol&1,FALSE),TRUE)","v":false},{"$f":"dld_msgbar(\"Is this the right sheet?\"&S2dat&\".\",TRUE)","v":0},{"$f":"  HALT()","v":true},null,{"$f":"FORMULA(\"Xclude\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&11,FALSE))","v":true},{"$f":"        SET.NAME(\"Atmp\",Atmp&\",\"&INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE))","v":true},{"$f":"    END.IF()","v":true},{"$f":"    FOR(\"Icol\",Icol0,Icol1,1)","v":true},"! Report the Standard and its total number of alleles","! Report the Standard and its total number of alleles",{"$f":"    FOR(\"Icol\",Icol0,Icol1,1)","v":true}]
[{"$f":"ELSE()","v":true},null,null,null,null,null,null,null,null,{"$f":"      ELSE.IF(Atmp=\"SU\")","v":true},{"$f":"  ALERT(\"Activate the desired sheet, save the file, and try this again.\",2)","v":true},null,null,{"$f":"  ACTIVATE(S1dat)","v":false},{"$f":"SET.NAME(\"Atmp1\",ALERT(\"Is this the right sheet?\"&S2dat&\".\"&Acar&Acar&\"Click 'OK' if 'Yes', 'Cancel' for 'No'.\",1))","v":true},{"$f":"END.IF()","v":false},"! Take care of simple replicates",{"$f":"IF(Nxcl>0.5)","v":true},null,{"$f":"  NEXT()","v":true},{"$f":"      SET.NAME(\"Aloc\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Icol,FALSE)))","v":true},{"$f":"    SET.NAME(\"Ntmp\",0)","v":true},{"$f":"    SET.NAME(\"Ntmp\",0)","v":true},{"$f":"      SET.NAME(\"Aloc\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Icol,FALSE)))","v":true},"! Do the Standards x Evidence",null,null,null,null,null,null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&AG$1&\"> Finished.\")","v":true},null,{"$f":"SELECT(\"CmdBut21\")","v":true}]
[{"$f":"  SET.NAME(\"Atmp2\",1)","v":true},null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Ntmp5\",Ntmp5+1)","v":true},{"$f":"  HALT()","v":true},null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&M$1&\"> Finished.\")","v":false},{"$f":"  SELECT(Arow&Irow0&Acol&Icol2)","v":false},{"$f":"IF(Atmp1=FALSE)","v":true},null,{"$f":"      IF(Itmp>Iall,dld_clearrange(Iall+1,3,Itmp,4,FALSE))","v":0},{"$f":"  SET.NAME(\"Irow\",MATCH(\"Xclude\",INDIRECT(\"'\"&S0dat&\"'!\"&Acol&1,FALSE),0))","v":true},"! Take care of too-long lists",{"$f":"  SET.NAME(\"Atmp2\",\"\")","v":true},{"$f":"      FORMULA(Aloc,Arow&Jrtr+Icol-Icol0+2&Acol&1)","v":true},{"$f":"    FOR(\"Icol\",Icol0,Icol1,1)","v":true},{"$f":"    FOR(\"Icol\",Icol0,Icol1,1)","v":true},{"$f":"      FORMULA(Aloc,Arow&Jrtr+Icol-Icol0+2&Acol&1)","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&Y$1&\"> Standards x Evidence\")","v":true},null,null,null,null,null,null,null,{"$f":"HALT()","v":true},null,{"$f":"FORMAT.SIZE(89,24)","v":true}]
[{"$f":"END.IF()","v":true},null,null,null,null,null,null,null,null,{"$f":"      ELSE.IF(Atmp=\"VI\")","v":true},{"$f":"END.IF()","v":false},null,{"$f":"RETURN()","v":true},{"$f":" dld_msgbar(\"Specified data sheet (\"&S1dat&\") does not have expected structure.\",TRUE)","v":false},{"$f":"  dld_msgbar(\"Activate the desired sheet, save the file, and try again!\",TRUE)","v":false},{"$f":"IF(DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&1,FALSE))<>\"Type\")","v":true},null,{"$f":"  FORMULA(Nxcl,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&12,FALSE))","v":true},{"$f":"        IF(LEN(Atmp)>200)","v":true},{"$f":"  IF(Imis>0.5)","v":true},{"$f":"      SET.NAME(\"Atmp1\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE)))","v":true},{"$f":"      SET.NAME(\"Aloc\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Icol,FALSE)))","v":true},{"$f":"      SET.NAME(\"Aloc\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Icol,FALSE)))","v":true},{"$f":"      SET.NAME(\"Atmp1\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE)))","v":true},{"$f":"SET.NAME(\"Icol\",1)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"FORMAT.MOVE(2,2,Arow&61&Acol&1)","v":true}]
[{"$f":"FORMULA(Atmp2,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&7&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Ntmp6\",Ntmp6+1)","v":true},null,null,null,{"$f":"  ALERT(\"Expected a Locus name at column \"&Icol2&\" of row \"&Irow0&\".\"&Acar&Acar&\"Correct structure or try a different sheet.\",2)","v":false},{"$f":"  ALERT(\"Activate the desired sheet, save the file, and try this again.\",2)","v":true},{"$f":"  dld_gotocell_RC(1,1,4,1,TRUE)","v":false},"! If this is a \"weak\", look to see if there was a \"strong\"",{"$f":"  FORMULA(Irow,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&13,FALSE))","v":true},{"$f":"          RUN(\"MUM_AllelesList\",FALSE)","v":{"$error":"#N/A"}},{"$f":"    SET.NAME(\"Atmp2\",\"'\"&INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&8,FALSE))","v":true},{"$f":"      IF(ISERROR(Atmp1),SET.NAME(\"Atmp1\",0))","v":false},{"$f":"      FORMULA(Aloc,Arow&Jrtr+Icol-Icol0+2&Acol&1)","v":true},{"$f":"      FORMULA(Aloc,Arow&Jrtr+Icol-Icol0+2&Acol&1)","v":true},{"$f":"      IF(ISERROR(Atmp1),SET.NAME(\"Atmp1\",0))","v":false},{"$f":"IF(OR(Nstd<0.5,Nevi<0.5))","v":true},null,null,null,null,null,null,null,null,null,{"$f":"SELECT(\"CmdBut22\")","v":true}]
[null,null,null,null,null,null,null,null,null,{"$f":"      ELSE.IF(Atmp=\"XC\")","v":true},"! Fetch data",null,null,{"$f":"  HALT()","v":true},{"$f":"  HALT()","v":true},{"$f":"  dld_msgbar(\"Row4Col1 is expected to be 'Type'.\",TRUE)","v":false},{"$f":"      IF(RIGHT(Aall,1)=\"*\")","v":true},{"$f":"  FORMULA(Irow+Nxcl-1,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&14,FALSE))","v":true},{"$f":"          ACTIVATE(S0rp1)","v":false},{"$f":"    FOR(\"Iall\",2,Imis,1)","v":true},{"$f":"      IF(Atmp1<>0)","v":true},{"$f":"      SET.NAME(\"Atmp1\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE)))","v":true},{"$f":"      SET.NAME(\"Atmp1\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE)))","v":true},{"$f":"      IF(Atmp1<>0)","v":true},{"$f":"  FORMULA(\"Unavailable\",Arow&5&Acol&Icol)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"FORMAT.SIZE(89,24)","v":true}]
["! Turn calculation off and set to R1C1",null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Ntmp7\",Ntmp7+1)","v":true},{"$f":"ACTIVATE(S1dat)","v":true},null,null,{"$f":"END.IF()","v":false},{"$f":"END.IF()","v":false},{"$f":"  ALERT(S0dat&\"!Row4Col1 is expected to be 'Type'.\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":false},{"$f":"        SET.NAME(\"Itmp\",MATCH(LEFT(Aall,LEN(Aall)-1),INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&3,FALSE),0))","v":true},{"$f":"END.IF()","v":true},{"$f":"          SET.NAME(\"Atmp\",Anew)","v":true},{"$f":"      SET.NAME(\"Atmp2\",Atmp2&\",\"&INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iall&Acol&8,FALSE))","v":true},{"$f":"        FORMULA(Atmp1,Arow&Jrtr+Icol-Icol0+2&Acol&2)","v":true},{"$f":"      IF(ISERROR(Atmp1),SET.NAME(\"Atmp1\",0))","v":false},{"$f":"      IF(ISERROR(Atmp1),SET.NAME(\"Atmp1\",0))","v":false},{"$f":"        FORMULA(Atmp1,Arow&Jrtr+Icol-Icol0+2&Acol&2)","v":true},{"$f":"  SELECT(Arow&5&Acol&Icol&Asep&Arow&5&Acol&Icol+Nblk-2)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"FORMAT.MOVE(2,2,Arow&64&Acol&1)","v":true}]
[{"$f":"OPTIONS.CALCULATION(3)","v":true},null,null,null,null,null,null,null,null,{"$f":"      ELSE()","v":true},{"$f":"SET.NAME(\"Nrow\",dld_findrowlast())","v":true},null,null,null,null,{"$f":"  HALT()","v":true},{"$f":"        IF(NOT(ISERROR(Itmp)))","v":true},null,{"$f":"        END.IF()","v":true},{"$f":"    NEXT()","v":true},{"$f":"        SET.NAME(\"Ntmp\",Ntmp+1)","v":true},{"$f":"      IF(Atmp1<>0)","v":true},{"$f":"      IF(Atmp1<>0)","v":true},{"$f":"        SET.NAME(\"Ntmp\",Ntmp+1)","v":true},{"$f":"  ALIGNMENT(7,FALSE,3,0)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"SELECT(\"CmdBut23\")","v":true}]
[{"$f":"A1.R1C1(FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Ntmp8\",Ntmp8+1)","v":true},{"$f":"SET.NAME(\"Itmp\",MATCH(\"Sample\",INDIRECT(\"'\"&S1dat&\"'!\"&Arow&1&Acol&1&Asep&Arow&Nrow&Acol&1,FALSE),0))","v":true},null,null,"! Make Title and Locus header","! Find row that holds locus names",{"$f":"END.IF()","v":false},{"$f":"          SET.NAME(\"Itmp1\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iall&Acol&4,FALSE)))","v":true},{"$f":"FORMULA(\"Victim\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&4&Acol&11,FALSE))","v":true},{"$f":"      NEXT()","v":true},{"$f":"  END.IF()","v":true},{"$f":"        FOR(\"Ichr\",1,LEN(Atmp1),1)","v":true},{"$f":"        FORMULA(Atmp1,Arow&Jrtr+Icol-Icol0+2&Acol&2)","v":true},{"$f":"        FORMULA(Atmp1,Arow&Jrtr+Icol-Icol0+2&Acol&2)","v":true},{"$f":"        FOR(\"Ichr\",1,LEN(Atmp1),1)","v":true},{"$f":"  FORMULA(\"Unavailable\",Arow&5&Acol&Icol+Nblk)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"FORMAT.SIZE(89,24)","v":true}]
[{"$f":"COLOR.PALETTE(\"\")","v":true},null,null,null,null,null,null,null,null,{"$f":"      END.IF()","v":true},{"$f":"SET.NAME(\"Jtmp\",MATCH(\"Generate CMF\",INDIRECT(\"'\"&S1dat&\"'!\"&Arow&1&Acol&1&Asep&Arow&Nrow&Acol&1,FALSE),0))","v":true},null,null,{"$f":"ACTIVATE(S0dat)","v":true},{"$f":"SET.NAME(\"Aloc\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&4,FALSE)))","v":true},{"$f":"IF(DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&2,FALSE))<>\"Description\")","v":true},{"$f":"          SET.NAME(\"Itmp2\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Itmp&Acol&4,FALSE)))","v":true},{"$f":"IF(Nvic>0.5)","v":true},null,null,{"$f":"          IF(MID(Atmp1,Ichr,1)=\",\",SET.NAME(\"Ntmp\",Ntmp+1))","v":false},{"$f":"        SET.NAME(\"Ntmp\",Ntmp+1)","v":true},{"$f":"        SET.NAME(\"Ntmp\",Ntmp+1)","v":true},{"$f":"          IF(MID(Atmp1,Ichr,1)=\",\",SET.NAME(\"Ntmp\",Ntmp+1))","v":false},{"$f":"  SELECT(Arow&5&Acol&Icol+Nblk&Asep&Arow&5&Acol&Icol+2*Nblk-2)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"FORMAT.MOVE(2,2,Arow&67&Acol&1)","v":true}]
[{"$f":"SET.NAME(\"Mlen\",30)","v":true},null,null,null,null,null,null,null,null,{"$f":"    END.IF()","v":true},{"$f":"IF(NOT(ISERROR(Itmp)))","v":true},null,null,{"$f":"FORMULA(\"Data from: \"&Dir_1&\"\\\"&S1dat,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&1&Acol&1,FALSE))","v":true},{"$f":"SET.NAME(\"Irow0\",-1)","v":true},{"$f":"  dld_gotocell_RC(1,1,4,2,TRUE)","v":false},{"$f":"          FORMULA(Itmp1+Itmp2,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Itmp&Acol&4,FALSE))","v":true},{"$f":"  SET.NAME(\"Irow\",MATCH(\"Victim\",INDIRECT(\"'\"&S0dat&\"'!\"&Acol&1,FALSE),0))","v":true},{"$f":"      RUN(\"MUM_AllelesList\",FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(Atmp2=\"'0\",SET.NAME(\"Atmp2\",\"\"))","v":false},{"$f":"        NEXT()","v":true},{"$f":"        FOR(\"Ichr\",1,LEN(Atmp1),1)","v":true},{"$f":"        FOR(\"Ichr\",1,LEN(Atmp1),1)","v":true},{"$f":"        NEXT()","v":true},{"$f":"  ALIGNMENT(7,FALSE,3,0)","v":true}]
[null,null,null,null,null,null,null,null,null,{"$f":"  NEXT()","v":true},{"$f":"  RUN(MUM_DataFetch_Basic,FALSE)","v":{"$error":"#N/A"}},null,null,null,{"$f":"SET.NAME(\"Nnew\",GET.DOCUMENT(10))","v":true},{"$f":"  dld_msgbar(S0dat&\"!Row4Col2 is expected to be 'Description'.\",TRUE)","v":false},{"$f":"          dld_clearrange(Iali,3,Iall,4,FALSE)","v":false},{"$f":"  FORMULA(Nvic,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&4&Acol&12,FALSE))","v":true},{"$f":"      ACTIVATE(S0rp1)","v":true},null,{"$f":"      END.IF()","v":true},{"$f":"          IF(MID(Atmp1,Ichr,1)=\",\",SET.NAME(\"Ntmp\",Ntmp+1))","v":false},{"$f":"          IF(MID(Atmp1,Ichr,1)=\",\",SET.NAME(\"Ntmp\",Ntmp+1))","v":false},{"$f":"      END.IF()","v":true},{"$f":"ELSE()","v":true},null,null,null,null,null,null,null,null,null,{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0}]
["! Check that the language dependencies are set",null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Ntmp\",0)","v":true},{"$f":"ELSE.IF(NOT(ISERROR(Jtmp)))","v":true},null,null,{"$f":"SET.NAME(\"Nloc\",0)","v":true},{"$f":"FOR(\"Irow\",1,Nnew,1)","v":true},{"$f":"  ALERT(S0dat&\"!Row4Col2 is expected to be 'Description'.\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":false},{"$f":"        END.IF()","v":true},{"$f":"  FORMULA(Irow,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&4&Acol&13,FALSE))","v":true},{"$f":"      FORMULA(\"'\"&Anew,INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Icol+1&Acol&1+IF(Ityp<3.5,Ityp,5),FALSE))","v":true},{"$f":"RETURN()","v":true},{"$f":"    NEXT()","v":true},{"$f":"        NEXT()","v":true},{"$f":"        NEXT()","v":true},{"$f":"    NEXT()","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"HALT()","v":true}]
[{"$f":"ACTIVATE(S0dti)","v":true},null,null,null,null,null,null,null,null,{"$f":"  FOR(\"Itmp\",1,8,1)","v":true},{"$f":"  RUN(MUM_DataFetch_BodeData,FALSE)","v":false},null,null,{"$f":"FOR(\"Icol\",Icol2,Icol1,1)","v":true},{"$f":"  SET.NAME(\"Itmp\",MATCH(Aloc,INDIRECT(\"'\"&S2dat&\"'!\"&Arow&Irow,FALSE),0))","v":true},{"$f":"  HALT()","v":true},{"$f":"      END.IF()","v":true},{"$f":"  FORMULA(Irow+Nvic-1,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&4&Acol&14,FALSE))","v":true},{"$f":"    END.IF()","v":true},null,{"$f":"    FORMULA(\"# Alleles\",Arow&Jrtr+Icol1-Icol0+3&Acol&1)","v":true},{"$f":"      END.IF()","v":true},{"$f":"      END.IF()","v":true},{"$f":"    FORMULA(\"# Alleles\",Arow&Jrtr+Icol1-Icol0+3&Acol&1)","v":true},"! Loop over Standards",null,null,null,null,null,null,null,null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&AI$1&\"> Finished.\")","v":true}]
[{"$f":"ERROR(FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Atmp\",EVALUATE(\"Ntmp\"&Itmp))","v":true},{"$f":"ELSE()","v":true},null,null,{"$f":"  SET.NAME(\"Ntmp\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow0&Acol&Icol,FALSE)))","v":true},{"$f":"  IF(NOT(ISERROR(Itmp)))","v":true},{"$f":"END.IF()","v":false},{"$f":"  END.IF()","v":true},{"$f":"END.IF()","v":true},{"$f":"  NEXT()","v":true},null,{"$f":"    FORMULA(Ntmp,Arow&Jrtr+Icol1-Icol0+3&Acol&2)","v":true},{"$f":"    NEXT()","v":true},{"$f":"    NEXT()","v":true},{"$f":"    FORMULA(Ntmp,Arow&Jrtr+Icol1-Icol0+3&Acol&2)","v":true},{"$f":"  FOR(\"Istd\",1,Nstd,1)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"HALT()","v":true}]
[{"$f":"  WORKBOOK.UNHIDE(\"DateTime\")","v":true},null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Ntmp\",Ntmp+Atmp)","v":true},{"$f":"  RUN(MUM_DataFetch_Standard,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"  IF(Ntmp>0.5)","v":true},{"$f":"    SET.NAME(\"Irow0\",Irow)","v":true},{"$f":"IF(COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&3,FALSE))>0)","v":true},{"$f":"NEXT()","v":true},null,null,null,{"$f":"    FORMULA(\"# Loci: In, Ex, Total\",Arow&Jrtr+Icol1-Icol0+4&Acol&2)","v":true},{"$f":"    FORMULA(\"# Alleles\",Arow&Jrtr+Icol1-Icol0+3&Acol&1)","v":true},{"$f":"    FORMULA(\"# Alleles\",Arow&Jrtr+Icol1-Icol0+3&Acol&1)","v":true},{"$f":"    FORMULA(\"# Loci: In, Ex, Total\",Arow&Jrtr+Icol1-Icol0+4&Acol&2)","v":true},{"$f":"    SET.NAME(\"Jrtr\",3+(Istd-1)*(Nloc+5))","v":true}]
[{"$f":"  SET.NAME(\"Itmp\",FORMULA.GOTO(Arow&1&Acol&1,TRUE))","v":true},null,null,null,null,null,null,null,null,{"$f":"    FORMULA(Atmp,INDIRECT(\"'\"&S0con&\"'!\"&Arow&2+Itmp&Acol&9,FALSE))","v":true},{"$f":"END.IF()","v":true},null,null,{"$f":"    SET.NAME(\"Nloc\",Nloc+1)","v":true},{"$f":"    BREAK()","v":true},{"$f":"  dld_SELECTrows(3,3,TRUE)","v":0},null,{"$f":"FORMULA(\"Suspect\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&5&Acol&11,FALSE))","v":true},"! Combine Xclude, Victim, and Suspect",null,{"$f":"    SELECT(Arow&Jrtr+2&Acol&1&Asep&Arow&Jrtr+1+Nloc&Acol&2)","v":true},{"$f":"    FORMULA(Ntmp,Arow&Jrtr+Icol1-Icol0+3&Acol&2)","v":true},{"$f":"    FORMULA(Ntmp,Arow&Jrtr+Icol1-Icol0+3&Acol&2)","v":true},{"$f":"    SELECT(Arow&Jrtr+2&Acol&1&Asep&Arow&Jrtr+1+Nloc&Acol&2)","v":true},{"$f":"    SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr+1&Acol&2,FALSE)))","v":true}]
[{"$f":"  IF(ISERROR(Itmp))","v":true},null,null,null,null,null,null,null,null,{"$f":"  NEXT()","v":true},null,null,null,{"$f":"    SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow0&Acol&Icol,FALSE)))","v":true},{"$f":"  END.IF()","v":false},{"$f":"  dld_msgbar(S0dat&\"!Col3 is expected to be <EMPTY>.\",TRUE)","v":0},"! ReSort",{"$f":"IF(Nsus>0.5)","v":true},{"$f":"  SET.NAME(\"Atmp\",INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Icol+1&Acol&2,FALSE)&\",\"&INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Icol+1&Acol&3,FALSE)&\",\"&INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Icol+1&Acol&4,FALSE))","v":true},null,{"$f":"    BORDER(1)","v":true},{"$f":"    FORMULA(\"# Loci: In, Ex, Total\",Arow&Jrtr+Icol1-Icol0+4&Acol&2)","v":true},{"$f":"    FORMULA(\"# Loci: In, Ex, Total\",Arow&Jrtr+Icol1-Icol0+4&Acol&2)","v":true},{"$f":"    BORDER(1)","v":true},{"$f":"    SET.NAME(\"Ntmp\",DEREF(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr+Nloc+2&Acol&2,FALSE)))","v":true}]
[{"$f":"  HIDE()","v":true},null,null,null,null,null,null,null,null,{"$f":"  FORMULA(Ntmp,INDIRECT(\"'\"&S0con&\"'!\"&Arow&12&Acol&9,FALSE))","v":true},"! Close the old file",null,null,{"$f":"    FORMULA(Atmp,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Nloc+3,FALSE))","v":true},{"$f":"NEXT()","v":true},{"$f":"  ALERT(S0dat&\"!Col3 is expected to be <EMPTY>.\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":true},{"$f":"  ACTIVATE(S0wrk)","v":true},{"$f":"  SET.NAME(\"Irow\",MATCH(\"Suspect\",INDIRECT(\"'\"&S0dat&\"'!\"&Acol&1,FALSE),0))","v":true},{"$f":"  RUN(\"MUM_AllelesList\",FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"    SELECT(Arow&Jrtr+2&Acol&1&Asep&Arow&Jrtr+1+Nloc&Acol&2)","v":true},{"$f":"    SELECT(Arow&Jrtr+2&Acol&1&Asep&Arow&Jrtr+1+Nloc&Acol&2)","v":true}]
[{"$f":"END.IF()","v":true},null,null,null,null,null,null,null,null,null,{"$f":"ACTIVATE(S1dat)","v":true},null,null,{"$f":"  END.IF()","v":true},{"$f":"IF(Irow0<0.5)","v":true},{"$f":"  HALT()","v":true},{"$f":"  dld_selectcols(3,4,FALSE)","v":0},{"$f":"  FORMULA(Nsus,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&5&Acol&12,FALSE))","v":true},{"$f":"  ACTIVATE(S0rp1)","v":true},null,"! Loop over Evidence",{"$f":"    BORDER(1)","v":true},{"$f":"    BORDER(1)","v":true},"! Loop over the controls","! Loop over Evidence"]
[{"$f":"ERROR(TRUE)","v":true},null,null,null,null,null,null,null,null,"! Do profile types",{"$f":"CLOSE(FALSE)","v":true},null,null,{"$f":"NEXT()","v":true},{"$f":"  dld_msgbar(\"Could not locate locus: \"&Aloc&\"!\",TRUE)","v":false},{"$f":"END.IF()","v":false},{"$f":"  SORT(1,Acol&3,1,,,,,2)","v":true},{"$f":"  FORMULA(Irow,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&5&Acol&13,FALSE))","v":true},{"$f":"  FORMULA(\"'\"&Anew,INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Icol+1&Acol&5,FALSE))","v":true},null,{"$f":"    FOR(\"Jrow\",Jrow0,Jrow1,1)","v":true},null,null,{"$f":"    FOR(\"Jrow\",Jrow0,Jrow1,1)","v":true},{"$f":"    FOR(\"Ievi\",1,Nevi,1)","v":true}]
[null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Ncols\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&\"\"&Arow&4&Acol&4&Asep&Arow&4&Acol&256,FALSE)))","v":true},null,null,null,{"$f":"ACTIVATE(S0dat)","v":true},{"$f":"  ALERT(\"Locus \"&Aloc&\" was not found on Sheet \"&S2dat&\"!\"&Hret&Acar&\"Make sure that all loci on the Data sheet are available and try again!\",2)","v":false},{"$f":"IF(DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&3&Acol&4,FALSE))<>\"Loci\")","v":true},{"$f":"  SET.NAME(\"Nall\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&3,FALSE)))","v":true},{"$f":"  FORMULA(Irow+Nsus-1,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&5&Acol&14,FALSE))","v":true},null,null,{"$f":"      SET.NAME(\"Jctr\",4+(Jrow-Jrow0)*5)","v":true},"! Loop over other Standards","! Loop over other Evidence",{"$f":"      SET.NAME(\"Jctr\",4+(Jrow-Jrow0)*5)","v":true},{"$f":"      SET.NAME(\"Jctr\",4+(Ievi-1)*5)","v":true}]
["! Get the current formats",null,null,null,null,null,null,null,null,{"$f":"  FOR(\"Itmp\",1,Ncols,1)","v":true},"! Try to assign types from contents of sample label and/or presence/absence of alleles",null,null,{"$f":"SELECT(Arow&1&Acol&1&Asep&Arow&1&Acol&3+Nloc)","v":true},{"$f":"  HALT()","v":true},{"$f":"  dld_gotocell_RC(1,1,3,4,TRUE)","v":false},null,{"$f":"END.IF()","v":true},"! Setup for flagging \"unsupported\" alleles",null,{"$f":"      SET.NAME(\"Aevi\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&2,FALSE)))","v":true},{"$f":"    FOR(\"Jrow\",Irow0,Irow1,1)","v":true},{"$f":"    FOR(\"Jrow\",Irow0,Irow1,1)","v":true},{"$f":"      SET.NAME(\"Acon\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&2,FALSE)))","v":true},{"$f":"      SET.NAME(\"Aevi\",DEREF(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr&Acol&Jctr,FALSE)))","v":true}]
[{"$f":"SET.NAME(\"Atmp\",NOW())","v":true},null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&3+Itmp,FALSE)))","v":true},{"$f":"ACTIVATE(S0dat)","v":true},null,null,{"$f":"FONT.PROPERTIES(\"Arial\",\"Bold\",14,,,,,,,1)","v":true},{"$f":"END.IF()","v":false},{"$f":"  dld_msgbar(S0dat&\"!Row3Col4 is expected to be 'Loci'.\",TRUE)","v":false},"! Make clean list",null,{"$f":"  IF(AND(Nxcl+Nvic+Nsus>0.5,Nevi>0.5))","v":true},null,null,{"$f":"      SET.NAME(\"Jctr\",4+(Jrow-Irow0)*5)","v":true},{"$f":"      SET.NAME(\"Jctr\",4+(Jrow-Irow0)*5)","v":true},{"$f":"      SET.NAME(\"Atyp\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&1,FALSE)))","v":true},{"$f":"      SET.NAME(\"Ntmp1\",DEREF(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr+Nloc+2&Acol&Jctr+1,FALSE)))","v":true}]
[{"$f":"FOR(\"Irow\",2,4,1)","v":true},null,null,null,null,null,null,null,null,{"$f":"    FORMULA(Atmp,INDIRECT(\"'\"&S0con&\"'!\"&Arow&2+Itmp&Acol&11,FALSE))","v":true},{"$f":"SET.NAME(\"Nsam\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&5&Acol&2&Asep&Arow&65536&Acol&2,FALSE)))","v":true},null,null,{"$f":"ALIGNMENT(7,FALSE,3,0)","v":true},null,{"$f":"  ALERT(S0dat&\"!Row3Col4 is expected to be 'Loci'.\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":false},{"$f":"  FOR(\"Iall\",1,Nall,1)","v":true},{"$f":"FORMULA(\"Evidence\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&6&Acol&11,FALSE))","v":true},{"$f":"    SET.NAME(\"Atmp1\",DEREF(INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Icol+1&Acol&5,FALSE)))","v":true},null,{"$f":"      FORMULA(Aevi,Arow&Jrtr&Acol&Jctr)","v":true},{"$f":"      SET.NAME(\"Aevi\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&2,FALSE)))","v":true},{"$f":"      SET.NAME(\"Aevi\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&2,FALSE)))","v":true},{"$f":"      FORMULA(Acon,Arow&Jrtr&Acol&Jctr)","v":true},{"$f":"      SET.NAME(\"Ntmp2\",DEREF(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr+Nloc+2&Acol&Jctr+2,FALSE)))","v":true}]
[{"$f":"  FORMULA(Atmp,INDIRECT(\"'\"&S0dti&\"'!\"&Arow&Irow&Acol&2,FALSE))","v":true},null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Atmp\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&5&Acol&3+Itmp&Asep&Arow&65536&Acol&3+Itmp,FALSE)))","v":true},{"$f":"SET.NAME(\"Nloc\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&4&Asep&Arow&4&Acol&256,FALSE)))","v":true},null,null,{"$f":"FORMULA(\"Sample\",INDIRECT(\"'\"&S0dat&\"'!\"&Arow&3&Acol&1,FALSE))","v":true},"! Now check for all the rest of 'em",{"$f":"  HALT()","v":true},{"$f":"    SET.NAME(\"Aall\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iall&Acol&3,FALSE)))","v":true},{"$f":"IF(Nevi>0.5)","v":true},{"$f":"    SET.NAME(\"Atmp2\",DEREF(INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Icol+1&Acol&6,FALSE)))","v":true},null,{"$f":"      FORMULA(\"Evidence\",Arow&Jrtr+1&Acol&Jctr)","v":true},{"$f":"      SET.NAME(\"Atyp\",IF(Irow=Jrow,\"Self\",\"Standard\"))","v":true},{"$f":"      SET.NAME(\"Atyp\",IF(Irow=Jrow,\"Self\",\"Evidence\"))","v":true},{"$f":"      FORMULA(Atyp,Arow&Jrtr+1&Acol&Jctr)","v":true},{"$f":"      SET.NAME(\"Ntmp3\",DEREF(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr+Nloc+3&Acol&Jctr+1,FALSE)))","v":true}]
[{"$f":"  SET.NAME(\"Atmp1\",GET.CELL(7,INDIRECT(\"'\"&S0dti&\"'!\"&Arow&Irow&Acol&2,FALSE)))","v":true},null,null,null,null,null,null,null,null,{"$f":"    FORMULA(Atmp,INDIRECT(\"'\"&S0con&\"'!\"&Arow&2+Itmp&Acol&12,FALSE))","v":true},{"$f":"SET.NAME(\"Ntyp\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&21,FALSE)))","v":true},null,null,{"$f":"SELECT(Arow&3&Acol&1&Asep&Arow&3&Acol&2)","v":true},{"$f":"SET.NAME(\"Icol0\",257)","v":true},{"$f":"END.IF()","v":false},{"$f":"    SET.NAME(\"Aall\",SUBSTITUTE(Aall,\".0\",\"\"))","v":true},{"$f":"  SET.NAME(\"Irow\",MATCH(\"Evidence\",INDIRECT(\"'\"&S0dat&\"'!\"&Acol&1,FALSE),0))","v":true},{"$f":"    RUN(\"MUM_AllelesCol\",FALSE)","v":{"$error":"#N/A"}},null,{"$f":"      FORMULA(\"#+\",Arow&Jrtr+1&Acol&Jctr+1)","v":true},{"$f":"      FORMULA(Aevi,Arow&Jrtr&Acol&Jctr)","v":true},{"$f":"      FORMULA(Aevi,Arow&Jrtr&Acol&Jctr)","v":true},{"$f":"      FORMULA(\"#+\",Arow&Jrtr+1&Acol&Jctr+1)","v":true},{"$f":"      SET.NAME(\"Ntmp4\",DEREF(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr+Nloc+3&Acol&Jctr+3,FALSE)))","v":true}]
[{"$f":"  IF(NOT(ISERROR(FIND(\";\",Atmp1))),SET.NAME(\"Atmp1\",LEFT(Atmp1,FIND(\";\",Atmp1)-1)))","v":false},null,null,null,null,null,null,null,null,{"$f":"  NEXT()","v":true},{"$f":"FOR(\"Isam\",1,Nsam,1)","v":true},null,null,{"$f":"ALIGNMENT(7,FALSE,3,0)","v":true},{"$f":"FOR(\"Iloc\",1,Nloc,1)","v":true},null,{"$f":"    WHILE(LEFT(Aall,1)=\"0\")","v":true},{"$f":"  FORMULA(Nevi,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&6&Acol&12,FALSE))","v":true},{"$f":"    ACTIVATE(S0rp1)","v":true},null,{"$f":"      FORMULA(\"#-\",Arow&Jrtr+1&Acol&Jctr+2)","v":true},{"$f":"      FORMULA(Atyp,Arow&Jrtr+1&Acol&Jctr)","v":true},{"$f":"      FORMULA(Atyp,Arow&Jrtr+1&Acol&Jctr)","v":true},{"$f":"      FORMULA(\"#-\",Arow&Jrtr+1&Acol&Jctr+2)","v":true},{"$f":"      FORMULA(Asam,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&4+Ievi+(Istd-1)*(Nevi+1)&Acol&Icol,FALSE))","v":true}]
[{"$f":"  IF(NOT(ISERROR(FIND(\"]\",Atmp1))),SET.NAME(\"Atmp1\",MID(Atmp1,FIND(\"]\",Atmp1)+1,100)))","v":false},null,null,null,null,null,null,null,null,{"$f":"END.IF()","v":true},{"$f":"  SET.NAME(\"Atyp\",\"Unassigned\")","v":true},null,null,{"$f":"FORMULA(\"Loci\",INDIRECT(\"'\"&S0dat&\"'!\"&Arow&3&Acol&4,FALSE))","v":true},{"$f":"  SET.NAME(\"Aloc\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&3+Iloc,FALSE)))","v":true},"! Get the numbers of the three types",{"$f":"        SET.NAME(\"Aall\",RIGHT(Aall,LEN(Aall)-1))","v":true},{"$f":"  FORMULA(Irow,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&6&Acol&13,FALSE))","v":true},{"$f":"    FORMULA(Atmp1,INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Icol+1&Acol&8,FALSE))","v":true},null,{"$f":"      FORMULA(\"'-Alleles\",Arow&Jrtr+1&Acol&Jctr+3)","v":true},{"$f":"      FORMULA(\"#+\",Arow&Jrtr+1&Acol&Jctr+1)","v":true},{"$f":"      FORMULA(\"#+\",Arow&Jrtr+1&Acol&Jctr+1)","v":true},{"$f":"      FORMULA(\"'-Alleles\",Arow&Jrtr+1&Acol&Jctr+3)","v":true},{"$f":"      FORMULA(Aevi,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&4+Ievi+(Istd-1)*(Nevi+1)&Acol&Icol+1,FALSE))","v":true}]
[{"$f":"  FORMULA(Atmp1,INDIRECT(\"'\"&S0dti&\"'!\"&Arow&Irow&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SELECT(Arow&3&Acol&4&Asep&Arow&3&Acol&3+Nloc)","v":true},{"$f":"  SET.NAME(\"Itmp\",MATCH(Aloc,INDIRECT(\"'\"&S2dat&\"'!\"&Arow&Irow0,FALSE),0))","v":true},{"$f":"SET.NAME(\"Nblk\",0)","v":true},{"$f":"    NEXT()","v":true},{"$f":"  FORMULA(Irow+Nevi-1,Arow&6&Acol&14)","v":true},{"$f":"    FORMULA(Atmp2,INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Icol+1&Acol&9,FALSE))","v":true},null,{"$f":"      SELECT(Arow&Jrtr&Acol&Jctr&Asep&Arow&Jrtr&Acol&Jctr+3)","v":true},{"$f":"      FORMULA(\"#-\",Arow&Jrtr+1&Acol&Jctr+2)","v":true},{"$f":"      FORMULA(\"#-\",Arow&Jrtr+1&Acol&Jctr+2)","v":true},{"$f":"      SELECT(Arow&Jrtr&Acol&Jctr&Asep&Arow&Jrtr&Acol&Jctr+3)","v":true},{"$f":"      IF(Ntmp>0.5,FORMULA(100*Ntmp1/Ntmp,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&4+Ievi+(Istd-1)*(Nevi+1)&Acol&Icol+2,FALSE)))","v":true}]
[{"$f":"  FORMULA(\"?\",INDIRECT(\"'\"&S0dti&\"'!\"&Arow&Irow&Acol&4,FALSE))","v":true},null,null,null,null,null,null,null,null,"! Update ControlPanel","! Any data?",null,null,{"$f":"ALIGNMENT(7,FALSE,3,0)","v":true},{"$f":"  IF(ISERROR(Itmp))","v":true},{"$f":"SET.NAME(\"Nctl\",0)","v":true},{"$f":"    SET.NAME(\"Anew\",IF(Iall<1.5,Aall,Anew&\",\"&Aall))","v":true},{"$f":"END.IF()","v":true},{"$f":"  END.IF()","v":true},null,{"$f":"      ALIGNMENT(7,FALSE,3,0)","v":true},{"$f":"      FORMULA(\"'-Alleles\",Arow&Jrtr+1&Acol&Jctr+3)","v":true},{"$f":"      FORMULA(\"'-Alleles\",Arow&Jrtr+1&Acol&Jctr+3)","v":true},{"$f":"      ALIGNMENT(7,FALSE,3,0)","v":true},{"$f":"      IF(Ntmp1+Ntmp2>0.5,FORMULA(100*Ntmp1/(Ntmp1+Ntmp2),INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&4+Ievi+(Istd-1)*(Nevi+1)&Acol&Icol+3,FALSE)))","v":true}]
[{"$f":"NEXT()","v":true},null,null,null,null,null,null,null,null,{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},{"$f":"  SET.NAME(\"Nall\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4+Isam&Acol&4&Asep&Arow&4+Isam&Acol&3+Nloc,FALSE)))","v":true},null,null,{"$f":"FORMULA(\"Type\",INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&1,FALSE))","v":true},{"$f":"    dld_msgbar(\"Could not locate locus: \"&Aloc&\"!\",TRUE)","v":0},{"$f":"SET.NAME(\"Ndis\",0)","v":true},{"$f":"  NEXT()","v":true},null,{"$f":"NEXT()","v":true},null,{"$f":"      SELECT(Arow&Jrtr+1&Acol&Jctr&Asep&Arow&Jrtr+1&Acol&Jctr+3)","v":true},{"$f":"      SELECT(Arow&Jrtr&Acol&Jctr&Asep&Arow&Jrtr&Acol&Jctr+3)","v":true},{"$f":"      SELECT(Arow&Jrtr&Acol&Jctr&Asep&Arow&Jrtr&Acol&Jctr+3)","v":true},{"$f":"      SELECT(Arow&Jrtr+1&Acol&Jctr&Asep&Arow&Jrtr+1&Acol&Jctr+3)","v":true},{"$f":"      IF(Ntmp4>0.5,FORMULA(100*Ntmp3/Ntmp4,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&4+Ievi+(Istd-1)*(Nevi+1)&Acol&Icol+4,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"  IF(Nall<0.5)","v":true},null,null,{"$f":"FORMULA(\"Description\",INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&2,FALSE))","v":true},{"$f":"    ALERT(\"Locus \"&Aloc&\" was not found on Sheet \"&S2dat&\"!\"&Acar&Acar&\"Make sure that all loci on the Data sheet are available and try again!\",2)","v":true},{"$f":"SET.NAME(\"Nevi\",0)","v":true},{"$f":"  FORMULA(Anew,INDIRECT(\"'\"&S0wrk&\"'!\"&\"\"&Arow&1&Acol&5,FALSE))","v":true},"! Loci",null,null,{"$f":"      BORDER(1)","v":true},{"$f":"      ALIGNMENT(7,FALSE,3,0)","v":true},{"$f":"      ALIGNMENT(7,FALSE,3,0)","v":true},{"$f":"      BORDER(1)","v":true},{"$f":"    NEXT()","v":true}]
["! Check the Date format",null,null,null,null,null,null,null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&J$1&\"> Finished.\")","v":true},{"$f":"    SET.NAME(\"Atyp\",\"Blank\")","v":false},null,null,{"$f":"SELECT(Arow&4&Acol&1&Asep&Arow&4&Acol&2)","v":true},{"$f":"    HALT()","v":true},{"$f":"SET.NAME(\"Nsus\",0)","v":true},{"$f":"END.IF()","v":true},{"$f":"SET.NAME(\"Nloc\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&4&Asep&Arow&4&Acol&256,FALSE)))","v":true},"! Format",null,{"$f":"      SELECT(Arow&Jrtr+2&Acol&Jctr&Asep&Arow&Jrtr+1+Nloc&Acol&Jctr+3)","v":true},{"$f":"      SELECT(Arow&Jrtr+1&Acol&Jctr&Asep&Arow&Jrtr+1&Acol&Jctr+3)","v":true},{"$f":"      SELECT(Arow&Jrtr+1&Acol&Jctr&Asep&Arow&Jrtr+1&Acol&Jctr+3)","v":true},{"$f":"      SELECT(Arow&Jrtr+2&Acol&Jctr&Asep&Arow&Jrtr+1+Nloc&Acol&Jctr+3)","v":true},{"$f":"    SELECT(Arow&5+(Istd-1)*(Nevi+1)&Acol&Icol&Asep&Arow&3+Istd*(Nevi+1)&Acol&Icol+Nblk-2)","v":true}]
[{"$f":"SET.NAME(\"AlngDat\",DEREF(INDIRECT(\"'\"&S0dti&\"'!\"&Arow&2&Acol&3,FALSE)))","v":true},null,null,null,null,null,null,null,null,{"$f":"RETURN()","v":true},null,null,null,{"$f":"ALIGNMENT(3,FALSE,3,0)","v":true},{"$f":"  END.IF()","v":false},{"$f":"SET.NAME(\"Nvic\",0)","v":true},null,{"$f":"FOR(\"Icol\",4,Nloc+3,1)","v":true},{"$f":"ACTIVATE(S0rp1)","v":true},null,{"$f":"      BORDER(1)","v":true},{"$f":"      BORDER(1)","v":true},{"$f":"      BORDER(1)","v":true},{"$f":"      BORDER(1)","v":true},{"$f":"    SORT(1,Arow&5+(Istd-1)*(Nevi+1)&Acol&Icol+4,2,Arow&5+(Istd-1)*(Nevi+1)&Acol&Icol+3,2,,,2)","v":true}]
[{"$f":"SET.NAME(\"Itmp0\",TEXT(NOW(),AlngDat))","v":true},null,null,null,null,null,null,null,null,null,"! Is the type actually defined?",null,null,{"$f":"BORDER(1)","v":true},{"$f":"  SET.NAME(\"Icol0\",MIN(Icol0,Itmp))","v":true},{"$f":"SET.NAME(\"Nxcl\",0)","v":true},{"$f":"RETURN()","v":true},{"$f":"  SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Icol,FALSE)))","v":true},{"$f":"DLD_ScreenUpdateOn()","v":0},null,null,{"$f":"      SELECT(Arow&Jrtr+2&Acol&Jctr&Asep&Arow&Jrtr+1+Nloc&Acol&Jctr+3)","v":true},{"$f":"      SELECT(Arow&Jrtr+2&Acol&Jctr&Asep&Arow&Jrtr+1+Nloc&Acol&Jctr+3)","v":true},null,{"$f":"  NEXT()","v":true}]
[{"$f":"IF(Itmp0=AlngDat,SET.NAME(\"Itmp0\",NA()))","v":false},null,null,null,null,null,null,null,null,null,{"$f":"  ELSE()","v":true},null,null,{"$f":"SELECT(Arow&4&Acol&4&Asep&Arow&4&Acol&3+Nloc)","v":true},{"$f":"NEXT()","v":true},{"$f":"FOR(\"Irow\",5,Nrows,1)","v":true},null,{"$f":"  FORMULA(Icol,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Icol-2&Acol&16,FALSE))","v":true},{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},null,"! Loop over loci",{"$f":"      BORDER(1)","v":true},{"$f":"      BORDER(1)","v":true},"! Loop over loci"]
[{"$f":"IF(ISERROR(Itmp0*1),SET.NAME(\"Itmp0\",NA()))","v":false},null,null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Atmp1\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4+Isam&Acol&1,FALSE)))","v":true},null,null,{"$f":"ALIGNMENT(3,FALSE,3,0)","v":true},null,null,null,{"$f":"  FORMULA(Atmp,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Icol-2&Acol&17,FALSE))","v":true},{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},null,{"$f":"      SET.NAME(\"Ntmp3\",0)","v":true},null,null,{"$f":"      SET.NAME(\"Ntmp3\",0)","v":true},"! Loop over Evidence"]
[{"$f":"IF(ISERROR(Itmp0))","v":true},null,null,null,null,null,null,null,null,null,{"$f":"    IF(LEN(Atmp1)>1.5)","v":true},null,null,{"$f":"BORDER(1)","v":true},"! Find the first column of non-blank sample id to the left of the first locus column","! Chack for assignments",null,{"$f":"NEXT()","v":true},null,null,{"$f":"      SET.NAME(\"Ntmp4\",0)","v":true},"! Loop over loci","! Loop over loci",{"$f":"      SET.NAME(\"Ntmp4\",0)","v":true},{"$f":"  FOR(\"Ievi\",1,Nevi,1)","v":true}]
[{"$f":"  FORMULA(\"Invalid!\",INDIRECT(\"'\"&S0dti&\"'!\"&Arow&2&Acol&4,FALSE))","v":true},null,null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Atmp1\",LEFT(Atmp1,2))","v":true},null,null,null,{"$f":"SET.NAME(\"Icol1\",-1)","v":true},{"$f":"  SET.NAME(\"Atmp\",LEFT(CLEAN(UPPER(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&1,FALSE))),2))","v":true},null,null,"! Update the controlpanel",null,{"$f":"      FOR(\"Icol\",Icol0,Icol1,1)","v":true},{"$f":"      SET.NAME(\"Ntmp3\",0)","v":true},{"$f":"      SET.NAME(\"Ntmp3\",0)","v":true},{"$f":"      FOR(\"Icol\",Icol0,Icol1,1)","v":true},{"$f":"    SET.NAME(\"Jctr\",4+(Ievi-1)*5)","v":true}]
[{"$f":"  dld_setcolwidth(1,4,TRUE)","v":false},null,null,null,null,null,null,null,null,null,{"$f":"      FOR(\"Irow\",2,Ntyp,1)","v":true},null,null,"! Loop over the samples",{"$f":"SET.NAME(\"Ntmp\",COUNTA(INDIRECT(\"'\"&S2dat&\"'!\"&Arow&Irow0+1&Acol&Icol0&Asep&Arow&65536&Acol&Icol0,FALSE)))","v":true},{"$f":"  IF(LEN(Atmp)<1.5)","v":true},null,{"$f":"ACTIVATE(S0wrk)","v":true},{"$f":"FORMULA(\"Complete\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&3,FALSE))","v":true},null,{"$f":"        SET.NAME(\"Atmp1\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE)))","v":true},{"$f":"      SET.NAME(\"Ntmp4\",0)","v":true},{"$f":"      SET.NAME(\"Ntmp4\",0)","v":true},{"$f":"        SET.NAME(\"Atmp1\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Irow&Acol&21,FALSE)))","v":true},null,null,{"$f":"SET.NAME(\"Nsam\",0)","v":true},{"$f":"FOR(\"Icol\",1,Icol0,1)","v":true},{"$f":"    dld_gotocell_RC(1,1,Irow,4,TRUE)","v":false},null,{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&4,FALSE))","v":true},null,{"$f":"        IF(ISERROR(Atmp1),SET.NAME(\"Atmp1\",0))","v":false},{"$f":"      FOR(\"Icol\",Icol0,Icol1,1)","v":true},{"$f":"      FOR(\"Icol\",Icol0,Icol1,1)","v":true},{"$f":"        IF(ISERROR(Atmp1),SET.NAME(\"Atmp1\",0))","v":false},"! Loop over standards"]
[{"$f":"  SELECT(Arow&2&Acol&2)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Atmp\",LEFT(Atmp,2))","v":true},null,null,{"$f":"FOR(\"Irow\",Irow0+2,Irow1,1)","v":true},{"$f":"  SET.NAME(\"Itmp\",COUNTA(INDIRECT(\"'\"&S2dat&\"'!\"&Arow&Irow0+1&Acol&Icol&Asep&Arow&65536&Acol&Icol,FALSE)))","v":true},{"$f":"    dld_msgbar(\"There must be a descriptor for this sample of at least two characters!\",TRUE)","v":false},null,null,{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"        SET.NAME(\"Atmp1\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE)))","v":true},{"$f":"        SET.NAME(\"Atmp1\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE)))","v":true},null,{"$f":"    FOR(\"Istd\",1,Nstd,1)","v":true}]
[{"$f":"  OPTIONS.VIEW(TRUE,TRUE)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"        IF(Atmp=Atmp1)","v":true},null,null,{"$f":"  SET.NAME(\"Atmp2\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow&Acol&1&Asep&Arow&Irow&Acol&Icol2-1,FALSE)))","v":true},{"$f":"  IF(Itmp>=Ntmp)","v":true},{"$f":"    ALERT(\"There must be a descriptor for this sample of at least two characters!\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":true},null,null,null,null,"! Compare Standard to Evidence",{"$f":"        IF(ISERROR(Atmp1),SET.NAME(\"Atmp1\",0))","v":false},{"$f":"        IF(ISERROR(Atmp1),SET.NAME(\"Atmp1\",0))","v":false},"! Compare Standard to other Standards",{"$f":"      SET.NAME(\"Jrtr\",3+(Istd-1)*(Nloc+5))","v":true}]
[{"$f":"  DLD_ScreenUpdateOn()","v":false},null,null,null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Atyp\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Irow&Acol&22,FALSE)))","v":true},null,null,{"$f":"  IF(Atmp2>0.5)","v":true},{"$f":"    SET.NAME(\"Icol1\",Icol)","v":true},{"$f":"    HALT()","v":true},null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&S$1&\"> Finished.\")","v":true},null,{"$f":"        SET.NAME(\"Atmp2\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&Icol,FALSE)))","v":true},null,null,{"$f":"        SET.NAME(\"Atmp2\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&Icol,FALSE)))","v":true},{"$f":"      SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr+1&Acol&2,FALSE)))","v":true}]
[{"$f":"  dld_msgbar(\"Missing a valid day, month, year format.\",TRUE)","v":false},null,null,null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Irow\",Ntyp+1)","v":true},null,null,{"$f":"    SET.NAME(\"Nsam\",Nsam+1)","v":true},{"$f":"    BREAK()","v":true},{"$f":"  END.IF()","v":false},null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&R$1&\"> Finished.\")","v":true},{"$f":"RETURN()","v":true},null,{"$f":"        IF(ISERROR(Atmp2),SET.NAME(\"Atmp2\",0))","v":false},"! Compare Standard to other Standards","! Compare Standard to other Standards",{"$f":"        IF(ISERROR(Atmp2),SET.NAME(\"Atmp2\",0))","v":false},{"$f":"      SET.NAME(\"Ntmp\",DEREF(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr+Nloc+2&Acol&2,FALSE)))","v":true}]
[{"$f":"  ALERT(\"Please format this as a valid date (day, month, year) with\"&Acar&\" Excel's standard cell format tool (Format > Cells… > Number > Date).\"&Acar&Acar&\"Then click 'Check It' to proceed.\")","v":true},null,null,null,null,null,null,null,null,null,{"$f":"        END.IF()","v":true},null,null,{"$f":"    SET.NAME(\"Atmp1\",\"'\")","v":true},{"$f":"  END.IF()","v":false},null,null,{"$f":"RETURN()","v":true},null,null,{"$f":"        IF(Atmp2<>0,FORMULA(Atmp2,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr))","v":true},{"$f":"        SET.NAME(\"Atmp2\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&Icol,FALSE)))","v":true},{"$f":"        SET.NAME(\"Atmp2\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&Icol,FALSE)))","v":true},{"$f":"        IF(Atmp2<>0,FORMULA(Atmp2,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr))","v":true},{"$f":"      SET.NAME(\"Aevi\",DEREF(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr&Acol&Jctr,FALSE)))","v":true}]
[{"$f":"  HALT()","v":true},null,null,null,null,null,null,null,null,null,{"$f":"      NEXT()","v":true},null,null,{"$f":"    FOR(\"Icol\",1,Icol2-1,1)","v":true},{"$f":"NEXT()","v":true},{"$f":"  IF(Atmp=\"BL\")","v":true},null,null,null,null,null,{"$f":"        IF(ISERROR(Atmp2),SET.NAME(\"Atmp2\",0))","v":false},{"$f":"        IF(ISERROR(Atmp2),SET.NAME(\"Atmp2\",0))","v":false},null,{"$f":"      SET.NAME(\"Ntmp1\",DEREF(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr+Nloc+2&Acol&Jctr+1,FALSE)))","v":true}]
[{"$f":"ELSE()","v":true},null,null,null,null,null,null,null,null,null,{"$f":"    END.IF()","v":true},null,null,{"$f":"      SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE)))","v":true},{"$f":"IF(OR(Icol1<0.5,Icol1>=Icol0))","v":true},{"$f":"    SET.NAME(\"Nblk\",Nblk+1)","v":true},null,null,null,null,"! Check for blank lists",{"$f":"        IF(Atmp2<>0,FORMULA(Atmp2,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr))","v":true},{"$f":"        IF(Atmp2<>0,FORMULA(Atmp2,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr))","v":true},"! Check for blank lists",{"$f":"      SET.NAME(\"Ntmp2\",DEREF(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr+Nloc+2&Acol&Jctr+2,FALSE)))","v":true}]
[{"$f":"  FORMULA(\"Valid\",INDIRECT(\"'\"&S0dti&\"'!\"&Arow&2&Acol&4,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      IF(AND(LEN(Atmp)>0.5,Atmp<>0),SET.NAME(\"Atmp1\",Atmp1&\" \"&Atmp))","v":true},{"$f":"  dld_msgbar(\"Could not locate Control identifiers!\",TRUE)","v":false},{"$f":"    SET.NAME(\"Atmp\",\"Blank\")","v":true},null,null,null,null,{"$f":"        IF(AND(Atmp1<>0,Atmp2<>0))","v":true},null,null,{"$f":"        IF(AND(Atmp1<>0,Atmp2<>0))","v":true},{"$f":"      SET.NAME(\"Ntmp3\",DEREF(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr+Nloc+3&Acol&Jctr+1,FALSE)))","v":true}]
[{"$f":"  ACTIVATE(S0dti)","v":true},null,null,null,null,null,null,null,null,null,"! Is the sample name interpretable?",null,null,{"$f":"    NEXT()","v":true},{"$f":"  ALERT(\"Could not locate a complete list of Control sample identifiers on Sheet \"&S2dat&\"!\"&Acar&Acar&\"Make sure that there is at least one column to the left of the loci that has entries for all samples and try again!\",2)","v":false},{"$f":"  ELSE.IF(Atmp=\"CO\")","v":true},null,null,null,null,{"$f":"          RUN(\"MUM_AllelesCol\",FALSE)","v":{"$error":"#N/A"}},"! Check for blank lists","! Check for blank lists",{"$f":"          RUN(\"MUM_AllelesCol\",FALSE)","v":{"$error":"#N/A"}},{"$f":"      SET.NAME(\"Ntmp4\",DEREF(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr+Nloc+3&Acol&Jctr+3,FALSE)))","v":true}]
[{"$f":"  SELECT(Arow&2&Acol&2)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Atmp1\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4+Isam&Acol&2,FALSE)))","v":true},null,null,{"$f":"    FORMULA(Atmp1,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4+Nsam&Acol&2,FALSE))","v":true},{"$f":"  HALT()","v":true},{"$f":"    SET.NAME(\"Nctl\",Nctl+1)","v":true},null,null,null,null,null,{"$f":"        IF(AND(Atmp1<>0,Atmp2<>0))","v":true},{"$f":"        IF(AND(Atmp1<>0,Atmp2<>0))","v":true},null,{"$f":"      FORMULA(Aevi,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&4+Istd+(Ievi-1)*(Nstd+1)&Acol&Icol+Nblk,FALSE))","v":true}]
[{"$f":"  FORMAT.NUMBER(AlngDat)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"    IF(AND(Atyp=\"Unassigned\",LEN(Atmp1)>2.5))","v":true},null,null,null,{"$f":"END.IF()","v":false},{"$f":"    SET.NAME(\"Atmp\",\"Control\")","v":true},null,null,null,null,{"$f":"         ACTIVATE(S0rp2)","v":true},{"$f":"          RUN(\"MUM_AllelesCol\",FALSE)","v":{"$error":"#N/A"}},{"$f":"          RUN(\"MUM_AllelesCol\",FALSE)","v":{"$error":"#N/A"}},{"$f":"         ACTIVATE(S0rp5)","v":true},{"$f":"      FORMULA(Asam,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&4+Istd+(Ievi-1)*(Nstd+1)&Acol&Icol+1+Nblk,FALSE))","v":true}]
[{"$f":"END.IF()","v":true},null,null,null,null,null,null,null,null,null,{"$f":"      FOR(\"Irow\",2,Ntyp,1)","v":true},null,null,"! Find next",null,{"$f":"  ELSE.IF(Atmp=\"DI\")","v":true},null,null,null,null,{"$f":"          SET.NAME(\"Ntmp2\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&7,FALSE)))","v":true},null,null,{"$f":"          SET.NAME(\"Ntmp2\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&7,FALSE)))","v":true},{"$f":"      IF(Ntmp>0.5,FORMULA(100*Ntmp1/Ntmp,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&4+Istd+(Ievi-1)*(Nstd+1)&Acol&Icol+2+Nblk,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Irow&Acol&21,FALSE)))","v":true},null,null,{"$f":"    FOR(\"Irow2\",Irow,Irow1,1)","v":true},null,{"$f":"    SET.NAME(\"Ndis\",Ndis+1)","v":true},null,null,null,null,{"$f":"          SET.NAME(\"Ntmp1\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&5,FALSE)))","v":true},{"$f":"         ACTIVATE(S0rp3)","v":true},{"$f":"         ACTIVATE(S0rp4)","v":true},{"$f":"          SET.NAME(\"Ntmp1\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&5,FALSE)))","v":true},{"$f":"      IF(Ntmp1+Ntmp2>0.5,FORMULA(100*Ntmp1/(Ntmp1+Ntmp2),INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&4+Istd+(Ievi-1)*(Nstd+1)&Acol&Icol+3+Nblk,FALSE)))","v":true}]
["! Check the Time format",null,null,null,null,null,null,null,null,null,{"$f":"        IF(NOT(ISERROR(FIND(Atmp,Atmp1))))","v":true},null,null,{"$f":"      SET.NAME(\"Ntmp\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow2+1&Acol&1&Asep&Arow&Irow2+1&Acol&Icol2-1,FALSE)))","v":true},"! Loop over all the rows",{"$f":"    SET.NAME(\"Atmp\",\"Disabled\")","v":true},null,null,null,null,{"$f":"          SET.NAME(\"Ntmp1\",Ntmp1-Ntmp2)","v":true},{"$f":"          SET.NAME(\"Ntmp2\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&7,FALSE)))","v":true},{"$f":"          SET.NAME(\"Ntmp2\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&7,FALSE)))","v":true},{"$f":"          SET.NAME(\"Ntmp1\",Ntmp1-Ntmp2)","v":true},{"$f":"      IF(Ntmp4>0.5,FORMULA(100*Ntmp3/Ntmp4,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&4+Istd+(Ievi-1)*(Nstd+1)&Acol&Icol+4+Nblk,FALSE)))","v":true}]
[{"$f":"SET.NAME(\"AlngTim\",DEREF(INDIRECT(\"'\"&S0dti&\"'!\"&Arow&3&Acol&3,FALSE)))","v":true},null,null,null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Atyp\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Irow&Acol&22,FALSE)))","v":true},null,null,{"$f":"      IF(Ntmp>0.5,BREAK())","v":false},{"$f":"SET.NAME(\"Nsam\",0)","v":true},{"$f":"  ELSE.IF(OR(Atmp=\"EV\",Atmp=\"MI\"))","v":true},null,null,null,null,{"$f":"          FORMULA(Ntmp1,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr+1)","v":true},{"$f":"          SET.NAME(\"Ntmp1\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&5,FALSE)))","v":true},{"$f":"          SET.NAME(\"Ntmp1\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&5,FALSE)))","v":true},{"$f":"          FORMULA(Ntmp1,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr+1)","v":true},{"$f":"    NEXT()","v":true}]
[{"$f":"SET.NAME(\"Itmp0\",TEXT(NOW(),AlngTim))","v":true},null,null,null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Irow\",Ntyp+1)","v":true},null,null,{"$f":"    NEXT()","v":true},{"$f":"FOR(\"Irow\",Irow0+1,Nnew,1)","v":true},{"$f":"    SET.NAME(\"Nevi\",Nevi+1)","v":true},null,null,null,null,{"$f":"          FORMULA(Ntmp2,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr+2)","v":true},{"$f":"          SET.NAME(\"Ntmp1\",Ntmp1-Ntmp2)","v":true},{"$f":"          SET.NAME(\"Ntmp1\",Ntmp1-Ntmp2)","v":true},{"$f":"          FORMULA(Ntmp2,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr+2)","v":true},{"$f":"    SELECT(Arow&5+(Ievi-1)*(Nstd+1)&Acol&Icol+Nblk&Asep&Arow&3+Ievi*(Nstd+1)&Acol&Icol+2*Nblk-2)","v":true}]
[{"$f":"IF(Itmp0=AlngTim,SET.NAME(\"Itmp0\",NA()))","v":false},null,null,null,null,null,null,null,null,null,{"$f":"        END.IF()","v":true},null,null,null,{"$f":"  SET.NAME(\"Atmp2\",COUNTA(INDIRECT(\"'\"&S2dat&\"'!\"&Arow&Irow,FALSE)))","v":true},{"$f":"    SET.NAME(\"Atmp\",\"Evidence\")","v":true},null,null,null,null,{"$f":"          FORMULA(Atmp2,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr+3)","v":true},{"$f":"          FORMULA(Ntmp1,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr+1)","v":true},{"$f":"          FORMULA(Ntmp1,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr+1)","v":true},{"$f":"          FORMULA(Atmp2,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr+3)","v":true},{"$f":"    SORT(1,Arow&5+(Istd-1)*(Nstd+1)&Acol&Icol+Nblk+4,2,Arow&5+(Istd-1)*(Nstd+1)&Acol&Icol+Nblk+3,2,,,2)","v":true}]
[{"$f":"IF(ISERROR(Itmp0*1),SET.NAME(\"Itmp0\",NA()))","v":false},null,null,null,null,null,null,null,null,null,{"$f":"      NEXT()","v":true},null,null,"! Get alleles",{"$f":"  IF(Atmp2>Nloc)","v":true},{"$f":"  ELSE.IF(Atmp=\"SU\")","v":true},null,null,null,null,null,{"$f":"          FORMULA(Ntmp2,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr+2)","v":true},{"$f":"          FORMULA(Ntmp2,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr+2)","v":true},null,{"$f":"  NEXT()","v":true}]
[{"$f":"IF(ISERROR(Itmp0))","v":true},null,null,null,null,null,null,null,null,null,{"$f":"    END.IF()","v":true},null,null,{"$f":"    FOR(\"Iloc\",1,Nloc,1)","v":true},null,{"$f":"    SET.NAME(\"Nsus\",Nsus+1)","v":true},null,null,null,null,{"$f":"          SET.NAME(\"Ntmp3\",Ntmp3+1)","v":true},{"$f":"          FORMULA(Atmp2,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr+3)","v":true},{"$f":"          FORMULA(Atmp2,Arow&Jrtr+Icol-Icol0+2&Acol&Jctr+3)","v":true},{"$f":"          SET.NAME(\"Ntmp3\",Ntmp3+1)","v":true},{"$f":"END.IF()","v":true}]
[{"$f":"  FORMULA(\"Invalid!\",INDIRECT(\"'\"&S0dti&\"'!\"&Arow&3&Acol&4,FALSE))","v":true},null,null,null,null,null,null,null,null,null,{"$f":"  END.IF()","v":true},null,null,{"$f":"      SET.NAME(\"Icol\",Icol2+(Iloc-1)*2)","v":true},"! Make the Control name",{"$f":"    SET.NAME(\"Atmp\",\"Suspect\")","v":true},null,null,null,null,{"$f":"          IF(AND(Ntmp1>0.5,Ntmp2<0.5),SET.NAME(\"Ntmp4\",Ntmp4+1))","v":false},null,null,{"$f":"          IF(AND(Ntmp1>0.5,Ntmp2<0.5),SET.NAME(\"Ntmp4\",Ntmp4+1))","v":false}]
[{"$f":"  dld_setcolwidth(1,4,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Atmp1\",\"'\")","v":true},{"$f":"    SET.NAME(\"Atmp1\",-1)","v":true},{"$f":"  ELSE.IF(Atmp=\"VI\")","v":true},null,null,null,null,{"$f":"        END.IF()","v":true},{"$f":"          SET.NAME(\"Ntmp3\",Ntmp3+1)","v":true},{"$f":"          SET.NAME(\"Ntmp3\",Ntmp3+1)","v":true},{"$f":"        END.IF()","v":true},"! Do the Standards x Standards"]
[null,null,null,null,null,null,null,null,null,null,"! Store the type",null,null,{"$f":"      SET.NAME(\"Nall\",0)","v":true},{"$f":"    FOR(\"Icol\",Icol1,Icol0-1,1)","v":true},{"$f":"    SET.NAME(\"Nvic\",Nvic+1)","v":true},null,null,null,null,{"$f":"      NEXT()","v":true},{"$f":"          IF(AND(Ntmp1>0.5,Ntmp2<0.5),SET.NAME(\"Ntmp4\",Ntmp4+1))","v":true},{"$f":"          IF(AND(Ntmp1>0.5,Ntmp2<0.5),SET.NAME(\"Ntmp4\",Ntmp4+1))","v":true},{"$f":"      NEXT()","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&Y$1&\"> Standards x Standards\")","v":true}]
[{"$f":"  SELECT(Arow&3&Acol&2)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"  FORMULA(Atyp,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4+Isam&Acol&1,FALSE))","v":true},null,null,{"$f":"      FOR(\"Jrow\",Irow,Irow2,1)","v":true},{"$f":"      SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S2dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE)))","v":true},{"$f":"    SET.NAME(\"Atmp\",\"Victim\")","v":true},null,null,null,null,null,{"$f":"        END.IF()","v":true},{"$f":"        END.IF()","v":true},null,{"$f":"SET.NAME(\"Icol\",1+2*Nblk)","v":true}]
[{"$f":"  OPTIONS.VIEW(TRUE,TRUE)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"NEXT()","v":true},null,null,{"$f":"        IF(NOT(ISBLANK(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Jrow&Acol&Icol,FALSE))))","v":true},{"$f":"      IF(AND(LEN(Atmp)>0.5,Atmp<>0),SET.NAME(\"Atmp1\",IF(Atmp1=-1,Atmp,Atmp1&\" \"&Atmp)))","v":true},{"$f":"  ELSE.IF(Atmp=\"XC\")","v":true},null,null,null,null,"! Sum Alleles",{"$f":"      NEXT()","v":true},{"$f":"      NEXT()","v":true},"! Sum things",{"$f":"IF(Nstd<1.5)","v":true}]
[{"$f":"  DLD_ScreenUpdateOn()","v":false},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Atmp\",UPPER(CLEAN(TRIM(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Jrow&Acol&Icol,FALSE)))))","v":true},{"$f":"    NEXT()","v":true},{"$f":"    SET.NAME(\"Nxcl\",Nxcl+1)","v":true},null,null,null,null,{"$f":"      SET.NAME(\"Ntmp1\",SUM(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr+2&Acol&Jctr+1&Asep&Arow&Jrtr+1+Nloc&Acol&Jctr+1,FALSE)))","v":true},null,null,{"$f":"      SET.NAME(\"Ntmp1\",SUM(INDIRECT(\"'\"&S0rp5&\"'!\"&Arow&Jrtr+2&Acol&Jctr+1&Asep&Arow&Jrtr+1+Nloc&Acol&Jctr+1,FALSE)))","v":true},{"$f":"  FORMULA(IF(Nstd<0.5,\"Unavailable\",\"Unneeded\"),Arow&5&Acol&Icol)","v":true}]
[{"$f":"  dld_msgbar(\"Missing a valid hours, minutes, seconds format.\",TRUE)","v":false},null,null,null,null,null,null,null,null,null,"! Format",null,null,{"$f":"          SET.NAME(\"Nall\",Nall+1)","v":true},null,{"$f":"    SET.NAME(\"Atmp\",\"Xclude\")","v":true},null,null,null,null,{"$f":"      SET.NAME(\"Ntmp2\",SUM(INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Jrtr+2&Acol&Jctr+2&Asep&Arow&Jrtr+1+Nloc&Acol&Jctr+2,FALSE)))","v":true},"! Sum things","! Sum things",{"$f":"      SET.NAME(\"Ntmp2\",SUM(INDIRECT(\"'\"&S0rp5&\"'!\"&Arow&Jrtr+2&Acol&Jctr+2&Asep&Arow&Jrtr+1+Nloc&Acol&Jctr+2,FALSE)))","v":true},{"$f":"  SELECT(Arow&5&Acol&Icol&Asep&Arow&5&Acol&Icol+Nblk-2)","v":true}]
[{"$f":"  ALERT(\"Please format this as a valid time (hours, minutes, seconds) with\"&Acar&\" Excel's standard cell format tool (Format > Cells… > Number > Time).\"&Acar&Acar&\"Then click 'Check It' to proceed.\")","v":true},null,null,null,null,null,null,null,null,null,{"$f":"ACTIVATE(S0dat)","v":true},null,null,{"$f":"          SET.NAME(\"Atmp1\",Atmp1&IF(Nall>1.5,\",\",\"\")&Atmp)","v":true},"! Check if this is already in the Data",{"$f":"  ELSE()","v":true},null,null,null,null,{"$f":"      FORMULA(Ntmp1,Arow&Jrtr+Icol1-Icol0+3&Acol&Jctr+1)","v":true},{"$f":"      SET.NAME(\"Ntmp1\",SUM(INDIRECT(\"'\"&S0rp3&\"'!\"&Arow&Jrtr+2&Acol&Jctr+1&Asep&Arow&Jrtr+1+Nloc&Acol&Jctr+1,FALSE)))","v":true},{"$f":"      SET.NAME(\"Ntmp1\",SUM(INDIRECT(\"'\"&S0rp4&\"'!\"&Arow&Jrtr+2&Acol&Jctr+1&Asep&Arow&Jrtr+1+Nloc&Acol&Jctr+1,FALSE)))","v":true},{"$f":"      FORMULA(Ntmp1,Arow&Jrtr+Icol1-Icol0+3&Acol&Jctr+1)","v":true},{"$f":"  ALIGNMENT(7,FALSE,3,0)","v":true}]
[{"$f":"  HALT()","v":true},null,null,null,null,null,null,null,null,null,{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},null,null,{"$f":"        END.IF()","v":true},{"$f":"    SET.NAME(\"Itmp\",MATCH(Atmp1,INDIRECT(\"'\"&S0dat&\"'!\"&Acol&2,FALSE),0))","v":true},{"$f":"    dld_gotocell_RC(1,1,Irow,1,TRUE)","v":0},null,null,null,null,{"$f":"      FORMULA(Ntmp2,Arow&Jrtr+Icol1-Icol0+3&Acol&Jctr+2)","v":true},{"$f":"      SET.NAME(\"Ntmp2\",SUM(INDIRECT(\"'\"&S0rp3&\"'!\"&Arow&Jrtr+2&Acol&Jctr+2&Asep&Arow&Jrtr+1+Nloc&Acol&Jctr+2,FALSE)))","v":true},{"$f":"      SET.NAME(\"Ntmp2\",SUM(INDIRECT(\"'\"&S0rp4&\"'!\"&Arow&Jrtr+2&Acol&Jctr+2&Asep&Arow&Jrtr+1+Nloc&Acol&Jctr+2,FALSE)))","v":true},{"$f":"      FORMULA(Ntmp2,Arow&Jrtr+Icol1-Icol0+3&Acol&Jctr+2)","v":true},{"$f":"ELSE()","v":true}]
[{"$f":"ELSE()","v":true},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"        IF(NOT(ISBLANK(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Jrow&Acol&Icol+1,FALSE))))","v":true},{"$f":"    IF(ISERROR(Itmp))","v":true},{"$f":"    dld_msgbar(S0dat&\"!Row\"&Irow&\"Col1 is expected to specify the sample Type.\",TRUE)","v":0},null,null,null,null,null,{"$f":"      FORMULA(Ntmp1,Arow&Jrtr+Icol1-Icol0+3&Acol&Jctr+1)","v":true},{"$f":"      FORMULA(Ntmp1,Arow&Jrtr+Icol1-Icol0+3&Acol&Jctr+1)","v":true}]
[{"$f":"  ACTIVATE(S0dti)","v":true},null,null,null,null,null,null,null,null,null,"! Give instructions",null,null,{"$f":"          SET.NAME(\"Atmp\",UPPER(CLEAN(TRIM(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Jrow&Acol&Icol+1,FALSE)))))","v":true},null,{"$f":"    ALERT(S0dat&\"!Row\"&Irow&\"Col1 is expected to specify the sample Type as: BLANK, CONTROL, DISABLE, EVIDENCE, SUSPECT, VICTIM, or XCLUDE.\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":true},null,null,null,null,"! Ins and Outs",{"$f":"      FORMULA(Ntmp2,Arow&Jrtr+Icol1-Icol0+3&Acol&Jctr+2)","v":true},{"$f":"      FORMULA(Ntmp2,Arow&Jrtr+Icol1-Icol0+3&Acol&Jctr+2)","v":true},"! Ins and Outs","! Loop over standards"]
[{"$f":"  FORMULA(\"Valid\",INDIRECT(\"'\"&S0dti&\"'!\"&Arow&3&Acol&4,FALSE))","v":true},null,null,null,null,null,null,null,null,null,{"$f":"dld_msgbar(\"Data from \"&S1dat&\" has been loaded.\",TRUE)","v":0},null,null,{"$f":"          SET.NAME(\"Nall\",Nall+1)","v":true},"! Add the Controls to Data",{"$f":"    HALT()","v":true},null,null,null,null,{"$f":"      FORMULA(Ntmp4,Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+1)","v":true},null,null,{"$f":"      FORMULA(Ntmp4,Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+1)","v":true},{"$f":"  FOR(\"Istd\",1,Nstd,1)","v":true}]
[{"$f":"  SELECT(Arow&3&Acol&2)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"ALERT(\"Data from \"&S1dat&\" has been loaded.\"&Acar&\"This data has NOT been validated!\"&Acar&Acar&\"You should check the Types, sample labels, and all of the allele lists before proceeding.  Shortcut: <Ctrl-A>\",2)","v":true},null,null,{"$f":"          SET.NAME(\"Atmp1\",Atmp1&IF(Nall>1.5,\",\",\"\")&Atmp)","v":true},{"$f":"      SET.NAME(\"Nsam\",Nsam+1)","v":true},{"$f":"  END.IF()","v":false},null,null,null,null,{"$f":"      FORMULA(Ntmp3-Ntmp4,Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+2)","v":true},"! Ins and Outs","! Ins and Outs",{"$f":"      FORMULA(Ntmp3-Ntmp4,Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+2)","v":true},{"$f":"    SET.NAME(\"Jrtr\",3+(Istd-1)*(Nloc+5))","v":true}]
[{"$f":"  FORMAT.NUMBER(AlngTim)","v":true},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"        END.IF()","v":true},{"$f":"      FORMULA(\"Control\",INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Nrow+2+Nsam&Acol&1,FALSE))","v":true},{"$f":"  FORMULA(Atmp,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&1,FALSE))","v":true},null,null,null,null,{"$f":"      FORMULA(Ntmp3,Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+3)","v":true},{"$f":"      FORMULA(Ntmp4,Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+1)","v":true},{"$f":"      FORMULA(Ntmp4,Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+1)","v":true},{"$f":"      FORMULA(Ntmp3,Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+3)","v":true},{"$f":"    SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0rp3&\"'!\"&Arow&Jrtr+1&Acol&2,FALSE)))","v":true}]
[{"$f":"END.IF()","v":true},null,null,null,null,null,null,null,null,null,"! Return to Control",null,null,{"$f":"      NEXT()","v":true},{"$f":"      FORMULA(Atmp1,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Nrow+2+Nsam&Acol&2,FALSE))","v":true},{"$f":"NEXT()","v":true},null,null,null,null,{"$f":"      SELECT(Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+1)","v":true},{"$f":"      FORMULA(Ntmp3-Ntmp4,Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+2)","v":true},{"$f":"      FORMULA(Ntmp3-Ntmp4,Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+2)","v":true},{"$f":"      SELECT(Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+1)","v":true},{"$f":"    SET.NAME(\"Ntmp\",DEREF(INDIRECT(\"'\"&S0rp3&\"'!\"&Arow&Jrtr+Nloc+2&Acol&2,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"FORMULA(\"Data Loaded\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&3,FALSE))","v":true},null,null,{"$f":"      IF(Nall>0.5,FORMULA(Atmp1,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4+Nsam&Acol&Iloc+3,FALSE)))","v":true},null,null,null,null,null,null,{"$f":"      FONT.PROPERTIES(,\"Bold\",,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,4)","v":true},{"$f":"      FORMULA(Ntmp3,Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+3)","v":true},{"$f":"      FORMULA(Ntmp3,Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+3)","v":true},{"$f":"      FONT.PROPERTIES(,\"Bold\",,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,4)","v":true}]
["! Check the DateTime format",null,null,null,null,null,null,null,null,null,{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&4,FALSE))","v":true},null,null,{"$f":"    NEXT()","v":true},"! Get all the alleles","! Check that the required types are present",null,null,null,null,{"$f":"      SELECT(Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+2)","v":true},{"$f":"      SELECT(Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+1)","v":true},{"$f":"      SELECT(Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+1)","v":true},{"$f":"      SELECT(Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+2)","v":true},"! Loop over other Standards"]
[{"$f":"SET.NAME(\"AlngDatTim\",AlngDat&\" \"&AlngTim)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"RUN(MUM_DisSum,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"  END.IF()","v":true},{"$f":"      FOR(\"Iloc\",1,Nloc,1)","v":true},{"$f":"IF(Nevi+Nsus+Nvic<1.5)","v":true},null,null,null,null,{"$f":"      FONT.PROPERTIES(,\"Bold\",,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,3)","v":true},{"$f":"      FONT.PROPERTIES(,\"Bold\",,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,4)","v":true},{"$f":"      FONT.PROPERTIES(,\"Bold\",,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,4)","v":true},{"$f":"      FONT.PROPERTIES(,\"Bold\",,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,3)","v":true},{"$f":"    FOR(\"Ievi\",1,Nstd,1)","v":true}]
[{"$f":"FORMULA(AlngDatTim,INDIRECT(\"'\"&S0dti&\"'!\"&Arow&4&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,null,{"$f":"FORMULA.GOTO(Arow&14&Acol&1,FALSE)","v":true},null,null,{"$f":"NEXT()","v":true},{"$f":"        SET.NAME(\"Aloc\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&3+Iloc,FALSE)))","v":true},{"$f":"  dld_gotocell_RC(1,1,5,4,TRUE)","v":0},null,null,null,null,{"$f":"      SELECT(Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+3)","v":true},{"$f":"      SELECT(Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+2)","v":true},{"$f":"      SELECT(Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+2)","v":true},{"$f":"      SELECT(Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+3)","v":true},{"$f":"      SET.NAME(\"Jctr\",4+(Ievi-1)*5)","v":true}]
[{"$f":"SET.NAME(\"Itmp0\",TEXT(NOW(),AlngDatTim))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Icol\",MATCH(Aloc,INDIRECT(\"'\"&S2dat&\"'!\"&Arow&Irow0,FALSE),0))","v":true},{"$f":"  dld_msgbar(\"There must be at least two data rows on sheet: \"&S0dat&\".\",TRUE)","v":0},null,null,null,null,{"$f":"      FONT.PROPERTIES(,\"Bold\",,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,1)","v":true},{"$f":"      FONT.PROPERTIES(,\"Bold\",,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,3)","v":true},{"$f":"      FONT.PROPERTIES(,\"Bold\",,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,3)","v":true},{"$f":"      FONT.PROPERTIES(,\"Bold\",,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,1)","v":true},{"$f":"      SET.NAME(\"Aevi\",DEREF(INDIRECT(\"'\"&S0rp3&\"'!\"&Arow&Jrtr&Acol&Jctr,FALSE)))","v":true}]
[{"$f":"IF(Itmp0=AlngDatTim,SET.NAME(\"Itmp0\",NA()))","v":false},null,null,null,null,null,null,null,null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&K$1&\"> Finished.\")","v":true},null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&N$1&\"> Finished.\")","v":true},{"$f":"        SET.NAME(\"Atmp\",UPPER(CLEAN(TRIM(INDIRECT(\"'\"&S2dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE)))))","v":true},{"$f":"  ALERT(\"There must be at least two Evidence, Suspect, and/or Victim rows on sheet: \"&S0dat&\".\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":true},null,null,null,null,{"$f":"    NEXT()","v":true},{"$f":"      SELECT(Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+3)","v":true},{"$f":"      SELECT(Arow&Jrtr+Icol1-Icol0+4&Acol&Jctr+3)","v":true},{"$f":"    NEXT()","v":true},{"$f":"      SET.NAME(\"Ntmp1\",DEREF(INDIRECT(\"'\"&S0rp3&\"'!\"&Arow&Jrtr+Nloc+2&Acol&Jctr+1,FALSE)))","v":true}]
[{"$f":"IF(ISERROR(Itmp0*1),SET.NAME(\"Itmp0\",NA()))","v":false},null,null,null,null,null,null,null,null,null,{"$f":"RETURN()","v":true},null,null,{"$f":"RETURN()","v":true},{"$f":"        IF(ISERROR(Atmp),SET.NAME(\"Atmp\",0))","v":false},{"$f":"  HALT()","v":true},null,null,null,null,{"$f":"  NEXT()","v":true},{"$f":"      FONT.PROPERTIES(,\"Bold\",,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,1)","v":true},{"$f":"      FONT.PROPERTIES(,\"Bold\",,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,1)","v":true},{"$f":"  NEXT()","v":true},{"$f":"      SET.NAME(\"Ntmp2\",DEREF(INDIRECT(\"'\"&S0rp3&\"'!\"&Arow&Jrtr+Nloc+2&Acol&Jctr+2,FALSE)))","v":true}]
[{"$f":"IF(ISERROR(Itmp0))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"        IF(OR(Atmp=\"INC\",Atmp=\"NA\",Atmp=\"NEG\",Atmp=\"-\"),SET.NAME(\"Atmp\",0))","v":false},{"$f":"END.IF()","v":false},null,null,null,null,{"$f":"  FORMULA(\"Complete\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&3,FALSE))","v":true},{"$f":"    NEXT()","v":true},{"$f":"    NEXT()","v":true},{"$f":"  FORMULA(\"Complete\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&3,FALSE))","v":true},{"$f":"      SET.NAME(\"Ntmp3\",DEREF(INDIRECT(\"'\"&S0rp3&\"'!\"&Arow&Jrtr+Nloc+3&Acol&Jctr+1,FALSE)))","v":true}]
[{"$f":"  FORMULA(\"Invalid!\",INDIRECT(\"'\"&S0dti&\"'!\"&Arow&4&Acol&4,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"        IF(NOT(Atmp=0),FORMULA(Atmp,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Nrow+2+Nsam&Acol&Iloc+3,FALSE)))","v":true},null,null,null,null,null,{"$f":"END.IF()","v":true},{"$f":"  NEXT()","v":true},{"$f":"  NEXT()","v":true},{"$f":"END.IF()","v":true},{"$f":"      SET.NAME(\"Ntmp4\",DEREF(INDIRECT(\"'\"&S0rp3&\"'!\"&Arow&Jrtr+Nloc+3&Acol&Jctr+3,FALSE)))","v":true}]
[{"$f":"  dld_setcolwidth(1,2,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      NEXT()","v":true},"! Get the number of loci",null,null,null,null,null,{"$f":"  FORMULA(\"Complete\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&3,FALSE))","v":true},{"$f":"  FORMULA(\"Complete\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&3,FALSE))","v":true},null,{"$f":"      SET.NAME(\"Irow\",4+Ievi+(Istd-1)*Nstd)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    END.IF()","v":true},{"$f":"SET.NAME(\"Nloc\",0)","v":true},null,null,null,null,"! Final Format",{"$f":"END.IF()","v":true},{"$f":"END.IF()","v":true},"! Final Format",{"$f":"      FORMULA(Asam,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow&Acol&Icol,FALSE))","v":true}]
[{"$f":"  SELECT(Arow&4&Acol&1)","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  END.IF()","v":true},{"$f":"FOR(\"Icol\",4,Ncols,1)","v":true},null,null,null,null,{"$f":"ACTIVATE(S0rp2)","v":true},null,null,{"$f":"ACTIVATE(S0rp5)","v":true},{"$f":"      FORMULA(Aevi,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow&Acol&Icol+1,FALSE))","v":true}]
[{"$f":"  OPTIONS.VIEW(TRUE,TRUE)","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NEXT()","v":true},{"$f":"  SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Icol,FALSE)))","v":true},null,null,null,null,{"$f":"DLD_ScreenUpdateOn()","v":0},"! Final Format","! Final Format",{"$f":"DLD_ScreenUpdateOn()","v":0},{"$f":"      IF(Ntmp>0.5,FORMULA(100*Ntmp1/Ntmp,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow&Acol&Icol+2,FALSE)))","v":true}]
[{"$f":"  DLD_ScreenUpdateOn()","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  IF(LEN(Atmp)>2.5)","v":true},null,null,null,null,{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},{"$f":"ACTIVATE(S0rp3)","v":true},{"$f":"ACTIVATE(S0rp4)","v":true},{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},{"$f":"      IF(Ntmp1+Ntmp2>0.5,FORMULA(100*Ntmp1/(Ntmp1+Ntmp2),INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow&Acol&Icol+3,FALSE)))","v":true}]
[{"$f":"  dld_msgbar(\"Date-Time format is not valid.\",TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,"! Close the old file",{"$f":"    IF(COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&5&Acol&Icol&Asep&Arow&Nrows&Acol&Icol,FALSE))<0.5)","v":true},null,null,null,null,{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},{"$f":"DLD_ScreenUpdateOn()","v":0},{"$f":"DLD_ScreenUpdateOn()","v":0},{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},{"$f":"      IF(Ntmp4>0.5,FORMULA(100*Ntmp3/Ntmp4,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow&Acol&Icol+4,FALSE)))","v":true}]
[{"$f":"  ALERT(\"While the Date and Time formats are ok, their combination is NOT ok.\"&Acar&\"Try reformatting the Date and/or the Time so that the combination of the two is valid using \"&Acar&\"Excel's Format > Cells… > Number > Custom tool.  Good Luck!\"&Acar&Acar&\"Cllick 'Check It' to proceed.\")","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ACTIVATE(S2dat)","v":true},{"$f":"      dld_selectrange(5,Icol,Nrows,Icol,TRUE)","v":false},null,null,null,null,null,{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},null,{"$f":"    NEXT()","v":true}]
[{"$f":"  HALT()","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CLOSE(FALSE)","v":true},{"$f":"      dld_msgbar(\"There are no alleles specified in any sample at this locus.\",TRUE)","v":false},null,null,null,null,"! Update the controlpanel",{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},"! Update the controlpanel",{"$f":"    SET.NAME(\"Irow\",4+Istd+(Istd-1)*Nstd)","v":true}]
[{"$f":"ELSE()","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      ALERT(\"There are no alleles specified in any sample at this locus.\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":false},null,null,null,null,{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&4,FALSE))","v":true},null,null,{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&4,FALSE))","v":true},{"$f":"    dld_clearrange(Irow,Icol,Irow,Icol+Nblk-2,FALSE)","v":0}]
[{"$f":"  ACTIVATE(S0dti)","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,"! Format",{"$f":"      HALT()","v":true},null,null,null,null,{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},"! Update the controlpanel","! Update the controlpanel",{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},{"$f":"    SELECT(Arow&5+(Istd-1)*Nstd&Acol&Icol&Asep&Arow&4+Istd*Nstd&Acol&Icol+Nblk-2)","v":true}]
[{"$f":"  FORMULA(\"Valid\",INDIRECT(\"'\"&S0dti&\"'!\"&Arow&4&Acol&4,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ACTIVATE(S0dat)","v":true},{"$f":"    END.IF()","v":true},null,null,null,null,null,{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&4,FALSE))","v":true},{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&4,FALSE))","v":true},null,{"$f":"    SORT(1,Arow&5+(Istd-1)*Nstd&Acol&Icol+4,2,Arow&5+(Istd-1)*Nstd&Acol&Icol+3,2,,,2)","v":true}]
[{"$f":"  SELECT(Arow&4&Acol&2)","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0},{"$f":"    SET.NAME(\"Nloc\",Nloc+1)","v":true},null,null,null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&U$1&\"> Finished.\")","v":true},{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&X$1&\"> Finished.\")","v":true},{"$f":"  NEXT()","v":true}]
[{"$f":"  FORMAT.NUMBER(AlngDatTim)","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  ELSE()","v":true},null,null,null,null,{"$f":"RETURN()","v":true},null,null,{"$f":"RETURN()","v":true},{"$f":"END.IF()","v":true}]
[{"$f":"END.IF()","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FORMULA.GOTO(Arow&1&Acol&1)","v":true},{"$f":"    IF(COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Icol&Asep&Arow&4&Acol&Ncols,FALSE))>0.5)","v":true},null,null,null,null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&V$1&\"> Finished.\")","v":true},{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&W$1&\"> Finished.\")","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      dld_selectcols(Icol,Icol,TRUE)","v":false},null,null,null,null,null,{"$f":"RETURN()","v":true},{"$f":"RETURN()","v":true},null,"! Do the Evidence x Evidence"]
["! Hide this worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,"! Give instructions",{"$f":"      dld_msgbar(S0dat&\"!Row4Col\"&Icol&\" is expected to be a locus name of at least 3 characters.\",TRUE)","v":false},null,null,null,null,null,null,null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&Y$1&\"> Evidence x Evidence\")","v":true}]
[{"$f":"ACTIVATE(S0dti)","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"dld_msgbar(Nsam&\" new Control sample from \"&S2dat&\" has been loaded.\",TRUE)","v":0},{"$f":"      ALERT(S0dat&\"!Row4Col\"&Icol&\" is expected to be a locus name of at least 3 characters.\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":false},null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Icol\",1+3*Nblk)","v":true}]
[{"$f":"WORKBOOK.HIDE()","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ALERT(Nsam&\" new Control sample from \"&S2dat&\" has been loaded.\"&Acar&\"This data has NOT been validated!\"&Acar&Acar&\"You should check the Types, sample labels, and all of the allele lists before proceeding.  Shortcut: <Ctrl-A>\",2)","v":true},{"$f":"      HALT()","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(Nevi<1.5)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    END.IF()","v":false},null,null,null,null,null,null,null,null,{"$f":"  FORMULA(IF(Nevi<0.5,\"Unavailable\",\"Unneeded\"),Arow&5&Acol&Icol)","v":true}]
["! Record system stuff",null,null,null,null,null,null,null,null,null,null,null,null,null,"! Return to Control",{"$f":"  END.IF()","v":true},null,null,null,null,null,null,null,null,{"$f":"  SELECT(Arow&5&Acol&Icol&Asep&Arow&5&Acol&Icol+Nblk-1)","v":true}]
[{"$f":"FORMULA(\"AlngDat\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&17&Acol&2,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FORMULA(\"Control Loaded\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&3,FALSE))","v":true},{"$f":"NEXT()","v":true},null,null,null,null,null,null,null,null,{"$f":"  ALIGNMENT(7,FALSE,3,0)","v":true}]
[{"$f":"FORMULA(\"AlngTim\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&18&Acol&2,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&4,FALSE))","v":true},{"$f":"IF(Nloc<0.5)","v":true},null,null,null,null,null,null,null,null,{"$f":"ELSE()","v":true}]
[{"$f":"FORMULA(\"AlngDatTim\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&19&Acol&2,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RUN(MUM_DisSum,FALSE)","v":{"$error":"#N/A"}},{"$f":"  dld_gotocell_RC(1,1,4,4,TRUE)","v":false}]
[{"$f":"FORMULA(\"Acol\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&20&Acol&2,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FORMULA.GOTO(Arow&17&Acol&1,FALSE)","v":true},{"$f":"  dld_msgbar(\"At least one Locus must be specified!\",TRUE)","v":false},null,null,null,null,null,null,null,null,"! Loop over Evidence"]
[{"$f":"FORMULA(\"Adcp\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&21&Acol&2,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  ALERT(\"At least one Locus must be specified!\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":false},null,null,null,null,null,null,null,null,{"$f":"  FOR(\"Istd\",1,Nevi,1)","v":true}]
[{"$f":"FORMULA(\"Agnl\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&22&Acol&2,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&O$1&\"> Finished.\")","v":true},{"$f":"  HALT()","v":true},null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Jrtr\",3+(Istd-1)*(Nloc+5))","v":true}]
[{"$f":"FORMULA(\"Alsp\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&23&Acol&2,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RETURN()","v":true},{"$f":"END.IF()","v":false},null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0rp4&\"'!\"&Arow&Jrtr+1&Acol&2,FALSE)))","v":true}]
[{"$f":"FORMULA(\"Arow\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&24&Acol&2,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Ntmp\",DEREF(INDIRECT(\"'\"&S0rp4&\"'!\"&Arow&Jrtr+Nloc+2&Acol&2,FALSE)))","v":true}]
[{"$f":"FORMULA(AlngDat,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&17&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! Get the number of loci"]
[{"$f":"FORMULA(AlngTim,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&18&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Nall\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&5&Acol&4&Asep&Arow&Nrows&Acol&Ncols,FALSE)))","v":true},null,null,null,null,null,null,null,null,"! Loop over other Evidence"]
[{"$f":"FORMULA(AlngDatTim,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&19&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Nall<Nloc*(Nvic+Nsus+Nevi)/4)","v":true},null,null,null,null,null,null,null,null,{"$f":"    FOR(\"Ievi\",1,Nevi,1)","v":true}]
[{"$f":"FORMULA(Acol,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&20&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  dld_gotocell_RC(1,1,5,4,TRUE)","v":false},null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Jctr\",4+(Ievi-1)*5)","v":true}]
[{"$f":"FORMULA(Adcp,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&21&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  dld_msgbar(\"At least 25% of the data must have allele lists!\",TRUE)","v":false},null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Aevi\",DEREF(INDIRECT(\"'\"&S0rp4&\"'!\"&Arow&Jrtr&Acol&Jctr,FALSE)))","v":true}]
[{"$f":"FORMULA(Agnl,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&22&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  ALERT(\"At least 25% of the (Victims+Suspects+Evidence)*Loci must have allele lists!\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":false},null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Ntmp1\",DEREF(INDIRECT(\"'\"&S0rp4&\"'!\"&Arow&Jrtr+Nloc+2&Acol&Jctr+1,FALSE)))","v":true}]
[{"$f":"FORMULA(Alsp,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&23&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  HALT()","v":true},null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Ntmp2\",DEREF(INDIRECT(\"'\"&S0rp4&\"'!\"&Arow&Jrtr+Nloc+2&Acol&Jctr+2,FALSE)))","v":true}]
[{"$f":"FORMULA(Arow,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&24&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"END.IF()","v":false},null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Ntmp3\",DEREF(INDIRECT(\"'\"&S0rp4&\"'!\"&Arow&Jrtr+Nloc+3&Acol&Jctr+1,FALSE)))","v":true}]
[{"$f":"SET.NAME(\"CurZoom\",DEREF(INDIRECT(\"'\"&S0mac&\"'!\"&Arow&9&Acol&3,FALSE)))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Ntmp4\",DEREF(INDIRECT(\"'\"&S0rp4&\"'!\"&Arow&Jrtr+Nloc+3&Acol&Jctr+3,FALSE)))","v":true}]
[{"$f":"IF(ISERROR(1/CurZoom),SET.NAME(\"CurZoom\",0))","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! Validate the alleles",null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Irow\",4+Ievi+(Istd-1)*Nevi)","v":true}]
[{"$f":"IF(OR(CurZoom<30,CurZoom>200),SET.NAME(\"CurZoom\",100))","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DLD_ScreenUpdateOff()","v":0},null,null,null,null,null,null,null,null,{"$f":"      FORMULA(Asam,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow&Acol&Icol,FALSE))","v":true}]
[{"$f":"FORMULA(CurZoom,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&9&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Imsg\",0)","v":true},null,null,null,null,null,null,null,null,{"$f":"      FORMULA(Aevi,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow&Acol&Icol+1,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Nmsg\",(Nrows-4)*Nloc)","v":true},null,null,null,null,null,null,null,null,{"$f":"      IF(Ntmp>0.5,FORMULA(100*Ntmp1/Ntmp,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow&Acol&Icol+2,FALSE)))","v":true}]
["! Return to control panel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FOR(\"Irow\",5,Nrows,1)","v":true},null,null,null,null,null,null,null,null,{"$f":"      IF(Ntmp1+Ntmp2>0.5,FORMULA(100*Ntmp1/(Ntmp1+Ntmp2),INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow&Acol&Icol+3,FALSE)))","v":true}]
[{"$f":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  FOR(\"Icol\",4,Nloc+3,1)","v":true},null,null,null,null,null,null,null,null,{"$f":"      IF(Ntmp4>0.5,FORMULA(100*Ntmp3/Ntmp4,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow&Acol&Icol+4,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Imsg\",Imsg+1)","v":true},null,null,null,null,null,null,null,null,{"$f":"    NEXT()","v":true}]
[{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  Welcome to \"&Asyst&\"!\")","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&P$1&\"> Checking alleles… \"&Imsg&\" of \"&Nmsg)","v":true},null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Irow\",4+Istd+(Istd-1)*Nevi)","v":true}]
[{"$f":"RETURN()","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    ACTIVATE(S0dat)","v":true},null,null,null,null,null,null,null,null,{"$f":"    dld_clearrange(Irow,Icol,Irow,Icol+Nblk-2,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Atmp\",CLEAN(TRIM(UPPER(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE)))))","v":true},null,null,null,null,null,null,null,null,{"$f":"    SELECT(Arow&5+(Istd-1)*Nevi&Acol&Icol&Asep&Arow&4+Istd*Nevi&Acol&Icol+Nblk-2)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    IF(ISNA(Atmp),SET.NAME(\"Atmp\",-999))","v":false},null,null,null,null,null,null,null,null,{"$f":"    SORT(1,Arow&5+(Istd-1)*Nevi&Acol&Icol+4,2,Arow&5+(Istd-1)*Nevi&Acol&Icol+3,2,,,2)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    IF(OR(Atmp=0,Atmp=\"0\",Atmp=\"'0\",Atmp=\"INC\",Atmp=\"NA\",Atmp=\"NEG\",Atmp=\"-\",Atmp=\"\",Atmp=\"'\"),SET.NAME(\"Atmp\",-999))","v":false},null,null,null,null,null,null,null,null,{"$f":"  NEXT()","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    IF(LEN(Atmp)<0.5,SET.NAME(\"Atmp\",-999))","v":false},null,null,null,null,null,null,null,null,{"$f":"END.IF()","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Atmp\",SUBSTITUTE(Atmp,\" \",\"\"))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! Do the Controls x Samples"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! Is it a null?",null,null,null,null,null,null,null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&Y$1&\"> Controls x Samples\")","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    IF(Atmp=\"-999\")","v":true},null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Icol\",1+4*Nblk)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      dld_clearcell(Irow,Icol,FALSE)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(Ncon<0.5)","v":true}]
[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":"  FORMULA(\"Unavailable\",Arow&5&Acol&Icol)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! Check that it doesn't have strange characters in it",null,null,null,null,null,null,null,null,{"$f":"  SELECT(Arow&5&Acol&Icol&Asep&Arow&5&Acol&Icol+Nblk-2)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    ELSE()","v":true},null,null,null,null,null,null,null,null,{"$f":"  ALIGNMENT(7,FALSE,3,0)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      FORMULA(\"'\"&Atmp,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE))","v":true},null,null,null,null,null,null,null,null,{"$f":"ELSE()","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Nchr\",LEN(Atmp))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      FOR(\"Ichr\",1,Nchr,1)","v":true},null,null,null,null,null,null,null,null,{"$f":"ACTIVATE(S0rp6)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Achr\",MID(Atmp,Ichr,1))","v":true},null,null,null,null,null,null,null,null,"! Loop over Controls"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Itmp\",MATCH(Achr,INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&1,FALSE),0))","v":true},null,null,null,null,null,null,null,null,{"$f":"  FOR(\"Istd\",1,Ncon,1)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"        IF(ISERROR(Itmp))","v":true},null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Jrtr\",3+(Istd-1)*(Nloc+5))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          ACTIVATE(S0dat)","v":true},null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0rp5&\"'!\"&Arow&Jrtr+1&Acol&2,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          dld_gotocell_RC(1,1,Irow,Icol,TRUE)","v":false},null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Ntmp\",DEREF(INDIRECT(\"'\"&S0rp5&\"'!\"&Arow&Jrtr+Nloc+2&Acol&2,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          dld_msgbar(S0dat&\"!Row\"&Irow&\"Col\"&Icol&\" has unexpected character: \"&Achr,TRUE)","v":false},null,null,null,null,null,null,null,null,{"$f":"    IF(Ntmp>0.5)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          ALERT(S0dat&\"!Row\"&Irow&\"Col\"&Icol&\" has unexpected character: \"&Achr&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          HALT()","v":true},null,null,null,null,null,null,null,null,"! Loop over all the samples"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"        END.IF()","v":false},null,null,null,null,null,null,null,null,{"$f":"      FOR(\"Ievi\",1,Nstd+Nevi,1)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      NEXT()","v":true},null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Jctr\",4+(Ievi-1)*5)","v":true}]
[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":"        SET.NAME(\"Aevi\",DEREF(INDIRECT(\"'\"&S0rp5&\"'!\"&Arow&Jrtr&Acol&Jctr,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! Check alleles",null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Ntmp1\",DEREF(INDIRECT(\"'\"&S0rp5&\"'!\"&Arow&Jrtr+Nloc+2&Acol&Jctr+1,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      RUN(\"MUM_AllelesList\",FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Ntmp2\",DEREF(INDIRECT(\"'\"&S0rp5&\"'!\"&Arow&Jrtr+Nloc+2&Acol&Jctr+2,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      ACTIVATE(S0dat)","v":true},null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Ntmp3\",DEREF(INDIRECT(\"'\"&S0rp5&\"'!\"&Arow&Jrtr+Nloc+3&Acol&Jctr+1,FALSE)))","v":true}]
[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":"        SET.NAME(\"Ntmp4\",DEREF(INDIRECT(\"'\"&S0rp5&\"'!\"&Arow&Jrtr+Nloc+3&Acol&Jctr+3,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! If the lengths are the same, ok… just replace",null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Irow\",3+Ievi+(Istd-1)*(Nstd+Nevi+1))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      IF(Atmp<>Anew)","v":true},null,null,null,null,null,null,null,null,{"$f":"        FORMULA(Asam,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow+1&Acol&Icol,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"        IF(AND(LEN(Atmp)=LEN(Anew),ISERROR(FIND(\"*\",Anew))))","v":true},null,null,null,null,null,null,null,null,{"$f":"        FORMULA(Aevi,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow+1&Acol&Icol+1,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          FORMULA(Anew,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE))","v":true},null,null,null,null,null,null,null,null,{"$f":"        IF(Ntmp>0.5,FORMULA(100*Ntmp1/Ntmp,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow+1&Acol&Icol+2,FALSE)))","v":true}]
[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(Ntmp1+Ntmp2>0.5,FORMULA(100*Ntmp1/(Ntmp1+Ntmp2),INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow+1&Acol&Icol+3,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! Any other difference",null,null,null,null,null,null,null,null,{"$f":"        IF(Ntmp4>0.5,FORMULA(100*Ntmp3/Ntmp4,INDIRECT(\"'\"&S0rp6&\"'!\"&Arow&Irow+1&Acol&Icol+4,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"        ELSE()","v":true},null,null,null,null,null,null,null,null,{"$f":"      NEXT()","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          ACTIVATE(S0dat)","v":true},null,null,null,null,null,null,null,null,{"$f":"      SELECT(Arow&5+(Istd-1)*(Nstd+Nevi+1)&Acol&Icol&Asep&Arow&3+Istd*(Nstd+Nevi+1)&Acol&Icol+Nblk-2)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          dld_gotocell_RC(1,1,Irow,Icol,TRUE)","v":0},null,null,null,null,null,null,null,null,{"$f":"      SORT(1,Arow&5+(Istd-1)*(Nstd+Nevi+1)&Acol&Icol+4,2,Arow&5+(Istd-1)*(Nstd+Nevi+1)&Acol&Icol+3,2,,,2)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          dld_msgbar(S0dat&\"!Row\"&Irow&\"Col\"&Icol&\" has a redundant or '()'-flagged weak allele.\",TRUE)","v":0},null,null,null,null,null,null,null,null,{"$f":"    END.IF()","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Atmp1\",ALERT(S0dat&\"!Row\"&Irow&\"Col\"&Icol&\" has a redundant or '()'-flagged weak allele: \"&Atmp&\" should be \"&Anew&\"?\"&Acar&Acar&\"Click 'OK' to continue, 'Cancel' to abort.\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",1))","v":true},null,null,null,null,null,null,null,null,{"$f":"  NEXT()","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          IF(NOT(Atmp1))","v":true},null,null,null,null,null,null,null,null,{"$f":"END.IF()","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"            dld_msgbar(\"User will correct the notation.\",TRUE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"            ALERT(\"Correct the hassle and try again!\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",1)","v":true},null,null,null,null,null,null,null,null,"! Format"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"            HALT()","v":true},null,null,null,null,null,null,null,null,{"$f":"ACTIVATE(S0rp6)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          END.IF()","v":false},null,null,null,null,null,null,null,null,{"$f":"DLD_ScreenUpdateOn()","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          FORMULA(Anew,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE))","v":true},null,null,null,null,null,null,null,null,{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"        END.IF()","v":true},null,null,null,null,null,null,null,null,{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"      END.IF()","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    END.IF()","v":true},null,null,null,null,null,null,null,null,"! Update the controlpanel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  NEXT()","v":true},null,null,null,null,null,null,null,null,{"$f":"FORMULA(\"Complete\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&3,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NEXT()","v":true},null,null,null,null,null,null,null,null,{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&RepR&Acol&4,FALSE))","v":true}]
[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":"RUN(MUM_ConRestore,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! Format Data sheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&P$1&\"> Final checks\")","v":true},null,null,null,null,null,null,null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&Y$1&\"> Finished.\")","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ACTIVATE(S0dat)","v":true},null,null,null,null,null,null,null,null,{"$f":"RETURN()","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DLD_ScreenUpdateOn()","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! Check the Descriptor lengths"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FOR(\"Isam\",1,Nvic+Nsus+Nevi,1)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4+Isam&Acol&2,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Nlen\",LEN(Asam))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  IF(OR(Nlen<1.5,Nlen>Mlen))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    dld_gotocell_RC(1,1,4+Isam,2,TRUE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    dld_msgbar(\"The sample Descriptors should be as short as possible.\",TRUE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    ALERT(\"The sample Descriptors should be as short as possible,\"&Acar&\"with a minimum of 2 and a MUM_DataCheckmaxium of \"&Mlen&\" characters.\"&Acar&Acar&Asam&\" has \"&Nlen&\" characters.\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    HALT()","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  END.IF()","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NEXT()","v":true}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! Update the Worksheet record"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RUN(\"MUM_DataParam\",FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! Format Data sheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ACTIVATE(S0dat)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"dld_setcolwidth(1,-1,TRUE)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! Check current maximum numbers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Nctl>0.5,Nxcl+Nvic+Nsus+Nevi>50.5))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Jrow0\",MIN(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&13&Asep&Arow&6&Acol&13,FALSE)))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Jrow1\",MAX(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&14&Asep&Arow&6&Acol&14,FALSE)))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  dld_SELECTrows(Jrow0,Jrow1,TRUE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  dld_msgbar(\"The maximum number of samples for the current version of \"&WB_0&\" is 50!\",TRUE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  ALERT(\"The maximum number of samples for the current version of \"&WB_0&\" is 50!\"&Acar&\"There are \"&Nxcl+Nvic+Nsus+Nevi&\" on \"&S0dat&\".  Dump some of 'em.\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  HALT()","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"END.IF()","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Nctl<0.5,Nxcl+Nvic+Nsus>50.5))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Jrow0\",MIN(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&13&Asep&Arow&5&Acol&13,FALSE)))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Jrow1\",MAX(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&14&Asep&Arow&5&Acol&14,FALSE)))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  dld_SELECTrows(Jrow0,Jrow1,TRUE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  dld_msgbar(\"The maximum number of standards for the current version of \"&WB_0&\" is 50!\",TRUE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  ALERT(\"The maximum number of standards for the current version of \"&WB_0&\" is 50!\"&Acar&\"There are \"&Nxcl+Nvic+Nsus&\" on \"&S0dat&\".  Dump some of 'em.\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  HALT()","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"END.IF()","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Nctl<0.5,Nevi>50.5))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ACTIVATE(S0dat)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Jrow0\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&6&Acol&13,FALSE)))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Jrow1\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&6&Acol&14,FALSE)))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  dld_SELECTrows(Jrow0,Jrow1,TRUE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  dld_msgbar(\"The maximum number of evidence for the current version of \"&WB_0&\" is 50!\",TRUE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  ALERT(\"The maximum number of evidence for the current version of \"&WB_0&\" is 50!\"&Acar&\"There are \"&Nevi&\" on \"&S0dat&\".  Dump some of 'em.\"&Acar&Acar&\"Shortcut: <Ctrl-A>\",2)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  HALT()","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"END.IF()","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! Update ControlPanel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FORMULA(\"Checked\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&3,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&4,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RUN(MUM_DisSum,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"dld_gotocell_RC(1,1,20,1,TRUE)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\"  \"&P$1&\"> Finished.\")","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RETURN()","v":true}]

{"sheet":"ReadMe","index":9,"n_rows":216,"n_cols":12,"rows_kept":216,"cut":false,"hidden":true,"merged":[[40,4,40,5],[40,7,40,8],[38,4,38,9],[206,3,206,4],[107,3,107,10],[108,3,108,10],[109,3,109,10],[110,3,110,10],[111,3,111,10],[112,3,112,10],[183,1,185,1],[197,1,197,4],[209,3,209,4],[147,3,147,5],[152,3,152,5],[199,3,199,4],[202,3,202,4]]}
[null,"Welcome to mixSTR!"]
[null,"mixSTR <Version 07-May-21>"]
[]
[null,"mixSTR is intended to help you sort out STR \"Mixture\" problems."]
[null,"mixSTR considers only the presence/absence of alleles.  It makes no use of relative signal intensity."]
["   ",null,null,null,null,null,null,null,null,null,"                                                         ","   "]
[]
[null,"ControlPanel"]
[]
[null,"The ControlPanel worksheet is where you drive the mixSTR system."]
[]
[null,"ControlPanel has a panel of \"buttons\" that execute various functions.  There are currently eight buttons:"]
[null,"  Clear Reports: Clears all contents of all the report sheets."]
[null,"  Clear Data: Clears all contents of the Data sheet."]
[null,"  Import Data: Clears any old data and imports data from \"Merged Landscape\"-style Excel workbooks."]
[null,"  Add Controls: Adds Control samples from specified Excel sheets.  Control alleles must be specified as comma-separated lists."]
[null,"  Check Data: Checks the Data sheet information compliance with mixSTR format."]
[null,"  Analyze: Clears any old reports, checks the data on the \"Data\" worksheet and, if all is ok, produces all the Reports."]
[null,"  ReadMe: Unhides this sheet and takes you to it."]
[null,"  Exit: Closes the workbook"]
[]
[null,"ControlPanel displays the current status of the Data and Report worksheets.  (See columns C to F, >>>>)"]
[]
[null,"ControlPanel also now summarizes the contents of the Data worksheet (see cols H to L, >>>>):"]
[null,"  1) the number, if any, of samples of different types  and"]
[null,"  2) the codes for the loci, if any, and the number of samples that specify at least one allele at that locus."]
[]
[]
[]
[]
[]
[]
[null,"Data"]
[]
[null,"The Data worksheet is where all the information used by the mixSTR system is defined."]
[]
[null,"All information for all samples must be entered in the Data worksheet."]
[null,"Every row, starting at row 5, must specify the sample type and all unique alleles for that sample.   See the example set ==>",null,null,"Col A","Col B","Col C","Col D","Col E","…"]
[null,"    Row 1 Column 1 must contain a descriptive title for the dataset.",null,"Row 1","A Short Title Goes Here"]
[null,"    Row 2 must be blank.",null,"Row 2"]
[null,"    Row 3 is for header information: \"Sample\" (row 3 column 1) and \"Loci\" (row 3 column 4).",null,"Row 3","Sample",null,null,"Loci"]
[null,"    Row 4 is also for header information: \"Type\" in column 1, \"Description in column 2, and the locus names in columns 4 to ?.",null,"Row 4","Type","Description",null,"FGA","TPOX"]
[null,"    Row 5 is for sample information: the sample Type (see below) in column 1, a short description of the sample in column 2,",null,"Row 5","Victim","L10: Victim",null,"19,23","8,11"]
[null,"        all unique alleles of the sample at each specified locus, entered as comma-separated strings, in columns 4 to ?.",null,"…","Suspect","L13: Suspect 3",null,"22,26",8]
[null,"        Each set of unique alleles may only contain the digits 0 to 9, period (.), \"X\", \"Y\", \"O\", asterisk (*), and comma (,).",null,"…","Suspect","L15: Suspect 5",null,"23,25",11]
[null,"            The absence of observed alleles at a locus may be specified as \"INC\", \"NEG\", \"NA\", or \"-\"; however, these are replaced by an empty cell.",null,"…","Mixture","L03: Gun-handle",null,"21,22,25","7,11"]
[null,"            An allele may be flagged with a trailing asterisk (*); enclosing parentheses will be replaced with the * (e.g., \"(11)\" becomes \"11*\").",null,"…","Mixture","L04: Door-Knob",null,"22,25","7,9,11"]
[null,"                The asterisk flag is used only in the display of alleles, e.g. indicating possible stutter.  It is not used in any computation."]
[null,"        There is NO check on the validity of allele designations for specific loci, only on the characters!"]
[]
[null,"Seven sample Types are recognized: Blank (BL), Control (CO), Disabled (DI), Evidence (EV), Suspect (SU), Victim (VI), and Xclude (XC)."]
[null,"    Only the first two letters of each Type are required; the Types are fully expanded when the Data are checked."]
[null,"    Blank and Disabled samples are checked for validity but otherwise are not used."]
[null,"        Any sample that has no valid alleles will be re-typed as \"Blank\", regardless of any originally assigned Type."]
[null,"        The Disabled designation temporarily removes a sample from analysis without actually deleting it from the Data sheet."]
[null,"    The Suspect, Victim, and Xclude Types are three types of Standard.  Except for the label, all Standards are treated identically in the Reports."]
[null,"    Standard samples are separately compared against Evidence samples and against other Standards."]
[null,"    Evidence samples are separately compared against the Standards and against other Evidence."]
[null,"    Control samples are compared against all Evidence, Suspect, Victim, and Xclude samples."]
[]
[null,"The current mixSTR system allows only a limited number of Standard and Evidence samples."]
[null,"    If there are no Control samples, up to 50 Evidence and 50 Standard (Suspect, Victim, Xclude) samples are allowed."]
[null,"    If there are one or more Control samples, only a total of 50 Evidence plus Standard (Suspect, Victim, Xclude) samples are allowed."]
[]
[null,"The system will stop & complain about all data-specification \"errors\" that it encounters."]
[]
[]
[]
[]
[null,"Importing Data - Original Format",null,null,null,null,null,null,null,null,"…"]
[null,"To make life easier, data can be imported from Excel worksheets using the Import Data button on the ControlPanel.",null,null,"Col j-2","Col j-1","Col j ","Col j+1","Col j+2","Col j+3"]
[null,"There is no absolute location for the data on the import sheet.  However, the following structure is required:",null,"Row i-1",null,null,"FGA",null,"TPOX"]
[null,"    The location of the data is signaled by the first encounter of adjacent cells on the same row that contain \"1\" and \"2\".  Designate this row i, col j",null,"Row i","Lane No.","Specimen No.",1,2,1,2]
[null,"    Every non-blank row below row i designates the start of a new sample.",null,"Row i+1","Lane 10","Victim",23,19,11,8]
[null,"    The names for the loci are taken from row(i-1), columns(j,j+2,j+4,…)",null,"Row i+2","Lane 13","Suspect 3",26,22,8]
[null,"    The sample names are built from every non-blank cell from col 1 to col j-1.  A non-blank cell in these columns indicates a new sample.",null,"Row i+3","lane 15","Suspect 5",25,23,11]
[null,"    The comma-separated allele list for each locus of a given sample is built from the locus \"1\" and \"2\" columns for all of the sample's rows.",null,"Row i+4","Lane 3","Gun-handle",25,22,11,7]
[null,"Completely blank rows and columns are ignored.",null,"Row i+5",null,null,21]
[null,"An attempt is made to assign a sample Type from the sample name.  Names that contain:",null,"Row i+6","Lane 4","Door-Knob",25,22,11,9]
[null,"    \"BLA\" are assigned type \"Blank\"",null,"Row i+7",null,null,null,null,7]
[null,"    \"CON\" are assigned type \"Control\""]
[null,"    \"EVI\" or \"MIX\" are assigned type \"Evidence\""]
[null,"    \"EXC\" or \"XCL\" are assigned type \"\"Xclude\"\""]
[null,"    \"SUS\" are assigned type \"Suspect\""]
[null,"    \"VIC\" are assigned type \"Victim\""]
[]
[null,"Importing Data - Bode \"Data\" Format",null,null,"Col 1","Col 2","Col 3","…"]
[null,"A new data sheet format is now susported: Bode's \"Data\" worksheet.  The format is quite rigid:",null,"Row 1",null,"Sample1","Sample2"]
[null,"    Row 1 specifies the sample names, starting in column 2 and going until a blank cell is located",null,"Row 2","Locus1","19,23","8,11"]
[null,"    Col 1 specifies the locus names, starting in row 2 and going until the keyword \"Generate CMF\" is located.",null,"Row 3","Locus2","22,26",8]
[null,"    The alleles are comma-delimited, everything in one cell.",null,"…","…","22,(23),36","NR"]
[null,"        The following non-allelic designations are ignored: US, NID, NR, ?, 0.",null,"Row N+1","LocusN","US","NID"]
[null,"        The characters \" \", \"(\", and \")\" are deleted.",null,"Row N+2","Generate CMF"]
[null,"An attempt is made to assign a sample Type from the sample name as above.  Samples that have no valid alleles are assigned \"Blank\""]
[]
[]
[null,"Adding Controls",null,null,"Col j-1","Col j ","Col j+1","…"]
[null,"To make life easier, Control data can be imported from Excel worksheets using the Add Controls button on the ControlPanel.",null,"Row i",null,"FGA","TPOX"]
[null,"Controls can only be added after a valid Data worksheet has been created.",null,"Row i+1","Control 1","22,23",8]
[null,"The Control sample profiles must be in the form of comma-separated strings, one line per sample.",null,"Row i+2","Control 2","20,22","8,11"]
[null,"As with Importing Data - Original Format, there is no absolute location for the data within the Control sheet.  However, the following structure is required:",null,"…"]
[null,"    The location of the data is signaled by the first cell to contain a valid locus name.  Designate this row i, col j"]
[null,"    Every non-blank row below row i designates a new Control sample."]
[null,"    The Control sample names are built from every non-blank cell from col 1 to col j-1."]
[null,"    Alleles must be available for all of the loci specified for the Data samples; the locus names must exactly match those on the Data sheet."]
[]
[]
[]
[null,"Note: Flagged Alleles",null,"Warning!!!"]
[null,"All asterisk-flagged alleles (e.g., \"11*\") are analyzed as if unflagged."]
[null,"When a flagged allele and its unflagged counterpart (e.g., \"11*\" and \"11\") are put into the same list, the asterisk-flag will be removed.",null,"All information imported or added to the \"Data\" worksheet"]
[null,"However, in the absence of an unflagged allele of the same value (e.g., \"11\"), the flag will be retained in the displays.",null,"should be checked thoroughly before use!"]
[]
[]
[]
[]
[null,"Output Reports"]
[]
[null,"The Analyze button causes the mixSTR system to generate six different output reports."]
[]
[null,"RepCombined: Allele validation on sheet"]
[null,"    This worksheet lists all recognized alleles for Standards and Evidence, providing a compact way to check for typographical errors and oversights."]
[null,"    Columns B to F report composite allele lists for Xcludes, Victims, Suspects, Standards (Xcludes&Victims&Suspects), and Evidence."]
[null,"    Column H reports all alleles that are present in some Standard (Xcludes&Victims&Suspects) but are not in any Evidence."]
[null,"    Column I reports alleles that are present in some Evidence but are not in any Standard (Xcludes&Victims&Suspects)."]
[]
[]
[null,"RepSE: Alleles from Standards (Xcludes&Victims&Suspects) present in Evidence"]
[null,"    This sheet provides detailed analysis of the number of alleles of each Standard that are common to each Evidence."]
[null,"    If there are both Standard (Xcludes&Victims&Suspects) and Evidence samples, there will (Number Standards) x (Number Evidence)  blocks of results."]
[null,"        Each block consists of two header rows, (number Loci) allele lists, and a summary row."]
[null,"        Columns A and B list the Description and alleles of each Standard.  These apply to all of the Evidence blocks in columns D to ?."]
[null,"        For each Evidence sample, there are four columns in the block."]
[null,"          The first column is the allele list for the Evidence."]
[null,"          The second column (labeled \"#+\") is the number of alleles in the Standard that are common to the given Evidence."]
[null,"          The third column (Labeled \"#-\") is the number of alleles in the Standard that are absent from the given Evidence."]
[null,"          The fourth column (labeled \"-Alleles\") is the list of alleles in the Evidence that are not shared with the given standard."]
[null,"      The next-to-last row of each block provides the sum of all present and absent alleles over the (number Loci) rows."]
[null,"      The last row of each block provides the number of loci where the all of the reference sample alleles are contained in the target sample (# In),"]
[null,"           the number of loci where at least one of the reference sample alleles are not contained in the target sample (# Ex),"]
[null,"           and the total number of loci where the reference and target samples have alleles (# Total)."]
[]
[null,"RepSS: Alleles from Standards (Xcludes&Victims&Suspects) present in other Standards"]
[null,"    This sheet provides detailed analysis of the number of alleles of each Standard that are shared with other Standards."]
[null,"    If there is more than one Standard (Xcludes&Victims&Suspects), there will (Number Standards) x (Number of Standards)  blocks of results."]
[null,"    The presentation format is identical to that in the RepSE worksheet."]
[]
[null,"RepEE: Alleles from Evidence samples present in other Evidence",null,"This looks much like the above"]
[null,"    This sheet provides detailed analysis of the number of alleles of each Evidence sample that are shared with other Evidence."]
[null,"    If there is more than one Evidence sample, there will (Number Evidence) x (Number Evidence)  blocks of results."]
[null,"    The information is identical to that in the RepSE worksheet."]
[]
[null,"RepControl: Alleles from Control samples present in Xclude, Victim, Suspect, and Evidence samples",null,"So does this"]
[null,"    This sheet provides detailed analysis of the number of alleles of each Control sample that are shared with Standard and Evidence samples."]
[null,"    There will (Number Controls) x (Number Standard+Evidence)  blocks of results."]
[null,"    The information is identical to that in the RepSE worksheet."]
[]
[null,"RepSummary: Summary results from the Reports presenting sorted lists of the % shared alleles"]
[null,"    Five sets of summary results are presented, each set divided into blocks indicated by an empty cell."]
[null,"        Columns A to E list the Standard (Xclude&Victim&Suspect), the Evidence, the % of shared alleles, and the % included loci."]
[null,"        Columns G to K list the Evidence, the Standard (Xclude&Victim&Suspect), the % of shared alleles, and the % included loci."]
[null,"        Columns M to Q list the Standard (Xclude&Victim&Suspect), the other Standard, the % of shared alleles, and the % included loci."]
[null,"        Columns S to W list the Evidence, the other Evidence, the % of shared alleles, and the % included loci."]
[null,"        Columns Y to AC list the Controls, the Standard+Evidence, the % of shared alleles, and the % included loci."]
[null,"    The % shared alleles is expressed two slightly different ways:"]
[null,"          %A is the % shared alleles relative to the number of alleles \"All\" loci: %A = 100*(#+)/(# in reference list)"]
[null,"          %P is the % shared alleles relative to the number of alleles in \"present\" loci: %P = 100*(#+)/(#+ & #-)"]
[null,"          %P should always be equal to or larger than %A."]
[null,"    The % included loci is the % loci where all reference sample alleles are shared with the target sample: %In = 100*(# In)/(# Total)"]
[null,"    Within each block of each set, the results are sorted from largest to smallest %In with ties sorted from largest to smallest %P."]
[]
[]
[]
[]
[]
[null,"Other sheets"]
[null,"ReadMe: This page, normally \"Hidden\".  It's intended to help you get started… but learning by doing is recommended."]
[null,"Macro_MUM: Holds the old XL4 programming code."]
[null,"Work: A \"Hidden\" sheet that holds the list of valid \"allelic specification\" characters and various other bits of operational info."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"When you have questions, comments, and/or corrections: Contact"]
[]
[null,"Dave Duewer, david.duewer@nist.gov"]
[null,"Chemical Sciences Division"]
[null,"National Institute of Standards and Technology"]
[null,"100 Bureau Drive, Stop 8390"]
[null,"Gaithersburg, MD  20899-8390"]
[]
[]
[null,"History"]
[]
[null,"mixSTR started life as \"MixedUpMess\" in late 2004.  It was created at the request of Cecelia A Crouse Palm Beach County Sheriff's Office (PBSO), Florida,",null,"Autumn, 2004"]
[null," to help organize results from complex mixtures and was intended to be pretty much a use-once program."]
[]
[null,"As the good folk at PBSO guided the growth of the original system into something that looked to have general utility, it was given the current",null,"March, 2005"]
[null," (rather more politically correct) name.  Catherine J Cothran, Palm Beach County Sheriff's Office, Florida, reported using mixSTR to organize"]
[null,"\"mind numbingly\" complex mixture data in March 2005 at the Fourth Annual Bode East Coast Advanced DNA Technology Workshop."]
[]
[null,"Again at PBSO's request, added the cabability to import data from \"Bode\" format data files",null,"1-January-2009"]
[null,"Also updated system to enable use with non-English Excel country versions, should anyone ever desire to do so."]
[]
[null,"Following Cathy Cothran's debugging, killed several bugs and updated the ReadMe worksheet",null,"20-January-2009"]
[null,"Made some progress in keeping font colors associated with alleles, but full solution will take awhile."]
[]
[null,"At request of Tayawee Romgaew, Thai police DNA lab in Bangkok, I modified enough of the ancient XL4 macro code so that it now runs on at least my current",null,"9-May-2021"]
[null,"version of Excel.  Timing issues within Excel seem to have been the major problem: solution involved replacing the XL4 \"SELECT\" commands with VBA"]
[null,"equivalents.  However, the mixing of languages creates its own problems!  Any error in calling VBA functions can cuase major and non-reproducable errors."]
[null,"Use at Your Own Risk!"]

{"sheet":"DateTime","index":10,"n_rows":56,"n_cols":32,"rows_kept":56,"cut":false,"hidden":true,"merged":[[0,5,1,5]]}
["Parameter","Value","Format","Status",null,"Whoops… Date-Time format issue!"]
["Date","2021-05-09T18:19:13.940","dd-mmm-yy","Valid"]
["Time",44325.763355787036,"h:mm:ss","Valid",null,"Different versions of Excel support different date and time formats."]
["DateTime","2021-05-09T18:19:13.940","dd-mmm-yy h:mm:ss","Valid",null,"The default formats (in Excel-eze, \"dd-mm-yy\" and \"hh:mm:ss\") are not valid for your system.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Atmp4"]
[]
[null,null,"Duewer, David L. Dr. (Fed)",null,null,"Please use Excel's standard Format menubar tool to format the contents of cells B2 and B3 (rows 2 and 3 of col 2)."]
[null,null,17,null,null,"to show the date (day, month and year) and time (hour, minute, second)."]
[null,null,null,null,null,"In the Excel system used to build this program, the date and time format tool is accessible from the"]
[null,null,null,null,null,"\"Number\" page of the \"Cells…\" entry of the \"Format\" menu of the MenuBar (Format > Cells… > Number)."]
[]
[null,null,null,null,null,"Use the \"Date\" item of the Number page to set the date format of cell B2 (row 2 col 2) and"]
[null,null,null,null,null,"the \"Time\" item to set the time format of cell B3 (row 3 col 2)."]
[null,null,null,null,null,"Once the contents of these two cells display to you satisfaction, click the Check It button below."]
[]
[null,null,null,null,null,"With any luck, you should never see this page (in this particular program) again!"]
[null,null,null,null,null,"If you encounter difficulties, please contact Dave Duewer (David.Duewer@NIST.gov) with details."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,140]
[null,null,null,null,null,{"$f":"F55/200","v":0.7}]

{"sheet":"Work","index":11,"n_rows":18,"n_cols":22,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["1",null,null,null,12,11,12,11,null,null,"Type","#","Rfst","Rlst",null,"Col","Locus",null,null,null,"Abb","Type"]
["2",null,null,null,13,null,13,null,null,null,"Control",null,null,null,null,null,null,null,null,null,"Bla","Blank"]
["3",null,null,null,null,null,null,null,null,null,"Xclude",null,null,null,null,null,null,null,null,null,"Con","Control"]
["4",null,null,null,null,null,null,null,null,null,"Victim",null,null,null,null,null,null,null,null,null,"Dis","Disabled"]
["5",null,null,null,null,null,null,null,null,null,"Suspect",null,null,null,null,null,null,null,null,null,"Evi","Evidence"]
["6",null,null,null,null,null,null,null,null,null,"Evidence",null,null,null,null,null,null,null,null,null,"Exc","Xclude"]
["7",null,null,null,null,null,null,null,null,null,"Blank",null,null,null,null,null,null,null,null,null,"Mix","Evidence"]
["8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sus","Suspect"]
["9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vic","Victim"]
["0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Xcl","Xclude"]
[","]
["."]
["*"]
[")"]
["("]
["X"]
["Y"]
["O"]