tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1071__Consolidated 2000 Peaker 8-15-00
Sheet: Assumptions

ASSUMPTIONS
TECHNICAL ASSUMPTIONS: |  | 2000 PROJECTS
 |  | [NAME] | Wheatland | [NAME] |  | Total
Number of Turbines |  | 3 | 4 | 8
Summer Capacity (MW) |  | 510 | 470 | 608
[NAME] (HHV, Btu/kWh) |  | 10592 | 11734 | 11973
Numbers of Starts |  | 75 | 75 | 75
PRICING ASSUMPTIONS:
Fixed Price Demand Charge ($/kW-month) |  | 4
Energy Charge ($/MWh)
Start Charge ($/Start/Turbine)
Annual Generation (MWh) |  | 532991.6197855896 | 461312.7218562186 | 2002000
OPERATING COSTS ASSUMPTIONS:
Variable O&M ($/MWh) |  | 1.5 | 3 | 2
Major [NAME] ($/Start/Turbine) |  | 1500 | 1500 | 1000
Annual Escalator |  | 0.03
Annual Cost (000$ in Year 2000)
Fixed O&M |  | 1242.481714285714 | 1515.790285714286 | 1448.540571428571
Variable O&M
Major [NAME]
Owner's Expense |  | 322.2511428571429 | 306.2677142857142 | 400.6471428571429
Property Tax Liability
TAX ASSUMPTIONS:
Federal Income Tax Rate |  | 0.35 | 0.35 | 0.35 |  | 0.35
State Income Tax Rate |  | 0.06 | 0.045 | 0.0718
Adjusted Gross Income Tax |  | N/A | 0.034 | N/A
Gross Receipts Tax Rate |  | N/A | 0.012 | N/A
Franchise Tax Rate (Year 1) |  | 0.0025 | N/A | 0.0015
Franchise Tax Rate (Year 2-20) |  | 0.0025 | N/A | 0.001
Spreadsheet: 122507d1316885465-drop-down-value-to-change-sum-of-another-box-interest-english
Sheet: Sheet1

 |  | Loans
 | Loan | Interest type | Loan type/years | Interest free | Amount | Interest | Interest per month | Payments
 | House | Moving | Annuitet/10y | Yes | 1450000 | 0.044 |  | 5000
 | Car | Moving | Annuitet/5y | Yes | 275000 | 0.066 |  | 4000
 | Ekspres Bank | Moving | Annuitet/10y | Yes | 265000 | 0.1241 |  | 800
 |  |  |  |  |  |  | Total amount each month only Interest
 |  |  |  |  |  |  | Total amount each month including payments
Yes
No
Spreadsheet: 863577d1711014596-scoring-system-sum-score-test-data
Sheet: Sheet1

Name | What is the location of the store ? |  |  |  |  |  |  | 10 | 20 | 30 | 40
Handy Stores | Parade of Shops | 30 |  |  |  |  | 1. Location of store? | Stand Alone | Forecourt | Parade | High Street
Londis, [NAME] | Stand Alone | 10 |  |  |  |  | last character ASCII code
Kettering road [NAME] | High Street | 40
Go local extra | Stand Alone | 10
Y-Farchnad-Fach Capel Hendre | Stand Alone | 10
Go local Sherlock avenue | Parade of Shops | 30
Exhall Service Station | Forecourt | 20 |  |  |  |  |  |  |  | used to be
 |  |  |  |  |  |  |  |  |  | Parade
 |  |  |  |  |  |  | last character ASCII code
