Friday, December 31, 2010

Registering Disco Workbook in Apps R12


1) Create the workbook

2) Open the workbook in the Discoverer Desktop or Plus edition and go to
'File->Manage Workbooks->Properties' look for the value for 'Identifier'. Save this value.

3) Create a form function. The form function definition includes the properties listed in these tabs:

3.1 Description tab:
3.1.1 Function Name: XX_[FUNCTION_NAME] (it is accepted practice to identify customizations with an XX prefix)
3.1.2 User Function Name: This is the name that will show in the menu
3.1.3 Description: Add a description of the function if you want.

3.2 Properties tab:
3.2.1 Type : SSWA jsp function
3.2.2 Maintenance Mode Support: Leave as "None"
3.2.3 Context Dependence: Leave as "Responsibility"

3.3 Form tab:
3.3.1 Form: Leave the field blank.
3.3.2 Application: Leave the field blank.
3.3.3 Parameters: mode=DISCO&workbook=(workbook identifier from step2)&parameters=(Disco parameters name/values)

3.4 Web HTML tab:
3.4.1 HTML call : OracleOasis.jsp

3.5 Web Host tab:
3.5.1 Leave all fields blank.

3.6 Region tab:
3.6.1 Leave all fields blank.

3.7 Save the form.

4) Open the menu form as sysadmin.

4.1 Search for the main menu under which you want the link to appear.
4.2 Add the information you need such as prompt, submenu, description etc.
4.3 Enter into the Function field the name of the function you created in step 3.
4.4 Save the menu form.

A message will appear saying that a concurrent program will run to regenerate the menus.

5) Set below Profile options, if your End User Layer Name = EUL_US
ICX: Discoverer Default End User Layer Schema Prefix = EUL
ICX: Discoverer EDW End User Layer Schema Prefix = US

6) Bounce Apache and Forms.

Tuesday, December 28, 2010

A is for ALPHA, it’s really all Greek,

B is for BRAVO, “three cheers” so to speak,

C is for CHARLIE, a Drake with a smile,

D is for DELTA, the mouth of the Nile,

E is for ECHO, a Sonar type ping,

F is for FOXTROT, a dancing type thing,

G is for GOLF, played with Ball and with Club,

H is for HOTEL, a posh sort of club,

I is for INDIA, far, far away,

J is for JULIET, in Shakespeare’s play,

K is for KILO, a thousand to you,

L is for LIMA, and thats in Peru,

M is for MIKE, makes your voice “loud and clear”,

N is for NOVEMBER, quite late in the year,

O is for OSCAR, a Wilde sort of chap,

P is for PAPA, a backward ApAp,

Q is for QUEBEC, far over the sea,

R is for ROMEO, ‘neath balcony,

S is for SIERRA, a mountain in Spain,

T is for TANGO, and dancing again,

U is for UNIFORM, white, black or blue,

V is for VICTOR, the man who beat you,

W is for WHISKEY, which TT’s deride,

X is for XRAY, to see your inside,

Y is for YANKEE, a New England man,

Z is for ZULU, he’s black (or dark tan!).

Friday, December 24, 2010

Pune Goa Direction

I know I am writing very late but it is for any on who wants to take NH 4 passing by Satara, Kolhapur and on the way to Belgaum. The road is wide, a high way and you can easily go up to a speed of 120-150. And is a nice ride.
Follow the Satara Road, go past kolhapur and then from Shankreshwara take a right turn.You will have to go down underthe bridge to take the right turn.
The small road will take you Gadgilanj or soemthing like this.Then coems Amboli Ghat and after that Sawantwadi.
From Sawantwadi its straight to Goa in 1 hour.
The whole journy for me takes not more then 8 to 10 hours driving with a speed of 100-120 on the highways and 60-80 on the inroads wiht one or two half hour stops in between. The distance is 450 kms approximately.
-----------------------------------------------------------------

to reach faster ...do pune to belgaum on the GQ ..u can easily do the 330 odd kms in about 4-5 hrs ...from belgaum you can tak eteh NH4A to panaji via Londa ...its a superb drive but you have to watch out for dumper trucks and also for loose sand on the corners ....

from belgaum to panaji its about 150 kms ...which should take you about 2.5 to 3 hours ...so the total time through this route should take about 8-10 hours max ..

-------------------------------------------------------------------


Pune - Satara - Kolhapur - Kagal - Nipani - Uttur - Ajara - Amboli - Sawantwadi - Goa. Total distance 491 kms. Driving speed 80Kmph in my friends van on the 4 lane NH-4 and between 60 - 80 kmph on State Highways 121 and 123 between Sankeshwar and Sawantwadi. Surprisingly it took us 8 hours and 45 minutes at these speeds to reach Goa with 2 Fuel stops, 1 flat tyre repair, 1 break for lunch and 1 at the Amboli waterfall.

For a better driving experience, get into Kolhapur city, ask for directions in the crowded and narrow laned town for 'Rankala' (This is a huge lake/reservoir). On reaching Rankala ask for directions to Gaganbawda ghat and enjoy the drive. This road takes you to Kankavli on NH-17 (Bombay - Goa highway) which is about 100 kms north from Sawantwadi. This route extends the journey distance by about 85-90 kms.

Other alternate route as mentioned by Satya. One from the same route is to go via Chorla ghat this is between Belgaum and Panji. Try this resort for a stay http://www.wildernest-goa.com/ . You will have to leave your car in their guarded parking lot. They transport you to the resort on bullock carts.

------------------------------------------------------------------

have driven many times from various routes from Pune to Goa and found that route via Tamhini ghat-NH17 is more time consuming as compared to Route via Kolhapur-amboli-sawantwadi. This has become faster with 4 lanes on bangalore highway taking you to kolhapur in just 3 hours. Amboli ghat/Sawantwadi is scenic but NH17 has its own charm. Route via chiplun is even longe

Wednesday, December 15, 2010

item supply/demand - basics on calculation

http://forums.oracle.com/forums/thread.jspa?threadID=665964


Depends a lot on how your instance is configured (mfg is there or not, external ATP sources are used or consigned inventorry exists etc)

For simple site in a distribution company looking back into my notes, here are the details:

