It is not now to determine a medical examinations calendar (which periodically must never forget to try to be healthy as long as possible), but to show my acknowledgment to the authors of the articles I've been reading this month for the realization of this Perpetual Calendar project.
In several blogs devoted to the Excel world I have known excellent professionals and now I want to express my sincere acknowledgment, starting with:
My Acknowledgments Calendar:
Purna Duggirala and his Chandoo.org (BECOME AWESOME IN EXCEL) with whom I shared calendars templates and flags, but above all witty comments and encouragement on his blog and in his article on how to make a perpetual calendar:
In acknowledgment to my visitors I'm sharing here another calendar
You can download it by clicking on the next SkyDrive page:
Or you can download a template even easier from here.
It is simpler than the proposed Perpetual Calendar, as summarized in a single spreadsheet that includes the 12 months of the year, starting any month, one selected month with anniversary dates that can be entered from any day and you could choose the color of the anniversary text.
To calculate the week numbers I'm using the following function in Excel 2010, which is not compatible with Excel 2007:
The $E$2 cell indicates whether the week starts on Sunday (3) or Monday (4).
When you start on Monday, the argument is 21 and serves to Europe countries and other with the Gregorian Calendar.
Passing the compatibility check tells me that the sheet is compatible with Excel 2007, which is not very successful as the argument value 21 does not appear anywhere.
For Excel 2003 and 2007 and OpenOffice Calc can substitute with this calculation:
This was my last Perpetual Calendar update with the help of this forum: AyudaExcel.com that when I uploaded the calendar, one of their members told me politely that the week numbers were not right for Spain, because if not, I had been calculated as in my previous calendars:
I was thinking that had been resolved in MS Excel with the argument 2 for weeks beginning on Monday, but Microsoft has been slow to resolve until 2010 Excel version the week number calculation following the Gregorian calendar and ISO 8601 for Europe: The week containing the first Thursday of the year is the first week of the year and is numbered as week 1.
State of the art from calendars
With the developed calendars here could be scheduled full-day events in the local timezone, which is not far from some major software vendors like Google that warns in its Apps Status Dashboard:
Google Calendar 5/24/10 All times are shown in your local timezone unless otherwise noted.
When it comes to events schedules, this approach is not correct and should be required that the start and end events can be scheduled in different time zones, what some bloggers are denouncing in the relevant Google Calendar forums:
The latter concerns to there aren't Easter days in the Google Calendar. Does this mean that their engineers have forgotten to do calculations (Computus in Latin)?
In short, in all these articles I tried to show that a proposed user interface can be attacked in various ways, but you should always take into account the recipient of the application and its changing needs, so development will not be terminated while there are users to meet, which makes software development is always a process of continuous improvement in time ...
Blogger lies when he says that creating a blog is easy and only takes a minute. Provide content to a blog or creating a high requirements spreadsheet, some days of dedication are needed, as any expert in Excel or Blogs will tell you. I have dedicated this month to this project that help me to stay active and have in this site some things I cannot find on other sites and that can serve other users like me. Next month I'm going to publish more projects headed to experienced users.
PD: Print a dodecahedron calendar form from this page: 12 sided calendar
Download Problems
-
It seems there is a problem with the certificate for my downloads folder,
which generates security warnings if anyone tries to download anything. I
am work...
Potencias equidistantes de cuadrados
-
En uno de mis cálculos habituales me encontré hace unas semanas con esta
igualdad doble:
16124=307^2-5^7
16124=5^7-249^2
Lo interesante de ella es que s...
Guía definitiva – Cómo usar imágenes en Excel
-
¿Alguna vez te has preguntado cómo potenciar tus habilidades en Excel
utilizando imágenes de manera efectiva? ¡Este es el lugar […]
The post Guía definit...
Formato de celdas con emojis
-
🔝*To translate this blog post to your language, select it in the top left
Google box. *
En este ejemplo uso el formato de celdas con emojis como sust...
REALIZAR UNA CONSULTA LEFT JOIN CON TYPESCRIPT
-
Hola a todos, Hace tiempo que no publico sobre typescript, pero es que como
ya sabéis estoy muy centrado en Power Apps y esto me …
La entrada REALIZAR U...
Data Validation Selection Popup Tool – Contextures
-
With the free Data Validation Select Popup (DVSP) tool from Contextures,
you can add popup lists to Excel workbooks. Set the rules you’d like for
the pop-u...
Spark Labs Power Platform con Creativity Spark
-
Eventos gratis sobre Power Platform: Acude a los Spark Labs Power Platform
con Creativity Spark para aprender desde el inicio sobre Power Apps, Power
Aut...
6 Ways to Create a Heat Map in Microsoft Excel
-
Learn how to create a heat map in Excel with real-world data, easy methods,
and effortless steps. Microsoft Excel offers some of the best data
visualizatio...
Truco Python. Pasar múltiples archivos pdf a texto
-
Estoy realizando un trabajo de scraping de archivos que genera una entidad
estatal en pdf y es necesario ... Leer más »
The post Truco Python. Pasar múlt...
Interés compuesto con Excel
-
En la imagen, se presenta un esquema de las distintas funciones Excel para
calcular el valor del dinero en el tiempo mediante la capitalización
compuesta...
Unblocking and Enabling Macros
-
When Windows detects that a file has come from a computer other than the
one you're using, it marks the file as coming from the web, and blocks the
file....
-
Aprendiendo Unreal Engine 5. ¿Por dónde empiezo?
Desde la presentación de la Comunidad Oficial de desarrolladores de Unreal
Engine de Málaga, he recibido m...
Navigating Outlook Favorites
-
I have these four favorites defined in Outlook: From the inbox, I could hit
Shift+F6 to get into the Favorites area but sometimes I would end up in no
man’...
Office Scripts: Trabajando con Tablas
-
[image: Office Scripts: Trabajando con Tablas]
Me he dado cuenta que últimamente solo escribo de lenguaje M (es mi pequeño
vicio)... pero hay que liberar l...
Progress on the Block Protocol
-
Since the 1990s, the web has been a publishing place for human-readable
documents. Documents published on the web are in HTML. HTML has a little
bit of… Re...
London Excel Meetup Workbooks
-
The workbooks used in my presentation on “Analytical and Interactive
Dashboards in Excel” at the London Excel Meetup, September 3, 2020
Dimensiones-Propiedades de perfiles de acero (IMCA)
-
Saludos compañeros, en esta oportunidad compartimos esta Planilla Excel que
contiene las Propiedades y dimensiones de diferentes tipos de perfiles de
acero...
Chart Porn Hiatus
-
I started this blog in 2008 as a simple personal repository of interesting
data visualizations and graphic design resources. Watching it grow over the
year...
Mis metas son seguir superando nuevos retos en Excel y compartirlos en mi blog, para sacarle todo el poder a esta excelente herramienta multiusos, tan usada y a la vez tan incomprendida, para así poder mejorar nuestros conocimientos de Excel.
No Response to "Excellent Acknowledgments Calendar"
Leave A Reply
Dime si te gusta lo que lees y, si no te gusta, dime por qué. Tengo habilitada la moderación de comentarios. Tu comentario se publicará pronto.