tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 11c5bc1a-5d16-4ced-9de5-f55ba3869a45
Sheet: Instructions

Instructions
The purpose of this file is to distribute teachers' salaries and contract hours among disability categories.
To use the file, you enter the following teacher-specific data into the yellow cells of the "Report" worksheet:
* | district number in the yellow cells
* | DO NOT CHANGE the threshold cell unless requested by MDE
* | total contact days,
* | total annual salary, and
* | pupil contacts by disability.
The file allows you to enter data for up to 20 teachers.  If you have more than 20 teachers, you have to
create multiple versions of the file.
The file also lets the user specify a particular district, and to specify a "threshold portion" that will be
explained below.
The inputs section is followed by a "TOTALS" section the adds up the results for individual teachers.
The come the detailed calculations, with six lines for each individual teacher:
1 | Inputs
 | This line simply restates the inputs that were entered in the yellow cells.
2 | Revised Pupils
 | In this line, a given disability's pupil count is eliminated if it represents less than 10% of a teacher's
 | total number of pupil contacts.  This 10% is the default "threshold portion", as noted above.
 | You probably don't want to change this 10% value.
3 | Pupil Portions
 | This shows the portion of pupils from the "Revised Pupils" line that are associated with each
 | category of disability.  Assuming that a teacher's overall pupil count is greater than zero,
 | the values in the "Pupil Portions" line will add up to 100%.
4 | Contract Days
 | In this line, the total number of contract days that were entered for a teacher in the yellow section
 | are distributed across disability categories in proportion to the "Pupil Portions" line.
EDRS DATA
 | The lines in the shaded (light green) area are the data that may be entered on EDRS.  It is the data below:
5 | Contract Hours
 | The number of hours per day varies from district to district.  One of the yellow cells lets the user
 | specify a particular district.  The file will automatically look up the hours per day for the district that
 | was specified as one of the inputs, and will use this value to convert contract days to contract hours.
6 | Annual Salary
 | In this line, the salary that was entered for a teacher in the yellow section is distributed across
 | disability categories in proportion to the "Pupil Portions" line.
As already noted, the totals across teachers for contract days, contract hours, and annual salaries
are shown in the TOTALS section that immediately follows the inputs.
Please address any spreadsheet questions to [NAME] at [EMAIL], or at [PHONE].
Tuition questions go the George Holt at 651-582-889 or email to [NAME] or
 | [NAME] at [PHONE] or email to [EMAIL]
EDRS question may be sent to [NAME] or [NAME]. [NAME]'s phone number is [PHONE] or email
 | to [EMAIL]. [NAME]' phone number is [PHONE] or email to [NAME]
Spreadsheet: 3293c68e-f304-4c32-8686-babdd9a8d6c6
Sheet: USB

 | USB Port
 | OS | Status | Detect | Plays
 | Windows XP | NA | x | x
 | Windows 7/8 | NA | x | x
 | Linux | NA | x | x
 | OS X | NA | x | x
 | T= Test  NT=Not Tested
 | D=Detectable ND=Not Detectable (have not been able to get this working yet)
 | P=Plays Movies (refer to list below)  NP=Will not play any media
 | Container | Audio Codec | Video Codec | Plays | [NAME]? | Exceptions
 | .avi | [NAME] | ac3 | Y | Y
 | .avi | [NAME] | mp3 | Y | Y
 | .avi | msmpeg4v2 | mp3 | N | N
 | .avi | divx5 | mp3 | N | N
 | .avi | [NAME] | mp3 | N | N
 | .avi | [NAME] | divx audio v2 | N | N
 | .avi | divx4 | mp3 | N | N
 | .flv | h264 | aac | N | N
 | .m4v | h264 | aac | Y | Y
 | .mkv | h264 | ogg | N | N
 | .mkv | h264 | aac | N | N
 | .mkv | h264 | dts | N | N
 | .mp4 | h264 | aac | Y | Y
 | .mpg | mpeg1 | mp2 | Y | Y
 | .mpg | mpeg2 | mp2 | Y | Y
 | Y=Plays in full  N1=Plays but doesn't recognize audio codec N2=Plays but doesn't recognize video codec NP=does not play
 | Exceptions refers to the ability to get that type of file to be played via a particular OS
 | WXP=not working in Windows XP  W78=not working in Windows 7/8  [NAME]=not working in Linux MAC=not working in MAC
 | Notes
