tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 270151d1381402990-rank-employees-based-on-performances-salespivot
Sheet: Sheet2

Years | (All)
Quarters | (All)
Date | (All)
Row Labels | Sum of # Sales
R | 669
I | 613
H | 594
G | 589
U | 568
Grand Total | 3033
Spreadsheet: 89915d1289663136-total-points-week-12-score
Sheet: Table

PREMIER LEAGUE FORECAST
WEEK 12
 | Pos | Name | Pts
 | 1 | [NAME] | #N/A
 | 2 | [NAME] | #N/A
 | 3 | [NAME] | #N/A
 | 4 | [NAME] | #N/A
 | 5 | [NAME] | #N/A
 | 6 | [NAME] | #N/A
 | 7 | [NAME] | #N/A
 | 8 | [NAME] | #N/A
 | 9 | [NAME] | #N/A
 | 10 | [NAME] | #N/A
 | 11 | [NAME] | #N/A
 | 12 | [NAME] | #N/A
 | 13 | [NAME] | #N/A
 | 14 | [NAME] | #N/A
 | 15 | 0 | 0
Spreadsheet: 851580d1701790596-predict-the-score-game-predict-the-score
Sheet: Week 4

2023-12-15 00:00:00
 |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Jordan |  | [NAME] |  | [NAME] |  | [NAME]
 | Nott Forest
 | Tottenham
 | Bournemouth
 | Luton
 | Chelsea
 | Sheff utd
 | Man city
 | Palace
 | Newcastle
 | Fulham
 | Burnley
 | Everton
 | [NAME]
 | Wolves
 | Brentford
 | A Villa
 | Arsenal
 | Brighton
 | Liverpool
 | Man Utd
 |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Jordan |  | [NAME] |  | [NAME] |  | [NAME]
Spreadsheet: 55765d1255964847-sumproduct-with-if-statement-book2_oct19
Sheet: Sheet2

Volume | Unit | Cost
44 | 14.11 | n/a
9 | 10.46 | 8.58 |  | 1596.14
37 | 9.61 | 7.88
20 | 8.26 | 6.77
78 | 7.36 | 6.04
0 | 3.65 | n/a
Spreadsheet: 103562d1301329025-how-do-i-convert-table-1-to-table-2-book1_cicihk_rows_to_column-1-
Sheet: Sheet1 (2)

Table 1
 | 1 | 2 | 3 | 4
a | 0 | 6 | 0 | 10
b | 5 | 50 | 0 | 0
c | 0 | 10 | 7 | 0
d | 8 | 11 | 0 | 8
Spreadsheet: 830446d1684924478-formula-to-allocate-numbers-in-excel-example1
Sheet: Sheet1

SKU | Location | Stock | Allocate | Result |  | SKU | Allocate
A | B01 | 10 |  | 10 |  | A | 11
B | B01 | 5 |  | 5 |  | B | 6
A | B03 | 2 |  | 1 |  | C | 10
C | B02 | 3 |  | 3 |  | D | 6
C | B03 | 6 |  | 6
D | B04 | 3 |  | 3
D | B01 | 4 |  | 3
D | B02 | 1 |  | 0
Spreadsheet: 82048d1282112522-custom-formula-in-pivot-table-samplept
Sheet: After

This is the after effect.
I tried create a Division column with formula like =C5/B5 but I can't seems to sort the Division column together with the Pivot Table.
Please advise.
 | Values