Spreadsheet: sara_shackleton__37318__Contour Energy
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: | 2000-04-24 00:00:00 | DEAL MAKER:
COUNTERPARTY: | Contour Energy Company | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING)
LIMIT $ MILLIONS
Incorporation State
ELEGIBLE SWAP PARTICIPANT
Counterparty
Guarantor
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit |  | X
Cash |  | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ |  | 1
COLLATERAL ROUNDING
Delivery Amount |  | 250000
Return Amount |  | 250000
HOLDING and USE OF COLLATERAL
Permitted |  | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor |  | X
Debt Ratings Change |  | X
-Below = S&P/Moody's |  | BBB-
Financial Covenants
-Funded Debt to Worth
-Minimum Net Worth
-EBITDA/Interest Expense
-Funded Debt / EBITDA
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt |  | X
-Counterparty ($[NAME])
-Guarantor ($[NAME]) |  | 100
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:  This customer has an existing Master Agreement with ENA.  But, the customer has MAC'd and
their threshold has been reduced to $0.  We currently LC secure all deal activity.
Last week we approved a trade that was quite large and long (15,000/d for 2001) under the understanding that existing support
of $3.95MM, due to expire October 15, would be amended to expire January 15, 2002.  They agreed.
CREDIT REVIEW  PREPARED BY: |  | B. Reves | 3-9897
Spreadsheet: 191925d1352247881-graph-or-chart-to-be-updated-automatically-with-new-data-graph-to-be-updated-daily
Sheet: Retail

STOCK POSITION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TGT VS RETAIL
 |  |  |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  | M&HCV TRUCK
Model | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  |  | 1 | 2 | 3 | 4 | 5
M&HCV TRUCK | 348 | 437 | 437 | 437 | 437 |  |  |  |  |  |  |  |  |  |  |  | Target | 5.666666666666667 | 11.33333333333333 | 17 | 22.66666666666667 | 28.33333333333334
BUS (MCV & LCV) | 274 | 272 | 272 | 272 | 272 |  |  |  |  |  |  |  |  |  |  |  | Achievement | 3 | 9 | 14 | 18 | 22
ICV TRUCK | 233 | 264 | 264 | 264 | 264
LCV TRUCK | 298 | 330 | 330 | 330 | 330
PICKUP | 129 | 129 | 129 | 129 | 134
[NAME] | 83 | 83 | 83 | 83 | 84
ACE Super | 8 | 8 | 8 | 8 | 8
ACE HT PICKUP Diesel | 325 | 325 | 325 | 325 | 333
ACE PICKUP -Ex | 830 | 830 | 830 | 830 | 821
ACE MAGIC | 85 | 85 | 85 | 85 | 75
Spreadsheet: 861776d1709622212-countifs-and-averageifs-formula
Sheet: Sheet1

Date | Signal 1 | Signal 2 | Gains
2024-01-01 00:00:00 | Buy | Buy | 0.01
2024-01-02 00:00:00 | Buy | Buy | 0.02
2024-01-03 00:00:00 | Sell | Sell | 0.03
2024-01-04 00:00:00 | Buy | Sell | 0.04
2024-01-05 00:00:00 | Buy | Buy | 0.05
2024-01-06 00:00:00 | Buy | Buy | -0.01
2024-01-07 00:00:00 | Sell | Sell | -0.02
2024-01-08 00:00:00 | Sell | Sell | -0.03
2024-01-09 00:00:00 | Buy | Buy | 0.04
2024-01-10 00:00:00 | Sell | Sell | 0.05
Requested formulas |  |  |  |  |  |  |  | Expected results:
1. Count all rows that Signal 1 = signal 2 and positive gains |  |  |  |  |  |  |  | 6
2. same as 1. but with average gains |  |  |  |  |  |  |  | 0.033
if possible, please use countifs and [NAME]
Spreadsheet: phillip_m_love__30118__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 4/24/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Dominion Field Services | V53134.1 | F | NG | [NAME]
Enbridge Inc. | V53624.1 | P | NG | [NAME]
Enline Energy Solutions, LLC | V53506.1 | P | NG | [NAME]
Indeck Pepperell Power Association | V53956.1 | P | NG | [NAME]
[NAME] District | V53464.1 | P | NG | [NAME]
KN Gas Services | V54341.1 | P | NG | [NAME]
Mitsui & Co. (USA) Inc. | V54159.1/2/3/4/5/6/7 | P/F | SHRC | [NAME]
NDR Energy Group, LLC | V53785.1 | P | NG | [NAME]
Petrous, LLC | V54167.1 | F | C3GC | Brant Reves
Prima Energy Corporation | V54356.1 | F | NG | [NAME]
Retex Inc. | V54326.1 | P | NG | [NAME]
Total International Limited | V54293.1 | F | C3GC | Brant Reves
Tropicana Products Inc. | V53934.1 | P | NG | [NAME]
Westlake Petrochemical Corporation | V54027.1/2 | F | NG | [NAME]
Union Gas Limited | QH8108.5/6/7 QJ0983.5/6/7 | P | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
AEP Energy Services Ltd. | V52737.1 | P | NG | AEP Energy Services, Inc.
Allegheny Ludlum Corporation | V53007.1 | F | NG | Allegheny Energy Supply Company
Banque Paribas (Suisse) S.A. | V54337.1/2 | F | NG | BNP Paribas
Cinergy Capital & Trading Inc. | V54053.1 | F | NG | Cinergy Marketing & Trading, LLC
Constellation Energy Source, Inc. | V53455.1/2 | F | NG | Constellation Power Source, Inc.
Kinder Morgan Energy Partners | V54350.1 | F | NG | Kinder Morgan Inc.
MidAmerican Capital Company | V53591.1 | F | NG | MidAmerican Energy Company
NRG Incorporated | V53972.1 | F | NG | NRG Power Marketing Inc.
Paribas | V53304.1 | F | NG | BNP Paribas
Sempra Energy Trading (Canada) | V53035.1 V53036.1 | F | NG | Sempra Energy Trading Corp.
TransCanada Energy Financial Products | V53683.1 | F | NG | TransCanada Energy Financial Products (w/ECC)
Spreadsheet: 274997d1383306291-compiling-a-string-of-numbers-from-individual-cells-ghozi-01112013compiling-a-string-of-numbers-from-individual-cells
Sheet: Sheet2

