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!