tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 727076d1617704232-iferror-nesting-excel-forum-sheet-iferrornesting-aligw
Sheet: Sheet1

ITEM | VENDOR | VENDOR1 | VENDOR2 | VENDOR2 | VENDOR3 | VENDOR3 | VENDOR4 | VENDOR4
 |  | PRICE |  | PRICE |  | PRICE |  | PRICE
 |  |  |  |  |  |  |  |  | FORMULA FOR PRODUCTPRICE1
PRODUCTPRICE1 | VENDOR1 | 100 | VENDOR2 | 125 | VENDOR3 | 150 | VENDOR4 | 175
PRODUCTPRICE2 | VENDOR1 | 50 | VENDOR2 | 75 | VENDOR3 | 100 | VENDOR4 | 125 | FORMULA FOR PRODUCTPRICE1 AND PRODUCTPRICE2
Spreadsheet: 153629d1335980798-organize-files-book2
Sheet: Sheet1

CLIENT -> | CLIENT1 | CLIENT1 | CLIENT2 | CLIENT2 | CLIENT2 | CLIENT3 | …
DOCUMENTS -> | PRODUCT1 | PRODUCT2 | PRODUCT3 | PRODUCT4 | PRODUCT5 | PRODUCT6 | …
1.   CAUTIONS | ..\..\..\1.pdf
2.   INGREDIENTS
3.   SPECIFICATIONS |  |  |  |  |  |  |  |  | all the cells below, must be fitted to a specific yellow cell at the left
4.   DIMENSIONS |  |  |  |  |  |  |  |  | here should go pdf1 | here should go pdf8 | here should go pdf15
5.   PACKAGING |  |  |  |  |  |  |  |  | here should go pdf2 | here should go [NAME] | here should go pdf16
6.   PROCEDURES |  |  |  |  |  |  |  |  | here should go pdf3 | here should go pdf10 | here should go pdf17
7.   DETAILS |  |  |  |  |  |  |  |  | here should go pdf4 | here should go pdf11 | here should go pdf18
8.   PRICES |  |  |  |  |  |  |  |  | here should go pdf5 | here should go pdf12 | here should go pdf19
9.   DISTRIBUTORS |  |  |  |  |  |  |  |  | here should go pdf6 | here should go pdf13 | here should go pdf20
10. DATA |  |  |  |  |  |  |  |  | here should go pdf7 | here should go pdf14 | here should go pdf21
11. TESTS
12. COLORS
13. WEIGHTS
14. [NAME]
15. PARAMETERS
in each non-yellow cell, a specific pdf file will be linked
in each of the yellow cells, a number of pdfs will be linked
Spreadsheet: 172179d1344014786-excel-2003-formula-for-assigning-a-1-0-1-depending-on-a-change-column-excel-rating-formula
Sheet: What It Looks Like

Name | Supervisor | Data Month | Calls Handled | % Change | Positive/Neutral/Negative Rating
SMITH, BOB | [NAME] | 2012-01 | 686 | 0.5145772594752187
SMITH, BOB | [NAME] | 2012-02 | 1039 | 0.1299326275264678
SMITH, BOB | [NAME] | 2012-03 | 1174 | -0.3100511073253833
SMITH, BOB | [NAME] | 2012-04 | 810 | -0.2975308641975309
SMITH, BOB | [NAME] | 2012-05 | 569 | -0.008787346221441126
SMITH, BOB | [NAME] | 2012-06 | 564 | 564 |  | Note: I know each 1st month will not have a rating because the rating for the change from January to February will be noted in the Rating cell for February
QUAN, MICHELLE | [NAME] | 2012-01 | 503 | 0.1113320079522863
QUAN, MICHELLE | [NAME] | 2012-02 | 559 | 0.5742397137745975
QUAN, MICHELLE | [NAME] | 2012-03 | 880 | 0.1329545454545455
QUAN, MICHELLE | [NAME] | 2012-04 | 997 | -0.238716148445336
QUAN, MICHELLE | [NAME] | 2012-05 | 759 | 0.1409749670619236
QUAN, MICHELLE | [NAME] | 2012-06 | 866 | 866
 |  |  |  |  |  | Criteria: If % change from the old month to the new month is between +17% and -17% then the Rating Cell for the new month = 0                                         If % change is greater than +17% then Rating cell=+1                                                                         If% change is less than - 17% then Rating cell=-1
