tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 819052d1677193394-how-to-find-a-growth-value-given-a-sum-total-help2
Sheet: Hoja1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total
 | 150
 | 0.09 | Growth (y)
 | 3000 | Target (x)
 | How can I make my growth (Y) a formula based on my Target (x)
Spreadsheet: 132335d1323705262-problem-pain-with-offset-looking-for-other-formula-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Week | 3
Calloffs | Week | Date | H Teams | BHpts | HS | AS | Bapts | A Teams |  | Calloffs | Week | H Teams | BHpts | HS | AS | Bapts | A Teams
 | 1 | 2011-10-20 00:00:00 | Sherwood S.C. |  |  |  |  | Bye
 | 1 | 2011-10-20 00:00:00 | [NAME] |  | 7 | 3 |  | The [NAME]
 | 1 | 2011-10-20 00:00:00 | Riley's A |  | 4 | 6 |  | Winning Post
 | 1 | 2011-10-20 00:00:00 | [NAME] |  | 5 | 5 | 1 | [NAME]
 | 1 | 2011-10-20 00:00:00 | Spot on Badgers |  | 8 | 2 |  | Phoenix Master
 | 1 | 2011-10-20 00:00:00 | Phoenix One |  | 7 | 3 |  | [NAME]
 | 2 | 2011-10-27 00:00:00 | [NAME] |  | 4 | 6 |  | Spot on Badgers
 | 2 | 2011-10-27 00:00:00 | [NAME] |  | 7 | 3 |  | Riley's A
 | 2 | 2011-10-27 00:00:00 | [NAME] |  | 7 | 3 |  | The [NAME]
 | 2 | 2011-10-27 00:00:00 | Bye |  |  |  |  | Phoenix One
 | 2 | 2011-10-27 00:00:00 | Phoenix Master |  | 8 | 2 |  | Sherwood S.C.
 | 3 | 2011-11-10 00:00:00 | The [NAME] |  |  |  |  | Bye
 | 3 | 2011-11-10 00:00:00 | Riley's A |  | 4 | 6 |  | [NAME]
 | 3 | 2011-11-10 00:00:00 | [NAME] |  | 2 | 8 |  | [NAME]
 | 3 | 2011-11-10 00:00:00 | Spot on Badgers |  | 4 | 6 |  | Winning Post
 | 3 | 2011-11-10 00:00:00 | Phoenix Master |  | 3 | 7 |  | [NAME]
 | 3 | 2011-11-12 00:00:00 | Winning Post |  | 6 | 4 |  | [NAME]
 | 4 | 2011-11-24 00:00:00 | Winning Post |  | 3 | 7 |  | Phoenix Master
 | 4 | 2011-11-24 00:00:00 | Winning Post |  | 3 | 7 |  | Phoenix Master
 | 4 | 2011-11-24 00:00:00 | [NAME] |  | 5 | 5 |  | [NAME]
 | 4 | 2011-11-24 00:00:00 | Bye |  |  |  |  | Riley's A
 | 4 | 2011-11-24 00:00:00 | Phoenix One |  | 4 | 6 |  | The [NAME]
 | 4 | 2011-11-24 00:00:00 | [NAME] |  | 6 | 4 |  | Sherwood S.C.
 | 4 | 2011-11-24 00:00:00 | Sherwood S.C. |  | 7 | 3 |  | The [NAME]
 | 5 | 2011-12-01 00:00:00 | [NAME] |  |  |  |  | Bye
 | 5 | 2011-12-01 00:00:00 | Spot on Badgers |  | 6 | 4 |  | [NAME]
 | 5 | 2011-12-01 00:00:00 | [NAME] |  | 4 | 6 |  | Phoenix Master
 | 5 | 2011-12-01 00:00:00 | [NAME] |  | 5 | 5 | 1 | Winning Post
 | 5 | 2011-12-01 00:00:00 | Riley's A |  | 3 | 7 |  | Phoenix One
 | 5 | 2011-12-01 00:00:00 | Sherwood S.C. | 1 | 5 | 5 |  | [NAME]
