Ongoing Research
This PRIVATE area is referenced only in the link
on the Research Home page. It contains data that will be updated as
this work evolves. Its purpose is to provide a convenient way to share raw data from
ongoing work without having to update and email large data files. It also provides an independent backup for the data on my
personal computer.
Use the public pages on the web site to access necessary background information.
The raw details of all fabrics/netting are also available in the ACCESS file
Fabrics and are reproduced in
EXCEL in the file
FabricMaster. I keep these
files reasonably up to date.
 | A short summary is provided in a
WORD file for each experiment. The EXCEL file
contains the detailed raw information for all species and is easy to interpret. The ultimate point of reference for all raw data is an ACCESS database (Canada nzi.mdb). This is my personal compendium of trapping work done since 1999 and is not public. Only older data have been made publicly available. |
| To produce species summaries for each experiment,
the data for each logical experiment are first exported through an ACCESS query
that collates several data entry tables. This information is sent to an EXCEL template that can be revised to accommodate each experimental design. The EXCEL file contains various scratch worksheets and a simple macro to calculate log(X+1) transformed data. The various templates provide flexible pivot tables for creating data summaries and graphs, given basic knowledge of EXCEL. |
| The transformed catches from EXCEL are exported to
SYSTAT to run ANOVAs for statistical inference. These are provided as raw output in a RTF file (Rich
Text Format). The MSE (Mean Square Error) values from the ANOVA tables are then entered into each EXCEL worksheet by taxa; sample sizes and degrees of freedom are entered into a common worksheet. The EXCEL worksheets are set up to calculate all necessary statistics, including confidence intervals for the Response Ratios for each taxon. The EXCEL file also contains a worksheet to compile response ratios for collation with other work. |
| Country | Area | Habitat | Details | ANOVAs | Systat Commands | Data |
| WORD | RTF | TEXT | EXCEL | |||
| Bionet / Econet & Crystal Clear 20/20 Nzi traps | ||||||
| 3x3 and 4x4 Latin squares, Locally-made Nzi trap added in Sudan2 | ||||||
| Sudan | Khartoum | Farm | Sudan1.doc | Sudan1.rtf | Sudan1.syc | Sudan1.xls |
| Sudan | Khartoum | Farm | Sudan2.doc | Sudan2.rtf | Sudan2.syc | Sudan2.xls |
| Phthalogen Blue, Local Blue cotton, Sunbrella Pacific Blue and Turquoise cotton Nzi traps | ||||||
| 4x4 Latin squares, All traps with white nylon netting | ||||||
| Sudan | Khartoum | Farm | Sudan3.doc | Sudan3.rtf | Sudan3.syc | Sudan3.xls |
| Country | Area | Habitat | Details | ANOVAs | Systat Commands | Data |
| WORD | RTF | TEXT | EXCEL | |||
| Turquoise Nzi and/or Plywood Nzi traps versus local greenhead control traps | ||||||
| Turquoise and/or Painted Plywood Nzi traps tested against greenhead control traps | ||||||
| USA - 2007 | Cape Cod | Salt Marsh | CapeCod1.doc | CapeCod1.rtf | CapeCod1.syc | CapeCod1.xls |
| USA - 2008 | Cape Cod | Salt Marsh | CapeCod2.doc | CapeCod2.rtf | CapeCod2.syc | CapeCod2LSQ.xls |
| Country | Area | Habitat | Details | ANOVAs | Systat Commands | Data |
| WORD | RTF | TEXT | EXCEL | |||
| Bionet / Econet & Crystal Clear 20/20 and Turquoise Nzi traps | ||||||
| 4x4 Latin square, and Survey trapping at a farm with a few horses | ||||||
| USA | Michigan | Lakeside | Mears1.doc | Mears1.rtf | Mears1.syc | Meras1.xls |
| Expt | Context | Notes | Details | ANOVAs | Systat Commands | Data |
| WORD | RTF | TEXT | EXCEL | |||
| Idle Farm on outskirts of Ottawa, Canada - a few horses and goats present | ||||||
|
Sequential 4x4 Latin squares during
tabanid season, WEEKLY trap checks Bionet, Econet-L, Sunbrella variations |
||||||
| Farm1 | Summary | Low Res photos | Farm1 Web.doc | 3.7 MB | ||
| High Res photos | Farm1.doc | 13.8 MB | ||||
| Both replicates | Risk basis | Farm1 Risk.rtf | Farn1 Risk.syc | Farm1 Risk.xls | ||
| Replicate 1 only | Risk basis | Farm1 Risk Rep1.rtf | Farm1 Risk Rep1.syc | Farm1 Risk Rep1.xls | ||
| Replicate 2 only | Risk basis | Farm1 Risk Rep2.rtf | Farm1 Risk Rep2.syc | Farm1 Risk Rep2. xls | ||
|
Alternative ANOVA |
Raw weekly catches | Farm1.rtf | Farm1.syc | Farm1.xls | ||
| Matched Weekly data |
All 2007 Farm vs Russell |
FarmRussell.xls | ||||
|
6 x 6 Latin square in Farm3, Collated
Tabanid Data in Farm123, WEEKLY trap checks Bionet, Econet-L, Crystal Clear 20/20 variations Sunbrella acrylic & Top Notch polyester variations & Turquoise cotton |
||||||
| Farm3 | Summary | Integrated discussion | Farm3.doc | |||
| 6x6 Latin square | Stomoxys comparisons | Farm3 Risk.rtf | Farn3 Risk.syc | Farm3 Risk.xls | ||
| Turquoise trap data | Extra control trap at fixed site | Farm3 Extra.xls | ||||
| Farm123 |
Collated Experiment |
Tabanid comparisons | 6 trap types compared | Farm123 Tab.rtf | Farm123 Tab.syc | Farm123 Tab.xls |
| Collated for the year | Stomoxys comparisons | Top Notch Blue polyester only | Farm123 Sto.rtf | Manual statistics | Farm123 Sto.xls | |
| Consolidated Data | All 2007 work at the Farm | FarmAll.xls | ||||
|
2x2 Latin squares replicated 6 times,
four sequential sets at start of tabanid season with Hybomitra present Ageing Cow urine, Baited versus unbaited, Various Nzi traps at different sites |
||||||
| Farm4 | Summary | Integrated discussion | Farm4.doc | |||
| First half, low catches | Urine at 2 ml/day | Farm4Rep12.rtf | Farn4Rep12.syc | Farm4Rep12.xls | ||
| Second half, high catches | Urine at 4 ml/day | Farm4Rep34.rtf | Farn4Rep34.syc | Farm4Rep34.xls | ||
| Qualitative Trap Comparisons | Farm4Traps.rtf | Farn4Traps.syc | Farm4Traps.xls | |||
|
12 x 12 Latin square comparing cow
urine, octenol, phenols, turpentine in various combinations Various minor variations on Nzi traps simultaneously tested with several rotations among sites |
||||||
| Farm4 | Summary | Integrated discussion | Farm5.doc | |||
| Bait Comparisons | Farm5.rtf | Farn5.syc | Farm5.xls | |||
| Trap Comparisons | FarmTrap.rtf | FarnTrap.syc | FarmTrap.xls | |||
