tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 109631d1306431829-countif-formula-on-dynamic-data-bestway_to_handle_this_dynamic_file
Sheet: Raw_Data

LotID | Raw_data_Date_field
A2 | 2008-11-24 00:00:00
A3 | 2009-03-25 00:00:00
A4 | 2008-04-03 00:00:00
A7 | 2010-03-09 00:00:00
A11 | 2009-03-03 00:00:00
A12 | 2009-10-01 00:00:00
A13 | 2010-07-02 00:00:00
A14 | 2007-08-27 00:00:00
A15 | 2009-03-23 00:00:00
A17 | 2011-02-04 00:00:00
A23 | 2009-08-28 00:00:00
A26 | 2009-12-11 00:00:00
A30 | 2010-04-14 00:00:00
A32 | 2010-03-31 00:00:00
A33 | 2009-07-01 00:00:00
A34 | 2010-09-01 00:00:00
A38 | 2009-04-28 00:00:00
A41 | 2010-05-21 00:00:00
A42 | 2009-06-12 00:00:00
A43 | 2010-09-10 00:00:00
[NAME] | 2009-10-15 00:00:00
A51 | 2011-03-29 00:00:00
A58 | 2010-08-13 00:00:00
A78 | 2010-07-14 00:00:00
A80 | 2009-06-25 00:00:00
A83 | 2008-10-31 00:00:00
[NAME] | 2011-02-03 00:00:00
A90 | 2009-03-30 00:00:00
A93 | 2011-02-08 00:00:00
A96 | 2011-04-01 00:00:00
A97 | 2009-02-17 00:00:00
A100 | 2009-10-09 00:00:00
A102 | 2008-09-26 00:00:00
A105 | 2010-02-22 00:00:00
A108 | 2010-02-08 00:00:00
A114 | 2011-02-01 00:00:00
A118 | 2010-09-03 00:00:00
A122 | 2010-08-16 00:00:00
A125 | 2010-12-16 00:00:00
A138 | 2011-03-02 00:00:00
A139 | 2010-12-08 00:00:00
A141 | 2010-08-11 00:00:00
A147 | 2010-12-07 00:00:00
A150 | 2009-12-18 00:00:00
A152 | 2011-02-01 00:00:00
A159 | 2010-06-14 00:00:00
A161 | 2010-10-25 00:00:00
A170 | 2011-01-21 00:00:00
A182 | 2010-02-25 00:00:00
Spreadsheet: gerald_nemec__11421__Compression Schematics
Sheet: Sheet1

Chicago Compression Project
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Objective:
 |  |  |  |  |  |  |  |  | Compressor Station |  |  |  |  |  |  | ANR |  |  |  |  | To interconnect all pipelines
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | in area to create market
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vector |  |  |  |  | opportunities for all parties.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Compression should be
 |  |  |  | Northern Border |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | available to parties on a firm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and interruptible basis.
 |  |  |  |  |  |  |  |  | Peoples
 |  |  |  |  |  |  |  |  | 514# |  |  | Northern Border
 |  |  | Vector Pipeline
 |  |  | [NAME] |  |  |  |  |  | 858#
 |  |  | Peoples
 |  |  | Northern Border
Various Pipeline Operating Pressures |  |  |  |  |  |  |  |  |  |  | Potential Equity Owners:
 | Vector |  |  | 850 - 600 psig |  |  |  |  |  |  | First Rights:
 | ANR |  |  | 850 - 600 psig |  |  |  |  |  |  | Vector or MCN
 | Northern Border |  |  | 1000 - 800 psig |  |  |  |  |  |  | Peoples & ANR or Whitecap
 | Peoples |  |  | 850 - 250 psig |  |  |  |  |  |  | Enron
 |  |  |  |  |  |  |  |  |  |  | Northern Border
 | Others:
 | NiGas |  |  | 500 - 250 psig |  |  |  |  |  |  | Secondary Rights:
 | NGPL |  |  | 700 - 400 psig |  |  |  |  |  |  | NiGas
 |  |  |  |  |  |  |  |  |  |  | NGPL
