Excel formular - Sum up multiple data in multiple cells & record down the order no.
Excel formular - Sum up multiple data in multiple cells & record down the order no. is project number 236015 posted at GetAFreelancer.com. Click here to post your own project.
| Status: |
Closed
(Selected Service Provider)
|
| Selected Providers: |
selected service provider
Icebear951
|
| Budget: |
$30-250
|
| Created: |
03/11/2008 at 5:11 EDT |
| Bidding Ends: |
03/18/2008 at 5:11 EDT
|
| Project Creator: |
seesee
 
Buyer Rating: 
(15 reviews)
|
| Description: |
Like the photo shown, i need to do a homework about summing up product quantity. This formula is bestly based on Excel. It is a $30 project.
In sheet 1,
A column is Order no. (A2 = 0001, A3 = 0002, A4 = 0003..etc). Products are free to order, order 0002 can contains some model where 0003 have.
Start from Y2, product information recorded in below absolute format and repeat till end of the order:
Model Product Qty Price
Model no. are started with "PD-" , "T-" , "Set-" , "A" or "S-", where repeat in every 4 columns. Product full name start with model no.
I need to add a Sheet 2, sum up all the corresponding data in Sheet 1 and sort in below format:
Eg.
Model Qty Corresponding Order no.
PD-0553 4 0001, 0003
PD-0554 3 0001
Thanks,
CC
Additional information submitted:
03/11/2008 at 5:22 EDT:
Sheet 2 should be in excel2.JPG format.
Eg. For Model PD-0553, there are 2 ppl ordered.
Order no.0001 takes 2 and no.0003 takes 2, so tatally 4pcs need for procurement.
Additional files submitted:
excel.JPG
excel2.JPG
|
| Job Type: |
|
| Database: |
(None)
|
| Operating system: |
MS Windows
|
| Bid count: |
19
|
| Average bid: |
$ 30
|
|
|
|
|
Messages Posted:
2
If you are the project creator or one of the bidders  for more options
|
| ready for your work.
|
| Excel Expert at your service.
Kindly see PM for details
|
| Please see PMB.
|
| Dear CC! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.
|
| Sir - You may consider it's done already. Please see PM for details.
|
| Please check PM for further details
|
| I have plenty of experience of it.
|
| Hi please see pmb
|
| My only purpose is to offer your my good service and get your good reviews, thanks for your attention.
|
| Dear Sir
Kindly check your PM for details.
Thanks
AZHU
|
| Sir or Madam,
Please Contact me.
Thanking you,
D.Krishna Kumar
|
| Hi, please PM
|
| Good Day! I am a college instructor and I am knowledgeable in MS Office Application especially in MS Excel where I try to record all my students quizzess. And I try linking multiple sheets like what you want to your project. If you will choose me, I will guaranteed your satisfaction to my work. Thanks and I will wait for you positive response.
|
| I am ready to carry out this project, but can you give me an example in MsOffice Excel to have more information.
|
| Hello;
I'm right away ready for a fast turnaround within hours for as low as $10.
REgards.
|
| An experienced (1 and a half years) in BPO in the capacity of a MIS executive - pertaining to the needs of the backend process of a Telecom company.
Professional Profile
Experienced in client relations.
Organized, dedicated with a positive attitude.
Excellent in Mathematics.
Major Achievement
Received the Best Performer Award as MIS for the year 2007-2008 H1 for customer support, team & operations management.
Completed Six Sigma Yellow belt certification on-Reduction in CAF rejection.
Completed Six Sigma Yellow belt certification on-Increase in active Sub Base.
Summary of technical qualifications
Internet, Databases Applications Expertise
Advanced education in Software and Hardware
Experienced in building reliable and scaleable systems
Successfully deployed applications on time and under budget
Extensive experience in third party tools and solutions.
IT skills
Excel / Word / PowerPoint / Access.
Expert in most Operating systems.
Software Applications: Macromedia Dreamweaver, Macromedia Captivate.
Spread Sheets: MS Excel 2003, MS Excel 2007.
Direct one-to-one interaction with the client for all matters related to process compliance, operations, support and business on a regular basis.
Producing daily circlewise activation report.
Productivity analysis.
Rejection reason analysis.
Comp dashboard for zone manager and coo.
Manageing ftp.
General Roles & Responsibilities
Adherence to the productivity, turn-around-time, and accuracy
Engage in improving processes through reengineering, system checks, process automation
Interact with client on transactional issues
Develop back up and contingency plans
Act as a change agent and provide implementation assistance as and when the need arises
Update supervisor on process performance and critical people issues.
Provide coaching and feedback to team members.
Hold regular team meetings with Team Members to ensure that there is constant flow of information and knowledge dissemination.
Assist new hires such that they are productive on the floor in the shortest possible time frame
Assess training needs, provide training opportunities and train new hires and existing staff.
Primary Internal Interactions:
All Team Members in the teams - for the purpose of achieving 0% error.
Managers/Directors in the Operations department - for the purpose of planning, and sharing performance feedback
Primary External Interactions
Process owner at the Client end - for the purpose of routine checks, process control, handling MIS related issues & maintaining the relationship.
Competencies: Process Orientation
Manages process performance through effective measurement. Identifies repeatable tasks for digitization.
Understands and follows processes. Committed to zero error.
Customer Focus
Understands the customers need and goes the extra mile to deliver it faster & better.
Training - Skills & Capabilities
Good experience in providing process-oriented trainings.
Efficient in preparing training modules pertaining to the support needs.
Effective in conducting, planning and evaluating trainings.
Adequate exposure in providing trainings under multi-skill environments.
Learn-ability
Learns from mistakes. Has the ability & urge to continuously learn.
Continuously solicits ideas and suggestions to make effective decisions and plans.
Teamwork
Has the ability to work cooperatively with others as part of multiple teams, as opposed to working separately or competitively
Understands the role in a team situation and contributes effectively. Shares information and maintains effective working relationships with other team members.
Leadership
Gets the best out of people by demonstrating confidence in them. Demonstrates the Continuum Spirit.
Other Responsibilities
Implemented the training for OE agents/teams to reduce error % during order entry.
Providing regular feedback & reports.
Generating numerous daily reports for in-depth analysis.
Preparation and submission of periodic reports to senior managers.
Ensuring complete satisfaction of the customers/clients.
Strengths
Good Communication Skills, Counseling, Handling multiple tasks simultaneously, highly adaptable, Proactive, Team worker, Responsible, Sincere & patient.
|
| If you choose us , you have 25% discount for your next project!
|
| I can do it at the earliset. just tell me when to start
|
| Please check the PM.
Looking forward to work for you. Thanks...
|
|
|
|
|
What is GetAFreelancer.com? ( Read about the company )
Would you like to outsource your next project? Would you like to make money as a freelancer? Click Sign Up to start!
Outsource projects and save a lot of money. Getting affordable freelance work, freelance programming and custom web design done for your website has never been easier.
Companies of any size have used our web services.
A freelancer is an independent worker, not on salary, hired instead on a project basis.
Deposit money and don't purchase until your project is completed.
GetAFreelancer.com is one of the largest sites of its kind. We have earned a good reputation and you can trust us.
Our site is global and we have freelancers from India, Romania, Russia, Ukraine, United States, UK and many other parts of the world.
Outsourcing is hiring an outside organization to perform services such as information processing and applications development.
Our escrow feature is developed to protect both buyers and sellers.
Buy services with help from our secure escrow system.
Outsourcing is the process of subcontracting network operations and support to an organization outside your own company. Try it free today!
|
Find Webmaster Resources and
Webmaster Forum.
Take a look at Search Engine Submission.
|
Provider Rating
Innovate it © 2004-2008
PRIVACY POLICY -
TERMS -
AFFILIATES -
CONTACT -
FAQ
