主题 : 投资之道-工欲善其事,必先利其器
阅读41551次 | 返回列表 | 关闭本页
三友码神
你想要的论坛有,我想要的你们有!!!
管理员
发帖: 202
威望: 1139 点
金钱: 2480 RMB
贡献值: 0 点
人民币: 0 元

我的钱包

投诉点击这里给我发消息


人人为我,我为人人
0  发表于: 2016-01-24 12:33
u  回复 u  编辑 u

投资之道-工欲善其事,必先利其器

管理提醒: 本帖被 三友码神 执行提前操作(2018-11-09)
【快速批量输入验证数据】

我们不止要从投资思维上转变观念,还要提高工作效率。
当你在单元格中输入往昔的数据以验证数据创作成果的可行性分析时,可以采用Excel的批量设置。

一、准备载入的数据,按你想验证的期数顺序排列。
例如想输入以下格式:
●【2135期】【汇总30码】01,05,06,07,08,15,16,17,18,20,21,22,23,24,26,28,29,★31,33,36,37,38,39,40,41,42,43,46,48,49, =30码,
●【2134期】【汇总30码】01,02,03,04,06,08,10,★13,14,15,18,20,21,22,23,24,26,27,29,31,32,35,36,38,41,42,46,47,48,49, =30码,
●【2133期】【汇总30码】01,02,03,05,08,11,12,13,14,15,16,17,23,25,26,27,29,★30,31,32,33,34,35,36,38,40,41,43,46,47, =30码,
●【2132期】【汇总30码】01,04,06,07,08,09,11,13,15,16,17,★21,22,23,24,27,28,32,33,35,37,38,39,40,41,42,43,45,47,49, =30码,
●【2131期】【汇总30码】01,02,03,06,07,11,12,13,14,15,16,17,18,20,21,24,26,27,★31,32,33,34,35,37,38,41,42,43,46,49, =30码,
●【2130期】【汇总30码】01,02,03,05,06,07,11,12,13,14,15,16,20,22,23,24,★25,26,27,31,33,34,35,36,38,39,42,45,48,49, =30码,
●【2129期】【汇总30码】02,03,04,05,07,08,09,10,13,14,17,18,19,20,21,23,24,27,28,29,33,34,35,38,40,★43,45,47,48,49, =30码,
●【2128期】【汇总30码】02,03,05,10,11,13,14,15,16,17,18,20,21,22,23,25,26,27,29,30,31,32,33,34,35,★42,43,45,47,49, =30码,
●【2127期】【汇总30码】03,05,06,07,08,09,13,14,16,17,18,19,21,23,24,26,27,29,30,35,36,37,39,40,★41,42,43,45,47,49, =30码,
●【2126期】【汇总30码】★02,04,05,07,08,12,13,14,15,16,17,21,22,23,27,28,29,31,32,33,35,36,37,38,39,41,43,45,47,48, =30码,
●【2125期】【汇总30码】05,08,10,11,12,13,14,15,16,17,18,20,21,22,23,24,27,29,31,32,33,35,36,38,40,43,44,45,47,48, =30码,
●【2124期】【汇总30码】★01,02,06,07,10,11,12,13,15,16,17,18,19,20,21,22,23,28,29,31,32,33,36,37,41,43,44,45,48,49, =30码,---------------
●【2123期】【汇总30码】01,02,03,06,08,10,11,12,13,14,15,18,20,22,24,26,27,30,31,32,33,34,35,36,37,38,42,44,45,48, =30码,
●【2122期】【汇总30码】01,02,03,04,10,13,15,16,17,18,20,★21,23,26,27,28,29,30,31,33,35,36,38,39,40,42,43,47,48,49, =30码,

首先可以用牛牛数据处理器快速处理出来,方案命令如下:
---------------------
删除空行≡⊕⊕
指定替换≡★⊕⊕
指定替换≡-⊕⊕
包含删前段≡】⊕⊕
包含删前段≡】⊕⊕
包含删后段≡ =⊕⊕
行倒排列≡⊕⊕
---------------------

其中“指定替换”命令可以处理数据中包含的其他不需要标记符号,“行倒排列”命令根据数据排列实际添加,处理后数据如下,符合投资表格式:

01,02,03,04,10,13,15,16,17,18,20,21,23,26,27,28,29,30,31,33,35,36,38,39,40,42,43,47,48,49,
01,02,03,06,08,10,11,12,13,14,15,18,20,22,24,26,27,30,31,32,33,34,35,36,37,38,42,44,45,48,
01,02,06,07,10,11,12,13,15,16,17,18,19,20,21,22,23,28,29,31,32,33,36,37,41,43,44,45,48,49,
05,08,10,11,12,13,14,15,16,17,18,20,21,22,23,24,27,29,31,32,33,35,36,38,40,43,44,45,47,48,
02,04,05,07,08,12,13,14,15,16,17,21,22,23,27,28,29,31,32,33,35,36,37,38,39,41,43,45,47,48,
03,05,06,07,08,09,13,14,16,17,18,19,21,23,24,26,27,29,30,35,36,37,39,40,41,42,43,45,47,49,
02,03,05,10,11,13,14,15,16,17,18,20,21,22,23,25,26,27,29,30,31,32,33,34,35,42,43,45,47,49,
02,03,04,05,07,08,09,10,13,14,17,18,19,20,21,23,24,27,28,29,33,34,35,38,40,43,45,47,48,49,
01,02,03,05,06,07,11,12,13,14,15,16,20,22,23,24,25,26,27,31,33,34,35,36,38,39,42,45,48,49,
01,02,03,06,07,11,12,13,14,15,16,17,18,20,21,24,26,27,31,32,33,34,35,37,38,41,42,43,46,49,
01,04,06,07,08,09,11,13,15,16,17,21,22,23,24,27,28,32,33,35,37,38,39,40,41,42,43,45,47,49,
01,02,03,05,08,11,12,13,14,15,16,17,23,25,26,27,29,30,31,32,33,34,35,36,38,40,41,43,46,47,
01,02,03,04,06,08,10,13,14,15,18,20,21,22,23,24,26,27,29,31,32,35,36,38,41,42,46,47,48,49,
01,05,06,07,08,15,16,17,18,20,21,22,23,24,26,28,29,31,33,36,37,38,39,40,41,42,43,46,48,49,

然后把处理好的数据复制到粘贴板。

二、在投资计划表中输入数据

1、打开投资计划表,单击计划表中数据单元格对应起始期数数据,如本例2122期。
2、同时按键盘shift+↓,选定2122期-2135期或以下数据。
3、鼠标右键单击可以选择被选数据要执行的命令,如清除内容等,这里我们把预先复制在粘贴板的数据选择粘贴命令,数据就成功批量载入单元格了。

全年批量输入数据方式一样,其他的单元格同样可以这样操作执行批量清除、复制、粘贴等命令,将你从一期一期输入的状态中解放出来,把时间用于开发数据上去。
@#¥%……&*
鼓励高手→我要打赏     我要举报

温馨提示:请参赛者自查 发帖格式?

一:所发表的参赛标题格式是否统一?

二:是否在原帖更新!(进入赛贴右上角“作者编辑”更新即可!)?

三:比赛者的成绩按规定时间内发帖子有效!超出了时间段更新的无效处理!谢谢合作!

四:领奖请联系QQ或者微信:1311333888