tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 82813d1282830114-multiplying-a-cell-number-by-a-user-input-number-food-nutrients-counter-02
Sheet: Carbohydrate Foods

 | Food Nutrients Counter |  |  | * Protein marked in red is where protein comes from plant  sources and should not be counted towards daily protein intake.
Carbohydrate Foods | Protein | Carbs | Fats | Calories | Description
Porridge Oats | 11 | 60 | 8 | 356 | 100g
[NAME] |  |  |  | 0 | 100g
[NAME] |  |  |  | 0 | 100g
Scottish Oatcakes | 10 | 55 | 20 | 440 | 100g (approx. a packet)
Scottish Oatcakes | 1 | 6 | 2 | 46 | Each
 |  |  |  | 0 | 100g burger
 |  |  |  | 0 | medium
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Spreadsheet: 695398d1600189240-workday-formula-and-calendar-2021-s1-pacing_guide-test
Sheet: September

2020-09-01 00:00:00
Date
Daily Task |  | New Student Orientation
Graded Activities Assigned
Graded Activities Due
Comments |  | Comments: None | Comments: None | Comments: None | Comments: None
Date
Daily Task
Graded Activities Assigned
Graded Activities Due
Comments | Comments: None | Comments: None | Comments: None | Comments: None | Comments: None
Date
Daily Task
Graded Activities Assigned
Graded Activities Due
Comments | Comments: None | Comments: None | Comments: None | Comments: None | Comments: None
Date
Daily Task
Graded Activities Assigned
Graded Activities Due
Comments | Comments: None | Comments: None | Comments: None | Comments: None | Comments: None
Date
Daily Task
Graded Activities Assigned
Graded Activities Due
Spreadsheet: 889889d1740901110-identifying-the-patients-having-specific-combination-of-conditions-multiple-rows-sample_mw
Sheet: Sheet1

PID | DISEASE CODE | DESCRIPITON |  | Combined
1 | 51356 | Eczema |  |  | Eczema|Psoriasis|Fracture | 2 |  |  | Eczema|Psoriasis|Fracture | 2
1 | 51355 | Psoriasis |  | 2 | Fracture|Eczema|Psoriasis | 2 |  | 2 | Fracture|Eczema|Psoriasis | 2
1 | 51358 | Fracture |  |  | Fracture|Eczema|Psoriasis | 2 |  |  | Eczema|Psoriasis|Fracture | 2
2 | 51358 | Fracture |  |  | Fracture|Eczema|Psoriasis | 2 |  | 2 | Fracture|Eczema|Psoriasis | 2
2 | 51356 | Eczema |  |  | Eczema|Psoriasis | 2 |  |  | Eczema|Psoriasis|Fracture | 2
2 | 51355 | Psoriasis |  |  |  |  |  | 2 | Fracture|Eczema|Psoriasis | 2
3 | 51355 | Psoriasis |  |  | Eczema|Psoriasis|Fracture | 2 |  |  | Eczema|Psoriasis|Fracture | 2
3 | 51358 | Fracture |  | 2 | Fracture|Eczema|Psoriasis | 2 |  | 2 | Fracture|Eczema|Psoriasis | 2
4 | 51356 | Eczema
 |  |  |  | Row Labels | Disesease
 |  |  |  | 1 | Eczema, Psoriasis, Fracture
 |  |  |  | 2 | Fracture, Eczema, Psoriasis
 |  |  |  | 3 | Psoriasis, Fracture
 |  |  |  | 4 | Eczema
Spreadsheet: 843807d1695653127-creating-calendar-from-data-within-summary-page-of-workbook-rb-example
Sheet: 2

 |  |  |  |  |  | LODESTONE
 | [NAME]
 | PROJECT: |  | kitchen |  | PROJECT NO: | 555
 | DATE to CLAIM RETENTION: |  | 2024-09-18 00:00:00
 |  |  |  |  |  |  | Agreed Final Account | 200
 |  |  |  |  |  |  | Amount paid to date | 20
 |  |  |  |  |  |  | Retention held on LPLL
 | [NAME]
 | Agreed Final Account |  | Sub Contractor | Paid to Date | Retention owed to SC | %
 | 0 | 1 |  | 0
 | 0 | 2 |  | 0
 |  | 3 |  | 0
 |  | 4 |  | 0
 |  | 5 |  | 0
 |  | 6 |  | 0
 |  | 7 |  | 0
 |  | 8 |  | 0
 |  | 9 |  | 0
 |  | 10 |  | 0
 |  | 11 |  | 0
 |  | 12 |  | 0
 |  | 13 |  | 0
 |  | 14 |  | 0
 |  |  | Totals
 |  |  |  |  |  |  | Sub Total
 | Less Provisions etc. |  |  |  |  |  |  | 0
 | [NAME] to LPLL