Spreadsheet: 47851d1247019885-excel-2007-need-help-with-wages-form-timesheet-icelandic
Sheet: Timesheet

Tímakaup: | 10 |  |  |  | Samtals tímar
Mánuður: | 2009-04-01 00:00:00 |  |  |  | Yfirvinna
Dagar | [NAME] | Fór | Hlé | [NAME]
 | 10:00:00 | 17:00:00 | 00:00:00
 | 10:00:00 | 17:00:00 | 00:00:00
 | 10:00:00 | 17:00:00 | 00:00:00
 | 10:00:00 | 17:00:00 | 00:00:00
 | 10:00:00 | 17:00:00 | 00:00:00
 | 10:00:00 | 17:00:00 | 00:00:00
 | 10:00:00 | 17:00:00 | 00:00:00
 | 10:00:00 | 17:00:00 | 00:00:00
Spreadsheet: 453656d1459399297-skipping-dates-have-blank-values-and-plot-remaining-dates-skip-the-date-which-has-blank-value-310316
Sheet: Sheet1

Date | Value |  | Desired result by formula
2008-08-01 00:00:00 | 335.1 |  | 2008-08-01 00:00:00
2008-08-02 00:00:00 | 335.1 |  | 2008-08-02 00:00:00
2008-08-03 00:00:00 |  |  | 2008-08-04 00:00:00
2008-08-04 00:00:00 | 322.65 |  | 2008-08-05 00:00:00
2008-08-05 00:00:00 | 320.05 |  | 2008-08-06 00:00:00
2008-08-06 00:00:00 | 318.85 |  | 2008-08-07 00:00:00
2008-08-07 00:00:00 | 320.05 |  | 2008-08-08 00:00:00
2008-08-08 00:00:00 | 311.1 |  | 2008-08-09 00:00:00
2008-08-09 00:00:00 | 309.9 |  | 2008-08-11 00:00:00
2008-08-10 00:00:00 |  |  | 2008-08-12 00:00:00
2008-08-11 00:00:00 | 307.35 |  | 2008-08-13 00:00:00
2008-08-12 00:00:00 | 304.2 |  | 2008-08-14 00:00:00
2008-08-13 00:00:00 | 317.2 |  | 2008-08-16 00:00:00
2008-08-14 00:00:00 | 315.1 |  | 2008-08-18 00:00:00
2008-08-15 00:00:00 |  |  | 2008-08-19 00:00:00
2008-08-16 00:00:00 | 315.15 |  | 2008-08-20 00:00:00
2008-08-17 00:00:00 |  |  | 2008-08-21 00:00:00
2008-08-18 00:00:00 | 318.25 |  | 2008-08-22 00:00:00
2008-08-19 00:00:00 | 329.15 |  | 2008-08-23 00:00:00
2008-08-20 00:00:00 | 327.15 |  | 2008-08-25 00:00:00
2008-08-21 00:00:00 | 338.65 |  | 2008-08-26 00:00:00
2008-08-22 00:00:00 | 332.25 |  | 2008-08-27 00:00:00
2008-08-23 00:00:00 | 331.9 |  | 2008-08-28 00:00:00
2008-08-24 00:00:00 |  |  | 2008-08-29 00:00:00
2008-08-25 00:00:00 | 337.05 |  | 2008-08-30 00:00:00
2008-08-26 00:00:00 | 332.15
2008-08-27 00:00:00 | 334.3
2008-08-28 00:00:00 | 331.05
2008-08-29 00:00:00 | 331.1
2008-08-30 00:00:00 | 327.15
2008-08-31 00:00:00
Spreadsheet: 854753d1704511213-simplifying-complex-formula-test-gk3-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1,2 | 4,9,19,25 | 4,10,14,22 | 4,13,19,23 | 4,17,19,24 | 1,14,23,24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 8 | 25 | 0 | 15 | 35
y/n | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z |  |  |  |  |  |  |  |  | windknife | windknife [NAME] | Original Formula
y | 18 | 2 | 2 | 3 | 0 | 2 | 1 | 2 | 1 | 3 | 1 | 2 | 1 | 3 | 26 | 2 | 0 | 22 | 0 | 22 | 2 | 32 | 2 | 4 | 2 | 2 |  |  | 9 | 4 | 0 | 14 | 0
y | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 2 | 1 | 4 | 24 | 0 | 0 | 2 | 0 | 2 | 1 | 3 | 2 | 5 | 0 | 0 |  |  |  |  |  |  |  |  |  | 0
y | 10 | 2 | 2 | 222 | 0 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 24 | 0 | 2 | 2 | 0 | 2 | 1 | 3 | 1 | 5 | 0 | 2 |  |  |  |  |  |  |  |  |  | 0
n | 12 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 0 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0 |  |  |  |  |  |  |  |  |  | 0
y | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 2 | 1 | 22 | 1 | 4 | 2 | 0 |  |  |  |  |  |  |  |  |  | 0
y | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 20 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0 |  |  |  |  |  |  |  |  |  | 1
y | 15 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 2 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0 |  |  |  |  |  |  |  |  |  | 1
n | 18 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0 |  |  |  |  |  |  |  |  |  | 0
n | 8 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 24 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 2 |  |  |  |  |  |  |  |  |  | 0
y | 14 | 2 | 2 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 12 | 0 | 2 | 22 | 0 | 2 | 1 | 22 | 2 | 3 | 0 | 2 |  |  |  |  |  |  |  |  |  | 0
y | 14 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 4 | 0 | 22 |  |  |  |  |  |  |  |  |  | 1
y | 18 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 28 | 2 | 0 | 2 | 0 | 2 | 1 | 32 | 2 | 5 | 2 | 2 |  |  |  |  |  |  |  |  |  | 1
y | 20 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 25 | 0 | 0 | 22 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 22 |  |  |  |  |  |  |  |  |  | 0
y | 24 | 2 | 2 | 222 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 22 |  |  |  |  |  |  |  |  |  | 0
n | 8 | 2 | 0 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 22 | 0 | 0 | 2 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 2 |  |  |  |  |  |  |  |  |  | 0
y | 18 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 0 |  |  |  |  |  |  |  |  |  | 1
y | 22 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 0 |  |  |  |  |  |  |  |  |  | 0
y | 24 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 3 | 2 | 5 | 21 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 0 |  |  |  |  |  |  |  |  |  | 1
y | 22 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 16 | 2 | 2 | 22 | 0 | 0 | 0 | 22 | 1 | 3 | 2 | 0 |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 841364d1693552207-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-copy-of-ef-file-
Sheet: Today

 | Day | Headcount | Night | Headcount |  | Day | Headcount | Night | Headcount
