Related questions

Program skipping 'if' Statement and defaults to 'else'

2018-10-11 18:51 Savannah Stidham imported from Stackoverflow

I'm doing an assignment for my programming class, but something is wrong with my code (again) and I've spent the past hour and a half trying to debug it. The code is a sort of gambling game, where the user enters an amount to bet, and chooses either high, low, or sevens. high is when the die roll an 8 or higher, low is when the die roll a 6 or lower, and seven is when the die roll a total of 7. If the die rolls seven, the bet is multiplied by 4 and awarded to the user. Otherwise, when the user "loses", they lose the amount that they bet. I can't seem to figure out exactly what is wrong.

To begin with, the winnings are not correct. They are showing up in the console as "You won 128 dollars!" and then when the code repeats,the current pool always becomes 132, even when the user lost and money should have been subtracted. Also, the program skips the "if" statements in the determineWinnings method - it defaults to the else even when the user should have won. This is due in 20 minutes and I can't figure out how to fix it! Any help is sincerely appreciated!

package example;
import java.util.Scanner;

public class test
{

public static void main(String[] args)
{

    Scanner inScanner = new Scanner(System.in);
    int currentPool = 100; 
    int bet = ' ';
    char highLow = ' ';
    int roll = ' ';
    int winnings = ' ';

    System.out.println("You have " + currentPool + " dollars.");
    getBet(inScanner, currentPool);
    getHighLow(inScanner);
    determineWinnings(highLow, bet, roll);
    currentPool = currentPool + winnings;
    System.out.println("");

    while (bet != 0)
    {
        System.out.println("You have " + currentPool + " dollars.");
        getBet(inScanner, currentPool);
        getHighLow(inScanner);
        determineWinnings(highLow, bet, roll);
        currentPool = currentPool + winnings;
        System.out.println("");
    }


}



private static int getBet(Scanner inScanner, int currentPool)
{
    System.out.print("Enter an amount to bet (0 to quit): ");
    String strBet = inScanner.nextLine();
    int bet = Integer.parseInt(strBet);


    while (bet < 0 || bet > currentPool)
    {
        System.out.print("Your bet MUST be between 0 and " + currentPool + " dollars.");
        System.out.println("You have " + currentPool + " dollars.");
        System.out.print("Enter an amount to bet (0 to quit): ");
        strBet = (inScanner.nextLine());
        bet = Integer.parseInt(strBet);
    }

    if (bet == 0)
    {
        System.out.println("You have " + currentPool + " dollars.");
        System.out.println("Goodbye!");
        return bet;
    }
    else
    {
        return bet;
    }
}


private static char getHighLow(Scanner inScanner)
{
    System.out.print("High, Low, or Sevens (H/L/S): ");
    String hls = inScanner.nextLine();
    char highLow = ' ';

    if (hls.equals("H") || hls.equals("h"))
    {
        highLow = 'H';
    }
    else if (hls.equals("L") || hls.equals("l"))
    {
        highLow = 'L';
    }
    else if (hls.equals("S") || hls.equals("s"))
    {
        highLow = 'S';
    }
    else
    {
        System.out.print("ERROR: invalid character entered. Please try again.");

        while (!hls.equals("H") || !hls.equals("h") || !hls.equals("L") || !hls.equals("l") || !hls.equals("S") || !hls.equals("s"))
        {
            System.out.println("High, Low, or Sevens (H/L/S): ");
            hls = inScanner.nextLine();
        }
    }
    return highLow;
}   


private static int getRoll()
{
    int roll = (int)Math.floor(Math.random() * 6 + 1);
    return roll;
}


private static int determineWinnings(char highLow, int bet, int roll)
{
    int rollOne = getRoll();
    int rollTwo = getRoll();
    int total = rollOne + rollTwo;
    int winnings = bet + 0;
    System.out.println("Die 1 rolls: " + rollOne);
    System.out.println("Die 2 rolls: " + rollTwo);
    System.out.println("Total of two dice is: " + total);

    if (highLow == 'H')
    {
        if (total >= 8)
        {
            System.out.println("You won " + winnings + " dollars!");

        }
        else
        {
            System.out.println("You lost!");
            winnings = 0 - bet;

        }
    }
    else if (highLow == 'L')
    {
        if (total <= 6)
        {
            System.out.println("You won " + winnings + " dollars!");

        }
        else 
        {
            System.out.println("You lost!");
            winnings = (0 - bet);

        }
    }
    else
    {
        if (total == 7)
        {
            winnings = bet * 4;
            System.out.println("You won " + winnings + " dollars!");

        }
        else 
        {
            System.out.println("You lost!");
            winnings = 0 - bet;

        }
    }
    return winnings;
}

}