Spreadsheet: 119243d1314282279-random-list-randomemployeesorter
Sheet: Sheet1

Employee | Random |  |  |  |  | Employee | [NAME] |  |  |  |  | Random 10 of 50 names
Name1 |  | <<Put a Rand() Col and sort by it. >> |  |  |  | Name14 | 0.01203898730004238 | <<Then take the top x of them >> |  |  |  | Name14 | << Here are Random 10 of 50 employees.
[NAME] |  |  |  |  |  | Name36 | 0.0853960226587509 |  |  |  |  | Name36
Name3 |  |  |  |  |  | Name46 | 0.09575072887397196 |  |  |  |  | Name46
Name4 |  |  |  |  |  | Name27 | 0.1285085600180608 |  |  |  |  | Name27
Name5 |  |  |  |  |  | Name28 | 0.1388771655468302 |  |  |  |  | Name28
Name6 |  |  |  |  |  | Name12 | 0.1902731963569713 |  |  |  |  | Name12
Name7 |  |  |  |  |  | Name22 | 0.2034974446115598 |  |  |  |  | Name22
Name8 |  |  |  |  |  | Name44 | 0.2161679547575083 |  |  |  |  | Name44
Name9 |  |  |  |  |  | Name3 | 0.2813183286784501 |  |  |  |  | Name3
Name10 |  |  |  |  |  | Name31 | 0.2875672114881491 |  |  |  |  | Name31
Name11 |  |  |  |  |  | Name21 | 0.2891695143997786
Name12 |  |  |  |  |  | Name30 | 0.3029961682000043
Name13 |  |  |  |  |  | Name25 | 0.3154532859673188
Name14 |  |  |  |  |  | Name18 | 0.3376214975340096
Name15 |  |  |  |  |  | Name41 | 0.3478102974360249
[NAME] |  |  |  |  |  | Name8 | 0.3568327329779551
Name17 |  |  |  |  |  | Name17 | 0.3767208293428764
Name18 |  |  |  |  |  | Name49 | 0.3797246038933809
Name19 |  |  |  |  |  | Name7 | 0.4000159671084006
[NAME] |  |  |  |  |  | Name1 | 0.4198813160643167
Name21 |  |  |  |  |  | [NAME] | 0.4232203804439916
Name22 |  |  |  |  |  | Name42 | 0.4542166383916354
Name23 |  |  |  |  |  | Name10 | 0.4964216119088174
Name24 |  |  |  |  |  | Name48 | 0.5417990391629367
Name25 |  |  |  |  |  | Name19 | 0.5666844715747
Name26 |  |  |  |  |  | Name50 | 0.5767651424195317
Name27 |  |  |  |  |  | [NAME] | 0.5976717306570202
Name28 |  |  |  |  |  | Name26 | 0.6034820988837584
Name29 |  |  |  |  |  | Name5 | 0.6376141236494617
Name30 |  |  |  |  |  | Name43 | 0.6427300802120912
Name31 |  |  |  |  |  | [NAME] | 0.6623908584086772
Name32 |  |  |  |  |  | Name35 | 0.6908841612795298
Name33 |  |  |  |  |  | Name38 | 0.7026454404330282
[NAME] |  |  |  |  |  | Name29 | 0.703276590107556
Name35 |  |  |  |  |  | Name4 | 0.7402964567016844
Name36 |  |  |  |  |  | [NAME] | 0.7408966140520586
Name37 |  |  |  |  |  | Name40 | 0.7434878131344018
Name38 |  |  |  |  |  | [NAME] | 0.7637490732993902
[NAME] |  |  |  |  |  | Name6 | 0.7853654997340693
Name40 |  |  |  |  |  | Name15 | 0.7949759648292839
Name41 |  |  |  |  |  | Name23 | 0.8215441235156231
Name42 |  |  |  |  |  | Name9 | 0.8526234762281535
Name43 |  |  |  |  |  | [NAME] | 0.8586634935463454
Name44 |  |  |  |  |  | Name45 | 0.8712148007270089
Name45 |  |  |  |  |  | Name13 | 0.8742528143458865
Name46 |  |  |  |  |  | Name37 | 0.8776804911203445
[NAME] |  |  |  |  |  | Name32 | 0.9082872071539345
Name48 |  |  |  |  |  | Name33 | 0.9126499267411565
Name49 |  |  |  |  |  | Name24 | 0.9220952121597338
Name50 |  |  |  |  |  | Name11 | 0.9611470093917013
Spreadsheet: 0040a1e8-5511-4079-a2a9-08c2c6515266
Sheet: Sheet1

