tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 775888d1649362455-using-a-location-reference-combine-information-from-two-tabs-into-a-consolidated-list-test-worksheet
Sheet: FGE Store List

VP | VPEmail | Region | RDO | RM | DM | GM | Location Code | State Abbr
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | 15 Manager | 0015 | VA
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | DE-0019 Manager | 0019 | DE
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | VA-20 Manager | 0020 | VA
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | DE-31 Manager | 0031 | DE
[NAME] | [EMAIL] | Region 1 | Alc | [NAME] | [NAME] | SC | 0034 | SC
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | NC-38 Manager | 0038 | NC
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | NC-49 Manager | 0049 | NC
[NAME] | [EMAIL] | Region 4 | Alc | Will | Scott | NY | 0052 | NY
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | MD-53 Manager | 0053 | MD
[NAME] | [EMAIL] | Region 1 | Alc | [NAME] | [NAME] | NC | 0057 | NC
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | MD-60 Manager | 0060 | MD
[NAME] | [EMAIL] | Region 4 | Alc | Will | Kurt | PA | 0061 | PA
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | SC-63 Manager | 0063 | SC
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | 64 Manager | 0064 | VA
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | MD-68 Manager | 0068 | MD
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | SC-72 Manager | 0072 | SC
[NAME] | [EMAIL] | Region 4 | Alc | Will | Kurt | PA | 0076 | PA
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | SC-77 Manager | 0077 | SC
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | MD-80 Manager | 0080 | MD
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | VA-88 Manager | 0088 | VA
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | NC-89 Manager | 0089 | NC
[NAME] | [EMAIL] | Region 1 | Alc | [NAME] | [NAME] | SC | 0091 | SC
[NAME] | [EMAIL] | Region 6 | Todd | Jeremy | Mistry | nc | 2021 | ND
[NAME] | [EMAIL] | Region 6 | Todd | Jeremy | Mistry | MN-2030 Manager | 2030 | MN
Spreadsheet: 760747d1640449378-depreciation-recalculation-excel-forum-dep
Sheet: Sheet1

 |  |  |  |  |  |  | Year | Start Date | End Date
 |  |  |  |  |  |  |  | 2021-01-01 00:00:00 | 2021-12-31 00:00:00
 | Asset Number | Major Category | Asset Category | Units Assigned | Asset Description | Asset Cost | Date of avaialable for use | Life In Months | End of useful life | Charge for the year
 | Fully depreciated assets
 | 000149 | Comp Eqp | Comp Eqp - Desktop Computer | 1 | IBM Netvista A22p | 66000 | 2001-12-29 00:00:00 | 36 | 2004-12-28 00:00:00
 | 000005 | Comp Eqp | [NAME] Printer | 1 | HP LASER JET 1200 PRINTER | 21400 | 2002-07-09 00:00:00 | 36 | 2005-07-08 00:00:00
 | 000009 | Comp Eqp | [NAME] Printer | 1 | HP LASER JET 1200 PRINTER | 21400 | 2002-07-11 00:00:00 | 36 | 2005-07-10 00:00:00
 | 000037 | Comp Eqp | [NAME] | 1 | HP SCAN JET | 7850 | 2002-10-16 00:00:00 | 36 | 2005-10-15 00:00:00
 | Fully depreciated during the year
 | 32896 | Comp Eqp | [NAME] | 1 | ETHERNET SWITCH WITH MOUNTING KIT | 1433195.47 | 2016-04-25 00:00:00 | 60 | 2021-04-24 00:00:00
 | 32892 | Comp Eqp | [NAME] | 1 | [NAME], [NAME] | 1945451.12 | 2016-04-25 00:00:00 | 60 | 2021-04-24 00:00:00
 | 32888 | Comp Eqp | [NAME] | 1 | [NAME] (SPARC T5-2 SERVER) | 4330350.91 | 2016-04-25 00:00:00 | 60 | 2021-04-24 00:00:00
 | 32899 | Comp Eqp | [NAME] | 1 | SUN RACK II, 42U RACK, 2 X PDU 15KVA | 670998.35 | 2016-04-25 00:00:00 | 60 | 2021-04-24 00:00:00
 | 32898 | Comp Eqp | [NAME] | 1 | SUN RACK II, 42U RACK, 2 X PDU 15KVA | 670998.35 | 2016-04-25 00:00:00 | 60 | 2021-04-24 00:00:00
 | Additions during the year
 | 47487 | Comp Eqp | [NAME] | 1 | CANON LIDE 300 SCANNER | 11583 | 2021-01-01 00:00:00 | 36
 | 47078 | Comp Eqp | [NAME] Printer | 1 | HP LASER JET M404DN PRINTER | 42530 | 2021-01-01 00:00:00 | 36
 | 46840 | Comp Eqp | [NAME] | 1 | D-LINK DGS-1024D FOR SOHAWA | 21000 | 2021-01-01 00:00:00 | 36
 | 47273 | Comp Eqp | [NAME] Printer | 1 | HP LASER JET M404DN PRINTER | 42530.5 | 2021-01-01 00:00:00 | 36
 | Full year Depreciation
 | 34273 | Comp Eqp | [NAME] | 1 | HPE ML30 GEN9 CTO SVR | 144872 | 2017-03-16 00:00:00 | 60
 | 34281 | Comp Eqp | [NAME] | 1 | HPE ML30 GEN9 CTO SVR | 144871 | 2017-03-16 00:00:00 | 60
 | 34275 | Comp Eqp | [NAME] | 1 | HPE ML30 GEN9 CTO SVR | 144872 | 2017-03-16 00:00:00 | 60
 | 34260 | Comp Eqp | [NAME] | 1 | HPE ML30 GEN9 CTO SVR | 144872 | 2017-03-16 00:00:00 | 60
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 8b

