
Đã đóng
Đã đăng vào
Thanh toán khi bàn giao
I have a set of source documents that contain both narrative details and numeric figures, all of which must be transcribed into a Google Sheets workbook designed for ongoing financial tracking. Every row will hold mixed data—descriptive text in some columns, numbers in others—so accuracy on both fronts is critical. Beyond clean data entry, the sheet must automatically calculate key performance indicators using the built-in IRR and NPV functions. Once the records are in place I should be able to adjust any cash-flow figure and see the updated returns instantly, so please structure the worksheet with clear cash-in, cash-out and date columns linked to those formulas. Deliverables • Fully populated Google Sheets file with all source data entered exactly as provided • Correctly configured IRR() and NPV() formulas referencing dynamic cash-flow ranges • Quick note inside the sheet (or a short Loom clip, if you prefer) explaining where to add future transactions without breaking the calculations I’ll share the raw files and a field-by-field mapping right after kickoff. Let me know your estimated turnaround and any clarifying questions before you start typing.
Mã dự án: 40308560
7 đề xuất
Dự án từ xa
Hoạt động 1 tháng trước
Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
7 freelancer chào giá trung bình ₹17.893 INR cho công việc này

With my diverse background in Web Scraping, Web Automation and coding useful scripts over the past 7 years, I bring an extensive set of skills to this project. Having worked with major corporations like Metlife GOSC, DXC technologies and Elite Services, I have sharpened my abilities to handle complex data manipulations at scale, saving valuable time and effort for both employers and businesses. My experience involves using Excel Formulas, VBA, Macros - exactly what you need for this task to ensure accurate numeric and narrative data entry. Moreover, I have a deep understanding of Google Sheets and its functions like IRR() and NPV(). I am adept at not only entering data accurately but also creating sheets with logical column structure so that your future adjustments can be made easily without breaking any calculations. I understand how vital it is for the financial records to be precise and scalable so that calculations can be tracked efficiently. For your added convenience, I assure you a detailed explanation on where to add future transactions without disturbing the complex formulae.
₹25.000 INR trong 7 ngày
8,6
8,6

Hi, I can handle this in Google Sheets with a strong focus on both entry accuracy and reliable financial calculation setup. From your description, the work involves two parts: first, entering all narrative and numeric data exactly as provided into the tracking sheet; second, structuring the cash-flow section so IRR and NPV update automatically whenever future transaction values are changed. My approach: enter all source data carefully into the mapped Google Sheets structure keep descriptive and numeric fields clean and consistent set up clear cash-in, cash-out, and date columns configure IRR()/NPV() formulas against dynamic ranges so future updates flow through correctly include a short note in the sheet showing where to add new transactions without breaking calculations Why I’m a strong fit: Strong hands-on experience with Excel/Sheets-based structured data work Comfortable building practical spreadsheet logic for ongoing use Detail-focused approach to validation, formatting, and formula reliability A few quick scope checks: Will the cash flows occur at regular intervals, or do you need date-based return logic for irregular timing? Approximately how many source documents / rows are involved? I can deliver a clean Google Sheet that is ready for ongoing financial tracking immediately after handoff. Deepanshu
₹15.000 INR trong 7 ngày
3,6
3,6

Hello! I can transcribe all narrative and numeric data into a clean Google Sheets workbook with 100% accuracy and proper field‑by‑field mapping. I’ll set up dynamic IRR() and NPV() formulas linked to flexible cash‑in, cash‑out and date columns so your financial metrics update instantly. Once the structure is ready, I’ll add all source records exactly as provided and make sure the calculations never break. I can also include a short note or Loom-style walkthrough showing exactly where to add future transactions.
₹14.000 INR trong 7 ngày
3,1
3,1

I see that you need precise transcription of both narrative details and numeric figures into a Google Sheets workbook for financial tracking, along with automated calculations for IRR and NPV. Your emphasis on accuracy and dynamic updates to cash-flow data is clear and important. You require a fully populated Google Sheets file that not only contains all your source data exactly as provided but also incorporates IRR() and NPV() formulas linked to cash-in, cash-out, and date columns for instant recalculations. Additionally, you want a simple guide within the sheet or a Loom clip explaining how to add future transactions without disrupting the formulas. I’ve built financial tracking sheets with dynamic IRR and NPV computations before, ensuring that cash-flow inputs can be adjusted on the fly and results update automatically. In one project, I structured sheets to handle mixed text and numeric data cleanly while maintaining formula integrity, which aligns well with your needs for accurate data entry and real-time financial modeling. I can complete this within 3 days after receiving your source files and mapping details. Feel free to share any questions or clarifications before I start inputting the data.
₹13.750 INR trong 7 ngày
0,0
0,0

I’ll take your source documents and carefully enter all the data, both text and numbers into a clean, well-organized Google Sheet. I’ll make sure everything matches exactly, with no typos or misplaced values and that each column (like dates, cash in, cash out, and descriptions) is clearly structured. Once the data is in place, I’ll set up simple formulas using IRR and NPV so the sheet automatically calculates your returns. This means whenever you update or add a new cash-flow entry, the results will instantly refresh without you needing to do anything extra. I’ll also keep the sheet easy to use going forward—so adding new rows won’t break the formulas. To help with that, I’ll include a short note inside the sheet explaining exactly where and how to add future data safely. You’ll receive a fully ready-to-use sheet that’s accurate, dynamic, and simple to maintain. Estimated turnaround will depend on the volume of data, but I can start immediately once you share the files.
₹30.000 INR trong 7 ngày
0,0
0,0

Hello, I am new to Freelancer, and I am trying to book my first gig. I am efficient and detail-oriented, and I will charge a low rate for services rendered. I look forward to hearing from you, and thanks for considering me!
₹12.500 INR trong 7 ngày
0,0
0,0

Hello, I can help you accurately transfer your source documents into a well-structured Google Sheets workbook with dynamic financial calculations. I have strong experience in data entry as well as building spreadsheets with functions like IRR() and NPV(). I will ensure: • Precise entry of both narrative and numeric data without errors • Properly structured cash-in, cash-out, and date columns • Correct setup of IRR and NPV formulas with dynamic ranges for real-time updates • A clean, easy-to-use sheet for ongoing financial tracking I will also include a short note (or Loom video) explaining how to add future data without affecting calculations. I’m detail-oriented, reliable, and can deliver within your required timeline. Ready to start as soon as you share the files. Best regards, Samriti G.
₹15.000 INR trong 7 ngày
0,0
0,0

Shimla, India
Thành viên từ thg 6 28, 2025
$10-30 USD
$10-30 USD
$250-750 USD
$15-25 USD/ giờ
₹1500-12500 INR
$250-750 USD
$250-750 AUD
$30-250 USD
$10000-20000 USD
£10-15 GBP/ giờ
$10-30 USD
₹12500-37500 INR
$30-250 USD
$30-250 USD
$250-750 USD
$250-750 USD
$30-250 AUD
$15-25 USD/ giờ
$30-250 USD
$250-750 AUD