For Stock Rigs Only

@FlyingWolfe

Got the adapter today. Thank you for your generosity.

 

Schweet! Welcome

 

After this week at work.....time for some fire and fireball. Beautiful cool evening we have going on

 

Good Morning

 

Howdy Maner

 

Me, the wife and my youngest daughter are going to pay a visit to see my 102 year old grandmother today. I saw her once in May (socially distanced and masked). But my wife and kids haven't seen her since Christmas (because of Covid). But the reality is...she's fading and opportunities to see her are dwindling.

 

Howdy Big Johnny

 

Sounds like something I did a couple jobs back. I had to reconcile payroll for about 2000 employees. When I was hired, it was done by hand. The job took two people 6 days. Since it was comparing two PeopleSoft database dumps (about 6000 different entries) two a third database dump from a different system. Wrote one Excel macro that pulled all the data we actually needed and outputted it to a new file. Second Excel would automatically import the remaining database output and run a comparison of the three different sources. Anything that was different, would spit out a report with those differences. Then I just had to reconcile that last report and file the corrections. Needless to say, got the job down to one person and two days. I was fired shortly thereafter (and subsequently rehired by a different department that wanted my skill set) because the boss was a Luddite and hated technology. She was forced to retire shortly thereafter. She messed up a accreditation report because she relied on paper instead of the active data on a shared report.

 

Anyone with a Tundra need a power tailgate lock kit? @FlyingWolfe maybe?

 

This one is reasonably simple. It takes an output spreadsheet from one of our systems, reads the range to copy/paste a couple of formulas into the appropriate number of rows on the report spreadsheet (because this report of health insurance enrollees could hold anywhere from 25,000 records to as much as 60,000 or more during open season), import the info into the report spreadsheet, vlookup the POI field to what organization it belongs to, then run a pre-configured pivot table to group the enrollees by org and POI looking for negative bill amounts (which would cause major reconciliation issues on the back end of our system.)

The spreadsheet is simple, the macro took me some work and studying. I’ve spent seven years with this organization dragging legacy payroll and account processes kicking and screaming from the old school, manual way to the world of spreadsheets. It has been contentious at times.

 

Evenin

 

spread sheets are simple.
That’s why our checks are always wrong.
Last week most of ours were off by 3 or 4 hundred dollars.

 

Hey Mark

 

Spreadsheets are only as good as the people that design and use them.

Might be a loose nut behind the keyboard.

 

Im always a fan of purpose built products that span multiple docs. Love that first feeling when you run your first report and it works properly.

 

Lol there are a lot of loose nuts in there everywhere... ROFLMAO..
Lol shit in, shit out...

 

Good morning stockers.

Doing a little wrenchin' on a buddy's wife's '13 Camry this morning. Not sure of the milage.....but it well north of 200k.

Oil change, spark plugs, serpentine belt, H11 Silverstar bulbs (his request), rotate the tires, check the brakes and install some OEM style aftermarket fog lights he bought. The 2nd set of Silverstars are for those.

There may be other things as I get into it....air filter, cabin filter, PVC valve, etc.

I would like to flush the brake fluid, cooling system and do a couple of DAFs on the tranny. But those will have to be another day.

 

Big John!!

 

Good Morning Folks