| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Area | Space | Monitor # | Insect | Quantity | Pest? | Stage | Date checked | Season | Space area (m2) | Monitors in this space | Time exposed (in days) | POI | This table would be your base table where you can input all the basic information. | ||||||||||||
2 | Storage | A | 2 | Ant | 1 | No | Adult | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.01319374353 | Note that the POI is a calculated field | ||||||||||||
3 | Storage | A | 4 | Ant | 1 | No | Adult | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.01319374353 | Every column is intended to help you filter out information for your pivot tables by column information | ||||||||||||
4 | Storage | A | 2 | Cricket | 1 | Yes | Adult | 20-Dec-22 | Spring | 168.43 | 5 | 90 | 0.01319374353 | |||||||||||||
5 | Storage | A | 2 | Cricket | 1 | Yes | Immature | 15-Mar-22 | Summer | 168.43 | 5 | 75 | 0.01583249223 | |||||||||||||
6 | Storage | A | 3 | Cricket | 1 | Yes | Remains/Exuviae | 15-Mar-22 | Summer | 168.43 | 5 | 75 | 0.01583249223 | |||||||||||||
7 | Storage | A | 5 | Cricket | 1 | Yes | Immature | 21-Sep-22 | Winter | 168.43 | 5 | 93 | 0.0127681389 | |||||||||||||
8 | Storage | A | 2 | House fly | 1 | No | Immature | 21-Sep-22 | Winter | 168.43 | 5 | 93 | 0.0127681389 | |||||||||||||
9 | Storage | A | 3 | Uknown | 1 | No | Adult | 21-Sep-22 | Winter | 168.43 | 5 | 93 | 0.0127681389 | |||||||||||||
10 | Storage | A | 5 | Uknown | 1 | No | Adult | 20-Dec-22 | Spring | 168.43 | 5 | 90 | 0.01319374353 | |||||||||||||
11 | Storage | A | 1 | Pillbug | 1 | No | Adult | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.01319374353 | |||||||||||||
12 | Storage | A | 3 | Pillbug | 1 | No | Adult | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.01319374353 | |||||||||||||
13 | Storage | A | 4 | Household casebearer moth | 1 | Yes | Larva | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.01319374353 | |||||||||||||
14 | Storage | A | 5 | Household casebearer moth | 1 | Yes | Adult | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.01319374353 | |||||||||||||
15 | Storage | A | 3 | Booklice | 1 | Yes | Adult | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.01319374353 | |||||||||||||
16 | Storage | A | 4 | Webbing clothes moth | 1 | No | Adult | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.01319374353 | |||||||||||||
17 | Storage | A | 4 | Uknown | 2 | No | Adult | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.02638748705 | |||||||||||||
18 | Storage | A | 1 | Spider | 3 | No | Adult | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.03958123058 | |||||||||||||
19 | Storage | A | 3 | Spider | 3 | No | Adult | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.03958123058 | |||||||||||||
20 | Storage | A | 4 | Spider | 3 | No | Adult | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.03958123058 | |||||||||||||
21 | Storage | A | 5 | Spider | 3 | No | Adult | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.03958123058 | |||||||||||||
22 | Storage | A | 3 | Ant | 3 | No | Adult | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.03958123058 | |||||||||||||
23 | Storage | A | 3 | Household casebearer moth | 3 | Yes | Larva | 20-Jun-22 | Fall | 168.43 | 5 | 90 | 0.03958123058 | |||||||||||||
24 | Storage | A | 2 | Spider | 6 | No | Adult | 20-Dec-22 | Spring | 168.43 | 5 | 90 | 0.07916246116 | |||||||||||||
25 | Storage | B | 2 | Ground beetle | 1 | No | Adult | 20-Dec-22 | Spring | 35.13 | 4 | 90 | 0.07907138565 | |||||||||||||
26 | Storage | B | 3 | Ant | 1 | No | Adult | 20-Jun-22 | Fall | 35.13 | 4 | 90 | 0.07907138565 | |||||||||||||
27 | Storage | B | 3 | Cricket | 1 | Yes | Adult | 20-Jun-22 | Fall | 35.13 | 4 | 90 | 0.07907138565 | |||||||||||||
28 | Storage | B | 1 | House fly | 1 | No | Adult | 15-Mar-22 | Summer | 35.13 | 4 | 75 | 0.09488566278 | |||||||||||||
29 | Storage | B | 1 | Pillbug | 1 | No | Adult | 15-Mar-22 | Summer | 35.13 | 4 | 75 | 0.09488566278 | |||||||||||||
30 | Storage | B | 4 | Barklice | 1 | Yes | Adult | 15-Mar-22 | Summer | 35.13 | 4 | 75 | 0.09488566278 | |||||||||||||
31 | Storage | B | 1 | Spider | 2 | No | Adult | 21-Sep-22 | Winter | 35.13 | 4 | 93 | 0.1530413916 | |||||||||||||
32 | Storage | B | 4 | Spider | 2 | No | Adult | 21-Sep-22 | Winter | 35.13 | 4 | 93 | 0.1530413916 | |||||||||||||
33 | Storage | B | 1 | Barklice | 2 | Yes | Adult | 20-Jun-22 | Fall | 35.13 | 4 | 90 | 0.1581427713 | |||||||||||||
34 | Storage | B | 4 | Drain fly | 3 | No | Adult | 20-Jun-22 | Fall | 35.13 | 4 | 90 | 0.2372141569 | |||||||||||||
35 | Storage | B | 1 | Household casebearer moth | 4 | Yes | Larva | 20-Dec-22 | Spring | 35.13 | 4 | 90 | 0.3162855426 | |||||||||||||
36 | Storage | C | 2 | Spider | 1 | No | Adult | 15-Mar-22 | Summer | 234.93 | 7 | 75 | 0.008107784892 | |||||||||||||
37 | Storage | C | 5 | Spider | 1 | No | Adult | 20-Dec-22 | Spring | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
38 | Storage | C | 4 | Carpet beetle | 1 | No | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
39 | Storage | C | 6 | Carpenter ant | 1 | Yes | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
40 | Storage | C | 7 | Mosquito | 1 | No | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
41 | Storage | C | 6 | Earwig | 1 | No | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
42 | Storage | C | 3 | Ant | 1 | No | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
43 | Storage | C | 1 | Cricket | 1 | Yes | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
44 | Storage | C | 1 | Cricket | 1 | Yes | Immature | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
45 | Storage | C | 5 | Cricket | 1 | Yes | Immature | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
46 | Storage | C | 7 | Cricket | 1 | Yes | Adult | 15-Mar-22 | Summer | 234.93 | 7 | 75 | 0.008107784892 | |||||||||||||
47 | Storage | C | 1 | Pillbug | 1 | No | Adult | 15-Mar-22 | Summer | 234.93 | 7 | 75 | 0.008107784892 | |||||||||||||
48 | Storage | C | 2 | Household casebearer moth | 1 | Yes | Larva | 20-Dec-22 | Spring | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
49 | Storage | C | 7 | Household casebearer moth | 1 | Yes | Larva | 20-Dec-22 | Spring | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
50 | Storage | C | 7 | Booklice | 1 | Yes | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
51 | Storage | C | 5 | Barklice | 1 | Yes | Adult | 21-Sep-22 | Winter | 234.93 | 7 | 93 | 0.006538536204 | |||||||||||||
52 | Storage | C | 7 | Barklice | 1 | Yes | Adult | 21-Sep-22 | Winter | 234.93 | 7 | 93 | 0.006538536204 | |||||||||||||
53 | Storage | C | 1 | Drain fly | 1 | No | Immature | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
54 | Storage | C | 1 | Carpet beetle | 1 | Yes | Remains/Exuviae | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
55 | Storage | C | 3 | Carpet beetle | 1 | Yes | Remains/Exuviae | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.00675648741 | |||||||||||||
56 | Storage | C | 6 | Spider | 2 | No | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.01351297482 | |||||||||||||
57 | Storage | C | 5 | Household casebearer moth | 2 | Yes | Larva | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.01351297482 | |||||||||||||
58 | Storage | C | 5 | Booklice | 2 | Yes | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.01351297482 | |||||||||||||
59 | Storage | C | 7 | Carpet beetle | 2 | Yes | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.01351297482 | |||||||||||||
60 | Storage | C | 3 | Spider | 3 | No | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.02026946223 | |||||||||||||
61 | Storage | C | 4 | Cricket | 3 | Yes | Immature | 15-Mar-22 | Summer | 234.93 | 7 | 75 | 0.02432335468 | |||||||||||||
62 | Storage | C | 1 | Household casebearer moth | 3 | Yes | Larva | 15-Mar-22 | Summer | 234.93 | 7 | 75 | 0.02432335468 | |||||||||||||
63 | Storage | C | 4 | Household casebearer moth | 3 | Yes | Larva | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.02026946223 | |||||||||||||
64 | Storage | C | 4 | Spider | 4 | No | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.02702594964 | |||||||||||||
65 | Storage | C | 6 | Uknown | 5 | No | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.03378243705 | |||||||||||||
66 | Storage | C | 3 | Household casebearer moth | 5 | Yes | Larva | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.03378243705 | |||||||||||||
67 | Storage | C | 1 | Spider | 6 | No | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.04053892446 | |||||||||||||
68 | Storage | C | 7 | Springtail | 8 | No | Adult | 15-Mar-22 | Summer | 234.93 | 7 | 75 | 0.06486227914 | |||||||||||||
69 | Storage | C | 4 | Springtail | 21 | No | Adult | 20-Jun-22 | Fall | 234.93 | 7 | 90 | 0.1418862356 | |||||||||||||
70 | Storage | C | 5 | Springtail | 27 | No | Adult | 21-Sep-22 | Winter | 234.93 | 7 | 93 | 0.1765404775 | |||||||||||||
71 | Storage | D | 1 | Spider | 1 | No | Adult | 21-Sep-22 | Winter | 71.87 | 4 | 93 | 0.03740325648 | |||||||||||||
72 | Storage | D | 2 | Spider | 1 | No | Remains/Exuviae | 20-Jun-22 | Fall | 71.87 | 4 | 90 | 0.03865003169 | |||||||||||||
73 | Storage | D | 3 | Spider | 1 | No | Adult | 20-Jun-22 | Fall | 71.87 | 4 | 90 | 0.03865003169 | |||||||||||||
74 | Storage | D | 1 | Springtail | 1 | No | Adult | 20-Jun-22 | Fall | 71.87 | 4 | 90 | 0.03865003169 | |||||||||||||
75 | Storage | D | 4 | Ant | 1 | No | Adult | 15-Mar-22 | Summer | 71.87 | 4 | 75 | 0.04638003803 | |||||||||||||
76 | Storage | D | 2 | Uknown | 1 | No | Adult | 15-Mar-22 | Summer | 71.87 | 4 | 75 | 0.04638003803 | |||||||||||||
77 | Storage | D | 2 | Household casebearer moth | 1 | Yes | Larva | 20-Jun-22 | Fall | 71.87 | 4 | 90 | 0.03865003169 | |||||||||||||
78 | Storage | D | 4 | Household casebearer moth | 1 | Yes | Larva | 20-Jun-22 | Fall | 71.87 | 4 | 90 | 0.03865003169 | |||||||||||||
79 | Storage | D | 3 | Webbing clothes moth | 1 | Yes | Adult | 20-Dec-22 | Spring | 71.87 | 4 | 90 | 0.03865003169 | |||||||||||||
80 | Storage | D | 2 | Springtail | 2 | No | Adult | 20-Dec-22 | Spring | 71.87 | 4 | 90 | 0.07730006339 | |||||||||||||
81 | Storage | D | 2 | House fly | 2 | No | Adult | 20-Jun-22 | Fall | 71.87 | 4 | 90 | 0.07730006339 | |||||||||||||
82 | Storage | D | 4 | Spider | 3 | No | Adult | 20-Jun-22 | Fall | 71.87 | 4 | 90 | 0.1159500951 | |||||||||||||
83 | Storage | D | 1 | Ant | 3 | No | Adult | 20-Jun-22 | Fall | 71.87 | 4 | 90 | 0.1159500951 | |||||||||||||
84 | Storage | D | 1 | Uknown | 3 | No | Adult | 20-Jun-22 | Fall | 71.87 | 4 | 90 | 0.1159500951 | |||||||||||||
85 | Storage | D | 2 | Spider | 4 | No | Adult | 20-Jun-22 | Fall | 71.87 | 4 | 90 | 0.1546001268 | |||||||||||||
86 | Storage | D | 2 | Cricket | 4 | Yes | Adult | 15-Mar-22 | Summer | 71.87 | 4 | 75 | 0.1855201521 | |||||||||||||
87 | Storage | D | 3 | Ant | 8 | No | Adult | 15-Mar-22 | Summer | 71.87 | 4 | 75 | 0.3710403043 | |||||||||||||
88 | Storage | D | 2 | Ant | 9 | No | Adult | 15-Mar-22 | Summer | 71.87 | 4 | 75 | 0.4174203423 | |||||||||||||
89 | Storage | E | 2 | Spider | 1 | No | Adult | 20-Jun-22 | Fall | 44.5 | 4 | 90 | 0.06242197253 | |||||||||||||
90 | Storage | E | 2 | Ant | 1 | No | Adult | 20-Jun-22 | Fall | 44.5 | 4 | 90 | 0.06242197253 | |||||||||||||
91 | Storage | E | 1 | Uknown | 1 | Yes | Adult | 20-Jun-22 | Fall | 44.5 | 4 | 90 | 0.06242197253 | |||||||||||||
92 | Storage | E | 3 | Household casebearer moth | 1 | Yes | Adult | 20-Jun-22 | Fall | 44.5 | 4 | 90 | 0.06242197253 | |||||||||||||
93 | Storage | E | 3 | Drain fly | 1 | No | Adult | 20-Jun-22 | Fall | 44.5 | 4 | 90 | 0.06242197253 | |||||||||||||
94 | Storage | E | 4 | Ground beetle | 1 | No | Remains/Exuviae | 21-Sep-22 | Winter | 44.5 | 4 | 93 | 0.06040836052 | |||||||||||||
95 | Storage | E | 4 | Webbing clothes moth | 1 | No | Remains/Exuviae | 21-Sep-22 | Winter | 44.5 | 4 | 93 | 0.06040836052 | |||||||||||||
96 | Storage | E | 1 | Spider | 2 | No | Adult | 15-Mar-22 | Summer | 44.5 | 4 | 75 | 0.1498127341 | |||||||||||||
97 | Storage | E | 3 | Spider | 2 | No | Adult | 15-Mar-22 | Summer | 44.5 | 4 | 75 | 0.1498127341 | |||||||||||||
98 | Storage | E | 1 | Uknown | 2 | No | Adult | 20-Dec-22 | Spring | 44.5 | 4 | 90 | 0.1248439451 | |||||||||||||
99 | Storage | E | 2 | Uknown | 2 | Yes | Adult | 20-Dec-22 | Spring | 44.5 | 4 | 90 | 0.1248439451 | |||||||||||||
100 | Storage | E | 4 | Spider | 4 | No | Adult | 20-Jun-22 | Fall | 44.5 | 4 | 90 | 0.2496878901 |