topic Challenge #388: Meteorite Impact Sites in Weekly Challenges

Challenge #388: Meteorite Impact Sites

AYXAcademy — Mon, 03 Jun 2024 15:41:59 GMT

Hi Maveryx,

A solution to last week’s challenge can be found here.

This challenge comes to us from @AkimasaKajitani . Thank you for your contribution, Aki!

Meteorite showers are a captivating natural phenomenon, though it can be challenging to see them depending on your location. Fortunately, residents and visitors in the Las Vegas area enjoy an advantageous position, being in proximity to expansive desert skies that offer excellent conditions for meteorite watching.

For this challenge, your mission is to plan a budget-friendly meteorite impact site tour near Las Vegas, ensuring enthusiasts visit locations where they have the best opportunity to witness this celestial spectacle.

Here are the tasks you must complete. Calculate all distances in kilometers.

Find a meteorite impact site that is closest to a hotel that costs less than $200 per night. Designate this location as the "First Stop."
Identify the nearest meteorite impact site in relation to the First Stop. Label this site as the "Second Stop" and determine the distance between the first and second stops.
Locate the nearest meteorite impact site in relation to the Second Stop. Name this site “Third Stop” and determine the distance between the second and third stops.
Calculate the total distance traveled from the hotel to the third stop.

Data Summary:

You have two datasets. The text dataset contains the latitude and longitude of some hotels in Las Vegas with their cost per night. The second dataset, meteorite-landings.csv, contains the latitude and longitude of over 45,000 meteorites that have struck our planet.

Source: https://www.kaggle.com/datasets/nasa/meteorite-landings

Re: Challenge #388: Meteorite Impact Sites

benjimoser — Sun, 17 Sep 2023 13:32:54 GMT

My first Solution:

My Solution using an iterative Macro which calculates the next 100 locations to visit:

---------------------------

Re: Challenge #388: Meteorite Impact Sites

mmontgomery — Mon, 11 Sep 2023 14:40:26 GMT

Not too bad

Re: Challenge #388: Meteorite Impact Sites

Kenda — Mon, 11 Sep 2023 15:10:17 GMT

Great challenge, @AkimasaKajitani

Re: Challenge #388: Meteorite Impact Sites

ed_hayter — Mon, 11 Sep 2023 15:12:09 GMT

Nice quick spatial challenge

I did want to use miles over KM though!

Re: Challenge #388: Meteorite Impact Sites

AkimasaKajitani — Mon, 11 Sep 2023 15:38:51 GMT

My solution! I also add a map solution!!

@Kenda Thanks!!

Map

When I see the Map of Las Vegas, I remember my awesome experience at Inspire 2023 and it makes me feel nostalgic.

Re: Challenge #388: Meteorite Impact Sites

nhardin — Mon, 11 Sep 2023 15:40:00 GMT

Re: Challenge #388: Meteorite Impact Sites

ahsanaali — Mon, 11 Sep 2023 16:23:51 GMT

Re: Challenge #388: Meteorite Impact Sites

alexnajm — Mon, 11 Sep 2023 16:33:26 GMT

Love the Spatial tools!

Re: Challenge #388: Meteorite Impact Sites

AshaDaniels — Mon, 11 Sep 2023 17:06:35 GMT

Re: Challenge #388: Meteorite Impact Sites

braveraj — Mon, 11 Sep 2023 17:06:53 GMT

Fun challenge!

Re: Challenge #388: Meteorite Impact Sites

JamesCharnley — Mon, 11 Sep 2023 17:13:22 GMT

Recognise this one!

Re: Challenge #388: Meteorite Impact Sites

olivier_newman — Mon, 11 Sep 2023 17:27:17 GMT

Nice spatial

Re: Challenge #388: Meteorite Impact Sites

toby49 — Mon, 11 Sep 2023 18:00:18 GMT

Re: Challenge #388: Meteorite Impact Sites

zdravkab — Mon, 11 Sep 2023 18:29:59 GMT

Re: Challenge #388: Meteorite Impact Sites

balajilolla2 — Mon, 11 Sep 2023 18:35:54 GMT

Solution Attached

Re: Challenge #388: Meteorite Impact Sites

Watermark — Mon, 11 Sep 2023 19:00:11 GMT

For everyone's benefit, I included 2 different ways to calc, used 1 for MI & 1 for KM. If there were more than 3 pts, a macro would have made sense, but with only 3 pts it was quicker to just stick in the tools.

Re: Challenge #388: Meteorite Impact Sites

patrick_digan — Mon, 11 Sep 2023 20:11:16 GMT

Re: Challenge #388: Meteorite Impact Sites

TDouheret — Mon, 11 Sep 2023 21:11:43 GMT

Nice one! Here's my solution

Re: Challenge #388: Meteorite Impact Sites

olga_strubbe — Mon, 11 Sep 2023 22:15:16 GMT

What a fun challenge, thank you, @AkimasaKajitani!

This would be a great case for iterative macro. I'll have to play with that next :)

Here is my solution attached.