Traducir el blog

International virtual keyboard

Download the new second renewed version from here:

International Virtual Keyboard in Excel | #ExcelPedroWave


Background

In the early 80s I chose, as Thesis in Industrial Engineering, the design of a dumb terminal acoustically coupled to a central computer.
I put together a working prototype with a microprocessor that controlled a QWERTY keyboard and showed the characters in a CRT television. It was my first contact with the ASCII character-encoding and those I still follow with this virtual keyboard with Unicode encoding to generate the characters in the "smart" terminal, if we show the logic to the  textbox of how to make them, but as so dumb as any TV box if we don't show that.



International Virtual Keyboard

Based on the idea of ​​Macro Antonio of a virtual keyboard, which verzulsan (with his machine gun to repeat keys) and I (with fonts and text zoom) modify some time ago in the forum AyudaExcel.com (link here), I allow myself to upload an improved version that includes:
  1. Keyboard translated into Spanish, Latin American, Inglés, Français, Italiano, Deutsch, Português, with ability to add more languages ​​in the sheet "Teclas".
  2. Some layouts: QWERTY, QWERTZ (German), AZERTY (French) and Dvorak simplified keyboard in Spanish and English.
  3. Safeguarding last zoom and font, size and text properties in the sheet "Personal".
  4. Symbols for special keys as the international standard ISO/IEC 9995.
  5. Numeric keypad functions as a basic calculator.
  6. Special Key Functions: Carriage Return (Enter), Tab, Ctrl, Alt Gr, Shift, Caps Lock, Num Lock, Windows Key, Menu, Insert, Delete, Home, End, Page Up, Page Down and movement arrows cursor.
  7. Hide or display the keypad.
  8. Enlarge text box with double click.
  9. Other minor improvements, such as the position of the keyboard on the screen.

NOTE: The Alt key does not generate the encoded characters, eg Alt +21 = §
Could you help me to solve it?

Download template from this link:

Touch Keyboard PW1.zip 


As it is a virtual keyboard you can use with the mouse, without touch the physical keyboard devices, such as tablets, etc.



Would like you find faults, errors, bugs, defects, incidents, improvements, etc., in order to improve this virtual keyboard when I return from summer holidays. See you soon!

Teclado virtual internacional

Descarga la nueva segunda versión renovada desde aquí:

Teclado Virtual Internacional en Excel | #ExcelPedroWave


Antecedentes

A comienzos de los años 80 elegí, como Proyecto Fin de Carrera en Ingeniería Industrial, el diseño de un terminal inteligente acoplado acústicamente a un ordenador central.

Monté un prototipo funcional con un microprocesador que controlaba un teclado QWERTY y mostraba los caracteres en un televisor CRT. Fue mi primer contacto con la codificación de los caracteres ASCII y en esas sigo con este teclado virtual con códigos Unicode para generar los caracteres en el terminal "inteligente", siempre que le mostramos la lógica de cómo hacerlos, sino es tan tonto como cualquier caja tonta, sea una televisión o sea una caja de texto conocida como textbox en lenguaje anglosajón.



Teclado virtual internacional

Basándome en la idea de Macro Antonio de un teclado virtual, que verzulsan (Santi con su ametralladora para repetir teclas) y yo (con las fuentes y el zoom de texto) modificamos hace tiempo en el foro:

Teclado virtual internacional - Ideas y aportes - Comunidad de Excelers de Ayuda Excel

Me permito subir una versión mejorada del teclado virtual haciéndolo internacional, ya que incluye:
  1. Teclado traducido al Español, Latinoamericano, English, Français, Italiano, Deutsch, Português, con posibilidad de añadir más idiomas en la hoja "Teclas".
  2. Varios layouts: QWERTY, QWERTZ (alemán), AZERTY (francés) y teclado Dvorak en español e inglés.
  3. Salvaguarda del zoom y de la última fuente, tamaño y propiedades del texto, en la hoja "Personal".
  4. Símbolos de las teclas especiales según el standard internacional ISO/IEC 9995.
  5. Teclado numérico que funciona como una calculadora básica.
  6. Funciones de las teclas especiales: Retorno de carro (Intro), Tab, Ctrl, Alt Gr, Mayúsculas, Bloq Mayús, Bloq Num, tecla Windows, Menu, Insertar, Suprimir, Inicio, Fin, Re Pág, Av Pág y flechas de movimiento del cursor.
  7. Ocultar o mostrar el teclado numérico.
  8. Ampliar la caja de texto con doble click.
  9. Otras mejoras menores, como la posición del teclado en la pantalla.

NOTA: La tecla Alt no genera los caracteres codificados, por ejemplo Alt+21 = § ¿me puedes ayudar a resolverlo?

Descarga la plantilla desde este enlace:
(Descarga desde Google "Excel Download" o Microsoft OneDrive)

Touch Keyboard PW1.zip 


Como es un teclado virtual y se puede emplear con el ratón, sirve como teclado táctil en dispositivos sin teclado físico, como tablets, etc.



Me gustaría que le sacaras faltas, fallos, bugs, defectos, incidencias, mejoras , etc., y poder mejorarlo cuando vuelva de vacaciones. ¡Hasta pronto!

Prime factorization decomposition

Decomposition problems

If someone believes that the integer factorization is solved with a simple formula is very wrong. The algorithms that try to break down a number into its prime factors are an asset to put to work quantum computers, designed the most powerful so far. One of the best known algorithms is the Shor's algorithm.

RSA problem

