Google Sheets-Why is my countif, weeknum arrayformula miscalculating for the 52nd week of the year but works fine in calculating other weeks?

In Google Sheets, I have an array formula with countif that counts attendance based on week number. But for some reason on the 52nd week of the year, it counts all the blank cells. The answer in the cell should be 0 since we do not have school that week, but instead it is in the thousands. I assume it is counting blank cells for some reason.
Can anyone fix my formula so it doesn’t go wacky on the 52nd week every year? See cell R3 for formula and R10 for miscalculation on spreadsheet linked below.
My formula:
=arrayformula(if(len(P3:P),countif(weeknum($E3:E,21),O3:O20),””))

Link to spreadsheet: https://docs.google.com/spreadsheets/d/1jvTkohGw9c-nDnjv_ZpGCHLTNJbfE2d0FwzZjjTurbw/edit?usp=sharing

Thanks in advance!!!

google calendar – Show current day in the middle of week view, shifting day by day

On week view mode Google Calendar shows Monday-Sunday. I would like the current day to always be in the centre of the week view, such that each day the view shifts to the “right”. So perhaps on a Thursday, the week view shows Tuesday (two days prior) to Monday (of the following week), and on Friday it shows Wednesday-Tuesday, and so on. This would help me on the weekend to see what is coming up in the next few days without having to move to the next week manually.

linux – Server is always slow at around 2pm for 1 week

I did top and got:

Tasks: 590 total, 8 running, 582 sleping, 0 stopped, 0 zombie
Cpus(s) 96.5%us, 2.7%sy, 0.0%ni, 0.4%id, 0.0%wa, 0.0%hi, 0.4%si, 0.0%st
Mem: 32877280k total, 30611188k used, 2266092k free, 4021204k buffers
Swap 0k total, 0k used, 0k free, 4267024k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21672 mysql 20 0 13.1G 8.9G 8496 S 559.1 28.3 124168:04 mysqld
12025 webs 20 0 494m 59m 5544 S 30.8 02 1:09.82 php-fpm
13325 webs 20 0 414m 57m 8014 S 21.4 02 1:08.42 php
11111 webs 20 0 495m 64m 3231 S 18.5 02 1:12.16 php-fpm
13232 webs 20 0 505m 96m 8542 S 16.5 02 1:12.12 php-fpm
13217 webs 20 0 401m 52m 8541 S 15.5 02 1:02.44 php-fpm
13119 webs 20 0 475m 39m 8555 S 15.5 02 1:02.16 php-fpm
12065 webs 20 0 495m 49m 2533 S 14.9 02 1:22.41 php-fpm
12161 webs 20 0 412m 61m 2524 S 10.5 02 1:06.01 php-fpm
12275 webs 20 0 455m 51m 1544 S 10.5 02 1:34.04 php-fpm
12427 webs 20 0 464m 92m 7541 S 10.5 02 1:31.41 php-fpm
12127 webs 20 0 459m 89m 6544 S 10.5 02 1:01.19 php-fpm

Now, I was thinking and I thought the best way to make the server faster would be to restart the mysqld process, but how do I make sure there’s no large sql dump going on? I did show full processlist, but I was told it doesn’t tell you if there’s an ongoing dump, because the insert happens really fast. Also, how do I investigate further? In an article I read, I was told if id and wa is low, I need to check if the CPU is high and if the CPU is high I need to restart the process. How often should I restart, what’s the decision tree when there’s a server slow down, what are all the things I need to do?

I did show full processlist and got:

