Very useful resource to understand google coding practices and implementation
http://google-styleguide.googlecode.com/svn/trunk/htmlcssguide.xml
Google Style Guide
Reply
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.
Design 101 for web developers
This months Adobe Edge news letter article was interesting. It provided some useful links. I liked playing around typekit.
Read the Edge Article here.
Some useful links from the article.
Laying out designs with Grids and CSS
- 960 Grid System
- Blueprint CSS Framework
- The Grid System
- Yahoo! Developer Network YUI Grids CSS
- Design By Grid
Inspiring design sites
Working with typography
Obtaining stock photography
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.
http://www.myintervals.com/
http://www.basecamphq.com/
http://www.simplegtd.com/
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/
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/
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.
Chew on this.
www.chewonthis.org
After a long time… a new site goes up.
This site educates us about the health and environmental benefits of eating locally. It is managed by Carlin Greenstein and Annie Stranger. The design is done by Annie Stranger. The site is based upon WordPress, this is the first wordpress site developed by Nitesh Sankhalkar and I have put in my bits to help out. Overall it works really well.
Will update with more info later.
.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
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