Forget the server issues - this is what I'm working on... you Excel nuts...
-
That looks like a project, nicely done
-
Very nice! I love statistics and data and numbers, and that is one sexy looking excel file. A sexcel file, if you will.
That excel document is the spreadsheet equivalent of TDKR-era Anne Hathaway.
-
@schnauzerface said in Forget the server issues - this is what I'm working on... Excel nuts...:
Very nice! I love statistics and data and numbers, and that is one sexy looking excel file. A sexcel file, if you will.
That excel document is the spreadsheet equivalent of TDKR-era Anne Hathaway.
I can just picture the numbers and formulas behind the graph right now, droool
-
@arvcpa_psn said in Forget the server issues - this is what I'm working on... Excel nuts...:
It's coming together...
https://twitter.com/twitarvcpa/status/1510004793149898754/photo/1
Shoot - having technical difficulties posting the pic - you'll just have to click on the link. And yes, my Twitter account is "twitarvcpa". I wasn't really thinking when I created it. WHEEEEE!!!
I'll update the pic once I have a weekend full of data. I'll share it with anyone who wants it.
Where does the data come from? is there an API, is this current market data or last years market data? Def interested and looks legit AF
-
Nice! I started adapting my depth chart and lineup spreadsheet from 21 today, until I realized the API doesn't have all of the cards in the database yet. At least it’s all set up for when the database is complete.
-
@arvcpa_psn said in Forget the server issues - this is what I'm working on... Excel nuts...:
It's coming together...
https://twitter.com/twitarvcpa/status/1510004793149898754/photo/1
Shoot - having technical difficulties posting the pic - you'll just have to click on the link. And yes, my Twitter account is "twitarvcpa". I wasn't really thinking when I created it. WHEEEEE!!!
I'll update the pic once I have a weekend full of data. I'll share it with anyone who wants it.
Here is a jpeg of my lineup sheet. This is all automated and driven by the database downloaded from the API. The batter's graph changes depending on who I have highlighted (who is batting) and the pitcher's graph changes depending on who I am facing.
There are some behind the scene things to do each time the database or inventory is uploaded (changed) but it only takes about 15 minutes, and then it is all good to go.
https://www.dropbox.com/s/tk9idp07vui8fh8/Lineup %26 Depth Chart.jpg?dl=0
Here is a PDF shot in case it's easier to see. I had to squish it all onto one sheet to do this - it's not this small in my spreadsheet.
https://www.dropbox.com/s/96kf7irxzqtfua4/Lineup %26 Depth Chart.pdf?dl=0
-
Man, I gotta learn how to work with API stuff
-
@magic1313_xbl said in Forget the server issues - this is what I'm working on... Excel nuts...:
Man, I gotta learn how to work with API stuff
Watch my video on youtube. It's long and boring, but I show how to download it and work with it. I have two youtube channels - Blind Bleeder and CWatsonJr.
Once I get my spreadsheet fully integrated with 22, I will stream a new video on Twitch and then store it on my Blind Bleeder youtube channel (because the Twitch video will disappear after a while).
-
@blind_bleeder said in Forget the server issues - this is what I'm working on... Excel nuts...:
@magic1313_xbl said in Forget the server issues - this is what I'm working on... Excel nuts...:
Man, I gotta learn how to work with API stuff
Watch my video on youtube. It's long and boring, but I show how to download it and work with it. I have two youtube channels - Blind Bleeder and CWatsonJr.
Once I get my spreadsheet fully integrated with 22, I will stream a new video on Twitch and then store it on my Blind Bleeder youtube channel (because the Twitch video will disappear after a while).
Awesome, def gonna check it out. Thank You
-
Is the data live or are you manually updating?
-
@magic1313_xbl said in Forget the server issues - this is what I'm working on... Excel nuts...:
@arvcpa_psn said in Forget the server issues - this is what I'm working on... Excel nuts...:
It's coming together...
https://twitter.com/twitarvcpa/status/1510004793149898754/photo/1
Shoot - having technical difficulties posting the pic - you'll just have to click on the link. And yes, my Twitter account is "twitarvcpa". I wasn't really thinking when I created it. WHEEEEE!!!
I'll update the pic once I have a weekend full of data. I'll share it with anyone who wants it.
Where does the data come from? is there an API, is this current market data or last years market data? Def interested and looks legit AF
I'm actually "Brute Forcing" the data. I'm simply using the Excel "Web Query" function, and grabbing each page of all the current player market data. Currently, there's 68 pages (by the end of the 21 cycle, I think there were about 90 pages).
Each query is a separate tab in the worksheet, and I do a quick "consolidate" to squish all the data into one tab. It took me about an hour to set it up, and it takes less than a minute to refresh it.
I'm refreshing the data 4 times a day, and I'll do this for the first few weeks to see the trends in how much the various cards move throughout the month.
-
@savefarris_psn said in Forget the server issues - this is what I'm working on... Excel nuts...:
Is the data live or are you manually updating?
^^^^ technically "live".
-
Better than me. I had to go into work today (THANKS, BOSS!!!), so I’m spending all day entering LS data.
-
@arvcpa_psn said in Forget the server issues - this is what I'm working on... you Excel nuts...:
@magic1313_xbl said in Forget the server issues - this is what I'm working on... Excel nuts...:
@arvcpa_psn said in Forget the server issues - this is what I'm working on... Excel nuts...:
It's coming together...
https://twitter.com/twitarvcpa/status/1510004793149898754/photo/1
Shoot - having technical difficulties posting the pic - you'll just have to click on the link. And yes, my Twitter account is "twitarvcpa". I wasn't really thinking when I created it. WHEEEEE!!!
I'll update the pic once I have a weekend full of data. I'll share it with anyone who wants it.
Where does the data come from? is there an API, is this current market data or last years market data? Def interested and looks legit AF
I'm actually "Brute Forcing" the data. I'm simply using the Excel "Web Query" function, and grabbing each page of all the current player market data. Currently, there's 68 pages (by the end of the 21 cycle, I think there were about 90 pages).
Each query is a separate tab in the worksheet, and I do a quick "consolidate" to squish all the data into one tab. It took me about an hour to set it up, and it takes less than a minute to refresh it.
I'm refreshing the data 4 times a day, and I'll do this for the first few weeks to see the trends in how much the various cards move throughout the month.
interesting, can't wait to see it done, about to do some analysis on how the new quicksell values will affect making stubs on player upgrades vs the old system
-
@savefarris_psn said in Forget the server issues - this is what I'm working on... you Excel nuts...:
Better than me. I had to go into work today (THANKS, BOSS!!!), so I’m spending all day entering LS data.
Wait - entering LS data? What type of data? I probably have it in a download I can email you (if it's the card data and stats) - that is, if you don't want to download the API.
-
@arvcpa_psn said in Forget the server issues - this is what I'm working on... you Excel nuts...:
@magic1313_xbl said in Forget the server issues - this is what I'm working on... Excel nuts...:
@arvcpa_psn said in Forget the server issues - this is what I'm working on... Excel nuts...:
It's coming together...
https://twitter.com/twitarvcpa/status/1510004793149898754/photo/1
Shoot - having technical difficulties posting the pic - you'll just have to click on the link. And yes, my Twitter account is "twitarvcpa". I wasn't really thinking when I created it. WHEEEEE!!!
I'll update the pic once I have a weekend full of data. I'll share it with anyone who wants it.
Where does the data come from? is there an API, is this current market data or last years market data? Def interested and looks legit AF
I'm actually "Brute Forcing" the data. I'm simply using the Excel "Web Query" function, and grabbing each page of all the current player market data. Currently, there's 68 pages (by the end of the 21 cycle, I think there were about 90 pages).
Each query is a separate tab in the worksheet, and I do a quick "consolidate" to squish all the data into one tab. It took me about an hour to set it up, and it takes less than a minute to refresh it.
I'm refreshing the data 4 times a day, and I'll do this for the first few weeks to see the trends in how much the various cards move throughout the month.
I wonder if your Web Query idea will work to grab the Inventory...but how to separate what I own vs all of it (which is available in the API, so there is no point to that). Currenly, I'm copy/pasting the Inventory I own from the web.
-
@blind_bleeder said in Forget the server issues - this is what I'm working on... you Excel nuts...:
@arvcpa_psn said in Forget the server issues - this is what I'm working on... you Excel nuts...:
@magic1313_xbl said in Forget the server issues - this is what I'm working on... Excel nuts...:
@arvcpa_psn said in Forget the server issues - this is what I'm working on... Excel nuts...:
It's coming together...
https://twitter.com/twitarvcpa/status/1510004793149898754/photo/1
Shoot - having technical difficulties posting the pic - you'll just have to click on the link. And yes, my Twitter account is "twitarvcpa". I wasn't really thinking when I created it. WHEEEEE!!!
I'll update the pic once I have a weekend full of data. I'll share it with anyone who wants it.
Where does the data come from? is there an API, is this current market data or last years market data? Def interested and looks legit AF
I'm actually "Brute Forcing" the data. I'm simply using the Excel "Web Query" function, and grabbing each page of all the current player market data. Currently, there's 68 pages (by the end of the 21 cycle, I think there were about 90 pages).
Each query is a separate tab in the worksheet, and I do a quick "consolidate" to squish all the data into one tab. It took me about an hour to set it up, and it takes less than a minute to refresh it.
I'm refreshing the data 4 times a day, and I'll do this for the first few weeks to see the trends in how much the various cards move throughout the month.
I wonder if your Web Query idea will work to grab the Inventory...but how to separate what I own vs all of it (which is available in the API, so there is no point to that). Currenly, I'm copy/pasting the Inventory I own from the web.
I'm trying the same method I used to get market data to pull inventory, and for the life of me, I can't get it to work. It's pulling the login screen. Probably because the market data is generic and inventory is "specific"? That's as technical as I can get
-
A admin locked this topic on
