Blog | AlchemyJ

All Posts
News
How-to
AJXF

3 days ago
1 min

Self Assessment - How Successful will You be in Life

Do you know how well Elon Musk and Steve Jobs spend their time is a pointer to their great achievements and have you wondered if you will...

14 views0 comments

Patient Health Questionnaire API in Excel

Raymond Tam

Jan 13
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 i...

38 views0 comments

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

Raymond Tam

Jan 5
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...

16 views0 comments

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

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 A...

36 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 Exc...

37 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 digit...

17 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 tutor...

34 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 I...

38 views0 comments

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

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 conver...

52 views0 comments

Introducing the New AlchemyJ Excel Library

Raymond Tam

Nov 10, 2020
1 min

Introducing the New AlchemyJ Excel Library

We would like to introduce you to our latest addition to the AlchemyJ family, the AlchemyJ Excel Library. AlchemyJ allows you to create J...

78 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 netw...

38 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 i...

44 views0 comments

Microsoft Graph Excel API Alternative - AlchemyJ

Raymond Tam

Oct 2, 2020
1 min

Microsoft Graph Excel API Alternative - AlchemyJ

In this video, we compare Microsoft Graph or also known as Excel REST API with AlchemyJ. We go through the strength of each product and p...

69 views0 comments

Create a Product Price List API using Excel in 90 seconds

Raymond Tam

Sep 25, 2020
1 min

Create a Product Price List API using Excel in 90 seconds

Ever wonder how to create a Product Price List API? What about turning your Excel price list into API? In this how-to tutorial, we will s...

61 views0 comments

Raymond Tam

Sep 8, 2020
1 min

Import a text file into Excel

Did you try to import a text file into Excel before? Sound simple but there's much more to it than just copy and paste. In this how-to tu...

62 views0 comments

Convert Excel Workbook to REST API (Web service)

Raymond Tam

Sep 4, 2020
1 min

Convert Excel Workbook to REST API (Web service)

Have you ever wanted to turn your Excel spreadsheets into a web service or REST API? AlchemyJ allows you to turn excel to API easily. The...

198 views1 comment

Raymond Tam

Jun 19, 2020
1 min

How to Read File in Excel Formula

Let's say you have a system that outputs a text file every day for you automatically and you need the data in the file in your Excel tabl...

156 views0 comments

Raymond Tam

Jun 16, 2020
1 min

Why use ajMergeRec?

The ajMergeRec function update records in databases if it exists. Otherwise, it’ll create a new record. Imagine you need to update your d...

23 views0 comments

Raymond Tam

Jun 11, 2020
1 min

How to use ajExecuteSql

The ajExecuteSQL function executes a SQL Statement and then returns the result. We can use this in Excel to allow users to execute SQL st...

30 views0 comments

Raymond Tam

May 26, 2020
1 min

AlchemyJ Documentation and Recipe Book

AlchemyJ enables you to turn your business model in Excel into OpenAPI easily. AlchemyJ also supports over 300 built-in Excel functions a...

24 views0 comments

