# Master spreadsheet with T1, T2, T3, & T4 settings **URL:** \ **Category:** GEM Forum\ **Created:** [July 25, 2019, 7:20pm UTC](https://community.electricforum.com/t/master-spreadsheet-with-t1-t2-t3-t4-settings/16693 "2019-07-25T19:20:49Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![diymatt](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.electricforum.com/diymatt/32/1822_2.png) [@diymatt](https://community.electricforum.com/u/diymatt)\ **Post date:** [July 25, 2019, 7:20pm UTC](https://community.electricforum.com/t/master-spreadsheet-with-t1-t2-t3-t4-settings/16693/1 "2019-07-25T19:20:50Z")
I’ve always envisioned how nice it would be if there was a big ole spreadsheet with tabs for each controller type showing the settings and what they do in layman’s speak. With everybody doing so many different things such as bigger or smaller wheels, standard and high voltage and other modifications I know this would be hard to make universal. I’m thinking we do a Version1 with just the stock values for all the controllers and then a few tabs with R4F settings or known vanilla values that are better than stock. Then once we start getting some data in there we can add pivot tables and entry fields so a person could (in theory) put in their information into a few fields and it would spit out a suggestion. Thoughts? Here is a very basic early version. Feel free to contribute. We can certainly lock it up, but for now I have it open for anybody with the link to edit just to get the party started. > **[GEM controller settings](https://docs.google.com/spreadsheets/d/1twGA7EIkPMfoofeXfKDYk8TwGo2f5kMpkvGuVtE3vcU/edit?usp=sharing)** > > T1 Controller > > Function Number,Description,Counts,Minimum,Maximum,Notes > 1,MPH Scaling > 2,Creep Speed > 3,Controlled Acceleration > 4,Current Limit > 5,Plugging Current > 6,Controlled Acceleration in Spe > 7,Minimum Field Current > 8,Maximum Field Current > 9,Regen... ---
**Author:** ![JarJarJava](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.electricforum.com/jarjarjava/32/15158_2.png) [@JarJarJava](https://community.electricforum.com/u/JarJarJava)\ **Post date:** [July 25, 2019, 8:17pm UTC](https://community.electricforum.com/t/master-spreadsheet-with-t1-t2-t3-t4-settings/16693/2 "2019-07-25T20:17:15Z")
Right on. Was just thinking about this earlier today actually while I was transcribing some settings from my controller over to a spreadsheet. ---
**Author:** ![diymatt](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.electricforum.com/diymatt/32/1822_2.png) [@diymatt](https://community.electricforum.com/u/diymatt)\ **Post date:** [July 25, 2019, 8:19pm UTC](https://community.electricforum.com/t/master-spreadsheet-with-t1-t2-t3-t4-settings/16693/3 "2019-07-25T20:19:36Z")
I’ve found it totally impossible to do a search on the forum and get anything definitive. All the data is so fractured over time and posts it’s hard to cohesively put anything together. ---
**Author:** ![JarJarJava](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.electricforum.com/jarjarjava/32/15158_2.png) [@JarJarJava](https://community.electricforum.com/u/JarJarJava)\ **Post date:** [July 25, 2019, 8:26pm UTC](https://community.electricforum.com/t/master-spreadsheet-with-t1-t2-t3-t4-settings/16693/4 "2019-07-25T20:26:22Z")
Funny. Had similar thoughts this morning also when I was looking for some settings. ---
**Author:** ![Tyson\_Davis](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.electricforum.com/tyson_davis/32/719_2.png) [@Tyson\_Davis](https://community.electricforum.com/u/Tyson_Davis)\ **Post date:** [August 15, 2019, 3:51pm UTC](https://community.electricforum.com/t/master-spreadsheet-with-t1-t2-t3-t4-settings/16693/5 "2019-08-15T15:51:57Z")
Thanks so much, I have been trying to get my Cart to Regain or Plug and by looking at this it gives me ideas. I have a T1 and I know the T2 settings are similar. I will put my custom codes on here as well here soon ---
**Author:** ![Ljtoro](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.electricforum.com/ljtoro/32/5120_2.png) [@Ljtoro](https://community.electricforum.com/u/Ljtoro)\ **Post date:** [August 26, 2019, 3:24pm UTC](https://community.electricforum.com/t/master-spreadsheet-with-t1-t2-t3-t4-settings/16693/6 "2019-08-26T15:24:09Z")
This is exactly what I was looking for Thank you ---
**Author:** ![JarJarJava](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.electricforum.com/jarjarjava/32/15158_2.png) [@JarJarJava](https://community.electricforum.com/u/JarJarJava)\ **Post date:** [November 11, 2019, 3:36pm UTC](https://community.electricforum.com/t/master-spreadsheet-with-t1-t2-t3-t4-settings/16693/7 "2019-11-11T15:36:29Z")
Finally remembered to add a sheet for how my spare controller came back from R4F. Looks like all they did was lower #7 (min field current) and increase #20 (overspeed). I found this to be too jerky on the acceleration and too much lag when accelerating from a dead stop. Tinkering with smoothing that out and maybe make the motor a bit happier when it’s running at 1k rpm above rated top speed. ---
**Author:** ![frankjr](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.electricforum.com/frankjr/32/5605_2.png) [@frankjr](https://community.electricforum.com/u/frankjr)\ **Post date:** [December 22, 2019, 6:25am UTC](https://community.electricforum.com/t/master-spreadsheet-with-t1-t2-t3-t4-settings/16693/8 "2019-12-22T06:25:08Z")
I added the stock settings from my 2015 E2 (T5 Controller) to the sheet. ---
**Author:** ![frankjr](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.electricforum.com/frankjr/32/5605_2.png) [@frankjr](https://community.electricforum.com/u/frankjr)\ **Post date:** [December 23, 2019, 5:14pm UTC](https://community.electricforum.com/t/master-spreadsheet-with-t1-t2-t3-t4-settings/16693/9 "2019-12-23T17:14:34Z")
I also added a tab for RPM / MPH calculator based on Tire size and Gear Ratio. Here is the math for how the calculator works in case anyone is interested, or I’ve made a mistake: ![IMG_1418-Web](https://canada1.discourse-cdn.com/flex030/uploads/electricforum/original/2X/9/9c62bf3c90209be8257298a67d39d44b832228e0.jpeg) ---
**Author:** ![frankjr](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.electricforum.com/frankjr/32/5605_2.png) [@frankjr](https://community.electricforum.com/u/frankjr)\ **Post date:** [December 23, 2019, 5:36pm UTC](https://community.electricforum.com/t/master-spreadsheet-with-t1-t2-t3-t4-settings/16693/10 "2019-12-23T17:36:32Z")
Also, based on the derived formula above, I’ve come up with another tab (calculator) that will calculate the controller settings (#13-Rolling Radius & #16-Gear Ratio) for displaying 0-40mph in KPH mode. No magic there, basically we need the Rr/Gr ratio to be divided by the MPH to KPH conversion factor (1.60934). Once I’ve had a chance to validate my belief, I will add the calculator to the spreadsheet. I’ve read from others that a wrench will come up if #13 is too small or #16 is too big. I’m wondering if that is specific to a certain controller and software revision. TL;DR; - dividing your legitimate Func#13 value by 1.60934, or multiplying your legit Func#16 value by 1.60934 should be mathematically correct to solve, but I don’t know if those values are out of range for the software until I get a chance to tinker with my GEM. ---
**Author:** ![LithiumGods](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.electricforum.com/lithiumgods/32/672_2.png) [@LithiumGods](https://community.electricforum.com/u/LithiumGods)\ **Post date:** [December 24, 2019, 8:24am UTC](https://community.electricforum.com/t/master-spreadsheet-with-t1-t2-t3-t4-settings/16693/11 "2019-12-24T08:24:32Z")
#13 & #16 are related . There are limits you can set #13 to depending on what #16 is . If you get out of the range it will throw a 14 code . ( I have only tested T4 & T5’s ) With a 12.44 differential and stock wheels you can’t get RR low enough for mph to be accurate in the kph setting . On a T5 with stock wheels you can get close or a T4 with the higher speed 10.35 Diff.