FCRR
Implementing Microsoft Excel Software For Rapfish: A Technique For The Rapid Appraisal of Fisheries Status
Publication
Fisheries Centre Research Reports, Vol. 12 No. 2 Pages: 75pp
2004 | PDF
2004 | PDF
TABLE OF CONTENTS
| Director's Foreward | 2 |
| Summary | 3 |
| Introduction | 3 |
| Rapfish Software Development Requirements | 4 |
| Rapfish Excel VBA Software Design Description | 5 |
| Software Architecture | 5 |
| User Interface Form: Enter Data, Run Rapfish Analysis and Options | 6 |
| Rapfish Analysis Procedure with the User Interface Form | |
| Parameter Input and Selection | 7 |
| Rapfish Algorithm | 8 |
| Attribute Leveraging | 10 |
| Monte Carlo | 11 |
| Monte Carlo Parameters | 11 |
| Monte Carlo Algorithms | 12 |
| VBA Subroutines | 15 |
| Multi-Dimensional Scaling Using ALSCAL Fortran DLL | 19 |
| Rapfish Installation and Use | 21 |
| Installation Description | 21 |
| Software Installation Steps | |
| Configure Excel for using Rapfish software | 22 |
| The Rapfish Toolbar and Troubleshooting | 23 |
| A Rapfish Test Run | 24 |
| Analyzing Your Own Fisheries Scoring Data | 24 |
| How to Edit the Rapfish Add-In for Further Development | 25 |
| Rapfish: What does it all mean? | 26 |
| Interpretation | 26 |
| Rapfish Error and Variability | 27 |
| Sustainability Calibration | 27 |
| Dominant Attributes | 28 |
| Future Rapfish development | 29 |
| Multiplicative Utility: Rapfish-M | 31 |
| References | 33 |
| Annexes | 34 |
| Annex 1: Published Papers Using Rapfish | 34 |
| Annex 2: The ALSCAL FORTRAN DLL | |
| 2a: ALSCAL DLL Build Procedure | 35 |
| 2b: ALSCAL FORTRAN DLL Function Interface Syntax | 36 |
| 2c: Visual Basic Calling Syntax for ALSCAL DLL | 38 |
| 2d: Parameters for ALSCAL DLL Multi-Dimensional Scaling | 39 |
| Annex 3: VBA Code for Rapfish Excel Add-in | 42 |
| Annex 4: VBA routine to label points in Excel x-y graph | 75 |
