Spreadsheet: 158402d1338220360-still-unsolved_copy-depending-on-a-weekly-frequency-event-frequency_7days_30days
Sheet: Sheet1

firm_id | manager_id | event_type | event_date | score | next event within 7 days | next event within 30 days | next event type1 within 7 days | next event type1 within 30 days | next event type0 within 7 days | next event type0 within 30 days | cumulated within 7 days mixedtype1and0 | cumulated within 30 days_mixedtype1and0 | cumulated within 7 days_type1 | cumulated within 30 days_type1 | cumulated within 7 days_type0 | cumulated within 30 days_type0
22 | 24410 | 1 | 1999-03-24 00:00:00 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 100 | 100 | 100 | 0 | 0
22 | 50590 | 1 | 2001-04-23 00:00:00 | 37.2844 | 0 | 0 | 0 | 0 | 0 | 0 | 37.2844 | 37.2844 | 37.2844 | 37.2844 | 0 | 0
22 | 50590 | 1 | 2002-04-05 00:00:00 | 29.6501 | 0 | 0 | 0 | 0 | 0 | 0 | 29.6501 | 29.6501 | 29.6501 | 29.6501 | 0 | 0
22 | 50590 | 1 | 2002-09-04 00:00:00 | 29.6501 | 0 | 0 | 0 | 0 | 0 | 0 | 29.6501 | 29.6501 | 29.6501 | 29.6501 | 0 | 0
22 | 56879 | 1 | 2003-03-20 00:00:00 | 49.3437 | 0 | 0 | 0 | 0 | 0 | 0 | 49.3437 | 49.3437 | 49.3437 | 49.3437 | 0 | 0
22 | 56879 | 1 | 2006-03-09 00:00:00 | 47.7464 | 0 | 0 | 0 | 0 | 0 | 0 | 47.7464 | 47.7464 | 47.7464 | 47.7464 | 0 | 0
22 | 56879 | 1 | 2006-05-24 00:00:00 | 47.7464 | 0 | 0 | 0 | 0 | 0 | 0 | 47.7464 | 47.7464 | 47.7464 | 47.7464 | 0 | 0
22 | 56879 | 1 | 2007-06-25 00:00:00 | 39.84 | 1 | 1 | 1 | 1 | 0 | 0 | 79.68 | 39.84 | 79.68 | 39.84 | 0 | 0
22 | 56879 | 1 | 2007-06-25 00:00:00 | 39.84 | 0 | 0 | 0 | 0 | 0 | 0 | 39.84 | 39.84 | 39.84 | 39.84 | 0 | 0
22 | 56879 | 1 | 2008-03-06 00:00:00 | 44.2004 | 1 | 1 | 1 | 1 | 0 | 0 | 88.4008 | 88.4008 | 88.4008 | 88.4008 | 0 | 0
22 | 56879 | 1 | 2008-03-12 00:00:00 | 44.2004 | 0 | 0 | 0 | 0 | 0 | 0 | 44.2004 | 44.2004 | 44.2004 | 44.2004 | 0 | 0
22 | 72824 | 1 | 2006-03-09 00:00:00 | 47.7464 | 0 | 0 | 0 | 0 | 0 | 0 | 47.7464 | 47.7464 | 47.7464 | 47.7464 | 0 | 0
22 | 72824 | 1 | 2006-05-24 00:00:00 | 47.7464 | 0 | 0 | 0 | 0 | 0 | 0 | 47.7464 | 47.7464 | 47.7464 | 47.7464 | 0 | 0
22 | 72824 | 1 | 2007-03-08 00:00:00 | 39.84 | 0 | 0 | 0 | 0 | 0 | 0 | 39.84 | 39.84 | 39.84 | 39.84 | 0 | 0
22 | 72824 | 1 | 2007-06-25 00:00:00 | 39.84 | 0 | 0 | 0 | 0 | 0 | 0 | 39.84 | 39.84 | 39.84 | 39.84 | 0 | 0
22 | 72824 | 1 | 2008-03-06 00:00:00 | 44.2004 | 1 | 1 | 1 | 1 | 0 | 0 | 88.4008 | 175.4797 | 88.4008 | 175.4797 | 0 | 0
22 | 72824 | 1 | 2008-03-11 00:00:00 | 44.2004 | 1 | 1 | 1 | 1 | 0 | 0 | 88.4008 | 131.2793 | 88.4008 | 131.2793 | 0 | 0
22 | 72824 | 1 | 2008-03-13 00:00:00 | 44.2004 | 1 | 1 | 1 | 1 | 0 | 0 | 87.0789 | 87.0789 | 87.0789 | 87.0789 | 0 | 0
22 | 72824 | 1 | 2009-03-31 00:00:00 | 42.8785 | 0 | 0 | 0 | 0 | 0 | 0 | 42.8785 | 42.8785 | 42.8785 | 42.8785 | 0 | 0
31 | 34766 | 0 | 1999-11-01 00:00:00 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 100 | 0 | 0 | 100 | 100
31 | 34766 | 0 | 2000-02-04 00:00:00 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 100 | 0 | 0 | 100 | 100
31 | 34766 | 0 | 2000-09-07 00:00:00 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 100 | 0 | 0 | 100 | 100
31 | 34766 | 1 | 2001-07-06 00:00:00 | 17.3748 | 0 | 0 | 0 | 0 | 0 | 0 | 17.3748 | 17.3748 | 17.3748 | 17.3748 | 0 | 0
31 | 34766 | 1 | 2003-02-20 00:00:00 | 17.3784 | 0 | 1 | 0 | 1 | 0 | 0 | 17.3784 |  | 17.3784 |  | 0 | 0
31 | 34766 | 1 | 2003-03-03 00:00:00 | 17.3784 | 0 | 1 | 0 | 1 | 0 | 0 | 17.3784 |  | 17.3784 |  | 0 | 0
31 | 34766 | 1 | 2003-03-14 00:00:00 | 17.3784 | 0 | 1 | 0 | 1 | 0 | 0 | 17.3784 |  | 17.3784 |  | 0 | 0
31 | 34766 | 0 | 2003-04-02 00:00:00 | 17.3784 | 0 | 0 | 0 | 0 | 0 | 0 | 17.3784 | 0 | 0 | 0 | 17.3784 | 17.3784