Spreadsheet Structure Inspection Using Low Level Access and Visualisation
White Papers Ways of studying the structure of a spreadsheet itself is normally constrained to the tools provided in the spreadsheet software. Spreadsheets are an extremely common form of end-user programming used for many applications from student marks to...
[September 20, 2006, 0:00]
Spreadsheet management is not the way to go!
Talkback Accounting based on manual spreadsheet management is not a viable solution for businesses. Advising companies to base their financial management on error-prone worksheets is not the way to go. SMEs need to take control of their financial activities.
[November 4, 2009, 17:04]
Spreadsheet Functional Programming
White Papers The functional programming community has shown some interest in spreadsheets, but surprisingly no one seems to have considered making a standard spreadsheet, such as Excel, work with a standard functional programming language, such as Haskell.
[January 9, 2009, 0:00]
Using an Excel Spreadsheet With PC SAS, No Gymnastics Required!
White Papers This paper will show developers how to include Excel spreadsheet in SAS using FILENAME and INFILE statements. Does a developer regularly analyze data received in Excel spreadsheets using SAS? Does the developer wish for a single-step method for...
[September 12, 2006, 1:00]
Assess staff needs with this spreadsheet
White Papers But this spreadsheet goes a long way toward helping the IT manager make that determination. Determining the number of IT staff needed is not a completely scientific process.
[May 16, 2006, 6:56]
Generate External Tables From an Excel Spreadsheet Using Apache Jakarta POI
White Papers With the advent of Oracle 10g's spreadsheet-like model capabilities, it is likely that more data that is currently stored and viewed in spreadsheets will be loaded into Oracle databases for manipulation and processing.
[October 17, 2006, 0:00]
Then why does the same spreadsheet load faster in ODF?
Talkback Were that not true, the da Vinci plug-in for MS Excel could not load a million row ODF spreadsheet into IMBR faster than the same spreadheet rendered in OOXML. Albert, the difference in conversion speed when loading or saving a file from to OOXML...
[February 29, 2008, 16:42]
Real Options by Spreadsheet: Parking Garage Case Example
White Papers Specifically, it illustrates a spreadsheet approach to valuing "Real options" in a project. The spreadsheet approach uses standard procedures; is based on data available in practice; and provides graphics that explain the results intuitively.
[September 20, 2006, 1:00]
Net Worth / Wealth Spreadsheet
Downloads This spreadsheet makes it easy to calculate your net worth, as well as track it from month to month. One of the keys to acquiring and maintaining wealth (also known as net worth) is to track it. As they say, If you track your results, you ll see...
[May 10, 2006, 10:02]
ExcelGrid: A .NET Plug-In for Outsourcing Excel Spreadsheet Workload to Enterprise and Global Grids
White Papers Microsoft Excel is a widely used spreadsheet application and provides a very easy-to-use system, which any user can utilise to perform complex analysis on data without having to learn programming. This paper describes a method to grid-enable...
[June 20, 2007, 1:00]
Inventory Spreadsheet
Downloads A useful spreadsheet for keeping track of household inventory. Especially handy for insurance record-keeping purposes, in case of loss, theft, or destruction. Allows for insertion of images, manufacturer contact information, and item specifics.
[February 20, 2006, 9:08]
A spreadsheet that doesn't add up might not be good for business
Talkback You'll note that DIS 29500 (aka OOXML) cannot do its sums very well, with some financial functions giving results that are wrong by several percent -- do you want a spreadsheet that implements that feature?
[May 30, 2008, 14:59]
Download our sample WORKDAY function spreadsheet
White Papers Download this sample spreadsheet that uses Excel's WORKDAY function to consider only business hours. Excel's DATE function is essential for performing calculations using dates, but it doesn't account for weekends or holidays.
[May 23, 2006, 1:00]
MobiSystems SpreadSheet
Downloads The grid structure of MobiSystems SpreadSheet can be applied to organize all kinds of information - from simple shopping lists to timetables, databases, sport or game scoring spreadsheets, and mathematical calculations.
[November 5, 2005, 7:00]
World time finder spreadsheet
White Papers TechRepublic's World time finder spreadsheet lets you quickly find the local time in 79 times zones and 141 cities around the world. When you conduct business with organizations across multiple time zones, you need the ability to quickly calculate...
[May 19, 2006, 1:00]
Network Associates warns of spreadsheet virus
News The "XM/Compat" virus can result in permanent changes to data stored in the spreadsheets, company officials said. Users of the company's anti-virus software for spreadsheets are being advised to upgrade to a new version posted on the Network...
[October 1, 1998, 6:05]
Red Cross Responds to Spreadsheet Emergency With Adaptive Planning
White Papers The American Red Cross in Greater New York Chapter helps nine million people prevent, prepare for and respond to emergencies. American Red Cross wanted to increase the efficiency and flexibility of the budgeting process and minimize opportunities...
[January 1, 2009, 0:00]
Excel Intelligence: Conquering Spreadsheet Defeat
White Papers A rapid recovery is possible from a situation that now leaves many E&P executives feeling vulnerable and overwhelmed - unmanaged spreadsheets. Using existing technological capability and end-user skill sets E&P companies can turn an unwieldy...
[April 3, 2008, 1:02]
Long Live the Spreadsheet: Leveraging Microsoft Excel for Effective BPM
White Papers Microsoft Excel is the de facto language of business. For nearly a quarter of a century, spreadsheets have helped businesspeople of all stripes communicate their past performance as well as their expectations for the future.
[March 16, 2009, 4:22]
Anatomy of Excel formatting: Make better spreadsheet presentations - part 3
White Papers Sometimes we take for granted what users know. While Microsoft Excel may be familiar to you, if you are on a help desk you will have to explain how the application works to users that fall within a vast range of skill level and knowledge.
[May 16, 2006, 1:00]



