tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 758181d1638724216-vlookup-across-multiple-sheets-kod195-129-commercial-road
Sheet: V (19)

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Instructed
 |  | Variations |  |  |  |  |  |  |  |  |  |  |  | Cost Provided
Item | Column2 | Description | Qty | Unit | Rate | Extension |  |  |  |  |  |  |  | Subcontractor Only |  |  |  |  |  |  | Column1 | Column2 | Column3 | Column4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cancelled
 | Variations
Item | Description |  | Qty | Unit | Rate | Extension
 |  |  |  |  |  |  |  | HOME TO VARIATIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBCONTRACTOR OUTPUT SECTION |  |  | [NAME] CONSTRIUCTION SECTION
Item | Description |  | Qty | Unit | Rate | Extension |  | Subcontractor | Status | Rate | Extension | Margin % | Margin £/p | Provided | Sub Only | Instructed | Provided | Sub Only | Instructed
Note
V
*
19.01
19.02
19.03
19.04 |  |  |  |  |  |  |  |  |  | 0
19.05 |  |  |  |  |  |  |  |  |  | 0
19.06 |  |  |  |  |  |  |  |  |  | 0
19.07 |  |  |  |  |  |  |  |  |  | 0
19.08 |  |  |  |  |  |  |  |  |  | 0
19.09 |  |  |  |  |  |  |  |  |  | 0
19.1 |  |  |  |  |  |  |  |  |  | 0
19.11 |  |  |  |  |  |  |  |  |  | 0
19.12 |  |  |  |  |  |  |  |  |  | 0
19.13 |  |  |  |  |  |  |  |  |  | 0
19.14 |  |  |  |  |  |  |  |  |  | 0
19.15 |  |  |  |  |  |  |  |  |  | 0
19.16 |  |  |  |  |  |  |  |  |  | 0
19.17 |  |  |  |  |  |  |  |  |  | 0
19.18 |  |  |  |  |  |  |  |  |  | 0
19.19 |  |  |  |  |  |  |  |  |  | 0
19.2 |  |  |  |  |  |  |  |  |  | 0
19.21 |  |  |  |  |  |  |  |  |  | 0
19.22 |  |  |  |  |  |  |  |  |  | 0
19.23 |  |  |  |  |  |  |  |  |  | 0
19.24 |  |  |  |  |  |  |  |  |  | 0
19.25 |  |  |  |  |  |  |  |  |  | 0
19.26 |  |  |  |  |  |  |  |  |  | 0
19.2699999999999 |  |  |  |  |  |  |  |  |  | 0
19.2799999999999 |  |  |  |  |  |  |  |  |  | 0
19.2899999999999 |  |  |  |  |  |  |  |  |  | 0
19.2999999999999 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | To Collection
Spreadsheet: 75627d1276175245-match-betweeen-two-lists-match
Sheet: Sheet1

 | Ranking
