The project goal is to consolidate different files of the same microsoft spreadsheet into a single consolidated spreadsheet.
The scenario will be two tools and two kind of target users:
- XLS Form to be filled by approx 100 users twice a year;
- Microsoft XLS with a macro that would fetch all the filled forms at a specific moment and consolidate data into a single new tab/spreadsheet; this xls will be used by no more than 4 users;
For mainteinability, the consolidation logic must be located at the spreadsheet and not a various XLS forms (spread for more than 100 people). It must comprises of:
1. Provide a button/trigger to start the consolidation;
2. when clicked, asked user to inform a directory to scan ms xls forms documents;
3. when submited, create a new work-sheet at the same spreadsheet having the current date (DDMMYYY_HHMM) into its name;
3. the algorithm must scan this directory and all subdirectories and, for each XLS found it must bring data to the target worksheet following certain rules:
a. data are those located in green or yellow cells; all of them must be consolidated at the target consolidation spreadsheet;
a. each form will fill in a new line at the worksheet;
b. each field (only form fields) will be a column at the spreadsheet;
c. column name must be consistent with form information.
d. form fields:
- text type: text must be filled at corresponding target worksheet cell;
- selection list: the corresponding value (not label) must be filled at corresponding target worksheet cell;
- selection list (Yes/No): 0 or 1 must be filled at the corresponding target worksheet cell;
- lock the forms cell that aren´t destinated for input (all, except yellow);
- lock the entire form spreadsheet and allow input only in yellow fields (no changes in layout as well);
- make the spreadsheet printable in A4 format (all content must be able to be read).
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
Petaling Jaya, Malaysia
I am a talented Bookkeeping open to accept and take up any Bookkeeping or Copy Typing jobs you have. I have strong knowledge in the Bookkeeping and Copy Typing field. I have also worked as a Copywriting Freelancer and as a Data Entry Worker for many years. My skills will prove to be beneficial to your jobs. If outsourced by you for your project I will strive for excellence with my continued efforts.
My name is Conrad Gillard and I am new to Freelancer, but not new to business. I have extensive experience in programming with VBA and MATLAB. My background is that I have studied and worked as a Chemical Engineer. I have always enjoyed and had an interest in programming. As a result I have helped many colleagues when they needed to process data in VBA. I had so much positive feedback from my colleagues that I decided to join FreeLancer to apply my skills to other projects. I plan to initially place very low bids, in order to gain a good reputation. Please do not misinterpret this as an indication of low quality, as I assure you that I will exceed your expectations.
Newe Yamin, Israel
I am a serious and hardworking person. I have knowledge of MS Office, Admin works, also a specialist in Data entry. I am a dedicated person to produces quality work in a timely manner. I pay close attention to details and ensure that all work submitted is professional and accurate
I have 10+ years in experience in Data Analytics and Business Intelligence. Advanced Excel and analytics.
I am a talented and experienced BPO Executive looking to be hired. In my work experience I have versatility as a Call Center working on many different projects. I also have exemplary skills in the areas of Data Entry, Excel and Microsoft Office. I will try to put in my best foot and help you in accomplishing your goals to reach your targeted task. I will involve myself sincerely in your team and can handle as an autonomous person too. You can trust on me for any of your assignments and I will deliver the result in a prompt manner. I am looking forward to be outsourced by you.
Hi, I am master in excel, word, i have 5 yrs experience in web scrapping.
I want to prove my ability to do work here.I know that freelancer.com is very trustful site for freelancer.So I want to do work here with Web Design and SEO. I want to create goal in this field. i am an expert web Designer and comfortable to work in web developing. I am here ready to take higher challenge. I believe in perfect but an easy solution and i hope my client will get both from me as the best service.
Kalmunai, Sri Lanka
I have partly qualified in CIMA and qualified in Dip in Islamic banking and finance and Professional certificate in Logistics and supply chain
Lubuk Linggau, Indonesia
Comprehensive knowledge in Macro Excel Programming
Hello sir, i am a new user for freelancer i am working in My Home Industries Ltd as a Asst.Accounts Officer for Vizag Regional Office. My work profile will be like processing of orders and collections in our SAP platform and all accounting and administrative activities and we have godowns under my control and i need to take all inventory reports as well. Hence it is request you that i can do any inventory or accounts based work as well as any data entry work in Excel or Word. As i am very much perfect in excel formulas and all.