Design Document of Neper Wheat

Problem Solver:Harvest

Top Specialist :Harvest Spec.

Plan:mechanicPlan

Sponsor

Row Number	Combine Avaliable	Results
1	= Yes	Perfect
2	~=Yes	Roleout

Task:HarvestByCombine

Step:Harvest_method

Value Holder: Harvest method

Row Number	Results
1	Harvest using combine

Step:Harvest Date LL

Value Holder: Harvest Date LL

Row Number	Results
1	Age LL

Step:Harvest Date UL

Value Holder: Harvest Date UL

Row Number	Results
1	Age UL

Step:HarvestCost

Value Holder: TotHarvestCost

Row Number	Cost	Results
1	= Yes	combineCost+(LaborCost/5)

Plan:HarvestByHand

Sponsor

Row Number	Tractor Mounted with Mower Avaliable	Combine Avaliable	Results
1	~=Yes	~=Yes	Perfect
2	= Yes	= Yes	Roleout
3	= Yes	~=Yes	Roleout
4	~=Yes	= Yes	Roleout

Task:HarvestByHandTask

Step:har method

Value Holder: Harvest method

Row Number	Results
1	Harvest by hand

Step:Harvest Date LLStep

Value Holder: Harvest Date LL

Row Number	Results
1	Age LL

Step:Harvest Date ULStep

Value Holder: Harvest Date UL

Row Number	Results
1	Age UL

Step:HarvestCostStep

Value Holder: TotHarvestCost

Row Number	Cost	Results
1	= Yes	8*LaborCost

Step:ThreshingMethod St.

Value Holder: thrMethod

Row Number	Results
1	Threshing Machine

Step:ThreshCost st.

Value Holder: TotThreshingCost

Row Number	Cost	Results
1	= Yes	ThreshMachCost+(5*LaborCost/3)

Step:UpperThreshingDate st.

Value Holder: threshUL

Row Number	Results
1	Age UL+1

Step:LowerThreshingDate st.

Value Holder: threshLL

Row Number	Results
1	Age LL+1

Plan:HalfMechanical

Sponsor

Row Number	Tractor Mounted with Mower Avaliable	Results
1	= Yes	Perfect
2	~=Yes	Roleout

Task:HarvestHalfMechanical

Step:Harv method

Value Holder: Harvest method

Row Number	Results
1	Harvest by tractor mounted with mower

Step:Harvest Date LL sp.

Value Holder: Harvest Date LL

Row Number	Results
1	Age LL

Step:Harvest Date UL sp.

Value Holder: Harvest Date UL

Row Number	Results
1	Age UL

Step:HarvestCost stp.

Value Holder: TotHarvestCost

Row Number	Cost	Results
1	= Yes	ThreshMachCost+((7*LaborCost/3) )+Tractor Cost

Step:Threshing_methodSt.

Value Holder: thrMethod

Row Number	Results
1	Threshing Machine

Step:threshCost st.

Value Holder: TotThreshingCost

Row Number	Cost	Results
1	= Yes	ThreshMachCost+((5*LaborCost/3) )

Step:LowerThreshingDate1 st.

Value Holder: threshLL

Row Number	Results
1	Age LL+1

Step:UpperThreshingDate1 st.

Value Holder: threshUL

Row Number	Results
1	Age UL+1

Problem Solver:Land Prep.

Top Specialist :Land Prep. Spec

Plan:Land Preparation Plan

Sponsor

Row Number	Results
1	Perfect

Task:Soil Sandy task

Step:clode step

Value Holder: Soil Clouds

Row Number	SoilType	Results
1	= Sandy	No

Step:stone step

Value Holder: Soil Stone

Row Number	SoilType	Results
1	= Sandy	No

Step:plant type step

Value Holder: PlantingType

Row Number	SoilType	Results
1	= Sandy	Dry

Task:Wet Sowing Mehtod Task

Step:Wet Sowing Mehtod Step

Value Holder: Sowing method

Row Number	PlantingType	Results
1	= Wet	Broadcast

Task:Drainage Task

Step:Drainage DateN Step

Value Holder: Drainage DateN

Row Number	Region	DrainageProblem	DrainageSystem	Soil Clouds	SalinityProblem	PlantingType	Used subsoiler	Subsoiler available	Results
1	~=Rain Fed Area	= Yes	= Good	?	?	~=Wet	?	~=No	-8
2	~=Rain Fed Area	= Yes	= Good	?	?	= Wet	?	~=No	-15
3	~=Rain Fed Area	= No	?	= Yes	?	~=Wet	= No	~=No	-8
4	~=Rain Fed Area	= No	?	= Yes	?	= Wet	= No	~=No	-15
5	~=Rain Fed Area	= No	?	= No	= major	~=Wet	?	~=No	-8
6	~=Rain Fed Area	= No	?	= No	= major	= Wet	?	~=No	-15

Step:Drainage equipment Step

Value Holder: Drainage equipment

Row Number	Region	DrainageProblem	DrainageSystem	Soil Clouds	SalinityProblem	Used subsoiler	Subsoiler available	Results
1	~=Rain Fed Area	= Yes	= Good	?	?	?	~=No	Subsoiler
2	~=Rain Fed Area	= No	?	= Yes	?	= No	~=No	Subsoiler
3	~=Rain Fed Area	= No	?	= No	= major	?	~=No	Subsoiler

Step:Drainage mehtod Step

Value Holder: Drainage method

Row Number	Region	DrainageProblem	DrainageSystem	Soil Clouds	SalinityProblem	Used subsoiler	Subsoiler available	Results
1	~=Rain Fed Area	= Yes	= Good	?	?	?	~=No	Plowing depth should be 50 cm
2	~=Rain Fed Area	= No	?	= Yes	?	= No	~=No	Plowing depth should be 50 cm. This operation done every three years.
3	~=Rain Fed Area	= No	?	= No	= major	?	~=No	Plowing depth should be 50 cm

Step:Drainage cost Step

Value Holder: Drainage cost

Row Number	Cost	Region	DrainageProblem	DrainageSystem	Soil Clouds	SalinityProblem	Used subsoiler	Subsoiler available	Results
1	= Yes	~=Rain Fed Area	= Yes	= Good	?	?	?	~=No	round(Subsoiler cost/2)
2	= Yes	~=Rain Fed Area	?	?	= Yes	?	= No	~=No	round(Subsoiler cost/2)
3	= Yes	~=Rain Fed Area	?	?	= No	= major	?	~=No	round(Subsoiler cost/2)

Task:Tillage wet Task

Step:Tillage wet dateN Step

Value Holder: Tillage wet dateN

Row Number	Region	PlantingType	Chisel plow available	Results
1	~=Rain Fed Area	= Wet	~=No	-15

Step:Tillage wet equipment Step

Value Holder: Tillage wet equipment

Row Number	Region	PlantingType	Chisel plow available	Results
1	~=Rain Fed Area	= Wet	~=No	Chisel plow

Step:Tillage wet mehtod Step

Value Holder: Tillage wet method

Row Number	Region	SoilType	PlantingType	Chisel plow available	Results
1	~=Rain Fed Area	= Sandy/calc-mixed	= Wet	~=No	Plow once and the plowing depth should not be more than 15 cm
2	~=Rain Fed Area	= Black	= Wet	~=No	Plow twice perpendicularly and the plowing depth should not be more than 15 cm
3	~=Rain Fed Area	= Calcarious	?	~=No	Plow twice perpendicularly and the plowing depth should not be more than 15 cm

Step:Tillage wet cost Step

Value Holder: Tillage wet cost

Row Number	Cost	Region	PlantingType	Chisel plow available	SoilType	Results
1	= Yes	~=Rain Fed Area	= Wet	~=No	= Sandy/calc-mixed	Chisel plow cost*1.25
2	= Yes	~=Rain Fed Area	= Wet	~=No	= Black	Chisel plow cost1.252
3	= Yes	~=Rain Fed Area	= Wet	~=No	= Calcarious	Chisel plow cost1.252

Task:Tillage Task

Step:Tillage DateN Step

Value Holder: Tillage DateN

Row Number	Region	SoilType	Sowing method	Disk plow available	Chisel plow available	PlantingType	Results
1	~=Rain Fed Area	~=Sandy	~=Direct planting tool	?	~=No	~=Wet	-7
2	~=Rain Fed Area	~=Sandy	?	?	~=No	= Wet	0
3	~=Rain Fed Area	= Sandy	~=Direct planting tool	~=No	?	~=Wet	-7

Step:Tillage equipment Step

Value Holder: Tillage equipment

Row Number	Region	SoilType	Sowing method	Chisel plow available	Disk plow available	Results
1	~=Rain Fed Area	= Sandy	~=Direct planting tool	?	~=No	Disk plow
2	~=Rain Fed Area	?	~=Direct planting tool	~=No	?	Chisel plow

Step:Tillage method Step

Value Holder: Tillage method

Row Number	Region	SoilType	Sowing method	Chisel plow available	Disk plow available	Tillage equipment	Results
1	~=Rain Fed Area	= Sandy	~=Direct planting tool	?	~=No	= Disk plow	Plow once and the plowing depth should not be more than 20 cm
2	~=Rain Fed Area	= Sandy	~=Direct planting tool	~=No	?	= Chisel plow	Plow once and the plowing depth should not be more than 15 cm.
3	~=Rain Fed Area	= Sandy/calc-mixed	~=Direct planting tool	~=No	?	= Chisel plow	Plow once and the plowing depth should not be more than 15 cm
4	~=Rain Fed Area	= Black	~=Direct planting tool	~=No	?	= Chisel plow	Plow twice perpendicularly and the plowing depth should not be more than 15 cm
5	~=Rain Fed Area	= Calcarious	~=Direct planting tool	~=No	?	= Chisel plow	Plow twice perpendicularly and the plowing depth should not be more than 15 cm

Step:Tillage cost Step

Value Holder: Tillage cost

Row Number	Cost	Region	SoilType	Sowing method	Chisel plow available	Disk plow available	Tillage equipment	Results
1	= Yes	~=Rain Fed Area	= Sandy	~=Direct planting tool	?	~=No	= Disk plow	Disk plow cost*1.5
2	= Yes	~=Rain Fed Area	= Sandy	~=Direct planting tool	~=No	?	= Chisel plow	Chisel plow cost*1.25
3	= Yes	~=Rain Fed Area	= Sandy/calc-mixed	~=Direct planting tool	~=No	?	= Chisel plow	Chisel plow cost*1.25
4	= Yes	~=Rain Fed Area	= Black	~=Direct planting tool	~=No	?	= Chisel plow	Chisel plow cost1.252
5	= Yes	~=Rain Fed Area	= Calcarious	~=Direct planting tool	~=No	?	= Chisel plow	Chisel plow cost1.252

Task:Weed Task

Step:Weed dateN Step

Value Holder: Remove weed dateN

Row Number	Weed Exist	PlantingType	Results
1	= Yes	= Dry	-7
2	= Yes	= Wet	-15

Step:Weed equipment Step

Value Holder: Remove Weed equipment

Row Number	Weed Exist	Weeds collector available	Results
1	= Yes	= Yes	weeds collector
2	= Yes	~=Yes	manual

Step:Weed mehtod Step

Value Holder: Remove weed method

Row Number	Weed Exist	Weeds collector available	Results
1	= Yes	= Yes	You must collect all weeds after each run outside field boarder
2	= Yes	~=Yes	You must collect all weeds and burn it outside field boarder

Step:Weed cost Step

Value Holder: Remove weed cost

Row Number	Cost	Weed Exist	Weeds collector available	Soil Stone	Results
1	= Yes	= Yes	= Yes	= Yes	Weeds collector cost
2	= Yes	= Yes	= Yes	~=Yes	Weeds collector cost/2
3	= Yes	= Yes	~=Yes	?	LaborCost*2

Task:Soil fine Task

Step:Soil fine dateN Step

Value Holder: Soil fine DateN

Row Number	SoilType	Region	Sowing method	Soil Clouds	Disk haorrow available	Rotary tiller available	PlantingType	Results
1	~=Sandy	~=Rain Fed Area	= Drill	?	?	~=No	?	-7
2	~=Sandy	~=Rain Fed Area	= Drill	?	~=No	?	?	-7
3	~=Sandy	~=Rain Fed Area	= Broadcast	= Yes	?	~=No	= Dry	-7
4	~=Sandy	~=Rain Fed Area	= Broadcast	= Yes	~=No	?	= Dry	-7
5	~=Sandy	~=Rain Fed Area	= Broadcast	= Yes	?	~=No	= Wet	0
6	~=Sandy	~=Rain Fed Area	= Broadcast	= Yes	~=No	?	= Wet	0

Step:Soil fine equipment Step

Value Holder: Soil fine equipment

Row Number	SoilType	Region	Sowing method	Soil Clouds	Rotary tiller available	Disk haorrow available	Results
1	~=Sandy	~=Rain Fed Area	= Drill	?	~=No	?	Rotary tiller
2	~=Sandy	~=Rain Fed Area	= Drill	?	?	~=No	Disk haorrow
3	~=Sandy	~=Rain Fed Area	= Broadcast	= Yes	~=No	?	Rotary tiller
4	~=Sandy	~=Rain Fed Area	= Broadcast	= Yes	?	~=No	Disk haorrow

Step:Soil fine cost Step

Value Holder: Soil fine cost

