tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 877733d1724592678-help-please-mio-audit-pnc
Sheet: GP NOT POSTED

Batch Number | Voucher Number | Vendor ID | [NAME] | Document Type | Document Date | Document Number | Document Amount | Shipping Method | Voucher | GP NOT POSTED VENDOID | PNC Vendor number | GP NOT POSTED Doc Number value2 | PNC Inv number2 | Check | [NAME] | Check2 | APA Inv date | Check3 | [NAME] | Check4 | Check5 | Check6 | Comments |  | Checked
 | VCH0000000241347 | 03310 |  | Invoice | 2024-06-01 00:00:00 | MI18153 | 108.74
 | VCH0000000241348 | 03310 |  | Invoice | 2024-06-15 00:00:00 | MI18943 | 87.87
 | [NAME] | 03310 |  | Invoice | 2024-08-10 00:00:00 | MI21459 | 514.81
082124NO-01 | VCH0000000241350 | 00304 |  | Invoice | 2024-04-01 00:00:00 | [PHONE] | 1879.19
082124NO-01 | VCH0000000241351 | 00304 |  | Invoice | 2024-08-11 00:00:00 | [PHONE] | 988.95
082124NO-01 | VCH0000000241352 | 01433 | [NAME] CONTROLS | Invoice | 2024-03-22 00:00:00 | 24035649 | 606
082124NO-01 | VCH0000000241353 | 02102 | ITW GSE INC | Invoice | 2024-05-30 00:00:00 | 112181 | 5017.89 | DELIVERY
082124NO-01 | VCH0000000241354 | 02102 | ITW GSE INC | Invoice | 2024-08-08 00:00:00 | 113724 | 3209.4 | DELIVERY
082324NO-01 | VCH0000000241464 | 02261 | MAVICH LLC | Credit  Memo | 2024-08-01 00:00:00 | [PHONE] | 21.27
082324NO-01 | VCH0000000241465 | 02261 | MAVICH LLC | Credit  Memo | 2024-08-13 00:00:00 | [PHONE] | 68.14
Spreadsheet: 94095d1293932745-formula-for-sport-rankings-wrestlingleage
Sheet: 152

Weight | Ranking | First Name | Last Name | School | Section | Grade
152 | 1 | [NAME] | [NAME] | Sante Fe | SS | 11 | reno 3
152 | 2 | Victor | Pereira | Newark Memorial | NC | 11 | 201 CIF 5
152 | 3 | [NAME] | Hammond | Bakersfield | CS | 10 | 2010 CIF 4
152 | 4 | [NAME] | [NAME] | Camarillo | SS | 12 | 2010 CIF 6
152 | 5 | [NAME] | [NAME] | [NAME] | CS | 12 | reno 8
152 | 6 | Shervin | Iraniha | [NAME] | SD | 12
152 | 7 | [NAME] | Smith | Santiago | SS | 12
152 | 8 | [NAME] | Sotomayor | Centennial | CS | 12
152 | 9 | [NAME] | [NAME] | Oxnard | SS | 12
152 | 10 | [NAME] | [NAME] | Carlsbad | SD | 12
152 | 11 | Isiah | Morfin | Selma | CS | 11 | zink 1
152 | 12 | Dallas | Poston | Foothill | NC | 11 | reno t12
152 | 13 | [NAME] | Donahue | Poway | SD | 12 | reno t12
152 | 14 | Colby | Thompson | Clovis | CS | 11 | zink 3
Spreadsheet: 146122d1331908999-using-dropdown-lists-to-populate-range-of-cells-2-day-4-week
Sheet: Master

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Swim/Dive - Spring 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CORE | CL | SQ | BP | DL | OH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Train Max | 100 | 100 | 100 | 100 | 100
 | Monday | Week 1 |  |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4 |  |  |  |  |  |  |  |  |  |  |  | Monday | Week 1 |  |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4
 |  | % | GR | WT | RA | % | GR | WT | RA | % | GR | WT | RA | % | GR | WT | RA |  |  |  |  |  |  |  |  |  | % | GR | WT | RA | % | GR | WT | RA | % | GR | WT | RA | % | GR | WT | RA
