Learning SAS is easy or difficult?
- It is very easy, just type correct command and run program
- But the problem is how to type correct commands
Read more...
September 7, 2009
July 15, 2009
June 25, 2009
Write something
More than 2 weeks in Wageningen passed. A moutain of works are still there: make a good and detail proposal, start to refine the data which can be analyzed, learning SAS, statistics, and need to write something for RIA1 also. Work for all day, even when sleep, dreaming about methodologies, data, but things just go slow and slow.
A day before, the guy from Standford gave a nice lecture on Comic strip of PhD, a lot of laughs in the big room of 200 people. You might want to look through it at http://www.phdcomics.com. I think he has done a good business in selling his books. If I still have money to buy books in my budget, I will buy one.
Read more...
A day before, the guy from Standford gave a nice lecture on Comic strip of PhD, a lot of laughs in the big room of 200 people. You might want to look through it at http://www.phdcomics.com. I think he has done a good business in selling his books. If I still have money to buy books in my budget, I will buy one.
Holiday season is comming, offices are silence and peacefull, July much be the best month in Holland!
Who are good in excel that I can ask? (just move quickly to different topic :)
Who are good in excel that I can ask? (just move quickly to different topic :)
My case is: I have a big database store in excel format, some of the records are wrong and marked as zero (0). Those data have been corrected in another excel file.
Now! I need to copy the data from corrected file to the original file, but it is not easy.
- If I filter the value zero in the original file and copy records from the corrected file and paste, it is not work as the records in original file are in different lines, not closed to each other. (it just show close to each other when we filtering)
- And if I copy and paste record one by one, it takes a lot of time.
Read more...
June 12, 2009
Wageningen
After one week delay, finally I arrived in Wageningen in 8 June. The flight is good because not many people, so I occupied five seats in middle rows of the Boing 777-200 as a bed for 12 hours. This time I stay in Bornsesteeg, at 19th floor, good view to spot center and Hovenstein.
First day start with a lecture of Dr. Daniel Pauly from University of British Columbia, Canada. He said that we should not believe in FAO fisheries data, and I thought that we should not believe his presented data also :)
Second day continued with a meeting with Paul, Arnol Bregt, and their Msc student, Ms. Phuong from CTU. Her thesis is about to develop a model to evaluate the assessibility of fish and shrimp in to mangrove. That was very interesting but let's wait to see how she continues.
In the afternoon, I was going to center to buy a new sim card, this time, again T-mobile is my choice. The guy who sell the card told me that after register on line at T-mobile website, there are 10 euro credit will be added. I have done registration, but 10 euro still has not come, let's wait! After the sim card, went around to find a second hand bicycle, most of them more than 100 euro which I thought not good to invest for only three month stay here. I am trying to find ones cost less than 50 euro but could not. Then I went to Idealis to pay first month renting.
Continued to walk to Zodiac because I have a meeting with Paul in the afternoon to discuss about works in three months in Wageningen. We made a plan that focus on upgrading proposal, and start data entering, statistics. I also have to do more on reading literatures, working with Phuong on the model. Finished discussion with Paul I walked back to Bornsesteeg, so a whole day walking around the city.
The third day I spent all for the proposal, and of course now, a bit for blogging. I am trying focus on proposal for the next some days before sending to Paul, and then move a bit to database.
Read more...
Windows view
Working corner
Kitchen
First day start with a lecture of Dr. Daniel Pauly from University of British Columbia, Canada. He said that we should not believe in FAO fisheries data, and I thought that we should not believe his presented data also :)
Second day continued with a meeting with Paul, Arnol Bregt, and their Msc student, Ms. Phuong from CTU. Her thesis is about to develop a model to evaluate the assessibility of fish and shrimp in to mangrove. That was very interesting but let's wait to see how she continues.
In the afternoon, I was going to center to buy a new sim card, this time, again T-mobile is my choice. The guy who sell the card told me that after register on line at T-mobile website, there are 10 euro credit will be added. I have done registration, but 10 euro still has not come, let's wait! After the sim card, went around to find a second hand bicycle, most of them more than 100 euro which I thought not good to invest for only three month stay here. I am trying to find ones cost less than 50 euro but could not. Then I went to Idealis to pay first month renting.
Continued to walk to Zodiac because I have a meeting with Paul in the afternoon to discuss about works in three months in Wageningen. We made a plan that focus on upgrading proposal, and start data entering, statistics. I also have to do more on reading literatures, working with Phuong on the model. Finished discussion with Paul I walked back to Bornsesteeg, so a whole day walking around the city.
The third day I spent all for the proposal, and of course now, a bit for blogging. I am trying focus on proposal for the next some days before sending to Paul, and then move a bit to database.
Read more...
May 15, 2009
Ca Mau rainy season
It is good to have new flow-meter before going to Ca Mau. The flow-meter looks like a rocket with 6 digits counter inside
The follows are several steps of using it that I tried to find by myself (they provided a not very good manual in deed):
1. Open the screw at back side, inject tap water in to the flow meter, and tighten the screw again.
2. Use a long string to tie one side to the flow-meter, and the other side to a tree or somewhere firmly if you don’t want it swims away.
3. Read the current number on counter, write down the number or just remember if you can.
4. When everything ready, looking your watch and start putting the flow-meter in to water.
5. Make sure the head of flow-meter facing to current direction.
6. After a time, 10 minutes for example, pull up the flow-meter out of water.
7. Read the new number in the counter.
8. Take the difference between new and the last number of the counter.
9. Calculation: The SPEED in cm/sec = Distance in meters multiple (X) 100 and divide (/) Time in seconds.
In that Distance in meters = Difference in COUNTS multiple (X) Rotor Constant and divide (/) 999,999.
And Rotor Constant = 26,873
10. Open the screw to get water out, clean, dry, and put to box for the next using.
So now you know how to get water current speed data :)).
The Spot image also arrived before the trip, so I have it for sites selection. The image was taken on 10 March 2008; resolution is 2.5m, and no cloud. It can be used first for trap sites in mangrove selection, and other purposes later.
Four selected sites at Tan An commune
Four selected sites at TGD commune
It starts rainy season, I've got wet all the time. Camera, laptop, papers…were covered with layers of plastic. Anyway, I have found out new sites for the next experiment. There are 4 sites (yellow dots) for each commune:
- close to shrimp farm and close to river,
- close to shrimp farm and in the forest,
- far from shrimp farm and close to river,
- far from shrimp farm and in forest (see map)
Catch in traps will be collected 8-10 days a month (the days water getting in the forest)
The purpose of this design is trying to answer the questions; what is different of catch between the area close to shrimp farm and far from it; and what is different of catch between the areas close to river and in deep mangrove? We would know the differences of catch between disturbance and undisturbance areas; we also would know the differences of fish/shrimp species between close to river and in deep mangrove.
This trip I involved four more river barrier fishermen for logbook recording. These four river barriers located more in land and close to shrimp farms. Lucky that all of them happy to join the program. But I am still not sure if they can record good data or not. Interesting is people said that river barriers which close to shrimp farm have better catch compare to river barriers close to forest. The reasons are: tiger shrimp escape from shrimp farms, then caught by the barriers, and more inland barriers located far from each other.
I am happy because this time I collected a good secondary data. Mr. Do Chi Sy, head of Fisheries Resource Protection Department let me copy all Ca Mau Fisheries Ms. Access Database and related documents in digital format. So now I can find the Ca Mau fisheries data back to 1989. He also gave me the 2007 province Statistical CD, so I don’t have to go to Statistical Department to buy.
You can enjoy with us some fieldwork activities:
Setup net in the rainy forest, cod-end
Setup net in the rainy forest, entrance
Fish samples storing lab at fishermen house, Mr. Huynh Van Lap
Fish samples storing lab at fishermen house, Mr. Ly Van Loc
Relax time
Going to the forest
Illegal forest cut. Mr. Hung, a border guard, he still found no way to stop this illegal activities, his duty anyway.
Illegal forest cut. The “pirates” put the cut down mangrove everywhere and waiting for suitable time to take out of the forest.
Still beautiful forest
Read more...
The follows are several steps of using it that I tried to find by myself (they provided a not very good manual in deed):
1. Open the screw at back side, inject tap water in to the flow meter, and tighten the screw again.
2. Use a long string to tie one side to the flow-meter, and the other side to a tree or somewhere firmly if you don’t want it swims away.
3. Read the current number on counter, write down the number or just remember if you can.
4. When everything ready, looking your watch and start putting the flow-meter in to water.
5. Make sure the head of flow-meter facing to current direction.
6. After a time, 10 minutes for example, pull up the flow-meter out of water.
7. Read the new number in the counter.
8. Take the difference between new and the last number of the counter.
9. Calculation: The SPEED in cm/sec = Distance in meters multiple (X) 100 and divide (/) Time in seconds.
In that Distance in meters = Difference in COUNTS multiple (X) Rotor Constant and divide (/) 999,999.
And Rotor Constant = 26,873
10. Open the screw to get water out, clean, dry, and put to box for the next using.
So now you know how to get water current speed data :)).
The Spot image also arrived before the trip, so I have it for sites selection. The image was taken on 10 March 2008; resolution is 2.5m, and no cloud. It can be used first for trap sites in mangrove selection, and other purposes later.
Four selected sites at Tan An commune
Four selected sites at TGD commune
It starts rainy season, I've got wet all the time. Camera, laptop, papers…were covered with layers of plastic. Anyway, I have found out new sites for the next experiment. There are 4 sites (yellow dots) for each commune:
- close to shrimp farm and close to river,
- close to shrimp farm and in the forest,
- far from shrimp farm and close to river,
- far from shrimp farm and in forest (see map)
Catch in traps will be collected 8-10 days a month (the days water getting in the forest)
The purpose of this design is trying to answer the questions; what is different of catch between the area close to shrimp farm and far from it; and what is different of catch between the areas close to river and in deep mangrove? We would know the differences of catch between disturbance and undisturbance areas; we also would know the differences of fish/shrimp species between close to river and in deep mangrove.
This trip I involved four more river barrier fishermen for logbook recording. These four river barriers located more in land and close to shrimp farms. Lucky that all of them happy to join the program. But I am still not sure if they can record good data or not. Interesting is people said that river barriers which close to shrimp farm have better catch compare to river barriers close to forest. The reasons are: tiger shrimp escape from shrimp farms, then caught by the barriers, and more inland barriers located far from each other.
I am happy because this time I collected a good secondary data. Mr. Do Chi Sy, head of Fisheries Resource Protection Department let me copy all Ca Mau Fisheries Ms. Access Database and related documents in digital format. So now I can find the Ca Mau fisheries data back to 1989. He also gave me the 2007 province Statistical CD, so I don’t have to go to Statistical Department to buy.
You can enjoy with us some fieldwork activities:
Setup net in the rainy forest, cod-end
Setup net in the rainy forest, entrance
Fish samples storing lab at fishermen house, Mr. Huynh Van Lap
Fish samples storing lab at fishermen house, Mr. Ly Van Loc
Relax time
Going to the forest
Illegal forest cut. Mr. Hung, a border guard, he still found no way to stop this illegal activities, his duty anyway.
Illegal forest cut. The “pirates” put the cut down mangrove everywhere and waiting for suitable time to take out of the forest.
Still beautiful forest
Read more...
Subscribe to:
Posts (Atom)
