Version 4.1.2 is Completed
This new version of Farm Manager is designed to be updated regularly by adding the new items to the sheets as opposed to downloading a new version each time. Updates will be posted weekly in an Excel file so that it may either be opened directly or downloaded and used later using the option you should get from your browser.
The Farm Manager is available in three ways they are stand alone workbooks, the complete workbook, the Farm Manager Inventory and farm data only, and the Harvest Planner only. For those who are not comfortable with editing spreadsheets the separate Harvest Planner may work the best, this is the only one which should need rows added to the Planner sheet. For those who do not want the Harvest Planner that section is now available without the Planners. These are available for download in a .zip file with a brief tutorial in MS Word included. The tutorial may also be viewed online Farm Manager Tutorial. There is also a brief on how to update the Farm Manager written with the new unreleased HTML 5.0 which most new major browsers support. How To Update Farm Manager, if your browser does not support this there is a link provided on the page for the standard version of HTML or it can be viewed directly here How To Update Farm Manager v2.
This copy of the Farm Manager is complete with all the data available as of July 25, 2010. I upload the updated workbooks weekly along with the updates so a current version can be downloaded for new users.
Those who have a version before July 25th. will need to update their workboook. There is a link to the update below.
I have compiled all the farm data found so far on one sheet in HTML for viewing. This can also be used to make some but not all updates by manually adding the new data located at the bottom of each table That can be viewed using this link FarmVille Data Sheet.
Bugs and fixes will be posted here with information on how to make the changes. I will update the sheets when new releases to the game are introduced, between updates I will post any new data to be added as it is found, sometime this may take a few days depending on what changes have been made to the game. I will post instructions on how to update your current sheets with the new data and try to make it easy as possible
View Farm Manager Updated May 30th.
View Farm Manager without Harvest Planners
If you do not have MS Word or MS Excel the Open Office Suite provided free by Sun Technologies can open and save these documents. You can download this at Open Office
If you haven't seen the Farm Report Program it is a great companion tool for the Harvest Planners. It runs on the Java framework independently on your desktop and will let you know when your crops are ready for harvest,
Farm Report
Update 14 July 25th.
The updates to the game this week as of July 25th. are available in a single Excel sheet labeled Update 14. When you take the link to the sheet your browser should ask what you would like to do with the file. It can be opened with Excel on your PC or saved to your machine, it is your option. Once the updates have been completed the sheet will no longer be needed and can be deleted from your PC. Previous week's updates are still there if needed and the first update with some details on how to make some of the edits.
Farm Manager Update 14 July 25, 2010. The Updates have been downloaded times
Download Farm Manager Complete
Download Farm Manager without the Harvest Planners
Download the Harvest Planners Only
What's New in Farm Manager
- There is a calculator for each of the short growth crops which will calculate how many fields or cycles are needed for the short growth crops.
- There is a crop planner for each of the short growth crops which will enter the total number of fields planted for each day into the 4 Day Crop Planner.
- The summary table on the calculator sheet now shows how many experience point are earned for plowing and planting the cycle.
- All of the newest crops, trees, animals, and items are included in this version.
- Costs, returns, and summary tables for the crop planner.
- The Farm Value has been changed and will now work with Farm Cash.
- A new table for land allows for buying land with coins or farm cash.
- Ribbons are now on the Farm Info sheet so you can track what you have.
- The Ribbons table and the Neighbors Sheet have been enhanced with conditional formatting to change the colors and font weight.
This is what you can do with the Farm Manager
- Keep track of your current coins and Farm Cash.
- Track how many coins and Farm Cash you have invested in your farm
- Keep track of your experience points.
- See how many points you need to reach the next level.
- See how many coins you need to upgrade to the next size farm and what you will have left after purchasing the upgrade.
- Keep an inventory of your farm. Trees, animals, buildings, and decorations.
- Track your status for Ribbons, Collections, Crop Mastery, and Co-Op farming tasks.
- A calculator for Crop Mastery to help with planning crops. There is a calculator to see how many coins were found while plowing.
- Crop calculators for the short growth crops and a four day cycle crop planner.
- A separate planner sheet for the Limited Edition Seeds. Nes items can be added or existing enabled when they are released again.
- The harvest planner will let you know how many fields are available for planting on each day including any Limited Edition Seeds planned.
- There are tables showing costs, projected returns from the crops, and a summary table with the data.
- There is a master game data sheet with the information for the game, it can be updated and used for reference for things such as the cost of land expansion.
- The crop data and farm data are on separate sheets, the smaller versions only have those needed for each, the complete version has all.
- There is now a sheet for tracking data on your neighbors.
Bugs & Fixes
Some of the cells that need to be updated in the Farm Manager workbook without the Harvest Planners were left locked and can not be updated without first Unprotecting the sheets. There are two ways to get around this problem. The best way is to Unprotect the sheets and unlock the cell ranges listed below then Protect the sheets and save the workbook and make the updates.
The other way is to Unprotect the sheets, make the updates, Protect the sheets, and save the workbook. This is the more simple way however you will need to do this for each update. The choice is which one will work best for you.
This is only needed for workbooks downloaded before the first update was posted. Workbooks downloaded after that point will not need anything fixed. Those workbooks will have an Update date stamp on the FarmInfo sheet on the top left, if yours does not have the date stamp you will need to make the changes.
The cell ranges listed below are the ones which need to be Unlocked to allow updates to be made without Unprotecting the sheets. To do this Unprotect the sheet, select the range, and unlock the cells.
To Unprotect the sheet choose the Protection option from the Tools Menu then choose Unprotect Sheet, to Protect the sheet when done use the same method the option will change to Protect Sheet. A dialogue box will appear with the option to Password Protect the sheet, this is not necessary unless you want to. You can click OK without entering a Password and be done.
To select the range left click on the first cell then scroll down and over to the last cell, hold the Shift Key then left click the last cell. The range will become hilighted with a border around it.
To Unlock the cells you need to choose the Cells option from the Format Menu. You can use the Menu on the top of the sheet, Right click the mouse to Pop Up the Shortcut Menu and choose Format Cells, or the Hot Key Combination of the Ctrl Key and the Number 1 Key on the keyboard (press both keys at the same time) which will bring up the Format Cells Box.
Select the Protection Tab on the box then uncheck Locked and click the OK Button. If the background of the Check Mark is Gray you will need to click the box twice to clear the Locked mode for the cells. The next time you open the menu the last tab you used will be visable.
Below is the list of ranges which need the cells unlocked for editing.
GameData sheet cells BF 47 to BK 261 which is the Co-op Farming Tasks table.
FarmData sheet every table needs to have cells unlocked.
Cells A 45 to F 510
Cells O 128 to T 510
Cells AC 116 to AH 510
Cells AQ 109 to AV 510
Cells BE 367 to BJ 510
Cells BS 24 to BX 110
Cells BS 152 to BX 191
Cells CG 45 to CL 114
This may appear to be a lot of work however it should take less than 15 minutes to complete. Remember to Protect the sheets and save the workbook. Most updates will now be able to be made without unprotecting the sheets on this workbook.
Farm Manager Tips
The only values required for the harvest planner to work are the current coins available on each day for plowing and planting, and how many fields your farm has. Farm Manager does not connect to the Farm Town data information you do need to manually enter the data and keep it up to date.
To fully use the complete workbook you should inventory your farm. Once you get the first count it is easy to keep track by updating the data when you add or delete items. Here is how I go about getting a count. First I make a list of all the items then start with the trees first. I mark the list using the old concept of 4 marks and a slash to make 5.
Counting fields can make your eyes tired for sure. I placed hay bales spaced 10 fields apart along the back and 5 down the side made the count much easier.
Adding your land expansion costs, level, experience points, current coins, farm cash, and fields will enable the formulas for tracking to work. Be sure to update these as they change, I do mine at least once a day.
If you are having problems, have questions not answered here or on the tutorials, find any bugs in the formulas you can use the form below to send them to me. If you want a reply add your email address otherwise that field is optional. I am open to suggestions for any way to improve this workbook so any ideas you may have let me know.
This link will open your default Email client
Email Uncle Joe
I do keep some emails archived for reference, I do not maintain an email list. I have not nor will I ever sell email addresses. I do respect the privacy of others and try to prevent spam from growing.