tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 814459d1674409602-copy-project-data-to-respective-tabs-excel-example
Sheet: Sheet1

Project | Data field 1 | Data field 2 | Data field 3 | Data field 4 | Data field 5
A | 1274 | 1225 | 3960 | 1450 | 2895
A | 7197 | 1130 | 3171 | 417 | 2772
A | 6040 | 9946 | 7271 | 2208 | 5109
A | 8153 | 2282 | 9714 | 4079 | 8061
A | 1241 | 7381 | 3811 | 5903 | 8985
B | 4889 | 5698 | 5301 | 4380 | 9062
B | 2970 | 8025 | 6926 | 771 | 8977
B | 9828 | 3140 | 9537 | 6618 | 9578
B | 2330 | 6398 | 5892 | 5444 | 8525
B | 324 | 7746 | 8531 | 9589 | 2768
C | 8105 | 7907 | 4673 | 595 | 2459
C | 5274 | 2412 | 5285 | 5238 | 580
C | 9146 | 7062 | 9859 | 2551 | 4902
D | 1155 | 9133 | 7672 | 9527 | 6859
D | 3440 | 5245 | 7139 | 4815 | 9601
D | 3531 | 525 | 825 | 5261 | 8723
E | 8521 | 8520 | 6964 | 3690 | 5594
E | 1992 | 1255 | 1573 | 7380 | 2022
E | 4315 | 7161 | 6850 | 4084 | 350
E | 3373 | 4802 | 7093 | 3859 | 336
E | 6721 | 6712 | 8320 | 9323 | 7304
Spreadsheet: 785981d1656895537-sum-night-shift-working-hours-ex
Sheet: JUN 22

2022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 6
ID | NAME | DAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
1 | X | 07 14 | 07 14 | 07 14 | 07 14 | 21 07 | S | 07 14 | 21 07 | S | 21 07 | S | N | 07 14 | 15 19 | 07 14 | 15 19 | 07 14 | 19 07 | 07 14 | 15 19 | 07 15 | 21 07 | S | 19 07 | S | 19 07 | S | 07 15
2
3
Spreadsheet: 111973d1308175914-rounding-to-a-specified-value-samplefile
Sheet: Sheet1

 |  |  |  |  |  | BONUS AMT. | 3500
 |  |  |  |  |  | # OF MEN | 9
Last Name | First Name | Assignment # | Amount | [NAME] (5 Digits, Leading zeros) | Project #
[NAME] | A |  |  | 0 | 0
[NAME] | B |  |  | 0 | 0
[NAME] | C |  |  | 0 | 0
[NAME] | F |  |  | 0 | 0
[NAME] | A |  |  | 0 | 0
[NAME] | S |  |  | 0 | 0
[NAME] | F |  |  | 0 | 0
[NAME] | L |  |  | 0 | 0
[NAME] | D |  |  | 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
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  | 3500.009999999999
 |  |  | Total Bonus
Spreadsheet: 883633d1732278367-using-countifs-samplw
Sheet: Sheet1

 |  |  |  | RESULT
 | DOG FOOD | 50 |  | 1
 | DOG FOOD | 20 |  | 2
 | CAT FOOD | 10 |  | 1
 | DOG FOOD | 0 |  | 0 | no value so nill
 | CAT FOOD | 0 |  | 0 | no value so nill
 | DOG FOOD | 0 |  | 0 | no value so nill
 | DOG FOOD | 100 |  | 3
 |  |  |  | Forumla to count the instances where the food has a sale value
 |  |  |  | but if it will count Dogs and Cats separate
Spreadsheet: 809808d1671335027-match-values-in-columns-on-2-different-sheets-test-match
Sheet: Sheet2

