# HG changeset patch # User pmac # Date 1464767727 14400 # Node ID 2aafe60f2fadf3b19050e95c667a60ff1ba09c2d Uploaded diff -r 000000000000 -r 2aafe60f2fad reformatPlatesLinearToTabular.pl --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/reformatPlatesLinearToTabular.pl Wed Jun 01 03:55:27 2016 -0400 @@ -0,0 +1,99 @@ +############################################################################### +# This script converts plate data from linear to tabular format. +# +# Args: +# input file: +# a text file containing a set of linear data in either 384/96 well format, +# +# Returns: +# For each input file, a tabular version of the data is returned +# in the same format typically generated from synergy or cellomics software. +# +# Author: jason ellul +############################################################################### + +use strict; +use warnings; +use IO::Handle; +use File::Temp qw/ tempfile tempdir /; +my $tdir = tempdir( CLEANUP => 0 ); + +# check to make sure having correct input and output files +my $usage = "usage: reformatPlatesTabularToLinear.pl [TABULAR.in] [TABULAR.out] \n"; +die $usage unless @ARGV == 2; + +#get the input arguments +my $linearPlateTable = $ARGV[0]; +my $tabularPlateTable = $ARGV[1]; + +#open the input files +open (INPUT, "<", $linearPlateTable) || die("Could not open file $linearPlateTable \n"); +open (OUTPUT1, ">", $tabularPlateTable) || die("Could not open file $tabularPlateTable \n"); + +#variable to store the name of the R script file +my $r_script; + +# R script to implement the calcualtion of q-values based on multiple simultaneous tests p-values +# construct an R script file and save it in a temp directory +chdir $tdir; +$r_script = "reformatPlatesLinearToTabular.r"; + +open(Rcmd,">", $r_script) or die "Cannot open $r_script \n\n"; +print Rcmd " + #options(show.error.messages = FALSE); + + #read the plates table + #tables <- read.table(\"$linearPlateTable\", sep=\"\\t\", head=T, comment=\"\"); + tablesTMP <- scan(\"$linearPlateTable\", sep=\"\\n\", what=\"character\", quiet = TRUE); + tmp <- strsplit(tablesTMP[1], \"\t\")[[1]]; + tables <- matrix(\"\", nrow=length(tablesTMP)-1, ncol=length(tmp)) + colnames(tables) <- tmp; + for(i in 2:length(tablesTMP)) { + tmp <- strsplit(tablesTMP[i], \"\t\")[[1]]; + if(length(tmp) > ncol(tables)) stop(paste(\"Error: Row\", i, \"has more columns than the header\")); + tables[i-1, 1:length(tmp)] <- tmp; + } + tables <- as.data.frame(tables, stringsAsFactors=F); + + if(ncol(tables) < 2) { + stop(\"The first column of the table must contain the well ID from A01 to either H12 or P24 depending on the number of wells.\") + } + + # check if the plate is in 96 or 384 well format + if(nrow(tables) == 96) { + nc <- 12; + nr <- 8; + } else if(nrow(tables) == 384) { + nc <- 24; + nr <- 16; + } else { + stop(\"Table is not for a 96 or 384 well plate. Please ensure you either have 96 or 384 rows plus a header.\") + } + + # for each table + for(i in 2:ncol(tables)) { + # write the name of the table + write(paste(colnames(tables)[i], sep=\"\"), file=\"$tabularPlateTable\", append=T); + write(\"\", file=\"$tabularPlateTable\", append=T); + # the column header + write(paste(\"\\t\", paste(1:nc, collapse=\"\\t\"), sep=\"\"), file=\"$tabularPlateTable\", append=T); + # replace any NAs with blank + if(any(is.na(tables[,i]))) tables[which(is.na(tables[,i])),i] <- \"\"; + # for each row print the values + curr <- 0; + for(j in LETTERS[1:nr]) { + write(paste(j, \"\\t\", paste(tables[(curr+1):(curr+nc), i], collapse=\"\\t\"), sep=\"\"), file=\"$tabularPlateTable\", append=T); + curr <- curr + nc; + } + # if we are at the last table do not add an extra line + if(i != ncol(tables)) write(\"\", file=\"$tabularPlateTable\", append=T); + } + #eof\n"; + +close Rcmd; + +system("R --no-restore --no-save --no-readline < $r_script > $r_script.out"); + +#close the input and output files +close(OUTPUT1); +close(INPUT); diff -r 000000000000 -r 2aafe60f2fad reformatPlatesLinearToTabular.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/reformatPlatesLinearToTabular.xml Wed Jun 01 03:55:27 2016 -0400 @@ -0,0 +1,45 @@ + + + + reformatPlatesLinearToTabular.pl $inputFile1 $outputFile1 + + + + + + + + + + + + + + + + + + + +.. class:: infomark + +**What it does** + +This program converts a plates table from a linear format to a tabular format. + + +**Example** + +If the plates table consisted of:: + + #Well Table_1 Table_2 A01 1654 6 A02 1719 8 A03 1624 19 A04 1518 6 A05 1587 12 A06 1517 8 A07 1638 9 A08 1733 7 A09 1617 6 A10 1722 8 A11 1665 7 A12 1536 9 A13 1636 13 A14 1691 8 A15 1773 8 A16 1554 12 A17 1651 13 A18 1670 7 A19 1748 7 A20 1541 7 A21 1549 9 A22 1550 8 A23 1615 6 A24 NA NA B01 1553 5 B02 1588 8 B03 1557 6 B04 1786 7 B05 1635 6 B06 1679 6 B07 1533 6 B08 1720 7 B09 1562 6 B10 1577 6 B11 1713 6 B12 1526 6 B13 1559 7 B14 1706 7 B15 1690 6 B16 1707 6 B17 1651 6 B18 1687 7 B19 1584 6 B20 1638 6 B21 1722 6 B22 1562 6 B23 1696 9 B24 NA NA C01 1579 6 C02 1568 14 C03 1684 8 C04 1501 12 C05 1546 22 C06 1718 9 C07 1569 11 C08 1532 8 C09 1530 11 C10 1572 12 C11 1517 12 C12 1573 8 C13 1518 21 C14 1585 16 C15 1595 17 C16 1505 9 C17 1593 10 C18 1735 7 C19 1548 8 C20 1534 10 C21 1512 6 C22 1577 17 C23 1519 19 C24 NA NA D01 1551 7 D02 502 25 D03 1764 6 D04 1827 7 D05 1587 6 D06 1655 6 D07 1625 7 D08 1549 6 D09 1798 7 D10 1689 6 D11 1588 7 D12 1630 7 D13 1620 7 D14 1595 6 D15 1711 6 D16 1504 6 D17 1511 6 D18 1645 6 D19 1608 6 D20 1745 7 D21 1525 5 D22 1646 7 D23 674 25 D24 NA NA E01 1809 7 E02 1624 8 E03 1791 6 E04 1556 17 E05 1530 7 E06 1604 10 E07 1610 14 E08 1620 11 E09 1506 7 E10 1609 15 E11 1620 7 E12 1531 19 E13 1534 8 E14 1723 7 E15 1600 15 E16 1480 25 E17 1714 7 E18 1574 9 E19 1658 8 E20 1634 7 E21 1632 10 E22 1671 8 E23 1639 8 E24 NA NA F01 1804 6 F02 1815 6 F03 1644 7 F04 1618 6 F05 1686 6 F06 1523 8 F07 1501 6 F08 1587 7 F09 1502 6 F10 1742 6 F11 1621 6 F12 1638 8 F13 1640 7 F14 1588 6 F15 1542 6 F16 1720 6 F17 1503 7 F18 1788 6 F19 1571 6 F20 1547 5 F21 1653 8 F22 1752 6 F23 1687 7 F24 NA NA G01 1540 6 G02 1567 22 G03 1587 7 G04 1564 18 G05 1671 9 G06 1552 18 G07 1555 7 G08 1571 11 G09 1693 7 G10 1692 7 G11 1617 11 G12 1590 7 G13 1589 16 G14 1546 8 G15 1648 8 G16 1583 10 G17 1538 17 G18 1560 9 G19 1553 6 G20 1598 9 G21 1561 16 G22 1523 11 G23 1599 13 G24 NA NA H01 1700 6 H02 513 25 H03 1615 6 H04 1656 6 H05 1796 6 H06 1547 6 H07 1563 7 H08 1598 6 H09 1555 6 H10 1621 6 H11 1644 7 H12 1760 7 H13 1525 6 H14 1541 7 H15 1635 6 H16 1527 6 H17 1651 6 H18 1643 7 H19 1593 5 H20 1551 8 H21 1507 6 H22 1504 5 H23 522 25 H24 NA NA I01 1604 7 I02 1591 9 I03 1626 11 I04 1585 11 I05 1522 17 I06 1546 9 I07 1520 6 I08 1582 9 I09 1664 9 I10 1589 10 I11 1508 10 I12 1505 23 I13 1577 7 I14 1657 12 I15 1560 7 I16 1561 12 I17 1597 14 I18 1505 13 I19 1646 9 I20 1579 15 I21 1602 13 I22 1621 12 I23 1583 6 I24 NA NA J01 1520 6 J02 1577 17 J03 1692 8 J04 1510 5 J05 1691 7 J06 1747 7 J07 1744 7 J08 1724 8 J09 1666 6 J10 1645 6 J11 1637 6 J12 1706 7 J13 1672 6 J14 1522 7 J15 1535 5 J16 1528 6 J17 1569 6 J18 1592 8 J19 1812 7 J20 1806 7 J21 1525 6 J22 1675 7 J23 1540 22 J24 NA NA K01 1626 6 K02 1513 6 K03 1624 7 K04 1530 7 K05 1650 11 K06 1610 11 K07 1644 11 K08 1522 11 K09 1544 14 K10 1532 7 K11 1229 25 K12 1520 11 K13 1540 9 K14 1630 10 K15 1668 8 K16 1519 17 K17 1657 8 K18 1509 21 K19 1543 7 K20 1513 12 K21 1564 7 K22 1660 10 K23 1632 6 K24 NA NA L01 1676 7 L02 507 25 L03 1682 6 L04 1595 7 L05 1557 6 L06 1593 7 L07 1734 6 L08 1519 6 L09 1550 6 L10 1528 6 L11 1781 7 L12 1500 6 L13 1573 6 L14 1524 6 L15 1735 7 L16 1523 5 L17 1503 6 L18 1621 6 L19 1559 6 L20 1795 6 L21 1667 6 L22 1560 8 L23 420 25 L24 NA NA M01 1625 6 M02 1548 19 M03 1538 25 M04 1731 7 M05 1607 14 M06 1637 7 M07 1544 9 M08 1703 9 M09 1617 6 M10 1635 8 M11 1528 16 M12 1532 6 M13 1583 7 M14 1555 8 M15 1551 9 M16 1580 15 M17 1655 6 M18 1662 7 M19 1591 8 M20 1758 8 M21 1623 8 M22 1597 6 M23 1561 18 M24 NA NA N01 1660 6 N02 592 25 N03 1595 7 N04 1527 5 N05 1745 6 N06 1543 6 N07 1529 5 N08 1691 6 N09 1705 7 N10 1612 6 N11 1769 7 N12 1624 6 N13 1673 7 N14 1683 7 N15 1637 6 N16 1786 7 N17 1593 6 N18 1636 6 N19 1614 6 N20 1650 6 N21 1553 6 N22 1671 6 N23 628 25 N24 NA NA O01 1692 6 O02 1701 8 O03 1611 10 O04 1370 25 O05 1537 10 O06 1538 14 O07 1582 8 O08 1515 11 O09 1587 6 O10 1582 6 O11 1660 10 O12 1544 10 O13 1544 8 O14 1603 9 O15 1592 12 O16 1518 11 O17 1606 6 O18 1565 10 O19 1617 6 O20 1543 18 O21 1649 7 O22 1710 8 O23 1788 7 O24 NA NA P01 1818 7 P02 1611 5 P03 1736 7 P04 1642 6 P05 1557 5 P06 1606 6 P07 1558 6 P08 1627 6 P09 1579 6 P10 1733 6 P11 1520 6 P12 1558 7 P13 1804 7 P14 1630 6 P15 1576 6 P16 1740 7 P17 1578 6 P18 1544 6 P19 1692 6 P20 1560 6 P21 1552 6 P22 1790 7 P23 1537 6 P24 NA NA + +Running the program will give the following output:: + + + Table_1 + 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A 1654 1719 1624 1518 1587 1517 1638 1733 1617 1722 1665 1536 1636 1691 1773 1554 1651 1670 1748 1541 1549 1550 1615 B 1553 1588 1557 1786 1635 1679 1533 1720 1562 1577 1713 1526 1559 1706 1690 1707 1651 1687 1584 1638 1722 1562 1696 C 1579 1568 1684 1501 1546 1718 1569 1532 1530 1572 1517 1573 1518 1585 1595 1505 1593 1735 1548 1534 1512 1577 1519 D 1551 502 1764 1827 1587 1655 1625 1549 1798 1689 1588 1630 1620 1595 1711 1504 1511 1645 1608 1745 1525 1646 674 E 1809 1624 1791 1556 1530 1604 1610 1620 1506 1609 1620 1531 1534 1723 1600 1480 1714 1574 1658 1634 1632 1671 1639 F 1804 1815 1644 1618 1686 1523 1501 1587 1502 1742 1621 1638 1640 1588 1542 1720 1503 1788 1571 1547 1653 1752 1687 G 1540 1567 1587 1564 1671 1552 1555 1571 1693 1692 1617 1590 1589 1546 1648 1583 1538 1560 1553 1598 1561 1523 1599 H 1700 513 1615 1656 1796 1547 1563 1598 1555 1621 1644 1760 1525 1541 1635 1527 1651 1643 1593 1551 1507 1504 522 I 1604 1591 1626 1585 1522 1546 1520 1582 1664 1589 1508 1505 1577 1657 1560 1561 1597 1505 1646 1579 1602 1621 1583 J 1520 1577 1692 1510 1691 1747 1744 1724 1666 1645 1637 1706 1672 1522 1535 1528 1569 1592 1812 1806 1525 1675 1540 K 1626 1513 1624 1530 1650 1610 1644 1522 1544 1532 1229 1520 1540 1630 1668 1519 1657 1509 1543 1513 1564 1660 1632 L 1676 507 1682 1595 1557 1593 1734 1519 1550 1528 1781 1500 1573 1524 1735 1523 1503 1621 1559 1795 1667 1560 420 M 1625 1548 1538 1731 1607 1637 1544 1703 1617 1635 1528 1532 1583 1555 1551 1580 1655 1662 1591 1758 1623 1597 1561 N 1660 592 1595 1527 1745 1543 1529 1691 1705 1612 1769 1624 1673 1683 1637 1786 1593 1636 1614 1650 1553 1671 628 O 1692 1701 1611 1370 1537 1538 1582 1515 1587 1582 1660 1544 1544 1603 1592 1518 1606 1565 1617 1543 1649 1710 1788 P 1818 1611 1736 1642 1557 1606 1558 1627 1579 1733 1520 1558 1804 1630 1576 1740 1578 1544 1692 1560 1552 1790 1537 Table_2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A 6 8 19 6 12 8 9 7 6 8 7 9 13 8 8 12 13 7 7 7 9 8 6 B 5 8 6 7 6 6 6 7 6 6 6 6 7 7 6 6 6 7 6 6 6 6 9 C 6 14 8 12 22 9 11 8 11 12 12 8 21 16 17 9 10 7 8 10 6 17 19 D 7 25 6 7 6 6 7 6 7 6 7 7 7 6 6 6 6 6 6 7 5 7 25 E 7 8 6 17 7 10 14 11 7 15 7 19 8 7 15 25 7 9 8 7 10 8 8 F 6 6 7 6 6 8 6 7 6 6 6 8 7 6 6 6 7 6 6 5 8 6 7 G 6 22 7 18 9 18 7 11 7 7 11 7 16 8 8 10 17 9 6 9 16 11 13 H 6 25 6 6 6 6 7 6 6 6 7 7 6 7 6 6 6 7 5 8 6 5 25 I 7 9 11 11 17 9 6 9 9 10 10 23 7 12 7 12 14 13 9 15 13 12 6 J 6 17 8 5 7 7 7 8 6 6 6 7 6 7 5 6 6 8 7 7 6 7 22 K 6 6 7 7 11 11 11 11 14 7 25 11 9 10 8 17 8 21 7 12 7 10 6 L 7 25 6 7 6 7 6 6 6 6 7 6 6 6 7 5 6 6 6 6 6 8 25 M 6 19 25 7 14 7 9 9 6 8 16 6 7 8 9 15 6 7 8 8 8 6 18 N 6 25 7 5 6 6 5 6 7 6 7 6 7 7 6 7 6 6 6 6 6 6 25 O 6 8 10 25 10 14 8 11 6 6 10 10 8 9 12 11 6 10 6 18 7 8 7 P 7 5 7 6 5 6 6 6 6 6 6 7 7 6 6 7 6 6 6 6 6 7 6 + + + + diff -r 000000000000 -r 2aafe60f2fad test-data/150615-HR-12015-01A.linear --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/test-data/150615-HR-12015-01A.linear Wed Jun 01 03:55:27 2016 -0400 @@ -0,0 +1,385 @@ +#Well Table_1 Table_2 Table_3 Table_4 Table_5 Table_6 +A01 2215 8.88 55.62 2.57 2.91 78.76 +A02 2811 8.61 57.35 1.07 2.03 63.32 +A03 2226 10.96 70.4 0.54 2.41 79.41 +A04 2528 9.35 61.59 1.66 2.14 74.9 +A05 1827 11.87 73.78 0.66 2.27 79.31 +A06 2337 8.69 58.49 1.07 1.87 62.34 +A07 2233 9.7 63.41 1.07 2.32 77.48 +A08 2462 8.48 57.39 1.06 2.07 67.32 +A09 2790 9.5 62.83 1.65 2.52 80.57 +A10 2792 9.19 60.67 1.9 2.38 73.6 +A11 2547 9.51 61.76 1.33 2.8 84.6 +A12 2629 9.47 60.94 2.09 2.42 72.34 +A13 1655 11.8 71.24 0.85 2.3 71.88 +A14 2647 8.27 52.13 2.15 2.37 72.76 +A15 2300 11.5 72.17 0.57 2.68 86.26 +A16 2030 11.71 71.63 0.74 2.66 89.03 +A17 2124 9.78 63.89 1.13 2.45 81.13 +A18 2461 9.14 59.65 1.83 2.3 77.14 +A19 2273 8.68 57.85 0.97 2.32 69.57 +A20 2281 10.62 70.58 0.7 1.98 65.3 +A21 2412 10.49 69.86 0.46 2.07 70.27 +A22 1331 10.72 69.65 0.68 1.97 61.54 +A23 2245 9.88 66.24 0.4 2.17 66.33 +A24 2037 8.13 53.26 1.42 2.06 70.05 +B01 2184 10.31 65.29 0.87 2.33 72.4 +B02 2104 9.33 57.94 3.09 2.44 79.26 +B03 1639 11.13 69.68 0.55 2.03 67.42 +B04 2467 9.84 64.33 0.77 2.03 67.95 +B05 1818 11.75 75.25 0.66 1.97 68.96 +B06 1769 9.08 57.32 2.43 2.29 69.18 +B07 1654 12.22 75.7 0.6 2.14 75.29 +B08 2199 10.04 68.58 0.73 2.43 73.55 +B09 2043 8.74 59.03 1.22 1.96 57.65 +B10 1329 11.6 73.06 0.68 2.04 58.75 +B11 2533 7.31 47.06 3.83 3.01 95.3 +B12 2712 9.31 61.98 2.06 2.49 75.2 +B13 1824 10.83 68.42 1.54 2.45 80.09 +B14 2718 7.68 49.74 4.01 2.54 81.37 +B15 2443 10.4 68.81 1.02 2.64 91.33 +B16 2061 11.82 77.1 0.39 2.53 87.74 +B17 2088 10.83 70.69 0.62 2.22 74.12 +B18 2730 10.36 70.4 0.81 2.39 78.69 +B19 2279 8.09 54.28 1.14 1.98 61.28 +B20 2371 12.37 78.28 0.25 2.23 78.36 +B21 2114 10.49 71.85 0.85 2.32 73.66 +B22 2355 9.84 66.71 0.72 2.04 64.63 +B23 1154 11.75 72.1 0.35 2.35 65.16 +B24 1646 7.49 50.12 1.82 2.11 64.74 +C01 2356 9.67 64.43 1.02 2.07 61.55 +C02 2680 10.27 67.57 0.82 2.03 60.64 +C03 2305 8.51 55.88 1.56 1.87 56.38 +C04 2510 9.55 63.55 1 2.02 58.22 +C05 2650 10.23 67.96 0.3 1.95 59.48 +C06 2918 9.76 64.98 0.69 2.21 65.35 +C07 2618 8.28 55.39 1.26 2.42 68.98 +C08 2654 9.56 65.3 1.09 2.52 75.17 +C09 2828 8.44 57.39 1.34 2.21 63.59 +C10 2877 9.48 64.75 1.32 2.59 77.38 +C11 2441 9.78 65.38 1.47 2.38 73.63 +C12 2870 7.1 47.04 3.69 2.87 88.54 +C13 3202 9.02 59.93 1.72 2.43 78.2 +C14 2619 8.63 57.43 2.1 2.93 95.11 +C15 2716 8.82 58.73 1.18 2.46 78.45 +C16 2413 10.72 71.07 0.33 2.62 84.52 +C17 2893 8.18 56.14 1.52 2.8 83.32 +C18 2669 9.82 66.62 0.67 2.26 70.88 +C19 2272 10.81 71.79 0.79 2.1 68.8 +C20 2161 9.42 63.4 1.2 2.79 79.7 +C21 2677 8.75 59.62 0.78 2.04 62.52 +C22 2406 9.91 65 0.71 2.08 68.61 +C23 2494 7.54 49.44 2.33 2.25 63.14 +C24 1760 7.85 51.99 1.82 2.15 66.92 +D01 2206 7.2 45.01 2.77 1.41 36.44 +D02 1033 10.08 62.25 1.84 2.61 77.42 +D03 1744 7.58 49.14 3.04 2.4 70.59 +D04 2579 8.78 59.83 1.2 2.12 62.68 +D05 1921 9.41 64.08 0.94 2.29 70.86 +D06 2352 9.68 63.95 2.3 2.6 79.33 +D07 1844 8.86 59.06 2.11 2.76 85.21 +D08 2831 8.45 56.55 1.77 2.62 78 +D09 1803 9.59 63.67 1.22 2.81 84.73 +D10 2531 9.03 59.9 1.78 2.64 75.75 +D11 1942 7.37 48.51 3.24 3.1 95.33 +D12 2653 9.72 66.34 1.43 2.77 84.49 +D13 2624 6.77 43.52 4.54 3.06 101.35 +D14 2777 6.68 43.03 5.47 3.36 106.95 +D15 2523 8.53 58.7 1.43 3.13 101.22 +D16 2532 9.9 66.11 0.87 2.96 89.01 +D17 2243 9.92 66.79 0.76 3.15 105.74 +D18 2653 11.31 76.1 0.45 2.67 85.7 +D19 1806 11.24 73.26 0.44 2.77 90.06 +D20 2502 11.17 74.5 0.48 2.58 76.4 +D21 2355 9.81 67.22 0.85 2.69 88.68 +D22 2036 11.95 77.65 0.29 2.54 82.78 +D23 4 19.75 100 0 1.5 74.25 +D24 2056 7.06 45.82 1.9 2.27 76.56 +E01 1953 7.89 52.02 2.36 2.09 64.14 +E02 58 10.38 67.24 6.9 2.34 81.33 +E03 1429 11 70.89 0.91 2.09 65.5 +E04 2419 9.41 61.06 1.2 2.4 69.87 +E05 2326 9.41 62.64 1.25 2.36 69.72 +E06 2281 9.32 61.03 2.59 2.88 89.16 +E07 2524 7.92 52.61 2.73 2.63 78 +E08 2444 9.17 62.19 1.51 2.8 84.21 +E09 2402 9.13 60.95 1.5 2.6 78.8 +E10 2470 9.23 60.89 1.94 2.64 78.64 +E11 2387 9.57 63.3 1.59 2.58 80.7 +E12 2812 9.54 64.76 1.21 2.61 83.54 +E13 2121 9.11 60.68 2.22 2.37 70.04 +E14 2467 8.67 58.25 1.34 2.65 87.2 +E15 1932 6.3 39.23 5.64 2.89 91.38 +E16 2207 9.54 63.57 1.54 2.63 86.13 +E17 866 11.03 69.98 0.81 2.23 71.41 +E18 1665 8.31 55.56 2.34 3.14 93.34 +E19 1668 11.19 72.96 0.66 2.3 73.16 +E20 1942 10.59 70.19 0.46 2.46 76.69 +E21 2717 10.46 69.82 0.44 2.22 72.24 +E22 1995 9.92 67.27 1.45 2.73 86.76 +E23 2686 8.98 60.65 1.19 2.33 71.8 +E24 1711 8.25 53.71 1.81 2.43 78.22 +F01 2647 8.61 56.89 1.44 2.05 56.86 +F02 1866 10.14 66.4 0.91 1.86 55.02 +F03 2327 7.3 46.41 4.08 2.04 60.29 +F04 1831 6.3 39.16 6.66 2.25 67.66 +F05 2081 8.89 57.33 2.4 2.34 70.01 +F06 2360 9.29 62.12 2.54 2.41 77.11 +F07 2465 8.21 54.36 2.92 2.59 77.73 +F08 2561 7.36 49 2.89 2.31 66.52 +F09 2242 9.81 66.77 1.43 2.47 72.7 +F10 2595 6.08 37.5 6.2 2.39 68.73 +F11 2601 8.19 54.48 3.65 2.77 96.56 +F12 2075 9.72 63.04 1.59 2.47 72.8 +F13 2452 9.25 62.11 1.51 2.66 82.33 +F14 2506 8.22 53.79 2.04 2.54 77.56 +F15 2228 8.19 53.82 2.65 2.91 103.54 +F16 2869 7.83 52.49 1.92 2.58 76.14 +F17 1322 8.78 60.14 1.97 2.52 72.6 +F18 2712 7.56 50 3.39 2.68 81.09 +F19 2623 9 60.62 1.03 2.41 73.71 +F20 2320 9.37 62.5 1.51 2.43 70.9 +F21 2528 9.04 59.53 1.15 2.2 65.33 +F22 1797 6.44 39.96 4.67 2.38 70.58 +F23 1933 10.26 67.36 0.93 2.5 71.62 +F24 1759 8.4 56.17 1.99 1.92 67.93 +G01 2715 10.83 72.08 0.59 1.98 58.65 +G02 2567 11.22 71.76 0.51 1.95 59.34 +G03 2346 8.73 57.37 1.49 2.13 61.93 +G04 2536 7.29 46.77 4.89 2.24 65.72 +G05 2157 8.33 54.38 2.23 2.35 65.99 +G06 2549 6.64 41.66 5.1 2.59 78.36 +G07 2368 9.22 61.15 1.35 2.41 73.63 +G08 2798 9.61 63.44 1.18 2.46 72.8 +G09 2595 8.97 59.73 1.93 2.4 68.47 +G10 3309 6.57 42.16 3.84 2.34 62.92 +G11 2701 7.84 53.05 2.3 2.46 68.96 +G12 2916 7.37 49.04 3.19 2.61 72.96 +G13 2664 9.26 63.48 1.73 2.88 88.03 +G14 2998 7.58 51.17 2.94 2.6 75.25 +G15 2257 9.19 63.14 1.2 2.49 71.58 +G16 2850 10.29 70.53 1.09 2.33 71.99 +G17 2559 7.88 52.25 2.34 2.67 83.35 +G18 2684 8.49 55.48 2.72 2.69 83.61 +G19 2852 7.68 50.25 3.54 2.78 87.58 +G20 2779 7.11 45.88 3.17 2.58 73.2 +G21 2448 9.83 67.28 0.69 2.52 77.41 +G22 2741 7.4 48.23 3.1 2.42 68.04 +G23 2945 10.08 70.12 0.75 2.52 78.27 +G24 1740 6.25 38.91 3.33 2.19 65.21 +H01 2214 12.71 78.73 0.36 2.1 68.06 +H02 11 19.73 90.91 0 2.18 67.36 +H03 1344 10.4 65.77 1.86 2.36 69.92 +H04 1937 7.72 49.3 3.1 2.42 70.48 +H05 2130 9.08 60.19 1.41 2.39 67.18 +H06 2637 8.69 56.16 1.71 2.34 68.97 +H07 2278 10.21 67.08 1.14 2.85 85.95 +H08 2020 10.78 72.62 1.09 2.56 74.15 +H09 1780 10.32 67.25 1.91 3.05 82.88 +H10 2262 7.84 52.43 2.25 3.01 78.92 +H11 2130 12.63 80.47 0.47 3.17 96.52 +H12 2404 9.57 63.89 1.87 3.07 87.48 +H13 1872 10.9 70.78 1.23 3.15 91.34 +H14 2598 9.23 63.01 1.31 2.65 76.86 +H15 2164 10.57 72.87 1.06 2.74 78.64 +H16 2475 9.77 66.87 0.73 2.86 90.95 +H17 1783 11.15 72.74 0.67 2.97 88.69 +H18 2114 9.08 60.83 1.32 2.87 84.31 +H19 2621 7.59 49.83 3.13 2.69 81.29 +H20 2623 7.95 53.49 2.06 2.34 68.36 +H21 1954 10.2 66.27 1.64 2.5 78.56 +H22 2356 9.53 62.82 1.57 3.31 99.15 +H23 8 26 100 0 3.25 139 +H24 1421 7.88 47.64 4.93 1.98 78.52 +I01 2071 12.39 78.17 0.43 2.11 61.97 +I02 1366 12.04 75.62 0.88 2.36 65.33 +I03 1769 9.91 63.2 1.19 2.13 56.36 +I04 2389 10.75 70.24 0.63 2.28 65.29 +I05 1983 8 51.49 2.57 2.69 74.38 +I06 2209 9.97 64.46 1.45 2.9 80.24 +I07 2524 9.56 62.08 1.78 3.01 88.14 +I08 1961 11.84 75.68 0.66 3.23 88.78 +I09 1925 11.12 71.27 0.88 2.82 78.49 +I10 2364 10.85 69.42 0.89 3.17 89.68 +I11 1809 12.46 77.34 0.44 2.66 76.47 +I12 2387 10.95 70.38 0.88 3.15 87.18 +I13 2530 12.5 78.42 0.87 3.04 94.74 +I14 2086 12.23 75.6 0.91 3.47 101.93 +I15 2587 10.9 72.59 0.7 2.84 85.07 +I16 2480 12.24 78.15 0.44 3.45 108.16 +I17 1770 12.3 78.25 0.73 3.12 95.09 +I18 1964 8.3 55.09 2.9 3.32 96.99 +I19 1969 10.6 69.78 1.12 3.11 95.42 +I20 2330 8.19 53.22 2.1 3.43 100.06 +I21 1922 8.76 58.27 1.82 3.08 90.8 +I22 2062 11.61 75.12 0.58 3.06 95.76 +I23 2446 9.95 66.39 1.19 2.99 83.27 +I24 1457 9.09 57.79 2.2 3.49 102.71 +J01 1967 13.45 80.22 0.31 2.06 62 +J02 1954 11.02 71.65 1.23 2.08 57.26 +J03 1402 10.14 67.05 0.86 1.75 48.25 +J04 1316 10.69 70.82 0.68 2.08 59.11 +J05 1784 7 45.8 4.37 2.09 58.3 +J06 2557 7.78 52.33 2.66 2.73 77.66 +J07 1753 10.05 66.29 1.43 2.44 71.51 +J08 1844 11.57 75.43 0.98 2.59 73.92 +J09 1670 9.2 61.44 0.78 2.5 65.14 +J10 2427 9.55 64.19 1.03 2.68 75.03 +J11 2011 11.93 77.03 0.2 2.55 73.74 +J12 1973 11.51 74.71 0.91 2.92 82.11 +J13 2276 11.43 74.74 0.66 3 89.39 +J14 2088 11.24 74.47 0.67 2.94 87.12 +J15 2476 10.48 69.35 0.65 2.77 79.58 +J16 2395 10.95 71.9 0.92 3.22 94.31 +J17 2127 11.9 75.6 0.52 2.8 87.35 +J18 2341 9.92 66.21 0.94 3.11 93.03 +J19 1800 13.06 81.61 0.61 2.54 82.49 +J20 2368 8.52 56.88 1.56 2.67 79.25 +J21 2387 7.99 50.98 2.51 2.99 88.09 +J22 2309 10.5 70.12 0.52 2.64 80.93 +J23 822 8.44 55.6 2.68 3.41 88.31 +J24 1434 11.4 69.67 0.49 2.56 75.84 +K01 2652 8.11 53.96 1.58 1.72 47.85 +K02 209 14.67 84.69 0.96 1.77 51.87 +K03 2838 6.24 38.51 4.33 1.85 52.13 +K04 3001 9.71 65.98 1.03 1.95 56.69 +K05 2873 7.73 52.52 2.89 1.97 54.93 +K06 2327 7.32 47.53 3.52 2.19 61.63 +K07 2870 7.96 54.01 2.37 2.14 62.09 +K08 2914 7.98 53.98 2.16 2.34 64.88 +K09 3239 8.13 55.26 1.82 2.2 59.7 +K10 2663 9.31 62.04 1.05 2.27 60.76 +K11 3009 7.53 49.52 1.5 2.28 62.38 +K12 2521 9.74 65.01 1.19 2.64 71.55 +K13 2470 8.63 58.14 1.74 2.43 68.82 +K14 2648 11.19 73.3 0.6 2.69 79.57 +K15 2692 8.76 58.77 1.63 2.18 64.46 +K16 2915 10.94 72.45 0.51 2.83 83.73 +K17 2653 9.45 64.87 1.39 2.41 73.68 +K18 2661 8.63 57.31 2.37 3.24 86.86 +K19 2647 7.55 49.34 2.34 2.74 82.51 +K20 2221 10.27 69.29 1.44 3.22 93.3 +K21 1987 9.5 63.56 1.56 2.41 70.16 +K22 2557 9.32 60.62 2.11 3.64 108.95 +K23 2367 9.79 65.82 1.31 2.82 81.75 +K24 1498 9.08 58.88 1.94 2.74 86.15 +L01 2370 10.08 67.26 0.97 1.89 53.56 +L02 2240 10.54 68.53 1.12 1.89 56.19 +L03 1355 10.4 68.34 1.11 1.71 48.94 +L04 2608 10.09 67.75 1 2.14 61.59 +L05 2088 8.34 54.21 3.21 2.08 58.54 +L06 2332 9.22 61.62 1.97 2.29 66.29 +L07 1528 9.21 59.95 1.7 2.06 58.84 +L08 2352 9.47 63.95 1.66 2.14 60.65 +L09 2595 9.2 62.62 0.66 2.1 56.05 +L10 2135 8.54 55.64 1.73 2.23 57.12 +L11 2537 8.28 55.54 1.3 2.41 65.07 +L12 2348 11.87 76.11 0.38 2.63 78.84 +L13 2197 9.55 63.63 1.14 2.37 67.98 +L14 2411 10.23 68.56 0.91 2.61 76.71 +L15 2815 8.27 54.03 2.1 2.26 64.29 +L16 2498 8.88 58.93 1.44 2.24 64.05 +L17 2493 9.81 67.19 0.96 2.22 67.86 +L18 2709 8.11 53.78 2.03 2.2 60.62 +L19 2416 8.75 59.89 1.28 2.54 75.84 +L20 2081 10.65 69.1 0.62 2.25 72.08 +L21 2376 10.08 68.9 0.67 2.33 72.37 +L22 1528 7.56 48.3 3.99 2.6 77.79 +L23 2344 12.22 77.05 0.34 2.26 68.61 +L24 1646 9.04 58.81 1.7 1.8 55.4 +M01 2012 9.29 60.04 1.79 2.3 65.75 +M02 1813 11.41 72.31 0.77 2.2 66.88 +M03 1962 9.57 60.14 2.14 2.43 73.04 +M04 1816 11.38 72.91 0.88 2.07 66.33 +M05 2155 8.49 55.96 3.62 2.4 76.36 +M06 1993 11.24 75.01 0.85 1.94 63.19 +M07 2175 10.08 64.69 1.52 2.39 70.2 +M08 2309 10.12 67.43 1.17 2.16 65.42 +M09 2005 8.1 53.27 2.49 2.33 64.79 +M10 2786 9.29 62.1 1.4 2.45 66.01 +M11 2191 10.62 70.61 0.46 2.43 69.75 +M12 2571 10.68 70.48 0.51 2.23 66.84 +M13 2492 10.03 65.85 0.88 2.33 70.78 +M14 2326 10.11 66.38 0.86 2.51 73.36 +M15 2134 9.57 63.96 1.73 2.41 70.35 +M16 2637 9.38 63.56 1.63 2.36 68.77 +M17 2058 9.33 60.74 1.65 2.36 68.1 +M18 2428 9.96 65.98 0.66 2.42 72.35 +M19 1955 10.45 67.88 0.82 1.96 58.52 +M20 2349 8.09 53.34 2.68 2.76 83.89 +M21 2413 9.06 60.92 1.41 2.12 66.1 +M22 2398 10.66 71.18 0.75 2.4 73.38 +M23 2369 9.28 60.57 1.1 2.22 65.44 +M24 1753 7.99 52.48 2 2.31 73.49 +N01 2349 9.7 62.96 1.23 2 54.24 +N02 1100 9.78 65.64 1.91 2.11 59.64 +N03 1959 11.19 70.7 1.07 2.13 63.27 +N04 2547 9.07 60.35 1.53 2.17 60.21 +N05 1861 6.58 41.91 5.59 2.15 58.81 +N06 2667 7.91 50.69 3.11 2.25 62.86 +N07 2841 7.86 52.34 1.9 2.25 59.96 +N08 2090 9.2 60.53 2.11 2.45 68.68 +N09 2292 10.12 67.32 0.96 2.14 56.57 +N10 1988 8.68 57.8 1.51 2.37 60.56 +N11 1850 9.76 63.3 1.08 2.16 58.67 +N12 2692 9.25 62.33 0.74 2.27 62.41 +N13 2556 8.4 54.3 2.58 2.69 77.77 +N14 2718 6.73 42.9 3.42 2.63 70.67 +N15 1790 10.56 70.06 0.78 2.5 71.66 +N16 2357 10.09 68.65 0.89 2.38 71.39 +N17 1855 11.31 73.75 0.65 2.26 69.82 +N18 2912 9.07 61.81 1.17 2.43 70.12 +N19 2774 8.88 59.7 1.95 2.7 80.08 +N20 2244 7.66 51.16 3.03 2.61 72.69 +N21 2607 6.2 38.59 4.99 2.53 74.74 +N22 1606 10.13 66.63 1 2.57 75.63 +N23 2548 10.1 69.31 0.82 2.3 69.19 +N24 1885 8.58 57.93 1.86 2.42 76.91 +O01 2211 7.97 50.11 4.84 2.51 75.51 +O02 1992 10.62 66.16 2.11 1.97 57.64 +O03 2127 9.32 59.43 3.57 2.23 66.12 +O04 2209 11.3 71.57 0.91 2.08 62.99 +O05 2659 9.12 61.34 1.32 1.85 52.69 +O06 2635 8.44 54.99 3.19 2.32 68.44 +O07 2715 9.04 59.08 1.73 2.07 59.75 +O08 2380 8.6 58.24 1.39 2.08 54.5 +O09 2660 9.1 60.45 1.39 2.11 57.22 +O10 2754 9.46 63.62 1.6 2.16 59.51 +O11 2441 10.22 66.41 1.31 2.14 62.51 +O12 2149 10.7 68.96 1.07 1.98 56.79 +O13 1852 9.47 60.21 2 2.11 62.8 +O14 2402 10.61 68.53 0.67 2.25 70.24 +O15 2391 10.34 69.97 1.21 2.42 77.32 +O16 2544 9.71 62.62 1.42 2.23 65.64 +O17 2212 9.12 60.53 1.18 2.18 65.33 +O18 2282 8.64 57.27 2.76 2.5 70.41 +O19 2386 9.37 63.45 1.22 1.86 55.53 +O20 1851 8.95 59.75 1.24 1.93 53.9 +O21 2400 8.57 56.79 2.29 2.2 66.64 +O22 2414 9.52 63.92 1.33 2.3 66.6 +O23 2636 8.44 55.54 2.2 2.27 64.76 +O24 2115 6.49 40.28 4.4 2.68 77.69 +P01 1588 4.5 24.5 12.59 2.79 86.44 +P02 2169 5.6 32.6 6.22 2.01 52.67 +P03 1924 7.28 47.97 2.86 1.75 47.57 +P04 2189 7.91 50.57 2.7 1.82 51.07 +P05 1911 8.01 52.8 1.88 2.06 51.74 +P06 2083 7.87 51.32 2.4 1.85 48.44 +P07 2465 4.52 23.85 11.03 2.38 67.92 +P08 2061 6.89 43.81 3.93 2.19 57.17 +P09 2394 8.75 56.27 1.71 1.8 48.47 +P10 2095 8.88 59 1.53 2.14 56.81 +P11 2744 8.51 57.14 1.38 2.14 59.91 +P12 2863 8.12 55.4 1.5 1.96 52.69 +P13 2294 8.23 55.32 1.96 2.09 55.48 +P14 2386 7.09 45.52 2.1 2.21 60.22 +P15 1721 8.98 61.13 1.57 2.24 61.47 +P16 2550 6.79 43.37 2.59 2.23 60.22 +P17 2533 7.36 48.28 2.09 2.3 65.8 +P18 2539 8.56 57.74 1.61 2.16 59.73 +P19 2234 7.78 50.31 2.69 1.92 53.58 +P20 2680 8.03 53.66 1.34 2 56.58 +P21 2361 9.24 61.54 0.93 1.99 57.69 +P22 2209 8.39 56.81 1.54 1.74 49.86 +P23 2365 6.57 41.31 4.02 2.1 56.17 +P24 1448 2.74 10.29 26.1 1.98 67.63 diff -r 000000000000 -r 2aafe60f2fad test-data/150615-HR-12015-01A.tabular --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/test-data/150615-HR-12015-01A.tabular Wed Jun 01 03:55:27 2016 -0400 @@ -0,0 +1,119 @@ +Table_1 + + 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 +A 2215 2811 2226 2528 1827 2337 2233 2462 2790 2792 2547 2629 1655 2647 2300 2030 2124 2461 2273 2281 2412 1331 2245 2037 +B 2184 2104 1639 2467 1818 1769 1654 2199 2043 1329 2533 2712 1824 2718 2443 2061 2088 2730 2279 2371 2114 2355 1154 1646 +C 2356 2680 2305 2510 2650 2918 2618 2654 2828 2877 2441 2870 3202 2619 2716 2413 2893 2669 2272 2161 2677 2406 2494 1760 +D 2206 1033 1744 2579 1921 2352 1844 2831 1803 2531 1942 2653 2624 2777 2523 2532 2243 2653 1806 2502 2355 2036 4 2056 +E 1953 58 1429 2419 2326 2281 2524 2444 2402 2470 2387 2812 2121 2467 1932 2207 866 1665 1668 1942 2717 1995 2686 1711 +F 2647 1866 2327 1831 2081 2360 2465 2561 2242 2595 2601 2075 2452 2506 2228 2869 1322 2712 2623 2320 2528 1797 1933 1759 +G 2715 2567 2346 2536 2157 2549 2368 2798 2595 3309 2701 2916 2664 2998 2257 2850 2559 2684 2852 2779 2448 2741 2945 1740 +H 2214 11 1344 1937 2130 2637 2278 2020 1780 2262 2130 2404 1872 2598 2164 2475 1783 2114 2621 2623 1954 2356 8 1421 +I 2071 1366 1769 2389 1983 2209 2524 1961 1925 2364 1809 2387 2530 2086 2587 2480 1770 1964 1969 2330 1922 2062 2446 1457 +J 1967 1954 1402 1316 1784 2557 1753 1844 1670 2427 2011 1973 2276 2088 2476 2395 2127 2341 1800 2368 2387 2309 822 1434 +K 2652 209 2838 3001 2873 2327 2870 2914 3239 2663 3009 2521 2470 2648 2692 2915 2653 2661 2647 2221 1987 2557 2367 1498 +L 2370 2240 1355 2608 2088 2332 1528 2352 2595 2135 2537 2348 2197 2411 2815 2498 2493 2709 2416 2081 2376 1528 2344 1646 +M 2012 1813 1962 1816 2155 1993 2175 2309 2005 2786 2191 2571 2492 2326 2134 2637 2058 2428 1955 2349 2413 2398 2369 1753 +N 2349 1100 1959 2547 1861 2667 2841 2090 2292 1988 1850 2692 2556 2718 1790 2357 1855 2912 2774 2244 2607 1606 2548 1885 +O 2211 1992 2127 2209 2659 2635 2715 2380 2660 2754 2441 2149 1852 2402 2391 2544 2212 2282 2386 1851 2400 2414 2636 2115 +P 1588 2169 1924 2189 1911 2083 2465 2061 2394 2095 2744 2863 2294 2386 1721 2550 2533 2539 2234 2680 2361 2209 2365 1448 + +Table_2 + + 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 +A 8.88 8.61 10.96 9.35 11.87 8.69 9.7 8.48 9.5 9.19 9.51 9.47 11.8 8.27 11.5 11.71 9.78 9.14 8.68 10.62 10.49 10.72 9.88 8.13 +B 10.31 9.33 11.13 9.84 11.75 9.08 12.22 10.04 8.74 11.6 7.31 9.31 10.83 7.68 10.4 11.82 10.83 10.36 8.09 12.37 10.49 9.84 11.75 7.49 +C 9.67 10.27 8.51 9.55 10.23 9.76 8.28 9.56 8.44 9.48 9.78 7.1 9.02 8.63 8.82 10.72 8.18 9.82 10.81 9.42 8.75 9.91 7.54 7.85 +D 7.2 10.08 7.58 8.78 9.41 9.68 8.86 8.45 9.59 9.03 7.37 9.72 6.77 6.68 8.53 9.9 9.92 11.31 11.24 11.17 9.81 11.95 19.75 7.06 +E 7.89 10.38 11 9.41 9.41 9.32 7.92 9.17 9.13 9.23 9.57 9.54 9.11 8.67 6.3 9.54 11.03 8.31 11.19 10.59 10.46 9.92 8.98 8.25 +F 8.61 10.14 7.3 6.3 8.89 9.29 8.21 7.36 9.81 6.08 8.19 9.72 9.25 8.22 8.19 7.83 8.78 7.56 9 9.37 9.04 6.44 10.26 8.4 +G 10.83 11.22 8.73 7.29 8.33 6.64 9.22 9.61 8.97 6.57 7.84 7.37 9.26 7.58 9.19 10.29 7.88 8.49 7.68 7.11 9.83 7.4 10.08 6.25 +H 12.71 19.73 10.4 7.72 9.08 8.69 10.21 10.78 10.32 7.84 12.63 9.57 10.9 9.23 10.57 9.77 11.15 9.08 7.59 7.95 10.2 9.53 26 7.88 +I 12.39 12.04 9.91 10.75 8 9.97 9.56 11.84 11.12 10.85 12.46 10.95 12.5 12.23 10.9 12.24 12.3 8.3 10.6 8.19 8.76 11.61 9.95 9.09 +J 13.45 11.02 10.14 10.69 7 7.78 10.05 11.57 9.2 9.55 11.93 11.51 11.43 11.24 10.48 10.95 11.9 9.92 13.06 8.52 7.99 10.5 8.44 11.4 +K 8.11 14.67 6.24 9.71 7.73 7.32 7.96 7.98 8.13 9.31 7.53 9.74 8.63 11.19 8.76 10.94 9.45 8.63 7.55 10.27 9.5 9.32 9.79 9.08 +L 10.08 10.54 10.4 10.09 8.34 9.22 9.21 9.47 9.2 8.54 8.28 11.87 9.55 10.23 8.27 8.88 9.81 8.11 8.75 10.65 10.08 7.56 12.22 9.04 +M 9.29 11.41 9.57 11.38 8.49 11.24 10.08 10.12 8.1 9.29 10.62 10.68 10.03 10.11 9.57 9.38 9.33 9.96 10.45 8.09 9.06 10.66 9.28 7.99 +N 9.7 9.78 11.19 9.07 6.58 7.91 7.86 9.2 10.12 8.68 9.76 9.25 8.4 6.73 10.56 10.09 11.31 9.07 8.88 7.66 6.2 10.13 10.1 8.58 +O 7.97 10.62 9.32 11.3 9.12 8.44 9.04 8.6 9.1 9.46 10.22 10.7 9.47 10.61 10.34 9.71 9.12 8.64 9.37 8.95 8.57 9.52 8.44 6.49 +P 4.5 5.6 7.28 7.91 8.01 7.87 4.52 6.89 8.75 8.88 8.51 8.12 8.23 7.09 8.98 6.79 7.36 8.56 7.78 8.03 9.24 8.39 6.57 2.74 + +Table_3 + + 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 +A 55.62 57.35 70.4 61.59 73.78 58.49 63.41 57.39 62.83 60.67 61.76 60.94 71.24 52.13 72.17 71.63 63.89 59.65 57.85 70.58 69.86 69.65 66.24 53.26 +B 65.29 57.94 69.68 64.33 75.25 57.32 75.7 68.58 59.03 73.06 47.06 61.98 68.42 49.74 68.81 77.1 70.69 70.4 54.28 78.28 71.85 66.71 72.1 50.12 +C 64.43 67.57 55.88 63.55 67.96 64.98 55.39 65.3 57.39 64.75 65.38 47.04 59.93 57.43 58.73 71.07 56.14 66.62 71.79 63.4 59.62 65 49.44 51.99 +D 45.01 62.25 49.14 59.83 64.08 63.95 59.06 56.55 63.67 59.9 48.51 66.34 43.52 43.03 58.7 66.11 66.79 76.1 73.26 74.5 67.22 77.65 100 45.82 +E 52.02 67.24 70.89 61.06 62.64 61.03 52.61 62.19 60.95 60.89 63.3 64.76 60.68 58.25 39.23 63.57 69.98 55.56 72.96 70.19 69.82 67.27 60.65 53.71 +F 56.89 66.4 46.41 39.16 57.33 62.12 54.36 49 66.77 37.5 54.48 63.04 62.11 53.79 53.82 52.49 60.14 50 60.62 62.5 59.53 39.96 67.36 56.17 +G 72.08 71.76 57.37 46.77 54.38 41.66 61.15 63.44 59.73 42.16 53.05 49.04 63.48 51.17 63.14 70.53 52.25 55.48 50.25 45.88 67.28 48.23 70.12 38.91 +H 78.73 90.91 65.77 49.3 60.19 56.16 67.08 72.62 67.25 52.43 80.47 63.89 70.78 63.01 72.87 66.87 72.74 60.83 49.83 53.49 66.27 62.82 100 47.64 +I 78.17 75.62 63.2 70.24 51.49 64.46 62.08 75.68 71.27 69.42 77.34 70.38 78.42 75.6 72.59 78.15 78.25 55.09 69.78 53.22 58.27 75.12 66.39 57.79 +J 80.22 71.65 67.05 70.82 45.8 52.33 66.29 75.43 61.44 64.19 77.03 74.71 74.74 74.47 69.35 71.9 75.6 66.21 81.61 56.88 50.98 70.12 55.6 69.67 +K 53.96 84.69 38.51 65.98 52.52 47.53 54.01 53.98 55.26 62.04 49.52 65.01 58.14 73.3 58.77 72.45 64.87 57.31 49.34 69.29 63.56 60.62 65.82 58.88 +L 67.26 68.53 68.34 67.75 54.21 61.62 59.95 63.95 62.62 55.64 55.54 76.11 63.63 68.56 54.03 58.93 67.19 53.78 59.89 69.1 68.9 48.3 77.05 58.81 +M 60.04 72.31 60.14 72.91 55.96 75.01 64.69 67.43 53.27 62.1 70.61 70.48 65.85 66.38 63.96 63.56 60.74 65.98 67.88 53.34 60.92 71.18 60.57 52.48 +N 62.96 65.64 70.7 60.35 41.91 50.69 52.34 60.53 67.32 57.8 63.3 62.33 54.3 42.9 70.06 68.65 73.75 61.81 59.7 51.16 38.59 66.63 69.31 57.93 +O 50.11 66.16 59.43 71.57 61.34 54.99 59.08 58.24 60.45 63.62 66.41 68.96 60.21 68.53 69.97 62.62 60.53 57.27 63.45 59.75 56.79 63.92 55.54 40.28 +P 24.5 32.6 47.97 50.57 52.8 51.32 23.85 43.81 56.27 59 57.14 55.4 55.32 45.52 61.13 43.37 48.28 57.74 50.31 53.66 61.54 56.81 41.31 10.29 + +Table_4 + + 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 +A 2.57 1.07 0.54 1.66 0.66 1.07 1.07 1.06 1.65 1.9 1.33 2.09 0.85 2.15 0.57 0.74 1.13 1.83 0.97 0.7 0.46 0.68 0.4 1.42 +B 0.87 3.09 0.55 0.77 0.66 2.43 0.6 0.73 1.22 0.68 3.83 2.06 1.54 4.01 1.02 0.39 0.62 0.81 1.14 0.25 0.85 0.72 0.35 1.82 +C 1.02 0.82 1.56 1 0.3 0.69 1.26 1.09 1.34 1.32 1.47 3.69 1.72 2.1 1.18 0.33 1.52 0.67 0.79 1.2 0.78 0.71 2.33 1.82 +D 2.77 1.84 3.04 1.2 0.94 2.3 2.11 1.77 1.22 1.78 3.24 1.43 4.54 5.47 1.43 0.87 0.76 0.45 0.44 0.48 0.85 0.29 0 1.9 +E 2.36 6.9 0.91 1.2 1.25 2.59 2.73 1.51 1.5 1.94 1.59 1.21 2.22 1.34 5.64 1.54 0.81 2.34 0.66 0.46 0.44 1.45 1.19 1.81 +F 1.44 0.91 4.08 6.66 2.4 2.54 2.92 2.89 1.43 6.2 3.65 1.59 1.51 2.04 2.65 1.92 1.97 3.39 1.03 1.51 1.15 4.67 0.93 1.99 +G 0.59 0.51 1.49 4.89 2.23 5.1 1.35 1.18 1.93 3.84 2.3 3.19 1.73 2.94 1.2 1.09 2.34 2.72 3.54 3.17 0.69 3.1 0.75 3.33 +H 0.36 0 1.86 3.1 1.41 1.71 1.14 1.09 1.91 2.25 0.47 1.87 1.23 1.31 1.06 0.73 0.67 1.32 3.13 2.06 1.64 1.57 0 4.93 +I 0.43 0.88 1.19 0.63 2.57 1.45 1.78 0.66 0.88 0.89 0.44 0.88 0.87 0.91 0.7 0.44 0.73 2.9 1.12 2.1 1.82 0.58 1.19 2.2 +J 0.31 1.23 0.86 0.68 4.37 2.66 1.43 0.98 0.78 1.03 0.2 0.91 0.66 0.67 0.65 0.92 0.52 0.94 0.61 1.56 2.51 0.52 2.68 0.49 +K 1.58 0.96 4.33 1.03 2.89 3.52 2.37 2.16 1.82 1.05 1.5 1.19 1.74 0.6 1.63 0.51 1.39 2.37 2.34 1.44 1.56 2.11 1.31 1.94 +L 0.97 1.12 1.11 1 3.21 1.97 1.7 1.66 0.66 1.73 1.3 0.38 1.14 0.91 2.1 1.44 0.96 2.03 1.28 0.62 0.67 3.99 0.34 1.7 +M 1.79 0.77 2.14 0.88 3.62 0.85 1.52 1.17 2.49 1.4 0.46 0.51 0.88 0.86 1.73 1.63 1.65 0.66 0.82 2.68 1.41 0.75 1.1 2 +N 1.23 1.91 1.07 1.53 5.59 3.11 1.9 2.11 0.96 1.51 1.08 0.74 2.58 3.42 0.78 0.89 0.65 1.17 1.95 3.03 4.99 1 0.82 1.86 +O 4.84 2.11 3.57 0.91 1.32 3.19 1.73 1.39 1.39 1.6 1.31 1.07 2 0.67 1.21 1.42 1.18 2.76 1.22 1.24 2.29 1.33 2.2 4.4 +P 12.59 6.22 2.86 2.7 1.88 2.4 11.03 3.93 1.71 1.53 1.38 1.5 1.96 2.1 1.57 2.59 2.09 1.61 2.69 1.34 0.93 1.54 4.02 26.1 + +Table_5 + + 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 +A 2.91 2.03 2.41 2.14 2.27 1.87 2.32 2.07 2.52 2.38 2.8 2.42 2.3 2.37 2.68 2.66 2.45 2.3 2.32 1.98 2.07 1.97 2.17 2.06 +B 2.33 2.44 2.03 2.03 1.97 2.29 2.14 2.43 1.96 2.04 3.01 2.49 2.45 2.54 2.64 2.53 2.22 2.39 1.98 2.23 2.32 2.04 2.35 2.11 +C 2.07 2.03 1.87 2.02 1.95 2.21 2.42 2.52 2.21 2.59 2.38 2.87 2.43 2.93 2.46 2.62 2.8 2.26 2.1 2.79 2.04 2.08 2.25 2.15 +D 1.41 2.61 2.4 2.12 2.29 2.6 2.76 2.62 2.81 2.64 3.1 2.77 3.06 3.36 3.13 2.96 3.15 2.67 2.77 2.58 2.69 2.54 1.5 2.27 +E 2.09 2.34 2.09 2.4 2.36 2.88 2.63 2.8 2.6 2.64 2.58 2.61 2.37 2.65 2.89 2.63 2.23 3.14 2.3 2.46 2.22 2.73 2.33 2.43 +F 2.05 1.86 2.04 2.25 2.34 2.41 2.59 2.31 2.47 2.39 2.77 2.47 2.66 2.54 2.91 2.58 2.52 2.68 2.41 2.43 2.2 2.38 2.5 1.92 +G 1.98 1.95 2.13 2.24 2.35 2.59 2.41 2.46 2.4 2.34 2.46 2.61 2.88 2.6 2.49 2.33 2.67 2.69 2.78 2.58 2.52 2.42 2.52 2.19 +H 2.1 2.18 2.36 2.42 2.39 2.34 2.85 2.56 3.05 3.01 3.17 3.07 3.15 2.65 2.74 2.86 2.97 2.87 2.69 2.34 2.5 3.31 3.25 1.98 +I 2.11 2.36 2.13 2.28 2.69 2.9 3.01 3.23 2.82 3.17 2.66 3.15 3.04 3.47 2.84 3.45 3.12 3.32 3.11 3.43 3.08 3.06 2.99 3.49 +J 2.06 2.08 1.75 2.08 2.09 2.73 2.44 2.59 2.5 2.68 2.55 2.92 3 2.94 2.77 3.22 2.8 3.11 2.54 2.67 2.99 2.64 3.41 2.56 +K 1.72 1.77 1.85 1.95 1.97 2.19 2.14 2.34 2.2 2.27 2.28 2.64 2.43 2.69 2.18 2.83 2.41 3.24 2.74 3.22 2.41 3.64 2.82 2.74 +L 1.89 1.89 1.71 2.14 2.08 2.29 2.06 2.14 2.1 2.23 2.41 2.63 2.37 2.61 2.26 2.24 2.22 2.2 2.54 2.25 2.33 2.6 2.26 1.8 +M 2.3 2.2 2.43 2.07 2.4 1.94 2.39 2.16 2.33 2.45 2.43 2.23 2.33 2.51 2.41 2.36 2.36 2.42 1.96 2.76 2.12 2.4 2.22 2.31 +N 2 2.11 2.13 2.17 2.15 2.25 2.25 2.45 2.14 2.37 2.16 2.27 2.69 2.63 2.5 2.38 2.26 2.43 2.7 2.61 2.53 2.57 2.3 2.42 +O 2.51 1.97 2.23 2.08 1.85 2.32 2.07 2.08 2.11 2.16 2.14 1.98 2.11 2.25 2.42 2.23 2.18 2.5 1.86 1.93 2.2 2.3 2.27 2.68 +P 2.79 2.01 1.75 1.82 2.06 1.85 2.38 2.19 1.8 2.14 2.14 1.96 2.09 2.21 2.24 2.23 2.3 2.16 1.92 2 1.99 1.74 2.1 1.98 + +Table_6 + + 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 +A 78.76 63.32 79.41 74.9 79.31 62.34 77.48 67.32 80.57 73.6 84.6 72.34 71.88 72.76 86.26 89.03 81.13 77.14 69.57 65.3 70.27 61.54 66.33 70.05 +B 72.4 79.26 67.42 67.95 68.96 69.18 75.29 73.55 57.65 58.75 95.3 75.2 80.09 81.37 91.33 87.74 74.12 78.69 61.28 78.36 73.66 64.63 65.16 64.74 +C 61.55 60.64 56.38 58.22 59.48 65.35 68.98 75.17 63.59 77.38 73.63 88.54 78.2 95.11 78.45 84.52 83.32 70.88 68.8 79.7 62.52 68.61 63.14 66.92 +D 36.44 77.42 70.59 62.68 70.86 79.33 85.21 78 84.73 75.75 95.33 84.49 101.35 106.95 101.22 89.01 105.74 85.7 90.06 76.4 88.68 82.78 74.25 76.56 +E 64.14 81.33 65.5 69.87 69.72 89.16 78 84.21 78.8 78.64 80.7 83.54 70.04 87.2 91.38 86.13 71.41 93.34 73.16 76.69 72.24 86.76 71.8 78.22 +F 56.86 55.02 60.29 67.66 70.01 77.11 77.73 66.52 72.7 68.73 96.56 72.8 82.33 77.56 103.54 76.14 72.6 81.09 73.71 70.9 65.33 70.58 71.62 67.93 +G 58.65 59.34 61.93 65.72 65.99 78.36 73.63 72.8 68.47 62.92 68.96 72.96 88.03 75.25 71.58 71.99 83.35 83.61 87.58 73.2 77.41 68.04 78.27 65.21 +H 68.06 67.36 69.92 70.48 67.18 68.97 85.95 74.15 82.88 78.92 96.52 87.48 91.34 76.86 78.64 90.95 88.69 84.31 81.29 68.36 78.56 99.15 139 78.52 +I 61.97 65.33 56.36 65.29 74.38 80.24 88.14 88.78 78.49 89.68 76.47 87.18 94.74 101.93 85.07 108.16 95.09 96.99 95.42 100.06 90.8 95.76 83.27 102.71 +J 62 57.26 48.25 59.11 58.3 77.66 71.51 73.92 65.14 75.03 73.74 82.11 89.39 87.12 79.58 94.31 87.35 93.03 82.49 79.25 88.09 80.93 88.31 75.84 +K 47.85 51.87 52.13 56.69 54.93 61.63 62.09 64.88 59.7 60.76 62.38 71.55 68.82 79.57 64.46 83.73 73.68 86.86 82.51 93.3 70.16 108.95 81.75 86.15 +L 53.56 56.19 48.94 61.59 58.54 66.29 58.84 60.65 56.05 57.12 65.07 78.84 67.98 76.71 64.29 64.05 67.86 60.62 75.84 72.08 72.37 77.79 68.61 55.4 +M 65.75 66.88 73.04 66.33 76.36 63.19 70.2 65.42 64.79 66.01 69.75 66.84 70.78 73.36 70.35 68.77 68.1 72.35 58.52 83.89 66.1 73.38 65.44 73.49 +N 54.24 59.64 63.27 60.21 58.81 62.86 59.96 68.68 56.57 60.56 58.67 62.41 77.77 70.67 71.66 71.39 69.82 70.12 80.08 72.69 74.74 75.63 69.19 76.91 +O 75.51 57.64 66.12 62.99 52.69 68.44 59.75 54.5 57.22 59.51 62.51 56.79 62.8 70.24 77.32 65.64 65.33 70.41 55.53 53.9 66.64 66.6 64.76 77.69 +P 86.44 52.67 47.57 51.07 51.74 48.44 67.92 57.17 48.47 56.81 59.91 52.69 55.48 60.22 61.47 60.22 65.8 59.73 53.58 56.58 57.69 49.86 56.17 67.63