tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 220013d1363033940-please-help-with-a-couple-issues-with-adding-moving-columns-financial-accounting-columbia-cu-hazel-savings-2010-upload
Sheet: Checking

2010 Final Smith Accounting-Joint Account
 |  | Bank Name: |  | Columbia Credit Union |  |  |  |  |  | Account: | xxxxx
 |  | Accounts Reviewed: |  | Savings-Suffix 0 |  |  |  |  | Account Holder: |  | [NAME]
 |  | Account Timeperiod: |  | January 1, 2010 - December 31, 2010
 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 |  | Totals
Starting Balance | 5
ADDITIONS
AV Deposits
AV Cash Deposits |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV Cash Deposits
AV ACH Qwest Pension |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV ACH Qwest Pension Deposits
AV ACH Social Security |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV ACH Social Security Deposits
AV ACH US Treasury |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV ACH US Treasury Deposits
AV Account Earned Interest |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Account Earned Interest
AV Check Deposits |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV Check Deposits
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV Transfer Deposits
Total AV Deposits |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV Deposits
AP Deposits
Total AP Deposits |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AP Deposits
SUBTRACTIONS
AV Expenses
AV ACH Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV ACHWithdrawals
AV Check Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV Check Withdrawals
AV Debit Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV Debit Withdrawals
AV Account Fees |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV Account Fees
Total AV Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AV Withdrawals
AP Expenses
AP Cash Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AP Cash Withdrawals
AP ACH Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AP ACH Withdrawals
AP Check Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AP Check Withdrawals
AP Debit Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AP Debit Withdrawals
AP Transfer Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AP Transfer Withdrawals
AP Overdraft Fees |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AP Overdraft Fees
Total AP Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total AP Withdrawals
Unassigned Expenses
Unassigned ACH Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Unassigned ACH Withdrawals
Unassigned Check Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Unassigned Check Withdrawals
Unassigned Debit Withdrawals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Unassigned Debit Withdrawals
Total Unassigned Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Unassigned Withdrawals
Account Balance
Spreadsheet: 175046d1345328505-is-there-a-quick-way-of-copying-sumif-formulas-through-and-adjusting-the-sum_range-excel-forum-test-revc
Sheet: Sheet2

\ | Player ID | Player Surname | Player Forename | Appearances | Time Played
 | 28566 | Player | A | 4 | 91
 | 20208 | Player | B | 5 | 396
 | 19959 | Player | C | 5 | 149
Spreadsheet: benjamin_rogers__1264__NewCo-7-15-00
Sheet: Brownsville