Event date | ID | Event Type | Program | Name
2021-05-01 00:00:00 | 0002215/1 | Note | Group1 | [NAME]
2021-05-01 00:00:00 | 0023414/1 | Other | Group1 | [NAME]
2021-05-03 00:00:00 | 06695/1 | Note | Group5 | [NAME]
2021-05-02 00:00:00 | 0023414/1 | Note | Group6 | [NAME]
2021-05-03 00:00:00 | 000666/1 | Other | Group15 | Get Smart
2021-05-04 00:00:00 | 06695/2 | File | Group2 | [NAME]
2021-05-06 00:00:00 | 0023414/1 | Care | Group3 | [NAME]
2021-05-09 00:00:00 | 06695/1 | File | Group1 | [NAME]
2021-05-09 00:00:00 | 02222/2 | File | Group4 | [NAME]
2021-05-08 00:00:00 | 0023414/1 | Other | Group5 | Wiley Coyote
2021-05-08 00:00:00 | 06695/2 | Care | Group1 | [NAME]
2021-05-11 00:00:00 | 0023414/1 | Note | Group3 | [NAME]
2021-05-11 00:00:00 | 06695/2 | File | Group7 | [NAME]
2021-05-12 00:00:00 | 0023414/3 | Other | Group11 | Grow Up
2021-05-12 00:00:00 | 06695/1 | Note | Group15 | New Person
2021-05-13 00:00:00 | 0023414/1 | Note | Group19 | [NAME]
2021-05-13 00:00:00 | 001162/1 | Note | Group23 | [NAME]
2021-05-14 00:00:00 | 06695/1 | Care | Group27 | Jelly Fish
2021-05-15 00:00:00 | 004567/1 | Care | Group3 | [NAME]
2021-05-16 00:00:00 | 0023414/1 | Note | Group31 | [NAME]
Spreadsheet: 872678d1719043615-getting-data-from-one-workbook-to-another-ghm-team-v2
Sheet: Results

 | 2012 |  |  |  |  | 2013 |  |  |  |  | 2014 |  |  |  |  | 2015
 | Girls |  | Boys |  |  | Girls |  | Boys |  |  | Girls |  | Boys |  |  | Girls |  |  | Boys
100
200
800
1500
Shot
Discus
Long
High
Spreadsheet: 126180d1319557473-find-and-replace-indirect-example
Sheet: 2011

Field 1 | Field 2 | Field 3 | Field 4
Data 1 | 0.56 | 829 | 40809
Data 2 | 0.51 | 832 | 25348
Data 3 | 0.09 | 798 | 47459
Data 4 | 0.77 | 338 | 80282
Data 5 | 0.47 | 572 | 14400
Data 6 | 0.21 | 886 | 54539
Data 7 | 0.16 | 670 | 36503
Data 8 | 0.45 | 586 | 87728
Data 9 | 0.94 | 473 | 59363
Data 10 | 0.22 | 123 | 6436
Spreadsheet: 4c52217e-a52a-4ddf-a773-7f182bcffb93
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Image Entertainment | 14381549027 | Various | Scruff: A Christmas Tale | 2010-10-05 | DVD | Children | 9.97 | Y | Available
Image Entertainment | 14381610628 | Various | Magical Christmas Collection | 2010-10-05 | DVD | Children | 14.98 | Y | Available
Image Entertainment | 14381635225 | Various | Knut & Friends | 2010-01-26 | DVD | Children | 14.98 | Y | Available
Image Entertainment | 715515028929 | Various | White Mane | 2012-04-17 | DVD | Children | 14.95 | Y | Available
Image Entertainment | 715515028820 | Various | Red Balloon, The | 2012-04-17 | DVD | Children | 14.95 | Y | Available
Image Entertainment | 628261124398 | Various | Adventures Of [NAME] (10-Disc Set) | 2012-10-02 | DVD | Children | 29.98 | Y | Available
Image Entertainment | 89353703226 | Various | Toys That Rescued Christmas, The | 2007-10-12 | DVD | Children | 9.99 | Y | Available
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Clearance

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Intake
Activity Name | Clearance
Activity Description / Purpose | When a client is registered the system automatically triggers an activity called a ‘clearance’ that searches for information about prior human services cases or applications, and seeks additional information provided outside of WMS, e.g. SSN or employment verification
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
 |  |  | Customer | Request for Services | New Application | Completed Application Packet | Pre-Screening |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Case Closure |  |  | Accounting
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
Searches for information about prior human services cases or applications in WMS
Seeks additional information provided outside of WMS, e.g. SSN or employment verification
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 797136d1663733849-matching-text-to-one-of-multiple-columns-sample-tally-spreadsheet
Sheet: Database

