- Email: [email protected]
Excel Sheets and Forms—Summary
A P P E N D I X
VII
Excel Sheets and Forms—Summary No.
File Name
Description
Folder Name: Nursery 1
PL Acclimation Data Recording Form
For data recording during acclimation to nursery tanks: PL samples, mortalities, water volume, and water quality. Page # 401
2
PL Evaluation Data Recording Form
For PL microscopic physical evaluation following receipt from the hatchery and during early nursery stages. Page # 402
3
Nursery WQ, Feed, & More_Form
For recording daily water quality, equipment operation, feed rations, and other inputs. Page # 403
4
Nursery Group Sampling_Form & Calc
For weekly shrimp growth sampling, with calculations for average weight and growth (g/day and g/week) given in a separate spreadsheet. Page # 404
5
Nursery Ration Growth FCR Survival
For input of Excel Sheet #4 data and calculating average weight, growth, biomass, FCR, and rations. A separate spreadsheet with example data from 2014 is included.
6
Nursery WQ Feed Growth FCR Electronic Data Recording Form Example & Cal
For collating data for individual nursery tanks over a full nursery cycle (from Sheet # 3 and # 4)—water quality, equipment operation, feed rations, shrimp weight, and other inputs. Includes columns to calculate FCR and growth. A separate spreadsheet with example data from 2012 is included. Page # 405
7
Nursery Individual wt. Frequency distribution & Feed Calc_Examples
Example spreadsheets (2014 nursery trials) for calculating shrimp size distribution and allocating feed type and size to individual nursery tanks.
8
Shrimp PL Age and Length
For estimating L. vannamei PL weight at given total lengths and PL size at given ages. Covers PL5–30. Page # 406
9
Nursery Sampling Before Transfer_Form
For recording weight and size distribution prior to nursery tank harvest. The collected data can be added to a separate spreadsheet which includes formulae for calculating average weight and size variation. Page # 407 Continued
399
400
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
No.
File Name
Description
10
Juvenile Transfer Form & Calc
For recording weight of harvested shrimp during transfer to grow—out tanks. The collected data can be added to a separate spreadsheet which includes formulae for calculating total harvest weight, yield, shrimp number, survival, average weight, and size variation. Page # 408
Folder Name: Grow—out 11
Grow—out WQ Operation Feed Vibrio Inputs Data Recording Form
For recording daily water quality, equipment operation, feed rations, and other inputs. Page # 409
12
Grow—out Group Sampling_Form & Calc
For weekly shrimp growth sampling, with calculations for average weight and growth (g/d and g/wk) given in a separate spreadsheet. Page # 410
13
Grow—out 40 & 100 m3 RWs Growth. FCR. Ration Calc_Examples
Example spreadsheets (2012 & 2013 Grow—out trials) for calculating shrimp average weight, growth, biomass, FCR, and rations.
14
Grow—out Ration Growth FCR Survival
For input of Sheet # 12 data and calculating average weight, growth, biomass, FCR, and rations. A separate spreadsheet with example data from 2014 is included.
Folder Name: General 15
Calc & Example FCRs 100 m3 RW
For recording feed offered and shrimp growth, and calculating FCR, biomass, average weight, and growth. A separate spreadsheet with example data from 2012 is included. Page # 411
16
Group Weight Sampling_Form & Calc
For recording group weight of harvested shrimp from nursery or grow—out tanks. The collected data can be added to a separate spreadsheet which includes formulae for calculating total harvest weight, shrimp number, average weight, and size variation. Page # 412
17
Individual Weight Sampling_Form & Calc
For recording individual weight of 100 sampled shrimp from nursery or grow—out harvest. Data can be added to a separate spreadsheet that includes formulae for calculating average weight and size variation. Page # 413
18
Organic Carbon Supplementation_Examples & Calc
Examples on how to calculate organic carbon requirements for feed with different crude protein and different organic C sources and user input to calculate molasses/white sugar requirements. Page # 414
Folder Name: Water Quality 19
Vibrio & Alkalinity Form_Examples & Calc
For recording and calculating Vibrio plate counts and alkalinity (standard titration method). Examples are given for each. Page # 415
20
TSS Form_Example & Calc
For recording and calculating TSS (standard titration method). Examples are given. Page # 416
21
pH Calc
Spreadsheet showing the calculation of [H+] from known pH and how to calculate an average pH from multiple pH values
22
Changes in WQ during Grow—out_2012 40 m3 RW System_Example
Example spreadsheets for weekly water quality data from the 2012 grow—out trial. Includes data and graphs of TAN, NO2,—N NO3—N, PO4, TSS, VSS, alkalinity, turbidity, cBOD5, and COD changes over time.
Salinity TDS Conductivity_Conversions Table
Conversion table Conductivity to salinity. Page # 417
400
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Postlarvae Acclimation Data Recording Form P L Sourc e :
D a te :
Bag #:
B ag Vol. (L):
Sample Vol. (mL):
P L/Sample :
Live P L/ Sample :
De ad P L/Sample :
Total P L/B ag:
TAN (mg/L):
Time
Temp.
Excel Sheet # 1_PL Acclimation Form
DO
pH
Salinity
Vol. Added (L)
401
402
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Postlarvae Microscopic Evaluation , after Davis et al. (2004) and Villalon (1991). Date :
Hatche ry:
PL Age (d):
Ge ne tic Line :
Sample Siz e :
Population CV:
Av. Wt. (mg): Indicator Mucus & debris on setae:
Fouling: (sessile ciliates, filamentous bacteria, benthic algae, fungi etc.), especially on gills:
Broken walking legs (periopods) or antennae:
Lesions on walking legs/swimming legs (pleopods) and antennae along with/without chitinoclastic bacterial infection: Evidence of brown spots on the body such as chitinoclastic bacteria:
Deformities in eye stalks, rostrum, first and second antennae, tail segments, and walking leg:
Opaqueness of tail segments and swimming legs:
Body pigmentation and hepatopancreas color:
Gut fullness, hepatopancreas lipid content and deformities:
Gill Development:
Other:
Excel Sheet # 2_PL Evaluation Form
Comme nts
Score
Nursery Production - L. vannamei PL Source _________
Date:____/___ DOC:_______ Day: M, T, W, T, F, S, S Tank ID
FW
SW
(m3)
(m3)
FF (h)
MCF (h)
ST (h)
TSS (mg/L)
SS (mL/L)
1.5 mm
2 mm
NH4-N
NO2-N (mg/L)
NO3-N
Sugar (g)
Bicarbo (kg)
PL/m3:_____
Turb (NTU)
Alka (mg/L)
Vibrio (CFU/mL) Yellow Green
Carbo (kg)
Probio (g)
O2 (L/min) (h)
DO am
pH pm
am
pm
Sal (ppt)
Dead (#)
1 2 3 4 5
7 8 9 Tank ID EZ Art
Belt Feeders (kg) <400µm 400-600µm 600-860µm
1 mm
1 2 3 4 5 6
Total Fed (kg)
REMARKS
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
6
7 8 9
Excel Sheet # 3_Nursery WQ, Feed, & More_Form
403
404
Nursery Production - Litopenaeus vannamei PL Source: Stocking Date:
DOC: Days from last Sampling : Current
TK ID
Group Wt. (g)
# Shrimp
1 2 3 4 5 6 7 8 Excel Sheet # 4_Nursery Group Sampling_Form
Tare (g)
7 Av. Wt. 7 Days
Av. Wt. (g)
(g/day)
(g/wk)
Earlier (g)
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Sampling Date :
Example for electronic nursery data entry templet used by Texas A&M-ARML for 40 m raceway Raceway Volume (m ):40 Tank ID: RW 1
PL Genetic Info:
Comments TSS (mg/L)
Alka (mg/L)
TAN (mg/L) NO3-N (mg/L) NO2-N (mg/L) O2 (lpm) Venturi (h) New SW (m3)
Volume (m3)
New FW (m3)
FF (h)
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
17 25
ST (h)
16 24
NaHCO3 (g)
15 23
CaCO3 (g)
14 22
Av. Weight (g)
13 21
Current Bio (g)
12 20
Bio Incr from Last
11 19
FCR From T1
10 18
Feed from Last (g)
9 17
Feed Types
8 16
FCR from Last
7 15
Total Feed (g)
6 14
Feed Type 2 (g)
5 13
pH
4 12
Feed Type 1 (g)
DO (%)
DO (mg/L)
3 11
3
Stocking Date:
Temperature (oC) SS (mL/L)
Time (PM)
pH
Turbidity (NTU) DO (mg/L)
Salinity (ppt)
DO (% Saturation)
Time (AM)
Temperature (oC)
Day of culture
PL Age (days)
9
Date (M/D/Y)
1
40,294 Cross: Fast-Growth/Taura-R# of shrimp:
PL Size (g): Stocking Density (PL/m ):
# of PLs stocked: 3
3
2 10
18 26
19 27
20 28
Excel Sheet # 6_Typical Nur WQ Feed_records
405
Min Ln (mm) Max Ln (mm) Mean Wt (g) 3 4 5 6 7
4 5 6 7 8
0.0010 0.0015
Insufficient branchial development and osmoregulatory capacity for salinity less than about 30 ppt.
30 25 20 15 10 5 0 5
10
15 20 PL age (days)
25
30
25
30
0.35 0.30
PL weight (g)
0.25 0.20 0.15 0.10 0.05 0.00 5
10
15
20
PL age (days)
Excel Sheet # 8_Shrimp PL Age and Length
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Acceptable range in PL development for osmoregulatory capacity (salinity reduction) and shipping in sealed bags (metabolic loading).
35
PL length (mm)
PL age 5 6 7 8 9
406
(Doug Ernst, NSC, 4/25/14)
Relationship of PL age and size
Data compiled from various sources, internal and external. Age and size relation shown below is an approximation and varies with PL culture conditions and growth rate. Given that it's easier to measure length than weight for PL stocking (PL8 - 12), this chart is used to estimate mean weight based on mean length.
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Nursery Tank Sampling Before Transfer Tank ID: Sample
Date: Total Wt. (g)
# Shrimp
Tare (g)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Excel Sheet # 9_Nursery Sampling Before Transfer_Form
Av. Wt. (g)
407
408
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Juvenile Transfer - Data Recording Sheet P L Sourc e :
M ove d to GO Tank: 3
Tank Vol. (m ): Nursery ID: Weight (kg)
Trans. Date: Cumulative Weight (kg)
Weight (kg)
1
26
2
27
3
28
4
29
5
30
6
31
7
32
8
33
9
34
10
35
11
36
12
37
13
38
14
39
15
40
16
41
17
42
18
43
19
44
20
45
21
46
22
47
23
48
24
49
25
50
Excel Sheet # 10_Juvenile Transfer Form & Calc
Cumulative Weight (kg)
Date:____/___
Grow-out - L. vannamei PL Source _________
DOC:_______
Stocking Juveniles/m3:_________
Day: M, T, W, T, F, S, S Tank ID
FW 3
SW
(m )
3 (m )
1 mm
1.5 mm
FF (h)
MCF (h)
TSS (mg/L)
SS (mL/L)
NH4-N
Total Fed Sugar (kg) (g)
Bicarbo (kg)
Carbo (kg)
ST (h)
NO2-N (mg/L)
NO3-N
Turb (NTU)
Alka (mg/L)
Vibrio (CFU/mL) Yellow Green
DO am
pH pm
am
pm
Sal (ppt)
Dead (#)
1 2 3
5 6 7 8
Tank ID
Belt Feeders (kg) 2 mm
2.4 mm
Probio (g)
O2 (L/min)
(h)
1 2 3 4 5
REMARKS
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
4
6 7 8 P. 535 GO WQ Operaon Feed
Excel Sheet # 11_Grow-out WQ Operation Feed Vibrio Inputs Data Recording Form
409
410
Grow-out Production - Litopenaeus vannamei PL Source:
DOC:
Stocking Date:
Days from Last Sampling:
TK
ID
Current Group Wt. (g)
# Shrimp
Tare (g)
1 2 3 4 5 6 7 8 Excel Sheet # 12_Grow-out Group Sampling_Form & Calc
7
Av. Wt. 7 Days Av. Wt. (g)
(g/day)
(g/wk)
Earlier (g)
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Sampling Date:
411
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY 3
Computing FCR in 100 m RW Total shrimp stocked in RW: Date
Total Total Doc Feed (g/day) Feed (g)
50,000 Stocking density (shrimp/m3): Inter FCR
Overall Feed FCR Last wt.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Excel Sheet # 15—Grow-out ration growth FCR survival
500
Biomass Av. wt. Biomass Increase (g) (g) (g)
412
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Group Weight - Nursery / Grow-out Harvest - Data Recording Sheet Transfer / Final Harvest
PL Source: Tot. Wt. (g)
# shrimp
Tare
Av. Wt.
Tot. Wt. (g)
1
21
2
22
3
23
4
24
5
25
6
26
7
27
8
28
9
29
10
30
11
31
12
32
13
33
14
34
15
35
16
36
17
37
18
38
19
39
20
40
Excel Sheet # 16—Group weight sampling_form & calc
Tank ID:
Date: # shrimp
Tare
Av. Wt.
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Individual Weight - Data Recording Sheet Tank ID:
Nur.
GO
Trans. Harvest Date:
1
26
51
76
2
27
52
77
3
28
53
78
4
29
54
79
5
30
55
80
6
31
56
81
7
32
57
82
8
33
58
83
9
34
59
84
10
35
60
85
11
36
61
86
12
37
62
87
13
38
63
88
14
39
64
89
15
40
65
90
16
41
66
91
17
42
67
92
18
43
68
93
19
44
69
94
20
45
70
95
21
46
71
96
22
47
72
97
23
48
73
98
24
49
74
99
25
50
75
100
Excel Sheet # 17—Individual weight sampling_form & calc
413
Specific Example 1. Assuming tank volume of: 100,000 L 2. Level of TAN in tank: 3 mg/L 3. Providing the heterotrophic bacteria all organic C requires to convert the TAN into bacteria biomass Calculation for molasses:
100,000 L (TK vol.)
3 (TAN conc.)
6 (required C)
Calculation of daily TAN production in no exchange production system Assumptions: F = Daily Ration: PC = Protein Concentration: Constant for TAN generation in no exchan Nitrogen in Protein:
1 kg 35% = 0.144 16%
0.35
1 kg 4 0% = 0.144 0.0576 kg
1.3 (molasses spec. wt.) Example 4: F PC C TAN/day =
0.40
Example 3: F 1 kg PC 4 5% = C 0.144 0.0648 kg TAN/day
0.45
24% (C in molasses) / 1,000 (conv. To g from m
1 kg 50% = 0.144 0.0720 kg
0.50
Example 5: F 1 kg PC 55% = C 0.144 0.0792 kg TAN/day
0.55
Steps to enhance development of nitrifying bacteria Assumptions: Tank volume: 40,000 L 1) 1/3 of the TAN generated from feed per day is taken by the heterotrophic bacteria 2) 2/3 of the TAN generated from feed per day is left for the nitrifying bacteria to process 3) Tank w as inoculated w ith at least 10% of its volume w ith nitrifying-rich water 4) Alkalinity, TAN, nitrite, nitrate and pH are monitored daily 5) Daily ration: 1 kg 6) Feed protein concentration: 55% 7) Amount of TAN generated: 0.0792 kg 1.98 mg/L (0.0792 × 1,000 × 1,000 / 40,000) 8) TAN concentration in 9) Amount of TAN left for the nitr 0.0523 kg (0.0792 × 0.66) Day 1 TAN 1.98 mg/L Alkalinity 140 mg/L (as CaCO3) pH 7.8 NO2 0.01 mg/L 0.001 mg/L NO3 Organic C supplementat 0.2981 kg [(0.0523 × 6 - (0.0523 × 6 × 0.05)] 5% reduction in organic C below the amount needed to convert all TAN into heterotrophic bacterial biomass to free-up TAN for the nitrifying bacteria
TAN (kg) = F (kg) × PC (decimal value) × 0.144 0.0504 1 × 35% × 0.144 Example 1: F PC C TAN/day
=
1 kg 30% = 0.144 0.0432 kg
0.30
Excel Sheet # 18_Organic Carbon Requirement Examples & Cal
Day 2 TAN 0.01 mg/L Alkalinity 128 mg/L (as CaCO3) pH 7.8 NO2 0.02 mg/L 0.001 mg/L NO3 Organic C supplementat 0.2824 kg (0.3138 - 0.0314) Alkalinity reduction along w ith slight increase in nitrite suggest nitrification activity 10% reduction in organic C supplementation along with increase in alkalinity to 140 mg/L are suggested to free-up TAN for the nitrifying bacteria
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Carbon Source Available C Required Organic Carbon Molasses* 24.0% 5,769.23 mL White sugar 42.1% 4,275.53 g Lactose 42.1% 4,275.53 g 40.0% 4,500.00 g Dextrose Glucose 40.0% 4,500.00 g Acetate 40.0% 4,500.00 g Glycerol 39.1% 4,603.58 L Cellulose 44.4% 4,054.05 g Starch 44.4% 4,054.05 g Cassava meal 43.4% 4,147.47 g Corn flour 43.4% 4,147.47 g Rice brane 43.4% 4,147.47 g Sorghum meal 43.4% 4,147.47 g Tapioca 43.4% 4,147.47 g Wheat flour 43.4% 4,147.47 g Wheat brane 43.4% 4,147.47 g * Assuming 24% W/W carbon concentration and specific weight of 1.3 g/ml
Example 2: F PC C TAN/day =
414
Amount of different organic carbon sources required to convert all TAN generated from feed into biomass of heterotrophic bacteria
415
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Vibrio Counts Date:
Time Inoculated: Time Counted: Sample size (µL):
Yellow
Green
Total
RACEWAY CFU/Plate
CFU/mL
CFU/Plate
CFU/mL
RW 1 RW 2 RW 3 RW 4 RW 5 RW 6 RW 7 RW 8 RW 9 RW 10
Alkalinity SULFURIC ACID USED (mL) Initial Reading
End Point Reading
Date:
Difference (mL)
RW1
0.00
RW2
0.00
RW3
0.00
RW4
0.00
RW5
0.00
RW6
0.00
B1
0.00
B2
0.00
Normality of H2SO4 Solution
Jun-14
0.019023462
*Calculated normality of H 2 SO 4 solution- should be close to 0.02
Excel Sheet # 19—Vibrio Alkalinity Forms & Calc.xls
Alkalinity (mg/L CaCO3)
CFU/Plate
CFU/mL
416
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
TSS Monitoring Form* DATE: RW Sample Empty (g) Dry (g) Empty (mg) Dry (mg) TSS (mg/L) Av. TSS (mg/L) Dry 2 (g) Dry 2 (mg) Control
RW1
RW2
RW3
RW4
RW5
RW6
RW7
RW8
RW9
RW10 * This form is based on Standard Method procedure (Eaton et al. 1995); To save time and siplify monitoring we recommend the use of Pre Weighed 7.7. cm filter papers Excel Sheet #20—TSS Form_Example & Calc
417
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Conversion Table for Changing Conductivity into Salinity Conductivity*
Salinity
0°C
5°C
10°C
15°C
20°C
25°C
30°C
ppt
1.200
1.400
1.500
1.700
2.000
2.200
2.400
1
2.220
2.500
2.900
3.300
3.700
4.100
4.500
2
3.200
3.700
4.200
4.700
5.300
5.900
6.500
3
4.100
4.700
5.400
6.100
6.900
7.600
8.400
4
5.000
5.800
6.600
7.500
8.400
9.300
10.300
5
5.900
6.800
7.900
8.800
9.900
11.000
12.100
6
6.700 7.600
7.800 8.800
8.900 10.100
10.100 11.400
11.300 12.800
12.600 14.200
13.900 15.700
7 8
8.500
9.800
11.200
12.700
14.200
15.800
17.400
9
9.300
10.800
12.300
13.900
15.600
17.300
19.100
10
10.200
11.800
13.400
15.200
17.000
18.900
20.800
11
11.000
12.800
14.500
16.500
18.900
20.400
22.500
12
11.900 12.600
13.700 14.600
15.600 16.700
17.600 18.700
19.700 21.100
21.900 23.400
24.100 25.800
13 14
13.400
15.600
17.800
20.100
22.400
24.900
27.400
15
14.200
16.400
18.800
21.200
23.800
26.400
29.100
16
15.000
17.400
19.800
22.400
25.100
27.800
30.700
17
15.800
18.300
20.900
23.600
26.400
29.300
32.300
18
16.600
14.200
21.900
24.800
27.700
30.700
33.900
19
17.400
20.100
23.000
25.900
29.000
32.200
35.500
20
18.200
21.100
24.000
27.100
30.300
33.600
37.000
21
19.000
22.000
25.100
28.300
31.600
35.000
38.600
22
19.800
22.900
26.100
29.400
32.900
36.500
40.100
23
20.600
23.800
27.100
30.600
34.200
37.900
41.700
24
21.400
24.700
28.100
31.700
35.400
39.300
43.200
25
22.100
25.500
29.100
32.800
36.700
40.700
44.800
26
22.800
26.400
30.100
33.900
37.900
42.100
46.300
27
23.600
27.300
31.100
35.100
39.200
43.500
47.800
28
24.400
28.100
32.100
36.200
40.400
44.800
49.400
29
25.200
29.000
33.100
37.300
41.700
46.200
50.900
30
26.000
30.000
34.100
38.500
43.000
47.600
52.400
31
26.800
30.900
35.100
39.600
44.200
49.000
53.900
32
27.500
31.700
36.100
40.700
45.400
50.300
55.400
33
28.300
32.600
37.100
41.800
46.700
51.700
56.800
34
29.100
33.500
38.100
42.900
47.900
53.000
58.300
35
29.700
34.200
39.000
44.000
49.100
54.400
59.800
36
30.500
35.100
40.000
45.100
50.300
55.700
61.300
37
31.200
36.000
41.000
46.200
51.500
57.100
62.800
38
32.000 32.700
36.800 37.700
41.900 42.900
47.200 48.300
52.700 53.900
58.400 59.700
64.200 65.700
39 40
* Conductivity values are given in millisiemens/cm Data derived from the equation of P.K. Weyl, Limnology and Oceanography; 9,75 (1964).
VII
Excel Sheets and Forms—Summary No.
File Name
Description
Folder Name: Nursery 1
PL Acclimation Data Recording Form
For data recording during acclimation to nursery tanks: PL samples, mortalities, water volume, and water quality. Page # 401
2
PL Evaluation Data Recording Form
For PL microscopic physical evaluation following receipt from the hatchery and during early nursery stages. Page # 402
3
Nursery WQ, Feed, & More_Form
For recording daily water quality, equipment operation, feed rations, and other inputs. Page # 403
4
Nursery Group Sampling_Form & Calc
For weekly shrimp growth sampling, with calculations for average weight and growth (g/day and g/week) given in a separate spreadsheet. Page # 404
5
Nursery Ration Growth FCR Survival
For input of Excel Sheet #4 data and calculating average weight, growth, biomass, FCR, and rations. A separate spreadsheet with example data from 2014 is included.
6
Nursery WQ Feed Growth FCR Electronic Data Recording Form Example & Cal
For collating data for individual nursery tanks over a full nursery cycle (from Sheet # 3 and # 4)—water quality, equipment operation, feed rations, shrimp weight, and other inputs. Includes columns to calculate FCR and growth. A separate spreadsheet with example data from 2012 is included. Page # 405
7
Nursery Individual wt. Frequency distribution & Feed Calc_Examples
Example spreadsheets (2014 nursery trials) for calculating shrimp size distribution and allocating feed type and size to individual nursery tanks.
8
Shrimp PL Age and Length
For estimating L. vannamei PL weight at given total lengths and PL size at given ages. Covers PL5–30. Page # 406
9
Nursery Sampling Before Transfer_Form
For recording weight and size distribution prior to nursery tank harvest. The collected data can be added to a separate spreadsheet which includes formulae for calculating average weight and size variation. Page # 407 Continued
399
400
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
No.
File Name
Description
10
Juvenile Transfer Form & Calc
For recording weight of harvested shrimp during transfer to grow—out tanks. The collected data can be added to a separate spreadsheet which includes formulae for calculating total harvest weight, yield, shrimp number, survival, average weight, and size variation. Page # 408
Folder Name: Grow—out 11
Grow—out WQ Operation Feed Vibrio Inputs Data Recording Form
For recording daily water quality, equipment operation, feed rations, and other inputs. Page # 409
12
Grow—out Group Sampling_Form & Calc
For weekly shrimp growth sampling, with calculations for average weight and growth (g/d and g/wk) given in a separate spreadsheet. Page # 410
13
Grow—out 40 & 100 m3 RWs Growth. FCR. Ration Calc_Examples
Example spreadsheets (2012 & 2013 Grow—out trials) for calculating shrimp average weight, growth, biomass, FCR, and rations.
14
Grow—out Ration Growth FCR Survival
For input of Sheet # 12 data and calculating average weight, growth, biomass, FCR, and rations. A separate spreadsheet with example data from 2014 is included.
Folder Name: General 15
Calc & Example FCRs 100 m3 RW
For recording feed offered and shrimp growth, and calculating FCR, biomass, average weight, and growth. A separate spreadsheet with example data from 2012 is included. Page # 411
16
Group Weight Sampling_Form & Calc
For recording group weight of harvested shrimp from nursery or grow—out tanks. The collected data can be added to a separate spreadsheet which includes formulae for calculating total harvest weight, shrimp number, average weight, and size variation. Page # 412
17
Individual Weight Sampling_Form & Calc
For recording individual weight of 100 sampled shrimp from nursery or grow—out harvest. Data can be added to a separate spreadsheet that includes formulae for calculating average weight and size variation. Page # 413
18
Organic Carbon Supplementation_Examples & Calc
Examples on how to calculate organic carbon requirements for feed with different crude protein and different organic C sources and user input to calculate molasses/white sugar requirements. Page # 414
Folder Name: Water Quality 19
Vibrio & Alkalinity Form_Examples & Calc
For recording and calculating Vibrio plate counts and alkalinity (standard titration method). Examples are given for each. Page # 415
20
TSS Form_Example & Calc
For recording and calculating TSS (standard titration method). Examples are given. Page # 416
21
pH Calc
Spreadsheet showing the calculation of [H+] from known pH and how to calculate an average pH from multiple pH values
22
Changes in WQ during Grow—out_2012 40 m3 RW System_Example
Example spreadsheets for weekly water quality data from the 2012 grow—out trial. Includes data and graphs of TAN, NO2,—N NO3—N, PO4, TSS, VSS, alkalinity, turbidity, cBOD5, and COD changes over time.
Salinity TDS Conductivity_Conversions Table
Conversion table Conductivity to salinity. Page # 417
400
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Postlarvae Acclimation Data Recording Form P L Sourc e :
D a te :
Bag #:
B ag Vol. (L):
Sample Vol. (mL):
P L/Sample :
Live P L/ Sample :
De ad P L/Sample :
Total P L/B ag:
TAN (mg/L):
Time
Temp.
Excel Sheet # 1_PL Acclimation Form
DO
pH
Salinity
Vol. Added (L)
401
402
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Postlarvae Microscopic Evaluation , after Davis et al. (2004) and Villalon (1991). Date :
Hatche ry:
PL Age (d):
Ge ne tic Line :
Sample Siz e :
Population CV:
Av. Wt. (mg): Indicator Mucus & debris on setae:
Fouling: (sessile ciliates, filamentous bacteria, benthic algae, fungi etc.), especially on gills:
Broken walking legs (periopods) or antennae:
Lesions on walking legs/swimming legs (pleopods) and antennae along with/without chitinoclastic bacterial infection: Evidence of brown spots on the body such as chitinoclastic bacteria:
Deformities in eye stalks, rostrum, first and second antennae, tail segments, and walking leg:
Opaqueness of tail segments and swimming legs:
Body pigmentation and hepatopancreas color:
Gut fullness, hepatopancreas lipid content and deformities:
Gill Development:
Other:
Excel Sheet # 2_PL Evaluation Form
Comme nts
Score
Nursery Production - L. vannamei PL Source _________
Date:____/___ DOC:_______ Day: M, T, W, T, F, S, S Tank ID
FW
SW
(m3)
(m3)
FF (h)
MCF (h)
ST (h)
TSS (mg/L)
SS (mL/L)
1.5 mm
2 mm
NH4-N
NO2-N (mg/L)
NO3-N
Sugar (g)
Bicarbo (kg)
PL/m3:_____
Turb (NTU)
Alka (mg/L)
Vibrio (CFU/mL) Yellow Green
Carbo (kg)
Probio (g)
O2 (L/min) (h)
DO am
pH pm
am
pm
Sal (ppt)
Dead (#)
1 2 3 4 5
7 8 9 Tank ID EZ Art
Belt Feeders (kg) <400µm 400-600µm 600-860µm
1 mm
1 2 3 4 5 6
Total Fed (kg)
REMARKS
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
6
7 8 9
Excel Sheet # 3_Nursery WQ, Feed, & More_Form
403
404
Nursery Production - Litopenaeus vannamei PL Source: Stocking Date:
DOC: Days from last Sampling : Current
TK ID
Group Wt. (g)
# Shrimp
1 2 3 4 5 6 7 8 Excel Sheet # 4_Nursery Group Sampling_Form
Tare (g)
7 Av. Wt. 7 Days
Av. Wt. (g)
(g/day)
(g/wk)
Earlier (g)
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Sampling Date :
Example for electronic nursery data entry templet used by Texas A&M-ARML for 40 m raceway Raceway Volume (m ):40 Tank ID: RW 1
PL Genetic Info:
Comments TSS (mg/L)
Alka (mg/L)
TAN (mg/L) NO3-N (mg/L) NO2-N (mg/L) O2 (lpm) Venturi (h) New SW (m3)
Volume (m3)
New FW (m3)
FF (h)
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
17 25
ST (h)
16 24
NaHCO3 (g)
15 23
CaCO3 (g)
14 22
Av. Weight (g)
13 21
Current Bio (g)
12 20
Bio Incr from Last
11 19
FCR From T1
10 18
Feed from Last (g)
9 17
Feed Types
8 16
FCR from Last
7 15
Total Feed (g)
6 14
Feed Type 2 (g)
5 13
pH
4 12
Feed Type 1 (g)
DO (%)
DO (mg/L)
3 11
3
Stocking Date:
Temperature (oC) SS (mL/L)
Time (PM)
pH
Turbidity (NTU) DO (mg/L)
Salinity (ppt)
DO (% Saturation)
Time (AM)
Temperature (oC)
Day of culture
PL Age (days)
9
Date (M/D/Y)
1
40,294 Cross: Fast-Growth/Taura-R# of shrimp:
PL Size (g): Stocking Density (PL/m ):
# of PLs stocked: 3
3
2 10
18 26
19 27
20 28
Excel Sheet # 6_Typical Nur WQ Feed_records
405
Min Ln (mm) Max Ln (mm) Mean Wt (g) 3 4 5 6 7
4 5 6 7 8
0.0010 0.0015
Insufficient branchial development and osmoregulatory capacity for salinity less than about 30 ppt.
30 25 20 15 10 5 0 5
10
15 20 PL age (days)
25
30
25
30
0.35 0.30
PL weight (g)
0.25 0.20 0.15 0.10 0.05 0.00 5
10
15
20
PL age (days)
Excel Sheet # 8_Shrimp PL Age and Length
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Acceptable range in PL development for osmoregulatory capacity (salinity reduction) and shipping in sealed bags (metabolic loading).
35
PL length (mm)
PL age 5 6 7 8 9
406
(Doug Ernst, NSC, 4/25/14)
Relationship of PL age and size
Data compiled from various sources, internal and external. Age and size relation shown below is an approximation and varies with PL culture conditions and growth rate. Given that it's easier to measure length than weight for PL stocking (PL8 - 12), this chart is used to estimate mean weight based on mean length.
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Nursery Tank Sampling Before Transfer Tank ID: Sample
Date: Total Wt. (g)
# Shrimp
Tare (g)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Excel Sheet # 9_Nursery Sampling Before Transfer_Form
Av. Wt. (g)
407
408
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Juvenile Transfer - Data Recording Sheet P L Sourc e :
M ove d to GO Tank: 3
Tank Vol. (m ): Nursery ID: Weight (kg)
Trans. Date: Cumulative Weight (kg)
Weight (kg)
1
26
2
27
3
28
4
29
5
30
6
31
7
32
8
33
9
34
10
35
11
36
12
37
13
38
14
39
15
40
16
41
17
42
18
43
19
44
20
45
21
46
22
47
23
48
24
49
25
50
Excel Sheet # 10_Juvenile Transfer Form & Calc
Cumulative Weight (kg)
Date:____/___
Grow-out - L. vannamei PL Source _________
DOC:_______
Stocking Juveniles/m3:_________
Day: M, T, W, T, F, S, S Tank ID
FW 3
SW
(m )
3 (m )
1 mm
1.5 mm
FF (h)
MCF (h)
TSS (mg/L)
SS (mL/L)
NH4-N
Total Fed Sugar (kg) (g)
Bicarbo (kg)
Carbo (kg)
ST (h)
NO2-N (mg/L)
NO3-N
Turb (NTU)
Alka (mg/L)
Vibrio (CFU/mL) Yellow Green
DO am
pH pm
am
pm
Sal (ppt)
Dead (#)
1 2 3
5 6 7 8
Tank ID
Belt Feeders (kg) 2 mm
2.4 mm
Probio (g)
O2 (L/min)
(h)
1 2 3 4 5
REMARKS
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
4
6 7 8 P. 535 GO WQ Operaon Feed
Excel Sheet # 11_Grow-out WQ Operation Feed Vibrio Inputs Data Recording Form
409
410
Grow-out Production - Litopenaeus vannamei PL Source:
DOC:
Stocking Date:
Days from Last Sampling:
TK
ID
Current Group Wt. (g)
# Shrimp
Tare (g)
1 2 3 4 5 6 7 8 Excel Sheet # 12_Grow-out Group Sampling_Form & Calc
7
Av. Wt. 7 Days Av. Wt. (g)
(g/day)
(g/wk)
Earlier (g)
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Sampling Date:
411
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY 3
Computing FCR in 100 m RW Total shrimp stocked in RW: Date
Total Total Doc Feed (g/day) Feed (g)
50,000 Stocking density (shrimp/m3): Inter FCR
Overall Feed FCR Last wt.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Excel Sheet # 15—Grow-out ration growth FCR survival
500
Biomass Av. wt. Biomass Increase (g) (g) (g)
412
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Group Weight - Nursery / Grow-out Harvest - Data Recording Sheet Transfer / Final Harvest
PL Source: Tot. Wt. (g)
# shrimp
Tare
Av. Wt.
Tot. Wt. (g)
1
21
2
22
3
23
4
24
5
25
6
26
7
27
8
28
9
29
10
30
11
31
12
32
13
33
14
34
15
35
16
36
17
37
18
38
19
39
20
40
Excel Sheet # 16—Group weight sampling_form & calc
Tank ID:
Date: # shrimp
Tare
Av. Wt.
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Individual Weight - Data Recording Sheet Tank ID:
Nur.
GO
Trans. Harvest Date:
1
26
51
76
2
27
52
77
3
28
53
78
4
29
54
79
5
30
55
80
6
31
56
81
7
32
57
82
8
33
58
83
9
34
59
84
10
35
60
85
11
36
61
86
12
37
62
87
13
38
63
88
14
39
64
89
15
40
65
90
16
41
66
91
17
42
67
92
18
43
68
93
19
44
69
94
20
45
70
95
21
46
71
96
22
47
72
97
23
48
73
98
24
49
74
99
25
50
75
100
Excel Sheet # 17—Individual weight sampling_form & calc
413
Specific Example 1. Assuming tank volume of: 100,000 L 2. Level of TAN in tank: 3 mg/L 3. Providing the heterotrophic bacteria all organic C requires to convert the TAN into bacteria biomass Calculation for molasses:
100,000 L (TK vol.)
3 (TAN conc.)
6 (required C)
Calculation of daily TAN production in no exchange production system Assumptions: F = Daily Ration: PC = Protein Concentration: Constant for TAN generation in no exchan Nitrogen in Protein:
1 kg 35% = 0.144 16%
0.35
1 kg 4 0% = 0.144 0.0576 kg
1.3 (molasses spec. wt.) Example 4: F PC C TAN/day =
0.40
Example 3: F 1 kg PC 4 5% = C 0.144 0.0648 kg TAN/day
0.45
24% (C in molasses) / 1,000 (conv. To g from m
1 kg 50% = 0.144 0.0720 kg
0.50
Example 5: F 1 kg PC 55% = C 0.144 0.0792 kg TAN/day
0.55
Steps to enhance development of nitrifying bacteria Assumptions: Tank volume: 40,000 L 1) 1/3 of the TAN generated from feed per day is taken by the heterotrophic bacteria 2) 2/3 of the TAN generated from feed per day is left for the nitrifying bacteria to process 3) Tank w as inoculated w ith at least 10% of its volume w ith nitrifying-rich water 4) Alkalinity, TAN, nitrite, nitrate and pH are monitored daily 5) Daily ration: 1 kg 6) Feed protein concentration: 55% 7) Amount of TAN generated: 0.0792 kg 1.98 mg/L (0.0792 × 1,000 × 1,000 / 40,000) 8) TAN concentration in 9) Amount of TAN left for the nitr 0.0523 kg (0.0792 × 0.66) Day 1 TAN 1.98 mg/L Alkalinity 140 mg/L (as CaCO3) pH 7.8 NO2 0.01 mg/L 0.001 mg/L NO3 Organic C supplementat 0.2981 kg [(0.0523 × 6 - (0.0523 × 6 × 0.05)] 5% reduction in organic C below the amount needed to convert all TAN into heterotrophic bacterial biomass to free-up TAN for the nitrifying bacteria
TAN (kg) = F (kg) × PC (decimal value) × 0.144 0.0504 1 × 35% × 0.144 Example 1: F PC C TAN/day
=
1 kg 30% = 0.144 0.0432 kg
0.30
Excel Sheet # 18_Organic Carbon Requirement Examples & Cal
Day 2 TAN 0.01 mg/L Alkalinity 128 mg/L (as CaCO3) pH 7.8 NO2 0.02 mg/L 0.001 mg/L NO3 Organic C supplementat 0.2824 kg (0.3138 - 0.0314) Alkalinity reduction along w ith slight increase in nitrite suggest nitrification activity 10% reduction in organic C supplementation along with increase in alkalinity to 140 mg/L are suggested to free-up TAN for the nitrifying bacteria
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Carbon Source Available C Required Organic Carbon Molasses* 24.0% 5,769.23 mL White sugar 42.1% 4,275.53 g Lactose 42.1% 4,275.53 g 40.0% 4,500.00 g Dextrose Glucose 40.0% 4,500.00 g Acetate 40.0% 4,500.00 g Glycerol 39.1% 4,603.58 L Cellulose 44.4% 4,054.05 g Starch 44.4% 4,054.05 g Cassava meal 43.4% 4,147.47 g Corn flour 43.4% 4,147.47 g Rice brane 43.4% 4,147.47 g Sorghum meal 43.4% 4,147.47 g Tapioca 43.4% 4,147.47 g Wheat flour 43.4% 4,147.47 g Wheat brane 43.4% 4,147.47 g * Assuming 24% W/W carbon concentration and specific weight of 1.3 g/ml
Example 2: F PC C TAN/day =
414
Amount of different organic carbon sources required to convert all TAN generated from feed into biomass of heterotrophic bacteria
415
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Vibrio Counts Date:
Time Inoculated: Time Counted: Sample size (µL):
Yellow
Green
Total
RACEWAY CFU/Plate
CFU/mL
CFU/Plate
CFU/mL
RW 1 RW 2 RW 3 RW 4 RW 5 RW 6 RW 7 RW 8 RW 9 RW 10
Alkalinity SULFURIC ACID USED (mL) Initial Reading
End Point Reading
Date:
Difference (mL)
RW1
0.00
RW2
0.00
RW3
0.00
RW4
0.00
RW5
0.00
RW6
0.00
B1
0.00
B2
0.00
Normality of H2SO4 Solution
Jun-14
0.019023462
*Calculated normality of H 2 SO 4 solution- should be close to 0.02
Excel Sheet # 19—Vibrio Alkalinity Forms & Calc.xls
Alkalinity (mg/L CaCO3)
CFU/Plate
CFU/mL
416
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
TSS Monitoring Form* DATE: RW Sample Empty (g) Dry (g) Empty (mg) Dry (mg) TSS (mg/L) Av. TSS (mg/L) Dry 2 (g) Dry 2 (mg) Control
RW1
RW2
RW3
RW4
RW5
RW6
RW7
RW8
RW9
RW10 * This form is based on Standard Method procedure (Eaton et al. 1995); To save time and siplify monitoring we recommend the use of Pre Weighed 7.7. cm filter papers Excel Sheet #20—TSS Form_Example & Calc
417
APPENDIX VII EXCEL SHEETS AND FORMS—SUMMARY
Conversion Table for Changing Conductivity into Salinity Conductivity*
Salinity
0°C
5°C
10°C
15°C
20°C
25°C
30°C
ppt
1.200
1.400
1.500
1.700
2.000
2.200
2.400
1
2.220
2.500
2.900
3.300
3.700
4.100
4.500
2
3.200
3.700
4.200
4.700
5.300
5.900
6.500
3
4.100
4.700
5.400
6.100
6.900
7.600
8.400
4
5.000
5.800
6.600
7.500
8.400
9.300
10.300
5
5.900
6.800
7.900
8.800
9.900
11.000
12.100
6
6.700 7.600
7.800 8.800
8.900 10.100
10.100 11.400
11.300 12.800
12.600 14.200
13.900 15.700
7 8
8.500
9.800
11.200
12.700
14.200
15.800
17.400
9
9.300
10.800
12.300
13.900
15.600
17.300
19.100
10
10.200
11.800
13.400
15.200
17.000
18.900
20.800
11
11.000
12.800
14.500
16.500
18.900
20.400
22.500
12
11.900 12.600
13.700 14.600
15.600 16.700
17.600 18.700
19.700 21.100
21.900 23.400
24.100 25.800
13 14
13.400
15.600
17.800
20.100
22.400
24.900
27.400
15
14.200
16.400
18.800
21.200
23.800
26.400
29.100
16
15.000
17.400
19.800
22.400
25.100
27.800
30.700
17
15.800
18.300
20.900
23.600
26.400
29.300
32.300
18
16.600
14.200
21.900
24.800
27.700
30.700
33.900
19
17.400
20.100
23.000
25.900
29.000
32.200
35.500
20
18.200
21.100
24.000
27.100
30.300
33.600
37.000
21
19.000
22.000
25.100
28.300
31.600
35.000
38.600
22
19.800
22.900
26.100
29.400
32.900
36.500
40.100
23
20.600
23.800
27.100
30.600
34.200
37.900
41.700
24
21.400
24.700
28.100
31.700
35.400
39.300
43.200
25
22.100
25.500
29.100
32.800
36.700
40.700
44.800
26
22.800
26.400
30.100
33.900
37.900
42.100
46.300
27
23.600
27.300
31.100
35.100
39.200
43.500
47.800
28
24.400
28.100
32.100
36.200
40.400
44.800
49.400
29
25.200
29.000
33.100
37.300
41.700
46.200
50.900
30
26.000
30.000
34.100
38.500
43.000
47.600
52.400
31
26.800
30.900
35.100
39.600
44.200
49.000
53.900
32
27.500
31.700
36.100
40.700
45.400
50.300
55.400
33
28.300
32.600
37.100
41.800
46.700
51.700
56.800
34
29.100
33.500
38.100
42.900
47.900
53.000
58.300
35
29.700
34.200
39.000
44.000
49.100
54.400
59.800
36
30.500
35.100
40.000
45.100
50.300
55.700
61.300
37
31.200
36.000
41.000
46.200
51.500
57.100
62.800
38
32.000 32.700
36.800 37.700
41.900 42.900
47.200 48.300
52.700 53.900
58.400 59.700
64.200 65.700
39 40
* Conductivity values are given in millisiemens/cm Data derived from the equation of P.K. Weyl, Limnology and Oceanography; 9,75 (1964).