I'm so glad I discovered VBA! Its a great tool if you're interested in electronics design and analysis! While Excel is a workhorse of the the electronics industry, it's not visually friendly when it comes to displaying equations or working with algorithms. But, VBA let's you write equations with meaningful variables. And to boot, you only have to write the equation once. Then simply call the function where you need it. Made a mistake? You only have to correct it once in the function.
You can down load the spreadsheet EE_VBA_Basics_Res_Divider.xls.
vo = vs * R2 / (R1 + R2).
What does the VBA code look like? Hit ALT-F11 and double click on the Modules > Modules1 in the VBA Project window. This opens the code window for this module.
What makes up this function? The first and last lines bookend the function to let the VBA compiler know which statements make up this function. The text following the'is ignored by the compiler. This is the place for your comments! Take some time to note what you did and why. For more complex functions, you'll be desperately scanning these comments later when you're reusing or debugging some code and trying to figure out - what was I thinking?
The meat of the function is the actual calculation of the resistor attenuation. Note that the result is placed in a variable with the same name as the function, K_Rdiv1. This is no accident. When executed, the value of K_Rdiv1 gets placed into cell from which it was called. Cool!
Okay, this ultra simple function did not showcase some of VBA's more advanced capabilities. But, it served our introductory purposes. There will be more interesting functions to challenge you coming around the bend.See how we’re using evidence-based techniques to augment complementary approaches like design thinking and user experience design, and helping organizations to de-risk their innovation strategies and investments.
Iron Door Agains Stone Wall, originally uploaded by KenEKaplan.
Rusty ironworks found in a late 17th century palace in Serra San Bruno, Italy, October 2007. Here’s a set of photos I shot in Calabria this October.
Learnin’ and Livin’ Together with Great People and Technology.
I=]
Taiwan IDF 2007 166, originally uploaded by KenEKaplan.
That’s good livin’ on the go. My boy Damian will go crazy for this motorcycle!
This is a great mix of storytelling — video, sound, editing and passionate energy from an Intel expert who can turn a phrase.
[podtech content=]=””\>
This is one I gotta check out.
[podtech content=]
Here’s the first part of the Graphing Social Patterns conference.
[podtech content=]
Dave McClure will be on a Social Media Club, Silicon valley panel at Intel headquarters on October 22. The discussion will be led by Shel Israel — YES! Others include IT@Intel blogger and social computing expert Eleanor Wynn, Social Media master Jeremiah Owyang of Forrester Research, Jennifer Jones of PodTech’s “Marketing Voices” and BobDuffy of Intel’s IT community, Open Port.
Register to attend the event here and see the online Upcoming Events listing here.
[podtech content=]
I missed the opportunity to visit with Six Apart during the Intel Developer Forum in September. They did participate in IDF’s Day Zero briefing with Intel Capital, when Intel’s investment group talked bout strategically supporting Web 2.0 companies like Six Apart.
[podtech content=]
I got to see Katie Delahaye Paine speak at the Cisco and SPP Social Media Summit earlier this year. She was GREAT!! So energetic. So definitive and informative. I gotta revisit her blog more often, as she shares insights and tips all the time.
[podtech content=]
The Movin' Ahead archives for October, 2007.
The Movin' Ahead archives for October, 2007.
Entries Feed and Comments Feed
You are viewing a mobilized version of this site...
View original page here
Recent CommentsRSSDouble-barrel-aged sour red lager with fruits, spices, and herbs.
This cocktail-inspired Flemish Red started as a soft, nuanced rotbier which we aged in 20 year Remy Martin French Oak Cognac barrels with mixed cultures before we then transferred the batch into Sazerac Rye barrels for further aging. The batch was then refermented in steel with black cherries, mission figs, orange peel, vanilla beans, and a blend of herbs and spices to emulate cocktail bitters.Search Your Google Chrome Bookmarks With Everymark
If you have a huge list of bookmarks stored in your browser, or piles upon piles of folders within folders containing these bookmarks, it can become a real challenge to find one in the time of need. Manually sorting through your bookmark library is not an easy task, making it a tiresome effort.
For users using Google Chrome, Everymark is an extension that allows one to perform search within the saved bookmarks.
Clicking the extension’s icon will display a pop-up menu listing all your bookmarks as well as a search bar. Enter a few characters to shortlist only those results that correlate to this tool, the results are shown in real-time. It is possible to navigate within folders using the backslash key, and delete bookmarks as well.
The extension works great on the latest version of Google Chrome browser.
Everymark Chrome Extension
Pingback: Manage Your Bookmarks In Chrome()I’ve made a 4-minute video for you of the various pieces of equipment I use in doing my writing, podcasts, video, and audio creations. I thought it might help to see what I use and that I might give you some ideas if you’re in the market for any of this type of equipment.
I’ve also had the video transcribed if you’d rather read than watch and listen.
And, I’ve included a list of all the equipment with links. Many of the links are Amazon affiliate links, by the way. I hope you enjoy and that you find it to be of some value.
Go here if you cannot see video.
00:00:00 Bob: Hi, everyone. Bob Poole here today, to share with you some of the Tools that I use here in my Office. One of the first things that I really love, is I use two Monitors. I have been doing it, probably, for about six or seven years now. And, I find them indispensable, they just make life a whole lot easier. So, if you ever go to using two, I do not think you will ever switch back.
00:00:19 I use a split keyboard also, for ergonomic reason, I can type better and faster on it. I also have a mouse that positions my hand vertically. You can find some more information about that in the Notes.
That is a typical couple of lines phone, but I use a headset that allows me to walk down three flights, go outside across the street. I can get my mail all while staying connected.
00:00:43 I also have blue USB Podcast Microphone, that is it right there, that I used for Podcasting and recording, even this voice-over that I am doing right now.
This might be something that you have not seen before. It is called a Square and this has taken the place of my Merchant Account. This is actually a little Credit Card Processing Unit, I guess, you would call it. It fits right on top of my iPad. And, I can run a Credit Card right through that. It will also fit on any kind of Smart Phone. I like it on the iPad, and I really like using the thing.
00:01:20 I have a couple of good Studio Monitors for my sound, because, I am going more Video and Audio. Here is a Mixer that will record right to an iPod that I can plug in there. And, I have another microphone setup that will allow me to record to that. So, if I wanted to do Interviews here in the Office, I could do that.
00:01:42 I have an Epson Printer that prints CDs and a Scanner, which, I think is indispensible these days, especially since I do not use a Fax anymore. This is a large Epson Photo Printer. I use it to print photos, because, I still do some of that work, and enjoy doing it. If it is not work, then sometimes just for play and for creative reasons. That is some prints that just came off.
00:02:10 They are sitting right now on top of a table which is really my Shipping Area. This is where I can weigh books and send them out. There is the infamous Fax Machine that is not even plugged into anything … so … I am not sure why I have that.
00:02:25 And, you always have to have a least two dogs in your Office. This is Max, we call him “Max, the wonder dog,” he is the white one. And, over there the little tiny black dog, is named “Sambuca,” he is going to say hello to you. And, besides having dogs, you should also have the Office Cat. This is “Toby”, the Office Cat, sitting in his own chair.
00:02:47 I keep a couple of these lights. These are cool lights, and they are used for Videos,