tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 17169c6b-a12a-4ff1-8e14-595b5fc73f73
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
 | 5671.0 Lending Finance, Australia
 | TABLE 6. COMMERCIAL FINANCE COMMITMENTS, By Purpose (Fixed Loans): Australia, Original ($000)
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
Construction finance ; |  |  | Original | A2413488R | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Purchase of real property ; |  |  | Original | A2413489T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Wholesale finance ; |  |  | Original | A2413490A | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Purchase of plant and equipment ; |  |  | Original | A2413491C | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Refinancing ; |  |  | Original | A2413492F | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Other ; |  |  | Original | A2413493J | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2413494K | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Commitments not drawn at end of month ; |  |  | Original | A2413495L | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: joe_parks__14830__el paso wire request_lk
Sheet: WT 8-7-00

 | FOR SAP COMPANIES ONLY
 | Wire Transfer Request
 |  |  |  |  |  | DATE FUNDS TO BE WIRED (MMDDYY)
 |  |  |  |  |  | 2002-02-22 00:00:00
COMPANY NAME PAYING (PAYOR) |  |  |  |  | COMPANY NO. |  | BANK ACCOUNT
HPLC - Division of 58 |  |  |  |  | 1648 |  | 3750494141
Requestor | NAME |  |  |  |  | PHONE NO.
 | [NAME] |  |  |  |  | [PHONE]
 | DEPARTMENT
 | Gas Accounting
In payment of
 |  |  |  | INVOICE NUMBER |  |  | INVOICE DATE
 | COUNTRY | BANK KEY |  | BANK ACCOUNT NO. |  |  | BANK T (ROUTING ORDER)
 | US |  |  | 0209517 |  |  | 043000261
 | PAYEE NAME
Wire Funds To | El Paso Energy Marketing
 | PAYEE ADDRESS
 | CITY |  |  |  | STATE |  | COUNTRY
 |  |  |  |  |  |  | US
 | BANK NAME
 | Mellon Bank Pittsburgh
 | BANK ADDRESS
 | CITY |  |  |  | STATE |  | COUNTRY
 |  |  |  |  |  |  | US
 | REFERENCE MESSAGE ON WIRE (20 CHARACTERS)
 | Refund of payment that should have been paid to AEP
Accounting Code | Amount |  | Co Number | Tax Code | City/        outside city | ZIP where Consumed | Trading Partner
 |  |  | GL Account | Cost Center | Order | WBS Element
 |  |  | Network | Activity | Allocation |  | Profit Center
 |  |  |  | Material | Asset | Description
 | 154240 |  | 0364
 |  |  | 3000018982
 |  |  |  |  |  | refund money to El Paso
 |  |  | Total amount of wire.  Documentation supporting amount MUST be attached to form.
APPROVAL |  |  | DATE | APPROVAL |  |  | DATE
APPROVAL |  |  | DATE | APPROVAL |  |  | DATE
A/P MANAGER APPROVAL |  |  | DATE
Attach Supplemental Wire Transfer Request Form for further credit routing or additional account coding.
Spreadsheet: 751521d1634150371-help-to-create-an-order-list-based-on-products-by-cheapest-supplier-price-comparison-test
Sheet: CLEANING SUPPLIES

