JPS58222345A - Integrating method by means of electronic computer - Google Patents

Integrating method by means of electronic computer

Info

Publication number
JPS58222345A
JPS58222345A JP57104825A JP10482582A JPS58222345A JP S58222345 A JPS58222345 A JP S58222345A JP 57104825 A JP57104825 A JP 57104825A JP 10482582 A JP10482582 A JP 10482582A JP S58222345 A JPS58222345 A JP S58222345A
Authority
JP
Japan
Prior art keywords
multiplier
program
information
prt
procedure
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
JP57104825A
Other languages
Japanese (ja)
Inventor
Katsuhisa Ebihara
蛯原 勝久
Masatoshi Inari
稲荷 政敏
Tomio Nihei
二瓶 富夫
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fujitsu Ltd
Original Assignee
Fujitsu Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Fujitsu Ltd filed Critical Fujitsu Ltd
Priority to JP57104825A priority Critical patent/JPS58222345A/en
Publication of JPS58222345A publication Critical patent/JPS58222345A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F7/00Methods or arrangements for processing data by operating upon the order or content of the data handled
    • G06F7/38Methods or arrangements for performing computations using exclusively denominational number representation, e.g. using binary, ternary, decimal representation
    • G06F7/48Methods or arrangements for performing computations using exclusively denominational number representation, e.g. using binary, ternary, decimal representation using non-contact-making devices, e.g. tube, solid state device; using unspecified devices
    • G06F7/52Multiplying; Dividing

Abstract

PURPOSE:To obtain a program inexpensively and to attain ease of correspondence with user's conditions, by defining a multiplier on an external file in the form of matrix, defining the operating procedure with a multiplicand in another location, and reading out the operating procedure for processing integration. CONSTITUTION:A storage device is prepared with an index information table SDT, a multiplier table MLT, an operation table PRT, and a calculation table CLT. The order of arrangement of each information of the table CLT is defined in the table SDT as index information like A, B, C, D. The multiplier is stored in the table MLT in the form of matrix as RTBL-A. The calculating procedure of the multiplication procedure is stored in the table PRT. The integration processing operation program reads out the content of the table PRT for decoding and execution. This means that the correction is to be done individually for each table if the correction of the information necessary for the multiplication processing is required, and it is not required to correct the program.

Description

【発明の詳細な説明】 +1)  発明の技術分野 本発明は処理プログ2ムの改訂、ユーザ条件の変更に対
し容易に対処できるS鼻′041i一方法に関する。
DETAILED DESCRIPTION OF THE INVENTION +1) Technical Field of the Invention The present invention relates to a method for easily dealing with revisions of processing programs and changes in user conditions.

