tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 844141d1695915771-workout-log-stats-not-calculate-the-full-week-blank-workouttracker
Sheet: BMR_Maint_Macro

 | ***Only Enter #'s where Font is Red*** |  |  |  |  |  |  |  |  |  | Activity Level: •1.2 = Sedentary (Little or no exercise and desk job) •1.3-1.4 = Lightly Active (Little daily activity & light exercise 1-3 days a week) [NAME] = Moderately Active (Moderately active daily life & Moderate exercise 3-5 days a week) •1.7-1.8 = Very Active (Physically demanding lifestyle & Hard exercise or sports 6-7 days a week) •1.9-2.0 = Extremely Active (Hard daily exercise or sports and physical job) •(note: these activity factors generally include your [NAME] (work) as well as your EXERCISE (gym/ sport) and a TEF of ~ 15% - which is an average mixed diet).
 | Conversion Chart: English to Metric
 | Weight: (lbs) | 175 |  |  |  | Weight: (kg)
 | Height: (inches) | 66 |  |  |  | Height: (cm)
 | Age: | 42 |  |  |  | Age:
 | Weight: (kg) | 79.37
 | Height: (cm) | 167
 | Age: | 40
 | Activity Level: | 1.2
 | Body Fat: | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculating Macronutrients:
 | Harris-Benedict Formula |  |  |  |  | Mifflin-St Jeor Formula
 | For Men: |  |  |  |  | For Men: |  |  |  |  | Katch-McArdle Formula |  |  |  | Enter [NAME]: |  | 2445
 | BMR = |  |  |  |  | BMR = |  |  |  |  | Not Gender Specific
 | Maintenance = |  |  |  |  | Maintenance = |  |  |  |  | BMR = |  |  |  | Macro [NAME]: (%)
 | For Women: |  |  |  |  | For Women: |  |  |  |  | Maintenance = |  |  |  | Fat: | 35
 | BMR = |  |  |  |  | BMR = |  |  |  |  |  |  |  |  | Carbs: | 20
 | Maintenance = |  |  |  |  | Maintenance = |  |  |  |  | Please Note: If you don't have a value entered for Body Fat, these calculations will be innacurate. |  |  |  | Protein: | 45
 | Schofield Formula |  |  |  |  | Schofield Formula |  |  |  |  |  |  |  |  |  | Fat | Carb | Protein
 | For Men 18-29 yrs Old: |  |  |  |  | For Men 30-59 yrs Old: |  |  |  |  | [NAME]
 | BMR = |  |  |  |  | BMR = |  |  |  |  | Not Gender Specific |  |  |  | Calories
 | Maintenance = |  |  |  |  | Maintenance = |  |  |  |  | [NAME] =
 |  |  |  |  |  |  |  |  |  |  | Maintenance = |  |  |  | [NAME]
 | For Women 18-29 yrs Old: |  |  |  |  | For Women 30-59 yrs Old:
 | BMR = |  |  |  |  | BMR =
 | Maintenance = |  |  |  |  | Maintenance =
 | Bodybuilding.com Created by: Ketnar
Spreadsheet: 115365d1311005951-nesting-limit-sample
Sheet: Sun

JOB NUMBER |  | MPRN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB [NAME]? (YES OR NO) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SSE removed
EMERG18742 |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMERG18742
EMERG18746 |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMERG18746
EMERG18748 |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMERG18748
EMERG18745 |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMERG18745
EMERG18743 |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMERG18743
Spreadsheet: 141313d1329215525-search-common-values-with-different-physical-locations-ef40_example2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Currently displaying |  |  |  |  |  |  | What I would like to display
 |  | PO No | Supplier | Description | Qty | Delivery Date | Value | Qty Received | Complete Ship | Location |  |  |  |  | Accept/Reject |  | Location
 |  | 114081 | [NAME] | picoview | 9 | 2012-02-08 00:00:00 | 100 | 9 |  |  |  |  |  |  |  |  | [NAME]
 |  | 114256 | Edmundson Electrical | enclosures | 10 | 2012-02-10 00:00:00 | 500 | 10 |  |  |  |  |  |  |  |  | C2,C4
 |  | 114210
 |  | 114181
Spreadsheet: 818752d1677027012-how-to-display-the-contents-of-a-cell-based-on-three-criteria-make-more-efficient-excel-help
Sheet: Prior Month

