Programmer: Bill McQuain CS 1044: Water System Ledger Acct # Gal Used Amt Due Code ------------------------------------------------ 0: W38013 560 40.00 C 1: W37587 1844 116.90 R 2: W37768 2951 116.08 C 3: W37966 2062 44.96 C 4: W37920 1039 26.40 R 5: W38629 1312 40.00 C 6: W38362 1426 65.10 R 7: W38603 1250 47.50 R 8: W38522 559 40.00 C 9: W37723 2315 164.00 R 10: W38546 2511 80.88 C 11: W37643 2320 65.60 C 12: W37848 1068 40.00 C 13: W38594 1662 40.00 C 14: W38142 1508 40.00 C 15: W37657 2035 136.00 R 16: W38078 2984 230.90 R 17: W38455 2921 113.68 C 18: W38095 1054 40.00 C 19: W38168 2427 175.20 R 20: W38264 2602 88.16 C 21: W38482 1844 116.90 R 22: W38568 1857 118.20 R 23: W38579 1084 30.90 R ---------------------------------------------------- find W37587 1 W37587 1844 116.90 R ---------------------------------------------------- find W38168 19 W38168 2427 175.20 R ---------------------------------------------------- find W38629 5 W38629 1312 40.00 C ---------------------------------------------------- add W03011 2231 R 24 W03011 2231 155.60 R ---------------------------------------------------- add W04038 825 C 25 W04038 825 40.00 C ---------------------------------------------------- add W08071 1396 R 26 W08071 1396 62.10 R ---------------------------------------------------- add W09241 2631 C 27 W09241 2631 90.48 C ---------------------------------------------------- add W13943 2403 R 28 W13943 2403 172.80 R ---------------------------------------------------- display Acct # Gal Used Amt Due Code ------------------------------------------------ 0: W38013 560 40.00 C 1: W37587 1844 116.90 R 2: W37768 2951 116.08 C 3: W37966 2062 44.96 C 4: W37920 1039 26.40 R 5: W38629 1312 40.00 C 6: W38362 1426 65.10 R 7: W38603 1250 47.50 R 8: W38522 559 40.00 C 9: W37723 2315 164.00 R 10: W38546 2511 80.88 C 11: W37643 2320 65.60 C 12: W37848 1068 40.00 C 13: W38594 1662 40.00 C 14: W38142 1508 40.00 C 15: W37657 2035 136.00 R 16: W38078 2984 230.90 R 17: W38455 2921 113.68 C 18: W38095 1054 40.00 C 19: W38168 2427 175.20 R 20: W38264 2602 88.16 C 21: W38482 1844 116.90 R 22: W38568 1857 118.20 R 23: W38579 1084 30.90 R 24: W03011 2231 155.60 R 25: W04038 825 40.00 C 26: W08071 1396 62.10 R 27: W09241 2631 90.48 C 28: W13943 2403 172.80 R ---------------------------------------------------- delete W37587 Removed 1 ---------------------------------------------------- delete W38168 Removed 18 ---------------------------------------------------- delete W38629 Removed 4 ---------------------------------------------------- display Acct # Gal Used Amt Due Code ------------------------------------------------ 0: W38013 560 40.00 C 1: W37768 2951 116.08 C 2: W37966 2062 44.96 C 3: W37920 1039 26.40 R 4: W38362 1426 65.10 R 5: W38603 1250 47.50 R 6: W38522 559 40.00 C 7: W37723 2315 164.00 R 8: W38546 2511 80.88 C 9: W37643 2320 65.60 C 10: W37848 1068 40.00 C 11: W38594 1662 40.00 C 12: W38142 1508 40.00 C 13: W37657 2035 136.00 R 14: W38078 2984 230.90 R 15: W38455 2921 113.68 C 16: W38095 1054 40.00 C 17: W38264 2602 88.16 C 18: W38482 1844 116.90 R 19: W38568 1857 118.20 R 20: W38579 1084 30.90 R 21: W03011 2231 155.60 R 22: W04038 825 40.00 C 23: W08071 1396 62.10 R 24: W09241 2631 90.48 C 25: W13943 2403 172.80 R ---------------------------------------------------- find W37587 W37587 not found ---------------------------------------------------- find W38168 W38168 not found ---------------------------------------------------- sortby AccountNumber Swaps: 183 ---------------------------------------------------- find W37643 5 W37643 2320 65.60 C ---------------------------------------------------- find W38603 25 W38603 1250 47.50 R ---------------------------------------------------- sortby RateCode Swaps: 86 ---------------------------------------------------- find W37643 2 W37643 2320 65.60 C ---------------------------------------------------- find W38603 25 W38603 1250 47.50 R ---------------------------------------------------- exit Finished script ---------------------------------------------------- Acct # Gal Used Amt Due Code ------------------------------------------------ 0: W04038 825 40.00 C 1: W09241 2631 90.48 C 2: W37643 2320 65.60 C 3: W37768 2951 116.08 C 4: W37848 1068 40.00 C 5: W37966 2062 44.96 C 6: W38013 560 40.00 C 7: W38095 1054 40.00 C 8: W38142 1508 40.00 C 9: W38264 2602 88.16 C 10: W38455 2921 113.68 C 11: W38522 559 40.00 C 12: W38546 2511 80.88 C 13: W38594 1662 40.00 C 14: W03011 2231 155.60 R 15: W08071 1396 62.10 R 16: W13943 2403 172.80 R 17: W37657 2035 136.00 R 18: W37723 2315 164.00 R 19: W37920 1039 26.40 R 20: W38078 2984 230.90 R 21: W38362 1426 65.10 R 22: W38482 1844 116.90 R 23: W38568 1857 118.20 R 24: W38579 1084 30.90 R 25: W38603 1250 47.50 R