DSERGTP-9718 DT [JCA] Analise e ajustes caso necessário para funcionamento da planilha de custos em contratos

• Passo 01
• Passo 02

Ao selecionar a Planilha o mesmo deve retornar os devidos cálculos baseados nas informações da Linha de forma correta, que foram montadas na planilha custo de viagem, e será gravado no XML da tabela GYD, no retorno como modelo abaixo:

<?xml version="1.0" encoding="UTF-8"?>
<FWMODELSHEET Operation="4" version="1.01">
<MODEL_SHEET modeltype="FIELDS">
<TOTLINES order="1">
<value>10</value>
</TOTLINES>
<TOTCOLUMNS order="2">
<value>5</value>
</TOTCOLUMNS>
<MODEL_CELLS modeltype="GRID" optional="1">
<struct>
<NAME order="1" />
<NICKNAME order="2" />
<FORMULA order="3" />
<VALUE order="4" />
<PICTURE order="5" />
<BLOCKCELL order="6" />
<BLOCKNAME order="7" />
</struct>
<items>
<item id="1" deleted="0">
<NAME>A1</NAME>
<VALUE>Campo Referencia</VALUE>
<PICTURE>@!</PICTURE>
</item>
<item id="2" deleted="0">
<NAME>B1</NAME>
<VALUE>Descricao</VALUE>
<PICTURE>@!</PICTURE>
</item>
<item id="3" deleted="0">
<NAME>C1</NAME>
<VALUE>Valor</VALUE>
<PICTURE>@!</PICTURE>
</item>
<item id="4" deleted="0">
<NAME>D1</NAME>
<VALUE>Formula</VALUE>
<PICTURE>@!</PICTURE>
</item>
<item id="5" deleted="0">
<NAME>A2</NAME>
<NICKNAME>A2</NICKNAME>
<VALUE>GYD_KMIDA</VALUE>
<PICTURE>@!</PICTURE>
</item>
<item id="6" deleted="0">
<NAME>B2</NAME>
<VALUE>KM DIA</VALUE>
<PICTURE>@!</PICTURE>
</item>
<item id="7" deleted="0">
<NAME>C2</NAME>
<NICKNAME>GYD_KMIDA</NICKNAME>
<VALUE>30</VALUE>
<PICTURE>@E 999,999,999.99</PICTURE>
</item>
<item id="8" deleted="0">
<NAME>D2</NAME>
<FORMULA>=D3*10</FORMULA>
<VALUE>300</VALUE>
<PICTURE>@E 999,999,999.99</PICTURE>
</item>
<item id="9" deleted="0">
<NAME>A3</NAME>
<VALUE>GYD_KMVOLT</VALUE>
<PICTURE>@!</PICTURE>
</item>
<item id="10" deleted="0">
<NAME>B3</NAME>
<VALUE>KM VOLTA</VALUE>
<PICTURE>@!</PICTURE>
</item>
<item id="11" deleted="0">
<NAME>C3</NAME>
<NICKNAME>GYD_KMVOLT</NICKNAME>
<VALUE>0</VALUE>
<PICTURE>@E 999,999,999.99</PICTURE>
</item>
<item id="12" deleted="0">
<NAME>D3</NAME>
<FORMULA>=C2+C3</FORMULA>
<VALUE>30</VALUE>
<PICTURE>@E 999,999,999.99</PICTURE>
</item>
<item id="13" deleted="0">
<NAME>A4</NAME>
</item>
<item id="14" deleted="0">
<NAME>D4</NAME>
</item>
</items>
</MODEL_CELLS>
</MODEL_SHEET>
</FWMODELSHEET>

Sendo o valor gerado na coluna D2 no caso acima, e será populado quando gerar a apuração