{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["송장 기록표"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"송장 기록표","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[null,"송장 기록표"]
[null,"송장 번호","날짜","지불 기한","고객 이름","금액 ","연체료 ","총 지불 금액","지불 날짜","미결"]
[null,1001,{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2018-01-15"},{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2018-02-15"},"하",{"v":20199000,"d":"₩20,199,000.00"},{"$f":"IFERROR(IF(송장[[#This Row],[지불 기한]]>=송장[[#This Row],[지불 날짜]],,5), \"\")","v":0},{"v":20199000,"d":"₩20,199,000.00"},{"$f":"DATE(YEAR(TODAY()),2,1)","v":"2018-02-01"},{"$f":"IFERROR(송장[[#This Row],[금액 ]]-송장[[#This Row],[총 지불 금액]]+송장[[#This Row],[연체료 ]], \"\")","v":0}]
[null,1002,{"$f":"DATE(YEAR(TODAY()),2,11)","v":"2018-02-11"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"하",{"v":15700000,"d":"₩15,700,000.00"},{"$f":"IFERROR(IF(송장[[#This Row],[지불 기한]]>=송장[[#This Row],[지불 날짜]],,5), \"\")","v":{"v":5,"d":"₩5.00"}},{"v":7500000,"d":"₩7,500,000.00"},{"$f":"DATE(YEAR(TODAY()),4,10)","v":"2018-04-10"},{"$f":"IFERROR(송장[[#This Row],[금액 ]]-송장[[#This Row],[총 지불 금액]]+송장[[#This Row],[연체료 ]], \"\")","v":{"v":8200005,"d":"₩8,200,005.00"}}]
[null,1003,{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),4,15)","v":"2018-04-15"},"한미 교역(주)",{"v":13799000,"d":"₩13,799,000.00"},{"$f":"IFERROR(IF(송장[[#This Row],[지불 기한]]>=송장[[#This Row],[지불 날짜]],,5), \"\")","v":0},{"v":5500000,"d":"₩5,500,000.00"},{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"IFERROR(송장[[#This Row],[금액 ]]-송장[[#This Row],[총 지불 금액]]+송장[[#This Row],[연체료 ]], \"\")","v":{"v":8299000,"d":"₩8,299,000.00"}}]
[null,1004,{"$f":"DATE(YEAR(TODAY()),3,8)","v":"2018-03-08"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"유정호",{"v":120000,"d":"₩120,000.00"},{"$f":"IFERROR(IF(송장[[#This Row],[지불 기한]]>=송장[[#This Row],[지불 날짜]],,5), \"\")","v":{"v":5,"d":"₩5.00"}},{"v":75000,"d":"₩75,000.00"},{"$f":"DATE(YEAR(TODAY()),4,16)","v":"2018-04-16"},{"$f":"IFERROR(송장[[#This Row],[금액 ]]-송장[[#This Row],[총 지불 금액]]+송장[[#This Row],[연체료 ]], \"\")","v":{"v":45005,"d":"₩45,005.00"}}]
[null,1005,{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"DATE(YEAR(TODAY()),4,30)","v":"2018-04-30"},"한미 교역(주)",{"v":150000,"d":"₩150,000.00"},{"$f":"IFERROR(IF(송장[[#This Row],[지불 기한]]>=송장[[#This Row],[지불 날짜]],,5), \"\")","v":0},{"v":75000,"d":"₩75,000.00"},{"$f":"DATE(YEAR(TODAY()),4,11)","v":"2018-04-11"},{"$f":"IFERROR(송장[[#This Row],[금액 ]]-송장[[#This Row],[총 지불 금액]]+송장[[#This Row],[연체료 ]], \"\")","v":{"v":75000,"d":"₩75,000.00"}}]
[null,1006,{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2018-06-01"},"정서현",{"v":1475000,"d":"₩1,475,000.00"},{"$f":"IFERROR(IF(송장[[#This Row],[지불 기한]]>=송장[[#This Row],[지불 날짜]],,5), \"\")","v":0},{"v":1200000,"d":"₩1,200,000.00"},{"$f":"DATE(YEAR(TODAY()),4,28)","v":"2018-04-28"},{"$f":"IFERROR(송장[[#This Row],[금액 ]]-송장[[#This Row],[총 지불 금액]]+송장[[#This Row],[연체료 ]], \"\")","v":{"v":275000,"d":"₩275,000.00"}}]
[null,"합계",{"$nulls":3},{"$f":"SUBTOTAL(109,송장[[금액 ]])","v":{"v":51443000,"d":"₩51,443,000.00"}},null,{"$f":"SUBTOTAL(109,송장[총 지불 금액])","v":{"v":34549000,"d":"₩34,549,000.00"}},null,{"$f":"SUBTOTAL(109,송장[미결])","v":{"v":16894010,"d":"₩16,894,010.00"}}]