(2)  従来技術と問題点 電子計算機により乗数と被乗数との撰算演舅な行ない、
複数の槙り結果ン加算する場合、被乗数が各ユーザ毎に
一定であって、且つ時期的に変化しない場合はシステム
を比較的容易に設計できるnまたユーザにとってもシス
テムの維持管理が容易である。しρ為しながら通常は、
具−ザ毎にも、時期的にも被乗数は変化することが多い
から事柄は複雑化する。例えば自治体が工事をするため
の経費計算ンするような場合、自治体の事情により計算
上考慮すべき事項が異なってくる。そのJ#項としては
大部会では夜間工事に限られるとか、地方では工事場所
が労働者の集合場所から遠隔の°所であるとか、積雪・
降雨の有無に影響されたり、地震・風水害に対する緊急
工事であるか否か等である。また土木建設工事の場合諸
経費の@接頓に対する割合がおよそ定められ曵いて、そ
れらを基準的計IL書に基づいて伽別的KiXt、てぃ
た。県単位の工事のように大規模な工事の場合グログ2
ムを組んで電子計算機により演算をすることが計画され
た。しかし前述の理由により被乗数の儂の変化すること
を考慮したプログラムが必要とされ、多(のユーザに共
通とはならないため、類似はし又いるが多数の1pグラ
ムを各別に作る必要があり、高価なものになりた。
(2) Prior art and problems Selective calculations of multipliers and multiplicands are performed using an electronic computer.
When adding multiple results, if the multiplicand is constant for each user and does not change over time, the system can be designed relatively easily.In addition, the system is easy to maintain and manage for the user. . Usually, while doing so,
Things get complicated because the multiplicand often changes from device to device and from time to time. For example, when a local government calculates the cost of construction work, the matters to be considered in the calculation will differ depending on the circumstances of the local government. Items J# include that construction work is limited to nighttime work in major subcommittees, that construction sites in rural areas are far from workers' gathering places,
These include whether the construction is affected by the presence or absence of rainfall, and whether it is an emergency construction work in response to earthquakes, wind and flood damage, etc. In addition, in the case of civil engineering construction work, the ratio of miscellaneous expenses to construction work was roughly determined, and these were calculated based on the standard budget IL document. In the case of large-scale construction such as prefectural construction, Grog 2
It was planned to form a team and perform calculations using electronic computers. However, for the reasons mentioned above, a program is required that takes into account the change in the multiplicand, and since it is not common to many (users), it is necessary to create a large number of similar 1p-grams for each one. It became expensive.

+31  発明の目的 本発明の目的は、前述の欠点を改善し、比較的汎用とな
るプログラムを作り、その改訂或いはユーザ条件の変更
を求められても容易に対処できる積算演算方法″(+−
提供することにある。
+31 Purpose of the Invention The purpose of the present invention is to improve the above-mentioned drawbacks, to create a relatively general-purpose program, and to provide an integration calculation method that can easily cope with the need to revise the program or change user conditions.
It is about providing.

+41  発明の構成 前述の目的を達成するための本発明の構成は、積算処理
により演算する場合の乗数なマ) IJクス形式で外部
ファイルに定義し、且つ被乗数との演算手順を前記外部
ファイルの他の場所に定義し、積算処理プログラムは前
記演算手順な胱出すことにより実行されることである。
+41 Structure of the Invention The structure of the present invention to achieve the above-mentioned object is to define a multiplier in an external file in the IJ format when calculating by integration processing, and to write the calculation procedure with the multiplicand in the external file. As defined elsewhere, the integration processing program is executed by executing the above calculation procedure.

1B+  発明の実施例 不発明の一実施例な示す回向について説明する。電子計
奥様の中央処理装置の動作により情報の格納・読出駿の
される。、、F憶装置に索引情報テーブル8DT、乗数
テーブルMIaT、演算テーブルpxT、lt算テーブ
ルOLTを準倫し、索引情報テープ/L/8 D Tに
は計算テーフ/&/C11Tにおける各情報の韮び順を
索引情報としてA、 B。
1B+ Embodiments of the Invention An example of the non-invention will be described below. Information is stored and read out by the operation of the electronic meter's central processing unit. ,,The index information table 8DT, multiplier table MIaT, calculation table pxT, and calculation table OLT are stored in the F storage device, and the index information tape/L/8D T contains each information in the calculation table/&/C11T. A, B with the order as index information.

0、 Dのよ5に定義する。また乗算テ:ブルMLTに
は例えはRTBL−Aと示すようにマトリクス形式で乗
数を記憶する6演算テーブルPR’l’は乗算処理ケ行
なう算出手j執を記述しておく。例えば算出手l鉄が ■ R工TORTBL−ム 1行2列 ■ OUL   B=&OO1 ■ auL  c=a”’JgB であったとする。演罵プpグ2ムは演算テーブルに格納
した内容を読出してそれを解読・実行させることで良く
統一化できる。そのためl 前記■の文に従い乗算テー
ブルRTBL−ムの1行2列の@0.05をシステム領
域&001に取出す &  0 0 1  =0.05 (2)前記■の文に従い&0010値をB情報部11・
・::、、。
0, D is defined as 5. Further, in the multiplication table MLT, a 6-operation table PR'l' storing multipliers in a matrix format, for example as shown in RTBL-A, describes calculation procedures for performing multiplication processing. For example, suppose that the calculation method is 1 row 2 columns OUL B=&OO1 auL c=a'''JgB.The operation program reads the contents stored in the calculation table. It can be well unified by decoding and executing it.Therefore, according to the statement in (■) above, extract @0.05 in the 1st row and 2nd column of the multiplication table RTBL-m to the system area &001 & 0 0 1 = 0.05 (2) According to the statement in ■ above, input the &0010 value to the B information section 11.
・::、、。

ちt1算テーブルの2番地に格納する。It is stored at address 2 of the t1 arithmetic table.

(3)前記■の文に従いム情軸即ち計算テーブルのl番
地に格納されている被乗数に、乗数としてB情fMン掛
けその結果をC情報即ち1真テーブル3番地に格納する
@ 10000X0.05=500 (4)乗算処理を繰返す文があるときそれt実行し、結
果奢加算するなどの処理な行なう。
(3) According to the statement in ■ above, multiply the multiplicand stored at address l of the mu information axis, that is, the calculation table, by the B information fM as a multiplier, and store the result in the C information, that is, address 3 of the 1 truth table @ 10000X0.05 =500 (4) When there is a statement that repeats multiplication processing, execute it for t times and perform processing such as adding the result.

次に乗算処理に必要な情報の改訂を要するとぎは、前記
各テーブルについて修正を個別に行なうことで良く、プ
ログラムそれ自身は修正することな要しない。
Next, when it is necessary to revise the information necessary for the multiplication process, it is sufficient to revise each table individually, and there is no need to revise the program itself.

16:  発明の効果 このようにして本発明によるとプログラムについ【安価
に作成でき、また−元管理により保守が簡素化される。
16: Effects of the Invention In this way, according to the present invention, programs can be created at low cost, and maintenance can be simplified through original management.

5j算テーブル・乗算テーブルについてその全部または
一部の共通利用ができるためシステム設計・工事におい
て導入工数が削減される。使用的または使用中ユーザに
ついての要件を容易に加味できるからあたかもユーザ専
用システムを有している意識が持てる。
All or part of the 5j arithmetic table and multiplication table can be used in common, reducing the number of man-hours required for system design and construction. Since the requirements of the user who is using the system or who is currently using the system can be easily taken into consideration, the user can feel as if he or she has a system exclusively for the user.

また情轢を改訂するときプログラム修正に比し工容易で
あるから作業工数が削減できるとい5効果がある。
In addition, when revising information, it is easier than modifying a program, so the number of man-hours can be reduced.

【図面の簡単な説明】[Brief explanation of the drawing]

図面は本発明の一実施例とし工テーブルの遊びを説明す
る図である。 8Dテ・・・・・・索引情報テーブル MLT・・・…乗数テーブル 01#τ・・・・・・計算テーブル PUT・・・・・・演算テーブル 特許出願人 富士通株式会社 代理人 弁理土鈴木栄祐
The drawing is a diagram illustrating the play of a machining table according to an embodiment of the present invention. 8D Te...Index information table MLT...Multiplier table 01#τ...Calculation table PUT...Calculation table Patent applicant Fujitsu Limited Agent Patent attorney Eisuke Suzuki

Claims (1)

【特許請求の範囲】[Claims] 積算処理により演算する場合の乗数をマトリクス形式で
外部ファイルに定義し、且つ被乗数との演算子@を前記
外部ファイルの他の場所に定義し、積算処理プログラム
は前記演算手順な読出すことにより実行されることを特
徴とする電子計算機によるa#舅演算方法。
Define the multiplier to be calculated by integration processing in an external file in matrix format, define the operator @ with the multiplicand in another location in the external file, and execute the integration processing program by reading the calculation procedure. 1. A method for calculating a# by an electronic computer, characterized in that:
JP57104825A 1982-06-18 1982-06-18 Integrating method by means of electronic computer Pending JPS58222345A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP57104825A JPS58222345A (en) 1982-06-18 1982-06-18 Integrating method by means of electronic computer

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
JP57104825A JPS58222345A (en) 1982-06-18 1982-06-18 Integrating method by means of electronic computer

Publications (1)

Publication Number Publication Date
JPS58222345A true JPS58222345A (en) 1983-12-24

Family

ID=14391166

Family Applications (1)

Application Number Title Priority Date Filing Date
JP57104825A Pending JPS58222345A (en) 1982-06-18 1982-06-18 Integrating method by means of electronic computer

Country Status (1)

Country Link
JP (1) JPS58222345A (en)

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPS56132662A (en) * 1980-03-19 1981-10-17 Tokyo Kaijo Kasai Hoken Kk Estimate issuing machine of portable type for car repair

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPS56132662A (en) * 1980-03-19 1981-10-17 Tokyo Kaijo Kasai Hoken Kk Estimate issuing machine of portable type for car repair

Similar Documents

Publication Publication Date Title
US6592626B1 (en) Method and system in an electronic spreadsheet for processing different cell protection modes
US9922019B2 (en) Persistently self-replicating cells
RU2390834C2 (en) Method and device for browsing and interacting with electronic worksheet from web-browser
JP5154002B2 (en) Method, system, and apparatus for providing access to a workbook model via remote function calls
US9875227B2 (en) Manipulating of labelled data for data entry in management applications
US7143338B2 (en) Method and system in an electronic spreadsheet for handling absolute references in a copy/cut and paste operation according to different modes
RU2421797C2 (en) Indication, definition and detection of electronic table document parameters
JP4806148B2 (en) Binding spreadsheet cells to data sources
US20020007380A1 (en) Method and system in an electronic spreadsheet for handling user-defined options in a copy/cut - paste operation
TWI423050B (en) Computer-implemented method, computer-readabe storage medium, and system for extensible value types in cells
Bourg Excel Scientific and Engineering Cookbook: Adding Excel to Your Analysis Arsenal
US20020103825A1 (en) Method and system in an electronic spreadsheet for persistently filling by samples a range of cells
US7743316B2 (en) Method and system for hiding sensitive data in an electronic spreadsheet environment
CN112748923A (en) Method and device for creating visual billboard, electronic equipment and storage medium
CN114201615B (en) Scientific research data change review method and server based on data snapshot
JP7339628B2 (en) Online report creation system using Excel tools
JPS58222345A (en) Integrating method by means of electronic computer
US11461544B2 (en) Spreadsheet with reuse functionality
JPH01147621A (en) Automatic program producing method
Soper et al. Computer spreadsheets for numerical analysis
US20200410161A1 (en) Computer-implemented method and computer-readable medium for enabling data referencing using one or multiple data connections between one or multiple source spreadsheets and one or multiple destination spreadsheets
JP3940771B2 (en) Calculation method that minimizes input and checking
EP1146438A2 (en) Handling absolute references in electronic spreadsheets during copy or cut and paste operation
JPH01290046A (en) File controller
Minker et al. COMMENTS ON “LOGICAL INFERENCE AS AN AID TO ANALYSIS IN LARGE DATABASES”