tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 725081d1616520300-formula-needed-for-several-scenerios-summary-report
Sheet: Sep-20

 | Month: | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | New Credits
 | SC | SC Name | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | Total |  |  | Pre-Invoice Amounts | ECR Applied | Invoice Amts
Prior/Current | 1234 | Example Name | 0 | 0 | 7516.13 | 2015.04 | 11294.35 | 2364.01 | 1271.04 | 340.55 | 173.86 | 1001.09 | 1265.51 | 182.52 | 465.63 |  |  |  | 2360.23
Prior/Current | 2345 | Example Name | 0 | 0 | 0 |  | 1793.69 | 2002.86 | 65.53 | 62.55 | 124.65 | 77.4 | 34.86 | 33.56 | 13.66 |  |  |  | 1179.56
Prior/Current | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 72019.71 | 15395.92 | 639.64 | 158.82 | 164.17 |  |  |  | 7768.89
Prior/Current | 4567 | Example Name | 0 | 0 | 0 | 0 | 802.4 | 868.01 | 325.14 | 221.6 | 305.99 | 30.8 | 482.43 | 180.97 | 62.47 |  |  |  | 821.74
Prior/Current | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 1022.51 |  |  |  | 16474.73
Prior/Current | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 314.72 |  |  |  | 8208.96
Prior/Current | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14111.41 | 463.06 | 373.47 | 651.22 | 190.09 |  |  |  | 2178.7
Prior/Current | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 370.16 |  |  |  | 4251.79
Prior/Current | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 81393.7 | 76.31 | 67.07 | 48.32 | 29.33 |  |  |  | 1418.89
Prior/Current | 9013 | Example Name | 0 | 0 | 0 | 0 |  |  |  | 205.47 | 262.39 | 563.85 | 2676.81 | 560.99 | 354.48 |  |  |  | 2590.42
Used | 1234 | Example Name | 0 | 0 | -2360.23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 2345 | Example Name | 0 | 0 | 0 | 0 | -1179.56 | 0 | 0 | 0 | 0 | 0 | 0
Used | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -7768.89 | 0 | 0
Used | 4567 | Example Name | 0 | 0 | 0 | 0 | -802.4 | -19.34 | 0 | 0 | 0 | 0 | 0
Used | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -2178.7 | 0 | 0
Used | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1418.89 | 0 | 0
Used | 9013 | Example Name | 0 | 0 | 0 | 0 |  |  |  | -205.47 | -262.39 | -563.85 | -1558.71
Remaining/Carried Forward | 1234 | Example Name | 0 | 0
Remaining/Carried Forward | 2345 | Example Name | 0 | 0
Remaining/Carried Forward | 3456 | Example Name | 0 | 0
Remaining/Carried Forward | 4567 | Example Name | 0 | 0
Remaining/Carried Forward | 5678 | Example Name | 0 | 0
Remaining/Carried Forward | 6789 | Example Name | 0 | 0
Remaining/Carried Forward | 7890 | Example Name | 0 | 0
Remaining/Carried Forward | 8901 | Example Name | 0 | 0
Remaining/Carried Forward | 9012 | Example Name | 0 | 0
Remaining/Carried Forward | 9013 | Example Name | 0 | 0
Spreadsheet: 838187d1690808904-need-advanced-indexmatch-formula-with-specific-criteria-for-obtaining-exact-desired-result-excel-forum-help-formula
Sheet: Result

Month | Count | 2019-04-30 00:00:00 | 2019-05-31 00:00:00 | 2019-06-30 00:00:00 | 2019-07-31 00:00:00 | 2019-08-31 00:00:00 | 2019-09-30 00:00:00 | 2019-10-31 00:00:00 | Nov'19 | Dec'19 | Jan'20 | Feb'20 | Mar'20
2019-04-30 00:00:00
Nov'19
Dec'19
Jan'20
Feb'20
Mar'20
Required Result
Month | Count | 2019-04-30 00:00:00 | 2019-05-31 00:00:00 | 2019-06-30 00:00:00 | 2019-07-31 00:00:00 | 2019-08-31 00:00:00 | 2019-09-30 00:00:00 | 2019-10-31 00:00:00 | Nov'19 | Dec'19 | Jan'20 | Feb'20 | Mar'20
2019-04-30 00:00:00 | 44 | 0 | 1.5 | 0 | 1.2 | 1.1 | 7.1 | 1
 | 14 | 0 | 2.3 | 2.5 | 5.4 | 3.4 | 1.1 | - | - | - | - | - | -
 | 44 | 0 | 1.2 | 1.1 | 5.4 | 5.4 | - | - | - | - | - | - | -
 | 87 | 0 | 1.1 | 5.1 | 1.1 | - | - | - | - | - | - | - | -
 | 42 | 0 | 5.4 | 1.7 | - | - | - | - | - | - | - | - | -
 | 87 | 0 | 7.1 | - | - | - | - | - | - | - | - | - | -
 | 47 | 0 | - | - | - | - | - | - | - | - | - | - | -
