Excel Percentage Data Entry
$250-750 USD
Posted 1 minute ago
•
Ends in 6 days
$250-750 USD
Paid on delivery
I have a dataset of numeric values that all represent percentages and need them entered into Excel with the proper Percentage number format applied throughout. Every figure you see in the source files must appear in the workbook exactly as provided, simply translated into percentage form so calculations and charts behave correctly from the start. At this stage I have not finalised any specialised data-validation rules, so feel free to recommend sensible checks that prevent accidental text entries, out-of-range percentages, or blank cells slipping through; if we agree on a rule set I’ll ask you to add it before hand-over. Deliverables • One Excel workbook containing all supplied numbers, consistently formatted as percentages • (If agreed) Data-validation rules documented and active in the sheet so future updates stay clean Once the file looks right, a quick review with me over screen-share or annotated screenshots will close the project.
Project ID: 40763540
About the project
2 proposals
Open for bidding
Remote project
Active 26 secs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
2 freelancers are bidding on average $313 USD for this job


Hello, "Consistently percentage-formatted Excel workbook" - the key is preserving every source value exactly while ensuring Excel interprets percentages correctly for calculations and charts. I'll transfer all supplied figures into a clean, organized workbook, apply consistent percentage formatting, and check the entries against the source files to catch omissions or unintended changes. I'll also recommend sensible validation rules for future entries, with clear limits agreed before applying them. One important detail: should a source value of 25 appear as 25%, or is it stored as 0.25 and intended to display as 25%? Thanks for your consideration. THANKS


Each Excel percentage will be stored as its true fraction and shown with the Percentage format. For example, a source figure of 12.5 will display as 12.5% and calculate as 0.125 in formulas and charts. The first milestone is 75 USD, part of the 375 USD total. It covers your first source file, entered and formatted, plus a cell-by-cell comparison log. It is accepted when every value matches the source exactly. The remaining 300 USD is the next milestone, after you accept that checkpoint. It covers the rest of the dataset and a proposed validation rule set: numbers only, no blank cells and a range you confirm. The rules will be documented on a separate sheet and switched on once you approve them. Two revision rounds are included. For the final review, I will send annotated screenshots and a written change note here in chat, so you can check everything at your own pace. Please share the source files so I can start. Price: 375 USD fixed · Timeline: 8 working days from access/brief Konrad
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