2 answers

  • answered 2018-10-11 19:20 Dawood ibn Kareem

    The part you haven't understood is that every method - in fact, every call to every method - has its own collection of local variables. That means that

    • the winnings variable declared in main is NOT the same variable as the winnings variable declared in determineWinnings;
    • the bet variable declared in main is NOT the same variable as the bet variable declared in getBet.

    What you need to do is to make sure that the value returned by each called method is assigned to the variable that you want to store it in, in the caller method. So in main, when you call getBet, you actually want to write

    bet = getBet(inScanner, currentPool);

    so that the value returned from getBet gets assigned to the bet variable from main. Similarly, when you call determineWinnings, you need to write

    winnings = determineWinnings(highLow, bet, roll);

    so that the value returned from determineWinnings gets assigned to the winnings variable from main.

    If you don't do that, then all the variables in main just keep their original values, which are 100 for currentPool and 32 for winnings (because ' ' is just another way to write 32). That's why your final value turns out to be 132.

  • answered 2018-10-11 19:32 sachin patel

    To avoid skipping if in execution use

    bet = getBet(inScanner, currentPool); highLow = getHighLow(inScanner); winnings = determineWinnings(highLow, bet, roll);

    instead of directly calling

    getBet(inScanner, currentPool); getHighLow(inScanner); determineWinnings(highLow, bet, roll);

    Reson for skipping if statement and wrong answer:

    getBet(inScanner, currentPool) method is returning the value which is not assigned to

    int bet = ' '; java tries to convert ' ' to an integer which is 32. so bet is every time assigned 32 value when you call getBet(inScanner, currentPool) even if the entered value is different(which will give wrong answer).

    In the case of getHighLow(inScanner) method is returning char value but since it is not assigned to highLow, highLow will always have value ' '.

    since highLow has not assigned the actual value(H/L/S), if statement will be skipped as ' '!=(H/L/S) and always statements in else are executed.

See also questions close to this topic

  • How can the creation of an instance happen in one component, but used in another?

    Lets say there is a maven multi module project.
    1. app (one jar)
    2. persistence (second jar)

    The aim is to make app "not know" about persistence.

    In other words I want to make Persistence depend on app. Looking at the diagram bellow I don't want arrows pointing from app to persistence.

    I would like to use the abstract factory (as seen also in the diagram).

    So how can I get an instance of the PersistenceImpl in app component without actually specify in the app component PersistenceFactoryImpl or PersistenceImpl?
    Diagram

  • Java --- java portion of opencv.js page

    well all of my time has been trying to get edge on webrtc video in browser at my site....

    i have this page that will work well....if it works better....any help with the page..... would be great...follow...

    a large portion of my code came from https://www.webrtc-experiment.com/

    and opencvjs example for video display

    https://docs.opencv.org/3.4/dd/d00/tutorial_js_video_display.html

    <!DOCTYPE HTML>