PJ02-0056-0045-001
PJ03-0057-0046-0002
PJ04-0058-0047
PJ06-0059-0048-0004
PJ02-0060-0049
PJ02-0061-0050-0006
PJ05-0071-0060
PJ02-0072-0061-0017
PJ08-0073
Spreadsheet: 823409d1679948319-iterating-through-a-column-and-counting-criteria-that-is-met-if-that-row-meets-a-condition-test-2-
Sheet: Sheet1

 |  |  |  | Month | Apples | Bananas | Pears | Grapes
 |  |  | [NAME] | February | Bag | Box | Box | Cart |  |  |  |  |  |  |  | January | Bag
 |  |  | [NAME] |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | February | Cart
 |  |  | [NAME] | January | Cart | Cart | Tray | Box |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | March | Box
 |  |  | [NAME] | January | Bag | Box | Bag | Bag |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | April | Tray
 |  |  | [NAME] |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | May
 |  |  | [NAME] | May | Tray | Bag | Cart | Box
 |  |  | Month | January | February | March | April | May
 |  |  | Bag | 3 | 1 | 0 | 0 | 1
 |  |  | Cart | 2 | 1 | 0 | 0 | 1
 |  |  | Box | 2 | 2 | 0 | 0 | 1
 |  |  | Tray | 1 | 0 | 0 | 0 | 1
 |  |  |  | Equations to be put in F26:F29
 |  |  |  |  | 1 | 0 | 0 | 1
 |  |  |  | 2 | 1 | 0 | 0 | 1
 |  |  |  | 2 | 2 | 0 | 0 | 1
 |  |  |  | 1 | 0 | 0 | 0 | 1
Spreadsheet: b4ff1080-c36a-493a-9caa-d35f0527af7f
Sheet: Sheet1

