Trying to run an analysis where I can run multiple scenarios to identify the max revenue in month 12. I am manually running several scenarios with 3 variables but I know there is a better way to run it - is there an excel function / model that I can use to automate a run of these scenarios?

like
Posting as :
works at
You are currently posting as works at

I haven’t used excel in a while but I believe excel solver add-in will work. I think you basically tell it your target cell, what you’re looking for and what cells to change and it’ll give you the optimal value

like

Thank you!!!!! It worked!!

like

^for those interested, I think DS 1 is referring to the “What If” feature in Excel. Super handy if you haven’t explored it yet!

Related Posts

Any good yoga studios in Denver/Boulder for beginners?

Gut check. On HCP projects, do you find the client or CW suggests what part of ISI per page?

like

Hi Fishes,
What should be the salary for Manager / Sr Manager having 14+ yoe in project/product service operations? I am at 32 lpa which I think is quite low having worked with top consulting firms for close to 12 years.

like

Anyone want to go on a date today? 🤷🏻‍♀️

likefunny

Moved to Dallas a few months ago, anyone else think it’s strange that so many neighborhoods use rear entry garages and people drive through alleys to get to them? Never saw these growing up.

like

Ernst & Young India is hiring for Tech Consulting!

DM if interested!

Post Photo
like

I've been sending out my resume but with no response. So, what do you think I've missed in my resume?

Post Photo
like

We’re hiring on our media & connections team. Various levels. If you’re looking to make a jump from a traditional media agency or a strategist who wants to get closer to both media and creative. Lmk.

likehelpful

My work doesn’t require us to be licensed in a particular state (i am licensed in my home country) - International Arbitration. What are the obvious benefits of getting licensed in New York?

like

Hi All,

I recently obtained my law degree and currently work for a BigLaw law firm as an assistant. I want to make the transition to the firm’s Litigation department because I want to practice international arbitration. How do I approach my HR department as well as the litigation bosses about transitioning to litigation? Any ideas would be helpful.

Thanks

like

In house insurance defense comp. What’s the highest paid and lowest paid companies? Which companies give bonuses? Please provide yoe and salary.

like

can an MD at B4 in the SAP practice become a partner in some time ?

like

Community, I’ve been meeting with a lot of people regarding next steps in my career. One of the best pieces of advice I received is to avoid micro-managing executive staff (agency leadership), as it puts downward and unwelcome pressure on people’s managers and ultimately oneself. Based on your experience in the last 2 years are there:
- Agencies you would steer clear from because their leadership micromanages
- Agencies you would recommend because their leadership gives you room to grow

Thx 🙏🏼

like

Has anyone been able to apply to the Lyft APM program? Can’t find the application link despite the website saying it’s live.

like

I am a Technolgy Risk staff at EY, been there a year and I don't want to stay in audit. Bachelors in Econ and MIS. I found a position as an Associate for Siemens Managent Consulting, any tips? Ctd

like

it’s disgusting to see in this city how people pay more attention to the dogs homeless people have than the people themselves - it’s dehumanizing and makes me sick when people give a strained smile to the homeless person while patting their pup like come on

like

1 bed, 1.5 baths, spacious, lots of sunlight, friendly doormen building close to Columbus Cir available Dec 2019 through Jan 2020 for a short term lease. Looking at $3000 / month but negotiable!

like

I got a vaccine appointment at javits but I just got one sooner at NYU. Am I able to transfer the javits appointment to a family member?

like

Additional Posts in Data & Analytics Consultants

Docket + R - I have an container running a rocker image and I’m trying to launch a bash terminal and the RStudio server (/init) at the same time. Is this possible? I tried adding CMD [“/init”] too.

like

Folks applying for Data and Analytics roles in the industry at M, SM, D Levels, what technical/functional topics do you prepare for on the Analytics side?

like

Have you ever failed to deliver? What was it and why?

like

McKinsey & Company Does somebody have experience regarding
compensation differences between
QuantumBlack & McKinsey? I am in the process at
QB and disappointed with the salary that's
proposed. (New grad Data science from top
university applying for London) McKinsey & Company QuantumBlack

like

from God import pandemic
From China import coronavirus, mortality_rate

covid_19 = pandemic.coronavirus.set_mortality(mortality = 1.)

like

What is Accenture’s data scientist interview process like?

like

Is 128k a fair base salary for Consultant in Deloitte Analytics & Cognitive. MS CS and about 3 yrs experience. In one of the fastest growing but midtier tech cities in the US.

like

What’s so good about the Georgia Tech OMSC and OMSA? Is it just the cost? Seems to be recommended by most of reddit

likehelpful

Looking for an entry-level data analyst position in the DC area. Have a BA in economics & certification in Computer Science. Also 3 years of professional work experience as a full time marketing manager which I performed while attending school full time. I’m a self-starter and extremely driven. I also have a passion for data and statistics, and plan on pursuing my MS in data science within the next year. Please let me know if you know of any positions! Thank you.

like

Noob question - I want to consolidate the dates into a single dates column. Would numpy or pandas help me reorganize this dataset effectively or should I do it within excel?

Post Photo
like

Meeting with a recruiter at one of the FAANG companies. I won’t be able to move jobs because of H1b /GC at least for the next year. Any idea if I should start off with that or should I just try to understand the work that they have been doing?

like

Anyone in the KPMG Lighthouse practice that would be willing to take a look at my husband’s resume and put in a referral? He’s interested in the Associate, Data Scientist position.

What is a data lake in basic terms?

like

Anyone have any suggestions for front end guis for users to run python code? I’ve created a few tools for webscraping data, automation, and modeling but non technical users freak out when they try to run the code themselves. Any suggestions? (Have tried Juypter Notebooks and a few other IDEs)

like

What biotech stocks are yall trading right now?

GILD, INO, MRNA

like

Newish to data analytics. Have some experience in power BI, sql, and R. I wanted to get some exposure to aws and saw the AWS cloud practitioner as an available course at my job. Is this cert worth it? Or should I try one of the more advanced ones ? The data analytics one for example but wasn’t sure if it would be difficult to get through as a beginner. Will it look good on my resume?

like

My manager continues to ask me to help other teams and do work on other billable projects. I’m sick of it .. and I’m going to explicitly say that no I can’t do it because my hours are taken by the existing project we are doing. Is this appropriate?

like

Is anyone working with Elastic at DoD?

How is Deloitte’s Analytics and Cognitive practice doing? Saw a couple of open Data Science roles open on their website, are they actively hiring

like

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal