tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 266520d1379642249-delete-rows-based-on-stored-values-in-a-seperate-sheet-book1
Sheet: Sheet3

color | month | year
green | January | 1932
red | February | 1933
yellow | March | 1934
green | April | 1935
red | May | 1936
yellow | June | 1937
green | July | 1938
red | August | 1939
yellow | September | 1940
green | October | 1941
red | November | 1942
yellow | December | 1943
green | January | 1944
red | February | 1945
yellow | March | 1946
green | April | 1947
red | May | 1948
yellow | June | 1949
green | July | 1950
red | August | 1951
yellow | September | 1952
green | October | 1953
red | November | 1954
yellow | December | 1955
green | January | 1956
red | February | 1957
yellow | March | 1958
green | April | 1959
red | May | 1960
yellow | June | 1961
green | July | 1962
red | August | 1963
yellow | September | 1964
green | October | 1965
red | November | 1966
yellow | December | 1967
green | January | 1968
red | February | 1969
yellow | March | 1970
green | April | 1971
red | May | 1972
yellow | June | 1973
green | July | 1974
red | August | 1975
yellow | September | 1976
Spreadsheet: 0948d153-9256-44af-8a94-e962234926f4
Sheet: Personnel Type Contracts

 |  | SFY 2014 STATE CODE SHEET
SFY 2014 STATE EDRS-UFARS codes crosswalk
UFARS Object Codes to EDRS Personnel Type Code
Contracted Services - SERVICE CODE B
UFARS OBJECT CODE | EDRS PTC | [NAME]
394 | 1 | Teacher (Requires Setting Code)
394 | 2 | Program Coordinator/Due Process Faciliator/Teacher on Special Education Assgnment (TOSA) (Non-Supervisory)
394 | 3 | Academic & Behavioral Strategist
394 | 4 | Physical Therapy Services
394 | 5 | Occupational Therapy Services
394 | 6 | School Nurse
394 | 7 | Educational Speech/Language Pathologist (Requires Setting Code)
394 | 8 | Paraprofessional/Personal Care Assistant
305 | 9 | Director of Special Education
305 | 10 | Assistant Director/Supervisor
394 | 11 | School Social Worker
394 | 12 | Cultural Liaison (Requires Activity Code)
394 | 13 | School Psychologist
394 | 14 | Audiologist
394 | 15 | Adaptive Physical Education Specialist
394 | 16 | Consultant (Prior Approval Required) (Requires Activity Code)
307 | 23 | Substitute Teachers
394 | 25 | Other Licensed/Certified Therapist - e.g. Music Therapist (Prior Approval Required)
394 | 26 | Foreign Language Interpreter
394 | 27 | Vision Media Assistant
394 | 28 | Interpreter for the Deaf
394 | 29 | Certified Orientation/Mobility Speciaist for Visually Impaired
394 | 34 | Assistative Technology Specialist
394 | 35 | School Counselor
394 | 37 | Certified Orientation/Mobility Assistant for Visually Impaired
394 | 38 | Security Specialist (Prior Approval Required)
394 | 40 | Social Worker for Interagency Activities
394 | 42 | Physician (Evaluation Only)
394 | 44 | Licensed Nursing Services
305 | 45 | Teacher Clerical Support Aide (Due Process)
394 | 48 | Behavioral Specialist
394 | 49 | Qualified Mental Health Professional
394 | 50 | Mental Health Behavioral Aide
394 | 52 | Mental Health Practitioner
394 | 53 | One - to -  One Paraprofessional
305 | 55 | Mentors for Interpreters of the Deaf & Hard of Hearing
394 | 57 | Contracted Therapeutic Recreational
307 | 58 | Substitute Para/PCA/One - to - One Para
394 | 59 | Speech/Language Pathology Assistant
394 | 60 | Special Transportation Nursing Services (IEP MA Reporting Only)
394 | 61 | Specail Transportation PCA Services (IEP MA Reporting Only)
394 | 62 | Extracurricular Activities (Staff Only) (Requires Activity Code)
394 | 63 | Licensed Staff Extra Duty Time
394 | 64 | Non-Licensed Staff Extra Duty Time
Spreadsheet: 0559ea4b-a207-4adb-b512-e445322d2c03
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
SCG BWF World Junior Championships 2013                                      23 October - 3 November , Bangkok Thailand
23 October - 3 November , Bangkok Thailand
Flights Schedules / transport request form
Name of Member Association
[NAME]
Group | (Passenger Group) Leader's Name | Date | Arrival  Time | Flight No. | No. of Passengers | Airport    (BKK or DMK)
1
2
3
4
5
6
7 |  |  |  |  | `
Departure
Group | (Passenger Group) Leader's Name | Date | Time | Flight No. | No. of Passengers | Airport    (BKK or DMK)
1
2
3
4
5
6
7 |  |  |  |  | `
- To be returned To [EMAIL]  not later than  October 12,  2013
- The transport desk is located at Gate 3  on the arrival floor
Spreadsheet: 869253d1715867517-meet-two-different-crieria-to-find-value-temp
Sheet: Sheet1

Reference | 2024-04-01 00:00:00 | 2024-04-02 00:00:00 | 2024-04-03 00:00:00 | 2024-04-04 00:00:00 | 2024-04-05 00:00:00 | 2024-04-07 00:00:00 | 2024-04-08 00:00:00 | 2024-04-09 00:00:00 | 2024-04-10 00:00:00 | 2024-04-11 00:00:00 | 2024-04-12 00:00:00 | 2024-04-15 00:00:00 | 2024-04-16 00:00:00 | 2024-04-17 00:00:00 | 2024-04-18 00:00:00 | 2024-04-19 00:00:00 | 2024-04-21 00:00:00 | 2024-04-22 00:00:00 | 2024-04-23 00:00:00 | 2024-04-24 00:00:00 | 2024-04-25 00:00:00 | 2024-04-26 00:00:00 | 2024-04-28 00:00:00 | 2024-04-29 00:00:00 | 2024-04-30 00:00:00
Test1
Test2
Test3
Test4
Test5
Test6
[NAME]
Test8
Spreadsheet: 743510d1628568000-vlookup-2-conditions-dau-etaf
Sheet: DAU

 | 2021-08-02 00:00:00 | 2021-08-03 00:00:00 | 2021-08-04 00:00:00 | 2021-08-05 00:00:00 | 2021-08-06 00:00:00 | 2021-08-07 00:00:00
[NAME]
[NAME]
[NAME]
[NAME] Nadeem
[NAME]
Rahmat
Spreadsheet: 155774d1337031313-combine-ranges-into-an-array-array-example-modified-by-tigeravatar-
Sheet: Sheet1

Create array from discontinous lists
Range Name | DATA  Source |  |  | Create This ARRAY
Project1 | 147500
 | 157600
 | 167700
 | 177800
 | #N/A
 | #N/A
Project2 | 162500
 | 172600
 | 177700
 | 182800
 | #N/A
 | #N/A
 | #N/A
Project3 | 147550
 | 157650
 | 167750
 | 177850
 | #N/A
 | #N/A
Project4 | 162575
 | 172675
 | 177775
 | 182875
 | 168350
 | #N/A
Spreadsheet: 98770d1297628125-text-function-codes
Sheet: Sheet1

 |  |  |  | Codes | Common Codes |  | List
 |  |  |  | ae-20-playtkaeen_12952 | playtkaeen
 |  |  |  | ae-20-plaarabic_296 | plaarabic |  | plaarabic
 |  |  |  | ae-20-arrabic_297 | N/A |  | playtkaeen
 |  |  |  | ae-20-maabic_298 | N/A |  | maabic
 |  |  |  | ae-20-parrabic_299 | N/A |  | anaabic
 |  |  |  | ae-20-anaabic_300 | N/A |  | sarabic
 |  |  |  | ae-20-sarabic_301 | N/A |  | parrabic
 |  |  |  | ae-20-playtkaeen_12952 | N/A
 |  |  |  | ae-20-playtkaeen_12952 | N/A
 |  |  |  | ae-20-playtkaeen_12952 | N/A
 |  |  |  | ae-20-parrabic_299 | N/A
 |  |  |  | ae-20-parrabic_299 | N/A
 |  |  |  | ae-20-parrabic_299 | N/A
 |  |  |  | ae-20-playtkaeen_12952 | N/A
 |  |  |  | ae-20-playtkaeen_12952 | N/A
 |  |  |  | ae-20-arrabic_297 | N/A
 |  |  |  | ae-20-arrabic_297 | N/A
 |  |  |  | ae-20-anaabic_300 | N/A
 |  |  |  | ae-20-anaabic_300 | N/A
 |  |  |  | ae-20-anaabic_300 | N/A