Row Labels | Sum of Time | Sum of Visit | Division
Australia | 1230 | 30
Brazil | 3320 | 12
China | 4836 | 36
Denmark | 2837 | 19
England | 5669 | 44
France | 2768 | 8
Germany | 3918 | 11
Grand Total | 24578 | 160
Spreadsheet: 0cbd6622-10ef-4bc6-b039-06a50ab7e742
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 40. OPERATING LEASE FINANCE COMMITMENTS: By Lender: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Banks ; |  |  | Original | A2413831L | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
Finance Companies ; |  |  | Original | A2413832R | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
General Financiers ; |  |  | Original | A2413833T | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
Other Lessors ; |  |  | Original | A2413834V | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413835W | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 883999d1732845648-weighted-average-with-multiple-criteria-help-weighted-average-2
Sheet: Revenue Share Breakdown - STAND

 |  |  | NEW |  | EXISTING |  | NEW |  | EXISTING
 | Country 1 | 0.5 |  | 0.697662247034194 |  | 0.6511514305652477 |  | 0.593012909979065 |  | 0.5534787159804605
 | Country 2 | 0.34 |  | 0.697662247034194 |  | 0.6511514305652477 |  | 0.5930129099790649 |  | 0.5534787159804605
 | Country 3 | 0.07 |  | 0.6874478732276897 |  | 0.6416180150125104 |  | 0.5843306922435363 |  | 0.5453753127606338
 | Country 4 | 0.06 |  | 0.6976622470341939 |  | 0.6511514305652476 |  | 0.5930129099790649 |  | 0.5534787159804605
 | Country 5 | 0.01 |  | 0.6874478732276897 |  | 0.6416180150125104 |  | 0.5843306922435362 |  | 0.5453753127606338
 | Country 6 | 0.02 |  | 0.6874478732276896 |  | 0.6416180150125104 |  | 0.5843306922435363 |  | 0.5453753127606339
 |  |  | 28220 |  | 31610.5 |  | 28220 |  | 31610.5
Spreadsheet: 77443d1277912394-extract-room-number-and-student-id-and-put-them-in-other-cells-studenthousing-3-
Sheet: 3716

Building No:- 3716 | Mr. [NAME] | Mr. [NAME] | Miss Walker Celie | Mrs. March Augie | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME]
Date | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo
2010-06-30 00:00:00 | 215 | 300 | 305 | 307 | 116A | 201B | 205B | 212A | 307A | 308B | 317B
OUTSTANDING
SATISFACTORY
UNSATISFACTORY
DOOR UNLOCKED
WINDOW UNLOCKED
LOCKER UNLOCKED
CARPET Not SWEPT
DUST
BEDS UNMADE
MESSY
MICROWAVE DIRTY
FREEZER DIRTY
REFRIGERATOR DIRTY
LIGHTS / APPLIANCES ON
CEILING FAN ON
OPEN FOOD NOT STORED
TRASH IN ROOM / HEAD
MIRROR / SHELF DIRTY
SINK / BRIGHTWORK DIRTY
FLOOR IN BATH DIRTY
TUB / SHOWER DIRTY
SHOWER CURTAIN DIRTY
TOILET DIRTY
ODOR
Dirty TILE
Spreadsheet: 2e5aeae7-3b6a-450d-9224-8b29267c2489
Sheet: Quarterly - Long-Term Infl Exp

Quarterly Question: Projecting ahead, to the best of your ability, please assign a percent likelihood to the following changes to unit costs per year over the next FIVE TO 10 years.
Month | Number of Responses | Unit costs down  (<-1%) | Unit costs about unchanged  (-1% to 1%) | Unit costs up somewhat (1.1% to 3%) | Unit costs up significantly (3.1% to 5%) | Unit costs up very significantly  (>5%) | Mean | [NAME]
2012-02-17 00:00:00 | 89 | 0.04078651685393259 | 0.1143820224719101 | 0.3788764044943821 | 0.292134831460674 | 0.1738202247191011 | 0.029 | 0.028
2012-04-13 00:00:00 | 152 | 0.03684210526315786 | 0.1152631578947368 | 0.3626315789473684 | 0.300921052631579 | 0.184342105263158 | 0.03 | 0.026
2012-07-20 00:00:00 | 153 | 0.04006493506493503 | 0.1491558441558442 | 0.3570779220779222 | 0.2640259740259741 | 0.1896753246753247 | 0.028 | 0.029
2012-10-19 00:00:00 | 196 | 0.0387301587301587 | 0.1275661375661376 | 0.3616402116402118 | 0.2974603174603175 | 0.1746031746031747 | 0.029 | 0.027
2013-01-11 00:00:00 | 196 | 0.03195121951219512 | 0.12 | 0.32 | 0.28 | 0.23 | 0.03 | 0.025
2013-04-12 00:00:00 | 189 | 0.03635279463762396 | 0.1247942885739619 | 0.3830080704715921 | 0.2586793008840816 | 0.1971655454327405 | 0.029 | 0.022
2013-07-12 00:00:00 | 209 | 0.04 | 0.14 | 0.37 | 0.28 | 0.15 | 0.028 | 0.024
2013-10-11 00:00:00 | 216 | 0.04 | 0.15 | 0.45 | 0.26 | 0.11 | 0.027 | 0.024
2014-01-10 00:00:00 | 208 | 0.03848039215686271 | 0.1973684210526316 | 0.4276315789473685 | 0.2142105263157895 | 0.113421052631579 | 0.02805294117647058 | 0.02304741176470588
Spreadsheet: michelle_lokay__26621__imbalsumm0102
Sheet: Amoco Abo

 | [NAME]
