tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 75868d1276498508-circular-reference-milescalc
Sheet: Sheet1

Enter Start Miles | or calculated |  | Enter End Miles | or calculated |  | Enter Miles Driven | or calculated
1455 |  |  |  | 5999 |  | 4544
 | 4555 |  | 5555 |  |  | 1000
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
 | 0 |  |  | 0 |  |  | 0
Spreadsheet: 114734d1310470065-total-from-multiple-spreadsheets-music2011sales
Sheet: Jan

TC Reporting Month | # [NAME] | PayRate for one sold | Total Earned | Currency | Album Title | [NAME] | Name of store or service | Country Of Sale
2011-01 | 1 | 0.7 | 0.7 | USD | Touching The Winky | Boobs | iTunes U.S. | US
2011-01 | 1 | 1.29 | 1.29 | AUD | [NAME] | [NAME] | iTunes Australia/N.Z. | AU
2011-01 | 1 | 0.99 | 0.99 | AUD | Touching The Winky | Touching Things Is Fun (the Winky Song) | iTunes Australia/N.Z. | AU
2011-01 | 4 | 0.92 | 3.68 | EUR | [NAME] | [NAME] | iTunes UK/European Union | GB
2011-01 | 1 | 0.71 | 0.71 | EUR | Touching The Winky | Midgets On Your Moon | iTunes UK/European Union | GB
2011-01 | 1 | 0.71 | 0.71 | EUR | Touching The Winky | Penguins | iTunes UK/European Union | GB
2011-01 | 1 | 0.71 | 0.71 | EUR | Touching The Winky | Touching Things Is Fun (the Winky Song) | iTunes UK/European Union | GB
Spreadsheet: 803485d1667489838-replace-and-right-function-for-job-title-example-file_1-aligw
Sheet: Sheet1

Employee Number | Employee Name | Current Job Title | New Grade | New Job Title | Latest 365
321 | Doe, [NAME] | 4380-080-01 - Deputy Sheriff Lieutenant (72) | 76
333 | Smith, [NAME] | 4380-040-01 - Deputy Sheriff Sergeant (69) | 73
456 | Smack, [NAME] | 4380-073-01 - Animal Shelter Supervisor (66) | 68
Spreadsheet: 679465d1590435557-text-join-ignoring-blanks-but-limited-to-a-maximum-of-five-entries-topictest-spreadsheet-draft-2-
Sheet: 01 Calculations (2)

Question Number
MathsWatch Clip |  | N18 | N18 | N19b | N19a | 21 | N2b | N17b | N28b | N29b | [NAME] | G21a | S7
 |  | Use negative number in a temperature context | Use negative number in a temperature context | Multiply and divide using negative numbers | Add and subtract using negative numbers | Use inverse operations to find missing numbers in calculations | Order decimal numbers | Multiply and divide numbers by powers of 10 | Multiply decimal numbers without a calculator | Divide decimal numbers without a calculator | Extend a geometric sequence where the term to term rule is | Multiply 3 decimals together to find the volume of a cuboid | Find the mean of decimal numbers | Total Marks | First 3 Incorrect Questions | Suggested MathsWatch Clips
 | % | 3 | 3 | 3 | 4 | 5 | 2 | 3 | 1 | 1 | 2 | 2 | 2