UP | [NAME] | 0.3 | x10 |  |  | 0.3 | x10 |  |  | 0.3 | x10 |  |  | 0.3 | x10 |  |  |  |  |  |  |  |  |  | UP | [NAME] | 0 | x10 |  |  | 0 | x10 |  |  | 0 | [NAME] |  |  | 0.7 | [NAME]
EX |  | 0.5 | x4 |  |  | 0.5 | x4 |  |  | 0.5 | x4 |  |  | 0.5 | x4 |  |  |  |  |  |  |  |  |  | SL | Week 1: 5-1-X | 0.5 | 8 |  |  | 0.5 | 8 |  |  | 0.5 | 8 |  |  | 0.8 | x2
% | Programs | 0.65 | x5 |  |  | 0.7 | [NAME] |  |  | 0.65 | x5 |  |  | 0.4 | x5 |  |  |  |  |  |  |  |  |  | % | Week 2: 3-1-X | 0.75 | x5 |  |  | 0.8 | x5 |  |  | 0.85 | x5 |  |  | 0.92 | x1
1 |  | 0.75 | x5 |  |  | 0.8 | [NAME] |  |  | 0.75 | x5 |  |  | 0.5 | x5 |  |  |  |  |  |  |  |  |  | 1 |  | 0.75 | x5 |  |  | 0.8 | x5 |  |  | 0.85 | x5 |  |  | 0.92 | x1
 |  | 0.85 | x5+ |  |  | 0.9 | x3+ |  |  | 0.85 | [NAME] |  |  | 0.6 | x5 |  |  |  |  |  |  |  |  |  |  |  | 0.75 | x5 |  |  | 0.8 | x5 |  |  | 0.85 | x5 |  |  | 0.92 | x1
 |  |  |  |  |  |  |  |  |  | 0.95 | x1+
UB | Push Press |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UP | Push Press
V |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V
% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4
HIP | BB Overhead |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UP | Push Press
V |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V
% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | SH - UB - PZ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SH - UB - PZ
UP | Push Press |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UP | Push Press
0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
UP | Push Press |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UP | Push Press
UP | Push Press |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UP | Push Press
Spreadsheet: 80903d1281043559-linking-data-from-one-sheet-to-another-client-invoice-blank
Sheet: Sales Invoice

MEDICAL IMAGE WIGS..THE HAIR CENTRE
 |  |  |  | DATE: | 2010-06-08 00:00:00
603 Argus Rd., [NAME] 106
Oakville, ON L6J 6G6
Phone   [PHONE]   Fax [PHONE]
Toll free [PHONE]
 | Surname
[NAME] To: | Test Customer
Company | [NAME]'s Cosmetic Eyewear
Address | 123 Sesame St
City, Province | NY, NY
Postal code | 12345-6789
Telephone | 123-456-789
QUANTITY | [NAME] | Wig Color |  | UNIT PRICE | AMOUNT
1 | Wig Ultra 9000 | Teal |  | 99.97 | 99.97
1 | Wig Ultra 9000 | Fucia |  | 99.97 | 99.97
1 | Wig Ultra 9000 | Eggplant |  | 99.97 | 99.97
1 | Wig Ultra 9000 | Sea Foam |  | 99.97 | 99.97
 |  |  |  | SUBTOTAL | 399.88
CRANIAL PROSTHESIS AS PRESCRIBED BY PHYSICIAN |  |  |  | HST - 13% | 51.9844
 |  |  |  | SHIPPING & HANDLING | 25
 |  |  |  | TOTAL | 476.8644
[NAME]
No Returns. No Exchanges
 |  | We appreciate your business
Spreadsheet: 123497d1317688954-using-ranked-values-as-basis-for-formula-daddy_weapons
Sheet: Sheet1

Weapon Name | ATK SCORE | Owned |  | Helper
Far Wave | 48 | 2
[NAME] | 41 | 0
Type A PulserMG | 38 | 0
V2 Concussion | 33 | 75
F15 Red Matter Discharge | 27 | 30
Type-A Fusion Phaser | 26 | 0
V2 Ambush | 26 | 25
[NAME] | 23 | 0
M9 Beam Rifle | 20 | 201
[NAME] | 17 | 1
V2 [NAME] | 17 | 1
Spec5 Custom | 16 | 1
[NAME] | 12 | 1
K9 Magnetic | 12 | 1
9I Vapid | 9 | 1
[NAME] | 8 | 1
X11 Vector | 5 | 1
[NAME] | 4 | 1
[NAME] | 3 | 552
[NAME] | 1 | 1
Unix Pistol | 1 | 2
 |  |  |  | Formula 1 | Formula 2
