tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 92821d1292357886-lookup-question-with-multiple-criteria-example2
Sheet: wk 1&2

Name: |  |  | Social Security #: |  |  |  |  | 2011-01-14 00:00:00
Pay Period: | 1/1/2011 - 1/14/2011 |  | [NAME]: | Single | # of Allowances: | [NAME]
[NAME] | Customer | [NAME] | Commission | Commission | Base | Pay | Total | Commission
Date | Name | $ [NAME] | % | $ | Pay | Previous Tows | Pay | Withheld
Previous
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
Revised
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0.3 | 0 | 0 | 0 | 0 | 0
Total  PreviousTows |  | 0 |  | 0 | 0 | 0 | 0 | 0
[NAME] | Customer | Paid | Non-paid | Commission | Paid | Non-Paid | Base | Total | Commission
Date | Name | [NAME] | [NAME] | % | Commission $ | Commission $ | Pay | Pay | Withheld
Current | 1/1/2011 - 1/7/2011
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
sub total |  | 0 | 0 |  | 0 | 0 | 160 | 160 | -160
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
sub total |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
 |  | 0 | 0 | 0.3 | 0 | 0
sub total |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Total  Current Tows |  | 0 | 0 |  | 0 | 0 | 160 | 160 | -160
Salvage | Customer | Paid | Non-Paid | Commission | Commission | Commission | Pay | Total | Commission
Date | Name | Salvage Amount | Salvage Amount | % | $ | $ | Previous Tows | Pay | Withheld
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Salvage |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Total All |  |  |  |  |  |  | 0 | 160 | -160
Bi-Weekly Summary |  |  |  | Year-To-Date Summary
Gross Pay |  | 160 |  | Gross Pay |  | 160
FICA |  | 12.24 |  | FICA |  | 12.24
Fed WT |  | 0 |  | Fed WT |  | 0
Other |  | 0 |  | Other |  | 0
Net Pay |  | 147.76 |  | Net Pay |  | 147.76
Spreadsheet: 4fd5621f-3001-4987-b217-f7af58d2576b
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0019907 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Holly Ridge WWTF | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Onslow | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder
Monthly Limit: |  |  | 260626
Daily Limit:
Sample Frequency: |  |  | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 697755d1601507895-is-there-a-way-to-automate-this-row-sort-process-rowsort2
Sheet: Sheet1

 | 3 | 12 | 13 | 19 | 34 | 53 | 65
 | 7 | 22 | 33 | 18 | 91 | 26 | 77
 | 45 | 34 | 5 | 67 | 89 | 12 | 23
 | 39 | 14 | 25 | 46 | 8 | 42 | 19
 | 12 | 48 | 23 | 55 | 13 | 40 | 21
 | 19 | 4 | 69 | 17 | 51 | 39 | 33
 | 99 | 14 | 15 | 20 | 36 | 39 | 9
 | 23 | 24 | 37 | 81 | 13 | 15 | 1
 | 66 | 22 | 49 | 93 | 1 | 25 | 44
 | 6 | 88 | 19 | 12 | 45 | 68 | 23