Account # | Customer Name | CurrencyCode | Trans Date | Invoice | Comments
test 1 |  |  | 2023-01-01 00:00:00 | InvoiceTest1 | Excel help test 1
test 2 |  |  | 2023-10-15 00:00:00 | InvoiceTest4 | Excel help test 4
test 2 |  |  | 2023-10-15 00:00:00 | InvoiceTest2 | Excel help test 2
test 3 |  |  | 2023-12-11 00:00:00 | InvoiceTest3 | Excel help test 3
Spreadsheet: 762494d1641577433-dynamic-sort-function-for-data-entries-eh-ss-db_v3
Sheet: Calculations

PROJECTS
Month | Client Projects |  | SRM Lead | Month | Days Spent | Hours spent | Client Calls | SRM Lead | Month | Days Spent | Hours spent
January |  |  | [NAME] | January |  |  |  | [NAME] | January
February |  |  | [NAME] | February |  |  |  | [NAME] | February
March |  |  | [NAME] | March |  |  |  | [NAME] | March
April |  |  | [NAME] | April |  |  |  | [NAME] | April
May |  |  |  | May |  |  |  |  | May
June |  |  |  | June |  |  |  |  | June
July |  |  |  | July |  |  |  |  | July
August |  |  |  | August |  |  |  |  | August
September |  |  |  | September |  |  |  |  | September
October |  |  |  | October |  |  |  |  | October
November |  |  |  | November |  |  |  |  | November
December |  |  |  | December |  |  |  |  | December
PAT TICKETS
Month | Tickets
January | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
February | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
March | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
April | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
May | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
June | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
July | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
August | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
September | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
October
November
December
Client Information
Name
Hire Date
Location
Termination Date
Employment Type
Year
Base Salary
Bonus
Overtime
Commission
Total Compensation
Department
PTO Days
Sick Days
Performance Score
Spreadsheet: 884348d1733453264-blended-rate-tiered-commission-blended-rate-tiered-commission
Sheet: Sheet2

 |  |  |  |  | From | To | Realtor
 |  |  |  |  | 0 | 2000000 | 0.5 |  | This is the sales tier/split
 |  |  |  |  | 2000000.01 | 3000000 | 0.6 |  | As YTD sales grow, the % is split changes
 |  |  |  |  | 3000000.01 | 5000000 | 0.7
 |  |  |  |  | 5000000.01 | 10000000 | 0.8 |  |  |  |  |  | Q: shouldn't the fixed charge of $250 be split accordingly also?
 |  |  |  |  | 10000000 | 100000000 | 0.9
 |  |  |  |  | Client Name | Location | [NAME] OR Buyer | Quarter | Sales Price | YTD Sales | Commission | GCI | Fixed | 0.06 | 0.1 | Comission Check |  | FORMULA?
 |  |  |  |  | Sale 1 |  |  |  | 1200000 |  | 0.025 |  | 250
 | I would like to show full sale price of These two at 1.1MM rather than split |  |  |  | Sale 2 |  |  |  | 800000 |  | 0.0275 |  |  |  |  |  |  |  | $800K (of Commission Check) is split at 50%, while the remaining $300K is split at 60%
 |  |  |  |  | Sale 2 |  |  |  | 300000 |  | 0.0275
 |  |  |  |  | Sale 3 |  |  |  | 1100000 |  | 0.0275 |  | 250
 |  |  |  |  | Sale 4 |  |  |  | 1800000 |  | 0.03 |  | 250 |  |  |  |  |  |  | Blended Rate
 |  |  |  |  | Sale 5 |  |  |  | 2900000 |  | 0.025 |  | 250
 |  |  |  |  | Sale 6 |  |  |  | 5000000 |  | 0.03 |  | 250
 |  |  |  |  | Sale 7 |  |  |  | 1000000 |  | 0.025 |  | 250
 |  |  |  |  | Sale 8 |  |  |  | 1800000 |  | 0.025 |  | 250
 |  |  |  |  | Sale 9 |  |  |  | 1250000 |  | 0.025 |  | 250
 |  |  |  |  | Sale 10 |  |  |  | 500000 |  | 0.025 |  | 250