Product | Supplier | Price | Quantity | Unit Price | Date | % change | Product Code | Notes |  | PRODUCT | SUPPLIER | PRICE | PRODUCT CODE | CHEAPEST PRICE | FROM
Blue Centrefeed Roll | [NAME] | 10.13 | 6 |  |  |  | 1111 |  |  | Alu Traywash MD6 |  |  |  |  |  |  |  |  |  | Blue Centrefeed Roll |  |  |  |  | 0
Dishwash Detergent 20l | [NAME] |  | 1 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | Citrus Grove Airfreshner
Rinse Aid 20l | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dishwash Detergent 20l
Alu Traywash MD6 | [NAME] | 28.73 | 1 |  |  |  | 1111 | test |  |  |  |  |  |  |  |  |  |  |  | [NAME] Detergent 5l
[NAME] Detergent 5l | [NAME] | 3.53 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Aid 5l
[NAME] Aid 5l | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hand Towels Zig Zag
Jangro Supreme Washing Up Liquid 5l | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
K5 [NAME] | [NAME] | 7.21 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 5l
K4 Kitchen Sanitiser | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jangro Glass & Mirror Cleaner
W1 Washroom Cleaner | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jangro Supreme Washing Up Liquid 5l
Perfumed Toilet Cleaner | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jangro Toilet Rolls
[NAME] 5l | [NAME] | 5.41 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K4 Kitchen Sanitiser
Jangro Glass & Mirror Cleaner | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K5 [NAME]
[NAME] | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Perfumed Toilet Cleaner
Citrus Grove Airfreshner | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Poppies [NAME] (Box)
Poppies [NAME] (Box) | [NAME] | 26.93 | 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rinse Aid 20l
Jangro Toilet Rolls | [NAME] | 23.46 | 36 |  |  |  |  |  |  | PRODUCT | SUPPLIER | PRICE | DATE CHECK | DIFFERENCE | PRODUCT CODE | NOTES |  |  |  | W1 Washroom Cleaner
Hand Towels Zig Zag | [NAME] | 21.8 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: jane_tholt__13262__WestRateSheet
Sheet: CashVarRates

 |  |  | Firm | Firm | Firm | Flow |  |  |  |  | Firm | Firm | Firm | Flow
 | Mids | Spread | Fuel % | Comm $ | Variable | Economics |  |  | Mids | Spread | Fuel % | Comm $ | Variable | Economics
[NAME] |  |  |  |  |  |  |  | Waha
[NAME] |  |  |  | 0.026 |  |  |  | [NAME] |  |  |  | 0.0123
EPNG [NAME] |  |  |  | 0.0436 |  |  |  | EPNG [NAME] |  |  | 0.0096 | 0.0151
Waha |  |  |  | 0.0436 |  |  |  | EPNG [NAME]
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  | 0.0123
[NAME] |  |  |  | 0.026 |  |  |  | [NAME]
EPNG [NAME] |  |  |  | 0.0436 |  |  |  | Opal |  |  | 0.015 | 0.03
Waha |  |  |  | 0.0436 |  |  |  | TransCol CIG |  |  | 0.013 | 0.0043
SoCal TW Needles |  |  |  |  |  |  |  | PGT Stanfield |  |  | 0.015 | 0.03
TW Blanco |  |  | 0.0475 | 0.0164 |  |  |  | Sumas |  |  | 0.015 | 0.03
TW Permian |  |  | 0.05 | 0.0224 |  |  |  | Opal
[NAME] |  |  |  |  |  |  |  | Aeco |  |  | 0.03865
Kern Opal |  |  | 0.042 | 0.06 |  |  |  | Sumas |  |  | 0.015 | 0.03
[NAME] |  |  |  |  |  |  |  | CIG Mainline |  |  | 0.03 | 0
[NAME] |  |  | 0.011 | 0 |  |  |  | [NAME] |  |  | 0.03 | 0
PG&E Baja Pool |  |  |  |  |  |  |  | [NAME] |  |  | 0.015 | 0.03
[NAME] |  |  |  | 0.026 |  |  |  | CIG Mainline
EPNG [NAME] |  |  |  | 0.0436 |  |  |  | Opal |  |  | 0.03 | 0
TW Blanco |  |  | 0.0475 | 0.0164 |  |  |  | PEPL
TW Permian |  |  | 0.05 | 0.0224 |  |  |  | CIG Mainline |  |  | 0.03 | 0
Kern Opal |  |  | 0.042 | 0.06 |  |  |  | [NAME] |  |  | 0.03 | 0
Waha |  |  |  | 0.0436
PG&E CtyGte
[NAME] |  |  | 0.0137 | 0
PG&E Baja Pool |  |  | 0.0137 | 0
[NAME]
Sumas |  |  | 0.029074
Aeco |  |  | 0.03771 | 0.01742
Opal |  |  | 0.029074
Spreadsheet: 112690d1308734281-formula-for-average-copy-of-formula-needed
Sheet: STATS

