tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 73142d1273781463-rank-worksheet-function-seems-not-to-work-excel-rank-function-issue
Sheet: Sheet1

 | Ref | Price | Price Rank |  | Ref | Price | Price Rank
 | 1 | 299.4699999999999 |  |  | 1 | 299.4699999999999
 | 2 | 213.4699999999999 |  |  | 2 | 213.4699999999999
 | 3 | 190 |  |  | 3 | 190
 | 4 | 150.65 |  |  | 4 | 150.65
 | 5 | 149.35 |  |  | 5 | 149.35
 | 6 | 146.75 |  |  | 6 | 146.75
 | 7 | 146.22 |  |  | 7 | 146.22
 | 8 | 140.4700000000001 |  |  | 8 | 140.4700000000001
 | 9 | 123.47 |  |  | 9 | 123.47
 | 10 | 106.97 |  |  | 10 | 106.97
 | 11 | 79.81000000000004 |  |  | 11 | 79.81
 | 12 | 79.81000000000003 |  |  | 12 | 79.81
 | 13 | 79.81000000000002 |  |  | 13 | 79.81
 | 14 | 79.81000000000002 |  |  | 14 | 79.81
 | 15 | 79.81000000000002 |  |  | 15 | 79.81
 | 16 | 79.81 |  |  | 16 | 79.81
 | 17 | 79.81 |  |  | 17 | 79.81
 | 18 | 79.81 |  |  | 18 | 79.81
 | 19 | 79.81 |  |  | 19 | 79.81
 | 20 | 79.81 |  |  | 20 | 79.81
 | 21 | 79.80999999999999 |  |  | 21 | 79.81
 | 22 | 79.80999999999999 |  |  | 22 | 79.81
 | 23 | 75.53 |  |  | 23 | 75.53
Spreadsheet: 134854d1325678744-index-match-ind-and-matc040112
Sheet: Sheet1

 | Skill | Site | Channel | 2012-01-01 00:00:00 | 2012-01-08 00:00:00 | 2012-01-15 00:00:00 | 2012-01-22 00:00:00 | 2012-01-29 00:00:00 | 2012-02-05 00:00:00
 | US_Pri | DAK | Phone | 500 | 500 | 500 | 500 | 500 | 500
 | Kindle | DAK | Phone | 500 | 500 | 500 | 500 | 500 | 800
 | MP3 | DAK | Phone | 500 | 500 | 500 | 500 | 500 | 900
 | US_Pri | SUT | Chat | 100 | 100 | 100 | 100 | 100 | 100
 | Kindle | SUT | Chat | 100 | 100 | 100 | 100 | 100 | 100
 | MP3 | SUT | Chat | 100 | 100 | 100 | 100 | 100 | 100
 | US_Pri | HYD | [NAME] | 300 | 300 | 300 | 300 | 300 | 300
 | Kindle | HYD | [NAME] | 300 | 300 | 300 | 300 | 300 | 300
 | MP3 | HYD | [NAME] | 300 | 300 | 300 | 300 | 300 | 300
Spreadsheet: 102656d1300640231-retrieve-first-non-blank-cell-value-order-monitor
Sheet: STOCK

 |  | STOCK
 | PRODUCT 1 | 1000
 | PRODUCT 2 | 50
 | PRODUCT 3 | 200
 | PRODUCT 4 | 300
 | PRODUCT 5 | 0
 | PRODUCT 6 | 0
 | PRODUCT 7 | 0
 | PRODUCT 8 | 50
 | PRODUCT 9 | 42
 | PRODUCT 10 | 56
 | PRODUCT 11 | 49
 | PRODUCT 12 | 800
 | PRODUCT 13 | 512
 | PRODUCT 14 | 483
 | PRODUCT 15 | 567
 | PRODUCT 16 | 78
 | PRODUCT 17 | 53
 | PRODUCT 18 | 27
 | PRODUCT 19 | 97
 | PRODUCT 20 | 982
