Excel Volume Calculator

The ‘Excel Volume Calculator’ is now available to buy as a direct download! :)

Microsoft Excel is a very versatile tool and can be used for many different purposes. The example we have here is a volume calculator for some simple geometric shapes. The user can enter values for the parameters (such as side length, or radius), and the corresponding volume is updated automatically.

However, rather than just display the parameters and calculated volume, it is often more user friendly to format the spreadsheet area with diagrams, and the odd splash of colour here and there!

Also, this example does not make use of any macros, but could be easily extended to do so. The volume equation for each shape is entered directly into worksheet cells but could be stored in macro code instead in the form of a custom worksheet function. This function could then be called as necessary, just like a standard worksheet function.

Posted in Excel, Graphics | Tagged , , , , , | 18 Comments

Juggling – Yet Again

As an attempt to streamline site content etc. I have deleted the online labs section and consolidated all Silverlight samples and demo’s into one section. The idea was to have a labs section just for testing and a samples section for more mature applications. But the reality is that this is a lot more to maintain and would result in less content being produced so…

All new Silverlight content posted to the site can be found in the Silverlight 3 samples section here:


Enjoy! Oh, and any particular Silverlight apps you are interested in seeing just drop us a line. Always happy to hear cool suggestions. 😉

Posted in Silverlight | Leave a comment

Silverlight Development

Just been updating the structure of the site to reflect our recent activity, which is pretty much mostly Silverlight at the moment. Check out the dedicated Silverlight Development page for more details!

Posted in C#, Silverlight | 1 Comment

New High Definition Video Tutorial Website

We are pleased to announce that our high definition video tutorial sister site www.vercana.com is finally getting off the ground. We have added some great videos already, and have lots more planned for the near future.


The site specialises in HD 720P quality video tutorials, and topics that will be appearing on the site in the coming months will include:

  1. Windows Presentation Foundation (WPF)
  2. C# and Visual Studio 2008
  3. WordPress
  4. JavaScript, PHP, CSS
  5. Flash and ActionScript
  6. 2D and 3D Graphics
  7. XNA Development
  8. MS Excel

At the moment the site is in beta mode and s has a reduced monthly subscription plan. For just £3.95 per month you have access to all of the current video tutorials, as well as new ones coming out! So, why not check us out at www.vercana.com, and let us know what you think!

Posted in Misc | Tagged , , , | Leave a comment

To Do List WordPress Plugin Updated

Just to let you know our WordPress ‘To Do List’ Plug-in has been updated, and the latest version is v1.3. You can see more details here, as well as download the Plug-in direct! :)

Posted in WordPress Plugins | Tagged , | 4 Comments

New Product – WordPress Plugin Manager

New product announcement. Just a quickie folks! :)

We have been mulling this over for a while now and have decided to press (pardon the pun!) ahead with a new Windows WordPress Plugin Management application (developed in C#) which is targeted at WordPress Plugin developers.

Features for the first version are not finalised yet but it will definitely include functionality to login to your WordPress account, browse your installed Plugins, create new Plugins, edit existing Plugins, and lots more besides!

There is still a lot to think about, but more details will appear soon, so keep checking back and be sure to let us know any comments, and what you think, as well as any suggestions for features that should be a priority. How would an application like this make your WordPress Plugin development easier, and more streamlined etc?

Posted in WordPress Plugins | Tagged , , , , | Leave a comment

New Product – Quadratic Solver

We are pleased to announce the release of Quadratic Solver 1.0. You can see more information on the product page.

Quadratic solver plots, and displays the solution to the quadratic polynomial equation. It can handle real and complex types of solution, and so displays the full complex number solution rather than just display an error message saying the solution is complex!

You can also see a HD video demo of Quadratic Solver on our YouTube page.

Let us know what you think!

Posted in Mathematics, Programming | Tagged , , | 1 Comment

Back again…

Oh my goodness, has it been that long since our last blogs/site activity!? We have been working hard on other projects recently, but I am pleased to say that we are back now and working on new and exciting gwycon projects.

One thing in the pipeline in the near future is a test/labs area on gwycon where we will be creating and experimenting with new (and existing technologies) such as Flash, Silverlight, WPF, C#, JavaScript, Ajax, PHP 5. Most of this information will be freely accessible but we are considering making certain sections available to subscribers who can access premium content. Any content accessible by subscription only (such as source code, scripts, windows applications etc.) would of course be Ok for users to implement in their own projects royalty free! Let us know what you think.


Posted in Misc | Tagged , , , , , , | Leave a comment

What have we been up to lately?

You may have noticed that things have been a little quiet on the blog front lately, apart from a few updates on new WordPress Plugins we have been creating.

The reason is that this has been taking up most of our time. But it is time well spent, as we have managed to produce 4 quite useful (we think!) WordPress Plugins in a little over 6 weeks.

You can see the fruits of our labour, at our WordPress.org Plugin directory page.

We will probably not be producing any new Plugins for WordPress, at least not for a while. But, we will be adding some nice new features to our existing Plugins. Any suggestions by the way, be sure to let us know!

We do love WordPress though, it is a great environment for developers to get their teeth into, and features a rich API to enable programmers to create some really great additions to the core WordPress Blog.

We will be getting back to C# development over the next couple of months, and also concentrating on SEO/SEM. This field is moving along rapidly and a site can really benefit from a deep understanding of the current technologies. If you have any requirements in this field than we would be happy to discuss them with you.

We already have clients who need a dedicated SEO/SEM solution and are working with them to enhance their web presence. Our next client could be you, so please do get in touch if you have any ideas you need help with.

Watch out for further announcements soon!

Posted in Misc | Tagged , , , | 1 Comment

Quick Code – New WordPress Plugin

Ok, we have another WordPress Plugin for you! Version 1.0 of our ‘Quick Code’ Plugin has been released on the WordPress Plugin directory this morning. This Plugin allows you to edit HTML, CSS, PHP, and MySQL in the admin area of your blog, and see the results displayed directly on the same page! This is very useful for testing code fragments.


There have been many times recently that I have needed to test out a quick snippet of code, but had nowhere to easily place it to see the output. What I have had to do up until now is create a ‘test’ Plugin and insert echo commands to view output. Of course, as anyone who has developed Plugins knows, the results of sending data output with the echo command can be unpredictable depending on where you enter the command in your Plugin code. Now all you have to do is to simply enter the code in the ‘Quick Code’ edit box and see the results displayed immediately!

There is another useful feature, which is the usage of three external code files that are automatically included by the Quick Code Plugin when the Plugin admin page renders. These are:

  • JavaScript file that is included in the admin head, and can be used to store JavaScript functions for reference from the main code edit box.
  • Style sheet CSS file, included in the admin head, that can be used to store commonly used blocks of CSS code.
  • PHP functions file, included directly before the main code output box, so that commonly used PHP functions can be stored and called from the main file.

See our Quick Code page for more information, or go to our Quick Code Plugin page on the WordPress.org Plugin directory.

Posted in WordPress Plugins | Tagged , , | 1 Comment