
Tamamlandı
İlan edilme:
Teslimde ödenir
I need an Excel expert to help create financial calculations. My primary need is for assistance in matching two rows of data. Ideal Skills and Experience: - Proficient in Excel, especially in creating complex formulas and functions - Strong understanding of financial calculations - Experience with data manipulation and row matching Please provide examples of similar work done. Looking forward to your bids! Review the attached table and calculate Qty-B and Rate-B with the following rules: 1. Amount-B must match Amount-A exactly (difference = 0 or less than 1). 2. Qty-B must be limited to a maximum of 3 decimals. 3. Rate-B can be changed but only in multiples of ₹0.50 per kg (i.e., multiples of ₹50 per MT). 4. You can adjust both Qty-B and Rate-B but keep changes minimal. 5. Final output must be a clean table containing: - Description - Qty-A - Rate-A - Amount-A - Corrected Qty-B (3 decimals max) - Corrected Rate-B (in ₹0.50 multiples) - Final Amount-B = Amount-A exactly ( not more than Rs1.) Do not change Amount-A. Your goal is to achieve perfect zero difference between Amount-A and Amount-B. .
Proje No: 40056680
17 teklifler
Uzaktan proje
Son aktiviteden bu yana geçen zaman 3 ay önce
Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir

Hello! I have analyzed your rules for calculating Qty-B and Rate-B and I can guarantee a solution with perfect precision (Difference < 1) as you requested. My Technical Approach: Instead of manual guessing, I apply a mathematical optimization algorithm to process your data: 1. It iterates through valid Rate-B values (multiples of ₹0.50). 2. It calculates the exact Qty-B (rounded to 3 decimals) needed to match Amount-A. 3. It selects the combination that yields the mathematical minimum error (closest to zero). Proof of Capability: Since I am new to this platform, I am happy to process a sample of 10 rows from your file for free right now via chat. This way, you can verify that my output meets your "clean table" requirement perfectly before awarding the project. I am ready to start immediately. Best regards, Juan Rangel
₹1.500 INR 1 gün içinde
0,4
0,4
17 freelancer bu proje için ortalama ₹1.130 INR teklif veriyor

Hello I have several years of experience with Excel macros and functions, including financial functions. I am interested in your project, but description mentions attached file, while there are no attached file yet. And description refers to attached file many times, could you share ? Thanks.
₹1.002 INR 1 gün içinde
6,0
6,0

Dear Client, Let’s get started right away!!! Feel free to chat with me anytime. I’m a ⭐5-star rated freelancer with strong expertise in Excel and financial calculations, and I’ve completed 1000+ projects across multiple platforms with 7+ years of experience. I can accurately match your two data rows by adjusting Qty-B (max 3 decimals) and Rate-B (₹0.50 multiples), ensuring Amount-B matches Amount-A with zero difference, and deliver a clean final table with all corrected values. Best regards
₹2.900 INR 1 gün içinde
5,5
5,5

I am an Excel specialist with extensive experience in creating complex formulas and performing precise financial data manipulation. I have carefully reviewed your project description. I understand that you need to align Amount-B with Amount-A exactly while adhering to strict constraints: limiting Qty-B to 3 decimals and ensuring Rate-B only moves in multiples of ₹0.50. I am ready to start immediately and can deliver the corrected table quickly to ensure your data is perfectly matched.
₹1.050 INR 3 gün içinde
2,1
2,1

Hello, I can help you create a clean and accurate Excel solution where Qty-B and Rate-B are automatically adjusted to match Amount-A (difference ≤ ₹1), following all your rules: - Qty-B restricted to 3 decimals - Rate-B adjusted only in ₹0.50/kg (₹50/MT) multiples - Amount-B matches Amount-A exactly - Clean final output table with all corrected values - No change to Amount-A - Minimal, controlled adjustments to both Qty-B and Rate-B I have strong experience in building financial & commercial logic sheets, including precision rounding, MROUND-based corrections, and automated calculators. I can also automate the process using formulas or Goal Seek/Solver so that future rows can be corrected instantly. Looking forward to working with you! Regards, Dhivya
₹1.200 INR 1 gün içinde
0,0
0,0

