Stake Ventures

So I’ve gotten most of the multi dimensional support completed. I only really need to create a user interface for moving dimensions around within the same axis or to another dimension.

The following screencast demos it a bit. Click on the screen shot below to view it:

So what is actually happening here is that I am creating a spreadsheet for revenue for various sites of mine (The revenue figures in the screencast bear no resemblance to actual revenue).

1. For the first part it is a normal 2 dimensional spreadsheet. I enter revenue per site per quarter
2. I then add another dimension to it (Year)
3. I Enter some data for the next year
4. I add a further dimension, but this time to the Y axis. I call it revenue type.
5. I add further data for the new revenue type
6. I Create a new view to demonstrate another view of the same data
7. I Pivot it, which basically flips the x and y axises.

My next demo will demonstrate the gui for moving dimensions around. The data model already supports it, but I’m working on as simple a gui as possible to do so. With this you should be able to change the order of dimensions, so you for example see the product dimension before the revenue type dimension. You could also move revenue type to the x axis instead.

Share your confidential code safely with a Source Code Confidentiality Agreement on our free web service Agree2

Here is as promised another little sneak preview:

(Click on the screenshot for the Quicktime movie)

What you will see is:

• Creation of new sheet
• Adding of rows
• Adding of formula
• Entering data
• Lack of row and column numbers/letters

You will notice various things missing:

• The only formula available at the moment is sums
• It’s not too nice graphically
• There are only 2 dimensions in it (the model supports arbitrary dimensions)

Create, negotiate and accept legally binding contracts for free with our Agree2 service.

WideWord seems to be taking off to some respects. I’m quite happy with the response considering it is about 2 weeks old. Amongst others Web 2.0 Central has covered WideWord and the upcoming WideSheet.

I should be ready with another little sneak peak of WideSheet tomorrow. I now have a fully working multidimensional spreadsheet model. There are no D8 like cell references and you should be able to get things working quickly. If I say so myself, it is pretty cool. However hold your horses, this is vastly more complex than WideWord and has some serious Rails trickery to make it work.

My goal is to provide an option for third party spreadsheet developers to sell or give away spreadsheet like templates, in the same way many small businesses sell excel templates/miniapplications today. If you are interested in developing apps like this, drop me an email at pelle@stakeitout.com

Create a simple NDA with zero legalese in no time at all and for free at our service Agree2.

I just cooked this up last night. It will be the next member of my family of web apps. It’s a fully Ajax based spreadsheet application. It wont be as complete as Excel, but have most of what a small business would need. Bear in mind the gui is still a bit rough.

While I’m working on this, go try out WideWord.

Create, negotiate and accept legally binding contracts for free with our Agree2 service.