1
2
3
4
5
6
7
8
9
10
11
12
13
15
16
17
18
19
20
21
22
23
30
31
50
Total
52
53
54
57
58
59
61
62
63
64
66
67
68
69
71
72
73
74
76
77
78
79
86
87
88
89
91
95
96
99
104
106
107
108
109
Total
Spreadsheet: 805646d1668803271-return-array-with-values-repeated-n-times-based-on-another-criteria-book2
Sheet: Sheet1

allo_id | allo_wh_n |  | OUTPUT
allo-750-001 | 0
allo-750-002 | 1
allo-750-003 | 1
allo-750-004 | 2
allo-750-005 | 3
allo-750-006 | 4
Spreadsheet: 3fad59e5-d6cd-467e-b64e-22c1b4e8b1da
Sheet: Sheet1

$ per funded child hour (GST incl) | Rates until 30 June 2009 | Unnamed: 2 | Unnamed: 3 | Rates from 1 July 2009 | Unnamed: 5 | Unnamed: 6 | % Change | Unnamed: 8 | Unnamed: 9
 | Under 2 | 2 and over | 20 Hours ECE | Under 2 | 2 and over | 20 Hours ECE | Under 2 | 2 and over | 20 Hours ECE
All-day teacher-led centre-based services
100% registered teachers | 12.28 | 7.72 | 12.26 | 12.94 | 7.79 | 12.35 | 0.05374592833876223 | 0.009067357512953405 | 0.007340946166394769
80 – 99% registered teachers | 11.55 | 6.85 | 11.33 | 12.16 | 6.91 | 11.42 | 0.05281385281385276 | 0.008759124087591314 | 0.007943512797881717
50 – 79% registered teachers | 9.91 | 5.41 | 9.75 | 10.36 | 5.46 | 9.83 | 0.04540867810292627 | 0.009242144177449136 | 0.008205128205128212
25 – 49% registered teachers | 8.08 | 4.32 | 8.59 | 8.35 | 4.35 | 8.64 | 0.03341584158415836 | 0.006944444444444296 | 0.005820721769499501
0 – 24% registered teachers | 7.03 | 3.6 | 7.83 | 7.14 | 3.62 | 7.88 | 0.01564722617354188 | 0.00555555555555556 | 0.006385696040868432
Sessional teacher-led centre-based services
100% registered teachers | 11.43 | 6.02 | 7.2 | 12.09 | 6.07 | 7.26 | 0.05774278215223098 | 0.00830564784053168 | 0.00833333333333328
80 – 99% registered teachers | 10.74 | 4.74 | 6.08 | 10.8 | 4.95 | 6.3 | 0.005586592178770996 | 0.04430379746835442 | 0.03618421052631575
50 – 79% registered teachers | 9.19 | 3.97 | 5.24 | 9.24 | 4.12 | 5.4 | 0.005440696409140447 | 0.03778337531486144 | 0.03053435114503819
25 – 49% registered teachers | 7.49 | 3.46 | 4.67 | 7.53 | 3.55 | 4.77 | 0.005340453938584784 | 0.02601156069364158 | 0.02141327623126331
0 – 24% registered teachers | 6.51 | 3.15 | 4.36 | 6.55 | 3.19 | 4.41 | 0.006144393241167441 | 0.01269841269841271 | 0.01146788990825684
Protected rate | 6.51 | 3.26 | 4.41 | 6.51 | 3.26 | 4.41 | 0 | 0 | 0
Teacher-led home-based ECE services
Quality | 7.86 | 4.17 | 8.73 | 7.91 | 4.24 | 8.83 | 0.006361323155216262 | 0.01678657074340534 | 0.01145475372279492
Standard | 6.9 | 3.68 | 8.24 | 6.94 | 3.75 | 8.34 | 0.005797101449275368 | 0.01902173913043474 | 0.01213592233009704
[NAME] (rates for 20 Hours ECE to be provided at a later date)
Quality | 8.33 | 4.18 |  | 8.4 | 4.22 |  | 0.00840336134453785 | 0.00956937799043063
Standard | 7.29 | 3.66 |  | 7.35 | 3.7 |  | 0.008230452674897066 | 0.01092896174863389
Te [NAME] (except those recognised as teacher-led for funding purposes)
Quality | 8.33 | 4.18 | 7.84 | 8.4 | 4.22 | 7.88 | 0.00840336134453785 | 0.00956937799043063 | 0.005102040816326535
Standard | 7.29 | 3.66 | 7.38 | 7.35 | 3.7 | 7.42 | 0.008230452674897066 | 0.01092896174863389 | 0.005420054200542011
Certificated Playgroups and Licence-Exempt Services (GST not applicable)
 | 1.36 | 1.36 |  | 1.37 | 1.37 |  | 0.007352941176470594 | 0.007352941176470594