Average of Total Score
Staff | Week # | Date | Total
Michelle | 23 | 2011-06-02 00:00:00 | 99.95454545454545
 |  | 2011-06-03 00:00:00 | 99.95
 | 23 Total |  | 99.953125
 | 24 | 2011-06-06 00:00:00 | 99.875
 |  | 2011-06-07 00:00:00 | 99.66666666666667
 |  | 2011-06-08 00:00:00 | 99.9375
 | 24 Total |  | 99.8125
Michelle Total |  |  | 99.8828125
Spreadsheet: 723790d1615898933-formula-if-one-or-more-the-cells-within-a-selection-of-cells-contains-text-then-change-tex-dailymanagement-test3
Sheet: Dashboard

 | Day 1 | Day 2 | Day 3
Employees
Managers
Spreadsheet: 54200d1254228441-is-it-possible-to-do-vlookup-with-criteria-sampledata
Sheet: Sheet1

 |  |  | TABLE A |  |  |  |  | TABLE B
 |  | REF | NAME | OP CODE |  |  | OP CODE | NAME
 |  | ABC | J Jones |  |  |  | JEJ | [NAME]
 |  | EFG | A [NAME] |  |  |  | AMK | [NAME]
 |  | HIJ | H Patel |  |  |  | HAP | [NAME]
 |  | KLM | S Smith |  |  |  | SHS | [NAME]
 |  | NOP | J Maxwell |  |  |  | JOM | [NAME]
 |  | QRS | T Harding |  |  |  | TIH | [NAME]
 |  | TUV | A Guerero |  |  |  | ARG | [NAME]
 |  | WXY | L Williams |  |  |  | LAW | [NAME]
 |  | ZAB | K Brooke |  |  |  | KEB | [NAME]
Spreadsheet: 200496d1355578157-help-for-sorting-winner-unique-race-winner
Sheet: Sheet1

BIB number | Name | Time | Race bib number winner |  | BIB number | Name | Time | unique rank
502 | ally | 00:00:25 | 502         ally |  | 502 | ally | 00:00:25 | 1 | 502         ally
515 | [NAME] | 00:00:40 | 515         jhun |  | 515 | [NAME] | 00:00:40 | 2 | 515         jhun
420 | kate | 00:01:02 | 420         kate |  | 420 | kate | 00:01:02 | 3 | 420         kate
403 | hazel | 00:01:22 | 403         hazel |  | 403 | hazel | 00:01:55 | 8 | 500         esteban
500 | esteban | 00:01:28 | 500         esteban |  | 500 | esteban | 00:01:28 | 4 | 423         haily
423 | haily | 00:01:39 | 423         haily |  | 423 | haily | 00:01:39 | 5 | 408         netnet
408 | netnet | 00:01:49 | 408         netnet |  | 408 | netnet | 00:01:49 | 6 | 499         shiela
499 | [NAME] | 00:01:55 | 499         shiela |  | 499 | [NAME] | 00:01:55 | 7 | 403         hazel
566 | joel | 00:02:03 | 566         joel |  | 566 | joel | 00:02:03 | 9 | 566         joel
528 | bugoy | 00:02:14 | 528         bugoy |  | 528 | bugoy | 00:02:14 | 10 | 528         bugoy
455 | nena | 00:02:26 | 455         nena |  | 455 | nena | 00:02:26 | 11 | 455         nena
 |  |  | assuming no ties |  |  | if there maybe ties rank unique then index/match that
Spreadsheet: 646b35df-48e0-4b70-859e-77e5230df143
Sheet: CDS-A

A.  General Information
A0 | Respondent Information (Not for Publication)
A0 | Name: |  | [NAME]
A0 | Title: |  | Research Analyst
A0 | Office: |  | Institutional Research
A0 | Mailing Address: |  | 3645 W. 112th Ave
A0 | City/State/Zip/Country: |  | Westminster, CO 80031
A0 | Phone: |  | (303) 404-5671
A0 | Fax: |  | (303) 404-5693
A0 | E-mail Address: |  | [EMAIL]
A0 | Are your responses to the CDS posted for reference on your institution's Web site? |  |  | Yes | No
 |  |  |  | X