The day that run Shor's algorithm on a quantum computer will be of no use secret codes to make an electronic transaction or signing a document with our electronic ID. RSA public keys will be possible to be deciphered, is known as the RSA problem in cryptography that relies on the security of not being able to find the two primes that decompose a secret key in computation polynomial time.

One doubt arises to me. U.S. intelligence agencies already have quantum computers able to decipher secret codes and to key factorially decomposing into its two prime numbers? If so, our privacy is in tatters and also our confidence in the security of our data and our private communications. The PRISM monitoring program can be finished them off, as reported in the current following links:

What is at stake is to not even be authors of our own issues, if anyone can supplant us using our secret keys, or creating them instead of us (in case you believe that without using the Internet will be free of impersonation of your digital identity).

Factorial decomposition

This article does not try to break composite keys extremely long into prime numbers, but with 6 digits or up to 1,000,000, with an Excel template to serve in school or college and can be uploaded to the cloud in order to exercise ourselves in finding the prime factors anywhere with internet connection.


The factorization allows you to obtain the prime numbers with exponents, which are divisors of an integer. Eg
70776 = 2³ · 3² · 983
It agreed to use the punctuation symbol "·" as a multiplication operator prime factorization, although you can use other symbols, such as:. (decimal point), x (sign for), * (asterisk sign).

On the right is the integer factorization of 70776, as a product of prime factors: 2, 3 and 983. The number 2 is raised to the 3rd power, it is necessary to multiply three times:
2³ =2 x 2 x 2 = 8.

Prime numbers

In the above example it is easy to obtain the factors 2 and 3 as they are small numbers, but not so easy to know if 983 is prime.

Prime numbers are natural numbers (integers greater than 1) that are divisible by 1 and by themselves, and there are infinite. The set of all prime numbers is represented by the symbol: \mathbb{P}

One method to determine whether a composite number is prime is to try to divide it by each of the prime numbers smaller than it and, if there is none that can divide it, you can ensure it is a prime number.

There are special primes as commenting The Solitude of Prime Numbers novel, are the twin primes, which are two consecutive odd prime numbers (except 2, all prime numbers are odd) as 11 and 13, 17 and 19, or 41 and 43.

In the following links you can explore some of the known problems with prime numbers, that many headaches facing students of the number theory:

Decomposition into SkyDrive cloud

Following a question from a math teacher I thought making this template in Excel 2010 that allows to practice factorization of a composite number into its prime factors from SkyDrive, without having Excel installed, thanks to solving only with formulas because macros can not be uploaded to the cloud from Microsoft Excel 2007 or 2010.

NOTE: You can edit the cell B11 and the range C11:C30, do not modify the other cells!

NOTE: To erase numbers, if backspace or delete keys not work, type a space and a backspace, so that the cell is empty.



Download template compatible with Excel 2003

Download the latest version below that allows numbers between 2 and 2,251,799,999,999
The ExcelWebApp cloud version only supports up to 1,000,000
Help with "?" character does not work in Excel 2003 for very large values​​.

GUESSING GAME FOR DECODERS:
A hidden character, written in cell C11, automatically calculates the prime factors of the number written on B11. Can you guess?

Download English templates for Excel 2003, 2007 and 2010 from this link:


Factores sheet (factors)
  • Cell B11 - Enter the composite number (between 2 and 1000000).
  • Range C11:C30 - Enter the prime factors that decompose the previous composite number. (warns if not prime or not divide the composite number)
  • Cell B8 - Factorization is displayed as powers of prime numbers. (eg 234 = 2 · 3² · 13)
  • Cell F10 - To change the multiplier symbol of the prime factors, default "·" (eg:  ·  x  .  * ).
Primos sheet (primes)
  • Range A2:A21 - Formula to find out if it is a prime number when it is greater than 0.
  • Range B2:B21 - List the prime numbers in increasing order.
  • Range C2:C21 - Calculate the number of repetitions of each prime.
  • Range D2:D21 - Gets the factorization.
  • Range G2:H21 - Superscripts of exponents auxiliary list to graphically represent powers of prime numbers (up to 20th).
Divisores sheet (dividers)
  • Range A2:A21 - Composite numbers of the range Factores!B11:B21
  • Range B2:B21 - Array formula to obtain the prime factors.
  • Range C2:C21 - Dividers of the composite numbers and their factors.
  • Range D2:D21 - Prime number, prime factor or less than F1 cell.
  • Cell F1 - For the user to find out the dividers less than this value, default: 20.
Array formula to obtain the prime factors:
With this formula, by introducing the "?" character, without the quotation marks, in the range Factors!C11:C30, you can know which is the prime factor.

Formulas for identifying prime numbers

The formula to determine if a number is prime the've taken by the expert in Excel, José Ramón García, on their website:

The following array formula (entered by pressing both keys: Ctrl + Shift + Enter) lets you know if a number is prime (result greater than 0), up to 4,295,098,367 in Excel 2003 to 1,099,513,724,928 in later versions, values ​​sufficient for 1000 (1,000,000 square root of which is the maximum composite number in this template).
With the 4th formula in above link you can find out if a number is prime to 15 digits (maximum accuracy of Excel). With VBA macros can be solved for more digits with a higher computation time with a function like this:
Prime number Digits Process time
535006138814359 15 00:00:18
4847464544434241 16 00:00:54
55350776431903243 17 00:03:03
496481100121144169 18 00:09:12
6082394749206781697 19 00:32:19

But this I leave to future articles on calculations with large numbers of time if we trust Edward Snowden in terms of the protection offered by encryption:
"Encryption works. Properly implemented strong crypto systems are one of the few things that you can rely on. Unfortunately, endpoint security is so terrifically weak that NSA can frequently find ways around it."

Mi lista de blogs