March 21, 2011
Excel Compare Cell Value in Range
I have been playing a lot with Excel Data lately and one of the usual items was to look for a cell value within a range. I started with a macro scripting but soon realized that I would waste a lot of time in it and there might be a easier method in Excel.
Seems like there was.
I used the following statement to view a cell value is in range or not and marked it "Yes" or "No".
=IF(COUNTIF(INDIRECT("K3"):INDIRECT("K347"),C3),"Yes","No")
K3 = Start of Range
K347 = End of Range
C3 = Cell Value that needs to be compared.
COUNTIF(range,criteria)
Range is the range of cells from which you want to count cells.
Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted. For example, criteria can be expressed as 32, "32", ">32", "apples", or B4.
The INDIRECT worksheet function is a useful tool for creating cell or range references "on the fly", as a formula is evaluated, rather than "hard coding" them into the formula. Microsoft's on-line Help documentation of this function only hints at is usefulness.
In its simplest usage, the INDIRECT function allows you to put the address of one cell in another, and get data from the the first cell by referencing the second. For example, if cell A1 has the value "C3", then =INDIRECT(A1) will return the value in C3.
The real power of the INDIRECT function is that it can turn any string into a reference. This includes any string that you build up using string constants and the values of other cells in the formula, strung together with the & concatenation operator. For example, the simple formula. INDIRECT statement lets you keep the cell value constant and not change when you drag this function into multiple rows.
Posted by Varun Shetty at 09:33 AM | Comments (0)
June 12, 2010
Flash Box 2D tutorials
AS3 Flash Physics Engine
Box2D - http://box2dflash.sourceforge.net/
Box2D is an open source physics engine written primarily for games. As the name suggests, Box2D is a purely 2D engine. However, Box2D has grown beyond it's humble box simulating roots, and can now handle convex polygons and other shapes.
Flash Box 2D Tutorials
http://www.kerp.net/box2d/
http://www.emanueleferonato.com/category/box2d/
Posted by Varun Shetty at 04:27 PM | Comments (0)
January 12, 2010
jQuery Lightbox Scripts
Why build your own light box when there are more than a dozen scripts available!!
The Best jQuery Lightbox Scripts by Bilal Çınarlı
http://woorkup.com/2009/12/29/jquery-lightbox-scripts/
and
Comparison of various scripts that display images
and other objects in somehow cool CSS popups
http://planetozh.com/projects/lightbox-clones/
Posted by Varun Shetty at 10:48 AM | Comments (0)
November 23, 2009
Flex Testing
I have been using Flex Unit for a while and suddenly felt the urge to search on other competitive testing frameworks, and to my surprise there were couple of testing frameworks. I think they specialize in their own ways.
Flex Monkey
FlexMonkey is a testing framework for Flex apps that provides for the capture, replay and verification of Flex UI functionality. FlexMonkey can record and playback Flex UI interactions, and generates ActionScript-based testing scripts that can easily be included within a continuous integration process. It uses the Flex Automation API and was created by extending Adobe's sample automation adapter, AutoQuick.
Features:
* Records and plays back Flex UI interactions
* UI Interactions can be edited and replayed
* Generates FlexUnit TestCases, and can also be used with non-FlexUnit-based testing frameworks
* Works with Flex and AIR apps
* Apps can be tested running standalone or in a browser
* Tests can be run from build systems such as Ant
* Handles all Flex UI events
* Uses Flex Automation API to provide native control over your flex app. Requires no javascript or browser plug-ins to use.
* Unit tests are written entirely in ActionScript. No other programming or special purpose scripting languages are needed to develop comprehensive UI test suites.
* Non-invasive. Requires no modifications to your application source.
FlexUISelenium
FlexUISelenium is an extension to the Selenium RC client driver that enables the Selenium RC client drivers to interact (and test) the Flex UI components and methods of the Flex application.
Flex Unit
FlexUnit is a unit testing framework for Flex and ActionScript 3.0 applications and libraries. It mimics the functionality of JUnit, a Java unit testing framework, and comes with a graphical test runner.
Posted by Varun Shetty at 02:37 PM | Comments (0)
May 16, 2009
Beyond Compare - File/Folder/Source Code Comparison
This is an amazing little tool that lets you compare files, folders and source code. It has been extremely useful for me, when there are more developers working on a single page of code. I have tried some code compare'r software before and this one turns out the best. It is small, simple and easy to use. Do not forget to look into the file viewer rules here.
Other code compare tools are.. (I havent tested them yet)
Araxis Merge
Examdiff Pro (Fast search on hard disk)
Win Merge
File Locator Pro
KDiff
Posted by Varun Shetty at 09:28 PM | Comments (0)
.sol editor (flash shared object/ flash cookie)
If you are working with Flash shared object or you might say flash cookie. It would be easier to verify the stored data by using .sol editor by Alexis Isaac. I frequently use this to even debug/read cookies from other sites. It just helps me understand the architect of some games they way it is made.
Download .sol editor from sound forge.
.sol editor
Posted by Varun Shetty at 09:20 PM | Comments (0)
February 26, 2009
Flash Physics Engines
List of Physics engines for Adobe Flash
1. APE: www.cove.org/ape/index.htm
2. Box2DFlashAS3: box2dflash.sourceforge.net
3. Fisix Engine: www.fisixengine.com
4. Glaze: yaa-blog.blogspot.com/search/label/Glaze
5. Motor2: lab.polygonal.de
6. PopShapes: lab.andre-michelle.com/physics-engine
Posted by Varun Shetty at 06:46 PM | Comments (0)
January 24, 2009
Cake PHP
Its been sometime I have worked on PHP, but I would love to try this out.
CakePHP is a rapid development framework for PHP that provides an extensible architecture for developing, maintaining, and deploying applications. Using commonly known design patterns like MVC and ORM within the convention over configuration paradigm, CakePHP reduces development costs and helps developers write less code.
Posted by Varun Shetty at 08:30 PM | Comments (0)
Saving Images Out of Flash/Flex Without Losing Quality
An interesting post by Jesse Warden, something you don't want to forget when you have an opportunity to work on an application that saves an image on the disk.
http://jessewarden.com/2009/01/saving-images-out-of-flashflex-without-losing-quality.html
Posted by Varun Shetty at 08:28 PM | Comments (0)
October 21, 2008
VisualComplexity
visualcomplexity is a space to view complex network visualization. The main goal is to understand different visualization methods across a series of disciplines, as diverse as Biology, Social Networks or the World Wide Web.
This is very inspiring and truly can be a future of visualization.
Posted by Varun Shetty at 03:12 PM | Comments (0)
October 13, 2008
Wordpress blogger templates
I am still planning to switch over from moveabletype to wordpress. progress have been very slow on it. Trying and testing different features, plugins, templates... this time I would like to make sure I have most of the items fixed and not bother about the blog engine for next couple of years.
Templates:
http://www.jackbook.com/
http://www.wordpress.org/
http://www.smashingmagazine.com/
http://www.bspcn.com/2008/11/10/50-beautiful-free-wordpress-themes/
Posted by Varun Shetty at 12:16 PM | Comments (0)
October 06, 2008
Flex Styling and Skinning
Degrafa is a Declarative Graphic Framework to level things between a designer and a developer. There are many things involved in it, one of it is to eliminate the learning curve to use these. So at a production level it can be used pretty fast. The core team is a mix of Architects, Framework Developers, UX Architect and Framework Engineers.
http://www.linearticulator.com/
Posted by Varun Shetty at 10:43 AM | Comments (0)
October 03, 2008
Time Tracker/ GTD's
Using time trackers/ GTDs on medium level projects becomes essential to track efficiency and development progress. It especially becomes important when you are not a the same location. Here are the few links to online time trackers which can be useful.
Posted by Varun Shetty at 03:28 PM | Comments (0)
August 27, 2008
Statistics and Trend Links
Links that would help to learn the web search trends and traffic results, I am pretty sure there are a lot more and these results are really intriguing and helps to learn in a global perspective of where a company site stands. Wish to get more such links and append this list.
Posted by Varun Shetty at 09:27 AM | Comments (0)
June 12, 2008
preparing for wordpress
It has been sometime that I have planned to move my blog into wordpress, I did many tests on it and loved it, just trying to read more articles and get prepared to move the paranoid
links to read:
http://codex.wordpress.org/Upgrading_WordPress_Extended
http://techie-buzz.com/wordpress-plugins/wordpress-automatic-upgrade-plugin.html
security-
http://www.noupe.com/how-tos/wordpress-security-tips-and-hacks.html
http://sitening.com/blog/2008/04/08/wordpress-security-vulnerabilities/.
WordPress Plugin I need..
http://www.flashtexteditor.com/ftf/
Posted by Varun Shetty at 02:19 PM | Comments (0)
AS3/Flex/Flash Coding Convention
http://opensource.adobe.com/wiki/display/flexsdk/Coding+Conventions
A really good link on Coding Conventions and Best practices, I do not think that this should be limited to flex. It would be nice to use this conventions across OOPS concept wherever it is possible.
Posted by Varun Shetty at 01:09 PM | Comments (0)
April 30, 2008
Deep linking for Flash and Ajax
I was reading about SWFAddress by Asual DZZD. Deep linking is one of the usual questions that I get when it comes to flash/flex metrics tagging and how the information can be read and interpreted to direct links. Maybe this is the solution, this is what they have to say about it.
SWFAddress is a small, but powerful library that provides deep linking for Flash and Ajax. It's a developer tool, allowing creation of unique virtual URLs that can point to a website section or an application state. SWFAddress enables a number of important capabilities which are missing in today's rich web technologies including:
* Bookmarking in a browser or social website
* Sending links via email or instant messenger
* Finding specific content with the major search engines
* Utilizing browser history and reload buttons
Link: http://www.asual.com/swfaddress/
Posted by Varun Shetty at 06:18 AM | Comments (0)
February 05, 2008
What is Singularity?
So finally I get a mail from Aral Balkan and I was really excited about it. Singularity is probably the first viral campaign within the flash community and that is what made me more intrigued about it.
What is Singularity?
Those of you who know me probably guessed that it was something Flash-related. Maybe an RIA? Or a new framework or library? Hmm, well, it does involve Flash but not in the way that you think!
Singularity is a conference. A web conference.
But not a traditional web conference.
Singularity is the world's first large-scale online web conference!
Here's a quick overview:
In a nutshell
Singularity is a technological tour-de-force and a beacon to signal just how far we have come and what we can archive on the web in 2008.
Singularity is over 100 of the world’s top web visionaries, developers, designers, thought leaders, and celebrities.
Singularity is web standards, JavaScript, Rich Internet Applications, and the Flash Platform all in one snapshot.
Singularity is a 3-day, multi-track online event the likes of which has never been experienced.
In 2008, Singularity will define Web ’08.
The Pricing is not yet finalised, I would really recommend keeping an eye on the site.
Posted by Varun Shetty at 06:57 AM | Comments (0)
February 02, 2008
Singularity - trying to be the first one to know it..
Posted by Varun Shetty at 02:56 PM | Comments (0)
January 31, 2008
actionscript speedcoding
SpeedCoding video by Joa Ebert.
http://blog.je2050.de/2008/01/20/speedcoding-2/
There are many interesting samples and articles on image processing within his blog. His blog also includes a section on Imageprocessing Library.
The Imageprocessing Library is a set of ActionScript 3 classes designed to work simple and performant. It comes with more than 50 filters to manipulate images and synthesize textures.
These libraries are not scientifically correct and they are to achieve good results in a short span.
Posted by riddlerr at 11:44 AM | Comments (0)
January 22, 2008
WOW-Engine (AS3 3D Physics Engine) in Flash
Jerome Birembaut released the WOW engine today, and everyone was eagerly looking for it. Some of the earlier experiments shared by him were just amazing and unbelievable. I never imagined flash could go far and this time it is even without an update. These are API's/Classes created and mashed up with other engines like (Sandy3D , Papervision3D, Away3D for 3D). hat are made from someone just not from Adobe.
here is an excerpt from WOW.
WOW-Engine is a free AS3 open source physics engine written by Seraf ( Jérôme Birembaut ) capable to handle positions in a 3D environment.
WOW-Engine use Sandy library for all the 3D mathematical computations (matrix, 3D vector, plane). The inner architecture of the engine is also inspired by Sandy’s one.
I hope that I get some time to work on this soon, will post my results later.
Collisions and physical reactions are possible thanks to the AS3 physic engine made by Alec Cove, named APE(version 0.2.).. Even if APE is a 2D physic engine, it is possible to extend the contraints on volumes, and that’s the purpose of WOW-engine. WOW-engine extends APE, and allows to simulate physics on 3D volumes.
WOW-Engine is capable to handle positions and rotations of abstract objects, which need to be linked to some visual objects (2D or 3D). The visual objects can be drawn thanks to another library (Sandy3D , Papervision3D, Away3D for 3D).
WOW-Engine use and depend of the Data Structures classes written by polygonal labs.
Posted by Varun Shetty at 08:12 AM | Comments (0)
January 02, 2008
ECMA Script 4
ECMAScript is widely used on the web and is often referred as JavaScript or JScript. ECMAScript is a scripting programming language, standardized by Ecma International in the ECMA-262 specification.
Flash Action Script is also based on ECMA Script 4. The next version of flash player (After AS 3.0) will be implementing ECMAScript 4. If you want to read more about ECMAScript 4.0, you can read it on ECMAScript.org. Also I would recommend reading John Resig's blog that has a screencast video featuring the ECMA Script code and how you can play around with it.
http://ejohn.org/blog/playing-with-ecmascript-4/
Posted by Varun Shetty at 12:05 PM | Comments (0)
December 22, 2007
Background patterns for websites
There are so many websites that you see with some really cool backgrounds, some of them are traditional pixel stripe patterns or big designed graphics. They can be simple but yet attractive. It gives a complete visual style to the website without adding any attention to it.
I started looking around websites for more designs and I found these 2 links which actually gives you these patterns for free and more than that, you can even make your own pattern.
You can find these titling beauty from the following websites.
Posted by Varun Shetty at 02:32 PM | Comments (0)
June 11, 2007
Icon Search
www.iconlet.com - icon search engine
You can search free icons for your project. Be sure to check out the "Advanced Search" where you can specify icon size, name, format (gif or png) and specifiy a particular license for use.
A nice resource and great to bookmark for handy icon searches.
Posted by Varun Shetty at 07:43 PM | Comments (0)
Microsoft Photosynth
Microsoft Photosynth
Just came across this software from Microsoft, it is still in its lab version named as 'Photosynth'.
Photosynth combines hundreds or thousands of regular digital photos of a scene to present a detailed 3D model, giving viewers the sensation of smoothly gliding around the scene from every angle. The scene can be constructed regardless of whether the photos are from a single or multiple sources. It’s like a hybrid of a slide show and a gaming experience that lets the viewer zoom in to see greater detail or zoom out for a more expansive view. By viewing the photos in a 3D context you are able to get a better sense for the place where they were captured.
The Photosynth Team haven't released the software or the webware yet. They are currently busy solving technical hurdles before they are ready for primetime.
Posted by Varun Shetty at 11:32 AM | Comments (0)
October 08, 2006
Web Debugging Tools
Charles Web Debugging Proxy
If you want to create a robust Flash Remoting Application, Charles Web Debugging Proxy is an highly recommended tool.
This will allow you to easily see what Remoting calls (and all other HTTP traffic) that are going over the wires.
ieHTTPHeaders
ieHTTPHeaders is an Explorer Bar for Microsoft Internet Explorer that will display the HTTP Headers sent and received by Internet Explorer as you surf the web. It can be useful in debugging various web-development problems related to cookies, caching, etc.
Posted by Varun Shetty at 07:33 PM | Comments (0)
May 28, 2006
Flash Source (FLA) Version Checker and Launcher
FLAver 1.0
by northcode.com
I switched my machines a few days back without much program backup and I just couldn't remember the name of this lil' utility which really did save my time whenever I double clicked on an FLA file. I am not sure how I got this software earlier. But it sure relieves me from the annoying popups. Finally I did get my hand on it and blogged about it so that I wouldn't forget it's name again.
From Northcode.Com...
When you double click on an FLA file it opens the last version of Flash that you used instead of the version of Flash that was used to create the FLA. If you have multiple versions of Flash installed, every click to open an FLA file is like rolling the dice. If you lose you get the "Unexpected file format" message, which really means "open me in the right version of Flash please".
If the last version of Flash you had open was MX 2004 and you double click on a version 6 (Flash MX) FLA file it will open, but it can take a looong time and then you still have to close Flash MX 2004 and reopen the FLA in Flash MX so you can edit it without making a mess of the FLA.
Admittedly the amount of time lost isn't huge, but it sure is annoying and life would be so much easier if the FLA was just opened in the right version of Flash. Well, I finally got fed up and created a utility that will do this... the Flash Version Checker and Launcher or FLAver for short.
When you install FLAver it hijacks the FLA format from Flash and associates all FLA files with FLAver.exe so when you double click on an FLA file it is opened by FLAver first. FLAver doesn't actually open the FLA file for editing, it just looks that the version of the FLA file and at the versions of Flash you have installed and chooses the closest version match for the FLA file. If you try to open an FLA file and you don't have a version of Flash that can open those FLA files FLAVer will present you with an error message like the one below, otherwise the FLA just opens in Flash and you can go on about your business.
FLAver was designed to run on all versions of the following operating systems: Windows 95, Windows 98, Windows Me, Windows NT, Windows 2000 and Windows XP
Posted by Varun Shetty at 03:23 AM | Comments (0)
September 29, 2005
Tips for Shooting Video
Current Studio VC2 Survival Guide
This is one helluva tips for shooting videos, they call it the survival guide while making videos, the topics are broken down to Gear Guide, Compression Guide, Shooting Guide. The whole presentation is made in flash and it's made really good. It's worth an archive 'cause you may always wanna check this out before going on a video shoot trip. :)
Posted by Varun Shetty at 04:02 AM | Comments (0)
September 15, 2005
Blogsearch.google.com
Google has started with their new Blog Search focused on Blogs.
There are a few different ways you can get to Blog Search:
* blogsearch.google.com (Google-style interface)
* search.blogger.com (Blogger-style interface)
If you do not publish a site feed for your blog, it will not be included in Blog Search. However, if you previously published a site feed that was included, the old posts will remain in the index, even though new ones are not added
Blog Search will also respect robots.txt files and NOINDEX, NOFOLLOW meta tags, as described at http://www.google.com/remove.html
I did a search on my nick as well as my name.. couple of things did come up.. :)
Posted by Varun Shetty at 04:32 AM | Comments (0)