Freelancer logo How It Works Browse Jobs
Log In Sign Up
Post a Project
Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$35 USD / hour
Flag of CANADA
huntsville, canada
$35 USD / hour
It's currently 8:14 AM here
Joined March 24, 2016
0 Recommendations

John H.

@jchham

 5.0 (3 reviews)
4.0
4.0
80%
80%
$35 USD / hour
Flag of CANADA
huntsville, canada
$35 USD / hour
100%
Jobs Completed
100%
On Budget
100%
On Time
N/A
Repeat Hire Rate

Custom programming, data recovery, website production, technical writing.

I write custom software for the PC, Mac, mini-computer and embedded microcontroller systems, from database applications to real-time analysis and control. I also do data recovery, website production, and technical writing. About Me I've worked with computers and microprocessors my entire career, writing software, building circuits, installing hardware (including business 'phone ACD systems), and teaching networking and telephony at the community college level. One of the first programs I ever wrote professionally was an implementation of the Data Encryption Standard (DES) in 8088 assembly-language on the first IBM PC, which I used to verify output of two hardware-based DES serial-data encryption devices I also built and tested. To upload and test the code before it became firmware, I also wrote a program monitor for the device by decompiling the monitor of a commercial circuit emulator. Those early experiences still resonate with me, and inform my work to this day.
Freelancer Visual Basic Developers Canada
See all Visual Basic Developers in Canada

Contact John H. about your job

Log in to discuss any details over chat.

Portfolio