Full Name | First | Alterate First Name #1 | Alterate First Name #2 | Alterate First Name #3 | Last | Alternate Last Name #1
[NAME] |  | [NAME] | Abbi | [NAME] |  | [NAME] | 1
[NAME] |  | [NAME] |  |  |  |  | 2
Addison Pearson |  | Addi | Adi | Addy |  |  | 3
[NAME] |  | Ade | Addy | Adi |  | Hunh | 4
[NAME] |  | Adi | Addy | Addison |  | Bells | 5
Spreadsheet: 105632d1302927021-excel-2007-paste-and-match-data-from-one-sheet-to-another-sample-sheet-1
Sheet: Sheet1

[NAME] | Client | Company | Orders Count | Gross Sales | Net Sales | (I need to paste the column headers from Worksheet 2 here)
137641155 | [NAME] | ABC | 1 | 100 | 100 | I need to paste the data for the John on this row, and the other rows in the same manner)
137658614 | [NAME] | BED | 1 | 100 | 100
139224230 | [NAME] | DEF | 1 | 100 | 100
139015916 | [NAME] | GHI | 1 | 100 | 100
Spreadsheet: 776230d1649617773-help-with-transpose-and-frequency-formula-excel-example
Sheet: Example

Filter by Rep email address | Cadence |  |  |  |  | Employee1@team
 | Monthly | Weekly | Daily | Never / Rarely |  |  | Monthly | Weekly | Daily | Never / Rarely
Assist warehouse with lost/mis-directed shipments - Cadence | 6 | 2 | 1 | 2
Assist warehouse with product identifcation - Cadence | 6 | 5 | 2 | 3 |  | Assist warehouse with product identifcation - Cadence
Calling customers for pickup orders - Cadence | 6 | 2 | 2 | 0 |  | Calling customers for pickup orders - Cadence
Collections / Chasing Payments - Cadence | 1 | 5 | 5 | 2 |  | Collections / Chasing Payments - Cadence
Contacting Purchasing for missing order confirmation in JDE - Cadence | 4 | 3 | 5 | 2 |  | Contacting Purchasing for missing order confirmation in JDE - Cadence
Correcting JDE or warehouse generated errors (kits, ship confirm, ) - Cadence | 5 | 5 | 5 | 2 |  | Correcting JDE or warehouse generated errors (kits, ship confirm, ) - Cadence
Costing from vendor - Cadence | 2 | 1 | 5 | 2 |  | Costing from vendor - Cadence
Credit card orders - Cadence | 1 | 2 | 5 | 2 |  | Credit card orders - Cadence
Credits/RGA/Debits - Cadence | 4 | 2 | 5 | 2 |  | Credits/RGA/Debits - Cadence
Drop Ship Orders - Cadence | 6 | 2 | 5 | 2 |  | Drop Ship Orders - Cadence
Expediting- internal departments (warehouse, shop) - Cadence | 8 | 5 | 5 | 2 |  | Expediting- internal departments (warehouse, shop) - Cadence
Expediting- with vendor - Cadence | 3 | 2 | 5 | 2 |  | Expediting- with vendor - Cadence
Export Docs - Cadence | 2 | 6 | 5 | 2 |  | Export Docs - Cadence
Freight Quotes & Freight Charges on Orders - Cadence | 5 | 6 | 5 | 2 |  | Freight Quotes & Freight Charges on Orders - Cadence
Generate customer UPS pick-up & waybills - Cadence | 6 | 8 | 5 | 2 |  | Generate customer UPS pick-up & waybills - Cadence
Incorrect JDE information - parts needing corrections/duplicates - Cadence | 7 | 8 | 5 | 2 |  | Incorrect JDE information - parts needing corrections/duplicates - Cadence
New Vendor Set Up - Cadence | 8 | 2 | 5 | 2 |  | New Vendor Set Up - Cadence
Non divisional Calls from customers - Cadence | 5 | 1 | 5 | 2 |  | Non divisional Calls from customers - Cadence
Release M1/C1 Holds - Cadence | 5 | 0 | 5 | 2 |  | Release M1/C1 Holds - Cadence
Reseller Quote Follow Ups - Cadence | 3 | 6 | 5 | 2 |  | Reseller Quote Follow Ups - Cadence
Re-send Packing Slips - Cadence | 3 | 5 | 5 | 2 |  | Re-send Packing Slips - Cadence
Send tracking information - Cadence | 2 | 3 | 5 | 2 |  | Send tracking information - Cadence
Sending invoices to customers - Cadence |  | 8 | 5 | 2 |  | Sending invoices to customers - Cadence
Sorting out billing issues/advising correct amounts - Cadence | 5 | 7 | 5 | 2 |  | Sorting out billing issues/advising correct amounts - Cadence
Vendor Purchase order Corrections - Cadence | 6 | 1 | 5 | 2 |  | Vendor Purchase order Corrections - Cadence
Spreadsheet: 834020d1687396856-looking-for-help-with-finding-amount-of-days-between-dates-test-sheet-for-days-calcs
Sheet: Sheet2

 |  | Item 1 | Item 2 | Item 3 | Item 4
