You have simple lists to sort and filter.Your primary task is to analyze and manipulate data.You want to embed tables or charts in other Microsoft Office programs through technologies such as OLE (object linking and embedding) FileMaker dispensed with OLE several releases prior to 15.You need a great many options for charting (FileMaker offers a nice charting option but it is not as full-featured as Excel).You are doing scenario testing but don’t want to touch the original data that is stored in a data warehouse.You have complicated, nested calculations, especially if they aren’t applied consistently across a row or a column.The cells in a column (the equivalent of a FileMaker data field) can vary by data type or appearance, particularly on an ad hoc basis.If you present FileMaker data in the table layout mode (the equivalent of a spreadsheet view), a record is the equivalent of an Excel row with each column representing a distinct field. In comparing the two, remember that the equivalent of a cell in an Excel spreadsheet is a single incidence of a data field for a particular record. Another is output – you can force Excel to mimic (or be exported to or embedded in) a great many presentations types but FileMaker’s layout capabilities can produce alternatives to the spreadsheet mode more rapidly and more reliably. One deal breaker is timeframe – setting up a simple data table that you will use once for a quick analysis or presentation and then never touch again is faster in Excel. So the decision to use one or the other can seem difficult. These two tools perform many of the same functions and produce reports and other output that can appear virtually identical. 2.7 Scripting and Automating the ProcessĮxcel versus FileMaker: When Should You Use Them?.2.5 Option 5: Exporting Data from a FMP Database.2.3 Option 3: Link to ODBC data via a driver.2.2 Option 2: Create a FileMaker solution and import the Excel data.2.1 Option 1: Create a FileMaker solution directly from an Excel Spreadsheet.2 Exchanging Data between Excel and FileMaker.1 Excel versus FileMaker: When Should You Use Them?.
0 kommentar(er)