Spreadsheet: daren_farmer__5907__SSGasLoss
Sheet: Sheet1

 |  | HPL - UNMETERED GAS LOSS &
 |  | GAS LOSS FOR CONSTRUCTION
 |  | SYSTEMS  427 - 699 / 753, 764, 765, 767
 |  |  |  | UNMETERED |  | CONSTRUCTION |  | WORK ORDER
 |  | METER | SYSTEM | MCF | MMBTU | MCF | MMBTU | NUMBER | EXPLANATION
 |  | 800 | 439 | 162 | 162
 |  | 801 | 445 | 14 | 14
 |  | 802 | 550 | 0 | 0
 |  | 803 | 447 | 9244 | 9244 |  |  |  | Maintenance.
 |  | 805 | 462 | 17000 | 17000 |  |  |  | A/S line equip. outage prevented gas from flowing into that line.  P/L pressure build up triggering relief valve.
 |  | 806 | 450 | 35 | 36
 |  | 808 | 458 | 0 | 0
 |  | 810 | 460 | 101 | 101
 |  | 812 | 550 | 1100 | 1134
 |  | 813 | 555 | 30 | 30
 |  | 814 | 561 | 0 | 0
 |  | 815 | 600 | 100 | 100
 |  | 816 | 766
 |  | 818 | 429 | 75 | 77
 |  | 819 | 441 | 112 | 130
 |  | 821 | 430 | 2 | 2
 |  | 822 | 517 | 0 | 0
 |  | 823 | 479 | 800 | 820 | 0 | 0
 |  | 824 | 485 | 800 | 845
 |  | 826 | 487 | 1000 | 1058
 |  | 827 | 490 | 3 | 3
 |  | 829 | 557 | 3 | 3
 |  | 830 | 550 | 240 | 240
 |  | 831 | 550 | 0 | 0
 |  | 839 | 649 | 9 | 9
 |  | 841 | 660 | 7 | 7
 |  | 842 | 670 | 42 | 43
 |  | 843 | 699
 |  | 845 | 766 | 0 | 0
 |  | 846 | 600 | 50 | 50
 |  | 846 | 601 | 0 | 0
 |  | 847 | 766 | 0 | 0
 |  | 857 | 429 | 124 | 127 | 0 | 0
 |  | 859 | 450 | 64 | 64
 |  | 860 | 550 | 20 | 20
 |  | 861 | 555 | 0 | 0
 |  | 866 | 600 | 0 | 0
 |  | 867 | 600 | 0 | 0
 |  | 868 | 479 | 153 | 158
 |  | 873 | 561 | 16 | 16
 |  | 877 | 765 | 18195 | 18195 |  |  |  | Regulator failure.
 |  | 888 | 427 | 79 | 81
 |  | 890 | 764 | 250 | 256
 |  | 892 | 764 | 70 | 72
 |  | 893 | 601 | 50 | 50
 |  | 894 | 757 | 950 | 950
 |  | 895 | 555 | 25 | 25
 |  | 2602 | 757
 |  | 1583 | 764
 | TOTAL VOLUME C/M
 | INSIDE FERC HSC 12/99 |  |  |  | 2.58
 |  | 800
 |  | 801 | 445
 |  | 803 | 447
 |  | 810 | 460
Spreadsheet: 89695d1289450943-lookup-issue-with-data-set-vlookupnth-usc1382-ef752807-sdg15
Sheet: Instructions

 |  | Sheet One |  |  |  |  | Sheet Two |  |  | Sheet Three
 |  | Name | Account # |  |  |  | Name | [NAME] |  | Name | [NAME]
 |  | [NAME] | 9010022722
 |  | [NAME] | 7110396401
 |  | [NAME] | 74238 |  |  |  | Account # |  |  | Account #
 |  | [NAME] | 54321 |  |  |  | 9010022722 | 9010022722 |  | 54321 | 54321
 |  | [NAME] | 9876 |  |  |  | 9010022722 | 7110396401 |  | 54321 | 9876
 |  |  |  |  |  |  | 9010022722 | 74238
 |  |  |  |  |  |  | MY RESULT | Desired Result
 |  | I am trying to take the Data set in Sheet One and then have separate sheets as in Sheet Two & Three that are based upon each name and organize the data by account number.  The issue I am having is my simple vlookup is producing the same result and trying to figure out the mising step in showing all relevant account numbers per Name.  The area highlighted in purple is my result while what is in blue is the result i am trying to achieve.  THANKS!
 |  | View First Unread
 |  | #1          Today, 10:25 PM
 |  | VlookupNth - usc1382 - EF752807 - SDG15.xls
 |  | Registered User   Join Date: 26 Oct 2010
 |  | Location: USA
 |  | MS Office Version:Excel 2003
 |  | Posts: 10
 |  | Lookup Issue with Data Set
 |  | http://www.excelforum.com/excel-general/752807-lookup-issue-with-data-set.html
 |  | I am trying to take the Data set in Sheet One that is comprised of Name & Account #
 |  | and then have separate sheets as in Sheet Two & Three
 |  | that are based upon each [NAME] and organize the data by account numbers.
 |  | The issue I am having is my simple vlookup is producing the same account number
 |  | and trying to figure out the mising step in showing all relevant account numbers per Name.
 |  | The area highlighted in purple is my result while what is in blue is the result i am trying to achieve.
 |  | Please see the attachment THANKS!