Most days in between 1's
Least days in between 1's
Average time between 1's
Days since last 1
Spreadsheet: a65425ad-bb3f-4cc1-a12a-78943f309ed8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7133 | 40954 | Faye | Mcclelland | GBR | 30 | 00:14:15 | 00:01:19 | 00:37:00 | 00:00:47 | 00:20:17 | 1 | 01:13:35
7133 | 47881 | Lauren | Steadman | GBR | 29 | 00:12:17 | 00:02:09 | [NAME] | 00:01:00 | [NAME] | 2 | 01:15:45
7133 | 30601 | Clare | Cunningham | GBR | 31 | 00:14:24 | 00:01:15 | 00:40:07 | 00:00:48 | 00:20:59 | 3 | 01:17:32
Spreadsheet: 215207d1361305808-add-increment-identifier-to-unique-values-book4
Sheet: Sheet1

Sports | Sports 1
Food & Nutrition | Food & Nutrition 1
Food & Nutrition | Food & Nutrition 2
Health & Fitness | Health & Fitness 1
Food & Nutrition | Food & Nutrition 3
Food & Nutrition | Food & Nutrition 4
Food & Nutrition | Food & Nutrition 5
Food & Nutrition | Food & Nutrition 6
Food & Nutrition | Food & Nutrition 7
Food & Nutrition | Food & Nutrition 8
Food & Nutrition | Food & Nutrition 9
Food & Nutrition | Food & Nutrition 10
Food & Nutrition | Food & Nutrition 11
Food & Nutrition | Food & Nutrition 12
Food & Nutrition | Food & Nutrition 13
Sports | Sports 2
Sports | Sports 3
Sports | Sports 4
Spreadsheet: 3f24eec5-aad1-48f2-9ca7-4585db1eb2b3
Sheet: Sheet1

Itm No | Description | Bidder | Unnamed: 3
 |  | Hampden Engineering Corporation | [NAME]
 |  | Bid Price | Bid Price
1 | Oil Extractor Press, Val-Tech Type M-70 or approved equal. | 7920 | 9043
2 | PreHeater Commodity Heater for the Oil Extractor Press | 435 | 506.5
3 | Centrifuge Oil Cleaner for the Oil Extractor Press | 2310 | 2522
4 | Commodity Cleaner for the Oil Extractor Press, Val-Tech CP-4 or approved equal | 8151 | 9754
5 | Screen drawer for seed cleaner for the Oil Extractor Press, Val-Tech CP-4SD or approved equal | 220 | 261.5
6 | 110V Grain Switch mounts in bin to automate auger on/off, Val-Tech CP-GS or approved equal | 302 | 344.5
7 | Meal Cutter, gear motor with propeller blade, Val-Tech MCTR or approved equal | 129 | 168.5
 | Total Oil Extractor Press Group Bid (Sum of the extended prices for Items 1-7 above) | 19467 | 22600