Day | Measured | Scheduled | Imbal
1 | 12775 | 10600
2 | 13246 | 10600
3 | 13142 | 10600
4 | 12799 | 10600
5 | 13325 | 10600
6 | 13103 | 10074
7 | 12780 | 10600
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  | 1002068.76
2001-02-07 00:00:00
Spreadsheet: e2f3111d-1ae1-47d7-bf60-796777b9455d
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
40274182 | 2014-02-28 01:52:54 | AXIS | 0 | 3 | 6 | 1530615 | semen_ua | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
40274310 | 2014-02-28 02:12:08 | ALLIES | 1 | 6 | 3 | 1530615 | semen_ua | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
Spreadsheet: 9d78581a-1b5e-4d56-b49b-d3bfd2204e7d
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FOOD7 | Test | FOOD7 | Food-Seafood Panel | Food-Seafood Panel | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel [NAME]: 0.5 mL Additional Information: See Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
FOOD7 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FOOD7 | Result | FOOD7 | Food-Seafood Panel | Food-Seafood Panel | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 46712-6 | (Gadus morhua+Mytilus edulis+Pandalus borealis+Salmo salar+Thunnus albacares) Ab.IgE:ACnc:Pt:Ser:Qn:Multidisk
Spreadsheet: 691872d1597928088-return-fiscal-calendar-month-year-and-period-based-on-calendar-date-fiscal-dummy
Sheet: Fiscal Calendar

Calendar Month | Fiscal Month | Fiscal Year | Fiscal Period | Days |  |  | 2
2019-12-01 00:00:00
2020-01-01 00:00:00
2020-02-01 00:00:00
2020-03-01 00:00:00
2020-04-01 00:00:00
2020-05-01 00:00:00
2020-06-01 00:00:00
2020-07-01 00:00:00
2020-08-01 00:00:00
2020-09-01 00:00:00
2020-10-01 00:00:00
2020-11-01 00:00:00
2020-12-01 00:00:00
2021-01-01 00:00:00
2021-02-01 00:00:00
2021-03-01 00:00:00
2021-04-01 00:00:00
2021-05-01 00:00:00
2021-06-01 00:00:00
2021-07-01 00:00:00
2021-08-01 00:00:00
2021-09-01 00:00:00
2021-10-01 00:00:00
2021-11-01 00:00:00
2021-12-01 00:00:00
Spreadsheet: 836480d1689393084-query-across-multiple-columns-and-multiple-criteria-with-flexible-content-ice-monthly-plan-stuart33-
Sheet: Project A

Project | Project A
Start | 2024-01-01 00:00:00
Months (+2) | 38
DOA | 1000000
Person ID | Person Name | Period Cost |  | Project Cost
A | Fred | 6600 |  |  |  | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
B |  | 13200
C | [NAME] | 19800 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1
D | [NAME] | 33000 |  |  |  | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
TOTAL
Diff to DOA
 |  |  |  |  |  | NB The date starts at 2024-01-01 and 3 people are used ADC
Spreadsheet: 142961d1330104251-date-formatting-not-functioning-dateformat
Sheet: Sheet1