Max # of Weapons | 250
Spreadsheet: 291769d1390402329-lookup-the-first-date-after-a-given-date-book2
Sheet: Sheet1

Client | Forename | Surname | Appointment | Confirmed | Course appointed | Available course 1 | Available course 2 | Available course 3 | Available course 4
1 | B | W | 2013-12-12 00:00:00 | x |  | 2014-01-13 00:00:00 | 2014-03-23 00:00:00 | 2014-05-16 00:00:00 | 2013-12-28 00:00:00
2 | S | J | 2013-12-13 00:00:00 | x |  | 2014-03-13 00:00:00 | 2014-03-23 00:00:00 | 2014-05-16 00:00:00 | 2014-01-28 00:00:00
3 | G | H | 2013-12-14 00:00:00 | x |  | 2014-04-13 00:00:00 | 2014-03-23 00:00:00 | 2014-01-16 00:00:00 | 2014-12-28 00:00:00
4 | C | D | 2013-12-15 00:00:00 | x |  | 2014-01-13 00:00:00 | 2014-03-23 00:00:00 | 2014-05-16 00:00:00 | 2013-12-28 00:00:00
5 | N | M | 2013-12-16 00:00:00 | x |  | 2014-01-13 00:00:00 | 2014-03-23 00:00:00 | 2014-05-16 00:00:00 | 2013-12-28 00:00:00
Spreadsheet: jonathan_mckay__17192__June Index Summary
Sheet: Tenn 800

EOL Transaction Summary Report
Criteria: | Traders
 | [NAME]
 | Product:
 | US Gas Phy Fwd
EnronOnline Report | All Counterparties
Product | Date-Time | Volume | Price
US Gas Phy       TENN 800                Jun01           USD/MM | 05/29/2001 09:58 am | 10000 | 3.8025
US Gas Phy       TENN 800                Jun01           USD/MM | 05/29/2001 12:16 pm | 5283 | 3.77
US Gas Phy       TENN 800                Jun01           USD/MM | 05/30/2001 08:34 am | 8229 | 3.595
US Gas Phy       TENN 800                Jun01           USD/MM | 05/30/2001 08:34 am | 10000 | 3.595
US Gas Phy       TENN 800                Jun01           USD/MM | 05/30/2001 08:35 am | 1771 | 3.585
US Gas Phy       TENN 800                Jun01           USD/MM | 05/30/2001 09:04 am | 414 | 3.565
US Gas Phy       TENN 800                Jun01           USD/MM | 05/30/2001 09:17 am | 1312 | 3.545
US Gas Phy       TENN 800                Jun01           USD/MM | 05/30/2001 09:21 am | 4700 | 3.5225
 | TOTAL VOLUME
Weighted Average
Spreadsheet: 856154d1705508673-count-distinct-values-help2
Sheet: Drop Down Menu

DROP DOWN MENU
 |  |  |  | <>
 |  |  |  | ACTON
Intensive Work Search |  | Yes |  | Brent
Light Touch - in work |  | No |  | Ealing
Light Touch - out of work |  | [NAME] District |  | Fulham
No Work Related Requirements |  | [NAME] |  | Harlesden
Work Focused Interview |  | Not Eligible Carer |  | [NAME]
Work Preparation |  | Not Eligible Claim Closed |  | [NAME]
Working enough |  | Not Eligible Health |  | Hounslow
 |  | Not Eligible Ineligible Partner |  | Kingston
IWS, Eligible & date <=today |  | Not Eligible Other |  | ShepherdBush
 |  | Not Eligible Provision |  | [NAME]
 |  | Not Eligible Regime Change |  | Uxbridge
 |  | Not Eligible Self-employed |  | Wandsworth
 |  | Not Eligible Working Enough
 |  | FTA, [NAME]
