Đã hoàn thành

135233 Excel scripting

I've got a simple Excel spreadsheet that I use to keep track of the schedule of contractors working for me. Each row is a separate job, while there is a column for each contractor. If a contractor has worked on a specific job a dollar value appears in his column.

I need to take this spreadsheet and generate a separate spreadsheet for each contractor that is populated with the data from each job they worked on.


* I need to be able to add or remove contractors without breaking this functionality. You can change the original spreadsheet as long as it maintains it's current functionality.

* You can choose a scripting language (in order of preference): Python, Ruby, Perl, VBS. If you would prefer another language please ask. I don't want to use a compiled language, Java or a Visual Basic "binary". VB Script is acceptable. I need a script I can maintain.

* You must be proficient in Excel.


If you can suggest improvements to the original spreadsheet we can discuss compensation for those improvements.

See the two attached spreadsheets, [url removed, login to view] is the schedule, while [url removed, login to view] is an example of the spreadsheet that needs to be generated for each contractor.

Kĩ năng: Bất kì công việc gì, Perl, Python, Visual Basic

Xem nhiều hơn: simple binary, scripting job, ruby contractors, ruby contractor, java and excel, excel contractor, binary t, ask excel, vb in excel, perl scripting language, is ruby a scripting language, compiled language, python contractor, Visual Basic Excel, vb excel, simple excel, python perl, python excel, java+excel, java excel, excel visual basic, excel python, excel java, excel specific, excel row column

Về Bên Thuê:
( 1 Nhận xét ) Tempe,

ID dự án: #1881405

Được trao cho:


I've completed the script for you. Please see PMB for details.

$50 USD trong 1 ngày
(0 Đánh Giá)