August 7, 2020 at 1:20 pm
I have a standing offer on LinkedIn to promote anyone looking for work. I'll double down on that for Threadizens. I can actually say I know that you know what you're talking about. So Lynn, if you are looking, send me a link to your profile. I'll push it to my group. I also have a head hunter who was looking for people. I normally don't link to them, ever. However, she was smart enough to promote her involvement in Scouting in her request for a contact. I can't help but support Scouts. Anyway, I can also pass on the link to her.
Anyone else looking, same offer.
You ARE the MAN, Grant! I don't need your good services (at least not yet and hope I don't) but I've seen some of your posts on LinkedIn to endorse people looking for a job.
Lynn, do some of the things I recommended about your profile on LinkedIn and then, seriously, take advantage of Grant's good offer.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2020 at 4:27 pm
I have a standing offer on LinkedIn to promote anyone looking for work. I'll double down on that for Threadizens. I can actually say I know that you know what you're talking about. So Lynn, if you are looking, send me a link to your profile. I'll push it to my group. I also have a head hunter who was looking for people. I normally don't link to them, ever. However, she was smart enough to promote her involvement in Scouting in her request for a contact. I can't help but support Scouts. Anyway, I can also pass on the link to her.
Anyone else looking, same offer.
Grant, once I have my profile updated and checked I will be more than happy to take you up on your offer, and yes, when I do send you the link please pass it on to the head hunter.
Thank you.
August 7, 2020 at 5:56 pm
Lynn, a bit late, and sorry to hear you're unexpectedly looking.
A couple things to think about, besides the advice above.
Good luck. Reach out if you need help. I'll keep an eye out for stuff.
August 10, 2020 at 1:53 pm
OMG! The world has gone completely mad. If you still don't think that spreadsheets rule the world, read the following article. The "punch line" after the title of the article is "Sometimes it’s easier to rewrite genetics than update Excel".
https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates
This has been a known issue in Excel since the day it came out and they've still not made a provision for it. Talk about the "Big Blue" syndrome. Wow... just WOW!
--Jeff Moden
Change is inevitable... Change for the better is not.
August 10, 2020 at 2:10 pm
How would Microsoft actually handle this case though, without disabling the ability to convert MAR1 into the 1st of March for the rest of the users? If the trick would be to format the column for genetics or something, there are already formatting options that negate that activity. This action is probably useful to a large number of users, although I don't use it myself.
I think this is much ado about nothing on the part of the scientists. If they are too careless to format the spreadsheets correctly (like the rest of us have to do to preserve leading zeroes, etc. in daily work) then they have no excuse.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
August 10, 2020 at 2:12 pm
Honestly, why is it converting MARCH1 to a date in the first place. MARCH1 doesn't have a year, so it's not a date... Changing it to a date means it guesses/assumes the year; which is just as bad...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2020 at 2:17 pm
Excel is doing its best to be helpful, though this 'help' is often a hindrance to advanced users.
Turning off auto-formatting could, perhaps, be enabled as a spreadsheet-specific option, but that would not fix the export/import errors.
As almost everyone on this forum knows, Excel is a numerical analysis tool, and should not be used as a database in any professional situation.
August 10, 2020 at 2:24 pm
OMG! The world has gone completely mad. If you still don't think that spreadsheets rule the world, read the following article. The "punch line" after the title of the article is "Sometimes it’s easier to rewrite genetics than update Excel".
https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates
This has been a known issue in Excel since the day it came out and they've still not made a provision for it. Talk about the "Big Blue" syndrome. Wow... just WOW!
There is a word describing this, starts with a W and sounds like the name of an anti-drifting maritime device
😎
Just proves that some people are willing to buy things at a market without a haggle, a bit like MS-Excel subscription 😉
August 10, 2020 at 2:27 pm
As almost everyone on this forum knows, Excel is a numerical analysis tool, and should not be used as a database in any professional situation.
Why I think everyone on this forum will almost always ask for a CSV file for data; then we have control over the data types and processing choices of the Extraction Process. For the last time ACE, no, just because the first 10 rows have a numerical value doesn't mean that the column is a float! >_< Stop Assuming my column's gender data type; you're not allowed to do that in 2020.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2020 at 2:30 pm
How would Microsoft actually handle this case though, without disabling the ability to convert MAR1 into the 1st of March for the rest of the users? If the trick would be to format the column for genetics or something, there are already formatting options that negate that activity. This action is probably useful to a large number of users, although I don't use it myself.
I think this is much ado about nothing on the part of the scientists. If they are too careless to format the spreadsheets correctly (like the rest of us have to do to preserve leading zeroes, etc. in daily work) then they have no excuse.
Heh... it just wouldn't be that difficult to have a button in the ribbon bar to temporarily disable auto-magic date conversions BUT, you've hit the other nail on the head. Even scientists don't necessarily take the time to learn the tools they supposedly depend on. That's a part of my OMG factor at reading this article.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 10, 2020 at 11:52 pm
Hey Lynn,
Sorry to hear about your impending doom. Now that you know how to search within your company, hope that you can get something.
In addition to all the great advice given, I'll offer one more. Go on every interview that you can... even if you know that you don't want / will not accept that job. This gives great experience in those job interviews. Nothing relaxes you more in an interview than knowing that you wouldn't take this job, and all you want is this interview experience.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 11, 2020 at 12:30 am
In nearly 30 years of using excel there are very few situations that don't have a straight forward work around.
412-977-3526 call/text
August 11, 2020 at 2:59 am
Take a pdf of your monthly credit card statement, and use Adobe to convert it to Excel.
Then see what it takes to clean it up. Getting rid of the graphics is just a couple lines of code. The rest is a bit more challenging to get to just the cards used, date, where, and amount. Where my wife works, they usually need 24 months of this information in Excel to categorize for divorce mediation.
Initially, she thought it would be easy to copy and paste rather than key all this in. The first cell with data was 30 lines of data in one cell. Then there were merged cells, where when you removed the merging, resulted in data not always in the same column, plus varying columns being blank.
I got a nice little side job parsing this apart and making it usable. Faster and more consistent than keying it in. And with quick turnaround, they can take short notice cases they used to turn away.
Since some of this formatting is likely due to Excel ‘helping’ the user, it is a feature that works for me.
August 11, 2020 at 3:55 am
In nearly 30 years of using excel there are very few situations that don't have a straight forward work around.
Heh... I look at it another way...
In more than 30 years of using Excel, I've found there are very few situations that don't require a work around. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2020 at 1:12 pm
Excel: enable bad solutions
Access: implement bad solutions that require other bad solutions in order to function
PowerBI: Automate all the bad solutions with a bad process, and call it "data science"
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
Viewing 15 posts - 64,996 through 65,010 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply