User 8f0e0cac1a
06-09-2012 19:14:58
Hi, I would like to export structure/data for generating a graph in Excel. Because I test same compounds in many assays, I get this type of Exel file after I export.
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAh0AAALiCAIAAADyxvN8AAAgAElEQVR4nO3dW5bquBKE4ZoWE2I6NRsGU5ex0A+9C1tS6GLZxlLm/y1eDgVuzlrKHYCx4uNp1NfP71mH/v68fTS6fX73HP3+OON1AxucOEEw7evn9+Pr55cbN27cuHE76vZxdbad5Yt3W8AOTBD6kCsANCYIfcgVABoThD5ucmV1pn11Svx1b3KaPDp3rp/eRp/k7z0xH72wx33HDwSAEpErfXPBL1GccZIrj/tr3T/ur3+CX/eu/rw8fnWXfnqrI4cqfGHfn7fXi0n+PwA7JbnSOReP+443UpiQj1x53Fdr/vXP/Ore1T/9/78Du93vSxjopzc7KFfECwsErxLYb50r/XPxuH/cbnxeccVHrgT+3mQFg7CMyPfj8f0sjMn2zwX5ifv+vH0E2fb///j+vN0+P+/R9wvlF7b+6AIcIsiVzrn4/rzdH3wP5oy7XFn+/c3kyupxB/3zLc+vrN7zyU9Pf49Ivl9IX9i/45MqOFj9/Mr6brUAvz9vt89vzq944ytXvj9v4cmJbbkSPL1dZai+P28f93v2K4X42bmjcX4FR2vMlfxcPO7iPRzsc5QrwZdOz825Ej+9XXWo4tOa4ROil1b6IoKPLDhSS64U5uJxX5+0JFcc8ZIr6i2VPm+/esJyT+cnFXWoxOP+cft8ZD+itH5eIVdwtGquFOdi+Qn87h/XYzI+ciXz7W/+d8bh/Ow8J17KlfB0z99PB1ZvAZOXtj7a+o//vskGDlPJlfa54POKMy5yJX3jtP6HuXpdZP7pbTKbH98f0Un519dhf2dc5OWO4g0j7wVxinKu5OZCfHAmV5xxkSuzYQoxhGknCBcjVwZErmAI004QLkaudKHXCw6QK+hDrgDQmCD0IVcAaEwQ+pArADQmCH3IFQAaE4Q+bnLFaq/XcnCuisTBKtdFJhewiCW4XvyvP+tFy1K2w0muGO31Wr2wXTvNAEqt1yv6S+b++G69aJfBovJhfj5yxWqvV3nrTGCfSq/XIruZdu3a+9ffWb2m+MiVgKVer3BXDQYTh2rs9cp/wJCb1qlFyyVbtrjLFXO9Xn9HJ1RwtLb+lUIm/Ksgzp5Ked332tR717lHjMJXrpjr9Qq/lGYecaimXCks7+Bd2OtMi1q0j/tHcNqTd0lzc5QrBnu9OL+CM7X2ejW9n/lbn3LR7jyFicF4yRWbvV7kCs7UkivNy66YK8Ulj+n4yBWrvV7R0xlGHKohV4oZoHvn9KJd8mn7L2MwGhe5YrjXi4vJcJ6GXBEfV9Z3VS5HzlwXSarMzkWuzIbvATCEaScIFyNXBkSuYAjTThAuRq50odcLDpAr6EOuANCYIPQhVwBoTBD6kCsANCYIfcgVABoThD5ucsVqrxdwmsbrIrPruVz8xUq2y0muWO31Ak5U7fUq7VgR0TPGSrbJR65Y7fUCzlTr9SrusBdQqXK7sZKt8pErAUu9XsCJKr1ezdueJhvsfX/e7g9Wsl3ucsVcrxdwlsr5ldZcEedkbp/frGTDfOWKuV4v4ETH5Eq6VSXdw9Y5yhWDvV7AmQ7JlWjBvmojWcmGeckVm71ewJlqvzNuOm8fBk5aOsFqNshHrpjt9QJOVL1+peF3xuVfrbCSbXKRK5Z7vYDTtPV6xTORfEBpPO8CO1zkymwYOAxh2gnCxciVAZErGMK0E4SLkStd6PWCA+QK+pArADQmCH3IFQAaE4Q+5AoAjQlCH3IFgMYEoY+bXKHXC9gomKDlMq5oM6Tygl4eIZ+243pjjMtJrtDrBWymd6xYpqE+F8vdqyPIO2GJj1yh1wvYLt9gdPv8bpkLebF9qakFNvjIlQC9XkCTSoNRQM2FXKssYAfc5Qq9XkCjeIL+rWQxAHouXlt1r5e8vBO2+MoVer2AdvoTv9xiW67Jx/3jIzmpIu+ELY5yhV4vYJPK+ZXn81meC3kCZufZSszAS67Q6wVsVc2VylzIhVxc3bDBR67Q6wVsF/yicj0Ozb8SXiIo/E1ybnXDBhe5Qq8X0CH5xB+fgJdzEX5xuzxPXmbMUjbJRa7MhujAEKadIFyMXBkQuYIhTDtBuBi50oVeLzhArqAPuQJAY4LQh1wBoDFB6EOuANCYIPQhVwBoTBD6DJwrr3Pj8S4myRnxTEuQuV4v2pDwVvUJkmVfa4U1q3aSiB8q510/HQMZNlfC7p/1Pl7xWlqu2Y12lTDW60UbEt6sMkG67GstO5vPZFc8vbzFvOunYyij5kpmU0hRCZTfPtJWrxdtSHi32gStqfVZ2Nr1cf+43UobvxbuFU/HWObKldfORJmHhsvQVK8Xn/rxdpUJWsl8hM7N5vfn7f6It+BLl7ecd/V0DGbUXIk/QS+fMG6Fsy7hIjTV60UbEt6uqS8yX/a1/nO0Zdjt8zsYMb289byLp2Mww+bKekH+bSIfrOjXN6/hF7P6/Mr6kHP2etGGhLerTNBa/vxKMpuPe/rGTi7v3LyL94UYy8C5spDfsv7d2XJ+5fl8zt7rRRsS3q4yQYHW8yvLmfjk80rL+Rv9dAxmhlzRC2hbrqj3WVP1etGGhLerTdBaY66km+unJzsLuZJ5OgYzbK6o7h9ZLhSdMZHfg2XOiszV60UbEt6sMkF6Hteys/n3x/hjeXDY8vF5czWwYXNldcmVLAnSFy3q6yKt9HotB2Ke8AbVCcpdK6kubNxwXWTwyaVhQjGagXNlt2l3oWBiMIRpJwgXI1cGRK5gCNNOEC5GrnTJfLWl0OuFWZEr6PP18/vx9fPLjRs3bty4HXXj8woAgQlCH3IFgMYEoQ+5AkBjgtDHTa5Urnyp/Tq+9EP6Gn2S/6Cr96vFSkAvkSvZi06K65lfojjjJFcs9HqJF7a+CpqL8HG0JFeiuSjuWJF/FszzkSsWer3UCwtQ/IWDfcX7g0XLr7jDXvZZsM9HrgTm7PWqvbCde5gBqSBX0uVX3hE89yw44C5XZu31KrywSrES0KlyfqUhV8Sz4ICvXJm416t6NM6v4GjkCvo4ypW5e73qR+P8Cg5GrqCPl1yZvterfjRyBQer/c64ft5ePQv2+cgVE71e4mj1YiWgX/X6lbbfGZMr7rjIFSu9XvELC4/N3OJgDddFigkSH5zJFWdc5MpsmEIMYdoJwsXIlQGRKxjCtBOEi5ErXej1ggPkCvqQKwA0Jgh9yBUAGhOEPuQKAI0JQh9yBYDGBKGPm1yx2uu1HJyrInGw+vUr1bmQD5BldOsxYS1PzkmuGO31Wr2wXTvNAEqt16s6F+oBuTK6x531a4aPXLHa69W+8R+wXaXXqzoX9cFZHsHytcRHrgQs9XqFu80wlzhUpdcrUJ2LzCZ8y554LF873OWKuV6vv6MzlThaw/5gq7uLKzB+QFxG97h/3G43zq4Y4StXzPV6LanD+RUcrjFXqmsv+4DXu6ogdjjTMj1HuWKw14vzKzhTS65U56L4ALloWcnT85IrNnu9yBWcqZor/Z9U/iFXbPKRK1Z7vaKn8+0BDtXQQ7zppMrz+cyU0dFQZ4uLXDHc68V1kThPOVdyc/H6uJF7gLxWkoY6S1zkymzYJx9DmHaCcDFyZUDkCoYw7QThYuRKF3q94AC5gj7kCgCNCUIfcgWAxgShD7kCQGOC0IdcAaAxQejjJles9noBp2nYxyU/QdHfZYUX11wZ5SRXrPZ6ASeq9XoVd6wI/r7eDyLcLJW1bJGPXLHa6wWcqdLrVd5hL77z78FsaueAj1wJWOr1Ak5U6fWqJ4TqnSNXHHCXK+Z6vYCzNOw7WU2ItHcu+nKM1WyQr1wx1+sFnGh3rmR655asebCaTXKUKwZ7vYAz7c2VpuDhezCDvOSKzV4v4Ey13xl3nbfPPgB2+MgVs71ewImq16/Ufmcse+eWgNn+GxjMwUWuWO71Ak7TcF2kmKDkZ/nJQn49ie/AjHKRK7MhOjCEaScIFyNXBkSuYAjTThAuRq50odcLDpAr6EOuANCYIPQhVwBoTBD6kCsANCYIfcgVABoThD5ucoVeL2CjyvUryYVd4jcq68X/+vPyRC5gsclJrtDrBWxW7fUK/5K5X+xk8TdBXHBvlI9codcL2K7W6/WSzYfavpLsO2mTj1wJ0OsFNKn0er3+lN0/7/vzVoqNnRvvYVjucoVeL6BRw/5g+q4/j/vH7XZTp1L+DQWpYpOvXKHXC2jXlCuFBRm8C0vPtHB+xSxHuUKvF7BJS640r0d6vRzxkiv0egFbteRKczKQK474yBV6vYDtGnKluBzXi/d1Cl/eCVtc5Aq9XkCHtl6veIWu75LXE++5yBhTcJErsyE6MIRpJwgXI1cGRK5gCNNOEC5GrnSh1wsOkCvoQ64A0Jgg9CFXAGhMEPqQKwA0Jgh9yBUAGhOEPgPnyuvceLyLSXJGXD7SYK/XciAuJsMb1K9fqTZ06QeouUunuNwbJn/dwk9exjBsriyXDMb7eMXLJvNIc71e4f9PkgWnq/R6VRu6Mg9Qc5ed4tV/OR3RdGemvndsONiouZLZFFJc3ZvfPtJWrxc7KeHdmnu9ng3r8/UANXflTWBlqtxuyQ5+tN6NYq5cUdsJteRKYM5eLz7g4+0ae72eDR+hK71HxVxJDv79ebs/op1hab0byai5svrne9VyJWuC5COfT2O9Xq9dj3tPzgBbNfevFE/5RQ/Qc5edYrnV5e3zm/MrIxs2V5Z/jpdN5HM1Qekjn8+nsV6vx/0jOC/Ed2I4XVtf5PP5bPgY/3pAbu4yUyx2uiychyFXxjBwrizamxtK34PN3eu18xwPsN2GXGk/v1I5lRLfmf4AbXUilFwZ1Ay5kv2BSPlci61eL3UfcKpTcqU8d8md4XHTzor03R+Tcb1hcyX4DdjqXMPqW6zkN2LRZ3FjvV7Z/5/AOSq5Um3oyjwg8ztjubrLP3rh88qghs2V1VuT6Lur9G2KeuTTYK/XciBGB29Q/bwi57Ha66XnTk9x/mMQuTKwgXNlt2l3oWA4MIRpJwgXI1cGRK5gCNNOEC5GrnTJfLWl0OuFWZEr6PP18/vx9fPLjRs3bty4HXXj8woAgQlCH3IFgMYEoQ+5AkBjgtDHTa7oH9K/7q39ED7zO/wm+iT/QVfvV4uVgF7kCvo4yRULvV7ihWV6k4BDkCvo4yNXLPR67S9WArYhV9DHR64E5uz12l2sBGxFrqCPu1yZtder8MKqxUpAF3IFfXzlysS9XtWjcX4FRyNX0MdRrszd61U/GudXcDByBX285Mr0vV71o5ErOBi5gj4+csVEr5c4WrVYCdiBXEEfF7lipdcrfmHhsTm5goORK+jjIldmwz75GMK0E4SLkSsDIlcwhGknCBcjV7rQ6wUHyBX0IVcAaEwQ+pArADQmCH3IFQAaE4Q+5AoAjQlCHze5YrXXazk4V0XiYGGu1Jaa/ru6lzI665zkitFer9UL27XTDKCsc2VZ+Hr7Cb0UxbMoo3PAR65Y7fUqb50J7BO+MyuuLr0Uq2uSRWuTj1wJWOr1CnebYUJxqHCHvfKqV0ux9izK6Kxylyvmer3+js584mjRJ/5H9mzk/5KlWHgWZXSm+coVc71e4dfXfFWNQwW5EpyW1OdX4qVYfRbnV4xylCsGe704v4Iz1c5QrsilWD8xyaK1yUuu2Oz1Ildwpsz5leZcqT6LRWuUj1yx2usVPZ2vFHCo6HfGuSX5fD5zS1E8izI6B1zkiuFeL66LxHly10Xqz8i16yKDd0Ndk4RZuMiV2bBPPoYw7QThYuTKgMgVDGHaCcLFyJUu9HrBAXIFfcgVABoThD7kCgCNCUIfcgWAxgShD7kCQGOC0MdNrljo9eJaFbyVyJXCb0pey1NevlLu+kquEVtfIpx/Oj9vGZSTXLHQ61UrVgIOluZKvJVd+Jdko/DsnaUyuuXvlaf3DCPewkeuWOj1YiclvFucK4/7x+2mF3N9f7DincF/Yz2KHXtZ4no+ciUwZ68XE4S3S/ZxuT9y63BDhJTK6IKP4vVtVdlnf1DucmXWXq+mYiXgSNGO4LfP75b3W6vlK+98LiNR2fwu9/TVo/kMPyRfuTJxr1e9WAk4WHCGslotvITFqvVB3Jkvo9N1Fckxl7/w/mpQjnJl7l4vvlbG2613BFfnPHJy31lVzq8Uj51uncxbq3F5yZXpe73qFUnAwf4mKG2KKC4/uTxfd+ZzpfTTlPiXNSz/ofnIFRO9XrViJeBgW65fkctT3pkro0sPrZ7OSZUZuMgVK71eoiIJOE81V+KPG8mS1XfqC3zVx5Xk6XuHEW/hIldmw9dcGMK0E4SLkSsDIlcwhGknCBcjV7rQ6wUHyBX0IVcAaEwQ+pArADQmCH3IFQAaE4Q+5AoAjQlCHze5YqHXS70w4DT16yKXy0mKv09h0TrjJFcs9HqpFwacKMmVcPmtL30v7gGRbwODTT5yxUKvl3phwJmSHfYKyy+/uVehDQxG+ciVwJy9XvUXBhwsyJXi8svv2lVsA4NR7nJl1l6v2gsDDte07+S/5Z1NlWIbGGzylSsT93q1Hg04zIb9jPXH+IY2MFjkKFfm7vVqPxpwkL598td3bWkDgx1ecmX6Xq/WowGH2ZcrG9vAYIiPXDHR69VwNOBIlVxZr81/J1IyWLTOuMgVK71e8QsDTlX9vCIvFxbfiLFonXGRK7NhCjGEaScIFyNXBkSuYAjTThAuRq50odcLDpAr6EOuANCYIPQhVwBoTBD6kCsANCYIfcgVABoThD4D58rr3Hiy7WJyt67notcL2KPhusi236hkp2nH5cYY2LC5slwyGK/k5PL03GXz9HoBe1R6veK/5JZldpp2bY+EgY2aK3pTSNkdlN3mi14vYI/mXq9sqohnlfd7hQlT5Yr8Bzq/TOn1AvZo7PUq7J+nnhVukUSsWDRqrsQflj/uj9XOv+t/bzfmCr1eQKO2/YwbVqTalJvTK4YNmyvrtfe3ifzj/hGcG0k/xFRyhV4voF1zX2RtQcaztnprx2K2aOBcWfz9oy/PczTnCr1ewCYtudK0HuPWCc6vGDdDrrwWon4f33Denl4vYLuWXGlKBnLFmWFzZVlw6xPl8t7674zp9QK2a8iVtuWYvFPiezDbhs2V1VVXmesiV+tR13PR6wXs0ZAruta+smi5LtK6gXNlt2l3oSA6MIRpJwgXI1cGRK5gCNNOEC5GrnSh1wsOkCvo8/Xz+/H188uNGzdu3LgddePzCgCBCUIfcgWAxgShD7kCQGOC0MdNrljt9eJSAJymPkHrtV1YgNGiXa4IS57Db1ZMcJIrVnu9qEjCiaoT9HzcWxZdsAHeevcKPXgs4+n5yBWrvV5stYQz1Saobc097h+3W77NaHWA0iMxEx+5ErDU60VFEk5UmaD/F2plzX1/3u6Ppjaj0iMxF3e5Yq7Xi4oknKUyQX+fLwrr71/y6P3Cg2dlH4kJ+coVc71eVCThRA0T9Fq18kzL4y7ewwV/X94/lR+JqTjKFYO9XpxfwZkqExTQGxuvTlqWzq80PBIz8ZIrNnu9yBWcqTZBa+nyS/sl0uf//6yWR2ImPnLFbK8XFUk4UWWC1muzfAp/vWjLz+LzigkucsVyrxfXReI01QmS10pWe71KFxmTKya4yJXZMFsYwrQThIuRKwMiVzCEaScIFyNXutDrBQfIFfQhVwBoTBD6kCsANCYIfcgVABoThD7kCgCNCUIfN7liodeLa1XwViJXctueFjaeTP+u28Dyh5I/ZOHXLQNzkisWer3CPSZJFpwuzZVoK7vamsz0zqk9KguHkmVfNICNzEeuWOj1YvsvvFucK3HvVm1NZvavU0/LH0qWfdEANjYfuRKYs9eLT/14u3CCkt6t+pqUvXNqK7HsoWTZFw1go3OXK7P2er12Pe49OQNsFe1nHPduNa3JtHdOtYFlDiXLvmgAG5+vXJm41+tx/wjOC/GdGE4XnKFM343V16TqnZNtYPpQsuyLBrAJOMqVuXu9dp7jAbZb72csereqa7LeD/R3pzqU/I/SADYFL7kyfa9XsesLOMPfBGV6t6prsj1XxKHkf5QGsDn4yBUTvV7B72mYJpyvev1KbU2q3rlMr1fpUFy/MhsXuWKl12s5EPOEN9h0XaT+YKIudsxcZJxf3uTKbFzkymyYGAxh2gnCxciVAZErGMK0E4SLkStd6PWCA+QK+pArADQmCH3IFQAaE4Q+5AoAjQlCH3IFgMYEoY+bXLHQ66VeGHCa+vUrjXPBBSjOOMkVC71e6oUBJ6r1ejXOhV60FHMZ5iNXLPR6qRcGnKnS69UwF9lFSzGXaT5yJTBnr1f9hQEHq/R6BTIbhOlFSzGXce5yZdZer9oLAw5X6fVaqcwFxVzO+MqViXu9Wo8GHKbS6/WnPhcUcznjKFfm7vVqPxpwkEqv1+uO6lxQzOWMl1yZvter9WjAYSq9Xu1zsSxairlc8JErJnq9Go4GHKly/Ur7XHD9ijMucsVKr1f8woBTlXMlNxeicJhcccZFrsyGgcMQpp0gXIxcGRC5giFMO0G4GLnShV4vOECuoA+5AkBjgtCHXAGgMUHoQ64A0Jgg9CFXAGhMEPoMnCuvc+PJtouNF3bQ6wXsUe/1Ksxj/PfVI/ZME2YwbK4slwyuV3J473oli+4ger2APWq9XoV5XD1CFXr1TxNmMGqu6E0hxZW8z3x3EL1ewB6VXq/MPMbPiB6xc5owg6lyJdf9kCm8otcL2KPS61Vfiv+aVvK2TxNmMGqurBbc0nL12vlXfjPbliv0egGNKr1e5Xn8e8RNnSZ9HZOvwUwaNleWf46XTeQf94/g3EglCej1Avao9HqV5/EZ5UZ8pmVX9wTGNnCuLP7+0S9/M1vLFXq9gE0qvV7bzpQkj+ajil0z5MprxRbfx5dzhV4vYKtKr1d5HmOrU5h8UrFu2FxZVuH61J6+93+FXKHXC9iuev1KaR6jO1+n8Dmp4sCwubJ6k5S5LrL9vD29XkCHTddFyu+U0ysg904TZjBwruw27S4URAeGMO0E4WLkyoDIFQxh2gnCxciVLvR6wQFyBX2+fn4/vn5+uXHjxo0bt6NufF4BIDBB6EOuANCYIPQhVwBoTBD6uMkVq71etV4loJvIlfxclBZg9KzlGpZoX6UdP3bBSJzkitVer2jXZ35EhiMluZLUyonarlT4rPX19tFeGqxfK3zkitVer/LWmcA+X/EOe3GtXHXN1crogo1gWL5m+MiVgKVer3C3GeYShwpyRS+/yporT1O4Jx7L1w53uWKu12upqWEqcaza+ZVKbVfmWa971s9qPhRm4CtXzPV6LanD+RUcrpIrxdqu7LPWXu+q2g+FGTjKFYO9XpxfwZnqvwdbFJfftmexkqfnJVds9nqRKzgTuYI+PnLFbK9X+HS+PcChKrkia7uk6rPaD4UZuMgVy71eXBeJ01Q/r8jLhcXHjYZn7bnyGKNxkSuzYZ98DGHaCcLFyJUBkSsYwrQThIuRK13o9YID5Ar6kCsANCYIfcgVABoThD7kCgCNCUIfcgWAxgShj5tcsdDrxbUqeKuGCXr9KbOe0zWbXA52+/zWd66fvt48rPxIrn8ZgJNcsdDrFe4xSbLgdNUJev3vzD/mtd45WTqx3Bku+fS/ED6yf0JxNB+5YqHXi02T8G61CarVdlX2r6ukyoan75xQHM1HrgTm7PViWPB2lQmqD0upd05+6g7uLOZK/kP79gnF0dzlyqy9Xq9dj/kGGe9SmaDgrtLOquqUoHxOdGf0NVq+S6L88vB2vnJl4l6vx/0jOC/E6OB0lQkK7s1+uNf7bbfEynOdSkGTROltH2+6BuAoV+bu9eIbZLxdZYKCP2w7v9IYKyttT+f91hi85Mr0vV7Fri/gDLUJWv9tW65s7vNS77XivzMTw/CRKyZ6vZZZ4sQk3qI6Qau/Vk52hP/uN35cyS15+WUCn1QG4iJXrPR6LQciVfAGDRP0fD6LHyb0tbzNH1de/+HgL/Ej904ojuYiV2bD11wYwrQThIuRKwMiVzCEaScIFyNXutDrBQfIFfQhVwBoTBD6kCsANCYIfcgVABoThD7kCgCNCUIfN7lioddLvTDgNMEELReJqEuqyj9P2b5tC6bmJFcs9HqpFwacSF9v39679Y9etPGueDDER65Y6PWqdSgBR8v3r/z1BJV6t57PwqJ93D9uN1ayVT5yJTBnr1f9hQEH29Vg9P+D9aL9/rzdH6xku9zlyqy9XrUXBhwunqB/K/m1Hgu9W8/kicG2kbfPb1ayYb5yZeJer9ajAYfRn/jXn9hzvVuRaNYazslgao5yZe5er/ajAQepnF+p3/kn3B18dSaTlWyTl1yZvter9WjAYTbkSnlZLn9Nt7RnNRvkI1dM9Ho1HA04UvCLyvU4LIuzrWqO61eccZErVnq94hcGnCr5xJ8sf9W7JT7OkCvOuMiV2TBwGMK0E4SLkSsDIlcwhGknCBcjV7rQ6wUHyBX0IVcAaEwQ+pArADQmCH3IFQAaE4Q+5AoAjQlCn4FzRVcGLWfMw/20xJUl9HoBe4hcyc5F5vcp68X//0OSy8F2XHKMQQ2bK7oyKLx3WaeydIteL2CPJFeyc5Hd6GjZDkzZXjqBKYyaK3pTSLUxUb50i14vYI/0evtg+TX0rxR3oyRVzJoqV+r/QAcrlV4vYI8gV8TyCzc70nWR2VjZueseRjZqrsjKoNfOv5kTFNFKpdcL2KN+fmVVwKKG4l/bsHoE69iyYXNFVQY97h/BuZH0hH6wUOn1Avao5Up4ulP/+GVdLpntGIIxA+fK4u8f/fx5Dlm6Ra8XsEclVxrOr6zsPEuJmcyQK681mHkfn/sYQa8XsMd5uVJ9NKY2bK7oyiBxb/6MB71ewB6178HC1ZsuS90GFh8F9gybK7oyaH0SfDmvnbngkF4vYI++6yLXn0Uy1xPzccW4gXNlt2l3oSA6MIRpJwgXI1cGRK5gCNNOEC5GrnSh1wsOkOQcE0QAABuKSURBVCvo8/Xz+/H188uNGzdu3LgddePzCgCBCUIfcgWAxgShD7kCQGOC0MdNrtDrBWwU5kqtw0sW8VWLv2CRk1yh1wvYbJ0rqlJvTRbxNRR/wSIfuUKvF7Bd+M6s+HaqXpjENfaO+MiVAL1eQJOvYIe94qrT01Qt/oJN7nKFXi+gUfSJv1Cpp4v4lv/F6RVffOUKvV5AuyBX8pV6/6RFfNXiLxjlKFfo9QI2qZ2hzOH8indecoVeL2CrzPmV2hLURXzkiiM+coVeL2C76HfGuSWZ/3ut+AtGucgVer2ADrnrIvVnEFnEx3WRLrnIldkQHRjCtBOEi5ErAyJXMIRpJwgXI1e60OsFB8gV9CFXAGhMEPqQKwA0Jgh9yBUAGhOEPuQKAI0JQh83uWK112u5uIbrA3AwcgV9nOSK0V6v9UYA2/fvB8rIFfTxkSsuer3YfwkHI1fQx0euBGz2eu3cwwxIkSvo4y5XDPZ6/Ts+qYKDkSvo4ytXLPd6cX4FRyNX0MdRrljv9eL8Cg5GrqCPl1xx0OtFruBg5Ar6+MgVq71e6z9+f96IFRyKXEEfF7liuNdrz/WaQBm5gj4ucmU27JOPIUw7QbgYuTIgcgVDmHaCcDFypQu9XnCAXEEfcgWAxgShD7kCQGOC0IdcAaAxQehDrgDQmCD0cZMrVnu9loNzVSQOFuZKbamlM5Jc+VXZQRVWOMkVo71eqxe2a6cZQFnnyrLw9fYTtRmJZyxayTDFR65Y7fUqb50J7BO+MyuursqMBKlSa6jD9HzkSsBSr1e42wyxgkOFO+y1r/p4RqJPOLURw/Tc5Yq5Xq+/oxMqOFr0if+RPRsZSGakMEvkik2+csVcr1f4pTdTikMFuRKclsy+ixHrMLf+yRW7HOWKwV4vzq/gTLUzlDE5I8VHkys2eckVm71e5ArOlDm/ohd0bkay65JcsctHrljt9YqezpTiUNHvjHNL8vkszEj5VyusWJtc5IrhXi+ui8R5ctdFpp+RiyOWWZnkil0ucmU2DByGMO0E4WLkyoDIFQxh2gnCxciVLvR6wQFyBX3IFQAaE4Q+5AoAjQlCH3IFgMYEoQ+5AkBjgtDHTa5Y6PXiWhW8lciVzXOhRmw9EdFSbrk8q3In43E9J7lioderVqwEHCzJlc1zoUfscc8MREttXabLLntMXMBHrljo9WL7L7xbssPe1rnQIyaXcmttXWZPPMZjKD5yJTBnrxfXtODtglzpmAs9Yt+fNxEBzbV1uTuJlYG4y5VZe722FCsBh6ifX1nfrT+DyL3Ebrdb5kxIU21demfxmHg7X7kyca9Xc7EScJTGXMnORfaLrNfqTc6K1Gvr1J3lY+LtHOXK3L1eO8/xANu15EppLur9QMW523J+pXRMvJ2XXJm+16uhWAk4VjVXanNRHLHoAenxyZVp+cgVE71elWIl4GiVXGmYCzFi69Wbnm6v19apO8vHxNu5yBUrvV6iWAk4TzlXcnMRfl4QI1a6mLL3usg9Fy7jcC5yZTZ8zYUhTDtBuBi5MiByBUOYdoJwMXKlS+arLYVeL8yKXEEfcgWAxgShD7kCQGOC0IdcAaAxQehDrgDQmCD0GThXXufG5ZZzyYUf6UPN9XqpFwacpr6PS2b0oic0jRgMGTZXwt3l1tcxRpenry/6DS9EN9brpV4YcKJKr1d+9IInZLa0iHfFgyGj5kp+h+3iv+nBA2z1eqkXBpyp0usVqG3VlX7Qud1YyVZNlSu1f6Cj/YpM9XrVXxhwsPZery39K///4f5gJds1aq7ELdYf98dq59/0+9p/3+Lmz6+sHzhjr1fthQGHa+pfUaOnHpyUO7KS7Ro2V5Z/jpdN5KvdVtnzK+tDFnfhDh7a3F9U/z9SeNbfLpPlXq/WowGHae+L1B/jc99mizd2MGXgXFn8rcj6eY7M+ZXXE+bt9Wo/GnCQDbkiz6+oEVvaHFnJds2QK6/1V++2yubK9L1erUcDDrM3V8SIpZvrs5oNGjZXdIuVuDdf6WOs16vhaMCRKrnS0KbVOmKwZdhcWV1ylbkuMnhHr976mOv1il8YcKq2HuJ4Jqq9XvJQsGTgXNlt2l0oGDgMYdoJwsXIlQGRKxjCtBOEi5ErXej1ggPkCvp8/fx+fP38cuPGjRs3bkfd+LwCQGCC0IdcAaAxQehDrgDQmCD0cZMrBnq9VKUZcJ7MBOUugMz/XkVtGtF0eZbsDdONfxiIk1wx0OsVbfDM78VwOjlB9eWnxym4cDLdZEI8UveG6cY/DMVHrhjo9Srvkgmc4CvYCalx+alUCSq88k8vlX3JEiYGYVA+ciUwaa9XuLEM04TzrSaodfkln0CSCq/sOJTKvlprkzAGd7kyc6/X0kjDKOENwglqWX7iREpc4ZVp58uWfcW9YarxD4PxlSsz93qFXyszTThfdH6lvvzipa4qvHQ7X63sK9o7+V/APcqjhas4ypW5e734+I+323p+Jf0xl6jwUmcrG8q+av0uGImXXJm+14tcwdttzZXMDvnht79idbeUfVX7KDEQH7liodcrfCTjhPNF5+1ry6/8AxVV0JIOXr03rPRsDMJFrhjp9eK6SLxX9brI5ANKZmXmr4tU5zArvWGZxj8MxEWuzIaP9xjCtBOEi5ErAyJXMIRpJwgXI1e60OsFB8gV9CFXAGhMEPqQKwA0Jgh9yBUAGhOEPuQKAI0JQp+Bc0W396hf0a/Poq8ebK3XiwtY8F4iV/JzoRelnOJCMVf2+KrX6yN7iRkDcq1hc0W39+hGoGV3oYCtXq9SGxJwhiRXornIjt768ckUF4q5snO3usi/NoxchT+AUXNF70ekL+jNXeZrqteLPcHwdskOe+FcVBelnOJc71F6fPnIyjCSKkOYKlf0P9DLzkERU71eXNOCtwtyRcxFdvSWv7fnij7+6qNJaYe/1RN49zWAUXNFtvfoRqB/5aXp16qmer0ybUjAeWrnV7Kj91wekExxuZgrt5OYOnwyjLz5GsWwuaLae2QjULC4gq97TfV66TYk4ESVXMmPXvj4cIpzd6bHL5aJiWEkVoYxcK4sGr9afUaPMNXrtfMcD7Bd/fdgi+r5v7Zirji39ITKYWQqxjFDrrzWS+6710U2V9RHjXl7vZggvMORuSKfWJ670hl+8Rr4Zcs4hs0V3d4j7tXlP8+ntV4v+ozwbpVcyY/eH7lmiws5ef8Ufw+WHUbebA1k2FzJtfcsJ8GD1acuNrTW66X+vwPnqX5ekaMXfG6QU1wo5qpdF1mcZT6ujGLgXNlt2l0oeOeFIUw7QbgYuTIgcgVDmHaCcDFypUvmqy2FXi/MilxBn6+f34+vn19u3Lhx48btqBufVwAITBD6kCsANCYIfcgVABoThD5uckVf5PK6t3YlcO4amRb6JH/Hifnkx/zAmfQEVRu65J2B/NzBBCe5Qq8XsFk0QW0NXYXartWxcvtcwAQfuUKvF7DdV7ATUluTSnk71+hOflFvlI9cCdDrBTQ5JVfqwYPpucsVer2ARvKb5FpDV7G260muuOArV+j1AtrJ8/b1hq5CbdeTXHHBUa7Q6wVskv8muaGhK3cnueKAl1yh1wvYSudKY0NX7k7O2zvgI1fo9QK2C8+vNDZ01dcpvzM2z0Wu0OsFdAg+r7Q3dKk7wy+88nMHE1zkymz4dgBDmHaCcDFyZUDkCoYw7QThYuRKF3q94AC5gj7kCgCNCUIfcgWAxgShD7kCQGOC0IdcAaAxQegzcK7odiDZbaULr6z1elHrhfei1wt9hs0V3Q4ku61yhVe2er2ibWIZSJyOXi/0GTVX9OZ07RvePZ/Ger3YrQ9vR68X+kyVKxv2tns+jfV6Re8IiRWcj14v9Bk1V2Q7kOy2yhdemer1Wh+IScRb0OuFPsPmimoHkt1W+cIrU71e0dfWfHuA89HrhT4D58rib/HJ8xz5kx+mer2YRrwdvV7oM0OuvBaifB+fL7yy2+vFNOId6PVCn2FzRbcDbSoSstXrFT6SacT56PVCn2FzJVMZpLutdOGVtV4vrovEe9HrhT4D58pu0+5CwbcDGMK0E4SLkSsDIlcwhGknCBcjV7rQ6wUHyBX0+fr5/fj6+eXGjRs3btyOuvF5BYDABKEPuQJAY4LQh1wBoDFB6OMmVwz0enEBC95LTxC9XqhxkisGer2y9WXASb7o9UIXH7lioNeLPcHwdl/0eqGLj1wJzNnrxQTi7U7JFXZQdcBdrsza65WvLwNOIr9JptcLVb5yZeJer3x9GXASed6eXi9UOcqVuXu9dp7jAbbLf5NMrxdKvOSKrV4vcgXvoHOFXi/U+MgVC71eDX1JwKG+6PVCFxe5YqTXK1NfBpzki14vdHGRK7Ph2wEMYdoJwsXIlQGRKxjCtBOEi5ErXej1ggPkCvqQKwA0Jgh9yBUAGhOEPuQKAI0JQh9yBYDGBKHPwLmi24GSbqvk6pLXw631elHrhfei1wt9hs0V3Q5U6bYKr9+11esVbRPLQOJ09Hqhz6i5ojenK+9SF69SU71e7NaHt6PXC32mypXiKkw/wJjq9YreERIrOB+9Xugzaq7IdqBSt5X4x9tUr9f6QEwi3oJeL/QZNldUO1Ch20rFgKler+hra749wPno9UKfgXNl8bf48uc55D/dpnq9mEa8Hb1e6DNDrrwWYj5K5PK02+vFNOId6PVCn2FzRbcDZTqD9PK01esVPpJpxPno9UKfYXMlUxmku630+3drvV5cF4n3otcLfQbOld2m3YWCbwcwhGknCBcjVwZErmAI004QLkaudKHXCw6QK+jz9fP78fXzy40bN27cuB114/MKAIEJQh9yBYDGBKEPuQJAY4LQx02uzN7rla8vk/8hTvtjvy95/UrupyiFB+SnaXlsuSJsvaQLF3Lxk5cxOMkVA71e0auT22PseJFA4kvuWCGXX/EB8QZ4j3tygGxFWLKkSwV38X8IF/GRKwZ6vRaZzS92vkggkfkerLo9XXJx/e2W7qQaPENufyeXdGGjvOQ/hKv4yJXApL1eq6fUP4qw8RIOICeougLDB3x/3u6PeCfVjk2Og43ykq3I5H8Il3GXKzP3euVf1v4XCSTiCfq3kvNrK3nAvwxJZu0Wn0uptIElWRWfXlH/IVzGV67M3OvVcqgdLxJI6E/81Q/DywMe9/Q9XBARqzMt+TawcEnLgjv1H8J1HOXK3L1e6kjp3s79LxJI7Dy/soRG6VvlShtYy9g2/IfwVl5yZfper/gVZ/47DBWOsy9X0n6JdHVWCiXFkha50vIfwlv5yBULvV6VA3FSBYcLflG5XoaF0+ryAdGbI/FI1Qaml3Sx4I7PK2NwkStGer2K7xP3vkggkXzij1fWekWWrsoVn/6TRyZtYNklzXWRw3ORK7NhODCEaScIFyNXBkSuYAjTThAuRq50yXy1pdDrhVmRK+hDrgDQmCD0IVcAaEwQ+pArADQmCH3IFQAaE4Q+bnJF/2b+dW/lF/fX93qtj8Plj3gLkSuF35Toy0rkiKk7cxfI1K5qWV9M3P9bGRzKSa4Y6PWSxUfAiZJcieYi/lNatyVHTN2pRmx9vb3c7DI6KEMxDB+5YqDXq15QARwsvd4+mIs1vT7liKk76yOWrvkgahiJofjIlcCcvV7kCt4uyJXKXKi6LbloN1R4hUdPNxxPel4wCHe5Mm2vV6X4CDjctvMrad1WV67EI/Yty8Si1yG7wnAZX7kyd69XvvgIOMOWXFF1W9tzJTti0WcY8bMa1RWGizjKFQO9XoW7gMNtyJX2CMnPXXHE2k9yMh3X85IrNnq92g4IHGNvrrSft6+PWJAWxeggV67nI1cs9Hqp4iPgTFu+B9N1W62/M5Yjlu0KS15EtXYM7+UiV4z0eiXFR8CpqrmSfo2VLFA5YvGduRHLXI6cOdvfNZ04g4tcmQ3fc2EI004QLkauDIhcwRCmnSBcjFzpQq8XHCBX0IdcAaAxQehDrgDQmCD0IVcAaEwQ+pArADQmCH3c5Aq9XsBGeoJka1f1zkB+7mCCk1yh1wvYLJqgZPm13xko7XMBE3zkCr1ewHbhTkh7t5V8pnfyFskoH7kSoNcLaHJKrrCSHXCXK/R6AY3kN8mr5dd+5wq54oCvXKHXC2gnz9sHy6/9zuA45IpxjnKFXi9gk/w3ycWzJuU7yRUHvOQKvV7AVjpX5PJrv5Pz9g74yBV6vYDtwvMr6fJrvzPA74zNc5Er9HoBHYLPK3L5Nd8ZfuGVnzuY4CJXZsO3AxjCtBOEi5ErAyJXMIRpJwgXI1e60OsFB8gV9CFXAGhMEPqQKwA0Jgh9yBUAGhOEPuQKAI0JQh83uWKg10u+sMKdwD4NE/QnuchrdW1k8gMWeaj1mIR75eWff9CE4mhOcsVAr5d8YYU7gb2qE6S9HrveqGI5QOZQj3u6hMOOsMLY7ptQHM1Hrhjo9ZIvLHMncIjaBEmF3Vv+Ch/UodQOlM21YDsnFEfzkSuBOXu9Mi+s9mqBfpUJUnJ76dW26Pv+vJV3PpZ35oKHYbiYu1yZtter+MLIFZygMkFCtrZIfjcVfrl1u93CMymvnb7XE1PLlZ2bxOIQvnJl7l6vwtHIFZygMkGpwjpMPkUkw/gagL8zLY97eP6/3nO8q88Cx3GUK0Z6vcgVvEtlghLFZZicA8keqngmJj+2/ROKo3nJFTu9XuQK3qU2QbFi++PqFGblUH+P1HNQ+LkNIzAKH7liodereDRyBSeoTlAoWYXrxfs6MS8PJR+ZLw6Lx5aTKoNxkStGer2SF1a5E9inOkFJW5dareHQ5A6Vua5xuXt1bzy2eycUR3ORK7MhJTCEaScIFyNXBkSuYAjTThAuRq50odcLDpAr6EOuANCYIPQhVwBoTBD6kCsANCYIfcgVABoThD5ucsVAr9frOFwBhrfQExTvKtR2ZyA/dzDBSa4Y6PUKK46YR5wvmqBk+bXfGSjtcwETfOSKgV6veu0EcLBwH5dk+bXfGSjuywcTfORKYM5eL3IFb3dKrrCSHXCXK9P2eoWb7PH9Ac4nv0leLb/2O1fIFQd85crcvV5/+RTtqg+cRJ63D5Zf+53BccgV4xzlipFer8xdwOHy3yQXz5qU7yRXHPCSK3Z6veoHBI6hc6W9qUEvVM7b2+cjVyz0esmKI+BE4fkV2bDVeGeA3xmb5yJXjPR6vV4H3xzgLYLPK3L5Nd+ZNIBxXaRlLnJlNnw7gCFMO0G4GLkyIHIFQ5h2gnAxcqULvV5wgFxBH3IFgMYEoQ+5AkBjgtCHXAGgMUHoQ64A0Jgg9HGTKwZ6vVYH4goWvEGYK9UyLtq68I+TXDHQ6xX1JZEsON06V6oXyXMVPV585IqBXi926MPbyX1c2PULVT5yJWCg1wt4h0qv1xq7FGPFXa7M2uv12vWYL7DxLuQK+vjKlYl7vR73j+C8EHOL05Er6OMoV+bu9dp5jgfYjlxBHy+5Mn2vV63rCzgc5+3Rx0euWOj1otgL78bvjNHHRa4Y6fVaHYixxRuE3ySLYaGtC5KLXJkN3yNgCNNOEC5GrgyIXMEQpp0gXIxc6UKvFxwgV9CHXAGgMUHoQ64A0Jgg9CFXAGhMEPqQKwA0Jgh93OSKgV4var3wXiJXCr8pea3P9fJcLv5a35ss5eQasXAP1vD564F63ct0jMRJrhjo9Vpew65NZYBmSa5EcxH/Kd4ofL1RhZwhuZNF9ZGPe/ISmI6x+MgVA71e7OuHt0t22AvnYq2+Pl93llfv+j2efqS4l+kYjI9cCczZ6xVtLMPg4HxBrpTnovYve6b3SB0m+GorfeT35y1d/UzHWNzlyqy9XusDMTZ4iy3nV6JvouLNwD/W32JlG+pEQ0TyyMf943YTZ3KYjoH4ypWJe72ir5r5Bhnn6ztvH7U+/BOczMw01EUHl48M3tm9zrQwHWNxlCtz93rxDTLebluuLIrnV/JnK+Nj189r/j2C6RiMl1yx1evF5OAdOnOlXPyVj5J4Wde77MiVQfnIFQu9XuEj+aSP8208v6Kq6NZDFJxhSRvqxKHFI/UxmY6xuMgVI71eXPmF96rmSvDR4DUnsoouGBrZUCc/Z4hHVi5xZjoG4CJXZsM++RjCtBOEi5ErAyJXMIRpJwgXI1e60OsFB8gV9CFXAGhMEPqQKwA0Jgh9yBUAGhOEPuQKAI0JQh83uWKp14sf6OMtNl5vry4h0b1e8lDJMGbLvtTT90wojuYkV4z0ejVsNA4cZkuvl+rgyvR6rY4VXGKZ3fxC3HvohOJoPnKFXi9guw29XvU1GT7g3273aknr/Vzi6+2PnFAczUeuBObs9SJX8Ha9vV5CuMfe9+ft/oi34CvuP7neG+bwCcXR3OXKtL1e+d4k4Bwbzq8U2rqiXq/XdpGtuVIYxYMmFEfzlSsz93rVepOAo23LlVxb1/KAv7dK6Ru7wjBu+YTEZsaDcJQrc/d6xU/gLRlOt/XzSksH16visTFXstNz4ITiaF5yZfperw0HBI6xIVdaO7jS0onSj2iehfdQB04ojuYjVyz0emXKkIDTbLp+pbmDSx8qM4zlH70cNKE4motcMdLrpXqTgPNs6/Vq7+BSh8oMY/4r3wMnFEdzkSuz4XsuDGHaCcLFyJUBkSsYwrQThIuRK13o9YID5Ar6kCsANCYIfcgVABoThD7kCgCNCUIfcgWAxgShz8C5omusVHeQuu9pr9fr8BcGFLVeF1n4oUlPr1dttOUx9T8XuMawuaJrrER3ULzR77JSbfV6nfDCgKK2Xq982Vep1yt+Vuto62PSejeWUXNF70OnLr7N71hnqtfrjBcGFFV7veSdGauKI/GsbaMdH7P+SLzVVLmi/+UM93NYrShTvV5nvDCgqNrrVVuTi/XHDPGsjaMdH5NcGcyouSJrrLLdQUszyXo52er1OuGFAUUHnF95vtZ/8ePIxtFOjknr3ViGzZX1ivrbRF53B4VfrerzK+tD1isfkr+qp2/7P1J41t8uk9Ver8NfGFB0TK78L/04HZ843TDa4pjpPxe4zsC5svj7R1+eTmg5v/J6goFerwNfGFB0ZK6UR2zjaGePmb0TbzVDrryWl3wf35Yr6v3OnL1eB74woOh9ubJxtLPHbH0xONewuaJrrNS94RkT+T1Y5uTDVL1eJ7wwoGhvrmzs9WoabX1MWu/GMmyu5GqslpPg8a8dk4da6/U6/IUBRX25sv4QsVr71TRqHW19TFrvRjJwruw27S4UfJLHEKadIFyMXBkQuYIhTDtBuBi50iXz1ZZCrxdmRa6gz9fP78fXzy83bty4ceN21I3PKwAEJgh9yBUAGhOEPuQKAI0JQh83uaJ/9P66t/bj+tLv8Gv0Sf6OE/OZ63SAc+gJincVarszkJ87mOAkVyz0eqniI+BE0QQl+4C33xko7XMBE75+fv8DgJ8ir7f8MxEAAAAASUVORK5CYII=)
However this is not good for me to do any analysis because so many data are in one cell.
Is there any better way to export data for further analysis; pivot table etc..
I would like each row has compound name, assay data so I can use,sort,modify easily.
Thank you
Hoon
ChemAxon 60ee1f1328
06-09-2012 22:38:41
So here you have exported some relational data into a XLSX format and it has bundled some child records into single cells.
One possible solution :
Export Structure and Data as separate CSV files and as you suggest attempt some merge/re-format from within VBA i.e. It could be possible with a simple macro.
Another is export your relational data into an SDF file with additional fields and then import using JChem 4 Excel functions thus giving you proper chemaxon structures in your spreadsheet as well as your graphing data.
ChemAxon 60ee1f1328
07-09-2012 11:50:00
Another alternative has been suggested to me and so I pass it on to you !
If you reverse your data tree and then complete a normal export, you should get the data in the format that you require !
If you need some assistance in doing this - please tell us on here and we will contact you !
User 8f0e0cac1a
07-09-2012 14:28:49
I think this is a good idea since I don't have JChem for Excel.
I appreciate your help in make my data tree reverse.
Best
Hoon
ChemAxon 60ee1f1328
07-09-2012 15:20:56
OK then...
Lets assume that you have Structures -< Data (1 : n) using a join column called ID.
1. Promote the Data entity to it's own data tree using your choice of primary key during promotion (this is not the ID column).
2. Create a (n : 1) / (Many to one) relationship FROM Data.ID to Structures.ID - The "Data" node is the parent and "Structures" is the child.
3. Add the edge (right click on Data datatree) and add edge, icon should transform and you see n:1 appear.
This should have reversed your original data tree, so an export from here should give you somthing like the data format your after (try CSV or XLSX) please.
Thanks,
Daniel.