INCOME STATEMENT - BROWNSVILLE
('000 $) | 2001
Revenue
Fixed Price Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Demand Payment
Energy Payment
Start Charge
Amortization of Power Contract
Merchant Period:
Demand Payment | 0 | 0 | 0
Variable Revenue | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major [NAME]
Owner's Expense
Property Taxes Liability | 325 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 427.6483011796236 | 436.201267203216 | 444.9252925472804 | 453.823798398226 | 462.9002743661905
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
After Tax Book Income
CASH FLOW - BROWNSVILLE
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA less Amortization of Power Contract
Plus Property Tax Liability
Less Property Tax Expense | -250
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
STATE TAX & FRANCHISE TAX - BROWNSVILLE
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FRANCHISE TAX
Book Value of Assets
Paid-In-Capital
[NAME] (less Amortization of Power Contract)
Outstanding Debt
Total Capitalization
Greater of Book Value or Capitalization
State Franchise Tax Rate
State Franchise Tax Liability | 456.8763465871717 | 442.7461503009706 | 430.5844881058754 | 414.4857577285682 | 400.355561442367 | 386.2253651561659 | 372.0951688699647 | 357.9649725837635 | 343.8347762975624 | 329.7045800113612 | 315.57438372516 | 301.4441874389589 | 287.3139911527577 | 273.1837948665565 | 259.0535985803553 | 244.9234022941542 | 230.793206007953 | 216.6630097217518 | 202.5328134355507 | 188.4026171493495
STATE TAXES
Pretax Book Income less Amortization of Power Contract
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
State Tax after Allocation of Corporate [NAME]
State Taxable Income before Corporate G&A
Corporate G&A Allocation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Book State Tax after Allocation of Corporate [NAME]
EBT before Corporate [NAME]
Corporate G&A Allocation
EBT
Book State Tax Benefit / (Expense)
Spreadsheet: 123360d1317605401-print-one-address-yard-sale-roster-2011-03
Sheet: Sheet2

 |  | From 654 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r1
 | To: | Name5 | 814
 |  |  |  |  | Confirmed
Barbour |  | Name1 | Name1 |  | a
Blackwood |  | [NAME] | 706 |  | a
Covey |  | Name3 | 412 |  | a
Gerber |  | Name4 | 820 |  | a
Hinz |  | Name5 | 814
Horn |  | Name6 | 117 |  | a
[NAME] |  | Name7 | 705 |  | a
McKintosh |  | Name8 | 647 |  | a
[NAME] |  | Name9 | 602
Office |  | Name10 | 500 |  | a
Wagner |  | Name11 | Office |  | a
Wisswell |  | Name12 | 652 |  | a
Zimmerman |  | Name13 | 523 |  | a
 |  | Name14 | 428 |  | a
 |  | Use "CTRL Q" for mailing
Spreadsheet: 386071d1427569769-struggling-to-work-this-one-out-example-ndm
Sheet: Stock In and Out

Product | Quantity In | Quantity Out | Total | Installer | Job
[NAME] | 1 |  |  | BBC | Bus |  | Product | Job | Sum of Quantity In | Sum of Quantity Out | Sum of Total
Bradford Gold 1.8 | 2 |  |  | BBC | Bus |  | Bradford Gold 1.8 | Bus | 3 | 3 | 101
Bradford Gold 1.8 |  | 3 |  | BBC | Bus |  |  | Delivery | 100 |  | 99
Bradford Gold 2.8 | 5 |  |  | MKO | X Street |  | Bradford Gold 2.8 | X Street | 5 |  | 5
Bradford Gold 1.8 | 100 |  |  | MNB | Delivery |  | [NAME] | Bus | 1 |  | 1
Novahush 3.2@870 |  | 2 |  | MKO | X Street |  | Novahush 3.2@870 | X Street |  | 2 | -2
Bradford Gold 1.8 | 1 |  |  | MMB | Bus |  | Grand Total |  | 109 | 5 | 204
Spreadsheet: 766496d1643907110-extract-unique-values-from-one-table-to-another-table-sample
Sheet: Table 2

Department | Date | Person
Purch | January | [NAME]
Purch | February | [NAME]
Purch | March | [NAME]
Purch | April | [NAME]
Purch | May | [NAME]
Purch | June | [NAME]
Purch | July | [NAME]
Purch | August | [NAME]
Purch | September | [NAME]
Purch | October | [NAME]
Purch | November | [NAME]
Purch | December | [NAME]
Finance | January | [NAME]
Finance | February | [NAME]
Finance | March | [NAME]
Finance | April | [NAME]
Finance | May | [NAME]
Finance | June | [NAME]
Finance | July | [NAME]
Finance | August | [NAME]
Finance | September | [NAME]
Finance | October | [NAME]
Finance | November | [NAME]
Finance | December | [NAME]
Finance | January | [NAME]
Finance | February | [NAME]
Finance | March | [NAME]
Finance | April | [NAME]
Finance | May | [NAME]
Finance | June | [NAME]
Finance | July | [NAME]
Finance | August | [NAME]
Finance | September | [NAME]
Finance | October | [NAME]
Finance | November | [NAME]
Finance | December | [NAME]
Finance | January | [NAME]
Finance | February | [NAME]
Finance | March | [NAME]
Finance | April | [NAME]
Finance | May | [NAME]
Finance | June | [NAME]
Finance | July | [NAME]
Finance | August | [NAME]
Finance | September | [NAME]
Finance | October | [NAME]
Finance | November | [NAME]
Finance | December | [NAME]
Proc | January | [NAME]
Proc | February | [NAME]
Proc | March | [NAME]
Proc | April | [NAME]
Proc | May | [NAME]
Proc | June | [NAME]
Proc | July | [NAME]
Proc | August | [NAME]
Proc | September | [NAME]
Proc | October | [NAME]
Proc | November | [NAME]
Proc | December | [NAME]
WH & Log. | January | [NAME]
WH & Log. | February | [NAME]
WH & Log. | March | [NAME]
WH & Log. | April | [NAME]
WH & Log. | May | [NAME]
WH & Log. | June | [NAME]
WH & Log. | July | [NAME]
WH & Log. | August | [NAME]
WH & Log. | September | [NAME]
WH & Log. | October | [NAME]
WH & Log. | November | [NAME]
WH & Log. | December | [NAME]
Proc | January | [NAME]
Proc | February | [NAME]
Proc | March | [NAME]
Proc | April | [NAME]
Proc | May | [NAME]
Proc | June | [NAME]
Proc | July | [NAME]
Proc | August | [NAME]
Proc | September | [NAME]
Proc | October | [NAME]
Proc | November | [NAME]
Proc | December | [NAME]
Purch | January | [NAME]
Purch | February | [NAME]
Purch | March | [NAME]
Purch | April | [NAME]
Purch | May | [NAME]
Purch | June | [NAME]
Purch | July | [NAME]
Purch | August | [NAME]
Purch | September | [NAME]
Purch | October | [NAME]
Purch | November | [NAME]
Purch | December | [NAME]
Spreadsheet: 109665d1306448880-sun-product-issue-sample_sumprod
Sheet: Sheet1

 | Number of SEs by Country
 |  | SE |  | SSE |  | Total | Budget*
 | Total | #N/A | #N/A | #N/A | #N/A | #N/A | 225 | #N/A
CA | Canada | #N/A | #N/A | #N/A | #N/A | #N/A | 42 | #N/A |  | 131
US | US | #N/A | #N/A | #N/A | #N/A | #N/A | 183 | #N/A
Spreadsheet: 83867d1283894599-order-horizontal-lines-by-skipping-empty-cells-example2
Sheet: Sheet1

1 | 2 |  | 0 | 0
2 |  | TOM | MIKE
3 | SANDRA | SAM | [NAME] | [NAME]
4 |  |  | PETER
5 | [NAME] | NICK |  | STEVE
6 | a |  | b
7 | word1 |  | word2 | word3
Spreadsheet: 139503d1328279044-excel-2007-countif-problem-2011-stats
Sheet: ITA

Pos | Driver | Team | Nation | Points | Laps | [NAME] | Grid | Gained | Classification | Race Distance | Qualifying Time
1 | [NAME] |  |  | 25 | 53 | 00:01:26.557000 | 1 |  | 1 |  | 00:01:22.275000
2 | [NAME] |  |  | 18 | 53 | 00:01:26.207000 | 3 |  | 2 |  | 00:01:22.777000
3 | [NAME] |  |  | 15 | 53 | 00:01:27.191000 | 4 |  | 3 |  | 00:01:22.841000
4 | [NAME] |  |  | 12 | 53 | 00:01:26.187000 | 2 |  | 4 |  | 00:01:22.725000
5 | [NAME] |  |  | 10 | 53 | 00:01:27.402000 | 8 |  | 5 |  | 00:01:23.777000
6 | [NAME] |  |  | 8 | 53 | 00:01:26.924000 | 6 |  | 6 |  | 00:01:23.188000
7 | [NAME] |  |  | 6 | 52 | 00:01:28.357000 | 18 |  | 7 |  | 00:01:25.334000
8 | [NAME] |  |  | 4 | 52 | 00:01:28.054000 | 11 |  | 8 |  | 00:01:24.163000
9 | [NAME] |  |  | 2 | 52 | 00:01:26.895000 | 10 |  | 9 |  | 00:01:24.157000
10 | Sebastien Buemi |  |  | 1 | 52 | 00:01:28.202000 | 16 |  | 10 |  | 00:01:24.932000
11 | Pastor Maldonado |  |  | 0 | 52 | 00:01:28.934000 | 14 |  | 11 |  | 00:01:24.726000
12 | [NAME] |  |  | 0 | 52 | 00:01:28.377000 | 13 |  | 12 |  | 00:01:24.648000
13 | [NAME] |  |  | 0 | 51 | 00:01:29.639000 | 20 |  | 13 |  | 00:01:27.184000
14 | Jarno [NAME] |  |  | 0 | 51 | 00:01:29.825000 | 19 |  | 14 |  | 00:01:26.647000
15 | [NAME] |  |  | 0 | 51 | 00:01:30.783000 | 21 |  | 15 |  | 00:01:27.591000
16 | [NAME] |  |  | 0 | 39 | 00:01:32.013000 | 23 |  | NC |  | 00:01:28.054000
17 | [NAME] |  |  | - | 32 | 00:01:29.403000 | 15 |  | RET |  | 00:01:24.845000
18 | [NAME] |  |  | - | 21 | 00:01:30 | 17 |  | RET |  | 00:01:25.065000
19 | [NAME] |  |  | - | 9 | 00:01:31.455000 | 12 |  | RET |  | 00:01:24.209000
20 | [NAME] |  |  | - | 4 | 00:01:30.994000 | 5 |  | RET |  | 00:01:22.972000
21 | [NAME] |  |  | - | 1 |  | 22 |  | RET |  | 00:01:27.609000
22 | [NAME] |  |  | - | 0 |  | 7 |  | RET |  | 00:01:23.530000
23 | [NAME] |  |  | - | 0 |  | 9 |  | RET |  | 00:01:24.477000
24 | [NAME] |  |  | - | 0 |  | 24 |  | RET |  | 00:01:28.231000
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -23046 | -20000 |  |  |  |  |  |  |  | San Juan
2 | -75534 | -75068 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
3 | -83709 | -75300 |  |  |  | 2001-02-01 00:00:00 | -537 | -5933 |  | 5.62
4 | -83059 | -80207 |  |  |  | 2001-03-01 00:00:00 | -80533 | -96000 |  | 4.98
5 | -83684 | -85233 |  |  |  | 2001-04-01 00:00:00 | -819833 | -1020974 |  | 4.87
6 | -69154 | -85233 |  |  |  | 2001-05-01 00:00:00 |  | -1252019 |  | 3.82
7 | -66976 | -58000 |  |  |  | 2001-06-01 00:00:00 |  | -1589467 |  | 3.2
8 | -80619 | -76101 |  |  |  | 2001-07-01 00:00:00 | -2051914 | -1898771 |  | 2.77
9 |  |  |  |  |  | 2001-08-01 00:00:00 | -2021619 | -1999977 |  | 2.77
10
11
12
13
14 |  |  |  |  |  | 9/1 - 9/25
15
16
17
18
19 |  |  |  |  |  | Accumulated @ 9/25/01
20
21 |  |  |  |  |  | Equilalent volumes at 9/25/01
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 51989
2001-12-08 00:00:00
CBS Volume
 |  |  | 116707
Spreadsheet: 123723d1317826553-find-number-of-instances-data-is-with-with-a-range-dc-temp-1
Sheet: DC

Count Instances above |  | 3
Index | Date | Time | °C
1 | 2011-09-15 00:00:00 | 09:05:51 | 2.1
2 | 2011-09-15 00:00:00 | 09:07:51 | 3.1
3 | 2011-09-15 00:00:00 | 09:09:51 | 3.2
4 | 2011-09-15 00:00:00 | 09:11:51 | 3.1 |  | 6 minutes
5 | 2011-09-15 00:00:00 | 09:13:51 | 2.9
6 | 2011-09-15 00:00:00 | 09:15:51 | 2.7
7 | 2011-09-15 00:00:00 | 09:17:51 | 1.9
8 | 2011-09-15 00:00:00 | 09:19:51 | 3.6 |  | 2 minutes
9 | 2011-09-15 00:00:00 | 09:21:51 | 1.8
10 | 2011-09-15 00:00:00 | 09:23:51 | 1.9
11 | 2011-09-15 00:00:00 | 09:25:51 | 3.5
12 | 2011-09-15 00:00:00 | 09:27:51 | 3.7
13 | 2011-09-15 00:00:00 | 09:29:51 | 5 |  | 6 minutes
14 | 2011-09-15 00:00:00 | 09:31:51 | 2
15 | 2011-09-15 00:00:00 | 09:33:51 | 2.2
16 | 2011-09-15 00:00:00 | 09:35:51 | 2.3
17 | 2011-09-15 00:00:00 | 09:37:51 | 2.5
18 | 2011-09-15 00:00:00 | 09:39:51 | 2.6
19 | 2011-09-15 00:00:00 | 09:41:51 | 2.6
20 | 2011-09-15 00:00:00 | 09:43:51 | 2.8
Spreadsheet: 478776d1473063988-cell-format-date-time-example2
Sheet: Sheet1

Reg Date | User | l16lcode | Volume | InOrder | Article | Revision | Qty | Volume in m3 | Time
2016-08-29 22:41:51 | ASARO | 1 | 589.76 | 055  DT [PHONE] | 40283889 | 20759 | 10 | 0.58976
Spreadsheet: 130404d1322255517-vlookup-help-soc-dashboard-console-extension
Sheet: CMTS Service Group NCP Lookup

 |  |  |  |  |  |  |  |  | Instructions: In the CMTS Selection field select the CMTS that you would like to look up a specific service group for. In the Service Group # [NAME] type in the service group number (Ex: SG66 = 66 or SG01 = 01). This will then display the NCP information for this CMTS and Service Group.
 |  |  |  |  | CMTS Selection
 |  |  |  |  | ALIACMTK01
 |  |  |  |  | Service Group # [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] Last Updated: 11/2/2011
 | Las Vegas Node Combining Plan Information |  |  |  | 01 |  |  |  |  |  |  |  |  |  |  | Version 2.0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Created by [NAME]
 |  |  |  |  | Service Group # [NAME]
 | Node # |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | DHCP Server IP
 | #N/A |  |  |  | #N/A |  |  |  |  |  | #N/A
 | Primary Locator (Slice ID) |  |  |  | MTC / STC |  |  |  | Headend |  |  |  | Service Group ID |  |  |  | IP Bundle Group
 | GEO & Sec Loc |  |  |  | CMTS |  |  |  | CMTS IP Address |  |  |  | [NAME] |  |  |  | Channel Width
 |  |  |  |  | CMTS Card Information |  |  |  | QAM Frequency |  |  |  | Modulation Scheme |  |  |  | Slot
 | RF Gateway Information
 | [NAME] |  |  |  | Spa Interface ID #1 |  |  |  | Spa Interface ID #2 |  |  |  | Spa Interface ID #3 |  |  |  | Spa Interface ID #4
 | Channel Width |  |  |  | TSID/DEPI |  |  |  | TSID/DEPI |  |  |  | TSID/DEPI |  |  |  | TSID/DEPI
 | Modulation Scheme |  |  |  | QAM Frequency #1 |  |  |  | QAM Frequency #2 |  |  |  | QAM Frequency #3 |  |  |  | QAM Frequency #4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Tools & Quick Links
 | North DNCS |  | HE |  | Non DNCS/DAC Fed |  |  |  | HE |  | (AZ Links in Green LV Links in Orange Change Links in Blue)
 | Bell |  | P2 |  | Wickenburg |  |  |  | C2
 | Fowler / Verrado / Tartesso |  | P4 |  | Gila Bend |  |  |  | [NAME]
 | McDowell |  | P5
 | [NAME] |  | P6 |  | South DNCS |  |  |  | HE
 | Peoria / Festival Ranch |  | P7 |  | Tempe / Chandler |  |  |  | A1 / P1
 |  |  |  |  | E. Mesa |  |  |  | P3
 | Moto & SA Platform |  | HE |  | Queen Creek / Pinal |  |  |  | C1
 | Las Vegas |  | 91 |  | S. Scottsdale |  |  |  | P8
 |  |  |  |  | Casa Grande |  |  |  | S1
 |  |  |  |  | Tucson / Green Valley / Vail / Corona De Tucson |  |  |  | T1
 |  |  | Cochise |  | Sierra Vista / Benson /  Ft Huachuca |  |  |  | 12
 |  |  |  |  | Motorola DAC |  |  |  | HE
 |  |  |  |  | Douglas / Pirtlesville |  |  |  | T2
 |  |  |  |  | Tombstone / Whetstone |  |  |  | T3
 |  |  |  |  | Patagonia |  |  |  | T4
 |  |  |  |  | [NAME] Sites |  |  |  | 12
 |  |  | AZ - iVMS Username: |  |  | AutoView (KVM Switch) Username:
 |  |  | roc |  |  | Soc
 |  |  | AZ - iVMS Password: |  |  | AutoView (KVM Switch) Password:
 |  |  | readonly |  |  | monitor
 |  |  | [NAME] Username:
 |  |  | rocaz
 |  |  | [NAME] Password:
 |  |  | readonly
Spreadsheet: 111685d1308023081-consolidate-rows-with-the-same-id-but-different-columns-consolidation-example
Sheet: Sheet1

ID# | A | B | C | D | E | F | G | H | I
1 | X | y | z
2 | y | x | z
3 | z | y | x
4 | X | y | z
5 | y | x | z
6 | z | y | x
7 | X | y | z
8 | y | x | z
9 | z | y | x
4 |  |  |  | x | z | y
5 |  |  |  | z | y | z
6 |  |  |  | y | z | x
7 |  |  |  |  |  |  | z | y | x
8 |  |  |  |  |  |  | x | x | z
9 |  |  |  |  |  |  | y | y | x
4 |  |  |  |  |  |  | x | x | y
Spreadsheet: 136257d1326493003-how-to-merge-multiple-lines-on-a-time-sheet-sched-time-sheet-integration2
Sheet: Site 2

Employee Number | Name |  |  |  |  |  |  |  | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Su | Mo | [NAME] | We | Th | Fr | Sa | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Total Bi-Weekly Hours
Spreadsheet: 90179d1289936686-sum-total-question-yesterdays-totals
Sheet: 1103

11/03/2010  Performance Data
 |  | 1st Work |  |  |  |  | QC |  |  |  | SC | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT | MMIG, RSCH & UPDT | All Other DA | IA  Forms Pkgs | IA  Trans | EDIT w/pass | PASS | FAIL | IA QC | SURINQ  &  Death Cert
 |  |  |  |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint |  | 14 | 10 |  |  |  |  |  |  |  | 128 |  |  | 8 | 16
 | Dustin |  | 13 | 14 |  |  |  |  |  |  |  | 133 | 0.5 | trending | 7.5 | 17.73333333333333
 | Sharron |  |  |  |  |  |  |  |  |  |  | 0 |  | Out of Office |  | #N/A
 | Roxy |  | 6 | 12 |  |  |  |  |  |  |  | 78 |  |  | 8 | 9.75
 | [NAME] |  |  |  |  |  | 2 | 5 | 2 |  |  | 54 |  |  | 7.5 | 7.2
 | Ana |  | 10 | 19 |  |  |  |  |  |  |  | 127 |  |  | 8 | 15.875
 | Maria |  | 3 | 25 |  |  |  |  |  |  |  | 96 |  |  | 8.25 | 11.63636363636364
 | [NAME] | 1 | 7 | 6 | 3 | 6 |  |  |  |  |  | 113 | 0.5 | CISS | 8.25 | 13.6969696969697
 | Petra |  |  |  |  |  | 5 | 7 | 5 |  |  | 102 | 1 | RSRCH/HELP | 11 | 9.272727272727273
 | Regina |  |  |  |  |  | 2 | 14 | 2 |  |  | 108 |  |  | 8 | 13.5
 | Noy |  |  |  |  |  | 3 | 7 | 0 |  |  | 60 | 2 | SWT SME | 6 | 10
 | [NAME] |  |  |  |  |  |  |  |  |  |  | 0 | * | Out of Office / Paternity |  | #N/A
 | [NAME] |  |  |  |  |  |  |  |  |  | 23 | 36.8 |  |  | 4 | 9.200000000000001
 | Michelle |  |  |  |  |  |  |  |  |  |  | 0 |  | IA distribution |  | #N/A
 | Keisha |  |  |  | 1 | 15 |  |  |  |  |  | 93 |  |  | 9.5 | 9.789473684210526
 | [NAME] |  |  |  | 3 | 14 |  |  |  |  |  | 93 | 2 | symposium/email review | 6 | 15.5
TEAM TOTALS | Pts Earned: | 1 | 7 | 3 | 3 | 6 | 6 | 6 | 6 | 3 | 1.6 |  |  |  |  | #N/A
 | TASK VOLUME: | 1 | 53 | 86 | 7 | 35 | 12 | 33 | 9 | 0 | 23 | 1221.8 | 6 |  | 100 | 12.218
 | Pts Earned: | 1 | 371 | 258 | 21 | 210 | 72 | 198 | 54 | 0 | 36.8
Spreadsheet: 195283d1353474272-look-for-specific-numbers-to-put-in-one-cell-test-file
Sheet: Sheet1

 | 6 | 20 | 22 | 37
2 | 3 | 11 | 34 | 36 | 2,11
3 | 15
13 |  |  |  |  | 13
7 |  |  |  | 31 | 31
2 | 4 | 6 | 29 | 30 | 2,29
 |  | 41
2 |  |  | 31 | 41 | 2,31
 |  |  |  |  |  | Results under col. F
 |  |  |  |  |  | numbers to identify are only 2,11,13,17,29,31
 |  |  |  |  |  | Thanks
Spreadsheet: 119127d1314210128-organizing-lists-by-name-condo
Sheet: helper

helper
1-AB
2-AB
1-BC
2-BC
1-YZ
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
0-
Spreadsheet: 871609d1718040259-create-a-dependant-drop-down-list-excel-help-new
Sheet: Sheet1

Coke & FBW
Date | FBW Reference | [NAME] | [NAME] | Catergory | Products | QTY | Invoice Price | Net Price | Gross | Rebate | [NAME] | Rebate Total | Total Price  due to Coke |  |  | Cans | 500ml | Monster | Costa | PMP Cans | PMP 500ml | PMP 2Ltr | PMP Energy
2024-04-04 00:00:00 |  | 128387139 | 937.66 | Cans | Coca Cola | 20 | 12.56 | 11.93 |  |  |  |  |  |  |  | Coca Cola | Coca Cola | Original Green | Americano
 |  |  |  | 500ml | Fanta Orange | 10 | 9.79 | 9.3 |  |  |  |  |  |  |  | Fanta Orange | Diet Coke | [NAME]
 |  |  |  | Monster | Diet Coke | 10 | 9.79 | 9.3
 |  |  |  | Costa | Americano | 20 | 5.95 | 5.65
 |  |  |  |  |  | 22 | 9.79 | 9.3
Spreadsheet: 134701d1325595318-not-include-some-values-in-arrays-based-on-a-further-test-joels-sample
Sheet: Sheet2 ToDo

Skills Log - TEPATS "To-Do" List
Skills Log Task.Variable | Corresponding TEPATS Task | S/S/S/N | Notes/Special Equipment | DTOS Reference
2.1
3.1 | Test2 | 31-51-01 | 0
3.2 | Test5 | 34-25-01 | 0
3.3 | Test6 | 36-20-01 | 0
3.4 | [NAME] | 23-71-01 | 0
5.1 | Test9 | 24-31-01 | 0
6.1 | Test17 | 34-43-02 | 0
6.2 | Test24 | 34-62-01 | 0
6.3 | Test26 | 34-45-01 | 0
7.2 | Test29 | 73-21-01 | 0
8.1
8.2
9.1 | Test30 | 21-00-01 | 0
10.1
11.1 | Test34 | 30-00-01 | 0
12.1 | Test35 | 36-20-01 | 0
13.1 | Test37 | 29-00-02 | (Eng Run)
13.2 | Test41 | 31-43-01 | 0
13.3
14.1 | Test42 | 22-31-10 | 0
15.1 | Test44 | 40869 | 0
15.2
16.1 | Test54 | 37218 | Wattmeter
16.2 | Test61 | 23-13-01 | Wattmeter
16.3
17.1 | Test68 | 34-28-01 | 0
17.2 | Test69 | 34-43-02 | 0
17.3 | Test73 | 34-51-01 | Ramp Test Set
17.4 | Test80 | 25-67-10 | 0
18.1 | Test81 | 34-44-01 | TCAS Test Set
18.2 | Test85 | 34-41-01 | 0
Spreadsheet: 110983d1307515345-nested-if-function-complex-if-and-or-function
Sheet: Sheet1

Conditions |  |  | Example
a>0,b>0,c>0 | All |  | E | F | A | B | C | REMARK
a>0 | b1 |  | 7 | 2 | 1 | 0 | 0 | ap,ac,all
a>0,b>0 | b1,b2 |  | 0 | 1 | 4 | 6 | 0 | ac,[NAME]
a>0,c>0 | b1b3 |  | 1 | 0 | 0 | 0 | 0 | ap
b>0 | b2
b>0,c>0 | b2,b3
c>0 | b3
e | ap
f | ac
Spreadsheet: 762494d1641577433-dynamic-sort-function-for-data-entries-eh-ss-db_v3
Sheet: ADMIN NOTES DO NOT USE

All Managers | Calculations TAB |  |  | Client Calls
SORT NAMES A-Z..