Spreadsheet: 751595d1634203923-if-cells-collumns-match-add-up-collumn-d-and-paste-result-to-other-sheet-example01
Sheet: Total

Poz | No | name | vnt | Ilgis | angl01 | angl02 | Bounding  Box  Length | Bounding  Box Width | Sheet  Metal  Thickness | MATERIA L
 |  |  | 65 |  |  |  | 800 | 400 | 9 | UPM [NAME]
 |  |  | 5 |  |  |  | 80 | 100 | 9 | UPM [NAME]
 |  |  | 51 |  |  |  | 530 | 300 | 9 | UPM [NAME]
 |  |  | 7 |  |  |  | 700 | 90 | 9 | UPM [NAME]
Spreadsheet: 0a171686-5ce6-4fae-9951-41a0210ffd1d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5302.0 Balance of Payments and International Investment Position, Australia
 | TABLE 83. EXCHANGE RATES - FINANCIAL YEAR
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
United States Dollar ;  Period average ; |  |  | Original | A3604466X | 1960-06-01 00:00:00 | 2012-06-01 00:00:00 | 53 | $ | INDEX | Annual | 6
United Kingdom Pound ;  Period average ; |  |  | Original | A3604465W | 1960-06-01 00:00:00 | 2012-06-01 00:00:00 | 53 | $ | INDEX | Annual | 6
Euro ;  Period average ; |  |  | Original | A3604467A | 1960-06-01 00:00:00 | 2012-06-01 00:00:00 | 53 | $ | INDEX | Annual | 6
[NAME] ;  Period average ; |  |  | Original | A3604463T | 1960-06-01 00:00:00 | 2012-06-01 00:00:00 | 53 | $ | INDEX | Annual | 6
Special Drawing Rights ;  Period average ; |  |  | Original | A3604468C | 1960-06-01 00:00:00 | 2012-06-01 00:00:00 | 53 | $ | INDEX | Annual | 6
United States Dollar ;  End of period ; |  |  | Original | A3605367K | 1960-06-01 00:00:00 | 2012-06-01 00:00:00 | 53 | $ | INDEX | Annual | 6
United Kingdom Pound ;  End of period ; |  |  | Original | A3605364C | 1960-06-01 00:00:00 | 2012-06-01 00:00:00 | 53 | $ | INDEX | Annual | 6
Euro ;  End of period ; |  |  | Original | A3605363A | 1960-06-01 00:00:00 | 2012-06-01 00:00:00 | 53 | $ | INDEX | Annual | 6
[NAME] ;  End of period ; |  |  | Original | A3605365F | 1960-06-01 00:00:00 | 2012-06-01 00:00:00 | 53 | $ | INDEX | Annual | 6
Special Drawing Rights ;  End of period ; |  |  | Original | A3605368L | 1960-06-01 00:00:00 | 2012-06-01 00:00:00 | 53 | $ | INDEX | Annual | 6
Trade Weighted Index ;  Period average ; |  |  | Original | A3604464V | 1960-06-01 00:00:00 | 2012-06-01 00:00:00 | 53 | Index Numbers | INDEX | Annual | 6
Trade Weighted Index ;  End of period ; |  |  | Original | A3605366J | 1960-06-01 00:00:00 | 2012-06-01 00:00:00 | 53 | Index Numbers | INDEX | Annual | 6
© Commonwealth of Australia  2012
Spreadsheet: 3b4c8b62-d3e7-455d-9b4d-f4c5de4c5b16
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (11 Entries):
 | 2 Analysis 2.8 Microscopes and optical image processing 2.8.15 Microscope image analysis
No. | Company | Country | City | [NAME] | Hall/Booth
1 | GE Healthcare | Germany | München | 80807 | A3.331/430
2 | Hamamatsu Photonics Deutschland GmbH | Germany | Herrsching | 82211 | A2.415/514
3 | [NAME] | Germany | Wetzlar | 35578 | A2.205/306
4 | Malvern Instruments GmbH | Germany | [NAME] | 71083 | A1.320
5 | Molecular Devices (Germany) GmbH | Germany | Biberach an der Riss | 88400 | A3.230A
6 | Motic Europe - Motic Deutschland GmbH | Germany | Wetzlar | 35578 | A2.127
7 | NIKON GmbH Mikroskope | Germany | [NAME] | 40472 | A2.103/204
8 | Olympus Deutschland GmbH Mikroskopie | Germany | Hamburg | 20097 | A2.311/410
9 | rap.ID Particle Systems GmbH | Germany | Berlin | 12555 | A2.434
10 | Sensovation AG | Germany | [NAME] | 78315 | A2.538
11 | TissueGnostics GmbH | Austria | [NAME] | 1020 | B1.148
Spreadsheet: tracy_geaccone__40323__3rd quarter curr est
Sheet: PRMA