Spreadsheet: 66421d1267084445-vlookups-or-more-example1
Sheet: Sheet1

 | Dept. | Area | Person | no
 | PR | England | Nick | 1
 | PR | Scotland | Rich | 2 | Lookup Values
 | PR | Wales | [NAME] | 3
 | PR | England | Geoff | 1
 | PR | N. Ireland | Rachel | 4
 | PR | ROI | Emma | 5
 | PR | England | [NAME] | 1
 | PR | ROI | Charlotte | 5
 | PR | Scotland | [NAME] | 2
 | PR | Wales | [NAME] | 3
 | CC | N. Ireland | [NAME] | 4
 | CC | Wales | [NAME] | 3 | Lookup Values
 | CC | ROI | Gemma | 5
 | CC | N. Ireland | [NAME] | 4
 | CC | England | [NAME] | 1
 | CC | Scotland | [NAME] | 2
 | CC | ROI | Judi | 5
 | CC | England | Maria | 1
 | CC | Wales | [NAME] | 3
 | CC | N. Ireland | [NAME] | 4
 |  |  | There could be more tables following, in much the same way as above.
Spreadsheet: 57607d1257818161-lookup-data-with-multiple-values-test
Sheet: Lookup Items

index | Part Number | MFR | Should be
1 | 897FGH-345 | OAKLY | OAKLY | <-- correct, because it is the first one found using VLOOKUP
2 | 897FGH-345 | OAKLY | [NAME]
3 | 897FGH-345 | OAKLY | POKLY
4 | 897FGH-345 | OAKLY | [NAME]
1 | KGIT95487-33 | 45609 | 45609 | <-- correct, because it is the first one found using VLOOKUP
2 | KGIT95487-33 | 45609 | 45269
1 | E5H65H66 | N0002 | N0002 | <-- correct, because it is the first one found using VLOOKUP, and it is the only one in the list
1 | 44SY55 | N0006 | N0006 | <-- correct, because it is the first one found using VLOOKUP, and it is the only one in the list
1 | 23456D3467 | D8266 | D8266 | <-- correct, because it is the first one found using VLOOKUP, and it is the only one in the list
 |  |  |  | The bold segment is the part of the formula that I want to change to would allow it to locate the next instance of the part number which appears multiple times in the source data
 |  |  |  | Can I do this based on the index value to the left of the partnumber?
 |  |  |  | IF(B4=B3,VLOOKUP(TRIM(B4),'Source Data'!A:D,4,FALSE),VLOOKUP(TRIM(B4),'Source Data'!A:D,4,FALSE))
Spreadsheet: 178246d1346733593-matching-names-then-delivering-value-in-another-cell-sample
Sheet: Accounts

Name | $ | $
Interest
Cash
Dividends
Fees
Payments
Spreadsheet: 229294d1366361410-dependent-drop-down-lists-based-on-dynamic-data-range-book1
Sheet: Data