1   system user         Daemon      InnoDB purge coordinator    
4   system user         Daemon      InnoDB purge worker 
3   system user         Daemon      InnoDB purge worker 
2   system user         Daemon      InnoDB purge worker 
5   system user         Daemon      InnoDB shutdown handler 
109725  root    localhost:54620     Query   0   Init    show full processlist
142438  cakes   localhost   cakes   Sleep   295     
142449  cakes   localhost   cakes   Sleep   21      
144422  pancakes    localhost   pancakes    Sleep   54      
144426  pancakes    localhost:54038 pancakes    Sleep   56      
145072  bookletv3   localhost   bookletv3   Query   0   Sending data    SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_prod wc ON  wc.post_id = wp_posts.ID AND (0  or 1)  AND (wc.stock = 'm004189' OR wc.vin = 'm004189')  AND ( wc.isbudget IS NULL OR wc.isbudget <> 1 )  AND ( wc.deleted IS NULL OR wc.deleted <> 1 )  WHERE 1=1  AND ( 
  wp_postmeta.meta_key = '_prod_info_new'
) AND wp_posts.post_type = 'used-prod' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wc.SoldDate IS NULL, wc.SoldDate ASC, wc.isnew DESC LIMIT 0, 15
145073  bookletv3   localhost:33840 bookletv3   Sleep   0       
145074  bookletv3   localhost   bookletv3   Query   0   Statistics  -- (brand) product city
      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s

      INNER JOIN `wp_prod` c
      ON (
        (c.bestproductname = s.product and c.bestproductname != '')
        OR c.product = s.product
      )
    
      WHERE c.product != '' AND c.product = 'tiramisu' AND s.`city` = 'losangeles' AND s.`prod_type` = 1 AND s.text_es <>''
      AND c.location in ("HY2112","HY1134","HY90428","HY10223","AR13821","AR90498","AR90613","BR92144","BR9239") 

      LIMIT 1)


      -- brand city
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s
      WHERE s.brand = 'Chewy' AND s.brand != '' AND s.`city` = 'losangeles' AND s.`city` != '' AND s.`prod_type` = 1 AND s.text_es <>'')


      -- city
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_city_seo` s
      WHERE `city_slug` = 'losangeles' AND `city_slug` != ''
      LIMIT 1)


      -- product
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s

      INNER JOIN `wp_prod` c
      ON (
        (c.bestproductname = s.product and c.bestproductname != '')
        OR c.product = s.product
      )

      WHERE c.product = 'tiramisu' AND c.product != '' AND s.`prod_type` = 1 AND s.text_es <>''
      AND c.location in ("HY2112","HY1134","HY90428","HY10223","AR13821","AR90498","AR90613","BR92144","BR9239")

      LIMIT 1)


      -- brand
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s
      WHERE (s.brand = 'Chew' OR s.brand = '') AND s.brand != '' AND s.`prod_type` = 1 AND s.text_es <>''

      LIMIT 1)

      -- none
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s
      WHERE s.brand = '' AND s.product = '' AND s.`prod_type` = 1 AND s.text_es <>'')

      LIMIT 1
145075  bookletv3   localhost   bookletv3   Sleep   0       
145076  bookletv3   localhost   bookletv3   Sleep   0       
145077  bookletv3   localhost:33858 bookletv3   Sleep   0       
145078  bookletv3   localhost:33860 bookletv3   Sleep   0       
145079  bookletv3   localhost:33862 bookletv3   Sleep   0   
145080  bookletv3   localhost   bookletv3   Query   0   Statistics  -- (brand) product city
      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s

      INNER JOIN `wp_prod` c
      ON (
        (c.bestproductname = s.product and c.bestproductname != '')
        OR c.product = s.product
      )
    
      WHERE c.product != '' AND c.product = 'muffins' AND s.`city` = 'losangeles' AND s.`prod_type` = 1 AND s.text_es <>''
      AND c.location in ("HY2112","HY1134","HY90428","HY10223") 

      LIMIT 1)


      -- brand city
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s
      WHERE s.brand = 'Chewy' AND s.brand != '' AND s.`city` = 'losangeles' AND s.`city` != '' AND s.`prod_type` = 1 AND s.text_es <>'')


      -- city
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_city_seo` s
      WHERE `city_slug` = 'losangeles' AND `city_slug` != ''
      LIMIT 1)


      -- product
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s

      INNER JOIN `wp_prod` c
      ON (
        (c.bestproductname = s.product and c.bestproductname != '')
        OR c.product = s.product
      )

      WHERE c.product = 'muffin' AND c.product != '' AND s.`prod_type` = 1 AND s.text_es <>''
      AND c.location in ("HY2112","HY1134","HY90428","HY10223","AR13821","AR90498","AR90613","BR92144","BR9239")

      LIMIT 1)


      -- brand
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s
      WHERE (s.brand = 'Chewy' OR s.brand = '') AND s.brand != '' AND s.`prod_type` = 1 AND s.text_es <>''

      LIMIT 1)

      -- none
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s
      WHERE s.brand = '' AND s.product = '' AND s.`prod_type` = 1 AND s.text_es <>'')

      LIMIT 1   