Number | Signer | Date_Entered | Date_Complete
5656453 | [NAME] | 2012-01-29 22:48:08 | 2012-01-31 08:06:03
564564564 | [NAME] | 2012-01-22 00:39:35 | 2012-02-08 09:37:15
564 | [NAME] | 2012-01-29 05:56:51 | 2012-02-08 09:37:15
5646564 | [NAME] | 2012-01-22 01:33:27 | 2012-02-08 09:37:15
54654564 | [NAME] | 2012-01-28 01:46:50 | 2012-02-08 09:37:15
564564564 | [NAME] | 2012-02-05 02:42:44 | 2012-02-08 09:37:15
321 | [NAME] | 2012-02-05 07:47:51 | 2012-02-05 08:49:08
321231231 | [NAME] | 2012-02-09 15:06:54 | 2012-02-10 07:17:57
Spreadsheet: 864350d1711556277-how-can-i-enhance-this-sumproduct-formula-to-only-counts-cells-greater-than-zero-sumproduct-question-1-
Sheet: NON-WORKING Version

Year | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2025 | 2025 | 2025 | 2025
Month | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00
Users | 25 | 28 | 26 | 21 | 29 |  | 33 |  |  | 27 | 27 | 25 | 23 | 22 | 27 | 29 | 31
Hours | 501 | 608 | 612 | 574 | 773 |  | 768 |  |  | 639 | 622 | 611 | 634 | 620 | 799 | 632 | 733
Avg of Monthly Hours
Year Selected ([NAME]) | 2024
Spreadsheet: 864866d1711995712-sum-single-vs-combined-cell-values-test
Sheet: Summary Sorted

What I currently have |  |  |  |  |  |  | What I would like
Tag Number | Group | Room |  | Area/Room | Area/Group |  | Tag Number | Group | Room |  | Area/Room or Group
Sorted |  |  |  |  |  |  | Sorted
 |  |  |  |  |  |  | ABC-XX-01 | [NAME] | RR 1 |  | 100
ABC-XX-02 |  |  |  |  |  |  | ABC-XX-02 | G20 | Patio |  | 500
ABC-XX-03 |  |  |  |  |  |  | ABC-XX-03 | G9 | Living |  | 300
ABC-XX-04 |  |  |  |  |  |  | ABC-XX-04 | G21 | Study |  | 150
ABC-XX-05 |  |  |  |  |  |  | ABC-XX-05 | C1 | Bed 1 |  | 450 | this would show the total group area bc cell [NAME] is not overriden from a blank cell to a number
ABC-XX-06 |  |  |  |  |  |  | ABC-XX-06 | A4 | Dining |  | 300 | this would show the area per rooms since cells C20 and C21 are overriden from a blank cell to number
ABC-XX-12 |  |  |  |  |  |  | ABC-XX-12 | A4 | Kitchen |  | 350
ABC-XX-13 |  |  |  |  |  |  | ABC-XX-13 | A4 | Powder |  | 50
ABC-XX-15 |  |  |  |  |  |  | ABC-XX-15 | B9 | Dining |  | 300 | this would show the total group area bc cell C14 or C15 are not overriden from a blank cell to a number
 |  |  |  |  |  |  | I was trying to do something with lookups but I am not able to figure out how to capture the other rooms that are in the same group (column D in Master).  Essentially what i would like is this: C6 is populated in Master (which has 2 rooms in the same group, column D) and it should then get S6 (450 which is the sum of R6 and R7),  however, if [NAME] were to be filled in, then C6 would return R6 only (instead of S6), and [NAME] would return R7.   Basically, the cell in column C in Master for each group in Master is the leader, and any populated cells under the leader cell are the child leaders. if the child leaders are filled, then instead of seeing the overall group area, it should show the room area.
Spreadsheet: a5ec482d-9d5f-43c6-a626-7138bd139bd2
Sheet: 2Plans-2Opt

 | Insured HRA Quote for:
 | Current Plans
 |  | Status | # |  |  |  | # |  | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 | Renewal Plans
 |  | Status | # |  |  |  | # |  | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 | Proposed Plan 1: Annual Savings Versus Renewal PH HMO
 |  | Status | Census | Medical |  | Insured HRA 250 Ded 80% to $750 |  |  | Total
 |  | Employee |  | 247.46 |  | 137.81
 |  | 2 Person |  | 593.89 |  | 263.48
 |  | Emp/Child |  |  |  | 0
 |  | Family |  | 742.37 |  | 373.27
 |  |  |  |  |  | 4Kdd/10K
 |  | Status | Census |  |  |  | Insured HRA |  | Total
 | 12 | Employee
 | 0 | 2 Person
 |  | Emp/Child
 | 1 | Family
 |  | Status | Census |  |  |  |  |  | Total
 | 28 | Employee
 | 10 | 2 Person
 |  | Emp/Child
 | 30 | Family
 |  | Proposed Plan Totals
 | Plan Summary
 |  | Proposed Plan 1: Annual Savings Versus Renewal
 |  | Proposed Plan 2:  Annual Savings Versus Renewal
