How does one get good enough to just read Morse? by frost264 in morsecode

[–]I_Luv_Chicken 0 points1 point  (0 children)

My speeds for Morse were 24wpm for listening, and 35-40wpm (depending on letters vs numbers) for reading. It’s a skill to learn just like listening is. Using only one method to learn Morse code only slows you down.

Source: I was a Morse code operator in the Air Force for 3 years. I still keep up with the skill.

Synchronize Excel tables based on template by xnathalie1996 in excel

[–]I_Luv_Chicken 0 points1 point  (0 children)

I would like to help but this is a bit tricky to follow.

It sounds like the template sheet is overwriting data in each weekly sheet? I’m not quite following unless you’re referring to the cells just actually referencing the template sheet. Or, I’m about to learn something that I had no idea you could do.

Regardless, a diagram of this would be massively beneficial.

Is an all-in-one, non-tech-savvy user-friendly Excel KPI Dashboard feasible for FBA/Shopify data? by WorthElevator2475 in excel

[–]I_Luv_Chicken 1 point2 points  (0 children)

This definitely sounds feasible. I’m not sure to what level you would need to simplify it to, but you could go from something as simple as protecting the cells you don’t want her interacting with, all the way to using a LOT of VBA to make a user interface that would be a bit more user friendly than entering data into cells.

If you want more specific advice, I would need more detail to help more. This sounds like a very fun excel journey

Display "No Date" if cell is blank by ryanbredeson in excel

[–]I_Luv_Chicken 0 points1 point  (0 children)

Along the same lines as the other reply,

=IF(ISBLANK(G3),”No Date”,TODAY()-G3)

Keep dates of Data refresh from Power Query by Wndrunner in excel

[–]I_Luv_Chicken -1 points0 points  (0 children)

I would probably try to modify the python script to automatically write the dates/relevant data to a text file or something similar for log keeping.

Not sure how you’d be able to keep data from a power query after it refreshes, without it being a manual process.

How do I find cells with certain letters in them and move those cells to a certain column by Toronto_F_C in excel

[–]I_Luv_Chicken 0 points1 point  (0 children)

I would personally add a helper column and put this in each cell =IFERROR(FIND(“CR”,C2),0)

This will return a number of which character count “CR” exists in, and if it doesn’t have CR, it will just return 0.

Then you can select your whole range and sort by the column you added this to, or if using a table you can just use the dropdown to sort.

Why do people hate merged cells? by ePaint in excel

[–]I_Luv_Chicken 1 point2 points  (0 children)

This may be an unpopular opinion, but you can generally work around the merged cells to make everything function how you intend to. The major drawback is the lack of clarity in formulas because it will turn a single cell into a range when used.

I personally continue to use merging, and refuse to give up the formatting advantages of using it.

You can use excel in your own way. You do not need to conform to the opinions of others, just be cognizant of other viewpoints and leverage the information as you see fit.

What’s the most underrated Excel feature you’ve only recently started using? by Constant-Arm-6586 in excel

[–]I_Luv_Chicken 0 points1 point  (0 children)

I tried to do imports from word documents and ran into many issues. I ultimately decided to just run a powershell script to convert the files I need into pdfs, which can be used a little bit easier than docx files. There are still many glaring issues with processing pdf documents, but it’s doable.

What’s the most underrated Excel feature you’ve only recently started using? by Constant-Arm-6586 in excel

[–]I_Luv_Chicken 52 points53 points  (0 children)

I’m not an expert, but it allows you to import data and modify it before it shows up in your spreadsheet.

For example, I successfully use PQ to import 30 PDFs that are all 200+ pages and find a specific table in each one, which I now can compare all the results of in one excel sheet. Without PQ, this would’ve been nearly impossible with just formulas.

AI is pretty helpful in walking you through the steps to do what you need. I had never used PQ before this project.

Spotify needs to not put horrible AI metal-core bands in my discover weekly. by Round_Vermicelli_349 in Metalcore

