{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["VloggingTemplate","ExcelDemy","Data"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"VloggingTemplate","index":0,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"VLOGGING TEMPLATE"]
[]
[null,"Name of Channel owner:",null,null,null,null,"Date:",{"$f":"TODAY()","v":"2017-07-08"}]
[null,"Name of Channel:",null,null,null,null,"Total Likes:",{"$f":"SUM(VloggingRecordT[Likes])","v":310}]
[null,"Total Views:",null,{"$f":"SUM(VloggingRecordT[Views])","v":2700},null,null,"Video with Highest Views:",{"$f":"INDEX(VloggingRecordT[Name of Video],MATCH(MAX(VloggingRecordT[Views]),VloggingRecordT[Views],0))","v":"Video 3"}]
[null,"View Milestone:",null,10000,null,null,"Video with Most Likes:",{"$f":"INDEX(VloggingRecordT[Name of Video],MATCH(MAX(VloggingRecordT[Likes]),VloggingRecordT[Likes],0))","v":"Video 1"}]
[null,"Milestone Progress:",null,{"$f":"IF(D6>D5,\"Have not met milestone yet\",IF(D6<D5, \"Exceeded Milestone\",\"Met milestone exactly\"))","v":"Have not met milestone yet"},null,null,"Number of Subcribers:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Name of Video","Date Uploaded","Month Uploaded","Category","Views","Likes","Like/View Ratio"]
[null,"Video 1","2017-01-01",{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":"January"},"Daily Life Descriptions ",1000,200,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":0.2}]
[null,"Video 2","2017-01-02",{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":"January"},"Product Testing",200,100,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":0.5}]
[null,"Video 3","2017-02-07",{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":"February"},"Product Reviewing",1500,10,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":6.6666666666666671E-3}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Gaming",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Beauty",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Computer/Technology Tutorials",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Musical Instrument Playing or Singing",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Cooking",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Travelling",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Education",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Comedy",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Travelling",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"DIY",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"How To",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"News",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Animation",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Animals",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Sports",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Music",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Advice",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},"Other",null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},null,null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},null,null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},null,null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},null,null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},null,null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},null,null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},null,null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,null,null,{"$f":"IF(VloggingRecordT[[#This Row],[Date Uploaded]]=\"\",\"\",TEXT(VloggingRecordT[[#This Row],[Date Uploaded]],\"mmmm\"))","v":""},null,null,null,{"$f":"IFERROR(VloggingRecordT[[#This Row],[Likes]]/VloggingRecordT[[#This Row],[Views]],\"\")","v":""}]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(109,VloggingRecordT[Views])","v":2700},{"$f":"SUBTOTAL(109,VloggingRecordT[Likes])","v":310}]

{"sheet":"ExcelDemy","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Copyright:","Exceldemy"]
["For other great Excel tutorials and Office templates please visit our blog:","https://www.exceldemy.com/ "]

{"sheet":"Data","index":2,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Daily Life Descriptions "]
["Product Testing"]
["Product Reviewing"]
["Gaming"]
["Beauty"]
["Computer/Technology Tutorials"]
["Musical Instrument Playing or Singing"]
["Cooking"]
["Travelling"]
["Education"]
["Comedy"]
["DIY"]
["How To"]
["News"]
["Animation"]
["Animals"]
["Sports"]
["Music"]
["Advice"]
["Other"]