Spreadsheet: kate_symes__18390__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2000-12-26 00:00:00 |  | 250.55 | 12960 | 173.75 | 800
 | 2000-12-25 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 75 | 464 | 59.88 | 171 |  | 204.22 | 10800
 | 2000-12-24 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 92.5 | 246 | 60.29 | 35 |  | 204.22 | 10800
 | 2000-12-23 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 140 | 35 | 121.09 | 184
 | 2000-12-22 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 267.5 | 0 | 80 | 375
 | 2000-12-21 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 252.65 | 1831 | 132.45 | 530
 | 2000-12-20 00:00:00 |  | 269.33 | 15200 | 190.33 | 2688 | 198.54 | 3261 | 151.82 | 927
 | 2000-12-19 00:00:00 |  | 258.18 | 10272 | 178.86 | 1968 | 195.85 | 2305 | 133.46 | 718
 | 2000-12-18 00:00:00 |  | 224.43 | 11840 | 176.78 | 1168 | 220.89 | 1072 | 124.85 | 495
 | 2000-12-17 00:00:00 |  | 196.67 | 1200 | 175.71 | 280 | 136.93 | 985 | 113.5 | 500 |  | 177.12 | 2664
 | 2000-12-16 00:00:00 |  | 233.65 | 12880 | 192.27 | 2704 | 130.23 | 922 | 120.83 | 60
 | 2000-12-15 00:00:00 |  | 238.8 | 13024 | 192.27 | 2704 | 180.19 | 1670 | 128.18 | 706
 | 2000-12-14 00:00:00 |  | 334.66 | 15184 | 213.55 | 2480 | 200 | 150 | 174.54 | 271
 | 2000-12-13 00:00:00 |  | 495.62 | 14992 | 223.93 | 4504 | 276 | 3139 | 184.69 | 2161
 | 2000-12-12 00:00:00 |  | 330 | 9200 | 211.98 | 2688 | 347.7 | 2622 | 193.04 | 1826
 | 2000-12-11 00:00:00 |  | 414.56 | 9200 | 213.96 | 2480 | 204.38 | 2263 | 187.04 | 1280
 | 2000-12-10 00:00:00 |  | 254.96 | 2160 | 217.63 | 2280 | 180.88 | 1906 | 161.34 | 780 |  | 172.02 | 600
 | 2000-12-09 00:00:00 |  | 317.74 | 14000 | 176.98 | 2608 | 189.51 | 1364 | 138.71 | 403
 | 2000-12-08 00:00:00 |  | 317.74 | 14000 | 176.98 | 2608 | 290.86 | 1368 | 205.28 | 799
 | 2000-12-07 00:00:00 |  | 262.73 | 15808 | 174.55 | 2816 | 241.93 | 1455 | 118.5 | 865
 | 2000-12-06 00:00:00 |  | 250.5 | 23472 | 154.65 | 3232 | 283.47 | 2363 | 157.27 | 595
 | 2000-12-05 00:00:00 |  | 227.52 | 24992 | 101.29 | 3072 | 232.74 | 2743 | 129.08 | 673
 | 2000-12-04 00:00:00 |  | 190.1 | 29792 | 122.57 | 3880 | 162.07 | 2138 | 113.27 | 707
 | 2000-12-03 00:00:00 |  | 131.13 | 1600 | 119.17 | 600 | 107.99 | 2405 | 107.67 | 1422 |  | 122.75 | 11040
 | 2000-12-02 00:00:00 |  | 137.08 | 30464 | 72.7 | 2560 | 118.37 | 1436 | 90.96 | 1103
 | 2000-12-01 00:00:00 |  | 137.11 | 30144 | 72.7 | 2560 | 118.32 | 2042 | 90.99 | 855
 | 2000-11-30 00:00:00 |  | 171.25 | 27456 | 82.58 | 2392 | 129.11 | 2102 | 91.19 | 576
 | 2000-11-29 00:00:00 |  | 172.05 | 26336 | 87.15 | 3328 | 109.18 | 1495 | 95.66 | 607
 | 2000-11-28 00:00:00 |  | 129.76 | 22496 | 80.75 | 2568 | 119.59 | 2075 | 96.18 | 1478
 | 2000-11-27 00:00:00 |  | 152.95 | 26240 | 92.28 | 1800 | 121.75 | 2397 | 79.26 | 1760
 | 2000-11-26 00:00:00 |  | 140 | 0 | 87.5 | 0 | 98.61 | 2369 | 70.02 | 968 |  | 92.77 | 6600
