The birth of Skweeds.

Imagine:

It’s the year 2001, and I’m a computer nerd. I have to make a username and password for every website which sucks.

If my preferred username is taken, I could add some numbers or XoX to the end and get something available, but that looks lame.

If I want a memorable username with no numbers, maybe I should make up a fake word that won’t mean anything to anybody, and then I’ll always have that as my username on every single site.

If someone asks me if I smoke, I think they’re talking about cigarettes. As a 15 year old, I am more naive than I want to admit.

man alive!

Re: Diluting the definition of racism.

Imagine this situation:

Alex doesn’t hate Chinese people, but asks, “Don’t a lot of Chinese people own laundromats?”
Upon hearing this, Chris interjects with, “That’s a racist thing to say, you’re a racist.”

… later, Alex sees a headline proclaiming “Institutional Racism: why it’s our country’s greatest problem.”

What will Alex think now?

After Chris’ chastisement, Alex may just think that institutional racism consists primarily of ‘microaggressions’ and stereotyping.
If cops hear that a suspect works at a laundromat, and they go to Chinatown to look for him, that’s racism? This doesn’t seem like that big of a deal to Alex.

What’s next for Alex?
Will Alex become more or less ‘racist’ after Chris’ intervention?
Will Alex think that alleged ‘racist’ cops are truly a threat?
Will Alex be more or less likely to want to learn about different cultures?

Counting uniques: updated

I previously posted a script I wrote to count uniques. It’s kind of a crappy script. It can only draw values from an array (as opposed to multiple selected values in the sheet) and it just leaves 2 arrays, 1 with each unique value, and a corresponding array with the count of each respective value. So, 2 arrays of numbers. Not very useful unless you are 100% aware of and confident about what you’re doing, and I certainly am not. So here’s a better script.

Use this in a google apps script bound to a spreadsheet. With the onOpen function, a menu will appear in the spreadsheet itself and you can run the function from within the document (as opposed to running it from the bound code.)

This will log each value and its corresponding count pretty clearly. Unfortunately, logs can only be viewed from the bound script editor, so I will update this code with something that will show an alert or HTML file within the spreadsheet so one can run the function and get the results without being forced to open the script editor.

function onOpen(){
var ui = SpreadsheetApp.getUi();
ui.createMenu('Counting')
 .addItem('Count instances', 'countSelected')
.addToUi();
}

function countSelected(){
var sheet = SpreadsheetApp.getActive().getActiveSheet();
var range = sheet.getActiveRange();
var row = range.getRow();
var col = range.getColumn();
var lastRow = range.getLastRow()
var numRows = range.getNumRows();

var rclr = 'Start row: ' + row + ', Column: ' + col + ', Last row: ' + lastRow + ', Number of rows: ' + numRows;
Logger.log(rclr)

var selectedVals = []
for(var a = 0; a < numRows; a++){
var thisRow = row + a;
var thisValue = sheet.getRange(thisRow, col).getValue();
selectedVals.push(thisValue)
}

var arr = selectedVals;
arr.sort();
var uniques = [];
var instCount = [];
var prev = '';
var arrCount = arr.length;
for(var a = 0; a < arrCount; a++){
if (arr[a] !== prev ) {uniques.push(arr[a]); instCount.push(1)}
else {instCount[instCount.length-1]++}
var prev = arr[a];}


for (var b = 0; b < uniques.length; b++){
 var variable = uniques[b];
 var instanceCount = instCount[b];
 Logger.log('There are ' + instanceCount + ' instances of the variable ' + variable);
 }
}

 

Count instances of each unique item in an array

This is a script I wrote for Google Apps Scripts:

function oreGon(){
var arr = [ 1, 1, 1, 1, 1, 1, 1, 3, 3, 1, 4, 9, 1, 2, 0, 7, 8, 1, 2 ];
arr.sort();
var uniques = [];
var instCount = [];
var prev = 666;
var arrCount = arr.length;
for(var a = 0; a < arrCount; a++){
if (arr[a] !== prev ) {uniques.push(arr[a]); instCount.push(1)}
else {instCount[instCount.length-1]++}
var prev = arr[a];}
Logger.log(uniques)
Logger.log(instCount)
}

Letter to Waste Connections TN

(Websites that allow you to contact them often use text forms in the pages themselves, so there’s often no record of your email. So I’m going to start posting pastes of the emails I write so that I have those records here)

Hi, I recently purchased a new house and I’m trying to figure out what’s going on with the trash pickup.

I’m not sure if my house is in the city or the county, it’s hard to tell from the maps because I think I’m right near the border.

You all have picked up my garbage one or two times, but I don’t know if that’s just remaining from the previous owners’ account.

What do I need to do to get the account for my house set up in my name? What is the cost?

On Art, Creativity, Etc.

It’s Friday, October 6, 2017. I’m at Lonesome Dove in the Old City area of Knoxville.

Not to be confused with Downtown Knoxville. There is a HUGE difference between the two and I would never be silly enough to mix them up… just kidding!

I met a lovely lady this evening named Cindy. As usual, because I was out in public and it terrifies me, I was drawing on my iPad. That’s what I do. Anyway, this woman complimented me on my “art,” saying she couldn’t possibly do anything similar.

This always upsets me. Sometimes I am creative and artistic, but when I am “drawing” on my iPad, 9 times out of 10 what I’m doing is really simple. Anyone could do it if they spent 5 minutes using the drawing app (with an open mind).

Here is the “picture” I was “drawing.” I think it turned out pretty cool, but I had to start over like 20 times to get it to where I liked it (and I’m not even 100% sure it’s done).

Anyway. I think anyone can create something beautiful, especially given the magic of technology. If you ever see me out in public, I would love to let you try my iPad so we can see what you come up with. It’s fun!