Office	Accepted	Missed	Voicemail	Total	Acceptance Rate

\n`;\n\n const wb = XLSX.utils.book_new();\n for (\n const office of Object.entries(offices)\n .sort(([, a], [, b]) => (b.Missed + b.Voicemail) - (a.Missed + a.Voicemail))\n .map(([office]) => office)\n ) {\n const ws = XLSX.utils.json_to_sheet(detailByOffice[office]);\n XLSX.utils.book_append_sheet(wb, ws, office.substring(0, 31));\n }\n const xlsxBin = XLSX.write(wb, { bookType: \"xlsx\", type: \"array\" });\n const xlsxB64 = Buffer.from(xlsxBin).toString(\"base64\");\n\n await email({\n subject: \"Office Call Report for \"\n + new Date(Date.now() - 86400000).toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n }),\n html: htmlTable,\n attachments: [\n {\n filename: \"call_details.xlsx\",\n content: xlsxB64,\n type: \"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\",\n },\n ],\n });\n}","deleted","label","croganm-ringcentral-call-log",[99],"permalink","https://www.val.town/x/croganm/Call-Log-Report/code/main.tsx","extension","actionData","errors"]