tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 95117d1294789471-help-with-using-formulas-2011-new-sales
Sheet: Sept

Advisor | FC | Individual Life Premium |  | Individual Life Volume | Type |  | Asset Volume | Portal Bus. | Case Name
 |  | Large Case - Y | [NAME] |  | B/F/O
 |  | 0 | 0 | 0 | B - | 0 | 0 | 0
 |  | 0 | 0 | 0 | F - | 0 | 0 | 0
 | Total All Cases: | 0 |  |  | O - | 0
 |  | 0 |  |  | Total - | 0
Note:  Large Case = > $5,000 Annual Premium for all Life Plans including U.L.
# L/C | # Not L/C | L/C Ind. Life Prem. | Ind. Life Prem. | Ind. Life. Vol. | B | F | O | Asset Vol. | # Asset Vol. | Portal Bus.
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 58
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 61
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 65
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 66
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 69
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 71
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 74
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 77
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 111
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 118
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 181
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A |  |  |  | #N/A
Spreadsheet: 145825d1331755310-fail-re-formatting-my-2d-table-for-use-with-a-pivot-table-crosstabtotablevbahelpsample
Sheet: Sheet3

Quarter | Category | Resource Name | Resource Type | Product A | Product B | Product C | Product D
1 | [NAME] | Design | Freelance | 10 | 20 | 30 | 0
1 | [NAME] | Design | Perm | 20 | 30 | 40 | 2
2 | [NAME] | Design | Freelance | 3 | 34 | 4 | 3
2 | [NAME] | Design | Perm | 2 | 2 | 2 | 3
3 | [NAME] | Design | Freelance | 1 | 3 | 44 | 3 |  |  |  | Hi - Look at the VBA code in the module attached.
3 | [NAME] | Design | Perm | 2 | 3 | 3 | 4 |  |  |  | Run MakeCrossTabsATable(4)
4 | [NAME] | Design | Freelance | 4 | 2 | 3 | 3 |  |  |  | from the immediate window while on this sheet.
4 | [NAME] | Design | Perm | 1 | 5 | 2 | 66
1 | Metal | Polisher | Freelance | 55 | 3 | 2 | 2
1 | Metal | Polisher | Perm | 2 | 3 | 4 | 5
2 | Metal | Polisher | Freelance | 5 | 3 | 2 | 1
2 | Metal | Polisher | Perm | 3 | 4 |  | 4
3 | Metal | Polisher | Freelance | 4 | 6 | 66 | 6
3 | Metal | Polisher | Perm | 45 | 6 | 6 | 6
4 | Metal | Polisher | Freelance | 44 | 663 | 33 | 6
4 | Metal | Polisher | Perm | 3 | 4 | 6 | 6
Spreadsheet: 37962d1236075878-random-selections-student
Sheet: Sheet4

name
student 401
student 402
student 403
student 404
student 405
student 406
student 407
student 408
student 409
student 410
student 411
student 412
student 413
student 414
student 415
student 416
student 417
student 418
student 419
student 420
student 421
Spreadsheet: 145221d1331391545-this-is-bugging-me-creating-a-line-by-line-list-from-a-set-of-data-book1
Sheet: Sheet22

Header1 | Header2 | Header3 |  |  |  |  |  | Sum of Header2
Living | 1 | 60 |  |  |  |  |  | Header1 | Header3 | Total
Living | 1 | 60 |  |  |  |  |  | Dining | 80 | 3
Living | 1 | 60 |  |  |  |  |  | Kitchen | 76 | 2
Dining | 1 | 80 |  |  |  |  |  | Living | 60 | 3
Dining | 1 | 80 |  |  |  |  |  | Grand Total |  | 8
Dining | 1 | 80
Kitchen | 1 | 76
Kitchen | 1 | 76
Spreadsheet: james_steffes__12897__Steffes Budget
Sheet: Scenario 3

Cost Center Owner
Cost Center Number
 | Please use this form only for Outside Services
 | Scenario 3:  How would you implement a 40% reduction from Scenario 1?
 | Retainers and Identified Needs
 | [NAME] | Activity/Region | 2002 Est. $
 | EPSA |  | 175000
 |  |  |  | Target
 |  | Total:
 | [NAME]
 | [NAME] | Activity/Region | 2002 Est. $
 | NE RTO |  | 75000
 | SE RTO |  | 75000
 | ERCOT |  | 25000
 | MW RTO |  | 75000
 | West RTO |  | 75000
 | Cal ISO |  | 25000
 | RTO NOPR |  | 0
 | FERC Market Power |  | 0
 | VA Market Develop |  | 0
 | MI Market Develop |  | 0
 | CA Market Develop |  | 45
 | [NAME] |  | 50000
 | Other FERC |  | 70000
 |  |  |  | Target
 |  | Total:
Spreadsheet: 215872d1361528279-converting-data-from-a-grid-into-a-list-grid-to-list-data-conversion
Sheet: Planning Sheet

week 1
 | 2012-01-02 00:00:00
A | RESTUARANT |  | CAFE |  | TAKEAWAY
B |  | SERVICE STATION |  | BOOKIES
C | OFFICE 1 |  | OFFICE 2 |  | FORECOURT
D |  | FORECOURT |  | TAKEAWAY
week 2
A |  | OFFICE 3 |  | BOOKIES
B | TAKEAWAY |  | FORECOURT |  | RESTUARANT
C |  | GYM |  | SHOP
D | OFFICE 4 |  | WAREHOUSE |  | LEISURE CENTRE
Would like it to show:
Engineer | Date | site
A | 2012-01-02 00:00:00 | RESTUARANT
A | 2012-01-04 00:00:00 | CAFE
A | 2012-01-06 00:00:00 | TAKEAWAY
A | 2012-01-10 00:00:00 | OFFICE 3
A | 2012-01-06 00:00:00 | BOOKIES
B | 2012-01-03 00:00:00 | SERVICE STATION
B | 2012-01-05 00:00:00 | BOOKIES
B | 2012-01-07 00:00:00 | TAKEAWAY
B | 2012-01-11 00:00:00 | FORECOURT
B | 2012-01-13 00:00:00 | RESTUARANT
C | 2012-01-02 00:00:00 | OFFICE 1
C | 2012-01-04 00:00:00 | OFFICE 2
C | 2012-01-06 00:00:00 | FORECOURT
C | 2012-01-10 00:00:00 | GYM
C | 2012-01-06 00:00:00 | SHOP
D | 2012-01-03 00:00:00 | FORECOURT
D | 2012-01-05 00:00:00 | TAKEAWAY
D | 2012-01-07 00:00:00 | OFFICE 4
D | 2012-01-11 00:00:00 | WAREHOUSE
D | 2012-01-13 00:00:00 | LEISURE CENTRE
Spreadsheet: 804391d1668037293-formula-for-printing-all-sheets-xcvbtr10
Sheet: 2

 |  | [NAME])  YA MSHIRIKA T.A.G HERMON REVIVAL CHURCH |  |  |  |  |  |  |  |  | MWAKA
 |  | JINA KAMILI | WEEKS | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUGU | SEPT | OKT | NOV | DEC | JUMLA
 |  | MUSA KUCHESA JULIASI MANGE | 1 | 900000 | 1000 |  | 400 | 5 | 6 | 7 | 8 | 9 | 6 | 4000 | 100
 |  |  | 2 | 200 | 1000 |  | 400 |  |  |  |  |  |  | 4000 | 100
 |  |  | 3 | 300 | 1000 |  | 400 |  |  |  |  |  |  | 4000 | 100
 |  |  | 4 | 400 | 1000 |  | 400 |  |  |  |  |  |  | 4000 | 100
 |  |  | 5 | 500 | 1000 |  | 400 |  |  |  |  |  |  | 4000 | 100
 |  |  | JUMLA
Spreadsheet: 838331d1690923727-calendar-markers-in-excel-forecast-tracker-test
Sheet: COPY.TEST

Key
0 | Teams Post (prep/informational)
1 | Website Page Post
2 | Weekly News Update
3 | Day of Post
 | Communications Committee
 | Start of Fiscal Year: | 2023-07-01 00:00:00 |  |  |  |  |  | 2023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024
 | Deadline marker: | 3 |  |  |  |  |  |  |  |  |  |  |  |  | Scrolling increment: |  |  |  |  |  | 0
 | Description | Assigned to | Comms Type | Progress | Start | Days
 | Events
 | Speaker - Presenting Yourself and Your Brand Online |  |  |  | 2023-08-16 00:00:00 | 1
 | Quarterly Membership Call |  |  |  | 2023-09-06 00:00:00 | 1
 | Misc Tasks
 | [NAME] (Bio) Member [NAME] |  |  |  | 2023-09-01 00:00:00 | 1
 | To add more data, [NAME] new rows ABOVE this one