Nov'19 | 50 | 0 | - | - | - | - | - | - | - | - | - | - | -
Dec'19 | 60 | 0 | - | - | - | - | - | - | - | - | - | - | -
Jan'20 | 70 | 0 | - | - | - | - | - | - | - | - | - | - | -
Feb'20 | 80 | 0 | - | - | - | - | - | - | - | - | - | - | -
Mar'20 | 90 | 0 | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: elizabeth_sager__9513__California Exposure 010119a
Sheet: Px - ISO 

RAC - Risk Assessment & Control
Exposure as of
 |  |  |  |  | Net Sales | Net Purchases |  |  | Enron's Net | CA ISO's |  | ISO
Counterparty | Enron Entity | Entity Code | Activity Month |  | (if A/R-A/P > $0) | (if A/P-A/R < $0) |  |  | Exposure | Net Exposure |  | Pmt. Date
California ISO | Enron Power Marketing, Inc. | ENA | November 2000 |  |  |  |  |  |  |  |  | 2001-02-02 00:00:00
California ISO | Enron Power Marketing, Inc. | ENA | December 2000 |  |  |  |  |  |  |  |  | 2001-03-05 00:00:00
California ISO | Enron Power Marketing, Inc. | ENA | MTD January 2001 |  |  |  |  |  |  |  |  | 2001-04-03 00:00:00
California ISO | Portland General | PGE | November 2000 |  | 7700000 |  |  |  |  |  |  | 2001-02-02 00:00:00
California ISO | Portland General | PGE | December 2000 |  | 45000000 |  |  |  |  |  |  | 2001-03-05 00:00:00
California ISO | Portland General | PGE | MTD January 2001 |  | 500000 |  |  |  |  |  |  | 2001-04-03 00:00:00
Total CA ISO
 |  |  |  |  |  |  |  |  |  |  | PX Net Purchases | PX Net Sales
 |  |  |  | Physical | Net Sales | Net Purchases |  |  | Enron's Net | CA PX's | Payment | Receipt
Counterparty | Enron Entity |  | Activity Month | Mark-to-Market | (if A/R-A/P > $0) | (if A/P-A/R < $0) |  |  | Exposure | Net Exposure | Date: | Date:
California Power Exchange Corporation | Enron Power Marketing, Inc. | ENA | November 2000 (Real Time Mkt) |  |  |  |  |  |  |  | 2001-02-01 00:00:00 | 2001-02-05 00:00:00
California Power Exchange Corporation | Enron Power Marketing, Inc. | ENA | December 2000 (Real Time Mkt) |  |  |  |  |  |  |  | 2001-03-02 00:00:00 | 2001-03-06 00:00:00
California Power Exchange Corporation | Enron Power Marketing, Inc. | ENA | December 2000 (Core Mkt) |  |  |  |  |  |  |  | 2001-01-16 00:00:00 | 2001-01-18 00:00:00
California Power Exchange Corporation | Enron Power Marketing, Inc. | ENA | December 2000 (Blk FW Mkt) |  |  |  |  |  |  |  | 2001-01-16 00:00:00 | 2001-01-18 00:00:00
California Power Exchange Corporation | Enron Power Marketing, Inc. | ENA | MTD January 2001 (Real Time Mkt) |  |  |  |  |  |  |  | 2001-04-02 00:00:00 | 2001-04-04 00:00:00
California Power Exchange Corporation | Enron Power Marketing, Inc. | ENA | MTD January 2001 (Core Mkt) |  |  |  |  |  |  |  | 2001-02-15 00:00:00 | 2001-02-20 00:00:00
California Power Exchange Corporation | Enron Power Marketing, Inc. | ENA | Existing Block FW Portfolio | -48000000 |  |  |  |  |  |  | Block forward positions out to 12/01
California Power Exchange Corporation | Portland General | PGE | December 2000 |  | 2800000 |  |  |  |  |  | 2001-01-16 00:00:00 | 2001-01-18 00:00:00
Total CA PX
 |  |  |  |  |  | ENRON |  |  | PORTLAND GENERAL |  | TOTAL
 |  |  | PCG REGULATED |  |  |  |  |  | 0
 |  |  | PCG NON-REGULATED FILING SUBS |  |  |  |  |  | 0
 |  |  | PCG EXPECTED NON-FILING SUBS |  |  |  |  |  | 0
 |  |  | EIX REGULATED
 |  |  | EIX NON-REGULATED |  |  |  |  |  | 0
 |  |  | SUBTOTAL
 |  |  | ISO
 |  |  | PX
 |  |  | SUBTOTAL