A0 | If yes, please provide the URL of the corresponding Web page:
A0A | We invite you to indicate if there are items on the CDS for which you cannot use the requested analytic convention, cannot provide data for the cohort requested, whose methodology is unclear, or about which you have questions or comments in general. This information will not be published but will help the publishers further refine CDS items.
A1 | Address Information
A1 | Name of College/University: | Front Range Community College
A1 | Mailing Address: | 3645 W. 112th Ave.
A1 | City/State/Zip/Country: | Westminster, CO 80031
A1 | Street Address (if different):
A1 | City/State/Zip/Country:
A1 | Main Phone Number: | [PHONE]
A1 | WWW Home Page Address: | www.frontrange.edu
A1 | Admissions Phone Number: | [PHONE]
A1 | Admissions Toll-Free Phone Number:
A1 | Admissions Office Mailing Address:
A1 | City/State/Zip/Country:
A1 | Admissions Fax Number: | [PHONE]
A1 | Admissions E-mail Address:
A1 | If there is a separate URL for your school’s online application, please specify: ______________
A1 | If you have a mailing address other than the above to which applications should be sent, please provide:
A2 | Source of institutional control (Check only one):
A2 | Public | X
A2 | Private (nonprofit)
A2 | Proprietary
A3 | Classify your undergraduate institution:
A3 | Coeducational college | X
A3 | Men's college
A3 | Women's college
A4 | Academic year calendar:
A4 | Semester | X
A4 | Quarter
A4 | Trimester
A4 | 4-1-4
A4 | [NAME]
A4 | Differs by program (describe):
A4 | Other (describe):
A5 | Degrees offered by your institution:
A5 | Certificate | X
A5 | Diploma
A5 | Associate | X
A5 | Transfer Associate | X
A5 | Terminal Associate | X
A5 | Bachelor's
A5 | Postbachelor's certificate
A5 | Master's
A5 | Post-master's certificate
A5 | Doctoral degree research/scholarship
A5 | Doctoral degree – professional practice
A5 | Doctoral degree -- other
A5 | Doctoral degree -- other
Spreadsheet: 84684d1284706566-iteration-and-compare-on-two-cols-diff-length-t3_t1_analysisshort
Sheet: Analysis

