u/CKSIT

For anyone interested, I've made a sort of template of the Google Sheets setup I use for collecting our middle school 1:1 Chromebooks . With the caveat that it's got some specific setup for our use-case and OU configuration, I offer it to anyone who'd like to try it out.

There's an Explanation tab and notes throughout in column headings. If they're not coherent enough, feel free to DM me with questions. :-) I've tweaked it here and there over the years that I've been using it. Hopefully, someone else will find it useful, too.

https://docs.google.com/spreadsheets/d/1NXyYw0fBGX2xJ4YOi3ibDfQQ7oNZtt2Fyw4-YeKOY4g/edit?usp=sharing

Edit to note: This is shared in view-only mode. Feel free to make a copy for yourself to explore the functionality.