tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 41408d1239880068-working-with-lookups-lookup-macro
Sheet: result 

Date | Ref | Mem No. | Name | Amount to  Release | Amount Received
2009-04-14 00:00:00
2009-04-14 00:00:00
2009-04-14 00:00:00
2009-04-14 00:00:00
2009-04-14 00:00:00
Spreadsheet: 221335d1363476348-adding-two-seperate-drop-down-lists-still-crazy-pay-roll
Sheet: Sheet1

Driver |  | Date |  | Load # |  | Pick-Up |  | Drop-Off |  | [NAME] |  | Rate |  | [NAME]
 |  |  |  |  |  | Auburn,ME |  | Cincinnati,OH |  |  |  | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Here are some links you may want to look at
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://www.ozgrid.com/forum/showthread.php?t=86708
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://www.ozgrid.com/forum/showthread.php?t=28210
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://stackoverflow.com/questions/3985887/how-can-i-extract-the-distance-from-google-directions-api-via-excel-web-query
Load Total
Com Check
Check Total
Fuel Cost
Tolls
[NAME].
Cash Back
Cash Kept |  |  |  |  |  |  |  |  |  |  |  | Total Pay
Spreadsheet: 273589d1382771166-rearranging-datewise-horizontally-in-a-specified-format-from-raw-data-breakdown-of-array-formula
Sheet: Result

Date | Name of Party | Particulars | Vch No. | Reference No. | Taxable Purchase | Taxable Import | [NAME] | [NAME] in Custom | Excise Duty | Total | TDS
Spreadsheet: 59925d1260450223-formula-query-possible-if-function-costing-example
Sheet: All Works

Project No. | Expected Month of Work | Site | Cost | Site Start Date | Site Completion Date
J16022 | January | High Street, Tenterden, [NAME] | 695
J16023 | December | Royal Hospital | 995 | 2008-12-24 00:00:00
J16024 | December | Kingsland House | 795
[NAME] | January | 43 [NAME] | 495 | 2009-01-08 00:00:00 | 2009-01-08 00:00:00
J16026 | January | 900 Kingsbury Road | 495 | 2009-01-08 00:00:00 | 2009-01-08 00:00:00
J16027 | January | Crewe First Class Lounge | 750 | 2009-01-06 00:00:00 | 2009-01-06 00:00:00
J16028 | January | 242 Fairway Court |  | 2009-01-05 00:00:00
J16029 | January | [NAME] | 3000 | 2009-01-07 00:00:00 | 2009-01-09 00:00:00
[NAME] | January | Albion Street | 2485 | 2009-01-13 00:00:00 | 2009-01-15 00:00:00
J16031 | January | Travel Shop | 1125 | 2009-01-12 00:00:00 | 2009-01-12 00:00:00
J16032 | February | BUPA Offices | 10453 | 2009-01-12 00:00:00 | 2009-02-15 00:00:00
J16033 | February | 49 Jenkin Road | 595 | 2009-01-12 00:00:00 | 2009-02-03 00:00:00
J16034 | January | [NAME] | 2200 | 2009-01-19 00:00:00 | 2009-01-20 00:00:00
 |  |  | 24083 |  | 21598
 |  |  | Expected |  | Actual
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 13b

Product1 | HY3 | IG | Other | TOTAL
Index Tranche | 64001 | 508738 | 487203 | 1059942
Europe | - | - | 481235 | 481235
North America/Asia | 64001 | 508738 | 5968 | 578707
Other | - | - | - | -
Index | 764981 | 3022415 | 4047272 | 7834668
Asia | - | - | 129214 | 129214
Europe | - | - | 3497013 | 3497013
North America | 764981 | 3022415 | 122054 | 3909450
Other | - | - | 298991 | 298991
OTHER* | - | - | 561499 | 561499
TOTAL | 828982 | 3531153 | 5095974 | 9456109
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 889689d1740597052-converting-decimals-to-dice-rolls-dice-limits_4
Sheet: Sheet1

 | 0.5477926779041045 | 0.4367489902157193 | 0.3466226332217783 | 0.5303073754276612 | 0.2491469340337321 | 0.6463583564874866 | 0.513186270935622 | 0.7792890097239141 | 0.5373486366995378 | 0.5805956467306749