this form is based on a table mtl_supply_demand_temp. This table is usually empty, but you can find rows here if you query the table when you are in the form after you query the form (don't close the details block, it will delete the records from this table).

One ATP rule will be automatically created in mtl_atp_rules table for every session and is used to identify the supply and demand sources. If you look at the ATP rule screen you will get an idea for the demand and supply for the quantity.

As far as the calculation goes, depending on the sources for demand and supply used in the ATP rule created, it will look at the following tables:

Supply:
mtl_supply (PO and req)
mtl_onhand_quantities_detail (onhand)
wip_discrete_jobs (wip jobs)
mrp_org_quantity_v and mrp_plans (production schedules) to name a few for supplies

Demand:
mtl_reservations
mtl_material_transactions_temp
again mrp plans may also be used if there is a component demand.



traditional form launches the native C function "INXDSD" from the INVDVDSD procedure



I tried using the same code used by the form in SQL. It worked. The only issue is that the ATP group Id specific to this request is not populating appropritely. It is always populating as 0. If I register as concurrent program probably it will populate correctly. This is required in order to delete the rows correctly belonging to that session from the mtl_supply_demand_temp at the end of the session.

You can try that if you are Ok with that approach. This way you do not have worry about finding out the tables to query. Here is that I did.

DECLARE
l_seq_num NUMBER;
rtvl NUMBER;
args1 VARCHAR (240);
args2 VARCHAR (240);
args3 VARCHAR (240);
args4 VARCHAR (240);
args5 VARCHAR (240);
args6 VARCHAR (240);
args7 VARCHAR (240);
args8 VARCHAR (240);
args9 VARCHAR (240);
args10 VARCHAR (240);
args11 VARCHAR (240);
args12 VARCHAR (240);
args13 VARCHAR (240);
args14 VARCHAR (240);
args15 VARCHAR (240);
args16 VARCHAR (240);
args17 VARCHAR (240);
args18 VARCHAR (240);
args19 VARCHAR (240);
args20 VARCHAR (240);
l_session_id NUMBER;
l_count NUMBER;
cutoff_date_j NUMBER;
l_total_temp VARCHAR2 (30);
l_avail_qty_temp VARCHAR2 (30);

CURSOR c1
IS
SELECT inventory_item_id
FROM mtl_system_items_b
WHERE organization_id = 204 AND segment1 IN ('AS18947', 'AS81414');
BEGIN
fnd_global.apps_initialize (1072, 50346, 401);
--fnd_profile.put ('CONC_DEBUG', 'TC');
/* fnd_global.initialize (session_id => l_session_id
, user_id => 1072
, resp_id => 50346
, resp_appl_id => 401
, security_group_id => 0
, site_id => 0
, login_id => 1833382
, conc_login_id => -1
, prog_appl_id => 401
, conc_program_id => 33808
, conc_request_id => fnd_global.conc_request_id
, conc_priority_request => -1
, form_id => 52654
, form_appl_id => 401
, conc_process_id => NULL
, conc_queue_id => NULL
, queue_appl_id => NULL
, server_id => 147
);*/
inv_globals.set_org_id (204);

SELECT mtl_demand_interface_s.NEXTVAL
INTO l_seq_num
FROM DUAL;

SELECT TO_CHAR (SYSDATE, 'j')
INTO cutoff_date_j
FROM DUAL;

FOR i IN c1
LOOP
IF (inv_tm.launch ('INXDSD'
, 'GROUP_ID='
|| TO_CHAR (l_seq_num)
|| ' '
|| 'ORGANIZATION_ID='
|| TO_CHAR (204)
|| ' '
|| 'INVENTORY_ITEM_ID='
|| TO_CHAR (i.inventory_item_id)
|| ' '
|| 'ONHAND_SOURCE='
|| TO_CHAR (1) --1 ATP Only, 2 For Net Subinventories, 3 all subinvs
|| ' '
|| 'CUTOFF_DATE="'
|| TO_CHAR (cutoff_date_j)
|| '" '
|| 'MRP_STATUS='
|| TO_CHAR (1)
|| ' '
|| 'ONHAND_FIELD=l_total_temp'
|| 'AVAIL_FIELD=l_avail_qty_temp'
, l_total_temp
, l_avail_qty_temp
) = FALSE
)
THEN
DBMS_OUTPUT.put_line ('FAILED');
ELSE
DBMS_OUTPUT.put_line ('SUCCESS');
DBMS_OUTPUT.put_line (l_total_temp);
DBMS_OUTPUT.put_line (l_avail_qty_temp);

INSERT INTO xx_mtl_supply_demand_temp
SELECT *
FROM mtl_supply_demand_temp
WHERE seq_num = 0;
END IF;
END LOOP;

-- fnd_profile.put ('CONC_DEBUG', NULL);
BEGIN
DELETE FROM mtl_atp_rules
WHERE rule_id IN (SELECT atp_rule_id
FROM mtl_group_atps_view
WHERE atp_group_id = 0);
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;

BEGIN
DELETE mtl_group_atps_view
WHERE atp_group_id = 0;
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;

BEGIN
DELETE mtl_supply_demand_temp
WHERE seq_num = 0;
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;

inv_utilities.do_sql ('commit');END;

As you can see I have to use seq_num as zero it was always populating as zero in this table where as from form it populates correctly.

Since this is a function, probably you can use this in discoverer queuries (I am not sure). Then query this custom table (mirror of mtl_supply_demand_temp) to show the report.

Tuesday, December 14, 2010

Bhargavi's Milestones


Craig Elementary 12 Aug 2015

Upper Front Incisor 14 Jul 2015

Upper Front Incisor 28 Jun 2015

Lower Front Incisor  7-Oct-2014

Lower Front Incisor  21-Sep-2014

Grace Christian Academy  Jun 2014

Parkway Preschool   Aug 2013

Zion Preschool   May 2012

Reached US - 16th Apr 2012

1st Complaint @ Play School - 30-Nov-2011 ( bday ) - Slapped Vedant

Play School - 13-Jun-2011 ( bday )

Walking w/o support - 13-Dec-2010 ( bday )

Walking with support - 18-Nov-2010

Standing Up with Support - 13-Nov-2010 ( bday )

Crawling - 8-Aug-2010

Sitting - 6-Aug-2010

Turning Over - 29 Mar 2010

Welcome - 13 Jan 2010

How to Run-In your new car

http://www.team-bhp.com/web/index.php?categoryid=13&p2_articleid=25

Although this is a controversial topic, we stand by the opinions of the manufacturers – after all, who knows your engine better than the company that made it? There are good reasons most manufacturers ask you to take it easy during the initial running period. Call us conservative, but we recommend the tried and tested method. The moving parts of your new engine need an adjustment period before reaching normal operating conditions, and these conditions are determined by how the engine has been run-in. The run-in involves settling the piston rings and ensuring that the bearings and cylinders wear evenly, but it’s not only the engine that needs a running-in. The transmission, tyres and brakes all benefit from it too.

• We recommend that you warm up the engine before putting it under any load.

• A 2,500 km running-in period is ideal. After this, you can high-rev her away to glory.

• For a petrol engine do not allow the RPMs to go over 2,500 for the first 1,000 km. After that, you can increase the limit to 3,000 RPMs until 1,500 km and then gradually increase it to the maximum by 2,500 km.

• Long highway trips or time spent in bumper-to-bumper traffic is bad for the run-in process. The key to the run-in is to subject the engine to a wide range of RPMs, so you will probably have to alter your driving style and make a point of driving under various conditions.

• Team-BHP recommends that you change your engine oil after the first 1,000 km. As with all new engines, you will find that some metal slivers have found their way into the oil. From this point onward you can stick to the manufacturer recommended intervals.

• Do not use synthetic oil for the first 10,000 km. The impressive lubrication properties of synthetic oil only slow the run-in process.

By following these simple steps you can help ensure that your engine reaches its maximum performance and endurance condition. This will maximize you car’s power, fuel economy and engine life. Many new cars are designed to minimize damage from a poor running-in, but even these engines benefit from the advantages of a proper run-in regime.

Saturday, November 6, 2010

http://money.outlookindia.com/article.aspx?87530

Should borrowing be only a last-resort option to raise money?


AMONG THE many questions that clients raise with a tax consultant, one of the most common is: "I need funds for such and such purpose. Given the fact that loans are available, should I borrow or would it be better to encash my investments and raise the money?" Tough decision on the face of it, but one that can easily be taken if one carefully assesses various qualitative and quantitative factors.
Among the qualitative factors, one would look at liquidity, the possibility of reinstating the investment out of future income, restrictive conditions attached to the borrowing and such like. But, of course, the crucial deciding factor will be the quantitative aspect, that is, the loss of post-tax returns from the investment and the post-tax cost of borrowing.


If the post-tax cost of borrowing is higher than the loss of post-tax returns from the investment, it’s better to disinvest your holdings, rather than borrow. If, on the other hand, the post-tax returns from the investment are higher than the post-tax cost of borrowing, it’s a better option to take a loan, than encash your investments.

Post-tax edge. So how does one compute the post-tax rate of returns and post-tax cost of borrowing? In computing the post-tax rate of returns or the cost of borrowing, one has to first compute the annualised rate of return or the cost of borrowing, and then adjust it for tax payments or savings.

To understand this better, let us consider a simple computation in a situation where an individual wants to buy a residential house for Rs 15 lakh. Let’s say he has Rs 5 lakh in hand, Public Provident Fund (PPF) investments that he can withdraw to the extent of Rs 10 lakh and company deposits of Rs 10 lakh that yield 11 per cent per annum compounded quarterly.

So, he has three options.
Option I: he can withdraw Rs 10 lakh from his PPF account.
Option II: he can break his company deposits, but in doing so, he will incur a penalty of 1 percentage point for premature encashment.
And Option III: he can take a home loan from a housing finance company at the rate of 11.5 per cent per annum (payable in equated monthly instalments with monthly reductions in the principal amount).

In the last case, he will have to pay a processing fee of 2 per cent of the amount of the loan.

Option I. In the case of the Public Provident Fund, after the recent reduction in interest rates on small savings, it will yield a return of 9 per cent per annum. Since this interest is paid annually, and there is no charge for withdrawals, the effective rate of return is equal to the coupon rate. Besides, since this interest payment is not taxable, this will be the post-tax rate of return as well.

Option II. At a rate of 11 per cent per annum compounded quarterly (2.75 per cent per quarter), the effective yield is 11.46 per cent. Since we are computing the loss of post-tax interest that arises due to disinvestment, we will also have to factor in the penalty for premature encashment.

The real rate of interest that has been lost due to premature encashment will, therefore, have to be computed by deducting the percentage of the penalty from 100, and dividing the annualised rate of return by this figure. In this case, by dividing 11.46 by 99 (100-1), the adjusted annualised rate of interest will be 11.58 per cent. Since this interest would have been taxable, and as the premature payment penalty would also be tax-deductible, this rate of interest will have to be discounted by 31.5 per cent (30 per cent plus surcharge of 5 per cent, which is the marginal tax rate applicable to the house buyer). Thus, the post-tax loss of interest would be 7.93 per cent.

Option III. In the case of the home loan, by compounding the monthly interest payable, the annualised rate of interest works out to 12.13 per cent. If we factor in the processing charge, we can deduct the charge of 2 per cent from the total loan amount (that, 100 per cent) to arrive at a net borrowing of 98 per cent. The adjusted annualised rate of interest thus works out to 12.37 per cent.

Since interest paid on housing loans is tax-deductible, this payment needs to be discounted by 31.5 per cent, giving us a cost of 8.48 per cent. The rebate available on the repayment of the principal amount of the housing loan will also need to be factored in. Since the rebate is available at the rate of 20 per cent to the extent of repayments of Rs 20,000 each year, and the rebate is to be computed before surcharge, the effective tax saving would be Rs 4,200 each year. On an average outstanding loan of Rs 5 lakh, the effective percentage of rebate works out to about 0.84 per cent. Thus, the post-tax cost of the housing loan from the finance company will be about 7.64 per cent (8.48 per cent minus 0.84 per cent).

What’s beneficial? Comparing the options we find that the post-tax cost of the loan is lower than the post-tax loss of interest in the case of the company deposits or PPF. And so, an individual will be better off taking a home loan to buy a house, rather than encashing either the PPF or the company deposits. If, however, the individual does opt to encash some investments, the company deposits are a better option than the PPF, since the loss of interest is of a lesser magnitude.

In the case that we have taken up, since the loan was being taken to buy a residential house, the interest was tax-deductible. Therefore, before you take a loan it makes sense to take a look at how you are going to utilise the borrowing and whether the interest is deductible for tax purposes. There may be many instances where interest will not be deductible for tax purposes. In such cases, the effective cost of the borrowing is generally far more than the rate of return that one could earn on most investments, and borrowings may, therefore, not be cost-effective.

The computation in the case we have looked at assumes that the eligible deductions on interest repayments and rebates on principal will continue to be available, and that the rates of interest will remain unchanged. In real-life situations, you will need to consider the prevailing tax laws and rates of interest to arrive at your best-case scenarios.

Of course, one can always use other similar methods of computation to compare the merits of various investments. Although other methods such as internal rate of return or net present value of cash flows are often superior decision-making tools, this method offers a simple and quick comparison for a person who is not a finance professional.

Thursday, September 9, 2010

Misc Transaction

INSERT
INTO mtl_transactions_interface(
transaction_interface_id
, Source_code
, source_header_id
, source_line_id
, process_flag
, transaction_mode
, item_segment1
, inventory_item_id
, organization_id
, distribution_account_id
, subinventory_code
, transaction_uom
, transaction_date
, transaction_type_id
, transaction_quantity
, creation_date
, created_by
, last_update_date
, last_updated_by
)
SELECT MTL_MATERIAL_TRANSACTIONS_S.nexval transaction_interface_id
, 'Costing/Non-costing adjustment' Source_code
, 199 source_header_id
, 199 source_line_id
, -9 process_flag
, 3 transaction_mode
, msi.segment1 item_segment1
, msi.inventory_item_id inventory_item_id
--, ood.organization_code
, ood.organization_id
, DECODE(ood.set_of_books_id,1,50066,NULL) distribution_account_id
, moq.subinventory_code
, moq.transaction_uom_code transaction_uom
, TRUNC(SYSDATE) transaction_date
, 32 transaction_type_id -- issue 42--receipt
, SUM(moq.transaction_quantity) transaction_quantity
, SYSDATE
, 17879
, SYSDATE
, 17879
FROM mtl_system_items msi
, mtl_onhand_quantities_detail moq
, org_organization_definitions ood
WHERE msi.organization_id = 2
AND moq.inventory_item_id = msi.inventory_item_id
AND ood.organization_id = moq.organization_id
AND msi.segment1 IN ('TSTITM')
GROUP BY msi.segment1
, msi.inventory_item_id
--, ood.organization_code
, ood.organization_id
, ood.set_of_books_id
, moq.subinventory_code
, moq.transaction_uom_code

Wednesday, September 8, 2010

User Responsibility

SELECT DISTINCT u.user_name, wur.role_orig_system_id responsibility_id
, wura.start_date, wura.end_date end_date, wura.created_by created_by
, wura.creation_date creation_date, wura.last_updated_by last_updated_by
, wura.last_update_date last_update_date
, wura.last_update_login last_update_login
, wura.assignment_reason description
, res.responsibility_name
FROM fnd_user u
, wf_user_role_assignments wura
, wf_all_user_roles wur
, fnd_responsibility_tl res
WHERE u.user_name = wura.user_name
AND wura.relationship_id = -1
AND wur.role_orig_system = 'FND_RESP'
AND NOT wura.role_name LIKE 'FND_RESP|%|ANY'
AND wura.role_name = wur.role_name
AND wura.user_name = wur.user_name
AND res.responsibility_id = wur.role_orig_system_id
AND u.user_id = 17879
--AND wur.role_orig_system_id IN ( 53721, 53741 )

Request Set Details

SELECT rs.request_set_name
, rs.user_request_set_name
, rss.stage_name
, rss.user_stage_name
, rss.display_sequence
, rss.success_link_name
, rss.warning_link_name
, c.concurrent_program_name
, c.user_concurrent_program_name
, e.executable_name
, e.execution_method_code
, e.execution_file_name
FROM fnd_concurrent_programs_vl c
, fnd_executables e
, fnd_request_set_programs rsp
, fnd_req_set_stages_form_v rss
, fnd_request_sets_vl rs
WHERE c.executable_id = e.executable_id
AND rsp.concurrent_program_id = c.concurrent_program_id
AND rsp.request_set_id=rs.request_set_id
AND rsp.request_set_stage_id=rss.request_set_stage_id
AND rss.request_set_id=rs.request_set_id
AND rs.request_set_name = 'FNDRSSUB1128'
ORDER BY rss.display_sequence

Monday, August 30, 2010

ADD Responsibility

fnd_user_resp_groups_api.insert_assignment(
user_id => 17879,
responsibility_id => 51661,
responsibility_application_id => 660,
security_group_id => 0,
start_date => SYSDATE,
end_date => NULL,
description => 'Order Management Super User')

VAASTU - Living room

http://www.amitlamba.com/vastu-mumbai-free-tips-home-apartment.html
http://www.gharexpert.com/articles/Drawing-Room-1058/Vastu-Living-Room_0.aspx
http://www.vastushastraguru.com/vastu-remedies-north-east-kitchen/



According to Vastu Shastra living room or drawing room should be located in east or north direction. The ideal location of a living room depends on plot facing. The living room can be in northeast direction for east and north facing house. The living room can be in northwest for west facing house. In south facing house, living room can be in southeast.

Where to Place Furniture as per Vastu
The furniture should be placed in west or south direction. The furniture such as showcase or heavy articles etc. should be in south or west direction. It should be rectangular or square, not in oval, circular or odd shape.

Television, A.C and Telephone Place according to Vastu

T.V. should be placed in southeast direction. Living room vastu opposes to place T.V. in north-east or south-west corner.
Cooler or A.C should be placed in west or north direction. Avoid A.C or Cooler in southeast and northwest. Telephone should be placed in East, North or south-east. It should not be in south-west or the north-west corners.

Aquarium Placement as per Vastu Directions

Aquariums are beneficial to place in the North, East and North-East of living room. The faults related to north-west corner can be corrected by putting an aquarium. Avoid aquarium in south direction as it draws out positive energies from house.

Painting and Pictures according to Vastu

The use of painting can create a pleasant environment in the room. Painting of waterfall, rising sun provides positive energy. Avoid paintings that symbolize death, violence and negative aspects of life.

Vastu Color Scheme

The color of wall in living room should be white, yellow, blue or green. Prefer light color over dark colors. Avoid black and red color in living room.

Vastu and Lighting

Lighting of living room should be bright. If chandelier is in living room, it should be slightly towards west, not at the centre of the room.

Vastu for Doors and Windows

The door of living room should be in east or north direction because doors are very auspicious in these directions. There should not be a photograph of any God in living room or at entrance door. Windows in east and north are beneficial.

Vastu Tips for Living Room

The East and North are best directions for living room.
The furniture should be square or rectangular.
Air-conditioner or cooler should be placed in West direction, not in South-east.
Portraits of women, animals, birds, scene of war should never be displayed in living room.
The sitting arrangement for the head of family should be in East or North direction.
A painting showing depression should not be placed on a wall. 

Friday, July 30, 2010

LFS ( Local Fish shops)

DADAR

Fish Fantacy (yes, with a 'c' and not an 's')
Prem Kamal, Gokhale Road,
North, Dadar. It's situated about 200m after the Portuguese Church traffic light.
Prop. Vinod Khade 9869524302

Grep SED

The grep -il statement finds all instances of Hello in files ending in txt (i = ignore case, , l = only list the filename). The file names are passed to sed, which runs a regular expression to change all instances of Hello to Goodbye. Since sed doesn't overwrite a file, I redirected the output to a temp file and then renamed it back to the original file name.

#!/bin/sh

for file in $(grep -il "Hello" *.txt)
do
sed -e "s/Hello/Goodbye/ig" $file > /tmp/tempfile.tmp
mv /tmp/tempfile.tmp $file
done

Monday, July 26, 2010

Concurrent Program Responsiblity

SELECT DISTINCT
FCPL.USER_CONCURRENT_PROGRAM_NAME
, FCP.CONCURRENT_PROGRAM_NAME
, FAPP.APPLICATION_NAME
, FRG.REQUEST_GROUP_NAME
, FNRTL.RESPONSIBILITY_NAME
FROM APPS.FND_REQUEST_GROUPS FRG
, APPS.FND_APPLICATION_TL FAPP
, APPS.FND_REQUEST_GROUP_UNITS FRGU
, APPS.FND_CONCURRENT_PROGRAMS FCP
, APPS.FND_CONCURRENT_PROGRAMS_TL FCPL
, APPS.FND_RESPONSIBILITY FNR
, APPS.FND_RESPONSIBILITY_TL FNRTL
WHERE
FRG.APPLICATION_ID =FAPP.APPLICATION_ID
AND FRG.APPLICATION_ID = FRGU.APPLICATION_ID
AND FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
AND FRG.REQUEST_GROUP_ID = FNR.REQUEST_GROUP_ID
AND FRG.APPLICATION_ID = FNR.APPLICATION_ID
AND FNR.RESPONSIBILITY_ID = FNRTL.RESPONSIBILITY_ID
AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID
AND FRGU.UNIT_APPLICATION_ID = FCP.APPLICATION_ID
AND FCP.CONCURRENT_PROGRAM_ID = FCPL.CONCURRENT_PROGRAM_ID
AND FCPL.CONCURRENT_PROGRAM_id = 54866
AND FNRTL.LANGUAGE = 'US'
AND FAPP.LANGUAGE = 'US'

Tuesday, May 18, 2010

fastest fishless cycle

fastest fishless cycle

Please note: Fishless cycling is the ONLY way a tank should be prepared for fish.

PWC Partial Water changes

The purpose of cycling is to build up the beneficial bacteria in a tank that
feed off the waste materials of your fish/inverts.
Without these present in great enough numbers, your fish will kill themselves with their own waste.
By building up these bacteria prior to adding in fish, you avoid harming your fish.
Unlike traditional cycling where a small amount of hearty fish are introduced into a tank,
and slowly additional fish are added,
fishless cycling (when properly performed) allows for a complete stocking of the tank at once.
This is a huge benefit, and one which is often overlooked.


The 2 types of bacteria we are looking to grow convert ammonia (fish waste which is quite toxic)
to nitrIte (actually more toxic than ammonia but not as long term damaging),
and finally to nitrAte (relatively non-toxic unless allowed to build up to large amounts).
So that's:
ammonia---->nitrIte--->nitrAte

The first conversion to nitrIte occurs faster than the second conversion to nitrAte.
Once the cycle is completed PWC's are required to keep the nitrAte level acceptable (general consensus is <40ppm) unless plants are present.

-Setup the tank, put all filters/heaters/decorations/etc in place.
Fill your tank up with tap water. DO NOT USE A DECHLORINATOR AT THIS TIME!

-Turn everything on and make sure it all works.
Better to find out now that the heater is broken, then 2 weeks into the cycle when nothing is happening

-Let the tank run for 30 minutes or so and check for leaks/malfunctions

-Now add in your dechlorinator (I prefer Prime).
Waiting to use a dechlorinator essentially sterilizes your tank from any contaminants
(especially if you have chloramines in your tap water).

-Purchase a good liquid reagent test kit that tests ammonia, nitrIte, nitrAte, pH, etc.
A lot of us on here use the Aquarium Pharmaceuticals FreshWater Master Test Kit (AP test kit for short).

-Now you need an ammonia source! Many fishkeeper's forget this step and without food, the bacteria will not multiply.
Pure ammonia is the easiest and best way to do a fishless cycle however,
you can use fish food or a raw shrimp but measurements will not be as accurate.
You need to find pure ammonia that does not contain any additives such as detergents or scents.

-With the ammonia purchased, and your test kit handy, dose the tank to ~5ppm ammonia.
If you add too much, do a Partial water change to reduce the level, if you add too little, dose more.
It doesn't need to be exact, but just aim for 3-5ppm.
Every couple of days test the ammonia level, when it gets below 1ppm, add more ammonia to keep the level above 1ppm.
Normally when I see it get below 1ppm, I dose 3-4ppm back in.
Never let it go to zero (until the cycle is finished) or you risk killing off your ammonia to nitrIte bacteria!


-Turn your heater up! Aim for 85-87F.
This increased temperature speeds up the metabolism of the bacteria which reduces the cycle time.


-Turn on any bubble wands, lower the water an inch or two if using HOB filters, turn on any PH's you might have.
Increasing agitation increases the dissolved O2 levels which bacteria like/want/need.

-Buy/borrow a small bottle of pH down. Add 1-2 drops per 4 gallons of tank water.
These pH products contain large amounts of phosphates which your bacteria need to grow.
This small amount will not affect the pH of the tank and will supply all the phosphate needed.
Lots of "my cycle stopped/stalled" posts can be attributed to phosphate deficiency.
A small amount of fishfood can probably also be substituted in place of this.


-Add in a VERY small amount of flake fish food.
When I mean small I mean microscopic!
About the size of a grain or 2 of rice.
Pulverize it into a very fine powder and add it in.
This will take care of any trace elements required by the bacteria and probably the phosphate requirement as well.



-Now its time to seed the tank!
This is the single most important step in the entire cycle.
The more seed material you can procure, the faster the cycle will go.
Seed material is anything you can take from an established tank.
Filter media (sponges/floss/ceramic media) is the #1 best.
This stuff is FULL of bacteria and exactly what you want.
Next up would be substrate (sand/gravel).
And last but not least would be decorations/ornaments.
Do you have a friend with a gaudy/hideous pink castle that's been in his goldfish tank for 3 years?
Beg/plead/steal it from him/her for a couple of weeks.
But make sure you keep anything wet in the tank water until
you can add it to your tank If it dries out in transit, the bacteria's dead!


With your tank setup and seed material you now want to maximize colonization of the surfaces.
If you are given a piece of filter media squish it in the tank water first.
This will cloud the tank with bacteria laden particles.
These will fly all over the tank and "seed" the surfaces with bacteria.
Then put the filter material in your filter.
It doesn't matter if it's not made to fit, find a way to get it in there.
HOB and canister filters normally allow for several compartments, make one of them the seed filter material.
Place it at the FRONT of the filtering.
By that I mean put the seed material as the first thing the water hits when entering the filter.
This will cause any bacteria that is released from the seed material to contact the new filter first, which is where you want the bacteria to be.


If you are given substrate (and don't mind it in the tank) spread it out all over the bottom.
This maximizes surface area and will allow the most contact with the bacteria and food source.



If the substrate is something you don't want in the tank after the cycle put it in the foot of a new UNWASHED piece of pantyhose.
Rinse the pantyhose under tap water but make sure it never went in the wash.
Detergents/fabric softener will kill your tank!
Squish the substrate around every day or two.
You'll notice it will cloud the tank.
This is a good thing as bacteria is being released into the water.
This is how I cycled my 20 gallon.
I did not have filter media, only a small amount of gravel from an established tank.
I put 1/2 the gravel in a filter insert in my HOB, and the rest in some pantyhose (since I had PFS and didn't want the gravel).
A couple of weeks after the cycle finished I removed the seed gravel (you don't want to remove it too soon or you may cause a minicycle).



Now for a note about bacteria.
They are surface adherers.
That is, very little of the bacteria is present in the water itself, the majority is attached to the surfaces in the tank.
This means that a PWC during the cycle is not necessarily a bad thing.
It's normally not needed, but if it is for some reason (say you overdose on the ammonia), don't fret!


A quick word on pH.
Ideally you want the pH of the tank to be ~7.5.
The ammonia to nitrIte bacteria prefer a higher pH (closer to 8.0), while the nitrIte to nitrAte bacteria prefer a lower pH (closer to 7.3).
Go too high and your nitrItes will build up, go too low and your ammonia won't get converted.
If you have a pH crash (either too high or too low, say pH 6.0 or pH 9.0) you have to do a PWC.
At these ranges your bacteria will seriously begin to slow down metabolism.


Keep the tank lights off and direct/indirect sunlight to a minimum.
This time in the tank is RIPE for algae outbreaks.
High ammonia levels, steady CO2 levels (from high aeration), and possible light can cause your tank to look like pea soup.
The bacteria do NOT require a light source, and in fact, direct sunlight can cause the bacteria to multiply slower.
Bottom line, keep it dark!


So now you have the perfect temperature, a steady food source with trace elements in abundence, good oxygen levels, your all set!


When you see your ammonia level drop to below 1ppm, increase it back up to 3-5ppm.
You will most likely build up a LARGE amount of nitrIte because the bacteria that convert nitrIte to nitrAte were at a disadvantage waiting for their food (nitrIte).
I've often thought of creating a product of pure nitrIte for cycling.
That way you can dose both ammonia and nitrIte at the beginning which would speed up the entire cycle.
Now don't go and steal my idea!



Watch your nitrAte levels.
When they start to rise wait about 5-7days and, if your nitrIte levels are really high (>10ppm),
I'd recommend a large PWC to bring the number down into a readable range.
This will not affect the cycle, and will keep you sane as you can watch the levels vary.
You might see the levels continue to go up as you will still have more ammonia converting bacteria,
but if you watch the nitrAtes you'll know your heading in the right direction. Several members on here have really been done the cycle,
but because there was so much nitrIte in the tank they didn't know it! (hint I was one of them....)

Once you can convert 1-2ppm ammonia completely to nitrAte in 24hours or less you can do a large (or several)
large PWC's to get the nitrAtes below 40ppm (<20ppm preferably).
Now decrease the tank temperature to 78-82F if housing tropicals, otherwise whatever temperature you need.
Make sure the temp is stable before addition of fish.

Now your all set to fully or near fully stock your tank!

XML from QUERY Directky

SELECT DBMS_XMLGEN.getxml(
'SELECT CURSOR(SELECT oha.order_number,
ola.ordered_item,
ola.ordered_quantity
FROM ont.oe_order_headers_all oha,
ont.oe_order_lines_all ola
WHERE oha.header_id = ola.header_id
and oha.order_number in (&order_number) order by ola.line_id) as order_detail,
CURSOR(SELECT ohd.name, ohs.hold_comment
FROM ont.oe_hold_sources_all ohs,
ont.oe_order_holds_all ohld,
ont.oe_hold_definitions ohd,
ont.oe_order_headers_all oha,
ont.oe_order_lines_all ola
WHERE oha.header_id = ola.header_id
AND ola.line_id = ohld.line_id
and ohld.hold_release_id is null
AND ohld.hold_source_id = ohs.hold_source_id
AND ohs.hold_id = ohd.hold_id
AND oha.order_number = &&order_number) as holds_detail
FROM DUAL')
FROM DUAL

Link between AR and OM

SELECT ooha.order_number
, oola.line_number so_line_number
, oola.ordered_item
, oola.ordered_quantity * oola.unit_selling_price so_extended_price
, rcta.trx_number invoice_number
, rcta.trx_date
, rctla.line_number inv_line_number
, rctla.unit_selling_price inv_unit_selling_price
FROM oe_order_headers_all ooha
, oe_order_lines_all oola
, ra_customer_trx_all rcta
, ra_customer_trx_lines_all rctla
WHERE ooha.header_id = oola.header_id
AND rcta.customer_trx_id = rctla.customer_trx_id
AND rctla.interface_line_attribute6 = TO_CHAR (oola.line_id)
AND rctla.interface_line_attribute1 = TO_CHAR (ooha.order_number)
AND order_number = :p_order_number

Unix concurrent Program

In Shell Script, $1 is the variable that stores following information
- Concurrent Program Short Name
- Request ID
- Login Information(APPS username and password)
- User Id
- User Name
- Printer Name
- Save output Flag
- Print number of Copies
- List of concurrent program parameters



requestid=`(echo $1 | cut -f2 -d' ' | cut -f2 -d= | tr -d '"' )` #request_id
login_usr_pwd=`(echo $1 | cut -f3 -d' ' | cut -f2 -d= | tr -d '"' )` #database username/password
conc_user_id=`(echo $1 | cut -f4 -d' ' | cut -f2 -d= | tr -d '"' | cut -c1-8)` #userid
conc_user_name=`(echo $1 | cut -f5 -d' ' | cut -f2 -d= | tr -d '"' | cut -c1-8)` #username
prog_param1=`(echo $1 | cut -f9 -d' ' | tr -d '"' )` #parameter 1
prog_param2=`(echo $1 | cut -f10 -d' ' | tr -d '"' )` #parameter 2
prog_param3=`(echo $1 | cut -f11 -d' ' | tr -d '"' )` #parameter 3
prog_param4=`(echo $1 | cut -f12 -d' ' | tr -d '"' )` #parameter 4
prog_param5=`(echo $1 | cut -f13 -d' ' | tr -d '"' )` #parameter 5
prog_param6=`(echo $1 | cut -f14 -d' ' | tr -d '"' )` #parameter 6

Wednesday, May 12, 2010

Good Links

http://oracleworld.wordpress.com/2008/12/18/after-running-create-internal-sales-order-pociso-how-to-determine-whether-the-sales-order-information-was-sent-to-order-entry/

http://www.oracleappshub.com/category/edi/

http://knoworacle.wordpress.com/2009/06/12/interview-questions-for-oracle-11i-apps-manufacturing/

Tuesday, May 11, 2010

TANK LOAD PLAN

http://www.thetropicalfishtank.com/tropical-fish-information/the-unusual-tropical-betta-fish/
3 x Albino Cory (Corydoras aeneus)
6 x Zebra Danio (Danio rerio)
3 x Guppy (Poecilia reticulata)
5 x Ghost Shrimp (Palaemonetes sp.)
5 x Neon Tetra (Paracheirodon innesi)
Tank (LxDxH): 24 x 12 x 12 inch (15.0gUS)
Filters: Aqua One Aquis 500
• Suggestion: If you want to keep more than 1 Guppy, minimum recommend male to female ratio is 1:2 (M:F). You will be less likely to experience problem if you get even more females.
• Warning: At least 4 x Albino Cory are recommended in a group.

Recommended temperature range: 22 - 24 C. [Display in Farenheit]
Recommended pH range: 6 - 7.5.
Recommended hardness range: 5 - 15 dH.


Warning: You should add more aquarium filtration capacity.

Your aquarium filtration capacity for above selected species is 94%.
Recommended water change schedule: 43% per week.
Your aquarium stocking level is 105%.

On Hand API

FUNCTION get_onhand_qty (
p_inventory_item_id NUMBER,
p_org_id NUMBER,
p_subinventory_code VARCHAR2
)
RETURN NUMBER
IS
v_api_version_number NUMBER := 1.0 ;
v_init_msg_lst VARCHAR2 (100);
v_return_status VARCHAR2 (100);
v_msg_count NUMBER;
v_msg_data VARCHAR2 (2000);
v_organization_id NUMBER;
v_inventory_item_id NUMBER;
v_tree_mode INTEGER:=inv_quantity_tree_pub.g_transaction_mode;
v_is_revision_control BOOLEAN default false;
v_is_lot_control BOOLEAN default false;
v_is_serial_control BOOLEAN default false;
v_demand_source_type_id NUMBER;
v_demand_source_header_id NUMBER;
v_demand_source_line_id NUMBER;
v_demand_source_name VARCHAR2 (500);
v_lot_expiration_date DATE;
v_revision VARCHAR2 (100):=null;
v_lot_number VARCHAR2 (100):=null;
v_subinventory_code VARCHAR2 (100);
v_locator_id NUMBER:=null;
v_onhand_source NUMBER:= inv_quantity_tree_pvt.g_all_subs;
v_qoh NUMBER;
v_rqoh NUMBER;
v_qr NUMBER;
v_qs NUMBER;
v_att NUMBER;
v_atr NUMBER;
v_transfer_subinventory_code VARCHAR2 (100);
v_cost_group_id NUMBER;
v_lpn_id NUMBER;
v_transfer_locator_id NUMBER;
v_onhand_qty NUMBER;
BEGIN
setdebug('Calling inv_quantity_tree_pub.query_quantities Procedure..'
);
fnd_client_info.set_org_context (2);
inv_quantity_tree_pub.query_quantities
( p_api_version_number=> v_api_version_number
, p_init_msg_lst => v_init_msg_lst
, x_return_status => v_return_status
, x_msg_count => v_msg_count
, x_msg_data => v_msg_data
, p_organization_id => p_org_id
, p_inventory_item_id => p_inventory_item_id
, p_tree_mode => v_tree_mode
, p_is_revision_control => v_is_revision_control
, p_is_lot_control => v_is_lot_control
, p_is_serial_control => v_is_serial_control
--, p_demand_source_type_id => v_demand_source_type_id
--, p_demand_source_header_id => v_demand_source_header_id
--, p_demand_source_line_id => v_demand_source_line_id
--, p_demand_source_name => v_demand_source_name
--, p_lot_expiration_date => v_lot_expiration_date
, p_revision => v_revision
, p_lot_number => v_lot_number
, p_subinventory_code => p_subinventory_code
, p_locator_id => v_locator_id
, p_onhand_source => v_onhand_source
, x_qoh => v_qoh
, x_rqoh => v_rqoh
, x_qr => v_qr
, x_qs => v_qs
, x_att => v_att
, x_atr => v_atr
--, p_transfer_subinventory_code => v_transfer_subinventory_code
--, p_cost_group_id => v_cost_group_id
--, p_lpn_id => v_lpn_id
--, p_transfer_locator_id => v_transfer_locator_id
);

IF x_msg_count > 0
      THEN
         FOR v_index IN 1 .. x_msg_count
         LOOP
            fnd_msg_pub.get (p_msg_index => v_index, p_encoded => 'F', p_data => x_msg_data, p_msg_index_out => v_msg_index_out);
            DBMS_OUTPUT.put_line (x_msg_data);
            END LOOP;
end if;

v_onhand_qty := v_atr;
Return v_onhand_qty;
EXCEPTION
WHEN OTHERS
THEN
setdebug('Error in get_onhand_qty Function '
|| SUBSTR (SQLERRM, 1, 50)
);
RETURN NULL;
END get_onhand_qty;

Friday, May 7, 2010

FILTERS

The only filters that you really need to produce professional-level images are a warming filter, polarizing filter, and a graduated neutral density filter.

Warming EffectThe filter that I use the most, by far, is the warming filter. It is used primarily in overcast light or in shade to remove the inherent blue or cold light from such scenes. As a result, an amber or warm tonality is added to the scene

Polarizing Filter Effect
Polarizing filters are used primarily to remove glare and can darken a blue sky if used at approximately a 90Þ angle. Here’s the shot on film without a polarizing filter. Notice how flat it is. The colors are actually very vibrant, but the glare is masking, or absorbing,
the color

A polarizer is almost never appropriate for portraiture.

Split Graduated Neutral Density
These filters are amazing in that they make images that are otherwise impossible to capture. These filters lower the contrast range by masking the highlights thus rendering detail in very dark and very bright areas, rather than blowing out the highlights or blackening shadows. The following examples are illustrative of using graduated neutral density filters


UV Filter
The "traditional" visible spectrum runs from red to violet. Red light has the longest wavelength and violet the shortest. Light which has a longer wavelength than red is called infrared, and light which has a shorter wavelength than violet is called ultra violet or UV.

There are basically three color sensitive layers, one sensitive to red light, one to green light and one to blue light. The blue layer not only responds to blue light, but also to UV light, so if there is a lot of UV around the blue sensitive layer gets extra exposure and the final image takes on a blue color.

three filters often used in place of a UV filter (i.e. filters which some photographers keep on the lens at all times as protection). These are the Hoya 81B, the Tiffen 812 and the B+W KR1.5. All three are warming filters in that they shift the color balance towards the red (warm) end of the tonal range.
As you can see all three of the warming filters were effective UV absorbers, as well as slight absorbers in the blue and green regions of the spectrum (which is what makes them warming filters). The polarizer absorbed slightly more in the UV than the visible, though I wouldn't call it an effective UV absorber.

Tiffen 812 . It blocks UV, it protects the lens and it's a warming filter. Some people use an 81B for this, but I slightly prefer the color shift of the 812. Not everyone wants a warming filter, so the clear winner for a neutral filter that really bocks UV is the Tiffen Haze-1, though the Hoya UV should also be pretty effective.

Wednesday, May 5, 2010

CERTIFICATION

Wish List

PMI
APICS CSCP Exam

Wednesday, April 28, 2010

HISTOGRAMS

http://luminous-landscape.com/tutorials/understanding-series/understanding-histograms.shtml

http://www.slrnikond50blog.com/
You can use the histogram to check if the exposure was correct.
When you review a picture and pull up the histogram, you’ll usually see a pattern that resembles a bell curve. If that curve is squished to the left of the screen, you’ve underexposed – a lot of shadow areas will be completely black. And if the curve is squished to the right of the screen, you’ve over-exposed – a lot of highlights are completely white.
If a portion of the histogram touches the top that means the highlights are blown out.

The common advice is to ‘expose to the right’. That means to expose the shot so that the curve is as far as possible to the right of the box, without actually blowing any highlights.


So take care to adjust the exposure so that the histogram doesn’t touch either of the sides or the top of the histogram doesn’t touch the top of the screen.


Here’s more on the reasoning behind that: http://luminous-landscape.com/tutorials/expose-right.shtml

BOREKH

http://www.daifukusensei.com/?page_id=52

Brenizer Method

Bokeh consists of the out-of-focus highlights seen in photographs. You know, those beautiful little balls of light that just seem to pop off the screen and make a picture look so much sexier? Here’s an example. So it follows that a bokehrama is a panorama — or a series of shots — of bokeh, lots of blur, and a single subject in focus. The best way to describe it is to showcase a terrific example, one from kick-butt wedding photog Ryan Brenizer, from whom I’ve learned this method:
http://www.flickr.com/photos/carpeicthus/3554480740/

Free substitute for Autostitch
http://hugin.sourceforge.net/

http://www.philmalpas.com/pages/artcomp.asp

Friday, April 23, 2010

FOCAL LEnght and Point and Shoot Zoom

The zoom factor like e.g. the 10X you mentioned above is simply the
longest focal lengt divided by the shortest focal length of that lens.
It could be 10mm-100mm or 20mm-200mm or 100mm-1000mm. All of those
lenses would be a 10x zoom.
The zoom factor does not tell you anyting about the magnification (or
tele) factor. That can be expressed in e.g. 8x, too. This is commonly
used in e.g. binoculars where 7x is a common marine magnification, 8x or
10x a common terrestial magnification, and 15x a strong glass for e.g.
bird viewing. For photography however it is much more common to use the
focal length. Problem is that the magnification not only depends on the
focal length but also on the sensor size.

On a full-frame sensor a focal length of 50mm is considered a 'normal
lens'. A 200mm lens would have a 4x magnification, a 1000mm lens a 20x
magnification.
For a DX sensors you have to adjust the magnification factor for the
smaller sensor size by a factor of 1.5 or 1.6, depending on the actual
camera.

Ok, going back to your original question: a 200mm lens on a DX body
(Canon EOS Digital Rebel XTI) will have a magnification(!) factor of
200/50*1.5 = 6x.
And it will have a zoom(!) factor of 1 because is is not a zoom lens to
begin with.

If it were e.g. a 50-200mm lens, then the magnification factor would be
1.5x - 6x and the zoom factor 4x on a DX body.
On a full frame camera this lens would have a magnification factor of
1x-4x and still the same zoom factor of 4x.

Oh, one more note: neither the camera nor the lens determines the image
size. The image size only depends on how you print it.

Wednesday, April 21, 2010

APERTURE

http://www.digital-slr-guide.com/maximum-aperture.html

1 – Natural Light Photos
No flash with a max aperture of f/2.8
A digital SLR camera sensor needs light to create an image.

There are two ways that it can get the light that it needs: it can keep the shutter open for a long period of time or open the aperture as wide as possible.

Let's say that you hate taking photos with flash, because you know how washed out they look.

You're indoors and your camera tells you that with your aperture set to f/4, your shutter speed will have to be 1/30 of a second. That's not going to be fast enough to take a shot of your child rampaging in the living room.

You're going to have to use the flash, or get the kid to sit VERY still.

If you had a lens with a maximum aperture of f/2.8 (which lets in double the amount of light of f/4) then you can use a shutter speed of 1/90, which means that you can get clear photos without the flash



2 – Fast Shutter SpeedsA fast shutter prevents motion blur
You're taking photos on an overcast day of a flower in the backyard. A strong breeze is blowing, and that flower is moving all over the place.

You set the aperture on your lens as wide as it can go (let's say f/5.6), and check the shutter speed. The camera tells you that you can use a shutter speed of 1/125 of a second.

That's not fast enough to get a clear photo of the flower. You're stuck.

If you had a lens with a wider maximum aperture you could get the shot. With a wider aperture (say f/2.8) your shutter speed could be 1/500 of a second.

Since the wide aperture lets in so much light, the shutter doesn't have to stay open as long.


3 – Reduced Depth of FieldWide aperture = shallow depth of field
Lenses with wide maximum apertures have shallow depth of field.

Without getting into a discussion on depth of field (that could take awhile), I will just refer to the photographic example at right.

This shot was taken with a lens set to f/3.2. Notice that the background is completely out of focus even though the ball in the foreground is clear?

This is shallow depth of field.

Nature and portrait photographers use this all the time to reduce the impact of a busy background.

If you have a lens with a maximum aperture of f/5.6, you can't reduce the depth of field as much as you can with a wider aperture.

Tuesday, April 20, 2010

CCD Cleaning

http://www.bythom.com/cleaning.htm

If you've got a D3s, D60, D90, D300, D300s, D700, or D5000, regularly use the built-in dust cleaning mechanism. About once every shooting session and after any long period of disuse should be fine. Remember to hold the camera normally (sensor perpendicular to the ground) so that the dust falls to the adhesive strip at the bottom of the sensor chamber designed to catch the dust. Skip to Step 3.
(For those without a built-in shake dust removal system) On a regular basis, use your blower bulb to try to dislodge casual dust from the filter surface (camera should be facing down so that dust dislodged falls out of the camera through the lens mount). Do this in a clean environment and regularly, and you generally will get most of the dust dislodged this way without having to touch the filter.
Use a Sensor Brush whenever you need to remove casual dust the automated cleaning or blower bulb can't dislodge. Follow their procedures exactly; don't take shortcuts. Most of the time, this is enough cleaning to remove the offending dust. If you're traveling, you can use an Arctic Butterfly for this step, but be extremely careful not to touch it to the sides of the sensor mounting frame.
If a Sensor Brush session doesn't remove stubborn dust, use a Sensor Swab wet with Eclipse or Dust Aid Ultra Clean solution. Again, follow the manufacturer's procedures exactly.
If you still have a persistent dust bunny, you'll probably have to really wet a Sensor Swab (being careful not to wet it so much that the cleaning material breaks) and go over that spot again, perhaps with a gentle scrubbing action. This will likely leave streaks. If it does, let the sensor dry and then do another regular Sensor Swab of the sensor. Sometimes you have to do this sequence several times (wet pollens are no fun to remove).

Nikon focus modes

When you set your camera lens to AF (auto focus), digital SLR camera's offer the photographer a choice between interchangeable modes. Auto focus modes can vary between different digital camera brands. In the past, Nikon's two most popular modes were called Continuous Servo AF and single area AF. Nowadays, they are called AF-C (short for auto focus continuous) and AF-S (short for auto focus single). Many Nikon models also have AF-A and MF (manual focus) modes to choose from as well.

What are the differences between AF-C, AF-S, AF-A and MF focus options?
AF-C (AF continuous, sometimes called continuous servo) is good use when photographing moving objects. When your camera is set to AF-C and you focus on a moving subject, for example a dog running towards you, the focus will stay on the animal so long as your shutter button is held half way down. In other words, the camera will keep re-focusing as the animal moves. That is, so long as you keep your shutter button held half way down.

AF-S (AF single, sometimes called single area AF) mode, is good for photographing subjects that don't move, such as flowers or portraits etc. It locks the focus on the non moving object that you want to photograph. You can then recompose the shot and take the photograph.

AF-A is where the camera selects and goes between the last two modes. If it thinks the subject you are photographing is stationary, then it will automatically use AF-S focus mode. If it picks up that the subject you're photographing is a moving subject, then it will automatically use AF-C focus mode. This is also the default camera focus mode, unless you change the setting to AF-C or AF-S.

MF is the manual focus mode. It's unclear why this focus mode is included, because nowadays there is usually an option to switch between auto and manual focus on the side of the actual lens. Maybe it's in case you come across a lens that doesn't give you that option.


Why would photographers change between focus modes?
The default camera setting is AF-A. As mentioned earlier, this mode guesses if the subject you are photographing is stationary or moving, and accordingly sets the focus to either AF-C or AF-S. Photographers don't always trust the camera to pick the correct setting, preferring to make the choice themselves.

http://www.slrphotographyguide.com/camera/nikon-digital-slr/focus-modes.shtml

Metering

Metering means to ensure that u properly expose ur scene. There are 3 kinds of mode (a) matrix metering (b) centre weighted (c) spot metering

(a) matrix metering - normally used in landscape photography to properly expose the whole scene, the camera will determine the light across the whole picture and try to find the best setting to properly expose everything.

(b) centre weighted - normally used in portrait setting or other scenes where there is a main object that occupies abt 70% of the picture center. The camera will try to properly expose the 70% of that picture and "ignore" the background. So for example, if ur object is black and ur background is white, the camera will meter the black object, and will try to adjust itself to bring out the black object's details. In order to do so, it got to expose more. So wat u get is a properly exposed black object against a over exposed background. Remember the background is already white, and because of the need to expose more to bring out the black details, the white background will be overexposed.
So i think u get wat i mean, the camera will only care abt the center 70%.

(c) spot metering - similar to the centre weighted metering, but just that in spot metering, we meter only a small spot eg. a 6mm diameter circle in the picture. This is used for example, when there is a small frog in a bright picture. if u use matrix metering, the camera will evaluate the whole scene and think that the whole picture is too bright, and hence under expose the picture to generate a proper exposure for the whole scene. But in doing so, the small frog may be further underexposed and become dark frog.
in addition, if u use centre weighted metering, remember it assigns abt 70% to the center of the picture, but the frog is only very very small in the picture! hence the end result will also be the camera feels that the scene is too bright and underexpose.
Thus in spot metering, u aim the center crosshair on the frog to meter the frog. This will ensure that the frog is properly exposed and be seen! but of course the background may not be properly exposed

photography 101

http://digital-photography-school.com/photography-1014-exposure-and-stops

Wednesday, April 14, 2010

Home remedies to Improve Lactation & Breast feeding

My experiences on improving milk prodution during breast feeding.

Breast feed your child for at least minimum six months.
Here are certain home remedies which have helped me improve Lactation & breat feed my baby.

1) Drink 3-4 litres of water daily....very very important
Your body needs lots of fluids during breast- feeding.
2)Have half a litre to one litre of milk daily..
There is One Ayurvedic powder available called SATAVARI- to be taken with milk.....creats wonders to milk secretion.
3)Eat dry grated coconut around 100 gms daily. Even fresh grated coconut is helpful.
4)Eat Carom seeds( Hindi name- Ajwain) around 1-2 teaspoon after every meal.Mildly Roast the carom seeds bafore eating.....this helps to improve the milk secretion and in addition prevents the baby from gastric problems.
5)Eat a bowl of cracked Wheat (Hindi name- Daliya) daily....you can mix milk & sugar to make a desert out of the Daliya or make any spicy recipe as per your choice.
6)Have enough Ghee with your food around 5 tablespoons daily.
7)Fenugreek seeds ( Hindi name- Methi Seeds) should be consumed daily....in the form of sprouted seeds or you can make vegetable or some sweet item by mixing them with rice & jaggery .
8)Juice of Neem Leaves & Neem Stem consumed every morning on empty stomach also helps.
9)Make ladoos by mixing Gum( Marathi name- Dink), wheat flour & dry fruits..eat one every morning
10)For non- vegetarians, you can have one Egg daily & chicken or paya soup.
If you love Fish eat fishes with shells (Mussels)
11)Continue with the prenatal tablets or Calcium/Iron Supplements

