Southern Soil Lab

Dashboard

Lab overview and daily shortcuts.

Daily tasks

ICP

View

Organic Matter

View Enter Weights

View Import

Samples submitted per day

Click a day to view its samples below.

Enter New Samples

Batch Information

Date into lab

Select consultant

Grower

Farm

Entry mode

Sequential mode is best for check-in sheets with event codes and multiple rows. Switch to Manual for a single sample count.

Sample Info

Live Preview

Select consultant, grower, farm, and date to preview lab refs and tubes.

Total samples: 0

Run control

Close intake for the selected date. New samples will use the next open date.

Enter Samples

Date in lab
Consultant
Grower
Farm

Year	Lab ref	Date in lab	Tube	Consultant Ref# (max 15)

Import from Access CSV

Export samples from Access as CSV with these columns (Access field names in parentheses are also accepted). Single-day and multi-day exports are supported — each row can have its own date_in_lab.

Required: lab_ref (labRef), date_in_lab (dateInLab)
Consultant: customer_id (cstID) or consultant / customer_name
Grower: producer_id (cstProdID) or grower / producer_name (pdr)
Farm: farm_id (cstFarmID) or farm / farm_name
Optional: cst_ref / sample_id (cstRef), test_tube (testTube), event_code (cstEventCode), year, master_ref (masterRef)

Attach tbl_cst.csv and tbl_pdr.csv lookup tables so cstID / cstProdID resolve to real names. Legacy placeholders are only used when a name is truly missing.

Consultant lookup (tbl_cst.csv) Grower lookup (tbl_pdr.csv) Sample CSV (tbl_cstSmplRef)

Row	Lab ref	Date	Tube	Cst ref	Consultant	Grower	Farm	Status

Preview samples

Date in lab
Consultant
Grower
Farm
Total samples
Event code
Lab numbers
Tube number start

Customer references

#	Customer ref	Lab ref	Tube

Intake Queue

Manage pending MSU soil test orders, enter samples, and print lab check-in sheets.

Catalog

Manage consultants, growers, and farms. Deleting catalog entries requires admin access.

Manage consultants and view sample activity.

Period

Growers (producers) linked to consultants.

Farms assigned to a consultant and grower.

Recommendations

View and edit crop nutrient recommendations. Changes affect future calculations and reports.

Show archived crops

Drag crops to reorder; drop under a group header to change type.

Edit crop

Basic information

Crop name Base crop name shown on reports (without yield goal). Yield goal (optional) Appended to the name, e.g. Soybeans-40 bu. Leave blank if not applicable. Crop group Required for new crops. Inherits existing P and K band tables for that group. Crop type Display category for organizing the crop list (separate from nutrient rule group).

Nitrogen (editable)

N (lbs/acre) Fixed nitrogen rate for this crop.

Phosphorus bands (P₂O₅ lbs/acre)

Phosphorus bands are shared by all crops in the same crop group. Editing them affects every crop in that group.

MinP and MaxP are soil test P ranges (ppm). reqP is the recommendation when soil P falls in that range.

Level	MinP	MaxP	reqP

Potassium bands (K₂O lbs/acre)

One reqK value per soil potassium level for this crop (VL, L-, L, L+, M-, M, M+, H-, H, H+, VH).

Level	reqK

Report defaults (editable)

Used as defaults when this crop is selected in Reports.

Target pH

6.3 6.5 6.75 7.0 None

Default Units

Graph report notes Notes for Graph PDF Shown on Graph PDF when non-empty.

Visibility Show on MSU submission form

Uncheck to hide this crop from the public online order form.

Micronutrient recommendations

Lime is always calculated from soil test at report time. Mg, S, and Zn are normally calculated from soil test; check a box below to force that nutrient to 0 for this crop.

Lime

Mg — Set to 0 (do not recommend this nutrient for this crop)

When unchecked, recommendation is calculated from soil test at report time.

S — Set to 0 (do not recommend this nutrient for this crop)

When unchecked, recommendation is calculated from soil test at report time.

Zn — Set to 0 (do not recommend this nutrient for this crop)

When unchecked, recommendation is calculated from soil test at report time.

Users

Create and manage lab accounts. Viewer accounts are read-only and scoped to a consultant, optionally narrowed to one grower.

Create user

For Viewer accounts, select a consultant. Optionally choose a grower to limit access to that grower only.

All users

Username	Full name	Email	Role	Consultant	Grower	Active	Actions

pH Robot CSV Import

Upload the robot CSV (Lab #, Tube #, Soil pH). Buffered pH is shown for reference only; buffer is calculated when you run Calculate.

Preview rows before importing — same workflow as Access pH robot export.

Open pH Import

Import ICP (PerkinElmer CSV)

Upload the ICP export (Sample ID = test tube, Analyte Name, Reported Conc (Samp)). Lab refs are assigned as base lab ref + Sample ID (Access Transposer rule). Re-import replaces rows for the same lab ref.

Organic Matter — Batch Entry

Enter gross and net weights for samples that do not yet have %OM saved (pH/ICP may already be on file). % OM is calculated automatically. Press Enter in Gross or Net wt mode to advance between rows.

Same workflow as Access tbl_mantable — optimized for batch entry from the balance print.

Open OM Batch Entry

Calculate recommendations

Requires machine data and pH manifest for each lab ref. Choose a pH goal every run.

Saved Reports

Browse saved soil reports by consultant, grower, and farm. Viewers see only reports within their assigned scope.

Reset password

Choose a new password

Complete your account setup

Southern Soil Lab

Dashboard

Daily tasks

Samples

Enter New Samples

Batch Information

Entry mode

Manual

Sample Info

Live Preview

Run control

Intake Queue

Catalog

Recommendations

Edit crop

Users

Create user

All users

pH Robot CSV Import

Import ICP (PerkinElmer CSV)

Organic Matter — Batch Entry

Calculate recommendations

Reports

Saved Reports

Reset password

Choose a new password

Complete your account setup

Southern Soil Lab

Daily tasks

Samples

Enter New Samples

Batch Information

Entry mode

Manual

Sample Info

Live Preview

Run control

All crops

Edit crop

Users

Create user

All users

pH Robot CSV Import

Import ICP (PerkinElmer CSV)

Organic Matter — Batch Entry

Calculate recommendations