Hello! My team (178) is working on making the electronic scouting a thing. We are using the app “Robot Scouter” from Google Play. The problem comes in when we try to organize it in a specific way. It should do according:
Merge overview sheets to make 1 master overview sheet of the whole competition
If there are multiple sheets of the same team (ex. Different matches are recorded on different tablets) merge them into one
Pretty much, in the end, we want an excel file with an overview sheet of the whole competition with averages, most recent comment, etc, and also individual sheets for each team and all of their match records. This is what we got so far:
Sub Apple()
Count = 1
Dim a1 As String
Dim a2 As String
a1 = Sheets(“Sheet” & Count).Cells(3, 2).Value
a2 = Sheets(“Sheet” & Count + 1).Cells(3, 2).Value
Dim compareNames As Boolean
If (a1 = a2) Then
compareNames = True
Count = Count + 1
Else
compareNames = False
Count = Count + 1
End If
If compareNames = True Then
‘put the code to merge 2 files with the same team number’
‘Set combineSheet = ActiveWorkbook.Sheets("New " & Sheets(Count).Range(“B3”))’
Sheets.Add After:=ActiveSheet
ActiveSheet.Name = “Temp”
Sheets(“Sheet” & Count).Select
Cells.Select
Cells.Copy
Sheets(“Temp”).Paste
Sheets(“Sheet” & Count).Delete
‘method that will find a first empty cell in row #1 and paste data from here’
‘otherwise, it pastes data on top of other important data, which is not good’
‘Method to merge 2 sheets on top of each other’
‘With Worksheets(“Temp”)’
’ .Range(Cells.Address).Copy ’
‘.Range(Cells.Address).PasteSpecial _’
’ Operation:=xlPasteSpecialOperationAdd’
‘End With’
Sheets(“Sheet” & (Count + 1)).Delete
Hey! One of my team’s (2521) alumni developed the “Robot Scouter” app and this will be our third year using it. Unfortunately, I’m not familiar with VBA and probably won’t be able to give you any specific programming tips.
However, I did want to share how our team analyzes data collected from the app. The Excel analysis file that RS spits out is great, but we’ve found that re-arranging the data is both much easier to do and more elegant using a separate software. Our team started using Tablaeu last season and we’ve been really enjoying it (Here and here are a few examples of how we used it last year – if you do some digging around you’ll be able to find some examples made by other teams that are much nicer than what we’ve been able to make so far). I think it’ll be able to do all of the things without requiring tons of additional work.
We’ve written a short article detailing our entire process (including how we get our Robot Scouter data into Tableau and what you can do with it) if you’re interested in learning more about how my team goes about doing it.
It’s really cool to see more teams using Robot Scouter, and we really appreciate your team giving it a try! I do apologize that I can’t help you with the programming aspect of your question but I hope the others resources will be helpful!
Hello! I looked at Tableau, at it looks very useful tool for organizing. Since we are using Robot Scouter together, I wonder if there is a descriptive guide on how to manage files from Robot Scouter and put them and organize them through Tableau. If you’re willing to help, or if you know the source of that guide, I would really appreciate your help. Thank you!
Absolutely! We’ve written a complete guide about that here. If you just want to know how to get Robot Scouter data into Tableau, we have shorter step-by-step tutorial for that as well.
If you have any other questions, please feel free to let me know!
I’m not sure, but I cannot access the link that you putted into hyperlinked word “here”. Nothing is happening when I click it, and I’m not sure if that’s because you forgot to put the link, or something is wrong with my laptop. Can you please just copy and paste the link?
We’ll be at WNE in a few weeks with you guys. Would you mind meeting up to compare and contrast scouting? We’ve been focusing on that side of things for a couple years and are always looking to improve.
Hello, sorry for late response. I think this is a great idea to meet together, since we also changed the system of electronic scouting. How about meeting together during lunch on that event?