Year | Quarter | Month | Product Code | BB % | USP %
2013 | Q1 | Jan | SD-21 | 0.13 | 0.0005
2013 | Q2 | Apr | NV-12 | 0.07 | 0.002
2013 | Q2 | May | NV-13 | 0.1 | 0.03
2012 | Q2 | Jun | QV-14 | 0.23 | 0.0003
2012 | Q3 | Jul | RT-15 | 0.14 | 0.0004
2011 | Q3 | Aug | [NAME] | 0.15 | 0.0015
Spreadsheet: 177913d1346515325-how-to-add-multiple-axis-in-the-chart-c-vs-p
Sheet: Sheet1

 | Year Vs Avg Paid
 | Year | Capital |  | Chemical |  | Project |  | Service |  | Spares & Consumables |  | Welfare & Safety |  | Total
 |  | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME].
 | 2009 | 1.51416701008018 | 0.2163095728685971 | 0.706943376 | 0.1009919108571429 | 2.41260505 | 0.3446578642857143 | 0.381588006965636 | 0.05451257242366229 | 14.2717723783826 | 2.038824625483229 | 0.473799897563001 | 0.06768569965185729 | 19.76087571899142 | 2.822982245570202
 | 2010 | 2.95847281855556 | 0.2465394015462966 | 0 | 0 | 4.417454596611109 | 0.3681212163842591 | 1.84582919902222 | 0.1538190999185183 | 16.90306961825 | 1.408589134854167 | 0.9167277014444449 | 0.07639397512037041 | 27.04155393388334 | 2.253462827823611
 | 2011 | 5.18706724511111 | 0.4322556037592591 | 0.23882665 | 0.01990222083333333 | 2.33583847138889 | 0.1946532059490742 | 2.90319622978889 | 0.2419330191490742 | 18.1561552169483 | 1.513012934745692 | 0.7940700980222221 | 0.06617250816851851 | 29.61515391125941 | 2.467929492604951
 | 2012 | 3.23756011345833 | 0.4046950141822912 | 0.244358961111111 | 0.03054487013888888 | 0.20881862 | 0.0261023275 | 1.32683107076778 | 0.1658538838459725 | 8.871180126993892 | 1.108897515874236 | 0.511045799255556 | 0.0638807249069445 | 14.39979469158667 | 1.799974336448333
 | Total | 12.89726718720518 | 1.299799592356444 | 1.190128987111111 | 0.1514390018293651 | 9.374716738 | 0.9335346141190476 | 6.457444506544527 | 0.6161185753372274 | 58.20217734057479 | 6.069324210957324 | 2.695643496285224 | 0.2741329078476907 | 90.81737825572084 | 9.344348902447098
 | Year Vs Production
 | Year | Production | Avg. Production |  | Year | Production | Avg. Production
 | 2008 | 552000 | 1514 |  | 2008 |  | 0
 | 2009 | 903000 | 2472 |  | 2009 | 282716 | 775
 | 2010 | 1055000 | 2890 |  | 2010 | 314088 | 861
 | 2011 | 1411000 | 3866 |  | 2011 | 391017 | 1071
 | 2012 | 963000 | 3931 |  | 2012 | 239619 | 978
Spreadsheet: mary_fischer__25629__1580  6-2001
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: 121628d1316204692-dget-formula-returns-num-error-i-verified-no-duplicates-dget-error
Sheet: DGET

 | THIS RESULT WORKS
ProdType | StudGrade | NutGrade | measuresystem | baseunit | [NAME] | length | partnum | lastlaborcost | lastburdencost | lastmaterialcost | lastsubcontcost | lastmtlburcost
BAR-NOMINAL | 660B |  | IMP | IN | 0.375 |  | BNI0B660000003700GRB | 0 | 0 | 0 | 0 | 0
 | THIS RESULT DOES NOT WORK. WHY? ONLY ONE RECORD ON THE NAMED RANGE MATCHES THESE CRITERIA.
ProdType | StudGrade | NutGrade | measuresystem | baseunit | [NAME] | length | partnum | lastlaborcost | lastburdencost | lastmaterialcost | lastsubcontcost | lastmtlburcost
BAR-NOMINAL | 660B |  | IMP | IN | 1.375 |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 704101d1605361627-sumproduct-with-substraction-and-ifs-testt
Sheet: Ledger

 | Date | Currency | Token | Action | Price | Quantity | Paid | Sold |  | Invested | Made
 | 2020-12-20 00:00:00 | Bitcoin | BTC | Buy | 3000 | 0.2
 | 2020-12-20 00:00:00 | Ripple | XRP | Buy | 0.08 | 11500
 | 2020-12-20 00:00:00 | Ethereum | ETH | Buy | 185 | 3.25
 | 2020-12-20 00:00:00 | Chainlink | LINK | Buy | 3 | 102
 | 2020-12-20 00:00:00 | Cardano | ADA | Buy | 0.04 | 3006
 | 2020-12-20 00:00:00 | VeChain | VET | Buy | 0.007 | 17178
 | 2020-12-20 00:00:00 | Reserve Rights | RSR | Buy | 0.002 | 45100
 | 2020-12-20 00:00:00 | Stellar | XLM | Buy | 0.007 | 12900
 | 2020-12-20 00:00:00 | SingularityNET | AGI | Buy | 0.01 | 9017
 | 2020-12-20 00:00:00 | Algorand | ALGO | Buy | 0.09 | 1003
 | 2020-12-21 00:00:00 | Bitcoin | BTC | Sell | 4000 | 0.005
