Excel MIDI Files

Version 21.0
	Incorporation of Chain Functions.
	Improved MIDI TOOLS Tab Menu.
	Removed Columns Sequence from Sequence Sheet to avoid confusion with the respective Row
	Improved Code where minor glitches have been solved.
Version 10.1
	Improved Functions getNoteOnScale and getScaleOnChord.
	Sheet AUXILIAR improved with Chord Progression implementation.
Version 10.0
	Functions added that make the process of working with Music Theory much more simple.
	Sheet AUXILIAR added to take advantage of the new added Functions.
	Sheet FUNCTIONS added listing all Functions that can be used in processing Musci Theory.
	Sheet MUSIC THEORY renamed to SCALES.
	On the Sheet SEQUENCE 6 Columns have been added to be used by the new Functions.
Version 9.6.1
	Added examples of applied CHAOS THEORY as informative source for composition.
Version 9.6
	Added VBA formula that returns the Device port number based on the Device name.
	Added formulation for returning Device port number based on Device name.
	Now the Device Output connection error is explicit in what the problem is.
Version 9.5.3
	Added formulation that returns notes according to Scales
Version 9.5.2
	Formulation for linear Automation corrected in order to refer to the right cells
	Formulation for LFO adjusted to count columns as steps regardless the step numbering
Version 9.5.1
	Added new Formulation to linear automation
	Formulation area edited to be more useful and understandable
Version 9.5
	The reference of Compositions can now be a string helping in its interpretation with sequences and respective elaboration
	The tables order in the ACTION TYPE sheet was changed to make it more useful than before
Version 9.4.2
	Corrected situation when mouse icon changes during playback introducing this way delays while playing
	Stops Clock Sync at the end of Sequence or Composition ending and not only when canceled
	Scale reduced from 100% to 75% so that more info is visible on screen
	All font size changed to 9 in order to condence more info on the screen
Version 9.4.1
	Corrected situation when a named "Set" is given as a number and not converted to a String as it should
Version 9.4
	Select case on table coordinates replaced by a much faster User Type Variable (Generally Increased Performance)
Version 9.3.3
	Correction of ARPEGGIO and REPEAT to a Swing of 50% and not almost 100% like before for all instances
Version 9.3.2
	Implementation of REPEAT also at Track level and not only Note level
Version 9.3.1
	Corrected Status Bar being disabled when playing in Performance level 1
	Added key shortcut to Sequence and Composition playback (Ctrl+Q, Ctrl+W)
Version 9.3
	Added buttons that Flip selected values Horizontally and Vertically
Version 9.2.1
	Corrected the PLAY button action on the sheets.
Version 9.2
	Row and column Randomizer are transversal to multiple and distinct selections
	Excel processing transition during playback avoided
	The file now shows the "MIDI TOOLS" menu when it is opened
Version 9.1
	Added a custom menu "MIDI TOOLS" with multiple actions like Play, Randomizer and other extras. This makes new tools very easy to access and use
Version 9.0
	Introduced first Add-In Position Randomizer
Version 8.7.1
	Solved bug that resulted in skiping first Sequence
	Solved the issue with the Composition position always used as the real Composition number, now Composition numbers are typed instead of formulated allowing to be in any position, order or numering
	Removed de reference name on first Sequence and Composition rows allowing the deletion of any of their rows including the first ones
	Links betwheen sheets were corrected
Version 8.7
	Sequences and Compositions are now made Solo or Mute accordingly with Mode value where 0 is Mute, 1 Enabled and 2 for Solo. Now filtering out rows doesn't disable Sequences or Compositions
Version 8.6
	Added Trim for Pattern enabling the selection of Pattern intervals to be played on Sequence Sheet
	Solved issue with first DoEvents call when animation are enabled. Now DoEvents is firstly called before any playing and not while avoiding this way transition delais for DoEvents first call
Version 8.5
	Added option for greater Resolution than 24 Frames per Quarter Note (PPQN)
Version 8.4
	Added the button Panic! that Releases all keys and sustain pedal in all playable devices
	Improved + and - buttons in terms of speed (now it runs in manual mode)
	Play code improved to run after hangs dismissing this way Excel restarts