Spreadsheet: 0313efb6-5af0-4506-8bbd-ec38b30bb308
Sheet: INTRODUCTION

 | COST PER PERSON MODEL 2.0
 | INTRODUCTION
 | I. Introduction
 | The Cost Per Person Model 2.0 (CPPM) is an Excel-based tool designed to compute and benchmark the cost per person for workspace, information technology (IT), and telecommunications scenarios. The CPPM also calculates potential cost savings resulting from the use of alternative work environments, such as hoteling, or desk sharing.
 | II. Overview of CPPM Worksheet
 | The CPPM has tabs on the bottom of each screen which take the user to any of the model's sections:
 | CPPM | Allows users to input data and generate results.
 | GRAPHS | Illustrates cost per person results graphically.
 | CALCULATIONS | Provides explanation of total office workplace cost for organization, as well as cost per person.
 | SCENARIOS | Calculates potential net savings resulting from the use of alternate work environments.
 | SCENARIO GRAPHS | Illustrates scenario results graphically.
 | DEFINITIONS | Defines data inputs for CPPM.
 | III. Getting Started: Enabling Macros
 | Depending on your current computer setting, you may see a message regarding macros (Figure1) or a similar message. You will need to enable the spreadsheet macros by changing the macro security setting in the Trust Center (Figure 2). | Figure 1 - Enabling Macros
 | Click the Microsoft Office Button       , then click Excel Options. In the Trust Center category, click Trust Center Settings, and then click the Macro Settings category. Under Macro Setting, Enable All Macros. Close Excel file and reopen Cost Per Person Model. | Figure 2 - Trust Center
 | IV. Completing the CPPM Worksheets
 | Input data in only the un-shaded spreadsheet cells. Work through each component and use suggested values where applicable, or refer to the DEFINITIONS tab for more information.
 | Complete the CPPM worksheet from top to bottom, since some calculations depend on prior inputs.  The CPPM displays a Cumulative Cost Per Person at the top of each spreadsheet. This number shows the impact of a single model component on the total cost per person.  Click on the  CPPM CALCULATIONS  tab at any time for details of each calculation in the model.
 | To save the results under a new file name, click "Save As" on the Excel toolbar. A dialog box will ask you for a new file name. Once you enter the new file name, click "Close" to overwrite the existing file.
 | [NAME] Us
 | If you have questions or comments regarding the Cost Per Person Model 2.0, please contact [NAME], GSA's Office of Governmentwide Policy, at [PHONE] or [EMAIL].
Spreadsheet: 843931d1695748630-extracting-values-vertically-based-on-two-categories-book1
Sheet: Output

S.No. | Apple | Orange | Pineapple | Mango |  |  |  |  |  |  |  |  |  |  |  |  |  |  | India
 |  |  |  |  |  |  |  |  | Singapore |  | S.No. | Apple | Orange | Pineapple | Mango |  |  |  | Singapore
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nepal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | France
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USA
Spreadsheet: 718482d1613148297-how-to-use-conditional-format-for-3-different-digit-test
Sheet: Sheet2

 |  |  |  |  |  |  | 9 |  |  |  |  | 9
 |  |  |  |  |  |  | 10 |  |  |  |  | 10
 |  |  |  |  |  |  | 11 |  |  |  |  | 11
 |  |  |  |  |  |  | 12 |  |  |  |  | 12
 |  |  |  |  |  |  | 13 |  |  |  |  | 13
 |  |  |  |  |  |  | 14 |  |  |  |  | 14
 |  |  |  |  |  |  | 15 |  |  |  |  | 15
 |  |  |  |  |  |  | 16 |  |  |  |  | 16
 |  |  |  |  |  |  | 17 |  |  |  |  | 17
 |  |  |  |  |  |  | 18 |  |  |  |  | 18
Spreadsheet: 112412d1308570884-how-to-cross-reference-two-criteria-to-get-up-to-12-different-results-rag-rating-example
Sheet: Sheet1

 |  | [NAME]
 |  | Number of Services: Value of Package | 1 - 2 | 3 | 4+
 | 10+ | 10000 | R | R | R
 | (4-10000) | 4000 | A | A | R
 | (2-4000) | 2000 | G | A | A
 | (1-2000) | 1000 | G | G | G
 |  | Examples
 |  | Value | Services | Should be
 |  | 9000 | 2 | Amber
Spreadsheet: 777076d1650123502-pull-data-from-multiple-sheets-floor-stock-sheets-template
Sheet:  3rd 2003030

