tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 763968d1642510070-solving-a-cash-flow-requirement-by-algebra-solving-balances
Sheet: Sheet1

 |  |  | Cash Flow | 0
 |  |  | Opening Balance
 |  |  | Income |  | 1.5 | 1.6 | 1.8
 |  |  | Loan |  | 0.75 | 0 | 0
 |  |  | Own Funds |  | 1.6 | 0.4 | 0
 |  |  | Less: Expense |  | -2.5 | -2 | -1.5
 |  |  | Less: Repay Loan
 |  |  | Less: Repay Own Funds
 |  |  | Closing Balance | 0
 |  |  | Loan Opening Balance
 |  |  | [NAME]
 |  |  | Repay Loan
 |  |  | [NAME] | 0.75
 |  |  | Own Funds Opening Balance
 |  |  | [NAME]
 |  |  | [NAME] Funds
 |  |  | Own Funds Closing Balance | 0.5
Spreadsheet: 766337d1643848457-searching-for-data-in-two-lists-player-a-and-player-b-the-same-as-player-b-and-player-a-examplepairings-2-
Sheet: Sheet1

Player Together Unique Pairs
PlayerA & PlayerB | PlayerB & PlayerA
PlayerA & PlayerC | PlayerA & PlayerC
PlayerA & PlayerE | PlayerB & PlayerE
PlayerA & PlayerF | PlayerC & PlayerH
PlayerA & PlayerG | PlayerA & PlayerM
PlayerA & PlayerH | PlayerP & PlayerA
PlayerA & PlayerI | PlayerK & PlayerA
PlayerA & PlayerJ
PlayerA & PlayerK
PlayerA & PlayerL
PlayerA & PlayerM
PlayerA & PlayerN
PlayerA & PlayerO
PlayerA & PlayerP
PlayerA & PlayerQ
PlayerA & PlayerR
PlayerA & PlayerS
PlayerA & PlayerT
PlayerB & PlayerC
PlayerB & PlayerE
PlayerB & PlayerF
PlayerB & PlayerG
PlayerB & PlayerH
PlayerB & PlayerI
PlayerB & PlayerJ
PlayerB & PlayerK
PlayerB & PlayerL
PlayerB & PlayerE
PlayerB & PlayerN
PlayerB & PlayerO
PlayerB & PlayerP
PlayerB & PlayerQ
PlayerB & PlayerR
PlayerB & PlayerS
PlayerB & PlayerT
PlayerC & PlayerE
PlayerC & PlayerF
PlayerC & PlayerG
PlayerC & PlayerH
PlayerC & PlayerI
Spreadsheet: e4517e33-96f6-456a-b386-e9caaa674f4f
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Leipzig, Stadt - Variante 2
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 6 | 29500 | 29458 | 28140 | 24993
6 - 15 | 32676 | 36198 | 39583 | 39254
15 - 25 | 55905 | 38592 | 42475 | 45771
25 - 40 | 123240 | 125945 | 110433 | 96475
40 - 65 | 173767 | 172779 | 172938 | 174512
65 und mehr | 116721 | 119990 | 126307 | 130956
Insgesamt | 531809 | 522962 | 519876 | 511961
%
unter 6 | 5.547104317527533 | 5.632914054940894 | 5.412829213120052 | 4.881817169667221
6 - 15 | 6.144311209475582 | 6.921726626408802 | 7.613931014318799 | 7.667380913780542
15 - 25 | 10.51223277530091 | 7.379503673307047 | 8.170217513407044 | 8.940329439156498
25 - 40 | 23.17373342685062 | 24.08301176758541 | 21.24218082773585 | 18.84420883621995
40 - 65 | 32.67470087945108 | 33.03853817294564 | 33.26524017265655 | 34.08697146852983
65 und mehr | 21.94791739139428 | 22.9443057048122 | 24.2956012587617 | 25.57929217264596
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 453096d1459167706-want-to-match-time-in-out-by-employee-id-to-cell-from-punch-card-data-test-in-out-01
Sheet: Report1

 |  |  |  |  | Weekly Time Sheet
 | Employee ID : | 4900651 |  | Name :
 | Title : |  |  | Dept. :
 | Start Date : | 2016-01-01 00:00:00 |  | Number of working days per week : |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | I | O | I | O
 | Date | Day | Time |  |  |  | Hours |  |  |  |  |  | 1 | 1 | 2 | 2
 |  |  | In | Out | In | Out | In | Out | Time | OT |  |  | Helper | Helper | Helper | Helper
 | Total Hour
 | [NAME] |  |  |  |  |  | 10 | 10 | 5 | 5
 | Total Hour x Hourly Rate
 | TOTAL
 | Notes :
 | Signature of Employee : |  |  |  |  |  |  | Date:
 | Signature of Supervisor : |  |  |  |  |  |  | Date:
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 5

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Tue 30 May Glucose mmol/L
Wed 31 May Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Thu 1 Jun Glucose mmol/L
 |  |  |  |  | 5.8