Backup mode characteristic | Why it is important | Reversed Incremental | Incremental | Incremental w/transform
Synthetic full backups | Increases speed, reduces load on production environment | Yes | Yes | Yes
Periodic active fulls | Allows to avoid long synthetic chains (for ex. monthly active fulls) | Yes | Yes | Yes
VM level retention | Deleted VM data blocks are removed from VBK according to retention | Yes | Yes | Yes
Synthetic full backup speed | Determines backup window on weekend | No periodic fulls (Fastest) | Normal | Slower
Incremental backup speed | Determines backup window on business days | Slower (full backup file rebuild) | Fastest | Fastest
Consistent backup window | Important for near-CDP protection | Yes (always the same) | No (longer on full backup day) | No (even longer on full backup day)
Last backup is always full | Enables scenarios such as taking full backup offsite each day | Yes | No | No
Restore while backup is running | Enables to restore from earlier backup while backup job is running | No | Yes | Yes, except full backup day
Tape backup compatibility | Enables to drop produced backup files to tape everyday | Limited (full backup file to copy) | Yes | Yes
Existing backup never modified | Important for some offsite backup synchronization scenarios | No | Yes | No
HW deduplicating storage friendly | Fast backup to hardware deduplicating storage | No | Yes | Yes, except full backup day
Number of full backups to keep | Primarily defines backup storage requirements | 1 full backup | Multiple full backups (*) | 1 full backup
VBK space reclamation (**) | Prevents VBK from growing with time | Blocks reused by new data | VBK shrinks each synthetic full | Blocks reused by new data
(*) not an issue when backing up to dedupe device
(**) what happens with VBK blocks belonging to VMs which were removed from backup job?
Spreadsheet: 841973d1694086563-need-help-with-a-data-table-book1
Sheet:  Targets 

 |  |  |  |  |  | 38.5 |  | 38.5
 |  |  |  |  |  | 1.58 |  | 1.58
 | 0.75 | 0.76 | 0.77 | 0.78 | 0.79 | 0.8 | 0.81 | 0.82 | 0.83 | 0.84 | 0.85
1.4
1.5
1.55
1.6
1.65
1.7
1.75
1.8
1.85
1.9
1.95
2.1
2.2
2.3
2.4
2.5
2.6
Spreadsheet: 68568d1269113249-excel-2007-combining-worksheets-unequal-numbers-of-names-positions-1-
Sheet: combined

Name | pos | (CA) | (1B) | (2B) | (3B) | (SS) | (OF) | UT | RC | PA
Spreadsheet: 2fd1904a-bbdc-46bc-aa21-99230e6a836b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-02-06 10:09:23.740000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.25 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.125 | 101.694 | 101.569 | 101.444 | 101.069
4 | 101.372 | 101.247 | 101.122 | 100.747 |  | Note: | Refer To Price [NAME]
3.875 | 100.55 | 100.425 | 100.3 | 99.925 |  |  | For all Price Adjs
3.75 | 99.572 | 99.447 | 99.322 | 98.697
3.625 | 99.119 | 98.994 | 98.869 | 98.244
3.5 | 98.614 | 98.489 | 98.364 | 97.739
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.625 | 101.933 | 101.808 | 101.683 | 101.308
3.5 | 101.593 | 101.468 | 101.343 | 100.968
3.375 | 101.062 | 100.937 | 100.812 | 100.437
3.25 | 100.431 | 100.306 | 100.181 | 99.806
3.125 | 99.665 | 99.54 | 99.415 | 98.79
3 | 99.322 | 99.197 | 99.072 | 98.447
2.875 | 98.763 | 98.638 | 98.513 | 97.888 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-02-20 10:09:23.740000
30 DAY | 2012-03-06 10:09:23.740000
45 DAY | 2012-03-21 10:09:23.740000
60 DAY | 2012-04-05 10:09:23.740000
90 DAY | 2012-05-05 10:09:23.740000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 867179d1714051858-calculating-a-percentage-based-on-rows-above-and-below-test1-22-aligw
Sheet: Sheet1