Spreadsheet: a47d8226-e54d-4ce1-a243-51a340b6c39c
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
 | Sixth Amendment to
 | Chouteau I-35 TIF Plan
Details |  |  |  |  | Positions/Recommendations
 | Specific Address |  |  |  | Sponsor
 |  |  |  |  | Programs,
 |  |  |  |  | Departments,
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 | Reason For Legislation
 |  |  |  |  | Applicants / |  | Applicant: Tax Increment Financing
 |  |  |  |  | Proponents |  | Commission
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff |  | X |  | For
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | 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 |  | x |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on next page)
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 January 9, 2008 by Resolution No. 01-13-08
Fact Sheet Prepared by:
Reviewed by:
Reference Numbers
Spreadsheet: 575867d1527720930-random-pair-generation-with-multiple-criteria-index-match-copy-of-random-pair-generator-with-criteria-vankmj-
Sheet: Sheet39

 | Criteria |  |  |  |  |  |  | Problem
 | 1) Two people to be paired up randomly, but |  |  |  |  |  |  | I don't know what formula to put in for 'Matched Person's Name' column
 | 2) Two people to be from the SAME cluster (Same Cluster Code)
 | 3) Two people to be from the DIFFERENT department (Different Department Code)
 | 4) Should be automatic calculation -no manual rand() sorting
 | Full Name | Cluster code | Dept Code | [NAME] Name | Rand() |  | Full Name | Cluster code | Dept Code | [NAME] Name
 | Leo | A | a
 | Precious | A | a
 | Kelle | A | b
 | Claribel | A | c
 | [NAME] | B | a
 | Val | B | a
 | [NAME] | C | a
 | [NAME] | C | b
 | Christen | C | c
 | [NAME] | C | r
 | Bradford | C | s
 | Adelaida | C | t
 | Malia | C | u
 | Yolonda | D | a
 | Aundrea | D | a
 | Lakisha | D | ab
 | Harold | D | ac
 | Miguel | D | ad
 | [NAME] | D | b
 | Otis | D | c
 | Rita | D | d
 | [NAME] | D | e
 | [NAME] | D | f
 | [NAME] | D | g
 | [NAME] | D | h
 | Rona | E | a
 | Anisha | F | a
 | [NAME] | F | b
 | Marlana | F | c
 | [NAME] | F | d
 | Carissa | K | c
 | Tamiko | K | d
 | Idella | K | e
 | Pam | K | f
 | Cesar | K | g
Spreadsheet: 675931d1588572017-count-unique-value-help
Sheet: Sheet1

 | Company name | Wave
 | A | 1 |  |  | Wave 1 | 2
 | B | 1 |  |  | Wave 2 | 2
 | B | 1 |  |  | Wave 3 | 1
 | B | 2 |  |  | Wave 4 | 2
 | B | 2
 | B | 2
 | C | 3
 | C | 3
 | C | 3
 | C | 4
 | D | 4
 | D | 4
 | D | 4
 | D | 2
Spreadsheet: 1d17ec90-af48-4ebb-b3c2-28f241eac0b1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
ID | Hybridization | Sex | Age
CauA1 | A | male | 29
CauA2 |  | male | 37
CauB1 | B | female | 38
CauB2 |  | female | 34
CauC1 | C | male | 42
CauC2 |  | male | 38
CauD1 | D | female | 46
CauD2 |  | female | 46
Spreadsheet: 167944d1342164921-i-want-to-send-data-in-multiple-workbook-projcet-22-expense-ledger
Sheet: Payment Received from Owner 

 |  |  |  |  |  | PROJECT # 22
 |  |  |  |  |  | Received from Client-OWNER