Row Number	Cost	Region	SoilType	Sowing method	Soil Clouds	Disk haorrow available	Rotary tiller available	Soil fine equipment	Results
1	= Yes	~=Rain Fed Area	~=Sandy	= Drill	?	?	~=No	= Rotary tiller	Rotary tiller cost*1
2	= Yes	~=Rain Fed Area	~=Sandy	= Drill	?	~=No	?	= Disk haorrow	Disk haorrow cost*1
3	= Yes	~=Rain Fed Area	~=Sandy	= Broadcast	= Yes	?	~=No	= Rotary tiller	Rotary tiller cost
4	= Yes	~=Rain Fed Area	~=Sandy	= Broadcast	= Yes	~=No	?	= Disk haorrow	Disk haorrow cost*1

Task:Leveling Task

Step:Leveling dateN Step

Value Holder: Leveling DateN

Row Number	Region	PlantingType	IrrigtationType	Leveling by laser	Field leveler available	Laser available	Results
1	~=Rain Fed Area	= Dry	= Flood	~=Yes	?	~=No	-7
2	~=Rain Fed Area	= Dry	= Flood	~=Yes	~=No	?	-7

Step:Leveling equipment Step

Value Holder: Leveling equipment

Row Number	Region	PlantingType	IrrigtationType	Leveling by laser	Field leveler available	Laser available	Results
1	~=Rain Fed Area	= Dry	= Flood	~=Yes	?	~=No	Laser
2	~=Rain Fed Area	= Dry	= Flood	~=Yes	~=No	?	Field leveler

Step:Leveling method Step

Value Holder: Leveling method

Row Number	Region	PlantingType	IrrigtationType	Leveling by laser	Field leveler available	Laser available	Leveling equipment	Results
1	~=Rain Fed Area	= Dry	= Flood	~=Yes	?	~=No	= Laser	Level the soil using laser once every three years
2	~=Rain Fed Area	= Dry	= Flood	~=Yes	~=No	?	= Field leveler	Level the soil twice perpendicularly

Step:Leveling cost Step

Value Holder: Leveling cost

Row Number	Cost	Region	PlantingType	IrrigtationType	Leveling by laser	Field leveler available	Laser available	Leveling equipment	Results
1	= Yes	~=Rain Fed Area	= Dry	= Flood	~=Yes	?	~=No	= Laser	Laser cost*2
2	= Yes	~=Rain Fed Area	= Dry	= Flood	~=Yes	~=No	?	= Field leveler	Field leveler cost*3

Task:Stone Picker Task

Step:Stone picker dateN Step

Value Holder: Stone picker dateN

Row Number	Region	Soil Stone	Stonepicker available	PlantingType	Results
1	~=Rain Fed Area	= Yes	= Yes	= Dry	-7
2	~=Rain Fed Area	= Yes	= Yes	= Wet	0

Step:Stone picker equipment Step

Value Holder: Stone picker equipment

Row Number	Region	Soil Stone	Stonepicker available	Results
1	~=Rain Fed Area	= Yes	= Yes	Stonepicker

Step:Stone picker method Step

Value Holder: Stone picker method

Row Number	Region	Soil Stone	Stonepicker available	Results
1	~=Rain Fed Area	= Yes	= Yes	All picked stone must be dumped outside the field

Step:Stone picker cost Step

Value Holder: Stone picker operation cost

Row Number	Cost	Region	Soil Stone	Stonepicker available	Results
1	= Yes	~=Rain Fed Area	= Yes	= Yes	Stonepicker cost*2

Task:Basin Task

Step:Basin divide dateN Step

Value Holder: Basin DateN

Row Number	Region	IrrigtationType	SoilType	Results
1	~=Rain Fed Area	= Flood	~=Sandy	0

Step:Leveling Step

Value Holder: Laser leveling

Row Number	Region	IrrigtationType	PlantingType	SoilType	Leveling by laser	Laser available	Field leveler available	Leveling equipment	Results
1	~=Rain Fed Area	= Flood	= Dry	~=Sandy	= Yes	?	?	?	Yes
2	~=Rain Fed Area	= Flood	= Dry	~=Sandy	~=Yes	~=No	?	= Laser	Yes
3	~=Rain Fed Area	= Flood	= Dry	~=Sandy	~=Yes	?	~=No	= Field leveler	No
4	~=Rain Fed Area	= Flood	= Dry	~=Sandy	~=Yes	= No	?	?	No
5	~=Rain Fed Area	= Flood	~=Dry	~=Sandy	?	?	?	?	No

Step:Harvest Mehtod Step

Value Holder: Harvest method

Row Number	Region	IrrigtationType	SoilType	Combine Avaliable	Tractor Mounted with Mower Avaliable	Results
1	~=Rain Fed Area	= Flood	~=Sandy	= Yes	?	Harvest using combine
2	~=Rain Fed Area	= Flood	~=Sandy	?	= Yes	Harvest by tractor mounted with mower
3	~=Rain Fed Area	= Flood	~=Sandy	~=Yes	~=Yes	Harvest by hand

Step:Basin size Step

Value Holder: Basin divide size

Row Number	Region	SoilType	IrrigtationType	SalinityProblem	Harvest method	Laser available	Leveling status	Results
1	~=Rain Fed Area	= Black	= Flood	~=major	~=Harvest using combine	= Yes	?	Divide your land into basins with the dimensions is 9 (or multiplicity of 3) m X 75 to 125 m approximately.
2	~=Rain Fed Area	= Black	= Flood	~=major	= Harvest using combine	= Yes	?	Divide your land into basins with the dimensions is 12 (or multiplicity of 6) m X 75 to 125 m approximately.
3	~=Rain Fed Area	= Black	= Flood	~=major	~=Harvest using combine	= No	= No	Divide your land into basins with the dimensions is 6 m X 20 m approximately.
4	~=Rain Fed Area	= Black	= Flood	~=major	= Harvest using combine	= No	= No	Divide your land into basins with the dimensions is 6 m X 75 m approximately.
5	~=Rain Fed Area	= Calcarious	= Flood	~=major	~=Harvest using combine	= Yes	?	Divide your land into basins with the dimensions is 9 (or multiplicity of 3) m X 75 to 125 m approximately.
6	~=Rain Fed Area	= Calcarious	= Flood	~=major	= Harvest using combine	= Yes	?	Divide your land into basins with the dimensions is 12 (or multiplicity of 6) m X 75 to 125 m approximately.
7	~=Rain Fed Area	= Calcarious	= Flood	~=major	~=Harvest using combine	= No	= No	Divide your land into basins with the dimensions is 6 m X 20 m approximately.
8	~=Rain Fed Area	= Calcarious	= Flood	~=major	= Harvest using combine	= No	= No	Divide your land into basins with the dimensions is 6 m X 75 m approximately.
9	~=Rain Fed Area	= Sandy/calc-mixed	= Flood	~=major	~=Harvest using combine	= No	= No	Divide your land into basins with the dimensions is 9 m X 20 m approximately.
10	~=Rain Fed Area	= Sandy/calc-mixed	= Flood	~=major	= Harvest using combine	= No	= No	Divide your land into basins with the dimensions is 6 m X 50 m approximately.
11	~=Rain Fed Area	= Sandy/calc-mixed	= Flood	~=major	~=Harvest using combine	= Yes	?	Divide your land into basins with the dimensions is 9 m X 50 m approximately
12	~=Rain Fed Area	= Sandy/calc-mixed	= Flood	~=major	= Harvest using combine	= Yes	?	Divide your land into basins with the dimensions is 12 m X 50 m approximately.
13	~=Rain Fed Area	~=Sandy	= Flood	~=major	?	= No	= Yes	Divide your land into basin according to the land leveling
14	~=Rain Fed Area	~=Sandy	= Flood	= major	?	?	?	Divide your land into basins with the dimensions is 3 m X 6 m approximately.

Step:Basin divide tool Step

Value Holder: Basin divide tool

Row Number	Region	SoilType	IrrigtationType	Laser leveling	Leveling status	Ditcher available	Ridger available	Results
1	~=Rain Fed Area	~=Sandy	= Flood	= No	= No	~=No	?	Ditcher
2	~=Rain Fed Area	~=Sandy	= Flood	= No	= No	?	~=No	Ridger
3	~=Rain Fed Area	~=Sandy	= Flood	?	?	= No	= No	Laborer
4	~=Rain Fed Area	~=Sandy	= Flood	= No	= Yes	?	?	Laborer
5	~=Rain Fed Area	~=Sandy	= Flood	= Yes	?	~=No	?	Ditcher
6	~=Rain Fed Area	~=Sandy	= Flood	= Yes	?	?	~=No	Ridger

Step:Basin divide cost Step

Value Holder: Basin divide cost

Row Number	Cost	Region	SoilType	IrrigtationType	SalinityProblem	Harvest method	Laser leveling	Leveling status	Basin divide tool	Results
1	= Yes	~=Rain Fed Area	~=Sandy	= Flood	~=major	?	= No	= Yes	= Laborer	LaborCost*3/4
2	= Yes	~=Rain Fed Area	~=Sandy	= Flood	= major	?	?	?	= Laborer	LaborCost*1
3	= Yes	~=Rain Fed Area	~=Sandy	= Flood	= major	?	?	?	= Ridger	Redger cost*1
4	= Yes	~=Rain Fed Area	~=Sandy	= Flood	= major	?	?	?	= Ditcher	Ditcher cost
5	= Yes	~=Rain Fed Area	~=Sandy	= Flood	~=major	~=Harvest using combine	= No	= No	= Laborer	LaborCost*3/4
6	= Yes	~=Rain Fed Area	~=Sandy	= Flood	~=major	~=Harvest using combine	= No	= No	= Ridger	Redger cost*3/4
7	= Yes	~=Rain Fed Area	~=Sandy	= Flood	~=major	~=Harvest using combine	= No	= No	= Ditcher	Ditcher cost*3/4
8	= Yes	~=Rain Fed Area	~=Sandy	= Flood	~=major	?	= Yes	?	= Laborer	LaborCost/2
9	= Yes	~=Rain Fed Area	~=Sandy	= Flood	~=major	?	= Yes	?	= Ridger	Redger cost*1/2
10	= Yes	~=Rain Fed Area	~=Sandy	= Flood	~=major	?	= Yes	?	= Ditcher	Ditcher cost*1/2
11	= Yes	~=Rain Fed Area	~=Sandy	= Flood	~=major	= Harvest using combine	= No	= No	= Laborer	LaborCost/2
12	= Yes	~=Rain Fed Area	~=Sandy	= Flood	~=major	= Harvest using combine	= No	= No	= Ridger	Redger cost*1/2
13	= Yes	~=Rain Fed Area	~=Sandy	= Flood	~=major	= Harvest using combine	= No	= No	= Ditcher	Ditcher cost*1/2

Problem Solver:Fertilization

Top Specialist :Fert Spec

Plan:Fert. Plan

Sponsor

Row Number	Results
1	Perfect

Task:K_Fert_Tsk.

Step:K_Base_St.

Value Holder: K_Base

Row Number	SprinklerValid	AnalysisExist	SoilType	Results
1	= Yes	= Yes	~=Black	((((Yeild_QTY150)/1000)29.5*2)-K_Analysis)
2	= Yes	~=Yes	~=Black	24

Step:K_Qty_St.

Value Holder: K_Qty

Row Number	SoilType	SprinklerValid	Results
1	~=Black	= Yes	((100*K_Base)/48)

Step:K_Name_St.

Value Holder: K_Name

Row Number	SoilType	SprinklerValid	Results
1	~=Black	= Yes	Potassium Sulphate 48% K2O

Step:K_Methode_St.

Value Holder: K_Methode

Row Number	SoilType	Results
1	~=Black	Broadcast

Step:K_Date_St.

Value Holder: K_Date

Row Number	SoilType	Results
1	~=Black	22

Step:K_Cost_St.

Value Holder: K_Cost

Row Number	SprinklerValid	SoilType	Cost	Results
1	= Yes	~=Black	= Yes	(((K_price/50)*K_Qty)+(LaborCost/3))

Task:R_N_Fert_Tsk.

Step:R_N_Qty_St.

Value Holder: RainfedIrrQty

Row Number	SprinklerValid	Region	Results
1	= Yes	= Rain Fed Area	10

Step:R_N_Name_St.

Value Holder: NComerOut

Row Number	SprinklerValid	Region	AmmonuimSulphateAvalable	AmmonuimNitrateAvalable	NComerInNew	Results
1	= Yes	= Rain Fed Area	= Yes	?	?	Ammonuim Sulphate
2	= Yes	= Rain Fed Area	= No	= Yes	?	Ammonuim Nitrate
3	= Yes	= Rain Fed Area	~=Yes	~=Yes	= Ammonuim Sulphate	Ammonuim Sulphate
4	= Yes	= Rain Fed Area	~=Yes	~=Yes	= Ammonuim Nitrate	Ammonuim Nitrate
5	= Yes	= Rain Fed Area	~=Yes	~=Yes	= unknown	Ammonuim Sulphate

Step:R_N_Methode_St.

Value Holder: N_Methode

Row Number	SprinklerValid	Region	Results
1	= Yes	= Rain Fed Area	Broadcasting then covering

Step:R_N_Date_St.

Value Holder: RainfedIrrDate

Row Number	SprinklerValid	Region	Results
1	= Yes	= Rain Fed Area	Cover the seeds and the fertilizer after broadcasting the seeds

Step:R_N_Cost_St.

Value Holder: RainfedIrrCost

Row Number	SprinklerValid	Cost	Region	NComerOut	Results
1	= Yes	= Yes	= Rain Fed Area	= Ammonuim Nitrate	((10*N_Nitrate_Price)+(LaborCost/3))
2	= Yes	= Yes	= Rain Fed Area	= Ammonuim Sulphate	((10*N_Sulphate_Price)+(LaborCost/3))
3	= Yes	= Yes	= Rain Fed Area	= unknown	((10*N_Sulphate_Price)+(LaborCost/3))