Product1 | USD | EUR3 | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Basis | 78 | 3 | 17 | 22 | 3 | 1 | 2 | 126
Cap/Floor | 58 | 4 | 1 | 1 | 0 | 0 | 17 | 81
Debt Option | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Exotic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fixed-Fixed | 1 | 0 | 0 | 0 | 0 | 0 | 14 | 15
Fixed-Float | 8063 | 3467 | 3699 | 657 | 719 | 1043 | 1279 | 18927
FRA | 616 | 1021 | 205 | 0 | 49 | 1 | 82 | 1974
Inflation | 29 | 61 | 35 | 0 | 1 | 0 | 27 | 153
OIS | 28 | 133 | 8 | 0 | 34 | 3 | 69 | 275
Swaption | 588 | 178 | 39 | 55 | 23 | 4 | 20 | 907
TOTAL | 9461 | 4867 | 4004 | 735 | 829 | 1052 | 1510 | 22458
Spreadsheet: cooper_richey__4345__QuickINFO
Sheet: Quick Facts

Ontario Statistics
Percentage by Fuel Type (by nameplate capacity)
Hydro | 0.2635127747202682
Nuclear | 0.3181105806028356
Coal-fired | 0.2755403287531435
Natural Gas & Resid Oil | 0.07799686554652477
NUG Units | 0.06483945037722783
 | 1
Percentage by Ownership
Bruce Power | 0.1144439989794803
Ontario Power Generation | 0.8207165506432919
NUG Ownership | 0.06483945037722783
 | 1
Interconnection | limits out of Ontario | limits into of Ontario
Manitoba | 240 | 240
Minnesota | 150 | 100
Quebec North | 120 | 65
Quebec South | 800 | 1200
New York East | 400 | 400
New York Niagara - Winter | 2100 | 1790
New York Niagara - Summer | 2070 | 1480
Michigan - Winter | 2180 | 1490
MIchigan - Summer | 1970 | 1390
Totals
Summers | 5750 | 4875
Winters | 5990 | 5285
Year Round Average | 5870 | 5080
Source: IMO 18-month outlook, IMO 10yr Outlook
Spreadsheet: 849565d1699989123-suming-cells-with-formulas-book1_r3
Sheet: Metrics

 | Forecast Finish Planned | Completed As Planned | Missed Tasks | Completed Early | Pending
Contacts
Doe, J.
Vader, D. |  |  |  |  | 0
[NAME], R. |  |  |  |  | 0
[NAME], F. |  |  |  |  | 0
Nuts, D. |  |  |  |  | 0
Spreadsheet: 35952d1233689359-formula-to-reset-a-count-based-on-cell-value-example-time_off_trkng
Sheet: Summary

