Editando SisDAT: Estrutura de dados: Planilha de dados

Você pode fazer o download da planilha de intercambio de informações, no formato do Microsoft Excel 2003(xls), acessando o link listado a seguir:

*[http://www.pellisistemas.com.br/downloads/sisdat/Planilha_Dados/Modelo_Planilha_dados_Laudo.xls Modelo de Planilha de Dados e Laudos Avaliação].<br><br>

A planilha de dados para intercambio de informações entre os usuários possui o formato do Microsoft Excel 2003. Para que este processo possa ser efetuado minimizando os erros de importação, a pasta do Excel possui as seguintes planilhas:<br><br>
== Planilha de Controle de versão ==
Esta planilha é utilizada para controlar a versão do modelo de dados. Cada alteração na estrutura de dados, como por exemplo, a inclusão de nova tipologia de imóveis, irá requerer uma versão nova desta planilha. O conteúdo dela está representado abaixo:

<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=520
 style='width:390.0pt;margin-left:3.5pt;border-collapse:collapse;mso-yfti-tbllook:
 1184;mso-padding-alt:0cm 3.5pt 0cm 3.5pt'>
 <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:15.0pt'>
  <td width=172 nowrap valign=bottom style='width:128.8pt;background:#FFFF99;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
  normal'><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
  mso-fareast-font-family:"Times New Roman";mso-fareast-language:PT-BR'>Versão
  arquivo</span></b></p>
  </td>
  <td width=153 nowrap valign=bottom style='width:114.8pt;background:#FFFFCC;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
  text-align:right;line-height:normal'><span class=GramE><b><span
  style='font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
  "Times New Roman";mso-fareast-language:PT-BR'>1</span></b></span><b><span
  style='font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
  "Times New Roman";mso-fareast-language:PT-BR'></span></b></p>
  </td>
  <td width=65 nowrap valign=bottom style='width:48.8pt;background:#FFFFCC;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
  text-align:right;line-height:normal'><b><span style='font-size:10.0pt;
  font-family:"Arial","sans-serif";mso-fareast-font-family:"Times New Roman";
  mso-fareast-language:PT-BR'>0</span></b></p>
  </td>
  <td width=65 nowrap valign=bottom style='width:48.8pt;background:#FFFFCC;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
  text-align:right;line-height:normal'><b><span style='font-size:10.0pt;
  font-family:"Arial","sans-serif";mso-fareast-font-family:"Times New Roman";
  mso-fareast-language:PT-BR'>0</span></b></p>
  </td>
  <td width=65 nowrap valign=bottom style='width:48.8pt;background:#FFFFCC;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
  text-align:right;line-height:normal'><b><span style='font-size:10.0pt;
  font-family:"Arial","sans-serif";mso-fareast-font-family:"Times New Roman";
  mso-fareast-language:PT-BR'>1</span></b></p>
  </td>
 </tr>
 <tr style='mso-yfti-irow:1;height:15.0pt'>
  <td width=172 nowrap valign=bottom style='width:128.8pt;background:#FFFF99;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
  normal'><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
  mso-fareast-font-family:"Times New Roman";mso-fareast-language:PT-BR'>Versão
  produto</span></b></p>
  </td>
  <td width=153 nowrap valign=bottom style='width:114.8pt;background:#FFFFCC;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
  text-align:right;line-height:normal'><b><span style='font-size:10.0pt;
  font-family:"Arial","sans-serif";mso-fareast-font-family:"Times New Roman";
  mso-fareast-language:PT-BR'>1</span></b></p>
  </td>
  <td width=65 nowrap valign=bottom style='width:48.8pt;background:#FFFFCC;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
  text-align:right;line-height:normal'><span class=GramE><b><span
  style='font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
  "Times New Roman";mso-fareast-language:PT-BR'>0</span></b></span><b><span
  style='font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
  "Times New Roman";mso-fareast-language:PT-BR'></span></b></p>
  </td>
  <td width=65 nowrap valign=bottom style='width:48.8pt;background:#FFFFCC;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
  text-align:right;line-height:normal'><span class=GramE><b><span
  style='font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
  "Times New Roman";mso-fareast-language:PT-BR'>0</span></b></span><b><span
  style='font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
  "Times New Roman";mso-fareast-language:PT-BR'></span></b></p>
  </td>
  <td width=65 nowrap valign=bottom style='width:48.8pt;background:#FFFFCC;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
  text-align:right;line-height:normal'><span class=GramE><b><span
  style='font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
  "Times New Roman";mso-fareast-language:PT-BR'>1</span></b></span><b><span
  style='font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
  "Times New Roman";mso-fareast-language:PT-BR'></span></b></p>
  </td>
 </tr>
 <tr style='mso-yfti-irow:2;mso-yfti-lastrow:yes;height:15.0pt'>
  <td width=172 nowrap valign=bottom style='width:128.8pt;background:#FFFF99;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
  normal'><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
  mso-fareast-font-family:"Times New Roman";mso-fareast-language:PT-BR'>Software
  gerador</span></b></p>
  </td>
  <td width=153 nowrap valign=bottom style='width:114.8pt;background:#FFFFCC;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
  normal'><span class=SpellE><span class=GramE><span style='mso-ascii-font-family:
  Calibri;mso-fareast-font-family:"Times New Roman";mso-hansi-font-family:Calibri;
  mso-bidi-font-family:Calibri;color:black;mso-fareast-language:PT-BR'>SisDAT</span></span></span><span
  style='mso-ascii-font-family:Calibri;mso-fareast-font-family:"Times New Roman";
  mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri;color:black;
  mso-fareast-language:PT-BR'></span></p>
  </td>
  <td width=65 nowrap valign=bottom style='width:48.8pt;padding:0cm 3.5pt 0cm 3.5pt;
  height:15.0pt'></td>
  <td width=65 nowrap valign=bottom style='width:48.8pt;padding:0cm 3.5pt 0cm 3.5pt;
  height:15.0pt'></td>
  <td width=65 nowrap valign=bottom style='width:48.8pt;padding:0cm 3.5pt 0cm 3.5pt;
  height:15.0pt'></td>
 </tr>
</table>
<br>
[[Arquivo:Versao_Excel.png]]<br>

== Header ==

Aqui você informa sobre a quantidade de dados existentes nas planilhas de Apartamento, Casa e Terreno. Possui a seguinte estrutura:<br><br>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 align=left
 width=383 style='width:287.0pt;border-collapse:collapse;mso-table-overlap:
 never;mso-yfti-tbllook:1184;mso-table-lspace:7.05pt;margin-left:4.8pt;
 mso-table-rspace:7.05pt;margin-right:4.8pt;mso-table-anchor-vertical:paragraph;
 mso-table-anchor-horizontal:margin;mso-table-left:left;mso-table-top:21.8pt;
 mso-padding-alt:0cm 3.5pt 0cm 3.5pt'>
 <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:15.0pt'>
  <td width=229 nowrap valign=bottom style='width:172.0pt;border-top:none;
  border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;
  background:#99CCFF;padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
  normal;mso-element:frame;mso-element-frame-hspace:7.05pt;mso-element-wrap:
  around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
  margin;mso-element-top:21.8pt;mso-height-rule:exactly'><span
  style='font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
  "Times New Roman";mso-fareast-language:PT-BR'>Quant. dados Apartamentos</span></p>
  </td>
  <td width=153 nowrap valign=bottom style='width:115.0pt;background:silver;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
  text-align:right;line-height:normal;mso-element:frame;mso-element-frame-hspace:
  7.05pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;
  mso-element-anchor-horizontal:margin;mso-element-top:21.8pt;mso-height-rule:
  exactly'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
  mso-fareast-font-family:"Times New Roman";mso-fareast-language:PT-BR'>7364</span></p>
  </td>
 </tr>
 <tr style='mso-yfti-irow:1;height:15.0pt'>
  <td width=229 nowrap valign=bottom style='width:172.0pt;border-top:none;
  border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;
  background:#99CCFF;padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
  normal;mso-element:frame;mso-element-frame-hspace:7.05pt;mso-element-wrap:
  around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
  margin;mso-element-top:21.8pt;mso-height-rule:exactly'><span
  style='font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
  "Times New Roman";mso-fareast-language:PT-BR'>Quant. dados Casas</span></p>
  </td>
  <td width=153 nowrap valign=bottom style='width:115.0pt;background:silver;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
  text-align:right;line-height:normal;mso-element:frame;mso-element-frame-hspace:
  7.05pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;
  mso-element-anchor-horizontal:margin;mso-element-top:21.8pt;mso-height-rule:
  exactly'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
  mso-fareast-font-family:"Times New Roman";mso-fareast-language:PT-BR'>89</span></p>
  </td>
 </tr>
 <tr style='mso-yfti-irow:2;mso-yfti-lastrow:yes;height:15.0pt'>
  <td width=229 nowrap valign=bottom style='width:172.0pt;border-top:none;
  border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt;
  background:#99CCFF;padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
  normal;mso-element:frame;mso-element-frame-hspace:7.05pt;mso-element-wrap:
  around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
  margin;mso-element-top:21.8pt;mso-height-rule:exactly'><span
  style='font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
  "Times New Roman";mso-fareast-language:PT-BR'>Quant. dados Terrenos</span></p>
  </td>
  <td width=153 nowrap valign=bottom style='width:115.0pt;background:silver;
  padding:0cm 3.5pt 0cm 3.5pt;height:15.0pt'>
  <p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
  text-align:right;line-height:normal;mso-element:frame;mso-element-frame-hspace:
  7.05pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;
  mso-element-anchor-horizontal:margin;mso-element-top:21.8pt;mso-height-rule:
  exactly'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
  mso-fareast-font-family:"Times New Roman";mso-fareast-language:PT-BR'>30</span></p>
  </td>
 </tr>
</table>
<br><br>

<br>[[Arquivo:Header_Excel.png]]

== Empresa ==
[[Arquivo:Empresa_Excel.png]]

== Tabela de Apartamento ==
[[Arquivo:Apartamento_Excel.png]]

== Tabela de Casa ==
A tabela de casa é acessada pela aba Casas e possui diversos campos em comum com a tabela de Apartamentos. Veja a figura abaixo:<br><br>

[[Arquivo:Casa_Excel.png]]
<br><br>

== Tabela de Terreno ==

A tabela de Terreno (Lotes) é acessada pela aba Terrenos e, assim como a tabela de Casas, possui diversos campos em comum com a tabela de Apartamentos. Veja a figura abaixo:

[[Arquivo:Terreno_Excel.png]]