{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["发票","客户","发票 - 主要","发票详细信息","关于此发票跟踪表"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"发票","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"merged":[[1,1,1,2],[1,3,1,4],[1,5,1,6],[2,1,2,2],[2,3,2,4],[2,5,2,6],[3,3,3,4],[4,3,4,4],[5,3,5,4],[37,1,37,4],[38,1,38,4]]}
[null,"公司名称"]
[null,"街道地址",null,"电话：电话号码",null,"电子邮件"]
[null,"省/市/自治区，市/县  邮政编码",null,"传真：传真号码",null,"网站"]
[null,"受票方：",{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngInvoice,发票主要[],2,FALSE),CustomerList[],3,TRUE),\"\")","v":"Contoso, Ltd"},{"$f":"\"电话：\"&IFERROR(VLOOKUP(VLOOKUP(rngInvoice,发票主要[],2,FALSE),CustomerList[],9,FALSE),\"\")","v":"电话：432-555-0189"},null,"发票编号：","3-456-2"]
[null,"地址：",{"$f":"IFERROR(IF((VLOOKUP(VLOOKUP(rngInvoice,发票主要[],2,FALSE),CustomerList[],5,FALSE))=\"\",\"\",(VLOOKUP(VLOOKUP(rngInvoice,发票主要[],2,FALSE),CustomerList[],5,FALSE))),\"\")","v":"核桃巷 567 号"},{"$f":"\"传真：\"&IFERROR(VLOOKUP(VLOOKUP(rngInvoice,发票主要[],2,FALSE),CustomerList[],11,FALSE),\"\")","v":"传真：432-555-0123"},null,"发票日期：",{"$f":"IFERROR(IF(VLOOKUP(rngInvoice,发票主要[],3,FALSE)=\"\",\"\",VLOOKUP(rngInvoice,发票主要[],3,FALSE)),\"\")","v":"2019-09-12"}]
[null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngInvoice,发票主要[],2,FALSE),CustomerList[],6,FALSE)&\", \"& VLOOKUP(VLOOKUP(G4,发票主要[],2,FALSE),CustomerList[],7,FALSE)&\" \"&VLOOKUP(VLOOKUP(G4,发票主要[],2,FALSE),CustomerList[],8,FALSE),\"\")","v":"莫林, MO 098765"},{"$f":"\"电子邮件：\"&IFERROR(VLOOKUP(VLOOKUP(rngInvoice,发票主要[],2,FALSE),CustomerList[],10,FALSE),\"\")","v":"电子邮件：someone@example.com"}]
[null,{"$f":"\"发票事由：\"&IFERROR(VLOOKUP(rngInvoice,发票主要[],4),\"\")","v":"发票事由：项目 2"}]
[null,"项目编号","说明","数量","单位价格","折扣","价格"]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(1:1)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":"Z4567"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(1:1)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":"发票 3-456-2 数据 1"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(1:1)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":39},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(1:1)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":5,"d":"¥5.00"}},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(1:1)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":0},{"$f":"IFERROR((D9*E9)-F9,\"\")","v":{"v":195,"d":"¥195.00"}}]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(2:2)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":"Z4568"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(2:2)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":"发票 3-456-2 数据 2"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(2:2)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":40},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(2:2)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":4,"d":"¥4.00"}},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(2:2)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":5,"d":"¥5.00"}},{"v":155,"d":"¥155.00"}]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(3:3)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":"Z4569"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(3:3)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":"发票 3-456-2 数据 3"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(3:3)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":30},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(3:3)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":6,"d":"¥6.00"}},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(3:3)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":7,"d":"¥7.00"}},{"v":173,"d":"¥173.00"}]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(4:4)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":"Z4570"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(4:4)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":"发票 3-456-2 数据 4"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(4:4)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":40},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(4:4)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":7,"d":"¥7.00"}},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(4:4)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":0},{"v":280,"d":"¥280.00"}]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(5:5)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":"Z4571"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(5:5)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":"发票 3-456-2 数据 5"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(5:5)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":10},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(5:5)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":4,"d":"¥4.00"}},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(5:5)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":0},{"v":40,"d":"¥40.00"}]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(6:6)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":"Z4572"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(6:6)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":"发票 3-456-2 数据 6"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(6:6)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":5},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(6:6)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":8,"d":"¥8.00"}},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(6:6)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":0},{"v":40,"d":"¥40.00"}]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(7:7)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":"Z4573"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(7:7)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":"发票 3-456-2 数据 7"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(7:7)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":70},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(7:7)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":6,"d":"¥6.00"}},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(7:7)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":0},{"v":420,"d":"¥420.00"}]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(8:8)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":"Z4574"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(8:8)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":"发票 3-456-2 数据 8"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(8:8)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":25},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(8:8)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":4,"d":"¥4.00"}},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(8:8)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":0},{"v":100,"d":"¥100.00"}]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(9:9)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":"Z4575"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(9:9)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":"发票 3-456-2 数据 9"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(9:9)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":5},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(9:9)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":7,"d":"¥7.00"}},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(9:9)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":3,"d":"¥3.00"}},{"v":32,"d":"¥32.00"}]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(10:10)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":"Z4576"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(10:10)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":"发票 3-456-2 数据 10"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(10:10)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":80},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(10:10)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":1,"d":"¥1.00"}},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(10:10)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":0},{"v":80,"d":"¥80.00"}]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(11:11)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":"Z4577"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(11:11)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":"发票 3-456-2 数据 11"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(11:11)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":65},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(11:11)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":7,"d":"¥7.00"}},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(11:11)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":0},{"v":455,"d":"¥455.00"}]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(12:12)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":"Z4578"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(12:12)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":"发票 3-456-2 数据 12"},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(12:12)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":44},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(12:12)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":{"v":1,"d":"¥1.00"}},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(12:12)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":0},{"v":44,"d":"¥44.00"}]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(13:13)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(13:13)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(13:13)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(13:13)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(13:13)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(14:14)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(14:14)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(14:14)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(14:14)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(14:14)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(15:15)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(15:15)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(15:15)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(15:15)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(15:15)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(16:16)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(16:16)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(16:16)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(16:16)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(16:16)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(17:17)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(17:17)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(17:17)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(17:17)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(17:17)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(18:18)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(18:18)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(18:18)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(18:18)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(18:18)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(19:19)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(19:19)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(19:19)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(19:19)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(19:19)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(20:20)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(20:20)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(20:20)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(20:20)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(20:20)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(21:21)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(21:21)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(21:21)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(21:21)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(21:21)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(22:22)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(22:22)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(22:22)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(22:22)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(22:22)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(23:23)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(23:23)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(23:23)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(23:23)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(23:23)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(24:24)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(24:24)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(24:24)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(24:24)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(24:24)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(25:25)), MATCH($B$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(25:25)), MATCH($C$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(25:25)), MATCH($D$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(25:25)), MATCH($E$8, 发票详细信息[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(发票详细信息[],SMALL(IF(发票详细信息[发票编号]=rngInvoice,ROW(发票详细信息[])-ROW(发票详细信息[#Headers])), ROW(25:25)), MATCH($F$8, 发票详细信息[#Headers], 0)),\"\")","v":""},""]
[{"$nulls":5},"发票小计",{"$f":"SUM(ProjectInvoice[价格])","v":{"v":2014,"d":"¥2,014.00"}}]
[{"$nulls":5},"税率",{"$f":"VLOOKUP(rngInvoice,发票主要[],5)","v":{"v":0.0875,"d":"8.75%"}}]
[{"$nulls":5},"销售税",{"$f":"G34*G35","v":{"v":176.225,"d":"¥176.23"}}]
[{"$nulls":5},"其他",{"$f":"VLOOKUP(rngInvoice,发票主要[],6)","v":0}]
[null,{"$f":"\"所有支票支付给\"&公司名称&\".\"","v":"所有支票支付给公司名称."},{"$nulls":3},"收到的存款",{"$f":"VLOOKUP(rngInvoice,发票主要[],7)","v":0}]
[null,"应付款总额期限为 <#> 天。逾期帐款收取每月 <#>% 的服务费。",{"$nulls":3},"汇总",{"$f":"(G34+G36+G37)-G38","v":{"v":2190.225,"d":"¥2,190.23"}}]