Spreadsheet: cda814c7-3e18-43c9-ae05-7b27eaabc32f
Sheet: Sheet1

Unnamed: 0 | Enter your information | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Summer Housing Calculator
 | Minimum 30 night stay
 | [NAME] |  |  | 2013-05-05 00:00:00
 | Departure Date |  |  | 2013-07-14 00:00:00
 | Calculated number of days |  |  | 70
 | Select your rate |  |  | 19.75 | click box to select
 |  |  | `
 | Total Due on [NAME] |  |  | 1382.5
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 10a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis
 | FRA
 | Exotic
 | Inflation
 | IRS- [NAME]
 | OIS
 | VNS
 | Zero Coupon
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | N/A*** | N/A | N/A
Estimated net notional amount outstanding, February 8 weekly snapshot, by product type and tenor (millions of USD), all participant types and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 594814d1539979444-spreadsheet-working-really-slowly-what-do-i-have-wrong-too-many-formulas-file-book-test-tmo
Sheet: Family UFN Proforma (2)

 |  | MANSFIELD FAMILY UFN'S
File Number | Client Name | Case Start Date | Case ID | UFN | Requested By
 |  |  | 701
 |  |  | 702
 |  |  | 703
 |  |  | 704
 |  |  | 705
 |  |  | 706
 |  |  | 707
 |  |  | 708
 |  |  | 709
 |  |  | 710
 |  |  | 711
 |  |  | 712
 |  |  | 713
 |  |  | 714
 |  |  | 715
 |  |  | 716
 |  |  | 717
 |  |  | 718
 |  |  | 719
 |  |  | 720
 |  |  | 721
 |  |  | 722
 |  |  | 723
 |  |  | 724
 |  |  | 725
 |  |  | 726
 |  |  | 727
 |  |  | 728
 |  |  | 729
 |  |  | 730
Spreadsheet: 142666d1329950330-automatically-updating-budget-allocation-see-example-attached-example
Sheet: Sheet1

 | Annual Budget | 120000
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Monthly budget
 | Employee A | -7000
 | Employee B | -5000
 | Total spend
 | (Over)/Under
 | Cumulative
 | Special event |  |  |  |  |  | -5000 | -5000
Spreadsheet: 786043d1656946404-excel-function-use-to-extract-between-range-data-without-array-formula-04072022-sample-file-for-excel-forum
Sheet: Sheet1

 |  |  | INSERTED 2 ROWS |  |  |  |  | RESULT |  |  | Topley |  | Mokko
 |  |  |  |  |  |  |  | Nos. | Bth | [NAME] | [NAME] Used
 | Bth |  | Bthno | From no. | To No. |  |  | 15712 | JG | 3
 | GK |  | 1 | 1 | 1000 |  |  | 1 | GK | 1
 |  |  | 2 |  |  |  |  | 8901 | GK | 9
 |  |  | 3 |  |  |  |  | 7484 | GK | 8
 |  |  | 4 |  |  |  |  | 23948 | BH | 3
 |  |  | 5 |  |  |  |  | 21910 | BR | 1
 |  |  | 6 |  |  |  |  | 13213 | JG | 1
 |  |  | 7 |  |  |  |  | 46676 | KD | 1
 |  |  | 8
 |  |  | 9 |  |  |  |  |  |  |  | ERROR CELLS
 |  |  | 10
 |  |  | 11
 |  |  | 12
 |  |  | 13 |  | 13212
 | JG |  | 1 | 13213 | 14212
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 6 |  | 19525
 | BY |  | 1 | 19526 | 20582
 | BR |  | 1 | 20583 | 21910
 | BH |  | 1 | 21911 | 22910
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5 |  | 27472
 | GT |  | 1 | 27473 | 28472
 |  |  | 2 |  | 29487
 | TH |  | 1 | 29488 | 30487
 |  |  | 2 |  | 31445
 | VS |  | 1 | 31446 | 32445
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5 |  | 36599
 | PNV |  | 1 | 36600 | 37305
 | PN |  | 1 | 37306 | 37617
 | PCN |  | 1 | 37618 | 38617
 |  |  | 2 |  | 39960
 | WA |  | 1 | 39961 | 41498
 | MD |  | 1 | 41499 | 42498
 |  |  | 2
 |  |  | 3 |  | 44425
 | ST |  | 1 | 44426 | 45337
 | SH |  | 1 | 45338 | 45592
 | KD |  | 1 | 45593 | 46676
Spreadsheet: 144b8e05-0e10-43e9-8ce4-ef42e0f34835
Sheet: Simple Schedule

.
Return to Index Page
 | Simple Daily Schedule
 | Per. | Min.
 | 1 | 52 |  |  | Daily Average Time in Seminar | 26
 | 2 | 53 |  |  | Number of classes (periods) in full time schedule | 7
 | Sem | 26 |  |  | Divide time by periods
 | 3 | 54 |  |  | Round time to whole minutes | 4
 | 4 | 54 |  |  | Enrollment in all .5 funded classes (less exceptions)   *** | 187
 | 5 | 56 |  |  | Minutes to add to vocational for seminar
 | 6 | 55
 | 7 | 52
 | ***  Enrollment in all .5 funded classes except OJT & IHT
Spreadsheet: 666028d1583433856-complex-timesheet-template-working-timesheet
Sheet: Table

Day | Task | Tiime In | Time End | Sum of Reg Hrs | Sum of Overtime |  | Day | Task | Sum of Reg Hrs | Sum of Overtime |  | Task | Sum of Reg Hrs | Sum of Overtime
Sun | Task A | 10 AM | 12 PM | 02:00:00 | 00:00:00 |  | Sun | Task A | 06:00:00 | 00:00:00 |  | Task A | 17:30:00 | 01:20:00
Sun | Task A | 1 PM | 5 PM | 04:00:00 | 00:00:00 |  | Sun Total |  | 06:00:00 | 00:00:00 |  | Task B | 17:30:00 | 01:00:00
Mon | Task A | 6 PM | 6 PM | 00:00:00 | 00:30:00 |  | Mon | Task A | 00:00:00 | 00:30:00 |  | Task C | 17:00:00 | 02:55:00
Mon | Task B | 5 PM | 6 PM | 00:00:00 | 01:00:00 |  | Mon | Task B | 00:00:00 | 01:00:00 |  | Grand Total | 1900-01-02 04:00:00 | 05:15:00
Mon | Task C | 8 AM | 11 AM | 03:30:00 | 00:00:00 |  | Mon | Task C | 08:00:00 | 02:00:00
Mon | Task C | 10 AM | 5 PM | 04:30:00 | 02:00:00 |  | Mon Total |  | 08:00:00 | 03:30:00
Tue | Task A | 4 PM | 5 PM | 01:00:00 | 00:20:00 |  | Tue | Task A | 01:00:00 | 00:20:00
Tue | Task B | 8 AM | 12 PM | 04:00:00 | 00:00:00 |  | Tue | Task B | 06:30:00 | 00:00:00
Tue | Task B | 1 PM | 3 PM | 02:30:00 | 00:00:00 |  | Tue | Task C | 00:30:00 | 00:55:00
Tue | Task C | 3 PM | 4 PM | 00:30:00 | 00:00:00 |  | Tue Total |  | 08:00:00 | 01:15:00
Tue | Task C | 5 PM | 6 PM | 00:00:00 | 00:55:00 |  | Wed | Task A | 04:00:00 | 00:00:00
Wed | Task A | 8 AM | 12 PM | 04:00:00 | 00:00:00 |  | Wed | Task B | 04:00:00 | 00:00:00
Wed | Task B | 1 PM | 5 PM | 04:00:00 | 00:00:00 |  | Wed Total |  | 08:00:00 | 00:00:00
Fri | Task A | 8 AM | 10 AM | 02:30:00 | 00:00:00 |  | Fri | Task A | 02:30:00 | 00:30:00
Fri | Task A | 4 PM | 5 PM | 00:00:00 | 00:30:00 |  | Fri | Task B | 02:00:00 | 00:00:00
Fri | Task B | 10 AM | 12 PM | 02:00:00 | 00:00:00 |  | Fri | Task C | 03:30:00 | 00:00:00
Fri | Task C | 1 PM | 4 PM | 03:30:00 | 00:00:00 |  | Fri Total |  | 08:00:00 | 00:30:00
Sat | Task A | 9 AM | 1 PM | 04:00:00 | 00:00:00 |  | Sat | Task A | 04:00:00 | 00:00:00
Sat | Task B | 11 AM | 2 PM | 02:30:00 | 00:00:00 |  | Sat | Task B | 02:30:00 | 00:00:00
Thur | Task B | 9 AM | 11 AM | 02:30:00 | 00:00:00 |  | Sat Total |  | 06:30:00 | 00:00:00
Thur | Task C | 12 PM | 4 PM | 03:45:00 | 00:00:00 |  | Thur | Task B | 02:30:00 | 00:00:00
Thur | Task C | 4 PM | 5 PM | 01:15:00 | 00:00:00 |  | Thur | Task C | 05:00:00 | 00:00:00
Grand Total |  |  |  | 1900-01-02 04:00:00 | 05:15:00 |  | Thur Total |  | 07:30:00 | 00:00:00
 |  |  |  |  |  |  | Grand Total |  | 1900-01-02 04:00:00 | 05:15:00
Spreadsheet: 85722d1285771777-excel-2007-excel-2007-problem-with-cell-formulas-cash20102011
Sheet: SO's

 | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug
Bailey JMP
Bailey SGR
[NAME]
[NAME]
Boswell DW
Bowling P
Collins M
Crane G
Curtis R
Dearle JK
Dobb K&E
Dobb Eliz
Dodds J
Dodds M
[NAME]
Gall NA&CT
Grimes AC
Grimes HM
[NAME]
Haley J
[NAME]
Harris BP
[NAME]
Howkins DA
[NAME]
[NAME]
Luff A
Luff J
Luker W
[NAME]
Marriott MH
Marshall SW
Mills PH
[NAME]
Orchard AC
[NAME]
[NAME]
Pedley JG
Philpott B
Pillow J
Price CJ
Razetti J&C
Sanderson M
Sayers V
Scannell DJ
Stevenson JA&JP
[NAME]
[NAME]
[NAME]
Tebb MC
Temple Bone G
[NAME]
Walsh SJ
Weller E
White J&D
Willis A
Woodison PA
Spreadsheet: 704765d1605734236-link-error-messages-to-a-product-barcode
Sheet: Sheet2

Feilkode | Maskin | Feil
1 | Dimac | Kiling inngang
2 | Dimac | Flaskevelt
3 | Dimac | Sensor plasting
4 | Dimac | Camelon
5 | Dimac | Håndtakmaskin
Feilkode | Maskin | Feil
6 | [NAME] | Flaskevelt
7 | [NAME] | Kræsj maskin
8 | [NAME] | Vakumdrum
9 | [NAME] | [NAME]
10 | [NAME] | Laser dato
Feilkode | Maskin | Feil
11 | Robot | Flaskevelt
12 | Robot | Kræsj robot
13 | Robot | Dårlig pakker
14 | Robot | Pall
15 | Robot | Brett
Feilkode | Maskin | Feil
16 | ITO | Nødstopp
17 | ITO | Vilker
18 | ITO | Camelon
19 | ITO | [NAME]
20 | ITO | Utlasting
Spreadsheet: 33548d1230015318-developing-a-better-calculating-method-leavetrackerexcel
Sheet: data

RATE FOR LOOKUP | R-N | WORK SHOP FOR LOOKUP | W-N
CDR | 1 | LINE1 | 1
LCDR | 2 | "THE WARLORD THREE" | 2
LT | 3 | WARLORD THREE TOTALS | 3
LTJG | 4 | LINE2 | 4
ENS | 5 | ADMIN / 1ST. LT | 5
CWO5 | 6 | ADMIN / 1ST. LT TOTALS | 6
CWO4 | 7 | [NAME] | 7
CWO3 | 8 | MAINT ADMIN / CONTROL | 8
CWO2 | 9 | MAINT ADMIN / CONTROL TOTALS | 9
CWO1 | 10 | LINE4 | 10
CMDCM | 11 | QA | 11
ABCM | 12 | QA TOTALS | 12
ADCM | 13 | LINE5 | 13
AFCM | 14 | MATERIAL CONTROL | 14
AMCM | 15 | MATERIAL CONTROL TOTALS | 15
AOCM | 16 | LINE6 | 16
ATCM | 17 | AIRCRAFT DIVISION | 17
AWCM | 18 | AIRCRAFT DIVISION TOTALS | 18
AZCM | 19 | LINE7 | 19
PRCM | 20 | AV / ARM DIVISION | 20
SKCM | 21 | AV / ARM DIVISION TOTALS | 21
ABCS | 22 | LINE8 | 22
ADCS | 23 | ALSS DIVISION | 23
AECS | 24 | ALSS DIVISION TOTALS | 24
[NAME] | 25 | LINE9 | 25
AOCS | 26 | OPS | 26
ATCS | 27 | OPS TOTALS | 27
AWCS | 28 | [NAME] | 28
AZCS | 29 | DET ONE | 29
PRCS | 30 | DET ONE TOTALS | 30
SKCS | 31 | LINE11 | 31
ABC | 32 | DET TWO | 32
ADC | 33 | DET TWO TOTALS | 33
AEC | 34 | LINE12 | 34
AMC | 35 | DET THREE | 35
AOC | 36 | DET THREE TOTALS | 36
ATC | 37 | LINE13 | 37
AWC | 38 | DET FOUR | 38
AZC | 39 | DET FOUR TOTALS | 39
PRC | 40 | LINE14 | 40
SKC | 41 | DET FIVE | 41
YNC | 42 | DET FIVE TOTALS | 42
AB1 | 43 | LINE15 | 43
AB2 | 44 | DET SIX | 44
AB3 | 45 | DET SIX TOTALS | 45
ABAN | 46 | LINE16 | 46
[NAME] | 47 | DET ELEVEN | 47
ABAR | 48 | DET ELEVEN TOTALS | 48
ABF1 | 49 | LINE17 | 49
ABF2 | 50 | GO TO BOTTOM | 50
ABF3 | 51 | GO TO BOTTOM TOTALS | 51
ABFAN | 52
ABFAA | 53
ABFAR | 54
ABH1 | 55
ABH2 | 56
[NAME] | 57
ABHAN | 58
ABHAA | 59
ABHAR | 60
AD1 | 61
AD2 | 62
AD3 | 63
ADAN | 64
ADAA | 65
ADAR | 66
AE1 | 67
AE2 | 68
AE3 | 69
AEAN | 70
AEAA | 71
AEAR | 72
AF1 | 73
AF2 | 74
AF3 | 75
AFAN | 76
AFAA | 77
AFAR | 78
AFCM | 79
AM1 | 80
AM2 | 81
AM3 | 82
AMAN | 83
AMAA | 84
AMAR | 85
[NAME] | 86
AME2 | 87
AME3 | 88
AMEAN | 89
AMEAA | 90
AMEAR | 91
AO1 | 92
AO2 | 93
AO3 | 94
AOAN | 95
AOAA | 96
AOAR | 97
AT1 | 98
AT2 | 99
AT3 | 100
ATAN | 101
ATAA | 102
ATAR | 103
AW1 | 104
AW2 | 105
AW3 | 106
AWAN | 107
AWAA | 108
[NAME] | 109
AZ1 | 110
AZ2 | 111
AZ3 | 112
AZAN | 113
AZAA | 114
AZAR | 115
IS2 | 116
IS3 | 117
SH3 | 118
IT2 | 119
IT3 | 120
IT3 | 121
ITSN | 122
ITSA | 123
ITSR | 124
HMCM | 125
HM1 | 126
HM2 | 127
HM3 | 128
PR1 | 129
PR2 | 130
PR3 | 131
PRAN | 132
PRAA | 133
PRAR | 134
SK1 | 135
SK2 | 136
SK3 | 137
SKAN | 138
SKAA | 139
SKAR | 140
YN1 | 141
YN2 | 142
YN3 | 143
YNSN | 144
YNSA | 145
YNSR | 146
Spreadsheet: 32756d1228927113-help-with-xls-column-calculation-balance-1
Sheet: Sheet1

Debit Date | Item | Amount | Wage | Account Transfer | Interest | Balance
2009-01-01 00:00:00 | Current Balance |  |  |  |  | 10000
2009-01-01 00:00:00 | Groceries | 50
2009-01-01 00:00:00 | Petrol | 75
2009-01-01 00:00:00 | Electric | 50
2009-01-01 00:00:00 | [NAME] | 450
2009-01-01 00:00:00 |  |  |  | 74
2009-01-01 00:00:00 |  |  |  |  | 3.25
2009-01-01 00:00:00 | Tax refund | 10.5
Spreadsheet: cara_semperger__1441__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (4)

 |  |  | To Portland General Electric : [NAME], [NAME], and [NAME]
 |  |  | Phone 464-7067
 |  |  | From Enron: Cara, [NAME], and [NAME] |  |  |  |  |  | DAILY COLSTRIP = 0
 |  |  | Phone 464-3814, 3902, 3831 |  |  |  |  |  | MONTH LONG COLSTRIP = 47 ATC
 |  |  |  |  |  |  |  |  | PARKING MIDC B/R =  50 HLH
 |  |  |  |  | Mid Columbia Paths
2001-11-04 00:00:00
 | HLH
 | DAY | 25 | BPA C#23923-BPAP | X | PWX | ENRON | PGE | X | BPA(T)BPAP/PGE #96095HNF-USING YOUR TRANS PER PWX
 | DAY | 25 | BPA C#23923-BPAP | X | PWX | ENRON | PGE | X | BPA(T)BPAP/PGE #96095HNF-USING YOUR TRANS PER PWX
 | FLAT
 | MONTH | 25 | WWP(G)MIDC | X | WWP | ENRON | PGE | X | COLSTRIP B/R | 3
 | DAY | 22 | CHELAN(G)-IPCMO1-IDAC | X | EWEB | ENRON | PGE | X | COLSTRIP B/R | 3
 | MONTH COLSTRIP PATHS
 | ALL HOURS
 | MONTH | 6 |  | X | PGE | ENRON | ASHGROVE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 6 |  | X | PGE | ENRON | EXPRESS PIPE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 7 |  | X | PGE | ENRON | HOLNAM | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 8 |  | X | PGE | ENRON | LOUISIANA P | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 5 |  | X | PGE | ENRON | LUZENAC | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 15 |  | X | PGE | ENRON | SMURFIT | X | MPCO NETWORK TRANSMISSION TO LOAD
Spreadsheet: phillip_m_love__30681__ontario synthetic fin liq
Sheet: 0003

 |  |  | OA Variances - Fin Liq and Synthetic Storage
Prod Month | Counterparty | Trans Type | TAGG # | Amount | Offsetting TAGG # | Missing Annuities
0003 | Consumers | Financial | EX2872.9 | 2812890 | EX2872.10(April 2000)
 | Consumers | Financial | EX2872.7 | -195058 | EX2872.8(April 2000)
 | Consumers | Financial | EU1485.A | 4360027 | EU1485.9(Oct 1999)
 | Consumers | Financial | EU1485.8 | -392653.75 | EU1485.7(Oct 1999)
 | St- [NAME] | Financial | EW0842.1 | -96000 | EW0842.2(booked to INTRA CNT TRANS)
 | INTRA-CNT-TRANS | Financial | EY2207.1 | 98500 | Offset in Central(Jim Little)
 | Central | Financial | NA6779.1 | -93992 | Offset in Central(Jim Little)
 | Market East | Financial | NA6790.1 | -52359 | Offset in East(Jim Little)
 | FT-Ontario | Financial | NA9241.1-.4 | -10920 | Reclass to be done by [NAME]
 | Consumers | Buy | EU1485.C | -1388000 | EU1485.B(Dec 1999) | EU1485.D(Dec 1999)
 | Consumers | Buy | EU1485.G | -844806 | EU1485.E(Jan 2000) | EU1485.I(Jan 2000)
 | Consumers | Buy | EU1485.L | -875870 | EU1485.J(Feb 2000)
 | Consumers | Buy | N32106.6 | -233184 | N32106.5(Nov 1999) | N32106.4 & .8
 | Consumers | Buy | N36669.C | -496154 | N36669.9(Nov 1999) | N36669.F
 | Consumers | Sale | N32106.2 |  | Liq variance net of flash to actual variance
 | Consumers | Sale | N32106.4 | 13875 | Annuity for N32106.2 & .6
 | Consumers | Sale | N32106.8 | 10920 | Annuity for N32106.2 & .6
 | Consumers | Sale | N36669.4 |  | Liq variance net of flash to actual variance
 | Consumers | Sale | N36669.F | 23235 | Annuity for N36669.C
 | Consumers | Sale | EU1485 |  | No sale liquidation for this deal - this linked to the buy
 | Consumers | Sale | EX2872 |  | No sale liquidation for this deal - this linked to the buy
 | Transcanada | Sale | N36190.6 | 135639 | This is a swap - for Tolls - transport
 | Transcanada | Sale | N63076.2 | 794222 | This is a swap - for Tolls - transport
 | Transcanada | Sale | N63076.6 | 198387 | This is a swap - for Tolls - transport
 | Enron Canada | Buy | N36190.3 | -135639 | This is a swap - for Tolls - transport
 | Enron Canada | Buy | N63076.8 | -794222.49 | This is a swap - for Tolls - transport
 | Enron Canada | Buy | N63076.C | -198387 | This is a swap - for Tolls - transport
Spreadsheet: 485159d1476736862-sumproduct-with-other-sheets-and-criteria-sumproduct-with-criteria-bvj-v4
Sheet: Sheet3

 |  |  |  | M2 | DATE
 |  | Areas | Description | COSTs | Summary | M1 | M2 | M3 | TOTAL (m1 to m3) | M4 | M5 | M6 | TOTAL (m1 to m6) | M7 | M8 | M9 | M10 | M11 | M12 | Total M12
 |  | A1 | abadf | 99439 |  | 10 |  | 456 |  |  | 65423 |  |  |  | 45 |  | 435 |  | 435
 |  | A2 | sadad | 32432 |  | 5 | 24 |  |  |  | 54564 | 56 |  |  | 5956 |  |  | 8
 |  | A3 | dsafsfds | 3242 |  | 2 |  |  |  |  |  | 3 |  |  | 6 | 2 | 435 |  | 435
 |  | A4 | trhrth | 43556 |  | 20 | 234 | 34234 |  | 4 | 5 |  |  | 5 |  |  |  | 56
 |  | A5 | rth | 234234 |  | 304 |  |  |  |  |  | 4 |  |  | 4 | 5 | 889 |  | 435
 |  | A6 | [NAME] | 345345 |  | 405 |  |  |  | 53 |  | 4 |  |  | 5 |  | 345
 |  | A7 | [NAME] | 4353 |  | 435 | 3243 |  |  |  |  | 678 |  |  |  | 867 |  | 435
 |  | A8 | rth | 76786 |  | 45 |  |  |  | 768 | 67 | 7 |  |  |  |  |  |  | 435
 |  | A9 | hrth | 78876 |  |  |  |  |  |  | 234 |  |  |  | 7756454
 |  | A10 | rhrh | 76888 |  | 78 | 67 |  |  |  |  |  |  | 234 |  | 234
 |  | A11 | rhrtthr | 2343 |  | 67 |  |  |  | 34 |  |  |  |  | 234 |  | 435
 |  | A12 | rthrth | 34232 |  | 79 | 173 | 45 |  | 5856 |  | 738 |  |  | 358 | 56
Spreadsheet: 734426d1622147975-conditional-formatting-and-color-cells-with-formula-kopieplanning
Sheet: nl

Project | datum | vertrek | via | aankomst | Tijd | tijd grens | wie nederland | wie Duitsland | [NAME] | nummer | telefoon | tropcos | beg NL | Beg D
5258 |  |  | waldseite |  |  |  |  |  |  |  |  |  |  |  |  | 02:00:00
5259 |  |  | waldseite |  |  |  |  | nl
5259 |  |  |  |  |  |  | [NAME] | nl
5259 |  |  |  |  |  |  |  | nl
5259 |  |  |  |  |  |  |  | nl
5260 |  |  |  |  |  |  | [NAME] | nl
Spreadsheet: 75077d1275602353-combine-vlookup-with-offset-sample
Sheet: Sheet1

 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
A1 |  | 29937.5 | 29937.5 | 29937.5 | 29937.5 | 7983.333333333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 127733.3333333333
 |  | 0 | 95285.075 | 0 | 96793.925 | 0 | 90818.4 | 71454.825 | 117762.15 | 0 | 0 | 0 | 0 | 472114.375
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 29937.5 | 125222.575 | 29937.5 | 126731.425 | 7983.333333333333 | 90818.4 | 71454.825 | 117762.15 | 0 | 0 | 0 | 0 | 599847.7083333334
A2 |  | 29937.5 | 29937.5 | 29937.5 | 29937.5 | 29937.5 | 29937.5 | 29937.5 | 7983.333333333333 | 0 | 0 | 0 | 0 | 217545.8333333333
 |  | 0 | 139185.425 | 0 | 0 | 95285.075 | 0 | 96434.675 | 90818.4 | 71454.825 | 117762.15 | 0 | 0 | 610940.5499999999
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 29937.5 | 169122.925 | 29937.5 | 29937.5 | 125222.575 | 29937.5 | 126372.175 | 98801.73333333332 | 71454.825 | 117762.15 | 0 | 0 | 828486.3833333333
A3 |  | 0 | 0 | 52390.625 | 52390.625 | 52390.625 | 52390.625 | 52390.625 | 52390.625 | 52390.625 | 52390.625 | 52390.625 | 52390.625 | 523906.25
 |  | 0 | 0 | 27053.52083333333 | 0 | 33365.34375 | 0 | 57993.92708333334 | 0 | 0 | 39702.11458333334 | 0 | 40330.80208333334 | 198445.7083333333
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 79444.14583333333 | 52390.625 | 85755.96875 | 52390.625 | 110384.5520833333 | 52390.625 | 52390.625 | 92092.73958333334 | 52390.625 | 92721.42708333334 | 722351.9583333334
A1 | = | ?? | Problem: how to return the total of [NAME] ($599,848) or any other reference in column A using vlookup and offset or match and offset
Spreadsheet: 83816d1283862817-formula-involving-hyperlinks-example
Sheet: Summary

ITEM | DETAILS
DOG | CLICK
CAT
HORSE
DONKEY
PARROT
BIRD
ELEPHANT
GIRAFFE
[NAME]
ALLIGATOR
SNAKE
CROCODILE
[NAME]
RAT
GORILLA
MONKEY
HOUSE
CAR
RADIO
CRANBERRY
ORANGE
BLUE
APPLE
GREEN
Spreadsheet: 710331d1608847257-help-pulling-data-from-a-range-copy-of-attendance-template-w-formula
Sheet: August

Employee Absence Schedule
August | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | CI | T | NCNS | Total Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]