tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: d0a967a1-83e6-45e5-9a3a-332ad8bda37a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Discovery | Unnamed: 5 | Unnamed: 6 | Follow-up | Unnamed: 8 | Unnamed: 9 | Joint | Unnamed: 11 | Unnamed: 12
 |  |  |  | MEN | WOMEN | Sex-Diff | MEN | WOMEN | Sex-Diff | MEN | WOMEN | Sex-Diff
SNP | Traita | Sexa | Geneb | Pc | Pc | Pd | Pe | Pe | Pf | Pc | Pc | Pd
rs16970956 | HEIGHT | M | [NAME] | 1.24e-05 | 0.231 | 0.00869 | 0.00057 | 0.195 | 0.015 | 5.96e-08 | 0.139 | 0.00163
rs12887636 | BMI | W | PRKD1 | 0.174 | 2.27e-06 | 0.013 | 0.164 | 5.83e-05 | 0.03 | 0.102 | 2.09e-09 | 0.00368
rs6091540 | BMI | W | ZFP64 | 0.519 | 1.79e-09 | 7.33e-05 | 0.149 | 9.67e-05 | 0.043 | 0.229 | 9.87e-12 | 0.000171
rs1443512 | WHRadjBMI | W | HOXC13 | 0.184 | 1.43e-09 | 0.000636 | 0.027 | 9.95e-07 | 0.045 | 0.023 | 3.01e-14 | 0.00041
rs718314 | WHRadjBMI | W | ITPR2 / SSPN | 0.177 | 8.29e-10 | 0.000611 | 0.025 | 9e-07 | 0.044 | 0.019 | 1.36e-14 | 0.000362
rs4460442 | HEIGHT | W | [NAME] | 0.441 | 5.76e-07 | 0.00203 | 0.051 | 1.13e-05 | 0.051 | 0.092 | 8.29e-11 | 0.00178
rs6921207 | HEIGHT | W | EPB41L2 | 0.071 | 1.2e-06 | 0.031 | 0.221 | 0.00101 | 0.068 | 0.068 | 1.46e-08 | 0.015
rs4325879 | HEIGHT | W | CCNL1 | 0.088 | 1.58e-06 | 0.024 | 0.036 | 9.95e-06 | 0.064 | 0.014 | 1.14e-10 | 0.011
rs1316952 | WHRadjBMI | W | DNAH10 | 0.857 | 1.53e-07 | 0.000269 | 0.036 | 3.03e-06 | 0.057 | 0.182 | 5.13e-12 | 0.000223
rs1936805 | WHRadjBMI | W | RSPO3 / C6orf173 | 0.000446 | 9.1e-14 | 0.00525 | 2.97e-08 | 3.45e-17 | 0.065 | 3.74e-10 | 4.11e-29 | 0.00218
Footnotes:
a Trait and sex for which the SNP was selected;
b [NAME] labels state the nearest gene or the gene as published previously; a full list of genes at this locus are given in Figure S2.
c P-Value for sex-specific association.
d. P-value for difference between the two sexes.
e One-sided P-Value for sex-specific association.
f. One-sided P-value for difference between the two sexes.
Spreadsheet: 751352d1634058578-retrieving-multiple-lookup-results-using-string-retrieving-multiple-lookup-results-using-string
Sheet: Sheet1

Lookup Value | Retrieve Value |  |  |  | [NAME] |  | Expected Results |  |  |  |  |  |  | =IFERROR(INDEX($B$2:$B$4,MATCH("*",IF(ISNA(IF(SEARCH($F8,$A$2:$A$4)=1,MATCH($B$2:$B$4,$G8:G8,0))),$B$2:$B$4),0)),IF(COLUMNS($H$1:H$1)=1,"no results",""))
ABCDEF | SUNDAY |  |  |  | ABCD |  | SUNDAY | MONDAY
ABCFED | MONDAY |  |  |  | ZYXW |  | TUESDAY
ZYXW12345 | TUESDAY |  |  |  | 12345 |  | no results
 |  |  |  |  | [NAME] |  | Expected Results
 |  |  |  |  | ABC
 |  |  |  |  | ZYXW
 |  |  |  |  | 12345
