{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["IT-WS-(2017-18) (8.5X13)","Particulars-FORM 16 (2017-18)","IT-FORM 16 (2017-18)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":3,"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":"IT-WS-(2017-18) (8.5X13)","index":0,"n_rows":178,"n_cols":70,"rows_kept":178,"cut":false,"hidden":false,"merged":[[98,2,99,3],[147,44,148,49],[147,50,148,55],[147,60,148,62],[143,60,144,62],[108,0,114,2],[145,38,146,40],[145,41,146,43],[141,64,142,66],[143,38,144,40],[143,41,144,43],[111,61,112,63],[111,64,112,66],[138,56,139,58],[138,59,139,62],[147,38,148,40],[147,41,148,43],[145,44,146,49],[145,50,146,55],[141,38,142,40],[141,41,142,43],[143,44,144,49],[143,50,144,55],[147,64,148,66],[140,56,148,58],[141,60,142,62],[145,64,146,66],[138,64,139,66],[145,60,146,62],[143,64,144,66],[141,44,142,49],[141,50,142,55],[177,6,177,11],[177,12,177,13],[177,14,177,15],[177,16,177,17],[177,18,177,19],[177,20,177,21],[177,22,177,23],[177,24,177,25],[141,59,142,59],[143,59,144,59],[145,59,146,59],[147,59,148,59],[138,63,139,63],[141,63,142,63],[143,63,144,63],[145,63,146,63],[147,63,148,63],[174,12,174,13],[174,14,174,15],[174,16,174,17],[174,18,174,19],[174,20,174,21],[174,22,174,23],[174,24,174,25],[175,6,175,11],[175,12,175,13],[175,14,175,15],[175,16,175,17],[175,18,175,19],[175,20,175,21],[175,22,175,23],[175,24,175,25],[176,6,176,11],[176,12,176,13],[176,14,176,15],[176,16,176,17],[176,18,176,19],[176,20,176,21],[176,22,176,23],[176,24,176,25],[171,0,171,5],[171,6,171,7],[171,8,171,9],[171,10,171,11],[171,12,171,13],[171,14,171,15],[171,16,171,17],[171,18,171,19],[171,20,171,21],[171,22,171,23],[171,24,171,25],[171,26,171,27],[171,28,171,29],[171,30,171,31],[171,32,171,34],[172,0,172,5],[172,6,172,7],[172,8,172,9],[172,10,172,11],[172,12,172,13],[172,14,172,15],[172,16,172,17],[172,18,172,19],[172,20,172,21],[172,22,172,23],[172,24,172,25],[172,26,172,27],[172,28,172,29],[172,30,172,31],[172,32,172,34],[169,0,169,5],[169,6,169,7],[169,8,169,9],[169,10,169,11],[169,12,169,13],[169,14,169,15],[169,16,169,17],[169,18,169,19],[169,20,169,21],[169,22,169,23],[169,24,169,25],[169,26,169,27],[169,28,169,29],[169,30,169,31],[169,32,169,34],[170,0,170,5],[170,6,170,7],[170,8,170,9],[170,10,170,11],[170,12,170,13],[170,14,170,15],[170,16,170,17],[170,18,170,19],[170,20,170,21],[170,22,170,23],[170,24,170,25],[170,26,170,27],[170,28,170,29],[170,30,170,31],[170,32,170,34],[167,0,167,5],[167,6,167,7],[167,8,167,9],[167,10,167,11],[167,12,167,13],[167,14,167,15],[167,16,167,17],[167,18,167,19],[167,20,167,21],[167,22,167,23],[167,24,167,25],[167,26,167,27],[167,28,167,29],[167,30,167,31],[167,32,167,34],[168,0,168,5],[168,6,168,7],[168,8,168,9],[168,10,168,11],[168,12,168,13],[168,14,168,15],[168,16,168,17],[168,18,168,19],[168,20,168,21],[168,22,168,23],[168,24,168,25],[168,26,168,27],[168,28,168,29],[168,30,168,31],[168,32,168,34],[165,0,165,5],[165,6,165,7],[165,8,165,9],[165,10,165,11],[165,12,165,13],[165,14,165,15],[165,16,165,17],[165,18,165,19],[165,20,165,21],[165,22,165,23],[165,24,165,25],[165,26,165,27],[165,28,165,29],[165,30,165,31],[165,32,165,34],[166,0,166,5],[166,6,166,7],[166,8,166,9],[166,10,166,11],[166,12,166,13],[166,14,166,15],[166,16,166,17],[166,18,166,19],[166,20,166,21],[166,22,166,23],[166,24,166,25],[166,26,166,27],[166,28,166,29],[166,30,166,31],[166,32,166,34],[164,0,164,5],[164,6,164,7],[164,8,164,9],[164,10,164,11],[164,12,164,13],[164,14,164,15],[164,16,164,17],[164,18,164,19],[164,20,164,21],[164,22,164,23],[164,24,164,25],[164,26,164,27],[164,28,164,29],[164,30,164,31],[164,32,164,34],[164,57,164,60],[164,61,164,70],[163,0,163,5],[163,6,163,7],[163,8,163,9],[163,10,163,11],[163,12,163,13],[163,14,163,15],[163,16,163,17],[163,18,163,19],[163,20,163,21],[163,22,163,23],[163,24,163,25],[163,26,163,27],[163,28,163,29],[163,30,163,31],[163,32,163,34],[163,57,163,60],[163,61,163,70],[162,0,162,5],[162,6,162,7],[162,8,162,9],[162,10,162,11],[162,12,162,13],[162,14,162,15],[162,16,162,17],[162,18,162,19],[162,20,162,21],[162,22,162,23],[162,24,162,25],[162,26,162,27],[162,28,162,29],[162,30,162,31],[162,32,162,34],[162,57,162,60],[162,61,162,70],[160,57,160,60],[160,61,160,70],[161,0,161,5],[161,6,161,7],[161,8,161,9],[161,10,161,11],[161,12,161,13],[161,14,161,15],[161,16,161,17],[161,18,161,19],[161,20,161,21],[161,22,161,23],[161,24,161,25],[161,26,161,27],[161,28,161,29],[161,30,161,31],[161,32,161,34],[161,57,161,60],[161,61,161,70],[159,0,159,5],[159,6,159,7],[159,8,159,9],[159,10,159,11],[159,12,159,13],[159,14,159,15],[159,16,159,17],[159,18,159,19],[159,20,159,21],[159,22,159,23],[159,24,159,25],[159,26,159,27],[159,28,159,29],[159,30,159,31],[159,32,159,34],[160,0,160,5],[160,6,160,7],[160,8,160,9],[160,10,160,11],[160,12,160,13],[160,14,160,15],[160,16,160,17],[160,18,160,19],[160,20,160,21],[160,22,160,23],[160,24,160,25],[160,26,160,27],[160,28,160,29],[160,30,160,31],[160,32,160,34],[157,38,157,60],[157,62,157,63],[157,65,157,66],[157,68,157,70],[158,0,158,7],[158,8,158,9],[158,10,158,11],[158,12,158,13],[158,14,158,15],[158,16,158,17],[158,18,158,19],[158,20,158,21],[158,22,158,23],[158,24,158,25],[158,26,158,27],[158,28,158,29],[158,30,158,31],[158,32,158,34],[155,65,155,66],[155,68,155,70],[156,0,156,5],[156,6,156,7],[156,8,156,9],[156,10,156,11],[156,12,156,13],[156,14,156,15],[156,16,156,17],[156,18,156,19],[156,20,156,21],[156,22,156,23],[156,24,156,25],[156,26,156,27],[156,28,156,29],[156,30,156,31],[156,32,156,34],[156,38,156,60],[156,62,156,63],[156,65,156,66],[156,68,156,70],[155,0,155,5],[155,6,155,7],[155,8,155,9],[155,10,155,11],[155,12,155,13],[155,14,155,15],[155,16,155,17],[155,18,155,19],[155,20,155,21],[155,22,155,23],[155,24,155,25],[155,26,155,27],[155,28,155,29],[155,30,155,31],[155,32,155,34],[155,38,155,60],[155,62,155,63],[153,65,153,66],[153,68,153,70],[154,0,154,5],[154,6,154,7],[154,8,154,9],[154,10,154,11],[154,12,154,13],[154,14,154,15],[154,16,154,17],[154,18,154,19],[154,20,154,21],[154,22,154,23],[154,24,154,25],[154,26,154,27],[154,28,154,29],[154,30,154,31],[154,32,154,34],[154,38,154,60],[154,62,154,63],[154,65,154,66],[154,68,154,70],[153,0,153,5],[153,6,153,7],[153,8,153,9],[153,10,153,11],[153,12,153,13],[151,65,151,66],[151,68,151,70],[152,0,152,5],[152,6,152,7],[152,8,152,9],[152,10,152,11],[152,12,152,13],[152,14,152,15],[152,16,152,17],[152,18,152,19],[152,20,152,21],[152,22,152,23],[152,24,152,25],[152,26,152,27],[152,28,152,29],[152,30,152,31],[152,32,152,34],[152,48,152,57],[152,59,152,66],[152,68,152,70],[151,22,151,23],[151,24,151,25],[151,26,151,27],[151,28,151,29],[151,30,151,31],[151,32,151,34],[151,38,151,60],[151,62,151,63],[153,14,153,15],[153,16,153,17],[153,18,153,19],[153,20,153,21],[153,22,153,23],[153,24,153,25],[153,26,153,27],[153,28,153,29],[153,30,153,31],[153,32,153,34],[153,38,153,60],[153,62,153,63],[152,38,152,46],[149,60,149,62],[149,64,149,66],[149,68,149,70],[150,0,150,5],[150,6,150,7],[150,8,150,9],[150,10,150,11],[150,12,150,13],[150,14,150,15],[150,16,150,17],[150,18,150,19],[150,20,150,21],[150,22,150,23],[150,24,150,25],[150,26,150,27],[150,28,150,29],[150,30,150,31],[150,32,150,34],[150,38,150,60],[150,62,150,63],[150,65,150,66],[150,68,150,70],[151,0,151,5],[151,6,151,7],[151,8,151,9],[151,10,151,11],[151,12,151,13],[151,14,151,15],[151,16,151,17],[151,18,151,19],[151,20,151,21],[148,0,148,5],[148,6,148,7],[148,8,148,9],[148,10,148,11],[148,12,148,13],[148,14,148,15],[148,16,148,17],[148,18,148,19],[148,20,148,21],[148,22,148,23],[148,24,148,25],[148,26,148,27],[148,28,148,29],[148,30,148,31],[148,32,148,34],[148,68,148,70],[149,0,149,5],[149,6,149,7],[149,8,149,9],[149,10,149,11],[149,12,149,13],[149,14,149,15],[149,16,149,17],[149,18,149,19],[149,20,149,21],[149,22,149,23],[149,24,149,25],[149,26,149,27],[149,28,149,29],[149,30,149,31],[149,32,149,34],[149,38,149,58],[146,0,146,5],[146,6,146,7],[146,8,146,9],[146,10,146,11],[146,12,146,13],[146,14,146,15],[146,16,146,17],[146,18,146,19],[146,20,146,21],[146,22,146,23],[146,24,146,25],[146,26,146,27],[146,28,146,29],[146,30,146,31],[146,32,146,34],[146,68,146,70],[147,0,147,5],[147,6,147,7],[147,8,147,9],[147,10,147,11],[147,12,147,13],[147,14,147,15],[147,16,147,17],[147,18,147,19],[147,20,147,21],[147,22,147,23],[147,24,147,25],[147,26,147,27],[147,28,147,29],[147,30,147,31],[147,32,147,34],[147,68,147,70],[144,0,144,5],[144,6,144,7],[144,8,144,9],[144,10,144,11],[144,12,144,13],[144,14,144,15],[144,16,144,17],[144,18,144,19],[144,20,144,21],[144,22,144,23],[144,24,144,25],[144,26,144,27],[144,28,144,29],[144,30,144,31],[144,32,144,34],[144,68,144,70],[145,0,145,5],[145,6,145,7],[145,8,145,9],[145,10,145,11],[145,12,145,13],[145,14,145,15],[145,16,145,17],[145,18,145,19],[145,20,145,21],[145,22,145,23],[145,24,145,25],[145,26,145,27],[145,28,145,29],[145,30,145,31],[145,32,145,34],[145,68,145,70],[142,0,142,5],[142,6,142,7],[142,8,142,9],[142,10,142,11],[142,12,142,13],[142,14,142,15],[142,16,142,17],[142,18,142,19],[142,20,142,21],[142,22,142,23],[142,24,142,25],[142,26,142,27],[142,28,142,29],[142,30,142,31],[142,32,142,34],[142,68,142,70],[143,0,143,13],[143,14,143,15],[143,16,143,17],[143,18,143,19],[143,20,143,21],[143,22,143,23],[143,24,143,25],[143,26,143,27],[143,28,143,29],[143,30,143,31],[143,32,143,34],[143,68,143,70],[140,44,140,49],[140,50,140,55],[140,60,140,62],[140,64,140,66],[140,68,140,70],[141,0,141,5],[141,6,141,7],[141,8,141,9],[141,10,141,11],[141,12,141,13],[141,14,141,15],[141,16,141,17],[141,18,141,19],[141,20,141,21],[141,22,141,23],[141,24,141,25],[141,26,141,27],[141,28,141,29],[141,30,141,31],[141,32,141,34],[141,68,141,70],[140,1,140,5],[140,6,140,7],[140,8,140,9],[140,10,140,11],[140,12,140,13],[140,14,140,15],[140,16,140,17],[140,18,140,19],[140,20,140,21],[140,22,140,23],[140,24,140,25],[140,26,140,27],[140,28,140,29],[140,30,140,31],[140,32,140,34],[140,38,140,40],[140,41,140,43],[138,68,138,70],[139,1,139,5],[139,6,139,7],[139,8,139,9],[139,10,139,11],[139,12,139,13],[139,14,139,15],[139,16,139,17],[139,18,139,19],[139,20,139,21],[139,22,139,23],[139,24,139,25],[139,26,139,27],[139,28,139,29],[139,30,139,31],[139,32,139,34],[139,38,139,40],[139,41,139,43],[139,44,139,49],[139,50,139,55],[139,68,139,70],[138,1,138,5],[138,6,138,7],[138,8,138,9],[138,10,138,11],[138,12,138,13],[138,14,138,15],[138,16,138,17],[138,18,138,19],[138,20,138,21],[138,22,138,23],[138,24,138,25],[138,26,138,27],[138,28,138,29],[138,30,138,31],[138,32,138,34],[138,38,138,43],[138,44,138,55],[136,65,136,66],[136,68,136,70],[137,1,137,5],[137,6,137,7],[137,8,137,9],[137,10,137,11],[137,12,137,13],[137,14,137,15],[137,16,137,17],[137,18,137,19],[137,20,137,21],[137,22,137,23],[137,24,137,25],[137,26,137,27],[137,28,137,29],[137,30,137,31],[137,32,137,34],[137,38,137,66],[137,68,137,70],[136,1,136,5],[136,6,136,7],[136,8,136,9],[136,10,136,11],[136,12,136,13],[136,14,136,15],[136,16,136,17],[136,18,136,19],[136,20,136,21],[136,22,136,23],[136,24,136,25],[136,26,136,27],[136,28,136,29],[136,30,136,31],[136,32,136,34],[136,38,136,60],[136,62,136,63],[134,54,134,57],[134,58,134,60],[134,62,134,63],[134,26,134,27],[134,28,134,29],[134,30,134,31],[134,32,134,34],[134,40,134,42],[134,43,134,52],[134,65,134,66],[134,68,134,70],[135,1,135,5],[135,6,135,7],[135,8,135,9],[135,10,135,11],[135,12,135,13],[135,14,135,15],[135,16,135,17],[135,18,135,19],[135,20,135,21],[135,22,135,23],[135,24,135,25],[135,26,135,27],[135,28,135,29],[135,30,135,31],[135,32,135,34],[135,38,135,60],[135,62,135,63],[135,65,135,66],[135,68,135,70],[134,0,134,5],[134,6,134,7],[134,8,134,9],[134,10,134,11],[134,12,134,13],[134,14,134,15],[134,16,134,17],[134,18,134,19],[134,20,134,21],[134,22,134,23],[134,24,134,25],[132,54,132,57],[132,58,132,60],[132,62,132,63],[132,65,132,66],[132,68,132,70],[133,0,133,5],[133,6,133,7],[133,8,133,9],[133,10,133,11],[133,12,133,13],[133,14,133,15],[133,16,133,17],[133,18,133,19],[133,20,133,21],[133,22,133,23],[133,24,133,25],[133,26,133,27],[133,28,133,29],[133,30,133,31],[133,32,133,34],[133,40,133,42],[133,43,133,52],[133,54,133,57],[133,58,133,60],[133,62,133,63],[133,65,133,66],[131,1,131,5],[131,8,131,11],[131,12,131,15],[131,16,131,19],[131,20,131,23],[131,24,131,27],[131,28,131,31],[131,32,131,34],[131,40,131,42],[131,43,131,52],[131,54,131,57],[131,58,131,60],[131,62,131,63],[131,65,131,66],[131,68,131,70],[132,1,132,5],[132,6,132,7],[132,8,132,9],[132,10,132,11],[132,12,132,13],[132,14,132,15],[132,16,132,17],[132,18,132,19],[132,20,132,21],[132,22,132,23],[132,24,132,25],[132,26,132,27],[132,28,132,29],[132,30,132,31],[132,32,132,34],[132,40,132,42],[132,43,132,52],[129,1,129,5],[129,8,129,11],[129,12,129,15],[129,16,129,19],[129,20,129,23],[129,24,129,27],[129,28,129,31],[129,32,129,34],[129,40,129,42],[129,43,129,52],[129,54,129,57],[129,58,129,60],[129,62,129,63],[129,65,129,66],[129,68,129,70],[130,1,130,5],[130,8,130,11],[130,12,130,15],[130,16,130,19],[130,20,130,23],[130,24,130,27],[130,28,130,31],[130,32,130,34],[130,40,130,42],[130,43,130,52],[130,54,130,57],[130,58,130,60],[130,62,130,63],[130,65,130,66],[130,68,130,70],[128,1,128,5],[128,6,128,7],[128,8,128,11],[128,12,128,15],[128,16,128,19],[128,20,128,23],[128,24,128,27],[128,28,128,31],[128,32,128,34],[128,40,128,42],[128,43,128,49],[128,51,128,54],[128,55,128,57],[128,59,128,60],[128,62,128,63],[128,65,128,66],[128,68,128,70],[126,68,126,70],[127,0,127,5],[127,6,127,7],[127,8,127,9],[127,10,127,11],[127,12,127,13],[127,14,127,15],[127,16,127,17],[127,18,127,19],[127,20,127,21],[127,22,127,23],[127,24,127,25],[127,26,127,27],[127,28,127,29],[127,30,127,31],[127,32,127,34],[127,40,127,42],[127,43,127,57],[127,59,127,60],[127,62,127,63],[127,65,127,66],[127,68,127,70],[125,54,125,57],[125,58,125,60],[125,62,125,63],[125,65,125,66],[126,0,126,5],[126,6,126,7],[126,8,126,9],[126,10,126,11],[126,12,126,13],[126,14,126,15],[126,16,126,17],[126,18,126,19],[126,20,126,21],[126,22,126,23],[126,24,126,25],[126,26,126,27],[126,28,126,29],[126,30,126,31],[126,32,126,34],[126,40,126,42],[126,43,126,57],[126,59,126,60],[126,62,126,63],[126,65,126,66],[125,0,125,5],[125,6,125,7],[125,8,125,9],[125,10,125,11],[125,12,125,13],[125,14,125,15],[125,16,125,17],[125,18,125,19],[125,20,125,21],[125,22,125,23],[125,24,125,25],[125,26,125,27],[125,28,125,29],[125,30,125,31],[125,32,125,34],[125,40,125,42],[125,43,125,45],[123,39,123,60],[123,62,123,63],[123,65,123,66],[123,68,123,70],[124,0,124,5],[124,6,124,7],[124,8,124,9],[124,10,124,11],[124,12,124,13],[124,14,124,15],[124,16,124,17],[124,18,124,19],[124,20,124,21],[124,22,124,23],[124,24,124,25],[124,26,124,27],[124,28,124,29],[124,30,124,31],[124,32,124,34],[124,40,124,42],[124,43,124,52],[124,54,124,57],[124,58,124,60],[124,62,124,63],[124,65,124,66],[124,68,124,70],[121,54,121,57],[121,58,121,60],[121,62,121,63],[121,65,121,66],[121,68,121,70],[122,0,122,5],[122,6,122,7],[122,8,122,9],[122,10,122,11],[122,12,122,13],[122,14,122,15],[122,16,122,17],[122,18,122,19],[122,20,122,21],[122,22,122,23],[122,24,122,25],[122,26,122,27],[122,28,122,29],[122,30,122,31],[122,32,122,34],[122,40,122,42],[122,43,122,52],[122,54,122,57],[122,58,122,60],[122,62,122,63],[122,65,122,66],[122,68,122,70],[121,0,121,5],[121,6,121,7],[121,8,121,9],[121,10,121,11],[121,12,121,13],[121,14,121,15],[121,16,121,17],[121,18,121,19],[121,20,121,21],[121,22,121,23],[121,24,121,25],[121,26,121,27],[121,28,121,29],[121,30,121,31],[121,32,121,34],[121,40,121,42],[121,43,121,52],[119,55,119,57],[119,59,119,60],[119,18,119,19],[119,20,119,21],[119,22,119,23],[119,24,119,25],[119,26,119,27],[119,28,119,29],[119,30,119,31],[119,32,119,34],[119,41,119,47],[119,49,119,54],[119,62,119,63],[119,65,119,66],[119,68,119,70],[120,0,120,5],[120,6,120,7],[120,8,120,9],[120,10,120,11],[120,12,120,13],[120,14,120,15],[120,16,120,17],[120,18,120,19],[120,20,120,21],[120,22,120,23],[120,24,120,25],[120,26,120,27],[120,28,120,29],[120,30,120,31],[120,32,120,34],[120,40,120,42],[120,43,120,52],[120,54,120,57],[120,58,120,60],[120,62,120,63],[120,65,120,66],[120,68,120,70],[119,0,119,5],[119,6,119,7]],"merged_total":1580,"flags":["merged_cut"]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"WORKSHEET FOR GROSS SALARY FOR THE FINANCIAL YEAR \",IF(AD88=\"\",\"_____\",AD88),AF88,IF(AH88=\"\",\"_____\",AH88),\" (ASSESSMENT YEAR \",IF(AD89=\"\",\"_____\",AD89),AF89,IF(AH89=\"\",\"_____\",AH89),\")\")","v":"WORKSHEET FOR GROSS SALARY FOR THE FINANCIAL YEAR 2018-2019 (ASSESSMENT YEAR 2019-2020)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"INCOME TAX CALCULATION FOR THE FINANCIAL YEAR \",IF(BN88=\"\",\"_____\",BN88),BP88,IF(BR88=\"\",\"_____\",BR88),\" (ASSESSMENT YEAR \",IF(BN89=\"\",\"_____\",BN89),BP89,IF(BR89=\"\",\"_____\",BR89),\")\")","v":"INCOME TAX CALCULATION FOR THE FINANCIAL YEAR 2018-2019 (ASSESSMENT YEAR 2019-2020)"}]
["Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH (Y/N)",null,"N",null,null,"Before Jan DA",null,null,0.05,null,null,"F.Y.",null,2018,null,"-",null,{"$f":"IF(OR(AD88=\"\",AD88=0),\"\",AD88+1)","v":2019},null,null,"Name",null,null,{"$f":"IF(D88=\"\",\"\",D88)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"PH (Y/N)",null,{"$f":"IF(S88=\"\",\"\",S88)","v":"N"},null,null,null,null,null,null,null,null,"F.Y.",null,{"$f":"IF(AD88=\"\",\"\",AD88)","v":2018},null,{"$f":"IF(AF88=\"\",\"\",AF88)","v":"-"},null,{"$f":"IF(AH88=\"\",\"\",AH88)","v":2019}]
["PAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level",null,6,null,null,"Jan DA",null,null,7.0000000000000007E-2,null,null,"A.Y.",null,{"$f":"IF(OR(AD88=\"\",AD88=0),\"\",AD88+1)","v":2019},null,"-",null,{"$f":"IF(OR(AD89=\"\",AD89=0),\"\",AD89+1)","v":2020},null,null,"PAN",null,null,{"$f":"IF(D89=\"\",\"\",D89)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Level",null,{"$f":"IF(S89=\"\",\"\",S89)","v":6},null,null,null,null,null,null,null,null,"A.Y.",null,{"$f":"IF(AD89=\"\",\"\",AD89)","v":2019},null,{"$f":"IF(AF89=\"\",\"\",AF89)","v":"-"},null,{"$f":"IF(AH89=\"\",\"\",AH89)","v":2020}]
["Desgn",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emp Cd",null,null,null,null,"Jul DA",null,null,0.09,null,null,"Date of Employement",null,null,null,null,null,null,null,null,"Desgn",null,null,{"$f":"IF(D90=\"\",\"\",D90)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Emp Cd",null,{"$f":"IF(S90=\"\",\"\",S90)","v":""}]
["Office",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPS",null,"Y","Month of Increment",null,null,null,null,"Jan",null,null,"From",null,null,null,"To",null,null,null,null,"Office",null,null,{"$f":"IF(D91=\"\",\"\",D91)","v":""}]
["Deductee Type",null,null,"Others",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-04-01",null,null,null,"2019-03-31"]
[null,null,null,"Month & Year",null,null,{"$f":"DATE(AD88,4,1)","v":"2018-04-01"},null,null,null,{"$f":"DATE(AD88,5,1)","v":"2018-05-01"},null,{"$f":"DATE(AD88,6,1)","v":"2018-06-01"},null,{"$f":"DATE(AD88,7,1)","v":"2018-07-01"},null,{"$f":"DATE(AD88,8,1)","v":"2018-08-01"},null,"2017-09-01",null,{"$f":"DATE(AD88,10,1)","v":"2018-10-01"},null,{"$f":"DATE(AD88,11,1)","v":"2018-11-01"},null,{"$f":"DATE(AD88,12,1)","v":"2018-12-01"},null,{"$f":"DATE(AH88,1,1)","v":"2019-01-01"},null,{"$f":"DATE(AH88,2,1)","v":"2019-02-01"},null,{"$f":"DATE(AH88,3,1)","v":"2019-03-01"},null,"Total",null,null,null,null,1,"Gross Salary (Vide Works Sheet enclosed)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"AG123","v":0}]
["Particulars",null,null,null,null,null,{"$f":"DATE(AD88,3,1)","v":"2018-03-01"},null,{"$f":"DATE(AD88,4,1)","v":"2018-04-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"(i) Exemption under Sec.10 (13A) in r/o. HRA for those who actually pay rent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"MIN(BH96:BI98)","v":0}]
["Pay",null,null,null,null,null,0,null,{"$f":"G95","v":0},null,{"$f":"I95","v":0},null,{"$f":"K95","v":0},null,{"$f":"IF(Y91=\"July\",ROUND(M95*103%,-2),M95)","v":0},null,{"$f":"O95","v":0},null,{"$f":"Q95","v":0},null,{"$f":"S95","v":0},null,{"$f":"U95","v":0},null,{"$f":"W95","v":0},null,{"$f":"IF(Y91=\"Jan\",ROUND(Y95*103%,-2),Y95)","v":0},null,{"$f":"AA95","v":0},null,null,null,{"$f":"SUM(G95:AF95)","v":0},null,null,null,null,null,"(Least of the following)"]
["Special Pay",null,null,null,null,null,null,null,0,null,0,null,0,null,{"$f":"M96","v":0},null,{"$f":"O96","v":0},null,{"$f":"Q96","v":0},null,{"$f":"S96","v":0},null,0,null,0,null,{"$f":"Y96","v":0},null,0,null,null,null,{"$f":"SUM(G96:AF96)","v":0},null,null,null,null,null,"(a)","Actual amount of HRA received",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"AG101","v":0}]
["Personal Pay",null,null,null,null,null,null,null,0,null,0,null,0,null,{"$f":"M97","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,{"$f":"SUM(G97:AF97)","v":0},null,null,null,null,null,"(b)","Rent paid in excess of 10% of salary",null,null,null,null,null,null,null,null,"(Rs.",{"$f":"AG126","v":0},null,"-","Rs.",{"$f":"IF(OR(S91=\"Y\",S91=\"y\"),ROUND((AG95+AG102+AG109+AG110)*10%,0),ROUND(AG95*10%,0))","v":0},null,")",null,null,"Rs.",{"$f":"IF((AX97-BB97)<0,0,AX97-BB97)","v":0}]
[null,null,"Qtrs. (Y/N)",null,null,null,"Y",null,"Y",null,"Y",null,"Y",null,{"$f":"M98","v":"Y"},null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,null,null,null,null,null,null,null,null,"(c)","50% of salary",null,null,null,null,null,null,null,null,"(50% of Rs.",null,null,{"$f":"IF(OR(S91=\"Y\",S91=\"y\"),(AG95+AG102+AG109+AG110),ROUND(AG95,0))","v":0},null,null,null,")",null,null,"Rs.",{"$f":"ROUND(AZ98*50%,0)","v":0}]
[null,null,"Classif.",null,"Tpt All",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,null,null,null,null,null,null,null,null,"(ii) Standard Deduction for Salaried & Pensioner (Rs 40,000) Budget 2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",40000]
[null,null,null,null,"HRA",null,"X",null,"X",null,"X",null,"X",null,"X",null,"X",null,"X",null,"X",null,"X",null,"X",null,"X",null,"X",null,null,null,null,null,null,null,null,null,"(iii) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs."]
["House Rent Allowance",null,null,null,null,null,{"$f":"IF(UPPER(G98)=\"Y\",0,IF(G95=0,0,IF(UPPER(G100)=\"X\",IF(ROUND(G95*24%,0)<5400,5400,ROUND(G95*24%,0)),IF(UPPER(G100)=\"Y\",IF(ROUND(G95*16%,0)<3600,3600,ROUND(G95*16%,0)),IF(UPPER(G100)=\"Z\",IF(ROUND(G95*8%,0)<1800,1800,ROUND(G95*8%,0)),0)))))","v":0},null,{"$f":"IF(UPPER(I98)=\"Y\",0,IF(I95=0,0,IF(UPPER(I100)=\"X\",IF(ROUND(I95*24%,0)<5400,5400,ROUND(I95*24%,0)),IF(UPPER(I100)=\"Y\",IF(ROUND(I95*16%,0)<3600,3600,ROUND(I95*16%,0)),IF(UPPER(I100)=\"Z\",IF(ROUND(I95*8%,0)<1800,1800,ROUND(I95*8%,0)),0)))))","v":0},null,{"$f":"IF(UPPER(K98)=\"Y\",0,IF(K95=0,0,IF(UPPER(K100)=\"X\",IF(ROUND(K95*24%,0)<5400,5400,ROUND(K95*24%,0)),IF(UPPER(K100)=\"Y\",IF(ROUND(K95*16%,0)<3600,3600,ROUND(K95*16%,0)),IF(UPPER(K100)=\"Z\",IF(ROUND(K95*8%,0)<1800,1800,ROUND(K95*8%,0)),0)))))","v":0},null,{"$f":"IF(UPPER(M98)=\"Y\",0,IF(M95=0,0,IF(UPPER(M100)=\"X\",IF(ROUND(M95*24%,0)<5400,5400,ROUND(M95*24%,0)),IF(UPPER(M100)=\"Y\",IF(ROUND(M95*16%,0)<3600,3600,ROUND(M95*16%,0)),IF(UPPER(M100)=\"Z\",IF(ROUND(M95*8%,0)<1800,1800,ROUND(M95*8%,0)),0)))))","v":0},null,{"$f":"IF(UPPER(O98)=\"Y\",0,IF(O95=0,0,IF(UPPER(O100)=\"X\",IF(ROUND(O95*24%,0)<5400,5400,ROUND(O95*24%,0)),IF(UPPER(O100)=\"Y\",IF(ROUND(O95*16%,0)<3600,3600,ROUND(O95*16%,0)),IF(UPPER(O100)=\"Z\",IF(ROUND(O95*8%,0)<1800,1800,ROUND(O95*8%,0)),0)))))","v":0},null,{"$f":"IF(UPPER(Q98)=\"Y\",0,IF(Q95=0,0,IF(UPPER(Q100)=\"X\",IF(ROUND(Q95*24%,0)<5400,5400,ROUND(Q95*24%,0)),IF(UPPER(Q100)=\"Y\",IF(ROUND(Q95*16%,0)<3600,3600,ROUND(Q95*16%,0)),IF(UPPER(Q100)=\"Z\",IF(ROUND(Q95*8%,0)<1800,1800,ROUND(Q95*8%,0)),0)))))","v":0},null,{"$f":"IF(UPPER(S98)=\"Y\",0,IF(S95=0,0,IF(UPPER(S100)=\"X\",IF(ROUND(S95*24%,0)<5400,5400,ROUND(S95*24%,0)),IF(UPPER(S100)=\"Y\",IF(ROUND(S95*16%,0)<3600,3600,ROUND(S95*16%,0)),IF(UPPER(S100)=\"Z\",IF(ROUND(S95*8%,0)<1800,1800,ROUND(S95*8%,0)),0)))))","v":0},null,{"$f":"IF(UPPER(U98)=\"Y\",0,IF(U95=0,0,IF(UPPER(U100)=\"X\",IF(ROUND(U95*24%,0)<5400,5400,ROUND(U95*24%,0)),IF(UPPER(U100)=\"Y\",IF(ROUND(U95*16%,0)<3600,3600,ROUND(U95*16%,0)),IF(UPPER(U100)=\"Z\",IF(ROUND(U95*8%,0)<1800,1800,ROUND(U95*8%,0)),0)))))","v":0},null,{"$f":"IF(UPPER(W98)=\"Y\",0,IF(W95=0,0,IF(UPPER(W100)=\"X\",IF(ROUND(W95*24%,0)<5400,5400,ROUND(W95*24%,0)),IF(UPPER(W100)=\"Y\",IF(ROUND(W95*16%,0)<3600,3600,ROUND(W95*16%,0)),IF(UPPER(W100)=\"Z\",IF(ROUND(W95*8%,0)<1800,1800,ROUND(W95*8%,0)),0)))))","v":0},null,{"$f":"IF(UPPER(Y98)=\"Y\",0,IF(Y95=0,0,IF(UPPER(Y100)=\"X\",IF(ROUND(Y95*24%,0)<5400,5400,ROUND(Y95*24%,0)),IF(UPPER(Y100)=\"Y\",IF(ROUND(Y95*16%,0)<3600,3600,ROUND(Y95*16%,0)),IF(UPPER(Y100)=\"Z\",IF(ROUND(Y95*8%,0)<1800,1800,ROUND(Y95*8%,0)),0)))))","v":0},null,{"$f":"IF(UPPER(AA98)=\"Y\",0,IF(AA95=0,0,IF(UPPER(AA100)=\"X\",IF(ROUND(AA95*24%,0)<5400,5400,ROUND(AA95*24%,0)),IF(UPPER(AA100)=\"Y\",IF(ROUND(AA95*16%,0)<3600,3600,ROUND(AA95*16%,0)),IF(UPPER(AA100)=\"Z\",IF(ROUND(AA95*8%,0)<1800,1800,ROUND(AA95*8%,0)),0)))))","v":0},null,{"$f":"IF(UPPER(AC98)=\"Y\",0,IF(AC95=0,0,IF(UPPER(AC100)=\"X\",IF(ROUND(AC95*24%,0)<5400,5400,ROUND(AC95*24%,0)),IF(UPPER(AC100)=\"Y\",IF(ROUND(AC95*16%,0)<3600,3600,ROUND(AC95*16%,0)),IF(UPPER(AC100)=\"Z\",IF(ROUND(AC95*8%,0)<1800,1800,ROUND(AC95*8%,0)),0)))))","v":0},null,null,null,{"$f":"SUM(G101:AF101)","v":0},null,null,null,null,null,"Aggregate of 2 (i) to 2 (iii)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"SUM(BQ94:BS100)","v":40000}]
["Dearness Allowance",null,null,null,null,null,{"$f":"ROUND(G95*$Y88,0)","v":0},null,{"$f":"ROUND(I95*$Y89,0)","v":0},null,{"$f":"ROUND(K95*$Y89,0)","v":0},null,{"$f":"ROUND(M95*$Y89,0)","v":0},null,0,null,0,null,0,null,{"$f":"ROUND(U95*$Y90,0)","v":0},null,{"$f":"ROUND(W95*$Y90,0)","v":0},null,{"$f":"ROUND(Y95*$Y90,0)","v":0},null,{"$f":"ROUND(AA95*$Y90,0)","v":0},null,{"$f":"ROUND(AC95*$Y90,0)","v":0},null,null,null,0,null,null,null,null,3,"BALANCE (1 - 2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"BQ93-BQ101","v":-40000}]
["Transport Allowance",null,null,null,null,null,0,null,{"$f":"G103","v":0},null,{"$f":"I103","v":0},null,{"$f":"K103","v":0},null,{"$f":"M103","v":0},null,{"$f":"O103","v":0},null,{"$f":"Q103","v":0},null,{"$f":"S103","v":0},null,{"$f":"U103","v":0},null,{"$f":"W103","v":0},null,{"$f":"Y103","v":0},null,{"$f":"AA103","v":0},null,null,null,0,null,null,null,null,4,"Deductions:"]
["DA on Transport Allowance",null,null,null,null,null,{"$f":"ROUND(G103*$Y88,0)","v":0},null,{"$f":"ROUND(I103*$Y89,0)","v":0},null,{"$f":"ROUND(K103*$Y89,0)","v":0},null,{"$f":"ROUND(M103*$Y89,0)","v":0},null,{"$f":"ROUND(O103*$Y89,0)","v":0},null,{"$f":"ROUND(Q103*$Y89,0)","v":0},null,{"$f":"ROUND(S103*$Y89,0)","v":0},null,{"$f":"ROUND(U103*$Y90,0)","v":0},null,{"$f":"ROUND(W103*$Y90,0)","v":0},null,{"$f":"ROUND(Y103*$Y90,0)","v":0},null,{"$f":"ROUND(AA103*$Y90,0)","v":0},null,{"$f":"ROUND(AC103*$Y90,0)","v":0},null,null,null,0,null,null,null,null,null,"(a)","Entertainment Allowance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs."]
["Total Salary",null,null,null,null,null,{"$f":"SUM(G95:H97,G101:H104)","v":0},null,{"$f":"SUM(I95:J97,I101:J104)","v":0},null,{"$f":"SUM(K95:L97,K101:L104)","v":0},null,{"$f":"SUM(M95:N97,M101:N104)","v":0},null,{"$f":"SUM(O95:P97,O101:P104)","v":0},null,{"$f":"SUM(Q95:R97,Q101:R104)","v":0},null,{"$f":"SUM(S95:T97,S101:T104)","v":0},null,{"$f":"SUM(U95:V97,U101:V104)","v":0},null,{"$f":"SUM(W95:X97,W101:X104)","v":0},null,{"$f":"SUM(Y95:Z97,Y101:Z104)","v":0},null,{"$f":"SUM(AA95:AB97,AA101:AB104)","v":0},null,{"$f":"SUM(AC95:AD97,AC101:AD104)","v":0},null,null,null,0,null,null,null,null,null,"(b)","Tax on Employment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"AG127","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Aggregate of 4 (a) and (b)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"SUM(BH104:BI105)","v":0}]
["Nett Salary",null,null,null,null,null,{"$f":"G105-G106","v":0},null,{"$f":"I105-I106","v":0},null,{"$f":"K105-K106","v":0},null,{"$f":"M105-M106","v":0},null,{"$f":"O105-O106","v":0},null,{"$f":"Q105-Q106","v":0},null,{"$f":"S105-S106","v":0},null,{"$f":"U105-U106","v":0},null,{"$f":"W105-W106","v":0},null,{"$f":"Y105-Y106","v":0},null,{"$f":"AA105-AA106","v":0},null,{"$f":"AC105-AC106","v":0},null,null,null,0,null,null,null,null,6,"Income chargeable under the head \"Salaries\" (3 - 5)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"BQ102-BQ106","v":-40000}]
[{"$f":"IF(OR(S91=\"Y\",S91=\"y\"),\"Govt's cont 2 NPS on Pay\",\"\")","v":"Govt's cont 2 NPS on Pay"},null,null,null,null,null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((G95+G102)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((I95+I102)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((K95+K102)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((M95+M102)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((O95+O102)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((Q95+Q102)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((S95+S102)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((U95+U102)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((W95+W102)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((Y95+Y102)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((AA95+AA102)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((AC95+AC102)*10%,0),\" \")","v":0},null,null,null,0,null,null,null,null,7,"Add: Any other income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"SUM(BH109:BI110)","v":0}]
["ARREARS",null,null,"Pay",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,{"$f":"IF(OR(B129=\"\",B129=0),\"\",B129)","v":"Inc. from House Property"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(AG132<-200000,-200000,AG132)","v":0}]
[null,null,null,"DA",null,null,null,null,{"$f":"(ROUND(G95*Y89,0)-ROUND(G95*Y88,0))*3","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(ROUND(O95*Y90,0)+ROUND(Q95*Y90,0))-(ROUND(O95*Y89,0)+ROUND(Q95*Y89,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,2,{"$f":"IF(OR(B133=\"\",B133=0),\"\",B133)","v":"Interest on Housing Loan"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"AG133","v":0}]
[null,null,null,"HRA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,8,"GROSS TOTAL INCOME (6 + 7)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"BQ107+BQ108","v":-40000}]
[null,null,null,"TA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G112:AF112)","v":0},null,null,null,null,9,"DEDUCTIONS UNDER CHAPTER VI-A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross Amount",null,null,"Deductible Amount"]
[null,null,null,"DA on TA",null,null,null,null,{"$f":"(I104-G104)*3","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(ROUND(O103*Y90,0)+ROUND(Q103*Y90,0))-(ROUND(O103*Y89,0)+ROUND(Q103*Y89,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"(A)","Sections 80C, 80CCC and 80CCD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,"(a)","Section 80C"]
[null,null,null,"Total",null,null,{"$f":"SUM(G109:H114)","v":0},null,{"$f":"SUM(I109:J114)","v":0},null,{"$f":"SUM(K109:L114)","v":0},null,{"$f":"SUM(M109:N114)","v":0},null,{"$f":"SUM(O109:P114)","v":0},null,{"$f":"SUM(Q109:R114)","v":0},null,{"$f":"SUM(S109:T114)","v":0},null,{"$f":"SUM(U109:V114)","v":0},null,{"$f":"SUM(W109:X114)","v":0},null,{"$f":"SUM(Y109:Z114)","v":0},null,{"$f":"SUM(AA109:AB114)","v":0},null,{"$f":"SUM(AC109:AD114)","v":0},null,{"$f":"SUM(AE109:AF114)","v":0},null,0,null,null,null,null,null,null,null,"(i)",{"$f":"IF(OR(B136=\"\",B136=0),\"\",B136)","v":"GPF Contribution"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"AG136","v":0}]
[{"$f":"IF(OR(S91=\"Y\",S91=\"y\"),\"Govt's cont 2 NPS on Arrs\",\"\")","v":"Govt's cont 2 NPS on Arrs"},null,null,null,null,null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((G109+G110)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((I109+I110)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((K109+K110)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((M109+M110)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((O109+O110)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((Q109+Q110)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((S109+S110)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((U109+U110)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((W109+W110)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((Y109+Y110)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((AA109+AA110)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((AC109+AC110)*10%,0),\" \")","v":0},null,{"$f":"IF(OR($S$91=\"Y\",$S$91=\"y\"),ROUND((AE109+AE110)*10%,0),\" \")","v":0},null,0,null,null,null,null,null,null,null,"(ii)","CGEGIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",0]
[{"$f":"CONCATENATE(\"Bonus for \",AD88-1,\"-\",AD88)","v":"Bonus for 2017-2018"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"(iii)","HBA Repayment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",0]
["C.E.A.R.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"(iv)","PLI/LIC/MF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",0]
["EL Encash (LTC)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G119:AF119)","v":0},null,null,null,null,null,null,null,"(v)","Tuition Fees paid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",0]
["Overtime Allowance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"(vi)","",null,null,null,null,null,null,null,"(i) to (vi) limited to Rs.",null,null,null,null,null,150000,null,null,"Rs.",0,null,"Rs.",{"$f":"AG142","v":0},null,"Rs.",{"$f":"IF(BK120>BD120,BD120,BK120)","v":0}]
["Honorarium",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,"(b)","Sec.80-CCD (1)",null,null,"New Pension Scheme (Contribution by the assessee)",null,null,null,null,null,null,null,null,null,null,"limited to Rs.",null,null,null,150000,null,null,"Rs.",{"$f":"AG143","v":0},null,"Rs.",{"$f":"IF(BK121>BG121,BG121,BK121)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"Sec.80-CCE",null,null,"Total u/s.80-C, 80-CCC, 80-CCD",null,null,null,null,null,null,null,null,null,null,"limited to Rs.",null,null,null,150000,null,null,"Rs.",{"$f":"AG144","v":0},null,"Rs.",{"$f":"IF(BK122>BG122,BG122,BK122)","v":0}]
["Gross Salary",null,null,null,null,null,{"$f":"SUM(G105,G108,G115:H122)","v":0},null,{"$f":"SUM(I105,I108,I115:J122)","v":0},null,{"$f":"SUM(K105,K108,K115:L122)","v":0},null,{"$f":"SUM(M105,M108,M115:N122)","v":0},null,{"$f":"SUM(O105,O108,O115:P122)","v":0},null,{"$f":"SUM(Q105,Q108,Q115:R122)","v":0},null,{"$f":"SUM(S105,S108,S115:T122)","v":0},null,{"$f":"SUM(U105,U108,U115:V122)","v":0},null,{"$f":"SUM(W105,W108,W115:X122)","v":0},null,{"$f":"SUM(Y105,Y108,Y115:Z122)","v":0},null,{"$f":"SUM(AA105,AA108,AA115:AB122)","v":0},null,{"$f":"SUM(AC105,AC108,AC115:AD122)","v":0},null,{"$f":"SUM(AE105,AE108,AE115:AF122)","v":0},null,0,null,null,null,null,null,null,null,"Sec.80-CCD (2)",null,null,"New Pension Scheme (Government's contribution)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"AG145","v":0},null,"Rs.",{"$f":"AG145","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(B)","OTHER SECTIONS"]
["Details of Deductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(a)","Sec.80CCD (1b)",null,null,"Additional contribution under NPS",null,null,null,null,null,null,null,null,null,null,"limited to Rs.",null,null,null,50000,null,null,"Rs.",{"$f":"AG146","v":0},null,"Rs.",{"$f":"IF(BK125>BG125,BG125,BK125)","v":0}]
["Rent paid for HRA Exemption",null,null,null,null,null,null,null,null,null,{"$f":"I126","v":0},null,{"$f":"K126","v":0},null,{"$f":"M126","v":0},null,{"$f":"O126","v":0},null,{"$f":"Q126","v":0},null,{"$f":"S126","v":0},null,{"$f":"U126","v":0},null,{"$f":"W126","v":0},null,{"$f":"Y126","v":0},null,{"$f":"AA126","v":0},null,{"$f":"AC126","v":0},null,{"$f":"SUM(G126:AF126)","v":0},null,null,null,null,null,null,"(b)","Sec.80-CCG",null,null,"RGESS",null,null,null,null,null,null,null,null,null,null,"limited to Rs.",null,null,null,25000,null,null,"Rs.",{"$f":"AG147","v":0},null,"Rs.",{"$f":"IF(BK126>BG126,BG126,BK126)","v":0}]
["Ded U/S.16-Professional Tax",null,null,null,null,null,0,null,{"$f":"G127","v":0},null,{"$f":"I127","v":0},null,{"$f":"K127","v":0},null,{"$f":"M127","v":0},null,{"$f":"O127","v":0},null,{"$f":"Q127","v":0},null,{"$f":"S127","v":0},null,{"$f":"U127","v":0},null,{"$f":"W127","v":0},null,{"$f":"Y127","v":0},null,{"$f":"AA127","v":0},null,null,null,{"$f":"SUM(G127:AF127)","v":0},null,null,null,null,null,null,"(c)","Sec.80-D",null,null,"Medical Insr. Prem",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"AG148","v":0}]
["Any Other Income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CGHS Contribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",0]
[1,"Inc. from House Property",null,null,null,null,null,null,"Rental income",null,null,null,"Less:Municipal Taxes",null,null,null,"Net Annual Value",null,null,null,"30% std ded on NAV",null,null,null,"Interest on home loan",null,null,null,"Net Chargeable Income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total of Sec.80-D",null,null,null,null,null,null,null,"limited to Rs.",null,null,null,25000,null,null,"Rs.",null,null,"Rs.",{"$f":"BH129","v":0},null,"Rs.",{"$f":"IF(BK129>BD129,BD129,BK129)","v":0}]
[null,"(i) Self Occupied ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q130,-(U130+Y130))","v":0},null,null,null,null,null,null,null,null,null,null,"(d)","Sec.80-DD",null,null,"Handicapped dependant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"AG151","v":0},null,"Rs.",{"$f":"AG151","v":0}]
[null,"(ii) Let out",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I131,-M131)","v":0},null,null,null,{"$f":"ROUND(Q131*30%,0)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Q131,-(U131+Y131))","v":0},null,null,null,null,null,null,null,null,null,null,"(e)","Sec.80-DDB",null,null,"Medical treatment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",0,null,"Rs.",{"$f":"AG152","v":0}]
[null,"(iii) Let out",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(AC130:AF132)","v":0},{"$f":"IF(SUM(AD133:AG135)<=-200000,-200000,SUM(AD133:AG135))","v":0},0,null,null,null,null,"(f)","Sec.80-E",null,null,"Education Loan (Int. only)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",0,null,"Rs.",{"$f":"AG153","v":0}]
[2,"Interest on Housing Loan",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G133:AF133)","v":0},null,null,null,null,null,null,"(g)","Sec.80-G",null,null,"Donations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",0,null,"Rs.",{"$f":"AG154","v":0}]
["Dedns under Ch. VI A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(h)","Sec.80-TTA",null,null,"Int. on SB",null,null,null,null,null,null,null,null,null,null,"limited to Rs.",null,null,null,10000,null,null,"Rs.",0,null,"Rs.",{"$f":"IF(BK134>BG134,10000,BK134)","v":0}]
["Sec-80C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(g)","Sec.80-U",null,null,"Handicapped Assessee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",0,null,"Rs.",{"$f":"AG156","v":0}]
[1,"GPF Contribution",null,null,null,null,0,null,{"$f":"G136","v":0},null,{"$f":"I136","v":0},null,{"$f":"K136","v":0},null,{"$f":"M136","v":0},null,{"$f":"O136","v":0},null,{"$f":"Q136","v":0},null,{"$f":"S136","v":0},null,{"$f":"U136","v":0},null,{"$f":"W136","v":0},null,{"$f":"Y136","v":0},null,{"$f":"AA136","v":0},null,null,null,{"$f":"SUM(G136:AF136)","v":0},null,null,null,null,10,"Aggregate of deductible amount under Ch.VI-A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"SUM(BN122:BO135)","v":0}]
[2,"CGEGIS",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,null,11,"TOTAL INCOME (8 - 10) (Rounded to nearest TEN Rupees)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"ROUND((BQ111-BQ136),-1)","v":-40000}]
[3,"HBA Repayment",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,null,12,"TAX ON TOTAL INCOME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"BM150","v":0}]
[4,"PLI/LIC/MF",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,null,null,"Taxable Income",null,null,null,null,null,"Income Tax",null,null,null,null,null,null,null,null,null,null,null,"Catgy. of Assessee",null,null,"Total Income",null,null,null,"Rate","Income Tax (Rs.)"]
[5,"Tuition Fees paid",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,null,null,"From",null,null,"To",null,null,"Senior Citizen",null,null,null,null,null,"Others"]
[6,null,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,null,null,0,null,null,250000,null,null,"NIL",null,null,null,null,null,"NIL",null,null,null,null,null,{"$f":"IF(OR(D92=\"Others\",D92=\"Women\",D92=\"\"),\"OTHERS\",\"SENIOR CITIZEN\")","v":"OTHERS"},null,null,"Rs.",{"$f":"IF(OR(BQ137=\"\",BQ137=0),0,IF(BQ137>AP141,AP141,BQ137))","v":-40000},null,null,{"$f":"IF(BE141=\"OTHERS\",0%,0%)","v":0},{"$f":"ROUND(BI141*BL141,0)","v":0}]
["Total U/S. 80C",null,null,null,null,null,{"$f":"SUM(G136:H141)","v":0},null,{"$f":"SUM(I136:J141)","v":0},null,{"$f":"SUM(K136:L141)","v":0},null,{"$f":"SUM(M136:N141)","v":0},null,{"$f":"SUM(O136:P141)","v":0},null,{"$f":"SUM(Q136:R141)","v":0},null,{"$f":"SUM(S136:T141)","v":0},null,{"$f":"SUM(U136:V141)","v":0},null,{"$f":"SUM(W136:X141)","v":0},null,{"$f":"SUM(Y136:Z141)","v":0},null,{"$f":"SUM(AA136:AB141)","v":0},null,{"$f":"SUM(AC136:AD141)","v":0},null,{"$f":"SUM(AE136:AF141)","v":0},null,0,null,null,null,null,null,{"$f":"AP141+1","v":250001},null,null,300000,null,null,"NIL",null,null,null,null,null,{"$f":"CONCATENATE(\"5% of Income exceeding Rs.\",AP141)","v":"5% of Income exceeding Rs.250000"},null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR(BQ137=\"\",BQ137=0),0,IF((BQ137-BI141)>(AP142-AP141),(AP142-AP141),(BQ137-BI141)))","v":0},null,null,0.05,{"$f":"ROUND(BI142*BL142,0)","v":0}]
["Sec-80CCD (1)-NPS Contr",null,null,null,null,null,{"$f":"SUM(G108,G116)","v":0},null,{"$f":"SUM(I108,I116)","v":0},null,{"$f":"SUM(K108,K116)","v":0},null,{"$f":"SUM(M108,M116)","v":0},null,{"$f":"SUM(O108,O116)","v":0},null,{"$f":"SUM(Q108,Q116)","v":0},null,{"$f":"SUM(S108,S116)","v":0},null,{"$f":"SUM(U108,U116)","v":0},null,{"$f":"SUM(W108,W116)","v":0},null,{"$f":"SUM(Y108,Y116)","v":0},null,{"$f":"SUM(AA108,AA116)","v":0},null,{"$f":"SUM(AC108,AC116)","v":0},null,{"$f":"SUM(AE108,AE116)","v":0},null,0]
["Tot - 80C, 80CCC & 80CCD (1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG142,AG143)","v":0},null,null,null,null,null,{"$f":"AP142+1","v":300001},null,null,500000,null,null,{"$f":"CONCATENATE(\"5% of Income exceeding Rs.\",AP142)","v":"5% of Income exceeding Rs.300000"},null,null,null,null,null,"-do-",null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR(BQ137=\"\",BQ137=0),0,IF((BQ137-(BI141+BI142))>(AP144-AP142),(AP144-AP142),(BQ137-(BI141+BI142))))","v":0},null,null,0.05,{"$f":"ROUND(BI144*BL144,0)","v":0}]
["Sec-80CCD (2)-Govt Contr",null,null,null,null,null,{"$f":"G143","v":0},null,{"$f":"I143","v":0},null,{"$f":"K143","v":0},null,{"$f":"M143","v":0},null,{"$f":"O143","v":0},null,{"$f":"Q143","v":0},null,{"$f":"S143","v":0},null,{"$f":"U143","v":0},null,{"$f":"W143","v":0},null,{"$f":"Y143","v":0},null,{"$f":"AA143","v":0},null,{"$f":"AC143","v":0},null,{"$f":"AE143","v":0},null,{"$f":"SUM(G145:AF145)","v":0}]
["Sec-80CCD(1b)-Addl. NPS",null,null,null,null,null,{"$f":"IF((AG144>150000),IF((AG143>150000),(AG143-150000),0),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G146:AF146)","v":0},null,null,null,null,null,{"$f":"AP144+1","v":500001},null,null,1000000,null,null,{"$f":"CONCATENATE((AP144-AP142)*BL144,\"+20% of Income exceeding Rs.\",AP144)","v":"10000+20% of Income exceeding Rs.500000"},null,null,null,null,null,{"$f":"CONCATENATE((AP144-AP141)*BL144,\"+20% of Income exceeding Rs.\",AP144)","v":"12500+20% of Income exceeding Rs.500000"},null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR(BQ137=\"\",BQ137=0),0,IF((BQ137-(BI141+BI142+BI144))>(AP146-AP144),(AP146-AP144),(BQ137-(BI141+BI142+BI144))))","v":0},null,null,{"$f":"IF(BE141=\"OTHERS\",20%,20%)","v":0.2},{"$f":"ROUND(BI146*BL146,0)","v":0}]
["Sec-80CCG - RGESS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G147:AF147)","v":0}]
["Sec-80D-Medical Insur. Prem.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G148:AF148)","v":0},null,null,null,null,null,{"$f":"AP146+1","v":1000001},null,null,"Above",null,null,{"$f":"CONCATENATE(((AP144-AP142)*BL144)+((AP146-AP144)*BL146),\"+30% of Income exceeding Rs.\",AP146)","v":"110000+30% of Income exceeding Rs.1000000"},null,null,null,null,null,{"$f":"CONCATENATE(((AP144-AP141)*BL144)+((AP146-AP144)*BL146),\"+30% of Income exceeding Rs.\",AP146)","v":"112500+30% of Income exceeding Rs.1000000"},null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR(BQ137=\"\",BQ137=0),0,IF(BQ137>(BI141+BI142+BI144+BI146),BQ137-(BI141+BI142+BI144+BI146),0))","v":0},null,null,{"$f":"IF(BE141=\"OTHERS\",30%,30%)","v":0.3},{"$f":"ROUND(BI148*BL148,0)","v":0}]
["Sec-80D-CGHS Contribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total of Sec 80-D",null,null,null,null,null,{"$f":"SUM(G148:H149)","v":0},null,{"$f":"SUM(I148:J149)","v":0},null,{"$f":"SUM(K148:L149)","v":0},null,{"$f":"SUM(M148:N149)","v":0},null,{"$f":"SUM(O148:P149)","v":0},null,{"$f":"SUM(Q148:R149)","v":0},null,{"$f":"SUM(S148:T149)","v":0},null,{"$f":"SUM(U148:V149)","v":0},null,{"$f":"SUM(W148:X149)","v":0},null,{"$f":"SUM(Y148:Z149)","v":0},null,{"$f":"SUM(AA148:AB149)","v":0},null,{"$f":"SUM(AC148:AD149)","v":0},null,{"$f":"SUM(AE148:AF149)","v":0},null,{"$f":"SUM(G150:AF150)","v":0},null,null,null,null,null,"TOTAL   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"SUM(BI141:BI149)","v":-40000},null,null,"Rs.",{"$f":"SUM(BM141:BM149)","v":0}]
["Sec-80DD-Handicap Dependent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,13,"Sec. 87A - Tax Rebate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(BQ137=0,0,IF(BQ137<=350000,IF(BQ138>=2500,2500,BQ138),0))","v":0}]
["Sec-80DDB-Medical Treatment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,14,"Tax on Total Income after Tax Rebate u/s. 87A (12 - 13)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"BQ138-BQ151","v":0}]
["Sec-80E-Educn Loan (Int only)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,15,"Edn Cess + Health Cess @ ",null,null,null,null,null,null,null,null,0.04,{"$f":"\"of Rs.\"&BQ152&\" + Hr. Sec. Edu Cess @ \"","v":"of Rs.0 + Hr. Sec. Edu Cess @ "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"ROUND(BQ152*AV153,0)","v":0}]
["Sec-80G-Donations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,16,"Tax payable (14 + 15)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"SUM(BQ152,BQ153)","v":0}]
["Sec-80TTA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G155:AF155)","v":0},null,null,null,null,17,"Relief under Section 89 (attach details)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"AG157","v":0}]
["Sec-80U-Handcap Assessee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,18,"Tax payable (16 - 17)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"BQ154-BQ155","v":0}]
["Relief u/s. 89 (Attach Details)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,19,"Income Tax paid (Details as per Worksheet attached)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"Y177","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Balance Tax [18 - 19]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"BQ156-BQ157","v":0}]
["(2) Tax Deducted at Source"]
["Deduction made in",null,null,null,null,null,"This Off",null,"This Off",null,"This Off",null,"This Off",null,"This Off",null,"This Off",null,"This Off",null,"This Off",null,"This Off",null,"This Off",null,"This Off",null,"This Off",null,"This Off"]
[null,null,null,null,null,null,{"$f":"DATE($AD88,4,1)","v":"2018-04-01"},null,{"$f":"DATE($AD88,4,30)","v":"2018-04-30"},null,{"$f":"DATE($AD88,5,31)","v":"2018-05-31"},null,{"$f":"DATE($AD88,6,30)","v":"2018-06-30"},null,{"$f":"DATE($AD88,7,31)","v":"2018-07-31"},null,{"$f":"DATE($AD88,8,31)","v":"2018-08-31"},null,{"$f":"DATE($AD88,9,30)","v":"2018-09-30"},null,{"$f":"DATE($AD88,10,31)","v":"2018-10-31"},null,{"$f":"DATE($AD88,11,30)","v":"2018-11-30"},null,{"$f":"DATE($AD88,12,31)","v":"2018-12-31"},null,{"$f":"DATE($AH88,1,31)","v":"2019-01-31"},null,{"$f":"DATE($AH88,2,28)","v":"2019-02-28"},null,{"$f":"DATE($AH88,3,31)","v":"2019-03-31"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIGNATURE    :"]
["IT deducted",null,null,null,null,null,0,null,{"$f":"G162","v":0},null,{"$f":"I162","v":0},null,{"$f":"K162","v":0},null,{"$f":"M162","v":0},null,{"$f":"O162","v":0},null,{"$f":"Q162","v":0},null,{"$f":"S162","v":0},null,{"$f":"U162","v":0},null,{"$f":"W162","v":0},null,{"$f":"Y162","v":0},null,{"$f":"AA162","v":0},null,null,null,{"$f":"SUM(G162:AF162)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NAME            :",null,null,null,{"$f":"IF(D88=\"\",\"\",D88)","v":""}]
["Cess deducted",null,null,null,null,null,{"$f":"G162*0.02+G162*0.01","v":0},null,{"$f":"I162*0.02+I162*0.01","v":0},null,{"$f":"K162*0.02+K162*0.01","v":0},null,{"$f":"M162*0.02+M162*0.01","v":0},null,{"$f":"O162*0.02+O162*0.01","v":0},null,{"$f":"Q162*0.02+Q162*0.01","v":0},null,{"$f":"S162*0.02+S162*0.01","v":0},null,{"$f":"U162*0.02+U162*0.01","v":0},null,0,null,{"$f":"Y162*0.02+Y162*0.01","v":0},null,{"$f":"AA162*0.02+AA162*0.01","v":0},null,{"$f":"AC162*0.02+AC162*0.01","v":0},null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DESIGNATION :",null,null,null,{"$f":"IF(D90=\"\",\"\",D90)","v":""}]
["Total TDS deducted",null,null,null,null,null,{"$f":"SUM(G162:H163)","v":0},null,{"$f":"SUM(I162:J163)","v":0},null,{"$f":"SUM(K162:L163)","v":0},null,{"$f":"SUM(M162:N163)","v":0},null,{"$f":"SUM(O162:P163)","v":0},null,{"$f":"SUM(Q162:R163)","v":0},null,{"$f":"SUM(S162:T163)","v":0},null,{"$f":"SUM(U162:V163)","v":0},null,{"$f":"SUM(W162:X163)","v":0},null,{"$f":"SUM(Y162:Z163)","v":0},null,{"$f":"SUM(AA162:AB163)","v":0},null,{"$f":"SUM(AC162:AD163)","v":0},null,{"$f":"SUM(AE162:AF163)","v":0},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OFFICE          :",null,null,null,{"$f":"IF(D91=\"\",\"\",D91)","v":""}]
["I.T. thru Challan/Bank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE             :"]
["Cess thru Challan/Bank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total TDS thru Challan/Bank",null,null,null,null,null,{"$f":"SUM(G165:H166)","v":0},null,{"$f":"SUM(I165:J166)","v":0},null,{"$f":"SUM(K165:L166)","v":0},null,{"$f":"SUM(M165:N166)","v":0},null,{"$f":"SUM(O165:P166)","v":0},null,{"$f":"SUM(Q165:R166)","v":0},null,{"$f":"SUM(S165:T166)","v":0},null,{"$f":"SUM(U165:V166)","v":0},null,{"$f":"SUM(W165:X166)","v":0},null,{"$f":"SUM(Y165:Z166)","v":0},null,{"$f":"SUM(AA165:AB166)","v":0},null,{"$f":"SUM(AC165:AD166)","v":0},null,{"$f":"SUM(AE165:AF166)","v":0},null,0]
["Total Payment in This Off",null,null,null,null,null,{"$f":"IF(G160=\"This Off\",SUM(G107:H108,G115:H122),\"0\")","v":0},null,{"$f":"IF(I160=\"This Off\",SUM(I107:J108,I115:J122),\"0\")","v":0},null,{"$f":"IF(K160=\"This Off\",SUM(K107:L108,K115:L122),\"0\")","v":0},null,{"$f":"IF(M160=\"This Off\",SUM(M107:N108,M115:N122),\"0\")","v":0},null,{"$f":"IF(O160=\"This Off\",SUM(O107:P108,O115:P122),\"0\")","v":0},null,{"$f":"IF(Q160=\"This Off\",SUM(Q107:R108,Q115:R122),\"0\")","v":0},null,{"$f":"IF(S160=\"This Off\",SUM(S107:T108,S115:T122),\"0\")","v":0},null,{"$f":"IF(U160=\"This Off\",SUM(U107:V108,U115:V122),\"0\")","v":0},null,{"$f":"IF(W160=\"This Off\",SUM(W107:X108,W115:X122),\"0\")","v":0},null,{"$f":"IF(Y160=\"This Off\",SUM(Y107:Z108,Y115:Z122),\"0\")","v":0},null,{"$f":"IF(AA160=\"This Off\",SUM(AA107:AB108,AA115:AB122),\"0\")","v":0},null,{"$f":"IF(AC160=\"This Off\",SUM(AC107:AD108,AC115:AD122),\"0\")","v":0},null,{"$f":"IF(AE160=\"This Off\",SUM(AE107:AF108,AE115:AF122),\"0\")","v":0},null,0]
["HRA Exemption",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BQ94","v":0}]
["Nett",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG168,-AG169)","v":0}]
["Total TDS at This Off",null,null,null,null,null,{"$f":"IF(G160=\"This Off\",G164,\"0\")","v":0},null,0,null,{"$f":"IF(K160=\"This Off\",K164,\"0\")","v":0},null,{"$f":"IF(M160=\"This Off\",M164,\"0\")","v":0},null,{"$f":"IF(O160=\"This Off\",O164,\"0\")","v":0},null,{"$f":"IF(Q160=\"This Off\",Q164,\"0\")","v":0},null,{"$f":"IF(S160=\"This Off\",S164,\"0\")","v":0},null,{"$f":"IF(U160=\"This Off\",U164,\"0\")","v":0},null,{"$f":"IF(W160=\"This Off\",W164,\"0\")","v":0},null,{"$f":"IF(Y160=\"This Off\",Y164,\"0\")","v":0},null,{"$f":"IF(AA160=\"This Off\",AA164,\"0\")","v":0},null,{"$f":"IF(AC160=\"This Off\",AC164,\"0\")","v":0},null,{"$f":"IF(AE160=\"This Off\",AE164,\"0\")","v":0},null,{"$f":"SUM(G171:AF171)","v":0}]
["Total Payment in Other Off",null,null,null,null,null,{"$f":"IF(G160=\"Other Off\",SUM(G107:H108,G115:H122),\"0\")","v":"0"},null,{"$f":"IF(I160=\"Other Off\",SUM(I107:J108,I115:J122),\"0\")","v":"0"},null,{"$f":"IF(K160=\"Other Off\",SUM(K107:L108,K115:L122),\"0\")","v":"0"},null,{"$f":"IF(M160=\"Other Off\",SUM(M107:N108,M115:N122),\"0\")","v":"0"},null,{"$f":"IF(O160=\"Other Off\",SUM(O107:P108,O115:P122),\"0\")","v":"0"},null,{"$f":"IF(Q160=\"Other Off\",SUM(Q107:R108,Q115:R122),\"0\")","v":"0"},null,{"$f":"IF(S160=\"Other Off\",SUM(S107:T108,S115:T122),\"0\")","v":"0"},null,{"$f":"IF(U160=\"Other Off\",SUM(U107:V108,U115:V122),\"0\")","v":"0"},null,{"$f":"IF(W160=\"Other Off\",SUM(W107:X108,W115:X122),\"0\")","v":"0"},null,{"$f":"IF(Y160=\"Other Off\",SUM(Y107:Z108,Y115:Z122),\"0\")","v":"0"},null,{"$f":"IF(AA160=\"Other Off\",SUM(AA107:AB108,AA115:AB122),\"0\")","v":"0"},null,{"$f":"IF(AC160=\"Other Off\",SUM(AC107:AD108,AC115:AD122),\"0\")","v":"0"},null,{"$f":"IF(AE160=\"Other Off\",SUM(AE107:AF108,AE115:AF122),\"0\")","v":"0"},null,{"$f":"SUM(G172:AF172)","v":0}]
["Total TDS at Other Off",null,null,null,null,null,{"$f":"IF(G160=\"Other Off\",G164,\"0\")","v":"0"},null,{"$f":"IF(I160=\"Other Off\",I164,\"0\")","v":"0"},null,{"$f":"IF(K160=\"Other Off\",K164,\"0\")","v":"0"},null,{"$f":"IF(M160=\"Other Off\",M164,\"0\")","v":"0"},null,{"$f":"IF(O160=\"Other Off\",O164,\"0\")","v":"0"},null,{"$f":"IF(Q160=\"Other Off\",Q164,\"0\")","v":"0"},null,{"$f":"IF(S160=\"Other Off\",S164,\"0\")","v":"0"},null,{"$f":"IF(U160=\"Other Off\",U164,\"0\")","v":"0"},null,{"$f":"IF(W160=\"Other Off\",W164,\"0\")","v":"0"},null,{"$f":"IF(Y160=\"Other Off\",Y164,\"0\")","v":"0"},null,{"$f":"IF(AA160=\"Other Off\",AA164,\"0\")","v":"0"},null,{"$f":"IF(AC160=\"Other Off\",AC164,\"0\")","v":"0"},null,{"$f":"IF(AE160=\"Other Off\",AE164,\"0\")","v":"0"},null,{"$f":"SUM(G173:AF173)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"IT",null,"Cess",null,"IT",null,"Cess",null,"Total",null,"-U/s.89",null,"Bal."]
[null,null,null,null,null,null,"Total IT payable",null,null,null,null,null,null,null,null,null,{"$f":"BQ152","v":0},null,{"$f":"BQ153","v":0},null,{"$f":"SUM(Q176:T176)","v":0},null,{"$f":"BQ155","v":0},null,{"$f":"U176-W176","v":0}]
[null,null,null,null,null,null,"Less: Total TDS",null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG162,AG165)","v":0},null,{"$f":"SUM(AG163,AG166)","v":0},null,{"$f":"SUM(Q177:T177)","v":0},null,null,null,{"$f":"U177-W177","v":0}]
[null,null,null,null,null,null,"Balance I.T. payable",null,null,null,null,null,null,null,null,null,{"$f":"Q176-Q177","v":0},null,{"$f":"S176-S177","v":0},null,{"$f":"U176-U177","v":0},null,null,null,{"$f":"Y176-Y177","v":0}]

{"sheet":"Particulars-FORM 16 (2017-18)","index":1,"n_rows":53,"n_cols":42,"rows_kept":53,"cut":false,"hidden":false,"merged":[[50,1,50,7],[50,8,50,12],[50,13,50,15],[50,16,50,20],[51,1,51,7],[51,8,51,12],[51,13,51,15],[51,16,51,20],[52,1,52,7],[52,8,52,12],[52,13,52,15],[52,16,52,20],[47,1,47,7],[47,8,47,12],[47,13,47,15],[47,16,47,20],[48,1,48,7],[48,8,48,12],[48,13,48,15],[48,16,48,20],[49,1,49,7],[49,8,49,12],[49,13,49,15],[49,16,49,20],[44,1,44,7],[44,8,44,12],[44,13,44,15],[44,16,44,20],[45,1,45,7],[45,8,45,12],[45,13,45,15],[45,16,45,20],[46,1,46,7],[46,8,46,12],[46,13,46,15],[46,16,46,20],[41,43,41,47],[42,1,42,7],[42,8,42,12],[42,13,42,15],[42,16,42,20],[43,1,43,7],[43,8,43,12],[43,13,43,15],[43,16,43,20],[30,1,30,5],[30,6,30,14],[32,1,32,5],[32,6,32,14],[33,1,33,5],[33,6,33,14],[36,1,36,20],[36,22,36,41],[41,1,41,7],[41,8,41,12],[41,13,41,15],[41,16,41,20],[37,1,40,7],[37,22,40,28],[37,8,40,12],[37,13,40,15],[37,16,40,20],[37,29,40,33],[37,34,40,41],[25,1,25,14],[26,1,26,5],[26,6,26,14],[27,1,27,5],[27,6,27,14],[28,1,28,5],[28,6,28,14],[29,1,29,5],[29,6,29,14],[21,1,21,4],[21,5,21,17],[21,18,21,25],[21,26,21,34],[22,1,22,4],[22,5,22,17],[22,18,22,25],[22,26,22,34],[23,1,23,4],[23,5,23,17],[23,18,23,25],[23,26,23,34],[16,1,16,34],[19,1,19,4],[19,5,19,17],[19,18,19,25],[19,26,19,34],[20,1,20,4],[20,5,20,17],[20,18,20,25],[20,26,20,34],[17,1,18,4],[17,5,18,17],[17,18,18,25],[17,26,18,34],[13,1,13,3],[13,4,13,17],[13,26,13,30],[13,31,13,34],[14,1,14,3],[14,4,14,17],[14,26,14,30],[14,31,14,34],[15,1,15,3],[15,4,15,8],[15,9,15,11],[13,18,14,25],[9,1,9,17],[9,18,9,34],[10,1,10,8],[10,9,10,17],[10,18,10,34],[11,1,11,8],[11,9,11,17],[11,18,11,34],[12,1,12,17],[12,18,12,25],[12,26,12,34],[4,1,4,17],[4,18,4,34],[5,1,5,17],[5,18,5,34],[6,1,6,17],[6,18,6,34],[7,1,7,17],[7,18,7,34],[8,1,8,17],[8,18,8,34]]}
[]
[]
[]
[]
[null,"Name and address of the Employer"]
[null,"OFFICE OF THE PRINCIPAL CHIEF COMMISSIONER OF GST & CENTRAL EXCISE"]
[null,"CHENNAI ZONE"]
[null,"26/1 MAHATHMA GANDHI ROAD"]
[null,"NUNGAMBAKKAM"]
[null,"CHENNAI 600034"]
[null,"PAN of the Deductor",null,null,null,null,null,null,null,"TAN of the Deductor"]
[]
[null,"CIT (TDS)"]
[null,"Address",null,null,"26/1 MAHATHMA GANDHI ROAD"]
[null,null,null,null,"NUNGAMBAKKAM"]
[null,"City",null,null,"CHENNAI",null,null,null,null,"Pin Code",null,null,6,0,0,0,3,4]
[]
[null,"Quarter",null,null,null,"Receipt Numbers of original statements of TDS under sub-section (3) of section 200. (24Q)"]
[]
[null,"Quarter 1"]
[null,"Quarter 2"]
[null,"Quarter 3"]
[null,"Quarter 4"]
[]
[]
[null,"Details of person responsible for deduction of tax"]
[null,"Name"]
[null,"Sex (M/F)",null,null,null,null,"F"]
[null,"Father's Name"]
[null,"Designation",null,null,null,null,"ADMINISTRATIVE OFFICER (DDO)"]
[null,"PAN NO."]
[]
[null,"Place",null,null,null,null,"CHENNAI"]
[null,"Date"]
[]
[]
[null,"Book identification number (BIN)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Book identification number (BIN)"]
[null,"Receipt numbers of Form No.24G",null,null,null,null,null,null,"DDO serial number in Form No. 24G",null,null,null,null,"Month and Year",null,null,"Date of transfer voucher (dd/mm/yyyy)",null,null,null,null,null,"Receipt numbers of Form No.24G",null,null,null,null,null,null,"DDO serial number in Form No. 24G",null,null,null,null,"Date on which tax deposited (dd/mm/yyyy)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-04-01",null,null,{"$f":"DATE(YEAR(N42),MONTH(N42)+1,DAY(N42)-1)","v":"2018-04-30"},null,null,null,null,null,{"$f":"MID(B42,1,1)","v":""},{"$f":"MID(B42,2,1)","v":""},{"$f":"MID(B42,3,1)","v":""},{"$f":"MID(B42,4,1)","v":""},{"$f":"MID(B42,5,1)","v":""},{"$f":"MID(B42,6,1)","v":""},{"$f":"MID(B42,7,1)","v":""},{"$f":"MID(I42,1,1)","v":""},{"$f":"MID(I42,2,1)","v":""},{"$f":"MID(I42,3,1)","v":""},{"$f":"MID(I42,4,1)","v":""},{"$f":"MID(I42,5,1)","v":""},{"$f":"MID(TEXT(DATE(YEAR(N42),MONTH(N42)+1,DAY(N42)-1),\"ddmmyyyy\"),1,1)","v":"3"},{"$f":"MID(TEXT(DATE(YEAR(N42),MONTH(N42)+1,DAY(N42)-1),\"ddmmyyyy\"),2,1)","v":"0"},{"$f":"MID(TEXT(DATE(YEAR(N42),MONTH(N42)+1,DAY(N42)-1),\"ddmmyyyy\"),3,1)","v":"0"},{"$f":"MID(TEXT(DATE(YEAR(N42),MONTH(N42)+1,DAY(N42)-1),\"ddmmyyyy\"),4,1)","v":"4"},{"$f":"MID(TEXT(DATE(YEAR(N42),MONTH(N42)+1,DAY(N42)-1),\"ddmmyyyy\"),5,1)","v":"2"},{"$f":"MID(TEXT(DATE(YEAR(N42),MONTH(N42)+1,DAY(N42)-1),\"ddmmyyyy\"),6,1)","v":"0"},{"$f":"MID(TEXT(DATE(YEAR(N42),MONTH(N42)+1,DAY(N42)-1),\"ddmmyyyy\"),7,1)","v":"1"},{"$f":"MID(TEXT(DATE(YEAR(N42),MONTH(N42)+1,DAY(N42)-1),\"ddmmyyyy\"),8,1)","v":"8"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-05-02",null,null,{"$f":"DATE(YEAR(N43),MONTH(N43)+1,DAY(N43)-1)","v":"2018-06-01"},null,null,null,null,null,"","","","","","","","","","","","","0","1","0","6","2","0","1","8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-06-02",null,null,"2018-07-01",null,null,null,null,null,"","","","","","","","","","","","","0","1","0","7","2","0","1","8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-03",null,null,"2018-08-02",null,null,null,null,null,"","","","","","","","","","","","","0","2","0","8","2","0","1","8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-08-03",null,null,"2018-09-02",null,null,null,null,null,"","","","","","","","","","","","","0","2","0","9","2","0","1","8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-03",null,null,"2018-10-02",null,null,null,null,null,"","","","","","","","","","","","","0","2","1","0","2","0","1","8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-10-04",null,null,"2018-11-03",null,null,null,null,null,"","","","","","","","","","","","","0","3","1","1","2","0","1","8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-11-04",null,null,"2018-12-03",null,null,null,null,null,"","","","","","","","","","","","","0","3","1","2","2","0","1","8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-12-05",null,null,"2019-01-04",null,null,null,null,null,"","","","","","","","","","","","","0","4","0","1","2","0","1","9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-05",null,null,"2019-02-04",null,null,null,null,null,"","","","","","","","","","","","","0","4","0","2","2","0","1","9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-05",null,null,"2019-03-04",null,null,null,null,null,"","","","","","","","","","","","","0","4","0","3","2","0","1","9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-08",null,null,"2019-04-07",null,null,null,null,null,"","","","","","","","","","","","","0","7","0","4","2","0","1","9"]

{"sheet":"IT-FORM 16 (2017-18)","index":2,"n_rows":172,"n_cols":74,"rows_kept":172,"cut":false,"hidden":false,"merged":[[142,40,145,75],[146,55,148,75],[156,16,158,36],[152,1,155,36],[162,2,163,36],[166,2,167,36],[168,2,170,36],[164,2,164,36],[165,2,165,36],[158,1,158,6],[158,7,158,15],[159,1,159,6],[159,7,159,15],[159,16,159,36],[160,1,160,6],[160,7,160,15],[160,16,160,20],[160,21,160,36],[149,55,149,75],[150,1,150,2],[150,3,150,4],[150,5,150,10],[150,40,150,45],[150,46,150,54],[171,2,171,35],[137,38,141,38],[137,39,141,39],[100,20,101,27],[104,1,105,6],[104,7,105,19],[104,20,105,27],[104,28,105,36],[113,1,117,2],[113,3,117,4],[113,5,117,10],[114,11,117,17],[114,18,117,22],[114,23,117,30],[114,31,117,36],[133,1,137,2],[133,3,137,4],[133,5,137,10],[134,11,137,17],[134,18,137,25],[134,26,137,30],[134,31,137,36],[156,1,156,6],[157,1,157,6],[150,55,150,59],[150,60,150,75],[151,1,151,36],[149,1,149,2],[149,3,149,4],[149,5,149,10],[149,11,149,17],[149,18,149,25],[149,26,149,30],[149,31,149,36],[149,40,149,45],[149,46,149,54],[148,1,148,2],[148,3,148,4],[148,5,148,10],[148,11,148,17],[148,18,148,25],[148,26,148,30],[148,31,148,36],[148,40,148,45],[148,46,148,54],[146,1,146,2],[146,3,146,4],[146,5,146,10],[146,11,146,17],[146,18,146,25],[146,26,146,30],[146,31,146,36],[146,40,146,45],[147,1,147,2],[147,3,147,4],[147,5,147,10],[147,11,147,17],[147,18,147,25],[147,26,147,30],[147,31,147,36],[147,40,147,45],[144,1,144,2],[144,3,144,4],[144,5,144,10],[144,11,144,17],[144,18,144,25],[144,26,144,30],[144,31,144,36],[145,1,145,2],[145,3,145,4],[145,5,145,10],[145,11,145,17],[145,18,145,25],[145,26,145,30],[145,31,145,36],[142,1,142,2],[142,3,142,4],[142,5,142,10],[142,11,142,17],[142,18,142,25],[142,26,142,30],[142,31,142,36],[143,1,143,2],[143,3,143,4],[143,5,143,10],[143,11,143,17],[143,18,143,25],[143,26,143,30],[143,31,143,36],[140,70,140,71],[140,73,140,75],[141,1,141,2],[141,3,141,4],[141,5,141,10],[141,11,141,17],[141,18,141,25],[141,26,141,30],[141,31,141,36],[141,40,141,75],[140,1,140,2],[140,3,140,4],[140,5,140,10],[140,11,140,17],[140,18,140,25],[140,26,140,30],[140,31,140,36],[140,41,140,65],[140,67,140,68],[138,70,138,71],[138,73,138,75],[139,1,139,2],[139,3,139,4],[139,5,139,10],[139,11,139,17],[139,18,139,25],[139,26,139,30],[139,31,139,36],[139,41,139,65],[139,67,139,68],[139,70,139,71],[139,73,139,75],[138,1,138,2],[138,3,138,4],[138,5,138,10],[138,11,138,17],[138,18,138,25],[138,26,138,30],[138,31,138,36],[138,41,138,65],[138,67,138,68],[135,41,135,65],[135,67,135,68],[135,70,135,71],[135,73,135,75],[136,41,136,65],[136,67,136,68],[136,70,136,71],[136,73,136,75],[137,41,137,65],[137,67,137,68],[137,70,137,71],[137,73,137,75],[133,11,133,36],[133,41,133,65],[133,67,133,68],[133,70,133,71],[133,73,133,75],[134,41,134,65],[134,67,134,68],[134,70,134,71],[134,73,134,75],[131,1,131,36],[131,45,131,47],[131,48,131,62],[131,64,131,65],[131,67,131,68],[131,70,131,71],[131,73,131,75],[132,1,132,36],[132,41,132,65],[132,67,132,68],[132,70,132,71],[132,73,132,75],[129,64,129,65],[129,67,129,68],[129,70,129,71],[129,73,129,75],[130,1,130,2],[130,5,130,10],[130,45,130,47],[130,48,130,62],[130,67,130,68],[130,70,130,71],[129,1,129,2],[129,3,129,4],[129,5,129,10],[129,11,129,17],[129,18,129,22],[129,23,129,30],[129,31,129,36],[129,45,129,47],[129,48,129,62],[127,64,127,65],[127,67,127,68],[127,70,127,71],[127,73,127,75],[128,1,128,2],[128,3,128,4],[128,5,128,10],[128,11,128,17],[128,18,128,22],[128,23,128,30],[128,31,128,36],[128,45,128,47],[128,48,128,62],[128,64,128,65],[128,67,128,68],[128,70,128,71],[128,73,128,75],[127,1,127,2],[127,3,127,4],[127,5,127,10],[127,11,127,17],[127,18,127,22],[127,23,127,30],[127,31,127,36],[127,45,127,47],[127,48,127,62],[125,64,125,65],[125,67,125,68],[125,70,125,71],[125,73,125,75],[126,1,126,2],[126,3,126,4],[126,5,126,10],[126,11,126,17],[126,18,126,22],[126,23,126,30],[126,31,126,36],[126,45,126,47],[126,48,126,62],[126,64,126,65],[126,67,126,68],[126,70,126,71],[126,73,126,75],[125,1,125,2],[125,3,125,4],[125,5,125,10],[125,11,125,17],[125,18,125,22],[125,23,125,30],[125,31,125,36],[125,45,125,47],[125,48,125,62],[123,73,123,75],[124,1,124,2],[124,3,124,4],[124,5,124,10],[124,11,124,17],[124,18,124,22],[124,23,124,30],[124,31,124,36],[124,45,124,47],[124,48,124,62],[124,64,124,65],[124,67,124,68],[124,70,124,71],[124,73,124,75],[122,67,122,68],[122,70,122,71],[123,1,123,2],[123,3,123,4],[123,5,123,10],[123,11,123,17],[123,18,123,22],[123,23,123,30],[123,31,123,36],[123,45,123,47],[123,48,123,62],[123,64,123,65],[123,67,123,68],[123,70,123,71],[122,1,122,2],[122,3,122,4],[122,5,122,10],[122,11,122,17],[122,18,122,22],[122,23,122,30],[122,31,122,36],[122,45,122,47],[122,48,122,62],[120,73,120,75],[121,1,121,2],[121,3,121,4],[121,5,121,10],[121,11,121,17],[121,18,121,22],[121,23,121,30],[121,31,121,36],[121,45,121,47],[121,48,121,62],[121,64,121,65],[121,67,121,68],[121,70,121,71],[121,73,121,75],[119,67,119,68],[119,70,119,71],[120,1,120,2],[120,3,120,4],[120,5,120,10],[120,11,120,17],[120,18,120,22],[120,23,120,30],[120,31,120,36],[120,44,120,65],[120,67,120,68],[120,70,120,71],[119,1,119,2],[119,3,119,4],[119,5,119,10],[119,11,119,17],[119,18,119,22],[119,23,119,30],[119,31,119,36],[119,45,119,47],[119,48,119,65],[117,45,117,47],[117,48,117,65],[117,67,117,68],[117,70,117,71],[117,73,117,75],[118,1,118,2],[118,3,118,4],[118,5,118,10],[118,11,118,17],[118,18,118,22],[118,23,118,30],[118,31,118,36],[118,45,118,47],[118,48,118,65],[118,67,118,68],[118,70,118,71],[118,73,118,75],[115,46,115,62],[115,64,115,65],[115,67,115,68],[115,70,115,71],[115,73,115,75],[116,46,116,62],[116,64,116,65],[116,67,116,68],[116,70,116,71],[116,73,116,75],[113,11,113,36],[113,46,113,62],[113,64,113,65],[113,67,113,68],[113,70,113,71],[113,73,113,75],[114,46,114,62],[114,64,114,65],[114,67,114,68],[114,70,114,71],[114,73,114,75],[111,1,111,36],[111,46,111,62],[111,64,111,65],[111,67,111,68],[111,70,111,71],[111,73,111,75],[112,1,112,36],[112,46,112,62],[112,64,112,65],[112,67,112,68],[112,70,112,71],[112,73,112,75],[109,1,109,6],[109,7,109,19],[109,20,109,27],[109,28,109,36],[109,44,109,65],[109,73,109,75],[110,1,110,6],[110,7,110,19],[110,20,110,27],[110,28,110,36],[110,45,110,65],[110,67,110,68],[110,70,110,71],[110,73,110,75],[108,66,109,68],[108,69,109,71],[107,1,107,6],[107,7,107,19],[107,20,107,27],[107,28,107,36],[107,41,107,65],[107,67,107,68],[107,70,107,71],[107,73,107,75],[108,1,108,6],[108,7,108,19],[108,20,108,27],[108,28,108,36],[108,41,108,65],[108,73,108,75],[104,41,104,65],[104,67,104,68],[104,70,104,71],[104,73,104,75],[105,45,105,62],[105,64,105,65],[105,73,105,75],[106,1,106,6],[106,7,106,19],[106,20,106,27],[106,28,106,36],[106,45,106,62],[106,64,106,65],[106,73,106,75],[102,1,102,5],[102,6,102,10],[102,11,102,13],[102,41,102,65],[102,67,102,68],[102,70,102,71],[102,73,102,75],[103,1,103,36],[103,41,103,65],[103,67,103,68],[103,70,103,71],[103,73,103,75],[101,1,101,5],[101,6,101,19],[101,28,101,32],[101,33,101,36],[101,44,101,62],[101,64,101,65],[101,67,101,68],[101,70,101,71],[101,73,101,75],[99,1,99,19],[99,20,99,27],[99,28,99,36],[99,41,99,65],[99,67,99,68],[99,70,99,71],[99,73,99,75],[100,1,100,5],[100,6,100,19],[100,28,100,32],[100,33,100,36],[100,44,100,62],[100,64,100,65],[100,67,100,68],[100,70,100,71],[100,73,100,75],[97,1,97,10],[97,11,97,19],[97,20,97,36],[97,41,97,65],[97,67,97,68],[97,70,97,71],[97,73,97,75],[98,1,98,10],[98,11,98,19],[98,20,98,36],[98,41,98,65],[98,67,98,68],[98,70,98,71],[98,73,98,75],[95,1,95,19],[95,20,95,36],[95,44,95,65],[95,67,95,68],[95,70,95,71],[95,73,95,75],[96,1,96,19],[96,20,96,36],[96,44,96,65],[96,67,96,68],[96,70,96,71],[96,73,96,75],[93,1,93,19],[93,20,93,36],[93,44,93,65],[93,67,93,68],[93,70,93,71],[93,73,93,75],[94,1,94,19],[94,20,94,36],[94,44,94,65],[94,67,94,68],[94,70,94,71],[94,73,94,75],[91,1,91,19],[91,20,91,36],[91,40,91,75],[92,1,92,19],[92,20,92,36],[92,41,92,65],[92,67,92,68],[92,70,92,71],[92,73,92,75],[88,1,88,36],[88,40,88,44],[88,45,88,56],[88,65,88,66],[88,67,88,68],[88,69,88,70],[88,71,88,72],[89,1,89,36],[90,1,90,19],[90,20,90,36],[90,40,90,75],[86,1,86,36],[86,40,86,75],[87,1,87,36],[87,40,87,44],[87,45,87,56],[87,57,87,58],[87,59,87,64],[87,65,87,66],[87,67,87,68],[87,69,87,70],[87,71,87,72]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FORM NO.16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORM NO.16"]
[null,"[See rule 31(1)(a)]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name",null,null,null,null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!D88=\"\",'IT-WS-(2017-18) (8.5X13)'!D88=0),\"\",UPPER('IT-WS-(2017-18) (8.5X13)'!D88))","v":""},null,null,null,null,null,null,null,null,null,null,null,"PAN",null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!D89=\"\",'IT-WS-(2017-18) (8.5X13)'!D89=0),\"\",'IT-WS-(2017-18) (8.5X13)'!D89)","v":""},null,null,null,null,null,"F.Y.",null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!AD88=\"\",'IT-WS-(2017-18) (8.5X13)'!AD88=0),\"\",'IT-WS-(2017-18) (8.5X13)'!AD88)","v":2018},null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!AF88=\"\",'IT-WS-(2017-18) (8.5X13)'!AF88=0),\"\",'IT-WS-(2017-18) (8.5X13)'!AF88)","v":"-"},null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!AH88=\"\",'IT-WS-(2017-18) (8.5X13)'!AH88=0),\"\",'IT-WS-(2017-18) (8.5X13)'!AH88)","v":2019}]
[null,"PART A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Desgn",null,null,null,null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!D90=\"\",'IT-WS-(2017-18) (8.5X13)'!D90=0),\"\",UPPER('IT-WS-(2017-18) (8.5X13)'!D90))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A.Y.",null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!AD89=\"\",'IT-WS-(2017-18) (8.5X13)'!AD89=0),\"\",'IT-WS-(2017-18) (8.5X13)'!AD89)","v":2019},null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!AF89=\"\",'IT-WS-(2017-18) (8.5X13)'!AF89=0),\"\",'IT-WS-(2017-18) (8.5X13)'!AF89)","v":"-"},null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!AH89=\"\",'IT-WS-(2017-18) (8.5X13)'!AH89=0),\"\",'IT-WS-(2017-18) (8.5X13)'!AH89)","v":2020}]
[null,"Certificate under section 203 of the Income-tax Act, 1961 for Tax deducted at source on Salary"]
[null,"Cetificate No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last updated on",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PART B (Annexure)"]
[null,"Name and address of the Employer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name and Designation of the Employee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Details of Salary paid and any other income and tax deducted"]
[null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$B$6=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$6)","v":"OFFICE OF THE PRINCIPAL CHIEF COMMISSIONER OF GST & CENTRAL EXCISE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!S90=\"\",'IT-WS-(2017-18) (8.5X13)'!S90=0),\"\",'IT-WS-(2017-18) (8.5X13)'!S90)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Gross Salary (Vide Work Sheet enclosed)"]
[null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$B$7=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$7)","v":"CHENNAI ZONE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!D88=\"\",'IT-WS-(2017-18) (8.5X13)'!D88=0),\"\",UPPER('IT-WS-(2017-18) (8.5X13)'!D88))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(a)",null,null,"Salary as per provisions contained in Sec. 17(1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ93=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ93=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ93)","v":""}]
[null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$B$8=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$8)","v":"26/1 MAHATHMA GANDHI ROAD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!D90=\"\",'IT-WS-(2017-18) (8.5X13)'!D90=0),\"\",UPPER('IT-WS-(2017-18) (8.5X13)'!D90))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(b)",null,null,"Value of perquisites u/s 17(2) (as per Form No.12BB, wherever applicable)"]
[null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$B$9=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$9)","v":"NUNGAMBAKKAM"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(c)",null,null,"Profits in lieu of salary under section 17(3) (as per Form No.12BB, wherever applicable)"]
[null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$B$10=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$10)","v":"CHENNAI 600034"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(d)",null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(SUM(BP94:BQ96)=0,\"\",SUM(BP94:BQ96))","v":""}]
[null,"PAN of the Deductor",null,null,null,null,null,null,null,null,null,"TAN of the Deductor",null,null,null,null,null,null,null,null,"PAN of the Employee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Less: Allowance to the extent exempt u/s.10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ101=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ101=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ101)","v":40000}]
[null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$B$12=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$12)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$J$12=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$J$12)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!D89=\"\",'IT-WS-(2017-18) (8.5X13)'!D89=0),\"\",'IT-WS-(2017-18) (8.5X13)'!D89)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Balance (1 - 2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ102=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ102=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ102)","v":-40000},null,null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ102=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ102=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ102)","v":-40000}]
[null,"CIT (TDS)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assessment Year",null,null,null,null,null,null,null,"Period",null,null,null,null,null,null,null,null,null,null,null,4,"Deductions:"]
[null,"Address",null,null,null,null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$E$14=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$E$14)","v":"26/1 MAHATHMA GANDHI ROAD"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(OR('IT-WS-(2017-18) (8.5X13)'!AD89=\"\",'IT-WS-(2017-18) (8.5X13)'!AD89=0),\"____\",'IT-WS-(2017-18) (8.5X13)'!AD89),IF(OR('IT-WS-(2017-18) (8.5X13)'!AF89=\"\",'IT-WS-(2017-18) (8.5X13)'!AF89=0),\"_\",'IT-WS-(2017-18) (8.5X13)'!AF89),IF(OR('IT-WS-(2017-18) (8.5X13)'!AH89=\"\",'IT-WS-(2017-18) (8.5X13)'!AH89=0),\"____\",'IT-WS-(2017-18) (8.5X13)'!AH89))","v":"2019-2020"},null,null,null,null,null,null,null,"From",null,null,null,null,"To",null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM104=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM104)","v":"(a)"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN104=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN104)","v":"Entertainment Allowance"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BH104=\"\",'IT-WS-(2017-18) (8.5X13)'!BH104=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BH104)","v":""}]
[null,null,null,null,null,null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$E$15=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$E$15)","v":"NUNGAMBAKKAM"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!I94=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!I94)","v":"2018-04-01"},null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AE93=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AE93)","v":"2019-03-01"},null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM105=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM105)","v":"(b)"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN105=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN105)","v":"Tax on Employment"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BH105=\"\",'IT-WS-(2017-18) (8.5X13)'!BH105=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BH105)","v":""}]
[null,"City",null,null,null,null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$E$16=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$E$16)","v":"CHENNAI"},null,null,null,null,"Pin Code",null,null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$M$16=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$M$16)","v":6},{"$f":"IF('Particulars-FORM 16 (2017-18)'!$N$16=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$N$16)","v":0},{"$f":"IF('Particulars-FORM 16 (2017-18)'!$O$16=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$O$16)","v":0},{"$f":"IF('Particulars-FORM 16 (2017-18)'!$P$16=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$P$16)","v":0},{"$f":"IF('Particulars-FORM 16 (2017-18)'!$Q$16=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$Q$16)","v":3},{"$f":"IF('Particulars-FORM 16 (2017-18)'!$R$16=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$R$16)","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM106=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM106)","v":"Aggregate of 4 (a) and (b)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ106=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ106=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ106)","v":""}]
[null,"Summary of tax deducted at source",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM107=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM107)","v":"Income chargeable under the head \"Salaries\" (3 - 5)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ107=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ107=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ107)","v":-40000}]
[null,"Quarter",null,null,null,null,null,"Receipt Numbers of original statements of TDS under sub-section (3) of section 200.",null,null,null,null,null,null,null,null,null,null,null,null,"Amount of tax deducted in respect of the employee",null,null,null,null,null,null,null,"Amount of tax deposited/remitted in respect of the employee",null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM108=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM108)","v":"Add: Any other income"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ108=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ108=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ108)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN109=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN109)","v":1},{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!AO109=\"\",'IT-WS-(2017-18) (8.5X13)'!AO109=0),\"\",'IT-WS-(2017-18) (8.5X13)'!AO109)","v":"Inc. from House Property"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BH109=\"\",'IT-WS-(2017-18) (8.5X13)'!BH109=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BH109)","v":""}]
[null,"Quarter 1",null,null,null,null,null,{"$f":"IF(U107=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$F$20=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$F$20))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F119:K121)=0,\"\",SUM(F119:K121))","v":""},null,null,null,null,null,null,null,{"$f":"IF(SUM(F119:K121)=0,\"\",SUM(F119:K121))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN110=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN110)","v":2},{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!AO110=\"\",'IT-WS-(2017-18) (8.5X13)'!AO110=0),\"\",'IT-WS-(2017-18) (8.5X13)'!AO110)","v":"Interest on Housing Loan"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BH110=\"\",'IT-WS-(2017-18) (8.5X13)'!BH110=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BH110)","v":""}]
[null,"Quarter 2",null,null,null,null,null,{"$f":"IF(U108=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$F$21=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$F$21))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F122:K124)=0,\"\",SUM(F122:K124))","v":""},null,null,null,null,null,null,null,{"$f":"IF(SUM(F122:K124)=0,\"\",SUM(F122:K124))","v":""},null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM111=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM111)","v":"GROSS TOTAL INCOME (6 + 7)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ111=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ111=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ111)","v":-40000}]
[null,"Quarter 3",null,null,null,null,null,{"$f":"IF(U109=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$F$22=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$F$22))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F125:K127)=0,\"\",SUM(F125:K127))","v":""},null,null,null,null,null,null,null,{"$f":"IF(SUM(F125:K127)=0,\"\",SUM(F125:K127))","v":""},null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM112=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM112)","v":"DEDUCTIONS UNDER CHAPTER VI-A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross Amount",null,null,"Deductible Amount"]
[null,"Quarter 4",null,null,null,null,null,{"$f":"IF(U110=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$F$23=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$F$23))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F128:K130)=0,\"\",SUM(F128:K130))","v":""},null,null,null,null,null,null,null,{"$f":"IF(SUM(F128:K130)=0,\"\",SUM(F128:K130))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM113=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM113)","v":"(A)"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN113=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN113)","v":"Sections 80C, 80CCC and 80CCD"}]
[null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(U107:AB110)=0,\"\",SUM(U107:AB110))","v":""},null,null,null,null,null,null,null,{"$f":"IF(SUM(AC107:AK110)=0,\"\",SUM(AC107:AK110))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN114=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN114)","v":"(a)"},{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO114=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO114)","v":"Section 80C"}]
[null,"I. DETAILS OF TAX DEDUCTED AND DEPOSITED IN THE CENTRAL GOVERNMENT ACCOUNT THROUGH BOOK ADJUSTMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO115=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO115)","v":"(i)"},{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!AP115=\"\",'IT-WS-(2017-18) (8.5X13)'!AP115=0),\"\",'IT-WS-(2017-18) (8.5X13)'!AP115)","v":"GPF Contribution"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BH115=\"\",'IT-WS-(2017-18) (8.5X13)'!BH115=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BH115)","v":""}]
[null,"(The deductor to provide payment wise details of tax deducted and deposited with respect to the deductee)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO116=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO116)","v":"(ii)"},{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!AP116=\"\",'IT-WS-(2017-18) (8.5X13)'!AP116=0),\"\",'IT-WS-(2017-18) (8.5X13)'!AP116)","v":"CGEGIS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BH116=\"\",'IT-WS-(2017-18) (8.5X13)'!BH116=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BH116)","v":""}]
[null,"S. No.",null,"S. No.",null,"Tax Deposited in respect of the deductee\n(Rs.)",null,null,null,null,null,"Book Identification Number (BIN)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO117=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO117)","v":"(iii)"},{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!AP117=\"\",'IT-WS-(2017-18) (8.5X13)'!AP117=0),\"\",'IT-WS-(2017-18) (8.5X13)'!AP117)","v":"HBA Repayment"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BH117=\"\",'IT-WS-(2017-18) (8.5X13)'!BH117=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BH117)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Receipt numbers of Form No. 24G",null,null,null,null,null,null,"DDO serial number in Form No. 24G",null,null,null,null,"Date of transfer voucher (dd/mm/yyyy)",null,null,null,null,null,null,null,"Status of matching with Form No.24G",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO118=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO118)","v":"(iv)"},{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!AP118=\"\",'IT-WS-(2017-18) (8.5X13)'!AP118=0),\"\",'IT-WS-(2017-18) (8.5X13)'!AP118)","v":"PLI/LIC/MF"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BH118=\"\",'IT-WS-(2017-18) (8.5X13)'!BH118=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BH118)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO119=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO119)","v":"(v)"},{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!AP119=\"\",'IT-WS-(2017-18) (8.5X13)'!AP119=0),\"\",'IT-WS-(2017-18) (8.5X13)'!AP119)","v":"Tuition Fees paid"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BH119=\"\",'IT-WS-(2017-18) (8.5X13)'!BH119=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BH119)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO120=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO120)","v":"(vi)"},{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!AP120=\"\",'IT-WS-(2017-18) (8.5X13)'!AP120=0),\"\",'IT-WS-(2017-18) (8.5X13)'!AP120)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BH120=\"\",'IT-WS-(2017-18) (8.5X13)'!BH120=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BH120)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BK120=\"\",'IT-WS-(2017-18) (8.5X13)'!BK120=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BK120)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BN120=\"\",'IT-WS-(2017-18) (8.5X13)'!BN120=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BN120)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN121=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN121)","v":"(b)"},{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO121=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO121)","v":"Sec.80-CCD (1)"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AR121=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AR121)","v":"New Pension Scheme (Contribution by the assessee)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BK121=\"\",'IT-WS-(2017-18) (8.5X13)'!BK121=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BK121)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BN121=\"\",'IT-WS-(2017-18) (8.5X13)'!BN121=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BN121)","v":""}]
[null,{"$f":"IF(F119=\"\",\"\",D119)","v":1},null,{"$f":"IF(F119=\"\",D118,D118+1)","v":1},null,{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!G160=\"This Off\",'IT-WS-(2017-18) (8.5X13)'!I160=\"This Off\"),IF(AND('IT-WS-(2017-18) (8.5X13)'!G164=0,'IT-WS-(2017-18) (8.5X13)'!I164=0),\" \",('IT-WS-(2017-18) (8.5X13)'!G164+'IT-WS-(2017-18) (8.5X13)'!I164)))","v":" "},null,null,null,null,null,{"$f":"IF(F119=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$B$42=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$42))","v":""},null,null,null,null,null,null,{"$f":"IF(F119=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$I$42=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$I$42))","v":""},null,null,null,null,{"$f":"IF(F119=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$Q$42=\"\",\"\",TEXT('Particulars-FORM 16 (2017-18)'!$Q$42,\"dd/mm/yyyy\")))","v":"30/04/2018"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,1,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO122=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO122)","v":"Sec.80-CCE"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AR122=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AR122)","v":"Total u/s.80-C, 80-CCC, 80-CCD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BK122=\"\",'IT-WS-(2017-18) (8.5X13)'!BK122=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BK122)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BN122=\"\",'IT-WS-(2017-18) (8.5X13)'!BN122=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BN122)","v":""}]
[null,{"$f":"IF(F120=\"\",\"\",D120)","v":2},null,{"$f":"IF(F120=\"\",D119,D119+1)","v":2},null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!K$160=\"This Off\",IF('IT-WS-(2017-18) (8.5X13)'!K$164=0,\" \",'IT-WS-(2017-18) (8.5X13)'!K$164))","v":" "},null,null,null,null,null,{"$f":"IF(F120=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$B$43=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$43))","v":""},null,null,null,null,null,null,{"$f":"IF(F120=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$I$43=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$I$43))","v":""},null,null,null,null,{"$f":"IF(F120=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$Q$43=\"\",\"\",TEXT('Particulars-FORM 16 (2017-18)'!$Q$43,\"dd/mm/yyyy\")))","v":"01/06/2018"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,1,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO123=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO123)","v":"Sec.80-CCD (2)"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AR123=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AR123)","v":"New Pension Scheme (Government's contribution)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BK123=\"\",'IT-WS-(2017-18) (8.5X13)'!BK123=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BK123)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BN123=\"\",'IT-WS-(2017-18) (8.5X13)'!BN123=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BN123)","v":""}]
[null,3,null,3,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!M$160=\"This Off\",IF('IT-WS-(2017-18) (8.5X13)'!M$164=0,\" \",'IT-WS-(2017-18) (8.5X13)'!M$164))","v":" "},null,null,null,null,null,{"$f":"IF(F121=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$B$44=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$44))","v":""},null,null,null,null,null,null,{"$f":"IF(F121=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$I$44=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$I$44))","v":""},null,null,null,null,{"$f":"IF(F121=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$Q$44=\"\",\"\",TEXT('Particulars-FORM 16 (2017-18)'!$Q$44,\"dd/mm/yyyy\")))","v":"01/07/2018"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,1,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM124=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM124)","v":"(B)"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN124=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN124)","v":"OTHER SECTIONS"}]
[null,4,null,4,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!O$160=\"This Off\",IF('IT-WS-(2017-18) (8.5X13)'!O$164=0,\" \",'IT-WS-(2017-18) (8.5X13)'!O$164))","v":" "},null,null,null,null,null,{"$f":"IF(F122=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$B$45=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$45))","v":""},null,null,null,null,null,null,{"$f":"IF(F122=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$I$45=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$I$45))","v":""},null,null,null,null,{"$f":"IF(F122=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$Q$45=\"\",\"\",TEXT('Particulars-FORM 16 (2017-18)'!$Q$45,\"dd/mm/yyyy\")))","v":"02/08/2018"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,2,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN125=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN125)","v":"(a)"},{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO125=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO125)","v":"Sec.80CCD (1b)"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AR125=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AR125)","v":"Additional contribution under NPS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BK125=\"\",'IT-WS-(2017-18) (8.5X13)'!BK125=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BK125)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BN125=\"\",'IT-WS-(2017-18) (8.5X13)'!BN125=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BN125)","v":""}]
[null,5,null,5,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!Q$160=\"This Off\",IF('IT-WS-(2017-18) (8.5X13)'!Q$164=0,\" \",'IT-WS-(2017-18) (8.5X13)'!Q$164))","v":" "},null,null,null,null,null,{"$f":"IF(F123=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$B$46=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$46))","v":""},null,null,null,null,null,null,{"$f":"IF(F123=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$I$46=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$I$46))","v":""},null,null,null,null,{"$f":"IF(F123=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$Q$46=\"\",\"\",TEXT('Particulars-FORM 16 (2017-18)'!$Q$46,\"dd/mm/yyyy\")))","v":"02/09/2018"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN126=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN126)","v":"(b)"},{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO126=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO126)","v":"Sec.80-CCG"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AR126=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AR126)","v":"RGESS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BK126=\"\",'IT-WS-(2017-18) (8.5X13)'!BK126=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BK126)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BN126=\"\",'IT-WS-(2017-18) (8.5X13)'!BN126=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BN126)","v":""}]
[null,6,null,6,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!S$160=\"This Off\",IF('IT-WS-(2017-18) (8.5X13)'!S$164=0,\" \",'IT-WS-(2017-18) (8.5X13)'!S$164))","v":" "},null,null,null,null,null,{"$f":"IF(F124=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$B$47=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$47))","v":""},null,null,null,null,null,null,{"$f":"IF(F124=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$I$47=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$I$47))","v":""},null,null,null,null,{"$f":"IF(F124=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$Q$47=\"\",\"\",TEXT('Particulars-FORM 16 (2017-18)'!$Q$47,\"dd/mm/yyyy\")))","v":"02/10/2018"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,2,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN127=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN127)","v":"(c)"},{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO127=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO127)","v":"Sec.80-D"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AR127=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AR127)","v":"Medical Insr. Prem"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BH127=\"\",'IT-WS-(2017-18) (8.5X13)'!BH127=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BH127)","v":""}]
[null,7,null,7,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!U$160=\"This Off\",IF('IT-WS-(2017-18) (8.5X13)'!U$164=0,\" \",'IT-WS-(2017-18) (8.5X13)'!U$164))","v":" "},null,null,null,null,null,{"$f":"IF(F125=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$B$48=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$48))","v":""},null,null,null,null,null,null,{"$f":"IF(F125=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$I$48=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$I$48))","v":""},null,null,null,null,{"$f":"IF(F125=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$Q$48=\"\",\"\",TEXT('Particulars-FORM 16 (2017-18)'!$Q$48,\"dd/mm/yyyy\")))","v":"03/11/2018"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,2,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AR128=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AR128)","v":"CGHS Contribution"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BH128=\"\",'IT-WS-(2017-18) (8.5X13)'!BH128=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BH128)","v":""}]
[null,8,null,8,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!W$160=\"This Off\",IF('IT-WS-(2017-18) (8.5X13)'!W$164=0,\" \",'IT-WS-(2017-18) (8.5X13)'!W$164))","v":" "},null,null,null,null,null,{"$f":"IF(F126=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$B$49=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$49))","v":""},null,null,null,null,null,null,{"$f":"IF(F126=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$I$49=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$I$49))","v":""},null,null,null,null,{"$f":"IF(F126=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$Q$49=\"\",\"\",TEXT('Particulars-FORM 16 (2017-18)'!$Q$49,\"dd/mm/yyyy\")))","v":"03/12/2018"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,3,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AR129=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AR129)","v":"Total of Sec.80-D"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BH129=\"\",'IT-WS-(2017-18) (8.5X13)'!BH129=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BH129)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BK129=\"\",'IT-WS-(2017-18) (8.5X13)'!BK129=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BK129)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BN129=\"\",'IT-WS-(2017-18) (8.5X13)'!BN129=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BN129)","v":""}]
[null,9,null,9,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!Y$160=\"This Off\",IF('IT-WS-(2017-18) (8.5X13)'!Y$164=0,\" \",'IT-WS-(2017-18) (8.5X13)'!Y$164))","v":" "},null,null,null,null,null,{"$f":"IF(F127=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$B$50=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$50))","v":""},null,null,null,null,null,null,{"$f":"IF(F127=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$I$50=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$I$50))","v":""},null,null,null,null,{"$f":"IF(F127=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$Q$50=\"\",\"\",TEXT('Particulars-FORM 16 (2017-18)'!$Q$50,\"dd/mm/yyyy\")))","v":"04/01/2019"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,3,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN130=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN130)","v":"(d)"},{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO130=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO130)","v":"Sec.80-DD"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AR130=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AR130)","v":"Handicapped dependant"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BK130=\"\",'IT-WS-(2017-18) (8.5X13)'!BK130=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BK130)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BN130=\"\",'IT-WS-(2017-18) (8.5X13)'!BN130=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BN130)","v":""}]
[null,10,null,10,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AA$160=\"This Off\",IF('IT-WS-(2017-18) (8.5X13)'!AA$164=0,\" \",'IT-WS-(2017-18) (8.5X13)'!AA$164))","v":" "},null,null,null,null,null,{"$f":"IF(F128=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$B$51=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$51))","v":""},null,null,null,null,null,null,{"$f":"IF(F128=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$I$51=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$I$51))","v":""},null,null,null,null,{"$f":"IF(F128=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$Q$51=\"\",\"\",TEXT('Particulars-FORM 16 (2017-18)'!$Q$51,\"dd/mm/yyyy\")))","v":"04/02/2019"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,3,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN131=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN131)","v":"(e)"},{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO131=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO131)","v":"Sec.80-DDB"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AR131=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AR131)","v":"Medical treatment"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BK131=\"\",'IT-WS-(2017-18) (8.5X13)'!BK131=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BK131)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BN131=\"\",'IT-WS-(2017-18) (8.5X13)'!BN131=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BN131)","v":""}]
[null,11,null,11,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AC$160=\"This Off\",IF('IT-WS-(2017-18) (8.5X13)'!AC$164=0,\" \",'IT-WS-(2017-18) (8.5X13)'!AC$164))","v":" "},null,null,null,null,null,{"$f":"IF(F129=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$B$52=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$52))","v":""},null,null,null,null,null,null,{"$f":"IF(F129=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$I$52=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$I$52))","v":""},null,null,null,null,{"$f":"IF(F129=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$Q$52=\"\",\"\",TEXT('Particulars-FORM 16 (2017-18)'!$Q$52,\"dd/mm/yyyy\")))","v":"04/03/2019"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,4,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN132=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN132)","v":"(f)"},{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO132=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO132)","v":"Sec.80-E"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AR132=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AR132)","v":"Education Loan (Int. only)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BK132=\"\",'IT-WS-(2017-18) (8.5X13)'!BK132=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BK132)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BN132=\"\",'IT-WS-(2017-18) (8.5X13)'!BN132=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BN132)","v":""}]
[null,12,null,12,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AE$160=\"This Off\",IF('IT-WS-(2017-18) (8.5X13)'!AE$164=0,\" \",'IT-WS-(2017-18) (8.5X13)'!AE$164))","v":" "},null,null,null,null,null,{"$f":"IF(F130=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$B$53=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$B$53))","v":""},null,null,null,null,null,null,{"$f":"IF(F130=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$I$53=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$I$53))","v":""},null,null,null,null,{"$f":"IF(F130=\"\",\"\",IF('Particulars-FORM 16 (2017-18)'!$Q$53=\"\",\"\",TEXT('Particulars-FORM 16 (2017-18)'!$Q$53,\"dd/mm/yyyy\")))","v":"07/04/2019"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,4,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN133=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN133)","v":"(g)"},{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO133=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO133)","v":"Sec.80-G"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AR133=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AR133)","v":"Donations"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BK133=\"\",'IT-WS-(2017-18) (8.5X13)'!BK133=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BK133)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BN133=\"\",'IT-WS-(2017-18) (8.5X13)'!BN133=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BN133)","v":""}]
[null,"Total",null,null,null,{"$f":"SUM(F119:K130)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN134=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN134)","v":"(h)"},{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO134=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO134)","v":"Sec.80-TTA"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AR134=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AR134)","v":"Int. on SB"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BK134=\"\",'IT-WS-(2017-18) (8.5X13)'!BK134=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BK134)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BN134=\"\",'IT-WS-(2017-18) (8.5X13)'!BN134=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BN134)","v":""}]
[null,"II. DETAILS OF TAX DEDUCTED AND DEPOSITED IN THE CENTRAL GOVERNMENT ACCOUNT THROUGH CHALLAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,4,null,null,null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AN135=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AN135)","v":"(g)"},{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AO135=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AO135)","v":"Sec.80-U"},null,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AR135=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AR135)","v":"Handicapped Assessee"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BK135=\"\",'IT-WS-(2017-18) (8.5X13)'!BK135=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BK135)","v":""},null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BN135=\"\",'IT-WS-(2017-18) (8.5X13)'!BN135=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BN135)","v":""}]
[null,"(The deductor to provide payment wise details of tax deducted and deposited with respect to the deductee)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM136=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM136)","v":"Aggregate of deductible amount under Ch.VI-A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ136=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ136=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ136)","v":""}]
[null,"S. No.",null,"S. No.",null,"Tax Deposited in respect of the deductee\n(Rs.)",null,null,null,null,null,"Challan Identification Number (CIN)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM137=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM137)","v":"TOTAL INCOME (8 - 10) (Rounded to nearest TEN Rupees)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ137=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ137=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ137)","v":-40000}]
[null,null,null,null,null,null,null,null,null,null,null,"BSR Code of the Bank Branch",null,null,null,null,null,null,"Date on which tax deposited (dd/mm/yyyy)",null,null,null,null,null,null,null,"Challan Serial Number",null,null,null,null,"Status of matching with OLTAS",null,null,null,null,null,null,null,null,12,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM138=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM138)","v":"TAX ON TOTAL INCOME"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ138=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ138=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ138)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM151=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM151)","v":"Sec. 87A - Tax Rebate"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ151=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ151=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ151)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM152=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM152)","v":"Tax on Total Income after Tax Rebate u/s. 87A (12 - 13)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ152=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ152=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ152)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Month","Quarter No.",15,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM153=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM153)","v":"Edn Cess + Health Cess @ "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ153=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ153=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ153)","v":""}]
[null,{"$f":"IF(F139=\"\",\"\",D139)","v":1},null,{"$f":"IF(F139=\"\",D138,D138+1)","v":1},null,{"$f":"IF(AND('IT-WS-(2017-18) (8.5X13)'!G167=0,'IT-WS-(2017-18) (8.5X13)'!I167=0),\" \",'IT-WS-(2017-18) (8.5X13)'!G167+'IT-WS-(2017-18) (8.5X13)'!I167)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM154=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM154)","v":"Tax payable (14 + 15)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ154=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ154=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ154)","v":""}]
[null,{"$f":"IF(F140=\"\",\"\",D140)","v":2},null,{"$f":"IF(F140=\"\",D139,D139+1)","v":2},null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!K$167=0,\" \",'IT-WS-(2017-18) (8.5X13)'!K$167)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM155=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM155)","v":"Relief under Section 89 (attach details)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ155=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ155=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ155)","v":""}]
[null,3,null,3,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!M$167=0,\" \",'IT-WS-(2017-18) (8.5X13)'!M$167)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AM156=\"\",\"\",'IT-WS-(2017-18) (8.5X13)'!AM156)","v":"Tax payable (16 - 17)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"IF(OR('IT-WS-(2017-18) (8.5X13)'!BQ156=\"\",'IT-WS-(2017-18) (8.5X13)'!BQ156=0),\"\",'IT-WS-(2017-18) (8.5X13)'!BQ156)","v":""}]
[null,4,null,4,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!O$167=0,\" \",'IT-WS-(2017-18) (8.5X13)'!O$167)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verification"]
[null,5,null,5,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!Q$167=0,\" \",'IT-WS-(2017-18) (8.5X13)'!Q$167)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,1,{"$f":"CONCATENATE(\"I, \",'Particulars-FORM 16 (2017-18)'!$G$27,\", \",'Particulars-FORM 16 (2017-18)'!$G$30,\", \",IF('Particulars-FORM 16 (2017-18)'!$G$28=\"F\",\"daughter of  \",\"son of  \"),'Particulars-FORM 16 (2017-18)'!$G$29,\", working in the capacity of \",'Particulars-FORM 16 (2017-18)'!$G$30,\" (designation) do hereby certify that the information given above is true, complete and correct and is based on the books of account, documents, TDS statements and other available records.\")","v":"I, , ADMINISTRATIVE OFFICER (DDO), daughter of  , working in the capacity of ADMINISTRATIVE OFFICER (DDO) (designation) do hereby certify that the information given above is true, complete and correct and is based on the books of account, documents, TDS statements and other available records."}]
[null,6,null,6,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!S$167=0,\" \",'IT-WS-(2017-18) (8.5X13)'!S$167)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,1]
[null,7,null,7,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!U$167=0,\" \",'IT-WS-(2017-18) (8.5X13)'!U$167)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,1]
[null,8,null,8,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!W$167=0,\" \",'IT-WS-(2017-18) (8.5X13)'!W$167)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,2]
[null,9,null,9,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!Y$167=0,\" \",'IT-WS-(2017-18) (8.5X13)'!Y$167)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,2]
[null,10,null,10,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AA$167=0,\" \",'IT-WS-(2017-18) (8.5X13)'!AA$167)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,2]
[null,11,null,11,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AC$167=0,\" \",'IT-WS-(2017-18) (8.5X13)'!AC$167)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,3,"Place",null,null,null,null,null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$G$33=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$G$33)","v":"CHENNAI"}]
[null,12,null,12,null,{"$f":"IF('IT-WS-(2017-18) (8.5X13)'!AE$167=0,\" \",'IT-WS-(2017-18) (8.5X13)'!AE$167)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,3,"Date",null,null,null,null,null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$G$34=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$G$34)","v":""},null,null,null,null,null,null,null,null,"Signature of person responsible for deduction of tax"]
[null,"Total",null,null,null,{"$f":"SUM(F139:K150)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,3,"Designation:",null,null,null,null,null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$G$30=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$G$30)","v":"ADMINISTRATIVE OFFICER (DDO)"},null,null,null,null,null,null,null,null,"Full Name:",null,null,null,null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$G$27=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$G$27)","v":""}]
[null,"Verification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,4]
[null,{"$f":"CONCATENATE(\"I, \",'Particulars-FORM 16 (2017-18)'!$G$27,\", \",'Particulars-FORM 16 (2017-18)'!$G$30,\", \",IF('Particulars-FORM 16 (2017-18)'!$G$28=\"F\",\"daughter of  \",\"son of  \"),'Particulars-FORM 16 (2017-18)'!$G$29,\", working in the capacity of \",'Particulars-FORM 16 (2017-18)'!$G$30,\" (designation) do hereby certify that a sum of   Rs.\",IF((F131+F151)=0,\"-NIL-\",(F131+F151)),\"/-  [\",IF((F131+F151)=0,\"-NIL-\",rstword((F131+F151))),\" (in words)] has been deducted and deposited to the credit of the Central Government.  \",\"I further certify that the information given above is true, complete and correct and is based on the books of account, documents, TDS statements, TDS deposited and other available records.\")","v":"I, , ADMINISTRATIVE OFFICER (DDO), daughter of  , working in the capacity of ADMINISTRATIVE OFFICER (DDO) (designation) do hereby certify that a sum of   Rs.-NIL-/-  [-NIL- (in words)] has been deducted and deposited to the credit of the Central Government.  I further certify that the information given above is true, complete and correct and is based on the books of account, documents, TDS statements, TDS deposited and other available records."}]
[]
[]
[]
[]
[]
[null,"Place",null,null,null,null,null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$G$33=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$G$33)","v":"CHENNAI"}]
[null,"Date",null,null,null,null,null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$G$34=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$G$34)","v":""},null,null,null,null,null,null,null,null,"Signature of person responsible for deduction of tax"]
[null,"Designation:",null,null,null,null,null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$G$30=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$G$30)","v":"ADMINISTRATIVE OFFICER (DDO)"},null,null,null,null,null,null,null,null,"Full Name:",null,null,null,null,{"$f":"IF('Particulars-FORM 16 (2017-18)'!$G$27=\"\",\"\",'Particulars-FORM 16 (2017-18)'!$G$27)","v":""}]
[null,"Notes:"]
[null,1,"Government deductors to fill information in item I if tax is paid without production of an income-tax challan and in item II if tax is paid accompanied by an income-tax challan."]
[]
[null,2,"Non-Government deductors to fill information in item II."]
[null,3,"The deductor shall furnish the address of the Commissioner of Income-tax (TDS) having jurisdiction as regards TDS statements of the assessee."]
[null,4,"If an assessee is employed under one employer only during the year, certificate in Form No. 16 issued for the quarter ending on 31st March of the financial year shall contain the details of tax deducted and deposited for all the quarters of the financial year."]
[]
[null,5,"If an assessee is employed under more than one employer during the year, each of the employers shall issue Part A of the certificate in Form No. 16 pertaining to the period for which such assessee was employed with each of the employers. Part B (Annexure) of the certificate in Form No.16 may be issued by each of the employers or the last employer at the option of the assessee."]
[]
[]
[null,6,"In items I and II, in column for tax deposited in respect of deductee, furnish total amount of TDS and education cess."]