DETAIL OF PRICE RISK MANAGEMENT ACTIVITIES
(Millions of Dollars)
 |  | Unrealized (Gain) / Loss on Price Risk Management Activities
 |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Total
Cash Flow
Originations |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Unrealized Activity |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Income Stmt Management Overview |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Settlements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Contract Monetization Inflows |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Contract Monetization Settlements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Prepaid Inflows |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Prepaid Settlements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Transfers |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
Total Change in PRM Activities (line 70)
Updated Jan. and Feb. to include $10.5 m cumulative effect of accounting change
Also includes mark to market adjustments
Spreadsheet: louise_kitchen__24135__people
Sheet: Sheet1

1 | Shively |  | 1 | Webb
2 | [NAME] |  | 2 | Colwell
3 | Belden |  | 3 | [NAME]
4 | Presto |  | 4 | Bradford
5 | [NAME] |  | 5 | [NAME]
6 | Benson |  | 6 | Sager
7 | Calger |  | 7 | Rub
8 | [NAME] |  | 8 | [NAME], [NAME]
9 | Milnthorp |  | 9 | Forster
10 | Motley |  | 10 | [NAME]
11 | Sturm |  | 11 | [NAME]
12 | Swerzbin |  | 12 | Belmont
13 | [NAME] |  | 13 | White
14 | Zuffferli |  | 14 | [NAME]
15 | Martin |  | 15 | Stock
16 | [NAME] |  | 16 | [NAME]
17 | Maggi |  | 17 | Scott, [NAME]
18 | [NAME] |  | 18 | Schneider
19 | Tycholiz |  | 19 | Reeves
20 | Richter |  | 20 | Port
21 | Crandell |  | 21 | [NAME]
22 | [NAME] |  | 22 | Nat
23 | Badeer |  | 23 | Montagne
24 | Black |  | 24 | Hodge
25 | Davies |  | 25 | McAuliffe
26 | Ermis |  | 26 | [NAME]
27 | [NAME] |  | 27 | [NAME]
28 | Cowan |  | 28 | [NAME]
29 | [NAME] |  | 29 | [NAME]
30 | Heizenrader |  | 30 | [NAME]
31 | Lagrasta |  | 31 | Gorny
32 | Lewis |  |  | Bracket
33 | May
34 | Mckay, [NAME]
35 | Brawner
36 | Luce
37 | McKay, [NAME]
38 | Vickers
39 | Choi
40 | Devries
41 | Le Dain
42 | [NAME]
43 | Rosman
44 | Redmond
45 | [NAME]
46 | [NAME]
47 | Dorland
48 | Fischer
49 | Gaskill
50 | Holst
51 | Mckay, [NAME]
52 | Keavey
53 | Schwieger
54 | [NAME]
55 | [NAME]
56 | Whitt
57 | Will
58 | Woulfe
59 | Zipper
60 | King
61 | [NAME]
62 | [NAME]
63 | Breslau
64 | Aucoin
65 | person x
66 | person x
67 | person x
68 | person x
69 | person x
70 | person x
71 | person x
72 | person x
73 | person x
74 | person x
75 | person x
Spreadsheet: 857025d1706118214-lookup-4000-lines-to-40-columns-nolook-nocoder-
Sheet: codes no header

 |  |  |  |  | Description | Transfer | CodeGroup | CodeType | PointLayer | [NAME] | PointColour | PointSize | PointModel | LineLayer | LineStyle | LineColour | LineThick | LineLTScale | TextLayer | TextStyle | TextColour | TextAlign | TextString | Field1
