Jump to content


Photo

Tips and examples


4 replies to this topic

#1 Rich

Rich

    Advanced Member

  • Savvysoft
  • PipPipPip
  • 397 posts
  • Gender:Male

Posted 09 August 2007 - 08:52 AM

This topic will contain tips and examples of Calc4Web. We will periodially post new examples here, and we encourage our users to post here, too.

#2 Rich

Rich

    Advanced Member

  • Savvysoft
  • PipPipPip
  • 397 posts
  • Gender:Male

Posted 09 August 2007 - 08:57 AM

This tip can be found at http://www.calc4web.com/trialtip1.htm

You'll see how to convert a long and complex formula into a simple custom
function that can be used anywhere in any spreadsheet. You'll also create
a useful text parsing function that Excel should have shipped with, but
doesn't. And you'll see how to simplify one of the complex built-in
functions that Excel does ship with.

#3 Rich

Rich

    Advanced Member

  • Savvysoft
  • PipPipPip
  • 397 posts
  • Gender:Male

Posted 09 August 2007 - 09:05 AM

This can be found at http://www.calc4web.com/trialtip2.htm

The tip covers using newly created functions inside Excel to make it
a snap to build tables (which are easier to use and run much quicker than
Excel's tables), and also creating bullet-proof functions just like the
pros do, with error checks, return values like #NA and even allowing for
default values for missing inputs.

#4 Rich

Rich

    Advanced Member

  • Savvysoft
  • PipPipPip
  • 397 posts
  • Gender:Male

Posted 09 August 2007 - 09:06 AM

Go to http://www.calc4web.com/trialtip3.htm to see the tips.

These tips cover connecting to a database inside your new function, and
then processing the results. We also dive a bit into VBA (if you don't
know it, don't worry), showing you how handle one of the few drawbacks
of working with spreadsheets: looping. We also demonstrate how to call
into Calc4Web generated functions inside VBA (it's just as easy to call
the new functions from C, C++, standalone VB and any other high-level
language).

While VBA is hardly necessary to get a lot of value from Calc4Web, it's
nice to know how to make a great product even better.

#5 Rich

Rich

    Advanced Member

  • Savvysoft
  • PipPipPip
  • 397 posts
  • Gender:Male

Posted 09 August 2007 - 09:07 AM

To see these tips, go to http://www.calc4web.com/trialtip4.htm

The tips show you how you can handle calculations based on ranges of
unlimited size (break through the 65,536 row and 256 column limit without
Excel 2007), and also how to quickly diagnose what's going on if a
function doesn't work as expected (we don't mean Calc4Web made a mistake,
it's when the spreadsheet had an error in a formula. This is called
debugging in programmer-speak, and with Calc4Web it's a whole lot easier
than in a language like C or VBA).



Reply to this topic



  


1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users