Announcement

Collapse
No announcement yet.

Last 200 - Air law, RNav, Flight Planning, AGK

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Last 200 - Air law, RNav, Flight Planning, AGK

    Hello,

    For those you might be interested. Good luck for your exams!

    AGK


    211144,211143,211142,211141,211140,211139,211138,2 11137,211136,211135,211134,211133,211132,211131,21 1130,211129,211128,211127,211126,211125,211124,211 123,211122,211121,211120,211119,211118,211117,2111 16,211115,211114,211113,211112,211111,211110,21110 9,211108,211107,211106,211105,211104,211103,211102 ,211101,211100,211099,211098,211097,211096,211095, 211094,211093,211092,211091,211090,211089,211088,2 11087,211086,211085,211084,211083,211082,211081,21 1080,211079,211078,211077,211076,211075,211074,211 073,211072,211071,211070,211069,211068,211067,2110 66,211065,211064,211063,211062,211061,211060,21105 9,211058,211057,211056,211055,211054,211053,211052 ,211051,211050,211049,211048,211047,211046,211045, 211044,211043,211042,211041,211040,211039,211038,2 11037,211036,211035,211034,211033,211032,211031,21 1030,211029,211028,211027,211026,211025,211024,211 023,211022,211021,211020,211019,211018,211017,2110 16,211015,211014,211013,211012,211011,211010,21100 9,211008,211007,211006,211005,211004,211003,211002 ,211001,211000,210999,210998,210997,210996,210995, 210994,210993,210992,210991,210990,210989,210988,2 10987,210986,210985,210984,210983,210982,210981,21 0980,210979,210978,210977,210976,210975,210974,210 973,210972,210971,210970,210969,210968,210967,2109 66,210965,210964,210963,210962,210961,210960,21095 9,210958,210957,210956,210955,210954,210953,210952 ,210951,210950,210949,210948,210947,210946,210945, 210944,210943,210942,210941,210940,210939,210938,2 10937,210936,210935,210934,210933,210932,210931,21 0930,210929,210928,210927,210926,210925,210924,210 923,210922,210921,210920,210919,210918,210917,2109 16,210915,210914,210913,210912,210911,210910,21090 9,210908,210907,210906,210905,210904,210903,210902 ,210901,210900,210899,210898,210897,210896,210895, 210894,210893,210892,210891,210890,210889,210888,2 10887,210886,210885,210884,210883,210882,210881,21 0880,210879,210878,210877,210876,210875,210874,210 873,210872,210871,210870,210869,210868,210867,2108 66,210865,210864,210863,210862,210861,210860,21085 9,210858,210857,210856,210855,210854,210853,210852 ,210851,210850,210849,210848,210847,210846,210845, 210844,210843,210842,210841,210840,210839,210838,2 10837,210836,210835,210834,210833,210832,210831,21 0830,210829,210828,210827,210826,210825,210824,210 823,210822,210821,210820,210819,210818,210817,2108 16,210815,210814,210813,210812,210811,210810,21080 9,210808,210807,210806,210805

    RNav


    620547,620548,620549,620550,620551,620552,620553,6 20554,620555,620556,6 20557,620558,620559,620560,620561,620562,620563,62 0564,620565,620566,620567,620568,620569,620570,620 571,620572,620573,620574,620575,620576,620577,6205 78,620579,620580,620581,620582,620583,620584,62058 5,620586,620587,620588,620589,620590,620591,620592 ,620593,620594,620595,620596,620597,620598,620599, ??????620600,620601,620602,620603,620604,620605,62 0606,620607,620608,620609,620610,620611,620612,620 613,620614,620615,620616,620617,620618,620619,6206 20,620621,620622,620623,620624,620625,620626,62062 7,620628,620629,620630,620631,620632,620633,620634 ,620635,620636,620637,620638,620639,620640,620641, 62064,620643,620643,620644,620645,620646,620647,62 0648,620649,620650,620651,620652,620653,620654,620 655,620656,620657,620658,620659,620660,620661,6206 62,620663,620664,620665,620666,620667,620668,62066 9,620670,620671,620672,620673,62 0674,620675,620676,620677,620678,620679,620680,620 681,620682,620683,620684,620685,620686,620687,6206 88,620689,620690,620691,620692,620693,620694,62069 5,620696,620697,620698,620699,620700,620701,620712 ,620713,620714,620716,620717,620718,620719,620720, 620721,620722,620723,620724,620725,620726,620727,6 20728,620729,620730,620731,620732,620734,620735,62 0736,620738,620739,620740,620741,620742,620743,620 744,620745,620746,620747,620750,620751,620753,6207 54,620755,620756,620757,620758,620762,620764,62076 5,620775,620776,620777,620778,620779,620780,620784 ,620785,620786,620787,620788,620789,620790,620791, 620792,620793,620794,620795,620796,620797,620798,6 20799,620800,620801,620802,620803,620804,620805
    Flight Planning


    330766,330765,330764,330763,330762,330761,330760,3 30759,330758,330757,330756,330755,330754,330753,33 0752,330751,330750,330749,330748,330747,330746,330 745,330744,330743,330742,330741,330740,330739,3307 38,330737,330736,330735,330734,330733,330732,33073 1,330730,330729,330728,330727,330726,330725,330724 ,330723,330722,330721,330720,330719,330718,330717, 330716,330715,330714,330713,330712,330711,330710,3 30709,330708,330707,330706,330705,330704,330703,33 0702,330701,330700,330699,330698,330697,330696,330 695,330694,330693,330692,330691,330690,330689,3306 88,330687,330686,330685,330684,330683,330682,33068 1,330680,330679,330678,330677,330676,330675,330674 ,330673,330672,330671,330670,330669,330668,330667, 330666,330665,330664,330663,330662,330661,330660,3 30659,330658,330657,330656,330655,330654,330653,33 0652,330651,330650,330649,330648,330647,330646,330 645,330644,330643,330642,330641,330640,330639,3306 38,330637,330636,330635,330634,330633,330632,33063 1,330630,330629,330628,330627,330626,330625,330624 ,330623,330622,330621,330620,330619,330618,330617, 330616,330615,330614,330613,330612,330611,330610,3 30609,330608,330607,330606,330605,330604,330603,33 0602,330601,330600,330599,330598,330597,330596,330 595,330594,330593,330592,330591,330590,330589,3305 88,330587,330586,330585,330584,330583,330582,33058 1,330580,330579,330578,330577,330576,330575,330574 ,330573,330572,330571,330570,330569,330568,330567, 330566,330565,330564,330563,330562,330561,330560,3 30559,330558,330557,330556,330555,330554,330553,33 0552,330551,330550,330549,330548,330547,330546,330 545,330544,330543,330542,330541,330540,330539,3305 38,330537
    Air law


    100791,100790,100789,100788,100787,100786,100785,1 00784,100783,100782,100781,100780,100779,100778,10 0777,100776,100775,100774,100773,100772,100771,100 770,100769,100768,100767,100766,100765,100764,1007 63,100762,100761,100760,100759,100758,100757,10075 6,100755,100754,100753,100752,100751,100750,100749 ,100748,100747,100746,100745,100744,100743,100742, 100741,100740,100739,100738,100737,100736,100735,1 00734,100733,100732,100731,100730,100729,100728,10 0727,100726,100725,100724,100723,100722,100721,100 720,100719,100718,100717,100716,100715,100714,1007 13,100712,100711,100710,100709,100708,100707,10070 6,100705,100704,100703,100702,100701,100700,100699 ,100698,100697,100696,100695,100694,100693,100692, 100691,100690,100689,100688,100687,100686,100685,1 00684,100683,100682,100681,100680,100679,100678,10 0677,100676,100675,100674,100673,100672,100671,100 670,100669,100668,100667,100666,100665,100664,1006 63,100662,100661,100660,100659,100658,100657,10065 6,100655,100654,100653,100652,100651,100650,100649 ,100648,100647,100646,100645,100644,100643,100642, 100641,100640,100639,100638,100637,100636,100635,1 00634,100633,100632,100631,100630,100629,100628,10 0627,100626,100625,100624,100623,100622,100621,100 620,100619,100618,100617,100616,100615,100614,1006 13,100612,100611,100610,100609,100608,100607,10060 6,100605,100604,100603,100602,100601,100600,100599 ,100598,100597,100596,100595,100594,100593,100592, 100591,100590,100589,100588,100587,100586,100585,1 00584,100583,100582,100581,100580,100579,100578,10 0577,100576,100575,100574,100573,100572,100571,100 570,100569,100568,100567,100566,100565,100564,1005 63,100562,100561,100560,100559,100558,100557,10055 6,100555,100554,100553,100552,100551,100550,100549 ,100548,100547

  • #2
    What an amazing, time-saving help. Let me be the first one to thank you TheEwook! I don't suppose you have the last 200 for Instruments too, do you? Either way, many thanks!

    Comment


    • #3
      Hello Dear Students,

      Since I've seen several posts regarding the last 200 questions for each subject I have decided to make an excel with two subjects as an example.

      Link to excel: https://drive.google.com/open?id=1Qr...gbUf8TNelNE0Gr

      In this excel file, we have two columns, A and B. Column A are the question numbers that we need to insert in order to generate the exam.
      Colum B will be the output to generate the exam.

      So the first entry on column A1 is the last question that was inserted into the database. Considering INST as a reference, the Question Bank(QB) has 1234 questions (when this post was written). So how do you know the number of the last question?

      Simple! The first thing we need to understand is how questions are numbered. The first two digits are the subject identification, INST = 22 followed by the number of the question. As an example, I chose the last question 221299. Yes, there is a question with the number 1299, and I figured this by picking the total number of questions, 1234, and adding up one, 1235, and so on, testing it on the database under the option "Search for questions by ID" until I get the error "Failed to find questions with chosen IDs.". When I get this error it means the last question in the database is the previous one I've tested.

      Now that we know the last question numbers, we simply use the excel that was provided and replace the A1 cell with the last question numbers and on the cell below, A2, should be A1 less 1. So, in this case, A1 = 221299, A2 = 221298. Use SHIFT to select A1 and A2 at the same time and where the "+" sign appears select and just drop-down until you reach 200 questions. Sometimes you need to continue for a few more questions lets say 4 to 5 because some questions in the middle were removed.

      On Column B, if you are studying a new subject just copy the formulas from cells B1 and B2 to the same cells of a new sheet. Now just click on "+" and drop-down until the 200 questions are created like we did for Column A, and voila! In the last cell of Column B, you will have the output with the correct format to paste the questions into the search box "Search for questions by ID" at the database.

      Keep in mind if for some reason Bristol decides to update the QB and introduces new questions this excel will not reflect those updates since this needs to be checked manually. This is not a Bristol product and is just a way to help get the most recent questions.

      Hope this helps. Happy flights!

      Regards,
      Pedro Alves
      Last edited by pnnalves; 10-03-2018, 20:25.

      Comment


      • #4
        Anyone have an updated version of the last 200?? We should make a last 200 dedicated forum page!

        Comment


        • #5
          POF Last 200 Updated January 14 2018

          811197,811198,811199,811200,811201,811202,811203,8 11204,811205,811206
          ,811207,811208,811209,811210,811211,811212,811213, 811214,811215,81121
          6,811217,811218,811219,811220,811221,811222,811223 ,811224,811225,8112
          26,811227,811228,811229,811230,811231,811232,81123 3,811234,811235,811
          236,811237,811238,811239,811240,811241,811242,8112 43,811244,811245,81
          1246,811247,811248,811249,811250,811251,811252,811 253,811254,811255,8
          11256,811257,811258,811259,811260,811261,811262,81 1263,811264,811265,
          811266,811267,811268,811269,811270,811271,811272,8 11273,811274,811275
          ,811276,811277,811278,811279,811280,811281,811282, 811283,811284,81128
          5,811286,811287,811288,811289,811290,811291,811292 ,811293,811294,8112
          95,811296,811297,811298,811299,811300,811301,81130 2,811303,811304,811
          305,811306,811307,811308,811309,811310,811311,8113 12,811313,811314,81
          1315,811316,811317,811318,811319,811320,811321,811 322,811323,811324,8
          11325,811326,811327,811328,811329,811330,811331,81 1332,811333,811334,
          811335,811336,811337,811338,811339,811340,811341,8 11342,811343,811344
          ,811345,811346,811347,811348,811349,811350,811351, 811352,811353,81135
          4,811355,811356,811357,811358,811359,811360,811361 ,811362,811363,8113
          64,811365,811366,811367,811368,811369,811370,81137 1,811372,811373,811
          374,811375,811376,811377,811378,811379,811380,8113 81,811382,811383,81
          1384,811385,811386,811387,811388,811389,811390,811 391,811392,811393,8
          11394,811395,811396,811397, 811321

          Comment


          • #6
            1. Find the highest subject question number - 200

            2. Download python shell: https://www.python.org/ftp/python/3....thon-3.7.3.exe

            3. Put this code into python shell: list(range(000000, 000000)) replace 00000 with number you have got after doing - 200 for example: list(range(610395, 610595))

            4. Execute and you should get all the list nicely done with ,,,,,,,,,,,,,,,,,,,,,,,,,,


            Good luck.

            Comment

            Working...
            X