Spreadsheet: 125972d1319452194-which-function-to-copy-data-from-many-sheets-to-a-sheet-in-same-file-monthly-report
Sheet: 02-09

2
Report
NGÀY :
STT | Type | Product Name |  |  | Amount | Price | % DISCOUNT |  |  |  | Total | Remarks
 |  | Code | Color Code | Size |  |  | PROMOTION |  | VIP CARD
 |  |  |  |  |  |  | % | Total | % | Total
 |  |  |  |  | (1) | (2) | (3) | (4)=(2)-(3) | (5) | (6)=(2)*(1)-(4)-(5) | (7)=(2)*(1)-(4)-(6)
 | GIAYSS10 | 1331 | 082 | 7.5 | 1 | 2015000 |  | 0 |  | 0 | 2015000
 | GIAYSS10 | 2811 | 1S9 | 5 | 1 | 1510000 |  | 0 |  | 0 | 1510000
 | GIAYSS10 | 3222 | 098 | 8 | 1 | 3733000 |  | 0 |  | 0 | 3733000
 | NAM | L121210 | S7X | 4 | 1 | 1936000 |  | 0 |  | 0 | 1936000
 | NAM | PH428310 | L0N | 3 | 1 | 2744000 |  | 0 |  | 0 | 2744000
 | NAM | PH428310 | PV3 | 3 | 1 | 2744000 |  | 0 | 10 | 274400 | 2469600
 | NAM | PH539C10 | 68G | 5 | 1 | 2468000 |  | 0 | 10 | 246800 | 2221200
 | NAM | PH665510 | QGD | 5 | 1 | 3119000 |  | 0 |  | 0 | 3119000
 | NAM | PH731910 | 476 | 3 | 1 | 1839000 |  | 0 | 10 | 183900 | 1655100
 | NAM | PH731910 | T01 | 3 | 1 | 1839000 |  | 0 | 10 | 183900 | 1655100
 | NON | RK981310 | 031 | TU | 1 | 621000 |  | 0 | 10 | 62100 | 558900
 |  | PH820110 | U5B | 4 | 1 | 2069000 |  | 0 |  | 0 | 2069000
 |  | RK981310 | [NAME] | TU | 1 | 621000 |  | 0 | 10 | 62100 | 558900
 |  | CH469010 | [NAME] | 40 | 1 | 2886000 |  | 0 |  | 0 | 2886000
 |  | PH820110 | QU4 | 5 | 1 | 2069000 |  | 0 |  | 0 | 2069000
 |  |  |  |  |  |  |  | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 |  | 0 | 0
 |  |  |  |  | 15 |  |  | 0 |  | 1013200 | 31199800
 |  | TOTAL:
 |  |  |  |  |  |  | %
* BANG XUAT NHAP NAY DANH CHO HCM
Spreadsheet: 41419d1239886272-cells-cross-referancing-data-from-another-sheet-to-fill-themselves-in-nice
Sheet: Pickups

 | Pickup | Component | Ref 1 |  | Ref 2 |  | Ref 3 |  | Ref 4 |  | Ref 5 |  | Ref 6 |  | Ref 7 |  | Ref 8 |  | Ref 9 |  | Ref 10 |  | Ref 11 |  | Ref 12 |  | Ref 13
 |  |  | Ref | Place | Ref | Place | Ref | Place | Ref | Place | Ref | Place | Ref | Place | Ref | Place | Ref | Place | Ref | Place | Ref | Place | Ref | Place | Ref | Place | Ref | Place
 | 1 | 270R | R4 | 1 | R117 | 2
 | 2 | 1K | R12 | 3
 | 3 | 10UF | C4 | 4
 | 4 | 10K | RN1 | 5
 | 5 | 10UH | L2 | 6
 | 6 | 47R | R19 | 7 | R13 | 8 | R14 | 9 | R15 | 10 | R16 | 11 | R165 | 12 | R17 | 13
 | 7
 | 8
 | 9
 | 10 |  |  |  |  |  | I would like the circuit ref "R15" to be looked up on this sheet and then to data in colum "C" to be copied into the placement sheet
 | 11
 | 12 |  |  |  |  |  | Wherever the data is found I would like the row number to be used but with column C so (so data to be copied will be   C:found ref row number)
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
Spreadsheet: 698139d1601791706-criteria-based-ranking-test
Sheet: Sheet1

 | Item | Rank |  | Fix Qty | Req. | Type 1 | Type 2 | Type 3
 | A | 1 |  | 100 | 120
 | B | 1 |  | 100 | 80
 | C | 2 |  | 100 | 100
 | D | 3 |  | 100 | 150
 | E | 4 |  | 100 | 50
 | F | 5 |  | 100 | 100
 | G | 6 |  | 100 | 100
 | H | 3 |  | 100 | 100
