tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30669__200002_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Denver |  | Texas-HPLR |  | Texas-EGM |  | Texas-HPLC |  | Storage |  | Ontario |  | Aruba |  | Sithe |  | BUG
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 130500 |  |  |  | 0
2 |  | Liquidations |  |  |  | -130500 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  | 5998 |  |  |  |  |  |  |  |  |  |  |  |  |  | -236103
7 |  | Liquidations |  |  |  |  |  | 528798 |  |  |  |  |  |  |  |  |  |  |  |  |  | -940000
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage |  |  |  |  | 150000 | -21605
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -95808
18 |  | W/D (Purchase from Stg) |  |  |  |  | -150000 | 21605 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13427849
19 |  | Inventory Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1428901
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 318140 |  |  |  |  |  |  |  |  |  | 0
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -50000
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  | -135000 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | -21000 |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
37 |  | [NAME] |  |  |  |  |  | 22942
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | -178764 |  |  |  |  |  |  |  | -318140
 |  | TOTAL
Spreadsheet: 680513d1591066905-is-it-possible-to-use-imported-queries-in-normal-formula-bar-without-load-to-worksheet-ef-master
Sheet: KoefAHSPDetil

NOMOR KOEFISIEN | KODE ITEM | NILAI KOEFISIEN | NAMA ITEM | KATEGORI ITEM | SATUAN
A.2.2.1.1 | UPAH-L.01 | 0.4
A.2.2.1.1 | UPAH-L.02A | 0.2
A.2.2.1.1 | UPAH-L.03 | 0.02
A.2.2.1.1 | UPAH-L.04 | 0.02
A.2.2.1.1 | MTRL-000002 | 5
A.2.2.1.1 | MTRL-000003 | 0.005
A.2.2.1.1 | MTRL-000004 | 0.009
A.2.2.1.1 | MTRL-000005 | 0.072
A.2.2.1.1 | MTRL-000006 | 0.06
A.2.2.1.1 | MTRL-000007 | 0.4
A.2.2.1.2 | UPAH-L.01 | 0.2
A.2.2.1.2 | UPAH-L.02A | 0.4
A.2.2.1.2 | UPAH-L.03 | 0.02
A.2.2.1.2 | UPAH-L.04 | 0.02
A.2.2.1.2 | MTRL-000002 | 2.5
A.2.2.1.2 | [NAME] | 1.2
A.2.2.1.2 | MTRL-000003 | 0.005
A.2.2.1.2 | MTRL-000004 | 0.009
A.2.2.1.2 | MTRL-000005 | 0.072
A.2.2.1.2 | MTRL-000006 | 0.06
A.2.2.1.2 | MTRL-000009 | 0.45
A.2.2.1.3 | UPAH-L.01 | 0.2
A.2.2.1.3 | UPAH-L.02A | 0.3
A.2.2.1.3 | UPAH-L.03 | 0.02
A.2.2.1.3 | UPAH-L.04 | 0.02
A.2.2.1.3 | MTRL-000001 | 1
A.2.2.1.3 | MTRL-000002 | 2
A.2.2.1.3 | MTRL-000010 | 25
A.2.2.1.3 | MTRL-000003 | 0.005
A.2.2.1.3 | MTRL-000004 | 0.009
A.2.2.1.3 | MTRL-000006 | 0.06
Spreadsheet: 539196d1506004129-adding-a-sum-to-an-index-match-test
Sheet: Sheet2

EE Number | Benefit | Total Amt
8866 | Life | 50
8866 | Life | 100
8877 | Other | 25
8877 | Other | 90
8888 | Life | 75
9966 | Life | 55
9977 | Other | 25
9912 | Life | 85
9912 | Life | 75
9912 | Other | 25
9912 | Other | 100
1111 | Life | 25
2222 | Other | 66
Spreadsheet: 07102345-a7d2-4190-ba5a-306b759d0847
Sheet: Sheet1