Spreadsheet: 742515d1627831293-category-subcategory-expense-type-on-transactions-sheet-category-test-1-
Sheet: Snapshot

 |  | Snapshot |  |  |  |  |  |  |  |  |  |  |  |  |  | Choose month below
 |  | See your spending trends month over month with easy to read graphs. To switch months, click on the blue date box to the right. |  |  |  |  |  |  |  |  |  |  |  |  |  | July 2021 |  |  |  |  |  |  |  | Monthly Summary |  |  |  | Category | Count | Rank | Order | Category | $ |  | Display Axis | Current Mon. | $ |  | [NAME] | Last Mon. | $ |  | [NAME] |  | Merchants | $ | Trans Count | Trans Rank | $ Rank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Input | Month Filter |  |  |  |  |  |  |  |  | 1
 |  |  | Current vs. previous month spending |  |  |  |  |  |  |  |  | This month's top spending categories |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Difference |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total spending
 |  |  | Cumulative spending throughout month
 |  |  | Frequented merchants |  |  |  |  |  |  |  |  | Merchants where the most was spent
 |  |  | Merchant |  |  | Count |  | Total cost |  |  |  | Merchant |  |  |  | Category |  | Total cost
 | 1
Spreadsheet: sally_beck__33914__HPL Budget reduction
Sheet: Sheet1

 |  |  | Total 2001 Budget |  |  | Savings After Sale *
 |  |  | Head count | Total Budget |  | Head Count | Budget
 | Settlements |  | 14 | 1289455 |  | 12
 | Risk Management |  | 9 | 842772 |  | 4
 | Logistics |  | 12 | 1143670 |  | 10
 | Vol Management |  | 14 | 1301887 |  | 14
 | Trading support |  | 3 | 310143 |  | 2
 | Global Facilities |  | 1 | 79398 |  | 1
 | Global Contracts |  | 4 | 326314 |  | 4
 | Rates |  | 4 | 372380 |  | 4
 | Regulatory |  | 5 | 588996 |  | 5
 | *  [NAME] sale completed by June 1, 2001
Spreadsheet: 766153d1643783835-appending-more-than-two-columns-using-one-dynamic-array-or-spilled-formula-book11
Sheet: Sheet1

 | From Here |  |  |  |  |  |  | To -
Balls
Dolls
Toy gun |  |  |  |  |  |  |  | Dolls | Low | Two
Robot |  |  |  |  |  |  |  | Toy gun | Middle | Three
Clay |  |  |  |  |  |  |  | Robot | Left | Four
 |  | One |  |  |  |  |  | Clay | Right | Five
 |  | Two |  |  |  |  |  |  |  | Six
 |  | Three
 |  | Four
 |  | Five
 |  | Six | High |  |  |  |  |  | High | One
 |  |  | Low |  |  |  |  | Dolls | Low | Two
 |  |  | Middle |  |  |  |  | Toy gun | Middle | Three
 |  |  | Left |  |  |  |  | Robot | Left | Four
 |  |  | Right |  |  |  |  | Clay | Right | Five
 |  |  |  |  |  |  |  |  |  | Six
Spreadsheet: 120072d1314965244-need-help-with-complex-if-function-to-return-values-on-different-sheet-book1
Sheet: Sheet1

Issue | Start | Close
Problem 1 | 2011-08-22 00:00:00
Problem 2 | 2011-08-23 00:00:00 | 2011-09-01 00:00:00
Problem 3 | 2011-08-31 00:00:00
Problem 4 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00
Problem 5 | 2011-09-01 00:00:00
Problem 6 | 2011-09-01 00:00:00
Problem 7 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00
Problem 8 | 2011-09-01 00:00:00
Problem 9 | 2011-09-01 00:00:00
Spreadsheet: 698653d1602095875-proportional-distribution-upto-the-cap-test-13-ans1
Sheet: Iteration 1 

