Posted on martes, septiembre 21, 2010 by Pedro Wave
Finding engineering work quite un-challenging lately I decided to start this blog in which to share cool ways of solving engineering problems or just interesting modeling of natural phenomena in MS Excel 2003. I use mainly cell formulas with minimum of VBA in order to take advantage of the native excel spreadsheet speed. Hi, I’m George Lungu, the admin of this blog. I do analog and mixed-signal electronics design and systems modeling for a living.
So begins the blog Excel Unusual that just started to publish my friend Geo and certainly surprise more than one, starting with me.
Yesterday included his first three contributions and have left me wondering, also he attaches the files in Excel 2003 without hiding anything!
As just one example: A roller coaster in Excel 2003 created with a 2D scatter plot. Math formulas are in the spreadsheet with minimal macro code.
Stephen Few’s Final U.S. Workshop
-
This blog post was written by Bryan Pierce of Perceptual Edge. It’s only a
little over seven weeks until Stephen Few will be teaching the West Coast
Visual...
Heart (Corazón) por Maruja
-
Hoy jugaremos con uno de los principales músculos del cuerpo humano Pero
no es un juego de anatomía, sino de cine. Maruja, sigue con su saga de
juegos de...
PLANTILLA EXCEL PARA RENDICIÓN DE VIÁTICOS
-
Plantilla Excel para rendición de viáticos – incluye DD. JJ. de viáticos al
exterior es una plantilla Excel que nos permite realizar la rendición del
diner...
Curso Online de Power Query y PowerPivot
-
Excel ha ido desarrollándose a lo largo de los años en un proceso de
permanente adaptación a las necesidades de los usuarios. Esto ha convertido
a Excel en...
Obtener Coincidencia Previa en Rango de Excel
-
En el grupo de facebook que gestiono, un usuario preguntaba por la manera
de *conseguir recuperar el valor previo coincidente*.
Lo vemos mejor en la imagen ...
Formula to list weekends only
-
[image: Generate weekend dates only with a simple formula]
*In a a world where everyday is Saturday or Sunday....*
Here's a little puzzle for you...how ca...
Comment on Main by Caroline1979
-
Hello blogger, do you monetize your blog ? There is easy method to earn
decent money every month, just search on youtube - How to earn with wordai 4
Drop Buttons on VBA UserForm Controls
-
What Are Drop Buttons Drop Buttons are buttons which are part of another
control. For example, in a ComboBox, the Drop Button is a small button with
an a...
Drop Buttons on VBA UserForm Controls
-
What Are Drop Buttons Drop Buttons are buttons which are part of another
control. For example, in a ComboBox, the Drop Button is a small button with
an a...
Using the Frame Analysis Spreadsheets
-
Following some recent questions in the comments, here are some answers: How
can nodal moments be created? The current versions only allow for forces to
be ...
Excel Pop Up Selector Tool With Slicer
-
Slicers make it easy to select from a list of items, but they take up
valuable space on your worksheet. To get the benefits of a Slicer, without
the real...
Variations of Alternative Bullet Graphs in Excel
-
Variations of the Alternative Bullet Graph Design: Visualization of Gaps
and Exceedances, two Targets and two Gaps, conditionally formatted Actuals
and dyn...
Cierre de blog
-
Hace tiempo que he decidido abandonar este blog y pasarme a
http://mexcelmx.blogspot.mx/ Sobre todo, que por motivos profesionales
estoy trabajando de la m...
Always Use Stored Procedures
-
I take data that has been entered in Excel and I store it in SQL Server. A
lot. I do that a lot. The proper way to do that is to create a stored
procedure ...
¡¡Más de un millón de visitas!!
-
Me alegra mucho comunicaros que este humilde blog ya tiene más de un millón
de visitas.
Si miramos las estadísticas podemos apreciar que el número de visi...
Excel assign sequence number to duplicate records
-
This Excel tutorial explains how to assign sequence number to duplicate
records using COUNTIF Function. Excel assign sequence number to duplicate
records...
Números piramidales (5) Hexágonos
-
Quienes sigáis esta serie sobre números piramidales adivinaréis que los de
tipo hexagonal son suma de los primeros números poligonales hexagonales, 1,
6, ...
Hasta la vista
-
Hasta la vista Estimado suscriptor: Voy a cerrar el proyecto Ideas Excel en
breve, por lo que ya no recibirás más actualizaciones de este sitio, que
dejará...
Me vs Hungarian Notation
-
Hungarian Notation is a coding convention that many programmers use to
(presumably) make their code more understandable. It involves prefixing
variable nam...
Clothing Store Inventory Keeper
-
It’s finally time that you got your clothing store in good running order
with the free Clothing Store Inventory Keeper. This Excel template was
designed ...
VLOOKUP versus INDEX MATCH! Which is Better?
-
VLOOKUP versus INDEX MATCH! Which is Better?[image: vlookup and index match]
Chris Chau of Defeatexcel.com asked twenty-seven (27) Excel MVPs and
communit...
-
La más grande del Mundo
El pasado día 7 ha abierto en Madrid la mayor tienda de la enseña ZARA en
el mundo.
Pese a la gran repercusión que ha tenido en...
Share your unique style with new Blogger themes
-
If you’re one of the millions of people who uses Blogger to share your
views on current affairs, teach the world how to make sushi, or just offer
a peek in...
A companion post to my NTTS2017 presentation
-
This post summarizes a few key points in my NTTS2017 effective data
visualization for statistical offices
The original post is titled A companion post to...
How about free VMs for Chromebook owners?
-
I've been using a Chromebook for a few years now, and find myself going for
long stretches without needing to turn on a Windows machine or an Apple
Mac. At...
10 hours left to get My Excel Dashboard Pro Course
-
Hi, all. I was debating doing a post on this, but the books say to do it–so
I will! (Who am I to second guess the wisdom of online marketing eBooks?)
Hopef...
Buscador de libros en Excel
-
Buscador de libros en ExcelPara comenzar bien el año 2017 nada como tener a
mano un buen *Buscador de libros en Excel*, en formato pdf, ppt, doc o xls.
En ...
Import data from SQL
-
*Macro to import data from SQL using ADO connection string:*
Sub Import_data_from_SQL()
' Tools -> References -> Microsoft Active Data object 2.0
Dim rs As...
Enviar emails desde Excel
-
Estamos terminando de desarrollar un complemento para que puedas enviar
emails desde Excel (te permitirá enviar emails desde cualquiera de tus
ficheros Exc...
Developers’ side projects
-
If you’re a developer working for software company, does that company own
what you do in your spare time? Read more "Developers’ side projects"
Workbook_Open vs. Auto_Open
-
I’ve seen it written that Auto_Open() was superseded by Workbook_Open() and
that it is therefore redundant and only still available for backward
compatibil...
Función DESREF y función INDICE
-
Puede descargar el archivo:
- indiceDesref.xlsx
Hoja1
Disponemos de una tabla de doble entrada con valores de ventas en cinco
ciudades durante seis mes...
Integrated Planning System Demonstration
-
See how an Integrated Planning System in Excel can plan inventory,
materials, capacity and production. View a 10 minute demonstration video
and get the com...
Stay connected wherever work takes you
-
You need the most up-to-date technology to ensure your work isn’t limited
by location or circumstance. But what should you look for in your
communication...
CBR de diseño Instituto del asfalto (MS-1)
-
Buenas tardes a todos nuestros amigos y amigas que visitan nuestra web de *planillas
Excel de ingeniería civil*, nuevamente les traigo un aporte de nuestro...
Desafío - Función Afín - 1ro. Medio (Resuelto)
-
Dada un Función f: IR ----> IR, tal que f(x)=5x+16. ¿Cuál es el valor de
f(3) + f(1)?
A) 31
B) 21
C) 4
D) 52
E) 62
*Respuesta:*
*Que sea de IR ----> IR, ...
200 - 201 - 202
-
*Inga: You know, there's something I've been meaning to ask you. In the
transference, the monster got part of your wonderful brain. But what did
you ever...
Limpiar caracteres no numéricos en Excel
-
Limpiar caracteres no numéricos en Excel
Aprende a emplear un conjunto de técnicas que te permitirán limpiar
caracteres no numéricos en Excel, de forma p...
Apologies
-
I seems to have inadvertently deleted my Picasa Web folder. As a result all
the graphs in the previous posts are missing.
I will over the next month or so ...
-
*Obligación de presentar los libros contables en el Registro Mercantil*
Para la mayoría de las empresas, (aquellas cuyo ejercicio fiscal termina el
31 de ...
Frau
-
Frau is a free blogger template adapted from WordPress with 2 columns,
responsive design, right sidebar, footer columns, slider, social
bookmarking icons, ...
SQL Database Performance Tuning for Developers
-
Hi, Recently I came across a great post about SQL Performance Tuning Tips n
Tricks, which outlines a good deal of information across all the common
feature...
The Gunman (2015)
-
Download Full The Gunman in HD QualityNow you can enjoy The Gunman in top
quality with duration 115 Min and has been launched in 2015-02-16 with MPAA
rati...
It's been fun
-
Hey just a note to say that this website will be shutting down on November
1st, 2015. I don't really program in VBA anymore, I'm more into mobile now
(mo...
llevar registros a otra hoja
-
Hola, estimados y queridos visitantes de *este malagradecido blogero
excelmaníaco*. Vuelvo luego de meses y meses de inactividad... espero no
abandonar nun...
Poner borde a imágenes de una entrada en Blogger
-
Para poner borde a imágenes de una entrada utilizamos, dependiendo de la
ubicación, los siguientes códigos:
Imagen a la izquierda
<div class="separator...
New Cloud folder for downloads
-
A new cloud folder is available for downloads. Here.
you will find the following sub-folders :
- Add-in files for Excel 2007 to 2013 - 32 bits
- Add...
Titulo de la primera linea word a pdf
-
Hola:
Respondiendo a este post:
Hola! Alguien sabe como puedo crear una macro en word para guardar un
documento en pdf cuyo nombre sea la primera linea...
Pronostics Coupe du Monde Football 2014 XLD
-
L'événement sportif de l'année, c'est pour bientôt : le 12 Juin 2014.
Téléchargez ce fichier pour faire vos simulations ou bien pour lancer un
concours de ...
How to Extract PDF to Excel Free
-
Adobe’s Portable Document Format or simply PDF is unavoidable and necessary
in today’s age of electronic file sharing, storing and exchanging. When you
w...
Training courses for Outlook 2013
-
Training courses for Outlook 2013
Beginner
*Calendar basics*
Watch these videos to get familiar with the calendar in Outlook 2013. You
can keep things si...
Cómo se crea una Tabla dinámica
-
Las *Tablas dinámicas* sirven para resumir tablas de datos y obtener
subtotales, promedios, porcentajes, máximos, mínimos... Pero, antes de
hacer nada debe...
Worksheet as a chart – multiple conditional formats
-
Several years back, I wrote an article on how to use multiple cells to
simulate conditional formats that involved more than 3 conditions. Three
versions of...
Grand Chaman Excel déménage !
-
Hé oui! Le site du Grand Chaman Excel a maintenant une nouvelle adresse.
Il y a eu peu d'activités sur mon blog au cours des dernières semaines. La
raison ...
Excel 2013 vs ¿?
-
Aún no hemos asimilado la llegada de Office 2010 y ya está disponible para
descargar la versión de prueba de Office 2013… No quisiera parecer
inmovilista, ...
Planificación de compras
-
Realizar una lista con los productos que necesitamos y que formarán parte
de nuestra cesta de la compra nos ayuda a *encontrar la combinación de
bienes pr...
Esquemas automáticos
-
Para crear un esquema automático en Excel, tenemos que contar previamente
con una tabla correctamente planificada, que incluya cálculos resumidos
creados a...
Excel Addins : Spell Currency Excel Addin
-
I am sharing Excel Addin for converting Numbers to Words. I keep getting
mails / comments where people are not able to install the VBA code shared
in my ea...
Top 10 Tallest Buildings in the World
-
Top 10 Tallest Buildings in the world
Hi friends, today i am going to list the top 10 tallest buildings in the
world, made till now.But as its not easy to ...
Analysis of two economic variables
-
This model is useful to study the relationships between two variables
(explanatory and explained), for example: amount depending on the price,
sales in te...
VBA-Worksheet
-
Es el objeto siguiente a Application y Workbook en el orden jerárquico de
Excel.
El objeto Worksheet recoge todos los métodos, propiedades y eventos
real...
Entradas
No Response to "Excel Unusual Engineering"
Leave A Reply
Dime si te gusta lo que lees y, si no te gusta, dime por qué. Tengo habilitada la moderación de comentarios. Tu comentario se publicará pronto.
Tell me if you like what you read here and if you don't like, tell me why. I've enabled comment moderation. Your comment will be published ASAP.