#restapi

Jan 13, 2021
1 min

Patient Health Questionnaire API in Excel

In this video, we created a PHQ-9 questionnaire together with the scoring function in Excel. Once we have done that, we turn this model into API using AlchemyJ. Once this API is generated, you can use this API together with any mobile app or browser for the UI interface as your own questionnaire application. If you want to learn how to use AlchemyJ, we really encourage you to try building this model by yourself. If you stumble upon a problem, don’t hesitate to post a question

139 views0 comments

Unbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 3

Raymond Tam

Jan 5, 2021
1 min

Unbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 3

In this video, we will explain how we get the different states (winning, draw, losing) we use or pattern matching in the Tic Tac Toe game in Excel with an unbeatable AI player. We built this Tic Tac Toe game from scratch so you can follow along and build your own model. We separate this video into multiple parts, for part 1 and part 2 please refer below for the link. Unbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 1: https://youtu.be/q9rL2z8FD5U Unbeatable Tic Tac Toe

90 views0 comments

Raymond Tam

Dec 30, 2020
1 min

Unbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 2

In this video, we will continue building the Tic Tac Toe game in Excel with an unbeatable AI player with Excel Functions. We were using AlchemyJ Excel Library to build this Tic Tac Toe game. You can also use the AlchemyJ Community Edition or Enterprise Edition if you want to turn this Excel into API. We will build this Tic Tac Toe game from scratch so you can follow along and build your own model. We separate this video into multiple parts, for part 1 please refer below for t

60 views0 comments

Unbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 1

Raymond Tam

Dec 22, 2020
1 min

Unbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 1

In this video, we will build a Tic Tac Toe game in Excel with an unbeatable AI player with Excel Functions. We will also use AlchemyJ Excel Library to build this Tic Tac Toe game. You can also use the AlchemyJ Community Edition or Enterprise Edition if you want to turn this Excel into API. We will build this Tic Tac Toe game from scratch so you can follow along and build your own model. We separate this video into multiple parts, so remember to watch the other part as well on

187 views0 comments

Overcoming large number limitation in Excel

Raymond Tam

Dec 15, 2020
1 min

Overcoming large number limitation in Excel

Do you know that Excel has limitations on supporting numbers that have over 15 digits? If you try to work with numbers with over 15 digits of precision in Excel, it replaces digits after the 15th with zeros. If you need to store numbers or perform calculations using Excel with over 15 digits, AlchemyJ will be able to solve your problem. In this video, we will show you how the AlchemyJ Big Numbers function can help solve big/large numbers in Excel. There's no need for you to w

42 views0 comments

How to Build a Password Checker API in 5 Minutes using Excel

Raymond Tam

Dec 8, 2020
1 min

How to Build a Password Checker API in 5 Minutes using Excel

Have you tried to build a password checker before? How long do you need to build a working API for password checker? In this how-to tutorial, we are going to show you how to build a password checker API in less than 5 mins. We will use the Rule Engine template that can be downloaded from here. The password checker will check the password created based on the rules you created. These rules can be changed easily in Rule Engine template. Once the password checker model has been

56 views0 comments

Excel IF, IFS, SWITCH Function - A Subtle Difference

Raymond Tam

Dec 3, 2020
1 min

Excel IF, IFS, SWITCH Function - A Subtle Difference

IF and IFS function in Excel are very useful decision-making functions. Do you know that IF and IFS function work differently? Although IF and IFS provide the same result, the way they are executed may create unexpected side-effects. This is especially important when they are used with User Defined Function (UDF). This video will first show you the difference between the Excel IF and IFS functions. We will then see whether the same behaviour appears in other decision-making o

99 views0 comments

Raymond Tam

Nov 18, 2020
1 min

How to Create a Real-Time Currency Converter API using Excel

Ever wonder how to create a real-time currency converter API using Excel? In this video, we will see how to create a REST API that converts one currency to another using Excel with a real-time exchange rate. This video will show you how to build this from scratch so you will be able to do the same. If you want to learn how to use AlchemyJ, we really encourage you to try building this model by yourself. If you stumble upon a problem, don’t hesitate to post a question in our fo

141 views0 comments

Build a Machine Learning Model API in Excel

Raymond Tam

Oct 28, 2020
1 min

Build a Machine Learning Model API in Excel

Handwritten digit recognition is not something new, but what if the model is built using Excel? In this video, we will use the neural network model built by Mike Pallister and we are going to turn it into an API with an interface so we can test it on the browser. We will explain briefly how the prediction model works and then convert the model into an API. If you want to learn how to convert an Excel model into an API, this video is for you. You can also understand more about

108 views0 comments

Raymond Tam

Oct 13, 2020
1 min

Number to words in Excel and REST API

Do you know you can convert numbers to words in Excel without the use of VBA and macros? We can convert numbers to words with a formula in Excel. We bring the formula in Excel to the next level by turning it into REST API. With AlchemyJ, you can easily convert the Excel into REST API so that more people can use this feature. If you want to find out more about converting numbers to words in Excel or REST API, this is the video for you. Leila Gharani - Convert NUMBERS to WORDS

504 views0 comments

Perform CRUD Operation on Excel - Part 2 of 2

Raymond Tam

May 5, 2020
5 min

Perform CRUD Operation on Excel - Part 2 of 2

We will work on updating and deleting records in the database today with AlchemyJ. If you notice the pattern on both reading records and creating records, the process is almost the same. The splits into 6 steps as below Configure the ##RestAPI Configure ##RestEndpointGroup Configure the BizLogic Define the IO_Schema Complete the #RestEndpointGroup configuration Generate API and test The above process is a simple way of how you can create an API using AlchemyJ. Let's proceed

85 views0 comments

Perform CRUD Operation on Excel - Part 1 of 2

Raymond Tam

May 4, 2020
6 min

Perform CRUD Operation on Excel - Part 1 of 2

This tutorial will show you how easy it is to perform CRUD operation to the database using AlchemyJ Our last post on executing SQL command in Excel shows how you can work with databases in Excel. However, the most common operation that we need to perform on database operation is CRUD which also stands for create, read, update and delete. In this tutorial, we are going to perform this process using AlchemyJ. Goals Create entries directly into the database from Excel Read the d

2,812 views0 comments

Raymond Tam

Apr 30, 2020
3 min

Execute SQL Statement in Excel

In this tutorial, we will execute the SQL Statement in Excel using AlchemyJ. Before we begin, ensure you have your database installed. For this tutorial, we will use the MySQL database. After you've installed the database, try creating a database at the same time. I'm naming this database as 'test'. CREATE DATABASE test; *use this script if you need help. Once you have the database created, let's start by selecting the REST API Sample Model for today's model. Once the new mod

172 views0 comments

Generate OpenAPI (Swagger) Specification Automatically with AlchemyJ

Raymond Tam

Apr 29, 2020
4 min

Generate OpenAPI (Swagger) Specification Automatically with AlchemyJ

In this tutorial, I'm going to show you how you can enable OpenAPI (Swagger) from API generated by AJ For this tutorial, we are going to use the model we created from our previous post (How to write your first API with AlchemyJ). Open the file you saved previously and if you follow the tutorial exactly, the file name should be SayHello.xlsm. Before we start to change the content, let's save the file under a new name. Go to File -> Save As -> OpenAPI Swagger.xlsm Please ensure

1,462 views0 comments