*Please do not keep your stomach empty when breast feeding...The Rule is " The More Healthy & Full the Mother eats The More Lactation Improves"
*The Baby has only one source of nutition and that is YOU!!!This is just the extension of your pregnency


Hope this post is Helpful to you.

D50 Lens

The Nikon D50 employs the Nikon DX Format sensor and Nikon F lens mount design. This maintains seamless compatibility with all AF Nikkor lenses and allows photographers to take full advantage of DX Nikkor lenses designed for Nikon's D-series digital SLR cameras and which are optimized to achieve maximum center-to-edge-to-corner image quality.

Compatible Lenses

1) DX Nikkor: All functions supported

2) Type G or D AF Nikkor: All functions supported

3) Micro Nikkor 85 mm F2.8D: All functions supported except autofocus and some exposure modes

4) Other AF Nikkor: All functions supported except 3D Color Matrix Metering II

5) AI-P Nikkor : All functions supported except 3D Color Matrix Metering II and autofocus

6) Non-CPU : Can be used in exposure mode M, but exposure meter does not function; electronic range finder can be used if maximum aperture is f/5.6 or faster

Note: IX Nikkor lenses can not be used

Monday, March 29, 2010

AIR PUMP / FILTER DIY


http://www.pet-expo.com/trivia/aquariums-pumps.htm
http://www.petsnpets.com/index.php?main_page=index&cPath=61_82_83

