## Posts

Showing posts from January, 2014

### Tech Tip: Calculate Tutor Payroll

Today a customer came with a good question.  He was trying to calculate tutor payments from a student visit report.  However, if you export the report in Excel format, you will get the Period in HH:MM format: To calculate the total hours and the total payment amount, you will need to use the TIMEVALUE Excel formula . For example, the following will return the total hours worked: =TIMEVALUE([Cell])*24 Then you can, round that number to have only 2 decimals: =ROUND(TIMEVALUE([Cell]) * 24, 2) For example, if the tutor has worked for 1 hour and 30 minutes (that would be displayed as 1:30), you will get 1.50 hours using the formula above. Or you can multiply the total hours worked (not rounded) by the hourly pay rate and then round the final amount.  If it were \$20, then the final formula would be: =ROUND(TIMEVALUE([Cell]) * 24 * 20, 2) Being [Cell] the reference to the cell where the period is (eg, 01:30), and 20 is the hourly pay rate.

### Make those courses available in your center!

As a support tech, you receive several times the same question.  This is about one of those things that many user usually forget: courses are not available by default to all centers.  When you create a new center, you need to assign the subject areas that can be taught in there. The same happens when you create a new subject area. To solve the problem, you need to import a file with 3 columns: Center Name, Subject Area Code Prefix and Subject Area Name. For example: Center Name Subject Area Code Prefix Subject Area Code Math Center MAT 101 Math Center ALG 201 Writing Center HIS 101 … … … And so on. In this case, MAT-101 and ALG-201 would be assigned to the Math Center and HIS-101 would be assigned to the Writing Center. If you want to assign all subject areas to all centers, you might want to use the export feature to get the list of subject areas.