Spreadsheet: 727174d1617742887-rank-within-sub-categories-in-a-single-column-tie-breaker-for-duplicates-rank-example
Sheet: Sheet1

 | Company Name | Industry | Return | Rank
 | Union Pacific | Freight Rail | -0.004027358999999999
 | CSX | Freight Rail | -0.008826243000000001
 | Canadian National Rail | Freight Rail | -0.002432436
 | Norfolk Southern | Freight Rail | -0.008575214
 | Canadian Pacific Rail | Freight Rail | -0.005406943
 | Kansas City Southern | Freight Rail | -0.004797956
 | Getlink | Freight Rail | -0.008614286
 | [NAME] | Freight Rail | -0.008614286
 | Rumo SA | Freight Rail | -0.002892935
 | Central Japan Rail | Passenger Rail | -0.01353791
 | East Japan Rail | Passenger Rail | -0.009598157000000001
 | West Japan Rail | Passenger Rail | -0.01279145
Spreadsheet: 59639d1260226388-combine-and-sort-two-tables-comparison-calculator-a
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Result |  |  |  |  |  |  |  | Desired Result
 |  |  | Boat A |  |  |  |  | Boat B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boat A | Boat B | Boat A | Boat B | Boat A | Boat B
 |  | RPM | MPH | GPH | MPG |  | RPM | MPH | GPH | MPG |  | RPM | MPH | MPH | GPH | GPH | MPG | MPG |  | RPM | MPH | MPH | GPH | GPH | MPG | MPG
 |  | (x100) |  |  |  |  | (x100) |  |  |  |  | (x100) |  |  |  |  |  |  |  | (x100)
 |  | 5 |  |  |  |  | 5 | 2.8 | 0.18 | 15.8 |  |  |  |  |  |  |  |  |  | 5 |  | 2.8 |  | 0.18 |  | 15.8
 |  | 10 | 5.3 | 1.4 | 3.79 |  | 10 | 5.5 | 0.73 | 7.5 |  |  |  |  |  |  |  |  |  | 10 | 5.3 |  | 1.4 |  | 3.79
 |  | 15 | 6.9 | 2.1 | 3.29 |  | 15 | 7.2 | 1.74 | 4.2 |  |  |  |  |  |  |  |  |  | 10 |  | 5.5 |  | 0.73 |  | 7.5
 |  | 20 | 8.1 | 3.5 | 2.31 |  | 20 | 9.1 | 4.75 | 1.9 |  |  |  |  |  |  |  |  |  | 15 | 6.9 |  | 2.1 |  | 3.29
 |  | 25 | 8.7 | 4.5 | 1.93 |  | 25 | 18.8 | 6.03 | 3.1 |  |  |  |  |  |  |  |  |  | 15 |  | 7.2 |  | 1.74 |  | 4.2
 |  | 30 | 16.7 | 5.2 | 3.21 |  | 30 | 27.7 | 7.26 | 3.8 |  |  |  |  |  |  |  |  |  | 20 | 8.1 |  | 3.5 |  | 2.31
 |  | 35 | 27.2 | 6.1 | 4.46 |  | 35 | 34.4 | 9.09 | 3.8 |  |  |  |  |  |  |  |  |  | 25 | 8.7 |  | 4.5 |  | 1.93
 |  | 40 | 32.9 | 7.6 | 4.33 |  | 40 | 42 | 11.86 | 3.5 |  |  |  |  |  |  |  |  |  | 20 |  | 9.1 |  | 4.75 |  | 1.9
 |  | 45 | 39.9 | 10.2 | 3.91 |  | 45 | 47.9 | 14.98 | 3.2 |  |  |  |  |  |  |  |  |  | 30 | 16.7 |  | 5.2 |  | 3.21
 |  | 50 | 44.4 | 12.5 | 3.58 |  | 50 | 53.3 | 17.02 | 3.1 |  |  |  |  |  |  |  |  |  | 25 |  | 18.8 |  | 6.03 |  | 3.1
 |  | 55 | 54.5 | 15.9 | 3.43 |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 27.2 |  | 6.1 |  | 4.46
 |  | WOT | 56.8 | 17.5 | 3.25 |  | WOT | 58.7 | 20.57 | 2.9 |  |  |  |  |  |  |  |  |  | 30 |  | 27.7 |  | 7.26 |  | 3.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 32.9 |  | 7.6 |  | 4.33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  | 34.4 |  | 9.09 |  | 3.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 | 39.9 |  | 10.2 |  | 3.91
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  | 42 |  | 11.86 |  | 3.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 44.4 |  | 12.5 |  | 3.58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 |  | 47.9 |  | 14.98 |  | 3.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 |  | 53.3 |  | 17.02 |  | 3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55 | 54.5 |  | 15.9 |  | 3.43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WOT | 56.8 |  | 17.5 |  | 3.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WOT |  | 58.7 |  | 20.57 |  | 2.9
Spreadsheet: 843819d1695658092-adding-days-as-time-24-00-00-test
Sheet: time