Manufactures of powerheads rate their "pumps" based on gallons per hour (GPH). A rating of 120 GPH means that the pump will move 120 gallons of water in an hour.

To determine the correct powerhead for your system know that most experts conclude that a healthy environment requires that the water be completely circulated at least five to six (5-6) times an hour. Therefore if your aquarium is 20 gallons, you should choose a powerhead that will pump 20 gallons times 5 (20x5) or at least 100-120 GPH. Choosing a powerhead that moves as much as 10 times the actual water volume of your aquarium is certainly acceptable.

************************************************************
http://www.petfish.net/articles/Do-It-Yourself/sponge_filter.php



Material List:

8 inch length of 1/2 inch or 3/4 inch PVC pipe (Lowes, Homedepot) approx $2.00 for a 10 foot pipe
4 inch by 4 inch block of foam rubber (different sizes available from Lowes, Home Depot or Walmart etc) Very cheap.
8 inch length of rigid airline tubing (Available at Petsmart for about $2.00 for a 4 foot length)
Marbles, slate or rocks to use as a weight for the filter
Silicone for glueing the parts together

Notes On Construction:
These filters can be made in bulk quantities faster and cheaper. Be sure to get "open pore sponge", to be sure that's what you have you can try to blow thru the sponge, if you can, it's open pore = good, if you can't, it's closed pore = bad.
Making the uplift tube:
Cut the PVC pipe into 8 inch lengths. On the bottom of the uplift tube drill a few holes to allow the entrance of water into the pipe from the sides. You can either drill holes or use a hacksaw to cut slits, either way is fine.
Silicone the rigid airline tubing on to the inside of the uplift tube. An alternate way to accomplish this is to drill a slanted hole so that the rigid tube can be slightly bent and forced to the bottom of the uplift tube. Natural friction will hold fast the rigid airline tubing.
Cut up the sponge into 4 inch cubes, larger or smaller, it's up to you.
Cut or drill a hole in the sponge to snugly accept the PVC uplift tube. One way to do this is to wet the sponge and freeze it to allow easier drilling. I find that just plunging a razor knife into the dry sponge works quite well. Be very careful.
The sponge is going to naturally float until it is well water logged, that's why the marbles or slate is used as a weight to help hold the sponge on the bottom of the tank.
I prefer to silicone a piece of slate or tile to the bottom of the sponge filter.
(I have found that hot glue will come undone under water, but your luck might be better, or I might have the wrong kind of hot glue)
Now hook your filter up to an airpump and it's ready to start filtering.
A quick way to populate the sponge filter with "good guy" bacteria is to run it a week or 2 in a tank with an established sponge filter. Or squeaze an established sponge filter in the water of the new tank so that the new filter will suck up the bacteria released from the established filter.
These filters are very efficient. One of these in a 10 gallon tank will supply all the filtration required to keep it clean and balanced. The costs of these filters if made in quantities of about 10 at a time will be under $2.00 each. Pretty good deal huh?

