{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["工事概況調"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"工事概況調","index":0,"n_rows":28,"n_cols":38,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,20,3,23],[3,24,3,27],[3,28,3,29],[1,20,1,22],[0,20,0,22],[3,36,4,36],[3,33,4,33],[3,35,4,35],[3,34,4,34],[3,30,3,32],[3,12,3,18],[0,4,0,9],[0,11,0,13],[1,4,1,7],[1,8,1,14],[0,17,0,19],[1,17,1,19],[3,11,4,11],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,3,6],[3,7,3,10]]}
[null,null,null,null,"工事概況調",null,null,null,null,null,"（","2020-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,null,null,null,null,"(","決　　算　　期　　：",null,null,"　年　　　月 ",null,null,"）",null,null,null,null,null,null,null,null,null,null,null,"百万円","工事進行基準"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：","百万円","、％）",null,null,"千円","完成・進行併用"]
["工　　期","発　注　者","工　　事　　名","請負金額","出　　来　　高",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月以前","2月","3月",null,"計","4月","5月","6月","7月","8月","9月以降","予定日","計","1月以前","2月","3月","計","4月","5月","6月以降","金　額","粗利率","銀　行","取扱番号","金　額"]
["～",null,null,null,null,null,{"$f":"IF(D6=\"\",\"\",D6*F6%)","v":""},{"$f":"IF(D6=\"\",\"\",SUM(I6:K6))","v":""},null,null,null,{"$f":"IF(D6=\"\",\"\",G6-H6)","v":""},{"$f":"IF(D6=\"\",\"\",D6-H6)","v":""},null,null,null,null,null,{"$f":"IF(D6=\"\",\"\",M6-SUM(N6:R6))","v":""},null,{"$f":"IF(D6=\"\",\"\",SUM(V6:X6))","v":""},null,null,null,{"$f":"IF(D6=\"\",\"\",SUM(Z6:AB6))","v":""},null,null,null,{"$f":"IF(D6=\"\",\"\",D6-U6-Y6)","v":""},{"$f":"IF(D6=\"\",\"\",AC6/D6*100)","v":""},null,null,null,{"$f":"IF(D6>0,1,0)","v":0},{"$f":"IF(M6=0,0,1)","v":1},{"$f":"IF(F6=100,1,0)","v":0},{"$f":"IF(F6<100,1,0)","v":1},{"$f":"IF(AJ6=1,TRUE,FALSE)","v":false}]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,{"$f":"IF(D12=\"\",\"\",D12*F12%)","v":""},{"$f":"IF(D12=\"\",\"\",SUM(I12:K12))","v":""},null,null,null,{"$f":"IF(D12=\"\",\"\",G12-H12)","v":""},{"$f":"IF(D12=\"\",\"\",D12-H12)","v":""},null,null,null,null,null,{"$f":"IF(D12=\"\",\"\",M12-SUM(N12:R12))","v":""},null,{"$f":"IF(D12=\"\",\"\",SUM(V12:X12))","v":""},null,null,null,{"$f":"IF(D12=\"\",\"\",SUM(Z12:AB12))","v":""},null,null,null,{"$f":"IF(D12=\"\",\"\",D12-U12-Y12)","v":""},{"$f":"IF(D12=\"\",\"\",AC12/D12*100)","v":""},null,null,null,{"$f":"IF(D12>0,1,0)","v":0},{"$f":"IF(M12=0,0,1)","v":1},{"$f":"IF(F12=100,1,0)","v":0},{"$f":"IF(F12<100,1,0)","v":1},{"$f":"IF(AJ12=1,TRUE,FALSE)","v":false}]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["～",null,null,null,null,null,"","",null,null,null,"","",null,null,null,null,null,"",null,"",null,null,null,"",null,null,null,"","",null,null,null,0,1,0,1,false]
["取下げ未了工事計",null,null,{"$f":"SUMIF(AI:AI,1,D:D)","v":0},"－","－",{"$f":"SUMIF(AI:AI,1,G:G)","v":0},{"$f":"SUMIF(AI:AI,1,H:H)","v":0},{"$f":"SUMIF(AI:AI,1,I:I)","v":0},{"$f":"SUMIF(AI:AI,1,J:J)","v":0},{"$f":"SUMIF(AI:AI,1,K:K)","v":0},{"$f":"SUMIF(AI:AI,1,L:L)","v":0},{"$f":"SUMIF(AI:AI,1,M:M)","v":0},{"$f":"SUMIF(AI:AI,1,N:N)","v":0},{"$f":"SUMIF(AI:AI,1,O:O)","v":0},{"$f":"SUMIF(AI:AI,1,P:P)","v":0},{"$f":"SUMIF(AI:AI,1,Q:Q)","v":0},{"$f":"SUMIF(AI:AI,1,R:R)","v":0},{"$f":"SUMIF(AI:AI,1,S:S)","v":0},"――",{"$f":"SUMIF(AI:AI,1,U:U)","v":0},{"$f":"SUMIF(AI:AI,1,V:V)","v":0},{"$f":"SUMIF(AI:AI,1,W:W)","v":0},{"$f":"SUMIF(AI:AI,1,X:X)","v":0},{"$f":"SUMIF(AI:AI,1,Y:Y)","v":0},{"$f":"SUMIF(AI:AI,1,Z:Z)","v":0},{"$f":"SUMIF(AI:AI,1,AA:AA)","v":0},{"$f":"SUMIF(AI:AI,1,AB:AB)","v":0},{"$f":"SUMIF(AI:AI,1,AC:AC)","v":0},{"$f":"AC25/D25*100","v":{"$error":"#DIV/0!"}},"――","――",{"$f":"SUMIF(AI:AI,1,AG:AG)","v":0}]
["全工事合計",null,null,{"$f":"SUMIF(AH:AH,1,D:D)","v":0},"－","－",{"$f":"SUMIF(AH:AH,1,G:G)","v":0},{"$f":"SUMIF(AH:AH,1,H:H)","v":0},{"$f":"SUMIF(AH:AH,1,I:I)","v":0},{"$f":"SUMIF(AH:AH,1,J:J)","v":0},{"$f":"SUMIF(AH:AH,1,K:K)","v":0},{"$f":"SUMIF(AH:AH,1,L:L)","v":0},{"$f":"SUMIF(AH:AH,1,M:M)","v":0},{"$f":"SUMIF(AH:AH,1,N:N)","v":0},{"$f":"SUMIF(AH:AH,1,O:O)","v":0},{"$f":"SUMIF(AH:AH,1,P:P)","v":0},{"$f":"SUMIF(AH:AH,1,Q:Q)","v":0},{"$f":"SUMIF(AH:AH,1,R:R)","v":0},{"$f":"SUMIF(AH:AH,1,S:S)","v":0},"――",{"$f":"SUMIF(AH:AH,1,U:U)","v":0},{"$f":"SUMIF(AH:AH,1,V:V)","v":0},{"$f":"SUMIF(AH:AH,1,W:W)","v":0},{"$f":"SUMIF(AH:AH,1,X:X)","v":0},{"$f":"SUMIF(AH:AH,1,Y:Y)","v":0},{"$f":"SUMIF(AH:AH,1,Z:Z)","v":0},{"$f":"SUMIF(AH:AH,1,AA:AA)","v":0},{"$f":"SUMIF(AH:AH,1,AB:AB)","v":0},{"$f":"SUMIF(AH:AH,1,AC:AC)","v":0},{"$f":"AC26/D26*100","v":{"$error":"#DIV/0!"}},"――","――",{"$f":"SUMIF(AH:AH,1,AG:AG)","v":0}]
["うち完成工事計",null,null,{"$f":"SUMIF(AJ:AJ,1,D:D)","v":0},"－","－",{"$f":"SUMIF(AJ:AJ,1,G:G)","v":0},{"$f":"SUMIF(AJ:AJ,1,H:H)","v":0},{"$f":"SUMIF(AJ:AJ,1,I:I)","v":0},{"$f":"SUMIF(AJ:AJ,1,J:J)","v":0},{"$f":"SUMIF(AJ:AJ,1,K:K)","v":0},{"$f":"SUMIF(AJ:AJ,1,L:L)","v":0},{"$f":"SUMIF(AJ:AJ,1,M:M)","v":0},{"$f":"SUMIF(AJ:AJ,1,N:N)","v":0},{"$f":"SUMIF(AJ:AJ,1,O:O)","v":0},{"$f":"SUMIF(AJ:AJ,1,P:P)","v":0},{"$f":"SUMIF(AJ:AJ,1,Q:Q)","v":0},{"$f":"SUMIF(AJ:AJ,1,R:R)","v":0},{"$f":"SUMIF(AJ:AJ,1,S:S)","v":0},"――",{"$f":"SUMIF(AJ:AJ,1,U:U)","v":0},{"$f":"SUMIF(AJ:AJ,1,V:V)","v":0},{"$f":"SUMIF(AJ:AJ,1,W:W)","v":0},{"$f":"SUMIF(AJ:AJ,1,X:X)","v":0},{"$f":"SUMIF(AJ:AJ,1,Y:Y)","v":0},{"$f":"SUMIF(AJ:AJ,1,Z:Z)","v":0},{"$f":"SUMIF(AJ:AJ,1,AA:AA)","v":0},{"$f":"SUMIF(AJ:AJ,1,AB:AB)","v":0},{"$f":"SUMIF(AJ:AJ,1,AC:AC)","v":0},{"$f":"AC27/D27*100","v":{"$error":"#DIV/0!"}},"――","――",{"$f":"SUMIF(AJ:AJ,1,AG:AG)","v":0}]
["うち未成工事計",null,null,{"$f":"SUMIF(AK:AK,1,D:D)","v":0},"－","－",{"$f":"SUMIF(AK:AK,1,G:G)","v":0},{"$f":"SUMIF(AK:AK,1,H:H)","v":0},{"$f":"SUMIF(AK:AK,1,I:I)","v":0},{"$f":"SUMIF(AK:AK,1,J:J)","v":0},{"$f":"SUMIF(AK:AK,1,K:K)","v":0},{"$f":"SUMIF(AK:AK,1,L:L)","v":0},{"$f":"SUMIF(AK:AK,1,M:M)","v":0},{"$f":"SUMIF(AK:AK,1,N:N)","v":0},{"$f":"SUMIF(AK:AK,1,O:O)","v":0},{"$f":"SUMIF(AK:AK,1,P:P)","v":0},{"$f":"SUMIF(AK:AK,1,Q:Q)","v":0},{"$f":"SUMIF(AK:AK,1,R:R)","v":0},{"$f":"SUMIF(AK:AK,1,S:S)","v":0},"――",{"$f":"SUMIF(AK:AK,1,U:U)","v":0},{"$f":"SUMIF(AK:AK,1,V:V)","v":0},{"$f":"SUMIF(AK:AK,1,W:W)","v":0},{"$f":"SUMIF(AK:AK,1,X:X)","v":0},{"$f":"SUMIF(AK:AK,1,Y:Y)","v":0},{"$f":"SUMIF(AK:AK,1,Z:Z)","v":0},{"$f":"SUMIF(AK:AK,1,AA:AA)","v":0},{"$f":"SUMIF(AK:AK,1,AB:AB)","v":0},{"$f":"SUMIF(AK:AK,1,AC:AC)","v":0},{"$f":"AC28/D28*100","v":{"$error":"#DIV/0!"}},"――","――",{"$f":"SUMIF(AK:AK,1,AG:AG)","v":0}]