Spreadsheet: 716326d1612176364-summing-an-area-when-a-condition-is-met-example-2-
Sheet: Sheet1

Product | Shop | Sum of Total
[NAME] | 1 | 37
[NAME] | 0 | 16
Bakewell Tart | 0 | 2
[NAME] | 2 | 7
Beef Pasty | 0 | 5
Brioche Doughnut | 0 | 0
Brownie | 1 | 25
Cheese and Onion Bread | 0 | 5
Cheese and Onion Pasty | 3 | 3
Chelsea Buns | 0 | 0
Chicken and [NAME] | 12 | 12
Chocolate Croissant | 0 | 10
Ciabatta | 0 | 0
Eight Grain | 3 | 8
[NAME] | 0 | 3
French Stick | 0 | 20
Granary | 4 | 133
Large Quiche | 0 | 3
Millionaire Shortbread | 0 | 6
Pain aux raisins | 4 | 14
Plain Croissant | 0 | 12
Portuguese [NAME] | 4 | 23
Rye | 0 | 2
Sausage Roll | 0 | 10
Small Quiche | 22 | 23
Sourdough | 0 | 40
Spelt | 0 | 0
Walnut | 0 | 0
White Rolls | 0 | 0
White Tin | 0 | 0
Wholemeal | 0 | 2
Wholemeal Rolls | 0 | 0
(blank)
Grand Total |  | 421
Spreadsheet: chris_stokley__3976__CDWR Profits
Sheet: Stewart's breakout

CDWR Transmission Sheet
 | CDWR Profits |  | MWHRS |  | EnPower Current |  | MWHRS |  | Annuity
2000-12-01 00:00:00 |  |  |  |  | 115055.18 |  | 4650
2000-12-02 00:00:00 |  |  |  |  | 17619 |  | 740
2000-12-03 00:00:00
2000-12-04 00:00:00 |  |  |  |  | 38164.5 |  | 1050
2000-12-05 00:00:00
2000-12-06 00:00:00 |  |  |  |  | 207598.45 |  | 3843
2000-12-07 00:00:00
2000-12-08 00:00:00
2000-12-09 00:00:00
2000-12-10 00:00:00
2000-12-11 00:00:00
2000-12-12 00:00:00
2000-12-13 00:00:00
2000-12-14 00:00:00
2000-12-15 00:00:00
2000-12-16 00:00:00
2000-12-17 00:00:00
2000-12-18 00:00:00
2000-12-19 00:00:00
2000-12-20 00:00:00
2000-12-21 00:00:00
2000-12-22 00:00:00
2000-12-23 00:00:00
2000-12-24 00:00:00
2000-12-25 00:00:00
2000-12-26 00:00:00
2000-12-27 00:00:00
2000-12-28 00:00:00
2000-12-29 00:00:00
2000-12-30 00:00:00
2000-12-31 00:00:00
Spreadsheet: 142048d1329602128-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: The Memorial

 |  | WEEK 9 THE MEMORIAL
 |  | Total Earnings |  |  |  | Rankings Through Week 9 | Total
 | [NAME] | 0 |  | 1 |  | [NAME] | 0
 | [NAME] | 0 |  | 2 |  | [NAME] | 0
 | [NAME] | 0 |  | 3 |  | [NAME] | 0
 | Player 4 | 0 |  | 4 |  | Player 4 | 0
 | Player 5 | 0 |  | 5 |  | Player 5 | 0
 | Player 6 | 0 |  | 6 |  | Player 6 | 0
 | Player 7 | 0 |  | 7 |  | Player 7 | 0
 | Player 8 | 0 |  | 8 |  | Player 8 | 0
 | Player 9 | 0 |  | 9 |  | Player 9 | 0
 | Player 10 | 0 |  | 10 |  | Player 10 | 0
 | Player 11 | 0 |  | 11 |  | Player 11 | 0
 | Player 12 | 0 |  | 12 |  | Player 12 | 0
 | Player 13 | 0 |  | 13 |  | Player 13 | 0
