Thank you for your suggestions, I am sorry that
http://www.nabble.com/file/p21168216/ds2_panelA_p8_B3_dil4x.csv
ds2_panelA_p8_B3_dil4x.csv I forgot to include the concentration of Standard
to use. the first standard (A1, A2) is 67000 and dilution series is created
by diluting it 1/3. i am reposting the full Absorbance data once again to
have a full idea about the output file created by the ELISA software. I am
also uploading the sample file for a better understanding, serum samples in
this case are diluted 4 times
Location Sample ENA-78(37) FgF(54) G-CSF(58) GM-CSF(71) IFNg(75) IL-10(50)
IL-17(20) IL-1b(6) IL-1ra(16) IL-2(17) IL-4(21) IL-5(09) IL-6(32) IL-8(36)
MCP1(78) MIP-1a(59) MIP-1b(74) TNFa(77) VEGF(52)
A1 s1 6923 12667.5 4644 3247 11878 11648 4142.5 6536.5 5409 7057.5 5146
10921 5437 7968 6590.5 11497.5 8358 8088.5 7721
B1 s2 4093 9680 2535.5 2000.5 8392 7017 2135 3913 3162 4226.5 2757 8132.5
2907 6416 6216 8332 5625.5 4364 4225
C1 s3 1689.5 4586 929 1020 4313 3549.5 961.5 2220.5 992 1585 1289.5 4309
1294 3748 4315 2780.5 2504 2043 1268
D1 s4 642 1440 352 418 1769 1327.5 318.5 824 409 528 399 1384 664 1693 1461
651 803 576.5 720
E1 s5 228.5 319.5 141 143 741 590.5 170 385 155 230 114 503.5 218 701 493
237 245 236 320
F1 s6 94 42 65 67 301 271 60 147 78 99.5 28 156.5 106 397 128 74 65 108 154
G1 s7 43 11 36 36 109 94 30.5 60.5 39 52 8 48 28 163 39 46 28 37 73.5
H1 b 15 2 12 15 7 4 3 4 19 6 2.5 0 0.5 78 23 12 16.5 3 30
A2 s1 6317 12543.5 4743 3757 10073.5 11016 4432 6990 5019 6687 4578 9856
5589.5 7265 6533 11368.5 7486 7503 7823
B2 s2 4487 9343.5 2114 2029 8300 6541 2027.5 4099 2986.5 3826 2857 7192.5
3197 5786 6386 7741 5086.5 4560.5 4409
C2 s3 1577 4024.5 942 1041 4035 3093.5 1098 1943 1133 1672 1263 3706 1421
3223 3729 2681 2065 1717 1453.5
D2 s4 609 1371.5 366.5 421.5 1884 1397 361 944 422 631 496 1442 535 1646
1523 766 791 718 723
E2 s5 234 304.5 143 165 760 541.5 160 358.5 163.5 249.5 111 459 222.5 765
416 188 215 235 281
F2 s6 90 44 64 68 268.5 218 55 135 73.5 102 25 140 101 304 104 72.5 57 87
120.5
G2 s7 39 9 34 35 90 90 31.5 57 38 47.5 9 42.5 25 133 38 42 29 33 70.5
H2 b 12 1.5 14 12 8 5 3 5 15 5 1.5 0 0.5 79.5 23.5 8 15 1 33
A3 1 683 5 23 23 16 10 16 9 66 10 6 4 12 653 641.5 23 22 14 182.5
B3 2 523 7 23 18 19.5 11 11 16 59.5 15.5 6 2 8.5 1789 369.5 26 28 16 140
C3 3 686.5 4 26 18 12 6 15.5 18.5 118 17 4 2 10 2040.5 714.5 20 28 17.5
123.5
D3 4 1640.5 5 71 17 17 9 13 16 564.5 13 5 4 18 1258 957 31 164 24.5 291
E3 5 158.5 5 34.5 20 15.5 8 13 13.5 75 13 4.5 4 50.5 1075 330 20.5 23 11 87
F3 6 862 5 21 22 18 10 14.5 12 58 18 4 2 7 2207 555.5 23 27 19 124
G3 7 710 6 30 16.5 19 6 13 14.5 105 17 6 2 12 1755.5 557 23 32 13 135
H3 8 1047 4 41 20 16 10.5 14 12 111 11 4.5 4 10.5 1690.5 404.5 23 50.5 23
212
A4 9 512.5 6.5 22 22 18 11 11 30 167 13 4 3 5 2729 1420 37 48 18 333
B4 10 979.5 5 20 27 19 2 18 15 122 14 4 2 7 1581 496 18 35 20 94
C4 11 270 6 23 20.5 19.5 9 14.5 68 656 15 3 4 79 5995 2964 50 40.5 17 198.5
D4 12 207 4 27 21 19 10 14 11 39 16 5 3 6.5 1622.5 311 25 25 15 181
E4 13 367 7.5 25 21 19 12 10 13 50 12 7 1 8.5 1395.5 718.5 24 30 19 219
F4 14 462 5 23 20 19 7.5 14 10 107 14 4 0 10 1715.5 484.5 23 22 19 265
G4 15 441.5 5 19 20 18 7 16 29 271 12 5 1 10 6917 6325 24.5 32 15.5 156
H4 16 521 7 38 22 18 10 14 11 164 16 4 3 23 1967 744 25 34.5 15 202
A5 17 759 5 18 21 16.5 10 10 10 55 11 4 1.5 16 1731.5 752 19 30 12 288
B5 18 624 6 22.5 20 21 12.5 11 12 52 12.5 4 2 8 2329.5 533 23 30.5 15 125
C5 19 735 5 21 19 14 10 17 11.5 291.5 9 5 3 10 773 1682.5 26 33 17.5 67
D5 20 450 5 25 16 15.5 8 17 12 65 12 5 3.5 9 1970 335 20 23 14 110
E5 21 405 5 21 18 14 7 12 10 139 13.5 5 0 8.5 1318 433 25.5 33.5 14 89
F5 22 155 3.5 12.5 10 12 4 35 6 24 4.5 3 2 8.5 391 257 19 114.5 8 104
G5 23 472 6 23 17 18 6 12 38.5 348 11 3 2 7 2764 1612 39 967 20 197
H5 24 326 5.5 20 19 17 7.5 13.5 11 44 13 5 3 66 1579 272.5 24 24 13 152.5
A6 25 341 5 24 22 15 8 13.5 13 68.5 12 4 2 7 1591 483 22 34 11 84
B6 26 460.5 5 21 23 16 10 11 160 677.5 11 5 2 23 5326 1495 46.5 62 19 138
C6 27 454 4 32.5 16.5 15 9 10.5 14 104.5 10.5 3 1 50 1468 1459 25.5 38 17
142
D6 28 604 6 27 18 16.5 7 14.5 37 950.5 12.5 5 4 14 5643 5980 24 36 18 324.5
E6 29 491 7 22.5 18 19 8 13.5 23 240 17 4 1 11 3802.5 1902 30.5 47.5 20 297
F6 30 414 4 24.5 20 20.5 9 13 14 39 16 3 3 6 1384.5 585.5 23 32 13 95
G6 31 423 5.5 21 19.5 19 9 16 299 1428 15 5 2 49 6343 6018 160.5 335 11.5
211
H6 32 286 6 28 18 10 9 14 13 108 13.5 3 2 27.5 1369 808 20 32 237 70
A7 33 874.5 6 23.5 20 16 8 12.5 65 588 6 5.5 3 17 5915 5098 36 81 23 229
B7 34 1211 3 23 20 16 33 12 9.5 78 9 4.5 2 8 2097 693.5 16.5 28 13 274.5
C7 35 257 4.5 25.5 17 16.5 9 12 10 52 10 5 3 7 1456 750 24 23 11 70.5
Thanks for the help
1Rnwb wrote:>
> Hello R guru's
>
> I am a newbie to R, In my research work I usually generate a lot of ELISA
> data in form of absorbance values. I ususally use Excel to calculate the
> concentrations of unknown, but it is too tedious and manual especially
> when I have 100's of files to process. I would appreciate some help in
> creating a R script to do this with minimal manual input. s A1-G1 and
> A2-G2 are standards serially diluted H1 and H2 are Blanks. A3 to H12 are
> serum samples. I am pasting the structure of my data below:
>
>
>
> A1 14821
> B1 11577
> C1 5781
> D1 2580
> E1 902
> F1 264
> G1 98
> H1 4
> A2 14569.5
> B2 11060
> C2 5612
> D2 2535
> E2 872
> F2 285
> G2 85
> H2 3
> A3 1016
> B3 2951.5
> C3 547
> D3 1145
> E3 4393
> F3 4694
> G3 1126
> H3 1278
> A4 974.5
> B4 3112.5
> C4 696.5
> D4 2664.5
> E4 184.5
> F4 1908
> G4 108.5
> H4 1511
> A5 463.5
> B5 1365
> C5 816
> D5 806
> E5 1341
> F5 1157
> G5 542.5
> H5 749
>
>
--
View this message in context:
http://www.nabble.com/creating-standard-curves-for-ELISA-analysis-tp20917182p21168216.html
Sent from the R help mailing list archive at Nabble.com.