What topic/subject/thing do you believe you are more knowledgeable of than any other forum member?

[BerkshireBlue]

No need to worry mate, this is used for genuine Excel work, which databases would not be suitable for. A real life example where this could be used, and which I have created, is preparing a sports league table. In its simplest form, all the teams would be listed in alphabetical order, and their results entered in a separate area on the spreadsheet. Points attained are calculated, and entered alongside each team. These points totals are then ranked using Excel's RANK function. A separate table is then used to show the league table, with real time updates every time a new result is entered. The league table has the positions listed from 1 to n, and using index matching, the nth ranked team can be displayed alongside each position in the league. Goals scored, conceded, difference, wins, draws, losses and points can similarly be displayed. The league table is displayed in real time. This is done without any VBA or SQL programming, and is therefore usable on almost any system without the need for Excel's security settings being triggered.

This is the whole problem your schematic IS a database designed system. You are entering scores which should be a table in a database and the calculations (especially the ranking) should be done DB side. Excel should only be your front end for viewing the data. Doing it all on the DB side means you are free to choose the front end as well; tableau, excel, c#, html, it really doesn't matter what front end you use.

 

[Paladin]

This is the whole problem your schematic IS a database designed system. You are entering scores which should be a table in a database and the calculations (especially the ranking) should be done DB side. Excel should only be your front end for viewing the data. Doing it all on the DB side means you are free to choose the front end as well; tableau, excel, c#, html, it really doesn't matter what front end you use.

I agree to an extent, but we're only talking about a small amount of data here, and this Excel model becomes very widely accessible. We often see these kinds of models distributed during sports tournaments, such as the World Cup. It is very easy to distribute a simple Excel model, with no VBA security implications. Less so a database and a front end.

 

[Tuearts right boot]

I can run down every st in Manchester in about ten minutes.

For years my dad used to tell me he knew where Every street in Manchester was.

 

[BerkshireBlue]

I agree to an extent, but we're only talking about a small amount of data here, and this Excel model becomes very widely accessible. We often see these kinds of models distributed during sports tournaments, such as the World Cup. It is very easy to distribute a simple Excel model, with no VBA security implications. Less so a database and a front end.

host the DB on digital ocean and use html front end then everybody has access to it including non Excel/OSX/linux users maximise your customer base.

 

[alib]

Robert De Niro
Washington Redskins
Family Law
Battle of Stalingrad
Hiking Routes in the Lake District

 

[tornandfrayed]

Audax

 

[Big Swifty]

Edith Piaf

 

[Damocles]

I agree to an extent, but we're only talking about a small amount of data here, and this Excel model becomes very widely accessible. We often see these kinds of models distributed during sports tournaments, such as the World Cup. It is very easy to distribute a simple Excel model, with no VBA security implications. Less so a database and a front end.

If your way works for you it's fine.

 

[Daz_Blue]

Tudor History
The band Styx

 

[Daz_Blue]

Vulcan bombers

I thought they were a peaceful race......had lots of logic tho, Spock being the most famous