Jump to content

Sign in to follow this  
Guest

Flightplans and Excel

Recommended Posts

Guest

Hi all,Is there a way to transfer the contents of flightplan.txt to an Excel spreadsheet? I would like to do that in order to tweak arrival and departure times using the various functions available on excel.I've read in various places here about folks using excel.Just doing a copy and paste is no good since all the info is shoved into a single cell.Thanks!Brian

Share this post


Link to post
Share on other sites
Guest Stamatis

Try renaming Flightplans.txt to Flightplans.csv and then open the renamed file with Excel. It should work.Stamatis

Share this post


Link to post
Share on other sites

Hi BrianYes the .csv and .txt works just fine.I do all my amendments by using excel. I usually just open the flightplans.txt in excel and excel identifies the format, just click on comma delineated and all opens smoothly.Save it all as .csv. Close excel and simply rename the file as .txt instead of .csvCheersMike

Share this post


Link to post
Share on other sites

Hi Brian:I'm an EXCEL geek too ;-)Two caveats: 1) Very long flightplans may not load as the exceed the max. number of columns allowd in EXCEL. Don't know a workaround for that; I edit those plans in Word.2) I your flightplans have different lengths (# of columns), you'll need to weed out extra commas after saving as .csv and renaming to .txt. I do that by loading the file into Word or Wordpad and then running a Replace of ",,," (three commas) with "" (nothing). That does the trick.Cheers, Holger

Share this post


Link to post
Share on other sites
Guest Captain Barfbag

I've never upgraded Excel beyond my original version 5.0, which generally works fine for my needs. However, it will not do a complete flightplan file because that version is limited to 16K lines. The newer versions will go up to 64K lines, which should suffice unless you've almost tripled your flight plans. Be aware, though, if you're using the older version. I don't remember that it told me it was truncating the data.

Share this post


Link to post
Share on other sites
Guest

Thanks everybody, for the great advice. I'm really getting into the whole AI thing and this makes it alot easier to sort things out.Cheers!Brian

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...