Python: How to Deal with Tables in Word

Header

I think I’ve mentioned it before that the Python documentation can be really confusing for beginners. There may be people out there who can look at this Table objects page and completely understand what’s happening.

I am not those people. I need visuals.

Continue reading

Advertisements
Tagged , , , , , ,

Arduino: A GifGuide to Parts

Header

I get approximately 2 sentences into most Aduino guides before becoming a giant ball of rage because I have no idea what’s going on. The terminology has been a serious barrier to entry for me. So I decided to take a break from scripting to make a guide for all the fun bits that come in an Arduino kit.

Continue reading

Tagged , , , ,

Python: How to Write an Intersect Analysis to a Text Document

Header

So here’s a quick thing to note before we get started. Python will throw a shit-fit if you do not have everything properly formatted. Indentation matters. I can’t figure out how to make WordPress format my tabs, so if you do copy and paste the below code, indent the loops to avoid errors.

Continue reading

Tagged , , , , , ,

VBA: How to Use VLookUp in a Macro

Header

Alright, here’s something I’ve been meaning to learn for weeks. It’s probably going to be the most boring post of all time for anyone who isn’t an Excel nerd. In fact, if you aren’t an Excel nerd, just run. Run far, far away.

Continue reading

Tagged , , , , , , , , , ,

VBA: How to Exclude Numbers from a List

Header

Alright, I ran short of time this week, so I don’t have a tutorial. But I DO have another fun UDF (User-Defined Function)–this one takes two parameters. Both need to be strings made of comma separated numbers. The function excludes the second set of numbers from the output.

Continue reading

Tagged , , , , , , , ,

Python: How to Start Scripting in ArcGIS

Header

Python in ArcGIS is intimidating, so I’m starting simple. This is a quick walk through of how to load a script for use and what a basic Python script looks like.

Continue reading

Tagged , , , , , ,

VBA: How to Get A List From a Range of Numbers

Header

A couple months ago, I did the exact opposite of this. I called it the ListToRange() Function. It’s weirdly helpful at work because I have to go back and forth between having numbers listed out and then having them clustered for other things.

Continue reading

Tagged , , , , , , ,