Total time |  | Start date | Start time | End time | End date | Helper
 |  | 2023-09-22 00:00:00 | 15:58:00 | 17:02:00 | 2023-09-22 00:00:00
 |  | 2023-09-22 00:00:00 | 16:07:00 | 16:15:00 | 2023-09-24 00:00:00
 |  | 2023-09-22 00:00:00 | 09:47:00 | 10:22:00 | 2023-09-23 00:00:00
 |  | 2023-09-22 00:00:00 | 09:18:00 | 09:22:00 | 2023-09-22 00:00:00
 |  | 2023-09-22 00:00:00 | 09:18:00 | 09:22:00 | 2023-09-30 00:00:00
 |  | 2023-09-22 00:00:00 | 09:18:00 | 10:38:00 | 2023-09-22 00:00:00
 |  | 2023-09-22 00:00:00 | 16:07:00 | 16:15:00 | 2023-09-26 00:00:00
Spreadsheet: 779574d1651859858-auto-assignment-randomized-with-little-or-no-duplicates-activity-timeline-participant-planning-and-checklists
Sheet: Participant Checklist

Participant Name | Cycle | Region | Mentor | Judge 1 | Judge 2 | Judge 3
[NAME] | C1 | NA
Amanda | C1 | NA
[NAME] | C1 | NA
Heather | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | NA
Eliza | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | NA
Min | C1 | APAC
Eddy | C1 | APAC
Calvin | C1 | APAC
Kazu | C1 | APAC
Sugi | C1 | APAC
Brent | C1 | APAC
Shailesh | C1 | APAC
Raj | C1 | APAC
Ruchir | C1 | APAC
Reshma | C1 | APAC
[NAME] | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | NA
Zya | C2 | NA
Ren | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | NA
Sloan | C2 | NA
Tyler | C2 | NA
Nick | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | APAC
Naveen | C2 | APAC
[NAME] | C2 | APAC
[NAME] | C2 | APAC
[NAME] | C2 | APAC
Spreadsheet: 828493d1683554836-need-formula-to-calculate-hrs-from-shift-log-time-log_shift_tracker
Sheet: Raw

Date | EMP | Log-In | [NAME] | Total Hours | Shift | Late Hrs | Extend Hrs
2023-05-08 00:00:00 | [NAME] | 09:00:00 | 12:00:00 | how many hours worked | what actual shift he worked | what time he start shift | till what time he extent out of shift timing
2023-05-08 00:00:00 | [NAME] | 09:00:00 | 16:00 PM
2023-05-08 00:00:00 | [NAME] | 03:00:00 | 15:00:00 PM
2023-05-08 00:00:00 | [NAME] | 21:00:00 | 04:00:00
Spreadsheet: louise_kitchen__23026__Margin 11_01_01
Sheet: 1101