{"sheet":"客户","index":1,"n_rows":6,"n_cols":12,"rows_kept":6}
[]
[null,null,"客户"]
[null,"查找","公司编号","公司名称","联系人姓名","地址","城市","省/市/自治区","邮政编码","电话","电子邮件","传真"]
[null,{"$f":"C4& \" - \"&D4","v":"1 - Tailspin Toys "},1,"Tailspin Toys ","米申","樱桃街 345 号","奥尔巴尼","SD","123456","432-555-0178","someone@example.com","432-555-0187"]
[null,"2 - Contoso, Ltd",2,"Contoso, Ltd","黄琏","核桃巷 567 号","莫林","MO","098765","432-555-0189","someone@example.com","432-555-0123"]
[null,"合计",{"$f":"\"总客户数：\"&SUBTOTAL(103,CustomerList[公司编号])","v":"总客户数：2"}]

{"sheet":"发票 - 主要","index":2,"n_rows":6,"n_cols":11,"rows_kept":6}
[]
[null,"发票"]
[null,"发票编号","公司","发票日期","项目描述","税率","其他","存款","详细信息总计","发票总计","备注"]
[null,"3-456-1","1 - Tailspin Toys ",{"$f":"TODAY()","v":"2019-09-02"},"项目 1",{"v":0.0875,"d":"8.75%"},{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"$f":"SUMIF(发票详细信息[发票编号],\"=\"&发票主要[[#This Row],[发票编号]],发票详细信息[汇总])","v":{"v":5200,"d":"¥5,200.00"}},{"$f":"(发票主要[[#This Row],[详细信息总计]]*(1+发票主要[[#This Row],[税率]]))+发票主要[[#This Row],[其他]]-发票主要[[#This Row],[存款]]","v":{"v":5654.999999999999,"d":"¥5,655.00"}}]
[null,"3-456-2","2 - Contoso, Ltd",{"$f":"TODAY()+10","v":"2019-09-12"},"项目 2",{"v":0.0875,"d":"8.75%"},null,null,{"$f":"SUMIF(发票详细信息[发票编号],\"=\"&发票主要[[#This Row],[发票编号]],发票详细信息[汇总])","v":{"v":2014,"d":"¥2,014.00"}},{"$f":"(发票主要[[#This Row],[详细信息总计]]*(1+发票主要[[#This Row],[税率]]))+发票主要[[#This Row],[其他]]-发票主要[[#This Row],[存款]]","v":{"v":2190.225,"d":"¥2,190.23"}}]
[null,"合计",{"$f":"\"发票总数：\"&SUBTOTAL(103,发票主要[发票编号])","v":"发票总数：2"},{"$nulls":3},{"$f":"SUBTOTAL(109,发票主要[其他])","v":{"v":100,"d":"¥100.00"}},{"$f":"SUBTOTAL(109,发票主要[存款])","v":{"v":100,"d":"¥100.00"}},{"$f":"SUBTOTAL(109,发票主要[详细信息总计])","v":{"v":7214,"d":"¥7,214.00"}},{"$f":"SUBTOTAL(109,发票主要[发票总计])","v":{"v":7845.2249999999985,"d":"¥7,845.23"}}]

