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.
Nacidos libres por Pleno
-
Hoy jugaremos con animales, Pleno, nos ha seleccionado 125 imágenes
relacionadas con animales que mayoritariamente nacen en libertad. En
algunas de ellas v...
Buscar el email con hipervínculo en Excel
-
Si disponemos de un listado con los datos de nuestros clientes, podemos
buscar el email con hipervínculo en Excel de forma rápida para enviárselo...
La e...
Revenue Chart Showing Year-Over-Year Variances
-
About the Revenue Chart This tutorial shows how to enhance a simple column
chart of revenues to show percentage changes or variances between columns.
I s...
Identificando la posición del último número
-
Hace unos días publiqué un post donde exponía una manera de *extraer los
primeros y últimos caracteres* no numéricos de una cadena de texto (ver aquí
).
Si ...
Excel VLOOKUP to the Left
-
To use VLOOKUP, the value you're looking for has to be in the first column
of the lookup range. But what if your lookup table has Scores in column 3,
and y...
AS 3600 and RC Design Functions 8.01
-
The updated RC Design Functions spreadsheet (presented here) included an
updated UMom function to find the ultimate strength of a rectangular
section under...
Keyboard Metrics III
-
In the grand tradition of Keyboard Shortcut Metrics and More Keyboard
Metrics, here’s this: Procedure 2016 2017 2018 Grand Total MakeComma 20.54%
18.67% 19...
Extraer información de la OMDb API con R
-
Problema
Queremos extraer con R información sobre películas o series de televisión
usando la OMDb API.
Solución
Empleamos el paquete *imdbapi* que nos p...
Crear una RESTful API con R con plumber
-
Podéis buscar info en la web acerca de lo que es una REST y una RESTful
pero el objetivo de este trabajo es la creación de una API para “escorear”
unos dat...
Excel VBA copy contents of protected worksheet
-
This Excel VBA tutorial explains how to copy contents of protected
worksheet and then paste contents in another worksheet. You may also want
to read: Exc...
Develop Excel Conference
-
The Develop Excel conference will take place in London on Thursday October
the 18th 2018. It will be held at the Microsoft Reactor (70 Wilson Street
London...
Variable lógica de control
-
Puede descargar el archivo booleanoPorDefecto.xlsm
Generamos siete números aleatorios entre 1 y 10 en las celdas del rango
B4:H4. En la celda amarilla (B6...
Step Charts in Excel
-
Step Charts are useful for showing values that don’t change steadily from
one point to the next, but that instead are constant for a period of time,
then...
How to use formula criteria (50 examples)
-
One of the key concepts in Excel formulas is criteria. Among other things,
criteria perform the following important functions:
- Direct logical flow ...
Minimally Viable Data Visualization
-
I received an email a few days ago from the founder and CEO of a new
analytics software company that led to an interesting revelation. In his
email, this f...
It’s spring cleaning time for Blogger
-
To make room for some exciting updates coming soon to Blogger, we’re
simplifying the platform to enhance the blogging experience for all of our
users.
Ch...
Announcing Stack Overflow for Teams
-
New product: Stack Overflow for Teams lets you direct questions to members
of your own team, company, or organization. Read more "Announcing Stack
Overflow...
-
This is a guest post from Joseph Helstrom, CPA.
*Adding VLookup as a Control for Your Month-End Workpapers*
When closing for the month, many use an Excel ...
Calendario Excel 2018
-
Un muy buen Calendario Excel 2018. En una hoja se visualizan los 12 meses
juntos. También hay una hoja individual para cada mes.
Tabla de amortización de préstamos con Power Query
-
Hace varios días que venía dándole vueltas a la idea de mostrar cómo crear
una tabla de amortización de préstamos, como el modelo que publiqué en el
pasado...
Algo sobre columnas y nombres de rangos
-
Casi que me da vergüenza escribir esta nueva entrada... ya que lo hago
luego de dos años sin aparecer por estos pagos. ¿Excusas? Miles: trabajo,
casa, estu...
Microsoft Excel Workbook Metrics
-
A small VBA code snippet to display the most important metrics of an Excel
workbook like the count of sheets, cells, formulas, constants, named
ranges, cha...
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...
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 ...
-
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...
LISTAR ARCHIVOS DE UNA CARPETA
-
TRUCOS
Si quisiéramos enlistar en una hoja de Excel todas nuestras canciones o
archivos que tengamos en una carpeta, lo podemos hacer de una forma muy
se...
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...
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...
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...
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...
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...
How to Create an Invoice Template in Excel
-
In this article we will show you how to create an Invoice template using MS
Excel by using simple functions. An invoice is a little piece of paper that
pro...
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 ...
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...
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.