Spreadsheet: f2572b30-d817-4679-b180-b25778a14076
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6146 | 30442 | Lynette | [NAME] | RSA | 149 | 00:21:40 | [NAME] | 01:10:41 | 00:00:45 | 00:48:22 | 1 | 02:22:05
6146 | 12805 | Tayla | Glover | RSA | 150 | 00:20:49 | 00:00:28 | 01:16:25 | 00:00:43 | 00:45:51 | 2 | 02:24:18
6146 | 20872 | Heide-Mari | Meiring | RSA | 148 | 00:26:19 | 00:00:31 | 01:12:57 | 00:00:41 | 00:45:28 | 3 | 02:25:56
6146 | 40203 | Nelmare | Loubser | RSA | 151 | [NAME] | 00:00:52 | 01:21:53 | 00:00:34 | 00:46:18 | 4 | 02:31:06
Spreadsheet: 467001d1466531839-match-n-a-price-list-data
Sheet: Sheet1

 | Item |  | Item | Store 1 | Store 2 | Store 3 | Store 4 | Lowest Price | Store Name
 |  |  | 1 | 7125.59
 |  |  | 2 | 136.19
 |  |  | 3 | 93.56
 |  |  | 4 | 113.96
 |  |  | 5 | 90.72
 |  |  | 6 | 107.2
 |  |  | 7 | 140.48
 |  |  | 8 | 636.29 | 490.5
 |  |  | 9 | 218.4
 |  |  | 10 | 116.95
 |  |  | 11 | 40.28
 |  |  | 12 | 615.28
 |  |  | 13 | 237.11
 |  |  | 14 | 57.92
 |  |  | 15 | 253.17
 |  |  | 16 | 62.31
 |  |  | 17 | 325
 |  |  | 18 | 113.4
 |  |  | 19 | 94.25
 |  |  | 20 | 120.84
 |  |  | 21 | 315.9
 |  |  | 22 | 104.16
 |  |  | 23 | 420.06
 |  |  | 24 | 313.92
 |  |  | 25 | 109
 |  |  | 26 | 422.92
 |  |  | 27 | 104.16
 |  |  | 28 | 420.06
 |  |  | 29 | 822.8
 |  |  | 30 | 4112.85
 |  |  | 31 | 595.1
 |  |  | 32 | 1371.5
 |  |  | 33 | 282.17
 |  |  | 34 | 450
 |  |  | 35 | 5473.67
 |  |  | 36 | 1647.2
 |  |  | 37 | 2719.04
 |  |  | 38 | 83.16
 |  |  | 39 | 715
 |  |  | 40 | 72
 |  |  | 41 | 518.02
 |  |  | 42 | 199.65
 |  |  | 43 | 46.34
 |  |  | 44 | 2593.97
 |  |  | 45 | 202.68
 |  |  | 46 | 5825.11
 |  |  | 47 | 3069.84
 |  |  | 48 | 73.7
 |  |  | 49 | 914.94
 |  |  | 50 | 1265
 |  |  | 51 | 1300
