45:["$","title",null,{"children":"Rental Calendar Audit: bookings, blocks and overlaps | NovAsia Estate | Observable"}] 4d:T3746,const RentalCalendar = (()=>{ 'use strict';const DAY=86400000; function day(s){if(!/^\d{4}-\d{2}-\d{2}$/.test(String(s)))throw Error('Dates must be YYYY-MM-DD.');const t=Date.parse(s+'T00:00:00Z');if(!Number.isFinite(t)||s<'2000-01-01'||s>'2100-12-31'||new Date(t).toISOString().slice(0,10)!==s)throw Error('Invalid date: '+s);return t/DAY;} const iso=d=>new Date(d*DAY).toISOString().slice(0,10); function parseCSV(text){if(typeof text!=='string'||text.length>1000000)throw Error('CSV limit: 1 million characters.');text=text.replace(/^\uFEFF/,'');let rows=[],row=[],cell='',quoted=false,closed=false; for(let i=0;i<=text.length;i++){const c=text[i];if(quoted){if(c==='"'){if(text[i+1]==='"'){cell+='"';i++;}else{quoted=false;closed=true;}}else if(c===undefined)throw Error('Unclosed quoted CSV field.');else cell+=c;continue;} if(c==='"'&&!cell&&!closed){quoted=true;continue;}if(closed&&c!==','&&c!=='\r'&&c!=='\n'&&c!==undefined)throw Error('Unexpected text after CSV quote.'); if(c===','||c==='\r'||c==='\n'||c===undefined){row.push(cell);cell='';closed=false;if(c!==','){if(row.some(x=>x!==''))rows.push(row);row=[];if(c==='\r'&&text[i+1]==='\n')i++;}}else{if(c==='"')throw Error('Quote must start a CSV field.');cell+=c;}} if(rows.length<2)throw Error('CSV needs a header and at least one event.');const header=rows.shift().map(s=>s.trim());if(header.join(',')!=='id,unit,start,end,status')throw Error('Use exactly: id,unit,start,end,status');return rows.map((r,i)=>{if(r.length!==5)throw Error('CSV row '+(i+2)+' must have five fields.');return Object.fromEntries(header.map((h,j)=>[h,r[j].trim()]));}); } function audit(events,start,end,complete=false){const first=day(start),last=day(end),n=last-first;if(n<1||n>366)throw Error('Select a period of 1–366 nights; end is exclusive.');if(!Array.isArray(events)||events.length>500||events.length===0)throw Error('Provide 1–500 events.');const ids=new Set(),units=new Map(); for(const e of events){if(!e||typeof e!=='object')throw Error('Each event must be a record.');if(typeof e.id!=='string'||!e.id.trim()||e.id.length>80||ids.has(e.id))throw Error('Event IDs must be unique nonempty strings, up to80 characters.');ids.add(e.id);if(typeof e.unit!=='string'||!e.unit.trim()||e.unit.length>100)throw Error('Every event needs a unit label, up to100 characters.');if(!['booked','owner','maintenance'].includes(e.status))throw Error('Status must be booked, owner or maintenance.');const a=day(e.start),b=day(e.end);if(b<=a)throw Error('Event '+e.id+': end must be after start.');if(!units.has(e.unit))units.set(e.unit,Array.from({length:n},(_,i)=>({date:iso(first+i),events:[]})));for(let d=Math.max(a,first);d20)throw Error('At most20 units per audit.');const result=[]; for(const [unit,days] of units){const counts={booked:0,owner:0,maintenance:0,open:0,conflict:0};for(const d of days){d.status=d.events.length>1?'conflict':d.events[0]?.status||'open';counts[d.status]++;}const available=n-counts.owner-counts.maintenance;const rate=complete&&counts.conflict===0&&available>0?100*counts.booked/available:null;result.push({unit,nights:n,...counts,available,occupancyPercent:rate,days});} const counts=result.reduce((a,r)=>{for(const k of ['nights','booked','owner','maintenance','open','conflict','available'])a[k]+=r[k];return a;},{nights:0,booked:0,owner:0,maintenance:0,open:0,conflict:0,available:0});return {start,end,complete:complete===true,units:result,totals:{...counts,occupancyPercent:complete===true&&counts.conflict===0&&counts.available>0?100*counts.booked/counts.available:null}}; } function csvReport(report){const safe=s=>'"'+(/^[=+\-@\t\r]/.test(String(s))?"'":'')+String(s).replace(/"/g,'""')+'"';const keys=['unit','nights','booked','owner','maintenance','open','conflict','available','occupancyPercent'];return [keys,...report.units.map(r=>keys.map(k=>r[k]===null?'Withheld':r[k]))].map(r=>r.map(safe).join(',')).join('\r\n');} return {day,iso,parseCSV,audit,csvReport}; })(); const calendarHost = document.createElement("div"); const calendarRoot = calendarHost.attachShadow({mode:"open"}); calendarRoot.innerHTML = "

NovAsia EstateRENTAL OPERATIONS / OPEN SOURCE

A calendar is not an occupancy claim

Which nights were
actually available?

Inspect a rental calendar before using its occupancy rate. Separate guest bookings, owner stays and maintenance. Flag overlaps instead of counting one night twice.

1 / Your calendar

One row per event. End dates are checkout dates and excluded. Status: booked, owner or maintenance. Avoid guest names.

Period startPeriod end · exclusive

Calendar CSV I confirm this calendar covers every booking and block for the selected units and period.

Load local CSV

Maximum500 events,20 units and366 nights. Blank nights are only known to be available if your calendar is complete.

2 / What the calendar supports

The denominator matters

For a complete conflict-free calendar: occupancy = booked nights ÷ (period nights − owner nights − maintenance nights). Across units, totals use unit-nights rather than a simple average of percentages.

Conflicting events are unresolved. The tool withholds the occupancy rate until overlaps are resolved. If all nights are blocked, the rate is also withheld rather than reported as0%. A missing unit cannot be discovered from a CSV: include every unit you intend to measure. This is an audit of your supplied calendar, not a market forecast or evidence of rental revenue.

"; display(calendarHost); (()=>{'use strict';const c=RentalCalendar,$=id=>calendarRoot.getElementById(id),esc=s=>String(s).replace(/[&<>"']/g,x=>({'&':'&','<':'<','>':'>','"':'"',"'":'''}[x]));let report=null; const clean='id,unit,start,end,status\nB01,Demo Villa,2026-10-01,2026-10-11,booked\nO01,Demo Villa,2026-10-15,2026-10-18,owner\nM01,Demo Villa,2026-10-20,2026-10-22,maintenance'; function run(){try{report=c.audit(c.parseCSV($('source').value),$('start').value,$('end').value,$('complete').checked);$('error').textContent='';const t=report.totals,rate=t.occupancyPercent===null?'Withheld':t.occupancyPercent.toFixed(2)+'%';$('summary').innerHTML=`

${[['Occupancy',rate],['Booked unit-nights',t.booked],['Owner blocks',t.owner],['Maintenance',t.maintenance],['Unresolved unit-nights',t.conflict],['Unassigned unit-nights',t.open]].map(([l,n])=>`

${n}${l}

`).join('')}

${!report.complete?'Calendar completeness is unconfirmed. No occupancy rate is supported.':t.conflict?'Resolve overlaps before using any occupancy rate.':t.available===0?'All nights are blocked. There is no available-night denominator.':'Complete calendar: '+t.booked+' booked / '+t.available+' available unit-nights.'}

`; $('calendars').innerHTML='

'+[['booked','#225d50'],['owner','#5a4d78'],['maintenance','#715f2f'],['conflict','#9a3f3a'],['open / unassigned','#283f33']].map(([l,color])=>`${l}`).join('')+'

'+report.units.map(u=>`

${esc(u.unit)} · ${u.nights} nights

${u.occupancyPercent===null?'Occupancy withheld':u.occupancyPercent.toFixed(2)+'% occupancy'} · ${u.booked} booked · ${u.owner+u.maintenance} blocked · ${u.conflict} unresolved

${u.days.map(d=>`

${d.date.slice(5)}${d.status}

`).join('')}

${u.conflict?'

Resolve these overlaps

'+esc(d.date+': '+d.events.map(e=>e.id+' ('+e.status+')').join(' + '))+'

':''}

`).join('');return true;}catch(e){report=null;$('error').textContent=e.message;$('summary').replaceChildren();$('calendars').replaceChildren();return false;}} function download(name,data,type){const url=URL.createObjectURL(new Blob([data],{type})),a=document.createElement('a');a.href=url;a.download=name;a.click();setTimeout(()=>URL.revokeObjectURL(url),2000);} $('audit').onclick=run;$('clean').onclick=()=>{$('source').value=clean;$('complete').checked=true;run();};$('overlap').onclick=()=>{$('source').value=clean+'\nB02,Demo Villa,2026-10-08,2026-10-12,booked';$('complete').checked=true;run();};$('export').onclick=()=>{if(run())download('rental-calendar-audit.csv',c.csvReport(report),'text/csv;charset=utf-8');};$('json').onclick=()=>{if(run())download('rental-calendar-audit.json',JSON.stringify(report,null,2),'application/json');}; for(const id of ['source','start','end','complete'])$(id).addEventListener('input',()=>{report=null;$('summary').textContent='Inputs changed. Run the audit again.';$('calendars').replaceChildren();});$('file').onchange=async e=>{try{const f=e.target.files[0];if(!f)return;if(f.size>1000000)throw Error('CSV limit: 1 MB.');$('source').value=await f.text();$('complete').checked=false;run();}catch(e){$('error').textContent=e.message;}};$('source').value=clean;$('complete').checked=true;run();})(); 4e:[] 49:{"id":"4f12dea7f628b37b","slug":"rental-calendar-audit","title":"Rental Calendar Audit: bookings, blocks and overlaps","thumbnail":"a0bb13f83b220169a06c0751c56f8825cfd6ae76d3c345de8003ff418e0c02ba","access_level":"public","create_time":"$D2026-10-28T13:18:45.962Z","update_time":"$D2026-10-28T13:45:06.621Z","view_time":null,"first_public_time":"$D2026-10-28T13:42:20.144Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"4d6df891457c8800","login":"novasia-estate","name":"NovAsia Estate","avatar_url":"https://avatars-next.observableusercontent.com/037d86b62057a71da9aeeeea878d5a48c8201afb14899fc1959672f7e7287e97","tier":"free_2026","bio":"NovAsia Estate builds open-source property tools for offer comparison, rental operations and buyer workflows. Research across Cambodia, Thailand and Bali. https://novasia.estate/","followed_by_you":false,"follows_you":false},"version":8,"publish_version":8,"role":null,"authored":false,"authors":[{"type":"individual","id":"3eff34d00f8e775d","login":"novasia-estate","name":"NovAsia Estate","avatar_url":"https://avatars-next.observableusercontent.com/037d86b62057a71da9aeeeea878d5a48c8201afb14899fc1959672f7e7287e97","tier":null,"bio":"NovAsia Estate builds open-source property tools for offer comparison, rental operations and buyer workflows. Research across Cambodia, Thailand and Bali. https://novasia.estate/","followed_by_you":false,"follows_you":false}],"members":[{"type":"team","id":"4d6df891457c8800","login":"novasia-estate","name":"NovAsia Estate","avatar_url":"https://avatars-next.observableusercontent.com/037d86b62057a71da9aeeeea878d5a48c8201afb14899fc1959672f7e7287e97","tier":"free_2026","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Rental Calendar Audit: bookings, blocks and overlaps","cells":[{"id":1,"value":"# Rental Calendar Audit: bookings, blocks and overlaps\n\nA booking calendar is not automatically an occupancy claim. Separate guest bookings, owner stays, maintenance and unresolved overlaps before using a rental assumption.\n\nCreated by [NovAsia Estate](https://novasia.estate/), covering property research in Cambodia, Thailand and Bali. Included dates are synthetic training examples, not market statistics.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"$4d","pinned":false,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4e","stdlib":"2"}} 44:null

Which nights wereactually available?

1 / Your calendar

2 / What the calendar supports

The denominator matters

${esc(u.unit)} · ${u.nights} nights

Which nights were
actually available?