Spreadsheet: 884371d1733486200-lookup-and-match-or-similar-with-2-column-headers-example-data
Sheet: Example Data

Data
Service Area | TOTALS |  |  | Qtr 1 | Qtr 1 | Qtr 1 | Qtr 1 | Qtr 2 | Qtr 2 | Qtr 2 | Qtr 2 | Qtr 3 | Qtr 3 | Qtr 3 | Qtr 3 | Qtr 4 | Qtr 4 | Qtr 4 | Qtr 4 |  |  | Service Area | B
 | Blue | Green | TOTAL | Blue | Green | Blue & Green | Original | Blue | Green | Blue & Green | Original | Blue | Green | Blue & Green | Original | Blue | Green | Blue & Green | Original |  |  | Quarter | Blue | Green | Blue & Green | Original
A | 2764294 | 215564 | 2979858 | 904631 | 0 | 904631 |  | 676709 | 194989 | 871698 |  | 1182954 | 20575 | 1203529 |  | 0 | 0 | 0 |  |  |  | Qtr 1
B | 1463828.662 | 201120 | 1211672.662 | 431985.662 | 0 | 431985.662 | 1371000 | 419520 | 0 | 419520 | 2742000 | 612323 | 201120 | 813443 | 4113000 | 0 | 0 | 0 | 5483000 | Done |  | Qtr 2
C | 1882648 | 260851 | 2127192 | 406333 | 0 | 406333 | 866000 | 1281471 | 0 | 1281471 | 1732000 | 194844 | 260851 | 455695 | 2598000 | 0 | 0 | 0 | 3464000 | Done |  | Qtr 3
D | 109954 | 0 | 109954 | 36961 | 0 | 36961 |  | 72993 | 0 | 72993 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | Qtr 4
E | 591665 | 153796 | 613102 | 89030 | 0 | 89030 | 336000 | 227428 | 127698 | 355126 | 668000 | 275207 | 26098 | 301305 | 1002000 | 0 | 0 | 0 | 1336000 | Done
F | 955187 | 21475 | 109954 | 163513 | 0 | 163513 | 594000 | 564613 | 0 | 564613 | 1188000 | 227061 | 21475 | 248536 | 1782000 | 0 | 0 | 0 | 2375000 | Done
G | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Total | 7767576.662 | 852806 | 7151732.662 | 2032453.662 | 0 |  |  | 3242734 | 322687 |  |  | 2492389 | 530119 |  |  | 0 | 0
Example Output
A |  |  |  |  |  | B
Column1 | Blue | Green | Blue & Green | Original |  | Column1 | Blue | Green | Blue & Green | Original
Qtr 1 |  |  |  |  |  | Qtr 1
Qtr 2 |  |  |  |  |  | Qtr 2
Qtr 3 |  |  |  |  |  | Qtr 3
Qtr 4 |  |  |  |  |  | Qtr 4
Spreadsheet: 268be74f-7032-420a-9b22-e23d38695001
Sheet: V.P. of PM

 |  |  |  |  |  | Date of Reference | 2014-03-27 00:00:00
 |  |  | Sector | $ [NAME] | % Weight | [NAME] | Holdings
 |  |  | Cash
 |  |  | Bond
 |  |  | Consumer Discretionary
 |  |  | Consumer Staples
 |  |  | Energy
 |  |  | Financial
 |  |  | Healthcare
 |  |  | Industrials
 |  |  | Information Technology
 |  |  | Materials
 |  |  | Telecommunications
 |  |  | Utilities
 |  |  | Totals
 |  |  | Return Period | I.P.O. | S&P 500 | Comments
 |  |  | 1 Week
 |  |  | 1 Month
 |  |  | 3 Month
 |  |  | 6 Month
 |  |  | 1 Year
 |  |  | 2 Year
 |  |  | [NAME] | [NAME] $ [NAME] |  | [NAME] % Weight
 |  |  | Large
 |  |  | Mid
 |  |  | Small
 |  |  | Bond
 |  |  | Option
 |  |  | Cash
 |  |  | Total