Spreadsheet: 216570d1361813780-still-sumif-question-book2-hb-start-over-14-daily-reconciliation-6
Sheet: Cash Out Envelope

 |  |  |  |  |  |  |  |  |  |  | CHECKS: | CHECKS: | CHECKS:
 |  |  | CASH OUT ENVELOPE
 |  |  |  |  |  |  | # Of
 |  |  |  |  | $ [NAME] |  | Bills |  | TOTAL
DEPARTMENT: |  |  |  |  | 100
CASH OUT NUMBER: |  |  |  |  | 50
PREPARED BY: |  |  |  |  | 20
Date: |  |  |  |  | 10
 |  |  |  |  | 5
Permit Numbers: |  |  |  |  | 2
Checked & Received By: |  |  |  |  | 1
 |  |  |  |  |  |  | Coins:
Deposited In Safe #:
Date: |  | Time: |  |  |  |  | CASH
When To Bank: |  | Time: |  |  |  |  | CHECKS/TCKS
 |  |  |  |  |  |  | STAMPS
 |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  | CHECKS
 |  |  |  |  |  |  |  |  | TOTAL CHECKS
 |  |  |  |  |  |  |  |  | # of Checks
 |  |  |  |  |  |  |  |  | Total # of Checks
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Central-Trading w-o AA

 | Central Gas - Trading
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 15000 | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 1
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 3
 |  |  |  |  |  |  |  | Director | 143000 | 2
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 734653d1622356934-formula-vlookup-does-not-find-values-cerca_vertelenco-etaf
Sheet: ASDX

 |  |  | drop-down menu
 |  |  | A20
 |  |  | A4
 |  |  | A7
 |  |  | A4
 |  |  | A3
 |  |  | A20
 |  |  | A4
 |  |  | A17
 |  |  | a2
 |  |  | A16
 |  |  | A18
 |  |  | BB
 |  |  | A16
 |  |  | A5