formula | 42 | 34 | 26 | 41 | 23 | 45 | 36 | 53 | 41 | 42
s/b | 42 | 34 | 26 | 41 | 23 | 45 | 36 | 54 | 41 | 43
 |  |  |  |  |  |  | 1e dice |  | 2e dice
 |  | 0.02777777777777778 | 11 |  |  |  | 1 | 1 | 1 | 1 |  |  | 0.5 | 36
 |  | 0.05555555555555555 | 12 |  |  |  | 1 | 2 | 2 | 2
 |  | 0.08333333333333333 | 13 |  |  |  | 1 | 3 | 3 | 3
 |  | 0.1111111111111111 | 14 |  |  |  | 1 | 4 | 4 | 4
 |  | 0.1388888888888889 | 15 |  |  |  | 1 | 5 | 5 | 5
 |  | 0.1666666666666667 | 16 |  |  |  | 1 | 6 | 0 | 6
 |  | 0.1944444444444444 | 21 |  |  |  | 2 | 7 | 1 | 1
 |  | 0.2222222222222222 | 22 |  |  |  | 2 | 8 | 2 | 2
 |  | 0.25 | 23 |  |  |  | 2 | 9 | 3 | 3
 |  | 0.2777777777777778 | 24 |  |  |  | 2 | 10 | 4 | 4
 |  | 0.3055555555555556 | 25 |  |  |  | 2 | 11 | 5 | 5
 |  | 0.3333333333333333 | 26 |  |  |  | 2 | 12 | 0 | 6
 |  | 0.3611111111111111 | 31 |  |  |  | 3 | 13 | 1 | 1
 |  | 0.3888888888888889 | 32 |  |  |  | 3 | 14 | 2 | 2
 |  | 0.4166666666666667 | 33 |  |  |  | 3 | 15 | 3 | 3
 |  | 0.4444444444444444 | 34 |  |  |  | 3 | 16 | 4 | 4
 |  | 0.4722222222222222 | 35 |  |  |  | 3 | 17 | 5 | 5
 |  | 0.5 | 36 |  |  |  | 3 | 18 | 0 | 6
 |  | 0.5277777777777778 | 41 |  |  |  | 4 | 19 | 1 | 1
 |  | 0.5555555555555556 | 42 |  |  |  | 4 | 20 | 2 | 2
 |  | 0.5833333333333334 | 43 |  |  |  | 4 | 21 | 3 | 3
 |  | 0.6111111111111112 | 44 |  |  |  | 4 | 22 | 4 | 4
 |  | 0.6388888888888888 | 45 |  |  |  | 4 | 23 | 5 | 5
 |  | 0.6666666666666666 | 46 |  |  |  | 4 | 24 | 0 | 6
 |  | 0.6944444444444444 | 51 |  |  |  | 5 | 25 | 1 | 1
 |  | 0.7222222222222222 | 52 |  |  |  | 5 | 26 | 2 | 2
 |  | 0.75 | 53 |  |  |  | 5 | 27 | 3 | 3
 |  | 0.7777777777777778 | 54 |  |  |  | 5 | 28 | 4 | 4
 |  | 0.8055555555555556 | 55 |  |  |  | 5 | 29 | 5 | 5
 |  | 0.8333333333333334 | 56 |  |  |  | 5 | 30 | 0 | 6
 |  | 0.8611111111111112 | 61 |  |  |  | 6 | 31 | 1 | 1
 |  | 0.8888888888888888 | 62 |  |  |  | 6 | 32 | 2 | 2
 |  | 0.9166666666666666 | 63 |  |  |  | 6 | 33 | 3 | 3
 |  | 0.9444444444444444 | 64 |  |  |  | 6 | 34 | 4 | 4
 |  | 0.9722222222222222 | 65 |  |  |  | 6 | 35 | 5 | 5
 |  | 1 | 66 |  |  |  | 6 | 0 | 0 | 6
Spreadsheet: 797923d1664213454-only-show-rows-that-match-tab-name-until-a-new-row-value-2022-09-26-oeldere-rafael1024-sample-excel-zones-v1
Sheet: Data

Zone Group | Zone
North | a
North | b
North | c
North | d
North | e
North | f
North | g
East | 2
East | 4
East | 6
East | 8
South | r1
South | r2
South | r3
South | r4
South | r5
South | r6
South | r7
West | 1a
West | 2a
West | 3a
Spreadsheet: 713599d1610820730-bulding-a-schedule-index-aggregate-dexter2-2-ef-1-16-21
Sheet: Summary