[NAME] |  | The Memorial |  | YTD
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 4
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 5
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 6
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 7
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 8
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 9
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 10
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 11
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 12
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 13
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Spreadsheet: 24673d1215378627-dynamic-data-from-another-worksheet-tracker-sample
Sheet: Constants

Tournaments | SWIFAs | Lessons | SquadTs | Drills | LogBook | Fundraisers | Demos | Mmelees | SU/TDs |  |  |  | lWCGoal | mWCGoal | WCGoal
100 | 100 | 20 | 20 | 5 | 5 | 20 | 15 | 45 | 45 | WeeklyPointValues |  |  | 550 | 50 | 600
 |  |  |  |  |  |  |  |  |  | WeeklySources
Spreadsheet: 841364d1693552207-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-copy-of-ef-file-
Sheet: 1-5 Day

 | CR1 | Priority | Headcount
1 | Architect RV | 18 | 0.25
2 | Alinity RV | 17 | 0.25
3 | Alinity RV | 16 | 0.25
4 | Alinity RV | 15 | 0.25
5 | Architect RV | 14 | 0.25
12 | [NAME] | 20 | 0.25
13 | [NAME] | 19 | 0.25
9 | Architect RV | 13 | 0.25
15 | Architect SC | 12 | 0.25
17 | Architect RV | 11 | 0.25
50 | Baxter SIV Assy | 21 | 3
31 | Architect RV | 10 | 0.25
8 | Alinity RV | 9 | 0.25
10 | Architect RV | 8 | 0.25
11 | [NAME] | 23 | 0.25
18 | Architect RV | 7 | 0.25
19 | Architect RV | 6 | 0.25
20 | Base Sleeve
21 | Architect RV | 5 | 0.25
22 | Architect RV | 4 | 0.25
23 | Architect RV | 3 | 0.25
30 | Architect RV | 2 | 0.25
7 | Architect SC | 1 | 0.25
Total
 | CR2 | Priority
73 | 6ul | 5 | 0.25
74 | Side Cassette | 4 | 0.25
77 | PP4 | 3 | 0.25
78 | PP1 | 2
79 | E/O Piston/Wash Piston | 1 | 0.25
87 | [NAME] | 6
53 | Architect RV | 7 | 0.25
61 | [NAME] | 8 | 0.25
66 | [NAME] | 9 | 0.25
83 | Ceph OM#1 | 14 | 2
84 | Ceph MB#1
86 | [NAME] | 12 | 0.25
62 | NP227 |  |  | deviation
63
64
67 | [NAME] |  |  | deviation
69
88 | Side Pump | 13 | 0.25
106 | Key 3 white assembly | 10 | 2
107
108 | [NAME] 4 | 11 | 0.25
109
Total
 |  |  | 14.75
Spreadsheet: 9ef444df-2a36-4009-bcc1-8a8a2c5c8652
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43237395 | 2014-09-20 15:40:12 | AXIS | 0 | 3 | 7 | 1631673 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43237601 | 2014-09-20 15:54:15 | ALLIES | 0 | 4 | 7 | 1631673 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43238509 | 2014-09-20 17:15:49 | AXIS | 1 | 7 | 4 | 298050 | MrBlonde | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43238702 | 2014-09-20 17:28:34 | ALLIES | 1 | 7 | 3 | 298050 | MrBlonde | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43245033 | 2014-09-21 02:15:58 | AXIS | 1 | 7 | 5 | 1009110 | HO-SA-KAI | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43250675 | 2014-09-21 13:17:24 | AXIS | 0 | 5 | 7 | 1589254 | Dieudonné de Laubier | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43250891 | 2014-09-21 13:36:49 | ALLIES | 1 | 7 | 4 | 1589254 | Dieudonné de Laubier | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43333873 | 2014-09-27 12:34:37 | AXIS | 0 | 5 | 7 | 1611169 | Baron Von Funck | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43333961 | 2014-09-27 12:49:27 | ALLIES | 0 | 5 | 7 | 1611169 | Baron Von Funck | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43339575 | 2014-09-27 21:16:30 | AXIS | 1 | 7 | 0 | 1268863 | Samurai 7 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43339689 | 2014-09-27 21:36:34 | ALLIES | 1 | 7 | 4 | 1268863 | Samurai 7 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43339972 | 2014-09-27 21:54:25 | AXIS | 1 | 7 | 2 | 1637062 | Arjo | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43341609 | 2014-09-27 23:54:20 | AXIS | 0 | 2 | 7 | 13513 | Dreexxer | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43341767 | 2014-09-28 00:13:47 | ALLIES | 1 | 7 | 3 | 13513 | Dreexxer | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43354050 | 2014-09-28 20:49:28 | AXIS | 1 | 7 | 3 | 120834 | foirallail | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43354384 | 2014-09-28 21:01:51 | AXIS | 1 | 7 | 3 | 1617192 | Spernatz | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43354566 | 2014-09-28 21:12:51 | ALLIES | 1 | 7 | 3 | 1617192 | Spernatz | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43354832 | 2014-09-28 21:41:29 | AXIS | 0 | 4 | 7 | 173801 | Henny | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
Spreadsheet: 57883d1258096825-vlookup-with-multiple-criteria-and-ranking-apples-test
Sheet: Data

