利用excel的vba代碼實(shí)現(xiàn)自動化“收集原始數(shù)據(jù)、匯總計(jì)算和報(bào)表”(參考版)
2025-07-03 18:42本頁面
【正文】 退出本簿 End If End WithEnd Sub3 表報(bào)，使用數(shù)據(jù)透視獲得所有需要的數(shù)據(jù)成果 總指標(biāo)區(qū)期總指標(biāo)一小區(qū)二小區(qū)A區(qū)B1期B2期居住區(qū)商業(yè)區(qū)土地面積 建筑面積 商品房套數(shù) 報(bào)表日期2016/11/1 銷售統(tǒng)計(jì)總表范圍狀態(tài)主房套數(shù)主房面積應(yīng)收款實(shí)收款欠收款1本日認(rèn)購1 97 79,711 10,000 69,711 簽約0 0 4,925,416 464,987 4,460,429 退房0 0 0 0 0 2本月認(rèn)購1 97 79,711 10,000 69,711 簽約0 0 5,404,406 464,987 4,939,419 退房0 0 0 0 0 3本年認(rèn)購524 63,234 3,494,963 3,356,856 138,107 簽約556 67,211 435,670,499 428,291,352 7,379,147 退房4 586 0 798,591 0 4項(xiàng)目認(rèn)購1,534 181,861 4,073,963 3,778,856 295,107 簽約1,495 177,353 1,004,922,220 995,181,472 9,740,748 退房5 715 0 2,173,977 0 項(xiàng)目銷售統(tǒng)計(jì)表項(xiàng)目范圍狀態(tài)主房套數(shù)主房面積應(yīng)收款實(shí)收款欠收款項(xiàng)目11本日認(rèn)購1 97 79,711 10,000 69,711 簽約0 0 2,179,372 464,987 1,714,385 退房0 0 0 0 0 2本月認(rèn)購1 97 79,711 10,000 69,711 簽約0 0 2,658,362 464,987 2,193,375 退房0 0 0 0 0 3本年認(rèn)購351 40,610 3,454,963 3,316,856 138,107 簽約380 44,325 227,972,468 223,309,365 4,663,103 退房0 0 0 300,000 0 4項(xiàng)目認(rèn)購950 109,325 3,733,963 3,438,856 295,107 簽約924 106,701 557,783,725 550,789,021 6,994,704 退房0 0 0 1,343,137 0 項(xiàng)目2 分區(qū)分期銷售統(tǒng)計(jì)表項(xiàng)目分區(qū)分期范圍狀態(tài)主房套數(shù)主房面積應(yīng)收款實(shí)收款欠收款項(xiàng)目1A01本日認(rèn)購0 0 0 0 0 簽約0 0 684,398 0 684,398 退房0 0 0 0 0 2本月認(rèn)購0 0 0 0 0 簽約0 0 684,398 0 684,398 退房0 0 0 0 0 3本年認(rèn)購57 8,846 500,000 500,000 0 簽約63 9,665 51,521,928 50,253,530 1,268,398 退房0 0 0 0 0 4項(xiàng)目認(rèn)購511 61,413 562,000 562,000 0 簽約511 61,414 352,571,621 351,083,223 1,488,398 退房0 0 0 811,547 0 B11本日認(rèn)購1 97 79,711 10,000 69,711 簽約0 0 1,494,974 464,987 1,029,987 退房0 0 0 0 0 2本月認(rèn)
公司管理相關(guān)推薦
鄂ICP備17016276號-1