FUTURES MARGIN REQUIREMENTS
2001-11-02 00:00:00
2001-11-01 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  | CANADIAN $$$
Broker | OTE | Credit Facility Covering OTE | OTE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Line of Credit Covering Realized/Unrealized Gains & Losses |  | OTE | Initial Margin
ABN-Amro Inc | 462252 |  |  | 0 | 388300 |  |  |  | 0
ADM INVESTOR | 316250 |  |  | 0 | 0
BANK ONE | 0 |  |  | 0 | 0
CARR FUTURES (NG) | 0 |  |  | 0 | 0
CARR FUTURES INC. | -970154.3332500001 |  |  | 0 | 2596565.03
CREDIT SUISSE FIRST BOSTON | -1487084.32 |  |  | 0 | 1400544
EDF MAN   (see note below) | -23998749.5 | 8099229 |  | -29673095.40000004 | 16900771 | 16900771 |  |  | 0
FIMAT * | 38568421.06 |  |  | 0 | 10062141 |  |  | 1 | 0
HSBC - US$ | -3257012.5 |  |  | 0 | 375311
HSBC - Canadian |  |  |  | 0 |  |  |  |  |  |  | 11020 | 153120
JP Morgan | 935685.85 |  |  | 0 | 556520
[NAME] | 0 |  |  | 0 | 0
PARIBAS | 84428855.2 |  |  | 0 | 22178414 | 22178414 |  |  | 0
PRUDENTIAL SI | 417813.7 |  |  | 0 | 392150
REFCO, INC | 0 |  |  | 0 | 0
R J O'BRIEN | 8679 |  |  | 0 | 114000
SAUL STONE & COMPANY | 154044 |  |  | 0 | 180000
SMITH BARNEY, INC ** | 8717126.2 |  |  | 0 | 5891729 | 5891729 |  |  | 0
SMITH BARNEY, INC ** (Financial) | -162000 |  |  | 0 | 86400
TOTAL EXCLUDING MID-DAY CALLS |  |  |  |  |  |  |  |  | 0 |  | 11020 | 153120
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS | 104134126.35675
** Smith Barney Initial Margin does not include Delivery Margin of |  |  |  |  |  | 0
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0 | 5891729 | 5891729 | 44108271
Paribas | 75000000 | 0 | 22178414 | 22178414 | 52821586
EDF | 25000000
Fimat | 20000000 | 0 | 0 | 0 | 20000000
Note:  EDF Man - Positive Net Option value is collateral for futures requirement.
Initial Margin |  |  |  |  | 16900771
Option value used to cover Margin |  |  |  |  | 0
Initial Margin less positive option value |  |  |  |  | 16900771
[NAME] of Credit Analysis:
Initial Margin |  |  |  |  | 16900771
OTE |  |  |  |  | 20000000 | (limit 20,000,000)
Net Option Value |  |  |  |  | 29673095.40000004
Line of Credit Balance |  |  |  |  | 25000000 | (limit 50,000,000)
Paribas Line of Credit Limit is $75,000,000
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: sally_beck__34378__ees gas solutions
Sheet: Sheet2

 |  | Prepared by
 |  | Energy Operations |  | EES Gas Solutions
 |  | Updated:  7/10/01
System |  | Activity |  |  | [NAME] | Status | Due Date
Intramonth Goals
 | 1 | Review Altra reporting |  |  | [NAME] |  | 2001-07-31 00:00:00
 | 2 | Develop Intramonth P&L/ Position reporting |  |  | [NAME] |  | 2001-07-31 00:00:00
 | 3 | Altra training |  |  | [NAME] | In progress | 2001-07-31 00:00:00
 | 4 | Establish procedures to ensure daily system updates and balancing |  |  | [NAME] |  | 2001-07-31 00:00:00
Global Counterparty
 | 1 | Validate and populate Industrial, Retail, and supply Counterparties |  |  | [NAME]
 | 2 | Credit |  |  | [NAME]
 | 3 | Obtain list from Altra of Industrial customers - need file/table format |  |  | [NAME] or Nagesh?
Global Facilities
 | 1 | Validate and populate pipelines and facilities |  |  | [NAME]