Last Name | First Name | Hire Date | Earned Personal Hours | Unused Personal Hours | Earned Vacation Hours | Unused Vacation Hours
0 | 02 | 2007-11-07 00:00:00 | 16 | 16 | 40 | 40
1 | 13 | 2007-09-17 00:00:00 | 16 | 16 | 40 | 40
2 | 02 | 2008-04-14 00:00:00 | 16 | 16 | 0 | 0
3 | 13 | 2002-01-11 00:00:00 | 16 | 16 | 120 | 120
4 | 02 | 2003-03-10 00:00:00 | 16 | 16 | 120 | 120
5 | 04 | 2008-07-21 00:00:00 | 16 | 16 | 0 | 0
6 | 03 | 1994-08-14 00:00:00 | 16 | 16 | 120 | 120
7 | 19 | 2008-03-03 00:00:00 | 16 | 16 | 0 | 0
8 | 12 | 2006-12-11 00:00:00 | 16 | 16 | 40 | 40
9 | 13 | 2007-05-29 00:00:00 | 16 | 16 | 40 | 40
A | 18 | 1994-08-14 00:00:00 | 16 | 16 | 120 | 120
B | 19 | 2005-08-08 00:00:00 | 16 | 16 | 80 | 80
C | 05 | 2007-09-24 00:00:00 | 16 | 16 | 40 | 40
D | 04 | 2005-09-19 00:00:00 | 16 | 16 | 80 | 80
E | 10 | 2006-01-23 00:00:00 | 16 | 16 | 80 | 80
F | 20 | 2006-08-29 00:00:00 | 16 | 16 | 40 | 40
G | 10 | 2006-10-09 00:00:00 | 16 | 16 | 40 | 40
H | 18 | 1999-05-01 00:00:00 | 16 | 16 | 120 | 120
I | 01 | 2008-02-25 00:00:00 | 16 | 16 | 0 | 0
J | 04 | 2007-10-01 00:00:00 | 16 | 16 | 40 | 40
K | 10 | 2008-06-16 00:00:00 | 16 | 16 | 0 | 0
L | 05 | 2006-07-19 00:00:00 | 16 | 16 | 40 | 40
M | 13 | 1998-02-15 00:00:00 | 16 | 16 | 120 | 120
N | 04 | 2002-06-17 00:00:00 | 16 | 16 | 120 | 120
O | 19 | 2004-02-05 00:00:00 | 16 | 16 | 80 | 80
P | 19 | 2004-04-12 00:00:00 | 16 | 16 | 80 | 80
Q | 13 | 2008-04-14 00:00:00 | 16 | 16 | 0 | 0
R | 03 | 2008-01-16 00:00:00 | 16 | 16 | 40 | 40
S | 26 | 2007-01-26 00:00:00 | 16 | 16 | 40 | 40
T | 10 | 2006-04-03 00:00:00 | 16 | 16 | 40 | 40
U | 02 | 2007-09-17 00:00:00 | 16 | 16 | 40 | 40
V | 04 | 2006-06-21 00:00:00 | 16 | 16 | 40 | 40
W | 02 | 2006-04-05 00:00:00 | 16 | 16 | 40 | 40
X | 11 | 2004-11-19 00:00:00 | 16 | 16 | 80 | 80
Y | 02 | 2007-01-22 00:00:00 | 16 | 16 | 40 | 40
Z | 02 | 2007-02-19 00:00:00 | 16 | 16 | 40 | 40
 |  |  | 16 | 16 | 120 | 120
Spreadsheet: 770321d1645990867-indirect-list-help-excelhelp
Sheet: Week 1

 |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  | [NAME] |  |  | Day Off
 |  |  | [NAME] |  | Day Off
 |  |  | [NAME] | Day Off
 |  |  | Helen |  |  |  |  |  | Day Off
 |  |  | Emily |  |  |  |  | Day Off
 |  |  | [NAME] |  |  |  | Day Off
 |  |  | [NAME] |  |  | Day Off
 |  |  | [NAME] |  | Day Off
 |  |  | [NAME] | Day Off
 |  |  | Trevor |  |  |  |  |  | Day Off
Spreadsheet: 483525d1475696893-carton-of-250-help-copamzorder
Sheet: NEW LABEL

