很多时候都会从一些应用软件中导出数据生成excel文件,再做下一步计算

但是,有时候会发现这些导出的数字会不参与计算,原因是很隐蔽的

在这类单元格上单击鼠标,会出现一个小的

image 提示,说明:

 

image

此时 可以拖选这些单元格,然后点击上面的小图标,选择

image

转换为数字,就可以参与计算乐

适用于excel 2003

前面已经提到过AMD的magic packet,但是由于某些原因,比如说它的组开机功能我试验不成功,于是决定再找一下,先找到了WOL magic packet sender 2007,如下图

magicpacketsender2007

这个软件很简单啦,host name那儿填入主机名或者远程计算机的IP,subnet mask这儿可以选255.255.255.255和0.0.0.0,我是选了后一个才能开机的,你可以自己试,mac address则是远程计算机网卡的mac地址了

更多的同类软件:

  • PacketTrap pt360 Wake On LAN - A complete network management tool which includes Wake On LAN capability as part of the free version of the software (It was checked, and is just a try out for a short period, then you have to pay for the Pro version).
  • WOL - Magic Packet Sender 2007 – A free Windows Wake-on-LAN application that can store multiple WOL profiles and send magic packets. Requires .NET runtime.
  • SolarWinds Wake-On-LAN - a full-featured tool to remotely power on network PCs, included in the free version of the SolarWinds network toolkit.
  • WakeOnLan (AquilaTech) - A free Windows WakeOnLan program that is full featured. WakeUp, Shutdown, Ping, global shutdown all in one. Requires .NET runtime.
  • FUSION WakeUp on Lan - A free Windows application. Using FUSION WakeUp on Lan you can take advantage of turning on a remote PC through the net interface.
  • Intellipool Network Monitor - Network and Server monitoring software that can start computers with WOL on a schedule.
  • AMD PCnet Magic Packet Utility - WOL application by AMD. It has a simple interface and features group announcements and scheduling.
  • Wake-on-LAN - Free commandline wake-on-lan for Windows. Can wakeup a computer from over the internet.
  • WakeUp - Free commandline wake-on-lan application for Windows.
  • PowerState - Free GUI wake-on-lan application for Windows that also includes Windows WMI shutdown. Build and save lists of PCs for repeated use.
  • WakeOnLan (Dipisoft) - A French freeware for wakeup, ping, restart, shutdown, close/lock session or hibernate distant computers. Works now in both GUI and commandline modes, last version is multilingual. Does not require .NET runtime.
  • WOL 1.0.3 - A freeware Wake-On-Lan tool for all Windows versions.
  • RSHUT PRO - A shareware tool for Wake-On-Lan and remote shutdown for all Windows versions.
  • WakeOnLAN Packet Sniffer - Free troubleshooting tool.
  • Depicus Wake On Lan Tools - Standard alone WOL tools including magic packet sender and monitor for various platforms, no installation required.
  • "WakeOnLan"er :) - Free and simple GUI utility to wake up network computers with "save parameters" option.

可以看到,上面直接给出了AMD magic packet的下载地址是:

magic_pkt.exe,enen,点击就可以下载乐

软件下载链接来自:

http://en.wikipedia.org/wiki/Wake-on-LAN,thanks :)

 

以下为下载地址:
用于 IT 专业人员和开发人员的 Windows XP Service Pack 3 网络安装软件包
http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=5b33b5a8-5e76-401f-be08-1e1555d4f3d4
Windows XP Service Pack 3 MUI Pack Update
http://www.microsoft.com/downloads/details.aspx?familyid=D3F8F6AB-84F1-4095-8709-DF509B1BEE22&displaylang=en
Windows XP Service Pack 3, Checked Build
http://www.microsoft.com/downloads/details.aspx?familyid=D811F258-C95F-479A-BDF1-0D1154D700A5&displaylang=en
快升级吧~~~ :)

买了根2G的内存条,插上后,在Vista系统下,居然出现百年一遇的蓝屏,天

先考虑软件因素,但在几次重起之后,系统进不去了,于是重装

重装之后,一切正常,Vista开始自动更新,在安装Creative EMU10K1的驱动时,再度蓝屏,于是明白,这款声卡out乐

把Emu10k1拆下来,再度更新,一切正常,想想这块EMU10K1声卡跟了我8年,终于在没有任何故障的情况下,离开机箱休息去了

正好试试板载的HDaudio声卡,感觉音质比EMU10K1好很多,那就OK吧

如果你的Vista也遇上这样的问题,试试拆掉太久的硬件,删掉古老的软件吧

Good luck! :)

Windows Vista默认是把自身所在分区作为C盘的,多次尝试之后,建议C盘最少40G

如果C盘不够40G,想要调整,怎么办,有两种方法

一种方法是用Vista的磁盘管理,具体方法见:

Vista技巧 磁盘管理调整硬盘分区,thanks

这个方法我试过一下,但不知道为什么,我这儿只能给C盘增加5G,于是我尝试了第二种方法

Vista调整硬盘分区大小的方法

使用Acronis Partition Expert,现在叫disk director suite,最新版本是10,在我的操作中,用了15分钟,给C盘增加了10G空间,操作中间不需要重启系统(当然在刚安装完软件是要重启一次的)

Good luck!

这是一个问题:

附加数据库的时候,提示:

执行 Transact-SQL 语句或批处理时发生了异常。 (Microsoft.SqlServer.Express.ConnectionInfo)

——————————

无法打开物理文件 "D:\myData.mdf"。操作系统错误 5:"5(拒绝访问。)"。 (Microsoft SQL Server, Error: 5120)

 

我的个人网络生活这儿找到的解决方法是:

不用sa用户附加,重新连接数据库,选中windows集成验证模式,ok

但我是换成用sa用户登录,就OK了,可以附加

Winamp v5.53默认是不播放的APE的音乐的,解决方法,不要从这儿下载插件

http://www.winamp.com/plugins/details/138099

改成从这儿下载:

http://www.monkeysaudio.com/download.html

是下3.99还是下4.01b2,看个人喜欢乐

安装上面下载下来的软件,最后一步,会提示安装Winamp插件,核对目录无误后,让它安装之,然后就可听APE格式的音乐啦

我怎么又忘了截图下来呢

如果还想进一步,试试APE分轨播放,看这里

http://blog.3cbank.com/?p=768,   thanks

Winamp5.53每次启动都会提示,找 不到tara.ini,然后就正常放歌听,但每次都要多点一下呵

Google一下,答案是这里:

http://www.musiclivesonline.com/software/watara.html,thanks

在这里下载完tara ,安装之,再启动winamp就没有提示乐 :)

安装很简单的

sp11

sp12

点点安装后,就开始啦

sp13

就是用了那么一段时间啦

sp14

感觉速度快了蛮多的

下载地址:

X86

http://www.microsoft.com/downloads/details.aspx?familyid=F559842A-9C9B-4579-B64A-09146A0BA746&displaylang=zh-cn

 

X64

http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=86d267bd-dfcd-47cf-aa76-dc0626dcdf10

 

正在下载 中,很快可以安装了!!!