Spreadsheet: 749895d1633085638-formula-to-calculate-nssa-deductions-on-due-date-nssa-due-dates
Sheet: Sheet1

Kindly asking for a formula to calculate NSSA deductions on due date.
How to calculate NSSA deductions
If any employee earn less the ceiling, multiply basic salary by 4.5%
If any employee earn more than the ceiling, multiply ceiling by 4.5%
Period | January | February | March | April | May | June | July | August | September | October | November | December
NSSA RATES | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045
Ceiling | 5000 | 6000 | 8000 | 8000 | 8500 | 9000 | 9500 | 10000 | 10500 | 11000 | 11500 | 11500
Pay due date | 2021-01-25 00:00:00 | 2021-02-25 00:00:00 | 2021-03-25 00:00:00 | 2021-04-25 00:00:00 | 2021-05-25 00:00:00 | 2021-06-25 00:00:00 | 2021-07-25 00:00:00 | 2021-08-25 00:00:00 | 2021-09-25 00:00:00 | 2021-10-25 00:00:00 | 2021-11-25 00:00:00 | 2021-12-25 00:00:00
Desired Outcome
NSSA Deductions
Name | Date | Period | Basic Salary | Amount Paid | Deductions
[NAME] | 2021-08-25 00:00:00 | August | 8000 | 8000
[NAME] | 2021-08-25 00:00:00 | August | 11000 | 11000
[NAME] | 2021-08-15 00:00:00 | August | 20000 | 10000
[NAME] | 2021-08-25 00:00:00 | August | 20000 | 10000 | 0
[NAME] | 2021-08-15 00:00:00 | August | 9000 | 4000
[NAME] | 2021-08-25 00:00:00 | August | 9000 | 5000 | 0
[NAME] | 2021-08-25 00:00:00 | August | 16000 | 9000
[NAME] | 2021-09-10 00:00:00 | August | 16000 | 7000 | 0
Note: [NAME] and [NAME] were partly paid in advance and on due date. [NAME] was partly paid on due date and in arrears on 10/9/21
Spreadsheet: 116674d1311975639-selective-columns-priors-hall
Sheet: Pc

Pennington. C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  | 14
 |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  | 10
 |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
 |  | 15
 |  | 7
 |  | 17
 |  | 13
 |  | 9
in
out
total
Spreadsheet: 754956d1636591795-applying-data-validation-to-check-box-activity-or-alternative-solution-multi-run-length-calculator-11-07-21-b
Sheet: Initial Calculation

Units |  |  | columns |  | Cut Lengths
 | Phase 1 Length
Spreadsheet: 130808d1322587908-extracting-numbers-from-tables-copy-of-excelforumquestion
Sheet: Sheet1

Date | In | Out | Hours
Monday 17th | 2:15a | 2:28a | 0.21 |  | 54.15
 | 4:52p | 1:56a | 9.07 |  | 64.76
Tuesday 18th | 2:22a | 2:54a | 0.53 |  | 56.82
 | 4:38p | 3:29a | 10.84
Wednesday 19th | 3:58a | 5:10a | 1.2
Thursday 20th | 5:54p | 3:23a | 9.47
Friday 21st | 3:55a | 6:29a | 2.57
Saturday 22nd | 5:43p | 5:20a | 11.12
Sunday 23rd | 5:42p | 3:20a | 9.14
Total hours clocked for dates 6/7 to 6/13: 54.15
Monday 24th | 6:32p | 9:20p | 2.81
 | 9:50p | 5:25a | 7.59
Tuesday 25th | 5:36p | 12:03a | 6.45
Wednesday 26th | 12:32a | 6:14a | 5.7
Thursday 27th | 6:04p | 8:47p | 2.71
 | 9:18p | 6:27p | 21.15
Friday 28th | - | - | -
Saturday 29th | 5:54p | 3:13a | 9.32
Sunday 30th | 3:45a | 4:05a | 0.32
 | 5:51p | 2:33a | 8.71
Total hours clocked for dates 6/14 to 6/20: 64.76
Monday 31st | 2:56a | 3:25a | 0.48
 | 6:10p | 3:28a | 8.8
