Tag - Spreadsheet
We used to think it was an Excel thing that other people would forget it was a spreadsheet and instead use it as a kind of rudimentary database where they listed text in the columns instead of numbers. Now we have to face the fact that it isn't other people who do this, it's us –– and we're doing it all over again in Apple's Numbers. We know we're wasting its strengths, we know, but it's handy and there is a way to both speed it up and to make us feel like we're fine not going off to create databases all the time. You can use popup forms in Numbers.
You've got a spreadsheet or a word processing document that you use to dump information into. Maybe research text you've copied from Wikipedia and pasted in with everything else you've found on the same topic. Maybe it's a spreadsheet with expenditure, notes, half-worked out sums. We all have messy documents like these, and they're fine -- until you have to send them to someone else. Or so you think. We want to argue that it isn't fine. That the fact you would clean it all up to help someone else understand your work is exactly the reason you should clean it up for yourself. We just also want you to clean it up with Microsoft's Format Painter.
Apple's Numbers spreadsheet is not Microsoft Excel. To be frank, it's not as good as Excel but that's not why we say it: Numbers is a first-class application, but people tend to think of it as an Excel clone -- and that misses the point a little. Instead, Numbers is a different approach to solving the same problems and giving the same tools as Excel. You'll get more from it if you don't think of how Excel would do something. You'll also get more from it by using the many little touches that Numbers has but, in typical Apple fashion, are not forced down your throat.
To the people who don't use or need data-mining, data-modelling or prediction software, it can seem pretty dull -- the province of scientists or IT experts. The truth, however, is that such software has significant real-world implications both theoretical and practical, as evidenced by KnowledgeMiner's self-titled software for data analysis in Microsoft's Excel spreadsheet application. In addition to announcing an update to v2.4 that splits the product into single-processor and multi-processor versions, the company has highlighted a case study where the use of KnowledgeMiner (yX)'s ability to reveal trends and patterns is actually saving the lives of thousands of animals formerly used for chemical testing in the European Union.
Mariner Software has released Mariner Calc, a spreadsheet application for the iPhone and iPod touch that enables users to view and edit Microsoft Excel files. The program provides a number of functions, with categories including math, finance, trigonometry, statistic, and lookup. The document dates, content or plus-logic information can also be edited, with support for splitting panes, freezing, border creation, font and color customization, or alignment. Users can view documents in either portrait or landscape mode.
Effigent on Thursday unveiled PowerEasy Distribution for Mac, offering users a suite of modules for tracking, managing, and replenishing inventory levels, as well as overseeing the distribution cycle from purchasing and stocking, to sales. Users are able to process sales and purchase orders, manage inventory, and create visual charts for company progress, which can be shared across networks, or interface with spreadsheet, analysis or presentation software.
ProVUE Development recently unveiled Panorama 5.5, a new version to its high performance RAM-based database program. The new version brings a bevy of new features, such as the Enhanced Live Clairvoyance search wizard, which allows users to search through bookmarks and formulas, in a style similar to that of Spotlight. Panorama can now interface directly with Microsoft Excel spreadsheets, as well as Quicken QIF, OFX, and QFX formats, enabling the application to directly exchange data with the databases. New users can purchase Panorama 5.5 for $300, directly from ProVUE's web site.