Spreadsheet: 472520d1469626713-retrieving-information-from-multiple-sheets-book1
Sheet: 1981

 | Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10
[NAME] | Y | Y | Y | Y | N | N | N | N | N | Y
[NAME] | Y | Y | N | N | N | N | N | N | N | N
[NAME] | N | Y | N | Y | N | Y | N | N | Y | Y
[NAME] | Y | Y | Y | N | N | Y | Y | N | Y | Y
Clarissa | N | N | Y | Y | Y | Y | Y | Y | N | Y
Spreadsheet: 888654d1739222071-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 35

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Tue 23 Jan Glucose mmol/L
 |  |  |  |  |  | 6.1
Wed 24 Jan Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Thu 25 Jan Glucose mmol/L
Fri 26 Jan Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 6.5
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sat 27 Jan Glucose mmol/L
 |  |  |  |  | 6.8 7.0
Sun 28 Jan Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Mon 29 Jan Glucose mmol/L
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Tue 30 Jan Glucose mmol/L
Spreadsheet: 28884d1223456578-conditional-formatting-by-referencing-a-different-cell-copy-of-test
Sheet: Sheet1

 | Test Level 1 | Test Level 2 |  | Test 1 Points | Test 2 Points | Progress
[NAME] | 2a | 2a |  | 17 | 17 | 0
[NAME] | 3b | 3a |  | 21 | 23 | 2
[NAME] | 2c | 3a |  | 13 | 23 | 10
[NAME] | 4b | 4a |  | 27 | 29 | 2
Spreadsheet: bddfd311-c6af-47e4-8ed8-17e4ef4803c2
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
40916897 | 2014-04-09 19:06:32 | ALLIES | 1 | 6 | 3 | 580159 | Devious | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
40917042 | 2014-04-09 19:23:35 | AXIS | 0 | 5 | 6 | 580159 | Devious | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
40918576 | 2014-04-09 21:15:46 | ALLIES | 1 | 6 | 3 | 198562 | Georgiev | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40918808 | 2014-04-09 21:37:23 | AXIS | 0 | 4 | 6 | 198562 | Georgiev | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
Spreadsheet: 744033d1628872220-find-the-first-x-or-the-first-o-when-another-cell-contains-the-same-value-example-4-
Sheet: Sheet1

Job | Sequence | Status
4579032L11 | 0 | C |  | 4579032L11
4579032L11 | 1 | S |  | 4526003LB5
4579032L11 | 2 | O |  | 4526003LB6
4579032L11 | 3 | O
4579032L11 | 4 | O
4579032L11 | 5 | O
4579032L11 | 6 | O
4579032L11 | 7 | O
4579032L11 | 8 | O
4579032L11 | 9 | O
4526003LB5 | 0 | C
4526003LB5 | 1 | C
4526003LB5 | 2 | C
4526003LB5 | 3 | C
4526003LB5 | 4 | C
4526003LB5 | 5 | C
4526003LB5 | 6 | S
4526003LB5 | 7 | O
4526003LB5 | 8 | O
4526003LB5 | 9 | O
4526003LB5 | 10 | O
4526003LB5 | 11 | O
4526003LB5 | 12 | O
4526003LB5 | 13 | O
4526003LB6 | 0 | C
4526003LB6 | 1 | C
4526003LB6 | 2 | O
4526003LB6 | 3 | O
4526003LB6 | 4 | O
4526003LB6 | 5 | O
4526003LB6 | 6 | O
4526003LB6 | 7 | O
4526003LB6 | 8 | O
4526003LB6 | 9 | O
4526003LB6 | 10 | O
4526003LB6 | 11 | O
4526003LB6 | 12 | O
4526003LB6 | 13 | O
Spreadsheet: darrell_schoolcraft__7622__imball0201
Sheet: Devon

 | Devon SFS Operating
 | POI 36289 - Bilbrey 28 Fed 1 C/P