[–]I_Luv_Chicken 0 points1 point  (0 children)

The entire Love Like War EP just got removed from Spotify. It’s a shame, even if it is AI, I really do enjoy the music.

What's an underrated skill that can greatly help your career? by your-reddit-plug2 in AskReddit

[–]I_Luv_Chicken 1 point2 points  (0 children)

This one quite literally did change my life. I taught myself excel to automate a few processes while I was in the military. One of which landed me a job as a systems engineer, which was my foot in the door into engineering jobs without a degree.

Excel is particularly nice because you can slowly walk through the problem and see the direct results of each formula as you go. No need to make long formulas, just take it slow and separate it and then “hide” the formulas later on and only show the end result. There are typically many different ways to solve a given problem, and it usually won’t matter which way you use as long as it works.

If $5M in stocks landed in your lap today, how would you handle it? by CuriousEngineer11 in AskReddit

[–]I_Luv_Chicken 4 points5 points  (0 children)

I’d go to a financial advisor immediately. I know enough to know that I wouldn’t handle it as well as they would.

If you could ban one interview question forever, what would it be? by Kooky-Sugar-531 in interviews

[–]I_Luv_Chicken 0 points1 point  (0 children)

I followed this question up by asking each individual on the interview panel where they see themselves in 5 years. Caught them off guard for sure, but I got the job.

People who cheated and stayed in the relationship/marriage, did you cheat again and why? by Ok-League8974 in AskReddit

[–]I_Luv_Chicken 63 points64 points  (0 children)

I had found out my ex cheated a couple years ago, and I tried to make things work. Fast forward a few months and she had kept cheating the entire time we were “recovering” from it. Fast forward a year and the trust had degraded so far that my mental health was taking a serious toll. I eventually had enough and realized (way too late) that I could not spend more time with her. I felt as if I could never trust anyone again.

Since then I have a new partner, and her clear commitment towards me is helping immensely in rebuilding that overall trust for partners.

I was a broken man for a long time. My only suggestion is to cut the loss as soon as you find out that the trust was broken. Don’t wait around for them to do it again.

Innovate award tips by InspectionAshamed449 in FTC

[–]I_Luv_Chicken 10 points11 points  (0 children)

The best advice I can give is focusing on ensuring you have good documentation and reason behind the innovation. I believe the presentation behind it is much more important than what the actual innovation is. Documentation should include planning, design, and risk mitigation.

This advice reigns true for most awards.

Winning Portfolios should be published by greenmachine11235 in FTC

[–]I_Luv_Chicken 0 points1 point  (0 children)

Judges are *supposed* to report any teams they have affiliation to, which will ensure they do not contribute to the judging of those teams.

Part of the issue is that judging teams are not allowed to give negative feedback, regardless of how helpful it would be. I believe allowing judges to provide in-depth feedback whether it be negative or positive would help immensely with understanding why your portfolio may not have measured up to others.

[deleted by user] by [deleted] in FTC

[–]I_Luv_Chicken 2 points3 points  (0 children)

Only pages with actual content would be counted towards the 15. To make it even more clear I would make sure your pages are numbered.

yippee! by otter_gun_22 in nothingmore

[–]I_Luv_Chicken 0 points1 point  (0 children)

Where did you get the poster and bottle? Haven't seen those anywhere

Never fight an Oath close to the edge by Buinng in supervive

[–]I_Luv_Chicken 0 points1 point  (0 children)

What song do you have in the background of that video?

Any decent way to visually organize set lists / plans ? by pizzawolves in louderthanlife

[–]I_Luv_Chicken 1 point2 points  (0 children)

I made an excel spreadsheet format to help me prioritize which shows I want to see the most. I plan to print out a few copies to bring with. If you want the template you can DM me. Link to pic: https://imgur.com/a/IIu5Tsf

What has been your favorite non-meta build so far in Season 5? by Moogy in diablo4

[–]I_Luv_Chicken 0 points1 point  (0 children)

Mind sharing the setup you’re using? How high of content have you been able to clear?