Step:R_N_Time_St.

Value Holder: N_Time

Row Number	SprinklerValid	Region	Results
1	= Yes	= Rain Fed Area	Better to application afternoon.

Task:Ph_Fert_Tsk.

Step:Ph_Base_St.

Value Holder: Ph_Base

Row Number	SprinklerValid	SoilType	AnalysisExist	previuos crop	Results
1	= Yes	= Black	~=Yes	= Rice	22.5
2	= Yes	= Black	~=Yes	= Corn	15
3	= Yes	= Black	~=Yes	= Cutton	15
4	= Yes	= Black	~=Yes	= Sorghum maize	15
5	= Yes	= Black	~=Yes	= Legumes	0
6	= Yes	= Black	~=Yes	= Vegetables	0
7	= Yes	= Sandy	~=Yes	?	30
8	= Yes	= Calcarious	~=Yes	?	22.5
9	= Yes	= Sandy/calc-mixed	~=Yes	?	22.5
10	= Yes	?	= Yes	?	((((Yeild_QTY150)/1000)12.5*2)-Ph_Analysis)
11	= Yes	= Black	~=Yes	= unknown	22.5
12	= Yes	= unknown	~=Yes	?	30

Step:Ph_Name_St.

Value Holder: PhComerOut

Row Number	SprinklerValid	Ph_Base	SuperPhosphate15Avalable	SuperPhosphate37Avalable	PhComerIn	Results
1	= Yes	~=0	~=Yes	~=Yes	= Super Phosphate 15%	Super Phosphate 15%
2	= Yes	~=0	~=Yes	~=Yes	= Super phosphate 37%	Super phosphate 37%
3	= Yes	~=0	~=Yes	~=Yes	= unknown	Super Phosphate 15%
4	= Yes	~=0	= Yes	?	?	Super Phosphate 15%
5	= Yes	~=0	?	= Yes	?	Super phosphate 37%

Step:Ph_Type_St.

Value Holder: PhType

Row Number	SprinklerValid	Ph_Base	PhComerOut	Results
1	= Yes	~=0	~=Super phosphate 37%	1
2	= Yes	~=0	= Super phosphate 37%	2

Step:Ph_Qty_St.

Value Holder: Ph_Qty

Row Number	SprinklerValid	Ph_Base	PhType	Results
1	= Yes	~=0	= 1	((100*Ph_Base)/15)
2	= Yes	~=0	= 2	((100*Ph_Base)/37)

Step:Ph_Methode_St.

Value Holder: Ph_Methode

Row Number	SprinklerValid	Ph_Base	Results
1	= Yes	~=0	Broadcast

Step:Ph_Date_St.

Value Holder: Ph_Date

Row Number	SprinklerValid	Ph_Base	PlantingType	Results
1	= Yes	~=0	~=Wet	(-1*(1+TillageDateN))
2	= Yes	~=0	= Wet	(-1*(1+TillagewetdateN))

Step:Ph_Cost_St.

Value Holder: Ph_Cost

Row Number	SprinklerValid	Cost	Ph_Base	PhType	Results
1	= Yes	= Yes	~=0	= 1	(((Ph15_Price/50)*Ph_Qty)+(LaborCost/3))
2	= Yes	= Yes	~=0	= 2	(((Ph37_Price/50)*Ph_Qty)+(LaborCost/3))

Specialist:OM_Fert_Sp.

Plan:Yes_OM_Pln.

Sponsor

Row Number	Results
1	Perfect

Task:OM_Fert_Tsk.

Step:OM_Exist_St.

Value Holder: OM_Exist

Row Number	SprinklerValid	Results
1	= Yes	Yes

Step:OM_Qty_St.

Value Holder: OM_Qty

Row Number	SprinklerValid	SoilType	Results
1	= Yes	= Black	12.5
2	= Yes	~=Black	25

Step:OM_Name_St.

Value Holder: OM_Name

Row Number	SprinklerValid	OM_Exist	Results
1	= Yes	= Yes	Ferment organic manure

Step:OM_Methode_St.

Value Holder: OM_Methode

Row Number	SprinklerValid	OM_Exist	Results
1	= Yes	= Yes	Broad Cast

Step:OM_Date_St.

Value Holder: OM_Date

Row Number	SprinklerValid	PlantingType	OM_Exist	Results
1	= Yes	~=Wet	= Yes	(-1*(1+TillageDateN))
2	= Yes	= Wet	= Yes	(-1*(1+TillagewetdateN))

Step:OM_Cost_St.

Value Holder: OM_Cost

Row Number	SprinklerValid	Cost	OM_Exist	Results
1	= Yes	= Yes	= Yes	((OM_PriceOM_Qty)+(1.5LaborCost))

Plan:No_OM_Pln.

Sponsor

Row Number	Results
1	Perfect

Task:No_OM_Tsk.

Step:No_OM_St.

Value Holder: OM_Exist

Row Number	SprinklerValid	Results
1	= Yes	No

Task:N_Base_Tsk.

Step:N_Base_St.

Value Holder: N_Base_Qty

Row Number	SprinklerValid	AnalysisExist	SoilType	PreviuosCropNew	PreviuosCrop	OM_Exist	Results
1	= Yes	~=Yes	= Black	?	= Legumes	= Yes	(60-(OM_Qty/2))
2	= Yes	~=Yes	= Black	?	= Legumes	= No	60
3	= Yes	~=Yes	= Sandy	= Legumes	?	= Yes	(85-(OM_Qty/2))
4	= Yes	~=Yes	= Sandy	= Legumes	?	= No	85
5	= Yes	~=Yes	= Calcarious	= Legumes	?	= Yes	(75-(OM_Qty/2))
6	= Yes	~=Yes	= Calcarious	= Legumes	?	= No	75
7	= Yes	~=Yes	= Sandy/calc-mixed	= Legumes	?	= Yes	(75-(OM_Qty/2))
8	= Yes	~=Yes	= Sandy/calc-mixed	= Legumes	?	= No	75
9	= Yes	~=Yes	= Black	?	= Corn	= Yes	(75-(OM_Qty/2))
10	= Yes	~=Yes	= Black	?	= Corn	= No	75
11	= Yes	~=Yes	= Black	?	= Cotton	= Yes	(75-(OM_Qty/2))
12	= Yes	~=Yes	= Black	?	= Cotton	= No	75
13	= Yes	~=Yes	= Black	?	= Rice	= Yes	(75-(OM_Qty/2))
14	= Yes	~=Yes	= Black	?	= Rice	= No	75
15	= Yes	~=Yes	= Black	?	= Sorghum maize	= Yes	(75-(OM_Qty/2))
16	= Yes	~=Yes	= Black	?	= Sorghum maize	= No	75
17	= Yes	~=Yes	= Sandy	= Corn	?	= Yes	(100-(OM_Qty/2))
18	= Yes	~=Yes	= Sandy	= Corn	?	= No	100
19	= Yes	~=Yes	= Sandy	= Cotton	?	= Yes	(100-(OM_Qty/2))
20	= Yes	~=Yes	= Sandy	= Cotton	?	= No	100
21	= Yes	~=Yes	= Sandy	= Sorghum maize	?	= Yes	(100-(OM_Qty/2))
22	= Yes	~=Yes	= Sandy	= Sorghum maize	?	= No	100
23	= Yes	~=Yes	= Calcarious	= Corn	?	= Yes	(90-(OM_Qty/2))
24	= Yes	~=Yes	= Calcarious	= Corn	?	= No	90
25	= Yes	~=Yes	= Calcarious	= Cotton	?	= Yes	(90-(OM_Qty/2))
26	= Yes	~=Yes	= Calcarious	= Cotton	?	= No	90
27	= Yes	~=Yes	= Calcarious	= Sorghum maize	?	= Yes	(90-(OM_Qty/2))
28	= Yes	~=Yes	= Calcarious	= Sorghum maize	?	= No	90
29	= Yes	~=Yes	= Sandy/calc-mixed	= Corn	?	= Yes	(90-(OM_Qty/2))
30	= Yes	~=Yes	= Sandy/calc-mixed	= Corn	?	= No	90
31	= Yes	~=Yes	= Sandy/calc-mixed	= Cotton	?	= Yes	(90-(OM_Qty/2))
32	= Yes	~=Yes	= Sandy/calc-mixed	= Cotton	?	= No	90
33	= Yes	~=Yes	= Sandy/calc-mixed	= Sorghum maize	?	= Yes	(90-(OM_Qty/2))
34	= Yes	~=Yes	= Sandy/calc-mixed	= Sorghum maize	?	= No	90
35	= Yes	~=Yes	= Black	?	= Vegetables	= Yes	((75/2)-(OM_Qty/2))
36	= Yes	~=Yes	= Black	?	= Vegetables	= No	37.5
37	= Yes	~=Yes	= Sandy	= Vegetables	?	= Yes	(75-(OM_Qty/2))
38	= Yes	~=Yes	= Sandy	= Vegetables	?	= No	75
39	= Yes	~=Yes	= Calcarious	= Vegetables	?	= Yes	((135/2)-(OM_Qty/2))
40	= Yes	~=Yes	= Calcarious	= Vegetables	?	= No	67.5
41	= Yes	~=Yes	= Sandy/calc-mixed	= Vegetables	?	= Yes	((135/2)-(OM_Qty/2))
42	= Yes	~=Yes	= Sandy/calc-mixed	= Vegetables	?	= No	67.5
43	= Yes	= Yes	?	?	?	?	((((Yeild_QTY150)/1000)28.3*2)-N_Analysis)
44	= Yes	~=Yes	= Black	?	= unknown	= No	(75-(OM_Qty/2))
45	= Yes	~=Yes	= Black	?	= unknown	= Yes	75
46	= Yes	~=Yes	= Calcarious	= unknown	?	= No	(90-(OM_Qty/2))
47	= Yes	~=Yes	= Calcarious	= unknown	?	= Yes	90
48	= Yes	~=Yes	= Sandy	= unknown	?	= No	(100-(OM_Qty/2))
49	= Yes	~=Yes	= Sandy	= unknown	?	= Yes	100
50	= Yes	~=Yes	= Sandy/calc-mixed	= unknown	?	= No	(90-(OM_Qty/2))
51	= Yes	~=Yes	= Sandy/calc-mixed	= unknown	?	= Yes	90
52	= Yes	~=Yes	= unknown	?	?	= No	(90-(OM_Qty/2))
53	= Yes	~=Yes	= unknown	?	?	= Yes	90

Specialist:N_Fert_Sp.

Plan:N_Flood_Pln.

Sponsor

Row Number	IrrigtationType	SprinklerValid	Results
1	~=Sprinkler	= Yes	Perfect
2	= Sprinkler	= Yes	Roleout
3	?	= No	Roleout

Task:NOfFertFlood_Tsk.

Step:NOfFertSt.

Value Holder: NOfFert

Row Number	SoilType	PreviuosCrop	PreviuosCrop	OM_Exist	Results
1	?	?	?	= Yes	2
2	= Black	~=Legumes	~=Vegetables	~=Yes	3
3	~=Black	?	?	~=Yes	3
4	= Black	= Legumes	?	~=Yes	2
5	= Black	= Vegetables	?	~=Yes	2

Step:F_N_Name_St.

Value Holder: NComerOut

Row Number	SoilType	UreaAvalable	AmmonuimSulphateAvalable	AmmonuimNitrateAvalable	NComerInOld	NComerInNew	Results
1	= Black	= Yes	?	?	?	?	Urea
2	= Black	?	= Yes	?	?	?	Ammonuim Sulphate
3	= Black	?	?	= Yes	?	?	Ammonuim Nitrate
4	~=Black	?	= Yes	?	?	?	Ammonuim Sulphate
5	~=Black	?	?	= Yes	?	?	Ammonuim Nitrate
6	= Black	~=Yes	~=Yes	~=Yes	= Urea	?	Urea
7	= Black	~=Yes	~=Yes	~=Yes	= Ammonuim Sulphate	?	Ammonuim Sulphate
8	= Black	~=Yes	~=Yes	~=Yes	= Ammonuim Nitrate	?	Ammonuim Nitrate
9	= Black	~=Yes	~=Yes	~=Yes	= unknown	?	Urea
10	~=Black	?	~=Yes	~=Yes	?	= Ammonuim Sulphate	Ammonuim Sulphate
11	~=Black	?	~=Yes	~=Yes	?	= Ammonuim Nitrate	Ammonuim Nitrate
12	~=Black	?	~=Yes	~=Yes	?	= unknown	Ammonuim Sulphate

Step:F_N_Methode_St.

Value Holder: N_Methode

Row Number	Results
1	Broadcast

Step:F_N_Time_St.

Value Holder: N_Time

Row Number	Results
1	Before irrigation immediately.

Step:F_N_Type_St.

Value Holder: N_Type

Row Number	NComerOut	Results
1	= Ammonuim Nitrate	1
2	= Ammonuim Sulphate	2
3	= Urea	3

Task:F_N_1Dose_Tsk.

Step:N1_Qty_St.

Value Holder: NQty1

Row Number	NOfFert	SoilType	N_Type	Results
1	= 2	= Black	= 1	((100*(N_Base_Qty/2))/20.6)
2	= 2	= Black	= 2	((100*(N_Base_Qty/2))/46)
3	= 2	= Black	= 3	((100*(N_Base_Qty/2))/33.5)
4	= 2	~=Black	= 1	((100*(N_Base_Qty/2))/20.6)
5	= 2	~=Black	= 2	((100*(N_Base_Qty/5))/33.5)
6	= 3	= Black	= 1	((100*(N_Base_Qty/5))/20.6)
7	= 3	= Black	= 2	((100*(N_Base_Qty/5))/46)
8	= 3	= Black	= 3	((100*(N_Base_Qty/5))/33.5)
9	= 3	~=Black	= 1	((100*(N_Base_Qty/5))/20.6)
10	= 3	~=Black	= 2