Forename | Surname | Reg | Subject T3 | Eff Result T3 | Eff T1 |  |  |  |  |  |  | Forename | Surname | Reg | [NAME] | Eff Result T1 Concerns
Game | Achakulwisut | B10 | E Ar | 1 |  |  |  |  |  |  |  | Game | Achakulwisut | B10 | E Gg | 1
Game | Achakulwisut | B10 | E Dr | 1 |  |  |  |  |  |  |  | Game | Achakulwisut | B10 | E En | 1
Game | Achakulwisut | B10 | E Sc | 1 |  |  |  |  |  |  |  | Game | Achakulwisut | B10 | E Th | 2
Game | Achakulwisut | B10 | E Ma | 1 |  |  |  |  |  |  |  | [NAME] | [NAME] | B10 | E Hi | 1
Game | Achakulwisut | B10 | E IT | 1 |  |  |  |  |  |  |  | [NAME] | [NAME] | B10 | E En | 1
Game | Achakulwisut | B10 | E Mu | 1 |  |  |  |  |  |  |  | [NAME] | [NAME] | B10 | E Th | 2
Game | Achakulwisut | B10 | E PE | 1 |  |  |  |  |  |  |  | Preoy | [NAME] | B10 | E Ar | 1
Game | Achakulwisut | B10 | E Hi | 1 |  |  |  |  |  |  |  | Preoy | [NAME] | B10 | E Hi | 2
Game | Achakulwisut | B10 | E Ts | 1 |  |  |  |  |  |  |  | Preoy | [NAME] | B10 | E En | 3
Game | Achakulwisut | B10 | E Rs | 1 |  |  |  |  |  |  |  | First | Hunsajarupan | B10 | E Th | 2
Game | Achakulwisut | B10 | E Gg | 1 | 1 |  |  |  |  |  |  | Fond | [NAME] | B10 | E Gg | 1
Game | Achakulwisut | B10 | E En | 1 | 1 |  |  |  |  |  |  | Fond | [NAME] | B10 | E Hi | 2
Game | Achakulwisut | B10 | E Th | 1 | 2 |  |  |  |  |  |  | [NAME] | Mettakhun | B10 | E Bi | 4
[NAME] | [NAME] | B10 | E Ar | 2 |  |  |  |  |  |  |  | [NAME] | Mettakhun | B10 | E Gg | 2
[NAME] | [NAME] | B10 | E Dr | 1 |  |  |  |  |  |  |  | [NAME] | Mettakhun | B10 | E Th | 2
[NAME] | [NAME] | B10 | E Sc | 1 |  |  |  |  |  |  |  | Puen | Naripthaphan | B10 | E Gg | 1
[NAME] | [NAME] | B10 | E Ma | 1 |  |  |  |  |  |  |  | Puen | Naripthaphan | B10 | E Bi | 4
[NAME] | [NAME] | B10 | E IT | 1 |  |  |  |  |  |  |  | Mone | Paditporn | B10 | E Ma | 2
[NAME] | [NAME] | B10 | E Mu | 2 |  |  |  |  |  |  |  | Mone | Paditporn | B10 | E Gg | 1
[NAME] | [NAME] | B10 | E PE | 2 |  |  |  |  |  |  |  | Kwan | Panyawanich | B10 | E Gg | 1
[NAME] | [NAME] | B10 | E Hi | 2 | 1 |  |  |  |  |  |  | Kwan | Panyawanich | B10 | E En | 3
[NAME] | [NAME] | B10 | E Ts | 3 |  |  |  |  |  |  |  | Kwan | Panyawanich | B10 | E Th | 2
[NAME] | [NAME] | B10 | E Rs | 2 |  |  |  |  |  |  |  | Kwan | Panyawanich | B10 | E Bc | 2
[NAME] | [NAME] | B10 | E Gg | 3 |  |  |  |  |  |  |  | Lily | [NAME] | B10 | E En | 1
[NAME] | [NAME] | B10 | E En | 1 | 1 |  |  |  |  |  |  | Lily | [NAME] | B10 | E Th | 2
[NAME] | [NAME] | B10 | E Mn | 2 |  |  |  |  |  |  |  | Lily | [NAME] | B10 | E Gg | 1
[NAME] | [NAME] | B10 | E Th | 2 | 2 |  |  |  |  |  |  | Grace | [NAME] | B10 | E Hi | 1
Preoy | [NAME] | B10 | E Ar | 1 | 1 |  |  |  |  |  |  | Grace | [NAME] | B10 | E En | 1
Preoy | [NAME] | B10 | E Dr | 1 |  |  |  |  |  |  |  | Nean | Suphantanida | B10 | E Th | 2
Preoy | [NAME] | B10 | E Sc | 1 |  |  |  |  |  |  |  | Nean | Suphantanida | B10 | E Ar | 1
Preoy | [NAME] | B10 | E Ma | 1 |  |  |  |  |  |  |  | Nean | Suphantanida | B10 | E Bi | 4
Spreadsheet: 198832d1354905882-display-all-rows-when-condition-is-true-book1
Sheet: esp

email | order | date | amount
customer15emailaddress.com | agd2523 | 2012-11-29 00:00:00 | 252
customer1emailaddress.com | agd1002 | 2012-12-01 00:00:00 | 5625
customer18emailaddress.com | agd586 | 2012-12-05 00:00:00 | 585
customer5emailaddress.com | agd1006 | 2012-12-04 00:00:00 | 45
customer16emailaddress.com | agd6852 | 2012-12-07 00:00:00 | 658
customer6emailaddress.com | agd1006 | 2012-12-04 00:00:00 | 45
customer10emailaddress.com | agd256 | 2012-12-01 00:00:00 | 6585
customer14emailaddress.com | agd635 | 2012-11-27 00:00:00 | 693
customer19emailaddress.com | agd963 | 2012-11-26 00:00:00 | 584
customer20emailaddress.com | agd85 | 2012-11-08 00:00:00 | 635
Spreadsheet: 699055d1602358421-read-a-cell-value-from-the-cluster-of-small-tables-score
Sheet: Women