[SCAN]
Description | GPR Scan
Transfer
CodeGroup
CodeType | 0x0000000b
PointLayer | FPS-UG-GPR_SCAN
[NAME] | Dot
PointColour | 122
PointSize | 6
PointModel | 0
LineLayer | FPS-UG-GPR_SCAN
LineStyle | GPR Scan
LineColour | 122
LineThick | 0.09
LineLTScale | 0.1
TextLayer | FPS-UG-GPR_SCAN
TextStyle | Feature Text
TextColour | 122
TextAlign | 4
TextString | %I1%\n%REM%
Field1 | I1,"Scan No.",2,
[PFRL]
Description | Flat Roof Level
Transfer
CodeGroup
CodeType | 0x00000009
PointLayer | FPS-BUILDING
[NAME] | Plus
PointSize | 2
PointModel | 0
TextLayer | FPS-LEVELS
TextStyle | Feature Text
TextColour | 7
TextString | Flat Roof\n%.2PZ%
[AGP]
Description | AG-PIPEWORK
Transfer
CodeGroup
CodeType | 0x0000000b
PointLayer | FPS-AG-UNKNOWN
[NAME] | Dot
PointColour | 8
PointSize | 2
PointModel | 0
LineLayer | FPS-AG-UNKNOWN
LineStyle | Centre Half
LineColour | 8
LineForce | 0
LineThick | 0.09
LineLTScale | 0.1
TextLayer | FPS-AG-UNKNOWN-TEXT
TextStyle | Feature Text
TextColour | 8
TextAlign | 4
TextString | Above Ground Pipework
Spreadsheet: 874798d1721306045-sort-list-of-dates-times-wont-work-sorting-times-and-dates-vs4b
Sheet: Blad1

datum en tijd | datum en tijd
31-10-2017 10:33:00
31-10-2017 10:33:00
31-10-2017 10:33:00
31-10-2017 10:34:00
31-10-2017 10:34:00
31-10-2017 10:34:00
31-10-2019 10:45:01
31-10-2019 10:45:01
31-10-2019 10:45:01
31-10-2019 10:45:04
31-10-2019 10:45:04
31-10-2019 10:45:04
31-10-2023 07:47:40
31-10-2023 07:47:40
31-10-2023 07:47:40
31-10-2023 07:47:41
31-10-2023 07:47:41
31-10-2023 07:47:41
31-12-2018 10:19:00
31-12-2018 10:19:00
31-12-2018 10:19:00
31-12-2018 10:19:00
31-12-2018 10:19:00
31-12-2018 10:19:00
Spreadsheet: 867118d1713997220-changing-template-data-employee-absence-report-copy-
Sheet: November

 | Employee Absence Report
 | November
 | Absence type key | V | Vacation (10) |  |  | P | Paid (2) |  |  | S | Unpaid (1) |  |  | U | Unauthorized |  |  | O | Other
 |  | Dates of absence
 | 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 |  | Total days
 | [NAME]. M  (PMO)
 | [NAME]. P  (PMO)
 | [NAME]. R  (GL)
 | [NAME]. M  (GL)
 | Teddy. M  (GL)
 | Krushna. J  (DLO)
 | [NAME]. W  (PFO)
 | Jaxon. B  (PMO)
 | Daman. S (PMO)
 | Alvin. C  (GL)
 | Baldomero. N  (GL)
 | Junner. B  (GL)
 | Heather. C  (PFO)
 | Jordan. B  (LO)
 | Santos. C  (GL)
 | Sunny. I  (GL)
 | Oliver. M  (PR)
 | [NAME]. C  (TL)
 | Justin. H  (YFO)
 | [NAME]. M  (YFO)
 | [NAME]. T  (YFO)
 | [NAME]. B  (SHC)
 | [NAME]. H  (IM)
 | [NAME]. A  (IM)
 | [NAME]. M  (IM)
 | Maryanne. B  (IMA)
 | Art. P  (MF)
 | Fabrice. M  (MF)
 | [NAME]. T (IE)
 | [NAME]. P  (IE)
 | Justin. N  (IEA)
 | Paige. B  (WMR)
 | Maryann. R  (PSC)
Spreadsheet: 77758d1278229489-link-to-another-page-dummy
Sheet: Mar 2010

 |  |  |  |  |  |  |  | Payment total | Stock  bought total | Stock sold total | Carried forward | Brought forward