Vehicle | Start | End | # of Service Trips | Service | Break | Deadhead | Duration | Service Miles | [NAME] | Total Mileage
101 | 05:25:00 | 09:27:00 | 5 | 3:30:00 |  | 0:20:00 |  | 25 | 2.25
102 | 05:55:00 | 18:57:00 | 15 | 10:30:00 |  | 0:20:00 |  | 75 | 2.25
103 | 06:10:00 | 09:17:00 | 4 | 2:48:00 |  | 0:10:00 |  | 20 | 1.5
104 | 06:15:00 | 08:12:00 | 2 | 1:24:00 |  | 0:30:00 |  | 70 | 3
105 | 06:25:00 | 18:32:00 | 14 | 9:48:00 |  | 0:10:00 |  | 70 | 1.5
106 | 06:40:00 | 23:02:00 | 18 | 12:36:00 |  | 0:10:00 |  | 90 | 1.5
109 | 07:45:00 | 18:27:00 | 12 | 8:24:00 |  | 0:30:00 |  | 60 | 3
107 | 15:10:00 | 23:47:00 | 10 | 7:00:00 |  | 0:10:00 |  | 50 | 1.5
108 | 15:15:00 | 21:32:00 | 7 | 4:54:00 |  | 0:20:00 |  | 35 | 2.25
Totals
Spreadsheet: 702462d1604362732-creating-formula-to-compute-outstanding-with-tie-to-specific-accounts-saving-vs-expense-1
Sheet: Sheet1

Expense Account | Expense Acct OS | Saving Account | Saving Acct OS | Working | exclude | Count SA | Saving Acct OS | Count Exp | Expense Acct OS | SA Portion to Cover Expense
4000000740 | 0 | 1733039065 | 0
4000247997 | 0 | 1733039065 | 0 |  |  |  |  |  |  |  | Desired Results: For Illustration Purpose
4000247997 | 0 | 3468007124 | 1517154.5 |  |  |  |  |  |  |  | Expense Account | Expense Acct OS | Saving Acct | Saving Acct OS | SA Portion to Cover Expense
4000249717 | 0 | 3468007124 | 1517154.5 |  |  |  |  |  |  |  | 8000359476 | 11600000 | 3468024819 | 9306381.2
4000356297 | 0 | 3468011598 | 6498224.73 |  |  |  |  |  |  |  | 8000357341 | 12000000 | 3468024800 | 18600894.47
4000395771 | 0 | 3468024800 | 18600894.47 |  |  |  |  |  |  |  | 8000357342 | 12000000
4000399720 | 0 | 3468024819 | 9306381.2 |  |  |  |  |  |  |  | 4000000733 | 14557052.68 | WONDA346PG | 374775.75
4000000740 | 0 | AGROSDBH346SG | 0 |  |  |  |  |  |  |  |  |  | WONDA346BA | 66166000
4000247997 | 0 | AGROSDBH346SG | 0 |  |  |  |  |  |  |  | 8000230852 | 24000000 | 3468011598 | 6498224.73
4000000740 | 0 | AGROSDBH346PG | 374775.75 |  |  |  |  |  |  |  |  |  | 3468007124 | 1517154.5
4000247997 | 0 | AGROSDBH346PG | 374775.75 |  |  |  |  |  |  |  | Total
4000000740 | 0 | AGROSDBH346LC | 0
4000247997 | 0 | AGROSDBH346LC | 0
4000000740 | 0 | AGROSDBH346BA | 66166000
4000247997 | 0 | AGROSDBH346BA | 66166000
4000000740 | 0 | AGROSDBH346IL | 0
4000000740 | 0 | AGROSDBH346IL | 0
4000247997 | 0 | AGROSDBH346IL | 0
4000247997 | 0 | AGROSDBH346IL | 0
4000000740 | 0 | AGROSDBH346IB | 0
4000000740 | 0 | AGROSDBH346IB | 0
4000247997 | 0 | AGROSDBH346IB | 0
4000247997 | 0 | AGROSDBH346IB | 0
4000000733 | 14557052.68 | 1733039065 | 0
4000000733 | 14557052.68 | AGROSDBH346LC | 0
4000000733 | 14557052.68 | AGROSDBH346IL | 0
4000000733 | 14557052.68 | AGROSDBH346PG | 374775.75
4000000733 | 14557052.68 | AGROSDBH346BA | 66166000
4000000733 | 14557052.68 | AGROSDBH346SG | 0
4000000733 | 14557052.68 | AGROSDBH346IL | 0
4000000733 | 14557052.68 | AGROSDBH346IB | 0
4000000733 | 14557052.68 | AGROSDBH346IB | 0
8000230852 | 24000000 | 3468011598 | 6498224.73
8000230852 | 24000000 | 3468007124 | 1517154.5
8000230852 | 24000000 | 3468011598 | 6498224.73
8000357341 | 12000000 | 3468024800 | 18600894.47
8000357342 | 12000000 | 3468024800 | 18600894.47
8000359476 | 11600000 | 3468024819 | 9306381.2
Spreadsheet: 539949d1506442943-sumif-formula-giving-me-a-bit-of-trouble-team-member-variance-log
Sheet: SEPT 2017 if Correct

 | CAGE | [NAME] | [NAME] | Total