Sample University | 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 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
Write Off Authorization Form
Date
[NAME] | Acct # | Acct  Address (optional) | Type Acct | $ Amount W/O | Legal Issue? | Prerequisites Met? | Comments  (including justification for write off, if not evident) |  |  |  |  |  |  |  |  | Yes | Student Accounts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Patient Accounts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contracts & Grants Accounts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Technoloy Transfer Accounts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Auxiliary Accounts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Departmental Sales/Services
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loan Accounts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
I HAVE REVIEWED THE ACCOUNTS LISTED TO BE WRITTEN OFF, THE ACTIONS TAKEN TO COLLECT THESE ACCOUNTS, AND THE REASONS FOR WRITING OFF THE ACCOUNT AND HAVE DETERMINED THAT THE ACCOUNTS MAY BE WRITTEN OFF IN ACCORDANCE WITH STATE AND ESTABLISHED UNIVERSITY POLICY.  I APPROVE THAT THE ABOVE ACCOUNTS BE WRITTEN OFF AS REQUESTED.
APPROVED BY: |  |  |  |  | DATE:
Spreadsheet: 4a766bf3-8937-44be-b716-c9385a11fb08
Sheet: CO GRAD PATHWAY

Grant: |  | Colorado Graduation Pathways
CFDA # |  | 84.36
GRANT NUMBER: |  | 5360
FISCAL YEAR: |  | FY2012-13
[NAME]: |  | Limited to 15%
Question regarding payments: |  | [NAME]  [PHONE] or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez [PHONE] or [EMAIL]
GBL/ORG: |  | 693C/7000
LAST DAY TO SUBMIT REQUEST FOR THIS GRANT  - October 15, 2013
Code | District/Agency Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY 2012 | AUGUST 2012 | SEPTEMBER 2012 | OCTOBER 2012 | OCTOBER 2012 | NOVEMBER 2012 | DECEMBER 2012 | JANUARY 2013 | FEBRUARY 2013 | MARCH 2013 | APRIL 2013 | MAY 2013 | JUNE 2013 | JULY 2013 | AUGUST 2013 | SEPTEMBER 2013 | OCTOBER 2013
0010 | [NAME] | 162479 |  |  |  |  |  |  |  | 6250 | 6250 | 13769 | 6250 |  |  | 6250 |  | 53535 | 12431 | 17128
0010-NAS | New America Schools | 56764 |  |  |  |  |  |  |  |  | 15458 |  | 7693 |  |  | 10774
0020 | Adams 12 Five Star Schools |  |  |  |  |  |  |  |  | 39233 | 14786 | 20366 | 26377 | 34916 | 30073 | 42514 | 32036 | 52183 | 8556 | 17254
0030 | Adams 14 | 109754 |  |  |  |  |  |  |  |  | 20024 | 12665 | 5183 | 6058 |  | 19109 | 13175 | 21987 |  | 11553
0070 | Westminster 50 | 121800 |  |  |  |  |  |  |  |  | 12951 | 7553 | 3156 | 6599 | 5826 | 27874 |  |  |  | 8386
0120 | Englewood 1 | 113406 |  |  |  |  |  |  |  | 20089 | 10187 | 13555 | 13334 | 317 | 6965 | 6852 | 28996 | 12184 | 597
0130 | [NAME] | 52311 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3130
0180 | Adams-Arapahoe 28J | 402922 |  |  |  |  |  |  |  |  | 122739 | 26933 | 54825 | 30718 | 37705 | 34142 | 37340 | 23572 | 29110 | 1226
0180-NAS | New America Schools | 50000 |  |  |  |  |  |  |  |  | 11744 | 587 | 8443 | 422 |  | 10171 |  |  | 15906 | 770
0880-11 | Denver Public Schools | 163799 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 117639
1010 | Colorado Springs 11 | 102626 |  |  |  |  |  |  |  |  | 30451 |  | 4856 | 1419 |  |  |  | 22149 | 20018
1420 | [NAME] | 270312 |  |  |  |  |  |  |  | 17641 | 18680 | 15494 | 13842 | 19155 | 16767 | 17891 | 31760 | 24272 |  | 29338
1990 | Plateau 50 | 51802 |  |  |  |  |  |  |  | 4940 | 4937 | 4966 | 4966 | 4966 | 4966 | 4966 | 4994 | 4994 | 4994 | 2113
2000 | Mesa 51 | 53804 |  |  |  |  |  |  |  | 3804 |  | 4164 | 6000 | 6000 |  | 8600 | 3400 |  | 21836
2035 | [NAME] | 103601 |  |  |  |  |  |  |  | 7633 | 6766 | 6734 | 6822 | 6778 | 6783 | 9529 |  | 15490 | 16566 | 14012
2405 | [NAME] | 57000 |  |  |  |  |  |  | 3639 | 3106 | 3459 | 3636 | 4105 | 3504 | 3555 | 3656 | 3668 | 3321 | 7192
2690 | Pueblo City 60 | 132250 |  |  |  |  |  |  |  | 942 | 17569 | 10435 | 8105 |  | 10911 | 9557 | 11019 | 24389 | 25784
3120 | [NAME] 6 | 105861 |  |  |  |  |  |  |  |  | 26145 | 4606 |  |  |  | 2002 | 2926 | 2379
3140 | Weld RE-6 | 58386 |  |  |  |  |  |  |  |  |  |  | 14131
Spreadsheet: 69586d1270128359-lookup-values-in-three-columns-true-if-they-match-another-sheet-sumproduct-test
Sheet: Actual

