VS-VY Enhanced Factory Bins

For discussion and distribution of custom code and hacks
slewinson
Posts: 224
Joined: Wed Oct 08, 2014 11:08 am
cars: Barina SB C14SE
Lexus RX350
VW Golf Mk5 TDI DSG

Re: The1's Enhanced Factory Bins

Post by slewinson »

All good. Consider it a late Xmas Present.

Simon
0081
Posts: 186
Joined: Fri Jul 09, 2010 10:01 pm
cars: VY s L67
Haines Hunter - not a car but still a toy

Re: The1's Enhanced Factory Bins

Post by 0081 »

The1 wrote:that's correct but i can't see any calculations, youve done it manually?
I copied the data in the 250 and 500 cells down and used the fill function to fill the empty cells between them.

Then highlighted all data in the cells 250 to 500 and clicked the little box at the bottom right corner of the highlighted section and dragged it across to populate the remaining cells. I'm sure there is a name for that just know how to do it not whats its called.

Not too sure if its the best way to go about it but the numbers look close to where it needs to be
User avatar
The1
Posts: 4694
Joined: Mon Jan 04, 2010 10:23 am

Re: The1's Enhanced Factory Bins

Post by The1 »

yeh i needed it to be automatic, so people would be able to paste in there data and copy the new data out.
slewinson
Posts: 224
Joined: Wed Oct 08, 2014 11:08 am
cars: Barina SB C14SE
Lexus RX350
VW Golf Mk5 TDI DSG

Re: The1's Enhanced Factory Bins

Post by slewinson »

I can tweak the sheet to add in extrapolation at the edges of the table if you like. L me know as it would be a ten minute job.

Simon
User avatar
hsv08
Posts: 547
Joined: Thu May 09, 2013 6:50 pm
cars: (EX) VT SENATOR 355 STROKER
(EX) VT SS 304 MANUAL
NOW VX V6 HACK

Re: The1's Enhanced Factory Bins

Post by hsv08 »

attached is a spreadsheet that converts and expolates figures between the old scale and new scale.
Any number you add to the red values will update what it will be in the new table.
Is this how you wanted it?
Attachments
table conversion hsv08.xlsx
(14.57 KiB) Downloaded 331 times
User avatar
The1
Posts: 4694
Joined: Mon Jan 04, 2010 10:23 am

Re: The1's Enhanced Factory Bins

Post by The1 »

what slewinson did above is what i was after.
slewinson
Posts: 224
Joined: Wed Oct 08, 2014 11:08 am
cars: Barina SB C14SE
Lexus RX350
VW Golf Mk5 TDI DSG

Re: The1's Enhanced Factory Bins

Post by slewinson »

The1 wrote:what slewinson did above is what i was after.
Been thinking more about it and I feel that you could get much better results by doing a polynomial curve fit for each row and then using the resultant formula to populate the lower table. That would potentially give a smoother end result than the stepwise linear interpolation.

Might give it a go when I have a spare half hour or so.

Simon.
User avatar
The1
Posts: 4694
Joined: Mon Jan 04, 2010 10:23 am

Re: The1's Enhanced Factory Bins

Post by The1 »

sweet :thumbup:
slewinson
Posts: 224
Joined: Wed Oct 08, 2014 11:08 am
cars: Barina SB C14SE
Lexus RX350
VW Golf Mk5 TDI DSG

Re: The1's Enhanced Factory Bins

Post by slewinson »

Here they are... Took a bit more "massaging" of the lookup formulas then I anticipated :wall: :comp:

There are also graphs to show the data on a second tab in the sheet. I used third and fifth order polynomials to get lines of best fit for each row and then extrapolated this into a new table (top right of the four). This is then re-ranged (bottom right) and then used to backfill the blank areas on the original linearly interpolated table (bottom left).

There are some discontinuities but it goves you an idea of what might happen. in this example there is a step that needs to be adjusted at higher flows above 550 ish. Ther are also some -ve numbers that need to be manually culled.

Have a play. :punk:
Simon
User avatar
The1
Posts: 4694
Joined: Mon Jan 04, 2010 10:23 am

Re: The1's Enhanced Factory Bins

Post by The1 »

uploaded new zip files, just tweaks and fix's here and there on xdf/adx's
Post Reply