Fri 2 Jun Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  |  | 5.7
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sat 3 Jun Glucose mmol/L
Sun 4 Jun Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 6.4
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Mon 5 Jun Glucose mmol/L
 |  |  |  |  | 5.4
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Tue 6 Jun Glucose mmol/L
Spreadsheet: 670016d1585707512-creating-a-cleaning-and-product-usage-schedule-cleaning-time-3-
Sheet: Sheet1

Choose Current Product |  |  |  | Choose Product your changing to |  |  |  |  |  | Product | Hopper | Helper | Material |  |  | Hopper | Clean Time |  | All Products
2 |  |  |  | 3 |  |  |  |  |  | 1 | 1 |  | Mat1 |  |  | 1 | 12 |  | 1
 |  |  |  |  |  |  | Clean Time |  |  | 1 | 2 |  | Mat2 |  |  | 2 | 14 |  | 2
Hopper | Material |  |  | Hopper | Material |  |  | <=Total Time |  | 1 | 4 |  | Mat4 |  |  | 3 | 12 |  | 3
 |  |  |  |  |  |  |  |  |  | 1 | 6 |  | Mat6 |  |  | 4 | 15
 |  |  |  |  |  |  |  |  |  | 1 | 8 |  | Mat8 |  |  | 5 | 17
 |  |  |  |  |  |  |  |  |  | 1 | 9 |  | Mat9 |  |  | 6 | 11
 |  |  |  |  |  |  |  |  |  | 2 | 2 |  | Mat2 |  |  | 7 | 20
 |  |  |  |  |  |  |  |  |  | 2 | 3 |  | Mat3 |  |  | 8 | 15
 |  |  |  |  |  |  |  |  |  | 2 | 5 |  | Mat5 |  |  | 9 | 5
 |  |  |  |  |  |  |  |  |  | 2 | 7 |  | Mat7 |  |  | 10 | 25
 |  |  |  |  |  |  |  |  |  | 2 | 9 |  | Matx
 |  |  |  |  |  |  |  |  |  | 3 | 1 |  | Maty
 |  |  |  |  |  |  |  |  |  | 3 | 5 |  | Matz
 |  |  |  |  |  |  |  |  |  | 3 | 6 |  | Mat6
 |  |  |  |  |  |  |  |  |  | 3 | 7 |  | Mat7
 |  |  |  |  |  |  |  |  |  | 3 | 8 |  | Mat8
 |  |  |  |  |  |  |  |  |  | 3 | 9 |  | Mat9
 |  |  |  |  |  |  |  |  |  | 3 | 10 |  | Mat10
Spreadsheet: 865628d1712671273-adding-firm-year-rows-based-on-start-and-end-year-example
Sheet: Sheet1

