Thursday, 14 May 2020

Give Us Back Our Eleven Days!


Although we are not conscious of it, our world view is built around time; being late for meetings, early for a first date. The time the concert starts, the day of a new term.

In business we are driven by time. Sales are compared to this time last year or last month. We forecast by month or quarter, and year. Dates, times, and time periods are a fundamental building block to how we understand the world. And it is how we measure our businesses.

Yet when you think about it, time is a slippery concept. The idea that events, like sales or profit, occur within a concept we call time, is philosophically tricky. When we talk about time, what do we mean? And what would a world look like that did not include time? If it sounds far-fetched, think again.

A tribe, deep in the Amazonian forest, was found by researchers to have no language for time. Their  language does not have time as a separate entity. There is the time when it is dry, and the time when it is wet. The time when it is dark, or the time when it is light. They do not map events backwards or analyse forwards. Their events are all in the present. Think about it – what if being late was not even a thing? What if planning your career was not a thing? What if you could not miss someone's birthday?

What if you just did what you needed to do, and when you had finished you all relaxed or played sport. Our mental health might be a world away from what it is now.

There are some similarities, however, from a non-time-based culture, to a time-based culture. Day and night are universal, as is getting old. Whether we meet to play sport once work has finished, or at 7pm, the concept is similar. For most of the world, and through most of history, the need to co-ordinate activities with a common and agreed language has been important. It became even more important with the railways. Over centuries our understanding developed, and we developed time zones, and today we measure time very precisely and can be late for anything, anywhere. It is quite an achievement. But it did not come without a cost.

The Julian calendar developed by Julius Caesar was not accurate. Not to the degree of accuracy we enjoy today. In the year 45 BC 80 days was added to the year to bring it back into line with the “real year” of the sun and moon. It was, not surprisingly, dubbed “the year of confusion”.  It also became a political issue, with Emperor Augustus renaming a month after himself (August) and moving a day from February for good measure. It was typical, however, of the difficulty of aligning the calendar, or any calendar, with the reality of the world. The answer turned out to be the Gregorian calendar that we use today, named after Pope Gregory. The only problem was how to move from the Julian calendar to the Gregorian calendar? Just as in the Year of Confusion, it was going to cause, well, confusion ….

It did not just cause confusion, it caused riots. “Popery” was stealing days, rent, and asking for taxes in return. There was a flat refusal to pay taxes for days that did not exist - which is why the UK’s tax year ends of the 5th April. Even more confusingly, Wednesday 2nd September would be followed by Thursday 14th September. I don’t know about you, but the clocks changing twice a year causes a philosophical battle in my head about the meaning of space and time. Imagine the September the 2nd being followed by September 14th, without the days of the week missing a beat. The mathematics and science were awe inspiring, but the practical implementation baffling.

Happily, that is all behind us. Science has turned to more pressing matters like saving humanity. But there are reminders of the time that politicians had to navigate the delicate waters of messing with the people’s calendar. Microsoft SQL Server, which stores data for banks, multi-national businesses, charities, and more besides, includes a data type called datetime. Datetime stores dates from 1-1-1753. 1753 might seem like an arbitrary year, until the stolen days are remembered. Then it is far from arbitrary.

Only historians need to capture data as far back as 1753, or before the Gregorian calendar. But for those who do look backwards, those days are missing as clearly as if it were yesterday. For the rest of us, analysing data by time is normally a more recent exercise. Microsoft Power BI and Excel, for example, have date types that store dates from 1-1-1900.

The story of the calendar, and how some very clever people figured it out is told in a little book called The Calendar by David Duncan. It has more twists than a Dan Brown novel, and in my view a lot more interesting. But that is just me.

Over at the day job blog, I have been writing about analysing data over time using Microsoft Power BI. If you have recently started using this magic bit of software, go have a look. It is complete with all the days, months, quarters and years. From 1900 onwards. Obviously.