Field1 | Field2 | Field3
Apple | 5 | 300
[NAME] | 20 | 125
[NAME] | 25 | 200
Apple | 10 | 210
[NAME] | 25 | 250
Apple | 15 | 100
Spreadsheet: hunter_shively__12722__Fundamentals_Netco
Sheet: Research

 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  | Per HC | New HC | Adj Comp |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  | Compensation | 0
 | Analysts & Associates | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services |  |  |  |  |  |  | Total |  |  |  |  | 1699109
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME]
ENARENT | Rent |  |  |  |  |  |  | Admins | 48000 | 0
ENATECH | Technology |  |  |  |  |  |  | Staff | 49200 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Analysts | 57600 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Associate | 72000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist | 62400 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialst | 74400 | 0
 |  |  |  |  |  |  |  | Managers | 90000 | 0
 | Headcount |  |  | 44 |  |  |  | Directors | 120000 | 1
 |  |  |  |  |  |  |  | General Counsel Asst | 178800 | 0
 | Analysts & Associate Headcount |  |  | 5 | 0 |  |  | Vice President | 216000 | 1
 |  |  |  |  |  |  |  | [NAME] | 312000
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  | Total Misc Exp |  | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 831738d1685859851-need-help-to-find-out-code-wise-rate-calculation-code-wise-rate-calculation-individual
Sheet: AG

Example | Code | From Date | To Date | Days | Connected Load | Load | Rate/Month | Calculation method used for reference | Remarks
1 | AG | 2022-01-01 00:00:00 |  |  |  | 19 |  | (20*G2)*E2/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
2 | AG | 2022-03-28 00:00:00 |  |  |  | 40 |  | (20*G3)*E3/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
3 | AG | 2022-07-23 00:00:00 | 2022-09-25 00:00:00 |  |  | 6 |  | (20*G4)*E4/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
4 | AG | 2022-07-23 00:00:00 | 2022-09-25 00:00:00 |  |  | 60 |  | (20*G5)*E5/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
5 | AG | 2022-09-01 00:00:00 | 2022-11-02 00:00:00 | 62 |  | 75 |  | ((20*G6*28)+(5*G6*34))/30 | 20 and 5 is the rate for AG category for the from and to date time frame respectively, 28 days are at the rate 20 and 34 days are for rate 5. 30 is the days for one month
6 | AG | 2022-12-01 00:00:00 |  |  |  | 100 |  | ((10*E7*7.5)+(5*E7*(G7-7.5)))/30 | Here I have used load brake up as per sheet BB, you can see in sheet BB that there is rate 10 from load 1 to 7.5 and rate 5 7.51 to 999. So I have calculated here First 7.5 load at the rate 10 and then subtracted 7.5 from total load and then remaining load at the rate of 5
7 | AG | 2022-12-01 00:00:00 |  |  |  | 22 |  | ((7.5*10*E8)+(5*E8*(G8-7.5)))/30 | Here I have used load brake up as per sheet BB, you can see in sheet BB that there is rate 10 from load 1 to 7.5 and rate 5 7.51 to 999. So I have calculated here First 7.5 load at the rate 10 and then subtracted 7.5 from total load and then remaining load at the rate of 5
8 | AG | 2023-02-01 00:00:00 |  |  |  | 35 |  | ((7.5*10*E9)+(5*E9*(G9-7.5)))/30 | Here same logic applied as per above but here we have to keep one thing in mind, when you see in sheet BB you will see that in this from date to date time frame period there is in to date cells – symbol available, means these rates are presently active and its end date not yet came.
Spreadsheet: 715844d1611878049-sum-if-across-multiple-sheets-tabs-excel-donation-eba
Sheet: Annual totals

 |  |  |  |  | Donations by organizations
 |  |  |  |  |  |  |  | Total Quantity | Total Weight | Total Value
 |  |  |  |  | St. Mary's Food Bank |  |  |  |  |  |  |  | Tabs
