用友U8资产负债表公式

C7=QC("1001",全年,,,,,,,"y",,)+QC("1002",全年,,,,,,,"y",,)+QC("1012",全年,,,,,,,"y",,)
D7=QM("1001",月,,,,,,,"y",,)+QM("1002",月,,,,,,,"y",,)+QM("1012",月,,,,,,,"y",,)
G7=QC("2001",全年,,,,,,,"y",,)
H7=QM("2001",月,,,,,,,"y",,)
C8=QC("1101",全年,,,,,,,"y",,)
D8=QM("1101",月,,,,,,,"y",,)
G8=QC("2101",全年,,,,,,,"y",,)
H8=QM("2101",月,,,,,,,"y",,)
C9=QC("1121",全年,,,,,,,"y",,)
D9=QM("1121",月,,,,,,,"y",,)
G9=QC("2201",全年,,,,,,,"y",,)
H9=QM("2201",月,,,,,,,"y",,)
C10=QC("1131",全年,,,,,,,"y",,)
D10=QM("1131",月,,,,,,,"y",,)
G10=QCEX("2202",全年,"贷",,,,,,,"y",,)+QCEX("1123",全年,"贷",,,"",,,,"y",,,)
H10=QMEX("2202",月,"贷",,,,,,,"y",,)+QMEX("1123",月,"贷",,,"",,,,"y",,,)
C11=QC("1132",全年,,,,,,,"y",,)
D11=QM("1132",月,,,,,,,"y",,)
G11=QCEX("112201",全年,"贷",,,"",,,,"y",,,)+QCEX("112202",全年,"贷",,,"",,,,"y",,,)+QCEX("112203",全年,"贷",,,"",,,,"y",,,)+QCEX("112204",全年,"贷",,,"",,,,"y",,,)+QCEX("112205",全年,"贷",,,"",,,,"y",,,)+QCEX("112206",全年,"贷",,,"",,,,"y",,,)+QCEX("2203",全年,"贷",,,"",,,,"y",,,)
H11=QMEX("112201",月,"贷",,,"",,,,"y",,,)+QMEX("112202",月,"贷",,,"",,,,"y",,,)+QMEX("112203",月,"贷",,,"",,,,"y",,,)+QMEX("112204",月,"贷",,,"",,,,"y",,,)+QMEX("112205",月,"贷",,,"",,,,"y",,,)+QMEX("112206",月,"贷",,,"",,,,"y",,,)+QMEX("2203",月,"贷",,,"",,,,"y",,,)
C12=QCEX("112201",全年,"借",,,"",,,,"y",,,)+QCEX("112202",全年,"借",,,"",,,,"y",,,)+QCEX("112203",全年,"借",,,"",,,,"y",,,)+QCEX("112204",全年,"借",,,"",,,,"y",,,)+QCEX("112205",全年,"借",,,"",,,,"y",,,)+QCEX("112206",全年,"借",,,"",,,,"y",,,)-QC("1231",全年,,,,,,,"y",,)+QCEX("2203",全年,"借",,,"",,,,"y",,,)
D12=QMEX("112201",月,"借",,,"",,,,"y",,,)+QMEX("112202",月,"借",,,"",,,,"y",,,)+QMEX("112203",月,"借",,,"",,,,"y",,,)+QMEX("112204",月,"借",,,"",,,,"y",,,)+QMEX("112205",月,"借",,,"",,,,"y",,,)+QMEX("112206",月,"借",,,"",,,,"y",,,)-QM("1231",月,,,,,,,"y",,)+QMEX("2203",月,"借",,,"",,,,"y",,,)
G12=QC("2211",全年,,,,,,,"y",,)
H12=QM("2211",月,,,,,,,"y",,)
C13=QCEX("122101",全年,"借",,,"",,,,"y",,,)+QCEX("122102",全年,"借",,,"",,,,"y",,,)+QCEX("122103",全年,"借",,,"",,,,"y",,,)+QCEX("2241",全年,"借",,,"",,,,"y",,,)
D13=QMEX("122101",月,"借",,,"",,,,"y",,,)+QMEX("122102",月,"借",,,"",,,,"y",,,)+QMEX("122103",月,"借",,,"",,,,"y",,,)+QMEX("2241",月,"借",,,"",,,,"y",,,)
G13=QC("2221",全年,,,,,,,"y",,)
H13=QM("2221",月,,,,,,,"y",,)
C14=QCEX("1123",全年,"借",,,"",,,,"y",,,)+QCEX("2202",全年,"借",,,"",,,,"y",,,)
D14=QMEX("1123",月,"借",,,"",,,,"y",,,)+QMEX("2202",月,"借",,,"",,,,"y",,,)
G14=QC("2231",全年,,,,,,,"y",,)
H14=QM("2231",月,,,,,,,"y",,)
C15=QC("1401",全年,,,,,,,"y",,)+QC("1402",全年,,,,,,,"y",,)+QC("1403",全年,,,,,,,"y",,)+QC("1404",全年,,,,,,,"y",,)+QC("1405",全年,,,,,,,"y",,)+QC("1406",全年,,,,,,,"y",,)+QC("1407",全年,,,,,,,"y",,)+QC("1408",全年,,,,,,,"y",,)+QC("1411",全年,,

,,,,,"y",,)+QC("1421",全年,,,,,,,"y",,)-QC("1471",全年,,,,,,,"y",,)
D15=QM("1401",月,,,,,,,"y",,)+QM("1402",月,,,,,,,"y",,)+QM("1403",月,,,,,,,"y",,)+QM("1404",月,,,,,,,"y",,)+QM("1405",月,,,,,,,"y",,)+QM("1406",月,,,,,,,"y",,)+QM("1407",月,,,,,,,"y",,)+QM("1408",月,,,,,,,"y",,)+QM("1411",月,,,,,,,"y",,)+QM("1421",月,,,,,,,"y",,)-QM("1471",月,,,,,,,"y",,)
G15=QC("2232",全年,,,,,,,"y",,)
H15=QM("2232",月,,,,,,,"y",,)
G16=QCEX("122101",全年,"贷",,,"",,,,"y",,,)+QCEX("122102",全年,"贷",,,"",,,,"y",,,)+QCEX("122103",全年,"贷",,,"",,,,"y",,,)+QCEX("2241",全年,"贷",,,"",,,,"y",,,)
H16=QMEX("122101",月,"贷",,,"",,,,"y",,,)+QMEX("122102",月,"贷",,,"",,,,"y",,,)+QMEX("122103",月,"贷",,,"",,,,"y",,,)+QMEX("2241",月,"贷",,,"",,,,"y",,,)
C20=ptotal(?C7:?C17)
D20=ptotal(?D7:?D17)
G20=ptotal(?G7:?G18)
H20=ptotal(?H7:?H18)
C22=QC("1503",全年,,,,,,,"y",,)
D22=QM("1503",月,,,,,,,"y",,)
G22=QC("2501",全年,,,,,,,"y",,)
H22=QM("2501",月,,,,,,,"y",,)
C23=QC("1501",全年,,,,,,,"y",,)-QC("1502",全年,,,,,,,"y",,)
D23=QM("1501",月,,,,,,,"y",,)-QM("1502",月,,,,,,,"y",,)
G23=QC("2502",全年,,,,,,,"y",,)
H23=QM("2502",月,,,,,,,"y",,)
C24=QC("1521",全年,,,,,,,"y",,)
D24=QM("1521",月,,,,,,,"y",,)
G24=QC("2701",全年,,,,,,,"y",,)
H24=QM("2701",月,,,,,,,"y",,)
C25=QC("1511",全年,,,,,,,"y",,)-QC("1512",全年,,,,,,,"y",,)
D25=QM("1511",月,,,,,,,"y",,)-QM("1512",月,,,,,,,"y",,)
G25=QC("271101",全年,,,,,,,"y",,)+QC("271102",全年,,,,,,,"y",,)
H25=QM("271101",月,,,,,,,"y",,)+QM("271102",月,,,,,,,"y",,)
C26=QC("153101",全年,,,,,,,"y",,)
D26=QM("153101",月,,,,,,,"y",,)
G26=QC("2801",全年,,,,,,,"y",,)
H26=QM("2801",月,,,,,,,"y",,)
C27=QC("1601",全年,,,,,,,"y",,)
D27=QM("1601",月,,,,,,,"y",,)
G27=QC("2901",全年,,,,,,,"y",,)
H27=QM("2901",月,,,,,,,"y",,)
C28=QC("1602",全年,,,,,,,"y",,)
D28=QM("1602",月,,,,,,,"y",,)
G28=QC("2702",全年,,,,,,,"y",,)
H28=QM("2702",月,,,,,,,"y",,)
C29=?C27-?C28
D29=?D27-?D28
G29=ptotal(?G22:?G28)
H29=ptotal(?H22:?H28)
C30=QC("1603",全年,,,,,,,"y",,)
D30=QM("1603",月,,,,,,,"y",,)
G30=?G20+?G29
H30=?H20+?H29
C31=?C29-?C30
D31=?D29-?D30
C32=QC("1621",全年,,,,,,,"y",,)-QC("1622",全年,,,,,,,"y",,)
D32=QM("1621",月,,,,,,,"y",,)-QM("1622",月,,,,,,,"y",,)
C33=QC("1605",全年,,,,,,,"y",,)
D33=QM("1605",月,,,,,,,"y",,)
G33=QC("4001",全年,,,,,,,"y",,)
H33=QM("4001",月,,,,,,,"y",,)
C34=QC("1604",全年,,,,,,,"y",,)
D34=QM("1604",月,,,,,,,"y",,)
G34=QC("4002",全年,,,,,,,"y",,)
H34=QM("4002",月,,,,,,,"y",,)
C35=QC("1606",全年,,,,,,,"y",,)
D35=QM("1606",月,,,,,,,"y",,)
G35=QC("4201",全年,,,,,,,"y",,)
H35=QM("4201",月,,,,,,,"y",,)
C36=QC("1701",全年,,,,,,,"y",,)-QC("1702",全年,,,,,,,"y",,)-QC("1703",全年,,,,,,,"y",,)
D36=QM("1701",月,,,,,,,"y",,)-QM("1702",月,,,,,,,"y",,)-QM("1703",月,,,,,,,"y",,)
G36=QC("4101",全年,,,,,,,"y",,)
H36=QM("4101",月,,,,,,,"y",,)
C37=QC("1711",全年,,,,,,,"y",,)

D37=QM("1711",月,,,,,,,"y",,)
G37=QC("4103",全年,,,,,,,"y",,)+QC("4104",全年,,,,,,,"y",,)
H37=QM("4103",月,,,,,,,"y",,)+QM("4104",月,,,,,,,"y",,)
C38=QC("1801",全年,,,,,,,"y",,)
D38=QM("1801",月,,,,,,,"y",,)
G38=?G33+?G34-?G35+?G36+?G37
H38=?H33+?H34-?H35+?H36+?H37
C39=QC("1811",全年,,,,,,,"y",,)
D39=QM("1811",月,,,,,,,"y",,)
C41=ptotal(?C22:?C26)+ptotal(?C31:?C40)
D41=ptotal(?D22:?D26)+ptotal(?D31:?D40)
C42=?C20+?C41
D42=?D20+?D41
G42=G30+G38
H42=H30+H38