Spreadsheet: 837237d1689952848-calculating-percentage-values-in-a-subtotalled-table-sample-data-6-
Sheet: Before

Company | Account | Limit |  | Occurences | Percentage of total Limit
Company 1 | AXMP1576 |  |  | 1
Company 1 | AXMP1415 |  |  | 18
Company 1 | AXMP1759 |  |  | 1
Company 1 | AXMP1782 |  |  | 2
Company 1 | AXMP1752 |  |  | 1
Company 1 | AXMP1975 |  |  | 1
Company 1 | AXMP1440 |  |  | 2
Company 1 | AXMP1832 |  |  | 1
Company 1 | AXMP1811 |  |  | 2
Company 1 | AXMP1412 |  |  | 3
Company 1 | AXMP1976 |  |  | 1
Company 1 | AXMP1458 |  |  | 2
Company 1 | AXMP1413 |  |  | 1
Company 1 | AXMP1593 |  |  | 4
 |  | 82000
Company 2 | AXMP1041 |  |  | 2
Company 2 | AXMP1176 |  |  | 2
 |  | 10000
Company 3 | AXMP1839 |  |  | 1
Company 3 | AXMP1157 |  |  | 1
Company 3 | AXMP1836 |  |  | 1
 |  | 10000
Company 4 | AXMP1110 |  |  | 5
Company 4 | AXMP1301 |  |  | 9
Company 4 | AXMP1456 |  |  | 4
Company 4 | AXMP1715 |  |  | 1
Company 4 | AXMP1101 |  |  | 12
Company 4 | AXMP1977 |  |  | 1
Company 4 | AXMP1888 |  |  | 2
Company 4 | AXMP1978 |  |  | 1
Company 4 | AXMP1578 |  |  | 7
Company 4 | AXMP1205 |  |  | 1
Company 4 | AXMP1372 |  |  | 1
Company 4 | AXMP1979 |  |  | 1
Company 4 | AXMP1859 |  |  | 2
Company 4 | AXMP1980 |  |  | 1
Company 4 | AXMP1981 |  |  | 1
Company 4 | AXMP1748 |  |  | 1
Company 4 | AXMP1982 |  |  | 1
Company 4 | AXMP1849 |  |  | 2
Company 4 | AXMP1983 |  |  | 1
Company 4 | AXMP1771 |  |  | 1
Company 4 | AXMP1340 |  |  | 1
 |  | 43500
Spreadsheet: eric_saibi__9801__091901R
Sheet: Indian River 04

Owner Name | NRG Energy Incorporated
Station Name | Indian River Power Station
Unit Name | Indian River 04
NERC Region | MAAC
State | DE
Fuel Type | Coal
Capacity | 442 MW
Start Date | 2001-10-19 00:00:00
End Date | 2001-11-29 00:00:00
Prv. Start Date | 2001-11-02 00:00:00
Prv. End Date | 2001-12-13 00:00:00
Comments | [NAME] work
SIC | 4931
Plant ID | 1515051
Unit ID | 1008236
Outage ID | 17128
Spreadsheet: 219ef978-f865-4605-8fcb-3186f5294b2d
Sheet: Sheet1

 |  | Loss and Constraint Excess |  | Notes
 | Year ending 30 June | Received from clearing manager | Passed through to customers
 |  |  | (if not 100%)
 | 2002 | 85017000 | 84778000 | 3
 | 2003 | 69076000 | 69063000
 | 2004 | 55240000 |  | 3
 | 2005 | 58690000
 | 2006 | 88660000
 | 2007 | 45448000
 | 2008 | 133675000
 | 2009 | 169388000
 | 2010 | 82241000
 | 2011 | 75500000
 | Notes:
 | 1)      Source - (Annual) Supplement to NZ Gazette - Transpower NZ Ltd - Information for Disclosure
 | 2)      Data is for financial years ending 30 June
 | 3)      Where figures differs between current and following year report, the most recent figure (i.e. following year report) has been shown
 | 4)      Data is referred to as "AC loss rental rebates" up to the 2006 report, and "Electricity loss rental rebates" thereafter, though they are believed to both refer to the total loss and constraint excess
 | 5)      2012 report not available till late November
