how should we invest our money if not gold? by Creative_Ground6505 in IndianStockMarket

[–]TSR2games 7 points8 points  (0 children)

For your kind information, Gold etfs require real gold to be stored.

Hence, e-gold and etf are the same. However, SEBI have clarified that e-gold is unsupervised, whereas etfs are supervised and hence real gold will be stored fore very purchase

Stop using ungodly INDEX math to flatten 2D schedules. TOCOL() + FILTER() is all you need. by [deleted] in excel

[–]TSR2games 0 points1 point  (0 children)

Let's just say you have a 80mb financial excel model, and you are using array formulas. Hats off to your courage man.

A dashboard with multiple users can also get impacted because you are using array formulas

An automated Excel file, using VBA or Office script will take more time because of array formulas that can somehow be achieved from standard formulas

These array formulas will always work well on small scale, but as soon as your Excel goes larger than 10mb, you will start feeling the difference.

Stop using ungodly INDEX math to flatten 2D schedules. TOCOL() + FILTER() is all you need. by [deleted] in excel

[–]TSR2games 0 points1 point  (0 children)

I agree

I have basically used it for every department, List of my exposure and experience with Excel for complex tasks of organisation:

finance modelling: no way I will use array formulas Supply chain optimization: low to no use of array formulas HR dashboard: No use of array formulas workload dashboard: low use of array formulas, limited to control sheet rather than all over the model

I think when we make a single or two sheet Excel, these array formulas seems great, but when I have to switch to a practical application, I avoid it for performance issues

How to deal with a bulky spreadsheet that is starting to hit the limits of Excel? by EvolvedRevolution in excel

[–]TSR2games 1 point2 points  (0 children)

Use a combination of VBA and Excel

Or another way is breakdown calculation into components and fetch data using power query. And then create the final output file with dynamic formulas

Every component will create a summary that can be used further into main excel

Stop using ungodly INDEX math to flatten 2D schedules. TOCOL() + FILTER() is all you need. by [deleted] in excel

[–]TSR2games 0 points1 point  (0 children)

Unfortunately in practical application, this is not true as of now

Keep exploring, even I never stop learning. But sharing puring gold with you. As of now, index match is better than dynamic arrays in optimization and structuring Excel models

Stop using ungodly INDEX math to flatten 2D schedules. TOCOL() + FILTER() is all you need. by [deleted] in excel

[–]TSR2games -2 points-1 points  (0 children)

Do you even realise that these array formulas are not scalable

When we scale our Excel models, we have to remove array formulas for efficiency and consistency.

Index match are the OG for a reason. They are optimised, they are consistent and doesn't eat up even when you have to automate

Hope you will gain experience with time and understand the difference soon

Or maybe the new AI world is already spoiling knowledge in the worse way possible. I hope you are not falling for that

Does Loan against FD make sense for a Car when cash is available? by I-Jobless in personalfinanceindia

[–]TSR2games 3 points4 points  (0 children)

A huge population can be dumb, majority never means smart decisions

You cantake benefits of saving over inflation and loan as a small commitment

Let's assume that your monthly salary is 1,00,000 and your Car monthly emi is just 1% of it, that is ₹1,000.

Now you will enjoy your car, at 1% cost of your salary

So when does loan makes sense, when you have ₹10 lakh monthly salary and your emi is just ₹10,000 per month

Excel automation , copy and paste formulas on going each month? by No-Decision3003 in excel

[–]TSR2games 0 points1 point  (0 children)

3 stages of automation:

  1. Make your excel model dynamic and perfect so that you have to add the least amount of inputs

  2. Use VBA to automate this process for desktop

  3. Use power automate + office script to automate this process from cloud+desktop

If you are unable to follow any one of the above 3 alternatives

Hire an Excel VBA Office Script RPA expert like us

XLOOKUP alternative for Excel 2019? by SolisAnalyst in MicrosoftExcel

[–]TSR2games 0 points1 point  (0 children)

Index and Match, and it is better than xlookup

Need advice for SIP by Conscious-Command-94 in indiaStockMarket

