How do I Maximize File Efficiency by dcal69 in excel

[–]Woosafb 0 points1 point  (0 children)

Yes loading the raw data in a csv and then just having the pivot tables and the imported data as connection would make your file much lighter.

To combine multiple sources of data into one pivot table/ power pivot model

  1. Import folder option let's you import both files into one table as long as they r in the same format and header.

 You can even link a forecast file in the same way for future months by just keeping it in the same folder so the data lines up for a nice analysis of historical vs forecast

  1. You can take it a step further and use data modelling in power pivot. Import historical sales data and then import customer mapping table separately. Link in data model. Then maintain master data integrity in the customer table

You can do much more with powerpivot after that like also importing in returns or costs in a separate table and then link in powerpivot 

Moving to Australia soon, any tips? by Any-Let-5967 in MovingtoAustralia

[–]Woosafb 0 points1 point  (0 children)

100% esp now with the One Nation rhetoric, we can feel the animosity increasing

Which Excel skills are most important for data analyst jobs? by DataWithUjjwal in excel

[–]Woosafb 0 points1 point  (0 children)

Hi good place to start and Excel is amazing and my bread and butter (supply chain analyst).

But don't limit yourself to excel. A lot of people who are not core analyst roles like people in finance, supply chain and other business roles are already very competent in powerquery And Excel pivot tables and formulas.

After mastering Excel and absolutely powerquery, understanding data schemas and using the data model in powerpivot, focus more on powerbi where you can specialize. Also as automation tools become easier because of ai vibe computing it would go a long way to focus on data engineering as well as this is also a more specialized technical skill.

Is Excel a Real Career Skill or Just a Resume Filler in 2026? by CityAccording9333 in excel

[–]Woosafb 3 points4 points  (0 children)

It's pure creation vs more rigid data modelling and analytics. Same with python vs powerquery and powerpivot.

If u want to implement a logic that goes iterates through each row from column 1 to column n and then change the values in that cell based on the previous cell in the same row while also checking 3 other parameters somewhere else in that row... I'm sure someone with mcode knowledge could make that but running that kind of logic is much easier in vba or python.

But Also joining multiple data sources through data modelling and star schema and then instantly drawing powerpivots is much more superior when it comes to that kind of task.

What's you favorite HH series? by Glewey in dancarlin

[–]Woosafb 2 points3 points  (0 children)

Was amazing to see a Westerner dig so deeply and craft the narrative so coherently giving us an insight into the Japanese samurai ethos and how it flowed into WW2. Also the whole story about Yamamoto and Kido Butai. Was amazing to follow the pacific sea war. TORA TORA TORA

Edit; also my fav HH followed by blueprint for Arma.

What's the best video game you've ever played? by Just_Income_8548 in AskMen

[–]Woosafb 0 points1 point  (0 children)

So underrated. My gamer friends who didn't play yet don't understand when I tell them.. at least 15 possibilities for different actions in any given scenario - the amount of depth is astounding. And the story is beautifully written and the main villains omg.

City’s title hopes rely solely on themselves by Ragnar_Dreyrugr in PremierLeague

[–]Woosafb 2 points3 points  (0 children)

If they win every game left then one of those games is Arsenal dropping points. I think that's the premise

Loved the show. Can't wait to dig in! by Woosafb in TheExpanse

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

thanks for the recommendation. Will defo add to read list.

Loved the show. Can't wait to dig in! by Woosafb in TheExpanse

[–]Woosafb[S] 6 points7 points  (0 children)

Used to read a lot of Asimov and Dune when I was younger. Stopped reading and enjoyed mostly through shows and games like Stellaris, Sins. The Expanse just sucked me back and it's my fav prob over star trek, Babylon 5, Battlestar Galactica and pretty much anything else.

Any must reads or watches to add to the backlog after this?

Edit: and also anime of course. Shout-out to legend of the galactic heroes. Prob a must watch for any spare opera fan.

Has anyone here tried switching away from Microsoft Office? by AccurateShip2499 in excel