Consultant | Monthly Average (Excl Saturday) |  | Consultant | Sales
[NAME] | 12 |  | [NAME] | 74
Bridget Mohale | 11.86 |  | [NAME] | 88
[NAME] | 11.86 |  | [NAME] | 60
[NAME] | 11.71 |  | Bridget Mohale | 88
[NAME] | 11.4 |  | [NAME] | 64
Innocentia Letsoalo | 11.29 |  | [NAME] | 41
Kamo C Maripane | 10.29 |  | [NAME] | 68
Ranchia Nokayi | 10.29 |  | [NAME] | 38
[NAME] | 10 |  | [NAME] | 88
Nyadzawela [NAME] | 9.86 |  | [NAME] | 56
[NAME] | 9.86 |  | Glodean ([NAME]) Mekwa | 65
[NAME] | 9.86 |  | [NAME] | 44
[NAME] | 9.71 |  | Innocentia Letsoalo | 83
[NAME] | 9.29 |  | Kamo C Maripane | 77
[NAME] | 9.14 |  | [NAME] | 71
[NAME] | 9.14 |  | [NAME] | 64
[NAME] | 9.14 |  | Lindiwe Maepa | 57
[NAME] | 9 |  | [NAME] | 55
Phindile Ndhlovu | 9 |  | [NAME] | 40
Sibusiso Sibeko | 8.6 |  | Michelle Damons | 31
[NAME] | 8.57 |  | [NAME] | 38
Glodean ([NAME]) Mekwa | 8.43 |  | [NAME] | 6
[NAME] | 8.43 |  | Musiwalo [NAME] | 57
[NAME] | 8.29 |  | [NAME] | 60
Lindiwe Maepa | 8.14 |  | [NAME] | 56
[NAME] | 8 |  | [NAME] | 36
[NAME] | 8 |  | [NAME] | 56
[NAME] | 7.86 |  | Nyadzawela [NAME] | 74
[NAME] | 7.86 |  | Phindile Ndhlovu | 63
[NAME] | 7.8 |  | [NAME] | 65
[NAME] | 7.8 |  | [NAME] | 62
Michelle Damons | 7.75 |  | Ranchia Nokayi | 72
Musiwalo [NAME] | 7.71 |  | [NAME] | 36
[NAME] | 7.67 |  | [NAME] | 16
[NAME] | 7.6 |  | [NAME] | 74
[NAME] | 7.2 |  | [NAME] | 23
[NAME] | 6.71 |  | Sibusiso Sibeko | 49
[NAME] | 5.57 |  | [NAME] | 60
[NAME] | 5.43 |  | [NAME] | 58
[NAME] | 5.14 |  | [NAME] | 73
[NAME] | 3 |  | [NAME] | 69
[NAME] | 2.67 |  | [NAME] | 76
Spreadsheet: f02929d6-0bc8-4450-89be-bfc58362d625
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (29 Entries):
 | 3 Displays 3.5 Organic Light-Emitting Diode (OLED)
No. | Company | Country | City | [NAME] | Hall/Booth
1 | ACTRON AG | Germany | Parsdorf | 85599 | A3.348
2 | [NAME] | Germany | Heidenheim | 89518 | A3.520
3 | [NAME] | Germany | Rechberghausen | 73098 | A3.125
4 | admatec GmbH Elektronische Systeme und Komponenten | Germany | Hamburg | 20097 | A3.239
5 | CODICO GmbH | Austria | Perchtoldsdorf | 2380 | A5.507
6 | DATA MODUL AG | Germany | München | 80687 | A3.207
7 | Densitron Display Solutions | United Kingdom | London | EC4N 6AE | [NAME]
8 | Display Devices Elektronik AG | Germany | Gräfelfing | 82166 | A3.106
9 | Display Elektronik GmbH | Germany | Nidda | 63667 | A3.413
10 | Display LC Deutschland GmbH | Germany | Waldbronn | 76337 | A3.421
11 | DMB Technics AG | Switzerland | [NAME] | 6331 | A3.260
12 | ELECTRONIC DIRECT GmbH | Germany | [NAME] | 85640 | A4.137
13 | [NAME]Vertriebs GmbH | Germany | Nagold | 72202 | A5.138
14 | Fraunhofer-Institut für Photonische Mikrosysteme IPMS | Germany | Dresden | 01109 | A5.221
15 | [NAME] Bauelemente GmbH | Germany | [NAME] | 25462 | A4.221
16 | Glyn GmbH & Co.[NAME] | Germany | Idstein | 65510 | A3.225
17 | GMS mbH-Ges. für [NAME] und Display Systeme | Germany | VS-Villingen | 78048 | A3.220
18 | GSR Technology Deutschland GmbH | Germany | München | 80999 | [NAME]
19 | Huntsman Advanced Materials GmbH Switzerland | Switzerland | Basel | 4057 | A6.A15
20 | Kunshan Visionox Display Co. Ltd | China | Kunshan Jiangsu | 215300 | A3.220
21 | MEV Elektronik Service GmbH | Germany | Hilter | 49176 | A4.260
22 | Optrex Europe GmbH | Germany | Babenhausen | 64832 | A3.240
23 | ORTUS TECHNOLOGY CO., LTD. | Japan | Tokyo | 192-8556 | A3.321
24 | OSRAM Opto Semiconductors GmbH | Germany | [NAME] | 93055 | A3.107
25 | Raystar Optronics, Inc. | Taiwan | Taichung County | 42878 | A3.463/5
26 | RS Components GmbH | Germany | Mörfelden-Walldorf | 64546 | A4.117
27 | TDK Electronics Europe GmbH | Germany | [NAME] | 40472 | B5.506
28 | Texim Europe GmbH | Germany | Quickborn | 25451 | A3.350
29 | Yeebo LCD Ltd. | Hong Kong | N.T. |  | A3.260
Spreadsheet: 47964d1247146430-time-sheet-calclulation-from-raw-data-time-sheet-calculation
Sheet: Sheet2

