Customer would like to calculate Cacheflow Cacheability from Accesslog

Some customers may need to generate their own report.

Cacheability ​Formula
CBL% = (1 - (NC_Bytes Remote to Server / Client Bytes Server to Client)) * 100 

Note: Use Accesslog for calculation.
"NC_Bytes Remote to Server": is "rs-bytes" for ONLY 2 "s-action" : "TCP_NC_MISS" and "TCP_NC_MISS_RST" 
"Client Bytes Server to Client": is "sc-bytes" for ALL "s-action" 

Please follow below steps to calculate CBL% 
1. Identify the domain that would like to calculate. For example "apple.com" and "microsoft.com" 

2. Process raw Accesslog 
C:\sgrep>grep "apple.com" "CF_main_.log" >apple.com.txt 
C:\sgrep>grep "microsoft.com" "CF_main_.log" >microsoft.com.txt 

3. After log is processed by domains, then added in first line as below column, this will be used later as a "column name" for Excel file. 
localtime c-ip time-taken sc-status sc-bytes cs-bytes rs-bytes sr-bytes s-action cs-method cs-uri-scheme cs-host cs-uri-port cs-uri-path cs-uri-query cs-uri-extension cs(User-Agent) cs-ip cs-categories c-uri x-exception-id rs(Content-Type) 
(*Above columns are just example for normal Accesslog, if you have changed the format, please use your format)

4. Open the text file in Excel, use "delimited" with "space". 

5. You will get Excel file. Please see example "apple.com.xls" and "microsoft.com.xls" (both files uploaded in attachments) 

- First, calculate "Client Bytes Server to Client", by sum all number in "sc-bytes" 
- Second, calculate "NC_Bytes Remote to Server", by Filter column "s-action" : for ONLY "TCP_NC_MISS" and "TCP_NC_MISS_RST", then summary all number.

6.  Put value in the formula