Global Contracts
 | 1 | Validate and populate contract data |  |  | Toby Ellis |  | 2001-09-30 00:00:00
 | 2 | Find all contracts |  |  | Toby Ellis
 | 3 | IT issue - CORP domain |  |  | [NAME]
 | 4 | Manpower |  |  | Toby Ellis
 | 5 | Obtain contract list from Altra |  |  | [NAME] or Nagesh?
 | 6 | Bring process down to EWS (now with [NAME]) |  |  | Toby Ellis
 | 7 | Can data be grouped into templates? |  |  | [NAME]
 | 8 | Identify minimum data needed to set contracts up |  |  | [NAME]
Global Rates
 | 1 |  |  |  | [NAME]
Risk/Deal Entry/Sitara
 | 1 | Review deal ticket terms |  |  | [NAME]
 | 2 | Inactivate deals that net out |  |  | [NAME]
 | 3 | Identify mechanism to know when/what has been checked per deal |  |  | [NAME]
 | 4 | Establish environment |  |  | [NAME]
 | 5 | Set up EES as a desk |  |  | [NAME]
 | 6 | Enter all deals into [NAME] |  |  | [NAME]
 | 7 | Provide Sitara training |  |  | [NAME]
 | 8 | Manpower |  |  | [NAME]
Confirmations
 | 1 | Block initial confirmations |  |  | [NAME]
 | 2 | Automate confirmations |  |  | [NAME]
 | 3 | Deal Validation process
Logistics
 | 1 | Provide Unify training |  |  | [NAME]
 | 2 | Establish LDC's up/download capabilities |  |  | [NAME]
 | 3 | Procedures for PMAs |  |  | [NAME]
 | 4 | Set up EDI |  |  | [NAME]
 | 5 | Work with Utilities to provide greater customer detail |  |  | [NAME]
 | 6 | Conversion Issues |  |  | [NAME]
 | 8 | Meet with schedulers |  |  | [NAME]
Transportation Rates
 | 1 | Establish procedures and assign responsibilities |  |  | [NAME]
 | 2 | Obtain current rates list |  |  | [NAME]
 | 3 | Obtain and populate Tariff rates |  |  | [NAME]
Volume Management /Settlements
 | 1 | Retrieve 1 month of invoices from CSC ( Altra only) |  |  | [NAME]
 | 2 | Identify pricing that will not fit into Sitara |  |  | [NAME]
 | 3 | Identify all "miscellaneous other costs" |  |  | [NAME]
MISC
 | 1 | IT concerns |  |  | [NAME]
 | 3 | CSC relationship |  |  | [NAME]
 | 4 | SAP accounting issues |  |  | [NAME]
 | 5 | AVISTA - improve process |  |  | [NAME]
 | 6 | Existing holes -- have they been addressed |  |  | [NAME]
 | 7 | Canada  deals |  |  | [NAME]
Training
Security
Spreadsheet: mark_taylor__24676__Sita
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY: | [NAME]
DATE: |  | DEAL MAKER: | [NAME]
COUNTERPARTY: | Societe Industrielle de Transports Automobiles | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State | France | S&P Rating | n/a
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING)
LIMIT $ MILLIONS
Incorporation State
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit
Cash
Treasuries/Maturity limit
MINIMUM TRANSFER $
COLLATERAL ROUNDING
Delivery Amount
Return Amount
HOLDING and USE OF COLLATERAL
Permitted
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor
Debt Ratings Change
-Below = S&P/Moody's
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 | X
-Counterparty ($[NAME]) | 100 | 100 | Tied to Enron Corp
-Guarantor ($[NAME])
Change in ownership
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: | Deemed ISDA
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | X3-3263
Spreadsheet: 177403d1346302486-index-match-with-row-information-offset-from-the-match-cell-sample-1
Sheet: AugData

Department and Period of Time |  |  |  |  |  |  | Revenue
Clinical Affairs
 |  |  |  | New Charges |  |  | 100
 |  |  |  | Fee Changes for Prior Periods * |  |  | -50
 |  |  |  | Monthly Total |  |  | 1
 |  |  |  | Dept Total |  |  | 2
