{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["집계날짜","구분","거래선","협력업체)관리대장","매출계산서","매입_병합","계약현황","하도계약현황","(투입누계)Filter","(기성누계)Filter","자금집행","월)기성청구서"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":35,"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":1828,"n_cols":2,"rows_kept":1828,"cut":false,"hidden":false,"merged":[]}
["집계날짜","회계연도 이월 시, 아래로 추가하세요."]
["2020-01-01"]
["2020-01-02"]
["2020-01-03"]
["2020-01-04"]
["2020-01-05"]
["2020-01-06"]
["2020-01-07"]
["2020-01-08"]
["2020-01-09"]
["2020-01-10"]
["2020-01-11"]
["2020-01-12"]
["2020-01-13"]
["2020-01-14"]
["2020-01-15"]
["2020-01-16"]
["2020-01-17"]
["2020-01-18"]
["2020-01-19"]
["2020-01-20"]
["2020-01-21"]
["2020-01-22"]
["2020-01-23"]
["2020-01-24"]
["2020-01-25"]
["2020-01-26"]
["2020-01-27"]
["2020-01-28"]
["2020-01-29"]
["2020-01-30"]
["2020-01-31"]
["2020-02-01"]
["2020-02-02"]
["2020-02-03"]
["2020-02-04"]
["2020-02-05"]
["2020-02-06"]
["2020-02-07"]
["2020-02-08"]
["2020-02-09"]
["2020-02-10"]
["2020-02-11"]
["2020-02-12"]
["2020-02-13"]
["2020-02-14"]
["2020-02-15"]
["2020-02-16"]
["2020-02-17"]
["2020-02-18"]
["2020-02-19"]
["2020-02-20"]
["2020-02-21"]
["2020-02-22"]
["2020-02-23"]
["2020-02-24"]
["2020-02-25"]
["2020-02-26"]
["2020-02-27"]
["2020-02-28"]
["2020-02-29"]
["2020-03-01"]
["2020-03-02"]
["2020-03-03"]
["2020-03-04"]
["2020-03-05"]
["2020-03-06"]
["2020-03-07"]
["2020-03-08"]
["2020-03-09"]
["2020-03-10"]
["2020-03-11"]
["2020-03-12"]
["2020-03-13"]
["2020-03-14"]
["2020-03-15"]
["2020-03-16"]
["2020-03-17"]
["2020-03-18"]
["2020-03-19"]
["2020-03-20"]
["2020-03-21"]
["2020-03-22"]
["2020-03-23"]
["2020-03-24"]
["2020-03-25"]
["2020-03-26"]
["2020-03-27"]
["2020-03-28"]
["2020-03-29"]
["2020-03-30"]
["2020-03-31"]
["2020-04-01"]
["2020-04-02"]
["2020-04-03"]
["2020-04-04"]
["2020-04-05"]
["2020-04-06"]
["2020-04-07"]
["2020-04-08"]
["2020-04-09"]
["2020-04-10"]
["2020-04-11"]
["2020-04-12"]
["2020-04-13"]
["2020-04-14"]
["2020-04-15"]
["2020-04-16"]
["2020-04-17"]
["2020-04-18"]
["2020-04-19"]
["2020-04-20"]
["2020-04-21"]
["2020-04-22"]
["2020-04-23"]
["2020-04-24"]
["2020-04-25"]
["2020-04-26"]
["2020-04-27"]
["2020-04-28"]
["2020-04-29"]
["2020-04-30"]
["2020-05-01"]
["2020-05-02"]
["2020-05-03"]
["2020-05-04"]
["2020-05-05"]
["2020-05-06"]
["2020-05-07"]
["2020-05-08"]
["2020-05-09"]
["2020-05-10"]
["2020-05-11"]
["2020-05-12"]
["2020-05-13"]
["2020-05-14"]
["2020-05-15"]
["2020-05-16"]
["2020-05-17"]
["2020-05-18"]
["2020-05-19"]
["2020-05-20"]
["2020-05-21"]
["2020-05-22"]
["2020-05-23"]
["2020-05-24"]
["2020-05-25"]
["2020-05-26"]
["2020-05-27"]
["2020-05-28"]
["2020-05-29"]
["2020-05-30"]
["2020-05-31"]
["2020-06-01"]
["2020-06-02"]
["2020-06-03"]
["2020-06-04"]
["2020-06-05"]
["2020-06-06"]
["2020-06-07"]
["2020-06-08"]
["2020-06-09"]
["2020-06-10"]
["2020-06-11"]
["2020-06-12"]
["2020-06-13"]
["2020-06-14"]
["2020-06-15"]
["2020-06-16"]
["2020-06-17"]
["2020-06-18"]
["2020-06-19"]
["2020-06-20"]
["2020-06-21"]
["2020-06-22"]
["2020-06-23"]
["2020-06-24"]
["2020-06-25"]
["2020-06-26"]
["2020-06-27"]
["2020-06-28"]
["2020-06-29"]
["2020-06-30"]
["2020-07-01"]
["2020-07-02"]
["2020-07-03"]
["2020-07-04"]
["2020-07-05"]
["2020-07-06"]
["2020-07-07"]
["2020-07-08"]
["2020-07-09"]
["2020-07-10"]
["2020-07-11"]
["2020-07-12"]
["2020-07-13"]
["2020-07-14"]
["2020-07-15"]
["2020-07-16"]
["2020-07-17"]
["2020-07-18"]
["2020-07-19"]
["2020-07-20"]
["2020-07-21"]
["2020-07-22"]
["2020-07-23"]
["2020-07-24"]
["2020-07-25"]
["2020-07-26"]
["2020-07-27"]
["2020-07-28"]
["2020-07-29"]
["2020-07-30"]
["2020-07-31"]
["2020-08-01"]
["2020-08-02"]
["2020-08-03"]
["2020-08-04"]
["2020-08-05"]
["2020-08-06"]
["2020-08-07"]
["2020-08-08"]
["2020-08-09"]
["2020-08-10"]
["2020-08-11"]
["2020-08-12"]
["2020-08-13"]
["2020-08-14"]
["2020-08-15"]
["2020-08-16"]
["2020-08-17"]
["2020-08-18"]
["2020-08-19"]
["2020-08-20"]
["2020-08-21"]
["2020-08-22"]
["2020-08-23"]
["2020-08-24"]
["2020-08-25"]
["2020-08-26"]
["2020-08-27"]
["2020-08-28"]
["2020-08-29"]
["2020-08-30"]
["2020-08-31"]
["2020-09-01"]
["2020-09-02"]
["2020-09-03"]
["2020-09-04"]
["2020-09-05"]
["2020-09-06"]
["2020-09-07"]
["2020-09-08"]
["2020-09-09"]
["2020-09-10"]
["2020-09-11"]
["2020-09-12"]
["2020-09-13"]
["2020-09-14"]
["2020-09-15"]
["2020-09-16"]
["2020-09-17"]
["2020-09-18"]
["2020-09-19"]
["2020-09-20"]
["2020-09-21"]
["2020-09-22"]
["2020-09-23"]
["2020-09-24"]
["2020-09-25"]
["2020-09-26"]
["2020-09-27"]
["2020-09-28"]
["2020-09-29"]
["2020-09-30"]
["2020-10-01"]
["2020-10-02"]
["2020-10-03"]
["2020-10-04"]
["2020-10-05"]
["2020-10-06"]
["2020-10-07"]
["2020-10-08"]
["2020-10-09"]
["2020-10-10"]
["2020-10-11"]
["2020-10-12"]
["2020-10-13"]
["2020-10-14"]
["2020-10-15"]
["2020-10-16"]
["2020-10-17"]
["2020-10-18"]
["2020-10-19"]
["2020-10-20"]
["2020-10-21"]
["2020-10-22"]
["2020-10-23"]
["2020-10-24"]
["2020-10-25"]
["2020-10-26"]
["2020-10-27"]
["2020-10-28"]
["2020-10-29"]
["2020-10-30"]
["2020-10-31"]
["2020-11-01"]
["2020-11-02"]
["2020-11-03"]
["2020-11-04"]
["2020-11-05"]
["2020-11-06"]
["2020-11-07"]
["2020-11-08"]
["2020-11-09"]
["2020-11-10"]
["2020-11-11"]
["2020-11-12"]
["2020-11-13"]
["2020-11-14"]
["2020-11-15"]
["2020-11-16"]
["2020-11-17"]
["2020-11-18"]
["2020-11-19"]
["2020-11-20"]
["2020-11-21"]
["2020-11-22"]
["2020-11-23"]
["2020-11-24"]
["2020-11-25"]
["2020-11-26"]
["2020-11-27"]
["2020-11-28"]
["2020-11-29"]
["2020-11-30"]
["2020-12-01"]
["2020-12-02"]
["2020-12-03"]
["2020-12-04"]
["2020-12-05"]
["2020-12-06"]
["2020-12-07"]
["2020-12-08"]
["2020-12-09"]
["2020-12-10"]
["2020-12-11"]
["2020-12-12"]
["2020-12-13"]
["2020-12-14"]
["2020-12-15"]
["2020-12-16"]
["2020-12-17"]
["2020-12-18"]
["2020-12-19"]
["2020-12-20"]
["2020-12-21"]
["2020-12-22"]
["2020-12-23"]
["2020-12-24"]
["2020-12-25"]
["2020-12-26"]
["2020-12-27"]
["2020-12-28"]
["2020-12-29"]
["2020-12-30"]
["2020-12-31"]
["2021-01-01"]
["2021-01-02"]
["2021-01-03"]
["2021-01-04"]
["2021-01-05"]
["2021-01-06"]
["2021-01-07"]
["2021-01-08"]
["2021-01-09"]
["2021-01-10"]
["2021-01-11"]
["2021-01-12"]
["2021-01-13"]
["2021-01-14"]
["2021-01-15"]
["2021-01-16"]
["2021-01-17"]
["2021-01-18"]
["2021-01-19"]
["2021-01-20"]
["2021-01-21"]
["2021-01-22"]
["2021-01-23"]
["2021-01-24"]
["2021-01-25"]
["2021-01-26"]
["2021-01-27"]
["2021-01-28"]
["2021-01-29"]
["2021-01-30"]
["2021-01-31"]
["2021-02-01"]
["2021-02-02"]
["2021-02-03"]
["2021-02-04"]
["2021-02-05"]
["2021-02-06"]
["2021-02-07"]
["2021-02-08"]
["2021-02-09"]
["2021-02-10"]
["2021-02-11"]
["2021-02-12"]
["2021-02-13"]
["2021-02-14"]
["2021-02-15"]
["2021-02-16"]
["2021-02-17"]
["2021-02-18"]
["2021-02-19"]
["2021-02-20"]
["2021-02-21"]
["2021-02-22"]
["2021-02-23"]
["2021-02-24"]
["2021-02-25"]
["2021-02-26"]
["2021-02-27"]
["2021-02-28"]
["2021-03-01"]
["2021-03-02"]
["2021-03-03"]
["2021-03-04"]
["2021-03-05"]
["2021-03-06"]
["2021-03-07"]
["2021-03-08"]
["2021-03-09"]
["2021-03-10"]
["2021-03-11"]
["2021-03-12"]
["2021-03-13"]
["2021-03-14"]
["2021-03-15"]
["2021-03-16"]
["2021-03-17"]
["2021-03-18"]
["2021-03-19"]
["2021-03-20"]
["2021-03-21"]
["2021-03-22"]
["2021-03-23"]
["2021-03-24"]
["2021-03-25"]
["2021-03-26"]
["2021-03-27"]
["2021-03-28"]
["2021-03-29"]
["2021-03-30"]
["2021-03-31"]
["2021-04-01"]
["2021-04-02"]
["2021-04-03"]
["2021-04-04"]
["2021-04-05"]
["2021-04-06"]
["2021-04-07"]
["2021-04-08"]
["2021-04-09"]
["2021-04-10"]
["2021-04-11"]
["2021-04-12"]
["2021-04-13"]
["2021-04-14"]
["2021-04-15"]
["2021-04-16"]
["2021-04-17"]
["2021-04-18"]
["2021-04-19"]
["2021-04-20"]
["2021-04-21"]
["2021-04-22"]
["2021-04-23"]
["2021-04-24"]
["2021-04-25"]
["2021-04-26"]
["2021-04-27"]
["2021-04-28"]
["2021-04-29"]
["2021-04-30"]
["2021-05-01"]
["2021-05-02"]
["2021-05-03"]
["2021-05-04"]
["2021-05-05"]
["2021-05-06"]
["2021-05-07"]
["2021-05-08"]
["2021-05-09"]
["2021-05-10"]
["2021-05-11"]
["2021-05-12"]
["2021-05-13"]
["2021-05-14"]
["2021-05-15"]
["2021-05-16"]
["2021-05-17"]
["2021-05-18"]
["2021-05-19"]
["2021-05-20"]
["2021-05-21"]
["2021-05-22"]
["2021-05-23"]
["2021-05-24"]
["2021-05-25"]
["2021-05-26"]
["2021-05-27"]
["2021-05-28"]
["2021-05-29"]
["2021-05-30"]
["2021-05-31"]
["2021-06-01"]
["2021-06-02"]
["2021-06-03"]
["2021-06-04"]
["2021-06-05"]
["2021-06-06"]
["2021-06-07"]
["2021-06-08"]
["2021-06-09"]
["2021-06-10"]
["2021-06-11"]
["2021-06-12"]
["2021-06-13"]
["2021-06-14"]
["2021-06-15"]
["2021-06-16"]
["2021-06-17"]
["2021-06-18"]
["2021-06-19"]
["2021-06-20"]
["2021-06-21"]
["2021-06-22"]
["2021-06-23"]
["2021-06-24"]
["2021-06-25"]
["2021-06-26"]
["2021-06-27"]
["2021-06-28"]
["2021-06-29"]
["2021-06-30"]
["2021-07-01"]
["2021-07-02"]
["2021-07-03"]
["2021-07-04"]
["2021-07-05"]
["2021-07-06"]
["2021-07-07"]
["2021-07-08"]
["2021-07-09"]
["2021-07-10"]
["2021-07-11"]
["2021-07-12"]
["2021-07-13"]
["2021-07-14"]
["2021-07-15"]
["2021-07-16"]
["2021-07-17"]
["2021-07-18"]
["2021-07-19"]
["2021-07-20"]
["2021-07-21"]
["2021-07-22"]
["2021-07-23"]
["2021-07-24"]
["2021-07-25"]
["2021-07-26"]
["2021-07-27"]
["2021-07-28"]
["2021-07-29"]
["2021-07-30"]
["2021-07-31"]
["2021-08-01"]
["2021-08-02"]
["2021-08-03"]
["2021-08-04"]
["2021-08-05"]
["2021-08-06"]
["2021-08-07"]
["2021-08-08"]
["2021-08-09"]
["2021-08-10"]
["2021-08-11"]
["2021-08-12"]
["2021-08-13"]
["2021-08-14"]
["2021-08-15"]
["2021-08-16"]
["2021-08-17"]
["2021-08-18"]
["2021-08-19"]
["2021-08-20"]
["2021-08-21"]
["2021-08-22"]
["2021-08-23"]
["2021-08-24"]
["2021-08-25"]
["2021-08-26"]
["2021-08-27"]
["2021-08-28"]
["2021-08-29"]
["2021-08-30"]
["2021-08-31"]
["2021-09-01"]
["2021-09-02"]
["2021-09-03"]
["2021-09-04"]
["2021-09-05"]
["2021-09-06"]
["2021-09-07"]
["2021-09-08"]
["2021-09-09"]
["2021-09-10"]
["2021-09-11"]
["2021-09-12"]
["2021-09-13"]
["2021-09-14"]
["2021-09-15"]
["2021-09-16"]
["2021-09-17"]
["2021-09-18"]
["2021-09-19"]
["2021-09-20"]
["2021-09-21"]
["2021-09-22"]
["2021-09-23"]
["2021-09-24"]
["2021-09-25"]
["2021-09-26"]
["2021-09-27"]
["2021-09-28"]
["2021-09-29"]
["2021-09-30"]
["2021-10-01"]
["2021-10-02"]
["2021-10-03"]
["2021-10-04"]
["2021-10-05"]
["2021-10-06"]
["2021-10-07"]
["2021-10-08"]
["2021-10-09"]
["2021-10-10"]
["2021-10-11"]
["2021-10-12"]
["2021-10-13"]
["2021-10-14"]
["2021-10-15"]
["2021-10-16"]
["2021-10-17"]
["2021-10-18"]
["2021-10-19"]
["2021-10-20"]
["2021-10-21"]
["2021-10-22"]
["2021-10-23"]
["2021-10-24"]
["2021-10-25"]
["2021-10-26"]
["2021-10-27"]
["2021-10-28"]
["2021-10-29"]
["2021-10-30"]
["2021-10-31"]
["2021-11-01"]
["2021-11-02"]
["2021-11-03"]
["2021-11-04"]
["2021-11-05"]
["2021-11-06"]
["2021-11-07"]
["2021-11-08"]
["2021-11-09"]
["2021-11-10"]
["2021-11-11"]
["2021-11-12"]
["2021-11-13"]
["2021-11-14"]
["2021-11-15"]
["2021-11-16"]
["2021-11-17"]
["2021-11-18"]
["2021-11-19"]
["2021-11-20"]
["2021-11-21"]
["2021-11-22"]
["2021-11-23"]
["2021-11-24"]
["2021-11-25"]
["2021-11-26"]
["2021-11-27"]
["2021-11-28"]
["2021-11-29"]
["2021-11-30"]
["2021-12-01"]
["2021-12-02"]
["2021-12-03"]
["2021-12-04"]
["2021-12-05"]
["2021-12-06"]
["2021-12-07"]
["2021-12-08"]
["2021-12-09"]
["2021-12-10"]
["2021-12-11"]
["2021-12-12"]
["2021-12-13"]
["2021-12-14"]
["2021-12-15"]
["2021-12-16"]
["2021-12-17"]
["2021-12-18"]
["2021-12-19"]
["2021-12-20"]
["2021-12-21"]
["2021-12-22"]
["2021-12-23"]
["2021-12-24"]
["2021-12-25"]
["2021-12-26"]
["2021-12-27"]
["2021-12-28"]
["2021-12-29"]
["2021-12-30"]
["2021-12-31"]
["2022-01-01"]
["2022-01-02"]
["2022-01-03"]
["2022-01-04"]
["2022-01-05"]
["2022-01-06"]
["2022-01-07"]
["2022-01-08"]
["2022-01-09"]
["2022-01-10"]
["2022-01-11"]
["2022-01-12"]
["2022-01-13"]
["2022-01-14"]
["2022-01-15"]
["2022-01-16"]
["2022-01-17"]
["2022-01-18"]
["2022-01-19"]
["2022-01-20"]
["2022-01-21"]
["2022-01-22"]
["2022-01-23"]
["2022-01-24"]
["2022-01-25"]
["2022-01-26"]
["2022-01-27"]
["2022-01-28"]
["2022-01-29"]
["2022-01-30"]
["2022-01-31"]
["2022-02-01"]
["2022-02-02"]
["2022-02-03"]
["2022-02-04"]
["2022-02-05"]
["2022-02-06"]
["2022-02-07"]
["2022-02-08"]
["2022-02-09"]
["2022-02-10"]
["2022-02-11"]
["2022-02-12"]
["2022-02-13"]
["2022-02-14"]
["2022-02-15"]
["2022-02-16"]
["2022-02-17"]
["2022-02-18"]
["2022-02-19"]
["2022-02-20"]
["2022-02-21"]
["2022-02-22"]
["2022-02-23"]
["2022-02-24"]
["2022-02-25"]
["2022-02-26"]
["2022-02-27"]
["2022-02-28"]
["2022-03-01"]
["2022-03-02"]
["2022-03-03"]
["2022-03-04"]
["2022-03-05"]
["2022-03-06"]
["2022-03-07"]
["2022-03-08"]
["2022-03-09"]
["2022-03-10"]
["2022-03-11"]
["2022-03-12"]
["2022-03-13"]
["2022-03-14"]
["2022-03-15"]
["2022-03-16"]
["2022-03-17"]
["2022-03-18"]
["2022-03-19"]
["2022-03-20"]
["2022-03-21"]
["2022-03-22"]
["2022-03-23"]
["2022-03-24"]
["2022-03-25"]
["2022-03-26"]
["2022-03-27"]
["2022-03-28"]
["2022-03-29"]
["2022-03-30"]
["2022-03-31"]
["2022-04-01"]
["2022-04-02"]
["2022-04-03"]
["2022-04-04"]
["2022-04-05"]
["2022-04-06"]
["2022-04-07"]
["2022-04-08"]
["2022-04-09"]
["2022-04-10"]
["2022-04-11"]
["2022-04-12"]
["2022-04-13"]
["2022-04-14"]
["2022-04-15"]
["2022-04-16"]
["2022-04-17"]
["2022-04-18"]
["2022-04-19"]
["2022-04-20"]
["2022-04-21"]
["2022-04-22"]
["2022-04-23"]
["2022-04-24"]
["2022-04-25"]
["2022-04-26"]
["2022-04-27"]
["2022-04-28"]
["2022-04-29"]
["2022-04-30"]
["2022-05-01"]
["2022-05-02"]
["2022-05-03"]
["2022-05-04"]
["2022-05-05"]
["2022-05-06"]
["2022-05-07"]
["2022-05-08"]
["2022-05-09"]
["2022-05-10"]
["2022-05-11"]
["2022-05-12"]
["2022-05-13"]
["2022-05-14"]
["2022-05-15"]
["2022-05-16"]
["2022-05-17"]
["2022-05-18"]
["2022-05-19"]
["2022-05-20"]
["2022-05-21"]
["2022-05-22"]
["2022-05-23"]
["2022-05-24"]
["2022-05-25"]
["2022-05-26"]
["2022-05-27"]
["2022-05-28"]
["2022-05-29"]
["2022-05-30"]
["2022-05-31"]
["2022-06-01"]
["2022-06-02"]
["2022-06-03"]
["2022-06-04"]
["2022-06-05"]
["2022-06-06"]
["2022-06-07"]
["2022-06-08"]
["2022-06-09"]
["2022-06-10"]
["2022-06-11"]
["2022-06-12"]
["2022-06-13"]
["2022-06-14"]
["2022-06-15"]
["2022-06-16"]
["2022-06-17"]
["2022-06-18"]
["2022-06-19"]
["2022-06-20"]
["2022-06-21"]
["2022-06-22"]
["2022-06-23"]
["2022-06-24"]
["2022-06-25"]
["2022-06-26"]
["2022-06-27"]
["2022-06-28"]
["2022-06-29"]
["2022-06-30"]
["2022-07-01"]
["2022-07-02"]
["2022-07-03"]
["2022-07-04"]
["2022-07-05"]
["2022-07-06"]
["2022-07-07"]
["2022-07-08"]
["2022-07-09"]
["2022-07-10"]
["2022-07-11"]
["2022-07-12"]
["2022-07-13"]
["2022-07-14"]
["2022-07-15"]
["2022-07-16"]
["2022-07-17"]
["2022-07-18"]
["2022-07-19"]
["2022-07-20"]
["2022-07-21"]
["2022-07-22"]
["2022-07-23"]
["2022-07-24"]
["2022-07-25"]
["2022-07-26"]
["2022-07-27"]
["2022-07-28"]
["2022-07-29"]
["2022-07-30"]
["2022-07-31"]
["2022-08-01"]
["2022-08-02"]
["2022-08-03"]
["2022-08-04"]
["2022-08-05"]
["2022-08-06"]
["2022-08-07"]
["2022-08-08"]
["2022-08-09"]
["2022-08-10"]
["2022-08-11"]
["2022-08-12"]
["2022-08-13"]
["2022-08-14"]
["2022-08-15"]
["2022-08-16"]
["2022-08-17"]
["2022-08-18"]
["2022-08-19"]
["2022-08-20"]
["2022-08-21"]
["2022-08-22"]
["2022-08-23"]
["2022-08-24"]
["2022-08-25"]
["2022-08-26"]
["2022-08-27"]
["2022-08-28"]
["2022-08-29"]
["2022-08-30"]
["2022-08-31"]
["2022-09-01"]
["2022-09-02"]
["2022-09-03"]
["2022-09-04"]
["2022-09-05"]
["2022-09-06"]
["2022-09-07"]
["2022-09-08"]
["2022-09-09"]
["2022-09-10"]
["2022-09-11"]
["2022-09-12"]
["2022-09-13"]
["2022-09-14"]
["2022-09-15"]
["2022-09-16"]
["2022-09-17"]
["2022-09-18"]
["2022-09-19"]
["2022-09-20"]
["2022-09-21"]
["2022-09-22"]
["2022-09-23"]
["2022-09-24"]
["2022-09-25"]
["2022-09-26"]
["2022-09-27"]
["2022-09-28"]
["2022-09-29"]
["2022-09-30"]
["2022-10-01"]
["2022-10-02"]
["2022-10-03"]
["2022-10-04"]
["2022-10-05"]
["2022-10-06"]
["2022-10-07"]
["2022-10-08"]
["2022-10-09"]
["2022-10-10"]
["2022-10-11"]
["2022-10-12"]
["2022-10-13"]
["2022-10-14"]
["2022-10-15"]
["2022-10-16"]
["2022-10-17"]
["2022-10-18"]
["2022-10-19"]
["2022-10-20"]
["2022-10-21"]
["2022-10-22"]
["2022-10-23"]
["2022-10-24"]
["2022-10-25"]
["2022-10-26"]
["2022-10-27"]
["2022-10-28"]
["2022-10-29"]
["2022-10-30"]
["2022-10-31"]
["2022-11-01"]
["2022-11-02"]
["2022-11-03"]
["2022-11-04"]
["2022-11-05"]
["2022-11-06"]
["2022-11-07"]
["2022-11-08"]
["2022-11-09"]
["2022-11-10"]
["2022-11-11"]
["2022-11-12"]
["2022-11-13"]
["2022-11-14"]
["2022-11-15"]
["2022-11-16"]
["2022-11-17"]
["2022-11-18"]
["2022-11-19"]
["2022-11-20"]
["2022-11-21"]
["2022-11-22"]
["2022-11-23"]
["2022-11-24"]
["2022-11-25"]
["2022-11-26"]
["2022-11-27"]
["2022-11-28"]
["2022-11-29"]
["2022-11-30"]
["2022-12-01"]
["2022-12-02"]
["2022-12-03"]
["2022-12-04"]
["2022-12-05"]
["2022-12-06"]
["2022-12-07"]
["2022-12-08"]
["2022-12-09"]
["2022-12-10"]
["2022-12-11"]
["2022-12-12"]
["2022-12-13"]
["2022-12-14"]
["2022-12-15"]
["2022-12-16"]
["2022-12-17"]
["2022-12-18"]
["2022-12-19"]
["2022-12-20"]
["2022-12-21"]
["2022-12-22"]
["2022-12-23"]
["2022-12-24"]
["2022-12-25"]
["2022-12-26"]
["2022-12-27"]
["2022-12-28"]
["2022-12-29"]
["2022-12-30"]
["2022-12-31"]
["2023-01-01"]
["2023-01-02"]
["2023-01-03"]
["2023-01-04"]
["2023-01-05"]
["2023-01-06"]
["2023-01-07"]
["2023-01-08"]
["2023-01-09"]
["2023-01-10"]
["2023-01-11"]
["2023-01-12"]
["2023-01-13"]
["2023-01-14"]
["2023-01-15"]
["2023-01-16"]
["2023-01-17"]
["2023-01-18"]
["2023-01-19"]
["2023-01-20"]
["2023-01-21"]
["2023-01-22"]
["2023-01-23"]
["2023-01-24"]
["2023-01-25"]
["2023-01-26"]
["2023-01-27"]
["2023-01-28"]
["2023-01-29"]
["2023-01-30"]
["2023-01-31"]
["2023-02-01"]
["2023-02-02"]
["2023-02-03"]
["2023-02-04"]
["2023-02-05"]
["2023-02-06"]
["2023-02-07"]
["2023-02-08"]
["2023-02-09"]
["2023-02-10"]
["2023-02-11"]
["2023-02-12"]
["2023-02-13"]
["2023-02-14"]
["2023-02-15"]
["2023-02-16"]
["2023-02-17"]
["2023-02-18"]
["2023-02-19"]
["2023-02-20"]
["2023-02-21"]
["2023-02-22"]
["2023-02-23"]
["2023-02-24"]
["2023-02-25"]
["2023-02-26"]
["2023-02-27"]
["2023-02-28"]
["2023-03-01"]
["2023-03-02"]
["2023-03-03"]
["2023-03-04"]
["2023-03-05"]
["2023-03-06"]
["2023-03-07"]
["2023-03-08"]
["2023-03-09"]
["2023-03-10"]
["2023-03-11"]
["2023-03-12"]
["2023-03-13"]
["2023-03-14"]
["2023-03-15"]
["2023-03-16"]
["2023-03-17"]
["2023-03-18"]
["2023-03-19"]
["2023-03-20"]
["2023-03-21"]
["2023-03-22"]
["2023-03-23"]
["2023-03-24"]
["2023-03-25"]
["2023-03-26"]
["2023-03-27"]
["2023-03-28"]
["2023-03-29"]
["2023-03-30"]
["2023-03-31"]
["2023-04-01"]
["2023-04-02"]
["2023-04-03"]
["2023-04-04"]
["2023-04-05"]
["2023-04-06"]
["2023-04-07"]
["2023-04-08"]
["2023-04-09"]
["2023-04-10"]
["2023-04-11"]
["2023-04-12"]
["2023-04-13"]
["2023-04-14"]
["2023-04-15"]
["2023-04-16"]
["2023-04-17"]
["2023-04-18"]
["2023-04-19"]
["2023-04-20"]
["2023-04-21"]
["2023-04-22"]
["2023-04-23"]
["2023-04-24"]
["2023-04-25"]
["2023-04-26"]
["2023-04-27"]
["2023-04-28"]
["2023-04-29"]
["2023-04-30"]
["2023-05-01"]
["2023-05-02"]
["2023-05-03"]
["2023-05-04"]
["2023-05-05"]
["2023-05-06"]
["2023-05-07"]
["2023-05-08"]
["2023-05-09"]
["2023-05-10"]
["2023-05-11"]
["2023-05-12"]
["2023-05-13"]
["2023-05-14"]
["2023-05-15"]
["2023-05-16"]
["2023-05-17"]
["2023-05-18"]
["2023-05-19"]
["2023-05-20"]
["2023-05-21"]
["2023-05-22"]
["2023-05-23"]
["2023-05-24"]
["2023-05-25"]
["2023-05-26"]
["2023-05-27"]
["2023-05-28"]
["2023-05-29"]
["2023-05-30"]
["2023-05-31"]
["2023-06-01"]
["2023-06-02"]
["2023-06-03"]
["2023-06-04"]
["2023-06-05"]
["2023-06-06"]
["2023-06-07"]
["2023-06-08"]
["2023-06-09"]
["2023-06-10"]
["2023-06-11"]
["2023-06-12"]
["2023-06-13"]
["2023-06-14"]
["2023-06-15"]
["2023-06-16"]
["2023-06-17"]
["2023-06-18"]
["2023-06-19"]
["2023-06-20"]
["2023-06-21"]
["2023-06-22"]
["2023-06-23"]
["2023-06-24"]
["2023-06-25"]
["2023-06-26"]
["2023-06-27"]
["2023-06-28"]
["2023-06-29"]
["2023-06-30"]
["2023-07-01"]
["2023-07-02"]
["2023-07-03"]
["2023-07-04"]
["2023-07-05"]
["2023-07-06"]
["2023-07-07"]
["2023-07-08"]
["2023-07-09"]
["2023-07-10"]
["2023-07-11"]
["2023-07-12"]
["2023-07-13"]
["2023-07-14"]
["2023-07-15"]
["2023-07-16"]
["2023-07-17"]
["2023-07-18"]
["2023-07-19"]
["2023-07-20"]
["2023-07-21"]
["2023-07-22"]
["2023-07-23"]
["2023-07-24"]
["2023-07-25"]
["2023-07-26"]
["2023-07-27"]
["2023-07-28"]
["2023-07-29"]
["2023-07-30"]
["2023-07-31"]
["2023-08-01"]
["2023-08-02"]
["2023-08-03"]
["2023-08-04"]
["2023-08-05"]
["2023-08-06"]
["2023-08-07"]
["2023-08-08"]
["2023-08-09"]
["2023-08-10"]
["2023-08-11"]
["2023-08-12"]
["2023-08-13"]
["2023-08-14"]
["2023-08-15"]
["2023-08-16"]
["2023-08-17"]
["2023-08-18"]
["2023-08-19"]
["2023-08-20"]
["2023-08-21"]
["2023-08-22"]
["2023-08-23"]
["2023-08-24"]
["2023-08-25"]
["2023-08-26"]
["2023-08-27"]
["2023-08-28"]
["2023-08-29"]
["2023-08-30"]
["2023-08-31"]
["2023-09-01"]
["2023-09-02"]
["2023-09-03"]
["2023-09-04"]
["2023-09-05"]
["2023-09-06"]
["2023-09-07"]
["2023-09-08"]
["2023-09-09"]
["2023-09-10"]
["2023-09-11"]
["2023-09-12"]
["2023-09-13"]
["2023-09-14"]
["2023-09-15"]
["2023-09-16"]
["2023-09-17"]
["2023-09-18"]
["2023-09-19"]
["2023-09-20"]
["2023-09-21"]
["2023-09-22"]
["2023-09-23"]
["2023-09-24"]
["2023-09-25"]
["2023-09-26"]
["2023-09-27"]
["2023-09-28"]
["2023-09-29"]
["2023-09-30"]
["2023-10-01"]
["2023-10-02"]
["2023-10-03"]
["2023-10-04"]
["2023-10-05"]
["2023-10-06"]
["2023-10-07"]
["2023-10-08"]
["2023-10-09"]
["2023-10-10"]
["2023-10-11"]
["2023-10-12"]
["2023-10-13"]
["2023-10-14"]
["2023-10-15"]
["2023-10-16"]
["2023-10-17"]
["2023-10-18"]
["2023-10-19"]
["2023-10-20"]
["2023-10-21"]
["2023-10-22"]
["2023-10-23"]
["2023-10-24"]
["2023-10-25"]
["2023-10-26"]
["2023-10-27"]
["2023-10-28"]
["2023-10-29"]
["2023-10-30"]
["2023-10-31"]
["2023-11-01"]
["2023-11-02"]
["2023-11-03"]
["2023-11-04"]
["2023-11-05"]
["2023-11-06"]
["2023-11-07"]
["2023-11-08"]
["2023-11-09"]
["2023-11-10"]
["2023-11-11"]
["2023-11-12"]
["2023-11-13"]
["2023-11-14"]
["2023-11-15"]
["2023-11-16"]
["2023-11-17"]
["2023-11-18"]
["2023-11-19"]
["2023-11-20"]
["2023-11-21"]
["2023-11-22"]
["2023-11-23"]
["2023-11-24"]
["2023-11-25"]
["2023-11-26"]
["2023-11-27"]
["2023-11-28"]
["2023-11-29"]
["2023-11-30"]
["2023-12-01"]
["2023-12-02"]
["2023-12-03"]
["2023-12-04"]
["2023-12-05"]
["2023-12-06"]
["2023-12-07"]
["2023-12-08"]
["2023-12-09"]
["2023-12-10"]
["2023-12-11"]
["2023-12-12"]
["2023-12-13"]
["2023-12-14"]
["2023-12-15"]
["2023-12-16"]
["2023-12-17"]
["2023-12-18"]
["2023-12-19"]
["2023-12-20"]
["2023-12-21"]
["2023-12-22"]
["2023-12-23"]
["2023-12-24"]
["2023-12-25"]
["2023-12-26"]
["2023-12-27"]
["2023-12-28"]
["2023-12-29"]
["2023-12-30"]
["2023-12-31"]
["2024-01-01"]
["2024-01-02"]
["2024-01-03"]
["2024-01-04"]
["2024-01-05"]
["2024-01-06"]
["2024-01-07"]
["2024-01-08"]
["2024-01-09"]
["2024-01-10"]
["2024-01-11"]
["2024-01-12"]
["2024-01-13"]
["2024-01-14"]
["2024-01-15"]
["2024-01-16"]
["2024-01-17"]
["2024-01-18"]
["2024-01-19"]
["2024-01-20"]
["2024-01-21"]
["2024-01-22"]
["2024-01-23"]
["2024-01-24"]
["2024-01-25"]
["2024-01-26"]
["2024-01-27"]
["2024-01-28"]
["2024-01-29"]
["2024-01-30"]
["2024-01-31"]
["2024-02-01"]
["2024-02-02"]
["2024-02-03"]
["2024-02-04"]
["2024-02-05"]
["2024-02-06"]
["2024-02-07"]
["2024-02-08"]
["2024-02-09"]
["2024-02-10"]
["2024-02-11"]
["2024-02-12"]
["2024-02-13"]
["2024-02-14"]
["2024-02-15"]
["2024-02-16"]
["2024-02-17"]
["2024-02-18"]
["2024-02-19"]
["2024-02-20"]
["2024-02-21"]
["2024-02-22"]
["2024-02-23"]
["2024-02-24"]
["2024-02-25"]
["2024-02-26"]
["2024-02-27"]
["2024-02-28"]
["2024-02-29"]
["2024-03-01"]
["2024-03-02"]
["2024-03-03"]
["2024-03-04"]
["2024-03-05"]
["2024-03-06"]
["2024-03-07"]
["2024-03-08"]
["2024-03-09"]
["2024-03-10"]
["2024-03-11"]
["2024-03-12"]
["2024-03-13"]
["2024-03-14"]
["2024-03-15"]
["2024-03-16"]
["2024-03-17"]
["2024-03-18"]
["2024-03-19"]
["2024-03-20"]
["2024-03-21"]
["2024-03-22"]
["2024-03-23"]
["2024-03-24"]
["2024-03-25"]
["2024-03-26"]
["2024-03-27"]
["2024-03-28"]
["2024-03-29"]
["2024-03-30"]
["2024-03-31"]
["2024-04-01"]
["2024-04-02"]
["2024-04-03"]
["2024-04-04"]
["2024-04-05"]
["2024-04-06"]
["2024-04-07"]
["2024-04-08"]
["2024-04-09"]
["2024-04-10"]
["2024-04-11"]
["2024-04-12"]
["2024-04-13"]
["2024-04-14"]
["2024-04-15"]
["2024-04-16"]
["2024-04-17"]
["2024-04-18"]
["2024-04-19"]
["2024-04-20"]
["2024-04-21"]
["2024-04-22"]
["2024-04-23"]
["2024-04-24"]
["2024-04-25"]
["2024-04-26"]
["2024-04-27"]
["2024-04-28"]
["2024-04-29"]
["2024-04-30"]
["2024-05-01"]
["2024-05-02"]
["2024-05-03"]
["2024-05-04"]
["2024-05-05"]
["2024-05-06"]
["2024-05-07"]
["2024-05-08"]
["2024-05-09"]
["2024-05-10"]
["2024-05-11"]
["2024-05-12"]
["2024-05-13"]
["2024-05-14"]
["2024-05-15"]
["2024-05-16"]
["2024-05-17"]
["2024-05-18"]
["2024-05-19"]
["2024-05-20"]
["2024-05-21"]
["2024-05-22"]
["2024-05-23"]
["2024-05-24"]
["2024-05-25"]
["2024-05-26"]
["2024-05-27"]
["2024-05-28"]
["2024-05-29"]
["2024-05-30"]
["2024-05-31"]
["2024-06-01"]
["2024-06-02"]
["2024-06-03"]
["2024-06-04"]
["2024-06-05"]
["2024-06-06"]
["2024-06-07"]
["2024-06-08"]
["2024-06-09"]
["2024-06-10"]
["2024-06-11"]
["2024-06-12"]
["2024-06-13"]
["2024-06-14"]
["2024-06-15"]
["2024-06-16"]
["2024-06-17"]
["2024-06-18"]
["2024-06-19"]
["2024-06-20"]
["2024-06-21"]
["2024-06-22"]
["2024-06-23"]
["2024-06-24"]
["2024-06-25"]
["2024-06-26"]
["2024-06-27"]
["2024-06-28"]
["2024-06-29"]
["2024-06-30"]
["2024-07-01"]
["2024-07-02"]
["2024-07-03"]
["2024-07-04"]
["2024-07-05"]
["2024-07-06"]
["2024-07-07"]
["2024-07-08"]
["2024-07-09"]
["2024-07-10"]
["2024-07-11"]
["2024-07-12"]
["2024-07-13"]
["2024-07-14"]
["2024-07-15"]
["2024-07-16"]
["2024-07-17"]
["2024-07-18"]
["2024-07-19"]
["2024-07-20"]
["2024-07-21"]
["2024-07-22"]
["2024-07-23"]
["2024-07-24"]
["2024-07-25"]
["2024-07-26"]
["2024-07-27"]
["2024-07-28"]
["2024-07-29"]
["2024-07-30"]
["2024-07-31"]
["2024-08-01"]
["2024-08-02"]
["2024-08-03"]
["2024-08-04"]
["2024-08-05"]
["2024-08-06"]
["2024-08-07"]
["2024-08-08"]
["2024-08-09"]
["2024-08-10"]
["2024-08-11"]
["2024-08-12"]
["2024-08-13"]
["2024-08-14"]
["2024-08-15"]
["2024-08-16"]
["2024-08-17"]
["2024-08-18"]
["2024-08-19"]
["2024-08-20"]
["2024-08-21"]
["2024-08-22"]
["2024-08-23"]
["2024-08-24"]
["2024-08-25"]
["2024-08-26"]
["2024-08-27"]
["2024-08-28"]
["2024-08-29"]
["2024-08-30"]
["2024-08-31"]
["2024-09-01"]
["2024-09-02"]
["2024-09-03"]
["2024-09-04"]
["2024-09-05"]
["2024-09-06"]
["2024-09-07"]
["2024-09-08"]
["2024-09-09"]
["2024-09-10"]
["2024-09-11"]
["2024-09-12"]
["2024-09-13"]
["2024-09-14"]
["2024-09-15"]
["2024-09-16"]
["2024-09-17"]
["2024-09-18"]
["2024-09-19"]
["2024-09-20"]
["2024-09-21"]
["2024-09-22"]
["2024-09-23"]
["2024-09-24"]
["2024-09-25"]
["2024-09-26"]
["2024-09-27"]
["2024-09-28"]
["2024-09-29"]
["2024-09-30"]
["2024-10-01"]
["2024-10-02"]
["2024-10-03"]
["2024-10-04"]
["2024-10-05"]
["2024-10-06"]
["2024-10-07"]
["2024-10-08"]
["2024-10-09"]
["2024-10-10"]
["2024-10-11"]
["2024-10-12"]
["2024-10-13"]
["2024-10-14"]
["2024-10-15"]
["2024-10-16"]
["2024-10-17"]
["2024-10-18"]
["2024-10-19"]
["2024-10-20"]
["2024-10-21"]
["2024-10-22"]
["2024-10-23"]
["2024-10-24"]
["2024-10-25"]
["2024-10-26"]
["2024-10-27"]
["2024-10-28"]
["2024-10-29"]
["2024-10-30"]
["2024-10-31"]
["2024-11-01"]
["2024-11-02"]
["2024-11-03"]
["2024-11-04"]
["2024-11-05"]
["2024-11-06"]
["2024-11-07"]
["2024-11-08"]
["2024-11-09"]
["2024-11-10"]
["2024-11-11"]
["2024-11-12"]
["2024-11-13"]
["2024-11-14"]
["2024-11-15"]
["2024-11-16"]
["2024-11-17"]
["2024-11-18"]
["2024-11-19"]
["2024-11-20"]
["2024-11-21"]
["2024-11-22"]
["2024-11-23"]
["2024-11-24"]
["2024-11-25"]
["2024-11-26"]
["2024-11-27"]
["2024-11-28"]
["2024-11-29"]
["2024-11-30"]
["2024-12-01"]
["2024-12-02"]
["2024-12-03"]
["2024-12-04"]
["2024-12-05"]
["2024-12-06"]
["2024-12-07"]
["2024-12-08"]
["2024-12-09"]
["2024-12-10"]
["2024-12-11"]
["2024-12-12"]
["2024-12-13"]
["2024-12-14"]
["2024-12-15"]
["2024-12-16"]
["2024-12-17"]
["2024-12-18"]
["2024-12-19"]
["2024-12-20"]
["2024-12-21"]
["2024-12-22"]
["2024-12-23"]
["2024-12-24"]
["2024-12-25"]
["2024-12-26"]
["2024-12-27"]
["2024-12-28"]
["2024-12-29"]
["2024-12-30"]
["2024-12-31"]

{"sheet":"구분","index":1,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"필터정렬기준","필터정렬기준_기성","오름내림","비용구분","대금구분","지급방법","투입월","회계연도 이월 시, 아래로 추가하세요."]
[null,"매입구분","작성일자","내림차순","재)공사원가(재료)","선급금","본사지급","2024년 1월"]
[null,"거래년도","매출년도","오름차순","노)공사원가(노무)","노무비(기성금)","하도급지킴이(직불)","2024년 2월"]
[null,"비용구분","공급받는자사업자등록번호",null,"간)공사원가(간접노무비)","기성금","지급보류","2024년 3월"]
[null,"투입월","상호",null,"외)공사원가(외주)","준공금",null,"2024년 4월"]
[null,"작성일자","상호수정",null,"장)공사원가(장비)",null,null,"2024년 5월"]
[null,"공급자사업자등록번호","대표자명",null,"경)공사원가(경비)",null,null,"2024년 6월"]
[null,"상호","거래처코드",null,"퇴)공사원가(퇴직공제)",null,null,"2024년 7월"]
[null,"대표자명","공사명",null,"보)공사원가(4대보험)",null,null,"2024년 8월"]
[null,"상호수정","공사코드",null,"안)공사원가(안전관리비)",null,null,"2024년 9월"]
[null,"성명","대금구분",null,"환)공사원가(환경보전비)",null,null,"2024년 10월"]
[null,"출생년월일","품목명",null,"증)공사원가(보증서)",null,null,"2024년 11월"]
[null,"거래처코드","합계금액",null,"판관비(본사)",null,null,"2024년 12월"]
[null,"출역공수","공급가액",null,"영업외비용(본사)"]
[null,"하도급공종","세액"]
[null,"품목명","기성청구방법"]
[null,"합계금액","기성청구일자"]
[null,"공급가액","(차감)직불노무비"]
[null,"세액","(차감)토공_하도급대금"]
[null,"적요","(차감)철콘_하도급대금)"]
[null,"공사명","(차감)기타_하도급대금"]
[null,null,"(차감)직불하도급대금"]
[null,null,"실입금예정액"]

{"sheet":"거래선","index":2,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"번호","구분","상호","거래처코드","대표자","사업자번호","주소","적요","담당자","휴대전화","전화번호","팩스번호","계산서발행메일","담당메일","은행","계좌번호"]
[null,{"$f":"ROW()-2","v":1},"매출","매출1",{"$f":"100+거래선[[#This Row],[번호]]","v":101},"매출1 대표"]
[null,{"$f":"ROW()-2","v":2},"매출","매출2",{"$f":"100+거래선[[#This Row],[번호]]","v":102},"매출2 대표"]
[null,3,"매출","매출3",{"$f":"100+거래선[[#This Row],[번호]]","v":103},"매출3 대표"]
[null,4,"매출","매출4",{"$f":"100+거래선[[#This Row],[번호]]","v":104},"매출4 대표"]
[null,5,"매입","매입1",{"$f":"100+거래선[[#This Row],[번호]]","v":105},"매입1 대표"]
[null,6,"매입","매입2",{"$f":"100+거래선[[#This Row],[번호]]","v":106},"매입2 대표"]
[null,7,"매입","매입3",{"$f":"100+거래선[[#This Row],[번호]]","v":107},"매입3 대표"]
[null,8,"매입","매입4",{"$f":"100+거래선[[#This Row],[번호]]","v":108},"매입4 대표"]

{"sheet":"협력업체)관리대장","index":3,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"하도실계약현황' 탭에서 관리코드만 가져와 수식 작성함"]
[null,"순번","관리코드","하도급공사번호","협력업체_등록일자","하도급공종","하도급명칭","하도급업체","계약일자"]

{"sheet":"매출계산서","index":4,"n_rows":8,"n_cols":26,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[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,"2020-1.xls",{"$f":"ROW()-4","v":1},{"$f":"YEAR(매출계산서[[#This Row],[작성일자]])&\"년 \"&MONTH(매출계산서[[#This Row],[작성일자]])&\"월\"","v":"2024년 1월"},"2024-01-01",null,null,null,"매출1",null,null,"공사1",null,null,"가",{"$f":"SUM(매출계산서[[#This Row],[공급가액]:[세액]])","v":1100},1000,{"$f":"ROUND(매출계산서[[#This Row],[공급가액]]*0.1,0)","v":100},null,null,null,null,null,null,null,{"$f":"매출계산서[[#This Row],[합계금액]]-매출계산서[[#This Row],[(차감)직불하도급대금]]","v":1100}]
[null,"2020-1.xls",{"$f":"ROW()-4","v":2},{"$f":"YEAR(매출계산서[[#This Row],[작성일자]])&\"년 \"&MONTH(매출계산서[[#This Row],[작성일자]])&\"월\"","v":"2024년 2월"},"2024-02-01",null,null,null,"매출2",null,null,"공사2",null,null,"나",{"$f":"SUM(매출계산서[[#This Row],[공급가액]:[세액]])","v":1101},1001,{"$f":"ROUND(매출계산서[[#This Row],[공급가액]]*0.1,0)","v":100},null,null,null,null,null,null,null,{"$f":"매출계산서[[#This Row],[합계금액]]-매출계산서[[#This Row],[(차감)직불하도급대금]]","v":1101}]
[null,"2020-1.xls",3,{"$f":"YEAR(매출계산서[[#This Row],[작성일자]])&\"년 \"&MONTH(매출계산서[[#This Row],[작성일자]])&\"월\"","v":"2024년 3월"},"2024-03-01",null,null,null,"매출3",null,null,"공사3",null,null,"다",{"$f":"SUM(매출계산서[[#This Row],[공급가액]:[세액]])","v":1102},1002,{"$f":"ROUND(매출계산서[[#This Row],[공급가액]]*0.1,0)","v":100},null,null,null,null,null,null,null,{"$f":"매출계산서[[#This Row],[합계금액]]-매출계산서[[#This Row],[(차감)직불하도급대금]]","v":1102}]
[null,"2020-1.xls",4,{"$f":"YEAR(매출계산서[[#This Row],[작성일자]])&\"년 \"&MONTH(매출계산서[[#This Row],[작성일자]])&\"월\"","v":"2024년 4월"},"2024-04-01",null,null,null,"매출4",null,null,"공사4",null,null,"라",{"$f":"SUM(매출계산서[[#This Row],[공급가액]:[세액]])","v":1103},1003,{"$f":"ROUND(매출계산서[[#This Row],[공급가액]]*0.1,0)","v":100},null,null,null,null,null,null,null,{"$f":"매출계산서[[#This Row],[합계금액]]-매출계산서[[#This Row],[(차감)직불하도급대금]]","v":1103}]

{"sheet":"매입_병합","index":5,"n_rows":8,"n_cols":28,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"인덱스_최종","매입기준","매입구분","거래년도","비용구분","투입월","작성일자","공급자사업자등록번호","상호","대표자명","상호수정","성명","출생년월일","거래처코드","출역공수","하도급공종","품목명","합계금액","공급가액","세액","적요","공사명","공사코드","품목비고","비고","카드번호","가맹점명/국가명(도시명)"]
[null,{"$f":"ROW()-4","v":1},null,null,{"$f":"YEAR(매입_병합[[#This Row],[작성일자]])","v":2024},"외)공사원가(외주)",{"$f":"YEAR(매입_병합[[#This Row],[작성일자]])&\"년 \"&MONTH(매입_병합[[#This Row],[작성일자]])&\"월\"","v":"2024년 1월"},"2024-01-01",null,"매입1",null,null,null,null,null,null,null,"매입1",{"$f":"SUM(매입_병합[[#This Row],[공급가액]:[세액]])","v":1100},1000,{"$f":"ROUND(매입_병합[[#This Row],[공급가액]]*0.1,0)","v":100}]
[null,{"$f":"ROW()-4","v":2},null,null,{"$f":"YEAR(매입_병합[[#This Row],[작성일자]])","v":2024},"재)공사원가(재료)",{"$f":"YEAR(매입_병합[[#This Row],[작성일자]])&\"년 \"&MONTH(매입_병합[[#This Row],[작성일자]])&\"월\"","v":"2024년 2월"},"2024-02-01",null,"매입2",null,null,null,null,null,null,null,"매입2",{"$f":"SUM(매입_병합[[#This Row],[공급가액]:[세액]])","v":1101},1001,{"$f":"ROUND(매입_병합[[#This Row],[공급가액]]*0.1,0)","v":100}]
[null,3,null,null,{"$f":"YEAR(매입_병합[[#This Row],[작성일자]])","v":2024},"장)공사원가(장비)",{"$f":"YEAR(매입_병합[[#This Row],[작성일자]])&\"년 \"&MONTH(매입_병합[[#This Row],[작성일자]])&\"월\"","v":"2024년 3월"},"2024-03-01",null,"매입3",null,null,null,null,null,null,null,"매입3",{"$f":"SUM(매입_병합[[#This Row],[공급가액]:[세액]])","v":1102},1002,{"$f":"ROUND(매입_병합[[#This Row],[공급가액]]*0.1,0)","v":100}]
[null,4,null,null,{"$f":"YEAR(매입_병합[[#This Row],[작성일자]])","v":2024},"재)공사원가(재료)",{"$f":"YEAR(매입_병합[[#This Row],[작성일자]])&\"년 \"&MONTH(매입_병합[[#This Row],[작성일자]])&\"월\"","v":"2024년 4월"},"2024-04-01",null,"매입4",null,null,null,null,null,null,null,"매입4",{"$f":"SUM(매입_병합[[#This Row],[공급가액]:[세액]])","v":1103},1003,{"$f":"ROUND(매입_병합[[#This Row],[공급가액]]*0.1,0)","v":100}]

{"sheet":"계약현황","index":6,"n_rows":14,"n_cols":26,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"번호","계약순번","공사명","공사코드","발주처","거래처코드","실적관리번호","최초계약일자","착수일자","완수일자","실준공일","금차계약금액","금차공급가계약","금차부가세계약","차액","산재","고용","건강","연금","장기요양","퇴직공제","건설기계대여보증","산업안전관리비","환경보전비","하도급대금지급보증"]
[null,{"$f":"ROW()-2","v":1},null,"공사1",{"$f":"600+실계약현황[[#This Row],[번호]]","v":601}]
[null,{"$f":"ROW()-2","v":2},null,"공사2",{"$f":"600+실계약현황[[#This Row],[번호]]","v":602}]
[null,3,null,"공사3",{"$f":"600+실계약현황[[#This Row],[번호]]","v":603}]
[null,4,null,"공사4",{"$f":"600+실계약현황[[#This Row],[번호]]","v":604}]
[null,5,null,"공사5",{"$f":"600+실계약현황[[#This Row],[번호]]","v":605}]
[null,6,null,"공사6",{"$f":"600+실계약현황[[#This Row],[번호]]","v":606}]
[null,7,null,"공사7",{"$f":"600+실계약현황[[#This Row],[번호]]","v":607}]
[null,8,null,"공사8",{"$f":"600+실계약현황[[#This Row],[번호]]","v":608}]
[null,9,null,"공사9",{"$f":"600+실계약현황[[#This Row],[번호]]","v":609}]
[null,10,null,"공사10",{"$f":"600+실계약현황[[#This Row],[번호]]","v":610}]
[null,11,null,"공사11",{"$f":"600+실계약현황[[#This Row],[번호]]","v":611}]
[null,12,null,"공사12",{"$f":"600+실계약현황[[#This Row],[번호]]","v":612}]

{"sheet":"하도계약현황","index":7,"n_rows":7,"n_cols":19,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"순번","관리코드","공사명","공사코드","하도급공종","하도급명칭","일련번호","하도급공사번호","계약구분","하도급업체","계약일자","착공일자","준공일자","정산/실준공일","계약금액","노무비","공급가","부가세"]
[null,{"$f":"ROW()-2","v":1}]
[null,{"$f":"ROW()-2","v":2}]
[null,3]
[null,4]
[null,5]

{"sheet":"(투입누계)Filter","index":8,"n_rows":13,"n_cols":25,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,18],[4,3,4,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,"본사 미포함시\n선택하세요.☞","#본사","간접노무비\n미포함시☞","간)공사원가(간접노무비)"]
[]
[null,"현 장 명",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SORT_기준1","SORT_기준2","SORT_기준3"]
[null,"매입년도",null,null,"투입월",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,{"$f":"IF(W6=1,-1,1)","v":1}]
[]
[null,"회사명: 완벽한 오피스",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(단위: 원)"]
[null,"매입구분","거래년도","비용구분","투입월","작성일자","공급자사업자등록번호","상호","대표자명","상호수정","성명","출생년월일","거래처코드","출역공수","하도급공종","품목명","합계금액","공급가액","세액","적요","공사명"]
[null,{"$f":"_xlfn._xlws.SORT(IF(D5<>\"\",_xlfn._xlws.FILTER(매입_병합[[매입구분]:[공사명]],ISNUMBER(SEARCH(D5,매입_병합[공사명]))*IF($D$6=\"\",매입_병합[작성일자]=매입_병합[작성일자],YEAR(매입_병합[작성일자])=$D$6)*IF($F$6=\"\",매입_병합[투입월]=매입_병합[투입월],매입_병합[투입월]=$F$6)*IF($Y$3=\"\",매입_병합[비용구분]=매입_병합[비용구분],매입_병합[비용구분]<>$Y$3)),_xlfn._xlws.FILTER(매입_병합[[매입구분]:[공사명]],IF($D$6=\"\",매입_병합[작성일자]=매입_병합[작성일자],YEAR(매입_병합[작성일자])=$D$6)*IF($F$6=\"\",매입_병합[투입월]=매입_병합[투입월],매입_병합[투입월]=$F$6)*IF($W$3=\"\",매입_병합[공사명]=매입_병합[공사명],매입_병합[공사명]<>$W$3)*IF($Y$3=\"\",매입_병합[비용구분]=매입_병합[비용구분],매입_병합[비용구분]<>$Y$3))),V6,X6)","v":0},2024,"외)공사원가(외주)","2024년 1월","2024-01-01",0,"매입1",0,0,0,0,0,0,0,"매입1",1100,1000,100,0,0]
[null,0,2024,"재)공사원가(재료)","2024년 2월","2024-02-01",0,"매입2",0,0,0,0,0,0,0,"매입2",1101,1001,100,0,0]
[null,0,2024,"장)공사원가(장비)","2024년 3월","2024-03-01",0,"매입3",0,0,0,0,0,0,0,"매입3",1102,1002,100,0,0]
[null,0,2024,"재)공사원가(재료)","2024년 4월","2024-04-01",0,"매입4",0,0,0,0,0,0,0,"매입4",1103,1003,100,0,0]

{"sheet":"(기성누계)Filter","index":9,"n_rows":13,"n_cols":28,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,23],[4,2,4,7]]}
[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,"본사 미포함시\n선택하세요.☞","#본사"]
[]
[null,"현 장 명",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SORT_기준1","SORT_기준2","SORT_기준3"]
[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,{"$f":"IF(AA6=1,-1,1)","v":1}]
[]
[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":"_xlfn._xlws.SORT(IF(C5<>\"\",_xlfn._xlws.FILTER(매출계산서[[기성월]:[실입금예정액]],ISNUMBER(SEARCH(C5,매출계산서[공사명]))*IF($C$6=\"\",매출계산서[작성일자]=매출계산서[작성일자],YEAR(매출계산서[작성일자])=$C$6)*IF($H$6=\"\",매출계산서[기성월]=매출계산서[기성월],매출계산서[기성월]=$H$6)),_xlfn._xlws.FILTER(매출계산서[[기성월]:[실입금예정액]],IF($C$6=\"\",매출계산서[작성일자]=매출계산서[작성일자],YEAR(매출계산서[작성일자])=$C$6)*IF($H$6=\"\",매출계산서[기성월]=매출계산서[기성월],매출계산서[기성월]=$H$6)*IF($AA$3=\"\",매출계산서[공사명]=매출계산서[공사명],매출계산서[공사명]<>$AA$3))),Z6,AB6)","v":"2024년 1월"},"2024-01-01",0,"00:00:00","00:00:00","매출1",0,0,"공사1",0,0,"가",1100,1000,100,0,0,0,0,0,0,0,1100]
[null,"2024년 2월","2024-02-01",0,"00:00:00","00:00:00","매출2",0,0,"공사2",0,0,"나",1101,1001,100,0,0,0,0,0,0,0,1101]
[null,"2024년 3월","2024-03-01",0,"00:00:00","00:00:00","매출3",0,0,"공사3",0,0,"다",1102,1002,100,0,0,0,0,0,0,0,1102]
[null,"2024년 4월","2024-04-01",0,"00:00:00","00:00:00","매출4",0,0,"공사4",0,0,"라",1103,1003,100,0,0,0,0,0,0,0,1103]

{"sheet":"자금집행","index":10,"n_rows":14,"n_cols":29,"rows_kept":14,"cut":false,"hidden":false,"merged":[[5,1,5,20],[5,21,5,26],[2,1,2,26]]}
[null,"*매월 '매입_병합(연결쿼리)'에서 작성일자로 오름차순 후, '(투입누계)Filter'에서 '투입월' 필터 후, '공사명'으로 오름차순 정렬 ☞ 값 복사하여 붙여넣고 지속적으로 작업. ","출력숨김셀",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":"ROW()-7","v":1},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(AB8<>0,\"(\"&AB8&\") \"&AC8,\"\")","v":""}]
[null,{"$f":"ROW()-7","v":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,{"$f":"IF(AB9<>0,\"(\"&AB9&\") \"&AC9,\"\")","v":""}]
[null,3,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,4,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,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,6,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(AB13<>0,\"(\"&AB13&\") \"&AC13,\"\")","v":""}]
[null,7,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(AB14<>0,\"(\"&AB14&\") \"&AC14,\"\")","v":""}]

{"sheet":"월)기성청구서","index":11,"n_rows":48,"n_cols":21,"rows_kept":48,"cut":false,"hidden":false,"merged":[[22,11,23,11],[13,11,14,11],[13,9,13,10],[13,7,13,8],[33,11,34,11],[6,11,7,11],[13,5,13,6],[13,4,14,4],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,6,6],[3,1,3,6],[33,1,34,1],[33,2,33,4],[33,5,33,7],[33,8,33,10],[22,2,22,4],[22,5,22,7],[22,8,22,10],[13,3,14,3],[13,2,14,2],[13,1,14,1],[22,1,23,1],[19,1,19,3],[6,7,6,8],[6,9,6,10]]}
[]
[null,{"$f":"\"[  자금청구서 \"&YEAR(Q2)&\"년 \"&MONTH(Q2)&\"월\"&\"  ]\"","v":"[  자금청구서 2024년 1월  ]"},null,null,null,null,null,null,null,null,null,null,null,"전회누계\n기준일자","2023-12-31","금회\n기준일자",{"$f":"IF(S2=\"\",EOMONTH(O2,1),EOMONTH(O2,1)+S2)","v":"2024-01-31"},"금회매입\n가중치"]
[]
[null,"공사4"]
[]
[null,"1. 원도급 계약 및 기성내역",null,null,null,null,null,null,null,null,null,"(단위: 원)"]
[null,"계약대비\n투입률(%)","기성대비\n투입률(%)","단위","계약금액","기성금액 (전회)",null,"기성금액 (금회)",null,"누  계 (기성률)",null,"비고\n(잔여기성률)"]
[null,null,null,null,null,"금    액","%","금    액","%","금    액","%"]
[null,{"$f":"I30/E9","v":{"$error":"#DIV/0!"}},{"$f":"I30/J9","v":{"$error":"#DIV/0!"}},"공급가",{"$f":"SUMIF(실계약현황[공사명],'월)기성청구서'!$B$4,실계약현황[금차공급가계약])","v":0},{"$f":"SUMPRODUCT(SUMIFS(매출계산서[공급가액],매출계산서[공사명],$B$4,매출계산서[작성일자],\"<=\"&$O$2))","v":0},{"$f":"F9/$E9","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT(SUMIFS(매출계산서[공급가액],매출계산서[공사명],$B$4,매출계산서[작성일자],\"<=\"&$Q$2,매출계산서[작성일자],\">\"&$O$2))","v":0},{"$f":"H9/E9","v":{"$error":"#DIV/0!"}},{"$f":"F9+H9","v":0},{"$f":"J9/$E9","v":{"$error":"#DIV/0!"}},{"$f":"1-K9","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"J30/E10","v":{"$error":"#DIV/0!"}},{"$f":"J30/J10","v":{"$error":"#DIV/0!"}},"부가세",{"$f":"SUMIF(실계약현황[공사명],'월)기성청구서'!$B$4,실계약현황[금차부가세계약])","v":0},{"$f":"SUMPRODUCT(SUMIFS(매출계산서[세액],매출계산서[공사명],$B$4,매출계산서[작성일자],\"<=\"&$O$2))","v":0},{"$f":"F10/$E10","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT(SUMIFS(매출계산서[세액],매출계산서[공사명],$B$4,매출계산서[작성일자],\"<=\"&$Q$2,매출계산서[작성일자],\">\"&$O$2))","v":0},{"$f":"H10/E10","v":{"$error":"#DIV/0!"}},{"$f":"F10+H10","v":0},{"$f":"J10/$E10","v":{"$error":"#DIV/0!"}},{"$f":"1-K10","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"K30/E11","v":{"$error":"#DIV/0!"}},{"$f":"K30/J11","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(E9:E10)","v":0},{"$f":"SUM(F9:F10)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(H9:H10)","v":0},{"$f":"H11/E11","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J9:J10)","v":0},{"$f":"J11/$E11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[null,"2. 협력업자 계약 및 기성내역",null,null,null,null,null,null,null,null,null,"(단위: 원)"]
[null,"공종","구  분","단위","계약금액","기성금액 (전회)",null,"기성금액 (금회)",null,"누  계 (기성률)",null,"비고\n(계약합계)"]
[null,null,null,null,null,"금    액","%","금    액","%","금    액","%"]
[null,null,null,"공급가",{"$f":"SUMIFS(하도실계약현황[공급가],하도실계약현황[공사명],$B$4,하도실계약현황[하도급공종],$B16,하도실계약현황[하도급업체],$C16)","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[하도급공종],$B16,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"F16/$E16","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[하도급공종],$B16,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"H16/E16","v":{"$error":"#DIV/0!"}},{"$f":"F16+H16","v":0},{"$f":"J16/$E16","v":{"$error":"#DIV/0!"}},null,null,"☜ 하도급업체 입력 주의! 하도급계약현황을 보고 작성하세요."]
[null,null,null,"부가세",{"$f":"SUMIFS(하도실계약현황[부가세],하도실계약현황[공사명],$B$4,하도실계약현황[하도급공종],$B17,하도실계약현황[하도급업체],$C17)","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[하도급공종],$B17,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"F17/$E17","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[하도급공종],$B17,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"H17/E17","v":{"$error":"#DIV/0!"}},{"$f":"F17+H17","v":0},{"$f":"J17/$E17","v":{"$error":"#DIV/0!"}},{"$f":"+E16+E17","v":0}]
[null,null,null,"공급가",{"$f":"SUMIFS(하도실계약현황[공급가],하도실계약현황[공사명],$B$4,하도실계약현황[하도급공종],$B18,하도실계약현황[하도급업체],$C18)","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[하도급공종],$B18,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$error":"#DIV/0!"},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[하도급공종],$B18,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,"부가세",{"$f":"SUMIFS(하도실계약현황[부가세],하도실계약현황[공사명],$B$4,하도실계약현황[하도급공종],$B19,하도실계약현황[하도급업체],$C19)","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[하도급공종],$B19,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$error":"#DIV/0!"},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[하도급공종],$B19,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"+E18+E19","v":0}]
[null,"계",null,null,{"$f":"SUM(E16:E19)","v":0},{"$f":"SUM(F16:F19)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(H16:H19)","v":0},{"$f":"H20/E20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J16:J19)","v":0},{"$f":"J20/$E20","v":{"$error":"#DIV/0!"}}]
[]
[null,"3. 자금투입내역 (현장청구분 및 운영관리비)",null,null,null,null,null,null,null,null,null,"(단위: 원)"]
[null,"구분","전 회 까 지",null,null,"금  회",null,null,"누  계",null,null,"비고"]
[null,null,"공 급 가","부가세","계","공 급 가","부가세","계","공 급 가","부가세","계"]
[null,"외주비",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O25:$T25,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O25:$T25,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"C25+D25","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O25:$T25,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O25:$T25,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"+F25+G25","v":0},{"$f":"+C25+F25","v":0},{"$f":"+D25+G25","v":0},{"$f":"E25+H25","v":0},null,null,"외주비","외)공사원가(외주)"]
[null,"재료비",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O26:$T26,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O26:$T26,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"C26+D26","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O26:$T26,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O26:$T26,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"+F26+G26","v":0},{"$f":"+C26+F26","v":0},{"$f":"+D26+G26","v":0},{"$f":"E26+H26","v":0},null,null,"재료비","재)공사원가(재료)"]
[null,"직접노무비",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O27:$T27,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O27:$T27,매입_병합[작성일자],\"<=\"&$O$2))","v":0},0,{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O27:$T27,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O27:$T27,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},0,0,0,0,null,null,"직접노무비","노)공사원가(노무)"]
[null,"장비비",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O28:$T28,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O28:$T28,매입_병합[작성일자],\"<=\"&$O$2))","v":0},0,{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O28:$T28,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O28:$T28,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},0,0,0,0,null,null,"장비비","장)공사원가(장비)"]
[null,"운영관리비",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O29:$U29,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O29:$U29,매입_병합[작성일자],\"<=\"&$O$2))","v":0},0,{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O29:$U29,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$O29:$U29,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},0,0,0,0,"본사",null,"운영관리비","경)공사원가(경비)","퇴)공사원가(퇴직공제)","보)공사원가(4대보험)","건안)공사원가(안전관리비)","산안)공사원가(안전관리비)","환)공사원가(환경보전비)","증)공사원가(보증서)"]
[null,"계",{"$f":"SUM(C25:C29)","v":0},{"$f":"SUM(D25:D29)","v":0},0,0,0,0,0,0,0]
[]
[]
[null,"4. 정산용/ 자금투입내역 (현장청구분 및 운영관리비)",null,null,null,null,null,null,null,null,null,"(단위: 원)"]
[null,"구분","전 회 까 지",null,null,"금  회",null,null,"누  계",null,null,"비고"]
[null,null,"공 급 가","부가세","계","공 급 가","부가세","계","공 급 가","부가세","계"]
[null,"재)공사원가(재료)",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B36,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B36,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"C36+D36","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B36,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B36,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"+F36+G36","v":0},{"$f":"+C36+F36","v":0},{"$f":"+D36+G36","v":0},{"$f":"E36+H36","v":0}]
[null,"노)공사원가(노무)",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B37,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B37,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"C37+D37","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B37,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B37,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"+F37+G37","v":0},{"$f":"+C37+F37","v":0},{"$f":"+D37+G37","v":0},{"$f":"E37+H37","v":0}]
[null,"간)공사원가(간접노무비)",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B38,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B38,매입_병합[작성일자],\"<=\"&$O$2))","v":0},0,{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B38,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B38,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},0,0,0,0,null,null,"☜ 급여에서 가져옴. 해당 현장 기술자(건강,연금 상용 가입자)"]
[null,"외)공사원가(외주)",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B39,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B39,매입_병합[작성일자],\"<=\"&$O$2))","v":0},0,{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B39,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B39,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},0,0,0,0]
[null,"장)공사원가(장비)",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B40,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B40,매입_병합[작성일자],\"<=\"&$O$2))","v":0},0,{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B40,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B40,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},0,0,0,0]
[null,"경)공사원가(경비)",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B41,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B41,매입_병합[작성일자],\"<=\"&$O$2))","v":0},0,{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B41,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B41,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},0,0,0,0]
[null,"퇴)공사원가(퇴직공제)",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B42,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B42,매입_병합[작성일자],\"<=\"&$O$2))","v":0},0,{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B42,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B42,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},0,0,0,0]
[null,"보)공사원가(4대보험)",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B43,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B43,매입_병합[작성일자],\"<=\"&$O$2))","v":0},0,{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B43,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B43,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},0,0,0,0,null,null,"건강, 연금 1/2의 금액"]
[null,"건안)공사원가(안전관리비)",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B44,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B44,매입_병합[작성일자],\"<=\"&$O$2))","v":0},0,{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B44,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B44,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},0,0,0,0]
[null,"산안)공사원가(안전관리비)",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B45,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B45,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"C45+D45","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B45,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B45,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"+F45+G45","v":0},{"$f":"+C45+F45","v":0},{"$f":"+D45+G45","v":0},{"$f":"E45+H45","v":0}]
[null,"환)공사원가(환경보전비)",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B46,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B46,매입_병합[작성일자],\"<=\"&$O$2))","v":0},0,{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B46,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B46,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},0,0,0,0]
[null,"증)공사원가(보증서)",{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B47,매입_병합[작성일자],\"<=\"&$O$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B47,매입_병합[작성일자],\"<=\"&$O$2))","v":0},0,{"$f":"SUMPRODUCT(SUMIFS(매입_병합[공급가액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B47,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},{"$f":"SUMPRODUCT(SUMIFS(매입_병합[세액],매입_병합[공사명],$B$4,매입_병합[비용구분],$B47,매입_병합[작성일자],\">\"&$O$2,매입_병합[작성일자],\"<=\"&$Q$2))","v":0},0,0,0,0,null,null,"차액검증",": 간접노무비만큼 차이"]
[null,"계",{"$f":"SUM(C36:C47)","v":0},0,0,0,0,0,0,0,0,null,null,{"$f":"K48-K30","v":0},{"$f":"K38-N48","v":0}]