A |  | 3 | 3 | 0 | 4 | 0 | 2 | 3 | 0 | 1 | 1 | 2 | 2 |  |  | N19b, 21, N28b
B |  | 3 | 3 | 2 | 4 | 5 | 1 | 2 | 1 | 0 | 2 | 2 | 2 |  |  | N29b
C |  | 3 | 3 | 2 | 0 | 4 | 2 | 3 | 0 | 1 | 2 | 2 | 2 |  |  | N19a, N28b
D |  | 3 | 2 | 2 | 4 | 5 | 0 | 3 | 1 | 1 | 2 | 0 | 2
E |  | 2 | 3 | 3 | 4 | 4 | 2 | 3 | 1 | 1 | 2 | 2 | 2
F |  | 3 | 0 | 3 | 1 | 2 | 2 | 3 | 1 | 1 | 2 | 2 | 2
G |  | 3 | 3 | 3 | 2 | 2 | 0 | 1 | 1 | 1 | 2 | 2 | 2
H |  | 3 | 0 | 0 | 4 | 5 | 2 | 3 | 1 | 0 | 1 | 2 | 2
I |  | 3 | 3 | 3 | 3 | 5 | 2 | 3 | 1 | 1 | 2 | 2 | 2
J |  | 2 | 3 | 0 | 4 | 2 | 2 | 3 | 1 | 1 | 2 | 2 | 2
K |  | 3 | 0 | 0 | 4 | 5 | 1 | 3 | 1 | 1 | 2 | 0 | 2
L |  | 3 | 3 | 2 | 2 | 0 | 2 | 2 | 1 | 1 | 2 | 2 | 2
M |  | 3 | 2 | 3 | 0 | 5 | 0 | 3 | 0 | 1 | 2 | 2 | 2
N |  | 3 | 3 | 1 | 4 | 5 | 2 | 3 | 1 | 1 | 2 | 2 | 2
O |  | 3 | 2 | 3 | 0 | 0 | 2 | 3 | 1 | 1 | 2 | 2 | 2
P |  | 3 | 3 | 1 | 4 | 5 | 2 | 3 | 1 | 1 | 1 | 0 | 2
Q |  | 2 | 3 | 1 | 1 | 3 | 1 | 3 | 1 | 1 | 2 | 2 | 2
R |  | 3 | 0 | 3 | 4 | 0 | 2 | 3 | 1 | 1 | 2 | 2 | 2
S |  | 3 | 3 | 0 | 4 | 0 | 2 | 1 | 1 | 1 | 2 | 2 | 2
T |  | 3 | 3 | 3 | 3 | 5 | 2 | 3 | 1 | 1 | 2 | 1 | 2
U |  | 2 | 3 | 1 | 4 | 0 | 1 | 3 | 1 | 1 | 2 | 2 | 2
V |  | 3 | 0 | 3 | 4 | 5 | 0 | 3 | 1 | 1 | 2 | 2 | 2
W |  | 3 | 3 | 3 | 4 | 5 | 2 | 2 | 0 | 1 | 2 | 2 | 2
X |  | 3 | 3 | 1 | 3 | 5 | 2 | 3 | 1 | 1 | 2 | 2 | 2
Y |  | 3 | 3 | 3 | 4 | 0 | 0 | 3 | 1 | 1 | 1 | 0 | 2
Z |  | 3 | 0 | 3 | 3 | 5 | 0 | 3 | 1 | 1 | 2 | 1 | 2
AA |  | 3 | 3 | 0 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 2 | 2
AB |  | 3 | 3 | 3 | 4 | 4 | 2 | 3 | 1 | 1 | 2 | 2 | 2
AC |  | 0 | 0 | 0 | 4 | 5 | 1 | 2 | 0 | 0 | 1 | 0 | 2
AD |  | 3 | 3 | 0 | 4 | 5 | 2 | 3 | 1 | 0 | 2 | 2 | 2
AE |  | 3 | 3 | 3 | 4 | 5 | 0 | 3 | 1 | 1 | 2 | 2 | 2
Spreadsheet: 715575d1611768634-fill-in-the-according-vehicle-nr-map1
Sheet: Blad1

 | Vehicle nr. |  | Name 1 | Name 2
 |  |  | [NAME] | Franky
 |  |  | Hans | [NAME]
 |  |  | Koen | Lesley
 |  |  | [NAME] | [NAME]
 |  |  | [NAME] | [NAME]
 | Datalist
 | 500 | [NAME] | [NAME]
 | 501 | [NAME] | [NAME]
 | 502 | Eddy | Fred
 | 503 | Gianni | Hans
 | 504 | Ives | [NAME]
Spreadsheet: 888966d1739620555-help-me-excel-zero-valu-highlite-ef1672_highlight_zero
Sheet: Sheet1

 |  |  | QTY | QTY | QTY
