Thanks guys I suspected Excel might be able to handle it. So I assume
Libreoffice Calc should be capable as well.
Chris
On 05/02/14 08:55, Allen Han wrote:
Google doc?
if ur client does not require a fancy UI.
On Feb 5, 2014 8:53 AM, "Harvey Kane" <[email protected]
<mailto:[email protected]>> wrote:
Excel would handle this just fine if they need something cheap and
simple and don't need multiple computers accessing the file at
once. I would put each member on their own row and have columns
for each species / weight class, then a formula at the end of the
row to calculate the points for that row / member.
Eg:
Member Name / Snapper 1kg / 2kg / 5kg / Gurnard 1kg / 2kg / 5kg /
Total
Otherwise there are hosted database systems out there where you
design your database and get a GUI for entering data. You might be
able to fashion something with one of these without any programming.
Or if something custom is required, a set of forms and controllers
to interact with a database in your CMS of choice wouldn't be
terribly difficult either.
Harvey.
On 4/02/2014 12:24 p.m., chris morris wrote:
Hi all - this may be slightly OT but I'm throwing it in here
anyway.
I've been asked to find a software solution for a local
fishing club. They want to be able to pick from preset
species/weights/quantities at weigh in time something like this.
Anglers Name | species list | weights |quantities for each
species |total points for his catch.
So for example:
Joe Bloggs turns up at weigh-in with 3 snapper of 1, 2, and
3kg, he also has 2 trevally of 2 and 4kg weights.
Each species would have points allocated by weight. So for
example:
A 1kg snapper might be worth 30 points, and a 2kg snapper
might be worth 45 points.
A 1kg Trevally might be worth 20 points and 35points for a 2kg.
What they want the software to do. (and not do)
They want the software to add up the points (per fish) for
each fish in each species caught and provide sub-total and
grand total.
(They don't want it to add 3 fish together and allocate points
as if it were one big fish)
I'm imagining something with dropdown lists of species and
weight-brackets.
Like a spreadsheet with all the competitors names down one
column, species and weight dropdowns in the following columns etc.
Could this even be done with excel perhaps?
Is there a cms or something out there that would come close?
cheers
Chris
--
Harvey Kane
Phone:
- Auckland: +64 9 950 4133 <tel:%2B64%209%20950%204133>
- Wanaka: +64 3 746 8133 <tel:%2B64%203%20746%208133>
- Mobile: +64 21 811 951 <tel:%2B64%2021%20811%20951>
Email: [email protected] <mailto:[email protected]>
If you need to contact me urgently, please read here
http://urgent.harveykane.com
--
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
<mailto:[email protected]>
To unsubscribe, send email to
[email protected]
<mailto:nzphpug%[email protected]>
--- You received this message because you are subscribed to the
Google Groups "NZ PHP Users Group" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected]
<mailto:nzphpug%[email protected]>.
For more options, visit https://groups.google.com/groups/opt_out.
--
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
---
You received this message because you are subscribed to the Google
Groups "NZ PHP Users Group" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
--
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
---
You received this message because you are subscribed to the Google Groups "NZ PHP Users Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
