KC's Power System Spreadsheet - Version 5.0 - Page 3

K.C. · Jun 11, 2004, 08:53 AM

Another new version...

I've inserted a Logo 10 sheet, updated the component data (added some AXI motors), and added a tiny feature to the spreadsheet.

KC

GGoodrum · Jun 11, 2004, 09:00 AM

I think 60 oz is a good number. For the power settings, I use 300, 415 and 850W for "standard" setups, and 350, 500 and 1000W for "HV" versions (i.e.-- 8s2p...).

nicco · Jun 11, 2004, 09:41 AM

K.C.

Is it possible to add the TANIC Li-Po cells and the new Tango 45-09 motors?

/N

K.C. · Jun 11, 2004, 10:27 AM

I removed the Tanic cells that I used to have in there because I wasn't entirely confident in the resistance and cell voltage data I had. If someone (Gary, perhaps?) can provide me with some reliable info on the Tanic cells, I'll be happy to add them.

I'll also add the Tango 45-09 if someone can provide me with its kV, Io, Rm and weight.

KC

nicco · Jun 11, 2004, 10:36 AM

Data:

Tango 45-09
920U/min/V
6-24 Zellen, max. 30000U/Min
15-50A Dauerstrom
70A kurzzeitig
300gr
Il 12V 1,1A
0,0279 Ohm

Tango 45-07
700U/min/V
6-32 Zellen, max. 30000U/Min
10-45A Dauerstrom
65A kurzzeitig
300gr
Il 12V 0,72A
0,0429 Ohm

/N

GGoodrum · Jun 11, 2004, 01:22 PM

I don't think it is possible to get reliable Tanic pack data!

-- Gary

elektromodely · Jun 15, 2004, 12:37 PM

Hi,

where can I find complete list ? There is only eolo,logo10,zoom400,R50 in this xls :-(

Miro

K.C. · Jun 15, 2004, 01:06 PM

Bug Fix & New Component Data.

I fixed a bug in the spreadsheet and added six new AXI motors to the Component Data (the 2208's and 2212's).

KC

K.C. · Jun 15, 2004, 01:11 PM

Miro - Do you mean a complete list of different helis? The four that are in there are the configurations I put together on my own. Other folks have built heli configurations as well, but I don't actually have them.

At some point, I do plan on compiling a list of all the e-helis I can find. The list would include the main gear tooth count, available pinion gears, rotor diameter, and typical empty-weight of each heli. It would be a great reference to include in the spreadsheet. In fact, if anybody has such a list - I'd love to see it.

KC

RC Man · Jun 15, 2004, 01:32 PM

KC,

I have an older version of Excel (Excel 97) and some of the functions in the Optimize sheet don’t work. The previous versions work but the ROUND function generates an error (function not defined).

Any suggestions?

K.C. · Jun 15, 2004, 02:00 PM

So ROUND doesn't exist in Excel 97? Hmmmm... Try replacing any occurrance (search and replace) of "ROUND" with "ROUNDUP" or "ROUNDDOWN". I think the ROUNDUP and ROUNDDOWN functions were there in Excel 97. If not - see if there's some other rounding function you can use. The ROUND function is only used for display purposes in the spreadsheet, so you could get rid of it entirely without affecting the functionality - some of the info would just look ugly because it'd contain numbers out to a dozen decimal points.

If the ROUND function weren't used so extensively, I could easily replace it with some more VB - but as it stands, that'd be quite a task at my level of expertise. If we can't find any other way, I may do it regardless. It'd be a shame if Excel 97 users couldn't use the niftier functions of the spreadsheet.

What optimization functions don't work in Excel 97? I may be able to work around those, as well.

Unfortunately, this is one of the fallouts of using more advanced features of Excel 2k...

KC

elektromodely · Jun 15, 2004, 02:28 PM

KC - it is exactly what I am looking for

drkite · Jun 16, 2004, 02:44 PM

I am very happy with the tool - however there is a problem with the optimisation tool. If I follow your instructions and set the constraints, set the ranges for motor and batteries - I can then run the optimisation and get results.

But as soon as I change some parameters afterwards, I always get an VB error in the following line if I click on optimize again:

Sheets("Optimization Output").Range(Delete_Range).Delete

Any advise on how to avoid this error is very welcomed.

Bernhard

flypilot · Jun 16, 2004, 08:23 PM

Hi :-)
When I try to open the spread it asks for a network connection, then it comes up with this message:
<-snip---
Microsoft Excel File Repair Log