8 | ETHANOL PRODUCTION PROCESS SYSTEM, HAMPDEN MODEL H-ETS-1 or approved equal. | 38931 | 38981
9 | “CDL” Add-on Package for the ETHANOL PRODUCTION PROCESS SYSTEM or approved equal. | 5844 | 5894
 | Total ETHANOL PRODUCTION PROCESS SYSTEM GROUP BID (Sum of the extended prices for Items 8-9 above) | 44775 | 44875
10 | SOLAR SYSTEM TRAINER, HAMPDEN MODEL H-SST-1A or approved equal. | 19742 | 19792
11 | CDL-Package for the SOLAR SYSTEM TRAINER, [NAME] or approved equal. | 4966 | 4991
12 | Electrical [NAME], Hampden Model H-SST-1A-FP or approved equal.  The Hampden product Includes 10 Electrical Faults | 1502 | 1527
 | Total SOLAR SYSTEM TRAINER GROUP BID (Sum of the extended prices for Items 10-12 above) | 26210 | 26310
13 | Mobile [NAME], Hampden or approved equal. | 75330 | 75380
14 | Video System for Mobile [NAME], Hampden or approved equal. | 10172 | 10197
15 | Storage and benches for Mobile [NAME], Hampden or approved equal. | 13408 | 13433
 | Total Mobile Classroom Trailer Group Bid (Sum of the extended prices for Items 13-15 above) | 98910 | 99010
16 | Scale model car construction kit, H-Racer 2.0, Applied Technologies # GTFCJJ-23 or approved equal. | 129 | 129
17 | Mobile Tool Chest, Applied Technologies # [NAME] or approved equal | 120 | 120
18 | Renewable Energy Package, Applied Technologies # [NAME] or approved equal. | 225 | 225
19 | SOLAR PHOTOVOLTAIC TRAINER, HAMPDEN MODEL H-SPT-AC-1 or approved equal | 13515 | 13515
20 | Green Technology Course Package, [NAME], Applied Technologies Package #GT-WC or approved equal. | 12645 | 12645
Items 16-20 received identical bids on the Best and Final Bid so were awarded by a flip of a coin to Hampden Engineering Corporation.  The coin was flipped by [NAME] and witnessed by [NAME], both of the MNPS Purchasing Department.
Spreadsheet: 140637d1328829233-how-to-force-solver-or-excel-to-take-the-maximum-productio-per-line-simple-example1
Sheet: Sheet2 (2)

 | Grade production per year. |  |  |  |  | [NAME] production/ grade/hr |  |  |  |  | Production plan/year |  |  |  | line capacity
 | x1 | x2 | [NAME] |  |  | X1 | X2 | X3 |  |  | x1 | 1000 |  |  | R1 | 2200
R1 | 0 | 0 | 2199.99999995531 | 2199.99999995531 | R1 | 65 | 50 | 55 |  |  | x2 | 2000 |  |  | R2 | 2300
R2 | 1499.999999996782 | 0 | 800.0000000018549 | 2299.999999998637 | R2 | 49 | 55 | 62 |  |  | [NAME] | 3000 |  |  | R3 | 2400
R3 | 399.9999999918341 | 1999.999999957828 | 0 | 2399.999999949662 | R3 | 55 | 60 | 50 |  |  |  | 6000 |  |  |  | 6900
 | 1899.999999988616 | 1999.999999957828 | 2999.999999957165 | 6899.999999903608
Spreadsheet: 183674d1348946584-apply-if-statement-formula-with-multiple-conditions-agent-commission-tabulation
Sheet: commission tabulation

Date: |  | [NAME] Agent
MLS |  | Buyer Agent
List Price
 | Type: | In House
 | Commission Rate: | 0.06
 | Sold Price: | 100000
 | I Worked with: | Sellers Side