Currency | Amount | Value Date
GBP | 1500 | 2010-03-01 00:00:00 | 1 |  | I want this value to say True if it matches any of the columns in the other table, false if it isn't located.
USD | 1000 | 2010-02-28 00:00:00 | 1
[NAME] | 10000 | 2010-01-03 00:00:00 | 0
EUR | 5000 | 2009-12-31 00:00:00 | 1
SEK | 15000 | 2009-07-01 00:00:00 | 1
[NAME] | 800 | 2010-01-04 00:00:00 | 0
EUR | 8000 | 2009-12-31 00:00:00 | 1
SEK | 14000 | 2009-07-01 00:00:00 | 1
Spreadsheet: 43241d1241808305-split-numbers-and-split-words-splitt-numbers
Sheet: Sheet1

 | FN |  | MN |  | EN
 | 1 | + | 0 | + | 9 | =
 |  | + |  | + |  | =
 |  | + |  | =
Spreadsheet: 44129d1242773530-macro-help-test051909
Sheet: Sheet1

 |  | No. ---means Numbers from 0---to---9---in---B--row
 |  | Out ---means how many times that the numbers is missing----A--row
 |  |  | Say the number  7  just hit…
 |  |  | Just as soon as the number  7  hits it goes back to 1 in the Out count…
 |  |  |  | example |  |  |  |  | example
Out | No. |  |  |  | Out | No. |  |  |  | Out | No.
17 | 6 |  |  |  | 17 | 6 |  |  |  | 17 | 6
14 | 4 |  |  |  | 14 | 4 |  |  |  | 14 | 4
11 | 0 |  |  |  | 11 | 0 |  |  |  | 11 | 0
10 | 7 |  |  | X | 1 | 7 |  |  |  | 10 | 7
8 | 1 |  |  |  | 8 | 1 |  |  |  | 8 | 1
6 | 9 |  |  |  | 6 | 9 |  |  |  | 6 | 9
4 | 5 |  |  |  | 4 | 5 |  |  |  | 4 | 5
3 | 3 |  |  |  | 3 | 3 |  |  |  | 3 | 3
2 | 2 |  |  |  | 2 | 2 |  |  |  | 2 | 2
1 | 8 |  |  |  | 1 | 8 |  |  |  | 1 | 8
Now we sort from highest out to lowest ……..
Can we get a macro to do all this????
We have Excel 2007…..
We have two different numbers that are drawn a day…from 0----to---9……
Thanks
[NAME]
Spreadsheet: 84325d1284387979-conditional-formatting-color_max_value
Sheet: Sheet1

 |  |  |  | 4
 |  |  | A | 1 | 1 | 1 |  |  |  |  | A | 1
 |  |  | C | 3 | 3 | 3 |  |  |  |  | B | 2
 |  |  | D | 4 | 4 | 4 |  |  |  |  | C | 3
 |  |  | B | 2 | 2 | 2 |  |  |  |  | D | 4
 |  |  | D | 4 | 4 | 4
 |  |  | A | 1 | 1 | 1
 |  |  | C | 3 | 3 | 3
 |  |  | D | 4 | 4 | 4