Tuesday 1st | 5:49p | 5:43a | 11.4
Wednesday 2nd | - | - | -
Thursday 3rd | 6:15p | 5:09a | 10.39
Friday 4th | 6:05p | 2:26a | 7.85
Saturday 5th | 5:59p | 3:50a | 9.35
Sunday 6th | 5:48p | 2:51a | 8.55
Total hours clocked for dates 6/21 to 6/27: 56.82
Spreadsheet: 874930d1721444156-help-with-formula-varibles-depend-on-drop-down-list-ccb-app-test-eng-calc-master-
Sheet: OPS - CCB APP

COMPOSITE BAR APPLICATION CALCULATION WORKSHEET |  |  |  |  |  |  |  |  | Carbide Volume
ITEM CODE: |  | CCB12-38 |  | REQ VOL: | 1 |  |  |  |  | MAJOR OD = | 0
EFF % | REQ | UNIT REQ | [NAME] | WGT | COST |  |  |  |  | MAJOR LG = | 0
1 | MIN: |  |  |  |  |  |  |  |  | CBORE ID = | 0
0.8 | NOM: |  |  |  |  |  |  |  |  | CBORE DP = | 0
0.6 | MAX: |  |  |  |  |  |  |  |  | MAJOR VOL = | 0
 |  |  |  |  |  |  |  |  |  | CAVITY VOL = | 0
 |  |  |  |  |  |  |  |  |  | REQ VOL = | 0
COMPOSITE BAR DATA FROM TEMPLATE (DO NOT EDIT)
ITEM CODE |  | VOL/UNIT | [NAME] | WEIGHT | COST | DATE |  | LEGACY CALC (UNKNOWN USAGE)
CCB12-38 |  | 4.44 | 1 | .90 | 24.77 | 2024-06-18 00:00:00 |  | PN: RODBORUM316
CCB14-316 |  | 2.74 | 1 | .90 | 24.77 | 2024-06-18 00:00:00 |  | Borum Hardface Application
CCB14-516 |  | 1 | 1 | .90 | 22 | 2024-06-21 00:00:00 |  | surface area to cover |  | 0 | sq inch
CCB14-PIR |  | 1 | 1 | .90 | 69.17 | 2023-02-22 00:00:00 |  | application time = |  | 0 | minutes
CCB18-116 |  | 1 | 1 | .90 | 23.82 | 2021-07-23 00:00:00 |  | No. of applications |  | 0
CCB316-118-70 |  | 1 | 1 | .90 | 1 | 1900-01-01 00:00:00 |  | total time to apply = |  | 5 | minutes
CCB316-118CNK |  | 1 | 1 | .90 | 20 | 1900-01-01 00:00:00 |  |  |  | 0.08333333333333333 | hrs
CCB316-18 |  | 1 | 1 | .90 | 21.75 | 1900-01-01 00:00:00 |  | amt of borum req = |  | 0 | sticks
CCB316-SIR |  | 1 | 1 | .90 | 41.06 | 2023-02-22 00:00:00 |  | amount in pounds = |  | 0 | pounds
Spreadsheet: 680166d1590828944-return-a-specific-value-dpending-on-which-list-the-cell-value-is-listed-qc-dummy
Sheet: KYUSI

DISTRICT | BARANGAY | NAME OF FACILITY |  | LIST | LIST 2 | LIST 3
 | ALICIA | FACILITY 1 |  | ALICIA | BAESA | MARIKINA
 | ALICIA | FACILITY 2 |  | AMIHAN | BAGUIO | BATANGAS
 | AMIHAN | FACILITY 3 |  | APOLONIO SAMSON | TUBA | LIPA
 | APOLONIO SAMSON | FACILITY 4 |  |  | POBLACION | UGONG
 | APOLONIO SAMSON | FACILITY 5 |  |  |  | SIBUYAS
 | BAESA | FACILITY 6
 | BAGUIO | FACILITY 7
 | TUBA | FACILITY 8
 | POBLACION | FACILITY 9
 | BAESA | FACILITY 10
 | MARIKINA | FACILITY 11
 | BATANGAS | FACILITY 12
 | LIPA | FACILITY 13
 | UGONG | FACILITY 14
 | SIBUYAS | FACILITY 15
 |  |  |  |  |  |  |  | SS
Spreadsheet: 219792d1362949726-have-a-function-but-if-the-answer-is-a-negative-i-want-it-to-say-zero-0-xlf-stats-sheet
Sheet: Sheet1

