{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["売り上げ"],"not_rendered":{"charts":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"売り上げ","index":0,"n_rows":9,"n_cols":11,"rows_kept":9}
[null,"オンライン販売の管理"]
[]
[null,"品目","コスト\n品目あたり","パーセント\n利幅","合計\n販売額","合計\n収益","送料\n請求額/品目","送料\nコスト/品目","品目あたりの利益\n(送料含む)","返品","合計\n収入"]
[null,"品目 1",{"v":10,"d":"¥10.00"},{"v":1,"d":"¥1.00"},15,{"$f":"IFERROR(売り上げ!$E4*売り上げ!$C4*(1+売り上げ!$D4),0)","v":{"v":300,"d":"¥300.00"}},{"v":10,"d":"¥10.00"},{"v":5.75,"d":"¥5.75"},{"$f":"IFERROR(売り上げ!$C4*売り上げ!$D4+売り上げ!$G4-売り上げ!$H4,0)","v":{"v":14.25,"d":"¥14.25"}},2,{"$f":"IFERROR((売り上げ!$E4-売り上げ!$J4)*売り上げ!$I4+(売り上げ!$J4*売り上げ!$H4),0)","v":{"v":196.75,"d":"¥196.75"}}]
[null,"品目 2",{"v":11.5,"d":"¥11.50"},{"v":0.75,"d":"¥0.75"},18,{"$f":"IFERROR(売り上げ!$E5*売り上げ!$C5*(1+売り上げ!$D5),0)","v":{"v":362.25,"d":"¥362.25"}},{"v":10,"d":"¥10.00"},{"v":5.75,"d":"¥5.75"},{"$f":"IFERROR(売り上げ!$C5*売り上げ!$D5+売り上げ!$G5-売り上げ!$H5,0)","v":{"v":12.875,"d":"¥12.88"}},1,{"$f":"IFERROR((売り上げ!$E5-売り上げ!$J5)*売り上げ!$I5+(売り上げ!$J5*売り上げ!$H5),0)","v":{"v":224.625,"d":"¥224.63"}}]
[null,"品目 3",{"v":13,"d":"¥13.00"},{"v":0.65,"d":"¥0.65"},20,{"$f":"IFERROR(売り上げ!$E6*売り上げ!$C6*(1+売り上げ!$D6),0)","v":{"v":429,"d":"¥429.00"}},{"v":10,"d":"¥10.00"},{"v":6.25,"d":"¥6.25"},{"$f":"IFERROR(売り上げ!$C6*売り上げ!$D6+売り上げ!$G6-売り上げ!$H6,0)","v":{"v":12.200000000000003,"d":"¥12.20"}},0,{"$f":"IFERROR((売り上げ!$E6-売り上げ!$J6)*売り上げ!$I6+(売り上げ!$J6*売り上げ!$H6),0)","v":{"v":244.00000000000006,"d":"¥244.00"}}]
[null,"品目 4",{"v":5,"d":"¥5.00"},{"v":0.9,"d":"¥0.90"},50,{"$f":"IFERROR(売り上げ!$E7*売り上げ!$C7*(1+売り上げ!$D7),0)","v":{"v":475,"d":"¥475.00"}},{"v":5,"d":"¥5.00"},{"v":3.5,"d":"¥3.50"},{"$f":"IFERROR(売り上げ!$C7*売り上げ!$D7+売り上げ!$G7-売り上げ!$H7,0)","v":{"v":6,"d":"¥6.00"}},0,{"$f":"IFERROR((売り上げ!$E7-売り上げ!$J7)*売り上げ!$I7+(売り上げ!$J7*売り上げ!$H7),0)","v":{"v":300,"d":"¥300.00"}}]
[null,"品目 5",{"v":4,"d":"¥4.00"},{"v":0.9,"d":"¥0.90"},42,{"$f":"IFERROR(売り上げ!$E8*売り上げ!$C8*(1+売り上げ!$D8),0)","v":{"v":319.2,"d":"¥319.20"}},{"v":5,"d":"¥5.00"},{"v":3.25,"d":"¥3.25"},{"$f":"IFERROR(売り上げ!$C8*売り上げ!$D8+売り上げ!$G8-売り上げ!$H8,0)","v":{"v":5.35,"d":"¥5.35"}},3,{"$f":"IFERROR((売り上げ!$E8-売り上げ!$J8)*売り上げ!$I8+(売り上げ!$J8*売り上げ!$H8),0)","v":{"v":218.39999999999998,"d":"¥218.40"}}]
[null,"合計",{"$nulls":7},{"$f":"SUBTOTAL(109,売り上げ[返品])","v":6},{"$f":"SUBTOTAL(109,売り上げ[合計\n収入])","v":{"v":1183.775,"d":"¥1,183.78"}}]