Web caclulators

slide_calc
Our clients often want both excel based calculator and web based calculator. Or they send us excel based calculator they already have and ask us to create web based calculator. That is why we have web developers in our team and our specialization in web development is calculators, grids and charts (dashboards). We use php + css + java script to create web calculators. It ca...
Read More

Converting PDF files to Excel

We convert scanned and searchable PDF files to excel. We prefer to use VBA programming and advanced custom excel functions to do pdf to excel converting job fast and with 100% accuracy. If you have 1000 pages pdf document (with similar structure of all pages) we will just create a program to process first page and then we will be able to process all document in one click. No ma...
Read More

Fuzzy Search

We use our custom vba programmed lookup functions in excel to match approximate duplicate entries. The custom lookup function allow to search the best match for string value in any database (people names, company names, addresses, etc). If there is 100% match value, it will be found. If there is no 100% match value, the best approximate match will be found. Also there is a func...
Read More

Advanced Excel Formulas to Split Names, Addresses and Phones

We use advanced excel formulas with custom vba programmed functions to split string data into columns. For example to split string with names and phones to First Name, Last Name and Phone columns: [swf:http://xlbin.com/wp-content/uploads/2012/02/aefsnp.swf 595 359] http://xlbin.com/wp-content/uploads/2012/02/aefsnp.swf Advanced excel formulas also can be used to split addre...
Read More