En cours

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

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

Voir plus : sugarcrm reporting database, tournament database results ipoker, crystal reporting database field, database speed test php, php database results, display database results php, php displaying database results, 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é à :

735 $ AUD en 10 jours
(398 Commentaires)
7.8

16 freelance ont fait une offre moyenne de 619 $ pour ce travail

someka

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

1176 $ AUD en 8 jours
(123 Commentaires)
6.9
dpune

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

700 $ AUD en 10 jours
(112 Commentaires)
6.2
sandroshubladze

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

470 $ AUD en 10 jours
(41 Commentaires)
5.4
shoguna2m

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

600 $ AUD en 10 jours
(32 Commentaires)
5.2
softsolution2000

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.

588 $ AUD en 10 jours
(4 Commentaires)
4.6
sheak

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!

1176 $ AUD en 20 jours
(6 Commentaires)
4.0
crypthne

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

400 $ AUD en 30 jours
(13 Commentaires)
3.4
naseefo

A proposal has not yet been provided

600 $ AUD en 3 jours
(5 Commentaires)
3.4
jssinfosys

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

388 $ AUD en 10 jours
(13 Commentaires)
4.2
vranjan

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

466 $ AUD en 10 jours
(0 Commentaires)
0.0
ZawnTechnologies

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

555 $ AUD en 10 jours
(0 Commentaires)
0.0
ecomHorizon

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

277 $ AUD en 5 jours
(0 Commentaires)
0.0
truedigisol

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

555 $ AUD en 10 jours
(0 Commentaires)
0.0
WeazenSoft

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

555 $ AUD en 10 jours
(0 Commentaires)
0.0
555 $ AUD en 10 jours
(0 Commentaires)
0.0
500 $ AUD en 10 jours
(1 Commentaire)
0.0