Spreadsheet: stacey_white__39035__West_Sens_new
Sheet: OptionNetPosition

 | OPTION_TYPE | (All)
 | EXP_FREQ | (All)
 | BOOK | (All)
 | REGION | (All)
 | Physical/Financial | (All)
 | Call/Put | (All)
 | Sum of MWH | DELIVERY_DT
 | STRIKE | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | 2003-01-01 00:00:00 | 2003-02-01 00:00:00 | 2003-03-01 00:00:00 | 2003-04-01 00:00:00 | 2003-05-01 00:00:00 | 2003-06-01 00:00:00 | 2003-07-01 00:00:00 | 2003-08-01 00:00:00 | 2003-09-01 00:00:00 | 2003-10-01 00:00:00 | 2003-11-01 00:00:00 | 2003-12-01 00:00:00
 | 0 | 0 | 10000 | 10000 | 10400 | 9600 | 10400 | 10400 | 10400 | 10000 | 10400 | 10800 | 9600 | 10800 | 10000 | 10000 | 10400 | 9600 | 10400 | 10400 | 10400 | 10000 | 10400 | 10400 | 10000
 | 15.04 | 0 | 0 | 0
 | 15.24 |  | 0
 | 15.28 |  |  | 0
 | 15.3 | 0
 | 28 |  | 40000
 | 30.03 |  | -12500 | -12500 | -13000 | -12000 | -13000 | -13000 | -13000 | -15625 | -16250 | -16875 | -12000
 | 31.25 |  |  |  |  |  |  |  |  |  |  |  |  | -16200 | -15000 | -15000 | -15600 | -14400 | -15600 | -15600 | -15600 | -18750 | -19500 | -19500 | -15000
 | 35 |  |  | -20000
 | 38.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10400 | 9600 | 10400 | 10400 | 10400 | 10000 | 10400 | 10400 | 10000 | 10800 | 9600 | 10400
 | 50 |  |  |  |  |  |  | 10400 | 10400 | 10000
 | 65 |  |  |  | 20800 | 19200 | 20800 | 20800 | 20800 | 20000 | 20800 | 21600 | 19200 | 21600 | 20000 | 20000
 | 70 |  |  |  | -20800 | -19200 | -20800
 | 75 |  |  |  | -10400 | -9600 | -10400 | -10400 | -10400 | -10000 | -10400 | -10800 | -9600 | -10800 | -10000 | -10000
 | 90 |  |  |  | 31200 | 28800 | 31200
 | 125 |  |  |  |  |  |  |  |  |  | 10400 | 10800 | 9600
 | 150 |  | 20000 | 20000 | 31200 | 28800 | 31200 | 31200 | 31200 | 30000 | 31200 | 32400 | 28800 | 32400 | 30000 | 30000
Spreadsheet: 166263d1341510780-getting-a-cell-to-populate-when-it-sees-a-name-airframe-engine-log-sample-modified-by-tigeravatar-v2
Sheet: Eric

Today is:
 | Date | Hourly | Cost Calculator
 |  |  |  |  | RUNNING TOTAL
 |  |  |  |  |  | Expenses
 |  |  |  |  |  | Date | Cost | Description
 |  |  | Total
Spreadsheet: 0337982d-4326-43fd-a65b-6aed45b894a2
Sheet: Sheet1

OPERATING | FY2012 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Beginning Reserve
Fund Balance | 441305
 | FY2012 | FY2012 | FY2011 | FY2012 | FY2012 | FY2011
 | Annual Budget | Annual Budget | Revenues this time | Actual Revenue | Actual Expenses | Expenses this time | Net | Net
 | Revenue | Expenses | last year | to date | to date | last year | This Year | Last Year