SL | [NAME] |  | IN-WORD | IN-STOCK | OUT-WORD | UNIT PRICE
1 | Brass Check Valve ½" Spring Type Watts |  | 12 | 12 |  | 10.8
2 | Brass Check Valve ¾" Spring Type Watts |  | 12 | 12 |  | 13.5
3 | Brass Check Valve 1" Spring Type Watts |  | 12 | 3 |  | 21.6
4 | Brass Check Valve 1¼" Spring Type Watts |  | 10 | 10 |  | 37.8
5 | Brass Check Valve 1½" Spring Type Watts |  | 10 | 8 |  | 47.7
6 | Brass Check Valve 2" Spring Type Watts |  | 10 | 10 |  | 65
7 | [NAME]" Watts |  | 2 | 1 |  | 142
8 | PRV ¾" Watts |  | 2 | 2 |  | 185
9 | PRV 1" Watts |  | 2 | 2 |  | 225
10 | Brass Gate Valve ½" Watts |  | 12 | 10 |  | 15.75
11 | Brass Gate Valve ¾" Watts |  | 12 | 8 |  | 19.35
12 | Brass Gate Valve 1" Watts |  | 12 | 10 |  | 27.9
13 | Brass Gate Valve 1¼" Watts |  | 6 | 4 |  | 38.7
14 | Brass Gate Valve 1½" Watts |  | 6 | 6 |  | 50
15 | Brass Gate Valve 2" Watts |  | 6 | 6 |  | 75
16 | [NAME] ¾" Watts |  | 12 | 10 |  | 16.5
17 | [NAME] Watts |  | 12 | 12 |  | 23
18 | [NAME] 1¼" Watts |  | 5 | 5 |  | 42
19 | [NAME] 1½" Watts |  | 5 | 5 |  | 58
20 | [NAME]" Watts |  | 5 | 5 |  | 88
21 | Air Vent Cap ½" Watts |  | 12 | 9 |  | 28
22 | Air Vent Cap ¾" Watts |  | 12 | 6 |  | 38
23 | Air Vent Cap 1" Watts |  | 10 | 10 |  | 44
24 | Brass Y-Strainer  1¼" Watts |  | 1 | 1 |  | 41
25 | Brass Y-Strainer  1½" Watts |  | 1 | 1 |  | 57
26 | Brass Y-Strainer  2" Watts |  | 1 | 1 |  | 95
27 | Water Hammer Arrester [NAME]" Watts |  | 30 | 30 |  | 40
28 | Water Hammer Arrester ¾" Watts |  | 12 | 12 |  | 70
29 | Water Hammer Arrester 1" Watts |  | 6 | 6 |  | 105
30 | [NAME]" Watts |  | 5 | 5 |  | 10
Spreadsheet: 796698d1663441956-keep-running-total-for-every-new-month-row-test
Sheet: Categories

 |  |  |  |  |  |  | SUMIF(Expenses[Category],[@[Main Category]],Expenses[Debited])
 |  |  |  | Main Category |  |  | Main Category | Total
 |  |  |  | Baby Care
 |  |  |  | Clothes |  |  | Clothes | 238.17
 |  |  |  | Documents |  |  | Documents | 164
 |  |  |  | Donations |  |  | Donations | 0
 |  |  |  | Education |  |  | Education | 300
 |  |  |  | Entertainments |  |  | Entertainments | 300
 |  |  |  | Finance |  |  | Finance | 490
 |  |  |  | Food |  |  | Food | 82.5
 |  |  |  | Grocery |  |  | Grocery | 183.5
 |  |  |  | Health |  |  | Health | 300
 |  |  |  | Miscellaneous |  |  | Miscellaneous | 476.5
 |  |  |  | Outdoor Dining |  |  | Outdoor Dining | 2428.8
 |  |  |  | Transportation |  |  | Transportation | 1963.48
 |  |  |  | Utilities |  |  | Utilities | 1230.26
 |  |  |  | Budget |  |  | Budget | 0