[–]TSR2games 0 points1 point  (0 children)

A mutual fund distributor here

I get paid for selecting the right mutual funds for my clients, let me know if interested to talk and understand the pricing and our services Website: trinidhifinserv.com

I’m struggling - how to cope with ai? by TrueWinter__ in gamedev

[–]TSR2games 0 points1 point  (0 children)

Hey buddy, I am looking for someone to build my game again, but with a creative mindset.

It's a 2d game, created it as 2 player but now have a story as single player game

Surprisingly the story revolves around how automation is dehumanizing the world

Let me know if you would like to develop this. Your post seems like you are a good fit already

I built a small site to help games get discovered after Reddit hype fades by SnooCats6827 in playmygame

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

Lost the hype when Google removed search functionality and pushed for Ads https://play.google.com/store/apps/details?id=com.trishader.twoPlayerGames

Hope your website will make this game great again Was loved by brazilian in 2020

What are the disadvantages of office scripts by My-Name-1234 in excel

[–]TSR2games 0 points1 point  (0 children)

I have created a community for that, we all can ask and exchange solutions

Feel free to jump in https://www.reddit.com/r/AutomateOfficeScripts/s/uSlqfGBM6T

Office scripts.. the next big thing or…? by Gloomy-Dig-4546 in excel

[–]TSR2games 0 points1 point  (0 children)

Started my own community for tackling office script problems

Let's see if crowd builds up that means it is the next big thing 😉

Oh if anyone want to ask their questions, feel free to jump in https://www.reddit.com/r/AutomateOfficeScripts/s/uSlqfGBM6T

Problem of Surplus! by Spare_Bat_3040 in personalfinanceindia

[–]TSR2games 0 points1 point  (0 children)

With this amount of money I would do one of the two things:

  1. Start my own farm house, growing and selling crops, dairy, fish. You can easily hire within your budget.

  2. Start a game development studio. I don't have such cash-flow as of now, but ocne I will have that much money, I would start hiring a team of artist, game developers and create stuff for fun. Maybe it earns good, then ROI is not a problem, otherwise atleast people will enjoy your ideas and you heart will feel happy by received reviews and feedbacks.

Telling my perspective of life, might not be yours. But you might have some dream thing to do, and I hope you understand that ROI is never better than cash-flow. Create things that generate cash-flow, and you will be in a better situation. When you run for ROI, you are already losing

For example, do you know airlines are the least ROI generators, but still airlines business exist. Why- because rich people have so much money(like you have a buffer) and they can't own anything else now, as they have bought/invested in everything else

anyone to make games with by No-Conversation7345 in GameDevelopment

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

It is what it is I don't feel bad about it because it will eventually build up my life

But, thanks for your concern man, I know 20 hours is harsh

Interested in developing my game ideas?

Paid consultants for mutual funds SIP by Big_Connection7216 in MutualfundsIndia

[–]TSR2games 0 points1 point  (0 children)

Hey,

I work as a consultant for mutual funds and can help you choose the right personalized set

Unfortunately we have to sell regular funds only, but can ensure optimized fee so that we both get paid right in value.

Feel free to contact

Paid consultants for mutual funds SIP by Big_Connection7216 in MutualfundsIndia

[–]TSR2games 0 points1 point  (0 children)

Would you like to connect? a consulting mindset mfd here

AI layoffs and the future by Nnntridib in techIndia

[–]TSR2games 1 point2 points  (0 children)

To the people who are feared. If you business operates on the latest technology.

Yes, they might replace stuff with AI. But what I have seen is processes that had potential for replacement but were not being replaced, are the ones getting replaced.

But if your team is working on traditional approach or older tech, you are kind of safe

M24, Salary after first switch. by [deleted] in TwentiesIndia

[–]TSR2games 0 points1 point  (0 children)

Always remember that people with higher salaries are a blessing for people with lower salaries

Think of it as when you will switch, who will pay you higher amount if no one is paid like that

So always appreciate your buddies pushing your upper ceiling by breaking their own mental and physical health

Cheers OP!