Day | Measured | Scheduled
1 | 108 | 441
2 | 136 | 441
3 | 78 | 441
4 | 84 | 441
5 | 81 | 441
6 | 78 | 441
7 | 49 | 441
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 161290
2002-01-07 00:00:00
CBS Volume
 |  |  | 33970
Spreadsheet: 198440d1354778603-add-rows-from-one-sheet-to-another-row-in-another-sheet-if-first-rows-match-11
Sheet: Sheet1

Name | Surname | # | Status | Card type
Giorgi | [NAME] | 12 | Employee | [NAME]
Ana | Chubinize | 45 | Wife | [NAME]
Eter | Jafaridze | 22 | Daughter | [NAME]
Spreadsheet: 696947d1601046733-row-cut-and-paste-to-change-text-row-cut-and-paste
Sheet: Before macro

Category | JOB | Customer | Shipment Plan | [NAME] | Ship ment Bal.
0 Closed | HY-05562 | AARUSH (PH.5) LOGISTCS | 1.067 | 1.067 | 0
0 Closed | HY-05986 | VEGA CONVEYORS | 5.4 | 5.4 | 0
0 Closed Total
1 Cleared for Shipment | HY-05925 | MIND SPACE | 17.527 | 13.62 | 3.906999999999998
1 Cleared for Shipment | HY-05979 | GS PEB & CIVIL WORKS | 404.378 | 343.282 | 61.096
1 Cleared for Shipment | HY-05985 | HERMES DISTILLERY | 55.82599999999999 | 30.491 | 25.33499999999999
1 Cleared for Shipment | HY-05986 | VEGA CONVEYORS | 11.761 | 11.096 | 0.6650000000000009
1 Cleared for Shipment | HY-06009 | SABURI CONSTRUCTION | 0.6 | 0.5 | 0.09999999999999998
1 Cleared for Shipment Total
4 To be Cleared | HY-05925 | MIND SPACE | 20.887 | 0 | 20.887
4 To be Cleared | HY-06005 | DR. REDDY’S LABS | 13.552 | 0 | 13.552
4 To be Cleared Total
Grand Total
Col. C to F are formulas, where the data will pull from different sheets based on the data in col.B & A. Category totals are sum formulas.
Status of the job keep changing from "4 To be cleared" to "1 Cleared for Shipment" and "0 Closed". Whenever the status changes, we cut the row shift to the respective category.
Need a mechanism that whenever we cut and insert to other category, the category name also to be changed
ex: Presently Row12 category is "4 To Be Changed". If we cut Row 12 and insert between 9 and 10, it should be changed to "1 Cleared for Shipment"
ex: after shifting Row 12, Shipment plan in "4 To Be Cleared" category will become 13 from 34. and 21 will be added to 490.
Spreadsheet: 749778d1633001869-sum-the-cells-till-sub-total-cell-appears-subtotal
Sheet: Sheet1

