I am an agronomist working with farmers on soil nutrition and arrange for regular soil sampling at GPS located sites. I currently interpret soil tests from approx 100-200 sites per year and most of those have 3-4 depths each
I am seeking a solution that makes for rapid and easy entry of lab data as well as providing detailed and customised reporting options.
I want to be able to create and easily modify report comments that can be automatically inserted into a report depending on the either the soil test result or somehow selecting to do so.
The laboratory (lab) provides numerous analysis options that measure many different aspects of soil fertility - eg
- minerals such as nitrogen, phosphorus, zinc, boron etc etc.
- dispersion index, pH, conductivity
- total carbon
- particle size analysis
The results come from one laboratory in particular and in a CSV format. The database would need to cater for results coming in different formats.
Desired Ranges for each analyte often change depending on geographic location and other factors. Some desired ranges would be based on or calculated from 'rules' that use other analyte results eg the critical level for potassium in the 10-30cm sample will change depending on the sodium or magnesium percent of cations or chloride level or conductivity.
Often there are 3 or depths taken from the one site eg 0-10cm, 10-30cm, 30-90cm and 90-105cm. But the number of depths and the size of the depths do vary.
I will try to upload some files that show how I do it now and how the raw data comes in.
I'm new to Freelancer and I am running my own small business with a limited budget - please do not apply for this project if this is not your area of expertise. I really am looking for someone with database/reporting design ideas also.
Thank you in anticipation, Ian
Décerné à :
16 freelance ont fait une offre moyenne de 619 $ pour ce travail
I am ready to get started right away.... Can we discuss the project details? My distinction, payment after your complete satisfaction with the resulted task.
Hello! We are extremely interested in this project and would love to work on this project, please reply back to discuss further. Looking forward to hear from you soon. Thanks!