I know this is coming late but thanks for the tutorial. I just got a request for weighted average of rates on one of my projects. This video helped me solve it much quicker.
I have been assigned some tasks by one of my professors. And what you have shown and explained in the video is exactly what I need. Thanks for saving me as the deadline is approaching! Thank you so much!
I use the weighted average allt the time as a business controller because it is often more relevant than the usual average in our business. The way you demonstrate it's use is much more efficient than my way so thank you! It really helps :-)
My problem for the weighted average of steel indices as shown in our agreement - like this : - (iii) Adjustment for Steel Component Price adjustment for increase or decrease in the cost of Steel procured by the contractor under different schedules of BOQ shall be paid in accordance with the following formula: Formulae-I (for all schedules of BOQ except bill/schedule-2 B & 2 C): Vs = Ps / 100 X RI X (S1-S0) / S0 Vs = Increase or decrease in the cost of work on the date under consideration due to changes in the rates for Steel. S0 = The weighted average of index Numbers of Wholesale Prices in India by Groups and Sub Groups (Averages) for (i) MS Bright Bars under Mild Steel -Long Products sub-group (weight=1) (ii) Angles, Channels, Sections, steel (coated/not) under Mild Steel -Long Products sub-group (weight=2) (iii) Mild Steel - Flat products sub-group (weight=1) published in RBI (Reserve Bank of India) Bulletin / website of the office of the Economic Adviser in the month on the day 28 days prior to the closing date of submission of Bids. S1 = The weighted average of index Numbers of Wholesale Prices in India by Groups and Sub Groups (Averages) for (i) MS Bright Bars under Mild Steel - Long Products subgroup (weight=1) (ii) Angles, Channels, Sections, steel (coated/not) under Mild Steel - Long Products sub-group (weight=2) (iii) Mild Steel - Flat products sub-group (weight=1) published in RBI (Reserve Bank of India) Bulletin / website of the office of the Economic Adviser in the month on the day 28 days prior to the last day of the period to which a particular interim payment certificate is related. Ps = Percentage of Steel component of the work. BASE DATE IS 25 MARCH'2019) Hope you will understand it properly and will give proper solution that how to get "weighted average of MS Bright Bar, e-Mild Steel - flat product and Angle channels ..) bs negi
This only works if %100 of assignments have already been submitted. You need to be using SUMIF instead of SUM in the denominator to factor in pending assignments. =SUMPRODUCT(C4:C8,D4:D8)/SUMIF(C4:C8,">=0",D4:D8). I get that this is a tutorial, but using SUM is just plain lazy and asking for careless mistakes.
Good tip. I think lazy is a strong word. It depends on the case. You use what you need. If assignments are pending we need it. If that is not a scenario we don't.
Hi.. I need help. I need to calculate the final mark between 2 papers. Paper 1 40 marks for 50%. Paper 2 60 marks for 50%. I used the formula in the video but get 131% in total instead of 100%. Could you help me out please?
Great vid! Is there a way I can add an additional element for calculating remaining grade average needed. E.g. Ass 3 and 4 haven't been completed yet...
I didn't get one point. At the end, you divided sumproduct function by sum of the weights which are always 100%. We know that dividing something with 100% we will get the same thing. Then why did you put the total of weights in the denominator of the fraction? Thanks in advance!
I know this is coming late but thanks for the tutorial. I just got a request for weighted average of rates on one of my projects. This video helped me solve it much quicker.
No problem!
I have been assigned some tasks by one of my professors. And what you have shown and explained in the video is exactly what I need. Thanks for saving me as the deadline is approaching! Thank you so much!
You're very welcome. Thanks, Jingyi.
This was extremely helpful. I really liked your presentation and explanation. Thank you for your time and service.
I use the weighted average allt the time as a business controller because it is often more relevant than the usual average in our business. The way you demonstrate it's use is much more efficient than my way so thank you! It really helps :-)
Thank you Alex.
You're a saint, thank you so much
You're welcome 👍🏼
I studied and immediately applied in my work. Love it. Many thanks. :)
You're very welcome 😊 Great to hear!
Thank you so much. This was super important for us when it came down to my daughter’s grades. You made it all so clear. 🤓
Glad it was helpful! Thanks, Susan.
Love your teaching! simple and short. looking forward to more of your videos bro.
Thank you very much Nelson.
Life Saver bro
👍
Super useful! You saved my afternoon! Thank you!!!!!!!!!!
Happy to be there. Thank you, Eunice.
No need to divide by the sum of the weights because the weights are percentages.
yep!
but i guess teaching that helps in getting weighted averages in general, whether the weights are %'s or not
THANK YOU!!!! SO helpful. Appreciate it
Glad it helped. No worries.
how to explain something in four minutes what my excel book tried to do with 15 pages: ^
Never thought I would meet Kuro here teaching us about weighted average 🤣🤣🤣
😊
Such a powerful function
Absolutely Sachin.
Thanks
You're welcome, Justin.
My problem for the weighted average of steel indices as shown in our agreement - like this : -
(iii) Adjustment for Steel Component
Price adjustment for increase or decrease in the cost of Steel procured
by the contractor under different schedules of BOQ shall be paid in
accordance with the following formula:
Formulae-I (for all schedules of BOQ except bill/schedule-2 B & 2
C):
Vs = Ps / 100 X RI X (S1-S0) / S0
Vs = Increase or decrease in the cost of work on the date under
consideration due to changes in the rates for Steel.
S0 = The weighted average of index Numbers of Wholesale
Prices in India by Groups and Sub Groups (Averages) for
(i) MS Bright Bars under Mild Steel -Long
Products sub-group (weight=1)
(ii) Angles, Channels, Sections, steel
(coated/not) under Mild Steel -Long Products
sub-group (weight=2)
(iii) Mild Steel - Flat products sub-group
(weight=1)
published in RBI (Reserve Bank of India) Bulletin / website of the
office of the Economic Adviser in the month on the day 28 days
prior to the closing date of submission of Bids.
S1 = The weighted average of index Numbers of Wholesale Prices
in India by Groups and Sub Groups (Averages) for
(i) MS Bright Bars under Mild Steel - Long Products subgroup
(weight=1)
(ii) Angles, Channels, Sections, steel (coated/not) under
Mild Steel - Long Products sub-group (weight=2)
(iii) Mild Steel - Flat products sub-group (weight=1)
published in RBI (Reserve Bank of India) Bulletin / website of the office
of the Economic Adviser in the month on the day 28 days prior to the
last day of the period to which a particular interim payment certificate is
related.
Ps = Percentage of Steel component of the work.
BASE DATE IS 25 MARCH'2019)
Hope you will understand it properly and will give proper solution that how to get "weighted average of MS Bright Bar, e-Mild Steel - flat product and Angle channels ..)
bs negi
Thanks, Man, it is helpful
Excellent. You're welcome Suralema.
I use this all the time as a mine engineer to calculate copper grades.
Excellent!
1:36 to skip intro
Please make videos on Primavera P6 schedule development to till its completion for a project.
I don't use this software Gopala.
How would you calculate weighted percentile scores? Can this be done?
nice video, helpful
Thank you.
Character In the video It's great, I like it a lot $$
😊
Hey i wanna learn how to find price of something in different weight like example 1k of apple is 1$ but need to determine price of 300g using excel
This only works if %100 of assignments have already been submitted. You need to be using SUMIF instead of SUM in the denominator to factor in pending assignments. =SUMPRODUCT(C4:C8,D4:D8)/SUMIF(C4:C8,">=0",D4:D8). I get that this is a tutorial, but using SUM is just plain lazy and asking for careless mistakes.
Good tip. I think lazy is a strong word. It depends on the case. You use what you need.
If assignments are pending we need it. If that is not a scenario we don't.
Thanks man that's the formula I need
What if you have hidden cells? how do you doge those?
"Average.weighted" function is enough for me.
Hi.. I need help. I need to calculate the final mark between 2 papers. Paper 1 40 marks for 50%. Paper 2 60 marks for 50%. I used the formula in the video but get 131% in total instead of 100%. Could you help me out please?
Great vid! Is there a way I can add an additional element for calculating remaining grade average needed. E.g. Ass 3 and 4 haven't been completed yet...
Thank you. The Goal Seek feature should be able to help with this.
I didn't get one point. At the end, you divided sumproduct function by sum of the weights which are always 100%. We know that dividing something with 100% we will get the same thing. Then why did you put the total of weights in the denominator of the fraction?
Thanks in advance!
This is for scenarios when the weights do not add up to 1.
please show Beta distribution
👌👌
Christian Bale?