1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Google Spreadsheets

Discussion in 'BlackHat Lounge' started by ORJay, Mar 12, 2015.

  1. ORJay

    ORJay Regular Member

    Joined:
    Aug 4, 2013
    Messages:
    291
    Likes Received:
    117
    Location:
    Mumbai
    Sorry Can't find a suitable section. Had to post in Lounge

    I'm looking for a tool that can pull data from daily updated Google spreadsheets and can do some statistical analysis.

    Is there any tool out there that can do the above?

    I need a "dashboard" to visualisethe results of statistical analysis done too all autopilot, kind a web app, but a pc software is also fine
     
    Last edited: Mar 12, 2015
  2. TeKn1qu3z

    TeKn1qu3z Jr. VIP Jr. VIP Premium Member

    Joined:
    Jul 26, 2012
    Messages:
    904
    Likes Received:
    227
    Occupation:
    Amazon FBA Guru
    Location:
    The Office
    If there are more people to se such type of data, then their would be a free one. I could suggest to you to hire someone for building tool.

    Can't you analyze the data on Google spreadsheets directly?
     
    • Thanks Thanks x 1
  3. ORJay

    ORJay Regular Member

    Joined:
    Aug 4, 2013
    Messages:
    291
    Likes Received:
    117
    Location:
    Mumbai
    I can manually do that, but the data is continuously updated, so have to do the analysis continuously( Can any Automation tool help with that? spreadsheets to IFTTT and so on).

    I'm looking for a web app like google analytics, for analysing spreadsheet data
     
  4. TeKn1qu3z

    TeKn1qu3z Jr. VIP Jr. VIP Premium Member

    Joined:
    Jul 26, 2012
    Messages:
    904
    Likes Received:
    227
    Occupation:
    Amazon FBA Guru
    Location:
    The Office
    There are some formulas in Microsoft excel, so the page will get updated by just a click. I think it will be easier to make a script and load where you want to publish it.
     
  5. ChanzGrande

    ChanzGrande Elite Member

    Joined:
    Feb 16, 2008
    Messages:
    2,484
    Likes Received:
    1,172
    Occupation:
    Accountant
    Location:
    Northern Woods Counting Money
    You may be able to find a way to use yahoo pipes to parse your data. It's difficult say without knowing exactly how you want to manipulate the data. I can say I find pipes to quite versatile despite it's simplicity. If you add in the YQL modules you can accomplish a lot of functions that seem outside the scope of pipes at first. That said, it might be a challenge to figure out how to accomplish your specific analysis, but at least it would be free.

    Alternatively I'm sure you can find much better solutions, especially if you are willing to pay.
     
    • Thanks Thanks x 1
  6. ORJay

    ORJay Regular Member

    Joined:
    Aug 4, 2013
    Messages:
    291
    Likes Received:
    117
    Location:
    Mumbai
    Any other insights?