DirectorName | ISIN |  | DateStartRole | DateEndRole | Years?
[NAME] | GB00B128C026 |  | 2010-03-01 00:00:00 | 2014-01-14 00:00:00 | 5
Ad Rawcliffe | US00653A1079 |  | 2019-10-01 00:00:00 | 2022-01-01 00:00:00 | 4
[NAME] | GB00B128C026 | GB00B128C026_2010 | 2010-03-01 00:00:00 | 2011-01-14 00:00:00
[NAME] | GB00B128C026 | GB00B128C026_2011 | 2010-03-01 00:00:00 | 2011-01-14 00:00:00
[NAME] | GB00B128C026 | GB00B128C026_2012 | 2010-03-01 00:00:00 | 2011-01-14 00:00:00
[NAME] | GB00B128C026 | GB00B128C026_2013 | 2010-03-01 00:00:00 | 2011-01-14 00:00:00
[NAME] | GB00B128C026 | GB00B128C026_2014 | 2010-03-01 00:00:00 | 2011-01-14 00:00:00
Ad Rawcliffe | US00653A1079 | US00653A1079_2019 | 2019-10-01 00:00:00 | 2023-01-01 00:00:00
Ad Rawcliffe | US00653A1079 | US00653A1079_2020 | 2019-10-01 00:00:00 | 2023-01-01 00:00:00
Ad Rawcliffe | US00653A1079 | US00653A1079_2021 | 2019-10-01 00:00:00 | 2023-01-01 00:00:00
Ad Rawcliffe | US00653A1079 | US00653A1079_2022 | 2019-10-01 00:00:00 | 2023-01-01 00:00:00
Spreadsheet: 134670d1325568725-counting-multiples-lead-breakdown
Sheet: Sheet1

Vertical | Company / Account | Lead Owner | First Name | Last Name | [NAME] | Title | Lead Source | Lead ID
Restaurants - Full Serve / Casual Dining | Darden Restaurants | [NAME] | Stephen | Judge | Unqualified | Chief Executive Officer | Cold Call - Internal | 00QF000000LoBO3 |  | Restaurants - Full Serve / Casual Dining
Restaurants - Full Serve / Casual Dining | McDs | [NAME] | [NAME] | [NAME] | Unqualified | President, Chief Operating Officer, Director | Cold Call - Internal | 00QF000000LoBO4 |  | Open - Not Contacted
Restaurants - Full Serve / Casual Dining | [NAME] | [NAME] | Clarence | [NAME] | Unqualified | Chief Financial Officer | Cold Call - Internal | 00QF000000LoBO5 |  | Unqualified
Restaurants - Full Serve / Casual Dining | [NAME] | [NAME] | Ian | [NAME] | Open - Not Contacted | Director Sustainability | Cold Call - Internal | 00QF000000LoBO6
Restaurants - Full Serve / Casual Dining | Darden Restaurants | [NAME] | [NAME] | Richmond | Open - Not Contacted | Senior Vice President and Chief Financial Officer | Cold Call - Internal | 00QF000000LoBO8
Retail - Grocery | Delhaize America | [NAME] | [NAME] | Anicetti | Open - Not Contacted | Chief Executive Officer of Food Lion, President of Food Lion and Chief Operating | Cold Call - Internal | 00QF000000LoBOA |  | Retail - Grocery
Retail - Grocery | Delhaize America | [NAME] | [NAME] | Byars | Open - Not Contacted | Chief Operating Officer of Kash N Karry | Cold Call - Internal | 00QF000000LoBOB
Retail - Grocery | Delhaize America | [NAME] | [NAME] | Fritzson | Open - Not Contacted | Chief Financial Officer of Hannaford Bros and Executive Vice President of Hannaf | Cold Call - Internal | 00QF000000LoBOC
Spreadsheet: 539fb5e0-8fab-4328-a0dd-a966c885e631
Sheet: Sheet1

