tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 846061d1697362320-looking-for-a-formula-that-returns-the-right-value-test
Sheet: Kostenoverzicht

[NAME] | Gewas | [NAME] | Amount
Bike | Asperge | 2024
Bike | Broccoli | 2024
Bike | Asperge | 2025
Bike | Broccoli | 2025
Bike | [NAME] | 2025
Bike | Prei | 2025
Bike | Asperge | 2026
Bike | Broccoli | 2026
Bike | [NAME] | 2026
Bike | Prei | 2026
Bike | Rabarber | 2026
Bike | Sla | 2026
Car | Asperge | 2024
Car | Broccoli | 2024
Car | Asperge | 2025
Car | Broccoli | 2025
Car | [NAME] | 2025
Car | Prei | 2025
Car | Asperge | 2026
Car | Broccoli | 2026
Car | [NAME] | 2026
Car | Prei | 2026
Car | Rabarber | 2026
Car | Sla | 2026
Spreadsheet: 21c0ae30-851d-4242-90aa-bd136c9ac299
Sheet: Sheet1

Table 4--Cottonseed:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  | Supply |  |  |  |  | Disappearance
Year begin. | Beginning |  |  |  |  |  |  |  |  | Ending
Aug. 1 | stocks | Production | Imports | Total |  | Crush | Exports | Other | Total | stocks
 |  |  |  | 1,000 short tons
2009/10 | 514.089 | 4148.8 | 24.2 | 4687.089 |  | 1900.697 | 295.523 | 2149.268 | 4345.488 | 341.601
2010/111 | 341.601 | 6098.1 | 0 | 6439.701 |  | 2562.55107 | 275.111 | 2984.47593 | 5822.138 | 617.563
2011/122 | 617.563 | 5312 | 100 | 6029.563 |  | 2400 | 225 | 2974.563 | 5599.563 | 430
1 Estimated.  2 Forecast.
Sources: Crop Production, National Agricultural Statistics Service, U.S. Department of Agriculture
and Oilseed Crushings, Census Bureau, U.S. Department of Commerce.
Last update: | 2011-12-13 14:52:48.570000
Spreadsheet: 33563d1230029859-logical-logical-
Sheet: Sheet1

 |  | Tax | 0.0971
Cust | Payment Status | Total Amt | Q1 | Tax | Q2 | Tax | Q3 | Tax | Q4 | Tax
AA | Q | 48000 | Yes | 1165.2 | Yes | 1165.2 | Yes | 1165.2 | Yes | 1165.2
BB | H | 12400 | Yes | 602.02 | Yes | 602.02 | No |  | No
CC | Y | 10000 | Yes | 971.0000000000001 | No |  | No |  | No
Spreadsheet: 332777e1-bb19-4181-a206-fa716c785402
Sheet: Miscellaneous Services

[NAME]
Item # | Item | Year | Install Price | Deinstall Price | Move Price | Relocate Price
 | Mail box | 1 | 75.02
 | (key system) | 2 | 76.14
 |  | 3 | 77.28
 |  | 4 | 78.44
 |  | 5 | 79.62
 | Program change to voice mailbox | 1 | 75.02
 | First on an order | 2 | 76.14
 | (key system) | 3 | 77.28
 |  | 4 | 78.44
 |  | 5 | 79.62
 | Program change to voice mailbox | 1 | 15 | 15 | 15 | 15
 | each additional on same order | 2 | 15.23 | 15.23 | 15.23 | 15.23
 | (key system) | 3 | 15.46 | 15.46 | 15.46 | 15.46
 |  | 4 | 15.69 | 15.69 | 15.69 | 15.69
 |  | 5 | 15.92 | 15.92 | 15.92 | 15.92
 | Active automated attendent | 1 | 300.07 | 150.03 | 100.02 | 100.02
 | Per Layer | 2 | 304.56 | 152.28 | 101.52 | 101.52
 | (key system) | 3 | 309.11 | 154.56 | 103.04 | 103.04
 |  | 4 | 313.76 | 156.88 | 104.59 | 104.59
 |  | 5 | 318.48 | 159.24 | 106.16 | 106.16
Spreadsheet: louise_kitchen__23863__6_25 daily direct cash flow
Sheet: prepay

