Thank you Sean, from Inflexon Point for this feedback blog. We always love to hear from Happy Customers! – Team Collatebox.
It’s that time of the year when the HR department is buzzing with activity! New recruits need to be brought in, lots of training needs to be done and we have just started. I’ve set out on the task with a team of six that verify the qualification of candidates for interviews through an offline communication channel.
With candidates spread across 3 major skill categories and 4 grades, we had 12 unique sets of candidates to be called and the 6 of us picked two sets each.
Once we set out to the task, we needed all our information to be in the same format because at the end of the day everything had to be collated into one Master Sheet that was the complete candidate database. So, I made 6 sheets every morning and one of us took turns collating the information back in the evening. The job of collation... well… lets just say that the ‘Ctrl’, ‘C’ and ‘V’ keys lost their identity by the end of the week!
Copying the data from each set into the master, sorting and collating according to the categories and sets, harmonizing the format in which the data has been collected! One might say you managed to share the data well, but the amount of productivity and time lost on collaborating does not make my heart sing.
I started to dream of an option where I could just open the Master Sheet, create some sort of Named Ranges based on Data Filters (if possible) and just with a click of a button share these ranges with my colleagues! There would be no need to collate the data at the end of every day, as the updates to the Name subsets would be like updating the master.
That was when I came across the blessing that is the online service “CollateBox.com”. It allows you to filter your data and remembers the filters through something called Views. It then allows you to share these Views with others. The data that a shared user works on, lands back into the Master. It made the whole HR department’s life easier! With all the time saved from collating, the productivity of the whole department increased by x% and helped me get into the management’s good books. ;)
CollateBox made me realize that I wasn’t just building castles in the air. The data was neater, clearer and more accurate. It was really easy to handle for those of us who aren’t Excel Gurus. Thank you CollateBox for making me employee of the month! :)