Hi
I have made a battery tester, where I write on a memory card in a ecxel file
But my result is not what i expect
The read in, is now like this
kanal 1
12,31
kanal 2
12,38
kanal 1
12,31
and so
But I like it in this way.
Column A1 B1 C1 D1
Kanal 1 12,31 Kanal 2 12,38
Kanal 1 12,31 and so....
can anyone help me
Thanks Per
#include <SPI.h>
#include <SD.h>
int CS_pin = 10;
const int chipSelect = 10;
float vPow = 5.0;
float r1 = 1001000;
float r2 = 100000;
float vPow2 = 5.0;
float r3 = 1013300;
float r4 = 100000;
void setup() {
Serial.begin(9600);
// Send ANSI terminal codes
Serial.print("\x1B");
Serial.print("[2J");
Serial.print("\x1B");
Serial.println("[H");
// End ANSI terminal codes
Serial.println("--------------------");
Serial.println("DC VOLTMETER");
Serial.print("Maximum Voltage: ");
Serial.print((int)(vPow / (r2 / (r1 + r2))));
Serial.print((int)(vPow2 / (r4 / (r3 + r4))));
Serial.println("V");
Serial.println("V3");
Serial.println("--------------------");
Serial.println("v2");
Serial.println("v4");
Serial.print("Initializing SD card...");
pinMode(CS_pin, OUTPUT);
if (!SD.begin(CS_pin))
{
Serial.println("Card failed, or not present");
// don't do anything more:
return;
}
Serial.println("card Ready.");
}
void loop()
{
int sensorValue = analogRead(A0);
int sensorValue2 = analogRead(A2);
float v = sensorValue * (vPow / 1024.0);
float v2 = v / (r2 / (r1 + r2));
float v3 = sensorValue2 * (vPow / 1024.0);
float v4 = (v3 / (r4 / (r3 + r4)))-v2;
// Send ANSI terminal codes
//Serial.print("\x1B");
// Serial.print("[1A");
// End ANSI terminal codes
File dataFile = SD.open("datalog.csv", FILE_WRITE);
String dataString = String(v2);
String dataString2 = String(v4);
if (dataFile)
{
dataFile.println("K 1");
dataFile.println(dataString);
dataFile.println("K 2");
dataFile.println(dataString2);
dataFile.println("\t");
dataFile.close();
Serial.println(dataString);
Serial.println("K 1");
Serial.println(dataString2);
Serial.println("K 2");
Serial.println("\t");
}
else {
Serial.println("error opening datalog.txt");
}
delay(1500);
// skriver en gang pr min
}