Example 1
 |  |  | Inventory Available |  | 7000
 | Total
 | Item |  | Required | [NAME] cap | Requirement with cap
 | A |  | 0 | 2000 | 0
 | B |  | 4000 | 2000 | 2000
 | C |  | 4500 | 5000 | 5000
 | D |  | 0 | 5000 | 0
 |  |  | Inventory Left |  | 0
 |  |  |  |  | Inventory Available 1 | Inventory Available 2 | Inventory Available 3 |  | I want a formula in F21 which do the three steps i.e., Step 1 - distribute the inventory on the basis of there requirement, Step 2- cap the distribution upto there [NAME]. cap and Step 3, distribute the delta arisen from the capped amount to remaining item
Example 2 |  |  | Total Inventory --> |  | 7000
 |  |  | Category |  | 1 | 2 | 3 |  | 1
 | Total |  |  |  |  |  |  |  | Step 1 | Step 2 | Step 3
 | Item | Category | Required | [NAME] cap | Requirement with cap for "1" | Requirement with cap for "2" | Requirement with cap for "3" |  | Distribution based on nomination | [NAME] the distribution | Distribute the Delta to other item upto there CAP |  |  | Requirement with cap for "1"
 |  |  |  |  |  |  |  |  |  |  | Delta | Distribute to item whose cap has not yet met
 | A | 1 | 2000 | 2000
 | B | 1 | 4000 | 2000
 | C | 1 | 4500 | 5000
 | D | 1 | 1000 | 5000
 | E
 | F
 | G
Spreadsheet: 689165d1596153767-excel-index-match-with-date-and-multiple-criteria-returning-n-a-book4
Sheet: Sheet1

test
test |  |  | Invoice |  | 2019-03-01 00:00:00 |  | 13084 |  | 1005-00 · Accounts Receivable |  | 3495 |  |  |  |  | 2019-08-15 00:00:00
test |  |  | Payment |  | 2019-03-13 00:00:00 |  |  |  | 1005-00 · Accounts Receivable |  | -245
test |  |  | Payment |  | 2019-04-01 00:00:00 |  |  |  | 1005-00 · Accounts Receivable |  | -250
test |  |  | Payment |  | 2019-05-01 00:00:00 |  |  |  | 1005-00 · Accounts Receivable |  | -250
test |  |  | Payment |  | 2019-06-01 00:00:00 |  |  |  | 1005-00 · Accounts Receivable |  | -250
test |  |  | Payment |  | 2019-07-01 00:00:00 |  |  |  | 1005-00 · Accounts Receivable |  | -250
test |  |  | Payment |  | 2019-08-01 00:00:00 |  |  |  | 1005-00 · Accounts Receivable |  | -250
test |  |  | Payment |  | 2019-09-01 00:00:00 |  |  |  | 1005-00 · Accounts Receivable |  | -250
test |  |  | Payment |  | 2019-10-01 00:00:00 |  |  |  | 1005-00 · Accounts Receivable |  | -250
test |  |  | Payment |  | 2019-11-01 00:00:00 |  |  |  | 1005-00 · Accounts Receivable |  | -250
test |  |  | Payment |  | 2019-12-01 00:00:00 |  |  |  | 1005-00 · Accounts Receivable |  | -250
test |  |  | Payment |  | 2020-01-01 00:00:00 |  |  |  | 1005-00 · Accounts Receivable |  | -250
test |  |  | Payment |  | 2020-02-01 00:00:00 |  |  |  | 1005-00 · Accounts Receivable |  | -250
test |  |  | Payment |  | 2020-03-01 00:00:00 |  |  |  | 1005-00 · Accounts Receivable |  | -250
test |  |  | Payment |  | 2020-04-01 00:00:00 |  |  |  | 1005-00 · Accounts Receivable |  | -250
Spreadsheet: keith_holst__19419__NewDealCheck
Sheet: NX1&BasisStart

 | NG | NGI-SOCAL | NGI-PGE/CG | NGI-MALIN | NGI-SOBDR-PG&E | IF-NWPL_ROCKY_M | IF-CIG/RKYMTN | IF-NTHWST/CANBR | CGPR-KINGSGATE | CGPR-AECO/BASIS | IF-ELPO/SJ | IF-ELPO/PERMIAN | IF-TW/PERMIAN | IF-HEHUB | IF-HPL/SHPCHAN | IF-WAHA-TX |  | TOTAL
 | Price | SOCAL | PG&E CityGate | Malin | PG&E Topock | [NAME] | CIG ROX | Sumas | [NAME] | AECO | San Juan | Perm | TW Perm | [NAME] | Ship Channel | Waha |  | BASIS
