- Subscribe to this page:
- RSS
- Email Alert
spreadsheets
(240 results)-
White Papers
Spreadsheets, Graphics Calculators and Mathematics Education
Dec 2007
Over recent years, spreadsheets have been increasingly recognised as having a role in teaching and learning mathematics, but have continued to suffer the limitation of requiring access to...
Provided by Australian Association of Mathematics Teachers
-
White Papers
Compensating the Computational Bias of Spreadsheets With MKM Techniques
May 2009
Spreadsheets are mathematical documents that are heavily employed in administration, financial forecasting, education, and science because of their intuitive, flexible, and direct approach to...
Provided by German Research Center for Artificial Intelligence
-
White Papers
Compiling Spreadsheet-Defined Functions
Jun 2009
Spreadsheets are ubiquitous end-user programming tools, but lack even the simplest abstraction mechanism: The ability to encapsulate a computation as a function. This paper presents a solution in...
Provided by IT University of Copenhagen
-
White Papers
An MCL Algorithm Based Technique for Comprehending Spreadsheets
Aug 2008
Spreadsheets are computer programs. However, as with programs written in traditional programming languages, it is very difficult to understand a spreadsheet created by others. This is because...
Provided by University of Botswana
-
White Papers
Spreadsheet-Based Ultrasensitive Magnetic Field Sensor Design Tool Using Microsoft Excel
Jun 2009
A spreadsheet-based preliminary design and noise consideration system is presented in this paper. The system is developed using Microsoft Excel. It allows users to optimize the various parameters...
Provided by University of Delaware
-
White Papers
A Critical Review of the Literature on Spreadsheet Errors
Jun 2008
Among those who study spreadsheet use, it is widely accepted that errors are prevalent in operational spreadsheets and that errors can lead to poor decisions and cost millions of dollars. However,...
Provided by Reed Elsevier
-
White Papers
Flodro 4.0: Spreadsheets Based Flood Frequency Analysis Computer Package
Aug 2009
A computer package for flood frequency analysis, based on the application of common use spreadsheets framework provided by Excel (Excel is a registered trademark of Microsoft Corporation, Inc.),...
Provided by University of the Americas Puebla
-
White Papers
Security Policy Analysis Using Deductive Spreadsheets
Nov 2007
As security policies get larger and more complex, analysis tools that help users understand and validate security policies are becoming more important. This paper explores the use of deductive...
Provided by Association for Computing Machinery
-
White Papers
Spreadsheet-Based Decision Support Systems
Nov 2008
This paper will present an important category of Decision Support Systems (DSS), spreadsheet-based DSS. After a short review of literature, the paper will specify the main characteristics that...
Provided by Universitatea Babes - Bolyai, Cluj-Napoca
-
White Papers
An Empirical Study of End-User Behaviour in Spreadsheet Debugging
Jul 2008
Very little is known about the process by which end-user developers audit and debug spreadsheets. Any research pertaining to the development of spreadsheet debugging methodologies or automated...
Provided by PPIG
-
White Papers
Spreadsheet Interaction With Frames: Exploring a Mathematical Practice
May 2009
Since Mathematics really is about what mathematicians do, this paper will look at the mathematical practice of framing, in which an object of interest is viewed in terms of well-understood...
Provided by Jacobs University Bremen
-
White Papers
Spreadsheet Visualisation to Improve End-User Understanding
Jan 2010
Spreadsheets are an extremely common form of end-user programming that have many applications, from calculating student marks to accounting for global multinationals. Ways of studying the...
Provided by Australian Computer Society
-
White Papers
Drowning in Spreadsheets
Sep 2009
Spreadsheet applications such as Microsoft Excel are widely used within most organisations and with good reason. They're powerful, easy to use, and they allow users to perform calculations quickly...
Provided by IPL Information Processing
-
White Papers
Successful Test Case Management: It Takes More Than a Spreadsheet
May 2009
Testing software applications can require hundreds to thousands of unique test cases, the time to execute them, and the ability to efficiently manage the results. As software becomes increasingly...
Provided by Seapine Software
-
White Papers
High Performance Spreadsheet Simulation on a Desktop Grid
Aug 2009
This paper, a high performance spreadsheet simulation system called S3 is presented. The approach is to add power of parallel computing on Windows-based desktop grid into popular Excel models by...
Provided by Kasetsart University
-
White Papers
Rapid Development of Spreadsheet-Based Web Mashups
Apr 2009
The rapid growth of social networking sites and web communities have motivated web sites to expose their APIs to external developers who create mashups by assembling existing functionalities....
Provided by Association for Computing Machinery
-
White Papers
Printable Spreadsheets Made Easy: Utilizing the SAS Excel XP Tagset
Aug 2008
The SAS System offers myriad techniques for reporting on data within Microsoft Excel. Depending on the task at hand SAS Access or the Output Delivery System (ODS) might be good choices; Dynamic...
Provided by UnitedHealth Group
-
White Papers
Logic of the Hearings Spreadsheet
Apr 2009
Primarily, the hearings spreadsheet is a tool to assist in the management of hearings. It is particularly useful to assess performance against temporal targets set by the Corporate Plan....
Provided by Intellectual Property Office
-
White Papers
An Empirical Study of End-User Behaviour in Spreadsheet Error Detection & Correction
Jul 2008
Very little is known about the process by which end-user developers detect and correct spreadsheet errors. Any research pertaining to the development of spreadsheet testing methodologies or...
Provided by Dundalk Institute of Technology
-
White Papers
Spreadsheets for Geothermal Water and Gas Geochemistry
Feb 2010
Two Excel spreadsheets released with this paper support many of the common graphical analyses of water and gas chemistry used to interpret hot spring, fumarole and well samples in geothermal...
Provided by Mighty River Power
-
White Papers
Recreating an Excel-Based Report With SAS and ODS
Dec 2008
One of the best features of Excel is the ease with which a paper-based report can be compiled to include data tables and charts on the same page, all with easily controlled fonts, colors and...
Provided by North Carolina State University
-
White Papers
An Optimal Way to Import Excel Worksheets Into PC SAS
Aug 2008
There are many ways to import data from Microsoft R Excel R into PC SAS R, and the "Optimal" way often depends upon the project and the programmer's preference. However, by adhering to clear...
Provided by SAS Institute
-
White Papers
Calculating the VIX in Excel
Dec 2007
The VIX has become a popular volatility index that is based on a weighted average of S&P 500 options that straddle a 30-day maturity. This manner of calculating the VIX emerged in September of...
Provided by University of Richmond
-
White Papers
Scientific and Algebraic Thinking: Visualizing With Interactive Excel and Nested Styrofoam Cups
Nov 2008
Using the stacking of nested Styrofoam cups, the paper constructs a mathematical model and explores it through simulations, all in Excel (prior experience unnecessary). This paper connects...
Provided by Prince George's Community College
-
White Papers
Methodologies for Converting Microsoft Excel Spreadsheets to SAS Datasets
Sep 2008
SAS version 9 offers many new features to handle the conversions from SAS to Excel and back again. Excel is often used as a data entry vehicle, thus making these conversions to SAS necessary. The...
Provided by SAS Institute
-
White Papers
Customized Excel Output Using the Excel Libname
Jul 2008
The advent of the ODS ExcelXP tagset and its many features has afforded the SAS user great flexibility in creating publishable Excel output. But what if the report must be delivered by populating...
Provided by Stratia Consulting
-
White Papers
Tying It Together: Using ODS to Insert EXCEL Hyperlinks
Dec 2008
A common task in report development is to generate EXCEL spreadsheets that have logical links between the various worksheets. Quite often, it's desirable to insert hyperlinks in selected cells to...
Provided by Regions Financial
-
White Papers
Making Microsoft Excel Accessible: Multimodal Presentation of Charts
Oct 2009
Several solutions, based on aural and haptic feedback, have been developed to enable access to complex on-line information for people with visual impairments. Nevertheless, there are several...
Provided by Association for Computing Machinery
-
White Papers
Requirements for 21st Century Spreadsheets
Oct 2009
What's one way to destroy a finance department's productivity? Get rid of spreadsheets. Or one way to immediately improve the finance department's productivity? Get rid of spreadsheets. This is...
Provided by Ventana Research
-
Whitepapers
Spreadsheet-Based Planning in Today's Economy: Why You're Up Against the Wall
May 2009
Spreadsheets are useful tools in many aspects of business, but they cannot support today's complicated enterprise planning needs because they: are prone to data errors, cannot handle the complex...
Provided by IBM
-
Case Studies
IT Solutions Provider Produces Reports 20 Percent Faster With Microsoft Office 2010
Mar 2010
Heartland Technology Solutions (HTS) aims to help customers boost productivity by transforming complex processes into simple, straightforward solutions that align with customer needs. A Microsoft...
Provided by Microsoft
-
Case Studies
Consultancy Creates Office Business Applications for Efficient Process Integration
Jul 2009
Tahoe Partners helps customers better integrate and execute business processes with Office Business Applications (OBAs) by connecting enterprise data with the familiar user interface and...
Provided by Microsoft
-
White Papers
Traffic Lighting Your Multi-Sheet Microsoft Excel Workbooks the Easy Way With SAS
Mar 2010
"Traffic lighting" is the process of applying visual formatting to data. This paper explains how to use Base SAS9 software to create multi-sheet Microsoft Excel workbooks (for Excel versions 2002...
Provided by SAS Institute
-
White Papers
Creating Highly Customized, Binary Excel Workbooks Using XML
Mar 2010
This paper will illustrate a new method for generating binary Excel workbooks using SAS data. It will illustrate how one can go beyond ODS, proc export, Access engines, etc. to make...
Provided by SAS Institute
-
White Papers
A VB.NET Utility to Transfer Multiple Data Files Between SAS and Microsoft Access/Excel by Automatically Generating SAS Import/Export Statements
Apr 2010
A VB.NET utility was developed to automate the process of converting data files between SAS and Microsoft Access or Microsoft Excel using point-and-click in the Windows environment. It saves time...
Provided by SAS Institute
-
White Papers
ODS ExcelXP: Tag Attr Is It! Using and Understanding the TAGATTR= Style Attribute With the ExcelXP Tagset
Mar 2010
The ODS ExcelXP tagset has many options to change its behavior. Many are set with the options in the ODS statement. There are others that must be set through the style. Most of these are set in...
Provided by SAS Institute
-
White Papers
Choosing the Right Tool From Your SAS and Microsoft Excel Tool Belt
Mar 2010
There are over a dozen ways to bring the data into SAS from Microsoft Excel or to push it out from SAS to Excel. Some are simple wizards, and others are more complex programming techniques. How...
Provided by SAS Institute
-
Webcasts
Microsoft Office System Webcast: Tips and Tricks for Outlook 2007 and Office 2010 (Level 100)
Apr 2010
The attendee will learn about new features and timesavers to help in the day-to-day work. This webcast is good for beginner and intermediate users. The presenter will also include a look at some...
Provided by Microsoft
-
Webcasts
Microsoft Webcast: What's New in Office 2010? (Level 100)
Apr 2010
This webcast provides an overview of the Microsoft Office 2010 client software and Office Web applications, and the presenter discusses the exciting new features in Office 2010.
Provided by Microsoft
-
White Papers
Work in Progress - SpreadSheet Implementation Programming Project Course
Oct 2008
Development of a course and textbook focusing on implementation of a spreadsheet program is proposed. The semester-long course will be suitable as a senior elective or graduate course for students...
Provided by Institute of Electrical and Electronics Engineers
-
Case Studies
Managed Services Provider Saves 520 Hours a Year With Microsoft Office 2010
Aug 2010
NxGen Communications specializes in providing systems integration and managed services for info communication solutions such as enterprise telephony, IP telephony, contact centres, and unified...
Provided by Microsoft
-
Case Studies
Microsoft Office 2010 Brings About Productivity Boost at Ship Management Firm
Aug 2010
Established in 1983, Belships Management (Singapore) Pte Ltd offers third-party ship management services. These range from crewing management and technical management to port agency services and...
Provided by Microsoft
-
Case Studies
Microsoft Office 2010 Halves Collaboration Time at Korean IT Firm
Aug 2010
Vinyl is a recognized brand in the Web, mobile and new media industries since it was established in 2000. By January 2008, it grew to 148 employees. Its main business is pursuing creativity and...
Provided by Microsoft
-
Case Studies
JET OIL Adopts Microsoft Office 2010 in Order to Improve Its Internal Administration
Aug 2010
JET OIL is one of the leading petroleum companies in Greece, operating with great success in the area of petroleum, fuel and oil products trading in Greece and the Balkans area. JET OIL currently...
Provided by Microsoft
-
Case Studies
Accounting Firm Chooses Office 2010 Over OpenOffice.org to Ensure Reliability
Aug 2010
Established in 1985, Chio Lim Stone Forest (CLSF) is the largest accounting and business advisory group outside the Big Four in Singapore. Over the years, its core business has extended beyond...
Provided by Microsoft
-
Case Studies
IT Infrastructure Solutions Provider Enhances Collaboration With Microsoft Office 2010
Aug 2010
Agile iSolutions is an IT infrastructure solutions provider for SMEs in Singapore. The company offers a whole range of IT services from the provision of networking solutions, Internet...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: Visio 2010 Pivot Diagramming for Visualizing Business Data and Structure (Level 200)
Aug 2010
In this highly data-focused webcast, we share the techniques that can dramatically increase the understanding, efficiency, and productivity of Microsoft Visio 2010 users, turning Visio generalists...
Provided by Microsoft
-
Case Studies
Airline Increases Productivity, Enhances Impact, and Reduces Costs With Office 2010
Aug 2010
Various business teams at Emirates airline are responsible for developing documents and presentations to support sales initiatives, performance research, and training programs for the company's...
Provided by Microsoft
-
Webcasts
MSDN Webcast: Office Business Applications Evolved (Level 300)
Jun 2010
Microsoft Office Business Applications (OBAs) have evolved significantly in the 2010 release. This webcast explores how building OBAs has progressed, and looks at the types of solutions one can...
Provided by Microsoft
-
White Papers
Basic Excel for Engineers
Oct 2008
Excel is a widely used spreadsheet developed by Microsoft. Although used widely by business professionals, it can be very useful to the engineer as well. An excellent paperback book which...
Provided by University of Minnesota
-
White Papers
How to Create a Form Enabled Spreadsheet in Google Docs for Use as a Survey in Google Sites
Mar 2008
How to create a form enabled spreadsheets in Google Doc for use as a Survey in Google Site. This is a useful task if one is going to gather responses to a form or survey from a group of people....
Provided by Rhode Island College
-
White Papers
A Spreadsheet-Like User Interface for Combinatorial Multi-Objective Optimization
Aug 2009
The authors present Moolloy, a general purpose, spreadsheet-like user interface for combinatorial multi-objective optimization. Current user interfaces for multi-objective optimization tend to...
Provided by University of Paderborn
-
White Papers
Morphit - Spreadsheets Evolved
Oct 2009
The first modern spreadsheet was VisiCalc from Software Arts created in 1979 for the Apple Mac. This same design is common in spreadsheets today. This was quickly followed by spreadsheets for...
Provided by Edge Software Consultancy
-
Webcasts
IT Manager Webcast: IT Manager Community Chat with Kevin Remde: Office 2010 - Deployment (Level 200)
Jun 2010
Chatting is one of the main features available in all web applications and websites. This webcast provides the details of IT Manager Community chat and describes how it processing. This is...
Provided by Microsoft
-
Webcasts
MSDN Radio: Office 2010 With John Durant
May 2010
Has one ever imagined, or wanted lot of things with what they already have? If one would like to take an advantage of an extended potential of what they own no, then, one has to join with, Mr....
Provided by Microsoft
-
Webcasts
MSDN Webcast: Creating Microsoft Office 2010 Add-Ins Using SharePoint 2010 as a Data Source (Level 300)
May 2010
This is the webcast which is exclusively developed for all the developers to face the internal Microsoft Share Point data within the Microsoft office client applications. This could allow all the...
Provided by Microsoft
-
Case Studies
Connecting Microsoft Excel PivotTables to Oracle OLAP for Powerful Ad Hoc Query and Analysis
Jan 2010
A masters-level course in Business Computing at the University of Applied Sciences incorporates the very interesting subject of Advanced Data Warehousing and Data Mining. The idea of the course is...
Provided by Simba Technologies
-
Case Studies
Russian Bank Primsotsbank Switches From OpenOffice.org to Microsoft Office
May 2010
This case study reveals how a world famous financial giant in Russia shifted from OpenOffice.org to Microsoft Office. Headquartered in Vladivostok, the Social Commercial Bank of Primorye...
Provided by Microsoft
-
Case Studies
Case Study 7 Interactive Spreadsheets
Nov 2008
This case study speaks about the perceptions of students about Statistics. The subject is generally considered difficult and intensive by the students. The paper seeks to increase students'...
Provided by University of Cape Town
-
Webcasts
Office 2010 - Security and Performance Enhancements
Feb 2010
ITpros have a lot to cheer about in terms of the enhancements in Office 2010. Security and performance have been ingrained into the design of the product and as an IT Pro, it gives the flexibility...
Provided by Microsoft
-
Webcasts
Microsoft Office System Webcast: Tips and Tricks for Excel 2007 and Office 2010 (Level 100)
May 2010
This webcast will help to get the most out of Excel 2007. The attendee will learn about new features and timesavers to help in the day-to-day work. This webcast is good for beginner and...
Provided by Microsoft
-
White Papers
Ad Hoc and Statistical Model Visualization Using JMP, SAS and Excel
Mar 2010
Generally speaking, models are abstractions of real-life systems used to facilitate understanding and to aid in decision making. However, models mean different things in different disciplines....
Provided by SAS Institute
-
White Papers
Using SAS Output Delivery System (ODS) Markup to Generate Custom PivotTable and PivotChart Reports
Mar 2010
One of Microsoft Excel's most powerful features is its ability to create PivotTable reports. A PivotTable report is an interactive table that enables one to summarize output as well as to change...
Provided by SAS Institute
-
White Papers
Using Excel to Individualise Basic Mathematics Assignments
Jun 2009
This paper sets out a method for creating and marking individualised mathematics assessments for students based on their ID numbers. It therefore provides a means for setting assessed coursework...
Provided by University of Bristol
-
White Papers
A Microsoft Excel Simulation Illustrating the Central Limit Theorem's Appropriateness for Comparing the Difference Between the Means of Any Two Populations
Oct 2008
Using Microsoft Excel, several interactive, computerized learning modules are developed to illustrate the Central Limit Theorem's appropriateness for comparing the difference between the means of...
Provided by University of South Dakota
-
White Papers
Integrated Microsoft Excel: Underwriting Can Be Connected and Still Performed in Excel
Nov 2009
Underwriting has always been done in standalone Microsoft Excel spreadsheets. This approach has extensive benefits in terms of flexibility and analytic power. It also is limited by several...
Provided by Rockport Group
-
White Papers
Targeted Technology Training: Excel Basics
Feb 2009
Excel allows the user to create spreadsheets similar to paper ledgers that hold data and can perform automatic calculations. Each Excel file is called a workbook and can hold many worksheets. A...
Provided by ConnectingStanislaus.com
-
White Papers
Spreadsheets
May 2010
A spreadsheet is an electronic piece of paper divided into rows and column209s. One can use a spreadsheet to tabulate grades, budgets, bank loans, inventory totals, or calculate experiments in...
Provided by Summercore
-
White Papers
Introduction to Data Analysis With Spreadsheets
Jan 2009
In this physics laboratory one will use computer spreadsheets to record and analyze the data. This lab is a tutorial which teaches one about spreadsheets in general and specifically introduces a...
Provided by University of Maryland
-
White Papers
Spatio-Textual Spreadsheets: Geotagging Via Spatial Coherence
Nov 2009
The spatio-textual spreadsheet is a conventional spreadsheet where spatial attribute values are specified textually. Techniques are presented to automatically find the textually-specified spatial...
Provided by Association for Computing Machinery
-
White Papers
Compensating the Semantic Bias of Spreadsheets
Aug 2008
Spreadsheets are heavily employed in administration, financial forecasting, education, and science because of their intuitive, flexible, and direct approach to computation. They represent examples...
Provided by German Research Center for Artificial Intelligence
-
White Papers
Improving SAS Processes With Excel
Oct 2009
SAS and Excel are two of the most useful tools in processing, analyzing, and reporting data, with each of them having its own strength and often a distinct user group. For example, SAS is one of...
Provided by Zale
-
White Papers
End-User Service Computing: Spreadsheets as a Service Composition Tool
Dec 2008
This paper shows how spreadsheets, an end-user development paradigm proven to be highly productive and simple to learn and use, can be used for complex service compositions. The paper identifies...
Provided by Institute of Electrical and Electronics Engineers
-
White Papers
Discovery-Based Edit Assistance for Spreadsheets
Jun 2009
Spreadsheets can be viewed as a highly flexible end-users programming environment which enjoys wide-spread adoption. But spreadsheets lack many of the structured programming concepts of regular...
Provided by University of Minho
-
White Papers
Evaluating Tractor Ownership With the OwnTractor Spreadsheet
Sep 2008
This paper accompanies the OwnTractor computer spreadsheet, which was developed as a "Quick and dirty" aid to help individuals think through the tractor ownership decision. Thus, most of the...
Provided by King Saud University
-
White Papers
An Instructional Video Module on Spreadsheets Accommodating the Needs of Senior Citizens
Mar 2010
An increasing number of senior citizens are motivated to learn how to use computers to make everyday tasks more effective and efficient. However, due to changes that occur with aging, they require...
Provided by University of Hawaii
-
White Papers
Why Spreadsheets Are Inadequate for Uncertainty Analysis
Jan 2010
The importance of estimating and reporting measurement uncertainty has greatly increased over the past few years. As a result, many companies and organizations have developed, or are seriously...
Provided by Integrated Sciences Group
-
White Papers
Reducing Spreadsheet Errors
Sep 2009
Increasing computational power and memory capacity in desktop computers has resulted in access to numerical techniques previously unavailable to many users. Although computational capabilities...
Provided by United States Army
-
White Papers
Spreadsheets in Mathematics: Accessibility, Creativity, and Fun
Nov 2007
A spreadsheet, such as Microsoft Excel, provides educators with a creative tool for the study and teaching of mathematics, mathematical modeling, and mathematical visualization. It enables...
Provided by Yahoo
-
White Papers
Enhancing Web-Based Data Collection Using Excel Spreadsheets
Jan 2008
The Current Employment Statistics (CES) Survey, conducted by the Bureau of Labor Statistics (BLS), is a monthly panel survey of over 390,000 business establishments. The national CES estimates of...
Provided by U.S. Bureau of Labor Statistics
-
White Papers
Recreating an Excel-Based Report With SAS and ODS
Dec 2008
One of the best features of Excel is the ease with which a paper-based report can be compiled to include data tables and charts on the same page, all with easily controlled fonts, colors and...
Provided by North Carolina State University
-
White Papers
An Optimal Way to Import Excel Worksheets Into PC SAS
Aug 2008
There are many ways to import data from Microsoft R Excel R into PC SAS R, and the "Optimal" way often depends upon the project and the programmer's preference. However, by adhering to clear...
Provided by SAS Institute
-
White Papers
Calculating the VIX in Excel
Dec 2007
The VIX has become a popular volatility index that is based on a weighted average of S&P 500 options that straddle a 30-day maturity. This manner of calculating the VIX emerged in September of...
Provided by University of Richmond
-
White Papers
Scientific and Algebraic Thinking: Visualizing With Interactive Excel and Nested Styrofoam Cups
Nov 2008
Using the stacking of nested Styrofoam cups, the paper constructs a mathematical model and explores it through simulations, all in Excel (prior experience unnecessary). This paper connects...
Provided by Prince George's Community College
-
White Papers
Methodologies for Converting Microsoft Excel Spreadsheets to SAS Datasets
Sep 2008
SAS version 9 offers many new features to handle the conversions from SAS to Excel and back again. Excel is often used as a data entry vehicle, thus making these conversions to SAS necessary. The...
Provided by SAS Institute
-
White Papers
Customized Excel Output Using the Excel Libname
Jul 2008
The advent of the ODS ExcelXP tagset and its many features has afforded the SAS user great flexibility in creating publishable Excel output. But what if the report must be delivered by populating...
Provided by Stratia Consulting
-
White Papers
Tying It Together: Using ODS to Insert EXCEL Hyperlinks
Dec 2008
A common task in report development is to generate EXCEL spreadsheets that have logical links between the various worksheets. Quite often, it's desirable to insert hyperlinks in selected cells to...
Provided by Regions Financial
-
White Papers
Making Microsoft Excel Accessible: Multimodal Presentation of Charts
Oct 2009
Several solutions, based on aural and haptic feedback, have been developed to enable access to complex on-line information for people with visual impairments. Nevertheless, there are several...
Provided by Association for Computing Machinery
-
White Papers
Requirements for 21st Century Spreadsheets
Oct 2009
What's one way to destroy a finance department's productivity? Get rid of spreadsheets. Or one way to immediately improve the finance department's productivity? Get rid of spreadsheets. This is...
Provided by Ventana Research
-
Whitepapers
Spreadsheet-Based Planning in Today's Economy: Why You're Up Against the Wall
May 2009
Spreadsheets are useful tools in many aspects of business, but they cannot support today's complicated enterprise planning needs because they: are prone to data errors, cannot handle the complex...
Provided by IBM
-
Case Studies
IT Solutions Provider Produces Reports 20 Percent Faster With Microsoft Office 2010
Mar 2010
Heartland Technology Solutions (HTS) aims to help customers boost productivity by transforming complex processes into simple, straightforward solutions that align with customer needs. A Microsoft...
Provided by Microsoft
-
Case Studies
Consultancy Creates Office Business Applications for Efficient Process Integration
Jul 2009
Tahoe Partners helps customers better integrate and execute business processes with Office Business Applications (OBAs) by connecting enterprise data with the familiar user interface and...
Provided by Microsoft
-
White Papers
Traffic Lighting Your Multi-Sheet Microsoft Excel Workbooks the Easy Way With SAS
Mar 2010
"Traffic lighting" is the process of applying visual formatting to data. This paper explains how to use Base SAS9 software to create multi-sheet Microsoft Excel workbooks (for Excel versions 2002...
Provided by SAS Institute
-
White Papers
Creating Highly Customized, Binary Excel Workbooks Using XML
Mar 2010
This paper will illustrate a new method for generating binary Excel workbooks using SAS data. It will illustrate how one can go beyond ODS, proc export, Access engines, etc. to make...
Provided by SAS Institute
-
White Papers
A VB.NET Utility to Transfer Multiple Data Files Between SAS and Microsoft Access/Excel by Automatically Generating SAS Import/Export Statements
Apr 2010
A VB.NET utility was developed to automate the process of converting data files between SAS and Microsoft Access or Microsoft Excel using point-and-click in the Windows environment. It saves time...
Provided by SAS Institute
-
White Papers
ODS ExcelXP: Tag Attr Is It! Using and Understanding the TAGATTR= Style Attribute With the ExcelXP Tagset
Mar 2010
The ODS ExcelXP tagset has many options to change its behavior. Many are set with the options in the ODS statement. There are others that must be set through the style. Most of these are set in...
Provided by SAS Institute
-
White Papers
Choosing the Right Tool From Your SAS and Microsoft Excel Tool Belt
Mar 2010
There are over a dozen ways to bring the data into SAS from Microsoft Excel or to push it out from SAS to Excel. Some are simple wizards, and others are more complex programming techniques. How...
Provided by SAS Institute
-
Webcasts
Microsoft Office System Webcast: Tips and Tricks for Outlook 2007 and Office 2010 (Level 100)
Apr 2010
The attendee will learn about new features and timesavers to help in the day-to-day work. This webcast is good for beginner and intermediate users. The presenter will also include a look at some...
Provided by Microsoft
-
Webcasts
Microsoft Webcast: What's New in Office 2010? (Level 100)
Apr 2010
This webcast provides an overview of the Microsoft Office 2010 client software and Office Web applications, and the presenter discusses the exciting new features in Office 2010.
Provided by Microsoft
-
White Papers
Work in Progress - SpreadSheet Implementation Programming Project Course
Oct 2008
Development of a course and textbook focusing on implementation of a spreadsheet program is proposed. The semester-long course will be suitable as a senior elective or graduate course for students...
Provided by Institute of Electrical and Electronics Engineers
-
White Papers
Spreadsheet Issues: Pitfalls, Best Practices, and Practical Tips
Feb 2010
Spreadsheets are one of the largest workhorses in actuarial work and business work in general, but few of them have serious, rigorous training in their use and design. The author usually picks up...
Provided by Society of Actuaries
-
White Papers
Assessment of Spreadsheet and Database Skills in the Undergraduate Student
Jun 2009
What makes a student computer literate? Since spreadsheets and databases are used in many applications, across many platforms, minimal skills in these areas are often seen as components of...
Provided by Association of Information Technology Professionals (AITP)
-
Case Studies
Colonial Properties Expedites Financial Reporting Process With IBM Cognos TM1 and Revelwood Report Manager
Aug 2009
Colonial Properties wanted to develop a coordinated system for generating financial reports from multiple, disparate sources. An IBM Cognos TM1 system that moved Colonial Properties from a...
Provided by IBM
-
Case Studies
Shipper Boosts Productivity, Gets Better Data Insights Faster With Software Upgrade
Mar 2010
Ever wonder how cotton from the southern United States makes it to the interior of Turkey? It is likely shipped by Mediterranean Shipping Company, the second-largest shipper in the world. With so...
Provided by Microsoft
-
Case Studies
Business Solution Provider Ensures Rich User Experience for Report and Data-Mining Tool
May 2010
Datawatch needed to ensure that Monarch Pro would integrate well with Microsoft Excel 2010 when that upgrade became available. The company wanted to evaluate the new features and begin planning as...
Provided by Microsoft
-
Case Studies
BI Firm Achieves Significant Cost Savings for Customers With New Spreadsheet Software
May 2010
German business intelligence firm pmOne had made Microsoft Office Excel 2007 central to most of its Business Intelligence solutions. To expand opportunity in the marketplace, pmOne became an early...
Provided by Microsoft
-
White Papers
Teaching and Learning Mathematics With Interactive Spreadsheets
Jan 2010
Learning to teach mathematics at the middle and secondary levels should include many opportunities for teachers to learn how to use technology o better understand mathematics themselves and...
Provided by North Carolina State University
-
White Papers
Getting Spreadsheets to Work Better for Your Business
May 2009
In manufacturing organizations, regardless of items produced or size, one finds spreadsheets everywhere. They contain and manage recipes or bills of materials; sometimes they track the production...
Provided by Horizon International
-
White Papers
Using Spreadsheets for Solving Logic Puzzles
Jul 2008
The consequence relation and perfect usage of derivation is a necessary knowledge for layers, economists, engineers and for hundreds of other different professionals. Students in the low and mid...
Provided by Babes-Bolyai University
-
White Papers
Spreadsheet Techniques in Physics Calculations
Nov 2008
The spreadsheet is a general purpose calculation tool and has many uses in physics. In particular, it is very good for one-time data manipulation and for developing calculations which then can be...
Provided by Illinois Institute of Technology
-
White Papers
Spreadsheet Modelling for Solving Combinatorial Problems: The Vendor Selection Problem
Sep 2008
Spreadsheets have grown up and became very powerful and easy to use tools in applying analytical techniques for solving business problems. Operations managers, production managers, planners and...
Provided by European Spreadsheet Risks Interest Group
-
White Papers
Essential Spreadsheet Modeling Course for Business Students
Aug 2009
Learning the art of modeling constitutes more than exposure to models and computing solutions. The latter has evidently been the primary approach so far. Modeling is really about dealing with...
Provided by Singapore Management University
-
White Papers
Concurrently Collaborative Spreadsheets in the Chemical Engineering Classroom
Sep 2008
A project investigating the viability of a concurrently collaborative online spreadsheet to improve the effectiveness of student teams when solving chemical engineering problems is described....
Provided by University of Kentucky
-
White Papers
Using Spreadsheets for Reconciliations - An Obsolete, Risky Practice
Dec 2009
Account reconciliations are considered a critical key control for ensuring financial statement accuracy. However, they can only succeed if they are meeting their purpose: Assessing the validity,...
Provided by Financial Executives International
-
White Papers
Working With Actuate Spreadsheet Reports
Jan 2008
In a diverse and global business enterprise, corporations need a way to create, publish, and distribute reports on a regular basis. The creation, storage, and viewing of reports now occurs using...
Provided by Actuate
-
White Papers
Spreadsheet Vs. Database: Hidden Cost of a Spreadsheet Solution
Apr 2008
Today more than ever, companies employ electronic record keeping. Doing so has been a proven cost effective solution. When it comes to storing data in an electronic medium, companies have many...
Provided by Paisley Software Solutions
-
White Papers
Enhancing Web-Based Data Collection Using Excel Spreadsheets
Jan 2008
The Current Employment Statistics (CES) Survey, conducted by the Bureau of Labor Statistics (BLS), is a monthly panel survey of over 390,000 business establishments. The national CES estimates of...
Provided by U.S. Bureau of Labor Statistics
-
White Papers
Spreadsheets in Mathematics: Accessibility, Creativity, and Fun
Nov 2007
A spreadsheet, such as Microsoft Excel, provides educators with a creative tool for the study and teaching of mathematics, mathematical modeling, and mathematical visualization. It enables...
Provided by Yahoo
-
White Papers
Reducing Spreadsheet Errors
Sep 2009
Increasing computational power and memory capacity in desktop computers has resulted in access to numerical techniques previously unavailable to many users. Although computational capabilities...
Provided by United States Army
-
White Papers
Why Spreadsheets Are Inadequate for Uncertainty Analysis
Jan 2010
The importance of estimating and reporting measurement uncertainty has greatly increased over the past few years. As a result, many companies and organizations have developed, or are seriously...
Provided by Integrated Sciences Group
