| Pages: [1] 2 3 4 5 6 7 8 9 10 20 |
1. WTS Complete Indy/production/Reserch/mining/invention Much Much - in Sell Orders [original thread]
Fern Slanjava, How does it feel to pass off someone else's work as your own? I have been working on the spreadsheet you described since 2005. Why should someone pay you for a spreadsheet that is free. Browse to the Ultimate EVE Excel Sheet do...
- by Fubar - at 2014.04.30 01:32:00
|
2. i need a data dump of manufacturing data, will pay for info - in Science and Industry [original thread]
You can use this list that I created for my UES spreadsheet. Blueprint, ore, ice text files <--- period files use a period as the decimal separator and the comma files use the comma as the decimal separator. Enjoy.
- by Fubar - at 2013.12.06 18:43:00
|
3. Pulling through data from eve-central - in Science and Industry [original thread]
Ezeller wrote: Hey, I am just attempting to pull some data onto a spreadsheet from eve-central using the api, I am using the following formula but not getting the same info i get if I query the database on the website, what am i doing wrong? ...
- by Fubar - at 2013.08.19 23:03:00
|
4. Googledocs API ImportXML noob question - in EVE Technology Lab [original thread]
We have two problems with this issue The Eve API returns the data in different system order for each call.
Google docs returns data in the order that if finds the solarsystemid in the XML data.
Therefore the kills per system will be in ...
- by Fubar - at 2013.08.16 16:35:00
|
5. Static DB dump, W-space anomalies - in EVE Technology Lab [original thread]
Atum wrote: LEFT JOIN [dbo].[mapLocationWormholeClasses] C ON C.locationID = A.regionID LEFT JOIN [dbo].[mapLocationWormholeClasses] D ON D.locationID = A.solarSystemID - The two LEFT JOIN statements connect the mLWC to the mSS table via either...
- by Fubar - at 2013.08.08 14:56:00
|
6. Static DB dump, W-space anomalies - in EVE Technology Lab [original thread]
I think this query is what you are looking for. Quote: SELECT A.[solarSystemName] ,A.[solarSystemID] ,A.[constellationID] ,A.[x] ,A.[y] ,A.[z] ,SUM(CASE WHEN B.[groupID] = 7 THEN 1 ELSE 0 END) as [planets] ,SUM(CASE WHEN B.[groupID] = 8 THEN 1...
- by Fubar - at 2013.08.08 14:00:00
|
7. Static DB dump, W-space anomalies - in EVE Technology Lab [original thread]
Quote: Now before I added the underlinged segment, it was just another ",0 as [Zero_2]" and things were fine. Now that I've added that CASE statement, I get the message Msg 8120, Level 16, State 1, Line 12 Column 'dbo.mapDenormalize.typeID' i...
- by Fubar - at 2013.08.08 01:47:00
|
8. How to pull personal assets - in EVE Technology Lab [original thread]
You need to specify the container ID in importXML. For example... =ImportXML("https://api.eveonline.com/char/AssetList.xml.aspx?vcode=52yDxAC0VbzztL8ULRWMI66gOSvQlS3YS1CxahGCRwjse9RmvtQicjCLEjVaPRVo&keyid=2432885","sum((//row[@locationid=60...
- by Fubar - at 2013.07.31 18:59:00
|
9. Problem retrieving Data from Eve-Central into Excel 2010 - in EVE Technology Lab [original thread]
White Star Research wrote: So what changed to make this statement to break the call ? Could of changed when they enabled CORS for all of the APIs. But I don't know for certain.
- by Fubar - at 2013.02.07 03:15:00
|
10. Eve Central marketstat API bugged - in EVE Technology Lab [original thread]
hours= looks at the Reported Time to determine filtering. So if you are looking at one region the reported times would all be the same. This filter does not go back into time it only looks at the last reported time per item per region. What th...
- by Fubar - at 2013.02.07 03:12:00
|
11. Problem retrieving Data from Eve-Central into Excel 2010 - in EVE Technology Lab [original thread]
Lorellei Blackmoon wrote: It is a hunch, since I am at work and cannot test it myself, but try to change the line: Call xmlHttp.Open("POST", xmlUrl, False) to Call xmlHttp.Open("GET", xmlUrl, False) and see if it works. It seems like Excel is...
- by Fubar - at 2013.02.06 19:57:00
|
12. Openoffice Calc Spreadsheet - import market prices? - in EVE Technology Lab [original thread]
See the EVE-Central Tips and Tricks
- by Fubar - at 2011.12.20 15:53:00
|
13. Tech help - excel 2010 + contracts.xml + dates - in EVE Technology Lab [original thread]
The following should work... Quote: =sumifs('My Contracts'!W:W, 'My Contracts'!V:V,">"& 'Sheet1'!A1,'My Contracts'!V:V,"<="& 'Sheet1'!A2) You need to combine (concatenate) the greater than and the less than or equal signs (no...
- by Fubar - at 2011.09.27 01:55:00
|
14. Predict the winner of Outbreak vs HYDRA RELOADED - in EVE Alliance Tournament Discussion [original thread]
HYDRA RELOADED
- by Fubar - at 2011.06.19 20:48:00
|
15. Predict the winner of HYDRA RELOADED vs. RAZOR Alliance - in EVE Alliance Tournament Discussion [original thread]
HYDRA RELOADED
- by Fubar - at 2011.06.19 20:00:00
|
16. Predict the winner of Darkside vs. Outbreak - in EVE Alliance Tournament Discussion [original thread]
Darkside
- by Fubar - at 2011.06.19 19:15:00
|
17. Predict the winner of Paisti Syndicate vs. HYDRA RELOADED - in EVE Alliance Tournament Discussion [original thread]
Paisti Syndicate
- by Fubar - at 2011.06.19 18:40:00
|
18. Predict the winner of Perihelion Alliance vs. DarkSide - in EVE Alliance Tournament Discussion [original thread]
Perihelion Alliance
- by Fubar - at 2011.06.19 17:42:00
|
19. Predict the winner of SOLAR FLEET vs. RAZOR Alliance - in EVE Alliance Tournament Discussion [original thread]
RAZOR Alliance
- by Fubar - at 2011.06.19 16:58:00
|
20. Predict the winner of Negative Ten vs. HYDRA RELOADED - in EVE Alliance Tournament Discussion [original thread]
Negative Ten
- by Fubar - at 2011.06.19 16:10:00
|
| Pages: [1] 2 3 4 5 6 7 8 9 10 20 |
| First page | Previous page | Next page | Last page |