{'fraction_non_alphanumeric': 0.020285087719298246, 'fraction_numerical': 0.001644736842105263, 'mean_word_length': 5.083333333333333, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
FUNCTIONAL MODELING OF COMPUTING DEVICES WITH MICROSOFT EXCEL SPEADSHEET APPLICATION

applicable to combinatorial and sequential logic. This article develops the technology to be applied to computing devices (CDs). CD is a device capable of executing an algorithm provided as a microprogram. A CD consists of computational unit and control unit. In the process of the execution of a micro-command, control unit produces control signals, which cause computational unit to perform micro-operations and form logical condition signals. For the described technology of creation of working functional models to be applicable to CDs several main stages need modifications and new stages are suggested. The paper describes two modes of functional modeling: step-by-step and automatic. Step-by-step mode is implemented by limiting to 1 the number of iterations used in the spreadsheet processor (Microsoft Excel) formulae computations. The next step in this mode is activated by F9 functional key («Tick») and it performs single re-computation of formulae in the spreadsheet, which corresponds to running a single micro-command in the CD. Each step visualizes the changes of internal registries of the CD in a screen form. The automatic mode is implemented by setting the maximum number of iterations for formulae computations in the spreadsheet to be not less than the number of device’s ticks required to run the microprogram to its completion. The modeling and the development of the screen form are illustrated by example of division of 8-bit integers. All the advantages of the technology to create working functional models for computer nodes and blocks by using a spreadsheet application (Microsoft Excel) previously described for combinatorial and sequential logic are shown to be fully applicable to modeling of CDs as well.