3rd Floor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Service Units
Item | Price | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Lemon Lime- Soda | 0.25
Diet Lemon Lime- Soda | 0.25
Cola- Soda | 0.25
Diet Cola- Soda | 0.25
Dr. [NAME] | 0.56
Coke | 0.56
Red Diamond Tea | 1
[NAME] | 0.71
[NAME] | 0.72
[NAME] | 0.08
[NAME] | 0.05
Broth, [NAME] | 0.1
Pudding-Vanilla | 0.27
[NAME] | 0.28
[NAME] | 0.28
Applesauce | 0.32
Juice Apple | 0.23
Juice Cranberry | 0.23
Juice Orange | 0.23
Juice Prune | 0.66
Ice Cream-Vanilla | 0.41
[NAME] cream | 0.43
Popcicles | 0.2
Diet Popsicles | 0.25
Milk, 2% | 0.25
Milk, [NAME] | 0.25
Salt/Pepper | 0.02
Mayo | 0.06
Mustard | 0.02
[NAME] | 0.02
[NAME] | 0.16
Ranch Dressing | 0.25
[NAME] House | 2.5
[NAME] | 1.47
Coffee, [NAME] cs. | 95.11
Coffee, Decaf  Prepack cs. | 37.84
Creamer, non dairy box | 0.03
Teabags | 0.03
Hydrolyte Honey Tea
Hydrolyte Honey Water
Hydrolyte Nectar Tea
Hydrolyte Nectar Water
Glucerna | 0.4
Jevity | 0.35
Vital | 3.05
Nepro | 1.03
[NAME] | 15.6
Osmolite | 0.25
Perative | 1.39
Promote | 0.23
Prune Juice | 0.66
Pulmocare | 0.44
2 Cal HN | 0.35
Pivot | 2.81
[NAME] | 1.5
Ensure | 0.13
Juven | 2.1
[NAME] | 1.75
Sugar | 0.02
Equal | 0.03
Splenda | 0.03
Sweet & Low | 0.02
cups | 0.03
Plastic Ware (fork,spoon knife) | 0.03
[NAME]-pkts. | 2.4
Refrigerator Thermometer (reg.)
Monthly Coffee
Monthly Total
Spreadsheet: michael_maggi__26472__NYMEXWEEKLYSTATS
Sheet: hu

Week Ending: | 2001-01-25 00:00:00
 | Futures Settlement Prices
 | UNLEADED GASOLINE |  |  |  |  | Contract Symbol:  [NAME]
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-01-21 00:00:00 | 2001-01-22 00:00:00 | 2001-01-23 00:00:00 | 2001-01-24 00:00:00 | 2001-01-25 00:00:00 | Interest
 | 2002-02-01 00:00:00 | CLOSED | 0.5479 | 0.5635 | 0.5685 | 0.5828 | 19397
 | 2002-03-01 00:00:00 | CLOSED | 0.5575 | 0.5738 | 0.5789 | 0.5912 | 36371
 | 2002-04-01 00:00:00 | CLOSED | 0.6275 | 0.6423 | 0.6479 | 0.6602 | 23851
 | 2002-05-01 00:00:00 | CLOSED | 0.6348 | 0.649 | 0.6571 | 0.6662 | 18263
 | 2002-06-01 00:00:00 | CLOSED | 0.637 | 0.6503 | 0.6541 | 0.6667 | 12988
 | 2002-07-01 00:00:00 | CLOSED | 0.6325 | 0.6448 | 0.6479 | 0.6607 | 9357
 | 2002-08-01 00:00:00 | CLOSED | 0.6215 | 0.6328 | 0.6351 | 0.6479 | 10997
 | 2002-09-01 00:00:00 | CLOSED | 0.6045 | 0.6148 | 0.6163 | 0.6291 | 10986
 | Total Weekly Volume
 |  |  |  |  | Total Open Interest |  | 143691
 |  |  |  | Weekly volume and open interest reflects all traded months.
 | Historical Volatility-Spot Month Futures
 |  |  |  | Unleaded Gas
 | 5 Day Hist. Vol. |  |  | 0.1405
 | 20 Day Hist. Vol. |  |  | 0.4749
 | Implied Volatility-Options |  |  | Unleaded Gas
 | At the Money Call & Put |  |  | 0.554
 | MON | TUE | WED | THUR | FRI | Total
Volume | CLOSED | 39655 | 35134 | 33590 | 36457
Spreadsheet: 755759d1637076327-nested-if-then-if-then-forum
Sheet: Sheet1