**from [NAME], forward, the prepay will run through Global Markets, and not Enron Americas (as seen in the May spreadhseet).
[NAME]
From: | [NAME], [NAME]
Sent: | Tuesday, June 12, 2001 5:42 PM
To: | [NAME], Angeles; Rodriguez, Nadia A.
Subject: | RE: Change of Account - USD Prepay
These bank accounts are acceptable. Thank you.
-----Original Message-----
From: | [NAME], [NAME]
Sent: | Tuesday, June 12, 2001 4:20 PM
To: | Rodriguez, Nadia A.
Cc: | [NAME], [NAME]
Subject: | RE: Change of Account - USD Prepay
Nadia - I have not heard from [NAME].
Paul - Please let me know if the account below will work.
thanks, Angeles
-----Original Message-----
From: | Rodriguez, Nadia A.
Sent: | Monday, June 11, 2001 8:07 AM
To: | [NAME], Angeles
Subject: | FW: Change of Account - USD Prepay
Did [NAME] approve the bank account that the prepays will now be going through?  I hadn’t heard anything further.
[NAME]
Enron Americas
Business Analysis & Reporting
Ph: (713) 345-3946
Fax: (713) 646-8564
-----Original Message-----
From: | [NAME], [NAME]
Sent: | Wednesday, June 06, 2001 3:30 PM
To: | Bloom, [NAME]; Rodriguez, Nadia A.
Subject: | FW: Change of Account - USD Prepay
 | FYI
-----Original Message-----
From: | [NAME], [NAME]
Sent: | Wednesday, June 06, 2001 3:17 PM
To: | [NAME], [NAME]; Sammon, [NAME]; [NAME], Elaine; [NAME], [NAME]
Cc: | [NAME], [NAME]; Herrera, [NAME]; Medwedeff, [NAME]; [NAME], [NAME]
Subject: | FW: Change of Account - USD Prepay
We spoke with [NAME], legal, about the USD bank account to be used for inflows and outflows for the USD Prepay.  She agreed that changing the wiring instructions from Co. 530 Acct 4078-1075 to Co. 1021's USD bank account would not present a problem.  She has provided the contact information below for Delta and Citibank.  We will be sending a letter to to the counterparties notifying them of the change in wiring instructions.  Please let me know if you have any questions.
[NAME] - we plan to use Co. 1021's Citibank Acct # 30420778.  Please let me know if this is acceptable.
Thank you, Angeles
-----Original Message-----
From: | Herrera, [NAME]
Sent: | Wednesday, June 06, 2001 2:29 PM
To: | [NAME], Angeles
Subject: | FW: Change of Account
FYI
-----Original Message-----
From: | [NAME], [NAME]
Sent: | Wednesday, June 06, 2001 2:26 PM
To: | Herrera, [NAME]
Subject: | Change of Account
For Delta:
Delta Energy Corporation
c/o Givens Hall Bank & Trust LTd.
PO Box 1040
[NAME], 2nd Floor
N. Church Street
[NAME], Grand Cayman
Cayman Islands, British West Indies
Attn:  [NAME]
Fax   [PHONE]
Phone  [PHONE]
and
Delta Energy Corporation
PO Box 309
Grand Cayman, Cayman Islands
British West Indies
[NAME]
Fax  [PHONE]
For Citibank:
Citibank, N.A.
333 West 34th Street, 2nd Floor
NY, NY   10001
Attention:  Confirmation Unit
Fax  212 615  8985
Phone  [PHONE]
and
Cordially,
[NAME]
Enron North America Corp.
1400 Smith, 38th Floor, Legal
Houston, Texas   77002-7361
(713) 345-7732 (phone)
(713) 646-3490 (fax)
[EMAIL] <mailto:[EMAIL]> <<mailto:[EMAIL]>>
Spreadsheet: michelle_lokay__26561__imbalsumm0012
Sheet: williams

 | La Maquina |  | Milagro |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 41033 | 47479 | 386304 | 382606 | 38081 | 48634 | 153724 | 143155
2 | 59989 | 71232 | 403458 | 384185 | 36007 | 36585 | 151696 | 152989
3 | 64884 | 73689 | 391197 | 397054 | 43616 | 48634 | 171875 | 151856
4 | 72845 | 72969 | 370233 | 375070 | 41520 | 48634 | 162638 | 146490
5 | 86850 | 87100 | 349554 | 354190 | 45007 | 48634 | 129789 | 115758
6 | 73245 | 63737 | 393698 | 399032 | 45036 | 47052 | 160393 | 159872
7 | 75161 | 67069 | 354762 | 357960 | 47482 | 49634 | 86575 | 170091
8 | 74164 | 64177 | 360958 | 364836 | 43337 | 49634 | 165147 | 160172
9 | 79821 | 70948 | 376404 | 367006 | 36696 | 49445 | 155105 | 159892
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  |  |  |  |  |  |  | -34361
2000-12-09 00:00:00
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: sally_beck__35257__consolidated for 12 04
Sheet: Listing of report