145081  bookletv3   localhost   bookletv3   Query   0   Statistics  -- (brand) product city
      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s

      INNER JOIN `wp_prod` c
      ON (
        (c.bestproductname = s.product and c.bestproductname != '')
        OR c.product = s.product
      )
    
      WHERE c.product != '' AND c.product = 'muffins' AND s.`city` = 'losangeles' AND s.`prod_type` = 1 AND s.text_es <>''
      AND c.location in ("HY2112","HY10223") 

      LIMIT 1)


      -- brand city
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s
      WHERE s.brand = 'Chewy' AND s.brand != '' AND s.`city` = 'losangeles' AND s.`city` != '' AND s.`prod_type` = 1 AND s.text_es <>'')


      -- city
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_city_seo` s
      WHERE `city_slug` = 'losangeles' AND `city_slug` != ''
      LIMIT 1)


      -- product
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s

      INNER JOIN `wp_prod` c
      ON (
        (c.bestproductname = s.product and c.bestproductname != '')
        OR c.product = s.product
      )

      WHERE c.product = 'muffin' AND c.product != '' AND s.`prod_type` = 1 AND s.text_es <>''
      AND c.location in ("HY2112","HY1134")

      LIMIT 1)


      -- brand
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s
      WHERE (s.brand = 'Chewy' OR s.brand = '') AND s.brand != '' AND s.`prod_type` = 1 AND s.text_es <>''

      LIMIT 1)

      -- none
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s
      WHERE s.brand = '' AND s.product = '' AND s.`prod_type` = 1 AND s.text_es <>'')

      LIMIT 1
145082  bookletv3   localhost   bookletv3   Query   0   Statistics  -- (brand) product city
      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s

      INNER JOIN `wp_prod` c
      ON (
        (c.bestproductname = s.product and c.bestproductname != '')
        OR c.product = s.product
      )
    
      WHERE c.product != '' AND c.product = 'tiramisu' AND s.`city` = 'losangeles' AND s.`prod_type` = 1 AND s.text_es <>''
      AND c.location in ("BR92144","BR9239") 

      LIMIT 1)


      -- brand city
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s
      WHERE s.brand = 'Chewy' AND s.brand != '' AND s.`city` = 'losangeles' AND s.`city` != '' AND s.`prod_type` = 1 AND s.text_es <>'')


      -- city
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_city_seo` s
      WHERE `city_slug` = 'losangeles' AND `city_slug` != ''
      LIMIT 1)


      -- product
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s

      INNER JOIN `wp_prod` c
      ON (
        (c.bestproductname = s.product and c.bestproductname != '')
        OR c.product = s.product
      )

      WHERE c.product = 'tiramisu' AND c.product != '' AND s.`prod_type` = 1 AND s.text_es <>''
      AND c.location in ("BR92144","BR9239")

      LIMIT 1)


      -- brand
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s
      WHERE (s.brand = 'Chew' OR s.brand = '') AND s.brand != '' AND s.`prod_type` = 1 AND s.text_es <>''

      LIMIT 1)

      -- none
      UNION ALL

      (SELECT s.text_es text
      FROM `wp_prod_brandproduct_seo` s
      WHERE s.brand = '' AND s.product = '' AND s.`prod_type` = 1 AND s.text_es <>'')

      LIMIT 1

Any tutorial on this? I am scared, because I am not 100% sure what to do.

Google Calendar: How to set up event on the week of a specific day

I want to set up a Google Calendar event, that lasts on the week of 1st of September. So this year, it would be from 30th August – 5th September, but of course, it would change every year, because every year 1st of September falls on different weeks of the year.

Also, I want to receive notifications on my phone every morning say at 7:00.

How can I achieve this? Could someone please help me with a step-by-step instruction list? :]

Thank you for your help.

What is the best day of week and time to visit Cyprus mountain villages?

We are currently on Cyprus and want to go to touristic mountain villages such as Kakopetria, Lefkara and Platres. We are interested in walking along streets, going to different shops (be it souvenir or not) and cafes; we are not interested in any religious activity (if any).

On what days of week and what time of day it is best to go there?

On one hand, most shops in other (not so touristic) areas of Cyprus are open till ~18.00-19.00, and are often closed on weekends (as may be expected). However, I think that touristic attractions may open later and/or on weekends. Also obviously around the noon it’s very hot, and so this may be not the best time to go.

Also, Google maps advise me that the next Sunday, Aug 15, is a religious holiday; will it affect the situation in the villages?

New tables for each day, week, month.

Hello i have an web app that i have been building for the past couple of years.
Its main role is to record employees attendances and there jobs during the day and then for the office
staff to calculate pays and hours worked on jobs by multiple jobs.
Also the office can see who is workin on what etc.

At the moment each activity if it be logging on or logging off or starting a job or finishing a job or going to lunch or finishing lunch etc.
This web app will be on the local Lan only.
These activities are all stored in a single Mysql table as each on must have an off..

The problem is that i would like to have a new table each day and then each day to be copied to a weekly table each day
deleting the day table once checked..
The weekly tables will align with their pay week. These weekly tables will be kept until a month then simplify
the data to another table for the year.

This part of daily, weekly, monthy table has many ways but i am unsure.
Use mysql event??, scripts from linux (cron or LT script), or other ways??
Best ways to create daily tables and other tables without user assistance.

I am using php as the backend language.

I have used temporary tables in VBA years ago for a point of sale system for corner shops that worked good.

But this php mysql on linux web app will have multiple user accessing and payrol using queries to extract employees hours and jobs and their hours and i
would like to keep the table size as small as i can.
SEMrush

Hope this makes sense.