|Posted by lsmith335 on November 17, 2013 at 1:55 PM|
Below is a sample of the spreadsheet and list that I use to keep track of my submissions. The spreadsheet lists all of the journals and pieces that I submit in the order that I send them. I also keep a list of which pieces I submit to each journal. If I decide to submit to that journal in the future, I try to make sure that I'm not sending them the same work over and over again. It's easier to look this up on the list than to try to go back through the entire spreadsheet to figure out which pieces you've submitted to that journal before. Both of these are word documents and are color coded. The green font indicates pending submissions, red font indicates rejections and blue font indicates an accepted submission. I also keep track of journals that do not respond within a year and remove journals that have gone out of business or are charging fees to submit. Feel free to use these templates or use them as a guide to create your own way of organizing and tracking your submissions.