tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 726511d1617282128-sum-if-issue-question-excel-new-1-april
Sheet: Blad1

 | Verkoopprijs |  |  |  |  |  |  |  |  | Inkoopprijs
Cat | Service | Aantal | Prijs per stuk ex. Btw | Prijs per stuk incl. Btw | BTW % | Totaal bedrag exclusief BTW | BTW bedrag | Totaal bedrag inclusief btw |  | Service | Aantal | Prijs per stuk ex. Btw | Prijs per stuk incl. Btw | BTW % | Totaal bedrag exclusief BTW | BTW bedrag | Totaal bedrag inclusief btw
Food | 3-gangen menu | 5 | 91.74311926605503 | 100 | 0.09 | 458.7155963302752 | 41.28440366972484 | 500 |  | 3-gangen menu | 5 | 87.15596330275228 | 95 | 0.09 | 435.7798165137614 | 475
Drank | Wijn | 10 | 41.32231404958678 | 50 | 0.21 | 413.2231404958678 | 86.7768595041322 | 500 |  | Wijn | 10 | 37.1900826446281 | 45 | 0.21 | 371.900826446281 | 450
Bezorging | [NAME] | 60 | 10 | 12.1 | 0.21 | 600 | 126 | 726 |  | [NAME] | 60 | 0 | 0 | 0.21 | 0 | 0
Commissie | Bezorgingskosten Randstad | 40 | 12 | 14.52 | 0.21 | 480 | 100.8 | 580.8 |  | Bezorgingskosten Randstad | 40 | 0 | 0 | 0.21 | 0 | 0
Giftcard | Giftcard | 10 | 100 | 100 | 0 | 1000 | 0 | 1000 |  | Giftcard | 10 | 0 | 0 | 0 | 0 | 0
Drank | Wijn | 10 | 82.64462809917356 | 100 | 0.21 | 826.4462809917356 | 173.5537190082644 | 1000 |  | Wijn | 10 | 74.3801652892562 | 90 | 0.21 | 743.801652892562 | 900
Overige | Services | 10 | 17.5 | 21.175 | 0.21 | 175 | 36.75000000000001 | 211.75 |  | Services | 10 | 14.46280991735537 | 17.5 | 0.21 | 144.6280991735537 | 175
 | Totale kosten |  |  |  |  | 3953.385017817879 | 565.1649821821213 | 4518.55 |  | Totale kosten |  |  |  |  | 1696.110395026158 | 2000
 |  |  |  |  |  |  |  |  |  | Marge analyse
 |  |  |  |  |  |  |  |  |  | Categorie | verkoopprijs ex. | inkoopprijs ex. | absolute marge | marge %
 |  |  |  |  |  |  |  |  |  | Food | 458.7155963302752 | 435.7798165137614 | 22.93577981651373 | 0.05263157894736836
 |  |  |  |  |  |  |  |  |  | Bezorging | 600 | 0 | 600 | nvt
 |  |  |  |  |  |  |  |  |  | Commissie | 826.4462809917356 | 0 | 826.4462809917356 | nvt
 |  |  |  |  |  |  |  |  |  | Giftcard | 1000 | 0 | 1000 | nvt
 |  |  |  |  |  |  |  |  |  | Overige | 175 | 144.6280991735537 | 30.37190082644628 | 0.21
 |  |  |  |  |  |  |  |  |  | Drank | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | Totaal | 3060.161877322011 | 580.4079156873152 | 2479.753961634696
Spreadsheet: 0d2c19e6-0dcf-4f34-8d49-8ef0822970df
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FGARG | Test | FGARG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr.  			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FGARG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FGARG | Result | FGARG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 888965d1739620056-automatically-entering-amount-as-dates-passed-test
Sheet: Sheet1

TUESDAY PAYMENT
 | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5 | TOTAL
