Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help please
Hello,
I have a program that takes a daily reading and subtracts the previous days number to get an daily total. Anyway, I can figure out how to do the numbers from January 1 thru December 31 within the same worksheet, but my question is how do I take the January 1st reading from 2007 and subtract December 31st from 2006? I would like to make 2007 on a seperate worksheet. How can I do that? Month January Year 2006 x100 x100 Reading Total GPD 39858 1525 41597 1739 42999 1402 44403 1404 45796 1393 47114 1318 48670 1556 50317 1647 51834 1517 53366 1532 54972 1606 56481 1509 57614 1133 59392 1778 60923 1531 62480 1557 63998 1518 65536 1538 67035 1499 68521 1486 69983 1462 71641 1658 73130 1489 74680 1550 76096 1416 77573 1477 78958 1385 80344 1386 81844 1500 83056 1212 84845 1789 Month February Year 2006 x100 x100 Reading Total GPD 86042 1197 87400 1358 88806 1406 90213 1407 91710 1497 93208 1498 94618 1410 96099 1481 97569 1470 98707 1138 100149 1442 101716 1567 103121 1405 104628 1507 106114 1486 107409 1295 108680 1271 110063 1383 111506 1443 113128 1622 114567 1439 116013 1446 117450 1437 118798 1348 120188 1390 121635 1447 123111 1476 124339 1228 Month March Year 2006 x100 x100 Reading Total GPD 125698 1359 127034 1336 128367 1333 129657 1290 131056 1399 132439 1383 133619 1180 134765 1146 136072 1307 137345 1273 138652 1307 139979 1327 141348 1369 142666 1318 144017 1351 145316 1299 146631 1315 148035 1404 149415 1380 150895 1480 152286 1391 153707 1421 155709 2002 156632 923 158062 1430 159462 1400 161011 1549 162216 1205 163456 1240 164893 1437 166218 1325 Month April Year 2006 x100 x100 Reading Total GPD 167540 1322 168963 1423 170308 1345 171542 1234 172841 1299 174297 1456 175672 1375 177111 1439 178587 1476 179807 1220 181186 1379 182466 1280 183708 1242 184958 1250 560 1244 1808 1248 3039 1231 4100 1061 5317 1217 6589 1272 7729 1140 8975 1246 10333 1358 11661 1328 12966 1305 945 1300 2244 1299 3560 1316 4927 1367 6330 1403 Month May Year 2006 x100 x100 Reading Total GPD 7670 1340 9298 1628 10614 1316 11965 1351 13326 1361 14546 1220 15937 1391 17293 1356 18655 1362 20009 1354 21297 1288 22528 1231 23861 1333 25212 1351 26574 1362 27918 1344 29226 1308 30639 1413 32034 1395 33540 1506 35053 1513 36565 1512 993 1485 2417 1424 3891 1474 5390 1499 6820 1430 8275 1455 9870 1595 11414 1544 13053 1639 Month June Year 2006 x100 x100 Reading Total GPD 14482 1429 15872 1390 17189 1317 18524 1335 19986 1462 21442 1456 22864 1422 24296 1432 25593 1297 26960 1367 28460 1500 30128 1668 31491 1363 32766 1275 34274 1508 35868 1594 37301 1433 38602 1301 40086 1484 41504 1418 42879 1375 44309 1430 45473 1164 47012 1539 48430 1418 49933 1503 51333 1400 52688 1355 54061 1373 55444 1383 Month July Year 2006 x100 x100 Reading Total GPD 56898 1454 58330 1432 59757 1427 61145 1388 62577 1432 63808 1231 65239 1431 66732 1493 68158 1426 69730 1572 71302 1572 72921 1619 74480 1559 2314 1506 3804 1490 5329 1525 6900 1571 8584 1684 10106 1522 11553 1447 13226 1673 14791 1565 16360 1569 17940 1580 19398 1458 20900 1502 22492 1592 24139 1647 1451 1547 3040 1589 4672 1632 Month August Year 2006 x100 x100 Reading Total GPD 6267 1595 7921 1654 9454 1533 10951 1497 12420 1469 13916 1496 15538 1622 17095 1557 18603 1508 20111 1508 21992 1881 23777 1785 25314 1537 26873 1559 28387 1514 30644 2257 1262 1638 2820 1558 4406 1586 6024 1618 7590 1566 9219 1629 10827 1608 12248 1421 13741 1493 15263 1522 16867 1604 18603 1736 20042 1439 21674 1632 23377 1703 Month September Year 2006 x100 x100 Reading Total GPD 25005 1628 26677 1672 28110 1433 29670 1560 31060 1390 32597 1537 33886 1289 35260 1374 36898 1638 38350 1452 39818 1468 41239 1421 42573 1334 44000 1427 45362 1362 46782 1420 48286 1504 49714 1428 51193 1479 52573 1380 53942 1369 55296 1354 56752 1456 58274 1522 59667 1393 61009 1342 62341 1332 63695 1354 64944 1249 66387 1443 Month October Year 2006 x100 x100 Reading Total GPD 67762 1375 69185 1423 70541 1356 71921 1380 73082 1161 74461 1379 75844 1383 77289 1445 78752 1463 80199 1447 81731 1532 83212 1481 84505 1293 85937 1432 87295 1358 88804 1509 90182 1378 91694 1512 93124 1430 94420 1296 95803 1383 97248 1445 98730 1482 100225 1495 101628 1403 103129 1501 104512 1383 105977 1465 107456 1479 108963 1507 110441 1478 Month November Year 2006 x100 x100 Reading Total GPD 111803 1362 113207 1404 114545 1338 116104 1559 926 1423 2364 1438 3884 1520 5334 1450 6688 1354 8099 1411 9537 1438 11074 1537 12559 1485 14086 1527 15585 1499 17004 1419 18365 1361 19691 1326 21169 1478 22511 1342 23802 1291 25246 1444 26663 1417 28141 1478 29274 1133 31184 1910 32736 1552 34172 1436 35600 1428 36976 1376 Month December Year 2006 x100 x100 Reading Total GPD 38208 1232 39753 1545 41265 1512 42822 1557 44303 1481 45788 1485 47168 1380 48610 1442 50088 1478 51554 1466 53006 1452 54270 1264 55891 1621 57189 1298 58789 1600 60098 1309 61554 1456 62722 1168 58 1224 thank you in advance for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help please
On the 2007 sheet you have two options, either start out by simply typing in
the value from Dec 31, 2006 and then continuing on from there much as you have already done for 2006. OR go to the place on the 2007 sheet where you want that value from Dec 31, 2006 to be placed and type in a formula similar to this (sheet name and actual cell will vary based on your sheet name/layout) ='2006 Sheet'!A370 Where 2006 Sheet is the name of the sheet with your 2006 data. I put A370 there vs A365 since you appear to have some headers and such that would put the Dec 31 entry further down the sheet than row 365. There is little immediate advantage to doing it one way or the other EXCEPT that if you do it the second way, if for some reason you ever have to go back to the 2006 sheet and change any entries, then the updated value would show up at the beginning of the 2007 sheet, keeping things current and up to date. "p-nut" wrote: Hello, I have a program that takes a daily reading and subtracts the previous days number to get an daily total. Anyway, I can figure out how to do the numbers from January 1 thru December 31 within the same worksheet, but my question is how do I take the January 1st reading from 2007 and subtract December 31st from 2006? I would like to make 2007 on a seperate worksheet. How can I do that? Month January Year 2006 x100 x100 Reading Total GPD 39858 1525 41597 1739 42999 1402 44403 1404 45796 1393 47114 1318 48670 1556 50317 1647 51834 1517 53366 1532 54972 1606 56481 1509 57614 1133 59392 1778 60923 1531 62480 1557 63998 1518 65536 1538 67035 1499 68521 1486 69983 1462 71641 1658 73130 1489 74680 1550 76096 1416 77573 1477 78958 1385 80344 1386 81844 1500 83056 1212 84845 1789 Month February Year 2006 x100 x100 Reading Total GPD 86042 1197 87400 1358 88806 1406 90213 1407 91710 1497 93208 1498 94618 1410 96099 1481 97569 1470 98707 1138 100149 1442 101716 1567 103121 1405 104628 1507 106114 1486 107409 1295 108680 1271 110063 1383 111506 1443 113128 1622 114567 1439 116013 1446 117450 1437 118798 1348 120188 1390 121635 1447 123111 1476 124339 1228 Month March Year 2006 x100 x100 Reading Total GPD 125698 1359 127034 1336 128367 1333 129657 1290 131056 1399 132439 1383 133619 1180 134765 1146 136072 1307 137345 1273 138652 1307 139979 1327 141348 1369 142666 1318 144017 1351 145316 1299 146631 1315 148035 1404 149415 1380 150895 1480 152286 1391 153707 1421 155709 2002 156632 923 158062 1430 159462 1400 161011 1549 162216 1205 163456 1240 164893 1437 166218 1325 Month April Year 2006 x100 x100 Reading Total GPD 167540 1322 168963 1423 170308 1345 171542 1234 172841 1299 174297 1456 175672 1375 177111 1439 178587 1476 179807 1220 181186 1379 182466 1280 183708 1242 184958 1250 560 1244 1808 1248 3039 1231 4100 1061 5317 1217 6589 1272 7729 1140 8975 1246 10333 1358 11661 1328 12966 1305 945 1300 2244 1299 3560 1316 4927 1367 6330 1403 Month May Year 2006 x100 x100 Reading Total GPD 7670 1340 9298 1628 10614 1316 11965 1351 13326 1361 14546 1220 15937 1391 17293 1356 18655 1362 20009 1354 21297 1288 22528 1231 23861 1333 25212 1351 26574 1362 27918 1344 29226 1308 30639 1413 32034 1395 33540 1506 35053 1513 36565 1512 993 1485 2417 1424 3891 1474 5390 1499 6820 1430 8275 1455 9870 1595 11414 1544 13053 1639 Month June Year 2006 x100 x100 Reading Total GPD 14482 1429 15872 1390 17189 1317 18524 1335 19986 1462 21442 1456 22864 1422 24296 1432 25593 1297 26960 1367 28460 1500 30128 1668 31491 1363 32766 1275 34274 1508 35868 1594 37301 1433 38602 1301 40086 1484 41504 1418 42879 1375 44309 1430 45473 1164 47012 1539 48430 1418 49933 1503 51333 1400 52688 1355 54061 1373 55444 1383 Month July Year 2006 x100 x100 Reading Total GPD 56898 1454 58330 1432 59757 1427 61145 1388 62577 1432 63808 1231 65239 1431 66732 1493 68158 1426 69730 1572 71302 1572 72921 1619 74480 1559 2314 1506 3804 1490 5329 1525 6900 1571 8584 1684 10106 1522 11553 1447 13226 1673 14791 1565 16360 1569 17940 1580 19398 1458 20900 1502 22492 1592 24139 1647 1451 1547 3040 1589 4672 1632 Month August Year 2006 x100 x100 Reading Total GPD 6267 1595 7921 1654 9454 1533 10951 1497 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|