Step:N1_Date_St.

Value Holder: NDate1

Row Number	NOfFert	PlantingType	Results
1	= 2	?	Flood2ndIrrnDate
2	= 3	~=Wet	Flood1stIrrnDate
3	= 3	= Wet	Flood1stIrrnDate

Step:N1_Cost_St.

Value Holder: NCost1

Row Number	Cost	SoilType	N_Type	Results
1	= Yes	= Black	= 1	(((N_Nitrate_Price/50)*NQty1)+(LaborCost/3))
2	= Yes	= Black	= 2	(((N_Sulphate_Price/50)*NQty1)+(LaborCost/3))
3	= Yes	= Black	= 3	(((N_Urea_Price/50)*NQty1)+(LaborCost/3))
4	= Yes	~=Black	= 1	(((N_Nitrate_Price/50)*NQty1)+(LaborCost/3))
5	= Yes	~=Black	= 2	(((N_Sulphate_Price/50)*NQty1)+(LaborCost/3))

Task:F_N_2Dose_Tsk.

Step:N2_Qty_St.

Value Holder: NQty2

Row Number	NOfFert	SoilType	N_Type	Results
1	= 2	= Black	= 1	((100*(N_Base_Qty/2))/33.5)
2	= 2	= Black	= 2	((100*(N_Base_Qty/2))/20.6)
3	= 2	= Black	= 3	((100*(N_Base_Qty/2))/46)
4	= 2	~=Black	= 1	((100*(N_Base_Qty/2))/33.5)
5	= 2	~=Black	= 2	((100*(N_Base_Qty/2))/20.6)
6	= 3	= Black	= 1	((200*(N_Base_Qty/5))/33.5)
7	= 3	= Black	= 2	((200*(N_Base_Qty/5))/20.6)
8	= 3	= Black	= 3	((200*(N_Base_Qty/5))/46)
9	= 3	~=Black	= 1	((200*(N_Base_Qty/5))/33.5)
10	= 3	~=Black	= 2	((200*(N_Base_Qty/5))/20.6)

Step:N2_Date_St.

Value Holder: NDate2

Row Number	NOfFert	Results
1	= 2	Flood3rdIrrnDate
2	= 3	Flood2ndIrrnDate

Step:N2_Cost_St.

Value Holder: NCost2

Row Number	Cost	SoilType	N_Type	Results
1	= Yes	= Black	= 1	(((N_Nitrate_Price/50)*NQty2)+(LaborCost/3))
2	= Yes	= Black	= 2	(((N_Sulphate_Price/50)*NQty2)+(LaborCost/3))
3	= Yes	= Black	= 3	(((N_Urea_Price/50)*NQty2)+(LaborCost/3))
4	= Yes	~=Black	= 1	(((N_Nitrate_Price/50)*NQty2)+(LaborCost/3))
5	= Yes	~=Black	= 2	(((N_Sulphate_Price/50)*NQty2)+(LaborCost/3))

Task:F_N_3Dose_Tsk.

Step:N3_Qty_St.

Value Holder: NQty3

Row Number	NOfFert	SoilType	N_Type	Results
1	= 3	= Black	= 1	((200*(N_Base_Qty/5))/33.5)
2	= 3	= Black	= 2	((200*(N_Base_Qty/5))/20.6)
3	= 3	= Black	= 3	((200*(N_Base_Qty/5))/46)
4	= 3	~=Black	= 1	((200*(N_Base_Qty/5))/33.5)
5	= 3	~=Black	= 2	((200*(N_Base_Qty/5))/20.6)

Step:N3_Date_St.

Value Holder: NDate3

Row Number	NOfFert	Results
1	= 3	Flood3rdIrrnDate

Step:N3_Cost_St.

Value Holder: NCost3

Row Number	NOfFert	Cost	SoilType	N_Type	Results
1	= 3	= Yes	= Black	= 1	(((N_Nitrate_Price/50)*NQty3)+(LaborCost/3))
2	= 3	= Yes	= Black	= 2	(((N_Sulphate_Price/50)*NQty3)+(LaborCost/3))
3	= 3	= Yes	= Black	= 3	(((N_Urea_Price/50)*NQty3)+(LaborCost/3))
4	= 3	= Yes	~=Black	= 1	(((N_Nitrate_Price/50)*NQty3)+(LaborCost/3))
5	= 3	= Yes	~=Black	= 2	(((N_Sulphate_Price/50)*NQty3)+(LaborCost/3))

Step:N_Total_Cost_St.

Value Holder: N_T_Cost

Row Number	Cost	NOfFert	Results
1	= Yes	= 2	(NCost1+NCost2)
2	= Yes	= 3	(NCost1+NCost2+NCost3)

Plan:N_Sprinkler_Pln.

Sponsor

Row Number	IrrigtationType	SprinklerValid	Results
1	= Sprinkler	= Yes	Perfect
2	~=Sprinkler	= Yes	Roleout
3	?	= No	Roleout

Task:NOfFertSprinklerTsk

Step:NOfFertSprinklerSt.

Value Holder: NOfFert

Row Number	InjectTankExist	Results
1	= Yes	10
2	~=Yes	6

Step:S_N_Name_St.

Value Holder: NComerOut

Row Number	SoilType	UreaAvalable	AmmonuimSulphateAvalable	AmmonuimNitrateAvalable	NComerInOld	NComerInNew	Results
1	= Black	= Yes	?	?	?	?	Urea
2	= Black	?	= Yes	?	?	?	Ammonuim Sulphate
3	= Black	?	?	= Yes	?	?	Ammonuim Nitrate
4	~=Black	?	= Yes	?	?	?	Ammonuim Sulphate
5	~=Black	?	?	= Yes	?	?	Ammonuim Nitrate
6	= Black	~=Yes	~=Yes	~=Yes	= Urea	?	Urea
7	= Black	~=Yes	~=Yes	~=Yes	= Ammonuim Sulphate	?	Ammonuim Sulphate
8	= Black	~=Yes	~=Yes	~=Yes	= Ammonuim Nitrate	?	Ammonuim Nitrate
9	= Black	~=Yes	~=Yes	~=Yes	= unknown	?	Urea
10	~=Black	?	~=Yes	~=Yes	?	= Ammonuim Sulphate	Ammonuim Sulphate
11	~=Black	?	~=Yes	~=Yes	?	= Ammonuim Nitrate	Ammonuim Nitrate
12	~=Black	?	~=Yes	~=Yes	?	= unknown	Ammonuim Sulphate

Step:S_N_Methode_St.

Value Holder: N_Methode

Row Number	NOfFert	Results
1	= 10	Use Injection tank.
2	= 6	Broadcast

Step:S_N_Time_St.

Value Holder: N_Time

Row Number	Results
1	Time of spraying either early in the morning or afternoon.

Step:S_N_Type_St.

Value Holder: N_Type

Row Number	NComerOut	Results
1	= Ammonuim Nitrate	1
2	= Ammonuim Sulphate	2
3	= Urea	3

Task:S_N_1Dose_Tsk.

Step:S_N1_Qty_St.

Value Holder: NQty1

Row Number	NOfFert	SoilType	N_Type	Results
1	= 10	= Black	= 1	((100*(N_Base_Qty/5))/33.5)
2	= 10	= Black	= 2	((100*(N_Base_Qty/5))/20.6)
3	= 10	= Black	= 3	((100*(N_Base_Qty/5))/46)
4	= 10	~=Black	= 1	((100*(N_Base_Qty/5))/33.5)
5	= 10	~=Black	= 2	((100*(N_Base_Qty/5))/20.6)
6	= 6	= Black	= 1	((100*(N_Base_Qty/5))/33.5)
7	= 6	= Black	= 2	((100*(N_Base_Qty/5))/20.6)
8	= 6	= Black	= 3	((100*(N_Base_Qty/5))/46)
9	= 6	~=Black	= 1	((100*(N_Base_Qty/5))/33.5)
10	= 6	~=Black	= 2	((100*(N_Base_Qty/5))/20.6)

Step:S_N1_Date_St.

Value Holder: NDate1

Row Number	Results
1	0

Step:S_N1_Cost_St.

Value Holder: NCost1

Row Number	NOfFert	Cost	SoilType	N_Type	Results
1	= 10	= Yes	= Black	= 1	((N_Nitrate_Price/50)*NQty1)
2	= 10	= Yes	= Black	= 2	((N_Sulphate_Price/50)*NQty1)
3	= 10	= Yes	= Black	= 3	((N_Urea_Price/50)*NQty1)
4	= 10	= Yes	~=Black	= 1	((N_Nitrate_Price/50)*NQty1)
5	= 10	= Yes	~=Black	= 2	((N_Sulphate_Price/50)*NQty1)
6	= 6	= Yes	= Black	= 1	(((N_Nitrate_Price/50)*NQty1)+(LaborCost/3))
7	= 6	= Yes	= Black	= 2	(((N_Sulphate_Price/50)*NQty1)+(LaborCost/3))
8	= 6	= Yes	= Black	= 3	(((N_Urea_Price/50)*NQty1)+(LaborCost/3))
9	= 6	= Yes	~=Black	= 1	(((N_Nitrate_Price/50)*NQty1)+(LaborCost/3))
10	= 6	= Yes	~=Black	= 2	(((N_Sulphate_Price/50)*NQty1)+(LaborCost/3))

Task:S_N_2Dose_Tsk.

Step:S_N2_Qty_St.

Value Holder: NQty2

Row Number	NOfFert	SoilType	N_Type	Results
1	= 10	= Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
2	= 10	= Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)
3	= 10	= Black	= 3	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/46)
4	= 10	~=Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
5	= 10	~=Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)
6	= 6	= Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/33.5)
7	= 6	= Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/20.6)
8	= 6	= Black	= 3	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/46)
9	= 6	~=Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/33.5)
10	= 6	~=Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/20.6)

Step:S_N2_Date_St.

Value Holder: NDate2

Row Number	Results
1	DecDate+DecInterval

Step:S_N2_Cost_St.

Value Holder: NCost2

Row Number	NOfFert	Cost	SoilType	Results
1	= 10	= Yes	= Black	((N_Nitrate_Price/50)*NQty2)
2	= 10	= Yes	= Black	((N_Sulphate_Price/50)*NQty2)
3	= 10	= Yes	= Black	((N_Urea_Price/50)*NQty2)
4	= 10	= Yes	~=Black	((N_Nitrate_Price/50)*NQty2)
5	= 10	= Yes	~=Black	((N_Sulphate_Price/50)*NQty2)
6	= 6	= Yes	= Black	(((N_Nitrate_Price/50)*NQty2)+(LaborCost/3))
7	= 6	= Yes	= Black	(((N_Sulphate_Price/50)*NQty2)+(LaborCost/3))
8	= 6	= Yes	= Black	(((N_Urea_Price/50)*NQty2)+(LaborCost/3))
9	= 6	= Yes	~=Black	(((N_Nitrate_Price/50)*NQty2)+(LaborCost/3))
10	= 6	= Yes	~=Black	(((N_Sulphate_Price/50)*NQty2)+(LaborCost/3))

Task:S_N_3Dose_Tsk.

Step:S_N3_Qty_St.

Value Holder: NQty3

Row Number	NOfFert	SoilType	N_Type	Results
1	= 10	= Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
2	= 10	= Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)
3	= 10	= Black	= 3	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/46)
4	= 10	~=Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
5	= 10	~=Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)
6	= 6	= Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/33.5)
7	= 6	= Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/20.6)
8	= 6	= Black	= 3	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/46)
9	= 6	~=Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/33.5)
10	= 6	~=Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/20.6)

Step:S_N3_Date_St.

Value Holder: NDate3

Row Number	NOfFert	Results
1	= 10	DecDate+(3*DecInterval)
2	= 6	DecDate+(4*DecInterval)

Step:S_N3_Cost_St.

Value Holder: NCost3

Row Number	NOfFert	Cost	SoilType	N_Type	Results
1	= 10	= Yes	= Black	= 1	((N_Nitrate_Price/50)*NQty3)
2	= 10	= Yes	= Black	= 2	((N_Sulphate_Price/50)*NQty3)
3	= 10	= Yes	= Black	= 3	((N_Urea_Price/50)*NQty3)
4	= 10	= Yes	~=Black	= 1	((N_Nitrate_Price/50)*NQty3)
5	= 10	= Yes	~=Black	= 2	((N_Sulphate_Price/50)*NQty3)
6	= 6	= Yes	= Black	= 1	(((N_Nitrate_Price/50)*NQty3)+(LaborCost/3))
7	= 6	= Yes	= Black	= 2	(((N_Sulphate_Price/50)*NQty3)+(LaborCost/3))
8	= 6	= Yes	= Black	= 3	(((N_Urea_Price/50)*NQty3)+(LaborCost/3))
9	= 6	= Yes	~=Black	= 1	(((N_Nitrate_Price/500)*NQty3)+(LaborCost/3))
10	= 6	= Yes	~=Black	= 2	(((N_Sulphate_Price/50)*NQty3)+(LaborCost/3))

Task:S_N_4Dose_Tsk.

Step:S_N4_Qty_St.

Value Holder: NQty4

Row Number	NOfFert	SoilType	N_Type	Results
1	= 10	= Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
2	= 10	= Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)
3	= 10	= Black	= 3	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/46)
4	= 10	~=Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
5	= 10	~=Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)
6	= 6	= Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/33.5)
7	= 6	= Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/20.6)
8	= 6	= Black	= 3	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/46)
9	= 6	~=Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/33.5)
10	= 6	~=Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/20.6)

