Entries Tagged as '数据库'

为制作excel表格头疼的朋友,可以留意一下Blist

无论是建立员工数据库,还是客户数据库,都需要用到表格,而用excel并不是一件简单的事,特别是对新手来说,因为经常要在各种格式(比如数字/文本)切换,有的时候还要添加一些特殊符号。
Blist的价值就是让新手能够很快的做出漂亮的excel表格,如果面对的是比较大的数据库建设的话,还可以多人协作。下面是操作界面,点击可以看大图。

picresized_blist

中间黄色的框是我试着做的几个项目,包括姓名(文本)、工资(数字)、一个小图标(特殊符号)、百分比(输入数字,自动以图形表示)、网站链接、电子邮件(红色的部分是提示有错误)。
做好这些东西大概2分钟也用不了。右边黄色的框中有很多小图标,包括我们刚才提到的这些,还有插入图片、插入文档、插入电话等等。需要的话,直接把图标拖拽到编辑界面里,然后填写内容就可以了。
Blist还处于测试阶段,除了这个基本的编辑功能外,很多功能还不具备(比如上边黄色框内的几乎所有项目)。另外,blist目前还不支持中文;像插入电话这种图标,用的都是美国的电话表现方式;也还没有数字求和的功能。

更新:

1. 增加了数据图表化的功能,这是excel里令人喜爱的功能之一。

2. 增加了导入.csv文件的功能,这样可以对现有文件进行编辑了,比如雅虎财经中的股票历史价格都是用这种文件格式导出的。

3. “分享”按钮已经开始工作了,发email告诉朋友吧。

4. 全文档搜索功能实现了,可以搜索文档中的每个字。 

We Feel Fine

看到We Feel Fine的时候,就像昨天看到Muxicall,我被迷住并且投入,尽管我还不知道她是谁。

we-feel-fine

这就是we feel fine的小小一角。一个同样生活在这个星球上的人写道,Ta觉得Ta不像Ta爱Ta那样爱Ta。Ta现在觉得小小的悲伤。这段话下面时聚时散的颜色,像飘在夜空中的颜色,每一颗都代表着一个人的心情,在这个世界的某个角落。

这就是we feel fine,一个记录人们心情的艺术品。从2005年8月开始,WFF开始从博客当中收集心情。每隔几分钟,这个系统就会搜寻那些以“I feel”/“I’m feeling”开头的博客文章,并把它们收藏起来,分析这是一种什么样的感情,在哪一天,在哪个地方,藏在一个男人还是女人的心里,Ta是大人还是孩子,这一天是阴翳还是晴朗。
WFF的数据库里已经储存了几百万人的各样心情,每天这些心情以15000——20000的速度增长。我们可以搜索这些心情,甚至可以了解,在某一天,是欧洲人更快乐一点,还是亚洲人更快乐一点,是男人更快乐一点,还是女人更快乐一点。
这就是we feel fine,一件由好多好多人共同创造的艺术品。我们在长大,她也在长大,一起看美丽和悲伤,潮起潮落。

We Feel Fine

We Feel Fine is an exploration of human emotion on a global scale.

Since August 2005, We Feel Fine has been harvesting human feelings from a large number of weblogs. Every few minutes, the system searches the world’s newly posted blog entries for occurrences of the phrases “I feel” and “I am feeling”. When it finds such a phrase, it records the full sentence, up to the period, and identifies the “feeling” expressed in that sentence (e.g. sad, happy, depressed, etc.). Because blogs are structured in largely standard ways, the age, gender, and geographical location of the author can often be extracted and saved along with the sentence, as can the local weather conditions at the time the sentence was written. All of this information is saved.

The result is a database of several million human feelings, increasing by 15,000 - 20,000 new feelings per day. Using a series of playful interfaces, the feelings can be searched and sorted across a number of demographic slices, offering responses to specific questions like: do Europeans feel sad more often than Americans? Do women feel fat more often than men? Does rainy weather affect how we feel? What are the most representative feelings of female New Yorkers in their 20s? What do people feel right now in Baghdad? What were people feeling on Valentine’s Day? Which are the happiest cities in the world? The saddest? And so on.

The interface to this data is a self-organizing particle system, where each particle represents a single feeling posted by a single individual. The particles’ properties – color, size, shape, opacity – indicate the nature of the feeling inside, and any particle can be clicked to reveal the full sentence or photograph it contains. The particles careen wildly around the screen until asked to self-organize along any number of axes, expressing various pictures of human emotion. We Feel Fine paints these pictures in six formal movements titled: Madness, Murmurs, Montage, Mobs, Metrics, and Mounds.

At its core, We Feel Fine is an artwork authored by everyone. It will grow and change as we grow and change, reflecting what’s on our blogs, what’s in our hearts, what’s in our minds. We hope it makes the world seem a little smaller, and we hope it helps people see beauty in the everyday ups and downs of life.

- Jonathan Harris & Sepandar Kamvar
May 2006

  • Partner links