Spreadsheet: chris_germany__2009__6-19-02 Gas Cash
Sheet: Log

5 Day Rolling Cash Forecast:  Payment Log as of Jun-19-02
Payment Date | Amount | Deal Name | Counterparty | Commercial Contact | Transaction Description
2002-06-24 00:00:00 | -2371234.02 | Citrus | Citrus | [NAME]/[NAME] | Phys | Payment related to gas purchases.  Payment day changed, and will keep being pushed back until further notice.
2002-06-20 00:00:00 | -200 | [NAME] | [NAME] | [NAME] | Phys | Possible payment in return for capacity release revenues of +$100,000.  Payment date to be rolled back until further notice.
2002-06-25 00:00:00 | 1280619.23 | City of Tallahassee | City of Tallahassee | C hris Germany | Phys | Payment for May swing and baseload gas.
Spreadsheet: 55814d1255988489-pricing-formula-pricing-formula
Sheet: Proman

productcode | productname | vendor_price | productweight | productprice |  | correct amount | comments
PRO-VL16201 | Excalibur Dark Cherry Wardrobe Valet | 82 | 21 | Here we need the formula based on vendor price and weight variable
PRO-VL16146 | Hampton Curved Executive [NAME] | 62.7 | 13 | 175.4 |  | 175.4 | correct
PRO-VL16241 | Kingston III Wardrboe Valet | 64 | 13 | 178 |  | 178 | correct
 |  | 3500 | 100 | 6475 |  |  | correct
 |  | 2500 | 100 | 5000 |  |  | correct
 |  | 1000 | 101 | 2250 |  | 2000 | this was to be 2 times vendor price
 |  | 1000 | 90 | 2050 |  | 1950 | this was to be 1.95 times vendor price
 |  | 500 | 101 | 1500 |  | 1250 | this should be 2.25 times the vendor price
 |  | 500 | 95 | 1050 |  | 1050 | this was to be 2 x times vendor price+ $50
 |  | 300 | 101 | 675 |  | 900 | this was to be 3 x times vendor price
 |  | 300 | 95 | 650 |  | 900 | this was to be 3 x times vendor price
 |  | 100 | 101 | 275 |  | 275 | this was to be 2 times vendor +75
 |  | 100 | 95 | 250 |  | 250 | this was to be 2 times vendor +50
 | 56003209
Spreadsheet: 105950d1303221660-major-vlookup-issues-example
Sheet: Sheet1

Account # | NAME | Parent ID |  | PARENT ID | ACCOUNT NUMBER
HR1324 | Company 1 | [NAME] |  | [NAME] | HR1327
HR1325 | Company 2 | HR101 |  | HR101 | HR1325
HR1326 | Company 3 | HR102 |  | HR102 | HR1326
HR1327 | Company 4 | HR103 |  | HR103 | HR1324
HR1328 | Company 5 | HR104 |  | HR104 | HR1328
HR1329 | Company 6 | HR105 |  | HR105 | HR1329
 |  |  |  | HR106
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | HR109
What I am looking for is in Orange (column C) |  |  |  | HR110
 |  |  |  | HR111
 |  |  |  | HR112
 |  | Equation I am using
 |  | =VLOOKUP(A2,$A$2:$F$14,5,FALSE)
What I am trying to do: I want the vlookup function to look for A2 Account number search column E and then bring back the matching value from Column d to Column C. I have thousands of more values in D than I do in E, will that matter?
Problem: It is just pulling over each ParentID and not searching for it via the Account Number (Column F)
Spreadsheet: 875406d1721983629-sum-after-sort-unique-vstack-with-criteria-for-multiple-worksheet-vstack-with-criteria-1-
Sheet: Summary

 |  |  | P1 |  | P2 |  | P3 |  | P4
 | Particulars | ID | Header 1 | [NAME] | Header 1 | [NAME] | Header 1 | [NAME] | Header 1 | [NAME]
 |  | 5263 | 52 |  | 147
 | Apple |  | 36 | 44 | 36
 | Deep | 412 | 44 |  | 44
 | Jasmine
 | Nuts | 3 | 4 |  | 4
 | Orange | 125 | 21 |  | 57
 | Sunflower
 | Text1 | 26 | 64 |  | 64
