How to paste data from Excel into ProductionAlgorithm form

 

Weather data

 

Excel preparation:

 

 

 

 

Pasting weather data into ProductionAlgorithm form

Now to paste weather data from your xls file (example file: QUZHOU99.xls) with weather data into the ProductionAlgorithm form:

 

All excel weather data will be copied into the ProductionAlgorithm form.

Optionally, replace the default value for relative humidity value (RHA) (0.73)
in the last row of the weather data table in your ProductionAlgorithm form by value 0.

 


Crop data, allocation fractions

 

Excel preparation:

 

 

0

0.279

0.523

0.686

0.736

1

0.372

0.481

0.263

0

0

0

0.4

0.225

0.06

0

0

0

0.228

0.294

0.677

0.24

0

0

0

0

0

0.76

1

1

 

 

0

0.372

0.4

0.228

0

0.279

0.481

0.225

0.294

0

0.523

0.263

0.06

0.677

0

0.686

0

0

0.24

0.76

0.736

0

0

0

1

1

0

0

0

1

 

 


  • Insert a new column before column A and enter numbers starting from 1, ending at the number of the number of rows that are defined. The allocation table now looks like:

 

1

0

0.372

0.4

0.228

0

2

0.279

0.481

0.225

0.294

0

3

0.523

0.263

0.06

0.677

0

4

0.686

0

0

0.24

0.76

5

0.736

0

0

0

1

6

1

0

0

0

1

 

 

Pasting crop data into ProductionAlgorithm form

Now to paste crop data from your xls file (example file: crops.xls) with allocation fraction data into the ProductionAlgorithm form:

 

All excel allocation fractions data will be copied into the ProductionAlgorithm form.

 

 

Canopy temperatures data

 

Excel preparation:

 

 

Your data may look like:

 

1

158

35.46

2

159

40.26

3

177

37.46

4

181

41.306

5

182

45.06

6

183

46.307

7

199

43.5

8

200

44.2

9

202

42.3

10

204

41.4

11

206

34.1

12

210

35

13

215

33.7

14

223

31.4

15

228

37.2

16

229

32.5

17

230

28.6

18

235

31.2

19

243

32.2

20

244

31

21

250

35.1

22

252

29.16

23

253

27.96

24

260

23.788

25

261

22.414

26

262

15.958

27

263

25.56

28

264

27.4

29

265

28.56

30

266

28.76

31

267

33.36

 

 

Pasting canopy temperature data into InterTCanAlgorithm form

Now to paste weather data from your xls file (example file: canopytemps.xls) with weather data into the InterTCanAlgorithm form:

 

All excel canopy temperatures data will be copied into the InterTCanAlgorithm form.