[NAME] From: |  |  | Enter Line Number |  |  | DATA
DTX International, Inc |  |  | 1 |  |  | Ship Warehouse
 |  |  |  |  |  | PO
 |  |  | Address Choice |  |  | ASIN
 |  |  | 3 |  |  | UPC
 |  | PRO# |  |  |  | SKU
 |  | BOL# |  |  |  | MASTER CTN
PO#: |  |  |  |  |  | TOTAL QTY TO SHIP
 |  |  |  |  |  | CARTON 1 of ?
 |  |  |  |  |  | BAR CODE 2D
 |  |  |  |  |  | EXP DATE IF NEEDED
ASIN:
UPC: |  |  |  |  |  |  | year, month, day
SKU:
MASTER CTN: |  |  |  |  |  |  | EXAMPLE  ,EXP:15023
CARTON: |  |  |  |  |  | AMZN,PO:3T435V4Y,UPC:[PHONE],QTY:24,EXP:140228,
Bar Code Packing Slip: |  |  |  |  |  | AMZN,PO:3T435V4Y,UPC:[PHONE],QTY:24,EXP:140228,
 |  |  |  |  |  |  | 1 | DTX International, Inc | 9855 N Front Street | Mancelona, MI 49659
 |  |  |  |  |  |  | 2 | DTX International, Inc | 140 Longmeadow Drive | Burlington, WI 53105
 |  |  |  |  |  |  | 3 | DTX International, Inc | CHINA | China
 |  |  |  |  |  |  | 4 | DTX International, Inc | 1392 [NAME] | Ontario, CA 91761
Spreadsheet: 90868d1290583632-large-with-if-function-sample
Sheet: Sheet1

Client ID | Client Name | Amount outstanding | Business Segment |  | All Segments
1000 | Alpha Inc | 4500000 | General |  | Rank | Largest Clients
1000 | Alpha Inc | 4500000 | General
1000 | Alpha Inc | 4500000 | General |  | 1
1001 | Beta inc | 6700000 | Special |  | 2
1001 | Beta inc | 6700000 | Special |  | 3
1001 | Beta inc | 6700000 | Special |  | 4
1002 | [NAME] | 7500000 | Auto |  | 5
1002 | [NAME] | 7500000 | Auto |  | 6
1003 | Delta Inc | 99000000 | Special |  | 7
1003 | Delta Inc | 99000000 | Special |  | 8
1004 | XYZ Inc | 10500000 | General |  | 9
1004 | XYZ Inc | 10500000 | General |  | 10
1004 | XYZ Inc | 10500000 | General
1005 | ABC Corp | 12099999 | Auto
1005 | ABC Corp | 12099999 | Auto |  | Auto
1006 | Lambda inc | 135000000 | Special |  | Rank | Largest Clients
1006 | Lambda inc | 135000000 | Special |  | 1
1007 | Omega Corp | 1000 | Auto |  | 2
1007 | Omega Corp | 1000 | Auto |  | 3
1008 | [NAME] | 99552200 | General |  | 4
1008 | [NAME] | 99552200 | General |  | 5
1008 | [NAME] | 99552200 | General |  | 6
1009 | [NAME] | 565656000 | Special |  | 7
1009 | [NAME] | 565656000 | Special |  | 8
1010 | [NAME] | 500 | Auto
1010 | [NAME] | 500 | Auto |  | General
1011 | [NAME] | 89684640 | Auto |  | Rank
1011 | [NAME] | 89684640 | Auto |  | 1
1012 | B1 Co | 8650401289 | Special |  | 2
1012 | B1 Co | 8650401289 | Special |  | 3
1013 | B2 Co | 54065540 | General |  | 4
1013 | B2 Co | 54065540 | General |  | 5
1014 | B3 Co | 100 | Auto |  | 6
1014 | B3 Co | 100 | Auto |  | 7
1015 | LMC Inc | 5000 | Special |  | 8
1015 | LMC Inc | 5000 | Special
1016 | GLL Inc | 9898803056 | General |  | Special
1016 | GLL Inc | 9898803056 | General |  | Rank
 |  |  |  |  | 1
 |  |  |  |  | 2
 |  |  |  |  | 3
 |  |  |  |  | 4
 |  |  |  |  | 5
 |  |  |  |  | 6
 |  |  |  |  | 7
 |  |  |  |  | 8
Spreadsheet: 754305d1636089060-applying-countif-formula-when-counting-values-from-multiple-worksheets-countif-example
Sheet: Law