Saturday, March 27, 2010

Scripts

http://arunrathod.blogspot.com/search?updated-max=2009-06-10T21%3A41%3A00-07%3A00&max-results=7

Friday, March 26, 2010

Acrylic Aquarium

--------------------------------------------------------------------------------

If you are willing to transport it from Goregaon-E (w.exp. highway) to Yari road, you can get in touch with Shekhar (9987509762, 9869480313) He is quite reasonable and he can also make a nice acrylic hood for you as per your requirement along with lighting fixtures.
His shop (Tanvi Aquarium) is bang on the highway, left hand side if you are travelling north (opposite SRPF camp)
You can give my reference if you want.

http://borneosucker.blogspot.com/search?updated-max=2009-11-03T15%3A49%3A00%2B08%3A00&max-results=7
--------------------------------------------------------------------------------

Best site : http://www.aquarticles.com/articles/management/Gopi_Making_an_Acrylic_Aquarium.html

http://www.procurefast.com/index.php?page=shop.product_details&flypage=flypage.tpl&product_id=83&category_id=28&option=com_virtuemart&Itemid=1

http://www.princeplastics.com/eng_careerpopp.htm


Aquarium Height Sheet Thickness
1 to 12 inches 1/4 inch
12 - 18 inches 3/8 inch
18 - 24 inches 1/2 inch
24 - 30 inches 3/4 inch


