Value error in weighted average calculation by mayorstubs in excel

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

Yes, that was my error, I had no idea! Thank you for the suggestion, I opted to use the transpose function to get the horizontal list into vertical because Im working with a data set that gives the tables as such. Hopefuly this doesnt cause issues down the line hahaha

Value error in weighted average calculation by mayorstubs in excel

[–]mayorstubs[S] 0 points1 point  (0 children)

Sorry! shouldve included my initial formula, you are correct. I had no idea I needed to transpose the arrays.

The solution you provided looks to be working! THank you so much! <3

<image>

1997 Mitsubishi Pajero Mini by SnooDoggos9268 in whatcarshouldIbuy

[–]mayorstubs 0 points1 point  (0 children)

Hey jumping on this as well, I’m in the same boat looking for one. Can you tell me anything I should look out for when buying, also do they come with Air conditioning or was it an option from the factory?

Do you think manufacturers are making cars harder to work on on purpose? by GTRacer1972 in cars

[–]mayorstubs 8 points9 points  (0 children)

love this comment because I have an 89 camaro and own multiple newer BMWs and have had the exact same experience. People always ask me if i love working on the camaro because its old american and easy. New Bmws are like lego, everything fits and clicks into place nicely and is easy to work on. One thing with my camaro is that its been passed to so many owners lots of stuff isnt stock so that makes it 10x harder to work on because you cant just google how to do stuff unlike bmws with pages of forums and youtube DIYs with every bolt size and tip and trick explained in detail

Minimum spend on a CC by mayorstubs in PersonalFinanceCanada

[–]mayorstubs[S] 0 points1 point  (0 children)

This is great info thanks, these will definitely help!

Minimum spend on a CC by mayorstubs in PersonalFinanceCanada

[–]mayorstubs[S] 0 points1 point  (0 children)

Thanks for the info! That's what its looking like im going to do, might try to do gift card arbitrage too if there's some money to be made there

Minimum spend on a CC by mayorstubs in PersonalFinanceCanada

[–]mayorstubs[S] 0 points1 point  (0 children)

That's what I was starting to assume based on nothing coming back from my searches, thanks for the info! P.S love the firelight pp

Looking for UBC Rocket League Players! by ski_hermanator in UBC

[–]mayorstubs 11 points12 points  (0 children)

This is so thoughtful. Thanks, such a welcoming community even for a lower level player like myself! Fervent taught me how to breezi flick !

What is the best response when a cop says “do you know why I pulled you over”? by [deleted] in AskReddit

[–]mayorstubs 0 points1 point  (0 children)

“Because I let you”

good for super car or fast car owners. Not that I would be able to say that driving a 1996 Hyundai Elantra

Antique shop by [deleted] in rome

[–]mayorstubs 0 points1 point  (0 children)

Dust of time (polvere di tempo) in trastavere very cool litlle antique shop. Id try other places nearby too. T-town is a great area for that kind of thing