Spreadsheet: 678424d1589885810-compare-2-big-excel-files-sample-attached-excel-2
Sheet: Sheet1

 |  | Days in a Month
 |  | Days in a Year
 |  | 8 Days Off Every 28 days
 |  | AVAILABLE DAYS CALCULATE
 |  | DATA | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42
 |  | TD - BF
 | Input Field | SET A
 |  | A | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
 |  | B | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
 |  | C | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
 |  | D | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
 |  | E | 0.075 | 0.075 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.075 | 0.075 | 0.075
 |  | F | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12
 |  | G | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.05 | 0.05 | 0.05
 |  | H | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | I | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | J | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
 |  | SET B
 |  | A | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
 |  | B | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
 |  | C | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
 |  | D | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
 |  | E | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075
 |  | F | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
 |  | G | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
 |  | H | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | I | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | J | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
 |  | MY RELF
 |  | LOGGING
 | 2 | Operating CP | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 3 | RELIEF A | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
 | 4 | RELIEF | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
 | 5 | RELIEF C | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
 |  | LOGGIN 2
 | 2 | CP | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 3 | CP (IRP)
 | 4 | FO
Spreadsheet: b504320f-09ba-4837-91f5-8986fff247a0
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
Wines offered in GBP per case of 12 bottles, 24 half-bottles or 6 magnums, unless otherwise indicated. 21 September 2014.  Wines lying in bond at London City Bond. E&O.E.  Prices exclude duty and VAT.  For all enquiries, please contact us at [EMAIL]
Region | Producer | Vintage | Wine | Condition | Cs | Bt | GBP Sell | Per | Size | Units | GBP/bt
Dry White Bordeaux | - | 2012 | Carbonnieux Blanc | - | 20 | - | 200 | CS | 75cl | 240 | 16.67
Dry White Bordeaux | - | 2011 | Carbonnieux Blanc | - | 3 | 6 | 215 | CS | 75cl | 42 | 17.92
Dry White Bordeaux | - | 2010 | Carbonnieux Blanc | - | 2 | - | 240 | CS | 75cl | 24 | 20
Dry White Bordeaux | - | 2005 | Domaine de Chevalier Blanc | - | 1 | - | 580 | CS | 75cl | 12 | 48.33
Dry White Bordeaux | - | 1999 | Domaine de Chevalier Blanc | - | 1 | - | 450 | CS | 75cl | 12 | 37.5
Dry White Bordeaux | - | 2005 | [NAME] | - | - | 6 | 450 | CS | 75cl | 6 | 37.5
Spreadsheet: 827892d1683107928-distribute-automatically-and-equitly-on-excel-in-a-certain-number-of-cells-the-result-o-distribute-automatically-and-equitly-on-excel-in-a-certain-number-of-cells-the-result-0
Sheet: josephteh 2

Products | Cost | Shipping Cost | TOTAL | 1st Apportion | Product wt highest cost | 2nd Apportion | 1st Product wt highest cost | 3rd Apportion | Total Shipping Cost | Combined Formula | Using LET for Excel 2021 | Remarks
Product A | 19.99 |  |  |  |  |  |  |  |  |  |  | 1st difference apportioned among products with highest Cost
Product B | 19.99 |  |  |  |  |  |  |  |  |  |  | Next, any remaining difference to 1st product on the list with highest Cost
Product C | 160.99
Product D | 160.99
Product E | 12.95
Product F | 12.95
 |  |  |  |  |  |  |  | Check
