Did not receive the email?
Download the files here…
Please note the the Excel files contain Macro. Make sure that you have enabled the Macro on your Spreadsheet software. Otherwise, the file will not work properly. If you are using Microsoft Excel software, read this article to see how to activate the Macro on Excel. Then, you should unblock the Macros of the file templates by following this instruction.
The simple cemetery plot map template contains two main parts:
In the upper left corner, there is a box labeled “Information.” This box has a formula that pulls details from the Name Input Registry sheet. This means you do not have to switch between sheets all the time. If you click on boxes with numbers, the corresponding information will show up.*
Now, let us make your own Excel cemetery map:
*This is where the Excel macro is found. If you cannot turn on the macro, this feature will not work, but the rest of the Excel file will still be usable.
The advanced cemetery plot map template contains three main parts:
A screenshot from Google Earth
Annotated Section Map
PS: If you have a section – lot – grave numbering system, you can copy paste the Section Map accordingly, but it is going to be a lot of editing. We suggest you to use the Simple Template.
Input Entries: These sheets are where you input all of the information, both interments and ROI (deeds). These sheets contain information for only one row, so you can duplicate them depending on how many rows you have in the section. We recommend color-coding the sheet per section to help you navigate them faster. We have created the Excel using formulas so that when you enter information on these sheets, the information will be reflected on the Section Map you just made in Part B.
Let us try to input details for Section F Row – 1. There are 3 components in this sheet:
Columns A-D contain plot information. Fill them sequentially for easier navigation.
Column E (surname) also serves as plot status. When you fill in the name, it will appear in the Section Map. When it’s reserved, it will automatically change the color to yellow for easier color-coding on the Section Map.
Columns E-P contain interment details. Fill them accordingly.
Columns Q-X are for ROI (deeds) details. You can add the details of the person purchasing the plot here
Important Note for Advanced Template:
Congratulations on taking the first step to your digital cemetery!
Feel free to reach out to us when you need assistance in using the template or you are ready to move forward in digitising your cemetery maps and records with us. At Chronicle, we create a digital mirror of your cemetery maps and records—easy and simple!