Spreadsheet: 720134d1614025086-excel-formula-spreadsheet-for-inter-company-cash-transfer-records-book8
Sheet: Sheet1

 | from | to | Amount |  |  | paying Company | receiving company | Balance
2021-02-01 00:00:00 | B | A | 50000
2021-02-02 00:00:00 | C | B | 20000
2021-02-03 00:00:00 | D | B | 10000
2021-02-04 00:00:00 | D | B | 50000
2021-02-05 00:00:00 | B | A | 40000
Spreadsheet: 765671d1643477302-index-match-formula-only-works-for-a-portion-of-columns-cocktail-cost-calculator_support
Sheet: LIST-Sup_Cat_UOM

SUPPLIER |  | CATEGORY |  | SUB-CATEGORY |  | UOM
SUPP A |  |  |  | RUM |  | ML
SUPP B |  |  |  | CORDIAL |  | CL
SUPP C |  |  |  |  |  | LTR
SUPP D |  |  |  |  |  | OZ
SUPP E |  |  |  | GIN |  | GR
SUPP F |  |  |  |  |  | KG
 |  |  |  |  |  | 6-Pack
 |  |  |  |  |  | 1 Piec/Pck
 |  |  |  | GARNISH |  | 24-Pack
 |  |  |  |  |  | 12-Pack
 |  |  |  | PUREE
 |  |  |  | MIXER
 |  |  |  | OTHER
 |  |  |  | BEER
 |  |  |  | JUICE
Spreadsheet: 881749d1729896717-fixing-this-high-jump-scoring-spreadsheet-highjump_competition_test_ranking
Sheet: Sheet2

Name / Hight> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Best | Tie Breaker | Ranking | Ranking |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Position | Position | Name | Best
[NAME] | o | o
Brooke | o | o
[NAME] | o | o
Danielle | o | o
Emily | o | o | xxx
[NAME] | o | o
[NAME] | o | o
[NAME] | o | o
Alexis | o | o
Jones | o | o
Smith | o | o
[NAME] | o | o
Black | o | o
Barshim | o | o
[NAME] | o | o
[NAME] | o | o
dgfdhgf | o | o | xxx
dfdfdfdfdf | o | O
Spreadsheet: 213463d1360531408-return-a-1st-2nd-or-3rd-from-row-of-numbers-golf_ranking-pcb-
Sheet: Sheet1

Score | Name
70 | [NAME]
99 | [NAME] |  |  |  | Place | Score | Name
100 | [NAME] |  |  |  | 1 | 99.999996 | [NAME] |  |  | [NAME]
60 | Nick |  |  |  | 2 | 99.999993 | [NAME]
100 | [NAME] |  |  |  | 3 | 98.999995 | [NAME]
Spreadsheet: 161843d1339651344-copy-paste-data-with-matching-criteria-from-different-sheet-for-help-form
Sheet: Issuance

