Who keeps their data in Excel

Moderators: gds, bakerjw, renegade, bamachem

User avatar
Flatliner
Silent But Deadly
Posts: 266
Joined: Tue Nov 17, 2015 4:43 pm

Who keeps their data in Excel

Post by Flatliner »

OK, odd question but who keeps their load data in Excel. The reason I ask is that over the last few years, professionally, I have become what my peers consider to be the go-to guy on Excel. There are some TRULY amazing things it is capable of doing. I have learned a TON from this board and would be willing to do some manipulation to a few spreadsheets and post samples and then, if any of you are interested, I would provide a screen share class or photo tutorial to show how I do various higher end functions as a way to give back.

If there isn't interest or if nobody really uses Excel no issue, just offering.
User avatar
smustian
Silent But Deadly
Posts: 3433
Joined: Thu Aug 08, 2013 5:55 pm
Location: Central Virginia

Re: Who keeps their data in Excel

Post by smustian »

I have used Excel to list load data that people have listed on this board since I joined along with their results. Gives me a quick reference to compare to online data when looking for a start point for load development.
User avatar
bangbangping
Silent But Deadly
Posts: 2695
Joined: Sun Sep 15, 2013 6:34 pm
Location: Texas Gulf Coast

Re: Who keeps their data in Excel

Post by bangbangping »

I'd love to see what you're doing. Don't need Excel lessons but always open to new ideas.
User avatar
plant.one
Silent But Deadly
Posts: 6823
Joined: Tue Jun 23, 2009 8:31 pm
Location: Oakland County, MI

Re: Who keeps their data in Excel

Post by plant.one »

im using OpenOffice
Reloading info shared is based on experiences w/ my guns. Be safe and work up your loads from published data. Web data may not be accurate/safe.
This disclaimer will self destruct in 10 seconds.
golfindia
Silent But Deadly
Posts: 1380
Joined: Thu Jun 20, 2013 1:16 pm

Re: Who keeps their data in Excel

Post by golfindia »

I have a lifetime of my own and family members load data in excel.

I started my spreadsheet a long time ago before I knew anything about excel. I now use excel and access extensively for statistical analyses professionally. One day I'll sit down and revamp my spreadsheet, but it's too much like work so not high on my list!

I'd love to hear any tips and tricks.
Smurky
Silent Operator
Posts: 69
Joined: Thu Aug 11, 2016 5:22 pm
Location: Democratic Peoples Republik of Dane County Wisconsin

Re: Who keeps their data in Excel

Post by Smurky »

I’ve been using excel to compile all the data in one place. Also graph velocity, ES and SD data for loads. I would be interested to see what you’re doing.
User avatar
rebel
Silent But Deadly
Posts: 7285
Joined: Mon Apr 22, 2013 2:01 pm
Location: Moonshine Country

Re: Who keeps their data in Excel

Post by rebel »

I scratch mine on a rock! :mrgreen:
You can't beat the mountain, pilgrim. Mountains got its own way.
User avatar
SwampDog_13
Silent But Deadly
Posts: 542
Joined: Wed Jan 13, 2016 2:15 pm
Location: NC swamp

Re: Who keeps their data in Excel

Post by SwampDog_13 »

rebel wrote:I scratch mine on a rock! :mrgreen:
I was scratching mine in the sand down here but Florance done messed that up for me now. Guess I'll give the excel a go. :mrgreen:
User avatar
bangbangping
Silent But Deadly
Posts: 2695
Joined: Sun Sep 15, 2013 6:34 pm
Location: Texas Gulf Coast

Re: Who keeps their data in Excel

Post by bangbangping »

SwampDog_13 wrote:
rebel wrote:I scratch mine on a rock! :mrgreen:
I was scratching mine in the sand down here but Florance done messed that up for me now. Guess I'll give the excel a go. :mrgreen:
Well, that's a bummer.

I thought rebel had sent me a backup of your data, but I looked and it's just a story about his neighbors dogs screwing up his hunt.
Image
User avatar
Flatliner
Silent But Deadly
Posts: 266
Joined: Tue Nov 17, 2015 4:43 pm

Re: Who keeps their data in Excel

Post by Flatliner »

A couple years ago someone taught me about pivot tables. I found that marginally useful until I discovered slicers. You can do some truly amazing things with them. I am traveling for work right now but will post a sheet with what I am talking about for people who want it to download when I get back home in a few days. If you like it, I am happy to teach you how to do it, with a very small amount of work, you can get a tool that is crazy easy to use, especially if you have a lot of data to sort through.
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 167 guests