Spreadsheet: 856809d1706001985-author-name-referencing-need-a-formula
Sheet: Data (2)

DATE | COLOUR | OPEN BALANCE | INBOUND | OUTBOUND | CLOSE BALANCE | AUTHOR NAME |  |  |  |  |  | DATE | COLOUR | OPEN BALANCE | INBOUND | OUTBOUND | CLOSE BALANCE
2024-01-19 00:00:00 | RED |  | 200 |  |  | Padi, [NAME] |  |  |  |  |  | 2024-01-19 00:00:00 | RED |  | 200
2024-01-19 00:00:00 | ORANGE |  | 2034 |  |  |  |  |  |  |  |  | 2024-01-19 00:00:00 | ORANGE |  | 2034
2024-01-19 00:00:00 | YELLOW |  | 1500 |  |  |  |  |  |  |  |  | 2024-01-19 00:00:00 | YELLOW |  | 1500
2024-01-19 00:00:00 | BLUE |  | 1320 |  |  |  |  |  |  |  |  | 2024-01-19 00:00:00 | BLUE |  | 1320
2024-01-20 00:00:00 | RED |  |  | 50 |  |  |  |  |  |  |  | 2024-01-20 00:00:00 | RED |  |  | 50
2024-01-20 00:00:00 | YELLOW |  |  | 120 |  |  |  |  |  |  |  | 2024-01-20 00:00:00 | YELLOW |  |  | 120
2024-01-21 00:00:00 | ORANGE |  |  | 150 |  |  |  |  |  |  |  | 2024-01-21 00:00:00 | ORANGE |  |  | 150
2024-01-21 00:00:00 | BLUE |  |  | 300 |  |  |  |  |  |  |  | 2024-01-21 00:00:00 | BLUE |  |  | 300
2024-01-22 00:00:00 | GREEN |  | 2500 | 120 |  |  |  |  |  |  |  | 2024-01-22 00:00:00 | GREEN |  | 2500 | 120
2024-01-22 00:00:00 | BLUE |  | 600 |  |  |  |  |  |  |  |  | 2024-01-22 00:00:00 | BLUE |  | 600
2024-01-22 00:00:00 | RED |  | 450 |  |  |  |  |  |  |  |  | 2024-01-22 00:00:00 | RED |  | 450
2024-01-22 00:00:00 | GREEN |  | 200 | 1230
Spreadsheet: 873502d1720008187-staff-loan-deduction-loan-dedution
Sheet: Sheet1

 | EMPLOYEE 1 |  |  |  |  |  | EMPLOYEE 2