Step:S_N4_Date_St.

Value Holder: NDate4

Row Number	NOfFert	Results
1	= 10	DecDate+(5*DecInterval)
2	= 6	DecDate+(7*DecInterval)

Step:S_N4_Cost_St.

Value Holder: NCost4

Row Number	NOfFert	Cost	SoilType	N_Type	Results
1	= 10	= Yes	= Black	= 1	((N_Nitrate_Price/50)*NQty4)
2	= 10	= Yes	= Black	= 2	((N_Sulphate_Price/50)*NQty4)
3	= 10	= Yes	= Black	= 3	((N_Urea_Price/50)*NQty4)
4	= 10	= Yes	~=Black	= 1	((N_Nitrate_Price/50)*NQty4)
5	= 10	= Yes	~=Black	= 2	((N_Sulphate_Price/50)*NQty4)
6	= 6	= Yes	= Black	= 1	(((N_Nitrate_Price/50)*NQty4)+(LaborCost/3))
7	= 6	= Yes	= Black	= 2	(((N_Sulphate_Price/50)*NQty4)+(LaborCost/3))
8	= 6	= Yes	= Black	= 3	(((N_Urea_Price/50)*NQty4)+(LaborCost/3))
9	= 6	= Yes	~=Black	= 1	(((N_Nitrate_Price/50)*NQty4)+(LaborCost/3))
10	= 6	= Yes	~=Black	= 2	(((N_Sulphate_Price/50)*NQty4)+(LaborCost/3))

Task:S_N_5Dose_Tsk.

Step:S_N5_Qty_St.

Value Holder: NQty5

Row Number	NOfFert	SoilType	N_Type	Results
1	= 10	= Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
2	= 10	= Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)
3	= 10	= Black	= 3	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/46)
4	= 10	~=Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
5	= 10	~=Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)
6	= 6	= Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/33.5)
7	= 6	= Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/20.6)
8	= 6	= Black	= 3	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/46)
9	= 6	~=Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/33.5)
10	= 6	~=Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/20.6)

Step:S_N5_Date_St.

Value Holder: NDate5

Row Number	NOfFert	Results
1	= 10	DecDate+(7*DecInterval)
2	= 6	JanDate+(2*JanInterval)

Step:S_N5_Cost_St.

Value Holder: NCost5

Row Number	NOfFert	Cost	SoilType	N_Type	Results
1	= 10	= Yes	= Black	= 1	((N_Nitrate_Price/50)*NQty5)
2	= 10	= Yes	= Black	= 2	((N_Sulphate_Price/50)*NQty5)
3	= 10	= Yes	= Black	= 3	((N_Urea_Price/50)*NQty5)
4	= 10	= Yes	~=Black	= 1	((N_Nitrate_Price/50)*NQty5)
5	= 10	= Yes	~=Black	= 2	((N_Sulphate_Price/50)*NQty5)
6	= 6	= Yes	= Black	= 1	(((N_Nitrate_Price/50)*NQty5)+(LaborCost/3))
7	= 6	= Yes	= Black	= 2	(((N_Sulphate_Price/50)*NQty5)+(LaborCost/3))
8	= 6	= Yes	= Black	= 3	(((N_Urea_Price/50)*NQty5)+(LaborCost/3))
9	= 6	= Yes	~=Black	= 1	(((N_Nitrate_Price/50)*NQty5)+(LaborCost/3))
10	= 6	= Yes	~=Black	= 2	(((N_Sulphate_Price/50)*NQty5)+(LaborCost/3))

Task:S_N_6Dose_Tsk.

Step:S_N6_Qty_St.

Value Holder: NQty6

Row Number	NOfFert	SoilType	N_Type	Results
1	= 10	= Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
2	= 10	= Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)
3	= 10	= Black	= 3	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/46)
4	= 10	~=Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
5	= 10	~=Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)
6	= 6	= Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/33.5)
7	= 6	= Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/20.6)
8	= 6	= Black	= 3	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/46)
9	= 6	~=Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/33.5)
10	= 6	~=Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/5))/20.6)

Step:S_N6_Date_St.

Value Holder: NDate6

Row Number	NOfFert	Results
1	= 10	JanDate+JanInterval
2	= 6	JanDate+(5*JanInterval)

Step:S_N6_Cost_St.

Value Holder: NCost6

Row Number	NOfFert	Cost	SoilType	N_Type	Results
1	= 10	= Yes	= Black	= 1	((N_Nitrate_Price/50)*NQty6)
2	= 10	= Yes	= Black	= 2	((N_Sulphate_Price/50)*NQty6)
3	= 10	= Yes	= Black	= 3	((N_Urea_Price/50)*NQty6)
4	= 10	= Yes	~=Black	= 1	((N_Nitrate_Price/50)*NQty6)
5	= 10	= Yes	~=Black	= 2	((N_Sulphate_Price/50)*NQty6)
6	= 6	= Yes	= Black	= 1	(((N_Nitrate_Price/50)*NQty6)+(LaborCost/3))
7	= 6	= Yes	= Black	= 2	(((N_Sulphate_Price/50)*NQty6)+(LaborCost/3))
8	= 6	= Yes	= Black	= 3	(((N_Urea_Price/50)*NQty6)+(LaborCost/3))
9	= 6	= Yes	~=Black	= 1	(((N_Nitrate_Price/50)*NQty6)+(LaborCost/3))
10	= 6	= Yes	~=Black	= 2	(((N_Sulphate_Price/50)*NQty6)+(LaborCost/3))

Task:S_N_7Dose_Tsk.

Step:S_N7_Qty_St.

Value Holder: NQty7

Row Number	NOfFert	SoilType	N_Type	Results
1	= 10	= Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
2	= 10	= Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)
3	= 10	= Black	= 3	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/46)
4	= 10	~=Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
5	= 10	~=Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)

Step:S_N7_Date_St.

Value Holder: NDate7

Row Number	NOfFert	Results
1	= 10	JanDate+(3*JanInterval)

Step:S_N7_Cost_St.

Value Holder: NCost7

Row Number	NOfFert	Cost	SoilType	N_Type	Results
1	= 10	= Yes	= Black	= 1	((N_Nitrate_Price/50)*NQty7)
2	= 10	= Yes	= Black	= 2	((N_Sulphate_Price/50)*NQty7)
3	= 10	= Yes	= Black	= 3	((N_Urea_Price/50)*NQty7)
4	= 10	= Yes	~=Black	= 1	((N_Nitrate_Price/50)*NQty7)
5	= 10	= Yes	~=Black	= 2	((N_Sulphate_Price/50)*NQty7)

Task:S_N_8Dose_Tsk.

Step:S_N8_Qty_St.

Value Holder: NQty8

Row Number	NOfFert	SoilType	N_Type	Results
1	= 10	= Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
2	= 10	= Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)
3	= 10	= Black	= 3	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/46)
4	= 10	~=Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
5	= 10	~=Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)

Step:S_N8_Date_St.

Value Holder: NDate8

Row Number	NOfFert	Results
1	= 10	JanDate+(5*JanInterval)

Step:S_N8_Cost_St.

Value Holder: NCost8

Row Number	NOfFert	Cost	SoilType	N_Type	Results
1	= 10	= Yes	= Black	= 1	((N_Nitrate_Price/50)*NQty8)
2	= 10	= Yes	= Black	= 2	((N_Sulphate_Price/50)*NQty8)
3	= 10	= Yes	= Black	= 3	((N_Urea_Price/50)*NQty8)
4	= 10	= Yes	~=Black	= 1	((N_Nitrate_Price/50)*NQty8)
5	= 10	= Yes	~=Black	= 2	((N_Sulphate_Price/50)*NQty8)

Task:S_N_9Dose_Tsk.

Step:S_N9_Qty_St.

Value Holder: NQty9

Row Number	NOfFert	SoilType	N_Type	Results
1	= 10	= Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
2	= 10	= Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)
3	= 10	= Black	= 3	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/46)
4	= 10	~=Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
5	= 10	~=Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)

Step:S_N9_Date_St.

Value Holder: NOfFert

Row Number	NOfFert	Results
1	= 10	JanDate+(7*JanInterval)

Step:S_N9_Cost_St.

Value Holder: NCost9

Row Number	NOfFert	Cost	SoilType	N_Type	Results
1	= 10	= Yes	= Black	= 1	((N_Nitrate_Price/50)*NQty9)
2	= 10	= Yes	= Black	= 2	((N_Sulphate_Price/50)*NQty9)
3	= 10	= Yes	= Black	= 3	((N_Urea_Price/50)+NQty9)
4	= 10	= Yes	~=Black	= 1	((N_Nitrate_Price/50)*NQty9)
5	= 10	= Yes	~=Black	= 2	((N_Sulphate_Price/50)*NQty9)

Task:S_N_10Dose_Tsk.

Step:S_N10_Qty_St.

Value Holder: NQty10

Row Number	NOfFert	SoilType	N_Type	Results
1	= 10	= Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
2	= 10	= Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)
3	= 10	= Black	= 3	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/46)
4	= 10	~=Black	= 1	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/33.5)
5	= 10	~=Black	= 2	((100*((N_Base_Qty-(N_Base_Qty/5))/9))/20.6)

Step:S_N10_Date_St.

Value Holder: NDate10

Row Number	NOfFert	Results
1	= 10	FebDate+FebInterval

Step:S_N10_Cost_St.

Value Holder: NCost10

Row Number	NOfFert	Cost	SoilType	N_Type	Results
1	= 10	= Yes	= Black	= 1	((N_Nitrate_Price/50)*NQty10)
2	= 10	= Yes	= Black	= 2	((N_Sulphate_Price/50)*NQty10)
3	= 10	= Yes	= Black	= 3	((N_Urea_Price/50)*NQty10)
4	= 10	= Yes	~=Black	= 1	((N_Nitrate_Price/50)*NQty10)
5	= 10	= Yes	~=Black	= 2	((N_Sulphate_Price/50)*NQty10)

Step:S_N_T_Cost_St.

Value Holder: N_T_Cost

Row Number	Cost	NOfFert	Results
1	= Yes	= 10	(NCost1+NCost2+NCost3+NCost4+NCost5+NCost6+NCost7+NCost8+NCost9+NCost10)
2	= Yes	= 6	(NCost1+NCost2+NCost3+NCost4+NCost5+NCost6)

Plan:Sprinkler not valid plan

Sponsor

Row Number	SprinklerValid	Results
1	= No	Perfect
2	= Yes	Roleout

Task:SpNotValid Task

Step:SprinkNotValid st.

Value Holder: adivce

Row Number	Results
1	The Fertilization schedule can not be computed, because the soil type is not suitable to compute Irrigation schedule.

Task:ME_No_Fert_Tsk.

Step:ME_No_Fert_St.

Value Holder: MENoFert

Row Number	SprinklerValid	SoilType	Results
1	= Yes	~=Black	2

Step:ME_Methode_St.

Value Holder: METoolOut

Row Number	SprinklerValid	SoilType	InjectTankExist	ManualBackSprayeAvalable	MotorBackSprayeAvalable	MotorSprayeAvalable	METoolIn	Results
1	= Yes	~=Black	= Yes	?	?	?	?	Injection tank
2	= Yes	~=Black	?	= Yes	?	?	?	Manual back sprayer
3	= Yes	~=Black	?	?	= Yes	?	?	Motor back sprayer
4	= Yes	~=Black	?	?	?	= Yes	?	Motor sprayer
5	= Yes	~=Black	~=Yes	~=Yes	~=Yes	~=Yes	= Manual back sprayer	Manual back sprayer
6	= Yes	~=Black	~=Yes	~=Yes	~=Yes	~=Yes	= Motor back sprayer	Motor back sprayer
7	= Yes	~=Black	~=Yes	~=Yes	~=Yes	~=Yes	= Motor sprayer	Motor sprayer
8	= Yes	~=Black	~=Yes	~=Yes	~=Yes	~=Yes	= unknown	Manual back sprayer

Step:ME_Time_St.

Value Holder: ME_Time

Row Number	SprinklerValid	SoilType	Results
1	= Yes	~=Black	Time of spraying either early in the morning or afternoon.

Step:ME_Type_St.

Value Holder: MEAvailble

Row Number	SprinklerValid	SoilType	ChelatAvaliable	SulphateAvaliable	MEAvailableIn	Results
1	= Yes	~=Black	= Yes	?	?	Chelate
2	= Yes	~=Black	?	= Yes	?	Sulphate
3	= Yes	~=Black	~=Yes	~=Yes	= Chelate	Chelate
4	= Yes	~=Black	~=Yes	~=Yes	= Suphate	Sulphate
5	= Yes	~=Black	~=Yes	~=Yes	= unknown	Sulphate

Task:ME_Dose1_Tsk.

Step:ME1_Qty_Name_St.

Value Holder: ME_Name

Row Number	SprinklerValid	MEAvailble	SoilType	Results
1	= Yes	= Chelate	~=Black	100 gm Chelate/Fed. With the following ratio: 30 gm Zinc Chelate + 30 gm Manganese Chelate + 30 gm Iron Chelate + 200 Ltr water.
2	= Yes	= Sulphate	~=Black	600 gm Sulphate/Fed. With the following ratio: 200 gm Zinc Sulphate + 200 gm Manganese Sulphate + 200 gm Iron Sulphate + 200 Ltr water.

Step:ME1_Date_St

Value Holder: ME_Date1

Row Number	SprinklerValid	SoilType	Results
1	= Yes	~=Black	27

Step:ME1_Cost_St.