Errors were detected in file 'Power_System_Comparison.xls'
The following is a list of repairs:

Lost Visual Basic project.
Lost ActiveX controls.
---/snip>

Any clue to what I am doing wrong?

Thanks. Great tool..

K.C. · Jun 16, 2004, 10:34 PM

Bernhard - good catch. There was an error in the VB code for the Efficiency and RPM Drop optimization routines. I've fixed the problem and updated the spreadsheet.

flypilot - that's a new one to me. I haven't encountered those errors myself. It almost sounds as though something about your installation of Excel is fundamentally incompatible with the spreadsheet. What version of Excel are you running? What version of Windows?

KC

Jun 15, 2004, 12:37 PM	#37
elektromodely Registered User Join Date: May 2004 Location: Slovak Republic Posts: 26	complete list ? Hi, where can I find complete list ? There is only eolo,logo10,zoom400,R50 in this xls :-( Miro

Jun 15, 2004, 01:32 PM	#40
RC Man A man with too many helicopter Join Date: Feb 2001 Location: Illinois Posts: 10,690	KC, I have an older version of Excel (Excel 97) and some of the functions in the Optimize sheet don’t work. The previous versions work but the ROUND function generates an error (function not defined). Any suggestions? Last edited by RC Man; Jun 15, 2004 at 01:38 PM.

Jun 15, 2004, 02:28 PM	#42
elektromodely Registered User Join Date: May 2004 Location: Slovak Republic Posts: 26	complete list KC - it is exactly what I am looking for

Jun 16, 2004, 08:23 PM	#44
flypilot 3d enjoyer Join Date: Jun 2004 Location: Eidsvoll, Norway Posts: 144	Getting a error Hi :-) When I try to open the spread it asks for a network connection, then it comes up with this message: <-snip--- Microsoft Excel File Repair Log Errors were detected in file 'Power_System_Comparison.xls' The following is a list of repairs: Lost Visual Basic project. Lost ActiveX controls. ---/snip> Any clue to what I am doing wrong? Thanks. Great tool..

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Discussion HELP! Designing power system Large C-5	PANTHERFLYR	Electric Ducted Fan Jet Talk	60	May 21, 2007 07:05 PM
KC's Power System Comparison Spreadsheet - Part 2	K.C.	Electric Heli Talk	159	Jan 20, 2007 09:02 AM
F/S Above 2kW - high power electric system Actro 40-5 complete NIB	AndersHoberg	Aircraft - Electric - Airplanes (FS/W)	5	May 11, 2005 04:44 PM
Question Openoffice and KC's Power System SpreadSheet	John_C	Electric Heli Talk	1	Jan 29, 2005 01:55 PM
F/S or F/T E3D power system	khen	Aircraft - Electric - Airplanes (FS/W)	5	Oct 04, 2002 01:24 AM

Jun 11, 2004, 08:53 AM	#31
K.C. Bending Electrons to My Whim Join Date: Sep 2001 Location: Cary, NC Posts: 795	Another new version... I've inserted a Logo 10 sheet, updated the component data (added some AXI motors), and added a tiny feature to the spreadsheet. KC

Jun 11, 2004, 09:00 AM	#32
GGoodrum www.tppacks.com Join Date: Mar 2003 Location: South Orange County, CA Posts: 5,578	I think 60 oz is a good number. For the power settings, I use 300, 415 and 850W for "standard" setups, and 350, 500 and 1000W for "HV" versions (i.e.-- 8s2p...).

Jun 11, 2004, 09:41 AM	#33
nicco Registered User Join Date: Nov 2003 Posts: 146	K.C. Is it possible to add the TANIC Li-Po cells and the new Tango 45-09 motors? /N