Date | Reference number | Details | Type | Payments | Stock bought | Stock Sold |  |  |  |  |  |  |  | Details list | Type list
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Wages | Sales invoice
 |  |  |  | 100 | 400 | 200 |  |  |  |  |  |  |  | Webpage hosting | Purchase invoice
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Postage stamps | Bank payment
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Office equipment | Bank receipt
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Drawings | Overdraft charge
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Materials & Stock
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Direct Costs
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff Wages
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Printing & Stationery
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sundries
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Telephone & Mobiles
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Internet
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel & Petrol
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sundry Motor Expenses
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Finance Charges
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Expenses
Spreadsheet: 40957d1239364990-copy-cell-based-on-data-in-another-cell-scorekeeping
Sheet: LVCG

 | Knightsleeper | LVBandit | Distractor_Beam | RogueMedic | DesertRipper | Delo85
Points | 40345 | 4305 | 40070 | 1800 | 9247 | 1280
With TK's | 40345 | 4305 | 38070 | 1800 | 9247 | 1280
EK's | 7806 | 755 | 8504 | 341 | 2688 | 226
TK's | 0 | 0 | -2000 | 0 | 0 | 0
Deaths | 48 | 3 | 60 | 3 | 43 | 11
Assists | 859 | 0 | 77 | 0 | 69 | 0
Shots/K | 8.780701754385966 | 6.307692307692307 | 2.322314049586777 | 2.4 | 5.394366197183099 | 72.64285714285714
Purple H | 19 | 3 | 20 | 2 | 11 | 0
Medic | 11 | 5 | 22 | 3 | 18 | 2
Drive | 4 | 0 | 2 | 0 | 1 | 0
Fly | 0 | 0 | 2 | 0 | 1 | 0
Boat | 0 | 0 | 0 | 0 | 0 | 0
Parachute | 19 | 1 | 22 | 2 | 5 | 0
LVCG
Points | With TK's | EK's | TK's | Deaths | Assists | Shots/K | Purple H | Medic | Drive | Fly | Boat | Parachute
97047 | 95047 | 20320 | -2000 | 168 | 1005 | 16.30798857528421 | 55 | 61 | 7 | 3 | 0 | 49
Spreadsheet: 775136d1648834302-how-to-assign-each-account-name-with-one-bucket-prob-1-
Sheet: Expected

 | Account Name | Groups
 |  | Group 1
 | BCD Corp | Group 3
 | HIJ Series | N/A
 | QDA Partners | N/A
 | EFG Ltd | Group 3
 | GIA Industries | Group 3
 | SDA Firm | Group 4
 | ARG Enterprises | Group 2
 | SOI Ltd | Group 4
 | Arcelor | Group 2
 | BRQ Stocks | Group 1
 |  |  | My logic is to use an if statement to assign each account with the groups I have categorised it into
Spreadsheet: 60129d1260662607-solving-a-multivariable-equation-with-excel-710598-solver-diophantine
Sheet: Sheet1

Variable | Value | Coeff1 | Coeff2 | Solver Model
t | 1 | 248 | 8 | 0
u | 0 | 145 | 3 | 7
v | 1 | 180 | 3 | 1
w | 0 | 290 | 7 | 100
x | 1 | 300 | 9
y | 0 | 90 | 2
z | 1 | 100 | 2 | [NAME]
 |  | 828 | 22 | C9 and across: =SUMPRODUCT($B2:$B8,C2:C8)
 | Target | 828 | 22 | C10 and across: Input
 | Error | 0 |  | C11: =SUMSQ(C9:D9-C10:D10)
