{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["利用方法","記入例","出来高内訳書"],"not_rendered":{"charts":0,"images":0,"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":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["出来高内訳書書式の利用方法(社内書式)"]
[]
[null,"１．様式について"]
[]
[null,null,"この出来内訳書は契約書(注文書発行済又は発行予定)の工事費等を請求するときに、必要に応じて"]
[null,null,"請求書に添付して下さい。"]
[]
[null,"２．様式の構成について"]
[]
[null,null,"出来高調書用紙は、提出用・控え用を兼ねています。"]
[]
[null,"３．記入方法について"]
[]
[null,null,"この出来高内訳書はマクロを使用しています。マクロを有効にしてお使い下さい。"]
[]
[null,null,"別紙「記入例」を参考にして作成して下さい。"]
[]
[null,null,"黄色のセルは手入力項目、水色のセルは自動計算項目です。"]
[null,null,"自動計算項目は上書き修正可です。必要に応じて数式を変更して下さい。"]
[null,null,"※ SUM等関数を使用したい場合は、シートの保護を解除してから使用して下さい。"]
[]
[null,null,"[契約金額]には注文書等の契約数量・金額を記入して下さい。"]
[]
[null,null,"[出来高金額]の[前回迄]には前月までの累計出来高を（初回の場合は入力不要）、[今回]には当"]
[null,null,"月分出来高を入力してください。[累計]は自動で計算されます。"]
[]
[null,null,"入力行が足りない場合は、最終行の次の行（２ページ目ならＡ２８セル、３ページ目ならＡ４８セル）を"]
[null,null,"選択して「ページ追加」ボタンをクリックして追加して下さい。"]
[]
[null,null,"追加したページが不要となった場合は「ページ削除」ボタンでページを削除して下さい。"]
[null,null,"ただし、「ページ削除」ボタンは２ページ目以降全ページを削除しますので、任意のページを削除"]
[null,null,"したい場合は、手動で削除して下さい。"]
[]
[null,null,"[データクリア]ボタンを押すと入力したデータがクリアされ、自動計算項目が初期状態に戻ります。"]

{"sheet":"記入例","index":1,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":false,"merged":[[22,14,22,15],[23,14,23,15],[24,14,24,15],[25,14,25,15],[26,14,26,15],[15,7,15,8],[20,7,20,8],[26,7,26,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[25,7,25,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[9,7,9,8],[4,9,4,18],[5,5,6,5],[6,14,6,15],[7,14,7,15],[5,11,5,12],[5,4,6,4],[4,4,4,8],[7,7,7,8],[8,7,8,8],[5,7,6,8],[0,1,0,5],[5,6,6,6],[0,6,0,7],[4,0,6,3],[5,9,5,10],[2,13,2,14],[8,14,8,15],[9,14,9,15],[10,14,10,15],[11,14,11,15],[5,13,5,16],[4,19,6,19],[5,17,5,18],[19,14,19,15],[20,14,20,15],[21,14,21,15],[13,14,13,15],[14,14,14,15],[15,14,15,15],[16,14,16,15],[17,14,17,15],[18,14,18,15],[12,14,12,15]]}
[null,"＊＊＊＊＊＊＊＊",null,null,null,null,"工　　事"]
[]
[null,null,null,null,null,null,"第",2,"回　工　事　出　来　高　内　訳　書　（",null,null,null,null,"Ｈ２７．８",null,"月分）"]
[]
["工　　事　　種　　別",null,null,null,"契約金額",null,null,null,null,"工事出来高",null,null,null,null,null,null,null,null,null,"備　　考"]
[null,null,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(F8=\"\",\"\",ROUND(F8*$G8,0))","v":""},null,null,{"$f":"IF(J8=\"\",\"\",ROUND($G8*J8,0))","v":""},null,{"$f":"IF(L8=\"\",\"\",ROUND($G8*L8,0))","v":""},{"$f":"SUM(J8,L8)","v":0},{"$f":"SUM(K8,M8)","v":0},null,{"$f":"IF(O8=0,0,O8/H8*100)","v":0},{"$f":"F8-N8","v":0},{"$f":"IF(H8=\"\",0,H8-O8)","v":0}]
[null,"道路土工",null,null,null,null,null,"",null,null,{"$f":"IF(J9=\"\",\"\",ROUND($G9*J9,0))","v":""},null,{"$f":"IF(L9=\"\",\"\",ROUND($G9*L9,0))","v":""},0,{"$f":"SUM(K9,M9)","v":0},null,{"$f":"IF(O9=0,0,O9/H9*100)","v":0},0,{"$f":"IF(H9=\"\",0,H9-O9)","v":0}]
[null,null,"掘削工",null,"㎥",1000,180,180000,null,300,54000,300,54000,600,{"$f":"SUM(K10,M10)","v":108000},null,{"$f":"IF(O10=0,0,O10/H10*100)","v":60},400,{"$f":"IF(H10=\"\",0,H10-O10)","v":72000}]
[null,null,"路体盛土工",null,"㎥",3500,120,420000,null,0,0,1000,120000,1000,{"$f":"SUM(K11,M11)","v":120000},null,{"$f":"IF(P11=0,0,P11/H11*100)","v":0},2500,{"$f":"IF(H11=\"\",0,H11-P11)","v":420000}]
[null,null,"　〃　土砂等積込・運搬",null,"㎥",2500,800,2000000,null,0,0,700,560000,700,560000,null,0,1800,2000000]
[null,null,"路床盛土工",null,"㎥",1500,180,270000,null,1000,180000,500,90000,1500,270000,null,0,0,270000]
[null,null,"　〃　土砂等積込・運搬",null,"㎥",1500,800,1200000,null,1000,800000,500,400000,1500,1200000,null,0,0,1200000]
[null,null,"法面整形工",null,"㎡",400,340,136000,null,0,0,0,0,0,0,null,0,400,136000]
[null,"舗装工",null,null,null,null,null,"",null,null,"",null,"",0,0,null,0,0,0]
[null,null,"アスファルト舗装工",null,null,null,null,"",null,null,"",null,"",0,0,null,0,0,0]
[null,null,null,"下層路盤","㎡",1800,1300,2340000,null,0,0,0,0,0,0,null,0,1800,2340000,"ＲＣ４０"]
[null,null,null,"路盤","㎡",250,800,200000,null,0,0,0,0,0,0,null,0,250,200000,"ＲＣ４０"]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,null,0,0,0]
["直接工事費計",null,null,null,null,null,null,{"$f":"SUM(H8:I20)","v":6746000},null,null,{"$f":"SUM(K8:K20)","v":1034000},null,{"$f":"SUM(M8:M20)","v":1224000},0,2258000,null,0,0,6746000]
["共通仮設費",null,null,null,null,null,null,{"$f":"H21*10%","v":674600},null,null,{"$f":"K21*10%","v":103400},null,{"$f":"M21*10%","v":122400},0,225800,null,0,0,674600]
["諸経費",null,null,null,null,null,null,379400,null,null,62600,null,53600,0,116200,null,0,0,379400]
["工事費計",null,null,null,null,null,null,{"$f":"SUM(H21:I23)","v":7800000},null,null,{"$f":"SUM(K21:K23)","v":1200000},null,{"$f":"SUM(M21:M23)","v":1400000},0,2600000,null,0,0,7800000]
[null,null,null,null,null,null,null,{"$f":"IF(F25=\"\",\"\",ROUND(F25*$G25,0))","v":""},null,null,{"$f":"IF(J25=\"\",\"\",ROUND($G25*J25,0))","v":""},null,{"$f":"IF(L25=\"\",\"\",ROUND($G25*L25,0))","v":""},0,{"$f":"SUM(K25,M25)","v":0},null,{"$f":"IF(O25=0,0,O25/H25*100)","v":0},0,{"$f":"IF(H25=\"\",0,H25-O25)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F26=\"\",\"\",ROUND(F26*$G26,0))","v":""},null,null,{"$f":"IF(J26=\"\",\"\",ROUND($G26*J26,0))","v":""},null,{"$f":"IF(L26=\"\",\"\",ROUND($G26*L26,0))","v":""},0,{"$f":"SUM(K26,M26)","v":0},null,{"$f":"IF(O26=0,0,O26/H26*100)","v":0},0,{"$f":"IF(H26=\"\",0,H26-O26)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F27=\"\",\"\",ROUND(F27*$G27,0))","v":""},null,null,{"$f":"IF(J27=\"\",\"\",ROUND($G27*J27,0))","v":""},null,{"$f":"IF(L27=\"\",\"\",ROUND($G27*L27,0))","v":""},0,{"$f":"SUM(K27,M27)","v":0},null,{"$f":"IF(O27=0,0,O27/H27*100)","v":0},0,{"$f":"IF(H27=\"\",0,H27-O27)","v":0}]

{"sheet":"出来高内訳書","index":2,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,7,26,8],[26,14,26,15],[24,14,24,15],[18,14,18,15],[19,7,19,8],[24,7,24,8],[21,14,21,15],[25,7,25,8],[25,14,25,15],[22,7,22,8],[22,14,22,15],[23,7,23,8],[23,14,23,15],[17,7,17,8],[17,14,17,15],[18,7,18,8],[21,7,21,8],[14,7,14,8],[14,14,14,15],[15,7,15,8],[15,14,15,15],[16,7,16,8],[16,14,16,15],[13,7,13,8],[13,14,13,15],[19,14,19,15],[20,7,20,8],[20,14,20,15],[10,7,10,8],[10,14,10,15],[11,7,11,8],[11,14,11,15],[12,7,12,8],[12,14,12,15],[7,7,7,8],[7,14,7,15],[8,7,8,8],[8,14,8,15],[9,7,9,8],[9,14,9,15],[4,19,6,19],[5,5,6,5],[5,6,6,6],[5,7,6,8],[5,9,5,10],[5,11,5,12],[5,13,5,16],[5,17,5,18],[6,14,6,15],[5,4,6,4],[4,4,4,8],[0,6,0,7],[2,13,2,14],[4,0,6,3],[4,9,4,18],[0,1,0,5]]}
[null,null,null,null,null,null,"工　　事"]
[]
[null,null,null,null,null,null,"第",null,"回　工　事　出　来　高　内　訳　書　（",null,null,null,null,null,null,"月分）"]
[]
["工　　事　　種　　別",null,null,null,"契約金額",null,null,null,null,"工事出来高",null,null,null,null,null,null,null,null,null,"備　　考"]
[null,null,null,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(F8=\"\",\"\",ROUND(F8*G8,0))","v":""},null,null,{"$f":"IF(J8=\"\",\"\",ROUND($G8*J8,0))","v":""},null,{"$f":"IF(L8=\"\",\"\",ROUND($G8*L8,0))","v":""},{"$f":"SUM(J8,L8)","v":0},{"$f":"SUM(K8,M8)","v":0},{"$f":"SUM(L8,N8)","v":0},{"$f":"IF(O8=0,0,O8/H8*100)","v":0},{"$f":"F8-N8","v":0},{"$f":"IF(H8=\"\",0,H8-O8)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F9=\"\",\"\",ROUND(F9*G9,0))","v":""},null,null,{"$f":"IF(J9=\"\",\"\",ROUND($G9*J9,0))","v":""},null,{"$f":"IF(L9=\"\",\"\",ROUND($G9*L9,0))","v":""},{"$f":"SUM(J9,L9)","v":0},{"$f":"SUM(K9,M9)","v":0},{"$f":"SUM(L9,N9)","v":0},{"$f":"IF(O9=0,0,O9/H9*100)","v":0},{"$f":"F9-N9","v":0},{"$f":"IF(H9=\"\",0,H9-O9)","v":0}]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,"",0,0,0,0,0,0]