Mathematical Science | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37 | Unnamed: 38 | Unnamed: 39 | Unnamed: 40 | Unnamed: 41 | Unnamed: 42 | Unnamed: 43 | Unnamed: 44 | Unnamed: 45 | Unnamed: 46 | Unnamed: 47 | Unnamed: 48 | Unnamed: 49 | Unnamed: 50 | Unnamed: 51
 | 1960 | 1961 | 1962 | 1963 | 1964 | 1965 | 1966 | 1967 | 1968 | 1969 | 1970 | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
Portiugal Bachelor Graduates |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 445 | 491 | 567 | 583 | 574 | 713 | 630 | 679 | 697 | 577 | 503 | 369 | 265 | 114
Portugal Masters Graduates |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63 | 76 | 85 | 73 | 60 | 76 | 93 | 82 | 105 | 116 | 120 | 68 | 65 | 40
Portugal PhD Graduates |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 10 | 11 | 8 | 25 | 16 | 20 | 28 | 30 | 32 | 52 | 47 | 36 | 36
Other Source - PhD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 23 | 25 | 26 | 26 | 28 | 23 | 23 | 30 | 33 | 50 | 38 | 43 | 56 | 62 | 61 | 81 | 66 | 60 | 65
Gabinete de Planeamento, Estratégia, Avaliação e Relações Internacionais
http://www.gpeari.mctes.pt/archive/doc/DoutConc_2008_Julho2009.xls
Spreadsheet: 144963d1331225173-how-to-count-duplicates-1-10-not-sum-dummy
Sheet: Sheet2

Key | Count
1
5
6
7
8
9
1
5
5
4
4
4
1
1
35
0
0
48
8
Spreadsheet: 328151d1403797500-need-help-proofing-my-formula-thanks-in-advance-carrothe
Sheet: Sheet1

 | Row | [NAME] | [NAME] sale in col | Model | [NAME]