Month | Loan Amount | Repayment | Advance | Once-Off Dedution | Total Deduction | Balance | Loan Amount | Repayment | Advance | Once-Off Dedution | Total Deduction | Balance
2024-07-01 00:00:00 | 9250 | 500 | 200 | 200 |  |  | 11950 | 500 | 500 | 500
2024-08-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2024-09-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2024-10-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2024-11-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2024-12-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-01-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-02-01 00:00:00 |  | 500 |  |  |  |  |  | 500 | 500 | 500
2025-03-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-04-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-05-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-06-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-07-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-08-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-09-01 00:00:00 |  | 500 | 700 | 700 |  |  |  | 500
2025-10-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-11-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2025-12-01 00:00:00 |  | 500 |  |  |  |  |  | 500
2026-01-01 00:00:00 |  |  |  |  |  |  |  | 501
2026-02-01 00:00:00 |  |  |  |  |  |  |  | 502
2026-03-01 00:00:00 |  |  |  |  |  |  |  | 503
2026-04-01 00:00:00 |  |  |  |  |  |  |  | 504
2026-05-01 00:00:00 |  |  |  |  |  |  |  | 505
2026-06-01 00:00:00
Spreadsheet: 746512d1630785728-lookup-returning-duplicate-values-when-there-a-blank-can-it-search-in-sequence-sheet-for-excelhelp
Sheet: Sign On Sheets

Day |  | Tue | x
Date |  |  | x
Week |  |  | x
a
Folder Number | Duty Number | Name | Pay Number | Duty Start Time | Duty Finish Time
Spreadsheet: 866048d1712984077-help-for-creating-major-league-table-24
Sheet: Setting

 | R | Team | Last Year Rank | M | P | W | D | L | F | A | [NAME] | Pt | P | W | D | L | F | A | [NAME] | Pt | P | W | D | L | F | A | [NAME] | Pt | Pt Rank | GD Rank | F Rank | Last Year Position
 | R | Team | Last Year Rank | M | P | W | D | L | F | A | [NAME] | Pt | P | W | D | L | F | A | [NAME] | Pt | P | W | D | L | F | A | [NAME] | Pt | Pt Rank | GD Rank | F Rank | Last Year Position
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
Spreadsheet: 3431a302-3570-4a13-8b57-9e40c8c027cd
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
HETRONIC NORGE AS | Hanekleiva 161 | 3090 | Hof
METALL FASADER Terje Trondsen |  | 3092 | Sundbyfoss
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 82656d1282684803-multiple-criteria-in-one-column-sumproduct
Sheet: Sheet1

Period | Not important column | Loan # | Status | Can Work?
Period 1 |  | Loan 1 | Submitted | 0
Period 2 |  | Loan 1 | Submitted | 0
Period 3 |  | Loan 1 | Submitted | 0
Period 4 |  | Loan 1 | Assigned | 0
Period 5 |  | Loan 1 | Some other Value | 0
Period 6 |  | Loan 1 | And Another | 0
Period 1 |  | Loan 2 | Submitted | 1
Period 2 |  | Loan 2 | Unassigned | 1
Period 3 |  | Loan 2 | Unassigned | 1
Period 1 |  | Loan 3 | Assigned | 0
Period 2 |  | Loan 3 | Some other Value | 0
Period 3 |  | Loan 3 | Some other Value | 0
Period 4 |  | Loan 3 | And Another | 0
Period 5 |  | Loan 3 | Submitted | 0
Period 1 |  | Loan 4 | Unassigned | 1
Period 2 |  | Loan 4 | Unassigned | 1
Spreadsheet: 181fd2d5-b923-45f2-ba3d-dbbd79badfa3
Sheet: 2007-08