AUG | 100 | 100 | 100 | 100
SEP | 100 | 100 | 100 | 100
OCT | 100 | 100 | 100 | 100 | 100
NOV | 100 | 100 | 100 | 100 | 100
DEC | 100 | 100 | 100 | 100 | 100
JAN | 100 | 100 | 100 | 100
FEB | 100 | 100
MAR
GRAND TOTALS
RESULT USING FORMULA =(ROUNDDOWN((TODAY()-"06/08/2024")/7,0)*221.2)
DIFFERENCE BETWEEN FORMULA AND ACTUAL
Spreadsheet: 648633d1573138682-power-bi-get-rate-based-on-category-and-date-xlf_1295591
Sheet: Sheet1

Date | Category | Amt |  | Date | Category | Rate |  | [NAME] |  |  |  |  |  |  | Want to find group of Alpha/Bravo/Charlie
2018-07-01 00:00:00 | Alpha | 6 |  | 2018-01-01 00:00:00 | Alpha | 0.2 |  | Date | Category | Amt | [NAME] | Multiply | Sum |  | Average | 2018-07-01 00:00:00
2018-07-01 00:00:00 | Bravo | 17 |  | 2018-01-01 00:00:00 | Bravo | 0.1 |  | 2018-07-01 00:00:00 | Alpha | 6 |  |  |  |  | Average | 2019-02-01 00:00:00
2018-07-01 00:00:00 | [NAME] | 8 |  | 2018-01-01 00:00:00 | [NAME] | 0.18 |  | 2018-07-01 00:00:00 | Bravo | 17
2018-07-01 00:00:00 | Delta | 13 |  | 2018-01-01 00:00:00 | Delta | 0.12 |  | 2018-07-01 00:00:00 | [NAME] | 8 |  |  |  |  |  | Date | DailyAverage ABC
2018-07-01 00:00:00 | Echo | 18 |  | 2018-01-01 00:00:00 | Echo | 0.12 |  | 2018-07-01 00:00:00 | Delta | 13 |  |  |  |  |  | 2018-07 | 3.5
2018-07-02 00:00:00 | Alpha | 4 |  | 2018-12-14 00:00:00 | Alpha | 0.22 |  | 2018-07-01 00:00:00 | Echo | 18 |  |  |  |  |  | 2019-02 | 5.5
2018-07-02 00:00:00 | Bravo | 15 |  | 2019-02-08 00:00:00 | Delta | 0.1 |  | 2018-07-02 00:00:00 | Alpha | 4
2018-07-02 00:00:00 | [NAME] | 2 |  |  |  |  |  | 2018-07-02 00:00:00 | Bravo | 15
2018-07-02 00:00:00 | Delta | 13 |  |  |  |  |  | 2018-07-02 00:00:00 | [NAME] | 2
2018-07-02 00:00:00 | Echo | 6 |  |  |  |  |  | 2018-07-02 00:00:00 | Delta | 13
2019-02-01 00:00:00 | Alpha | 13 |  |  |  |  |  | 2018-07-02 00:00:00 | Echo | 6
2019-02-01 00:00:00 | Bravo | 3 |  |  |  |  |  | 2019-02-01 00:00:00 | Alpha | 13
2019-02-01 00:00:00 | [NAME] | 16 |  |  |  |  |  | 2019-02-01 00:00:00 | Bravo | 3
2019-02-01 00:00:00 | Delta | 5 |  |  |  |  |  | 2019-02-01 00:00:00 | [NAME] | 16
2019-02-01 00:00:00 | Echo | 13 |  |  |  |  |  | 2019-02-01 00:00:00 | Delta | 5
2019-02-08 00:00:00 | Alpha | 7 |  |  |  |  |  | 2019-02-01 00:00:00 | Echo | 13
2019-02-08 00:00:00 | Bravo | 18 |  |  |  |  |  | 2019-02-08 00:00:00 | Alpha | 7
2019-02-08 00:00:00 | [NAME] | 9 |  |  |  |  |  | 2019-02-08 00:00:00 | Bravo | 18
2019-02-08 00:00:00 | Delta | 17 |  |  |  |  |  | 2019-02-08 00:00:00 | [NAME] | 9
2019-02-08 00:00:00 | Echo | 2 |  |  |  |  |  | 2019-02-08 00:00:00 | Delta | 17
 |  |  |  |  |  |  |  | 2019-02-08 00:00:00 | Echo | 2