FRI | 2017-09-01 00:00:00 |  | 55 |  | No Points LB
SAT |  | 5
SUN
MON
TUE |  |  | 5
WED
THU |  | 1
FRI
SAT |  | 1
SUN
MON
TUE
WED
THU
FRI
SAT
SUN |  | -10 |  |  | No Points LB
MON
TUE
WED
THU |  | 3
FRI
SAT
SUN
MON
TUE
WED
THU
FRI
SAT
Total
 | Points | 0.25 | 0.25
Spreadsheet: darrell_schoolcraft__7222__saledoc12_4TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2001-12-11 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 12/12/2001 |  |  | FAX Number:
Total Quantity |  |  | 20000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.66
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
12/12/01 | 2001-12-12 00:00:00 | 20000 |  | 20000 |  | 20000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
California Border |  |  | 10487 |  | 10000 |  |  |  | 22940
May Sell @ PG&E |  |  | 56698 |  | 10000 |  |  |  | 22940
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 728461d1618478097-formula-for-match-report-02
Sheet: WK03

Week 03
KPI |  |  | Delivery Performance
Service Type |  |  | TA |  |  | AM |  |  | A |  |  | True A (A - TA & AM) |  |  | B-D |  |  | Total Performance
Depot Number | Region | On [NAME] | Due | Suc. | % | Due | Suc. | % | Due | Suc. | % | Due | Suc. | % | Due | Suc. | % | Due | Suc. | %
Spreadsheet: 0600ab45-9bce-4fee-9b6d-aa87a24a4b99
Sheet: Sheet1

Table 1--U.S. rice supply and use  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14
 |  |  |  |  |  |  | 2/
TOTAL RICE |  |  |  | Million acres
Area:
Planted | 2.761 | 2.995 | 3.135 | 3.636 | 2.689 | 2.7 | 2.489
Harvested | 2.748 | 2.976 | 3.103 | 3.615 | 2.617 | 2.679 | 2.468
 |  |  |  | Pounds per harvested acre
Yield | 7219 | 6846 | 7085 | 6725 | 7067 | 7449 | 7694
 |  |  |  | Million cwt
Beginning stocks | 39.315 | 29.492 | 30.419 | 36.499 | 48.467 | 41.079 | 36.423
Production | 198.388 | 203.733 | 219.85 | 243.104 | 184.941 | 199.546 | 189.886
Imports | 23.9 | 19.218 | 19.023 | 18.338 | 19.359 | 21.062 | 21
Total supply | 261.603 | 252.443 | 269.292 | 297.941 | 252.767 | 261.687 | 247.309
Food, industrial,
& residual 3/ | 123.152 | 123.77 | 119.947 | 133.603 | 107.505 | 115.105
Seed | 3.697 | 3.87 | 4.488 | 3.324 | 3.332 | 3.067
Total domestic use | 126.849 | 127.64 | 124.435 | 136.927 | 110.837 | 118.172 | 120
Exports | 105.262 | 94.384 | 108.358 | 112.547 | 100.851 | 107.092 | 99
Rough | 37.663 | 31.633 | 40.351 | 34.595 | 32.94 | 34.165 | 35
Milled 4/ | 67.599 | 62.751 | 68.007 | 77.952 | 67.911 | 72.927 | 64
Total use | 232.111 | 222.024 | 232.793 | 249.474 | 211.688 | 225.264 | 219
Ending stocks | 29.49200000000002 | 30.41899999999998 | 36.49900000000002 | 48.46700000000004 | 41.07900000000004 | 36.423 | 28.309
 |  |  |  | Percent
