DSR Excel Formula that tabulates Across tabs and Feeds into Chart.
$30-250 USD
Terminado
Publicado hace más de 4 años
$30-250 USD
Pagado a la entrega
I figured it would be easier doing the math from week to week versus a work book with 8 full weeks in it. I may just need both. Regardless, I need to be able to insert a workbook sheet/tab each week that feeds into the report numbers on the DSR tab.
Thanks for taking a look at this. : - ) Any help is much appreciated!
The first tab is the DSR, the daily report I send out.
(C13 on the DSR tab, I haven't created a formula yet, still waiting on team members to give me their final numbers on Blocked Test Cases).
Example: Add values in worksheet tabs 11_11_DSR, 11_12 DSR, 11_13 DSR, 11_14 DSR, 11_15 DSR.
Pass =SUM(C2:C25)
Fail =SUM(D2:D25)
Passed with Observation =SUM(E2:E25)
Blocked =SUM(J2:J25)
What I need is a formula that tabulates the totals for Pass, Fail, Passed with Observation and Blocked on each daily tab for the week and drop those totals into the DSR Tab for respective cells C10-Passed, C11-Passed Observation, C12-Failed, C13-Blocked.
Kind Regards,
I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main Skills: - Excel - VBA - Python - Web Scraping - MS Office Word, Outlook, Access, PPT Skill Set in Detail: - Office & Web Automation & Blogging on Office Tricks & tips. - Python Programming, Web Scraping - Data Scraping - Manual to Automatic updates in Excel - Excel Pivot Charts & Tables - Excel Auto Filter, Vlookup, Formula Assistance - Excel to Access - User Forms in Excel - Calendars in Excel - Bulk Files Processing in side a Folder - Folder Operations - Sending Email from Excel - Extract Data from Webpages Requesting to Contact before ordering. This would enable me to give a feasible custom offer. Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount. Thanks for your time
Hi, hope you are doing good!
I have done my MBA from one of the top 3 institutes of India and have completed many jobs in Excel and macros related to the ask here. You can check my jobs history for the same
I can assure you about the quality of the work and timed delivery.
Looking forward for your message.
payment only on mutually agreed milestone delivery
$40 USD en 1 día
5,0 (8 comentarios)
3,4
3,4
17 freelancers están ofertando un promedio de $124 USD por este trabajo
Hi,
I am good at Excel Advanced Formulas and VBA macros. I have referred the file. You want to transfer the data and create the summary even with the new sheets coming in? Looking forward to discuss further in detail to review the scope of work.
-Chandra
Hi there,
I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project.
Thanks.
..
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work.
Completed more than 290+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction.
I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
Dear client
I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. I can definitely help you in this project.
Kindly contact me.
Roy
I am MBA accounts and finance, Mphill in computer science and having seven years of experience in Excel (vba & macro's) development.
I already done many projects of:
• Excel Automation.
• Excel Reports system.
• Excel financial models.
• Excel dashboard designing.
• Excel Solver.
• Microsoft Access.
• Excel calculators.
• Excel vba.
• Excel Tracker.
• Excel macro's.
• Visualizations, Chart's, Table's.
• word macro's.
I have ability to do your project within your deadline, I need some discussion to make the things clear.
Thanks.
Hello, I'm Russel,
I can provide you perfect work as you looking for .
we can discuss more in chat .
I will be waiting for your response .
I have very great experience about your project , if you want discuss more please send me a text
Thank you
"Hi there,
I have read your project description carefully and I would like to work with you on this project. I have well experience in data entry work like data copy from the website and make it an excel file.
Feel free to ping me so we can discuss further details. I am looking forward to hearing from you. I am ready to do some free sample for you
Regards,
Data Express"
Hello Sir,
Contact me. I have read your requirements and willing to work for you. My Experties are in MATLAB, EXCEL, Data Entry, Programming and Circuit Designing using Proteus, Etap, Power World Simulator
hey, I AM READY TO START WORK NOW! Dear Prospective Client, Believe me, I am the person for this job. I am contacting you for one simple reason - you deserve the very best. I am a versatile and experienced writer with a vastly impressive general knowledge. I go extra lengths to add that touch of pure magic to my works leaving my clients delightfully satisfied. I strongly believe in honesty, excellence and quality with prompt delivery. I am more than willing to render you these services but this is only possible if you avail me the opportunity. Looking forward to working with you. And never forget this: you deserve the very best! Thank you.
Hi, This is my first time on freelancer, so please excuse me if I am not doing a right proposal.
I am used to develop some VBA modules in excel to make operations. It sounds you need a formula as there will be more tabs in the time and you would have to change a fixed formula each time you add a tab. Maybe I forgot something but this function does not seams to be very difficult to make.