Date Referred | Install Date | Removal Date | Total # of Days Sentenced | Offender | Agency | Number of Days Served at time of report | Offence that put Offender on Program | Violations Yes/No | Was it a Misd. or Felony | What is Violation | Date of Report
2012-12-07 00:00:00 | 2013-01-27 00:00:00 | 2013-05-12 00:00:00 | 105 | [NAME] | [NAME] | 41 | DUI | Yes | Misd | DUI | 2013-03-09 00:00:00
2013-03-07 00:00:00 | 2013-03-15 00:00:00 | Pre-Trial | PT | [NAME] | Pinal Co APO | 0 |  |  |  |  | 2013-03-09 00:00:00
2013-03-01 00:00:00 | 2013-03-16 00:00:00 | 2013-04-25 00:00:00 | 40 | [NAME] | [NAME] | 0 |  |  |  |  | 2013-03-09 00:00:00
2013-01-15 00:00:00 | 2013-03-17 00:00:00 | 2013-04-01 00:00:00 | 15 | [NAME] | [NAME] | 0 |  |  |  |  | 2013-03-09 00:00:00
2013-02-21 00:00:00 | 2013-03-28 00:00:00 | 2013-04-13 00:00:00 | 16 | [NAME] | [NAME] | 0 |  |  |  |  | 2013-03-09 00:00:00
2013-02-21 00:00:00 | 2013-04-10 00:00:00 | 2013-04-17 00:00:00 | 7 | [NAME] 6 | [NAME] | 0 |  |  |  |  | 2013-03-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2013-03-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2013-03-09 00:00:00
 |  |  |  |  |  |  | Column G is the date of report minus the |  |  |  | 2013-03-09 00:00:00
 |  |  |  |  |  |  | installation date, but some of the people
 |  |  |  |  |  |  | on the list have not been installed yet so
 |  |  |  |  |  |  | I would like the number to be zero, they are
 |  |  |  |  |  |  | now coming up with a negative number.
 | Total # of Participants Refered in reporting period |  |  |  |  |  | Also if someone has completed their time
 |  |  |  |  |  |  | during the reporting period can we get it to
 | Total # of Participants in Program during reporting period |  |  |  |  |  | stop counting at the removal date.
 |  |  |  |  |  |  | Also is there any way of getting this to work
 | Total # of Participants Completing Program during reporting period |  |  |  |  |  | with having my date of report only in 1 cell
 |  |  |  |  |  |  | rather than in the whole column? If not this
 | Total # of Participants that were violated from Program during reporting period |  |  |  |  |  |  | is the least of my worries!
 | Total # of Participants that have used alcohol and/or drugs while on program
 | and/or refused an alcohol or drug test during the reporting period
 | Number of DUI offenders that have used alcohol and/or drugs while on the |  |  |  |  |  |  |  | I am also going to be sending questions about
 | program and/or refused an alcohol or drug test during the reporting period |  |  |  |  |  |  | <-------- | all of those!
 | Number of program participants that committed a new misd. [NAME] while
 | on program during the reporting period (See Offender info for individual accounts)