Quantitative Standards
Daily Exception Reports
Summary of Reports
Reporting against quantitative standards
A | Transactions are recorded accurately and timely
 | 01 | To capture transactions either not input or input but not valued in the Risk Management System.
B | Daily management P&L and Position reporting is accurate and timely
 | 01 | To capture when reporting to DPR group was received late (to be performed only by Houston Risk Controls group).
C | Timely confirmation and execution of transactions
 | 01 | To capture what brokers were not confirmed with on the same day (or exceptions to your standard - please indicate standard)
 | 02 | To capture what confirmations (non-exchange as exchange is reported in C01) were 1) not sent out within 24 hours of the trade execution and 2) what incoming confirmations you have not received with 48 hours (or exceptions to your standard - please indicate standard).
 | 03 | To capture what incoming & outgoing confirmations have not been completely executed with 7 days (or exception to your standard -  please indicate standard)
D | Settlements with counterparties occurs accurately and timely (non CACS, non DASHED deals)
 | 01 | To capture disputes over 30 days and overdue cash collections.
E | Operating system data matches Risk Systems and General Ledger Data
 | NA
Spreadsheet: 53259d1253172618-locking-values-example_md
Sheet: Output

Name | Period 1 Jul | Period 2 Aug | Period 3 Sep | Period 4 Oct | Period 5 Nov | Period 6 Dec | Period 7 Jan | Period 8 Feb | Period 9 Mar | Period 10 Apr | Period 11 May | Period 12 Jun
SMITH JOE
Work | 8
Leave | 9
Maintenance | 11
Training | 2
 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JONES BOB
Work | 5
Leave | 6
Maintenance | 4
Training | 5
 | 20 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME]
Work | 1
Leave | 2
Maintenance | 8
Training | 9
 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GREG HARRY
Work | 9
Leave | 8
Maintenance | 5
Training | 4
 | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PHIL BRIAN
Work | 3
Leave | 6
Maintenance | 4
Training | 15
 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BROWN SIMON
Work | 18
Leave | 2
Maintenance | 3
Training | 6
 | 29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: kevin_ruscitti__20284__Dec_Mich_Sales
Sheet: Sheet1

NX1: | 6.016
 |  | Volume | Price
Michcon:
 |  | 8288 | 6.06
 |  | 10000 | 6.0475
 |  | 10000 | 6.06
 |  | 10000 | 6.11
 |  | 1615 | 6.0725
 |  | 347 | 6.075
 |  | 5000 | 6.1175
 |  | 5000 | 6.13
 |  | 10000 | 6.016
 |  | 112 | 6.1075
 |  | 5000 | 6.095
 |  | 5000 | 6.0535
 |  | 5000 | 6.115
 |  | 1879 | 6.1875
 |  | 20000 | 6.051
 |  | 162 | 6.22
 |  | 2000 | 6.1975
 |  | 6000 | 6.255
Consumers:
 |  | 10000 | 6.155
 |  | 10000 | 6.19
 |  | 3173 | 6.175
 |  | 1200 | 6.1575
 |  | 10000 | 6.2225
 |  | 5500 | 6.105
 |  | 5000 | 6.1025
 |  | 10000 | 6.1225
 |  | 5000 | 6.175
 |  | 10000 | 6.25
 |  | 2000 | 6.235
 |  | 5000 | 6.305
 |  | 5000 | 6.275
 |  | 1129 | 6.3425
 |  | 1500 | 6.2775
 |  | 3000 | 6.3025
 |  | 5000 | 6.23
 |  | 10000 | 6.091
 |  | 10000 | 6.086
ML7: |  | 10000 | 6.131
 |  | 688 | 6.1435
 |  | 1480 | 6.156
 |  | 637 | 6.176
 |  | 1425 | 6.196
 |  | 20000 | 6.181
