tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 736519d1623695474-ratios-in-excel-ratios
Sheet: Sheet1

 |  | Students | Managers | Grand Total |  | GCD | #1 | #2 | Ratio
 | Department 1 | 1826.639999999999 | 566.33 | 2392.969999999999
 | Department 2 | 181.86 | 128.9 | 310.76
 | Department 3 | 494.24 | 124.33 | 618.5699999999999
 | Department 4 | 1676.719999999995 | 245.68 | 1922.399999999995
 | Department 5 | 239.39 | 95 | 334.39
 | Department 6 | 296.11 | 146.16 | 442.27
 | Grand Total | 4714.959999999994 | 1306.4 | 6021.359999999995
 | I need the ratio of students to managers in each department |  |  |  |  | Trying to get the ratios in column J to show  more simply i.e.  1:5 or 16:9
Spreadsheet: 134185d1325080280-vlookup-index-match-and-count-exmaple2
Sheet: 01. Cases Opened Data Input

01. CASES OPENED DATA INPUT
2011-12-01 00:00:00
Report From | Report To | Region | Region Description | Division | Division Description | District | District Description | Area | Area Description | Investigation Date (Formatted) | Disciplinary Category
- | - | - | Group Distribution | - | - | - | - | - | - | 2011 11 | -
- | - | - | Group Distribution | - | - | - | - | - | - | 2011 04 | -
- | - | - | Group Example | - | - | - | - | - | - | 2011 10 | -
- | - | - | Group Distribution | - | - | - | - | - | - | 2011 09 | -
- | - | - | Group Another | - | - | - | - | - | - | 2011 10 | -
- | - | - | Group Another | - | - | - | - | - | - | 2011 09 | -
Spreadsheet: 803515d1667502680-count-duplicate-and-missing-names-in-other-sheets-main
Sheet: Sheet1

THOMAS
[NAME]
JACK
DANIEL
MATTHEW
RYAN
[NAME]
[NAME]
SAMUEL
JORDAN
ADAM
[NAME]
ALEXANDER
CHRISTOPHER
BENJAMIN
[NAME]
LIAM
JAKE
WILLIAM
ANDREW
GEORGE
LEWIS
[NAME]
[NAME]
[NAME]
[NAME]
NATHAN
CONNOR
[NAME]
HARRY
Spreadsheet: 808374d1670433167-vlookup-depend-on-dropdown-list-in-another-column-car-parked-testt
Sheet: orders pivot

Count of ORDER NUMBER |  |  |  |  |  | COSTUMER | [NAME] | Days
Distinct Count of Sales Order |  |  |  |  |  | AUSTRALIA | 15 MONTHS | 450
 |  |  |  |  |  | BEIRUT | 12 MONTHS | 365
 |  |  |  |  |  | BELGIUM | 14 MONTHS | 425
 |  |  |  |  |  | BULGARIA | 12 MONTHS | 365
 |  |  |  |  |  | CV Brazil | 18 MONTHS | 548
 |  |  |  |  |  | CV CHINA (SHANGHAI) | 24 MONTHS | 730
 |  |  |  |  |  | [NAME] | 14 MONTHS | 427
 |  |  |  |  |  | CV HONG KONG | 18 MONTHS | 548
 |  |  |  |  |  | CV IBERIA | 15 MONTHS | 450
 |  |  |  |  |  | CV INDIA | 18 MONTHS | 548
 |  |  |  |  |  | CV KOREA LTD | 24 MONTHS | 730
 |  |  |  |  |  | [NAME] | 18 MONTHS | 550
 |  |  |  |  |  | [NAME] | 18 MONTHS | 548
 |  |  |  |  |  | CV SOUTH AFRICA | 14 MONTHS | 427
 |  |  |  |  |  | [NAME] | 14 MONTHS | 427
 |  |  |  |  |  | CV USA | 18 MONTHS | 548
 |  |  |  |  |  | CVI HUNGARY | 15 MONTHS | 450
 |  |  |  |  |  | DUBAI | 12 MONTHS | 365
 |  |  |  |  |  | EUROLENT-SERVIVIOS | 17 MONTHS* | 504
 |  |  |  |  |  | GREECE | 12 MONTHS | 365