Date | DOC REF | EQUPMENT ID | EQUPMENT TYPE | itemCode | Description | Unit | Qty
2012-06-01 00:00:00 | 50 | 73523 | BUS | 5262 | HIGH SPEED DIESEL | LTR | 100
2012-06-01 00:00:00 |  | 73171 | TRUCK | 5262 | HIGH SPEED DIESEL | LTR | 200
2012-06-02 00:00:00 |  | 73523 | BUSS | 5262 | HIGH SPEED DIESEL | LTR | 200
2012-06-02 00:00:00 |  | 73171 | TRUCK | 5262 | HIGH SPEED DIESEL | LTR | 150
Spreadsheet: 149792d1334143788-do-not-display-calculated-cell-value-time-format-in-timesheet-timesheet_ex
Sheet: pracovny_vykaz

 |  |  |  |  |  |  |  |  | Month begins |  |  | 2012-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | [42]
 | Day |  | Time In |  | Time out |  | Break |  | Total hrs [h]:mm | Hours [h]:mm |  | Overtime [h]:mm | Hols [h]:mm |  | § [h]:mm |  | Sick [h]:mm |  | Days off [h]:mm |  | Abs [h]:mm |  |  | hide (dont display)
 |  |  | 700 |  | 1530 |  | 30 |  |  | 800 |  |  |  |  | 30 |  | 700 |  | 800 |  |  |  |  | show
 |  |  | 700 |  | 1530 |  | 30 |  |  | 800 |  |  | 800 |  | 0 |  | 0 |  | 0
 |  |  | 700 |  | 1530 |  | 0 |  |  | 800 |  |  |  |  | 0 |  | 0 |  | 0
 |  |  | 700 |  | 1530 |  | 30 |  |  | 800 |  |  |  |  | 0 |  | 0 |  | 0
 |  |  | 700 |  | 1530 |  | 30 |  |  | 800 |  |  |  |  | 0 |  | 0 |  | 0 |  | 800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300
 |  |  | 700 |  | 1530 |  | 0 |  |  | 800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  | Total [h]:mm:
 |  |  |  |  |  |  |  |  | Total hrs:
 |  |  |  |  |  |  |  |  | Rounded hrs:
 |  |  |  |  | Total total:
Spreadsheet: 267292d1380036303-ranking-by-percentage-of-contribution-to-category-test-file2
Sheet: Sheet1

CATEGORY | UPC | UNITS SOLD | CONTRIBUTION TO CATEGORY | Cumlative Sales %
 |  |  | BY PERCENTAGE
RTE CEREAL | 1111111111 | 500 | 0.07668711656441718
RTE CEREAL | 2222222222 | 1500 | 0.2300613496932515
RTE CEREAL | 3333333333 | 2000 | 0.3067484662576687
RTE CEREAL | 4444444444 | 1000 | 0.1533742331288344
RTE CEREAL | 5555555555 | 50 | 0.007668711656441718
RTE CEREAL | 6666666666 | 20 | 0.003067484662576687
RTE CEREAL | 7777777777 | 900 | 0.1380368098159509
RTE CEREAL | 8888888888 | 350 | 0.05368098159509203
RTE CEREAL | 9999999999 | 200 | 0.03067484662576687
BAG CEREAL | 11111111110 | 560 | 0.1840894148586456
BAG CEREAL | 12222222221 | 230 | 0.07560815253122946
BAG CEREAL | 13333333332 | 235 | 0.07725180802103879
BAG CEREAL | 14444444443 | 125 | 0.0410913872452334
BAG CEREAL | 15555555554 | 16 | 0.005259697567389875
BAG CEREAL | 16666666665 | 877 | 0.2882971729125575
BAG CEREAL | 17777777776 | 999 | 0.3284023668639053
NATURAL CEREAL | 18888888887 | 10 | 0.01934235976789168
NATURAL CEREAL | 19999999998 | 15 | 0.02901353965183752
NATURAL CEREAL | 21111111109 | 140 | 0.2707930367504836
NATURAL CEREAL | 22222222220 | 144 | 0.2785299806576402
NATURAL CEREAL | 23333333331 | 160 | 0.3094777562862669
NATURAL CEREAL | 24444444442 | 25 | 0.0483558994197292
NATURAL CEREAL | 25555555553 | 23 | 0.04448742746615087
Spreadsheet: 846123d1697438677-excel-formula-with-multiple-conditions-downgrade-template
Sheet: Quote

 | Southern Queensland Steel Pty Ltd
 | ABN: 62 085 107 991
 | Head Office |  |  |  | Toowoomba Branch
 | 97 Coulson Street, [NAME] 4076 |  |  |  | 12 Carroll Street
 | PO Box 296, [NAME] 4300 |  |  |  | [NAME] 4350
 | Ph: 07 3271 9111 | Fax: 07 3271 9100 |  |  |  | Ph: 07 4529 9292 | Fax: 07 4529 9299
 | Web: www.sqsteel.com.au |  |  |  | [NAME]: [EMAIL]
QUOTATION: | 26082021 KEATINGS |  |  |  | DATE:
Invoice to: | Keating's Hardware |  |  |  | Deliver to: | Keating's Hardware
 | [NAME] |  |  |  |  | [NAME]
