background preloader

Excel Unusual

Excel Unusual
About the Speed of Spreadsheets #2 This is the second post on Excel speed. The first part benchmarked the calculation speed of Excel 2003 versus Excel 2007 for various size arrays of formulas. This part analyzes the effect of formula complexity on the spreadsheet speed. Power Management: An Animated Buck Switching Regulator Model in Excel 2003 This is an animated model of a Buck voltage switching regulator in MS Excel 2003.

Related:  Electronics 4ExcelExcel LINKS

Fubarino Contest: Serial Data Transmission [Jesus] is helping his cousin learn about microcontrollers. Right now they’re on the subject of serial communications, which turned into a nice way to add a Hackaday Easter Egg. Using and FTDI chip in conjunction with the PIC 18F4550 (it’s a little soon for them to tackle implementing USB directly) the serial data is shown in a terminal window.

Basic Excel - 7 Buttons You Must Add to your Quick Access Toolbar - Computergaga Blog In the latest version of Excel it has become your responsibility (if you choose to) to create your own toolbar, and in our basic Excel series we show you how.. The Quick Access Toolbar at the top of your screen begins with just the Save, Undo and Redo buttons. If you require fast access to any other Excel commands you are able to add them yourself. You can add almost any functionality to the toolbar including those not found on the Ribbon. As part of our basic Excel series, this post explores 5 incredible additions to the toolbar that are sure to improve the way you work.

USBPIC controls just about anything Over the last few years, [Michael] has been developing a PIC microcontroller board. He calls his project USBPIC, and with the addition of a few FET drivers, H-bridges, and LED drivers his homemade dev board can handle just about anything thrown at it. [Michael]’s board is build around a PIC18F2455 microcontroller with both an In Circuit Serial Programming header and support for a USB port included. Instead of going for a modular format where the board can expanded through shields or expansion cards, [Michael] decided to make three different versions of the USBPIC. How to VLOOKUP with Multiple Criteria Using INDEX and MATCH in Excel December 21, 2013 By Andrew Roberts VLOOKUP is a great tool for pulling data from tables, but it has a handicap: it can only work with one criteria for matching information. If there are multiple rows in your sheet with the same information, you’ll only get the first one. If you need to use two or more conditions to match a specific piece of data, you’re out of luck. Fortunately, Excel has a pair of functions called INDEX and MATCH that can help produce the same results as VLOOKUP with multiple criteria.

Learning Excel - Awesome Date Functions in Excel - Computergaga Blog Do you want to advance your skills by learning Excel? Performing date calculations can sometimes be troublesome. Trying to calculate the number of working days between two dates, or automatically finding the date in two months’ time is not as straight forward as formulas with general numbering can be. Fortunately Excel has a full repertoire of fantastic date functions. PIC 18F4550 dev board [Natsfr] was looking for a single-sided PCB to host a PIC 18F4550. Not finding one he designed his own in Kicad and is sharing (translated) the spoils of his labor. This chip has USB capabilities which is why we see it used in a ton of projects. Using the Hyperlink Function in Excel - Computergaga Blog Hyperlinks can be used to link to other sheets, webpages or other files such as PDF’s from your Excel spreadsheet. If you are creating hyperlinks for many records though this will take a long time to set them up. Excel provides a HYPERLINK function for creating hyperlinks in our spreadsheets. The real power behind this function is that it can be used to create dynamic hyperlinks. We can create conditional hyperlinks by nesting them within an IF function, or create hyperlinks that can find the address to link to themselves by embedding Lookup or Text functions within them.

Arduino PIC programmer writes to 18F family [Kirill] wrote in to share his Arduino-based PIC programmer. It is capable of writing to the 18F family of chips, including 18F2XXX and 18F4XXX. We think that’s pretty exciting because this line of chips has USB functionality and there are bootloaders out there that let you program them via USB. So if you wanted to build your own PIC dev-board (like this one) you can use your Arduino to flash the bootloader. This post comes hot on the heels of the Arduino being used as a PIC 16F programmer. That hack has a rudimentary programming GUI, something that [Kirill] admits his lacks but has no plans to implement himself.