<?xml version="1.0" encoding="UTF-8"?><oembed><type>video</type><version>1.0</version><html>&lt;iframe src=&quot;https://www.loom.com/embed/c9f279f7c6f94dbbb58b1711ee05a36e&quot; frameborder=&quot;0&quot; width=&quot;1720&quot; height=&quot;1290&quot; webkitallowfullscreen mozallowfullscreen allowfullscreen&gt;&lt;/iframe&gt;</html><height>1290</height><width>1720</width><provider_name>Loom</provider_name><provider_url>https://www.loom.com</provider_url><thumbnail_height>1290</thumbnail_height><thumbnail_width>1720</thumbnail_width><thumbnail_url>https://cdn.loom.com/sessions/thumbnails/c9f279f7c6f94dbbb58b1711ee05a36e-6abcaef5226d432e.gif</thumbnail_url><duration>124.117</duration><title>Fixing Duplicate Dispatch Numbers in Exports</title><description>This Loom follows up on a reported issue with invoicing report exports where dispatch numbers appear duplicated in Google Sheets. The speaker checks the actual reports and finds no duplicate dispatch numbers when exporting the data themselves, noting that for CERH Western Rock products the dispatch numbers are different as expected. The likely cause is scientific knowledge formatting in the export. They recommend changing an Excel setting by unchecking a specific option so formatting remains consistent when the report is opened.</description></oembed>