Soil Test Results - Database and Reporting

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

I don't mind if this is done on a web-site if that happens to be a better option. In some ways it would be great to have my farm client provide some details eg the next crop and yield target. They could access old tests also?? I think it would be simplest just to have some sort of database that lives on my computer/cloud but open to suggestions.

The main report would typically be for a single site (with 3-4 depths) and contain 4-5 charts of results (with selectable analytes ie choose what to display) as well as automated comments that are editable.
I would also need to be able to report and compare selected lab results (analytes or calculations based on them), to A) previous tests results for the same site, or B) be able to select and number of sites (again w multiple depths) to compare.
Hope that makes sense

Compétences : Administration de Bases de données, Développement de bases de données, Excel

en voir plus : sugarcrm reporting database, tournament database results ipoker, paging pages database results including thumbnails php mysql, crystal reporting database field, database speed test php, php database results, display database results web style, php database results ajax drag sort, display database results php, php displaying database results, database results java flex webservice, php display database results link, reporting services online test, php display database results, displaying database results website

Concernant l'employeur :
( 1 commentaire ) Southbrook, Australia

Nº du projet : #12633368

Décerné à:

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% AUD en 10 jours
(398 Commentaires)

16 freelance font une offre moyenne de $619 pour ce travail


Hi there. Yes it can be built as a website, as an app, as a database or as a spreadsheet tool on your computer. If you ask me, if you dont collaborate simultaneously with other people for data input, then I would go fo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 8 jours
(123 Commentaires)

Hi, I have more than 14 years of exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(112 Commentaires)

Hello, I am experienced Excel expert and VBA programmer Recently I have done similar project like this , but did for hospital I can help you and create desirable spreadsheet for you Also I would like to offer ong Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(41 Commentaires)

Hello, my name is Andrés. First of all, thank you for considering my offer and welcome to Freelancer I am really interested in working with you on this project as database construction and data analysis and manageme Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(32 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(4 Commentaires)

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!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 20 jours
(6 Commentaires)

I have a bachelor degree in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(13 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(5 Commentaires)

I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I am a financial engineering graduate and have extens Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(13 Commentaires)

Dear Hiring Manager, My work experience as shown in my profile have helped me develop mastery in Website design & development. As proof, I got positive feedback from my previous employers. Please have a look of m Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(0 Commentaires)

Hi there! I have read what you exactly need, however I would like to ask you a few questions. I wouldn't call myself a master but I do work smart and do not rest until I get the job done. Please feel free to ping me an Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(0 Commentaires)

I have carefully reviewed the description and looks very doable for me. Can you share some CSV files so that we can start creating the necessary table spaces in db? we can create a prototype in my lab environment which Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(0 Commentaires)

I can assure timely delivery with lowest rate and best quality work. Requesting you to kindly provide a chance to work with you. LETS START WORK WITH TRUE DIGITAL SOLUTIONS.. please share requirement we are 3 years Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(0 Commentaires)

Hello Respected Sir/Madam, We have a team of Microsoft Certified Solution Developer (MCSD) and Design & Development and I have more than 7 years experience in software development and web development using Microsof Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(1 Évaluation)