Sum of Hours | Date
Emp Id | 2009-06-27 00:00:00 | 2009-06-29 00:00:00 | 2009-06-30 00:00:00 | 2009-07-01 00:00:00 | 2009-07-02 00:00:00 | 2009-07-03 00:00:00 | 2009-07-04 00:00:00 | 2009-07-06 00:00:00 | 2009-07-07 00:00:00 | Grand Total
390 | 5.000000000000001 | 9.099999999999998 | 9.366666666666667 | 9.483333333333333 | 9.566666666666668 | 9.516666666666666 | 4.033333333333333 | 9.383333333333333 | 8.3 | 73.74999999999999
853 | 0.06666666666666643 | 9.2 | 9.249999999999998 | 9.450000000000003 | 9.16666666666667 | 9.333333333333332 | 4.699999999999999 | 9.3 | 9.35 | 69.81666666666666
Spreadsheet: 8d7d9b5d-8593-4a34-94e0-e2ebc9be00b8
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
35933468 | 2013-05-14 03:40:30 | AXIS | 1 | 6 | 4 | 1210210 | player1210210 | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
35933738 | 2013-05-14 04:10:15 | ALLIES | 1 | 6 | 5 | 1210210 | player1210210 | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
35992330 | 2013-05-18 07:08:39 | AXIS | 0 | 3 | 6 | 1152035 | minderbinder | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
36005092 | 2013-05-19 03:01:45 | AXIS | 1 | 6 | 4 | 1245251 | [NAME] | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
36005281 | 2013-05-19 03:17:02 | ALLIES | 0 | 5 | 6 | 1245251 | [NAME] | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
36021951 | 2013-05-20 04:49:19 | AXIS | 1 | 6 | 5 | 1275298 | player fynenolay | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
36038633 | 2013-05-21 05:11:06 | ALLIES | 0 | 5 | 6 | 469507 | abelyas | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
36038866 | 2013-05-21 05:34:20 | AXIS | 1 | 6 | 4 | 469507 | abelyas | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
Spreadsheet: 862428d1710163883-orders-and-returns-detailed-contract-summary-order-and-returns-contract-summary
Sheet: Sheet1

Contract Summary
Order and [NAME] |  |  |  |  | Customer Contract Details
Type | Date | Serial Number | Customer # |  |  | Start Date | Customer Number | Cash Back (Purchase Only) | Annual Volume Commitments
Order | 1/1/2000 | 1 | 100 |  |  | 1/1/2022 | 100 | 5 | 10
Return | 1/1/2021 | 2 | 100 |  |  | 1/1/2024 | 200 | 10 | 20
Order | 1/1/2022 | 3 | 100
Return | 1/1/2023 | 1 | 100 |  | Rules
Return | 1/1/2023 | 3 | 100 |  | 1 | Orders must be at => after start date (i.e 1/1/2022 or after for customer 100)
Order | 1/1/2023 | 8 | 200 |  | 2 | Returns are only counted if the returned serial number was purchased => start date (i.e 1/1/2022 or after for customer 100)
Order | 1/1/2024 | 4 | 100 |  | 3 | Orders and returns can happen on the same date since this is a customer product (returns are easy)
Order | 1/1/2024 | 5 | 100 |  | 4 | Volume commitments are counted as the NET # orders (orders - returns)
Order | 1/1/2024 | 6 | 200 |  | 5 | Cash back is counted on NET # orders (orders-returns)
Return | 1/1/2024 | 5 | 100
Order | 1/1/2025 | 7 | 200
Return | 1/1/2025 | 7 | 200
Order | 1/1/2026 | 9 | 200
Answer (cells in yellow are what will be filled by formulas)
Below are the answers - I mannually entered in the  correct answer and did my best to show all details :)
Customer # | Orders | Returns | Cash Back |  | Net Orders | Volume Commitment | [NAME]
100 | 3 | 2 | 5 |  | 1 | 10
200 | 3 | 1 | 20 |  | 2 | 20
Spreadsheet: 113466d1309362594-comparing-dates-start-finish-dates-to-other-start-finish-dates-to-return-a-level-compare-dates-test
Sheet: Sheet1

