{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["ControlPanel","Data","RepDetail","RepSummary","RepProfile","Introduction","ReadMe","MS_Macro","DateTime","Work"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":168,"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":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":false,"merged":[[10,2,10,5],[11,2,11,5],[0,0,2,0],[5,0,7,0],[79,0,80,0],[10,0,12,0],[70,0,71,0],[73,0,74,0],[20,0,22,0],[76,0,77,0],[28,0,29,0],[31,0,32,0],[15,0,17,0],[35,0,37,0],[25,0,26,0],[12,2,12,5],[15,3,15,6],[16,3,16,6],[25,4,25,6],[20,2,20,5],[21,2,21,5],[23,4,23,6],[24,4,24,6],[17,3,17,6]]}
[null,"***",null,"Status of Report Sheets",null,null,null,null,"Counts"]
[null,null,null,"Status","Last Called","Sheet","Contains",null,"Type","#"]
[null,null,null,"Clear","2017-10-10T10:37:25.830","Data","Comma-delimited STR-profiles for all samples",null,"Total",0]
[null,null,null,"Clear","2017-10-10T10:37:25.830","RepDetail","Details of 'Best Match' of Unmatcheds to other Unmatched samples",null,"Exact Match",0]
[null,null,null,"Clear","2017-10-10T10:37:25.830","RepSummary","Summary of Two 'Best Match'es to other Unmatched samples",null,"Unmatched",0]
[null,null,null,"Clear","2017-10-10T10:37:25.830","RepProfile","Profiles for Unmatched and its 'Best Match' to other Unmatched samples",null,"Unmatch (able?)",0]
[]
[null,null,null,null,null,null,null,null,"Off-ladder alleles"]
[]
[2]
[1,null,"Only the initial dataset"]
[null,null,"All datasets"]
[null,null,"All datasets, if confirmed"]
[]
[]
[null,false,null,"Delete blank (no specified alleles) records",null,null,null,null,"Deleted blanks"]
[null,false,null,"Convert all \"OR\" allelic designations to \"no result\"",null,null,null,null,"Deleted 'OR's"]
[null,false,null,"Remove ambiguous alleles (\"?\")",null,null,null,null,"Deleted '?'s"]
[]
[]
[2,null,"Against all samples"]
[null,null,"Against unmatched samples"]
[]
[null,null,null,"Value","Criteria for number of 'Best Match' profiles listed in RepDetail  - at least one must be 'checked'!"]
[null,true,null,15," Maximum number.  Default is 10, lower-bound is 3 and upper-bound is all available."]
[null,false,null,90," Minimum %Loci:1+ (i.e., the percent of loci that share at least one allele).  Default is 100"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["EngineeringControl"]

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

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

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

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

{"sheet":"Introduction","index":5,"n_rows":77,"n_cols":4,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,0,34,0],[12,2,12,4],[18,2,18,4],[20,2,20,4],[21,2,21,4],[0,2,0,4],[2,2,2,4],[3,2,3,4],[19,2,19,4],[17,2,17,4],[4,2,7,4],[14,2,14,4],[15,2,15,4],[76,3,79,4],[72,3,74,4],[9,3,9,4],[44,2,44,4],[13,2,13,4],[11,3,11,4],[23,2,23,4],[68,3,70,4],[61,3,66,4],[56,3,59,4],[22,2,22,4],[25,2,25,4],[24,2,24,4],[51,3,51,4],[53,3,54,4],[45,3,49,4],[27,3,28,3],[30,2,30,4],[32,3,34,3],[1,2,1,4],[8,3,8,4],[10,3,10,4]]}
["STR_MatchSamples was developed by David Duewer, Analytical Chemical Division, NIST,\nwith advice and support from the Applied Genetics group, Biochemical Science Division.",null,"Welcome to STR_MatchSamples!"]
[null,null,"Version <22-Apr-2016>"]
[]
[null,null,"STR_MatchSamples enables identification of Exact Batch and Best Match samples in a list of STR profiles."]
[null,null,"The system was designed to compare profiles from electropherograms processed by different software (particularly different \"Expert Systems\") and for the same set of samples analyzed at different times, by different analysts, using different multiplexes, etc.  It has also proven useful for the evaluation of profiles from related individuals, particularly father/son pairs."]
[]
[]
[]
[null,null,"Outputs results include: ","a list of all samples that have the exactly the same alleles at all specified loci;"]
[null,null,null,"for each sample, a list of up-to-10 samples that Best Match;"]
[null,null,null,"for each sample, a list of the two most Best Matches;"]
[null,null,null,"for each sample, a color-coded map of the differences relative to the Best Match."]
[null,null,"where Best Match is defined as the largest percentage of shared alleles."]
[]
[null,null,"Profiles stored in either the NIST standard and/or compact formats (see STR_ConvertFormats) can be used to create the profile list."]
[null,null,"Any number of Excel worksheets can be combined into the profile list ('tho you need a fast computer if the list gets very long…)"]
[]
[null,null,"Problems?"]
[null,null,"This is still a \"beta\" release: there will be problems!"]
[null,null,"Please repeat whatever caused the blowup a couple of times and note down all symptoms and error messages."]
[null,null,"Email the description to david.duewer@nist.gov"]
[]
[null,null,"Getting Started"]
[null,null," STR_MatchSamples is designed to be operated by \"pushing buttons.\"  All functions are available on the ControlPanel worksheet."]
[null,null,"The ReadMe worksheet documents the functions, abbreviations and file formats as well as giving a few usage tips."]
[null,null,"If you haven't used STR_MatchSamples before, please…"]
[]
[]
[]
[]
[null,null,"…but the best way to learn the tool is to 1) download the demo-data workbook and 2) start pushing buttons!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"History"]
[null,null,"2006-12-01","The Human Identity Project team at NIST has used, with varying degrees of ease and success, a number of special-purpose format conversion systems over the past few years.  Responding to requests from the forensic human identity community for access to these utilities, this (hopefully) more robust and user-friendly system was cobbled together from these \"bits and pieces\" of purpose-built code in later November of 2006."]
[]
[]
[]
[]
[]
[null,null,"2006-12-20","Beta version released on an unsuspecting world."]
[]
[null,null,"2007-01-01","Thanks to Becky Hill (NIST's HIP team) and Scott Nagy (Cal DOJ), several \"user-abuser\" issues were addressed, mostly by changes to the Introduction and ReadMe worksheets."]
[]
[]
[null,null,"2007-06-12","Thanks to Tom Heylen (DNA Laboratory of the National Institute of Criminalistics and Criminology, Brussels Belgium), the system can now be used with Excel versions that use \",\" rather than \".\" as the decimal point and \";\" rather than \",\" as the list separator.  Also, a facility that helps ensure use of locally-valid date and time formats was added."]
[]
[]
[]
[]
[null,null,"2007-06-18","Thanks to Becky Hill for recognizing a major bug in tracking loci across datasets.  Previous versions only worked correctly when the loci in different datasets were sorted in the same order as the first loaded dataset.  Sorry 'bout that!  At Tom Heylen suggestion, you can now change the color-coding in the RepProfile (see the bottom of the ReadMe worksheet.)  Also at Tom's suggestion, you can also chose whether you want \"new loci\" (i.e., those not specified in the initial dataset) to be Added to the dataset."]
[]
[]
[]
[]
[]
[]
[null,null,"2007-06-19","A \"list separator\" error in the new color-coding routine, reported cogently by Tom Heylen, was fixed along with a few cosmetic bugs.  The \"Get Started\" button on the ReadMe sheet was moved to the top of the sheet and above the freeze-pane.  "]
[]
[]
[]
[null,null,"2008-04-17","Thanks to Tom Reid (DNA Diagnostics Center), you can now specify the number of \"best Match\" profiles listed in the RepDetail sheet and/or the minimum % of loci than must have at least one matching allele.  While I was at it, I cleaned up some stylistc issues in the code."]
[]
[]
[]
[null,null,"28-May to 1-Jun-2009","Thanks to Jasper Humbert, South Carolina Law Enforcement Division DNA lab, for helping me identify a major error: in previous versions, five or more alleles at any locus could cause the generation of really odd and potentially wrong output.  Also, at his suggestion several data-check options were addded to make life a bit simpler."]

{"sheet":"ReadMe","index":6,"n_rows":135,"n_cols":15,"rows_kept":135,"cut":false,"hidden":false,"merged":[[43,1,43,15],[134,1,134,15],[72,4,72,15],[92,4,92,15],[108,4,108,15],[128,1,128,15],[129,1,129,15],[131,1,131,15],[126,1,126,15],[133,1,133,15],[121,1,121,15],[123,1,123,15],[124,1,124,15],[125,1,125,15],[11,3,11,15],[16,3,16,15],[25,3,25,15],[53,4,53,10],[21,3,21,15],[22,3,22,15],[23,3,23,15],[32,1,32,14],[36,1,36,14],[34,1,34,15],[27,3,27,15],[40,1,40,15],[38,1,38,15],[48,1,48,15],[45,1,45,15],[46,1,46,15],[26,3,26,15],[2,3,2,15],[3,3,3,15],[6,3,6,15],[7,3,7,15],[5,3,5,15],[13,3,13,15],[14,3,14,15],[15,3,15,15],[8,3,8,15],[17,3,17,15],[18,3,18,15],[19,3,19,15],[24,3,24,15],[9,3,9,15],[10,3,10,15]]}
[null,"  "]
[]
[null,"What is a 'Best Match'?",null,"ControlPanel Summary Information"]
[null,"For a given \"Match From\" profile, the STR_MatchSamples system selects the Best Match \"Match To\" profiles as:",null,"Columns A and B of the ControlPanel worksheet contain the command buttons and the radio-button that specify various user-dettable options."]
[null,"    Those \"Match To\" profiles with the largest percentage of loci that share at least one well-defined allele with the \"Match From\" profile."]
[null,"    Given the same % matching loci, those \"Match To\" profiles with the largest percentage of alleles shared with \"Match From\".",null,"Columns D to G provide information on the progress of the analysis."]
[null,null,null,"  Status: the current condition of the 'Report' worksheets.  The status of the Data worksheet is the most important."]
[null,"In the absence of ambiguous/missing alleles, if A is the Best Match to B then B\" will be the Best Match to A.",null,"    The Data states are: Clear, Loading, Loaded, Checking and Checked.  Data must first be successfully loaded, then checked."]
[null,"However, this symmetry may not hold when one or both of the profiles has ambiguous/missing alleles.",null,"    The RepDetail, RepSummary and RepProfile states are: Clear, Processing and Done!"]
[null,null,null,"  Last Called: The date-time when the last operation occurred that affected the status of the worksheet."]
[null,null,null,"  Sheet: The name of the worksheet"]
[null,"ControlPanel Commands",null,"  Contains: A short description of the eventual content of the worksheet."]
[null,"All of the (interesting) STR_MatchSamples commands are accessed from the ControlPanel worksheet."]
[null,null,null,"Columns I and J list the number of  various categories of sample listed in the Data worksheet."]
[null,"There are currently six commands, each accessed via it's own Command Button:",null,"  Type: The match-type of the samples.  The four types (well, the total plus two distinct types plus a subtype) are:"]
[null,"ReadMe: Activates this ReadMe \"Instruction Manual\" worksheet.",null,"    Total - the total number of profiles listed in the Data worksheet."]
[null,"Clear: Clears all status reports, working data, and report worksheets.",null,"    ExactMatch - the number of unique profiles that were shared by two or more of the originally loaded profiles."]
[null,"Add Data: Allows user to specify a particular worksheet and add it to the list of samples-to-match on Data.  Shortcut: <Ctrl-A>",null,"    Unmatched - the number of unique profiles in the originally loaded data that were not shared."]
[null,"    What data is added depends on the setting of the radio buttons in the \"Use Loci Contained In\" group, to the right of the Add Data button.",null,"    Unmatch (able?) - the number of 'Unmatched' profiles that do not share a sample name with at least one other sample."]
[null,"     If \"Only the initial dataset\" is active, then only those loci specified in the initial Add will be used… What's more, only datasets that have",null,"  #: The number of samples of each type."]
[null,"         those loci can be added.  If one or more loci are missing, the system will notify you of the situation and stop; excess loci are ignored."]
[null,"     If \"All datasets\" is active, then all loci specified in any added dataset will be automatically used.",null,"Columns L to O document the worksheets that have been successfully used to load profiles into the Data worksheet."]
[null,"     If \"All datasets, if confirmed\" is active, then you will be asked whether a \"new-to-the-current-data\" locus should be used.",null,"  Rows: The number of rows(i.e., new samples) added from the given dataset."]
[null,"Check Data: Insures that all profiles on worksheet Data are in standard format and have a unique identifying code.  Shortcut: <Ctrl-C>",null,"  Date Loaded: the datetime when the dataset was added."]
[null,"    It also identifies samples that have the same profile and creates a composite identifying code for the unique profile.",null,"  Worksheet: the worksheet from which the dataset was loaded."]
[null,"Best Match: Generates the three Best Match reports (see below).",null,"  Directory: the directory holding the worksheet from which the dataset was loaded."]
[null,"    Depending on the setting of the radio buttons to the immediate right of the Best Match Command Button,",null,"  #Loci: the number of loci specified in the dataset."]
[null,"     the three Best Match reports match all of the \"UnMatched\" (I.e., those that were not found to be \"Exact Matches\")",null,"  Loci...: the names of all the loci in the dataset."]
[null,"     either to all profiles or just to the other \"Unmatched\" profiles."]
[null,"Exit: Gracefully exits the STR_MatchSamples system."]
[]
[]
[null,"Ill-defined Alleles / Genotypes and How to Correct Them"]
[null,"To validly compare profiles, all profiles should be as complete as possible and every non-missing genotype unambiguously specified.  While \"OL\" is accepted as the code for an off-ladder allele, an \"OL\" allele in one system may be a \">x\" in another.  It is up to you to resolve such differences."]
[null,"If you were paying attention in STR_ConvertFormats, you corrected all ill-defined designations before you stored the converted profiles.  However, do not despair: ambiguities can be resolved without leaving this system. "]
[]
[null,"STR_MatchSamples regards any allele that contains any non-numeric character other than \"L\", \"O\", \"X\", \"Y\" or \"?\" to be ill-defined.  The most common ill-defined designations are off-ladder designations such as \"<\" or \">\" and hybrid designations from FSSi-format"]
[null,"data when the \"Designation\" alleles and the i-STRess genotype did not exactly agree (hybrid designations list all the possible alleles separated by the four characters \" or \".)  When Check Data encounteres anything it doesn't recognize, it (1) paints the cell's background",null,null,null,null,null,null,null,null,null,null,null,"yellow,"]
[null,"(2) selects the cell, (3) complains about it to you and (4) stops.  The background of possibly modified desigtnations is painted blue and you are asked to resolve the issue; the background of \"OL\" (off-ladder) alleles is painted green and you will notified of their presence."]
[]
[null,"If you know that there are only a very few ill-defined data, your best choice is probably to (1) edit the contents of the selected cell (or just enter the correct value), (2) activate the ControlPanel worksheet and (3) re-click Check Data.  Repeat until the complaints stop."]
[null,"The shortcut key <Ctrl-C> (that is, the combination of the Control, Shift key and C keys) allows you to skip step (2). "]
[]
[null,"When there are many ill-defined data of similar kind then it may well be more efficient to use Excel's Replace… function; this function is in the Edit menu and can be invoked with the <Ctrl-h> shortcut."]
[null,"With this you can replace multiple occurances of a given string of characters throughout a selected range of cells or, if only one cell is selected or the entire sheet is selected, thoughout the entire worksheet."]
[null,"If you are very confident, you can use Replace…'s Replace All command to do everthing all-at-obce but its safer to step through one-at-a-time using its Replace command.  Typical use would be replacement of the hybrid construct \"0 or \" with a null (nothing in the box) or space (\" \")."]
[null,"After you correct everything that you know needs correcting, activate the ControlPanel and re-click Check Data (or <Ctrl-C>).  Repeat until the complaints stop.  Or you become completely frustrated, whichever comes first."]
[]
[null,"Of course, figuring out what the correct alleles / genotypes should be may be a bit of a puzzle… that's why you shoulda done it in STR_ConvertFormats when you had the pre-converted data to look at.  When in doubt, replace ill-defined alleles with the \"?\" missing data flag."]
[]
[]
[null,"The Data Worksheet"]
[null,"The Data worksheet contains all of the loaded data.  It has three structural elements:",null,null,"A","B","C","D","E","F","…"]
[null,"    Title (cell A1): this lists all of the worksheets loaded via Add Data.",null,1,"[TEST_012006.xls]FSSI"]
[null,"    SampleCode (columns A and B): the \"Type\" and \"Description\" of the unique profiles.",null,2]
[null,"        The initial sample \"Description\" is a combination of the SampleCode as listed in the originating worksheet and",null,3,"SampleCode",null,null,"Loci"]
[null,"            that worksheet's name, separated by a \":\".  A unique identity code is assigned to all samples from the same",null,4,"Type","Description",null,"D8S1179","D21S11","D7S820"]
[null,"            worksheet with different profiles but identical names. ",null,5,"Unmatched","AF01C:FSSI",null,13,"?","?"]
[null,"        There are three possible \"Types\": ExactMatch, Unmatched and Unmatch (able?).",null,6,"Unmatched","AF02C:FSSI",null,"11,13","28,29","8,9"]
[null,"            All samples start as \"Unmatched\".   If the first part of the \"Description\" (that is, the SampleCode) is not shared by",null,"…"]
[null,"                at least one other unique profile, the sample will be given the Type \"Unmatched (able)?\""]
[null,"            If two or more samples share a profile, they will be replaced by a single, unique profile with a \"Description\" that is a"]
[null,"                composite of all the initial \"Descriptions\" and the Type will be \"ExactMatch\"."]
[null,"    Loci (columns D to ?): the alleles present at each locus in compact, comma-separated format."]
[]
[null,"Note: if you are attempting to find the \"exact match\" profiles for two or more evaluations of the same set of samples,"]
[null,"this Data worksheet report may be all you need.  It will find exactly matching profiles and SampleCodes and will clearly"]
[null,"identify samples that exactly match neither profile nor SampleCode."]
[]
[]
[null,"The RepDetail Worksheet"]
[null,"The RepDetail worksheet reports the 10 Best Match profiles to all or every Unmatched sample.",null,null,"A","B","C","D","E","…"]
[null,null,null,1,"Details of 'Best Match' of Unmatcheds to other Unmatched samples"]
[null,"The Title (cell A1) is the only \"global\" element.  The remainder of the report consists of individual sample matches,",null,2]
[null,"    formatted in groups of three.  The format elements for each sample are:",null,3,"Sample From","Sample To","%Allele","%Loci:1+",null,"Sample From"]
[null,"    Sample From (first column of each repeat): the \"Description\" of the sample being matched.  The number of unique,",null,4,"AF01C:FSSI","C25B:FSSI",57.142857142857146,62.5,null,"AF02C:FSSI"]
[null,"        fully specified alleles in the profile is also listed (\"# Alleles\") as is the number of loci with at least one fully",null,5,"#Alleles: 21","C05C:FSSI",52.38095238095238,62.5,null,"#Alleles: 24"]
[null,"        specified allele (\"#Loci\").",null,6,"#Loci: 16","C11C:FSSI",52.38095238095238,62.5,null,"#Loci: 16"]
[null,"    Sample To (second column of each repeat): the \"Description\" of the matched sample.",null,7,null,"C15C:FSSI",52.38095238095238,62.5]
[null,"    %Allele (third column of each repeat): the percent of alleles in common between the \"From\" and \"To\" samples.",null,8,null,"C17C:FSSI",52.38095238095238,62.5]
[null,"    %Loci:1+ (fourth column of each repeat): the percent of loci common to both samples that share at least one",null,9,null,"C01C:FSSI",47.61904761904762,62.5]
[null,"        fully specified allele.",null,10,null,"AF97B:FSSI",52.38095238095238,56.25]
[null,null,null,11,null,"C97B:FSSI",52.38095238095238,56.25]
[null,"The ten matched samples are sorted in order of decreasing %Loci:1+, then by %Allele.  ",null,12,null,"AF11C:FSSI",47.61904761904762,56.25]
[null,"Ambiguous or undetermined samples (those represented as \"?\" in the profile) are ignored in this analysis.",null,13,null,"C07C:FSSI",47.61904761904762,56.25]
[null,null,null,14]
[null,"This report may be of some use when evaluating profiles from related individuals.  However, it's primary utility is as the",null,15,"AF04C:FSSI","C04C:FSSI",68.965517241379317,100,null,"AF05C:FSSI"]
[null,"source of data for the following two reports.",null,"…"]
[]
[]
[null,"The RepSummary Worksheet"]
[null,"The RepSummary worksheet reports the best two Best Match profiles to all or every Unmatched sample,",null,null,"A","B","C","D","E","F","G","H","I","J","K"]
[null,null,null,1,"Summary of Two 'Best Match'es to other Unmatched samples"]
[null,"The Title (cell A1) is the only \"global\" element.  The remainder of the report consists of individual sample matches,",null,2]
[null,"    one sample per row.  The format elements for each sample are:",null,3,"Sample","#Alleles","#Loci",null,"Best Match","%Allele","%Loci:1+",null,"Next Best","%Allele","%Loci:1+"]
[null,"    Sample From (Column A): the \"Description\" of the sample being matched.",null,4,"C11C:FSSI",28,16,null,"AF11C:FSSI",75,100,null,"AF12C:FSSI",53.571428571428569,81.25]
[null,"    # Alleles (column B) is the number of fully specified alleles in the profile.",null,5,"AF07C:FSSI",27,16,null,"C07C:FSSI",70.370370370370367,100,null,"AF82B:FSSI",55.555555555555557,81.25]
[null,"    # Loci (column C) is the number of loci with at least one fully specified allele.",null,6,"C12C:FSSI",27,16,null,"AF12C:FSSI",70.370370370370367,100,null,"AF20C:FSSI",59.25925925925926,87.5]
[null,"    Best Match To (column E): the \"Description\" of the best Best Match sample.",null,7,"AF11C:FSSI",30,16,null,"C11C:FSSI",70,100,null,"C16C:FSSI",53.333333333333336,81.25]
[null,"    %Allele (column F): the percent of alleles in common between the two samples.",null,8,"AF03C:FSSI",26,16,null,"C03C:FSSI",69.230769230769226,100,null,"C09C:FSSI",50,68.75]
[null,"    %Loci:1+ (column G): the percent of loci common to both samples that share at least one fully specified allele.",null,"…"]
[null,"    Next Best Match To (column I): the \"Description\" of the next-to-the-best Best Match sample."]
[null,"    %Allele (column J): the percent of alleles in common between the two samples."]
[null,"    %Loci:1+ (column K): the percent of loci common to both samples that share at least one fully specified allele."]
[]
[]
[null,"The RepProfile Worksheet"]
[null,"The RepProfile worksheet provides a detailed analysis of the differences between every Unmatched sample and its Best Match.",null,null,"A","B","C","D","E","F","G","H","I","J","K"]
[null,null,null,1,"Profiles for Unmatched and its 'Best Match' to other Unmatched samples"]
[null,"The Title (cell A1) is the only \"global\" element.  The remainder of the report consists of pairs of profiles that are",null,2]
[null,"    each other's Best Match.  A blank line separates each sample pair.  The format elements for each pair are:",null,3,null,null,null,"Loci"]
[null,"    Type (Column A): the \"Type\" of the samples (see Data, above).",null,4,"Type","Description",null,"D8S1179","D21S11","D7S820","CSF1PO","D3S1358","TH01","D13S317","D16S539"]
[null,"    Description (Column A): the \"Description\" of the samples (see Data, above).",null,5,"UnMatched (able?)","AF01C:FSSI",null,13,"?","?","?","16,17","6,9",11,11]
[null,"    Loci (columns D on) contain the compact-format profiles of the paired samples.",null,6,"UnMatched (able?)","C25B:FSSI",null,"13,16","30.2,32",10,"?","15,17","6,9",12,"9,10"]
[null,"        The profiles are color-coded according to how well they match.",null,7]
[null,"            a) Loci with exactly the same, fully-specified alleles,",null,8,"UnMatched (able?)","AF02C:FSSI",null,"11,13","28,29","8,9",11,"14,15",9.3000000000000007,11,"9,12"]
[null,"            b) Loci with ill-defined alleles,",null,9,"UnMatched (able?)","C02C:FSSI",null,"11,13","29,31.2","9,12",11,"15,18",9.3000000000000007,"10,11","10,12"]
[null,"            c) Loci with fully-specified alleles and that share at least one allele but not all alleles and",null,"…"]
[null,"            d) Loci with fully-specified alleles but that share no allele."]
[]
[]
[null,"Want to change the color codes used in the RepProfile worksheet?"]
[]
[null,"Just select each of the above profile description cells, row 116 column 2 to row 119 column 2 (I.e, the ones starting with \"a)\" to \"d)\") and use the Fill Color tool to set the background color to your desire."]
[null,"Alternatively, after selecting the desired cell use the formatting tool on the Patterns tab of the Cells… command under the Format menu - or right-click and use the tool on the Patterns tab of the Format Cells command."]
[null,"After you have modified one or more of the cells, click the Change Colors button.  The chosen colors will be applied to the example (to the right of the description cells) so that you may review your choices."]
[null,"If you don't like the effect, change the colors and click the Change Colors button once again.  Stop when you are happy with the colors."]
[]
[null,"The Other Worksheets"]
[null,"The ControlPanel provides access to the various command, displays the current status of the analysis and lists the profile worksheets that have been loaded."]
[null,"   "]
[null,"The Introduction and ReadMe worksheets provide some guidance into the use of this system (but you obviously already have already figured that out...)"]
[]
[null,"There are also three normally hidden worksheets: Macro which holds the Excel Macro code which does the analyses, Work which is used for a number of transient calculations and DateTime which is used to set the date and time display formats."]
[null,"The first column of Work also lists the alphanumeric characters that can be present in a \"valid\" allele specification.  If you want/need to view any of these worksheets, you can 'unhide' them using Format > Sheet > Unhide > sheetname."]

{"sheet":"MS_Macro","index":7,"n_rows":400,"n_cols":34,"rows_kept":400,"cut":false,"hidden":false,"merged":[]}
["AutoCall_Globals","Parameter","Value","AutoCall_Exit","AutoCall_StartUp","SMS_Cancel","SMS_ChangeColors","SMS_CheckCutoffs","SMS_CheckData","SMS_Clear","SMS_Control","SMS_DataAdd","SMS_DataUpdate","SMS_GetData","SMS_GetWorksheet","SMS_Print","SMS_Print1","SMS_Print2","SMS_Print3","SMS_ReadMe1","SMS_ReadMe2","SMS_Report","SMS_RepDetail","SMS_RepSummary","SMS_RepProfile","Utility_DateTimeDependencies","Utility_CleanUpNames","Atmp1","Utility_ReVersion","Utility_ShowMacro","Utility_AlignControls","Utility_Colors",1,1]
["! In the normal course of events, this is ONLY run by the Auto_Open VBA Macro","R1C1 mode",true,"! Restore baseline system just prior to quiting","! Set all the constants","! Take care of User interruptions","! Allow user to change the RepProfile color code","! Allow user to change the RepDetail Cutoffs","! Check the structure and all of the profiles","! Clear the decks","! Take user to the Control worksheet","! Get the first dataset","! Get current Counts","! Get the names and alleles for the samples from this worksheet","! Get the data from one worksheet","! Print active sheet","! Print Rep1","! Print Rep1","! Print Rep1","! Take a new user to the ReadMe worksheet","! Take user to the ReadMe worksheet, no nonsence","! Generate the reports","! The detailed report","The summary report","The profile report","! Check the DateTime format setting","! Get rid of all the transcients","Atmp2","! Reset Page Headers of visible files","! Unide all hidden sheets","! Make sure the buttons are in the right spot","! List the colors",2,2]
["! If you diddle any of the constants, make sure you re-run it yourself before you evaluate the diddle","Calculation mode",1,{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&T$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&U$1,FALSE)","v":0},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&Z$1,FALSE)","v":0},null,"Atmp3",{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&AC$1,FALSE)","v":false},{"$f":"ACTIVATE(S0mac)","v":true},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&AE$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&AF$1,TRUE)","v":false},3,3]
[{"$f":"SET.NAME(\"Asyst\",\"STR_MatchSamples\")","v":true},"Start datetime","2017-10-10T10:37:23",{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&D$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&E$1,FALSE)","v":0},{"$f":"DLD_setcolwidth(Ched1col,Ched1col+3,TRUE)","v":false},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&G$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&H$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&J$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&K$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&L$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&M$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&N$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&O$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&P$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&Q$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&R$1,FALSE)","v":false},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&S$1,FALSE)","v":false},{"$f":"ACTIVATE(S0int)","v":true},{"$f":"ACTIVATE(S0rme)","v":true},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&V$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&W$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&X$1,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&Y$1,FALSE)","v":0},null,{"$f":"SET.NAME(\"Atmp1\",COUNTA(NAMES()))","v":true},"AutoCall_Exit",null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&AD$1,FALSE)","v":0},null,null,4,4]
[{"$f":"SET.NAME(\"Avers\",\"22-Apr-2016\")","v":true},"Stop datetime","00:00:06",null,null,{"$f":"DLD_gotocell_RC(1,1,1,1,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DLD_gotocell_RC(1,1,1,1,TRUE)","v":0},null,{"$f":"CANCEL.KEY(TRUE,SMS_Cancel)","v":true},{"$f":"CANCEL.KEY(TRUE,SMS_Cancel)","v":true},{"$f":"CANCEL.KEY(TRUE,SMS_Cancel)","v":true},null,{"$f":"FOR(\"Atmp2\",Atmp1,1,-1)","v":true},"AutoCall_Globals",{"$f":"RUN(AutoCall_Globals,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"RUN(AutoCall_Globals,FALSE)","v":{"$error":"#N/A"}},{"$f":"ACTIVATE(S0mac)","v":true},5,5]
[{"$f":"MESSAGE(FALSE)","v":true},"User","Duewer, David L. Dr.","! Restore calculation and RC states","! Check that the language dependencies are set",{"$f":"ALERT(\"You have interrupted \"&Asyst&\".\"&Achr&\"The message line lists the system's current status.\"&Achr&Achr&\"Go do what you need to do and try again.\",2)","v":true},"! Ensure ReadMe is active","! Get Cutoffs","! Tell user","! Clear the Data worksheet",{"$f":"DLD_gotocell_RC(1,1,6,1,TRUE)","v":0},"! Are data already loaded?",{"$f":"SET.NAME(\"Itmp\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&2,FALSE))-1)","v":true},"! Loop over the samples","! Find the new  file","! Check if it is ready",{"$f":"SET.NAME(\"Irow\",4)","v":true},{"$f":"SET.NAME(\"Irow\",5)","v":true},{"$f":"SET.NAME(\"Irow\",6)","v":true},"! Make sure Intro is in right format",null,"! Have the data been checked?",null,null,null,"! Make sure that the chart isn't active",{"$f":"  SET.NAME(\"Atmp3\",INDEX(NAMES(),Atmp2))","v":true},"AutoCall_StartUp",null,"! Unhide",null,{"$f":"FOR(\"Itmp\",1,56,1)","v":true},6,6]
[{"$f":"ECHO(FALSE)","v":true},"Number invocations",4,{"$f":"SET.NAME(\"Atmp1\",DEREF(INDIRECT(\"'\"&S0mac&\"'!\"&Arow&2&Acol&3,FALSE)))","v":true},{"$f":"SET.NAME(\"NumNew\",0)","v":true},null,{"$f":"SET.NAME(\"ClrRow\",107)","v":true},{"$f":"SET.NAME(\"LkepMax\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx1row&Acol&2,FALSE)))","v":true},{"$f":"FORMULA(\"Checking...\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&3&Acol&Ched1col,FALSE))","v":true},{"$f":"ACTIVATE(S0dat)","v":true},null,{"$f":"SET.NAME(\"NsamOld\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&1,FALSE))-3)","v":true},{"$f":"FORMULA(MAX(0,Itmp),INDIRECT(\"'\"&S0con&\"'!\"&Arow&3&Acol&Ched2col+1,FALSE))","v":true},{"$f":"SET.NAME(\"Asht\",MID(S1dat,FIND(\"]\",S1dat)+1,100))","v":true},{"$f":"SET.NAME(\"Nloc\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4,FALSE))-2)","v":true},{"$f":"SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Irow&Acol&4,FALSE)))","v":true},{"$f":"SET.NAME(\"Igoto\",Cbut5row)","v":true},{"$f":"SET.NAME(\"Igoto\",Cbut6row)","v":true},{"$f":"SET.NAME(\"Igoto\",Cbut7row)","v":true},{"$f":"DLD_gotocell_RC(1,1,27,4,FALSE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&U$1&\" > Finished!\",TRUE)","v":0},{"$f":"SET.NAME(\"Atmp\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&3&Acol&Ched1col,FALSE))","v":true},"! Update Control Pannel","! Update Control Pannel","! Update Control Pannel",{"$f":"ACTIVATE(S0dti)","v":true},{"$f":"  IF(ISERROR(MATCH(Atmp3,AB:AB,0)),DELETE.NAME(Atmp3))","v":true},"SMS_Cancel",{"$f":"SET.NAME(\"Atmp\",\"A System for Matching Samples Across Excel Worksheets by Their STR Profiles\")","v":true},{"$f":"ERROR(FALSE)","v":true},"! Reset the User info",{"$f":"  FORMULA(Itmp,INDIRECT(\"'\"&S0mac&\"'!R\"&Itmp&\"C[1]\",FALSE))","v":true},7,7]
[null,null,null,{"$f":"IF(ISERROR(Atmp1),SET.NAME(\"Atmp1\",TRUE))","v":false},{"$f":"RUN(Utility_DateTimeDependencies,FALSE)","v":{"$error":"#N/A"}},{"$f":"HALT()","v":true},{"$f":"ACTIVATE(S0rme)","v":true},{"$f":"IF(NOT(ISLOGICAL(LkepMax)),SET.NAME(\"LkepMax\",TRUE))","v":false},{"$f":"DLD_setcolwidth(Ched1col,Ched1col+1,TRUE)","v":0},{"$f":"SET.NAME(\"Atitle\",\"\")","v":true},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&K$1&\" > Finished!\",TRUE)","v":0},{"$f":"IF(NsamOld<1.5)","v":true},{"$f":"SET.NAME(\"Itmp\",COUNTIF(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&1,FALSE),\"=ExactMatch\"))","v":true},{"$f":"SET.NAME(\"Nsam\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&2,FALSE))-1)","v":true},{"$f":"SET.NAME(\"Afile\",OPEN.DIALOG(,,\"Please select the desired file.\"))","v":true},{"$f":"IF(Atmp<>\"Finished\")","v":true},{"$f":"SET.NAME(\"S0rep\",S0rp1)","v":true},{"$f":"SET.NAME(\"S0rep\",S0rp2)","v":true},{"$f":"SET.NAME(\"S0rep\",S0rp3)","v":true},null,{"$f":"RETURN()","v":true},{"$f":"IF(NOT(Atmp=\"Checked\"))","v":true},{"$f":"FORMULA(\"Processing\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&4&Acol&Ched1col,FALSE))","v":true},{"$f":"FORMULA(\"Processing\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&5&Acol&Ched1col,FALSE))","v":true},{"$f":"FORMULA(\"Processing\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&6&Acol&Ched1col,FALSE))","v":true},{"$f":"ERROR(FALSE)","v":true},{"$f":"NEXT()","v":true},"SMS_ChangeColors",null,{"$f":"  WORKBOOK.UNHIDE(MID(S0dti,FIND(\"]\",S0dti)+1,100))","v":true},{"$f":"ACTIVATE(S0mac)","v":true},{"$f":"  SELECT(INDIRECT(\"'\"&S0mac&\"'!R\"&Itmp&\"C[1]\",FALSE))","v":true},8,8]
["! Make sheetnames",null,null,{"$f":"A1.R1C1(NOT(Atmp1))","v":true},null,null,{"$f":"DLD_gotocell_RC(1,1,ClrRow-1,1,FALSE)","v":0},{"$f":"SET.NAME(\"LkepMin\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx2row&Acol&2,FALSE)))","v":true},{"$f":"DLD_gotocell_RC(1,1,Cbut3row,1,TRUE)","v":0},{"$f":"dld_Selectcols(1,-1,FALSE)","v":0},{"$f":"RETURN()","v":true},null,{"$f":"FORMULA(Itmp,INDIRECT(\"'\"&S0con&\"'!\"&Arow&4&Acol&Ched2col+1,FALSE))","v":true},{"$f":"ACTIVATE(S0dat)","v":true},{"$f":"IF(ISERROR(Afile),SET.NAME(\"Afile\",FALSE))","v":false},{"$f":"  SET.NAME(\"Atmp1\",MID(S0rep,FIND(\"]\",S0rep)+1,100))","v":true},null,null,null,"! Go to ReadMe",null,{"$f":"  ACTIVATE(S0con)","v":true},{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&4&Acol&Ched1col+1,FALSE))","v":true},{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&5&Acol&Ched1col+1,FALSE))","v":true},{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&6&Acol&Ched1col+1,FALSE))","v":true},{"$f":"  WORKBOOK.UNHIDE(\"DateTime\")","v":true},null,"SMS_CheckCutoffs","! Reset Readme",{"$f":"  WORKBOOK.UNHIDE(MID(S0mac,FIND(\"]\",S0mac)+1,100))","v":{"$error":"#VALUE!"}},{"$f":"ERROR(FALSE)","v":true},{"$f":"  PATTERNS(1,1,Itmp,TRUE)","v":true},9,9]
[{"$f":"SET.NAME(\"Drctry0\",GET.DOCUMENT(2))","v":true},null,null,{"$f":"SET.NAME(\"Atmp2\",DEREF(INDIRECT(\"'\"&S0mac&\"'!\"&Arow&3&Acol&3,FALSE)))","v":true},"! Get the RepProfile color codes",null,null,{"$f":"IF(NOT(ISLOGICAL(LkepMin)),SET.NAME(\"LkepMin\",FALSE))","v":false},null,{"$f":"EDIT.DELETE()","v":true},null,"! Clear everything",{"$f":"SET.NAME(\"Jtmp\",COUNTIF(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&1,FALSE),\"=Unmatched (able?)\"))","v":true},{"$f":"FOR(\"Irow\",RowHed+1,RowLst,1)","v":true},{"$f":"IF(Afile=FALSE)","v":true},{"$f":"  ACTIVATE(S0con)","v":true},{"$f":"RUN(SMS_Print,FALSE)","v":{"$error":"#N/A"}},{"$f":"RUN(SMS_Print,FALSE)","v":{"$error":"#N/A"}},{"$f":"RUN(SMS_Print,FALSE)","v":{"$error":"#N/A"}},{"$f":"ACTIVATE(S0rme)","v":true},null,{"$f":"  DLD_gotocell_RC(1,1,Cbut3row,1,TRUE)","v":false},{"$f":"DLD_setcolwidth(Ched1col,Ched1col+1,TRUE)","v":0},{"$f":"DLD_setcolwidth(Ched1col,Ched1col+1,TRUE)","v":0},{"$f":"DLD_setcolwidth(Ched1col,Ched1col+1,TRUE)","v":0},{"$f":"  SET.NAME(\"Itmp\",FORMULA.GOTO(Arow&1&Acol&1,TRUE))","v":true},{"$f":"RUN(AutoCall_Globals,FALSE)","v":{"$error":"#N/A"}},"SMS_CheckData",{"$f":"ACTIVATE(S0rme)","v":true},{"$f":"  WORKBOOK.UNHIDE(MID(S0wrk,FIND(\"]\",S0wrk)+1,100))","v":{"$error":"#VALUE!"}},{"$f":"  WORKBOOK.UNHIDE(\"MS_Macro\")","v":{"$error":"#VALUE!"}},{"$f":"  SET.NAME(\"Jtmp\",GET.CELL(63,INDIRECT(\"'\"&S0mac&\"'!R\"&Itmp&\"C[1]\",FALSE)))","v":true},10,10]
[{"$f":"SET.NAME(\"WrkBk0\",GET.DOCUMENT(88))","v":true},null,null,{"$f":"IF(ISERROR(Atmp2),SET.NAME(\"Atmp2\",3))","v":false},{"$f":"RUN(SMS_ChangeColors,FALSE)","v":{"$error":"#N/A"}},null,"! Get the four color codes",{"$f":"IF(NOT(OR(LkepMax,LkepMin)),SET.NAME(\"LkepMax\",TRUE))","v":false},"! Initialize data display",{"$f":"DLD_setcolwidth(1,-1,TRUE)","v":0},null,{"$f":"  RUN(SMS_Clear,FALSE)","v":{"$error":"#N/A"}},{"$f":"FORMULA(Jtmp,INDIRECT(\"'\"&S0con&\"'!\"&Arow&6&Acol&Ched2col+1,FALSE))","v":true},{"$f":"  SET.NAME(\"Atmp2\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow,FALSE)))","v":true},{"$f":"  ACTIVATE(S0con)","v":true},{"$f":"  DLD_gotocell_RC(1,1,Cbut1row,1,TRUE)","v":false},null,null,null,{"$f":"DLD_gotocell_RC(1,1,1,1,TRUE)","v":0},null,{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&V$1&\" > You must first 'Check' the data.\",TRUE)","v":false},{"$f":"DLD_gotocell_RC(1,1,Cbut4row,1,FALSE)","v":0},{"$f":"DLD_gotocell_RC(1,1,Cbut4row,1,FALSE)","v":0},{"$f":"DLD_gotocell_RC(1,1,Cbut4row,1,FALSE)","v":0},{"$f":"  IF(ISERROR(Itmp))","v":true},null,"SMS_Clear",{"$f":"PAGE.SETUP(\"&L&\"\"Arial,Regular\"\"&8Built by: DL Duewer, NIST&C&\"\"Arial,Bold\"\"&16\"&Asyst&\" &\"\"Arial,Regular\"\"&12<\"&Avers&\">\n\"&Atmp&\"&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.25,1.1,0.5,FALSE,FALSE,TRUE,FALSE,2,1,{1,#N/A},\"Auto\",1,FALSE,,0.7,0.3,FALSE,FALSE)","v":true},{"$f":"ERROR(TRUE)","v":true},{"$f":"ERROR(TRUE)","v":true},{"$f":"  FORMULA(Jtmp,INDIRECT(\"'\"&S0mac&\"'!R\"&Itmp&\"C[2]\",FALSE))","v":true},11,11]
[{"$f":"SET.NAME(\"S0con\",\"[\"&WrkBk0&\"]ControlPanel\")","v":true},null,null,{"$f":"OPTIONS.CALCULATION(Atmp2)","v":true},{"$f":"ACTIVATE(S0con)","v":true},null,{"$f":"SET.NAME(\"ClrCde1\",GET.CELL(63,INDIRECT(\"'\"&S0rme&\"'!\"&Arow&ClrRow+9&Acol&2,FALSE)))","v":true},{"$f":"FORMULA(LkepMax,INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx1row&Acol&2,FALSE))","v":true},{"$f":"ACTIVATE(S0dat)","v":true},null,null,{"$f":"  DLD_GotoCell(1,1,Cbut2row,1,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"SET.NAME(\"Itmp\",COUNTIF(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&1,FALSE),\"=Unmatched\"))","v":true},{"$f":"  IF(Atmp2>0.5)","v":true},{"$f":"  DLD_gotocell_RC(1,1,IF(Nloc<1.5,Cbut2row,Cbut3row),1,TRUE)","v":false},{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&P$1&\" > Error… The report sheet (\"&Atmp1&\") has not been Finished!\",TRUE)","v":false},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&Q$1&\" > Finished!\",TRUE)","v":0},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&R$1&\" > Finished!\",TRUE)","v":false},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&S$1&\" > Finished!\",TRUE)","v":false},{"$f":"ALERT(\"This worksheet is the 'Instruction Manual' for this system.\"&Achr&Achr&\"Click 'OK', survey the information, then go to the ControlPanel and get started.\"&Achr&\"When you encounter hassles, return here and read the relevant bits more thoroughly.\",2)","v":true},null,{"$f":"  ALERT(\"You must first 'Check' the data.\"&Achr&Achr&\"Please click the button, fix any problems, and try again.\",2)","v":true},null,null,null,{"$f":"  HIDE()","v":true},{"$f":"RUN(AutoCall_StartUp,FALSE)","v":{"$error":"#N/A"}},"SMS_Control",{"$f":"DLD_gotocell_RC(1,1,1,1,TRUE)","v":false},null,{"$f":"FORMULA(\"NewUser\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&6&Acol&3,FALSE))","v":true},{"$f":"NEXT()","v":true},12,12]
[{"$f":"SET.NAME(\"S0dat\",\"[\"&WrkBk0&\"]Data\")","v":true},null,null,{"$f":"OPTIONS.VIEW(TRUE,TRUE)","v":true},{"$f":"DLD_gotocell_RC(1,1,Cbut1row,1,TRUE)","v":0},null,{"$f":"IF(ISERROR(ClrCde1*1),SET.NAME(\"ClrCde1\",0))","v":false},{"$f":"FORMULA(LkepMin,INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx2row&Acol&2,FALSE))","v":true},{"$f":"DLD_clearrange(5,1,-1,1,FALSE)","v":0},"! Clear the worksheet",null,null,{"$f":"FORMULA(Itmp+Jtmp,INDIRECT(\"'\"&S0con&\"'!\"&Arow&5&Acol&Ched2col+1,FALSE))","v":true},{"$f":"    SET.NAME(\"Nsam\",Nsam+1)","v":true},{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&O$1&\" > Browsing aborted by user.\",TRUE)","v":false},{"$f":"  ALERT(\"The report (\"&Atmp1&\") has not been generated.\"&Achr&Achr&\"Please define the data and matchs and try again.\",2)","v":true},{"$f":"RETURN()","v":true},{"$f":"RETURN()","v":true},{"$f":"RETURN()","v":true},null,null,{"$f":"  HALT()","v":true},"! Make report","! Make summary report","! Make summary report",{"$f":"END.IF()","v":true},null,"SMS_DataAdd",null,"! format",{"$f":"FORMULA(0,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&\"7C3\",FALSE))","v":true},{"$f":"SELECT(\"C:C[1]\")","v":true},13,13]
[{"$f":"SET.NAME(\"S0dti\",\"[\"&WrkBk0&\"]DateTime\")","v":true},null,null,{"$f":"SET.NAME(\"Atmp1\",NOW())","v":true},null,null,{"$f":"IF(OR(ClrCde1<-0.5,ClrCde1>56.5),SET.NAME(\"ClrCde1\",0))","v":false},null,{"$f":"DLD_Clearcols(256,-1,FALSE)","v":0},{"$f":"ACTIVATE(S0wrk)","v":true},null,"! Get the incoming data",null,{"$f":"    IF(MOD(Nsam,2)=1,MESSAGE(TRUE,TEXT(NOW(),AlngDatTim)&\" \"&N$1&\" > Processing \"&Irow-RowHed&\" / \"&RowLst-RowHed))","v":false},{"$f":"  ALERT(\"No data file was specified.\"&Achr&Achr&\"Please do whatever you need to do and try again.\",2)","v":true},{"$f":"  HALT()","v":true},null,null,null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&T$1&\" > Finished!\",TRUE)","v":0},null,{"$f":"END.IF()","v":false},{"$f":"SET.NAME(\"Icol0\",4)","v":true},{"$f":"SET.NAME(\"Nums\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&5&Acol&Ched2col+1,FALSE)))","v":true},{"$f":"SET.NAME(\"Icol0\",4)","v":true},{"$f":"ERROR(TRUE)","v":true},{"$f":"ACTIVATE(S0mac)","v":true},"SMS_DataUpdate","! Reset Introduction",{"$f":"ACTIVATE(S0mac)","v":true},{"$f":"DLD_gotocell_RC(1,1,1,1,TRUE)","v":0},{"$f":"COLUMN.WIDTH(5)","v":true},14,14]
[{"$f":"SET.NAME(\"S0int\",\"[\"&WrkBk0&\"]Introduction\")","v":true},null,null,{"$f":"FORMULA(Atmp1,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&5&Acol&3,FALSE))","v":true},"! Set the program identifiers",null,{"$f":"SELECT(\"(\"&Arow&ClrRow+9&Acol&2&Alsp&Arow&ClrRow+6&Acol&13&Asep&Arow&ClrRow+7&Acol&13&Alsp&Arow&ClrRow+9&Acol&8&Asep&Arow&ClrRow+10&Acol&8&Alsp&Arow&ClrRow+9&Acol&11&Asep&Arow&ClrRow+10&Acol&11&Alsp&Arow&ClrRow+9&Acol&13&Asep&Arow&ClrRow+10&Acol&13&\")\")","v":true},"! Check the maximum number",{"$f":"dld_Selectcols(1,-1,FALSE)","v":0},{"$f":"DLD_Clearcols(2,-1,FALSE)","v":0},null,{"$f":"  RUN(SMS_GetWorksheet,FALSE)","v":{"$error":"#N/A"}},"! Match to all or only to unmatched?",null,{"$f":"  HALT()","v":true},{"$f":"END.IF()","v":false},null,null,null,{"$f":"RETURN()","v":true},null,null,{"$f":"SET.NAME(\"Icol1\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4,FALSE))+1)","v":true},{"$f":"SET.NAME(\"Nlne\",MIN(Nlne0,Nums))","v":true},{"$f":"SET.NAME(\"Icol1\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4,FALSE))+1)","v":true},null,{"$f":"DLD_gotocell_RC(1,1,1,1,TRUE)","v":0},"SMS_GetData",{"$f":"ACTIVATE(S0int)","v":true},{"$f":"WINDOW.MAXIMIZE()","v":true},null,null,15,15]
[{"$f":"SET.NAME(\"S0mac\",\"[\"&WrkBk0&\"]MS_Macro\")","v":true},null,null,{"$f":"SET.NAME(\"Atmp2\",DEREF(INDIRECT(\"'\"&S0mac&\"'!\"&Arow&4&Acol&3,FALSE)))","v":true},{"$f":"SET.NAME(\"Aprog\",Asyst&\" <\"&TEXT(Adate,AlngDat)&\">\")","v":true},null,{"$f":"IF(ClrCde1<0.5,PATTERNS(0),PATTERNS(1,,ClrCde1,TRUE))","v":true},{"$f":"SET.NAME(\"NkepMax\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx1row&Acol&4,FALSE)))","v":true},{"$f":"PATTERNS(0)","v":true},{"$f":"DLD_setcolwidth(1,-1,TRUE)","v":0},null,null,{"$f":"SET.NAME(\"IsAll\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Cbut4row&Acol&1,FALSE)))","v":true},"! Name",{"$f":"END.IF()","v":false},null,null,null,null,null,null,"! Update the data counts",{"$f":"SET.NAME(\"Nloc\",Icol1-Icol0+1)","v":true},null,{"$f":"SET.NAME(\"Nloc\",Icol1-Icol0+1)","v":true},"! Get the current formats",{"$f":"HALT()","v":true},"SMS_GetWorksheet",{"$f":"FORMULA(\"Welcome to \"&Asyst&\"!\",INDIRECT(\"'\"&S0int&\"'!\"&Arow&1&Acol&3,FALSE))","v":true},{"$f":"OPTIONS.VIEW(TRUE,TRUE,FALSE,TRUE,1,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE)","v":true},"! Hide the trivial worksheets",{"$f":"FORMULA.GOTO(Arow&1&Acol&\"[-1]\",TRUE)","v":false},16,16]
[{"$f":"SET.NAME(\"S0rme\",\"[\"&WrkBk0&\"]ReadMe\")","v":true},"AlngDat","d-mmm-yy",{"$f":"SET.NAME(\"Atmp3\",24*(Atmp1-Atmp2))","v":true},null,null,null,{"$f":"IF(ISERROR(NkepMax),SET.NAME(\"NkepMax\",0))","v":false},{"$f":"DLD_setcolwidth(1,-1,TRUE)","v":0},null,null,"! Format the Controlpanel's worksheet list",{"$f":"IF(IsAll<>2,SET.NAME(\"IsAll\",1))","v":false},{"$f":"    FORMULA(\"Unmatched\",INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4+Nsam&Acol&1,FALSE))","v":true},null,"! Offer to print the specified sheet",null,null,null,null,null,{"$f":"RUN(SMS_DataUpdate,FALSE)","v":{"$error":"#N/A"}},{"$f":"SET.NAME(\"Nsam\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&3&Acol&Ched2col+1,FALSE)))","v":true},"! Format the header lines",{"$f":"SET.NAME(\"Nums\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&5&Acol&Ched2col+1,FALSE)))","v":true},{"$f":"SET.NAME(\"Atmp\",NOW())","v":true},null,"SMS_Print",{"$f":"FORMULA(\"Version <\"&Avers&\">\",INDIRECT(\"'\"&S0int&\"'!\"&Arow&2&Acol&3,FALSE))","v":true},{"$f":"FREEZE.PANES(FALSE)","v":true},{"$f":"ERROR(FALSE)","v":true},null,17,17]
[{"$f":"SET.NAME(\"S0wrk\",\"[\"&WrkBk0&\"]Work\")","v":true},"AlngTim","h:mm:ss",null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\"  Welcome to \"&Asyst&\"!\",TRUE)","v":0},null,{"$f":"SET.NAME(\"ClrCde2\",GET.CELL(63,INDIRECT(\"'\"&S0rme&\"'!\"&Arow&ClrRow+10&Acol&2,FALSE)))","v":true},{"$f":"IF(NkepMax<0.5,SET.NAME(\"NkepMax\",10))","v":false},{"$f":"FREEZE.PANES(FALSE)","v":true},"! Format the control panel",null,{"$f":"  ACTIVATE(S0con)","v":true},{"$f":"SET.NAME(\"Atmp\",IF(IsAll=1,Amat1_txt,Amat2_txt))","v":true},{"$f":"    SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow&Acol&ColHed,FALSE)))","v":true},"! Open the file",{"$f":"ACTIVATE(S0rep)","v":true},null,null,null,null,null,null,{"$f":"SET.NAME(\"Nexr\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&4&Acol&Ched2col+1,FALSE)))","v":true},{"$f":"ACTIVATE(S0rp2)","v":true},null,{"$f":"FOR(\"Irow\",2,4,1)","v":true},null,"SMS_Print1",{"$f":"PAGE.SETUP(\"&L&\"\"Arial,Regular\"\"&8Built by: DL Duewer, NIST&C&\"\"Arial,Bold\"\"&16\"&Asyst&\" &\"\"Arial,Regular\"\"&12<\"&Avers&\">\n\"&Atmp&\"&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.25,1.3,0.5,FALSE,FALSE,TRUE,FALSE,2,1,{1,#N/A},\"Auto\",1,FALSE,,0.7,0.3,FALSE,FALSE)","v":true},{"$f":"FREEZE.PANES(TRUE,0,1)","v":true},{"$f":"  WORKBOOK.UNHIDE(\"DateTime\")","v":{"$error":"#VALUE!"}},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&AF$1&\" > Finished!\",TRUE)","v":false},18,18]
[{"$f":"SET.NAME(\"S0rp1\",\"[\"&WrkBk0&\"]RepDetail\")","v":true},"AlngDatTim","d-mmm-yy h:mm:ss","! Restore screensize",{"$f":"RETURN()","v":true},null,{"$f":"IF(ISERROR(ClrCde2*1),SET.NAME(\"ClrCde2\",0))","v":false},{"$f":"FORMULA(NkepMax,INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx1row&Acol&4,FALSE))","v":true},{"$f":"FREEZE.PANES(TRUE,3,4)","v":true},{"$f":"ACTIVATE(S0con)","v":true},null,{"$f":"  dld_Selectcols(Ched3col+1,Ched3col+1,FALSE)","v":0},{"$f":"FOR(\"Itmp\",1,Nrepsht,1)","v":true},{"$f":"    FORMULA(Atmp&\":\"&Asht,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4+Nsam&Acol&2,FALSE))","v":true},{"$f":"ERROR(FALSE)","v":true},{"$f":"ECHO(TRUE)","v":true},null,null,null,null,null,"! Match to all or only to unmatched?",{"$f":"SET.NAME(\"Nums\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&5&Acol&Ched2col+1,FALSE)))","v":true},{"$f":"DLD_Clearcols(1,-1,FALSE)","v":0},"! Format the header lines",{"$f":"  FORMULA(Atmp,INDIRECT(\"'\"&S0dti&\"'!\"&Arow&Irow&Acol&2,FALSE))","v":true},null,"SMS_Print2",{"$f":"DLD_gotocell_RC(1,1,1,1,TRUE)","v":false},{"$f":"ZOOM(75)","v":true},{"$f":"  WORKBOOK.UNHIDE(\"Work\")","v":{"$error":"#VALUE!"}},{"$f":"HALT()","v":true},19,19]
[{"$f":"SET.NAME(\"S0rp2\",\"[\"&WrkBk0&\"]RepSummary\")","v":true},"Acol","C",{"$f":"FULL.SCREEN(FALSE)","v":true},null,null,{"$f":"IF(OR(ClrCde2<-0.5,ClrCde2>56.5),SET.NAME(\"ClrCde2\",0))","v":false},null,null,{"$f":"DLD_clearrange(1,Ched1col,10,-1,TRUE)","v":0},null,{"$f":"  FORMAT.NUMBER(AlngDatTim)","v":true},{"$f":"  SET.NAME(\"Arep\",EVALUATE(\"S0rp\"&Itmp&\"_txt\"))","v":true},null,{"$f":"  SET.NAME(\"Atmp1\",OPEN(Afile,0,FALSE,,,,,,,,1))","v":true},{"$f":"PRINT?(1,,,1,,,,,1,,,2)","v":false},null,null,null,null,null,{"$f":"SET.NAME(\"Nums\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&10,FALSE)))","v":true},{"$f":"IF(Nums<1.5)","v":true},null,{"$f":"ACTIVATE(S0rp3)","v":true},{"$f":"  SET.NAME(\"Atmp1\",GET.CELL(7,INDIRECT(\"'\"&S0dti&\"'!\"&Arow&Irow&Acol&2,FALSE)))","v":true},null,"SMS_Print3",null,null,{"$f":"ERROR(TRUE)","v":true},null,20,20]
[{"$f":"SET.NAME(\"S0rp3\",\"[\"&WrkBk0&\"]RepProfile\")","v":true},"Adcp",".",{"$f":"WINDOW.MAXIMIZE()","v":true},null,null,{"$f":"SELECT(\"(\"&Arow&ClrRow+10&Acol&2&Alsp&Arow&ClrRow+6&Acol&9&Asep&Arow&ClrRow+7&Acol&11&\")\")","v":true},"! Check the minimum %loci","! Get maxium rows&cols",{"$f":"FONT.PROPERTIES(\"Arial\",\"Regular\",10,,,,,,,1)","v":true},null,{"$f":"  ALIGNMENT(4,FALSE,3,0)","v":true},{"$f":"  FORMULA(Arep&Atmp,INDIRECT(\"'\"&S0con&\"'!\"&Arow&3+Itmp&Acol&Ched1col+3,FALSE))","v":true},"! Alleles",{"$f":"ERROR(TRUE)","v":true},{"$f":"ECHO(FALSE)","v":true},null,null,null,null,null,{"$f":"SET.NAME(\"IsAll\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Cbut4row&Acol&1,FALSE)))","v":true},{"$f":"  DLD_gotocell_RC(1,1,Cbut4row,1,TRUE)","v":false},{"$f":"FORMAT.NUMBER(\"0\")","v":true},{"$f":"DLD_Clearcols(1,-1,FALSE)","v":0},{"$f":"  IF(NOT(ISERROR(FIND(\";\",Atmp1))),SET.NAME(\"Atmp1\",LEFT(Atmp1,FIND(\";\",Atmp1)-1)))","v":false},null,"SMS_ReadMe1","! Reset ControlPanel",{"$f":"DLD_gotocell_RC(1,1,1,1,TRUE)","v":0},{"$f":"ACTIVATE(S0dti)","v":true},null,21,21]
[null,"Agnl","General",null,null,null,{"$f":"IF(ClrCde2<0.5,PATTERNS(0),PATTERNS(1,,ClrCde2,TRUE))","v":true},{"$f":"SET.NAME(\"PkepMin\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx2row&Acol&4,FALSE)))","v":true},{"$f":"SET.NAME(\"RowLst\",GET.DOCUMENT(10))","v":true},{"$f":"FORMAT.NUMBER(\"0\")","v":true},null,{"$f":"  FORMULA(\"Worksheets Loaded\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&1&Acol&Ched3col,FALSE))","v":true},{"$f":"NEXT()","v":true},{"$f":"    FOR(\"Iloc\",1,Nloc,1)","v":true},{"$f":"IF(Atmp1=FALSE)","v":true},null,null,null,null,null,null,{"$f":"IF(IsAll<>2,SET.NAME(\"IsAll\",1))","v":false},{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&W$1&\" > No unmatched samples!\",TRUE)","v":false},{"$f":"FONT.PROPERTIES(\"Arial\",\"Regular\",10,,,,,,,1)","v":true},null,{"$f":"  IF(NOT(ISERROR(FIND(\"]\",Atmp1))),SET.NAME(\"Atmp1\",MID(Atmp1,FIND(\"]\",Atmp1)+1,100)))","v":false},null,"SMS_ReadMe2",{"$f":"ACTIVATE(S0con)","v":true},null,{"$f":"WORKBOOK.HIDE()","v":true},null,22,22]
["! Set the display text for the Report worksheets","Alsp",",","! Exit nicely",null,null,null,{"$f":"IF(ISERROR(PkepMin),SET.NAME(\"PkepMin\",0))","v":false},{"$f":"SET.NAME(\"ColLst\",GET.DOCUMENT(12))","v":true},{"$f":"ALIGNMENT(3,FALSE,3,0)","v":true},null,{"$f":"  DLD_selectrange(1,Ched3col,1,Ched3col+3,FALSE)","v":0},null,{"$f":"      SET.NAME(\"Jcol\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&6,FALSE)))","v":true},{"$f":"  ACTIVATE(S0con)","v":true},"! Go back to the control panel",null,null,null,null,null,{"$f":"IF(AND(IsAll=2,Nums<0.5))","v":true},{"$f":"  ALERT(\"There are only \"&Nums&\" 'UnMatch' samples.\"&Achr&Achr&\"The \"&S0dat&\" worksheet may well provide all the interesting information.\"&Achr&\"If you do wish to Match the 'ExactMatch' samples, first re-run Check Data then and try Best Match again.\",2)","v":false},{"$f":"ALIGNMENT(4,FALSE,2)","v":true},{"$f":"FORMAT.NUMBER(\"0\")","v":true},{"$f":"  FORMULA(Atmp1,INDIRECT(\"'\"&S0dti&\"'!\"&Arow&Irow&Acol&3,FALSE))","v":true},null,"SMS_RepDetail",{"$f":"PAGE.SETUP(\"&L&\"\"Arial,Regular\"\"&8Built by: DL Duewer, NIST&C&\"\"Arial,Bold\"\"&16\"&Asyst&\" &\"\"Arial,Regular\"\"&12<\"&Avers&\">\n\"&Atmp&\"&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.25,1.3,0.5,FALSE,FALSE,FALSE,FALSE,2,1,{1,#N/A},\"Auto\",1,FALSE,,0.7,0.3,FALSE,FALSE)","v":true},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&AD$1&\" > Finished!\",TRUE)","v":0},{"$f":"ACTIVATE(S0wrk)","v":true},null,23,23]
[{"$f":"SET.NAME(\"Nrepsht\",3)","v":true},"Arow","R",{"$f":"ACTIVATE(S0con)","v":true},null,null,{"$f":"SET.NAME(\"ClrCde3\",GET.CELL(63,INDIRECT(\"'\"&S0rme&\"'!\"&Arow&ClrRow+11&Acol&2,FALSE)))","v":true},{"$f":"IF(OR(PkepMin<0.5,PkepMin>100),SET.NAME(\"PkepMin\",100))","v":false},{"$f":"IF(RowLst<5.5)","v":true},{"$f":"DLD_selectrange(2,Ched1col+1,10,Ched1col+1,FALSE)","v":0},null,{"$f":"  ALIGNMENT(7,FALSE,3,0)","v":true},"! Format",{"$f":"      IF(Jcol>0.5)","v":true},{"$f":"  DLD_gotocell_RC(1,1,IF(Nloc<1.5,Cbut2row,Cbut3row),1,TRUE)","v":false},{"$f":"ACTIVATE(S0con)","v":true},null,null,null,null,null,{"$f":"  ACTIVATE(S0con)","v":true},{"$f":"  HALT()","v":true},{"$f":"FREEZE.PANES(FALSE)","v":true},{"$f":"FONT.PROPERTIES(\"Arial\",\"Regular\",10,,,,,,,1)","v":true},{"$f":"  FORMULA(\"?\",INDIRECT(\"'\"&S0dti&\"'!\"&Arow&Irow&Acol&4,FALSE))","v":true},null,"SMS_Report",{"$f":"DLD_gotocell_RC(1,1,1,1,TRUE)","v":false},{"$f":"HALT()","v":true},{"$f":"WORKBOOK.HIDE()","v":true},null,24,24]
[{"$f":"SET.NAME(\"S0rp1_txt\",\"Details of 'Best Match' of Unmatcheds\")","v":true},"NumNew",0,{"$f":"DLD_gotocell_RC(1,1,Cbut8row,1,TRUE)","v":0},null,null,{"$f":"IF(ISERROR(ClrCde3*1),SET.NAME(\"ClrCde3\",0))","v":false},{"$f":"FORMULA(PkepMin,INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx2row&Acol&4,FALSE))","v":true},{"$f":"  DLD_gotocell_RC(1,1,1,1,TRUE)","v":false},{"$f":"FORMAT.NUMBER(AlngDatTim)","v":true},null,{"$f":"  FONT.PROPERTIES(\"Arial\",\"Regular\",10,,,,,,,1)","v":true},{"$f":"DLD_setcolwidth(Ched1col,-1,TRUE)","v":0},null,{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&O$1&\" > Workbook (\"&Afile&\") could not be opened.\",TRUE)","v":false},{"$f":"DLD_gotocell_RC(1,1,Igoto,1,TRUE)","v":0},null,null,null,null,null,{"$f":"  DLD_gotocell_RC(1,1,Cbut4row,1,TRUE)","v":false},{"$f":"END.IF()","v":false},{"$f":"FREEZE.PANES(TRUE,,3)","v":true},{"$f":"ALIGNMENT(4,FALSE,2)","v":true},{"$f":"NEXT()","v":true},null,"SMS_RepProfile",null,null,null,null,25,25]
[{"$f":"SET.NAME(\"S0rp2_txt\",\"Summary of Two 'Best Match'es\")","v":true},null,null,null,null,null,{"$f":"IF(OR(ClrCde3<-0.5,ClrCde3>56.5),SET.NAME(\"ClrCde3\",0))","v":false},null,{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Data error... must have at least two samples.\",TRUE)","v":false},{"$f":"ALIGNMENT(4,FALSE,3,0)","v":true},null,{"$f":"  FORMULA(\"Rows\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&Ched3col,FALSE))","v":true},null,"! Only transfer desired loci",{"$f":"  ALERT(\"Unexpected error... Workbook (\"&Afile&\") could not be opened.\"&Achr&Achr&\"Please contact david.duewer@nist.gov about this hassle.\",2)","v":false},null,null,null,null,null,null,{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&V$1&\" > There are no 'UnMatched' samples!\",TRUE)","v":false},null,null,{"$f":"FREEZE.PANES(FALSE)","v":true},null,null,"SMS_RepSummary","! Reset Data worksheets",null,"! Clear the sheets",null,26,26]
[{"$f":"SET.NAME(\"S0rp3_txt\",\"Profiles for Unmatched and its 'Best Match'\")","v":true},null,null,{"$f":"RETURN()","v":true},null,null,{"$f":"SELECT(\"(\"&Arow&ClrRow+11&Acol&2&Alsp&Arow&ClrRow+6&Acol&8&Asep&Arow&ClrRow+7&Acol&8&Alsp&Arow&ClrRow+6&Acol&12&Asep&Arow&ClrRow+7&Acol&12&Alsp&Arow&ClrRow+9&Acol&9&Asep&Arow&ClrRow+10&Acol&10&Alsp&Arow&ClrRow+9&Acol&12&Asep&Arow&ClrRow+10&Acol&12&Alsp&Arow&ClrRow+9&Acol&14&Asep&Arow&ClrRow+10&Acol&15&\")\")","v":true},"! Get Options",{"$f":"  ALERT(\"There must be at least four header rows and at least two sample rows.\"&Achr&Achr&\"Please add more data and try again.\",2)","v":false},{"$f":"DLD_selectrange(3,Ched1col+2,10,Ched1col+3,FALSE)","v":0},null,{"$f":"  FORMULA(\"Date Loaded\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&Ched3col+1,FALSE))","v":true},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&M$1&\" > Finished!\",TRUE)","v":0},{"$f":"        SET.NAME(\"Nall\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&4,FALSE)))","v":true},{"$f":"  HALT()","v":true},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&P$1&\" > Finished!\",TRUE)","v":0},null,null,null,null,null,{"$f":"  ALERT(\"There are no 'Unmatched' samples.  Unless you wish to match against 'All Samples', you do not need any further report.\",2)","v":true},{"$f":"SET.NAME(\"Irow0\",5)","v":true},{"$f":"dld_Selectcols(6,11,FALSE)","v":0},{"$f":"FREEZE.PANES(TRUE,,4)","v":true},"! Check the Date format",null,"Utility_CleanUpNames",{"$f":"ACTIVATE(S0dat)","v":true},null,{"$f":"RUN(SMS_Clear,FALSE)","v":{"$error":"#N/A"}},null,27,27]
[{"$f":"SET.NAME(\"Amat1_txt\",\" to all samples\")","v":true},null,null,null,null,null,{"$f":"IF(ClrCde3<0.5,PATTERNS(0),PATTERNS(1,,ClrCde3,TRUE))","v":true},{"$f":"SET.NAME(\"LOptBlk\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx3row&Acol&2,FALSE)))","v":true},{"$f":"  HALT()","v":true},{"$f":"ALIGNMENT(2,FALSE,3,0)","v":true},null,{"$f":"  FORMULA(\"Worksheet\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&Ched3col+2,FALSE))","v":true},{"$f":"RETURN()","v":true},{"$f":"        SET.NAME(\"Icol\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&5,FALSE)))","v":true},{"$f":"END.IF()","v":false},{"$f":"RETURN()","v":true},null,null,null,null,null,{"$f":"  HALT()","v":true},{"$f":"SET.NAME(\"Irow1\",Irow0+Nums-1)","v":true},{"$f":"FORMAT.NUMBER(\"0.0\")","v":true},null,{"$f":"SET.NAME(\"AlngDat\",DEREF(INDIRECT(\"'\"&S0dti&\"'!\"&Arow&2&Acol&3,FALSE)))","v":true},null,"Utility_DateTimeDependencies",{"$f":"PAGE.SETUP(\"&L&\"\"Arial,Regular\"\"&8Built by: DL Duewer, NIST&C&\"\"Arial,Bold\"\"&16\"&Asyst&\" &\"\"Arial,Regular\"\"&12<\"&Avers&\">\n\"&Atmp&\"&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.25,1.2,0.5,FALSE,FALSE,TRUE,FALSE,2,1,{1,#N/A},\"Auto\",1,FALSE,,0.7,0.3,FALSE,FALSE)","v":true},null,null,null,28,28]
[{"$f":"SET.NAME(\"Amat2_txt\",\" to other Unmatched samples\")","v":true},null,null,null,null,null,null,{"$f":"IF(NOT(ISLOGICAL(LOptBlk)),SET.NAME(\"LOptBlk\",FALSE))","v":false},{"$f":"END.IF()","v":false},null,null,{"$f":"  FORMULA(\"Directory\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&Ched3col+3,FALSE))","v":true},null,null,null,null,null,null,null,null,null,{"$f":"END.IF()","v":false},{"$f":"SET.NAME(\"Irow2\",IF(IsAll=2,Irow1,Irow0+Nsam-1))","v":true},{"$f":"FORMULA(S0rp2_txt&IF(IsAll=1,Amat1_txt,Amat2_txt),Arow&1&Acol&1)","v":true},{"$f":"FORMULA(S0rp3_txt&IF(IsAll=1,Amat1_txt,Amat2_txt),Arow&1&Acol&1)","v":true},{"$f":"SET.NAME(\"Itmp0\",TEXT(NOW(),AlngDat))","v":true},null,"Utility_ReVersion",{"$f":"DLD_gotocell_RC(1,1,1,1,TRUE)","v":false},null,"! Format the ControlPanel",null,29,29]
[null,null,null,null,null,null,{"$f":"SET.NAME(\"ClrCde4\",GET.CELL(63,INDIRECT(\"'\"&S0rme&\"'!\"&Arow&ClrRow+12&Acol&2,FALSE)))","v":true},{"$f":"SET.NAME(\"LOptBlk\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx3row&Acol&2,FALSE)))","v":true},null,{"$f":"FORMULA(\"Status of Report Sheets\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&1&Acol&Ched1col,FALSE))","v":true},null,{"$f":"  FORMULA(\"#Loci\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&Ched3col+4,FALSE))","v":true},null,"! Check whether there's at least one allele specified","! Get file info",null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Nlne\",MIN(Nlne0,Nums))","v":true},{"$f":"DLD_selectrange(1,1,1,11,FALSE)","v":0},{"$f":"DLD_selectrange(1,1,1,3+Nloc,FALSE)","v":0},{"$f":"IF(Itmp0=AlngDat,SET.NAME(\"Itmp0\",NA()))","v":false},null,"Utility_ShowMacro",null,null,{"$f":"ACTIVATE(S0con)","v":true},null,30,30]
["! Country-Version dependencies that can be automatically determined",null,null,null,null,null,{"$f":"IF(ISERROR(ClrCde4*1),SET.NAME(\"ClrCde4\",0))","v":false},{"$f":"SET.NAME(\"LOptAor\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx4row&Acol&2,FALSE)))","v":true},{"$f":"FOR(\"Icol\",4,ColLst,1)","v":true},{"$f":"DLD_selectrange(1,Ched1col,1,Ched1col+3,FALSE)","v":0},null,{"$f":"  FORMULA(\"Loci...\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&Ched3col+5,FALSE))","v":true},null,{"$f":"        SET.NAME(\"Atmp\",\"?\")","v":true},{"$f":"ECHO(FALSE)","v":true},null,null,null,null,null,null,"! Clear any old reports",null,{"$f":"FONT.PROPERTIES(\"Arial\",\"Bold\",12,,,,,,,1)","v":true},{"$f":"FONT.PROPERTIES(\"Arial\",\"Bold\",12,,,,,,,1)","v":true},{"$f":"IF(ISERROR(Itmp0*1),SET.NAME(\"Itmp0\",NA()))","v":false},null,"Utility_AlignControls","! Do all the report sheets",null,{"$f":"DLD_Setrowautofit(1,-1)","v":0},null,31,31]
[{"$f":"SET.NAME(\"Acol\",INDEX(GET.WORKSPACE(37),7))","v":true},null,null,null,null,null,{"$f":"IF(OR(ClrCde4<-0.5,ClrCde4>56.5),SET.NAME(\"ClrCde4\",0))","v":false},{"$f":"IF(NOT(ISLOGICAL(LOptAor)),SET.NAME(\"LOptAor\",FALSE))","v":false},{"$f":"   SET.NAME(\"Atmp\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Icol&Asep&Arow&65536&Acol&Icol,FALSE)))","v":true},{"$f":"ALIGNMENT(7,FALSE,3,0)","v":true},null,{"$f":"  DLD_selectrange(2,Ched3col,2,Ched3col+4,FALSE)","v":0},null,{"$f":"        SET.NAME(\"Ntmp\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow&Acol&Icol&Asep&Arow&Irow&Acol&Icol+Nall-1,FALSE)))","v":true},{"$f":"SET.NAME(\"Drctry1\",GET.DOCUMENT(2))","v":true},null,null,null,null,null,null,{"$f":"FOR(\"Itmp\",1,Nrepsht,1)","v":true},"! Format the header lines",{"$f":"ALIGNMENT(7,FALSE,3,0,FALSE)","v":true},{"$f":"ALIGNMENT(7,FALSE,3,0,FALSE)","v":true},{"$f":"IF(ISERROR(Itmp0))","v":true},null,null,{"$f":"FOR(\"Itmp\",1,Nrepsht,1)","v":true},null,{"$f":"DLD_setcolwidth(1,2,FALSE)","v":0},null,32,32]
[{"$f":"SET.NAME(\"Adcp\",INDEX(GET.WORKSPACE(37),3))","v":true},null,null,null,null,null,{"$f":"SELECT(\"(\"&Arow&ClrRow+12&Acol&2&Alsp&Arow&ClrRow+6&Acol&14&Asep&Arow&ClrRow+7&Acol&15&\")\")","v":true},{"$f":"SET.NAME(\"LOptAor\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx4row&Acol&2,FALSE)))","v":true},{"$f":"    IF(Atmp<0.5,SET.NAME(\"ColLst\",Icol-1))","v":false},{"$f":"FONT.PROPERTIES(\"Arial\",\"Regular\",10,,,,,,,1)","v":true},null,{"$f":"  ALIGNMENT(3,FALSE,3,0)","v":true},null,{"$f":"        FOR(\"Iall\",1,Ntmp,1)","v":true},{"$f":"SET.NAME(\"WrkBk1\",GET.DOCUMENT(88))","v":true},null,null,null,null,null,null,{"$f":"  SET.NAME(\"Atmp\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&3+Itmp&Acol&Ched1col,FALSE))","v":true},{"$f":"ACTIVATE(S0rp1)","v":true},{"$f":"FORMULA(\"Sample From\",Arow&3&Acol&1)","v":true},{"$f":"FORMULA(\"Loci\",Arow&3&Acol&4)","v":true},{"$f":"  SET.NAME(\"NumNew\",NumNew+1)","v":true},null,null,{"$f":"  SET.NAME(\"S0rep\",EVALUATE(\"S0rp\"&Itmp))","v":true},null,null,null,33,33]
[{"$f":"SET.NAME(\"Agnl\",INDEX(GET.WORKSPACE(37),26))","v":true},null,null,null,null,null,{"$f":"IF(ClrCde4<0.5,PATTERNS(0),PATTERNS(1,,ClrCde4,TRUE))","v":true},{"$f":"SET.NAME(\"LOptQmk\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx5row&Acol&2,FALSE)))","v":true},{"$f":"NEXT()","v":true},{"$f":"FORMULA(\"Status\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&Ched1col,FALSE))","v":true},null,{"$f":"  BORDER(1)","v":true},null,{"$f":"          SET.NAME(\"Aloc\",UPPER(CLEAN(TRIM(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow&Acol&Icol+Iall-1,FALSE)))))","v":true},{"$f":"SET.NAME(\"Asht\",GET.WORKBOOK(38))","v":true},null,null,null,null,null,null,{"$f":"  IF(NOT(Atmp=\"Clear\"))","v":true},{"$f":"DLD_Clearcols(1,-1,FALSE)","v":0},{"$f":"FORMULA(\"#Alleles\",Arow&3&Acol&2)","v":true},{"$f":"DLD_selectrange(3,4,3,3+Nloc,FALSE)","v":0},{"$f":"  FORMULA(\"Invalid!\",INDIRECT(\"'\"&S0dti&\"'!\"&Arow&2&Acol&4,FALSE))","v":true},null,null,{"$f":"  ACTIVATE(S0rep)","v":true},null,{"$f":"SELECT(\"Button 19\")","v":true},null,34,34]
[{"$f":"SET.NAME(\"Alsp\",INDEX(GET.WORKSPACE(37),5))","v":true},null,null,null,null,null,null,{"$f":"IF(NOT(ISLOGICAL(LOptQmk)),SET.NAME(\"LOptQmk\",FALSE))","v":false},{"$f":"IF(ColLst<3.5)","v":true},{"$f":"FORMULA(\"Last Called\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&Ched1col+1,FALSE))","v":true},null,{"$f":"  DLD_setcolwidth(2,-1,TRUE)","v":0},null,null,{"$f":"SET.NAME(\"S1dat\",\"[\"&WrkBk1&\"]\"&Asht)","v":true},null,null,null,null,null,null,{"$f":"    SET.NAME(\"S0rep\",EVALUATE(\"S0rp\"&Itmp))","v":true},null,{"$f":"FORMULA(\"#Loci\",Arow&3&Acol&3)","v":true},{"$f":"ALIGNMENT(7,FALSE,3,0,FALSE)","v":true},{"$f":"  DLD_setcolwidth(1,4,TRUE)","v":false},null,null,{"$f":"  PAGE.SETUP(\"&L&\"\"Arial,Regular\"\"&8Built by: DL Duewer, NIST&C&\"\"Arial,Bold\"\"&16\"&Asyst&\" &\"\"Arial,Regular\"\"&12<\"&Avers&\">\n\"&Atmp&\"&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.25,1.2,0.5,FALSE,FALSE,TRUE,FALSE,2,1,{1,#N/A},\"Auto\",1,FALSE,,0.7,0.3,FALSE,FALSE)","v":true},null,{"$f":"FORMAT.SIZE(95,36)","v":true},null,35,35]
[{"$f":"SET.NAME(\"Arow\",INDEX(GET.WORKSPACE(37),6))","v":true},null,null,null,null,null,{"$f":"DLD_gotocell_RC(1,1,ClrRow-1,1,TRUE)","v":0},{"$f":"SET.NAME(\"LOptQmk\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx5row&Acol&2,FALSE)))","v":true},{"$f":"  DLD_gotocell_RC(1,1,1,1,TRUE)","v":false},{"$f":"FORMULA(\"Sheet\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&Ched1col+2,FALSE))","v":true},null,null,null,"! Standardize the sucker",{"$f":"ACTIVATE(S1dat)","v":true},null,null,null,null,null,null,{"$f":"    SET.NAME(\"Arep\",EVALUATE(\"S0rp\"&Itmp&\"_txt\"))","v":true},{"$f":"FORMAT.NUMBER(\"0\")","v":true},{"$f":"FORMULA(\"Best Match To\",Arow&3&Acol&5)","v":true},{"$f":"FORMULA(\"Type\",Arow&4&Acol&1)","v":true},{"$f":"  DLD_SelectCell(2,2,TRUE)","v":false},null,null,{"$f":"  DLD_gotocell_RC(1,1,1,1,TRUE)","v":false},null,{"$f":"FORMAT.MOVE(2,2,Arow&Cbut0row&Acol&1)","v":true},null,36,36]
[{"$f":"SET.NAME(\"Asep\",\":\")","v":true},null,null,null,null,null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&G$1&\" > Finished!\",TRUE)","v":0},null,{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Data error... must have alleles at at least one locus.\",TRUE)","v":false},{"$f":"FORMULA(\"Contains\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&Ched1col+3,FALSE))","v":true},null,"! Format the Data worksheet",null,{"$f":"          IF(ISERROR(Aloc),SET.NAME(\"Aloc\",\"?\"))","v":false},{"$f":"DLD_setcolwidth(1,-1,TRUE)","v":0},null,null,null,null,null,null,{"$f":"    FORMULA(\"Clear\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&Itmp+3&Acol&Ched1col,FALSE))","v":true},{"$f":"FONT.PROPERTIES(\"Arial\",\"Regular\",10,,,,,,,1)","v":true},{"$f":"FORMULA(\"%Allele\",Arow&3&Acol&6)","v":true},{"$f":"FORMULA(\"Description\",Arow&4&Acol&2)","v":true},{"$f":"  OPTIONS.VIEW(TRUE,TRUE)","v":true},null,null,{"$f":"NEXT()","v":true},null,null,null,37,37]
[null,null,null,null,null,null,{"$f":"RETURN()","v":true},{"$f":"DLD_gotocell_RC(1,1,1,1,TRUE)","v":0},{"$f":"  ALERT(\"At least loci must be specified.\"&Achr&Achr&\"Please correct and try again.\",2)","v":true},{"$f":"DLD_selectrange(2,Ched1col,2,Ched1col+3,FALSE)","v":0},null,{"$f":"  ACTIVATE(S0dat)","v":true},null,{"$f":"          IF(NOT(ISERROR(Aloc+0)),SET.NAME(\"Aloc\",Aloc+0))","v":true},{"$f":"ZOOM(75)","v":true},null,null,null,null,null,null,{"$f":"    FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&Itmp+3&Acol&Ched1col+1,FALSE))","v":true},{"$f":"ALIGNMENT(4,FALSE,2)","v":true},{"$f":"FORMULA(\"%Loci:1+\",Arow&3&Acol&7)","v":true},{"$f":"DLD_selectrange(4,1,4,2,FALSE)","v":0},{"$f":"  DLD_MsgBar(\"Missing a valid day, month, year format.\",TRUE)","v":false},null,null,null,null,{"$f":"SELECT(\"Button 1\")","v":true},null,38,38]
["! Set some useful globals",null,null,null,null,null,null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&H$1&\" > Finished!\",TRUE)","v":0},{"$f":"  HALT()","v":true},{"$f":"ALIGNMENT(3,FALSE,3,0)","v":true},null,{"$f":"  FORMULA(\"Data from: \"&S1dat,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&1&Acol&1,FALSE))","v":true},null,{"$f":"          IF(Aloc=  0,SET.NAME(\"Aloc\",\"?\"))","v":false},{"$f":"DLD_gotocell_RC(1,1,1,1,TRUE)","v":0},null,null,null,null,null,null,{"$f":"    FORMULA(MID(S0rep,FIND(\"]\",S0rep)+1,100),INDIRECT(\"'\"&S0con&\"'!\"&Arow&Itmp+3&Acol&Ched1col+2,FALSE))","v":true},{"$f":"FREEZE.PANES(FALSE)","v":true},{"$f":"FORMULA(\"Next Best Match To\",Arow&3&Acol&9)","v":true},{"$f":"ALIGNMENT(3,FALSE,3,0,FALSE)","v":true},{"$f":"  ALERT(\"Please format this as a valid date (day, month, year) with\"&Achr&\" Excel's standard cell format tool (Format > Cells… > Number > Date).\"&Achr&Achr&\"Then click 'Check It' to proceed.\")","v":false},null,null,"! Reset Macro page as well",null,{"$f":"FORMAT.SIZE(95,36)","v":true},null,39,39]
[{"$f":"SET.NAME(\"Achr\",CHAR(10))","v":true},null,null,null,null,null,null,{"$f":"RETURN()","v":true},{"$f":"END.IF()","v":false},{"$f":"BORDER(1)","v":true},null,{"$f":"  DLD_selectrange(1,1,1,3+Nloc,FALSE)","v":0},null,null,{"$f":"SET.NAME(\"Atmp1\",ALERT(\"Is this the right sheet?\"&S1dat&\".\"&Achr&Achr&\"Click 'OK' if 'Yes', 'Cancel' for 'No'.\",1))","v":true},null,null,null,null,null,null,{"$f":"    FORMULA(Arep&IF(IsAll=1,Amat1_txt,Amat2_txt),INDIRECT(\"'\"&S0con&\"'!\"&Arow&Itmp+2&Acol&Ched1col+3,FALSE))","v":true},{"$f":"FREEZE.PANES(TRUE,,3)","v":true},{"$f":"FORMULA(\"%Allele\",Arow&3&Acol&10)","v":true},{"$f":"BORDER(1)","v":true},{"$f":"  HALT()","v":true},null,null,{"$f":"ACTIVATE(S0mac)","v":true},null,{"$f":"FORMAT.MOVE(2,2,Arow&Cbut1row&Acol&1)","v":true},null,40,40]
[{"$f":"SET.NAME(\"Nlne0\",3)","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"  FONT.PROPERTIES(\"Arial\",\"Bold\",14,,,,,,,1)","v":true},null,"! Assemble the condensed profile",{"$f":"IF(Atmp1=FALSE)","v":true},null,null,null,null,null,null,{"$f":"    ACTIVATE(S0rep)","v":true},null,{"$f":"FORMULA(\"%Loci:1+\",Arow&3&Acol&11)","v":true},{"$f":"FOR(\"Iloc\",1,Nloc,1)","v":true},null,null,null,{"$f":"PAGE.SETUP(\"&L&\"\"Arial,Regular\"\"&8Built by: DL Duewer, NIST&C&\"\"Arial,Bold\"\"&16\"&Asyst&\"  &\"\"Arial,Regular\"\"&12<Version \"&Avers&\">\n\"&Atmp&\"&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\",1,0.5,1.3,0.8,FALSE,FALSE,TRUE,FALSE,2,TRUE,50,\"Auto\",1,FALSE,,0.75,0.5,FALSE,FALSE)","v":true},null,null,null,41,41]
[{"$f":"SET.NAME(\"Nblock\",4)","v":true},null,null,null,null,null,null,null,"! Sort into standard order",{"$f":"DLD_Clearcols(Ched2col,Ched2col+1,TRUE)","v":0},null,{"$f":"  ALIGNMENT(7,FALSE,3,0,FALSE)","v":true},null,{"$f":"          IF(Iall<1.5)","v":true},{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&O$1&\" > Activate the desired sheet, save the file, and try again!\",TRUE)","v":0},null,null,null,null,null,null,{"$f":"    dld_Selectcols(1,-1,FALSE)","v":0},{"$f":"FORMULA(S0rp1_txt&IF(IsAll=1,Amat1_txt,Amat2_txt),INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&1&Acol&1,FALSE))","v":true},{"$f":"SELECT(\"(\"&Arow&3&Acol&1&Asep&Arow&3&Acol&3&Alsp&Arow&3&Acol&5&Asep&Arow&3&Acol&7&Alsp&Arow&3&Acol&9&Asep&Arow&3&Acol&11&\")\")","v":true},{"$f":"  SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&3+Iloc,FALSE)))","v":true},{"$f":"ELSE()","v":true},null,null,{"$f":"DLD_clearrange(6,3,7,3,FALSE)","v":false},null,{"$f":"SELECT(\"Button 3\")","v":true},null,42,42]
[null,null,null,null,null,null,null,null,{"$f":"DLD_selectrange(5,1,RowLst,ColLst,FALSE)","v":0},{"$f":"FONT.PROPERTIES(\"Arial\",\"Regular\",10,,,,,,,1)","v":true},null,{"$f":"  FORMULA(\"SampleCode\",INDIRECT(\"'\"&S0dat&\"'!\"&Arow&3&Acol&1,FALSE))","v":true},null,{"$f":"            SET.NAME(\"Atmp\",Aloc)","v":true},{"$f":"  ALERT(\"Please activate the desired worksheet, save the workbook and try again.\",2)","v":true},null,null,null,null,null,null,{"$f":"    EDIT.DELETE()","v":true},{"$f":"DLD_selectrange(1,1,1,Nlne*(Nblock+1)-1,FALSE)","v":0},{"$f":"ALIGNMENT(3)","v":true},{"$f":"  FORMULA(Atmp,Arow&4&Acol&3+Iloc)","v":true},{"$f":"  FORMULA(\"Valid\",INDIRECT(\"'\"&S0dti&\"'!\"&Arow&2&Acol&4,FALSE))","v":true},null,null,null,null,{"$f":"FORMAT.SIZE(95,36)","v":true},null,43,43]
["! Store a few workspace parameters",null,null,null,null,null,null,null,{"$f":"SORT(1,Arow&5&Acol&2,1,,,,,2)","v":true},{"$f":"ALIGNMENT(4,FALSE,3,0)","v":true},null,{"$f":"  DLD_selectrange(3,1,3,2,FALSE)","v":0},null,{"$f":"            SET.NAME(\"Anew\",Aloc)","v":true},{"$f":"  HALT()","v":true},null,null,null,null,null,null,{"$f":"    DLD_setcolwidth(1,-1,TRUE)","v":0},{"$f":"FONT.PROPERTIES(\"Arial\",\"Bold\",12,,,,,,,1)","v":true},{"$f":"BORDER(1)","v":true},{"$f":"NEXT()","v":true},{"$f":"  DLD_SelectCell(2,2,FALSE)","v":0},null,null,null,null,{"$f":"FORMAT.MOVE(2,2,Arow&Cbut2row&Acol&1)","v":true},null,44,44]
[{"$f":"FORMULA(GET.WORKSPACE(4),INDIRECT(\"'\"&S0mac&\"'!\"&Arow&2&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,{"$f":"SET.NAME(\"RowLst\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&2,FALSE))+3)","v":true},{"$f":"FORMULA(\"Counts\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&1&Acol&Ched2col,FALSE))","v":true},null,{"$f":"  ALIGNMENT(7,FALSE,3,0,FALSE)","v":true},null,{"$f":"          ELSE.IF(Iall<2.5)","v":true},{"$f":"END.IF()","v":false},null,null,null,null,null,null,{"$f":"  END.IF()","v":true},{"$f":"ALIGNMENT(7,FALSE,3,0,FALSE)","v":true},{"$f":"DLD_setcolwidth(1,-1,TRUE)","v":0},{"$f":"DLD_selectrange(4,4,4,3+Nloc,FALSE)","v":0},{"$f":"  FORMAT.NUMBER(AlngDat)","v":true},null,null,{"$f":"DLD_gotocell_RC(1,25,TRUE)","v":false},null,null,null,45,45]
[{"$f":"FORMULA(GET.DOCUMENT(14),INDIRECT(\"'\"&S0mac&\"'!\"&Arow&3&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,null,{"$f":"DLD_selectrange(1,Ched2col,1,Ched2col+1,FALSE)","v":0},null,{"$f":"  FORMULA(\"Loci\",INDIRECT(\"'\"&S0dat&\"'!\"&Arow&3&Acol&4,FALSE))","v":true},null,{"$f":"            IF(NOT(Aloc=  Anew))","v":true},null,null,null,null,null,null,null,{"$f":"NEXT()","v":true},{"$f":"FOR(\"Ilne\",1,Nlne,1)","v":true},null,{"$f":"ALIGNMENT(3)","v":true},{"$f":"END.IF()","v":true},null,null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&AC$1&\" > Finished!\",TRUE)","v":false},null,{"$f":"SELECT(\"Option Button 21\")","v":true},null,46,46]
[{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0mac&\"'!\"&Arow&4&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,"! Check row/column recognition",{"$f":"ALIGNMENT(7,FALSE,3,0)","v":true},null,{"$f":"  DLD_selectrange(3,4,3,3+Nloc,FALSE)","v":0},null,{"$f":"              SET.NAME(\"Atmp\",Atmp&Alsp&Aloc)","v":true},"! Get the basic file parameters",null,null,null,null,null,null,null,{"$f":"  FORMULA(\"Sample From\",INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&3&Acol&1+(Ilne-1)*(Nblock+1),FALSE))","v":true},{"$f":"SET.NAME(\"Ilne\",Nlne+1)","v":true},{"$f":"BORDER(1)","v":true},null,null,null,{"$f":"HALT()","v":true},null,{"$f":"FORMAT.MOVE(1,-3,Arow&Cbut2row&Acol&2)","v":true},null,47,47]
[null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Atitle\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&1&Acol&1,FALSE)))","v":true},{"$f":"DLD_selectrange(2,Ched2col,2,Ched2col+1,FALSE)","v":0},null,{"$f":"  ALIGNMENT(7,FALSE,3,0,FALSE)","v":true},null,{"$f":"              SET.NAME(\"Anew\",Aloc)","v":true},{"$f":"SET.NAME(\"ColHed\",-1)","v":true},null,null,null,null,null,null,"! Check Cutoffs",{"$f":"  FORMULA(\"Sample To\",INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&3&Acol&2+(Ilne-1)*(Nblock+1),FALSE))","v":true},{"$f":"SET.NAME(\"Krow\",0)","v":true},null,"! Check the Time format",null,null,null,null,{"$f":"SELECT(\"Option Button 22\")","v":true},null,48,48]
["! Turn calculation off and set to R1C1",null,null,null,null,null,null,null,{"$f":"IF(LEN(Atitle)<4.5)","v":true},{"$f":"ALIGNMENT(3,FALSE,3,0)","v":true},null,{"$f":"  FORMULA(\"Type\",INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&1,FALSE))","v":true},null,{"$f":"            END.IF()","v":true},{"$f":"SET.NAME(\"RowHed\",-1)","v":true},null,null,null,null,null,null,{"$f":"RUN(SMS_CheckCutoffs,FALSE)","v":{"$error":"#N/A"}},{"$f":"  FORMULA(\"%Allele\",INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&3&Acol&3+(Ilne-1)*(Nblock+1),FALSE))","v":true},{"$f":"FOR(\"Iums\",1,Nums,1)","v":true},"! Make match list",{"$f":"SET.NAME(\"AlngTim\",DEREF(INDIRECT(\"'\"&S0dti&\"'!\"&Arow&3&Acol&3,FALSE)))","v":true},null,null,null,null,{"$f":"FORMAT.MOVE(1,-3,Arow&Cbut2row+1&Acol&2)","v":true},null,49,49]
[{"$f":"OPTIONS.CALCULATION(1)","v":true},null,null,null,null,null,null,null,{"$f":"  DLD_gotocell_RC(1,1,1,1,TRUE)","v":false},{"$f":"BORDER(1)","v":true},null,{"$f":"  FORMULA(\"Description\",INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&2,FALSE))","v":true},null,{"$f":"          ELSE()","v":true},{"$f":"SET.NAME(\"RowFst\",GET.DOCUMENT(9))","v":true},null,null,null,null,null,null,null,{"$f":"  FORMULA(\"%Loci:1+\",INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&3&Acol&4+(Ilne-1)*(Nblock+1),FALSE))","v":true},null,{"$f":"ACTIVATE(S0wrk)","v":true},{"$f":"SET.NAME(\"Itmp0\",TEXT(NOW(),AlngTim))","v":true},null,null,null,null,{"$f":"SELECT(\"Option Button 24\")","v":true},null,50,50]
[{"$f":"A1.R1C1(FALSE)","v":true},null,null,null,null,null,null,null,{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Data error... the title must have at least 5 characters.\",TRUE)","v":false},null,null,{"$f":"  SELECT(\"(\"&Arow&4&Acol&1&Asep&Arow&4&Acol&2&Alsp&Arow&4&Acol&4&Asep&Arow&4&Acol&3+Nloc&\")\")","v":true},null,{"$f":"            IF(NOT(OR(Aloc=  Anew,Aloc=  \"?\")))","v":true},{"$f":"SET.NAME(\"RowLst\",GET.DOCUMENT(10))","v":true},null,null,null,null,null,null,"! Tell the user",{"$f":"  DLD_selectrange(3,1+(Ilne-1)*(Nblock+1),3,4+(Ilne-1)*(Nblock+1),FALSE)","v":0},"! Find where it is",{"$f":"DLD_Clearcols(116,119,FALSE)","v":0},{"$f":"IF(Itmp0=AlngTim,SET.NAME(\"Itmp0\",NA()))","v":false},null,null,null,null,{"$f":"FORMAT.MOVE(1,-3,Arow&Cbut2row+2&Acol&2)","v":true},null,51,51]
[{"$f":"COLOR.PALETTE(\"\")","v":true},null,null,null,null,null,null,null,{"$f":"  ALERT(\"The first column of the first row must hold a dataset Title of at least five characters.\"&Achr&Achr&\"Please correct and try again.\",2)","v":true},{"$f":"FORMULA(\"Type\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&Ched2col,FALSE))","v":true},null,{"$f":"  ALIGNMENT(3,FALSE,3,0,FALSE)","v":true},null,{"$f":"              SET.NAME(\"Atmp\",Atmp&Alsp&Aloc)","v":true},{"$f":"SET.NAME(\"ColFst\",GET.DOCUMENT(11))","v":true},null,null,null,null,null,null,{"$f":"ACTIVATE(S0con)","v":true},{"$f":"  ALIGNMENT(3)","v":true},{"$f":"  SET.NAME(\"Rout\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iums&Acol&132,FALSE)))","v":true},{"$f":"COPY(INDIRECT(\"'\"&S0rp2&\"'!\"&Acol&1,FALSE),INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&116,FALSE))","v":true},{"$f":"IF(ISERROR(Itmp0*1),SET.NAME(\"Itmp0\",NA()))","v":false},null,null,null,null,{"$f":"SELECT(\"Group Box 23\")","v":true},null,52,52]
[null,null,null,null,null,null,null,null,{"$f":"  HALT()","v":true},{"$f":"FORMULA(\"#\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&2&Acol&Ched2col+1,FALSE))","v":true},null,{"$f":"  BORDER(1)","v":true},null,{"$f":"              SET.NAME(\"Anew\",Aloc)","v":true},{"$f":"SET.NAME(\"ColLst\",GET.DOCUMENT(12))","v":true},null,null,null,null,null,null,{"$f":"DLD_setcolwidth(Ched1col,Ched1col+1,TRUE)","v":0},{"$f":"  BORDER(1)","v":true},{"$f":"  SET.NAME(\"Cout\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iums&Acol&133,FALSE)))","v":true},{"$f":"CANCEL.COPY(FALSE)","v":true},{"$f":"IF(ISERROR(Itmp0))","v":true},null,null,null,null,{"$f":"FORMAT.SIZE(180,48)","v":true},null,53,53]
["! Is this the first time for a new user?",null,null,null,null,null,null,null,{"$f":"END.IF()","v":false},{"$f":"FORMULA(\"Total\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&3&Acol&Ched2col,FALSE))","v":true},null,{"$f":"  FOR(\"Iloc\",1,Nloc,1)","v":true},null,{"$f":"            END.IF()","v":true},null,null,null,null,null,null,null,{"$f":"DLD_gotocell_RC(1,1,Cbut4row,1,FALSE)","v":0},{"$f":"  dld_Selectcols(3+(Ilne-1)*(Nblock+1),4+(Ilne-1)*(Nblock+1),FALSE)","v":0},null,{"$f":"COPY(INDIRECT(\"'\"&S0rp2&\"'!\"&Acol&5,FALSE),INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&117,FALSE))","v":true},{"$f":"  SET.NAME(\"NumNew\",NumNew+1)","v":true},null,null,null,null,{"$f":"FORMAT.MOVE(0,-6,Arow&Cbut2row&Acol&2)","v":true},null,54,54]
[{"$f":"SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0mac&\"'!\"&Arow&6&Acol&3,FALSE)))","v":true},null,null,null,null,null,null,null,null,{"$f":"FORMULA(\"Exact Match\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&4&Acol&Ched2col,FALSE))","v":true},null,{"$f":"    SET.NAME(\"Aloc\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&3,FALSE)))","v":true},null,{"$f":"          END.IF()","v":true},"! Check for (essentially) blank sheet",null,null,null,null,null,null,null,{"$f":"  FORMAT.NUMBER(\"0.0\")","v":true},"! Get the best match data",{"$f":"CANCEL.COPY(FALSE)","v":true},{"$f":"  FORMULA(\"Invalid!\",INDIRECT(\"'\"&S0dti&\"'!\"&Arow&3&Acol&4,FALSE))","v":true},null,null,null,null,{"$f":"FORMULA(1,INDIRECT(\"'\"&S0con&\"'!\"&Arow&Cbut2row&Acol&1,FALSE))","v":true},null,55,55]
[{"$f":"SET.NAME(\"Atmp1\",GET.WORKSPACE(26))","v":true},null,null,null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&2,FALSE))>0)","v":true},{"$f":"FORMULA(\"Unmatched\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&5&Acol&Ched2col,FALSE))","v":true},null,{"$f":"    FORMULA(Aloc,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Iloc+3,FALSE))","v":true},null,{"$f":"        NEXT()","v":true},{"$f":"IF(MIN(ColLst-ColFst,RowLst-RowFst)<0.5)","v":true},null,null,null,null,null,null,"! Make the summary",{"$f":"NEXT()","v":true},{"$f":"  SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Rout&Acol&Cout,FALSE)))","v":true},null,{"$f":"  DLD_setcolwidth(1,4,TRUE)","v":false},null,null,null,null,null,null,56,56]
[{"$f":"FORMULA(Atmp1,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&6&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,{"$f":"  DLD_Selectrow(2,2,TRUE)","v":{"$error":"#NAME?"}},{"$f":"FORMULA(\"Unmatch (able?)\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&6&Acol&Ched2col,FALSE))","v":true},null,{"$f":"    FORMULA(Iloc+3,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&6,FALSE))","v":true},null,{"$f":"        FORMULA(Atmp,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4+Nsam&Acol&Jcol,FALSE))","v":true},{"$f":"  DLD_gotocell_RC(1,1,1,1,TRUE)","v":false},null,null,null,null,null,null,{"$f":"RUN(SMS_RepDetail,FALSE)","v":{"$error":"#N/A"}},{"$f":"DLD_setcolwidth(1,-1,FALSE)","v":0},{"$f":"  SET.NAME(\"Nall\",1*MID(INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Rout+1&Acol&Cout,FALSE),11,100))","v":true},{"$f":"DLD_clearrange(1,116,3,117,FALSE)","v":0},{"$f":"  DLD_SelectCell(3,2,TRUE)","v":false},null,null,null,null,{"$f":"SELECT(\"Button 4\")","v":true}]
[{"$f":"IF(Atmp=Atmp1)","v":true},null,null,null,null,null,null,null,{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Data error... the second row must be blank.\",TRUE)","v":false},{"$f":"FORMULA(\"Off-ladder alleles\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&8&Acol&Ched2col,FALSE))","v":true},null,{"$f":"  NEXT()","v":true},null,{"$f":"      END.IF()","v":true},{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&O$1&\" > Worksheet (\"&S1dat&\") is effectively empty.\",TRUE)","v":false},null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Nlps\",1*MID(INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Rout+2&Acol&Cout,FALSE),8,100))","v":true},{"$f":"BORDER(0,0,0,0,0)","v":true},{"$f":"  OPTIONS.VIEW(TRUE,TRUE)","v":true},null,null,null,null,{"$f":"FORMAT.SIZE(95,36)","v":true}]
[{"$f":"  SET.NAME(\"Atmp2\",DEREF(INDIRECT(\"'\"&S0mac&\"'!\"&Arow&7&Acol&3,FALSE)))","v":true},null,null,null,null,null,null,null,{"$f":"  ALERT(\"The second row is expected to be blank.\"&Achr&Achr&\"Please correct and try again.\",2)","v":false},{"$f":"FORMULA(\"Deleted blanks\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx3row&Acol&Ched2col,FALSE))","v":true},null,null,null,{"$f":"    NEXT()","v":true},{"$f":"  ALERT(\"This worksheet contains at most \"&ColLst-ColFst+1&\" columns and \"&RowLst-RowFst+1&\" rows of information.\"&Achr&Achr&\"Specify a sheet that contains at least two STR profiles and try again.\",2)","v":false},null,null,null,null,null,null,{"$f":"RUN(SMS_RepSummary,FALSE)","v":{"$error":"#N/A"}},"! Format the worksheet",{"$f":"  FORMULA(Asam,INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Iums+3&Acol&1,FALSE))","v":true},{"$f":"dld_Selectcols(116,117,FALSE)","v":0},{"$f":"  DLD_MsgBar(\"Missing a valid hours, minutes, seconds format.\",TRUE)","v":false},null,null,null,null,{"$f":"FORMAT.MOVE(2,2,Arow&Cbut3row&Acol&1)","v":true}]
[{"$f":"  IF(ISERROR(Atmp2),SET.NAME(\"Atmp2\",0))","v":false},null,null,null,null,null,null,null,{"$f":"  HALT()","v":true},{"$f":"FORMULA(\"Deleted 'OR's\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx4row&Acol&Ched2col,FALSE))","v":true},null,"! Some data currently loaded",null,{"$f":"  END.IF()","v":true},null,null,null,null,null,null,null,null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&W$1&\" > Processing all sample pairs… have patience.\",FALSE)","v":0},{"$f":"  FORMULA(Nall,INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Iums+3&Acol&2,FALSE))","v":true},{"$f":"SORT(1,Arow&1&Acol&116,1,,,,,2)","v":true},{"$f":"  ALERT(\"Please format this as a valid time (hours, minutes, seconds) with\"&Achr&\" Excel's standard cell format tool (Format > Cells… > Number > Time).\"&Achr&Achr&\"Then click 'Check It' to proceed.\")","v":false}]
[{"$f":"  SET.NAME(\"Atmp2\",Atmp2+1)","v":true},null,null,null,null,null,null,null,{"$f":"END.IF()","v":false},{"$f":"FORMULA(\"Deleted '?'s\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx5row&Acol&Ched2col,FALSE))","v":true},null,{"$f":"ELSE()","v":true},null,{"$f":"NEXT()","v":true},{"$f":"  ACTIVATE(S0con)","v":true},null,null,null,null,null,null,{"$f":"RUN(SMS_RepProfile,FALSE)","v":{"$error":"#N/A"}},{"$f":"ACTIVATE(S0wrk)","v":true},{"$f":"  FORMULA(Nlps,INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Iums+3&Acol&3,FALSE))","v":true},null,{"$f":"  HALT()","v":true},null,null,null,null,{"$f":"SELECT(\"Button 5\")","v":true}]
[{"$f":"ELSE()","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"  RUN(SMS_GetWorksheet,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"  DLD_gotocell_RC(1,1,IF(Nloc<1.5,Cbut2row,Cbut3row),1,TRUE)","v":false},null,null,null,null,null,null,null,{"$f":"DLD_Clearcols(3,-1,FALSE)","v":0},null,"! If {A,B} and {B,A}, then get rid of {B,A}",null,null,null,null,null,{"$f":"FORMAT.SIZE(95,36)","v":true}]
[{"$f":"  SET.NAME(\"Atmp2\",1)","v":true},null,null,null,null,null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&3,FALSE))>0)","v":true},{"$f":"FORMULA.ARRAY(\"Clear\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&3&Acol&Ched1col&Asep&Arow&3+Nrepsht&Acol&Ched1col,FALSE))","v":true},null,null,null,"! Format",{"$f":"  HALT()","v":true},null,null,null,null,null,null,"! Format the ControlPanel",null,{"$f":"  SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Rout&Acol&Cout+1,FALSE)))","v":true},{"$f":"FOR(\"Iums\",1,Nums,1)","v":true},{"$f":"ELSE()","v":true},null,null,null,null,{"$f":"FORMAT.MOVE(2,2,Arow&Cbut4row&Acol&1)","v":true}]
[{"$f":"END.IF()","v":true},null,null,null,null,null,null,null,{"$f":"  DLD_Selectcol(3,3,TRUE)","v":{"$error":"#NAME?"}},{"$f":"FORMULA.ARRAY(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&3&Acol&Ched1col+1&Asep&Arow&3+Nrepsht&Acol&Ched1col+1,FALSE))","v":true},null,"! Check if this data already loaded",null,{"$f":"DLD_setcolwidth(1,-1,TRUE)","v":0},{"$f":"END.IF()","v":false},null,null,null,null,null,null,{"$f":"ACTIVATE(S0con)","v":true},{"$f":"FORMAT.NUMBER(\"0\")","v":true},{"$f":"  SET.NAME(\"Pall\",DEREF(INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Rout&Acol&Cout+2,FALSE)))","v":true},{"$f":"  SET.NAME(\"Asam1\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iums&Acol&116,FALSE)))","v":true},{"$f":"  FORMULA(\"Valid\",INDIRECT(\"'\"&S0dti&\"'!\"&Arow&3&Acol&4,FALSE))","v":true}]
[{"$f":"FORMULA(Atmp2,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&7&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Data error... the second row must be blank.\",TRUE)","v":false},{"$f":"FORMULA(MID(S0dat,FIND(\"]\",S0dat)+1,100),INDIRECT(\"'\"&S0con&\"'!\"&Arow&3&Acol&Ched1col+2,FALSE))","v":true},null,{"$f":"  SET.NAME(\"Atitle\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&1&Acol&1,FALSE)))","v":true},null,null,null,null,null,null,null,null,null,{"$f":"DLD_setcolwidth(Ched1col,Ched1col+1,TRUE)","v":0},{"$f":"FONT.PROPERTIES(\"Arial\",\"Regular\",10,,,,,,,1)","v":true},{"$f":"  SET.NAME(\"Ploc\",DEREF(INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Rout&Acol&Cout+3,FALSE)))","v":true},{"$f":"  SET.NAME(\"Asam2\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iums&Acol&117,FALSE)))","v":true},{"$f":"  DLD_SelectCell(3,2,TRUE)","v":0},null,null,null,null,{"$f":"SELECT(\"Option Button 8\")","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  ALERT(\"The third column is expected to be blank.\"&Achr&Achr&\"Please correct and try again.\",2)","v":false},{"$f":"FORMULA(\"Comma-delimited STR-profiles for all samples\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&3&Acol&Ched1col+3,FALSE))","v":true},null,{"$f":"  IF(NOT(ISERROR(FIND(S1dat,Atitle))))","v":true},null,"! Close the old file","! Find the header row/col",null,null,null,null,null,null,{"$f":"DLD_gotocell_RC(1,1,Cbut5row,1,TRUE)","v":0},{"$f":"ALIGNMENT(4,FALSE,2)","v":true},{"$f":"  FORMULA(Asam,INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Iums+3&Acol&5,FALSE))","v":true},{"$f":"  SET.NAME(\"Irow\",MATCH(Asam2,INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&116,FALSE)))","v":true},{"$f":"  FORMAT.NUMBER(AlngTim)","v":true},null,null,null,null,{"$f":"FORMAT.MOVE(1,-3,Arow&Cbut4row&Acol&2)","v":true}]
["! ControlPanel locations",null,null,null,null,null,null,null,{"$f":"  HALT()","v":false},{"$f":"FOR(\"Itmp\",1,Nrepsht,1)","v":true},null,{"$f":"    ACTIVATE(S0con)","v":true},null,{"$f":"ACTIVATE(S1dat)","v":true},{"$f":"FOR(\"Irow\",RowFst,RowLst,1)","v":true},null,null,null,null,null,null,null,{"$f":"FORMULA(\"Locus\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&6,FALSE))","v":true},{"$f":"  FORMULA(Pall,INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Iums+3&Acol&6,FALSE))","v":true},{"$f":"  IF(NOT(ISERROR(Irow)))","v":true},{"$f":"END.IF()","v":true},null,null,null,null,{"$f":"SELECT(\"Option Button 9\")","v":true}]
[{"$f":"SET.NAME(\"Ched1col\",4)","v":true},null,null,null,null,null,null,null,{"$f":"END.IF()","v":false},{"$f":"  SET.NAME(\"S0rep\",EVALUATE(\"S0rp\"&Itmp))","v":true},null,{"$f":"    DLD_GotoCell(1,1,Cbut2row,1,TRUE)","v":{"$error":"#VALUE!"}},null,{"$f":"CLOSE(FALSE)","v":true},{"$f":"  SET.NAME(\"Atmp1\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow,FALSE)))","v":true},null,null,null,null,null,null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&V$1&\" > Finished!\",TRUE)","v":0},{"$f":"FORMULA(\"#\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&7,FALSE))","v":true},{"$f":"  FORMULA(Ploc,INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Iums+3&Acol&7,FALSE))","v":true},{"$f":"    SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Irow&Acol&117,FALSE)))","v":true},null,null,null,null,null,{"$f":"FORMAT.MOVE(1,-3,Arow&Cbut4row+1&Acol&2)","v":true}]
[{"$f":"SET.NAME(\"Ched2col\",Ched1col+5)","v":true},null,null,null,null,null,null,null,null,{"$f":"  FORMULA(MID(S0rep,FIND(\"]\",S0rep)+1,100),INDIRECT(\"'\"&S0con&\"'!\"&Arow&Itmp+3&Acol&Ched1col+2,FALSE))","v":true},null,{"$f":"    DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&L$1&\" > That worksheet (\"&S1dat&\") is already loaded.\",TRUE)","v":0},null,null,{"$f":"  IF(Atmp1>1.5)","v":true},null,null,null,null,null,null,{"$f":"HALT()","v":true},{"$f":"FOR(\"Itmp\",1,20,1)","v":true},null,{"$f":"    IF(Atmp=Asam1)","v":true},"! Check the DateTime format",null,null,null,null,{"$f":"SELECT(\"Group Box 20\")","v":true}]
[{"$f":"SET.NAME(\"Ched3col\",Ched2col+3)","v":true},null,null,null,null,null,null,null,{"$f":"IF(DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&3&Acol&1,FALSE))<>\"SampleCode\")","v":true},{"$f":"  ACTIVATE(S0rep)","v":true},null,{"$f":"    ALERT(\"The worksheet (\"&S1dat&\") is already loaded.\"&Achr&\"The current dataset is: \"&Atitle&\".\"&Achr&Achr&\"Specify a different worksheet and try again.\",2)","v":true},null,"! Update the worksheet list",{"$f":"    FOR(\"Icol\",ColFst,ColLst,1)","v":true},null,null,null,null,null,null,null,{"$f":"  FORMULA(\"All-\"&TEXT(Itmp,\"00\"),INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&7+Itmp,FALSE))","v":true},{"$f":"  SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Rout+1&Acol&Cout+1,FALSE)))","v":true},{"$f":"      DLD_clearrange(Irow,116,Irow,117,FALSE)","v":0},{"$f":"SET.NAME(\"AlngDatTim\",AlngDat&\" \"&AlngTim)","v":true},null,null,null,null,{"$f":"FORMAT.SIZE(180,36)","v":true}]
[{"$f":"SET.NAME(\"Cbut0row\",1)","v":true},null,null,null,null,null,null,null,{"$f":"  DLD_gotocell_RC(1,1,3,1,TRUE)","v":false},{"$f":"  dld_Selectcols(1,-1,FALSE)","v":0},null,{"$f":"    HALT()","v":true},null,{"$f":"ACTIVATE(S0con)","v":true},{"$f":"      SET.NAME(\"Atmp2\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Acol&Icol,FALSE)))","v":true},null,null,null,null,null,null,null,{"$f":"  FORMULA(\"Bll-\"&TEXT(Itmp,\"00\"),INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&57+Itmp,FALSE))","v":true},{"$f":"  SET.NAME(\"Pall\",DEREF(INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Rout+1&Acol&Cout+2,FALSE)))","v":true},null,{"$f":"FORMULA(AlngDatTim,INDIRECT(\"'\"&S0dti&\"'!\"&Arow&4&Acol&3,FALSE))","v":true},null,null,null,null,{"$f":"FORMAT.MOVE(0,-6,Arow&Cbut4row&Acol&2)","v":true}]
[{"$f":"SET.NAME(\"Cbut1row\",6)","v":true},null,null,null,null,null,null,null,{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Data error... the first column of the third row must contain 'SampleCode'.\",TRUE)","v":false},{"$f":"  EDIT.DELETE()","v":true},null,{"$f":"  END.IF()","v":false},null,{"$f":"SET.NAME(\"Nfile\",COUNTA(INDIRECT(\"'\"&S0con&\"'!\"&Acol&Ched3col,FALSE)))","v":true},{"$f":"      IF(Atmp2>1.5)","v":true},null,null,null,null,null,null,null,{"$f":"NEXT()","v":true},{"$f":"  SET.NAME(\"Ploc\",DEREF(INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Rout+1&Acol&Cout+3,FALSE)))","v":true},{"$f":"    END.IF()","v":true},{"$f":"SET.NAME(\"Itmp0\",TEXT(NOW(),AlngDatTim))","v":true},null,null,null,null,{"$f":"FORMULA(2,INDIRECT(\"'\"&S0con&\"'!\"&Arow&Cbut4row&Acol&1,FALSE))","v":true}]
[{"$f":"SET.NAME(\"Cbut2row\",11)","v":true},null,null,null,null,null,null,null,{"$f":"  ALERT(\"The first column of the third row is expected to be 'SampleCode'.\"&Achr&Achr&\"Please correct and try again.\",2)","v":false},{"$f":"  DLD_setcolwidth(1,-1,TRUE)","v":0},null,null,null,{"$f":"FORMULA(RowLst-RowHed,INDIRECT(\"'\"&S0con&\"'!\"&Arow&1+Nfile&Acol&Ched3col,FALSE))","v":true},{"$f":"        SET.NAME(\"Atmp3\",DEREF(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow&Acol&Icol,FALSE)))","v":true},null,null,null,null,null,null,null,{"$f":"FOR(\"Iloc\",1,Nloc,1)","v":true},{"$f":"  FORMULA(Asam,INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Iums+3&Acol&9,FALSE))","v":true},{"$f":"  END.IF()","v":true},{"$f":"IF(Itmp0=AlngDatTim,SET.NAME(\"Itmp0\",NA()))","v":false}]
[{"$f":"SET.NAME(\"Cbut3row\",16)","v":true},null,null,null,null,null,null,null,{"$f":"  HALT()","v":true},{"$f":"NEXT()","v":true},null,"! Get the current attitude towards new loci",null,{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&1+Nfile&Acol&Ched3col+1,FALSE))","v":true},null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Iloc+Icol0-1,FALSE)))","v":true},{"$f":"  FORMULA(Pall,INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Iums+3&Acol&10,FALSE))","v":true},{"$f":"NEXT()","v":true},{"$f":"IF(ISERROR(Itmp0*1),SET.NAME(\"Itmp0\",NA()))","v":false},null,null,null,null,{"$f":"SELECT(\"Check Box 28\")","v":true}]
[{"$f":"SET.NAME(\"Cbut4row\",21)","v":true},null,null,null,null,null,null,null,{"$f":"END.IF()","v":false},null,null,"! 1 = no new ones",null,{"$f":"FORMULA(S1dat,INDIRECT(\"'\"&S0con&\"'!\"&Arow&1+Nfile&Acol&Ched3col+2,FALSE))","v":true},"! First significant row/col begins \"SAMPLECODE\", found header",null,null,null,null,null,null,null,{"$f":"  FORMULA(Atmp,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&6,FALSE))","v":true},{"$f":"  FORMULA(Ploc,INDIRECT(\"'\"&S0rp2&\"'!\"&Arow&Iums+3&Acol&11,FALSE))","v":true},null,{"$f":"IF(ISERROR(Itmp0))","v":true},null,null,null,null,{"$f":"FORMAT.MOVE(1,-1,Arow&Ckbx1row&Acol&2)","v":true}]
[{"$f":"SET.NAME(\"Cbut5row\",26)","v":true},null,null,null,null,null,null,null,null,"! Update the RepDetail cutoffs",null,"! 2 = all new ones",null,{"$f":"FORMULA(Drctry1,INDIRECT(\"'\"&S0con&\"'!\"&Arow&1+Nfile&Acol&Ched3col+3,FALSE))","v":true},{"$f":"        IF(UPPER(LEFT(Atmp3,10))=\"SAMPLECODE\")","v":true},null,null,null,null,null,null,null,{"$f":"NEXT()","v":true},{"$f":"NEXT()","v":true},"! Sort the interesting pairs",{"$f":"  SET.NAME(\"NumNew\",NumNew+1)","v":true},null,null,null,null,{"$f":"FORMAT.SIZE(14,14)","v":true}]
[{"$f":"SET.NAME(\"Cbut6row\",29)","v":true},null,null,null,null,null,null,null,{"$f":"IF(DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&3&Acol&4,FALSE))<>\"Loci\")","v":true},{"$f":"RUN(SMS_CheckCutoffs,FALSE)","v":{"$error":"#N/A"}},null,"! 3 = only confirmed new ones",null,null,{"$f":"          SET.NAME(\"RowHed\",Irow)","v":true},null,null,null,null,null,null,null,{"$f":"DLD_setcolwidth(1,-1,TRUE)","v":0},null,{"$f":"dld_Selectcols(116,117,FALSE)","v":0},{"$f":"  FORMULA(\"Invalid!\",INDIRECT(\"'\"&S0dti&\"'!\"&Arow&4&Acol&4,FALSE))","v":true},null,null,null,null,{"$f":"CHECKBOX.PROPERTIES(0,Arow&Ckbx1row&Acol&2)","v":true}]
[{"$f":"SET.NAME(\"Cbut7row\",32)","v":true},null,null,null,null,null,null,null,{"$f":"  DLD_gotocell_RC(1,1,3,4,TRUE)","v":false},null,null,{"$f":"  SET.NAME(\"AddTyp\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Cbut2row&Acol&1,FALSE)))","v":true},null,{"$f":"SET.NAME(\"Nloc\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&3,FALSE)))","v":true},{"$f":"          SET.NAME(\"ColHed\",Icol)","v":true},null,null,null,null,null,null,null,null,"! Sort",{"$f":"SORT(1,Arow&1&Acol&116,1,,,,,2)","v":true},{"$f":"  DLD_setcolwidth(1,2,TRUE)","v":false},null,null,null,null,{"$f":"SELECT(\"Check Box 29\")","v":true}]
[{"$f":"SET.NAME(\"Cbut8row\",36)","v":true},null,null,null,null,null,null,null,{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Data error... the fourth column of the third row must contain 'Loci'.\",TRUE)","v":false},"! Update the data counts",null,{"$f":"  IF(ISERROR(AddTyp*1),SET.NAME(\"Addtyp\",1),IF(OR(AddTyp<0.5,AddTyp>3.5),SET.NAME(\"Addtyp\",1)))","v":false},null,{"$f":"FORMULA(Nloc,INDIRECT(\"'\"&S0con&\"'!\"&Arow&1+Nfile&Acol&Ched3col+4,FALSE))","v":true},{"$f":"          SET.NAME(\"Icol\",ColLst+1)","v":true},null,null,null,null,null,null,null,"! Loop over all sample pairs",{"$f":"DLD_selectrange(4,1,Nums+3,11,FALSE)","v":0},{"$f":"SET.NAME(\"Npai\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&116,FALSE)))","v":true},{"$f":"  DLD_SelectCell(4,1,TRUE)","v":false},null,null,null,null,{"$f":"FORMAT.MOVE(1,-1,Arow&Ckbx2row&Acol&2)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  ALERT(\"The fourth column of the third row is expected to be 'Loci'.\"&Achr&Achr&\"Please correct and try again.\",2)","v":false},{"$f":"RUN(SMS_DataUpdate,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"  FORMULA(AddTyp,INDIRECT(\"'\"&S0con&\"'!\"&Arow&Cbut2row&Acol&1,FALSE))","v":true},null,{"$f":"FOR(\"Iloc\",2,Nloc,1)","v":true},{"$f":"          SET.NAME(\"Irow\",RowLst+1)","v":true},null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Ilne\",Nlne+1)","v":true},{"$f":"SORT(1,Arow&4&Acol&7,2,Arow&4&Acol&6,2,,,2)","v":true},null,{"$f":"  OPTIONS.VIEW(TRUE,TRUE)","v":true},null,null,null,null,{"$f":"FORMAT.SIZE(14,14)","v":true}]
[{"$f":"SET.NAME(\"Ckbx1row\",25)","v":true},null,null,null,null,null,null,null,{"$f":"  HALT()","v":false},null,null,null,null,{"$f":"  SET.NAME(\"Aloc\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc&Acol&3,FALSE)))","v":true},null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Krow\",0)","v":true},null,"! Show page",{"$f":"  DLD_MsgBar(\"Date-Time format is not valid.\",TRUE)","v":false},null,null,null,null,{"$f":"CHECKBOX.PROPERTIES(0,Arow&Ckbx2row&Acol&2)","v":true}]
[{"$f":"SET.NAME(\"Ckbx2row\",26)","v":true},null,null,null,null,null,null,null,{"$f":"END.IF()","v":false},{"$f":"DLD_setcolwidth(2,-1,TRUE)","v":0},null,"! Classify the loci of the new file",null,{"$f":"  FORMULA(Aloc,INDIRECT(\"'\"&S0con&\"'!\"&Arow&1+Nfile&Acol&Ched3col+Iloc+3,FALSE))","v":true},"! Whoops, format doesn't appear to be NIST format (standard or compact)",null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Rout\",4)","v":true},"! Format",{"$f":"ACTIVATE(S0rp3)","v":true},{"$f":"  ALERT(\"While the Date and Time formats are ok, their combination is NOT ok.\"&Achr&\"Try reformatting the Date and/or the Time so that the combination of the two is valid using \"&Achr&\"Excel's Format > Cells… > Number > Custom tool.  Good Luck!\"&Achr&Achr&\"Cllick 'Check It' to proceed.\")","v":false},null,null,null,null,{"$f":"SELECT(\"Check Box 35\")","v":true}]
[{"$f":"SET.NAME(\"Ckbx3row\",16)","v":true},null,null,null,null,null,null,null,null,{"$f":"DLD_GotoCell(1,1,Cbut2row,1,TRUE)","v":{"$error":"#VALUE!"}},null,{"$f":"  FORMULA(\"OutCol\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&6,FALSE))","v":true},null,{"$f":"NEXT()","v":true},{"$f":"        ELSE()","v":true},null,null,null,null,null,null,null,{"$f":"FOR(\"Irow\",Irow0,Irow1,1)","v":true},{"$f":"ACTIVATE(S0rp2)","v":true},{"$f":"DLD_setcolwidth(1,-1,TRUE)","v":0},{"$f":"  HALT()","v":true},null,null,null,null,{"$f":"FORMAT.MOVE(1,-1,Arow&Ckbx3row&Acol&2)","v":true}]
[{"$f":"SET.NAME(\"Ckbx4row\",17)","v":true},null,null,null,null,null,null,null,{"$f":"IF(DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&1,FALSE))<>\"Type\")","v":true},null,null,{"$f":"  FORMULA(\"Status\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&7,FALSE))","v":true},null,{"$f":"DLD_setcolwidth(Ched3col,-1,TRUE)","v":0},{"$f":"          ACTIVATE(S1dat)","v":true},null,null,null,null,null,null,null,{"$f":"  ACTIVATE(S0wrk)","v":true},{"$f":"DLD_setcolwidth(1,-1,TRUE)","v":0},null,null,null,null,null,null,{"$f":"FORMAT.SIZE(14,14)","v":true}]
[{"$f":"SET.NAME(\"Ckbx5row\",18)","v":true},null,null,null,null,null,null,null,{"$f":"  DLD_gotocell_RC(1,1,4,1,TRUE)","v":false},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&J$1&\" > Finished!\",TRUE)","v":0},null,{"$f":"  SET.NAME(\"Nloc\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&3,FALSE))-1)","v":true},null,null,{"$f":"          DLD_gotocell_RC(1,1,MAX(1,RowHed),MAX(1,ColHed),TRUE)","v":0},null,null,null,null,null,null,null,{"$f":"  DLD_clearrange(2,7,Nloc+1,56,FALSE)","v":0},null,"! Loop over each Unmatched",{"$f":"ELSE()","v":true},null,null,null,null,{"$f":"CHECKBOX.PROPERTIES(0,Arow&Ckbx3row&Acol&2)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Data error... the first column of the fourth row must contain 'Type'.\",TRUE)","v":false},{"$f":"RETURN()","v":true},null,{"$f":"  FORMULA.ARRAY(\"\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&2&Acol&6&Asep&Arow&Nloc+1&Acol&7,FALSE))","v":true},null,null,{"$f":"          DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&O$1&\" > Worksheet not in NIST format.\",TRUE)","v":0},null,null,null,null,null,null,null,{"$f":"  DLD_Clearcols(116,120,FALSE)","v":0},{"$f":"ACTIVATE(S0con)","v":true},{"$f":"SET.NAME(\"Krow\",2)","v":true},{"$f":"  FORMULA(\"Valid\",INDIRECT(\"'\"&S0dti&\"'!\"&Arow&4&Acol&4,FALSE))","v":true},null,null,null,null,{"$f":"SELECT(\"Check Box 36\")","v":true}]
[{"$f":"RETURN()","v":true},null,null,null,null,null,null,null,{"$f":"  ALERT(\"The first column of the fourth row is expected to be 'Type'.\"&Achr&Achr&\"Please correct and try again.\",2)","v":false},null,null,{"$f":"  SET.NAME(\"Nprv\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4,FALSE))-2)","v":true},null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&N$1&\" > Finished!\",TRUE)","v":0},{"$f":"          ALERT(\"The header row does not begin with the keyword 'SampleCode'.\"&Achr&\"This worksheet thus does not appear to be in either the NIST standard or compact format.\"&Achr&Achr&\"Please review the format specified in the 'ReadMe' worksheet, make all needed changes and try again.\",2)","v":true},null,null,null,null,null,null,null,null,{"$f":"ECHO(TRUE)","v":true},{"$f":"FOR(\"Ipai\",1,Npai,1)","v":true},{"$f":"  DLD_SelectCell(4,2,TRUE)","v":0},null,null,null,null,{"$f":"FORMAT.MOVE(1,-1,Arow&Ckbx4row&Acol&2)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  HALT()","v":false},null,null,{"$f":"  SET.NAME(\"Nold\",0)","v":true},null,{"$f":"RETURN()","v":true},{"$f":"          HALT()","v":true},null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&2,FALSE)))","v":true},{"$f":"FORMULA(\"Finished\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&5&Acol&Ched1col,FALSE))","v":true},{"$f":"  SET.NAME(\"Asam1\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Ipai&Acol&116,FALSE)))","v":true},{"$f":"  FORMAT.NUMBER(AlngDatTim)","v":true},null,null,null,null,{"$f":"FORMAT.SIZE(14,14)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"END.IF()","v":false},null,null,{"$f":"  SET.NAME(\"Nnew\",0)","v":true},null,null,{"$f":"        END.IF()","v":false},null,null,null,null,null,null,null,{"$f":"  FORMULA(Asam,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&116,FALSE))","v":true},{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&5&Acol&Ched1col+1,FALSE))","v":true},{"$f":"  SET.NAME(\"Asam2\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Ipai&Acol&117,FALSE)))","v":true},{"$f":"END.IF()","v":true},null,null,null,null,{"$f":"CHECKBOX.PROPERTIES(0,Arow&Ckbx4row&Acol&2)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"  FOR(\"Iloc\",1,Nloc,1)","v":true},null,null,{"$f":"      END.IF()","v":true},null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Irow\",MATCH(Asam1,INDIRECT(\"'\"&S0dat&\"'!\"&Acol&2,FALSE),0))","v":true},null,null,null,null,null,{"$f":"SELECT(\"Check Box 37\")","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"IF(DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&2,FALSE))<>\"Description\")","v":true},null,null,{"$f":"    SET.NAME(\"Aloc\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&3,FALSE)))","v":true},null,null,{"$f":"    NEXT()","v":true},null,null,null,null,null,null,null,"! Fetch and store individual alleles",{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&X$1&\" > Finished!\",TRUE)","v":0},{"$f":"  IF(ISERROR(Irow))","v":true},"! Success",null,null,null,null,{"$f":"FORMAT.MOVE(1,-1,Arow&Ckbx5row&Acol&2)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  DLD_gotocell_RC(1,1,4,2,TRUE)","v":false},null,null,{"$f":"    SET.NAME(\"Atmp1\",MATCH(Aloc,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4,FALSE),0))","v":true},null,null,{"$f":"  END.IF()","v":true},null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Mall1\",0)","v":true},{"$f":"RETURN()","v":true},{"$f":"    DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&Y$1&\" > Unexpected error with Unmatched Sample # \"&Ipai&\" (\"&Asam1&\").\",TRUE)","v":false},{"$f":"ACTIVATE(S0dti)","v":true},null,null,null,null,{"$f":"FORMAT.SIZE(14,14)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Data error... the second column of the fourth row must contain 'Description'.\",TRUE)","v":false},null,null,{"$f":"    IF(NOT(ISERROR(Atmp1)))","v":true},null,null,{"$f":"NEXT()","v":true},null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Mlps1\",0)","v":true},null,{"$f":"    ALERT(\"Unexpected error... could not find \"&Asam1&\" in \"&S0dat&\" worksheet.\"&Achr&Achr&\"Please contact david.duewer@NIST.gov about this hassle.\",2)","v":true},{"$f":"FORMULA(\"AlngDat\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&17&Acol&2,FALSE))","v":true},null,null,null,null,{"$f":"CHECKBOX.PROPERTIES(0,Arow&Ckbx5row&Acol&2)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  ALERT(\"The second column of the fourth row is expected to be 'Description'.\"&Achr&Achr&\"Please correct and try again.\",2)","v":false},null,null,{"$f":"      SET.NAME(\"Nold\",Nold+1)","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"  FOR(\"Iloc\",1,Nloc,1)","v":true},null,{"$f":"    HALT()","v":true},{"$f":"FORMULA(\"AlngTim\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&18&Acol&2,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  HALT()","v":false},null,null,{"$f":"      FORMULA(Atmp1,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&6,FALSE))","v":true},null,null,"! Find the last non-blank row",null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Nall\",0)","v":true},null,{"$f":"  END.IF()","v":false},{"$f":"FORMULA(\"AlngDatTim\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&19&Acol&2,FALSE))","v":true},null,null,null,null,{"$f":"SELECT(\"Button 30\")","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"END.IF()","v":false},null,null,{"$f":"      FORMULA(\"aaOld\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&7,FALSE))","v":true},null,null,{"$f":"FOR(\"Irow\",RowLst,RowHed+1,-1)","v":true},null,null,null,null,null,null,null,{"$f":"    IF(NOT(ISBLANK(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Iloc+Icol0-1,FALSE))))","v":true},null,{"$f":"  SET.NAME(\"Jrow\",MATCH(Asam2,INDIRECT(\"'\"&S0dat&\"'!\"&Acol&2,FALSE),0))","v":true},{"$f":"FORMULA(\"Acol\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&20&Acol&2,FALSE))","v":true},null,null,null,null,{"$f":"FORMAT.SIZE(95,24)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"    ELSE()","v":true},null,null,{"$f":"  SET.NAME(\"Ntmp\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&Irow,FALSE)))","v":true},null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Anew\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Iloc+Icol0-1,FALSE)))","v":true},null,{"$f":"  IF(ISERROR(Jrow))","v":true},{"$f":"FORMULA(\"Adcp\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&21&Acol&2,FALSE))","v":true},null,null,null,null,{"$f":"FORMAT.MOVE(2,2,Arow&Cbut5row&Acol&1)","v":true}]
[null,null,null,null,null,null,null,null,"! Check the locus names",null,null,{"$f":"      SET.NAME(\"Nnew\",Nnew+1)","v":true},null,null,{"$f":"  IF(Ntmp>0.5)","v":true},null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Itmp\",0)","v":true},null,{"$f":"    DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&Y$1&\" > Unexpected error with Unmatched Sample # \"&Ipai&\" (\"&Asam2&\").\",TRUE)","v":false},{"$f":"FORMULA(\"Agnl\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&22&Acol&2,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"FOR(\"Icol\",4,ColLst,1)","v":true},null,null,{"$f":"      FORMULA(Nloc+Nnew+3,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&6,FALSE))","v":true},null,null,{"$f":"    SET.NAME(\"RowLst\",Irow)","v":true},null,null,null,null,null,null,null,{"$f":"      WHILE(NOT(ISERROR(Itmp)))","v":true},null,{"$f":"    ALERT(\"Unexpected error... could not find \"&Asam2&\" in \"&S0dat&\" worksheet.\"&Achr&Achr&\"Please contact david.duewer@NIST.gov about this hassle.\",2)","v":false},{"$f":"FORMULA(\"Alsp\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&23&Acol&2,FALSE))","v":true},null,null,null,null,{"$f":"SELECT(\"Button 31\")","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Icol,FALSE)))","v":true},null,null,{"$f":"      FORMULA(\"New\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&7,FALSE))","v":true},null,null,{"$f":"    SET.NAME(\"Irow\",RowHed)","v":true},null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Itmp\",FIND(Alsp,Anew))","v":true},null,{"$f":"  END.IF()","v":false},{"$f":"FORMULA(\"Arow\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&24&Acol&2,FALSE))","v":true},null,null,null,null,{"$f":"FORMAT.SIZE(95,24)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  IF(LEN(Atmp)<2.5)","v":true},null,null,{"$f":"    END.IF()","v":true},null,null,{"$f":"  END.IF()","v":true},null,null,null,null,null,null,null,{"$f":"        IF(ISERROR(Itmp))","v":true},null,null,{"$f":"FORMULA(\"NumNew\",INDIRECT(\"'\"&S0mac&\"'!\"&Arow&25&Acol&2,FALSE))","v":true},null,null,null,null,{"$f":"FORMAT.MOVE(2,2,Arow&Cbut6row&Acol&1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    DLD_gotocell_RC(1,1,4,Icol,TRUE)","v":false},null,null,{"$f":"  NEXT()","v":true},null,null,{"$f":"NEXT()","v":true},null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Nall\",Nall+1)","v":true},null,"! Write out these profiles",{"$f":"FORMULA(AlngDat,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&17&Acol&3,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Data error... Locus names must have at least three characters.\",TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"          FORMULA(Anew,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&7+Nall,FALSE))","v":true},null,{"$f":"  SET.NAME(\"Krow\",Krow+3)","v":true},{"$f":"FORMULA(AlngTim,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&18&Acol&3,FALSE))","v":true},null,null,null,null,{"$f":"SELECT(\"Button 32\")","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    ALERT(\"Locus names (\"&Atmp&\") are expected to have at least 3 characters.\"&Achr&Achr&\"Please correct and try again.\",2)","v":true},null,null,"! No old loci specified",null,null,"! Find the first blank col",null,null,null,null,null,null,null,{"$f":"        ELSE()","v":true},null,{"$f":"  COPY(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&1&Asep&Arow&Irow&Acol&3+Nloc,FALSE),INDIRECT(\"'\"&S0rp3&\"'!\"&Arow&Krow&Acol&1,FALSE))","v":true},{"$f":"FORMULA(AlngDatTim,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&19&Acol&3,FALSE))","v":true},null,null,null,null,{"$f":"FORMAT.SIZE(95,24)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    HALT()","v":true},null,null,{"$f":"  IF(Nold<0.5)","v":true},null,null,{"$f":"FOR(\"Icol\",ColHed+1,ColLst,1)","v":true},null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Nall\",Nall+1)","v":true},null,{"$f":"  CANCEL.COPY(FALSE)","v":true},{"$f":"FORMULA(Acol,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&20&Acol&3,FALSE))","v":true},null,null,null,null,{"$f":"FORMAT.MOVE(2,2,Arow&Cbut7row&Acol&1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  END.IF()","v":false},null,null,{"$f":"      DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&L$1&\" > The 'Added' do not share any loci with previously 'Add'ed datasets.\",TRUE)","v":false},null,null,{"$f":"  SET.NAME(\"Ntmp\",COUNTA(INDIRECT(\"'\"&S1dat&\"'!\"&Acol&Icol,FALSE)))","v":true},null,null,null,null,null,null,null,{"$f":"          FORMULA(LEFT(Anew,Itmp-1),INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&7+Nall,FALSE))","v":true},null,{"$f":"  COPY(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&1&Asep&Arow&Jrow&Acol&3+Nloc,FALSE),INDIRECT(\"'\"&S0rp3&\"'!\"&Arow&Krow+1&Acol&1,FALSE))","v":true},{"$f":"FORMULA(Adcp,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&21&Acol&3,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"NEXT()","v":true},null,null,{"$f":"      ACTIVATE(S1dat)","v":true},null,null,{"$f":"  IF(Ntmp<0.5)","v":true},null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Anew\",MID(Anew,Itmp+1,100))","v":true},null,{"$f":"  CANCEL.COPY(FALSE)","v":true},{"$f":"FORMULA(Agnl,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&22&Acol&3,FALSE))","v":true},null,null,null,null,{"$f":"SELECT(\"Button 10\")","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"      DLD_gotocell_RC(1,1,1,1,TRUE)","v":false},null,null,{"$f":"    SET.NAME(\"ColLst\",Icol-1)","v":true},null,null,null,null,null,null,null,{"$f":"        END.IF()","v":true},null,{"$f":"  DLD_selectrange(Krow,1,Krow+1,2+Iloc,FALSE)","v":0},{"$f":"FORMULA(Alsp,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&23&Acol&3,FALSE))","v":true},null,null,null,null,{"$f":"FORMAT.SIZE(95,36)","v":true}]
[null,null,null,null,null,null,null,null,"! Check that there's actually some data at each locus",null,null,{"$f":"      DLD_selectrange(RowHed,ColHed+1,RowHed,ColLst,TRUE)","v":false},null,null,{"$f":"  END.IF()","v":true},null,null,null,null,null,null,null,{"$f":"      NEXT()","v":true},null,{"$f":"  PATTERNS(0)","v":true},{"$f":"FORMULA(Arow,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&24&Acol&3,FALSE))","v":true},null,null,null,null,{"$f":"FORMAT.MOVE(2,2,Arow&Cbut8row&Acol&1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"FOR(\"Icol\",4,ColLst,1)","v":true},null,null,{"$f":"      IF(AddTyp=1)","v":true},null,null,{"$f":"NEXT()","v":true},null,null,null,null,null,null,null,{"$f":"    END.IF()","v":true},null,{"$f":"  DLD_selectrange(Krow,4,Krow+1,2+Iloc,FALSE)","v":0},{"$f":"FORMULA(NumNew,INDIRECT(\"'\"&S0mac&\"'!\"&Arow&25&Acol&3,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Atmp\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&5&Acol&Icol&Asep&Arow&65536&Acol&Icol,FALSE)))","v":true},null,null,{"$f":"        ALERT(\"The 'Add'ed data (\"&S1dat&\") does not share any loci with the prior datasets.\"&Achr&Achr&\"Correct loci designations or change the 'Use Loci' option setting.\"&Achr&\"Then retry 'Add Data'.\",2)","v":false},null,null,null,null,null,null,null,null,null,null,{"$f":"    FORMULA(Nall,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&7,FALSE))","v":true},null,{"$f":"  IF(ClrCde1<0.5,PATTERNS(0),PATTERNS(1,,ClrCde1,TRUE))","v":true},null,null,null,null,null,{"$f":"SELECT(\"Button 25\")","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  IF(Atmp<0.5)","v":true},null,null,{"$f":"        HALT()","v":true},null,null,"! Clear the workspace",null,null,null,null,null,null,null,{"$f":"    IF(Nall>0.5)","v":true},null,null,"! Hide this worksheet",null,null,null,null,{"$f":"FORMAT.SIZE(95,24)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    DLD_selectrange(4,Icol,-1,Icol,TRUE)","v":0},null,null,{"$f":"      ELSE()","v":true},null,null,{"$f":"ACTIVATE(S0wrk)","v":true},null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Mall1\",Mall1+Nall)","v":true},null,"! Color code the locus profiles for this pair",{"$f":"ACTIVATE(S0dti)","v":true},null,null,null,null,{"$f":"FORMAT.MOVE(2,2,Arow&71&Acol&1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Data error... At least one sample must have data at this locus.\",TRUE)","v":0},null,null,{"$f":"        SET.NAME(\"Atmp1\",ALERT(\"The 'Add'ed data (\"&S1dat&\") does not share any loci with the prior datasets.\"&Achr&Achr&\"Click 'OK' to continue, 'Cancel' to stop and edit the loci designations.\",1))","v":false},null,null,{"$f":"DLD_Clearcols(3,114,FALSE)","v":0},null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Mlps1\",Mlps1+1)","v":true},null,{"$f":"  FOR(\"Iloc\",1,Nloc,1)","v":true},{"$f":"WORKBOOK.HIDE()","v":true},null,null,null,null,{"$f":"DLD_setcolwidth(1,-1,TRUE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"    ALERT(\"There are no alleles specified in any sample at this locus.\"&Achr&Achr&\"Please correct and try again.\",2)","v":true},null,null,{"$f":"        IF(NOT(Atmp1))","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"    END.IF()","v":true},null,{"$f":"    SET.NAME(\"Asam1\",DEREF(INDIRECT(\"'\"&S0rp3&\"'!\"&Arow&Krow&Acol&3+Iloc,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    HALT()","v":true},null,null,{"$f":"          DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&L$1&\" > Returning to control to User.\",TRUE)","v":false},null,null,{"$f":"FORMULA(\"Locus\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,{"$f":"  NEXT()","v":true},null,{"$f":"    SET.NAME(\"Asam2\",DEREF(INDIRECT(\"'\"&S0rp3&\"'!\"&Arow&Krow+1&Acol&3+Iloc,FALSE)))","v":true},"! Do we need to restart Auto_Open?",null,null,null,null,{"$f":"RUN(SMS_CheckCutoffs,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,{"$f":"  END.IF()","v":false},null,null,{"$f":"          ALERT(\"Please correct the hassle and try again.\",2)","v":true},null,null,{"$f":"FORMULA(\"#\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&4,FALSE))","v":true},null,null,null,null,null,null,null,{"$f":"  FORMULA(\"#Alleles: \"&Mall1,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&2&Acol&116,FALSE))","v":true},null,{"$f":"    DLD_selectrange(Krow,3+Iloc,Krow+1,3+Iloc,FALSE)","v":0},{"$f":"IF(NumNew>0.5)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"NEXT()","v":true},null,null,{"$f":"          HALT()","v":true},null,null,{"$f":"FORMULA(\"InCol\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&5,FALSE))","v":true},null,null,null,null,null,null,null,{"$f":"  FORMULA(\"#Loci: \"&Mlps1,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&3&Acol&116,FALSE))","v":true},null,null,{"$f":"  _xlnm.Auto_Open()","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"        END.IF()","v":false},null,null,{"$f":"FORMULA(\"OutCol\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&6,FALSE))","v":true},null,null,null,null,null,null,null,null,null,"! If either is \"?\", flag COOL",{"$f":"ELSE()","v":true},null,null,null,null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&AE$1&\" > Finished!\",TRUE)","v":0}]
[null,null,null,null,null,null,null,null,"! Dump any crap",null,null,{"$f":"      END.IF()","v":true},null,null,null,null,null,null,null,null,null,null,"! Loop over all other samples",null,{"$f":"    IF(OR(Asam1=\"?\",Asam2=\"?\"))","v":true},{"$f":"  ACTIVATE(S0con)","v":true},null,null,null,null,{"$f":"HALT()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"dld_Selectcols(ColLst+1,-1,FALSE)","v":0},null,null,{"$f":"  END.IF()","v":true},null,null,"! Find the alleles",null,null,null,null,null,null,null,{"$f":"  FOR(\"Jrow\",Irow0,Irow2,1)","v":true},null,{"$f":"    IF(ClrCde2<0.5,PATTERNS(0),PATTERNS(1,,ClrCde2,TRUE))","v":true},{"$f":"  DLD_gotocell_RC(1,1,1,1,TRUE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"EDIT.DELETE(4)","v":true},null,null,null,null,null,{"$f":"SET.NAME(\"Nloc\",0)","v":true},null,null,null,null,null,null,null,{"$f":"    IF(Jrow<>Irow)","v":true},null,null,{"$f":"END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"DLD_Selectrows(RowLst+1,-1,FALSE)","v":0},null,null,"! Not all old loci specified",null,null,{"$f":"FOR(\"Icol\",ColHed+1,ColLst,1)","v":true},null,null,null,null,null,null,null,{"$f":"      DLD_clearrange(2,58,Nloc+1,106,FALSE)","v":0},null,"! See if there is at least one common allele",null,null,null,null,null,"! Format the Introduction"]
[null,null,null,null,null,null,null,null,{"$f":"EDIT.DELETE(4)","v":true},null,null,{"$f":"  IF(AND(Nold<Nprv-0.5,AddTyp=1))","v":true},null,null,{"$f":"  SET.NAME(\"Aloc\",CLEAN(TRIM(INDIRECT(\"'\"&S1dat&\"'!\"&Arow&RowHed&Acol&Icol,FALSE))))","v":true},null,null,null,null,null,null,null,null,null,{"$f":"    ELSE.IF(NOT(Asam1=Asam2))","v":true},{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\"  Welcome to \"&Asyst&\"!\",TRUE)","v":0},null,null,null,null,{"$f":"ACTIVATE(S0int)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"DLD_setcolwidth(1,-1,TRUE)","v":0},null,null,{"$f":"    FOR(\"Iloc\",1,Nprv,1)","v":true},null,null,{"$f":"  SET.NAME(\"Itmp\",MATCH(Aloc,INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&3,FALSE),0))","v":true},null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Asam\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&2,FALSE)))","v":true},null,{"$f":"      SET.NAME(\"Ntmp\",MAX(2,COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&120,FALSE))))","v":true},{"$f":"RETURN()","v":true},null,null,null,null,{"$f":"SELECT(\"Button 4\")","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Aloc\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&3+Iloc,FALSE)))","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"      FORMULA(Asam,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Jrow-Irow0+1&Acol&117,FALSE))","v":true},null,{"$f":"      FORMULA.ARRAY(\"\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&120&Asep&Arow&Ntmp&Acol&120,FALSE))","v":true},null,null,null,null,null,{"$f":"FORMAT.SIZE(239,25)","v":true}]
[null,null,null,null,null,null,null,null,"! Validate the alleles",null,null,{"$f":"      SET.NAME(\"Atmp1\",MATCH(Aloc,INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&3,FALSE)))","v":true},null,null,"! Found a new one",null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Mall2\",0)","v":true},null,{"$f":"      SET.NAME(\"Iall\",0)","v":true},null,null,null,null,null,{"$f":"FORMAT.MOVE(1,1,Arow&28&Acol&4)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Nloc\",ColLst-3)","v":true},null,null,{"$f":"      ACTIVATE(S0con)","v":true},null,null,{"$f":"  IF(ISERROR(Itmp))","v":true},null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Mlps2\",0)","v":true},null,{"$f":"      SET.NAME(\"Istr\",1)","v":true},null,null,null,null,null,{"$f":"SELECT(\"Button 3\")","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Nmsg\",(RowLst-4)*Nloc)","v":true},null,null,{"$f":"      DLD_GotoCell(1,1,Cbut2row,1,FALSE)","v":false},null,null,{"$f":"    SET.NAME(\"Nloc\",Nloc+1)","v":true},null,null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Atmp\",Asam1&Alsp)","v":true},null,null,null,null,null,{"$f":"FORMAT.SIZE(239,37)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Nofl\",0)","v":true},null,null,{"$f":"      ACTIVATE(S1dat)","v":true},null,null,{"$f":"    FORMULA(Aloc,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1+Nloc&Acol&3,FALSE))","v":true},null,null,null,null,null,null,null,"! Disperse the target alleles",null,{"$f":"      SET.NAME(\"Ntmp\",LEN(Asam1))","v":true},null,null,null,null,null,{"$f":"FORMAT.MOVE(1,1,Arow&33&Acol&4)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Nblk\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx3row&Acol&Ched2col+1,FALSE)))","v":true},null,null,{"$f":"      DLD_gotocell_RC(1,1,1,1,TRUE)","v":false},null,null,{"$f":"    FORMULA(1,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1+Nloc&Acol&4,FALSE))","v":true},null,null,null,null,null,null,null,{"$f":"      FOR(\"Iloc\",1,Nloc,1)","v":true},null,{"$f":"      FOR(\"Itmp\",1,Ntmp,1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(Nblk*1),SET.NAME(\"Nblk\",0))","v":false},null,null,{"$f":"      DLD_selectrange(RowHed,ColHed+1,RowHed,ColLst,TRUE)","v":false},null,null,{"$f":"    FORMULA(Icol,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1+Nloc&Acol&5,FALSE))","v":true},null,null,null,null,null,null,null,{"$f":"        IF(NOT(ISBLANK(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&Iloc+Icol0-1,FALSE))))","v":true},null,{"$f":"       SET.NAME(\"Itmp\",FIND(Alsp,Atmp,Istr))","v":true},null,null,null,null,null,{"$f":"DLD_gotocell_RC(1,1,29,4,TRUE)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Naor\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx4row&Acol&Ched2col+1,FALSE)))","v":true},null,null,{"$f":"      DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&L$1&\" > The 'Added' data must have all of the 'First' data loci.  Missing: \"&Aloc,TRUE)","v":false},null,null,{"$f":"  ELSE.IF(Itmp<>Nloc+1)","v":true},null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Anew\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&Iloc+Icol0-1,FALSE)))","v":true},null,{"$f":"       SET.NAME(\"Atmp1\",MID(Atmp,Istr,Itmp-Istr))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(Naor*1),SET.NAME(\"Naor\",0))","v":false},null,null,{"$f":"      ALERT(\"The Added data (\"&S1dat&\") does not specify at least one of the required loci: \"&Aloc&\".\"&Achr&Achr&\"Correct the spelling or change the 'Add Locus' option.\",2)","v":false},null,null,{"$f":"    SET.NAME(\"Jtmp\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Itmp&Acol&5,FALSE)))","v":false},null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Nall\",0)","v":true},null,{"$f":"       SET.NAME(\"Istr\",Itmp+1)","v":true},null,null,null,null,null,"! Take care of the ReadMe"]
[null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Nqmk\",DEREF(INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx5row&Acol&Ched2col+1,FALSE)))","v":true},null,null,{"$f":"      HALT()","v":true},null,null,{"$f":"    ACTIVATE(S1dat)","v":true},null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Itmp\",0)","v":true},null,{"$f":"       IF(NOT(Atmp1=\"?\"))","v":true},null,null,null,null,null,{"$f":"ACTIVATE(S0rme)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(Nqmk*1),SET.NAME(\"Nqmk\",0))","v":false},null,null,{"$f":"    NEXT()","v":false},null,null,{"$f":"    SELECT(\"(\"&Arow&RowHed&Acol&Icol&Alsp&Arow&RowHed&Acol&Jtmp&\")\")","v":false},null,null,null,null,null,null,null,{"$f":"          WHILE(NOT(ISERROR(Itmp)))","v":true},null,{"$f":"         SET.NAME(\"Iall\",Iall+1)","v":true},null,null,null,null,null,{"$f":"SELECT(\"Button 1\")","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"  END.IF()","v":false},null,null,{"$f":"    DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&O$1&\" > Alleles for each locus must be contiguous.\",TRUE)","v":false},null,null,null,null,null,null,null,{"$f":"            SET.NAME(\"Itmp\",FIND(Alsp,Anew))","v":true},null,{"$f":"         FORMULA(\"'\"&Atmp1,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iall&Acol&120,FALSE))","v":true},null,null,null,null,null,{"$f":"FORMAT.SIZE(95,36)","v":true}]
[null,null,null,null,null,null,null,null,"! Loop over all samples",null,null,null,null,null,{"$f":"    ALERT(\"Alleles for each locus must be contiguous.\"&Achr&Achr&\"Unless this is a test, this is unusual enough that you should suspect the integrity of these data.\",2)","v":false},null,null,null,null,null,null,null,{"$f":"            IF(ISERROR(Itmp))","v":true},null,{"$f":"       END.IF()","v":true},null,null,null,null,null,{"$f":"FORMAT.MOVE(380,6,Arow&121&Acol&1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"ACTIVATE(S0dat)","v":true},null,null,"! Some new loci specified",null,null,{"$f":"    HALT()","v":true},null,null,null,null,null,null,null,{"$f":"              SET.NAME(\"Nall\",Nall+1)","v":true},null,{"$f":"      NEXT()","v":true},null,null,null,null,null,{"$f":"SELECT(\"Button 3\")","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"FOR(\"Irow\",5,RowLst,1)","v":true},null,null,{"$f":"  IF(Nnew>0.5)","v":true},null,null,{"$f":"  ELSE()","v":true},null,null,null,null,null,null,null,{"$f":"              FORMULA(Anew,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&57+Nall,FALSE))","v":true},null,null,null,null,null,null,null,{"$f":"FORMAT.SIZE(300,36)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Ntmp\",Nprv)","v":true},null,null,{"$f":"    SET.NAME(\"Iall\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1+Nloc&Acol&4,FALSE)))","v":true},null,null,null,null,null,null,null,{"$f":"            ELSE()","v":true},null,"! Count the number of matches in the second",null,null,null,null,null,{"$f":"FREEZE.PANES(TRUE,0,1)","v":true}]
[null,null,null,null,null,null,null,null,"! Loop over all samples",null,null,{"$f":"    FOR(\"Iloc\",1,Nloc,1)","v":true},null,null,{"$f":"    FORMULA(Iall+1,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1+Nloc&Acol&4,FALSE))","v":true},null,null,null,null,null,null,null,{"$f":"              SET.NAME(\"Nall\",Nall+1)","v":true},null,{"$f":"     SET.NAME(\"Iall\",0)","v":true},null,null,null,null,null,{"$f":"FORMAT.MOVE(-150,-2,Arow&1&Acol&3)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"NvalLoc\",0)","v":true},null,null,{"$f":"      SET.NAME(\"Aloc\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&3,FALSE)))","v":true},null,null,{"$f":"  END.IF()","v":true},null,null,null,null,null,null,null,{"$f":"              FORMULA(LEFT(Anew,Itmp-1),INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&57+Nall,FALSE))","v":true},null,{"$f":"     SET.NAME(\"Istr\",1)","v":true},null,null,null,null,null,{"$f":"DLD_gotocell_RC(1,1,1,1,TRUE)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Checking alleles… Sample \"&Irow-4&\" of \"&RowLst-4,FALSE)","v":0},null,null,{"$f":"      SET.NAME(\"Atyp\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&7,FALSE)))","v":true},null,null,{"$f":"NEXT()","v":true},null,null,null,null,null,null,null,{"$f":"              SET.NAME(\"Anew\",MID(Anew,Itmp+1,100))","v":true},null,{"$f":"     SET.NAME(\"Atmp\",Asam2&Alsp)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  FOR(\"Icol\",4,Nloc+3,1)","v":true},null,null,{"$f":"      IF(Atyp=\"New\")","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"            END.IF()","v":true},null,{"$f":"     SET.NAME(\"Ntmp\",LEN(Atmp))","v":true}]
[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,{"$f":"        FORMULA(-1,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&6,FALSE))","v":true},null,null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&O$1&\" > Finished!\",TRUE)","v":0},null,null,null,null,null,null,null,{"$f":"          NEXT()","v":true},null,{"$f":"      FOR(\"Itmp\",1,Ntmp,1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    IF(ISNA(Atmp),SET.NAME(\"Atmp\",-999))","v":false},null,null,null,null,null,{"$f":"RETURN()","v":true},null,null,null,null,null,null,null,{"$f":"        END.IF()","v":true},null,{"$f":"        SET.NAME(\"Itmp\",FIND(Alsp,Atmp,Istr))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    IF(OR(Atmp=\"?\",Atmp=0,Atmp=\"0\",Atmp=\"'0\",Atmp=\"INC\",Atmp=\"NA\",Atmp=\"ND\",Atmp=\"NEG\",Atmp=\"-\",Atmp=\"\",Atmp=\"'\"),SET.NAME(\"Atmp\",-999))","v":false},null,null,"! Ask whether to keep or ignore",null,null,null,null,null,null,null,null,null,null,{"$f":"      NEXT()","v":true},null,{"$f":"        SET.NAME(\"Atmp1\",MID(Atmp,Istr,Itmp-Istr))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    IF(LEN(Atmp)<0.5,SET.NAME(\"Atmp\",-999))","v":false},null,null,{"$f":"        IF(AddTyp>2.5)","v":true},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Istr\",Itmp+1)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"          ACTIVATE(S1dat)","v":true},null,null,null,null,null,null,null,null,null,null,"! Count the alleles in common",null,{"$f":"         IF(NOT(ISERROR(MATCH(Atmp1,INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&120,FALSE),0))),SET.NAME(\"Iall\",Iall+1))","v":false}]
[null,null,null,null,null,null,null,null,"! Is it a null?",null,null,{"$f":"          DLD_gotocell_RC(1,1,1,1,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,{"$f":"      FOR(\"Iloc\",1,Nloc,1)","v":true},null,{"$f":"      NEXT()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    IF(Atmp=-999)","v":true},null,null,{"$f":"          DLD_selectrange(RowHed,ColHed+1,RowHed,ColLst,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Nall\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&7,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Anew\",\"?\")","v":true},null,null,{"$f":"          DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&L$1&\" > New locus: \"&Aloc,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,{"$f":"        IF(Nall>0.5)","v":true},null,"! Al least one allele in common, flag WARM else HOT"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Atmp1\",ALERT(\"Locus(\"&Aloc&\") was not previously specified.\"&Achr&Achr&\"Click 'OK' to add it, 'Cancel' to skip it.\",1))","v":false},null,null,null,null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Itmp\",0)","v":true},null,{"$f":"      IF(Iall>0.5,IF(ClrCde3<0.5,PATTERNS(0),PATTERNS(1,,ClrCde3,TRUE)),IF(ClrCde4<0.5,PATTERNS(0),PATTERNS(1,,ClrCde4,TRUE)))","v":true}]
[null,null,null,null,null,null,null,null,"! Check for \" OR \"",null,null,{"$f":"          IF(Atmp1)","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"          FOR(\"Iall\",1,Nall,1)","v":true},null,{"$f":"    END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"     ELSE.IF(NOT(ISERROR(FIND(\" OR \",Atmp))))","v":true},null,null,{"$f":"            SET.NAME(\"Ntmp\",Ntmp+1)","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"            SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&7+Iall,FALSE)))","v":true},null,{"$f":"  NEXT()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"       IF(LOptAor)","v":true},null,null,{"$f":"            FORMULA(Aloc,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Ntmp+3,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"            IF(NOT(ISERROR(MATCH(Atmp,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&58&Asep&Arow&Iloc+1&Acol&106,FALSE),0))),SET.NAME(\"Itmp\",Itmp+1))","v":false},null,{"$f":"NEXT()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Naor\",Naor+1)","v":true},null,null,{"$f":"            FORMULA(Ntmp+3,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&6,FALSE))","v":true},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(\"Anew\",\"?\")","v":true},null,null,{"$f":"            FORMULA(\"Added\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&7,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Mall2\",Mall2+Itmp)","v":true},null,"! Format"]
[null,null,null,null,null,null,null,null,{"$f":"       ELSE()","v":true},null,null,{"$f":"          END.IF()","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"          IF(Itmp>0.5,SET.NAME(\"Mlps2\",Mlps2+1))","v":false},null,{"$f":"ACTIVATE(S0rp3)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"          DLD_gotocell_RC(Irow,Icol,Irow,Icol,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"        END.IF()","v":true},null,{"$f":"DLD_setcolwidth(1,-1,TRUE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"          DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Ambiguous 'OR' designation: \"&Atmp1&\".\",TRUE)","v":false},null,null,"! Accept it",null,null,null,null,null,null,null,null,null,null,{"$f":"      NEXT()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"          PATTERNS(1,6,0)","v":true},null,null,{"$f":"        ELSE()","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"      FORMULA(100*Mall2/Mall1,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Jrow-Irow0+1&Acol&118,FALSE))","v":true},null,{"$f":"ACTIVATE(S0con)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"          ALERT(\"This 'OR' profile (\"&Atmp&\") is ambiguous.\"&Achr&Achr&\"Please make it one or the other (or delete it entirely) and try again.\",2)","v":true},null,null,{"$f":"          SET.NAME(\"Ntmp\",Ntmp+1)","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"      FORMULA(100*Mlps2/Mlps1,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Jrow-Irow0+1&Acol&119,FALSE))","v":true},null,{"$f":"FORMULA(\"Finished\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&6&Acol&Ched1col,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"          HALT()","v":true},null,null,{"$f":"          FORMULA(Aloc,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&4&Acol&Ntmp+3,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"    END.IF()","v":true},null,{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&6&Acol&Ched1col+1,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"       END.IF()","v":false},null,null,{"$f":"          FORMULA(Ntmp+3,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&6,FALSE))","v":true},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,{"$f":"          FORMULA(\"Added\",INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Iloc+1&Acol&7,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&Y$1&\" > Finished!\",TRUE)","v":0}]
[null,null,null,null,null,null,null,null,"! Not a null - standardize it",null,null,{"$f":"        END.IF()","v":true},null,null,null,null,null,null,null,null,null,null,"! Sort the best ones to the top",null,{"$f":"RETURN()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    ELSE()","v":true},null,null,{"$f":"      END.IF()","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"  dld_Selectcols(117,119,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Atmp\",SUBSTITUTE(Atmp,\" \",\"\"))","v":true},null,null,{"$f":"    NEXT()","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"  SORT(1,Arow&1&Acol&119,2,Arow&1&Acol&118,2,,,2)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Atmp\",SUBSTITUTE(Atmp,\"'\",\"\"))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Atmp\",SUBSTITUTE(Atmp,Alsp&Alsp,Alsp))","v":true},null,null,"! Take care of reformating the locus header",null,null,null,null,null,null,null,null,null,null,"! Define \"Best\""]
[null,null,null,null,null,null,null,null,{"$f":"       WHILE(NOT(ISERROR(FIND(Alsp&Alsp,Atmp))))","v":true},null,null,{"$f":"    IF(Ntmp>Nprv)","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Nbst\",COUNTA(INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&119,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Atmp\",SUBSTITUTE(Atmp,Alsp&Alsp,Alsp))","v":false},null,null,{"$f":"      ACTIVATE(S0dat)","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"  IF(LkepMax,SET.NAME(\"Nbst\",MIN(Nbst,NkepMax)))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      NEXT()","v":false},null,null,{"$f":"      DLD_selectrange(4,Nprv+4,4,Ntmp+3,FALSE)","v":false},null,null,null,null,null,null,null,null,null,null,{"$f":"  IF(LkepMin)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Atmp\",SUBSTITUTE(Atmp,Alsp&\"0\",Alsp&\"?\"))","v":true},null,null,{"$f":"      BORDER(1)","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Itmp\",MATCH(PkepMin,INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&119,FALSE),-1))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      IF(LEFT(Atmp,1)=\"0\",SET.NAME(\"Atmp\",\"?\"&MID(Atmp,2,100)))","v":false},null,null,{"$f":"      COLUMN.WIDTH(,,,3)","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"    IF(ISERROR(Itmp),SET.NAME(\"Itmp\",0))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"      DLD_selectrange(3,4,3,Ntmp+3,FALSE)","v":false},null,null,null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Nbst\",IF(LkepMax,MIN(Nbst,Itmp),Itmp))","v":true}]
[null,null,null,null,null,null,null,null,"! Check that it doesn't have strange characters in it",null,null,{"$f":"      ALIGNMENT(7,FALSE,3,0)","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"  END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Nchr\",LEN(Atmp))","v":true},null,null,{"$f":"    END.IF()","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Nbst\",MAX(Nbst,3))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      FOR(\"Ichr\",1,Nchr,1)","v":true},null,null,{"$f":"  END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Atmp1\",MID(Atmp,Ichr,1))","v":true},null,null,{"$f":"END.IF()","v":true},null,null,null,null,null,null,null,null,null,null,"! Keep the best"]
[null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Itmp\",MATCH(Atmp1,INDIRECT(\"'\"&S0wrk&\"'!\"&Acol&1,FALSE),0))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Ilne\",Ilne+1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        IF(ISERROR(Itmp))","v":true},null,null,"! Sort the data",null,null,null,null,null,null,null,null,null,null,{"$f":"  IF(Ilne>Nlne+0.5)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"          DLD_SelectCell(Irow,Icol,TRUE)","v":false},null,null,{"$f":"ACTIVATE(S0wrk)","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"    ACTIVATE(S0rp1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"          DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Unexpected character in allele designation: \"&Atmp1&\".\",TRUE)","v":false},null,null,{"$f":"dld_Selectcols(3,7,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"    DLD_gotocell_RC(1,1,Rout,1,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"          PATTERNS(1,6,0)","v":true},null,null,{"$f":"SORT(1,Arow&2&Acol&7,1,Arow&2&Acol&6,1,,,1)","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Ilne\",1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"          ALERT(\"This profile contains the unexpected character: \"&Atmp1&\".\"&Achr&Achr&\"Please correct and try again.\",2)","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"    IF(Krow>0,SET.NAME(\"Rout\",Rout+Nkep+1))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"          HALT()","v":true},null,null,{"$f":"ACTIVATE(S0con)","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Krow\",Krow+1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        END.IF()","v":false},null,null,{"$f":"DLD_setcolwidth(2,-1,TRUE)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Nkep\",Nbst)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      NEXT()","v":true},null,null,{"$f":"DLD_gotocell_RC(1,1,Cbut2row,1,FALSE)","v":0},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,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Nkep\",MAX(Nkep,Nbst))","v":true}]
[null,null,null,null,null,null,null,null,"! Make sure alleles are unique and in sort order",null,null,"! Get the data",null,null,null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Cout\",1+(Ilne-1)*(Nblock+1))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      DLD_Clearcols(256,-1,FALSE)","v":0},null,null,{"$f":"RUN(SMS_GetData,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Iall\",0)","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,"! Store the position info"]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Istr\",1)","v":true},null,null,"! Update the data counts",null,null,null,null,null,null,null,null,null,null,{"$f":"  FORMULA(Nbst,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Irow-Irow0+1&Acol&131,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Anew\",Atmp&Alsp)","v":true},null,null,{"$f":"SET.NAME(\"Atitle\",IF(NsamOld<1.5,S1dat,Atitle&\", \"&S1dat))","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"  FORMULA(Rout,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Irow-Irow0+1&Acol&132,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Ntmp\",LEN(Atmp))","v":true},null,null,{"$f":"FORMULA(Atitle,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&1&Acol&1,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,{"$f":"  FORMULA(Cout,INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&Irow-Irow0+1&Acol&133,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"       FOR(\"Itmp\",1,Ntmp,1)","v":true},null,null,{"$f":"FORMULA(\"Loaded\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&3&Acol&Ched1col,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Itmp\",FIND(Alsp,Anew,Istr))","v":true},null,null,{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&3&Acol&Ched1col+1,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,"! Store the best"]
[null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Atmp1\",MID(Anew,Istr,Itmp-Istr))","v":true},null,null,{"$f":"RUN(SMS_DataUpdate,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,{"$f":"  COPY(INDIRECT(\"'\"&S0wrk&\"'!\"&Arow&1&Acol&116&Asep&Arow&Nbst&Acol&119,FALSE),INDIRECT(\"'\"&S0rp1&\"'!\"&Arow&Rout&Acol&Cout,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        IF(NOT(ISERROR(Atmp1+0)),SET.NAME(\"Atmp1\",Atmp1+0))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"  CANCEL.COPY(FALSE)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Istr\",Itmp+1)","v":true},null,null,{"$f":"DLD_gotocell_RC(1,1,Cbut2row,1,TRUE)","v":0},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(\"Iall\",Iall+1)","v":true},null,null,{"$f":"ALERT(\"Data from \"&S1dat&\" has been loaded.\"&Achr&\"This data has NOT been validated!\"&Achr&Achr&\"You should check the Types, sample labels, and all of the allele lists before proceeding.\",2)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        FORMULA(Atmp1,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Iall&Acol&256,FALSE))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,"! Format"]
[null,null,null,null,null,null,null,null,{"$f":"        IF(Atmp1=\"OL\")","v":true},null,null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&L$1&\" > Finished!\",TRUE)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"ACTIVATE(S0rp1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Nofl\",Nofl+1)","v":true},null,null,{"$f":"HALT()","v":true},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,{"$f":"          DLD_Selectccell(Irow,Icol,FALSE)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,{"$f":"          PATTERNS(1,4,0)","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ACTIVATE(S0con)","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,{"$f":"FORMULA(\"Finished\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&4&Acol&Ched1col,FALSE))","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,{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&4&Acol&Ched1col+1,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      DLD_selectrange(1,256,Iall,-1,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"      SORT(1)","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&W$1&\" > Finished!\",TRUE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Anew\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&1&Acol&256,FALSE)))","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RETURN()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"       FOR(\"Itmp\",2,Iall,1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        IF(DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Itmp-1&Acol&256,FALSE))<>DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Itmp&Acol&256,FALSE)),SET.NAME(\"Anew\",Anew&Alsp&INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Itmp&Acol&256,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      NEXT()","v":true}]
[]
[null,null,null,null,null,null,null,null,"! Has it changed?"]
[null,null,null,null,null,null,null,null,{"$f":"      IF(Atmp=Anew)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        IF(Anew=0,SET.NAME(\"Anew\",\"?\"))","v":false}]
[]
[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":"      ELSE.IF(LEN(Atmp)=LEN(Anew))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        IF(Anew=0,SET.NAME(\"Anew\",\"?\"))","v":false}]
[]
[null,null,null,null,null,null,null,null,"! If is just an expanded form, ok…"]
[null,null,null,null,null,null,null,null,{"$f":"      ELSE.IF(Atmp=Anew&Alsp&Anew)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        IF(Anew=0,SET.NAME(\"Anew\",\"?\"))","v":false}]
[]
[null,null,null,null,null,null,null,null,"! Any other difference"]
[null,null,null,null,null,null,null,null,{"$f":"      ELSE()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        DLD_SelectCell(Irow,Icol,TRUE)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"        PATTERNS(1,5,0)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        DLD_gotocell_RC(MAX(1,Irow-5),1,Irow,Icol,TRUE)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"        DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Unexpected change on profile standardization: \"&Atmp&\" to \"&Anew&\".\",TRUE)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Atmp1\",ALERT(\"Are the specified profile (\"&Atmp&\") and the standard form (\"&Anew&\") equivalent?\"&Achr&Achr&\"Click 'OK' if they are, 'Cancel' to manually correct.\",1))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        IF(NOT(Atmp1))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"          DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > Returning to control to User.\",TRUE)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"          ALERT(\"Please correct the hassle and try again.\",1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"          HALT()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        END.IF()","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"        ECHO(FALSE)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    END.IF()","v":true}]
[]
[null,null,null,null,null,null,null,null,"! Count the unique alleles"]
[null,null,null,null,null,null,null,null,{"$f":"    IF(NOT(Anew=\"?\"),SET.NAME(\"NvalLoc\",NvalLoc+1))","v":true}]
[]
[null,null,null,null,null,null,null,null,"! Check for \",?\" and \"?,\" and \"?\""]
[null,null,null,null,null,null,null,null,{"$f":"    IF(LOptQmk)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      IF(NOT(ISERROR(FIND(\",?\",Anew))))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Nqmk\",Nqmk+1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Anew\",SUBSTITUTE(Anew,\",?\",\"\"))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      IF(NOT(ISERROR(FIND(\"?,\",Anew))))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Nqmk\",Nqmk+1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Anew\",SUBSTITUTE(Anew,\"?,\",\"\"))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      IF(Anew=\"?\")","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Nqmk\",Nqmk+1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        SET.NAME(\"Anew\",\"\")","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    END.IF()","v":true}]
[]
[null,null,null,null,null,null,null,null,"! Store it!"]
[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":"  NEXT()","v":true}]
[]
[null,null,null,null,null,null,null,null,"! Is this a blank record?"]
[null,null,null,null,null,null,null,null,{"$f":"    IF(AND(NvalLoc<0.5,LOptBlk))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Nblk\",Nblk+1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      dld_clearrows(Irow,Irow,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"    END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"NEXT()","v":true}]
[]
[null,null,null,null,null,null,null,null,"! Make the hash code for every non-blank sample"]
[null,null,null,null,null,null,null,null,{"$f":"FOR(\"Irow\",5,RowLst,1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&4,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  FOR(\"Iloc\",2,Nloc,1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Atmp\",Atmp&\";\"&INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Iloc+3,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  NEXT()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  FORMULA(Atmp,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Nloc+5,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"NEXT()","v":true}]
[]
[null,null,null,null,null,null,null,null,"! Sort by hash and sample name"]
[null,null,null,null,null,null,null,null,{"$f":"DLD_selectrange(5,1,RowLst,Nloc+5,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SORT(1,Arow&5&Acol&Nloc+5,1,Arow&5&Acol&2,1,,,2)","v":true}]
[]
[null,null,null,null,null,null,null,null,"! Combine matching samples"]
[null,null,null,null,null,null,null,null,{"$f":"FOR(\"Irow\",5,RowLst-1,1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&Nloc+5,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Itmp\",MATCH(Atmp,INDIRECT(\"'\"&S0dat&\"'!\"&Acol&Nloc+5,FALSE),1))","v":true}]
[]
[null,null,null,null,null,null,null,null,"! If hash matches, eliminate things with same label"]
[null,null,null,null,null,null,null,null,{"$f":"  IF(Itmp>Irow)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Alab\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&2,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Alab1\",Alab)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    FOR(\"Jrow\",Irow+1,Itmp,1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Alab2\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&2,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      DLD_clearrange(Jrow,1,Jrow,Nloc+3,TRUE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"      IF(Alab1<>Alab2)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        IF(LEN(Alab)<50)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Alab\",Alab&\", \"&Alab2)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        ELSE.IF(NOT(RIGHT(Alab,3)=\"...\"))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"          SET.NAME(\"Alab\",Alab&\",...\")","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"        END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"     SET.NAME(\"Alab1\",Alab2)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    NEXT()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    IF(Alab<>Alab1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      FORMULA(\"ExactMatch\",INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&1,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      FORMULA(Alab,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&2,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"NEXT()","v":true}]
[]
[null,null,null,null,null,null,null,null,"! Clear the workarea and resort"]
[null,null,null,null,null,null,null,null,{"$f":"DLD_Clearcols(Nloc+4,-1,TRUE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"DLD_selectrange(5,1,RowLst,Nloc+5,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SORT(1,Arow&5&Acol&1,1,Arow&5&Acol&2,1,,,2)","v":true}]
[]
[null,null,null,null,null,null,null,null,"! Find any non-match replicate long-names"]
[null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"Nexa\",COUNTIF(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&1,FALSE),\"=ExactMatch\"))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"SET.NAME(\"RowLst\",COUNTA(INDIRECT(\"'\"&S0dat&\"'!\"&Acol&2,FALSE))+3)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"FOR(\"Irow\",Nexa+5,RowLst,1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&2,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Itmp\",Nexa+4+MATCH(Atmp,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Nexa+5&Acol&2&Asep&Arow&RowLst&Acol&2,FALSE),1))","v":true}]
[]
[null,null,null,null,null,null,null,null,"! If necessary, make the long-names unique"]
[null,null,null,null,null,null,null,null,{"$f":"  IF(Itmp>Irow)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    FOR(\"Jrow\",Irow,Itmp,1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&2,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      FORMULA(Atmp&\"|\"&Jrow-Irow+1,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Jrow&Acol&2,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    NEXT()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    DLD_selectrange(Irow,2,Itmp,2,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"    PATTERNS(1,8)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Irow\",Itmp)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"NEXT()","v":true}]
[]
[null,null,null,null,null,null,null,null,"! Make the short names… the stuff to the left of the first separater ( :-_|/\\)"]
[null,null,null,null,null,null,null,null,{"$f":"FOR(\"Irow\",Nexa+5,RowLst,1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&2,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Nchr\",LEN(Atmp))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  FOR(\"Ichr\",2,Nchr,1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Atmp1\",MID(Atmp,Ichr,1))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    IF(OR(Atmp1=\" \",Atmp1=\":\",Atmp1=\"-\",Atmp1=\"_\",Atmp1=\"|\",Atmp1=\".\",Atmp1=\"/\",Atmp1=\"\\\"))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Atmp\",LEFT(Atmp,Ichr-1))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"      SET.NAME(\"Ichr\",Nchr+1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    FORMULA(Atmp,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&5+Nloc,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  NEXT()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"NEXT()","v":true}]
[]
[null,null,null,null,null,null,null,null,"! Try to match short name"]
[null,null,null,null,null,null,null,null,{"$f":"DLD_selectrange(5+Nexa,1,RowLst,Nloc+5,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SORT(1,Arow&Nexa+6&Acol&Nloc+5,1,Arow&Nexa+6&Acol&1,1,,,2)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"FOR(\"Irow\",Nexa+5,RowLst,1)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Atmp\",DEREF(INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&5+Nloc,FALSE)))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  SET.NAME(\"Itmp\",Nexa+4+MATCH(Atmp,INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Nexa+5&Acol&Nloc+5&Asep&Arow&RowLst&Acol&Nloc+5,FALSE),1))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  IF(Itmp>Irow)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    FORMULA.ARRAY(\"UnMatched\",INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&1&Asep&Arow&Itmp&Acol&1,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    SET.NAME(\"Irow\",Itmp)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  ELSE()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    FORMULA(\"UnMatched (able?)\",INDIRECT(\"'\"&S0dat&\"'!\"&Arow&Irow&Acol&1,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"    DLD_SelectCell(Irow,1,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"    PATTERNS(1,7)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  END.IF()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"NEXT()","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"DLD_Clearcols(4+Nloc,-1,FALSE)","v":0}]
[]
[null,null,null,null,null,null,null,null,"! Leave it sorted by Type and long name"]
[null,null,null,null,null,null,null,null,{"$f":"DLD_selectrange(5,1,RowLst,Nloc+3,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SORT(1,Arow&5&Acol&1,2,Arow&5&Acol&2,1,,,2)","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,{"$f":"DLD_gotocell_RC(1,1,1,1,FALSE)","v":0}]
[]
[null,null,null,null,null,null,null,null,"! Update the data counts"]
[null,null,null,null,null,null,null,null,{"$f":"FORMULA(\"Checked\",INDIRECT(\"'\"&S0con&\"'!\"&Arow&3&Acol&Ched1col,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"FORMULA(NOW(),INDIRECT(\"'\"&S0con&\"'!\"&Arow&3&Acol&Ched1col+1,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"RUN(SMS_DataUpdate,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,"! Off-ladder alleles"]
[null,null,null,null,null,null,null,null,{"$f":"ACTIVATE(S0con)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"FORMULA(Nofl,INDIRECT(\"'\"&S0con&\"'!\"&Arow&8&Acol&Ched2col+1,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Nofl>0.5)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"  DLD_GotoCell(1,1,8,Ched2col,TRUE)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"  DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" > There are \"&Nofl&\" off-ladder alleles.\",TRUE)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"  ALERT(\"There \"&IF(Nofl<1.5,\"is\",\"are up to \")&\" \"&Nofl&\" 'OL' (off-ladder) allele\"&IF(Nofl<1.5,\"\",\"s\")&\" in the current dataset.\"&Achr&\"While valid, you really should use\"&IF(Nofl<1.5,\" a\",\"\")&\" more informative description\"&IF(Nofl<1.5,\"\",\"s\")&\".\"&Achr&Achr&\"Click 'OK' to continue.\",2)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"END.IF()","v":true}]
[]
[null,null,null,null,null,null,null,null,"! Option alerts"]
[null,null,null,null,null,null,null,null,{"$f":"FORMULA(Nblk,INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx3row&Acol&Ched2col+1,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"FORMULA(Naor,INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx4row&Acol&Ched2col+1,FALSE))","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"FORMULA(Nqmk,INDIRECT(\"'\"&S0con&\"'!\"&Arow&Ckbx5row&Acol&Ched2col+1,FALSE))","v":true}]
[]
[null,null,null,null,null,null,null,null,{"$f":"DLD_gotocell_RC(1,1,Cbut4row,1,TRUE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"DLD_MsgBar(TEXT(NOW(),AlngDatTim)&\" \"&I$1&\" >  Finished!\",TRUE)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"RETURN()","v":true}]

{"sheet":"DateTime","index":8,"n_rows":56,"n_cols":6,"rows_kept":56,"cut":false,"hidden":true,"merged":[[0,5,1,5]]}
["Parameter","Value","Format","Status",null,"Date-Time format issue!"]
["Date","2017-10-10T10:37:22.780","d-mmm-yy","Valid"]
["Time",43018.442624768519,"h:mm:ss","Valid",null,"Different versions of Excel support different date and time formats."]
["DateTime","2017-10-10T10:37:22.780","d-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,"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,null,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":9,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["."]
[","]
[";"]
["?"]
["0"]
["1"]
["2"]
["3"]
["4"]
["5"]
["6"]
["7"]
["8"]
["9"]
["O"]
["L"]
["X"]
["Y"]