Attachment I
County Treasurer's Report to School District Clerk
for preparing the 2012-13 USD Budget
IMPORTANT:  File this information with the school district on or before July 1.
Office of the County Treasurer  __________________________ County, Kansas
To: ___________________________, [NAME] of the Board             USD No. _______
Delinquent Tax Computation
1.  2010 Total Taxes Levied for USD # ____________
2.  2010 Taxes Uncollected
3.  Percent of Delinquency (line 2 divided by line 1)
Estimated Tax Collections (All USD Funds)    July 1, 2012 to June 30, 2013
4.  Est. Motor Vehicle Property Tax       07/01/12 to 06/30/13
5.  Est. 16/20M Truck Tax                     07/01/12 to 06/30/13
6.  Est. Rec. Vehicle Property Tax        07/01/12 to 06/30/13
7.  Est. In Lieu of Taxes on Industrial Revenue Bonds
07/01/12 to 06/30/13
8.  Est. Mineral Production Tax             07/01/12 to 06/30/13
Estimated Assessed Valuation (See K.S.A. 79-5a27) | (file with USD when available)
9.   2012 Estimated Assessed Valuation for General Fund
10.  2012 Estimated Assessed Valuation for All Other Funds
Estimated percent of distribution of year 2012 tax dollars
It is important to under-estimate the January, March and June distribution amounts by 1 or 2 percent
in order to assure cash flow.  The amount under-estimated would be added to the September and
October estimates.
a) January 20, 2013
b)  March 20, 2013
c)  June 5, 2013
d)  September 20, 2013
e)  October 31, 2013
 | Must total 100% | %
I hereby certify that this is a true and correct statement of the Receipts and Disbursements of the above
Unified School District as shown by my records.
County Treasurer  ______________________________________
Signature (Authorized by [NAME] 19-508b)
Spreadsheet: 805877d1668974973-please-help-with-excel-formula-unique-dates-between-2-numbers-book4
Sheet: Sheet1

2022-11-15 00:00:00 | 33
2022-11-15 00:00:00 | 28
2022-11-17 00:00:00 | 45
2022-11-18 00:00:00 | 33
2022-11-19 00:00:00 | 13
2022-11-20 00:00:00 | 4
2022-11-21 00:00:00 | 40
2022-11-22 00:00:00 | 6
2022-11-23 00:00:00 | 7
2022-11-24 00:00:00 | 9
2022-11-25 00:00:00 | 34
2022-11-26 00:00:00 | 45
2022-11-27 00:00:00 | 23
2022-11-28 00:00:00 | 3
2022-11-29 00:00:00 | 33
2022-11-30 00:00:00 | 28
2022-12-01 00:00:00 | 2
2022-12-02 00:00:00 | 4
2022-12-03 00:00:00 | 40
2022-12-04 00:00:00 | 7
2022-12-05 00:00:00 | 28
2022-12-06 00:00:00 | 33
2022-12-07 00:00:00 | 3
2022-12-08 00:00:00 | 4
2022-12-09 00:00:00 | 28
2022-12-10 00:00:00 | 33
Spreadsheet: 678748d1590049026-formula-not-calculating-charts
Sheet: Age off WIP Jan. 2020

 | <= 14 Days | >14 <=89 Days | >= 90 days | Target Line |  | Last day of month
 |  |  |  |  |  | Jan