<html>
<head>
  <title>J^2</title>
  <meta name="description" content="=100jay" />
  <meta name="keywords" content="Music, Art, Forum" />
  <meta http-equiv="content-type" content="text/html" />
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://cdn.webrtc-experiment.com/style.css">
</head>
<style>
body, div, p {
    font: 400 14px/22px Roboto,sans-serif;
}
canvas, img, video {
    border: 1px solid black;
}
td {
    padding: 10px 0px 0px 10px;
    text-align: center;
}
button {
    display: inline-block;
    color: #fff;
    background-color: #337ab7;
    border-color: #2e6da4;
    padding: 6px 12px;
    margin-bottom: 0;
    font-size: 14px;
    font-weight: bold;
    text-align: center;
    white-space: nowrap;
    vertical-align: middle;
    -ms-touch-action: manipulation;
    touch-action: manipulation;
    cursor: pointer;
    -webkit-user-select: none;
    -moz-user-select: none;
    -ms-user-select: none;
    user-select: none;
    background-image: none;
    border: 1px solid transparent;
    border-radius: 4px;
}
button[disabled] {
    cursor: not-allowed;
    filter: alpha(opacity=65);
    -webkit-box-shadow: none;
    box-shadow: none;
    opacity: .65;
}
.control {
    margin-bottom: 3px;
}
.err {
    color: red;
    font-weight: bold;
}
.caption {
    margin: 0;
    font-weight: bold;
}
.code {
    padding: 4px 6px;
    margin: 4px 8px 4px 2px;
    background-color: #FBFCFD;
    border: 1px solid #C4CFE5;
    font-family: monospace, fixed;
    font-size: 13px;
    min-height: 13px;
    line-height: 1.0;
    text-wrap: unrestricted;
    padding-bottom: 0px;
    margin: 0px;
}
.hidden {
    display: none;
}
.small {
    max-width: 300px;
}

</style>
<style>
.column {
    float: left;
    width: 50%;
}

/* Clear floats after the columns */
.row:after {
    content: "";
    display: table;
    clear: both;
}
iframe#embed
{
    width:2600px;       /* set this to approximate width of entire page you're $
    height:3800px;      /* determines where the bottom of the page cuts off */
    margin-left:-0px; /* clipping left side of page */
    margin-top:-2350px;  /* clipping top of page */
    overflow:hidden;
    /* resize seems to inherit in at least Firefox */
    -webkit-resize:none;
    -moz-resize:none;
    resize:none;
}






container {
    margin: 0px auto;
    width: 1440px;
    height: 1080px;
    border: 10px #333 solid;
}
videoElement {
    width: 1440px;
    height: 1080px;
{height: 100%;}
}
  *
 { margin:0px;
   padding:0px;
   color:#777;
   }

