Created an excel document I'd like to share but...excel + me and mathing=bad. help!

[Mucko]

I have been working on an excel sheet for the average shooter for several hours (yes, I am not good at excel...been years since I've had to use it)...

I've forgotten how to do the majority of the formulas for mathematics...I was hoping someone could help me out so I can share this with everyone. I have most of it formatted...and color coded...but I have boxes that need to add values from individual rows to their respected boxes to a total of time and shots. basically, I'm trying to say if row 1a/1b = a total value of 60 seconds which is listed at row ag per individual cake...then the total value of all columns in respect to their rows = blah blah for a single input area.

HELP...PM me for my info and I'll send you the file.

Hope everyone had a great weekend...also hope everyone has their stashes at this point...getting late in the season!!

this file is formatted with colors only in sections that you'd have to input values (name and numerics)...but ANYONE can use it for reference if I can get a little help on the math!

thanks,

Mike

[hatsgoods]

there should be a button towards the top right hand corner that says auto sum or formulas. it will be under there somewhere. ill post a video of a free version of excel that is almost similar to the real excel program

[mjbland05]

i am brand new here but i spend a ton of time working in excel and would be happy to help

[Mucko]

its just about done. a few have offered to help which I appreciate. I figured it out on my own but whatever tweaks they recommend I'll take. I based it around what I like to have for info for my own plans. If anyone wants it...just pm me your email.

-Mike

[Mucko]

I've calculated that I have a total of 4603 bursts as part of my show. 217 cakes, 549 artillery shells to fuse up. Estimated total show time of 52 minutes. It's gonna be wired a bit quicker than that ofcourse. Should be a solid 30 of mayhem. God I spent too much this year...OR DID I?

[Bazerk]

How much did you spend this year if you don't mind my asking.

[Mucko]

with shipping 4600, wholesale.

[Bazerk]

Pretty damn good deal if you ask me. Where did you buy from?

[Mucko]

I bought from the same guy I've bought from for several years. Sparky (mark) at sparkysfireworksoutlet

Good guy. between him and Dan...both knowledgeable and detailed. Pleasure as usual.

[mjbland05]

I can second the recommendation on Sparky's. good people & product.