Stocks-to-use ratio | 12.70598980660116 | 13.70077108781032 | 15.6787360444687 | 19.42767582994622 | 19.40544575034959 | 16.16902834008097 | 12.92648401826484
 |  |  |  | $/cwt
Average farm |  |  |  |  |  |  | 15.30 to
price 5/ | 12.8 | 16.8 | 14.4 | 12.7 | 14.5 | 14.9 | 16.3
 |  |  |  | Percent
Average
milling rate | 69.88 | 70.83 | 71.53 | 68.86 | 69.93 | 70 | 70.25
N/A = not available.  1/ August-July market year; rough equivalent.  2/ Projected.  3/ Residual includes unreported
use, processing losses, and estimating errors.  4/  Rough-rice equivalent.  5/ Market-year weighted average.
Source: World Agricultural Supply and Demand Estimates, WAOB, USDA.
Updated January 10, 2014.
Spreadsheet: 148179d1333224262-formula-for-register-long-and-shorts-register-long-shorts
Sheet: March

March | Number of shortages | Value of shortages | 2012-03-01 00:00:00 | 2012-03-02 00:00:00 | 2012-03-03 00:00:00 | 2012-03-04 00:00:00 | 2012-03-05 00:00:00 | 2012-03-06 00:00:00 | 2012-03-07 00:00:00 | 2012-03-08 00:00:00 | 2012-03-09 00:00:00 | 2012-03-10 00:00:00 | 2012-03-11 00:00:00 | 2012-03-12 00:00:00 | 2012-03-13 00:00:00 | 2012-03-14 00:00:00 | 2012-03-15 00:00:00 | 2012-03-16 00:00:00 | 2012-03-17 00:00:00 | 2012-03-18 00:00:00 | 2012-03-19 00:00:00 | 2012-03-20 00:00:00 | 2012-03-21 00:00:00 | 2012-03-22 00:00:00 | 2012-03-23 00:00:00 | 2012-03-24 00:00:00 | 2012-03-25 00:00:00 | 2012-03-26 00:00:00 | 2012-03-27 00:00:00 | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | 2012-03-30 00:00:00 | 2012-03-31 00:00:00
Cashier 1
Cashier 2
Cashier 3
Cashier 4
Cashier 5
Cashier 6
April | Number of shortages | Value of shortages | 2012-04-01 00:00:00 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00 | 2012-04-07 00:00:00 | 2012-04-08 00:00:00 | 2012-04-09 00:00:00 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2012-04-12 00:00:00 | 2012-04-13 00:00:00 | 2012-04-14 00:00:00 | 2012-04-15 00:00:00 | 2012-04-16 00:00:00 | 2012-04-17 00:00:00 | 2012-04-18 00:00:00 | 2012-04-19 00:00:00 | 2012-04-20 00:00:00 | 2012-04-21 00:00:00 | 2012-04-22 00:00:00 | 2012-04-23 00:00:00 | 2012-04-24 00:00:00 | 2012-04-25 00:00:00 | 2012-04-26 00:00:00 | 2012-04-27 00:00:00 | 2012-04-28 00:00:00 | 2012-04-29 00:00:00 | 2012-04-30 00:00:00 | 2012-05-01 00:00:00
Cashier 1
Cashier 2
Cashier 3
Cashier 4
Cashier 5
Cashier 6
Spreadsheet: 216b5582-e0fa-4d61-a484-83297a184095
Sheet: SF-424A (18)

Applicant Name: |  |  |  | Award Number:
Budget Information - Non Construction Programs
OMB Approval No. 0348-0044
Section A - Budget Summary
 | Grant Program Function or Activity | Catalog of Federal Domestic Assistance Number | Estimated Unobligated Funds |  | New or Revised Budget
 |  |  | Federal | Non-Federal | Federal | Non-Federal | Total
 | (a) | (b) | (c ) | (d) | (e) | (f) | (g)