33 comments:

  1. Thanks for sharing such huge content keep posting further....outsource medical billing services

    ReplyDelete
  2. Great post. I have learned a lot. Thanks.

    ReplyDelete
  3. Give Us Back Our Eleven Day> This article is very necessary and timely. Very good article. Thank you for telling me about this article. I know of a school & fashion house that has a good education in fashion. Fashion schools in accra madina Riohs Originate is a Creative Art Service and Training Institute in Ghana.
    They provide services and training for individuals/organizations that value their image, style, color and insist on promptness, accuracy and consistency.
    In their course course is tailored and premised on ensuring that students are well grounded in all the basic practical areas of clothing and construction. The core aim is to allow new students unlock their potential in fashion within the shortest possible time.
    Tuition for local students: Gh¢ 4500.
    Tuition for Foreign students: $ 1250.
    Tuition Fees can be paid in 2 installments:
    Local Students-Ghc3500 paid before start of class with the balance Ghc1000 paid during your second month in class.
    Foreign Students-$1000 paid before start of class with the balance $250 paid during your second month in class.

    ReplyDelete
  4. I really want to appreciate the way to write this article.
    It seems that you are very professional and intelligent on the above topics of writing.
    I enjoyed reading your article very much.

    No more waste time to searching #HDimages, #PCwallpaper, #smartphone_wallpaper, #socialmedia_banner, #socialmedia_image_post, #natureHDimages, and many more awesome pictures. Just visit All Awesome Pictures Only For Love Hearts and choose your best choice.

    ReplyDelete
  5. Canzana CBD Don't Miss Out Today's Special Offer. New York, NY - ( NewMediaWire ) - August 22, 2020 - Stress and anxiety have end up inseparable issues of human lifestyles. Males, as well as females, suffer from paintings pressure. Every man or woman has a busy agenda at domestic and workplace. Due to strain and tension, one can't get an excellent quality of sleep every day. Besides, humans can not focus on their work due to anxiety. The calming homes of CBD show development in mental cognizance. It additionally gets rid of stress and tension and improves sleep quality. Canzana CBD Oil is one of the exceptional hemp oils to therapy stress and different intellectual issues. https://apnews.com/bdb5c370156711c36116a9c246688e61

    ReplyDelete
  6. The very Nice post to read from the interesting article and I really like that one of the interesting content in the post and really helpful for me and for other readers on that website to read that, I am expecting more such kind of posting from the writer So Nice. I know party rentals bethesda md . they provide better service
    https://dcpartyrentalsupply.com/blog-party-rental-bethesda-md/
    party rentals bethesda md

    ReplyDelete
  7. Amazing information, thank you for such amazing insights
    Get Lean Six Sigma Green Belt Certification with HenryHarvin.
    Learn from experts and be on top. These courses are taught by industry leaders and upon completion a certification is provided.

    ReplyDelete
  8. What a well written post!
    Get Six Sigma Certification Online with HenryHarvin.
    Learn from experts and be on top. The certification provided upon completion will act as an asset to your CV. Hurry up!

    ReplyDelete
  9. Thank you for the valuable insights

    Get Six Sigma Certification In Delhi with HenryHarvin.
    Learn from experts and be on top.

    ReplyDelete
  10. Great post. Thanks a lot. Would you like to try some big ideas?

    beddings

    ReplyDelete
  11. Very good information.
    Keep up the good Work.
    https://thesleekmart.com

    ReplyDelete
  12. Thank you for sharing your info. I really appreciate your efforts and I am waiting for your further write ups thank you once again. And know Mimz International Merchandising Company provides services to clients to Make their Vision a Reality and to help companies to improve business performance. merchandising

    ReplyDelete
  13. Wow, impressive!!! Amazing post, I found a lot of interesting information here. I really appreciate your article. Going to read more new posts.

    Find out Dream11 Today Prediction & fantasy cricket tips. We Provides 100% true match prediction with free fantasy tips. We cover all major cricket tournaments and matches.

    ReplyDelete
  14. Food and recipes
    Thank you admin for your useful information . I think your dedication is inspiring. This note is just an extension of what we all already know. We couldn’t do it without you.

    ReplyDelete
  15. I really appreciate your work which you have shared here about the Buy Real Passport -. The article you have shared here is very informative and the points you have mentioned are very helpful. Thank you so much.Buy Real Passport Online USA

    ReplyDelete
  16. Diskdatadestruction.net offers Mobile paper shredding, Mobile hard drive destruction at Hauppauge NY, Suffolk County NY, Long Island NY, Ronkonkoma NY, Melville NY, Huntington NY, Garden City NY, Farmingdale NY, Westbury NY, Bohemia NY, Stony Brook NY, Nassau County NY

    ReplyDelete
  17. Viceroy Investigations and Consulting LLC is a member of the Chamber of Commerce of the Massapequa's offer security consulting, assessments and training to large and small businesses. Let us help you design and implement policies that aid in Safe hiring, Work Place security and Information Security. Call us: 516-694-0093

    ReplyDelete
  18. Nyallpurposepaving.com offers Paving Contractor, Parking Lot Repairs, sealing, striping, Oil and Stone Driveways at Riverhead NY, Quogue NY, Hamptons NY, Southampton NY, Sag Harbor NY, Green point NY, Wading River NY

    ReplyDelete
  19. Davispestmanagement.com offers Pest Control, Exterminator, Bed Bug Removal, Inspections, Rodent, Pest Elimination, Commercial, Residential, Professional, Licensed Exterminator , Scorpion, Bee Hive, Hornet, Fire Ant Removal by Service Area, Las Vegas NV

    ReplyDelete
  20. johnnyontheshop.com offers Supermarket, Food , Costco ,Home depot , Supermarket home , groceries home , home delivery for seniors, shopping for seniors, Elder services, Senior services, BJS Home Delivery, Prescription Drug Delivery, Department Store Delivery, Fry’s Food Delivery, Lowes home Delivery Service at Scottsdale AZ

    ReplyDelete
  21. Bedbugprocpc.com offers Bed Bug Exterminator, Bed Bug Inspections, Bed Bug Elimination, Bed Bug Inspection for Hotels and Residential and Commercial Bed Bug at Palo Alto CA, San Mateo CA, San Jose CA, Belmont CA, San francisco CA, Redwood City CA, Sunnyvale CA

    ReplyDelete
  22. Complete pest control specializing in Rodents & Rodent Proofing, has 40 years of experience in dealing with nuisance pests such as skunks, possums and raccoons. Our business is based on honesty, integrity and reliability, so you can count on us to solve all your wildlife problems. 650-839-9999, 408-246-0492, 415-818-6301

    ReplyDelete
  23. It's a very nice and lovely post.

    https://bolgameshowluckydraw.blogspot.com

    ReplyDelete
  24. It's informative and knowledgeable post and article.

    https://cocacolaluckywinner1.blogspot.com

    ReplyDelete
  25. Atopcommercialpaving.com offers Commercial Paving, Asphalt Contractor, and Parking Lot Resurfacing at Queens NY, Nassau County, Bayside NY, Jamaica NY, Middle Village NY, Ozone Park NY, Howard Beach NY, Little Neck NY

    ReplyDelete
  26. Diskdatadestruction.net offers Mobile paper shredding, Mobile hard drive destruction at Hauppauge NY, Suffolk County NY, Long Island NY, Ronkonkoma NY, Melville NY, Huntington NY, Garden City NY, Farmingdale NY, Westbury NY, Bohemia NY, Stony Brook NY, Nassau County NY

    ReplyDelete
  27. Read the latest trending news, viral stories, and more share free guest post with do-follow backlink on AajKaViral.

    ReplyDelete
  28. hanks For Your valuable posting,this is for wonderful sharing,i would like to see more information from your side.i am working in Electrical system design



    ReplyDelete
  29. I really like that one of the interesting content in the post and really helpful for me and for other readers on that website to read that, I am expecting more such kind of posting from the writer So Nice. house lighting design

    ReplyDelete