What can I export into excel?

daves · 11-24-2019, 06:19 PM

With tournaments I am trying to build various teams. How can I export my team collection into excel with the type of card?

Barmy Fungy-Phipps · 11-24-2019, 07:37 PM

In any tournament, activate all the players you want to look at. Reserve roster or active, doesn't matter. Then go to your player list, and customize it for whatever you want to see - ratings, stats, whatever you want.

Then, on the drop down menus right above the list of players, select "Report" and choose "Write report to disk". That will open the report in your browser. From there, just copy and paste into your spreadsheet.

Dogberry99 · 11-25-2019, 11:30 AM

This didn't work right for me. Is there a way to keep it from pasting the report's wonky formatting?

Barmy Fungy-Phipps · 11-25-2019, 11:34 AM

I had to insert an extra cell to get the headers to line up over the columns. And I did delete some stuff that was extra/unnecessary.

Dogberry99 · 11-25-2019, 11:36 AM

I'll try it again later, but I thought part of my issue was the html formatting between each field, not just the headers and such. Thank you though!

Lemandria · 11-25-2019, 01:39 PM

Quote:

Originally Posted by daves

With tournaments I am trying to build various teams. How can I export my team collection into excel with the type of card?

Anything you can export to web view is just a copypasta from Excel.

You can save reports directly to drive, but the filenames and finding yiur output is a problem

Renfro · 11-26-2019, 09:54 AM

The process is fun and simple: create your Custom View of the stats you want to see.

For pitchers, I just use G GS W L IP HA HR ER BB K AVG. You can come up with the rest of the basic stats ratios (k/9, etc) with those. The reason I export AVG is because I haven't found a way to actually have excel calculate the average simply because I don't think we have access to all the stats that make up opponent batting average. That is, we're missing Sac Hits, Sac Flies, and Catcher Interference.

If you have your spreadsheet rows aligned, the Copy Paste works good except for the first row. But it's just a matter of moving over that first row once you are in Excel. I think this has something to do with HTML white space? It's easy to get around.

Leo_The_Lip · 11-26-2019, 10:57 AM

I have gotten this to work for my the list of my active and reserve roster, However I would like to examine ALL my players with the objective of getting my most efficient roster for a 1500 limit league.

Is there any way to do this without tediously activating and deactivating all 835 of my cards?

Barmy Fungy-Phipps · 11-26-2019, 11:08 AM

Renfro, I was able to find sac flies/hits and catcher interference in the custom stats.

Leo, I don't know of any. I haven't been able to access a card in any way except when activated.

11-24-2019, 06:19 PM	#1
daves Hall Of Famer Join Date: Dec 2007 Posts: 3,635	What can I export into excel? With tournaments I am trying to build various teams. How can I export my team collection into excel with the type of card? __________________

11-25-2019, 11:30 AM	#3
Dogberry99 All Star Starter Join Date: Nov 2018 Location: Wichita Falls, TX Posts: 1,328	This didn't work right for me. Is there a way to keep it from pasting the report's wonky formatting? __________________ "And, Masters, do not forget to specify, when time and place shall serve, that I am an [censored]." (Much Ado About Nothing 5.1.255-256) Primary Team Collection Rewards (Cards & Packs) F2P Theme Team Movers F2P Theme and Adam Schlesinger Memorial Team

11-25-2019, 11:36 AM	#5
Dogberry99 All Star Starter Join Date: Nov 2018 Location: Wichita Falls, TX Posts: 1,328	I'll try it again later, but I thought part of my issue was the html formatting between each field, not just the headers and such. Thank you though! __________________ "And, Masters, do not forget to specify, when time and place shall serve, that I am an [censored]." (Much Ado About Nothing 5.1.255-256) Primary Team Collection Rewards (Cards & Packs) F2P Theme Team Movers F2P Theme and Adam Schlesinger Memorial Team

11-26-2019, 09:54 AM	#7
Renfro Minors (Double A) Join Date: Aug 2015 Posts: 197	The process is fun and simple: create your Custom View of the stats you want to see. For pitchers, I just use G GS W L IP HA HR ER BB K AVG. You can come up with the rest of the basic stats ratios (k/9, etc) with those. The reason I export AVG is because I haven't found a way to actually have excel calculate the average simply because I don't think we have access to all the stats that make up opponent batting average. That is, we're missing Sac Hits, Sac Flies, and Catcher Interference. If you have your spreadsheet rows aligned, the Copy Paste works good except for the first row. But it's just a matter of moving over that first row once you are in Excel. I think this has something to do with HTML white space? It's easy to get around. __________________

11-26-2019, 10:57 AM	#8
Leo_The_Lip All Star Starter Join Date: Nov 2009 Posts: 1,703	I have gotten this to work for my the list of my active and reserve roster, However I would like to examine ALL my players with the objective of getting my most efficient roster for a 1500 limit league. Is there any way to do this without tediously activating and deactivating all 835 of my cards? __________________ "My name will live forever" - Anonymous

11-24-2019, 07:37 PM	#2
Barmy Fungy-Phipps Minors (Rookie Ball) Join Date: Mar 2015 Posts: 41	In any tournament, activate all the players you want to look at. Reserve roster or active, doesn't matter. Then go to your player list, and customize it for whatever you want to see - ratings, stats, whatever you want. Then, on the drop down menus right above the list of players, select "Report" and choose "Write report to disk". That will open the report in your browser. From there, just copy and paste into your spreadsheet.

11-25-2019, 11:34 AM	#4
Barmy Fungy-Phipps Minors (Rookie Ball) Join Date: Mar 2015 Posts: 41	I had to insert an extra cell to get the headers to line up over the columns. And I did delete some stuff that was extra/unnecessary.

11-26-2019, 11:08 AM	#9
Barmy Fungy-Phipps Minors (Rookie Ball) Join Date: Mar 2015 Posts: 41	Renfro, I was able to find sac flies/hits and catcher interference in the custom stats. Leo, I don't know of any. I haven't been able to access a card in any way except when activated.