1. | Previous Projects | 10.17
2.
3.
4.
5. | Totals
Section B - Budget Categories
6. | Object Class Categories |  | Grant Program, Function or Activity |  |  |  | Total (5)
 |  |  | Previous Projects | (53) | (54) | (55)
 | [NAME]
 | [NAME]
 | c.  Travel
 | d.  Equipment
 | e.  Supplies
 | f.  Contractual
 | g.  Construction
 | h.  Other
 | i.  Total Direct Charges (sum of 6a-6h)
 | j.  Indirect Charges
 | k.  Totals (sum of 6i-6j)
7. | Program Income
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  |  | Prescribed by OMB Circular A-102
Authorized for Local Reproduction
Section C - Non-Federal Resources
 | (a) Grant Program |  |  | (b) Applicant | (c ) State | (d) Other Sources | (e) Totals
8.
9.
10.
11.
12. | Total (sum of lines 8 - 11)
Section D - Forecasted Cash Needs
 |  |  | Total for 1st Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th quarter
13. | Federal
14. | Non-Federal
15. | Total (sum of lines 13 and 14)
Section E - Budget Estimates of Federal Funds Needed for Balance of the Project
(a) Grant Program |  |  |  | Future Funding Periods (Years)
 |  |  |  | (b) First | (c ) Second | (d) Third | (e) Fourth
16.
17.
18.
19.
20. | Total (sum of lines 16-19)
Section F - Other Budget Information
21. Direct Charges |  |  |  | 22. Indirect Charges
23.  [NAME]
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  |  |  | Prescribed by OMB Circular A-102
 |  | Authorized for Local Reproduction
Spreadsheet: 864501d1711642381-find-another-row-in-a-table-whose-first-two-columns-match-and-determine-value-of-third-sampleboltnail
Sheet: IO

Program 1 output |  |  |  |  |  | Program 2 input
Date | Empl# | Name | Code | Hours |  | Calculated | Required Entry
2024-03-18 00:00:00 | 2 | [NAME] | S | 10 |  |  | B
2024-03-18 00:00:00 | 12 | [NAME] | S | 1 |  |  | 1B
2024-03-18 00:00:00 | 14 | [NAME] | S | 1 |  |  | 1B
2024-03-18 00:00:00 | 17 | [NAME] | V | 8 |  |  | E
2024-03-19 00:00:00 | 17 | [NAME] | V | 8 |  |  | E
2024-03-20 00:00:00 | 17 | [NAME] | V | 8 |  |  | E
2024-03-21 00:00:00 | 23 | [NAME] | S | 0.2 |  |  | 1B
2024-03-21 00:00:00 | 35 | [NAME] | M | 10 |  |  | H
2024-03-21 00:00:00 | 39 | Mac | S | 1.8
2024-03-21 00:00:00 | 39 | Mac | V | 8.2 |  |  | 8E
2024-03-21 00:00:00 | 51 | Fred | M | 1 |  |  | 1H
2024-03-21 00:00:00 | 58 | Derek | V | 1 |  |  | 1E
2024-03-21 00:00:00 | 17 | [NAME] | V | 8 |  |  | E
2024-03-22 00:00:00 | 36 | Brenden | V | 8 |  |  | E
2024-03-22 00:00:00 | 17 | [NAME] | V | 8 |  |  | E
Spreadsheet: 803335d1667398593-formula-to-identify-if-set-of-data-needs-addressing-based-on-multiple-criteria-duplicates-example
Sheet: Duplicates

