/WWor-'THEsEnrngrV1m>ER.u.covzammur1!TitME"" />

NSA UFO 蓝皮书计划

NSA UFO 蓝皮书计划
NSA UFO 蓝皮书计划

50.1,

3 -t F/e/yumbm

S

gc:

§~w

I~.-

. 1 §

é; -'" i -1 -B ?

_ , .

._ i -5 -/i 1" z?! +,L

. DEPARTMENT

oF THE

AIR NC;

*-_ :92 %14"1 V1_

WASHlNGTON.D.C.

20330

- /'

qt ¢_ " °1>/ W W

or-'

THE

sE nrngr V

1m>ER.u. covzammur

1 !T it M E" " 14JARWl ii

92,92N;;92,.92¢ ;?A F92

c92.+<¢<

s L92 ! -

Dear Mr. Malmfeldt: 92

This office recently received

UFOs, referred to us from the Bu

sheet indicates, the A '

gation of UFOs was t erminated on

related documentation was turned

and Records Service.

a public inquiry regarding

e u. As the inclosed fact

Project Blue Book" investi-

cember l7, 1969, and all

o to the National Archives

The inquirer referred to us has b een apprised of these events. Hopefully, the inclosed fact sheet will be of help

in responding to any f uture inquiries on this s ubject.

Sincerely,

A$

H. A. MCCLANAHAN, Lt C O1, USAF

Chief, Civil Branch

Conmunity Relations Division

Office of Information

Attachment ?=

57¢

Federal Bureau of Investigation

Attention: Mr. Malmfeldt, Room 7825 7

Washington, D. C. 20535

REC-25.

,92U B53 - 9&7/ "

W <.'a- 5:53 * F

OLUTIQN

6 Q

B7"

gs.

92?L!

1

5

".1

I *2

Q _ I

2-. _

1

I n