This row is calculated with =[NAME]) | Full number (can have letters) |  |  |  |  |  |  |  | 8 rows up and below | 20 rows up and below |  |  |  |  |  |  |  |  |  |  |  |  | Grade | Value
2853 | 102853 | B0 | 0 | 0 | B0 | 2 Years, 6m |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B0 | 0
2854 | 202854 | B0 | 0 | 0 | B2 | 2 Years, 6m |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1 | 0.15
2855 | 302855 | B0 | 0 | 0 | B2 | 2 Years, 6m |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2 | 0.15
2856 | 402856 | B2 | 1 | 4 | B0 | 2 Years, 5m |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B3 | 0.4
2858 | 602858 | B0 | 0 | 0 | B1 | 2 Years, 5m |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B4 | 0.9
2862 | 302862 | B0 | 0 | 0 | B4 | 2 Years, 5m |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B5 | 1.5
2865 | 602865 | B0 | 0 | 0 |  | 0 |  | 0
2866 | 702866 | B0 | 0 | 0 | B3 | 2 Years, 5m |  | 0
2871 | 502871 | B0 | 0 | 0 |  | 0 |  | 0
2874 | 102874 | B0 | 0 | 0 | B3 | 2 Years, 4m |  | 0
2876 | 302876 | B0 | 0 | 0 |  | 0 |  | 0
2877 | 402877 | B0 | 0 | 0 | B4 | 2 Years, 4m |  | 0
2879 | 602879 | B5 | 1 | 10 |  | 0 |  | R |  | 3 out of 30 (12 up, 18 bellow) 10%
2880 | 702880 | B0 | 0 | 0 | B4 | 2 Years, 4m |  | 0
2883 | 302883 | B0 | 0 | 0 | B0 | 2 Years, 3m |  | 0
2884 | 402884 | B0 | 0 | 0 |  | 0 |  | 0
2885 | 502885 | B0 | 0 | 0 |  | 0 |  | 0
2886 | 602886 | B0 | 0 | 0 |  | 0 |  | 0
2889 | 202889 | B0 | 0 | 0 | B5 | 2 Years, 3m |  | 0
2892 | 502892 | B5 | 1 | 9 |  | 0 |  | R |  | 3 out of 30 (11 up, 19 bellow) 10%
2893 | 602893 | B0 | 0 | 0 | B4 | 2 Years, 3m |  | 0
2895 | 102895 | B0 | 0 | 0 |  | 0 |  | 0
2896 | 202896 | B0 | 0 | 0 |  | 0 |  | 0
2897 | 302897 | B0 | 0 | 0 | B3 | 2 Years, 3m |  | 0
2898 | 402898 | B0 | 0 | 0 |  | 0 |  | 0
2902 | 102902 | B0 | 0 | 0 |  | 0 |  | 0
2903 | 202903 | B0 | 0 | 0 | B0 | 2 Years, 2m |  | 0
2904 | 302904 | B3 | 1 | 5 | B4 | 2 Years, 2m |  | 0
2907 | 602907 | B0 | 0 | 0 | B0 | 2 Years, 2m |  | 0
2908 | 702908 | B0 | 0 | 0 | B4 | 2 Years, 2m |  | 0
2911 | 302911 | B0 | 0 | 0 | B2 | 2 Years, 2m |  | 0
Spreadsheet: 4141c2e0-eb31-43fa-afa6-7b138aad4977
Sheet: Sheet1

PRESIDENTIAL PRIMARY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
1996-02-20 00:00:00
[NAME]
 | Republican |  |  |  | Democratic |  |  |  | Libertarian
Belknap County | Regular | Absentee | Total |  | Regular | Absentee | Total |  | Regular | Absentee | Total
Alton | 932 | 127 | 1059 |  | 193 | 16 | 209 |  | 7 | 1 | 8
Barnstead | 705 | 31 | 736 |  | 238 | 17 | 255 |  | 4 | 0 | 4
Belmont | 913 | 40 | 953 |  | 338 | 12 | 350 |  | 15 | 0 | 15
Center Harbor | 239 | 26 | 265 |  | 68 | 2 | 70 |  | 0 | 0 | 0
Gilford | 1543 | 94 | 1637 |  | 391 | 18 | 409 |  | 2 | 0 | 2
Gilmanton | 608 | 35 | 643 |  | 211 | 8 | 219 |  | 8 | 0 | 8
[NAME] | 607 | 41 | 648 |  | 138 | 13 | 151 |  | 4 | 0 | 4
[NAME] | 445 | 53 | 498 |  | 199 | 26 | 225 |  | 3 | 0 | 3
[NAME] 3 | 471 | 43 | 514 |  | 201 | 8 | 209 |  | 1 | 0 | 1
[NAME] | 362 | 21 | 383 |  | 185 | 16 | 201 |  | 1 | 0 | 1
[NAME] | 312 | 19 | 331 |  | 219 | 23 | 242 |  | 2 | 0 | 2
[NAME] 6 | 499 | 25 | 524 |  | 169 | 7 | 176 |  | 3 | 0 | 3
Meredith | 1307 | 91 | 1398 |  | 359 | 12 | 371 |  | 5 | 0 | 5
New Hampton | 369 | 16 | 385 |  | 138 | 3 | 141 |  | 2 | 0 | 2
Sanbornton | 500 | 31 | 531 |  | 204 | 13 | 217 |  | 5 | 0 | 5
[NAME] | 548 | 41 | 589 |  | 212 | 15 | 227 |  | 2 | 1 | 3
Totals | 10360 | 734 | 11094 |  | 3463 | 209 | 3672 |  | 64 | 2 | 66
 | Republican |  |  |  | Democratic |  |  |  | Libertarian