2001-11-01 00:00:00
TOTALS
Spreadsheet: 851221d1701443378-column-comparison-column-comparison
Sheet: Sheet1

Column A | Column B | Col A not in Col B | Col B not in Col A
KD07113 | PM032
KD13414 | PM021
KD13415 | PM032
[NAME] | KS-1V
KD-72X | KS-19V
DH30421 | PM013
DH30422 | KS-97V
DH30435 | S100RM-WARNE
[NAME] | KS-104
KD07116 | KSC-24B
D-72X | MPF06700-328
D07116 | MPF06701-375
D13414 | KS-6V
D13415 | KSC-52V
PM142 | S-29
DH30433 | S-33
PM121 | MPF06701-250
PM611 | [NAME]
[NAME] | MPF06700-375
KD07111 | KS-7V
PM503 | S-25
PM021 | S-36
D07114 | S-56
D07111 | S-39
PM100 | S-31
KD-6 | S-26
KD04650 | S-49
D32708 | S-54
[NAME] | D13200
PM032 | MPF06700-406
DH30432 | bitch
KD01700 | S-48
D06013 | D-77
KD01804 | [NAME]
KD01431V | S-42
[NAME] | S-47
D06012 | S-58
DH30431 | S-50
KD-73M | S-85
[NAME] | KS-43
KD02600 | S-18
D06319 | S-44
MS06301 | KDBA01346
PM182 | S-137
MPF06701-250 | PM213
MPF07602 | S-11
KD01341 | D-83
[NAME] | KS-40
MPF07601 | S-43
D-73 | S-27
D-19 | KS-44
D-74 | S-32
D06316 | PM073
MS06300 | D13100
KD-54 | KS-87
KD01442V | KS-138
KD13405 | PM310
D04200 | S-59
D07112 | S-88
KMPF07602M | S-80
KD00807 | D06101
KD13401 | KB-89
PM070 | S-18
D06113 | S-53
KD01343 | S-45
KD03100V | D-68
D01700 | D12900
MS08702 | S-22
D13401 | D-70
D08001 | S-40
KD13402 | MPF06701-330
D22734 | S-60
D-148 | S-30
KD09000 | S-51
D13410 | KS-86B
D06104 | D13300
D02201 | KS-137
KD07112 | D-64
KD04750 | S-41
KD01702 | KD13200
D02100 | S-139
DBA01345 | D06313
D0040406 | S-61
PM280 | S-86B
D13405 | D06316
D22735 | S-37
KD13400 | D-73
D06212 | S-46
KD13406 | MPF07601
D22700 | S-87
D06015 | [NAME]
D-68 | KD-73M
D01804 | KD06101
KD01432V | S-57
D22725 | D-74
D01344 | PM503
D22724 | [NAME]
D13404 | S-38
D03100V | [NAME]
KD-40 | D-69
D-90 | S-28
PM296 | B-89
D04606 | PM100
KD00900 | MS06600
D22737 | B-76
S-87 | KE-48
[NAME] | MPF07602
PM310 | KMPF07602M
MS08300 | C-83
[NAME] | PM070
KD01344 | PM071
KD03400 | PM296
D06210
D13503
R00307
D04650
D06115
[NAME]
KD13411
[NAME]
D01102
D22743
DH30418
[NAME]
NS00042
B-76
KD13407
D04800
D-83
D06313
[NAME]
D32715A
KD00802
KD00801
D07113
D00215
PM020
KD13410
D-77
KD13404
DH30496
[NAME]
KD01342
D-32
[NAME]
KD07115
D22741
S-86B
D22702
D13407
KD04850
D04850
PM137
KD-55
KD07110
D12900
D03202
DBA13409
D06014
KD-56
KD07114
D13406
D08003
[NAME]
D01343
PM116
D04750
D-82
D13403
KD01438V
DH-91
D01341
KD01437V
KDBA00307
DBA00307
D07110
[NAME]
D-56
DBA13412
J04500
[NAME]
D-135
D00807
KDBA01345
KD13403
PM073
PM656
D00802
D13300
J02400
[NAME]
KDBA01346
RW-020-BL/BR-CC
DH-97
D-95
KD01500
D22707
D13200
D22738
D13100
[NAME]
D-64
D04901
D22742
D06314
[NAME]
D-55
D06317
D22710
SC-41
Spreadsheet: kate_symes__18899__ST-CALI Length
Sheet: Sheet1

 | Date |  |  | HE | HE | Total Hrs | Delivery Point | Supply |  |  |  | CISO INC | Sink | Sale Price | Fees
 | 2001-03-21 00:00:00 |  | Y | 7 | 8 |  | NP-15 | ST-CALI | 50 |  |  | 150 | SEMPRA | 200 |  |  |  |  |  |  | 557624, 557629 | 1
 | 2001-03-21 00:00:00 |  | Y | 9 | 10 |  | NP-15 | ST-CALI | 50 |  |  | 150 | SEMPRA | 250 |  |  |  |  |  |  | 557624, 557629 | 1
 | 2001-03-21 00:00:00 |  | Y | 11 | 11 |  | NP-15/PV | ST-CALI | 20 |  |  | 150 | SRP | 190 |  |  |  |  |  |  | 556845, 556582, 556592 | 1
 | 2001-03-21 00:00:00 |  | Y | 11 | 11 |  | NP-15/PV/NOB/MALIN | ST-CALI | 30 |  |  | 150 | SEMPRA | 450 | 30.72 |  |  |  |  |  | 556845, 556582, 556594, 556582, 503112, 556598, 556609, 556598, 556669 | 1
 | 2001-03-21 00:00:00 |  | Y | 12 | 22 |  | NP-15 | ST-CALI | 50 |  |  | 150 | SEMPRA | 290 |  |  |  |  |  |  | 557624, 557629 | 1