Spreadsheet: 866480d1713390100-index-and-match-to-find-a-column-number-book1-1-
Sheet: Sheet1

 |  | Centile
 | Age | 10 | 25 | 50 | 75 | 90 |  |  |  |  | 10 | 25 | 50 | 75 | 90
1 | 90 | 16 | 20 | 25 | 29 | 33 |  | Age | 57 | Nearest Age > 57 |  | 39 | 45 | 51 | 56
2 | 85 | 19 | 24 | 29 | 33 | 38 |  | Value | 52 | Nearest Age < 57 |  | 40 | 47 | 53 | 59
3 | 80 | 23 | 27 | 32 | 37 | 42
4 | 75 | 26 | 31 | 35 | 41 | 45
5 | 70 | 29 | 34 | 39 | 44 | 49 |  |  | Either this
6 | 65 | 31 | 37 | 43 | 48 | 53 |  |  | or this
7 | 60 | 33 | 39 | 45 | 51 | 56
8 | 55 | 34 | 40 | 47 | 53 | 59
9 | 50 | 35 | 41 | 48 | 54 | 60
10 | 45 | 36 | 42 | 49 | 56 | 61
11 | 40 | 38 | 44 | 50 | 57 | 63
12 | 35 | 39 | 45 | 51 | 58 | 64
13 | 30 | 38 | 44 | 51 | 58 | 64
14 | 25 | 36 | 41 | 48 | 55 | 61
15 | 20 | 30 | 35 | 40 | 46 | 52
16 | 15 | 21 | 25 | 29 | 33 | 38
17 | 10 | 12 | 15 | 17 | 20 | 22
18 | 5 | 6 | 7 | 8 | 9 | 10
 | I can find the age row, 8 for 55 years.
 | I need to be able to look up the smallest number equal or greater than a value in the array in order to lookup the centile column.
Spreadsheet: tracy_geaccone__40162__2001_Q1_Negotiated Deals_Rev1
Sheet: Detail

 | CR# | SHIPPER |  | VOLUME | MAX RATE | REVENUE
JANUARY
Deal | 27446 | Reliant | SJ to EOT | 310000 |  | 155000
[NAME] |  |  | SJ to EOT | 216888 | 0.2144
[NAME] |  |  | SJ to WOT | 39990 | 0.3845
Difference
January Total
FEBRUARY
Deal | 27491 | Sempra | EOT to WOT | 139885 |  | 1501076
Deal |  | Sempra | SJ to WOT | 267323 |  | 2940668
[NAME] |  |  | EOT to WOT | 139885 | 0.3699
[NAME] |  |  | SJ to WOT | 267323 | 0.3845
Difference
Deal | 27492 | Richardson | EOT to WOT | 258911 |  | 1480810
[NAME] |  |  | EOT to WOT | 258911 | 0.3699
Difference
February Total
[NAME]
 |  |  |  |  |  |  | Invoiced | [NAME]