VLOOKUP(F2,'orders pivot'!$G$4:$H$22,2,FALSE) |  |  |  |  |  | ISRAEL | 12 MONTHS | 365
or |  |  |  |  |  | KUWAIT | 12 MONTHS | 365
IFERROR(VLOOKUP(F2,'orders pivot'!G:H,2,FALSE),"") |  |  |  |  |  | MAGRABI OPTICAL | 24 MONTHS | 730
 |  |  |  |  |  | Medicals Egypt | 48 MONTHS | 1460
 |  |  |  |  |  | SANDEEP OPTICAL | 13 MONTHS* | 390
 |  |  |  |  |  | SAUDI ARABIA | 12 MONTHS | 365
 |  |  |  |  |  | SINGAPORE | 12 MONTHS | 365
 |  |  |  |  |  | SOUTH AFRICA | 14 MONTHS | 425
 |  |  |  |  |  | TIEDRA | 18 MONTHS | 548
 |  |  |  |  |  | VISION EXPRESS CLS | 12 MONTHS | 365
 |  |  | https://www.excelforum.com/excel-formulas-and-functions/1394715-vlookup-depend-on-dropdown-list-in-another-column.html
Spreadsheet: 835829d1688880526-pmt-formula-incorporating-increased-yearly-payments-2m_loan_dcshaw83
Sheet: Sheet1

Period | PMT | IPMT | PPMT | [NAME] |  | Loan | 2000000
 |  |  |  |  |  | Interest | 0.12
1 | 23040.12 |  |  |  |  | Term, yrs | 10
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
Spreadsheet: 164658d1340828534-need-way-to-interchange-the-way-my-data-is-laid-out-example5
Sheet: Sheet1

format 1 |  |  |  |  | format 2 |  |  |  | format 3
group1 | A1 | B3 |  |  | group1 | A1 |  |  | group1 | A1 | A5 | A9 | A22 | A48 | B3 | B4 | B8 | B19
 | A5 | B4 |  |  |  | A5 |  |  | group2 | A3 | A6 | A8 | A9 | B8 | B21 | B22 | B28
 | A9 | B8 |  |  |  | A9 |  |  | [NAME] | A2 | A3 | A10 | A12 | A24 | B1 | B2 | B12 | B13 | [NAME] | B21 | B34
 | A22 | B19 |  |  |  | A22
 | A48 |  |  |  |  | A48
 |  |  |  |  |  | B3 |  |  | or
group2 | A3 | B8 |  |  |  | B4 |  |  | group1 | A1 | A5 | A9 | A22 | A48 |  | B3 | B4 | B8 | B19
 | A6 | B21 |  |  |  | B8 |  |  | group2 | A3 | A6 | A8 | A9 |  |  | B8 | B21 | B22 | B28
 | A8 | B22 |  |  |  | B19 |  |  | [NAME] | A2 | A3 | A10 | A12 | A24 |  | B1 | B2 | B12 | B13 | [NAME] | B21 | B34
 | A9 | B28
 |  |  |  |  | group2 | A3
[NAME] | A2 | B1 |  |  |  | A6
 | A3 | B2 |  |  |  | A8
 | A10 | B12 |  |  |  | A9
 | A12 | B13 |  |  |  | B8
 | A24 | [NAME] |  |  |  | B21
 |  | B21 |  |  |  | B22
 |  | B34 |  |  |  | B28
 |  |  |  |  | [NAME] | A2
 |  |  |  |  |  | A3
 |  |  |  |  |  | A10
 |  |  |  |  |  | A12
 |  |  |  |  |  | A24
 |  |  |  |  |  | B1
 |  |  |  |  |  | B2
 |  |  |  |  |  | B12
 |  |  |  |  |  | B13
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | B21
 |  |  |  |  |  | B34
Spreadsheet: richard_ring__31559__MPR- Cumulative Filings
Sheet: Purchases

PURCHASES
 |  | CEC |  |  | CEC |  |  | CEC |  |  | CEC |  |  | CEC |  |  | CEC |  |  |  | Total
 |  | Number | Date | [NAME] | Number | Date | [NAME] | Number | Date | [NAME] | Number | Date | [NAME] | Number | Date | [NAME] | Number | Date | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
