Memuat
Memuat
Want to go deeper?
Join one of our courses or ask us directly on WhatsApp.
Picked from the software, topic, and level of “Claude from Zero to Expert Class #28: Creating Tables and Simple Calculators”.
Other ways we can help with Claude.
Learn with a mentor
Scheduled AI & Machine Learning courses with live guidance and a certificate.

Midjourney Course: Create Stunning AI Images from Text
★ 4.9

DALL-E Course: Creating Professional AI Images from Text
★ 4.9

Stable Diffusion Course: AI Art from Beginner to Professional
★ 4.9
Have it built for you
No time to learn Claude? Our team can do the project for you.

AI Image Creation with Stable Diffusion — Unlimited Custom Visual Production
★ 4.9

AI Image & Video Creation with Leonardo AI — All-in-One Visuals for Business
★ 4.9

AI Image Creation with Midjourney — Cinematic AI Art for Business
★ 4.9
Get notified about new Claude classes
At most one email a week. Unfollow anytime with one click.
The full narration of this video. The current sentence is highlighted while the video plays; click any sentence to jump there.
Hi, let's continue the Artifacts session. After documents and checklists, today we create Artifacts that can do math: tables and simple calculators. We'll create a stock table and a coffee cost-of-goods calculator, test it properly, look at examples for offices and schools, then decide when to use an Artifact or a spreadsheet.
Let's start with a table. Every morning Dimas writes down ingredient stock in a small notebook. Today he pastes his notes into Claude and asks for a table with minimum stock and status. The right panel shows a table of five ingredients. The status column immediately flags two ingredients below the minimum: palm sugar and cups. Below it is a summary of today's shopping. Where do the minimums come from? Laras wrote them in an earlier request. If you don't have minimums yet, set them yourself; don't let Claude guess. A table like this is easy to read at a glance and can be sent to Laras as a morning report. No need to open a spreadsheet app at all. So when do you use a table Artifact, and when a spreadsheet? A table Artifact suits a summary at a glance. A spreadsheet suits data that keeps growing every day. A table Artifact's strengths: tidy, quick to create, and it can have markers. A spreadsheet's strengths: it keeps a long history, has formulas, and can be filtered. So this morning's stock report is fine as an Artifact, while a full year of stock records stays in a spreadsheet. The two complement each other.
Now for a calculator. Laras wants to know her cost of goods sold, the total ingredient cost for one cup of coffee. The task: create a cost-of-goods and profit calculator as an Artifact. She writes the data in full: coffee four thousand, milk three thousand five hundred, palm sugar one thousand five hundred, cup and lid one thousand five hundred, ice five hundred rupiah, and a selling price of eighteen thousand. The format: each cost is a field you can change, then show the cost of goods, profit per cup, and margin as a percentage. And one very useful limit: write the formula in plain words below the calculator, so Laras can check how it calculates. Laras sends her request. The screen shows a short version: the cost components and the selling price. The calculator appears in the right panel. There are cost fields you can change; here we see milk, palm sugar, and the selling price. The result cards: a cost of eleven thousand, a profit of seven thousand per cup, and a margin of thirty-eight point nine percent. Below that is the formula in plain words: cost is the sum of all ingredient costs, profit is the selling price minus the cost, and margin is the profit divided by the selling price. Because the formula is written clearly, Laras can make sure Claude calculates the same way she understands it. A calculator whose formula is hidden shouldn't be trusted right away. Let's compare by hand. The cost: four thousand, plus three thousand five hundred, plus one thousand five hundred, plus one thousand five hundred, plus five hundred. That's eleven thousand rupiah. Profit per cup: eighteen thousand minus eleven thousand, which is seven thousand rupiah. Margin: seven thousand divided by eighteen thousand, times one hundred percent, is about thirty-eight point nine percent. Everything matches the calculator.
Now let's test it with a real change. The milk supplier raises the price to four thousand per cup. Laras also asks for a field for cups sold per day and the profit per day. Version two appears. The cost rises to eleven thousand five hundred, profit per cup is six thousand five hundred, and the margin drops to thirty-six point one percent. At one hundred cups a day, gross profit is six hundred fifty thousand rupiah. Notice the note below: this figure doesn't include rent, wages, and electricity. Claude is honest about the limits of its calculation, so Laras doesn't mistake gross profit for net profit. With this calculator Laras can make a decision: raise the selling price a little, or find another milk supplier. The decision stays with Laras; the calculator just makes the numbers clear. There are four ways to test a calculator. First, use an example you've already worked out by hand, like we just did. Second, change just one number, then make sure only the related results change. If the milk price changes, the margin should drop too. Third, try zero and a very large number. A good calculator doesn't show strange results when cups sold is set to zero. Fourth, read the formula in plain words and compare it with how you calculate. If something is wrong, name the mistake specifically, for example: the margin must be divided by the selling price, not by the cost.
An example from the office. Customers often ask Dewi about wholesale discounts on A4 paper. The price is fifty-two thousand per ream, with five percent off from fifty reams, and ten percent off from one hundred reams. For an order of one hundred twenty reams, the calculator shows a subtotal of six million two hundred forty thousand, a ten percent discount of six hundred twenty-four thousand, and a total due of five million six hundred sixteen thousand. Dewi tests the boundaries: forty-nine reams must have no discount, fifty reams must get five percent, and one hundred reams must get ten percent. Numbers right at a rule's boundary are where mistakes happen most often. An example from school. Mr. Hendra asks for a final grade calculator weighting assignments at thirty percent, the midterm at thirty percent, and the final exam at forty percent, complete with letter grades. For an assignment score of eighty, a midterm of seventy, and a final exam of ninety, the result is eighty-one, grade B. Check by hand: twenty-four plus twenty-one plus thirty-six equals eighty-one. It matches. Mr. Hendra uses this calculator just for himself. Students' grades are personal data, so a calculator with student names and scores isn't shared publicly. There are many more calculators you can create. First, shipping and order totals, like a Sunset Coffee calculator with free shipping above two hundred thousand. Second, recipes for many servings. Ingredient amounts are automatically multiplied by the order size, perfect for orders for family celebrations. Third, simple installments or savings: how much to set aside each month to reach a goal, such as buying a new coffee machine. Fourth, staff overtime and meal allowances. For more serious financial calculations, such as taxes or loans, still consult an expert.
What if Laras wants to record her cost of goods every month? She asks Claude to write a spreadsheet version with its formulas, then copies it into Google Sheets. The first row: coffee, four thousand. Milk, which has gone up to four thousand. Palm sugar, one thousand five hundred. Cup and lid, one thousand five hundred. Ice, five hundred rupiah. The last row is the cost of goods. Look at the formula box at the top: SUM B2 to B6, which means add up all the costs. The result is eleven thousand five hundred, the same as version two of the calculator Artifact. Finally, a checklist before a calculator is used or shared. First, it's been tested with manual examples and numbers at the rule boundaries. Second, the formula is written in plain words, so anyone using it can understand how it calculates. Third, the reference numbers are updated whenever prices change. A calculator with old prices is actually misleading. And fourth, there's no confidential financial data or personal data in a calculator you share. The screens in this video are simulations, and menu names may differ slightly because Claude is updated often.
We've created a stock table, a cost-of-goods and profit calculator, discount and grade calculators, tested them with manual examples, and copied a spreadsheet version. In the next episode we build a one-page website for Sunset Coffee, complete with the menu, testimonials, and an order button, without writing any code ourselves. See you there!
Try these on your own after watching to lock in what you learned.
Type a question or keyword; we find the part of this episode that explains it and jump the video there.
Notes are saved with the current video time and are only visible to you.
Stuck on a step? Ask here; the instructor and other learners can answer.
No questions yet.

Cerdas Inovasi Digital Team
Software developers, BIM & 3D engineers, and AI practitioners
We build software, BIM models, games and AI automations for clients every day, and turn that hands-on work into step-by-step classes: every step is shown on screen and comes with a PDF guide you can keep.
See our clients →