10 | 286.85
55 | 417.35
6 | 253.95
Subtotal |  |  | answer
18 | 7365.15
11 | 6050.65
3.25 | 9793.75
11 | 804.25
2 | 4827.4
65 | 1063.45
80 | 181
Subtotal |  |  | answer
45 | 234.9
45 | 90.8
90 | 53.25
50 | 62.25
25.5 | 408.25
8.2 | 2455.1
71 | 4484.65
200 | 93.05
Subtotal |  |  | answer
10.2 | 3008.8
Subtotal |  | 30690 | answer
3 | 668.95
2330 | 154.9
1200 | 142.3
80 | 144.6
22 | 928.5
35 | 935.6
94 | 163.65
30 | 319.75
Subtotal |  |  | answer
6 | 132
550 | 92.75
500 | 154.45
114 | 61.45
220 | 131.45
Subtotal |  |  | answer
550 | 16.35
500 | 20.85
9.6 | 941.95
16000 | 0.4
7 | 2007.1
1.6 | 1239.6
0.35 | 1698.45
Subtotal |  |  | answer
50 | 45.05
120 | 219.35
100 | 951
50 | 108.65
50 | 362.3
4 | 5540.55
5 | 2965.6
3 | 1023.05
Subtotal |  |  | answer
12 | 104.35
8 | 1411.15
15 | 1042.1
12 | 138.7
4 | 453.4
2 | 573.8
4 | 1604.1
Subtotal |  |  | answer
20 | 52.9
30 | 408.55
20 | 513.75
4 | 532.35
4 | 399.15
12 | 81.5
12 | 166.35
2000 | 9.7
Subtotal |  |  | answer
15 | 434.2
10 | 715.05
10 | 594.75
43 | 2453.55
55 | 811.15
25 | 466.3
40 | 564.8
Subtotal |  |  | answer
10 | 14275.75
190 | 474.15
20 | 104.6
350 | 6.65
225 | 13.35
20 | 117.75
15 | 333
15 | 510.5
40 | 323
312 | 605.05
25 | 609.5
30 | 479.5
20 | 691.35
80 | 88.15
12 | 1160.9
Subtotal |  |  | answer
25 | 911.35
15 | 1651.9
6 | 911.35
60 | 551.8
Subtotal |  |  | answer
Spreadsheet: 830091d1684697384-ipmt-function-failing-in-amortization-table-problem-ipmt-project-funding-loan-analysis
Sheet: 12 Mos

[NAME], 365 Day Year
 | Date | Payment | Interest | Principal | Balance
 | 2024-01-01 00:00:00
2 | 2024-02-01 00:00:00
3 | 2024-03-01 00:00:00
4 | 2024-04-01 00:00:00
5 | 2024-05-01 00:00:00
6 | 2024-06-01 00:00:00
7 | 2024-07-01 00:00:00
8 | 2024-08-01 00:00:00
9 | 2024-09-01 00:00:00
10 | 2024-10-01 00:00:00
11 | 2024-11-01 00:00:00
12 | 2024-12-01 00:00:00
 | Totals
 |  |  |  |  | To record monthly payment on funding note for Project XXXXX
Spreadsheet: 113a16d3-2d0d-4aa5-96d5-4ee83b5c8638
Sheet: Walmart Acceptance Criteria

