Arrange Place, Latitude and Longitude in an excel.
Then import it to Google Fusion Table
Go to the maps in the third tab
Download the content in kml format.
Open it in google map
Wednesday, October 17, 2012
Tuesday, October 16, 2012
Excel Table to One Coloumn
Press Alt+F11 to open the VBE
Press Control+R to view the Project Explorer
Sub MakeOneColumn()
Dim vaCells As Variant
Dim vOutput() As Variant
Dim i As Long, j As Long
Dim lRow As Long
If TypeName(Selection) = "Range" Then
If Selection.Count > 1 Then
If Selection.Count <= Selection.Parent.Rows.Count Then
vaCells = Selection.Value
ReDim vOutput(1 To UBound(vaCells, 1) * UBound(vaCells, 2), 1 To 1)
For j = LBound(vaCells, 2) To UBound(vaCells, 2)
For i = LBound(vaCells, 1) To UBound(vaCells, 1)
If Len(vaCells(i, j)) > 0 Then
lRow = lRow + 1
vOutput(lRow, 1) = vaCells(i, j)
End If
Next i
Next j
Selection.ClearContents
Selection.Cells(1).Resize(lRow).Value = vOutput
End If
End If
End If
End Sub
Saturday, June 23, 2012
Changing Excel Column Data to Row
While I was dealing with some climate excel data (rainfall) it was recorded as follows,
2000 - Jan 10
2000 - Feb 16
2000 - Mar 1
2000 - Apr 14
2000 - May 19
2000 - Jun 12
But I wanted data in below format,
Jan Feb Mar Apr May Jun
10 16 1 14 19 12
So the steps are as follows,
Select the coloumn,
Select Copy
Right Click
Paste Spatial
Select Value (in Paste) , and Transpose
Click OK
2000 - Jan 10
2000 - Feb 16
2000 - Mar 1
2000 - Apr 14
2000 - May 19
2000 - Jun 12
But I wanted data in below format,
Jan Feb Mar Apr May Jun
10 16 1 14 19 12
So the steps are as follows,
Select the coloumn,
Select Copy
Right Click
Paste Spatial
Select Value (in Paste) , and Transpose
Click OK
Friday, March 23, 2012
Sunday, March 18, 2012
How to speed up web site laoding time part 1
- Do not let browser to reside the images.Spend another 45 second on the image-> edit it from photo shop -> then upload
- remove white space in the code -> better open the code in server it self and check it.
- load fewer external objects. Do not embed youtube, slideshare in the home page
- try to minimize java script conditions in the home page.
Friday, February 10, 2012
in Visual Studio how to make components relative to parent
Please follow the below steps to make the Visual Studio components relative to Parent. So when the client expand the windows form components are also adjusting. So very convenient.
1.Select a component.
2.Go the component properties.
3.Use Anchor button to make the component relative to the parent
1.Select a component.
2.Go the component properties.
3.Use Anchor button to make the component relative to the parent
How to Setup the BlackBerry 1.5 jde in Windows 7
1.Download the jre 1.5 or higher version and install it.
2.Run the BlackBerry_JDE_5.0.0.exe.
3.Go to the start menu and run the jde.
4.If it gives a message window in random time.
5.Run the jde as administrator.
6.If it gives an error message too follow the following steps.
7.Go to the msconfig.exe in start menu.
8.In Tools tab click on Change UAC Settings and click Launch button.
9.Set the motion button to never notify aand click ok.
10.Restart your computer.
2.Run the BlackBerry_JDE_5.0.0.exe.
3.Go to the start menu and run the jde.
4.If it gives a message window in random time.
5.Run the jde as administrator.
6.If it gives an error message too follow the following steps.
7.Go to the msconfig.exe in start menu.
8.In Tools tab click on Change UAC Settings and click Launch button.
9.Set the motion button to never notify aand click ok.
10.Restart your computer.
Saturday, February 4, 2012
Clear loaded projects in Simulator of Blackberry Java Plug in for Eclips
When there are many test blackberry projects loaded to the simulator we get confused. Specially when there are many versions in the same same project.
The best option is to clean your blackberry simulator.
The steps are as follows,
In the top menu go to projects ->
Blackberry ->
Clean Simulator
This make simulator clean and comfortable
The best option is to clean your blackberry simulator.
The steps are as follows,
In the top menu go to projects ->
Blackberry ->
Clean Simulator
This make simulator clean and comfortable
Saturday, January 28, 2012
Embed Ajax to windows applications
Currently we are doing technical analysis to www.cse.lk advisory and we wanted to present his the details in much attractive manner. So I found a good ajax graphs library and did a web based applications. But later I thought to present them in a windows format so that customer is very convenience on it. So I embed the html pages from visual studio web browser component in the "Common Controls" section. You have to drag the component and set the URL.
Thursday, January 26, 2012
Sanetra Solutions on tripadvisor slideshow
Profile Photos Slideshow: Sanjurat’s trip to Colombo, Sri Lanka was created by TripAdvisor. See another Colombo slideshow. Create your own stunning free slideshow from your travel photos.
Wednesday, January 25, 2012
set default file when navigating to sub folder
I am used to develop joomla sites and host in CLOUDLINUX. So home directory by default redirect to index.php page. Recently I developed a pure HTML site. For testing purposes I used my CLOUD LINUX server. It can read index.html as the default folder file.
In this project customer gave his windows server. Surprisingly it did not read index.html page. But it identifies home.htm page. So I did little change in my structure to priorities home.htm.
In this project customer gave his windows server. Surprisingly it did not read index.html page. But it identifies home.htm page. So I did little change in my structure to priorities home.htm.
Monday, January 23, 2012
Joomla 1.7 how to link to Articles : JCE is not working
I enjoyed JCE editor very much compared to TinyMC editor in Joomla. But joomla 1.7 does not support JCE. I was fed up. But I am catching up with small techniques
How to link to an Article in Joomla 1.7?
I used the basic Strategy. Hidden menu in Joomla to link to article.
How to link to an Article in Joomla 1.7?
I used the basic Strategy. Hidden menu in Joomla to link to article.
- First I create a hidden menu and link all the required articles.
- Then in my main article I link to those main items.
This sorted my issue. But this is not user friendly.
Monday, January 16, 2012
FTP vs Cpanel : Softculous
my hosting service providing company provides both cpanel a FTP login details upload the web site. Lot of people prefer FTP compare to cpanel because you can instruct FTP tool to upload the site while you are sleeping
But there is a great advantages in cpael compare to FTP
We are not providing our serer details to ay thir party So it provides great security
But now I am using Softculous. So I do not want cpanel upload or ftp uploads I ca install joomla on the fly.
.
But there is a great advantages in cpael compare to FTP
We are not providing our serer details to ay thir party So it provides great security
But now I am using Softculous. So I do not want cpanel upload or ftp uploads I ca install joomla on the fly.
.
Friday, January 13, 2012
Embed youtube videos to joomla 1.7
When I use joonla 1.5 I was able to embed you tube videos for my web sites with out any issue. But Embedding you tube videos on joomla 1.7 was not straight forward. It requires few additional steps.
Step 01: In Joomla Administrator first go to article options. There under super user (for other required privileged) set text filtering to "NO" . This is under text filtering section.
Step 02: Now navigate to plugin manager and select tinyMC. Under Basic Options -> Functionality set it to extended.
Step 03: Now in the required article click on insert/edit embeded media. Paste the you tube embed code in Source section.
FYI:
Joomla does not like youtube embeded code with iFrame. So make sure to get youtube old embeded code.
Step 01: In Joomla Administrator first go to article options. There under super user (for other required privileged) set text filtering to "NO" . This is under text filtering section.
Step 02: Now navigate to plugin manager and select tinyMC. Under Basic Options -> Functionality set it to extended.
Step 03: Now in the required article click on insert/edit embeded media. Paste the you tube embed code in Source section.
FYI:
Joomla does not like youtube embeded code with iFrame. So make sure to get youtube old embeded code.
Monday, January 9, 2012
Time Series Terminology and Basics
Univariate Time Series
Multivariate Series
Component Series
Smoothing
Interpolating
Seasonality
Trend
Auto correlation
Negative Auto Correlation
Positive Auto Correlation
Multivariate Series
Component Series
Smoothing
Interpolating
Seasonality
Trend
Auto correlation
Negative Auto Correlation
Positive Auto Correlation
Sinhala Font on Joomla CMS based web site
Recently I completed a NGO web site. The main objectives of the web site was to eliminate gender inequality, reduce poverty and so on.The Non Government Organizations name is Gemi Sarana Kendraya The main consumers of the Sinhala rural area people. In order to facilitate them with a better Human Computer Interactions I localized the web site. However the adding Sinhala to web site was not a tedious task as previous. Early days we had to depend on Joomla Fish. Last year I localized www.gunner.lk web site using Joomla Fish extension. However I was able to add Sinlala to www.gemisaranakendraya.com web site using Unicode with out an issue.
You need to add below code to your site.
"iframe id="settdecoder" name="settdecoder" frameborder="0" style="margin:0; padding:0; height:0px; width:0px;" "
"iframe " script type="text/javascript" src="http://sett-decoder.appspot.com/SettUnicodeDecoder.js"" script"
Therefore, even if the client computer done not have Unicode this script eliminate that issue.
You need to add below code to your site.
"iframe id="settdecoder" name="settdecoder" frameborder="0" style="margin:0; padding:0; height:0px; width:0px;" "
"iframe " script type="text/javascript" src="http://sett-decoder.appspot.com/SettUnicodeDecoder.js"" script"
Therefore, even if the client computer done not have Unicode this script eliminate that issue.
Sunday, January 8, 2012
Minitab Statistical Software to Predict Sri Lanka Share Price
While fallowing Msc in Applied Statistics course at Post Graduate Institute of Science, University of Peradeniya I got the opportunity to come across the Minitab Statistical software. The Minitab is very user friendly compared to R and SAS.
Also very recently I completed the Raja Senanayake the Economist and Stockbroker official web site : http://rmbsenanayake.com/
After completing his web site he wanted to me to do a Technical Analysis of Environmental Resource Investment Plc.
Subscribe to:
Posts (Atom)