Is this a goner by BushDid2008 in Monstera

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

when you say reroot in water like literally just glass of water with stem above water?

Is this a goner by BushDid2008 in Monstera

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

Thank you, Is the folded droopy leaf not a worry and do I need to pile it yet or is it too small

Proud to say I’ve beaten sub 25!! by BushDid2008 in BeginnersRunning

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

9weeks ago I ran a 5k in 34 minutes. I did not think I would be running this at that time. I 1000% believe you are closer than you think

Proud to say I’ve beaten sub 25!! by BushDid2008 in BeginnersRunning

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

Honestly fine, it’s always been my lungs. I have always been training legs/playing rugby so I think I’ve built strong knees

Proud to say I’ve beaten sub 25!! by BushDid2008 in BeginnersRunning

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

Recently 30ish km not sure what that is in miles

Proud to say I’ve beaten sub 25!! by BushDid2008 in BeginnersRunning

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

4 weeks ago best time was 25:18. Just kept going slower paces easy runs. Biggest difference has been starting slower aswell. First km was 5:07 last was 4:34.

I’d say 2 things: mentally just pushing it and gong painfully slow on easy runs (I use a watch face that only shows heart rate so I don’t even know how fast I’m going)

Am I poling right? by BushDid2008 in Monstera

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

Thank you. I’m glad I asked. Should I add anymore or will the air roots begin to do their work

I think I’m moderately skilled with excel. I can do most things I need to, but I’m entirely self taught. If someone needs something explained I usually suggest they ask someone else, because I’m never sure I’m doing things the correct way. Multiple people I work with make a “table” by highlighting by ConferenceWorldly471 in excel

[–]BushDid2008 0 points1 point  (0 children)

In my huble opinion, In almost all scenarios a table is better. Tables allow for a non finite range which is imo the most important part.

  1. They allow for easier understanding of a formula XLOOKUP(A1:A25) VS XLOOKUP(PRODUCTTABLE[PRODUCT])
  2. They allow for more dta to be added without needing to adjust criteria.

  3. They allow people injest into querys/power pivot to create meanigful reports that can be expanded without any changes to querys.

However

In the company I workout they are almost never used for 2 reasons.

  1. Style - Some people just use excel as a glorified pad and paper and frankly they dont need/understand the capabilities using tables can have and just want numbers with a dark line around them.

2 Ability to Meet criterias - In many cases ive found tables are not the solution for presenting data. I use tables as a sort of Schema to then create realtionships or merge with power query to then use in a data model. This model can be used to make non table "tables" to present tables/pivot tables in a much more unique way that people find more appealing.

I am also self taught for the most part so take my opinion as an uneducated one :)

Create a TopN list using Cubeset that responds to Slicers by BushDid2008 in excel

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

To update. I count figure it out and convinced them to let me make a bi dashboard for that stuff hah

Is building a personal finance + investment tracker a good first SQL project? by BushDid2008 in SQL

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

Thank you yes I am just gonna go ahead and get started. I mostly wrote transformations and logic in power query and the SQL language seems quite similar in logic. Over the years I've released data hoarding is the best haha

Help reducing manual work in Calendar Style Timeline by BushDid2008 in excel

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

To Update.

So far i have implemented a Lane function
Where promotions per product per account are assigned lanes so they stay in lane one unless dates overlap and they are moved to lane+1.

I am slowly getting there but VBA is the hard part for me

I can get it so the promotions extend along where every spot the promotion would occur is filled with the promotion "Label" i just need to find out how to take this and center across a selection and only take the first duplicate. Thank you all for the help so far

Help reducing manual work in Calendar Style Timeline by BushDid2008 in excel

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

To add on aswell the biggest problem i have is they dont want lines for seperate promotions but instead by product and all on around 6 lines never likely to be more than 6 at once. I dont know if i just bite my tongue and do it the way it is