Search results for

#Excel

#1 Click this link to see Blog page --> 03/24/2011

I spent a couple hours working on an #Excel program for Tracey at work. They changed the policy on Care Plans and she needs something to keep track of when the Care Plans are due or when they were last completed.

Typical corporate bureaucracy to create complicated and convoluted policies that are very difficult to keep track of.

MjL

#2 Click this link to see Blog page --> 03/25/2011

I spent a good deal of time working on Tracey’s #Excel program. I think I made some improvements and this time I locked everything so when she lets the employees use it they can’t change things —— accidentally or otherwise. I actually enjoy doing that stuff, I just wish I could get a job somewhere and get paid for it!

MjL

#3 Click this link to see Blog page --> 11/15/2013

I spent a good deal of yesterday morning getting an #Excel program set up for Tracey to keep track of scheduling her employees for next year. I emailed it off to her hoping it would work OK, but we really won’t know until she starts using it the end of next month.

I had a little trouble wrapping my head around the idea that the first pay period in 2014 is in December as they don’t get that pay until January.

MjL

#4 Click this link to see Blog page --> 02/01/2014

Tracey has a bunch of “year end” stuff to compile and tabulate for work and she asked me to write an #Excel program to help her figure out last year’s patient census for the year. She also wants to make it easier to keep track of all this stuff for the future as well.

They are supposed to keep track of things like gender, age group, ethnicity, race, and a variety of classifications of patient status such as new patient, transfer in or out, got a transplant, died, ETC.

It took me most of yesterday to figure out how to make it all work and we stayed up until midnight last night populating this spreadsheet with data for the year 2013.

Tracey has been going crazy looking for 1 category that is off by 1 person. We found him! Evidently somebody at #Medicare or #Fresenius or whomever decided this guy was dead or gone or whatever.

Medicare has killed off some of her patients over the past months and she has to call Medicare up and resurrect the patient’s information in the database.

MjL

#5 Click this link to see Blog page --> 03/24/2016

Over the past few years I have helped Tracey with various #Excel spread sheets and Word documents for her work. Recently Fresenius upgraded the Office software and my old Office 2000 program can’t do anything with it.

Yesterday I upgraded to the most recent Office programs. I spent most of the day wading through all the pretty interface changes and #ArtsyFartsy “themes” and “backgrounds” to sort out how to manage the migration. What fun. I miss the days of purely functional software without all the pretty and flash slowing things down.

I feel a little dirty about giving #Microsoft more of our money but I think the support I have given Tracey has helped her to stay more organized at work. Or perhaps that is just a good way to rationalize the expense so I can play with new software?

MjL

#6 Click this link to see Blog page --> 09/28/2016

Although we have a few credit cards there are only two we use with any regularity. The #DiscoverCard for the vast majority of our purchases and a Visa card for those places that won’t take the Discover.

I have an #Excel workbook I use to record our finances with separate sheets for all of our accounts. I have written Virtual Basic Scripts for a few of these to automate my entries. I can just copy from the website, paste it into the Excel sheet and the macro parses it all out and enters data into the various columns.

I have no trouble with any of the various accounts —— except for the Discover Card account. They change the web page regularly to include all manner of BS advertisements, etc. So I have to rewrite my script every 4 to 6 months to weed out the unnecessary nonsense to properly parse the copied text. It seems the marketing department has more control over the web site than does the accounting department. Typical I guess.

I spent about an hour yesterday morning sorting out a particularly nasty change they recently made to the site. It is no wonder they can’t keep the page up to date when they are so busy cluttering up the statement page with irrelevant junk.

Update: 09/28/17
Because of this and the inability to use Samsung Pay we have moved away from Discover Card almost entirely. We used to spend several thousand dollars a month through them and now less than a hundred

MjL

#7 Click this link to see Blog page --> 10/14/2016

I got sidetracked yesterday creating an #Excel spreadsheet for Tracey. I am afraid I neglected my Internet and Blog duties as a result.

It has been a while since I’ve built one from scratch. #Microsoft has altered a lot of the VBS code in the latest edition of Excel. Msoft has a policy that if it ain’t broke they have to break it.

One particular quirk I discovered really makes no sense. I made a subroutine to add comments to a cell. The command to select the new comment block causes the NumLock key to shut off. It took me a while to figure out that was causing it. I went to trusty Google to find a fix and discovered this has been a known bug since 2010 and Msoft has made no effort to fix it. WTF? It’s not like you use a number pad to enter data into an accounting spreadsheet?

MjL

#8 Click this link to see Blog page --> 10/29/2016

Just so I don’t go the entire day without an entry —— I’ve spent a lot of today working on an #Excel spreadsheet for Tracey. She has to coordinate numerous overlapping class schedules for a project for the region. They are trying to create a new master schedule that will start new hires every three weeks so there is less time between hire date and first class scheduled into the education pipeline.

MjL

#9 Click this link to see Blog page --> 10/30/2016

Spent about another hour on Tracey’s #Excel sheet for her “Class Schedule” presentation. We even ironed out a few conflicts with holidays throughout the year. Now she needs a #PowerPoint to go with it because you can’t do a meeting without a Power Point!

