Econometrics blog

Aug 19, 2016

Install Latex Package on Sublime 3

To use latex in Sublime, we need to install Latex tools on Sublime 3. Here is the instruction to install LaTeXTools. 
https://packagecontrol.io/packages/LaTeXTools
First, you have to install Sublime and Sumatra PDF

Before we need to install LaTexTools, we have to install the package control from here.
https://packagecontrol.io/installation


After installing package control. Open Sublime and click Shift+Ctrl+P to open the Palette. Search for "install package"and look for "LaTeXtools".

If succeeded, you will see latex on the build.

Apr 21, 2016

Converting a Polygon ZM shape file to a regular Shape Polygon

from:http://blog.csdn.net/qb371/article/details/8102109

I tried this on Arcmap 10.4:

  • Locate the following tool - 
    • ArcToolbox > Conversion Tools > To Shapefile > Feature Class To Shapefile (multiple) 
  • Launch the tool and add your Polygon ZM shapefiles to the input features. 
  • Select an 'Output Folder' 
  • Click on the 'Environments...' button at the bottom of the dialog box. To the right of the 'OK' button. 
  • Click on the 'General Settings' text. 
  • You should see two fields marked 'Output has Z Values' and 'Output has M Values'. 
  • Set both fields to 'Disabled'. 
  • Click 'OK' to exit the Environments Settings then click 'OK' to run the tools.

Feb 16, 2016

Remove trailing space in excel

Using the Trim function is easy to remove the trailing space in one cell, but time-consuming to remove trailing spaces in many cells. Here provides a macro to remove all trailing spaces of all cells in a selection.
Step 1: Select the range in which you want to remove trailing spaces from cells.
Step 2: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
Step 3: Click Insert > Module, and paste the following macro in the Module Window.
Sub NoSpaces()
Dim c As Range
For Each c In Selection.Cells
c = Trim(c)
Next
End Sub
Step 4: Press the F5 key to run this macro. And all of the trailing spaces of the selection will be removed.