 | This article has multiple issues. Please help improve it or discuss these issues on the talk page . (Learn how and when to remove these messages)
|
 | |
| Company type | Private |
|---|---|
| Industry | Business intelligence, business analytics |
| Founded | 2007 |
| Headquarters | Arlington, Massachusetts |
Key people | Richard Petti, Howard Cannon |
| Website | http://www.modelsheetsoft.com/ |
ModelSheet Software LLC is a venture-funded software company focused on business analytics and based in Arlington, Massachusetts.
ModelSheet was founded by two MIT graduates, Richard Petti and Howard Cannon, who earlier worked together at Symbolics and later in the division spun out as Macsyma. [1] [ non-primary source needed ] After the Macsyma episode in the 1980s and the 1990s, the pair took separate career paths, with Petti at The MathWorks, and Cannon at Groton NeoChem and SciQuest, and then merged their companies to found ModelSheet in 2007. [2] [ non-primary source needed ]
ModelSheet Software was founded to put more desktop modeling power in the hands of business experts without requiring them to become programmers. The spreadsheet is the classic example of such an end-user development tool, but its cell-based paradigm has its limitations. ModelSheet technology attempts to addresses these limitations with two types of products: Custom Spreadsheet Solutions, and the ModelSheet Authoring Environment.
By filling in a simple form, a Custom Spreadsheet Solution yields a custom spreadsheet workbook, without users having to edit spreadsheets or cell formulas. Users can set three aspects of spreadsheet models: time series (time range, time grains, and rollup grains), dimensions (e.g. a list of products organized in product families) and turning on or off model features. [3] [ non-primary source needed ] [4] [ non-primary source needed ]
ModelSheet offers Custom Spreadsheet Solutions for many common business tasks in corporate finance (financial plans, cash flow analysis, cap tables, activity-based budgets, etc.), marketing and sales analysis (sales plans, marketing program effectiveness, price elasticity, etc.) and other areas. [5] Users can download the Custom Spreadsheet Solutions as Excel workbooks, or upload them to an account on Google Docs. [6] [ non-primary source needed ] [7]
The ModelSheet Authoring Environment has all the functionality needed to build spreadsheet models from scratch and edit existing models. [8] [ non-primary source needed ] It retains the graphical representation of spreadsheets, while adding in model structures such as named variables, symbolic formulas with varying scopes, time series, dimensions, and controls for optional features and automated operations. ModelSheet Authoring is the technical backend of Custom Spreadsheets. For intermediate applications (where more flexibility is needed, but the customer doesn't require frequent use of the Authoring Environment itself) ModelSheet offers consulting services in which a ModelSheet engineer uses the Authoring Environment to create a spreadsheet to the customer's specification.
Testing a pre-beta version in 2008, [9] journalist Dennis Howlett of ZDNet concluded that ModelSheet was "good in theory" but "needs more work." Howlett criticised several aspects: Windows-only platform support, bugs, poor usability, choice of fonts, and dull quick start guide. Although "bemused" by the product, Howlett did concede, "ModelSheet is at an early stage of development, and I'm sure [it] will improve over time."
Microsoft Excel is a spreadsheet editor developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft 365 and Microsoft Office suites of software and has been developed since 1985.
A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. The term spreadsheet may also refer to one such electronic document.
Lotus Improv is a discontinued spreadsheet program from Lotus Development released in 1991 for the NeXTSTEP platform and then for Windows 3.1 in 1993. Development was put on hiatus in 1994 after slow sales on the Windows platform, and officially ended in April 1996 after Lotus was purchased by IBM.
Macsyma is one of the oldest general-purpose computer algebra systems still in wide use. It was originally developed from 1968 to 1982 at MIT's Project MAC.
Microsoft Works is a discontinued productivity software suite developed by Microsoft and sold from 1987 to 2009. Its core functionality includes a word processor, a spreadsheet and a database management system. Later versions have a calendar application and a dictionary while older releases include a terminal emulator. Works is available as a standalone program and as part of a namesake home productivity suite. Because of its low cost, companies frequently preinstalled Works on their low-cost machines. Works is smaller, less expensive, and has fewer features than contemporary major office suites such as Microsoft Office.
Wingz was a spreadsheet program sold by Informix in the late 1980s and early 1990s. Originally developed for the Macintosh, it was later ported to Microsoft Windows, OS/2, NeXTSTEP and several other commercial flavors of Unix. In spite of many positive reviews, including one calling it "clearly the spreadsheet of the future", the market was rapidly entrenching Microsoft Excel. Informix eventually gave up on the desktop market and reverted solely to database sales in the mid-1990s. Claris licensed and sold an extensively cleaned up version as Claris Resolve in 1991, but it was far too late to market to have any effect.
Custom software is software that is developed specifically for some specific organization or other user. As such, it can be contrasted with the use of out-of-the-box software packages developed for the mass market, such as commercial off-the-shelf software, or existing free software.
A collaborative real-time editor is a type of collaborative software or web application which enables real-time collaborative editing, simultaneous editing, or live editing of the same digital document, computer file or cloud-stored data – such as an online spreadsheet, word processing document, database or presentation – at the same time by different users on different computers or mobile devices, with automatic and nearly instantaneous merging of their edits.
IBM Planning Analytics powered by TM1 is a business performance management software suite designed to implement collaborative planning, budgeting and forecasting solutions, interactive "what-if" analyses, as well as analytical and reporting applications.
Google Workspace is a collection of cloud computing, productivity and collaboration tools, software and products developed and marketed by Google. It consists of Gmail, Contacts, Calendar, Meet and Chat for communication; Drive for storage; and the Google Docs Editors suite for content creation. An Admin Panel is provided for managing users and services. Depending on edition Google Workspace may also include the digital interactive whiteboard Jamboard and an option to purchase add-ons such as the telephony service Voice.
Numbers is a spreadsheet application developed by Apple Inc. as part of the iWork productivity suite alongside Keynote and Pages. Numbers is available for iOS and macOS High Sierra or newer. Numbers 1.0 on Mac OS X was announced on August 7, 2007, making it the newest application in the iWork suite. The iPad version was released on January 27, 2010. The app was later updated to support iPhone and iPod Touch.
F9 is a financial reporting software application that dynamically links general ledger data to Microsoft Excel through the use of financial cell-based formulas, wizards, and analysis tools to create spreadsheet reports that can be calculated, filtered, and drilled upon. The F9 software is developed, marketed, and support by an organization also called F9, a division of Infor Global Solutions (Canada) Ltd. which is headquartered in Vancouver, British Columbia.
XLeratorDB is a suite of database function libraries that enable Microsoft SQL Server to perform a wide range of additional (non-native) business intelligence and ad hoc analytics. The libraries, which are embedded and run centrally on the database, include more than 450 individual functions similar to those found in Microsoft Excel spreadsheets. The individual functions are grouped and sold as six separate libraries based on usage: finance, statistics, math, engineering, unit conversions and strings. WestClinTech, the company that developed XLeratorDB, claims it is "the first commercial function package add-in for Microsoft SQL Server."
FarPoint Spread is a suite of Microsoft Excel-compatible spreadsheet components available for .NET, COM, and Microsoft BizTalk Server. Software developers use the components to embed Microsoft Excel-compatible spreadsheet features into their applications, such as importing and exporting Microsoft Excel files, displaying, modifying, analyzing, and visualizing data. Spread components handle spreadsheet data at the cell, row, column, or worksheet level.
Synex Systems Corporation, a subsidiary of Synex International Inc., was formed in 1983 in an effort to develop software for the microcomputer market and was run by Synex International Vice President Murray Hendren until 1992. In 2002, Synex Systems was acquired by privately owned Lasata Software of Perth, Australia. In 2005, Lasata was acquired by UK based Systems Union. In 2007, Systems Union was acquired by privately held Infor Global Solutions, a U.S. company that specializes in enterprise software.
RCA Open-Source Application (ROSA) is an open-source management accounting application that aims to provide decision-support information to managers. Resource consumption accounting (RCA) is a principle-based approach to management accounting that combines German management accounting techniques known as Grenzplankostenrechnung (GPK) with a disciplined form of activity-based costing.
Microsoft Office password protection is a security feature that allows Microsoft Office documents to be protected with a user-provided password.
Microsoft Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence (BI). It is part of the Microsoft Power Platform. Power BI is a collection of software services, apps, and connectors that work together to turn various sources of data into static and interactive data visualizations. Data may be input by reading directly from a database, webpage, PDF, or structured files such as spreadsheets, CSV, XML, JSON, XLSX, and SharePoint.
AppSheet is a no-code development platform for application software, which allows users to create mobile, tablet, and web applications. It allows using data sources like Google Drive, DropBox, Office 365, and other cloud-based spreadsheet and database platforms. AppSheet can be utilized for a broad set of business use cases including project management, customer relationship management, field inspections, and personalized reporting. AppSheet was acquired by Google in January 2020.
Microsoft Power Platform is a collection of low-code development tools that allows users to build custom business applications, automate workflows, and analyze data. It also offers integration with GitHub, Microsoft Azure, Microsoft Dynamics 365, and Microsoft Teams, amongst other Microsoft and third-party applications.