Spreadsheet: 204664d1357598676-general-database-problems-to-make-it-more-user-friendly-excel-practice-hjii-oeldere-
Sheet: Sheet1

Student ID | Surname | Initial | Age | Program | Building | Classroom
ST348-245 | [NAME] | L. | 18 | English lit.
ST348-246 | Wilson | R. | 23 | Business
ST348-247 | [NAME] | J. | 18 | Chemistry
ST348-248 | Smith | K. | 20 | Chemistry
ST348-249 | [NAME] | B. | 21 | Business
ST348-250 | [NAME] | K. | 26 | Biology
ST348-251 | [NAME] | N. | 18 | Maths
ST348-252 | [NAME] | C. | 19 | English lit.
ST348-253 | Bettison | M. | 20 | English lit.
ST348-254 | Martins | J. | 22 | Physics
Spreadsheet: 3e7cad3b-e36e-4005-9c3d-617e29405aec
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 | Unnamed: 12 | Unnamed: 13
 |  |  |  |  |  |  |  |  | Forma patvirtinta [NAME] socialinės apsaugos  ir darbo ministro 2006 m. lapkričio d. įsakymu  Nr. A1-
 |  |  |  |  | _______________________________________________________________________________
 |  |  |  |  | ([NAME], įstaigos, [NAME])
 |  |  |  |  | __________________________________________________________________
 |  |  |  |  | (adresas, tel., faks.)
________________________________________
(adresatas)
Pažyma apie priskaičiuotą ir išmokėtą darbo
užmokestį bei kitas išmokas
____________ Nr. ____________
 | Darbuotojo [NAME] pavardė _______________________________________________________________
[NAME], mėnuo | Nustatyta maksimali darbo laiko trukmė, [NAME] dienų per mėnesį | Dirbtas laikas; nedirbtas laikas dėl ligos; prastovų; val. ar dienų per mėnesį; kasmetinių atostogų trukmė, dienų per mėnesį | Nemoka-mų atostogų trukmė, dienų per mėnesį | Priskaičiuota, Lt |  |  |  |  | Išskaičiuota, Lt |  |  |  | Iš viso priskaičiuota išmokėti suma, Lt
 |  |  |  |  |  |  |  |  |  |  |  |  | (14=9-13)
 |  |  |  | [NAME] užmokesčio; užmokesčio už prastovas ne dėl darbuotojo kaltės | [NAME] | už kasmetines atostogas | [NAME] (išeitinė išmoka, netekto darbingumo kompensacija, [NAME]) | Iš viso per mėnesį | pajamų mokesčio | [NAME] | [NAME] išlaikyti | Iš viso per mėnesį
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
Iš viso
____________________________                                          ______________                                                                                     _________________________
(vadovo pareigų [NAME])                                                      (parašas)                                                                                                     ([NAME] pavardė)
A.V.
Vyr. finansininkas    (Vyr. [NAME])                                        ______________                                                                                     _________________________
(parašas)                                                                                                      ([NAME] pavardė)
Spreadsheet: 688909d1596017987-fx-to-mean-average-then-remove-outliers-the-re-mean-average-and-repeat-until-two-left-average-with-extremes-removed
Sheet: Sheet1

Member | X | Y |  |  | #[NAME] values removed | 0 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 | 40 | 42 | 44 | 46 | 48 | 50 | 52 | 54 | 56 | 58 | 60 | 62 | 64 | 66 | 68
1
2
3 |  |  |  |  | X Mean
4 |  |  |  |  | Y [NAME]
5
6 |  |  |  |  | #X values used for average
7 |  |  |  |  | #Y values used for average
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
Spreadsheet: 3fc2b044-2260-463e-a66a-7b3d4b8b1635
Sheet: Sheet1

FY 2013 AEA STATE AID PAYMENTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | ORIGINAL | SEPT-FEB | PAID THROUGH | AMOUNT
 |  | BUDGET | PAYMENT | FEB | REMAINING