{I

UFO FACT SHEET

On December 17, 1969 the Secretary of the Air Force announced the termination of Project Blue Book, the Air Force

program for the investigation of UFOs.

The decision to discontinue UFO investigations was based on an evaluation of a report prepared by the University of

Colorado entitled, "Scientific Study of Unidentified Flying

Objects;" a review of the University of Colorado's report by the National Academy of Sciences; past UFO studies; and Air

Force experience investigating UFO reports during the past

two-decades. .

As a result of these investigations and studies, and experience gained from investigating UFO reports since

1948, the conclusions of Project Blue Book are: l! no UFO reported, investigated, and evaluated by the Air Force has ever given

any indication of threat to our national security; ! there

has

been no evidence submitted to or discovered by the Air

Force

that sightings categorized as

"unidentified" represent technological developments or principles beyond the range of

present day scientific knowledge; and !there has been no

evidence indicating

that sightings

categorized as

"unidentified are extraterrestrial vehicles.

with

the termination of Project Blue Book, the Air Force regulation establishing and controlling the program for invest-igating and analyzing UFOs was rescinded. All documentation

regarding the former Blue Book investigation has been per-

manently transferred to the Modern Military Branch, National

Archives and Records Service, 8th and Pennsylvania Avenue,

Washington, D.C. 20408, and is available for public review

and analysis.

Attached for your information is the Project Blue Book sighting summary for the period 1947-1969. Also included is

a listing of UFO-related materials currently available.

Since the termination of Project Blue Book, no evidence has been presented to indicate that further investigation of UFOs by the Air Force is warranted. In view of the consider-

able Air Force

commitment of resources

in the past, and the extreme pressure on Air Force

funds at this

time, there is no likelihood of renewed Air Force

involvement in this area.

We

4

i 1 "--

YEAR

1947

1948

1949

1950

1951

1952

1953

1954

1955

1956

1957

1958

1959

1960

1961

1962

1963

1964

1965

1966

1967

1968

1969

TOTAL

~.

-. §-1 _-

3

A

TOTAL_pF0 szsurzncs, 1947 - 1969

I

4

TOTAL SIGHTINGS" UNIDENTIFIED

122 12

156 7

166 622

210 27

169 22

1,501 303

509 42

497 46

545 '

24

670 14

1,006 14

627 10

390 12

557 14

591 '

13

474 15

399 14

562 19

887 16

1112 32

937 19

375 3

161

12,618 701

I

Z

-1 -1-< l ma

H?

UFO MATERIALS

Scientific Stugy

of Unidentified

Flying 0b'ects.

Study conducted_by t

e University

of Colorado

under contract F44620-76-C-0035. Three volumes, 1,465 p. 68 plates. Photoduplicated hard copies of the official report may

be ordered for $6 per volume, $18 the set of three,

as AD 68O:975, AD 680:976, and AD 680:977, from the

National Technical Information Service, U.S. Department

of Commerce, Springfield, VA 22151. T

Review of University o f Colorado Report on Unidentified ' 50b t R v of re ort b anel of the National Flying iec s. e iew p y a p

Aca emy o Sciences. National Academy of Sciences,

1969,

6p. Photoduplicated hard copies may be ordered for

$3

as AD 688:54l from the National Technical Information Service, U.S. Department of Commerce, Springfield, VA 22151.

--1

i

_ K

.,.>.

RI

Z

4!

I 92- _ <; I

ix

92

There are a number of universities and professional

scientific organizations such as the American Association for

the Advancement of Science, which have considered UFO phenomena during periodic meetings and seminars. In addition,

a list of private organizations interested in aerial phenomena may be found in Gale's Encyclopedia

of Associations Edition 8,_ Vol I, pp. 432-3!. Such timely review of the situation by private groups insures that sound evidence will not be over-looked by the scientific community.

I

2Atchs

l. Sighting Summary

2. UFO r elated Materials

2 .

?,,-_ .1?

.,;_. _- _, ,:_._-.___.__

":,_._._ "'

._i-1

'92

J

.4 -.4 .8-"'2

I

_ I

I W

- ~--~ -_ .

.___ ______..

_.__* .

4 .

1'

*

" , 3 ' _-' .- T

"

?

A

1' '

FEDERAL qgvmmmr Jan -III? 24¢ 1977

I

.'

Lieutenant Colonel H. A. Mo l enehan, USA?

cn1¢:..-.cu.LL-.2s.=a.¢l92_ '

Conmunit __391etIqns Divis on

"crr'f1<=¢ 3¥' rn":sam~;1aa- -Depart1nen1;:..:

WI

y?-D4-_C _'

'

l :'..=C*¢'<>1:::.$92'92"92

H C 15- Hr. Helmfeldt

has brought

your letter

of Janu-ary'14th, with enclosure, to

my attention.

I join

him in

thanking you

for sending us a copy

of your

UFO Fact Sheet

and for appriaing us of the termination of

your project.

sincerely yours, __

AV

oneld W.

Moore, Jr.

Assistant Director

92O'92'/ External Affairs Division 1

1

@;-z.2zz-15¢

A

.1?. C -26 22

JAN 271977

IIX __i Den A D

AJu._Dop.AD uv._

-I--n -Ii

isié '__ Am. mm

"A"-I9 1'0 ---Ala. Sen _i

""f.?' " <,a>%1> i > 19 L

Hem. i

lnuponiun i lnhll. i__

Lebonvoryi Lop! Ceun..__

Plea. In Evl|.__Rae. llgnhi S c. lnv.P.Twining

___' "'~"~ I|l.___

92A /

-nu .

UNIT G

I

cro =

mu r92'Q

'nQ

92

'-iii

DQH._._

lDOl@.i._

LDDIIV.

The NEW

AQN;

https://www.360docs.net/doc/753372096.html,rn

termini

tt____._ T

BLUE

BOOK A7

and name-approved, by

the United Slates Air Force. ~ L 7<

1- 12, 1989

. William S. Sessions

Director

Federal Bureau of Investigations

U.S. Department of Justice"";---~~~¢,--'jj'_';

1 j'_'jI _-11': Washington, D.C. 20535 "' "

IQ_.._._

l ._._i

Iii

Lag|lOe92n

l92ne.lleIl_

l'ech.s

h iiqi

AIIQOI-__

E7

Dear Mr. Sessions :

ilYour letter

of P- e ptember

1 has been

received, and I am

very

I8ppreciative of hearing from you.

Your letter presented information that I had already mentioned

to you,in my

letter of July 21.; so this was information I knew.

I had

given this

to you as "advance" information that

you would probably receive from

other Government agencies, and departments,

and which is the standard

release material.

Again, the new Project Blue Book is a civilian continuation of the

original Project Blue Book, which did

close in 1969. Here, twenty-

years later, som e of the same

original Blue Book, Pentagon, and

other persons are, still,

looking for the real answer to the UFO phenomenon. That is the reason, too, I gave you the information

I did - about J. Edgar Hoover, President Carter, Senator Barry Goldwater, etc. I was hoping to go "deeper" into the intelligence-gathering agencies

-which

received some o

t e"better"};RO