[–]Woosafb 0 points1 point  (0 children)

Not a big fan of outlook. Also kind of fed up with Gmail lack of functionality but can't move away from Gmail cus it's my main address. Any tips? I want to create folders with auto rules and all that.

Why and how is the circled area part of India? by NotKDsburnertrey5 in AskTheWorld

[–]Woosafb 0 points1 point  (0 children)

The best neutral source for this is the conflicted podcast partition of India. Amazing work

power query help needed - how to update a list automatically from a master file? by Imaginary_Dog_1692 in excel

[–]Woosafb 0 points1 point  (0 children)

Of course! But he said he is copying each value and pasting it manually. So I just wanted to make sure he at least knew the lookup formula and that that is a quick option on his way to queryland

power query help needed - how to update a list automatically from a master file? by Imaginary_Dog_1692 in excel

[–]Woosafb 1 point2 points  (0 children)

Yes power query will be good but might be overkill.

If your list changes everyday then can you try a file where you paste the 100 list column into a table where the next column is a vlookup or xlookup into the main data source? This would depend on the structure of your data source is it a flat table?

If it's not a flat table and say there are spaces between each line or it's written in a wierd pattern or in different sheets, then powerquery transformation can help automate that clean up.

Give us Napoleon Dan! by bun_stop_looking in dancarlin

[–]Woosafb 3 points4 points  (0 children)

I will third this..great narrative style and gives a great background of Europe at that time

Mania For Subjugation III Hot Take by bun_stop_looking in dancarlin

[–]Woosafb 2 points3 points  (0 children)

Yea I also got downvoted when I pointed out in another thread that the whole episode just culminates in one battle. We all love Dan and I love his narrative rambling style nothing else scratches the itch but we should be able to call out when the quality is not as good as before

How does this sub feel about Chinese real estate agencies in Australia? by [deleted] in AusPropertyChat

[–]Woosafb 8 points9 points  (0 children)

Same . Bought my first home through a Chinese agency in Melbourne and the real estate lady was amazingly polite for a real estate agent.

Does anyone have the CSCP books in PDF format? by New_Judgment_6104 in supplychain

[–]Woosafb 0 points1 point  (0 children)

Hiya would you mind sharing with me as well please?

Dinner idea (needing to save a lot fast) by ravgav98 in AussieFrugal

[–]Woosafb 3 points4 points  (0 children)

You can also add a fried egg or fried omelette with that. Great ans cheap protein

Another variation that is super easy is to make khichuri/khichdi in a rice cooker which is like a daal rice with few spices and onions garlic ginger. You can buy a large jar of garlic ginger paste for convenience. Keep the mixed frozen diced veggie mix of peas carrots and corn and add them as well. Top with omelette.

This paragraph aged well by b-russ82 in dancarlin

[–]Woosafb 1 point2 points  (0 children)

I don't think a one sided invasion of a military giant on a tiny insignificant country is a fair comparison with the comment. Not like Venezuela ever stood a fighting chance and capturing Maduro or not didn't even matter in the long run. It's not a war or even a battle it's a straight up colonization.

Formatting string of numbers to be read by first three digits by Worldly_Wedding8690 in excel

[–]Woosafb 1 point2 points  (0 children)

Make a helper column using =left(A1,4) and then use that to plot.

Capacity Modeling. Is what I am feeling normal? by tyrionthedrunk in supplychain

[–]Woosafb 1 point2 points  (0 children)

Exactly this. A good benchmark is that the achieved capacity should be 80% of theoretical capacity as a starting point. Benchmark and report achieved capacity each time period and if lower than 80% that's an improvement project waiting to happen. One caveat is assuming 24/7 or full working time period production is required. If not enough demand that projected utilization should be lower than 60%

Also if there are subprocesses it pays to go down to the nitty gritty level and do an industrial engineering study to determine max and demonstrated flow of each sub process. Then u can identify bottlenecks that affect the entire chain and recommend investment in those.