Carroll County | Regular | Absentee | Total |  | Regular | Absentee | Total |  | Regular | Absentee | Total
Albany | 102 | 17 | 119 |  | 27 | 1 | 28 |  | 1 | 0 | 1
[NAME] | 613 | 46 | 659 |  | 125 | 5 | 130 |  | 3 | 0 | 3
[NAME] | 156 | 15 | 171 |  | 33 | 7 | 40 |  | 6 | 0 | 6
Chatham | 47 | 3 | 50 |  | 10 | - | 10 |  | 0 | 0 | 0
Conway | 1317 | 126 | 1443 |  | 365 | 22 | 387 |  | 7 | 0 | 7
Eaton | 77 | 6 | 83 |  | 27 | 2 | 29 |  | 3 | 0 | 3
[NAME] | 190 | 14 | 204 |  | 56 | - | 56 |  | 0 | 0 | 0
Freedom | 273 | 27 | 300 |  | 76 | 11 | 87 |  | 0 | 0 | 0
Hale's Location | 4 | - | 4 |  | - | - | - |  | 0 | 0 | 0
Hart's Location | 12 | 6 | 18 |  | 7 | 2 | 9 |  | 0 | 0 | 0
[NAME] | 271 | 30 | 301 |  | 59 | 4 | 63 |  | 0 | 0 | 0
[NAME] | 349 | 36 | 385 |  | 100 | 5 | 105 |  | 3 | 0 | 3
Moultonborough | 1030 | 150 | 1180 |  | 178 | 13 | 191 |  | 6 | 0 | 6
Ossipee | 659 | 37 | 696 |  | 154 | 2 | 156 |  | 9 | 0 | 9
Sandwich | 355 | 40 | 395 |  | 171 | 11 | 182 |  | 2 | 0 | 2
Tamworth | 435 | 35 | 470 |  | 189 | 13 | 202 |  | 7 | 0 | 7
Tuftonboro | 618 | 71 | 689 |  | 81 | 3 | 84 |  | 8 | 0 | 8
Wakefield | 679 | 73 | 752 |  | 166 | 17 | 183 |  | 10 | 0 | 10
Wolfeboro | 1489 | 218 | 1707 |  | 253 | 24 | 277 |  | 4 | 0 | 4
Totals | 8676 | 950 | 9626 |  | 2077 | 142 | 2219 |  | 69 | 0 | 69
Spreadsheet: 768642d1645058207-stacking-multiple-ranges-to-one-combined-range-pq-append-week
Sheet: Sunday

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
Run | Run | Start_Time | End_Time | Day of Week | Route | Block | EE ID
FT_1 | 309 | 0.3125 | 0.6458333333333334 | Sunday | 309 | 309 | 1050295
FT_2 | 310 | 0.3125 | 0.6458333333333334 | Sunday | 310 | 310 | 1050311
[NAME] | 800 | 0.15625 | 0.4895833333333333 | Sunday | 800 | 800 | 1050800
FT_34 | 801 | 0.1875 | 0.5208333333333334 | Sunday | 801 | 801 | 1050308
FT_35 | 802 | 0.2291666666666666 | 0.5625 | Sunday | 802 | 802 | 1050292
FT_36 | 805 | 0.2708333333333333 | 0.6041666666666666 | Sunday | 805 | 805 | 1050288
[NAME] | 806 | 0.2708333333333333 | 0.6041666666666666 | Sunday | 806 | 806 | 1050290
FT_38 | 807 | 0.2708333333333333 | 0.6041666666666666 | Sunday | 807 | 807 | 1050285
FT_39 | 810 | 0.2708333333333333 | 0.6041666666666666 | Sunday | 810 | 810 | 1050331
Spreadsheet: 68490d1269015862-formula-help-for-newbie-example-included-everything-lookup
Sheet: SKU Lookup