a
b
c
d
e
Spreadsheet: jeffrey_a_shankman__13998__Exhibit 14 (Scenario 4)
Sheet: Rate Increase Model

 | CPUC Rate Proceeding |  |  |  |  |  |  |  | Exhibit 14 (Scenario 4)
 | SDG&E A. 01-01-044 |  |  |  |  |  |  |  | Revised with DWR Revenue Requirement
 |  |  |  |  |  |  |  |  | Update August 7, 2001
 | Billing Determinants
 | Original Filing Determinants (July-01 to June-02)
 | Sales (GWh) |  | URG | DWR |  | Total
 | Capped AB 265 Customers | 0.7 | 6987.209349386416 | 4772.273078870193 |  | 11759.48242825661
 | Capped ABX1 43 Customers | 0.3 | 0 | 5039.778183538547 |  | 5039.778183538547
 | Total Bundled Sales |  | 6987.209349386416 | 9812.05126240874 |  | 16799.26061179516
 | Update Determinants (October-01 to December-02)
 | Sales (GWh) |  | URG | DWR |  | Total
 | Capped AB 265 Customers | 0.7
 | Capped ABX1 43 Customers | 0.3 | 0
 | Total Bundled Sales
 | Commodity Revenue Requirement |  | ($000s)
 | DWR Rev. Requirement |  | 2068441 |  | <============ | DWR Revenue Requirements Update Letter August 7, 2001
 | SDG&E - URG |  | 670175.3136200698 |  | <============ | Retained Generation Costs Jul-01 to Dec-02
 | SDG&E Ancillary Charges |  | 213045.1524139957 |  | <============ | SDG&E Ancillary Charges Jul 01 to Dec 02
 | SDG&E Other ISO Charges |  | 73149.20836804548 |  | <============ | SDG&E ISO Charges Jul 01 to Dec 02
 | SDG&E Grid Mgmnt Charges (GMC) |  | 30621.4823457456 |  | <============ | SDG&E Grid Mgmnt Charges (GMC) Jul 01 to Dec 02
 | Total URG Revenue Requirement
 | Total Commodity Revenue Requirement
 | Bundled Revenues
 | Revenues at Current Commodity Rate
 | DWR Commodity Revenues @6.5 c/kWh
 | URG Commodity Revenues @ 6.5 c/kWh |  |  | 6.5
 | DWR Revenues Subject to Rate Increase
 | SDG&E Revenues Subject to Rate Increase
 | Total Rate Increase
 | Customer Revenue Allocation
 |  |  | System |  |  | ABX1 43 Customers |  | AB 265 Customers
 | DWR Revenue Requirement
 | Billed Revenues
 | DWR Revenues Subject to Rate Increase
 | [NAME] (GWh) Oct-01 to Dec-02
 | DWR Rate Increase (C/kWh)
 | CTC Rate (C/kWh) |  |  |  |  | -0.66 |  | 0
 | Net DWR Rate Increase (C/kWh)
Spreadsheet: 881075d1728993398-copy-and-paste-value-error-example
Sheet: Sheet1

Type | No. | Description | Quantity | UoM Name | Warehouse | Issue Method | Production Std Cost | Total Production Std Cost
Item | 1 | Example A | 900 | EA | 50-LX | Manual | 375.42
Item | 2 | Example B | 900 | ea | 50-LX | Manual | $ 5.5647
Item | 3 | Example C | 900 | ea | 50-LX | Manual | $ 6.0465 | $ 5,441.8500
Item | 4 | Example D | 20 | ea | 50-LX | Manual | $ 0.0836 | $ 1.6720
Item | 5 | Example E | 20 | ea | 50-LX | Manual | $ 0.6500 | $ 13.0000
Spreadsheet: 61516d1262389707-excel-2007-hours-calculation-example-hours2
Sheet: Monday

 | 2010-01-05 00:00:00
Name | Agency Supplier | Driver Type | Comments | Start Time | Finish Time | [NAME] | Paid Hours | O/T Hours
Jan | agency 1 | Pressure Van | None | 14:34:00 | 18:56:00
Piet | agency 3 | Pressure Van | None | 23:34:00 | 03:56:00
Jan | agency 2 | Pressure Van | None | 03:34:00 | 14:16:00
Jan | agency 2 | Pressure Van | None | 09:34:00 | 18:56:00
Piet | agency 3 | Pressure Van | None | 06:34:00 | 14:56:00
Kees | agency 5 | Pressure Van | None | 03:34:00 | 11:16:00
Jan | agency 3 | Pressure Van | None | 10:34:00 | 19:56:00
Spreadsheet: 180849d1347818399-picking-up-only-particular-numbers-workbook69
Sheet: Sheet1

