Finacle Solution Android App Update 3.0.2 is released on 21.09.2015. It is upgraded with more features. Now it can work both online and offline base. It is filled with all Finacle command. The process of using command is also given in this App. It can easily install in android and work better than previous version. You can download it from this blog and share you views about it with us.
Tuesday, September 22, 2015
Saturday, September 5, 2015
Your Excel formulas sheet: 15 tips for calculations and common tasks
Many of us fell in love with Excel as we delved into its deep and sophisticated formula features. Because there are multiple ways to get results, you can decide which method works best for you. For example, there are several ways to enter formulas and calculate numbers in Excel.
1. Manually enter Excel formulas:
Short Lists: =SUM(B4,B5,B6,B7); =SUM(B4+B5+B6+B7). Or, place your cursor in the first empty cell at the bottom of your list (or any cell, really) and press the plus sign, then click B4; press the plus sign again and click B5; and so on to the end; then press Enter. Excel adds/totals this list you just “pointed to:” =+B4+B5+B6+B7.
Excel formulas
2. Click the Insert Function button
Use the Insert Function button under the Formulas tab to select a function from Excel’s menu list:
=COUNT(B4:B13) Counts the numbers in a range (ignores blank/empty cells).
=COUNTA(B3:B13) Counts all characters in a range (also ignores blank/empty cells).
3. Select a function from a group (Formulas tab)
Narrow your search a bit and choose a formula subset for Financial, Logical, or Date/Time, for example.
=TODAY() Inserts today’s date.
4. The Recently Used button
Click the Recently Used button to show functions you've used recently. It's a welcome timesaver, especially when wrestling with an extra-hairy spreadsheet.
=AVERAGE(B4:B13) adds the list, divides by the number of values, then provides the average.
5. Auto functions under the AutoSum button
Auto functions are my editor's personal favorite, because they're so fast. Select a cell range and a function, and your result appears with no muss or fuss. Here are a few examples:
=MAX(B4:B13) returns the highest value in the list.
=MIN(B4:B13) returns the lowest value in the list.
AutoSum in ExcelJD SARTAIN
Use the AutoSum button to calculate basic formulas such as SUM, AVERAGE, COUNT, etc.
Note: If your cursor is positioned in the empty cell just below your range of numbers, Excel determines that this is the range you want to calculate and automatically highlights the range, or enters the range cell addresses in the corresponding dialog boxes.
Bonus tip: With basic formulas, the AutoSum button is the top choice. It’s faster to click AutoSum>SUM (notice that Excel highlights the range for you) and press Enter.
Another bonus tip: The quickest way to add/total a list of numbers is to position your cursor at the bottom of the list and press Alt+ = (press the Alt key and hold, press the equal sign, release both keys), then press Enter. Excel highlights the range and totals the column.
Five handy formulas for common tasks
The five formulas below may have somewhat inscrutable names, but their functions save time and data entry on a daily basis.
Note: Some formulas require you to input the single cell or range address of the values or text you want calculated. When Excel displays the various cell/range dialog boxes, you can either manually enter the cell/range address, or cursor and point to it. Pointing means you click the field box first, then click the corresponding cell over in the worksheet. Repeat this process for formulas that calculate a range of cells (e.g., beginning date, ending date, etc.)
1. =DAYS
This is a handy formula to calculate the number of days between two dates (so there’s no worries about how many days are in each month of the range).
Example: End Date October 12, 2015 minus Start Date March 31, 2015 = 195 days
Formula: =DAYS(A30,A29)
2. =NETWORKDAYS
This similar formula calculates the number of workdays (i.e., a five-day workweek) within a specified timeframe. It also includes an option to subtract the holidays from the total, but this must be entered as a range of dates.
Example: Start Date March 31, 2015 minus End Date October 12, 2015 = 140 days
Formula: =NETWORKDAYS(A33,A34)
3. =TRIM
TRIM is a lifesaver if you’re always importing or pasting text into Excel (such as from a database, website, word processing software, or other text-based program). So often, the imported text is filled with extra spaces scattered throughout the list. TRIM removes the extra spaces in seconds. In this case, just enter the formula once, then copy it down to the end of the list.
Example: =TRIM plus the cell address inside parenthesis.
Formula: =TRIM(A39)
Excel formulas
4. =CONCATENATE
This is another keeper if you import a lot of data into Excel. This formula joins (or merges) the contents of two or more fields/cells into one. For example: In databases; dates, times, phone numbers, and other multiple data records are often entered in separate fields, which is a real inconvenience. To add spaces between words or punctuation between fields, just surround this data with quotation marks.
Example: =CONCATENATE plus (month,”space”,day,”comma space”,year) where month, day, and year are cell addresses and the info inside the quotation marks is actually a space and a comma.
Formula: For dates enter: =CONCATENATE(E33,” “,F33,”, “,G33)
Formula: For phone numbers enter: =CONCATENATE(E37,”-“,F37,”-“,G37)
5. =DATEVALUE
DATEVALUE converts the above formula into an Excel date, which is necessary if you plan to use this date for calculations. This one is easy: Select DATEVALUE from the formula list. Click the Date_Text field in the dialog box, click the corresponding cell on the spreadsheet, then click OK, and copy down. The results are Excel serial numbers, so you must choose Format>Format Cells>Number>Date, and then select a format from the list.
Formula: =DATEVALUE(H33)
Three more formula tips
As you work with formulas more, keep these bonus tips in mind to avoid confusion:
Tip 1: You don’t need another formula to convert formulas to text or numbers. Just copy the range of formulas and then paste as Special>Values. Why bother to convert the formulas to values? Because you can’t move or manipulate the data until it’s converted. Those cells may look like phone numbers, but they’re actually formulas, which cannot be edited as numbers or text.
Tip 2: If you use Copy and Paste>Special>Values for dates, the result will be text and cannot be converted to a real date. Dates require the DATEVALUE formula to function as actual dates.
Tip 3: Formulas are always displayed in uppercase; however, if you type them in lowercase, Excel converts them to uppercase. Also notice there are no spaces in formulas. If your formula fails, check for spaces and remove them.
Excel formulas
Pradhan Mantri Jeevan Jyoti Bima Yojana (PMJJBY) and Pradhan Mantri Suraksha Bima Yojana (PMSBY) are going to be launched in all the CBS Post Offices w.e.f. 7th September, 2015
Click on the following links to view:
Pradhan Mantri JeevanJyoti Bima Yojna(PMJJBY): FAQ
Pradhan Mantri JeevanJyoti Bima Yojna(PMJJBY) : Standard Operating Procedure
Pradhan Mantri JeevanJyoti Bima Yojna(PMJJBY) : Form
Pradhan Mantri JeevanJyoti Bima Yojna(PMJJBY) : Incentive Structure
Pradhan Mantri Suraksha Bima Yojna(PMSBY) : Rules
Pradhan Mantri Suraksha Bima Yojna(PMSBY) : Rules
Pradhan Mantri Suraksha Bima Yojna(PMSBY) : FAQ
Pradhan Mantri Suraksha Bima Yojna(PMSBY) : Final Consent Cum Declaration
Pradhan Mantri Suraksha Bima Yojna(PMSBY) : Incentive Structure
Pradhan Mantri JeevanJyoti Bima Yojna(PMJJBY) : Rules
Pradhan Mantri JeevanJyoti Bima Yojna(PMJJBY)
Pradhan Mantri JeevanJyoti Bima Yojna(PMJJBY): FAQ
Pradhan Mantri JeevanJyoti Bima Yojna(PMJJBY) : Standard Operating Procedure
Pradhan Mantri JeevanJyoti Bima Yojna(PMJJBY) : Form
Pradhan Mantri JeevanJyoti Bima Yojna(PMJJBY) : Incentive Structure
Pradhan Mantri Suraksha Bima Yojna(PMSBY)
Pradhan Mantri Suraksha Bima Yojna(PMSBY) : Rules
Pradhan Mantri Suraksha Bima Yojna(PMSBY) : Rules
Pradhan Mantri Suraksha Bima Yojna(PMSBY) : FAQ
Pradhan Mantri Suraksha Bima Yojna(PMSBY) : Final Consent Cum Declaration
Pradhan Mantri Suraksha Bima Yojna(PMSBY) : Incentive Structure
Pradhan Mantri JeevanJyoti Bima Yojna(PMJJBY) : Rules
Thursday, September 3, 2015
Central Govt Employees may cheer for higher bonus this year
After long times Central Govt. employees are going to get higher amount of bonus this year. Earlier, the ceiling for bonus was Rs 3500 per month. From this year, the ceiling is going to be increased to as high as Rs 10,000 per month. In a letter from Secretary, Ministry of Labour and Employment, Mr S. Agarwal conveyed this good news to Sri Vijesh Upadhyay, Genl. Secy., Bharatiya Mazdoor Sangha.
Thursday, August 27, 2015
Profitable But Shame; True Story Of India Post COD
Location 1: A Branch Post Office
A congested small half heighted room under the staircase of an office complex built by the state government authorities. The Branch Postmaster, a lady looking nearly 65 years old, is sitting in a damaged chair with dissatisfied face near to a small table. A fan or even proper ventilation is not available in this office.
NB: Dissatisfaction may be due to her concern about the life after retirement (Sorry- Discharge of service)
This small room is filled with undeliverable parcels with label COD. Actually the BPM is surrounded with different types of CODs i.e. BP-COD, SP-COD, EP-COD.
One college boy approached this Post Office and asked about one COD parcel to be received in his name. The BPM told him “Your parcel has been received and this is your parcel, but I cannot deliver this to you since the message is not received.”
The boy asked more about the message and argued for his parcel. He told “my parcel has been received and I am willing to pay the amount, then why you are waiting for message? I don’t want any message… I want only that parcel.”
Helpless BPM! She doesn’t know much about message and its technicality. Instead she acts according to the instruction received from her Account office.
Finally the boy left the office by cursing the Department.
Location 2: A Departmental B Class Sub Office
Rented building with sufficient space but no space in the counter to place a voucher because the small counter is over crowded with various devices. But one-man-show is playing in this office due to staff shortage. But the man working in this office looks very enthusiastic. (NB: The expectation of salary hike in the 7th CPC may be the one of the reasons of his happiness)
One network rack is fixed in a danger condition just above the head of Postmaster and that may fall at any time. (NB: Sify people will reduce the staff strength again)
COD-parcels are dumped in all corner of this office.
One middle aged man approached this Post Office and asked about one COD parcel to be received in his name. The Sub-Postmaster told him “Your parcel has been received, but I cannot deliver it to you because three messages have been received of for this one parcel. So I am waiting for our System Administrator”
He looked at the eyes of Postmaster pathetically without understanding these technicalities. After that he left the office without any complaint or agitation. But he might have said in his mind “What Message and What System Administrator”
Location 3: A Head Post Office
Red and white colour theme and standardized furniture increase the look but old 2000 model computers and dragging printers are losing the dignity gained from Look and Feel.
One e-commerce customer is waiting at the counter for booking COD articles, at the same time one Gentle man approached the delivery branch for his COD articles. The official in the delivery branch told “Your parcel has been reached at this office one week back, due to error in the software it cannot be included in our software. We are waiting for the solution from CEPT.”
The Gentle man asked “What is CEPT?”
The official replied with a smile “Centre for Excellence in Postal Technology”
Part II
Have you ever gone through any of the above said scenario? If you are a Post Office staff, surely you will be well aware of it. Most pain full part is that it is the sorrow of operational staffs only. But others are simply closing their eyes towards the truth (may be due to ignorance)
If it is a single case, we can leave it without giving much importance. But if is happening everywhere, there is something wrong somewhere. But who will answer to the questions from field units?
Have you checked the impression of India Post COD in the web world? If the answer is no, please see the Google search result about India Post COD below. If you search in Google.com with words “India Post COD Service” you can see the same results in rank number 2.
The above said search result is not at all a good sign for India Post in the ecommerce driven parcel service industry. Till the introduction of COD service, the market share of India Post in the parcel service related to ecommerce sector was negligible. But now lots of ecommerce parcels are flowing through the channel of India Post and it is the main revenue source of Department of Post.
If you analyse the evolution of COD in India Post, you can see that there were so many setback in its implementation. Let us examine the reason for this fall.
Retaining an existing customer is more important than acquiring a new business.
1. Implementation without proper planning.
India Post has glorious track record in the implementation of various services throughout the nation and thereby it has earned good trust from the people of India. So the expectation toward any new product or service introduced by India Post will be very high especially the trust in security since it is a Government of India institution.
A mere implementation will not satisfy the needs of a customer in long run. An effective implementation needs proper planning. Here in the case of COD services, I think there was no such planning in advance. It was like somebody got an idea in the midnight and they have implemented the same in the morning.
Through the next four points you can clearly understand that the DOP had implemented COD service without much planning.
2. Lack of time for development and testing of software.
Creating error free software is the crucial part while introducing a new service. Without stable software, it cannot implement on a larger scale without much complaint. At the same time it is not possible to develop stable software in one or two days. So many stages are involved in the development of software and each stage has its own time.
In my knowledge, CEPT is receiving late intimation from directorate in connection with adding new option in software. In most of the cases the inauguration of new service would be fixed in advance without knowing the status of software.
Due to the pressure from the directorate or somewhere, the programmers will be forced to release imperfect software. They will cut off the time taken in each stage of development and in some case they may skip some stages also. This happened in many cases especially in the case of BP-COD. That is why it is facing so many issues even after two years .
3. Same way of thinking in software development.
Conceiving the idea is very important for the development of software. Software for new service can be developed in many ways. Attaining the goal through simple steps with minimum requirement should be the first priority.
In case of COD services, programmers are thinking in same pattern followed by the introduction of eVP service. Since they are more concerned with the rules in the volume, they cannot develop with full freedom. This is the main issue in developing software for India Post.
India Post has very strict rules and regulations in its operation but all such rules need not be implemented while developing software. Trying to include all manual procedure in the software will make software complex.
The developers are not trying to explore the other areas to develop stable COD software. Even if the BP-COD software is a failure, they simply followed same procedure in the SP-COD service also. They all are based on RNet, SpeedNet and ePayment communications. Using multiple communications and multiple modules for handling one service will make service more inconsistent.
COD services are prestige service of India Post then why don’t they use the possibilities of web application for this service? If it is more expensive or time consuming, why don’t they try some simple methods through existing system?
Option for ePayment booking with flexible biller ID at delivery Post Office, receiving automated token from Central Server for retransmitting COD booking messages without human intervention, etc. are some other options.
If India Post invites idea from Postal Staffs across the country for better implementation of a service or Software, they will give hundreds of amazing options.
4. Lack of proper software support.
Software itself is a problem then think about the condition in which operating this software without proper support. That is happening everywhere. For the past few years the condition of CEPT help desk is pathetic. With the introduction of COD, the support is getting worse.
We have discussed the same matter through different posts like
IndiaPost’s COD services – Implementation failed and Testing of SP-COD articles;Total confusion made severe headache.
Unfortunately there is no change in the attitude. The comic replies from help desk make peoples laughing.
A latest comedy is given below.
Scenario: The case was happened at one COD payment office. The SA raised ticket in HDMS for not receiving payment message of a particular COD in Treasury module. The said COD was booked in another office and was delivered from another office.
Fortunately all details were get updated in the tracking.
Support team asked for epayment database of payment office and finally they have given a reply after analysing the database that “article details not available in the forwarded database, please check with out article details providing solution is not possible”
If the details were available in the database there would be no need for raising ticket.
The helpless SA not reopened the case because if he asks more questions, it will invite the dislike of support team and finally they will reach in a conclusion “Database Tampering”, the final arrow towards the questioner.
You can read the original conversation below.
Ticket No: TICNO006XXXX
Ticket Raised Date: 09 Jul 2015 15:14:46:120
Problem Description: An SP-COD EZ746000XXXX booked at XXXX HO has been delivered at destination office on 26.06.2015 and the status has been updated in the ePayment server. But the message has not reached at YYYYY HO for payment. ePayment client is running without any issue and other SP-COD articles are receiving both for delivery and payment. Kindly give necessary guidance to receive the above said SP-COD message for effecting payment. The SP-COD tracking details attached
Screen shot: Download
Suspended Information: CEPT Replied: please forward ecounter database for analysis
Suspended Date: 10 Jul 2015 15:43:00:500
Ticket No: TICNO006XXXX
Ticket Raised Date: 13 Jul 2015 11:28:36:943
Problem Description: Google drive link attached
Solution Description: CEPT Replied: article details not available in the forwarded database, please check with out article details providing solution is not possible
Ticket Closed Date: 13 Jul 2015 17:50:03:820
Ticket Raised Date: 09 Jul 2015 15:14:46:120
Problem Description: An SP-COD EZ746000XXXX booked at XXXX HO has been delivered at destination office on 26.06.2015 and the status has been updated in the ePayment server. But the message has not reached at YYYYY HO for payment. ePayment client is running without any issue and other SP-COD articles are receiving both for delivery and payment. Kindly give necessary guidance to receive the above said SP-COD message for effecting payment. The SP-COD tracking details attached
Screen shot: Download
Suspended Information: CEPT Replied: please forward ecounter database for analysis
Suspended Date: 10 Jul 2015 15:43:00:500
Ticket No: TICNO006XXXX
Ticket Raised Date: 13 Jul 2015 11:28:36:943
Problem Description: Google drive link attached
Solution Description: CEPT Replied: article details not available in the forwarded database, please check with out article details providing solution is not possible
Ticket Closed Date: 13 Jul 2015 17:50:03:820
5. Lag in alternative and corrective measures
Setback is common in the implementation of a new service or new mechanism, but finding and applying an alternative solution in the right time is the success in failure. At the same time, when you following an alternative methods, correction process should be started after studying the actual causes of failure.
After the introduction of BP-COD, so many software issues have been reported from various sides but no one had given proper attention to these issues. Finally lots of customers complained for not receiving their money for the delivered article. After a long period the Directorate has issued an order showing the alternative method of COD payment through eMO.
The first order for sending CDD collection through money order was upto a particular period and after understanding the seriousness of issues they have extended this order to an indefinite period.
No corrective measures have been done in the software side after this order and the issues are still alive even after two years, so most of the offices are sending the COD collection as Money Order.
When you come to SP-COD, the scenario is not different. So many issues are reporting from all sides but no effective action has been taken from any side. The higher authorities are not hearing the crying from the ground level, they simply admitting what CEPT is telling. The ground level facts are more important than conceptual talking of software developers. Everything will be fine theoretically but in practical it may not be like that.
No alternative method has been adopted for the payment of SP-COD collection so far. India Post has all the facility to adopt an alternative method of payment quickly. Then, why should they wait for long to introduce this. The lost customer will not approach again so quick and effective remedy is needed.
Deploying a disaster recovery site or modules after the failure of software as a result of false implementation is not at all a good exercise.
Conclusion
After reading all the above points, you should not think that COD service of India Post is worse compared to others. Compared to the benefits which one ecommerce customer is getting, the internal issues pertaining to India Post COD are negligible. Since it is the prestigious and future deciding service of India Post, it should be completely error free and reliable. If the issues reported from ground level are addressed properly, COD business of India Post and its rating in web will be raised to a new height in the near future.
Source : www.speakpost.com
Subscribe to:
Posts (Atom)