Deal | 27495 | Astra | EOT to WOT | 195513 |  | 305221.43 | 355534
[NAME] |  |  | EOT to WOT | 195513 | 0.3699
Difference
[NAME] (Con'd)
Deal | 27529 | BP Energy | EOT to WOT | 163003 |  | 489282
[NAME] |  |  | EOT to WOT | 163003 | 0.3699
Difference
Deal | 27496 | Reliant | SJ to WOT | 375071 |  | 495219 | 498016
[NAME] |  |  | SJ to WOT | 375071 | 0.3845
Difference
Deal | 27528 | Sempra | EOT to WOT | 159645 |  |  | 1828051
Deal |  | Sempra | SJ to WOT | 291269 |  | 1126654
[NAME] |  |  | EOT to WOT | 159645 | 0.3699
[NAME] |  |  | SJ to WOT | 291269 | 0.3845
Difference
Deal | 27526 | Richardson | EOT to WOT | 300000 |  | 1299622 | 1299638
[NAME] |  |  | EOT to WOT | 300000 | 0.3699
Difference
March Total
TOTAL Q1
Spreadsheet: 214331d1360866107-building-complex-sales-projections-could-use-some-help-sales-projections-sample
Sheet: Resource Requirements

Resource Requirements | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Totals
PM |  | 10 | 15 | 15 | 5 | 5 | 5 | 5 |  |  |  |  | 60
Senior [NAME] |  | 10 | 15 | 15 | 5 | 5 | 5 | 5 |  |  |  |  | 60
Development |  | 10 | 15 | 15 | 5 | 5 | 5 | 5 |  |  |  |  | 60
Spreadsheet: 723cd854-6b85-4ca8-a10d-5c8ebf78c1a2
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
40232153 | 2014-02-25 12:49:33 | AXIS | 1 | 6 | 3 | 1524192 | [NAME] | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
40232309 | 2014-02-25 13:10:07 | ALLIES | 0 | 4 | 6 | 1524192 | [NAME] | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
40248891 | 2014-02-26 13:57:08 | AXIS | 0 | 2 | 5 | 1524192 | [NAME] | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
Spreadsheet: 874763d1721288281-formula-scrambles-arguments-when-pulled-across-s3_dynamic_array_legacyformulas_issue_
Sheet: SUMIFS

SUMIFS & COUNTIFS with OR Condition (more than 1 criteria in one column)
 |  |  |  |  | 1. Create a summary table by Region and Division
Division | Region | App | Revenue
Game | Asia | Arcade | 4378 |  |  | Asia | North America | Europe
Game | Asia | Aviatrr | 5254 |  |  | Australia | South America
Game | Asia | Baden | 6130 |  | Division | Region 1 | Region 2 | Region 3
Game | Asia | deRamblr | 7443
Game | Asia | Fightrr | 13135 |  | Productivity
Game | Asia | Twistrr | 7443 |  | Utility
Game | Australia | Arcade | 15890
Game | Australia | Aviatrr | 11917
Game | Australia | Baden | 1490
Game | Australia | Pes | 497
Game | Australia | Twistrr | 3476
Game | Europe | Arcade | 9267
Game | Europe | Aviatrr | 9731
Game | Europe | Kryptis | 927
Game | Europe | Perino | 463
Game | Europe | Pes | 463
Game | Europe | Twistrr | 2317
Game | North America | Arcade | 5361
Game | North America | Aviatrr | 5808
Game | North America | Pes | 4468
Game | North America | Twistrr | 1340
Game | South America | Arcade | 5108
Productivity | Asia | Halotot | 3513
Productivity | Asia | Inkly | 2928
Productivity | Europe | Blend | 911
Productivity | Europe | Dasring | 2277
Productivity | Europe | Didactic | 3188
Productivity | Europe | Flowrrr | 3643
Productivity | Europe | Halotot | 5465
Productivity | Europe | Right App | 5465
Productivity | Europe | Silvrr | 4554
Productivity | Europe | Sleops | 455
Productivity | Europe | Voltage | 911
Productivity | Europe | WenCaL | 10930
Productivity | North America | Blend | 1708
Productivity | North America | Dasring | 683
Productivity | North America | Didactic | 683
Productivity | North America | Flowrrr | 683
Productivity | North America | Halotot | 6148
Productivity | North America | Inkly | 1025
Productivity | North America | [NAME] | 683
Productivity | North America | Mirrrr | 1366
Productivity | North America | Pet Feed | 1708
Productivity | North America | Rehire | 6148
Productivity | North America | Right App | 7514
Productivity | North America | Silvrr | 683
Productivity | North America | Sleops | 342
Productivity | North America | Voltage | 3416
Productivity | North America | WenCaL | 1366
Productivity | South America | Blend | 1220
Productivity | South America | Dasring | 2732
Productivity | South America | Didactic | 9563
Productivity | South America | Sleops | 683
Productivity | South America | Voltage | 12979
Productivity | South America | WenCaL | 5465
Utility | Australia | Accord | 684
Utility | Australia | Amplefio | 4104
Utility | Australia | [NAME] | 0
Utility | Australia | Commuta | 1710
Utility | Australia | Infic | 684
Utility | Australia | Minor Liar | 684
Utility | North America | Minor Liar | 9723
Utility | South America | [NAME] | 2508
Utility | South America | Mosquit | 0
Utility | South America | Motocyco | 0
Utility | South America | Twenty20 | 7105
Spreadsheet: 684187d1593187068-index-indirect-and-match-using-two-workbooks-results
Sheet: Sheet1

Date Quoted | Quote Completed | # of Quotes | Line | # of Quote Lines | Cust. ID | User | Customer Name | Part Num | Quantity |  |  | Address from Daily | New Jobs Date Stamp
2020-06-01 00:00:00 | 2020-06-23 00:00:00 | 39139 | 7 | 391397 | 53072 | PER | INTERNATIONAL SUBMERSIBLE WATER PUMP | 72989101 | 200
2020-06-10 00:00:00 | 2020-06-23 00:00:00 | 39139 | 7 | 391397 | 53072 | PER | INTERNATIONAL SUBMERSIBLE WATER PUMP | 72989101 | 200
2020-06-19 00:00:00 | 2020-06-23 00:00:00 | 39139 | 7 | 391397 | 53072 | PER | INTERNATIONAL SUBMERSIBLE WATER PUMP | 72989101 | 200
Spreadsheet: 45653d1244473242-nesting-vlookup-in-if-vice-versa-and-pivot-table-sample3
Sheet: Mar Cat2

Model | Amount-Cat2
750 | 219.89402424
900 | 2854.077098447526
AB | 835.1874557769601
AG | 67.99038950879999
AN | 1921.91843448
BX | 5117.59845828
BZ | 4073.83675776
CA | 2323.15658388
CB | 507.5799795000001
LA | 2456.4472599744
MF | 952.9452647580772
MR | 11705.8886839439
OA | 414.1111906152968
OB | 155.5198082960761
OR | 195.3656905009663
RA | 604.2866291580772
RF | 11357.2300483439
TM | 65.45255501529672
ZB | 2892.4240980096
ZP | 1649.4411745548
ZQ | 360.381785445
Grand Total | 50730.73337048868
Spreadsheet: louise_kitchen__22726__0201MarginRequirements
Sheet: 0104

FUTURES MARGIN REQUIREMENTS
2002-01-07 00:00:00
2002-01-04 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$ |  | US $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | TE | Initial Margin | OTE
ABN-Amro Inc | 148571.6360000279 |  | 148571.6360000279 | 0 | 0 |  | 0 |  |  |  | 148571.6360000279 |  |  |  | 0
ADM INVESTOR | 0.1990000053192489 |  | 0.1990000053192489 | 0 | 0 |  | 0 |  |  |  | 0.1990000053192489 |  |  |  | 0
BANK ONE | 0.2200000286102295 |  | 0.2200000286102295 | 0 | 0 |  | 0 |  |  |  | 0.2200000286102295 |  |  |  | 0
CARR FUTURES (NG) | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
CARR FUTURES INC. | 4275645.259770168 |  | 4275645.259770168 | 0 | 683152.59 |  | 683152.59 |  |  |  | 3592492.669770168 |  |  |  | 24675.79125
CREDIT SUISSE FIRST BOSTON | 29866.61000000313 |  | 29866.61000000313 | 0 | 0 |  | 0 |  |  |  | 29866.61000000313 |  |  |  | 0
EDF MAN | 8383992.715999773 |  | 8383992.715999773 | 0 | 0 |  | 0 |  |  |  | 8383992.715999773 |  |  |  | 0
FIMAT | 2272696.17 |  | 2272696.17 | 0 | 0 |  | 0 |  |  |  | 2272696.17 |  |  |  | 0
HSBC - US$ | -2131.681408999983 |  | -2131.681408999983 | 0 | 0 |  | 0 |  |  |  | -2131.681408999983 |  |  |  | 0
HSBC - Canadian | 0 |  | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 64204.5 | 0 | 0
JP Morgan | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
[NAME] | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
PARIBAS | 80371717.16000006 |  | 80371717.16000006 | 0 | 0 |  | 0 |  |  |  | 80371717.16000006 |  |  |  | 0
PRUDENTIAL SI | -0.09857879066839814 |  | -0.09857879066839814 | 0 | 0 |  | 0 |  |  |  | -0.09857879066839814 |  |  |  | 0
REFCO, INC | 0.2590000069403686 |  | 0.2590000069403686 | 0 | 0 |  | 0 |  |  |  | 0.2590000069403686 |  |  |  | 0
R J O'BRIEN | 0.1799999999930151 |  | 0.1799999999930151 | 0 | 0 |  | 0 |  |  |  | 0.1799999999930151 |  |  |  | 0
SAUL STONE & COMPANY | 0.180000000000291 |  | 0.180000000000291 | 0 | 0 |  | 0 |  |  |  | 0.180000000000291 |  |  |  | 0
SMITH BARNEY, INC | 53592.45999999158 |  | 53592.45999999158 | 0 | 0 | 0 | 0 |  |  |  | 53592.45999999158 |  |  |  | 0
SMITH BARNEY, INC  (Financial) | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
TOTAL EXCLUDING MID-DAY CALLS | 95533951.26978227 | 0 | 95533951.26978227 | 0 | 683152.59 | 0 | 683152.59 |  | 0 |  | 94850798.67978227 |  | 64204.5 | 0 | 24675.79125
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS | 95533951.26978227
 |  |  |  |  |  |  |  |  |  |  |  |  | 94850798.67978227
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0 | 0 | 0 | 50000000
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: 101789d1299829797-populating-an-invoice-from-two-timesheets-invoice_1101-5_test
Sheet: WEEK TWO

DUSTIN |  | [NAME]
 |  | 5514 Timber [NAME]
 |  | San Antonio, Texas 78250
 |  | [PHONE] cell
 |  | [EMAIL]
 |  |  | INVOICE for Design Services |  |  |  |  |  |  | no. | 1101-5
 |  |  | TIMESHEET SUMMARY
 |  |  | WEEK TWO
INDIRECT TIME |  |  | SAT | SUN | MON | TUE | WED | THU | FRI | TOTAL HOURS
 |  |  | 2011-03-05 00:00:00 | 2011-03-06 00:00:00 | 2011-03-07 00:00:00 | 2011-03-08 00:00:00 | 2011-03-09 00:00:00 | 2011-03-10 00:00:00 | 2011-03-11 00:00:00
1100 | GENERAL OFFICE |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
1100 | BUSINESS DEVELOPMENT |  |  |  |  |  |  |  |  | 4.5
 | MARKETING |  |  |  |  |  |  |  |  | 0
 | CLIENT MAINTENANCE |  |  |  |  |  |  |  |  | 0
 | SALES |  |  |  |  |  | 4.5 |  |  | 4.5
 |  |  |  |  |  |  |  |  |  | SUBTOTAL OF INDIRECT TIME | 4.5
DIRECT TIME
PROJECT NUMBER | SUB CODE | PROJECT NAME
1101 | D | SMITH RESIDENCE |  |  | 2.5 | 5 | 2.25 | 5 |  | 14.75
1102 | D | [NAME] | 3 | 2 | 3.5 | 3 |  |  |  | 11.5
 | E | MUSEUM GROUNDS |  |  |  |  | 2.5 | 2.5 |  | 5
 | F | WHISPERING HILLS |  |  | 2 |  |  | 0.5 | 6.5 | 9
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | SUBTOTAL OF DIRECT TIME | 40.25
 |  |  | SAT | SUN | MON | TUE | WED | THU | FRI | % DIRECT | TOTAL
 |  |  | 3 | 2 | 8 | 8 | 9.25 | 8 | 6.5 | 0.8994413407821229 | 44.75