tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 035c62c3-574c-4d01-a03f-fcfaf93e3fc2
Sheet: Sheet1

[NAME] University Monthly Overtime Sheet
 | SURNAME |  |  |  |  |  |  |  | PERSONNEL NO (SEE PAYSLIP)
 | FORENAME |  |  |  |  |  |  |  | MONTH
 | DEPARTMENT |  |  |  |  |  |  |  | WEEKLY CONTRACTED HOURS
 |  | 24 Hour Clock |  |  |  |  |  |  | Use Decimals
DATE OF THE MONTH | DAY | START TIME |  | FINISHING TIME |  | TIME TAKEN FOR LUNCH |  | TOTAL HOURS | HOURS AT SINGLE TIME | HOURS AT 1.5 X (TIME & HALF) | HOURS AT 2 X (DOUBLE) | ADDITIONAL INFORMATION
 |  | hrs | mins | hrs | mins | hrs | mins | When part of an hour has been worked use decimals e.g 7 1/4 is 7.25
example 17.09.07 | MONDAY | 9 | 30 | 16 | 30 | 1 | 30 |  | 5.5
 |  |  |  | TOTAL HOURS WORKED
 |  |  |  |  |  |  | E&D (Finance Use) |  | 1530 | 1535 | 1540
CLAIMANTS SIGNATURE |  |  |  |  |  |  |  | DATE |  |  | THIS CLAIM FORM HAS BEEN RETURNED BECAUSE:- |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 1. NO CLAIMANTS SIGNATURE
 |  |  |  |  |  |  |  |  |  |  | 2. NO AUTHORITY
AUTHORISATION:- |  |  |  |  |  |  |  | DATE |  |  | 3. NO COST CENTRE PROVIDED
 |  |  |  |  |  |  |  |  |  |  | 4. OTHER
I CONFIRM THAT I HAVE CHECKED THE TOTAL HOURS WORKED AND I AUTHORISE THAT PAYMENT BE MADE IN RESPECT OF THE TOTAL HOURS STATED |  |  |  |  |  |  |  |  |  |  | PLEASE ENSURE YOUR TIME SHEET IS RETURNED TO THE FINANCE DEPARTMENT FOR PROCESSING BEFORE THE PAYROLL DEADLINE
PRINT NAME |  |  |  |  |  |  |  |  | TOTAL HOURS WORKED
 |  |  |  |  |  |  |  |  |  |  | FINANCE USE
