| Hobie Forums http://www.hobie.com/au/en/forums/ |
|
| Sailing sites spreadsheet http://www.hobie.com/au/en/forums/viewtopic.php?f=32&t=60110 |
Page 1 of 1 |
| Author: | TI_Tom [ Sun Mar 26, 2017 12:30 pm ] |
| Post subject: | Re: Sailing sites spreadsheet |
If you end up with multiple rows per site you might be better served by a database instead of a spreadsheet. It would allow you to have many to many relationships between a site and any of the conditions. Basically each of your columns becomes it's own table with a relational table between it and the site table. You could then write some simple queries against the tables passing in the conditions and the watercraft and returning the best location. Sorry if I'm confusing you, I'm a database and data administrator and I tend to look at data different than most folks. Sent from my SPH-L720T using Tapatalk |
|
| Author: | TI_Tom [ Sun Mar 26, 2017 7:13 pm ] |
| Post subject: | Re: Sailing sites spreadsheet |
Hmmm...I've heard of Prolog, but have never seen it. If you're looking for a free database MySQL is an open source database owned by Oracle. It supports you're typical jdbc connections so you can easily write an ASP based application or Java based applications (asp.net and Java are both free to use as well). That might all be more than you're looking for though. Hell, Microsoft Access will do the job just fine and you can create reports that are based on a form that queries the tables in the database. Sent from my SPH-L720T using Tapatalk |
|
| Author: | TI_Tom [ Fri Apr 14, 2017 5:15 am ] |
| Post subject: | Re: Sailing sites spreadsheet |
If you want something similar to Microsoft Office on the cheap...OpenOffice works amazing and it's compatible with Microsoft extensions. |
|
| Author: | TI_Tom [ Mon May 08, 2017 5:12 pm ] |
| Post subject: | Re: Sailing sites spreadsheet |
You're not blogging to yourself. I'm following [SMILING FACE WITH SMILING EYES] Sent from my SPH-L720T using Tapatalk |
|
| Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|