Hi Vincent,
I can do 4. East (A-K) and 5. East (L-Z)
Dear AQ members,
I need some help entering fish shop data for use in the new fish shop directory.
The Task
Browse through our existing Fish Shop Directory Forum and copy the data into a spread sheet.
I have divided our fish shop list into groups of about 8 to 12 entries:
1. North East (A-F)
2. North East (G-Z) (ZackZhou is doing.)
3. South (Done Thanks to Shadow.)
4. East (A-K) (Done. Thanks to Bossteck.)
5. East (L-Z) (Done. Thanks to Bossteck.)
6. West (A-O) (Done. Thanks to Tiintinn.)
7. West (P-Z) (Done. Thanks to Tiintinn.)
(I've already done the North category while developing.)
Instructions
1. Pick one (or more) of the groups above. (Check replies below to see which has been taken)
2. Reply to this thread and state which group you picked.
3. Download the Excel sheet from: http://dl.dropbox.com/u/7993331/AQ/aqfsd_fishshops.xlsx
4. Go through the relevant entries in the Fish Shop Directory and copy the data into the columns in the Spreadsheet. (See Column Details below for specific instructions about certain columns).
5. Email the file to admin at aquaticquotient dot com, or upload somewhere that I can download from and drop the link here.
Column Details (See the North sheet for example.)
streetNo: Don't include words like "Blk", "No". Just the number.
streetName: Please spell out words like "Road" and "Avenue" in full. Avoid "Rd" "Ave", etc.
city: Leave it blank.
altNames: Any alternate name that is used in the forum. Usually already include in the current Fish Shop Directory entry in brackets next to their real shop name. Separate with commas.
aqUserName: The shops username in the forum, if any. E.g. Biotope used to be Biotopeshop. (If unsure, leave blank.)
type: Select from the drop down list only. Please do NOT type your own. Choose Farm if they actually breed livestock or grow plants. If they occupy farm land, but only Import and Export, choose Importer/Exporter.
remarks: Paste the Opening Hours only. Leave out the other remarks for now.
lat & lng: Go to http://gmaps-samples-v3.googlecode.c...oder-tool.html to get the values. Download http://dl.dropbox.com/u/7993331/AQ/G...der%20Tool.pdf for instructions to use it. There should be some yellow sticky notes in the PDF file with instructions. If you don't see any, let me know.
categories: Select or type "Y" (Capital) if the shop has those products or services. There can be more then one "Y" for each fish shop. If you don't know for sure, just put down what you know.
Thank you.
Last edited by vinz; 3rd May 2011 at 23:17.
Vincent - AQ is for everyone, but not for 'u' and 'mi'.
Why use punctuation? See what a difference it makes:A woman, without her man, is nothing.
A woman: without her, man is nothing.
Hi Vincent,
I can do 4. East (A-K) and 5. East (L-Z)
- eric
Thanks Eric.
Anyone else can help?
Vincent - AQ is for everyone, but not for 'u' and 'mi'.
Why use punctuation? See what a difference it makes:A woman, without her man, is nothing.
A woman: without her, man is nothing.
I can do south, since I'm staying at south
vinz, so north done already or not? if undone i will do North(g-z). If done, i'll do west (a-o)
haha, just opened the spreadsheet, so northeast (g-z) is undone, thus i'll do that
Thanks, Robert.
Thanks, Zack.
P.S. The spreadsheet is NOT an indicator of what is done as it is the unfilled one. Those that are done (like East by Bossteck) are not updated into the online file.
Vincent - AQ is for everyone, but not for 'u' and 'mi'.
Why use punctuation? See what a difference it makes:A woman, without her man, is nothing.
A woman: without her, man is nothing.
Can I add new fish shop into it? Like JZXboutique?
Zack,
Yes, please do.
Vincent - AQ is for everyone, but not for 'u' and 'mi'.
Why use punctuation? See what a difference it makes:A woman, without her man, is nothing.
A woman: without her, man is nothing.
can do west too ")
Great. Thanks Tiintinn.
Vincent - AQ is for everyone, but not for 'u' and 'mi'.
Why use punctuation? See what a difference it makes:A woman, without her man, is nothing.
A woman: without her, man is nothing.
Tiintinn,
Doing both West? Or just one of them?
Vincent - AQ is for everyone, but not for 'u' and 'mi'.
Why use punctuation? See what a difference it makes:A woman, without her man, is nothing.
A woman: without her, man is nothing.
hey Vinz, can do the whole west. ")
vinz, when i think of it. JZXboutique is located in the north and not north-east if i'm not wrong. nearest mrt is AMK, which is in the range of mrt from woodlands to novena
Zack,
Put it in anyway. The new Fish Shop directory will not be using the regional classification. I'm using it in this exercise to divide up the list into manageable chunks.
Vincent - AQ is for everyone, but not for 'u' and 'mi'.
Why use punctuation? See what a difference it makes:A woman, without her man, is nothing.
A woman: without her, man is nothing.
Roger that
Bookmarks