Walmart Acceptance Criteria for the
Produce GAPs Harmonized Food Safety Standard Post-harvest Operations
In addition to the USDA acceptance criteria, growers utilizing this audit to meet Walmart audit requirements must meet the following additional criteria, which are listed as major elements within the Global Markets Program for Primary Production Basic or Intermediate Level Assessment.
Audit Element (s) | Criteria
1.3.1 | Raw Material Sourcing
1.4.1 | Documentation & Recordkeeping
1.5.1 | Worker Training
1.9.1 | Self Audits
1.10.2 | Ag Chemicals, Biocides, Plant Protection Products
1.11.1 | Water Use
1.11.3 | Water System Assessment
1.13.2 & 1.13.5 | Master Sanitation Schedule
1.14.1, 1.14.3 & 1.14.4 | Storage Areas
1.18.1 | Lubrication
1.21.1, 1.21.2 | Toilet Facilities
1.21.7 & 1.21.8 | Employee Hygienic Practices
1.24 | Pest & Animal Control (includes all 3 sub-questions)
2.3, 2.4 & 2.5 | Water Treatment Procedures
4.1.1 | Customer Specifications
4.1.2 | Risk Assessment of Packinghouse
4.1.3 | Critical Control Points, HACCP Plan
4.1.6, 4.1.7 & 4.1.8 | Record of Food Safety Non-conformances, Complaints, and Corrective Actions
Spreadsheet: 831742d1685862615-create-a-descending-number-series-example1
Sheet: Sheet1

 |  | Amount | 1500
 |  | Rows | 23
 |  | Start | 110 |  | 110
 |  | Step | 4.07 |  | 105.93
 |  |  |  |  | 101.86
 |  |  |  |  | 97.79000000000002
 |  |  |  |  | 93.72000000000003
 |  |  |  |  | 89.65000000000003
 |  |  |  |  | 85.58000000000004
 |  |  |  |  | 81.51000000000005
 |  |  |  |  | 77.44
 |  |  |  |  | 73.37
 |  |  |  |  | 69.3
 |  |  |  |  | 65.23
 |  |  |  |  | 61.16
 |  |  |  |  | 57.09
 |  |  |  |  | 53.02
 |  |  |  |  | 48.95
 |  |  |  |  | 44.88
 |  |  |  |  | 40.81
 |  |  |  |  | 36.74
 |  |  |  |  | 32.67
 |  |  |  |  | 28.6
 |  |  |  |  | 24.53
 |  |  |  |  | 20.46
 |  |  |  | Sum
Spreadsheet: vkaminski__40792__PnmaRegas021800
Sheet: BS

 |  |  | Calendar Year
Balance Sheet |  |  | Contract Year
Assets:
Cash and Cash Equivalents
Working Capital / Accounts Receivable |  |  | 0
Construction in Progress |  |  | 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
Property, Plant and Equipment
Cost |  |  | 0
Accumulated Depreciation |  |  | 0
Net PP&E
Total Assets
Liabilities:
Panama Deferred Tax Liability |  |  | 0
Long Term Debt |  |  | 0
Total Liabilities
Stockholder's Equity:
Capital Stock
Dividends |  |  | 0
[NAME] |  |  | 0
Total Stockholder's Equity
Total Liabilities and Stockholder's Equity
[NAME]
 |  |  | Calendar Year
Income Statement |  |  | Contract Year
Sales/Revenues |  |  | 0
Operating Expenses |  |  | 0
Other (Income)/Expenses |  |  | 0
Depreciation |  |  | 0
Interest Expense |  |  | 0
Withholding Tax on Interest |  |  | 0
License Tax |  |  | 0
Book Income Taxes |  |  | 0
Total Expenses
Net Income
 |  |  | Calendar Year
Statement of Cash Flows |  |  | Contract Year
Cash Flows from Operating Activities
Cash Received from Customers |  |  | 0
Cash Paid to Employees and Suppliers |  |  | 0
(Increase)/Decrease in Working Capital |  |  | 0
Interest Paid |  |  | 0
Withholding Tax on Interest |  |  | 0
License Tax |  |  | 0
Cash Income Taxes Paid |  |  | 0
Net Cash from Operating Activities
Cash Flows from Financing Activities:
Proceeds from Issuance of LTD |  |  | 0
Principal Payments on LTD |  |  | 0
Capital Contribution |  |  | 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
Construction in Progress |  |  | 0 |  | 0
Dividends Paid |  |  | 0
Net Cash Provided by Financing Activities
Net Increase in Cash and Cash Equivalants
Cash and Cash Equivalents at Beginning of Year |  |  | 0
Cash and Cash Equivalents at End of Year
Sources and Uses of Funds
Sources of Funds:
 | Cash Received from Customers
 | Proceeds from Issuance of LTD
 | Capital Contributions
 |  | Total Sources of Funds
Uses of Funds:
 | Cash Paid to Employees and Suppliers
 | Less: Income Taxes Paid
 | Interest Paid
 | Trapped Cash |  |  | 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
 | Principal Payments on LTD
 | Construction in Progress
 | Dividends Paid
 |  | Total Uses of Funds
Net Sources and Uses of Funds
Spreadsheet: 758759d1639055110-averaging-entries-per-day-by-date-excel_example
Sheet: Sheet1

