Bulk Product Data Entry
Budget: ₹600 – ₹1,500 INR
I need a streamlined Excel workbook that will calculate each employee’s monthly pay directly from the base-salary figures stored in our database. The file should open, refresh the connection, pull the latest salary table, and instantly populate a clean payroll sheet with totals for every employee.
Scope
• Build or adapt an .xlsx file (no macros if they’re not essential; VBA is fine if it keeps the process one-click).
• Configure the database connection so I can point the workbook at our SQL server credentials and refresh securely.
• Insert all formulas or Power Query steps required to compute the gross figure from Base salary only. At this stage I’m not adding bonuses or deductions, but please leave the structure expandable so those components can be slotted in later without a full rebuild.
• Present results in a printable, month-ready summary tab.
Acceptance
The workbook must refresh without errors, show identical numbers to a test dataset I will supply, and run on standard Excel 2016+ without add-ins.
Scope
• Build or adapt an .xlsx file (no macros if they’re not essential; VBA is fine if it keeps the process one-click).
• Configure the database connection so I can point the workbook at our SQL server credentials and refresh securely.
• Insert all formulas or Power Query steps required to compute the gross figure from Base salary only. At this stage I’m not adding bonuses or deductions, but please leave the structure expandable so those components can be slotted in later without a full rebuild.
• Present results in a printable, month-ready summary tab.
Acceptance
The workbook must refresh without errors, show identical numbers to a test dataset I will supply, and run on standard Excel 2016+ without add-ins.