Monter un fichier Excel comme vu sur un site
Bonjour,
Je souhaiterais monter un fichier excel exactement comme sur le site ci-dessous . Tout du moins en ce qui concerne la partie sélection par liste déroulante indépendante
http://www.tennisbetting365.com/thisweek/australian-open/2013/jesse/levine/vs/nicolas/almagro
Je n'ai pas une grande connaissance d'excel (filtre, recherche V, ...)
Mais d'après vous, que faut-il créé d'autre à part un tableau excel ?
En combien d'heures celà peut-il se faire ?
Si vous pouvez me donner la marche à suivre, je vous en serais infiniment reconnaissant.
(je possède excel 2013)
Bonjour,
La réalisation d'un truc comme ça ne se compte pas en heures mais plutôt en jours voir semaine.
Ça nécessite également une bonne connaissance d'Excel et du VBA.
Je ne pense pas que tu puisse y arriver avant la fin des matchs.
A+
Wow, coup de massue. Et bien si c'est le cas, je n'ai plus qu'à laisser tomber...
Bonjour, ça va?
That is all the French I know so I will now switch into English!
Tennisbetting365.com is my website, I saw your backlink in Google Analytics and may be able to help. I only have a Google translation so I may have misunderstood your requirement. Is it just the drop down lists you require?
I used to upload these predictions on a blog, and I would use an Excel Web App to create the interactive interface. The limitations of Excel Web Apps are that you cannot use Active-X controls (like drop down menus) nor can you use VBA. I ended up using Sliders with Pivot Tables in the background to allow player selection. It works quite well, you can see an example here:
Does that answer your question?
Hello Martin,
Thank you very much for your help !!
My english is not good. sorry...
My objective is to facilitate my data entry.
http://www.tennisbetting365.com/thisweek/australian-open/2013/juan-martin/del-potro/vs/roger/federer
I have built a simple excel spreasheet and i enter manually ELO EVOLUTION for all tennis players .
it's very fastidius because i have 4 operations for 1 match.
1- selecting player A with the dropdown and enter ACTUAL ELO on calculating soft
2 - selecting player B with the dropdown and enter ACTUAL ELO on calculating soft
3 - selecting player A with the dropdown and enter NEW ELO on EXCEL SPREADSHEET
4 - selecting player B with the dropdown and enter NEW ELO on EXCEL SPREADSHEET
HERE the example of excel spredsheet
Pos Player Elo Played
Djokovic Novak (SRB) 1322 7
Federer Roger (CHE) 1302 12
Nadal Rafael (ESP) 1284 11
Murray Andy (GBR) 1243 11
Juan-Martin (ARG) 1213 12
Berdych Tomas (CZE) 1212 14
Raonic Milos (CAN) 1185 13
Ferrer David (ESP) 1183 10
Nishikori Kei (JPN) 1162 11
Tsonga Jo-Wilfried (FRA)1159 10
My main objective is to build excel spreadsheet (no need graph) and take me only 2 operations for enter datas . 2 INDEPENDANT PLAYERS LIST BUT THE SAME UDPATE
1- selecting player A with the dropdown, enter ACTUAL ELO on calculating soft
2 - selecting player B with the dropdown and enter ACTUAL ELO on calculating soft
AND ENTER NEW ELO
LIKE YOUR EXCEL SPREADSHEET. (2 independants list and the same update for theses 2 list.
You can answer to me on my email : mattyou.benett [at] gmail.com and give me the following steps if possible.
Thank you very much Martin !
Best regards
Matt