Create a map of points from bearing and range data extracted from text.

I’d like a short program (excel is fine) that will scrape through pasted text (example below) and create a map of points. I also need it to be able to filter for a set time period.

The data of interest is the Cranes e.g:

OBST CRANE 157FT AGL BRG 141 MAG 1.34NM FM ARP

AD FROM: 06 152334 TO: PERM C0138/22

HANDLING SERVICES AND FACILITIES AMD

ADD NOTE:

AVTUR FUEL DELIVERIES AVBL FM HYDRANT AND TRUCK REFUELLING VEHICLES.

AMEND EN ROUTE SUPPLEMENT AUSTRALIA (ERSA)

AD FROM: 08 050019 TO: 11 050830 C0172/22

INCREASED BIRD HAZARD (AUSTRALIAN PELICAN, AUSTRALIAN WHITE IBIS AND

LITTLE CORRELLA) WI VCY RWY 18/36

FOR DETAILS CTC AIR BASE COMMAND POST TEL: 08 xxx xxxx

DAILY 2130/0830

AD FROM: 08 250210 TO: 11 250730 C0178/22 REVIEW C0113/22

OBST CRANE 157FT AGL BRG 141 MAG 1.34NM FM ARP

INFRINGES OBST LIMITATION SFC BY 108FT

SITE CTC TEL: 0438 xxx xxx

FOR DETAILS CTC AIR BASE COMMAND POST TEL: 08 xxx xxxx

AD FROM: 08 260413 TO: 11 290530 C0179/22 REVIEW C0121/22

OBST CRANE 197FT AGL BRG 090 MAG 0.04NM FM ARP

INFRINGES OBST LIMITATION SFC BY 197FT

FOR DETAILS CTC AIR BASE COMMAND POST TEL: 08 xxxx xxx

SITE CTC TEL: 0414 xxx xxx

AD FROM: 08 260415 TO: 11 290530 C0180/22 REVIEW C0117/22

OBST CRANE 56FT AGL BRG 090 MAG 0.11NM (203M) FM ARP

INFRINGES OBST LIMITATION SFC BY 56FT

SITE CTC TEL: 0423 xxx xxx

FOR DETAILS CTC AIR BASE COMMAND POST TEL: 08 xxxx xxx

PROC FROM: 08 290246 TO: 11 290530 EST C0183/22 REVIEW C0142/22

AUSTRALIAN DEFENCE FORCE FLT INFO PUBLICATIONS AMD

TERMINAL AUSTRALIA (TERMA), FACILITIES AND PROCEDURES AIR COMBAT

GROUP SOUTH (FAP ACG SOUTH)

ILS-Y OR LOC-Y RWY 18 USING EDN TACAN OR IED DME

ILS/TAC MINIMA 570 (509) -2100 (VIS -1500 WITH ACTUAL QNH)

AD FROM: 09 010525 TO: 11 300830 C0188/22

OBST CRANE 158FT AGL ERECTED BRG 124 MAG 1870M FM ARP

INFRINGES OBST LIMITATION SFC BY 18FT

SITE CTC TEL: 0438 xxx xxx

FOR DETAILS CTC AIR BASE COMMAND POST TEL: 08 xxxx xxx

AD FROM: 09 052030 TO: 10 290530 C0182/22

ORDNANCE LOADING AREA (OLA) 11 NOT AVBL DUE WIP

FOR DETAILS CTC AIR BASE COMMAND POST TEL: 08 xxxx xxx

AD FROM: 09 270535 TO: 11 300700 C0208/22 REVIEW C0176/22

TWY B NORTH OF TWY D NOT AVBL DUE WIP

FOR DETAILS CTC AIR BASE COMMAND POST TEL: 08 xxxx xxx

AD FROM: 09 270535 TO: 10 310700 C0209/22 REVIEW C0175/22

TWY L NOT AVBL DUE WIP

FOR DETAILS CTC AIR BASE COMMAND POST TEL: 08 xxxx xxx

AD FROM: 10 032030 TO: 10 310730 C0212/22

OBST CRANE 131FT AGL ERECTED BRG 198 MAG 1.43NM FM ARP

INFRINGES OBST LIMITATION SFC BY 79FT

SITE CTC TEL: 0487 xxx xxx

FOR DETAILS CTC AIR BASE COMMAND POST TEL: 08 xxxx xxx

DAILY 2030/0730

Excel Web Scraping Xử lí dữ liệu

ID dự án: #35052205

Về dự án