Table Q
Full Time Affiliate Student numbers
Department | Undergraduate |  |  | Graduate |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total
Anatomy and Developmental Biology | 0 | 1 |  | 0 | 0
Anthropology | 4 | 8 |  | 1 | 0
Institute of Archaeology | 1 | 10 |  | 0 | 1
Bartlett School of Architecture | 0 | 3 |  | 0 | 0
Bartlett School of Graduate Studies | 0 | 0 |  | 0 | 1
Bartlett School of Planning | 5 | 4 |  | 4 | 0
Biochemical Engineering | 2 | 2 |  | 0 | 1
Biochemistry and Molecular Biology | 0 | 2 |  | 1 | 0
Biology | 0 | 8 |  | 0 | 0
Centre for Advanced Spatial Analysis | 0 | 0 |  | 1 | 0
Centre for Intercultural Studies | 0 | 0 |  | 1 | 0
Chemical Engineering | 7 | 3 |  | 0 | 0
Chemistry | 2 | 5 |  | 0 | 0
Civil, Environmental and Geomatic Eng. | 0 | 1 |  | 2 | 1
Institute of Child Health | 0 | 4 |  | 4 | 0
Computer Science | 10 | 1 |  | 1 | 0
[NAME] and Literature | 7 | 0 |  | 0 | 0
Earth Sciences | 1 | 1 |  | 0 | 0
Eastman Dental Institute | 0 | 0 |  | 5 | 3
Economics | 0 | 46 |  | 4 | 4
Electronic and Electrical Engineering | 1 | 2 |  | 0 | 0
English Language and Literature | 1 | 34 |  | 0 | 0
Epidemiology and Public Health | 0 | 0 |  | 0 | 1
European Social and Political Studies | 9 | 0 |  | 0 | 0
Slade School of Fine Art | 1 | 6 |  | 0 | 1
French | 22 | 8 |  | 0 | 0
Geography | 9 | 6 |  | 0 | 2
German | 15 | 0 |  | 0 | 0
Greek and Latin | 2 | 4 |  | 0 | 0
Hebrew and Jewish Studies | 0 | 2 |  | 0 | 0
History | 10 | 35 |  | 5 | 0
History of Art | 2 | 20 |  | 0 | 0
Italian | 23 | 0 |  | 1 | 0
Language Centre (Affiliates) | 0 | 171 |  | 0 | 0
Laws | 51 | 3 |  | 0 | 53
Mathematics | 0 | 7 |  | 0 | 0
Mechanical Engineering | 0 | 6 |  | 0 | 0
Medical Physics | 1 | 0 |  | 1 | 0
Philosophy | 0 | 13 |  | 0 | 0
Phonetics and [NAME] | 2 | 1 |  | 0 | 0
Physics and Astronomy | 3 | 6 |  | 0 | 0
Physiology | 0 | 1 |  | 0 | 1
Political Science | 0 | 35 |  | 0 | 1
Psychology | 5 | 29 |  | 0 | 0
Scandinavian Studies | 6 | 0 |  | 1 | 0
School of Slavonic and E. European Stds | 18 | 2 |  | 0 | 0
Science and Technology Studies | 0 | 2 |  | 0 | 0
Spanish and Latin American Studies | 15 | 2 |  | 0 | 0
Statistical Science | 5 | 0 |  | 1 | 0
Total
As figures relate to the official HEFCE census date, 1 December, affiliate students who start in January are not included.
Spreadsheet: 785281d1656324008-sum-calculations-for-specific-data-in-another-column-voucher-tracker
Sheet: Dashboard

 | Voucher Tracker |  |  |  |  | Project Allocation
 | £10 Vouchers |  |  |  |  | Works4Youth | We Work For Everyone | Future Bright | [NAME]  /  Family Learning
Voucher | Issued | Remaining | Value issued |  | No.
10
20
 | £20 Vouchers |  |  |  | Value
 | Issued | Remaining | Value issued
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 10c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60+ | TOTAL
Cross-Currency Basis | 1646869 | 705484 | 2617928 | 2192742 | 3640432 | 3661275 | 14464730
Cross-Currency Fixed-Fixed | 17737 | 15760 | 24187 | 45626 | 118943 | 198871 | 421123
Cross-Currency Fixed-Float | 157469 | 83652 | 180199 | 254089 | 402551 | 237056 | 1315016
TOTAL | 1822075 | 804896 | 2822314 | 2492457 | 4161926 | 4097202 | 16200869
Spreadsheet: 816164d1675409423-generate-next-ids-based-on-existing-list-id_generator
Sheet: Feuil1

 |  |  |  |  |  |  | expected_result
 |  | model |  |  | code |  | [NAME]
 |  | Ag-104 |  |  | An |  | 103
 |  | Ag-100 |  |  | Ag |  | 102
 |  | ZrO-100 |  |  | ZrO |  | 106
 |  | ZrO-101 |  |  | MWc |  | 100
 |  | ZrO-102
 |  | ZrO-103
 |  | ZrO-104
 |  | An-100
 |  | An-101
 |  | An-102
 |  | [NAME]
 |  | ZrO-110
 |  | ZrO-111
 |  | [NAME]
 |  | ZrO-110
 |  | ZrO-111
 |  | Ag-100
 |  | Ag-101
 |  | ZrO-120