ID | Start time | Completion time | Call Number
43 | 2021-12-06 09:00:03 | 2021-12-06 09:17:47 | 904 | 2021-12-06 00:00:00
44 | 2021-12-06 06:05:43 | 2021-12-06 10:37:33 | 935 | 2021-12-07 00:00:00
45 | 2021-12-06 09:39:49 | 2021-12-06 12:11:45 | 914 | 2021-12-08 00:00:00
46 | 2021-12-06 12:14:06 | 2021-12-06 12:15:18 | 947 | 2021-12-09 00:00:00
47 | 2021-12-06 12:15:22 | 2021-12-06 12:15:58 | 947 | 2021-12-10 00:00:00
48 | 2021-12-06 12:22:30 | 2021-12-06 12:23:18 | 904 | 2021-12-11 00:00:00
49 | 2021-12-06 10:37:38 | 2021-12-06 14:14:43 | 935 | 2021-12-12 00:00:00
50 | 2021-12-06 14:14:53 | 2021-12-06 15:33:54 | 935 | 2021-12-13 00:00:00
51 | 2021-12-06 15:39:35 | 2021-12-06 15:40:27 | 904
52 | 2021-12-06 15:56:19 | 2021-12-06 15:58:58 | 752
53 | 2021-12-06 15:59:01 | 2021-12-06 15:59:37 | 752
54 | 2021-12-06 15:59:39 | 2021-12-06 16:00:17 | 752
55 | 2021-12-06 16:09:10 | 2021-12-06 16:10:08 | 947
56 | 2021-12-06 16:43:24 | 2021-12-06 16:44:02 | 947
57 | 2021-12-06 15:34:02 | 2021-12-06 16:59:08 | 935
59 | 2021-12-07 08:37:27 | 2021-12-07 08:38:40 | 940
60 | 2021-12-07 10:12:46 | 2021-12-07 10:13:27 | 914
61 | 2021-12-07 11:01:50 | 2021-12-07 11:02:41 | 947
62 | 2021-12-07 11:02:46 | 2021-12-07 11:04:19 | 947
63 | 2021-12-07 11:28:43 | 2021-12-07 11:29:14 | 904
64 | 2021-12-07 11:29:18 | 2021-12-07 11:29:48 | 904
65 | 2021-12-07 11:29:50 | 2021-12-07 11:30:42 | 904
66 | 2021-12-07 11:31:06 | 2021-12-07 11:31:44 | 904
67 | 2021-12-07 11:31:54 | 2021-12-07 11:32:48 | 904
68 | 2021-12-07 11:59:12 | 2021-12-07 11:59:45 | 914
69 | 2021-12-07 07:02:32 | 2021-12-07 12:05:47 | 935
70 | 2021-12-07 15:24:06 | 2021-12-07 15:25:35 | 935
71 | 2021-12-07 15:44:09 | 2021-12-07 15:44:50 | 904
72 | 2021-12-07 15:54:22 | 2021-12-07 15:55:04 | 914
74 | 2021-12-07 15:26:41 | 2021-12-07 17:33:44 | 935
75 | 2021-12-07 22:38:13 | 2021-12-07 22:40:32 | 947
76 | 2021-12-07 22:40:36 | 2021-12-07 22:41:09 | 947
77 | 2021-12-08 05:57:16 | 2021-12-08 05:57:49 | 911
78 | 2021-12-08 05:57:58 | 2021-12-08 05:58:29 | 911
79 | 2021-12-08 05:58:30 | 2021-12-08 05:58:46 | 911
80 | 2021-12-08 05:58:48 | 2021-12-08 05:59:04 | 911
Spreadsheet: 122684d1317065405-formatting-issue-causing-printing-problems-truck-open-comp-mod-muscle
Sheet: Truck

 |  | Truck & Lightning
Car Number | 1st Session | 2nd Session | 3rd Session | Quickest Time | Dial In
Spreadsheet: 710337d1608851861-help-pulling-data-from-a-range-attendance-template
Sheet: April