1 | [NAME] 1 | 12252023 | 1225203 | 7351218 | 4900805
5 | PRAIRIE LAKES AEA 8 | 12262873 | 1226292 | 7357752 | 4905121
7 | AEA 267 | 25621579 | 2562162 | 15372972 | 10248607
9 | MISSISSIPPI BEND AEA 9 | 18256425 | 1825645 | 10953870 | 7302555
10 | GRANT WOOD AEA 10 | 25694279 | 2569428 | 15416568 | 10277711
11 | HEARTLAND AEA 11 | 47311975 | 4731203 | 28387218 | 18924757
12 | NORTHWEST AEA | 15237716 | 1523774 | 9142644 | 6095072
13 | GREEN HILLS AEA 13 | 14922450 | 1492246 | 8953476 | 5968974
15 | GREAT PRAIRIE AEA 15 | 13628215 | 1362826 | 8176956 | 5451259
 |  | 185187535 | 18518779 | 111112674 | 74074861
Spreadsheet: 65548d1266273456-find-a-value-across-multiple-sheets-in-another-workbook-sales-orders_2010
Sheet: SalesNov

Expected Sales Proceeds For JANUARY 2010
 |  |  |  |  |  |  | FX | 0.9135
 | INVOICE | INVOICE DATE | CUSTOMER | PRODUCT | Quantity | PRICE        USD / MT | AMOUNT (USD) | AMOUNT (AUD)
EXPORT
 | 101106 | 2010-01-12 00:00:00 | Customer1 | Product333 | 10000 | 2 | 20000 | 21893.81499726327
 | 101107 | 2010-01-12 00:00:00 | Customer2 | Product334 | 20000 | 2 | 40000 | 43787.62999452655
 | 101108 | 2010-01-12 00:00:00 | Customer3 | Product335 | 30000 | 2 | 60000 | 65681.44499178982
 | 101109 | 2010-01-12 00:00:00 | Customer4 | Product336 | 40000 | 2 | 80000 | 87575.2599890531
 | 101110 | 2010-01-12 00:00:00 | Customer5 | Product337 | 50000 | 2 | 100000 | 109469.0749863164
 | 101111 | 2010-01-12 00:00:00 | Customer6 | Product338 | 60000 | 2 | 120000 | 131362.8899835796
 | 101112 | 2010-01-12 00:00:00 | Customer7 | Product339 | 70000 | 2 | 140000 | 153256.7049808429
 | 101113 | 2010-01-12 00:00:00 | Customer8 | Product340 | 80000 | 2 | 160000 | 175150.5199781062
 | 101114 | 2010-01-12 00:00:00 | Customer9 | Product341 | 90000 | 2 | 180000 | 197044.3349753694