2000-01-01 00:00:00 |  | 80000 | 11/99 | 596000 | 80000 | 10/99 | 48000 | 80000 | 11/99 | 100000 | 50011 | 7/99 | 528000 | 50011 | 8/99 | 216000 |  |  | 0
2000-02-01 00:00:00 |  | 80000 | 11/99 | 696000 | 50011 | 8/99 | 528000 | 50011 | 9/99 | 168000 |  |  | 0 |  |  | 0 |  |  | 0
2000-03-01 00:00:00 |  | 80000 | 11/99 | 744000 | 50011 | 9/99 | 552000 | 50011 | 10/99 | 193000 |  |  | 0 |  |  | 0 |  |  | 0
2000-04-01 00:00:00 |  | 80000 | 11/99 | 720000 | 50011 | 10/99 | 552000 | 50011 | 11/99 | 168000 |  |  | 0 |  |  | 0 |  |  | 0
2000-05-01 00:00:00 |  | 80000 | 11/99 | 167000 | 10034 | 04/00 | 577000 | 50011 | 11/99 | 552000 | 50011 | 12/99 | 192000 |  |  | 0 |  |  | 0
2000-06-01 00:00:00 |  | 50011 | 12/99 | 552000 | 50011 | 01/00 | 168000 | 10034 | 04/00 | 720000 |  |  | 0 |  |  | 0 |  |  | 0
2000-07-01 00:00:00 |  | 50011 | 01/00 | 332000 | 50011 | 02/00 | 412000 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
2000-08-01 00:00:00 |  | 50011 | 02/00 | 284000 | 50011 | 03/00 | 460000 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
2000-09-01 00:00:00 |  | 50011 | 03/00 | 284000 | 50011 | 04/00 | 436000 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
2000-10-01 00:00:00 |  | 50011 | 04/00 | 283000 | 50011 | 05/00 | 462000 | 80003 | 11/00 | 19445000 | 80003 | 11/00 | 7823000 | 80003 | 11/00 | 1182000 |  |  | 0
2000-11-01 00:00:00 |  | 80000 | 11/00 | 52000000 | 80000 | 11/00 | 8300000 | 80000 | 11/00 | 17000000 | 80000 | 11/00 | 5200000 | 50011 | 05/00 | 282000 |  |  | 0
2000-12-01 00:00:00 |  | 50011 | 06/00 | 282000 | 80003 | 12/00 | 9525000 | 80003 | 12/00 | 1153000 | 50011 | 07/00 | 462000 | 80003 | 09/00 | 126000 |  |  | 0
2001-01-01 00:00:00 |  | 50011 | 01/01 | 744000 | 80003 | 01/01 | 10000000 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
2001-02-01 00:00:00 |  | 50011 | 02/01 | 672000 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
2001-03-01 00:00:00 |  | 80003 | 03/01 | 744000 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
2001-04-01 00:00:00 |  | 80003 | 06/01 | 720000 | 50011 | 04/01 | 720000 | 50011 | 05/01 | 744000 |  |  | 0 |  |  | 0 |  |  | 0
2001-05-01 00:00:00 |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
2001-06-01 00:00:00 |  | 80003 | 07/01 | 744000 | 80003 | 03/01 | 2170000 | 80003 | 04/01 | 2268000 | 80003 | 05/01 | 5268000 | 80003 | 06/01 | 5048000 | 80003 | 07/01 | 3246000
Spreadsheet: 810049d1671511899-find-student-id-and-fill-coressponding-data-in-rows-results
Sheet: Students

[NAME] | LAB01 | LAB02 | LAB03 | LAB04 | LAB05 | LAB06 | [NAME]
1
2
6
7
8
9
10
11
13
14
15 |  |  |  |  |  |  |  |  | Populate Results on this sheet from LABs corresponding to the Student ID
16
17
18
19
21
22
23
24
29
31
Spreadsheet: 473089d1470045196-vlookup-partial-text-example
Sheet: F&B

