[VBA] Excel user-defined functions - Your own help for your fuctions

I would like to describe a problem which concerns writing your own functions called "user-defined functions". In My opinion the most important thing for engeneer computer programmer is a writing not only same code but also documentation.
Today I had case that my manager wanted to find some function in Excel which compare values. We knew that Excel have a function Find.Vertical(...) or something of that kind, but this function is very limited. Few months ago I wrote some functions in VBA in Excel to expedite my own work and I wrote a description before declaration of function. Everything would be great but the problem is that I know where I wrote a description, but anyone other might not know. I decided to find a solve in Google searcher but a lot of idea was wrong and not working. I read one of them and I try it step-by-step and I discover one important field...

When you wrote your own functions in VBA and You'd like to use it by "Function window" you may see something like this:

Or in Polish:

How to solve it?
SOLVE IS COMMING

You need to open a VB window and open a properties of Your module in your own functions and choose HELP FILE !
:)

Window looks like this:

Read More

Algorytm NWW(a, b).

Podczas jednej z rozmów kwalifikacyjnych zadano mi zadanie zaprogramowania funkcji NWW, jako, że matematyka jest bardzo ciekawą i ekscytującą dyscypliną życia w której drzemie nieposkromiona energia pragnę przedstawić swoją wersję wyznaczenia NWW którą udało mi się "z palca" napisać podczas tej rozmowy, teraz wygląda trochę ściślej pewnie niż na rozmowie, ale algorytm jest ten sam ;)

Oto moje dzieło:

/**
 * Wersja przed poprawką
 * @param a
 * @param b
 * @return
 */
int nww(int a, int b)
{
  int min = min(a,b);
  int max = max(a,b);
  for(int j=1; j < max ; j++)
  {
        for(int i=j;i<=(j+1);i++)
        {
                if(min*i==max*j)
                    return min*i;
                if(j==min)
                    return max*j;
        }
  }
  return 0;
}

/**
 * Wersja po poprawce
 * @param a
 * @param b
 * @return
 */
public int nww(int a, int b)
{
  int minimum = min(a,b);
  int maximum = max(a,b);
  int lowValue,
  int highValue;
  int k = 0;
  
  for(int j=1; j < maximum ; j++)
  {
        k=j+1;

        for(int i=j;i<=k;i++)
        {
                lowValue = minimum*i;
                highValue = maximum*j;

                if(c==highValue)
                    return minimum*i;
                if(j==min)
                    return maximum*j;
                if(lowValue<=highValue)
                    k++;
        }
  }
  return 0;
}

Read More

[SOLVED] Firefox & Flash & other plugins installed by unpacking

[Gentoo ~x86]
When you try install firefox form portage like this:

user@host# emerge [YOUR FAVOURITE OPTIONS] firefox

Probably you can see something like this:

These are the packages that would be merged, in order:

Calculating dependencies ... done!
[ebuild N ] www-client/firefox-3.6.17 USE="alsa dbus ipc -bindist -custom-cflags -custom-optimization -debug -gnome -java -libnotify -startup-notification -system-sqlite -wifi" LINGUAS="pl -af -ar -as -be -bg -bn -bn_BD -bn_IN -ca -cs -cy -da -de -el -en -en_GB -en_US -eo -es -es_AR -es_CL -es_ES -es_MX -et -eu -fa -fi -fr -fy -fy_NL -ga -ga_IE -gl -gu -gu_IN -he -hi -hi_IN -hr -hu -id -is -it -ja -ka -kk -kn -ko -ku -lt -lv -mk -ml -mr -nb -nb_NO -nl -nn -nn_NO -oc -or -pa -pa_IN -pt -pt_BR -pt_PT -rm -ro -ru -si -sk -sl -sq -sr -sv -sv_SE -ta -ta_LK -te -th -tr -uk -vi -zh_CN -zh_TW" 0 kB

Total: 1 package (1 new), Size of downloads: 0 kB

Would you like to merge these packages? [Yes/No]

This version is older than actual version but when You download firefox from http://www.mozilla.org/. After unpacked you have to do this:

ln -s /usr/lib/nsbrowser/plugins [your-path-to-unpucked-firefox]/plugins

After that your FF is installed with plugins.

Read More

[SOLVED] : command not found19: :Qkbq - An annoying error log when you change state of service

I am writing for more information about error log looks like this:

: command not found19: :Qkbq

If you are changing a state of service in "/etc/init.d/..." like this:
/etc/init.d/net.wlan0 start
/etc/init.d/net.eth0 restart
/etc/init.d/postfix pause
/etc/init.d/postfix status
etc. etc. etc.

You can see this error log. If you want to know how to solve this problem you
can follow this:
The main problem is in "/etc/rc.conf". The high probability is in ones of line
of this files looks like command name i.ex. "Qkbq". Next you should comment
this line or delete bad line from this file.

Enjoy!

Best regards,
Maveius

Read More