Excel

profileshanta75
Skill NameNCONCHNCA%NCAService LevelASAAHTACWMax Delay
CA (French)3933246917.6%42.1%224.13754.41265.551404.83
CLI-PCL CA256235218.2%93.5%92.55944.02249.72603.28
CLI-PCL US152013931288.4%91.5%98.54889.80234.77899.96
Gen. Inquiry CA230209219.1%57.7%112.04875.20264.77710.53
Gen. Inquiry US194718021457.4%50.3%125.16797.31236.60860.24
Hold Orders Group303287165.3%68.7%79.13565.06270.071261.43
My Events-HR CA247232156.1%47.8%122.60895.66266.68745.90
My Events-HR US459439204.4%50.5%127.191038.26260.17802.98
My Office CA485455306.2%50.3%118.26989.37269.80707.33
My Office US348326226.3%50.0%122.11864.71238.66810.77
NVP Support25124383.2%71.7%45.25886.66263.29736.22
Orders-RMA CA16315674.3%53.4%118.84970.18262.95815.48
Orders-RMA US379136211704.5%54.5%111.76935.91259.671462.29
Product Claims Hotline ARB11411221.8%93.9%13.32491.33125.06501.28
RVP Support873851222.5%72.9%53.07810.45273.76945.77
Spanish US163147169.8%78.1%53.40637.87210.781667.69
VP Support (French)252414.0%72.0%62.34571.12252.33509.19
VP-Addison202100.0%    147.51
Total11570108567156.2%6.8%    
 Identify %NCA by skill type and calculate all statistical data for the Total.   
          
Skill NameNCONCHNCA%NCAService LevelASAAHTACWMax Delay
CA (French)39332469 42.1%224.13754.41265.551404.83
CLI-PCL CA25623521 93.5%92.55944.02249.72603.28
CLI-PCL US15201393128 91.5%98.54889.80234.77899.96
Gen. Inquiry CA23020921 57.7%112.04875.20264.77710.53
Gen. Inquiry US19471802145 50.3%125.16797.31236.60860.24
Hold Orders Group30328716 68.7%79.13565.06270.071261.43
My Events-HR CA24723215 47.8%122.60895.66266.68745.90
My Events-HR US45943920 50.5%127.191038.26260.17802.98
My Office CA48545530 50.3%118.26989.37269.80707.33
My Office US34832622 50.0%122.11864.71238.66810.77
NVP Support2512438 71.7%45.25886.66263.29736.22
Orders-RMA CA1631567 53.4%118.84970.18262.95815.48
Orders-RMA US37913621170 54.5%111.76935.91259.671462.29
Product Claims Hotline ARB1141122 93.9%13.32491.33125.06501.28
RVP Support87385122 72.9%53.07810.45273.76945.77
Spanish US16314716 78.1%53.40637.87210.781667.69
VP Support (French)25241 72.0%62.34571.12252.33509.19
VP-Addison2 2     147.51
Total         
 Without rearranging the data, moving rows and/or deleting rows.  Calculate the total for the area's highlighted in yellow.
          
   Need the formula how you receive the answers      
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
  • 8 years ago
  • 15
Answer(0)
Bids(0)