Weekly Excel Links – Issues with Hosting of PHD
My website hosting provider GoDaddy.com has mailed me saying that this site is consuming a lot of server resources. As part of the remedy I have removed several plugins and cut down on few features in sidebars. I am not sure if these measures are going to cut down the CPU load on GoDaddy servers. I might end up moving the site to another server (although I would like to keep it where it is).
If you know a good hosting provider that can support PHD, please drop a comment or mail me at chandoo.d @ gmail.com. Thanks.
Clarification (added later): I have been using GoDaddy for the last 8 months and the site had seen crazy (ok, moderately crazy) traffic but hosting never failed. I am guessing the cause of this recent development is unnecessary (and probably dumb) plugin usage. Also, as most you might think the issue is not with traffic or storage capacity but with how much of server CPU is used by the blog. Initial research suggests usage of plugins and some non-optimized queries is to be blamed for this.
Anyways, here is a list of excel links that I found useful in the last week. Thanks to Tal for sending few links thru email.
Spreadsheet page explores the calendar generation logic and concludes that there are actually just 14 different calendar combinations (7 possible weekdays for Jan 1 and another 7 for leap years). They provided a compatibility table to see which year’s calendar same.
How cool would it be if you can use regular expressions in excel’s find formulas? Well, T Mehta has provided a simple VBA solution to achieve just this.
Number Spirals in Excel [xls file]
Number spirals is an interesting way to explore and understand numbers.
Number spirals are very simple. To make one, we just write the non-negative integers on a ribbon and roll it up with zero at the center.
So what the heck they got to do with Excel ? Well, they have provided an excel sheet using which you can generate number spirals. If you enjoy numbers like I do then you can download and play with this.
Dick Kusleika from daily dose of excel points us to few sources of huge excel based sample data that you can use in your simulations or just to play around.
This one aims to be reliable and help programmers understand and build applications on this excel clone. For one it uses Python (unlike VBA) to extend the functionality. I have doubts if this will appeal to excel users (of which most are working in offices or running businesses). What do you think?
Want to share a link with PHD readers?
Drop a comment or send me an email (chandoo.d at gmail.com) and I will be very happy to publish the same.
Leave a Reply
|Excel Basics – What are Combination Charts and How to Make One?||Automatically insert timestamps in excel sheet using formulas|