SKU # |  | S/O # | SERIAL # | MODEL # | GRADE | BATCH # | [NAME] | [NAME] |  | Total # of S/O #'s:
 |  |  |  |  |  |  |  |  |  | # of D-Units:
Spreadsheet: 866784d1713709297-excel-circular-reference-wagestruc-copy
Sheet: Salary Rate

Salary Structure:  [NAME]
Month/Year:  Apr/2024
SLNO | EMP ID. | Name | DA | HRA | CONVEYANCE | LUNCH | OTHERS | UNIFORM | BASIC. | RES CH PAY | Remarks | [NAME]
1 | AV00001 | Muruganandam D |  |  |  | 0 | 0 | 0 |  |  | 35000
2 | AV00002 | [NAME] P |  |  |  | 0 | 0 | 0 |  |  | 35000
3 | AV00003 | Shivananjappa |  |  |  | 0 | 0 | 0 |  |  | 28000
Spreadsheet: 685659d1594132853-counting-conditionally-formatted-cells-which-are-blank-config
Sheet: UMMS BC Labour Input

Task | Original | EDIT | Job Family | System | Inspect | Check | Clean | Survey | Tag out | Remove | [NAME] | Limited overhaul | Top overhaul | Refurbish | Refurbish pipework | Install | Renew | Replace | Pressure and endurance test | Shop Test | Load Test | Operational Test | Set to work | Report | Adjust | Assemble | Calibrate | Dismantle | Push/Purge | Functional Test | Isolate | Preservation | Rectify | Renew coatings | Represerve | Lock | Off | Test | UxE | Work in way | Deep cleaning | Limited set to work | Weigh
Overhaul 9 in number valves |  |  |  |  |  |  |  |  | 0 | 2
Suvery 10 valves |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
Spreadsheet: 218066d1362329126-help-how-to-display-passport-and-visa-almost-expired-dates-to-another-sheet-sample-1-ver2
Sheet: DATABASE

SR. No. | EMP. ID | Name of EMP. | Nationality | Passport No. | [NAME] | Salary | Sponsor | Designation | Joining Date | Joining Date | [NAME]
1 | EMP 1 | Employee 1 |  |  | 2013-03-03 00:00:00 | 2200 | DTC | SUPERVISOR | ------- | 2008-11-01 00:00:00 | 2013-12-18 00:00:00
2 | EMP 2 | Employee 2 |  |  | 2013-04-05 00:00:00 | 2200 | DTC | SUPERVISOR | ------- | 2008-11-01 00:00:00 | 2014-01-13 00:00:00
3 | EMP 3 | Employee 3 |  |  | 2012-11-15 00:00:00 | 2500 | GET | STORE KEEPER | ------- | 2008-11-01 00:00:00 | 2013-08-13 00:00:00
4 | EMP 4 | Employee 4 |  |  | 2013-03-30 00:00:00 | 1100 | DTC | MASON | ------- | 2008-11-01 00:00:00 | 2014-02-16 00:00:00
5 | EMP 5 | Employee 5 |  |  | 2013-04-10 00:00:00 | 1200 | DTC | MASON | ------- | 2008-12-27 00:00:00 | 2014-01-13 00:00:00
Spreadsheet: 23899d1213752055-conditional-formatting-problem-with-change-from-excel-2000-to-2003-conditional-format-test
Sheet: Test

Red indicates increase on previous cell, blue indicates decrease, gray no change
8
9
12
3 | * Deleted previous line (see conditional format error)
2
7
7
22
20
12
12
12
14
14
13
13 | * copied previous line and inserted here
13 | * causes incorrect change here. The conditional format is referring to 2 lines previous.
22
17
7
14
20
12
12
14
13
13
17
17