{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Legs","Info"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Legs","index":0,"n_rows":4,"n_cols":16,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Base","Cat","Rot\nNum","Date","FltNum\nStatus\nCode","Right\nStatus","Flt","From","Dep","To","Arr","Block","M/U","Block\n+ M/U","Ship","Leg"]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUBTOTAL(109,K5:K12)","v":0},{"$f":"SUBTOTAL(109,L5:L12)","v":0},{"$f":"SUBTOTAL(109,M5:M12)","v":0}]

{"sheet":"Info","index":1,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[24,2,24,11],[25,2,25,11],[22,2,22,11],[6,2,6,11],[15,2,15,11],[23,2,23,11],[14,2,14,11],[3,2,3,4],[21,2,21,11],[16,2,16,11],[17,2,17,11],[18,2,18,11]]}
[]
[null,"Version:","2.0a"]
[null,"Date:","2023-06-06"]
[null,"Contact:","thejohnbell@gmail.com"]
[null,null,"407.230.7790"]
[null,"Warning:"]
[null,null,"This should really be in the instructions, but it is an obscure issue that you may not reach in the instructions below. Excel \"thinks\" in days. For example, Excel thinks of 72:00 (format [h]:mm) as the same as 3 days. Thus, you need to multiply any times by 24 to get the hours."]
[null,null,"Example:"]
[null,null,"Monthly\nHours","Hourly\nRate","Wrong\nC*D","Correct\nC*24*D"]
[null,null,3,330,{"$f":"C10*D10","v":990},{"$f":"C10*D10*24","v":23760}]
[null,null,3,330,{"$f":"C11*D11","v":990},{"$f":"C11*D11*24","v":23760}]
[null,null,"C10=C11",{"$f":"C10=C11","v":true}]
[]
[null,"Explanation:"]
[null,"-","This takes the text of an iCrew rotation and strips out the main leg elements such as block and m/u."]
[null,"-","Background: Some line check airman wanted a way of checking the line check time given. I though there might be other people who wanted to total their time, so I made it a more general tool. However, I do not think that I would use it as my logbook -- not that I keep one anymore. Use this at your own risk for whatever use you may find."]
[null,"-","The problem with the pilot activity statement is that it is downstream in the data flow. If the purpose is to check the validity of the pay, then it seems to make sense to go as far up the data stream as possible -- to the iCrew rotations."]
[null,"-","Filtering in Excel is one of its best features. To show only line check legs, filter for \"L\" in the status column. If you want to check on a month, you can filter by that month. You can apply multiple filters and they are joined with a logical AND. The totals at the top will reflect the totals of those lines showing after the filters have been applied."]
[null,"-","This is not something that I personally expect to use. It was interesting enough to spend some time on it, but it will not benefit from dogfooding (Google that term). I am willing to take some suggestions if they don't involve too much work."]
[null,"-","Let me know if I am even on the correct path."]
[null,"Instructions"]
[null,"-","Make sure that you download this file and run it on your computer within Excel. It will not work online or on the iPad. It should probably work on the Mac, but I have not tested it. Let me know about the Mac and perhaps I can tweak it to work."]
[null,"-","Copy the rotation in iCrew. Make sure that you get the top line with \"*** ROTATON OPER.\" You should be able to select within the rotation and use Ctrl-A then Ctrl-C to select all and then copy. I ignore all of the \"junk\" that gets pasted."]
[null,"-","This should work with the pairings if you click on the airplane icon at the bottom of your schedule or use Pre-Flight -> Rotation. This will now work with the Pre-Flight -> Archived Rotations."]
[null,"-","Click on the import button. The copied rotation will automatically be copied, but you can paste into or otherwise modify the text before sending it to the sheet."]
[null,"-","New data will be added to the end and the display will jump to the newly extracted data. The previous information can be accessed by scrolling up."]
[null,"Support"]
[null,null,"I offer very little support. However, let me know if you find an error."]
[null,"Updates"]
[null,"2023-06-06","Updated to reflect some changes in the rotation display."]
[null,"2022-04-27","I updated the info to note that Excel thinks in days."]