Name | Staff ID | Staff type | Employed as/student type | Job description
Name 1 | ID 1 | Academic | Teaching & Research | Associate Professor
Name 2 | ID 2 | Non-academic | Honorary | Honorary Research Fellow
Name 3 | ID 3 | Non-academic | Honorary | [NAME]
Name 4 | ID 4 | Academic | Teaching & Research | Professor
Name 5 | ID 5 | Academic | Teaching | Assistant Professor
Name 6 | ID 6 | Non-academic | Adjunct | Adjunct Professor
Name 7 | ID 7 | Academic | Teaching & Research | Professor
Name 8 | ID 8 | Academic | Teaching & Research | Senior Lecturer
Name 9 | ID 9 | Non-academic | Adjunct | Adjunct Professor
Name 10 | ID 10 | Non-academic | Honorary | [NAME]
Name 11 | ID 11 | Academic | Teaching & Research | Senior Lecturer
Name 12 | ID 12 | Academic | Teaching & Research | Professor
Name 13 | ID 13 | Academic | Teaching & Research | Winthrop Professor
Name 14 | ID 14 | Academic | Teaching & Research | Senior Lecturer
Name 15 | ID 15 | Non-academic | Adjunct | [NAME]
Name 16 | ID 16 | Non-academic | Adjunct | [NAME]
Name 17 | ID 17 | Academic | Teaching & Research | Professor
Name 18 | ID 18 | Academic | Teaching & Research | Senior Lecturer
Name 19 | ID 19 | Academic | Teaching & Research | Professor
Name 20 | ID 20 | Non-academic | Honorary | Honorary Research Fellow
Name 21 | ID 21 | Academic | Teaching & Research | Associate Professor
Name 22 | ID 22 | Academic | Teaching & Research | Lecturer
Name 23 | ID 23 | Non-academic | Adjunct | [NAME]
Name 24 | ID 24 | Non-academic | Staff | Research Officer
Name 25 | ID 25 | Non-academic | Honorary | Honorary Research Fellow
Name 26 | ID 26 | Non-academic | Honorary | Senior Honorary Research Fellow
Name 27 | ID 27 | Non-academic | Adjunct | Adjunct Professor
Name 28 | ID 28 | Academic | Teaching & Research | Senior Lecturer
Name 29 | ID 29 | Non-academic | Adjunct | Adjunct Professor
Name 30 | ID 30 | Academic | Teaching & Research | Senior Lecturer
Spreadsheet: 558371d1517075141-create-a-formula-with-structured-references-to-calculate-the-percent-of-the-list-price-table-w-divide-operation-for-percentage
Sheet: Sheet1

Selling Price | List Price | Percentage
10 | 5
20 | 15
30 | 25
40 | 35
50 | 45
60 | 55
70 | 65
80 | 75
90 | 85
100 | 95
Spreadsheet: 599625d1543226792-create-a-report-from-a-data-table-sample
Sheet: Sheet1

CURRENT FORMAT
COMPANY NAME | WHAT SERVICES DO YOU USE | HOW WOULD YOU RATE OUR SERVICE | WOULD YOU RECOMMEND US | WHAT MAKES US STAND OUT AS A SUPPLIER
abc | Online banking | Good | Yes | Great customer service
DESIRED FORMAT
abc | WHAT SERVICES DO YOU USE | Online banking
 | HOW WOULD YOU RATE OUR SERVICE | Good
 | WOULD YOU RECOMMEND US | Yes
 | WHAT MAKES US STAND OUT AS A SUPPLIER | Great customer service
Spreadsheet: 69e5a7f6-5d8f-4597-b058-d59aba27db48
Sheet: Sheet1

GENERAL | 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
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  |  | Approval Deadline |  | Reason
 | First Amendment to
 | [NAME] TIF Plan
Details |  |  |  |  | Positions/Recommendations
 | Specific Address |  |  |  | Sponsor
 |  |  |  |  | Programs,
 |  |  |  |  | Departments,
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents |  | Tax Increment Financing Commission
 |  |  |  |  |  |  | City Department
 | Reason For Legislation
 |  |  |  |  |  |  | Other
 |  |  |  |  |  |  | North Kansas City School District
 |  |  |  |  |  |  | Clay EDC, Northland Neighborhoods Inc,
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By |  |  | Tax Increment Financing Com.
 |  |  |  |  | Recommendation |  |  |  |  |  | Resolution
 |  |  |  |  |  |  | X |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee Actions |  |  |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details
 |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Applicable Dates:
 | Approved by TIF Commission on April 12, 2006 by Resolution No. 4-6-06