Level 0 Start | Level 0 Finish | Level 1 Start | Level 1 Finish | Level 2 Start | Level 2 Finish | On Hold Start | On Hold Finish | Data Date | On Hold Level | What On Hold Value Should =
2009-01-01 00:00:00 | 2009-04-15 00:00:00 | 2009-04-16 00:00:00 | 2009-08-09 00:00:00 | 2009-08-10 00:00:00 | 2009-12-11 00:00:00 | 2009-04-18 00:00:00 | 2009-07-04 00:00:00 | 2011-06-29 00:00:00 |  | Level 1
2009-01-14 00:00:00 | 2010-03-21 00:00:00 | 2010-03-22 00:00:00 | 2010-06-20 00:00:00 | 2010-06-21 00:00:00 |  | 2011-01-01 00:00:00 |  | 2011-06-29 00:00:00 |  | Level 2
2009-01-16 00:00:00 | 2010-03-21 00:00:00 | 2010-03-23 00:00:00 | 2010-06-25 00:00:00 | 2010-06-21 00:00:00 |  | 2010-10-01 00:00:00 | 2011-02-14 00:00:00 | 2011-06-29 00:00:00 |  | Level 2
2011-01-01 00:00:00 | 2011-03-19 00:00:00 | 2011-03-20 00:00:00 |  |  |  | 2011-02-01 00:00:00 | 2011-02-20 00:00:00 | 2011-06-29 00:00:00 |  | Level 0
2011-01-20 00:00:00 | 2011-03-24 00:00:00 | 2011-03-25 00:00:00 | 2011-04-01 00:00:00 | 2011-04-02 00:00:00 |  | 2011-04-05 00:00:00 |  | 2011-06-29 00:00:00 |  | Level 2
Spreadsheet: 695255d1600109689-how-to-find-latest-date-using-max-formula-matching-p-n-and-partial-text-find-latest-date-using-index-match-and-partial-word
Sheet: Sheet1

 | 10/31/2022 |  |  |  | 10/31/2022 |  | 10/31/2022
 | 10/31/2022 |  |  |  | 10/31/2022 |  | 10/31/2022
 | 09/30/2022 |  |  |  | 09/30/2022 |  | 09/30/2022
 | 09/30/2022 |  |  |  | 09/30/2022 |  | 09/30/2022
 | 08/31/2026 |  |  |  | 08/31/2026 |  | 08/31/2026
 | 08/31/2026 |  |  |  | 08/31/2026 |  | 08/31/2026
 | 06/30/2022 |  |  |  | 06/30/2022 |  | 06/30/2022
 | 06/30/2022 |  |  |  | 06/30/2022 |  | 06/30/2022
 | 03/31/2024 |  |  |  | 03/31/2024 |  | 03/31/2024
 | 03/31/2024 |  |  |  | 03/31/2024 |  | 03/31/2024
 | 10/31/2027 |  |  |  | 10/31/2027 |  | 10/31/2027
 | 10/31/2027 |  |  |  | 10/31/2027 |  | 10/31/2027
 | 03/31/2029 |  |  |  | 03/31/2029 |  | 03/31/2029
 | 03/31/2029 |  |  |  | 03/31/2029 |  | 03/31/2029
 | 06/30/2022 |  |  |  | 06/30/2022 |  | 06/30/2022
 | 06/30/2022 |  |  |  | 06/30/2022 |  | 06/30/2022
 | 11/30/2025 |  |  |  | 11/30/2025 |  | 11/30/2025
 | 11/30/2025 |  |  |  | 11/30/2025 |  | 11/30/2025
 | 01/31/2027 |  |  |  | 01/31/2027 |  | 01/31/2027
 | 01/31/2027 |  |  |  | 01/31/2027 |  | 01/31/2027
 | 05/31/2030 |  |  |  | 05/31/2030 |  | 05/31/2030
 | [NAME] |  |  |  | [NAME] |  | [NAME]
