tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 768797d1645123190-calculate-percentage-filled-per-day-appointments-filled-sample
Sheet: Sheet1

Appt Date: | Appt Time: | Appointment filled? (Yes=1 No=0) | Intials of Scheduler | # of patients attempted | [NAME] | fill rate per day
2022-01-27 00:00:00 | 13:30:00 | 1 | PAC
2022-01-27 00:00:00 | 11:00:00 | 1 | PAC
2022-01-27 00:00:00 | 08:30:00 | 0 | es
2022-01-27 00:00:00 | 11:30:00 | 0 | es
2022-01-27 00:00:00 | 08:00:00 | 0 | es
2022-01-27 00:00:00 | 15:00:00
2022-01-27 00:00:00 | 16:00:00
2022-01-28 00:00:00 | 07:40:00 | 0 | es
2022-01-28 00:00:00 | 08:00:00 | 0 | es
2022-01-28 00:00:00 | 08:40:00 | 1 | es
2022-01-28 00:00:00 | 10:00:00 | 1 | dr | 2
2022-01-28 00:00:00 | 11:30:00 | 1 | PAC
2022-01-28 00:00:00 | 15:30:00 | 0 | dr
2022-01-28 00:00:00 | 12:30:00 | 1 | kr | 1
2022-01-31 00:00:00 | 10:30:00
2022-01-31 00:00:00 | 11:20:00 | 0 | dr
2022-01-31 00:00:00 | 15:30:00 | 1 | kr
2022-01-31 00:00:00 | 16:00:00 | 0 | dr
2022-01-31 00:00:00 | 08:40:00 | 1 | mj
2022-02-01 00:00:00 | 14:10:00 | 1 | PAC
Spreadsheet: 454658d1459936553-subtract-from-a-fixed-value-subtractfrom500
Sheet: Sheet1

OR |  | Answer | 2nd Last | Last
 |  |  | 100 | 500
 |  |  | 200 | 500
 |  |  | 300 | 500
 |  |  | 1 | 500
 |  |  | 2 | 500
 |  |  | 3 | 500
 |  |  | 4 | 500
 |  |  | 5 | 500
 |  |  | 6 | 500
 |  |  | 7 | 500
 |  |  | 8 | 500
 |  |  | 9 | 500
 |  |  | 10 | 500
 |  |  | 11 | 500
 |  |  | 12 | 500
Spreadsheet: 182657d1348570818-if-formula-new-ta-report
Sheet: Summary

 | Live Transactions
 |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12
 | Lead Source | Association | January | January Live | Feburary | Feburary live | March | march Live |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total Leads | Total Live
 | PSP | 3R Telecom - T04
 |  | 3R Telecom[Non CTN] - T444
 |  | ABTA - T26
 |  | Accept Cards - T05
Spreadsheet: 772924d1647526447-if-and-to-return-cell-value-priority-3-
Sheet: Sheet1

 | Code | Category | Fault X | Fault Y | Fault Z | Repair Priority |  | Auto Generated Priority
 | HC2-D | Immediate Defect | 1 | 0 | 0 |  |  | P1
 | HC2-E | Immediate Defect | 1 | 0 | 0 |  |  | P1
 | HC2-D | Time Qual Defect | 0 | 2 | 0 |  |  | P2
 | HC2-E | Time Qual Defect | 0 | 1 | 0 |  |  | P3
 | HC2-N | Time Qual Defect | 0 | 1 | 0 |  |  | P3
 | HC2-NL | Time Qual Defect | 0 | 3 | 0 |  |  | P3
 | HC2-MQ | Time Qual Defect | 0 | 1 | 0 |  |  | P4
 | HC2-I | Time Qual Defect | 0 | 1 | 0 |  |  | P5
 | HC2-I | Time Qual Defect | 0 | 0 | 1 |  |  | P6
 | HC2-D | Time Qual Defect | 1 | 1 | 1
 | HC2-N | Immediate Defect | 1 | 0 | 0
 | HC2-E | Time Qual Defect | 1 | 3 | 0