1 | 0.3333333333333333 | 1 | 0.333
3 | 0.3 | 3 | 0.3
4 | 0.2833333333333333 | 4 | 0.283
5 | 0.3 | 5
9 | 0.3166666666666667
10 | 0.3166666666666667 | 10
17 | 0.3666666666666666
18 | 0.2833333333333333 | 18
20 | 0.2833333333333333 | 20
21 | 0.3 | 21
22 | 0.35
25 | 0.3166666666666667
26 | 0.2833333333333333 | 26
31 | 0.2833333333333333 | 31
32 | 0.3666666666666666
34 | 0.3 | 34
35 | 0.3166666666666667
43 | 0.3166666666666667
44 | 0.3333333333333333 | 44
49 | 0.3666666666666666
53 | 0.3333333333333333 | 53
54 | 0.35
55 | 0.3 | 55
56 | 0.2833333333333333 | 56
58 | 0.3166666666666667
61 | 0.2833333333333333 | 60
62 | 0.3166666666666667
64 | 0.2833333333333333 | 64
67 | 0.3333333333333333 | 67
68 | 0.3333333333333333 | 68
69 | 0.2833333333333333 | 69
73 | 0.3 | 73
75 | 0.2833333333333333 | 75
76 | 0.2833333333333333 | 76
77 | 0.2833333333333333 | 77
78 | 0.3 | 78
Spreadsheet: 221260d1363449008-sorting-a-filter-not-keeping-data-the-same-tattered
Sheet: Stats

Sire | Winners | Starters | % | Stakes | %
Dark Implications
Blood Red Sun
[NAME]
Trafalgar
Stockings
Coach Cal
Tracks in the Sand
[NAME]
Harmful
You Are Loud
Celebrating
[NAME]
Ark
Achieve
Mammoth
Feat
Accomplishment
Tribute to LeRoi
The Governor
Northern Hero
Untamed
[NAME]
Stars of Tomorrow
Spreadsheet: 218309d1362424827-lookup-a-value-and-display-all-data-multiple-rows-and-columns-fruits-3
Sheet: Lookup

 | Enter Fruit Type: |  | Apple
 | Colors | Purchased | Cost per 1/1/13 | Total | Purchased | Cost per 1/2/13 | Total | Purchased | Cost per 1/2/13 | Total
 | Green | 5 | 0.4 | 2 | 5 | 0.4 | 2 | 5 | 0.4 | 2
 | Yellow | 21 | 0.5 | 10.5 | 21 | 0.5 | 10.5 | 21 | 0.5 | 10.5
 | Red | 25 | 0.3 | 7.5 | 21 | 0.3 | 6.3 |  | 0.3 | 0
 | Blue |  | 0.36 | 0 | 21 | 0.36 | 7.56 | 6 | 0.36 | 2.16
 | [NAME] | 11 | 0.39 | 4.29 | 21 | 0.39 | 8.19 |  | 0.39 | 0
Spreadsheet: michelle_lokay__26631__imbalsumm0102
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 36840 | 37236
2 | 44709 | 44762
3 | 42744 | 42762 |  | 15000
4 | 42732 | 42762 |  | 15000
5 | 42708 | 42762 | 40 | 15000
6 | 48175 | 48262
7 | 33784 | 33736
8 | 44644 | 44762
9 | 44746 | 44762
10 | 44757 | 44762
11 | 44761 | 44762
12 | 44742 | 44762
13 | 44751 | 44762
14 | 44721 | 44762
15 | 54649 | 54762
16 | 54758 | 54762
17 | 55307 | 55337
18 | 55309 | 55337
19 | 55328 | 55337
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00
2001-02-19 00:00:00
Spreadsheet: 116835d1312214549-if-function-between-sheets-with-text-and-numbers-load-board
Sheet: HUG

Driver # | Book Date | Company | Load # | [NAME] | Fuel | [NAME] | Shared | PU Date | PU Time | City, State | Drop Date | Drop Time | City, State | Truck | Trailer #(s) | Percentage | BOLs | Location? | Billed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Received? | CH or ME or DM
HUG101 | 2011-08-02 00:00:00 | [NAME] | 102407050 |  | 354 |  |  | 2011-08-04 00:00:00 | 08:00:00 | Chanhassen, MN | 2011-08-06 00:00:00 | 09:00:00 | Elmhurst, IL | 3 | 843530
Spreadsheet: 876852d1723565769-pivot-table-second-column-sum-and-values-not-matching-work-progress-dated-12-aug-2024-bvj-
Sheet: Sheet1