As an IT Specialist and Data Analyst with more than a decade of experience under my belt, I'm equipped to handle your Excel financial calculations with efficacy. My expertise lies in creating complex formulas and functions, which plays perfectly into augmenting data to meet specified criteria. You can rely on me to polish your dataset and produce desired results with a microscopic eye for detail. Beyond proficiency in Excel, I have a profound understanding of financial calculations, ensuring not just mere matching of two rows of data but achieving a perfect zero difference between Amount-A and Amount-B. My success hinges on my acute problem-solving skills and knack for designing smart, automated solutions that execute tasks quickly without compromising on accuracy - exactly what your project warrants. Moreover, I'm no stranger to large-scale data manipulation, making me adept at taking strategic decisions while keeping potential changes minimal. Trusting me with your project means you get both technical precision and robust reliability; traits guaranteed to transform your spreadsheet into a lean, clean table that aligns with all your requirements. So let's dive right into it and bring balance to your financial realm!
₹600 INR 1 gün içinde
0,0
0,0

I have 3 years of experience in data entry. So that I can complete your project very easily with correct data and make your satisfaction for giving me this project.
₹1.050 INR 7 gün içinde
0,0
0,0

Hello Client, I’m an Excel specialist with strong experience in financial computation, data cleaning, and formula-based value adjustments, and I would love to work on this project. Your requirement to force-match Amount-A and Amount-B without changing Amount-A fits perfectly with the kind of Excel reconciliation tasks I handle.I can deliver fast, accurate, and clean results. Let’s start and get this completed with perfect precision! Best regards, Deepak
₹1.350 INR 2 gün içinde
0,0
0,0

I need an Excel expert to help create financial calculations. My primary need is for assistance in matching two rows of data. Ideal Skills and Experience: - Proficient in Excel, especially in creating complex formulas and functions - Strong understanding of financial calculations - Experience with data manipulation and row matching
₹1.050,33 INR 7 gün içinde
0,0
0,0

I’m very interested in assisting with your project to match and correct your financial data in Excel. While I’m new on Freelancer.com, I have strong proficiency in Excel, including complex formulas, functions, and data manipulation. I pay close attention to detail and understand the importance of matching Amount-A exactly while making minimal adjustments to Qty-B and Rate-B according to your rules. I am confident I can provide a clean, accurate table with: Corrected Qty-B (up to 3 decimals) Corrected Rate-B (in ₹0.50 multiples) Final Amount-B matching Amount-A exactly I would be happy to start with a sample calculation to demonstrate my approach and accuracy. I am committed to delivering high-quality work promptly and professionally. Thank you for considering my bid. I look forward to the opportunity to help you complete this project. Reply within few hours
₹900 INR 1 gün içinde
0,0
0,0

Hi, I'm Muhammad, a seasoned Full-Stack Developer ready to tackle your Excel financial functions project. I am intimately familiar with Excel and its powerful formulas and functions. I often work with large sets of data and have expertise in data manipulation, making me the ideal candidate for your task of matching two rows of data. Let me present my experience: although my focus has been largely on web application development, my proficiency in Excel has consistently served as an additional advantage in my role for over 7 years. Besides, I've honed strong analytical and problem-solving skills that have improved my efficiency in finding optimal solutions to complex tasks like yours. Let's have a quick chat to discuss more in detail. I am looking forward to hearing from you. Best, Sajid.
₹1.050 INR 7 gün içinde
0,0
0,0

Hello sir, I saw your project and I can assist you with Excel and data entry tasks accurately and quickly. I have good experience with Excel formulas, formatting, and data organization. I will deliver clean, error-free work within the deadline. I am ready to start immediately. Please send me a message so we can discuss the details. Thank you!
₹800 INR 2 gün içinde
0,0
0,0