1 |  |  |  | 200 |  | Feb
2 |  |  |  | 200 |  | Mar
3 |  |  |  | 200 |  | Apr
4 |  |  |  | 200 |  | May
5 | 154 | 307 | 370 | 200 |  | Jun
6 | 119 | 301 | 374 | 200 |  | Jul
7 | 82 | 298 | 359 | 200 |  | Aug
8 | 98 | 288 | 369 | 200 |  | Sept
9 | 113 | 288 | 369 | 200 |  | Oct
10 | 112 | 286 | 365 | 200 |  | Nov
11 | 137 | 272 | 377 | 200 |  | Dec
12 | 108 | 267 | 382 | 200 |  | Jan
13 | 132 | 267 | 381 | 200 |  | Feb
14 | 139 | 268 | 386 | 200 |  | Mar
15 | 110 | 263 | 380 | 200 |  | Apr
16 | 87 | 252 | 396 | 200 |  | May
17 | 91 | 247 | 401 | 200 |  | Jun
18 | 119 | 234 | 415 | 200 |  | Jul
19 | 119 | 247 | 415 | 200 |  | Aug
20 | 103 | 245 | 415 | 200 |  | Sep
21 | 136 | 245 | 410 | 200 |  | Oct
22 | 133 | 248 | 400 | 200 |  | Nov
23 | 132 | 280 | 398 | 200 |  | Dec
24 | 214 | 260 | 392 | 200 |  | Jan
25 | 196 | 245 | 407 | 200 |  | Feb
26 | 252 | 236 | 404 | 200 |  | Mar
27 | 212 | 239 | 405 | 200 |  | Apr
28 | 240 | 220 | 417 | 200 |  | May
29 | 263 | 220 | 417 | 200 |  | June
30 | 221 | 204 | 417 | 200 |  | July
31 | 184 | 180 | 426 | 200
Total
Spreadsheet: df4c0ba1-f25d-4870-9b87-2e35073bfbbc
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
FSRP | Test | FSRP | SRP | SRP | Immunoprecipitation (IPP) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Submit only 1 of the following  Serum Draw blood in a plain, red-top tube(s). Spin down and send 1 mL of serum refrigerate in plastic vial. Note: 1. Indicate serum on request form.             2. Label specimen appropriately (serum).  [NAME] blood in a lavender-top (EDTA) tube(s). Spin down and send 1 mL of EDTA plasma refrigerate in plastic vial. Note: 1. Indicate plasma on request form.             2. Label specimen appropriately (plasma). | 1 mL | Specimens Other Than:	Serum, plasma Anticoagulants Other Than:	EDTA Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icteric:	NA | Negative   Signal Recognition Particle (SRP) is a myositis specific autoantibody which is seen in 5-10% of adult and juvenile myositis. Symptoms often are acute onset of severe polymyositis with frequent myalgias, severe weakness and very high creatine kinase levels. Some adults experience cardiac involvement and palpitations. There is a poor response to therapy.   Test Performed by: RDL Reference Laboratory, Inc.                              10755 Venice Boulevard                              Los Angeles, CA 90034 | Monday through Friday | 14 days | 16 - 18 days | 1 | 83516 |  |  |  |  | RDL Reference Laboratory, Inc.
FSRP | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FSRP | Result | Z2422 | SRP | SRP | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33921-8
Spreadsheet: 867045d1713955008-how-can-i-add-value-based-on-two-different-variables-example-67-ans
Sheet: Sheet5

Sum of Count of Rating |  |  |  |  | Score | 1 through 6 | 7, 8 | 9, 10 |  | This should be my results
Region | Rating | Total |  |  | NA |  |  | 81
ANZ | 1 | 18 |  |  | EU |  |  | 235
 | 2 | 1 |  |  | ANZ |  |  | 8
 | 4 | 2
 | 6 | 1
 | 9 | 1
 | 10 | 7 |  |  | Work table
ANZ Total |  | 30 |  |  |  |  |  |  |  | What is the right formula?
EU | 1 | 7 |  |  | Score | 1 through 6 | 7, 8 | 9, 10
 | 2 | 12 |  |  | NA
 | 3 | 23 |  |  | EU
 | 4 | 4 |  |  | ANZ
 | 5 | 13
 | 6 | 9
 | 7 | 12
 | 8 | 45
 | 9 | 77
 | 10 | 158
EU Total |  | 360
NA | 1 | 11
 | 2 | 17
 | 3 | 175
 | 4 | 7
 | 5 | 12
 | 6 | 3
 | 7 | 11
 | 8 | 12
 | 9 | 22
 | 10 | 59
NA Total |  | 329
Grand Total |  | 719
Spreadsheet: 801528d1666247420-googlesheets-calendar-that-updates-automatically-when-you-click-either-sunday-or-monday-sample-workbook-calendar-aligw
Sheet: Sheet1

 | MONTHLY CALENDAR |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 1
 |  |  |  |  |  |  |  |  |  | 1 | 2
 | MONTH | OCTOBER
 | YEAR | 2022
 | START DAY | MONDAY
 | BILLS & FIXED EXPENSES
 | [NAME] | DUE DATE | PAID
 | Amazon Prime subscription | 2022-08-11 00:00:00 |  |  |  | 4 | 5 | 6 | 7 | 8 | 9
 | Internet bill | 2022-08-12 00:00:00
 | Amazon Prime US subscription | 2022-08-13 00:00:00
 | Uber Pass | 2022-08-13 00:00:00
 | Funimation subscription | 2022-08-14 00:00:00
 |  |  |  |  |  | 11 | 12 | 13 | 14 | 15 | 16
 | SPECIAL EVENTS |  |  |  |  | 18 | 19 | 20 | 21 | 22 | 23
 | EVENT | EVENT DATE
 |  |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30