DOMESTIC
Spreadsheet: 43664d1242295874-automatically-adding-tables-upload
Sheet: Championship Leaderboard

 |  | Position |  |  | Old Links | Fairhaven | Clitheroe | Lancaster | Pleasington | Fleetwood | Shaw Hill | Green Drive | Total
 |  | 1 | 8 |  | 20 | 13 | 18 | 0 | 0 | 0 | 0 | 0 | 51 |  |  |  | 20 | 38 | 51 | 51 | 51 | 51 | 51 | 51
 |  | 2 | 4 |  | 14 | 16 | 20 | 0 | 0 | 0 | 0 | 0 | 50 |  | No. of Scores to Count |  | 20 | 36 | 50 | 50 | 50 | 50 | 50 | 50
 |  | 2 | 12 |  | 16 | 18 | 16 | 0 | 0 | 0 | 0 | 0 | 50 |  | 5 |  | 18 | 34 | 50 | 50 | 50 | 50 | 50 | 50
 |  | 4 | 5 |  | 18 | 13 | 15 | 0 | 0 | 0 | 0 | 0 | 46 |  |  |  | 18 | 33 | 46 | 46 | 46 | 46 | 46 | 46
 |  | 5 | 6 |  | 0 | 20 | 15 | 0 | 0 | 0 | 0 | 0 | 35 |  |  |  | 20 | 35 | 35 | 35 | 35 | 35 | 35 | 35
 |  | 5 | 3 |  | 14 | 14 | 7 | 0 | 0 | 0 | 0 | 0 | 35 |  |  |  | 14 | 28 | 35 | 35 | 35 | 35 | 35 | 35
 |  | 5 | 1 |  | 15 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 35 |  |  |  | 15 | 25 | 35 | 35 | 35 | 35 | 35 | 35
 |  | 8 | 9 |  | 11 | 15 | 7 | 0 | 0 | 0 | 0 | 0 | 33 |  |  |  | 15 | 26 | 33 | 33 | 33 | 33 | 33 | 33
 |  | 9 | 11 |  | 10 | 7 | 15 | 0 | 0 | 0 | 0 | 0 | 32 |  |  |  | 15 | 25 | 32 | 32 | 32 | 32 | 32 | 32
 |  | 10 | 13 |  | 10 | 7 | 12 | 0 | 0 | 0 | 0 | 0 | 29 |  |  |  | 12 | 22 | 29 | 29 | 29 | 29 | 29 | 29
 |  | 11 | 7 |  | 12 | 5 | 8 | 0 | 0 | 0 | 0 | 0 | 25 |  |  |  | 12 | 20 | 25 | 25 | 25 | 25 | 25 | 25
 |  | 12 | 2 |  | 0 | 10 | 12 | 0 | 0 | 0 | 0 | 0 | 22 |  |  |  | 12 | 22 | 22 | 22 | 22 | 22 | 22 | 22
 |  | 13 | 14 |  | 0 | 8 | 9 | 0 | 0 | 0 | 0 | 0 | 17 |  |  |  | 9 | 17 | 17 | 17 | 17 | 17 | 17 | 17
 |  | 14 | 10 |  | 0 | 11 | 5 | 0 | 0 | 0 | 0 | 0 | 16 |  |  |  | 11 | 16 | 16 | 16 | 16 | 16 | 16 | 16
Spreadsheet: 720719d1614267992-formula-curve-curve
Sheet: Sheet1

Formaten | Prijzen | Min/[NAME] prijs | A | B | C
1 |  | 800 | 466.66666618517 | 0 | 10.14421338170565
2
3
4
5
6
7
8 |  | 400
9
10
11
12
13
14
15
16
17
18
19
20 |  | 200
 | Solver:
 | Set target cell: F24 (cell with [NAME]() fuction)
 | Select:Min
 | By Changing: D2:F2
Spreadsheet: 160378d1339070417-excel-2007-a-formula-calculates-a-cycle-open-and-close-same-day-an-extension-needed-different-day-spiros63_the_case_ron_v2
Sheet: Testing

 | =IF($C7="";""; IF(COUNT($G7:$H7); SUMIF($C$6:$C7;$C7;$E$6:$E7)*IF(INDEX($D$6:$D7;MATCH($C7;$C$6:$C7;0))="ã";1;-1)*(SUMIF($C$6:$C7;$C7;$G$6:$G7) -SUMIF($C$6:$C7;$C7;$F$6:$F7))-SUMIF($C$6:$C7;$C7;$H$6:$H7);""))
 | 2012-05-01 00:00:00
 | Date | Ascending Numbering | Trade  Direction | Entry                               Type | Amount                                                      € | Open                                        At | Close                                   At | Exit                                  Type | Expenses                                € | P/L                                                  €
 |  | 1 | ã | Wave Entry | 100000 | 1.31 | 1.25 | Stop Loss | 100
 |  | 2 | ä | Trend Reversal Entry | 100000 | 1.31 | 1.25 | Take Profit Level | 100
 |  | 3 | ä | Breakout Entry | 100003 | 1.31 | 1.25 | Take Profit Level | 100
 |  | 4 | ä | Wave Entry | 100000 | 1.31 | 1.25 | Take Profit Level | 100
 |  | 5 | ã | Breakout Entry | 100000 | 1.31 | 1.25 | Stop Loss | 100
 |  | 6 | ã | Trend Reversal Entry | 100001 | 1.31
 |  | 6 |  |  |  |  | 1.25 | Stop Loss | 100
 |  | 7 | ä | Wave Entry | 100000 | 1.31
 |  | 7 |  |  |  |  | 1.28 | Take Profit Level 1 | 50
 |  | 7 |  |  |  |  | 1.25 | Take Profit Level 2 | 50