Monthly Totals |  |  |  |  |  |  |  |  |  |  |  |  | January
 | Total Quantity | Total Weight | Total Value |  |  |  |  |  |  |  |  |  | February
January
February
March
April
May
June
July
August
September
October
November
December
Annual Totals
Spreadsheet: 733693d1621718596-variables-for-formulas-sample-for-excel-help-forum-5-22-tms
Sheet: Sheet1

 |  |  |  | Rate Tables
Full name | Job | Rate | YOS | Job | A
EE 1 | A |  | 5 |  | Rate Year | YOS
EE 2 | A |  | 0 |  | 1 |  | 15
EE 3 | B |  | 1 |  | 2 | 1 | 20
EE 4 | B |  | 2 |  | 3 | 2 or more | 25
EE 5 | A |  | 0
EE 6 | A |  | 1 | Job | B
EE 7 | A |  | 2 |  | Rate Year | YOS
EE 8 | A |  | 3 |  | 1 |  | 20
EE 9 | A |  | 4 |  | 2 | 1 | 25
EE 10 | A |  | 5 |  | 3 | 2 or more | 30
EE 11 | A |  | 6
EE 12 | B |  | 0
EE 13 | B |  | 1
EE 14 | B |  | 2
EE 15 | B |  | 3
EE 16 | B |  | 4
EE 17 | B |  | 5
EE 18 | B |  | 6
Spreadsheet: 79461d1279723622-conditional-partially-coping-of-rows-in-excel-something-like-this-maybe
Sheet: Party 1

germany
x | 40299 | Germany | PAO | Q3 2010 | 0 | 0
poland
x | 40326 | Poland | PAO | 0 | 0 | 0
x | 40287 | Poland | PAO | Q3 2010 | 0 | 0
x | 40290 | Poland | PAO | Q3 2010 | x | 0
x | 40297 | Poland | PAO | Q4 2010 | 0 | 0
x | 40300 | Poland | PAO | Q3 2010 | x | 0
Romania
x | 40281 | Romania | PAO | 0 | 0 | 0
x | 40181 | Romania | PAO | Q2 2010 | x | 0
x | 40358 | Romania | PAO | 0 | 0 | 0
x | 40295 | Romania | PAO | 0 | 0 | 0
Spreadsheet: dana_davis__4473__CANADA - 28C
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 28C |  | (Please print)  PREPARED BY: | Laynie East
COMPANY NAME ECT - CANADA ACCOUNTING ENTRY
E-SCHEDULES CHECK LIST
For the period ending: 09/30/2000 |  | REVIEWED BY:
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | N/A
E-2 * | 195 | Other Current Assets | N/A
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | N/A
E-5 | 344 | Goodwill | N/A
E-6 * | TOT_PPE | Property, Plant & Equipment | COMPLETED
 | [NAME] | Depreciation, Depletion & Amortization
[NAME] * | 343, 360 | Other Deferred Charges | N/A
E-11* | 655 | Other Current Liabilities | N/A
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | N/A
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | N/A
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | COMPLETED
E-21 |  | Lease Expense & Future Lease Commitments | N/A
E-31 | VARIOUS ACCOUNTS | Reconciliation of Stockholders' Equity and | N/A
 |  | Investment in Subs
E-36 | TOT_INVEST_SUBS | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A
Spreadsheet: 91117d1290797247-vlookup-multiple-sheets-in-a-different-other-file-samp_a
Sheet: Sheet1

C-code |  | v25-35 | v63-36 | v53-37 | v13-38 | v23-34
c123 |  | 7 | 2 | 999 | 8 | 145
c125 |  | 2 | 3 | 100 | 9 | 563
c126 |  | 5 | 2 | 200 | 10 | 541
c124 |  | 4 | 11 | 23 | 21 | 554
c128 |  | 2 | 10 | 21 | 22 | 555
c127 |  | 1 | 15 | 121 | 14 | 1546