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.
My second #Excel Video on YouTube
-
Glad to share with you my second video here. This video is about how to
plot a compelling to compare Actual vs. Budget, Target and Last Year data.
The w...
Excel formulas and functions
-
Formulas and functions are the bread and butter of Excel. They drive almost
everything interesting and useful you will ever do in a spreadsheet. This
ar...
Suma y diferencia de fracciones egipcias unitarias
-
Recordamos que una fracción egipcia unitaria es aquella de numerador igual
a la unidad. Una fracción egipcia en general es una suma de varias
fracciones ...
Invisibles 6 por Pinky
-
Vayamos de nuevo en busca de películas. Pero como en otras ocasiones,
Pinky, nos ha seleccionado 100 películas en las que han desparecido las
partes humana...
Power Pivot: Columnas Calculadas y Medidas.
-
Propondré hoy un ejercicio para mostrar cómo crear en el entorno de *Power
Pivot* dos herramientas fundamentales:
*- columnas calculadas- medidas*.
Supond...
Excel Pivot Table Troubleshooting
-
If you have a big Excel file, with lots of pivot tables and their source
data, I've written a macro that might help you. The macros creates a
detailed list...
Ya no nos interesa el GDPR
-
GDPR en Google Trends un pico en mayo de 2018 y desaparece el interés. Será
porque todas las compañías se han adecuado a ese marco general legislativo
y no...
Reference SeriesCollection Item by Name or Index
-
SeriesCollection(Item) Working on a project last week, I encountered a
somewhat amusing source of potential confusion. In VBA, you can reference a
Series...
Reference SeriesCollection Item by Name or Index
-
SeriesCollection(Item) Working on a project last week, I encountered a
somewhat amusing source of potential confusion. In VBA, you can reference a
Series...
Data visualization: beautiful Paris?
-
When I saw Paris for the first time I was like, meh. Not Paris’ fault. This
was the second leg of a trip that started in Prague, and I was still in a
pro...
La diversificación reduce el riesgo financiero
-
Puede descargar el archivo de Excel: reaseguro.xlsx
En finanzas representamos el riesgo por la varianza σ2 o su raiz cuadrada,
la desviación estandar σ.
S...
Sydney Opera House: the designs that didn’t make it
-
From the Guardian: In 1956, the New South Wales premier Joseph Cahill
announced a competition – open to anyone – to design a national opera house
at Bennel...
Calcular y representar la duración del día con R
-
Problema
Queremos calcular y representar la duración del día con R en función de
unas coordinadas geográficas.
Solución
- 1. Calculamos la salida y pues...
An update on Google+ and Blogger
-
Following the announcement of Google+ API deprecation scheduled for March
2019, a number of changes will be made to Blogger’s Google+ integration on
4 Febr...
App Android para calcular ladrillos de un muro
-
Saludos a todos los visitantes de nuestra web de *ingeniería civil*, en
esta oportunidad compartimos algo diferente, se trata de una aplicación
para sus di...
Update: Name Manager
-
Name Manager has just been updated to build 666. Name Manager will now
recognize names starting with _xlfn as Excel system names.
Tip: Quickly clean up your data in Excel
-
[image: Quickly Clean Up Data and Formatting in Excel]Save 5 minutes a day
by using ASAP Utilities to quickly clean up your data in Excel. "Easily
optimize...
Formula Explorer Pro Beta 4.2
-
After another 6 months on my quest to create the worlds best tool for
exploring, validating, debugging and editing Excel formulas I have made
Explorer Pro ...
Get Email Information Into Google Sheets Using GAS
-
Last updated: 05/01/2019, 1 min read (without the code) Introduction We
have already seen how to send emails directly from Google Sheets. In this
post, we ...
Formación, formación y formación
-
Hace mucho que no actualizo ninguna información en el blog, ni para dar
consejos de Excel, ni para comentar los cambios que voy haciendo en el
sitio web,...
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...
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...
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...
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...
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.