Jump to content

Jason Hefley

Members
  • Content Count

    17
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jason Hefley

  • Rank
    member
  1. I am trying to create a data base for fantasy football. Â I am sure I am not the first nor am I the last. Â Â I am attempting to take all available players at a given site, and calculate value for each player. Â I am then going to sort by position to help the selection process each player. Â I have my tables getting data from a specific excel spreadsheet and importing it into a FM table. Â I am then performing calculations to come up with predicted performance. Â I next want to take that predicted performance and calculate to "fantasy points per dollar" thus finding the most value. Â Â I have two tables set up as seen in the .jpg. Â I can not relate the two tables and I am stuck. Â I have tried a join table using position, but no luck. Â When I connect to available players, and ESPN predictions using players as my primary key, it results in a many to many relationship and I can do nothing with the results. Â Â Â In summary I want to create a report that sorts by position, takes data from two tables for each player (salary and proj points) and calculate value. Â What join table do I need to accomplish? Â Thanks. Â I hope my lack of understandingof FM does not frustrate the community. Â You guys have been awesome in the past. Â I am mostly doing this to practice using filemaker.Â
  2. I do have those unique identifiers as stated in your reply. For playername_id I have ensured a unique identifier for each player by performing a calculation to make player_nameid and player_nameidfk to be the first two letters in a players first name and his last name (i.e Mike Trout = MiTrout) Thanks again.
  3. stat 1 and stat 2 were used for example only.  On the stats table I have 10 different stats.  I am trying to use a portal on the position table to display all players that play that particular position and their statistics (from the stat table)  The data that I am importing is a spreadsheet that has a players name, a player id and about 10 different stats.  When I attempt to create a relationship between the stats table to a player, I am getting a many to many relationship.  Here is a pic of my table structure if it makes it more clear.  Thanks for your patience as I am new to Filemaker, and very eager to learn
  4. Im in the process of just learning Filemaker, so please bear with me. Everytime I think I have a grasp on the process, I get humbled. So here is the latest: I am trying to create a report about baseball. My goal is to have a report by position and display all the stats for players that play that position. I have downloaded a .csm file that has every player since 1871 and their associated stats. So here is my thought process. First I created a table for Position: Position pos_name pos_id Next I created a table of players in that postition. I imported these players from a .csm file through the import records: Since I did not care about LF, CF, or RF (instead of), I created a field that if pos was lf, cf, or Rf it would automatically read of. Player_pos player_name player_nameid imported_pos pos pos_id Player_nameid, is a derived from a calculation to use the first two initials of a players name combined with his last name to uniquely identify said player The table positions is the parent and player_pos is the child and a succesful relationship was established. Now the problem!!! I created another table to import a players raw stats stats player name player nameidfk stat_1 stat_2 I was hoping that player_pos could act as a parent (as one player has one position) and the stats table the child (one player has many stats). When I try to establish the relationship I get a many to many relationship, and my macbook almost takes flight in my frustration I know that I had a stat column with only the player_nameidfk and entered the data manually using a portal I could do this using an intermediate table. The idea of manually entering literally thousands of lines of data makes me sad. What am I missing? I may be just having a fundamental filemaker concept error, so some expert help is appreciated. Thank You J
  5. I worked through those power points and watched a couple videos on youtube...It was all a relationship problem. Thank you very much...I just had to get the relationships correct and use a portal to show the ingredients everytime I select a new rub.
  6. The specific question I have is that I want to prepare a rub (with a button). When I do that I want it to import all the associated ingredients with that rub. I do not have a problem with changes in price over time, because I have a weighted average of how much each ingredient costs. I know that is going to change with time, and I do not have a problem with that. I am more worried about keeping track of inventory then I am price. Once I import all the associated ingredients, I want to be able to dictate how much rub I am going to make and then be able to calculate the exact quantity of each ingredient to make a "recipe" card. I am stuck on the part of importing the specific ingredients. My vision is to be able to select the rub, and the records will be imported based on the recipe. I then type in how much I am going to make, and press calculate and it commits the record and calculates the amount removed from inventory. I know I have a long ways to go. That is as specific as I can get..
  7. In my continued quest to learn Filemaker the old fashion way (just dive in head first!), I have got stuck again. I am attempting to make a typical inventory database that consists of recipe ingredients for Dry Rubs. I have a table and have successfully created the ability to take a receipt and enter the data off the receipt to calculate "inventory in". Now the twist. I have created another table to add recipes to the database, using a portal to add related records to each recipe at a given amount for each recipe. I would like to create a button/link to push "make" recipe and have the ingredients calculated for a given size of recipe and those results be taken out of my inventory. Eventually I would like to calculate the cost of each ingredient and therefore how much it would cost to make a given rub at a given size. I will just attach my database and let you professionals look at it. I am sure there is a way to do this. I was trying to make a portal in the "prepare_rub" that would use the data from the "rub_recipe" table and make and amount used field for calculation in the ingredient table to make an inventory. I have reached my limited level of knowledge and can not make it work. I appreciate your help. smokeandbones.zip
  8. The problem I am have having, or maybe this is my misunderstanding, is that when I am trying to use the weighted average for a given ingredient's price the result is zero. I have a layout that is all the ingredients used, and the all the purchases of that ingredient. I have a subsummary part that calculated the weighted average of all the transactions of a particular ingredient based on the quantity of the ingredient and the actual purchase price. I am then trying to take that subsummary part using the getsummary function and multiple it by the amount used in a recipe to give me the cost of making a given recpe. I think my biggest misunderstanding is how to relate the tables and what function to use.
  9. In the Recipe table I am trying to make it so when I create a recipe it calculates the cost of said recipe. I must use a weighted average of all the purchase I make of a given ingredient as the price of ingredients change over time.
  10. I am pretty new to this so I apologize for my ignorance, but I have no idea what you are talking about. When entering date on a purchase order, I should have a script that runs the calculation and it will become stored data that can be later used in calculations.
  11. When trying to change the calculation using an aggregate function it makes it an unstored field. I am using the calculation of: Sum (purchaseorder::Amount Paid)/Sum (purchaseorder::Cost per Pound) It classifies it as an unstored field. I attempted to change the field to an stored field and it gives me the following error: "The calculation “total cost” cannot be stored or indexed because it references a related field, a summary field, an unstored calculation field, or a field with global storage."
  12. I understand that now, but now trying to use aggregate functions, it show that the calculation is unstored. How do I change this as it is giving me the same result (blank field)
  13. Wow great question....I think the answer is yes. As I purchase product the weighted average will change, and I am ok with that. To answer your question, yes.
  14. I am pretty new to Filemaker so I would like to apologize ahead of time..  I am trying to learn Filemaker the old fashion way, and just diving into it and asking questions when I get stuck.  I am making a data base that I plan on tracking expenses for BBQ.  In this data base, I have a table called ingredients that list of all ingredients that I use.  It is the parent to a table I call "recipeingredients".  (ingredientid -> ingredientidfk).  I also have another table called "purchaseorder".  This table is a list of transactions of buying ingredients.  I know that prices change over time, so this table has a list layout of all purchases sorted by ingredient with a subsummary of the weighted average of the list of ingredients.  It is also the child of the ingredient table. (ingredientid -> ingredientidfk).  I have another table called recipe.  Lastly I have a table called recipeingredients that is a list view and sorted by recipe name.  I have a relationship between recipe and recipieingredients (recipeid -> recipeidfk).  I have another relationship between "purchaseorder" and recipeingredients.  I have attached a screen shot to make sure I explained that correctly.  My goal is create a field in the recipeingredients table that calculates how much each recipe costs to make.  I must extract the subsummary data from the purchaseorder table and multiply it by the amount used in each ingredient for a given recipe and total the value for each recipe.  I have attempted to use the "getsummary" function as shown: (GetSummary ( purchaseorder::Avg Cost per Pound ; purchaseorder::Ingredients )) * amount.  When I do this, the only number I get is 0.  I am posting this here as I think I have a relationship problem...  I may be way off here, so please help  Hafa Adai  Jason      Â
  15. I am pretty new to Filemaker,and maybe trying to bite off more than I can chew...story of my ilfe.. I have used the GetUrl script and pasted html data into a field called "url_g". In this HTML I am attempting to get some data out of 4 tables and put them in their respective fields. I have tried numerous scripts to accomplish this, and am really struggling. A sample of the HTML code is below: <tr class="ysprow1" align="right" height="16"><td class="yspscores" align="left">&nbsp;2010-11</td><td class="yspscores" align="left">ATL</td><td class="yspscores">77</td><td class="yspscores">34:17&nbsp;</td><td class="yspscores">6.5</td><td class="yspscores">13.5</td><td class="yspscores">47.7</td><td>&nbsp;</td><td class="yspscores">0.7</td><td class="yspscores">2.0</td><td class="yspscores">33.1</td><td>&nbsp;</td><td class="yspscores">3.0</td><td class="yspscores">4.1</td><td class="yspscores">72.5</td><td>&nbsp;</td><td class="yspscores">1.7</td><td class="yspscores">6.8</td><td class="yspscores">8.5</td><td>&nbsp;</td><td class="yspscores">3.3</td><td class="yspscores">2.6</td><td class="yspscores">1.3</td><td class="yspscores">1.6</td><td class="yspscores">2.8</td><td class="yspscores">16.5</td><td>&nbsp;</td></tr> Every number in this code needs to be placed in a particular field. To start I was simply trying to parse this text to a separate field so I could attempt to parse each number. Now, I am here begging for help. Is this even possible? I watched a video of a somebody doing it, but he made assumptions I did not understand. I have googled "parse data" and most of the examples are very simple. What I have tried is to Set a variable at word "ysprow1" and "ysprow2" (the beginning of the next table). I then attempted set a variable using the Middle function. I ran the script and it crashed FM. Here is a copy of the script I was using last #Parse the Tables out of the Code #First Table Loop Go to Record/Request/Page[ First ] Set Variable [ $t1beg; Value:Position ( NBA Players::url_g; "ysprowl1" ; 1 ; 1 ) ] Set Variable [ $t1end; Value:Position ( NBA Players::url_g; "ysprowl2" ; 1 ; 1 ) ] Set Variable [ $table1; Value:Middle ( NBA Players::url_g; $t1beg ; $1tend-$t1beg ) ] Set Field [ NBA Players::url_l_table_1; $table1 ] Go to Record/Request/Page [ Next; Exit after last ] End Loop I know this is the part where experienced FM designers are laughing..I deserve it Any help would greatly be appreciated..
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.