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 » Sun Sep 30, 2018 8:55 pm

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.

BulletFlight for Android
User avatar
smustian
Silent But Deadly
Posts:3434
Joined:Thu Aug 08, 2013 5:55 pm
Location:Central Virginia

Re: Who keeps their data in Excel

Post by smustian » Mon Oct 01, 2018 10:38 am

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:2676
Joined:Sun Sep 15, 2013 6:34 pm
Location:Texas Gulf Coast

Re: Who keeps their data in Excel

Post by bangbangping » Mon Oct 01, 2018 11:23 am

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:6816
Joined:Tue Jun 23, 2009 8:31 pm
Location:Oakland County, MI

Re: Who keeps their data in Excel

Post by plant.one » Mon Oct 01, 2018 11:36 am

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 » Mon Oct 01, 2018 11:37 am

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:68
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 » Mon Oct 01, 2018 5:10 pm

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:7283
Joined:Mon Apr 22, 2013 2:01 pm
Location:Moonshine Country

Re: Who keeps their data in Excel

Post by rebel » Mon Oct 01, 2018 5:20 pm

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 » Mon Oct 01, 2018 8:58 pm

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:2676
Joined:Sun Sep 15, 2013 6:34 pm
Location:Texas Gulf Coast

Re: Who keeps their data in Excel

Post by bangbangping » Mon Oct 01, 2018 9:57 pm

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 » Mon Oct 01, 2018 10:25 pm

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