Hello Sir, I can help you create a robust Excel solution to match your two rows of financial data according to the rules you’ve outlined. My approach will ensure that Amount-B matches Amount-A exactly, while adjusting Qty-B and Rate-B minimally and keeping all values within your specified constraints. What I will deliver: A clean Excel table with: Description Qty-A, Rate-A, Amount-A Corrected Qty-B (maximum 3 decimals) Corrected Rate-B (multiples of ₹0.50 per kg / ₹50 per MT) Final Amount-B exactly matching Amount-A Formulas to automatically calculate the corrected Qty-B and Rate-B while keeping the difference to zero. Minimal adjustments to Qty-B and Rate-B, maintaining data integrity. Easy-to-use structure so you can apply the same logic to future datasets. Why me: Expert in Excel formulas, financial calculations, and data manipulation. Experienced in row matching and reconciliation tasks for financial datasets. Focus on accuracy, clean presentation, and audit-ready outputs. Examples of similar work: Matching purchase orders to invoices to ensure totals match while adjusting quantities/prices minimally. Reconciling sales and production reports with formula-driven corrections for exact totals. Creating financial reconciliation sheets to ensure all numbers are traceable and precise. I can start immediately and deliver a fully functional, error-free Excel file ready for your review. Best regards, Punna Shiva Rama Krishna
₹1.050 INR 7 gün içinde
0,0
0,0

Hi! I’m an Excel & financial functions expert. I’ll make Amount‑B match Amount‑A, adjust Qty‑B to 3 decimals, and Rate‑B in ₹0.50/kg increments with 100% accuracy. Fast, clean, and reliable delivery. Ready to start immediately!
₹1.000 INR 2 gün içinde
0,0
0,0

Yes I will done it i will match all your rates and quantity and manage well in excel and will do better job
₹1.050 INR 7 gün içinde
0,0
0,0

As an Excel specialist with a keen eye for detail and a deep understanding of financial calculations, I am well-equipped to handle the complexities of your project. My past work experiences have allowed me to develop a strong proficiency in creating complex formulas and functions in Excel which has enabled me to manipulate data with ease and accuracy. I have worked on numerous projects where precision is crucial, just like your assignment. In these projects, I maintained strict adherence to specific guidelines and always ensured that my outputs are free from errors. Your requirement of matching two rows of data exactly aligns with my expertise, guaranteeing a thorough and meticulous approach to your project. I'm also fully aware of the need for simplicity and efficiency when dealing with large amounts of data, thus I will ensure your final table is clean and easy to analyze. Choosing me as your Excel Financial Functions Specialist would enable you to leverage my expertise to achieve perfect zero difference between Amount-A and Amount-B while also complying with all other assignment rules. I look forward to contributing greatly to your success! I also worked for a company, but in your assignment you wrote that the amount B must match A od deviate by 0 or 1. But l don't see the amount of either A or B anywhere. And what you are looking for in the task, l know how to calculate and much more...
₹1.050 INR 7 gün içinde
0,0
0,0

I’m confident I’m the ideal candidate for your Excel Financial Functions project due to my strong analytical skills, deep understanding of financial calculations, and extensive experience building accurate, automated, and user-friendly spreadsheets. Whether you need help fixing formulas, building a full financial model, automating calculations, or improving an existing spreadsheet, I can deliver a polished and reliable solution.
₹600 INR 5 gün içinde
0,0
0,0

Guntur, India
Ödeme yöntemi onaylandı
Ara 11, 2025 tarihinden bu yana üye
₹600-1500 INR
minimum ₹2500 INR / saat
$30-250 USD
$10-30 USD
₹12500-37500 INR
$2-8 USD / saat
₹1500-12500 INR
€6-12 EUR / saat
$8-15 USD / saat
$250-750 USD
$15-25 USD / saat
₹1500-12500 INR
$10-30 USD
₹12500-37500 INR
$10-30 USD
$30-250 USD
₹1500-12500 INR
£10-20 GBP
₹1500-12500 INR
₹750-1250 INR / saat