UTC+2h 1 13-09-28 16:09:52┐ Sep 28 ┌13-09-28 2 13-09-28 0 Δ2h 17:21:34.44 Saturday 17:21 Δ2h {$AG$2} & IF( {$AH$2} =IF($L2="_","_", {$AF$2} N2>1, IF(COUNT(AO$1:AO2)=1, "), IF( hh:mm:ss┐ {$AO$2} {$AE$2} N2>1/24, IF( 2 IF( hh:mm:ss┘ "), "")) & , TEXT(AE2, IF(AF2,"mmm d dddd hh:mm", "hh:mm")) & REPT(" ) ) ) &AG2 ) ))))) The columns between columns AH and AO are discussed in the previous section and are skipped in the above table. construction The capture shows the data source of the chart. The data source range of the chart will be changed by a VBA script before generating and mailing the image file. This step is carried out for the cases when the user changes the number of intervals. The mailing VBA script will be presented later in this document (see sections 14 and 15). The chart looks as follows: The vertical axis on the left side is associated to the areas of cost (in pink) and margin (in green). All other curves, minutes per hour, PDD, spoken per minute, and failed per minute, are associated to the blue vertical axis on the right. Gradients are used for the areas to underline the lack of precision of the fresh data with pale colors and more consistent statistics for the old data with more opaque colors. Similar gradients are used for the curves.
1 UTC+2h 2 13-09-28 17:21:34.44 13-09-28 Δ2h ┌13-09-28 16:09:52┐ Sep 28 Saturday 17:21 Δ2h 0 2 {$AE$2} {$AF$2} IF( ) ) ) {$AG$2} & IF( N2>1, IF( N2>1/24, IF( ))))) {$AH$2} =IF($L2="_","_", IF(COUNT(AO$1:AO2)=1, hh:mm:ss┐ "), hh:mm:ss┘ "), "")) & TEXT(AE2, IF(AF2,"mmm d dddd hh:mm", "hh:mm")) & REPT(" &AG2 ) {$AO$2} The columns between columns AH and AO are discussed in the previous section and are skipped in the above table. construction The capture shows the data source of the chart. The data source range of the chart will be changed by a VBA script before generating and mailing the image file. This step is carried out for the cases when the user changes the number of intervals. The mailing VBA script will be presented later in this document (see sections 14 and 15). The chart looks as follows: The vertical axis on the left side is associated to the areas of cost (in pink) and margin (in green). All other curves, minutes per hour, PDD, spoken per minute, and failed per minute, are associated to the blue vertical axis on the right. Gradients are used for the areas to underline the lack of precision of the fresh data with pale colors and more consistent statistics for the old data with more opaque colors. Similar gradients are used for the curves. ,
index7.docx