Spreadsheet: 680512d1591066905-is-it-possible-to-use-imported-queries-in-normal-formula-bar-without-load-to-worksheet-ef-usageofimportedtable
Sheet: Sheet1

 | ITEM CODE | ITEM NAME |  | LOOKUP ITEM NAME BY ITEM CODE VIA FORMULA ???
 | MTRL-000002 | SEMEN PORTLAND |  | something like index(tblitem[name],match(b5,tblitem[code],0),1)
 | MTRL-000003 | PASIR BETON |  | so this yellow area will return data like in the column C
 | MTRL-000004 | KORAL BETON
 |  |  |  | Short story, we have more than 1 building construction project, so we'll make 1 workbook file for each project to make it easier to manage.
 |  |  |  | These projects workbook shares some same table that will served as the same MASTER data, example tabel [NAME] (tblItem)
 |  |  |  | The main idea we'll have to separate this table item into one MASTER data workbook to make its data CENTRALIZED
 |  |  |  | So every project workbook will look to this master data and could update automatically its table value if there's an update to this master data source table  (imported/connected).
 |  |  |  | I've searched for solution, and the closest one to my wish is by IMPORTED QUERIES
 |  |  |  | But this solution require these imported table to LOAD to worksheet and define that load as a local named range table BEFORE we could use in formula bar
 |  |  |  | Which is redundant and it'll have the possibility to broke the centralized data because this loaded queries table could be update locally
 |  |  |  | One thing that comes first in my mind, how could we use this queries WITHOUT even load to worksheet?
 |  |  |  | Like just type in the formula bar something like : index(tblitem[name],match(b5,tblitem[code],0),1) if we want to pull Item Name based by Item Code
 |  |  |  | Which is tblItem refers to this UNLOADED imported query tblItem
 |  |  |  | Or if you have another better solution that could fulfilled my requirement maybe you would kindly share to me.
 |  |  |  | Thank you for your attention
Spreadsheet: d4088125-d319-4877-b2b3-39f25654f48d
Sheet: MultipleMarksClassifications

MCCC# | MCCC title
23008 | Field Studies--NonSpecific Subject Area
23009 | Seminar/Project--Nonspecific Subject Area
23205 | Language Arts/Social Studies Combination--Support Services (special education)
23320 | Integrated Program--Support Services (special education)
23321 | Individualized Program--Support Services (special education)
23329 | Particular Program--Support Services (special education)
23396 | Seminar/Project--Support Services (special education)
23397 | Independent Study--Support Services (special education)
23480 | ESL Seminar/Project (English as a Second Language)
23481 | ESL Independent Study (English as a Second Language)
23995 | Homebound
23997 | Nonspecific Subject Areas--Independent Study
Spreadsheet: 847907d1698752122-bulk-substitute-in-a-spilling-array-cannot-split-v2
Sheet: Feuil1

 |  |  |  | spilling array |  |  |  | substitue table |  |  | expected result (spilling array) |  |  | spilling array with bulk substitute