3812774
This is a demonstration using Squarespace website as a front end for Google sheets form generation. A working demonstration can be provide on request This includes access to the connected Google Sheets spreadsheet that is updated in real-time with each form submission. In particular, this demonstration 1) implements data submission from a form block to a connected Google Sheets customized spreadsheet stored in the cloud; 2) modifies Squarespace's standard form block fields: in particular: - for both Time form fields, the subfield Second is hidden and set to zero - for both Number form fields, the width of the input is reduced to accommodate a maximum of 3 digits, optimized for both mobile & desktop - the narrowed Number form fields are placed beside one another on the form block, rather than one beneath the other 3) demonstrates Google Sheets form generation from data submitted using Squarespace as a fontend
Squarespace website customization with Google Sheets
4001673
Project Description: The client had an Excel workbook with VB macros that function as an app. He wanted it to be run as a Google app replacing the VB with GScript. The Excel application included a main form (created in the macro editor of Excel), and about 25 spreadsheets that were used by the application to print out the sheets as forms. The main form, which included multiple tabs, was used to collect data that was then used to populate the printable spreadsheets, and to select which sheets to print. One of the sheets saved the data entered into the main form. The project involved importing all the spreadsheets into Google Sheets, and creating a Google web application that duplicated the client's original Excel form. This included implementing all the VBA macro code as Google script (Javascript) and implementing the printing function using Google Cloud printing. The image shown is a screen-capture of the duplicated web form.
Convert Excel VBA Form to Google Apps Script & Sheets
3794026
The following images illustrate importing POS credit card purchase data from an Excel data file into QuickBooks Desktop Pro using the QuickBooks SDK 13.0. Importing via the SDK was verified by the program TestSDKPlus3.exe, provided by QuickBooks, using input from XML files populated with data from rows of the Excel file. This example shows the import of a credit card charge of $250.29. The amount is charged to the account 51043 David, a sub-account of Amex SPG 51001. The first image shows the Excel data to be imported. In this example, the import data comes from Row75. The next image shows a partial list of the accounts and sub-accounts to which credit card charges can be applied. In this example, account 51043 David, a sub-account of Amex SPG 51001 is used. The third and fourth images show the results of import of the data as described above, with respect to the accounts. The last two images show the same results, with respect to the vendor Default Vendor.
QuickBooks SDK 13.0 Import of POS data from Excel file
The following images illustrate importing POS credit card purchase data from an Excel data file into QuickBooks Desktop Pro using the QuickBooks SDK 13.0. Importing via the SDK was verified by the program TestSDKPlus3.exe, provided by QuickBooks, using input from XML files populated with data from rows of the Excel file. This example shows the import of a credit card charge of $250.29. The amount is charged to the account 51043 David, a sub-account of Amex SPG 51001. The first image shows the Excel data to be imported. In this example, the import data comes from Row75. The next image shows a partial list of the accounts and sub-accounts to which credit card charges can be applied. In this example, account 51043 David, a sub-account of Amex SPG 51001 is used. The third and fourth images show the results of import of the data as described above, with respect to the accounts. The last two images show the same results, with respect to the vendor Default Vendor.
QuickBooks SDK 13.0 Import of POS data from Excel file
The following images illustrate importing POS credit card purchase data from an Excel data file into QuickBooks Desktop Pro using the QuickBooks SDK 13.0. Importing via the SDK was verified by the program TestSDKPlus3.exe, provided by QuickBooks, using input from XML files populated with data from rows of the Excel file. This example shows the import of a credit card charge of $250.29. The amount is charged to the account 51043 David, a sub-account of Amex SPG 51001. The first image shows the Excel data to be imported. In this example, the import data comes from Row75. The next image shows a partial list of the accounts and sub-accounts to which credit card charges can be applied. In this example, account 51043 David, a sub-account of Amex SPG 51001 is used. The third and fourth images show the results of import of the data as described above, with respect to the accounts. The last two images show the same results, with respect to the vendor Default Vendor.
QuickBooks SDK 13.0 Import of POS data from Excel file
The following images illustrate importing POS credit card purchase data from an Excel data file into QuickBooks Desktop Pro using the QuickBooks SDK 13.0. Importing via the SDK was verified by the program TestSDKPlus3.exe, provided by QuickBooks, using input from XML files populated with data from rows of the Excel file. This example shows the import of a credit card charge of $250.29. The amount is charged to the account 51043 David, a sub-account of Amex SPG 51001. The first image shows the Excel data to be imported. In this example, the import data comes from Row75. The next image shows a partial list of the accounts and sub-accounts to which credit card charges can be applied. In this example, account 51043 David, a sub-account of Amex SPG 51001 is used. The third and fourth images show the results of import of the data as described above, with respect to the accounts. The last two images show the same results, with respect to the vendor Default Vendor.
QuickBooks SDK 13.0 Import of POS data from Excel file
The following images illustrate importing POS credit card purchase data from an Excel data file into QuickBooks Desktop Pro using the QuickBooks SDK 13.0. Importing via the SDK was verified by the program TestSDKPlus3.exe, provided by QuickBooks, using input from XML files populated with data from rows of the Excel file. This example shows the import of a credit card charge of $250.29. The amount is charged to the account 51043 David, a sub-account of Amex SPG 51001. The first image shows the Excel data to be imported. In this example, the import data comes from Row75. The next image shows a partial list of the accounts and sub-accounts to which credit card charges can be applied. In this example, account 51043 David, a sub-account of Amex SPG 51001 is used. The third and fourth images show the results of import of the data as described above, with respect to the accounts. The last two images show the same results, with respect to the vendor Default Vendor.
QuickBooks SDK 13.0 Import of POS data from Excel file
The following images illustrate importing POS credit card purchase data from an Excel data file into QuickBooks Desktop Pro using the QuickBooks SDK 13.0. Importing via the SDK was verified by the program TestSDKPlus3.exe, provided by QuickBooks, using input from XML files populated with data from rows of the Excel file. This example shows the import of a credit card charge of $250.29. The amount is charged to the account 51043 David, a sub-account of Amex SPG 51001. The first image shows the Excel data to be imported. In this example, the import data comes from Row75. The next image shows a partial list of the accounts and sub-accounts to which credit card charges can be applied. In this example, account 51043 David, a sub-account of Amex SPG 51001 is used. The third and fourth images show the results of import of the data as described above, with respect to the accounts. The last two images show the same results, with respect to the vendor Default Vendor.
QuickBooks SDK 13.0 Import of POS data from Excel file
3617344
Excel Gematria Calculator (non-English Unicode characters)
3617317
Demonstration of controlling legends, axis labels, etc. on multi-graph plots in R. Solution to project "Correction to a line graph code in R" (Project ID: 14942560) https://www.freelancer.com/projects/r/correction-line-graph-code-14942560/ The client provided R-code generating two uncorrected multi-graph plots,, and an example plot of what the corrections should entail. The images show the example provided, and the uncorrected & corrected multi-graph plots. Here is a link to video depicting a working demonstration of the modified code: http://bit.ly/2wbrBqH
Graphing datasets using R
Demonstration of controlling legends, axis labels, etc. on multi-graph plots in R. Solution to project "Correction to a line graph code in R" (Project ID: 14942560) https://www.freelancer.com/projects/r/correction-line-graph-code-14942560/ The client provided R-code generating two uncorrected multi-graph plots,, and an example plot of what the corrections should entail. The images show the example provided, and the uncorrected & corrected multi-graph plots. Here is a link to video depicting a working demonstration of the modified code: http://bit.ly/2wbrBqH
Graphing datasets using R
Demonstration of controlling legends, axis labels, etc. on multi-graph plots in R. Solution to project "Correction to a line graph code in R" (Project ID: 14942560) https://www.freelancer.com/projects/r/correction-line-graph-code-14942560/ The client provided R-code generating two uncorrected multi-graph plots,, and an example plot of what the corrections should entail. The images show the example provided, and the uncorrected & corrected multi-graph plots. Here is a link to video depicting a working demonstration of the modified code: http://bit.ly/2wbrBqH
Graphing datasets using R
2612510
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
3812774
This is a demonstration using Squarespace website as a front end for Google sheets form generation. A working demonstration can be provide on request This includes access to the connected Google Sheets spreadsheet that is updated in real-time with each form submission. In particular, this demonstration 1) implements data submission from a form block to a connected Google Sheets customized spreadsheet stored in the cloud; 2) modifies Squarespace's standard form block fields: in particular: - for both Time form fields, the subfield Second is hidden and set to zero - for both Number form fields, the width of the input is reduced to accommodate a maximum of 3 digits, optimized for both mobile & desktop - the narrowed Number form fields are placed beside one another on the form block, rather than one beneath the other 3) demonstrates Google Sheets form generation from data submitted using Squarespace as a fontend
Squarespace website customization with Google Sheets
4001673
Project Description: The client had an Excel workbook with VB macros that function as an app. He wanted it to be run as a Google app replacing the VB with GScript. The Excel application included a main form (created in the macro editor of Excel), and about 25 spreadsheets that were used by the application to print out the sheets as forms. The main form, which included multiple tabs, was used to collect data that was then used to populate the printable spreadsheets, and to select which sheets to print. One of the sheets saved the data entered into the main form. The project involved importing all the spreadsheets into Google Sheets, and creating a Google web application that duplicated the client's original Excel form. This included implementing all the VBA macro code as Google script (Javascript) and implementing the printing function using Google Cloud printing. The image shown is a screen-capture of the duplicated web form.
Convert Excel VBA Form to Google Apps Script & Sheets
3794026
The following images illustrate importing POS credit card purchase data from an Excel data file into QuickBooks Desktop Pro using the QuickBooks SDK 13.0. Importing via the SDK was verified by the program TestSDKPlus3.exe, provided by QuickBooks, using input from XML files populated with data from rows of the Excel file. This example shows the import of a credit card charge of $250.29. The amount is charged to the account 51043 David, a sub-account of Amex SPG 51001. The first image shows the Excel data to be imported. In this example, the import data comes from Row75. The next image shows a partial list of the accounts and sub-accounts to which credit card charges can be applied. In this example, account 51043 David, a sub-account of Amex SPG 51001 is used. The third and fourth images show the results of import of the data as described above, with respect to the accounts. The last two images show the same results, with respect to the vendor Default Vendor.
QuickBooks SDK 13.0 Import of POS data from Excel file
The following images illustrate importing POS credit card purchase data from an Excel data file into QuickBooks Desktop Pro using the QuickBooks SDK 13.0. Importing via the SDK was verified by the program TestSDKPlus3.exe, provided by QuickBooks, using input from XML files populated with data from rows of the Excel file. This example shows the import of a credit card charge of $250.29. The amount is charged to the account 51043 David, a sub-account of Amex SPG 51001. The first image shows the Excel data to be imported. In this example, the import data comes from Row75. The next image shows a partial list of the accounts and sub-accounts to which credit card charges can be applied. In this example, account 51043 David, a sub-account of Amex SPG 51001 is used. The third and fourth images show the results of import of the data as described above, with respect to the accounts. The last two images show the same results, with respect to the vendor Default Vendor.
QuickBooks SDK 13.0 Import of POS data from Excel file
The following images illustrate importing POS credit card purchase data from an Excel data file into QuickBooks Desktop Pro using the QuickBooks SDK 13.0. Importing via the SDK was verified by the program TestSDKPlus3.exe, provided by QuickBooks, using input from XML files populated with data from rows of the Excel file. This example shows the import of a credit card charge of $250.29. The amount is charged to the account 51043 David, a sub-account of Amex SPG 51001. The first image shows the Excel data to be imported. In this example, the import data comes from Row75. The next image shows a partial list of the accounts and sub-accounts to which credit card charges can be applied. In this example, account 51043 David, a sub-account of Amex SPG 51001 is used. The third and fourth images show the results of import of the data as described above, with respect to the accounts. The last two images show the same results, with respect to the vendor Default Vendor.
QuickBooks SDK 13.0 Import of POS data from Excel file
The following images illustrate importing POS credit card purchase data from an Excel data file into QuickBooks Desktop Pro using the QuickBooks SDK 13.0. Importing via the SDK was verified by the program TestSDKPlus3.exe, provided by QuickBooks, using input from XML files populated with data from rows of the Excel file. This example shows the import of a credit card charge of $250.29. The amount is charged to the account 51043 David, a sub-account of Amex SPG 51001. The first image shows the Excel data to be imported. In this example, the import data comes from Row75. The next image shows a partial list of the accounts and sub-accounts to which credit card charges can be applied. In this example, account 51043 David, a sub-account of Amex SPG 51001 is used. The third and fourth images show the results of import of the data as described above, with respect to the accounts. The last two images show the same results, with respect to the vendor Default Vendor.
QuickBooks SDK 13.0 Import of POS data from Excel file
The following images illustrate importing POS credit card purchase data from an Excel data file into QuickBooks Desktop Pro using the QuickBooks SDK 13.0. Importing via the SDK was verified by the program TestSDKPlus3.exe, provided by QuickBooks, using input from XML files populated with data from rows of the Excel file. This example shows the import of a credit card charge of $250.29. The amount is charged to the account 51043 David, a sub-account of Amex SPG 51001. The first image shows the Excel data to be imported. In this example, the import data comes from Row75. The next image shows a partial list of the accounts and sub-accounts to which credit card charges can be applied. In this example, account 51043 David, a sub-account of Amex SPG 51001 is used. The third and fourth images show the results of import of the data as described above, with respect to the accounts. The last two images show the same results, with respect to the vendor Default Vendor.
QuickBooks SDK 13.0 Import of POS data from Excel file
The following images illustrate importing POS credit card purchase data from an Excel data file into QuickBooks Desktop Pro using the QuickBooks SDK 13.0. Importing via the SDK was verified by the program TestSDKPlus3.exe, provided by QuickBooks, using input from XML files populated with data from rows of the Excel file. This example shows the import of a credit card charge of $250.29. The amount is charged to the account 51043 David, a sub-account of Amex SPG 51001. The first image shows the Excel data to be imported. In this example, the import data comes from Row75. The next image shows a partial list of the accounts and sub-accounts to which credit card charges can be applied. In this example, account 51043 David, a sub-account of Amex SPG 51001 is used. The third and fourth images show the results of import of the data as described above, with respect to the accounts. The last two images show the same results, with respect to the vendor Default Vendor.
QuickBooks SDK 13.0 Import of POS data from Excel file
3617344
Excel Gematria Calculator (non-English Unicode characters)
3617317
Demonstration of controlling legends, axis labels, etc. on multi-graph plots in R. Solution to project "Correction to a line graph code in R" (Project ID: 14942560) https://www.freelancer.com/projects/r/correction-line-graph-code-14942560/ The client provided R-code generating two uncorrected multi-graph plots,, and an example plot of what the corrections should entail. The images show the example provided, and the uncorrected & corrected multi-graph plots. Here is a link to video depicting a working demonstration of the modified code: http://bit.ly/2wbrBqH
Graphing datasets using R
Demonstration of controlling legends, axis labels, etc. on multi-graph plots in R. Solution to project "Correction to a line graph code in R" (Project ID: 14942560) https://www.freelancer.com/projects/r/correction-line-graph-code-14942560/ The client provided R-code generating two uncorrected multi-graph plots,, and an example plot of what the corrections should entail. The images show the example provided, and the uncorrected & corrected multi-graph plots. Here is a link to video depicting a working demonstration of the modified code: http://bit.ly/2wbrBqH
Graphing datasets using R
Demonstration of controlling legends, axis labels, etc. on multi-graph plots in R. Solution to project "Correction to a line graph code in R" (Project ID: 14942560) https://www.freelancer.com/projects/r/correction-line-graph-code-14942560/ The client provided R-code generating two uncorrected multi-graph plots,, and an example plot of what the corrections should entail. The images show the example provided, and the uncorrected & corrected multi-graph plots. Here is a link to video depicting a working demonstration of the modified code: http://bit.ly/2wbrBqH
Graphing datasets using R
2612510
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA
Income & Expense report generation using Excel with VBA

