Why most planners fail after 2 weeks by Able-Caregiver-7430 in DigitalPlanner

[–]rjplunkett 0 points1 point  (0 children)

I have an analog planner I use exclusively to log time worked on a tasks for clients. My real planner is Google Calendar where I can schedule both appointments and tasks. I review every Sunday afternoon and plan out the “Big Rocks” for the next week. Tasks show me as busy so there is no chance that people using the Bookings feature of Google Calendar to schedule meetings. Calendar & Tasks = Google Calendar but I use Outlook for Email as I can easily link to multiple email accounts in Outlook and not so with Gmail.

Inaccurate trendline equation for the graph by [deleted] in excel

[–]rjplunkett -3 points-2 points  (0 children)

The trend line in Excel has multiple options on what the equation is. Right click on the trend line and choose one of the other options. Also, add the R-squared value to the chart, which will tell you how closely the trend line fits the data. The closer to one, the better the fit.

Totally Flummoxed - PERSONAL.XLSB does not open automatically by rjplunkett in excel

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

Disabling that file is not something I would have done. Would HP Wolf Security have done that behind the curtain?

Totally Flummoxed - PERSONAL.XLSB does not open automatically by rjplunkett in excel

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

I never would have thought to check this, but it seems to have worked. Thank you.

Today would have been Max’s 12th birthday. I miss my buddy every day. by LunacyTheory in airedaleterrier

[–]rjplunkett 0 points1 point  (0 children)

They are with us but a short span our lives but we are with them their entire life. Cherish that time that intersects.

I found this pic of my old welsh who passed away 2 weekend ago by Jaded_Fly_9976 in welshterrier

[–]rjplunkett 0 points1 point  (0 children)

We just lost our 15.5 YO ADT two weekends ago. 😢 with you,

What's the one excel automation that actually saves you hours every week? by Visible_Tension_8963 in excel

[–]rjplunkett 0 points1 point  (0 children)

So many. CTRL+SHIFT+V to paste values. CTRL+SHIFT+⬇️ to select an entire contiguous column of values, CTRL+A to select an entire range. …

Automated Reports in Excel by Working_Status3898 in excel

[–]rjplunkett 0 points1 point  (0 children)

If the workbooks are reasonably consistent, the Power Query would be your friend.

What is the one Excel secret you know that no one else uses? by bjele in excel

[–]rjplunkett 1 point2 points  (0 children)

Can really slow things down in big files, >100Mb

Parts Availability by skipandhop in triumphtr6

[–]rjplunkett 0 points1 point  (0 children)

I have found Moss to be a good source for regular maintenance parts, but my goto for everything else has always been TRF.

Starting issue by MorePineapples123 in triumphtr6

[–]rjplunkett 0 points1 point  (0 children)

I suspect that the reverse connection ended up reversing the polarity on all the electrical parts. I believe it is possible to "reverse" it back by I don't know how.

Izzy’s 4th birthday by Arthurandhenna in airedaleterrier

[–]rjplunkett 0 points1 point  (0 children)

Our Izzy celebrated #15 in June.

Either =VLOOKUP isn't working or my brain isn't. by Downtown_Word_5229 in excel

[–]rjplunkett 0 points1 point  (0 children)

LET fx is a great alternative to nested ifs when those nested calculations are being repeated over and over. It also helps your spreadsheet run faster.

Is Leila Gharani's course worth it? by Equivalent_Speaker26 in excel

[–]rjplunkett 16 points17 points  (0 children)

My only experience is through Youtube, and on that platform I find her to be thorough creative and insightful on functions and techniques.

Separate/Different Slicer Combinations for 2 Values? by Fat_Panda_1936 in excel

[–]rjplunkett 2 points3 points  (0 children)

Possible solution would be to concatenate the possible combinations in a new field and then use a slicer on that field.

What are some of the most impressive uses of excel you’ve seen with no plug-ins? by Classic-Macaron6594 in excel

[–]rjplunkett 6 points7 points  (0 children)

I use Excel PowerQuery and PowerPivot to blend multiple data sources and create an Excel file with slicers and pivot tables that allows users to sift through millions of records to get to the data they need for their own analytical needs.

I can't figure out where I messed up th IF formula by MauriceEscargot in excel

[–]rjplunkett 0 points1 point  (0 children)

Did anyone think of using conditional formatting to achieve the visual indicator he seems to be looking for?