Total of shipping cost | Quantity of product | Shipping cost for each product | Rounddown | Difference | # Product wt highest cost | Difference Apportion |  | [NAME]
14.6
Distribute automatically and equitly on EXCEL, in a certain number of cells, the result 0
[NAME]
Spreadsheet: 231005d1366917551-copy-data-based-on-selection-in-drop-down-control-sample-3-
Sheet: Data

 | 123456 |  |  |  | 654321 |  |  |  | 123654 |  |  |  | 456321
 | Result | Result 2 | Result 3 | Summary Data | Result | Result 2 | Result 3 | Summary Data | Result | Result 2 | Result 3 | Summary Data | Result | Result 2 | Result 3 | Summary Data
 | 0.5 | 0.25 | 0.125 | ABC (123) | 1 | 2 | 5 | [NAME] (789) | 1 | 2 | 5 | HI (123) | 1 | 2 | 5 | UP (123)
 | 1 | 0.5 | 0.25 | 123 (ABC) | 2 | 4 | 10 | 789 (XYZ) | 2 | 4 | 10 | 123 (HI) | 2 | 4 | 10 | 123 (UP)
 | 1.5 | 0.75 | 0.375 |  | 3 | 6 | 15 |  | 3 | 6 | 15 |  | 3 | 6 | 15
 | 2 | 1 | 0.5 |  | 4 | 8 | 20 |  | 4 | 8 | 20 |  | 4 | 8 | 20
 | 2.5 | 1.25 | 0.625 | DEF (456) | 5 | 10 | 25 | UVW (456) | 5 | 10 | 25 | BYE (123) | 5 | 10 | 25 | DOWN (123)
 | 3 | 1.5 | 0.75 | 456 (DEF) | 6 | 12 | 30 | 456 (UVW) | 6 | 12 | 30 | 123 (BYE) | 6 | 12 | 30 | 123 (DOWN)
 | 3.5 | 1.75 | 0.875 |  | 7 | 14 | 35 |  | 7 | 14 | 35 |  | 7 | 14 | 35
 | 4 | 2 | 1 |  | 8 | 16 | 40 |  | 8 | 16 | 40 |  | 8 | 16 | 40
 | 4.5 | 2.25 | 1.125 |  | 9 | 18 | 45 |  | 9 | 18 | 45 |  | 9 | 18 | 45
 | 5 | 2.5 | 1.25 |  | 10 | 20 | 50 |  | 10 | 20 | 50 |  | 10 | 20 | 50
 | 5.5 | 2.75 | 1.375 |  | 11 | 22 | 55 |  | 11 | 22 | 55 |  | 11 | 22 | 55
 | 6 | 3 | 1.5 |  | 12 | 24 | 60 |  | 12 | 24 | 60 |  | 12 | 24 | 60
 | 6.5 | 3.25 | 1.625 |  | 13 | 26 | 65 |  | 13 | 26 | 65 |  | 13 | 26 | 65
 | 7 | 3.5 | 1.75 |  | 14 | 28 | 70 |  | 14 | 28 | 70 |  | 14 | 28 | 70
 | 7.5 | 3.75 | 1.875 |  | 15 | 30 | 75 |  | 15 | 30 | 75 |  | 15 | 30 | 75
 | 8 | 4 | 2 |  | 16 | 32 | 80 |  | 16 | 32 | 80 |  | 16 | 32 | 80
 | 8.5 | 4.25 | 2.125 |  | 17 | 34 | 85 |  | 17 | 34 | 85 |  | 17 | 34 | 85
Spreadsheet: 767309d1644405088-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Sheet16

 |  | Status | Count of Status
 |  | Didn't join after selection | 1
 |  | Duplicate | 12
 |  | In Progress | 2
 |  | No Show | 14
 |  | Not Interested | 17
 |  | Not Suitable | 31
 |  | Not Yet Scheduled | 10
 |  | Offer Accepted | 1
 |  | [NAME] | 3
 |  | On Hold | 1
 |  | Pending | 10
 |  | Rejected (1st) | 42
 |  | Rejected (2nd) | 5
 |  | Rejected-Online Test | 5
 |  | Grand Total | 154
Spreadsheet: 125b6b74-1a41-475c-b9c6-361cb30ba080
Sheet: Sheet1

