Excel reader that supports my formula

Discussion in 'iPad General Discussions' started by Bluescan, May 10, 2012.

  1. Bluescan
    Offline

    Bluescan iPF Noob

    Joined:
    May 10, 2012
    Messages:
    4
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    USA
    Ratings:
    +0 / 0
    Hello everybody!

    My first post in this forum, so not even sure if this is the right category.
    Plase forgive me. :)

    I just bought an Ipad to use for my flight school training. It's great for reading books and maps, aswell as a reference to everything.

    I wanted to make a application to calculate some very basic stuff for me. It's mostly very basic weight and balance. Anyway, since I don't know programming very well, I decided to create a Excel spreadsheet insted. On my Windows desktop it's working perfect, but unfortunatly it seems like my Excel reader "Documents to go" do not support one of my formulas. I tried to google it, couldn't find anything helpful, but ended up on this forum a few times. :)

    I had to use a forumla that could respond with multiple values.

    My formula looks like this:
    Code:
    =INDEX($B$1:$C$47590,SMALL(IF($B$1:$B$47590=$I$3,ROW($B$1:$B$47590)),ROW(1:1)),2)
    It looks into a table with runways and airports. Every airport code (B) have multiple runways (C). If I ask for "KELZ" it should return 10 and 28.

    Thought, it looks like "SMALL" is not supported. Do anybody know a way around this problem?

    :rolleyes:

    Best regards,
    Bluescan

    Attached Files:

  2. AQ_OC
    Offline

    AQ_OC Super Moderator Staff Member

    Joined:
    Apr 28, 2011
    Messages:
    6,418
    Thanks Received:
    430
    Trophy Points:
    83
    Location:
    SC
    Ratings:
    +430 / 0
    Two options come to my mind:

    1) get Numbers and just build the forumla in that..
    2) get Onlive Desktop and run your Excel spreadsheet in that. Can't be 100% sure it will work, but that excel is supposed to BE excel. You need good WiFI to use it.

    You might be able to use CloudOn, but I have forgotten exactly what that app does (I have it installed, but it has been a while since I used it).
  3. Bluescan
    Offline

    Bluescan iPF Noob

    Joined:
    May 10, 2012
    Messages:
    4
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    USA
    Ratings:
    +0 / 0
    Thank you AQ_OC.

    It has to be offline :)

    Are you sure this will work with Numbers? I were told that Documets to Go supported most formulas compared to other Ipad spreadsheets.
  4. shornbeck
    Offline

    shornbeck iPF Noob

    Joined:
    Mar 13, 2012
    Messages:
    1
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    WV
    Ratings:
    +0 / 0





    It appears to me that Polaris Office supports the index, row, and small function. I didn't look closely at your use of these functions, but you might look at that app. It's on sale for $9.99 until May 15.
  5. AQ_OC
    Offline

    AQ_OC Super Moderator Staff Member

    Joined:
    Apr 28, 2011
    Messages:
    6,418
    Thanks Received:
    430
    Trophy Points:
    83
    Location:
    SC
    Ratings:
    +430 / 0
    No, I'm not sure at all. I should have said that. My guess is that you can modify whatever spreadsheet app you use to do the same thing. I think the other poster has a solution, but both seem to involve spending money.
  6. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,526
    Thanks Received:
    2,076
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,414 / 1
    Numbers does have the SMALL function. It returns the nth smallest value within a range (if that sounds right). All the other functions in your formula are also present, and at first glance look to be compatible.

    Since I'm not sure I understand the formula and the desired results (haven't studied it hard enough yet) I can not guarantee it will work.

    On your third post you should be able to include links. If you there is no private or sensitive data in the Excel spreadsheet (and you don't mind), go ahead and post a shared link (from DropBox or the like) and I will be happy to import it into Numbers and see if it works.

    Include any explanations on how to use the spreadsheet if you think they are needed.
  7. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,526
    Thanks Received:
    2,076
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,414 / 1
    On further examination I don't believe Numbers can do this. The use of ranges in the IF function looks unlikely to work, and I don't know of any Numbers function that will return more than one value. You'd probably have to use some kind of string creation function to manage it.

    But I'm still willing to give it a try if you like.
  8. Bluescan
    Offline

    Bluescan iPF Noob

    Joined:
    May 10, 2012
    Messages:
    4
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    USA
    Ratings:
    +0 / 0
    That would be great!
  9. Bluescan
    Offline

    Bluescan iPF Noob

    Joined:
    May 10, 2012
    Messages:
    4
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    USA
    Ratings:
    +0 / 0
    http://minus.com/m3XHHNOW4/


    On the Runway sheet, J3, 4, 5, 6, shout be returning 2, 20, 13, 31.


    The document has quite a lot of data in it. About 2mb.


    Best regards,
    Bluescan
  10. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,526
    Thanks Received:
    2,076
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,414 / 1
    Darn. Apparently the document is too big for Numbers. The import errors out with a too many cells warning.

    Sorry. Maybe someone else can give it a shot with their favorite spreadsheet app.

Share This Page

Search tags for this page
excel ipad formulas
,

excel reader for ipad

,
excel reader ipad
,
excel viewer ipad
,
formulas in excel ipad
,
ipad docs to go formula excel compatibility
,
ipad excel app supports formula
,

ipad excel formula

,
ipad excel that supports function
,
ipad support formula excel
,
numbers spreadsheet couldn't be imported too many formulas
,

numbers too many formulas

,
reading excel formulas in ipad
,
run excel formulas ipad
,
small function excel for ipad
,

spreadsheet for ipad compatible with excel

,
spreadsheet reader for ipad
,
using excel formulas in ipad
,
what is the excel reader for ipad