On The Insider: Chris Brown Writes 2 Songs for Britney
1 Resources for

spreadsheet technology

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

Going Beyond Spreadsheets: How Visual Modeling Can Enhance Decision Analysis
Traditional spreadsheet technology has peaked as the most effect method of data analysis. This paper outlines how the next advancement in the speed and quality of decision making comes with the creation of fully interactive and visually compelling models that provide greater insight into data.
Tags: Decision Analysis, Business Objects, Spreadsheet, Modeling, Spreadsheet Technology, Productivity, Tools & Techniques, Databases, Management, Enterprise Software, Software, Data Management
White papers 2006-03-03

Additional Resources

More on the Use of the Spreadsheet: Making Changes to Existing Spreadsheets
In this paper the reader will learn how to maintain a spreadsheet. This will be done by making enhancements to the spreadsheets created. The reader will also learn about some of the logical processing capabilities of spreadsheets, capabilities which enable to give an "Intelligent" flavor to the applications that the...
Tags: Spreadsheet, Productivity
White papers 2005-03-31
Excel Spreadsheet help
I am trying to find a way to take information from a table in one spreadsheet and populate another cell in another spreadsheet. Can this be done?
Tags: PRODUCTIVITY, 1bravesfan@..., Excel spreadsheet
Discussion threads 2007-07-13
Excel 2002 Spreadsheet opens two copies with :1 or :2 added to filename
When I open my spreadsheet two copies appear. One copy is named file:1 the other is file:2. Changes made to either copy are replicated to the other, closing one file closes the other. Renaming the file does not stop the behavior. This is a new behavior...
Tags: PRODUCTIVITY, Microsoft Excel 2002, Microsoft Excel, pcorning@..., spreadsheet
Discussion threads 2007-06-06
Excel - Using formula in separate spreadsheet?
Hello,Can anyone advise if the following is possible?I have a pricing spreadsheet maintained by another entity that allows me to calculate a software license and b annual maintenance prices based on input value of "number of users".I am creating my own forecasting spreadsheet where each customer/prospect will have a "number...
Tags: PRODUCTIVITY, Microsoft Excel, tonygoulding@..., spreadsheet, pricing spreadsheet
Discussion threads 2007-07-20
Linking MS-Excel Spreadsheet
Hello,I've inherited an MS-Excel 97 spreadsheet, as a data-entry sheet. I need to import & link the spreadsheet into an MS-Access 97 database.I need to keep the spreadsheet as a "data-entry" sheet, because of the mass amount of data it contains, & the number of people using the spreadsheet. 1....
Tags: tptbusines_98@..., spreadsheet, windows, MS-Access 97
Q&A 2006-06-18
NCell (zip)
This program is a simple spreadsheet designed for maximum speed and ease of use, unlike all other spreadsheet you do not have to deal with formulas so it can be used also by people that are not expert in spreadsheet. With this program you can do many of the monitoring...
Tags: Spreadsheet, Productivity
Software downloads 2006-02-25
Spreadsheet Errors and Decision Making: Evidence From Field Interviews
When thinking about how spreadsheet errors contribute to bad decisions, it may be useful to think of that not primarily in terms of spreadsheets recommending the wrong course of action but rather as misinforming deliberations. Furthermore, the overall information context underpinning decisions is almost always murky, ill structured, and incomplete....
Tags: Decision-making, Spreadsheet, Productivity
White papers 2005-09-19
google_spreadsheet_8.jpg (A first look: Google's beta spreadsheet application)
jmb4I will be sticking to my works spreadsheet.I tried out the new beta office 2007 onlinedon't like it. I am happy with works spreadsheetfor what I do. I looked at your article about goole spreadsheet. I am much faster with what I know. If it is not broke do not...
Tags: jmb4@..., not switching, spreadsheet, hardware, Google Inc.
Discussion threads 2006-06-27
What We Know About Spreadsheet Errors
Although spreadsheet programs are used for small "Scratchpad" applications, they are also used to develop many large applications. In recent years, people have learned a good deal about the errors that they make when they develop spreadsheets. In general, errors seem to occur in a few percent of all cells,...
Tags: Spreadsheet, Productivity
White papers 2005-01-01
Word 2003 embedded links
Hi:I'm trying to create a response form with various sections that request different types of information. I'm trying to start with an embedded spreadsheet to capture the first block of data.I'm then trying to paste/link to the first embedded spreadsheet, so that it displays a different part of the...
Tags: PRODUCTIVITY, Word processors, Microsoft Office, sglance@..., Microsoft Word 2003, spreadsheet, Microsoft Word
Discussion threads 2007-06-01
Searching In A Spreadsheet
If I am doing a search for a specific word or file number, etc, in my spreadsheet, is there a way that you can search through all the tabs of the spreadsheet without actually going to each tab and redoing the search?Click on the Left/top bar cornerit will highlight everything,...
Tags: PRODUCTIVITY, corie.hunter@..., spreadsheet
Discussion threads 2007-07-11
Errors During Spreadsheet Development Experiments
Ever since the earliest days of spreadsheet development, there have been reported incidents of spreadsheet errors and the problems they caused. More importantly, a number of systematic field audits have reported errors in 24% of the spreadsheets audited (86% in studies since 1997), and these rates may be low because...
Tags: Spreadsheet, Experiments, Productivity
White papers
Gencel: Automatic Generation of Correct Spreadsheets
Spreadsheets that are used in the real world are full of errors and cause companies and organizations to lose millions of dollars every year. Finding and correcting spreadsheet errors is a very difficult and time-consuming activity. Observing that all errors in spreadsheets result from updates or changes applied to the...
Tags: Spreadsheet, Productivity
White papers 2006-06-29
Automatic Generation and Maintenance of Correct Spreadsheets
Existing spreadsheet systems allow users to change cells arbitrarily, which is a major source of spreadsheet errors. This paper proposes a system that prevents errors in spreadsheets by restricting spreadsheet updates to only those that are logically and technically correct. The system is based on the concept of templates that...
Tags: Spreadsheet, Program Generator, Productivity
White papers 2005-05-15
Clarity (exe)
Clarity provides 14 powerful but easy to use analytical tools for anyone using a spreadsheet. The perfect add-on for any spreadsheet. Simply copy the data and click Capture Data in Clarity to begin your analysis. Clarity simplifies the analysis of data, easily handles empty cells, and provides additional statistical and...
Tags: Clarity, Spreadsheet, Productivity
Software downloads 2007-01-22
Using Objects of Measurement to Detect Spreadsheet Errors
There are many common spreadsheet errors that traditional spreadsheet systems do not help users find. This paper presents a statically-typed spreadsheet language that adds additional information about the objects that the spreadsheet values represent. By annotating values with both units and labels, users denote both the system of measurement in...
Tags: Spreadsheet, Productivity
White papers 2005-11-22
The Managed Spreadsheet Environment: How to Preserve the Best and Most Useful Features of Spreadsheets While Mitigating the Risks and Expense Caused by Unbridled Shadow IT
A managed spreadsheet environment effectively retains all of the benefits of using spreadsheets are personal software, but eliminates substantial amounts of risk and cost. Implementing this environment will be challenging, though, as there are only a few technology providers able to provide the capability. An even greater challenge will be...
Tags: Information Technology, Environment, Spreadsheet, Productivity
White papers 2005-09-22
Spreadsheet Consolidator (zip)
If your problem involving volumes of Excel spreadsheets files and requirements for flexibility in consolidation then Spreadsheet Consolidator is the accurate tool for you. Spreadsheet Consolidator is an Excel add-in which will allow to consolidate spreadsheet data from one or several sheets from one or many open workbooks, easy and...
Tags: Spreadsheet, Spreadsheet Consolidator, Productivity
Software downloads 2005-12-26
Generate External Tables From an Excel Spreadsheet Using Apache Jakarta POI
DBAs and application developers frequently face the task of loading data from Excel spreadsheets into Oracle databases. 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....
Tags: Excel Spreadsheet, Oracle Corp., Apache Software Foundation, Spreadsheet, Microsoft Excel, Productivity, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
White papers
  • << Previous
  • page 1 of 1
  • Next >>


Network Administration in Windows Server 2003
While the role of a Windows network administrator would never be considered easy, you can lighten your load by knowing the ins and outs of Microsoft's ...
Buy Now
Recovering Windows Servers
Your organization's servers hold your data, systems, communications, and business processes together. So it's critical for you to understand how to us ...
Buy Now

Cracking Open Apple Tech