PPRuNe Forums

PPRuNe Forums (https://www.pprune.org/)
-   Tech Log (https://www.pprune.org/tech-log-15/)
-   -   Spreadsheet to Web Application Conversion (https://www.pprune.org/tech-log/629444-spreadsheet-web-application-conversion.html)

Dadanawa 5th Feb 2020 10:47

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?
https://cimg7.ibsrv.net/gimg/pprune....c334d9db6.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

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.

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....851aaa1c8.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....0ea938e9fa.png


Dadanawa 18th Feb 2020 01:43

“Superpilot” and “crunchingnumbers”, your insights have been helpful. I’m looking into PHP now. Thanks.


All times are GMT. The time now is 14:38.


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