Fact Sheet Prepared by:
Reviewed by:
Reference Numbers
Spreadsheet: 844316d1696043032-count-rows-to-calculate-position-post-position
Sheet: Sheet1

Track | Entrants |  |  |  | Track | Entrants
CT | 9 |  |  |  | CT | 14
Prgram # | Scratched | Position |  |  | Prgram # | Scratched | Position
 |  | 1 |  |  |  | x | x
 |  | 2 |  |  |  |  | 1
 | x | x |  |  |  |  | 2
 |  | 3 |  |  |  |  | 3
 |  | 4 |  |  |  |  | 4
 |  | 5 |  |  |  |  | 5
 | x | x |  |  |  | x | x
 |  | 6 |  |  |  |  | 6
 |  | 7 |  |  |  |  | 7
 |  |  |  |  |  | x | x
 |  |  |  |  |  | x | x
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9
 |  |  |  |  |  | x
Starters |  |  |  |  | Starters
Spreadsheet: 821331d1678632698-rank-from-current-table-to-desired-table-what-formula-do-i-use-rank-formula-5
Sheet: Sheet1

 | Current table |  |  |  |  |  |  |  | RESULT
 | potatoes | 12
 | carrots | 8
 | peas | 89
 | cabbage | 0
 | swede | 7
 | beans | 5
 | onions | 1047
 | Bananas | 100 |  |  |  |  |  |  |  |  | This should be lemons
 | Grapes | 201
 | Oranges | 1
 | Lemons | 89
 | Melons | 164
 | Apples | 1
 | Pears | 901
 | Plums | 33
 | Grapefruit | 18
 | Strawberries | 168 |  |  |  |  |  |  |  |  | This should be apples
 | Raspberries | 11
Spreadsheet: 875843d1722467098-locking-sheet-and-drop-down-list-ddlist
Sheet: Main

Title
Title 2
Areas | Q No | Question | Response | Outcome | Nos | Helper 1 | Helper 2 | Comment
Area 1 | 1 | Q1
Area 2 | 2 | Q2
 | 3 | Q3
 | 4 | Q4
 | 5 | Q5
Area 3 | 6 | Q6
 | 7 | Q7
 | 8 | Q8
Area 4 | 9 | Q7
 | 10 | Q8
 | 11 | Q9
 | 12 | Q10
Area 5 | 13 | Q11
 | 14 | Q12
Area 6 | 15 | Q13
Spreadsheet: craig_dean__4445__Bike to Beach '01
Sheet: Sheet1

 |  | riders |  |  |  |  | residuals unite!
Riders |  | Trailer/Gas |  | B'fast in Port and lunch |  |  | House | Sat dinner and Sun b'fast | Dinner #2 | Credits | Deposits | Owes
Todd |  |  |  |  |  |  |  |  |  |  | -50
Debbie |  |  |  |  |  |  |  |  |  |  | -50
Cyn |  |  |  |  |  |  |  |  |  |  | -70
[NAME] |  |  |  |  | 16 |  |  |  |  | -16 | -50
[NAME] | 51 |  |  |  | 20 |  |  |  |  | -71
[NAME] | 25 |  |  |  |  |  |  |  |  | -25
Billy |  |  | 80 |  | 95 | 835 |  |  |  | -1010
[NAME]
Stew |  |  |  |  |  |  |  |  |  |  | -50
[NAME] |  |  |  |  |  |  |  |  |  |  | -50
Caroline |  |  |  |  |  |  |  |  |  |  | -50
Erin |  |  |  |  |  |  |  |  |  |  | -60
[NAME] |  |  |  |  |  |  |  |  |  |  | -60
[NAME]
[NAME]
Rachel |  |  |  |  |  |  |  |  |  |  | -70
Friends |  |  |  |  |  |  | House | Sat dinner and Sun b'fast |  | Credits | Deposits | Owes
[NAME] |  |  |  |  | 10 |  |  |  |  | -10 | -50
Cathy |  |  |  |  |  |  |  |  |  |  | -50
[NAME] |  |  |  |  |  |  |  |  |  |  | -50
Axel |  |  |  |  | 100 |  |  |  |  | -100 | -50
[NAME] |  |  |  |  |  |  |  |  |  |  | -60
Travis | 10 |  |  |  | 35 |  |  |  |  | -45
[NAME]
Tess |  | too |  | cute |  |  | for | words. |  | On | scho | larship!
Spreadsheet: 111500d1307880624-summarising-data-from-multiple-worksheets-cashbook-sample-2
Sheet: Lists