Table 8--Oilseed prices received by U.S. farmers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Marketing | Soybeans2 | Cottonseed3 | Sunflowerseed2 | Canola4 | Peanuts3 | Flaxseed4
year
 | $/bushel | $/short ton | $/cwt. | $/cwt. | Cents/pound | $/bushel
2003/04 | 7.34 | 117 | 12.1 | 10.6 | 19.3 | 5.88
2004/05 | 5.74 | 107 | 13.7 | 10.7 | 18.9 | 8.07
2005/06 | 5.66 | 96 | 12.1 | 9.62 | 17.3 | 5.94
2006/07 | 6.43 | 111 | 14.5 | 11.9 | 17.7 | 5.8
2007/08 | 10.1 | 162 | 21.7 | 18.3 | 20.5 | 13
2008/09 | 9.97 | 223 | 21.8 | 18.7 | 23 | 12.7
2009/10 | 9.59 | 158 | 15.1 | 16.2 | 21.7 | 8.15
2010/11 | 11.3 | 161 | 23.3 | 19.3 | 22.5 | 12.2
2011/12 | 12.5 | 260 | 29.1 | 24 | 31.8 | 13.9
2012/13 | 14.4 | 252 | 25.4 | 26.5 | 30.1 | 13.8
2013/141 | 11.95-13.45 | 230-270 | 20.15-22.65 | 18.05-20.55 | 22.75-25.25 | 13.25-14.75
2012/13
September | 14.3 | 254 | 28.9 | 26.5 | 35.2 | 13.3
October | 14.2 | 254 | 26.3 | 27 | 33.7 | 13.6
November | 14.3 | 255 | 26.7 | 26.7 | 32.6 | 14.1
December | 14.3 | 252 | 24.8 | 27.1 | 36.9 | 13.8
January | 14.3 | 249 | 26.3 | 26.8 | 31.2 | 13.7
February | 14.6 | 217 | 26.1 | 27.8 | 28.2 | 14.3
March | 14.6 |  | 24.6 | 27.3 | 27.8 | 14.4
April | 14.4 |  | 24.8 | 27.5 | 26.8 | 14.9
May | 14.9 |  | 24 | 28 | 27.1 | 15.4
June | 15.1 |  | 24.4 | 27.4 | 27 | 15.2
July | 15.3 |  | 23.7 | 26.2 | 24.2 | 15.1
August | 14.1 |  | 23.7 | 22.2 | 25.1 | 14.9
2013/14
September | 13.3 | 190 | 22.6 | 20.7 | 25.5 | 13.1
October | 12.5 | 281 | 23 | 21 | 26 | 13.5
November | 12.7 | 248 | 20.8 | 20.4 | 26.6 | 13.4
December | 13 | 246 | 18.8 | 21.2 | 24.6 | 13.5
January1 | 13 | 230 | 20.3 | 18 | 25.7
1 Preliminary.  2 September-August.  3August-July. 4 July-June.
NA = Not available. |  | cwt.=hundredweight.
Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Last update: | 2014-02-12 09:19:57.560000
Spreadsheet: 866421d1713337126-how-to-automatically-match-cell-info-from-one-sheet-to-another-if-it-matches-a-cell-in-she-complete-list-mock-up-v1
Sheet: Example_2

Client Names | Notes
3 Spring
Vehicle Details | Make & Model | Vehicle Reg | MOT | Service
 | Fiat Doblo | derhg | 2024-10-11 00:00:00