Spreadsheet: richard_shapiro__32394__Lisa - EIM Budget
Sheet: Scenario 1

Cost Center Owner | [NAME]
Cost Center Number | 103886
 | Please use this form only for Outside Services
 | Scenario 1:  The "ideal" world
 | Retainers and Identified Needs
 | [NAME] | Activity/Region | 2002 Est. $
 | Akin Gump | International Trade Retainer * | 180000
 |  | Total:
 | [NAME]
 | [NAME] | Activity/Region | 2002 Est. $
 | Akin Gump | Steel Section 201 - Lobbying at the Administration Level | 150000
 |  | Total:
* Retainer covers:
- identifying trade laws and regulations
- monitoring trade cases in relevant markets
- identifying exposures relating to trade rules
- advice on contracts
Spreadsheet: 716785d1612363015-how-to-convert-the-currency-and-then-sum-up-into-single-currency-sample-tried-with-glenn-formula-ans
Sheet: Sheet15

 |  |  |  | Accumulate
Div1 | Currency | EX-RATE | Dec'20 | Jan'21 | Feb'21 | Mar'21 | Apr'21 | May'21 | Jun'21 | Jul'21 | Aug'21 | Sep'21 | Oct'21 | Nov'21 | Dec'21 | USD
Beginning Balance | CNY |  | 44248.91017
[NAME] | CNY |  | 2176.989509999999 | 5000 | 2000
[NAME] | CNY |  | 796.466 | 3000 | 1000
Apple | CNY |  |  | 50 | 2000
Total | CNY
Div2 | Currency | EX-RATE | Dec'20 | Jan'21 | Feb'21 | Mar'21 | Apr'21 | May'21 | Jun'21 | Jul'21 | Aug'21 | Sep'21 | Oct'21 | Nov'21 | Dec'21 | USD
Beginning Balance | KRW |  | 2600.79475
[NAME] | KRW |  |  | 5000 | 3000
[NAME] | KRW |  | 5000 | 20 | 2000
Apple | KRW |  | 2000 | 5000 | 4000
Total | KRW
Div3 | Currency | EX-RATE | Dec'20 | Jan '21 | Feb '21 | Mar'21 | Apr'21 | May'21 | Jun'21 | Jul'21 | Aug'21 | Sep'21 | Oct'21 | Nov'21 | Dec'21 | USD
Beginning Balance | VND |  | 10671.47525
[NAME] | VND |  |  | 6000 | 5000
[NAME] | VND |  | 1000 | 3000 | 6000
Apple | VND |  | 2000 | 1000 | 3000
Total | VND
Div4 | Currency | EX-RATE | Dec'20 | Jan '21 | Feb '21 | Mar'21 | Apr'21 | May'21 | Jun'21 | Jul'21 | Aug'21 | Sep'21 | Oct'21 | Nov'21 | Dec'21 | USD
Beginning Balance | SRD |  | 5000
[NAME] | SRD |  | 2000 | 5000
[NAME] | SRD |  | 50 | 3000
Apple | SRD |  | 100000 | 5000
Total | SRD
Div5 | Currency | EX-RATE | Dec'20 | Jan '21 | Feb '21 | Mar'21 | Apr'21 | May'21 | Jun'21 | Jul'21 | Aug'21 | Sep'21 | Oct'21 | Nov'21 | Dec'21 | USD
Beginning Balance | USD |  | 2.152172613735
[NAME] | USD |  | 5000
[NAME] | USD |  | 3000 | 500
Apple | USD |  | 2000
Total | USD
TOTAL | Currency | EX-RATE | Dec'20 | Jan'21 | Feb'21 | Mar'21 | Apr'21 | May'21 | Jun'21 | Jul'21 | Aug'21 | Sep'21 | Oct'21 | Nov'21 | Dec'21 | USD
Beginning Balance | USD
[NAME] | USD
[NAME] | USD
Apple | USD
Total | USD
Need to formulate a formula so that if there is new [NAME] being add, I do not have to manually add them in
Spreadsheet: 93685d1293416657-excel-2007-transfer-data-on-a-spreadsheet1-to-another-spreadsheet2-using-a-macro-t-mobile_120910
Sheet: CANX