ASSEMBLY MARK NUMBER | SL.NO | BUILDING REF. | PRIORITY | LEVEL | ASSEMBLY NAME | QTY | GROSS WEIGHT | DELIVERY | ERECTION | REMARKS | Delivery Weight | Erection Weight |  |  |  |  |  | Count of Delivery  Weight | Count of Install Weight
QLGF-C2001 | 1 | A | PRIORITY-1A | GF | COLUMN | 1 | 200.1 |  |  |  |  |  |  |  | Row Labels | Sum of QTY | Sum of GROSS WEIGHT | Count of Delivery Weight | Count of Erection Weight | Sum of Install Weight
QLGF-C2002 | 2 | A | PRIORITY-1A | GF | COLUMN | 2 | 512.6 |  | 2024-06-23 00:00:00 | Part assembly 1/2 |  |  |  |  | A
QLGF-C2002 | 3 | A | PRIORITY-1B | GF | COLUMN |  |  |  | 2024-06-24 00:00:00 | Part assembly 2/2 |  |  |  |  | PRIORITY-1A
QLGF-C2003 | 4 | A | PRIORITY-1B | GF | COLUMN | 1 | 205.6 |  |  |  |  |  |  |  | GF
QLGF-BM2003 | 5 | A | PRIORITY-1B | GF | FLOOR_BEAM | 1 | 181 |  |  |  |  |  |  |  | COLUMN | 3 | 712.7 | 2 | 2
QLGF-BM2004 | 6 | A | PRIORITY-2A | GF | FLOOR_BEAM |  |  |  |  | Part assembly 1/3 |  |  |  |  | PRIORITY-1B
QLGF-BM2004 | 7 | A | PRIORITY-2A | GF | FLOOR_BEAM |  |  |  |  | Part assembly 2/3 |  |  |  |  | GF
QLGF-BM2004 | 8 | A | PRIORITY-2A | GF | FLOOR_BEAM | 1 | 205.7 |  |  | Part assembly 3/3 |  |  |  |  | COLUMN | 3 | 205.6 | 2 | 2
QLGF-HB2005 | 9 | A | PRIORITY-2A | GF | HORIZONTAL BRACING | 1 | 203.6 |  |  |  |  |  |  |  | FLOOR_BEAM | 1 | 181 | 1 | 1
QLGF-HB2009 | 10 | A | PRIORITY-2A | GF | HORIZONTAL BRACING | 1 | 200.1 |  |  |  |  |  |  |  | PRIORITY-2A
QL-1-VB2001 | 11 | A | PRIORITY-2B | LEVEL-1 | VERTICAL BRACING | 1 | 906.1 |  |  |  |  |  |  |  | GF
QL-1-VB2002 | 12 | A | PRIORITY-2B | LEVEL-1 | VERTICAL BRACING | 1 | 1137.6 |  |  |  |  |  |  |  | FLOOR_BEAM | 3 | 205.7 | 3 | 3
QL-1-BM2002 | 13 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 |  |  |  | Part assembly 2/2 |  |  |  |  | HORIZONTAL BRACING | 2 | 403.7 | 2 | 2
QL-1-BM2002 | 14 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 673.6 |  |  | Part assembly 1/2 |  |  |  |  | PRIORITY-2B
QL-1-BM2003 | 15 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 525 |  |  |  |  |  |  |  | LEVEL-1
QL-1-BM2004 | 16 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 483.6 |  |  |  |  |  |  |  | VERTICAL BRACING | 2 | 2043.7 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRIORITY-2C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEVEL-1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLOOR_BEAM | 4 | 1682.2 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 18 | 5434.6 | 16 | 16
Spreadsheet: 92108d1291767907-summarizing-cost-data-from-list-by-unit-excel-example
Sheet: Sheet2

