Презентация на тему Business analysis

no new challenge
The creation of automatized reporting, KPI with

excel

The analysis of Data, the market analysis…

The passion had gone out, the computer began to work without me

Leaving me alone, facing the machine

No challenge, no transcendence in my work, no self-surpassing

So what else? How could I create my own challenge?

Challenge.
I had to find it, to continue to learn,

to improve myself, to develop new skills, or maybe just to project myself in something crazy, strange or finally maybe just different.

To be a Human with his own personality, and not the extension of my last software and realizations.

Because others considered that it would be impossible…
I had to try it, I had to achieve it.

I wanted to leave this mental Prison that I created in my comfort zone.

take in account at this moment:
Determinate my area of

abilities, my own limits and the way to surpass them.
Imagine the final result and conceptualize the main aspect of the layout and data.
The creation of a statistical basis (Statistics of creatures, presentation for each creature, Evolution , Attacks…)
The creation of the Database ( Pictures of creatures, attacks, movement, players, etc.…)
The main rules to respect during the game
The realization of the Software and programming

structuration of VBA (Autorun…)
Variable (dim) and controls
Graphical & Indicators

& Complexes-formulas
Userform / Image- & Object Integration and management
Multi-loop and conditions- & Probability control
Time management
Error-resolution & treatment of methodology of resolution

(Map with several types of environment)
Permits Interaction between the

player and his environment
(identification of wall, of the type of field ( Grass, forest, sea…) teleportation of the player….)

Determine the type of environment and create some options of fight.
Have the way to fight several type of enemies (human and Pokémon) with some specifics options ( Environment of the battle, dialogs, variation of the level and statistics, evolutions)
Allows the player to use several Pokémon to fight foes.
Create an A.I able to take basic choices during the battles.
With the different sprites created give the feeling to assist to a real match.

Attacks in relationship with the Statistical Information integrated in

the Software at the beginning.

Creation of several types of Environment for the options of fight
15 possibilities by type of environment
The software realised with Excel is able to choose randomly a picture

Creation of the other players managed by the Artificial Intelligence of Excel.
Each Adversary has his own dialogs and use a type of Pokémon.

Integration of some Pictures for the object which are available and that the player can use / buy / sell :

During the fight, the software needs to use some pictures of Pokémon to automate the battle. Excel will import the different pictures, when it is necessary.

Userform

Adversaries

Pokémon of the player

If the adversary is K.O, the Macro will import this picture

The creation of the picture database is a big job
- Pictures to download
- Pictures to modify ( Ex. Pokemon-KO, pictures for Userform,blank background )
- Structuration of the database ( png, jpg)
- Respect and reliability matching the name that I integrated in the statistics sheet of file(s).
unfortunately annoying but MANDATORY.

50 hours of work

of the map represented around 50 hours of work.

It

represents a very investment, but I wanted to have something special, near the reality of the original game.

But I added in the same time new buildings, and developed the layout.

The number of cells used has naturally a drawback: the increase of the size of the data.

leave the House.
Identification of the field: Here water =>

SURF
A new sprite is used when we left the continent.

The player is meeting an adversary. The macro will import the dialogs planed for this adversary.

The fight will soon begin. Let’s go.

of the game, I integrated some basic functions of

the game, for example, the Pokematos.

The Pokemap

The Pokedex

The Inventory

The creation of the Pokematos with an User form represented around 20 Hours of Work. But it is in any case useful for the player.

to integrate all the data concerning the Pokémon and

their abilities, their main statistics, the information to allow them to evolve (Stone or experience)

Ex: the Pokedex

the attacks
(name, type, power and precision).
Statistics and

Database

take in account the table of correspondence CE (strengths

and weaknesses) and this formula to calculate the result of the attacks

Statistics and Database

is important. A Pokemon with a high level knows

more attacks. So we need to look for in a data base, to know the attacks that Pokemon can used.

Pikachu reached the 55th level.
The last attack that he learned is “Fatalfoudre” at the level 45.
In our example, Pikachu know all the attacks.
He can use all his abilities against Rattata.

Rattata in our example is weak.
He knows just 2 attacks.
But he will learn soon Viveattaque. If he survives to the battle, of course.

Statistics and Database

or in a forest, we can meet some wild

Pokemon, and try to capture them.

But the probabilities of meeting are not the same everywhere.
The typology of the environment has an impact about the type of Pokémon.

Example : In the water, we have 10% (1/10) of chance to meet Stary.

In the forest, we will meet often Chenipan ( 6/30) and sometimes Insécateur (1/30)

can use a stone to transform our Pokemon, or

our Pokemon can evolve at the end of the fight.

But we need to have this information in our Databank to know it.

opened by the Program.
You can choose your next Attack:
Here

the example of the code beside the Combo box

To begin the animation

VBA is going to use the code to animate the attack, search pictures in the databank, to import them on Excel and use it to launch the attack in the game.