Student Ref (five digit) | Student Name | Preferred Name | Gender | Age (1/9/15) | Nationality | Residence | Week beginning | 2015-09-07 00:00:00 | 2015-09-14 00:00:00 | 2015-09-21 00:00:00 | 2015-09-28 00:00:00 | 2015-10-05 00:00:00 | 2015-10-12 00:00:00 | 2015-10-19 00:00:00 | 2015-10-26 00:00:00 | 2015-11-02 00:00:00 | 2015-11-09 00:00:00 | 2015-11-16 00:00:00 | 2015-11-23 00:00:00 | 2015-11-30 00:00:00 | 2015-12-07 00:00:00 | 2015-12-14 00:00:00 | 2015-12-21 00:00:00 | 2015-12-28 00:00:00 | 2016-01-04 00:00:00 | 2016-01-11 00:00:00 | 2016-01-18 00:00:00 | 2016-01-25 00:00:00 | 2016-02-01 00:00:00 | 2016-02-08 00:00:00 | 2016-02-15 00:00:00 | 2016-02-22 00:00:00 | 2016-02-29 00:00:00 | 2016-03-07 00:00:00 | 2016-03-14 00:00:00 | 2016-03-21 00:00:00 | 2016-03-28 00:00:00 | 2016-04-04 00:00:00 | 2016-04-11 00:00:00 | 2016-04-18 00:00:00 | 2016-04-25 00:00:00 | 2016-05-02 00:00:00 | 2016-05-09 00:00:00 | 2016-05-16 00:00:00 | 2016-05-23 00:00:00 | 2016-05-30 00:00:00 | 2016-06-06 00:00:00 | 2016-06-13 00:00:00 | 2016-06-20 00:00:00 | 2016-06-27 00:00:00
Spreadsheet: 801006d1666025445-drag-down-formula-but-skip-certain-cells-sample
Sheet: Sheet1

Fruit | [NAME] to be dragged down in A1 |  | Fruits
 |  |  | [NAME]
 |  |  | Apple
 |  |  | Orange
 |  |  | Grapes
 |  |  | Watermellon
 |  |  | [NAME]
 |  |  | Apple
Apple |  | I don't want the formula to effect this cell! Just stay this value! | Orange
 |  |  | Watermellon
 |  |  | [NAME]
 |  |  | Apple
 |  |  | Orange
Orange |  | I don't want the formula to effect this cell! Just stay this value! | [NAME]
 |  |  | Apple
 |  |  | Orange
 |  |  | Watermellon
 |  |  | [NAME]
 |  |  | Apple
 |  |  | Apple
Spreadsheet: 271635d1382007903-sumif-within-date-criteria-sample-workbook
Sheet: Payment List

Contract No | payment start | payment end | Amount Due
12345 | 2012-01-01 00:00:00 | 2012-01-31 00:00:00 | 10
12345 | 2012-01-03 00:00:00 | 2012-06-30 00:00:00 | 20
23456 | 2012-02-05 00:00:00 | 2012-06-24 00:00:00 | 30
23456 | 2012-02-01 00:00:00 | 2012-02-28 00:00:00 | 40
23456 | 2013-02-01 00:00:00 | 2013-02-06 00:00:00 | 50
34567 | 2012-03-01 00:00:00 | 2012-03-31 00:00:00 | 60
34567 | 2013-05-01 00:00:00 | 2013-05-31 00:00:00 | 70
45678 | 2012-04-01 00:00:00 | 2012-04-30 00:00:00 | 80
45678 | 2013-04-01 00:00:00 | 2013-04-30 00:00:00 | 90
56789 | 2012-05-01 00:00:00 | 2012-09-30 00:00:00 | 100
56789 | 2012-06-01 00:00:00 | 2012-04-30 00:00:00 | 110
56789 | 2013-05-01 00:00:00 | 2013-05-31 00:00:00 | 120
Spreadsheet: 103178d1300977104-freight-charges-based-on-zip-freight-per-zip
Sheet: Sheet1

Zip Code | Basic Charge | Min Charge | 0 - 250 KGS | 251 - 500 KGS | 501 - 1000 KGS | 1001 - 3000 KGS | 3001 + KGS
900-1000 | 20 | 65 | 3.0774 | 5.8757 | 5.5557 | 5.5557 | 5.0774
3450-4550 | 3 | 70 | 0.8252 | 2.0786 | 0.7577 | 0.8788 | 0.8252
9999-10111 | 50 | 78 | 0.9276 | 2.2558 | 2.2227 | 2.0075 | 0.7276
Spreadsheet: 141033d1329049467-sum-of-data-from-consecutive-nonconsecutive-dates-example3
Sheet: Sheet3

