Go Back  PPRuNe Forums > Flight Deck Forums > Tech Log
Reload this Page >

Spreadsheet to Web Application Conversion

Wikiposts
Search
Tech Log The very best in practical technical discussion on the web

Spreadsheet to Web Application Conversion

Thread Tools
 
Search this Thread
 
Old 5th Feb 2020, 10:47
  #1 (permalink)  
Thread Starter
 
Join Date: May 2009
Location: Home
Posts: 63
Likes: 0
Received 0 Likes on 0 Posts
Spreadsheet to Web Application Conversion

This is a spreadsheet for weight and balance on the 737-800.
Can anyone suggest how to convert to web application?

Dadanawa is offline  
Old 5th Feb 2020, 20:49
  #2 (permalink)  
 
Join Date: Nov 2000
Location: Pewsey, UK
Posts: 1,976
Received 12 Likes on 6 Posts
drive.google.com
The Nr Fairy is offline  
Old 15th Feb 2020, 10:06
  #3 (permalink)  
Thread Starter
 
Join Date: May 2009
Location: Home
Posts: 63
Likes: 0
Received 0 Likes on 0 Posts
It’s a Numbers for IOS spreadsheet. Can this be transferred to Google drive ?
Dadanawa is offline  
Old 15th Feb 2020, 13:36
  #4 (permalink)  
 
Join Date: Oct 2007
Location: Here
Posts: 962
Received 3 Likes on 2 Posts
I can't really help however I notice :-

Search - [numbers to excel]
basically on MAC saveas Excel

Search - [excel to web page]

https://www.spreadsheetconverter.com/

jimjim1 is offline  
Old 15th Feb 2020, 14:34
  #5 (permalink)  
 
Join Date: Nov 2014
Location: IL, USA
Posts: 11
Likes: 0
Received 0 Likes on 0 Posts
Numbers on iPad has Export option

You can export to Excel format, and then import that into Google Sheets.

It will take some tweaking but when done Google Sheets version should be really handy, easy to share, etc.
sansmoteur is offline  
Old 16th Feb 2020, 09:23
  #6 (permalink)  
Thread Starter
 
Join Date: May 2009
Location: Home
Posts: 63
Likes: 0
Received 0 Likes on 0 Posts
Thanks all.

The problem with converting to Excel is that the worksheet will lose some of its functionality.

For example; Numbers allows multiple Tables in a single worksheet. Each can be re-sized and moved to any convenient location within the worksheet. This is not possible with Excel.

In the example below I have moved the position of a separate Table (indicated by red arrow).

Even though Excel has many more functions and formulas, Numbers appears to offer more flexibility and options regarding the way the information is presented. The problem with Numbers is not being able to password protect cells containing formulas.

So to have a worksheet like this, I might have to get involved with ios application programming.


Dadanawa is offline  
Old 16th Feb 2020, 15:26
  #7 (permalink)  
 
Join Date: May 2001
Location: England
Posts: 1,904
Likes: 0
Received 0 Likes on 0 Posts
You're using a very app specific spreadsheet, the app does not have a web engine right? So the only thing you can do is give it over to a Freelance PHP or ASP.NET developer and tell him to engineer a like for like web site.
Superpilot is offline  
Old 17th Feb 2020, 15:02
  #8 (permalink)  
 
Join Date: Mar 2006
Location: USA ex-pat
Age: 62
Posts: 55
Likes: 0
Received 0 Likes on 0 Posts
As Superpilot said this is bespoke development although there may be some existing apps out there which will allow you to configure an individual aircraft.

From a web perspective it can easily be done in any number of frameworks including responsive design for laptop/tablet/mobile. This is one I did for my personal use as a little side project in HTML/Javascript/PHP which hopefully gives you an idea of what's possible. I wanted to be able to quickly drag and drop different pieces of gear on to the outline and then just add weights to calculate a CG envelope diagram and raw data. All the other graphics etc are pretty straight forward. Hybrid apps and responsive frameworks mean you don't even need specific ios or android programming skills (swift or java). In terms of porting to excel, that's possible as well but probably would require some vba support to provide all functionality.



crunchingnumbers is offline  
Old 18th Feb 2020, 01:43
  #9 (permalink)  
Thread Starter
 
Join Date: May 2009
Location: Home
Posts: 63
Likes: 0
Received 0 Likes on 0 Posts
“Superpilot” and “crunchingnumbers”, your insights have been helpful. I’m looking into PHP now. Thanks.
Dadanawa is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service

Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.