Spreadsheet: 541362d1507240403-conditional-formatting-highlighter-instructions
Sheet: Form_2

 |  |  |  |  |  |  |  |  | Instructions:
 | 1. Part Number: |  | 2 Part Name: |  | 3. Serial Number: |  | 4. FAIR Number: |  | Field 1 | (Auto-filled) Customer part number
 |  |  |  |  |  |  |  |  | Field 2 | (Auto-filled) Part name
 | 5. Material or Process Name: |  | 6. Specification Number: | 7. Code: | 8. Supplier: | 9. Customer Approval Verification | 10. Certificate of Conformance number |  | Field 3 | (Auto-filled) Serial number
 | iex:INSPECTIONXPERT/INSPECTION_SHEET/SPECIFICATIONS/SPECIFICATION/@Name |  | iex:INSPECTIONXPERT/INSPECTION_SHEET/SPECIFICATIONS/SPECIFICATION/@Spec | iex:INSPECTIONXPERT/INSPECTION_SHEET/SPECIFICATIONS/SPECIFICATION/@Code | iex:INSPECTIONXPERT/INSPECTION_SHEET/SPECIFICATIONS/SPECIFICATION/@SupplierCode | iex:INSPECTIONXPERT/INSPECTION_SHEET/SPECIFICATIONS/SPECIFICATION/@CustomerApprovalVerification |  |  | Field 4 | (Auto-filled) Job number  / lot number
 |  |  |  |  |  |  |  |  | Field 5 | Name of applicable materials or special processes.
 | 11. Functional Test Procedure Number: |  | 12. Acceptance Report Number: |  |  |  |  |  | Field 6 | - Material specifications and material form (e.g., sheet, bar) for all materials incorporated into the FAI part (e.g., weld or braze filler). - Special process specifications; including class, if applicable, and permitted substitutions. - If standard catalogue items (e.g., fasteners) or COTS are modified, then list that standard hardware or COTS item
 | N/A |  | N/A
 | N/A |  | N/A
 | 13. Comments | N/A
 | 14. Signature |  |  |  | 15. Date |  |  |  | Field 7 | Any required code from the customer for material or process listing, as applicable.
 |  |  |  |  |  |  |  |  | Field 8 | Identify supplier name, address, and code performing special processes or supplying material.
 |  |  |  |  |  |  |  |  | Field 9 | Indicate if the special process(es) or material sources are approved by the customer.
 |  |  |  |  |  |  |  |  | Field 10 | The applicable certificate number (e.g., special process cert, raw material test report number; add heat lot number when applicable).
 |  |  |  |  |  |  |  |  | Field 11 | Functional Test Procedure number identified as a design characteristic.
 |  |  |  |  |  |  |  |  | Field 12 | The functional test certification indicating that test requirements have been met.
 |  |  |  |  |  |  |  |  | Field 13 | Provide supporting comments, as applicable.
 |  |  |  |  |  |  |  |  | Field 14 | (Auto-filled) Printed name or unique identification, and signature of the person who prepared and approved this form.
 |  |  |  |  |  |  |  |  | Field 15 | (Auto-filled) Date when field 14 was signed (DD-MMM-YYYY).
 |  |  |  |  |  |  |  |  | *Additional | N/A in all blank spaces, unless otherwise specified
Spreadsheet: 176af7d1-76d6-44ea-b4bb-5f34eae40a12
Sheet: Sheet1

REP 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
PERFORMANCE CASTING |  |  | SUBJECT TO CHANGE
2011-09-13 00:00:00
 |  | WEEK ONE
 | Fri | Sat Mat | [NAME]
 | 2011-09-23 00:00:00 | 2011-09-24 00:00:00 | 2011-09-24 00:00:00
 | 19:30:00 | 14:00:00 | 19:30:00
CAROUSEL (A DANCE)
Principal Couple | KORBES | RICARD | KORBES
 | ORZA | [NAME] | ORZA
Demi Couples
1 | [NAME] | [NAME] | [NAME]
 | GAINES | GAINES | GAINES
2 | MULLIN | MULLIN | MULLIN
 | GRIFFITHS | GRIFFITHS | GRIFFITHS
Corps Women
1 | [NAME] | [NAME] | [NAME]
2 | ANSPACH | ANSPACH | ANSPACH
3 | BIASUCCI | BIASUCCI | BIASUCCI
4 | CLARK | CLARK | CLARK
5 | LOVE | LOVE | LOVE
6 | MURPHY | MURPHY | MURPHY
7 | REID | REID | REID
8 | O'CONNOR | O'CONNOR | O'CONNOR
9 | PASCH | PASCH | PASCH
10 | RELIC | RELIC | RELIC
11 | RESHEF | RESHEF | RESHEF
12 | SAMUELSON | SAMUELSON | SAMUELSON
Corps Men
1 | BARTEE | BARTEE | BARTEE
2 | CARDEA | CARDEA | CARDEA
3 | DAVIS | DAVIS | DAVIS
4 | HIPOLITO | HIPOLITO | HIPOLITO
5 | LIN-YEE | LIN-YEE | LIN-YEE
6 | RENKO | RENKO | RENKO
7 | ROLLOFSON | ROLLOFSON | ROLLOFSON
8 | THOMSON | THOMSON | THOMSON
Pause
AFTER THE RAIN PAS DE DEUX
 | FOSTER | KORBES | CHAPMAN
 | MOORE | [NAME] | CRUZ
