(elevator trim setting and reduced takeoff thrust are the main additions)Hi team,This Excel spreadsheet is a new version based on Rob van Leest's one, which I think is the most popular amongst PICers. I always wanted to have the ELEV trim setting calculated for me as well as to be able to use RTOT (reduced takeoff thrust) without it being purely a guesswork. I also wanted results in *METRIC* system.So here is a sample of what I'll be releasing in a few days, depending on the progress of our beta testing.Selected shots of input area of the sheet------------------------------------------RTOThttp://planeta.terra.com.br/educacao/wagne...kow/fs/rtot.jpgELEV TRIMhttp://planeta.terra.com.br/educacao/wagne...fs/trim_rwy.jpgPrintable Output-----------------Release sheethttp://planeta.terra.com.br/educacao/wagne...dispatchrls.pdfCouldn't make this work here. Copy URL above and paste it into a new browser window. Actual printout's dotted lines are not that thick and look more dot matrix printerish as intended.TKOF CARDhttp://planeta.terra.com.br/educacao/wagne...fs/tkofcard.jpgLNDG CARDhttp://planeta.terra.com.br/educacao/wagne.../fs/lndcard.jpgThe sheet will also provide fairly detailed weight and fuel calculations.This is certainly a step forward but it's not meant to be perfect, so be warned. Though I have some knowledge of the subject, I'm not a dispatcher nor a real 763 pilot...At this stage I just want to get this shipped so you folks can use it (no point keeping that to myself, though I made if for me) and if improvements become necessary I will encourage others to follow it up.Stay tuned.Wagner

Wagner,Great job! Look forward to using it.Tried my hand at the trim settings a long time ago, but my Excel knowledge wasn't enough to make it work. Kind regards,Stephan Haas

Thanks Stephan. Are you able to see the shots above? From my home PC it was ok, now at work it won

Looks great! adds everything I needed and was too lazy to add myself...Realy looking forward to having it!Ilan

Wagner,All the pictures are showing without any extra help.Kind regards,Stephan Haas

Hey Wagner, i also needed to paste them into a new window...but that's fine enough with me.Can't wait for your sheet :)Thanks alotCheers

Guys,I have recently come into posession of an AHM50 for the 767-300.What you might ask is this?Only the document that airlines and Boeing issue, that contains all the data for computerised weight and balance. Maybe at some stage I will get round to starting to dissimilate the information fromthis doc.Mark

Great notice a greats screenshots!Only a minor question: Can the spreadsheet reproduce the ETP calculations for a ETOPS flight?Thanks for your's work. I'm awaiting the release.Regards,Jose M. Barruezo

Hola Jos

Hola, Wagner.Well, if you wish, we can talk about this question. I have some graphics calculations and I hope that we can obtain some useful ideas.Thanks again.Saludos desde Espa

hiwhere I can find this Utility ?thx

He writes:>So here is a sample of what I'll be releasing in a few days, depending on the progress of our beta testing.Hope that helps ;)SamCX110

Hi Wagner,Any news about the release?It looks great and i'm still waiting...Thanks,Ilan

Hi Ilan,We are qetting there and by there I mean to something "releasable" coz it ain't goona be free of problems or the ultimate thing. It's just something better than what is available at the moment. That's all.Since my first message above the follwoing has been implemented:. Fixed YSSY in the airport database.. Added helpful notes everywhere.. Now wind component for trip and alternate fuel is calculated rather than asked.. Several useful weather links are provided on the spot.. Added checks to verify if wind limits are not exceeded on landing for each type of landing.. More cosmetic improvements.. Created a desktop icon.. Added FLP15-5 speed retraction, TODR, and MAX N1 on TKOF CARD.. Fixed TODR error when TODR was > TODA.. Rectified several error check routines.. Now "NOT READY!" message will show up in red on the DISP RLS and cards if an unacceptable error (e.g. MTOW exceeded) has not been corrected.. Added a check and warning routine for TKOF X-WND > 33 kts.. Improved logics behind TKOF thrust display calculations on the TKOF card and improved its output.. Added a check and warning when user forgets to select a DEP/DEST RWY.. Added a check and warning when planned fuel exceeds the fuel capacity of 73,420 kg.. Created a chart depicting fuel in the tanks.. Improved fuel burnoff chart by adding a banchmark.. Created a dynamic diagram showing landing distance required x RWY landing distance available.. Added FP distance check (minimum trip to operate the Dispatcher is 250 nm).. Added check and warning when trim setting is above 7.0.. "Red light" warnings now illuminate kg cells and not only pound one on weight sheet.Stay tuned.Wagner

Well, now you made me realy impatient ;-)great effort wagner, tell me if you need any help (I teach Excel courses at couple of universities here).have a nice weekend,Ilan