{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Questions","Categories","Settings and Controls"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Questions","index":0,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Category","Question","Answer","Format"]
["Limitations","Maximum Operating\nAltitude","<pre>\n<strong>-323, -200</strong> (Pratt)\n&nbsp;&nbsp;41,100 feet\n\n<strong>-302, -900</strong>\n&nbsp;&nbsp;41,450 feet</pre>","html"]
["Limitations","Maximum Takeoff and\nLanding Tailwind\nComponent","<pre>\n<strong>-200, -323, -302</strong>\n&nbsp;&nbsp;10 knots, or as permitted by Company Pages\n\n<strong>-900</strong>\n&nbsp;&nbsp;15 knots, or as permitted by Company Pages\n</pre>","html"]
["Limitations","Maximum Crosswind Component","<pre>\n<strong>-200, -323, -302</strong>\n&nbsp;&nbsp;Crosswind limit is 40 knots for takeoff or landing, including gusts.\n\n<strong>-900</strong>\n&nbsp;&nbsp;Crosswind limit is 30 knots for takeoff, including gust. Landing is 35 knots,\nincluding gusts.\n</pre>","html"]
["Limitations","Autopilot Minimum Altitudes","The minimum altitude for autopilot engagement during takeoff and manual go-around is 100 feet AGL and at least 5 seconds after liftoff.","html"]
["Limitations","Automatic Landing Wind Limits","<strong>-200, -323, -302</strong>\n<table>\n<tr><td>Headwind</td><td>35 knots</td></tr>\n<tr><td>Tailwind</td><td>10 knots</td></tr>\n<tr><td>Crosswind</td><td>20 knots (15 knots when operating below CAT I minimums)</td></tr>\n</table><br />\n\n<strong>-900</strong>\n<table>\n<tr><td>Headwind</td><td>20 knots</td></tr>\n<tr><td>Tailwind</td><td>10 knots</td></tr>\n<tr><td>Crosswind</td><td>15 knots</td></tr>\n</table>","html"]
["Limitations","Soft Go-Arund (-900)","The use of soft go-around is prohibited with one engine inoperative."]
["Limitations","Max flap or slat altitude.","Do not extend flaps or slats above 20,000 feet."]
["Maneuvers","Engine out","-Rotate\n- \"Positive Rate\" (PM) - \"Gear Up\" (PF)\n-SRS speed (V2 or current airspeed)\n-Rudder to center Beta target\n-When Safely Airborne\n   -Set rudder trim\n   -Engage autopilot if desired\n-At acceleration height (normally 1000 ft.)\n   -Press ALT\n   -Retract flaps on schedule\n   -Accelerate to Green Dot\n   -After Takeoff chedklist\n-At Green Dot\n   -select OP CLB\n   -Set MCT Thrust\n   -PM begin ECAM"]
["Maneuvers","Missed Approach","- \"Go Around, Flaps\" (PF)\n- Select TOGA\n    If above TRA use TOGA bump and back to CLB\n- \"SRS Verified\"  \"Positive Rate\" (PM)\n- \"Gear Up\" (PF)\n- 400 ft verify or call for lateral mode\n- Thrust Reduction Altitude (normally 1000 ft)\n    FMA should indicate with LVR CLB\n   - Thrust levers to CLB\n- Follow FD\n- Retract flaps on schedule\n- After Takeoff checklist"]
["Maneuvers","Upset","Push\nRoll\nPower\nStabilize"]
["Memory Items","Driftdown","<pre>\nCondition:Engine failure or shutdown during cruise.\n\n1 Max continuous thrust (MCT)...............Set\n2 A/THR.....................................Disconnect\n3 Select HDG or NAV as appropriate.\n4 FCU SPD/MACH..............................Set\nSet Green Dot SPD (not MACH).\n5 FCU Altitude..............................Set\n</pre>","html"]
["Memory Items","CAB PR EXCESS CAB ALT or Rapid Depressurization"," CREW OXY MASKS . . . . . . . . . . . . . . . . . . . . ON"]
["Memory Items","Loss of Braking","<pre>\n1 Thrust Levers........................Maximum reverse (as reqd)\n2 Brake Pedals.........................Release\n3 A/SKID & NWS switch..................OFF\n4 Brake Pedals.........................Press (Max 1000 psi)\n5 If required, apply parking brake with short,\nsuccessive applications.\n</pre>","html"]
["Memory Items","Unreliable Airspeed Indication","<pre>\n<strong>If the safe conduct of the flight is impacted:</strong>\n\n1. A/P....................................OFF\n2. A/THR..................................OFF\n3. FD.....................................OFF\n4. PITCH/THRUST\n  &bull; BELOW THR RED ALT.................15&#176;/TOGA\n  &bull; ABOVE THR RED & Below FL 100......10&#176;/CL\n  &bull; ABOVE THR RED & Above FL 100.......5&#176;/CL\n5. FLAPS\n  (If CONF 0(1)(2)(3))....MAINTAIN CURRENT CONF\n6. FLAPS\n  (If CONF) FULL..........SELECT CONF 3 & MAINTAIN\n7. SPEED BRAKES.........................CHECK RETRACTED\n8. L/G..................................UP\n9. When at or above MSA or Pattern altitude:\n  &bull; Level off for troubleshooting.\n</pre>","html"]
["Memory Items","Emergency Evacuation Flow/Phylosophy","STOP<br />CONFIGURE<br />SHUTDOWN<br />EVACUATE<br />","html"]
["Non-memory Limits","Brake temperature for takeoff","275&deg; C (from Vol1 Landing Gear Supp Procedures)","html"]
["Non-memory Limits","Gear Speed","240 kts (250 Airbus limited to 240 by Delta)"]
["Non-memory Limits","Severe Turbulence speeds","<strong>-323, -302</strong>\n240 KIAS below 20,000 ft.<br />\n260 KIAS or .78 (whichever is lower) above 20,000 ft.<br /><br />\n<strong>-200, -900</strong>\n240 KIAS below 20,000 ft.<br />\n260 KIAS or .80 (whichever is lower) above 20,000 ft.<br /><br />","html"]
["Non-memory Limits","Flap Speeds","<pre>\n1      240 kts\n1+F    215 kts\n2      196 kts\n3      186 kts\nFull   180 kts\n</pre>","html"]
["Non-memory Limits","Turn Radius for 180 turn","-200 142 ft.\n-300 157 ft.\n-900 158 ft."]
["Non-memory Limits","Wing span","197ft 10in (60m)"]
["Non-memory Limits","Fuel Capacity","323: 172,000\n-200, -302, -900 245,000"]
["Non-memory Limits","Ignition","-moderate rain\n-moderate turbulence\n-standing water or slush on the runway"]
["Vocab / ACRONYMS","IR (on ADIRS panel)","Inertial Reference"]
["Vocab / ACRONYMS","ADR (on ADIRS panel)","Air Data Inertial Reference System"]
["Vocab / ACRONYMS","FMGEC","Flight Management Guidance and Envelope Computer"]
["Vocab / ACRONYMS","LGCIU","Landing Gear Control and Interface Unit"]
["Vocab / ACRONYMS","BSCU","Brake and Steering Control Unit"]
["Vocab / ACRONYMS","SRS","Speed Reference System"]
["Vocab / ACRONYMS","DMC","Display Management Computer"]
["Vocab / ACRONYMS","ISIS","Integrated Standby Instrument System"]
["Vocab / ACRONYMS","CIDS","Cabin Intercommunication Data System"]
["Vocab / ACRONYMS","BSCU","Brake and Steering Control Unit"]
["Vocab / ACRONYMS","ECAM","Electronic Centralized Aircraft Monitor"]
["Vocab / ACRONYMS","DMC","Display Management Computer"]
["Vocab / ACRONYMS","AOC","Airline Operational Communication"]
["Non-memory Limits","Minimum and Emergency Fuel","Min 7800 (7000 on the 900)\nEmergency 6000"]

{"sheet":"Categories","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Category"]
["Limitations"]
["Maneuvers"]
["Memory Items"]
["Non-memory Limits"]
["Vocab / ACRONYMS",null,"Note: This sheet allows you to enter categories and then send them to the Questions sheet as pull down options."]
[null,null,"This will help prevent making duplicate categories that are simple misspellings of a correct category."]

{"sheet":"Settings and Controls","index":2,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,2,2,4],[3,3,3,10],[16,3,16,11],[17,3,17,11],[4,2,4,3],[11,2,14,11],[20,2,20,11],[21,2,21,11],[22,2,22,11],[24,2,24,11],[25,2,25,11],[28,2,28,11],[26,2,26,11],[27,2,27,11]]}
[]
[null,"Version:","1.0f"]
[null,"Contact:","thejohnbell@gmail.com"]
[null,"Latest version, etc:",null,"www.johnfbell.com"]
[null,"Updated:","2020-11-04"]
[]
[null,"Controls HTML version"]
[]
[]
[null,"Data"]
[null,null,"Information about the questions to be added to the About section:"]
[null,null,"Updated 10/22/2022\nYou are welcome to use these, but they are meant for my own use. "]
[]
[]
[]
[null,null,"Note: You do not need to interface with these next boxes. Running the macro will prompt you."]
[null,null,"Title:","330 Flash Cards"]
[null,null,"File Location","C:\\Users\\johnbell\\OneDrive\\A330\\330FlashCards.htm"]
[]
[null,"Instructions"]
[null,"1.","Create your list of categories in the Categoris tab. This will delete text such as characters that might cause problems such as \".\" and \"/\"."]
[null,"2.","Use the button in the catgories tab to add the categories as pull down options when creating the questoins."]
[null,"3.","Create the Questions and Answers. Unless you select html, the macro will assume that the text is plain text. Selecting html allows you to do some simple html like bulleted lists."]
[null,"Tricks (a little html)"]
[null,"-","For multiple lines use Alt Enter to create multiple lines and specify Plain Text or leave column D blank. This will reflect in the html output."]
[null,"-","Bulleted items. Use the following html:\n<ul>\n  <li>First Item</li>\n  <li>Second Item</li>\n</ul>\nThe line feed in Excel does not matter. <ul><li>First Item</li><li>Second Item</li></ul> will do the same thing. It is uglier, but easer to type."]
[null,"-","You can make fixed width text using the <pre> tag. This is handy if you are pasting things with columns made using fixed width text. You might also change the font in the cell to Courier New to help line things up. Example:"]
[null,null,"<pre>\nCategory    ALV    LOW   HIGH      GUAR\nATL 777 A   71:00  65:00-78:30     72:00\nATL 777 B   71:00  65:00-78:30     72:00\nATL 330 A   71:00  65:00-78:30     72:00\nATL 330 B   71:00  65:00-78:30     72:00\n</pre>"]
[null,"-","There are a variety of other format tricks such as <b>text to bold</b>. Let Google be your guide. Remember to select html as the style in column b if you use this. Also <br/> adds a line feed. Note that in an html formatted cell I do not automatically turn the Excel line feed into a line feed in the html. Use <br/> if you want to force a line feed in an html cell."]
[null,"Using the resulting file on your iPad"]
[null,null,"Use this almost like an html flight plan. It is probably easiest to e-mail it to yourself. You an save to files.  "]
[null,null,"From within the Files app, hold on the attachment and use Share to Edge or similar app."]
[null,"Changes:"]
[null,"1.0f","Added option to get categories from questions. Mostly for when someone gives me a list of questions with new categories."]
[null,"1.0e","Fixed translation of text for characters such as the degree mark and apostrophe."]
[null,"1.0d","Changed some formats to look a little better on iOS."]
[null,"1.0c","I added red shading if the Category in the Questions colum A does not correspond to a Category in the Categories tab."]
[null,"1.0c","If you add a line shift with Alt Enter in a cell, it will now reflect in html."]
[null,"1.0c","Allow html input for Questions or Answers."]
[null,"1.0b","I made the buttons taller."]