reports which never

did go to Project Blue Book. __ _

5it 3 Q{@577 I h.ve been to t..e National Archives, an

h ave looked a sohe f he original Blue Book material that is there....I met with persons at

NASA's headquarters,

in Washington, following their receipt of the

request fran

President Carter....I met with

President Carter's chief Scientific Adviser's personnel, at the New Executive Offices of the President....I sent reports to the original Project Blue book, and

know some of it's former personnel, etc. So, I know the whole

scheme

of things, pertaining to UFO 's

-except for the hidden Intelligence-gathering agency participation with regard to the better UFO sighting reports, and

whichare, to

this date,

real,

hardéun@wns&

°°'92l-

on.e_e.u

on.92.un

mm

one

nupaunnn__

C

']6/Inspired, and name-approved, by the United Slates Alr Force. >

E

l v

I

nu! '5 1. -' THE NEW

En:

IQ F

A332.

C11:C: .:a

!.-:.-lC;. .!lj I c/

}*"

u

-..

00 92"--b92 0

R:_ct.1_~

Ti

Oil-|-E-2Jul 2:, 1989 "?*"""'-"""" ' -"1

Y t : Nm o v ni HI

Federal Bureau_ of Investigations

Washington,

D.C. 20535,i

r

Mr. William S. Sessions, Director

U..S. Department of Justice

Dear Mr.

Sessions:

Y ou may recall.3hat,vvhile you were in Fort Smith visiting your

Fath:r,dE!calle and,_briefly,_mengioned m Eisire to meet:&#fw yo -~ andto? discussthe phennenon.

of .

in general, and the role of U. S. Government participation,

in

particular.I said g at I wished to issue a "challenge" to you not that you

d o notjc allenges on a daily

basis! pertaining to UFO's. You

.stated that you were interested, and to write you - and which I am now doing. Icnuld write "pages" on the matter, but rather than to do so - it will be lengthy enough for me to endeavor to give you information I wish to convey in this letter.In any event, the U.-S. Government has played important roles

in the evaluation of UFO reported sightings. The new Project

Blue Book is a "continuation" of the original Project

Blue Book,

established

by the Air Force, and was located at wright-Patterson

Air Force Base, Dayton,

Ohio. some of the most important sighting

"announcements" came

from the Air Force, and which were, later,

stated

to

be something not in the original

announcements - in a

cover-up of the initial

announcement. This repeatedly happened

much to the chagrin

of the Air

Force. Original

members of

the Project Blue Book found that many reports never were received

by this group, but went to intelligence-gathering agencies. A