Jun 11, 2004, 10:27 AM	#34
K.C. Bending Electrons to My Whim Join Date: Sep 2001 Location: Cary, NC Posts: 795	I removed the Tanic cells that I used to have in there because I wasn't entirely confident in the resistance and cell voltage data I had. If someone (Gary, perhaps?) can provide me with some reliable info on the Tanic cells, I'll be happy to add them. I'll also add the Tango 45-09 if someone can provide me with its kV, Io, Rm and weight. KC

Jun 11, 2004, 10:36 AM	#35
nicco Registered User Join Date: Nov 2003 Posts: 146	Data: Tango 45-09 920U/min/V 6-24 Zellen, max. 30000U/Min 15-50A Dauerstrom 70A kurzzeitig 300gr Il 12V 1,1A 0,0279 Ohm Tango 45-07 700U/min/V 6-32 Zellen, max. 30000U/Min 10-45A Dauerstrom 65A kurzzeitig 300gr Il 12V 0,72A 0,0429 Ohm /N

Jun 11, 2004, 01:22 PM	#36
GGoodrum www.tppacks.com Join Date: Mar 2003 Location: South Orange County, CA Posts: 5,578	I don't think it is possible to get reliable Tanic pack data! -- Gary

Jun 15, 2004, 01:06 PM	#38
K.C. Bending Electrons to My Whim Join Date: Sep 2001 Location: Cary, NC Posts: 795	Bug Fix & New Component Data. I fixed a bug in the spreadsheet and added six new AXI motors to the Component Data (the 2208's and 2212's). KC

Jun 15, 2004, 01:11 PM	#39
K.C. Bending Electrons to My Whim Join Date: Sep 2001 Location: Cary, NC Posts: 795	Miro - Do you mean a complete list of different helis? The four that are in there are the configurations I put together on my own. Other folks have built heli configurations as well, but I don't actually have them. At some point, I do plan on compiling a list of all the e-helis I can find. The list would include the main gear tooth count, available pinion gears, rotor diameter, and typical empty-weight of each heli. It would be a great reference to include in the spreadsheet. In fact, if anybody has such a list - I'd love to see it. KC

Jun 15, 2004, 02:00 PM	#41
K.C. Bending Electrons to My Whim Join Date: Sep 2001 Location: Cary, NC Posts: 795	So ROUND doesn't exist in Excel 97? Hmmmm... Try replacing any occurrance (search and replace) of "ROUND" with "ROUNDUP" or "ROUNDDOWN". I think the ROUNDUP and ROUNDDOWN functions were there in Excel 97. If not - see if there's some other rounding function you can use. The ROUND function is only used for display purposes in the spreadsheet, so you could get rid of it entirely without affecting the functionality - some of the info would just look ugly because it'd contain numbers out to a dozen decimal points. If the ROUND function weren't used so extensively, I could easily replace it with some more VB - but as it stands, that'd be quite a task at my level of expertise. If we can't find any other way, I may do it regardless. It'd be a shame if Excel 97 users couldn't use the niftier functions of the spreadsheet. What optimization functions don't work in Excel 97? I may be able to work around those, as well. Unfortunately, this is one of the fallouts of using more advanced features of Excel 2k... KC

Jun 16, 2004, 02:44 PM	#43
drkite Registered User Join Date: Feb 2002 Location: Ulm/Germany Posts: 82	I am very happy with the tool - however there is a problem with the optimisation tool. If I follow your instructions and set the constraints, set the ranges for motor and batteries - I can then run the optimisation and get results. But as soon as I change some parameters afterwards, I always get an VB error in the following line if I click on optimize again: Sheets("Optimization Output").Range(Delete_Range).Delete Any advise on how to avoid this error is very welcomed. Bernhard

Jun 16, 2004, 10:34 PM	#45
K.C. Bending Electrons to My Whim Join Date: Sep 2001 Location: Cary, NC Posts: 795	Bernhard - good catch. There was an error in the VB code for the Efficiency and RPM Drop optimization routines. I've fixed the problem and updated the spreadsheet. flypilot - that's a new one to me. I haven't encountered those errors myself. It almost sounds as though something about your installation of Excel is fundamentally incompatible with the spreadsheet. What version of Excel are you running? What version of Windows? KC