Multiple identical dimension values
MasterRavelToEmulatePivotTableFilterFunctionality20240905A.mp4 https://drive.google.com/file/d/1lH3G5ac9t2Zh-b-zVTjMaF2Jog0-QMfW/view?usp=drive_web Yes, that seems to nail it. Here's a video of me using the slices feature on that Excel file anyway. Pardon the excess commentary!
Sure. I'll use it and take a video. The point is that the filters on an Excel Tab, with plots derived from a set of independent Pivot Tables, affects all of the plots. We can't (yet) do that, because Ravels are currently related just to the slice already taken from the source data. Best, Steve Professor Steve Keen Want to rebuild economics? Support me on Patreon: https://www.patreon.com/ProfSteveKeen https://www.patreon.com/ProfSteveKeen My latest book, The New Economics, is now available from Polity:...
Here's the movie. ResizingHassleAgain20240830.mp4 https://drive.google.com/file/d/1RyW5VCyILVm1JOq2BSzGEdkSgpspzrOy/view?usp=drive_web
Unfortunately not! I'm using Minsky 3.8.0-alpha.3 Minsky GUI 3.8.0-alpha.3 Ravel 1.3.1: Expires in 72 days Angular 17.3.7 And I just triggered it again. MP4 too big to attach directly; coming in the next post.
Having gotten rid of them to continue editing the file, a control-Z restored them
MKY file--created two days ago, using this alpha.
This is with Minsky 3.6.0-alpha.1 Minsky GUI 3.6.0-alpha.1 Ravel 1.3.1: Expires in 73 days Angular 17.3.7
Posted before the MP4 had been fully created. Check this one instead.
At least I found a minor bug! When you resize an edit mode Godley on a publication tab, it resizes from the middle or thereabouts of the Table, rather than from its other edge.
My bad! I didn't try the right-click menu to toggle to Editor mode. My apologies Maestro!
Renew Godley Table Tab
Forecast widget
Master Ravel for a Publication Tab?
User-extensible widget bar
We need day of the week too, in abbreviated and full name format, both as data import format options to time, and as display options on the canvas.
Abbreviated Month Name Import Dropdown Option needed
Finally got the intended result. I hope I've uncovered something buggy in the code in the process. The exercise has emphasised the desirability of a running sum and a running average operator. In terms if icons, maybe indicate them with arrows <--> above the current cumulative sum and average operators?
I just re-triggered it by resizing windows.
Replace the old running sum operator with the new one and everything is fine.
Here's another comparison. The original operator doesn't work, with the same settings on which the new one does.
Strange! I added a new running sum, and it worked with that. But it's still not working with the older one.
I did that. See image and RVL file.
What I now have is: Minsky 3.8.0-alpha.3 Minsky GUI 3.8.0-alpha.3 Ravel 1.3.1: Expires in 80 days Angular 17.3.7It seems not to have that bug now though.
3.7.1. I'll try upgrading now. On Thu, Aug 22, 2024 at 8:53 AM High Performance Coder hpcoder@users.sourceforge.net wrote: Are you guys using the latest version? (3.7.4). I think this one is probably fixed. [ravel:#631] https://sourceforge.net/p/minsky/ravel/631/ Integer called on real value Status: open Milestone: Babbage Created: Wed Aug 21, 2024 01:48 PM UTC by Steve Keen Last Updated: Thu Aug 22, 2024 05:59 AM UTC Owner: nobody Attachments: JoernDemo20240821.rvl https://sourceforge.net/p/minsky/ravel/631/attachment/JoernDemo20240821.rvl...
The successful workaround file.
Moving average operator
I managed to trigger this bug myself by resizing Ravel's window, so--as I expect you've already worked out--it's a scaling bug issue again. One of these videos also illustrates another bug: an error message for a difference operator that persists even though the error (not specifying an axis) has been addressed. I'm leaving this in this ticket because there's a chance these bugs are related.
Here's the recording of our Zoom session. I got him to open, try to import, shut down, reinstall, and the same error applies. After the initial error message on loading Ravel, nothing works: not even typing a divide by key, let alone inserting a data import parameter. He's a good friend, so I can link you two for you to suss out what's happening. It must be specific to his PC (Windows) but this is a problem we don't want anyone to experience. video1715194963.mp4 https://drive.google.com/file/d/1_gY35hjK-x5DY0WITP40FCRnZ38IBr7b/view?usp=drive_web...
Integer called on real value
CSV files
Sort order not working
CSV files.
This one generates a strange effect--another 16-bit problem?
Crash on Loading Horizontal Data
Movies of crashes CrashOnFileImport20240818A.mp4 https://drive.google.com/file/d/1WcJMo_R4ntjVn7CKRwpJrP117NPaY1Hx/view?usp=drive_web CrashOnFileImport20240818B.mp4 https://drive.google.com/file/d/1HBVbIryvIZzwt0Sc7NOy6XpS5Newlr6c/view?usp=drive_web
Data files.
Crash on Loading Horizontal Data
Ah! What I actually did was define GDP as a parameter, and then put it into a Ravel using the merge operator, then--here's the error--attach it to a variable that I also called GDP. Ravel caught the error, so I then renamed the variable GDP_{Nom}. Thanks. I'll go back and redo that file. Best, Steve Professor Steve Keen Want to rebuild economics? Support me on Patreon: https://www.patreon.com/ProfSteveKeen https://www.patreon.com/ProfSteveKeen My latest book, The New Economics, is now available from...
CSV files.
Divide Operator Glitch
The merge operator seems to be scrambling data somehow. A division of one parameter by another returns the expected result. A division of one variable by another, both derived from a merged Ravel, does not.
Merge Operator glitch
I'm only getting Ravel 1.3.0 when I choose Upgrade.
Let's go for the parameter edit then. Can you bump it up to 10? An option can come later, as you say. I'm starting social media posts tomorrow BTW. And I might contact a friend who runs a game marketing company as well.
Yeah, but now with the improvements we made to axis labelling and such in the last year, six is no longer the maximum. I'd say it's about ten. Can that parameter value be changed in the code? At some point, we could make it a user-option, but in trying to show off Ravel in social media posts, the faded display is more of a hindrance than a help. Best, Steve Professor Steve Keen Want to rebuild economics? Support me on Patreon: https://www.patreon.com/ProfSteveKeen https://www.patreon.com/ProfSteveKeen...
Good. Even a minimum size warning would help, since 2^64 is a much bigger number than most people appreciate. Something that gave users an indication of potential data cube size? Maybe a box like this: Dimensions: Max number: 21 (this is the initial size of the BIS database) Est. minimum for unique key: (user entered--7 for the BIS) Max values per dimension: 350 (that's roughly the number of quarters) Min values per dimension: 2 (Adjusted or unadjusted for breaks) Estimated data cube size (calculated...
OK, but I have to sheepishly say... that I think my idea of a "greyed out" Ravel when there are more than six dimensions was a mistake--or rather a relic of when the angles of the axis labels and the text clashed with each other. This is now an annoyance when I load the BIS debt data for a video, since it come in as seven dimensions. I have to reduce by at least one dimension before what a Ravel looks like is obvious in a recording. Could this effect be bumped up to say ten dimensions, as a temporary...
OK, but we do need to warn users of when they are likely to breach "curse of dimensionality" limits. Could you include a calculation field showing the data requirements of current selections? This could be used to advise users to reduce dimensionality on importing by choosing to ignore sufficient columns while still generating a unique key.
Also some peculiarities in the associated sheet.
CSV file
Negative which should be positive
Analyse and Load Button
Import form reversion
Will do. Best, Steve Professor Steve Keen Want to rebuild economics? Support me on Patreon: https://www.patreon.com/ProfSteveKeen https://www.patreon.com/ProfSteveKeen My latest book, The New Economics, is now available from Polity: http://politybooks.com/bookdetail/?isbn=9781509545285 @ProfSteveKeen Mobile +66 (0) 99-257-2692 Honorary Professor, UCL &ISRS Distinguished Research Fellow www.profstevekeen.com On Wed, 7 Aug 2024 at 08:00, High Performance Coder hpcoder@users.sourceforge.net wrote: Seems...
Source data.
Bad Alloc again
This is one worth bumping up in the priority list. Here's another example
Using index and gather
I didn’t enter a value though. That must be the consequence of attempting to move the legend using the mouse. I think we could insist the scaling is always positive, unless we sell a copy to Leonardo da Vinci. Best, Steve Professor Steve Keen Want to rebuild economics? Support me on Patreon: https://www.patreon.com/ProfSteveKeen https://www.patreon.com/ProfSteveKeen My latest book, The New Economics, is now available from Polity: http://politybooks.com/bookdetail/?isbn=9781509545285 @ProfSteveKeen...
Upside-Down Plot Label
Also notice that the Year axis on the first Ravel is light while for the second it is the correct intensity.
Massaged CSV files.
Axes Wrongly Labelled
Import routine loading pre-header rows
Yes, but what happens if we have two time series then, one with something that fits the ISO standard and one Quarterly? Will they be treated consistently, or will one bugger up the other? Pardon my mood! My expensive USB microphone has just failed one day before the bloody YouTube Pitch. I'm now going to go back in time and kill Murphy.
Invisible Wires
I think I've worked out what's going wrong. When you don't specify the date format, the program seems to treat the Quarter numbers as months. So what you get is data for January, February, March, April, and then the next January-April. Instead what you should have is data for January, April, July, October, then the next January, April, July, October. Of course what different countries choose as months for quarters is probably also arbitrary! But in this case I think it would be best to use the American...
Fair enough--but that raises the question of whether dates should be automatically sorted in Date order. Anyway, I was concerned that I might have found a boundary condition bug. This is something for the backlog I think--ensuring that date data is always in date order, regardless of how it was stored in the source CSV file. Best, Steve Professor Steve Keen Want to rebuild economics? Support me on Patreon: https://www.patreon.com/ProfSteveKeen https://www.patreon.com/ProfSteveKeen My latest book,...
The Date dimension was a time dimension in both versions; in one I didn't specify the format, in the other I did. The first one had klunky plots--I think because only the year was being plotted, or each quarter in a year was stacked vertically--while the latter had smooth plots. The basic point is that I think we should aim to make specifying the date format unnecessary, unless there's a need to clarify when a US MDY format is used and it can't be distinguished from DMY formatted dates. In that case...
RVL and data files
Plot formatting without date formatting
Changing the difference operator to -1 for years worked, while the operator for quarterly data is correct with the operator being +4.
Data files
Difference operator error
CSV file--too big for SourceForge. Unemployment_{Rate}^{ILO}.csv https://drive.google.com/file/d/1OjV0MPmIEY2C-mM8dS32p3JmRYnuJSmQ/view?usp=drive_web Best, Steve Professor Steve Keen Want to rebuild economics? Support me on Patreon: https://www.patreon.com/ProfSteveKeen https://www.patreon.com/ProfSteveKeen My latest book, The New Economics, is now available from Polity: http://politybooks.com/bookdetail/?isbn=9781509545285 @ProfSteveKeen Mobile +66 (0) 99-257-2692 Honorary Professor, UCL &ISRS Distinguished...
PS This was using 3.6 Alpha
Cyclic plot on first import
Plot has wrong labels
This is the post about using Python to analyze the data: https://medium.com/@ifewada/exploring-movie-revenue-correlations-with-exploratory-data-analysis-in-python-4b586cb2fba6
Dimensionality Error
Bad Alloc again
I couldn't save the file.
Second JPG. I wasn't able to save the file.
Bad Alloc again
Missing Data on Import
Parameter value bleed
Just what we need at the moment: it appears to be a Heisenbug! The file loaded fine on the next attempt.
The offending process seems to be getting 0% of processor time.
I can't shut the program down. I think we need a "cancel" button on the resetting window.
Data files.
RVL file
Cannot read properties error
I thought it might--in which case, forget the "get me a beta ASAP" in my previous email: this needs to work as well for my intended example file. July 1 is looking like a good choice for the release.
My gawd, you're human after all! 😉. That sounds like one of my mistakes! Good that we've caught this one now, anyway. Can you get a new beta to me ASAP? I want to use this dataset as an indication of getting insights rapidly from Ravel on the Patreon site.
RVL and CSV
Here's another example. I aggregated data by sorting and deleting in Excel, so the CSV has the actual numbers that can be compared to what Ravel is pumping out. There are obvious cases of numbers being scambled.
I think the redesign of the output from sheets may be the culprit here. The time trend for China in this sheet is the opposite of the data, but the column output for the year 1997 seems to grow as you'd expect China's patents to rise over time.
CSV file.
Column Tail Not Working