Spreadsheet: 81097d1281367301-excel-2007-add-only-certain-cells-in-column-budget
Sheet: FUNDING

PROJECT | FUNDING | SPENT | BALANCE
CO | 4000 |  | 4000
DECK | 50000 |  | 50000
PPE | 30000 |  | 30000
AUX | 500 |  | 500
ENG | 55000 |  | 55000
HAZ | 2000 |  | 2000
TRAINING | 5000 |  | 5000
MAA | 5000 |  | 5000
ADMIN | 500 |  | 500
SUPPLY | 5000 |  | 5000
TRAVEL | 3000 |  | 3000
BUILDING MAINT | 30000 |  | 30000
GALLEY | 1000 |  | 1000
FISHERS ISL | 1000 |  | 1000
LE | 15000 |  | 15000
TOTAL | 207000 |  | 207000
Spreadsheet: 804618d1668185032-i-need-a-formula-for-an-avg-of-a-data-set-found-on-multiple-sheets-but-must-exclude-zeroes-dans-driver-list-dz081699-
Sheet: 799

First | Last | 4 week Score Avg | 4 week Incident per [NAME] | Week 41 Score | Week 41 Incidents Per Mile | Week 42 Score | Week 42 Incidents Per Mile | Week 43 Score | Week 43 Incidents Per Mile | Week 44 Score | Week 44 Incidents Per Mile
[NAME] | Delaney |  |  | 89 | 2.93 | 87 | 1.61 | 93 | 2.27 | 94 | 1.74
[NAME] | [NAME] |  |  | n/a | n/a | n/a | n/a | n/a | n/a | 95 | 1.87
Asia | Kimmons |  |  | 88 | 1.17 | n/a | n/a | 86 | 2.05 | 91 | 1.64
[NAME] | Zurita |  |  | 98 | 0.52 | 98 | 0.47 | 98 | 0.53 | 99 | 0.31
 | Store Average
Spreadsheet: 835825d1688873661-what-formula-for-investment-compound-interest-calculation-with-dividend-reinvested-compound-interest-with-dividends-reinvested
Sheet: Sheet1

Interest Rate | 0.05 | Term (years) | 20 | Periods per Year | 1
Symbol | Name | Current Dividend Yield % | Market Value | Value in 20 Years | Value in 20 Years with dividends reinvested
TD.TO | TORONTO-DOMINION BANK | 0.046 | 855.61
TD.TO | TORONTO-DOMINION BANK | 0.046 | 855.61
Spreadsheet: 874804d1721316391-combining-text-using-text-to-extract-data-and-apply-formula-bench-reduction
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 |  | 6 |  | 7 | 8 | 9
 | STATION | + | HI | - | ELEV |  | DIFF |  | STA TO STA | DIFF (B - A) | TURNS
 | 111 |  |  |  | 20 |  | B – A
 |  | 3.743 |  |  |  |  |  |  | 111-110 | -1.271 | 1
 | 110 |  |  | 5.014 |  |  |  |  | 110-701 | -4.962 | 2
 |  | 1.056 |  |  |  |  |  |  | 701-702 | -9.323 | 4
 | TP A |  |  | 5.269 |  |  |  |  | 702-703 | 5.863 | 3
 |  | 4.252 |  |  |  |  |  |  | 703-111 | 9.67 | 2
 | 701 |  |  | 5.001 |  |  | -4.962
 |  | 4.138
 | TP B |  |  | 5.008
 |  | 4.213 |  |  |  |  |  |  | 1. I HAVE DATA IN COLUMNS 1 THROUGH 5.
 | TP C |  |  | 5.261 |  |  |  |  | 2. I NEED STATION NUMBERS FROM COLUMN 1 COMBINED, IGNORING "TP" POINTS. SEE COLUMN 7
 |  | 2.669 |  |  |  |  |  |  | 3. I NEED ACCUMULATED DIFF OF SECOND POINT ELEV MINUS FIRST POINT ELEV IN COLUMN 5, IGNORING "TP" POINTS. SEE COLUMN 6 AND 8
 | TP D |  |  | 6.407 |  |  |  |  | 4. I NEED A COUNT OF "TP" POINTS +1 IN COLUMN 1, FROM LAST DIFF TO NEW DIFF. COLUMN 9
 |  | 1.364
 | 702 |  |  | 5.031 |  |  | -9.323
 |  | 3.334
 | TP E |  |  | 1.627
 |  | 3.462
 | TP F |  |  | 4.627
 |  | 5.462
 | 703 |  |  | 0.141 |  |  | 5.863
 |  | 5.462
 | TP G |  |  | 0.627
 |  | 5.462
 | 111 |  |  | 0.627 |  |  | 9.67
 |  |  |  |  | 20
 |  |  |  | CLOSURE