Employee Absence Schedule
April | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 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 | CL | T | NCNS | Total Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 48302d1247542844-automatically-adjusting-cell-values-example
Sheet: Sheet1

 | Product 1
 | FOB
Shipment Quanitity |  | 500
Quote ex tax | USD | 5.69
Exchange Rate - Average
NZD cost
freight/insurance/cartage/fees
CIF
Marketing |  | 2.5
Direct Costs
Wholesale Margin | 45.36
Wholesale Price
Safety Margin | 0.1
Wholesale to distributor
Average Exchange Rate
Wholesale FX
Duty | 0.175
Landed costs |  | 0
Charity Donation |  | 1
DDP
Distributor | 0.2
Wholesale (via distributor)
Retail markups 100%(x2.0)
Sales Tax | 0.1
RRP |  | 64.95
Spreadsheet: 157505d1337771072-concatenating-text-values-example-sum-words-problem
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | One
 |  |  | One | Two | Three |  | One |  | Two
 | OPTION | 1 | s | e | s |  |  |  | Three
 |  | 2 | w | n | w
 |  | 3 | n | s | w
 |  | 4 | e | s | e
 |  | 5 | s | n | n
 |  | 6 | s | w | n
 |  | 7 | w | w | s
 |  | 8 | e | e | w
 |  |  |  |  |  |  |  | WANT to read
 | OPTION | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
Spreadsheet: 167363d1341961555-excel-2007-copying-editing-conditional-sum-formulas-check-register
Sheet: PAYROLL

Deaniko & Pals, Inc. |  | Ombrovich & Assoc.
DBA Buddy & Pals |  | [NAME]
6/4 - 6/17 |  | Office: 764-3949
Pay Date:    6/19 |  | Fax: [PHONE]
Employee Name | Start Date | 2.13 | 8 | Salary | Credi Card Tips | Non-exempt hrs
Brazil, Rachel |  | 35.4 |  |  | 371.33
[NAME], [NAME] |  | 30.45 |  |  | 232.91
Holoboski, [NAME] |  | 35.18 |  |  | 194.61
[NAME], Ashton |  | 14.28 |  |  | 49
[NAME], [NAME] |  | 47.77 |  |  | 364.81
Pearson, [NAME] |  | 14.83 |  |  | 63.88
Shurr, Meagan |  | 43.6 |  |  | 358.16
Smolen, Tabitha |  | 21.65 |  |  | 282.27
[NAME], [NAME] |  | 61.17 |  |  | 574.94
Vasquez, Brittany |  | 28.28 |  |  | 202
Whitlock, Kiera |  | 12 |  |  | 41
[NAME] |  |  | 42.8
Moskovich, [NAME]
Collins, Cecil |  |  | 12
[NAME] |  |  |  | 1000 | 235.37
TOTALS
Total Hours
New Employee: |  |  |  | SS#
Name: | [NAME]
Address: | 11571 Lakewood St. CP |  |  | City,St,Zip | 46307
New Employee:
Name:
Address:
New Employee:
Name:
Address:
New Employee:
Name:
Address:
Spreadsheet: 62389d1263338131-pivot-table-refresh-budget2
Sheet: Sheet2

Year | (Show All)
Sum of Amt
Month | Account | Total
Jan | acct1 | 2066
 | acct2 | 489
 | acct3 | 200
Jan Total |  | 2755
Feb | acct2 | 3060
 | acct3 | 1000
Feb Total |  | 4060
Mar | acct1 | 143
 | acct3 | 50
[NAME] |  | 193
Apr | acct1 | 1054
 | acct2 | 9676
 | acct3 | 888
Apr Total |  | 11618
Grand Total |  | 18626
Acct | Year | Jan Budget | Feb Budget | [NAME] | Apr Budget
acct1 | 2010 | 111 | 211 | 311 | 411
acct2 | 2011 | 112 | 212 | 312 | 412
acct3 | 2012 | 113 | 213 | 313 | 413