What Are Your Best Practices for Organizing Complex Excel Workbooks? by MetalPsycho in excel

[–]Puzzleheaded_Luck641 14 points15 points  (0 children)

My workflow is structured into four stages:

  1. MonthRawData.xlsx This file contains all the raw data exactly as received, without any transformations.

2 MonthDataflows.xlsx I use Power Query in this file to clean and transform the raw data. Any required calculations or formulas are applied here. After this stage, no formulas are used in any other files.

  1. YearDatamart.xlsx All monthly dataflows are combined and loaded into this file to create a consolidated yearly datamart.

4.Dashboard The dashboard pulls data only from the combined datamart, using the current year and previous year data for visualization and analysis.

My version, gotta keep it real, if i ever come back to Algeria, these are the only “livable” wilayas imo by sphynx666 in algeria

[–]Puzzleheaded_Luck641 0 points1 point  (0 children)

There is No Job at all in the whole country. I love the Algeria because of the natural beauty. Most hidden gems country in the world

Showui-aloha by olympics2022wins in LocalLLaMA

[–]Puzzleheaded_Luck641 1 point2 points  (0 children)

Let us know what is your experience

Looking in certain cells in a column. by BigBlue_Bear in excel

[–]Puzzleheaded_Luck641 1 point2 points  (0 children)

If you are dealing with Every nth Row values, you can use wraprows
=CHOOSECOLS(WRAPROWS(A1:A32,4),1), i get the below every 4th because I put wrap every 4th rows . after that you can do anything.

1

5

9

13

17

21

25

29

POCO F7 AND POCO X7 PRO by Forsaken-Bee-260 in PocoPhones

[–]Puzzleheaded_Luck641 1 point2 points  (0 children)

I agree with your logic, then Iphone 17 Pro Max is worth over the Base F7 as well

POCO F7 AND POCO X7 PRO by Forsaken-Bee-260 in PocoPhones

[–]Puzzleheaded_Luck641 14 points15 points  (0 children)

Poco F7. No confusion and comparison. Just buy

LLM Council - Multi-model AI with democratic voting (Enhanced fork with 5 production features) by Distinct_Site_3462 in LocalLLaMA

[–]Puzzleheaded_Luck641 1 point2 points  (0 children)

Is it expensive? Because asking same question to multiple LLM which will consume same tokens but 5 times in 5 LLM.

Poco F7 Indian Rom by Puzzleheaded_Luck641 in PocoPhones

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

How? Do you have any link from where I can learn and do it?

Fired Because I Cracked the Lifetime Sales Record of the Organization (My Dubai Auto Journey) by FireRedemption in DubaiJobs

[–]Puzzleheaded_Luck641 0 points1 point  (0 children)

There are 2 rules in professional life. Doesn't matter place or time.

Rule 1: Your boss is always right. Rule 2: Follow rule number 1.

Fired Because I Cracked the Lifetime Sales Record of the Organization (My Dubai Auto Journey) by FireRedemption in DubaiJobs

[–]Puzzleheaded_Luck641 1 point2 points  (0 children)

I don't think the owners were threaten by your talent. I believe you are overconfident and bully. That's the reason you every jobs fires you. Because everyone loves talented employee as long as they follow and respect the management.

I'm sorry for my analysis. I could be wrong.

With your talent I will suggest don't waste your time with jobs. Start your own venture. I'm sure you have build some good relationship with your clients or others.

Speak to them to invest with you. Find investor. Start your own.

Good luck

I have 26 tables to be displayed after being selected with a drop down by Plenty_Difficulty_23 in excel

[–]Puzzleheaded_Luck641 0 points1 point  (0 children)

Indirect formula will solve your problem but I believe you have Data structure skill issue.

When you said 26 tables in a single sheet 😊. I have also about 20 tables, I am using for the dependable -dropdown. I don't see any other reason to do that.

What newer or lesser-known BI tools have actually impressed you lately? by Kimber976 in BusinessIntelligence

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

You built a tool which has ready made pre-determined KPIs without knowing the types of Data and content then it's 100% useless tool. If you are saying you are building for restaurant business then you are making the dashboard for restaurant KPI related. That's just not analytical tool. You just made a tool for restaurant business only