Hi, new member here
Is there a general formula for calculating AUDPC values in excel? I have foliar blight data I need to convert and am struggling a bit. Any help greatly appreciated!
Thanks
Simon
Hi, new member here
Is there a general formula for calculating AUDPC values in excel? I have foliar blight data I need to convert and am struggling a bit. Any help greatly appreciated!
Thanks
Simon
Welcome to the forum! Do you mean this?
http://www.apsnet.org/EDCENTER/ADVAN...ges/AUDPC.aspx
If you want Excel to do a calculation like that for you, then you have to tell it what to do. Are you asking for help in interpreting the formula and replicating it in Excel?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Don't know if my first reply sent, sorry, not used this service before!
Yes the help I need is telling excel what I want it to do. If I can work out how to attach a file I can show you the dataset as that may help?
Thanks
Simon
So, just to be clear: you are asking for someone here to create a formula that will carry out the calculation shown in that link I provided?
Yes, please provide data - but you MUST provide source and manually generated result data and explain (in words) what you need the formula to do. Working out the maths is beyond the scope of help offered here, I am afraid.
Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.
1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired results are also shown (mock up the results manually).
3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).
4. Try to avoid using merged cells as they cause lots of problems.
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.
Many thanks again, I'll get this loaded asap
Cheers
Simon
Hi again, apologies for the delay in getting this back to you. As you can see, the dataset consists of sixteen potato varieties scored for foliar blight on ten occasions. there were four replicates with the mean of the four in bold. To calculate AUDPC "manually" I have followed these instructions:
1) take the first and second score (e.g. 0% and 10%), add them together
2) multiply by the time between them (e.g. 7 days, so 10 x 7 = 70) and
divide by two (=35).
3) Repeat for second and third score (e.g. 10 + 25 = 35. 35 x 10 (cos to
keep things interesting we were late assessing that week) = 350. div 2 =
175.
4) Repeat for all consecutive pairs of scores.
5) Sum all of these values together, and that's your AUDPC.
So what I need is a formula that summarises these instructions and can be applied each set of scores
Is this all the information you need and do you think you can help with this? I'm looking at using R to calculate AUDPC and run other stats too but I'm very inexperienced with R so may take a while.
Many thanks again
Simon
I can see you are not used to this sort of thing! You know where to look, but we don't. Where will I find these?
Which are the mocked up results in the attachment, please?1) take the first and second score (e.g. 0% and 10%), add them together
What is R???
Sorry!
The scoring dates are in cells 1B - 1K, the scores, as percentages, are in 2B - 2K, 3B - 3K, 4B - 4K etc
so for example Axona R1 first score is in cell 2B
Sorry - I don't get it.
If it helps, I put "area under the disease progress curve excel" into my favorite internet search engine and found this on the first page of results: https://zachrokeach.files.wordpress....k-write-up.pdf On page 2, part #3 shows the formula you give above, along with his translation into an Excel formula (and picture of the spreadsheet he is using).
This result (http://www.apsnet.org/EDCENTER/ADVAN...ges/AUDPC.aspx ) mentions an Agricolae package for R (for AliGW, R is a statistics application -- I believe it is open source but not certain) that has this function built into it. If you have access to R and this package, it might be easier to perform the calculation in R rather than Excel.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks