Home

FPC32.net Data Entry Program Manual

Contents

1. B S Species Clip Code 7 8 9 Edit Delete Color CwT Gen Comment Spec Comment Predator Weight 4 5 6 Next Other cond 100 1 2 3 0 EE Export Site MCN Batch 11153 2 3 2012 S batch 1 Sequence 131 Touch screen for BON JDA and MCN incorporates condition monitoring for lamprey juveniles Note BON and JDA screen does not have Tank B Clip Unclip Tally 36 6 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 7 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 8 If 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 9 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
2. 82 VIII D 1 Definitions and Data Entry 83 PR Ga Un ncn timi dani Cesta den afin 84 AD caste NCC 84 Species ME M CE 84 AG LII II 85 Mig 85 Brano nate 85 Brand 85 ONENA DT 85 SE 86 LP 86 CIO E E R 86 S ppiemental Gode 86 86 Promoted Summary Condition Fish 86 VIll D 2 Editing or Deleting Mark Recaptures Records 86 ETIN EE r lacieregrzus 87 VA EST 2 Detnnitions DAT ca e aoa cota devo td vea 87 EET RT E EY 89 SDCCISS COUE aaa E 89 Special SPECIES Code oco e ee 89 AJC OOOO a E E E E E EEEE EE eee eee 89 RR AEE 89 ON 89 INNUIT A A 89 WING FAS Ca EET 90 AITITE She A 90 VIILE 2 Editing or Deleting Transportation Records 90 SE ero
3. 7 Ill FPC Contacts amp 9 Personnel to Contact for Technical Help 9 9 SMP Remote Site Facilities and 2015 10 Zt 11 V Site by Site SMP 15 V A Bonneville Dam Powerhouse 1 15 V B Bonneville Dam Powerhouse 2 15 Mos GRANGE RONGE 16 V D River nennen nnne nnns 16 Ay DI t 16 LC WISTO VAD 16 V G Little Goose 16 V A Low r Granite Dam 17 V I Lower Monumental Dam ccccccccceccceecceeeeeeceeeseeeseeeseeeeeeeeeeseeeseeeseeeaeeeeesaeess 17 eA m 17 SEMEL oe Roo m 17 BTE iueloMR 18 VI System Requirements amp Program Installation 19 VEA Hardware and SOWA eS 19 T PO FedUltemelllS adeste iced
4. 67 Sub Bale 69 i o 69 SPECIES m 70 E 70 LAE 11 0 012s EIER 71 qug 71 opeclal Species OG si e diete uUa cate 72 RR MS 73 Multiplier and Sample 73 Noriscond Salm Ole 75 uie 0 e161 0g me 75 NUNMEX AMMO DCSCall 75 NUM DOS CALC P 76 Salle eee eta 76 melee m 77 mistiscien PP TUTO TT ETT 78 PIT da MONS 78 Promoted Summary Condition 78 VIII B 2 Editing or Deleting Catch Detail 79 mmn 79 VII C 1 Definitions and Data 79 SPECIES EISE RETI 80 odimple OCOUIUs2 259 90 019 0 9091990 02010 08 20102009919 E 81 RERO TT 81 Promoted Summary Condition 82 VIII C 2 Editing or Deleting Incidental Catch Records 82 Mark HECADIUNGS VA
5. 130 IX B 8 Lamprey Batch Tank 131 FPO Weeky Valldal redira een ereu ei idu FUP FVPLVbPVEUVMPUPI UPS US VN OVER Y PO SU EY YS 132 IX D FPC Validation Spreadsheets ccccccccsecccseeecseeeceeeeceeeeseeeceeeeseeeeseeeesseeenees 132 IX E End of Year 132 VI IX F Project by Project Details for SMP Reporting Requirements 133 X Printing Daily Reports and Sending Data to FPC 141 Generating and Printing Reports 141 NOXUPTeVIDUS Ta O esne nce RUNS EMI UR EMEN E 142 PANUNG METTE TT 142 Save Report AS ccccceecccsssccceseeeceeeeeceeeeeseeseeseeeeeseeeeeseeeesseeeesseeeessaeeeeas 142 mi iie i oro m O 143 Sending SMP Data and Hand Logs to the 143 Sending New Batches Via E mail cccccceececeeeeeseeeeesseeeeseeeeesseeeeeas 143 Uploading New Batches or Hand Logs Via HTTP 144 Sending Hand Logs to the 146 What s New with FPC32 net 2015 147 Red Length and Weight Caution Dot
6. eeeeseeeeseeeeereenennn 147 XI B Added Functionality to Transportation Import Feature 148 XIL NON CS 151 VII LA 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 Corps of Engineers COE bypass facilities at Lower Snake River and Columbia Hiver dams This Protocol addresses the data that are collected for the SMP at COE bypass facilities at Lower Snake River and Columbia River dams and at the mainstem traps throughout the Snake River Basin 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 Bonneville Dam BON Rock Island Dam RIS the onake River Trap at Lewiston LEW the Salmon River Trap at Whitebird WTB and the Gra
7. la 481 cun ial 7 Disease Parasite Injuries Predator FU fungus head injury PB bird predator CO columnaris El eye injury PF fish predator KD BKD OP operculum injury PL lamprey predator PA parasite Bl body injury PO other predator DE deformity Fl fin injury OD other disease Other Conditions Descaling PE pop eye PD partial descaling 5 19 FH fin hemorrhage DS descaled 220 FP pink fin DP descaled by predator 22096 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 8 Tank None and 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 3 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
8. nud ARE TETTE 90 VIILF 1 Definitions and Data Entry 90 SIE aW 2110 9 LM M A MEUS 92 TT OO tes ea gs D D 92 TANK E T 92 qug 92 SDCCICS COS ee 92 Miseellaneous Incigel ial siise E E RE EEEE 93 opecial Specles GCode 94 Mark TYDE atest end tenia ds IU IU UE 94 Elas M EN 94 Sedem H 94 zu i em 95 OO TTE 95 Predator GHeckDOXBS 96 Illy ENO CKDOXES 97 Disease GlieckDOXOS 97 Other Conditions Checkboxes 98 General 99 VIII F 2 Editing or Deleting Condition RecordS 99 VIG Summary GONG videtnr e Rice ee Germen uode duod 100 AU ETT 100 Site and t E E AERE UA LA ate en Uren Cran EA RE 101 Catch Detail SubsBaICchHGS Dach 101 Conditions Sub BaleliBs cote cta t RU mots 102 VIII H Fish Condition Touch Screen 102 VIII H 1 Data Entry Sequence for the Fish Condition Touch Screen 103 VIII H 2 Fish Condition Touch S
9. or 00 e SMP Sites at Dams can use all Gear Codes except e Gear Code 00 must be used when there is no sample conducted in a collection period Gear Code GC Gatewell Collection Systen Unknown 00 No Sample FS Facility 5 ample GB Separator for GBT GD Gatewell Dip GP Gatewell Airlift Purnp MT Migrant Trap Sample Code The default Sample Code is 7 which means Normal Complete Sample 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 60 p Ld LS y Sample Hou Total Dischartggs Comments 1 2 Two or more samples taken during a day with separator cleanout 3 Mo sample or biased sample due to abnormal flows or inoperation of sample unit 4 No sample or biased sample due to weather conditions _ 5 Ma sample or biased sample due to equipment failure maintenance repair 1 7 Incomplete sample na code provided cause explained in comments 8 fish counts entered Fish accumulated and were sampled at a later date 9 Incomplete or biased sample counts are modified to estimate a normal sample 10 Multiple sample rates used throuout day not including sample rate for GET sample 12 Sample of fis
10. CM UM A2 jCohoAdut X Z A6 CohoAdult Hatchery AA CohoAdut Wid CR __ Crappie species Sucker Largescale LD Dace LongNose X SD _ Dace Speckled SU Sucker Other AD KeltAdut TT fench AE jKeltAdult Hatchery Trout Brook AF jKeltAdut Wild BK KO Trout Cutthroat L LK E LIR Trout Rainbow BT ON Killifish Banded LT Kokanee CT Lamprey Adult Brook RT Tr WE Walee WA Wamouh LW Whitefish Lake MW Whitefish Mountain MA _ Madtom Tadpole OT Other species not listed Notes e f 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 enter Other Species OT be sure to indicate what this was in your comment s for the batch Catch Tab PM PE SQ SR 5 5 oJ HS SP A4 A8 AC A3 A7 AB SK SN SG BU LU MU SU BT NT LT CT RT WE WA LW W BM BS BL BH 1 5 9 J1 J5 J4 JO J3 J2 CM UM A2 A6 AA CR LD SD AD AE AF BK KO LK LP LR MA OT 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 mortalities found in the sample Only required for lamprey adults
11. 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 2015 Send in your daily batch via e mail 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 lag only 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 HIS 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 U S 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 2096 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 are segmented into three descaling categories at least 10 descaled between 1090 2075 descaled and greater than 2096 descaled This las
12. continues sequentially When a new sub batch is started sequence starts over at 1 Starts at 1 The value of sub batch for the next record is the same as the previous entry until the user changes the value Tank Default is none The value of tank for the next record is the same as the previous entry until the user changes the value opecies 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 Age Default is none This field is used only for Chinook Default is none Default is none Default is none Default is none Field is blank Default is none Default is none Field is blank Field is blank 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 be used only
13. EE EE 110 BEIC 111 SS UID DAG A NE TERRE 111 SEGUEN gt 111 VIII H 4 Fish Condition Touch Screen Tallies 111 Tank and None and Tank B 111 opecial SPECIES TalllGSs uui E 111 Total Inciaental Tally sace tetti e ei bet 111 keirciber ino emi me 111 VIII H 5 Fish Condition Touch Screen Condition Species and Mark Type I 112 Elastomer Eocallort aHI GO OE eiut rupe vivis H PME PREIS 114 General Comments Sub batch Tank and Special Comments 114 Disease Parasite 115 MUN 69 EET 115 Miscellaneous GONGITIONS soto rSv Mr ERE 116 ise TT TT ET 116 Predator Condition S bm 116 cuoc 116 VV CIO Mt ANA rca as Sa RU 117 opecies Special Species and Miscellaneous Incidental Species 117 IX ieri e 121 IX A Automatic Data Validation and Alerts 121 IX A 1 Suspect Data Entry Alert Red Dot 121 Ex
14. RV right ventral and CWT coded wire tag 116 For those sites that examine Chinook coho and sockeye for coded wire tags the CWT button is pressed only 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 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 opecies 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 click 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 int
15. 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 COE biologists do not identify lamprey facility mortalities e g raceway mortalities to species and life stage Therefore SMP personnel should not report these mortalities in FPC32 net If a facility mortality is entered for any of the lamprey species AP AS AB MP or LU a red warning dot will appear next to the Facility Morts text box to alert the user to this entry FPC32 net will still allow the user to save this record but the erroneous facility mortality will be overwritten as 0 in the saved record 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 approved by The Fish Passage Center 77 Research Morts For each Species Age Clip CW T 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 used only at RIS WTB LEW IMN and GRN Enter the number of mortalities due to SMP
16. 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 g ta Remote SMP Site Data Entry Program E 51 Mark t ark Recapture Mark Recaptures Transportation Conditions Summary Cond Incidental Catch Fish Condition art Mew Batch ae T End Day Today Individual Fish Condition Report Daily Batch T ank Report New Batch Special Species Daily Bateh Tank Choose Gear Code End Day Tomorrow Lamprey B atch T ank Sample H d NE Batch Jay Yesterda Total Discharge Turb Discharge Total Spill EcFs Boal Comments 1 Comments 2 Choose Comment Daily Summary Report l 1 of 2 b b dg 100 al Percent Zoom Next Previous Save Report As Page Print Fage 1 FISH PASSAGE CENTER Date 2 2 2011 240085 ote LGS Daily SMP Summary Batch 11032 from File La811032 XML sample Start Date 13112011 sample Start Hour QOO Number of Hours Sampled 24 End Date 202011 sample End Hour Oro sample Code 1 Avg Total Discharge 100 kets Avg Total Spill S0 kets Total Turbine Discharge 20 kets Comments The Report Viewing Window has several buttons at the top INN that allow the user to perform different functions Below is a brief description of these buttons and
17. 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 End Day Today End Day Today Batch Batch Batch End Day Tomorrow Batch End Day Tomorrow Batch End Day Yesterday Batch End Day Yesterday J 2 Click on the appropriate Batch End Day button to create the desired batch Ifa 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 103 Clip Unclip T ally CH1 0 CHO 02 0 TE 0 0 CO 0 0 50 D 0 Total DE 0 Tank B Clip LInclip T ally EHI 0 0 CHO 0 0 5 0 0 CD 0 0 50 D 0 Total D 0 Special Species T ally Tank B None TotalHo 0 0 0 Total EF 0 0 0 TotalLF 0 0 0 Total Incidental 0 Total Sampled 0 Please enter Tank Trap Tank Trap Q S Species Clip Code 7 8 9 CE Edit Delete Elast Color CwT Gen Comment Spec Comment Predator Weight 4 5 5 Next Prev Injury Other cond PLUME Disease 1 2 3 0 Export Site LGS Batch 10044 2 13 2010 S batch 1 Sequ
18. 40 2 14 6 24 30040 65007500 50 20 180 6 30 300375 4500 6000 70 143 252 6 42 315420 3 000 4 500 100 10 360 6 60 300450 25003000 125 8 450 6 75 313375 5002500 200 5 720 6 120 300500 1 000 1 500 250 4 90 6 150 250 375 60031000 500 2 1800 6 300 300500 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 rates than needed to meet salmonid sample goals may be used to reduce handling and mortalities of shad Anesthetic Hesearch 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 one to two 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 approximat
19. Cat CM hiselmouth UM CR rappie species D ace Long Nose SD ace Speckled BK kWilifish Banded amprey Adult Brook LP amprey Adult Pacific LR Lampre Adult River MA Tadpole OT species not listed PM PE Perch SQ ike Minnow Northern almon Pink juv and Roller BM BS BL BH CP CC CM UM CR LD SD BK LK LP LR MA OT PM PE SQ SR CD 93 luegill and Pumpkinsee CD sonne pon rn peram drap wm CH1 Chinook yearling Chinook Subyearling Steelhead Coho angth Sockeye Ammocoete Brook amp mmacoete Pacific Operc AS amp mmocoete Llnknovwn Fin Macrap Pacific saric Parasite ImeFnrraiF Species list for BON JDA and MCN incorporating lamprey juveniles Special Specie n a Miscellaneous Incid Color Ca Bass Large Mouth BS Bass Small Mouth BL Bluegill Pumpkinseed BH Bullhead CP Carp CC Channel Cat CM Chiselmouth UM Chum CR Crappie m LD Dace Long Nosed SD Dace Speckled BK Kallifish Banded Code Name SC SA SJ Shad Juvenile RS SP Siberian Prawn SK SN Sturgeon Green BU LU S S nment Comment n Discol Eye Hemm 1 Deformity Other MU SU TT BT Trout Brook NT LT CT
20. Microsoft PowerPoint 2010 Q Tinn R R 7 TextPad j Brandon Chockley Documents Pictures Music Games Computer Control Panel Change settings an Devices and Printers Default Programs Help and Support Shut down gt 08 2 23 pP _ gt zd gt Control Panel All Control Panel Items v Search Control Pane File Edit View Tools Help Adjust your computer s settings View by Small icons Action Center Administrative Tools Adobe Version Cue CS4 32 bit AutoPlay We Backup and Restore the BitLocker Drive Encryption Ell Color Management Credential Manager 9 Date and Time Default Programs Desktop Gadgets Device Manager Devices and Printers Ii Display Ease of Access Center Flash Player 32 bit Folder Options Fonts Ad Getting Started 44 HomeGroup 2 Indexing Options Internet Options S Java 32 bit Z2 Keyboard Location and Other Sensors amp Mail P Mouse amp Network and Sharing Center Notification Area Icons EB NVIDIA Control Panel Wi Performance Information and Tools Personalization Phone and Modem 2 Power Options I Programs and Features 2 Realtek HD Audio Manager Recovery 9 Region and Language 3 RemoteApp and Desktop Connections Sound 8 Speech Recognition Sync Center 2 System uL Taskbar and Start Menu sli Troubleshooting User Accounts Windows CardSpace Windows Defender Windows Firewa
21. N A This field is for Elastomer Tags only i e Mark dip Code aiii Type EL or ER Click on the Tag Color BL Blue i Length GR G j drop down list and select the appropriate color EN code Leave blank for numbered VI tags e color code entry is attempted for any other YE Yellow mark type an error message is displayed PU Purple lOT Ohe Cli Code Tag Color Click on the Clip Code drop down list and T select the appropriate code for the clipped fins and clipped fin combinations on marked fish e Select N A when the fish is unclipped Length iilis AD Adipose TAL Adipose Lett Ventral SOEU AR Adipose Right Ventral LV Left Ventral Only Clip with CYT Hv Right Ventral Orly n Supplemental Code Leave blank 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 Th
22. Spill cannot be greater than Total Discharge 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 Example 1 Entering a Tank At LGS LMN and MCN each time a user starts data entry for a new sub batch 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 sub batch is changed or the user changes to a new Tank This message 15 also used in the Condition Touch Screen for these sites ecapbLures Transportation Conditions Summary Cond Please choose tank for this record 1 TankiTrap JA 2B Mone g Age Code 91 90 Special Species n a 124 IX B FPC32 net Validation Reports It is important that you validate your data before sending anything to the FPC 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 c
23. 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 or to designate the correct tank Choose N A to designate fish from the separator CWT At those sites that examine Chinook coho and sockeye for coded wire tags select Y when unclipped fish has a CWT N when an unclipped fish does not have a CWT CWT will default to N A for all clipped fish 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 92 Species ST Steelhead hol Chinook Yearling Chinook Subyearling 0 Leng 20 Sockeye Species list for LGR LGS and LMN Miscellaneous Incidental The Miscellaneous Incidental codes include several non salmonid incidental fish codes This drop down menu options are listed alphabetically by incidental species name NOT incidental species code Incidental Species Name ass Large Mouth ass Small Mouth Code BM BS BL BH CP CC
24. VII C Importing a Batch From the Condition Sample or Creating a New Batch 38 VII C 1 Importing Daily Fish Condition Records into FPC32 NET Main Form 39 VII C 2 Creating a New Batch Record Directly from the FPC32 net Main Form for sites where no condition data are collected 40 VII D Entering Non Condition Fish Data Catch Detail 41 VIEE Entering Incidental Gateli Data costituito eo e Menu ep ee eed 43 VILE Enternng Mark Hecablure Dala sisse E pd Roter ru Eras 44 Validating Condition BITES 45 VII H Promoting Condition Data into the 46 MILI Entering TIransportalor 48 VII I 1 Manual Entry of Transportation 49 VII I 2 UPDATED Importing Data from Catch Detail for Transportation Data alg m 50 VII I 2a Importing Species Data 51 VII I 2b Importing Species and Collection 51 ESQ iosuada ead uma Be menfe RR auae ap tad Ux ots 51 VILK ETa 53 MODOS IO AE 55 V
25. 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 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 Seconaly 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 13 14 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 vario
26. imported into the local 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 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 66 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 Sub batch Tank Species Code Age Code Special Species Code and Coded Wire Tag combination that were tallied as part of non condition sampling 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 he she intends 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 Pi Remote SMP Site Data Entry Program mj x File Reports atch Detail Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch Sequence 3 TankiTrap t JB Batch 11026 Species Code Chinook 91 Fin Clipped 9M cwk COY 9M COMMA Special Species n a Gear Cod
27. j U Cond Sample Count U er 9 19 122 IX A 2 Suspect Data Entry Alert Red Field 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 lt 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 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 Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch 1 Species Cade CH1 TankTrap 4 B i jMone Cut OY Batch 11032 Sequence 1 Species choose Species Code Special Species n a Miscellaneous Incidental Choose Spec
28. 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 AO F Summarize and Verify All Sample Data on Days Collected at Lower Monumental Dam Milestone AO G Project Operations and Flow Data Collection SMP personnel at Lower Monumental Dam will collect record and verify daily USACE project operations and flow data and facility fish mortality within the bypass collection system 135 Milestone AP A Transmission of Project Data SMP personnel Lower Monumental 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 AQ F Monitor for signs of GBT trauma Collect samples and conduct exams according to FPC GBT program protocols Samples should be taken one to two times per week
29. users to send the final XML file with the push of a button However this feature 143 works only with users who have Microsoft Outlook configured in their office 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 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 clicking on the Send button A prompt will appear asking you if you want to send an e mail choose Yes Mew Batch End Dav Today Fish Condition Touch Screen Only E Automatically Export Last Selected Batch When Exit Mew Batch End Day Tomorrow 7 Play Sound 9 0 New Batch Site BO Bonnevilille Dam Powerhouse 2 End Day Yesterday Gear Code Select Default Gear Code M Sample Rate Sub 1 0 005 200 0 5 0 005 v Sample Rate Sub 2 0 05 20 5 0 0 05 Default Start Hour End Hour e mail smp amp fpc org Caton Comment Sample comment 3 ELLA Import From Batch Edit Save s Batch Te SE fetes ee Delete ED Uploading New Batches or Hand Logs Via HTTP Instead of e mail new batches and han
30. 13 2014 2 39 32 PM from File LGS13364 XML Gear Code Sample Code 10 Avg Total Spill 50 Sock Total 2 10 40 0 680 0 2 10 0 0 0 0 0 0 0 0 0 0 40 680 0 0 0 0 000 0 00 96 CoFry Sock SoFry Total 1 5 1 27 20 0 100 0 20 0 1180 0 0 5 0 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20 100 20 860 0 0 0 0 0 0 0 0 0 00 96 0 00 96 Date 1 13 2014 2 39 32 PM from File LGS13364 XML PacAm BrkAm SmAm PacMac LamUn Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 Sock PacAm BrkAm SmAm LamUn Total 8 0 0 0 0 0 37 160 0 0 0 0 0 0 0 0 0 0 0 1860 0 7 0 0 0 0 0 34 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 0 0 0 0 0 1540 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000 0 00 96 126 IX B 2 Mark Recapture Report The Mark Recapture Report is the same as has been 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 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 Age Type LocBmd BmdOR Col
31. Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site Sub Batch 2 Species Code 5T TankiTrap Mone Cyt OY 2M Batch 09139 Sequence 74 choose Species Code Special Species p a Miscellaneous Incidental Choose Species Cade Mark Type AD Adipose Elas Code M A Color Code N A Descaling Gen Comment Weight af Length 170 Predator Bird Fish Lamprev Special Comment Injury Head Operc Fin PepEve Fin Hemm PinkFin Fin Discol Eye Herm Disease Fungus Columnaris BED Parasite Deformity Other Subbat Sequen Tank Edit CT BOCA Mc Color Weight Length Mene n 1 1A C CH1 AD LF 24 1 138 Edit JSB CH1 AD 18 5 129 m Delete L Select All E Clear All E Record Count 216 Below is 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 Sub batch Sta
32. GBT Examine juvenile salmonid emigrants for symptoms of GBT twice weekly The unpaired fins and eyes will be examined for the presence of bubbles Absence or presence of GBT symptoms as well as the location and severity of symptoms will be reported to FPC daily throughout the sample Season 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 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 134 Milestone X Mark Tag Animals Insert PIT tags into between 200 and 600 unclipped Chinook yearlings unclipped subyearling Chinook unclipped sockeye hatchery steelhead and wild steelhead weekly 3 For Lower Granite Dam Work Elements Al and AK Lower Monumental Dam Work Elements AO and AQ and McNary Dam Work Elements AL and AN the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 states the following Milestone 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
33. Installed 9 19 2011 Installed On 9 19 2011 Installed On 1 11 2012 Installed On 1 11 2012 Installed On 1 11 2012 Size 0 09ME Size Components 3 Fish Liberation Recording Pragram Size 4 742 23 ME B FishCondition3 Size Used occasionally Sele Click here Far support information Set Program Access and Defaults Last Used 1 20 2012 Fraps Size 1 58MEB GET Net Size if Gobi Interactive Graphics Platform Size Google Earth Size Google Toolbar For Internet Explorer GoToMeeting 4 5 0 457 To change this program ar remove it From your computer click Change or Remove 1 44 3 MB ga TME sooth 7 Lb PEEL e me rre m meL or remove programs and Windows components 5 A dialog box appears asking you to confirm the removal of FishCondition3 choose Yes to uninstall FishCondition3 Follow the prompts to uninstall the program 6 After the program has been uninstalled follow the instructions for installing FPC32 net Section VI B above VI C 2 Windows 7 1 If you want to install a newer version of FPC32 net you must first uninstall the old version 2 louninstall the older version of FPC32 net choose Start Control Panel 3 From within the Control Panel select Programs and Features de SQL Server Management Studio xci Microsoft Excel 2010 wi Microsoft Word 2010 Adobe Reader XI Windows Explorer
34. LP LK and LR 81 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 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 opecies Sub batch 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 VIII C 2 Editing or Deleting Incidental Catch Records You can edit only 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 double clicking on the record The selected record automatically populates 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 button If no edits are necessary choose the Cancel button To delete
35. Mum Cond 0 0 0 For descaled Num descaled For descaled descaled Total Exam j Total Mum Total Sample Count Total Collection 0 p EE qu Far descaled Descaled Sample Morts O Facility Morts 0 Research Marts 0 PITTag Morts 0 5 ubbat EN pm minu Delete Record Count 4 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 43 Incidental Catch data should be validated by printing or viewing the Incidental Catch summary report To view this report chose Reports and select Incidental Catch Condition Data include incidental species this validation step should be done prior to incorporating the condition data into the Incidental Catch tab via promo
36. Ope 1 1 0 1 0 0 0 1 3 0 0 1 A 0 1 m 0 1 A 0 0 0 e B 0 0 0 e B 0 0 0 e B 0 0 0 e B 0 0 0 e B 0 0 0 Record Count 15 Below is list of the fields and instructions regarding the types of data that be found in each field Site and Batch The Site and Batch fields cannot be edited Site is set in the Settings 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 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 samples 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 be populated only if data for non condition fish were entered into Catch Detail it is otherwise blank 101 Conditions Sub Batches When entering condition data via the touch screen the user enters a sub batch numb
37. 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 2 runs on Windows XP and Windows 7 B An internet e mail connection capable of sending files attached with base 64 encoding 3 Communication Devices 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 D types of internet connections such as a cable modem DSL or ISDN A thumb drive or other portable device for carrying batch files XML files from wet lab touch screen computer to data entry computer VI B 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 Windows 7 FPC32 net has not been tested on anything newer than Windows 7 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 3 Open Internet Explorer and go to ftp ftp fpc org FPC32 n
38. PIT tagging operations 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 Rate 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 Th
39. To flow Tu flow Look in FPC32 V3 902 Edit LEWO09363 xml LGRO9363 xml LGRO9364 xml LG509132 xml LGS09143 xml LG509156 xml Comments 2 Save 4s Batch Recent Import From Batch Desktop LGS09355 xml cum 16509356 xml gt LG509357 xml LGS09362 xml Wekc METTI LG509363 xml lt gt LG509364 xmi 595 WTBO9362 xml lt WTBO09363 xml ad m 6 My Network File name j Places Files of type Batch files xml A Choose Save Record button Data entered into the Catch tab should be reviewed and validated at this point Proceed to Section VII D VII C 2 Creating 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 forward From within the Catch tab choose New Batch End Day Today to create a new batch with the End Date matching today s date To create a new batch with the end date matching tomorrow s date select New Batch End Day Tomorrow create a new batch with the End Date matching yesterday s date select New Batch End Day Yesterday 40 Fea Remote SMP Site Data Entry Program 10 x File Repor
40. 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 POF comma delimited Excel Rich Text Format TIFF File Web Archive 142 saveas ad Save n exportbatch E m B Recent Documents rt ad Desktop Documents Computer File name arkHepart Iz save as MarkR eport sls Cancel EZ Percent Zoom Ihe Percent Zooms allows the user to select a zoom percentage to view report details on screen Daily Summary Report liq 4 of 2 b H 2 ae 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 New 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 batches may be sent If users do 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
41. Whitefish Mountain RT WE WA LW MW Notes e f 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 to indicate what this was in your comment s for the batch Catch Tab Special Species Code Click on the Special Species drop Special species down list and choose one of the Incidental following codes EF LF or HO EF Eroded firi s See Section VIII B 1 for a detailed LF Lyons Ferry discussion of each of these Special Hold over Species Codes Color Co 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 mE Mark Type The Mark Type drop down list includes choices for mL TOF what type of clip a fish has adipose adipose and e left ventral etc Use N A if individual condition pog Left Ventral fish does not have any type clip Pesaro AB Adipose Aight Ventral 3 Injury Elas Code The Elas Code drop down list includes choices for a fish with an Elastomer tag and its location EH Elastomer Aight Other UN Unknown Color Code The Color Code drop down list allows the user to choose the color of the
42. Windows XP with Service Pack or a newer version of Windows you do not need to install Microsoft NET Framework 3 5 Procedure to Install New Version of FPC32 net and Uninstall an Old Version VI C 1 Windows XP 4 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 From within the Control Panel select Add Remove Programs Internet Mozilla FireFox E mail Microsoft GFFice Outlook ES Gontrol Panel J My Documen File Edit View Favorites Tools Help Recent Back a ak Ha 2 Gack gt Search Folders 0 a Pictures Address gt Control Panel Windows Media Player e Music Mame comments ns s Accessibility Options Adjust your comput PE Compute m 33 Windows Messenger wI MSN Add Hardware Installs and trouble n i Mi Prog 5 Install or remove pr E Control Panel Administrative Tools Configure administr Set Program Ac Adobe version Cue C53 Adobe version Cue Defaults automatic Updates Set up windows to Dw Adobe Dreamweaver C53 ke Date and Time Set Ehe date time j Display Change the appear Microsoft Office Excel 2003 dels ene eura pj Folder Options Customize the displ E Fonts Add change and e Tour Windows Search Game Co
43. 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 Mark Recaptures Tab In the lower data grid the Sub batch 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 82 Ini xj File Reports Mark Recaptures Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch Sequence 2 Tank Trap Batch 10044 Species Code CH Chinook Code Mark Type ER Elastomer T ag Fight Brand Loc Brand Code M A hd Brand Orientation Tag Number Color N M Supplemental Cade Length Count 0 Count Total Count NETS 1 Sequens Terk PEST eee Wpe location orient number code Ke i Delete Record Count 1 1 Definitions and Data Entry Before any data can be entered or edited in the Mark Recaptures data entry tab the user must specify whi
44. data staff will investigate the error and try to remedy it as soon as possible SQL Server Express Service not found It is probably not installed Please reboot you PC before contacting technical support Error in starting the service Cannot open MSSQLSSQLEXPRESS service on computer X 5 SQL Server Express Service not Found It is probably not installed Please reboot you PC before contacting technical support 29 VI D 3 Default Display Settings In order for FPC32 net to display properly you must use the default Smaller text size in your Display Settings To change these settings in Windows 7 select Control Panel Display and make sure the Smaller 100 default setting is selected e m Control Panel All Control Panel Items Display Control Panel Home Make it easier to read what s on your screen Adjust resolution You can change the size of text and other items on your screen by choosing one of these options To B temporarily enlarge just part of the screen use the Magnifier tool Mj Calibrate color Change display settings Preview Adjust ClearType text Set custom text size DPI Medium 125 Larger 150 In order for the touch screen to display properly the resolution on the wet lab computers must be set to 1024x768 gt a gt SE aes H Control Panel All Control Panel Items Display Screen Resolution 4 S
45. does not have an Elastomer tag BL blue PU purple GR green RE red OR orange YE yellow Pl pink OT other CWT This field indicates the presence Y or absence N of a Coded Wire Tag Currently only LGR LGS and LMN examine all unclipped Chinook coho and sockeye 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 entering 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 addition to these conditions there are fields for the Weight and Length of each condition fish Predator This row is where any Predator data are displayed If any of th
46. etu tete tie de lute diei teint bend 19 PS CIVI ETT TIMES 19 9 Comimuniecauor DEVICES eui etie dime devia tu 19 VI B Procedure to Install the FPC32 net Program including the fish condition TOUGIN SOCED 19 Procedure to Install New Version of FPC32 net and Uninstall an Old Version 22 VEC WIRCOWS 22 VEO 23 VED Troubleshooting sees medio Eu UE RD 25 VI D 1 Windows 7 Procedure to Allow Full Control 25 VLD 2 Problems Witt SQL EXDIBSS oir Meet 26 MS SQL Server Database Could Not 27 Problem with SQL Express Service 28 Other Error Messages Related to SQL Express Service 29 VI D 3 Default Display Settings 30 VII Overview of 2 31 VILA EPOS2 net Settings Dialog BOX RE RS RR Us 31 VII B Entering Fish Condition Data Via the Touch Screen 34 VII B 1 Brief Overview of Steps to Entering Fish Condition Data via the Fish elt E E DO S 34 VII B 2 Exporting Daily Fish Condition Records from the Wet Lab Computer 37
47. 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 AS Ammocoete Unknown should be used for ammocoetes that are less than 70mm or that cannot be positively identified as AB or 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 distin guishing 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 70 consistent with the fall Chinook shown below Additionally holdover fall Chinook should be assigned as age 1 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 wider eyes smaller nose more sharp than yearling Spring Summer Chinook football sha
48. 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 AI F Summarize and Verify All Sample Data on Days Collected at Lower Granite Dam Milestone Al G Project Operations and Flow Data Collection SMP personnel at Lower Granite Dam will collect record and verify daily USACE 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 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 AK G Monitor for signs of GBT Trauma Collect samples and conduct exams according to FPC GBT program protocols Samples should be taken one to two times per week depending on site Collect PIT tag recapture information Milestone AO E Sample Fish Daily and Collect Data SMP personnel at Lower Monumental Dam will sample fish daily throughout the monitoring
49. 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 bypass 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 toward 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 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 use only 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
50. 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 and size A discussion of the morphological criteria can be found in Section VIII B 1 Chinook fry are age O 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 opecies 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 coho and sockeye fry based on size 60mm or less See Section 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 o
51. 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 112 L Orange L Y ellow L Pink L Other R Orange R Yellow R Pink cM ejesi om Sc RES CH1 AD CHO AD ST AD CO AD SO AD Touch screen species and conditions for LGR LGS and LMN Note LGR does not have Tank Buttons mity 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 113 Elastomer Location and Color If the condition fish has an Elastomer tag the user presses the appropriate Color Location button These buttons toggle on and off If a user selects a 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 T
52. on these changes see Section VII M 1 above e 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 62 Total Spill Total Spill is the average hourly spill Kcfs during the sampling period e This field is mandatory for BO2 JDA MCN RIS LMN LGS and LGR o This value is in row SPILL in the COE daily report e his field is not displayed at LEW WTB or IMN e 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 e AtJDA 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 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 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 Da
53. only The location of Elastomer tags is now designated in the Mark Type drop down list see above e Field validation logic checks to see what mark Brand N A d and Orientati DL Double Left LA Left Anterior LD Left Dorsal Tag Color lip Code I LE Let Eye type was entered An error message is displayed LP Left Posterior if the wrong location codes are used for the wrong PH Usually Anal Fin F RA Right Anterior Subbal S RD Right Dorsal RE Right Eye HP Right Posterior mark type e error message is also displayed if Mark Type is a Floy tag or a Visual Implant tag and data entry is attempted in this field VI Left or Right Brand Code This is for Freeze Brands i e Mark Type 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 o clock 2 6 o clock 9 o clock 4 e error message is displayed if the mark type is anything other than FB and data entry is attempted here 85 Tag Number This field is for Floy and Visual Implant Tags only i e Mark Type FL or VI If itis 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 Tag Color Tag Color
54. 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 Site Set in setting dialog Batch Computed based on system date Sequence For each batch the first incidental catch record sequence starts at 1 and continues sequentially Tank 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 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 88 Field Name Default Settings 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 Default is none Coded wire tao Default is none n 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 T
55. 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 completing 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 2 From the wet lab computer open Windows Explorer and navigate to where the daily batch XML files are saved 3 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 4 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 37 File Edit wiew Favorites Tools Help c E Search Fold
56. third party cookies that use personally identifiable Information without your implicit consent Restricts first party cookies that use personally identifiable Information without implicit consent Import Advanced defaut Web Sites To override cookie handling Far individual Web sites click the Edit button OF Cancel Ampy 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 145 e EJ O Bh Page Teak i iN SMOLT MONITORING PROGRAM FILE UPLOAD PAGE Upload File s log Out Choose Select to browse to the location of the files you wish to upload and click the OK button Once you have uploaded all the files you wish to upload click on the Upload File s 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 two types of files can be uploaded to this site FPC32 net files with the suffix XML and hand logs in PDF format If you accidentally attempt to upload a file in a format other than these two only the XML and PDF files will load and the results page will show you the number of XML and PDF 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 total size of the file
57. 0 0 0 0 0 0 0 Total Sample Count 3 1 6 0 0 0 0 4 1 0 0 0 0 0 0 0 0 0 0 15 Total Collection 300 100 600 0 0 0 0 400 100 0 0 0 0 0 0 0 0 0 0 1500 Sample Morts 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Facility Morts 0 0 0 0 0 0 0 0 0 0 0 0 0 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 0 0 0 0 PIT Tag Morts 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Num Bypassed 200 0 600 0 0 0 0 400 100 0 0 0 0 0 0 0 0 0 0 1300 Num Trucked 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Num Barged 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 of 0 0 Descaling Pctg 96 0 0 00 00 0 0 00 00 00 0 0 00 00 0 0 0 0 00 00 00 00 00 00 00 00 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 summarizes only Lyons Ferry and Holdover yearling fall 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 fis
58. 0 am and 7 00 am daily Smolts from the collection are sampled for counts by species and clipped unclipped status All unclipped yearling Chinook subyearling Chinook sockeye and coho are examined 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 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 7 00 and 7 00 daily Smolts are sampled 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 17 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 18 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 Requirements A
59. 011 11 45AM Directory BO 12 02 2008 01 52PM 206 692 864 dotnetfx35 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 901 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 TouchScreenSetup3 lamprey msi 08 26 2011 11 46AM Directory TrapRelease 05 04 2010 12 12PM 382 Version loq Double click on the SQLEXPR EXE file to begin the installation Follow all prompts and accept all default settings 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 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 21 VI C 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
60. 13 Num Trucked 14 Num Barged and 15 Descaling Pctg 129 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 l above Lamprey juveniles are not included in this report see Section IX B 8 below Page 1 FISH PASSAGE CENTER Date 1 13 2014 2 42 11 PM Site LGS DAILY BATCH TANK REPORT Batch 13364 from File LGS13364 XML Subbatch All Sample Start Date 12 29 2013 Sample Start Hour 0700 Sample End Date 12 30 2013 Sample End Hour 0700 Number of Hours Sampled 24 Sample Code 10 Avg Total Discharge 100 kcfs Avg Total Spill 50 kcfs Total Turbine Discharge 50 kcfs Comments Test of special species codes in new Daily Summary and Daily Tank Batch reports Tank A Chinook 1 Chinook 0 Steelhead Coho Sockeye Total UC CWT ICL CL UC EF CL luc CWT CL luc CWT CL Fry Non Cond Sample Count 3 1 6 0 0 0 0 4 1 0 0 0 0 0 0 0 0 0 0 15 Exam Desc Non cond 3 1 8 o o 0 4 1 0 o of of o o of o 15 Non cond Descaled 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Condition Sample Count 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Condition Descaled 0 0 0 0 0 0 0 0 0 0 0 0 0
61. 19 2015 2 18 2015 2 18 2015 2 13 2015 2 13 2015 2 12 2015 2 12 2015 2 12 2015 2 4 2015 1 30 2015 1 30 2015 1 29 2015 1 26 2015 12 19 2014 11 19 2014 8 28 2014 8 5 2014 8 5 2014 23 9 MB 74 0 MB 6 00 MB 16 5 MB 13 8 MB 21 4 MB 326 KB 82 9 MB 38 8 MB 126 MB 22 6 MB 1 33 MB 1 27 MB Version 7 10 2352 3 130 8 0 210 16 0 0 305 16 0 0 273 10 0 40219 10 0 40219 10 0 50903 1 0 0 35 0 1 35 0 1 4 5 51209 2015 0 5646 11010 5 1 20514 0 18 1 9 799 4 20 9876 0 4 20 9870 0 5 A dialog box appears asking you to confirm the removal of FishCondition3 choose Yes to uninstall FishCondition3 Follow the prompts to uninstall the program 6 After the program has been uninstalled follow the instructions for installing FPC32 net Section VI B above 24 Uninstalling FPC32 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 contact their system administrator See Section VI D 2 below if you encounter this problem VI D Troubleshooting FPC32 net VI D 1 Windows 7 Procedure to Allow Full Control When FPC32 net is installed on a machine with a 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 have found that this is often a permissions issue that can affect wh
62. 2 Species Code ST Tank Trap B Cwt OY Batch 09159 Sequence 74 Species choose Species Cade Special Species p a Miscellaneous Incidental Choose Species Code Mark Type Adipose Elas Code M A Color Code M Descaling Comment Weight af Length 170 Predator Bird Fish Lamprev Special Comment Injury Head Operc Bedy Fin c Fungus Columnaris Parasite Deformity 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 apply NOTE Detailed definitions of each of these diseases are provided in a separate manual Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch 2 Species Code 5 T Tank Trap Cwt OY ON None Batch U3138 Sequence 74 Species choose Species Code Special Species n a Miscellaneous Incidental Choose Species Code Mark Type AD Adipose Elas Code Color Code N A Descaling M A Gen Comment Weight aff Length 170 Predator Bird Fish Lamprev Special Comment Injury Eve E Fop Eye Fin Hemm PinkFin Discal Hemm Disease Fungus Colum
63. 5 0 0 0 Sample Morts 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 Facility Morts 0 0 0 0 0 0 0 0 0 0 0 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 0 0 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 from our SQL database This will be done weekly These spreadsheets should be checked against the data in your electronic batches discrepancies are found then follow normal reposting procedures see Section VILL Hows 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
64. 69 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 Sub Batch 1 Sequence 4 Tank Trap CH Chinook Species Code CH Chinook CO Coho U SN ow O SO Sockeye ST Steelhead eye AB Ammocoete Brook 0 Collection a n Ammocoete Brook AP Ammocoete Pacific Num 45 Ammocoete Pacific AS Ammocoete Unknown ee ig tic ee MP Macropthalmia Pacific D Facility Morts LU Lamprey Sp Unid O Priva LU Lamprey sp Unidentified NOTE 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 in which case it is entered as a sockeye in Catch Detail Use 450mm as the threshold
65. Batches You can edit only 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 net 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 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 re
66. Bypass Import to Truck Import to Barge Include Previous Day Delete Old Batches from Database Delete Prev Year Delete Old Delete All 1 You must choose whether you want the Fish Condition Touch Screen as the primary data entry screen To make the Fish Condition Touch Screen the primary entry screen select the Fish Condition Touch Screen Only checkbox see figure above i Computers located in the wet lab should be set to have the Fish Condition Touch Screen as the primary data entry screen upon opening the program ii 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 2 You must decide if you want to enable to AutoExport function To enable this function select the Automatically Export Last Selected Batch When Exit checkbox see figure above 31 i When this function is enabled all data that are stored in the SQL Express database will automatically be written to the XML file for the last selected batch and the program will close when exiting FPC32 net either from the Main Form or Touch Screen li If this function is not enabled the user will be prompted with a pop up asking them whether they want to exit without writing data to the XML file This prompt will only appear if newly entered data have not been written to an XML file prior to trying to exit FPC32 net FPC32 net has built in sounds that prompt u
67. C pro vides 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 operation information and analysis including current and historical data During the in river migration season FPC 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 833 3900 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 14 0 1 It has many improvements including a touch screen for entering fish condition data and the batch data entry is now done through for
68. 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 is 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 bel
69. D Y Y Y Y Start Hour The default start hour is carried forward from the Settings screen Section VII A If the listed Start Hour is incorrect enter the actual start hour in 24 hour military time Numbers less than 0000 or greater than 2400 are restricted from entry here 99 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 DD Y YYY End Hour The default end hour is carried forward from the Settings screen Section VII A If the listed End Hour is incorrect enter the actual end hour in 24 hour military time Numbers less than 0000 or greater than 2400 are restricted from entry here Trap Location This field is used only 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 e Lewiston Trap enter 0 or east when the trap is in its normal position 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 feet from the east tower that the trap is located at e g 175 or 175 Gear Code The default Gear Code is carried forward from the Settings screen Section VII 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
70. Elastomer tag rm Dark Green DO Dark Orange GR Green Mustard Orange Descaling The Descaling drop down list includes three choices for descaling including e Partial Descale for fish with descaling greater than background levels 296 596 but less than 20 e Descale for fish that are gt 20 descaled e Descale Predator for fish that are descaled and have clear predator marks NOTE If Descale Pred is chosen at least of the Predator check boxes should be checked see Predator Checkboxes below 94 D escaling Weight NAA 4 1 Partial Descale Predator 2 Descale 3 Descale Predator IPnnFvge I Fin Hemm Pink 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 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 targ
71. H 3 P E Telerik WinControls UL dll 11 6 20091 03PM DLL File 4 280 KB 1 x9 HistoricData Y E TelerikCommon dll 11 6 20091 03PM DLL File 624 KB spillemt 5012 Z 2 Right click on the folder named Data and select Properties This will open the Data 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 Object name C Program Files 86 Passage Center FishCc Object name C Program Files x85 Fish Passage Center FishCc Group or user names A Administrators PANAQUEZ2 VAdministrators A Users PANAQUE2 Users Trustedinstaller Group user names 58 CREATOR OWNER SYSTEM Administrators PANAQUE Administrators gt AR Users PANAQUE Users change permissions click Edit dit 8 Trustedinstaller Permissions for Users Full control Modify Read amp execute List folder contents Full control Read m Modify Read amp execute List folder contents Permissions for Users For special permissions or advanced settings click Advanced Read Leam about access control and permissions VI D 2 Problems with SQL Express Occasional
72. IENE 55 VII M 1 Daylight Savings Time Transitions 55 VII M 2 Sampling End Date is the Same for Two 56 Detailed Data Entry Instructions eese sees 57 VILA Catei aD cS 57 and Date ENUY iussis vitet epe Prae opcre tes 58 Bii neues 59 59 FO ANC 60 EO 60 ellos OC ROLE 60 SN Oe 60 COGS PE 60 SAMPES ROU E TOT 61 ERE LT 62 FIOW or Turbine DISCIIarge usisueensamgoa sich ruta eu mena cura Dru ed e eui euin 62 mutuo c 62 cre Mt 63 Comments1 and Comments2 63 VIII A 2 Editing Records in the Catch Data Entry Tab 63 Adjusting Batch Numbers and Creating Batches for Past Dates 63 Editing Older mf 69 1 EE LS 64 Removing a Batch Record from the Local Database 65 MIB Catch Detall TaD 67 VIII B 1 Definitions and Data Entry
73. Once the first record has been entered the user must press the Save New button to save the record 106 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 change 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 button 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 15 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 ed
74. Smolt Monitoring Program Protocol and FPC32 net Data Entry Program User s Manual Manual Version 2015 Season Produced by The Fish Passage Center Last updated 2 25 2015 Smolt Monitoring Program SMP Protocol ees 1 I A Introduction to the SMP sssssssssssessnnee emnes 1 I B Summary of Data to be Collected for the 5 2 1 Target Species and Species Identification 2 2 Species Specific Data to 2 nte 26 V ee eee 2 COGS MNT 2 Clipping Marking and Tagging 3 Descaling 1 nnne nnns 3 3 I B 3 Fish Sampling at Main stem Monitoring Sites 4 Sample Size T ana area Davus 4 Recommetidedaamble FIOlGS 4 Anesthetic GEM 5 mia M P 5 Il Introduction to 2 2 2 7 ILA TheFish Passage Center FIG seen 7 Remote SMP Site Data Entry Program 2
75. 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 Below is 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 End date User defined based on whether End Date Today or End Date Tomorrow selected Default start hour is set to 0700 can be edited in the Start hour Settings dialog box Default end hour is set to 0700 can be edited in the dialog box Trap location Traplocationisleftblank location is left blank Default gear code is set to GC can be edited in the settings dialog box Default sample code is set to 01 can be edited in the Sample code Settings dialog box Sample hours Default sample hours is set to 24 Hiver flow default is zero PH1 flow or Turbine Power house 1 flow default is set to zero 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 hours prior to the end date Format MM D
76. al 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 Y Chinook Adult AT Chinook Adult Chinook Adult Hatchery 9 Chinook Adult wild 41 Chinook Jack J5 Chinook Jack Hatchery Chinook Jack wild Chinook Minijack J3 Chinook Minijack Hatchery J2 Chinook wild Chiselmouth 80 Bass Large Mouth Peamouh Bass Small Mouth Bluegill and Pumpkinseed 50 Pike Minnow Northern Bullhead PI Salmon Pink juv Cap SR SandRoler ChannelCat SC AdultChinook SA Adult Hatchery Chinook SJ Adult Wild Chinook RS SgShinerRedside Chinook Jack 12 22in SP Siberian Prawn Chinook Jack Hatchery A4 SockeyeAdut __ A7 AB SK SN SG BU lU MU Sculpin species Shad Adult Shad Juvenile nj Sockeye Adult Hatchery y Steelhead Adult Wi BM BS BL BH CP OM A5 A9 41 Chi J Ch J4 J8 Chinook Minijack Hatchery _ J2 ChinookMinijack Wild
77. al 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 gt 24 is when Sample Code is gt 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 61 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 is optional at the SMP trap sites GRN IMN LEW WTB lf a trap site chooses to enter this value it is acceptable to use either 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 ftp nwd wc usace army mil pub project data 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 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 i
78. also be recorded If species ID is not 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 or None For these sites None denotes a group of fish that were sampled from the separator and NOT from Tank or Tank None for BO2 JDA LGR and RIS indicates that these sites have only a single tank At MCN use Tank None to denote raceway 10 The Trap code pertains only to site IMN Choose either A or B to designate trap il Incidental Catch Sub Batch 2 Sequence 1 Tank Trap 3B None Sample Code Validaton Alert Species Code Chinook 91 M OY CONIA Special Species n a hd ll Collection System Multiplier Sample Rate O02 Fat Cand
79. am Desc Hon cond Descaled Condition Sample Count Exam Desc Condition Condition Descaksd Total Sample Count Total Collecti di Sample Morts Facility Research Morte FIT Tau Mort Dezcaling n cole mor tm ele o ele co cole cea sle sce ele cole oa uls co cele ce cee cle sce oie 2 ele cele a c aules VII K 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 his writes the data in the local database to an XML file in the directory specified in the Settings see Section VII A e fan 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 53 2 End data entry each day by printing the Daily Summary Incidental Catch Mark Recaptures Fish Condition Daily Batch Tank All Sub batches and Lamprey Batch Tank All Sub batches 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 from the web see Section X B Remote SMP Site Data Entry Program xi File Reports Batch Info Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditio
80. ample 1 Improper Gear Code Sample Code Sample Hours CSO MMO IMATION OM 121 Example 2 Improper Species Special Species Combination 121 Example 3 Invalid Length Touch 122 Example 4 Improper Sample Code Sub batch Combination 122 IX A 2 Suspect Data Entry Alert Red Field in Data Review Grid 123 Example 1 Anomalous Length 123 IX A 3 Data Entry Error Message 123 Example 1 Flow and Spill Data 124 X Ac Date TAC IMIS 5 0 124 Examples Ea eus i e tones raa iron n a hue ceca 124 DCB EPOCS2 net 125 XB 1 125 IX B 2 Mark Recapture PReDOLE L ssec ioni sux Ets See Eu ue ROME coa RM ran EO 127 IX B 3 Incidental Catch a aa ai 127 Fish Gordillo 128 IX B 5 Individual Fish Condition 128 IX B 6 Daily Batch Tank 129 IX B 7 Special Species Daily Batch Tank
81. ample Count 2 0 0 2 0 0 0 0 2 Total Collection 1000 oof ool 1000 00 oo oof oo 1000 Sample 0 0 j 0 0 4 0 0 Facility Mats 0 0 0 0 0 0 0 0 0 Research Mars 0 0 0 0 0 0 0 0 0 PIT Tag Mats 0 j 0 0 0 0 0 Descaling Peig P3 00 oof oof 00 00 00 00 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 summarizes data only 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 131 1 FISH PASSAGE CENTER Date 2 13 2013 8 29 27 Site LGR LAMPREY BATCH TANK REPORT Batch 12177 from File LGR12177 XML Subbatch All Sample Start Date 6 24 2012 Sample Start Hour 0700 Sample End Date gt 6 25 2012 Sample End Hour 0700 Number of Hours Sampled 24 Sample Code E g Avg Total Discharge 83 48kcfs Avg Total Spill 25 18kcfs Total Turbine Discharge 57 85kcfs Comments Tank A Tank B Tank None Combination Batch e js m e Js p js v Non Cond Sample Count 0 0 0 0 0 0 0 0 0 14 0 1 0 0 14 0 1 0 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 0 0 0 0 0 0 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 00 3500 0 0 25 0 0 0 00 3500 0 0 2
82. an be used validation Some validation information is also provided in Section VII J above IX B 1 Daily Summary Report Remote SMP Site Data Entry Program Batch Daily Summary Mark Hecapture Incidental Catch Fish Condition Individual Fish Condition Report Daily Batch T ank Report Special Species Daily Batch Tank gt L ampreu B atch T ank k fring Total Discharge 100 Turb Discharge 50 This report is two pages with a landscape page layout The batch header information is found at the top of the Daily Summary Report This report does not separate condition and noncondition fish Target species salmonids and lamprey are split into four groups 1 CLIPPED TOTALS 2 UNCLIPPED TOTALS 3 LAMPREY TOTALS and 4 COMBINED TOTALS Each Species is represented by a separate column in the report The UNCLIPPED TOTALS section of this report includes a fry column for subyearling Chinook coho and sockeye fry Each column has several rows of data These rows are as follows 1 Sample Count 2 Collection Count 8 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 12 Descaling Pctg 125 1 Site LGS Sample Start Date Sample End Date Number of Hours Sampled 24 Comments CLIPPED TOTALS Sample Count Collection Count Num Exam for Desc Num Descaled Facility Morts Sampl
83. ank At LGS LMN and MCN choose or to designate the correct tank Choose to designate fish from the separator The Tank toggle has been turned off for LGR Species Code Click on the Species Code drop down species Code list and choose the appropriate species SN Enc code from the list 0 SO Sockeve ST Steelhead Special Species Code Click on the Special Species drop down list and choose one of the following codes 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 for Fry Age Code Age Code is used for Chinook only Choose 0 for subyearlings and 1 for yearlings 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 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 U
84. ank and Comments for each individual fish When the user selects Gen Comments a pop up 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 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 Cir 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 foggle on and off Once 114 Tank or Tank B is selected for a single fish that tank is carried on to subsequent fish until a different tank or sub batch is chosen by the user These Tank buttons are hidden for BO2 JDA and LGH When the user selects Special Comments a pop up 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 t i
85. arized condition data For example the records for the incidental species are promoted only to the Incidental Catch tab Clicking the Promote 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 VIII 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 a batch has been selected in the Catch tab you may navigate to the Summary Cond data entry tab Upon successful promotion the user will hear a prompt and see a red push pin icon in the upper right of the screen 100 1 Remote SMP Site Data Entry Program a ioj xj File Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site Catch Detail Sample Ssubbatch Sample Rate Editable z Sub Batches Sub Batches ane Promote All Batch 2 0 2 4 b 5 ubbat ank Spec D M mp Elast E 5 ubbat ED Species Cod pero 3 Code length samp Eye Fop ve
86. by the IMN Trap Enter A or B to designate trap Species Code Species Code Click on the Species Code drop down list and Unknown select the appropriate species code from the list box Only choose RT for Rainbow Trout if you encounter marked rainbow trout LI Coho AT Rainbow Trout SU Sockeye ST Steelhead 84 Age Code This field is to be used for Chinook only Click on 0 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 Mark Type Click on the Mark Type drop down list and select the type of external mark observed on a fish or group of fish with identical mark types attributes Current valid mark types are Mark Brand Cot EL Elastomer ER Elastomer f FB Freeze Brand gt FL Floy Tag PH Photonic Tag Supplement visual Implant Notes The location of Elastomer tags are built into the Mark Type code EL or ER You 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
87. ced 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 sizes of 300 to 500 fish when possible Typically Lower Columbia sites should limit sample rates to at or below 2596 except when increased numbers of fish may be needed for research or to address immediate management needs Avoid using sample rates between 12 and 2596 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 Daily Sample Multiplier Sample Subsamples Duration umber of Fish Collection Rate 1 sample rate Seconds Hour Per Hour sec in Sample Emergency 05 200 18 2 9 20 000 35000 15 666 54 4 135 300525 15000 00000 20 50 72 6 12 30040 10 000 15000 30 333 108 6 18 300 450 7 500 10000
88. ch batch she he intends 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 To create a new record in the Mark Recaptures data entry tab choose New his 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 83 Field Name Default Settings Set in Settings dialog box oequence For each sub batch sequence starts at 1 and
89. chScreenSetup3 msi or TouchScreenSetupS3 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 This program requires NET 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 Choose Yes 20 Te cetup exe Ld MEM Setup ese Windows Installer Package i 4 366 KB FPC32 NET This setup requires the WET Framework version 3 5 Please install the Framework and run this setup again The NET Framework can be obtained from the web ould wou like ta do this now Once the installation of this software is complete you will also be required to install Microsoft SQL 2005 Express Download Microsoft SQL 2005 Express from the FPC website ftp ftp fpc org FPCS32 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 C X FTP directory FPC32 net a X 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 2
90. 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 Disease Fungus Columnaris BKD Parasite Deformit Other 99 New Subbatch 3 Mew Tank Trap 2B Mone Update Subbatch Update Tank Trap Cancel 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 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 summ
91. cial 48 Species code EF and 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 Sub batches 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 NEW Although FPC32 net can now import collection counts into the Transportation tab it is still the responsibility of SMP personnel to verify that the collection counts match what is in the Daily Batch Tank Report 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 1 Due to the collection of fish for NOAA marking LGH is the only transportation site that cannot enter EF Steelhead separately Unclipped steelhead should be entered as a single record at LGH Page 2 Site LGS Subbatch Sample Code Comments Tank B Non Cond Sample Count Exam Desc Non cond Non cond Descaled Condition Sample Count Condition Descaled Facility Morts Research Morts PIT Tag Morts Num Bypassed Num Trucked Num Barged Descaling Pctg 96 UC AI 10 Test of special species codes in new Daily Summary and Daily Tan
92. 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 Eye Hemm Fin Discol Descaling These buttons allow the user to enter the following Descaling Conditions Partial Descale 2 5 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 If a button is pressed by mistake simply press it again to make that Predator type go away 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
93. cord 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 64 Remote SMP Site Data Entry Program laini File Reports Batch Info Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Start New Batch End Day Today Batch 99138 Mew Batch Gear Code Choose Gear Cot A End Day Tomorrow Sample Code Choose Sample Code Sample Hours News Batch Total Discharge Turb Discharge Total Spill kcFs End Day Yesterday Comments 1 Comments 2 Choose Comment METAM End date End Gear Sample Sample Hiver Phouse2 meen a pam emptied Cancel Dg 10044 2 12 2010 0700 2 13 2010 0700 24 09156 6 4 2009 0700 4 5 2009 0700 24 131 91 105 72 0 AE 10043 2 11 2010 0700 2 12 2010 0700 24 100 02 50 01 0 As Batch Import From Batch Delete Record Count 4 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 wish 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 transportation mark recap and catch detail records A dialog box appears asking you if you really want to delete the batch choos
94. creen Function Buttons 105 MR ER ERU UTD 106 err 106 hs S eee Eu E e are E EE 106 uu i EM M E E E S 107 Ce RI RR 107 POTS a eee AAA 107 107 PO VIOBIS 21MM 107 S inei 107 EX OOM Me P M 107 VIILH 3 Fish Condition Touch Screen Record Browsing Panel 108 E cR 108 SPECIES 108 E 108 CMC OG 108 Oe ee ee 109 UNTER 109 e 109 General COMMent 109 opecial GOIiell lam iem ter 109 n 109 et E 110 COMG EEE 110 BINNEN 110 Wo On UNUM 110 CMON TT 110 sj 110 Fy UC
95. d all collections will be imported to the Number Bypassed field Import to Truck imports all species information as above from Catch Detail plus the total collections for these species combinations If this option is checked all collections will be imported to the Number Trucked field Import to Barge imports all species information as above from Catch Detail plus the total collections for these species combinations If this option is checked all collections will be imported to the Number Barged field Include Previous Day if checked this button will import all species information from Catch Detail for the current and previous batch plus the total collections for these species combinations Where the collections are imported to will be dependent on which of the Bypass Trucked or Barge options is checked It is intended that this button will be checked during every other day transportation 33 5 he Delete Prev Year and Delete Old buttons delete the batches stored in the local database except the current day s batch These buttons should be used only to clean the database The Delete All button deletes all of the records in the local database 6 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
96. d falls within the criteria outlined in Section VIII F 1 Length This Red Dot is intended to serve only as a warning as all lengths entered can still be saved DE ight 4 5 6 Save New Length E 12 Q 1 3 0 Cancel si LGR pach 15048 2 17 2015 1 sequence 1 Example 4 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 different 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 gt Remote SMP Site Data Entry Program E 2B X File Reports Catch Detail Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch 2 Sequence 1 TankTrap B C None Sample Code Validation Alert Batch 11032 Species Code CH Chinook 91 90 Fin Clipped ON OY CON 9N A Special Species n a Gear Code GC Gatewell Collection System Multiplier EAE Sample Rate 0 0083 Mon Cond Al in Camnla 0 ES MEI
97. d logs can also be uploaded via the web To upload a new batch or hand log you must first navigate to http www fpc org smpupload uploadfile aspx 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 144 5 SMP FILE UPLOAD PAGE Windows Internet Explorer Joj qu in Frc Akko www fpc org smpuplaad SMP Posting asp X E Google B File Edit View Favorites Tools Help Gege e oe Ser Sonn ir Favorites pu Suggested Sites Earthlink Free Hotmail 4 Google Web Slice Gallery E d gt E Fec SMP FILE UPLOAD PAGE Fre SMP FILE UPLOAD PAGE X f E Safety A SMOLT MONITORING PROGRAM FILE UPLOAD LOGIN PAGE Lozin guest Password Internet Options Ei General Security Privacy Content Connections Programs Advanced Sethings 4 Move the slider to select a privacy setting for the Internet a gt zone Medium Blocks third party cookies that do not have a compact privacy policy Blocks
98. depending on site Collect PIT tag recapture information Milestone AL E 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 F Summarize and Verify All Sample Data on Days Collected at McNary Dam Milestone AL G Project Operations and Flow Data Collection SMP personnel at McNary Dam will collect record and verify daily USACE 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 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 AN G Monitor f
99. e EF and FH 3 Enter the Num Bypassed Trucked and or 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 nthe 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 4 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 ETE SMP Site Data Entry Program P mi x File Reports Transportation Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sequence Tank Trap 1B Batch 09138 Species Code Choose Species Code Age Code O1 a Fin Clipped OY OY OM None Special Species Choose Special Species Cade Mum Bypassed Mum Trucked Mum Barged Ll H If Ld OH AL FEL 1B ST 0 0 e 0 0 3 ST 0 0 Edit M 0 0 5A CH M 0 0 Delete OB CH N 0 0 Refresh CH 0 0 CH M 0 ag M 0 0 Record Count 19 VII I 2 UPDATED Importing Data from Catch Detail for Transportation Data Entry Tab If a user wishes to import data from Catch Detail to the Trans
100. e GL Gatewell Collection System Multiplier 5 20 0 0 2 Sample Rate Mon Cond n Est Cond Sample Count Collection Collection Mum exam T Mum Cond exam Mum Cond 0 0 0 Far descaled Num descaled for descaled descaled Exam Total For descaled Descaled 0 0 Cond Sample Count Total Sample Count 0 Total Collection 0 Sample Morts 0 Facility Morts 0 Research Morts 0 PITTag Morts Record Count 5 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 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 67 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 record 1 row o
101. e 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 65 Remote SMP Site Data Entry Program File Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Yew Batch End Day Today New Batch Gear Code End Day Tomorrow Sample Code Sample Hours i New Batch Total Discharge Turb Discharge Total Spill kcFs End Day Yesterday Comments 1 S 3 Save Record Comments 2 Start End Tra Gear Sample Sample River Phouse Phouse Batch Start date End date A PN hour hour locati code code hours flow 1 flo 2flow 5 Edit 09075 3 15 2009 0700 3 16 2009 0700 09082 3 22 2009 0700 3 23 2009 0700 GC 1 24 0 0 0 o Save As Batch Confirm Delete Import from Batch 3 Do you want to delete the 09075 batch Delete e Record Count 2 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 NOTE This does not delete the records from the FPC database it deletes the batch and it s supporting records only from your local database on your hard drive If a batch has been deleted by the user it can be re
102. e Morts Research Morts PIT Tag Morts Num Bypassed Num Trucked Num Barged Descaling Pctg UNCLIPPED TOTALS Sample Count Collection Count Num Exam for Desc Num Descaled Facility Morts Sample Morts Research Morts PIT Tag Morts Num Bypassed Num Trucked Num Barged Descaling Pctg LAMPREY TOTALS Sample Count Collection Count Chn1 P dalana e E Chn1 F ER e ES Page 2 Site LGS Num Exam for Desc Num Descaled Facility Morts Sample Morts Research Morts PIT Tag Morts Num Bypassed Num Trucked Num Barged Descaling Pctg SUMMARY TOTALS Sample Count Collection Count Num Exam for Desc Num Descaled Facility Morts Sample Morts Research Morts PIT Tag Morts Num Bypassed Num Trucked Num Barged Descaling Pctg Chn1 T S ec undas e amp rz FISH PASSAGE CENTER Daily SMP Summary Batch 13364 12 29 2013 12 30 2013 Sample Start Hour Sample End Hour Avg Total Discharge 100 kcfs 0700 0700 Total Turbine Discharge 50 kcfs Test of special species codes in new Daily Summary and Daily Tank Batch reports S 5 e ct ChFry B coBcooco oc ae e Pm 1 dac s 0 00 96 FISH PASSAGE CENTER Daily SMP Summary Batch 13364 140 0 oo 120 0 00 96 E Bud dud e 5 ce A T 5 S 5 5 0 00 96 160 0 oo oO NI 160 0 00 96 Date 1
103. e Total UC CWT CL JUC CWT Fry CWT CL UC CWT CL JUC CWT CL Fry 0 5 1 5 5 2 0 5 0 5 5 2 Descal 0 0 0 0 0 0 Condition Sample Count 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Condition Descaled 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Sample Count 0 0 0 5 1 0 1 0 0 0 0 5 0 2 1 5 0 2 1 23 Total Collection 0 0 0 100 20 0 20 0 0 0 0 100 0 40 20 100 01 40 20 460 Sample Morts 0 0 0 0 0 0 0 0 0 0 0 Facility Morts 0 0 0 0 0 0 0 0 0 0 0 Research Morts 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 Num Bypassed 0 0 0 100 0 0 20 0 0 0 0 100 0 40 20 100 0 40 20 440 Num Trucked 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Num Barged 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Descaling Pctg 96 0 0 00 0 0 0 0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 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 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 sub batch at a time or for all sub batches combined Validate no
104. e from a site several miles upriver that has standard phone access Milestone K Mark Tag Animals PIT tag wild steelhead hatchery steelhead wild Chinook and hatchery Chinook over the fish collection period at the Grande Ronde Trap 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 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 137 For the Salmon River Trap Work Elements AB AD and AF and Snake River Trap Work Elements AC AE and AQ the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 states the following Milestone AB E Operate Trap for Collection of Data SMP personnel at the Salmon River Trap will operate the 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 inju
105. e 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 109 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 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 hundred
106. e 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 78 VIII B 2 Editing or Deleting Catch Detail Records You can edit only 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 select
107. e value Multiplier Default is set from the Settings 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 Settings 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 68 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 l flamprey 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 10096 sample rate gear code of GC and tank none Any mortalities associated with these lamprey should
108. earch Control Pane File Edit View Tools Change the appearance of your displays Display Resolution Orientation Multiple displays Make this my Advanced settings Make text and othe What display setting IO 1024 x 768 gt 800 x 600 30 VII A FPC32 net Settings Dialog Box Once FPC32 net is installed an icon will appear on your desktop Double click on the Fish Condition icon on your computer desktop This opens the program By default the program is set to open to the Batch Data Entry P 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 This will open the Settings dialog box which allows the user to customize how FPC32 net operates on a particular machine and what some of the values will default to These settings can be changed whenever the user wishes 7 Fish Condition Touch Screen Only Warning Popup when Cancel Button is selected Automatically Export Last Selected Batch When Exit E Play Sound 9 Site Choose Site Code Gear Code Select Default Gear Code Sample Rate Sub 1 Select Default Sample Rate Sample Rate Sub 2 Select Default Sample Rate Default Start Hour End Hour Custom Commet CustomComment2 CustomComment Transportation Import settings Import Species Only Import to
109. ed record At this point edits can be made to the record Once edits are made choose the Save Record button 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 VIII 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 Poa Remote SMP Site Data Entry Program 15 x File Reports Incidental Catch Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond 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 car
110. eld that is currently in focus Exit Panel When the Exit Panel button is chosen a pop up menu will appear This pop up menu has three options Exit Hide Screen and Return Choose Exit to exit the touch screen and close the FPC32 net program Choose Hide Screen to close Hide Exit the touch screen and return to the Main Form Choose Return to return to the touch screen for additional data entry Screen If newly entered records have not been exported to the XML Return file before the Exit Panel button is pressed the pop up menu will have a warning message informing the user that newly entered records have not been exported to the XML file In this case if Exit is pressed the touch screen and program will close and newly entered records will not be exported to the XML file However if the user wishes to export newly entered records to the XML file simply press the Return button This will return the user to the touch screen where the Export button can be pushed to save all records to the XML file Warning You have not exported newly saved data to XML file Press Exit to exit program without saving data to XML file Press Return to retum to touch screen so data can be exported to XML file Exit i Hide Screen 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
111. ely 15 minutes or less Fry Handling Protocol It is recommended that fry Chinook Sockeye or Coho x 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 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 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 Fish Passage Center 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 Hiver Hydro electric System In addition to real time access to SMP data the FP
112. ence Tank A or None Clip Unciip Tally CH1 8 0 12 22 5 3 2 CO 0 7 2 50 1 4 025 0 IAP OMP 1 Total 24 31 Tank B Clip Unciip Tally CH1 13 CHO 12 ST 3 18 Total Incidental 3 Total Sampled 131 Species AP S Species Clip Code 7 8 9 Edit Delete CWT Gen Comment Spec Comment Weight 4 5 6 Next Prev Length 1 2 3 0 Site MCN Batch 11153 2 3 2012 S batch 1 Sequence 131 Touch screen for BON JDA and MCN incorporates condition monitoring for lamprey juveniles 104 co 10 11 Repeat Steps 4 through 9 for each subsequent fish 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 Condi
113. ence 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 VIII H 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 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 A and None and Tank 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 i
114. er 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 lf 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 will 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 If 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 does not matc
115. er these data This section also provides instructions on how data can be edited if when errors are found during data entry and validation For convenience all data entry tabs in the FPC32 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
116. ers Es E X i HB Address C Ufpc32 5509007 xml 1 7200 MIL Document ES 5509002 xml 1 21200 Document 05508347 xml Type XML Document 12 18 2 Document ka LGS08346 xml Date Modified 1 7 2009 10 20 AM 1271212 Document ka IMMOE339 xml Size 5 38 KB 12 112 Document default 5 3 12 5 20 WinwWwedge Configur deFaull1 5 V3 3115 20 wWin Wedge Configur E Boz 08340 xml 12 5 20 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 Atthis 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 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 charac ters 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 After another dialog box appears again hig
117. es 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 F G Monitor for signs of GBT trauma Collect samples and conduct exams according to FPC GBT program protocols Samples should be taken one to two times per week depending on site Collect PIT tag recapture information For Lower Grande Ronde River Trap Work Elements J L the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 11198 7 127 00 states the following Milestone J E Operate Trap for Collection of Data SMP personnel at the Lower Grande Ronde River Trap will operate trap 7 days week March 5 May 26 Collect data on daily catch hatchery and wild population composi tion 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 F Transmit Collection Data SMP personnel at the Lower Grande Ronde River Trap will electronically transmit salmonid collection data to FPC daily in a standard format determined by FPC This will be don
118. esponding Batch End Day button B atch B atch End Day Today End Day Today Batch Batch End Day Tomorrow End Day Tomorrow Batch End Day Yesterday Batch End Day Yesterday The Fish Condition touch screen then appears The background panel appears gray until you select New 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 the user to see more clearly when these data are entered into the program 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 Once 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 Enter the fish length using the touch screen number pad Using the number pad on the touch screen automatically
119. et 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 19 BON JDA Right click TouchScreenSetup3 lamprey msi and choose Save Target As Navigate to c installfpc32net and save this file to this directory C X 2 FTP directory FPC32 net a X 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 dotnetfx35 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 901 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 TouchScreenSetup3 lamprey msi 08 26 2011 11 46 Directory TrapRelease 05 04 2010 12 12PM 382 Version loq Once the files have been saved to your local hard drive using File Explorer navigate to c installfpc32net and double click on the Tou
120. et species Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS SubBatch 2 Species Code 57 Tank Trap B OY ON None Batch 09139 Sequence 74 Species choose Species Cade Special Species n a Miscellaneous Incidental Choose Species Code Mark Type AD Adipose Elas Code M A Color Code M aen Comment Special Comment PopEve Fin Hemm Pink Fin Fin Discol Hemm Disease Fungus Columnaris BED 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 95 61 to 250 CH1 61 to 250 61 to 350 61 to 200 _ 61 to 250 MP E AB 7 0 to 250 30 to 75 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 def
121. etailed 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 entitled Condition Sampling Protocol L B of Data to be Collected for the SMP 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 richardsoni ammocoete 4 unknown ammocoetes and 5 unidentified lamprey 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 2 Species Specific Data to Collect For each
122. ether SQL Express 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 C Program Files 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 Catch Info Table not found Unable to open the physical file C Program Files x86 Fish Passage Center FishCondition3 Data fpcFish_log I df Operating system error 5 5 Access is denied Cannot open user default database Login failed Login failure for user File activation failure The physical file name C Program Files x86 Fish Passage Center FishCondition3 Data fpcfish_log Idf may be incorrect Below is a brief description of how to remedy both these errors 1 Navigate to the directory C Program Files x86 Fish Passage Center FishCondition3 or C Program Files Fish Passage Center FishCondition3 25 a ji gt Computer gt Local Disk C gt Program Files x86 Fish Passage Center FishCondition3 gt X Sea
123. ew this report chose Reports and select Mark Recapture If Condition Data include Mark Hecapture data this validation step should be done prior to incorporating the condition data into the Mark Recaptures tab via promotion see Section VII H Remote SMP Site Data Entry Program E mi x File Reports Mark Recaptures Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch Sequence Tank Trap L Batch 09138 Species Code Choose Species C Age Code C Mark Type Choose Mark Type Brand Loc Choose Brand Brand Code Choose Brand Cade Brand Orientation Choose Brand Orien Tag Number Tag Color Choose Color Clip Cade Choose Clip Cade kd Supplemental Cade Length Count Cond Count Total Count Delete Note Cond Count and Total Count will be filled in automatically when Condition Data are incorporated into the batch see Section VII G 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 co
124. f 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 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 Settings dialog box oequence For each sub batch sequence starts at 1 and continues sequentially When a new sub batch is started sequence starts over at 1 Sub Batch Starts at 1 The value of sub batch for the next record is the same as the previous entry until the user changes the value Tank Default is none The value of tank for the next record is the same as the previous entry until the user changes the value opecies 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 Default is none This field is used only for Chinook opecial species Default is none code Gear code Default is none The value of gear code is the same as the previous entry until the user changes th
125. h you must change the sample rate in Catch Detail See Section VIII B 1 above for instructions on how to do this i SMP Site Data Entry Program mi xj File Reports Summary Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site sample Conditions Subbatch Sample Rate Editable es Sub Batches Sub Batches gt E T Promote All Batch 2 02 GC 1 0 01 09138 3 7 VIII H Fish Condition Touch Screen The Fish Condition Touch Screen allows users to enter individual fish condition data Double click on the FPC32 net icon to open the touch screen to enter fish condition records for a new batch with the Settings dialog Fish Condition Touch Screen Only checkbox checked The touch screen will open on the computer s desktop 102 To open the touch screen to enter fish condition records using an existing batch record with the Settings 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 Catch data entry tab and select the batch you want to work with Choose File Open Condition Touch Screen VIII H 1 Data Entry Sequence for the Fish Condition Touch Screen 1 Open the fish condition touch screen A dialog box appears with three buttons
126. h 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 is number of days 15 Sample of fish accumulated 5 days Samplecode minus 10 15 number of days 16 Sample of fish accumulated 6 days Samplecode minus 10 1 number of days 17 Sample of fish accumulated 7 days Samplecode minus 10 is number of days Comments 2 Normal Complete Sample 24 hours Two or more samples taken during a day with separator clean out 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 biased 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 7 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 the 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 N Il Sample Hours Enter the actu
127. h are already included in the tallies of Chinook 1 from the Daily Batch Tank Report see Section VII I above 130 1 FISH PASSAGE CENTER Date 2 32 2042 10 28 56 Site MEN SPECIAL SPECIES DAILY BATCH TANK REPORT Batch 11153 from File MCHN11153 XML Subbatch sample Stat Date 5 1 2011 Sample Start Haw 0700 Sample End Date Ear Sample End Hour 0700 GearCode 6 Sample Code 1 Number of Hours Samped 24 Avg Total Dischage 481 7 Total Turbine Dischage 143 4 kcls Avg Total Spk 333 6 Comments A Chino 1 HO Chino 11 Eus Uc jc CWT Non Cond Sample Count 0 0 2 0 0 0 2 Exam Desc Non cand 0 2 0 2 0 0 a 0 2 Non cond Descaed 0 0 j 0 0 0 0 Condition Sample Count 0 0 0 0 0 0 0 0 0 Exam Desc 0 0 0 0 0 0 0 0 0 Condition Descaed 0 0 0 0 0 0 0 0 0 Total Sample Count 0 2 0 2 0 0 0 0 2 Total 00 00 ue oo 00 1000 Sample Mats 0 0 0 0 0 0 0 0 0 Facility Mors 0 0 0 ol 0 0 0 0 0 Research Mars 0 j 0 i 0 0 0 j PIT Tag Mots 0 0 0 0 0 0 0 0 0 Descaling Peig oo oof oof oof oof oof oo 00 Tark 1 HO Chincck 11 Non Cond Sample Court 2 0 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 0 0 a 0 0 Condition Sample Count 0 0 0 0 0 0 0 0 0 Exam Desc Condit 0 0 0 0 0 0 0 0 0 Condition Descaed 0 j 0 0 0 0 0 Total S
128. he 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 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 Remote SMP Site Data Entry Program E m xj File Reports Batch Info Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Mew Batch End Day Today Batch 09138 New Batch Gear Code Choose Gear Code End Day Tomorrow Sample Cade Choose Sample Cade Sample Hours New Batch Total Discharge Turb Discharge Total Spill End Day Yesterday Comments 1 Comments 2 Choose Comment Batcl Start d End d E MERE ale date 09138 10044 2 12 2010 0700 2 13 2010 0700 09156 66 4 2009 0700 66 5 2009 0700 131 91 105 72 0 10043 2 11 2010 0700 2 12 2010 0700 100 02 50 01 0 Save As Batch Import From Batch Delete Record Count 4 58
129. herwise 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 oecond select the Catch Detail tab For a detailed description of data entry fields in the Catch Detail tab see Section VIII B below 41 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 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
130. hlight 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 Safely Remove Hardware XA Ta VII C Importing a Batch From the Condition Sample 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 Section 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 a new batch record can be created from within the Main Form see Section VII C 2 below 38 VII C 1 Importing Daily Fish Condition Records into FPC32 NET Main Form 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 forward 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 on next page The Main Form displays the batch from which fish condition records were just imported in the Catch tab Select the batch with the fish condition records you just im
131. idental 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 e mail to repost fpc org see above for further documentation VII M Special Situations VII M 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 Inthe 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 55 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 number for dates prior to the current date e Select Fi
132. ies Code Mark Type Adipose Elas Code Color Code N A Descaling Gen Comment Weight 25 6 Length 500 Predator Bird Fish Lamprey Special Comment Head Eve operc Body Fin Pap Eve Fin Hemm PinkFin Fin Discal Eve Hemm Disease Fungus Columnaris BKD Parasite Deformity 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 123 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 figure below In this case the user must click on the OK button and makes the proper correction before the record can be saved Sd LI murs Total Discharge 200 Turb Discharge 133 Total Spill kcfs 10 Comments 1 Data Entry Error X Comments 2 site LOS Turb Discharge
133. ill 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 133 Milestone Summarize and Verify All Sample Data on Days Collected at John Day Dam Milestone R G Collect 100 smolts for fish condition studies 100 smolts to be collected for fish condition studies for ongoing COE assessment Milestone R H Project Operations and Flow Data Collection SMP personnel at John Day Dam will collect record and verify daily USACE 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 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 For Rock I
134. ill optional as is the importing of collection data The default destination for collection data is determined in the Setting dialog box of FPC32 net Below is a brief explanation of what each of these settings does E Fish Condition Touch Screen Only Warning Popup when Cancel Button is selected Automatically Export Last Selected Batch When Exit Play Sond 90 Site Choose Site Code Gear Code Select Default Gear Cade Sample Rate Sub 1 Select Default Sample Rate Sample Rate Sub 2 0 02 Select Default Sample Rate Default Start Hour End Hour Batch Export Directory 2 2015 Batch Import Directory C Users bchockley Desktop emaii Custom Comment 1 Custom Commet Custom Comments Transportation Import settings Import Species Only Import to Bypass Import to Truck Import to Barge C Include Previous Day Delete Old Batches from Database 148 Import Species Only imports different combinations of Species Code Age Code Tank Special Species Clipped Unclipped and CWT from the Catch Detail tab If this option is checked no collections will be imported to the Transportation tab Import to Bypass imports all species information as above from Catch Detail plus the total collections for these species combinations If this option is checked all collections will be imported to the Number Bypassed field Import to Truck imports all species informat
135. ined length ranges that are used for data validation for target species e f an anomalous length is identified for an individual record as part of the validation process delete this 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 f 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 Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site L 35 SubBatch 2 Species Code 5T TankiTrap B Cut OY CON Batch 0159 Sequence 74 Species choose Species Cade Special Species n a Miscellaneous Incidental Choose Species Code Mark Type AD Adipose Elas Code M A Color Code Descaling M A Gen Comment Weight Irr Predator Fish Cer Special Comment Injury Head Eye Operc Bedy Fin Pop Eve Fin Hemm Pink Fin Fin Discol Hemm Disease Fungus Columnaris BKD Parasite Deformity 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 p
136. install 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 1 The TouchScreenSetup3 lamprey msi edition will be used by SMP site personnel at BON JDA and MCN 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 msi from the FTP site ftp ftp fpc org FPC32 net See Section 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 1 XI A Red Length and Weight Caution Dot The fish condition touch screen has an added feature that alerts users when an entered length or weight is outside the range of valid estimates For length this red caution dot will linger next to the length field in the data review screen until a valid length is entered However all lengths entered can still be saved The red dot is meant to serve only as a caut
137. ion as above from Catch Detail plus the total collections for these species combinations If this option is checked all collections will be imported to the Number Trucked field Import to Barge imports all species information as above from Catch Detail plus the total collections for these species combinations If this option is checked all collections will be imported to the Number Barged field Include Previous Day if checked this button will import all species information from Catch Detail for the current and previous batch plus the total collections for these species combinations Where the collections are imported to will be dependent on which of the Bypass Trucked or Barge options is checked It is intended that this button will be checked during every other day transportation 149 150 151 152 2 MANUAL ACKNOWLEDGEMENT FORM the undersigned acknowledge that have read the FPC32 net manual Name Please Print oignature Date Please copy this form and mail or fax a completed and signed form to Fish Passage Center Attn Brandon Chockley we Pp 847 NE 19 Ave Suite 250 agone Portland OR 97213 Fax 503 232 1259 153
138. ion that the currently entered length is not in the range of valid estimates see table for valid length estimates by species Species CH1 s Species Clip Code Code s Range Gen Comment CHO 1 CO 61 to 250 ST 61 to 350 SO 61 to 200 Predator Weight AS Other cond Length i Disease 12 Site LGR Batch 15048 2 17 2015 Sibatch 1 Sequence SO 70 to 250 AS 301075 For weight the red caution dot appears if an invalid weight is entered As with lengths all weights entered can still be saved The red dot is meant to serve only as a 147 caution that the currently entered weight is outside the range of valid estimates see table for valid weight estimates by species Species S Species Clip Code CWT Gen Comment Spec Comment Length Site BO2 Batch 15048 2 17 2015 Sibatch 1 Sequence XI B Added Functionality to Transportation Import Feature In previous versions of FPC32 net the Import button on the Transportation tab only imported summaries of species information from the current batch i e Tank Species Age Clip CWT and Special Species FPC2 net 3 15 0 1 has added functionality to add summarized collections to these data as well In addition collection and species information can now be summarized from two sample days to accommodate every other day transportation The use of the Import button is st
139. is BKD Parasite Deformity Other Select All Clear All Record Count 2 VII H 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 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 VIII 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 46 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 Sub batches 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 counts for condition fish will appear in the grayed area of Ca
140. is 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 VIII D 2 Editing 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 86 point edits 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 VIILE Transportation Tab The Transportation data entry tab is for transportation sites only i e LGR LGS and LMN and is intended for target salmonid species only Each record entered into the Transportation data entry tab is broken into groups based o
141. is provided by the SMP V E John Day Dam omolts 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 7 00 AM and 7 00 AM 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 period The primary function of this site for SMP is to PIT tag out migrating smolts V G Little Goose Dam omolts 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 7 00 AM and 7 00 AM daily Smolts from the collection are sampled for counts by species and clipped unclipped status All unclipped yearling Chinook subyearling Chinook sockeye and coho are examined 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 16 V H Lower Granite Dam omolts will be examined for various factors including species fin clips marking data and detailed fish condition data including descaling Fish f
142. iting a record 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 Settings 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 107 VIII H 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 JA species CHL 5 Species Clip Code AD Elast ER Color RE DwT Gen Comment Spec Comment Predator Fish Weight Injury Operc Other cond Fin Hemm Length Disease B Site LGS Batch 09138 5 batch 1 Sequence The Top Section in above figure 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 lette
143. k Batch reports FISH PASSAGE CENTER Sample Start Date Sample End Date DAILY BATCH TANK REPORT Batch 13364 12 29 2013 12 30 2013 Avg Total Discharge 100 kcfs Total Turbine Discharge 50 kcfs Date 1 13 2014 2 42 11 PM from File LGS13364 XML Sample Start Hour 0700 Sample End Hour 0700 Number of Hours Sampled 24 Avg Total Spill 50 kcfs Chinook 1 Chinook 0 Steelhead Coho Sockeye uc ry luc o 0 si 1 oo 1 ol 5 2 13 s of 2 o 0 5 1 o ol o s of 2 of s 2 o 0 o o o ol o of of of of o o 0 o o ol o of of o of o o 0 o o ol o of of o of o Fry Total Collection 0 0 0 100 20 20 0 0 100 40 20 100 40 20 Total 0 0 0 0 0 460 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20 0 0 0 0 100 0 40 20 100 0 40 20 440 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 00 00 0 0 00 00 00 00 00 00 0 0 VII l 1 Manual Entry of Transportation Data 1 button to add a record 2 combination for the record you wish to create 49 To create a new record in the Transportation data entry screen click on the New Enter the Tank Species Clip CWT and Special Species cod
144. le 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 JE Remote SMP Site Data Entry Program inl x File Reports Batch Info Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Batch 09138 February 2010 Sample Code Choose Sample Code Total Discharge Comments 1 10044 2 12 2010 0700 09156 6 4 2009 0700 10043 2 11 2010 0700 Import from Batch Delete Record Count 4 e his 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 Putthe actual end date and end hour in the Comments field o Putthe actual sample hours in the Sample Hours field o Putthe 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 96 The purpose of this section is to provide detailed information on the types of data that are entered into FPC32 net and how to ent
145. lection counts can also be imported from the Catch Detail tab to the Transportation tab This saves time as it is no longer necessary to enter every possible combination again However the user must specify whether data should be imported from the currently selected batch or from the current and previous batches i e every other day transportation See Section VII A Step 4 xi for more details on how to import species information and collection counts from Catch Detail to the Transportation tab 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 present 87 Remote SMP Site Data Entry Program lani xl File Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Batch 10044 Species Code CH Chinook Age Code 1 Fin Clipped OY 9 Cwt OY OM None Special Species n a Bypassed 0 Num Trucked Num Barged 0 Tank species Code Age Code Clip B Num Tucked Num Banged Import 4 Edit Delete Refresh iecord Count 1 To edit 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
146. ll 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 e Milestone N F Project Operations and Flow Data Collection SMP personnel at Bonneville Dam will collect record and verify daily USACE project operations and flow data and facility fish mortality within the bypass collection system Milestone N G Collect 100 smolts for fish condition studies 100 smolts to be collected for fish condition studies for ongoing USACE assessment Milestone Summarize and Verify Sample Data on Days Collected at Bonneville Dam e 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 e Milestone P G Monitor for Signs of GBT Trauma Collect samples and conduct exams according to the FPC GBT program protocols Samples should be taken one to two times per week depending on site Collect PIT tag recapture information Milestone R E Sample Fish Daily and Collect Data SMP personnel at John Day Dam w
147. ll g Windows Update Computer 4 From within Programs and Features select FishCondition3 and choose Uninstall File Edit View Tools Help Control Panel Home View installed updates fa Turn Windows features on or off Install a program from the network Uninstall or change a program To uninstall a program select it from the list and then click Uninstall Change or Repair Organize Uninstall Change Repair Uninstall this program GoToMeeting 7 10 2352 FishCondition3 S Java 8 Update 31 Adobe Flash Player 16 NPAPI EB Adobe AIR Name Microsoft Visual C 2010 x86 Redistributable 10 0 Microsoft Visual C 2010 x64 Redistributable 10 0 B Microsoft Visual Studio 2010 Tools for Office Runtim a GBT Net T Mozilla Maintenance Service Mozilla Firefox 35 0 1 x86 en US B Microsoft NET Framework 4 5 2 AvG 2015 BS Adobe Reader XI 11 0 10 Microsoft Silverlight AVG Security Toolbar MSXML 4 0 SP2 KB973688 MSXML 4 0 SP2 KB954430 Publisher CitrixOnline Fish Passage Center Oracle Corporation Adobe Systems Incorporated Adobe Systems Incorporated Microsoft Corporation Microsoft Corporation Microsoft Corporation Fish Passage Center Mozilla Mozilla Microsoft Corporation AVG Technologies Adobe Systems Incorporated Microsoft Corporation AVG Technologies Microsoft Corporation Microsoft Corporation Installed Size 2
148. llection System _ SS be Confirm Overwrite Sample Rate Maon Cond g Est Sample Count Collection Do vou want to ovewrite the sample rate O descale with 0 2 Total Sample Count Total Collecti For descaled Sample Morts 0 Facility Marks Age ubbat 5 Sequen wa th Lade Code asp iniri uL LL Cip d ul pli Record Count 2 Non Cond Sample Count Enter the number of non condition fish sampled This number includes sample mortalities e lf 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 10096 sample rate gear code of GC and tank none 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 be overwritten only if a sample rate of 10096 is chose
149. lumn 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 editing and instructions on group editing 45 2 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 Remote SMP Site Data Entry Program O x File Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site 65 Sub Batch 1 Species Code CH1 Tank Trap OB Mone OY ON OMA Batch 11026 9 Sequence 3 Species choose Species Code Special Species n a Miscellaneous Incidental Choose Species Code Mark Type Elas Code Color Code N A Descaling Gen Comment Weight Length Predator Bird Fish Lamprey Special Comment Injury Head Eve Bedy Fin Fin Hemm PinkFin Fin Discol Hemm Disease Fungus Columnar
150. ly uninstalling and reinstalling FPC32 net can occasionally lead to problems with SQL Express Over the years two different issues with SQL Express have occurred This section outlines procedures on how to remedy these two issues As usual the FPC data staff is available to support users should you need to use either of these procedures 26 MS SQL Server Database Could Not Open After uninstalling FPC32 net and installing a newer version a user may encounter an Error message stating that the MS SQL Server Database could not open and that the user should contact their system administrator Below is a procedure to properly uninstall Microsoft SQL 2005 Express A simple uninstall of Microsoft SQL 2005 Express is not enough and will not remedy this problem 1 Via the Control Panel uninstall FPC32 net and mssql server express 2 Download and install the MS Installer Clean Up Utility MS Installer Clean Up Utility msicuu2 exe can be downloaded from FPC FTP website ftp ftp fpc org FPC32 net C LE ftp tp fpcorg FPC32 net Getting Started Latest Headlines Google Gmail Favorites Index of FPC32 net Name Size Date Modified t parent directory Bo 8 26 11 11 45 00 AM L dotnetfx35 exe 41 0 kB 11 11 13 11 49 00 AM ih JDA 4 16 13 12 35 00 PM ih LGR 8 26 11 11 46 00 ih LGS 8 26 11 11 46 00 AM lh LMN 8 26 11 11 46 00 AM Manuals 2 21 13 3 51 00 PM ilh 8 26 11 11 46 00 AM m
151. ment why you are changing the batch and submit this documentation along with the batch preferably via FAX or e mail FPC WILL NOT UPDATE BATCHES UNLESS PROPER DOCUMENTATION IS RECEIVED You should also send a copy of this documentation to your project leader If FPC 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 833 3902 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 e mail sent to repost fpc org along with an explanation memo of why this batch is being resubmitted for reposting 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 these changes must be re promoted into the Catch Detail Inc
152. ms 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 FPC32 net program and corresponding with the FPC read and understand this manual If any questions arise please call Brandon Chockley at the Fish Passage Center 503 833 3907 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 FPC II B Personnel to Contact for Technical Help Brandon Chockley SMP Manager 503 833 3907 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 Jerry McCann CSS Coordinator 503 833 3909 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 Christopher McCarty Computer Specialist 503 833 3902 cmccarty fpc org Weekend number 503 851 1549 Contact Chris for computer hardware wind
153. n Num Exam for Descal The Num Exam for Descal is a calculated field Num Exam Descal Sample Count Sample Morts This equation assumes that 10096 of the non condition 75 sample excluding sample mortalities was examined for descaling If this is not the case you may enter the correct Num Exam for Descaling after entering the Sample Count and Sample Morts e f you overwrite the calculated value for Num Exam for Descaling this must be the last entry before hitting the Save New button e 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 the default Num Exam for Descal is O e Fry and Lamprey juveniles are not to be examined for descaling The default Num Exam for Descal is 0 when 1 Species Codes are AB AP AS or MP or 2 when Special Species is Num Descaled Enter the number of fish descaled from the non condition fish that were examined for descaling fish that has greater than 2096 descaling on one side is considered descaled e he 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 rea
154. n the clipping marking and or tagging of target salmonid species Below is a brief explanation of the various clipping marking and tagging information that are to be collected for the SMP See Section VIII B 1 and Section VIII D 1 for more information on these categories Fin Clips are recorded on all target 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 j
155. n Species Code Age Code Tank Special Species EF and FH 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 1 Definitions and Data Entry Before any data can be 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 manually 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 UPDATED 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 In addition col
156. n 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 52 n ea 2 2 I oo Page 1 FISH PASSAGE CENTER Date 1 2372012 3 24 35 Site LGS SPECIAL SPECIES DAILY BATCHITANE REPORT Bach 110 from File LG311088 SUbbatch gt All Sample Start Date 1 2011 Sample Start Hour Sample End Date gt Sample End Hour Gear Code GC Sample Code 1 Humber Hours Sampled 24 Total Discharge 111 45 Total Turbine Discharge T6 73 Aug Total Spi 54 04 kok Comments i i Chinook 1 Chinook 1 LF Grand Total Hon cond Sample Count Exam Desc Hon comd Descaled Condition Sample Count Exam Desc condition Condition Dez Total Sample Count Total Collection Sample Morts Facility Research Morts PIT Tad Mark Descaling 5 rn apa aa a2 2 2 slo cee a als ok slo 2 2E ck cls 25 gt 2 ck 2l 22 aja 2 a Tank Chinook 1 Chinonk 1 LF ur CL Total UC Total Grand otal Hon cond Sample Count Ex
157. n 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 111 Tank or None Clip Unciip Tally Tank and T ally CHI 0 CH 111 13 12 7 oe CHO 0 ST 2 ST la 4 0 2 CO Oy 0 50 19 4 SO D T I AB 0 AS 1 Total 124 1 Total 24 3 Tank B Elip LInclip T ally A Tank B Clip Unciip Taly E UM e CHI 130 7 CHO Oy 12 9 44 f ST 3 CO 0 1 11 50 Oy SO 4 3 9 Total B4 p 11 IAB 0 AS AP 1 MF 1 Special Species T ally Total 32 41 otal Tank B Mone 0 0 0 Soecial Species Tally ela E Tatal EF 0 1 0 Total Ho 0 0 0 88 8 ol Total LF 0 0 Total Incidental e Total Incidental 3 Total Sampled 215 D Total Sampled 131 Touch screen tallies Touch screen tallies for BON for LGR LGS and JDA and MCN incorporates LMN lamprey juveniles VIII H 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
158. naris 5 DbeFormity 98 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 Color Code pecial tormenti Mark Type AD Adipose Elas Code Descaling Weight af Length 170 Predator Bird Fish Lamprev Injury Operc Bedy Pop Eve Fin Hemm Pink Fin Fin Discol Hemm Disease Fungus Columnaris BED Parasite Deformity Other VIII F 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 screen is populated with that record s data At this point edits can be made to the record Edits should be made to these records only 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
159. ncel 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 42 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 DTI SMP Site Data Entry Program Bl x File Reports Catch Detail Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch Sequence 3 Tank Trap 6j Batch 11026 Species Code CH Chinook Age Code Fin clipped OY ON Special Species n a Gear Code GC Gatewell Collection System Multiplier 5 20 0 0 2 Sample Rate Mon Cond Est Cond Sample Count 0 Collection 0 Cond Sample Count Collection Mum exam Cond exam
160. nclipped and CWT combination See 89 Section VII I for 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 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 VIII E 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 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 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 VIILF 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 con
161. nde Ronde River Trap GRN For the remainder of the document these sampling sites will be referred to as Main stem Monitoring Sites or Trap Sites This protocol is meant to complement the Condition Sampling Protocol and provides overall guidelines for sampling and data to collect The primary data gathered at these SMP sites are count data on juvenile salmonids and lamprey that are sampled from the bypass system or trap These target species are identified by 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 or at traps 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 that is needed from a particular site For the full sample at all sites 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 mainstem monitoring sites conduct d
162. ns Summary Cond Site LiR Hour New Batch End Day Today Batch 09041 Hour Mew Batch Gear Code Choose Gear Cade End Day Tomorrow Sample Code Choose Sample Code Sample Hours i CENE Total Discharge Turb Discharge Total Spill cfs ree Comments 1 Comments 2 Batch Start date start End date End Trap sample Sample River Phouse Phouse hour hour locati code code hours flow 1 2 5 um 09041 0700 2 10 2000 07000 1 24 0 o 0 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 Do you want En ovewrite the File CALGROS041 xml e Delete Record Count 2 4 You must also send your hand logs to the Fish Passage Center Hand logs can be sent via Fax to 503 232 1259 e mail to smp fpc org or uploaded via the web see Section X B for uploading instructions e E mailed and uploaded hand logs must be sent in PDF format If e mailed they can be sent in the same e mail as the batch file i e XML file e f you cannot send the batches 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 54 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 below If you wish to resend a batch you must docu
163. ntrollers Add remove and c Driver Control Ehe graphic 177 Run Internet Options Configure your Inte All Programs gt gt Java Java TM Control cum Keyboard Customize your key oa Microsoft Office Cu ley Mouse Customize your mo Network Connections Connects En other c Phone and Options Configure your tele Th Power Options Configure energv s Printers and Faxes Shows installed prin QuickTime Configures QuickTi Regional and Language Options Customize settings S Scanners and Cameras Add remove and c E Scheduled Tasks Schedule computer Install or remove programs and Windows components From within Add Remove Programs select Fish Condition3 and choose Remove 22 Add or Remove Programs aa in x Change or Remove Programs 5 Add Mew Programs ic Add Remove Win dows Currently installed programs and updates Security Update Far 2007 Microsoft Office System 2 84 63 Security Update Far 2007 Microsoft Office System KB2553090 Update Far Microsoft Office 2007 suites KB2596789 32 Bit Edition Security Update For Microsoft Office PowerPoint 2007 KB2596843 32 Bik Edition Security Update Far Microsoft Office 2007 suites KB2596785 32 Bit Edition i ConsoleImportTdgs amp u Dimension 4 55 0 Show updates Sort by Name
164. o 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 VII 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 VII K below vii The Batch Import Directory button 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 viii If 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 32 in the e mail dialog box in the settings screen It is NOT mandatory that sites do this 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 th
165. o 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 selected for each fish If the wrong species button is pressed simply press the correct species button to overwrite the mistake 117 Fish Condition Touch Screen species codes for ALL sites Li EXE Additional species codes for lamprey juveniles at BON JDA and MCN The Special Species buttons include 1 HO for yearling Chinook holdovers 2 EF for eroded fin
166. ollection Ron dns Descaled Sample Morts Facility Morts Record Count 5 IMPORTANT The Cond Sample Count Num Cond 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 of data entry fields in the Transportation tab see Section VIILE 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 and potentially their associated collections 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 Hegardless of whether you use the manual entry or import function you must know what your collection counts were for each Tank Species Clip CWT and Spe
167. or TAG Clip Supp Length Total 1 CH 1 EL GR AD 142 1 1B CH 1 EL 5 RE AD 137 1 1B CH 1 ER 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 Total Chin Stlhd Recaptures 3 REPORT COMPLETED NORMALLY IX B 3 Incidental Catch Report The Incidental Catch Report is the same as 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 PASSAGE 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 Peamouth 1 0 PE Perch 1 0 SK Stickleback 1 1 Total Incidental Catch 4 Total Incidental Mortalities 1 127 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 sam
168. or signs of GBT trauma Collect samples and conduct exams according to FPC GBT program protocols Samples should be taken one to two times per week depending on site Collect PIT tag recapture information For Little Goose Dam Work Elements D F the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 states the following Milestone D E 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 136 periods of low fish collection August to October 24 hour daily samples may be held and sampled every other day Milestone D F Summarize and Verify All Sample Data on Days Collected at Little Goose Dam Milestone D G Project Operations and Flow Data Collection SMP personnel at Little Goose Dam will collect record and verify daily USACE 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 Corps project operations flow data fish transport numbers facility mortaliti
169. ow 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 VII B 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 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 34 Day Yesterday button creates batch with the end date matching yesterday s date The Batch End Day Tomorrow button should be used only if a sample is being worked up early The Batch End Day Yesterday button should be used only 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 corr
170. ows and software setup technical problems i e problems with computer hardware errors and issues Lynnae Sutton Data Management Specialist 503 833 3904 lsutton fpc or Weekend number 503 720 8205 Contact Lynnae for questions about how to enter data or information about using FPC32 net and about how to use site specific database management tools Main Line Voice 503 833 3900 Leave a message at the front desk for other questions not identified here Correspondence Fax for hand logs 503 232 1259 Main SMP E mail for batches and hand logs smp tpc org Reposting E mail repost fpc org GBT E mail smp fpc org FTP site ftp fpc org Web site www fpc org Mailing Address 847 NE 19th Ave Suite 250 Portland OR 97232 SMP Remote Site Facilities and 2015 Dates e Bonneville Dam Powerhouse 1 Pacific States Marine Fisheries Commission e Bonneville Dam Powerhouse 2 2 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
171. ped 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 for Fin Clipped OY 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 yearlings coho and sockeye for coded wire tags Cwt OY IN N A For unclipped Chinook coho and sockeye choose for those with CWT and 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 71 Special Species Code Click on the Special Species drop AgeCode 91 20 down list and choose one of the Special Species n a following codes FR EF LF or HO Select Sample R EF Eroded At all sites choose FR for Fry if the sample count Fem 0 fish is 60mm or less This code should Num Cond Do be used only for Chinook coho or For descaled vues sockeye as these are the only species that have fry If Chinook i
172. ple 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 Eye Hemm Pop Eye Fin Hemm Pink Fin and Fin Discol 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 File MCN11153 XML CLIPPED TOTALS Chn1 Chn0 St Coho Sock Total Num Sampled 21 24 6 0 5 56 Descaling 20 or greater 1 0 1 0 0 2 Injury 0 0 1 0 0 1 Predation 2 1 0 0 0 3 Disease or Parasite 0 0 0 0 0 0 Total with conditions 2 1 1 0 0 4 UNCLIPPED TOTALS Chn1 Chn0 St Coho Sock PacAm BrkAm SmAm Total Num Sampled 7 31 5 13 13 3 2 2 2 T8 Descaling 2096 or greater 0 0 0 1 1 2 Injury 1 1 0 1 1 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 1 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 o
173. ponder 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 Whitebird Lewiston Imnaha and Grand Ronde The PIT tag is a small glass cylinder approximately 1mm in diameter and 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 e mail failure and erroneous data entry that was not picked up by the error checking algorithms 12 Separator This is part
174. port the different combinations of Tank Species Age Clip CWT and Special Species from the Catch Detail tab to the Transportation tab Enter the Num Bypassed Num Trucked and or Num Barged for each Tank Species Age Clip CWT and Special Species EF and Fry combination 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 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 I 2b Importing Species and Collection Data This option works when Import to Bypass Import to Truck or Import to Barge are selected in the Transportation Import Settings portion of the Settings dialog box 1 Push Import to import the different combinations of Tank Species Clip CWT and Special Species and their collections from the Catch Detail tab to the Transportation tab 2 validate the collection data 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 genera
175. portation tab they must first decide what data they want to import Users can choose to import only species data i e Tank Species Age Clip CWT and Special Species EF and Fry combinations or species data and collection totals see Section VII A Step 4 xi on the possible settings for this Import function Regardless of which option a user chooses the user can import data from Catch Detail to the Transportation tab by pushing the Import button on the Transportation tab e Only target salmonid species are imported from Catch Detail Lamprey juveniles are NOT to be entered into the Transportation tab 90 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 Eroded fin steelhead at LGR will be imported as Unclipped steelhead as LGR cannot know how many EF steelhead were collected e possible to import species information and or collections from the current batch or from the current and previous batch i e every other day transportation If you wish to have these data imported from both the current and previous batches select Include Previous Day in the Transportation Import Settings portion of the Settings dialog box VII I 2a Importing Species Data Only This option works only if Import Species Only is selected in the Transportation Import Settings portion of the Settings dialog box 1 Push Import to im
176. ported by clicking on the record in the data grid Selected records have an arrow beside the batch 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 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 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 to 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 For a detailed description of each of these fields and what types of data should be entered see Section VIII A 1 below 39 Lai Remote SMP Site Data Entry Program EH Oj x 2 File Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site BO2 New Batch End Day Today Batch New Batch Gear Code Choose Gear Code End Day Tomorrow Sample Code Choose Sample Code v Sample Hours Mew Batch End Day Yesterday Total Discharge PH 1 Flow PH 2 Flow Total Spill kcFs Comments 1 Choose Comment Batch Start date Start End date End Gea Sampe Sample Hiver Phousel Phouse2 P LLL how a location code code hours flow
177. r Finally holdover fall Chinook are typically observed in April and May The figure below compares a yearling Sp Su Chinook top to a holdover yearling fall Chinook bottom Size morphology and timing are useful for identifying fish 72 NOTE If fish do not meet the above mentioned criteria contact FPC for instructions as to which code is appropriate Gear Code Gear Code will be carried forward Gear Cade IC Gatewell Collection System Multipl into the Catch Detail data entry tab Unknown 0 4 from the Catch data entry tab Most sample cour 00 Sample often it will not need to be edited on lut Fc Facility Sample the Catch Detail data entry tab GB Separator for However some sub batches will require a separate Gear Code e g GBT samples To change the Gear Code click on the drop down menu and select the 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 be used only on days when no sample was taken Multiplier and Sample Rate of Multiplier Sample Rae 01 choose the sample ra e 200 0 5 0 005 two ways First the Multiplier Collection 0 6 0 006 drop down list provides a list of m descaled 149 3 0 67 0 0067 some of the more common 143 0 7 0 007 sample rates from which users EIE TOS may choose
178. r 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 For a detailed explanation of each of the Species Codes see Section VIII B 1 Target Species and Section VIII C 1 Incidental Species above 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 ventral 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 108 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
179. rage 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 F Transmit Collection Data SMP personnel at the Snake Hiver 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 AE Mark Tag Animals Operate a scoop trap on the Snake River at Lewiston This trap is operated 7 days week Begin trap operations in early March and end operations in late May for SMP purposes For purposes of survival estimation in weeks when large numbers of smolts are passing PIT tag weekly blocks of 600 fish for each species and rearing type possible 138 e Milestone AG A Transmit of Project Data SMP personnel at the Snake Hiver Trap will transmit electronically PIT 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 weekdays and or critical weekends via FPC32 Advise and discuss problems with FPC when they occur 139 140 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
180. rch FishCondition3 File Edit View Tools Help Organize Include in library v Share with Burn New folder HE e ux Name Date modified Type Size 1 EE Desktop Data 2 18 2015 2 31 PM File folder 4 E Recent Places _ condclipcodes xml f 24252 t Y i 1 KB Date created 2 18 2015 2 31 PM f Ji Downloads amp FishCondition exe Size 3 16 MB ion 2 940 KB FishCondition exe config Files brandcodes xml brandloccodes xml nfiguratio 4 KB Libraries s FPC32PSTClassLibrary dll 2 6 2015 3 38 PM DLL File 427 KB Documents new fpc logo ico 5 26 2011 3 37 PM Icon 107 KB 1 d Music 9 Telerik Reporting dll 11 4 2009 6 27 PM DLL File 2 836 KB i Pictures E Telerik ReportViewer WinForms dll 11 4 2009 6 27PM File 160 KB 1 B Videos 9 Telerik WinControls dll 11 6 20091 03PM DLL File 1 784 KB 1 E Telerik WinControls GridView dll 11 6 2009 1 03 PM DLL File 1 176 KB 1 Computer E Telerik WinControls Themes Aqua dll 11 6 2009 1 03 PM DLL File 1 396 KB E amp Local Disk C E Telerik WinControls Themes Breeze dll 11 6 2009 1 03 PM DLL File 1 376 KB 1 amp CurrentData MOBYDICK G E Telerik WinControls Themes Office2007B 11 6 2009 1 03 PM DLL File 1 580 KB P css Sql main4 new H E Telerik WinControls Themes Office2007Si 11 6 2009 1 03 DLL File 1 372 KB G wwwroot SWORDFISH 3 E 9 Telerik WinControls Themes Telerik dll 11 6 2009 1 03 DLL File 1 192 a ftproot SWORDFIS
181. rder 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 128 1 FISH PASSAGE CENTER Date 2 2 2012 1 38 54 PM Site MCN Individual Fish Condition Report Batch 11153 from File MCN11153 XML Sub Special Elast Disease Parasite Injuries Predator Other Conds Descaling Batch Tank Seq Species Species Clip Loc Color CWT Weight Length FU co DE fon El PB PL FH FP FD EH PD DS DP 1 A 1 CHO AD 58 80 1 2 AD 116 100 1 3 108 101 AIA A CHT 0 00 P 5 CH0 fj 10 PL 1A 6 SO 208 18 1 7 lAD 105 98 PL 1 8 ST AD 614 18 ll O O 9 ao 458 174 _ 10 CHO a e 11 CHO 95 98 o iA 12 AD 339 14 PL DS f cH 25 6l 1 14 102 9
182. red 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 11 Julian 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 Hiver 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 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 1 one over the sample rate or 1 sr Pick List Drop down menu List Box or any pop up menu which uses a scrolling highlighted bar to mark the desired choice PIT tag Passive Integrated Trans
183. redator or predators check all of the boxes that apply 96 NOTE Detailed definitions of each of these predator conditions are provided in a separate manual Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch 2 Species Code ST Tank Trap B Cwt OY OM Batch 09159 Sequence 74 Species choose Species Cade Special Species pna Miscellaneous Incidental Choose Species Code Mark Type Adipose Elas Code M A Color Code Descaling Gen Comment Weight af Length 170 Predator Bird Fish Lamprev Special Comment Injury Head Eve Operc Bedy Pop Eye Fin Hemm Pink Fin Fin Discol Eye Hemm Disease Fungus Columnaris BED 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 pro
184. ree text boxes Any text that is entered into these text boxes will automatically show up in the Comment2 drop down menu Sites can enable a warning pop up when the Cancel button on the touch screen is pushed Since Cancel and Save New buttons on the touch screen are close together it is possible that a user may accidently press Cancel when he she meant to hit the Save New button Depending on the sequence of data entry this could lead to the loss of data for the most recent condition fish To prevent this potential loss of data we now allow the user to decide if he she would like to see a warning pop up when the Cancel button is pushed To enable this pop up simply check the Warning Popup when Cancel Button is selected check box in the Settings dialog NEW We have added a Transportation Import Settings section the Settings dialog box These settings are important for those transportation sites that wish to use the Import button in the Transportation tab of the Main Form Below is a brief explanation of what each of these settings does Import Species Only imports different combinations of Species Code Age Code Tank Special Species Clipped Unclipped and CWT from the Catch Detail tab If this option is checked no collections will be imported to the Transportation tab Import to Bypass imports all species information as above from Catch Detail plus the total collections for these species combinations If this option is checke
185. ried over from the Catch data entry tab The user 79 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 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 the fields and instructions of the types of data that should be entered into each field and how Field Name Default Settings Set in Settings dialog box Computed based on system date oequence 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 tot
186. ring 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 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 famortality is externally marked elastomer tagged or freeze branded the following steps must be taken o Enterthe 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 76 entered as Facility Mortalities Assigning these mortalities as Facility Mortalities should be approved by The Fish Passage Center NEW All sample mortalities should be scanned for PIT tags If a PIT tag is present these records should be
187. rom the general population are obtained from a timed sub sample of fish diverted from the bypass channel during a 24 hour interval between 7 00 AM and 7 00 AM daily Smolts from the collection are sampled for counts by species and clipped unclipped status All unclipped yearling Chinook subyearling Chinook sockeye and coho are examined 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 7 00 am and 7 00 am daily Smolts from the collection are sampled for counts by species and clipped unclipped status All unclipped yearling Chinook subyearling Chinook sockeye and coho are examined 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 7 0
188. rts at 1 The value of subbatch for the next record is the same as the previous entry until the user changes the value Tank Trap Default is none The value of tank for the next record is the same as the previous entry until the user changes the value 91 Field Name Default Settings opecies 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 Coded Wire Tag opecial species Default is none code Elastomer code Default is none Color code Default is none Descalina 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 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 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 Settings 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
189. ry and mortality rates Milestone AB F Transmit Collection Data SMP personnel at the Salmon Hiver 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 AD Mark Tag Animals Operate a dipper trap on the Salmon Hiver at Twin Bridge at Whitebird Put the trap in sampling mode by 6 00 PM Sunday nights and process collections at 7 00 AM Mondays through Fridays Operate trap until finished processing fish sample on Friday Begin Trap operations in early March and end operations in late May for SMP purposes For purposes of survival estimation in weeks when large numbers of smolts are passing PIT tag weekly blocks of 600 fish for each species and rearing type Milestone AF A Transmit of Project Data SMP personnel at the Salmon Hiver Trap will transmit electronically PIT 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 weekdays and or critical weekends via FPC32 Advise and discuss problems with FPC when they occur Milestone AC E Operate Trap for Collection of Data SMP personnel at the Snake River Trap will operate the trap 7 nights week March 5 May 26 Collect data on daily catch hatchery and wild population composition descaling recaptures of PIT tagged parr and ave
190. s up to 999 9 grams Weight is not mandatory at BO2 or JDA Length The Length field holds the length in 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 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 Batch The Batch field is where the Batch number is displayed This batch number is a five digit number 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 110 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 Sequ
191. s 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 Injuries as the fish has Definitions and examples of these Injury conditions can be found in the Condition Sampling Protocol document 115 Miscellaneous Conditions These buttons allow the user to enter the following Miscellaneous Conditions Eye Hemm Pop Eye Fin Pink Fin and Fin Discol These
192. s that are uploaded Currently the total upload is limited to 32 Mb If you are having trouble uploading an XML or PDF file check the file sizes If the file is larger than 32 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 three ways to do this e Fax Hand logs can be faxed to FPC at 503 232 1259 e E mail Hand logs can be e mailed as an attachment to the FPC E mailed hand logs must be in PDF format and should be sent to smp fpc org E mailed hand logs can be sent in the same e mail as the batch file i e XML e Upload Hand logs can be uploaded via the web at http www fpc org smpupload SMP The procedure for up loading hand logs is the same as that outlined for uploading XML batches see Section X B Uploaded hand logs must be in PDF format 146 In 2015 the 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 To make sure you are running the most up to date version and edition we suggest that all sites un
193. s 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 flow in Kcfs through Powerhouse 1 during the sampling period of the batch e This field is mandatory for BO2 JDA MCN RIS LMN LGS LGR o Obtain this daily number from the COE at the project o For BO2 obtain this value by subtracting BON 2 AVG DISCH from AVG TURB DISCH on the COE daily report e his field is not displayed at WTB IMN LEW GRN e 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 e AtJDA 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 15 displayed e 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
194. s the species code then 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 Hiver sites The 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 spring releases of hatchery yearling fall Chinook Size alone is not a fool proof indicato
195. ser to save all data that are entered by the user regardless of whether the data 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 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 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 Remote SMP Site Data Entry Program mJ lt File Reports Catch Catch Detail Incidental Catch Mark Recap
196. sers 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 Set your default settings for your particular SMP site Default settings can be entered for 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 ii Gear Code enter a default gear code by selecting a 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 O 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 trap location the trap location field appears in the site configuration screen otherwise it does not vi 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 t
197. 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 lf this length is incorrect press the Clear Length button on the touch screen and then re enter the correct length 35 Tank and None Clip LInclip T ally CH1 0 0 CHO 0 0 ST 0 0 CD 0 0 50 0 0 Total 0 0 Tank B Clip LInclip T ally CH1 0 0 CHO 0 0 5 07 0 co 0 0 SD D 0 Total D 0 Special Species T ally Tank B None TotalHo 0 0 0 Total EF 0 0 0 Total LF 0 0 0 Total Incidental 0 Total Sampled Please enter Tank Trap Tank Trap Q S Species Clip Code CWT 7 8 9 CE Edit Delete Gen Comment Elast Color Spec Comment Length Next Prev Exit 1 2 3 0 Export Injury Dther cond Disease Site LGS Batch 10044 2 13 2010 S batch 1 Sequence 1 Tank or None Clip Unciip Tally CHI 8 0 CHO 12 22 ST 2 0 2 50 14 4 OAS 0 IAP OMP 1 Total 24 31 Tank B Clip Unciip Tally CH1 13 7 CHO 12 9 Pink Fin Si 3 3 0 11 50 4 9 OAS 0 1 1 Total 32 1 41 Special Species Tally TankA None TotalHo 0 0 0 TotalEF 0 1 0 Total LF 0 0 Total Incidental 3 Total Sampled 131
198. sicuu2 exe 345 kB 11 11 13 11 50 00 AM Preseason Presentations 2 19 13 3 21 00 PM lh RIS 8 26 11 11 16 00 AM setup exe 884 kB 11 11 13 11 49 00 AM SQLEXPR EXE 41 5 kB 11 11 13 11 50 00 AM L TouchScreenS etup3 msi 6 2 MB 3 27 13 10 25 00 AM L TouchScreenS etup3 lamprey msi 6 2 MB 3 27 13 11 01 00 AM 1 8 26 11 11 36 00 bj Version log 382B 5 4 10 12 12 00 PM Run the utility to completely remove MS SQL Express MSXML 6 0 4 Download and install 5 SQL Express see Section VI B Step 8 for instructions 5 Download and install FPC32 net see Section VI B Step 10 for instructions 27 Problem with SQL Express Service Run On rare occasions SQL Express will not terminate when FPC32 net is closed If this happens the user will get the following Error message SQL Express Service not found Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance when trying to open FPC32 net Follow the procedure below if you encounter this error message 1 Open the Windows Task Manager to make sure all user instances of SQL Server are stopped To stop an instance of SQL Server browse the Processes tab of the Windows Task Manager for sglsrv exe If you see this listed select it and select End Process File Options View Help Applications Processes Services Performance Networking Users Image Name nvtra
199. single batch for error checking and or validation For each of the data entry tabs one or more of the 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 If 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 VIII A 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 57 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 the program is not already running or right click on the FPC32 net icon in the system tray and choose Open Main Form The Main Form window opens with the Catch tab forward About Open Main Form Setting Exit Upon being opened the Catch tab displays t
200. 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 site s 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 132 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 4 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 states the following Milestone N E Sample Fish 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 a
201. sland Dam Work Elements the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 states the following Milestone V E 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 fish would be removed and recorded as the appropriate sample days catch Fish will be delivered via the bypass elevator in 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 fish will recover in a separate holding tank and be released after they have recovered from anesthesia Milestone V F Collect Biological Data Collect biological data from salmonid migrants captured in the collection facility from 1 April to 31 August 2015 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 V G Examine juvenile salmonid emigrants for symptoms of
202. 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 a 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 F 1 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 pe and the disappears returning the user to the main touch screen The selected incidental species code appears in the Species field on the Record Browsing Panel 118 119 120 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 u
203. submitted to PT AGIS as a mortality Dead PIT tagged fish should not be disposed of in a route that has PIT tag detection capabilities If this is not possible the PIT tag should be removed prior to disposal Facility Morts In a sub batch enter the daily number of facility related mortalities e g trans portation 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 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
204. t 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 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 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 monito
205. tch Detail tab and the Cond Sample Count column of the data grid Red boxes in figure below ETE SMP Site Data Entry Program mj gt File Reports Summary Fish Condition Catch Site LGS Batch 09138 5 ubbat mn 1 1 1 1 1 1 2 2 2 2 2 Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Subbatch Sample Rate Editable p Conditions Sub Batches gt Catch Detail Sub Batches Promote All 2 0 005 GC 3 4 MESE Tank Species A o mam Nim t i l ami ps dan Pop Eve m mo mo oO gt rm gt rm oOo oO oO oO oOo oO oO Record Count 15 47 Fi Remote SMP Site Data Entry Program x File atch Detail Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch Sequence 3 TankiTrap CJA C Batch 11026 Species Cade Chinook Code Fin Clipped OY 9 OY GN ON A X Special Species n a EI SH PIED HN 1 Gear Code GUC Gatewell Collection System Multiplier 5 20 0 0 2 Non Cond Est and Sample Coun Collection Cond Sample Count g Collection Mum exam Mum Cond exam Mum Cond 0 0 For descaled Num descaled For descaled descaled Total Exam jjj Total Mum 0 ian Total Sample Count Total C
206. te 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 4 above VIII 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 calendar 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 a 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 63 Remote SMP Site Data Entry Program File Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond ial x February 2010 10044 2 12 2010 0700 09156 6 4 2009 0700 10043 2 11 2010 0700 Import From Batch Delete Record Count 4 Editing Older
207. ted 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 51 these reports 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 be made edit the records with incorrect data using 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 2 FISH PASSAGE CENTER Date 1 13 2014 2 42 11 PM Site LGS DAILY BATCH TANK REPORT Batch 13364 from File 16513364 XML Subbatch All Sample Start Date 12 29 2013 Sample Start Hour 0700 Sample End Date 12 30 2013 Sample End Hour 0700 Number of Hours Sampled 24 Sample Code 10 Avg Total Discharge 100 kcfs Avg Total Spill 50 kcfs Total Turbine Discharge 50 kcfs Comments Test of special species codes in new Daily Summary and Daily Tank Batch reports Tank B Chinook 1 Chinook 0 Steelhead Coho Sockey
208. the Summary Cond tab Where applicable after entering non condition data and promoting condition data transportation data are entered via the Transportation tab 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 be conducted at Bonneville Powerhouse 1 this year V B Bonneville Dam Powerhouse 2 omolts 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 7 00 AM and 7 00 AM daily Examination of fish may occur throughout the 24 hour sample interval as necessary 15 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 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
209. the appropriate 100 1 00 0 010 multiplier i e sample rate for a 66 6 1 5 0 015 given sub batch The 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 73 e fyou enter a sample rate directly use minimum of four digits to the right of the decimal point e g enter 0 0083 for a 0 8396 sample rate If your sample rate has more than four digits the user must round their sample rate to six digits to the right of the decimal point e g sample rate of 45 296 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 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
210. 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 5 Enter Non Cond Sample Count Num Exam for descaling Num descaled Sample Morts Facility Morts Research Morts and PITTag Morts where appropriate 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 10096 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 When 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 Ca
211. their functions 4 1 of 2p H 141 Next Previous Page Ihe 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 he Single Arrow buttons advance the report to the next previous page 4 e The Skip buttons advance the report to the beginning or Mem ees end pages i4 rl 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 Brin eee A21 x General Select Printer EA FrontOffice HP4250 PRINTMASTER a Microsoft Office Document Image Writer k Status Ready Preferences Location Comment Find Printer Page Al Number of copies E Selection Current Page Pages o Collate Enter either single page number or a single 2 page range For example 5 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
212. tion and Tagging buttons If a Special Comment needs to be entered press the Special 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 If a General Comment needs to be entered press the General Comment button and type the comment using the touch screen keyboard The user can enter only 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 or to wherever it needs to go After the record for the last fish is saved you must choose the Cancel button prior to exporting data VIII H 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 7 8 9 CE Mew Edit Delete Po 1 Save rev a 1 2 E E Export 105 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 numbers can be entered into the comment field by using this number pad The CE button clears the number that is in the fi
213. tion see Section VII H Remote SMP Site Data Entry Program E E nm x File Reports Incidental Catch Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site Sequence Batch 095138 Species Code Choose Species Cade Non Cond Sample Count Cond Count Total Count Sample Morts Record Count 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 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 44 When the entry is complete choose Save Record Mark Recapture data should be validated by printing or viewing Mark Recapture Summary Report To vi
214. ts Batch Info Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond New Batch End Day Today New Batch End Day Tomorrow v Sample Hours New Batch Total Discharge Total Spill kcFs Comments 1 Comments 2 gt 09082 Record Count 1 e sites except LEW and the batch number and site are auto matically generated based on the information selected in the Settings dialog box and by the current date on your computer The 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 to 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 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 Ot
215. tures Transportation Conditions Summary Cond LGS Start 7 37 2011 Hour 0700 Mew Bakch End Dav Today 11032 End 2 1 2011 Hour 0700 New Batch Gear Code GC Gatewell Collection System End Day Tomorrow Sample Code Sample Hours Mew Batch Ce Mews arkar ia 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 121 Validation Alert to alert the user of the suspect combination For more details on which Species Special Species combinations are valid see Section VIII B 1 Special Species Code Remote SMP Site Data Entry Program Ix File Reports Catch Detail Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Site LGS Sub Batch 1 Sequence 1 Tank Trap Special Species Validation Alert Batch 11032 Species Code CH Chinook 91 20 Fin Clipped OY N OY ON A Special Species Example 3 Invalid Length Touch Screen NEW When creating a new record via the Touch Screen a Red Dot appears next to the length field in the Data Review Panel This Red Dot will linger until the length being entere
216. us types of data will be entered and processed using the FPC32 net data entry program 1 For 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 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 Once sampling is completed detailed condition data will be transferred from the wet lab computer and imported into the office computer Section VII and Section VIII Non condition data will be entered from hand logs using FPC32 net Section VII and Section 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 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
217. used for this batch e g Sample Code 10 iil Incidental Catch Mark Recaptures Transportation Conditions Summary Cond cample Code Validation Alert Sub Batch 2 Sequence 1 TankiTrap 3B Mone Species Code CH Chinook Age Code 1 0 M OY CONIA Special Species n a Collection System Multiplier 4 Sample Rate ME Cand Sample rates for each sub batch appear in the Sub batch Sample Rate Lookup Table located in the upper right corner of the Catch Detail tab If a mistake is made on the sample rate for a sub batch it can be edited but only after all of the records for that subbatch have been 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 14 Remote SMP Site Data Entry Program nj File Reports Catch Detail Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch Sequence 2 Tank Trap Batch 11027 Species Code Chinook d Age Code OY 9M cwe OY GON ONA Special Species n a Gear Code GC Gatewell Co
218. uvenile 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 subsample 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 Section VIII 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 correspond with the goal of achieving accurate and precise estimates of total collection at the dams These sample sizes have been redu
219. venience 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 correspond ing 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 and Length are required for each individual fish condition record 90 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 Remote SMP Site Data Entry Program File Reports
220. vided in a separate manual Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch 2 species Code TankTrap 0A B OY ON None Batch 09159 Sequence 74 Species choose Species Cade Special Species n a Miscellaneous Incidental Choose Species Code Mark Type AD Adipose Elas Code M A Color Code M Descaling Gen Comment Weight af Length 170 mnl Special Comment PepEve Hemm PinkFin Fin Discol _ Eye Hemm Disease Fungus Columnaris BED Parasite Deformity Other Disease Checkboxes There are six checkboxes found near the Disease label These include Fungus Columnaris BKD Parasite Deformity and Other Check all boxes 97 that apply for 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 Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch
221. y exe nvvsvc exe nvxdsync exe OUTLOOK EXE RAVCpl64 exe sidebar exe taskeng exe taskhost exe taskhost exe taskmgr exe vprot exe 32 Updater exe 32 32 User bchockley bchockley bchockley bchockley bchockley bchockley bchockley bchockley bchockley bchockley bchockley Description NVIDIA Settings Microsoft Outlook Realtek HD Audio Manager Windows Desktop Gadgets SQL Server Windows NT Task Scheduler Engine Host Process for Windows Tasks Host Process for Windows Tasks Windows Task Manager Ask Updater VProtect Application Official winlogon exe WINWORD EXE bchockey Microsoft Word E Show processes from all users CPU Usage 5 Physical Memory 71 2 Click on My Computer and open your C Drive Search your C Drive for SQLEXPRESS The search should come up with a folder in a directory like AppData Local Microsoft Microsoft SQL Server Data SQLEXPHRESS Delete all the contents from the SQLEXPRESS folder 3 You should now be able to start FPC32 net error free 28 Other Error Messages Related to SQL Express Service If you experience any of the following error messages while using FPC32 net please reboot your machine and re open FPC32 net If upon reboot you continue to experience these or related error messages please take a screen shot Ctrl PrtScn of your error message and send it to Brandon Chockley ochockley fpc org The FPC

Download Pdf Manuals

Related Search

Related Contents

Troubleshooting - George Salter Academy  Dr Emmanuelle Girou Hôpital Henri Mondor Dr Jean  raymarine cp100 handbuch  Aquatic 160304PSL-WH Installation Guide  SUPPLEMENTAL RESTRAINT SYSTEM (SRS)  Manual - Amalgamated Pumping Supplies  第68回 定時株主総会招集通知（PDF：580KB）  RC-N IFU - Bernafon (CH)  

Copyright © All rights reserved. Failed to retrieve file