{"items":["600aa04522048700179addec","5ffec84c0aad3f0017d69e98","5ff3f8d7179c130017a6ed1a","5febd466e26e510017a17304","5fe171091b6016001746a101","5fd82298fab4510017b4c871","5fcdd7a4b315770017202c6d","5fc89e0836189f001710ba42","5fb485cc2eb0d50017367257","5fa5170f7d785b001759353d","5f98db459371f100177e046f","5f851cf3ddf63e0018318b14","5f753388baedf70017109053","5f586acfb863d20017bb8dc0","5f5099dcab0c3d0018f56118","5ea136796ba5360017e86a11","5eec698b52b4f0002ec38a88","5ee890a0d6300f0017d03e36","5ee1fce18e6972001782823e","5eccc3814fd28c0017ad996c"],"styles":{"galleryType":"Columns","groupSize":1,"showArrows":true,"cubeImages":true,"cubeType":"fill","cubeRatio":1.3333333333333333,"isVertical":true,"gallerySize":30,"collageAmount":0,"collageDensity":0,"groupTypes":"1","oneRow":false,"imageMargin":32,"galleryMargin":0,"scatter":0,"rotatingScatter":"","chooseBestGroup":true,"smartCrop":false,"hasThumbnails":false,"enableScroll":true,"isGrid":true,"isSlider":false,"isColumns":false,"isSlideshow":false,"cropOnlyFill":false,"fixedColumns":1,"enableInfiniteScroll":true,"isRTL":false,"minItemSize":50,"rotatingGroupTypes":"","rotatingCropRatios":"","columnWidths":"","gallerySliderImageRatio":1.7777777777777777,"numberOfImagesPerRow":1,"numberOfImagesPerCol":1,"groupsPerStrip":0,"borderRadius":0,"boxShadow":0,"gridStyle":1,"mobilePanorama":false,"placeGroupsLtr":false,"viewMode":"preview","thumbnailSpacings":4,"galleryThumbnailsAlignment":"bottom","isMasonry":false,"isAutoSlideshow":false,"slideshowLoop":false,"autoSlideshowInterval":4,"bottomInfoHeight":0,"titlePlacement":"SHOW_ON_THE_RIGHT","galleryTextAlign":"center","scrollSnap":false,"itemClick":"nothing","fullscreen":true,"videoPlay":"hover","scrollAnimation":"NO_EFFECT","slideAnimation":"SCROLL","scrollDirection":0,"scrollDuration":400,"overlayAnimation":"FADE_IN","arrowsPosition":0,"arrowsSize":23,"watermarkOpacity":40,"watermarkSize":40,"useWatermark":true,"watermarkDock":{"top":"auto","left":"auto","right":0,"bottom":0,"transform":"translate3d(0,0,0)"},"loadMoreAmount":"all","defaultShowInfoExpand":1,"allowLinkExpand":true,"expandInfoPosition":0,"allowFullscreenExpand":true,"fullscreenLoop":false,"galleryAlignExpand":"left","addToCartBorderWidth":1,"addToCartButtonText":"","slideshowInfoSize":200,"playButtonForAutoSlideShow":false,"allowSlideshowCounter":false,"hoveringBehaviour":"NEVER_SHOW","thumbnailSize":120,"magicLayoutSeed":1,"imageHoverAnimation":"NO_EFFECT","imagePlacementAnimation":"NO_EFFECT","calculateTextBoxWidthMode":"PERCENT","textBoxHeight":0,"textBoxWidth":200,"textBoxWidthPercent":50,"textImageSpace":10,"textBoxBorderRadius":0,"textBoxBorderWidth":0,"loadMoreButtonText":"","loadMoreButtonBorderWidth":1,"loadMoreButtonBorderRadius":0,"imageInfoType":"ATTACHED_BACKGROUND","itemBorderWidth":1,"itemBorderRadius":0,"itemEnableShadow":false,"itemShadowBlur":20,"itemShadowDirection":135,"itemShadowSize":10,"imageLoadingMode":"BLUR","expandAnimation":"NO_EFFECT","imageQuality":90,"usmToggle":false,"usm_a":0,"usm_r":0,"usm_t":0,"videoSound":false,"videoSpeed":"1","videoLoop":true,"jsonStyleParams":"","gallerySizeType":"px","gallerySizePx":940,"allowTitle":true,"allowContextMenu":true,"textsHorizontalPadding":-30,"itemBorderColor":{"themeName":"color_12","value":"rgba(204,204,204,1)"},"showVideoPlayButton":true,"galleryLayout":2,"targetItemSize":940,"selectedLayout":"2|bottom|1|fill|true|0|true","layoutsVersion":2,"selectedLayoutV2":2,"isSlideshowFont":false,"externalInfoHeight":0,"externalInfoWidth":0.5},"container":{"width":940,"galleryWidth":972,"galleryHeight":0,"scrollBase":0,"height":null}}