+ Reply to Thread
Results 1 to 2 of 2

I am trying to create a cache simulator with Excel VBA.

  1. #1
    Registered User
    Join Date
    04-15-2020
    Location
    US
    MS-Off Ver
    2019
    Posts
    1

    I am trying to create a cache simulator with Excel VBA.

    I am trying to create a cache simulator with Excel VBA. I will have four sheets with data like so:

    2 400170 8fa40000
    0 7ffebc64 0
    2 400174 3c1c1002
    2 400178 279ce710
    2 40017c 27a50004
    2 400180 af85abb4
    1 100192c4 0
    2 400184 24a60004
    2 400188 41080
    2 40018c af80abb8
    1 100192c8 0
    2 400190 c23021
    2 400194 27bdffe8
    2 400198 af86a470
    1 10018b80 0
    2 40019c afa00014
    1 7ffebc60 0
    2 4001a0 c1057e7
    2 4001a4 af84abb0
    1 100192c0 0
    2 415f9c 27bdff70
    2 415fa0 afb00020
    1 7ffebbdc 0
    2 415fa4 afbf0044
    1 7ffebc00 0
    2 415fa8 afa40090
    1 7ffebc4c 0
    2 415fac afbe0040
    1 7ffebbfc 0
    I want to loop through these 'addresses' with the LRU policy and output the hit/miss ratios, either adjacent to each address, or in a table on another sheet of the workbook.

    It will be a single-level cache with a 64KB size and 64KB cache block. It will also be Direct-mapped with a write-through policy, and it will be data integrated.

    The logic for the loop I'm assuming would be to process each address from the sheet (the data above), and check to see if that address is in the cache or not. Once processed, it will output the address as either hit or miss, and then give the ratio for the data set.

    Does anyone have any idea as to how my VBA structure should look (can you provide some code examples)? Is it possible to use any Excel formulas for this function? I haven't been able to find many resources online regarding cache simulation with Excel VBA.

    Thank you!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: I am trying to create a cache simulator with Excel VBA.

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

+ 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. Couldn't Create Pivot Cache in another workbook.
    By shiva_raj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2018, 05:10 AM
  2. VBA to create an Pivot table using an existing Cache
    By ola7mat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2016, 10:26 AM
  3. [SOLVED] Macro to update pivot tables and use the SAME cache instead of repeatedly recreating cache
    By Fowzee1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2015, 11:26 PM
  4. [SOLVED] VBA - PivotTable - Cannot Create Cache
    By ryanmorris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2012, 12:43 PM
  5. Macro to create common cache for groups of pivot tables
    By robhumbug in forum Excel General
    Replies: 0
    Last Post: 12-21-2010, 07:15 PM
  6. Excel flight simulator
    By Climaxgp in forum Excel General
    Replies: 2
    Last Post: 04-18-2010, 07:42 AM
  7. [SOLVED] Game in Excel - Flight simulator
    By Jasper Recto in forum Excel General
    Replies: 2
    Last Post: 04-02-2005, 06:07 PM

Tags for this Thread

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