{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":[" Form. de Abast. de Água"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":" Form. de Abast. de Água","index":0,"n_rows":233,"n_cols":22,"rows_kept":233,"cut":false,"hidden":false,"merged":[[193,8,193,9],[189,6,189,7],[182,13,182,14],[183,3,183,4],[183,13,183,14],[183,11,183,12],[184,9,184,10],[184,11,184,12],[184,13,184,14],[186,9,186,11],[188,2,188,14],[183,5,183,6],[183,7,183,8],[184,3,184,4],[184,5,184,6],[184,7,184,8],[186,3,186,5],[173,9,173,10],[173,11,173,12],[174,9,174,10],[193,3,193,6],[183,9,183,10],[181,9,181,10],[181,11,181,12],[181,13,181,14],[177,13,177,14],[178,13,178,14],[179,13,179,14],[180,13,180,14],[182,3,182,4],[182,5,182,6],[182,7,182,8],[182,9,182,10],[177,3,177,4],[177,5,177,6],[177,7,177,8],[177,9,177,10],[177,11,177,12],[178,3,178,4],[180,3,180,4],[178,5,178,6],[178,7,178,8],[179,3,179,4],[179,5,179,6],[179,7,179,8],[180,5,180,6],[180,7,180,8],[178,9,178,10],[178,11,178,12],[168,9,168,10],[168,11,168,12],[168,13,168,14],[179,9,179,10],[179,11,179,12],[180,9,180,10],[180,11,180,12],[182,11,182,12],[181,3,181,4],[181,5,181,6],[172,3,172,4],[172,5,172,6],[172,7,172,8],[172,9,172,10],[172,11,172,12],[172,13,172,14],[173,3,173,4],[173,13,173,14],[175,3,175,4],[176,3,176,4],[176,5,176,6],[176,7,176,8],[176,9,176,10],[176,11,176,12],[176,13,176,14],[173,5,173,6],[173,7,173,8],[174,3,174,4],[174,5,174,6],[174,7,174,8],[175,5,175,6],[175,7,175,8],[169,13,169,14],[170,13,170,14],[170,3,170,4],[171,3,171,4],[171,5,171,6],[171,7,171,8],[171,9,171,10],[171,11,171,12],[171,13,171,14],[170,5,170,6],[170,7,170,8],[170,9,170,10],[170,11,170,12],[169,3,169,4],[169,5,169,6],[169,7,169,8],[169,9,169,10],[169,11,169,12],[5,2,5,14],[6,3,6,14],[7,3,7,4],[7,8,7,9],[7,10,7,11],[8,8,8,9],[8,10,8,11],[8,3,8,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,8,14,11],[22,2,22,14],[23,3,23,4],[165,9,165,10],[165,11,165,12],[166,9,166,10],[166,11,166,12],[166,13,166,14],[24,3,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[24,13,24,14],[165,3,165,4],[165,13,165,14],[141,7,141,8],[142,7,142,8],[143,7,143,8],[144,7,144,8],[145,7,145,8],[161,7,161,8],[162,7,162,8],[147,7,147,8],[148,7,148,8],[149,7,149,8],[150,7,150,8],[151,7,151,8],[152,7,152,8],[153,7,153,8],[154,7,154,8],[155,7,155,8],[146,7,146,8],[133,7,133,8],[134,7,134,8],[135,7,135,8],[136,7,136,8],[137,7,137,8],[125,7,125,8],[126,7,126,8],[127,7,127,8],[128,7,128,8],[129,7,129,8],[130,7,130,8],[131,7,131,8],[113,7,113,8],[114,7,114,8],[97,7,97,8],[98,7,98,8],[99,7,99,8],[132,7,132,8],[115,7,115,8],[116,7,116,8],[117,7,117,8],[118,7,118,8],[119,7,119,8],[120,7,120,8],[121,7,121,8],[122,7,122,8],[123,7,123,8],[106,7,106,8],[107,7,107,8],[108,7,108,8],[109,7,109,8],[110,7,110,8],[111,7,111,8],[112,7,112,8],[72,7,72,8],[73,7,73,8],[74,7,74,8],[75,7,75,8],[76,7,76,8],[77,7,77,8],[78,7,78,8],[79,7,79,8],[80,7,80,8],[81,7,81,8],[82,7,82,8],[83,7,83,8],[84,7,84,8],[85,7,85,8],[86,7,86,8],[87,7,87,8],[124,7,124,8],[100,7,100,8],[101,7,101,8],[102,7,102,8],[103,7,103,8],[104,7,104,8],[105,7,105,8],[88,7,88,8],[89,7,89,8],[90,7,90,8],[91,7,91,8],[92,7,92,8],[93,7,93,8],[94,7,94,8],[95,7,95,8],[96,7,96,8],[65,7,65,8],[48,7,48,8],[49,7,49,8],[50,7,50,8],[51,7,51,8],[52,7,52,8],[53,7,53,8],[54,7,54,8],[55,7,55,8],[56,7,56,8],[58,7,58,8],[59,7,59,8],[60,7,60,8],[61,7,61,8],[62,7,62,8],[63,7,63,8],[64,7,64,8],[41,11,41,12],[42,11,42,12],[66,7,66,8],[67,7,67,8],[68,7,68,8],[69,7,69,8],[70,7,70,8],[71,7,71,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[57,7,57,8],[43,7,43,8],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[43,11,43,12],[44,11,44,12],[44,9,44,10],[45,9,45,10],[46,9,46,10],[47,9,47,10],[54,11,54,12],[55,11,55,12],[56,11,56,12],[57,11,57,12],[58,11,58,12],[59,11,59,12],[60,11,60,12],[61,11,61,12],[62,11,62,12],[45,11,45,12],[46,11,46,12],[47,11,47,12],[48,11,48,12],[49,11,49,12],[50,11,50,12],[51,11,51,12],[52,11,52,12],[53,11,53,12],[48,9,48,10],[49,9,49,10],[50,9,50,10],[51,9,51,10],[52,9,52,10],[72,11,72,12],[73,11,73,12],[74,11,74,12],[75,11,75,12],[76,11,76,12],[77,11,77,12],[78,11,78,12],[79,11,79,12],[80,11,80,12],[63,11,63,12],[64,11,64,12],[65,11,65,12],[66,11,66,12],[67,11,67,12],[68,11,68,12],[69,11,69,12],[70,11,70,12],[71,11,71,12],[90,11,90,12],[91,11,91,12],[92,11,92,12],[93,11,93,12],[94,11,94,12],[95,11,95,12],[96,11,96,12],[97,11,97,12],[98,11,98,12],[81,11,81,12],[82,11,82,12],[83,11,83,12],[84,11,84,12],[85,11,85,12],[86,11,86,12],[87,11,87,12],[88,11,88,12],[89,11,89,12],[108,11,108,12],[109,11,109,12],[110,11,110,12],[111,11,111,12],[112,11,112,12],[113,11,113,12],[114,11,114,12],[115,11,115,12],[116,11,116,12],[99,11,99,12],[100,11,100,12],[101,11,101,12],[102,11,102,12],[103,11,103,12],[104,11,104,12],[105,11,105,12],[106,11,106,12],[107,11,107,12],[127,11,127,12],[128,11,128,12],[129,11,129,12],[130,11,130,12],[131,11,131,12],[132,11,132,12],[133,11,133,12],[134,11,134,12],[117,11,117,12],[118,11,118,12],[119,11,119,12],[120,11,120,12],[121,11,121,12],[122,11,122,12],[123,11,123,12],[124,11,124,12],[125,11,125,12],[42,13,42,14],[43,13,43,14],[44,13,44,14],[45,13,45,14],[153,11,153,12],[154,11,154,12],[155,11,155,12],[156,11,156,12],[157,11,157,12],[158,11,158,12],[159,11,159,12],[160,11,160,12],[161,11,161,12],[144,11,144,12],[145,11,145,12],[146,11,146,12],[147,11,147,12],[148,11,148,12],[149,11,149,12],[150,11,150,12],[151,11,151,12],[152,11,152,12],[135,11,135,12],[136,11,136,12],[137,11,137,12],[138,11,138,12],[139,11,139,12],[140,11,140,12],[141,11,141,12],[142,11,142,12],[143,11,143,12],[126,11,126,12],[25,11,25,12],[26,13,26,14],[27,13,27,14],[28,13,28,14],[29,13,29,14],[30,13,30,14],[31,13,31,14],[32,13,32,14],[33,13,33,14],[34,13,34,14],[35,13,35,14],[36,13,36,14],[37,13,37,14],[38,13,38,14],[39,13,39,14],[40,13,40,14],[41,13,41,14],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[40,11,40,12],[55,13,55,14],[56,13,56,14],[57,13,57,14],[58,13,58,14],[59,13,59,14],[60,13,60,14],[61,13,61,14],[62,13,62,14],[63,13,63,14],[46,13,46,14],[47,13,47,14],[48,13,48,14],[49,13,49,14],[50,13,50,14],[51,13,51,14],[52,13,52,14],[53,13,53,14],[54,13,54,14],[73,13,73,14],[74,13,74,14],[75,13,75,14],[76,13,76,14],[77,13,77,14],[78,13,78,14],[79,13,79,14],[80,13,80,14],[81,13,81,14],[64,13,64,14],[65,13,65,14],[66,13,66,14],[67,13,67,14],[68,13,68,14],[69,13,69,14],[70,13,70,14],[71,13,71,14],[72,13,72,14],[91,13,91,14],[92,13,92,14],[93,13,93,14],[94,13,94,14],[95,13,95,14],[96,13,96,14],[97,13,97,14],[98,13,98,14],[99,13,99,14],[82,13,82,14],[83,13,83,14],[84,13,84,14],[85,13,85,14],[86,13,86,14],[87,13,87,14],[88,13,88,14],[89,13,89,14],[90,13,90,14],[109,13,109,14],[110,13,110,14],[111,13,111,14],[112,13,112,14],[113,13,113,14],[114,13,114,14],[115,13,115,14],[116,13,116,14],[117,13,117,14],[100,13,100,14],[101,13,101,14],[102,13,102,14],[103,13,103,14],[104,13,104,14],[105,13,105,14],[106,13,106,14],[107,13,107,14],[108,13,108,14],[143,13,143,14],[144,13,144,14],[127,13,127,14],[128,13,128,14],[129,13,129,14],[130,13,130,14],[131,13,131,14],[132,13,132,14],[133,13,133,14],[134,13,134,14],[135,13,135,14],[118,13,118,14],[119,13,119,14],[120,13,120,14],[121,13,121,14],[122,13,122,14],[123,13,123,14],[124,13,124,14],[125,13,125,14],[126,13,126,14],[25,9,25,10],[26,9,26,10],[28,9,28,10],[29,9,29,10],[30,9,30,10],[31,9,31,10],[32,9,32,10],[33,9,33,10],[34,9,34,10],[163,13,163,14],[164,13,164,14],[25,13,25,14],[154,13,154,14],[155,13,155,14],[156,13,156,14],[157,13,157,14],[158,13,158,14],[159,13,159,14],[160,13,160,14],[161,13,161,14],[162,13,162,14],[145,13,145,14],[146,13,146,14],[147,13,147,14],[148,13,148,14],[149,13,149,14],[150,13,150,14],[151,13,151,14],[152,13,152,14],[153,13,153,14],[136,13,136,14],[137,13,137,14],[35,9,35,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[40,9,40,10],[41,9,41,10],[42,9,42,10],[43,9,43,10],[62,9,62,10],[63,9,63,10],[64,9,64,10],[65,9,65,10],[66,9,66,10],[67,9,67,10],[68,9,68,10],[69,9,69,10],[70,9,70,10],[53,9,53,10],[54,9,54,10],[55,9,55,10],[56,9,56,10],[57,9,57,10],[58,9,58,10],[59,9,59,10],[60,9,60,10],[61,9,61,10],[80,9,80,10],[81,9,81,10],[82,9,82,10],[83,9,83,10],[84,9,84,10],[85,9,85,10],[86,9,86,10],[87,9,87,10],[88,9,88,10],[71,9,71,10],[72,9,72,10],[73,9,73,10],[74,9,74,10],[75,9,75,10],[76,9,76,10],[77,9,77,10],[78,9,78,10],[79,9,79,10],[98,9,98,10],[99,9,99,10],[100,9,100,10],[101,9,101,10],[102,9,102,10],[103,9,103,10],[104,9,104,10],[105,9,105,10],[106,9,106,10],[89,9,89,10],[90,9,90,10],[91,9,91,10],[92,9,92,10],[93,9,93,10],[94,9,94,10],[95,9,95,10],[96,9,96,10],[97,9,97,10],[129,9,129,10],[130,9,130,10],[131,9,131,10],[132,9,132,10],[133,9,133,10],[116,9,116,10],[117,9,117,10],[118,9,118,10],[119,9,119,10],[120,9,120,10],[121,9,121,10],[122,9,122,10],[123,9,123,10],[124,9,124,10],[107,9,107,10],[108,9,108,10],[109,9,109,10],[110,9,110,10],[111,9,111,10],[112,9,112,10],[113,9,113,10],[114,9,114,10],[115,9,115,10],[43,3,43,4],[152,9,152,10],[153,9,153,10],[154,9,154,10],[155,9,155,10],[156,9,156,10],[157,9,157,10],[158,9,158,10],[159,9,159,10],[160,9,160,10],[143,9,143,10],[144,9,144,10],[145,9,145,10],[146,9,146,10],[147,9,147,10],[148,9,148,10],[149,9,149,10],[150,9,150,10],[151,9,151,10],[134,9,134,10],[135,9,135,10],[136,9,136,10],[137,9,137,10],[138,9,138,10],[139,9,139,10],[140,9,140,10],[141,9,141,10],[142,9,142,10],[125,9,125,10],[126,9,126,10],[127,9,127,10],[128,9,128,10],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[161,9,161,10],[162,9,162,10],[163,9,163,10],[164,9,164,10],[27,9,27,10],[42,3,42,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[67,3,67,4],[68,3,68,4],[69,3,69,4],[70,3,70,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[61,3,61,4],[80,3,80,4],[81,3,81,4],[82,3,82,4],[83,3,83,4],[84,3,84,4],[85,3,85,4],[86,3,86,4],[87,3,87,4],[88,3,88,4],[71,3,71,4],[72,3,72,4],[73,3,73,4],[74,3,74,4],[75,3,75,4],[76,3,76,4],[77,3,77,4],[78,3,78,4],[79,3,79,4],[98,3,98,4],[99,3,99,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[104,3,104,4],[105,3,105,4],[106,3,106,4],[89,3,89,4],[90,3,90,4],[91,3,91,4],[92,3,92,4],[93,3,93,4],[94,3,94,4],[95,3,95,4],[96,3,96,4],[97,3,97,4],[127,3,127,4],[128,3,128,4],[129,3,129,4],[130,3,130,4],[131,3,131,4],[132,3,132,4],[133,3,133,4],[116,3,116,4],[117,3,117,4],[118,3,118,4],[119,3,119,4],[120,3,120,4],[121,3,121,4],[122,3,122,4],[123,3,123,4],[124,3,124,4],[107,3,107,4],[108,3,108,4],[109,3,109,4],[110,3,110,4],[111,3,111,4],[112,3,112,4],[113,3,113,4],[114,3,114,4],[115,3,115,4],[42,5,42,6],[43,5,43,6],[44,5,44,6],[152,3,152,4],[153,3,153,4],[154,3,154,4],[155,3,155,4],[156,3,156,4],[157,3,157,4],[158,3,158,4],[159,3,159,4],[160,3,160,4],[143,3,143,4],[144,3,144,4],[145,3,145,4],[146,3,146,4],[147,3,147,4],[148,3,148,4],[149,3,149,4],[150,3,150,4],[151,3,151,4],[134,3,134,4],[135,3,135,4],[136,3,136,4],[137,3,137,4],[138,3,138,4],[139,3,139,4],[140,3,140,4],[141,3,141,4],[142,3,142,4],[125,3,125,4],[126,3,126,4],[25,5,25,6],[26,5,26,6],[27,5,27,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[37,5,37,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[54,5,54,6],[55,5,55,6],[56,5,56,6],[57,5,57,6],[58,5,58,6],[59,5,59,6],[60,5,60,6],[61,5,61,6],[62,5,62,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[49,5,49,6],[50,5,50,6],[51,5,51,6],[52,5,52,6],[53,5,53,6],[72,5,72,6],[73,5,73,6],[74,5,74,6],[75,5,75,6],[76,5,76,6],[77,5,77,6],[78,5,78,6],[79,5,79,6],[80,5,80,6],[63,5,63,6],[64,5,64,6],[65,5,65,6],[66,5,66,6],[67,5,67,6],[68,5,68,6],[69,5,69,6],[70,5,70,6],[71,5,71,6],[90,5,90,6],[91,5,91,6],[92,5,92,6],[93,5,93,6],[94,5,94,6],[95,5,95,6],[96,5,96,6],[97,5,97,6],[98,5,98,6],[81,5,81,6],[82,5,82,6],[83,5,83,6],[84,5,84,6],[85,5,85,6],[86,5,86,6],[87,5,87,6],[88,5,88,6],[89,5,89,6],[108,5,108,6],[109,5,109,6],[110,5,110,6],[111,5,111,6],[112,5,112,6],[113,5,113,6],[114,5,114,6],[115,5,115,6],[116,5,116,6],[99,5,99,6],[100,5,100,6],[101,5,101,6],[102,5,102,6],[103,5,103,6],[104,5,104,6],[105,5,105,6],[106,5,106,6],[107,5,107,6],[126,5,126,6],[127,5,127,6],[128,5,128,6],[129,5,129,6],[130,5,130,6],[131,5,131,6],[132,5,132,6],[133,5,133,6],[134,5,134,6],[117,5,117,6],[118,5,118,6],[119,5,119,6],[120,5,120,6],[121,5,121,6],[122,5,122,6],[123,5,123,6],[124,5,124,6],[125,5,125,6],[144,5,144,6],[145,5,145,6],[146,5,146,6],[147,5,147,6],[148,5,148,6],[149,5,149,6],[150,5,150,6],[151,5,151,6],[152,5,152,6],[163,7,163,8],[164,7,164,8],[181,7,181,8],[135,5,135,6],[136,5,136,6],[137,5,137,6],[138,5,138,6],[139,5,139,6],[140,5,140,6],[141,5,141,6],[142,5,142,6],[143,5,143,6],[168,7,168,8],[165,5,165,6],[165,7,165,8],[138,7,138,8],[139,7,139,8],[140,7,140,8],[156,7,156,8],[157,7,157,8],[158,7,158,8],[159,7,159,8],[160,7,160,8],[161,3,161,4],[162,3,162,4],[163,3,163,4],[164,3,164,4],[138,13,138,14],[139,13,139,14],[140,13,140,14],[141,13,141,14],[142,13,142,14],[232,9,232,11],[232,13,232,14],[232,3,232,7],[162,5,162,6],[163,5,163,6],[164,5,164,6],[222,8,223,8],[218,8,219,8],[153,5,153,6],[154,5,154,6],[155,5,155,6],[156,5,156,6],[157,5,157,6],[158,5,158,6],[159,5,159,6],[160,5,160,6],[161,5,161,6],[162,11,162,12],[163,11,163,12],[164,11,164,12],[167,3,167,4],[168,3,168,4],[168,5,168,6],[215,2,215,14],[226,2,229,14],[166,3,166,4],[166,5,166,6],[166,7,166,8],[198,8,198,9],[198,3,198,6],[203,3,203,6],[203,8,203,9],[208,3,208,6],[208,8,208,9],[213,3,213,5],[213,9,213,11],[194,8,194,10],[195,8,195,10],[199,8,199,10],[204,8,204,10],[205,8,205,10],[209,8,209,10],[210,8,210,10],[200,8,200,10],[190,7,190,9]],"merged_total":1010,"flags":["merged_cut"]}
[]
[]
[]
[]
[]
[null,null,"Informações Iniciais do Sistema"]
[null,null,"Cidade/Distrito"]
[null,null,"Ano Inicial",null,null,null,null,null,"Ano Final"]
[null,null,"População Atual",null,null,null,null,null,"População Futura"]
[null,null,"Taxa de Crescimento",{"$f":"IFERROR((($K$9/$D$9)^(1/($K$8-$D$8))-1),\"\")","v":""}]
[]
[null,null,"Número de Economias atuais"]
[null,null,"Taxa de Ocupação (n/hab)"]
[null,null,"População Atendida (hab.)",{"$f":"IF(OR($D$12=\"\",$D$13=\"\"),\"\",$D$13*$D$12)","v":""}]
[null,null,"Índice de cobertura de água Atual (%)",{"$f":"IFERROR(IF(D14/D9>1,1,D14/D9),\"\")","v":""},null,null,null,null,"Índice de Cobertura de Água Futura (%)"]
[]
[null,null,"Ano","Jan","Fev","Mar","Abr","Mai","Jun","Jul","Ago","Set","Out","Nov","Dez"]
[]
[null,null,"Consumo Per Capita (L/hab.dia)",{"$f":"IF(SUM($D$18:$O$18)=0,\"\",AVERAGE($D$18:$O$18))","v":""}]
[]
[null,null,"Perda de água do sistema (%)"]
[]
[null,null,"Captação de Água Subterranea"]
[null,null,"Número de Poços do sistema"]
[null,null,"Numeração do Poço e DURH","Vazão Instântanea (m³/h)",null,"Tempo Média de Operação Atual (h/dia)",null,"Volume Captado Atual (m³/dia)",null,"Tempo Maximo de Operação (h/dia)",null,"Volume Captado Máximo (m³/dia)",null,"População atendida por poço (hab.)"]
[null,null,null,null,null,null,null,{"$f":"IF(OR(D26=\"\",F26=\"\"),\"\",D26*F26)","v":""},null,null,null,{"$f":"IF(OR(D26=\"\",J26=\"\"),\"\",D26*J26)","v":""},null,{"$f":"IFERROR(((L26-$D$21*L26)*1000)/$D$19,\"\")","v":""}]
[null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(OR(D27=\"\",J27=\"\"),\"\",D27*J27)","v":""},null,{"$f":"IFERROR(((L27-$D$21*L27)*1000)/$D$19,\"\")","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,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,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(OR(D49=\"\",F49=\"\"),\"\",D49*F49)","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,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,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(OR(D73=\"\",F73=\"\"),\"\",D73*F73)","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,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,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(OR(D91=\"\",J91=\"\"),\"\",D91*J91)","v":""},null,{"$f":"IFERROR(((L91-$D$21*L91)*1000)/$D$19,\"\")","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,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,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(OR(D116=\"\",F116=\"\"),\"\",D116*F116)","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,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,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(OR(D142=\"\",F142=\"\"),\"\",D142*F142)","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,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,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(OR(D155=\"\",J155=\"\"),\"\",D155*J155)","v":""},null,{"$f":"IFERROR(((L155-$D$21*L155)*1000)/$D$19,\"\")","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,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,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(OR(D166=\"\",F166=\"\"),\"\",D166*F166)","v":""},null,null,null,{"$f":"IF(OR(D166=\"\",J166=\"\"),\"\",D166*J166)","v":""},null,{"$f":"IFERROR(((L166-$D$21*L166)*1000)/$D$19,\"\")","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,{"$f":"IFERROR(H169/$L169,\"\")","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,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[]
[null,null,null,"População Máxima Atendida (hab.)",null,null,{"$f":"IFERROR(((SUM($L$26:L185)-$D$21*SUM($L$26:L185))*1000)/$D$19,\"\")","v":""},null,null,"Vazão Máxima Captada (m³/dia)",null,null,{"$f":"IF(SUM($L$26:M185)=0,\"\",SUM($L$26:$M$185))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sim"]
[null,null,"Captação de Água Superficial",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Não"]
[]
[null,null,"Número de Captações",null,null,null,null,"Vazão necessaria (m³/dia)",null,null,{"$f":"IFERROR(IF((K9*M15)>G187,(($K$9*$M$15*$D$19/1000)-$M$187*(1-D21))*(1+$D$21),\nIF(G187>(K9*M15),(($K$9*$M$15*$D$19/1000)-$M$187),\"\")),\"\")","v":""},"em ",{"$f":"IFERROR(IF($K$191=\"\",\"\",$K$8-$D$8),\"\")","v":""},"anos"]
[]
[null,null,"Já é outorgada ?",null,null,null,null,null,null,null,"Latitude","Longitude"]
[null,null,"Nome do curso Hidrico",null,null,null,null,null,"Coordenada"]
[null,null,{"$f":"IF(D193=\"Sim\",\"Vazão Outorgada (m³/h)\",IF(D193=\"Não\",\"Vazão Requerida (m³/h)\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(D193<>\"\",\"Tempo de Captação Diario (h)\",\"\")","v":""}]
[null,null,{"$f":"IF(D193=\"Sim\",\"Vazão Média Atual (m³/h)\",IF(D193=\"Não\",\"Não há captação atualmente\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(D193=\"Sim\",\"Tempo de Captação Diario (h)\",IF(D193=\"Não\",\"Não há captação atualmente\",\"\"))","v":""}]
[]
[null,null,"Já é outorgada ?",null,null,null,null,null,null,null,"Latitude","Longitude"]
[null,null,"Nome do curso Hidrico",null,null,null,null,null,"Coordenada"]
[null,null,{"$f":"IF(D198=\"Sim\",\"Vazão Outorgada (m³/h)\",IF(D198=\"Não\",\"Vazão Requerida (m³/h)\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(D198<>\"\",\"Tempo de Captação Diario (h)\",\"\")","v":""}]
[null,null,{"$f":"IF(D198=\"Sim\",\"Vazão Média Atual (m³/h)\",IF(D198=\"Não\",\"Não há captação atualmente\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(D198=\"Sim\",\"Tempo de Captação Diario (h)\",IF(D198=\"Não\",\"Não há captação atualmente\",\"\"))","v":""}]
[]
[null,null,"Já é outorgada ?",null,null,null,null,null,null,null,"Latitude","Longitude"]
[null,null,"Nome do curso Hidrico",null,null,null,null,null,"Coordenada"]
[null,null,{"$f":"IF(D203=\"Sim\",\"Vazão Outorgada (m³/h)\",IF(D203=\"Não\",\"Vazão Requerida (m³/h)\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(D203<>\"\",\"Tempo de Captação Diario (h)\",\"\")","v":""}]
[null,null,{"$f":"IF(D203=\"Sim\",\"Vazão Média Atual (m³/h)\",IF(D203=\"Não\",\"Não há captação atualmente\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(D203=\"Sim\",\"Tempo de Captação Diario (h)\",IF(D203=\"Não\",\"Não há captação atualmente\",\"\"))","v":""}]
[]
[null,null,"Já é outorgada ?",null,null,null,null,null,null,null,"Latitude","Longitude"]
[null,null,"Nome do curso Hidrico",null,null,null,null,null,"Coordenada"]
[null,null,{"$f":"IF(D208=\"Sim\",\"Vazão Outorgada (m³/h)\",IF(D208=\"Não\",\"Vazão Requerida (m³/h)\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(D208<>\"\",\"Tempo de Captação Diario (h)\",\"\")","v":""}]
[null,null,{"$f":"IF(D208=\"Sim\",\"Vazão Média Atual (m³/h)\",IF(D208=\"Não\",\"Não há captação atualmente\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(D208=\"Sim\",\"Tempo de Captação Diario (h)\",IF(D208=\"Não\",\"Não há captação atualmente\",\"\"))","v":""}]
[]
[]
[null,null,null,"População Máxima Atendida (hab.)",null,null,{"$f":"IFERROR(((SUM(D195*L195,D200*L200,D205*L205,D210*L210)-SUM(D195*L195,D200*L200,D205*L205,D210*L210)*D21)*1000)/D19,\"\")","v":""},null,null,"Vazão Máxima Captada (m³/dia)",null,null,{"$f":"IF(D191<>\"\",SUM(D195*L195,D200*L200,D205*L205,D210*L210),\"\")","v":""}]
[]
[null,null,"Informações Finais do Sistema"]
[]
[null,null,"Demanda Atual do Sistema (Total)",{"$f":"IFERROR($D$9*$D$15*($D$19/86400)*(1+$D$21),\"\")","v":""},"L/s",{"$f":"IFERROR(D218*86.4,\"\")","v":""},"m³/dia",{"$f":"IFERROR(D218/$D$218,\"\")","v":""},"Ano"]
[null,null,"Captação de Água Subterrânea atual",{"$f":"IF(SUM($H$26:I185)=0,\"\",SUM($H$26:I185)/86.4)","v":""},"L/s",{"$f":"IFERROR(D219*86.4,\"\")","v":""},"m³/dia",{"$f":"IFERROR(D219/$D$218,\"\")","v":""},{"$f":"D8","v":0}]
[null,null,"Captação de Água Superficial atual",{"$f":"IF(D191<>\"\",SUM(D196*L196,D201*L201,D206*L206,D211*L211)/86.4,\"\")","v":""},"L/s",{"$f":"IFERROR(D220*86.4,\"\")","v":""},"m³/dia",{"$f":"IFERROR(D220/$D$218,\"\")","v":""}]
[]
[null,null,"Demanda Futura do Sistema (Total)",{"$f":"IFERROR($K$9*$M$15*(1+$D$21)*$D$19/86400,\"\")","v":""},"L/s",{"$f":"IFERROR(D222*86.4,\"\")","v":""},"m³/dia",{"$f":"IFERROR(D222/$D$222,\"\")","v":""},"Ano"]
[null,null,"Captação de Água Subterrânea Max.",{"$f":"IF(SUM($L$26:M185)=0,\"\",SUM($L$26:M185)/86.4)","v":""},"L/s",{"$f":"IFERROR(D223*86.4,\"\")","v":""},"m³/dia",{"$f":"IFERROR(D223/$D$222,\"\")","v":""},{"$f":"K8","v":0}]
[null,null,"Captação de Água Superficial Futura",{"$f":"IF(F224<>\"\",F224/86.4,\"\")","v":""},"L/s",{"$f":"IF(D191<>\"\",M214,\"\")","v":""},"m³/dia",{"$f":"IFERROR(D224/$D$222,\"\")","v":""}]
[]
[null,null,"Observações:"]
[]
[]
[]
[]
[]
[null,null,"RESPONSABILIDADE TÉCNICA"]
[null,null,"Responsável Técnico:",null,null,null,null,null,"CREA:",null,null,null,"Data:"]