Intermission
POLYPHONIA
Women
1 | KORBES | KORBES | CHAPMAN
2 | FOSTER | FOSTER | FOSTER
3 | NAKAMURA | NAKAMURA | NAKAMURA
4 | RICARD | RICARD | RICARD
Men
1 | [NAME] | [NAME] | CRUZ
2 | POSTLEWAITE | POSTLEWAITE | POSTLEWAITE
3 | GRIFFITHS | GRIFFITHS | GRIFFITHS
4 | [NAME] | [NAME] | [NAME]
Intermission
VARIATIONS SERIEUSES
Ballerina | GILBREATH | GILBREATH | IMLER
Premier [NAME] | ORZA | ORZA | ORZA
Young Girl | RICARD | RICARD | RICARD
Ballet Master | PORRETTA | PORRETTA | GAINES
Conductor | LIN-YEE | LIN-YEE | LIN-YEE
Pianist | CHOE | CHOE | CHOE
Stage Manager | DEC | DEC | DEC
Dresser | NELSON | NELSON | NELSON
Corps de Ballet
Women
1 | [NAME] | [NAME] | [NAME]
2 | ANSPACH | ANSPACH | ANSPACH
3 | LOVE | LOVE | LOVE
4 | MULLIN | MULLIN | MULLIN
5 | O'CONNOR | O'CONNOR | O'CONNOR
6 | REID | REID | REID
7 | RESHEF | RESHEF | RESHEF
8 | SAMUELSON | SAMUELSON | SAMUELSON
Men
1 | BARTEE | BARTEE | LOCH
2 | DAVIS | DAVIS | CARDEA
3 | ROLLOFSON | ROLLOFSON | HIPOLITO
4 | THOMSON | THOMSON | RENKO
Crew
1 | [NAME] | [NAME] | [NAME]
2 | VEIT | VEIT | VEIT
3 | MCCALL | MCCALL | MCCALL
4 | AOKI | AOKI | AOKI
Spreadsheet: 65655d1266347931-selective-data-to-get-a-printed-report-budget-to-actual-expenditure-2010-slots
Sheet: 4

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Estimated Duty / Tax / Transport = |  | 0.45
 | Details |  |  |  |  | Quotation |  |  |  |  |  | Invoice |  |  |  |  |  |  |  | Local Duty, TAX & Local Transport
I / Q | # | Sequence # | Company | Discription |  | Quotation # | Quotation (Euro) | X rate | RSD | Date (processed) |  | Invoice # | Act invoice (Euro) | X rate | RSD | SHIP invoice | Difference % | Process (date) |  | Duty & Transport | Act invoice | Difference % | Paid (date) |  | Total cost (actual) | Special NOTES
 | 1 | 9 | Transportsped | 7 x Game conversions for IGT (Party Time) |  |  |  |  | 0 |  |  | 1781 - 7 |  |  | 27708 |  | 0 |  |  | 0 |  | 0 |  |  | 27708
 | 2 | 6 | World Freight GmbH | Transport and handling fees for - WMS spare parts |  |  |  |  | 0 |  |  | 90056440 | 213 | 98.65 | 21012.45 |  | 0 |  |  | 0 |  | 0 |  |  | 21012.45
 | 3 | 3 | Ainsworth | Transportation for - CD from Ainsworth to reprogram the OS security settings |  |  |  |  | 0 |  |  | 3372 | 12.5 | 97 | 1212.5 |  | 0 |  |  | 0 |  | 0 |  |  | 1212.5
 | 4 | 2 | [NAME] | CD from Ainsworth to reprogram the OS |  |  |  |  | 0 |  |  | 145-298-51 |  |  | 1228.85 |  | 0 |  |  | 0 |  | 0 |  |  | 1228.85
 | 5 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 6 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 7 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 8 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 9 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 10 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 11 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 12 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 13 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 14 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 15 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 16 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 17 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 18 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 19 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 20 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 |  |  |  | Total = |  |  |  |  | 0 |  |  |  |  |  | 51161.8 |  |  |  |  | 0 |  |  | Total spent = |  | 51161.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budget total = |  | 4598400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remaining = |  | 4547238.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % = |  | 0.9888739996520529