Equipment # | Line Cost | Cost Type
528248 | 6.9225 | Stock Part
528248 | 115.5732 | Internal Labor
531455 | 9.3708 | Internal Labor
531455 | 10.412 | Internal Labor
531455 | 39.045 | Internal Labor
531455 | 36.442 | Internal Labor
531455 | 58.3072 | Internal Labor
C11013 | 5.570084 | Stock Part
C11013 | 32.2772 | Internal Labor
C11013 | 51.0188 | Internal Labor
C11013 | 177.004 | Internal Labor
C11013 | 48.4025 | Stock Part
C11013 | 48.4025 | Stock Part
C11013 | 76.5282 | Internal Labor
C11013 | 23.427 | Internal Labor
C11013 | 27.5918 | Internal Labor
C11013 | 28.633 | Internal Labor
C11013 | 40.0862 | Internal Labor
C11014 | 27.5918 | Internal Labor
C11015 | 3.07 | Stock Part
C11015 | 6.588803 | Stock Part
C11015 | 161.386 | Internal Labor
C11015 | 10.638571 | Stock Part
C11015 | 78.09 | Internal Labor
C11015 | 14.0562 | Internal Labor
C11015 | 33.839 | Internal Labor
C12172 | 16.547632 | Stock Part
C12172 | 19.74 | Stock Part
C12172 | 7.601619 | Stock Part
C12172 | 244.61 | Stock Part
C12172 | 422.256 | Stock Part
C12172 | 28.633 | Internal Labor
C12172 | 29.6742 | Internal Labor
C12172 | 33.839 | Internal Labor
C12172 | 44.251 | Internal Labor
C12172 | 14.5768 | Internal Labor
C12172 | 44.251 | Internal Labor
C12172 | 131.1912 | Internal Labor
C12172 | 62.472 | Internal Labor
C12172 | 77.0488 | Internal Labor
C12172 | 99.9552 | Internal Labor
C12181 | 5.06 | Stock Part
C12181 | 74.4458 | Internal Labor
C12181 | 24.9888 | Internal Labor
C12182 | 6.96 | Stock Part
C12182 | 6.588803 | Stock Part
C12182 | 772.6 | Stock Part
C12182 | 57.266 | Internal Labor
C12182 | 123.3822 | Internal Labor
C12182 | 53.6218 | Internal Labor
C12182 | 58.3072 | Internal Labor
Spreadsheet: 1c0c7987-1437-4031-b588-e5569e50d612
Sheet: Petty Cash Declaration

 |  | UNIVERSITY OF SOUTHERN QUEENSLAND
 |  | CASH ON HAND DECLARATION AS AT 31 DECEMBER |  |  |  | Year
 |  |  |  |  |  |  | Version 1.3 |  | Instructions:
To be completed on the last working day in December and forwarded to |  |  |  |  |  |  | Mar 2012 |  | 1. Enter Dept name and Dept ID in cells D9 and D11 respectively
 |  | Manager (Financial Reporting & Analysis) - Financial & Business Services |  |  |  |  |  |  | 2. Place a cross in the type of float/s you maintain
 |  |  |  |  |  |  |  |  | 3. Enter the float amount that is approved to you (confimed by
 | DEPARTMENT NAME: |  | (enter Department name here) |  |  |  |  |  | email from the Manager, Financial Reporting) in cells [NAME], G20 and/or G27
 |  |  |  |  |  |  |  |  | 4. Itemise cash on hand in colum E - this should balance to the approved amount
 | DEPT ID: |  | (Dept ID here) | DATE: |  | 31/12/ | Year |  | There are check cells that will indicate a variance if one exists
 |  |  |  | On Hand |  | Approved
 |  | Petty Cash
 |  | Consisting of:
 |  | Cash on Hand
 |  | Vouchers to be Reimbursed
 |  | Cash Registers
 |  | Register 1
 |  | Register 2
 |  | Register 3
 |  | Change Float
 |  | Collections Not Banked
 |  | Other Cash Floats
 |  | Cashier
 |  | Relief Cashier
 |  | Emergency Loans
 |  | English Language Cultural Program
 |  | Tickets – Artsworx
 |  | [NAME] – Artsworx
 |  | Programs – Artsworx
 |  | TOTAL
I hereby certify that the above cash advances are in existence and that cash together with the authorised vouchers are held in accordance with the approved procedures.
 | Signature:
 | Responsible Officer: |  | (type details here)
 | Position: |  | (type details here)
