Web-based spreadsheets like Google’s are great for collaborating, but slow you down when it comes to clicking through cells quickly or creating really big spreadsheets. It doesn’t even have a search function other than what your browser can do on its own (try finding a name in a list of 500). Desktop-based spreadsheets like Microsoft’s Excel give you all the features and speed you want, but are not easy to share. (Yes, there is SharePoint, but most people resort to e-mailing the bulky files around, creating a version-control nightmare).

Tomorrow at noon (* Update: this has been pushed to November 15*), Transmedia, a New York City startup, will take a step towards bridging those online and offline worlds. It is adding a spreadsheet to its Glide service called Glide Crunch. (Good name!). So far, all of the apps on Glide—including a Word processor, presentation software, e-mail, calendar, contacts, and online photo, video, and music sharing—have been completely Web-based. But with Glide Crunch, the spreadsheet will operate as a local application on your desktop that is automatically synced to your Glide Webtop without you having to do anything special other than create a spreadsheet as you normally would.

Glide Crunch is not based on Adobe AIR or Google Gears, the two main platforms for creating offline, Web-like apps. Transmedia coded the application from scratch using C/C++. In contrast to something like Google Gears, Glide Crunch is not trying to download data into the browser. “We have left the browser,” says CEO Donald Leka. “The browser is limited. It can only hold so much data.” Google Spreadsheet, for instance, only supports 100,000 cells and up to 40 sheets, says Leka. Glide Crunch, in contrast, can support 16.7 million cells and an unlimited number of sheets in a single spreadsheet.

Glide Crunch also supports advanced formulas, pivot tables, various printing formats, and, yes, you can search within a spreadsheet. Leka is really going after Excel users with a powerful local spreadsheet that syncs automatically to the Web, where it is shareable with others. He thinks his new spreadsheet will meet the needs of 60 to 70 percent of the market. “Scientists and financial-modeling experts can continue to use Excel,” he allows. But Glide Crunch is robust enough for him to use to manage Transmedia’s P&L. “We use Glide for everything,” he says.

Glide, which is free for the first two gigabytes and $50 for 12 gigabytes, comes with all of the Web apps listed above and also works on the iPhone and other mobile devices. (it is great for showing PowerPoint slides on your iPhone, which you previously could not do). Later this month and next, Transmedia will be rolling out local versions of its other productivity apps, starting with Glide Write, then e-mail, and Glide Presenter. Glide may not have the user numbers of Google Docs (Glide has about 500,000 total users, 14 percent actually pay), but it is pushing the envelope in terms of functionality and in terns of fusing the Web and the desktop. The company’s revenues are closing in on $4 million a year, with no VC money. The $6.5 million it has raised has all been angel investors, including several ex-Wall Street analysts like Harold Vogel.

Here are some of the advanced functions and features Glide Crunch will support:

Function

Sin – sine function

Cos – cosine function

Tan – tangent function

Asin – arc sine function

Acos – arc cosine function

Atan – arc tangent function

Sinh – hyperbolic sine function

Cosh – hyperbolic cosine

Tanh – hyperbolic tangent function

Asinh – hyperbolic arc sine function

Acosh – hyperbolic arc tangent function

Atanh – hyperbolic arc tangent function

log2 – logarithm to the base 2

log10 – logarithm to the base 10

log – logarithm to the base 10

ln – logarithm to base e (2.71828…)

exp – e raised to the power of x

sqrt – square root of a value

sign – sign function -1 if x<0; 1 if x>0

rint – round to nearest integer

abs – absolute value

if – if … then … else …

min – min of all arguments

max – max of all arguments

sum – sum of all arguments

avg – mean value of all arguments

and more…

Operator

and logical and

or logical or

x or logical xor

< = less or equal

>= greater or equal

!= not equal

== Equal

> greater than

< less than

+ Addition

– Subtraction

* Multiplication

/ Division

^ raise x to the power of y

! factorial