l{7L!ts I 1'While Director of the F.B.I., Mr. J. Edgar Hoover %Lhose personne reported some

of the sightings themselves and who were, otherwise,

brought

in to some of the cases!

repeatedly

asked the Air

Force

for complete information about the UFO's - to no avail. They the

Air Force! would not release

certain case reports to Mr. Hoover.

Even with the present

F.O.I., mostly sanitized version/copies are

received and with information

requested completely blocked-out.

.~

p

L °3'° ° @/an 7

1,7 '

I cg. .3 1 0'.

"1...

3I .13.TI. ,_.38.

Adm C:.".~:s.

--an?e_-an -1O4. 92.._ _ u _..._ ..._P|____,

....-.1 c :.*a C;..:.I

:."-3

III. M... .-.T0 -£51231: Rf QVQZQT3 C-Z3

' .'

1

.Mr. William sea ns - F.B.I. - 2 _

,.

while Chairman

of the Senate Committee

on Science,

Senator Barry

Goldwater asked for information

and was told that he was

not on

a "need to know" basis. This

request, of Goldwater, had

to do with

an initial

announcement from

the Air

Force that

a

"saucer" had crashed

and that alien bodies were at thn point in time! located in a hanger,or other building, at Wright-Patterson Air Force Base, at Dayton, Ohio.Senator Goldwater was refused any information in this matter, along wit not being allowed to personally look inside of the alleged building.Before taking office as President, Jimmy Carter announced to the public that, if elected, he would give the American people the Government's information about UFO's. This did not happen, and Mr. Carter was given

a complete run-around and I could tell you more about this, because I

was contacted by the Pentagon on the matter.

The new Project Blue Book has 1&8 present,

and/or former,

Air Force, NC

NASA, and intelligence g athering agency personnel, among others, acting

as adviser-consultants to PBB - anonymously. These are

persons who,

fo

the most part, have/had

been actively

engaged in earlier

UFO reports fo

their respective

agencies, and who are

still

muchly interested.

So, with this brief back-ground of information about me and about Gover ment participatiaz, the "challenge" I have mentioned would be to have you make inquiries at the highest levels of "officialdom" about what ou Government really knows, whether or not there ARE alien bodies located ANYWHERE, what happened to the crashed "flying saucers", where are the photo's taken b y Air Force personnel through on b oard gun cameras, and similar questioning. I am positive you would find that even you would be getting a general run-aroun and could not receive satisfactory answ to the above. I think you will/would find

that you are not receiving

all the information you should be receiving and which should be very evident to you after making several inquiries. You may tend to drop

th

matter, thinking you are receiving answers to your questions, but

this

will not

b_e the case, Ia

ssure you.

0s' /1

FQBQIQ 3

MI . A'1{ '

I -Lr. Sessions, I will not take more of your time in this matter, but,

if you are interested, I would appreciate your looking into the matter.

You may w ish to appoint one of our office; personnel to start making

which Agencies

and see

to which you inquiry about

in general,

UFO 's,

would be directed. Keep in mind, however, that some present office

you would be personnel, in the other agencies, may not know what

Air Force Project Blue inquiring about -and will tell you that the

the Air Force no longer

Book closed it's "doors" i n 1969, and that

importan

-this I already know. The

Sightini reports

investigqtes UFO

agencies; such as

key is to go beyond the ir Force and into the other

Office of Defense, C.I.A., etc. President Bush, when asked about

the

half of it". As ym

do not know the

UFO's, told

the gerson

askirg "You

know, President ush was formerly with the C.I.A@ His comments are on tape, by the

way..

this should suffice for this time. I appreciate your

Well, I think

patience in reading this letter, and should you desire any additional

know. I would like, ver; infonnation, please do not hesitate to let me

matte much, to work through you, and with you, to endeavor to bring the

of UFO's to a conclusion -if that conclusion is an honest one.

I hope you had a nice visit,with your Dad, and c ome back for a visit

again, soon.

Very sincerely ,

r

i

P.S. As sort of an "ultimate" challenge -why not ask President Bush, himself?

I

/"Wired. and a mg-3

the

4353111 by

Unlled sum

1,

4'".-~92 92

538

. SEP H985

$Rc'p

$38

Air

CL.Ll-I

67°

-T _. ' "";"v~a.

Nwayum E r -__§~_ -'n'$l !'vg¢4_.,|

._____ <5 _92

67¢;

A

*I have received your July 24th letter in which you ask

for my help in securin information relative to investigations of unidentified flying ob ect UFO! sightings.

I have discussed your request with my colleagues, and I would first like to explain that the investigation of UFOs is not now nor has it ever been the responsibility of the FBI. The Department of the Air Force conducted investigations and studies of UFO reports from 1947 to 1969. On Deceber 17, 1969, the Secretary of the Air Force announced the termination of "Project Blue Book," and the Air Force has furnished all documents regarding its investigations of UFOs to the Modern Military Branch, National Arch ves and Records Administration, Eighehn

Street and Pennsylvania Avenue, N.W., Washington, D.C. 20408. I

understand this data is available for public review and analysis.You may wish to make an inquiry

of the Modern Military Branch for

the answers

to some

of your

questions.

Also of

possible interest,

the National

Aeronautics and

Space Administration

was asked

b President Carter to

look into

the possibility of resumin UFO investigations in 1977. After

studying all the facts available, it decided that nothing would be gained by further investigation, and the Department of the > .Force agreed with that decision.. You may also want to check with the Nat onal Aeronautics and Space Admin stration in connection

with your

research. ,

O 15- P o -121?!

I am not

aware of any Federal

agency tasked

wi

the responsibility of investigating UFOs

and

hope this information

dill be of help to you and

your organization.sincerely yours,

U!

§iZ2. ..3.":_

_

Wd a m S. Session!em no Lu __

_

Azxfm

William

S. Sessions

mmm__jjj Director

- _ _ '>,}9E"°;:::f=.. 2.3, O3 " Q doll!-.i..i

Imp. _____l

.-'.'Z'.1"_"'_1 -I-Iwww -_-_ .-c a 1ON. 00¢.

Public Alla.Roe. IA 9'"-Toch. Sent.Training i.ON. Llallnl I Int. Alli. _i

Yolophono Rm. _._

7lrO¢QI'I ROG C]

i

SEE NOTE PAGE TWO

bl

c/

92:.

h

NO l "F!.' .._ ,_. n dis levels or Government~ebout what our Government really '

knows about. UFOs wh th '

9 phone conversation he h ad witb..t.he Director while the Director.

-was visiting his father in Fort Smith. He says he

C1158

Ums-and-the role=__o£ U.S_

, and he indicates

the

gm? identi a ble in Bufiles, . A70what appears to be e brie!

, e er or

not there

are

alien-bodies located

anywhere, what h appened to the crashed -"£lying saucers," where are the photos taken by Air Force personnel through on-board gun c as and similar questioning. Above response r eviewed by

S iolmt Crimes Unit, CID. Substance or paragraphs 2and 3 o response previously provided to other inquiries on the

investigation or

UFOs.

,-92

..?

513024; ?'92|.:~|.i'- 4

ma. AD-LES ._._ wee Cw? -

T" °

-2...

Adm Sam. ..._.__¢"- °'5°"9-C/Em. =.-.¢.,_._.__.. 1- P~===1= ~="*-----' Hr >e=-1

_ _____ ,1. _-

.

~~-01 ' If J i -.1-u--¢:.'eCIO' ......_-H = - '

'1." "~'~,=-c NJ-.-92.~.-n: .-.. 5'-£113. ._..._...__. $1 ! 7-WT -V-- ---'

_ '.',?;:.-':!~".-~.' .._....._.-...T"1"<'3 5*~5- --'x ab /

92

(企业管理套表)实验六UFO报表管理

(企业管理套表)实验六UFO报表管理

实验六财务报表编制 【实验目的】 1.理解报表编制的原理及流程。 2.掌握报表格式定义、公式定义的操作方法;掌握报表单元公式的用法。 3.掌握报表数据处理、表页管理及图表功能等操作。 4.掌握如何利用报表模板生成壹张报表。 【实验内容】 1.自定义壹张报表 2.利用报表模板生成报表 【实验资料】 1.货币资金表 (1)报表格式 货币资金表 编制单位:明达科技年月日单位:元 项目,行次,期初数,期末数 库存现金,1,, 银行存款,2,, 合计,3,, 制表人: 说明: 表头: 标题“货币资金表”设置为“黑体、14号、居中”。 编制单位行设置为“楷体、12号”。 年、月、日设为关键字。 表体: 表体中文字设置为“楷体、12号、加粗、居中”。

表尾: “制表人:”设置为“楷体、12号、右对齐”。 (2)报表公式 现金期初数:C4=QC(“1001”,月) 现金期末数:D4=QM(“1001”,月) 银行存款期初数:C5=QC(“1002”,月) 银行存款期末数:D5=QM(“1002”,月) 期初数合计:C6=C4+C5 期末数合计:D6=D4+D5 2.资产负债表和利润表 利用报表模板生成资产负债表和利润表 【实验准备】 引入光盘中“实验账套\实验五”下的账套数据 【实验要求】 以“11刘宁”的身份进行财务报表编制。 【操作步骤】 1.启动财务报表系统(如图6-1所示) (1)双击左侧“财务报表”菜单项,进入“UFO报表窗口”。 (2)单击“日积月累”对话框中的“关闭”按钮。 (3)单击工具栏中的“新建”按钮,建立壹张空白报表,报表名默认为“report1”。 图6-1

UFO报表 答案

UFO报表 一、UFO报表判断题 1.用友UFO报表系统是报表事务处理的工具。T 2.UFO报表可直接在格式状态下获取总账数据。F 3.在UFO报表的格式状态下可以进行删除表页的操作。F 4.在UFO的数据状态,可以调整报表的行高和列宽。T 5.在UFO中只能从总账中提取财务数据。F 6.在UFO中单元中的数据类型只有表样型、数值型和字符型三种。T 7.UFO中关键字偏移量为负数,则表示关键字的位置向左偏移的距离。T 8.在数据状态下可以修改UFO报表的审核公式。F 9.在UFO报表系统中,审核公式的正确性只能用实例验证。T 10.UFO数据状态下只需录入单位编码即可完成损益表的计算。F 11.执行UFO报表审核操作能更正数据错误。F 12.执行UFO舍位操作后,工作界面展示的报表是生成的舍位报表。T 13.在UFO中,透视功能是查询不同报表文件中的同页数据。F 14.UFO报表的所有数据单元都可以联查明细账。F 15.UFO中可以在命令行方式下使用语句。F 16.UFO报表中可在同一表页上插入多个图形。T 17.在UFO命令窗口输入命令回车后,可以马上看到运行结果。T 18.在UFO二次开发窗口下输入命令行后,可以提示语法错误。F 19.在UFO中生成一张新表时,所有的单元都被默认为是字符单元。F 20.在UFO报表中,关键字的主要作用是标识表页。T 21.在一个UFO报表文件中,选择了“月”作为关键字,还可以用自定义方式再定义“月”作为另一个关键字。F 22.在UFO报表系统中,可以自定义报表摸板。T 23.在UFO报表系统中,可以在格式状态下插入直方图。F 24.在批命令文件中,既可以使用半角字符,也可以使用全角字符。F 二、UFO报表单选题 1.以下哪项不是UFO报表的功能?(D) A.导入标准财务数据。 B.可管理多达99,999张相同格式的报表表页 C.制作10种图式的分析图表 D.联查有关凭证 2.UFO报表不能导出以下哪种文件格式?(C) A.EXCEL文件(.XLS) B.LOTUS1-2-3 C.WORD文件(.DOC) D.ACCESS 数据库文件(.MDB) 3.UFO报表的数据处理能够完成以下哪些任务?(B) A.格式排版。 B.舍位平衡。 C.修改单元公式 D.设置关键字。 4.UFO报表的正确的基本操作流程是(A)。

用友系统UFO报表常用

UFO报表处理 第一部分报表公式及函数 UFO电子报表主要由报表公式编辑\报表命令\二次开发(批命令使用)组成,这里只对常用的一些操作做一简单述叙. 一、UFO的基本概念 (一)单元 数值单元:15位的有效数字; 字数单元:63个字符或31个汉字; 表样单元:63个字符或31个汉字; 单元的表示: 1、〈列标〉〈行号〉 2、〈列标〉#〈行号〉:如A#2 (等同于A2) 3、!<列标〉#〈行号〉:如!1#2 (等同于A2) 4、!!##:表示当前表面的最大单元(以屏幕显示的最大行列数为准,不是表尺寸)。 (二)区域 1、〈单元名称〉:〈单元名称〉如A3:C14;C14:A3 2、〈行〉:"#5"表示第5行的所有单元组成的区域; 3、<列> : "B"或"!2"表示B列所有单元组成的区域; "!!"表示表页中最后一列所有单元组成的区域; 4、〈行〉:〈列〉"#5:#7"表示第5行到第7行所有单元组成的区域;:#1:##"表示整个表页的区域; 5、<列>:<列> 如"B:D"或"!2:!4"或"B:!4"或"!2:D"表示B列到D列的所有单元组成的区域。"A:!!"或"!1:!!"表示整个表页的区域。 区域描述:“报表名”—>〈区域名称〉@表页号 如:B1:B11=“利润表”—>A1:A11@5 (三)关键字 关键字是游离于单元之外的特殊数据单元,可以唯一标识一个表页,用于区别并选择

表页,为多维操作起“关键字”的作用,UFO提供六种关键字:单位名称;年;月;日;季。 (四)筛选 筛选是执行UFO命令或函数时,根据用户指定的筛选条件,对报表中每一页或每一个可变行(列)进行判断,只处理符合筛选条件的表页或可变行(列)。 筛选条件分表页筛选条件和可变区筛选条件,表页筛选条件指定要处理的表页;可变区筛选条件指定要处理的可变行或列。 格式: FOR〈表页筛选条件〉〈;可变区筛选条件〉 其中:表页筛选条件确定要处理的表页,若省略则指当前表页;ALL表示选择所有的表页。 例:C2:C5=E2:E5 FOR 年〉2002 FOR 年=2002 AND 月>10 (五)关联 UFO报表中一张报表中的不同表页或不同的报表中存在着经济或勾稽关系,要根据这种对应关系找到相关连的数据进行引用,就要定义关联条件。UFO在多个报表之间操作时,主要通过关联条件来实现数据组织。 关联条件跟在命令、函数的后面。 格式: RELATION〈本表单值表达式1〉WITH 〈对应报表单值表达式2〉[,〈单值表达式11〉WITH 〈单值表达式22〉] 例如: 1、RELATION 月WITH “ZJB”—>月 表示取“ZJB”报表与本报同月的一页的数值 2、RELATION 2 WITH “ZJB”—>季 表示取“ZJB”报表第二季度这一页的数值 3、A=“LRB”—>B RELATION 月WITH “LRB”—>月+1 表示取“LRB”报表上一月B列的数值

用友U8-UFO报表操作技巧

利用用友UFO系统可以编制对外报表又可以编制内部报表,还可对报表进行审核和汇总,也可根据预定格式生成报表,它是报表数字处理的工具,它的任务是涉及报表的格式和编辑的公式从总账和其他业务系统中取得有关的会计信息并自动编制会计报表的数据。笔者通过学习用友UFO报表系统,对如何快捷的掌握UFO系统以及如何灵活运用UFO系统总结如下操作程序: 首先,编制对外报表的操作程序: 1、打开或新建会计报表。在UFO系统文件菜单下点击“打开”按钮,如系统已生成的“资产负债表”,或当系统中没有生成任何报表时点击文件菜单下“新建”按钮,则可生成一份空白表格,根据规定的格式输入内容即可。 2、选择会计报表模板。由于生成空的表格后输入内容比较耗时,U8软件中已经预定了行业的会计报表,称为模板,在模板报表中选出最适合的报表。在窗口“格式”下拉菜单下选择“报表模板”,出现选择框(您所在行业:新会计制度科目(假设),财务报表:利润表(假设)),则电脑提示,模板覆盖,按“确定”后电脑会确定一张“利润表”。 3、修改格式。如果生成的会计模表不适合本单位,也可对这张报表进行修改,在“编辑”下拉菜单下增加“行”“列”“加宽”“缩小”等进行调整。可以对每一单元属性(含类型、对齐方式、字体颜色、表格边框)进行修改,也可对相邻的单元合并成一个单元,称为组合单元。具体操作为在“格式”下拉菜单下点击“单元属性”,在常用工具栏中点击“合并单元格”等。 4、试算(输入关健字和确定账套)。表头部分的“公司名称,年,月”用于区别同一格式,不同数据来源的表页,在UFO系统中称为关健字。如何选择关健字?通过介面左下角的“格式”状态进行切换为“数据”菜单下点击“关健字”,出现对话框,录入相关内容(含单位名称、单位编号、年、季、月、自定义),输入完毕后系统会出现“是否重算?”,点击“是”,则报表的各单元格会出现数据,这组数据可以在用友企业门户中的“总账”系统进行核对。如何确定账套?当前生成的报表就为当前操作窗口下的账套,如果想在当前窗口下生成别的账套的报表数据,则在“数据”菜单下“计算时选择账套”,则电脑会跳出新登陆号,选择一个账套,则报表中的数据源就不一样了。 5、修改公式。当报表的格式修改完之后,下一步我们就要确认报表取数的公式定义得对不对,能不能把这套账的准确的数据取出来,我们知道UFO报表中在格式状态下表示数字的地方用“公式单元”表示,也即意此单元可用公式描述出来,这个公式实际就是取数的方式,我们叫取数函数。由取数函数来表示取数的规则最直接的办法就是检查取数函数。检查的方法有:一是激活要检查单元公式,在编辑栏中可以看到公式,如果发生的公式不准确,则要修改,可以用编辑栏中的“fx”修改,点击“fx”,出现一个定义公式框,先删除原来的公式,就需输入正确的公式,当不熟悉系统时点击“函数向导”,出现第一个选择框:左边是函数分类指与UFO系统有接口的具体业务分类如财务函数,右边是函数名指与函数分类有关的名称如发生额。点出“确定”出现业务函数的函数录入的第二个选择框:在不熟悉系统是先点出“参照”按钮,系统就会出现财务函数选择框,具有(1)账套号(默认)(2)会计年度(默认),默认表示当前打开的账套号,如果不想默认,也可在下拉单中选其他账套号。(3)会计科目:指反映的是哪一会计科目如主营业务收入。(4)期间:指这张表是按什么范围来取数的如月份。(5)方向:指会计科目属于借方还是贷方。(6)包含未记账凭证(有要求时可选择)六个要素,其中最重要的是选择会计科目,点出“确定”,退回到定义公式的窗口,公式修改完毕。改动已有的单元公式另一种方法也可在当前单元格双击鼠标,就可修改。录入新的函数时用“fx”或直接在键盘上按“=”,但不可用当前单元在编辑格中录“=”号,财整个报表的格式录入完成。

相关文档
最新文档