Community Health July 2012(07/01/2012 - 07/31/2012)
New Charges |  |  |  |  |  |  | 300
Fee Changes for Prior Periods * |  |  |  |  |  |  | -100
Monthly Total |  |  |  |  |  |  | 200
Dept Total |  |  |  |  |  |  | 200
Dental Hygiene July 2012(07/01/2012 - 07/31/2012)
Fee Changes for Prior Periods * |  |  |  |  |  |  | 0
Monthly Total |  |  |  |  |  |  | 0
Dept Total |  |  |  |  |  |  | 0
Diagnostic Science July 2012(07/01/2012 - 07/31/2012)
New Charges |  |  |  |  |  |  | 150
Fee Changes for Prior Periods * |  |  |  |  |  |  | -25
Monthly Total |  |  |  |  |  |  | 125
Dept Total |  |  |  |  |  |  | 125
Endodontics July 2012(07/01/2012 - 07/31/2012)
New Charges |  |  |  |  |  |  | 1000
Fee Changes for Prior Periods * |  |  |  |  |  |  | -80
Monthly Total |  |  |  |  |  |  | 920
Dept Total |  |  |  |  |  |  | 920
Special Care July 2012(07/01/2012 - 07/31/2012)
New Charges |  |  |  |  |  |  | 0
Fee Changes for Prior Periods * |  |  |  |  |  |  | -150
Monthly Total |  |  |  |  |  |  | -150
Dept Total |  |  |  |  |  |  | -150
Implant July 2012(07/01/2012 - 07/31/2012)
New Charges |  |  |  |  |  |  | 700
Fee Changes for Prior Periods * |  |  |  |  |  |  | 600
Monthly Total |  |  |  |  |  |  | 1300
Dept Total |  |  |  |  |  |  | 1300
Oral Surgery July 2012(07/01/2012 - 07/31/2012)
New Charges |  |  |  |  |  |  | 900
Fee Changes for Prior Periods * |  |  |  |  |  |  | -250
Monthly Total |  |  |  |  |  |  | 650
Dept Total |  |  |  |  |  |  | 650
Pedo July 2012(07/01/2012 - 07/31/2012)
New Charges |  |  |  |  |  |  | 1400
Fee Changes for Prior Periods * |  |  |  |  |  |  | -400
Monthly Total |  |  |  |  |  |  | 1000
Dept Total |  |  |  |  |  |  | 1000
Periodontics July 2012(07/01/2012 - 07/31/2012)
New Charges |  |  |  |  |  |  | 800
Fee Changes for Prior Periods * |  |  |  |  |  |  | 0
Monthly Total |  |  |  |  |  |  | 800
Spreadsheet: 728255d1618393248-index-match-formula-to-summarize-data-by-specific-column-information-sample-file
Sheet: Sheet1

Initial table
Quarter | 2 | 2 | 2 | 2 | 2 | 2 | 2
Month | Apr | Apr | Apr | Apr | Apr | Apr | Apr
Week | 13 | 13 | 14 | 14 | 14 | 14 | 14
Activity / Day | 2021-04-01 00:00:00 | 2021-04-02 00:00:00 | 2021-04-05 00:00:00 | 2021-04-06 00:00:00 | 2021-04-07 00:00:00 | 2021-04-08 00:00:00 | 2021-04-09 00:00:00
Activity 1 |  |  | 2 | 1 | 2
Activity 2 |  | 2 |  | 3 |  | 2
Activity 3 |  |  | 1 |  | 2 |  | 2
Activity 4 |  | 2 |  |  | 1 | 3
Activity 5 |  |  | 1 |  |  |  | 2
Activity 6 | 5 |  |  | 2 |  | 1 | 2
Activity 7 |  |  |  | 1 | 1 |  | 1
Activity 8 |  | 2 | 3 |  |  | 1
Activity 9 |  | 2 |  | 1 | 2 |  | 1
Activity 10 | 3 |  | 1 |  |  | 1
Final table
Activity | Apr
Activity 1 | 5
Activity 2 | 7
Activity 3 | 5
Activity 4 | 6
Activity 5 | 3
Activity 6 | 10
Activity 7 | 3
Activity 8 | 6
Activity 9 | 6
Activity 10 | 5
Spreadsheet: 767681d1644579353-1-value-and-return-multiple-results-book1-1-
Sheet: Data

