{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["주문개발목록","휴일"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":218,"n_cols":15,"rows_kept":218,"cut":false,"hidden":false,"merged":[[193,2,194,2],[191,2,192,2],[122,3,134,3],[122,4,134,4],[98,3,106,3],[98,4,106,4],[135,2,137,2],[135,4,137,4],[161,3,163,3],[117,3,120,3],[117,4,120,4],[187,2,190,2],[135,3,137,3],[164,3,171,3],[3,3,5,3],[6,3,7,3],[6,4,7,4],[3,4,5,4],[31,3,33,3],[31,4,33,4],[8,3,24,3],[8,4,24,4],[29,4,30,4],[25,3,28,3],[29,3,30,3],[25,4,28,4],[164,4,171,4],[172,3,178,3],[172,4,178,4],[161,4,163,4],[149,3,160,3],[149,4,160,4],[138,3,145,3],[138,4,145,4],[54,4,62,4],[54,3,62,3],[41,3,42,3],[41,4,42,4],[107,3,116,3],[107,4,116,4],[43,3,44,3],[43,4,44,4],[46,3,52,3],[66,3,86,3],[66,4,86,4]]}
[]
[]
["사이트구분","depth1","depth2","depth3","화면구분","일정","시작일자","완료일자","기능","링크","차수","세부일정","개발자"]
["관리자","주문/배송","주문관리","주문목록","화면",{"$f":"SUM(L4:L8)","v":6},"2020-11-23",{"$f":"WORKDAY(G4,F4,휴일!A:A)","v":"2020-12-01"},"주문목록 > 주문목록조회","/order/list/form",1,2,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문목록 > 엑셀조회","/order/ecel/search",1,1,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문목록 > 엑셀다운로드","/order/ecel/search",1,1,"전석훈"]
["관리자","주문/배송","주문관리","입점업체미발주목록조회\n(SCM)","화면",null,null,null,"주문목록 > 입점업체미발주목록조회","/order/seller/unorder/list/form",1,1,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문목록 > 입점업체송장업로드","/order/seller/invoice/upload",1,1,"전석훈"]
["관리자","주문/배송","주문관리","주문상세","화면",{"$f":"SUM(L9:L23)","v":5},{"$f":"WORKDAY(H4,1,휴일!A:A)","v":"2020-12-02"},{"$f":"WORKDAY(G9,F9,휴일!A:A)","v":"2020-12-09"},"주문상세 > 주문기본정보조회",null,1,0.25,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 주문상세정보조회",null,1,0.25,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 주문상세상품단품정보조회",null,1,0.25,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 배송정보",null,1,0.25,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 결제정보",null,1,0.25,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"배송비정보",null,1,0.25,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > (취소/반품/교환) 요청 내역",null,1,0.25,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 환불정보",null,1,0.25,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 상담내역",null,1,0.25,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 관리자메모내역",null,1,0.25,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 외부몰 주문 실패내역",null,1,1.5,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 쿠폰사용내역",null,1,0.25,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 포인트사용내역",null,1,0.25,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 선포인트사용내역",null,1,0.25,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 상품권사용내역",null,1,0.25,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 교환배송비 결제 정보",null,3,0,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 반품/교환 추가배송비 개별결제 정보",null,3,0,"전석훈"]
["관리자","주문/배송","주문관리","주문취소완료","팝업",{"$f":"SUM(L26:L29)","v":7},{"$f":"WORKDAY(H9,1,휴일!A:A)","v":"2020-12-10"},{"$f":"WORKDAY(G26,F26,휴일!A:A)","v":"2020-12-21"},"주문취소 > 전체취소완료",null,1,2,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문취소 > 부분취소완료",null,1,2,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문취소 > 무료배송이하로 적용될때 배송비 부과",null,1,0,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문취소 > PG연동",null,1,3,"전석훈"]
["관리자","주문/배송","주문관리","주문반품신청","팝업",{"$f":"SUM(L30:L31)","v":4},{"$f":"WORKDAY(H26,1,휴일!A:A)","v":"2020-12-22"},{"$f":"WORKDAY(G30,F30,휴일!A:A)","v":"2020-12-29"},"주문반품 > 주문반품신청",null,1,2,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문반품 > 회수지정보등록 (최초배송지 설정)",null,1,2,"전석훈"]
["관리자","주문/배송","주문관리","주문교환신청","팝업",null,null,null,"주문교환 > 주문교환신청",null,null,null,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문교환 > 배송지정보등록 (최초배송지 설정)",null,null,null,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문교환 > 회수지정보등록 (최초배송지 설정)",null,null,null,"전석훈"]
["관리자","주문/배송","주문관리","주문상세이력조회","팝업",{"$f":"L35","v":1},{"$f":"WORKDAY(H26,1,휴일!A:A)","v":"2020-12-22"},{"$f":"WORKDAY(G35,F35,휴일!A:A)","v":"2020-12-23"},"주문 > 주문상세이력",null,1,1,"전석훈"]
["관리자","주문/배송","주문관리","주문상세상태변경","팝업",{"$f":"L37","v":1},{"$f":"WORKDAY(H35,1,휴일!A:A)","v":"2020-12-24"},{"$f":"WORKDAY(G36,F36,휴일!A:A)","v":"2020-12-28"},"주문 > 주문상세상태변경",null,1,1,"전석훈"]
["관리자","주문/배송","주문관리","배송지정보수정","팝업",{"$f":"L37","v":1},{"$f":"WORKDAY(H36,1,휴일!A:A)","v":"2020-12-29"},{"$f":"WORKDAY(G37,F37,휴일!A:A)","v":"2020-12-30"},"주문 > 배송지정보수정",null,1,1,"전석훈"]
["관리자","주문/배송","주문관리","회수지정보수정","팝업",1,{"$f":"WORKDAY(H37,1,휴일!A:A)","v":"2020-12-31"},{"$f":"WORKDAY(G38,F38,휴일!A:A)","v":"2021-01-04"},"주문 > 회수지정보수정",null,1,1,"전석훈"]
["관리자","주문/배송","주문관리","칼라,사이즈 변경","팝업",1,{"$f":"WORKDAY(H38,1,휴일!A:A)","v":"2021-01-05"},{"$f":"WORKDAY(G39,F39,휴일!A:A)","v":"2021-01-06"},"주문 > 칼라/사이즈 변경",null,1,1,"전석훈"]
["관리자","주문/배송","주문관리","관리자메모등록, 조회, 수정","팝업",1,{"$f":"WORKDAY(H39,1,휴일!A:A)","v":"2021-01-07"},{"$f":"WORKDAY(G40,F40,휴일!A:A)","v":"2021-01-08"},"주문 > 관리자메모 등록, 조회, 수정, 삭제",null,1,1,"전석훈"]
["관리자","주문/배송","주문관리","주문 반품 TO 교환","팝업",0,null,null,"주문상세 > 반품에서 교환 변경 (환불컨펌 이전)",null,3,0,"전석훈",3,"회수컨펌이전까지"]
["관리자","주문/배송","주문관리","주문 교환 TO 반품","팝업",{"$f":"L42","v":0},null,null,"주문상세 > 교환에서 반품 변경 (물류 회수컨펌 이전)",null,null,null,"전석훈"]
["관리자","주문/배송","주문관리",{"$nulls":5},"주문상세 > 교환에서 반품 변경 (물류 회수컨펌 이후)",null,3,0,"전석훈",3,"회수컨펌이전까지"]
["관리자","주문/배송","주문관리","주문 오배송 처리","팝업",0,null,null,"주문상세 > 주문 오배송 처리 (요건에 있음)",null,3,0,"전석훈",3,"자세한 협의"]
["관리자","주문/배송","주문관리",{"$nulls":5},"상품회수 후 WMS 의 오배송상품 +1, 배송상품+1 처리"]
["관리자","주문/배송","주문관리","NPAY 송장번호전송",{"$nulls":4},"NPAY 연동 > 송장번호 전송"]
["관리자","주문/배송","주문관리","NPAY 취소, 반품, 교환 접수","API",null,null,null,"NPAY 취소신청 접수"]
["관리자","주문/배송","주문관리",null,"API",null,null,null,"NPAY 취소철회 접수"]
["관리자","주문/배송","주문관리",null,"API",null,null,null,"NPAY 취소완료 등록"]
["관리자","주문/배송","주문관리",null,"API",null,null,null,"NPAY 반품신청 접수"]
["관리자","주문/배송","주문관리",null,"API",null,null,null,"NPAY 반품신청 철회"]
["관리자","주문/배송","주문관리",null,"API",null,null,null,"NPAY 교환신청 접수"]
["관리자","주문/배송","주문관리",null,"API",null,null,null,"NPAY 교환신청 철회"]
[{"$nulls":4},"합계",{"$f":"SUM(F4:F40)","v":28}]
["프론트","장바구니","장바구니","장바구니","화면",{"$f":"SUM(L55:L63)","v":4.5},"2021-01-13",{"$f":"WORKDAY(G55,F55,휴일!A:A)","v":"2021-01-19"},"장바구니 > 상품정보 조회",null,1,0.5,"이태영"]
["프론트","장바구니","장바구니",{"$nulls":5},"장바구니 > 즉시할인쿠폰조회",null,1,0.5,"이태영"]
["프론트","장바구니","장바구니",{"$nulls":5},"장바구니 > 업체별배송비조회",null,1,0.5,"이태영"]
["프론트","장바구니","장바구니",{"$nulls":5},"장바구니 > 총알배송상품조회",null,1,0.5,"이태영"]
["프론트","장바구니","장바구니",{"$nulls":5},"장바구니 > 적립예상포인트조회",null,1,0.5,"이태영"]
["프론트","장바구니","장바구니",{"$nulls":5},"장바구니 > 다다익선1 여부 조회 (수량)",null,1,0.5,"이태영"]
["프론트","장바구니","장바구니",{"$nulls":5},"장바구니 > 다다익선2 여부 조회 (금액)",null,1,0.5,"이태영"]
["프론트","장바구니","장바구니",{"$nulls":5},"장바구니 > 상품금액, 옵션금액, 할인금액 적용 계산",null,1,0.5,"이태영"]
["프론트","장바구니","장바구니",{"$nulls":5},"상품금액, 옵션금액, 할인금액 적용 계산",null,1,0.5,"이태영"]
["프론트","장바구니","장바구니","상품수량변경","팝업",{"$f":"L64","v":1},{"$f":"WORKDAY(H55,1,휴일!A:A)","v":"2021-01-20"},{"$f":"WORKDAY(G64,F64,휴일!A:A)","v":"2021-01-21"},"TB_CART, TB_GOODS, TB_OPTION",null,1,1,"이태영"]
["프론트","장바구니","장바구니","칼라/사이즈변경","팝업",{"$f":"L65","v":1},{"$f":"WORKDAY(H64,1,휴일!A:A)","v":"2021-01-22"},{"$f":"WORKDAY(G65,F65,휴일!A:A)","v":"2021-01-25"},"TB_CART, TB_GOODS, TB_OPTION",null,1,1,"이태영"]
["프론트"]
["프론트","주문서","결제화면","결제화면","화면",{"$f":"SUM(L67:L86)","v":10},{"$f":"WORKDAY(H40,1,휴일!A:A)","v":"2021-01-11"},{"$f":"WORKDAY(G67,F67,휴일!A:A)","v":"2021-01-25"},"주문서 > 상품정보 조회",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 즉시할인쿠폰조회",null,1,0.25,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 상품쿠폰조회",null,1,0.25,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 주문서쿠폰조회",null,1,0.25,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 배송비쿠폰조회",null,1,0.25,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 업체별배송비조회",null,1,0.25,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 적립예상포인트조회",null,1,0.25,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 다다익선1 여부 조회 (수량)",null,1,0.25,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 다다익선2 여부 조회 (금액)",null,1,0.25,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 보유포인트조회",null,1,0,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 상품권금액조회",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 결제금액계산",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 선물하기여부조회",null,1,3,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 예상배송일정조회",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 주문최소, 최대수량 조회",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > ID당 최대구매수량 체크",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 주문최소, 최대수량 조회",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 사은품정보조회",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 프로모션코드입력 쿠폰 (장바구니쿠폰)",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 장바구니쿠폰 결제 수단 제어 기능",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면",{"$nulls":5},"주문서 > 적용가능 사은품 조회"]
["프론트","주문서","결제화면","즉시할인쿠폰적용","프로그램",{"$f":"L88","v":1},{"$f":"WORKDAY(H67,1,휴일!A:A)","v":"2021-01-26"},{"$f":"WORKDAY(G88,F88,휴일!A:A)","v":"2021-01-27"},"주문서 > 즉시할인쿠폰 (조회 후 최대할인금액 적용)",null,1,1,"전석훈"]
["프론트","주문서","결제화면","다다익선1 적용","프로그램",{"$f":"SUM(L89:L90)","v":1},{"$f":"WORKDAY(H88,1,휴일!A:A)","v":"2021-01-28"},{"$f":"WORKDAY(G89,F89,휴일!A:A)","v":"2021-01-29"},"주문서 > 다다익선1 (수량)",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면","다다익선2 적용","프로그램",null,null,null,"주문서 > 다다익선2 (금액)",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면","총알배송 적용","프로그램",{"$f":"SUM(L91:L92)","v":1},{"$f":"WORKDAY(H89,1,휴일!A:A)","v":"2021-02-01"},{"$f":"WORKDAY(G91,F91,휴일!A:A)","v":"2021-02-02"},"주문서 > 총알배송",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면","상품쿠폰적용","팝업",null,null,null,"주문서 > 상품쿠폰",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면","배송비쿠폰적용","팝업",{"$f":"SUM(L93:L94)","v":1},{"$f":"WORKDAY(H91,1,휴일!A:A)","v":"2021-02-03"},{"$f":"WORKDAY(G93,F93,휴일!A:A)","v":"2021-02-04"},"주문서 > 배송비쿠폰",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면","장바구니쿠폰적용","팝업",null,null,null,"주문서 > 주문서쿠폰",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면","포인트적용","프로그램",{"$f":"SUM(L95:L96)","v":1},{"$f":"WORKDAY(H93,1,휴일!A:A)","v":"2021-02-05"},{"$f":"WORKDAY(G95,F95,휴일!A:A)","v":"2021-02-08"},"주문서 > 보유포인트",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면","선포인트적용","프로그램",null,null,null,"주문서 > 선포인트",null,1,0.5,"전석훈"]
["프론트","주문서","결제화면","상품권금액적용","프로그램",{"$f":"L97","v":1},{"$f":"WORKDAY(H95,1,휴일!A:A)","v":"2021-02-09"},{"$f":"WORKDAY(G97,F97,휴일!A:A)","v":"2021-02-10"},"주문서 > 상품권금액",null,1,1,"전석훈"]
["프론트","주문서","결제화면","사은품적용",{"$nulls":4},"주문서 > 사은품적용 기능",null,0,0,"전석훈"]
["프론트","주문서","결제화면","결제수단적용","프로그램",{"$f":"SUM(L99:L107)","v":8},{"$f":"WORKDAY(H65,1,휴일!A:A)","v":"2021-01-26"},{"$f":"WORKDAY(G99,F99,휴일!A:A)","v":"2021-02-05"},"결제수단 > 신용카드",null,1,1,"이태영"]
["프론트","주문서","결제화면",{"$nulls":5},"결제수단 > 실시간계좌이체",null,1,1,"이태영"]
["프론트","주문서","결제화면",{"$nulls":5},"결제수단 > 무통장입금",null,1,1,"이태영"]
["프론트","주문서","결제화면",{"$nulls":5},"결제수단 > 휴대폰결제",null,1,1,"이태영"]
["프론트","주문서","결제화면",{"$nulls":5},"결제수단 > 페이코",null,1,1,"이태영"]
["프론트","주문서","결제화면",{"$nulls":5},"결제수단 > NPAY",null,1,1,"이태영"]
["프론트","주문서","결제화면",{"$nulls":5},"결제수단 > 카카오페이",null,1,1,"이태영"]
["프론트","주문서","결제화면",{"$nulls":5},"결제수단 > YES24페이 (세이페이)",null,1,0,"이태영"]
["프론트","주문서","결제화면",{"$nulls":5},"결제수단 > 상품권",null,1,1,"이태영"]
["프론트","주문서","결제진행","결제진행","프로그램",{"$f":"SUM(L108:L116)","v":5},{"$f":"WORKDAY(H99,1,휴일!A:A)","v":"2021-02-08"},{"$f":"WORKDAY(G108,F108,휴일!A:A)","v":"2021-02-17"},"결제진행 > 주문정보등록",null,1,0.5,"이태영"]
["프론트","주문서","결제진행",{"$nulls":5},"결제진행 > 배송비내역등록",null,1,0.5,"이태영"]
["프론트","주문서","결제진행",{"$nulls":5},"결제진행 > 포인트사용처리",null,1,0.5,"이태영"]
["프론트","주문서","결제진행",{"$nulls":5},"결제진행 > 쿠폰사용처리",null,1,0.5,"이태영"]
["프론트","주문서","결제진행",{"$nulls":5},"결제진행 > 상품권사용처리",null,1,0.5,"이태영"]
["프론트","주문서","결제진행",{"$nulls":5},"결제진행 > 결제정보등록",null,1,0.5,"이태영"]
["프론트","주문서","결제진행",{"$nulls":5},"결제진행 > WMS 재고 체크 로직 추가",null,1,0.5,"이태영"]
["프론트","주문서","결제진행",{"$nulls":5},"결제진행 > 재고차감",null,1,1,"이태영"]
["프론트","주문서","결제진행",{"$nulls":5},"결제진행 > 장바구니정보 삭제",null,1,0.5,"이태영"]
["프론트","주문서","결제진행",{"$nulls":5},"결제진행 > IF 테이블 주문정보 등록",null,null,null,"이태영"]
["프론트","주문서","결제완료","결제완료","화면",{"$f":"SUM(L118:L121)","v":2},{"$f":"WORKDAY(H108,1,휴일!A:A)","v":"2021-02-18"},{"$f":"WORKDAY(G118,F118,휴일!A:A)","v":"2021-02-22"},"결제완료 > 주문정보",null,1,0.5,"이태영"]
["프론트","주문서","결제완료",{"$nulls":5},"결제완료 > 배송정보",null,1,0.5,"이태영"]
["프론트","주문서","결제완료",{"$nulls":5},"결제완료 > 결제정보",null,1,0.5,"이태영"]
["프론트","주문서","결제완료",{"$nulls":5},"결제완료 > 알림톡전송, 이메일전송",null,1,0.5,"이태영"]
["프론트"]
["프론트","마이페이지","주문목록","주문확인/배송조회","화면",{"$f":"SUM(L123:L135)","v":4},"2021-01-13",{"$f":"WORKDAY(G123,F123,휴일!A:A)","v":"2021-01-19"},"주문확인/배송조회 > 포인트조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문목록",{"$nulls":5},"주문확인/배송조회 > 상품권조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문목록",{"$nulls":5},"주문확인/배송조회 > 보유쿠폰조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문목록",{"$nulls":5},"주문확인/배송조회 > 할인쿠폰만료예정(7일이내)",null,1,0.25,"전상목"]
["프론트","마이페이지","주문목록",{"$nulls":5},"주문확인/배송조회 > 결제완료 건수조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문목록",{"$nulls":5},"주문확인/배송조회 > 상품준비중 건수 조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문목록",{"$nulls":5},"주문확인/배송조회 > 배송중 건수 조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문목록",{"$nulls":5},"주문확인/배송조회 > 배송완료 건수 조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문목록",{"$nulls":5},"주문확인/배송조회 > 취소/교환/반품 건수 조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문목록",{"$nulls":5},"주문확인/배송조회 > 주문목록조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문목록",{"$nulls":5},"주문확인/배송조회 > EVENT 배너조회",null,1,1,"전상목"]
["프론트","마이페이지","주문목록",{"$nulls":5},"주문확인/배송조회 > 공지사항조회 최신 2건",null,1,0.25,"전상목"]
["프론트","마이페이지","주문목록",{"$nulls":5},"주문확인/배송조회 > 구매확정버튼",null,1,0.25,"전상목"]
["프론트","마이페이지","배송","배송조회","화면",{"$f":"SUM(L136:L138)","v":2},{"$f":"WORKDAY(H123,1,휴일!A:A)","v":"2021-01-20"},{"$f":"WORKDAY(G136,F136,휴일!A:A)","v":"2021-01-22"},"배송조회 > 주문상품정보조회",null,1,0.5,"전상목"]
["프론트","마이페이지",{"$nulls":6},"배송조회 > 배송지정보",null,1,0.5,"전상목"]
["프론트","마이페이지",{"$nulls":6},"배송조회 > 배송내역",null,1,1,"전상목"]
["프론트","마이페이지","주문상세","주문상세","화면",{"$f":"SUM(L139:L146)","v":6},{"$f":"WORKDAY(H136,1,휴일!A:A)","v":"2021-01-25"},{"$f":"WORKDAY(G139,F139,휴일!A:A)","v":"2021-02-02"},"주문상세 > 주문정보(상품, 결제, 배송지정보)",null,1,1,"전상목"]
["프론트","마이페이지","주문상세",{"$nulls":5},"주문상세 > 배송지정보",null,1,1,"전상목"]
["프론트","마이페이지","주문상세",{"$nulls":5},"주문상세 > 할인정보 (즉시할인쿠폰, 상품쿠폰, 장바구니쿠폰, 배송비쿠폰)",null,1,0.5,"전상목"]
["프론트","마이페이지","주문상세",{"$nulls":5},"주문상세 > 할인정보 (다다익선1, 다다익선2)",null,1,0.5,"전상목"]
["프론트","마이페이지","주문상세",{"$nulls":5},"주문상세 > 할인정보 (포인트)",null,1,0.5,"전상목"]
["프론트","마이페이지","주문상세",{"$nulls":5},"주문상세 > 할인정보 (선포인트)",null,1,0.5,"전상목"]
["프론트","마이페이지","주문상세",{"$nulls":5},"주문상세 > 적립포인트",null,1,0.5,"전상목"]
["프론트","마이페이지","주문상세",{"$nulls":5},"주문상세 > 멤버십추가포인트적립",null,1,1.5,"전상목"]
["프론트","마이페이지","주문상세",{"$nulls":5},"주문상세 > 사은품 정보 조회",null,null,null,"전상목"]
["프론트","마이페이지","주문상세","신용카드전표(현금영수증)","화면",{"$f":"L148","v":1},{"$f":"WORKDAY(H139,1,휴일!A:A)","v":"2021-02-03"},{"$f":"WORKDAY(G148,F148,휴일!A:A)","v":"2021-02-04"},null,null,1,1,"전상목"]
["프론트","마이페이지","주문상세","현금영수증","화면",{"$f":"L149","v":1},{"$f":"WORKDAY(H148,1,휴일!A:A)","v":"2021-02-05"},{"$f":"WORKDAY(G149,F149,휴일!A:A)","v":"2021-02-08"},null,null,1,1,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역","주문취소/교환/반품 내역","화면",{"$f":"SUM(L150:L160)","v":4},{"$f":"WORKDAY(H149,1,휴일!A:A)","v":"2021-02-09"},{"$f":"WORKDAY(G150,F150,휴일!A:A)","v":"2021-02-17"},"취소/교환/반품 내역 > 포인트조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"취소/교환/반품 내역 > 상품권조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"취소/교환/반품 내역 > 보유쿠폰조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"취소/교환/반품 내역 > 할인쿠폰만료예정(7일이내)",null,1,0.25,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"취소/교환/반품 내역 > 주문접수 건수조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"취소/교환/반품 내역 > 결제완료 건수조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"취소/교환/반품 내역 > 상품준비중 건수 조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"취소/교환/반품 내역 > 배송중 건수 조회",null,1,0.25,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"취소/교환/반품 내역 > 배송완료 건수 조회",null,1,0.5,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"취소/교환/반품 내역 > 취소/교환/반품 건수 조회",null,1,0.5,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"취소/교환/반품 내역 > 취소/교환/반품 목록조회",null,1,1,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"취소/교환/반품 내역 > 교환/반품 추가배송비 정보 조회",null,3,0,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역","반품/취소 정보","팝업",{"$f":"SUM(L162:L164)","v":2},{"$f":"WORKDAY(H150,1,휴일!A:A)","v":"2021-02-18"},{"$f":"WORKDAY(G162,F162,휴일!A:A)","v":"2021-02-22"},"반품/취소 > 주문상품정보",null,1,0.5,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"반품/취소 > 환불내용",null,1,0.5,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"반품/취소 > 회수지정보",null,1,1,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역","반품/취소 신청","화면",{"$f":"SUM(L165:L170)","v":5},{"$f":"WORKDAY(H162,1,휴일!A:A)","v":"2021-02-23"},{"$f":"WORKDAY(G165,F165,휴일!A:A)","v":"2021-03-03"},"반품/취소 신청 > 주문상품정보조회",null,1,0.5,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"반품/취소 신청 > 취소시 상태값에 따라서 신청, 완료",null,1,2,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"반품/취소 신청 > 사유등록",null,1,0.5,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"반품/취소 신청 > 반품주소표시(업체표기)",null,1,0.5,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"반품/취소 신청 > 환불정보",null,1,1,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"반품/취소 > 회수지정보 (최초 배송지 설정)",null,1,0.5,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"반품/취소 > 사유가 고객일때 결제 PG 실행 (신용카드, 휴대폰)",null,null,null,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"반품/취소 > 사유가 회사로 신청 되어도 상품 회수 후 고객으로 판단되면 배송비 부과 후 환불",null,null,null,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역","교환신청","화면",{"$f":"SUM(L173:L178)","v":4},{"$f":"WORKDAY(H165,1,휴일!A:A)","v":"2021-03-04"},{"$f":"WORKDAY(G173,F173,휴일!A:A)","v":"2021-03-10"},"교환신청 > 상품정보조회",null,1,0.5,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"교환신청 > 교환사유등록",null,1,0.5,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"교환신청 > 교환 칼라, 사이즈 로 변경 가능",null,1,1,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"교환신청 > 배송지정보등록 (배송목록 연동)",null,1,1,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"교한신청 > 회수지정보 (최초 배송지 설정)",null,1,1,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"교환신청 > 사유가 고객일때 결제 PG 실행 (신용카드, 휴대폰)",null,3,0,"전상목"]
["프론트","마이페이지","주문취소/교환/반품 내역",{"$nulls":5},"교환신청 > 사유가 회사로 신청 되어도 상품 회수 후 고객으로 판단되면 배송비 부과 후 교환 배송"]
["프론트","상품","상품상세","NPAY 결제","기능",null,null,null,"상품상세 화면에서 NPAY 결제 진행 하면 NPAY 주문화면 (세트상품 체크)",null,3,3]
["프론트","상품","상품상세","NPAY 상품연동","기능",null,null,null,"NPAY 에서 상품 정보 요청 하면 XML DATA 로 URL 제공",null,3,3]
[{"$nulls":4},"합계",{"$f":"SUM(F55:F178)","v":66.5}]
["배치","주문","무통장입금취소",null,null,{"$f":"L183","v":2},{"$f":"WORKDAY(H118,1,휴일!A:A)","v":"2021-02-23"},{"$f":"WORKDAY(G183,F183,휴일!A:A)","v":"2021-02-25"},null,null,1,2]
["배치","주문","무통장(가상계좌) 입금 대기 알림(입금 유도 LMS 발송), 15시면 (입금마감 2시간 전 발송)( 시간배치 )",null,null,{"$f":"L184","v":3},{"$f":"WORKDAY(H183,1,휴일!A:A)","v":"2021-02-26"},{"$f":"WORKDAY(G184,F184,휴일!A:A)","v":"2021-03-04"},null,null,1,3]
["배치","주문","구매확정상태변경(14일)",null,null,{"$f":"L185","v":2},{"$f":"WORKDAY(H184,1,휴일!A:A)","v":"2021-03-05"},{"$f":"WORKDAY(G185,F185,휴일!A:A)","v":"2021-03-09"},null,null,1,2]
["배치","주문","위시리스트삭제",null,null,{"$f":"L186","v":1},{"$f":"WORKDAY(H185,1,휴일!A:A)","v":"2021-03-10"},{"$f":"WORKDAY(G186,F186,휴일!A:A)","v":"2021-03-11"},null,null,1,1]
["배치","주문","장바구니삭제",null,null,{"$f":"L187","v":1},{"$f":"WORKDAY(H186,1,휴일!A:A)","v":"2021-03-12"},{"$f":"WORKDAY(G187,F187,휴일!A:A)","v":"2021-03-15"},null,null,1,1]
["배치","주문","결제완료 후 결품취소(?)",null,null,{"$f":"SUM(L188:L191)","v":7},{"$f":"WORKDAY(H187,1,휴일!A:A)","v":"2021-03-16"},{"$f":"WORKDAY(G188,F188,휴일!A:A)","v":"2021-03-25"},"결제완료 결품정보 조회",null,1,1]
["배치","주문",{"$nulls":6},"예약 알림톡 발송",null,1,2]
["배치","주문",{"$nulls":6},"가상계좌결제시 환불계좌 여부 판단 (FRONT)",null,1,2]
["배치","주문",{"$nulls":6},"PG 부분취소, PG 전체취소 로직 추가",null,1,2]
["배치","주문","PG 정산 데이터 수신",null,null,{"$f":"SUM(L192:L193)","v":0},null,null,"KCM",null,3,0]
["배치","주문",{"$nulls":6},"NPAY",null,3,0]
["배치","주문","PG  거래대사 수신",null,null,{"$f":"SUM(L194:L195)","v":0},null,null,"KCM",null,3,0]
["배치","주문",{"$nulls":6},"NPAY",null,3,0]
["배치","NPAY","NPAY 연동",{"$nulls":5},"결제완료 주문정보 수신"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"결제완료 주문정보 생성 (TB_ORDER, TB_ORDER_DETAIL…)"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"주문취소 신청정보 수신 (관리자 API 호출)"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"주문취소 신청철회정보 수신 (관리자 API 호출)"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"주문취소 완료정보 수신 (관리자 API 호출)"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"주문반품 신청정보 수신 (관리자 API 호출)"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"주문반품 신청철회정보 수신 (관리자 API 호출)"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"주문교환 신청정보 수신 (관리자 API 호출)"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"주문교환 신청철회정보 수신 (관리자 API 호출)"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"주문취소 신청 완료 정보 송신"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"주문취소 신청 철회 정보 송신"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"주문반품 신청 완료 정보 송신"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"주문반품 신청 철회 정보 송신"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"주문교환 회수 완료 정보 송신"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"주문교환 발송 완료 정보 송신"]
["배치","NPAY","NPAY 연동",{"$nulls":5},"주무교환 철회 정보 송신"]
[{"$nulls":4},"합계",{"$f":"SUM(F183:F193)","v":16}]
[{"$nulls":5},{"$f":"SUM(F182,F54,F212)","v":110.5}]
[]
[null,null,"개발자","개발일수"]
[null,null,"전석훈",{"$f":"SUMIF(M:M,$C$216,L:L)","v":44}]
[null,null,"이태영",{"$f":"SUMIF(M:M,$C$217,L:L)","v":21.5}]
[null,null,"전상목",{"$f":"SUMIF(M:M,$C$218,L:L)","v":29}]

{"sheet":"휴일","index":1,"n_rows":45,"n_cols":1,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["2020-11-21"]
["2020-11-22"]
["2020-11-28"]
["2020-11-29"]
["2020-12-05"]
["2020-12-06"]
["2020-12-12"]
["2020-12-13"]
["2020-12-19"]
["2020-12-20"]
["2020-12-25"]
["2020-12-26"]
["2020-12-27"]
["2021-01-01"]
["2021-01-02"]
["2021-01-03"]
["2021-01-09"]
["2021-01-10"]
["2021-01-16"]
["2021-01-17"]
["2021-01-23"]
["2021-01-24"]
["2021-01-30"]
["2021-01-31"]
["2021-02-06"]
["2021-02-07"]
["2021-02-11"]
["2021-02-12"]
["2021-02-13"]
["2021-02-14"]
["2021-02-20"]
["2021-02-21"]
["2021-02-27"]
["2021-02-28"]
["2021-03-01"]
["2021-03-06"]
["2021-03-07"]
["2021-03-13"]
["2021-03-14"]
["2021-03-20"]
["2021-03-21"]
["2021-03-27"]
["2021-03-28"]
["2021-04-03"]
["2021-04-04"]