1mm = just over 1/32 inch
2mm = just over 1/16 inch
3mm = almost 1/8 inch
4mm = 5/32 inch (= a bit over 1/8 inch)
5mm = just over 3/16 inch
6mm = almost 1/4 inch
7mm = almost 9/32 inch (= a bit over 1/4 inch)
8mm = 5/16 inch
9mm = almost 3/8 inch
10mm = just over 3/8 inch
11mm = almost 7/16 inch
12mm = almost 15/32 inch (= almost 1/2 inch)
13mm = just over 1/2 inch
14mm = almost 9/16 inch
15mm = almost 19/32 inch
16mm = 5/8 inch
17mm = almost 11/16 inch
18mm = just over 11/16 inch
19mm = 3/4 inch
20mm = 25/32 inch
21mm = just over 13/16 inch
22mm = almost 7/8 inch
23mm = 29/32 inch
24mm = just over 15/16 inch
25mm = almost 1 inch

Thursday, March 25, 2010

STARTER FISH

http://www.aqadvisor.com/AqAdvisor.php
http://www.fishforums.net/index.php?/topic/277264-beginners-resource-center/
***********************************************
Good Freshwater Fish for Beginners

Here is our list of freshwater fish that would be great for the beginner to start with. For pricing purposes, we used the LiveAquaria.com site.


