Nexus 7 (or other tablet) and Excel

[PaulSB]

Stock taking in our business is done on a weekly basis across 8 acres of glasshouses on four different sites! Currently the stock take is made using an Asus Eee running a simple Excel spreadsheet. After taking stock on the Asus with the data entered while walking the glasshouses the spreadsheet is transferred to a desktop PC, edited and imported into Sage. Columns on the spreadsheet are titled:

Product Type - never edited
Stock Code - never edited
Description - never edited
Stock Category - filtered
Stock Quantity - data entry

In the Stock Category we apply a simple Data Filter during the stock take process. This limits the number of products viewed at any one time.

The ONLY data entry is in the column Stock Quantity using a number in the range 1 - 1000.

I have three questions:

Can I run Excel on a Nexus 7 and edit the spreadsheet with a filter on one column and data entry in another? I realise this will probably require the Office Suite Pro app but it's only few ££. I'm 99% the answer is "yes" but would like to be 100%!!

Are there other tablets I could use? It seems iPad Mini will not run Excel - not surprising really.

If I can't run Excel on a Nexus 7 can I run an Open Office spreadsheet or run Excel on another brand of tablet?

Many thanks.

PS - the only reason for changing from the Asus is weight and the screen is poor in sunlight.

 

[ELL]

Hi, I have a Samsung Galaxy S2 and the Tab 2 10.1 and both of these come with polaris office. I am not sure if you can get them on the Nexus. If you are after a smaller device they do the tab2 7 inch. Have a look at the website http://www.polarisoffice.com/en/default.asp not sure if this is the sort of thing you are after but has a couple of Excel sort of spreadsheets( I think they are proper Excel but not 100%) that seem to work in the same way. I haven't used them a lot but have sent the excel style form from my phone to computer and it truns up as a excel spreadsheet.

 

[SquareDaff]

I use a Samsung Galaxy Note 10.1. Good device but you do get a fair bit of reflection from the screen in strong sunlight. It comes with Polaris Office too

 

[Mr Haematocrit]

Excel has proprietary database formatting (which is the reason why you should not use it) it only runs on Microsoft approved devices or under emulation.
Android devices and ipod/pod devices can provide database apps but they do not have the calculation functionality of Excel.
Use a open database format or googledocs for ease imho

if you must have Excel get a Surface tab

 

[ian turner]

Quickoffice and documents to go both provide both android and ios versions which they claim can edit office documents though i'd check out their websites first (and forum in the case of quickoffice)

 

[Andrew_Culture]

I use Google Drive / Docs, you could do the same then download as Excel format perhaps?

 

[ianjmcd]

Andrew took the word out my keyboard if you going to be using a google device then you have access to google docs/drive so can use a cloud based spreadsheet app on the nexus and would not need to download anything on the office pc just use the online google spreadsheet on both and if needed it can be exported as excel spreadsheet

Bonus is that if anything happens to office pc you dont lose anything as its all in the cloud

 

[MossCommuter]

Played with this at work the other day and it's excellent! Somewhat dearer than a tablet but is truly a PC and tablet at the same time.

Almost enough to make me consider moving back to Windows

 

[PaulSB]

MC link doesn't work

 

[MossCommuter]

MC link doesn't work

Sorry

works for me

It's a link to the HP Envy X2 if you want to Google for it

 

[PaulSB]

Thanks. Looks lovely but a touch outside the budget!!

 

[ufkacbln]

The IPad runs "Numbers" which can open, work and save Excel format.

It will do most of the work that Excel can do for £14