Spreadsheet: 753644d1635602878-help-to-create-an-order-list-based-on-products-by-cheapest-supplier-price-comparison-t8
Sheet: TA 

Product | Supplier | Price | Quantity | Unit Price | Date | % change | Notes | PRODUCT | ABPAC | BAKO | Catering 24 | Cheapest | From | Saving | x50 bought
10" Greaseproof bag | ABPAC | 16.82 | 1000 |  |  |  |  | 10" Greaseproof bag |  |  |  |  |  |  |  |  |  | 12oz compostable d/w cup |  |  |  |  | BAKO
10" Greaseproof bag | BAKO | 8.12 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12oz compostable lid |  |  |  |  | Bonds Packaging
10" Greaseproof bag | Catering 24 | 19.02 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7" Greaseproof bag |  |  |  |  | Catering 24
12oz compostable d/w cup | Catering 24 | 45.54 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8oz compostable d/w cup |  |  |  |  | Enviropack
12oz compostable d/w cup | Next Day Coffee | 43.19 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8oz compostable lid |  |  |  |  | Enviropack 4+
12oz compostable d/w cup | [NAME] | 53.1 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nesting Tray |  |  |  |  | Enviropack 5+
12oz compostable lid | Catering 24 | 53.99 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. 1 [NAME] |  |  |  |  | Next Day Coffee
12oz compostable lid | Next Day Coffee | 29.75 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. 3 [NAME] |  |  |  |  | [NAME]
12oz compostable lid | [NAME] | 54.84 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Perforated Film Front [NAME] bag
7" Greaseproof bag | ABPAC | 10.28 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOS Carrier Bag
7" Greaseproof bag | BAKO | 6.88 | 1000
7" Greaseproof bag | Catering 24 | 9.77 | 1000
8oz compostable d/w cup | Catering 24 | 38.34 | 500
8oz compostable d/w cup | Next Day Coffee | 38.39 | 500
8oz compostable d/w cup | [NAME] | 43.56 | 500
8oz compostable lid | Catering 24 | 59.34 | 1000
8oz compostable lid | Next Day Coffee | 25.19 | 500
8oz compostable lid | [NAME] | 45.35 | 1000
Nesting Tray | ABPAC | 32.74 | 500
Nesting Tray | Bonds Packaging | 21.12 | 220
No. 1 [NAME] | Catering 24 | 56.99 | 450
No. 1 [NAME] | Enviropack | 59.94 | 450
No. 1 [NAME] | Enviropack 4+ | 56.39 | 450
No. 3 [NAME] | Catering 24 | 42.24 | 180
No. 3 [NAME] | Enviropack | 44.34 | 180
No. 3 [NAME] | Enviropack 4+ | 41.99 | 180
Perforated Film Front [NAME] bag | Enviropack | 36.54 | 1000
Perforated Film Front [NAME] bag | Enviropack 5+ | 33.59 | 1000
Perforated Film Front [NAME] bag | Next Day Coffee | 39.59 | 1000
SOS Carrier Bag | Catering 24 | 21.59 | 250
SOS Carrier Bag | Enviropack | 21.59 | 250
SOS Carrier Bag | Enviropack 5+ | 19.79 | 250
10" Greaseproof bag | ABPAC | 15
Spreadsheet: 60136d1260676250-solved-vlookup-adambudget2009-1-
Sheet: CurrentPayCheck