Membership activities
Administration |  | 229109 |  |  | 94945 | 89999
Membership Promotion |  | 2000 |  |  | 1000 | 679
Governance Support |  | 8900 |  |  | 8351 | 7254
Dues | 188884 | 3905 | 77649 | 75377 | 1553 | 1617
MW & Annual Conference | 0 | 6300 | 0 | 0 | 1076 | 3654
External Relations | 13500 | 20712 | 0 | 0 | 773 | 1409
Technology Grants | 0 | 1000 | 0 | 0 | 0 | 0
50th Anniversary | 0 | 0 | 0 | 0 | 0 | 0
Friends of LITA (LITA Now) | 100 | 0 | 0 | 575 | 0 | 0
Subtotal | 202484 | 271926 | 77649 | 75952 | 107698 | 104612 | -31746 | -26963
Publications
ITAL | 57338 | 62533 | 21362 | 18382 | 29341 | 32195 | -10959 | -10833
Classified ads | 10000 | 2100 | 7270 | 6789 | 903 | 894 | 5886 | 6376
Nonperiodical Pubs. | 2000 | 1755 | 1582 | 825 | 855 | 956 | -30 | 626
Subtotal | 69338 | 66388 | 30214 | 25996 | 31099 | 34045 | -5103 | -3831
Education
Pre-conferences | 15900 | 13754 | 0 | 0 | 0 | 0 | 0 | 0
MW Workshop | 14870 | 11192 | 6328 | 4004 | 1395 | 3618 | 2609 | 2710
Forum | 117400 | 110012 | 127423 | 118102 | 96904 | 106745 | 21198 | 20678
Institutes | 22800 | 14508 | 3500 | 0 | 0 | 1957 | 0 | 1543
Web CE-1 (courses) | 27000 | 11883 | 7106 | 5980 | 1537 | 1938 | 4443 | 5168
Web CE-2 (webinars) | 15000 | 6467 | 0 | 2521 | 520 | 0 | 2001 | 0
Subtotal | 212970 | 167816 | 144357 | 130607 | 100356 | 114258 | 30251 | 30099
TOTAL | 484792 | 506130 | 252220 | 232555 | 239153 | 252915 | -6598 | -695
ENDOWMENT | FY2012
 | actual to date
Fund Balance | 121084
Revenues | 2171
Expenses | 382
Net Revenue/Expense | 2546
Ending Net Asset Balance | 123630
Interest/Dividends | 2171
Spreadsheet: 86282d1286296233-consecutive-number-list-ignoring-duplicates-getuniquevaluesplacenumberat-end
Sheet: Sheet1

Numbers
1234
1234
1234
5236
5236
8885
8885
8886
8887
8888
8889
8890
8891
1234
1234
1234
5236
5236
8885
8885
8886
8887
8888
8889
8890
8891
Spreadsheet: 829048d1683884752-update-added-data-in-rows-of-sheet1-to-sheet2-automatically-serial-no
Sheet: Sheet2

UPDATED QUESTIONS FROM SHEET 1
PART A | PART A
PART B | PART B
Spreadsheet: 128809d1321289708-excel-2007-balances-allocation-mechanism-logic-797778-index-function-and-data-extract-book1
Sheet: Sheet1

 |  | Type | LS Code | Priority | Balance | FAC Unique Key |  | Collateral Type | Amount | Collateral Unique Key | Code | Qaulity | Hair Cut | Recognized Amount |  |  |  |  |  |  |  | FAC Unique Key | Collateral Unique Key
 |  | Syndicated Loan - قرض تجمع متناقص |  |  | 100 | S1 |  | Unrated Corporate Debt Securities | 100 | S2 |  |  |  |  |  |  |  |  |  | << =COUNTIF(FAC_Unique_Key,W4) |  | S1
 |  | Temporary Overdraft - جاري مدين [NAME] |  |  | 50 | S1 |  | Real Estate Mortgage - رهونات عقارية | 50 | S3
 |  | Syndicated Revolving Loan - قرض تجمع دوار |  |  | 200 | S2 |  | Commercial Papers - الأوراق التجارية | 300 | S1 |  |  |  |  |  |  |  |  |  | Type | LS Code | Priority | Balance | FAC Unique Key |  | Collateral Type | Amount | Collateral Unique Key | Code | Qaulity | Hair Cut | Recognized Amount | Coverage
 |  | Term Loan - قرض متناقص |  |  | 50 | S3 |  | Machinery & Equipment - آلات ومعدات | 100 | S1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FAC Unique Key | Collateral Unique Key
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | << =COUNTIF(FAC_Unique_Key,W4) |  | S2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Type | LS Code | Priority | Balance | FAC Unique Key |  | Collateral Type | Amount | Collateral Unique Key | Code | Qaulity | Hair Cut | Recognized Amount | Coverage
Spreadsheet: 771901d1646912348-formula-when-a-number-is-added-up-to-a-specific-number-book1
Sheet: Sheet1

 |  | 30
 |  | 38
 |  | 46
 |  | 2
 |  | 10
 |  | 18
 |  | 26
 |  | 34
 |  | 42
 |  | 50
 |  | 6
 |  | 14
 |  | 22
 |  | 30
 |  | 38
 |  | 46
 |  | 2
 |  | 10
 |  | 18