MjL

#10 Click this link to see Blog page --> 12/06/2017

Use it or lose it. I haven’t done any #Excel spreadsheet programming for Tracey in over six months. She wants me to help set up a new spreadsheet to track her new hire training schedules.

It’s going to take me a while to get back into it because I don’t remember how to do some things. It doesn’t help that the #ArtsyFartsy crowd at #Microsoft rearranges the menus in each new version of Excel.

MjL

#11 Click this link to see Blog page --> 12/17/2017

I got a bit sidetracked yesterday. I was working on Tracey’s spreadsheet for work and didn’t get back to the Blog. I need to keep working on both of them to get them ready for the first of the year.

This new monitor makes it much easier to do side-by-side comparisons of spreadsheets. Unfortunately I am still struggling with #Excel. I am using a newer version than before and all the menus have been changed and rearranged. I sure wish they would quit trying to make it pretty and just make it more functional.


Aaron dropped by for a short visit yesterday. As always it was good to visit with him. And we are all looking forward to Ben arriving later today. We probably won’t see him until tomorrow but he should be staying with Aaron tonight.

MjL

#12 Click this link to see Blog page --> 05/30/2019

Tracey worked from home yesterday and we spent some time working on an #Excel spreadsheet to help her keep track of the progress of the students.

One of the aggravations of the latest Excel programs is the proliferation of themes, fonts, font sizes, colors, etc.

Every time I would cut & paste something there were unwanted changes in appearance and format.

I long for the old days when a spread sheet was made to be functional.

Now it has to be pretty too.

MjL

#13 Click this link to see Twitter Roundup page --> 04/13/2022 #4

#Excel used to be a straightforward spreadsheet.
Now it is riddled with useless features.

MjL

#14 Click this link to see Blog page --> 08/17/2023

#Fresenius #Excel #Blog
Tracey’s employers have rearranged her region (again) and she needs some help rebuilding spreadsheets for the students, clinics, educators, learning centers, etc. I will be spending some time building and populating some data for her. The Blog may suffer.

MjL

#15 Click this link to see Blog page --> 08/18/2023

Once again I am confronted with the half-assery of #Microsoft software. I am building a large #Excel spreadsheet for Tracey. It has a main page with over a hundred employees and their data. Each employee also has a worksheet tab to record notes and information pertinent just to them. I decided hyperlinks would be the best way to connect these pages.

The first thing I noticed was that the hyperlinked text would change font size, and be underlined. A followed-link changed color. I spent at least a half-hour researching to discover buried behind several click and right-click menus this could be changed. Somewhere in the dumbdom of software engineering it was decided hyperlinks are to treated as separate styles. Next I discovered these changes weren’t permanent unless the theme / style was saved. Nowhere is this information to be found in the help files and are definitely not user friendly or intuitive. AND, as is typical of Msoft, it all depends on which version how the menus are rearranged idiotically to make changes.

After getting that all figured out I discovered the links are NOT permanently linked. (What good is that?) If rows on the main page are sorted, filtered, added to or deleted from —— the hyperlinks are still anchored to the OLD cell location before the view was altered. The link on the master will always take you to the proper tab, but the tab links back to the master page will be corrupted and you have to search through them to get to the row you started from anyway.

MjL

#16 Click this link to see Blog page --> 08/20/2023

#Fresenius #Excel
I have more rants and observations about the use of spreadsheets where Tracey works. Far too many people can enter, alter, or delete data and there seems to be little control over the format of how they do so. Many, if not most, of these users are almost clueless about how spreadsheets manipulate data.

For instance, let’s say you were to add information in a column for the clinic in East Peoria. In a controlled format a dropdown list would be provided to choose from, and if “East Peoria” wasn’t a choice, you would have to add it to the list of choices. This prevents multiple spellings (or misspelling) of the same name. Otherwise, you could search, sort or filter on “East Peoria” but the results wouldn’t include “E.P.”, “EP”, “E. Peoria”, etc.

AND —— some people have a proclivity to “correct” names in the dropdown list, thus creating multiple errors. Changing the listed entry only changes future use and the original entry will remain on the multitude of previous entries.

Her employee spreadsheets are littered with various spellings and variations for multiple places, names and events making it impossible to trust most of the data. We have wasted so much time sifting through this to create a more accurate spreadsheet for her use and there is no way to correct the corporate source for the benefit of others.

MjL

#17 Click this link to see Blog page --> 08/21/2023

#Fresenius #Excel
Tracey and I finished up entering most of the data into her work spreadsheet yesterday. She will have to start filling out the rest of the blanks going forward. I emailed it to her and closed it out to my archive. Unless she finds something I need to change, it is all hers now.

So much information to keep track of for so many people!

MjL

#18 Click this link to see Blog page --> 10/28/2024

Over the weekend we worked on a couple of #Excel spreadsheets for Tracey to keep track of students at work. Once again I was frustrated with the menu and function changes. I am convinced the software engineers never actually USE the software they design. There are still major glitches with hyperlinks and data validation. You can make it look pretty though.

MjL

#19 Click this link to see Twitter Roundup page --> 08/22/2025 #2

#Microsoft #Excel

MjL