Reviews

Changes saved
Showing 1 - 3 out of 3 reviews
Filter reviews by:
5.0
$750.00 USD
Convert Excel VBA to Google Apps Script
John, did a great job, kept me informed of progress and was able to communicate any issue he ran into and a solution to solve. Asked good question to understand the project before he started working. I would hire John again for any future projects.
JavaScript
Visual Basic
Excel
Software Architecture
User Avatar
Flag of Joseph C.
@jcrostar
•
5 years ago
5.0
$250.00 CAD
Custom Code Project for John Ham
Great communication, asks for and implements feedback, great problem solver.
PHP
Data Entry
Excel
Software Architecture
HTML
J
Flag of Jason S.
@jsahlani
•
6 years ago
5.0
$100.00 USD
Visual Basics Code Writer
John was very good. He understood what we were looking for and turned the project around very quickly. We were very satisfied with the end result.
Visual Basic
L
Flag of Linda G.
@linda61363
•
6 years ago

Experience

Software/Hardware Consultant

John Ham & Assoc.
Jan 1989 - Present
My first job was building & programming data encryption hardware at a small startup firm from 1981-1983. From 1983-1985 I helped to create the first laser-readable wallet-sized data cards. In 1985 I returned to cryptographic work, and in 1987 went on to work on a bank reporting system using the first Windows 3 SDK. I have been running my own programming & consulting service since 1989. I have worked with firms such as IBM and Kimberly-Clark, and taught at Sheridan College in Toronto.

Education

BA in Philosophy (4yr Honours), BSc in Computer Science & Mathematics (3 of 4 yrs) Univ. of Toronto

Canada 1974 - 1981
(7 years)

Contact John H. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Certifications

us_eng_1.png US English 1 97%

Top Skills

Visual Basic 2
Excel 2
Software Architecture 2
C Programming
Python

Browse Similar Freelancers

Visual Basic Developers in Canada
Visual Basic Developers
Excel Experts
Software Architecture Developers

Browse Similar Showcases

Visual Basic
Excel
Software Architecture
C Programming
Previous User Next User
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Freelancer logo US (International) / English Help & Support Freelancer Categories Projects Contests Freelancers Enterprise Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified Desktop App About About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers Terms Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges Partners Escrow.com Loadshift Warrior Forum Apps Apple App Store logoGoogle Play logo
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.