Spreadsheet: 134094d1325008415-merging-combining-rows-and-creating-a-range-example-excel-data
Sheet: Sheet1

Assignment# | Sponsor | Product Code
15275 | 1006 | ML
15276 | 1006 | ML
15277 | 1006 | TK
15278 | 1006 | TK
15279 | 1006 | TK
15281 | 1006 | RU
15284 | 706 | SF
15285 | 706 | SF
15286 | 706 | SF
 |  |  | Assignment#
 | Sponsor | Product Code | From | To | # available till next row
 | 1006 | ML | 15275 | 15276
 | 1006 | TK | 15277 | 15279
 | 1006 | RU | 15281 | 15281
 | 706 | SF | 15284 | 15284
 | x | x | 15500
Spreadsheet: 838158d1690797312-need-to-get-tabular-data-in-excel-based-on-the-header-reference-formula-for-table-data-effect
Sheet: Sheet1

H1 | H2 | H3 |  | H4
1A | 1b | 3c |  | abc
2A | 2b | 3c |  | def
3A | 3b | 3c |  | ghi
4A | 1b | 3c |  | jkl
5A | 2b | 3c |  | mno
6A | 3b | 3c |  | pqr
Spreadsheet: 710196d1608763307-opportunity-cost-calculation-sample2
Sheet: Sheet1

Item# | Quantity | Cost | Opportunity
12345 | 5 | 200 | 0
12346 | 10 | 200 | 0
12347 | 150 | 100
 | 20 | 50
 | 400 | 75
12348 | 10 | 200 | 0
12349 | 15 | 300 | 0
Opportunity = Zero for same Item #
Opportunity= If there are different Qty and Cost data
Equals to the Sum of difference in the price*Quantity
Example: For Item 12347, lowest price is $50, so opportunity is sum of 400x ($75-$50) and 150 x ($100-$50)
Spreadsheet: 743483d1628536450-finding-number-of-months-and-no-of-days-in-the-incomplete-month-between-two-dates-sheet1
Sheet: 工作表1

Annual Premium | 3561
Monthly Premium
Daily Premium |  |  | = Monthly Premium / No of days in the month and round to nearest 2 d.p.
 |  |  | 1. Period
 |  |  | By counting |  |  |  | Using Datedif
Start date | End date |  | Months | Days |  |  | Months | Days
2021-06-01 00:00:00 | 2021-12-31 00:00:00 |  | 7 | 0
2021-06-22 00:00:00 | 2021-12-31 00:00:00 |  | 6 | 9
 |  |  | 2. Premium
 |  |  | Months | Days | Total |  | Months | Days | Total
2021-06-01 00:00:00 | 2021-12-31 00:00:00
2021-06-22 00:00:00 | 2021-12-31 00:00:00
Spreadsheet: 97336d1296564350-sorting-puting-items-in-a-table-based-on-the-values-from-another-table-copy-of-copy-of-boo-1
Sheet: Sheet1

[PHONE]-AB | 500 | 500 | 500 | 500 | 0 | 2000
305548520D52-AB | 500 | 500 | 500 | 500 | 0 | 2000
305566520GNR-AA | 500 | 500 | 500 | 500 | 0 | 2000
305566520GNR-AB | 500 | 500 | 500 | 500 | 0 | 2000 |  |  |  | 6 | high runners | >500/week
305566520GNR-AC | 500 | 500 | 500 | 500 | 0 | 2000 |  |  |  |  | [PHONE]-AB
[PHONE]-AA | 1 | 0 | 0 | 0 | 0 | 1 |  |  |  |  | 305548520D52-AB
[PHONE]-AA |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 305566520GNR-AA
305583720T18-AA | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 305566520GNR-AB
[PHONE]-AA | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 305566520GNR-AC
[PHONE]-AA | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | [PHONE]-AC
305657920F82-AA | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 1 | Low runners | <501/week
305659520F82-AA | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | [PHONE]-AA
305665820E82-AA | 0 | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0 | 0
[PHONE]-AA | 0 | 0 | 0 | 0 | 0 | 0
[PHONE]-AC | 990 | 490 | 490 | 490 | 490 | 2950