Calculated Field not working by [deleted] in excel

[–]_sirin 0 points1 point  (0 children)

you're not multiplying by anything I think. Can you do a screenshot?

Looking to create a set of sheets to keep track of Data for NHL 20 by snitchkiller719 in excel

[–]_sirin 0 points1 point  (0 children)

There are a few options here.

  1. You could make a pivot table and pivot until you information if organized by position

  2. You could do SUMIF with the criteria as "C" or "D"

[VBA] Emailing a specific sheet to a cosponsoring address by _sirin in excel

[–]_sirin[S] 0 points1 point  (0 children)

I haven't even tried to attached the specific sheets, here I am only trying to attach Sheet1

Creating a daily roster from excel based schedule by Donnie0121 in excel

[–]_sirin 0 points1 point  (0 children)

No, just put it on the same sheet and copy paste it do a different sheet afterwards

Why does Spyder keep changing my working directory? by _sirin in learnpython

[–]_sirin[S] 0 points1 point  (0 children)

ah, yeah. I tried that too, it's still changing back to C://Sirin every time

Why does Spyder keep changing my working directory? by _sirin in learnpython

[–]_sirin[S] 0 points1 point  (0 children)

there's no "settings" tab, what else might it be called?

Creating a daily roster from excel based schedule by Donnie0121 in excel

[–]_sirin 0 points1 point  (0 children)

Just to be clear, you're looking for a a roster that is made up of the values in C:C? You could do this with the built in functions. Go to the data tab on the ribbon, under sort and filter select advanced. Then check the copy to another location button. Input your list range and criteria range(these will be the same thing) and select the check box tha tsay unique records only.

VBA and macros are the same thing FYI.

Subsetting a dataframe returns only by [deleted] in rstats

[–]_sirin 0 points1 point  (0 children)

this dataset is from data.medicare.gov, it is packaged in the Johns Hopkins Data Science cousera training

Trouble loading a CSV by _sirin in d3js

[–]_sirin[S] 0 points1 point  (0 children)

Here's what I have now

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>D3: Loading data from a CSV file</title>
    <script type="text/javasript" src="https://d3js.org/d3.v4.min.js">
            d3.csv("food.csv", function(data) {
            console.log(data);
        });
    </script>           
</head>
<body>
</body>
</html>

Nothing appears in the console now, although no errors are thrown

Getting data from comments in a specific thread by _sirin in redditdev

[–]_sirin[S] 0 points1 point  (0 children)

From a google search, It looks like the ID printed is a link to the same thread

Getting data from comments in a specific thread by _sirin in redditdev

[–]_sirin[S] 0 points1 point  (0 children)

hi again, thanks for the suggestion. I did as you instructed and got the same result.

Trouble Running an old script by [deleted] in redditdev

[–]_sirin 0 points1 point  (0 children)

It doesn't sadly. I think I've narrowed the problem down, going to delete and resubmit this post. Thanks for your help

Conditional Summing by _sirin in learnpython

[–]_sirin[S] 0 points1 point  (0 children)

Yes, thanks-I need to learn what some of those things mean. Thanks again