Anya and I came up with a new card game — sum war. It’s a bit like war, but you throw two cards. The person with the higher sum wins all of the cards & puts them on the bottom of their stack. Keep going until someone has all of the cards. There’s obviously lots of addition involved, but the game uses estimation too (I have a 5 and a 7, you have a 5 and a 9 … you win without actually adding anything).
“People like things that socialism gives us, but as soon as you *call* it socialism, a lot of people stop liking it.” — this is one of the biggest problems I’ve seen in modern politics. Medicare recipients, for instance, demanding the gov’t keep its ‘hands off’ *their* Medicare. Not sure if that’s ignorance and people actually don’t realize these things are government-provided or the whole cognitive dissonance thing where someone just cannot reconcile decades of anti-Soviet fearmongering with “it’s not a bad thing to ensure old people don’t go bankrupt dealing with an illness”.
The Democratic party has a serious branding issue — Republicans manage pithy phrases that make people who don’t bother digging into the details support awful ideas — one of the Bush’s Clean Water Act, which was more or less legislation to avoid clean water. But how are you *against* clean water?!? Abolishing the “death tax” that you only incur on multi-million dollar estates. But you *want* to tax grieving kids!?!? The masses don’t want to get into nuanced details, great. Seems like the Democrats could spend some time with a few marketing guys and come up with catchier names for populist socialist ideas. Compassionate capitalism — are you against compassion? Or capitalism? The horror!
Let’s be forthright — those who disparage socialism promote their own type of socialism. It’s the difference between corporate socialism where capital is transferred to massive corporations (oil subsidies, agro subsidies, bank rescues) and populist socialism where capital is transferred to individuals (Medicare for All, free public Uni tuition, incentives to install personal electrical generation facilities).
Cleveland Scene provides an interesting look at the bail process — something I think a lot of people don’t have any experience with — and an organization that pays bail for individuals who cannot afford it. I didn’t realize bond had fees. Which is, I admit, because I’ve spent more time watching some guy on A&E chase down fugitives than I’ve spent thinking about the bail bond business model. I’ve bailed a few friends out – it’s been years, but I think I had to swing by the bank and get actual cash instead of a cheque. But that’s the sum of my experience — friend did something silly and illegal, spent a few hours between the courthouse and jail, and I swung by with cash. They go to the trial, get their fine / community service assigned, and the gov’t posts me a cheque.
Now, I realize bail bond providers are operating a business. And there’s no way that my model where I hand over a grand and get a grand back six weeks later is a valid business model. But it’s always been in my head that bond is like 10% of the bail, so for a 5k bail, you temporarily need to come up with 500$. You need to come up with 500$ today, which may not be possible. But you also get back 90-95% of that five hundred bucks. And that’s how the bail bondsman earns money.
I don’t use composer often, and it generally just works … so I don’t know much about it beyond “another package manager”. But every once in a while, it just hangs. Nothing happening, nothing instructive in strace. Fortunately, composer has several levels of verbosity on the output. While the default output is minimal and offers absolutely no clue that it’s doing something … adding -vvv is a nicely verbose output that lets me see that the package install isn’t actually hung. It’s just going to take a long time.
We came up with a new card game today — something to practice adding and subtracting (and mathematical thinking). Deal x cards (we’ve had five and seven to start). The remaining cards are the ‘draw’ pile. Flip one card over. Try to come up with an equation using the cards in your hand that combine with the flipped card to make an equation. Aces are 1, jacks are 11, queens are 12, and kings are 13.
There’s a King up — you’ve got 2, 5, 8, 9, and Q. 12(Q) + 9 – 8 = 13(K). You select one of the cards in your equation to place on the top of the face-up pile. The next person then tries to create an equation using the card you laid down.
Zero is a little special — there’s a some card up, x. If you have two cards of the same value, y. X plus Y minus Y equals X … and you can discard one of the cards you used in your equation.
If you cannot form an equation, you draw a card. The game ends when the face-down pile is exhausted. Add the values of the cards in your hand, and the person with the lowest value hand wins. This means you probably want to discard the highest value card in your equation (unless there’s a strategy to having the card — if I have an equation with 5 and 10, but have another 10 in my hand … I might want to hold on to the ten because the two tens are a 0 and are a guaranteed play).
This approach can use “where COLUMN_NAME like ‘Something%’ too:
select COLUMN_NAME from ALL_TAB_COLUMNS where TABLE_NAME = 'TableName'
I need to programmatically parse an Excel file where items are grouped with arbitrary group sizes. We don’t want the person filling out the spreadsheet to need to fill in a group # column … so I’m exploring ways to read cell formatting so something like color can be used to show the groups. Reading the formatting isn’t a straight-forward process, so I wondered if Excel could populate a group number cell based on the cell’s attributes.
While it is possible, it’s not a viable solution. The mechanism to access data about a cell cannot be accessed directly and, unfortunately, requires a macro-enabled workbook. The mechanism also requires the user to remember to update the spreadsheet calculations when they have finished colorizing the rows. While I won’t be using this approach in my current project … I thought I’d record what I did for future reference.
We need to define a ‘name’ for the function. On the “Formulas” tab, select “Name Manager”.
Provide a name – I am using getBackgroundColor – and put the following in the “refers to” section: =GET.CELL(63,INDIRECT(“rc”,FALSE))
Now we can use this name within the cell formula:
Select the rows for your first group and change the “fill color” of the row.
Repeat this process to colorize all of your groups – you can re-use a color as long as adjacent groups have different colors. Notice that the “ColorGroup” values do not change when you colorize your groups.
On the “Forumlas” tab, select “Calculate Now”
Now the colorized cells will have a non-zero value.
We finally got around to calling Progressive about the difference in my quoted price v/s their renewal price … ugh! The first person we spoke to started out with ‘just cancel the old policy & open the new one’. Which, great — except it’s a pain. And we lose the ‘perks’ that come with being a long time customer. Including some 250$ off the deductible. Start a new policy, have the bad luck to get in an accident, and saving 150$ just cost me 250$. Not a great deal, that. Plus our home insurance is tied in with the car insurance. And the only reason I didn’t just buy insurance from GEICO (who had the lowest quoted price) is that I didn’t want to screw with the home insurance right now.
Luckily, she transferred us to an insurance agent for help. He checked and there was no way they could price the policy we had at the price quoted under my name. He was able to move the reduced deductible over to the new policy (although it’s still a pain that they have no provision for just swapping the names … and it’s even more of a pain that the person listed first makes such a difference in pricing!). Final price was 164$ for more coverage than the policy they wanted 321$ !?!?! Only took an hour and a half to get there! And I’ve got a really bad feeling the same thing can be done with the homeowners insurance. 🙁