SHIP TO WAREHOUSE | MODEL/ SKU | [NAME] | PO | LINE NO. | ORDER RECEIVED FROM CUSTOMER | ORDER QTY | NEED BY DATE | ANTICIPATED SHIP DATE | SHIP QTY | ACTUAL SHIP DATE | ETA to  DC | PO LINE TOTAL | C/I | SALES ORDER | STATUS | APPT. # | TIME | AQL
LOUI-S | GS505NV.ATMONV | GS505 NAVY BLUE KIT | 4500105097 | 1 | 2010-09-15 00:00:00 | 5670 | 2010-10-12 00:00:00 | 2010-10-11 00:00:00 |  |  |  | 5670 | HQWW100176106-1 |  |  |  |  |  | ATCLE
CAGU-S | [NAME] | [NAME] | 4500105089 | 1 | 2010-09-15 00:00:00 | 405 | 2010-10-26 00:00:00 | 2010-10-22 00:00:00 |  |  |  | 405
LA GRANGE | GS505GIP.ATMOGI | SEEDGS505RED | 4500102988 | 1 | 2010-08-02 00:00:00 | 500 | 2010-09-02 00:00:00 |  |  |  |  | 500 | HQWW100179846-1
CAGU-S | GS170RD.ATMORD | GS170 RED KIT | 4500106050 | 1 | 2010-10-14 00:00:00 | 810 | 2010-11-09 00:00:00 | DO NOT SHIP |  |  |  | 810
CAGU-S | LGP509MZ.ATMOMZ | LG P509 WINE KIT | 4500106092 | 1 | 2010-10-14 00:00:00 | 810 | 2010-11-23 00:00:00 | 2010-11-17 00:00:00 |  |  |  | 810
LOUI-S | [NAME] | LG P509 BLACK KIT | 4500106100 | 1 | 2010-10-14 00:00:00 | 3240 | 2010-11-18 00:00:00 | 2010-11-18 00:00:00 |  |  |  | 3240 | HQWW100205739-5
LOUI-S | [NAME] | LG P509 BLACK KIT | 4500106102 | 1 | 2010-10-14 00:00:00 | 3240 | 2010-11-30 00:00:00 | 2010-11-29 00:00:00 |  |  |  | 3240 | HQWW100207451-1 |  |  |  |  |  | not on open po
Spreadsheet: 49078d1248352741-lookup-list-function-employee_reg
Sheet: PTO Entitlement