Version 8.3.1
	Formulas on Sequence Header Scale improved to comply with the insertion of User Auxiliar Columns
Version 8.3
	Added + and - buttons to increment and decrement by 1 selected non empty cells, handy for making fast changes without typing
Version 8.2
	More resilient code when applying Filters
	Added F9 update button to facilitate Random functions usage
	When Automatic Calculation is disabled it disables also while Saving Document
Version 8.1
	Solved issue with filtered out Sequnces and Measures not previously disabled as intended
	Increased the total possible amount of devices from 16 to 32
Version 8.0
	All fields were replaced by Names (Formulas->Names) so that now it is possible to insert new columns without disrupting the macro. This is useful to introduce auxiliary columns in conjunction with developed Formulas
	The animations were also corrected to work as intended (When Enabled)
	The list of enabled devices results in clean text without strange characters
	Changing Sequence order without Automatic calculation enabled now doesn't affect playing even with wrong Sequence number. Same applies to Compositions (Useful when using random formulas)
	Generally improved code
Version 7.7.1
	Solved a bug with the Version 64bit of Excel
Version 7.7
	Start and Finish Loop fields on the SEQUENCE Sheet now play accordingly to the Loop number (not as mask)
Version 7.6
	Corrected negative Pitch Bend offset of (1/16383) / 2
	Designation of "Group" identifier replaced by "Set" and is now Mandatory
Version 7.5
	Pitch Bend linear progression with LSB values and NOT only MSB ones
Version 7.4
	Rearrange of Track hierarchy under Device and Channel with identifiers restricted to the respective scope
Version 7.3
	Added optional column Group to allow new option for filtering and aggregate multiple Tracks
	Measured term replaced by PATTERN
	Increased the number of PATTERNS from 16 to 64
Version 7.2
	Added Loop Start column and all fields exclusive to Sequence Loops have been reformulated as Start, Finish and Length
Version 7.1
	Now Notes with 0 value given turns them off the same way the value 1 turns them on
	Now on Sequence Sheet automations do end when Last Loop given is achieved
Version 7.0
	Program Change are now set only as Action Type
	New collumn for Last Loop that alows a Sequence to stop before the end of the entire Loop
	Solved Bug at the Last 1024 Measure in Composition mode (hypothetical scenario)
	Added the word END to the end of Rows and Columns to help in selection entire fields while pressing CTRL+SHIFT and directional keys
Version 6.6
	Composition Sheet with Measures entered directly on From To fields
	Added Ctrl-Q shortcut for Composition Play while on other Sheets
	After Touch improved to consider the Palayed Notes
	NOTE Parameters are now retained by each Played NOTE, like, VELOCITY, DURATION and DELAY
	Generally improved Tracks Code
Version 6.5.3
	HOLD Action Type allows Note Replay like in Sustain mode
	Added all CC Controls concerning the UNO Synth (may be easily deleted)
Version 6.5.2
	HOLD Action Type now not only Holds Notes but also avoids Note Replay
	Solved BUG on LINEAR transitions on Action Types like CC and PITCH
Version 6.5.1
	Added Composition estimated total Duration
	PITCH and CP Action Types now with their scopes corrected and restricted to Channel
	Action Types table updated accordingly to the corrections on PITCH and CP
	Improved Code efficiency
Version 6.5
	Added ROUTE Action Type that enables Routing Notes to other Notes
	Better implementation of the CLOCK Action Type, with explicit START, PAUSE and REWIND Parameters
Version 6.4.1
	Enabled Polyrhythm Clock signals
	Clock Signals inconsistency corrected
Version 6.4
	Added CLOCK Action Type to enable Time Sync on specified Device
Version 6.3
	Improved Action Types Auxiliary Sheet
Version 6.2
	Introduced Polyrhythm with the BEATS Action Type allowing triplets (BEATS = 3)
	Time signature is now on the SEQUENCE Sheet
	Generally improved code
Version 6.1
	Run time efficiency highly improved
	Delay in Arpeggio now corrected and so become more efficient
	Notes attributes have now a separate Action Type for DURATION and VELOCITY
	Added HOLD Action Type
	Created new Sheet listing all available Action Types
	TRANSPOSE Action now applies also to DURATION, VELOCITY and REPEAT or other Actions specific to Note attributes
	Status Bar now informs of current Measure/Loop and Step
	Corrected the Frame duration for different time signatures than 4/4
Version 6.0
	Complete integration of processing code inside Tracks enabling future new sophisticated features
	Tracks are now enumerated allowing multiple tracks on the same Device and Channel
	Added push button to list available devices
	LENGTH and OFFSET actions are also applicable to the entire Track when Parameter is not given
Version 5.1
	General improved code that also avoids repeated CC messages
	Adds support for Track in LINEAR or NONLINEAR mode concerning CC Step transitions
Version 5.0
	Improved code now focusing on Tracks
	Adds support for Track in MONO mode
Version 4.0
	Allows to Enable and Disable Time Sync
	Works now based on Tracks and Devices
	Adds support for Arpeggio and Repeat functions for each Track
Version 3.4
	Solves multiple issues for multiple measure stepping conserning CC messages and similaires
	Finishes Sequences or Composition with a last expected CC and similaires values allowing cycle closure
	Added some examples of Excel Formulation A and B
Version 3.3.1
	Solves the BUG of not releasing all pressed keys at the end of all playing
	Corrects the condition for Frame start avoiding repetition of notes in the same Step (OFFSET)
Version 3.3
	Corrects the formula for FRAMES to be 24 Frames per 1/4 note and not 24 Frames per Beat
	Allows filtering out as a mean to disable Sequences or Compositions
	Now uses Frames as unit for LENGTH and OFFSET
	The sequencer allows the selection of a range of Measures instead a single Measure
Version 3.2
	Corrects the formula for LENGTH and OFFSET
Version 3.0
	Introduces Configuration parameters for NOTE, like LENGTH, TRANSPOSE and OFFSET. This way there is no need to define the end of a note anymore so the NOTE end is now based on its LENGTH
Version 2.7.3
	Linear transition between different BPMs corrected as linear progression
	Performance level 0, 1 and 2 well adjusted for the intended purpose
	DoEvents is now called each second regardless the time signature (BPM)
Version 2.7.2
	Status Bar now indicates the MIDI Message being sent 
	Frame rate and midi clock corrected for different time signatures than 4/4
	Messages ON and OFF added as alternatives for NOTE
Version 2.6
	Loops only trough ENABLED Compositions and Sequences resulting in faster execution 
	Variation of Tempo/BPMs with linear progression useful for automations with smoother transitions
Version 2.5.3
	Added DoEvents for each Measure/Loop to enable Esc key during all play
Version 2.5.2
	Solved the bug concerning disabled sequences between enabled ones
	Solved the wrongly timed Stop Clock signal at the end of Composition or Sequences
Version 2.5.1
	Allows Blank Cells on the Channel Column for the reuse of the same Channel of the last previous enabled Device
	Allows Blank Cells on the Program Column for the reuse of the same Program of the last previous enabled Device
Version 2.5
	Sends Midi Clock signals to keep devices in sync
Version 2.4
	Numbers and values input are now from 0 to 127
	Added a new Sheet named Music Theory to help on music composition
Version 2.3
	Faster Code using an internal Array instead the data Sheet
Version 2.2
	Able to control up to 16 distinct Midi Devices (Ports)
Version 2.1
	New option to select the number of Frames used for linear progression interpolation (for computer performance)
Version 2.0
	Supports linear progression Automation
Version 1.19
	Supports discrete progression Automation
	Solved previous Bugs of unnecessary repeated Midi messages and no Program selected on final keys release
	Added Description field
Version 1.13
	Allows different time signatures
Version 1.12
	Cleaner and improved Code
	New performance option for slower computers
Version 1.11
	Cleaner Code
	Solved previous Bug concerning keys unreleased between different Measures
Version 1.10
	Supports Midi Programs