PDA

View Full Version : Spreadsheet to Web Application Conversion


Dadanawa
5th Feb 2020, 10:47
This is a spreadsheet for weight and balance on the 737-800.
Can anyone suggest how to convert to web application?
https://cimg7.ibsrv.net/gimg/pprune.org-vbulletin/1184x1518/635791d9_81f0_49f6_863a_06196eb2a860_aa89ec079f8d4549e17b912 59790d30c334d9db6.jpeg

The Nr Fairy
5th Feb 2020, 20:49
drive.google.com

Dadanawa
15th Feb 2020, 10:06
It’s a Numbers for IOS spreadsheet. Can this be transferred to Google drive ?

jimjim1
15th Feb 2020, 13:36
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/

sansmoteur
15th Feb 2020, 14:34
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.

Dadanawa
16th Feb 2020, 09:23
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.

https://cimg0.ibsrv.net/gimg/pprune.org-vbulletin/1500x2000/f101d6df_57b2_49a4_9add_210c65b65553_8bc8bc24b379f642aa6f7d9 f245f83c851aaa1c8.jpeg

Superpilot
16th Feb 2020, 15:26
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.

crunchingnumbers
17th Feb 2020, 15:02
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.

https://cimg6.ibsrv.net/gimg/pprune.org-vbulletin/588x1151/w_b_web_example_92aa7b499f82dfb1a61a95439e1a5c0ea938e9fa.png

Dadanawa
18th Feb 2020, 01:43
“Superpilot” and “crunchingnumbers”, your insights have been helpful. I’m looking into PHP now. Thanks.