{"sheet":"发票详细信息","index":3,"n_rows":40,"n_cols":8,"rows_kept":40}
[]
[null,"发票详细信息"]
[null,"说明","发票编号","项目编号","数量","单位价格","折扣","汇总"]
[null,"发票 3-456-1 数据 1","3-456-1",1,{"v":1,"d":"1 "},{"v":1,"d":"¥1.00"},{"v":1,"d":"¥1.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":0,"d":"¥0.00"}}]
[null,"发票 3-456-1 数据 2","3-456-1",2,{"v":2,"d":"2 "},{"v":2,"d":"¥2.00"},{"v":2,"d":"¥2.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":2,"d":"¥2.00"}}]
[null,"发票 3-456-1 数据 3","3-456-1",3,{"v":3,"d":"3 "},{"v":3,"d":"¥3.00"},{"v":3,"d":"¥3.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":6,"d":"¥6.00"}}]
[null,"发票 3-456-1 数据 4","3-456-1",4,{"v":4,"d":"4 "},{"v":4,"d":"¥4.00"},{"v":4,"d":"¥4.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":12,"d":"¥12.00"}}]
[null,"发票 3-456-1 数据 5","3-456-1",5,{"v":5,"d":"5 "},{"v":5,"d":"¥5.00"},{"v":5,"d":"¥5.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":20,"d":"¥20.00"}}]
[null,"发票 3-456-1 数据 6","3-456-1",6,{"v":6,"d":"6 "},{"v":6,"d":"¥6.00"},{"v":6,"d":"¥6.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":30,"d":"¥30.00"}}]
[null,"发票 3-456-1 数据 7","3-456-1",7,{"v":7,"d":"7 "},{"v":7,"d":"¥7.00"},{"v":7,"d":"¥7.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":42,"d":"¥42.00"}}]
[null,"发票 3-456-1 数据 8","3-456-1",8,{"v":8,"d":"8 "},{"v":8,"d":"¥8.00"},{"v":8,"d":"¥8.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":56,"d":"¥56.00"}}]
[null,"发票 3-456-1 数据 9","3-456-1",9,{"v":9,"d":"9 "},{"v":9,"d":"¥9.00"},{"v":9,"d":"¥9.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":72,"d":"¥72.00"}}]
[null,"发票 3-456-1 数据 10","3-456-1",10,{"v":10,"d":"10 "},{"v":10,"d":"¥10.00"},{"v":10,"d":"¥10.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":90,"d":"¥90.00"}}]
[null,"发票 3-456-1 数据 11","3-456-1",11,{"v":11,"d":"11 "},{"v":11,"d":"¥11.00"},{"v":11,"d":"¥11.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":110,"d":"¥110.00"}}]
[null,"发票 3-456-1 数据 12","3-456-1",12,{"v":12,"d":"12 "},{"v":12,"d":"¥12.00"},{"v":12,"d":"¥12.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":132,"d":"¥132.00"}}]
[null,"发票 3-456-1 数据 13","3-456-1",13,{"v":13,"d":"13 "},{"v":13,"d":"¥13.00"},{"v":13,"d":"¥13.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":156,"d":"¥156.00"}}]
[null,"发票 3-456-1 数据 14","3-456-1",14,{"v":14,"d":"14 "},{"v":14,"d":"¥14.00"},{"v":14,"d":"¥14.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":182,"d":"¥182.00"}}]
[null,"发票 3-456-1 数据 15","3-456-1",15,{"v":15,"d":"15 "},{"v":15,"d":"¥15.00"},{"v":15,"d":"¥15.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":210,"d":"¥210.00"}}]
[null,"发票 3-456-1 数据 16","3-456-1",16,{"v":16,"d":"16 "},{"v":16,"d":"¥16.00"},{"v":16,"d":"¥16.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":240,"d":"¥240.00"}}]
[null,"发票 3-456-1 数据 17","3-456-1",17,{"v":17,"d":"17 "},{"v":17,"d":"¥17.00"},{"v":17,"d":"¥17.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":272,"d":"¥272.00"}}]
[null,"发票 3-456-1 数据 18","3-456-1",18,{"v":18,"d":"18 "},{"v":18,"d":"¥18.00"},{"v":18,"d":"¥18.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":306,"d":"¥306.00"}}]
[null,"发票 3-456-1 数据 19","3-456-1",19,{"v":19,"d":"19 "},{"v":19,"d":"¥19.00"},{"v":19,"d":"¥19.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":342,"d":"¥342.00"}}]
[null,"发票 3-456-1 数据 20","3-456-1",20,{"v":20,"d":"20 "},{"v":20,"d":"¥20.00"},{"v":20,"d":"¥20.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":380,"d":"¥380.00"}}]
[null,"发票 3-456-1 数据 21","3-456-1",21,{"v":21,"d":"21 "},{"v":21,"d":"¥21.00"},{"v":21,"d":"¥21.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":420,"d":"¥420.00"}}]
[null,"发票 3-456-1 数据 22","3-456-1",22,{"v":22,"d":"22 "},{"v":22,"d":"¥22.00"},{"v":22,"d":"¥22.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":462,"d":"¥462.00"}}]
[null,"发票 3-456-1 数据 23","3-456-1",23,{"v":23,"d":"23 "},{"v":23,"d":"¥23.00"},{"v":23,"d":"¥23.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":506,"d":"¥506.00"}}]
[null,"发票 3-456-1 数据 24","3-456-1",24,{"v":24,"d":"24 "},{"v":24,"d":"¥24.00"},{"v":24,"d":"¥24.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":552,"d":"¥552.00"}}]
[null,"发票 3-456-1 数据 25","3-456-1",25,{"v":25,"d":"25 "},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":600,"d":"¥600.00"}}]
[null,"发票 3-456-2 数据 1","3-456-2","Z4567",{"v":39,"d":"39 "},{"v":5,"d":"¥5.00"},null,{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":195,"d":"¥195.00"}}]
[null,"发票 3-456-2 数据 2","3-456-2","Z4568",{"v":40,"d":"40 "},{"v":4,"d":"¥4.00"},{"v":5,"d":"¥5.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":155,"d":"¥155.00"}}]
[null,"发票 3-456-2 数据 3","3-456-2","Z4569",{"v":30,"d":"30 "},{"v":6,"d":"¥6.00"},{"v":7,"d":"¥7.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":173,"d":"¥173.00"}}]
[null,"发票 3-456-2 数据 4","3-456-2","Z4570",{"v":40,"d":"40 "},{"v":7,"d":"¥7.00"},null,{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":280,"d":"¥280.00"}}]
[null,"发票 3-456-2 数据 5","3-456-2","Z4571",{"v":10,"d":"10 "},{"v":4,"d":"¥4.00"},null,{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":40,"d":"¥40.00"}}]
[null,"发票 3-456-2 数据 6","3-456-2","Z4572",{"v":5,"d":"5 "},{"v":8,"d":"¥8.00"},null,{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":40,"d":"¥40.00"}}]
[null,"发票 3-456-2 数据 7","3-456-2","Z4573",{"v":70,"d":"70 "},{"v":6,"d":"¥6.00"},null,{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":420,"d":"¥420.00"}}]
[null,"发票 3-456-2 数据 8","3-456-2","Z4574",{"v":25,"d":"25 "},{"v":4,"d":"¥4.00"},null,{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":100,"d":"¥100.00"}}]
[null,"发票 3-456-2 数据 9","3-456-2","Z4575",{"v":5,"d":"5 "},{"v":7,"d":"¥7.00"},{"v":3,"d":"¥3.00"},{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":32,"d":"¥32.00"}}]
[null,"发票 3-456-2 数据 10","3-456-2","Z4576",{"v":80,"d":"80 "},{"v":1,"d":"¥1.00"},null,{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":80,"d":"¥80.00"}}]
[null,"发票 3-456-2 数据 11","3-456-2","Z4577",{"v":65,"d":"65 "},{"v":7,"d":"¥7.00"},null,{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":455,"d":"¥455.00"}}]
[null,"发票 3-456-2 数据 12","3-456-2","Z4578",{"v":44,"d":"44 "},{"v":1,"d":"¥1.00"},null,{"$f":"(发票详细信息[[#This Row],[数量]]*发票详细信息[[#This Row],[单位价格]])-发票详细信息[[#This Row],[折扣]]","v":{"v":44,"d":"¥44.00"}}]

{"sheet":"关于此发票跟踪表","index":4,"n_rows":40,"n_cols":3,"rows_kept":40,"merged":[[3,1,3,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,2,7,7],[8,2,8,7],[9,2,9,7],[10,2,10,7],[11,2,11,7],[12,1,12,7],[13,2,13,3],[14,2,14,7],[15,1,15,7],[16,2,16,7],[17,2,17,7],[18,2,18,7],[19,2,19,7],[20,2,20,7],[21,2,21,7],[22,1,22,7],[23,1,23,7],[24,2,24,7],[25,2,25,7],[26,2,26,7],[27,2,27,7],[28,1,28,7],[29,1,29,7],[30,2,30,7],[31,2,31,7],[32,2,32,7],[33,2,33,7],[34,2,34,7],[36,2,36,7],[37,2,37,7],[38,2,38,7],[39,2,39,7]]}
[null,"关于此发票跟踪表"]
[]
[]
[null,"该发票跟踪表旨在维护客户、发票和发票详细信息的历史记录，以便无需创建多个文件即可存储多张发票。还可以使用“发票跟踪表”来分析以前所开发票的数据。例如，可以查看某一客户、特定项目的所有发票，也可以查看上个月、上一年的所有发票等。"]
[null,"在开始之前，请查看提供的示例数据。在“发票”工作表中，选择发票编号单元格右侧的单元格（单元格 L8），随即会出现一个下拉列表。选择下拉箭头，然后选择一个示例发票。请注意所有发票信息会如何自动进行更改，从而反映所选发票。现在，请查看工作表“客户”、“发票 - 主要”和“发票详细信息”。这些工作表中的每一个表都会向发票提供信息，而你所做的任何更改都将自动更新。 "]
[null,"如何入门？"]
[null,"采用以下步骤修改“发票”工作表，使其反映贵公司的信息："]
[null,"1.","导航到“发票”工作表的“审阅”选项卡，在“保护”组中，选择“撤销工作表保护”。 "]
[null,null,"注意：发票页处于受保护状态有助于避免意外更改，因为正如前文所述，该页上的大多数数据都提取自工作簿中的所有其他工作表。 "]
[null,"2.","通过键入公司名称、街道地址、城市、电子邮件地址、网站等，自定义发票抬头。在发票底部（第 43 行），修改付款说明。 "]
[null,null,"重要提示！请勿修改账单信息或发票信息。所有这些单元格都具有自动更新发票的公式，如“关于发票跟踪表”部分中所述。  "]
[null,"3.","（可选）修改整个工作簿的颜色：在“页面布局”选项卡的“主题”组中，选择“颜色”，并从颜色库中选择另一种主题颜色集。 "]
[null,"提示：创建与贵公司品牌打造相符的自定义主题颜色集！为此，请在“页面布局”选项卡上的“主题”组中，选择“颜色”，然后选择“自定义颜色”。有关创建自定义颜色集的详细信息，请查阅下面的帮助主题： "]
[null,null,"自定义文档主题。"]
[null,"4.","执行所需更改后，请返回到“发票”工作表中，并在“审阅”选项卡上的“更改”组中，选择“保护工作表”，然后选择“确定”。发票工作表处于受保护状态时，唯一可选择的单元格是含有“发票编号”下拉列表的单元格。"]
[null,"如何创建发票？"]
[null,"1.","在“客户”工作表中，输入公司名称和地址等客户信息。请注意，公司编号是很重要的条目，因为该编号为整个发票跟踪表中所使用的每个公司都提供了唯一标识符。另请注意，公司只需添加一次即可。对于同一公司的后续发票，可跳过此步骤。 "]
[null,null,"注意：如果将同一号码分配给多个公司或多次输入同一个公司名称，条目将变为红色，提醒你存在重复。 "]
[null,"2.","在“发票 - 主要”工作表上，输入发票的主要信息，例如发票编号、发票日期和项目描述。与公司编号类似，发票编号是一个重要条目，因为该编号可为每张发票提供唯一标识符，并在整个发票跟踪表中得到使用。另一个重要的条目是“公司”。从提供的下拉列表中选择公司后，可以将发票与该公司进行关联。此后，在“发票”工作表上选择发票编号时，该公司的信息（如公司名称和地址）将自动填充在发票上。"]
[null,null,"注意：如果将同一号码分配给多张发票，条目将变为红色，提醒你存在重复。 "]
[null,"3.","在“发票详细信息”工作表上，输入发票的详细信息，例如项目说明、项目编号、数量和单位价格。“发票编号”下拉列表提供了“发票 - 主要”工作表中所输入发票的列表，以便于数据输入。与上一步中的“公司编号”类似，“发票编号”会将该详细信息项目与特定发票进行关联。从“发票”工作表中的“发票编号”下拉列表中选择发票编号时，该发票的相关发票详细信息项目便会显示。"]
[null,null,"注意：每张发票的详细信息项目上限为 25。如果添加的项目超过 25 个，所有相应的条目都将变为红色，提醒你存在此限制。如果具有 25 个以上的发票项目，则需要创建第二张发票。 "]
[null,"如何添加更多客户、发票和发票详细信息？"]
[null,"“客户”、“发票”和“发票详细信息”的数据存储在 Excel 表格中。向表格中添加新行时，新添加的行将自动设置格式，并将复制所有计算结果。若要添加新的表行，请执行下列任一操作："]
[null,"● ","如果表格中没有总计行，请在表格下方开始键入，当你按下 Enter 或 Tab 键时，它将自动展开。"]
[null,"● ","将单元格指针放在总计行上方的最后一个单元格（如“发票”表格中最后一张发票的“备注”单元格中），然后按 Tab。"]
[null,"● ","在“开始”选项卡的“单元格”组中，选择“插入”，然后选择“上方的表行”或“下方的表行”。 "]
[null,"● ","在表格的右下角，将鼠标放在表格的尺寸控点上并向下拖动以增加可用表行数。"]
[null,"如何分析发票详细信息？"]
[null,"正如“关于发票跟踪表”部分中所述，输入多张发票后，你可以查看特定客户、项目、指定日期间隔等的所有发票列表。此类分析通过筛选器实现，利用筛选器可快速缩小数据列表的范围。若要访问“客户”、“发票”或“发票详细信息”中的筛选器，请选择任意表字段名称旁边的下拉箭头。随即会显示一个筛选器窗格，其中提供了多种筛选选项。下面是一些可帮助你入门的筛选示例:"]
[null,"● ","若要查看为特定客户开具发票的总金额，请执行以下操作：在“发票 - 主要”工作表中的“公司”字段右侧，选择下拉箭头。在“筛选器”窗格中，单击“全选”以取消选择所有公司，选择所需公司，然后选择“确定”。 "]
[null,null,"提示：在“筛选器”窗格中，还可以在“搜索”文本框中键入客户姓名，以便快速搜索可用列表。"]
[null,"● ","若要查看特定客户和特定项目的所有发票，请执行以下操作：首先，采用上一示例中提供的步骤来筛选所需客户。然后，在“项目编号”右侧，选择下拉箭头。在“筛选器”窗格中，选择所需的一个或多个项目，然后选择“确定”。 "]
[null,"● ","若要查看上个月的所有发票，请执行以下操作：在“发票 - 主要”工作表的发票日期字段右侧，选择下拉箭头，指向“日期筛选器”，然后选择“上个月”。"]
[null,"● ","若要查看具有同一区号的所有客户，请执行以下操作：在“客户”工作表中的“电话”字段右侧，选择下拉箭头。在“筛选器”窗格中，在“搜索”文本框中单击，键入区号，然后选择“确定”。 "]
[null,"筛选提示"]
[null,"● ","如果表格中含有总计行（如“客户”和“发票”），则计算的合计将仅反映筛选后的列表。"]
[null,"● ","对单个字段或在多个字段中使用多个筛选器可微调结果。"]
[null,"● ","若要清除单个筛选器，请选择先前筛选列的下拉箭头，然后选择“从<字段名称>中清除筛选”。"]
[null,"● ","若要同时清除多个筛选器，请将单元格指针放在表格中，在“开始”选项卡上的“编辑”组中，选择“排序和筛选”，然后选择“清除”。"]