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.
Some multi-cultural songs
-
The latest concert of the excellent Willoughby Symphony Choir featured a
collection of popular and folk songs, rather than their usual classical
performanc...
School in Excel por Princesa
-
Este fin de semana vamos a aprender muchas cosas… Porque
Princesa nos va a mostrar los logos o escudos de 100 universidades o
escuelas mayore...
Top 40 Excel Blogs by Feedspot
-
What an honour and pleasant surprise to be selected as one of the Top 40!
Recently I am quite busy (and moody) at work, I mean the real work at
office. Yo...
How to undo in Power Query [Quick Tip]
-
Ever wondered how to undo in Power Query. If you try to press CTRL+Z or
look for undo icon in Power Query (either in Excel or Power BI), you will
not fin...
Calculadora Horas Anuales Trabajadas
-
Seguro te has preguntando muchas veces cuántas horas trabajas al año y si
cumples con lo establecido con el convenio que tengas...
Hoy explicaremos como con...
Media o Promedio de las horas en Excel
-
Obtener el promedio de las horas en Excel sin considerar valores de cero y
celdas vacías...
La entrada Media o Promedio de las horas en Excel aparece pri...
Importing and Cleaning Data with Power Query
-
If you work with any type of data, then you know that rarely does it come
perfectly in the format you need. Power Query (also called Get & Transform
in E...
Importing and Cleaning Data with Power Query
-
If you work with any type of data, then you know that rarely does it come
perfectly in the format you need. Power Query (also called Get & Transform
in E...
Mapa coroplético de España con leaflet para R
-
Title Problema
Crear un mapa coroplético con leaflet es muy sencillo. En nuestro ejemplo,
crearemos un mapa coroplético de España con el número de habitan...
Números piramidales centrados (4/4)
-
*Otros números piramidales centrados*
*Hexagonales*
Con estos números, como veremos, el inicio del estudio seguirá un camino
más simple:
Partimos de l...
Excel Mileage Lookup With Total Distance
-
If you’re planning a vacation trip, Excel can help. It’s a great place to
keep your packing lists, and you can track your vacation spending too (if
you rea...
Física Cuántica: Qué dice y que NO dice
-
Ya podéis ver en Youtube la charla que di el pasado mes de diciembre en el
evento divulgativo Desgranando Ciencia 4.
Espero que os guste.
Excel shows formula but not result
-
Every once in a while, you might find Excel behaving in a bizarre or
unexpected way. One example is when you accidentally trigger the scroll
lock featur...
Triángulo de Floyd
-
Puede descargar el archivo trianguloFloyd.xlsm
El triángulo de Floyd para cuatro filas es el siguiente.
Se construye con los números naturales en forma de...
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...
Get External Hyperlinks From A Webpage
-
Last updated: 20/05/2018, 1 min read Introduction Some years ago, I
published a VBA code that proved to be very popular in blog users: the code
and the acc...
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 ...
Excel 2016 Performance Improvements
-
Excel 2016 Performance Improvements The Excel team has made a number of
performance improvements to Excel 2016. These improvements were rolled out
as part ...
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...
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...
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.