Spreadsheet: 765078d1643149946-determining-work-time-based-on-criteria-book4
Sheet: Sheet1

 |  |  |  |  | `
 |  |  |  | Span
 |  |  |  | Report | 04:25:00 |  | 05:45:00 |  | 06:15:00 |  | 05:50:00
 |  |  |  | Start | 04:35:00 |  | 05:55:00 |  | 06:25:00 |  | 06:00:00
 |  |  |  | 1st End | 11:19:00 |  | 07:24:00 |  | 10:31:00 |  | 10:59:00
 |  |  |  | Half pay
 |  |  |  | Report | 14:30:00 |  | 11:13:00 |  | 13:50:00 |  | 14:30:00
 |  |  |  | Start | 14:40:00 |  | 11:13:00 |  | 14:00:00 |  | 14:40:00
 |  |  |  | 11th hr
 |  |  |  | 2nd end | 15:43:00 |  | 17:09:00 |  | 17:33:00 |  | 17:48:00
 |  |  |  | ST
 |  |  |  | OT
 |  |  |  |  |  |  |  | 08:00:00
Spreadsheet: gerald_nemec__11509__011201 HPL
Sheet: Itinerary Ops

Itinerary for Houston Region Operations
Week of January 15 - 19, 2001
 | Monday | Tuesday | Wednesday | Thursday | Friday | Pager #
CHERRY, STEVE | Holiday | Liberty | Pearland | [NAME] | BH | (281) 490-1484
HARWELL, DANA | Holiday | BH | BH | BH | BH | (281) 490-6874
KANTENBERGER, [NAME] | Holiday | BH | [NAME] | Field | [NAME] | (281) 665-3920
NEWMAN, [NAME] | Holiday | BH | Beeville | Tivolie | Enda / Wharton | (281) 264-9455
ROBINSON, DIANA | Holiday | BH | BH | BH | BH | (281) 262-3167
SHERIDAN, BILL | Holiday | Persall | Persall | Persall | Persall | (800)367-2431    PIN 3586
THOMPSON, CHARLIE | Holiday | BH / EB | BH | BH | BH | (713) 608-1022
[NAME], ANNA | Holiday | Corpus | Corpus | Corpus | Corpus | Office
BORDELON, ANJI | Holiday | Corpus | Corpus | Corpus | Corpus | Office
JURECEK, [NAME] | Holiday | Corpus | Vacation | Vacation | Vacation | (361)844-2111
HOWELL, [NAME] | Holiday | BH | BH | BH | BH | (800) 443-7243 PIN 006509
Spreadsheet: 116809d1312196394-order-form-vlookup-inv_sales_order-4-
Sheet: Sales Receipt

[Street Address] |  |  | RECEIPT  NO. | 14
[City, ST  ZIP Code] |  |  | DATE | 2003-01-22 00:00:00
[Phone] [Fax] |  | CUSTOMER ID |  | 14
[e-mail]
SOLD TO | 2
 | [Company Name]
 | 5
 | 1
 | 7
PAYMENT METHOD |  | CHECK NO. |  | JOB
QTY | ITEM # | [NAME] |  | UNIT PRICE | DISCOUNT | LINE TOTAL
4 | 1 | CD's | 100 | 0.5 | 0 | 2
1 | 3 | Paper Sleeves | 500 | 0.25 | 0 | 0.25
1 | 5 | 1 Hour of Video | #N/A | 5 | 0 | 5
 | #N/A |  | #N/A |  | 0
 | #N/A |  | #N/A |  | 0
 | #N/A |  | #N/A |  | 0
 | #N/A |  | #N/A |  | 0
 | #N/A |  | #N/A |  | 0
 | #N/A |  | #N/A |  | 0
 | #N/A |  | #N/A |  | 0
 | #N/A |  | #N/A |  | 0
 | #N/A |  | #N/A |  | 0
 | #N/A |  | #N/A |  | 0
 | #N/A |  | #N/A |  | 0
 | #N/A |  | #N/A |  | 0
 | #N/A |  | #N/A |  | 0
 | #N/A |  | #N/A |  | 0
 | #N/A |  | #N/A |  | 0
 |  |  | TOTAL DISCOUNT
 |  |  |  |  | SUBTOTAL | 7.25
 |  |  |  |  | SALES TAX
 |  |  |  |  | TOTAL | 7.25
Spreadsheet: 675751d1588464597-formula-average-with-conditions-averages-with-a-twist
Sheet: Sheet1

Rand | Helper |  | Average1 | << Average of All 20 Numbers
 |  |  | Answer 2 | << Average without [NAME] and Min
 |  |  | Answer 3 | << Average with no repeated numbers
 |  |  | Answer 4 | << Average no repeats and no [NAME] or Min
 |  |  |  |  | Note must use MaxIfs which you may not have.
 |  |  | Press F9 a few times to get random sets of numbers in Col A
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 13b

Product1 | HY6 | IG | Other | TOTAL
Index Tranche | 41878 | 401372 | 405925 | 849175
Europe | 0 | 0 | 400154 | 400154
North America/Asia | 41878 | 401372 | 5771 | 449021
Other | - | - | -
Index | 638617 | 2628995 | 3725333 | 6992945
Asia | 0 | 0 | 110881 | 110881
Europe | 0 | 0 | 3272056 | 3272056
North America | 638617 | 2628995 | 107968 | 3375580
Other | 0 | 0 | 234428 | 234428
OTHER* | 0 | 0 | 679009 | 679009
TOTAL | 680495 | 3030367 | 4810267 | 8521129
*OTHER variable includes exotic credit products, swaptions, and total return swaps.