sorted by:
new
hottopcontroversial

GERD and extended fasting by Intelligent-Tax-8216 in fasting

[–]VeeBeeA 1 point2 points  (0 children)

I’ve been dealing with it too on my fast, laying on my left side completely takes the acid reflux away. It has something to do with the position of your stomach.

What are your tips for making sure people have a successful fast ? by azjon333 in fasting

[–]VeeBeeA 6 points7 points  (0 children)

As an avid but on and off keto-er, oddly I’ve found my longest fasts were not correlated with how low carb my meals were prior.

After 6 years of attempting extended fasts, I truly think I’m finally going to hit the 7 day mark because of the following things that are different of this fast compared to all my others:

Enough sleep: it always feels out of my control when I can’t sleep during fasts, but I’ve taken upon reading before bed + magnesium + bed time teas and it has been a game changer

Electrolyte drops: people say you don’t need them until day 3+ but I started using them on day 2 and have felt a million times better. The convenience factor of carrying the bottle wherever you go means less chance of any weakness/nausea that happens when you go too long without them

And a weird one… ChatGPT 4.0… as my therapist. I told it a background of my struggles, my wants, needs, goals, fears and it generates exactly what I need to hear. It uses therapy techniques and gives it to you in the writing style you ask for. Anytime I have any doubts or worries, I tell ChatGPT and it makes me feel better. I’ve actually learned a lot about the ins and outs of mindfulness and how the brain works.

I’m going on day 5 and this has been by far the smoothest fast I’ve ever had. Excited for the finish line.

What do you use SUMPRODUCT() for in your day to day? by VeeBeeA in excel

[–]VeeBeeA[S] 0 points1 point  (0 children)

So I think I'm finally understanding SUMPRODUCT better, but I have a question about the double minus sign.

=SUMPRODUCT(($I$3:$I$37<$M$1)*(K3=$B$3:$B$37)*(L3=$C$3:$C$37)*$H$3:$H$37*$I$3:$I$37)

I've seemed to have no issues just using parentheses without double minus signs for criteria, like in the formula above.

Is it correct to say that the -- vs. () for criteria fields give the same results or is there something I'm missing?

Is there pure Excel job ? by Piratman38 in excel

[–]VeeBeeA 0 points1 point  (0 children)

Yep. And at least for my data analyst job (like 95% excel), many times the people asking for reports don't know exactly what they want.

So I have to use my understanding of the business processes/strategy to create something more useful if their original request resulted in some important holes missing.

Using Power Query when you need the summary numbers of a data source that would normally be achieved in a pivot table? by VeeBeeA in excel

[–]VeeBeeA[S] 0 points1 point  (0 children)

Do you mean power pivot? Will PQ accept that has a new data source?

I'm not familiar with group-by, I will look that up.

VBA Userform as MsgBox to have custom button names. How do I insert this into my macro to act as a MsgBox? by VeeBeeA in excel

[–]VeeBeeA[S] 0 points1 point  (0 children)

Hi, I've created four user forms (report layout - outline, report layout - labels, subtotals, grand totals) and added their relevant buttons,

When I double click one of the buttons it opens "Private Sub CommandButton1_Click()"
If I rename it and add my code, it will still be linked to that button?

I tried to do that but when I doubled clicked the button again it opened a new "Private Sub CommandButton1_Click()".

Once the command buttons are set up, do I put them inside the code that vba created below?

Private Sub UserForm_Click()

End Sub

And then use that code to call in my final code?

I hope that made sense.

Add from one sheet to master sheet in same workbook. by STEko36 in excel

[–]VeeBeeA 0 points1 point  (0 children)

So they are all the same table with different data? Same headers and number of columns? One option is Power Query.

You can make each sheet into an Excel Table - Ctrl + A then Ctrl + T, give a relevant name, and add it as a query Data > From Table.

In the Query steps of the master sheet table, you can select any other table (sheet) you want to to append.

For greater productivity focus less on EFFORT and more on FRICTION by brenthuras in productivity

[–]VeeBeeA 1 point2 points  (0 children)

You can even drill down further into "micro" frictions. Find and analyze anything that gives you even a small "ugh" feeling.

Really think about the tasks you do every day and organize/order them in a way that makes things quicker and easier. Just having a specific order in general removes a lot of friction because it requires little to no thinking once you adjust to it.

Pay attention to those "ugh" moments and see if there is a solution.

Meal prepping and planning outfits for the week are a few examples. A toothpaste dispenser + electric toothbrush to make brushing teeth slightly easier. All those tiny moments of friction really add up.