Categories | Pay Check | Date | Finger Print | Item Name | Tags | Tag Amount | Bank Amount | Comments | Expense Categories | Tags
 |  |  |  |  |  |  |  |  | Blank | Blank
 | 1301
Gifts | Left Over |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | Total Category Amount | Total Tag Amount
 |  |  |  |  |  |  |  |  | Total Budgeted Amount | Filter
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Left Over
Spreadsheet: b3a295d5-b94a-43d8-9770-a62672a3af4c
Sheet: Women

1st qaurter - Jan - Mar |  |  | WOMENS
TEAM |  | HOMETOWN | TOURNY'S | WINS | LOSES | PTS
DECUSES |  | OVIEDO | 2 | 8 | 1 | 63
ENVY |  | ORLANDO | 1 | 2 | 2 | 38
SWEET SPOT |  | ORLANDO | 2 | 2 | 7 | 38
SIMPLY SINFUL |  | PT ST LUCIE | 1 | 1 | 3 | 32
HEAT RELOADED |  |  | 1 | 2 | 2 | 10
LADY ANGELS |  |  | 1 | 2 | 2 | 9
CHERRY BOMBERS |  |  | 1 | 2 | 2 | 8
2nd Quarter - Apr - June |  |  | WOMENS
TEAM |  | HOMETOWN | TOURNY'S | WINS | LOSES | PTS
DECUSES |  | OVIEDO | 2 | 8 | 1 | 63
ENVY |  | ORLANDO | 1 | 2 | 2 | 38
SWEET SPOT |  | ORLANDO | 2 | 2 | 7 | 38
SIMPLY SINFUL |  | PT ST LUCIE | 1 | 1 | 3 | 32
HEAT RELOADED |  |  | 1 | 2 | 2 | 10
LADY ANGELS |  |  | 1 | 2 | 2 | 9
CHERRY BOMBERS |  |  | 1 | 2 | 2 | 8
Spreadsheet: 794572d1662123850-double-if-with-word-search-vlookup-first-7-letters-hd
Sheet: Sheet1

CAVILING |  | APADANA |  | Find out words where S is the last letter , take seven letters of the eight look up into 7 letter words , if you dont find it plug Y
GRACILIS |  | ATALAYA
MICATING |  | ARAWANA
ISOGAMIC |  | ARAARAS
SIGMATIC |  | ATAATAS
TESTTESS |  | TESTTES
Spreadsheet: tracy_geaccone__40534__NNGOrgPLFormatCORP02
Sheet: EquityAffiliates

DETAIL of EQUITY (EARNINGS)/LOSSES & EQUITY/PARTNERSHIP DISTRIBUTIONS
(Millions of Dollars)
 |  | 2002 Activities
 |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Total
Equity (Earnings)/Losses
[NAME] |  | -0.3 |  | -0.3 |  | -0.3 |  | -0.3 |  | -0.3 |  | -0.8 |  | -0.8 |  | -0.7 |  | -0.7 |  | -0.7 |  | -0.7 |  | -0.7
Other |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Miscellaneous
Total (line 97)
Equity/Partnership Distributions
[NAME] |  | 0 |  | 0 |  | 0.9 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
- Incremental (Special) |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
[NAME] |  | 0 |  | 0 |  | 0 |  | 0 |  | -4.5 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Miscellaneous
Total (line 98)
Net Equity Earnings/Distributions
Spreadsheet: 175732d1345632331-ignore-blank-cells-copy-of-ignore-blank-cells-1
Sheet: Data Sheet

