Steps to produce a .nc file from netCDF4Excel

1. Download and install netcdf excel addin. (Link)
2. You can use User Guide Documentation. (Link)
    or
1. Open the link of the file NetCDF4Excel_2007.xlsm.
2. Save the file in «C:Programme Files\Microsoft\AddIns», in selecting a .xlam extension.
3. Click on File>Options, and then click the Add-Ins category.
4. In the Manage box, click COM Add-ins, and then click Go. The COM Add-Ins dialog box appears.
5. In the Add-Ins available box, select NetCDF add-in for Excel.
6. NetCDF menu will permanently appear in the Add-ins menu in Excel.
7. Click ADD-INS tab + NetCDF and create New Empty File.






8. Then we can add New dimensions, and add Variables. Variables appear as work sheets.


9. Then add data to the Yellow color columns.
 
 10. Save the work file , NetCDF >> Save >> Create a New File , then give a proper name. It will save as .nc format.

 


11. After complete all the above Steps, still you need to view your data more specific way or edit this header file, Go to Link

Important
When we add STRING type or CHAR type variables, attributes should be in byte.
A=65, B=66, C=67 ... 
a=97, b=98, c=99 ... and so on
For more about to byte codes Go to Link

Comments

  1. UnknownOctober 22, 2020 at 2:07 AM

    Is netCDF4Excel only for 32 bit windows? Is it available for excel 2013 & 64 bit windows?

    ReplyDelete
  2. UnknownOctober 22, 2020 at 2:09 AM

    Is netCDF4Excel only for 32 bit windows? Is it available for excel 2013 & 64 bit windows?

    ReplyDelete

Post a Comment

Popular posts from this blog

Set-Up Local data Library

Assigning ip address and cache clearing  Log in as jdcorral Open a terminal window Type 'ifconfig' to get ip address  'sudo hostname xxx.xxx.x.xx' (where xxx....is the ip address ) change the hostname in /etc/hosts from localhost.localdomain to ip address) 'sudo /etc/init.d/ingrid stop' (to shutdown ingrid) 'sudo /usr/local/squid/sbin/squid -k reconfigure' (to flush squid cache) 'sudo /etc/init.d/ingrid start' (to start up ingrid) 'ps ef| grep ingrid'  (should show one ingridd process, if not, repeat ingrid start, it may take 2 or 3 times) Processes that are necessary for Ingrid to work ingrid (‘ps –ef | grep ingrid) squid (‘ps –ef | grep squid) postgresql (ps –ef | grep post) If you change the ip address or hostname , Changing IP Address Use the System Administration tool, ‘Network Devices’. To change the existing NMA local area network ip address, click on the auto-eth1 device. Then change the ip address from...
Read more

Upload data to the Data Library through Ingrid scripts

Image
The IRI Data Library is built on Ingrid, a PostScript-based language, that facilitates the creation of user-tailored analyses and graphics. In this post describes the basic steps of adding data set to the data library through the ingrid script. Can use any kind of text editor,  in Windows - eg: Notepad, WordPad, ... in Linux - eg: Emacs, vi editor, ...  As an example: Steps to add Tea production and Area to the Data Library. Step 1.  \begin { ingrid } Scripts should write inside this codes. \end { ingrid } Step 2.  \begin { ingrid }     /tea  insertdataset:     The data set and all the other commands are inside this codes.        :insertdataset \end { ingrid } Inserting grid grid:        /name /T  def       /long_name /Time  def        monthtime       1    ...
Read more

Adding data to the Data library

Image
Location to store data In order to add data to a data library first user needs to identify where we going to store the data.  where do we store our Ingrid script? file system \local \Data \Data catalog \entries \SL \FECT where do we store data files? file system \local \Data \ SL\ FECT In the above-mentioned location, the user should create a folder under the user's name.  Create a script to add data The example code can find in this path which have create under the above-mentioned location Folder Path: /local/data/DataCatalog/entries/SL/FECT/MOH/District_DengueCase Below is an example to create a district-wise dengue cases map for Sri Lanka . Starting Ingrid script Adding the path of the source file here we are going to allocate data to each district of Sri Lanka. therefore need to mention the...
Read more