Value Holder: ME_Cost1

Row Number	SprinklerValid	Cost	SoilType	MEAvailble	METoolOut	Results
1	= Yes	= Yes	~=Black	= Chelate	= Injection tank	(0.03Zn_Chelate_Price+0.03Mn_Chelate_Price+0.04*Fe_Chelate_Price)
2	= Yes	= Yes	~=Black	= Sulphate	= Injection tank	(0.2*(Zn_Sulphate_Price+Mn_Sulphate_Price+Fe_Sulphate_Price))
3	= Yes	= Yes	~=Black	= Chelate	= Manual back sprayer	((0.03Zn_Chelate_Price+0.03Mn_Chelate_Price+0.04Fe_Chelate_Price)+0.5(LaborCost+ManualBackSprayerPrice))
4	= Yes	= Yes	~=Black	= Sulphate	= Manual back sprayer	((0.2(Zn_Sulphate_Price+Mn_Sulphate_Price+Fe_Sulphate_Price))+0.5(LaborCost+ManualBackSprayerPrice))
5	= Yes	= Yes	~=Black	= Chelate	= Motor back sprayer	((0.03Zn_Chelate_Price+0.03Mn_Chelate_Price+0.04Fe_Chelate_Price)+((1/3)(LaborCost+FuelPrice+MotorBackSprayerPrice)))
6	= Yes	= Yes	~=Black	= Sulphate	= Motor back sprayer	((0.2(Zn_Sulphate_Price+Mn_Sulphate_Price+Fe_Sulphate_Price))+((1/3)(LaborCost+FuelPrice+MotorBackSprayerPrice)))
7	= Yes	= Yes	~=Black	= Chelate	= Motor sprayer	((0.03Zn_Chelate_Price+0.03Mn_Chelate_Price+0.04Fe_Chelate_Price)+((0.25FuelPrice)+LaborCost+MoterSprayerPrice))
8	= Yes	= Yes	~=Black	= Sulphate	= Motor sprayer	((0.2(Zn_Sulphate_Price+Mn_Sulphate_Price+Fe_Sulphate_Price))+((0.25FuelPrice)+LaborCost+MoterSprayerPrice))

Task:ME_Dose2_Tsk.

Step:ME2_Qty_Name_St.

Value Holder: ME_Name2

Row Number	SprinklerValid	MEAvailble	SoilType	Results
1	= Yes	= Chelate	~=Black	150 gm Chelate/Fed. With the following ratio: 45 gm Zinc Chelate + 45 gm Manganese Chelate + 60 gm Iron Chelate + 300 Ltr water.
2	= Yes	= Sulphate	~=Black	900 gm Sulphate/Fed. With the following ratio: 300 gm Zinc Sulphate + 300 gm Manganese Sulphate + 300 gm Iron Sulphate + 300 Ltr water.

Step:ME2_Date_St.

Value Holder: ME_Date2

Row Number	SprinklerValid	SoilType	Results
1	= Yes	~=Black	47

Step:ME2_Cost_St.

Value Holder: ME_Cost2

Row Number	SprinklerValid	SoilType	Cost	MEAvailble	METoolOut	Results
1	= Yes	~=Black	= Yes	= Chelate	= Injection tank	(0.045Zn_Chelate_Price+0.045Mn_Chelate_Price+0.06*Fe_Chelate_Price)
2	= Yes	~=Black	= Yes	= Sulphate	= Injection tank	(0.3*(Zn_Sulphate_Price+Mn_Sulphate_Price+Fe_Sulphate_Price))
3	= Yes	~=Black	= Yes	= Chelate	= Manual back sprayer	((0.045Zn_Chelate_Price+0.045Mn_Chelate_Price+0.06Fe_Chelate_Price)+0.5(LaborCost+ManualBackSprayerPrice))
4	= Yes	~=Black	= Yes	= Sulphate	= Manual back sprayer	((0.3(Zn_Sulphate_Price+Mn_Sulphate_Price+Fe_Sulphate_Price))+0.5(LaborCost+ManualBackSprayerPrice))
5	= Yes	~=Black	= Yes	= Chelate	= Motor back sprayer	((0.045Zn_Chelate_Price+0.045Mn_Chelate_Price+0.06Fe_Chelate_Price)+((1/3)(LaborCost+FuelPrice+MotorBackSprayerPrice)))
6	= Yes	~=Black	= Yes	= Sulphate	= Motor back sprayer	((0.3(Zn_Sulphate_Price+Mn_Sulphate_Price+Fe_Sulphate_Price))+((1/3)(LaborCost+FuelPrice+MotorBackSprayerPrice)))
7	= Yes	~=Black	= Yes	= Chelate	= Motor sprayer	((0.045Zn_Chelate_Price+0.045Mn_Chelate_Price+0.06Fe_Chelate_Price)+((0.25FuelPrice)+LaborCost+MoterSprayerPrice))
8	= Yes	~=Black	= Yes	= Sulphate	= Motor sprayer	((0.3(Zn_Sulphate_Price+Mn_Sulphate_Price+Fe_Sulphate_Price))+((0.25FuelPrice)+LaborCost+MoterSprayerPrice))

Step:ME_Total_Cost_St.

Value Holder: ME_T_Cost

Row Number	SprinklerValid	SoilType	Cost	Results
1	= Yes	~=Black	= Yes	(ME_Cost1+ME_Cost2)

Task:Mg_No_Fert_Tsk.

Step:Mg_No_Fert_St.

Value Holder: MgNoFert

Row Number	SoilType	Results
1	~=Black	2

Step:Mg_Time_St.

Value Holder: Mg_Time

Row Number	SprinklerValid	SoilType	Results
1	= Yes	~=Black	Time of spraying either early in the morning or afternoon.

Task:Mg_Dose1_Tsk.

Step:Mg1_Qty_Name_St.

Value Holder: Mg_Name

Row Number	SprinklerValid	SoilType	Results
1	= Yes	~=Black	200 gm Magnesium Sulphate + 200 Ltr water per Feddan.

Step:Mg1_Date_St.

Value Holder: Mg_Date1

Row Number	SoilType	SprinklerValid	Results
1	~=Black	= Yes	27

Step:Mg1_Cost_St.

Value Holder: Mg_Cost1

Row Number	SprinklerValid	SoilType	METoolOut	Cost	Results
1	= Yes	~=Black	= Injection tank	= Yes	(0.2*Mg_Sulphate_Price)
2	= Yes	~=Black	= Manual back sprayer	= Yes	((0.2Mg_Sulphate_Price)+(0.5(LaborCost+ManualBackSprayerPrice)))
3	= Yes	~=Black	= Motor back sprayer	= Yes	((0.2Mg_Sulphate_Price)+((1/3)(LaborCost+FuelPrice+MotorBackSprayerPrice)))
4	= Yes	~=Black	= Motor sprayer	= Yes	((0.2Mn_Sulphate_Price)+((0.25FuelPrice)+LaborCost+MoterSprayerPrice))

Task:Mg_Dose2_Tsk.

Step:Mg2_Qty_Name_St.

Value Holder: Mg_Name2

Row Number	SoilType	Results
1	~=Black	300 gm Magnesium Sulphate + 300 Ltr water per Feddan.

Step:Mg2_Date_St.

Value Holder: Mg_Date2

Row Number	SoilType	SprinklerValid	Results
1	~=Black	= Yes	47

Step:Mg2_Cost_St.

Value Holder: Mg_Cost2

Row Number	SprinklerValid	SoilType	Cost	METoolOut	Results
1	= Yes	~=Black	= Yes	= Injection tank	(0.3*Mg_Sulphate_Price)
2	= Yes	~=Black	= Yes	= Manual back sprayer	((0.3Mg_Sulphate_Price)+(0.5(LaborCost+ManualBackSprayerPrice)))
3	= Yes	~=Black	= Yes	= Motor back sprayer	((0.3Mg_Sulphate_Price)+((1/3)(LaborCost+FuelPrice+MotorBackSprayerPrice)))
4	= Yes	~=Black	= Yes	= Motor sprayer	((0.3Mg_Sulphate_Price)+((0.25FuelPrice)+LaborCost+MoterSprayerPrice))

Step:Mg_Total_Cost_St.

Value Holder: Mg_T_Cost

Row Number	SprinklerValid	Cost	SoilType	Results
1	= Yes	= Yes	~=Black	(Mg_Cost1+Mg_Cost2)

Problem Solver:Variety

Top Specialist :Variety Spec.

Plan:Variety Plan

Sponsor

Row Number	Results
1	Perfect

Task:Variety Task

Step:Variety Yield LL step

Value Holder: Yield LL

Row Number	Variety	SalinityProblem	Results
1	= Beni Sweif 1	?	18
2	= Beni Sweif 3	?	18
3	= Gemmiza 5	~=major	18
4	= Gemmiza 7	~=major	18
5	= Gemmiza 9	~=major	20
6	= Giza 164	~=major	16
7	= Giza 165	~=major	16
8	= Giza168	~=major	18
9	= Sahel 1	~=major	1
10	= Sakha 61	~=major	14
11	= Sakha 69	~=major	16
12	= Sakha 69	= major	6
13	= Sakha 8	~=major	16
14	= Sakha 8	= major	8
15	= Sakha 93	~=major	18
16	= Sakha 93	= major	7
17	= Sids 1	~=major	16
18	= Sids 1	= major	8
19	= Sids 6	~=major	16
20	= Sids 7	~=major	16
21	= Sohag 2	?	18
22	= Sohag 3	?	18

Step:Variety Yield UL step

Value Holder: Yield_QTY

Row Number	Variety	SalinityProblem	Results
1	= Beni Sweif 1	?	20
2	= Beni Sweif 3	?	20
3	= Gemmiza 5	~=major	20
4	= Gemmiza 7	~=major	22
5	= Gemmiza 9	~=major	24
6	= Giza 164	~=major	20
7	= Giza 165	~=major	20
8	= Giza168	~=major	24
9	= Sahel 1	~=major	2
10	= Sakha 61	~=major	18
11	= Sakha 69	~=major	20
12	= Sakha 69	= major	8
13	= Sakha 8	~=major	20
14	= Sakha 8	= major	10
15	= Sakha 93	~=major	20
16	= Sakha 93	= major	10
17	= Sids 1	~=major	20
18	= Sids 1	= major	10
19	= Sids 6	~=major	20
20	= Sids 7	~=major	20
21	= Sohag 2	?	20
22	= Sohag 3	?	20

Step:Variety Age LL step

Value Holder: Age LL

Row Number	Region	Variety	SalinityProblem	Results
1	= Rain Fed Area	?	?	130
2	= North Delta	= Sakha 69	~=major	150
3	= North Delta	= Sakha 69	= major	145
4	= North Delta	= Sakha 8	~=major	150
5	= North Delta	= Sakha 8	= major	145
6	= North Delta	= Sakha 61	~=major	140
7	= North Delta	= Sakha 93	~=major	155
8	= North Delta	= Sakha 93	= major	150
9	= North Delta	= Giza168	~=major	155
10	= North Delta	= Gemmiza 5	~=major	160
11	= North Delta	= Gemmiza 7	~=major	160
12	= North Delta	= Gemmiza 9	~=major	165
13	= Middle Egypt	= Sakha 69	~=major	150
14	= Middle Egypt	= Sakha 69	= major	145
15	= Middle Egypt	= Sakha 8	~=major	150
16	= Middle Egypt	= Sakha 8	= major	145
17	= Middle Egypt	= Sakha 61	~=major	140
18	= Middle Egypt	= Sakha 93	~=major	155
19	= Middle Egypt	= Sakha 93	= major	150
20	= Middle Egypt	= Giza168	~=major	155
21	= Middle Egypt	= Gemmiza 5	~=major	160
22	= Middle Egypt	= Gemmiza 7	~=major	160
23	= Middle Egypt	= Gemmiza 9	~=major	165
24	= South Delta	= Sakha 69	~=major	150
25	= South Delta	= Sakha 69	= major	145
26	= South Delta	= Sakha 8	= major	145
27	= South Delta	= Gemmiza 5	~=major	160
28	= South Delta	= Gemmiza 7	~=major	160
29	= South Delta	= Gemmiza 9	~=major	165
30	= West Delta	= Sakha 69	~=major	150
31	= West Delta	= Sakha 69	= major	145
32	= West Delta	= Gemmiza 5	~=major	160
33	= West Delta	= Giza168	~=major	160
34	= West Delta	= Sakha 8	= major	145
35	= East Delta	= Sakha 69	?	140
36	= East Delta	= Sakha 8	?	140
37	= East Delta	= Gemmiza 5	~=major	140
38	= East Delta	= Gemmiza 7	~=major	140
39	= Fayoum	= Sakha 8	~=major	150
40	= Fayoum	= Sakha 8	= major	145
41	= Fayoum	= Sakha 69	~=major	150
42	= Fayoum	= Sakha 69	= major	145
43	= Fayoum	= Sids 1	~=major	150
44	= Fayoum	= Sids 1	= major	145
45	= Fayoum	= Gemmiza 5	~=major	160
46	= Fayoum	= Gemmiza 7	~=major	150
47	= Middle Delta	= Sakha 8	= major	145
48	= Middle Delta	= Sakha 69	~=major	150
49	= Middle Delta	= Sakha 69	= major	145
50	= Middle Delta	= Giza 164	~=major	150
51	= Middle Delta	= Sids 1	~=major	150
52	= Middle Delta	= Beni Sweif 1	?	155
53	= Middle Delta	= Beni Sweif 3	?	155
54	= Upper Egypt	= Sids 1	~=major	145
55	= Upper Egypt	= Sids 1	= major	140
56	= Upper Egypt	= Sids 6	~=major	145
57	= Upper Egypt	= Sids 7	~=major	145
58	= Upper Egypt	= Giza 164	~=major	145
59	= Upper Egypt	= Giza 164	= major	140
60	= Upper Egypt	= Giza 165	~=major	145
61	= Upper Egypt	= Giza 165	= major	140
62	= Upper Egypt	= Sohag 2	?	150
63	= Upper Egypt	= Sohag 3	?	150