Spreadsheet: 71347d1272014679-need-help-with-my-report-spreadsheet-report-spreadsheet
Sheet: Activity by Client

 | Exisiting / New client | (All)
 | Count of Id | Week
 | Client name | 10 | 11 | 12 | 13 | 14 | Grand Total
 | ABC Healthcare | 2 |  | 1 | 1 | 1 | 5
 | Audi | 1 |  | 2 | 1 |  | 4
 | [NAME] |  | 1 |  | 1 | 1 | 3
 | Bt Vision | 2 | 1 | 1 | 1 |  | 5
 | Capital One | 1 | 1 | 1 | 1 | 1 | 5
 | Care-Knight Limited | 1 | 1 | 1 | 1 |  | 4
 | [NAME] | 1 | 1 | 1 | 1 |  | 4
 | Credit Crisis |  | 1 | 1 | 1 |  | 3
 | Eurodebt Financial Services | 2 | 2 | 1 | 2 | 1 | 8
 | European Fine Wines Ltd | 1 | 2 | 1 | 2 |  | 6
 | [NAME] | 1 | 1 | 1 |  | 1 | 4
 | Guide Dogs For The Blind | 1 | 1 |  | 1 | 1 | 4
 | Help the Aged | 2 | 2 | 1 |  | 1 | 6
 | Lovefilm | 2 | 2 | 1 | 1 | 1 | 7
 | [NAME] |  | 2 |  | 1 | 1 | 4
 | Optical Express | 3 | 1 | 4 | 1 |  | 9
 | Satellite Customer Care | 2 | 2 | 1 | 1 |  | 6
 | Sports School | 2 | 2 |  | 1 | 1 | 6
 | UCI |  | 3 | 3 | 1 |  | 7
 | Grand Total | 24 | 26 | 21 | 19 | 10 | 100
 | Volume and % Contribution of activity by Client by week
 |  | Week
 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | Total
 | Data Owner | vol. | (%) | vol. | (%) | vol. | (%) | vol. | (%) | vol. | (%) | vol. | (%)
 | Total | 24 |  | 26 |  | 21 |  | 19 |  | 10 |  | 100
Spreadsheet: 1af06ba8-811f-4648-8a84-f387ec1fbfbf
Sheet: Sheet1

Australian Bureau of Statistics | Unnamed: 1 | Unnamed: 2
87310DO001_201205 Building Approvals, Australia, May 2012
Released at 11:30 am (Canberra time) [NAME] 10 Jul 2012
 | Contents
 | Tables
 | 1 | ASGS Data Items, by Statistical Area 2 (SA2)
 | 2 | ASGS Data Items, by Local Government Area (LGA) (a)
 | 3 | ASGS Data Items, by Greater Capital City Statistical Area (GCCSA), State and Australia
 | More information available from the ABS website
 | Building Approvals, Australia, May 2012
 | Summary
 | Explanatory Notes
 | Inquiries
 | For further information about these and related statistics, contact the National Information and Referral Service on 1300 135 070.
 | © Commonwealth of Australia 2012
Spreadsheet: 076651a4-9e47-4b16-b50c-d5edff10edce
Sheet: Sheet2

Analysis Date | Analysis Time | Sample ID | Salinity | Temp (˚C) | Temp (˚K) | dye volume (µl) | 596A | 435A | 750A | R | pHT | pK2 | e1 | e2 | e3
2009-11-03 00:00:00 |  | OCB-group_E-01 | 30.77 | 19.389 |  | 40 | 0.174 | 0.386 | 0.001
 |  | OCB-group_E-01 | 30.77 | 19.389 | 292.539 | 80 | 0.343 | 0.763 | -0.001
 |  | OCB-group_E-02 | 30.77 | 19.386 |  | 40 | 0.144 | 0.323 | -0.002
 |  | OCB-group_E-03 | 30.77 | 19.383 |  | 40 | 0.141 | 0.313 | 0
 |  | OCB-group_F-04 | 30.77 | 19.399 |  | 40 | 0.153 | 0.334 | 0.008
 |  | OCB-group_F-05 | 30.77 | 19.465 |  | 40 | 0.159 | 0.342 | 0.014
 |  | OCB-group_F-06 | 30.77 | 19.688 |  | 40 | 0.14 | 0.315 | 0.001
 |  | OCB-group_D-07 | 30.77 | 19.808 |  | 40 | 0.139 | 0.31 | 0.002
 |  | OCB-group_D-08 | 30.77 | 19.927 |  | 40 | 0.163 | 0.329 | 0.031
 |  | OCB-group_D-09 | 30.77 | 19.991 |  | 40 | 0.145 | 0.319 | 0.005