Spreadsheet: 159184d1338540908-excel-2007-peoblem-of-opening-and-closing-stock-mock-work-sheet
Sheet: Raw Data

Date | Type of Transaction | Qty |  |  |  |  | Validation
2012-04-01 00:00:00 | Purchase | 100 |  |  |  |  | 2012-04-01 00:00:00
2012-04-01 00:00:00 | Purchase | 100 |  |  |  |  | 2012-04-02 00:00:00
2012-04-01 00:00:00 | Sale | 150 |  |  |  |  | 2012-04-03 00:00:00
2012-04-01 00:00:00 | Purchase | 400 |  |  |  |  | 2012-04-04 00:00:00
2012-04-02 00:00:00 | Sale | 100 |  |  |  |  | 2012-04-05 00:00:00
2012-04-02 00:00:00 | Sale | 100 |  |  |  |  | 2012-04-06 00:00:00
2012-04-02 00:00:00 | Purchase | 50 |  |  |  |  | 2012-04-07 00:00:00
 |  |  |  |  |  |  | 2012-04-08 00:00:00
 |  |  |  |  |  |  | 2012-04-09 00:00:00
 |  |  |  |  |  |  | 2012-04-10 00:00:00
 |  |  |  |  |  |  | 2012-04-11 00:00:00
 |  |  |  |  |  |  | 2012-04-12 00:00:00
 |  |  |  |  |  |  | 2012-04-13 00:00:00
 |  |  |  |  |  |  | 2012-04-14 00:00:00
 |  |  |  |  |  |  | 2012-04-15 00:00:00
 |  |  |  |  |  |  | 2012-04-16 00:00:00
 |  |  |  |  |  |  | 2012-04-17 00:00:00
 |  |  |  |  |  |  | 2012-04-18 00:00:00
 |  |  |  |  |  |  | 2012-04-19 00:00:00
 |  |  |  |  |  |  | 2012-04-20 00:00:00
 |  |  |  |  |  |  | 2012-04-21 00:00:00
 |  |  |  |  |  |  | 2012-04-22 00:00:00
 |  |  |  |  |  |  | 2012-04-23 00:00:00
 |  |  |  |  |  |  | 2012-04-24 00:00:00
 |  |  |  |  |  |  | 2012-04-25 00:00:00
 |  |  |  |  |  |  | 2012-04-26 00:00:00
 |  |  |  |  |  |  | 2012-04-27 00:00:00
 |  |  |  |  |  |  | 2012-04-28 00:00:00
 |  |  |  |  |  |  | 2012-04-29 00:00:00
 |  |  |  |  |  |  | 2012-04-30 00:00:00
Spreadsheet: 21037d1208081327-excel-import-stock-branches
Sheet: Summary Stock

Code | Name | Br 1 Qty | [NAME] | Br 3 Qty | BR 4 Qty | Br 5 Qty
1258 | PONDS
130756 | BOYS SPORTS WATCH RMB TA431/9
130891 | 2 PIN JAPAN
130895 | 3PIN TO 2PIN ADAPTOR
150069 | MAJMUR A00003
150672 | 12Pcs CUP & SAUCER CHINA
150991 | 11PCS MELAMINE PARTY SET 14
151661 | EGG BEATER STEEL 12 INCH-HAQ
151674 | 12PC CUP & SAUCER SET WITH STAND-HF298
152123 | 11PCS MELAMINE PARTY SET 3501
152124 | 11PCS MELAMINE PARTY SET S811-15 Inch
152268 | DOUBLE CIRCLE ALU.COFFEE POT-18CM
152269 | DOUBLE ALU.KETTLE 3LTR-A3020W
161726 | ATLAS LUNGY SHAMS 200x200
190695 | COLOUR BALLOONS 50Pcs RMB
190852 | 22 KEYS ELECTRONIC KEYBOARD 3665
[PHONE] | 1 D AILLEURS SPRAY 125ML
[PHONE] | DURACELL BATTERY AA (4) LR6
[PHONE] | 12PC MAGNET SET CARD-MG12
[PHONE] | 2A2 MEN SPRAY 100ml./FF
[PHONE] | 202 ERA SPRAY 100ml./In Style
[PHONE] | 10 WAY 13 AMP EXTENSION SOCKET 2111/13A/
[PHONE] | AL FELAIJ HAND BRUSH
BEU003 | MAKE UP SET 8000
BEU011 | MAKE UP SET 8080
BEU012 | MAKE UP SET 979
BEU023 | MAKE UP SET 7070
BEU037 | MAKE UP SET 9292
BEU063 | MAKE UP SET 9090
COS100 | PERT PLUS 200
COS200 | PENTINE 200
COS550 | MAKE UP 220
DINS001 | 16 PCS DINNER SET SAIF
ELE1268 | UNIVERSAL REMOTE CONTROL URC22
HOU1520 | 24 PCS SPOON SET METAL TRAY
MAJ002 | ELECTRIC MAJMUR IBEX WOOD-MINI
MAK014 | MAKE UP SET 9070 R
MAK060 | MAKE UP SET 9595W
RED1840 | BABY WEAR LUCKY BABY 3PCS
RED3660 | 026 BOYS SEMILONG 6PC
SPR007 | 16 PARIS SPRAY 100ml.
Spreadsheet: 872902d1719346973-count-span-of-zeros-in-row-between-1st-and-second-non-zero-cell-countspan
Sheet: Arkusz1