Cost of Sale | Hours | Amount | FICA | Medicare | FUTA | SUTA - 3.2% plus Interest  @ $12.12 Each Employee over $13,000 | Group Ins @  % of Cost | W/C | Total
Cost of Sale | 45 |  |  |  |  |  | 75
Marketing
Repair | 45 |  |  |  |  |  | 75
Utility
Total
Spreadsheet: 28185c7d-125a-41a8-a2b2-4cb308d6068f
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40839501 | 2014-04-04 18:08:56 | AXIS | 1 | 6 | 5 | 1360620 | Factotem | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
40839841 | 2014-04-04 18:31:16 | ALLIES | 1 | 6 | 2 | 1360620 | Factotem | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
40840106 | 2014-04-04 18:52:03 | AXIS | 0 | 4 | 5 | 29736 | suggs | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
40840377 | 2014-04-04 19:10:43 | ALLIES | 0 | 3 | 5 | 29736 | suggs | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
41019076 | 2014-04-16 19:26:40 | AXIS | 1 | 4 | 0 | 1559370 | claus-gammlegaadr | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
41019351 | 2014-04-16 19:54:15 | ALLIES | 0 | 6 | 7 | 681429 | Caverne | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
41019718 | 2014-04-16 20:11:39 | AXIS | 1 | 7 | 2 | 681429 | Caverne | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
41032452 | 2014-04-17 18:19:08 | ALLIES | 0 | 3 | 7 | 1228101 | player1228101 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
41032903 | 2014-04-17 19:10:05 | ALLIES | 1 | 7 | 2 | 1559823 | player1559823 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
41033244 | 2014-04-17 19:32:41 | ALLIES | 1 | 7 | 0 | 1559823 | player1559823 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
Spreadsheet: eric_saibi__9904__Market briefs
Sheet: Sheet1

Market Briefs | Thursday, October 25
Stocks | Close | Change | % Change
DJIA | 9462.9 | 117.2799999999988 | 0.01254919416796305
DJ 15 Util. | 298.31 | 6.06 | 0.02073567151411464
NASDAQ | 1775.47 | 43.93000000000006 | 0.0253704794575927
S&P 500 | 1099.29 | 14.87999999999988 | 0.01372174730959681
Market Vols | Close | Change | % Change
AMEX (000) | 193551 | 50268 | 0.3508301752475869
NASDAQ (000) | 2267926 | 378661 | 0.2004276795473372
NYSE (000) | 1370258 | 31158 | 0.02326786647748488
Commodities | Close | Change | % Change
Crude Oil (Dec) | 21.93 | -0.3300000000000018 | -0.01482479784366585
Heating Oil (Nov) | 0.6295 | -0.01 | -0.01563721657544959
Nat. Gas (Henry) | 2.95 | -0.14 | -0.04530744336569569
Propane (Nov) | 39.3 | -0.2000000000000028 | -0.005063291139240578
Palo Verde (Nov) | 27.25 | 0 | 0
COB (Nov) | 29 | 0 | 0
PJM (Nov) | 28.8 | 1.5 | 0.05494505494505494
Dollar US $ | Close | Change | % Change
Australia $ | 1.983 | 0.01400000000000001 | 0.007110208227526669
Canada $ | 1.574 | -0.0009999999999998899 | -0.000634920634920565
Germany Dmark | 2.186 | -0.003000000000000114 | -0.001370488807674789
Euro | 0.8924 | -0.00109999999999999 | -0.001231113598209278
Japan ¥en | 122.8 | -0.1000000000000085 | -0.0008136696501221198
Mexico NP | 9.25 | 0.01999999999999957 | 0.002166847237269726
[NAME] | 0.6989 | -0.001000000000000001 | -0.001428775539362768
Foreign Indices | Close | Change | % Change
Arg MerVal | 245.79 | -0.8200000000000216 | -0.003325088195936992
[NAME]. | 3189.1 | 7 | 0.00219980516011439
[NAME] | 11723.75 | 256.01 | 0.02232436382408393
Can TSE 300 | 6943.69 | 46.79 | 0.00678420739752642
Germany DAX | 4715.6 | -92.69999999999982 | -0.01927916311378238
[NAME] | 10243.46 | 0 | 0
Japan Nikkei 225 | 10880.1 | 77.95000000000073 | 0.007216156043010024
[NAME] | 5729.13 | 20.85000000000036 | 0.003652588870903383
UK FTSE 100 | 5086.6 | -81 | -0.01567458781639446
Source:  Yahoo! & TradingDay.com
Spreadsheet: 73930d1274467309-averageif-function-scorecard-data-pivot
Sheet: Pivot