Sys. BP |  | Non-smoker |  |  |  |  |  | Smoker |  |  |  |  |  | Age
180 |  | 7 | 8 | 9 | 10 | 12 |  | 13 | 15 | 17 | 19 | 22 |  | 65
160 |  | 5 | 5 | 6 | 7 | 8 |  | 9 | 10 | 12 | 13 | 16
140 |  | 3 | 3 | 4 | 5 | 6 |  | 6 | 7 | 8 | 9 | 11
120 |  | 2 | 2 | 3 | 3 | 4 |  | 4 | 5 | 5 | 6 | 7
180 |  | 4 | 4 | 5 | 6 | 7 |  | 8 | 9 | 10 | 11 | 13 |  | 60
160 |  | 3 | 3 | 3 | 4 | 5 |  | 5 | 6 | 7 | 8 | 9
140 |  | 2 | 2 | 2 | 3 | 3 |  | 3 | 4 | 5 | 5 | 6
120 |  | 1 | 1 | 2 | 2 | 2 |  | 2 | 3 | 3 | 4 | 4
180 |  | 2 | 2 | 3 | 3 | 4 |  | 4 | 5 | 5 | 6 | 7 |  | 55
160 |  | 1 | 2 | 2 | 2 | 3 |  | 3 | 3 | 4 | 4 | 5
140 |  | 1 | 1 | 1 | 1 | 2 |  | 2 | 2 | 2 | 3 | 3
120 |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 2 | 2 | 2
180 |  | 1 | 1 | 1 | 2 | 2 |  | 2 | 2 | 3 | 3 | 4 |  | 50
160 |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 2 | 2 | 2 | 3
140 |  | 0 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 2
120 |  | 0 | 0 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1
180 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 1 | 1 |  | 40
160 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
140 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
120 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
Spreadsheet: 877135d1723810904-custom-data-validation-personal-budget-template
Sheet: Instructions

Entering Transactions:
1 | Start by clikcing the [NAME] and Income tab at the bottom of the screen.
2 | Enter the proper date in the first or next empty space in the date column.
3 | In the IN/OUT field click, (tab or arrow) into the box and a drop down option with appear, Select if it is income or outgoing money
4 | In the Category field, (tab or arrow) into the box and a drop down option will appear, Select which category your income or outgoing money is from
5 | In the [NAME] field, click (tab or arrow) into the box and add any thing you need in here.
6 | Click (tab or arrow) into the corresponding [NAME] or [NAME] fields according to your expense and just enter numbers, No $ needed
7 | New information will always start with the date field and repeat these steps.
Adding/Changing Outgoing expenses or Income Expenses
1 | Click on the [NAME] and Income tab at the bottom
2 | On the Right sid eof the screen you will see a list of Out going expenses and a short list of Income Expenses under that. (Column K)
3 | If you need to change any expense name (either Outgoing or Income) simply click on a name you want to change and change it. It will not rememeber what it was, it will change it for everything everywhere.
4 | If you nee to add something new Just click in the first empty cell in the category and add the name of your choosing.
5 | If you need more rows to add additional items, find a little green arrow in the bottom right corner of the last cell in the table hover your mouse over it, it should turn your mouse into a double direction angled arrow. Left click and hold, and drag straight down to add more rows
6 | If you need to remove rows, do the same as above but drag staright up, the table will shrink but may leave some values but will be outsid eof a 2 tones table. This information can simply be higlighted and deleted.
Adding a Budget Value
1 | If you want to add a budget value to the data click on the [NAME] and Income Tab
2 | Just enter a value in row L under the catagories you wish to track. This can be any value you want.  [NAME] should be a value you do not want to go over every month.  Income should be somehting you would like to at least bring in.
Working the [NAME] tabs
Monthly
1 | Click on [NAME])
2 | At the top of the page is a Month and a year
3 | Click on the Month and a dropdown box will appear, select the month you wish to view.
4 | Click on the Year and a dropdown box will appear , Select the year you wish to view.
Yearly
1 | Click on Dashboard(Year)
2 | At the top of the page is a year
3 | Click on the Year and a dropdown box will appear , Select the year you wish to view.
Spreadsheet: 56133204-5721-45a1-a059-c9d8f755f483
Sheet: Sheet1