J | F | M | A | M | J | J | A | S | O | N | D |  | count span
0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 2 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 8 | 0 | 7 | 9 | 2 | 0 | 0 | 0 | 0
4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
9 | 9 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 2
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4
Spreadsheet: 23d1a923-038d-4137-a162-d27c0084d962
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | User Adjustable Figures | Vehicle A | Vehicle B
 | Price Paid | 25000 | 20000
 | Fuel Cost Per Gallon | 3 | 3
 | Miles Per Gallon | 30 | 25
 | Miles Driven Per Year | 15000
 | Calculated Metrics | Vehicle A | Vehicle B
 | Gallons Used in a Year | 500 | 600
 | Annual Fuel Cost | 1500 | 1800
 | Premium Paid for Vehicle A | 5000
 | Annual Savings Driving Vehicle A | 300
 | Years to Payback Premium | 16.66666666666667
 | User Adjustable Figures | Vehicle A | Vehicle B
 | Price Paid
 | Fuel Cost Per Gallon
 | Miles Per Gallon
 | Miles Driven Per Year
 | Calculated Metrics | Vehicle A | Vehicle B
 | Gallons Used in a Year | Miles Driven Per Year divided by [NAME], Vehicle A | Miles Driven Per Year divided by [NAME], Vehicle B
 | Annual Fuel Cost | Gallons Used in a Year multiplied by Fuel Cost Per Gallon, Vehicle A | Gallons Used in a Year multiplied by Fuel Cost Per Gallon, Vehicle B
 | Premium Paid for Vehicle A | Vehicle A's Price Paid minus [NAME] Price Paid
 | Annual Savings Driving Vehicle A | Vehicle B's Annual Fuel Cost minus Vehicle A's Annual Fuel Cost
 | Years to Payback Premium | Premium Paid for Vehicle A divided by Annual Saving Driving Vehicle A
Spreadsheet: 42256526-1d63-40f4-a6d6-771a61eb307b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Risk Balanced Commodity Fund
 | Monthly Performance History
 | Inception Date | 2012-07-09 00:00:00
 |  | Class I | Class N | UBS Dow Jones
 | Date | ARCIX | ARCNX | Commodity Index
