Home

here - Fish Passage Center

1. Fin Clipped OY OY CaN NA Special Species Gear Code GC Gatewell Collection System Multiplier 5 20 0 0 2 Sample Rate Non Cond ry Est niin J Cond Sample Count Collection i L Cone Sample Count Collecion Num exam for descaled Num Cond exam n Num Cond for descaled descaled Total Exam n Total Num for descaled Desc abled 0 PITTag Morts isaac 9 he nc mh VAA 0 Num descaled Total Sample Count l Total Collection J Sample Morts D Facility Morts J Research Morts VILE Entering Incidental Catch Data Once the Catch Detail data have been entered the next step is to enter the non condition incidental species data via the Incidental Catch tab For a detailed description of data entry fields in the Incidental Catch tab see Section VIII C below To create a new record in Incidental Catch click on the New button to add a record Only incidentals collected as part of the non condition data are entered into the Incidental Catch tab at this point Data to enter for each incidental species include 1 Species 2 Sample Count and 3 Sample Morts When the entry of a single species is complete choose Save Record Note Cond Count will be filled in automatically when Condition Data are incorporated into the batch see Section VII H Incidental Catch data should be validated by printing or viewing the Incidental Catch summary report To view this report chos
2. Sample Code H Normal Complete Sample Sample Hou Unknown Total Dischar Comments 1 2 Two or more samples taken during a day with separator cleanout 3 No sample or biased sample due to abnormal flows or inoperation of sample unit 4 No sample or biased sample due to weather conditions 5 No sample or biased sample due to equipment failure maintenance repair ws ww Eh a 7 Incomplete sample no code provided cause explained in comments 18 No fish counts entered Fish accumulated and were sampled at a later date 3 Incomplete or biased sample counts are modified to estimate a normal sample 10 Multiple sample rates used throuout day not including sample rate for GBT sample 12 Sample of fish accumulated 2 days Samplecode minus 10 is number of days 13 Sample of fish accumulated 3 days Samplecode minus 10 is number of days 14 Sample of fish accumulated 4 days Samplecode minus 10 1s number of days 15 Sample of fish accumulated 5 days Samplecode minus 10 is number of days 16 Sample of fish accumulated 6 days Samplecode minus 10 is number of days 17 Sample of fish accumulated 7 days Samplecode minus 10 is number of days Comments 2 51 1 Normal Complete Sample 24 hours 2 Two or more samples taken during a day with separator clean out 3 No sample biased sample due to abnormal flows or in operation of sample unit GC 00 if no sample GC GC if bias sample 4 No sample biase
3. C Fungus C Columnaris C eko _ Parasite Deformity C Other Disease Checkboxes There are six checkboxes found near the Disease label These include Fungus Columnaris BKD Parasite Deformity and Other Check all boxes that apply for a diseased fish If the fish has a disease other than one of these check the Other box and type in a comment in the Special Comment field TIP To save time when entering a comment into the Special Comment field use predefined codes for particular conditions Also up to two comments can be entered into this field as long as they are separated by a semicolon NOTE Detailed definitions of each of these diseases are provided in a separate manual Catch Catch Detai Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS SubBatch 2 Species Code ST TankiTrap A B None Cwt OY ON None Batch 05139 Sequence 74 Species choose Species Code Special Species n a Miscellaneous Incidental Choose Species Code Mark Type AD Adipose Elas Code N A Color Code N A Descaling N A Weight I T Length 170 Predator Bird Fish _ Lamprey Injury Head Eye Operc C Disease Fungus _ Columnaris _ BKO Parasite Deformity Other Other Conditions Checkboxes There are five checkboxes that are designated as Other Conditions These include Pop Eye Fin Hemm Pink Fin Fin Discol and Eye Hemm Check all of the boxes that
4. GC a Sample Code of 1 and a Sample Hours of 2 The data validation process assumes that Sample Hours would be 24 when Gear Code GC and Sample Code 1 are entered Therefore an alert Red Dot is provided to alert the user to the suspect combination 1 Ea Remote SMP Site Data Entry Program E o O x File Reports Hour 0700 End 34 2011 Hour 0700 haw Batet TEW GOLGI gt GC Gatewell Colection System ba End Day Tomorrow Sample Hours New Batch Erma Pisa Veeckord su Example 2 Improper Species Special Species Combination When creating a record in the Catch Detail tab this user entered a record with a Species of CH and Special Species of EF Since Special Species EF is limited to steelhead a Red Dot appears along with a Special Species Validation Alert to alert the user of the suspect combination For more details 108 on which Species Special Species combinations are valid see Section VIII B 1 Special Species Code Eajrem ote SMP Site Data Entry Program Sub Batch 1 Sequence 1 TankiTrap A B None Species Code CH Chinook X Age Coda 1 C 0 FinCipped OY N Gwt OY GN CINIA Special Species BEME Example 3 Improper Sample Code Sub batch Combination When creating a record in the Catch tab this user entered a Sample Code of 1 However when entering data in the Catch Detail tab the user created a second sub batch with a dif
5. At JDA MCN LGS LMN and LGR the sum of the Turbine Discharge and Total Spill cannot be greater than the Total Discharge If this occurs an error message is displayed At BO2 and RIS the sum of PH1 Flow PH2 Flow and Total Spill cannot be greater than the Total Discharge If this occurs an error message is displayed PH 2 Flow This field only appears in the Catch data entry tab of the FPC32 net Main Form at BO2 and RIS PH2 Flow is the average hourly flow in Kcfs through Powerhouse 2 during the sampling period of the batch This number is found on the COE daily report BON 2 AVG DISCH When daylight savings time begins and ends the period for calculating the PH2 Flow will need to be adjusted For detailed instruction on these changes see Section VII M 1 above At BO2 and RIS the sum of PH1 Flow PH2Flow and Total Spill cannot exceed the Total Discharge If this occurs an error message is displayed Total Spill Total Spill is the average hourly spill Kcfs during the sampling period This field is mandatory for BO2 JDA MCN RIS LMN LGS and LGR o Obtain this value is in row SPILL in the COE daily report This field is not displayed at LEW WTB GRN or IMN When daylight savings time begins and ends the period for calculating the Total Spill will need to be adjusted For detailed instruction on these changes see Section VII M 1 above At JDA MCN LGS LMN and LGR the sum of the Turbine Discharge and Total Spill canno
6. If you receive a message that the NET framework is already installed on your computer proceed to the next step 11 Once the installation of this software is complete you will also be required to install Microsoft SQL 2005 Express 12 Download Microsoft SQL 2005 Express from the FPC website ftp ftp fpc org FRC32 net by right clicking on the file SQLEXPR EXE and choosing Save Target as Navigate to a temporary file on your hard drive and save the file FTP directory FPC32 net at ftp fpc org To view this FTP site in Windows Explorer press Alt click View and then click Open FTP Site in Windows Explorer Up to higher level directory 08 26 2011 11 45AM Directory BO 12 02 2008 01 52PM 206 692 864 dotnetix35 exe 08 26 2011 11 46AM Directory LGR 08 26 2011 11 46AM Directory LGS 08 26 2011 11 46AM Directory LMN 08 26 2011 11 46AM Directory Manuals 08 26 2011 11 46AM Directory MCN 08 24 2009 02 48PM 359 656 msicuu2 exe 08 26 2011 11 46AM Directory Preseason Presentations 12 30 2008 08 57AM 739 840 PROCEDURE TO INSTALL FPC32NET doc 08 26 2011 11 46AM Directory RIS 04 23 2009 09 24AM 01 120 setup exe 01 30 2012 04 01PM 57 393 504 SQLEXPR EXE 02 01 2012 11 40AM 6 567 936 TouchScreenSetup3 msi 02 01 2012 03 34PM 6 567 424 TouchScre etup3 la 08 26 2011 11 46AM Directory TrapRelease 05 04 2010 12 12PM 382 Version lo 13 Double click on the SQLEXPR EXE file to begin the installation Follow all prompts and accept all
7. Special Species Combination Example 3 Improper Sample Code Sub batch Combination IX B 1 Daily Summary Report IX B 2 Mark Recapture Report oo cccscsessssssssssessssesesesesesscseseseees IX B 3 Incidental Catch Report cecssssssssssssssesssscsssssssssssssseees IX B 4 Fish Condition Report ceesessssssesssssssssesesessescsceeseseeeeess IX B 5 Individual Fish Condition Report uses IX B 6 Daily Batch Tank Report oo c cessssssssssssesssscsessseseeseseseseees IX B 7 Special Species Daily Batch Tank Report IX B 8 Lamprey Batch Tank Report ooooo cecsssssssesssesessseseseseseees IX C FPC Weekly Validation ooo ccccsesscssssscsecesesesssscsesesessescseseseeeees IX D FPC Validation Spreadsheets IX E End of Year Validation IX F Project by Project Details for SMP Reporting Requirements Printing Daily Reports Sending Data to FPC and Detailed Report DESCrIPtiONs i ccceesssssssssetessssssseee X A Generating and Printing Reports Next Previous Page Printing Reports Save Report As F 11167 400 eae een ne ee ee ee ee eee X B Sending SMP Data and Hand Logs to the FPC Sending New Batches Via E mail sssssessssesessssessesssseseeseeees Uploading New Batches via HTTP Sending Hand Logs to the FP C esscssssessesessssessesseseesesseesee What s New with FPC32 net 2013 XI A Procedure to Allow Full Control for Windows 7 Operating 104 105 105 108 108 108 108 108 109 109 109 110 110 11
8. Total Spit 34 09 ket Comments Tar A Chinook 1 HO Chinook 1 LF uc cur CL Total Ho UC cT CL Grand Toti Non Cond Sample Count Exam Desc Non lt ond Non lt ond Descaled Condon Sample Court Exam Desc Condman Condition Descald Total Sample Count Total Collecton 0 Sample Morts Facility Mot Research Morts qeeceseesleeceHsesliecs Jeco ola coco o oloo so Jeco ola coco o oloo oo Tark amp Chinook 1 HO Chinook 1 LF uc CWT CL T l Hoe Lic Chilly CL T otal LF Grand Toti Non Cond Sample Count Exam Desc Non lt ond Non lt ond Descaled Condmon Sample Court Exam Desc Condition Condition Descakd Total Sample Court Total Collecton di Sample Morts Facility Mots Research Morts PIT Tag Mort Descaling Peta f4 Selececeslon orn noco o VILK End and Send Once data have been validated the next step is to print reports for your records and create an XML file that will be sent to The Fish Passage Center 1 Navigate to the Catch tab and click on Save as Batch 44 e This writes the data in the local database to an XML file in the directory specified in the Settings see Section VII A e In an XML file already exists for that batch you may be prompted with a message asking if you want to overwrite the existing batch Select Yes 2 End data entry each day by printing the Daily Summary Incidental Catch Mark Recaptures Fish Condition Daily Batch Tank All Subbatches and Lamprey Bat
9. Users are allowed to choose as many Predator types as the fish has Definitions and examples of these Predation conditions can be found in the Condition Sampling Protocol document Mark Types These buttons allow the user to enter the following mark types LV left ventral RV right ventral and CWT coded wire tag 104 For those sites that examine Chinook Coho and Sockeye for coded wire tags the CWT button is only pressed when an unclipped fish has a CWT This will place a Y in the Record Browsing Panel For these species the default CWT in the Record Browsing Panel is N If the CWT button is pressed by mistake simply press it again to toggle it to the off N position The LV and RV buttons are pressed with a fish has a Left Ventral Clip LV or a Right Ventral Clip RV If a fish has both a ventral clip and an adipose clip the user would first select the adipose clip by selecting the corresponding Species AD button see below Then the user would select the corresponding Ventral Clip button LV or RV When this is done the Clip Code in the Record Browsing Panel will display an AR Adipose Right Vent or AL Adipose Left Vent For example for a subyearling Chinook with an adipose clip and a left ventral clip the user would press CHO AD and then press the LV button The Clr Mark button clears Clip Code and CWT fields At sites where condition fish are examined for CWT the 1 c
10. for subyearling Chinook or 1 for yearling Chinook See Section VIII B 1 for a morphological diagram and methodology to distinguish between yearling and subyearling Chinook 74 Mark Type Mark Type N A j Click on the Mark Type drop down list and select the Ghia a amp type of external mark observed on a fish or group of Brand Cot EL Elastomer Tag L fish with identical mark types attributes Current E JER Elastomer Tag F valid mark types are rU Freeze Brand FL Floy Tag PH Photonic Tag Supplement Yi Visual Implant NOTES e The location of Elastomer tags are built into the Mark Type code EL or ER You do NOT need to enter a Tag Brand Location for Elastomer tags see below e Coded Wire tags and PIT tags are internal marks that are not included in this entry screen Recaptured PIT tagged fish are reported directly to PTAGIS and not entered into FPC32 net Brand Location Click on the Brand Loc drop down menu and select a location code for Freeze Brand and Photonic Tags 8nd Lou LNA only The location of Elastomer tags is now and Orientati DL Double Left designated in the Mark Type drop down list see rag Color LA Left Anterior above LD Left Dorsal e Field validation logic checks to see what mark ip Code I LE LeftEye type was entered An error message is ja peu displayed if the wrong location codes are used Morey ices for the wrong mark type Right Dorsal e An e
11. 0 Leng SO Sockeye Lamprey A te Pacific r Ammocoete Pacific Species list for LGR LGS and LMN Operc C ES _ Fin rie MP Macrop Pacific i aris 1RKD T1Parasite lDefnrmitw Species list for BON JDA and MCN incorporating lamprey juveniles Special Specie n a x L Miscellaneous Incidental Miscellaneous Incidente __ The Miscellaneous Incidental codes v Color Cc BM Bass Large Mouth aa BS Bass Small Mouth include several non salmonid incidental iment BL Bluegill Pumpkinseed fish codes This drop down menu options BH Bullhead f i cial Comment ICP Carp are listed alphabetical by incidental ICC Channel Cat species name NOT incidental species a Discoll Eye Hemm howls code Deformity _ Other CR Crappie Gn LD Dace Long Nosed ME SD Dace Speckled BK Killifish Banded 82 Incidental Incidental Species Incidental Incidental Species Code Name Code Name Bass Large Mouth Sculpin species Bass Small Mouth Shad Adult Bluegill and Pumpkinseed Shad Juvenile iberian Prawn S Stickleback 3 Spine Sturgeon Green CR _ Crappiespecies BU Sucker Bridgelip Dace Long Nose LU Sucker Largescale ench alleye PI _ Salmon Pink juv LW _ Whitefish Lake Notes e If you see a Bull Trout LT it is important that you minimize handling and return it to the river as soon as possible e f you encounter an Other Species OT be sure t
12. 1 Due to the collection of fish for NOAA marking LGR is the only transportation site that cannot enter EF Steelhead separately Unclipped steelhead should be entered as a single record at LGR 40 Subbatch Sample Code Page 1 FISH PASSAGE CENTER Date 4 16 2009 1 05 22 PM site LGS DAILY BATCH ATANK REPORT Batch 09106 from File L S09106 XML All Sample Start Date 4415 2009 Sample Start Hour O700 Sample End Date 4162009 Sample End Hour 0700 Number of Hours Sampled 24 4 Awg Total Discharge kets Avg Total Spill kets Total Turbine Discharge 0 kets Comments START USGS COLLECTION 47 HCH 1 1 WCH 1 17 HST 14 WST bypassed to researchers Condition and non condiion sample ALL ish bypassed Tank A Chinook 1 Chinook 0 Steelhead Coho Sockeye Total uc cwt cL uc fwr ct ry uc Jer cwr eL luc fewr ct ry uc fewr e Non Cond Sample Court ol of ol of of of of oF of of of of of of of of o o 0 Exam Desc Non cond ol ol ol of of of of of of of of oF of of of of of o o Non cond Descaled o of of of of of of of of of of of of of of of of o 0 Condition Sample Court 16 7 se of of of of s of of 4 of of of of af of ol 9 Exam Desc Condiion 16 7 so ol ol of of s of of al oF of of of af of 0 39 Condon Descaled ol of of of of of of of of of of of of of of of of ol J Total Sample Court 16 7 69 of of of of s of of 4 of of of of af ol o 9 Sample Morts
13. 57 85kefs Comments Tank A Tank B Tank Nore Combination Batch AB AP AS iM P AB JAF AS MF AB AP JAS MP LU AB JAP AS MP Lu Non Cond Sample Count 0 0 0 0 0 0 0 0 0 t4 0 0 0 14 0 i Condition Sample Count 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Sample Count 0 0 0 i i 0 0 1 14 0 1 0 0 14 0 1 0 Total Collection 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3500 0 0 25 0 0 0 00 350 0 0 0 25 0 0 0 Sample hlorts i i 0 0 0 0 0 0 0 i i 1 0 0 0 0 i i Facility Morts 0 0 0 0 0 0 0 0 i 0 i 0 0 0 0 0 0 0 Research Morts 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 i IX C FPC Weekly Validation The FPC validates two random batches from every week by comparing the hand logs with the electronic batch reports for any discrepancies For every batch with a discrepancy the FPC validates two additional batches for the same week The FPC then contacts the appropriate site via e mail requesting that necessary corrections be made and corrected batches be reposted See Section VII L for reposting instructions When reposting batches sites are required to include a description of what data have been changed and why FPC WILL NOT UPDATE BATCHES UNLESS PROPER DOCUMENTATION IS RECEIVED IX D FPC Validation Spreadsheets In addition to weekly validation the FPC will send all sites a set of validation spreadsheets generated form our SQL database This will be done weekly These spreadsheets should be checked against the data in your electronic batches If discre
14. Cwt OY ON None Batch 09139 Sequence 74 Species choose Species Code Special Species n a Miscellaneous Incidental Choose Species Code Mark Type AD Adipose Elas Code N A Color Code N A ii we Gen Comment e Special Comment Injury Head Cleve Operc _ Body _ Fin _ Pop Eye _ Fin Hemm _ PinkFin FinDiscol Eye Hemm Disease Fungus Columnaris BKD Parasite Deformity Other Length Enter the fork length of the fish in the Length field Length is a required field for condition fish except miscellaneous incidentals Length is measured to the nearest millimeter and can range from 1 to 999 mm FL no decimal place is allowed for length Code Range 61 to 250 61 to 250 61 to 350 61 to 200 61 to 250 pCO MP AP AB 70 to 250 AS 30075 FPC32 net has pre defined length ranges for each of the condition monitoring target species If a length is entered that is outside of this range the record can still be saved However when these data are imported into the Condition tab the suspect value will appear Red in the Data Review Grid This is intended to alert the user to an anomalous length It is up to the user to decide if this length is wrong or acceptable The table above provides the pre defined length ranges that are used for data validation for target species e fan anomalous length is identified for an individual record as part of the validation process delete this
15. Date Pl Pink Descaling The Descaling drop down list includes three choices for descaling including e Partial Descale for fish with descaling greater than 5 but less than 20 Descale for fish that are gt 20 descaled Descale Predator for fish that are descaled and have clear predator marks NOTE If Descale Pred is chosen at least one of the Predator check boxes should be checked see Predator Checkboxes below Descaling BRK Weight N A ralaton 1 Partial Descale 2 Descale 3 Descale Predator i Injury Weight Enter the weight of the fish in the Weight field Weight is NOT a mandatory field for condition fish Weight is measured in grams and can range from 0 1 to 999 9 grams Weights are accepted to the nearest tenth of a gram 0 to 199 CO 0to175 MP AP AS AB 0 to 20 FPC32 net has pre defined weight ranges for each of the condition monitoring target species If a weight is entered that is outside of this range the record can still be saved However when these data are imported into the Condition tab the suspect value will appear Red in the Data Review Grid This is intended to alert the user to an anomalous weight It is up to the user to decide if this weight is wrong or acceptable The table above provides the pre defined weight ranges that are used for data validation for each of the target species 84 Conditions site LGS Sub Batch 2 Species Code 5T TankjTrap A 6 None
16. Example 1 Flow and Spill Data Entry This user entered a Total Discharge of 200 a Turb Discharge of 199 and a Total Spill of 10 which prompted a Data Entry Error Message see above figure In this case the user must click on the OK button and makes the proper correction before the record can be saved eS VU FE he en Ape St E eS 0 as a7 Total Discharge 200 Turb Discharge 199 Total Spill kefs 10 Data Entry Error xj 11026 1 25 2011 0700 1 26 IX A 4 Data Reminders When entering data with FPC32 net there are some pieces of data that are entered once by the user and are automatically repeated for subsequent entries by the program If the user forgets to enter these pieces of data on the first entry it can become cumbersome to correct the data In order to avoid this FPC32 net has built in Data Reminders that alert users to enter these data when entering their initial records 110 Example 1 Entering a Tank At LGS LMN and MCN each time a user starts data entry for a new subbatch in Catch Detail a Data Reminder will appear reminding them to enter a Tank This is because Tank is repeated for all subsequent records until the subbatch is changed or the user changes to a new Tank This message Is also used in the Condition Touch Screen for these sites TankiTrap OA COB None v Age Code 1 0 Special Species n a IX B FPC32 net Validation Reports It is im
17. Framework Version 3 5 or better and Microsoft 2005 SQL Express edition software packages to be installed After you double click on the msi file you will be prompted to install NET Framework Version 3 5 if you don t already have it 6 Choose Yes 17 Te C TouchScreenSetup msi Ta SOGNO 1 windows Installer Paci tizi 4 366 KE s FPC32 NET This setup requires the NET Framework version 3 5 Please install the NET Framework and run this setup again The NET Framework can be obtained from the web Would you like to do this now 7 After selecting Yes your default internet browser will open to the URL http msdn microsoft com en us netframework aa569263 aspx e lf the dialog box asking you to choose Yes to install NET Framework does not appear manually open Internet Explorer and open the URL htto msdn microsoft com en us netiramework aa569263 aspx OR e Go to ftp ftp fpc org FPC32 net right click on the file dotnetfx35 exe and choose Save Target as and navigate to a temporary file on your hard drive and save the file Double click on the file to begin the installation of the NET framework OR e If you are installing this from a CD double click on the file dotnetfx35 exe from the CD directory and follow the installation procedure prompts using default prompts 8 From the http msdn microsoft com en us netframework aa569263 aspx website select the INSTALL IT NOW button NET Framework Downloads Download an
18. Incidentals Mark Recaptures by selecting the Summary Cond data entry tab For a detailed description of the Summary Cond tab and its functions see Section VII G below To incorporate condition sample data into the batch select the Summary Cond tab and click on the Promote All button When condition sample data are incorporated into the Catch Detail tab the sample counts for condition fish will appear in the Cond Sample Count column Note If all fish sampled were condition fish before promoting the user must first enter the sample rate for each sub batch that was entered using the touch screen The default sample rate s are listed but need to be checked and corrected when applicable To do this right click in the Sample Rate cell in the Condition SubBatches box at the top of the Summary Cond screen A in figure below This allows you to manually enter the sample rate for each individual sub batch that was entered into the touch screen Once this is done click on the Promote All button When condition sample data are incorporated into the Catch Detail tab the sample 38 counts for condition fish will appear in the grayed area of Catch Detail tab and the Cond Sample Count column of the data grid Red boxes in figure below Remote SMP Site Data Entry Program File Reports Summary Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site Catch Detad blue a
19. O 0 oy 0 7 oo OO OF OF OF Of Facility Morts o of ofl o 0 0 o of of of of of o Research Morts O o ol ol o ol o ol ol ol ol ol ol o PITTagMorts of of of of of of of of of of of of of of of of of o 0 Num Bypassed 300 360 2950 of of of of 250 ol of sof of of ol ol sf o ol 4450 Num Trucked ol of of of of of of of of of of of of of of of of o 0 NumBarged ol of of of of ol of of oF of of of of of oF of of ol J Descaiing Peig 00 oo oo oof oo oo 00 oof 00 oo oo 00 oof oof 00 00 oo ool 0 0 VII I 1 Manual Entry of Transportation Data 1 2 To create a new record in the Transportation data entry screen click on the New button to add a record Enter the Tank Species Clip CWT and Special Species code EF and FR combination for the record you wish to create Enter the Num Bypassed Num Trucked and or Num Barged for each new record These numbers are derived from the Total Collection minus total mortalities in the Daily Batch Tank Report All Sub batches e Inthe case when two day s samples are being transported together the Daily Batch Tank Report All Sub batches for each of these batches will have to be collectively entered in to the Transportation tab To validate these data re run the Daily Batch Tank Report All Sub batches and verify that the Num Bypassed Num Trucked and Num Barged are correct 4 z Remote SMP Site Data Entry Program A i oj x
20. Sub 1 0 005 200 0 5 0 005 v Sample Rate Sub 2 U U 20 5 0 0 05 Default Start Hour i700 End Hour Batch Import Directory C Users bchockley Desktop Same as Export f derai smp fpc org Custom Comment 1 Custom Comment 2 Custom Comment 3 Delete Old Batches from Database Delete Prev Year _ Delete Old Delete All New Batch End Day Today New Batch End Day Tomorrow x Import From Batch ancel on me i i Edit Save s Batch Delete Uploading New Batches Via HTTP Instead of e mail new batches can also be uploaded via the web To upload a new batch first you must navigate to http www fpc org smpupload SMP_Posting asp with your internet browser To log in enter Login guest and password niceguest The password authentication requires you to accept cookies but you can set Internet Explorer to accept just cookies from FPC if you wish To change the privacy settings in Internet Explorer go to Tools Internet Privacy then click on the Edit button under Web Sites Add the domain fpc org and select Always Allow o x hA p la Fie Ede View Faaks Tools Help x Google ME sexch Tm m d S Gshae Q A Ap Check gt o Sipin Favorites a Suggested Stes Earthlink Free Hotmail 9 coogle E Web Slice Gallery S
21. Summary Batch 12177 from File LGR12177_XML Samp Start Date G2e 2012 Sample Start Hour 0700 Gear Code GC Sample End Date 6 25 2012 Sample End Hour 0700 Sample Code 1 Number of Hours Sampled 24 Avg Total Discharge 83 48 kets Total Turbine Discharge 57 85 cfs Avg Total Spit 25 18 kets Comments CLIPPED TOTALS Chat hind Std Coho Sock Total Sample Count 1 192 8 0 0 201 Colechon Count 20 0 4600 0 200 0 0 0 0 0 5025 0 Num Exam for Desc 1 191 8 0 0 200 Num Descalked g 1 0 0 g Faty Morts 1 11 1 0 0 13 Sample Morts i 1 l i 0 1 Research Morts 0 0 0 0 0 0 PIT Tag Morts i g g 1 i g Num Bypassed 0 0 D 0 0 0 Num T ruched g 0 0 g i 0 Num Barged 24 9106 473 0 0 9603 Destalng Fag 0 00 O52 0 00 0 005 0 005 0 50 UNCLIPPED Chat Chad ChFry Std Coho CoFry Sock Pachm BrkAm Smam PacMac Lamun Total TOTALS Sample Count 3 354 2 4 1 0 0 14 0 0 1 0 389 Colection Count 75 0 9100 0 50 0 100 0 25 0 0 0 0 0 350 0 0 0 0 0 25 0 0 0 9725 0 Num Exam for Dese 2 363 0 1 0 0 0 0 0 0 0 370 Num Descaled 0 5 0 0 0 0 0 0 0 0 0 0 5 Fac ty Morts 1 20 U 0 1 i i lt 0 J i U Z1 Sample Morts 1 1 0 0 0 0 0 4 0 0 1 0 3 Research Morts 0 0 0 0 0 0 0 0 0 0 0 0 0 PIT Tag Morts 0 0 0 0 0 0 0 0 0 0 0 0 0 Num Bypassed 0 2 0 0 0 0 i 0 0 0 0 0 2 Num Trucked 0 0 0 0 0 0 0 0 0 0 0 0 0 Num Banged T3 15095 0 300 50 0 0 0 0 0 0 0 15518 Descaling Peig 0 00 Lad 0 00 0 00 0 00 1 35 IX B 2 Mark Recapture Report The Mark Recapture Report is the same as what has bee
22. Transportation Conditions Summary Cond Sub Batch 2 Species Code ST Tank Trap A 8 None Cwt OY ON None Sequence 74 Species Choose Species Code Special Species n a Miscellaneous Incidental Choose Species Code Mark Type AD Adipose Elas Code N A Color Code N A Descaling N A X Gen Comment Weight 37 7 Length 170 Session erd Fish tamprey gt Special Comment Injury _JHead _ Eye _ Operc Body _ Fin _ Pop Eye _ Fin Hemm _ PinkFin _ Fin Discol _ Eye Hemm Disease _ Fungus _ Columnaris BKD Parasite _ Deformity _ Other Injury Checkboxes There are five checkboxes found near the Injury label These include Head Eye Operc Body and Fin Check all of the boxes that apply for an injured fish If a fish has specific and or other injuries that site personnel want to record use the Special Comment field TIP To save time when entering a comment into the Special Comment field use predefined codes for particular conditions Also up to two comments can be entered into this field as long as they are separated by a semicolon NOTE Detailed definitions of each of these injuries are provided in a separate manual 86 Fish Condition Site LGS Sub Batch 2 Species Code 5 TankjTrap A 6 None Cwt OY ON None 74 Species Choose Species Code Special Species n a Miscellaneous Incidental Choose Species Code Elas Code N A Color Code N A Gen Comment
23. a new batch in the Catch tab depends on whether condition data were collected or not If condition data were collected the batch data from the condition sample are imported into the Main Form for editing and entering non condition data A detailed description of how to import condition data is provided in Section VII C 1 above If no condition data were collected a new batch record can be created from within the Catch tab of the Main Form A detailed description of how to create a new batch from within the Catch tab is provided in Section VII C 2 above eal Fay Remote SMP Site Data Entry Program ve Reports Bec 1 Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS New Batch E ng Da k T da y Batch 9736 New Batch Gear Code Choose Gear Code End Day Tomorrow Sample Code Choose Sample Code T Sample Hours l p P New Batch Total Discharge Turb Discharge Total Spill keFs End Day Yesterday Comments 1 Comments 2 10044 2 12 2010 0700 2 13 2010 0700 09156 6 4 2009 0700 6 5 2009 0700 131 91 105 72 0 10043 2 11 2010 0700 2 12 2010 0700 100 02 50 01 0O Save As Batch Import From Batch d 4 To edit an existing batch select the batch record in the data grid and choose Edit This allows the user to make changes via the data entry panel above the data grid After necessary changes are made choose Save Record 49 Below is
24. a table of the fields of data that are entered into the Catch tab along with the default settings for each field prior to data entry Following this table is a list of the fields and instructions of the types of data that should be entered into each field and how User defined based on whether End Date Today or End Date End date Tomorrow selected PH1 flow or Power house 1 flow default is set to zero Turbine Discharge PH2 flow Power house 2 flow default is set to zero Total Spill Total spill default is set to zero Comments are left blank Start Date Start date is calculated based on whether the user chose the End Date Today End Date Tomorrow or the End Date Yesterday button This is typically 24 hour prior to the end date Format MM DD YYYY Start Hour The default start hour is carried forward from the Settings screen Section III A If the listed Start Hour is incorrect enter the actual start hour in 24hr military time Numbers less than 0000 or greater than 2400 are restricted from entry here End Date End date is determined by the user when he she selects the End Date Today End Date Tomorrow or the End Date Yesterday button Format MM DDIYYYY End Hour The default end hour is carried forward from the Settings screen Section III A If the listed End Hour is incorrect enter the actual end hour in 24hr military time Numbers less than 0000 or greater than 2400 are restricted from entry here Trap Locatio
25. below If you wish to resend a batch you must document why you are changing the batch and submit 45 this documentation along with the batch preferably via FAX or email FPC WILL NOT UPDATE BATCHES UNLESS PROPER DOCUMENTATION IS RECEIVED You should also send a copy of this documentation to your project leader If FRC has already posted the original batch a reposted batch will not be allowed to overwrite the old batch FPC staff must first delete the old batch before data from the newly updated batch can be posted Call Chris McCarty 503 230 4582 if you have any questions about reposting Reposted batches must be sent via email When you send a batch for reposting attach it to an email sent to repost fpc org along with an explanation memo of why this batch is being resubmitted for reposting If you use Microsoft Exchange configure your mail client to send a return receipt back to you acknowledging that the mail arrived To edit a pre existing batch for reposting e Open the FPC32 net Main Form Under the Catch tab select the batch that needs editing selected records have an arrow next to them from the data grid by clicking on the record e Select the appropriate tab for the data that need to be edited e g Catch Detail Under that tab select the record that needs to be edited Choose the Edit button Make the appropriate changes to the record and then choose Save Record e f changes are made to individual condition records th
26. case a sanctuary net should be used to remove these fish only if it is possible with minimal disruption to other fish Chasing fish to capture them would increase stress to the fry and other fish in the holding tank so only net those individuals that can be easily captured with a sanctuary net If fry are anesthetized sites should work them up immediately but only for species identification and count purposes only Fry are not to be examined as part of the condition monitoring as this would mandate anesthetic and increase the time that they are handled In general sites should begin working up the smallest fish and fish that are deepest in anesthetic first and move to larger fish ILA The Fish Passage Center FPC The Fish Passage Center FPC provides current and historic data on salmon and steelhead passage in the main stem Snake and Columbia River Basins Data from the Smolt Monitoring Program SMP are intended to provide the information basis for federal state and tribal recommendations for fish passage in the Federal Columbia River Hydro electric System In addition to real time access to SMP data the FPC provides data about river conditions hatchery releases smolt migration and adult returns The FPC plans and implements the annual Smolt Monitoring Program SMP that provides daily information for in season management decisions The FPC also provides the agencies and tribes and the FPC Board of Directors with reservoir
27. default settings 14 Once the NET Framework 3 5 and the Microsoft SQL 2005 Express edition have been installed on your local computer open File Explorer and navigate back to C installfpc32 net Double click on the TouchScreenSetup3 msi or TouchScreenSetup3_lamprey msi file 19 15 Follow the prompts and accept all default settings The program will place an icon on your desktop called Fish Condition This is the FPC32 net program which includes the batch data entry and the fish condition touch screen NOTES e The NET Framework 3 5 and the Microsoft SQL 2005 Express edition only need to be downloaded and installed once e If you already have Windows XP with Service Pack 3 or a newer version of Windows you do not need to install Microsoft NET Framework 3 5 VI C Procedure to Install Newest Version of FPC32 net and Uninstall an Older Version 1 If you want to install a newer version of FPC32 net you must first uninstall the old version To uninstall the older version of FPC32 net choose Start Settings Control Panel al 8 Control Panel CJ Internet CJ My Documen File Edit Yiew Favorites Tools Help PLoS Prey re 7 3 Ss ikii 9 My Recent D gt Ss p Search Ke Folders S 9 My Pictures Address G Control Panel Windows Media Player a My Music Name Comments Accessibility Options Adjust your comput 3s Windows Messenger S iar canes Hardware Installs and trouble Add or Remo
28. each sampling day of the fish migration season This file is a text file formatted in xml notation External Mark Fish tags or marks which are readable through simple visual inspection Floy Tags Freeze Brands Elastomer Tags and Visual Implant tags are examples of External marks PIT tags and Coded Wire Tags are not considered external marks since they are not readable through simple visual inspection FPC32 net The current Windows version of the Fish Passage Center s Remote Site Data Entry Program for the Smolt Monitoring Project SMP This program can run under these operating systems Windows XP or Windows 7 Freeze Brands A form of external mark whereby a fish is branded with a mark using a super cold branding iron Ftp client A program installed on a computer that enables the user to download files from FTP sites on the Internet using File Transfer Protocol FTP Gas Bubble Trauma Monitoring Program Also referred to as GBT monitoring This is a monitoring program which examines fish after they pass through dams to monitor and measure biological effects from dissolved gas Incidental Catch Fish that are caught in the sample tanks at Remote SMP sites that are not one of the four main anadromous fish species whose passage is monitored in the Smolt Monitoring Program The target species for the SMP are Chinook Salmon Sockeye Salmon Coho Salmon Steelhead and juvenile lamprey both Pacific and Brook Lamprey Ju
29. er eo ree eet ar eT le eer er eee ee ee eo ee eee ee 99 BN ieee rae cece E A acetal 99 SUD ETE Ce PANE 99 So UEA CS E E T N EA EA EENE TE 96 VIILH 4 Fish Condition Touch Screen Tallies 99 Tank A and None and Tank B Tallies ooo ccesscssessessceseeseseseereees 99 Special Species Tallies ooo ccesccscssesecsccecesesecscceesearersceeeseaveresseeneeeens 99 Total Incidental Tally ooo cccscssssecscccescesesscescssesecsceececesavecseeecesaracecerees 99 Total Sampled Tally ccscssecsccscesscescesecescesecsceseassceeesvrseessasecesearaces 99 VIILH 5S Fish Condition Touch Screen Condition Species and Mark Type Buttons 100 Elastomer Location And Color ooo ccscscssssecsscsceseseseceseecsessceneecaveres 102 General Comments Sub Batch and Tank esscssesceseseseceseeee 102 Disease Predator Conditions ooo ceessssssecesesessesececeseetareseeeseeeaneres 103 Injury ConditionS ooo ce ceeescecesececeacsescesesececececeseseecaeatavseeseescceseneaeataeaee 103 Miscellaneous CONditions ooo cesesecsccsceseseseccscecesesececeececarececeeeecareres 104 BSC UN PEE EA at cat cc AEEA AE TATE ET ETEA EET 104 Predator Conditions 104 _ yj IX XI XII MarK TY DOS a eE E AEN GE weight and LEnNgtA ssori i Species and Special Species Validation IX A 1 Suspect Data Entry Alert Red Dot Example 1 Improper Gear Code Sample Code Sample Hours COmMbination asssssesenesereroernnrosrenernrerenrnnrennnn Example 2 Improper Species
30. is incorrect press the Clear Length button on the touch screen and then re enter the correct length 28 Press the appropriate Species Clip and Other Condition buttons e Once a species has been selected the species field will turn from yellow to white and the corresponding species code will appear For those sites with tanks the Please Enter Tank Trap warning will disappear once a tank is chosen Records cannot be saved until a tank is chosen lf a comment needs to be entered press the General Comment button and type the comment using the touch screen keyboard pop up The user can enter up to two comments or codes in this field separated by a semicolon Press Save New to save the individual fish record The Save New button also automatically starts a new record for the next fish e Follow steps 4 through 8 for each subsequent fish in the condition sample NOTE The scale will occasionally need to be zeroed between fish by pressing the Tare button 10 Once the last fish has been entered and the Save New button has been pushed push the Cancel button to end data entry VII B 2 Exporting Daily Fish Condition Records from the Wet Lab Computer Typically condition records are entered on the wet lab computer and the batch records are entered on a different computer in the office Therefore the daily condition records must be saved to an XML file on the wet lab computer which is then imported into the office computer 1 After co
31. or Unclipped If the site does not have a tank the species clip type tallies are displayed in the Tank A and None display Special Species Tallies B in figure below Each of the Special Species are tallied based on whether they were sampled in Tank A Tank B or None for those sites without tanks These fish are included in the Tank and None and Tank B tallies above Total Incidental Tally C in figure to below This tally is the total number of Miscellaneous Incidental Species that are entered via the touch screen Total Sampled Tally D in figure below This tally is the total number of fish Salmonids and Miscellaneous Incidentals that have been entered via the touch screen for a single batch 99 Tank A or None Clip Unclip Tally Tank A and None Clip Unclip T ally CH1 8 0 CH1 111 13 CHO 12 22 CHO 07 0 ST 3 2 ST 13 2 4 CO 0 2 co Oy 0 SO 1 7 4 So ol 0 AB OAS OF Tota 124 17 JAP 0 MP Total 24 31 Tank B Clip Unclip T ally A Tank B Clio Unclio Tally CHI 207 CHi 13 7 CHO 0 1 CHO 12 7 9 ST 447 7 ST 3i 3 CO Oy 1 CO 0 7 11 l SO 0 0 50 4 9 Total 64 11 IAB OAS 0 Special Species Tally i Tanke A Total 32 l 41 TotalHo 0 Special eg cee TotalEF 0 TotalHo 0 0 Oo tose S Toler of 1 o TotalLF 0 0 0 Total Incidental _ C Titel nacre 3 Total Sampled 216 D Total Sampled 131 Touch screen tallies for Touch screen tal
32. prer fll 2 708 la ST AD 137 4 242 z san El er Sia 10 a D a a Record Count 216 j Below is a table of the fields of data that are entered into the Conditions data entry tab along with the default settings for each field prior to data entry Following this table is a list of the fields and instructions of the types of data that should be entered into each field and how Field Name Default Settings Set in setting dialog Sequence For each subbatch sequence starts at 1 and continues sequentially When a new subbatch is started sequence starts over at 1 as the previous entry until the user changes the value as the previous entry until the user changes the value Species Code Default is none Species code is populated when the user chooses a value from the Species or Miscellaneous Incidental pull down menus Default is none This field is only used for Chinook Mark type Default is none Coded Wire Tag Default is none Special species Default is none code Elastomer code Default is none Default is none Default is none Weight Weight is a number field and is initially set to blank The user may enter a weight to the nearest 10th of a gram up to 100 grams Field Name Default Settings Length Length is a number field and is initially set to blank The user may enter a fork length to the nearest millimeter up to 1 000 millimeters Comment Fields General Comment and Special Comment are text fields Users
33. record is the best indicator of the selected record Once a batch has been selected you may navigate to the data entry tab that requires editing Catch Catch Detail Incidental Catch Mark Recaptures Transportation or Conditions Once you select the appropriate tab navigate to the record from the data grid and choose the record that requires editing You may activate a record for editing by selecting that record and pressing Edit or by double clicking on the record you wish to edit This populates the data entry panel at the top of the screen for the selected record You may now edit any of the fields in this data entry panel When you have completed making the necessary corrections to the record choose Save Record m Remote SMP Site Data Entry Program x File Reports Catch Catch Detail Incidental Catch Mark Recaptues Transportation Conditions Summary Cond 7 Sample Hours New Batch ate lay Yeskere Total Spill kes End Day erday 40044 2 12 2010 0700 2 13 2010 0700 09156 6 4 2009 0700 6 5 2009 0700 3 131 91 105 72 0 10043 2 11 2010 0700 2 12 2010 0700 100 02 50 01 0O Removing a Batch Record from the Local Database You may choose to delete batch records from the local database To do this select the batch record you with to delete from the Catch tab and choose Delete This will delete all records entered into the local computer database for that batch including condition incidental catch t
34. species age rearing disposition combination For Separator Morts use the following protocol Separator Mortalities should be entered as a separate sub batch For this sub batch enter a Sample Rate of 1 For each Species Age Clip CWT combination enter a Non Cond Sample Count of 0 and enter the number of mortalities in the Estimated Collection and the Facility Mortality fields This way the separator mortalities will be considered facility mortalities and included in the collection count but not in the sample count This field does not appear at the SMP trap sites NOTES e fa mortality is externally marked elastomer tagged or freeze branded the following steps must be taken o Enter the mort as a regular mortality o Enter a comment in the comment field Catch data entry tab describing the external mark of the mort Use the following format for the comment in the Catch data entry tab CH1 AD EL RE 3 mort This indicates that three of the clipped yearling Chinook that had a red elastomer tag on the left side were mortalities o Enter the marked mort as a marked live fish in the Mark Recaptures data entry tab e At BON and JDA all mortalities should be considered sample mortalities EXCEPT when it is clear that the fish has been dead for a significant period of time prior to entering the sample tank These fish should be entered as Facility Mortalities Assigning these mortalities as Facility Mortalities should be appro
35. standard sample rate was used you may enter this value directly into the Sample Rate field this value must be between 0 and 1 e The sample rate for a single sub batch is carried forward to the next record from the previous record until the sub batch number is changed by the user e Given this it is critical that you verify that the sample rate for each sub batch is correct before saving the first record of each sub batch Section VIII B provides detailed information for correcting the sample rate if you find that the wrong sample rate was entered for a sub batch 33 5 Enter Non Cond Sample Count Num Exam for descaling Num descaled Sample Morts Facility Morts Research Morts and PITTag Morts where appropriate e When sample code is NOT GB the field for Num Exam for Descaling will calculate automatically based on what is entered into the Non Cond Sample Count and Sample Morts fields for all species and special species combinations except for lamprey juveniles and fry using the following equation Num Exam for Descaling Non Cond Sample Count Sample Morts This assumes that 100 of non condition fish were examined for descaling If this is not the case you may over ride the calculated value of Num Exam for Descaling after entering the Non Cond Sample Count and Sample Morts e Descaling is not assessed on GBT fish lamprey juveniles or fry so the Num Exam for Descaling for these records is assumed to be 0 6 W
36. tag tagging files within 24 hours Transmit flow data facility mortalities percent descaling daily Notify FPC by phone whenever we cannot transmit data by 1400 hours on 123 weekdays and or critical weekends via FPC32 Advise and discuss problems with FPC when they occur 124 X A Generating and Printing Reports There are several different reports available with the FPC32 net remote data entry program see Section IX B for a detailed discussion of each To generate a report click on the Catch tab and select a batch Choose Reports and choose the report you want to generate from the drop down list Once a report is selected it may take a few moments for the report to open A report will open in a separate Report Viewing Window Ua Remote SMP Site Data Entry Program 10 x Mark Recaptures Transportation Conditions Summary Cond Incidental Catch Fish Condition art Hour Individual Fish Condition Report New Batch End Day Today Daily Batch Tank Report gt New Batch Special Species Daily Batch Tank p Choose Gear Code z End Day Tomorrow Lamprey Batch T ank i Sample Hours Total Discharge Turb Discharge Total Spill cis Comments 1 Comments 2 d Daily Summary Report IKN 4 1 of 2 gt Pi Gy 100 e Percent Zoom Next Previous Page Save Report As Print Page 1 FISH PASSAGE CENTER Date 2 2 2011 2 40 55 AM Site LGS Daily SMP S
37. the remote data entry sites BO2 JDA MCN LMN LGS and LGR once fish are in hand site personnel will use the FPC32 net fish condition touch screen to enter detailed condition data Section VIII H Trap sites LEW GRN WTB and RIS do not collect fish condition data and therefore will not use the condition touch screen A more detailed description of sample sizes target species and condition definitions with examples is provided in Section of this manual 2 Simultaneously all SMP site personnel will continue to tally information on non condition fish in the sample by species and clip code using existing counting stations These data will be recorded onto hand logs 3 Once sampling is completed detailed condition data will be transferred from the wet lab computer and imported into the office computer Section VII and VIII 4 Non condition data will be entered from hand logs using FPC32 net Section Vil and VIII Entry of non condition data begins with the Catch screen followed by the Catch Detail Incidental Catch and Mark Recaptures After non condition data have been entered into FPC32 net these data are validated Section IX 5 Condition data are then validated via the Conditions tab and or Individual Fish Condition Report After validation condition fish are incorporated into the overall batch via promotion from the Summary Cond tab 6 Where applicable after entering non condition data and promoting condition data
38. the user presses the appropriate Color Location button These buttons toggle on and off If a user selects the wrong button simply select the correct button or select the same button to remove that Elastomer tag location and tag color General Comments Sub batch Tank and Special Comments These buttons allow the user to enter the appropriate Sub batch Tank and Comments for each individual fish When the user selects Gen Comments a popup appears with the general comment text field and a keyboard Users are allowed to enter two comments per field separated by a semicolon Pressing Submit enters the comments into the database The Clr Gen Comments button clears the General Comments text field Submit Cancel Z x Y B N M B Space Space When the user begins entering data Sub batch defaults to 1 To change the Sub batch the user should push the Sub batch button Each time the Sub batch button is pressed the Sub batch number increases by 1 If the user presses the Sub batch button too many times the user can press the Clr Sub batch button to return the Sub batch number to 1 Where applicable the user selects the Tank A or Tank B button for the appropriate tank The Tank A and Tank B buttons toggle on and off Once Tank A or Tank B is selected for a single fish that tank is carried on to 102 subsequent fish until a different tank or sub batch is chosen by the user These Tank buttons are hidden fo
39. to use site specific database management tools e Main Line Voice 503 230 4099 Leave a message at the front desk for other questions not identified here Ill B Correspondence e Fax for hand logs 503 230 7559 e Main SMP E mail for batches and hand logs smp fpc org e Reposting E mail repost fpc org e GBT E mail smp fpc org e FTP site ftp fpc org Web site www fpc org Mailing Address 1827 NE 44th Ave Suite 240 Portland OR 97213 IlIl C SMP Remote Site Facilities and 2013 Dates e Bonneville Dam Powerhouse 1 BO1 Pacific States Marine Fisheries Commission 7 e Bonneville Dam Powerhouse 2 BO2 Pacific States Marine Fisheries Commission Grande Ronde River Trap GRN Oregon Dept of Fish and Wildlife Imnaha River Trap IMN Nez Perce Tribe John Day Dam JDA Pacific States Marine Fisheries Commission Lewiston Snake River Fish Trap LEW Idaho Dept of Fish and Game Little Goose Dam LGS Oregon Dept of Fish and Wildlife Lower Granite Dam LGR Washington Dept of Fish and Wildlife Lower Monumental Dam LMN Washington Dept of Fish and Wildlife McNary Dam MCN Washington Dept of Fish and Wildlife Rock Island Dam RIS Chelan Public Utility District Whitebird Salmon River Trap WTB idaho Dept of Fish and Game Smolt Monitoring Dates for 2013 March 12 October 31 March 5 May 26 March 5 May 26 April 2 Septe
40. used to clean the database The Delete All button deletes all of the records in the local database 10 Once you are finished with the Settings dialog box choose Save Setting to save the settings you have entered A dialog box appears prompting the user to restart the application for the setting changes to take effect Select Yes and the application will Exit VII B Entering Fish Condition Data Via the Touch Screen Species Length and Sub batch data are required in the Fish Condition touch screen in order for records to be saved successfully Weight is not required however some of the sites collecting fish condition data will collect weight as a part of the fish condition dataset except for incidental species By default the Sub batch number on the first record is set to 1 To change sub batch for the first record press the Sub batch button as many times as is necessary to get to the desired sub batch number If the sub batch number is incorrect choose Clr Sub batch The sub batch number is carried forward from the previous record until it is changed To enter a Tank press the appropriate Tank button either Tank A or Tank B The tank letter is carried forward to the next record from the previous record until it is changed by the user Sites that do not have separate tanks will not see a Tank button To enter a Species and Clip type choose the appropriate Species Clip button For example CH1 is for unclipped yearling Chinook CH1 AD i
41. where the first two digits correspond to the year e g 09 and the last three digits correspond to the sample end date in Julian Days This number was generated based on which Batch End Day button that was selected when initially opening the touch screen Date The Date field is where the batch end date is displayed The batch end date corresponds to which Batch End Day button was selected when initially opening the touch screen Sub batch This field is where the Sub batch number is displayed Up to 999 sub batches can be displayed in this field Sequence This field is where the Sequence number of the individual fish record is displayed Each sub batch starts with a sequence number of 1 and each record is incremented by one If a record is deleted that sequence number is deleted with it The deleted sequence number cannot be used again in the current sub batch VIILH 4 Fish Condition Touch Screen Tallies The Touch Screen Tallies are found in the upper right corner of the touch screen These are the total number of condition fish that have been sampled Condition fish are broken into several categories based on 1 Species 2 Clipped Unclipped 3 Tank 4 Special Species and 5 Incidentals Tank A and None and Tank B Tallies A in figure below Each of the target salmonid species are tallied based on whether they were sampled in Tank A or None or Tank B and whether they were Clipped AD RV LV AR AL
42. would like to get a better idea of what uncertain injuries may look like for juvenile lamprey To this effect USFWS asks that when an injury is uncertain crews at BON JDA and MCN are to enter that injury and then enter a UI into the Special Comments field as a way to flag it Crews are also asked to take a picture of uncertain injury if possible 133 134 135 THIS PAGE WAS INTENTIONALLY LEFT BLANK 136 FPC32 NET MANUAL ACKNOWLEDGEMENT FORM the undersigned acknowledge that have read the FPC32 net manual Name Please Print Signature Date Please copy this form and mail a completed and signed form to Fish Passage Center Attn Brandon Chockley _ 1827 NE 44 Ave Suite 240 m Portland OR 97213 Fax 503 230 7559 137
43. wt OY ON N A Special Species n a Gear Code GC Gatewell Collection System Mumiplier 3 20 U 02 Sample Rate Non Cond n Este Cond Sample Count Collection Collection Num exam ote ae Num Cond exam n Num Cond for descaled 1 Num descaled For descaled descaled Total Sample Count 0 Total Collection Total Exam 0 ae for descaled Descaled Sample Morts Facility Morts 0 J PITTag Morts Cond Sample Count To create a new record in the Catch Detail data entry tab choose New This activates the data entry panel at the top of the screen When the first record is 57 created Site and Batch are carried over from the Catch data entry tab Also default Sample Rate s Multiplier and Gear Code are carried over from the Settings screen The user should enter a separate detailed record for each Sub batch Tank where applicable Species Clip CWT and Special Species Code combination for the eight different target species of the SMP For Chinook separate Age Codes 1 or 0 should also be entered To edit a record select the record from the data entry grid at the bottom of the screen Each record has a sequence number to make the editing process easier for the user A selected record has an arrow on the left The user may scroll to the right to evaluate the data to make sure it is the correct record for editing If the data need to be edited either click on the re
44. 0 ws m HA 4 CHI JAD 30 142 PL IJA 5 CHO J _ u wl PL Ia 6 SO O 28 128 1A 7 CHO AD J 105 PL _ A 8 s Jao J J es aso o o ooo o o d G IA 9 sT aD 458 174 Aa 10 coj J J J 3 7 A 11 CHO 35 li IJA 12 CHI AD 3I 14 PL DS ija 13 CHO J 235 l ijA 14 CHO 102 l FH ila OTK CHO 3A f Disease Parasite Injuries Predator FU fungus HI head injury PB bird predator CO columnaris El eye injury PF fish predator KD BKD OP operculum injury PL lamprey predator PA parasite BI body injury PO other predator DE deformity Fl fin injury OD other disease Other Conditions Descaling PE popeye PD partial descaling 5 19 FH fin hemorrhage DS descaled 220 FP pink fin DP descaled by predator 220 with pred marks FD fin discoloration EH eye hemorrhage IX B 6 Daily Batch Tank Report The Daily Batch Tank Report is arranged in a matrix fashion similar to the hand logs for many of the sites The batch header information is found at the top of the report This report separates fish that were sampled as part of the condition sample from those that were sampled as part of the non condition sample There are four summary sections to the report including 1 Tank A 2 Tank B 3 Tank None a
45. 0 111 111 111 112 113 114 114 115 116 117 118 118 118 119 125 125 126 126 126 127 127 127 128 130 132 132 132 134 FPC32 net Manual Acknowledgement Form Vill I A Introduction to the SMP There are two primary goals of the Smolt Monitoring Program SMP 1 to provide real time data on juvenile fish migration to support in season fisheries management decisions and 2 to provide a long term time series of consistently collected data that allow for comparison of the impacts of changing river conditions among years particularly with respect to juvenile fish survival To achieve these goals there are three components to the SMP 1 PIT tag marking at hatcheries 2 PIT tag marking and monitoring at Snake River Basin traps and Rock Island Dam and 3 fish sampling at COE bypass facilities at Lower Snake River and Columbia River dams This Protocol addresses the data that are collected for the SMP at COE bypass facilities at Lower Snake River and Columbia River dams The sampling sites covered by this protocol include Lower Granite Dam LGR Little Goose Dam LGS Lower Monumental Dam LMN McNary Dam MCN John Day Dam JDA and Bonneville Dam BON For the remainder of the document these sampling sites will be referred to as Main stem Monitoring Sites This protocol is meant to compliment the Condition Sampling Protocol and provides overall guidelines for sampling and data to collect In past yea
46. 0 state the following Milestone V C Collect Fish for Examination Fish will be collected continuously during the monitoring period Fish will be examined during regular work hours 0800 1630 hrs unless large numbers of fish are entering the flume of the bypass trap in which case with would be removed and recorded as the appropriate sample days catch Fish will be delivered via the bypass elevator in a 12 x 4 x 3 5 aluminum holding talk which will be plumbed for continuous flow of river water Small samples of fish will be re anesthetized using a light buffered solution of MS 222 before being moved into the sampling trailer and placed in a full strength buffered solution of MS 222 Fish will be identified by species and examined for marks indicating hatchery origin and descaling Anesthetized with will recover in a separate holding tank and be released after they have recovered from anesthesia Milestone V D Collect Biological Data Collect biological data from salmonid migrants captured in the collection facility from 1 April to 31 August 2013 Data will be recorded daily to include by species total count adipose fin clipped unclipped status CWT presence absence other external or internal marks or tags smolt condition and descaling Milestone W B Transmit Data Transmit daily project operations flow data fish transport numbers facility mortalities percent descaling and average fork length data daily Ensure prompt transfer of d
47. 0 0 0 Research Mots 0 0 0 0 0 0 0 0 4 PIT Tag Mots 0 0 0 0 0 0 0 0 0 Descaling Peg C9 00 oof ool ool ool oof oof o0 00 i Tark amp Chinook 1 HO Chinook 1 LF Grand Tots cwr a INon Cond Sample Cort 2 oj 0 2 0 0 0 0 2 Exam Desc Non cond 2 0 0 2 0 0 0 0 2 Non cond Descaed 0 0 0 i 0 0 0 0 o Condition Sample Cart 0 0 0 0 0 0 0 0 0 Exam Desc Condition 0 0 o o0 0 0 0 0 Condition Descad 0 o 0 i 0 0 0 o Total Sampie Cart 2 0 0 2 0 0 0 0 2 Total Collector 100 ooj 00 1000 ooj 00 oof 00 s Sample Mots 0 0 0 0 0 0 0 0 0 Facdty Mots 0 ol 0 0 0 0 0 0 0 Research Mos 0 0 0 0 0 0 0 0 0 PIT Tag Mots 0 ol 0 0 0 0 0 0 Descaling Peg C9 ool ool oof ool oof ool oof oo 00 IX B 8 Lamprey Batch Tank Report The Lamprey Batch Tank Report is arranged in a similar fashion as the Daily Batch Tank Report However this report only summarizes data for lamprey juveniles separated by tank Tank A Tank B Tank None and Combined Running this report after entering promoting lamprey juveniles into the Catch Detail data entry tab is the best way to validate these data 117 Page 1 FISH PASSAGE CENTER Date 2 13 2013 8 29 27 AM Site LGR LAMPREY BATCH TANK REPORT Batch 121 77 from File LGR12177 XML Subbatch All Sample Start Date Be 2012 Sample Stari Hour 0700 sample End Date ee a Fd Sample End Hour 0700 Humber of Hours Sampled 24 Sample Code 1 Avg Total Discharge 33 48 kcis Avg Total Spl 25 18 kets Total Turbine Discharge
48. 06 107 IX A Automatic Data Validation and Alerts Throughout FPC32 net there are many automatic data validation process that occur for several fields when data are entered Many of these validation process result in Alert Error Messages that alert the user to a possible error in data entry It s important to note however that FPC32 net was designed to allow the user to save all data that are entered by the user regardless of whether the data were a were entered in error The details for many of the various data checking algorithms are explained in the detailed instructions for entering data in Section VIII However there are too many validation procedures throughout FPC32 net to guarantee that we have covered them all The Alert Error Messages fall into a couple of basic categories Below is a detailed explanation of the various Alert Error Messages that a user may encounter when entering data with FPC32 net followed by examples of each IX A 1 Suspect Data Entry Alert Red Dot When a user is entering a combination of data that are outside of the validation criteria a Red Dot will appear on the suspect data entry This alerts the user that something on the current data entry screen does not agree with the current validation criteria and warrants further investigation Example 1 Improper Gear Code Sample Code Sample Hours Combination When creating a record in the Catch tab this user entered a Gear Code of
49. 1 Navigate to the directory C Program Files x86 Fish Passage Center FishCondition3 Data Cc Program Files 86 Fish Passage Center FishCondition3 Date s Search Data Organize Include in library Share with Burn New folder FF ir Favorites Name Date modified Type Size BE Desktop brandcodes 11 4 2008 3 32PM XML Document 1 KB de Downloads brandloccodes 1 29 2009 3 10 PM XML Document 2 KB Recent Places brandorientationcodes 11 24 2008 1 09PM XML Document 1 KE brands 11 4 2008 3 32 PM AML Document 1 KE a Libraries chpcodes 12 9 2009 5 39 PM AML Document 1 KB Documents colorcodes 3 11 2009 3 50PM XML Document 1 KB d Music comments 11 2 2009 6 59 PM XML Document 1 KB i t Pictures condclipcodes 2 25 2009 2 58PM XML Document 1 KB H Videos condspecies 12 11 2008 5 16 PM XML Document 1 KB Select a file to DefaultSetup 2 11 2010 3 37 PM Tet Document 1 KE Preview Computer descalingcodes 12 11 2008 6 10 PM XML Document 1 KB elascodes 12 31 2008 1 35 PM XML Document 1 KB Giu Network fallbackcodes 12 11 2008 5 16PM XML Document 3 KB A fpcFish 2 1 20129 27 AM SQL Server Databa 2 176KB TE fpcFish_log 2 1 2012 9 27 AM SOL Server Databa 1 024 KB GearCodes 11 4 2008 3 32 PM AML Document 1 KB incidentalspecies 1 12 2011 7 51PM XML Document 9 KB markrecapspecies 11 4 2008 3 32PM XML Document 1 KB marktypes 12 18 2008 2 59PM XML Document 1 KB al micrincic
50. 2 1 1 0 0 4 UNCLIPPED TOTALS Chni Chn0 St Coho Sock PacAm BrkAm SmAm PacMac Total Num Sampled T 31 5 13 13 3 2 2 2 78 Descaling 20 or greater 0 0 0 1 1 2 Injury 1 1 0 i 1 0 0 2 7 Predation 0 2 0 0 0 0 0 0 0 2 Disease or Parasite 0 0 0 1 1 0 0 0 0 2 Total with conditions 1 3 0 2 2 i 0 0 2 11 IX B 5 Individual Fish Condition Report The Individual Fish Condition Report lists each fish that was sampled as part of the condition sample via the touch screen This report was intended for review of condition data in order to determine obvious errors from data entry e g anomalous lengths or weights incorrect species etc Condition fish are sorted by sub batch tank and sequence The condition data are divided into five groups 1 Disease Parasite 2 Injuries 3 Predator 4 Other Conditions and 5 Descaling The report uses codes for each of the conditions within these groupings A detailed listing of these codes and their meaning can be found below 114 Page 1 FISH PASSAGE CENTER Date 2 2 2012 1 38 54 PM Site MCN Individual Fish Condition Report Batch 11153 from File MCN11153 4ML Sub Special Elast Disease Parasie Injunes Predator Other Conds Descaling Batch Tank Seq Species Species Clip Loc Color CWT Weight Length FU CO KD IPA IDE OD HI El OP BI FI IPA PF PL PE FH FP FD EH PD Ds DP ya 1 cHo jao 58 j 1 A 2 CHO AD tej 100 iA 3 CH
51. 75 600 1 000 500 2 1800 6 300 300 500 Carry multipliers to 3 digits total then round 1 multiplier 3 will provide a sample rate to nearest 10 place that is correct For custom sample rates it may be necessary to carry to 6 digits beyond the decimal place if rate results in longer than 6 digits During periods of peak juvenile shad passage lower sample rated than needed to meet salmonid sample goals may be used to reduce handling and mortalities of shad Anesthetic Research funded by COE has shown that MS 222 can degrade relatively rapidly causing added stress to fish as a result Degradation was found to occur within a few weeks of mixing the dry powder with water In order to minimize stress to fish it is recommended that batches of MS 222 be mixed in quantities to assure that these mixed i e liquid batches will be used within 1 week to 2 weeks of being prepared It is unclear what impacts degradation will have on fish but to be conservative mix as small a batch as is practical to avoid impacts of anesthetic Sites should try to minimize the amount of time that fish are in anesthetic to approximately 15 minutes or less Fry Handling Protocol It is recommended that fry Chinook or Coho lt 60mm TL not be handled more than is necessary to collect information on the species and counts It is preferred that sites avoid anesthetizing fry by netting them directly from the sample tank if this is possible In this
52. A oN witb BL Length GR Green OR Orange Subb Sequ ue pod E ll a PU Purple OT Other OI Other Tag Color N A Clip Code N A Length AL Arison Left Ventral a AR Adipose Right Ventral P 1 LV Left Ventral Only NW No Clip with OWT RV Right Ventral Only Tally Total For each Sub batch Tank Species Code Age Code and Mark Type combination enter total number sampled non condition sample only If entering individual fish records e g individual freeze brand fish then enter 1 Promoted Summary Condition fish Individual Mark Recapture records from fish that were examined as part of the condition sample and entered with the Touch Screen and or edited through the Condition tab need to be Summarized and Promoted to the Mark Recaptures data entry tab This is done by using the Promote All button found in the Summary Cond Tab This button when selected summarizes the Mark Recaptures into Subbatch Tank Species Code Age Code and Mark Type groups and populates the Cond Count field in the Mark Recaptures data entry tab This field cannot be edited To change this Cond Count field individual records must be edited in the Conditions data entry tab data and re promoted via the Summary Cond data entry tab To learn more about the Summary Condition tab and the promotion of condition fish into the Mark Recaptures data entry tab see Section VIII G Vill D 2 Edit
53. Cond Sample Count 12 0 24 57 o Hj 4 o o o 4 0 o o 3J of o 169 Exam Desc Non cond 7 0 20 ST 0 21 0 0 0 0 3 0 o 60 5 0 0 114 Non cond Descaled 0 0 i 23 0 i 0 0 0 0 o o o l 0 0 5 Condition Sample Count 0 0 8 22 0 12 0 2 0 0 3 2 0 0l 0 4 0 1 54 Condition Descaled 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 Total Sample Count 12 0 32 fa 0 a3 41 2 0 0 4 6 0 0 0 13 0 1 223 Total Collection 600 0 1600 3950 ol 1650 2050 100 0 0 200 300 0 0 0 650 0 50 11150 Sample Morts 5 0 4 0 0 4 0 0 0 0 i 0 o u 4 0 0 18 Facility Morts 0 0 0 0 0 0 0 0 0 0 0 0 ol 0 0 0 0 0 Research Morts 0 D 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 PIT Tag Morts 0 0 0 0l 0 0 0 j 0 0 0 l 0 o o 0 0 0 0 Num Bypassed 585 0 1596 3950 0 1650 2046 100 of of 200 299 ol ol 64 Oo 50 11132 Num Tracked 0 of o o o o o o o o o of of of o of of o 0 Num Barged o 0 o o o o o o of o oo o o of o of of o 0 Descaling Peig 0 0 0 0 TA 29 0 0 3 0 0 0 00 0 0 0 0 ool oo oo 0 0 00 222 0 0 00 42 Lyons Ferry or Holdover yearling fall Chinook are included in the Chinook 1 columns depending on whether they were unclipped CWT or clipped IX B 7 Special Species Daily Batch Tank Report The Special Species Daily Batch Tank Report has all the same data and is arranged in a similar manner as the Daily Batch Tank Report However this report only summarizes Lyons Ferry and Holdover yearling fa
54. E CENTER Date 2 2 2012 1 34 14 PM site MCN Incidental Catch Report for Batch 11153 from File MCN11153 XML Species Description sample sample Code Count Mortalities BS Bass Small Mouth 1 0 PM Peamouth 1 0 PE Perch 1 0 SK Stickleback 1 1 Total Incidental Catch 4 Total Incidental Mortalities 1 REPORT COMPLETED NORMALLY 113 IX B 4 Fish Condition Report The Fish Condition Report is designed similarly to the Daily Summary Report This report summarizes the prevalence of each of the conditions from the condition sample Target salmonid species are split into three groups 1 Clipped 2 Unclipped and 3 Combined Each species represents a column in the report Each column has several rows of data These rows are as follows 1 Num Sampled 2 Descaling 20 or greater 3 Injury 4 Predation 5 Disease or Parasite and 6 Total With Conditions This report is NOT meant to be used for validation it is simply a summary of the conditions seen for a particular day s sample Condition fish with the Other Conditions Fin Hemm Pop Eye Pink Fin Fin Discol and Eye Hemm are NOT included in the Injury row Page 1 FISH PASSAGE CENTER Date 2 3 2012 3 45 40 PM Site MCN Conditions Report for Batch 11153 from Fie MCN11153 XML CLIPPED TOTALS Chni Chn St Coho Sock Total Num Sampled 21 24 6 0 5 56 Descaling 20 or greater 1 0 0 0 2 Injury 0 0 0 0 1 Predation a 1 0 0 0 3 Disease or Parasite 0 0 0 0 0 0 Total with conditions
55. FPC This will be done from a site several miles upriver that has standard phone access Milestone AF A Transmit of Project Data SMP personnel at the Salmon River Trap will transmit electronically PIT tag tagging files within 24 hours Transmit flow data facility mortalities percent descaling daily Notify FRC by phone whenever we cannot transmit data by 1400 hours on weekdays and or critical weekends via FPC32 Advise and discuss problems with FPC when they occur Milestone AC C Operate Trap for Collection of Data SMP personnel at the Snake River Trap will operate trap 5 nights week March 5 May 26 This will mean lowering the trap to begin the sample period at 6 00 pm on Sunday and cessation on Friday morning at 9 00 am Collect data on daily catch hatchery and wild population composition descaling recaptures of PIT tagged parr and average length by species Collect limited species data on incidental fish captured Monitor fish injury rates and mortality due to trapping and sampling procedures and modify as necessary to minimize injury and mortality rates Milestone AC D Transmit Collection Data SMP personnel at the Snake River Trap will electronically transmit salmonid collection data to FPC daily in a standard format determined by FPC This will be done from a site several miles upriver that has standard phone access Milestone AG A Transmit of Project Data SMP personnel at the Snake River Trap will transmit electronically PIT
56. Facility Morts section below e Do NOT enter a single mortality in more than one place This quantity is subtracted from Sample Count and the result is the Num Exam for Descaling e Mortalities are NOT examined for descaling NOTES e fa mortality is externally marked elastomer tagged or freeze branded the following steps must be taken o Enter the mort as a regular mortality o Enter a comment in the comment field Catch data entry tab describing the external mark of the mort Use the following format for the comment in the Catch data entry tab CH1 AD EL RE 3 mort This indicates that three of the clipped yearling Chinook that had a red elastomer tag on the left side were mortalities o Enter the marked mort as a marked live fish in the Mark Recaptures data entry tab e At BON and JDA all mortalities should be considered sample mortalities EXCEPT when it is clear that the fish has been dead for a significant period of time prior to entering the sample tank These fish 66 should be entered as Facility Mortalities Assigning these mortalities as Facility Mortalities should be approved by The Fish Passage Center Facility Morts In a sub batch enter the daily number of facility related mortalities e g transportation raceways separator morts for each species age rearing disposition For raceway and other non separator mortalities enter the number of mortalities directly into the Facility Morts field for the appropriate
57. File Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond TankiTrap CJA CJB jNone Batch 103138 Species Code Choose Species Code 7 Age Code l 10 Fin Clipped TA Cut OY ON None Special Species Choose Special Specie Num Bypassed Num Trucked Num Barged y 0 0 E 2 CH 1 Y o o 3 ST Y 0 0 z 4A CH 1 N 0 o zi SA CH 1 N Y 0 0 7 Delete E 6B CH 0 N 0 o a 7B CH 1 N 0 0 8B CH 1 N Y 0 0 wl 9B co N 0 o 0 0 A J08 iSf LY Record Count 19 VII I 2 Importing Data from Catch Detail for Transportation Data Entry Tab 1 To import the different Tank Species Age Clip CWT and Special Species EF and Fry combinations from the Catch Detail tab into the Transportation tab push the Import button e Only data in Catch Detail for that particular batch are imported This means that additional Tank Species Age Clip CWT and Special Species EF and Fry combinations from previous days may need to be entered when every other day transportation is in place e Only target salmonid species are imported from Catch Detail Lamprey juveniles are NOT to be entered into the Transportation tab e f condition data have not been promoted to Catch Detail these Tank Species Age Clip CWT and Special Species EF and Fry combinations may not be present e NOTE Eroded fin steelhead at LGR will be imported as Unclipped steelhead as LGR cann
58. Frc SMP FILE UPLOAD PAGE Fre SMP FILE UPLOAD PAGE X p A lam gt Pager Safety gt Toos SMOLT MONITORING PROGRAM FILE UPLOAD LOGIN PAGE LA NANA Ms Login guest Password jececceees lt Internet Uptions General Security Privacy Content Connections Programs Advanced Settings i gt Move the slider to select a privacy setting for the Internet zone Medium a ala ae acy policy Blocks third party cookies that use personally identifiable information without your implicit consent Restricts first party cookies that use personally identifiable information without implicit consent Web Sites To override cookie handling for individual Web sites click the Edit button Once you have logged in you will be directed to the SMP Batch Upload Page where you may upload up to 4 files at once 129 gt SMP FILE UPLOAD PAGE Windows Internet Explorer go Fre hittp www fpc org smpupload UploadFile asp File Edit View Favorites Tools t a 9g Ay Check gt r CG Signin doe Favortes Suggested Stes Earthlink Free Hotmail Y Google Web Slice Gallery SA Fre SMP FILE UPLOAD PAGE M Oo Pager Safety Toos K Fec SMP FILE UPLOAD PAGE Files already uploaded Refresh List You must select Refresh List after each upload LOG OUT Choose Browse to browse to the location of the XML file you w
59. IILB 2 Editing or Deleting Catch Detail Records You can only edit one record from the Catch Detail data entry tab at a time To edit a record you must first select the record from the data grid at the bottom of the screen by double clicking on the record The data from the selected record will populate the data entry panel and can be edited The arrow next to the record is the best indicator of the selected record At this point edits can be made to the record Once edits are made choose the Save Record button 68 To delete a record single click on the record you wish to delete and choose the Delete button If Delete is chosen you will get a prompt confirming that the record is to be deleted select Yes and that record will be removed from the local database VIII C Incidental Catch Tab The Incidental Catch tab is for recording daily sample counts and mortalities of incidental species i e non target species SMP target species are to be entered using the Catch Detail tab Since the data grid has so few columns there are no frozen fields in the Incidental Catch data entry tab Vill C 1 Definitions and Data Entry Before any data can be entered or edited in the Incidental Catch data entry tab the user must specify which batch they intend to add edit data to by selecting the corresponding batch in the Catch data entry tab Once a batch has been selected in the Catch tab you may navigate to the Incidental Catch tab Re
60. Imnaha and Grand Ronde The PIT tag is a small glass cylinder approximately 1mm in diameter x 10 mm in length which contains a small coil and chip which transmit a tiny 134 7 kHz radio signal when excited by a 134 7 kHz radio frequency signal Raceway Part of the juvenile bypass system at main stem dams that are transportation sites LMN LGS LGR and MCN Raceways are large water troughs where the fish are stored awaiting transportation by truck or barge after they have passed through the bypass system and or the sample tanks and recovery tanks Rearing disposition A fish is reared in the wild or it is reared in a hatchery or where it was reared is unknown Remote site The locations remote to FPC where SMP sampling takes place There are currently four remote sites that are fish traps in rivers and seven remote sites at main stem dams on the Snake and Columbia Rivers Repost revise and resend When an SMP batch of data is resent to FPC from a remote site for any reason it is called a repost Reasons for reposting a batch of data can vary widely and include such things as intermittent Internet email failure and erroneous data entry that was not picked up by the error checking algorithms Separator This is part of the juvenile bypass system at main stem dams which have a juvenile bypass system The separator is designed to let small fish pass through and keep mini jacks jacks and adults out of the juvenile bypa
61. KCFS or CFS units Total Discharge is obtained from the COE s Crohms System Daily Report or from online COE data reports such as Report 96 ftp fto nwd wc usace army mil pub project_ data A copy of this report should be sent to FPC along with your daily hand logs When daylight savings time begins and ends the period for calculating the Total Discharge will need to be adjusted For detailed instruction on these changes see Section VII M 1 above e On days when no sample is conducted sites are still expected to send in a batch with flow and spill information only using a Gear Code of 00 and a Sample Code of 3 PH 1 Flow or Turbine Discharge For all sites except BO2 and RIS PH1 Flow Turbine Discharge is the average hourly flow in Kcfs through the powerhouse during the sampling period of the batch For BO2 and RIS PH1 Flow is the average hourly 52 flow in Kcfs through Powerhouse 1 during the sampling period of the batch This field is mandatory for BO2 JDA MCN RIS LMN LGS and LGR o Obtain this daily number from the Army Corps of Engineers at the project o For BO2 obtain this value by subtracting BON 2 AVG DISCH from AVG TURB DISCH on the COE daily report This field is not displayed at WTB IMN LEW and GRN When daylight savings time begins and ends the period for calculating the PH1 Flow or Turbine Discharge will need to be adjusted For detailed instruction on these changes see Section VII M 1 above
62. Non Cond n Est al Num Total Samole Count U Total Colle pm Ee Sample Morts Ul Facility Morts Non Cond Sample Count Enter the number of non condition fish sampled This number includes sample mortalities e NEW If lamprey juveniles are sampled above the sample gate e g during separator clean out procedures removed from dewatering screens etc these individuals should be identified to species if possible and recorded in Catch Detail non condition sample count as a separate sub batch with a 100 sample rate gear code of GC and tank none Any mortalities associated with these lamprey should also be recorded If species ID is not possible use species code LU when recording in Catch Detail Est Collection FPC32 net automatically calculates this field by dividing Sample Rate into Sample Count This number is then rounded to the nearest hundredth place Using integer multipliers instead of sample rates will reduce any rounding errors that may appear in the calculated quantity The Estimated Collection is a calculated number and should not be edited EXCEPT when entering Separator Mortalities see Facility Morts below The Est Collection can only be overwritten if a sample rate of 100 is chosen Num Exam for Descal The Num Exam for Descal is a calculated field Num Exam Descal Sample Count Sample Morts This equation assumes that 100 of the non condition sample excluding samp
63. Panel l When the Exit Panel button is chosen a pop up menu will Exit appear This pop up menu has three options Exit Hide Screen and Return Choose Exit to exit the touch screen Hide and close the FPC32 net program Choose Hide Screen to Screen close the touch screen and return to the Main Form Choose Return to return to the touch screen for additional data entry Return New The New button allows the user to enter new records After pressing the New button the background panel turns white and the New button disappears indicating that data entry is allowed Once the first record has been entered the user must press the Save New button to save the record Save New The Save New button allows the user to save the current record and automatically starts a new record for the next fish The Sub batch and Tank of the previous record automatically appear for each new record You must correct the Sub batch and or Tank each time you switch Sub batches or Tanks Edit The Edit button allows the user to edit the record shown in the record browsing panel found in the lower left corner of the touch screen After pressing the Edit button the background panel turns white indicating that data entry is allowed Once editing is complete the user must press the Save button to save the changes to the record Delete The Delete button allows the user to delete the current record shown in the record browsing panel Next The Next butt
64. Smolt Monitoring Program Protocol and FPC32 net Data Entry Program User s Manual Manual Version 2013 Season Produced by The Fish Passage Center Last updated 2 21 2013 Table of Contents VI Smolt Monitoring Program SMP Protocol LA Introduction to the SMP I B Summary of Data to be Collected for the SMP II A The Fish Passage Center FPC II B Remote SMP Site Data Entry Program FPC32 net FPC Contacts and Correspondence III A Personnel to Contact for Technical Help III B Correspondence ll C SMP Remote Site Facilities and 2013 Dates Glossary Site by Site SMP Overview V A Bonneville Dam Powerhouse 1 V B Bonneville Dam Powerhouse 2 V C Grande Rhode River Trap V D Imnaha River Trap V E John Day Dam V F Lewiston Trap V G Little Goose Dam V J McNary Dam V K Rock Island Dam V L Whitebird Trap System Requirements and Program Installation VI A Hardware and Software 1 PC Details 2 Software _ii ONNNN DODO HRWWHWWWNNNNHNH VII Vill VI B Procedure to Install FPC32 net Program 16 VI C Procedure to Install Newest Version of FPC32 net and Uninstall an Older Version csssssescssesesesesssssssssssesesceveveverersesesees 20 VI D Procedure to Allow for Full Control for Windows 7 Operating SYSE een ee 21 Overview of FPC32 met Program 24 VILA Running the FPC32 net Program and Select Settings 24 VII B Entering Fish Condition Data via the
65. TA 82 gt 8 059 5 iO Een ee aa one eee E eae ey ee 82 KR a APOE P EE EE EE EE ese fo E S A ee ecaeiciese 82 gt 01 1 1 312 Cod ine aerate r en eT 82 Miscellaneous Incidental oo cccsssscssssccesssseccecsccsccessesseeeccassessceareeseces 82 Special Species Code aoa ccssssssescssescsccecsecacsecacsssscesssccarsecarseeaceeeaceaees 83 AF 4A 0 lt a ene a aoe Nieto An Nac 83 FOO arise croc e ten att dadesssentteaat ed deeb a 84 OF 5 0 sgl Code Seen en ee eee Ee eee ae eee ener ere eee eer 84 DESEAN a eee een en i etree 84 A211 en eee ce ee ne E 84 QD AE A ts E ENA EA I AEN EA EAN late 85 Predator CHECKDOXES oo cecssssssessssssscesssesscssessssestessssesteseasseesteatenesees 86 Injury CRECKDOXES ccccsnseenevescecsoscenescecossencxeovsenensenevscnerscnersonserereessneee 86 Disease CNeCKDOXES einean a 87 Other Conditions CHECKBOXES ooo ccessscsssscssescscesesscacsecacsseaceseaceness 87 General COMMON ornan n aai a aN 88 VIILF 2 Editing or Deleting Conditions Record S nnn 88 VIILG Summary Condition Tab ooo cccsccsccsssecscsscsceserscscescererscseeseeearersessees 89 VIILG 1 D FIITIONS os ccccccccsccsscessscsscessscsecsscecssssscacsessecaccassetsccacsetsecaceasseess 89 SSE bl t e fern eee ee On Ec ie ee eevee ee 90 Catch Detail Sub Batches ooo cccsccssssssscsssecsscsscesssesseecseessesteasseeees 90 Conditions SUD BatCne ooo ccccscsssssscecssesscessecssceceacssesseecseestesteaeseeaes 91 VIIIL H Fish Condition To
66. The Batch End Day Tomorrow button should only be used if a sample is being worked up early The Batch End Day Yesterday button should only be used if a sample is being worked up after being held for 24 hours Click on one of these buttons to create a new batch If a batch already exists in the local database with a particular Batch End Day a pushpin icon appears next to the corresponding Batch End Day button Batch Batch e End Day Today End Day Today Batch Batch End Day Tomorrow End Day Tomorrow Batch Batch End Day Yesterday End Day Yesterday Tank A and Hone ip Uncip Taly CH1 Or Oy ST of R Pin Ov 50 Totat Oy slalslsiolsik ool oloicic Takte scel S Specier Ebest Color CWT Gen Comment Spec Comment 1 razy Other cond Disease se GS san 1044 PAST AOLON pce ED sarea MME 7 8 9 CE Edit Delete D Exit i 2 3 0 Cancel in Export Touch screen for LGR LGS and LMN for 2013 27 Tank A or None Cin Uecie Ta Tank Trap B peger AP 5 Species Cip Code 7 8 9 CE New Edit Delete Wegh fT a a i enyi L athen _ i 2 3 o Meee ae Export S batch 1 Sequence 131 N Touch screen for BON JDA and MCN for 2013 incorporates condition monitoring for lamprey juveniles Note BON and JDA screen does not have Tank B Clip Unclip Tally i Elaz oku CWT Gen ommani Spec Comment Dithe
67. Touch Screen 26 ViL B 1 Brief Overview of Steps to Entering Fish Condition Data via the Fish Condition TOUCH Screen 26 Vil B 2 Exporting Daily Fish Condition Records from Wet Lab Lab COMPUte lr ccecssessssessssesessssessesesesseseseesssessesssenseeeseesseenseseee 29 VII C Importing a Batch from the Condition Sample or Creating a New BACA A eee ee 30 VII C 1 Importing Daily Fish Condition Records into FPC32 net MaN ONIN ae coats ei tcat aes ta eageae cee eat eee ake 31 Vil C 2 Creating a New Batch Record Directly from the FPC32 net Main Form iccccssssssssscscesesessssssssssesesesevevenensnseseseeen 32 VIIL D Entering Non Condition Fish Data Catch Detail 33 VILE Entering Incidental Catch Data ic ccessssesssssssseseseeseseseresesesenees 35 VILF Entering Mark Recapture Data ccsssssssssssssssesssssssseessrsesesensen 36 VIG Validating Condition Data ccsessesesssessssesesesessssesestesesenesesenses 37 VII H Promoting Condition Data into the Batch 38 VIII Entering Transportation Dattani cccsssssssssesesssssssssesssesessreesesnsen 40 VILI 1 Manual Entry of Transportation Data 41 VILI 2 Importing Data from Catch Detail For Transportation Data Entry Tab asaca aai 42 VIIJ Validating Bater i ecssssssssessssssssessssssssesssesesssessssessresesesereesesesenees 43 VILK End ANG Sendain aa eet cence a ean 44 VILL REDOSIS aiana ee ee eee 45 VIIM Special Situations i ccessssessssessssssesssseseseesesesesestesesesee
68. a batch has been selected in the Catch tab you may navigate to the Summary Cond data entry 89 tab Upon successful promotion the user will hear a prompt and see a red push pin icon in the upper right of their screen Remote SMP Site Data Entry Program i p ioj x Fie Reports Summary Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond a ae Site Condiions idl Sample Rate Editable Sub Batches Promote All 1 A o O0 1 JA o o o 4 A 3 o o0 ha e o o o hn A o o o a A o o o 2 o o o0 Me o o 0 2 B cH Y 135 1 0 oOo oO 2 B cH AD 362 0 0 oO 2 B mh bp b bo amp _ EEE Record Count 15 aaa Below if a list of the fields and instructions of the types of data that can be found in each field Site and Batch The Site and Batch fields cannot be edited Site is set in the Setting dialog box Batch is set when data entry for the batch is first started generally with the touch screen Site contains the three character code for the remote site entering The Batch number contains two digits for the year and three digits for the day of the year 1 366 YYDDD Catch Detail Sub Batches The current selected batch s sub batch numbers and associated sample rates are displayed in this small data grid at the top of the tab window These data are not editable It is for reference only During entry of the non condition s
69. act their system administrator The FPC data staff has only encountered this issue once but has determined that is usually means that there is a problem with Microsoft SQL 2005 Express If you encounter this problem please call Lynnae Sutton at FPC and she will walk you through a procedure to properly uninstall Microsoft SQL 2005 Express Uninstalling Microsoft SQL 2005 Express is not enough and will not remedy this problem VI D Procedure to Allow Full Control for Windows 7 Operating System When FPC32 net is installed on a machine with Windows 7 operating system the user may experience problems when trying to save new records These problems may occur each time FPC32 net is uninstalled and reinstalled The FPC staff has found that this is often a permissions issue that can affect whether SQL Express 21 database files can be written to by the current user If this is the case the user will typically get one of the following two error messages when trying to create a new batch The first error message appears to be an Unhandled Exception Error with a message that appears when the user attempts to save a new record This error message states something to the effect of C Program Files x86 Fish Passage Center FishCondition3 Data fpcFish dbf is read only A similar error may occur when starting the program after it is installed or reinstalled This error states Below is a brief description of how to remedy both these errors
70. al miles upriver that has standard phone access Milestone L A Transmit of Project Data SMP personnel at the Lower Grand Ronde Trap will transmit electronically PIT tag tagging files within 24 hours Transmit flow data facility mortalities percent descaling daily Notify FRC by phone whenever we cannot transmit data by 1400 hours on weekdays and or critical weekends via FPC32 Advise and discuss problems with FPC when they occur For the Salmon River Trap Work Elements AB and AF and Snake River Trap Work Elements AC and AG the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 states the following Milestone AB C Operate Trap for Collection of Data SMP personnel at the Salmon River Trap will operate trap 5 nights week March 5 May 26 This will mean lowering the trap to begin the sample period at 6 00 pm on Sunday and cessation on Friday morning at 9 00 am Collect data on daily catch hatchery and wild population composition descaling recaptures of PIT tagged parr and average length by species Collect limited species data on incidental fish captured Monitor fish injury rates and mortality due to trapping and sampling procedures and modify as necessary to minimize injury and mortality rates Milestone AB D Transmit Collection Data SMP personnel at the Salmon River Trap will electronically transmit salmonid collection data to FPC daily in a standard format determined by
71. alidated by printing or viewing Mark Recapture Summary Report To view this report chose Reports and select Mark Recapture If Condition Data include Mark Recapture data this validation step should be done prior to incorporating the condition data into the Mark Recaptures tab via promotion see Section VII H 36 File Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Tank Trap Age Code Grand Code f Tag Humber x Suppementa Code Non Cond Count Note Cond Count and Total Count will be filled in automatically when Condition Data are incorporated into the batch see Section VII H VILG Validating Condition Data Once the Mark Recaptures data have been entered the next step is to validate the condition data by selecting the Conditions data entry tab For a detailed description of data entry fields in the Conditions tab see Section VIII F below Validation of condition data can be done in two ways 1 Individual fish condition records can be viewed for validation directly from the data grid in the Conditions tab By clicking on the column header records can be sorted for easier viewing Sorting by multiple columns is also possible simply hold the Shift key while selecting the sequence of columns you wish to sort by If errors are found records can be edited directly from the Conditions tab see Section VIII F for more details on e
72. amples into Catch Detail the user entered a sample rate for each of the sub batches from which data were entered This data grid allows the user to see these non condition sub batches and their corresponding sample rates This is helpful because it indicates what sample rate s will be applied to the condition records upon promotion This data grid will only be populated if data for non condition fish were entered into Catch Detail it is otherwise blank 90 Conditions Sub Batches When entering condition data via the touch screen the user enters a sub batch number for each fish condition record The sub batch numbers for the condition fish are listed in this data grid along with the corresponding default sample rate that was assigned to these sub batches as entered in the Settings tab If data for non condition fish were entered into Catch Detail the sample rate s entered into Catch Detail will automatically overwrite these condition sample rates Note If all fish sampled were condition fish the user must check to make sure the default sample rates from the Settings tab were correct for this batch before promoting condition fish into the Catch Detail Incidental Catch and Mark Recap tabs To correct them right click in the Sample Rate cell in the Condition Sub Batches box at the top of the screen A in the figure below This allows you to manually enter the sample rate for that particular sub batch must be between 0 0 and 1 0 You wi
73. and Length are required for each individual fish condition record To edit a record double click on the record you wish to edit Each record has a sequence number to make the editing process easier for the user The data from the record then populate the data entry panel at the top of the screen and are editable Once necessary changes are made choose the Save button For ease of navigation the Tab Keys can be used to move between fields and Right and Left arrow keys can be used to move the cursor within a data field 80 Remote SMP Site Data Entry Program Catch Catch Deta Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Sub Batch 2 Species Code 5 Tank Trap A B None OY ON None sequence 74 Species Choose Species Code Special Species n a Miscellaneous Incidental Choose Species Code Mark Type AD Adipose Elas Code N A Color Code N A Descaling N A Gen Comment p Weight I F Length 170 Cancel Predator _ Bird Fish _ Lamprey Special Comment Injury Head Eye Operc C Body Fin C Pop Eye C Fin Hemm PinkFin C Fin Discol C Eye Hemm Disease Fungus Columnaris BKD Parasite _ Deformity _ Other an E ae SiH TVG i E S Dal Sequen 3 Edit Specie 1 1A O cHt aD LF 24 1 138 Edit 2 756 O cHi AD 18 5 129 b _ 2 738 fal ST AD 112 4 233 pea l Select All 2 728 ST AD 92 212 2 71B sT ao 73 1 201
74. and size A discussion of the morphological criteria can be found in Section VIII B 1 Chinook fry are age 0 Special Species Code There are four possible Special Species Codes that are to be recorded for particular target species of the SMP These four Special Species Codes correspond to salmonid juveniles only Below is a brief explanation of each of the Special Species Codes along with details as to which target species apply Eroded Fin EF for unmarked steelhead with eroded fins This Special Species Code is used to identify hatchery steelhead that are otherwise unmarked Lyons Ferry Yearling Fall Chinook LF for yearling fall Chinook that are known to have been reared at Lyons Ferry hatchery Holdover Fall Chinook HO for yearling fall Chinook that are identified as being holdovers based on size and morphology See Section VIII B 1 for detailed description of how to identify holdover fall Chinook Fry FR for Chinook and coho fry based on size 60mm or less See Section I B 3 below for fry handling protocol Clipping Marking and Tagging Data In order to aide in the identification of origin the SMP collects information on the clipping marking and or tagging of target salmonid species Below is a 2 brief explanation of the various clipping marking and tagging information that are to be collected for the SMP See Sections VIII B 1 and VIII D 1 for more information on these categories Fin Clips are recorded on all ta
75. anomalous length and leave the length field blank as opposed to attempting to correct the length Once the length is deleted a Length value Alert Button will flash Red next to the length field e If anomalous lengths are deleted from condition fish the field will have a value of 0 If your on site databases use these length data you will need to be sure to filter these O s out before calculating summary statistics 85 Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond LGS Sub Batch 2 Species Code 5 Tank Trap A 6 None Cwt OY ON None Batch 05139 Sequence 74 Species choose Species Code Special Species n a Miscellaneous Incidental Choose Species Code Mark Type AD Adipose Elas Code N A Color Code N A Descaling N A Gen Comment Weight I 7 Length 170 Predator 0O Bird Fish TO Special Comment Injury Head Eye JOperc Body Fin _ Pop Eye _ Fin Hemm PinkFin FinDiscol Eye Hemm Fungus Columnaris Jeko C Parasite C Deformity C Other Predator Checkboxes There are three checkboxes found near the Predator label These include Bird Fish and Lamprey If a fish has marking due to a predator or predators check all of the boxes that apply NOTE Detailed definitions of each of these predator conditions are provided in a separate manual Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures
76. antal 2 75 9011 1 20 DMA YML Naciumaent AKR W hos 28 items Aea 22 Right click on the file named fpcFish mdf and select Properties This will open the fpcFish Properties dialog box 3 Click on the Security tab and choose Users among the list of Group or User Names 4 Once Users has been selected look to see if Full Control has a check mark next to it in the list of Permissions for Users 5 If it does NOT select the Edit button Select Users again and check the Full Control box Click Apply and then OK 6 Navigate to the directory C Program Files x86 Fish Passage Center FishCondition3 Data 7 Right click on the file named fpcFish_log LDF and select Properties This will open a dialog box titled Data Properties 8 Click on the Security tab and choose Users among the list of Group or User Names 9 Once Users has been selected look to see if Full Control has a check mark next to it in the list of Permissions for Users 10 If it does NOT select the Edit button Select Users again and check the Full Control box Click Apply and then OK iy fpcFish Properties General Securty Detais Previous Versions Object name C Program Files amp 86 Fish Passage Center FishCc Group OF User names A SYSTEM R Administrators PANAQUEZ Administrators Users PANAQUE Users To change permissions click Edit Ede Permissions for Users low Deny Full control Modify Rea
77. apply NOTE Detailed definitions of each of these diseases are provided in a separate manual 87 Conditions Site LGS Sub Batch 2 Species Code 5T Tank Trap A 68 None Cwt OY ON None Batch 05138 Sequence 74 Species choose Species Code Special Species n a Miscellaneous Incidental Choose Species Code Mark Type AD Adipose Elas Code N A Color Code N A Descaling N A Gen Comment Weight 37 7 Length 170 Predator 0O Bird Fish Lamprey Special Comment General Comment Enter any specific comments about the fish that you may think are important and have not been entered into the Special Comment field TIP To save time when entering a comment into the General Comment field use predefined codes for particular conditions Also up to two comments can be entered into each comment field as long as they are separated by a semicolon Miscellaneous Incidental Choose Species Code T Mark Type AD Adipose Elas Code N A Color Code N A Descaling N A 7 Gen Comment Predator _ Bird _ Fish C Lamprey Special Comment Injury Head Eye Operc Body Fin _ Pop Eye _ Fin Hemm _ PinkFin _ Fin Discol Eye Hemm Disease Fungus Columnaris BKD Parasite Deformity Other VIILF 2 Editing or Deleting Condition Records To edit a single record in the Conditions data entry tab double click on the record you wish to edit The data entry panel top of
78. ar appears Select the date you want to create the batch for by double clicking on the End Date of the batch you want to create You are limited to creating batch for a date in the present year The batch for the End Date you selected is automatically created From the Catch tab choose Edit and begin entering the flow spill and other important information l0j x Fie R put Catch Catch Detai Incidental Catch ak Recaptures Transportation Conditions Summary Cond 10044 2 12 2010 0700 09156 6 4 2009 0700 10043 2 11 2010 0700 54 Editing Older Batches You can only edit one batch at a time Each batch is stored on the local computer in a database unless it has been deleted by the user If a batch has been deleted by the user it can be re imported into the database To do this from the Catch tab choose Import From Batch and navigate to the directory where the final XML files are being saved to the office computer hard drive Select the XML file for the batch you want to import and choose Open To edit a batch you must first select the Catch data entry tab from the FPC32 met Main Form Using the scroll bars in the data grid at the bottom of the page scroll down to the batch you want to edit Click on the record to highlight it The selected record will turn yellow and have an arrow next to it A batch is not selected until the record is selected by clicking the mouse even though it appears yellow The arrow next to the
79. ard 2 From within the Catch tab choose New Batch End Day Today to create a new batch with the EndDate matching today s date To create a new batch with the enddate matching tomorrow s date select New Batch End Day Tomorrow To create a new batch with the EndDate matching yesterday s date select New Batch End Day Yesterday Remote SMP Site Data Entry Program lt lo xi Fie Reports Batch Info _ SEE Incidental Catch Mark Recaptures lransoortal Condtions Summary Cond New Bat ch End Day Today New Batch End Day Tomorrow New Batch End Day Yesterday Inport From Batch Delete Record Count 1 e For all sites except LEW and WTB the batch number and site are automatically generated based on the information selected in the Settings dialog box and by the current date on your computer The 32 LEW and WTB sites will have to select the Site for which data are to be entered To do this select the Site from the Site Drop down menu located on the right hand side 3 From this point users should enter the remaining Catch data including 1 Start Time 2 End Time 3 Gear Code 4 Sample Code 5 Sample Hours 6 Total Discharge 7 Powerhouse 1 flow 8 Powerhouse 2 flow if applicable 9 Total Spill and 10 any Comments Comment 1 or Comment 2 that pertain the entire batch Note The start time end time and gear code will automatically set to the default values that were entered
80. ata Notify FPC by phone whenever we cannot transmit data by 1400 hours on weekdays and or critical weekends via FPC32 Advise and discuss problems with FPC when they occur 3 For Lower Granite Dam Work Elements Al and AJ Lower Monumental Dam Work Elements AO and AP and McNary Dam Work Elements AL and AM the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 state the following Milestone Al C Sample Fish Daily and Collect Data SMP personnel at Lower Granite Dam will sample fish daily throughout the monitoring season at the JMF Collect species condition and external mark detail from all sampled fish Collect detailed condition and length data from a subsample of the sample Count and identify all incidental species caught inthe samples Tally review enter into computer and transmit all data to FPC daily During periods of low fish collection August to October 24 hour daily samples may be held and sampled every other day 120 Milestone Al D Summarize and Verify All Sample Data on Days Collected at Lower Granite Dam Milestone AI E Project Operations and Flow Data Collection SMP personnel at Lower Granite Dam will collect record and verify daily USACOE project operations and flow data and facility fish mortality within the bypass collection system Milestone AJ A Transmission of Project Data SMP personnel at Lower Granite Dam will transmit daily Corps pr
81. ate s for the condition fish sub batch es are automatically assigned based on what was entered into Catch Detail If data were not entered into Catch Detail prior to promotion the sample rate s assigned to the condition fish sub batch es are the default sample rate s from the Settings screen If these sample rates were not used you must edit the sample rates for the condition sub batches prior to promotion The sample rate for each of the sub batches in the review panel is applied to the Cond Sample Count to produce the Estimated Cond Collection this field cannot be edited The program adds the Cond Sample Count and Non Cond Sample Count together to produce the Total Count After promoting the Total Collection is estimated This estimate is based on the Total Sample Count and the Sample Rate Depending on what Sample Rate is used there are times when this Total Collection is NOT equal to the sum of the Condition and Non Condition Collections due to rounding The program then adds the fields Num Examined for Descal and Num Cond Exam for Descal producing Total Num Exam for Descal The program also adds the Num Descaled and the Num Cond Descaled producing Total Num Descaled NOTE None of these Condition fields or TOTAL fields can be edited In order to change the numbers the individual fish records for condition fish must be edited using the Conditions data entry tab and re promoted via the Condition Summary data entry tab V
82. avscscescseavacsecessavavseeseseatavarecesees Sample Morts Fe AGI MORS cies oe head allen eae ui eaelseat lee atlee tv alee Research Morts MTD EE E inactadsafesctatnebaiedha Species Code _iv G 9 00 lt EE nat enon RE Rn i ea aI eer ar oC Onn eer eee 76 vo 18 8 8 21 011 A Code eee ene ee et ones eee eran ee 76 LE AE ie EEN EE AA E AAA SI AIEA E aati tae 76 Promoted Summary Condition FISH oo csssssssscecsscessscesesseccersceerere 76 Vill D 2 Editing or Deleting Mark Recapture Records 76 VIILE Transportation Tab oo ccccsccscsssssscssessccscesssssceressececarscsteatacseceearseeseess 77 VIILE 1 Definitions and Data Entry cicccscsssesesssssssssesessessensverssseenens 77 SU TVG ce eesti sess E E EA E EAE A TE A a AT 19 SPECIES COE E 19 SPEClal SPECIES COMES cccccsscseceocecnssecnersensrsescesoversencencrsenseseneesonernoes 19 SO PIENET A ETETE A TEE AE ETETEN 79 ia 66 oe Rear ee ea eres es E E oe an ee a Pee 19 O EES EA En ee re 19 NUM BYPaSSeO ooo sccsssscssessscssssccecsccersecacsesscsecsccarsecarsecacsetaceessceatscearece 79 AIID EEU e o E E AE E E E E T 19 INI B ARQ CG AEE 80 VIILE 2 Editing or Deleting Transportation Records 80 VIILF Conditions TAD occ ccccccssssscsscsccssceccssseeseeseeseeseesccaccacsacsarseesenseeseeaees 80 VIILF 1 Definitions and Data Entry iccscsssesessssssssssesessessenseverssseenees 80 SEZAO E 12 e Neer aS aR oa EE TENA
83. can put up to two comments into these fields with a semicolon separating the different comments Site and Batch The Site and Batch fields cannot be edited They are set in the Setting dialog box Site contains the three character code for the remote site entering the daily batch sub batch and fish condition data The batch number contains two digits for the year and three digits for the day of the year 1 366 YYDDD Sub Batch This is the sub batch number associated with each individual fish Each sub batch has an individual sample rate Sample rates for each sub batch are entered under the Catch Detail tab Tank At LGS LMN and MCN choose A or B to designate the correct tank Choose N A to designate fish from the separator Species Code Click on the Species Code drop down list and choose the appropriate Species Code from the list and the Species Code field will be populated Species Code is a required field and is intended to be used for target salmonid species For Chinook the species code includes the age of the individual sampled with CH1 for Chinook yearling and CHO for Chinook subyearling iyo Livs gt T LS i a yy Fe gers species ST Steelhead Soie js odes Cho CH1 Chinook Yearling CH1 Chinook Yearling le CHO Chinook Subyearling CHO Chinook Subyearling ST Steelhead ST Steelhead LU Coho sngth SO Sockeye AB Ammocoete Brook
84. ce 1 Tank Trap 4 B None sample Code Validation Alert Species Code CH Chinook Age Code 1 0 N cw OY N ONJA SpecialSpecies n a ll Collection System Y Multiplier BUR Sample Rate F l Cond Sample rates for each sub batch appear in the Sub batch Sub Sample Rate Lookup Table located in the upper right 2 corner of the Catch Detail tab If a mistake is made on the o sample rate for a subbatch it can be edited but only 3 i gt after all of the records for that subbatch have been 4 entered using the Catch Detail data entry tab see instructions below To Change a Sample Rate after all Catch Detail Records have been Entered single click on the sample rate in the Sub batch Sample Rate Lookup Table and it becomes editable Type in the correct sample rate and press the Enter key A dialog box appears asking if you want to change the sample rate Choose Yes 64 Gees SMP Site Data Entry Program File Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Sub Batch Sequence 2 Tank Trap B Batch 11027 Species Code CH Chinool Age Code Fin Clipped e N cat Y N CINA Special Species Gear Code ale l3 ate dle i neha z z Confirm Overwrite Sample Rate J xf Rate Sample Count Collection 3 ma i Nn ea i Do you want to ovewrite the sample rate ond for descaled Num des with 0 2 galed
85. ch Tank All Subbatches reports if they have not already been printed 3 Send the XML file to the FPC office via e mail to smp fpc org or uploading to the FPC website see Section X B Lag Remote SMP Site Data Entry Program Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond New Batch End Day Tomorrow Sample Code Choose Sample Code Sample Hours Total Discharge Turb Discharge Total Spill kcFs Comments 1 z Start End Trap Gear Sample Sample River Phouse Phouse T Batch Ser Gate hour End cae hour _locati code code hours flow 1 flo 2flow S Edit gt 09041 09069 3 9 2009 0700 3 10 2009 0700 GC 1 24 65 50 0 1 Save As Batch Confirm Overwrite Export File Import from Batch P Do you want to ovewrite the file tH C LGRO09041 xml Delete y 4 P T E Record Count 2 J 4 You must also send your hand logs to the Fish Passage Center via Fax to 503 230 7559 or e mail to smp fpc org e E mailed hand logs must be sent in PDF format They can be sent in the same e mail as the batch file i e XML file e f you cannot send the batches in on time be sure to call a member of the data center staff and let us know the reason and when you expect to get the batch in VILL Reposts If you need to revise and resend a batch you must edit the batch that was previously created see instructions for editing a batch in Section VIII
86. cord i e row of data to be edited and choose Edit or double click on the record to be edited The data from the record then populate the data entry panel at the top of the screen and are editable Once necessary changes are made choose Save For ease of navigation the Tab Keys can be used to move between fields and Right and Left arrow keys can be used to move the cursor within a data field Below is a table of the fields of data that are entered into the Catch Detail tab along with the default settings for each field prior to data entry Following this table is a list of the fields and instructions of the types of data that should be entered into each field and how Field Name Default Settings Set in setting dialog Sequence For each subbatch sequence starts at 1 and continues sequentially When a new subbatch is started sequence starts over at 1 Starts at 1 The value of subbatch for the next record is the same as the previous entry until the user changes the value Default is none The value of tank for the next record is the same as the previous entry until the user changes the value Species Code Default is none Species is a required field The value of species code is the same as the previous entry until the user changes the value Fin clipped Default is none Coded Wire Tag Default is none code Default is none The value of gear code is the same as the previous entry until the user changes the value Multiplier Defau
87. d Condition Sampling Protocol L B Summary of Data to be Collected for the SMP B 1 Target Species and Species Identification The target species for the SMP include juvenile salmonids and larval and juvenile lamprey Among the juvenile salmonids that are considered target species are 1 yearling age 1 and subyearling age 0 Chinook Oncorhynchus tshawytscha 2 Sockeye O nerka 3 Coho O kisutch and 4 Steelhead O mykiss Among the larval and juvenile lamprey that are considered target species are 1 pacific lamprey Lampetra tridentatus ammocoetes 2 pacific lamprey L tridentatus macropthalmia 3 brook lamprey Lampetra richardson ammocoete 3 and unknown ammocoete The above species make up the majority of the fish that are collected for the SMP However incidental species are also of interest Incidental species should also be identified and counted The Fish Passage Center recommends using the Columbia River Basin Juvenile Fish Field Guide published by Pacific States Marine Fisheries Commission for identifying juvenile fish and incidental species 1 B 2 Species Specific Data to Collect For each of the target species there are additional species specific data that are to be collected for the SMP Below is a brief explanation of each of these pieces of species specific data Age Code Age Code is used for Chinook only Chinook are to be assigned an age of 1 or 0 based on morphology
88. d 4 execute Read Write Special permissions For special permissions or advanced settings dick Advanced Advanced Leam about access control and pemnissions Data Properties Gener Shama Seoxty Previous Versons Catone Object name C Program Files amp 86 Fish Passage Center FishCc Group or user names gt SYSTEM ER Administrators PANAQUE2 Administrators S Users PANAQUE Users A Tr etadinet slar 4 yir To change pemissions click Edit Permissions for Users Full control Modify Read execute List folder contents Read Write For special permissions or advanced settings click Advanced eam about access o l emission __ Cancel 23 VILLA Running the FPC32 net Program and Select Settings 1 2 Once FPC32 net is installed an icon will appear on your desktop e awe Double click on the FishCondition icon on your computer desktop 4 This opens the program By default the program is set to open to the Batch Data Entry Screen and an icon is placed in your system tray lower right hand corner Right click on the FPC32 net Fish Condition icon in the system tray and choose Setting The setting dialog box appears From this dialog box you can choose whether you want the Fish Condition Touch Screen as the primary data entry screen Computers located in the wet lab should be set to have the Fish Condition Touch Screen as the primary data entry screen upon openi
89. d install the NET Framework SDKs readmes and more NET Framework 3 5 Service Pack 1 Download NET Framework 3 5 Service Pack 1 The NET Framework 3 5 Service Pack 1 SP1 delivers more controls a streamlined setup improved start up performance and powerful new graphics features for client development improved AJAX support and other improvements for Web development The NET Framework 3 5 SP1 delivers Performance increases between 20 45 for WPF based applications without having to change any code WCF improvements that give developers more control over the way they access data and services Streamlined installation experience for client applications Improvements in the area of data platform such as the ADO NET Entity Framework ADO NET Data Services and support for SQL Server 2008 s new features Download and install the NET Framework 3 5 SP1 Bootstrapper now Install it now 9 Once the NET Framework 3 5 installation program has completed downloading choose to Run the program 18 Internet Explorer Security Warning Do you want to run this software E Name dotnetfx35setup exe a Publisher Microsoft Corporation Ce re oto While files From the Internet can be useful this file type can potentially harm your computer Only run software from publishers you trust What s the risk 10 After you choose to Run the program the computer begins downloading and installing the NET Framework 3 5 software NOTE
90. d sample due to weather conditions GC 00 if no sample GC GC if bias sample 5 No sample biased sample due to equipment failure maintenance repair GC 00 if no sample GC GC if bias sample Incomplete sample no code provided cause explained in comments 8 No fish counts were entered for this sample period fish accumulated and were sampled at a later date 9 Incomplete biased sample counts are modified to estimate a normal sample 10 Multiple sample rates used throughout day not including sample rate for GBT sample gt 12 Sample of fish accumulated 2 or more days The sample code minus 10 is the number of days that fish accumulated before being sampled Sample Hours Enter the actual number of hours sampled rounded to the nearest 100th place e g 4 hours and 43 minutes 4 72 hours When daylight savings time begins and ends the sample hours will need to be adjusted The only time Sample Hours should be 224 is when Sample Code 2 12 For detailed instruction on these changes see Section VII M 1 above If Sample End Date is the same for two batches see Section VII M 2 above Total Discharge Total Discharge is the average hourly river flow Kcfs during the sampling period This value is mandatory for the SMP sites at dams BO2 JDA MCN RIS LMN LGS and LGR but it optional at the SMP trap sites GRN IMN LEW WTB If a trap site chooses to enter this value it is acceptable to use either
91. diting and instructions on group editing Individual condition can also be viewed via the Individual Fish Condition Report To validate condition data in this manner choose Reports and select the Individual Fish Condition Report from the drop down menu This report may be reviewed or printed for validation If errors are found records can be edited directly from the Conditions tab see Section VIII F for more details on editing 37 Hai Remote SMP Site Data Entry Program olx File Reports Incidental Catch fark Recaptures Transportation Conditions Site LGS SubBatch 1 Species Code CH1 Tank Trap A OB None Cwt CY N Batch 110426 Sequence 3 Species Choose Species Code Special Species n a Miscellaneous Incidental C Mark Type N A Elas Code N A Color Code N A Descaling N A ad Gen Comment Weight Length Cae Predator _ Bird Fish _ Lamprey Special Comment Injury Head Eye Operc Body Fin _ Pop Eye _ Fin Hemm PinkFin Fin Discol Eye Hemm Disease Fungus _ Columnaris BKD Ci Parasts 0O Deformity Other oo a a EE a i 1A z ST AD 46 235 i Select All Clear All 4 Record Count 2 VILH Promoting Condition Data into the Batch Once the Condition data have been validated and edited when applicable the next step is to incorporate condition sample data into the batch Catch Detail
92. e Preferences Locator Find Printer p Page Range CAI Number of copies 1 4 C Selection Cunent Page C Pages lo Ener Senar a sine pags ener ora tnos page range For example 5 12 oA Save Report As Clicking the Save Report As button opens a drop down list This drop down lists the formats that are available for saving the report These include 1 Adobe PDF 2 Comma Separated Value CSV 3 Excel XLS 4 Rich Text Format RTF 5 Image TIFF or 6 Web Archive html Once the user has chosen a format for the exported report a Save as dialog box appears From this dialog box navigate to where you want to save the report and name the report 100 acrobat PDF File CSV comma delimited Excel Rich Text Format TIFF file Web Archive 126 2x Save in O exportbatch 71 Fi 5 fie File name Yia k enan wis F Saveastype MakRepot xs Cancel Percent Zoom The Percent Zooms allows the user to select a zoom percentage to view report details on screen a tt n d Daily Summary Report of 2 gt bi S we im X B Sending SMP Data and Hand Logs to the FPC New batch data i e XML files are sent to the FPC in one of two ways 1 through e mail or 2 via http upload Copies of the hand logs must also be submitted via fax or e mail to the FPC Sending New Batches Via E mail Ne
93. e Reports and select Incidental Catch If Condition Data include incidental species this validation step should be done prior to incorporating the condition data into the Incidental Catch tab via promotion see Section VII H 35 Remote SMP Site Data Entry Program wl ih tira File Repot 1O x Incidental Catch Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cord Record Court 0 VII F Entering Mark Recapture Data Once the Incidental Catch data have been entered the next step is to enter the non condition Mark Recapture data by selecting the Mark Recaptures data entry tab For a detailed description of data entry fields in the Mark Recaptures tab see Section VIII D below To create a new record in Mark Recaptures click on the New button to add a record Only mark recapture data for non condition fish are entered into the Mark Recaptures tab at this point Mandatory data for each mark recapture record include 1 Tank where applicable 2 Species 3 Age 4 Mark Type 5 Tag Color 6 Clip Code chose N A if fish is unclipped and not CWT and 7 Tally Total Location for Elastomer Tags is part of the Mark Type code so Tag Brand Loc is NOT required for Elastomer Tags Tag Brand Loc Brand Code Brand Orientation Tag Number Supplemental Code and Length are NOT mandatory When the entry is complete choose Save Record Mark Recapture data should be v
94. e entered or edited in the Transportation data entry tab the user must specify which batch they intend to add edit data to by selecting the corresponding batch in the Catch data entry tab Once a batch has been selected in the Catch tab you may navigate to the Transportation data entry tab To create a new record in the Transportation data entry tab choose New This activates the data entry panel at the top of the screen When the first record is created Site and Batch are carried over from the Catch data entry tab The user should enter a separate detailed record for each Species Code Age Code Tank Special Species EF and FR only Clipped Unclipped and Coded Wire Tag combination FPC32 net allows users to import the different Species Code Age Code Tank Special Species EF and Fry Clipped Unclipped and CWT combinations from the Catch Detail tab into the Transportation tab This saves time as it is no longer necessary to enter every possible combination again However only data in Catch Detail for that particular batch are imported This means that additional Species Code Age Code Tank Special Species EF and Fry Clipped Unclipped and CWT combinations from previous days may need to be entered when every other day transportation is in place Furthermore if condition data have not been promoted to Catch Detail some Species Code Age Code Tank Special Species EF and Fry Clipped Unclipped and CWT combinations may not be prese
95. ecies fin clips marking data and detailed fish condition data including descaling Fish from the general population are obtained from a timed sub sample of fish diverted from the bypass channel during a 24 hour interval between 7am and 7am daily Examination of fish may occur throughout the 24 hour sample interval as necessary V F Lewiston Trap Operate a dipper trap on the lower Snake River at Lewiston for a 12 week The primary function of this site for SMP is to PIT tag out migrating smolts V G Little Goose Dam Smolts will be examined for various factors including species fin clips marking data and detailed fish condition data including descaling Fish from the general population are obtained from a timed sub sample of fish diverted from the bypass channel during a 24 hour interval between 7am and 7am daily Sample smolts from the collection for counts by species and clipped unclipped status Examine all unclipped yearling Chinook for coded wire tags GBT monitoring is conducted at this site See Gas Bubble Trauma Monitoring Protocol and GBT net Data Entry Program User s Manual 13 V H Lower Granite Dam Smolts will be examined for various factors including species fin clips marking data and detailed fish condition data including descaling Fish from the general population are obtained from a timed sub sample of fish diverted from the bypass channel during a 24 hour interval between 7am and 7am daily Sam
96. eee a LGS Sub Batches Batch Promote Aul 09133 RF re cee SCs ne Spec re Coo avg Nin re ire ubdal Tank Species Code CwT Elast Code wlenol ye Pop Eye Oped Meee co Uo ODO Yr Pp gt PP P pll ooo co Oo oO oOo Ow Oo O O O O D O O O amp OD O O ooo oO oO oO oO oO oO oO O Remote SMP Site Data Entry Program File atch Detail Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond LGS Sub Batch Sequence 3 TankiTrap OA OB O None Batch 11026 Species Code CH Chinook Age Code 1 C0 Subba Same Ma Fin Clipped Oy N Cut CY N ONJA Special Species m iin sas TEEMA Gear Code GC Gatewell Collection System Multiplier 5 20 0 0 2 v Sample Rate l 3 Non Cond 9 Est gt TEE Ca chr Collection e Num exam i en e 0 Num descaled Total Sample Count 0 Total Collection D Tein Ee 0 eatery 0 Facility Morts i yts 0 PITTag Morts 0 20 10 29 40 IMPORTANT The Cond Sample Count Num Cond Exam Num Cond Descaled and Cond Collection fields cannot be edited If an error was made in the fish condition records these data need to be edited in the Conditions tab and then re promoted from Summary Cond for edits to take effect VIII Entering Transportation Data Once the Condition sample data have been incorporated into the batch the next step is to enter the Transportation data via the Transportation tab For a detailed description
97. encoding 3 Communication Devices A A printer preferably a laser printer that understands PCL 4 or above to print the daily reports B Access to a Fax machine or e mail account to send daily hand logs to FPC C An appropriate modem or other types of communication hardware for other types of internet connections such as a cable modem DSL or ISDN D A thumb drive or other portable device for carrying batch files XML files from wet lab touch screen computer to data entry computer VLB Procedure to Install the FPC32 net Program including the fish Condition touch screen 1 To install this program you will need to have Windows XP or a newer version of Windows NOTE If you already have Windows XP with Service Pack 3 or a more recent version of Windows you do not need to install Microsoft NET Framework 3 5 or higher 2 Within File Explorer make a temporary directory to save the installation program files In this procedure this directory is referred to as c installfpc32net 16 3 Open Internet Explorer and go to ftp ftp fpc org FPC32 net Right click on setup exe and choose Save Target As Navigate to c installfpc32net and save this file to this directory e LGR LGS LMN RIS WTB LEW and GRN Right click on TouchScreenSetup3 msi and choose Save Target As Navigate to c installfpc32net and save this file to this directory e BON JDA MCN Right click on TouchScreenSetup3_lamprey msi and choo
98. entries in this row include 1 Fungus 2 Columnaris 3 BKD 4 Parasite 5 Deformity and 6 Other Weight The Weight field holds the weight grams of the fish that was entered via the scale Even though Weight is NOT a Required Field for condition fish the text box for Weight will appear yellow when a new record is created until a Weight is entered by the user There can be 5 digits in the weight field including three numbers before the decimal point a decimal point and one number after the decimal point The weight field can have data values in the hundreds up to 999 9 grams Weight is not mandatory at BO2 or JDA Length The Length field holds the length millimeters of the fish which was entered via the number pad Length is a Required Field for condition fish Therefore the text box for Length will appear yellow when a new record is created until a Length is entered by the user There can be 3 digits in the length field There are no decimals in this field Length can have data values in the hundreds up to 999 mm Length is mandatory at all sites where condition data are collected The Bottom Section C in above figure of the Record Browsing Panel displays the Site Batch Date S batch and Sequence number Site This site field is where the Site is displayed Site was chosen in the Settings dialog box 98 Batch The Batch field is where the Batch number is displayed This batch number is a five digit number
99. es found in the sample Only required for lamprey adults LP CK and LR Promoted Summary Condition Fish Individual incidental species that were examined as part of the condition sample and entered with the Touch Screen and or edited through the Condition tab need to be Summarized and Promoted to the Incidental Catch data entry tab 71 This is done by using the Promote All button found in the Summary Cond Tab This button when selected summarizes the incidental condition fish by Species Subbatch groups and populates the total sample count for each incidental fish species under the field Cond Count This field cannot be edited To change this Cond Count field individual records must be edited in the Conditions data entry tab and re promoted via the Summary Cond data entry tab To learn more about the Summary Condition tab and the promotion of condition fish into the Incidental Catch data entry tab see Section VIII G VIIL C 2 Editing or Deleting Incidental Catch Records You can only edit one record from the Incidental Catch data entry tab at a time To edit a record you must first select the record from the data grid at the bottom of the screen by either double clicking on the record The selected record automatically populate the data entry panel The arrow next to the record is the best indicator of the selected record At this point edits can be made to the record Once edits are made choose the Save b
100. ese changes must be re promoted into the Catch Detail Incidental and Mark Recap records To re promote choose the Summary Condition tab and choose Promote All to rewrite or change the daily batch condition records in the Catch Detail Incidental and Mark Recap tables e Once you have made all the required changes select the Catch tab and press the Save As Batch button A dialog box will prompt you to overwrite the previous batch record Choose Yes This creates a new daily batch XML file for the day you have edited e Send the changed batch along with the appropriate documentation to the FPC via email to repost fpc org see above for further documentation VII M Special Situations VILM 1 Daylight Savings Time Transitions e Inthe Spring the start and end times will be recorded normally but on the day when daylight savings time begins the sampling hours will be 1 hour less and the flows averaged for 23 hours e In the Fall the start and end times will be recorded normally but on the day when daylight savings time ends the sampling hours will be 1 hour more and the flows averaged for 25 hours 46 VII M 2 Sampling End Date is the Same for Two Batches Each batch must have a unique batch number and end date If sampling ends on the same day as the previous batch the batch number must be that of the following day Batch numbers are created automatically From the FPC32 net Main Form you can create batches and hence a batch
101. ferent sample rate This prompted a Red Dot and a Sample Code Validation Alert to alert the user of the suspect combination In this case the user should continue data entry for this record and save the record Then before entering the next record the user should navigate back to the Catch tab and edit Sample Code to 10 Site LGE Sub Batch 2 Sequence 1 TankjTrap A 6 Mone Batch 113 Species Code CH Chinook Age Code gaji 90 Fin dipped Y ON Cwt OY CON N A Special Species ma Gear Code GC Gatewell Colection System Non Cond 0 Est mle fa smh eB lo IX A 2 Suspect Data Eniry Alert Red Field in Data Review Grid FPC32 net has validation on Length and Weight data for condition fish If a user enters a Length or Weight that is outside of a pre determined range for that species the field for that entry will appear Red in the Data Review Grid of the Condition tab For details on these length and weight ranges see Section VII F 1 Weight and Section VIII F 1 Length above These alerts are intended to alert the user to anomalous Length and Weight estimates that warrant review It is up to the user to keep or delete these anomalous estimates FPC does not recommend changing anomalous Length or Weight estimates If an anomalous Length or Weight is entered for an individual FPC recommends simply deleting the anomalous estimate Example 1 Anomalous Length Entry When creating a record
102. for a condition fish the user entered a Length of 500 for a yearling Chinook This length is outside the expected range for yearling Chinook fork lengths see Section VIII F 1 Length which prompted this field to be Red in the Data Review Grid 109 Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond site LGS Sub Batch Species Code LH TankiTrap 4 B _ None Cwt Batch 11032 Sequence Species choose Species Code v Special Species n a Miscellaneous Incidental Choose Species Code Mark Type AD Adipose Elas Code M A Color Code N A Descaling N A Gan Carement Weight 20 6 Length Predator _ Bird 0O Fish Lamprey Special Comment e Head Eye Jope sre Body C Fin Pe op Eye Fin Hermin C Pink Fin _ Fin Disco jEye Hemm t C Fungus _ Columnaris _ BKD C Parasite E peformty a Other IX A 3 Data Entry Error Message For SMP sites at the dams entering flow and spill data is mandatory for each batch When entering flow and spill data using the Catch tab the sum of Turbine Discharge or PH1 and PH2 Discharge for BO2 and RIS and Total Spill must not exceed Total Discharge If a user enters data that violate this rule a Data Entry Error Screen will appear informing the user that the flow and spill data are in violation of this rule In this case the user must make the proper correction before these data can be saved
103. from Bonneville Dam where they are unloaded back into the river The transportation program was created to attempt to mitigate the negative health effects on anadromous fish of in river passage through the hydro system Trap Facilities This refers collectively to the remote site SMP river traps of LEW WTB IMN and GRN Validation process In terms of the SMP there are multiple levels of the validation process First of all a statistical quality control process is applied to the submitted electronic batches and hand logs and any discrepancies and possible errors are brought to the attention of the remote site that submitted the batch for possible correction by the remote site Secondly each week during fish migration season a spreadsheet containing all of the data submitted year to date from a remote site is sent to the remote site to ensure that what FPC has in its database matches what the remote site has in its database Wire Tag A wire tag can be a coded wire tag CWT or a blank wire tag NOTE FISH CONDITION terminology is located in a separate manual 11 Migration year 2013 is the fifth season when all SMP sites will be using FPC32 net for data entry A detailed site by site overview is provided below which outlines what type s of data are being collected Also below is a brief step by step outline of how the various types of data will be entered and processed using the FPC32 net data entry program 1 For
104. hanges the value Species code Default is set to Chinook CH The value of species code for the next record is the same as the previous entry until the user changes the value Species code is a required field Age code Default is set to 1 The value of age code for the next record is the same as the previous entry until the user changes the value Field Name Default Settings Special species Default is none code All number fields All number fields are initially set to zero These fields include number bypassed number trucked number barged Tank At LGS LMN and MCN choose A or B to designate the correct tank Choose N A to designate fish from the separator The Tank toggle has been turned off for LGR Species Code Click on the Species Code drop down listand SPecies Code _ FH Chinook i choose the appropriate species code from the aN nno Nok CO Coho 0 Num SO Sockeye jar SI Steemhead Special Species Code Click on the Special Species drop down list and choose one of the following codes e FR and EF See Section VIII B 1 for a detailed discussion of each of these Special Species Codes e Due to NOAA sampling at LGR entering separate records for Eroded Fin EF steelhead is not possible The only Special Species Code to be used at LGR is FR for Fry Age Code Age Code is used for Chinook only Choose 0 for subyearlings and 1 for yearling
105. he fields and instructions of the types of data that should be entered into each field and how Field Name Default Settings Set in setting dialog Computed based on system date Sequence For each batch the first incidental catch record sequence starts at 1 and continues sequentially All number fields are initially set to zero These fields include sample count condition count total count and sample mortalities Species Code Click on the Species Code drop down list within the cell and select the appropriate species and species code The list is sorted alphabetically by Incidental Species Name NOT Incidental Species Code Species Code 61 Chinook Adult Al Chinook Adult al 0 Cond A5 Chinook Adult Hatchery 43 Chinook Adult Wild J1 Chinook Jack J5 Chinook Jack Hatchery 1J4 Chinook Jack Wild 40 Chinook Minijack J3 Chinook Minijack Hatchery J2 Chinook Minijack Wild CM Chiselmouth 70 Code Name Code Name BH Bullhead PI Salmon Pink uv Notes e fyou see a Bull Trout LT it is important that you minimize handling and return it to the river as soon as possible e f you enter Other Species OT be sure to indicate what this was in your comment s for the batch Catch Tab Sample Count Enter the number of incidental fish of each particular Species Code found in the sample tank Sample Morts Enter the number of incidental mortaliti
106. he left most columns are frozen to help the user identify the row as they scroll to the right Column headers can also be resized and can be wrapped To resize a column header click and drag a column separator the line between two columns Maximizing the data entry window allows the user to see more of the column headers Data cannot be entered or edited directly from the data grid To hide the Main Form click on the X in the upper right hand corner The program remains running in the background and can be re opened by right clicking on the FPC32 net icon in the system tray To exit the FPC32 net program from the Main Form choose File Exit f the Main Form is hidden you may exit the FPC32 net program by right clicking on the FPC32 net icon in the system tray and choosing Exit VIILA Catch Tab In the lower data grid the Batch field is frozen on the left to help the user identify the row as they scroll to the right VIILA 1 Definitions and Data Entry To view the Catch tab of the FPC32 net Main Form either double click on the FPC32 net icon on your desktop if program not already running or right click on 48 the FPC32 net icon in the system tray and choose Open Main Form The Main Form window opens with the Catch tab forward Upon being opened the Catch tab displays the batch records that are in the temporary database in the data grid near the bottom Each batch is represented by a single row in this data grid Creating
107. hen the entry is complete choose Save New The Save New button also automatically starts a new record for this batch 7 Follow steps 4 through 6 for each subsequent record to be entered 8 Once the last record has been entered and the Save New button has been pushed push the Cancel button to end data entry for this screen 9 Once all non condition records have been entered these data should be validated from the hand logs by printing or viewing the Daily Batch Tank Report and or the Lamprey Batch Tank Report To view these reports chose Reports and select Daily Batch Tank Report and or Lamprey Batch Tank Report A separate report can be generated for each sub batch that was entered It s best to do this level of validation prior to incorporating the condition data into the Catch Detail tab via promotion see Section VII H Note There are several fields on the Catch Detail tab that are inactive i e grayed out These are fields that are either calculated e g Est Collection Cond Collection or are incorporated into the batch upon promotion of the Condition Data e g Cond Sample Count Num Cond Exam for Descaling etc 34 Ej Remote SMP Site Data Entry Program loj xj File Reports Catch Detail Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch Sequence 3 Tank Trap JA JB _ None a Batch 1102 Species Code CH Chinool Age Code 1 O
108. ider eyes smaller nose more sharp than yearling Spring Summer Chinook football shaped Spring Summer Chinook yearling Caudal fin forked usually edged in black Parr marks large vertical oblong shapes centered on lateral line and wider than interspaces Anal fin rays short wedge shapes usually not pigmented Large spots on back Body narrower eyes larger nose more rounded than subyearling fall Chinook Fin Clipped Choose Y for those fish that have a fin clip either an adipose or ventral fin clipped Choose N for Fin Clipped O Y N those fish that do not have a fin clip CWT LGR LGS LMN WTB LEW and GRN are to examine all unclipped Chinook Subyearling and SE yearlings coho and sockeye for coded wire Ont OY ON ONA tags For unclipped Chinook coho and sockeye choose Y for those with CWT and N for those without CWT If fish were not examined for CWT than choose N A The default for clipped Chinook coho and sockeye at these sites is N A The default for RIS MCN JDA and BON is N A 6l Special Species Code 7 Age Code 1 O0 Click on the Special Species drop down list i and Choose one of the following codes FR P993 Species ah ij EF LF or HO imple K EF Eroded fin s LF Lyons Ferry Choose FR for Fry if fish is 60mm or less 53mMP e Count a fy at all sites This code should only be used for desealed HO Hold over f
109. in which case it is entered as a sockeye in Catch Detail Use 450mm as the threshold for adult sockeye fallbacks e Use the less streamlined shape and the non silvery color characteristics of rainbow trout to exclude them from the steelhead smolt count and enter them in the Incidental Catch data entry tab e AS Ammocoete Unknown should be used for ammocoetes that are less than 70mm or that cannot be positively identified as AB or AP Age Code For Chinook choose 0 for subyearlings or 1 for yearlings For all other species the Age Code radio buttons are inactive Age is useful for distinguishing Spring Summer Chinook migrants typically yearling from fall Chinook migrants typically subyearlings Below is a series of diagrams to help users distinguish between yearling and subyearling Chinook based on their morphology In recent years a large number of yearling fall Chinook have been released into the Snake River from Lyons Ferry Hatchery and acclimation ponds above Lower Granite Dam and thus should be assigned a 1 even though their morphology is consistent with the fall Chinook shown below Additionally holdover fall Chinook should be assigned as age 1 60 Fall Chinook subyearling Caudal fin forked with outer margin usually black Parr marks large vertical oblong shapes centered on lateral line and wider than interspaces Anal fin rays short wedge shapes usually not pigmented Large spots on back Body w
110. ing or Deleting Mark Recaptures Records You can only edit one record from the Mark Recaptures data entry tab at a time To edit a record first double click on the record you wish to edit The data entry panel top of screen will automatically be populated with that record s data At this point edits can be made to the record Once edits are made choose the Save button If no edits are necessary choose the Cancel button To delete a record single click on the record you with to delete and choose the Delete button You will get a prompt confirming that the record is to be deleted select yes and that record will be removed from the local database 76 VIILE Transportation Tab The Transportation data entry tab is for transportation sites only i e LGR LGS LMN and MCN and is intended for target salmonid species only Each record entered into the Transportation data entry tab is broken into groups based on Species Code Age Code Tank Special Species EF and FR Clipped Unclipped and Coded Wire Tag combinations The numbers for Bypassed Trucked and Barged are derived from the Collection Totals minus total mortalities sample facility and research for each Species Code Age Tank Special Species EF and FR Clipped Unclipped and Coded Wire Tag combination Since the data grid has so few columns there are no frozen fields in the Transportation data entry tab VIILE 1 Definitions and Data Entry Before any data can b
111. into the Settings screen 4 Choose Save Record 5 Proceed to Section VII D VII D Entering Non Condition Fish Data Catch Detail If all fish sampled that day were condition fish and no mortalities were encountered you may skip this step and move onto Section VII E Otherwise once the Catch data have been entered the next step is to enter the non condition sample data via the Catch Detail tab To select the Catch Detail screen for data entry first select the record for the batch you want to add data to by clicking on the batch record in the data grid at the bottom of the Catch screen A selected record has an arrow beside it Second select the Catch Detail tab For a detailed description of data entry fields in the Catch Detail tab see Section VIII B below Below is a brief overview of how to enter a single record of non condition sample data 1 From the Catch Detail tab click on the New button 2 Fill in the correct sub batch and tank information for the record you wish to enter 3 Choose the appropriate Species Age Clip Coded Wire Tag and Special Species information for the record you wish to enter 4 When entering the first record of a sub batch the program applies the default sample rate for that sub batch If this is not the sample rate that was used you must change the sample rate multiplier to the correct value Use the Multiplier drop down menu to choose from the list of standard sample rates multipliers If a non
112. ise please call Brandon Chockley at the Fish Passage Center 503 230 5362 with questions After the manual is read by each individual SMP remote site staff member please sign the form on the last page of the manual which acknowledges that you have read the manual and return the signed form to Brandon Chockley at the Fish Passage Center III A Personnel to Contact For Technical Help e Brandon Chockley SMP Co Manager 503 230 5362 bchockley fpc or Weekend number 503 521 0184 Contact Brandon for questions about definition of a specific fish condition change addition to procedures GBT questions and questions on how to enter data or information using FPC32 net and how to run or use specific commands Brandon is the principle contact for the SMP program e Jerry McCann SMP Co Manager 503 230 4291 jmccann fpc org Weekend number 503 432 0676 Contact Jerry for questions about definition of a specific fish condition change addition to procedures GBT questions etc e Christopher McCarty Computer Specialist 503 230 4582 cmccarty fpc org Weekend number 503 851 1549 Contact Chris for computer hardware windows and software setup technical problems i e problems with computer hardware errors and issues e Lynnae Sutton Data Management Specialist 503 230 4290 lsutton fpc org Weekend number 503 720 8205 Contact Lynnae for questions about how to enter data or information about using FPC32 net and about how
113. ish Daily and Collect Data SMP personnel at Bonneville Dam will sample fish daily throughout the monitoring season at the JMF Collect species condition and external mark detail from all sampled fish Collect detailed condition and length data from a subsample of the sample Count and identify all incidental species caught in the samples Tally review enter into computer and transmit all data to FPC daily During periods of low fish collection August to October 24 hour daily samples may be held and sampled every other day Milestone N D Project Operations and Flow Data Collection SMP personnel at Bonneville Dam will collect record and verify daily USACOE project operations and flow data and facility fish mortality within the bypass collection system Milestone N E Summarize and Verify All Sample Data on Days Collected at Bonneville Dam Milestone O A Transmission of Project Operations SMP personnel at Bonneville Dam will transmit daily Corps project operations flow data fish transport numbers facility mortalities percent descaling and average fork length data daily or every other day during low collections periods from August to October Ensure prompt transfer of data Notify FPC by phone whenever we cannot transmit data by 1400 hours on weekdays and or critical weekends via FPC32 Advise and discuss problems with FPC when they occur Milestone R C Sample Fish Daily and Collect Data SMP personnel at John Day Dam wi
114. ish to delete and choose the Delete button You will get a prompt confirming that the record is to be deleted select Yes and that record will be removed from the local database VIIL G Summary Cond Tab The Summary Cond tab allows users to view summarized fish condition records that are grouped by key fields listed below for promotion into the Catch Detail Incidental Catch and Mark Recaptures tabs The condition fish in the data grid are grouped by Sub batch Tank Species Clip Code CWT Special Species Elastomer tags and Elastomer tag colors Upon promotion the Catch Detail Incidental Catch and Mark Recaptures tabs all receive different subsets of these summarized condition data For example the records for the incidental species are only promoted to the Incidental Catch tab Clicking the Promote All button adds the summarized records to the appropriate data entry tab For convenience the Sub batch Tank Species Clip Code CWT Special Species Elast and Color codes are frozen on the left to help the user identify the row as they scroll to the right VIIL G 1 Definitions No data are entered or edited into the Summary Cond tab This tab is specifically used to promote the condition fish data into the Catch Detail Incidental Catch and Mark Recaptures data entry tabs Before promoting the user must specify which batch they intend to promote data for by selecting the corresponding batch in the Catch data entry tab Once
115. ish to upload and click the OK button Once you have uploaded all the files you with to upload click on the Upload Files button You will receive a message about the number of files that were successfully uploaded You can select the Refresh List button to check which files were uploaded e Note Only FPC32 net files with the suffix XML can be uploaded to this site If you accidentally attempt to upload a non FPC32 net file along with FPC32 net files the XML file will load and the results page will show you the number of XML files that uploaded successfully along with an error message for the incorrect file type s e Note Although up to 4 files can be uploaded at one time there is a limit to the size of each file and a limit to the total size of the files that are uploaded Currently a single file cannot be more than 1 5 Mb in size and the total upload is limited to 3 1 Mb If you are having trouble uploading an XML file check the file size If the file is larger than 1 5 Mb contact the data staff at FPC e Note If you are having trouble uploading files via the web try sending the file to the FPC via e mail smp fpc org See above for instructions Sending Hand Logs to the FPC After batches i e XML file have been submitted to the FPC SMP personnel must also send a copy of their hand log There are two ways to do this e Fax Hand logs can be faxed to FPC at 503 230 7559 e E mail Hand logs can now be e mailed as an attach
116. k Default is none The value of tank for the next record is the same as the previous entry until the user changes the value Species Code Default is none Species is a required field The value of species code is the same as the previous entry until the user changes the value Most number fields are initially set to zero These fields include tally condition count and total count Sub Batch This field facilitates the reporting of marked fish in samples carried out using different sample rates and or mechanisms within one batch or sampling period The default is 1 Make sure you are aware of which sub batch the marked fish were sampled in for each entry in the Mark Recaptures data entry tab When entering records in the Mark Recaptures tab the sub batch will be carried forward for each new record until it is changed by the user Tank Trap The Tank field only appears at LGS LMN and MCN Enter A or B to designate the tank from which the marked fish was sampled The Trap field is to only be used by the IMN Trap Enter A or B to designate trap Species Code Species Code lt H Chinook Click on the Species Code drop down list and Unknown E select the appropriate species code from the list box Only choose RT for Rainbow Trout if you encounter marked rainbow trout AT Rambow Trout SO Sockeye SI Steelhead Age Code This field is to be used for Chinook only Click on 0
117. le mortalities was examined for descaling If this is not 65 the case you may enter the correct Num Exam for Descaling after entering the Sample Count and Sample Morts e lf you over write the calculated value for Num Exam for Descaling this must be the last entry before hitting the Save New button e The automatic field validation logic displays an error message if the Sample Count minus Sample Morts is less than the number examined for descaling e Fish collected for GBT Gear Code GB are not to be examined for descaling For sub batches with Gear Code GB the default Num Exam for Descal is 0 e Fry and Lamprey juveniles are not to be examined for descaling The default Num Exam for Descal is 0 when Species Codes AB AP AS or MP or when Special Species FR are selected Num Descaled Enter the number of fish descaled from the non condition fish that were examined for descaling A fish that has greater than 20 descaling on one side is considered descaled e The auto field validation logic checks to see if Number Descaled is greater than Num Exam for Descal if so an error message is displayed Sample Morts For each sub batch enter the number of SMP related sampling mortalities for each species age rearing disposition This includes all fish that are dead in the sample tank s or those GBT fish that died after being sampled from the separator e Separator mortalities get entered in a special way see
118. lian Date In Basin biological terms the number of the day of the year from 1 365 In computer software terms the number of days after Julius Caesar changed the Roman calendar from the old Roman lunar calendar to the new Julian Sun calendar in 44BC KCFS Kilo or thousands of cubic feet per second a quantity measurement of liquid flow A commonly used measurement scale at main stem dams in the Columbia and Snake River basin Major Species The four anadromous salmonid species that are monitored in the Columbia Snake River basin Chinook Oncorhynchus tshawytscha Sockeye O nerka Coho O kisutch and Steelhead O mykiss Mark Recapture When an externally marked fish is recaptured and observed at an SMP remote sample site it is called a mark recapture or mark recap The marks that are considered external are elastomer tags freeze brands floy tags and visual implants PIT tags and coded wire tags and blank cheek tags are not considered external marks Multiplier The mathematical inverse of the sample rate I E one over the sample rate 1 sr Pick List Drop down menu List Box or any popup menu which uses a scrolling highlighted bar to mark the desired choice PIT tag Passive Integrated Transponder Tag This is an internal mark which is used in the SMP predominately to measure travel time down the hydro system SMP PIT tag marking sites are generally Rock Island White Bird Lewiston
119. lick of Clr Mark clears the Clip Code while the 2 click of Clr Mark makes CWT blank Weight and Length The Enter Weight and Enter Length buttons allow the user to return focus of the number key pad to the corresponding field This allows the user to use the number pad to enter in the data into the desired field The Clr Weight and Cir Length buttons clear the values in the weight or length fields and also return focus of the number key pad to the corresponding field Species Special Species and Miscellaneous Incidental Species These buttons allow the user to enter the following Species data 1 CH1 AD for yearling Chinook with an adipose clip 2 CH1 for unclipped yearling Chinook 3 CHO AD for subyearling Chinook with an adipose clip 4 CHO for unclipped subyearling Chinook 5 ST AD for steelhead with an adipose clip 6 ST for an unclipped steelhead 7 CO AD for a coho with an adipose clip 8 CO for an unclipped coho 9 SO AD for a sockeye with an adipose clip and 10 SO for an unclipped sockeye In addition to these BON JDA and MCN will be doing condition monitoring for lamprey juveniles The species codes for juvenile lamprey are 1 AB for Ammocoete Brook 2 AP for Ammocoete Pacific 3 AS for Ammocoete Unknown and 4 MP for Macropthalmia Pacific The Species Code is a required field and only one species button can be pushed for each fish If the wrong species button is pressed by mistake simply pre
120. lies for BON LGR LGS and LMN JDA and MCN for 2013 for 2013 incorporates lamprey juveniles VIILH 5 Fish Condition Touch Screen Condition Species and Mark Type Buttons The condition species and mark type buttons on the Fish Condition Touch Screen are found in the upper left and central portion of the touch screen These buttons are grouped in sections and some are also grouped by color These buttons have many functions Some of the buttons toggle on and off some move the computer focus to a specific field some clear a field or fields some open a pop up screen with additional selections and some select the appropriate sub batch and tank The condition button groupings include 1 Elastomer Location and Color 2 General Comments Sub batch and Tank 3 Disease Parasite conditions 4 Injuries 5 Miscellaneous Conditions 6 Descaling 7 Predation 8 Mark Types 9 Length and Weight functions 10 Species Special Species and Incidental Species codes 100 a L Yellow L Pink L Other R Yellow epn nk Touch screen species and conditions for LGR LGS and LMN Note LGR does not have Tank Buttons Touch screen species and conditions for BON JDA and MCN incorporating condition monitoring for lamprey juveniles Note MCN touch screen has buttons for Tank A and Tank B in same location as LGS and LMN touch screen 101 Elastomer Location and Color If the condition fish has an Elastomer tag
121. ll sample fish daily throughout the monitoring season at the JMF Collect species condition and external mark detail from all sampled fish Collect detailed condition and length data from a subsample of the sample Count and identify all incidental species caught in the samples Tally review enter into computer and transmit all data to FPC daily During periods of low fish collection August to October 24 hour daily samples may be held and sampled every other day Milestone R D Summarize and Verify All Sample Data on Days Collected at John Day Dam Milestone R E Project Operations and Flow Data Collection SMP personnel at John Day Dam will collect record and verify daily USACOE 119 project operations and flow data and facility fish mortality within the bypass collection system Milestone S A Transmission of Project Data SMP personnel at John Day Dam will transmit daily Corps project operations flow data fish transport numbers facility mortalities percent descaling and average fork length data daily or every other day during low collections periods from August to October Ensure prompt transfer of data Notify FRC by phone whenever we cannot transmit data by 1400 hours on weekdays and or critical weekends via FPC32 Advise and discuss problems with FPC when they occur 2 For Rock Island Dam Work Elements V and W the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 0
122. ll Chinook Running this report after entering non condition fish into the Catch Detail data entry tab prior to promoting condition fish is the best way to validate data entry of Lyons Ferry and Holdover yearling fall Chinook data from the non condition sample NOTE Collection counts from this report are NOT to be used for entry into the Transportation data entry tab as these fish are already included in the tallies of Chinook 1 from the Daily Batch Tank Report see Section VII I above 116 FISH PASSAGE CENTER Date 2 3 2012 10 29 56 AM SPECIAL SPECIES DAILY BATCH TANK REPORT Batch 11153 from File MCN11153 XML Page 1 Site MCN Subbaich Al Sampe Start Date 6 2011 Sample Start How 700 Sample End Date e220 Sample End Hour 700 Ge earCode a Sample Code 1 Number of Hours Sampet 24 Avg Total Dischage 481 7 kes Total Turbine Dischage 143 4 kt Avg Total Sot 333 6 kcs Commerts T ak A _Chinok HO __ Chinodk 1 LF F uc jow fo froaro k kew Joa Toan Non Cond Sample Cout 0 2 0 2 0 0 0 0 2 Exam Desc Non cond 0 2 0 2 0 0 0 0 2 Non cond Descaed 0 of o 0 0 0 0 0 o Condition Sample Cort 0 ol 0 0 0 0 0 0 ol Exam Desc Condition 0 0 0 0 0 0 0 0 0 Condition Descated 0 o o 0 0 0 0 0 0 Total Sampie Cart 0 2 0 2 0 0 0 0 2 Total Collection oo 1000 ool 1000 oof 00 j 00 j Sampie Mots 0 0 0 0 0 0 0 0 0 Facility Mors 0 0 0 0 0 0
123. ll be prompted with a message asking if you want this sample rate to be applied to all records of this sub batch Click Yes Once this is done for each of the sub batches click on the Promote All button When condition sample data are incorporated into the Catch Detail tab the sample counts for condition fish will appear in the Cond Sample Count field of the data grid lf data were entered in Catch Detail the sample rates in the two review grids must match for each of the sub batches If you notice that the sample rate in either of these two data grids do not match you must change the sample rate in Catch Detail See Section VIII B 1 above for instructions on how to do this Remote SMP Site Data Entry Program 5 x File Reports Summary Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site Catch Detad KUUE Conditions LG Sub Batches 7 Sub Batches 1 0 01 GC 2 0 2 i tormote Af Batch 3 02 Ge 1 0g Ne an 3 ioc T A i E VIILH Fish Condition Touch Screen The Fish Condition Touch Screen allows users to enter individual fish condition data To open the touch screen to enter fish condition records for a new batch with the Setting dialog Fish Condition Touch Screen Only checkbox checked double click on the FPC32 net icon The touch screen will open on the computer s desktop To open the touch screen to enter fish condition records using an exi
124. lt is set from the Setting dialog box The value of multiplier is the same as the previous entry until the user changes the value Sample rates Default is set from the Setting dialog box The value of sample rate is the same as the previous entry until the user changes the value There is only one sample rate per sub batch All number fields All number fields are initially set to zero 58 Sub Batch The default for the first record is 1 If the sample rate changes during sample day create a new sub batch for each period with a different sample rate Enter 2 for second sub batch 3 for third etc Examples where separate sub batches are appropriate include 1 multiple sample rates are used within a single day Note in this case Sample Code in Catch tab should have value of 10 2 a GBT sample from the separator should be entered as a separate sub batch 3 separator mortalities should be entered as a separate sub batch 4 lamprey juveniles are encountered during separator clean out procedures etc e lflamprey juveniles are sampled above the sample gate e g during separator clean out procedures removed from dewatering screens etc these individuals should be identified to species if possible and recorded in Catch Detail non condition sample count as a separate sub batch with a 100 sample rate gear code of GC and tank none Any mortalities associated with these lamprey should also be recorded If species ID is no
125. mber 17 March 1 May 31 Send in your daily batch via email and your daily batch hand logs via fax or e mail Send this information into FPC prior to the end of the business day or early the next morning FPC should only lag one day behind the current day s batch information Bypass Facilities Smolt bypass facilities smolt bypass collection facilities These terms refer collectively to the mainstream dam remote SMP sites of BO1 BO2 JDA MCN RIS LMN LGS and LGR Coded Wire Tag A small piece of wire inserted into the surface of a fish s nose which has been coded with information about the origin of the fish COE Daily Report The US Army Corps of Engineers produces many hydrological reports containing measurements of various hydro system parameters Descaled For SMP basin wide purposes when a fish is at more than 20 descaled on either side as determined by ocular measurement the fish is considered descaled even if descaling was clearly caused by predation in which case it would be considered descaled with predation marks present Descaled fish tagged with PIT tags that are entered into PTAGIS are segmented into three descaling categories at least 10 descaled between 10 20 descaled and greater than 20 descaled This last PTAGIS descaling category is similar to the basin wide SMP definition of a descaled fish Electronic Batch The xml file which is sent from the remote SMP sites to FPC
126. ment to the FPC E mailed hang logs must be in PDF format and should be sent to smp fpc org 130 E mailed hand logs can be sent in the same e mail as the batch file i e XML 131 In 2013 the FPC will continue to support two editions of FPC32 net for SMP data entry These editions are TouchScreenSetup3 msi and TouchScreenSetup3_lamprey msi The TouchScreenSetup3 msi edition will be used by site personnel at LGR LGS LMN RIS WTB LEW and GRN There were no significant changes to this edition of FPC32 net for the 2013 sampling season To make sure you are running the most up to date version and edition we suggest that all sites uninstall FPC32 net from their machines and download the newest version of TouchScreenSetup3 msi from the FTP site ftp ftp fpc org FPC32 net See Section VI C for instructions on how to do this If you are using a computer with Windows 7 operating system you may need to follow instructions that allow the user to gain Full Control of SQL Express These instructions have been added to this manual see Section VI D The TouchScreenSetup3_lamprey msi edition will be used by SMP site personnel at BON JDA and MCN There were no significant changes to this edition of FPC32 net for the 2013 sampling season To make sure you are running the most up to date version and edition we suggest that all sites uninstall FPC32 net from their machines and download the newest version of TouchScreenSetup3_lamprey m
127. mote SMP Site Data Entry Program z oj x File Reports Incidental Catch Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond J I Record Count 2 To create a new record in the Incidental Catch data entry tab choose New This activates the data entry panel at the top of the screen When the first record is created Site and Batch are carried over from the Catch data entry tab The user should enter a separate detailed record for each incidental species that was identified in the sample To edit a record select the record from the data entry grid at the bottom of the screen Each record has a sequence number to make the editing process easier 69 for the user A selected record has an arrow on the left The user may scroll to the right to evaluate the data to make sure it is the correct record for editing If the data need to be edited click on the record i e row of data to be edited and choose Edit The data from the record then populate the data entry panel at the top of the screen and are editable Once necessary changes are made choose Save For ease of navigation the Tab Keys can be used to move between fields and Right and Left arrow keys can be used to move the cursor within a data field Below is a table of the fields of data that are entered into the Incidental Catch tab along with the default settings for each field prior to data entry Following this table is a list of t
128. mple eae rate for a given sub batch The ee multiplier s corresponding sample rate will automatically appear in the Sample Rate field Alternatively users may enter the sample rate directly into the Sample Rate field e lf you enter a sample rate directly use a minimum of four digits to the right of the decimal point e g enter 0 0083 for a 0 83 sample rate If your sample rate has more than four digits the user must round their sample 63 rate to six digits to the right of the decimal point e g sample rate of 45 2 is 0 022123894 rounded to 0 022124 e When you choose a Multiplier from the drop down menu or directly entered a Sample Rate press Enter or Tab to move to the next field Once a sample rate is chosen the collection counts will be automatically calculated as integers when sample counts are entered see below e FPC32 net now validates whether the Sample Code from Catch tab matches the number of sub batches and sample rate data that are entered in Catch Detail For example if a Sample Code of 1 is entered into the Catch tab but two sub batches with different sample rates are entered into Catch Detail a Sample Code Validation Alert will appear f when this happens simply finish the current record and choose Save New followed by Cancel Switch back to the Catch tab and edit the Sample Code to reflect that two sample rates were used for this batch e g Sample Code 10 Sub Batch 2 Sequen
129. mpleting the fish condition records press the Export button on the lower right corner of the touch screen This action creates an XML file for the current batch that contains all of the fish condition records This file is saved in the location specified under the Setting dialog box for this computer FPC32 net uses the following naming convention for these exported XML files the first three characters are the site code followed by a two digit year and three characters corresponding to the Julian day of the batch sample end date 1 366 days From the wet lab computer open Windows Explorer and navigate to where the daily batch XML files are saved Insert a portable storage device e g thumb drive or floppy disk into the wet lab computer The computer may open a directory for the portable storage device Highlight the current day s batch or the batch you want to transfer to the office computer by clicking on the file name Choose Edit Copy 29 C fpc32 Eie Edit View Favorites Tools Help Qs p gt Search j gt Folders Wes gt X 19 E Address O C fpc32 Name tec Size Type 2 1 7200 XML Document t2 LG509002 xml 1 2 200 XML Document lt 2 LG508347 xml aa an 12 18 2 3KB XML Document 2 LG508346 xml D ified 20 AM 12 12 2 XML Document k2 IMNO8339 xml Size 5 12 11 2 XML Document 7 default2 SWw3 12 5 20 Win Wedge Configur Fi default1 sw3 3 15 20 BKB Win Wedge Configu
130. n This field is only used by the SMP trap sites and not visible for other non trap sites e Imnaha River Trap enter 1 2 3 or 4 for trap positions 1 4 50 e Lewiston Trap enter 0 or east when the trap is in its normal position e Whitebird Trap enter the number of meters the trap is from the northern cable tower e g 10m 30m 50m or 10 30 50 e Grande Ronde River Trap enter the number of meters from the east tower that the trap is located at e g 175 Gear Code The default Gear Code is carried forward from the Settings screen Section III A If the listed Gear Code is incorrect click on the Gear Code drop down list and select the correct Gear Code e SMP Traps must use Gear Code MT or 00 e SMP Sites at Dams can use all Gear Codes except MT e Gear Code 00 must be used when there is no sample conducted in a collection period Gear Code GC Gatewell Collection Systen e Sample Unknown a 00 No Sample o FS Facility Sample GB Separator for GBT PHI Flow 2 GD Gatewell Dip GP Gatewell Airlift Pump MT Migrant Trap Sample Code The default Sample Code is 7 which means Normal Complete Sample If you wish to change this click on the Sample Code drop down list and select the desired Sample Code Below is a list of the various Sample Codes their meanings and appropriate Gear Codes in italics when applicable ae ee ee ee ere
131. n generated by previous versions of FPC32 This report summarizes all fish that had Elastomer tags and does not separate condition and non condition fish Running this report after entering non condition fish with Elastomer tags prior to promoting condition fish is the best way to validate data entry into the Mark Recaptures data entry tab 112 Page 1 FISH PASSAGE CENTER Date 2 2 2012 1 37 50 PM site MCN Mark Recap Report for Batch 11153 from File MCN11153 XML SB Tnk Spc Age Type LocBmd BmdOR Color TAG Clip Supp Length Total 1A CH 1 EL GR AD 142 1 1B CH 1 EL RE AD 137 1 1B CH 1 ER RE AD 132 1 Subtotal Chinook Elastomers 3 Subtotal Chinook Freeze Brands 0 Subtotal All Marked Chinook 3 Subtotal Steelhead Elastomers 0 subtotal Stelhead Freeze Brands 0 Subtotal All Marked Steelhead 0 Subtotal Chin Stlhd Elastomers 3 Subtotal Chin Stlhd Freeze Brands 0 Total Chin Stlhd Recaptures 3 REPORT COMPLETED NORMALLY IX B 3 Incidental Catch Report The Incidental Catch Report the same as what has been generated by previous versions of FPC32 This report summarizes all incidental fish regardless of whether they were collected as part of the condition or non condition sample Running this report after entering non condition incidentals prior to promoting incidental fish from the condition sample is the best way to validate data entry into the Incidental Catch data entry tab Page 1 FISH PASSAG
132. nd 4 Combined Each Species Clip combination represents a column in the report Each column has several rows of data These rows are as follows 1 Non Cond Sample Count 2 Exam Desc Non Cond 3 Non Cond Descaled 4 Condition Sample Count 5 Condition Descaled 6 Total Sample Count 7 Total Collection 8 Sample Morts 9 Facility Morts 10 Research Morts 11 PIT tag Morts 12 Num Bypassed 13 Num Trucked 14 Num Barged and 15 Descaling Pctg Running this report after entering non condition fish into the Catch Detail data entry tab prior to promoting condition fish is the best way to validate data entry of non condition data Also after promoting condition fish this report can be used to determine final collection counts for data entry of salmonid species into the Transportation data entry tab see Section VII I above Lamprey juveniles are not included in this report see Section IX B 8 below 115 Page 1 FISH PASSAGE CENTER Date 2 2 2012 1 40 03 PM Site MCN DAILY BATCH TANK REPORT Batch 11153 from File MCN11153 XML Subbatch All Sample Start Date 6 2011 Sample Start Hour oroo Sample End Date 6 2011 Sample End Hour oroo Number of Hours Sampled 24 Sample Code Avg Total Decharge 481 7 kefs Avg Total Spil 333 6 keis Total Turbine Discharge 143 4 kets Comments Tank amp Chinook 1 Chinook 0 Steelhead Coho Sockeye Tatal Non
133. ng FPC32 net If data have been edited run the Daily Batch Tank Report and Lamprey Batch Tank Report again Once all of the data are entered and validated follow the End and Send Section VII K instructions below Page 1 FISH PASSAGE CENTER Date 4 16 2009 3 36 39 PM site LGS DAILY BATCHATANK REPORT Batch 09106 from File LGSO9106 AML Subbatch a sample Start Date 4 15 2009 Sample Start Hour 0700 Sample End Date 4416 2009 Sample End Hour OF OO Number of Hours Sampled 24 Sample Code a Avg Total Discharge 0 kefs Avg Total Spill kets Total Turbine Discharge 0 Kets Comments START USGS COLLECTION 47 HCH 1 1 WCH 1 17 HST 14 WST bypassed to researchers Condition and non condition sample ALL fish bypassed Tank A Chinook 1 Chinook 0 Steelhead Coho Sockeye il Total uc cwrt c uc wrt cL Fry uc er cwt c uc cwrt cL Fry uc cwrt cL i i A i i i i i i i i i i i i 0 o of of of of of of of of of of of of o i w esse i i i i i i L L L J i i i Condon Sample Count 16 7 69 of of of of s of of 4 of of of of af of o g9 Exam Desc Condon 16 7 se ol of ofl of s of of 14 of of of of af of 0 39 Condition Descaled ol of of of of of of of of of of of of of of of of 0 Total Sample Count 16 7 59 of of of of s oF of 4 oF of of of af of o 39 Total Collecton 00 350 2950 ol of ofl ol 250 of ol s of of of of
134. ng the program Computers located in the office should be set to have the Batch Data Entry Screen as the primary data entry window upon opening the program To make the Fish Condition Touch Screen the primary entry screen select the Fish Condition Touch Screen Only checkbox see figure below Computers in the wet lab should be configured in this manner Fish Condition Touch Screen Only Save Setting Automatically Export Last Selected Batch When Exit Cancel BO Bonneville Dam Powerhouse z Y Sample Rate Sub 1 0 005 200 0 5 0 005 Sample Rate Sub 2 0 05 20 5 0 0 05 Default Start Hour 0700 End Hour 0700 Batch Export Directory C Users bchockley Desktop F P Browse Batch Import Directory C Users bchockley Desctop Same as Export Browse email smp fpcorg Custom Comment 1 Sample commet 1 O O O O OOOO O O Custom Comment 2 Sample commet 2 0 O Custom Comment 3 Sample comment x Delete Old Batches from Database Delete Prev Year Delete Old Delete All 24 3 Regardless of which computer you are configuring the Settings dialog box can also be used to set many of the default settings for SMP sites including Site Gear Code Sample Rate s Start Hour and End Hour i Site enter your site in the Site box by choosing a value from the Site Code drop down list li Gear Code enter a default gear code by selecting a
135. nt ed wali Remote SMP Site Data Entry Program 0 x le Reports ransportation Catch Cabch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Ste LG Sequence 7 TankiTrap eA OOF Batch 9 1UU44 ode CH Chinoot 7 Age Code 45 Fin Clipped ajh Cwt s None Special Species New Num Bypassed Y Num Trucked i Num Barged i r i f Nu al Import Egit Delete Refresh To edit a record double click on the record from the data entry grid at the bottom of the screen Each record has a sequence number to make the editing process easier for the user The data from the record then populate the data entry panel at the top of the screen and are editable Once necessary changes are made choose the Save button For ease of navigation the Tab Keys can be used to move between fields and Right and Left arrow keys can be used to move the cursor within a data field Below is a table of the fields of data that are entered into the Transportation data entry tab along with the default settings for each field prior to data entry Following this table is a list of the fields and instructions of the types of data that should be entered into each field and how Field Name Default Settings Set in setting dialog Computed based on system date at 1 and continues sequentially Default is none The value of tank for the next record is the same as the previous entry until the user c
136. ntering fish condition records This is where these Special Comments are displayed Two separate comments can be entered each separated by a semicolon The Middle Section B in above figure of the Record Browsing Panel is where the fish condition information is displayed Fish condition information is divided into four types of conditions including 1 Predator 2 Injury 3 Other Condition and 4 Disease In addition to these conditions there are fields for the Weight and Length of each condition fish 97 Predator This row is where any Predator data are displayed If any of the predator buttons are pushed that predator type is displayed in this row Possible entries in this row include 1 Bird 2 Fish and 3 Lamprey Injury This row is where any Injury data are displayed If any of the injury buttons are pushed that injury will be displayed in this row Possible entries in this row include 1 Head Injury 2 Eye Injury 3 Operculum Injury 4 Body Injury and 5 Fin Injury Other Cond This row is where any Miscellaneous Injuries are displayed If any of the misc injury buttons are pushed that misc injury will be displayed in this row Possible entries in this row include 1 Pop Eye 2 Fin Hemorrhage 3 Pink Fin 4 Fin Discoloration and 5 Eye Hemorrhage Disease This row is where any Disease data are displayed If any of the disease buttons are pushed that disease will be displayed in this row Possible
137. ntry Program User s Manual V K Rock Island Dam Smolts will be examined for various factors including species fin clips marking data and detailed fish condition data including descaling Fish from the general population are obtained from the bypass channel during a 24 hour interval between 7am and 7am daily Sample smolts for counts by species and clipped unclipped status In additional another primary function of this site for SMP is to PIT tag out migrating smolts 14 GBT monitoring is conducted at this site See Gas Bubble Trauma Monitoring Protocol and GBT net Data Entry Program User s Manual V L Whitebird Trap Operate a scoop trap on the lower Salmon River above Whitebird for a 12 week period five days per week The primary function of this site for SMP is to PIT tag out migrating smolts 15 The FPC32 net program was designed and tested on Windows XP It has not been tested on newer Windows operating systems but should operate properly in those environments FPC32 net will not operate in Windows 2000 or older operating systems VI A Hardware and Software 1 PC Details A PC running Windows XP with Service Pack 2 or later with at least 512MB of RAM to run the FPC32 net program 1 GB recommended and at least 1 GB of hard drive space 2 GB are recommended 2 Software A FPC32 net runs on Windows XP and Windows 7 B An internet e mail connection capable of sending files attached with base 64
138. number for dates prior to the current date e Select File and click on Create Older Days Batch A calendar will appear from which you may choose your batch end date You are limited to the current year To switch to a previous month press and hold on the current month and move up to select the desired month Double click on the date for the batch you want to create ad Remote SMP Site Data Entry Program a joj xj File Reports Batch Info Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conctions Summary Cond February 2010 To w E amp 7 24 O 10044 2 12 2010 0700 09156 6 4 2009 0700 10043 2 11 2010 070g e This batch must be edited To edit the batch from the Catch tab select the batch to be edited and choose the Edit button The following are items that must be edited o Put the actual end date and end hour in the Comments field o Put the actual sample hours in the Sample Hours field o Put the adjusted sample end date the following day in the End Date field o Be sure that you choose the appropriate Sample Code from the drop down list that reflects this adjusted sample o Choose Save Record e Follow instructions for sending the batch to FPC found in Section VII K The purpose of this section is to provide detailed information on the types of data that are entered into FPC32 net and how to enter these data This section also provides instructions on how data can be edited if when errors are f
139. o create a new record in the Mark Recaptures data entry tab choose New This activates the data entry panel at the top of the screen When the first record is created Site and Batch are carried over from the Catch data entry tab The user should enter a separate detailed record for each Sub batch Tank Species Code Age Code and Mark Type combination To edit a record double click on the record from the data entry grid at the bottom of the screen Each record has a sequence number to make the editing process easier for the user The data from the record then populate the data entry panel at the top of the screen and are editable Once necessary changes are made choose Save For ease of navigation the Tab Keys can be used to move between fields and Right and Left arrow keys can be used to move the cursor within a data field Below is a table of the fields of data that are entered into the Mark Recaptures data entry tab along with the default settings for each field prior to data entry Following this table is a list of the fields and instructions of the types of data that should be entered into each field and how 73 Field Name Default Settings Set in setting dialog Sequence For each subbatch sequence starts at 1 and continues sequentially When a new subbatch is started sequence starts over at 1 Subbatch Starts at 1 The value of subbatch for the next record is the same as the previous entry until the user changes the value Tan
140. o indicate what this was in your comment s for the batch Catch Tab BU LU Special Species Code Click on the Special Species drop Special Species ERE down list and choose one of the 1e0us Incidental n a following codes EF LF and HO Color Co EF Eroded fin s See Section VIII B 1 for a detailed LF Lyons Ferry discussion of each of these Special HO Hold over Species Codes Note SMP sites no longer take condition data for Fry FR Therefore FR is no longer an option in this drop down list All Fry sampled should be entered as non condition fish using the Catch Detail tab Mark Type a ae The Mark Type drop down list includes choices for ag what type of clip a fish has adipose adipose and TaD Weight AD Adipose left ventral etc Use N A if individual condition redara AL Adipose Left Ventral x redator fish does not have any type of clip i JAR Adipose Right Ventral Injury LV Left Ventral Only RV Right Ventral Only 83 Elas Code Flas Code et The Elas Code drop down list includes choices for 7 oo a fish with an Elastomer tag and its location 5 EL Elastomer Tag Left ER Elastomer Tag Fight i Other UN Unknown Type Color Code rs The Color Code drop down list allows the user to rank ee choose the color of the Elastomer tag ik DO Dark Orange GR Green M Y Mustard yellow OR Orange
141. of data entry fields in the Transportation tab see Section VIII E below There are two ways to enter data using the Transportation tab The first is manual data entry where each Tank Species Age Clip CWT and Special Species EF and Fry combinations from that day s batch are manually entered one by one Lamprey Juveniles are NOT to be entered into the Transportation Data Entry Tab The other is to import the Tank Species Age Clip CWT and Special Species EF and Fry combinations from the Catch Detail data entry screen using the Import button For a more detailed discussion of each of these methods see Section VII I 1 and Section VII I 2 below Regardless of which method you chose to use you must know what your collection counts were for each Tank Species Clip CWT and Special Species code EF and FR combination This information is summarized for the entire batch in the Daily Batch Tank Report which can be generated by selecting Reports and choosing Daily Batch Tank Report All Subbatches from the drop down menu This report should be printed The data that are to be entered into the Transportation tab can be found in the rows labeled Total Collection and Sample Facility Research Morts i e mortalities see figures below NOTE For each tank all columns should be entered into the Transportation tab as separate records Holdovers and Lyons Ferry fish are included in the UC CWT or CL columns for Chinook
142. oject operations flow data fish transport numbers facility mortalities percent descaling and average fork length data daily or every other day during low collections periods from August to October Ensure prompt transfer of data Notify FRC by phone whenever we cannot transmit data by 1400 hours on weekdays and or critical weekends via FPC32 Advise and discuss problems with FPC when they occur Milestone AO C Sample Fish Daily and Collect Data SMP personnel at Lower Monumental Dam will sample fish daily throughout the monitoring season at the JMF Collect species condition and external mark detail from all sampled fish Collect detailed condition and length data from a subsample of the sample Count and identify all incidental species caught inthe samples Tally review enter into computer and transmit all data to FPC daily During periods of low fish collection August to October 24 hour daily samples may be held and sampled every other day Milestone AO D Summarize and Verify All Sample Data on Days Collected at Lower Monumental Dam Milestone AO E Project Operations and Flow Data Collection SMP personnel at Lower Monumental Dam will collect record and verify daily USACOE project operations and flow data and facility fish mortality within the bypass collection system Milestone AP A Transmission of Project Data SMP personnel at Lower Monumental Dam will transmit daily Corps project operations flow data fish transport n
143. on allows the user to navigate to the next record in the fish condition record set each record is shown in the record browsing panel The Next button cannot be used if a record is active i e data entry editing is allowed Previous The Previous button allows the user to navigate to the previous record in the fish condition record set each record is shown in the record browsing panel The Previous button cannot be used if a record is active i e data entry editing is allowed Cancel The Cancel button is used to cancel entering a new record or to cancel editing a record 95 Export The Export button saves the condition records to an XML file named with the site and batch number The location where this file is saved is specified in the Setting dialog box for your wet lab computer Upon successful export the user will hear a prompt and see an icon under the data review panel VIILH 3 Fish Condition Touch Screen Record Browsing Panel The Record Browsing Panel of the Fish Condition Touch Screen is found in the lower left corner of the touch screen This form displays the current record being entered or edited or it shows the last record entered Tank Trap Species S Species Clip Code AD Elast ER Color RE CWT Gen Comment A Spec Comment Irpury 0 erc Other cond Fin Hemm Lengi B Disease BKD 124 Site LGS Batch 09138 S batch 1 Sequence 141 C The Top Section A in above figu
144. on and type the comment using the touch screen keyboard The user can only enter two comments or codes in this field each separated by a semicolon lf a General Comment needs to be entered press the General Comment button and type the comment using the touch screen keyboard The user can only enter two comments or codes in this field each separated by a semicolon Press the Save New button to save the individual fish record and start on the next fish Return the fish to the bypass to where ever it needs to go Repeat Steps 4 through 9 for each subsequent fish After the record for the last fish is saved you must choose the Cancel button prior to exporting data VIILH 2 Fish Condition Touch Screen Function Buttons These function buttons appear in the lower center and right corner of the touch screen The following describes the functions of each of the buttons in this section of the touch screen CE New Edit Delete co Le Gave 4 5 6 Next Prev i Cond i 2 3 0 Cancel Exit Export Panel Number Pad The focus of the number pad is automatically set to the length field for entering fish lengths To change the focus of this number pad to the weight field the user must select either Enter Weight or Clear Weight If a comment button is chosen 94 numbers can be entered into the comment field by using this number pad The CE button clears the number that are in the field that is currently in focus Exit
145. on is used to specify which directory FPC32 net will look in for XML files to be imported If you want to use the same directory as the Batch Export press the Same as Export button Otherwise use the Browse button to browse to the directory where you want these files to be imported from 6 FPC32 net has built in sounds that prompt users when certain functions have been performed or need attention To hear these messages the Play Sound Checkbox must be checked NOTE to hear messages speakers need to be connected to the computer 7 f desired sites can have their batch files i e XML files sent directly to FPC upon completion To do this site personnel must enter smp fpc org in the e mail dialog box in the settings screen It is NOT mandatory that sites do this 8 FPC32 net allows for up to three user defined comments that can be incorporated in the Comments2 drop down menu of the Catch data entry tab These comments are labeled as Custom Comment 1 Custom Comment 2 and Custom Comment 3 in the Setting screen If you have a comment that you want to enter repeatedly that is not already in the drop down menu you can type that comment in one of these three text boxes 25 Any text that is entered into these text boxes will automatically show up in the Comment2 drop down menu 9 The Delete Prev Year and Delete Old buttons delete the batches stored in the local database except the current day s batch These buttons should only be
146. operation information and analysis including current and historical data During the in river migration season FRC summarizes current conditions in a Weekly Report FPC also provides web distribution of System Operation Requests SORs made by the Salmon Managers SORs are requests to the U S Army Corps of Engineers to operate the federal hydrosystem to protect or enhance in river fish passage and survival conditions If you would like more information or to view Weekly Reports and SORs please visit our web page www fpc org or contact our office at 503 230 4099 I B Remote SMP Site Data Entry Program FPC32 net The FPC32 net data entry program was originally designed as an organized method of obtaining fish and water flow data from remote Smolt Monitoring Program sites The software program has changed names slightly over the years beginning with RSDEP Remote Site Data Entry Program Later it was ported to Windows and named FPC32 The current version is FPC32 net Version 3 0 0 10 It has many improvements including a touch screen for entering fish condition data and the batch data entry is now done through forms This manual has been provided for the biologist who input the data as a reference to assist in the operation of the FPC32 net program It is essential that all SMP personnel who are responsible for entering fish data into the FRC32 net program and corresponding with the FPC read and understand this manual If any questions ar
147. or Chinook coho or sockeye as these are the only species that have fry If Chinook is the species code than the Age Code must be entered as 0 since only age 0 Chinook can be fry Steelhead fry should be entered as an incidental species Rainbow trout in the Incidental Catch data entry tab The EF code for Eroded Fin s is for use only with unclipped steelhead If the dorsal fin or paired fins of the unclipped steelhead are clearly eroded as a result of being from a hatchery and is clearly not the result of wear and tear from passing through the juvenile bypass system use this code The LF code is for Lyons Ferry Hatchery yearling fall Chinook that are released either from Lyons Ferry Hatchery or at acclimation sites above Lower Granite Dam This code should only be used at Snake River sites The HO code is for Holdover yearling fall Chinook which can be identified by morphologic characteristics at the Snake and Lower Columbia River dams Those morphologic characteristics include downturned eye deep body deeply forked tail and relatively little descaling to differentiate from recently released hatchery fish A photograph comparing Yearling spring summer Chinook to a Holdover fall Chinook is shown below Size can partly be used to identify a Holdover fall Chinook as these fish are typically greater than 160mm However a few Holdover fall Chinook may be as small as 135mm These fish may be smaller than some
148. ot know how many EF steelhead were collected 2 Enter the Num Bypassed Num Trucked and or Num Barged for each Tank Species Age Clip CWT and Special Species EF and Fry combinations To do this select each record and enter the corresponding Num Bypassed Num Trucked and or Num Barged for that record followed by the Save Record button e These collection counts can be found in the Daily Batch Tank Report 42 3 To validate these data re run the Daily Batch Tank Report All Sub batches and the Lamprey Batch Tank Report All Sub batches and verify that the Num Bypassed Num Trucked and Num Barged are correct VII J Validating Batch The Daily Batch Tank Report and the Lamprey Batch Tank Report that were generated and printed for Section VII I above can be used for final data validation These reports summarize sample counts descaling information collection counts and mortality data for condition and non condition fish separately by tank Validation from these reports can be done for a single sub batch at a time or for all sub batches combined Validate non condition data by comparing these reports to your hand logs paying special attention to the sample counts number examined for descaling descaling mortality counts and flow spill quantities Holdovers and Lyons Ferry fish are included in the UC CWT or CL columns for Chinook 1 If any changes need to be made edit the records with incorrect data usi
149. ound during data entry and validation For convenience all data entry tabs in the FRC32 net Main Form have similar layouts The fields found in each of the data entry tabs are presented in two ways The upper portion of each data entry tab is a data entry panel This panel is the location where new data are entered or existing data are edited It provides an ordered list of metrics to be entered for each record Many of the fields in this panel have data validation and integrity rules that check the data being entered to assist the user in determining if the entry is valid for the specified field Although some fields have built in validation not every field has validation checking routines For Clarification this section of the manual provides information about suitable data entry for each field in each of the data entry tabs Also there is a glossary of the various terminology used throughout this manual see Section IV The lower portion of each data entry tab is a data grid for display of entered data From this data grid data can be browsed scrolling up and down and left and right and sorted by header As mentioned earlier sorting by multiple headers is possible To do this simply hold down the Shift key while selecting the column headers in the order you wish to sort them by This data grid allows the user to view all entered data for a single batch for error checking and or validation For each of the data entry tabs one or more of t
150. our local database on your hard drive If a batch has been deleted by the user it can be re imported into the local database To do this from the 56 Catch tab choose Import From Batch and navigate to the directory where the final XML files are being saved Select the XML file for the batch you want to import and choose Open To make changes to the FPC database the reposting procedure must be followed VIII B Catch Detail Tab In the lower data grid the Sub Batch Sequence Tank Species Code Age Code Special Species Code Coded Wire Tag and Clip fields are frozen on the left to help the user identify the row as they scroll to the right Data are entered for each Subbatch Tank Species Code Age Code Special Species Code and Coded Wire Tag combination that were tallied as part of non condition sampling VIIL B 1 Definitions and Data Entry Before any data can be entered or edited in the Catch Detail data entry tab the user must specify which batch they intend to add edit data to by selecting the corresponding batch in the Catch data entry tab Once a batch has been selected in the Catch tab you may navigate to the Catch Detail tab faa Remote SMP Site Data Entry Program File Reports Catch Detail Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Ske LGS Sub Batch Sequerme 3 TankjTrap C Batch 11026 Species Code LH Lhincoal bal Age Code Fin Clipped OY
151. pancies are found then follow normal reposting procedures see Section VII L Rows for days with no data are included and batch numbers are included in each row to facilitate the use of pivot tables in spreadsheet programs to subtotal and grand total the counts by species rearing disposition batch number etc IX E End of Year Validation When sampling for the year is completed each site must send an e mail to notify the FPC staff that the sample season has ended This e mail should state the final batch number If necessary this e mail will also request a yearly validation spreadsheet including the data from the site for the entire year which should match the sites own data records After you have validated your end of year data against the FPC validation spreadsheets and all corrections have been made you must send us an e mail stating that your data are finalized 118 IX F Project by Project Details for SMP Reporting Requirements The Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 includes several milestones that pertain to the use of the FPC32 net data entry program Below is a summary of these milestones for the various SMP projects 1 For Bonneville Dam Work Elements N Q and John Day Dam Work Elements R T the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 state the following Milestone N C Sample F
152. ple smolts from the collection for counts by species and clipped unclipped status Examine all unclipped yearling Chinook for coded wire tags GBT monitoring is conducted at this site See Gas Bubble Trauma Monitoring Protocol and GBT net Data Entry Program User s Manual V I Lower Monumental Dam Smolts will be examined for various factors including species fin clips marking data and detailed fish condition data including descaling Fish from the general population are obtained from a timed sub sample of fish diverted from the bypass channel during a 24 hour interval between 7am and 7am daily Sample smolts from the collection for counts by species and clipped unclipped status Examine all unclipped yearling Chinook for coded wire tags GBT monitoring is conducted at this site See Gas Bubble Trauma Monitoring Protocol and GBT net Data Entry Program User s Manual V J McNary Dam Smolts will be examined for various factors including species fin clips marking data and detailed fish condition data including descaling Fish from the general population are obtained from a timed sub sample of fish diverted from the bypass channel during a 24 hour interval between 7am and 7am daily Sample smolts from the collection for counts by species and clipped unclipped status Examine all unclipped yearling Chinook for coded wire tags GBT monitoring is conducted at this site See Gas Bubble Trauma Monitoring Protocol and GBT net Data E
153. portant that you validate your data before sending anything to the Fish Passage Center There are several reports that can be generated to validate data entry Data can be validated by comparing these reports to your hand logs Below is a brief description of each of the reports that can be generated with FPC32 net and how they can be used validation Some validation information is also provided in Section VII J above Remote SMP Site Data Entry Program File Reports Daly Sumas p Mark Recapture Incidental Catch Fish Condition bat Individual Fish Condition Report En Daily Batch Tank Report tia Special Species Daily Batch Tank gt E San Lamprey Batch T ank na Total Discharge 100 Turb Discharge 50 IX B 1 Daily Summary Report The batch header information is found at the top of the Daily Summary Report This report does not separate condition and non condition fish Target species salmonids and lamprey are split into three groups 1 Clipped 2 Unclipped and 3 Combined Each Species represents a column in the report Each column has several rows of data These rows are as follows 1 Sample Count 2 Collection Count 3 Num Exam for Desc 4 Num Descaled 5 Facility Morts 6 Sample Morts 7 Research Morts 8 PIT tag Morts 9 Num Bypassed 10 Num Trucked 11 Num Barged and 13 Descaling Pctg 111 Page 1 FISH PASSAGE CENTER Date 2132013 8 30 52 AM Site LGR Daly SMP
154. r lt 2 BO208340 xml 12 5 20 B XML Document 5 Within Windows Explorer navigate to the portable storage device and choose Edit Paste The current day s fish condition data are now stored on the portable storage device e At this point you can rename the fish condition XML file in order to avoid confusing it with the final batch file that will later be saved and sent to FPC e To rename the fish condition XML file in the portable storage device right click on the file and choose Rename You must leave the first eight characters of the original file name intact and on the left hand side For example the file named BO211100 XML could be renamed BO211100Cond XML 6 The portable storage device needs to be removed from the wet lab computer If the portable storage device is a thumb drive right click on the Safely Remove Hardware icon in the system tray and choose Safely Remove Hardware A dialog box appears highlight USB mass storage device and press Stop Another dialog box appears again highlight USB mass storage device and press OK A system message appears stating that it is alright to remove the USB device Remove the USB drive and go to the office computer VII C Importing a Batch From the Condition Sample or Creating a New Batch Creating a new batch in the Catch Data Entry Tab Form i e Main Form depends on whether condition data were collected or not If condition data were collected as described in Sec
155. r BO2 JDA and LGR a When the user selects Special Comments a popup appears with the general comment text field and a keyboard see General Comments keyboard above The intent of this field is for sites to use it for other conditions that they would like to keep track of but don t have buttons for Itis recommended that sites come up with two letter codes for these conditions and let FPC know what these codes are and what they stand for FPC will use these codes with developing the site specific tools for site specific databases Users are allowed to enter two comments per field separated by a semicolon Pressing Submit enters the comments into the database Disease Parasite Conditions These buttons allow the user to enter the following Diseases Parasites Fungus Columnaris BKD Parasite Deformity and Other These condition buttons toggle on and off If a button is pressed by mistake simply press it again to make that disease parasite go away Users are allowed to choose as many Diseases as the fish has Definitions and examples of each of these Disease Parasite conditions can be found in Condition Sampling Protocol document Injury Conditions These buttons allow the user to enter the following Injuries Head Inj Eye Inj Operc Body Inj and Fin Inj These condition buttons toggle on and off If a button is pressed by mistake simply press it again to make that injury go away Users are allowed to choose as many Inju
156. r cond Site MCN Batch 11153 2 3 2012 2 The Fish Condition touch screen then appears The background panel appears gray until you select New 3 Select New to enter a new fish condition record The background panel turns white meaning that the computer will accept data The New button disappears and a Save New button appears If the background panel is gray the computer will beep when you press a button because it is not in the New or Edit mode In addition the Species Weight and Length fields in the lower left hand corner are highlighted in yellow This allows to user to more clearly see when these data are entered into the program 4 Turn on the scale and add the tray the scale automatically tares or calibrates to compensate for the weight of the tray place the fish in the tray and press the Print button on the scale e tis important that you press the Print button on the scale only once e Once a weight has been entered the weight field will turn from yellow to white and the corresponding weight will appear e lf this weight is incorrect press the Clear Weight button on the touch screen and then press the Print button on the scale 5 Enter the fish length using the touch screen number pad Using the number pad on the touch screen automatically shifts the focus to the length field e Once a length has been entered the length field will turn from yellow to white and the corresponding length will appear e If this length
157. ransportation mark recap and catch detail records A dialog box appears asking you if you really want to delete the batch choose Yes if you want to delete the batch along with all of its supporting records NOTE Do not delete the current day s batch record created when entering condition records edit it instead ka Remote SMP Site Data Entry Program File Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond New Batch End Day Tomorrow Sample Code Sampie Hours New Batch Yar Total Decharge Turb Dischange Total Spal cts OUE rescascay Comments 1 Comments 2 Start End Trap Gear Sample Sample River Phouse Phouse T Gapa Batch Startdate hour Enddate Kour locati code code hours flow 1 flo 2 fow S Edit 09075 5s 09082 3 22 2009 0700 3 23 2009 0700 GC 1l 4 0 0 0 O save As Batch Confirm Delete import from Batch D Do you want to delete the 09075 batch Delete al Record Count 2 l A second dialog box appears again asking if you want to delete the batch including all fish condition records Choose Yes if you want to delete the batch along with all of its supporting records Confirm Delete E xi YY You are going to delete all your records include fish condition from the 08366 batch NOTE This does not delete the records from the FPC database it only deletes the batch and it s supporting records from y
158. re of the Record Browsing Panel displays the Tank Trap Species Special Species Clip Codes Elastomer Code Elastomer Color CWT General Comment and Special Comment Tank Trap This will be either A or B where applicable If no Tanks are present this field will be blank Species Code Species Code is a Required Field for condition fish Therefore the text box for Species Code will appear yellow when a new record is created until a Species Code is chosen by the user When a Species Code is chosen this field will have the two letter code of that species If the individual fish is a Chinook there will be a third digit corresponding to the Age Code 0 for subyearlings and 1 for yearlings This field is used for target species and incidentals that are entered with the Fish Condition Touch Screen Fora detailed explanation of each of the Species Codes see Section VIII B 1 Target Species and Section VIII C 1 Incidental Species above 96 Special Species This field is where the Special Species Code is displayed There are three possible Special Species Codes for condition fish 1 HO for yearling Chinook holdovers 2 EF for eroded fish steelhead and 3 LF for Lyons Ferry yearling fall Chinook Clip Code This field is where any clip codes will be displayed There are five possible clip codes 1 AD for adipose clip 2 LV for left ventral clip 3 RV for right ven
159. rget salmonid species at all sites Fin clips include Adipose Left Vent and or Right Vent clips or any combination of the three If a fish has any of these clips that fish is considered Clipped Elastomer Tags are to be recorded on all target salmonid species at all sites For fish that have Elastomer tags sites are expected to record tag location and tag color in addition to species special species and clipping information Coded Wire Tags are to be recorded for all unclipped Chinook age 0 amp 1 unclipped coho and unclipped sockeye that are sampled at LGR LGS LMN WTB LEW and GRN This request was based on the increasing proportion of hatchery releases that are otherwise unclipped or unmarked By including CWT data SMP can differentiate many unmarked hatchery fish from wild origin fish This is important for use in run reconstruction wild fish population estimates timing data and other analyses of wild origin stocks Descaling Data Descaling data will be collected on all target salmonid species in the sample except Fry and those salmonids that are sampled as part of the Gas Bubble Trauma program Larval and juvenile lamprey will not be examined for descaling Fish that are part of the detailed condition sample will be examined for descaling as well as other indices of fish health status See the Condition Sampling Protocol for more information Other fish that are sampled but are not part of the detailed condition s
160. ries as the fish has Definitions and examples of these Injury conditions can be found in the Condition Sampling Protocol document 103 Miscellaneous Conditions These buttons allow the user to enter the following Miscellaneous Conditions Pop Eye Fin Hemm Pink Fin Fin Discol and Eye Hemm These condition buttons toggle on and off If a button is pressed by mistake simply press it again to make that miscellaneous injury go away Users are allowed to choose as many Miscellaneous Conditions as the fish has Definitions and examples of these Other conditions can be found in the Condition Sampling Protocol document Descaling These buttons allow the user to enter the following Descaling Conditions Partial Descale 3 to 19 descaled Descaled 220 descaled Descale Pred descaled 220 and clear predator marks If the wrong descaling button is pressed by mistake simply press it again to make that descaling go away or push a different descaling button to overwrite the erroneous selection with the correct selection Only one descaling type is allowed per fish record Definitions and examples of these Descaling categories can be found in the Condition Sampling Protocol document Predator Conditions These buttons allow the user to enter the following Predation conditions Bird Fish and Lamprey These condition buttons toggle on and off Ifa button is pressed by mistake simply press it again to make that Predator type go away
161. rom which fish condition records were just imported in the Catch tab Select the batch with the fish condition records you just imported by clicking on the record in the data grid Selected records have an arrow beside the batch 4 Choose Edit This puts the selected record into the form at the top of the page allowing the user to edit the data fields in the upper portion of the screen 5 From this point users should enter basic Catch data including 1 Start Time 2 End Time 3 Gear Code 4 Sample Code 5 Sample Hours 6 31 Total Discharge 7 Powerhouse 1 flow 8 Powerhouse 2 flow if applicable 9 Total Spill and 10 any Comments Comments 1 or Comments 2 that pertain the entire batch Note The start time end time and gear code will automatically set to the default values that were entered into the Settings dialog box e Fora detailed description of each of these fields and what types of data should be entered see Section VIII A 1 below 6 Choose Save Record button 7 Data entered into the Catch tab should be reviewed and validated at this point 8 Proceed to Section VII D Vil C 2 Creating a New Batch Record Directly from the FPC32 net Main Form for sites where no condition data are collected 1 From the office computer double click on the Fish Condition icon on the desktop The office computer should be configured so that the Main Form opens by default The Main Form window opens with the Catch tab forw
162. rps project operations flow data fish transport numbers facility mortalities percent descaling and average fork length data daily or every other day during low collections periods from August to October Ensure prompt transfer of data Notify FRC by phone whenever we cannot transmit data by 1400 hours on weekdays and or critical weekends via FPC32 Advise and discuss problems with FPC when they occur 5 For Lower Grande Ronde River Trap Work Elements J and L the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 states the following Milestone J C Operate Trap for Collection of Data SMP personnel at the Lower Grande Ronde River Trap will operate trap 5 nights week March 5 May 26 This will mean lowering the trap to begin the sample period at 6 00 pm on Sunday and cessation on Friday morning at 9 00 am Collect data on daily catch hatchery and wild population composition descaling recaptures of PIT tagged parr and average length by species Collect limited species data on incidental fish captured Monitor fish injury rates and mortality due to trapping and sampling procedures and modify as necessary to minimize injury and mortality rates Milestone J D Transmit Collection Data SMP personnel at the Lower Grande Ronde River Trap will electronically transmit salmonid collection 122 data to FPC daily in a standard format determined by FPC This will be done from a site sever
163. rranger een EE a Ha Security Update for 2007 Microsoft Office System KB2584063 Installed On 9 19 2011 C2 Security Update For 2007 Microsoft Office System KB2553090 Installed On 9 19 2011 C2 Update for Microsoft Office 2007 suites KB2596789 32 Bit Edition Installed On 1 11 2012 Ga Security Update For Microsoft Office PowerPoint 2007 KB2596343 32 Bit Edition Installed On 1 11 2012 3 Security Update For Microsoft Office 2007 suites KB2596765 32 Bit Edition Installed On 1 11 2012 BB ConsoleImportTdgs Size 0 09MB GB Dimension 4 v5 0 Size 0 29MB f Fish Liberation Recording Program Size 4 742 00MB E FishCondition3 Size 23 77M6 Click here for support information Lised occasionally Last Used On 1202012 E Fraps MB GBT Net Size B GGobi Interactive Graphics Platform amp Googe Earth a9 Google Toolbar for Internet Explorer B GoToMeeting 4 5 0 457 see ieii o oon oe Mie om om Bose 2 oe oe mea mmn mm h or remove programs and Windows components 4 A dialog box appears asking you to confirm the removal of FishCondition3 choose Yes to uninstall FishCondition3 Follow the prompts to uninstall the program 5 After the program has been uninstalled follow the instructions for installing FPC32 net Section VI B above NOTE e Uninstalling FRC32 net and installing a newer version can sometimes lead to an Error message stating that the MS SQL Server Database could not open and that the user should cont
164. rror message is also displayed if Mark Right Eye Type is a Floy tag or a Visual Implant tag and SUAT seta data entry is attempted in this field VI Left or Right Brand Code This is for Freeze Brands i e Mark Type FB only Select the brand from the drop down list Brand Orientation This field is only used with Freeze Brands i e Mark Type FB Click on the drop down list and select an orientation Examples include 12 o clock 1 3 o clock 2 6 o clock 3 9 o clock 4 e An error message is displayed if the mark type is anything other than FB and data entry is attempted here Tag Number This field is for Floy and Visual Implant Tags only i e Mark Type FL or VI If it is discernible enter the tag number in this field e An error message is displayed if Mark Type is FB EL or ER and data entry is attempted here 75 Tag Color This field is for Elastomer Tags only i e Mark Type EL or ER Click on the Tag Color drop down list and select the appropriate color code Leave blank for numbered VI tags e fa color code entry is attempted for any other mark type an error message is displayed Clip Code Click on the Clip Code drop down list and select the appropriate code for the clipped fins and clipped fin combinations on marked fish e Select N A when the fish is unclipped Supplemental Code Leave blank Tag Color N A S Clip Code N
165. rs the primary data gathered at these main stem monitoring sites is count data on juvenile salmonids that are sampled from the bypass system However lamprey juveniles have been added to the list of target species for the SMP These target species are identified to species and any clips and marks tags are also recorded Based on these count data i e sample counts an estimate of daily collection can be generated at each project From estimates of collection passage and population indices can be generated if the sample data are representative based on 24 hour sampling that is systematic and sample rates are known throughout that period Estimates of passage and population indices will not be done for lamprey juveniles In addition to sample counts data on fish condition are also collected Two levels of condition data are collected based on the level of detailed information to be collected For the full sample fish are examined for descaling based on FTOT criteria A subsample of the full sample is examined for detailed condition information including descaling injury and disease Salmonid fry are NOT examined for descaling or detailed condition information All COE dam sites conduct detailed condition monitoring on salmonid species In addition BON JDA and MCN conduct detailed condition monitoring on juvenile and larval lamprey The protocol for examination of fish for detailed condition monitoring can be found in a separate document entitle
166. s For other species this field is unavailable Fin Clipped Choose Y if the fish has an adipose or ventral fin clip Choose N if there are no adipose or ventral fin clips CWT Choose Y if there is a coded wire tag and you have been requested by FPC to check for a coded wire tag on that particular species Choose N only if you have checked for a coded wire tag and there is there is not a tag Otherwise choose N A Num Bypassed Enter the number of fish bypassed for each Species Code Age Code Tank Special Species EF and Fry Clipped Unclipped and CWT combination See Section VII I for a detailed discussion of how to get these numbers from FPC32 net reports Num Trucked Enter the number of fish trucked for each Species Code Age Code Tank Special Species EF and Fry Clipped Unclipped and CWT combination See 79 Section VII I for a detailed discussion of how to get these numbers from FPC32 net reports Num Barged Enter the number of fish barged for each Species Code Age Code Tank Special Species EF and Fry Clipped Unclipped and CWT combination See Section VII I for a detailed discussion of how to get these numbers from FPC32 net reports VIILE 2 Editing or Deleting Transportation Records You can only edit one record from the Transportation data entry tab at a time To edit a record double click on the record you with to edit The data entry panel top of screen is pop
167. s for an adipose fin clipped yearling Chinook If the species is an incidental species choose Miscellaneous Incidental Species and choose the appropriate button from the pop up menu To enter specific fish condition data press the appropriate button on the touch screen For a detailed description of each of these buttons and what types of data should be entered see Section VIII H below The data are saved to the database behind the touch screen and appear on the bottom left corner of the touch screen Most of the buttons are toggle buttons which means that pressing the button once adds the selected condition to the fish record and pushing the same button again removes the condition from the fish record There are some buttons where only one choice can be selected These include Species or Species Clip Special Species Descaling and Elastomer Tag Orientation Color buttons VILB 1 Brief Overview of Steps to Entering Fish Condition Data via the Fish Condition Touch Screen 1 To enter fish condition data with the Fish Condition touch screen double click on the FishCondition icon on the desktop on the wet lab computer A dialog box appears with three buttons The Batch End Day Today button 26 creates a batch with the end date matching today s date the Batch End Day Tomorrow button creates a batch with the end date matching tomorrow s date and the Batch End Day Yesterday button creates a batch with the end date matching yesterday s date
168. s of 300 to 500 fish when possible Typically Lower Columbia sites should limit sample rates to at or below 25 except when increased numbers of fish may be needed for research or to address immediate management needs Avoid using sample rates between 12 and 25 whenever possible to avoid impacts to sample accuracy as well as to minimize impacts to PIT tag studies near the divert during sample DDS trigger of 20 When possible sites should try to avoid the 0 6 0 67 0 7 1 5 3 0 7 0 and 15 sample rates as much as possible as they have the highest probability of causing rounding errors in data reports Sites should attempt to minimize the number of times per season sample rates switch from above to below 20 or from below to above 20 to minimize the number of times the DDS is turned on or off Collection Rate 1 sample rate Seconds Hour Per Hour Duration sec of Fish in Sample Emergency 05 200 18 2 J 9 f 20 000 35 000 15 666 54 4 135 300525 15 000 20 000 20 50 72 6 12 300400 10 000 15 000 3 0 333 108 6 18 300450 7 500 10 000 40 25 144 6 24 30040 6500 7500 50 20 180 6 30 300 375 4 500 6 000 7 0 143 252 6 42 315420 __ 3 000 4 500 100 10 360 6 60 300450 2 500 3 000 125 8 450 6 75 313375 1 500 2 500 200 5 720 6 120 300500 1 000 1 500 250 4 900 6 150 250 3
169. screen is populated with that record s data At this point edits can be made to the record Edits should only be made to these records when you are absolutely sure that there was an error in data entry For example if an anomalous length is identified for an individual record delete this anomalous length and leave the length field blank as opposed to attempting to correct the length Once edits are made choose the Save button If no edits are necessary choose the Cancel button FPC32 net also allows the user to edit the Sub batch number and or Tank for multiple records at once To do this first check the box in the Edit column of the data grid for all the records you wish to edit Second select the Edit button Change the Sub batch and or Tank to the correct value for the records to be edited Press the Update Sub batch button to edit the sub sub batch for the records and or the Update Tank Trap button to edit the Tank Trap for the records 88 _ BKD Parasite Deformity Other Linn ars Fungus _ Cot 1 1A A CH1 AD LF 24 1 138 2 75B CH1 AD 18 5 129 2 74B vy ST AD 37 7 170 2 3B x ST AD 112 4 233 jy d tee w T T e e ees 2 71B J st AD 73 1 201 2 70B fia ST AD 137 4 242 A S a ee ee a s Sia 191 i p New Subbatch 3 New Tank Trap 4 OB None Update Subbatch Update Tank Trap Cancel maa B To delete a record single click on the record you w
170. se Save Target As Navigate to c installfpc32net and save this file to this directory ae amp ftp ftp fpc org FPC32 net FTP directory FPC32 net a X FTP directory FPC32 net at ftp fpc org To view this FTP site in Windows Explorer press Alt click View and then click Open FTP Site in Windows Explorer Up to higher level directory 08 26 2011 11 45AM Directory BO 12 02 2008 01 52PM 206 692 864 dotnet fx35 exe 08 26 2011 11 46AM Directory LGR 08 26 2011 11 46AM Directory LGS 08 26 2011 11 46AM Directory LMN 08 26 2011 11 46AM Directory Manuals 08 26 2011 11 46AM Directory MCN 08 24 2009 02 48PM 359 656 msicuu2 exe 08 26 2011 11 46AM Directory Preseason Presentations 12 30 2008 08 S7AM 739 840 PROCEDURE TO INSTALL FPC32NET doc 08 26 2011 11 46AM Directory RIS 04 23 2009 09 24AM 901 120 setu ax 01 30 2012 04 01PM 57 393 504 SOI 02 01 2012 11 40AM 6 567 936 Touch 02 01 2012 03 34PM 6 567 424 Touch 08 26 2011 11 46AM Directory 05 04 2010 12 12PM 382 V 4 Once the files have been saved to your local hard drive using File Explorer navigate to c installfpc32net and double click on the TouchScreenSetup3 msi or TouchScreenSetup3_lamprey msi file to begin the installation process Note If you are installing this from a CD open File Explorer and navigate to the directory of the CD and double click on the TouchScreenSetup3 msi or TouchScreenSetup3_lamprey msi 5 This program requires NET
171. sesenseeesenses 46 VILM 1 Daylight Savings Time Transitions 46 VILM 2 Sampling End Date is the Same for Two Batches 47 Detailed Data Entry Instructions 48 VII A Catch Ta ccccccssscescsssssscssessecscesseeecesscseeesavscecavaeseeesarseeeeavasseeesarseeneans 48 VIILA 1 Definitions and Data Entry ccsssssssssessesesssesssesessneseeeeses 48 CA ct space tease tesstcaeee tend essadicdtasectecad eaten caec tama tateetiascitecsteaaictag 50 SAN AOUT arsa a aadks deca cttuedln eis 50 3 0H eee E E ee E EE EAE E EE 50 EA AOE E E dee recast 50 Trap Location asesesnenenennoneoeennennennonrenrnnennenrnnronrnnnnnnnrrnrnnennnnennrennnnrnnn nenes 50 Gar Code orire aa eE aL a aces 51 RNS OS E E E A E ve E E E E 51 S711 119 im et i ene E Y 52 Total DISCM AIG C cscsessacvescusssucsacesosescasnsuasesecenastacncutvaccseseicasacsdreseseussenunczee 52 PH1 Flow Turbine DISCharge esennnenenennenennennenneenennnenennennrenrenrenenn 52 ill Fee ON ca aa ae ec ceca aes emt E ae EE caeadinctcueee es fie gt rae ane ne one re Oe A S Comments1 ad Comments 2 Adjusting Batch Numbers and Creating Batches for Past Dates Editing Older Batches ssssssssssssessessessessessessssessessesseeseeseeseeseess Removing a Batch Record from the Local Database VIII B Catch Detail Tab Special Species Code Gear Code Multiplier and Sample Rate Non Cond Sample Count Estimated Collection NUM De SCAlCO a sesececesecsesessceceseec
172. si from the FTP site ftp ftp fpc org FPC32 net See Section VI C for instructions on how to do this If you are using a computer with Windows 7 operating system you may need to follow instructions that allow the user to gain Full Control of SQL Express These instructions have been added to this manual see Section VI D XI A Procedure to Allow Full Control for Windows 7 Operating System When FPC32 net is installed on a machine with Windows 7 operating system the user may experience problems when trying to save new records These problems may occur each time FPC32 net is uninstalled and reinstalled The FPC staff has found that this is often a permissions issue that can affect whether SQL Express database files can be written to by the current user The 2013 manual has been updated to provide instructions on how to remedy these issues These instructions can be found in Section VI D starting on page 21 X B Lamprey Condition Monitoring Pred Bird vs Body Injury BON JDA and MCN U S Fish and Wildlife has asked that the FPC crews at BON JDA and MCN work with them to better differentiate between body injuries causes by birds i e Pred Bird and those caused by the project i e Body Injury To that effect they have 132 asked that crews take pictures of Bird Marks versus Body Injuries and share them with the FPC as you go along FPC will work with USFWS towards better defining these two categories In addition USFWS
173. so ay 3 Tank A and None Chip Unctip T aly CH1 OF 0 CHO Oy 0 ST of Co Os 50 y E Totat Oo 0 Tank B Cip Unclp Tally CH1 of CHO Ov 0 ST of co Or 0 SO Totat s 0 Special Species Taly Total Incilentak ij Total Sampled 0 Rlease enter Tank Trap Edit Delete Next Prey Exit Panel East f IAB QAS IAP 60 Me 1 Toa Po 31 Tank E Ci Undio Tay CH1 id 7 AB OAS 0 I AP 1 MF 1 Next Prev ext Panel Epot Touch screen for BON JDA and MCN incorporates condition monitoring for lamprey juveniles 93 aS 10 11 12 13 Press New The background panel turns white meaning that the computer will accept data If the background panel is gray the computer will beep when you press a button because it is not in the New or Edit mode Where applicable select the Tank for the sub batch you are currently sampling Turn On the scale and add the tray the scale automatically tares or calibrates to compensate for the weight of the tray place the fish in the tray and press the Print button on the scale Note You do not need to place the tray on the scale between fish but you may need to Tare the scale occasionally between fish Enter the fish Length using the touch screen number pad Press the appropriate Species Clip Condition and Tagging buttons lf a Special Comment needs to be entered press the Special Comment butt
174. sof ol 0 4450 Sample Morts 0 0 f 0 0 0 0 0 0 Facility Morts o of of o o o of of of o 0 Research Morts o of o o of o o of o o 0 PIT Tag Morts o ol of of i 0 o o of ol o 0 Descaling Peig 00 oo oo oof 00 oo 00 O00 00 oof 00 00 oof 00 oo oo 00 oD 0 0 A separate report Special Species Daily Tank Batch Report can be used to validate the entry of holdover and Lyons Ferry yearling Chinook data at the unclipped clipped and CWT level Select Reports and choose Special Species 43 Daily Batch Tank Report from the drop down menu This report summarizes sample counts descaling information collection counts and mortality data for condition and non condition holdover and Lyons Ferry yearling Chinook separately by tank Validation from this report can be done for a single subbatch at a time or for all subbatches combined Validate non condition data by comparing this report to your hand logs paying special attention to the sample counts number examined for descaling descaling mortality counts and flow spill quantities Page 1 FISH PASSAGE CENTER Date 1 23 2012 3 24 Pht Site LGS SPECIAL SPECIES DAILY BATCH TANK REPORT Batch 11029 from File LGS110993tuL Subbatn l Sample Start Date 45 2011 Sample Start Hour oTOO sample End Dat gt gi Sample End Hour oTOO Gear Code GE Sample Code 1 Number of Hours Sampled 24 ug Total Discharge 111 45 ket Total Turbine Discharge 76 73 kc amp ong
175. spring releases of hatchery yearling fall Chinook Size alone is not a fool proof indicator Finally Holdover fall Chinook are typically observed in April and May The figure below compares a Yearling Sp Su Chinook top to Holdover yearling fall Chinook bottom size morphology and timing are useful for identifying HO fish 62 NOTE If fish do not meet the above mentioned criteria contact FPC instructions as to which code is appropriate Gear Code Gear Code will be carried forward into the Catch Detail data entry tab i from the Catch data entry tab Most often it will not need to be edited on GB Separator for GBT the Catch Detail data entry tab Total Sami GE Gatewell Collection System However some sub batches will A C0 Gatewell Dip require a separate Gear Code e g i iige iae nae GBT samples To change the Gear 7 i Code click on the drop down menu and Scien me appropriate Gear Code The Gear Code of MT cannot be entered at the SMP sites at dams an error message will display The Gear Code of 00 should only be used on days where no sample was taken ae 00 No Sample I FS Facility Sample Multiplier and Sample Rate For each sub batch you may choose the sample rate in one of AN aE aa two ways First the Multiplier drop Dp down list provides a list of some of the more common sample rates from which users may choose the E e aa p appropriate multiplier i e sa
176. ss system The separator is also part of the dewatering system in the juvenile bypass systems that removes water and increases the statistical density of fish within a given volume of water passing through the system Smolt An anadromous fish that is migrating down river towards the ocean In the SMP the use of the term smolt almost always refers to the four monitored anadromous fish species As a juvenile anadromous fish begin to move down river morphological changes can occur to the juvenile fish For example some species will silver up or become more silver in color As another example fall Chinook will become more football shaped as they reach the time to migrate downstream SMP Smolt Monitoring Program the program to monitor and evaluate the four main anadromous fish species in the Columbia Snake River basin 10 Sub batch Each batch of electronic data sent from the remote sites to FPC can contain multiple sub batches but not all batches do Some batches only use the default sub batch number for the entire batch which is 01 Usually one creates a sub batch for each change in the sample rate during a 24 hour sample Up to 99 sub batches can be made for each batch of submitted SMP data Transportation At LGR LGS LMN and MCN sometimes referred to as the four collector sites juvenile anadromous fish headed downstream are collected and transported via barge or truck to a place in the river downstream
177. ss the correct species button to overwrite the mistake 105 Fish Condition Touch Screen species codes for ALL sites a a J M a i AP MP Additional species codes for lamprey juveniles at BON JDA and MCN ooo As The Special Species buttons include 1 HO for yearling Chinook holdovers 3 EF for eroded fin steelhead unclipped only and 3 LF for Lyons Ferry yearling fall Chinook These buttons toggle on and off The user is only allowed to enter one special species code for each fish If the wrong Special Species button is pressed by mistake simply press it again to make that Special Species value go away or push a different Special Species button to overwrite the erroneous selection with the correct selection Only one Special Species type is allowed per fish record In addition to the five target salmonid species the user can also choose the Misc Incidental Species button For a list of the species codes see the species code listings in Section VIII H 3 When this button is pressed a pop up appears with a button for each of the Miscellaneous Incidental Species listed in alphabetical order of the common name not the species code The user simply presses the appropriate species button and the popup disappears returning the user to the main touch screen The selected incidental species code appears in the Species field on the Record Browsing Panel I Mise Incidental Species 1
178. sting batch record with the Setting dialog Fish Condition Touch Screen Only checkbox unchecked double click on the FPC32 net icon Right click on the FPC32 net icon in the system tray and choose Open Main Form From the Main Form choose the 91 Catch data entry tab and select the batch you want to work with Choose File Open Condition Touch Screen VIILH 1 Data Entry Sequence for the Fish Condition Touch screen 1 Open the fish condition touch screen A dialog box appears with three buttons 1 The Batch End Day Today button creates a batch with the end date corresponding to today s date 2 the Batch End Day Tomorrow button creates a batch with the end date corresponding to tomorrow s date and 3 the Batch End Day Yesterday creates a batch with the end date corresponding to yesterday s date Batch Batch End Day Today End Day Today Batch Batch End Day Tomorrow End Day Tomorrow Batch Batch e End Day Yesterday End Day Yesterday 2 Click on the appropriate Batch End Day button to create the desired batch If a batch already exists with any of these end dates a push pin icon appears next to the already existing batch s Batch End Day button Once you have done this the Fish Condition Touch Screen will appear 92 Oihe cond Lice aie ste MCN gacn 11153 2 3 2012 Smac 1 sequence 100 131 an 2 3 o E Iome 12 9 ST yy 3 co Oy 11
179. t Cond Species Code Click on the drop down list under Species Code and select the appropriate species code These are the only species codes that are allowed to be entered here Target Species Codes CH Chinook CO Coho SO Sockeye 59 Sub Batch Sequence 4 Tank Trap ST Steelhead Species Code CH Chinook Age AB Ammocoete Brook Unknown Ji XN Cwt O AP Ammocoete Pacific CH Chinook L vell Collection Syste CO Coho Je R AS Ammocoete Unknown SO Sockeye MP Macropthalmia Pacific 4 epee ount a ne bidia id LU Lamprey sp Unidentified 0 NUM ap ammocoete Pacific faled al Exam Total AS Ammocoete Unknown MP Macrop Pacific Facility Morts LU Lamprey Sp Unid NOTE e Exclude Chinook mini jacks 150 300mm that are obvious precocious males to the extent possible from the Chinook smolt count Enter them in the Incidental Catch data entry tab e Be aware that in April and May a significant number of Holdover Fall Chinook could be encountered in samples These should be entered as Age 1 Chinook with a Special Species Code of HO see below for further information on identifying holdover fall Chinook e All clipped sockeye kokanee are to be recorded as sockeye except at RIS In general sockeye kokanee 2200mm are to be recorded as kokanee in the Incidental Catch data entry tab unless it is clipped has a CWT and or is PIT tagged
180. t possible use species code LU when recording in Catch Detail FPC32 net now validates whether the Sample Code from Catch tab matches the number of sub batches and sample rate data that are entered in Catch Detail For example if a Sample Code of 1 is entered into the Catch tab but two sub batches with different sample rates are entered into Catch Detail a Sample Code Validation Alert will appear If when this happens simply finish the current record and choose Save New followed by Cancel Switch back to the Catch tab and edit the Sample Code to reflect that two sample rates were used for this batch e g Sample Code 10 Tank Trap The Tank field is available for editing at LGS LMN and MCN Choose either A B or None For these sites None denotes a group of fish that were sampled from the separator and NOT from Tank A or B Tank None for BO2 JDA LGR and RIS indicates that these sites only have a single tank At MCN use Tank None to denote raceway 10 The Trap code only pertains to site IMN Choose either A or B to designate trap Sub Batch 2 Sequence 1 Tank Trap A B None sample Code I Validation Alert Species Code CH Chinook v Age Code 1 OO F ki S ubbat S ame e Hes 7 N cwt OY N QONA SpecialSpecies n a v Subb t _ Deque ll Collection System Multiplier ile v Sample Rate 0 02 Fat F l
181. t be greater than the Total Discharge If this occurs an error message is displayed At BON and RIS the sum of PH1 Flow PH2 Flow and Total Spill cannot be greater than the Total Discharge If this occurs an error message is displayed 53 Comments1 and Comments2 Comments are used primarily to explain problems in getting the daily sample as described in Section VII M 2 above Observations of fish condition or abnormal size should also be included in the comments Extraordinary events impacting fish passage should be noted in the comments field s The comments field should NOT be used to indicate data entry updates Such comments as water turbidity lamprey kokanee etc should not be included If Sample End Date is the same for two batches see Section VII M 2 above Comments2 has a drop down menu that allows for entry of common comments during certain periods FPC32 net allows for up to three user defined comments that can be edited throughout the season by the users These user defined comments are available in the Comment2 drop down menu These user defined comments can be edited in the Settings dialog box of FPC32 net see Section VII A 7 above VIll A 2 Editing Records in the Catch Data Entry Tab Adjusting Batch Numbers and Creating Batches for Past Dates To create a batch that corresponds to another date other than Today s Date or Tomorrow s Date choose File Create Older Days Batch from the FPC32 net Main Form A calend
182. ta daily or every other day during low collections periods from August to October Ensure prompt transfer of data Notify FRC by phone whenever we cannot transmit data by 1400 hours on weekdays and or critical weekends via FPC32 Advise and discuss problems with FPC when they occur 4 For Little Goose Dam Work Elements D and E the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 states the following Milestone D C Sample Fish Daily and Collect Data SMP personnel at Little Goose Dam will sample fish daily throughout the monitoring season at the JMF Collect species condition and external mark detail from all sampled fish Collect detailed condition and length data from a subsample of the sample Count and identify all incidental species caught in the samples Tally review enter into computer and transmit all data to FPC daily During periods of low fish collection August to October 24 hour daily samples may be held and sampled every other day Milestone D D Summarize and Verify All Sample Data on Days Collected at Little Goose Dam Milestone D E Project Operations and Flow Data Collection SMP personnel at Little Goose Dam will collect record and verify daily USACOE project operations and flow data and facility fish mortality within the bypass collection system Milestone E A Transmission of Project Data SMP personnel at Little Goose Dam will transmit daily Co
183. tion VII B above the batch data from the condition sample is imported into the Batch Data Entry Screen i e Main Form for editing and entering non condition data see Section VII C 1 below If no condition data were collected 30 a new batch record can be created from within the Main Form see Section VII C 2 below ViI C 1 Importing Daily Fish Condition Records into FPC32 NET Main Form 1 From the office computer double click on the FishCondition icon on the desktop The office computer should be configured so that the Main Form opens by default The Main Form window opens with the Catch tab forward 2 Choose the button Import from Batch An open dialog box appears Navigate to your portable storage device and choose the batch you want to import data from Click on Open see picture below e112 Batch Info Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Sample Hours Total Discharge 2 Flow Total Spal hes Comments 1 Comments 2 Select a Batch File 2 x C LEW09363 ml LGRO9363 xml 2 LGROS364 xml LG509132 xml LGS09143 xml E UGS09156 xml LG509355 xml LG509356 xml gt E LGS09357 xml LGS09362 xml a LG509363 xml LG509364 xml WTB09362 xml CE WTB09363 xml File name z Files of type Batch files smi Cancel ey 3 The Main Form displays the batch f
184. tral clip 4 AR for adipose and right ventral clip and 5 AL for adipose and left ventral clip This field is blank if the fish is not clipped Elastomer This field is where any Elastomer tag information is displayed There are two possible codes for this field 1 ER for an Elastomer tag on the right or 2 EL for an Elastomer tag on the left This field is blank if the fish does not have an Elastomer tag Color This field is where the Elastomer Tag Color is displayed Below is a list of the different color codes This field is blank if the fish does not have an Elastomer tag BL blue RE red GR green OR orange YE yellow PI pink PU purple OT other CWT This field indicates the presence Y or absence N of a Coded Wire Tag Currently only LGR LGS and LMN examine condition fish for CWT For these sites the default value for CWT is blank for clipped Chinook coho and sockeye The default value for CWT is N for unclipped Chinook coho and sockeye unless the user enters Y For steelhead the default CWT is blank regardless of clip status General Comment The user can enter General Comments about the fish when entering fish condition records This is where these General Comments are displayed Two separate comments can be entered each separated by a semicolon Special Comment The user can enter Special Comments about the fish when e
185. transportation data are entered via the Transportation tab 7 Reports are printed Section X and data are sent to FPC for posting into the central database Section VII K and the FPC website V A Bonneville Dam Powerhouse 1 No sampling will conducted at Bonneville Powerhouse 1 in 2013 V B Bonneville Dam Powerhouse 2 Smolts will be examined for various factors including species fin clips marking data and detailed fish condition data including descaling Fish from the general population are obtained from a timed sub sample of fish diverted from the bypass channel during a 24 hour interval between 7am and 7am daily Examination of fish may occur throughout the 24 hour sample interval as necessary 12 GBT monitoring is conducted at this site See Gas Bubble Trauma Monitoring Protocol and GBT net Data Entry Program User s Manual V C Grande Ronde River Trap Operate a scoop trap on the lower Grande Ronde River 5 km upstream of the mouth seven days per week for a 12 week period The primary function of this site for SMP is to PIT tag out migrating smolts V D Imnaha River Trap Operate of the screw trap in the lower Imnaha River seven days per week The primary function of this site for SMP is to PIT tag out migrating smolts The Nez Perce Tribe provides data on fish collection based on a prior agreement no funding is provided by SMP V E John Day Dam Smolts will be examined for various factors including sp
186. ub sample are considered non condition fish These non condition fish will be examined for descaling based on the FTOT protocol A fish will be recorded as descaled if at least 20 of either side of the fish is descaled Descaling is defined as areas of the fish where scales have been removed by mechanical or other means including predators and it cannot be determined that scales have regenerated or healing has occurred When in doubt examiner should report the fish as descaled Consistency is important since changes in descaling rate are what triggers management action Mortality Data Fish that are found dead in the sample or die during or after handling should be recorded as mortalities in the non condition sample See the Section VIIIL B 1 for more details about what data to record 1 B 3 Fish Sampling at Main stem Monitoring Sites Sample Size Targets Fish Passage Center recommends collecting between 300 and 500 fish for the Smolt Monitoring Program at main stem sites These target sample sizes 3 correspond with the goal of achieving accurate and precise estimates of total collection at the dams These sample sizes have been reduced from historic sampling targets in an attempt to reduce fish handling The above target includes fish that are examined for detailed condition monitoring Recommended Sample Rates Sites should use the table below to determine sample rates Use a sample rate that achieves the target sample size
187. uch SCreen ooo cccccssssssscesssssscessessscessesseesscesseesees 91 VIILH 1 Data Entry Sequence for the Fish Condition Touch Screen 92 DIU ga 95 ee 22 ene nee are ee eee ne nen nee ee eee nee ee 94 EOR AM Sa ae cc tec ase a ste ree Ce ase acta oh atest ca seca 95 DO a ae ata etal coe at chat le acca Nahata Dlg Nae aca 95 SAVO NOW aaa aa Ea A 95 e eect E ANO AEA E AAE E A teeeeeteee 95 DIE ie TE E E E EE E E E E E E 95 NORU a a eee 95 PrEVIOU S ee ee eee eee ee 95 RANG Sc cates Ape rete Bu ers ee te ate O EEE 95 EXPOR taste ce ane te a ene ee a tate es aaa 96 VIILH 3 Fish Condition Touch Screen Record Browsing Panel 96 TAn UL epee ere ne E eee 96 S 1216 2 1c 0 6 ge een E E 96 Special SPCC a ececsescsseccssscseescecaracceceecavaescsceeeatavaeseeeeetavanseseeseaeans 97 E Ea ASP EA E NAE AA ATAS 97 121 0 4 lt A E E A E E E 97 0 2 EEE E EAA TA E ee A TN 97 sean cate AA PO AE A te E TE 97 General COMMENE oan cescsscscessssesccecesscsescescavatcseeeeatavacseseestavarseseeseatans 97 Special COMMEME aaa iccscsscscssssscecescessesesceececacscseceeatavseseseestavarseseesearans 97 1852 0 PE E E A AEE E EE E E 98 AITO 9s E E E EE EE E A E A ETET 98 Other CondiNonS a batten sdane uebviepciadeddtosa tetecieneiaeete 98 Be Ce EEEE eee er ne are meee ee ert 98 VALETO a en Tne ee 98 COO a eet eee earn Rene nea eee Seen rere 98 SM ea aaa ee des E E T desi neem neice deve eee ic em eae 98 22 0 amp eRe Oe nee
188. ulated with that record s data At this point edits can be made to the record Once edits are made choose the Save button If no edits are necessary choose the Cancel button To delete a record single click on the record you wish to delete and choose the Delete button You will get a prompt confirming that the record is to be deleted select Yes and that record will be removed from the local database VIIL F Conditions Tab The Conditions data entry tab allows users to edit browse individual fish from the condition sub sample that were entered through the touch screen For convenience the Sub batch Sequence Tank Species Age Code Special Species Code Coded Wire Tag Mark Type clip code and Elastomer Code are frozen on the left side of the data grid to help the user identify the row as they scroll to the right VIILF 1 Definitions and Data Entry Before any data can be entered or edited in the Conditions data entry tab the user must specify which batch they intend to add edit data to by selecting the corresponding batch in the Catch data entry tab Once a batch has been selected in the Catch tab you may navigate to the Conditions data entry tab To enter new fish condition records through the Conditions tab choose New Enter a fish condition record for an individual fish and choose the Save New button Upon entering your last entry you must choose the Cancel button after choosing Save New for that record Subbatch Species
189. umbers facility mortalities percent descaling and average fork length data daily or every other day during low collections periods from August to October Ensure prompt transfer of data Notify FPC by phone whenever we cannot transmit data by 1400 hours on weekdays and or critical weekends via FPC32 Advise and discuss problems with FPC when they occur Milestone AL C Sample Fish Daily and Collect Data SMP personnel at McNary Dam will sample fish daily throughout the monitoring season at the JMF Collect species condition and external mark detail from all sampled fish Collect detailed condition and length data from a subsample of the sample Count and identify all incidental species caught in the samples Tally review enter into computer and transmit all data to FPC daily During periods of low fish collection August to October 24 hour daily samples may be held and sampled every other day Milestone AL C Summarize and Verify All Sample Data on Days Collected at McNary Dam Milestone AL E Project Operations and Flow Data Collection SMP personnel at McNary Dam will collect record and verify daily USACOE 121 project operations and flow data and facility fish mortality within the bypass collection system Milestone AM A Transmission of Project Data SMP personnel at McNary Dam will transmit daily Corps project operations flow data fish transport numbers facility mortalities percent descaling and average fork length da
190. ummary Batch 11032 from File LGS11032 XML sample Start Date 1812011 sample Start Hour 0700 Number of Hours Sampled 24 sample End Date 2 72011 sample End Hour OF00 sample Code 4 Awg Total Discharge 100 kefs Awg Total Spill 50 keis Total Turbine Discharge 50 kcfs Comments The Report Viewing Window has several buttons at the top that allow the user to perform different functions Below is a brief description of these buttons and their Hz SE 4 off 2 gt i functions Daily Summary Report 125 Next Previous Page The Next Previous Page buttons allows the user to view the next or previous report pages In addition this section of the Report Viewing Window informs the user how many pages the chosen report is If the arrow buttons are blue then the report consists of more than one page e The Single Arrow buttons advance the report to the next or q gt previous page e The Skip buttons advance the report to the beginning or end J4 gt pages Printing Reports The Print button allows the user to print the report The Print button opens the Print Dialog Box From here the user can select a printer choose a print range and choose the number of copies to be printed LL Print a E E 2 x General M Select Printer PiDataCenter HP4250 B amp W on PRINTMASTER A FrontOffice HP4250 B amp W on PRINTMASTER lt 2 Microsoft Office Document Image Writer b Status Ready Printtofil
191. utton If no edits are necessary choose the Cancel button To delete a record single click on the record you with to delete make sure the record is highlighted and has an arrow next to it and choose the Delete button You will get a prompt confirming that the record is to be deleted select Yes and that record will be removed from the local database VIIIL D Mark Recapture Tab In the lower data grid the Subbatch Sequence Tank Species Code and Age Code fields are frozen on the left to help the user identify the row as they scroll to the right Data are entered for each Sub batch Tank Species Code Age Code and Mark Type combination that were tallied as part of non condition sampling 72 O x q Re mote SMP Site Data Entry Program File Reports Mark Recaptures Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Tank Trap ia Age Code e Mark Type ER Elastomer ag Hight Brand Loc Mee Brand Cede NA Brand Orientation NAA Tag Number Supplemental Code Non Cond Court Delete Vill D 1 Definitions and Data Entry Before any data can be entered or edited in the Mark Recaptures data entry tab the user must specify which batch they intend to add edit data to by selecting the corresponding batch in the Catch data entry tab Once a batch has been selected in the Catch tab you may navigate to the Mark Recaptures data entry tab T
192. value from the Default Gear Code drop down menu A gear code of MT will not be allowed at the dams and a gear code of GC will not be allowed at the traps iii Sample Rate s enter the default sample rates for your site and sub batches by choosing a value from the Select Default Sample Rate drop down menu for Sub batch 1 and Sub batch 2 Sample rates for additional sub batches will be entered later in the data entry process A sample rate of greater than 1 and less than 0 will not be allowed iv Start and End Hour enter the default start and stop hours in military time ranging from 0000 to 2400 v Trap Location if you are at a trap location the trap location field appears in the site configuration screen otherwise it does not 4 The Batch Export Directory button is used to specify where your batch records i e XML file will be stored on your PC Use the Browse button to browse to the directory where you want these files to be saved NOTE Regardless of whether the wet lab or office computer is being used to generate the XML file the file is named in the same convention It is imperative that the sites recognize this and do not confuse the two files The file that is generated by the wet lab computer can be renamed if site personnel choose see Section VI B 2 below The XML file that is generated by the office computer is the only file that will be processed by the FPC see Section VI K below 5 The Batch Import Directory butt
193. ve Programs Install or remove pr QB Administrative Tools Configure administr 9 MSN Set Program Ac E adobe Version Cue C53 Adobe Version Cue Defaults t Automatic Updates Set up Windows to Adobe Dreamweaver C53 k Printers and Fa 7 Date and Time Set the date time hiie EA Display Change the appear a Microsoft Office Excel 2003 Halo and Suppi Folder Options Customize the displ ibFonts Add change and 13 Tour Windows XP Search Game Controllers Add remove and c he EA inteKR GMA Driver Control the graphic U Run Internet Options Configure your Inte All Programs gt S gt Java Java TM Control P SyaKeyboard Customize your key T Mail Microsoft Office Ou _ Mouse Customize your mo a Network Connections Connects to other c R gt Phone and Modem Options Configure your tele Sy Power Options Configure energy s TA Printers and Faxes Shows installed prin QuickTime Configures Quick7i Regional and Language Options Customize settings Sy Scanners and Cameras Add remove andc Gi Scheduled Tasks Schedule computer Fa m ee Pees see me ses Install or remove programs and Windows components 2 From within Control Panel select Add Remove Programs 3 From within Add Remove Programs select FishCondition3 and choose Remove 20 Add or Remove Programs Currently installed programs and updates Show updates Sort by Name gt a
194. ved by The Fish Passage Center Research Morts For each Species Age Clip CWT combination enter the daily number of fish taken out of the SMP sample and sacrificed by non SMP researchers For example mortalities from USGS radio telemetry marking should be entered as Research Mortalities PIT Tag Morts This field is only used at RIS WTB LEW IMN and GRN Enter the number of mortalities due to SMP PIT tagging operations 67 Promoted Summary Condition Fish Individual fish examined for fish condition that have been entered through the touch screen and or edited through the Condition tab need to be Summarized and Promoted to the Catch Detail Incidental Catch and Mark Recaptures tab This is done by using the Promote All button found in the Summary Cond tab To learn more about the Summary Condition tab and the promotion of condition fish into the Catch Detail data entry tab see Section VIII G The Condition Summary tab summarizes the condition fish by Species Sub batch groups Sub batch Tank Species Age Mark type CWT The Promote All button adds the total condition fish sample to Catch Detail under the fields Cond Sample Count Num Cond fish examined for descaling and Num Cond fish descaled These fields cannot be edited To change the number of condition fish sampled or descaled the fish condition sub batch records must be edited in the Conditions tab When data are entered into Catch Detail prior to promotion the Sample R
195. w batches should be sent via e mail to smp fpc org with the appropriate XML file attached The FPC will not receive this e mail unless your e mail address has been cleared by the FPC data center staff Contact the FPC Data Staff if you need to add a new e mail address from which bathes may be sent If users to not want to send the final XML file to the FPC by navigating to their e mail program and attaching it to an e mail FPC32 net has a feature that allows users to send the final XML file with the push of a button However this feature only works with users who have Microsoft Outlook configured in their office iy computers and have constant internet access If you are not using Microsoft Outlook you will need to send the XML files using the procedure above To use this new feature you must type smp fpc org into the e mail field in the Settings tab see picture below Once this feature has been activated a Send button will be added to the Catch data entry tab on the Main Form Once the Save as Batch button has been pressed and the final XML file is written you may choose to send the batch automatically through FPC32 net by pushing this Send button A prompt will appear asking you if you want to send an e mail choose Yes Fish Condition Touch Screen Only M Automatically Export Last Selected Batch When Exit Play Sound o 4 Site 802 B02 Bonneville Dam Powerhouse z Gear Code Select Default Gear Code x Sample Rate

here - Fish Passage Center

Contents

Download Pdf Manuals

Related Search

Related Contents