Date | Score |  |  |  | Con | Non-con | Total
2011-12-27 00:00:00 | 106 |  |  | Count: | 7 | 16 | 23
2011-12-28 00:00:00 | 101 |  |  | Sum of score: | 702 | 1509 | 2211
2011-12-30 00:00:00 | 105
2011-12-31 00:00:00 | 84
2012-01-02 00:00:00 | 100 |  |  |  | If … only one column
2012-01-03 00:00:00 | 74 |  |  |  | {formula}=Array formula, and has to be confirmed by hitting Ctrl+Shift+Enter, not just Enter. {} will be added automatically by Excel
2012-01-05 00:00:00 | 109
2012-01-06 00:00:00 | 102
2012-01-07 00:00:00 | 109
2012-01-09 00:00:00 | 106
2012-01-11 00:00:00 | 84
2012-01-12 00:00:00 | 111
2012-01-14 00:00:00 | 93
2012-01-16 00:00:00 | 93
2012-01-18 00:00:00 | 92
2012-01-20 00:00:00 | 76
2012-01-21 00:00:00 | 121
2012-01-25 00:00:00 | 97
2012-01-27 00:00:00 | 83
2012-01-29 00:00:00 | 107
2012-01-31 00:00:00 | 94
2012-02-02 00:00:00 | 77
2012-02-04 00:00:00 | 87
Spreadsheet: 50073d1249476374-excel-2007-information-merge-from-multiple-sheets-automatic-end-of-month-report-year-09
Sheet: SEPTEMBER 09

 | CONTRACTOR UTILIZED: |  | [NAME]
 | WEEK #1 | 24 - 28 AUG | # of HOURS | # of STUDENTS | CLASS #
ENTER COURSE, CLASS # & # OF STUDENTS IN THE TOTALS BLOCK AT BOTTOM OF PAGE | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
ENTER DATES AT WEEK # FIRST THEN ENTER HOURS FOR APPROPRIATE COURSE | WEEK #1 TOTAL |  | 0 | 0
 | WEEK #2 | 31 AUG - 4 SEP | # of HOURS | # of STUDENTS | CLASS #
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
 | WEEK #2 TOTAL |  | 0 | 0
 | WEEK #3 | 7 - 11 SEP | # of HOURS | # of STUDENTS | CLASS #
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
 | WEEK #3 TOTAL |  | 0 | 0
 | WEEK #4 | 14 - 18 SEP | # of HOURS | # of STUDENTS | CLASS #
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
 | WEEK #4 TOTAL |  | 0 | 0
 | WEEK #5 | 21 - 25 SEP | # of HOURS | # of STUDENTS | CLASS #
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
 | WEEK #5 TOTAL |  | 0 | 0
 | WEEK #6 |  | # of HOURS | # of STUDENTS | CLASS #
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
 | WEEK #6 TOTAL |  | 0 | 0
 |  |  | TOTALS |  | CLASS #
Enter Course Here------------> |  |  | 0 |  |  | <--------Enter Class # Here
Enter Second Course Here------------> |  |  | 0 |  |  | <--------Enter Second Class # Here
Enter Third  Course Here------------> |  |  | 0 |  |  | <--------Enter Third  Class # Here
 | LEAVE (H/V) |  | 0
 | GRAND TOTAL |  | 0 | 0 |  | Enter # of Students in # of Students Column Next to Appropriate Class
Spreadsheet: 857416d1706444865-getting-information-in-a-calendar-formated-table-book1
Sheet: Sheet1

CALENDAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INFORMATION TO BE INTEGRATED IN THE CALENDAR
 | n.r. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  | contract placement
 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  |  | month |  |  |  | CHEKUP 1 |  |  |  |  | CHEKUP 2 |  |  |  |  | CHEKUP 3 |  |  |  |  | CHEKUP 4 |  |  |  |  | CHEKUP 5
 | Year | 2024 |  |  |  |  |  |  |  |  |  |  |  | 2025 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pers | Moths after contract |  |  |  | Pers | Moths after contract |  |  |  | Pers | Moths after contract |  |  |  | Pers | Moths after contract |  |  |  | Pers | Moths after contract
CONTRACT | Month/Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  |  |  |  | Client 1 | [NAME] | 2 |  |  |  | Nick | 4 |  |  |  | [NAME] | 6 |  |  |  | [NAME] | 8 |  |  |  | [NAME] | 11
Client 1 |  |  |  |  |  |  |  |  |  | contr. |  | [NAME] |  | Nick |  | [NAME] |  | [NAME] |  |  | [NAME] |  |  |  |  |  | 1 | Sep | 9 |  | Client 2 | [NAME] | 3 |  |  |  | [NAME] | 5 |  |  |  | [NAME] | 7 |  |  |  | Dina | 9 |  |  |  | [NAME] | 11
Client 2 |  | contr. |  |  | [NAME] |  | [NAME] |  | [NAME] |  |  | Dina |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Jan | 1 |  | Client 3 | [NAME] | 4 |  |  |  | [NAME] | 6 |  |  |  | [NAME] | 8 |  |  |  | Greg | 10 |  |  |  | Megy | 12
Client 3
Spreadsheet: 750762d1633622121-petty-cash-daily-report-working-sheet
Sheet: Report 2 Oct 

 | Statement for: | 1 | 2021-10-02 00:00:00 |  | Current Date | Opening Balance
 |  |  |  |  |  | Closing Balance
 |  |  |  |  | Total Todate | Cash In
 |  |  |  |  |  | Cash Out
 | DATE | TYPE | [NAME] | Invoice Ref | CASH IN | CASH OUT | BALANCE
 |  |  | Opening Balance
