{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculator","formula&data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Calculator","index":0,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,2,4,6]]}
[]
[]
[]
[]
[null,null,"VSS License Calculator"]
[]
[]
[null,null,1,"Please select your VSS Edition."]
[]
[null,null,2,"Please select system architecture."]
[]
[null,null,3,"Number of cameras in the system?"]
[null,null,null,"Cameras in single VSS server (*fill in the number >0)"]
[null,null,null,"Cameras in VSS substations (*fill in the number >0)"]
[null,null,null,"Cameras in ND/NV substations (*fill in the number >0)"]
[null,null,null,"Cameras in CMS server (*fill in the number >=0)"]
[]
[null,null,null,"Total cameras in system",null,null,{"$f":"SUM(G13:G16)","v":0}]
[]
[null,null,null,"Required licenses"]
[null,null,null,"License for single standalone server"]
[null,null,null,"License for CMS server"]
[null,null,null,"License for substations"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"v2.0"]

{"sheet":"formula&data","index":1,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[[19,6,19,8],[15,6,15,8],[16,6,16,8],[12,6,12,8],[13,6,13,8],[14,6,14,8],[17,6,17,8],[18,6,18,8]]}
[]
[]
[null,null,"License Type","System architectures",null,null,"# of cameras ","Item","License term"]
[null,null,"Standard","Standard","Upgrade_from_standard_to_Pro","Pro","Total cameras in single VSS server","A","Standard license"]
[null,null,"Upgrade_from_standard_to_Pro","Single standalone VSS server","Single standalone VSS server","Single standalone VSS server","Total cameras in VSS substations","B","Pro license"]
[null,null,"Pro","VSS CMS with ND/NV-series NVR substations","VSS CMS with ND/NV-series NVR substations","VSS CMS with VSS substations","Total cameras in ND/NV substations","C","Standard to Pro license"]
[null,null,null,null,null,"VSS CMS with ND/NV-series NVR substations","Total cameras in NR substations","D","Pro Embedded NVR Camera license"]
[null,null,null,null,null,"VSS CMS with VSS and ND/NV-series NVR substations","Total cameras in CMS server","E"]
[null,null,null,null,null,null,"Total cameras in system","F"]
[]
["Formula Table"]
["Index","VSS Edition","System architecture","License in Single VSS server","License in CMS server","License in substations","Formula reference"]
[13,"Standard","Single standalone VSS server",{"$f":"IF(Calculator!G13>8,\nIF(Calculator!G13<=128,\nCalculator!G13-8 & \" \" & I4,\n\"Require Pro Edition\"),\nIF(Calculator!G13<=128,\n\"free\", \"Require Pro Edition\"))","v":"free"},"Invalid","invalid","Assume A>0\nif A > 7 then\nIf A <= 128 then show  A - 8 Std Lic\nOtherwise show \"Require Pro Edition\"\nElse (A<=7)\nIf A <= 128 then show  \"0\"\nOtherwise show \"Require Pro Edition\""]
[14,"Standard","VSS CMS with ND/NV-series NVR substations","invalid",{"$f":"IF(Calculator!G16>8,\nIF(Calculator!G15+Calculator!G16<=128,\nCalculator!G16-8 & \" \" &I4,\n\"Require Pro Edition\"),\nIF(Calculator!G15+Calculator!G16<=128,\n\"free\",\n\"Require Pro Edition\"))","v":"free"},{"$f":"IF(Calculator!G15+Calculator!G16<=128,\n\"free\",\"Require Pro Edition\")","v":"free"},"Assume E>=0\nif E>7 then\nIf C+E <=  128 then show  E - 8 Std Lic\nOtherwise show \"Require Pro Edition\"\nElse (E<=7)\nIf C+E <=  128 then show \"0\"\nOtherwise show \"Require Pro Edition\"\n"]
[15,"Upgrade_from_standard_to_Pro","Single standalone VSS server",{"$f":"IF(Calculator!G13<=8,\nCalculator!G13&\" \"&I5,\nCalculator!G13-8&\" \"&I6&CHAR(10)&\"8 \"& I5)","v":" Pro license"},"invalid","invalid","Assume A>0\nIf A <= 8 then show A Pro Lic\nOtherwise show A-8 Std to Pro Lic and 8 Pro Lic"]
[16,"Upgrade_from_standard_to_Pro","VSS CMS with ND/NV-series NVR substations","invalid",{"$f":"IF(Calculator!G16<=8,\nCalculator!G16 & \" \" & I5 &CHAR(10)& Calculator!G15 & \" \" &'formula&data'!I7,\nCalculator!G16-8 & \" \" & 'formula&data'!I6 &CHAR(10)& \"8 \" & 'formula&data'!I5 &CHAR(10)& Calculator!G15 & \" \" &'formula&data'!I7)","v":" Pro license\n Pro Embedded NVR Camera license"},0,"Assume E >= 0 & C > 0\nIf E <= 8 then \nshow E Pro Lic and C Pro Embedded NVR Lic\nOtherwise   \nshow E-8 Std to Pro Lic and 8 pro Lic and C Pro Embedded NVR Lic"]
[17,"Pro","Single standalone VSS server",{"$f":"Calculator!G13 & \" \" & I5","v":" Pro license"},"invalid","invalid","Assume A >0\nshow A Pro Lic"]
[18,"Pro","VSS CMS with VSS substations","invalid",{"$f":"IF(Calculator!G16>0,\nCalculator!G16 & \" \"&'formula&data'!I5,\n\"0\")","v":"0"},{"$f":" Calculator!G14& \" \"&'formula&data'!I5","v":" Pro license"},"Assume E >= 0 & B > 0\nLic in CMS\nIf E > 0  show E Pro Lic  Else show 0\nLic in substations\nshow B Pro Lic "]
[19,"Pro","VSS CMS with ND/NV-series NVR substations","invalid",{"$f":"IF(Calculator!G16>0,\nCalculator!G16 & \" \" & I5 & CHAR(10) & Calculator!G15 & \" \" &'formula&data'!I7,\nCalculator!G15 & \" \" &'formula&data'!I7)","v":" Pro Embedded NVR Camera license"},0,"Assume E >= 0 & C > 0\nIf E > 0\nshow E Pro Lic and C Pro Embedded NVR Lic\nElse \n show C Pro Embedded NVR Lic"]
["20","Pro","VSS CMS with VSS and ND/NV-series NVR substations","invalid",{"$f":"IF(Calculator!G16>0,\nCalculator!G16 & \" \" &I5 & CHAR(10) & Calculator!G15 & \" \" & 'formula&data'!I7,\nCalculator!G15 & \" \" & 'formula&data'!I7)","v":" Pro Embedded NVR Camera license"},{"$f":"Calculator!G14&\" \"&'formula&data'!I5","v":" Pro license"},"Assume E >= 0 &  C > 0 & B > 0\nLic in CMS\nIf E > 0\nshow E Pro Lic and C Pro Embedded NVR Lic\nElse \nshow C Pro Embedded NVR Lic\nLic in substations\nshow B Pro Lic"]