Some of my fave Excel Date Functions. Some old, some new; all designed to help track the passage of time.
returns the last day of the month
|EOMONTH ( start_date , month )
returns the date x number of months before/after a given date
| EDATE ( start_date , months )
calculates the number of working days
(see also NETWORKDAYS.INTL)
| NETWORKDAYS ( start_date , end_date , [holidays] )
returns the current date
| TODAY( )
returns serial number for a given week
| WEEKNUM ( date , [week_start] )
calculates the next valid work day
(see also WORKDAY.INTL)
|WORKDAY( start_date, days, [holidays] )
returns the date as a fraction of the year
| YEARFRAC ( start_date , end_date , [basis])
Comments and questions are always welcome!
Starting this summer, Johannes Oerlemans of Utrecht University and his colleagues will blow artificial snow onto a small glacier at the foot of Diavolezzafirn, in the south-eastern part of Switzerland. The hope is that a thin white sheet of snow will increase the sunlight reflected, and thus protect the ice underneath from melting, Oerlemans explained at the European Geosciences Union on Thursday (Apr. 27). If this $100,000 pilot project is successful, researchers hope they can raise funding to use the technique to protect the Morteratsch glacier, a huge tourist attraction that’s considered a national treasure—but is shrinking.
via Switzerland will blow artificial snow onto its prized glaciers in an attempt to save them — Quartz
First it was your bank account, now it’s your data.
In the wake of the 2014 Snowden revelations about mass surveillance programs, startups with concerns about overreaching government requests for user data settled on Switzerland as a base for their business, drawn to its perceived favorable privacy laws.
They may need to look elsewhere.
Sunday, Swiss citizens approved granting the government the power to lawfully hack into computers, install malware, tap communications (i.e. phone, and internet) and to install hidden cameras in private locations in order to gather data. Said ‘hacking’ to be done in the name of National Security and to be exercised with restraint.
Fore more read TechCrunch article: Swiss public back law expanding surveillance powers
Take a mini desktop vacation!
Visit the worlds largest miniature railroad set, Miniatur Wunderland, courtesy of Google Straße
Click and drag within the interactive frame, below, to explore 360 view street scene from Switzerland
or click this link to fully explore other miniature locales including Austria, America, & Germany.
University researchers at the Swiss Federal Institute of Technology (ETH) in Zürich have designed drones that work together to build a rope bridge. Watch this cool video to see them in action.
For more, follow this link to original QZ.com article:
CSS, one of the country’s biggest health insurers, launched a pilot project in July, in which the company tracks the movements of 2,000 volunteers on a daily basis using digital pedometers. The program is intended to aid insurance companies in tailoring their offers to their customers’ needs.
For more click here to view the original article on Quartz.com