Transaction Type |  | VatCode | Rate | Mult
D/D |  | E | 0 | 0
CHQ |  | L | 0.05
BACS |  | O | 0 | 0
CC |  | S | 0.2
S/O |  | Z | 0 | 0
BULKPAY
PC
CC
Spreadsheet: 2532feeb-5693-4fe6-b857-1662c8e9ccec
Sheet: 2RD OUT OF 166

ANON# | RANK
11267 | 15
11825 | 21
12891 | 2
13393 | 8
13925 | 6
15439 | 19
16142 | 23
18013 | 24
18946 | 7
19869 | 41
20142 | 26
20438 | 22
23981 | 18
28588 | 17
44028 | 30
44112 | 13
48496 | 3
49948 | 27
49963 | 33
52966 | 11
54823 | 16
58228 | 37
62956 | 42
64784 | 5
66666 | 4
66816 | 32
67998 | 39
70658 | 25
72014 | 14
73323 | 31
76975 | 1
77221 | 20
77922 | 10
81070 | 9
84707 | 28
87670 | 40
88310 | 35
88555 | 33
92071 | 12
96445 | 38
98845 | 36
99308 | 29
Spreadsheet: 712660d1610363681-combine-data-from-multiple-sheets-on-one-sheet-cert-jobs-wip-gk3
Sheet: 63373

Employee Login | Module ID | [NAME] | Grade | Shift Pattern
vtovar | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NT6-0000
qwillich | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NE1-0000
patrlutt | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | DO3-0800
osorwill | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NE7-0045
shelbihe | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NE1-0045
gemsuyat | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NS2-0045
carrbeav | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NM2-0045
isaiasja | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NT6-0000
[NAME] | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NE1-0030
[NAME] | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NE1-0030
[NAME] | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NS3-0030
[NAME] | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NE1-0000
ortalja | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass
higdonno | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NW4-0000
jzzubi | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NS2-0000
chavedes | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NW4-0030
olivrez | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass
rojeness | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NE1-0030
maljro | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass
michvial | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NE1-0045
napjuare | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass
regibray | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NE1-0000
[NAME] | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NW5-0000
vincscor | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NE1-0000
armsjas | 63373 | PMV_FC_Wide-Floor-Scraper_FAT1 | Pass | NM2-0000
Spreadsheet: 189156d1351101807-looking-to-calculate-months-rent
Sheet: Customer

NAME | START DATE | PAYMENT | # OF MONTHS | DUE DATE
[NAME] | 2012-05-01 00:00:00 | 2012-11-01 00:00:00 | 1 | 2012-11-30 00:00:00
[NAME] | 2012-05-01 00:00:00 | 2012-11-01 00:00:00 | 2 | 2012-11-30 00:00:00 | <--- This should be 12/31/12
[NAME] | 2012-05-01 00:00:00 | 2012-11-01 00:00:00 | 3 | 2012-11-30 00:00:00 | <--- This should be 01/31/2013
Spreadsheet: 877551d1724347723-if-and-or-formula-assistance-excel-file-example
Sheet: BUYOUT

 | GP Goal | YTD Delta | Prior YTD Delta | Jul 2024 |  |  | FY 2025 YTD |  |  | 2024
Customer |  |  |  | Revenue | GP $ | GP % | Revenue | GP $ | GP % | Revenue | GP $ | GP %
Customer 1 |  |  |  | 90465.04 | 27084.51 | 0.2993920082277087 | 135657.17 | 44895.82 | 0.3309505866884883 | 405287.23 | 126292.62 | 0.3116126308741581
Customer 2 | 0.38 |  |  | 137720.55 | 59538.18 | 0.4323115177800264 | 426978.85 | 187620.12 | 0.4394131465762297 | 2815209.24 | 1418519.31 | 0.5038770439670764