City Officials Statements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
For Quarter Ending 3/31/2009
(As of 4/16/2009)
Name | Title | Personal Benefits Reported | City Benefits Reported
Adams, Sam | Mayor | 640
Ames, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | Portland Development Commission Member
Birge, [NAME] | At-will staff for Mayor [NAME] |  | 200
Blackmer, [NAME] | City Auditor
Bogue, Emerald | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
Fish, [NAME] | Commissioner | 284.7
Fritz, Amanda | Commissioner
Hanson, [NAME] | Portland Planning Commission Member
Jimenez, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | Director of Bureau of Fire, Rescue and Emergency Services | 100
Leonard, [NAME] | Commissioner
[NAME], [NAME] | At-will staff for Mayor [NAME]
Lord II, Reese | At-will staff for Mayor [NAME]
Marriott, [NAME] | Director of Bureau of Environmental Services
[NAME], [NAME] | At-will staff for Mayor [NAME]
Neal, Clay | At-will staff for Mayor [NAME]
[NAME], Skip | At-will staff for Mayor [NAME]
Oppenheim, [NAME] | At-will staff for Mayor [NAME] | 50
[NAME], [NAME] | At-will staff for Mayor [NAME]
Ponder, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME] | 70 | 483
Ruiz, [NAME] | At-will staff for Mayor [NAME] | 45
Saltzman, [NAME] | Commissioner | 62
[NAME], [NAME] | Director of Bureau of Development Services
Schneider, Kimberly | At-will staff for Mayor [NAME] | 25
[NAME], [NAME] | Director of Bureau of Police | 120
Stringfield, Sierra | At-will staff for Mayor [NAME]
Uwagbae, Grace | At-will staff for Mayor [NAME]
Yocom, [NAME] | At-will staff for Mayor [NAME] | 25
Spreadsheet: 455336d1460247099-use-vlookup-to-retrieve-a-value-based-on-a-word-within-a-cell-example
Sheet: Sheet A

URL New | URL | Title
 | http://oldsiteexample.com/home | Home
 | http://oldsiteexample.com/products | Products
 | http://oldsiteexample.com/newsflash | Newsflash from the World
 | http://oldsiteexample.com/newsflash-usa | Newsflash from USA
 | http://oldsiteexample.com/newsflash-germany | Newsflash from Germany
 | http://oldsiteexample.com/newsflash-uk | Newsflash from UK
Spreadsheet: 854200d1704169644-closest-date-with-criteria-with-maxifs-formula-closestdate
Sheet: Sheet1

Date | Symbol | Closest RS Date |  |  |  | Date | Symbol | [NAME]
2023-12-08 00:00:00 | MULN |  |  |  |  | 2023-05-04 00:00:00 | MULN | 1 for 10
2023-12-05 00:00:00 | ABC |  |  |  |  | 2023-08-11 00:00:00 | MULN | 1 for 20
2023-12-06 00:00:00 | ABC |  |  |  |  | 2023-12-04 00:00:00 | SYTA | 1 for 10
2023-12-07 00:00:00 | ABC |  |  |  | Desired date in cell C2-> | 2023-12-21 00:00:00 | MULN | 1 for 50
2023-12-31 00:00:00 | MULN |  |  |  | Desired date in cell C6 -> | 2023-12-30 00:00:00 | MULN | 1 for 10
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 6802 | 5488 |  |  | 1020 | 1011 | 1891 | 1414
2 | 6013 | 5488 |  |  | 1005 | 1011 | 577 | 1414
3 | 5948 | 5488 |  |  | 1055 | 1011 | 1908 | 1414
4 | 6198 | 5488 |  |  | 1045 | 856 | 1668 | 1414
5 | 6168 | 5488 |  |  | 607 | 1011 | 1539 | 1414
6 | 6277 | 5488 | 898 |  | 978 | 1011 | 1481 | 1414
7 | 6183 | 5488 | 2419 |  | 1079 | 506 | 1419 | 1414
8 | 6277 | 5488 | 2312 | 1000 | 1035 | 1007 | 1405 | 1414
9 | 6323 | 5488 | 2355 | 1000 | 1015 | 1011 | 1492 | 1414
10 | 3536 | 5488 | 2271 | 1000 | 871 | 1011 | 1559 | 1414
11 | 1415 | 5488 | 2181 | 1000 | 1020 | 1011 | 1457 | 1414
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  | 423166.07
2001-12-11 00:00:00
CBS Volume
 |  |  | 174196