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. 🙁
I love the Peppermint Swirl Dress, and I’ve made a few of them for Anya. The 5-year-old size easily fit within four yards of fabric — two yards of each colour. The 8-year-old size fit easily in six yards of fabric — three yards of each color (and about a half-yard of one color was left over, the half-yard from the other was used for the top of the dress). I think the 10-year-old size will be tight with six yards of fabric … but it’ll be a few years before I know for certain 🙂
For some reason, the audio on Scott’s Fedora laptop falls over (maybe when coming out of sleep?) The playback device gets set to some ‘dummy’ device and he’s got no sound. Solution — from his user account, run:
systemctl --user restart pulseaudio.service
I’m writing this down mostly to remember that I have built the latest flite instead of using the version from the Fedora repository.
git clone https://github.com/festvox/flite.git cd flite ./configure make
Voila, the compiled binaries for flite are in ./bi