COST CENTRE |  |  | DETAIL CODE |  | 4116 |  | PROJECT CODE |  |  |  | INPUT BY & DATE
(4 digits) |  |  | (4 digits) |  |  |  | (if applicable) |  |  |  | CHECKED BY & DATE
Spreadsheet: 477402d1472274938-how-to-count-the-datas-from-multiple-range-procurement-initiatives_pmo-tracker_260816
Sheet: RM-Multiple suppliers

 | SKU | Suppliers | Spend (in Cr) | Price per Unit | Qty Procured | Spend at lowest cost procurement [NAME]) | Saving at lowest cost procurement
 | Benzophenone-4 |  | 0.3623320000000001 |  |  | 0.139535 | 0.2227970000000001
 |  | Galaxy Surfactants Ltd. | 0.17641 | 1357 | 1300
 |  | Qualikems Fine Chem Pvt Ltd | 0.002537 | 507.4000000000001 | 50
 |  | RP Global Ventures | 0.003926 | 1570.4 | 25
 |  | SALICYLATES & CHEMICALS P.LTD. | 0.135051 | 1286.2 | 1050
 |  | Standard Chemicals | 0.00299 | 1196 | 25
 |  | [NAME] | 0.041418 | 1380.6 | 300
 | Brij 721 |  | 0.323565234 |  |  | 0.323232 | 0.0003332339999999601
 |  | Atishay Specialities | 0.176046 | 577.2 | 3050
 |  | Connell Bros. Company (India) | 0.09545362200000002 | 578.5068 | 1650
 |  | [NAME] | 0.052065612 | 578.5068000000001 | 900
 | Brij-72 |  | 0.1313202852 |  |  | 0.1313195922 | 6.929999999683023e-07
 |  | Atishay Specialities | 0.075348 | 478.3999999999999 | 1575
 |  | Connell Bros. Company (India) | 0.04520838420000001 | 478.3956000000001 | 945
 |  | [NAME] | 0.010763901 | 478.3956000000001 | 225
 | Capric/Caprylic triglyceride ( |  | 0.10615876 |  |  | 0.09440944 | 0.01174931999999999
 |  | Galaxy Surfactants Ltd. | 0.0223964 | 344.56 | 650
 |  | RP Global Ventures | 0.03768336 | 380.64 | 990
 |  | Subhash Chemical Industries | 0.04607899999999999 | 418.8999999999999 | 1100
 | DC 245/SF 1202 |  | 0.1436128964 |  |  | 0.1280941792 | 0.01551871719999998
 |  | Ameya Perfomatt Private Ltd. | 0.02907402 | 253.7 | 1146
 |  | Confiance Life Sciences Pvt. | 0.1017265964 | 253.7 | 4009.72
 |  | Epstom Spec Chem Private | 0.01281228 | 223.6 | 573
 | Emulsifying Wax BP |  | 0.237435496 |  |  | 0.218013201 | 0.01942229499999998
 |  | Connell Bros. Company (India) | 0.111599621 | 226.5982152284264 | 4925
 |  | [NAME] | 0.037077075 | 197.7444 | 1875
 |  | Vikas Chemicals Agencies | 0.0887588 | 210.08 | 4225
 | [NAME] (Brij-35) |  | 0.0324908 |  |  | 0.0322848 | 0.0002059999999999979
 |  | Atishay Specialities | 0.020384 | 407.6799999999999 | 500
 |  | Connell Bros. Company (India) | 0.0060534 | 403.5600000000001 | 150
 |  | [NAME] | 0.0060534 | 403.5600000000001 | 150
 | Tween-20 |  | 0.07822559999999999 |  |  | 0.076837824 | 0.001387775999999993
 |  | Atishay Specialities | 0.04056000000000001 | 260 | 1560
 |  | Connell Bros. Company (India) | 0.03264352 | 251.104 | 1300
 |  | [NAME] | 0.00502208 | 251.104 | 200
 | Tween-80 |  | 0.05904672 |  |  | 0.05350799999999999 | 0.005538720000000018
 |  | Atishay Specialities | 0.0273 | 218.3999999999999 | 1250
 |  | Connell Bros. Company (India) | 0.02513282 | 264.5559999999999 | 950
 |  | [NAME] | 0.0066139 | 264.556 | 250
 | Total Saving
Spreadsheet: 144458d1330981728-how-can-i-get-the-left-function-to-stop-when-there-is-a-symbol-conversion-of-accounts
Sheet: Sheet1

System | Bank Id | Account/Obligor number | Obligation | Account Reference Number
cls | 21 | 123456 | 789
rel | 21 | 1234567
als | 21 | 89101112
cls | 21 | 123456-789
Spreadsheet: 86558d1286509667-solver-and-interger-programming-problem-33
Sheet: Answer Report 2

Microsoft Excel 12.0 Answer Report
Worksheet: [BIT HW4 #33.xlsx]Sheet1
Report Created: 10/7/2010 5:36:00 PM
Target Cell (Min)
 | Cell | Name | Original Value | Final Value
 | $B$20 | Total | 0 | 309
Adjustable Cells
 | Cell | Name | Original Value | Final Value
 | $B$17 | Selections | 0 | 1
 | $C$17 | Selections | 0 | 0
 | $D$17 | Selections | 0 | 0
 | $E$17 | Selections | 0 | 0
 | $F$17 | Selections | 0 | 0
 | $G$17 | Selections | 0 | 1
 | $H$17 | Selections | 0 | 0
 | $I$17 | Selections | 0 | 0
 | $J$17 | Selections | 0 | 0
 | $K$17 | Selections | 0 | 1
Constraints
 | Cell | Name | Cell Value | [NAME] | Status | Slack
 | $[NAME] | Sum | 1 | $L$6>=1 | Binding | 0
 | $[NAME] | Sum | 1 | $L$7>=1 | Binding | 0
 | $L$8 | Sum | 1 | $L$8>=1 | Binding | 0
 | $[NAME] | Sum | 2 | $L$9>=1 | Not Binding | 1
 | $L$10 | Sum | 1 | $L$10>=1 | Binding | 0
 | $L$11 | Sum | 1 | $[NAME] | Binding | 0
 | $L$12 | Sum | 1 | $L$12>=1 | Binding | 0
 | $L$13 | Sum | 2 | $L$13>=1 | Not Binding | 1
 | $L$14 | Sum | 2 | $L$14>=1 | Not Binding | 1
 | $L$15 | Sum | 1 | $L$15>=1 | Binding | 0
 | $B$17 | Selections | 1 | $B$17<=1 | Binding | 0
 | $C$17 | Selections | 0 | $C$17<=1 | Not Binding | 1
 | $D$17 | Selections | 0 | $D$17<=1 | Not Binding | 1
 | $E$17 | Selections | 0 | $E$17<=1 | Not Binding | 1
 | $F$17 | Selections | 0 | $F$17<=1 | Not Binding | 1
 | $G$17 | Selections | 1 | $G$17<=1 | Binding | 0
 | $H$17 | Selections | 0 | $H$17<=1 | Not Binding | 1
 | $I$17 | Selections | 0 | $I$17<=1 | Not Binding | 1
 | $J$17 | Selections | 0 | $J$17<=1 | Not Binding | 1
 | $K$17 | Selections | 1 | $K$17<=1 | Binding | 0
 | $B$17 | Selections | 1 | $B$17=integer | Binding | 0
 | $C$17 | Selections | 0 | $C$17=integer | Binding | 0
 | $D$17 | Selections | 0 | $D$17=integer | Binding | 0
 | $E$17 | Selections | 0 | $E$17=integer | Binding | 0
 | $F$17 | Selections | 0 | $F$17=integer | Binding | 0
 | $G$17 | Selections | 1 | $G$17=integer | Binding | 0
 | $H$17 | Selections | 0 | $H$17=integer | Binding | 0
 | $I$17 | Selections | 0 | $I$17=integer | Binding | 0
 | $J$17 | Selections | 0 | $J$17=integer | Binding | 0
 | $K$17 | Selections | 1 | $K$17=integer | Binding | 0
Spreadsheet: 59651d1260237735-league-spreadsheet-709588-league-spreadsheet
Sheet: Preview

Week | 2 |  | preview |  |  |  |  | data entry | enter week number in B1
[NAME] | 4 |  |  |  |  |  |  |  | set up pairing blocks for each pairing and enter the pairing number in the pink cell
number of pairings |  | 3 |  |  |  |  |  |  | all else is calculated.
team # | team name | rank in team | team members | Avg score | [NAME] | Handicap | VS | team # | team name | rank in team | team members | Avg score | [NAME] | Handicap
Pairing # | 1
1 | Blue | 1 | bill | 300 | 55 | 16 |  | 4 | green | 1 | gary | 280 | 45 | 0
 |  | 2 | bob | 296 | 50 | 40.8 |  |  |  | 2 | grendel | 245 | 23 | 0
 |  | 3 | [NAME] | 280 | 40 | 35.2 |  |  |  | 3 | greg | 236 | 22 | 0
Pairing # | 2
2 | red_team | 1 | ray | 300 | 50 | 8.8 |  | 5 | purple | 1 | [NAME] | 289 | 44 | 0
 |  | 2 | [NAME] | 268 | 24 | 0 |  |  |  | 2 | pete | 271 | 39 | 2.4
 |  | 3 | ron | 250 | 25 | 0 |  |  |  | 3 | [NAME] | 260 | 35 | 8
Pairing # | 3
3 | yellow | 1 | erin | 268 | 25 | 0 |  | 6 | orange | 1 | oliver | 300 | 55 | 25.6
 |  | 2 | [NAME] | 258 | 23 | 3.2 |  |  |  | 2 | bob | 254 | 20 | 0
 |  | 3 | elwood | 245 | 30 | 24.8 |  |  |  | 3 | [NAME] | 214 | 10 | 0
Standings
Blue | 3 |  | This sheet gives an overview of who plays vs who and what the handicaps are.
red | 0 |  | The Standings overview show the points collected per team up to the week selected above
yellow | 2
green | 0
purple | 2 |  | player's rank within the team is recaclulated every week
orange | 1 |  | players are sorted by rank here to match up teamA #1 vs teamB #1
 |  |  | ranking changes can be studied on the Teams sheet as the weeks progess
copy the other team |  |  | compare the blue team pecking order between week 2 and week 3 preview
names into this list |  |  | note that teams end up in different spots each week, because of the pairings ….
and copy the formula in
B30 down
Spreadsheet: 63813d1264682835-extract-two-columns-book1_jan27
Sheet: Sheet1

Column A | Column B
A | 1 | 1 | 8
B | 2 | 2
C | 3 | 3
D | 4 | 4
D | 5
E | 6 | 5
F | 7 | 6
F | 8
D | 9 | 7
G | 10 | 8
Spreadsheet: 051fdf3c-5cda-406d-988d-d7bc7ea5cfa2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Club Name |  |  |  |  | # |  |  | Total Members @ $45/$65 =
Contact: |  |  |  |  | Date of Roster: |  |  | Total Free Members =
MEMBERS | LAST NAME | FIRST NAME | MALE / FEMALE?    (M or F) | ADDRESS | CITY | ST | ZIP | E-MAIL | PHONE # | DOB | USRowing ID #(if applicable)
1
2
3
4
5
6
FREE
8
9
10
11
12
13
FREE
15
16
17
18
19
20
FREE
22
23
24
25
26
27
FREE
29
30
31
21
33
34
FREE
36
37
38
39
40
41
FREE
43
44
45
46
47
48
FREE
50
51
52
53
54
55
FREE
57
58
59
60
61
62
FREE
64
65
66
67
68
69
Spreadsheet: 866575d1713484987-not-transferring-employee-names-to-main-sheets-employee-absence-schedule
Sheet: May

 | Employee absence schedule
 | May
 | Absence type key | V | Vacation |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  | Dates of absence
 | 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 | Total days
 | [NAME]
 | [NAME]
 | Asaf Karten
 | [NAME]
 | [NAME]
Spreadsheet: 875239d1721824318-formula-to-calculate-values-based-on-criteria-example-1-
Sheet: Info

 | Item | Component | Component Task | Light Tower | Flag Pole | Comms Tower | [NAME] | WT M&T | [NAME] | [NAME] | Mono Poles | Sat Dish | [NAME] | Time (Mins)
 | 1 | Details | Conduct survey and check area | X | X | X | X | X | X | X | X | X | X | 20
 | 2 | Structure | [NAME] To Be Sound and Safe | X | X | X |  | X | X | X | X | X | X | 5
 | 3 | Structure | Check Fasteners | X | X | X | X | X | X | X | X | X | X | 5
 | 4 | Structure | Fasteners Secure | X | X | X | X |  | X | X | X | X | X | 3
 | 5 | Structure | Drainage Holes unblocked |  | X | X | X | X | X | X | X | X | X | 2
 | 6 | Structure | No Corrosion | X | X | X | X | X | X |  | X | X | X | 20
 | 7 | Structure | Base Plate Fasteners Secure | X | X | X | X | X | X | X | X | X | X | 2
 | 8 | Structure | Pivot Joint Fastener Present |  |  |  |  |  |  |  |  | X | X | 1
 | 9 | Structure | Cables And Fittings Are Secure And Free From Corrosion. | X | X | X | X |  | X | X | X | X | X | 3
 | 10 | Structure | Earth Wire Present | X |  | X | X | X | X | X | X | X |  | 2
 | 11 | Structure | Terminals Of The Earth Wire Secure | X |  | X | X | X | X | X | X | X | X | 5
 | 12 | [NAME] | Guy Cables Free From Sag |  |  | X | X |  | X |  |  |  | X | 10
 | 13 | [NAME] | Mast Concrete Pad Footing Free From Surface Soil and Debris | X | X | X |  |  | X | X |  | X | X | 10
 | 14 | Antenna Ropes | Ropes Are Free From Damage Or Deterioration |  |  |  |  |  |  |  |  |  |  | 5
Spreadsheet: 865943d1712901133-date-calculation-base-on-filed-maintaine-book1
Sheet: ESTERA

Sr. No. | Part | Unit | Name | Handed Over to account | Aging post handing over to accounts (Till  the file received back to CRM in case of any pendency) | RM | Accounts Executive | Remarks by Accounts (Mention pendency if any in details) | Due Amount | File return to CRM Date (Accounts to put this date) | Aging Post Handing over to CRM | Resent to accounts by CRM (To be updated by CRM) | Aging post handing over to accounts | Final Clerance date sent to Sunil | Cleared by [NAME] to Directors | Aging post handing over to Sunil | Cleared Signoff by Director | Aging post handing over to Director | Remarks by CRM
1 | E | 1402 | A | 2023-12-07 00:00:00 |  | Test | P 1 | File Cleared
2 | E | 503 | B | 2023-10-11 00:00:00 |  | Test | P2 | rework |  | 2024-04-12 00:00:00
 | E | 206 | Dileep kumar varma |  |  |  | SHYAM | File Cleared
Spreadsheet: 819156d1677249917-auto-calculation-formula-help-dawng1231-excel-forum-sample-ot
Sheet: Sheet1

DATA |  |  |  |  | This information will be hidden, as the President does not want anyone seeing this top level of info showing individual salary.  Is there a way to take the information in this first set of data to automatically populate down below by using a drop box solution?  More information below
Name | Salary | OT Hourly Rate | Effective
[NAME] |  |  | 2023-01-01 00:00:00
[NAME] | 50000 |  | 2023-01-01 00:00:00
[NAME] | 75000 |  | 2023-01-01 00:00:00
[NAME] | 87000 |  | 2023-01-01 00:00:00
[NAME] | 82000 |  | 2023-01-01 00:00:00
STANDARD | OVERNIGHT | 25 | 2023-01-01 00:00:00
DATA
Week Beginning | Name | OT Hours | OT Payment | # [NAME] | ON Amount | Total | Payout Date | Comments
2023-02-13 00:00:00 | [NAME] | 5 |  | 5 |  |  | [NAME] | [NAME]
2023-02-13 00:00:00 | [NAME]
2023-02-13 00:00:00 | [NAME]
Spreadsheet: 832975d1686711641-i-am-confused-why-equation-equaling-zero-is-sometimes-red-color-and-sometimes-black-color-cnfusing
Sheet: Sheet1

102.6 |  |  |  |  | 102.6
84.3 |  |  |  |  | 84
payments | credits | fees | total |  | payments | credits | fees | total
 | 186.9 | 0 |  |  |  | 186.6 | 0
payments | credits | fees | total |  | payments | credits | fees | total
186.9 | 186.9 | 0 |  |  | 186.6 | 186.6 | 0
Spreadsheet: 44046d1242724520-how-do-i-write-a-positive-negative-and-red-green-function-book11
Sheet: Sheet1

WOT05395 | P | 19000002 | #N/A | 0.75mm 3 core flex cable white (per 50m)
WOT05396 | P | 40000010 | #N/A | 013008trad 10.0mm x 1000mm drill bit
WOT05397 | P | 40000009 | #N/A | 025413trad 8.0mm x 600mm drill bit
WOT05398 | P | 42000006 | #N/A | 1/2 couplers (each)
WOT05399 | P | 42000004 | #N/A | 1/2 elbows (each)
[NAME] | P | 42000007 | #N/A | 1/2 end ferrules (without hole) per 100
[NAME] | P | 42000005 | #N/A | 1/2 tees (each)
WOT05402 | P | 80000024 | #N/A | 2.5m triple ladder
WOT05403 | P | 19000114 | #N/A | 2.5mm 6242y mains t+e cable grey (per 50m)
WOT05404 | P | 39000158 | #N/A | 2.5mm t&e flat cable clips grey (per 100)
WOT05405 | P | 55000756 | #N/A | 3.6v aa lithium battery for 714reur-00
WOT05406 | P | 44000049 | #N/A | 300w tungsten halogen bulb sthl300
WOT05407 | P | 905000041 | #N/A | 3e0691-1 firemans overide drop [NAME]
WOT05408 | P | 44000076 | #N/A | 500w tungsten halogen bulb
Spreadsheet: 268810d1380832724-sumproduct-formula-working-on-all-but-one-worksheet-2012-inpt-mb
Sheet: Jan

January |  |  |  |  |  |  | 1
Expenses | Total Expenses HTG | Total Expenses USD | Inpatient Total HTG | Inpatient Total USD | Outpatient Total HTG | Outpatient Total USD
bongu/juice
formula
patient food
medical supplies
medical services
medication
x-ray
office supplies
photocopy
other transportation
outpatient nurse for injections
employee compensation
school
other expenses
phone list
physical phone
telephone minutes
oxygen
volunteer expenses
patient transportation
Spreadsheet: 158520d1338292631-organizing-an-array-into-a-different-array-questionn
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | a | lskjd | 1.2
 | 1 | 2 | 3 | 4 | 5 |  |  |  | c | [NAME] | 2.4 |  |  | 1 | 2 | 3 | 4 | 5
a | jf | lskjd |  |  | xklvj |  |  |  | e | lskdjf | 4 |  | a
b | lkwkne | [NAME] |  |  |  |  |  |  | a | jf | 0.6 |  | b
c |  | xvlkcj | [NAME] | qrwklr | xkjv |  |  |  | b | [NAME] | 1.2 |  | c
d |  |  |  |  |  |  |  |  | c | xkjv | 4.1 |  | d
e | lvxczjk |  | nskl |  | lskdjf |  |  |  | g | do | 4 |  | e
f |  |  |  |  | werlmk |  |  |  | c | qrwklr | 3.2 |  | f
g |  | lj |  |  | do |  |  |  | e | nskl | 2.2 |  | g
 |  |  |  |  |  |  |  |  | a | xklvj | 4
What I want to do is to display the yellow array according to the green array. |  |  |  |  |  |  |  |  | b | lkwkne | 0.5
The organization is based on the number in column L and the letter in column J |  |  |  |  |  |  |  |  | c | xvlkcj | 1.5
In the green array, the letters from column K are displayed organized according to |  |  |  |  |  |  |  |  | f | werlmk | 4.3
the correct letter in column A and the correct number in row 2 |  |  |  |  |  |  |  |  | e | lvxczjk | 0.1
The numbers are organized as follows: If a number from column L is lower than the |  |  |  |  |  |  |  |  | g | lj | 1
number from row 2 it is organized in under the highest number of row 2
Sorry for the vague explanation
Spreadsheet: 860683d1708690726-needing-best-solution-for-a-cost-report-cr2022
Sheet: Check

10
Project WBS Element
20 |  |  |  | 54000
30 |  |  |  | 1665000
40 |  |  |  | 2317000
50 |  |  |  | 2682000
60 |  |  |  | 2452000
70 |  |  |  | 1450000
80 |  |  |  | 54000
90 |  |  |  | 4729000
100 |  |  |  | 1192000
Contingency
COB
 | 18760000
Spreadsheet: 51329d1250870256-data-validation-list-with-only-non-blank-cells-testform
Sheet: SALESMEN

[NAME] | Adams | [PHONE]
[NAME] | [NAME] | [PHONE]
Adam | Smith | [PHONE]
Spreadsheet: 856818d1706006137-adjust-issue-qty-so-that-computed-closing-should-match-with-physical-closing-xl-help
Sheet: Sheet1

 |  |  |  |  |  |  |  | DESIRED RESULT
TRAN TYPE | ITEM CODE | OPENING STOCK | RECEIPT QTY | ISSUE QTY | CLOSING STOCK |  |  | NEW ISSUE QTY | CLOSING STOCK | PHYSICAL CLOSING | DIFFRENCE
PURC | A | 12 | 10 | 2 |  |  | what I want: consider & adjust the already have issue qty(in column E) to (new issue qty in column I) to match the computed closing balance(in column J) with physical closing qty in column K, highlighted with light green colour
PURC | A |  | 20 | 4
PURC | A |  | 60 | 6
SALE | A |  | 0 | 8
PURC | A |  | 120 | 10
SALE | A |  | 0 | 12
TRFR | A |  | 0 | 14 |  |  |  |  |  | 100
PURC | B | 13 | 40 | 16
PURC | B |  | 50 | 18
PURC | B |  | 45 | 20
TRFR | B |  | 0 | 22
SALE | B |  | 0 | 24
PURC | B |  | 95 | 26
SALE | B |  | 0 | 28 |  |  |  |  |  | 120
PURC | C | 14 | 70 | 30
PURC | C |  | 80 | 32
PURC | C |  | 75 | 34
SALE | C |  | 0 | 36
PURC | C |  | 101 | 38
PURC | C |  | 123 | 40
SALE | C |  | 0 | 42
TRFR | C |  | 0 | 44 |  |  |  |  |  | 75
PURC | D | 15 | 100 | 46
PURC | D |  | 110 | 48
PURC | D |  | 101 | 50
SALE | D |  | 0 | 52
PURC | D |  | 211 | 54
SALE | D |  | 0 | 56
TRFR | D |  | 0 | 58 |  |  |  |  |  | 400
Spreadsheet: 082e93df-8abb-4d8b-843e-d35fd1083bfd
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6427.0 Producer Price Indexes, Australia
 | Table 30. Copper materials used in the manufacture of electrical equipment, index numbers and percentage changes
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Number ;  Industrial Electric Motors ; |  |  | Original | A2314268J | 1983-09-01 00:00:00 | 2002-06-01 00:00:00 | 76 | Index Numbers | INDEX | Quarter | 3
Percentage change from previous quarter ;  Industrial Electric Motors ; |  |  | Original | A2314269K | 1983-12-01 00:00:00 | 2002-06-01 00:00:00 | 75 | Percent | PERCENT | Quarter | 3
Percentage change from corresponding quarter of previous year ;  Industrial Electric Motors ; |  |  | Original | A2314270V | 1984-09-01 00:00:00 | 2002-06-01 00:00:00 | 72 | Percent | PERCENT | Quarter | 3
Index Number ;  Distribution Transformers ; |  |  | Original | A2314289V | 1983-09-01 00:00:00 | 2009-09-01 00:00:00 | 105 | Index Numbers | INDEX | Quarter | 3
Percentage change from previous quarter ;  Distribution Transformers ; |  |  | Original | A2314290C | 1983-12-01 00:00:00 | 2009-09-01 00:00:00 | 104 | Percent | PERCENT | Quarter | 3
Percentage change from corresponding quarter of previous year ;  Distribution Transformers ; |  |  | Original | A2314291F | 1984-09-01 00:00:00 | 2009-09-01 00:00:00 | 101 | Percent | PERCENT | Quarter | 3
Index Number ;  Power Transformers ; |  |  | Original | A2314301X | 1983-09-01 00:00:00 | 2009-09-01 00:00:00 | 105 | Index Numbers | INDEX | Quarter | 3
Percentage change from previous quarter ;  Power Transformers ; |  |  | Original | A2314302A | 1983-12-01 00:00:00 | 2009-09-01 00:00:00 | 104 | Percent | PERCENT | Quarter | 3
Percentage change from corresponding quarter of previous year ;  Power Transformers ; |  |  | Original | A2314303C | 1984-09-01 00:00:00 | 2009-09-01 00:00:00 | 101 | Percent | PERCENT | Quarter | 3
© Commonwealth of Australia  2009
Spreadsheet: 854779d1704537578-main-contributor-q1
Sheet: Sheet1

What I have: |  |  |  | What I want:
Department | Product | Profit |  | The total profit of all departments is 25.
A | AA | -5 |  | The profit of department A is 20 and the main contributing product is AC with a profit of 15.
A | AB | 10 |  | The profit of department B is 25 and the main contributing product is AD with a profit of 15.
A | AC | 15 |  | The profit of department C is negative 20 and the main contributing product is AB with a negative profit of 15.
A | AD | 0
 | sum A
B | AA | 5
B | AC | 5
B | AD | 15
 | sum B
C | AB | -15
C | AC | -10
C | AD | -5
C | AE | 10
 | sum C
Spreadsheet: 0e18ff09-7238-4990-8cdf-b2f9e458e294
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Iowa Menu Production Work Sheet | 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
Date |  |  |  |  |  | NEW Food Based Menu Planning--Breakfast |  |  |  |  |  |  |  |  |  |  | Meal Counts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grade Group | Planned | Actual
School
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K-5
Offer [NAME]? |  | Yes___No___ |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6-8
Grades: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9-12
Seconds/A la Carte? |  | Yes___No___ |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adult
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Menu |  |  | Serving Temperature | Component Contribution | Recipe No. or Brand & Product Code | Quantity Prep (# of servings, pounds, cans) | Grades: |  |  |  | Grades: |  |  | Grades: |  |  | Total
 |  |  |  |  |  |  | Serving Size |  | Planned Servings |  | Serving Size | Planned Servings |  | Serving Size | Planned Servings |  | Amount Prepared | Adult/ A la Carte Sold | Leftover/ comments
Grain/Bread: check (√) if whole grain rich
Fruit
Vegetables: DG, RO, BP, S, O--identify veg subgroup in Component column
Other including Meat substitution for grain
Milk
Spreadsheet: 599824d1543324569-transposing-data-foi-data-nhs-trusts-roles
Sheet: PIVOT

Row Labels | Average of What was the value of the contract?2 | Sum of What was the term of the contract?
Assure RCR | 21600
Clickview | 10000 | 12
Covalent | 3000 | 12
Datix | 26264.245 | 48
HealthAssure | #[NAME]! | 12
HealthAssure | 46099.5 | 108
InPhase | #[NAME]! | 36
InPhase | 130000
Internal | #[NAME]! | 36
Internal | #[NAME]!
Inview | 318750 | 36
Life Qi | #[NAME]!
Memebership Engagement Services | 45460
Meridian | #[NAME]!
Microsoft Office | #[NAME]!
Multiple | 47900 | 60
N/A | #[NAME]! | 360
N/A | #[NAME]!
Promatica | 57000 | 60
QPulse and Synbiotix | 40625 | 36
RiO | 2500000 | 12
Safeguard | 1000 | 12
SNAP | 1500 | 12
Ulysses | 4201.175
(blank) | 28476.835 | 24
Grand Total | 153032.2830434783 | 876