财务决策支持系统实验Word文档格式.docx
- 文档编号:16770875
- 上传时间:2022-11-26
- 格式:DOCX
- 页数:21
- 大小:39.93KB
财务决策支持系统实验Word文档格式.docx
《财务决策支持系统实验Word文档格式.docx》由会员分享,可在线阅读,更多相关《财务决策支持系统实验Word文档格式.docx(21页珍藏版)》请在冰豆网上搜索。
2008-10-16
20
100
2000
10
2008-10-16
1000
11
2008-10-16
13
100
1300
12
2008-10-17
5
500
2008-10-17
16
1600
14
2008-10-17
16
1600
15
2008-10-17
18
100
1800
2008-10-17
13
100
1300
17
2008-10-17
12
1200
光驱
陕西
青龙
2008-10-18
张红
110
990
19
电脑
2008-10-18
20
2008-10-18
5420
65040
21
2008-10-19
16
86720
22
2008-10-19
23
2008-10-19
17
110
1870
24
2008-10-19
1760
25
2008-10-19
1430
26
1320
27
2008-10-20
15
110
1650
28
2008-10-20
18
110
1980
29
2008-10-20
14
1540
30
2008-10-20
17
110
1870
31
2008-10-20
15
1650
32
2008-10-20
33
2008-10-20
34
2008-10-20
12
35
2008-10-20
14
1540
36
云天
2008-10-21
李梅
11
1100
37
2008-10-21
2100
38
2008-10-22
2000
39
2008-10-22
21
40
2008-10-22
25
2500
41
2008-10-22
2300
42
2008-10-22
2200
43
25
44
2008-10-23
1200
45
2008-10-23
1500
46
阳光数码港
2008-10-23
王星
19
1691
47
2008-10-23
2225
48
2008-10-24
15
1335
49
2008-10-24
89
1424
2008-10-24
29
2581
51
2008-10-24
2581
52
2008-10-24
18
1602
53
2008-10-24
2759
54
2008-10-25
3204
55
2008-10-25
34
3026
56
2008-10-25
38
3382
57
2008-10-25
39
3471
58
2008-10-25
45
4005
2008-10-25
4094
60
47
4700
61
2008-10-26
62
2008-10-26
26
2600
63
2008-10-26
2800
64
2008-10-26
2900
65
2008-10-26
2700
66
2008-10-27
2900
67
2008-10-27
2500
68
2008-10-27
26
2600
69
2008-10-27
100
2400
70
手机
山东
2008-10-28
36
1800
64800
71
2008-10-28
39
1800
70200
72
2008-10-28
1800
68400
73
2008-10-28
37
1800
66600
74
2008-10-28
44
79200
75
2008-10-28
82800
76
2008-10-29
1800
88200
77
2008-10-29
1800
86400
78
2008-10-29
1800
86400
79
2008-10-29
47
84600
80
2008-10-29
41
1800
73800
81
2008-10-29
81000
82
2008-10-29
46
82800
83
2008-10-29
81000
84
2008-10-29
73800
85
2008-10-29
73800
86
2008-10-30
87
2008-10-30
49
88200
88
2008-10-30
52
4628
2008-10-30
4539
90
2008-10-30
51
4539
91
2008-10-30
4806
92
2008-10-30
56
4984
93
2008-10-30
52
4628
94
2008-10-30
95
2008-10-31
4984
96
2008-10-31
97
2008-10-31
4094
98
2008-10-31
3738
99
2008-10-31
4183
4005
使用界面
产品名称,销售网点,销售人员与销售额
4450
4450
8900
1780
1780
4450
1780
1780
1780
5251
800
900
900
900
2000
2000
1000
1000
1300
1300
500
500
500
1600
1600
1600
1800
1300
1300
1200
1200
1200
990
990
990
81300
81300
81300
65040
65040
65040
86720
86720
86720
75880
75880
1870
1870
1760
1430
1430
1430
1320
1320
1320
1650
1980
1980
1540
1540
1540
1870
1870
1650
1650
1760
1760
1320
1320
1540
1100
1100
2100
2100
2100
2000
2100
2500
2500
2300
2300
2300
2200
2200
2200
2500
1200
1500
1500
1500
1691
1691
1691
2225
2225
2225
1335
1335
1335
1424
1424
1424
2581
2581
2581
2581
1602
1602
2759
3204
3204
3204
3026
3026
3382
3382
3382
3471
3471
4005
4005
4094
4094
4094
4700
4700
2500
2600
2600
2800
2800
2800
2900
2900
2700
2900
2400
2400
64800
64800
64800
70200
70200
68400
68400
68400
66600
66600
66600
79200
79200
79200
82800
82800
82800
88200
88200
86400
86400
86400
84600
84600
73800
73800
73800
81000
81000
82800
82800
81000
81000
73800
73800
82800
82800
88200
88200
88200
4628
4539
4539
4539
4806
4806
4984
4984
4628
4628
4628
4628
4984
4984
4005
4094
4094
3738
3738
4183
4005
4005
4005
汇总表
求和项:
汇总
308940
22000
62100
121752
总计
程序:
Sub按钮4_单击()
Sheets("
产品名称链接"
).Select
ActiveCell.FormulaR1C1="
=Sheet1!
R[1]C[1]"
Range("
A1"
).Select
Selection.AutoFillDestination:
=Range("
A1:
A101"),Type:
=xlFillDefault
Range("
A101"
).Select
ActiveWindow.SmallScrollDown:
=-93
Range("
B1"
).Select
ActiveCell.FormulaR1C1= "=Sheet1!
R[1]C[6]"
Range("
).Select
Selection.AutoFill Destination:
=Range("
B1:
B101"
),Type:
=xlFillDefault
Range("
B101"
).Select
ActiveWindow.SmallScroll Down:
=-3
C85"
).Select
ActiveWindow.SmallScrollDown:
=-93
End Sub
Sub按钮5_单击()
Sheets("
销售网点链接").Select
ActiveCell.FormulaR1C1="=Sheet1!
R[1]C[3]"
Range("
A1"
).Select
Selection.AutoFill Destination:
=Range("
A101"
),Type:
=xlFillDefault
Range("A1:
).Select
ActiveWindow.SmallScrollDown:
=-81
Range("
).Select
ActiveCell.FormulaR1C1="
=Sheet1!
R[1]C[6]"
).Select
Selection.AutoFillDestination:
=Range("
B101"
),Type:
=xlFillDefault
Range("B1:
ActiveWindow.SmallScrollDown:
=-60
Range("D34"
EndSub
Sub按钮6_单击()
Sheets("
销售人员链接"
ActiveCell.FormulaR1C1="
=
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 财务 决策 支持系统 实验