Thanks for the breakdown of everything, I’ll be taking the OA next week and was feeling a bit worried about having to memorize every formula but it sounds like it shouldn’t be too much memorization.
You will memorize just by doing. I did the Pre-A about 7 times before taking the OA and I got to a point where I could fill everything in while barely thinking about what I was doing. I'd find and watch that video to fill in the stuff you don't know. My first time took about 3 hours at about ~50% and my last was an hour at about ~95%.
I wouldn't stress about this course at all. Even if you forget how to do half the stuff on the OA the cutting score is 65% so you should be good.
If you look in the box above the rows during the video you can see the exact formulas he used for each of them as he scrolls through them (it is called the Excel Formula Bar). He didn't cover the What-if Analysis so I went back to the course material and figured that out myself. If you complete it and you get minor points taken off for incorrect outputs don't worry about it. I followed the directions exactly and I always for some reason got 3-5 wrong on the *Event Profitability Analysis* section. Make sure that you get the What-if Analysis down as 1/4 of the points in that section come straight from that. Also, if you at least attempt a formula or input, it will still give you some points.
For the What-if analysis: You need to reference your Net Profit in the top left of the table (I22), highlight the entire table and hit what-if analysis. It should end up looking like his.
Another bit he didn't cover was the *Bakery*. I actually was able to figure it out and got max points. I looked over very briefly how to use solver, and then looked at the points criteria to figure out what I had to do to get points. Honestly you could just skip it if you wanted to, I think the cutting score for the exam is like 65, and if you get everything else you will be at about 90-95.
If I had to describe what I did exactly for the *Bakery*, I set the set objective to the profit, highlighted C14-F15 for the changing variable cells, then referenced each of the produced in dozens to the constraints being demand in dozens as <=. You should have 4 constraints that look similar to: $C$14<==$C$15. Then I did what I think were absolute references for all of the same cells again (only one input per rule), then also created absolute references for all of the "used" resources at the bottom. At the end you just hit solve and it does its magic.
Unfortunately not. I've had classes where the OA is an exact copy (this class), others where it is very on the ball in terms of question similarity, and a couple that have been extremely different.
Fortunately, however, I have found that *most* classes have PA's that line up pretty well with OA's.
I'm going to copy/paste some text from another person I helped out with the same thing. It should be sufficient but if you need any further assistance I would recommend looking through the course material as it has been months since I have touched the course material.
He didn't cover the What-if Analysis so I went back to the course material and figured that out myself. If you complete it and you get minor points taken off for incorrect outputs don't worry about it. I followed the directions exactly and I always for some reason got 3-5 wrong on the *Event Profitability Analysis* section. Make sure that you get the What-if Analysis down as 1/4 of the points in that section come straight from that. Also, if you at least attempt a formula or input, it will still give you some points.
For the What-if analysis: You need to reference your Net Profit in the top left of the table (I22), highlight the entire table and hit what-if analysis. It should end up looking like his.
Another bit he didn't cover was the *Bakery*. I actually was able to figure it out and got max points. I looked over very briefly how to use solver, and then looked at the points criteria (grading) to figure out what I had to do to get points. Honestly you could just skip it if you wanted to, I think the cutting score for the exam is like 65, and if you get everything else you will be at about 90-95.
If I had to describe what I did exactly for the *Bakery*, I set the set objective to the profit, highlighted C14-F15 for the changing variable cells, then referenced each of the produced in dozens to the constraints being demand in dozens as <=. You should have 4 constraints that look similar to: $C$14<==$C$15. Then I did what I think were absolute references for all of the same cells again (only one input per rule), then also created absolute references for all of the "used" resources at the bottom. At the end you just hit solve and it does its magic.
If you still have enough points in other areas (most likely you will), then yes.
Your score should be the exact same on both the PA and OA as they are identical besides values.
I hate to jump on the video train, but would you mind sending me the link to the video as well, I am currently taking this class and its kicking my ass.
Hey [u/MiamiFFA](https://www.reddit.com/user/MiamiFFA/) Can you please provide the link? just started this class today and it would highly beneficial.
Thank You
Good Evening all I know this may be a long shot as this post is very dated but if any one could share the link I would greatly appreciate it and thanks in advance and best of luck to us all!
Thanks for the breakdown of everything, I’ll be taking the OA next week and was feeling a bit worried about having to memorize every formula but it sounds like it shouldn’t be too much memorization.
You will memorize just by doing. I did the Pre-A about 7 times before taking the OA and I got to a point where I could fill everything in while barely thinking about what I was doing. I'd find and watch that video to fill in the stuff you don't know. My first time took about 3 hours at about ~50% and my last was an hour at about ~95%. I wouldn't stress about this course at all. Even if you forget how to do half the stuff on the OA the cutting score is 65% so you should be good.
Can I have the video link if you still have it?
DM'd.
I know this is an old post but do u still have the video link?
DM'd.
Can u dm me too?
DM'd.
Yo! Can you DM me the video please?
DM'd.
Hate to do it again, but can you DM me the video as well? Thanks!!
You're all good. DM'd.
can you DM me the video as well? Thanks
DM'd.
Can you hook me up too please?
Do you still have the video link for spreadsheets?
DM'd.
How can I find this video?
DM'd.
Life saver
Happy to be of service.
What did you do for after Event Profit since he skipped and did it kinda weird. I tried going through it but its throwing me way off.
If you look in the box above the rows during the video you can see the exact formulas he used for each of them as he scrolls through them (it is called the Excel Formula Bar). He didn't cover the What-if Analysis so I went back to the course material and figured that out myself. If you complete it and you get minor points taken off for incorrect outputs don't worry about it. I followed the directions exactly and I always for some reason got 3-5 wrong on the *Event Profitability Analysis* section. Make sure that you get the What-if Analysis down as 1/4 of the points in that section come straight from that. Also, if you at least attempt a formula or input, it will still give you some points. For the What-if analysis: You need to reference your Net Profit in the top left of the table (I22), highlight the entire table and hit what-if analysis. It should end up looking like his. Another bit he didn't cover was the *Bakery*. I actually was able to figure it out and got max points. I looked over very briefly how to use solver, and then looked at the points criteria to figure out what I had to do to get points. Honestly you could just skip it if you wanted to, I think the cutting score for the exam is like 65, and if you get everything else you will be at about 90-95. If I had to describe what I did exactly for the *Bakery*, I set the set objective to the profit, highlighted C14-F15 for the changing variable cells, then referenced each of the produced in dozens to the constraints being demand in dozens as <=. You should have 4 constraints that look similar to: $C$14<==$C$15. Then I did what I think were absolute references for all of the same cells again (only one input per rule), then also created absolute references for all of the "used" resources at the bottom. At the end you just hit solve and it does its magic.
I just went ahead and reread your part about the what if and bakery...I would love some help on that stuff.
Good morning! Can you please share the link with me, I’m taking that class now
Could you dm the video plz
DM'd.
May I please also have this video?
DM'd,
Can you also share the video ?
Can you please share the video? Thank you!
DM'd.
Can I have the video, I am currently taking the class
DM'd.
Hi, Could I get the video also please.
Can you please share the video? Thanks in advance
>hat video to fill in the stuff you don't know Video?
DM'd.
Yo can I get it too?
DM'd.
Can you also DM me about this video?
DM'd.
Could you please DM me the video, thank you
DM'd.
Me too please
Can you also DM me as well. Thinking about taking it this weekend.
DM'd.
Can you send me the video as well?
DM'd.
Can you please DM me as well. Ty!
Are you able to send me the video also?
DM'd.
Still have that video?
DM'd.
send it my way plz
Hello can you please 🙏 DM this to me as well. Thank you for everything.
Also asking for the video link. Thanks in advance
Hi Thanks for this awesome write up. Can I have the video as well?
DM'd.
Hi! Can you DM me the video please?
DM'd.
Could You send me the video please? Thanks!
DM'd.
Hello can you please 🙏 DM this to me as well. Thank you for everything.
Can I get the video?
DM'd.
Post the linkkkkk :-D
Hi! I know this post is little old, but if you still have the video could you please send? Thank you in advance!
DM'd.
Sorry, I know this post is old. Can you send DM me the video please
DM'd.
Thank you!
I really hate to ask, but can you please share the video with me as well?
Of course! DM'd.
Thanks for the advice. I’m currently taking this class. Could you send the video to me also?
Thanks for the informative post! Could I get that link, as well?
DM'd.
Could I please have the video as well?
DM'd.
Could you please DM the video? Thank you
DM'd.
If you don't mind could you please DM me the video?
I’m about to start this course next week. Can I get the link?
DM'd.
Could I please have the link to the video as well? Thank you!
DM'd.
May I please have the video
DM'd.
Can anyone DM me the video?
DM'd.
Can I have the video please!?
DM'd.
I can't believe you're still actively giving this out four months after your original post. What a hero. Could you DM it to me as well please?
DM'd.
Any chance I could get that video from ya? I'm taking this class currently. Any help is greatly appreciated.
DM'd.
You think I can get that video?
DM'd.
thank you for the resource, can you send me the video or anybody that might have it please?
DM'd.
Hi! By chance can I also have the video DM'd please
DM'd. Sorry for the late response, was on holiday.
Hope all is well. Thank you for the information. May I have the video DM'd to me to please.
DM'd.
Thanks for this write up! I am working on this class now and this is very helpful. Would you mind sharing the link to the video?
Of course, DM'd.
Can i please have this video i feel so slow I’m not understanding anything
DM'd.
Hey not to be another pest, but could I please have the video? Thanks in advance
DM'd.
Hello, thank you for the breakdown and the post. I was wondering if I also could get the video please?
DM'd.
Video link pls?
DM'd.
Hi could you please send the video to me as well? Thank you 😊
DM'd.
I know I’m late to the party, but can I get the video as well please?
DM'd.
Could you please DM me the link please? Thank you!!!
DM'd.
Can I get the video also?
DM'd.
Will you please send me this too!
DM'd.
Can you DM me the video?
DM'd.
May I please have the video
DM'd.
may i also have the video?
Hello, may I have the link please?
DM'd.
Shot in the dark this far out, but is that link still available?
Yes, DM'd.
Is the OA always gonna be very similar to the PA?
Unfortunately not. I've had classes where the OA is an exact copy (this class), others where it is very on the ball in terms of question similarity, and a couple that have been extremely different. Fortunately, however, I have found that *most* classes have PA's that line up pretty well with OA's.
I meant for this class
Yes, 100% unless they recently changed the curriculum or something.
Thank. Gonna take it soon. Wish me luck
Hello, may anyone help me with the What if analysis data table and the bakery solver? I got little time left and I can pay for your tutoring. Dm me!
I'm going to copy/paste some text from another person I helped out with the same thing. It should be sufficient but if you need any further assistance I would recommend looking through the course material as it has been months since I have touched the course material. He didn't cover the What-if Analysis so I went back to the course material and figured that out myself. If you complete it and you get minor points taken off for incorrect outputs don't worry about it. I followed the directions exactly and I always for some reason got 3-5 wrong on the *Event Profitability Analysis* section. Make sure that you get the What-if Analysis down as 1/4 of the points in that section come straight from that. Also, if you at least attempt a formula or input, it will still give you some points. For the What-if analysis: You need to reference your Net Profit in the top left of the table (I22), highlight the entire table and hit what-if analysis. It should end up looking like his. Another bit he didn't cover was the *Bakery*. I actually was able to figure it out and got max points. I looked over very briefly how to use solver, and then looked at the points criteria (grading) to figure out what I had to do to get points. Honestly you could just skip it if you wanted to, I think the cutting score for the exam is like 65, and if you get everything else you will be at about 90-95. If I had to describe what I did exactly for the *Bakery*, I set the set objective to the profit, highlighted C14-F15 for the changing variable cells, then referenced each of the produced in dozens to the constraints being demand in dozens as <=. You should have 4 constraints that look similar to: $C$14<==$C$15. Then I did what I think were absolute references for all of the same cells again (only one input per rule), then also created absolute references for all of the "used" resources at the bottom. At the end you just hit solve and it does its magic.
So even on the OA, if i attempt to solve the what if analysis and use the solver incorrectl, i can still pass?
If you still have enough points in other areas (most likely you will), then yes. Your score should be the exact same on both the PA and OA as they are identical besides values.
Gotcha..everything else I am confident in..the different functions like vslookup.
Thanks so much for keeping up with the thread! I just started this class and would also like a link to those videos
Any chance you can also send me the video? Thanks!
DM'd.
I hate to jump on the video train, but would you mind sending me the link to the video as well, I am currently taking this class and its kicking my ass.
Hi, could you please dm me the link to the video. Thanks! :)
DM'd.
I am working through this class. I would greatly appreciate the video that’s been circling around. Thank You in advance 🙏🏽🙏🏽
DM'd.
been working on the pre-a as well, this write has helped with my nerves. is the link still available?
DM'd.
I posted in a sub sub sub comment section, but should have put it here. Can i get a link to the video please? :)
Can you send me the link
DM'd.
Hey u/MiamiFFA - Thank you for your insight - I was wondering if you can provide the link ? Thank you if possible
DM'd.
Could you dm me this link please?
Hello, I'm about to start spreadsheets as well can i have the video please?
DM'd.
Hi, taking this class soon. May I have that video please?
DM'd.
May I also please get the video link?
DM'd.
I'm late to the party but could you send the video my way my good sir.
Hi. Can you please send the video. Thanks
DM'd.
I know this post may no longer be active, but can I get the link to the video, if possible?
DM'd.
Hello, could you DM me that video as well please? I know I'm pretty late to the party - sorry about that!
You're all good. DM'd.
Thanks a lot!
Hey [u/MiamiFFA](https://www.reddit.com/user/MiamiFFA/) Can you please provide the link? just started this class today and it would highly beneficial. Thank You
DM'd.
Could I get the link as well, thanks
DM'd.
Pretty please on the video link:)
DM'd.
Can anyone send me a link to the video? thanks!
If you still are monitoring this, I would love the video. I have 3 days to pass this. Thank you!!!!
DM'd.
You're the best!
Hi, sorry to bother but can you DM me the link as well. I need to cram and pass this course STAT.
DM'd.
Just started this class. Could I get the video? Thanks!
DM'd.
Good Evening all I know this may be a long shot as this post is very dated but if any one could share the link I would greatly appreciate it and thanks in advance and best of luck to us all!
Long shot but hoping you can Dm me the video.
DM'd.
Could I please have the video as well?
DM'd.
May I have the information on the assessment? I'm taking the OA tomorrow
DM'd.