Spreadsheet: bfd37180-f801-4505-a2fd-df6ac19e51e8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  |  |  |  | 第26表 | 高齢者対応型共同住宅の別(2区分)，オートロックの別(2区分)，
 |  |  |  |  |  |  |  | エレベーターの有無(4区分)別共同住宅数―全国
 |  |  |  |  |  |  | Table 26. | Apartments by Designed for Aged People (2 Groups), According to the Auto Lock (2 Groups)
 |  |  |  |  |  |  |  | and Existence of Elevator (4 Groups) - Japan
 |  |  |  |  |  |  | 高齢者対応型共同住宅の別 (2区分), オートロックの別 (2区分) |  | 総　数 | エレベーターの有無　　　　　　　Existence of elevator
 |  |  |  |  |  |  |  |  |  | あ　り |  |  |  | な　し
 |  |  |  |  |  |  |  |  |  |  | ドアの一部が ガラス張り | 防犯カメラの設置 | これらの設備はない
 |  |  |  |  |  |  | Designed for aged people (2 Groups) and according to the auto lock (2 Groups) |  |  |  | Some doors fitted with glass | With security camera
 |  |  |  |  |  |  |  |  | Total | With elevator |  |  | Without facilities | Without elevator
 |  |  |  |  |  |  |  |  |  | 1)
 |  |  |  |  |  |  | 全　　　　　　　　　  　　　国 | Japan
26 | 0 |  |  |  | 1 |  | 共　  同　  住　  宅　 総　 数 | 33-J | 20694300 | 8539300 | 5243200 | 4583300 | 1541600 | 12155000
26 | 0 |  |  |  | 2 |  | 高 齢 者対応型共同住宅である | 7-A | 3341900 | 3153800 | 2260100 | 2087000 | 228300 | 188000
26 | 0 |  |  |  | 3 |  | オ　ー　ト　ロ　ッ　ク　式 | 8-A | 2077800 | 2053700 | 1437300 | 1543700 | 114800 | 24100
26 | 0 |  |  |  | 4 |  | オートロック式 で は な い | 8-B | 1264100 | 1100100 | 822800 | 543300 | 113500 | 164000
26 | 0 |  |  |  | 5 |  | 高齢者対応型共同住宅ではない | 7-B | 17352400 | 5385500 | 2983100 | 2496300 | 1313200 | 11967000
26 | 0 |  |  |  | 6 |  | オ　ー　ト　ロ　ッ　ク　式 | 8-A | 3378500 | 2706000 | 1574900 | 1487400 | 459000 | 672500
26 | 0 |  |  |  | 7 |  | オートロック式 で は な い | 8-B | 13973900 | 2679400 | 1408200 | 1008900 | 854200 | 11294500
 |  |  |  |  |  |  | 1)　複数回答であるため，内訳の合計とは必ずしも一致しない。 |  |  | 1)  The numbers do not necessarily add up to the total because the question can have multiple answers.
Spreadsheet: 99632d1298248121-help-with-excel-solver-math-homework-unit-6
Sheet: Sheet1

 |  |  | Station B
 |  | [NAME] | New Program | Home Improvement | Rowmin
 |  | b1 | b2 | b3
 | [NAME] a1 | 10 | -5 | 3 | -5
Station A | News Program a2 | 8 | 7 | 6 | 6 | Maxmin
 | Home Improvement a3 | 4 | 8 | 7 | 4
Maximum |  | 10 | 8 | 7
 |  |  |  | Minimum
 | PA | > | 0
 | PB | > | 0
 | PC | > | 0
 | GAINA | = | 0
Spreadsheet: 76557d1277116488-help-on-lookup-table-for-ticketing-ticket-logger
Sheet: Tickets

Ticket Number | Department | Ticket Reference
14 | DS | DS014
13 | DS | [NAME]
12 | DS | DS012
11 | DS | DS011
10 | DS | DS010
9 | DS | DS009
8 | DS | DS008
7 | MIS | [NAME]
6 | MIS | MIS006
5 | MIS | MIS005
4 | DS | [NAME]
3 | MIS | MIS003
2 | MIS | MIS002
1 | DS | DS001
Spreadsheet: 119782d1314737724-transpose-a-reference-moviemodelprogress
Sheet: start times

[NAME] | Senna | Aquinas | Duel | Sugarland Express | Suntrust
2011-08-29 18:00:00 | 2011-08-29 16:45:00 | 2011-08-31 16:30:00 | 2011-08-29 20:10:00 | 2011-08-29 22:05:00 | 2011-08-30 18:00:00
2011-08-30 15:50:00 | 2011-08-29 19:00:00
2011-08-30 21:20:00 | 2011-08-29 21:10:00
2011-08-31 16:45:00 | 2011-08-30 16:45:00
2011-09-01 18:00:00 | 2011-08-30 19:00:00
2011-09-01 20:15:00 | 2011-08-30 21:10:00
 | 2011-09-01 16:45:00
 | 2011-09-01 19:00:00
 | 2011-09-01 21:10:00