Spreadsheet: 859136d1707594934-calculate-ship-date-based-on-lead-time-and-day-of-the-week-book1
Sheet: CS WIP

Customer | Five Star Gourmet Foods |  |  |  |  | Customer Notes
PO# | 12345678 |  | PO Date | 2024-02-10 00:00:00
Cust Code |  |  | Delivery Address
Lead Time
Ship Via
Carrier |  |  | Ship Day
ORDER DETAILS
SRF Order #
Req'd Del Date | 2024-03-01 00:00:00 | Ship | Calculate? | Within Lead Time? |  |  | Lead-Compliant Ship Date |  |  |  |  | [NAME] |  | DtD After P/U
 | Product # | Qty | Description |  |  |  |  | Cat | Cat Freight Multiplier | Flagged |  | Pallet Cube | TiHi | GCW | GIW
Item 1
Item 2
Item 3
Item 4
Item 5
Item 6
Item 7
Item 8
Item 9
Item 10
Item 11
Item 12
Item 13
Item 14
Item 15
Customer Freight Structure
1 Pallet:
2 Pallets:
3 Pallets:
FREIGHT/SHIPPING DETAILS
Full Pallet Req? |  |  | DEL Pricing
Pallet(s) Cube |  |  | Enter in Freight Tracking -> | Freight |  | Fuel |  | Total
Pallet Count |  |  | FOB Pricing | Freight |  | Fuel |  | SRF
Weight |  |  |  |  |  |  |  | Total
Ship-To Zip
Ship Week
Spreadsheet: 875518d1722096481-need-formula-to-deduct-and-add-in-carton-box-pump-formula-pump-2
Sheet: Stocks Check

1 carton | = 16box |  |  |  | SQL  balance | + | -
1 box | = 5pump
unit |  |  |  |  | 100ca 0b 0p | 1 | 1
carton | = CA
box | = B
pump | = P
Spreadsheet: 744325d1629178936-gantt-char-conditional-formatting-dates-pm-simple-gantt-chart-template
Sheet: ProjectSchedule

Company Name
Project Lead | Project Start:
 | Display Week: |  | 1
TASK | [NAME] TO | PROGRESS | START | END | Days | DAYS
Demo
Concrete | Name | 0 |  |  | 2
Walls |  | 0 | 2021-08-19 00:00:00 |  | 5
Task 3 |  | 0 | 2021-08-23 00:00:00 |  | 6
Task 4 |  | 0 | 2021-08-30 00:00:00 |  | 2
Task 5 |  |  | 2021-08-25 00:00:00 |  | 1
Phase 2 Title
Task 1 |  | 0.5
Task 2 |  | 0.5
Task 3
Task 4
Task 5
Phase 3 Title
Task 1
Task 2
Task 3
Task 4
Task 5
Phase 4 Title
Task 1 |  |  | date | date
Task 2 |  |  | date | date
Task 3 |  |  | date | date
Task 4 |  |  | date | date
Task 5 |  |  | date | date
[NAME] new rows ABOVE this one
Spreadsheet: 5e4fb8ab-4195-44ae-8ee7-3c32d1e0b79c
Sheet: Sheet1

2193 Kistarcsa–Gödöllő–Dány | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
(Érvényes: 2011. december 11-től)
Km | Km | Km | Km | VOLÁNBUSZ Zrt. | 2
 |  |  |  |  | 2
 |  |  |  |  | A