QUOTATION ONLY
ACCOUNT NO: | 96 | REFERENCE: | Downgrade |  | ATTENTION: | [NAME] |  |  | SALESPERSON: TRK
QTY | PRODUCT DESCRIPTION |  |  |  | LENGTH* | WEIGHT | UOM | RATE | AMOUNT (Ex GST) |  | QTY Approx | Type | Description | Finish | Approximate Length (mtr) | EDIT THIS COLUM (KG Per MTR) | DON'T EDIT THIS COLUMN (KG Per Length) | DON'T EDIT THIS COLUMN (KG Total)
 |  |  |  |  |  |  | Tonne | 1300 |  |  | 9 | RHS | 40X40X2.0 | BLK / PTD | 8000 | 2.31 | 18.48 | 167 | 2NDP |  | 0
 |  |  |  |  |  |  | Tonne | 1300 |  |  | 49 | RHS | 40x40x2.5 | BLK / PTD | 8000 | 2.82 | 22.56 | 1106 | 2NDP |  | 0
 |  |  |  |  |  |  | Tonne | 1300 |  |  | 37 | RHS | 65x35x3.0 | BLK / PTD | 8000 | 4.25 | 34 | 1258 | 2NDP |  | 0
 |  |  |  |  |  |  | Tonne | 1300 |  |  | 12 | RHS | 95x35x2.8 | BLK / PTD | 8000 | 5.5 | 44 | 528 | 2NDP |  | 0
 |  |  |  |  |  |  | Tonne | 1600 |  |  | 44 | CATTLE RAIL | 53x35x1.6 | GAL | 6100 | 1.84 | 11.224 | 494 | 2NDG |  | 0
 | Delivery |  |  |  |  |  |  |  | 100
*Overall length is approximate only. No returns or refunds for 2nd grade.*
 | Delivery is $120+g.s.t. (not calculated in this quote).
 |  |  |  |  |  |  |  |  |  |  |  |  | Delivery
*Overall length is approximate only. No returns or refunds for 2nd grade.*
 | Bank Details:
 | Account Name: Southern Queensland Steel Pty Ltd
 | BSB: 332-020
 | Account No. 554409318 - Reference: |  | 21160
 | PLEASE REFER TO THIS QUOTE WHEN PLACING AN ORDER.
 |  |  |  |  |  |  | Total Weight:
Quote is valid for 7 days - Materials subject to prior sale / availability. Prices quoted are subject to increases. |  |  |  |  |  |  | NETT Total
 |  |  |  |  |  |  | Delivery |  | 100
Unless previously agreed in writing by the Company, no goods will supplied by the Company, on any terms or |  |  |  |  |  |  | GST
conditions other than those set out in the General Terms & Conditions of Sale, and by taking delivery of goods,
the Customer will be deemed to agree to be bound by the General Terms & Conditions of Sale. |  |  |  |  |  |  | Statutory Rounding
A copy of our General Terms & Conditions of Sale are available on our website or upon request. |  |  |  |  |  |  | Invoice Total
 | Wacol |  | Toowoomba |  | Townsville |  | MacKay
 | 97 Coulson St |  | 12 Carroll Street |  | 646 Ingham Road |  | 40-44 Maggiolo Drive
 | [NAME] 4076 |  | [NAME] 4350 |  | Mt [NAME] 4814 |  | Paget QLD 4741
 | Ph: 07 3271 9111 |  | Ph: 07 4529 9292 |  | Ph: 07 4774 2527 |  | Ph: 07 4998 5831
 | Fax: 07 3271 9100 |  | Fax: 07 4529 9299 |  | Fax: 077 4774 2530 |  | Fax: 07 4998 5931
Spreadsheet: 849305d1699828534-how-to-copy-formulas-across-the-row-when-criteria-are-in-static-cells-sample-report-purchase-and-supplier-payments-_v3
Sheet: Purchase Forecast 

 |  |  | Purchase Budget
 |  | Month of Purchase |  |  |  |  |  |  |  |  | Procurement period |  |  | Item | Forecast Month
 |  | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 60 | 30 | 0 |  | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00
 |  |  |  |  |  |  | ??? | ??? | ??? | ???? | 0.25 | 0.5 | 0.25 | Stock & Purchase - PT A | 300000 | 250000 | 150000 | 300000 | 450000 | 250000
 |  |  |  |  |  |  | ???? | ???? | ???? | ??? | 0.2 | 0.6 | 0.2 | Stock & Purchase - PT B | 250000 | 100000 | 150000 | 75000 | 100000 | 125000