Step:Variety Age UL step

Value Holder: Age UL

Row Number	Region	Variety	SalinityProblem	Results
1	= Rain Fed Area	?	?	140
2	= North Delta	?	= major	150
3	= North Delta	= Sakha 69	~=major	155
4	= North Delta	= Sakha 8	~=major	155
5	= North Delta	= Sakha 61	~=major	150
6	= North Delta	= Sakha 93	~=major	160
7	= North Delta	= Giza168	~=major	160
8	= North Delta	= Gemmiza 5	~=major	165
9	= North Delta	= Gemmiza 7	~=major	165
10	= North Delta	= Gemmiza 9	~=major	170
11	= Middle Delta	?	= major	150
12	= Middle Delta	= Sakha 69	~=major	155
13	= Middle Delta	= Sakha 8	~=major	155
14	= Middle Delta	= Sakha 61	~=major	150
15	= Middle Delta	= Sakha 93	~=major	160
16	= Middle Delta	= Giza168	~=major	160
17	= Middle Delta	= Gemmiza 5	~=major	165
18	= Middle Delta	= Gemmiza 7	~=major	165
19	= Middle Delta	= Gemmiza 9	~=major	170
20	= South Delta	?	= major	150
21	= South Delta	= Sakha 69	~=major	155
22	= South Delta	= Gemmiza 5	~=major	165
23	= South Delta	= Gemmiza 7	~=major	165
24	= South Delta	= Gemmiza 9	~=major	170
25	= West Delta	= Sakha 69	= major	145
26	= West Delta	= Sakha 8	= major	150
27	= West Delta	~=Sakha 69	~=major	165
28	= West Delta	= Sakha 69	~=major	150
29	= East Delta	?	?	150
30	= Fayoum	= Sakha 8	~=major	155
31	= Fayoum	= Sakha 8	= major	150
32	= Fayoum	= Sakha 69	~=major	150
33	= Fayoum	= Sakha 69	= major	145
34	= Fayoum	= Sids 1	~=major	155
35	= Fayoum	= Sids 1	= major	150
36	= Fayoum	= Gemmiza 5	~=major	165
37	= Fayoum	= Gemmiza 7	~=major	155
38	= Middle Egypt	= Sakha 69	~=major	155
39	= Middle Egypt	= Sakha 69	= major	150
40	= Middle Egypt	= Sakha 8	= major	150
41	= Middle Egypt	= Giza 164	~=major	155
42	= Upper Egypt	= Sakha 69	~=major	150
43	= Upper Egypt	= Sakha 69	= major	145
44	= Upper Egypt	= Sids 1	= major	145
45	= Upper Egypt	= Giza 164	= major	145
46	= Upper Egypt	= Giza 165	= major	145
47	= Upper Egypt	= Sids 1	~=major	150
48	= Middle Egypt	= Sids 1	~=major	155
49	= Middle Egypt	= Beni Sweif 1	?	160
50	= Middle Egypt	= Beni Sweif 3	?	160
51	= Upper Egypt	= Giza 164	~=major	150
52	= Upper Egypt	= Giza 165	~=major	150
53	= Upper Egypt	= Sids 6	~=major	150
54	= Upper Egypt	= Sids 7	~=major	150
55	= Upper Egypt	= Sohag 2	?	155
56	= Upper Egypt	= Sohag 3	?	155

Problem Solver:Planting

Top Specialist :Planting Spec.

Plan:Planting Plan

Sponsor

Row Number	Results
1	Perfect

Task:Planting Task

Step:Planting DateN Step

Value Holder: Planting DateN

Row Number	Results
1	0

Step:Planting date Step

Value Holder: Planting date

Row Number	PlantingDate	Region	Results
1	~=Yes	= Fayoum	15/11 to 30/11
2	~=Yes	= Middle Egypt	1/11 to 15/11
3	~=Yes	= North Delta	15/11 to 30/11
4	~=Yes	= South Delta	15/11 to 30/11
5	~=Yes	= Upper Egypt	1/11 to 15/11
6	~=Yes	= Rain Fed Area	When raining
7	~=Yes	= East Delta	15/11 to 30/11
8	~=Yes	= Middle Delta	15/11 to 30/11
9	~=Yes	= West Delta	15/11 to 30/11

Step:Planting dateN Step

Value Holder: plantDateDay

Row Number	PlantingDate	Region	plantDateMon	Results
1	?	?	= unknown	15
2	~=Yes	= Fayoum	?	22
3	~=Yes	= Middle Egypt	?	8
4	~=Yes	= North Delta	?	22
5	~=Yes	= South Delta	?	22
6	~=Yes	= Upper Egypt	?	8
7	~=Yes	= Rain Fed Area	?	15
8	~=Yes	= East Delta	?	22
9	~=Yes	= Middle Delta	?	22
10	~=Yes	= West Delta	?	22
11	= Yes	?	= November	plantDateDay
12	= Yes	?	= December	plantDateDay

Step:Planting type Step

Value Holder: PlantingType

Row Number	SoilType	IrrigtationType	Flexible planting date	SalinityProblem	Weedy soil	Leveling status	Results
1	= Calcarious	= Flood	= Yes	~=major	= Yes	?	Wet
2	= Black	= Flood	= Yes	~=major	= Yes	?	Wet
3	= Calcarious	= Flood	= Yes	~=major	= No	= Yes	Wet
4	= Black	= Flood	= Yes	~=major	= No	= Yes	Wet
5	?	?	?	?	?	?	Dry

Step:Sowing method Step

Value Holder: Sowing method

Row Number	Flexible planting date	Drill available	PlantingType	Direct planting available	Results
1	= No	?	?	= Yes	Direct planting tool
2	?	?	= Wet	?	Broadcast
3	?	= Yes	= Dry	?	Drill
4	?	?	= Dry	?	Broadcast

Step:market wheat

Value Holder: WheatType

Row Number	Region	Results
1	= North Delta	Bread
2	= South Delta	Bread
3	= Rain Fed Area	Bread
4	= Fayoum	Bread
5	= Middle Egypt	Bread

Step:Seeding rate Step

Value Holder: Seeding rate

Row Number	Sowing method	WheatType	PlantingType	SoilType	Weedy soil	Results
1	= Broadcast	~=Durum	= Dry	= Black	~=Yes	60
2	= Broadcast	= Durum	= Dry	= Black	~=Yes	75
3	= Drill	~=Durum	= Dry	= Black	~=Yes	50
4	= Drill	= Durum	= Dry	= Black	~=Yes	60
5	?	~=Durum	= Wet	= Black	~=Yes	75
6	?	= Durum	= Wet	= Black	~=Yes	90
7	= Broadcast	~=Durum	= Dry	~=Black	= Yes	70
8	= Broadcast	= Durum	= Dry	~=Black	= Yes	85
9	= Drill	~=Durum	= Dry	~=Black	= Yes	60
10	= Drill	= Durum	= Dry	~=Black	= Yes	70
11	?	~=Durum	= Wet	~=Black	= Yes	85
12	?	= Durum	= Wet	~=Black	= Yes	100
13	= Broadcast	?	?	= Black	= Yes	80
14	= Broadcast	?	?	~=Black	~=Yes	70
15	= Direct planting tool	?	= Dry	= Black	~=Yes	70
16	= Direct planting tool	?	= Dry	~=Black	= Yes	80
17	= Drill	?	?	~=Black	~=Yes	60
18	= Drill	?	?	= Black	= Yes	70

Step:Planting method Step

Value Holder: Planting method

Row Number	Sowing method	PlantingType	Results
1	= Broadcast	= Wet	Planting wet, divide seeds quantity into two halves, broadcast the first half from east to west, then Broadcast the second half from north to south.
2	= Broadcast	= Dry	Planting dry, divide seeds quantity into two halves, broadcast the first half from east to west, then Broadcast the second half from north to south.
3	= Drill	= Dry	Planting dry, planting depth should be 5 cm.
4	= Direct planting tool	= Dry	Planting dry, Using direct planting tool. This Equipment plows, levels, and sows seeds in one operation.

Task:Loose Smut Task

Step:Loose smart dateN Step

Value Holder: Loose smart dateN

Row Number	Treated seeds	Results
1	= No	-1

Step:Loose Smart Material Step

Value Holder: Loose Smut Control Material

Row Number	Treated seeds	Results
1	= No	Sumi 8

Step:Loose Smart Qty Step

Value Holder: Loose Smut Control Qty

Row Number	Treated seeds	Loose smut material select	Results
1	= No	~=Powder	1 cm3 (material) +10 m3 (water) /kg seed respectively with the recommended materials
2	= No	= Powder	2 g (material) + 20 (water)cm3 / kg seeds respectively with the recommended materials

Step:Loose Smut Method Step

Value Holder: Loose Smut Control Material

Row Number	Treated seeds	Results
1	= No	Mix the insecticide with seeds

Step:Loose Smart Tool Step

Value Holder: Loose Smut Control Tool

Row Number	Treated seeds	Results
1	= No	Manual

Step:Loose Smart Cost Step

Value Holder: LaborCost4

Row Number	Cost	Treated seeds	Results
1	= Yes	= No	LaborCost/4

Step:Loose Smart Cost Step1

Value Holder: SeedingRateCost

Row Number	Cost	Treated seeds	Loose smut material select	Results
1	= Yes	= No	~=Powder	Sumi 8 liquid cost*Seeding rate
2	= Yes	= No	= Powder	2Sumi 8 liquid costSeeding rate

Step:Loose Smart Cost Step2

Value Holder: Loose smut control Cost

Row Number	Cost	Treated seeds	Results
1	= Yes	= No	LaborCost4+SeedingRateCost

Task:Seed covering Task

Step:Seed Covering DateN Step

Value Holder: Seed covering DateN

Row Number	Sowing method	Chisel plow available	Rotary tiller available	Results
1	= Broadcast	= Yes	?	0
2	= Broadcast	?	= Yes	0
3	= Broadcast	?	?	0

Step:Seed covering tool Step

Value Holder: Seeding covering tool

Row Number	Sowing method	PlantingType	Chisel plow available	Rotary tiller available	Results
1	= Broadcast	?	= Yes	?	Chisel plow
2	= Broadcast	~=Wet	?	= Yes	Rotary tiller
3	= Broadcast	?	?	?	Tractor attached with woody bar

Step:Seed covering cost Step

Value Holder: Seeding covering cost

Row Number	Cost	Sowing method	Chisel plow available	Rotary tiller available	Seeding covering tool	Results
1	= Yes	= Broadcast	= Yes	?	= Chisel plow	Chisel plow cost*1.25
2	= Yes	= Broadcast	?	= Yes	= Rotary tiller	Rotary tiller cost
3	= Yes	= Broadcast	?	?	= Tractor attached with woody bar	Tractor Cost*1.25

Problem Solver:Irrigation PS

Top Specialist :Irrigation Spec.

Plan:Irrigated Regions Plan

Sponsor

Row Number	Results
1	Perfect

Task: Total Water Qty Task

Step:SpValid

Value Holder: SprinklerValid

Row Number	IrrigtationType	SoilType	Results
1	= Sprinkler	= Black	No
2	= Sprinkler	= Calcarious	No
3	= Sprinkler	= Sandy	Yes
4	= Sprinkler	= Sandy/calc-mixed	Yes
5	= Sprinkler	= unknown	No
6	= Flood	?	Yes

Step:ClassOfRegion

Value Holder: RegionClass

Row Number	SprinklerValid	Region	Results
1	= Yes	= East Delta	Delta Region
2	= Yes	= Fayoum	Middle Region
3	= Yes	= Middle Delta	Delta Region
4	= Yes	= Middle Egypt	Middle Region
5	= Yes	= North Delta	Delta Region
6	= Yes	= Rain Fed Area	unknown
7	= Yes	= South Delta	Delta Region
8	= Yes	= Upper Egypt	Upper Region
9	= Yes	= West Delta	Delta Region
10	= Yes	= unknown	unknown

Step:Primary Water Qty St

Value Holder: PrimQty

Row Number	SprinklerValid	Region	Results
1	= Yes	= North Delta	1470
2	= Yes	= Upper Egypt	1827
3	= Yes	= South Delta	1470.00
4	= Yes	= Fayoum	1701
5	= Yes	= Middle Egypt	1701
6	= Yes	= East Delta	1700
7	= Yes	= West Delta	1700
8	= Yes	= Middle Delta	1470

Step:Define Sol.Sal. St.

Value Holder: SoilSal

Row Number	SprinklerValid	SoilAnalysis	SalinityProblem	Results
1	= Yes	~=Yes	= major	7.00
2	= Yes	~=Yes	= minor	5.00
3	= Yes	~=Yes	= none	3.00
4	= Yes	~=Yes	= unknown	3.00

Step:Define Water Sal St.

Value Holder: WaterSal

Row Number	SprinklerValid	WaterSource	Results
1	= Yes	= Nile water	1.00

Step:Leashing St

Value Holder: LeashQty

Row Number	SprinklerValid	IrrigtationType	Results
1	= Yes	~=Sprinkler	((0.2SoilSalWaterSal)/(SoilSal-WaterSal))*PrimQty
2	= Yes	= Sprinkler	0.025WaterSalPrimQty