body
{ font: normal 2.2em 'trebuchet ms', arial, sans-serif;
  background: #1339de;
  color: #777;}

p
{ padding: 0 0 20px 0;
  line-height: 1.7em;}

img
{ border: 0;}

h1
{ font: normal 175% 'century gothic', arial, sans-serif;
  color: #000000;
  margin: 0 0 15px 0;
  padding: 15px 0 5px 0;}

h2, h3, h4, h5, h6 
{ font: normal 175% 'century gothic', arial, sans-serif;
  color: #43423F;
  margin: 0 0 15px 0;
  padding: 15px 0 5px 0;}

h2
{ font: normal 175% 'century gothic', arial, sans-serif;
  color: #A4AA04;}
h3
{  text-align: center;}
h4, h5, h6
{ margin: 0;
  padding: 0 0 5px 0;
  font: normal 120% arial, sans-serif;
  color: #A4AA04;}

h5, h6
{ font: italic 95% arial, sans-serif;
  padding: 0 0 15px 0;
  color: #000;}

h6
{ color: #362C20;}

a, a:hover
{ outline: none;
  text-decoration: underline;
  color: #1293EE;}

a:hover
{ text-decoration: none;}

.left
{ float: left;
  width: auto;
  margin-right: 10px;}

.right
{ float: right; 
  width: auto;
  margin-left: 10px;}

.center
{ display: block;
  text-align: center;
  margin: 20px auto;}

blockquote
{ margin: 20px 0; 
  padding: 10px 20px 0 20px;
  border: 1px solid #E5E5DB;
  background: #FFF;}

ul
{ margin: 2px 0 22px 17px;}

ul li
{ list-style-type: circle;
  margin: 0 0 6px 0; 
  padding: 0 0 4px 5px;}

ol
{ margin: 8px 0 22px 20px;}

ol li
{ margin: 0 0 11px 0;}

#logo, #menubar, #site_content, #footer
{ margin-left: auto; 
  margin-right: auto;
  margin-top: 20px;
  margin-bottom: 20px;}

#main
{ background: #1339de;
margin: 0; 
  }

#header
{ background: #1339de	;
  }

#logo
{ width: 1280px;
  height: 1440px;
  background: #025587 url(logo.png) no-repeat;}

#menubar
{ 
  width: 1420px;
  height: 420px;
  background: #ff7f01 url(menu.png) repeat-x;} 

ul#menu, ul#menu li
{ float: left;
  margin: 0; 
  padding: 0;}

ul#menu li
{ list-style: none;}

ul#menu li a
{ letter-spacing: 0.2em;
  font: normal 150% 'lucida sans unicode', arial, sans-serif;
  display: block; 
  float: left; 
  height: 50px;
  padding: 29px 26px 6px 26px;
  text-align: center;
  color: #FFF;
  text-transform: uppercase;
  text-decoration: none;
  background: transparent;} 

ul#menu li a:hover, ul#menu li.selected a, ul#menu li.selected a:hover
{ color: #FFF;
  background: #1C2C3E url(menu_select.png) repeat-x;}

#site_content
{ width: 2600px;
  overflow: hidden;
  background: #FFFFFF;} 

.sidebar
{ float: right;
  width: 300px;
  padding: 0 15px 20px 15px;}

.sidebar ul
{ width: 178px; 
  padding: 4px 0 0 0; 
  margin: 4px 0 30px 0;}

.sidebar li
{ list-style: none; 
  padding: 0 0 7px 0; }

.sidebar li a, .sidebar li a:hover
{ padding: 0 0 0 40px;
  display: block;
  background: transparent url(link.png) no-repeat left center;} 

.sidebar li a.selected
{ color: #444;
  text-decoration: none;} 

#content
{ text-align: left;
  width: 2600 px;
  padding: 20px 20px 20px 20px;}

#content ul
{ margin: 2px 0 22px 0px;}

#content ul li
{ list-style-type: none;
  background: url(bullet.png) no-repeat;
  margin: 0 0 6px 0; 
  padding: 0 0 4px 25px;
  line-height: 12.2em;}

#footer
{ width: 1420px;
  font: normal 100% 'lucida sans unicode', arial, sans-serif;
  height: 232px;
  padding: 24px 0 5px 0;
   	
  text-align: center; 
  background: #29425E url(footer.png) repeat-x;
  color: #FFF;
  text-transform: uppercase;
  letter-spacing: 0.1em;}

#footer a
{ color: #FFF;
  text-decoration: none;}

#footer a:hover
{ color: #FFF;
  text-decoration: underline;}
</style>
<body>
  <div id="main">
    <div id="site_content">            
      <div id="content">

<div class="row">
  <div class="column">




<section>
<div align="left">
    <style>
        video {
            object-fit: fill;
            width: 1440px;
		height:1080px;
        }
        button,
        input,
        select {
            font-weight: normal;
            padding: 2px 4px;
            text-decoration: none;
            display: inline-block;
            text-shadow: none;
            font-size: 24px;
            outline: none;
        }

        .make-center {
            text-align: left;
            padding: 5px 10px;
        }
    </style>
</head>
<script async src="https://docs.opencv.org/master/opencv.js" type="text/javascript"></script>
<body>
                <div class="make-center">
                <input type="text" id="room-id" value="hello">
                <button id="join-room">JOIN AND VIEW MY BROADCAST (hello) ROOM</button>
                <button id="open-or-join-room"></button>
                <button id="open-room">START A BROADCAST</button>
                <div id="room-urls" style="text-align: center;display: none;background: #F1EDED;margin: 15px -10px;border: 1px solid rgb(189, 189, 189);border-left: 0;border-right: 0;"></div>
                </div>
        
<h2>Video Capture Example</h2>
<div id="videos-container" width=1440 height=1080></div>
<canvas id="canvasOutput" width=1440 height=1080></canvas>
<script type="text/javascript">
let streaming = true;
let videoInput = document.getElementById('videos-container');
let canvasOutput = document.getElementById('canvasOutput');
let canvasContext = canvasOutput.getContext('2d');
videoInput.width = videoInput.videoWidth;
videoInput.height = videoInput.videoHeight;
let video = document.getElementById('videos-container');
let src = new cv.Mat(video.height, video.width, cv.CV_8UC4);
let dst = new cv.Mat(video.height, video.width, cv.CV_8UC1);
let cap = new cv.VideoCapture(video);
cap.read(src);
cv.Canny(src, dst, 100, 250);
cv.imshow('canvasOutput', dst);
</script>
</section>
	
<script src="https://rtcmulticonnection.herokuapp.com/dist/RTCMultiConnection.min.js"></script>
<script src="https://rtcmulticonnection.herokuapp.com/socket.io/socket.io.js"></script>
<script>
            // ......................................................
            // .......................UI Code........................
            // ......................................................

            document.getElementById('open-room').onclick = function() {
                disableInputButtons();
                connection.sdpConstraints.mandatory = {
                    OfferToReceiveAudio: false,
                    OfferToReceiveVideo: false
                };
                connection.open(document.getElementById('room-id').value, function() {
                    showRoomURL(connection.sessionid);
                });
            };

            document.getElementById('join-room').onclick = function() {
                disableInputButtons();
                connection.sdpConstraints.mandatory = {
                    OfferToReceiveAudio: true,
                    OfferToReceiveVideo: true
                };
                connection.join(document.getElementById('room-id').value);
            };

            document.getElementById('open-or-join-room').onclick = function() {
                disableInputButtons();
                connection.openOrJoin(document.getElementById('room-id').value, function(isRoomExists, roomid) {
                    if(!isRoomExists) {
                        showRoomURL(roomid);
                    }
                });
            };

            // ......................................................
            // ..................RTCMultiConnection Code.............
            // ......................................................

            var connection = new RTCMultiConnection();

            // by default, socket.io server is assumed to be deployed on your own URL
            connection.socketURL = '/';

            // comment-out below line if you do not have your own socket.io server
            connection.socketURL = 'https://rtcmulticonnection.herokuapp.com:443/';

            connection.socketMessageEvent = 'video-broadcast-demo';

            connection.session = {
                audio: true,
                video: true,
                oneway: true
            };

            connection.videosContainer = document.getElementById('videos-container');
            connection.onstream = function(event) {
                connection.videosContainer.appendChild(event.mediaElement);
                event.mediaElement.play();
                setTimeout(function() {
                    event.mediaElement.play();
                }, 5000);
            };

            function disableInputButtons() {
                document.getElementById('open-or-join-room').disabled = true;
                document.getElementById('open-room').disabled = true;
                document.getElementById('join-room').disabled = true;
                document.getElementById('room-id').disabled = true;
            }

            // ......................................................
            // ......................Handling Room-ID................
            // ......................................................

            function showRoomURL(roomid) {
                var roomHashURL = '#' + roomid;
                var roomQueryStringURL = '?roomid=' + roomid;

                var html = '<h2>Unique URL for your room:</h2><br>';

                html += 'Hash URL: <a href="' + roomHashURL + '" target="_blank">' + roomHashURL + '</a>';
                html += '<br>';
                html += 'QueryString URL: <a href="' + roomQueryStringURL + '" target="_blank">' + roomQueryStringURL + '</a>';

                var roomURLsDiv = document.getElementById('room-urls');
                roomURLsDiv.innerHTML = html;

                roomURLsDiv.style.display = 'block';
            }

            (function() {
                var params = {},
                    r = /([^&=]+)=?([^&]*)/g;

                function d(s) {
                    return decodeURIComponent(s.replace(/\+/g, ' '));
                }
                var match, search = window.location.search;
                while (match = r.exec(search.substring(1)))
                    params[d(match[1])] = d(match[2]);
                window.params = params;
            })();

            var roomid = '';
            if (localStorage.getItem(connection.socketMessageEvent)) {
                roomid = localStorage.getItem(connection.socketMessageEvent);
            } else {
                roomid = connection.token();
            }
            document.getElementById('room-id').value = roomid;
            document.getElementById('room-id').onkeyup = function() {
                localStorage.setItem(connection.socketMessageEvent, this.value);
            };

            var hashString = location.hash.replace('#', '');
            if(hashString.length && hashString.indexOf('comment-') == 0) {
              hashString = '';
            }

            var roomid = params.roomid;
            if(!roomid && hashString.length) {
                roomid = hashString;
            }

            if(roomid && roomid.length) {
                document.getElementById('room-id').value = roomid;
                localStorage.setItem(connection.socketMessageEvent, roomid);

                // auto-join-room
                (function reCheckRoomPresence() {
                    connection.checkPresence(roomid, function(isRoomExists) {
                        if(isRoomExists) {
                            connection.join(roomid);
                            return;
                        }

                        setTimeout(reCheckRoomPresence, 5000);
                   });
                })();

                disableInputButtons();
            }
        </script>
</div>
</div>
  <div class="column">

<body>

<canvas id="canvas" width="1100" height="1100"
style="background-color:#333">
</canvas>

<script>
var canvas = document.getElementById("canvas");
var ctx = canvas.getContext("2d");
var radius = canvas.height / 2;
ctx.translate(radius, radius);
radius = radius * 0.90
setInterval(drawClock, 1000);

function drawClock() {
  drawFace(ctx, radius);
  drawNumbers(ctx, radius);
  drawTime(ctx, radius);
}

function drawFace(ctx, radius) {
  var grad;
  ctx.beginPath();
  ctx.arc(0, 0, radius, 0, 2*Math.PI);
  ctx.fillStyle = 'white';
  ctx.fill();
  grad = ctx.createRadialGradient(0,0,radius*0.95, 0,0,radius*1.05);
  grad.addColorStop(0, '#333');
  grad.addColorStop(0.5, 'white');
  grad.addColorStop(1, '#333');
  ctx.strokeStyle = grad;
  ctx.lineWidth = radius*0.1;
  ctx.stroke();
  ctx.beginPath();
  ctx.arc(0, 0, radius*0.1, 0, 2*Math.PI);
  ctx.fillStyle = '#333';
  ctx.fill();
}

function drawNumbers(ctx, radius) {
  var ang;
  var num;
  ctx.font = radius*0.15 + "px arial";
  ctx.textBaseline="middle";
  ctx.textAlign="center";
  for(num = 1; num < 13; num++){
    ang = num * Math.PI / 6;
    ctx.rotate(ang);
    ctx.translate(0, -radius*0.85);
    ctx.rotate(-ang);
    ctx.fillText(num.toString(), 0, 0);
    ctx.rotate(ang);
    ctx.translate(0, radius*0.85);
    ctx.rotate(-ang);
  }
}

function drawTime(ctx, radius){
    var now = new Date();
    var hour = now.getHours();
    var minute = now.getMinutes();
    var second = now.getSeconds();
    //hour
    hour=hour%12;
    hour=(hour*Math.PI/6)+
    (minute*Math.PI/(6*60))+
    (second*Math.PI/(360*60));
    drawHand(ctx, hour, radius*0.5, radius*0.07);
    //minute
    minute=(minute*Math.PI/30)+(second*Math.PI/(30*60));
    drawHand(ctx, minute, radius*0.8, radius*0.07);
    // second
    second=(second*Math.PI/30);
    drawHand(ctx, second, radius*0.9, radius*0.02);
}

function drawHand(ctx, pos, length, width) {
    ctx.beginPath();
    ctx.lineWidth = width;
    ctx.lineCap = "round";
    ctx.moveTo(0,0);
    ctx.rotate(pos);
    ctx.lineTo(0, -length);
    ctx.stroke();
    ctx.rotate(-pos);
}
</script>

</body>
</div>

</div>

<div class="column">


</div></div>

</body>
</div></div>
    <div id="content_footer"></div>
</html>

    must be run on https server i use this with a self made cert and key....

    webserver.py

    #!/usr/bin/env python
import os, sys
import BaseHTTPServer
import CGIHTTPServer
import SocketServer
import cgitb; cgitb.enable() ## This line enables CGI error reporting
import ssl
class ThreadingCGIServer(SocketServer.ThreadingMixIn,BaseHTTPServer.HTTPServer):
     pass
handler = CGIHTTPServer.CGIHTTPRequestHandler
handler.cgi_directories = ["/cgi-bin"]
os.chdir('/var/www/')
server = ThreadingCGIServer(("", 443), handler)
server.socket = ssl.wrap_socket(server.socket, certfile="/var/security/www.99.9.180.210_com.crt", keyfile="/var/security/www.99.9.180.210_com.key", server_side=True, ca_certs=None, do_handshake_on_connect=True, suppress_ragged_eofs=True)
handler.have_fork=False
try:
     while 1:
          sys.stdout.flush()
          server.handle_request()
except KeyboardInterrupt:
     print "Finished"

    any help getting the opencvjs part to read div videos-container would help a lot, from what i understand it is wrapping a video-div named video that is not grabbed in the capture...not completely sure.

  • lua encode protobuf messge and java decode fail

    I use lua in nginx to encode a protobuf messge by binary transfer.Then use java to decode the message. Below is the error: com.google.protobuf.InvalidProtocolBufferException: While parsing a protocol message, the input ended unexpectedly in the middle of a field. This could mean either than the input has been truncated or that an embedded message misreported its own length.

  • Excel: Aggregate function combined with IF function

    I have an Excel formula I'm having trouble with. I have searched for an answer on Google and YouTube but can't seem to find one.

    In Excel I'm using an aggregate function with two criteria. Based on "Location" and "Function" I'm able to extract records from endless rows and columns of data.

    I have a dropdown list for both Location and Function. For "Location" I want to be able to choose between:

    No Selection, Amsterdam, Paris, London and Madrid.

    For "Function" I want to be able to choose between:

    No Selection, Banker, Banker II and Assistant.

    I'm using the following formula:

    =IF(ROWS(M$2:M2)>$I$6;"";INDEX(source[Name];AGGREGATE(15;6;(ROW(source[Name])-ROW(source[#Headers]))/((source[Location]=$I$2)*(source[Function]=$I$3));ROWS(M$2:M2))))

    I want to be able to extract data based on two criteria but also based on one criteria. That's why I'm using "No Selection". No whenever I choose "No Selection" for Location, I want to be able to extract the data for all the bankers in all of the locations.

    The problem I'm having is with the above formula I have to choose two criteria. Whenever I select "No Selection" on one of the dropdown lists it wont extract data.

    I know an IF function can be used but I can't get it right. It's a school project I'm working on and my knowledge about Excel is very limited.

    Link to an example I'm working with: https://www.dropbox.com/s/mhsfzv7d63y7rb7/example%281%29.xlsx?dl=0

  • i dont understand why my if cycle does not work correctly

    I wrote next cycle, but when I run it, Spyder shows me next message:

    ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().

    why it happens? because I specified the value to be assigned to the column if none of the conditions is met.

    if 11 >= df['age'] <= 20:
    df['age_enc'] = 20
elif 21 >= df['age'] <= 25:
    df['age_enc'] = 25
elif 26 >= df['age'] <= 30:
    df['age_enc'] = 30
elif 31 >= df['age'] <= 35:
    df['age_enc'] = 35       
elif 36 >= df['age'] <= 40:
    df['age_enc'] = 40    
elif 41 >= df['age'] <= 50:
    df['age_enc'] = 50  
elif 51 >= df['age'] <= 60:
    df['age_enc'] = 60  
else:
    df['age_enc'] = 100;
  • The if/else method doesn't running properly

    I want to make a method, which show vbcim as 0 if value is not in the versenyzok.txt, and show the real value if value is found. Something is misunderstood by me, and the Feltolt method doesn't running properly.

    It should list the results from the text file. If the 4th value is not found set it as 0, and if its found list it as well

      package vizsgamintaa;
    import java.io.File;
    import java.io.FileNotFoundException;
    //import java.io.PrintStream;
    import java.text.ParseException;
    import java.text.SimpleDateFormat;
    import java.util.ArrayList;
    import java.util.Date;
    import java.util.Scanner;
    //import java.util.logging.Level;
    //import java.util.logging.Logger;

    public class VizsgaMintaA {

        static SimpleDateFormat df = new SimpleDateFormat("yyyy.MM.dd");
       static Scanner sc= new Scanner(System.in);

        public static void main(String[] args) throws ParseException, FileNotFoundException {
            ArrayList<Versenyzo> versenyzok = new ArrayList<>();
            Feltolt(versenyzok);
            Kiir(versenyzok);
        }
        private static void Feltolt(ArrayList<Versenyzo> versenyzok) throws ParseException{
        Versenyzo v;
        File f = new File("versenyzok.txt");
        try {
                Scanner scan = new Scanner(f, "iso-8859-2");
                while (scan.hasNextLine()) {
                    String sor = scan.nextLine();
                    String[] adatok = sor.split(";");
                    if (adatok.length == 3) {
                       v = new Versenyzo();
                       v.nev = adatok[0];
                        v.szuletes = df.parse(adatok[1]);
                         v.csapat = adatok[2];
                         if (adatok[3].length()==0 )  {

                            v.vbcim = 0; 
                        } 
                         else {
                            v.vbcim = Integer.parseInt(adatok[3]);
                        }
                    } else {
                         v = new Versenyzo (adatok[0],df.parse(adatok[1]),adatok[2],Integer.parseInt(adatok[3]));
                    }
                    versenyzok.add(v);

                    }
            } catch (FileNotFoundException ex) {
                System.out.println("Nincs meg a fájl.");
            }

        }

        public static void Kiir(ArrayList<Versenyzo>versenyzok){
        for (Versenyzo f : versenyzok){
            System.out.println(f.toString());
        }
        }
    }
       class Versenyzo {

           String nev,csapat;
           Date szuletes;
           int vbcim;
           SimpleDateFormat df = new SimpleDateFormat("yyyy.MM.dd");

            @Override
       public String toString(){
       return "Versenyzo:" +nev + "Született:" + df.format(szuletes)+"Csapata:"+ csapat + "Vb címek:" + vbcim; 
       }
       public Versenyzo(String nev, Date szuletes, String csapat, int vbcim) {
           this.nev = nev;
           this.szuletes = szuletes;
           this.csapat = csapat;
           this.vbcim = vbcim;

       }
       public Versenyzo(){
       }
    }

    The 

    else {     
       v = new Versenyzo (adatok[0],df.parse(adatok[1]),adatok[2],Integer.parseInt(adatok[3]));
  }

    part is some way not works. ArrayIndexOutOfBoundsException it says.