OCC Approved  Drivers
Drivers Name | Driving Licence | [NAME] | Endorsements | [NAME]
sa | 1942 | 2024-03-14 00:00:00 | 3 | 1905-07-16 00:00:00
2012 | March | 1903-10-31 00:00:00 | 106 | 2029-07-18 00:00:00
deb | 12391 | February |  | 2032-06-08 00:00:00
ella | 1060 | 1996-03-03 00:00:00 | 2 | 2025-11-17 00:00:00
Spreadsheet: 704850d1605779095-editing-weekly-monthly-assignment-template-project-tracker-test
Sheet: Month View

 | ASSIGNMENTS | WEEK VIEW
 | Select Month: | Enter the Year:
 | November
 | MONTH VIEW
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Spreadsheet: 66137d1266855219-sumproduct-across-tables-100222
Sheet: Sheet1

 | Raw data extract (there can be multiple of same items in column B with varying city allocations) |  |  |  |  | Sorting | --> user maps two variables
 | ABCD1 | 3432 | CITY1 |  |  | ABCD1 | ABC |  | CITY1 | LONDON
 | DEFA1 | 564 | CITY2 |  |  | ABCE2 | ABC |  | CITY2 | PARIS
 | ABCE2 | 5334 | [NAME] |  |  | ABCF3 | ABC |  | [NAME] | NEW YORK
 | GHIY1 | 7837 | CITY1 |  |  | DEFA1 | DEF |  | CITY4 | BERLIN
 | ABCF3 | 8373 | CITY4 |  |  | DEFB2 | DEF |  | CITY5 | SINGAPORE
 | DEFB2 | 392 | CITY2 |  |  | DEFC3 | DEF
 | DEFC3 | 828 | [NAME] |  |  | GHIY1 | GHI
 | GHIZ2 | 202 | CITY5 |  |  | GHIZ2 | GHI
 | Output
 |  |  | ABC | --> user can choose this, which will alter numbers below accordingly
 | LONDON |  | 3432 | --> where formula is required to lookup sorting allocation and pick-out values from raw data accordingly
 | PARIS |  | 0
 | NEW YORK |  | 5334
 | BERLIN |  | 8373
 | SINGAPORE |  | 0
Spreadsheet: 24782d1215606414-allocating-values-over-a-range-of-months-month-spread-example-version-2-
Sheet: Sheet1

Information
work start month | spread | amount
2008-07-01 00:00:00 | 101 | 100 | this means that an order of $100 will start on 1 July, 50% will occur in the first month, zero in the second month and 50% in the third month
Question
Q1 | How can I automatically calculate the values shown below in red text
Q2 | If cell B15 contains the first date of my forecast period how can I set each of E17 to O17 automatically to be a monthly series starting at that date
first month | 2008-07-01 00:00:00
work start month | spread | amount | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 |  | checksum
2008-07-01 00:00:00 | 101 | 100 | 50 | 0 | 50 |  |  |  |  |  |  |  |  |  |  | 100
2008-08-01 00:00:00 | 1 | 150 |  | 150 |  |  |  |  |  |  |  |  |  |  |  | 150
2008-08-01 00:00:00 | 11 | 200 |  | 100 | 100 |  |  |  |  |  |  |  |  |  |  | 200
2008-09-01 00:00:00 | 1111 | 200 |  |  | 50 | 50 | 50 | 50 |  |  |  |  |  |  |  | 200
2008-10-01 00:00:00 | 1111 | 100 |  |  |  | 25 | 25 | 25 | 25 |  |  |  |  |  |  | 100
2008-11-01 00:00:00 | 1201 | 200 |  |  |  |  | 50 | 100 | 0 | 50 |  |  |  |  |  | 200
2009-01-01 00:00:00 | 111111 | 360 |  |  |  |  |  |  | 60 | 60 | 60 | 60 | 60 | 60 |  | 360
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 1310 | 50 | 250 | 200 | 75 | 125 | 175 | 85 | 110 | 60 | 60 | 60 | 60 |  | 1310
Spreadsheet: 593544d1539197872-correct-way-of-linking-data-to-master-workbook-test-sheet
Sheet: turkey green curry peanut sauce

Tomatokeftedes and Mizeria
 | Ingredients | QTY | Measurement | Macros calculated from Quantity
 |  |  |  | CAL | P | F | C
 | turkey breast mince | 2.5
 | thai green curry paste | 0.15
 | carrots | 1.6
 | Spring Onions | 2
 | yoghurt | 0.25
 | [NAME] | 0.15
 | [NAME] sauce | 0.05
 | Quinoa | 1.85
 | Sweetcorn | 1
 |  | 0.2
 |  | 0.05
 | Total - Entire Recipe
 | No. Of Servings | 2 |  | CAL | P | F | C
 | Per Serving
 | Check
 | Rounded