DATE | B# | P# | L# | V# | A/C | Description |  |  |  | Cheq#/PS | Bank | Book# | A/C Ref # |  |  | DEBIT | CREDIT | BALANCE
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]# | Page# | Ledger#
2009-07-26 00:00:00 | 1 | 91 | L-06 |  |  | Received cheque H.M.B |  |  |  | 43397176 |  |  |  | 114 | L-05 | 2500000 |  | 2500000
2009-08-09 00:00:00 | 2 | 91 | L-06 |  |  | Received cheque H.M.B |  |  |  | 43397177 |  |  |  | 129 | L-05 | 100000 |  | 2600000
Spreadsheet: 482942d1475361942-how-to-set-up-pivot-table-data-book5
Sheet: Sheet1

Category | Subcategory | Sub Sub
Channel Sales | Online
Channel Sales | Direct
Channel Sales | Retail
Channel Dollars | Online
Channel Dollars | Direct
Channel Dollars | Retail
State | County | City
State | County | City
State | County | City
Spreadsheet: 1b25b2ed-7cff-4243-8917-6139f1a16798
Sheet: Annuity, A-FV

Discount Factor Table for Annuity
Annuity (A) --> Future Value (FV) |  |  |  |  |  |  |  |  | Column: discount rate (r%), Row: Year (n)
 |  |  |  |  |  |  |  |  | [NAME]: ((1+r)^n-1)/r
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Spreadsheet: jane_tholt__13278__bid2001A
Sheet: MAY-00

 |  |  |  |  | Bass Enterprises Production Co.
 |  |  |  |  | November 2001 - March 2002 Bid Package
 | FIELD |  |  |  | PIPELINE(S) | MMbtu/D |  | [NAME]. | County | State
 | NORTH WORD |  |  |  | HPL | 7000 |  | 9807 | Lavaca | Texas
 |  |  |  |  | Midcon Texas |  |  | 6007
 |  |  |  |  | Crosstex Gulf Coast
 | RAMBLER |  |  |  | TETCO | 1300 |  | 95601 or S.Tx Pooling Pt. #79501 | Dewitt | Texas
 |  |  |  |  | EPGT |  |  | 553-750
 | FLORES (LA GLORIA) |  |  |  | TENNESSEE | 1300 |  | Duke's LaGloria Plant | [NAME] | Texas
 |  |  |  |  | Trunkline, NGPL |  |  | Outlet Pipes
 |  |  |  |  | Channel, Coral Mexico
 | POINTE-A-LA-HACHE, COX BAY |  |  |  | SNG | 5000 |  | SNG 0144100, 014800 | Plaquemines | Louisiana
 | WEST SANDY HOOK |  |  |  | SNG | 300 |  | SNG 048500 | Marion | Mississipi
 | [NAME] |  |  |  | EPNG | 15000 |  | SRGC - KEYSTONE PLANT | Winkler | Texas
 | GOMEZ |  |  |  | OASIS | 3000 |  | WGR Gomez #4466 | Pecos | Texas
 |  |  |  |  | EPGT |  |  | WGR Gomez #504-218
 | PYOTE FIELD |  |  |  | Oasis - Waha | 800 |  | Waha header | Pecos | Texas
 |  |  |  |  |  |  |  | via SRGC transport
 | [NAME] |  |  |  | EPFS | 2800 |  | 10 Meters(EPFS) | Eddy | New Mexico
 | BIG EDDY |  |  |  | TRANSWESTERN | 1900 |  | [NAME] | Eddy | New Mexico
 | JAL PLANT RESIDUE |  |  |  | EPNG | 2000 |  | Mainline Pool | [NAME] | New Mexico
 | POKER LAKE |  |  |  | EPNG | 2500 |  | [NAME] | Eddy | New Mexico
 | POKER LAKE |  |  |  | EPNG | 4000 |  | Waha Pool | Pecos | Texas
 | TERRELL |  |  |  | EPNG | 1000 |  | 37506747 | Terrell | Texas
 |  |  |  |  | EPGT |  |  | 503-536
 |  |  |  | TOTAL