{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["텍스트상자 잠금","abs_iferror_rept","프로시저"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"문제: 표 제목부분인 텍스트상자를 잠금설정 후 시트보호를 적용."]
[]
[null,"성명","수도사용량","단가","요금","포인트"]
[null,"김함바",98,88,{"$f":"C7*D7","v":8624},9000]
[null,"박헨리",89,99,{"$f":"C8*D8","v":8811},8500]
[null,"김골든",82,55,4510,5000]
[null,"이정우",64,30,1920,2500]
[null,"송혜수",51,44,2244,2500]
[null,"서유진",93,66,6138,6000]
[null,"김써니",86,99,8514,9000]
[null,"지율무",72,55,3960,3500]
[null,"이효진",99,66,6534,7000]
[null,"박정재",77,88,6776,6500]
[null,"최승원",63,55,3465,4000]
[null,"공두나",80,77,6160,6000]

{"sheet":"abs_iferror_rept","index":1,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"문제: 포인트에서 요금을 뺀 금액을 100으로 나눈 값으로 추가납입비율 표시."]
[null,"        양수면 ▶ 음수면 ▷ 로 반복."]
[null,"        abs, iferror, rept 함수 모두 사용."]
[null,"성명","수도사용량","단가","요금","포인트","추가납입비율"]
[null,"김함바",98,88,{"$f":"C8*D8","v":8624},9000]
[null,"박헨리",89,99,{"$f":"C9*D9","v":8811},8500]
[null,"김골든",82,55,4510,5000]
[null,"이정우",64,30,1920,2500]
[null,"송혜수",51,44,2244,2500]
[null,"서유진",93,66,6138,6000]
[null,"김써니",86,99,8514,9000]
[null,"지율무",72,55,3960,3500]
[null,"이효진",99,66,6534,7000]
[null,"박정재",77,88,6776,6500]
[null,"최승원",63,55,3465,4000]
[null,"공두나",80,77,6160,6000]

{"sheet":"프로시저","index":2,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"[표1]"]
[null,"학번","성명","결석","지각","출석","과제","평가","비고"]
[null,1628002,"홍길동",0,0,20,20,60]
[null,1628011,"장길산",4,1,11,15,40,"출석미달"]
[]
[]
[]
[null,"문제: 폼이 초기화 되면 결석, 지각, 과제, 평가 텍스트상자에 1이 표시되도록 설정."]