http://sajanmaharjan.com.np/my-works/nepali-functions-addin-for-excel/

http://sajanmaharjan.com.np/my-works/nepali-functions-addin-for-excel/


It has been sometime that people had been requesting for an excel utility that would perform the date conversion from AD to BS and vice versa in Excel itself. Finally, I have had the time to program it and hope that it can help you in some way.
You can download the file here.
Available Functions
ExampleDescription
AD2BS( “enter_ad_date” )
AD2BS( "12/25/2016")
AD date format ( MM/DD/YYYY )
BS2AD( “enter_bs_date” )
BS2AD( "2073/12/25")
BS date format ( YYYY/MM/DD )
number2words( enter_number )number2words( 123 )Returns the result in preeti font
number2words_preeti( enter_number, show_units )number2words_preeti( 123 )Returns the result in preeti font. Here show_units is optional and set to false by default; Shows paisa count if set to true.
number2words_unicode( enter_number, show_units )number2words_unicode( 123 )Returns the result in unicode. Here show_units is optional and set to false by default; Shows paisa count if set to true.
number2words_english( enter_number, show_units )number2words_english( 123 )Returns the result in nepali system ( crore, lakh, thousand ). Here show_units is optional and set to false by default; Shows paisa count if set to true.
BsDatesDiff( “start_date”, “end_date” )
BsDatesDiff( "2073/2/3", "2073/2/5" )
Date count between 2 BS Dates
BsAddDays( “bs_date”, no_of_days )
BsAddDays( "2073/2/3", 5 )
Add or Subtract number of days from a BS Date
  • AD2BS(“enter_ad_date”) // AD date format (MM/DD/YYYY)
  • BS2AD(“enter_bs_date”) // BS date format (YYYY/MM/DD)
  • number2words(enter_number) // Assign the font as Preeti
  • number2words_preeti(enter_number, show_units) // the output is in Preeti font, and show_units specifies if you want to get units (
  • number2words_unicode(enter_number, show_units) // Assign the font as Preeti
  • number2words_english(enter_number, show_units)
  • BsDatesDiff(“start_date”, “end_date”) // Date count between 2 Bs Dates
  • BsAddDays(“bs_date”, no_of_days”) // Add or Subtract number of days from a BS Date
Instructions:
  • Open Excel 2007/2010/2013
  • Click Office Start Button at the top left corner of the screen
  • Select Excel Options
  • In the Excel Options window, select Add-Ins tab from the left sidebar
    Untitled-1
  •  Inside the right side pane, make sure the Manage drop down says Excel Add-ins before you click the Go button.
  • AddIns window is opened up. Click on Browse and navigate to the above downloaded file (Sajan.Nepali.Functions.xlam)
    Capture
  • Check on Sajan.Nepali.Functions in the list and then Click OK
  • You are done.
Limitations
  • Date Range from 2000 BS to 2099 BS.
  • Date Range from 1944 AD to 2043 AD.
You can download the file here.

Comments

Post a Comment

Popular posts from this blog

Nepali Calendar using php

example.php <?php include('nepali_calendar.php'); $cal = new Nepali_Calendar(); print_r ($cal->eng_to_nep(2008,11,23)); print_r($cal->nep_to_eng(2065,8,8)); ?> nepali_calendar.php  <?php  class Nepali_Calendar { private $bs = array( 0=>array(2000,30,32,31,32,31,30,30,30,29,30,29,31), 1=>array(2001,31,31,32,31,31,31,30,29,30,29,30,30), 2=>array(2002,31,31,32,32,31,30,30,29,30,29,30,30), 3=>array(2003,31,32,31,32,31,30,30,30,29,29,30,31), 4=>array(2004,30,32,31,32,31,30,30,30,29,30,29,31), 5=>array(2005,31,31,32,31,31,31,30,29,30,29,30,30), 6=>array(2006,31,31,32,32,31,30,30,29,30,29,30,30), 7=>array(2007,31,32,31,32,31,30,30,30,29,29,30,31), 8=>array(2008,31,31,31,32,31,31,29,30,30,29,29,31), 9=>array(2009,31,31,32,31,31,31,30,29,30,29,30,30), 10=>array(2010,31,31,32,32,31,30,30,29,30,29,30,30), 11=>array(2011,31,32,31,32,31,30,30,30,29,29,30,31), 12=>array(2012
Read more

Algorithm for Nepali date conversion

https://nirmaljoshi.wordpress.com/2010/09/12/algorithm-for-nepali-date-conversion/ If you are looking for code to put in your website visit  http://nepalidateconve.sourceforge.net/  to download php code. …..i don’t have time to read..download  NepaliDateConverterAddIn.xlsm  now. The codes Nepali date conversion consists of two parts A. Data of number of days that occur in each month in each year. This is the reason why all the Nepali date conversion programs have its limitations B. Algorithm to convert the date from AD to BS or vice versa. This is explained with the code in VBA (in Excel) below with the required steps. 1. Open MS Excel 2. Open Visual Basic editor (short cut Alt + F11) 3. Insert a class module 4. Rename the class module to  Nepali_Calender  in Properties window (F4) 5. Paste the code 1 given at the end of this article 6. Insert a Module (normal module not class module!) and Paste the code 2 . It consists of two functions : a. nepaliToEnglish(y,m,d,forma
Read more