Proceeds |  |  | % of Commission | % of Sold Price
 | Agency:
 | Listing Agency: |  | 0.6
 | Selling Agency: |  | 0.4
 | Total Commission:
 | Agent:
 | Listing Agent:
 | Selling Agent:
 | My commission is:
Agent Signature:
_______________________________________________________________Date:___________________ | ______________________________________________________Date:___________________
By Signing agent has confirmed and agrees that all calculations are accurate and dissolves any future
claims of commission against this transaction.
Broker Signature:
_______________________________________________________________Date:__________________ | ______________________________________________________Date:___________________
By signing [NAME] has confirmed and agrees that all calculations are accurate and agrees to pay agent
the above stated commission within a reasonable time.
Performance:
 | Selling Price was |  | of the List Price
Broker Comments:
Spreadsheet: lisa_gang__22338__Avista Energy Prepayment Data
Sheet: Tmx

Tmx purchased from Enron
Date | Volume | Hours | Rate | Day total | Day Dollars
2002-01-03 00:00:00 | 100 | 8 | 1.5
2002-01-06 00:00:00 | 175 | 6 | 1.5 |  |  | nuc has 1050;175 17-22; note says 13-22; 700 dif
2002-01-07 00:00:00 | 75 | 6 | 1.5
2002-01-07 00:00:00 | 175 | 2 | 1.5
2002-01-15 00:00:00 | 150 | 11 | 1.5
2002-01-16 00:00:00 | 150 | 7 | 1.5
2002-01-17 00:00:00 | 150 | 7 | 1.5
2002-01-17 00:00:00 | 150 | 7 | 1.5
2002-01-19 00:00:00 | 150 | 3 | 1.5
2002-01-21 00:00:00 | 150 | 3 | 1.5
2002-01-22 00:00:00 | 100 | 1 | 1.5
2002-01-22 00:00:00 | 150 | 4 | 1.5
2002-01-22 00:00:00 | 150 | 3 | 1.5
2002-01-23 00:00:00 | 100 | 3 | 1.5
2002-01-23 00:00:00 | 150 | 8 | 1.5
2002-01-24 00:00:00 | 100 | 3 | 1.5
2002-01-24 00:00:00 | 150 | 7 | 1.5
2002-01-25 00:00:00 | 150 | 3 | 1.5
2002-01-25 00:00:00 | 150 | 7 | 1.5
2002-01-26 00:00:00 | 150 | 3 | 1.5
Spreadsheet: 83104d1283172157-calculate-of-tasks-completed-category-percentage-calculation
Sheet: Sheet1

Percent Complete | Description | Time Spent | Estimated Time to Completion
0.3 | Category 1 | 35.5
0.1 | Cat 1 Task 1 | 3 | 27
0.2 | Cat 1 Task 2 | 2.5 | 10
0.3 | Cat 1 Task 3 | 17 | 39.66666666666666
0.4 | Cat 1 Task 4 | 6 | 9
0.5 | Cat 1 Task 5 | 7 | 7.000000000000002
0.7999999999999999 | Category 2 | 42
0.6 | Cat 2 Task 1 | 1 | 0.6666666666666667
0.7 | Cat 2 Task 2 | 22 | 9.428571428571427
0.8 | Cat 2 Task 3 | 6 | 1.5
0.9 | Cat 2 Task 4 | 8 | 0.8888888888888893
1 | Cat 2 Task 5 | 5 | 0
 | Totals | 77.5 | 105.1507936507936
 |  | Estimated % Complete: | 0.4243069435995481
Spreadsheet: louise_kitchen__24118__netcobudget1
Sheet: ProForma

NetCo
2002 Proforma
All $'s in Millions Unless Otherwise Noted
EXPENSES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Commercial Headcount Allocation Matrix
 | Budget | Headcount | $/Head | Gas | East Power | West Power | Canada | OOC | Total |  |  |  |  |  | Gas | East Power | West Power | Canada | OOC | Total