Spreadsheet: 133173d1324243759-filter-and-calculating-results-example
Sheet: Sheet1

Site | Date |  |  |  |  |  |  |  | Category
www.site.com.au | Tue Feb 15 14:37:29 2005 |  |  |  |  |  |  |  | current student
www.science.com.au | Tue Feb 15 14:37:29 2006 |  |  |  |  |  |  |  | current student
www.site.com.au | Tue Feb 15 14:37:29 2007 |  |  |  |  |  |  |  | current student
www.site.com.au/assets/banner/image1.jpg | Tue Feb 15 14:37:29 2008 |  |  |  |  |  |  |  | Assets
www.site.com.au/assets/banner/image1.jpg | Tue Feb 15 14:37:29 2009 |  |  |  |  |  |  |  | Assets
www.science.com.au/research | Tue Feb 15 14:37:29 2010 |  |  |  |  |  |  |  | Research
www.site.com.au/promo | Tue Feb 15 14:37:29 2011 |  |  |  |  |  |  |  | Promo
I want to know how many are in each category
Also, what percentage is any particular category overall of the entire spreadsheet
Example
Assets | 0.6
Total Numner | 3000
Current Students | 0.15
Total Number | 1000
Research | 0.15
Total Number | 1000
Promo | 0.1
Total Number | 500
Spreadsheet: 690612d1597198302-need-help-programming-check-registger
Sheet: Help

HELP
https://www.vertex42.com/ExcelTemplates/excel-checkbook.html |  | © 2008-2020 Vertex42 LLC
[NAME]
 | 1. Clear the sample data in the table, but do not clear the Balance column.
 | 2. Enter the name of your account at the top of the worksheet (e.g. "Ted's Checking")
 | 3. Enter your starting balance as a Deposit in the first row of the register.
 | When adding, deleting, inserting, copying, or pasting transactions in the Register, you will have fewer errors or problems if you delete/insert/copy/paste the entire row. This is done by first right-clicking on the Row number.
 | Note: The Balance formula will not work if you leave a blank row between transactions.
Customize the List of Categories
 | Edit the Category list in the Settings worksheet if you want to customize the categories that appear in the drop-down box within the Register table.
 | The current list of categories comes from the Vertex42 Money Management Template (see the link in the references section below).
Deleting a Transaction
 | To delete a transaction, right-click on the Row number and select "Delete Row". If you select the Row number and press the Delete key, it will only clear the contents of the row, instead of removing the entire row.
Example Entries in the NUM Field
 | 2032    (check number)
 | EFT     (electronic funds transfer)
 | DEP    (deposit)
 | TXFR  (transfer to/from other account)
 | CARD (debit/check card)
 | FEE    (bank fees)
 | You can change the options that appear in the drop-down list for the [NAME] column by editing the list in the L column of the Register worksheet (this allows you to have a custom list for each copy of the worksheet). You will need to unhide the hidden rows to see the entire list.
Daily Reconciliation, "C" is for "Cleared"
 | When you see that charges have been processed or "cleared" by your bank, enter a "c" in the Reconcile (R) column for that transaction.
[42]
Balancing Your Check Book, "R" is for "Reconcile"
 | When balancing your check book, add an "R" or "r" in the Reconcile (R) column to indicate that the transaction is correct and reconciled with your bank statement.
Cleared Balance
 | This is the balance that includes all transactions marked "R", "r", "C", or "c". This is the amount that you can use to compare to your bank statement.
Current Balance
 | This is the amount that you will want to monitor closely from day to day.
Additional Help
 | The link at the top of this worksheet will take you to the web page on vertex42.com that talks about this template.
Related Templates and Resources
Spreadsheet: kimberly_watson__20634__tw_priority_rate
Sheet: 9901-9903

