excel怎样制作物业水电收费管理报表?

发布网友发布时间：2022-04-23 20:19

共6个回答

懂视网时间：2022-05-01 16:18

table admin （ aid varchar2(10) not null, apassword varchar2(8) not null, aphone varchar2(11) not null, aname varchar2(8) not null ）; comment on table admin is ‘管理员登录‘; comment on column admin.aid is ‘管理编号(主键)‘; comment on column admin.apassword is ‘登录密码‘; comment on column admin.aphone is ‘管理员电话‘; comment on column admin.aname is ‘管理员姓名‘; alter table admin add constraint pk_admin primary key (aid);

技术分享

drop table uuser;

create table uuser
(
uon varchar2(15) not null,
uname varchar2(8) not null,
uphone varchar2(11) not null,
upassword varchar2(8) not null,
uaddress varchar2(60) not null

）;
comment on table uuser is ‘用户登录‘;
comment on column uuser.uon is ‘用户编号(主键)‘;
comment on column uuser.uname is ‘用户姓名‘;
comment on column uuser.uphone is ‘用户电话‘;
comment on column uuser.upassword is ‘用户登录密码‘;
comment on column uuser.uaddress is ‘用户地址‘;

alter table uuser add constraint pk_uuser primary key (uon);

技术分享

drop table dianfei;
create table dianfei
（
uon varchar2(10) not null,
mmonth varchar2(6) not null,
ddf number(6,2) not null,
djftime date not null,
djfzt varchar2(3) not null,
dsyjf date not null
）;
comment on table dianfei is ‘电表‘;
comment on column dianfei.uon is ‘用户编号(从键)‘;
comment on column dianfei.mmonth is ‘缴费月份（从键）‘;
comment on column dianfei.ddf is ‘电费金额‘;
comment on column dianfei.djftime is ‘缴费日期‘;
comment on column dianfei.djfzt is ‘缴费状态‘;
comment on column dianfei.dsyjf is ‘上月缴费日期‘;

alter table dianfei add constraint pk_dianfei foreign key (uon)
references uuser (uon);
alter table dianfei add constraint pk_dianfeia foreign key (mmonth)
references money (mmonth);

技术分享

drop table shuifei;
create table shuifei
（
uon varchar2(10) not null,
mmonth varchar2(6) not null,
sdf number(6,2) not null,
sjftime date not null,
sjfzt varchar2(3) not null,
ssyjf date not null
）;
comment on table shuifei is ‘水表‘;
comment on column shuifei.uon is ‘用户编号(从键)‘;
comment on column shuifei.mmonth is ‘缴费月份（从键）‘;
comment on column shuifei.sdf is ‘水费金额‘;
comment on column shuifei.sjftime is ‘缴费日期‘;
comment on column shuifei.sjfzt is ‘缴费状态‘;
comment on column shuifei.ssyjf is ‘上月缴费日期‘;
alter table shuifei add constraint pk_shuifei foreign key (uon)
references uuser (uon);
alter table shuifei add constraint pk_shuifeia foreign key (mmonth)
references money (mmonth);

技术分享

drop table money;

create table MONEY
(
 mmonth varchar2(6) not null,
 mwater NUMBER(4,2) not null,
 mpower NUMBER(4,2) not null
);
comment on column MONEY.mmonth
 is ‘缴费月份（主键）‘;
comment on column MONEY.mwater
 is ‘水费价格‘;
comment on column MONEY.mpower
 is ‘电费价格‘;
 alter table MONEY add constraint pk_money primary key (mmonth);

技术分享

水电缴费管理系统-数据库表格创建

标签：

热心网友时间：2022-05-01 13:26

excel制作物业水电收费管理报表的步骤：

1、新建Excel表：

2、顶格单元格输入文字日常开支报表，单元合并：

3、输入名称、输量、单价、金额：

4、在表格下方输入总金额：

5、选中表格点击添加全部边框即可。

以上就是excel制作物业水电收费管理报表的步骤了。

热心网友时间：2022-05-01 14:44

如果你要别人给你做一个报表，含统计功能。不现实。
excel其实很简单，多学吧。你所要的管理报表没几个函数就可以搞定。

热心网友时间：2022-05-01 16:18

在C列插入计算费用的公式：=B2*0.55并向下填充

在D1输入公式，计算总费用：=sum(c:c)

热心网友时间：2022-05-01 18:10

点击条件格式，选择突出显示单元格规则，选择小于里面，条件输入零，设置你需要的格式就可以了

热心网友时间：2022-05-01 20:18

不管报表要看各家的需要，据实际情况设置