Type | (All)
Row Labels | Average of Overall Scorecard average | Average of Resource Preparedness | Average of Risk Mitigation | Average of Scalability Result | Average of Simplification
adCenter Desktop | 3.86 | 3.67 | 4 | 3.82 | 4
[NAME] | 4.21 | 4.16 | 4.25 | #[NAME]! | #[NAME]!
ARM Partner Integrated Tracking Support Model | 2.75 | 2.58 | #[NAME]! | 3 | 2.66
Image Ads | 3.65 | 3.75 | 3.98 | 3.13 | 3.75
[NAME] | 4.28 | 4.38 | 4.67 | 4.17 | 4
Mobile Display CPC Launch | 3.76 | 3.69 | 4 | 3.75 | 3.58
Personal Expression Workaround | 3.9 | 4.16 | 4 | 3.5 | 3.92
[NAME] Entertainment | 3.73 | 3.86 | 4.4 | 3.45 | 3.42
San Jose & AdECN | 4.22 | 4.36 | 4.5 | 4.33 | 3.58
SMB V1 | 3.93 | 3.83 | 4.25 | 3.63 | 4
Tier 3 Growth Migration to SMB | 4.21 | 4.05 | 4.67 | 4.13 | 4.08
[NAME] | 3.71 | 3.83 | 4 | 3 | 4
Grand Total | 3.850833333333334 | 3.859999999999999 | 4.247272727272727 | 3.628181818181818 | 3.726363636363637
 |  |  | Columns like D, E, F here all contain #[NAME]!. I need the average of these colums in row 16  to only compute against the fields that contain numeric values.
Spreadsheet: 1c9224db-1374-4c3c-be35-bc0aa210c6aa
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 50. PERSONAL FINANCE COMMITMENTS, Summary: Australia ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Fixed loans ; |  |  | Original | A2414192W | 1975-10-01 00:00:00 | 2009-12-01 00:00:00 | 411 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Original | A2414193X | 1975-10-01 00:00:00 | 2009-12-01 00:00:00 | 411 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414194A | 1975-10-01 00:00:00 | 2009-12-01 00:00:00 | 411 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Seasonally Adjusted | A2414189J | 1975-10-01 00:00:00 | 2009-12-01 00:00:00 | 411 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Seasonally Adjusted | A2414190T | 1975-10-01 00:00:00 | 2009-12-01 00:00:00 | 411 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Seasonally Adjusted | A2414191V | 1975-10-01 00:00:00 | 2009-12-01 00:00:00 | 411 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Trend | A2414186A | 1975-10-01 00:00:00 | 2009-12-01 00:00:00 | 411 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Trend | A2414187C | 1975-10-01 00:00:00 | 2009-12-01 00:00:00 | 411 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Trend | A2414188F | 1975-10-01 00:00:00 | 2009-12-01 00:00:00 | 411 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 855719d1705245892-help-to-find-latest-previous-related-value-book1-1-1-
Sheet: Sheet1

7
No. | Name | Point
1 | [NAME] | 10
2 | [NAME] | 8
3 | [NAME] | 6
4 |  | 10
5 | [NAME] | 7
6 | [NAME] | 6
7 | [NAME] | 10
Spreadsheet: e1277731-502b-40c9-bdea-338fb929350a
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40852657 | 2014-04-05 14:29:29 | ALLIES | 1 | 6 | 4 | 325246 | sbluerock | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
40876394 | 2014-04-06 22:33:18 | AXIS | 0 | 5 | 6 | 1345830 | player1345830 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
40940764 | 2014-04-11 14:02:26 | ALLIES | 1 | 6 | 3 | 1444429 | michelecannone | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
40941221 | 2014-04-11 14:58:11 | ALLIES | 1 | 6 | 4 | 1553688 | Sturmtiger1944 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
40973081 | 2014-04-13 17:47:38 | AXIS | 1 | 6 | 2 | 1074141 | mussopimpin132 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]