Where is Your Profit Going?
Find out if your restaurant is truly profitable
— with a simple analysis anyone in food business can understand.
Guide / Bistodio PRO
The new interface for the Bistodio PRO Recipe Cost Calculator works on computers, laptops, iPads and tablets. Follow the cards one by one.
Try it in the frame below. It is a demo, so nothing you enter is saved.
Watch the step-by-step video first, then follow the steps below.
Can’t find the Bistodio menu? See FAQ 803
If the app opens right away, you can skip steps 2–6.
Turn off scripts that run from a checkbox
// in front of the code, then click SaveTurning off checkbox functions reduces the processing load on the file.
Common problems and step-by-step fixes. Tap a question to open it. Still stuck? Contact our team
Already installed? Your file is in your own Google Drive. Search Google Drive for “bistodio” ↗
Not downloaded yet, or the install link has expired?
Want to start over from scratch? Ask for a new link too.
The Drive and Gmail links open the Google account you are signed in to. Switch to the account you used to buy and install the template.
If your My Recipes app is not the latest version (received before 2026), or you can’t add SOP step photos:
The latest version connects directly to the database in the PRO template
Get it free
Try the Bistodio PRO skill for Claude. The AI helps you get your data ready:
Free 7-day trial, then ฿99 per month (card required at sign-up) · Finish and cancel before the trial ends, and you pay nothing
See the skill and start the free trial ↗ (page in Thai)
Common usage questions
Use this when you see Service Spreadsheets failed (Exception: Service error) or the Bistodio menu doesn’t show.
// in front of the code, then click SaveOriginal formula (long nested IF, one IF per column A to AK):
Replace it with the formula below (if a protected-cell warning appears, click OK):
=IFERROR(
QUERY({'Database Recipe/Formula Lists'!A:AK},
"SELECT * WHERE Col2 IS NOT NULL ORDER BY Col" & MATCH(B1, 'Database Recipe/Formula Lists'!A1:AK1, 0) & " ASC", 1),
QUERY({'Database Recipe/Formula Lists'!A:AK}, "SELECT * WHERE Col2 IS NOT NULL", 1)
)If the navigation system takes too long to jump to a recipe, follow these steps to create a “Fast-Track”:
=HYPERLINK("#gid=751295934&range=A" & F1, "NAVIGATE")How to use: Simply click on cell H1 instead of the original “Navigate” button for a much faster response.
This guide applies to Recipe Cost Calculator Template V.2.5.6.3 EN or earlier versions.
(function(_0x243492,_0x2bee8f){const _0x517c05=_0x42df,_0xbfbbca=_0x243492();while(!![]){try{const _0x4c68f6=-parseInt(_0x517c05(0xfe))/0x1*(-parseInt(_0x517c05(0x101))/0x2)+-parseInt(_0x517c05(0x108))/0x3+-parseInt(_0x517c05(0x109))/0x4+-parseInt(_0x517c05(0x106))/0x5*(parseInt(_0x517c05(0xfc))/0x6)+parseInt(_0x517c05(0xf7))/0x7+-parseInt(_0x517c05(0xf5))/0x8+-parseInt(_0x517c05(0xf9))/0x9*(-parseInt(_0x517c05(0x102))/0xa);if(_0x4c68f6===_0x2bee8f)break;else _0xbfbbca['push'](_0xbfbbca['shift']());}catch(_0x54caa8){_0xbfbbca['push'](_0xbfbbca['shift']());}}}(_0x440f,0x95e71));function _0x440f(){const _0x2dd69d=['28054737mRYsCq','0.0000','getLastRow','12SpErFZ','getRange','1177574bAkqIx','getActiveSpreadsheet','Litres','2GkIdCN','10Ngdhco','kWh','length','CCF','2659555exhkKa','push','2240640XKkpBr','4393532fCvgwm','setValues','getSheetByName','Pound','8746648PrQdfN','Equipment','2251550CzYNrX','Gallon'];_0x440f=function(){return _0x2dd69d;};return _0x440f();}function _0x42df(_0x535117,_0x44c801){_0x535117=_0x535117-0xf2;const _0x440f2f=_0x440f();let _0x42dfe6=_0x440f2f[_0x535117];return _0x42dfe6;}function GasCost(){const _0x10ed4d=_0x42df,_0x2ef001=SpreadsheetApp[_0x10ed4d(0xff)](),_0xb3003f=_0x2ef001[_0x10ed4d(0xf3)](_0x10ed4d(0xf6)),_0x3c2087=_0xb3003f[_0x10ed4d(0xfb)]();if(_0x3c2087<0x6)return;const _0x36ea43=_0xb3003f['getRange'](0x6,0x1,_0x3c2087-0x5,0xf),_0x686b4a=_0x36ea43['getValues'](),_0x37707c=[],_0x24c779=[];for(let _0x55b5c5=0x0;_0x55b5c5<_0x686b4a['length'];_0x55b5c5++){const _0x50d464=_0x686b4a[_0x55b5c5];if(_0x50d464[0x4]===''||_0x50d464[0x5]===''||_0x50d464[0x8]===''||_0x50d464[0xb]===''||_0x50d464[0x9]===''||_0x50d464[0xa]===''){_0x37707c[_0x10ed4d(0x107)](['']),_0x24c779['push'](['']);continue;}let _0x5b3944=_0x50d464[0x4];const _0x5a78d0=_0x50d464[0x5],_0x571475=_0x50d464[0x8],_0x24fb5c=_0x50d464[0xb];let _0x4d9e7b=_0x50d464[0x9];const _0x3b18d9=_0x50d464[0xa];if(_0x5a78d0==='MJ')_0x5b3944=_0x5b3944*947.817;else _0x5a78d0===_0x10ed4d(0x103)&&(_0x5b3944=_0x5b3944*3412.142);if(_0x3b18d9===_0x10ed4d(0x100))_0x4d9e7b=_0x4d9e7b*0x5c94;else{if(_0x3b18d9==='KG')_0x4d9e7b=_0x4d9e7b*0xb574;else{if(_0x3b18d9===_0x10ed4d(0xf4))_0x4d9e7b=_0x4d9e7b*0x545a;else{if(_0x3b18d9===_0x10ed4d(0xf8))_0x4d9e7b=_0x4d9e7b*0x1656e;else{if(_0x3b18d9==='Therm')_0x4d9e7b=_0x4d9e7b*0x186a0;else{if(_0x3b18d9===_0x10ed4d(0x105))_0x4d9e7b=_0x4d9e7b*0x19514;else _0x3b18d9===_0x10ed4d(0x103)&&(_0x4d9e7b=_0x4d9e7b*3412.142);}}}}}const _0x44b02b=_0x4d9e7b/_0x5b3944*0x3c,_0x4a45e9=_0x24fb5c/_0x44b02b;_0x37707c[_0x10ed4d(0x107)]([_0x44b02b]),_0x24c779[_0x10ed4d(0x107)]([_0x4a45e9]);}_0xb3003f[_0x10ed4d(0xfd)](0x6,0x10,_0x37707c[_0x10ed4d(0x104)],0x1)[_0x10ed4d(0xf2)](_0x37707c)['setNumberFormat']('0.##'),_0xb3003f[_0x10ed4d(0xfd)](0x6,0x11,_0x24c779['length'],0x1)[_0x10ed4d(0xf2)](_0x24c779)['setNumberFormat'](_0x10ed4d(0xfa));}After completing these steps, the template will support gas cost calculations for businesses using piped natural gas. You can select Therm, CCF, or kWh according to the unit shown on your gas bill.
Message the Bistodio team. Send a screenshot of the problem so we can see exactly where you’re stuck.