Home

here - Fish Passage Center

1. B Mane OY ON None Batch 09138 Sequence 74 Species choose Species Cade Special Species Miscellaneous Incidental Choose Species Code Mark Type AD Adipose Code M A Color Code M A Descaling M A Gen Comment Weight 37 Length 170 Predator Bird Fish Lamprev Special Comment Injury Operc Bedy Fin LA Aes E 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 Cade 5T Tank Trap A B OY Batch 09135 Sequence 74 Species choose Species Code Special Species n a Miscellaneous Incidental Choose Species Cade Mark Type AD Adipose Elas Code N A Color Code N A Descaling M Gen Comment Weight af Length 170 Predator Bird Fish Lamprev Special Comment Injury Eye Fin Hemm PinkFin Discol Eye Hemm Disease Fungus Columnaris
2. eese esee eee 53 VIIA CCR Emm 53 VIILA 1 Definitions and Data Entry 54 Start DAN 55 OUI 55 e 56 M 56 1 OCA O 56 Gear 56 SAMPE COE NEN 56 SIMPE D T 57 Total DISCHI CG ITI TT 58 PH 1 Flow or Turbine DiSCharge cccccccssccceeeceeeceececeeeseeeceeeeseeeseeeseeess 58 PLZ OW denti deside 58 OW NOR 59 Gomments1 and Comirents2 YR EY AR E SPA nace 59 VIII A 2 Editing Records in the Catch Data Entry Tab 59 Adjusting Batch Numbers and Creating Batches for Past Dates 59 Editing 60 Removing a Batch Record from the Local Database 61 Vll aie 63 d Dennuiuions and Data ENY debo dnx EE auo E 63 UG TETUR 64 65 COUO aa 65 1 6 MR MEER 66 mises asad ew aden T 67 E 67 SPECla
3. 81 TIER IT OE ET 81 Brand OS ras D 81 sls eR TEE II 81 WAG HINO CF MENT 82 82 OEC 82 Supplemental Code ESI 82 82 Promoted Summary Condition fish 82 VIII D 2 Editing or Deleting Mark Recaptures 82 VILE TranSpOn atom M 83 VIILE 1 Definitions and Data Entry 83 EE ete ED 85 85 Special Species eee 85 BUG ODIO Maa rete LM I 85 REEE 1 0 EEEE A A 85 eg 85 NUM tuu Ute conus ve mee UNTEN UEM 85 NUNT NISI CG EE SN 86 NITES AG an ton na etna eee 86 VIII E 2 Editing or Deleting Transportation Records 86 eg cas UTE 86 VIILF 1 Definitions and Data Entry 86 OItecarid Bale 88 T EU NITE 88 eae 88 DOCES ee ae 89 Miscellaneous Ingeldetital x iim i dI a a tu rte box ta 89 wlerceizibeo e 320700 X
4. 145 Xl l Lamprey Condition Monitoring Pred Bird vs Body Injury BON JDA amp MCN 145 XIL Slime EM 147 FPC32 NET Manual Acknowledgement Form 149 Vil 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 8 fish sampling at COE bypass facilities at Lower Snake River and Columbia River dams This Protocol addresses the data that are collected for the SMP at COE bypass facilities at Lower Snake River and Columbia River dams The sampling sites covered by this protocol include Lower Granite Dam LGR Little Goose Dam LGS Lower Monumental Dam LMN McNary Dam MCN John Day Dam JDA and Bonneville Dam BON For the remainder of the document these sampling sites will be referred to as Main stem Monitoring Sites This protocol is meant to compliment the Condition Sampling Protocol and provides overall guidelines
5. 90 MarK WI EET TI ITTMTEE 90 H w 90 COG T 90 91 seve be seen Dee 91 LENO 92 sized eio P 93 MIUN MC CKD OX CS ERN T 93 Disease ous a deest 94 Other Conditions Checkboxes eeeesssesssssesseeee nennen nennen 94 zu General Comment cccececececcccccececececcccccacacecececeauacacscececeecuceaesceeceauavaees 95 VIIL F 2 Editing or Deleting Condition Records 95 VII Gi Summary Cond Tab aestu 96 MAL ASSI IN cR 96 gi izle 97 Caiciy Detall SUD BalC 97 ALC MCS 98 VILHA Fish Condition TOUCH SGFe6Dn 98 VIII H 1 Data Entry Sequence for the Fish Condition Touch Screen 99 VIII H 2 Fish Condition Touch Screen Function Buttons 101 a gel mici RR RET TER 102 AMO Ub UO USO UU 102 BI MENOR 102 SOUS ML E TE KM EE EO 103 aC BR RP PCR POOR
6. 6 Ill FPC Contacts amp 7 Personnel to Contact for Technical Help 7 MB IR 7 III C SMP Remote Site Facilities and 2014 8 a 9 V Site by Site SMP 12 V A Bonneville Dam Powerhouse 1 12 V B Bonneville Dam Powerhouse 2 ceccc secs sees cece eeaeeeaeeceeeceeeseeeseeseesaeeseeseeeseeeaes 12 Mo Grande monde 13 V D River 13 OMIM DAY 13 Wels 13 V G Little Goose ensued 13 V A Eower Cina m 14 V I Lower Monumental Dam 14 Vie MOCNA m 14 14 15 Hardware and SOIWale dvd Docet boxed era fronde voee 16 Detail REUS 16 PE EIS NV
7. 111 Miscellaneous Conditions These buttons allow the user to enter the following Miscellaneous Conditions Pop Eye Fin Hemm Pink Fin Fin Discol and Eye Hemm These condition buttons toggle on and off If a button is pressed by mistake simply press it again to make that miscellaneous injury go away Users are allowed to choose as many Miscellaneous Conditions as the fish has Definitions and examples of these Other conditions can be found in the Condition Sampling Protocol document Eye Hemm Fin Discol Descaling These buttons allow the user to enter the following Descaling Conditions Partial Descale 3 to 19 descaled Descaled 220 descaled Descale Pred descaled 220 and clear predator marks If the wrong descaling button is pressed by mistake simply press it again to make that descaling go away or push a different descaling button to overwrite the erroneous selection with the correct selection Only one descaling type is allowed per fish record Definitions and examples of these Descaling categories can be found in the Condition Sampling Protocol document Predator Conditions These buttons allow the user to enter the following Predation conditions Bird Fish and Lamprey These condition buttons toggle on and off 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 th
8. enter your site in the Site box by choosing a value from the Site Code drop down list li Gear Code enter a default gear code by selecting a 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 a 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 to be saved NOTE Regardless of whether the wet lab or office computer is being used to generate the XML file the file is named in the same 29 convention It is imperative that the sites recognize this and do not confuse the two files The file that is generated by the wet lab computer can be renamed if site personnel choose see Section VI B 2 below Th
9. Remote SMP Site Data Entry Program 10 x File Reports 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 rey gt 0902 Record Count 1 For all sites except LEW and WTB 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 encounter
10. 103 a ML MM EE 103 DR S 103 E 103 Caneco RITE 103 103 VIII H 3 Fish Condition Touch Screen Record Browsing Panel 104 Tank M 104 COS 104 SDC Cla OOS 104 104 FO iE TTE T 105 Se opm REPE 105 qi ge H EN 105 General COMMent fester cate hie tates ame coin o tate tenn LES Cer Code Gene 105 opeclal GOIDITIGhl sesves 105 9 2 a 105 ipe 105 Other COLI ioco err nte 106 BITTE 106 Alem P 106 NT 106 106 106 107 Subsbal6l ceca hace 107 SS CIS eet cao ger on ae soars be A 107 4 Fish Condition Touch Screen Tallies esee 107 Tank A and None and Tank B 107 Special Species 107 Ho fe lt Ba Ec NR DT 107 Total Sampicd Tally
11. 107 VIII H 5 Fish Condition Touch Screen Condition Species and Mark Type since e 108 Elastomer LOCATON arid Ne M DUUM 110 General Comments Sub batch Tank and Special Comments 110 Disease Parasite Conditions usce eoo ito email wees Cave disse 111 Ces cedet etu Lom eter Men M du vd ES 111 Miscellaneous ttes icd utter didus 112 gro RR NR TET 112 CONCIIONS EE 112 V yDOSoqusitudtiu1001919 919 990990090 92022490 092900010 00029 0200 0019909910291 112 LONGU pridem dert deris 113 Species Special Species and Miscellaneous Incidental Species 113 IA 022502532025 c2 cada cuis ase esee ecu 116 IX A Automatic Data Validation and Alerts 116 IX A 1 Suspect Data Entry Alert Red 116 Example 1 Improper Gear Code Sample Code Sample Hours Ge ia 0 atch 116 Example 2 Improper Species Special Species Combination 116 Example Improper Sample Code Sub batch Combination 117 IX A 2 Suspect Data Entry Alert Red Field in Data Review Grid 117 Exam
12. Documen 134 Recent Es e Pictures e My Music PE Compute lg Control Panel Set Program Defaults Printers and Fa Help and Suppe 2 Search Run File Edit View Tools Help Favorites Britis 1 a Search Folders Address Control Panel Kame Comments Accessibility Options Add Hardware Add or Remowe Programs Administrative Tools Adobe version Cue C53 o Automatic Updates Date and Time SA Display 4 Folder Options E Fonts Game Controllers EaIntetR ama Driver Internet Options Adjust your comput Installs and trouble Install or remove pr Configure administr Adobe version Cue Set up windows to Set the date time Change the appear Customize the displ Add change and Add remove and c Control Ehe graphic Configure your Inte Java Javal TM Control P eam Keyboard Customize your key a Mail Microsoft Office Ou Mouse Customize your mn Network Connections Connects En other ke Phone and Modem Options Th Power Options Configure your tele Configure energy s Printers and Faxes Shows installed prin QuickTime Configures QuickTi Regional and Language Options Scanners and Cameras 2 Scheduled Tasks ee Customize settings Add remove and c Schedule computer Install or
13. 15002500 200 5 720 6 120 30050 1 000 1 500 250 4 900 6 150 250 375 600 1 000 500 2 1800 6 30 30050 Carry multipliers to 3 digits total then round 1 multiplier 3 will provide a sample rate to nearest 10 15 correct For custom sample rates it may be necessary to carry to 6 digits beyond the decimal place if rate results in longer than 6 digits During periods of peak juvenile shad passage lower sample rated than needed to meet salmonid sample goals may be used to reduce handling and mortalities of shad Anesthetic Research funded by COE has shown that MS 222 can degrade relatively rapidly causing added stress to fish as a result Degradation was found to occur within a few weeks of mixing the dry powder with water In order to minimize stress to fish it is recommended that batches of MS 222 be mixed in quantities to assure that these mixed i e liquid batches will be used within 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 approximately 15 minutes or less Fry Handling Protocol It is recommended that fry Chinook 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 av
14. 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 82 point edits can be made to the record Once edits are made choose the Save button If no edits are necessary choose the Cancel button To delete a record single click on the record you with to delete and choose the Delete button You will get a prompt confirming that the record is to be deleted select yes and that record will be removed from the local database VIILE Transportation Tab The Transportation data entry tab is for transportation sites only i e LGR LGS LMN and MCN and is intended for target salmonid species only Each record entered into the Transportation data entry tab is broken into groups based on Species Code Age Code Tank Special Species EF and FR Clipped Unclipped and Coded Wire Tag combinations The numbers for Bypassed Trucked and Barged are derived from the Collection Totals minus total mortalities sample facility and research for each Species Code Age Tank Special Species EF and FR Clipped Unclipped and Coded Wire Tag combination Since the data grid has so few columns there are no frozen fields in the Transportation data entry tab 1 Definitions and Data Entry
15. 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 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 only deletes the batch and it s supporting records from your local database on your hard drive If a batch has been deleted by the user it can be re imported into the local database To do this from the 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 62 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 entere
16. encoding Communication Devices A A printer preferably a laser printer that understands PCL 4 or above to print the daily reports B Access to a Fax machine or e mail account to send daily hand logs to FPC C 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 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 Within File Explorer make a temporary directory to save the installation program files In this procedure this directory is referred to as c installfpc32net Open Internet Explorer and go to ftp ftp fpc org FPC32 net Right click on setup exe and choose Save Target As Navigate to c installfpc32net and save this file to this directory 16 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 BON JDA MCN Right c
17. CO 11 SO 9 rt Total Incidental 3 Total Sampled 131 Tank Trap B Species 5 Clip Code 7 8 9 CE Edit Delete Elast Color CWT Gen Comment Spec Comment Predator Weight 4 5 B Next Prev Other cond 100 2 3 0 pi 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 32 2 3 10 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 to user to more clearly see when these data are entered into the program Turn on the scale and add the tray the scale automatically tares or calibrates to compensate for the weight of the tray place the fish in the tray and press the Print button on the scale e tis important that you press the Print button on the scale only once e O
18. Choose Comment CUIU Hur a Gear Sample Sample River PRGUse Phone Batch Start date in locat j Tou flowZT Dg 10044 2 12 2010 0700 2 13 2010 0700 24 0 0 0 09156 6 4 2009 0700 6 5 2009 0700 24 131 91 105 72 0 10043 2 11 2010 0700 2 12 2010 0700 24 100 02 50 01 0 S Save 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 with to delete from the Catch tab and choose Delete This will delete all records entered into the local computer database for that batch including condition incidental catch transportation mark recap and catch detail records A dialog box appears asking you if you really want to delete the batch choose Yes if you want to delete the batch along with all of its supporting records NOTE Do not delete the current day s batch record created when entering condition records edit it instead 61 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 Save Record Comments 2
19. LLL how a location code code hours flow To flow Tu flow 2x Look in FPC32 V3 902 amp Edit 2 LEWO09363 xml 2 LGRO9363 xml 2 LGRO9364 xml LG509132 xml LGS09143 xml LG509156 xml Comments 2 Save 4s Batch Recent Import From Batch Desktop 2 LGS09355 xml cum 2 LG509356 xml gt LG509357 xml LGS09362 xml Wekc METTI LG509363 xml lt gt 2 116509364 WTBO9362 xml WTBO09363 xml My Computer ad m 6 My Network File name j Places Files of type Batch files xml Cancel 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 a New Batch Record Directly from the FPC32 net Main Form for sites where no condition data are collected 1 From the office computer double click on the Fish Condition icon on the desktop The office computer should be configured so that the Main Form opens by default The Main Form window opens with the Catch tab forward From within the Catch tab choose New Batch End Day Today to create a new batch with the EndDate matching today s date To create a new batch with the end date matching tomorrow s date select New Batch End Day Tomorrow create a new batch with the EndDate matching yesterday s date select New Batch End Day Yesterday 36
20. New The New button allows the user to enter new records After pressing the New button the background panel turns white and the New button disappears indicating that data entry is allowed Once the first record has been entered the user must press the Save New button to save the record 102 Save New The Save New bution allows the user to save the current record and automatically starts a new record for the next fish The Sub batch and Tank of the previous record automatically appear for each new record You must correct the Sub batch and or Tank each time you switch Sub batches or Tanks Edit The Edit button allows the user to edit the record shown in the record browsing panel found in the lower left corner of the touch screen After pressing the Edit button the background panel turns white indicating that data entry is allowed Once editing is complete the user must press the Save button to save the changes to the record Delete The Delete button allows the user to delete the current record shown in the record browsing panel Next The Next 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 1 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 b
21. 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 the predator buttons are pushed that predator type is displayed in this row Possible entries in this row include 1 Bird 2 Fish and 3 Lamprey Injury This row is where any Injury data are displayed If any of the injury buttons are pushed that injury will be displayed in this row Possible entries in this row 105 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 ent
22. 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 FB only Select the brand from the drop down list Brand Orientation This field is only used with Freeze Brands i e Mark 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 An error message is displayed if the mark type is anything other than FB and data entry is attempted here 81 Tag Number This field is for and Visual Implant Tags only i e Mark Type FL or VI If it is discernible enter the tag number in this field An error message is displayed if Mark Type is FB EL or ER and data entry is attempted here Tag Color Tag Color 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 Length GR G drop down list and select the appropriate color 2520 code Leave blank for numbered tags e f a 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 beats SER E select the appropri
23. 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 forms This manual has been provided for the biologist who input the data as a reference to assist in the operation of the FPC32 net program It is essential that all SMP personnel who are responsible for entering fish data into the FP
24. aled C AP Ammocoete Pacific led SO sockeye 0 Total 1 9 Ammocoete Unknown cares _ MP Macrop Pacific 2222214 0 Facility Morts LU Lamprey Sp Unid AB Ammocoete Brook 65 AP Ammocoete Pacific AS Ammocoete Unknown MP Macropthalmia Pacific 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 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 F
25. 0 0 0 100 0 40 20 100 01 40 20 460 Sample Morts 0 0 0 0 0 0 0 0 0 Facility Morts 0 0 0 0 0 0 0 0 0 0 Research Morts 0 0 0 0 0 0 0 0 0 Tag Morts 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 o 0 o 0 o of o of o of of of of o 0 Descaling Pctg 96 0 0 00 0 0 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 00 00 00 00 0 0 00 00 0 0 47 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 non condition data by comparing this report to your hand logs paying special attention to the sample counts number examined for descaling descaling mortality counts and flow spill quantities Page 1 FISH PASSAGE CENTER Date 1723 2012 3 24 35 Site LGS SPECIAL SPECIES DAILY BATCH TANE REPORT Batch 11068 from File 65511099 SUbbatch All Sample St
26. 0 0 0 0 0 0 Descaling Pctg 0 00 96 0 00 96 0 00 96 0 00 96 0 00 96 0 00 96 140 Page 2 FISH PASSAGE CENTER Date 1 13 2014 2 39 32 PM Site LGS Daily SMP Summary Batch 13364 from File LGS13364 XML Collection Count Num Exam for Desc eoceosese e oo gt oO gt gt gt 0 00 5 i e Se es ee e oo gt gt eo oc gt c eo 8 53 Foo Daily Tank Batch Report This is still a four page report with a landscape layout A column for sockeye fry has been added to the Sockeye section of this report A in figure below This new column is present for all four sections Tank A Tank B Tank None and Combined Page 2 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 A Total Turbine Discharge 50 kcfs Comments Test of special species codes in new Daily Summary and Daily Tank Batch reports Tank Coho
27. 09041 __ 09069 3 9 2009 0700 3 10 2009 0700 6C 1 24 65 50 0 1 Save As Batch Confirm Overwrite Export File xj Import From Batch Do you want En ovewrite the File CHLGROSO41 xml e Delete Record Count 2 4 You must also send your hand logs to the Fish Passage Center logs can be sent Fax to 503 232 1259 e mail to snp fpc org or uploaded 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 1 XML file 49 e lf you cannot send the batches in on time be sure to call a member of the data center staff and let us know the reason and when you expect to get the batch in VILL Reposts If you need to revise and resend a batch you must edit the batch that was previously created see instructions for editing a batch in Section VIII below If you wish to resend a batch you must document why you are changing the batch and submit this documentation along with the batch preferably via FAX or email FPC WILL NOT UPDATE BATCHES UNLESS PROPER DOCUMENTATION IS RECEIVED You should also send a copy of this documentation to your project leader If 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
28. 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 Batch End Day Today Batch Batch End Day Tomorrow Batch End Day Tomorrow Batch End Day Yesterday Batch End Day Yesterday 2 Click on the appropriate Batch End Day button to create the desired batch 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 99 Tank and None Clip Unclip T ally CH1 04 0 CHO 0 TE 0 0 CO 0 0 50 0 0 Total DE 0 Tank B Clip LInclip T ally 1 0 0 CHO 0 0 5 0 0 co 0 0 50 0 0 Total 0 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 Seque
29. 27 13 11 01 00 AM TrapRelease 8 26 11 11 46 00 AM Version log 382 5 4 10 12 12 00 PM 3 Run the utility to completely remove MS SQL Express MSXML 6 0 4 Download and install MS SQL Express see Section VI B Step 12 for instructions 5 Download and install FPC32 net see Section VI B Step 14 for instructions 24 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 nvtray 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 C User Name bchockley bchockley bchockley bchockley bchockley bchockley bchockley bchockley bchockley bchockley bchoc
30. Avg Total Discharge 100 kcfs Total Turbine Discharge 50 kcfs 0 0 0 0 0 0 0 0 0 0 0 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 Chinook 0 Steelhead CWT juc JEF CWT CL of of o 0 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 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 Coho Sockeye Total Fy luc Fry si ol 2 13 s 0 21 23 of 2 of s 0 2 o 20 o of of o of of of o 0 o ol o of of of o 0 o ol o of of of o 0 0 0 0 0 0 of 0 0 0 0 o of o o o of o 0 0 100 0 40 20 100 of 0 20 440 o of of o of of of o 0 o o of o o of of o 0 00 00 00 00 00 oo 00 0 0 VII l 1 Manual Entry of Transportation Data 1 2 To create a new record in the Transportation data entry screen click on the New button to add a record Enter the Tank Species Clip CWT and Special Species code EF and FR combination for the record you wish to create Enter the Num Bypassed Num Trucked and or Num Barged for each new record These numbers are derived from the Total Collection minus total mortalities in the Daily Batch Tank Report All Sub batches In the case when two day s samples are being transported together the Daily Batch Tank Report All Sub batches for each of these batches will hav
31. By clicking on the column header records can be sorted for easier viewing Sorting by multiple columns is also possible simply hold the Shift key while selecting the sequence of columns you wish to sort by If errors are found records can be edited directly from the Conditions tab see Section VIII F for more details on editing and instructions on group editing 41 2 Individual condition can also be viewed via the Individual Fish Condition Report 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 x File Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site L35 Sub Batch 1 Species Code Tank Trap OB Mone OY Batch 11026 9 Sequence 3 Species choose Species Code Special Species n a Miscellaneous Incidental Choose Species Code Mark N Elas Code N A Color Code N A Descaling N A Gen Comment Weight Length Predator Bird Fish Lamprey Special Comment Injury Eve Bedy Fin Hemm PinkFin Discol Eye Hem
32. Code Below is a list of the various Sample Codes their meanings and appropriate Gear Codes in italics when applicable 96 p LM a RU LS FS NEED 1 y Sample Hou Total Discharge Comments 1 2 Two 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 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 fish accumulated 2 days Samplecode minus 10 is number of days 13 Sample of fish accumulated 3 days Samplecode minus 10 is number of days 14 Sample of fish accumulated 4 days Samplecode minus 10 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 is 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 3 No sample biased sample due to abnormal flows
33. Injury 4 Predation 5 Disease or Parasite and 6 Total With Conditions This report is NOT meant to be used for validation it is simply a summary of the conditions seen for a particular day s sample Condition fish with the Other Conditions Fin Hemm Pop Eye Pink Fin Fin Discol and Eye Hemm are NOT included in the Injury row Page 1 FISH PASSAGE CENTER Date 2 3 2012 3 45 40 PM Site MCN Conditions Report for Batch 11153 from 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 78 Descaling 20 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 order to determine obvious errors from data entry e g anomalous lengths or weights incorrect species etc Condition fish are sorted by sub batch tank and sequence The condition data are divided into five groups 1 Disease Parasite 2 Injuries 3 Pre
34. Monumental Dam will sample fish daily throughout the monitoring season at the JMF Collect species condition and external mark detail from all sampled fish Collect detailed condition and length data from a subsample of the sample Count and identify all incidental species caught 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 D Summarize and Verify All Sample Data on Days Collected at Lower Monumental Dam Milestone AO E Project Operations and Flow Data Collection SMP personnel at Lower Monumental Dam will collect record and verify daily USACOE project operations and flow data and facility fish mortality within the bypass collection system Milestone AP A Transmission of Project Data SMP personnel at Lower Monumental Dam will transmit daily Corps project operations flow data fish transport 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 AL C Sample Fish Daily and Collect Data SMP personnel at McNary Dam will sample fish daily throughout the
35. Num Exam for Descaling after entering the Sample Count and Sample Morts e f you over write the calculated value for Num Exam for Descaling this must be the last entry before hitting the Save New bution e The automatic field validation logic displays an error message if the Sample Count minus Sample Morts is less than the number examined for descaling e Fish collected for GBT Gear Code are not to be examined for descaling For sub batches with Gear Code the default Num Exam for Descal is 0 e Fry and Lamprey juveniles are not to be examined for descaling The default Num Exam for Descal is 0 when Species Codes AB AP AS or MP or when Special Species FR are selected Num Descaled Enter the number of fish descaled from the non condition fish that were examined for descaling A fish that has greater than 20 descaling on one side is considered descaled e The auto field validation logic checks to see if Number Descaled is greater than Num Exam for Descal if so an error message is displayed Sample Morts For each sub batch enter the number of SMP related sampling mortalities for each species age rearing disposition This includes all fish that are dead in the sample tank s or those GBT fish that died after being sampled from the separaior 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 Thi
36. 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 12 GBT monitoring is conducted at this site See Gas Bubble Trauma Monitoring Protocol and GBT net Data Entry Program User s Manual V C Grande Ronde River Trap Operate a scoop trap on the lower Grande Ronde River 5 km upstream of the mouth seven days per week for a 12 week period The primary function of this site for SMP is to PIT tag out migrating smolts V D Imnaha River Trap Operate of the screw trap in the lower Imnaha River seven days per week The primary function of this site for SMP is to PIT tag out migrating smolts The Nez Perce Tribe provides data on fish collection based on a prior agreement No funding is provided by SMP V E John Day Dam smolts will be examined for various factors including species fin clips marking data and detailed fish condition data including descaling Fish from the general population are obtained from a timed sub sampl
37. Sockeye juc c __ uc Fy luc jw eL Non Cond Sample Count o 0 5 1 0 1 o of o 5 0 2 5 o 2 1 23 Exam Desc Non cond o 0 5 1 0 0 o of ol o 0 2 0 5 0 2 o 20 Non cond Descaled of 0 0 o o of of of o 0 of o 0 of o of of of o 0 Condition Sample Count o 0 o 0 0 o of 0 o o o of of of 0 of o 0 Condition Descaled o 0 o 0 0 o of o o o o of of of 0 of o 0 Total Sampie Count of 0 0 sS o of o o 0 s 0 21 s o 2 1 23 Total Collection o 0 100 20 o 20 o 0 o 0 100 0 40 20 100 0 40 20 460 Sample Morts 0 0 0 0 0 oj 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Facility Morts o 0 0 0 0 o of ol o o o of of of 0 of o 0 Research Morts o 0 o 0 o of ol o o o of of of 0 of o 0 PIT Tag Morts o 0 of oj 0 o of 0 o o o of of of 0 of o 0 Num Bypassed o 0 100 0 of 20 o of ol 0 100 0 40 0 100 0 40 20 440 Num Trucked o 0 of 0 0 0 o of o o o o of of of 0 of o 0 Num Barged o 0 0 0 0 o of oj o o of of of of 0 o 0 Descaiing Pctg 00 00 00 00 00 0 0 00 00 00 00 00 00 00 ooj ooj 00 00 0 0 141 XI D Facility Mortalities for Lamprey Currently COE biologists do not identify lamprey facility mortalities e g race way mortalities to species and life stage Therefore SMP personnel do not need to report facility mortalities of lamprey juveniles
38. batch number for each fish condition record The sub batch numbers for the condition fish are listed in this data grid along with the corresponding default sample rate that was assigned to these sub batches as entered in the Settings tab If data for non condition fish were entered into Catch Detail the sample rate s entered into Catch Detail will automatically overwrite these condition sample rates Note If all fish sampled were condition fish the user must check to make sure the default sample rates from the Settings tab were correct for this batch before promoting condition fish into the Catch Detail Incidental Catch and Mark Recap tabs To correct them right click in the Sample Rate cell in the Condition Sub Batches box at the top of the screen A in the figure below This allows you to manually enter the sample rate for that particular sub batch must be between 0 0 and 1 0 You 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 lf data were entered in Catch Detail the sample rates in the two review grids must match for each of the sub batches If you notice that the sample rate in either of these two data grids d
39. be carried forward Gear Cade Gatewell Collection System Multipl into the Catch Detail data entry tab Mon Cond Unknown 0 4 from the Catch data entry tab Most sample cour 00 No 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 only be used on days where no sample was taken Multiplier and Sample Rate of Multiplier 7 Sample Rate 01 choose the sample ra e 200 0 5 0 005 two ways First the Multiplier Collection ce 6 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 0 EIE TOS may choose 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 69 e lf you enter a sample rate directly use a minimum of four digits to the right of the decimal point e g enter 0 0083
40. 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 25 except when increased numbers of fish may be needed for research or to address immediate management needs Avoid using sample rates between 12 and 25 whenever possible to avoid impacts to sample accuracy as well as to minimize impacts to PIT tag studies near the divert during sample DDS trigger of 20 When possible sites should try to avoid the 0 6 0 67 0 7 1 5 3 0 7 0 and 15 sample rates as much as possible as they have the highest probability of causing rounding errors in data reports Sites should attempt to minimize the number of times per season sample rates switch from above to below 20 or from below to above 20 to minimize the number of times the DDS is turned on or off 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 30055 15000 00000 20 50 72 6 12 30040 10 000 15000 30 333 108 6 18 300450 7500 10000 40 2 144 6 24 300 400 65007500 50 2 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
41. 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 RIS LMN LGS and LGR Coded Wire Tag A small piece of wire inserted into the surface of a fish s nose which has been coded with information about the origin of the fish COE Daily Report The US Army Corps of Engineers produces many hydrological reports containing measurements of various hydro system parameters Descaled For SMP basin wide purposes when a fish is at more than 20 descaled on either side as determined by ocular measurement the fish is considered descaled even if descaling was clearly caused by predation in which case it would be considered descaled with predation marks present Descaled fish tagged with PIT tags that are entered into PTAGIS are segmented into three descaling categories at least 10 descaled between 10 20 descaled and greater than 20 descaled This last PTAGIS descaling category is similar to the basin wide SMP definition of a descaled fish Electronic Batch The xml file which is sent from the remote SMP sites to FPC each sampling day of the fish migration season This fi
42. 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 63 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 of data to be edited and choose Edit or double click on the record to be edited The data from the record then populate the data entry panel at the top of the screen and are editable Once necessary changes are made choose Save For ease of navigation the Tab Keys can be used to move between fields and Right and Left arrow keys can be used to move the cursor within a data field Below is a table of the fields of data that are entered into the Catch Detail tab along with the default settings for each field prior to data entry Following this table is a list of the fie
43. 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 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 iil Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Sub Batch 2 Sequence 1 TankiTrap 3B Mone cample Code Validation Alert Species Code CH Chinook Age Code 1 0 M OY CONIA Special Species n a Collection System Multiplier 4 Sample Rate Cand Sample rates f
44. for sampling and data to collect In past years the primary data gathered at these main stem monitoring sites are count data on juvenile salmonids that are sampled from the bypass system However lamprey juveniles have been added to the list of target species for the SMP These target species are identified to species and any clips and marks tags are also recorded Based on these count data 1 sample counts an estimate of daily collection can be generated at each project From estimates of collection passage and population indices can be generated if the sample data are representative based on 24 hour sampling that is systematic and sample rates are known throughout that period Estimates of passage and population indices will not be done for lamprey juveniles In addition to sample counts data on fish condition are also collected Two levels of condition data are collected based on the level of detailed information to be collected For the full sample fish are examined for descaling based on FTOT criteria A subsample of the full sample is examined for detailed condition information including descaling injury and disease Salmonid fry are NOT examined for descaling or detailed condition information All COE dam sites conduct detailed condition monitoring on salmonid species In addition BON JDA and MCN conduct detailed condition monitoring on juvenile and larval lamprey The protocol for examination of fish for detailed condition moni
45. 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 2 Remote SMP Site Data File File Reports Catch Detail Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch 2 Sequence 11 Tank Trap None Batch 13364 Species Code MP Macrop Pacific Code O1 0 Fin Clipped OY OY ON Special Species n a Gear Code GC Gatewell Collection System Multiplier select Sample Rate Sample Rate 0 05 Est on in 5 Cond Sample Count 4 Collection S00 Cond Sample Count Collection i Num Cond exam Num Cond 0 JL t dz 0 g 0 for descaled for descaled descaled Total Sample Count 4 Total Collection 80 Total Exam 0 Total Num 0 for descaled Descaled Sample Morts D Facility Morts 20 Research Morts PITTag Morts 0 XI E Warning Pop up When Cancel Button on Touch Screen is Selected We have added a new feature in the Settings dialog box that will 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
46. jon Total Sample Count Total Collection Ron dns Descaled Sample Morts Facility Morts Record Count 5 IMPORTANT The Cond Sample Count Num Cond Exam Num Cond Descaled and Cond Collection fields cannot be edited If an error was made in the fish condition records these data need to be edited in the Conditions tab and then re promoted from Summary Cond for edits to take effect VIII Entering Transportation Data Once the Condition sample data have been incorporated into the batch the next step is to enter the Transportation data via the Transportation tab For a detailed description 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 from the Catch Detail data entry screen using the Import button For a more detailed discussion of each of these methods see Section VII I 1 and Section VII I 2 below Regardless of which method you chose to use you must know what your collection counts were for each Tank Species Clip CWT and Special Species code EF and FR combinatio
47. net will still allow the user to save this record but the erroneous facility mortality will be overwritten as O 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 73 Research Morts For each Species Age Clip CWT combination enter the daily number of fish taken out of the SMP sample and sacrificed by non SMP researchers For example mortalities from USGS radio telemetry marking should be entered as Research Mortalities PIT Tag Morts This field is only used at RIS WTB LEW IMN and GRN Enter the number of mortalities due to SMP PIT tagging operations 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 Ta
48. nm 16 3 Gomimunicauon DOVICCS cues pr oa nhe 16 VI B Procedure to Install the FPC32 net Program including the fish condition touch 16 VI C Procedure to Install New Version of FPC32 net and Uninstall an Old Version 20 VED Troubleshooting EPOGOS2 TIBL i E ep 21 VI D 1 Windows 7 Procedure to Allow Full Control esses 21 VED 2 Problems with SOL JEXDEGSS cerit n ii xot a di di deus 24 MS SQL Server Database Could Not 24 Problem with SQL Express Service 25 Other Error Messages Related to SQL Express Service 26 VI D 3 Default Display Settings A 27 VII Overview of FPC32 NET 28 VILA FP OS2 Ner settings Dialog BOX UR deve Cogo Uo dud 28 VII B Entering Fish Condition Data Via the Touch Screen 30 VII B 1 Brief Overview of Steps to Entering Fish Condition Data the Fish Condition Oto OE 31 VII B 2 Exporting Daily Fish Condition Records from the Wet Lab Computer 33 VII C Importing a Batch From the Condition Sample or Creating a New Batch 35 VII C 1 Importing Daily Fish Conditi
49. occur Milestone AC C Operate Trap for Collection of Data SMP personnel at the Snake River Trap will operate the trap 5 nights week March 5 26 This will mean lowering the trap to begin the sample period at 6 00 PM on Sunday and cessation on Friday morning at 9 00 AM Collect data on daily catch hatchery and wild population composition descaling recaptures of PIT tagged parr and average length by species Collect limited species data on incidental fish captured Monitor fish injury rates and mortality due to trapping and sampling procedures and modify as necessary to minimize injury and mortality rates Milestone AC D Transmit Collection Data SMP personnel at the Snake Hiver Trap will electronically transmit salmonid collection data to FPC daily in 131 a standard format determined by FPC This will be done from a site several miles upriver that has standard phone access e Milestone AG A Transmit of Project Data SMP personnel at the Snake River 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 132 X A Generating and Printing Reports There are several different reports available with the FPC32 net remote data entry program see Section IX B for a detailed d
50. 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 118 Example 1 Entering a Tank At LGS LMN and MCN each time a user starts data entry for a new subbatch in Catch Detail a Data Reminder will appear reminding them to enter a Tank This is because Tank is repeated for all subsequent records until the subbatch is changed or the user changes to a new Tank This message 1 also used in the Condition Touch Screen for these sites Transportation Conditions Summary Cond he o Please choose 1 TankiTrap None ad rine Code 91 O0 this record Special Species n a 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 can be used validation some validation information is also provided in Section VII J above SMP Site Data Entry Program Batch Daily Summary Mark Recapture Incidental Catch Fish Condition lndividual Fish Condition Report Daily ank Report Special Speci
51. 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 day not including sample rate for GBT sample gt 12 Sample of fish accumulated 2 or more days The sample code minus 10 is the number of days that fish accumulated before being sampled Sample Hours Enter the actual number of hours sampled rounded to the nearest 100th place e g 4 hours and 43 minutes 4 72 hours When daylight savings time begins and ends the sample hours will need to be adjusted The only time Sample Hours should be 2 24 is when Sample Code 2 12 For detailed instruction on these changes see Section VII M 1 above If Sample End Date is the same for two batches see Section VII M 2 above 57 Total Discharge Total Discharge is the average hourly river flow Kcfs during the sampling period This value is mandatory for the SMP sites at dams BO2 JDA MCN RIS LMN LGS and LGR but it opt
52. remove programs and Windows components 2 From within Control Panel select Add Remove Programs 20 3 From within Add Remove Programs select FishCondition3 and choose Remove Ce ee f Add or Remove Programs E ar 7 x amp Currently installed programs and updates Show updates Sort by Change or Remove Programs Add New Programs Security Update For 2007 Microsoft Office System KB2584063 Installed 3 19 2011 Security Update For 2007 Microsoft Office System KB2553090 Installed On 91972011 Update For Microsoft Office 2007 suites KB2596789 32 Bit Edition Installed On 1 11 2012 ET Security Update For Microsoft Office PowerPoint 2007 2596843 32 Bit Edition Installed On 1 11 2012 EN Security Update For Microsoft Office 2007 suites KB2596785 32 Bik Edition Installed On 1 11 2012 m i ConsoleImportTdgs Size 0 09ME Add Remove Windows Components Qi Dimension 4 v5 0 Sire 0 29MB Fish Liberation Recording Program Size 4 742 00MB Size 23 ffl A Used occasionally Set Program Access and DeFaulks Last Used On 1 20 2012 To change this program or remove it From your computer click Change or Remove Fraps Size 1 68 GBT Net Size 21 44 isl Gobi Interactive Graphics Platform Size 3 79MB Google Earth Size 92 77MB G Google Toolbar For Internet Explorer GoToMeeting 4 5 0 457 cir iL STI lL remove pr
53. 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 e his writes the data in the local database to an XML file in the directory specified in the Settings see Section VII A e XML file already exists for that batch you may be prompted with a message asking if you want to overwrite the existing batch Select Yes 2 End data entry each day by printing the Daily Summary Incidental Catch Mark Recaptures Fish Condition Daily Batch Tank All Subbatches and Lamprey Batch Tank All Subbatches reports if they have not already been printed 3 Send the XML file to the FPC office via e mail to smp fpc org or uploading from the web see Section X B Remote SMP Site Data Entry Program ziBl x File Reports Batch Info Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGR Haur New Batch End Day Today Batch 09041 Hour Mew Batch Gear Code Choose Gear Cade End Day Tomorrow Sample Code Choose Sample Cade Sample Hours d Total Discharge Turb Discharge Total Spill cs rue Comments 1 Comments 2 TU Mm Sta MET End Gear Sample Sample Rive Phouse Phouse Batch Start date ED End date End Trap Sample Sample River Phouse hour hour locati ME code code hours flows nn 1 flo 2 flow dit
54. should you need to use either of these procedures 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 fip ttp fpc org FPC32 net ftp ftpfpcorg FPC32 net Getting Started Latest Headlines Google Gmail Favorites Index of FPC32 net Name Size Date Modified t parent directory 4 BO 8 26 11 11 45 00 AM L dotnetfx35 exe 41 0 kB 11 11 13 11 49 00 AM IDA 4 16 13 12 35 00 PM 4 LGR 8 26 11 11 46 00 AM LGS 8 26 11 11 36 00 AM LMN 8 26 11 11 46 00 AM Manuals 2 21 13 3 51 00 PM MCN 8 26 11 11 36 00 AM L exe 345 kB 11 11 13 11 50 00 AM Preseason Presentations 2 19 13 3 21 00 PM RIS 8 26 11 11 46 00 AM setup exe 884 kB 11 11 13 11 49 00 AM ha SQLEXPR EXE 41 5 kB 11 11 13 11 50 00 AM TouchScreenS etup3 msi 6 2 MB 3 27 13 10 25 00 AM L TouchScreenS etup3 lamprey msi 6 2 MB 3
55. similar fashion as the Daily Batch Tank Report However this report only summarizes data for lamprey juveniles separated by tank Tank A Tank B Tank None and Combined Running this report after entering promoting lamprey juveniles into the Catch Detail data entry tab is the best way to validate these data 125 Page 1 FISH PASSAGE CENTER Date 2 13 2013 8 29 27 AM 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 Tank B Tank None Combination Batch e e Js p e 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 25 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 di
56. some of the values will default to These settings can be changed whenever the user wishes Fish Condition Touch Screen Only Warning Popup when Cancel Button is selected Automatically Export Last Selected Batch When Exit 0 Play Sound 0 0 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 m 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 28 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 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 progra
57. the appropriate documentation to the FPC via email to repost fpc org see above for further documentation 90 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 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 File and click on Create Older Days Batch A calendar will appear from which you may choose your batch end date You are limited to the current year To switch to a previous month press and hold on the current month and move up to select the desired month Double click on the date for the batch you want to create a Fag Remote SMP Site Data Entry Program _ File Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond February 2010
58. these buttons and their functions 4 of 2 H 133 Next Previous Page The Next Previous Page buttons allows the user to view the next or previous report pages In addition this section of the Report Viewing Window informs the user how many pages the chosen report is 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 or previous page 4 e The Skip buttons advance the report to the beginning Mem 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 Berit eee 2 x General Select Printer FrontOffice HP4250 PRINTMASTER a Microsoft Office Document Image Writer k Status Ready Printto Preferences Location Comment Find Printer Page Range Al Number of copies E Selection Current Page Pages o Collate Enter either a 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 TIF
59. to enter data or information about using FPC32 net and about how to use site specific database management tools e 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 SMP E mail for batches and hand logs smp Qfpc org Reposting E mail repost fpc org GBT E mail smp fpc org FIP 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 2014 Dates e Bonneville Dam Powerhouse 1 Pacific States Marine Fisheries Commission e Bonneville Dam Powerhouse 2 BO2 Pacific States Marine Fisheries Commission Grande Ronde River Trap GRN Oregon Dept of Fish and Wildlife Imnaha River Trap IMN Nez Perce Tribe John Day Dam JDA Pacific States Marine Fisheries Commission Lewiston Snake River Fish Trap LEW Idaho Dept of Fish and Game Little Goose Dam LGS Oregon Dept of Fish and Wildlife Lower Granite Dam LGR Washington Dept of Fish and Wildlife Lower Monumental Dam LMN Washington Dept of Fish and Wildlife McNary Dam MCN Washington Dept of Fish and Wildlife Rock Island Dam RIS Chelan Public Utility District Whitebird Salmon River Trap WTB Idaho Dept of Fish and Game Smolt Monitoring Dates for 2014 Send in your daily batch via
60. up early The Batch End Day Yesterday button should only be used if a sample is being worked up after being held for 24 hours Click on one of these buttons to create a new batch If a batch already exists in the local database with a particular Batch End Day a pushpin icon appears next to the corresponding Batch End Day button Batch End Day Today Batch End Day Today Batch End Day Tomorrow Batch End Day Tomorrow Batch End Day Yesterday Batch End Day Yesterday 31 Tank and None Clip Unclip T ally CH1 0 0 CHO um 0 ST 0 co 0 0 50 0 0 Total 0 0 Tank Clip Unclip T ally 0 0 CHO um 0 ST 0 0 co 0 0 50 0 0 Total 0 0 Special Species T ally Tank B None Total Ho 0 0 0 Total EF 0 0 0 Total LF 0 0 0 Total Incidental 0 Total Sampled 0 Please enter Tank Trap Q S Species Clip Code Tank T rap 7 8 9 CE Edit Delete Elast Color CWT Gen Comment Spec Comment Weight 4 5 Next Prev Injury Other cond Length Disease Exit Cancel nn Export Site LGS Batch 10044 2 13 2010 S batch 1 Sequence 1 Tank or None Clip Unciip Tally CH1 8 0 CHO 12 1 22 ST 2 co 2 50 11 4 OAS 0 IAP 0 1 Total 24 31 Tank B Clip Unciip Tally CHI 13d 7 CHO 12d 9 SI 3
61. uploaded via the web To upload a new batch or hand log you must first navigate to http www fpc org smpupload SMP Posting asp with your internet browser To log in enter Login guest and password niceguest The password authentication requires you to accept cookies but you can set Internet Explorer to accept just cookies from FPC if you wish To change the privacy settings in Internet Explorer go to Tools Internet Privacy then click on the Edit button under Web Sites Add the domain fpc org and select Always Allow 136 5 SMP FILE UPLOAD PAGE Windows Internet Explorer Joj qu Lo ral Frc htkp www fpc org smpuplaad SMP Posting asp X E Google B File Edit View Favorites Tools Help Gege Asad Be e oe Sonn ir Favorites Suggested Sites Earthlink Free Hotmail 3 Google Web Slice Gallery d gt E Fec SMP FILE UPLOAD PAGE Fre SMP FILE UPLOAD PAGE X f Safety A SMOLT MONITORING PROGRAM FILE UPLOAD LOGIN PAGE Login 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 zone Medium Blocks third party cookies that do not have a compact privacy policy Blocks third party cookies that use persona
62. with CH1 for Chinook yearling and CHO for Chinook subyearling MUU pt species ST Steelhead M Species CH1 Chinook yearling CHO Chinook Subyearling Steelhead Coho sn gth Sockeye Leng 50 Sockeye Species list for LGR LGS LMN ee oe AS Ammocaete Lnmnknavwn Fin H Pacific Parasite 1 Species list for JDA MCN incorporating lamprey juveniles Miscellaneous Incidental The Miscellaneous Incidental codes Miscellaneous Incidente awe include several non salmonid gt Color Cd BM Bass Large Mouth E incidental fish codes This drop down MICE NAR BL Bluegill Pumpkinseed menu options are listed alphabetical by incidental species name NOT Comment incidental species code n Discol Hemm Deformity Other LD Dace Long Nosed SD Dace Speckled BK Banded Code Name Code Name LK Lamprey Adult Brook TT Tench 89 Incidental Incidental Species Incidental Incidental Species Code Name Code Name Madtom Tadpole LT Trout Bull OT species not listed CT rout Cutthroat PPeamouh RT Trout Rainbow PI Pink juv _ LW Whitefish Lake Notes e f you see a Bull Trou
63. 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 0 0 0 Descaling Pctg 0 0 001 00 0 0 0 0 00 00 0 0 00 00 0 0 00 00 001 00 00 00 00 00 0 0 Lyons Ferry or Holdover yearling fall Chinook are included in the Chinook 1 columns depending on whether they were unclipped CWT or clipped IX B 7 Special Species Daily Batch Tank Report The Special Species Daily Batch Tank Report has all the same data and is arranged in a similar manner as the Daily Batch Tank Report However this report only summarizes Lyons Ferry and Holdover yearling 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 fish are already included in the tallies of Chinook 1 from the Daily Batch Tank Report see Section above 124 Page 1 FISH PASSAGE CENTER Date 2 2012 10 29 56 Site MCH SPECIAL SPECIES DAILY BATCH TANK REPORT Batch 11153 from File MCHN11153 XML Subbatch sample Stat Date 5 1 2011 Sample Start
64. 10044 2 12 2010 0700 09156 6 4 2009 0700 10043 2 11 2010 0700 Save As Batch Import From Batch Delete Record Count 4 e This batch must be edited To edit the batch from the Catch tab select the batch to be edited and choose the Edit button The following are items that must be edited 51 Put the actual end date and end hour in the Comments field Put the actual sample hours in the Sample Hours field Put the adjusted sample end date the following day in the End Date field 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 52 The purpose of this section is to provide detailed information on the types of data that are entered into FPC32 net and how to enter these data This section also provides instructions on how data can be edited if when errors are 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 validatio
65. 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 email sent to repost fpc org along with an explanation memo of why this batch is being resubmitted for reposting If you use Microsoft Exchange configure your mail client to send a return receipt back to you acknowledging that the mail arrived To edit a pre existing batch for reposting 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 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 lf changes are made to individual condition records these changes must be re promoted into the Catch Detail Incidental and Mark Recap records To re promote choose the Summary Condition tab and choose Promote All to rewrite or change the daily batch condition records in the Catch Detail Incidental and Mark Recap tables Once you have made all the required changes select the Catch tab and press the Save As Batch bution 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 send the changed batch along with
66. 3904 Chris s Phone Number 503 833 3902 Fax Number 503 232 1259 XI B Hand Logs Can Now Be Uploaded Via the Web This new feature was implemented in the middle of the 2013 SMP Season In case you weren t aware hand logs can now be submitted to the FPC via upload from the web The procedure for uploading a hand log is the same as that for uploading an XML file see Section X B Hand logs must be in PDF format in order to be uploaded via the web 139 XI C Redesign of Daily Summary and Daily Tank Batch Reports To remedy a bug with the reporting of sockeye fry we have redesigned the Daily summary and Daily Tank Batch reports Below is an example of the new reports and a more detailed description of the changes that were made The redesign of these reports will also facilitate easier entry of sockeye fry into the Transportation tab Daily Summary Report This is still a two page report with a landscape layout A column for sockeye fry SOFry has been added to the UNCLIPPED TOTALS section on the first page A in figure below The lamprey summaries have been moved from the UNCLIPPED TOTALS section on the first page to a section of their own on the second page named LAMPREY TOTALS red box in figures below Finally the SUMMARY TOTALS section has been moved to the end of the second page This section now includes totals for each species of salmonid and lamprey clipped and unclipped combined Subyearling Chinook sockeye and coho fry are
67. ALL sites 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 steelhead unclipped only and 3 LF for Lyons Ferry yearling fall Chinook These buttons toggle on and off The user is only allowed to enter one special species code for each fish If the wrong Special Species button is pressed by mistake simply press it again to make that Special Species value go away or push a different Special Species button to overwrite the erroneous selection with the correct selection Only one Special Species type is allowed per fish record In addition to the five target salmonid species the user can also choose the Misc Incidental Species button For a list of the species codes see the species code listings in Section VIII H 3 When this button is pressed a pop up appears with a button for each of the Miscellaneous Incidental Species listed in alphabetical order of the common name not the species code The user simply presses the appropriate species wena and the popup disappears returning the user to the main touch screen he selected incidental species code appears in the Species field on the Record Browsing Panel 114 115 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 en
68. BE Parasite DeFormity 94 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 N A Mark Type AD Adipose Elas Code Descaling M A Weight af Length 170 Predator Bird Fish Lamprev Injury Operc Bedy Fin Fop Eve Fin Hemm Pink Fin Fin Discol Eye Hemm Disease Fungus Columnaris BED Parasite Deformity Other 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 Atthis point edits can be made to the record Edits should only be made to these records when you are absolutely sure that there was an error in data entry For example if an anomalous length is identified for an individual record delete this anomalous length and leave the length field blank as opposed to attempting to correct the length Once edits are
69. 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 create a new record in the Transportation data entry tab choose New This activates the data entry panel at the top of the screen When the first record is created Site and Batch are carried over from the Catch data entry tab The user should enter a separate detailed record for each Species Code Age Code Tank Special Species EF and FR only Clipped Unclipped and Coded Wire Tag combination FPC32 net allows users to import the different Species Code Age Code Tank Special Species EF and Fry Clipped Unclipped and CWT combinations from the Catch Detail tab into the Transportation tab This saves time as it is no longer necessary to enter every possible combination again However only data in Catch Detail for that particular batch are imported This means that additional Species Code Age Code Tank Special Species EF and Fry Clipped Unclipped and CWT combinations from previous days may need to be entered when every other day transportation is in place Furthermore if condition data have not been promoted to Catch Detail some Species Code Age Code Tank Special Species EF and Fry Clipped Unclipped and CWT combinat
70. C32 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 6 Personnel to Contact for Technical Help e Brandon Chockley SMP Co 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 e Jerry McCann SMP Co Manager 503 833 3909 jmccann tpc org Weekend number 503 432 0676 Contact Jerry for questions about definition of a specific fish condition change addition to procedures GBT questions etc e Christopher McCarty Computer Specialist 503 833 3902 cmccarty fpc org Weekend number 503 851 1549 Contact Chris for computer hardware windows and software setup technical problems i e problems with computer hardware errors and issues e Lynnae Sutton Data Management Specialist 503 833 3904 lsutton fpc or Weekend number 503 720 8205 Contact Lynnae for questions about how
71. D C Sample Fish Daily and Collect Data SMP personnel at Little Goose Dam will sample fish daily throughout the monitoring season at the JMF Collect species condition and external mark detail from all sampled fish Collect detailed condition and length data from a subsample of the sample Count and identify all incidental species caught in the samples Tally review enter into computer and transmit all data to FPC daily During periods of low fish collection August to October 24 hour daily samples may be held and sampled every other day Milestone D D Summarize and Verify All Sample Data on Days Collected at Little Goose Dam Milestone D E Project Operations and Flow Data Collection SMP personnel at Little Goose Dam will collect record and verify daily USACOE project operations and flow data and facility fish mortality within the bypass collection system Milestone E A Transmission of Project Data SMP personnel at Little Goose Dam will transmit daily 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 5 For Lower Grande Ronde River Trap Work Elements J and L the Sta
72. Directory TrapRelease 05 04 2010 12 12PM 382 Version loq 13 Double click on the SQLEXPR EXE file to begin the installation Follow all prompts and accept all default settings 19 14 Once the NET Framework 3 5 and the Microsoft SQL 2005 Express edition have been installed on your local computer open File Explorer and navigate back to C installfpc32 net Double click on the TouchScreenSetup3 msi or TouchScreenSetup3 lamprey msi file 15 Follow the prompts and accept all default settings The program will place an icon on your desktop called Fish Condition This is the FPC32 net program which includes the batch data entry and the fish condition touch screen NOTES e The NET Framework 3 5 and the Microsoft SQL 2005 Express edition only need to be downloaded and installed once e If you already have Windows with Service Pack 3 or a newer version of Windows you do not need to install Microsoft NET Framework 3 5 VI C Procedure to Install New Version of FPC32 net and Uninstall an Old Version 1 If you want to install a newer version of FPC32 net you must first uninstall the old version To uninstall the older version of FPC32 net choose Start Settings Control Panel 197 Internet Mozilla FireFox E mail Microsoft Office Outlook Windows Media Player 33 Windows Messenger 9 Dw Microsoft Office Excel 2003 MSN Adobe Dreamweaver C53 Tour Windows All Programs gt
73. E deformity Fl fin injury OD other disease Other Conditions Descaling PE popeye PD partial descaling 5 19 FH fin hemorrhage DS descaled 220 FP pink fin DP descaled by predator 220 with pred marks FD fin discoloration EH eye hemorrhage IX B 6 Daily Batch Tank Report The Daily Batch Tank Report is arranged in a matrix fashion similar to the hand logs for many of the sites The batch header information is found at the top of the report This report separates fish that were sampled as part of the condition sample from those that were sampled as part of the non condition sample There are four summary sections to the report including 1 Tank A 2 Tank B 3 Tank None 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 Non Cond Descaled 4 Condition Sample Count 5 Condition Descaled 6 Total Sample Count 7 Total Collection 8 Sample Morts 9 Facility Morts 10 Research Morts 11 PIT tag Morts 12 Num Bypassed 13 Num Trucked 14 Num Barged and 15 Descaling Pctg 96 123 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 th
74. F or 6 Web Archive html Once the user has chosen a format for the exported report a Save as dialog box appears From this dialog box navigate to where you want to save the report and name the report 100 acrobat POF File comma delimited Excel Rich Text Format TIFF File Web Archive 134 X B Save As d Recent Documents er E Desktop Documents Computer d File name dark Report Iz save MarkR eport sls Cancel 7 Percent Zoom Ihe Percent Zooms allows the user to select a zoom percentage to view report details on screen Daily Summary Report of 2 b 2 ae 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 bathes 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 users to send the final XML file with
75. 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 Avg Total pk 333 6 Comments _ Chino 1 HO Chino 11 Eus Uc jc CWT e Non Cond Sample Count 0 0 2 0 0 0 2 Exam Desc Non cond 0 2 0 2 0 0 a 0 2 Non cond 0 0 j 0 0 0 0 Condition Sample Count 0 0 0 0 0 0 0 0 0 Exam Desc Condition 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 Collection 00 00 ue 00 00 100 0 Sample Mats 0 0 0 0 0 0 0 0 0 Facility Mots 0 0 0 0 0 0 0 0 0 Research Mats 0 j 0 i 0 0 0 j PIT Tag Mots 0 0 0 0 0 0 0 0 0 Descaling Peig 9 00 oof oof oof oof 00 00 00 oal Tark B Chinook 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 0 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 Sample Count 2 0 0 2 0 0 0 0 2 Total Collection 1000 oof ool 1000 00 00 ool 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 00 oof oof 00 00 00 oo 00 IX B 8 Lamprey Batch Tank Report The Lamprey Batch Tank Report is arranged in a
76. III 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 juvenile lamprey will not be examined for descaling Fish that are part of the detailed condition sample will be examined for descaling as well as other indices of fish health status See the Condition Sampling Protocol for more in
77. 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 only enter two comments or codes in this field each separated by a semicolon Press the Save New button to save the individual fish record and start on the next fish Return the fish to the bypass to where ever it needs to go Repeat Steps 4 through 9 for each subsequent fish After the record for the last fish is saved you must choose the Cancel button prior to exporting data VIII H 2 Fish Condition Touch Screen Function Buttons These function buttons appear in the lower center and right corner of the touch screen he following describes the functions of each of the buttons in this section of the touch screen Delete 7 8 New m Edit f Exit Export 101 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 comment button is chosen numbers can be entered into the comment field by using this number pad The CE button clears the number that
78. S Chn1 Sock Total Sample Count 6 0 0 2 2 10 Collection Count 600 0 0 0 0 0 40 0 40 0 680 0 Num Exam for Desc 6 0 0 2 2 10 Num Descaled 0 0 0 0 0 0 Facility Morts 0 0 0 0 0 0 Sample Morts 0 0 0 0 0 0 Research Morts 0 0 0 0 0 0 PIT Tag Morts 0 0 0 0 0 0 Num Bypassed 600 0 0 40 40 680 Num Trucked 0 0 0 0 0 0 Num Barged 0 0 0 0 0 0 Descaling Pctg 0 00 96 0 0096 0 0096 0 00 96 0 00 0 00 96 UNCLIPPED Chn1 ChFry StlHd Coho CoFry Sock SoFry Total TOTALS Sample Count 4 6 1 4 5 1 5 1 27 Collection Count 400 0 120 0 20 0 400 0 100 0 20 0 100 0 20 0 1180 0 Num Exam for Desc 4 6 0 4 5 0 5 0 24 Num Descaled 0 0 0 0 0 0 0 0 0 Facility Morts 0 0 0 0 0 0 0 0 0 Sample Morts 0 0 0 0 0 0 0 0 0 Research Morts 0 0 0 0 0 0 0 0 0 PIT Tag Morts 0 0 0 0 0 0 0 0 0 Num Bypassed 200 100 20 300 100 20 100 20 860 Num Trucked 0 0 0 0 0 0 0 0 0 Num Barged 0 0 0 0 0 0 0 0 0 Descaling Pctg 0 00 90 0 00 0 00 0 00 96 0 00 96 0 00 96 Page 2 FISH PASSAGE CENTER Date 1 13 2014 2 39 32 PM Site LGS Daily SMP Summary Batch 13364 from File LG813364 XML LAMPREY PacAm BrkAm SmAm PacMac LamUn Total TOTALS Sample Count 0 0 0 0 0 0 Collection Count 0 0 0 0 0 0 0 0 0 0 0 0 Num Exam for Desc 0 0 0 0 0 0 Num Descaled 0 0 0 0 0 0 Facility Morts 0 0 0 0 0 0 Sample Morts 0 0 0 0 0 0 Research Morts 0 0 0 0 0 0 PIT Tag Morts 0 0 0 0 0 0 Num Bypassed 0 0 0 0 0 0 Num Trucked 0 0 0 0 0 0 Num Barged 0 0 0 0 0 0 Descaling Pctg 0 0096 SUMMARY C
79. S would like to get a better idea of what uncertain injuries may look like for juvenile lamprey To this effect USFWS asks that when an injury is uncertain crews at BON JDA and MCN are to enter that injury and then enter a UI into the opecial Comments field as a way to flag it Crews are also asked to take a picture of uncertain injury if possible 145 146 147 148 FPC32 NET MANUAL ACKNOWLEDGEMENT FORM the undersigned acknowledge that have read the FPC32 net manual Name Please Print oignature Date Please copy this form and mail a completed and signed form to Fish Passage Center Attn Brandon Chockley __ 847 19 Ave Suite 250 agone Portland OR 97213 Fax 503 232 1259 149
80. Smolt Monitoring Program Protocol and FPC32 net Data Entry Program User s Manual Manual Version 2014 Season Produced by The Fish Passage Center Last updated 2 19 2014 Smolt Monitoring Program SMP Protocol cessere 1 LA Introduction tothe SMP Pm 1 I B Summary of Data to be Collected for the 2 1 Target Species and Species 2 2 Species Specific Data to 2 1 10 e c ee 2 pecial 8 12 2 Clipping Marking and Tagging 3 Descaling Data 3 3 3 Fish Sampling at Main stem Monitoring Sites 4 oample Size E 4 RUES E E E 4 D FY ASRING tT E 5 Il Introduction to FPC32 net m 6 ILA The Fish Passage Center 6 Remote SMP Site Data Entry Program 2
81. ab 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 86 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 Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch 2 Species Code 5T TankiTrap Mone Cyt OY Batch 09138 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 M A T Gen Comment Weight af Length 170 Predator Bird Fish Lamprev Special Comment Injury Head Operc Fin PepEve Fin Hemm PinkFin Discol Eye Herm Diseas
82. am 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 AM and 7 00 AM daily Sample smolts for counts by species and clipped unclipped status In additional another primary function of this site for SMP is to PIT tag out migrating smolts 14 GBT monitoring is conducted at this site See Gas Bubble Trauma Monitoring Protocol and GBT net Data Entry Program User s Manual V L Whitebird Trap Operate a scoop trap on the lower Salmon River above Whitebird for a 12 week period five days per week The primary function of this site for SMP is to PIT tag out migrating smolts 15 The FPC32 net program was designed and tested on Windows XP It has not been tested on newer Windows operating systems but should operate properly in those environments FPC32 net will not operate in Windows 2000 or older operating systems VI A Hardware and Software 1 PC Details A PC running Windows XP with Service Pack 2 or later with at least 512MB of RAM to run the FPC32 net program 1 GB recommended and at least 1 GB of hard drive space 2 GB are recommended Software A 2 runs on Windows XP and Windows 7 B An internet e mail connection capable of sending files attached with base 64
83. ard see General Comments keyboard above The intent of this field ts for sites to use it for other conditions that they would like to keep track of but don t have buttons for t is 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
84. are found in the upper left and central portion of the touch screen These buttons are grouped in sections and some are also grouped by color These buttons have many functions Some of the buttons toggle on and off some move the computer focus to a specific field some clear a field or fields some open a pop up screen with additional selections and some select the appropriate sub batch and tank The condition button groupings include 1 Elastomer Location and Color 2 General Comments Sub batch and Tank 3 Disease Parasite conditions 4 Injuries 5 Miscellaneous Conditions 6 Descaling 7 Predation 8 Mark Types 9 Length and Weight functions 10 Species Special Species and Incidental Species codes 108 L Orange L Y ellow L Pink L Other R Orange R Yellow R Pink SSS oe p a 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 EENEN 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 109 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 the wrong button simply select the correct button or select the same button to re
85. are in the field 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 New The functions of the Exit Panel button on the touch Return screen have been revised to remedy issues that arise when this button is pressed prior to the Export button If newly entered records have not been exported to the XML 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 return to touch screen so data can be exported to XML file Exit A Hide Screen Return
86. art Date gt 2011 Sample Start Hour Sample End Date gt Sample End Hour Gear Code GC Sample Code 1 Humberof Hours Sampled 24 Total Discharge 111 45 Total Turbine Discharge T5 73 Aug Total Spi 4 09 Comments Tam 1 Chinook 1 LF Grand T otal Hon cond Sample Count Exam Desc Hon cond j Hon cond Dezcaled Condition Sample Count Exam Desc Condition Condition D ezcaksi Total Sample Count Tiotal Collection Sample Morts Facility Research Morts Tad Mark 5 0 so coe ok slo Tank Chinook 1 Chinook 1 LF CL Total Ho UC CUT CL Total Gand Tota Hon cond Sample Count Exam Desc Mon cond Hon cond Descaled Condition Sample Count Exam Desc condition Condition Total Sample Count Total Collecti di mn n ea foe I oo Sample Morts Facility Fiezearch Morts FIT Tau Mort Dezcaling FA n tm ele cote o ele co cole cs eas ele cole gt a ulos ele gt cele ce cee cle sce oie 2 oe 2 pon ele cele 48 VII K End and Send Once data have been validated the next step is to print
87. ate 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 198 AR Adipose Right Ventral LV Left Ventral Only Hw Clip with Hv Right Ventral Orly 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 This button when selected summarizes the Mark Recaptures into Subbatch Tank Species Code Age Code and Mark Type groups and populates the Cond Count field in the Mark Recaptures data entry tab This field cannot be edited To change this Cond Count field individual records must be edited in the Conditions data entry tab data and re promoted via the Summary Cond data entry tab To learn more about the Summary Condition tab and the promotion of condition fish into the Mark Recaptures data entry tab see Section VIII G
88. ation spreadsheets and all corrections have been made you must send us an e mail stating that your data are finalized 126 IX F Project by Project Details for SMP Reporting Requirements The Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 includes several milestones that pertain to the use of the FPC32 net data entry program Below is a summary of these milestones for the various SMP projects 1 For Bonneville Dam Work Elements N Q and John Day Dam Work Elements R T the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 state the following Milestone N C Sample 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 all data to FPC daily During periods of low fish collection August to October 24 hour daily samples may be held and sampled every other day Milestone N D Project Operations and Flow Data Collection SMP personnel at Bonneville Dam will collect record and verify daily project operations and flow data and facility fish mortality within the bypass col
89. 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 record You may now edit any of the fields in this data entry panel When you have completed making the necessary corrections to the record choose Save Record 60 Remote SMP Site Data Entry Program D 21 xf File Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS New Batch End Day Today Batch 09138 New Batch Gear Code ise B End Day Tomorrow Choose Sample Code Y Sample Code Sample Hours UNES Total Discharge Turb Discharge Total Spill kcfs End Day Yesterday Comments 1 Comments 2
90. ce e Only target salmonid species are imported from Catch Detail Lamprey juveniles are NOT to be entered into the Transportation tab e f condition data have not been promoted to Catch Detail these Tank Species Age Clip CWT and Special Species EF and Fry combinations may not be present e NOTE Eroded fin steelhead at LGR will be imported as Unclipped steelhead as LGR cannot know how many EF steelhead were collected 2 Enter the Num Bypassed Num Trucked and or Num Barged for each Tank Species Age Clip CWT and Special Species EF and Fry combinations To do this select each record and enter the corresponding Num Bypassed Num 46 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 3 To validate these data re run the Daily Batch Tank Report All Sub batches and the Lamprey Batch Tank Report All Sub batches and verify that the Num Bypassed Num Trucked and Num Barged are correct Validating Batch The Daily Batch Tank Report and the Lamprey Batch Tank Report that were generated and printed for Section above can be used for final data validation These reports summarize sample counts descaling information collection counts and mortality data for condition and non condition fish separately by tank Validation from these reports can be done for a single sub batch at a time or for all sub bat
91. ches combined Validate non condition data by comparing these reports to your hand logs paying special attention to the sample counts number examined for descaling descaling mortality counts and flow spill quantities Holdovers and Lyons Ferry fish are included in the UC CWT or CL columns for Chinook 1 If any changes need to be made edit the records with incorrect data 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 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 Chinook 1 Chinook 0 Steelhead Coho Sockeye Total UC CWT ICL CWT Fry UC EF CWT CL UC JUC CWT CL Fry 0 0 5 1 0 0 5 5 2 0 0 5 0 0 0 5 5 2 0 o i 0 0 0 0 0 oj 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 10 20 0 20 0
92. cidental Catch tab via promotion see Section VII H Remote SMP Site Data Entry Program E E joj 2 File Reports Incidental Catch Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS 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 40 When the entry is complete choose Save Record Mark Recapture data should be validated by printing or viewing Mark Recaptu
93. cies Subbatch groups and populates the total sample count for each incidental fish species under the field Cond Count This field cannot be edited To change this Cond Count field individual records must be edited in the Conditions data entry tab and re promoted via the Summary Cond data entry tab To learn more about the Summary Condition tab and the promotion of condition fish into the Incidental Catch data entry tab see Section VIII G VIII C 2 Editing or Deleting Incidental Catch Records You can only edit one record from the Incidental Catch data entry tab at a time To edit a record you must first select the record from the data grid at the bottom of the screen by either double clicking on the record The selected record automatically populate the data entry panel The arrow next to the record is the best indicator of the selected record At this point edits can be made to the record Once edits are made choose the Save button If no edits are necessary choose the Cancel button To delete a record single click on the record you with to delete make sure the record is highlighted and has an arrow next to it and choose the Delete button You will get a prompt confirming that the record is to be deleted select Yes and that record will be removed from the local database Mark Recapture Tab In the lower data grid the Subbatch Sequence Tank Species Code and Age Code fields are frozen on the left to help the user identif
94. close together it is possible that a user may accidently press Cancel when they 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 box in the Settings dialog box 142 su _ 4 08 0 Fish Condition Touch Screen Only Warning Popup when Cancel Button is selected Automatically Export Last Selected Batch When Exit E Play Sound H 9 Site Choose Site Code Gear Code Select Default Gear Code v Sample Rate Sub 1 Select Default Sample Rate Sample Rate Sub 2 Select Default Sample Rate Default Start Hour m End Hour D700 Browse Delete Old Batches from Database When enabled in the settings a warning pop up with the message Are you sure you want to cancel the current unsaved record will appear on your screen Injury Other cond Disease Fungus Tank A and None Clip Unclip Tally 7 m Cancel ste LGS bac 14013 1 14 2014 143 A Yes answer will drop the current un saved record and return the user to the touch screen The user can then press the New button to begin entering new
95. condition data If condition data entry has been completed the user can proceed to saving the condition XML by pressing the Export button A No answer will return the user to the touch screen with the current un saved record Still visible in the Record Browsing Panel The user can now continue to enter condition data for this fish or save this un saved record by pressing the Save New button It is important to note that there is no way for the program to know if you pressed the Cancel button by accident or on purpose i e you are finished with condition data entry Therefore if you have this feature enabled you will get this warning pop up message when you hit the Cancel button on purpose to end data entry When this happens simply select Yes in the pop up This will drop the un saved blank record and allow the user to move on with exporting condition data and closing the touch screen XI F New Functions for Exit Panel Button on Touch Screen The functions of the Exit Panel button on the touch screen have been revised to remedy issues that arise when this button is pressed prior to the Export button As usual pressing the Exit Panel button at any time will prompt a pop up menu with three options Exit Hide Screen and Return As usual the Exit button will exit the touch screen and close FPC32 net the Hide Screen button will close the touch screen and return to the Main Form and the Return button will return to the touch screen for addit
96. creen 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 l 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 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 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
97. d 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 they intend to add edit data to by selecting the corresponding batch in the Catch data entry tab Once a batch has been selected in the Catch tab you may navigate to the Catch Detail tab 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 Batch 11026 Species Code Chinook 91 Fin Clipped 9M 9M Special Species n a Gear Code GL Gatewell Collection System Multiplier 5 20 0 0 2 Sample Rate 0 Est Cond Sample Count Collection Collection Mum exam T Mum Cond exam Mum Cond 0 0 0 For descaled Num descaled for descaled descaled Total Exam Total For descaled Descaled 0 0 Cond Sample Count Total Sample Count 0 Total Collection 0 Sample Morts 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
98. d has so few columns there are no frozen fields in the Incidental Catch data entry tab 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 Remote SMP Site Data Entry Program olx File Reports Incidental Catch Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sequence 3 Batch 1102 Species Code 41 Chinook Adult Sample Count 0 Cond Count J Total Count Edit Delete Record Count 2 19 To create a new record in the Incidental Catch data entry tab choose New This activates the data entry panel at the top of the screen When the first record is created Site and Batch are carried over from the Catch data entry tab The user should enter a separate detailed record for each incidental species that was identified in the sample To edit a record select the record from the data entry grid at the bottom of the screen Each record has a sequence number to make the editing process easier 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 cor
99. d 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 79 Field Name Default Settings Set in setting dialog Sequence For each subbatch sequence starts at 1 and continues sequentially When a new subbatch is started sequence starts over at 1 Subbatch Starts at 1 The value of subbatch for the next record is the same as the previous entry until the user changes the value 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 none Species is a required field The value of species code is the same as the previous entry until the user changes
100. dator 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 122 Page 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 HI El PB PF PL FP EH PD DS DP 1 CHO 40 58 80 2 CHO AD 116 100 3 108 101 AIA A CHT L5 0j 1 5 CHO 124 10 PL 1A 6 SO 208 128 7 CHO lAD 105 98 PL 8 ST AD 9 ao 458 174 _ 10 CHO 34 e 11 CHO 95 98 12 CH AD 339 14 PL DS f cH 25 61 14 CHO 102 96 45 cun ial 72 Disease Parasite Injuries Predator FU fungus HI head injury PB bird predator CO columnaris El eye injury PF fish predator KD BKD OP operculum injury PL lamprey predator PA parasite Bl body injury PO other predator D
101. e ye 1 1 0 0 0 1 0 0 0 1 3 0 0 1 A 0 0 1 m 0 0 0 1 A 0 0 0 e B 0 0 0 e B 0 0 0 e B 0 0 0 B 0 0 0 e B 0 0 0 Record Count 15 Below if a list of the fields and instructions of the types of data that can be found in each field Site and Batch The Site and Batch fields cannot be edited Site is set in the Setting dialog box Batch is set when data entry for the batch is first started generally with the touch screen Site contains the three character code for the remote site entering The Batch number contains two digits for the year and three digits for the day of the year 1 366 YYDDD Catch Detail Sub Batches The current selected batch s sub batch numbers and associated sample rates are displayed in this small data grid at the top of the tab window These data are not editable It is for reference only During entry of the non condition 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 only be populated if data for non condition fish were entered into Catch Detail it is otherwise blank 97 Conditions Sub Batches When entering condition data via the touch screen the user enters a sub
102. e Fungus Columnaris BED Parasite Deformity Other Subbat Sequen Tank Edit CT sl m BOCA Mc Color Weight Length Mene n 1 1A CH1 AD LF 24 1 138 Edit CH1 AD 18 5 129 m Delete L Select All E Clear All E Record Count 216 Below is a table of the fields of data that are entered into the Conditions data entry tab along with the default settings for each field prior to data entry Following this table is a list of the fields and instructions of the types of data that should be entered into each field and how Field Name Default Settings Set in setting dialog Sequence For each subbatch sequence starts at 1 and continues sequentially When a new subbatch is started sequence starts over at 1 Sub batch Starts 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 87 Field Name Default Settings Species Code Default is none Species code is populated when the user chooses a value from the Species or Miscellaneous Incidental pull down menus Default is none This field is only used for Chinook Mark type Coded Wire Tag Special species Default is none code Elastomer code Default is none Color code Default is none Descalina Default
103. e 3 Improper Sample Code Sub batch Combination When creating a record in the Catch tab this user entered a Sample Code of 1 However when entering data in the Catch Detail tab the user created a second sub batch with a 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 10 xi File Reports Catch Detail Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch 2 Sequence 1 TankTrap B None Sample Code Validation Alert Batch 11032 Species Code CH Chinook X 91 Q0 Fin ON OY CON Special Species n a v Gear Code GC Gatewell Collection System Multiplier Sample Rate 0 0083 Non Cond cut 0 U U Cond Sample Count J DM IX A 2 Suspect Data Entry Alert Red Field in Data Review Grid FPC32 net has validation on Length and Weight data for condition fish If a user enters a Length or Weight that is outside of a pre determined range for that species the field for that entry will appear Red in the Data Review Grid of the Condition tab For details on these length and w
104. e XML file that is generated by the office computer is the only file that will be processed by the FPC see Section VI K below 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 in the e mail dialog box in the settings screen It is NOT mandatory that sites do this ix FPC32 net allows for up to three user defined comments that 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 in the Setting screen If you have a comment that you want to enter repeatedly that is not already in the drop down menu you can type that comment in one of these three text boxes Any text that is entered into these text boxes will automatically show up in the Comment2 drop down menu 6 The Delete Prev Year and Delete Old buttons delete the batches stored in the local database except the current day s batch These buttons should only be used to clean the database Delete All button deletes all of the records th
105. e local database 7 Once you are finished with the Settings dialog box choose Save Setting to save the settings you have entered A dialog box appears prompting the user to restart the application for the setting changes to take effect Select Yes and the application will Exit VII B Entering Fish Condition Data Via the Touch Screen Species Length and Sub batch data are required in the Fish Condition touch screen in order for records to be saved successfully Weight is not required however some of the sites collecting fish condition data will collect weight as a part of the fish condition dataset except for incidental species By default the Sub batch number on the first record is set to 1 To change sub batch for the first record press the Sub batch button as many times as is necessary to get to the desired sub batch number If the sub batch number is incorrect choose Clr Sub batch The sub batch number is carried forward from the previous record until it is changed To enter a Tank press the appropriate Tank button either Tank A or Tank B The tank letter is carried forward to the next record from the previous record until it is changed by the user Sites that do not have separate tanks will not see a Tank button To enter a Species and Clip type choose the appropriate Species Clip button 30 For example CH1 is for unclipped yearling Chinook CH1 AD is for an adipose fin clipped yearling Chinook If the species is an inciden
106. e 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 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 Sample smolts from the collection for counts by species and clipped unclipped status Examine all unclipped yearling Chinook subyearling Chinook sockeye and coho for coded wire tags GBT monitoring is conducted at this site See Gas Bubble Trauma Monitoring Protocol and GBT net Data Entry Program User s Manual 13 V H Lower Granite Dam 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 Sample smolts from the collection for counts by species and clipped unclipped status Examine all unc
107. e to be collectively entered in to the Transportation tab 45 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 EET SMP Site Data Entry Program mi Reports Transportation Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site 188 Sequence CJA Batch 09138 Species Code Choose Species Code ge O1 020 Fin Clipped CIN Cwt OY CON None Special Species Choose Special Species Code Mum Bypassed Mum Trucked Mum Barged b ri I iu uw Edit ri I Delete BE CH Refresh l rn ra I ea m I un l mr E Loi 4 m C D a oOo oo oa Record Count 19 VII I 2 Importing Data from Catch Detail for Transportation Data Entry Tab 1 To import the different Tank Species Age Clip CWT and Special Species EF and Fry combinations from the Catch Detail tab into the Transportation tab push the Import button e Only data in Catch Detail for that particular batch are imported This means that additional Tank Species Age Clip CWT and Special Species EF and Fry combinations from previous days may need to be entered when every other day transportation is in pla
108. e 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 New Upload logs can be uploaded the web at http www fpc org smpupload SMP Posting asp The procedure for uploading hand logs is the same as that outlines for uploading XML batches see Section X B Uploaded hand logs must be in PDF format 138 In 2014 the FPC will continue to support two editions of FPC32 net for SMP data entry These editions are TouchScreenSetup3 msi and TouchScreenSetup3 lamprey msi The TouchScreenSetup3 msi edition will be used by site personnel at LGR LGS LMN RIS WTB LEW and GRN To make sure you are running the most up to date version and edition we suggest that all sites uninstall FPC32 net from their machi
109. e 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 XI H Newly Expanded Troubleshooting Section Section VI D Troubleshooting FPC32 net has been expanded in this manual to better explain some of the more common issues that users have run into over the years Most of these issues are related with problems with the SQL Express service While users are encouraged to reference this newly expanded section first the FPC data staff will still be available for technical support Lamprey Condition Monitoring Pred Bird vs Body Injury BON JDA and MCN U S Fish and Wildlife has asked that the SMP crews at BON JDA and MCN continue to work with them to better differentiate between body injuries caused by birds i e Pred Bird and those caused by the project 1 Body Injury To that effect they have asked that crews again take pictures of Bird Marks versus Body Injuries and share them with the FPC as you go along USFWS would like pictures that clearly document the symmetrical nature of Pred Bird injuries on lamprey juveniles 1 marks on both sides of body to be added to the condition monitoring manual SMP sites are asked to send pictures to FPC We will continue to work with USFWS towards better defining these two categories In addition USFW
110. 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 64 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 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 100 sample rate gear code of GC and tank none Any mortalities associated with these lamprey should also be recorded If species ID is not possible use species code LU when recording in Catch Detail 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 Switc
111. ed you may skip this step and move onto Section VII E Otherwise once the Catch data have been entered the next step is to enter the non condition sample data via the Catch Detail tab To select the Catch Detail screen for data entry first select the record for the batch you want to add data to by clicking on the batch record in the data grid at the bottom of the Catch screen A selected record has an arrow beside it second select the Catch Detail tab For a detailed description of data entry fields in the Catch Detail tab see Section VIII B below 37 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 The sample rate for a single sub batch is carried forward to the next record from
112. een fish by pressing the Tare button Once the last fish has been entered and the Save New button has been pushed push the Cancel button to end data entry VII B 2 Exporting Daily Fish Condition Records from the Wet Lab Computer Typically condition records are entered on the wet lab computer and the batch records are entered on a different computer in the office Therefore the daily 33 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 clicki
113. eight ranges see Section VII F 1 Weight and Section VIII F 1 Length above These alerts are intended to alert the user to anomalous Length and Weight estimates that warrant review It is up to the user to keep or delete these anomalous estimates FPC does not recommend changing anomalous Length or Weight estimates If an anomalous Length or Weight is entered for an individual FPC recommends simply deleting the anomalous estimate Example 1 Anomalous Length Entry When creating a record 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 117 Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Sub Batch 1 Species Code B Batch 11032 Sequence 1 Species choose Species Code Special Species n a Miscellaneous Incidental Choose Species Cade Mark AD Adipose Code Color Code N A Descaling NA Gen Comment Weight 28 6 Length 500 Predator Bird Fish Lamprey Special Comment Head Operc Body Fin Pap Eye Fin Hemm PinkFin Discol Eye Hemm Disease Fungus Columnaris BED Parasite Deformity Other Canc
114. el 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 Example 1 Flow and Spill Data Entry This user entered a Total Discharge of 200 a Turb Discharge of 199 anda Total Spill of 10 which prompted a Data Entry Error Message see above figure In this case the user must click on the OK button and makes the proper correction before the record can be saved SIE LILIE EON Pe OP Sampie murs E Total Discharge 200 Discharge 199 Total Spill kcfs 10 Comments 1 Data Entry Error E xl Comments 2 site LOS Turb Discharge Spill cannot be greater than Total Discharge mum c m wm 126 11026 1 25 2011 0700 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
115. elhead 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 the same as what has been generated by previous versions of FPC32 This report summarizes all incidental fish regardless of whether they were collected as part of the condition or non condition sample Running this report after entering non condition incidentals prior to promoting incidental fish from the condition sample is the best way to validate data entry into the Incidental Catch data entry tab Page 1 FISH 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 PM Peamouth 1 0 PE Perch 1 0 5 Stickleback 1 1 Total Incidental Catch 4 Total Incidental Mortalities 1 121 IX B 4 Fish Condition Report The Fish Condition Report is designed similarly to the Daily Summary Report This report Summarizes the prevalence of each of the conditions from the condition sample Target salmonid species are split into three groups 1 Clipped 2 Unclipped and 8 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
116. ered by the user There can be 5 digits in the weight field including three numbers before the decimal point a decimal point and one number after the decimal point The weight field can have data values in the hundreds up to 999 9 grams Weight is not mandatory at BO2 or JDA Length The Length field holds the length millimeters of the fish which was entered via the number pad Length is a Required Field for condition fish Therefore the text box for Length will appear yellow when a new record is created until a Length is entered by the user There can be 3 digits in the length field There are no decimals in this field Length can have data values in the hundreds up to 999 mm Length is mandatory at all sites where condition data are collected The Bottom Section C in above figure of the Record Browsing Panel displays the Site Batch Date S batch and Sequence number Site This site field is where the Site is displayed Site was chosen in the Settings dialog box 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 106 Date The Date field is where the batch end date is displayed The batch end date corresponds
117. es Daily Batch Tank Lamprey Batch T ank ring Total Discharge 100 Turb Discharge 50 IX B 1 Daily Summary Report 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 non condition 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 3 Num Exam for Desc 4 Num Descaled 5 Facility 119 Morts 6 Sample Morts 7 Research Morts 8 PIT tag Morts 9 Num Bypassed 10 Num Trucked 11 Num Barged and 12 Descaling Pctg Page 1 FISH PASSAGE CENTER Date 1 13 2014 2 39 32 PM Site LGS Daily SMP Summary Batch 13364 from File LGS13364 XML Sample Start Date 12 29 2013 Sample Start Hour 0700 Gear Code GC Sample End Date 12 30 2013 Sample End Hour 0700 Sample Code 10 Number of Hours Sampled 24 Avg Total Discharge 100 kcfs Total Turbine Discharge 50 kcfs Avg Total Spill 50 kcfs 120 Comments Test of special species codes in new Daily Summary and Daily Tank Batch reports CLIPPED TOTAL
118. ese Predation conditions can be found in the Condition Sampling Protocol document Mark Types These buttons allow the user to enter the following mark types LV left ventral RV right ventral and CWT coded wire tag 112 For those sites that examine Chinook Coho and Sockeye for coded wire tags the CWT button is only pressed when an unclipped fish has a CWT This will place a Y in the Record Browsing Panel For these species the default CWT in the Record Browsing Panel is N If the CWT button is pressed by mistake simply press it again to toggle it to the off N position The LV and RV buttons are pressed with a fish has a Left Ventral Clip LV or a Right Ventral Clip RV fish has both a ventral clip and an adipose clip the user would first select the adipose clip by selecting the corresponding Species AD button see below Then the user would select the corresponding Ventral Clip button LV or RV When this is done the Clip Code in the Record Browsing Panel will display an AR Adipose Right Vent or AL Adipose Left Vent For example for a subyearling Chinook with an adipose clip and a left ventral clip the user would press CHO AD and then press the LV button The Clr Mark button clears Clip Code and CWT fields At sites where condition fish are examined for CWT the 1 click of Clr Mark clears the Clip Code while the 2 click of Clr Mark makes CWT blank Weight and Length The En
119. f the Elastomer tag Blue Dark Green Dark Orange Green Mustard yellow Orange 90 Descaling The Descaling drop down list includes three choices for descaling including e Partial Descale for fish with descaling greater than 5 but less than 20 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 one of the Predator check boxes should be checked see Predator Checkboxes below D escaling Weight 1 Partial Descale Predator 2 Descale Injury 3 Descale irm 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 SO J 0019 FPC32 net has pre defined weight ranges for each of the condition monitoring target species If a weight is entered that is outside of this range the record can still be saved However when these data are imported into the Condition tab the suspect value will appear Red in the Data Review Grid This is intended to alert the user to an anomalous weight It is up to the user to decide if this weight is wrong or acceptable The table above provides the pre defined weight ranges that are used for data validation for each of the target species Fish Condition Catch Catch Deta
120. f the dewatering system in the juvenile bypass systems that removes water and increases the statistical density of fish within a given volume of water passing through the system Smolt An anadromous fish that is migrating down river towards the ocean In the SMP the use of the term smolt almost always refers to the four monitored anadromous fish species As a juvenile anadromous fish begin to move down river morphological changes can occur to the juvenile fish For example some species will silver up or become more silver in color As another example fall Chinook will become more football shaped as they reach the time to migrate downstream SMP Smolt Monitoring Program the program to monitor and evaluate the four main anadromous fish species in the Columbia Snake River basin Sub batch Each batch of electronic data sent from the remote sites to FPC can contain multiple sub batches but not all batches do Some batches only use the default sub batch number for the entire batch which is 01 Usually one creates a sub batch for each change in the sample rate during a 24 hour sample Up to 99 sub batches can be made for each batch of submitted SMP data Transportation At LGR LGS LMN and MCN sometimes referred to as the four collector sites juvenile anadromous fish headed downstream are collected and transported via barge or truck to a place in the river downstream from Bonneville Dam where they are unloaded bac
121. 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 Unclipped and CWT combination See 85 Section VII I for a detailed discussion of how to get these numbers from FPC32 net reports Num Trucked Enter the number of fish trucked for each Species Code Age Code Tank Special Species EF and Fry Clipped Unclipped and CWT combination see 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 2 Editin
122. fore the text box for Species Code will appear yellow when a new record is created until a Species Code is chosen by the user When a Species Code is chosen this field will have the two letter code of that species If the individual fish is a Chinook there will be a third digit corresponding to the Age Code 0 for subyearlings and 1 for yearlings This field is used for target species and incidentals that are entered with the Fish Condition Touch Screen 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 104 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
123. formation Other fish that are sampled but are not part of the detailed condition sub sample are considered non condition fish These non condition fish will be examined for descaling based on the FTOT protocol A fish will be recorded as descaled if at least 20 of either side of the fish is descaled Descaling is defined as areas of the fish where scales have been removed by mechanical or other means including predators and it cannot be determined that scales have regenerated or healing has occurred When in doubt examiner should report the fish as descaled Consistency is important since changes in descaling rate are what triggers management action Mortality Data Fish that are found dead in the sample or die during or after handling should be recorded as mortalities in the non condition sample See the Section 1 for more details about what data to record 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 reduced from historic sampling targets in an attempt to reduce fish handling The above target includes fish that are examined for detailed condition monitoring Recommended Sample Rates Sites should use the table below to
124. g 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 Conditions Tab The Conditions data entry tab allows users to edit browse individual fish from the condition sub sample that were entered through the touch screen For convenience the Sub batch Sequence Tank Species Age Code Special Species Code Coded Wire Tag Mark Type clip code and Elastomer Code are frozen on the left side of the data grid to help the user identify the row as they scroll to the right 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 t
125. h 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 A or B Tank None for BO2 JDA LGR and RIS indicates that these sites only have a single tank At MCN use Tank None to denote raceway 10 The Trap code only pertains to site IMN Choose either A or B to designate trap 8 M pp Teide aee Den Ur Eie EL er HI DEDE iz oM nrc iil Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Sub Batch 2 Sequence 1 Tank Trap m B Mone oample Code Validation Alert Species Code CH Chinook 91 0 OY 9M ONA Special Species n a 1 Collection System Multiplier Sample Rate 0 02 Cnni Species Code Click on the drop down list under Species Sub Batch 1 Sequence 4 Tank Trap Code and select the appropriate species code These are the only species codes that are allowed to be entered here Species Code CH Chinook Age DN Sue Coho Target Species Codes lici AER CH Chinook 57 ua O Coh ol bnd exam
126. hat have a fin clip either an adipose or ventral fin clipped Choose for Fin Clipped OY N those fish that do not have a fin clip CWT LGR LGS LMN WTB LEW and GRN are to examine all unclipped Chinook subyearling and yearlings coho and sockeye for coded wire tags Cwt OY 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 67 Special Species Code Click on the Special Species drop v AgeCode 1 down list and Choose one of the Special Species n a following codes FR EF LF or HO nda Select Sample EF Eroded finls Choose FR for Fry if fish is 60mm Or sample count 9978 Fery 0 less at all sites This code should only Num Cond be used for Chinook coho sockeye as these are the only species that have fry If Chinook is the species code than the Age Code must be entered as 0 since only age 0 Chinook can be fry Steelhead fry should be entered as an incidental species Rainbow trout in the Incidental Catch data entry tab The EF code for Eroded Fin s is for use only with unclipped steelhead If the dorsal fin or paired fins of the unclipped steelhead are clearly eroded as a result of being fro
127. he 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 17 d TeuchscreenSetup msi setup exe Windows Installer Package 2T 4 366 iz FPC32 NET This setup requires the 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 to do this now After selecting Yes your default internet browser will open to the URL http msdn microsoft com en us netframework aa569263 aspx e lf the dialog box asking you to choose Yes to install NET Framework does not appear manually open Internet Explorer and open the URL htto msdn microsoft com en us netframework aa569263 aspx OR Go to ftp ftp fpoc org FPC32 net right click on the file dotnetfx35 exe and choose Save Target as and navigate to a temporary file on your hard drive and save the file Double click on the file to begin the installation of the NET framework OR e lf you are installing this from a CD double click on the file dotnetfx35 exe from the CD directory and follow the installation procedure prompts using default prompts From the hittp msdn microsoft com en us netframewo
128. hese summarized condition data For example the records for the incidental species are only promoted to the Incidental Catch tab Clicking the Promote All button adds the summarized records to the appropriate data entry tab For convenience the Sub batch Tank Species Clip Code CWT Special Species Elast and Color codes are frozen on the left to help the user identify the row as they scroll to the right 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 their screen 96 D Remote SMP Site Data Entry Program a ioj xj Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site Catch Detail Sample Conditions Ssubbatch Sample Rate Editable E Sub Batches Sub Batches ane GC _ Promote All Batch 2 0 2 GC 4 b 5 ubbat ank D M mp it Elast E 5 ubbat ED Species Cod wapeciess wal Code length samp Ey
129. hn1 BrkAm SmAm PacMac LamUn Total TOTALS Sample Count 10 7 4 8 8 0 0 0 0 0 37 Collection Count 1000 0 140 0 400 0 160 0 160 0 0 0 0 0 0 0 0 0 0 0 1860 0 Num Exam for Desc 10 6 4 7 7 0 0 0 0 0 34 Num Descaled 0 0 0 0 0 0 0 0 0 0 0 Facility Morts 0 0 0 0 0 0 0 0 0 0 0 Sample 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 800 120 300 160 160 0 0 0 0 0 1540 Num Trucked 0 0 0 0 0 0 0 0 0 0 0 Num Barged 0 0 0 0 0 0 0 0 0 0 0 Descaling Pctg 0 00 96 0 00 96 0 00 96 0 00 96 0 00 96 0 00 96 IX B 2 Mark Recapture Report The Mark Recapture Report is the same as what 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 Color TAG Clip Supp Length Total 1A CH 1 EL z GR AD 142 1 1B CH 1 EL AD 137 1 1B 1 132 1 Subtotal Chinook Elastomers 3 Subtotal Chinook Freeze Brands 0 Subtotal All Marked Chinook 3 Subtotal Steelhead Elastomers 0 Subtotal St
130. hological 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 Tag ER Elastomer FB Freeze Brand gt FL Flopy Tag PH Photonic Tag Supplement visual Implant Notes e The location of Elastomer tags are built into the Mark Type code or You do NOT need to enter a Tag Brand Location for Elastomer tags see below e Coded Wire tags and PIT tags are internal marks that are not included in this entry screen Recaptured PIT tagged fish are reported directly to PTAGIS and not entered into FPC32 net Brand Location Click on the Brand Loc drop down menu and select a location code for Freeze Brand and Photonic Tags 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 Loc N A d and Orientati DL Double Left LA Left Anterior LD Left Dorsal Tag Color Code I LE Let Eye type was entered An error message is displayed LP LeftPosterior if the wrong location codes are used for the wrong 219 PH Usually Anal Fin RA Right Anterior Subbal 5 RD Right Dorsal RE Right Eye HP
131. iew 188 Computer descalingcodes 12 11 2008 6 10 PM AML Document 1 elascodes 12 31 2008 1 35 XML Document 1 Network fallbackcodes 12 11 2008 5 16 PM AML Document 3 2 fpcFish 2 1 2012 9 27 AM SQL Server Databa 2 176 KB 8l fpcFish log 2 1 2012 9 27 AM SQL Server Databa 1 024 KB GearCodes 11 4 2008 3 32 PM XML Document 1 incidentalspecies 1 12 2011 7 51 PM AML Document 9 KB markrecapspecies 11 4 2008 3 32PM XML Document 1 KB marktypes 12 18 2008 2 59 PM AML Document 1 5 orniecinnindental 2 25 2011 1 39 XM Dincument AER h 9 2R tems 22 Right click on the file named fpcFish mdf and select Properties This will open the fpcFish Properties dialog box Click on the Security tab and choose Users among the list of Group or User Names 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 If it does NOT select the Edit button Select Users again and check the Full Control box Click Apply and then OK Navigate to the directory C Program Files x86 Fish Passage Center FishCondition3 Data Right click on the file named fpcFish log LDF and select Properties This will open a dialog box titled Data Properties Click on the Security tab and choose Users among the list of Group or User Names Once Users has been selected look to see if Full Control has a check mark ne
132. il Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site 105 Sub Batch 2 Species Code Tank Trap B OY None Batch 09138 Sequence 74 Species choose Species Cade Special Species n a Miscellaneous Incidental choose Species Cade Mark Type AD Adipose Code M A Color Code M Comment 170 Special Comment Injury Head Operc Bedy Fin Fop Eye Fin Hemm Pink Fin Discol Eye Hemm Disease Fungus Columnaris Parasite Deformity Other 91 Length Enter the fork length of the fish in the Length field Length Is a required field for condition fish except miscellaneous incidentals Length is measured to the nearest millimeter and can range from 1 to 999 mm FL no decimal place is allowed for length Code Range ST 61 to 350 CO J 61 to 250 AB 70 to 250 AS 30 to 75 ST CO 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
133. ily and Collect Data SMP personnel at Lower Granite Dam will sample fish daily throughout the monitoring season at the JMF Collect species condition and external mark detail from all sampled fish Collect detailed condition and length data from a subsample of the sample Count and identify all incidental species caught in the samples Tally review enter into computer and transmit all data to FPC daily During 128 periods of low fish collection August to October 24 hour daily samples may be held and sampled every other day Milestone Al D Summarize and Verify All Sample Data on Days Collected at Lower Granite Dam Milestone Project Operations and Flow Data Collection SMP personnel at Lower Granite Dam will collect record and verify daily USACOE project operations and flow data and facility fish mortality within the bypass collection system Milestone AJ A Transmission of Project Data SMP personnel at Lower Granite Dam will transmit daily Corps 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 AO C Sample Fish Daily and Collect Data SMP personnel at Lower
134. included in their respective species columns in this section green box in figures below Page 1 FISH PASSAGE CENTER Date 1 13 2014 2 39 32 PM Site LGS Daily SMP Summary Batch 13364 from File LGS13364 XML Sample Start Date 12 29 2013 Sample Start Hour 0700 Gear Code GC Sample End Date 12 30 2013 Sample End Hour 0700 Sample Code 10 Number of Hours Sampled 24 Avg Total Discharge 100 kcfs Total Turbine Discharge 50 kcfs Avg Total Spill 50 kcfs Comments Test of special species codes in new Daily Summary and Daily Tank Batch reports CLIPPED TOTALS Chn1 Chno Total Sample Count 6 0 0 2 2 10 Collection Count 600 0 0 0 0 0 40 0 40 0 680 0 Num Exam for Desc 6 0 0 2 2 10 Num Descaled 0 0 0 0 0 0 Facility Morts 0 0 0 0 0 0 Sample Morts 0 0 0 0 0 0 Research Morts 0 0 0 0 0 0 PIT Tag Morts 0 0 0 0 0 0 Num Bypassed 600 0 0 40 40 680 Num Trucked 0 0 0 0 0 0 Num Barged 0 0 0 0 0 0 Descaling Pctg 0 00 96 0 0096 0 00 0 00 0 00 0 00 UNCLIPPED Chn1 ChFry CoFry Sock SoFry A Total TOTALS Sample Count 2 6 1 5 1 5 1 27 Collection Count 400 0 120 0 20 0 400 0 100 0 20 0 100 0 20 0 1180 0 Num Exam for Desc 6 0 5 0 5 0 24 Num Descaled 0 0 0 0 0 0 0 0 0 Facility Morts 0 0 0 0 0 0 0 0 0 Sample Morts 0 0 0 0 0 0 0 0 0 Research Morts 0 0 0 0 0 0 0 0 0 PIT Tag Morts 0 0 0 0 0 0 0 0 0 Num Bypassed 200 100 20 300 100 20 100 20 860 Num Trucked 0 0 0 0 0 0 0 0 0 Num Barged 0 0 0
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 155 Sub Batch 2 Species Code 5T TankTrap B None OY ON None Batch 09138 Sequence 74 Species choose Species Cade Special Species n a Miscellaneous Incidental Choose Species Cade Mark Type AD Adipose Code M A Color Code M A Descaling M A Gen Comment Weight Irr Predator Fish ers Special Comment Injury Operc Bedy Fin Fop Eye Fin Hemm Pink Fin Fin Discol Eye Hemm Disease Fungus Columnaris Parasite Deformity Other 92 Predator Checkboxes There are three checkboxes found near the Predator label These include Bird Fish and Lamprey fish has marking due to a
136. ing and Printing 133 NOXUPFGVIOUS T aO sestrscessesrotussueinivyqu 30002221 0093019 03 1 9243910122 4 00 112v 5059191 90005900 134 PONING aco PETRO HEU 134 Save Report 134 A 135 VI Sending SMP Data and Hand Logs to the 135 Sending New Batches Via 135 Uploading New Batches or Hand Logs Via 136 Sending Hand Logs to the 138 XI What s New with FPC32 net 2014 11 ee ceeeee Lesser liene nennen nnn annnm 139 New Contact Information for Fish Passage Center 139 XI B Hand Logs Now Be Uploaded Via the Web 139 Redesign of Daily Summary and Daily Tank Batch Reports 140 ALD Facility M rtalties TOF amples cedar br Edd ev lere bMS 142 Warning Pop up When Cancel Button on Touch Screen is Selected 142 XI F New Functions for Exit Panel Button on Touch 144 XI G Fully Functional Autoexport in Settings Staa 145 Newly Expanded Troubleshooting
137. ional 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 a Gear Code of 00 and a Sample Code of 3 PH 1 Flow or Turbine Discharge For all sites except BO2 and RIS PH1 Flow Turbine Discharge is the average hourly flow in Kcfs through the powerhouse during the sampling period of the batch For BO2 and RIS PH1 Flow is the average hourly 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 Army Corps of Engineers at the project o For BO2 obtain this value by subtracting BON 2 AVG DISCH from AVG TURB DISCH on the COE daily report e his field is not displayed at WTB IMN LEW and GRN e When daylight savings time begins and ends the period for calculating the PH1 F
138. ional data entry or export If newly entered records have not been exported to the XML file before the Exit Panel button was 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 return to touch screen so data can be exported to XML file Exit 4 Hide Screen Return 144 XI G Fully Functional Autoexport in Settings In the Settings dialog box there is a check box for automatically exporting batches when exiting FPC32 net While this check box has been there for years it has only applied to the Main Form Now this check box applies to both the Main Form and the Touch Screen lf this box is checked all data that are stored in the SQL Express database will automatically be written to the XML file for that batch and the program will close when exiting FPC32 net either from the Main Form or Touch Screen If this box is not checked th
139. ions may not be present 83 Remote SMP Site Data Entry Program lani xl Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Batch 10044 Species Code Chinook Code 1 Fin Clipped OY Cwt OY Special Species n a Num Bypassed 0 Num Trucked Num Barged 0 aE Tank species Code Age Code Clip 5 B Num Tucked Num Banged Import Edit Delete Refresh iecord Count 1 To edit a record double click on the record from the data entry grid at the bottom of the screen Each record has a sequence number to make the editing process easier for the user The data from the record then populate the data entry panel at the top of the screen and are editable Once necessary changes are made choose the Save button For ease of navigation the Tab Keys can be used to move between fields and Right and Left arrow keys can be used to move the cursor within a data field Below is a table of the fields of data that are entered into the Transportation data entry tab along with the default settings for each field prior to data entry Following this table is a list of the fields and instructions of the types of data that should be entered into each field and how Field Name Default Settings Site Set in setting dialog Batch Computed based on system date Sequence For each batch the f
140. irst 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 84 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 Tank 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 E Enc code from the list Winaok 0 Mum SO Sockeve ST Steelhead Special Species Code Click on the Special Species drop down list and choose one of the following codes e FR and 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
141. 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 Setting dialog box Site contains the three character code for the remote site entering the daily batch sub batch and fish condition data The batch number contains two digits for the year and three digits for the day of the year 1 366 YYDDD Sub Batch This is the sub batch number associated with each individual fish Each sub batch has an individual sample rate Sample rates for each sub batch are entered under the Catch Detail tab Tank At LGS LMN and MCN choose or to designate the correct tank Choose N A to designate fish from the separator 88 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
142. is report can be used to determine final collection counts for data entry of salmonid species into the Transportation data entry tab see Section VII I above Lamprey juveniles are not included in this report see Section IX B 8 below 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 Chinook 1 Chinook 0 Steelhead Coho Sockeye Total UC CWT ICL CWT Fry UC EF CL luc CWT CL Fry 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 of o o 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 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
143. iscussion of each To generate a report click on the Catch tab and select a batch Choose Reports and choose the report you want to generate from the drop down list Once a report is selected it may take a few moments for the report to open A report will open in a separate Report Viewing Window g ta Remote SMP Site Data Entry Program E 51 Mark Fi t 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 New Batch Jay Yesterda Total Discharge Turb Discharge Total Spill Boal Comments 1 Comments 2 Choose Comment P Daily Summary Report l 1 of 2 b b dg 100 al Percent Zoom Next Previous Save Report As Page Print Page 1 FISH PASSAGE CENTER Date 2 2 2011 240085 ote LGS Daily SMP Summary Batch 11032 from File 8511082 XML sample Start Date 13112011 sample Start Hour QOO Number of Hours Sampled 24 Sample End Date 202011 sample End Hour Oro sample Code 1 Avg Total Discharge 100 kets Avg Total Spill S0 kets Total Turbine Discharge 50 kets Comments The Report Viewing Window has several buttons at the top Hile that allow the user to perform different functions Below is a brief description of
144. ish will appear in the grayed area of Catch Detail tab and the Cond Sample Count column of the data grid Red boxes in figure below ETE SMP Site Data Entry Program mj gt Reports Summary Fish Condition Catch Site LGS Batch 09138 S 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 b Catch Detail Sub Batches Promote All 2 0 005 GC 3 4 MESE Tank Species OCA mno mam Nim t i l ami Pop Eve m an oO gt rm rr gt rm oO oO oO oO oOo oO oO Record Count 15 43 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 11025 Species Code Chinook Age Code 9 Fin Clipped 9 OY CON OMA Special Species n a nl mad NE 1 Gear Code GUC Gatewell Collection System Multiplier 5 20 0 0 2 0 2 Non Cond Est n and Sample Coun Collection Cond Sample Count g Collection Mum exam Mum Cond exam Num Cond 0 0 For descaled Num descaled For descaled descaled Total Exam 0 Total Mum 0
145. k Elements AB and AF and Snake River Trap Work Elements AC and AG the Statement of Work Report for the contract omolt Monitoring by Non Federal Entities Project 1987 127 00 states the following Milestone AB C Operate Trap for Collection of Data SMP personnel at the Salmon River Trap will operate 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 injury and mortality rates Milestone AB D Transmit Collection Data SMP personnel at the Salmon River Trap will electronically transmit salmonid collection data to FPC daily in a standard format determined by FPC This will be done from a site several miles upriver that has standard phone access Milestone AF A Transmit of Project Data SMP personnel at the Salmon River Trap will transmit electronically PIT tag tagging files within 24 hours Transmit flow data facility mortalities percent descaling daily Notify 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
146. k 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 11 A detailed site by site overview is provided below which outlines what type s of data are being collected Also below is a brief step by step outline of how the various types of data will be entered and processed using the FPC32 net data entry program 1 For 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 s
147. kley 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 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 25 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 ochockley fpc org The FPC 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 SQL Server Expres
148. l SPeCIES ENTE T T o D 68 d 69 Multiplier and Sample 69 NorisGond Sample COUN ers 71 Sl CONC CHOW 71 NUM Ee OVID CSC 72 CSCal OO 72 RENE RE ore 72 N E 73 Resear MOMS RTT 74 PUE TAMO mee 74 Promoted Summary Condition 74 VIII B 2 Editing or Deleting Catch Detail Records esses 75 Incidental Galen or att ae tod 75 VIII C 1 Definitions and Data 75 M rte ear eer ean ee ere een er eee ee 76 SIMPE COUN 77 MOIS MOINS em 77 Promoted Summary Condition 78 VIII C 2 Editing or Deleting Incidental Catch 78 VATI Mark ACCP Ue Fab unacum madii ned prn E ale 78 AME l Dennitlons ana Data ENUY scana 79 SUD A EERE A E A E 80 i o 80 PECES 80 POC COG E 81
149. lass cylinder approximately 1mm in diameter x 10 mm in length which contains a small coil and chip which transmit a tiny 134 7 kHz radio signal when excited by a 134 7 kHz radio frequency signal Raceway Part of the juvenile bypass system at main stem dams that are transportation sites LMN LGS LGR and MCN Raceways are large water troughs where the fish are stored awaiting transportation by truck or barge after they have passed through the bypass system and or the sample tanks and recovery tanks Rearing disposition A fish is reared in the wild or it is reared in a hatchery or where it was reared is unknown Remote site The locations remote to FPC where SMP sampling takes place There are currently four remote sites that are fish traps in rivers and seven remote sites at main stem dams on the Snake and Columbia Rivers Repost revise and resend When an SMP batch of data is resent to FPC from a remote site for any reason it is called a repost Reasons for reposting a batch of data can vary widely and include such things as intermittent Internet email failure and erroneous data entry that was not picked up by the error checking algorithms 10 Separator This is part of the juvenile bypass system at main stem dams which have a juvenile bypass system The separator is designed to let small fish pass through and keep mini jacks jacks and adults out of the juvenile bypass system The separator is also part o
150. lds 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 Starts at 1 The value of subbatch for the next record is MIN 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 only used for Chinook Default is none Coded Wire Default is none code Default is none The value of gear code is the same as the previous entry until the user changes the value Multiplier Default is set from the Setting dialog box The value of multiplier is the same as the previous entry until the user changes the value Sample rates Default is set from the Setting dialog box The value of sample rate is the same as the previous entry until the user changes the value There is only one sample rate per sub batch All number fields All number fields are initially set to zero Sub Batch The default for the first record is 1 If the sample rate changes during sample day create a new sub batch for
151. le is a text file formatted in xml notation External Mark Fish tags or marks which are readable through simple visual inspection Floy Tags Freeze Brands Elastomer Tags and Visual Implant tags are examples of External marks PIT tags and Coded Wire Tags are not considered external marks since they are not readable through simple visual inspection FPC32 net The current Windows version of the Fish Passage Center s Remote Site Data Entry Program for the Smolt Monitoring Project SMP This program can run under these operating systems Windows XP or Windows 7 Freeze Brands A form of external mark whereby a fish is branded with a mark using a super cold branding iron Ftp client A program installed on a computer that enables the user to download files from FTP sites on the Internet using File Transfer Protocol FTP Gas Bubble Trauma Monitoring Program Also referred to as GBT monitoring This is a monitoring program which examines fish after they pass through dams to monitor and measure biological effects from dissolved gas Incidental Catch Fish that are caught in the sample tanks at Remote SMP sites that are not one of the four main anadromous fish species whose passage is monitored in the Smolt Monitoring Program The target species for the SMP are Chinook Salmon Sockeye Salmon Coho Salmon Steelhead and juvenile lamprey both Pacific and Brook Lamprey Julian Date In Basin biological terms the number
152. lection system Milestone N E Collect 100 smolts for fish condition studies 100 smolts to be collected for fish condition studies for ongoing COE assessment Milestone N F Summarize and Verify All Sample Data on Days Collected at Bonneville Dam Milestone O A Transmission of Project Operations SMP personnel at Bonneville Dam will transmit daily Corps project operations flow data fish transport numbers facility mortalities percent descaling and average fork length data daily or every other day during low collections periods from August to October Ensure prompt transfer of data Notify FPC by phone whenever we cannot transmit data by 1400 hours on weekdays and or critical weekends via FPC32 Advise and discuss problems with FPC when they occur Milestone R C Sample Fish Daily and Collect Data SMP personnel at John Day Dam 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 R D Summarize and Verify All Sample Data on Days Collected at John Day Dam Milestone R E Collect 100 smolts for fish condition
153. left This field is blank if the fish does not have an Elastomer tag Color This field is where the Elastomer Tag Color is displayed Below is a list of the different color codes This field is blank if the fish does not have an Elastomer tag BL blue RE red GR green OR orange YE yellow PI pink PU purple OT other CWT This field indicates the presence Y or absence of a Coded Wire Tag Currently only LGR LGS and LMN examine condition fish for CWT For these sites the default value for CWT is blank for clipped Chinook coho and sockeye The default value for CWT is 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
154. lick TouchScreenSetup3_lamprey msi and choose Save Target As Navigate to c installfpc32net and save this file to this directory X FP directory FPC32 net a X FTP directory FPC32 net at ftp fpc org To view this FTP site in Windows Explorer press Alt click View and then click Open FTP Site in Windows Explorer Up to higher level directory 08 26 2011 11 45AM Directory BO 12 02 2008 01 52PM 206 692 864 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 D 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 log Once the files have been saved to your local hard drive using File Explorer navigate to c installfpc32net and double click on the TouchScreenSetup3 msi or TouchScreenSetup3_lamprey msi file to begin the installation process Note If you are installing this a CD open File Explorer and navigate to the directory of the CD and double click on t
155. lipped yearling Chinook subyearling Chinook sockeye and coho 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 Sample smolts from the collection for counts by species and clipped unclipped status Examine all unclipped yearling Chinook subyearling Chinook sockeye and coho 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 00 am and 7 00 am daily Sample smolts from the collection for counts by species and clipped unclipped status Examine all unclipped yearling Chinook for coded wire tags GBT monitoring is conducted at this site See Gas Bubble Trauma Monitoring Protocol and GBT net Data Entry Progr
156. lly identifiable Information without your implicit consent Restricts first party cookies that use personally identifiable Information without implicit consent Import Advanced Werau Web Sites override cookie handling Far individual Web sites click the Edit button 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 137 e EJ 17 Bh Page Teak i 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 with 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 files that are uploaded Currently th
157. low or Turbine Discharge will need to be adjusted For detailed instruction on these changes see Section VII M 1 above At JDA MCN LGS LMN and LGR the sum of the Turbine Discharge and Total Spill cannot be greater than the Total Discharge If this occurs an error message 1 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 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 08 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 This field is not displayed at LEW WTB GRN or IMN e When daylight savings time begins and ends the period for calculating the Total Spill will need to be adjusted For detailed instruc
158. m Disease Fungus Columnaris 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 42 default sample rate s are listed but need to be checked and corrected when applicable To do this right click in the Sample Rate cell in the Condition SubBatches box at the top of the Summary Cond screen A in figure below This allows you to manually enter the sample rate for each individual sub batch that was entered into the touch screen Once this is done click on the Promote All button When condition sample data are incorporated into the Catch Detail tab the sample counts for condition f
159. m a hatchery and is clearly not the result of wear and tear from passing through the juvenile bypass system use this code The LF code is for Lyons Ferry Hatchery yearling fall Chinook that are released either from Lyons Ferry Hatchery or at acclimation sites above Lower Granite Dam This code should only be used at Snake River sites The HO code is for Holdover yearling fall Chinook which can be identified by morphologic characteristics at the Snake and Lower Columbia River dams Those morphologic characteristics include downturned eye deep body deeply forked tail and relatively little descaling to differentiate from recently released hatchery fish A photograph comparing Yearling spring summer Chinook to a Holdover fall Chinook is shown below Size can partly be used to identify a Holdover fall Chinook as these fish are typically greater than 160mm However a few Holdover fall Chinook may be as small as 135mm These fish may be smaller than some spring releases of hatchery yearling fall Chinook Size alone is not a fool proof indicator Finally Holdover fall Chinook are typically observed in April and May The figure below compares a Yearling Sp Su Chinook top to Holdover yearling fall Chinook bottom size morphology and timing are useful for identifying HO fish 68 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
160. m 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 3 FPC32 net has built in sounds that prompt users when certain functions have been performed or need attention To hear these messages the Play Sound Checkbox must be checked NOTE to hear messages speakers need to be connected to the computer 4 NEW We have added a new feature in the Settings dialog box that will 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 they 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 box 5 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
161. made choose the Save button If no edits are necessary choose the Cancel button FPC32 net also allows the user to edit the Sub batch number and or Tank for multiple records at once To do this first check the box in the Edit column of the data grid for all the records you wish to edit Second select the Edit button Change the Sub batch and or Tank to the correct value for the records to be edited Press the Update Sub batch button to edit the sub sub batch for the records and or the Update Tank Trap button to edit the Tank Trap for the records Disease Fungus Columnaris BKD Parasite Deformit Other 95 New Subbatch 3 Mew Tank Trap 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 t
162. mined 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 74 VIII B 2 Editing or Deleting Catch Detail Records You can only edit one record from the Catch Detail data entry tab at a time To edit a record you must first select the record from the data grid at the bottom of the screen by double clicking on the record The data from the selected record will populate the data entry panel and can be edited The arrow next to the record is the best indicator of the selected record At this point edits can be made to the record Once edits are made choose the Save Record button 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 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 gri
163. 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 129 Milestone AL D Summarize and Verify All Sample Data on Days Collected at McNary Dam Milestone AL E Project Operations and Flow Data Collection SMP personnel at McNary Dam will collect record and verify daily USACOE 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 4 For Little Goose Dam Work Elements D and E the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 states the following Milestone
164. move that Elastomer tag location and tag color General Comments Sub batch Tank and Special Comments These buttons allow the user to enter the appropriate Sub batch Tank and Comments for each individual fish When the user selects Gen Comments a popup appears with the general comment text field and a keyboard Users are allowed to enter two comments per field separated by a semicolon Pressing Submit enters the comments into the database The Clr Gen Comments button clears the General Comments text field Submit Cancel When the user begins entering data Sub batch defaults to 1 To change the Sub batch the user should push the Sub batch button Each time the Sub batch button is pressed the Sub batch number increases by 1 If the user presses the Sub batch button too many times the user can press the Clr Sub batch button to return the Sub batch number to 1 110 Where applicable the user selects the Tank A or Tank B button for the appropriate tank The Tank A and Tank B buttons toggle on and off Once Tank A or Tank B is selected for a single fish that tank is carried on to subsequent fish until a different tank or sub batch is chosen by the user These Tank buttons are hidden for BO2 JDA and LGR When the user selects Special Comments a popup appears with the general comment text field and a keybo
165. n This information is summarized for the entire batch in the Daily 44 Batch Tank Report which can be generated by selecting Reports and choosing Daily Batch Tank Report All Subbatches from the drop down menu This report should be printed The data that are to be entered into the Transportation tab can be found in the rows labeled Total Collection and Sample Facility Research Morts i e mortalities see figures below NOTE For each tank all columns should be entered into the Transportation tab as separate records Holdovers and Lyons Ferry fish are included in the UC CWT or CL columns for Chinook 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 LGR Comments Tank B Page 2 Site LGS Subbatch Sample Code 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 0 0 AI 10 Test of special species codes in new Daily Summary and Daily Tank Batch reports Chinook 1 ICL o ol 0 0 o 0 0 o 0 0 o o o 00 FISH PASSAGE CENTER DAILY BATCH TANK REPORT Batch 13364 UC 0 0 Sample Start Date Sample End Date 12 29 2013 12 30 2013
166. n 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 header As mentioned earlier sorting by multiple headers is possible To do this simply hold down the Shift key while selecting the column headers in the order you wish to sort them by This data grid allows the user to view all entered data for a single batch for error checking and or validation For each of the data entry tabs one or more of 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 prog
167. n entered and the Save New button has been pushed push the Cancel button to end data entry for this screen 9 Once all non condition records have been entered these data should be validated from the hand logs by printing or viewing the Daily Batch Tank Report and or the Lamprey Batch Tank Report To view these reports chose Reports and select Daily Batch Tank Report and or Lamprey Batch Tank Report A separate report can be generated for each sub batch that was entered It s best to do this level of validation prior to incorporating the condition data into the Catch Detail tab via promotion see Section VII H 38 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 6j Batch 11026 Species Code CH Chinook Age Code 2 Fin Clipped Special Species n a 5 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 Collecti
168. nce Tank A or None Clip Unciip Tally CH1 8 0 CHO 12 22 ST 3 2 CO 0 1 2 SO 1 4 0 45 0 OMP 1 Total 24 31 Tank B Clip Unciip Tally CH1 13 CHO 12 1 ST 3 Total Incidental 3 Total Sampled 131 5 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 100 co 10 11 12 13 Press New The background panel turns white meaning that the computer will accept data If the background panel is gray the computer will beep when you press a button because it is not in the New or Edit mode Where applicable select the Tank for the sub batch you are currently sampling Turn On the scale and add the tray the scale automatically tares or calibrates to compensate for the weight of the tray place the fish in the tray and press the Print button on the scale Note You do not need to place the tray on the scale between fish but you may need to Tare the scale occasionally between fish Enter the fish Length using the touch screen number pad Press the appropriate Species Clip Condition and Tagging buttons
169. nce a weight has been entered the weight field will turn from yellow to white and the corresponding weight will appear e lf this weight is incorrect press the Clear Weight button on the touch screen and then press the Print button on the scale Enter the fish length using the touch screen number pad Using the number pad on the touch screen automatically shifts the focus to the length field e Once a length has been entered the length field will turn from yellow to white and the corresponding length will appear e lf this length is incorrect press the Clear Length button on the touch screen and then re enter the correct length Press the appropriate Species Clip and Other Condition buttons e Once a species has been selected the species field will turn from yellow to white and the corresponding species code will appear For those sites with tanks the Please Enter Tank Trap warning will disappear once a tank is chosen Records cannot be saved until a tank is chosen 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 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 betw
170. nes 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 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 XI A New Contact Information for Fish Passage Center Staff The Fish Passage Center moved its offices in the fall of 2013 As a result we have all new phone and fax numbers Below is a list of our new address and phone numbers for your reference Address 847 NE 19 Ave Suite 250 Portland OR 97232 Main Phone Number 503 833 3900 Brandon s Phone Number 3 503 833 3907 Jerry s Phone Number 003 833 3909 Lynnae s Phone Number 503 833
171. ng on the file name Choose Edit Copy Edit View Favorites Tools Help lt a 2 Search Folders s E X Address CuUfpc3z 5509007 ml 1 7200 Document ka 5509002 xml 1127200 Document E 05508947 xml 1211912 Document E 155083246 xml ified 1211212 ML Document E 408339 xml 5 1211112 ML Document default S3 12 5 20 Win Wwedge Configur deFaull1 5 V3 3115 20 win Wedge Configur E Boz 08340 xml 1215120 ML 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 this point you can rename the fish condition XML file in order to avoid confusing it with the final batch file that will later be saved and sent to FPC e Torename 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 S
172. nk B tallies above Total Incidental Tally C in figure to below This tally is the total number of Miscellaneous Incidental Species that are entered via the touch screen Total Sampled Tally D in figure below This tally is the total number of fish Salmonids and Miscellaneous Incidentals that have been entered via the touch screen for a single batch 107 Tank None Clip Unciip Tally Tank and None Clip Unclip T ally gm 0 111 13 CHO 178 oe CHO 0 ST 2 ST 13 4 CO 0 2 CO Oy 0 50 19 4 SO D 0 I AB 0 AS 0 1 Total 124 1 Total 247 31 Tank B Elip LInclip T ally A Tank B Clip Unciip Taly E UM 131 7 CHO 1 CHO 12 9 Ep 44 7 ST 3 CO 0 1 0 11 50 0 50 4 1 9 Total 11 1 0 AS AP 1 MF 1 Special Species T ally Total 32 41 otal Tank B 0 0 0 Soecial Species Tally ela B E Tatal EF 0 1 0 Total Ho 0 0 0 8 0 1 0 Total LF 0 0 0 Total Incidental e Total Incidental 3 Total Sampled 216 4 D gt Total Sampled 131 Touch screen tallies Touch screen tallies for BON for LGR LGS and JDA and MCN incorporates LMN lamprey juveniles VIILH 5 Fish Condition Touch Screen Condition Species and Mark Type Buttons The condition species and mark type buttons on the Fish Condition Touch Screen
173. nk 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 The sample rate for each of the sub batches in the review panel is applied to the Cond Sample Count to produce the Estimated Cond Collection this field cannot be edited The program adds the Cond Sample Count and Non Cond Sample Count together to produce the Total Count After promoting the Total Collection is estimated This estimate is based on the Total Sample Count and the Sample Rate Depending on what Sample Rate is used there are times when this Total Collection is NOT equal to the sum of the Condition and Non Condition Collections due to rounding The program then adds the fields Num Exa
174. nook Minijack 43 Chinook Minijack Hatchery J2 Chinook wild Chiselmouth P 0 Cond 76 Code Name Code Name Bass Large Mouth Bass Small Mouth Pech Bluegill and Pumpkinseed SQ Pike Minnow Northern Bullhead PI Salmon Pink juv Cap SR Channel SC AdultChinook SA Adult Hatchery Chinook SJ Adult Wild Chinook RS JgShinerRedside Chinook Jack 12 22 in SP Siberian Prawn Chinook Jack Hatchery A4 SockeyeAdut O A 7 AB SK SN SG BU lU MU Sculpin species Shad Adult Shad Juvenile nj Sockeye Adult Hatchery Steelhead Adult Wi BM BS BL BH CP Lee OM A5 _ A9 41 Chi J J4 Ch J3 Chinook Minijack Hatchery J2 ChinookMinijack Wild CM UM Chum J A2 X Z A6 CohoAdult Hatchery AA CohoAdut Wid CR __ Crappie species Sucker Largescale LD Dace LongNose X SD Dace Specked SU gSucker Other AD KeltAdut TT fench jKeltAdult Hatchery Trout Brook AF jKeltAdut Wild BK KO Trout Cutthroat L LK Loe LIR Tro
175. o Run the program the computer begins downloading and installing the NET Framework 3 5 software NOTE If you receive a message that the NET framework is already installed on your computer proceed to the next step 11 Once the installation of this software is complete you will also be required to install Microsoft SQL 2005 Express 12 Download Microsoft SQL 2005 Express from the FPC website ftp ftp fpc org FPC32 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 2 FTP directory FPC32 net a X FTP directory FPC32 net at ftp fpc org To view this FTP site in Windows Explorer press Alt click View and then click Open FTP Site in Windows Explorer Up to higher level directory 08 26 2011 11 45AM Directory BO 12 02 2008 01 52PM 206 692 864 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 4 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
176. o not match you must change the sample rate in Catch Detail See Section VIII B 1 above for instructions on how to do this Remote SMP Site Data Entry Program 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 b E T Promote All Batch 2 02 GC 1 0 01 09138 3 A Fish Condition Touch Screen The Fish Condition Touch Screen allows users to enter individual fish condition data To open the touch screen to enter fish condition records for a new batch with the Setting dialog Fish Condition Touch Screen Only checkbox checked double click on the FPC32 net icon The touch screen will open on the computer s desktop 98 To open the touch screen to enter fish condition records using an existing batch record with the Setting dialog Fish Condition Touch Screen Only checkbox unchecked double click on the FPC32 net icon Right click on the FPC32 net icon in the system tray and choose Open Main Form From the Main Form choose the 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
177. 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 an SMP remote sample site it is called a mark recapture or mark recap The marks that are considered external are elastomer tags freeze brands floy tags and visual implants PIT tags and coded wire tags and blank cheek tags are not considered external marks Multiplier The mathematical inverse of the sample rate 1 one over the sample rate or 1 sr Pick List Drop down menu List Box or any popup menu which uses a scrolling highlighted bar to mark the desired choice PIT tag Passive Integrated Transponder Tag This is an internal mark which is used in the SMP predominately to measure travel time down the hydro system SMP PIT tag marking sites are generally Rock Island White Bird Lewiston Imnaha and Grand Ronde The PIT tag is a small g
178. ograms and Windows components 4 A dialog box appears asking you to confirm the removal of FishCondition3 choose Yes to uninstall FishCondition3 Follow the prompts to uninstall the program 5 After the program has been uninstalled follow the instructions for installing FPC32 net Section VI B above NOTE 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 VII D 2 below if you encounter this problem VID Troubleshooting FPC32 net VI D 1 Windows 7 Procedure to Allow Full Control When 2 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 whether SQL Express database files can be written to by the current user If this is the case the user will 21 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 MpcFish dbf is read onl
179. oid 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 only Fry are not to be examined as part of the condition monitoring as this would mandate anesthetic and increase the time that they are handled In general sites should begin working up the smallest fish and fish that are deepest in anesthetic first and move to larger fish The Fish Passage Center FPC The Fish Passage Center FPC provides current and historic data on salmon and steelhead passage in the main stem Snake and Columbia River Basins Data from the Smolt Monitoring Program SMP are intended to provide the information basis for federal state and tribal recommendations for fish passage in the Federal Columbia River Hydro electric System In addition to real time access to SMP data the FPC 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
180. ol 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 mortality is externally marked elastomer tagged or freeze branded the following steps must be taken o Enterthe mort as a regular mortality o Entera 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 NEW Currently COE biologists do not identify lamprey facility mortalities e g race way 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
181. on Mum exam Mum Cond exam Mum Cond 0 0 0 For descaled Num descaled For descaled descaled Total Exam Total Mum Total Sample Count Total Collection 0 p EE al Far descaled Descaled Sample Morts O Facility Morts 0 Research Marts PITTag Morts 0 5 ubbat EN specie NE 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 39 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 lf Condition Data include incidental species this validation step should be done prior to incorporating the condition data into the In
182. on Records into FPC32 NET Main Form 35 VII C 2 Creating a New Batch Record Directly from the FPC32 net Main Form for sites where no condition data are collected 36 VII D Entering Non Condition Fish Data Catch 37 Entering Ineidental ate 39 VILE Enterng MarkK Pecaplure Dala iiusissusesnbesu ensevenescnedentesadedenesienesluisaberiasensbeseulesbjeneseaed 40 MEG Validating co ta ate 41 VII H Promoting Condition Data into the 42 Entenng Transporation Dalee uae ru teo nag RE hae zu Prae gusce Earl Esc 44 VII I 1 Manual Entry of Transportation 45 VII I 2 Importing Data from Catch Detail for Transportation Data Entry Tab 46 VILE Validalrig BalCcllassvizudesesesdsusasvsdaVsa veda a0 oda Yao o Ia da os ee ava Vv Lea ia do Yu Yo V YE Eos va Da Vu a OR aU 47 E o firs g 16 anes tes RES tm EE 49 VEs WACO ME em 50 ee IDEA 51 VII M 1 Daylight Savings Time 51 VII M 2 Sampling End Date is the Same for Two Batches 51 Detailed Data Entry Instructions
183. ontinuous flow of river water Small samples of fish will be re anesthetized using a light buffered solution of MS 222 before being moved into the sampling trailer and placed in a full strength buffered solution of MS 222 Fish will be identified by species and examined for marks indicating hatchery origin and descaling Anesthetized with will recover in a separate holding tank and be released after they have recovered from anesthesia Milestone V D Collect Biological Data Collect biological data from salmonid migrants captured in the collection facility from 1 April to 31 August 2014 Data will be recorded daily to include by species total count adipose fin clipped unclipped status CWT presence absence other external or internal marks or tags smolt condition and descaling Milestone W B Transmit Data Transmit daily project operations flow data fish transport numbers facility mortalities percent descaling and average fork length data daily Ensure prompt transfer of 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 3 For Lower Granite Dam Work Elements Al and AJ Lower Monumental Dam Work Elements AO and AP and McNary Dam Work Elements AL and AM the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 state the following Milestone Al C Sample Fish Da
184. ook are to be assigned an age of 1 or O based on morphology and size A discussion of the morphological criteria can be found in Section VIII B 1 Chinook fry are age 0 Special Species Code There are four possible Special Species Codes that are to be recorded for particular target species of the SMP These four Special Species Codes correspond to salmonid juveniles only Below is a brief explanation of each of the Special Species Codes along with details as to which target species apply Eroded Fin EF for unmarked steelhead with eroded fins This Special Species Code is used to identify hatchery steelhead that are otherwise unmarked Lyons Ferry Yearling Fall Chinook LF for yearling fall Chinook that are known to have been reared at Lyons Ferry hatchery Holdover Fall Chinook HO for yearling fall Chinook that are identified as being holdovers based on size and morphology See Section VIII B 1 for detailed description of how to identify holdover fall Chinook Fry FR for Chinook coho and sockeye fry based on size 60mm or less See Section 1 3 below for fry handling protocol 2 Clipping Marking and Tagging Data In order to aide in the identification of origin the SMP collects information on the clipping marking and or tagging of target salmonid species Below is a brief explanation of the various clipping marking and tagging information that are to be collected for the SMP See Sections VIII B 1 and V
185. or 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 consistent with the fall Chinook shown below Additionally holdover fall Chinook should be assigned as age 1 66 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 shaped Spring Summer Chinook yearling Caudal fin forked usually edged in black Parr marks large vertical oblong shapes centered on lateral line and wider than interspaces Anal fin rays short wedge shapes usually not pigmented Large spots on back Body narrower eyes larger nose more rounded than subyearling fall Chinook Fin Clipped Choose Y for those fish t
186. or 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 subbatch 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 70 Remote SMP Site Data Entry Program File Reports Catch Detail Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site 35 Sub Batch Sequence 2 Tank Trap Batch 11027 Species Code CH Chinook Age Code 9 Mar S E enmt Fin Clipped 0 9M OY 9M Special Species n a ubbat Sample Gear Code GC Gatewell Collection System ste 0 02 Confirm Overwrite Sample Rate g Est Sample Count ion F tus era ERN Dao you want to ovewrite the sample rate O descale with 0 2 For descaled Total Sample Count Total Collecti Sample Morts Facility Marks Subbat Sequen Tank Cod Cad CWT M ulti
187. p li t 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 100 sample rate gear code of GC and tank none Any mortalities associated with these lamprey should also be recorded If species ID is not possible use species code LU when recording in Catch Detail Est Collection FPC32 net automatically calculates this field by dividing Sample Rate into Sample Count This number is then rounded to the nearest hundredth place Using integer multipliers instead of sample rates will reduce any rounding errors that may appear in the calculated quantity The Estimated Collection is a calculated number and should not be edited EXCEPT when entering Separator Mortalities see Facility Morts below The Est Collection can only be overwritten if a sample rate of 100 is chosen 71 Num Exam for Descal The Num Exam for Descal is a calculated field Num Exam Descal Sample Count Sample Morts This equation assumes that 100 of the non condition sample excluding sample mortalities was examined for descaling If this is not the case you may enter the correct
188. ple 1 Anomalous LEngin ENUY as coe eoo aa eee ten S activerain 117 IX A 3 Data Entry Error Message 118 Example 1 Flow and Spill Data 118 AAA Data ROMIN tenebit ai ao deviant Desc due etd tl uds 118 Example t EMENI A 119 119 IX B 1 Daily Summary 119 IX B 2 pepe Dove reden 121 Incidental Caten too EIE obruo 121 Fish Condition ERA 122 IX B 5 Individual Fish Condition 122 IX B 6 Daily Batch Tank 123 IX B 7 Special Species Daily Batch Tank 124 X B 8 Lamprey Batch Tank 125 XG FPOW eekly ValidatlOPisuaue oc voe Pss etta SERRA DIU 126 DD FPG Validation Spreads heele 126 EDndor Year esdas 126 IX F Project by Project Details for SMP Reporting Requirements 127 X Printing Daily Reports and Sending Data to FPC 133 XA Generat
189. predator or predators check all of the boxes that apply NOTE Detailed definitions of each of these predator conditions are provided in a separate manual Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site 105 Sub Batch 2 Species Code Mone OY OM Batch 09138 Sequence 74 Species choose Species Cade Special Species n a Miscellaneous Incidental Choose Species Code Mark Type AD Adipose Code M A Color Code M A Descaling MA Gen Comment Weight af Length 170 Predator Bird Fish Lamprev Special Comment Injury Eve Operc Bedy Fin Fop 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 p
190. ram 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 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 53 1 Definitions and Data Entry To view the Catch tab of the FPC32 net Main Form either double click on the FPC32 net icon on your desktop if program not already running or right click on 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 the batch records that are in the temporary database in the data grid near the bottom Each batch is represented by a single row in this data grid Creating 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 Ca
191. re Summary Report To view this report chose Reports and select Mark Recapture If Condition Data include Mark Recapture data this validation step should be done prior to incorporating the condition data into the Mark Recaptures tab via promotion see Section VII H Remote SMP Site Data Entry Program mi x 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 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 Supplemental Code Length Mon Cand Count Cond Count Total Count Delete Note Cond Count and Total Count will be filled in automatically when Condition Data are incorporated 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
192. rect 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 oet in setting dialog Computed based on system date Sequence For each batch the first incidental catch record sequence starts at 1 and continues sequentially All number fields are initially set to zero These fields include sample count condition count total count and sample mortalities Species Code Click on the Species Code drop down list within the cell and select the appropriate species and species code The list is sorted alphabetically by Incidental Species Name NOT Incidental Species Code Species Code 1 Chinook Adult AT Chinook Adult Chinook Adult Hatchery 9 Chinook Adult wild Chinook Jack J5 Chinook Jack Hatchery Chinook Jack wild J Chi
193. red Therefore an alert Red Dot is provided to alert the user to the suspect combination Remote SMP Site Data Entry Program E mJ x File Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Start 1 31 2011 Hour O00 End Day Today Batch 47092 End 2 72011 Hour 0700 New Batch End Day Tomorrow Gear Code GC Gatewell Collection System Sample Code Mk Eune Be Sample Hours 2 9 New Batch Creed Wak 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 is 116 limited to steelhead a Red Dot appears along with a Special Species Validation Alert to alert the user of the suspect combination For more details on which Species Special Species combinations are valid see Section VIII B 1 Special Species Code Remote SMP Site Data Entry Program oj xl File Reports Catch Detail Catch Incidental Catch lark Recaptures ransportation Conditions Summary Cond Special Species Validation Alert Site 105 Sub Batch 1 Sequence 1 None Batch 11032 Species Code CH Chinook 91 00 Clipped OY 9N OY SN Special Species in 3 mon Exampl
194. rk aad569263 aspx website select the INSTALL IT NOW button NET Framework Downloads Download and install the NET Framework SDKs readmes and more NET Framework 3 5 Service Pack 1 Download NET Framework 3 5 Service Pack 1 The NET Framework 3 5 Service Pack 1 5P1 delivers more controls a streamlined setup improved start up performance and powerful new graphics features for client development improved AJAX support and other improvements for Web development The NET Framework 3 5 SP1 delivers Performance increases between 20 45 for WPF based applications without having ta change any code WCF improvements that give developers more control over the way they access data and services Streamlined installation experience for client applications Improvements in the area of data platform such as the ADO NET Entity Framework ADO NET Data Services and support for SQL Server 2008 s new features Download and install the NET Framework 3 5 SP1 Bootstrapper now Install it now 18 9 Once the NET Framework 3 5 installation program has completed downloading choose to Run the program Internet Explorer Security Warning Do you want to run this software Mame dotnethx35setup exe Publisher Microsoft Corporation More options while Files Fron the Internet can be useful this File type can potentially harm your computer Only run software From publishers vau trust What s the risk 10 After you choose t
195. rovided in a separate manual Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS SubBatch 2 Species Code B None OY ON None Batch 09138 Sequence 74 Species choose Species Cade Special Species p a Miscellaneous Incidental Choose Species Code Mark Type AD Adipose Code M A Color Code M Descaling MA Gen Comment Weight af Length 170 Predakor Special Comment PepEve _ Fin Hemm PinkFin Discal Eye Hemm Disease Fungus Columnaris BED Parasite Deformity Other 93 Disease Checkboxes There are six checkboxes found near the Disease label These include Fungus Columnaris BKD Parasite Deformity and Other Check all boxes that apply for a diseased fish If the fish has a disease other than one of these check the Other box and type in a comment in the Special Comment field TIP To save time when entering a comment into the Special Comment field use predefined codes for particular conditions Also up to two comments can be entered into this field as long as they are separated by a semicolon NOTE Detailed definitions of each of these diseases are provided in a separate manual Fish Condition Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS SubBatch 2 Species Code
196. rowsing panel The Previous button cannot be used if a record is active i e data entry editing is allowed Cancel The Cancel button is used to cancel entering a new record or to cancel editing a record Export The Export button saves the condition records to an XML file named with the site and batch number The location where this file is saved is specified in the Setting dialog box for your wet lab computer Upon successful export the user will hear a prompt and see an icon under the data review panel 103 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 Species CH1 5 Species Clip Code AD Elast ER Color RE T Gen Comment Spec Comment Predator Fish Weight Injury Other cond Fin Hemm Disease Site LGS Batch 09138 S batch 1 Sequence 141 The Top Section A 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 There
197. s Service not Found It is probably not installed Please reboot you PC before contacting technical support 26 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 10096 default setting is selected B Control Panel All Control Panel Items Display nil Control Panel Home Make it easier to read what s on your screen Adjust resolution You can change the size of text and other iterns on your screen by choosing one of these options To B temporarily enlarge just part of the screen use the Magnifier tool My Calibrate color Change display settings Adjust ClearType text Preview Set custom text size DPI Medium 125 Larger 150 Apply 27 VII A FPC32 net Settings Dialog Box Once FPC32 net is installed an icon will appear on your desktop Double click on the FishCondition icon on your computer desktop This opens the program By default the program is set to open to the Batch Data tel 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
198. s quantity is subtracted from Sample Count and the result is the Num Exam for Descaling Mortalities are NOT examined for descaling NOTES e mortality is externally marked elastomer tagged or freeze branded the following steps must be taken o Enterthe mort as a regular mortality o Entera 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 72 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 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 protoc
199. screpancy the FPC validates two additional batches for the same week The FPC then contacts the appropriate site via e mail requesting that necessary corrections be made and corrected batches be reposted See Section VII L for reposting instructions When reposting batches sites are required to include a description of what data have been changed and why FPC WILL NOT UPDATE BATCHES UNLESS PROPER DOCUMENTATION IS RECEIVED IX D FPC Validation Spreadsheets In addition to weekly validation the FPC will send all sites a set of validation spreadsheets generated form our SQL database This will be done weekly These spreadsheets should be checked against the data in your electronic batches If discrepancies are found then follow normal reposting procedures see Section VII L Rows for days with no data are included and batch numbers are included in each row to facilitate the use of pivot tables in spreadsheet programs to subtotal and grand total the counts by species rearing disposition batch number etc IX E End of Year Validation When sampling for the year is completed each site must send an e mail to notify the FPC staff that the sample season has ended This e mail should state the final batch number If necessary this e mail will also request a yearly validation spreadsheet including the data from the site for the entire year which should match the sites own data records After you have validated your end of year data against the FPC valid
200. studies 100 smolts to be collected for fish condition studies for ongoing COE assessment 127 Milestone R F Project Operations and Flow Data Collection SMP personnel at John Day Dam will collect record and verify daily USACOE 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 2 For Rock Island Dam Work Elements V and W the Statement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 state the following Milestone V C Collect Fish for Examination Fish will be collected continuously during the monitoring period Fish will be examined during regular work hours 0800 1630 hrs unless large numbers of fish are entering the flume of the bypass trap in which case with would be removed and recorded as the appropriate sample days catch Fish will be delivered via the bypass elevator in a 12 x 4 x 3 5 aluminum holding talk which will be plumbed for c
201. t 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 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 and See Section VIII B 1 for a detailed discussion of each of these Special Species Codes EF E raded finis LF Lyons Ferry Hold over 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 The Mark Type drop down list includes choices for what type of clip a fish has adipose adipose and Weight AD Adipose left ventral etc Use N A if individual condition AL Adipose Left Ventral Predator fish does not have any type of clip Adipose Aight Ventral Injury LV Left Ventral Only AY Right Only Elas Code Elas Code The Elas Code drop down list includes choices for a fish with an Elastomer tag and its location EH Elastomer Right Other LN Unknown Type Color Code The Color Code drop down list allows the user to choose the color o
202. tal species choose Miscellaneous Incidental Species and choose the appropriate button from the pop up menu To enter specific fish condition data press the appropriate button on the touch screen For a detailed description of each of these buttons and what types of data should be entered see Section VIII H below The data are saved to the database behind the touch screen and appear on the bottom left corner of the touch screen Most of the buttons are toggle buttons which means that pressing the button once adds the selected condition to the fish record and pushing the same button again removes the condition from the fish record There are some buttons where only one choice can be selected These include Species or Species Clip Special Species Descaling and Elastomer Tag Orientation Color buttons 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 bution creates a batch with the end date matching today s date the Batch End Day Tomorrow button creates a batch with the end date matching tomorrow s date and the Batch End Day Yesterday button creates a batch with the end date matching yesterday s date The Batch End Day Tomorrow button should only be used if a sample is being worked
203. tch 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 5 x Reports Batch Info Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site LGS Mew Batch End Day Today Batch 99738 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 hour date 09138 10044 2 12 2010 0700 2 13 2010 0700 09156 56 4 2009 0700 6 5 2009 0700 131 91 105 72 D 10043 2 11 2010 0700 2 12 2010 0700 100 02 50 01 0 Save As Batch Import From Batch Delete Record Count 4 54 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 Tomorro
204. tement of Work Report for the contract Smolt Monitoring by Non Federal Entities Project 1987 127 00 states the following Milestone J C Operate Trap for Collection of Data SMP personnel at the Lower Grande Ronde River Trap will operate trap 5 nights week March 5 May 26 This will mean lowering the trap to begin the sample period at 6 00 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 130 data on incidental fish captured Monitor fish injury rates and mortality due to trapping and sampling procedures and modify as necessary to minimize injury and mortality rates Milestone J D Transmit Collection Data SMP personnel at the Lower Grande Ronde River Trap will electronically transmit salmonid collection 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 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 6 For the Salmon River Trap Wor
205. ter Weight and Enter Length buttons allow the user to return focus of the number key pad to the corresponding field This allows the user to use the number pad to enter in the data into the desired field The Clr Weight and Clr Length buttons clear the values in the weight or length fields and also return focus of the number key pad to the corresponding field Species Special Species and Miscellaneous Incidental Species These buttons allow the user to enter the following Species data 1 CH1 AD for yearling Chinook with an adipose clip 2 CH1 for unclipped yearling Chinook 3 CHO AD for subyearling Chinook with an adipose clip 4 CHO for unclipped subyearling Chinook 5 ST AD for steelhead with an adipose clip 6 ST for an unclipped steelhead 7 CO AD for a coho with an adipose clip 8 CO for an unclipped coho 9 SO AD for a sockeye with an adipose clip and 10 SO for an unclipped sockeye In addition to these BON JDA and MCN will be doing condition monitoring for lamprey juveniles The species codes for juvenile lamprey are 1 AB for Ammocoete Brook 2 AP for Ammocoete Pacific 3 AS for Ammocoete Unknown and 4 MP for Macropthalmia Pacific The Species Code is a required field and only one species button can be pushed for each fish If the wrong species button is pressed by mistake simply press the correct species button to overwrite the mistake 113 Fish Condition Touch Screen species codes for
206. tered Many of these validation process result in Alert Error Messages that alert the user to a possible error in data entry It s important to note however that FPC32 net was designed to allow the user to save all data that are entered by the user regardless of whether the data were a were entered in error The details for many of the various data checking algorithms are explained in the detailed instructions for entering data in Section VIII However there are too many validation procedures throughout FPC32 net to guarantee that we have covered them all The Alert Error Messages fall into a couple of basic categories Below is a detailed explanation of the various Alert Error Messages that a user may encounter when entering data with FPC32 net followed by examples of each IX A 1 Suspect Data Entry Alert Red Dot When a user is entering a combination of data that are outside of the validation criteria a Red Dot will appear on the suspect data entry This alerts the user that something on the current data entry screen does not agree with the current validation criteria and warrants further investigation Example 1 Improper Gear Code Sample Code Sample Hours Combination When creating a record in the Catch tab this user entered a Gear Code of 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 ente
207. the batch with the fish condition records you just imported by clicking on the record in the data grid Selected records have an arrow beside the batch 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 Fora detailed description of each of these fields and what types of data should be entered see Section VIII A 1 below 35 Remote SMP Site Data Entry Program Oj x 2 File Reports Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site 02 New Batch End Day Today Batch New Batch Gear Code Choose Gear Code End Day Tomorrow Sample Code Choose Sample Code v Sample Hours New 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
208. the previous record until the sub batch number is changed by the user e Given this it is critical that you verify that the sample rate for each sub batch is correct before saving the first record of each sub batch Section VIII B provides detailed information for correcting the sample rate if you find that the wrong sample rate was entered for a sub batch 5 Enter Non Cond Sample Count Num Exam for descaling Num descaled Sample Morts Facility Morts Research Morts and PITTag Morts where appropriate e When sample code is NOT GB the field for Num Exam for Descaling will calculate automatically based on what is entered into the Non Cond Sample Count and Sample Morts fields for all species and special species combinations except for lamprey juveniles and fry using the following equation Num Exam for Descaling Non Cond Sample Count Sample Morts This assumes that 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 Descaling is not assessed 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 bee
209. the push of a button However this feature only works with users who have Microsoft Outlook configured in their office 135 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 pushing this 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 Automatically Export Last Selected Batch When Exit New Batch End Day Tomorrow E Play Sound 9 0 New Batch Site BO Dam Powerhouse 2 End Day Yesterday Gear Code Select Default Gear Code Sample Rate Sub 1 0 005 200 0 5 0 005 Sample Rate Sub 2 20 5 0 0 05 Default Start Hour End Hour Edit Sample comment 1 aS Save As Batch Custom Comment 2 Sample comment 2 E Sys abyss i Sample comment 3 5 Import From Batch ara EIE Delete Uploading New Batches or Hand Logs Via HTTP Instead of e mail new batches and hand logs can also be
210. the value Age Default is none This field is only used 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 by the IMN Trap Enter A or B to designate trap Species Code Species Code Click on the Species Code drop down list and select the appropriate species code from the list box Only choose RT for Rainbow Trout if you encounter marked rainbow trout HT Rainbow Trout SU Sockeye ST Steelhead 80 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 morp
211. tion on these changes see Section VII M 1 above At JDA MCN LGS LMN and LGR the sum of the Turbine Discharge and Total Spill cannot be greater than the Total Discharge If this occurs an error message Is displayed e 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 Date is the same for two batches see Section VII M 2 above Comments2 has a drop down menu that allows for entry of common comments during certain periods FPC32 net allows for up to three user defined comments that can be edited throughout the season by the users These user defined comments are available in the Comment2 drop down menu These user defined comments can be edited in the Settings dialog box of FPC32 net see Section VII A 7 above 2 Editing Records in the Catch Data Entry Tab Adjusting Batch Numbers and Creating Batches for Past Dates To create a batch that corresponds
212. 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 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 99 Remote SMP Site Data Entry Program 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 Batches You can only edit one batch at a time Each batch is stored on the local computer in a database unless it has been deleted by the user If a batch has been deleted by the user it can be re imported into the database To do this from the Catch tab choose Import From Batch and navigate to the directory where the final XML files are being saved to the office computer hard drive Select the XML file for the batch you want to import and choose Open To edit a batch you must first select the Catch data entry tab from the FPCS32 met Main Form Using the scroll bars in the data grid at the
213. to which Batch End Day button was selected when initially opening the touch screen Sub batch This field is where the Sub batch number is displayed Up to 999 sub batches can be displayed in this field Sequence This field is where the Sequence number of the individual fish record is displayed Each sub batch starts with a sequence number of 1 and each record is incremented by one If a record is deleted that sequence number is deleted with it The deleted sequence number cannot be used again in the current sub batch 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 and None and Ta
214. top Another dialog box appears again highlight USB mass storage device and press OK A 34 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 lt lt Importing a Batch From the Condition Sample or Creating a New Batch Creating a new batch in the Catch Data Entry Tab Form i e Main Form depends on whether condition data were collected or not If condition data were collected as described in 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 VII C 1 Importing Daily Fish Condition Records into FPC32 NET Main Form 1 From the office computer double click on the FishCondition icon on the desktop The office computer should be configured so that the Main Form opens by default The Main Form window opens with the Catch tab forward 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
215. toring can be found in a separate document entitled Condition Sampling Protocol L B gt Summary 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 nerka 3 Coho kisutch and 4 Steelhead mykiss Among the larval and juvenile lamprey that are considered target species are 1 pacific lamprey Lampetra tridentatus ammocoetes 2 pacific lamprey tridentatus macropthalmia 3 brook lamprey Lampetra richardsoni ammocoete and 4 unknown ammocoete The above species make up the majority of the fish that are collected for the SMP However incidental species are also of interest Incidental species should also be identified and counted The Fish Passage Center recommends using the Columbia River Basin Juvenile Fish Field Guide published by Pacific States Marine Fisheries Commission for identifying juvenile fish and incidental species 2 Species Specific Data to Collect For each of the target species there are additional species specific data that are to be collected for the SMP Below is a brief explanation of each of these pieces of species specific data Age Code Age Code is used for Chinook only Chin
216. ual 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 only used by the SMP trap sites and not visible for other non trap sites Imnaha River Trap enter 1 2 3 or 4 for trap positions 1 4 e Lewiston Trap enter or east when the trap is in its normal position e Whitebird Trap enter the number of meters the trap is from the northern cable tower e g 10m 30m 50m or 10 30 50 e Grande Ronde River Trap enter the number of 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 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 or 00 e SMP Sites at Dams can use all Gear Codes except Gear Code 00 must be used when there is no sample conducted in a collection period Gear Code GC Gatewell Collection Systen Unknown 00 Sample F5 Facility 5 ample GB Separator for GBT GD Gatewell Dip GP Gatewell Airlift Purnp MT Migrant Trap Sample Code The default Sample Code is which means Normal Complete Sample f you wish to change this click on the Sample Code drop down list and select the desired Sample
217. ut Rainbow BT ON Killifish Banded LT Kokanee CT Lamprey Adult Brook RT WE Walee WA Wamouh LW Whitefish Lake MW Whitefish Mountain 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 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 CP CC A1 A5 A9 J1 J5 J4 JO J3 J2 CM UM A2 A6 AA CR LD 50 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 LP LK and LR 77 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 Spe
218. w selected Default start hour is set to 0700 can be edited in the Start hour setting dialog Default end hour is set to 0700 can be edited in the End hour setting dialog Trap location Trap location is left blank Default gear code is set to GC can be edited in the Gear code setting dialog Default sample code is set to 01 can be edited in the sample code setting dialog Sample 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 hour prior to the end date Format MM DD YYYY Start Hour The default start hour is carried forward from the Settings screen Section If the listed Start Hour is incorrect enter the actual start hour in 24hr military time Numbers less than 0000 or greater than 2400 are restricted from entry here 55 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 YYYY End Hour The default end hour is carried forward from the Settings screen Section If the listed End Hour is incorrect enter the act
219. xt to it in the list of Permissions for Users 10 If it does NOT select the Edit button Select Users again and check the Full Control box Click Apply and then OK 23 152 fpcFish Properties Object name C Program Files amp 66 Fish Passage CentersFishCc Group or user names SYSTEM 38 Administrators PANAQUE2 Administrators 1 A Users PANAQUE Users To change permissions click Edit Permissions for Users Full control Modify Read amp execute Read Write Special permissions For special permissions or advanced settings click Advanced Advanced Leam about access control and permissions Data Properties Object name C Program Files amp 86 Fish Passage Center FishCc Group or user names SYSTEM Administrators PANAQUE2 Administrators 4 Users PANAQUE Users d 4 change permissions click Edit Pennissions for Users Full control Modify Read amp execute List folder contents Read For special permissions or advanced settings click Advanced Leam about access control and permissions VI D 2 Problems with SQL Express Occasionally 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
220. y 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 DataMpcFish log ldf 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 DataMpcfish 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 Data Organize Include in library Share with Burn New folder Sr Favorites Mame Date modified Type Size EE Desktop brandcodes 11 4 2008 3 32 PM XML Document 1 KB Downloads E brandloccodes 1 29 2009 310 PM Document 2 KB Recent Places brandorientationcodes 11 24 2008 1 09 PM XML Document 1 KB 12 brands 11 4 2008 3 32 XML Document 1 Libraries clipcodes 12 9 2009 5 39 PM Document 1 Es Documents colorcodes 3 11 2009 3 50 PM XML Document 1 Music 2 comments 11 2 2009 6 59PM XML Document 1KB 3 E Pictures condclipcodes 2 25 2009 2 58 PM XML Document 1 B Videos condspecies 12 11 2008 5 16 PM XML Document 1 KB oe a EJ DefaultSetup 2 11 2010 5 57 PM Text Document 1 KB prev
221. y 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 78 p Remote SMP Site Data Entry Program Ini xj File Reports Mark Recaptures Catch Catch Detail Incidental Catch Mark Recaptures Transportation Conditions Summary Cond Site 155 Sub Batch Sequence 2 Tank Trap Batch 10044 Species Code CH Chinook Code 9 Mark Type ER Elastomer T ag Fight Brand Loc Brand Code M A hd Brand Orientation Tag Number Tag Color N Clip Code M Supplemental Code Length Count 0 Count Total Count sens er tna A 1 Edit Delete Record Count 1 VIILD 1 Definitions and Data Entry Before any data can be entered or edited in the Mark Recaptures data entry tab the user must specify which batch they intend to add edit data to by selecting the corresponding batch in the Catch data entry tab Once a batch has been selected in the Catch tab you may navigate to the Mark Recaptures data entry tab 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 detaile

here - Fish Passage Center

Contents

Download Pdf Manuals

Related Search

Related Contents