Spreadsheet: 737795d1624611411-need-a-single-formulas-to-calculate-net-worth-overall-gain-and-couple-of-more-parameters-money
Sheet: Portfolio

 | This is how I made my transactions |  |  |  | Last trading price on 24 Jun | 119.7
 | Date | Price | Side | ShareQty
 | 2021-05-25 00:00:00 | 100.4 | BUY | 250 | My Networth (Latest Value) | 43331
 | 2021-05-31 00:00:00 | 92.5 | BUY | 54 | Quantity | 362.2
 | 2021-06-03 00:00:00 | 100.75 | SELL | -14 | Investments | 39868
 | 2021-06-07 00:00:00 | 126.9 | SELL | -38 | Today's Gain | -2263 | -0.0496
 | 2021-06-10 00:00:00 | 154.1 | SELL | -27 | Overall Gain | 3463 | 0.0869
 | 2021-06-14 00:00:00 | 140.9 | BUY | 40
 | 2021-06-16 00:00:00 | 127.25 | BUY | 40
 | 2021-06-18 00:00:00 | 114.9 | BUY | 40
 | 2021-06-22 00:00:00 | 126.6 | SELL | -18 |  |  |  |  | The report below is downloaded from the website
 | 2021-06-24 00:00:00 | 119.7 | BUY | 35
 |  |  | My Networth (Latest Value) |  |  |  |  |  | Stocks Bought
 |  |  | Quantity |  |  |  |  |  | PURCHASE |  |  |  | LATEST |  |  | Live Price | Change | Quantity | Latest Value | Inv. Price | Day's Gain | Overall Gain
 |  |  | Investments |  |  |  |  |  | Qty | Date | Price | Amount | Price | Value |  |  |  |  |  |  | % Change | % Change
 |  |  | Today's Gain |  |  |  |  |  | 153 | 25-05-2021 | 100.4 | 15361.2 | 119.7 | 18314 |  | 119.7 | -6.25 | 362 | 43331 | 110.13 | -2263 | 3464
 |  |  | Overall Gain |  |  |  |  |  | 54 | 31-05-2021 | 92.5 | 4995 | 119.7 | 6464 |  |  |  |  |  |  | -0.0496 | 0.0869
 |  |  |  |  |  |  |  |  | 40 | 14-06-2021 | 140.9 | 5636 | 119.7 | 4788 |  | Quantity | Inv. Price | Inv. Date | Inv. Amount | Day's Gain% | Overall Gain | Latest Value
 |  |  |  |  |  |  |  |  | 40 | 16-06-2021 | 127.25 | 5090 | 119.7 | 4788 |  | 35 | 119.7 | 24/06/2021 | 4190 | 219 (-4.96%) | 0 (0.00%) | 4190
 |  |  |  |  |  |  |  |  | 40 | 18-06-2021 | 114.9 | 4596 | 119.7 | 4788 |  | 40 | 114.9 | 18/06/2021 | 4596 | 250 (-4.96%) | 192 (4.18%) | 4788
 |  |  |  |  |  |  |  |  | 35 | 24-06-2021 | 119.7 | 4189.5 | 119.7 | 4190 |  | 40 | 127.25 | 16/06/2021 | 5090 | 250 (-4.96%) | -302 (-5.93%) | 4788
 |  |  |  |  |  |  |  |  | Stocks Sold |  |  |  |  |  |  | 40 | 140.9 | 14/06/2021 | 5636 | 250 (-4.96%) | -848 (-15.05%) | 4788
 |  |  |  |  |  |  |  |  | PURCHASE |  |  | SELL |  | PROFIT |  | 54 | 92.5 | 31/05/2021 | 4995 | 338 (-4.96%) | 1,469 (29.41%) | 6464
 |  |  |  |  |  |  |  |  | Date | Price | Qty | Date | Price |  |  | 153 | 100.4 | 25/05/2021 | 15361 | 956 (-4.96%) | 2,953 (19.22%) | 18314
 |  |  |  |  |  |  |  |  | 25-05-2021 | 100.4 | 14 | 2021-03-06 00:00:00 | 100.75 | 5
 |  |  |  |  |  |  |  |  | 25-05-2021 | 100.4 | 38 | 2021-07-06 00:00:00 | 126.9 | 1007
 |  |  |  |  |  |  |  |  | 25-05-2021 | 100.4 | 27 | 2021-10-06 00:00:00 | 154.1 | 1450
 |  |  |  |  |  |  |  |  | 25-05-2021 | 100.4 | 18 | 22/6/2021 | 126.6 | 472
 |  |  |  |  |  |  |  |  | Profit / Loss |  |  |  |  | 2933