Transwestern Pipeline Company
Contracts Under the Global Settlement
Priority Rates (Reservation and Demand Surcharges)
Contract | Shipper | Receipt to Delivery | Reservation | Shared Cost | TCR II No. 1 | TCR II No. 2 | GRI Demand | Total |  | Commodity
Number | Name | Area | Rate | Surcharge | Surcharge | Surcharge | Surcharge | Rate |  | Rate
8255 | Southern California Gas Company | East of Thoreau to California (W. of Thoreau) | 0.3105 |  | 0.0052 | 0.0007 | 0.0076 |  |  | 0.0228
20834 | Citizens Utilities Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.101 | - | - | - | -
20835 | Conoco Inc. | San Juan Lateral to Thoreau/San Juan Pt. | 0.101 | - | - | - | -
21175 | Pacific Gas & Electric Company(Gas) | San Juan Lateral to Thoreau/San Juan Pt. | 0.101 | - | - | - | -
21172 | Pacific Gas & Electric Company(UEG) | San Juan Lateral to Thoreau/San Juan Pt. | 0.101 | - | - | - | -
26371 | Duke Energy Trading and Marketing. LLC | San Juan Lateral to Thoreau/San Juan Pt. | 0.101 | - | - | - | -
25923 | Texaco Natural Gas Inc. | San Juan Lateral to Thoreau/San Juan Pt. | 0.101 | - | - | - | -
20715 | Southern California Gas Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.101 | - | - | - | -
20747 | Conoco Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2503 | 0.0369 | 0.006 | 0.0008 | 0.0076 |  |  | 0.0156
20748 | Conoco Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2503 | 0.0369 | 0.006 | 0.0008 | 0.0047 |  |  | 0.0156
21165 | Pacific Gas & Electric Company(Gas) | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2503 | 0.0443 | 0.0046 | 0.0006 | 0.0076 |  |  | 0.0156
21162 | Pacific Gas & Electric Company(UEG) | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2503 | 0.0443 | 0.0051 | 0.0007 | 0.0076 |  |  | 0.0156
26372 | Duke Energy Trading and Marketing. LLC | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2503 | 0.0443 | 0.0051 | 0.0007 | 0.0076 |  |  | 0.0156
25924 | Texaco Natural Gas Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2503 | 0.0443 | 0.0055 | 0.0007 | - |  |  | 0.0156
20822 | Citizens Utilities Company | Thoreau/San Juan Pt. to East of California (W. of Thoreau) | 0.1614 | 0.0369 | 0.0031 | 0.0004 | 0.0047 |  |  | 0.0156
NOTE --- | Per CBS Negotiated Rate System, the termination date for the rates listed above are as follows:
 | Reservation | 1999-10-31 00:00:00
 | SCS | 2001-10-31 00:00:00
 | TCR II No. 1 | 2005-10-31 00:00:00
 | TCR II No. 1 | 2006-10-31 00:00:00
 | GRI Demand | N/A **
 | ** Calculation made every year to determine which contracts are High Load vs. Low Load
Spreadsheet: 24445d1214839666-searching-for-intermediate-value-648427a
Sheet: Sheet1

x | y |  | New Y | Calc'd New X
147 | 46.8 |  | 50 | 149.5 |  | Nearest Y | 49.6 |  |  | 49.6 |  | 152 | 52.6
148 | 48.2 |  | 50 | 149.5 |  | Position in Table | 3 |  |  | 4 |  | 151 | 51.2
149 | 49.6 |  |  |  |  | X value before/after new Y | 149 | 150 |  | 149 | 150 | 150 | 50.4
150 | 50.4 |  |  |  |  | Y value before/after new Y | 49.6 | 50.4 |  | 49.6 | 50.4 | 149 | 49.6
151 | 51.2 |  |  |  |  | X Gap | 1 |  |  | 1 |  | 148 | 48.2
152 | 52.6 |  |  |  |  | Y Gap | 0.7999999999999972 |  |  | 0.7999999999999972 |  | 147 | 46.8
 |  |  |  |  |  | Amount of gap from New value | 0.3999999999999986 |  |  | 0.3999999999999986
 |  |  |  |  |  | Proportion of gap | 0.5 |  |  | 0.5