{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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,"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":"Sheet1","index":0,"n_rows":15,"n_cols":32,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,20,3,20],[2,1,3,1],[2,2,3,2],[2,3,2,4],[2,6,2,9],[2,10,2,13],[2,14,3,14],[2,27,3,27],[2,29,3,29],[2,30,3,30],[2,31,3,31],[14,1,14,20],[2,21,3,21],[2,22,3,22],[2,23,3,23],[2,24,3,24],[2,25,3,25],[2,26,3,26],[2,15,3,15],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,19,3,19]]}
[]
[null,"メルカリ出品管理表"]
[null,"No.","枝番","登録",null,"価格変更","売却",null,null,null,"確認",null,null,null,"ID","送り状","県名","郵便番号","配達区域","発送方法","商品名","文字数","定価","金額","定価%","手数料","送料","送料の割合","メルカリ","箱代他\n直接支払","利益","利益の割合"]
[null,null,null,"日付","時刻","予定日","日付","曜日","時刻","購入者","日付","時刻","いいね","閲覧数",null,null,null,null,null,null,null,null,"定価","金額",null,"手数料","送料",null,"算出利益","箱代他","粗利"]
[null,1,0,"2020-11-01","11:50:00",{"$f":"D5+7","v":"2020-11-08"},"2020-11-05",{"$f":"TEXT(G5,\"aaa\")","v":"木"},"19:10:00",null,null,null,null,null,"m01234567890","123456789012","〇〇県","〒999-9999","＊＊＊＊＊センター","宅配便コンパクト","＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊",{"$f":"LEN(U5)","v":33},4300,2950,{"$f":"IF(W5<>\"\",X5/W5,\"\")","v":0.68604651162790697},{"$f":"X5*0.1","v":295},380,{"$f":"AA5/X5","v":0.12881355932203389},{"$f":"X5-Z5-AA5","v":2275},70,{"$f":"AC5-AD5","v":2205},{"$f":"AE5/X5","v":0.74745762711864405}]
[null,2,0,null,null,null,null,{"$f":"TEXT(G6,\"aaa\")","v":"土"},null,null,null,null,null,null,null,null,null,null,null,"ネコポス","＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊",{"$f":"LEN(U6)","v":33},null,700,{"$f":"IF(W6<>\"\",X6/W6,\"\")","v":""},{"$f":"X6*0.1","v":70},195]
[null,2,1,"2020-11-05","18:00:00",{"$f":"D7+7","v":"2020-11-12"},"2020-11-05","木","20:00:00",null,null,null,null,null,"m01234567890","123456789012","〇〇県","〒999-9999","＊＊＊＊＊センター","ネコポス","＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊",33,null,500,{"$f":"IF(W7<>\"\",X7/W7,\"\")","v":""},{"$f":"X7*0.1","v":50},175,{"$f":"AA7/X7","v":0.35},{"$f":"X7-Z7-AA7","v":275},null,{"$f":"AC7-AD7","v":275},{"$f":"AE7/X7","v":0.55000000000000004}]
[null,3,3,null,null,null,null,"土",null,null,null,null,null,null,null,null,null,null,null,null,"＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊",33,null,300,null,null,null,null,null,null,"-","-"]
[null,4,0,null,null,null,null,"土",null,null,null,null,null,null,null,null,null,null,null,"宅配便コンパクト","＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊",{"$f":"LEN(U9)","v":33},null,1100,{"$f":"IF(W9<>\"\",X9/W9,\"\")","v":""},{"$f":"X9*0.1","v":110},380,{"$f":"AA9/X9","v":0.34545454545454546},{"$f":"X9-Z9-AA9","v":610},70,{"$f":"AC9-AD9","v":540},{"$f":"AE9/X9","v":0.49090909090909091}]
[]
[]
[]
[]
[]
[null,"合計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"SUMIF(G5:G14,\"<>\",X5:X14)","v":3450},null,{"$f":"SUMIF(G5:G14,\"<>\",Z5:Z14)","v":345},{"$f":"SUMIF(G5:G14,\"<>\",AA5:AA14)","v":555},{"$f":"AA15/X15","v":0.16086956521739129},{"$f":"SUMIF(G5:G14,\"<>\",AC5:AC14)","v":2550},{"$f":"SUMIF(G5:G14,\"<>\",AD5:AD14)","v":70},{"$f":"SUMIF(G5:G14,\"<>\",AE5:AE14)","v":2480},{"$f":"AE15/X15","v":0.71884057971014492}]