2009 PTO Entitlement
Employee | Start Date | 2009 PTO | Floating Holiday | Total PTO | Hours
Amelia | 2008-07-29 00:00:00 | 17 | 1 | 18 | 144
[NAME] | 2007-04-03 00:00:00 | 18 | 1 | 19 | 152
Brent | 2007-03-22 00:00:00 | 18 | 1 | 19 | 152
[NAME] | 2007-11-15 00:00:00 | 18 | 1 | 19 | 152
[NAME] | 2009-05-06 00:00:00 | 16 | 1 | 17 | 136
Cathy | 2008-09-02 00:00:00 | 17 | 1 | 18 | 144
Christina | 2008-01-23 00:00:00 | 17 | 1 | 18 | 144
[NAME] | 2008-08-18 00:00:00 | 17 | 1 | 18 | 144
[NAME] | 2007-01-09 00:00:00 | 18 | 1 | 19 | 152
Eliza | 2007-05-14 00:00:00 | 18 | 1 | 19 | 152
Emily | 2001-02-19 00:00:00 | 21 | 1 | 22 | 176
Heather | 2006-07-05 00:00:00 | 19 | 1 | 20 | 160
Jasmine | 2006-03-06 00:00:00 | 19 | 1 | 20 | 160
Jodi | 2006-10-09 00:00:00 | 19 | 1 | 20 | 160
Jordan | 2008-03-17 00:00:00 | 17 | 1 | 18 | 144
Justin | 2009-04-28 00:00:00 | 16 | 1 | 17 | 136
[NAME] | 2008-08-18 00:00:00 | 17 | 1 | 18 | 144
[NAME] | 2008-06-16 00:00:00 | 17 | 1 | 18 | 144
[NAME] | 2008-05-01 00:00:00 | 17 | 1 | 18 | 144
Lindsey | 2005-10-10 00:00:00 | 20 | 1 | 21 | 168
[NAME] | 2008-07-07 00:00:00 | 17 | 1 | 18 | 144
Mande | 2008-08-18 00:00:00 | 17 | 1 | 18 | 144
[NAME] | 2008-08-26 00:00:00 | 17 | 1 | 18 | 144
Natasha | 2008-03-28 00:00:00 | 17 | 1 | 18 | 144
Shelley | 2007-05-08 00:00:00 | 18 | 1 | 19 | 152
Stephania | 2005-11-29 00:00:00 | 20 | 1 | 21 | 168
[NAME] | 2008-09-18 00:00:00 | 17 | 1 | 18 | 144
[NAME] | 2009-06-09 00:00:00 | 16 | 1 | 17 | 136
[NAME] | 2009-06-08 00:00:00 | 16 | 1 | 17 | 136
Brooke | 2009-06-08 00:00:00 | 16 | 1 | 17 | 136
Deidre | 2009-06-01 00:00:00 | 16 | 1 | 17 | 136