ID 1 (Set) | ID 2 (File Copy) | ID Full | Name | Status | File Path
1 | 1 | 1-1 | Example 3.doc |  | C:\Folder 2\Financial\General\Example 3.doc | <- was deleted, and is contained in "Destruction Log"
1 | 2 | 1-2 | Example 3.doc |  | C:\Folder 1\Admin\General\Example 3.doc | <- was kept, and its redundant copy (above) was deleted
2 | 1 | 2-1 | Example 5.doc |  | C:\Folder 1\Admin\Misc\Example 5.doc | <- was deleted, and is contained in "Destruction Log"
2 | 2 | 2-2 | Example 5.doc |  | C:\Folder 3\Human Resources\Example 5.doc | <- was deleted, and is contained in "Destruction Log"
2 | 3 | 2-3 | Example 5.doc |  | C:\Folder 2\Financial\General\Example 5.doc | <- was kept, and its redundant copy (above/below) was deleted
2 | 4 | 2-4 | Example 5.doc |  | C:\Folder 4\Archived\Example 5.doc | <- was deleted, and is contained in "Destruction Log"
3 | 1 | 3-1 | Example 8.doc |  | C:\Folder 1\Admin\Misc\Example 8.doc | <- has not been addressed yet
3 | 2 | 3-2 | Example 8.doc |  | C:\Folder 4\Archived\Example 8.doc | <- has not been addressed yet
^ This is currently what the formula below returns in "Status" column
[NAME]: IFERROR(IF(MATCH($F2,'Destruction Log'!B:B,0),"Deleted"),"Not Deleted")
ID 1 (Set) | ID 2 (File Copy) | ID Full | Name | Status | File Path
1 | 1 | 1-1 | Example 3.doc |  | C:\Folder 2\Financial\General\Example 3.doc | <- was deleted, and is contained in "Destruction Log"
1 | 2 | 1-2 | Example 3.doc | Kept | C:\Folder 1\Admin\General\Example 3.doc | <- was kept, and its redundant copy (above) was deleted
2 | 1 | 2-1 | Example 5.doc | Deleted | C:\Folder 1\Admin\Misc\Example 5.doc | <- was deleted, and is contained in "Destruction Log"
2 | 2 | 2-2 | Example 5.doc | Deleted | C:\Folder 3\Human Resources\Example 5.doc | <- was deleted, and is contained in "Destruction Log"
2 | 3 | 2-3 | Example 5.doc | Kept | C:\Folder 2\Financial\General\Example 5.doc | <- was kept, and its redundant copy (above/below) was deleted
2 | 4 | 2-4 | Example 5.doc | Deleted | C:\Folder 4\Archived\Example 5.doc | <- was deleted, and is contained in "Destruction Log"
3 | 1 | 3-1 | Example 8.doc | Needs Attention | C:\Folder 1\Admin\Misc\Example 8.doc | <- has not been addressed yet
3 | 2 | 3-2 | Example 8.doc | Needs Attention | C:\Folder 4\Archived\Example 8.doc | <- has not been addressed yet
^ This is what I would like the formula to return.
Deleted: Set was reviewed and this copy was deleted
Kept: Set was reviewed and this copy was kept
Needs Attention: Set has not yet been reviewed
Duplicates = Full list of duplicate files, pulled from Inventory
Spreadsheet: 758723d1639040112-excel-dashboard-help-sum-data-from-multiple-tabs-service-support-management-db_v2
Sheet: Data_Dashboard

 |  |  | CUSTOMER DELIVERY DASHBOARD
 | 1. Filter by manager
 |  |  |  |  |  |  | number of Client Projects by month
 |  |  | Total Client Projects |  | COUNT TOTAL CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Client Projects completed |  | COUNT TOTAL CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c) & status (column G)
 |  |  | Total Client Projects 'not completed' |  | COUNT TOTAL CLIENT CALLS & CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Client Client Calls |  | COUNT TOTAL CLIENT CALLS & CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Client Calls completed |  | COUNT TOTAL CLIENT CALLS (column b) AND CLIENT IS NOT N/A (column c) & status (column G)
 |  |  | Total Client Calls 'not completed' |  | COUNT TOTAL CLIENT CALLS & CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Training Days |  | COUNT TOTAL holiday (column b)
 |  |  | Total Holidays |  | COUNT TOTAL training (column b)
 | 2. Filter by month
 |  |  |  |  |  |  | number of Client Calls by month
 | 3. Filter by Client
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Client Information
 |  |  | Client Name
 |  |  | Total number of Client Calls |  | Total number of Client Proects
 |  |  | Average number of Client Calls |  | Average number of Client Projects
 |  |  | Not started |  | Not started
 |  |  | On hold |  | On hold
 |  |  | In progress |  | In progress
 |  |  | Completed |  | Completed
Spreadsheet: 4a3eea65-f4a1-4e04-a6ec-2dab8934756d
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
40926052 | 2014-04-10 11:22:39 | AXIS | 0 | 4 | 6 | 1524192 | [NAME] | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
40926180 | 2014-04-10 11:37:32 | ALLIES | 1 | 6 | 3 | 1524192 | [NAME] | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron