+ Reply to Thread
Results 1 to 3 of 3

code omits values during simulation

  1. #1
    Registered User
    Join Date
    03-01-2019
    Location
    Mansfield
    MS-Off Ver
    2013
    Posts
    19

    code omits values during simulation

    Hi!
    I've written some code in which i run a simulation of the population dynamics of an insect. The simulation works perfectly for the first year and although the values for thefollowing year seem to be simulated correctly, the output omits certain values and i'm uncertain as to why that is. some simulated days in the second year (usually around the time of butterfly emergence) are completely omitted and i have absolutely no clue where i've made the mistake. i'm attaching my workbook for reference.
    Can anyone help?

    thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: code omits values during simulation

    I don't want to really understand the logic of the code.
    When stepping through the code a blank cells seams to appear when b=26.
    .
    B26.jpg

  3. #3
    Registered User
    Join Date
    03-01-2019
    Location
    Mansfield
    MS-Off Ver
    2013
    Posts
    19

    Re: code omits values during simulation

    I figured out what the issue was! thanks anyway!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need help with a sum formula that omits cells
    By jdsid in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-02-2018, 01:18 PM
  2. [SOLVED] Monte Carlo Simulation VBA Code
    By nav505 in forum Excel General
    Replies: 7
    Last Post: 03-17-2013, 01:01 PM
  3. solver macro + simulation code + not updating solver values
    By sabinemaria in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2012, 11:37 AM
  4. monte carlo simulation code for calculating value at risk
    By kmsoni in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2011, 03:08 PM
  5. Inputbox for password protection, monte carlo simulation complete code
    By karan21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2011, 07:44 PM
  6. String Function - Omits Zero
    By nivassrii in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2011, 02:43 AM
  7. [SOLVED] VBA Code for Montecarlo Simulation
    By Rafaga in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-19-2006, 07:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1