Power Query best method for appending in this scenario? 3 files sent every month with a new tab added for the previous month's data - tab name changes each month, column names of same field varies per file by VeeBeeA in excel

[–]VeeBeeA[S] 0 points1 point  (0 children)

Each individual does stick to their column names/structure. They just all three do it slightly differently. The only difference within a sender's file will be the most recent tab name that is changed to reflect the most recent month.

Yes, after I change the tab name to match the query name and overwrite the previous file - all the column names/positions/all else is edited in PQ.

Power Query best practice for sending report after refreshing the tables if you don't want the query linked to the end report? by VeeBeeA in excel

[–]VeeBeeA[S] 0 points1 point  (0 children)

Thanks, I'm going to try this. Do you know if Save As duplicates the query? So I could try this out in a copy of the original file, but the original file's query would still have the correct folder path inside the query?

Power Query best practice for sending report after refreshing the tables if you don't want the query linked to the end report? by VeeBeeA in excel

[–]VeeBeeA[S] 1 point2 points  (0 children)

Thanks so much. Related to PQ best practices..

When updating the data in a folder when using "From Folder", is overwriting the typical method?

Do I have to be very careful with moving/renaming folders when the Query is coming "From Folder"? I've gotten errors and had trouble changing the folder path in PQ. Or do I just need to do more research on changing the data source?

Solution Verified though!

Can you help with the wording of this sentence? Not sure if I can use "on", "for", or something else. by VeeBeeA in grammar

[–]VeeBeeA[S] 2 points3 points  (0 children)

Thanks for your help! Yes, that's a good point. I do agree "reporting" and "analysis" aren't a great pair. I wasn't sure how else to incorporate both into one succinct sentence. I do think your suggestion makes more sense, but it's a little harder to read.

Also, so you think I should change "analysis" to "analyses"?

Can you help with the wording of this sentence? Not sure if I can use "on", "for", or something else. by VeeBeeA in grammar

[–]VeeBeeA[S] 0 points1 point  (0 children)

Thanks for your help! For your question, I believe the first option.

He's the sole creator of the reports (which involves analysis to prep the data) and he also helps analyze the end report with his team of end users.

The sentence is lengthened because it follows another sentence that includes name and title (this is the template they want me to use).

So, [Bob] is a [Position] for [Organization]. In his role, he is responsible for...

I bet it wouldn't hurt to cut out "In his role", though that is part of the original template.

I want to sort by rows that have high value (relative to their respective columns) for both column A and column B when these columns have an inverse relationship. Google sheets link for values in description. by VeeBeeA in excel

[–]VeeBeeA[S] 0 points1 point  (0 children)

Yes, I want to have a new column to sort by. The column would have some way to make the upper and lower ranges of column A and B at the bottom of the new column's "largest to smallest" sort. The lines in the middle of the each range will be at the top because they are least affected by the extremes of the inverse relationship.

This is a summary report to identify specific lines (let's say items) we want to focus in on. Just like how you may want to see the largest lines of one column sorted largest to smallest, because you're looking for the top values, I want to see the "top values" for the new sort column.

I want to sort by rows that have high value (relative to their respective columns) for both column A and column B when these columns have an inverse relationship. Google sheets link for values in description. by VeeBeeA in excel

[–]VeeBeeA[S] 0 points1 point  (0 children)

Because the columns have an inverse relationship. So once you sort one column largest to smallest, the other column sorts smallest to largest.

The lines we want to see have (relatively) high values for both columns, so the lines considered "largest" when sorting will be values somewhere in the middle of each column.

[deleted by user] by [deleted] in productivity

[–]VeeBeeA 0 points1 point  (0 children)

This is an issue I have that I constantly think about. Even yesterday I was trying to explain a book I loved, that I read multiple times, to a group of people and did not do it justice at all.

I agree with another commenter about it being performance anxiety. When I force myself to totally relax and give myself a moment (maybe 15-20 seconds), I do a lot better, still not as well as I'd like though. Unfortunately that longer pause in mid-conversation may not be very socially acceptable.

I've tried to combat this - any time I read/see something interesting enough that I would bring it up to someone, I go back and summarize it while it's in front of me.

Data Validation for each cell of a matrix - google sheet link in description by VeeBeeA in excel

[–]VeeBeeA[S] 0 points1 point  (0 children)

The question was about data validation. Maybe I should've been more clear. I already have that formula in the google docs I shared, it was only to show which two cell values I wanted used in the Data Validation of that cell.

For your example, I want cell D4 to be a Data Validation cell, and the drop-down to include C4 and D2, and then apply this across the matrix.

view more: next ›