Community
 
Aggiungi lista preferiti Aggiungi lista nera Invia ad un amico
------------------
Crea
Profilo
Blog
Video
Sito
Foto
Amici
   
 
 

BINUM
Binary Numbers in  EXCEL

By Foxes Team

 

 

History review

 

 

BINUM.XLA - Ver. 11 -  March. 2004

Bug for functions: and, or, nand, nor, xor, nxor

Fix the problem with two numbers of unequal number of bits.

   (Thanks to Joseph Kim and Edward Leung)

 

New function b_logic  - returns the logic canonical functions

y = OR(AND(x1,x2..),AND(x1,x2..)+...)

y = AND(OR(x1,x2..),OR(x1,x2..)+...)

 

New Macro Synthesis  - Perform the synthesis of a logic function from its logic-table

with the Quine-McKluskey algorithm.

 

New binary memory functions Flip-Flop

New pulse counter

New Serial/parallel binary converter

 

 

BINUM.XLA - Ver. 1.0.1 -  Oct. 2003

b_xor and b_nxor - fix bug for wrong results (thanks to David Frick)

 

 

BINUM.XLA – Binary Arithmetic Package ver. 1.0 – Sept. 2003

This is the first version, containing the following macros:

 

Macro Binary_Generator

Generate the sequential binary table

 

Macro Binary_Mapping

Generate the mapping table of a binary function

 

Macro Binary_System

Solve a binary linear system

 

Function b_map

binary linear function

 

Function b_not

not

 

Function b_and

and

 

Function b_or

or

 

Function b_xor

xor

 

Function b_nand

nand

 

Function b_nor

nor

 

Function b_nxor

nxor

 

Function b_add

addition

 

Function b_sub

subtraction

 

Function b_inc

increment

 

Function b_compl

complement

 

Function b_shr

shift right

 

Function b_shl

shift left

 

Function b_shift

shift

 

Function b_cvstr

format convertion: from vector to string

 

Function b_cvvect

format convertion: from string to vector

 

Function cvBinDec

base conversion: from 2 to 10

 

Function cvDecBin

base conversion: from 10 to 2

 

__________________________________________________________________________________

This software is free.

I will appreciate every your suggestions and bug reports.

:-)

In the meantime, have fun!

Bye

 

Leonardo Volpi

 

Foxes & C. team

Rome, Italy

E-mail: volpi.leonardo@enel.it

E-mail: leovlp@libero.it

 

 

 

TOP

Home