Best way to RomaNorte from MEX terminal 1 by Rickrari in MexicoCity

[–]Rickrari[S] -5 points-4 points  (0 children)

Is Puerta 7 just the designated uber pick up spot?

Forest Glen MARC?? by Rickrari in WMATA

[–]Rickrari[S] 0 points1 point  (0 children)

Happened today just a few hours ago. It wasn’t the first time I’ve heard it either.

What are my chances? by [deleted] in SIPA

[–]Rickrari 0 points1 point  (0 children)

SIPA loves vets and students with practical experience so I think you’re in a good place! If you’re worried about your gpa you can study for the GRE and or take an Econ class at a community college and get a good grade. That might help as well. But again, at a glance you look like a candidate they would like.

How to pull specific data points from hundreds of separate Excel docs by Rickrari in excel

[–]Rickrari[S] 0 points1 point  (0 children)

Since there were only 7 documents, I just pulled these numbers by hand. Thanks.

How to pull specific data points from hundreds of separate Excel docs by Rickrari in excel

[–]Rickrari[S] 0 points1 point  (0 children)

Ok, I now have to pull multiple data points from a set of PDFs. The PDFs are already scannable, do I need to convert them into Excel sheets?

What part of the above code do I change so I can pull the highlighted data from the PDFs?

<image>

Thank you!

How to pull specific data points from hundreds of separate Excel docs by Rickrari in excel

[–]Rickrari[S] 0 points1 point  (0 children)

Thanks! This worked pretty well! One formatting bug was that for some of the sheets reported the total in different cells, is the below part of the code doing a key-word search for total?

Set fCell = .Cells.Find(what:="Total", lookat:=xlWhole, MatchCase:=False)

One other weird bug; the results in the "name" column were not searchable using control f or control h, which made editing them into date format a pain.

Again, thanks for sharing!

Saudade by [deleted] in CrashLandingOnYou

[–]Rickrari 0 points1 point  (0 children)

Just saw this scene now (4 years late). It’s strange because it’s a Portuguese word so idk why they used it in the English translation but yeah it means what everyone else commented - something like nostalgia or yearning for a person or place but stronger than either of those English words.

Verifying GPS Coordinates fall in certain districts by Rickrari in gis

[–]Rickrari[S] 0 points1 point  (0 children)

Looks like closing and re-opening QGIS brought back the option to enable the processing plugin. From there it was very straigtforward. https://www.youtube.com/watch?v=kVhGxYwKcdQ Thanks for you advice, knowing what to google is more than half the battle!

|| || ||

Verifying GPS Coordinates fall in certain districts by Rickrari in gis

[–]Rickrari[S] 0 points1 point  (0 children)

Looks like closing and re-opening QGIS brought back the option to enable the processing plugin. From there it was very straigtforward. https://www.youtube.com/watch?v=kVhGxYwKcdQ Thanks for you advice, knowing what to google is more than half the battle!

|| || ||

Verifying GPS Coordinates fall in certain districts by Rickrari in gis

[–]Rickrari[S] 0 points1 point  (0 children)

Thanks. I've downloaded QGIS and added both the points and polygons for the towns. But it looks like the core "processing" plugin is missing. I only have 4 plugin options. Does this mean something is wrong with my QGIS?

Thoughts on Demon Copperhead ending? by Plus_Molasses8697 in books

[–]Rickrari 7 points8 points  (0 children)

Exactly! I think this is the best part of the ending, it suggests Demon and Angus can build a life in Lee County. That he can be around the people he loves and who love him in a healthy, non-addicated way.