Spreadsheet: 818562d1676915926-formula-to-breakout-text-from-a-cell-multiple-times-strato-error-rating-example
Sheet: Sheet1

Error Rating | C | 1B | 2B | 3B | SS | LF | CF | RF
1b-1e1 |  | 101
1b-4e12, 3b-4e16, rf/lf-5(+2)e12 |  | 412 |  | 416 |  | 512 |  | 512
lf-2(0)e3, rf-3, cf-4, 2b-4e24 |  |  | 424 |  |  | 203 | 403 | 303
2b-3e11 |  |  | 311
1b-4e7 |  | 407
3b-3e14, 1b-4e30 |  | 430 |  | 314
cf-2(-1)e2 |  |  |  |  |  | 202 | 202 | 202
lf-5(-3)e6 |  |  |  |  |  | 506 |  | 506
ss-2e12 |  |  |  |  | 212
of-4(-1)e9 |  |  |  |  |  | 409 | 409 | 409
1b-4e5, rf/lf-3(+1)e22 |  | 405 |  |  |  | 322 |  | 322
CA-2(0)e4t10p0, 1b-4e25 | 204 | 425
Spreadsheet: 709331d1608251016-how-do-i-create-a-dynamic-table-from-another-tables-data-testing-file-v2
Sheet: Accounts

Project Name | Billed to Date | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  | 15000 | 11350 |  |  |  |  |  |  |  |  |  |  | 15000 | 11350
 |  |  | 5480 |  |  |  |  |  |  |  |  |  |  |  | 5480
 |  | 5340 |  |  |  |  |  |  |  |  |  |  |  | 5340
 |  | 5000 | 5380 |  |  |  |  |  |  |  |  |  |  | 5000 | 5380
 |  |  |  | 6820 |  |  |  |  |  |  |  |  |  |  |  | 6820
 |  | 20000 | 40000 | 40000 | 85000 |  |  |  |  |  |  |  |  | 20000 | 40000 | 40000 | 85000
 |  | 4000 |  |  |  |  |  |  |  |  |  |  |  | 4000
 |  |  | 2880 |  |  |  |  |  |  |  |  |  |  |  | 2880
 |  | 15000 | 6500 |  |  |  |  |  |  |  |  |  |  | 15000 | 6500
 |  |  | 200 |  |  |  |  |  |  |  |  |  |  |  | 200
Spreadsheet: 793227d1661359099-return-cell-values-from-a-table-based-on-multiple-criteria-example-error-details
Sheet: Per Person

 | Sample Report - Team 1
 | Results per Person
Goal | Employee | QA [NAME] | Total Agreements  Audited | Total Attributes Reviewed | Total Attribute Errors | Attribute Error Details
0.95 | Gina |  |  |  |  | Attribute 2, Attribute 18
0.95 | [NAME]
0.95 | Manny
0.95 | Timothy
0.95 | Travis
0.95 | [NAME]
0.95 | [NAME]
0.95 | [NAME]
0.95 | Stacy
0.95 | Belen
0.95 | [NAME]
 | Sample Report - Team 2
 | Results per Person