* | 2012-07-31 00:00:00 | 0.02699999999999991 | 0.02699999999999991 | 0.03248631122739276
 | 2012-08-31 00:00:00 | 0.03602726387536515 | 0.03505355404089583 | 0.01298355992804878
 | 2012-09-30 00:00:00 | 0.01597744360902253 | 0.01599247412982119 | 0.01705559998270556
 | 2012-10-31 00:00:00 | -0.0545790934320074 | -0.0537037037037037 | -0.03872880663780853
 | 2012-11-30 00:00:00 | -0.004892367906066619 | -0.005870841487279899 | 0.0005160544468780781
 | 2012-12-31 00:00:00 | -0.0294985250737464 | -0.02952755905511817 | -0.0260713221720742
 | 2013-01-31 00:00:00 | 0.04660587639311053 | 0.04665314401622722 | 0.0239726
 | 2013-02-28 00:00:00 | -0.07066795740561471 | -0.07073643410852715 | -0.04086798
 | 2013-03-31 00:00:00 | -0.01770833333333333 | -0.01876955161626692 | 0.00673825
 | 2013-04-30 00:00:00 | -0.05832449628844105 | -0.05844845908607876 | -0.02790998
 | 2013-05-31 00:00:00 | -0.013513514 | -0.013544018 | -0.02242793
 | 2013-06-30 00:00:00 | -0.04794520547945202 | -0.04805491990846678 | -0.04714576
 | 2013-07-31 00:00:00 | 0.01079136690647475 | 0.01081730769230771 | 0.01362443
 | 2013-08-31 00:00:00 | 0.03202846975088969 | 0.03210463733650415 | 0.03402301
 | 2013-09-30 00:00:00 | -0.024137931 | -0.0241935484 | -0.02554184
 | 2013-10-31 00:00:00 | -0.0070671378 | -0.0082644628 | -0.0147661928
 | 2013-11-30 00:00:00 | -0.02016607354685651 | -0.01904761904761909 | -0.008003462071515033
 | 2013-12-31 00:00:00 | 0.003631961 | 0.002427184 | 0.01239895
 | 2014-01-31 00:00:00 | -0.01085645355850418 | -0.01089588377723971 | 0.00297646201515489
 | 2014-02-28 00:00:00 | 0.12317073170732 | 0.12239902080783 | 0.06235249966429
 | 2014-03-31 00:00:00 | -0.00325732899 | -0.002181025082 | 0.0041119619
 | * partial month return, inception date 7/9/2012
 | Risk Balanced Commodity Fund
 | [NAME]
 | Month-end Returns as of | Class I | Class N | UBS Dow Jones Commodity
 | March 31, 2014 | ARCIX | ARCNX | Index
 | 1 Year | -0.02651113536430805 | -0.02763018105641035 | -0.02097251656642363
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | -0.08200000064854274 | -0.08500000037408217 | -0.03549003862386846
 | Since Inception Annualized Return | -0.04836074819978742 | -0.05016377445861231 | -0.02071780120109479
 | Since Inception Annualized Monthly Volatility | 0.1485853251304662 | 0.1479494893877121 | 0.09735538801602747
 | Quarter-end Returns as of | Class I | Class N | UBS Dow Jones Commodity
 | March 31, 2014 | ARCIX | ARCNX | Index
 | 1 Year | -0.02651113536430805 | -0.02763018105641035 | -0.02097251656642363
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | -0.08200000064854274 | -0.08500000037408217 | -0.03549003862386846
 | Since Inception Annualized Return | -0.04836074819978742 | -0.05016377445861231 | -0.02071780120109479
Spreadsheet: 111458d1307824020-excel-2007-lookup-with-summing-ptproblem
Sheet: Φύλλο1

Orders
 |  |  |  |  | Product
Name | Product | Amount |  |  | A | B | C | D |  | Sum of Amount | Column Labels
[NAME] | A | 320 |  | [NAME] |  |  |  |  |  | Row Labels | A | B | C | D | Grand Total
[NAME] | C | 300 |  | [NAME] |  |  |  |  |  | Gerard |  |  |  | 300 | 300
[NAME] | A | 430 |  | Gerard |  |  |  |  |  | [NAME] | 750 | 200 |  |  | 950
Gerard | D | 300 |  | [NAME] |  |  |  |  |  | [NAME] |  | 600 | 300 |  | 900
[NAME] | D | 300 |  |  |  |  |  |  |  | [NAME] |  | 400 |  | 300 | 700
[NAME] | B | 200 |  |  |  |  |  |  |  | Grand Total | 750 | 1200 | 300 | 600 | 2850
[NAME] | B | 600
[NAME] | B | 400
Spreadsheet: phillip_allen__29936__LeanderCF0723
Sheet: Sheet1

REVENUES | PROJECTIONS |  |  |  | ACTUALS
 | PROJECT | P.ALLEN | K.HOLST |  | PROJECT | P.ALLEN | K.HOLST |  |  | LAN Estimate for Blvd extension = $292,500.  We agreed as follows:
