Good Spreadsheet app

Discussion in 'Mac Apps and Mac App Store' started by thefredelement, Dec 18, 2013.

  1. thefredelement macrumors 65816

    thefredelement

    Joined:
    Apr 10, 2012
    Location:
    New York
    #1
    I'm working on a bunch of pretty intensive spreadsheets... they're some pretty big output from a database dump (the db is pretty terminal in terms of data quality, making a traditional re-import into another database not worth the time of fixing it)

    I've been trying to use Excel and Numbers, they both seem to really choke up handling this kind of data, especially with formulas.

    I have a Mac Pro 4,1 2x 2.93 Xeons and 16GB of RAM. I need a spreadsheet program that will use this hardware and not get all choked up, any advice?

    (In MenuStats I see both Excel & Numbers don't take advantage of any of the hardware really).
     
  2. maflynn Moderator

    maflynn

    Staff Member

    Joined:
    May 3, 2009
    Location:
    Boston
    #2
    I have to say the best spreadsheet app out there is MS excel, so I'm not sure who else to recommend.

    Did you check out Libraoffice - the open source competitor to MS Office?
     
  3. Bear macrumors G3

    Joined:
    Jul 23, 2002
    Location:
    Sol III - Terra
    #3
    How big a spreadsheet are you talking about? From your comments, it almost sounds like you need a database program.

    Pretty much this, but I dount LibreOffice will be able to handle it either.

    maflynn do you think FileMaker might be an option here?
     
  4. ozaz macrumors 65816

    Joined:
    Feb 27, 2011
    Location:
    UK
    #4
    If you are able to, maybe try Excel 2013 on a Windows machine. I would imagine it can handle large spreadsheets better than Excel 2011 for Mac.
     
  5. MacUserUK macrumors member

    MacUserUK

    Joined:
    Oct 25, 2012
    #5
    Give OpenOffice.org a go

    Other than that MS have the office suite pretty wrapped up
     
  6. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #6
    I've used Excel for about the past 20 years, including extensive use of highly complex formulas and very large data sets. I've never had it "choke" unless the computer being used was not sufficient in terms of RAM or processor speed. Your Mac Pro should be more than sufficient. I couldn't recommend anything more powerful or capable than Excel.
     
  7. ApfelKuchen macrumors 68020

    Joined:
    Aug 28, 2012
    Location:
    Between the coasts
    #7
    Just to be clear -
    You exported data from a DB (XLS, CSV...??), and are trying to apply formulas to it in Excel/Numbers? If so, how did the spreadsheet behave prior to applying formulas?

    Just how many rows/records and columns/fields are involved?

    Poor-quality data can be just as much a problem for a spreadsheet as it is for a DB. You just may have to clean it up before applying the formulas.
     
  8. exegete77 macrumors 6502a

    Joined:
    Feb 12, 2008
    #8
    If Excel is choking, then you need database. Consider two alternatives from ProVue Panorama and Panorama Sheets

    When I worked full time as an analyst for a Fortune 100 company, I imported huge mainframe data on demand, and Excel (Windows) handled it very well. I used VBA code to do that. I could downloaded hundreds of thousands of data points, automatically set up for viewing data for 99 markets, with nine outlets on a 13 week view. One cell could change all 99 worksheets.

    That download and updates into Excel, then into PowerPoint took a total of 22 minutes.
     

Share This Page