Recent Posts: ADP (CDK Global) Technical
CDK letter explaining the end of Telnet
Start Collecting Your Dealership’s Data So You Can Understand & Improve Your Store’s Results – Reposted
This is a re-post of my post on ADP (CDK Global) Expertise today.
Recent Posts: Auto Dealership Group Management
TagsADP Apps for Excel ASC Automotive Systems Consulting BAI BAI2 Bank File Bank FIle Conversion App for Excel BFC BI BTRS CDK Global Excel 2013 Excel Data Model Inventory Management Management Objectives MDA Microsoft MIS M language PowerPivot Power Query SQL Server summary Used Vehicle Department Winners Circle XML XQuery
Category Archives: Apps for Excel
In a previous post, I showed how to use the Bank File Conversions App for Excel 2013 (BFC) to: convert BAI Version 2 and BTRS files, set the data in tables in Excel 2013, add them to the Excel Data Model … Continue reading
The purpose of this post is to give users (or prospective users) an idea of the benefits of storing their bank data in SQL Server (2005 or greater) as an XML data type. In particular converting BAI and BTRS files … Continue reading
Bank File Conversion App for Excel 2013 (BFC) is designed with PowerPivot in mind. In fact, the three outputs provided by the conversion (Excel Tables, XML and CSV) are readily imported into PowerPivot for further analysis. This post uses a sample workbook … Continue reading
A quick overview of the Bank File Conversion App for Excel 2013 allowing BAI V2 and BTRS bank files to be securely converted to Excel tables, CSV text blocks and validated XML.
Automotive Systems Training (AST) has some exciting news to share with all of you who interact with bank data. AST released an App for Excel to the Microsoft Store which was approved last week. You can purchase this app here at an introductory price. … Continue reading