Projected Sales Price | 1856250 |  |  |  | 1900000 |  |  |  |  | AMF               $236,250
Carrying Cost Payments |  |  |  |  | 12500 |  |  |  |  | Us                  $ 18,750
 |  |  |  |  |  |  |  |  |  | J Smith           $ 25,000
EXPENSES |  |  |  |  |  |  |  |  |  | AMFs Broker  $12,500
 |  |  |  |  |  |  |  |  |  | TOTAL           $292,500
Land Purchase Price | 1250000 |  |  |  | 1250000
Purchase Commissions | 75000 |  |  |  | 75000
Resale Commissions | 70000 |  |  |  | 70000
[NAME]. Closing | 621 |  |  |  | 621
Property Tax (2000) | 53.4 |  |  |  | 53.4
Property Tax (2001)
Permits (City of Leander) | 605 |  |  |  | 605
Appraisal | 1500 |  |  |  | 1500
Rezoning Costs | 15000
Plat Preparation |  |  |  |  | 11960
City permit for Plat application |  |  |  |  | 455
Subsurface expl. & pave analysis |  |  |  |  | 1275
[NAME]'s Title Policy | 15000 |  |  |  | 15000
Loan Origiantion | 8750 |  | 0 |  | 8750 |  | 0
Loan Carrying Cost | 50000 |  | 0 |  | 50000 |  | 0
TOTAL EXPENSES
NET INCOME
LEDGER
PAYEE | ITEM | PAYOR | ACCOUNT |  | DATE | AMOUNT
Austin Title Company | Land Purchase Price | P.Allen |  |  | 2001-12-29 00:00:00 | 1250000
Austin Title Company | Purchase Commissions | P.Allen |  |  | 2001-12-29 00:00:00 | 75000
Austin Title Company | Loan Origiantion | P.Allen |  |  | 2001-12-29 00:00:00 | 8750
Austin Title Company | [NAME]. Closing | P.Allen |  |  | 2001-12-29 00:00:00 | 621
Austin Title Company | Property Tax (2000) | P.Allen |  |  | 2001-12-29 00:00:00 | 53.4
 | Appraisal | P.Allen |  |  |  | 1500
City of Leander | Permits | P.Allen |  |  |  | 355
Enron Corp | Courier | P.Allen | State Bank (#1218) |  | 2001-01-25 00:00:00 | 162
City of Leander | Permits | P.Allen |  |  | 2001-04-04 00:00:00 | 250
Lockwood, Andrews & Newman | Rezoning Costs | P.Allen | PW (#104) |  | 2001-04-24 00:00:00 | 4500
Lockwood, Andrews & Newman | Rezoning Costs | P.Allen | State Bank (#1259) |  | 2001-05-09 00:00:00 | 455
InTEC of Austin Inc | Rezoning Costs | K.Holst | NB (Check 1169) |  | 2001-05-15 00:00:00 | 1275
Lockwood, Andrews & Newman | Rezoning Costs | K.Holst | NB (Check 1177) |  | 2001-06-07 00:00:00 | 1700
Lockwood, Andrews & Newman | Rezoning Costs | K.Holst | NB (Check 1183) |  | 2001-06-29 00:00:00 | 5760
Lockwood, Andrews & Newman | Rezoning Costs | K.Holst | TD (Check #110) |  | 2001-07-31 00:00:00 | 4940
O'Connor & Craig P.C. | Legal | P.Allen |  |  | 2001-01-19 00:00:00 | 5400.5
O'Connor & Craig P.C. | Legal | K.Holst | NB (Check 1190) |  | 2001-07-16 00:00:00 | 8972.5
OWNERSHIP
P.Allen - 90%
K.Holst - 10%
PAYMENTS FROM K.HOLST TO P.ALLEN
PAYEE | ITEM | PAYOR | ACCOUNT |  | DATE | AMOUNT
P.Allen | Investment | K.Holst | TD (Check #102) |  | 2001-12-20 00:00:00 | 127000
P.Allen | Investment | K.Holst |  |  | 2001-02-01 00:00:00 | 18000
P.Allen | Investment | K.Holst | NB (Check 1156) |  | 2001-04-24 00:00:00 | 4500