Jump to content

  • Quick Navigation
Photo

Pest trending

Share this

  • You cannot start a new topic
  • Please log in to reply
7 replies to this topic
- - - - -

gel braza

    Grade - Active

  • IFSQN Active
  • 16 posts
  • 0 thanks
0
Neutral

  • Philippines
    Philippines

Posted 23 July 2018 - 04:12 AM

Can anyone help me and give idea to do a pest trending chart using dashboard in excel.
Thanks



mohamed ahmed yusuf

    Grade - MIFSQN

  • IFSQN Member
  • 190 posts
  • 40 thanks
17
Good

  • Egypt
    Egypt
  • Gender:Male
  • Interests:Reading, Listening music, handball , volleyball, food safety, drawing , R&D, Photoshop

Posted 24 July 2018 - 07:32 AM

Can anyone help me and give idea to do a pest trending chart using dashboard in excel.
Thanks

Hello, 

 I hope that this file helping you in doing trend , trend shall be for year and you can make a trend for :

1. Month to month. 

2. Station to station. 

3. Year to year. 

 

If you have any inquiry , please message me :) .

Attached Files


Edited by mohamed ahmed yusuf, 24 July 2018 - 07:33 AM.

M.Yusuf


Thanked by 2 Members:

Charles.C

    Grade - FIFSQN

  • IFSQN Moderator
  • 20,542 posts
  • 5662 thanks
1,544
Excellent

  • Earth
    Earth
  • Gender:Male
  • Interests:SF
    TV
    Movies

Posted 24 July 2018 - 07:59 AM

Hello, 

 I hope that this file helping you in doing trend , trend shall be for year and you can make a trend for :

1. Month to month. 

2. Station to station. 

3. Year to year. 

 

If you have any inquiry , please message me :) .

 

Hi mohamed,

 

The trends are fine. :thumbup:

 

But the 1Million dollar question is - how to interpret/act upon the trends ? :smile:


Kind Regards,

 

Charles.C


mohamed ahmed yusuf

    Grade - MIFSQN

  • IFSQN Member
  • 190 posts
  • 40 thanks
17
Good

  • Egypt
    Egypt
  • Gender:Male
  • Interests:Reading, Listening music, handball , volleyball, food safety, drawing , R&D, Photoshop

Posted 24 July 2018 - 02:06 PM

Hi mohamed,

 

The trends are fine. :thumbup:

 

But the 1Million dollar question is - how to interpret/act upon the trends ? :smile:

I didn't get your point Charles ?   :biggrin:


M.Yusuf


Charles.C

    Grade - FIFSQN

  • IFSQN Moderator
  • 20,542 posts
  • 5662 thanks
1,544
Excellent

  • Earth
    Earth
  • Gender:Male
  • Interests:SF
    TV
    Movies

Posted 24 July 2018 - 02:54 PM

I didn't get your point Charles ?   :biggrin:

 

There may be (at least) 3 questions to answer after doing the charting -

 

(1) Is there a trend ?

(2) If yes, is the trend significant ?

(3) if yes, what is(are) an appropriate corrective action ?

 

The potential complexity is illustrated in this recent thread -

 

http://www.ifsqn.com...nding-analysis/


Kind Regards,

 

Charles.C


Thanked by 1 Member:

mgourley

    Grade - FIFSQN

  • IFSQN Fellow
  • 1,403 posts
  • 997 thanks
274
Excellent

  • United States
    United States
  • Gender:Male
  • Location:Plant City, FL
  • Interests:Cooking, golf, firearms, food safety and sanitation.

Posted 24 July 2018 - 09:49 PM

Indeed. As usual, the correct answer is "it depends".

 

I worked at a facility in north eastern Ohio for 6 years. Every year the trend for catches in light traps increased during the late spring to early fall.

Is it a trend? Yes, it is. Is it significant? Not really, because the rest of the year it was cold and snowing, thus less pest activity.

 

Mohammed, those are really good trend maps. I did mine weekly, but data is data and they should be perfectly fine for the OP's purposes.

 

But as Charles typed, is there a trend? If so, is it because you have more pests in the facility or is it just a function of nature and climate?

 

If your building fabric does not change, it's likely it's just a natural fluctuation in the amount of pests in nature.

 

Marshall



Thanked by 2 Members:

012117

    Grade - MIFSQN

  • IFSQN Member
  • 227 posts
  • 69 thanks
36
Excellent

  • Earth
    Earth
  • Gender:Male
  • Location:Philippines
  • Interests:Validation, basketball, chocolatier

Posted 25 July 2018 - 02:14 AM

Hi, Gel.

 

Before using dashboard in excel, it requires that you have a good  working "table" that you can convert as dashboard. If you have individual sheet for each devices and insect, you will just likely to come up with a trend similar to without dashboard. Suggest that you first try to consolidate your sheet into one table and if you will "understand" that table, you can make it into a working dashboard that will faciliatte faster trend sharing.

One can share file here but it will always be depending on how can you interpret the data from your trends, as it will be meaningful or any dashboard will not be useful without good analysis.

 

P.S. Creating dashboard sometimes will take you longer time, weigh the importance of creating one vs the time you can allot in improving other FS that needs to be improved. If your current trends and analysis is working just fine and there are other things that needs improvement, suggest that focus first on the other things :) But if you are really interested I can help you with it.



rsuong

    Grade - Active

  • IFSQN Active
  • 24 posts
  • 2 thanks
1
Neutral

  • United States
    United States

Posted 27 July 2018 - 09:03 PM

Your PCO should be able to provide the trend.


Sent from my iPhone using Tapatalk





Share this

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users