Spreadsheet: 714008d1611059843-if-statement-with-embedded-today-formula-sample-error
Sheet: Sheet1

Company incorporated date | Today | Incorporation Date Format Formula | Copy/Paste Acts Due Date | Incorporation Date - EOM | Approx Account due date | 1st [NAME] (11 months) - Acts & CS | 2nd Email Contact (13 months) | Deadline Approaching (<2 months) | Overdue (1 month)
20201104 | =IF((F3-TODAY())>11)), "AMBER","FALSE")' |  | 04-11-2020
20201104 |  |  | 04-11-2020
Spreadsheet: darrell_schoolcraft__7346__imball0201
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -248536 | -247815
2 | -256988 | -257667
3 | -177704 | -177700
4 | -184043 | -182700
5 | -102760 | -120064
6 | -159504 | -157450
7 | -146645 | -155851
8 | -147570 | -155884
9 | -67555 | -76928
10 | -98016 | -106532
11 | -99217 | -97700
12 | -157690 | -156351
13 | -159519 | -157722
14 | -161298 | -157663
15 | -199783 | -198440
16 | -183992 | -183889
17 | -190001 | -177700
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 59071
2002-01-17 00:00:00
CBS Dollars
 |  |  | -80543.15
Spreadsheet: 110147d1306913610-finding-if-price-data-between-cells-satisfies-conditions-findvalue
Sheet: Sheet1

 | Price |  | Action | Test Y to 1st x back | Test Y to 2nd x back | Test Y to 3rd x back | etc
2009-04-10 00:00:00 | 94.45 | x |  | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank
2009-04-17 00:00:00 | 121 | x |  | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank
2009-04-24 00:00:00 | 93.3 |  |  | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank
2009-05-01 00:00:00 | 93.5 | x |  | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank
2009-05-08 00:00:00 | 93.2 |  |  | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank
2009-05-15 00:00:00 | 94.65 |  |  | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank
2009-05-22 00:00:00 | 100.5 | x | Y | [NAME] is Y in column.  Therefore test 1st 'x' back from current row.  Test: Price in cell B5 (first x back) is < at least one price in cells B6:B7, therefore result is "false" | Test 2nd x back from current row.  Test: Price at B3 is > all prices between B4:B7, therefore test is "true" | Test 3rd x back from current row.  Test: Price in cell B2 is < at least one price in cells B4:B7, therefore result is "false" | Indicates if cell(d8)= Y then find if price at previous x is > than all prices from x+1 to subsequent Y
2009-05-29 00:00:00 | 103.7 |  |  | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank
2009-06-05 00:00:00 | 102.1 |  |  | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank
2009-06-12 00:00:00 | 100 | x |  | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank
2009-06-19 00:00:00 | 99.9 |  |  | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank
2009-06-26 00:00:00 | 103.3 |  |  | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank
2009-07-03 00:00:00 | 94.65 |  | Y | False | False | False | Indicates if cell(d14)= Y then find if price at previous x is > than all prices from x+1 to subsequent Y
2009-07-10 00:00:00 | 93.5 |  |  | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank
2009-07-17 00:00:00 | 103.7 |  |  | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank | no "Y" in column D, therefore show blank
 |  | Test is to see if in column D = 'Y' then test to find if price at previous x is > or < than all prices from x+1 to subsequent Y
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 560082 | 616033
78311 | 384996 | 380999 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
78308 | 9592 |  |  |  |  |  |  |  |  |  | lunch | 7.6
500238 | 543790 | 588151
500239 | 711205 | 614083
500293 | 273732 | 364771
500302 |  | 4997
500303 |  | 28264
500305 | 862636 | 950211
500307 |  | 38304
500313 |  | 1818
500314
500655 | 140900
500657 | 70239 | 39500
INDEX
2002-02-28 00:00:00 |  |  | 38489.3
2002-03-18 00:00:00
CBS Volume
 |  |  | 31234
Spreadsheet: 775409d1649086590-automation-for-excel-updations-from-one-sheet-to-another-some-dummy-data
Sheet: database sheet