Houston Gas Trading and Marketing | 20.6 | 90 |  |  |  |  |  |  |  |  |  |  |  |  | 90 | 65 | 40 | 28 | 4
East Power Trading and Marketing | 10.8 | 65
West Power Trading and Marketing | 7.9 | 40
Canada Gas and Power | 4.5 | 28
Office of the Chairman | 1.4 | 4
Total Commercial Direct
Accounting, Transaction Support | 6.5 | 45
Cash Operations and Tax | 2 | 10
Regulatory Affairs | 1.9 | 9
Credit | 2.2 | 15
Research | 0.5 | 2
Market Risk | 0.8 | 4
Legal | 10.5 | 20
HR | 1.4 | 12
Total General
Gas Logistics | 6.2 | 37
Gas Risk | 7.7 | 46
Gas Settlements | 4.4 | 26
Gas Volume Management | 1.8 | 12
Total Gas Operations
Power Logistics | 2.14 | 13
Power Book Running | 2.7 | 16
Power Settlements | 2.3 | 14
Power Volume Management | 2.3 | 14
Total Power Operations
Houston Fundies | 6.3 | 39
IT Development | 30 | 115
IT Infrastructure | 50.8 | 61
Total IT
IT EOL | 6.7 | 25
EOL Support | 6.3 | 44
Total EOL
Canada Support | 4.6 | 33
Houston Rent | 5
Portland Rent | 1
Canada Rent | 1
Mexico Rent | 0.6
Total Rent
ENE Service Level Agreements | 13.4
Corporate Overhead | 40
Total Expenses
EXPENSE ALLOCATION SUMMARY
 | Budget | Headcount | $/Head | Gas | East Power | West Power | Canada | OOC | Total
Total Expenses
EARNINGS AND BONUS SUMMARY
Gross Margin |  |  |  | 400 | 250 | 150 | 50 | 25
Total Expenses
EBIT
Total Bonus Pool
Non-Commercial Bonuses to Pay
Average Non-Commercial Bonus |  |  |  | 60000 | 60000 | 60000 | 60000 | 60000
Total Non-Commercial Bonus Pool
Commercial Bonuses to Pay
Average Commercial Bonus
Commercial Bonus Pool
% of Book
EXPENSE ALLOCATION PERCENTAGES
 | Budget | Headcount | $/Head | Gas | East Power | West Power | Canada | OOC | Total
EXPENSE BREAKDOWN BY COMMERCIAL BUSINESS UNIT
 | Budget | Headcount | $/Head | Gas | East Power | West Power | Canada | OOC | Total
Check
Spreadsheet: 736578d1623752165-summing-in-a-column-with-an-if-function-whilst-accounting-for-unique-values-in-another-example-tms
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | =SUMPRODUCT(--($D$8:$D$13=$B3),--($H$8:$H$13>0))
 | Industries | Bids Complete | Clients | Wins Per Industry (Attempt) | Wins Per Industry (Attempt) | Should be |  |  |  | TMS Attempt | =SUMPRODUCT(($D$8:$D$13=$B3)*($H$8:$H$13>0))
 | Care |  |  |  |  | 2
 | Construction |  |  |  |  | 0
 | IT / Media |  |  |  |  | 1
 | Client | Buyer / Contract | Industry | Submission | Completed | Results | W | L | ? | Win % of Known Result | Total Win %
 | CLIENT 1 | [NAME] | Care | 2016-01-04 00:00:00 | 2 | 2 | 2 | 0
 | CLIENT 1 | University of Manchester | Care | 2016-02-15 00:00:00 | 2 | 2 | 2 | 0
 | CLIENT 2 | [NAME] | Care | 2016-03-01 00:00:00 | 2 | 2 | 0 | 2
 | CLIENT 3 | NHS England | Construction | 2016-04-18 00:00:00 | 1 | 1 | 0 | 1
 | CLIENT 4 | NHS England | IT / Media | 2016-04-19 00:00:00 | 1 | 1 | 1 | 0
 | CLIENT 2 | University of Oxford | Care | 2016-05-01 00:00:00 | 2 | 2 | 0 | 2