谢谢您的回复：
- {"version":"9.40.20161.0","tabEditable":false,"newTabVisible":false,"sheets":{"开店损益表":{"name":"开店损益表","defaults":{"rowHeight":25,"colWidth":62,"rowHeaderColWidth":40,"colHeaderRowHeight":20},"columns":[{"size":130}],"rowCount":200,"columnCount":20,"activeRow":0,"activeCol":0,"theme":"Office2007","protectionOption":{"allowResizeColumns":true},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"data":{"dataTable":{"0":{"0":{"value":"项目/月份"},"1":{"value":"4月"},"2":{"value":"5月"},"3":{"value":"6月"},"4":{"value":"7月"},"5":{"value":"8月"},"6":{"value":"9月"},"7":{"value":"10月"},"8":{"value":"11月"},"9":{"value":"12月"},"10":{"value":"1月"},"11":{"value":"2月"},"12":{"value":"3月"},"13":{"value":"合计"},"14":{"value":"占比"}},"1":{"0":{"value":"吊牌金额"},"1":{"value":150609,"formula":"ROUND(B5/B4,0)"},"2":{"value":150609,"formula":"ROUND(C5/C4,0)"},"3":{"value":129093,"formula":"ROUND(D5/D4,0)"},"4":{"value":107578,"formula":"ROUND(E5/E4,0)"},"5":{"value":150609,"formula":"ROUND(F5/F4,0)"},"6":{"value":172124,"formula":"ROUND(G5/G4,0)"},"7":{"value":236670,"formula":"ROUND(H5/H4,0)"},"8":{"value":236670,"formula":"ROUND(I5/I4,0)"},"9":{"value":279701,"formula":"ROUND(J5/J4,0)"},"10":{"value":150609,"formula":"ROUND(K5/K4,0)"},"11":{"value":236670,"formula":"ROUND(L5/L4,0)"},"12":{"value":150609,"formula":"ROUND(M5/M4,0)"},"13":{"value":2151551,"formula":"SUM(B2:M2)"},"14":{"value":1,"formula":"IFERROR(N2/N$2,0)"}},"2":{"0":{"value":"销售折扣"},"1":{"value":30122,"formula":"ROUND(B2-B5,0)"},"2":{"value":30122,"formula":"ROUND(C2-C5,0)"},"3":{"value":25819,"formula":"ROUND(D2-D5,0)"},"4":{"value":21516,"formula":"ROUND(E2-E5,0)"},"5":{"value":30122,"formula":"ROUND(F2-F5,0)"},"6":{"value":34425,"formula":"ROUND(G2-G5,0)"},"7":{"value":47334,"formula":"ROUND(H2-H5,0)"},"8":{"value":47334,"formula":"ROUND(I2-I5,0)"},"9":{"value":55940,"formula":"ROUND(J2-J5,0)"},"10":{"value":30122,"formula":"ROUND(K2-K5,0)"},"11":{"value":47334,"formula":"ROUND(L2-L5,0)"},"12":{"value":30122,"formula":"ROUND(M2-M5,0)"},"13":{"value":430312,"formula":"SUM(B3:M3)"},"14":{"value":0.200000836605779,"formula":"IFERROR(N3/N$2,0)"}},"3":{"0":{"value":"折扣"},"1":{"value":0.8},"2":{"value":0.8},"3":{"value":0.8},"4":{"value":0.8},"5":{"value":0.8},"6":{"value":0.8},"7":{"value":0.8},"8":{"value":0.8},"9":{"value":0.8},"10":{"value":0.8},"11":{"value":0.8},"12":{"value":0.8}},"4":{"0":{"value":"含税销售净额(考核)"},"1":{"value":"120487"},"2":{"value":"120487"},"3":{"value":"103274"},"4":{"value":"86062"},"5":{"value":"120487"},"6":{"value":"137699"},"7":{"value":"189336"},"8":{"value":"189336"},"9":{"value":"223761"},"10":{"value":"120487"},"11":{"value":"189336"},"12":{"value":"120487"},"13":{"value":1721239,"formula":"SUM(B5:M5)"},"14":{"value":0.799999163394221,"formula":"IFERROR(N5/N$2,0)"}},"5":{"0":{"value":"含税销售净额(冲刺)"},"1":{"value":"168681"},"2":{"value":"168681"},"3":{"value":"144584"},"4":{"value":"120487"},"5":{"value":"168681"},"6":{"value":"192778"},"7":{"value":"265070"},"8":{"value":"265070"},"9":{"value":"313265"},"10":{"value":"168681"},"11":{"value":"265070"},"12":{"value":"168681"},"13":{"value":2409729,"formula":"SUM(B6:M6)"},"14":{"value":1.11999622597838,"formula":"IFERROR(N6/N$2,0)"}},"6":{"0":{"value":"扣点"},"1":{"value":0},"2":{"value":0},"3":{"value":0},"4":{"value":0},"5":{"value":0},"6":{"value":0},"7":{"value":0},"8":{"value":0},"9":{"value":0},"10":{"value":0},"11":{"value":0},"12":{"value":0},"13":{"value":0,"formula":"SUM(B7:M7)"},"14":{"value":0,"formula":"IFERROR(N7/N$2,0)"}},"7":{"0":{"value":"自买单"},"1":{"value":0.8},"2":{"value":0.8},"3":{"value":0.8},"4":{"value":0.8},"5":{"value":0.8},"6":{"value":0.8},"7":{"value":0.8},"8":{"value":0.8},"9":{"value":0.8},"10":{"value":0.8},"11":{"value":0.8},"12":{"value":0.8}},"8":{"0":{"value":"商场扣率额"},"1":{"value":0,"formula":"B7*B5"},"2":{"value":0,"formula":"C7*C5"},"3":{"value":0,"formula":"D7*D5"},"4":{"value":0,"formula":"E7*E5"},"5":{"value":0,"formula":"F7*F5"},"6":{"value":0,"formula":"G7*G5"},"7":{"value":0,"formula":"H7*H5"},"8":{"value":0,"formula":"I7*I5"},"9":{"value":0,"formula":"J7*J5"},"10":{"value":0,"formula":"K7*K5"},"11":{"value":0,"formula":"L7*L5"},"12":{"value":0,"formula":"M7*M5"},"13":{"value":0,"formula":"SUM(B9:M9)"},"14":{"value":0,"formula":"IFERROR(N9/N$2,0)"}},"9":{"0":{"value":"销售开票金额"},"1":{"value":30122,"formula":"B3-B9+B7"},"2":{"value":30122,"formula":"C3-C9+C7"},"3":{"value":25819,"formula":"D3-D9+D7"},"4":{"value":21516,"formula":"E3-E9+E7"},"5":{"value":30122,"formula":"F3-F9+F7"},"6":{"value":34425,"formula":"G3-G9+G7"},"7":{"value":47334,"formula":"H3-H9+H7"},"8":{"value":47334,"formula":"I3-I9+I7"},"9":{"value":55940,"formula":"J3-J9+J7"},"10":{"value":30122,"formula":"K3-K9+K7"},"11":{"value":47334,"formula":"L3-L9+L7"},"12":{"value":30122,"formula":"M3-M9+M7"},"13":{"value":430312,"formula":"SUM(B10:M10)"},"14":{"value":0.200000836605779,"formula":"IFERROR(N10/N$2,0)"}},"10":{"0":{"value":"销售税金"},"1":{"value":4377,"formula":"ROUND(B10/1.17*0.17,0)"},"2":{"value":4377,"formula":"ROUND(C10/1.17*0.17,0)"},"3":{"value":3751,"formula":"ROUND(D10/1.17*0.17,0)"},"4":{"value":3126,"formula":"ROUND(E10/1.17*0.17,0)"},"5":{"value":4377,"formula":"ROUND(F10/1.17*0.17,0)"},"6":{"value":5002,"formula":"ROUND(G10/1.17*0.17,0)"},"7":{"value":6878,"formula":"ROUND(H10/1.17*0.17,0)"},"8":{"value":6878,"formula":"ROUND(I10/1.17*0.17,0)"},"9":{"value":8128,"formula":"ROUND(J10/1.17*0.17,0)"},"10":{"value":4377,"formula":"ROUND(K10/1.17*0.17,0)"},"11":{"value":6878,"formula":"ROUND(L10/1.17*0.17,0)"},"12":{"value":4377,"formula":"ROUND(M10/1.17*0.17,0)"},"13":{"value":62526,"formula":"SUM(B11:M11)"},"14":{"value":0.0290608960698584,"formula":"IFERROR(N11/N$2,0)"}},"11":{"0":{"value":"净销售收入"},"1":{"value":25745,"formula":"B10-B11"},"2":{"value":25745,"formula":"C10-C11"},"3":{"value":22068,"formula":"D10-D11"},"4":{"value":18390,"formula":"E10-E11"},"5":{"value":25745,"formula":"F10-F11"},"6":{"value":29423,"formula":"G10-G11"},"7":{"value":40456,"formula":"H10-H11"},"8":{"value":40456,"formula":"I10-I11"},"9":{"value":47812,"formula":"J10-J11"},"10":{"value":25745,"formula":"K10-K11"},"11":{"value":40456,"formula":"L10-L11"},"12":{"value":25745,"formula":"M10-M11"},"13":{"value":367786,"formula":"SUM(B12:M12)"},"14":{"value":1,"formula":"IFERROR(N12/N$12,0)"}},"12":{"0":{"value":"产品销售成本"},"1":{"value":45054,"formula":"ROUND(B2*0.35/1.17,0)"},"2":{"value":45054,"formula":"ROUND(C2*0.35/1.17,0)"},"3":{"value":38618,"formula":"ROUND(D2*0.35/1.17,0)"},"4":{"value":32181,"formula":"ROUND(E2*0.35/1.17,0)"},"5":{"value":45054,"formula":"ROUND(F2*0.35/1.17,0)"},"6":{"value":51490,"formula":"ROUND(G2*0.35/1.17,0)"},"7":{"value":70799,"formula":"ROUND(H2*0.35/1.17,0)"},"8":{"value":70799,"formula":"ROUND(I2*0.35/1.17,0)"},"9":{"value":83671,"formula":"ROUND(J2*0.35/1.17,0)"},"10":{"value":45054,"formula":"ROUND(K2*0.35/1.17,0)"},"11":{"value":70799,"formula":"ROUND(L2*0.35/1.17,0)"},"12":{"value":45054,"formula":"ROUND(M2*0.35/1.17,0)"},"13":{"value":643627,"formula":"SUM(B13:M13)"},"14":{"value":1.75000407845867,"formula":"IFERROR(N13/N$12,0)"}},"13":{"0":{"value":"产品销售毛利小计(考核)"},"1":{"value":57926,"formula":"ROUND(B5/1.17-B13,0)"},"2":{"value":57926,"formula":"ROUND(C5/1.17-C13,0)"},"3":{"value":49650,"formula":"ROUND(D5/1.17-D13,0)"},"4":{"value":41376,"formula":"ROUND(E5/1.17-E13,0)"},"5":{"value":57926,"formula":"ROUND(F5/1.17-F13,0)"},"6":{"value":66201,"formula":"ROUND(G5/1.17-G13,0)"},"7":{"value":91027,"formula":"ROUND(H5/1.17-H13,0)"},"8":{"value":91027,"formula":"ROUND(I5/1.17-I13,0)"},"9":{"value":107578,"formula":"ROUND(J5/1.17-J13,0)"},"10":{"value":57926,"formula":"ROUND(K5/1.17-K13,0)"},"11":{"value":91027,"formula":"ROUND(L5/1.17-L13,0)"},"12":{"value":57926,"formula":"ROUND(M5/1.17-M13,0)"},"13":{"value":827516,"formula":"SUM(B14:M14)"},"14":{"value":2.24999320256889,"formula":"IFERROR(N14/N$12,0)"}},"14":{"0":{"value":"产品销售毛利小计(冲刺)"},"1":{"value":99118,"formula":"ROUND(B6/1.17-B13,0)"},"2":{"value":99118,"formula":"ROUND(C6/1.17-C13,0)"},"3":{"value":84958,"formula":"ROUND(D6/1.17-D13,0)"},"4":{"value":70799,"formula":"ROUND(E6/1.17-E13,0)"},"5":{"value":99118,"formula":"ROUND(F6/1.17-F13,0)"},"6":{"value":113278,"formula":"ROUND(G6/1.17-G13,0)"},"7":{"value":155757,"formula":"ROUND(H6/1.17-H13,0)"},"8":{"value":155757,"formula":"ROUND(I6/1.17-I13,0)"},"9":{"value":184077,"formula":"ROUND(J6/1.17-J13,0)"},"10":{"value":99118,"formula":"ROUND(K6/1.17-K13,0)"},"11":{"value":155757,"formula":"ROUND(L6/1.17-L13,0)"},"12":{"value":99118,"formula":"ROUND(M6/1.17-M13,0)"},"13":{"value":1415973,"formula":"SUM(B15:M15)"},"14":{"value":3.84999157118542,"formula":"IFERROR(N15/N$12,0)"}},"15":{"0":{"value":"工资"},"1":{"value":10550},"2":{"value":11670},"3":{"value":9429},"4":{"value":9429},"5":{"value":9429},"6":{"value":9429},"7":{"value":13912},"8":{"value":9429},"9":{"value":9429},"10":{"value":10550},"11":{"value":12791},"12":{"value":9429},"13":{"value":125476,"formula":"SUM(B16:M16)"},"14":{"value":0.341165786625918,"formula":"IFERROR(N16/N$12,0)"}},"16":{"0":{"value":"提成奖金"},"1":{"value":7800},"2":{"value":7800},"3":{"value":7200},"4":{"value":6600},"5":{"value":7800},"6":{"value":10300},"7":{"value":12400},"8":{"value":12400},"9":{"value":13300},"10":{"value":9400},"11":{"value":12400},"12":{"value":7800},"13":{"value":115200,"formula":"SUM(B17:M17)"},"14":{"value":0.313225625771508,"formula":"IFERROR(N17/N$12,0)"}},"17":{"0":{"value":"社保"},"1":{"value":3200},"2":{"value":3200},"3":{"value":3200},"4":{"value":3200},"5":{"value":3200},"6":{"value":3200},"7":{"value":3200},"8":{"value":3200},"9":{"value":3200},"10":{"value":3200},"11":{"value":3200},"12":{"value":3200},"13":{"value":38400,"formula":"SUM(B18:M18)"},"14":{"value":0.104408541923836,"formula":"IFERROR(N18/N$12,0)"}},"18":{"0":{"value":"公积金"},"13":{"value":0,"formula":"SUM(B19:M19)"},"14":{"value":0,"formula":"IFERROR(N19/N$12,0)"}},"19":{"0":{"value":"办公费"},"1":{"value":710},"2":{"value":100},"3":{"value":100},"4":{"value":100},"5":{"value":100},"6":{"value":100},"7":{"value":100},"8":{"value":100},"9":{"value":100},"10":{"value":100},"11":{"value":100},"12":{"value":100},"13":{"value":1810,"formula":"SUM(B20:M20)"},"14":{"value":0.00492134012713915,"formula":"IFERROR(N20/N$12,0)"}},"20":{"0":{"value":"差旅费"},"1":{"value":200},"2":{"value":200},"3":{"value":200},"4":{"value":200},"5":{"value":200},"6":{"value":200},"7":{"value":200},"8":{"value":200},"9":{"value":200},"10":{"value":200},"11":{"value":200},"12":{"value":200},"13":{"value":2400,"formula":"SUM(B21:M21)"},"14":{"value":0.00652553387023976,"formula":"IFERROR(N21/N$12,0)"}},"21":{"0":{"value":"通讯费"},"1":{"value":1300},"13":{"value":1300,"formula":"SUM(B22:M22)"},"14":{"value":0.0035346641797132,"formula":"IFERROR(N22/N$12,0)"}},"22":{"0":{"value":"水电费"},"1":{"value":4000},"2":{"value":4000},"3":{"value":4000},"4":{"value":4000},"5":{"value":4000},"6":{"value":4000},"7":{"value":4000},"8":{"value":4000},"9":{"value":4000},"10":{"value":4000},"11":{"value":4000},"12":{"value":4000},"13":{"value":48000,"formula":"SUM(B23:M23)"},"14":{"value":0.130510677404795,"formula":"IFERROR(N23/N$12,0)"}},"23":{"0":{"value":"修理费"},"1":{"value":50},"2":{"value":50},"3":{"value":50},"4":{"value":50},"5":{"value":50},"6":{"value":50},"7":{"value":50},"8":{"value":50},"9":{"value":50},"10":{"value":50},"11":{"value":50},"12":{"value":50},"13":{"value":600,"formula":"SUM(B24:M24)"},"14":{"value":0.00163138346755994,"formula":"IFERROR(N24/N$12,0)"}},"24":{"0":{"value":"低值易耗品"},"1":{"value":2054},"2":{"value":0},"3":{"value":0},"4":{"value":0},"5":{"value":0},"6":{"value":0},"7":{"value":0},"8":{"value":0},"9":{"value":0},"10":{"value":0},"11":{"value":0},"12":{"value":0},"13":{"value":2054,"formula":"SUM(B25:M25)"},"14":{"value":0.00558476940394686,"formula":"IFERROR(N25/N$12,0)"}},"25":{"0":{"value":"租金/抽成"},"13":{"value":0,"formula":"SUM(B26:M26)"},"14":{"value":0,"formula":"IFERROR(N26/N$12,0)"}},"26":{"0":{"value":"物业管理费"},"1":{"value":600},"2":{"value":600},"3":{"value":600},"4":{"value":600},"5":{"value":600},"6":{"value":600},"7":{"value":600},"8":{"value":600},"9":{"value":600},"10":{"value":600},"11":{"value":600},"12":{"value":600},"13":{"value":7200,"formula":"SUM(B27:M27)"},"14":{"value":0.0195766016107193,"formula":"IFERROR(N27/N$12,0)"}},"27":{"0":{"value":"保底费用"},"1":{"value":20000},"2":{"value":20000},"3":{"value":20000},"4":{"value":20000},"5":{"value":20000},"6":{"value":20000},"7":{"value":20000},"8":{"value":20000},"9":{"value":20000},"10":{"value":20000},"11":{"value":20000},"12":{"value":20000},"13":{"value":240000,"formula":"SUM(B28:M28)"},"14":{"value":0.652553387023976,"formula":"IFERROR(N28/N$12,0)"}},"28":{"0":{"value":"商场费用"},"1":{"value":3524},"2":{"value":2024},"3":{"value":1878},"4":{"value":1732},"5":{"value":2024},"6":{"value":2170},"7":{"value":2609},"8":{"value":2609},"9":{"value":2902},"10":{"value":2024},"11":{"value":2609},"12":{"value":2024},"13":{"value":28129,"formula":"SUM(B29:M29)"},"14":{"value":0.0764819759316559,"formula":"IFERROR(N29/N$12,0)"}},"29":{"0":{"value":"装修费"},"1":{"value":0},"2":{"value":0},"3":{"value":0},"4":{"value":0},"5":{"value":0},"6":{"value":0},"7":{"value":0},"8":{"value":0},"9":{"value":0},"10":{"value":0},"11":{"value":0},"12":{"value":0},"13":{"value":0,"formula":"SUM(B30:M30)"},"14":{"value":0,"formula":"IFERROR(N30/N$12,0)"}},"30":{"0":{"value":"折旧费"},"13":{"value":0,"formula":"SUM(B31:M31)"},"14":{"value":0,"formula":"IFERROR(N31/N$12,0)"}},"31":{"0":{"value":"小计"},"1":{"value":53988,"formula":"SUM(B16:B31)"},"2":{"value":49644,"formula":"SUM(C16:C31)"},"3":{"value":46657,"formula":"SUM(D16:D31)"},"4":{"value":45911,"formula":"SUM(E16:E31)"},"5":{"value":47403,"formula":"SUM(F16:F31)"},"6":{"value":50049,"formula":"SUM(G16:G31)"},"7":{"value":57071,"formula":"SUM(H16:H31)"},"8":{"value":52588,"formula":"SUM(I16:I31)"},"9":{"value":53781,"formula":"SUM(J16:J31)"},"10":{"value":50124,"formula":"SUM(K16:K31)"},"11":{"value":55950,"formula":"SUM(L16:L31)"},"12":{"value":47403,"formula":"SUM(M16:M31)"},"13":{"value":610569,"formula":"SUM(B32:M32)"},"14":{"value":1.66012028734101,"formula":"IFERROR(N32/N$12,0)"}},"32":{"0":{"value":"店铺利润(考核)"},"1":{"value":3938,"formula":"B14-B32"},"2":{"value":8282,"formula":"C14-C32"},"3":{"value":2993,"formula":"D14-D32"},"4":{"value":-4535,"formula":"E14-E32"},"5":{"value":10523,"formula":"F14-F32"},"6":{"value":16152,"formula":"G14-G32"},"7":{"value":33956,"formula":"H14-H32"},"8":{"value":38439,"formula":"I14-I32"},"9":{"value":53797,"formula":"J14-J32"},"10":{"value":7802,"formula":"K14-K32"},"11":{"value":35077,"formula":"L14-L32"},"12":{"value":10523,"formula":"M14-M32"},"13":{"value":216947,"formula":"SUM(B33:M33)"},"14":{"value":0.589872915227877,"formula":"IFERROR(N33/N$12,0)"}},"33":{"0":{"value":"店铺利润(冲刺)"},"1":{"value":45130,"formula":"B15-B32"},"2":{"value":49474,"formula":"C15-C32"},"3":{"value":38301,"formula":"D15-D32"},"4":{"value":24888,"formula":"E15-E32"},"5":{"value":51715,"formula":"F15-F32"},"6":{"value":63229,"formula":"G15-G32"},"7":{"value":98686,"formula":"H15-H32"},"8":{"value":103169,"formula":"I15-I32"},"9":{"value":130296,"formula":"J15-J32"},"10":{"value":48994,"formula":"K15-K32"},"11":{"value":99807,"formula":"L15-L32"},"12":{"value":51715,"formula":"M15-M32"},"13":{"value":805404,"formula":"SUM(B34:M34)"},"14":{"value":2.18987128384441,"formula":"IFERROR(N34/N$12,0)"}}},"defaultDataNode":{"style":{"hAlign":1,"vAlign":1,"font":"13.3333px "Comic Sans MS""}}},"index":0}}}
上面是我的json字符串，看到回复之后，我修改了代码，
如下：
var spreadst = new GcSpread.Sheets.Spread($("#statement1")[0]);
var jsonstr = @Model.StatementJson;
spreadst.fromJSON(JSON.parse(jsonstr));
但是还是报各种未知的 js错误，例如：
Uncaught SyntaxError: Unexpected token &
，我查了，我的JSON字符串中并没有&字符。 |
陕公网安备：61019002000258 |
隐私政策 |
网站地图