Ha! I drove right by here not knowing there were colorful scenes like this awaiting. Most fossil beds areas look kinda dull, but not this one.
I have a few questions for you: does the toolkit work in OpenOffice? Has anyone tried to port it there from Excel? I don't have Excel and failed to get it working in Quattro Pro many months ago. Also, what does the toolkit do these days, besides the vote counting and results list, that is? Does it prepare the various forum opening/closing statements (I thought mods were copy/pasting that stuff) and the Top 10 list with photo links and all its detailed formatting? Does it create the award as well? :) (I doubt the last, but you never know till you ask)
You and Wim continue to work wonders with this quick-and-dirty contest I'd started on a whim way back in March 2008.
Thanks a lot for all your efforts, Brian
Hi Brian, Just got around to mapping this, and in the process came upon Jim Dockery http://www.panoramio.com/user/289226 with some on his front page.
I had previously looked into OpenOffice Calc, but it does not have macros, and the Toolkit makes heavy use of Visual Basic code.
Similar problem with the free Excel viewer, as well as the fact that editing is required when using the Toolkit.
Google docs? no macros.
To get some idea of what you are missing, go to http://vm.npc.nl.eu.org/ and see the link to “How the Toolkit developed” for some screen shots.
No long instructions needing translation, but short prompts and green highlighting are a guide to the next step.
Yes the Toolkit does have templates for the moderator posts, useful if the mod has not used the “reply with quote” prior to the previous contest thread being closed, though of course available from many helpers.
There is the full list of results and the Top Ten for forum posts, and a variation of a voting machine for the results I put on my site.
It provided a viewing and selection feature for voting, and then for those without Excel, then I developed html Voting Machine, which it produces, and with Wim’s latest work it will be possible for authorised people to upload them, (and not needing Excel because “Vote Counter Plus” can also create a VM).
Also, it does various checks, for a user entering twice, self voting, over or under the number of votes.
The award photo: I admit that I could not conceive how it would be possible, surely need a photo editing application, how to manipulate an image within Excel was beyond me. But Wim managed it, and it could be improved but I am not sure the effort is warranted. It is good to have some variety in the awards, a little personal touch by the mod.
Initially after joined Panoramio it did become an important interest and pastime for me, but the way the software development with Wim has occupied me, and the appreciation expressed by so many, has been a wonderful ride, all due to your contest concept, may the NPC live on from strength to strength.
OK, after entering letters (a,b,c,d) in the blanks above 'Winners Post' button I see that the 4 fields are for YEAR, MONTH, PHOTO ID# of award certificate and a general comment. Thanks! Very cool stuff, Rob! Cheers, Brian
Hi Brian, Thank you very much for taking a look and providing feedback. I am happy that a bit of trial and error led you to the solution. My excuse for using hover text tips, and not labels, for those boxes is that things like text boxes and buttons can be hidden and then made visible, but not plain text. So I have not modified the page layout, but have extended the message for entering values.
Thank you for your entry into the CFP!
Good luck, Crina.
Sign up to comment.
Sign in if you already did it.
Photo taken in John Day Fossil Beds National Monument, 32651 Highway 19, Kimberly, OR 97848, USA
Misplaced? Suggest new location