pt and total | I Heal / Epic | Reconciled ? | IDEAL
Blanch   1028.46 | BLANCH   1028.46
CPT4 Code   Total
11042   1028.46
Bobzin   1028.46 | BOBZIN   1028.46
CPT4 Code   Total
11042   1028.46
Brown   1445.21 | BROWN   1028.46 |  | Investigate
CPT4 Code   Total
11042   1028.46
99214   416.75
Brunner   289.52 | BRUNNER   0 |  | Investigate
CPT4 Code   Total
99212   289.52
Burch   1445.21 | BURCH   1239.45 |  | Investigate
CPT4 Code   Total
11042   1028.46
99214   416.75
Eodice   1028.46 | EODICE   1028.46
CPT4 Code   Total
11042   1028.46
Fearby   1028.46 | FEARBY   1028.46
CPT4 Code   Total
11042   1028.46
Fore   2987.9 | FORE   1753.68 |  | Investigate
CPT4 Code   Total
11042   1028.46
11045   1542.69
99214   416.75
Golden   1028.46 | GOLDEN   1028.46
CPT4 Code   Total
11042   1028.46
Spreadsheet: 1c0c7987-1437-4031-b588-e5569e50d612
Sheet: Worksheet

UNIVERSITY OF SOUTHERN QUEENSLAND
[NAME]
for the period ended 31 December 2010
60502 - Petty Cash/Cash Float
 | Description | Float | Petty Cash | Custodian | Comments
 | VC & University Services Divisions
 | VC, DVC (S), COO, SBMI, HR, DVC (GL), CFO, CTO |  |  | [NAME]
 | VC, DVC (S), COO, SBMI, HR, DVC (GL), CFO, CTO |  | 500 | [NAME]
 | VC, DVC (S), COO, SBMI, HR, DVC (GL), CFO, CTO |  | 500 | [NAME]
 | Uni Services (ICT, FM, Multicultural) |  | 500 | [NAME]
 | Uni Services (ICT, & any other Dept's as required) |  | 300 | [NAME]
 | Uni Services (ICT) |  | 300 | [NAME]
 | Uni Services (Financial Services) |  | 400 | [NAME]
 | Uni Services (Finance - Cashier Float) | 500 |  | [NAME]
 | Uni Services (Finance - Imprest) | 5000 |  | [NAME]
 | Uni Services (Finance - Cashier 2 Float) | 250 |  | [NAME]
 | Uni Services (Finance - Cashier 3 Float) | 250 |  | [NAME]
 | Uni Services (FM) |  | 700 | [NAME]
 | Scholarship Division
 | Scholarship Division (FOB) |  | 0 | [NAME] | Closed (secondment)
 | Scholarship Division (FOB, FOA, CAIK) |  | 0 | [NAME] | Closed (secondment)
 | Scholarship Division (FOB, FOS) |  | 500 | [NAME]
 | Scholarship Division (FOES) |  | 500 | [NAME]
 | Scholarship Division (FOES, FOE, FOS) |  | 500 | [NAME]
 | Scholarship Division (FOS) |  | 0 | [NAME] | Closed (secondment)
 | Scholarship Division (FOA) |  | 500 | [NAME]
 | Scholarship Division (FOA, FOE) |  | 400 | [NAME]
 | Scholarship Division (FOE) |  | 700 | [NAME]
 | Scholarship Division (FOES) |  | 700 | [NAME]
 | Scholarship Division (FOES) |  | 500 | [NAME]
 | Office of Research |  | 500 | [NAME]
 | Office of Research |  | 500 | [NAME]
 | GL Division
 | GL Division (DAIS, DEC, [NAME], LTSU, OAC, LA & SM) |  | 500 | [NAME]
 | GL Division (DAIS, DEC, [NAME], LTSU, OAC, LA & SM) |  | 500 | [NAME]
 | GL Division (DAIS, DEC, [NAME], LTSU, OAC, LA & SM) |  | 500 | [NAME]
 | GL Division (DAIS, DEC, [NAME], LTSU, OAC, LA & SM) |  | 500 | [NAME]
 | Non-Finance Float Custodians
 | Artsworx - Performance Centre | 700 | 400 | [NAME]
 | Artsworx - McGregor Schools |  | 400 | [NAME]
 | QCWT | 300 | 500 | Chrissy Mattiazzi
 | Fraser Coast |  | 1200 | [NAME]
 | CAIK |  | 200 | [NAME]
 | Springfield |  | 800 | [NAME]
 | Springfield [NAME] 1 | 250 |  | [NAME]
 | Library | 150 |  | [NAME]
 | NCEA/CRC |  | 800 | [NAME]
 | OAC - Study Tours |  | 3500 | [NAME]
 | USQ Bookshop |  |  | [NAME]
 | USQ Bookshop - Register 1 | 2000 |  | [NAME]
 | USQ Bookshop - Register 2 | 0 |  | [NAME]
 | Fraser Coast Bookshop |  |  | [NAME]
 | Residential Colleges |  | 300 | [NAME]
 | McGregor College | 100 |  | [NAME]
 | Steele Rudd College | 100 |  | [NAME]
 | Concannon College | 100 |  | [NAME]
 | Residential Colleges | 220 |  | [NAME]
 | DeC - Media Services | 150 |  | Liza Mattiazzi/[NAME]
 | Total Petty Cash & Floats per GL @ 31/12/10
Spreadsheet: 818533d1676902257-sundays-and-public-holidays-roaster-sundays-and-public-holidays-roaster
Sheet: Roaster

Sunday & Public Holidays Roaster 2023 |  |  |  |  |  |  |  |  | 1). Can these public holiday dates (from the sheet "Holidays") be automaticallly added ?
Staff | 2023-01-01 00:00:00 | 2023-01-02 00:00:00 |  |  |  | 2023-01-23 00:00:00 | 2023-01-24 00:00:00 | 2023-01-25 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2023-04-05 00:00:00 | . . .
Staff 1 | TD |  |  | TD |  |  | TD |  |  | TD |  |  | TD |  |  | TD
Staff 2 | TD |  |  | TD |  |  | TD |  |  | TD |  |  | TD |  |  | TD
Staff 3 |  | TD |  |  | TD |  |  | TD |  |  | TD |  |  | TD |  |  | TD
Staff 4 |  | TD |  |  | TD |  |  | TD |  |  | TD |  |  | TD |  |  | TD
Staff 5 |  |  | TD |  |  | TD |  |  | TD |  |  | TD |  |  | TD |  |  | TD
Staff 6 |  |  | TD |  |  | TD |  |  | TD |  |  | TD |  |  | TD |  |  | TD
 |  |  | 2). Is there any other smart formulas can display all Sundays in year 2023 ?
 | 2023-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-30 00:00:00 |  | . . .
