|
I am not sure I could code with background music. I must admit I never tried.
I only code as a hobby so production is at my pace. Former job in the hospital someone always
interrupting while working with questions but that is what I got paid to do so not complaining.
My house is semi-remote in Arizona. Half a mile down the paved road in front of my house the road
turns to dirt. When I moved here in 1995 there were about 10 homes that direction. Today the count is
about 20 homes. They are all in the $500,000.00 range and up. Across the street for 14 miles is
Apache reservation. No homes nothing but old tall pine trees a few wild horses and a bear that likes
to maul my trash container from time to time. No more than 20 cars go by the house in a day.
While my office has a 5 ft wide by 4 ft tall window I enjoy the view from time to time.
The 3 ft diameter Alligator juniper and 15 Pine that are about 50 ft tall in the front gravel
(we do not have grass) do block the view a little. After years in an apartment beside the Interstate
I do enjoy the solitude and quiet. If you what a peek at the area Google Maps Live Oak Drive Lakeside,AZ
|
|
|
|
|
Arizona you say?
I'm near the Chandler mall and I can see some buildings at ASU from my desk.
Also South Mountain and some great sunsets.
|
|
|
|
|
Greetings and Kind Regards In a previous time I listened to radio . I don't recall now if it was NPR news or my favorite local Classical station at the time but under the advice of Marie vos Savant I turned it off . I now find myself distracted w/o quiet . However I always plan on Fridays to listen to listener call in requests at WCPE as the requested pieces are the usual favorites but I always forget except this time as your post reminded me which is why I am listening to it now . Thanks for the reminder . Cheerio
|
|
|
|
|
Well according to the Pandora algorithm:
Haunting vocals with a hard driving base line and screeching guitars with Rock and Roll and Blues Rock roots.
Hmmm. Yeah that sounds about right when I think about it.
|
|
|
|
|
I had no idea that you could view the AI's data on you. Now I'm going to check Spotify for this info
|
|
|
|
|
Furrowed brows over the features (9)
(Am going to be offline now till around 3 / 3.30 so bear with me!)
modified 27-Jan-22 6:08am.
|
|
|
|
|
Like it!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I'm surprised no-one else did, but I'll take it:
HEADLINES!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Indeed! IYTT then....
|
|
|
|
|
It was features that stumped me - but I suppose headlines are features
"Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
It's meant to be a double definition: Furrowed brows are head lines and appear above the "features" i.e. face (though yes, can form part of the features). In a magazine / paper / webpage, the headline goes over the feature.
I was hoping to cause a few furrowed brows - looks like I did!
|
|
|
|
|
It was a good clue Derek
"Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
I'm no Excel wizard, and I've been presented with a spreadsheet with a problem that's been bothering me. I promise this is not some homework.
Let's say there's a total amount of money (T) to be inherited, as part of a will, by N number of people. Different people are given a fixed percentage. Say there's 10 people named in the spreadsheet--they don't all get the same percentages, but the total allocated (as a percentage) has to add up to 100%.
Bob is one of those people, and he's supposed to get 15% of T. But if Bob dies, his 15% share should go back to the pot (T). If we simply delete the row that defines Bob and his 15%, we'll end up with an "unallocated" 15% (for lack of a better term).
How would you even set up a spreadsheet so if a row is deleted whenever someone dies, the percentages for the remaining recipients are automatically increased by an equal amount?
Assume whoever is using the spreadsheet (not the one who wrote it) only has enough knowledge to fill in the value for T, and deleting rows.
I'm starting to think Excel's built-in formulas aren't sufficient for this, and this is where you have to get into automating Excel. Blech!
|
|
|
|
|
Where "tots" is the cell having the total inheritance, and "recipients" is the range with the names:
=tots/rows(recipients)
(at least it worked with a quick and cheesy test(tm))
TTFN - Kent
|
|
|
|
|
Huh. Show how little I know about Excel.
|
|
|
|
|
Excel is a seriously good spreadsheet, and can easily be mismanaged to the point of terminal stupidity.
An ex-boss had an Excel file that ran the whole company: stock control, human resource allocation, BOM, ordering, the whole nine yards. It started as a quick and dirty stock inventory ... and grew like topsy to the point where it took 20 minutes just to load ... and seemingly forever to update.
But it worked. And there wasn't even VBA to help in those days, it was all cell formulae ...
I did try to convince him to move to a DB, but then he dragged out a stack of Basic floppies and I changed my mind.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Cost Accounting is unique to each company. Don’t ask me why or how but we had to pay our software vendor a goodly sum of money to modify their cost accounting package to meet our needs. Then I found out that one $600 million company in our neighborhood in Silicon Valley was running its cost accounting on spreadsheets.
Don’t ask me how you can have anything other than Last-In-First-Out (LIFO), First-In-First-Out (FIFO), or Average Cost as the methods of valuing inventory but accountants manage to tell you that their company is uniquely different.
And I had enough on my plate as an IT Manager that I left it to the cost accountant and our software vendor to work out what should be done and I merely signed off on the contract and on the final invoice. The software vendor was sufficiently honest that we had no cost or schedule overruns.
The other area that you will find where spreadsheets are used is Sales Forecasting. After paying $50,000 to buy a basic package, we spent $200,000 modifying it and then threw it out. There is no pleasing salescritters.
|
|
|
|
|
OriginalGriff wrote: I did try to convince him to move to a DB, but then he dragged out a stack of Basic floppies and I changed my mind.
At one point I wrote an automation tool for generating reports from a spreadsheet like that - it was designed by a bookkeeper. It actually wasn't as bad as you might think, as the bookkeeper was good at her job, and it was very organized.
I wasn't about to move her to even Access, given her lack of tech background. She wasn't great with computers, excepting Excel and QuickBooks.
In another case, I stored invoice data in a flat file in CSV format for a cab company that didn't even have Office.
I believe in meeting people where they're at. It's *my* job to make it work with *them*, not to make them work around what I built. At least that's how I see it.
When I'm doing requirements gathering for people and situations like this, I have them walk me through their job.
Then I design something that works with the way they already operate, and streamlines it.
Real programmers use butterflies
|
|
|
|
|
Hey, I wrote my first few database engines using QuickBasic 4.5, on floppies.
If you think 'goto' is evil, try writing an Assembly program without JMP.
|
|
|
|
|
OriginalGriff wrote: Excel is a seriously good spreadsheet, and can easily be mismanaged to the point of terminal stupidity.
I keep hearing that Excel's probably the program that has been the most twisted and abused to do things it was never intended to do.
I have no problem believing that.
I just wanted to make sure I didn't get into that rabbit hole when I asked my question.
modified 27-Jan-22 11:26am.
|
|
|
|
|
columns: name, gets share (1 or 0), base share (percentage), intermediate value (percentage, needs better name) actual share
columns A, B, and C are user entered.
column D is a formula = B2*C2
column E is a formula = D2/SUM(C2:C#) where # is the last row with data in it.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
|
|
|
|
|
Now that's the sort of answer I can deal with. I like the original reply I got, but still haven't taken the time to figure out where I would use that equation.
|
|
|
|
|
dandy72 wrote: increased by an equal amount
That doesn't sound right.
|
|
|
|
|
What I think I should've said here is that if Bob (worth 15%) dies, and there's 15 people left on the list, Bob's 15% should be redistributed equally among those 15 people - so each person gets an extra 1%. If there's 30 people, they all get an extra 0.5%.
|
|
|
|
|
That's what I thought, but it seems to me that if Alice is due a 50% share of T, that she should get 50% of Bob's 15% share of T.
|
|
|
|