1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. #GiveAwayFriday. Win a copy of F1 2017 - The Game. Click here to join.

Assetto Corsa iCALCS

Discussion in 'Assetto Corsa' started by fantomas76, Jun 27, 2017.

  1. fantomas76

    fantomas76

    Messages:
    11
    Ratings:
    +5
    Welcome to

    Assetto Corsa iCALCS – integrated Car Assessment, Laptime and Combo Searcher

    Click here and create your own copy. Do it once a day after 00:01 GMT to have the last laptimes updates.

    What is this?
    “iCALCS” is an integrated Car Assessment, Laptime and Combo Searcher for “Assetto Corsa” (by Kunos Simulazioni).

    Who is the author?
    It’s me, Andrea “fantomas76” Anania.

    And who are you?
    I’m the author of “Assetto Corsa Car Summary List” and “iCALCS”.

    It is based on Google Sheets, right?
    Yes, because of better sharing and usability, but I think Microsoft “Excel 2013” (on which “iCALCS” was originally born and then converted from) is much better.

    This is only your opinion. Are you a programmer?
    No, I’m not a programmer, and of course that’s my opinion.

    Is this new spreadsheet perfect?
    No, but this is only my opinion as well.

    Just in case, are you gonna make it better?
    I don’t know. But maybe you and all the simracing community could do it or help.

    Is there a place where people could post this help?
    The official forum of "iCALCS" is inside the AC official forum, so you need both Steam and AC accounts to access.

    By the way, the full name of the spreadsheet doesn’t help me to understand what it does. Explain.
    Errr… Nope.

    Uhm… Please, explain.
    Ok, now it’s good. If you know “Car Summary List”, you will notice that it’s the main part od “iCALCS” too, so we have a big bunch of informations for every car in AC and try to use them to have a better idea of what car we are gonna choose for our driving experience, or maybe to create more reasonable combos.

    So, does this make “Car Summary List” obsolete?
    Yes, you can scrap it with no future regrets, because all that it was is inside “iCALCS” now. And there is more.

    Tell us. Sorry, tell us, please.
    Open the link and immediately create your own copy by clicking the proper voice in the File menu. If you don’t create your copy, you won’t interact with anything useful into “iCALCS”. Do it and the the whole thing will get alive, but beware, you have to do it every day, because it is a little “dead” in your hands anyway since it doesn’t get new laptimes by itself. And there’s a “technical” reason for this. The UI is build through Microsoft Edge browser and optimized for a Full HD display resolution of 1920x1080 pixels at 100% zoom with default Google Sheets buttons. You should be in the “Car Assessment” sheet where you find that big bunch of informations. You can read and sort them in different ways, then you have to choose as many cars as you want to prepare a comparison. You choose a car by selecting “V” symbol in the “Select” column. A car for which you don’t select any symbol is a non-selected car just as another one with “X” symbol selected. If you first select a car and then you want to unselect, but you are not sure, you want to remind which was or exclude it temporarily, I suggest to unselect it by choosing “X”. Copy and paste “V” or “X” for multiple selection/deselection. Now, keep in mind that every car is identified by its full name, but especially and briefly by an ID number. If you wanna find a certain car in the next sheets, you need to take note of that ID and manually digit/select it.

    Mmh… I take note… Go on.
    Now, while in “Car Assessment” you know cars through technical features and general informations, in “Laptime Searcher” you can view all the world records set on every circuit by every car (if available) and compare by pure performance.

    Wait, wait, wait. World records? What are you talking about?
    All laptimes come from the renown RSR Live Timing, the most complete, reliable and commonly accepted laptime database available for AC out there.“iCALCS” retrieves the updates once every day between 23:00 and 00:00 GMT and they are available after a minute or so.

    Hold on, RSR Live Timing sucks! Those times are often slower than my personal bests and when they are faster, it means people are cheating.
    Bwoah… If you think so, go to set your best laptimes with RSR Live Timing app switched on and contribute to the cause. The more laptimes RSR will get, the more useful, reliable and precise “iCALCS” will be. Otherwise, make another live timing app and come back here.

    Bwoah…
    Hey, don’t worry, I’ve something for people like you.

    Please, continue.
    In “Combo Searcher”, look at the yellow bordered cells. You need to select one track and one car first. This is the car you maybe want to drive and potentially compare with every other one you have selected in “Car Assessment”. It’s quite a rare coincidence that two different cars has the same best lap on a certain track, but if there are you’re gonna see them. Now you can set a delta time above and below the RSR world record (use the format “mm:ss,000” and digit altogether, for example “0.00.00,500” if you mean 500 milliseconds). This is to include other cars in the comparison that are in the overall performance window you have create digiting those deltas (laptime between WR minus fastest personal delta and WR plus slowest personal delta). This also means you could suppose you are faster than the WR or slower in other laps. Of course you can insert laptime deltas based on you real experience. At this point, “iCALCS” gives the first list of possible car opponents by laptimes sorting them automatically by faster ones (red column), equal (yellow) and slower (green). You can read this as 3 different racing classes, if you like! Now, if you come back on top and set further deltas for your opponents, and so spread the overall laptime window (laptime between your personal best minus fastest opponent delta and your personal worst plus slowest opponent delta), you will extend the list of potential opponents too.

    Ok, understood, but can you explain *exactly* when opponents are classified red, yellow or green?
    We said you have a laptime window, or at least you could have set one. Yellow is everything inside this window, so between or equal to your fastest laptime and your slowest laptime. Then, red is for laptimes faster than your fastest laptime but always within or equal to the “top barrier” of opponent fastest and green is for laptimes slower than your slowest laptime but always within or equal to the “bottom barrier” of opponent slowest.

    Good, I’d rather classify faster cars with green and slower with red though…
    Really? Uhm… I don’t agree… I used the traffic lights colours meaning green as something you don’t care much about because you are faster, and red for other cars you have to pay more attention to like in multiclass races… I just said before, those 3 classes… Le Mans 24 hours, Spa 24 hours, Silv… You know… that kind of car races.

    Oh yeah, the WEC stuff… yeah yeah… I’ve heard something about… And yellow?
    Oh, yellow is for… let’s say, imminent danger of losing your position on the finish line… I like that.

    Ooookkey, move on.
    Yes. Now, without changing the numbers you already have here, you can still go back in “Car Assessment” at any time and include other cars or delete them from the comparison. Or you could go back there to re-assess all technical and general informations and choose which one you would read beside every car in the opponent list in “Combo Searcher”. Infact, you can select every single car feature and correlate, for example, the kg/bhp ratio to the laptime or see how a car with less power and maybe better traction can keep up with others with more grunt, etc.

    Uhm, good. What is(are) the source(s) of that bunch of informations?
    I use the official changelog, ingame informations and devs posting to get the "initial truth". I tried to identify the right car reproduced and report the correct name and figures through research on books and on the internet, because there are errors and inconsistencies, as well as KS rarely speaks properly about the exact cars we got. I took Wikipedia style KS car descriptions in consideration again only if they kinda speak for KS intentions in some way. Power and torque curves shown are so strange... I tried to sort things by watching into “ui_car.json” for every single car verifying numbers with official sources. Still not have the right values for some cars. Like easily understandable at this point, the "Genre (Racing Category and Homologation)" column is initially referred to the assettocorsa.net official webpage, but there are errors and inconsistencies even there (already posted), so I tried to sort them out and added some additional information. A certain kind of data is inserted only if available for all cars, so you can compare them. This is why there are no speed and acceleration figures right now and some other infos are taken from external sources to fill the empty spaces with reasonable and reliable numbers.

    Where are all the intermediate times? RSR got them for every lap completed. Oh, and I see there are not usernames to remind who has done the WR.
    I’m really sorry, but it’s impossible for me to retrieve and use intermediates in the spreadsheet. I can retrieve usernames but these were never considered since the start of the project because they are mathematically useless and require space in the interface. You can still have a look at RSR website for what's missing. I’ve placed an hyperlink in “Combo Searcher”.

    Why can’t I find any modded cars and tracks?
    They are not in it. I took in consideration only AC official PC cars and tracks, because I’m not gonna download and collect any data of any mod, neither catch all the updates and different versions that come out every week.

    Official AC cars and tracks get updates too and don’t forget even RSR includes modded cars and tracks.
    Yes but, even with all the problems with AC devs, it’s another story, definitely more reliable and followable stuff.

    I think you are overestimating yourself a bit. Do you hate modders?
    No, I admire them a lot, but I need they get hired by KS to see their works included in “iCALCS”.

    Is this why modders should hate KS?
    Bwoah… Talk with them…

    I haven’t foundy any video tutorial where people can quickly appreciate what is like to use “Hilocks”. You should do it, everybody does video tutorial these days.
    “iCALCS”. I’m currently watching some video tutorials on how to make a video tutorial.

    And what is the update frequency of “HiCall”?
    “i-C-A-L-C-S”.

    Of course, “iCALCS”.
    Possibly every time and within some days after AC for PC is majorly updated. But could also be never. And the release version of “iCALCS” is simply the same of AC, so you can easily check if you have the last one. For example, the first release is v1.14.4, just like AC has arrived until now. If a newer version of AC doesn’t have any significant update regarding “iCALCS” contents, probably there won’t be any “iCALCS” update. Oh, and it all depends on when new contents are available inside RSR Live Timing tables as well.

    I believe it’s not print friendly, isn’t it? Will it ever be?
    (crosslegging and speaking slower) Weeellll… I consider myself a sensible guy… and I take care of the environment that these days is a big concern for human kind… I always wanted to think and create stuff that contributes to harm hour planet the less possible and this time I had an idea that is a very innovative one. “Print unfriendly” stuff, as they call them, made possible a great wood waste in the past, because documents required more paper (and ink as well) to be printed. Then, “print friendly” stuff encouraged deforestation in the same way because people felt free to print everything believing that forests were already safe… That’s crazy, I mean, it’s crazily crazy… Now, due to the effect of this sequence of things, I think the best possible innovation is… to come back to print unfriendly stuff, so people will never print anymore! I think it’s a brilliant idea! In other words, “iCALCS” is not easily printable for a reason. No time was wasted to check if whatever sheet is any good out of a printer. To demonstrate I’m serious and want to save more ink and paper, just in case somebody’s gonna print this TV interview, I will answer your two last questions with a single “No” and tell you that this is good for both, no need to write or print twice.

    (long pause) …This is not a TV interview.
    Err… I know, I know… These are a series of f**k.

    ”F**k”? Maybe you mean FAQ…? Anyway, quite a long answer to save forests.
    Yep, sorry, FAQ. But I need to say that “iCALCS” doesn’t leave all users without possibilities. Infact, I actually re-apply another big idea you’ve already found in “Car Summary List”: the “My Combos” sheet.

    What was that?
    It was and it is a place where you can paste anything you want during your assessments and searches.

    Let me see… So, you simply have added a blank sheet and claim it’s a brilliant idea? Come on, you have only changed the default name…
    It is! And I tell you, I’ve found a smart name too! Nothing could ever be better than a blank space, ‘cause it gives neverending possibilities and “iCALCS” is the first spreadsheet where the clean sheet is there for a reason and not to be ignored or deleted before saving the file. Come on, confess, you’ve done it at least once in your life!

    Is at least this last sheet customizable printwise?
    Yes, the whole “iCALCS” is, but don’t write this too loudly…

    Ok, God, get outta here. Is there anything you would say to the community?
    Yes.
    1st: don’t be disappointed with RSR world records. We always need new laptimes, so don’t complain, go and set more and more world records with RSR Live Timing.
    2nd: thanks to RSR blokes that gave me the permission to use their laptimes.
    3rd: this is a work of an absolute beginner like me, so if you have any suggestion, I’m here to listen, but remember: I’m not an “Excel” neither a “Google Sheets” expert.
    4th: the data collection is a very long job, so consider to make a donation through PayPal to andrea.anania@gmail.com.
    5th: data collection for new car features or double checking them, multiplied by all the cars, could be deadly stressing for me, so I could need a serious practical help from the community. Please, contact me.
    6th: if you have chosen a combo by using my work, would you mark your hosted racing sessions with “iCALCS” name in it? It would be a very kind courtesy from you.
    7th: please make me know of any possible different use of “iCALCS” other than the one it was intended by me.
    8th: support Kunos Simulazioni and Radiator Springs Racing Team. They deserve it as well. After me.

    Last question: tell me, you use irony because you got no technical words to describe this thing, right?
    No, I use irony because “iCALCS” is nothing special.

    Goodbye.
    Goodbye.

    Car Assessment capture.jpg Laptime Searcher capture.jpg Combo Searcher capture.jpg My Combos capture.jpg
     
    Last edited: Jul 21, 2017
    • Like Like x 2
    • Love Love x 2
    • Wow Wow x 1
  2. Nico Major

    Nico Major

    Messages:
    522
    Ratings:
    +40
    Hey, thank you! You are great in every regard. I'm not sure if i can ever make use of this, but really thank you for your effort and this hilarious post!
     
  3. fantomas76

    fantomas76

    Messages:
    11
    Ratings:
    +5
    I thank you for your kind comment! If you do not use it, I hope at least I ripped you a laugh.
     
    • Like Like x 1
  4. fantomas76

    fantomas76

    Messages:
    11
    Ratings:
    +5
    Please everybody, re-download your copy from the original link in the OP and delete/overwrite what you had before. The previous is critically bugged, because it tends to be slow and doesn't complete the laptimes updates correctly.

    I've also improved the FAQ a little, but didn't change the release version though.

    Thank you very much.
     
    Last edited: Jul 17, 2017
  5. fantomas76

    fantomas76

    Messages:
    11
    Ratings:
    +5
    Hi guys, I'm proud to announce the first (and maybe only, at least for this year) "iCALCS" contest!

    Are you a graphic designer or simply you have passion and skills for designing a logo? Yes? Are you sure? Goodwood! You can take a chance to design the new "iCALCS" official logo!

    You'll be given two tasks, the first is to design the logo starting from my idea of it and the second is to develop your one, so you're gonna create two logos in one contest! Pretty convenient, isn't it?

    The only judge is me, but I promise I will compare both my left and right side brain opinions before announcing the winner.

    The contest is also launched in AssettoCorsa.net, DrivingItalia.net and SimRacingZone.net forums.


    What's the prize? The winner logo will be inserted in the spreadsheet and you will be credited for it. Furthermore, since I don't earn any money for "iCALCS", but you can make a free donation, I shouldn't pay anything either, but I'm a good guy and want to thank the winner properly. So, in case you are the winner, I will pay you a pizza (€ 15,00) by giving you some money via Paypal. All the logos will be my property from then on and only the winner will earn the prize.

    You can apply if you want to send me only one logo, but you eventually will see it in the spreadsheet, you will not be credited and you'll gonna take half the money.

    And what if I don't like the logo? Could happen. In this case there will be no logo and no credits in the spreadsheet, but I will post the winner and give him/her half the money anyway.

    If you want to take part in the contest, please send me a private message in this forum so we can start to keep in touch and I can give you the task.

    The contest will end September the 30th 2017, so you can apply and send your logos until then. The winner will be announced within October 2017

    Thank you very much and good luck!
     
    Last edited: Jul 27, 2017