Network | Platform | Domestic / International | Type | Deal Status | helper
A | XX | Domestic | B'Cast Linear | DEAL
A | SFAFSFS | Domestic | B'Cast Linear | Target
A | tbyu | Domestic | B'Cast Linear | Deal
A | DD | Domestic | B'Cast Linear | Target
A | FF | Domestic | B'Cast Linear | Deal
A | fvfvvffngh | Domestic | vMVPD | DEAL
A | RSGSDFDS | International | vMVPD | DEAL
A | XZXCFDDF | Domestic | [NAME] | DEAL
A | hvgvuvjhvu | Domestic | [NAME] | DEAL
A | fhfu8fufh | International | [NAME] | DEAL
B | gf86btff | Domestic | B'Cast Linear | DEAL
B | dddsdd | Domestic | [NAME] | DEAL
B | sfjsfsf9 | Domestic | [NAME] | DEAL
B | fiffis | International | [NAME] | DEAL
B | [NAME] | Domestic | B'Cast Linear | DEAL
B | ytb786t6 | Domestic | B'Cast Linear | Target
B | ijhn76t65rf | International | vMVPD | Active
B | i0i0 | Domestic | vMVPD | DEAL
B | jhhj | Domestic | B'Cast Linear | DEAL
B | ihgn7nff | Domestic | B'Cast Linear | Target
C | 9ug8tt8m | International | B'Cast Linear | DEAL
C | hign8tf5tf | Domestic | B'Cast Linear | Target
C | hg6nm | Domestic | vMVPD | Active
C | huyn | Domestic | vMVPD | DEAL
C | junmgtgf | Domestic | vMVPD | DEAL
C | gf76rfrf | Domestic | B'Cast Linear | Target
C | gyb6tft | Domestic | B'Cast Linear | Active
C | fdtrsc63w | Domestic | B'Cast Linear | DEAL
Spreadsheet: 720969d1614406519-match-the-value-from-a-cell-and-compare-to-one-line-of-data-and-paste-into-a-table-match-a-value-add
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMPOUND NUMBER CHECK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | 2 | 9 | 0 | 3 | 1 | 9 | 9 | 1 | 1952-06-02 00:00:00 |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 5 | 0 | 2 | 2 | 0 | 2 | 1 | 2021-02-25 00:00:00 |  |  |  |  |  |  | L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  | 4 | 4 | 4 | 9 |  |  |  |  | 9 | 9 | 9 | 2 |  |  |  |  |  | 2 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thank you so much it solved my problem
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  | 3 | 3 | 3 | 5 |  |  |  |  | 5 | 5 | 5 | 7 |  |  |  |  |  | 6 | 6 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | need a little help with a formula for as4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AQ4 sums the total ae2 to ah2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 8 | 8 | 8 | 1 |  |  |  |  | 1 | 1 | 1 | 6 |  |  |  |  |  | 6 | 6 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | need help with a formula that if
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if z2 = M(ale) the we have to subtract 11 from the value in Aq4 and results reduced to single
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | digit and paste into as4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is z2 = F(emale) the we have to add 4 to the value in Aq4 and the result reduced to single digit and paste in as4
Spreadsheet: 878000d1724951736-display-what-is-left-on-a-6-day-goal-based-on-how-much-is-completed-and-days-left-flc-sample
Sheet: Sheet1

 |  |  | Front Line Commitment execution
 |  |  | Last week's commitments |  |  |  | This weeks production |  |  |  |  |  |  |  |  |  |  | This week's FLC Goals
 |  |  | Last weeks FLC targets | FLC actual | Gap to last weeks target
 |  |  |  |  |  |  | Mon | [NAME] | Wed | Thur | Fri | Sat | Total | Needed per day | Left to hit goal
 | Atlanta |  | 125 | 125 |  |  | 11 | 20 | 15 |  |  |  |  |  |  |  |  | 130
 | [NAME] |  | 310 | 316 |  |  | 27 | 48 | 67 |  |  |  |  |  |  |  |  | 330
 | Houston |  | 185 | 199 |  |  | 31 | 32 | 40 |  |  |  |  |  |  |  |  | 220
 | St Louis |  | 30 | 54 |  |  | 2 | 12 | 12 |  |  |  |  |  |  |  |  | 30
 |  |  | Last week's FLC
 |  |  | total target | total achieved
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  | Region FLC performance  to Goal