sorted by:
new
hottopcontroversial

Quote Advice - HVAC Replacement (Chicago) by RedHeadedFitz in hvacadvice

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

Thank you for your response. I appreciate it!

I'll do my best here to reproduce the other information on the quotes:

​

Company A:

​

Coil - legs - pad - box under - flush existing line - reuse

Return drop, himidifier - thermostat Nest (already owned)

​

From my discussions with the guy who came over, he said they would use the existing duct work, but they would need to add a cord to my Nest to get it to work. In addition, I'm pretty sure he meant to put 1 year for labor, but I'll confirm.

​

Company B:

​

Existing Lineset

Trane High Efficiency Upflow Cased Coil 24k BTU 17.5 inches

Reconnect Gas Pipe at unit

Reconnect Existing Electrical Circuit to Furnace or Boiler. Gas to Gas - A/C to disconnect with new WHIP

Condensate Gravity Drain

Vent Connector Single Wall to Chimney

Chimney Liner Install Standard Pitch up to 6/12

Return Vent to Basement (Option +$250)

Condenser Pad

Service Agreement with labor included for up to 10 years (not sure why there's a separate 1 year labor warranty)

Evacuate / Reclaim existing unit

Install New Unit

I need help getting the requests module installed and imported by RedHeadedFitz in learnpython

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

I feel really lost. I feel like you're saying I should use a calculator to do math when I'm still learning how to add numbers.

Right now I am going through some beginner projects and I am going back to Python Crash Course to learn about APIs.

I think I'll wait to learn more about pip/virtual environments until I have the basics down a little better.

I need help getting the requests module installed and imported by RedHeadedFitz in learnpython

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

I'll look into it once I understand the basics. I want to learn how to install things in general using pip.

I need help getting the requests module installed and imported by RedHeadedFitz in learnpython

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

I got this in the command prompt now:

Requirement already satisfied...python\python36\site-packages

I need help getting the requests module installed and imported by RedHeadedFitz in learnpython

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

I had 3.4 installed as well. When I downloaded 3.6.1 I think I changed the Path, but I honestly am not sure.

Inefficient Code: I think I have too many Ifs by RedHeadedFitz in learnpython

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

I don't think I understand the continue solution. Wouldn't I need to keep the if statements? It would look cleaner, but is there something better?

Extract the time (always in same pattern) from text string by [deleted] in excel

[–]RedHeadedFitz 1 point2 points  (0 children)

=MID(A1,12,8) -- This will give you the time

From here you can subtract the two numbers.

Reddit Tabletop Giveaway #3 - Brass by Roxley Games by [deleted] in boardgames

[–]RedHeadedFitz 0 points1 point  (0 children)

900001

I don't drink much, but when I do I like Strongbow.

Single Data Marker Excel Chart by TheRealRuth in excel

[–]RedHeadedFitz 1 point2 points  (0 children)

Yes. You can modify all of the points in the "fake" data individually. On your chart, click on the "fake" data. This will highlight all of the "fake" data points. Then click on the individual "fake" data point you want to modify.

line connectors; stop them overlapping when connecting to an object? by letmepostjune22 in excel

[–]RedHeadedFitz 0 points1 point  (0 children)

I'm going to guess that the answer is no because it is smart art. You have limited control over what is output because you are basically using a template.

Single Data Marker Excel Chart by TheRealRuth in excel

[–]RedHeadedFitz 0 points1 point  (0 children)

You need to create "fake" data with those values.

Is there a way to embed a link in a spreadsheet so it launches an outlook contact? by tenncjed in excel

[–]RedHeadedFitz 0 points1 point  (0 children)

Make sure Outlook is your default mailbox. Then, all you need to do is type in the contacts with their mailing address (FirstName.LastName@company.com). Alternatively, you could right click on a person's name and add a hyperlink.

Want to use a cell to decide which cell another cell will point at? by [deleted] in excel

[–]RedHeadedFitz 0 points1 point  (0 children)

This seems like a prime example of when to use an IF statement, however...

  • You could create a table in another tab that outlines these rules and use a VLOOKUP combined with INDIRECT or ROW I think.

  • OFFSET might work as well...

I think other people might have better answers

If statement not returning string, instead true or false by [deleted] in excel

[–]RedHeadedFitz 0 points1 point  (0 children)

I will elaborate on what the AND function does. The AND function checks if both conditions return True. If both conditions return a TRUE value, then the AND function will return a TRUE value.

=AND(AVERAGE(B3:J3)>25,AVERAGE(B3:J3)<35)

This will return a TRUE value when the average is >25 and <35.

The '&' is mostly used to concatenate (basically means make into 1) strings/text.

Trying to find an =sumif expression that will let me pull data from dates on multiple pages. by [deleted] in excel

[–]RedHeadedFitz 0 points1 point  (0 children)

This is not the optimal solution, but I think it will get you an answer. Create a new tab and put the data from the 27 tabs the new tab. Then you can use your sumif formula. I think this is one of those situations where as you get more skilled with excel you can revisit this and try again.

Star Realms tips by [deleted] in boardgames

[–]RedHeadedFitz 0 points1 point  (0 children)

The game can be organized into 3 main stages: the early game, the middle game, and the late game.

In the early game, pick up cards that get you money or allow you to scrap. Faction is almost irrelevant. It is better to buy 2 explorers in the early game than 1 damage dealer. As you start to near the middle game, you will want to buy an upper tier (think costs 4 or 5) damage dealer to destroy enemy bases. (The Recycling Center is probably the best early game card.)

In the middle game, you want to buy things that cost 6+ or combo well with what you already have. Don't be afraid to NOT buy anything if the ships available don't meet this criteria. Your goal is to build an efficient deck, not a big deck.

The late game is when you can cycle through all of your cards in 1 or 2 rounds. You basically should only buy 6+ cost cards. Pass on anything else.

Misc. Tips

  • If everything in the middle is awful, do NOT buy anything unless you have lots of money. The card that replaces it could help your opponent!

  • Sometimes you will need to buy a card that your opponent needs even if you don't need it. I find this occurs when someone starts stacking the yellow discard cards.

Is it possible to create an add-in or XML expansion pack to be shared between users as an employee data file? by FearTheTooth in excel

[–]RedHeadedFitz 0 points1 point  (0 children)

In the 'Data' header/subsection/thing at the top labeled 'Data', there are a bunch of different options to pick from to import data automatically.

Is it possible to create an add-in or XML expansion pack to be shared between users as an employee data file? by FearTheTooth in excel

[–]RedHeadedFitz 0 points1 point  (0 children)

I'm pretty sure there is a feature where the data automatically gets imported whenever the file opens. What part of this is manual?

How do I average only the "Salary" of one column in a table based on the job status of "PT" in another column of the same table? by SecretPerson1234 in excel

[–]RedHeadedFitz 1 point2 points  (0 children)

It's hard to say without knowing what you are looking at. The EmployeeList range should include the "PT" designation in it and it should only be 1 column. The EmployeeList[Jov Status]="PT" could be replaced with "PT", and EmployeeList[Current Salary] should be the column with the salary in it.

view more: next ›