Anabantids (Bettas and Gouramis) Bettas are also known as Siamese Fighting Fish (as in the fish that will attack its own mirror image). Bettas and Gouramis are beautiful labyrinth fishes meaning that they get air at the surface of the water through a labyrinth organ. The downside with male Bettas is that you can only keep one Betta male in a tank (you can have other fish but no other male Bettas). Gouramis are usually peaceful additions to the community tank. Price range for Bettas is $2.49 to $6.49. Price range for Gouramis is $2.49 to $12.99.
Cichlids. There are so many different Cichlid species, that you will have no problem picking one that suits your aquarium. Cichlids can get large and are territorial during breeding season. They can be prolific in captivity? Price range for African Cichlids is $5.99 to $39.99. Price range for New World Cichlids is $3.99 to $59.99.
Cyprinids (White Cloud Mountain Minnow, Zebra Danios, Rasboras, and Cherry Barbs) These little guys are hardy. You will find tons of color and pattern variations. You will also enjoy watching their schooling behavior. If you had to pick one fish to start with, you could not go wrong with a White Cloud Mountain Minnow. Price range is $1.29 to $7.99.
Livebearers (Guppies, Platies, and Swordtails) These beautiful fish will stay small (under 3 inches for the most part) but that is not the only thing about these guys that makes them a great pick. Brilliantly colored and happy in the community tank, these peaceful fish are extremely easy to keep. Out of all the starter fish, they are the easiest to breed in captivity. Guppies look like they should cost way more than their going price; you'll easily get excited about these fish. Price range is $1.99 to $5.99 to $34.99.
Tetras are so cheap it is practically criminal! Tetras are great additions to the community tank and their vivid colors will attract your attention every time they dart around in their little schools. Price range is $1.49 to $7.99 with most of them in the under $3 range.
Loaches are bottom dwellers that differentiate themselves from most of the fish in this list. They are more secretive; they tend to hang out alone, with many being nocturnal. Loaches require currents in the water as they are stream dwellers in the wild. They will also take care of your snail population if you have a problem with it. Price range is $2.99 to $13.99.

-------------------------------------------------------
http://fins.actwin.com/mirror/fish-popular.html
-------------------------------------------------------
Zebra Danios is indeed one of the best choices. There's one time, i've poured in ammonia at the same time as putting them in a 75-gallon tank. Problem was, i overdosed. Probably 3-4 times the MAXIMUM of what an Ammonia Meter can normally measure. 5/6 died instantaneously, but the 6th one never died. This shows how hard a Zebra Danio can really be.
But make sure you have a lid with them. They do jump out. And they super fast.

Another choice is Guppies. I've cycled a tank with 14 guppies before. At the end of the cycle., NONE of them died. It might be luck, or probably because i was paying REALLY close attention to the tank.

I've had 2 guppy fry raised in an ice-cappuccino cup till adult form. I've moved them into a 5 gallon now, 2-years old, still living.

So my conclusion is, Guppies and Zebra Danios are the hardiest freshwater fishes you can find and are best candidates for Fish Cycling. However, I suggest Fishless Cycling, since it's a faster, can put in tons of fishes at once at the end, and no risk of scarifying fish.

********************************
pygmy cories
copper harlequin rasboras
cherry barbs
Cardinal/Neon tetras are about the most common fish that beginners want to include but that we like to advise that people wait on. For some reason they do much better after the tank has aged 6 months regardless of cycling.
Neon tetras don't always do well in new tanks, not sure why but they have a higher death rate in new tanks. If you can avoid adding them first then do.

SMALL TROPICAL FISHES

http://www.aquariumpros.com/articles/fishcyclefw.shtml
http://aqualandpetsplus.com/Minnows,%20Danios.htm

Guppies.
look up cycling a tank before you go off and buy some guppies they WILL DIE if you do not cycle your tank

neon tetras*****
they are middle level swimmers, but you need to buy at least 6 or more as they are schooling fish. there about 1/2 inch or smaller and non-aggressive.
Not good for Cycling

Philippine goby