ID:aze|Size:32|Label:rty |  |  |  |  |  |  |  | from | to |  | ID:aze|Size:32|Label:rty
ID:aze|Dim:32|Label2:rty |  |  |  | ID:aze|Dim:32|Label2:rty |  |  |  | Label2 | Label |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label:rty |  |  |  | ID:aze|Size:32|Label:rty |  |  |  | Label3 | Label |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label3:rty |  |  |  | ID:aze|Size:32|Label3:rty |  |  |  | Dim | Size |  | ID:aze|Size:32|Label:rty
ID:aze|Weight:32|Label:rty |  |  |  | ID:aze|Weight:32|Label:rty |  |  |  | Weight | Size |  | ID:aze|Size:32|Label:rty
 |  |  |  |  |  |  | split (via substituted range O2#) - works |  |  |  | split (via substituted array) - does NOT work
 |  |  |  |  |  |  | ID | Size | Label |  | ID | Size | Label
Spreadsheet: 720905d1614355499-conditional-formatting-a-row-or-rows-based-on-state-of-row-s-above-it-taskganttworking
Sheet: Sheet1

State | Feature | [NAME] | Effort | Burn Up | Effort Left | Start | End |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I have MANUALLY colored the Rows to show what I would like to do dynamically
 | TEAM MEMBER NAME |  |  |  |  |  |  | 2021-02-25 00:00:00
In Progress | Parent 1 |  | 2.25 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parent States are initially manually changed to "Commited" and then if Burn Up > 0 the State changes to "In Progress"
Work Complete |  | Child 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The State of this Row changes to complete when Effort Left = 0
In Progress |  | Child 2 | 0.75 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The State of this Row is "In Progress" because the "Feature" Item above is "In Progress" and this Backlog Item has Burn Up > 0
Blocked |  | Child 3 | 0.5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The State of this Row is manually changed to "Blocked" by a drop down in the "State" column.
Commited |  | Child 4 | 0.25 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The following three Rows are in a "Commited" State because they are the Children of a Parent "In Progress" but the Burn Up of these items are = 0
Commited |  | Child 5 | 0.25 | 0
Commited |  | Child 6 | 0.25 | 0
Approved | Parent 2 |  | 0.25 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Feature Items are intially automatically in the "Approved" state when entered into the sheet
Approved |  | Child 1 | 0.25 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Child items following the "Approved" Feature are also in the "Approved" state
Approved |  | Child 2 | 0.25 | 0
Approved |  | Child 3 | 0.25 | 0
Spreadsheet: 869044d1715708831-how-to-get-a-summary-of-total-expenses-nuwara-eliya-project-expenses
Sheet: Total Expenses

Total Expenses
Date | Description | Amount
2024-05-08 00:00:00 | Fuel-Anuruddha
2024-05-08 00:00:00 | Fuel-Dinesh
2024-05-08 00:00:00 | Food
2024-05-08 00:00:00 | Legal Fees
2024-05-08 00:00:00 | Commission
2024-05-08 00:00:00 | Taxes
Spreadsheet: 689708d1596609820-if-function-exceeding-8000-character-limit-need-help-on-shorter-formula-au-and-nz-vendor-margin-analysis-fy20-ytd-test
Sheet: July NZ

Margin and Sales by Vendor - July 2020
Vendor | Sales | Margin $ | Margin %
NetApp | 1 | 1
FireEye | 1 | 1
Riverbed | 1 | 1
Palo Alto Networks | 1 | 1
Extreme Networks | 1 | 1
F5 | 1 | 1
Infoblox | 1 | 1
MobileIron | 1 | 1
Cylance | 1 | 1
Channel Services | 1 | 1
Cohesity | 1 | 1
Ribbon | 1 | 1
Avaya | 1 | 1
CS Vendors | 1 | 1
Grand Total
Spreadsheet: e4924fa0-8860-4a02-94f2-bcbd19ab6774
Sheet: WC - Operating EPS - H1

GAAP to Non-GAAP Reconciliation
Diluted Earnings per Share to Operating EPS
For the Six Months Ended June 30,
([NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  | % Growth
 | 2011 |  | As Reported (GAAP) |  | Integration Program Costs (1) |  | Acquisition-Related Costs (2) and Financing Fees (3) |  | U.S. Health Care Legislation Impact on Deferred Taxes |  | Operating (Non-GAAP) |  |  | As Reported EPS Growth (GAAP) |  | Operating EPS Growth (Non-GAAP)
 | Diluted EPS
 | -  Continuing operations |  | 1.01 |  | 0.13 |  | 0 |  | 0 |  | 1.14 |  |  | 0.443 |  | 0.036
 | -  Discontinued operations |  | 0
 | -  Net earnings attributable to Kraft Foods |  | 1.01
 | 2010
 | Diluted EPS
 | -  Continuing operations |  | 0.7 |  | 0.08 |  | 0.24 |  | 0.08 |  | 1.1
 | -  Discontinued operations |  | 0.97
 | -  Net earnings attributable to Kraft Foods |  | 1.67
(1) | Integration Program costs are defined as the costs associated with combining the Kraft Foods and Cadbury businesses, and are separate from those costs
 | associated with the acquisition.
(2) | Acquisition-related costs include transaction advisory fees, U.K. stamp taxes and the impact of the Cadbury inventory revaluation.
(3) | Acquisition-related financing fees include hedging and foreign currency impacts associated with the Cadbury acquisition and
 | other fees associated with the Cadbury bridge facility.
Spreadsheet: 7864031c-edd0-4d68-aa83-87c04c295f40
Sheet: General

GENERAL |  |  |  |  |  |  | 120455
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  |  | Approval Deadline |  | Reason
 | To increase appropriations
 | in the Police Grants Fund.
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor
 | To estimate revenues of $299,730 and appropriate |  |  |  | Programs,
 | same in the Police Grants Fund. |  |  |  | Departments, |  |  |  | Police Department
 |  |  |  |  | or Groups
 | This ordinance provides funds for overtime and to |  |  |  | Affected
 | partner with the University of Missouri-Kansas City
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | Police Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None known.
 |  |  |  |  |  |  | Basis of opposition
 | This ordinance applies to the Patrol Division Program
 | The U.S. Department of Justice has awarded a |  |  |  | Staff |  | x |  | For
 | grant to the Police Department to partner with |  |  |  | Recommendation
 | the University of Missouri-Kansas City. |  |  |  |  |  |  |  | Against
 | The grant provides for overtime and training
 | with the objective to impact and evaluate violence in |  |  |  |  |  | Reason Against
 | high crime areas through use of foot patrol.
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By |  |  | Board of Police Commissioners
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  | x | For |  |  |  | Against |  |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council |  |  |  | Do pass
 |  |  |  |  | Committee Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 | The grant is 100% federally funded.
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  |  |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue |  |  | The $299,730 increase in revenues and
 |  |  |  |  | Projections -- |  |  | charge outs offsets related expenditures
 |  |  |  |  | Including Indirect |  |  | of $299,730.
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact |  |  | The impact of this ordinance is neutral since the
 |  |  |  |  |  |  |  | increase in revenues equals the increase in
 |  |  |  |  |  |  |  | expenditures.
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
 | Is this ordinance good for the children?
 | Yes, because it helps protect public safety in
 | Kansas City.
 | How will this contribute to a sustainable Kansas City?
 | This grant has no environmental impact.
Applicable Dates:
Reviewed by:
Reference Numbers
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: Ammonia Liquor

Raw Material |  | Ammonia Liquor
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 703.85
2023-10-02 00:00:00 |  |  |  |  | 59
2023-10-03 00:00:00 |  |  |  |  | 59
2023-10-04 00:00:00 |  |  |  |  | 59
Total
Spreadsheet: 830714d1685043321-combine-data-from-2-tables-s666-pq-combine-data-from-2-tables
Sheet: Tabelle3

ID | Name | Text | Text1 |  | ID | Name | Text | Text1
test1.de | Hamburg | Testtext10 | 2000 |  | test1.de | Hamburg | Testtext10 | 2000
test1.de | Hamburg | Testtext10 | 3000 |  | test1.de | Hamburg | Testtext10 | 3000
test1.de | München | Testtest11 | 2000 |  | test1.de | München | Testtest11 | 2000
test1.de | München | Testtest11 | 3000 |  | test1.de | München | Testtest11 | 3000
test2.de | Stuttgart | Testtext12 | 2000 |  | test2.de | Stuttgart | Testtext12 | 2000
test2.de | Stuttgart | Testtext12 | 4000 |  | test2.de | Stuttgart | Testtext12 | 4000
test2.de | Stuttgart | Testtext12 | 6000 |  | test2.de | Stuttgart | Testtext12 | 6000
test2.de | Ulm | Testtext13 | 2000 |  | test2.de | Ulm | Testtext13 | 2000
test2.de | Ulm | Testtext13 | 4000 |  | test2.de | Ulm | Testtext13 | 4000
test2.de | Ulm | Testtext13 | 6000 |  | test2.de | Ulm | Testtext13 | 6000
test2.de | Augsburg | Testtext14 | 2000 |  | test2.de | Augsburg | Testtext14 | 2000
test2.de | Augsburg | Testtext14 | 4000 |  | test2.de | Augsburg | Testtext14 | 4000
test2.de | Augsburg | Testtext14 | 6000 |  | test2.de | Augsburg | Testtext14 | 6000
Spreadsheet: kate_symes__18091__Deal Correction 12-1
Sheet: Current Day

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2000-12-01 00:00:00 | 2000-12-01 00:00:00 | 2000-11-30 00:00:00 | LTCA | BB | Houston: KT | TFS | Entered two deals for yesterday | Broker did not notify trader | 471546/547 | Palo Verde | Cal-01 | On [NAME] | 25 | Buy 141/Sell 141.05 | Buy EPEM/Sell EES
 |  |  |  | BB Count
 | 2000-12-01 00:00:00 | 2000-12-01 00:00:00 | 2000-12-01 00:00:00 | STNW | DS | Houston:EM | Amerex | Price: from sell @ $285.05 and buy @ $285 to sell @ 280.05 and buy @ $280 |  | 471310/311 | COB | 2000-12-04 00:00:00 | On [NAME] | 25 | Buy 280/Sell 280.05 | Buy PWRX/Sell EES
 | 2000-12-01 00:00:00 | 2000-12-01 00:00:00 | 2000-12-01 00:00:00 | STNW | DS | Houston: KT | APB | Delivery Point: from Puget to PGET |  | 471315 | Mid-C | 2000-12-04 00:00:00 | On [NAME] | 25 | 285 | PGET
 |  |  |  | DS Count
 | 2000-12-01 00:00:00 | 2000-12-01 00:00:00 | 2000-12-01 00:00:00 | LTCA | BB | Houston:EM | Amerex | Term: from Cal-01 to Cal-02 |  | 471555/556 | NP-15 | Cal-02 | On peak | 25 | Buy 86.5/Sell 86.55 | [NAME]/Sell EES
 |  |  |  | BB Count
 | 2000-12-01 00:00:00 | 2000-12-01 00:00:00 | 2000-12-01 00:00:00 | STCA | JR | Houston:KT | APB | Time: from RTC to On [NAME] |  | 471946 | SP-15 | 2000-12-04 00:00:00 | On [NAME] | 25 | Index | Edison Mission
 |  |  |  | JR Count
 | 2000-12-01 00:00:00 | 2000-12-01 00:00:00 | 2000-12-01 00:00:00 | STSW | TA | Houston: KT | APB | Date: from 12/4 to 12/3 |  | 471588 | SP-15 | 2000-12-03 00:00:00 | On [NAME] | 25 | 185 | Reliant
 |  |  |  | TA Count
 | 2000-12-01 00:00:00 | 2000-12-01 00:00:00 | 12/4-12/31/00 | LTNW | LR | LR | N/A | Days: from On peak w/ Sun. & Hol. To On Peak Mon-Sat. | Mask in Deal Blotter | 1.471884 | Mid-C | BOM | On [NAME] | 10 | 250 | Avista
 |  |  |  | LR Count
 |  |  |  |  |  |  |  |  |  | 2.471891 | [NAME] | BOM | On [NAME] | 10 | 211.56 | Willamette Ind.
 |  |  |  |  |  |  |  |  |  | 3.471938 | Pacificorp | BOM | On [NAME] | 10 | transmission | PUD of Snohomish
 |  |  |  |  |  |  |  |  |  | 4.471943 | [NAME] | BOM | On [NAME] | 10 | transmission | Pacificorp
 |  |  |  | Grand Count
Spreadsheet: 882791d1731259502-transpose-data-into-multiple-columns-based-on-numbers-book-2
Sheet: Sheet1

1 | MEMBER ID: 1234
1 | Organization Name: ABC Corp
1 | Mobile Number: [PHONE]
1 | Representative Name: [NAME]
2 | MEMBER ID: 5678
2 | Organization Name: XYZ Ltd
2 | Mobile Number: [PHONE]
2 | Representative Name: [NAME]
3 | MEMBER ID: 59862
3 | Organization Name: HGTLtd
3 | Mobile Number: 1258932
4 | MEMBER ID: 1258
4 | Organization Name: LGB Corp
Spreadsheet: 150783d1334678992-combining-table-tab-information-startup-prl
Sheet: All

Project Name:
Project Team: |  |  | G.C. Super:
Project Manager:
Mechancial Engineer:
Controls Engineer:
Field Technician (TAB):
 |  |  |  |  | Problem-Resolution Log (PRL) Summary
Issue No. | Date Entered | Entered By: | Equipment or System | Description of Issue | Action By | Progress | Date Corrected | Corrected By: | Date Approved | Resolved by | [NAME] | Approved By:
1
Spreadsheet: 762066d1641384343-vlookup-for-two-different-conditions-rotational-stiffness
Sheet: Ecc. base plate_UC column

UC column | UC 152x152x30
UC base beam | UC 203x203x46
Rotational stiffness
 | UC 152x152x23 | UC 152x152x30 | UC 152x152x37 | UC 152x152x44 | UC 152x152x51 | UC 203x203x46 | UC 203x203x52 | UC 203x203x60 | UC 203x203x71 | UC 203x203x86 | UC 203x203x100 | UC 203x203x113 | UC 203x203x127 | UC 254x254x73 | UC 254x254x89 | UC 254x254x107 | UC 254x254x132 | UC 254x254x167 | UC 305x305x97 | UC 305x305x118 | UC 305x305x137 | UC 305x305x158 | UC 305x305x198 | UC 305x305x240 | UC 305x305x283
UC 152x152x23
UC 152x152x30 |  |  |  |  |  | 1.4
UC 152x152x37
UC 152x152x44
UC 152x152x51
UC 203x203x46
UC 203x203x52
UC 203x203x60
UC 203x203x71
UC 203x203x86
UC 203x203x100
UC 203x203x113
UC 203x203x127
UC 254x254x73
UC 254x254x89
UC 254x254x107
UC 254x254x132
UC 254x254x167
UC 305x305x97
UC 305x305x118
UC 305x305x137
UC 305x305x158
UC 305x305x198
UC 305x305x240
UC 305x305x283
Spreadsheet: 878904d1726228818-conditional-formatting-formula-conditional-formatting-formula
Sheet: Working & Testing

 | SIDE PLATE COSTING SCHEDULE |  |  |  |  |  |  |  | LABOUR MATRIX
 | JOB REF |  |  | DRG No |  |  |  |  |  |  | MACHINE WIDTH
 | MODEL |  |  | DATE | 2024-09-12 00:00:00 |  |  |  |  |  | 300 | 600 | 900 | 1200 | 1500 | 1800 | 2100 | 2400 | 2700 | 3000 |  | CF forula formachine length: =IF(AND($C$13<=MIN($K$9:$K$23),$K9=[NAME],IF(AND($C$13>=MAX($K$9:$K$23),$K9=MAX($K$9:$K$23)),TRUE,AND($C$13>=$K9,$C$13<$K10)))
 |  |  |  |  |  |  |  |  | MACHINE LENGTH | 1200 | 50 | 50 | 60 | 60 |  |  |  |  |  |  |  | CF formula for machine width: =IF(AND($D$13<=MIN($L$8:$U$8),L$8=MIN($L$8:$U$8)),TRUE,IF(AND($D$13>=MAX($L$8:$U$8),L$8=MAX($L$8:$U$8)),TRUE,AND($D$13>=L$8,$D$13<M$8)))
 |  |  |  |  |  |  |  |  |  | 1800 | 60 | 65 | 70 | 75 | 80 |  |  |  |  |  |  | CF formula for intersection: =AND(IF(AND($C$13<=MIN($K$9:$K$23),$K9=[NAME],IF(AND($C$13>=MAX($K$9:$K$23),$K9=MAX($K$9:$K$23)),TRUE,AND($C$13>=$K9,$C$13<$K10))),IF(AND($D$13<=MIN($L$8:$U$8),L$8=MIN($L$8:$U$8)),TRUE,IF(AND($D$13>=MAX($L$8:$U$8),L$8=MAX($L$8:$U$8)),TRUE,AND($D$13>=L$8,$D$13<M$8))))
 | SIDE PLATE SQUARE |  |  |  |  |  |  |  |  | 2400 | 65 | 70 | 75 | 80 | 80 | 80
 | CUT BY | L | H | THK | MASS | L/HRS |  |  |  | 2700 | 70 | 70 | 70 | 70 | 75 | 75 | 80
 | TRIDENT |  |  | 6 | 115.94934 | 70 |  |  |  | 3000 | 70 | 75 | 75 | 80 | 80 | 80 | 85
 | True |  | PER PAIR |  |  |  |  |  |  | 3300 | 75 | 75 | 80 | 80 | 80 | 85 | 85 | 90
 | SIDE PLATE |  | 0 | PER PAIR |  |  |  |  |  | 3600 | 75 | 80 | 80 | 80 | 90 | 90 | 90 | 100
 | REINFORCING PLATE |  | 0 |  |  |  |  |  |  | 4000 | 80 | 80 | 80 | 80 | 90 | 90 | 100 | 100 | 100
 | STIFFENERS |  | 0 |  |  |  |  |  |  | 4200 | 80 | 80 | 85 | 85 | 90 | 90 | 100 | 100 | 100
 | STRESS |  | 0 |  |  |  |  |  |  | 4500 | 90 | 90 | 90 | 90 | 90 | 90 | 100 | 100 | 100 | 100
 | PAINT |  | 0 |  |  |  |  |  |  | 4800 | 90 | 90 | 90 | 90 | 90 | 90 | 100 | 100 | 100 | 100
 |  |  |  |  |  |  |  |  |  | 5200 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 | LABOUR |  | 0 |  | PER EACH |  |  |  |  | 5800 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 | TOTAL COST PER PAIR |  | 0 | [NAME]/pr | 0 | [NAME] |  |  |  | 6100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 | TOTAL SELLING PER PAIR |  | 0 | 269.0024688 | 0 | 135 |  |  |  | 6400 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Spreadsheet: kimberly_watson__20555__imbalsumm0108
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -783122 | -801047 | -40000 | -40000
2 | -765413 | -746994 | -39998 | -40000
3 | -751586 | -748805 | -39999 | -40000
4 | -739284 | -742991 | -101
5 | -714787 | -734668
6 | -734353 | -750409 | -9877 | -10000
7 | -729199 | -722209 | -25859 | -25000
8 | -719904 | -715180 | -27002 | -25000
9 | -725690 | -722897 | -51038 | -50000
10 | -740803 | -742788 | -51972 | -50000
11 | -752259 | -753379 | -124
12 | -743592 | -743981 | -51599 | -50000
13 | -722904 | -722201 | -20107 | -20000
14 | -711618 | -701605
15 | -679140 | -681609
16 | -674938 | -699370 | -25872 | -25000
17 | -694068 | -664964 | -25122 | -25000
18 | -715015 | -718391 | -185
19 | -703637 | -699226 | -24990 | -25000
20 | -684261 | -661695 | -6703 | -5000
21 | -705505 | -692927 | -25793 | -25000
22 | -694670 | -697277 | -24997 | -25000
23 | -700984 | -681477 | -25002 | -25000
24 | -680977 | -683267 | -24997 | -25000
25 | -693830 | -704130 | -25000 | -25000
26 | -681818 | -696016 | -25002 | -25000
27 | -671056 | -666426 | -25000 | -25000
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  | 145102
2001-08-27 00:00:00
CBS Dollars
 |  |  | 448413.9
Spreadsheet: 762464d1641568060-increment-value-with-criteria-for-every-nth-duplicate-increment-value-with-criteria-for-every-nth-duplicate-ans
Sheet: Sheet1

Data | Year | Year to Increment (Desired Result) | FORMULA |  | # of duplicate before increment
A | 2021 | 2021 |  |  | 2
B | 2022 | 2022
C | 2023 | 2023
A | 2021 | 2021
A | 2021 | 2022
B | 2022 | 2022
B | 2022 | 2023
C | 2023 | 2023
C | 2023 | 2024
A | 2021 | 2022
B | 2022 | 2023
C | 2023 | 2024
A | 2021 | 2023
A | 2021 | 2023
B | 2022 | 2024
B | 2022 | 2024
C | 2023 | 2025
C | 2023 | 2025
A | 2021 | 2024
B | 2022 | 2025
C | 2023 | 2026