Skip to content

PULSE INFOMATICS

Business Automation, Workflow, & Analytics Consulting

  • HOME
  • SERVICES
  • CONTACT
  • ARTICLES
  • Menu

Tag Archives: application

Custom Reports using Excel and SQL Server from Time Plus payroll software

Posted on July 24, 2015July 24, 2015 by Matthew Moran

Technology   SQL Server Microsoft Excel Time Plus Payroll Software   The Challenge One of our clients needed a custom 401k report. They were manually creating the report using data in canned/available reports. We wrote a custom script to extract the data, pull it into Excel in the format required, and save the file with […]

Continue reading→
Learn how to automate using Visual-basic for Applications

Recent Posts

  • Using Google App Scripts for contract assembly and save as PDF documents
  • How to use Google App Scripts to send HTML emails from Google Sheets with Airtable Data
  • Airtable Reporting Dashboard using Google Apps Script, Google Big Query and Google Data Studio
  • Airtable Database Systems: The Good, The Bad, and the Ugly (really ugly)
  • Excel VBA Google Distance Matrix API and Google Static Map Image API
  • Solving line breaks and other unstructured data when importing CSV files
  • How I check if optional parameters were passed to a c# method
  • Updated: Microsoft Excel VBA and Google Maps to calculate distances and time from multiple locations

Categories

Pulse Infomatics: Software Development, Office Automation, Technology Consulting