{"id":18482,"date":"2023-05-28T06:28:22","date_gmt":"2023-05-28T04:28:22","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/excel-sheet-data-processing-help-helicopter-foia-separating-data-excel-sheet\/"},"modified":"2023-06-24T10:39:23","modified_gmt":"2023-06-24T08:39:23","slug":"excel-sheet-data-processing-help-helicopter-foia-separating-data-excel-sheet","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/excel-sheet-data-processing-help-helicopter-foia-separating-data-excel-sheet\/","title":{"rendered":"Excel Sheet Data Processing Help &#8211; Helicopter FOIA Separating Data Excel Sheet"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Data Processing<\/p>\n<p>Hey, I need help processing data. My friend offered me a helicopter ride (met through someone) in a certain city in the US in January of 2022 &#8230; Lost contact of person who connected me the helicopter dude never gave me his name \ud83d\ude2d (he has an electrical engineering lisence from I&#8217;m assuming Florida&#8230; He owns a house in this city in south Florida) <\/p>\n<p>Fast forward. I requested a FOIA (freedom of information act) of all helicopters in that city January 2022 &#8230; Less that 20 total. Easy. What happens. <\/p>\n<p>My FOIA came in ANDDD according to the FOIA letter they couldn&#8217;t separate the rotorcrafts (helicopters) from the fixed wing (small planes \ud83d\ude2d) from January 2022. <\/p>\n<p>January 2022 was a VERY BUSY month for planes&#8230; It&#8217;s going to be an insane amount of data. <\/p>\n<p>(But it&#8217;s probably over 10 pages with 50 aircraft info per page on 11 pt. Font) <\/p>\n<p>How do I sort the helicopters out of the data. It was like 15 helis maximum. <\/p>\n<p>HOWEVER&#8230; <\/p>\n<p>You can also download all the persons with pilot licenses. This guy has a pilot license (owns and flies his helicopter)&#8230; On a sheet that identifies type of lisence <\/p>\n<p>As like p\/h for helicopter&#8230;. How do you sort all the helicopter owners from this sheet? <\/p>\n<p>It&#8217;s as an excel sheet. <\/p>\n<p>Please advise!!<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/Soggy-Nectarine-3578\"> \/u\/Soggy-Nectarine-3578 <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/13tqce4\/excel_sheet_data_processing_help_helicopter_foia\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/13tqce4\/excel_sheet_data_processing_help_helicopter_foia\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-18482 jlk' href='javascript:void(0)' data-task='like' data-post_id='18482' data-nonce='614a020375' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-18482 lc'>0<\/span><\/a><\/div><\/div> <div class='status-18482 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Data Processing Hey, I need help processing data. My friend offered me a helicopter ride (met through&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[27],"class_list":["post-18482","post","type-post","status-publish","format-standard","hentry","category-datatards","tag-english","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/18482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=18482"}],"version-history":[{"count":1,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/18482\/revisions"}],"predecessor-version":[{"id":19551,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/18482\/revisions\/19551"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=18482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=18482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=18482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}