Category Archives: Tips and Tricks
to be come a Web Design professional
To be a professional web designer, you need to gather the knowledge and develop your skill in the following terms
- Web Technology (how they work – the basics)
- Design Concept (Why desing need?)
- Development Process
- Page layouts (why to think about the layouts)
- Audience and Audience usability
- Browser technology (why differ)
- Navigation method (for whom, for what and for why)
- Graphics concept, different between web graphics and print graphics
- Ethical issues
- Basic HTML concept
- Basic Image editing method
- Basic Web Server management
- At the end Search engine Optimization method
Overall those are the minimum knowledge and skill required to be a master web designer . For more information in web design you are always welcome to call me…. Try my cell or email from my contact page.
Article by
Khan Mohammad Mahmud Hasan
Professional Web Designer and Trainer
Inventory Freight Calculation
To account for freight on incoming inventory, I allocate the freight charges proportionately over the inventory items by total value. Quickbooks doesn’t have a way to handle that, so I use a simple Excel spreadsheet to do the calculation.
The last entry is always the freight (or handling or whatever I want to distribute). I don’t have much information here because it’s just a throwaway calculator. I get the numbers I need for data entry from the Totals column and don’t save the workbook.
I start by making a couple of defined names. First, ‘Freight’ is defined as =OFFSET(Sheet1!$B$2,COUNT(Sheet1!$B:$B),0).
It picks the last used cell in the Line Items column. It starts at B2 and COUNTs down the number of filled cells. Note that I don’t use COUNTA because I don’t want to count B2, which is text.
Next I define ‘LineItems’ as =OFFSET(Sheet1!$B$2,1,0,COUNT(Sheet1!$B:$B)-1,1)
That picks up all the numbers in column B except the last one.
C3: =IF(ISBLANK(B4),0,ROUND(Freight*(B3/SUM(LineItems)),2))
The above formula allocates the freight into the Freight column. Download FreightCalculator.xls.zip
Calculating a Date Based on Year, Week Number and Day of the Week
Use the DATE and WEEKDAY functions as shown in the following formula:
=DATE(C2,1,3)-WEEKDAY(DATE(C2,1,3),1)+7*(B2-1)+A2
Entering dates quickly, without having to use delimiters to separate month, day, and year.
nter only the \”day\” part of the date and complete it by using the DATE, YEAR, TODAY, and MONTH functions in the following formula:
=DATE(YEAR(TODAY()),MONTH(TODAY()),A2)
Thus, on entering \”5\”, the formula will automatically create a date representing the 5th of the current month in the current year.
Solution 2:
Enter the entire date, without delimiters, and use the DATEVALUE, LEFT, MID, and RIGHT functions as shown in the following formula to convert it to a proper date:
=DATEVALUE(LEFT(D2,2)&\”/\”&MID(D2,3,2)&\”/\”&RIGHT(D2,2))
Thus, on entering \”060705\”, the above formula will return \”06/07/05\”.
Problem:
Entering dates quickly, without having to use delimiters to separate month, day, and year.
Solution 1:
Enter only the \”day\” part of the date and complete it by using the DATE, YEAR, TODAY, and MONTH functions in the following formula:
=DATE(YEAR(TODAY()),MONTH(TODAY()),A2)
Thus, on entering \”5\”, the formula will automatically create a date representing the 5th of the current month in the current year.
Solution 2:
Enter the entire date, without delimiters, and use the DATEVALUE, LEFT, MID, and RIGHT functions as shown in the following formula to convert it to a proper date:
=DATEVALUE(LEFT(D2,2)&\”/\”&MID(D2,3,2)&\”/\”&RIGHT(D2,2))
Thus, on entering \”060705\”, the above formula will return \”06/07/05\”.
Finding the Last Day of a Given Month
=DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0) where num_mths = 0 for the end of month for the current month and num_mths = 1 for the end of the month for the next month, etc.
1. Tried the formula if num_months = 0, it gives the end date for the prev
Selecting a random value from a List.
Using the RAND function in the following formula:
=INDEX(A2:A7,ROUND(RAND()*COUNTA(A2:A7),0))
The value returned by the formula will change with each recalculation (F9).
