ModelSheet

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.{{cite web |date=June 8, 2020 |title=Maxima: A computer Algebra System |url=https://maxima.sourceforge.io/ }}{{primary source inline|date=February 2024}} 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.{{cite web

| url = http://www.prweb.com/releases/modelsheet/customized-spreadsheets/prweb4659294.htm

| archive-url = https://web.archive.org/web/20101022143744/http://www.prweb.com/releases/modelsheet/customized-spreadsheets/prweb4659294.htm

| url-status = dead

| archive-date = October 22, 2010

| title = ModelSheet Launches the Spreadsheet Customizer - Create Professional Spreadsheets that Meet your Needs, Quickly and Easily

| publisher = PR Web

}}{{primary source inline|date=July 2021}}

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.{{cite web

| url = http://blogs.msdn.com/b/excel/archive/2010/10/08/extending-excel-174-to-build-models-for-you.aspx

| title = Extending Excel to Build Models for You

| publisher = Microsoft Corporation

| author = Diego Oppenheimer and Richard Petti

}}{{primary source inline|date=July 2021}}{{cite web

| url = http://www.modelsheetsoft.com/doc/WhitePaper_CustTemplates.pdf

| title = Customized Spreadsheet Solutions – The Promise of Templates Fulfilled

| publisher = PRWeb

| author = Richard Petti and Howard Cannon

}}{{primary source inline|date=July 2021}}

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.{{cite web

| url = http://office.microsoft.com/en-us/templates/CT010290111.aspx

| title = ModelSheet Software - Templates

| publisher = Microsoft Corporation

}} Users can download the Custom Spreadsheet Solutions as Excel workbooks, or upload them to an account on Google Docs.{{cite web

| url = http://www.prweb.com/releases/modelsheet/google-spreadsheets/prweb5205484.htm

| archive-url = https://web.archive.org/web/20110401071055/http://www.prweb.com/releases/modelsheet/google-spreadsheets/prweb5205484.htm

| url-status = dead

| archive-date = April 1, 2011

| title = Getting Started With Spreadsheets on Google Docs Just Got Easier

| publisher = ModelSheet Software

}}{{primary source inline|date=July 2021}}{{cite web

| url = http://www.ubergizmo.com/2011/03/modelsheet-spreadsheet-customizer-google-docs/

| title = ModelSheet Spreadsheet Customizer now works with Google Docs

| author = George Wong

| publisher = übergizmo

| access-date = 2011-06-21

| archive-url = https://web.archive.org/web/20110403040557/http://www.ubergizmo.com/2011/03/modelsheet-spreadsheet-customizer-google-docs/

| archive-date = 2011-04-03

| url-status = dead

}}

The ModelSheet Authoring Environment has all the functionality needed to build spreadsheet models from scratch and edit existing models.{{cite web

| url = http://www.modelsheetsoft.com/doc/Whitepaper_AuthoringIntro.pdf

| title = The ModelSheet Authoring Environment for Spreadsheet Models

| publisher = ModelSheet Software

| author = Richard Petti and Howard Cannon

}}{{primary source inline|date=July 2021}} 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,{{cite web

| url = https://www.zdnet.com/article/modelsheet-good-in-theory-needs-more-work/

| title = ModelSheet: good in theory, needs more work

| author = Dennis Howlett

| publisher = ZD Net

| date = 2008-08-20

| access-date = 2010-11-20

}} 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."

• Macsyma (for information on founders' earlier work together there)
• Microsoft Excel
• Spreadsheet
• End-user development
• Business Analytics
• Business Intelligence
• Business Intelligence 2.0

{{Reflist|2}}

• http://www.manta.com/c/mtbr350/modelsheet-software-llc
• {{usurped|1=[https://web.archive.org/web/20100112164104/http://venturebeatprofiles.com/company/profile/modelsheet-software Article title]}}

• [http://modelsheetsoft.com Official web site]

{{DEFAULTSORT:Modelsheet}}

Category:Software companies based in Massachusetts

Category:American companies established in 2007

Category:Defunct software companies of the United States