Step:Irr. System Effeciency St

Value Holder: EffQty

Row Number	SprinklerValid	IrrigtationType	WeedsLevelingByLaser	Results
1	= Yes	= Sprinkler	?	0.3333*PrimQty
2	= Yes	~=Sprinkler	= Yes	0.43*PrimQty
3	= Yes	~=Sprinkler	= No	0.67*PrimQty
4	= Yes	~=Sprinkler	= Unknown	0.67*PrimQty

Step:Rain Fall St

Value Holder: RainFallQty

Row Number	SprinklerValid	Region	Region	Region	Region	Results
1	= Yes	= South Delta	?	?	?	-120
2	= Yes	= North Delta	?	?	?	-300
3	= Yes	= East Delta	?	?	?	-300
4	= Yes	= West Delta	?	?	?	-300
5	= Yes	= Middle Delta	?	?	?	-120
6	= Yes	~=East Delta	~=North Delta	~=South Delta	~=West Delta	0

Step:Drainage Sys. Req. St

Value Holder: DrainAgeQty

Row Number	SprinklerValid	WaterTableLevel	DrainageSystem	Results
1	= Yes	?	= Bad	-0.1*PrimQty
2	= Yes	= High	= Not exist	-0.2*PrimQty
3	= Yes	= Medium	= Not exist	-0.1*PrimQty
4	= Yes	= Low	= Not exist	-0.05*PrimQty
5	= Yes	= unknown	= Not exist	-0.1*PrimQty
6	= Yes	?	= Good	0
7	= Yes	?	= unknown	0

Step:Calculate Total Water Qty St

Value Holder: TotWaterQty

Row Number	SprinklerValid	Results
1	= Yes	DrainAgeQty+EffQty+LeashQty+PrimQty+RainFallQty

Specialist:Schedule Spec

Plan:Flood Plan

Sponsor

Row Number	IrrigtationType	Results
1	= Flood	Perfect
2	~=Flood	Roleout

Task:Flood 1st Irrigation Task

Step:Flood 1st Irrigation Qty St

Value Holder: FirstIrriQty

Row Number	Results
1	400

Step:Flood 1st Irrigation Date St

Value Holder: FirstIrrDate

Row Number	PlantingType	Results
1	~=Wet	with Plnating Date
2	= Wet	10 to15 days before planting date

Step:Flood 1st Irr Cost St.

Value Holder: FirstIrrCost

Row Number	Cost	IrrigtationType	Results
1	= Yes	~=Sprinkler	10.00

Step:Flood 1st Irr nDare

Value Holder: RestIrrQty

Row Number	Results
1	TotWaterQty-FirstIrriQty

Task:Flood 2nd Irrigation Task

Step:Flood 2nd Irrigation Qty St

Value Holder: SndIrriQty

Row Number	Region	SoilType	Results
1	= Upper Egypt	~=Calcarious	RestIrrQty/6
2	= Middle Egypt	~=Calcarious	RestIrrQty/5
3	= North Delta	~=Calcarious	RestIrrQty/4
4	= South Delta	~=Calcarious	RestIrrQty/4
5	= Fayoum	~=Calcarious	RestIrrQty/5
6	?	= Calcarious	RestIrrQty/6
7	= East Delta	~=Calcarious	RestIrrQty/5
8	= Rain Fed Area	~=Calcarious	RestIrrQty/5
9	= West Delta	~=Calcarious	RestIrrQty/5
10	= Middle Delta	~=Calcarious	RestIrrQty/4

Step:Flood 2nd Irrigation Date St

Value Holder: SndIrrDate

Row Number	IrrigtationType	Results
1	~=Sprinkler	from 21 to 25 day after Planting Date.

Step:Flood 2nd Irr Cost St.

Value Holder: SndIrrCost

Row Number	Cost	IrrigtationType	Results
1	= Yes	~=Sprinkler	10

Task:Flood 3th Irrigation Task

Step:Flood 3th Irrigation Qty St

Value Holder: ThirdIrriQty

Row Number	Results
1	SndIrriQty

Step:Flood 3th Irrigation Date St

Value Holder: ThirdIrrDate

Row Number	Results
1	from 50 to 55 day after Planting Date.

Step:Flood 3th Irr Cost St.

Value Holder: THirdIrrCost

Row Number	Cost	IrrigtationType	Results
1	= Yes	~=Sprinkler	10

Task:Flood 4th Irrigation Task

Step:Flood 4th Irrigation Qty St

Value Holder: ForthIrriQty

Row Number	Results
1	SndIrriQty

Step:Flood 4th Irrigation Date St

Value Holder: ForthIrrDate

Row Number	Region	SoilType	Results
1	= Upper Egypt	~=Calcarious	from 70 to 75 day after Planting Date.
2	= Fayoum	~=Calcarious	from 70 to 75 day after Planting Date.
3	= Middle Egypt	~=Calcarious	from 70 to 75 day after Planting Date.
4	= South Delta	~=Calcarious	from 85 to 90 day after Planting Date.
5	= North Delta	~=Calcarious	from 85 to 90 day after Planting Date.
6	?	= Calcarious	from 70 to 75 day after Planting Date.
7	= Rain Fed Area	~=Calcarious	from 70 to 75 day after Planting Date.
8	= East Delta	~=Calcarious	from 70 to 75 day after Planting Date.
9	= West Delta	~=Calcarious	from 70 to 75 day after Planting Date.

Step:Flood 4th Irr Cost St.

Value Holder: ForthIrrCost

Row Number	Cost	IrrigtationType	Results
1	= Yes	~=Sprinkler	10

Task:Flood 5th Irrigation Task

Step:Flood 5th Irrigation Qty St

Value Holder: FifithIrriQty

Row Number	Results
1	SndIrriQty

Step:Flood 5th Irrigation Date St

Value Holder: FifthIrrDate

Row Number	Region	SoilType	Results
1	= Upper Egypt	~=Calcarious	from 85 to 90 day after Planting Date.
2	= Fayoum	~=Calcarious	from 90 to 95 day after Planting Date.
3	= Middle Egypt	~=Calcarious	from 90 to 95 day after Planting Date.
4	= North Delta	~=Calcarious	from 110 to 115 day after Planting Date.
5	= South Delta	~=Calcarious	from 110 to 115 day after Planting Date.
6	?	= Calcarious	from 85 to 90 day after Planting Date.
7	= Rain Fed Area	~=Calcarious	from 90 to 95 day after Planting Date.
8	= East Delta	~=Calcarious	from 90 to 95 day after Planting Date.
9	= West Delta	~=Calcarious	from 90 to 95 day after Planting Date.

Step:Flood 5th Irr Cost St.

Value Holder: FifthIrrCost

Row Number	Cost	IrrigtationType	Results
1	= Yes	~=Sprinkler	10

Task:Flood 6th Irrigation Task

Step:Flood 6th Irrigation Qty St

Value Holder: SixIrriQty

Row Number	Region	Region	Results
1	= North Delta	?	SndIrriQty
2	= South Delta	?	SndIrriQty
3	~=North Delta	~=South Delta	SndIrriQty

Step:Flood 6th Irrigation Date St

Value Holder: SixIrrDate

Row Number	Region	SoilType	Results
1	= Upper Egypt	~=Calcarious	from 100 to 105 day after Planting Date.
2	= Fayoum	~=Calcarious	from 110 to 115 day after Planting Date.
3	= Middle Egypt	~=Calcarious	from 110 to 115 day after Planting Date.
4	?	= Calcarious	from 100 to 105 day after Planting Date.
5	= Rain Fed Area	~=Calcarious	from 110 to 115 day after Planting Date.
6	= West Delta	~=Calcarious	from 110 to 115 day after Planting Date.
7	= East Delta	~=Calcarious	from 110 to 115 day after Planting Date.

Step:Flood 6th Irr Cost St.

Value Holder: SixIrrCost

Row Number	Results
1	10

Task:Flood 7th Irrigation Task

Step:Flood 7th Irrigation Qty St

Value Holder: SevenIrriQty

Row Number	Region	SoilType	Results
1	= Upper Egypt	~=Calcarious	RestIrrQty/6
2	?	= Calcarious	RestIrrQty/6
3	~=Upper Egypt	~=Calcarious	0

Step:Flood 7th Irrigation Date St

Value Holder:

Step:Flood 7th Irr Cost St.

Value Holder:

Plan:Sprinkler Plan

Sponsor

Row Number	IrrigtationType	SprinklerValid	Results
1	= Sprinkler	= Yes	Perfect
2	~=Sprinkler	?	Roleout

Task:Sp. Factor Calculate. Task

Step:Calculate Sp. Factor St.

Value Holder: SpFactor

Row Number	IrrigtationType	SprinklerValid	RegionClass	Results
1	= Sprinkler	= Yes	= Delta Region	(TotWaterQty-500)/31.7
2	= Sprinkler	= Yes	= Middle Region	(TotWaterQty-500)/38.2
3	= Sprinkler	= Yes	= Upper Region	(TotWaterQty-500)/41.3

Task:Sprink Irr during Nov. Month Task

Step:Calculate Irr Qty St.

Value Holder: SpIrrQtyNov

Row Number	IrrigtationType	Results
1	= Sprinkler	125

Step:Nov Motor Time St

Value Holder: NovMotorTime

Row Number	IrrigtationType	Results
1	= Sprinkler	NoOfSpr*SpRate/SpIrrQtyNov

Step:Nov Interval St

Value Holder: NovInterval

Row Number	IrrigtationType	Results
1	= Sprinkler	Each tow days.

Step:Nov Cost St.

Value Holder: SpNovCost

Row Number	Cost	IrrigtationType	Results
1	= Yes	= Sprinkler	7*NovMotorTime

Task:Sprink Irr during Dec. Month Task

Step:Calculate Dec Irr Qty St.

Value Holder: SpIrrQtyDec

Row Number	IrrigtationType	Results
1	= Sprinkler	SpFactor*4.4/8

Step:Dec Motor Time St

Value Holder: DecMotorTime

Row Number	IrrigtationType	Results
1	= Sprinkler	NoOfSpr*SpRate/SpIrrQtyDec

Step:Dec. Interval St

Value Holder: DecInterval

Row Number	IrrigtationType	Results
1	= Sprinkler	4 days.

Step:Dec. Cost St.

Value Holder: SpDecCost

Row Number	Cost	IrrigtationType	Results
1	= Yes	= Sprinkler	7*DecMotorTime

Task:Sprink Irr during Jan. Month Task

Step:Calculate Jan Irr Qty St.

Value Holder: SpIrrQtyJan

Row Number	IrrigtationType	Results
1	= Sprinkler	SpFactor*4.4/8

Step:Jan. Motor Time St

Value Holder: JanMotorTime

Row Number	IrrigtationType	Results
1	= Sprinkler	NoOfSpr*SpRate/SpIrrQtyJan

Step:Jan. Interval St

Value Holder: JanInterval

Row Number	IrrigtationType	Results
1	= Sprinkler	4 days.

Step:Jan. Cost St.

Value Holder: SpJanCost

Row Number	IrrigtationType	Cost	Results
1	= Sprinkler	= Yes	7*JanMotorTime

Task:Sprink Irr during Feb. Month Task

Step:Calculate Feb Irr Qty St.

Value Holder: SpIrrQtyFeb

Row Number	IrrigtationType	Results
1	= Sprinkler	SpFactor*5.4/7

Step:Feb. Motor Time St

Value Holder: FebMotorTime

Row Number	IrrigtationType	Results
1	= Sprinkler	NoOfSpr*SpRate/SpIrrQtyFeb

Step:Feb. Interval St

Value Holder: FebInterval

Row Number	IrrigtationType	Results
1	= Sprinkler	4 days.

Step:Feb. Cost St.

Value Holder: SpFebCost

Row Number	Cost	IrrigtationType	Results
1	= Yes	= Sprinkler	7*FebMotorTime

Task:Sprink Irr during Mar. Month Task

Step:Calculate Mar Irr Qty St.

Value Holder: SpIrrQtyMar

Row Number	IrrigtationType	Results
1	= Sprinkler	SpFactor*8/10

Step:Mar. Motor Time St

Value Holder: MarMotorTime

Row Number	IrrigtationType	Results
1	= Sprinkler	NoOfSpr*SpRate/SpIrrQtyMar

Step:Mar. Interval St

Value Holder: MarInterval

Row Number	IrrigtationType	Results
1	= Sprinkler	3 days.

Step:Mar. Cost St.

Value Holder: SpMarCost

Row Number	Cost	IrrigtationType	Results
1	= Yes	= Sprinkler	7*MarMotorTime

Task:Sprink Irr during Apr. Month Task

Step:Calculate Apr Irr Qty St.

Value Holder: SpIrrQtyApr

Row Number	IrrigtationType	Results
1	= Sprinkler	SpFactor*9.5/10

Step:Apr. Motor Time St

Value Holder: AprMotorTime

Row Number	IrrigtationType	Results
1	= Sprinkler	NoOfSpr*SpRate/SpIrrQtyApr

Step:Apr. Interval St

Value Holder: AprInterval

Row Number	IrrigtationType	Results
1	= Sprinkler	3 days.

Step:Apr. Cost St.

Value Holder: SpAprCost

Row Number	Cost	IrrigtationType	Results
1	= Yes	= Sprinkler	7*AprMotorTime

Task:Total Water & Cost Task

Step:Total Water St ..

Value Holder: TotWaterTmp

Row Number	Results
1	0

Task:general advice Task

Step:general advice st.

Value Holder: GenAdvice

Row Number	Results
1	Do not irrigate during rain or during wind , and its better to irrigate at evening or at morning.