TITLE | Number | User
TEST | INC0125 | Piet
TEST1 | INC0126 | Jan
TEST2 | INC0127 | [NAME]
TEST3 | INC0128 | [NAME]
TEST4 | INC0129 | [NAME]
TEST5 | INC0130 | [NAME]
TEST6 | [NAME] | Jan
TEST7 | INC0132 | Piet
TEST8 | INC0133 | [NAME]
TEST9 | INC0134 | [NAME]
TEST10 | INC0135 | [NAME]
TEST11 | INC0136 | Jan
Spreadsheet: 59751d1260312797-excel-2007-how-to-sort-data-validation-menu-while-typing-characters-in-the-cell-for-the-menu-master_requirement_gathering_template_-final-
Sheet: Case Transfer

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Case Closure
Activity Name | [NAME]
Activity Description / Purpose | Determine whether a client will be eligible for transitional benefits or new benefits as the current case benefits are being closed.
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Receive documentation/decision/report
Determine whether other benefits should be authorized as the prior benefit is closed
Enter information into system
Perform separate determination
Send client notice of action
Generate authorization
Update case folder
Spreadsheet: 193857d1352976143-excel-if-two-columns-match-sum-all-duplicate-values-then-delete-the-duplicates-example
Sheet: Sheet2

201 | 25.455_FRA | 3296000
201 | 25.216_FRA_RD | 1511892.3
201 | 25.460_GBS | 1466076.25
204 | 25.455_FRA | 0
220 | 25.455_FRA | 0
237 | 25.455_FRA | 0
250 | 25.455_FRA | 2999.999999999999
250 | 25.460_GBS | 1100
290 | 25.216_FRA_RD | 116000
290 | 25.455_FRA | -83527.81999999995
290 | 25.460_GBS | -46000
Spreadsheet: 863019d1710586463-how-to-prorate-sales-number-per-consecutive-years-between-2-dates-template-excel-formula
Sheet: Sheet1

 | 2024-2029 Sales  report
 |  |  |  |  |  |  | 2024-01-01 00:00:00 | 2025-01-01 00:00:00 | 2026-01-01 00:00:00 | 2027-01-01 00:00:00 | 2028-01-01 00:00:00 | 2029-01-01 00:00:00
 |  |  |  |  |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 2026-12-31 00:00:00 | 2027-12-31 00:00:00 | 2028-12-31 00:00:00 | 2029-12-31 00:00:00
 | Products | Start date | End date | # of Days | Gross Sales | daily sales | Before and up to end 2024 | 2025 | 2026 | 2027 | 2028 | 2029
 | Home insurance policies | 2024-02-01 00:00:00 | 2026-10-15 00:00:00 |  | 255350 |  |  |  |  | 0 | 0 | 0
 | Life insurance policies | 2025-07-15 00:00:00 | 2027-02-05 00:00:00 |  | 328750 |  | 0 |  |  |  | 0 | 0
 | Car insurance policies | 2027-08-03 00:00:00 | 2029-12-31 00:00:00 |  | 46850 |  | 0 | 0 | 0
 | Concert events policies | 2023-01-15 00:00:00 | 2029-09-30 00:00:00 |  | 855785
 | Travel insurance policies | 2023-03-03 00:00:00 | 2029-08-25 00:00:00 |  | 25000
 | Unemployment, incapacity policies | 2024-04-28 00:00:00 | 2024-12-31 00:00:00 |  | 49950 |  |  | 0 | 0 | 0 | 0 | 0
 | Natutal disasters insurance policies | 2024-02-29 00:00:00 | 2029-10-31 00:00:00 |  | 952500
 | [NAME] outbreak insurance policies | 2026-05-23 00:00:00 | 2027-01-05 00:00:00 |  | 150000 |  | 0 | 0 |  |  | 0 | 0
 | Alien invasions insurance policies | 2028-01-01 00:00:00 | 2028-12-31 00:00:00 |  | 565000 |  | 0 | 0 | 0 | 0 |  | 0
 | Total
 |  |  | # of days = [End date - Start date]+1
 |  |  | Daily sales= Gross Sales / # of days