Staff 1
Staff 2
Staff 3
Staff 4
Staff 5
Staff 6
Spreadsheet: 765787d1643599876-formula-for-missing-numbers-in-a-range-based-on-criteria-missing-number-wider-range-ans2
Sheet: Sheet1

Report # | Version # | Item #
20-A-1 | 0 | 1
20-A-1 | 0 | 3
20-A-1 | 1 | 1
20-A-1 | 1 | 5
21-B-2 | 0 | 1
21-B-2 | 0 | 2
21-B-2 | 1 | 1
21-B-2 | 1 | 3
21-B-2 | 1 | 13
Spreadsheet: 220688d1363235770-making-fully-automated-spreadsheet-big-excel-for-forum-help
Sheet: Site Progress

 | TS = Trouble Shoot
 |  |  | 2013-03-08 00:00:00 | 2013-03-15 00:00:00 | 2013-03-22 00:00:00 | 2013-03-29 00:00:00 | 2013-04-05 00:00:00 | 2013-04-12 00:00:00 | 2013-04-19 00:00:00 | 2013-04-26 00:00:00 | 2013-05-03 00:00:00
Site ID | PO | SOW | % Complete | % Complete | % Complete | % Complete | % Complete | % Complete | % Complete | % Complete | % Complete
 |  |  | 100
 |  |  | 90
 |  |  | 100
Spreadsheet: 873613d1720111046-return-specific-text-if-within-range-of-days-excel-help-date-range-lookup-example
Sheet: MASTER DATA - ALL BRANCHES

DAYS SINCE LAST USED | PIVOT CATEGORY (BRANCH SPECIFIC) | MANUALLY WRITTEN ANSWER (AS CHECK)
NEVER |  | NEVER
210.2685719560031 |  | 6-7 MONTHS
8.437299421297212 |  | 0-1 MONTHS
35.28513356480107 |  | 1-2 MONTHS
27.69366408570204 |  | 0-1 MONTHS
49.56036096059688 |  | 1-2 MONTHS
90.58421982639993 |  | 2-3 MONTHS
483.7035456829035 |  | 1-2 YEARS
224.3621806365991 |  | 7-8 MONTHS
331.7326639699022 |  | 10-11 MONTHS
34.74347233799926 |  | 1-2 MONTHS