Goal | Employee | QA [NAME] | Total Agreements  Audited | Total Attributes Reviewed | Total Attribute Errors | Attribute Error Details
0.95 | Kristen
0.95 | [NAME]
0.95 | [NAME]
0.95 | Justin
0.95 | [NAME]
0.95 | Heather
0.95 | [NAME]
0.95 | [NAME]
0.95 | Ricardo
Spreadsheet: 851014d1701281477-need-formula-maybe-aggregate-to-show-values-but-only-if-not-on-a-list-book1
Sheet: Sheet1

 |  | Positions not listed and not on table
[NAME] | [NAME] | [NAME]
Administrative Assistant II | Administrative Assistant II |  |  |  |  | EHS Partner
[NAME] | [NAME] |  |  |  |  | FSQA Partner
Credit Validator | Credit Validator |  |  |  |  | General Manager
Cycle Counter | Cycle Counter |  |  |  |  | HR Business Partner - Ops
Driver, Delivery | Driver, Delivery |  |  |  |  | IT Site Support Team Lead
EHS Partner | Facility Maintenance - CBA |  |  |  |  | Mgr Advertising - S
Facility Maintenance - CBA | Fleet Maintenance Coordinator |  |  |  |  | Mgr Facility Maintenance
Fleet Maintenance Coordinator | Fleet Maintenance Mechanic |  |  |  |  | Mgr Human Resources - Ops
Fleet Maintenance Mechanic | Fleet Maintenance Mechanic II |  |  |  |  | Mgr Inventory Control
Fleet Maintenance Mechanic II | Fleet Refrigeration Tech |  |  |  |  | Mgr Quality Assurance - Fresh
Fleet Refrigeration Tech | IT Specialist I |  |  |  |  | Mgr Transportation
FSQA Partner | Mail Room Clerk II |  |  |  |  | Operations Manager
General Manager | Night Driver - CBA |  |  |  |  | Supv Office
HR Business Partner - Ops | Office [NAME] |  |  |  |  | Supv Transportation
IT Site Support Team Lead | Payroll [NAME] |  |  |  |  | [NAME]
IT Specialist I | PO Discrepancy Researcher
Mail Room Clerk II | QA Inspector - Fresh
Mgr Advertising - S | QA Inspector - Produce
Mgr Facility Maintenance | Refrigeration Technician - CBA
Mgr Human Resources - Ops | Slotting Analyst
Mgr Inventory Control | Transportation Coordinator
Mgr Quality Assurance - Fresh | Warehouse Coordinator
Mgr Transportation | [NAME]
Night Driver - CBA | Sample 1
Office [NAME] | Sample 2
Operations Manager
Payroll [NAME]
PO Discrepancy Researcher
QA Inspector - Fresh
QA Inspector - Produce
Refrigeration Technician - CBA
Slotting Analyst
Supv Office
Supv Transportation
[NAME]
Transportation Coordinator
Warehouse Coordinator
[NAME]
Spreadsheet: 92b895e5-17ce-4be6-b000-1fe4771cfa45
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3036 | 17437 | [NAME] | Cuder | AUT | 121 | 00:47:22 | 00:02:06 | 2:26:03 | 00:01:25 | 1:39:05 | 1 | 4:56:03
3036 | 17440 | Danièle | Lentz | LUX | 125 | 1:02:51 | 00:02:20 | 2:20:19 | 00:01:18 | 1:32:45 | 2 | 4:59:35
3036 | 16683 | Ingrid | [NAME] | BEL | 123 | 00:47:49 | 00:02:27 | 2:37:06 | 00:01:39 | 1:54:21 | 3 | 5:23:24
3036 | 13025 | [NAME] | Mulder | NED | 127 | 00:57:32 | 00:02:50 | 2:38:52 | 00:02:37 | 2:00:56 | 4 | 5:42:51