0 | .. | .. | .. | Kistarcsa, Megyei kórház | 17:35:00
1.3 | .. | .. | .. | Kistarcsa, vendéglő | 17:38:00
4.4 | .. | .. | .. | [NAME], Templom tér | 17:42:00
11.2 | .. | 0 | .. | Gödöllő, Szabadság tér | 17:50:00
S | .. | 0.5 | .. | Gödöllő, aut. áll. | 17:52:00
S | .. | 0.5 | .. | Gödöllő, aut. áll. | 17:57:00
11.2 | .. | 0 | .. | Gödöllő, Szabadság tér | 17:59:00
11.9 | .. | .. | .. | Gödöllő, Török Ignác u. | 18:00:00
12.3 | .. | .. | .. | Gödöllő, vá. | 18:01:00
12.3 | .. | .. | .. | Gödöllő, vá. | 18:02:00
12.7 | .. | .. | .. | Gödöllő, Fürdö u. | 18:03:00
13.5 | .. | .. | .. | Gödöllő, [NAME] út 90. | 18:05:00
14.4 | .. | .. | .. | Gödöllő, Olt. Ell. Int. | 18:06:00
15.1 | .. | .. | .. | Gödöllő, méhészet | 18:07:00
15.5 | .. | .. | .. | Gödöllő, baromfitelep | 18:08:00
16.6 | .. | .. | .. | [NAME] | 18:10:00
18 | .. | .. | .. | Isaszeg, Hold u. | 18:12:00
18.5 | .. | .. | .. | Isaszeg, [NAME] | 18:13:00
19.1 | .. | 0 | .. | Isaszeg, vá. [NAME]. út | 18:14:00
S | .. | 0.6 | .. | Isaszeg, vá. | 18:15:00
S | .. | 0.6 | .. | Isaszeg, vá. | 18:16:00
.. | .. | 1.2 | .. | Isaszeg, vá. [NAME]. út
19.6 | .. | 1.5 | .. | Isaszeg, Kossuth u. 37. | 18:18:00
20.3 | .. | .. | .. | Isaszeg, Madách u.-i iskola | 18:20:00
20.8 | .. | .. | .. | Isaszeg, [NAME]. | 18:22:00
23.1 | .. | .. | .. | Szentgyörgypusztai erdészet | 18:25:00
23.6 | .. | .. | .. | Isaszeg-Szentgyörgypuszta | 18:26:00
25 | .. | .. | .. | [NAME] fácános | 18:28:00
26.5 | .. | .. | .. | [NAME] erdészlak | 18:30:00
27.6 | .. | .. | .. | Dány-Szentkirály, felső | 18:31:00
28.3 | .. | .. | .. | Dány-Szentkirály, alsó | 18:32:00
28.8 | .. | .. | .. | Sülysápi elág. | 18:33:00
32.4 | .. | .. | .. | Dány, Ady Endre u. | 18:37:00
32.9 | .. | .. | .. | Dány, [NAME] út | 18:38:00
33.3 | .. | .. | .. | Dány, Szőlő körút | 18:39:00
33.9 | .. | .. | .. | Dány, temető | 18:40:00
34.4 | .. | .. | .. | Dány, aut. ford. | 18:41:00
[NAME]:
2 nem közlekedik december 24-én
[NAME]: 2 XII. 24.
A | szabad- és [NAME]
 | a járat érinti a megállóhelyet, de nem áll meg
S | a járat nem érinti a megállóhelyet, [NAME]
Spreadsheet: scott_neal__38686__East
Sheet: East - Trading

 | East Gas - Trading
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp |  | ADJUSTED
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates |  |  |  |  |  |  |  |  |  |  |  | 60500
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  |  |  |  |  | 100000
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | 200000
ENAOUTSV | Outside Services |  |  |  |  |  |  |  |  |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  |  |  |  |  |  |  | 75000
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000 |  |  |  | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0 |  |  | 500
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0 |  |  | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0 |  |  | 100000
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0 |  |  | 1
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 1 |  |  | 15000
ENATAXES | Taxes Other than Income |  |  |  |  |  | 3571654.51 | Associate | 89100 | 0 |  |  | 3571655
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 2
 |  |  |  |  |  |  |  | Director | 143000 | 4
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
 | [NAME] |  |  |  |  |  | Vice President
 | [NAME] |  |  |  |  |  | Director
 | [NAME] |  |  |  |  |  | Director
 | [NAME] |  |  |  |  |  | Director
 | [NAME] |  |  |  |  |  | Director
 | [NAME] |  |  |  |  |  | Manager
 | [NAME] |  |  |  |  |  | Manager
 | [NAME] |  |  |  |  |  | Analyst