How to set up a meals per diem calculator spreadsheet

Calculating per diem seems like such a chore at work. Although I am not doing much directly related to travel, I am starting to be involved in getting several outside contractors paid. I am thinking that when they travel, I might have to figure out their per diem. It is still unclear how much we promise to pay or not pay. I went ahead with experimenting with a spreadsheet to calculate meals per diem. From this point, I am going to start referring the spreadsheet as the MPDC, i.e. the Meals Per Diem Calculator! Continue reading “How to set up a meals per diem calculator spreadsheet”