Please fill all required fields
    Gauteng Freeway Improvement Project Toll Calculator Spreadsheet                      
       
    Scroll down to enter your details in the blue cells and see the results in the yellow cells  
    You will need to estimate how many kilometres you travel PER MONTH on and off the GFIP roads  
    As a rough guide, assume 20 work days per month, 8 weekend days per month and perhaps 1 public holiday per month  
       
       
    For more of what we offer visit the home page  
    www.AuditExcel.co.za  
       
       
    Answer the questions below  
    Type of Vehicle?
    		/km @ full rate  
    Will you have an e tag?
    		Discount provided  
     
    For accuracy purposes we have included travel on and off the toll roads. This means you can check that it matches roughly to your monthly travel KM's  
    If not it may mean you are travelling more than you think on the highways  
     
    Enter the number of KM's travelled within a month during these time slots     Tolled Roads- KM per Month Other Roads- KM per Month (optional) Total KM's per month in time slots  
    Weekdays           Toll Fees for the next 6 months              
    23h00- 05h00           Month 1 Month 2 Month 3 Month 4 Month 5 Month 6
    05h00- 06h00     Full Price Toll Fees  
    06h00- 10h00     Less Time of Day Discounts  
    10h00- 14h00     Less e- Tag Discount if applicable  
    14h00-18h00     Toll Fees before Frequent User Discounts
    18h00- 23h00                      
              Frequent user Dis % (See note below)
    Weekend           Frequent user Discount  
    18h00- 06h00     Toll Fees per month  
    06h00- 18h00                      
              Note- we are currently unclear whether the frequent user discount will be applied after    
    Public Holidays     the previous months frequent user discount or before          
      km per mth  
          km per year  
     
       
     
    Calculations  
    Relevant Details  
    Frequent user Discount  
    Prior Month Bill band   Discount  
    0 100 0.00%  
    100 200 2.50%  
    200 380 7.50%  
    380 550 15.00%  
    550 700 25.00%  
    700 830 37.50%  
    830 940 45.00%  
    940 10,000,000 50.00%  
     
        Normal Toll Rate per KM Time of date Discount Normal Bill Time of day discount Bill After Time of Day Discounts  
    Weekday              
    23h00- 05h00   25%  
    05h00- 06h00   10%  
    06h00- 10h00   0%  
    10h00- 14h00   10%  
    14h00-18h00   0%  
    18h00- 23h00   10%  
           
    Weekend        
    18h00- 06h00   25%  
    06h00- 18h00   15%  
           
    Public Holiday   25%  
       
     
       
    		Powered By SpreadsheetConverter