Zebra Danio
Good for cycling
Danios insist on being in schools. The more the merrier.

albino Corydoras
Catfish Males smaller than 2 inches, females larger
While almost all Plecostomus species feed on algae, they too need a varied diet.
Not to be added w/o cycling

How to do Fishless Cycling

By Cichlid dude at http://answers.yahoo.com/question/index?qid=20090402233249AAdp1hP


Ammonia is introduced into the aquarium via fish waste and uneaten food. The fish waste and excess food will break down into either ionized ammonium (NH4) or un-ionized ammonia (NH3). Ammonium is not harmful to tropical fish but ammonia is. Whether the material turns into ammonium or ammonia depends on the ph level of the water. If the ph is under 7, you will have ammonium. If the ph is 7 or higher you will have ammonia.

Stage 2
Soon, bacteria called nitrosomonas will develop and they will oxidize the ammonia in the tank, essentially eliminating it. The byproduct of ammonia oxidation is Nitrites. So we no longer have ammonia in the tank, but we now have another toxin to deal with - Nitrites. Nitrites are just as toxic to tropical fish as ammonia. If you have a test kit, you should be able to see the nitrite levels rise around the end of the first or second week.

Stage 3
Bacteria called nitrobacter will develop and they will convert the nitrites into nitrates. Nitrates are not as harmful to tropical fish as ammonia or nitrites, but nitrate is still harmful in large amounts. The quickest way to rid your aquarium of nitrates is to perform partial water changes. Once your tank is established you will need to monitor your tank water for high nitrate levels and perform partial water changes as necessary. There are other methods to control nitrates in aquariums besides water changes. For freshwater fish tanks, live aquarium plants will use up some of the nitrates. In saltwater fish tanks, live rock and deep sand beds can have anaerobic areas where denitrifying bacteria can breakdown nitrates into harmless nitrogen gas that escapes through the water surface of the aquarium.

Getting The Nitrogen Cycle Started
There are two ways to get the aquarium cycle started, either with fish or without fish.

Starting The Nitrogen Cycle With Fish
This is not the preferred way to get the nitrogen cycle started because the fish are being exposed to ammonia and nitrites during this process. Many fish can not and will not make it through the cycling process. Often times the fish become stressed and fish disease starts to break out. I wonder what percentage of disease is caused by the cycling of new aquariums?

Certain species are hardier than others and seem to tolerate the start-up cycle better than others. For freshwater tanks, the zebra danio is a very hardy fish that many use to get the nitrogen cycle started. For saltwater tanks, some have reported success using damselfish to get the process started. Again, using fish to cycle is not a good idea and you may be throwing your money (on dead fish) out the window. There is a better way. Read on, young grasshopper.

Starting The Nitrogen Cycle Fishless
There are a few different ways to get this process started. To easily get an ammonia reading from your tank water try the Seachem Ammonia Alert. It sticks inside the tank and has a circle that changes color depending on the ammonia levels in the tank.

Option 1:
Using Fish Food
Drop in a few flakes every 12 hours. As the food decomposes it will release ammonia. You will have to continue to "feed" the tank throughout the process to keep it going.

Option 2:
Use a small piece of raw fish or a raw shrimp
Drop a 2 inch by 1 inch chunk of raw fish or a raw shrimp into the tank. As it decomposes it will release ammonia into the tank.

Option 3:
Use 100% pure ammonia.
Using a dropper, add 5 drops of ammonia per 10 gallons of aquarium water. If you don't get an ammonia reading with your test kit, add some more drops until you start to see an ammonia reading. Keep track of how many drops you've used so you can repeat this process daily. Continue to dose the tank with ammonia until you start to get nitrite readings with your test kit. Once you can detect nitrites you should only add 3 drops of ammonia per 10 gallons of aquarium water, or if you added more drops originally to get an ammonia reading cut the amount of drops used in half. Continue this process daily until you get nitrate readings with your test kit. Do a 30% water change and your tank is ready.

Option 4:
Use gravel and/or filter media from an established and cycled tank
This is the best and fastest way to go. This will seed the tank with all of the necessary bacteria for the nitrogen cycle. "Feed" the tank daily with flake food until you are getting nitrate readings. Depending on how fast you were able to get the gravel and filter media into your tank, you may be getting nitrate readings in only a day or two. There are some drawbacks to this method. Ask your source if they have recently used any copper medications in the tank. If they have and you are planning to have invertebrates in the tank you should probably not use this method. Invertebrates will not tolerate copper. Get a copper test kit to determine if it's safe to use.

Good luck!!!~~~~<><~~~~><>~~~~


To Make Cycling Faster

http://www.bluecrayfish.com/cycle.htm


2. Keep the tank only about 50-65% full. This creates a waterfall effect as the water leaves the filter, and when the water from the filter hits the surface of the aquarium water, there is a great deal of water turbulence, exposing more water to more air more quickly, and leading to increased oxygenation, and thus, faster cycling.

3. Keep the aquarium light on 24 hours per day during cycling. Only do this if you have no pets in the aquarium which need less light, or which need darkness. The increased light leads to faster cycling.

4. Use as many air stones and air pumps as you have access to, which will fit in the aquarium. Keep them all running all the time. This leads to increased oxygenation, which leads to faster cycling. Only do this if you have no pets in the aquarium which need calm, or still water.

5. Keep the filter running the entire time the aquarium is undergoing the cycling process. This increases water flow, and insures that good bacteria build up in the filter material, both of which lead to faster cycling.

--------------------------------------------------------------------
2 Sunset platies require 100 bacteria to process their waste
5ppm of ammonia requires 10000 bacteria to process it's waste.
9900 bacteria would die when you added just 2 sunset platys.

Then when you added 4 shrimp and 4 corys imagine they took around 500 bacteria to process their waste. Well that 100 would have to double 5 times before the ammonia would be kept stable, and then it would take additional times for them to actually remove ammonia+nitrite from the water.

However if you add a large group alltogether then you keep most of your bacteria colony hopefully.
And so when you then add new fish, it should hopefully only need to double once to produce sufficient numbers to process waste.
That way you will never risk seeing an ammonia spike.
Eitherways there is certainly no point in waiting 2weeks, you could add fish every couple of days as it will have definitely caught up by then


Luckily I have reread the article on cycling. I had inconveniently forgotten that the nitrite had to be getting to zero within 12 hours also. I couldn't understand why the nitrite level wasn't going down when the ammonia was disappearing after 12 hours. I now realise we are only half way through cycling!

I wasn't aware that the bacteria would be dying if they weren't being fed by ammonia so I will take your advice and once we are fully cycled we will virtually fully stock. Thanks again.

*************************************************************

) Buy liquid testing kits for ammonia and nitrite
2) Buy pure ammonia (from a hardware store or department store)
3) Add enough ammonia to the tank to read 5ppm (parts per million) or5 mg/l (milligram per litre) on the test kit.
4) Test every day for ammonia and always add enough ammonia to keep the levels at 5ppm or 5 mg/l
5) Keep testing until you see the levels of ammonia reach zero within 12 hours of adding new ammonia
6) Start testing for nitrite and ammonia, and keep adding new ammonia if you need to
7) Keep testing for both until they both reach 0 after 12 hours
8) Do a very large water change (90%)
9) Add fish

*************************************************

Friday, March 19, 2010

Remove ^M characters at end of lines in vi

To remove the ^M characters at the end of all lines in vi, use:

:%s/^V^M//g

The ^v is a CONTROL-V character and ^m is a CONTROL-M. When you type this, it will look like this:

:%s/^M//g

In UNIX, you can escape a control character by preceeding it with a CONTROL-V. The :%s is a basic search and replace command in vi. It tells vi to replace the regular expression between the first and second slashes (^M) with the text between the second and third slashes (nothing in this case). The g at the end directs vi to search and replace globally (all occurrences).

Thursday, March 18, 2010

sql-excel

Well, if you are on unix then using the method in the link that I posted.
You need to list down the names of the tables in a file suppose list.txt
you can use the following shell script to generate spool of various tables in xls files.
cat list.txt | while read a
do
echo "spooling $a"
sqlplus username/password@string <set feed off markup html on spool on
spool /home/oracle/$a.xls
select * from $a;
spool off
set markup html off spool off
EOF
done


set feed off markup html on spool on
spool c:\salgrade.xls
select * from salgrade;
spool off
set markup html off spool off

Tuesday, March 2, 2010

Playback

A final note, make sure you adjust your display resolution to the native resolution of your TV. Most TV’s are 720p or 1080p, which in computer resolution terms are 1280x720 or 1920x1080, respectively. This will ensure the highest quality picture for you and your family.

Read more: http://www.brighthub.com/electronics/home-theater/articles/36197.aspx#ixzz0gzlvYTs3


DMI has quickly become a popular request for users who read about all the features it brings - most notably its ability to carry both audio and video over a single cable. Since most older systems do not include an HDMI port, the first step needed will be to upgrade your graphics card to a new one that does. For graphics solutions there are two players: Nvidia and ATI. Both manufacturers produce video cards with HDMI ports (or DVI ports with HDMI adapters), but Nvidia does not have it’s own sound chip on board. What that means is that the Nvidia is merely a pass-through of the S/PDIF audio. If you only have a 5.1 surround sound setup, then this is acceptable. For users with newer 7.1 surround sound setups, ATI will be the only graphics card of choice. The ATI contains a dedicated sound chip on-board which allows for support of up to 7.1 multichannel audio over the HDMI cable.

The other critical piece of information necessary is to ensure you have an available port on your motherboard to support the video card. You can refer to your motherboard or computer documentation for this information if you do not know. Basically, there are two standards. These are the older AGP connection and the newer PCI-Express. Any computer built in the last 2-3 years should have a PCI-Express slot. If you only have AGP, upgrading may be more difficult as the number of AGP cards with HDMI ports is quite limited and may cost more. If that’s the case, you may be better suited for a complete system overhaul or re-purchase.

Read more: http://www.brighthub.com/electronics/home-theater/articles/36197.aspx#ixzz0gzmoOchO