tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 707282d1607154142-index-match-formula-not-working-properly-from-data-in-pivot-tables-help-november-mileage-and-fuel
Sheet: Vehicle Mileage Rpt - Nov

Truck | AL | AR | AZ | CA | CO | CT | FL | GA | IA | ID | IL | IN | KS | KY | LA | MA | MD | ME | MI | MO | MS | MT | NE | NH | NJ | NM | NY | OH | OK | OR | PA | SD | TN | TX | UT | VA | WA | WV | WY | Total (mi)
01 | 0 | 225 | 0 | 0 | 420 | 0 | 0 | 0 | 147 | 536 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 530 | 0 | 655 | 0 | 0 | 0 | 446 | 0 | 0 | 1014 | 202 | 0 | 479 | 0 | 1411 | 547 | 0 | 509 | 0 | 378
73 |  |  |  |  |  |  | 731 | 712 | 320 | 550 | 929 | 151 |  | 186 |  | 170 |  | 51 |  | 431 |  |  | 909 | 21 |  |  | 384 | 245 |  | 747 | 47 |  | 363 |  | 296 |  | 7 |  | 799
1022 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1603 | 0 | 0 | 0 | 0 | 0 | 0 | 2039 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4017 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
247006 | 134 | 0 | 360 | 900 | 586 | 319 | 1117 | 0 | 991 | 1331 | 824 | 643 | 0 | 0 | 731 | 144 | 115 | 0 | 0 | 241 | 155 | 556 | 918 | 0 | 124 | 1374 | 245 | 1087 | 41 | 1900 | 1438 | 484 | 0 | 2625 | 1341 | 0 | 1799 | 58 | 1390
2907 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
667896 | 445 | 146 | 744 | 837 | 71 | 0 | 2887 | 1132 | 195 | 997 | 656 | 161 | 0 | 280 | 624 | 0 | 0 | 0 | 0 | 1935 | 284 | 630 | 1377 | 0 | 0 | 994 | 0 | 331 | 397 | 919 | 0 | 500 | 564 | 1671 | 718 | 0 | 542 | 216 | 1104
88 | 0 | 304 | 0 | 0 | 1027 | 0 | 0 | 0 | 0 | 1121 | 133 | 125 | 824 | 194 | 0 | 0 | 83 | 0 | 0 | 251 | 0 | 0 | 0 | 0 | 0 | 884 | 0 | 0 | 815 | 836 | 151 | 0 | 507 | 1415 | 1150 | 675 | 838 | 208 | 716
Total
Spreadsheet: 812122d1672966954-due-upcoming-overdue-123perwinkle-123
Sheet: R12

Project Phase | Deliverable | Responsible Party | Date Assigned | Date Due | Date Completed | Color | Current Issue? | Issues Resolved? | Due/Overdue | NOTES
Planning & Scope | CAP Contract Process Discovery | [NAME] | 2022-12-12 00:00:00 | 2022-12-12 00:00:00 | 2022-12-12 00:00:00 |  |  |  |  | Develop process visibility, tracking, and task management for IT Contracting and other C&P processes.   [NAME] will ask key questions in the Procurement User Group Meeting.
Planning & Scope | Identify types of contracts | [NAME] | 2022-12-12 00:00:00 | 2022-12-16 00:00:00 | 2023-01-03 00:00:00 |  | Yes |  |  | Courtney will get info from [NAME].  On 12/12/22, [NAME] asked [NAME] for her cheat sheet.  [NAME] said her cheat sheet is for procurement, and has a lot of extra tasks on it that are not pertinent to [NAME]'s job.  [NAME] said she can edit it to remove procurement tasks then send it to [NAME] - unsure when [NAME] will be able to do this, though.  On 12/20/22, [NAME] asked [NAME] to send her cheat sheet as is and to highlight what portions are procurement and what portions are divisional responsibility.    On 01/03/23, [NAME] followed up w/ [NAME] again for the cheat sheet, and [NAME] provided it.
Planning & Scope | Send information and data that we track in CAP | [NAME] | 2022-12-12 00:00:00 | 2022-12-20 00:00:00 | 2022-12-13 00:00:00 |  |  |  |  | Courtney will send existing data, documentation, etc., to [NAME], [NAME], and Cornelius.
Spreadsheet: 215576d1361417326-conditional-formating-budget
Sheet: Dashboard

 |  |  | Budget Dashboard |  |  |  |  | Expenditures & Income | 'Expenditures & Income'!A1 | 'Expenditures & Income'!A1
 |  |  |  |  | 3 |  |  |  |  |  | 2013
 |  |  | MONTH TOTALS | Monthly Totals |  |  |  |  |  | ANNUAL TOTALS |  | Annual Totals
 |  |  | INCOME | Expenditures |  |  |  |  |  | INCOME |  | Expenditures
 |  |  | EXPENDITURES | Income |  |  |  |  |  | EXPENDITURES |  | Income
 |  |  |  |  |  |  | Savings Goal - $2,000
 |  |  | SAVINGS TOTALS | Monthly Totals
 |  |  | USAA
 |  |  | KAYLEE'S PIGGIE BANK
 |  |  | WATER JUG FUND
 |  |  | Savings
 |  |  | Goal | 2000
 |  |  | Percent of Goal
Spreadsheet: 686753d1594802461-conditional-addition-payroll-test
Sheet: Yearly

Monthly  Tax Calculator
Tax Table | 1 | 2 | 3 | 4 | 5 | 6
Compensation Range | 0 to 20,832 | 20,834 to 33,332 | 33,334 to 66,664 | 66,666 to 166,664 | 166,666 to 666,664 | 666,666 to 1,000,000
Withholding Tax | 0.00 + 0% over | 0.00 +20% over | 1,250.00 + 25% over | 5,416.67 + 30% over | 20,416.67 + 32% over | 100,416.67 + 35% over
Monthly Salary | 22500
SSS
Philhealth |  |  |  |  |  |  |  |  |  |  |  | BIR TAX TABLE
Pag Ibig Premium | 100 |  |  |  |  |  |  |  |  |  |  | [NAME] (ANNUAL) | INCOME TAX RATE
Bonus |  |  |  |  |  |  |  |  |  |  |  | 250000 and below | 0
13th Month Pay |  |  |  |  |  |  |  |  |  |  |  | 250000.01 to 400000 | 20% of the excess over 250000
Other Adjustment |  |  |  |  |  |  |  |  |  |  |  | 400000.01 to 800000 | 30000 + 25% of the excess over 400000
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 800000.01 to 2000000 | 130000 + 30% of the excess over 800000
OT Meal allowance |  |  |  |  |  |  |  |  |  |  |  | 2000000.01 to 8000000 | 490000 + 32% of the excess over 2000000
Abcenses/tardiness |  |  |  |  |  |  |  |  |  |  |  | 8000000.01 and above | 2410000 + 35% of the excess over 8000000
Taxable Income
Yearly |  |  |  |  |  |  |  |  |  |  |  | Taxable Income
 |  |  |  |  |  |  |  |  |  |  |  | Income Tax
Yearly Witholding |  |  |  |  |  |  |  |  |  |  |  | Monthly Tax
Monthly
 |  |  |  |  |  |  |  |  |  |  |  | FROM | TO
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 250000 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 250000.01 | 400000 | 0 | 0.2
 |  |  |  |  |  |  |  |  |  |  |  | 400000.01 | 800000 | 30000 | 0.25
 |  |  |  |  |  |  |  |  |  |  |  | 800000.01 | 2000000 | 130000 | 0.3
 |  |  |  |  |  |  |  |  |  |  |  | 2000000.01 | 8000000 | 490000 | 0.32
 |  |  |  |  |  |  |  |  |  |  |  | 8000000.01 | 99999999 | 2410000 | 0.35
Spreadsheet: 836297d1689248355-dynamic-range-for-match-function-bonus-calculations
Sheet: SPARE PARTS

1 | AIR SPRING DAMPER REPAIRED FRONT RIGHT | PR---234 | 95835804000KIT | 1 | 2600 | P | 390 | Item Delivered | Supplied By : | Invoice # 0008468 | Task Completed By :
2 | REAR DOOR LOCK LEFT | PR---645 | 9A783911501 | 1 | 1082 | P | 162.3 | Item Delivered | Supplied By : | Invoice # 0008468 | Task Completed By :
3 | [NAME] | PR---228 | 95834301820 | 3 | 297 | P | 44.55 | Item Delivered | Supplied By : | Invoice # 0008468 | Task Completed By :
4 | DOOR PANEL CLIP | PR---957 | 95555524300 | 5 | 9 | P | 1.35 | Item Delivered | Supplied By : | Invoice # 0008468 | Task Completed By :
5 | AIR SPRING DAMPER REPAIRED REAR LEFT | PR---236 | 95835801905KIT | 1 | 2800 | P | 420 | Item Delivered | Supplied By : | Invoice # 0008468 | Task Completed By :
6 | AIR SPRING DAMPER REPAIRED REAR RIGHT | PR---235 | 95835802015KIT | 1 | 2800 | P | 420 | Item Delivered | Supplied By : | Invoice # 0008468 | Task Completed By :
Spreadsheet: 815818d1675219037-formula-v-pivot-table-or-manual-entry-cblunch
Sheet: Submission

 |  |  | Crouse |  |  |  |  | Grade |  |  | 2nd |  |  | Month: |  |  |  | 2023-02-01 00:00:00
 |  |  |  | F = full meal | E = Entre only | S = Snack | x = Pizza |  |  |  | Pizza - Cheese=C; Pepperoni=P
 |  |  |  |  |  |  |  |  |  |  |  | Snack - Y or N
 |  |  | Day of Month
First Name | Last Name | Composite | 1 | 2 | 3 | 6 | 7 | 8 | 9 | 10 | 13 | 14 | 15 | 16 | 17 | 21 | 22 | 23 | 24 | 27 | 28 | Column3 | Pizza | Snack
C | [NAME]
N | [NAME]
W | Breedlove
D | Filiault
C | Fleming
S | Griffin
N | Hairston
J | Hopkins
A | Hudson
L | [NAME]
A | Lumsden
N | McLaughlin
T | Norton
J | Parsons
H | Porter
J | [NAME]
Q | Tuttle
S | Troutman
P | Wheeler
M | Crouse
Spreadsheet: 169020d1342681351-how-do-i-add-up-cells-from-multiple-sheets-invoice
Sheet: Sheet2

 |  |  | TAX INVOICE
 |  |  | Invoice #004
 |  |  | Date: July 13th 2012
To: |  | For:
 |  | Consultancy work as per agreement CS001
[NAME] | RATE (per week) | QTY | GST | AMOUNT
Consulting services for weeks commencing 2nd and 9th of July | 1875 | 2
Superannuation Provision | 168.75 | 2
Car Provision | 357.08 | 2
 |  | Total Amount
 |  | GST
 |  | Total (Inc. GST)
Spreadsheet: 3c8be800-59dc-4f4c-94d9-8cf7bc861c07
Sheet: Fig3A (inset)

Ave_PropTimeOut | Sex
0.406743297 | M
0.156281064 | F
0.35081426 | F
0.062357123 | M
0.656536618 | M
0.137704178 | M
0.12205108 | F
0.419644508 | M
0.0234975 | F
0.449247377 | M
0.675644731 | M
0.320586391 | F
0.427913884 | F
0.168624974 | M
0.248931649 | F
0.079064351 | M
0.275542832 | M
0.064747007 | F
0.11719979 | F
0.071305228 | F
0.135090614 | F
0.167295279 | F
0.1055767 | M
0.197210628 | M
0.429572854 | F
0.146376453 | F
0.125743134 | F
0.074816471 | F
0.048134 | M
0.003418 | F
0.19802301 | F
0.228376157 | M
0.111422001 | M
0.041260558 | F
0.060712349 | F
0.065596457 | F
0.089555234 | F
0.099572137 | F
0.041427335 | M
0.224078526 | M
0.075574536 | F
0.09672397 | F
0.176831833 | F
0.140210111 | M
0.141564389 | F
0.101431722 | F
0.09453575 | F
0.050657911 | F
Spreadsheet: 874631d1721194469-query-that-shows-only-the-following-day-and-after-chrisgarcia78-pq-aligw
Sheet: Sheet1

 |  | Column1
2024-07-13 00:00:00 |  | 2024-07-18 00:00:00
2024-07-14 00:00:00 |  | 2024-07-19 00:00:00
2024-07-15 00:00:00 |  | 2024-07-20 00:00:00
2024-07-16 00:00:00 |  | 2024-07-21 00:00:00
2024-07-17 00:00:00 |  | 2024-07-22 00:00:00
2024-07-18 00:00:00 |  | 2024-07-23 00:00:00
2024-07-19 00:00:00 |  | 2024-07-24 00:00:00
2024-07-20 00:00:00 |  | 2024-07-25 00:00:00
2024-07-21 00:00:00 |  | 2024-07-26 00:00:00
2024-07-22 00:00:00 |  | 2024-07-27 00:00:00
2024-07-23 00:00:00 |  | 2024-07-28 00:00:00
2024-07-24 00:00:00 |  | 2024-07-29 00:00:00
2024-07-25 00:00:00 |  | 2024-07-30 00:00:00
2024-07-26 00:00:00 |  | 2024-07-31 00:00:00
2024-07-27 00:00:00
2024-07-28 00:00:00
2024-07-29 00:00:00
2024-07-30 00:00:00
2024-07-31 00:00:00
Spreadsheet: 102404d1300349455-select-worksheet-shorcuts-keyboard
Sheet: MyKeys

 | Ctrl | Ctrl-Shift
[NAME]
F1
F2 |  |  |  | You can override the defaults by creating your
F3 | Define Name | Create Names |  | own macro in place of the function keys, but
F4 | Close Window |  |  | to provide feedback to the user, the default-defined
F5 | Restore Win Sz. |  |  | keys have been shaded in grey.
F6 | Next Workbook | Prior Workbook
F7 | Move window |  |  | For user-macros you create, the first 7 characters
F8 | Resize Window |  |  | of your entry here will be echoed on the [NAME] tab.
F9 | Maximize wrkbk
[NAME] | Maximize window
F11 | Excel4 Macro
F12 | Open | Print
Symbols
~ | Toggle: Show Result/Formula in cell | Apply General [NAME]
" | Copy cell above into current cell.
= |  | [NAME] dialog box
/ ? | Select Array
\ |  | [NAME] select
[ | [NAME] reference select | [NAME] reference select
] | [NAME] reference select | [NAME] reference select
<  ,
>  .
+
- | Deleted selected cells | Delete Framed border around selected cell(s)
Numeric
1 | Display [NAME] dialog box | Format selected cell(s) as numeric, two-decimal
2 |  | Apply Time format in hh:[NAME] am/pm format
3 |  | Apply Date format in dd/mm/yyyy format
4 |  | Apply Currency format ($)
5
6
7 |  | Add "framed" border around selected cell(s)
8 |  | Select "region"
9 | Hide whole row | Show whole row
0 | Hide whole column | Show whole column
Alpha
A | Select entire workbook
B | Bold
C | Cut
D | [NAME]
E
F
G
H
I | Italics
J
K | [NAME]
L
M
N | Create new workbook
O |  | Select all cells with Comments
P | Print
Q
R | Fill Right
S
T
U | Underline
V
W | Close Window
X
Y
Z | Undo last action
Spreadsheet: 1073e19a-d255-450e-9d83-1430f84cf8b2
Sheet: Sheet1

Applicant Name:
SBVC Student ID:
Calculation of Science GPA for Nursing:
Directions:  Enter the information in  columns  B-F.  Enter the appropriate number in colums G and H, rows 11-13. Click "Enter"
on  H15 to get total. | Then select  "enter" for each space of I  11-15.  Finally, select "enter" in box I -16 to get your science GPA.
SCIENCE PREREQUISITES | Course name/ Number | Lab | Year Completed | Name of College | Letter Grade Received | Grade Value | Number of Units | GRADE POINTS
 |  | Course Yes/No? |  |  |  | Values: A is 4, B is 3, |  | The product of units times Grade Value
 |  |  |  |  |  | C is 2
SAMPLE – | BIOL 260 | yes | 2010 | SBVC | B | 3 | 4
Anatomy or Anatomy & Physiology I with lab
Physiology or Anatomy & Physiology II with lab
Microbiology with lab
Psychology
 |  |  |  |  | Totals
 |  |  |  | Divide Grade points by Number of units |  |  | GPA science
Spreadsheet: drew_fossum__8676__SSCOTT8-22-00
Sheet: Meals and Ent Sup

Employee Expense Report
Meals and Entertainment Supplement |  |  |  |  |  |  |  |  |  |  | Page
LAST NAME |  |  |  | FIRST NAME, INITIAL |  |  | TITLE |  |  |  | EMPLOYEE NUMBER
MEALS AND ENTERTAINMENT - Enter the cost of all meals (including food charges from hotel receipts) and entertainment.  Attach guest list for entertainment expense.  Meal: B = Breakfast,
L = Lunch, D = Dinner, R = Refreshments, T = Travel Status.  Assign a reference symbol for each accounting classification to be used.  Charges to be allocated do not require a reference symbol.
REF | Date | Meal |  | Location and Business Purpose |  |  |  | Guests |  |  | Cost/Qty | Rate | $ [NAME]
1 | 2000-06-01 00:00:00 | D | San Francisco, CA, CPUC Hearing |  |  |  |  | [NAME], [NAME], Gov. Affairs, Enron |  |  | 190.75
 |  |  |  |  |  |  |  | [NAME], Account Executive,
 |  |  |  |  |  |  |  | Transwestern; self
1 | 2000-06-26 00:00:00 | D | Washington, DC, FERC Technical Conference |  |  |  |  | [NAME], Vice President Rates, NNG |  |  | 155.97
 |  |  |  |  |  |  |  | [NAME], [NAME], [NAME]
 |  |  |  |  |  |  |  | [NAME], Vice President [NAME]
 |  |  |  |  |  |  |  | [NAME], [NAME]., [NAME], Boland
 |  |  |  |  |  |  |  | [NAME], Dir, Rates, NNG
 |  |  |  |  |  |  |  | self
1 | 2000-05-31 00:00:00 | D | San Francisco, CA, CPUC Conference |  |  |  |  | [NAME], Account Executive, |  |  | 67.42
 |  |  |  |  |  |  |  | Transwestern; self
1 | 2000-05-29 00:00:00 | D | San Francisco, CA, CPUC Conference |  |  |  |  | [NAME], Account Executive, |  |  | 50.94
 |  |  |  |  |  |  |  | Transwestern; self
1 | 2000-05-24 00:00:00 | D | San Francisco, CA, CPUC Conference |  |  |  |  | [NAME], Account Executive, |  |  | 59
 |  |  |  |  |  |  |  | Transwestern; self
1 | 2000-05-23 00:00:00 | D | San Francisco, CA, CPUC Conference |  |  |  |  | [NAME], [NAME], Gov. Affairs, Enron |  |  | 95.6
 |  |  |  |  |  |  |  | [NAME], Account Executive,
 |  |  |  |  |  |  |  | Transwestern; self
1 | 2000-07-19 00:00:00 | D | Denver, CO, discuss Big Sandy Project with |  |  |  |  | [NAME], Facility Planner, TW |  |  | 40.39
 |  |  | Caiphness |  |  |  |  | [NAME], Account Executive,
 |  |  |  |  |  |  |  | self
 |  |  |  |  | Expense allocation |  |  |  | Allocated amount: |  | TOTAL
 |  |  |  |  | Enter an allocation factor next to each account receiving allocated |  |  |  |  | Total travel expense must be shown on Page 1,
 |  |  |  |  | charges.  Lines not assigned an allocation factor will not |  |  |  |  | Employee Expense Report Short Form.
 |  |  |  |  | receive an allocation; lines without a REF code will be allocated.
 |  |  |  |  | The total of all allocation factors must equal 1.
ACCOUNT [NAME]
Show the total amount for each accounting classification referenced above.
REF | GL Acct      Asset | GL Co Tr Ptr |  | Cost Center                           WBS Element |  |  | Order                                      Network |  | Material       Activity | Plant                      Func Area | ALLOC FACTOR |  | Amount
1 | 52003000 | 0366 | 0014
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 856259d1705575462-how-to-join-2-excel-sheets-with-a-common-column-pq-sample-data-31-aligw
Sheet: Sheet1

 | Source File1 |  |  |  | Source File 2 |  |  |  | Destination File (Desired)
 | User | Role |  |  | Role | Privilege |  |  | User | Role | Privilege |  | SourceFile1.User | Role | Privilege
 | A | AA |  |  | AA | 123 |  |  | A | AA | 123 |  | A | AA | 345
 | A | BB |  |  | AA | 345 |  |  | A | AA | 345 |  | A | BB | 456
 | B | AA |  |  | BB | 456 |  |  | A | BB | 456 |  | A | AA | 123
 | C | BB |  |  | BB | 678 |  |  | A | BB | 678 |  | A | BB | 678
 | D | ZZ |  |  | CC | 910 |  |  | B | AA | 123 |  | B | AA | 123
 |  |  |  |  |  |  |  |  | B | AA | 345 |  | B | AA | 345
 |  |  |  |  |  |  |  |  | C | BB | 456 |  | C | BB | 678
 |  |  |  |  |  |  |  |  | C | BB | 678 |  | C | BB | 456
Spreadsheet: 798036d1664283070-alternating-formulas-every-two-cells-needs-to-reference-same-column-book3
Sheet: D

B
 | January | February | March | April | May | June | July | August | September | October | November | December
Client 1 | 98 |  |  |  |  | 511 |  |  | 7012 |  | 912 | 50
Client 2 | 7 |  |  |  |  | 112 |  |  | 321 |  | 250 | 13
Client 3 | 60 |  |  |  |  | 3618 |  |  | 61 |  | 52 | 30
total
ytd
gl
difference
balance
Spreadsheet: 805731d1668868647-need-help-setting-up-a-formula-based-on-conditions-excel-help-formula-2-boneylit-
Sheet: Sheet2

Net Income | Owners Charges | Rate Increase |  | Owner Charges
 |  | 0.625 |  | Income | 500000
 |  |  |  | Extra Income | 200000
 |  |  |  | Expense | -2000000
Current Owner Charges | Increase to Owner Charges | Projected Owner Charges
100000
300000
250000
150000
Spreadsheet: 025a3251-ae6a-48a4-9bd6-fdd9a7f709b2
Sheet: g. Construction

Detailed Budget Justification
g. Construction
PLEASE READ!!!  Construction, for the purpose of budgeting, is defined as all types of work done on a particular building, including erecting, altering, or remodeling.  Construction conducted by the award recipient is entered on this page.  Any construction work that is performed by a vendor or subrecipient to the award recipient should be entered under f. Contractual.  List all proposed construction below, providing a basis of cost such as engineering estimates, prior construction, etc., and briefly justify its need as it applies to the Statement of Project Objectives.  Add rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer.
Overall description of construction actiivities:
Example Only!!! - Build wind turbine platform
General Description | Cost | Basis of Cost | Justification of need
Budget Period 1
Three days of excavation for platform site EXAMPLE ONLY!!! | 28000 | Engineering estimate | Site must be prepared for construction of platform.
Budget Period 1 Total
Budget Period 2
Budget Period 2 Total
Budget Period 3
Budget Period 3 Total
PROJECT TOTAL
Additional Explanations/Comments (as necessary)
Spreadsheet: 767308d1644403894-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Sheet9

Row Labels | Count of Status
Didn't join after selection | 1
Duplicate | 6
In Progress | 1
No Show | 11
Not Interested | 15
Not Suitable | 21
Not Yet Scheduled | 2
Offer Accepted | 1
[NAME] | 3
Rejected (1st) | 39
Rejected (2nd) | 5
Scheduled | 1
Grand Total | 106
Spreadsheet: 770107d1645811947-countif-dates-in-month-year-date
Sheet: Sheet1

Column1 |  |  | Column1 | Column1 - Copy | Count
2021-09-01 00:00:00 |  |  | 2021 | 9 | 6
2021-09-02 00:00:00 |  |  | 2021 | 10 | 10
2021-10-02 00:00:00
2021-10-06 00:00:00
2021-09-01 00:00:00
2021-09-02 00:00:00
2021-10-02 00:00:00
2021-10-06 00:00:00
2021-09-01 00:00:00
2021-09-02 00:00:00
2021-10-02 00:00:00
2021-10-06 00:00:00
2021-10-07 00:00:00
2021-10-08 00:00:00
2021-10-09 00:00:00
2021-10-10 00:00:00
Spreadsheet: 835488d1688629848-sumproduct-with-dynamic-arrays-query-1-aligw
Sheet: Sheet2

 | Table 1 |  |  |  |  |  |  | Table 2
 | Students |  | Maths | Commerce | Economics | Physics |  | Students | Multipler
 |  |  | 12 | 14 | 16 | 18
 | [NAME] | 15 | 17 | 19 | 21 | 23 |  | [NAME] | 19
 | [NAME] | 20 | 22 | 24 | 26 | 28 |  | [NAME] | 15
 | Joel | 25 | 27 | 29 | 31 | 33 |  | Joel | 11
 | Prasanth | 30 | 32 | 34 | 36 | 38 |  | Prasanth | 10
 | Joel | 35 | 37 | 39 | 41 | 43 |  | Joel | 6
 | [NAME] | 40 | 42 | 44 | 46 | 48 |  | [NAME] | 9
 | [NAME] | 45 | 47 | 49 | 51 | 53 |  | [NAME] | 23
 | [NAME] | 20 | 26 | 32 | 38 | 44 |  | [NAME] | 11
 | [NAME] | 50 | 52 | 54 | 56 | 58 |  | [NAME] | 12
 | Table 3
 | Students |  | Maths | Commerce | Economics | Physics
 |  |  | 687 | 749 | 811 | 873
 | [NAME] | 865 | 987 | 1109 | 1231 | 1353
 | [NAME] | 300 | 330 | 360 | 390 | 420
 | Prasanth | 300 | 320 | 340 | 360 | 380
 | [NAME] | 1035 | 1081 | 1127 | 1173 | 1219
 | [NAME] | 600 | 624 | 648 | 672 | 696
 |  | English | Maths | Commerce | Economics | Physics
 | Joel | 625 | 687 | 749 | 811 | 873
 | [NAME] | 865 | 987 | 1109 | 1231 | 1353
 | [NAME] | 300 | 330 | 360 | 390 | 420
 | Prasanth | 300 | 320 | 340 | 360 | 380
 | [NAME] | 1035 | 1081 | 1127 | 1173 | 1219
 | [NAME] | 600 | 624 | 648 | 672 | 696
Spreadsheet: sally_beck__33725__CC_BUDGET_FORMAT
Sheet: Exec Summ

2001 - 2003 Operating & Strategic Plan
Executive Review Summary
(Thousands of Dollars)
 |  |  |  |  |  |  | Operating
 |  |  |  |  |  |  | & Strategic
 |  |  | 2000 |  | 2000 |  | Plan*
 | Cost Categories |  | Plan |  | Estimate |  | 2001 |  | 2002 |  | 2003
Salaries & Wages
Employee Expense
General Business Expense
Supplies & Expense
Outside Services
Rents
Other Computer Costs
Advertising & Promotion
Other Business Expense
 | Subtotal
Payroll Taxes
Benefits
EIS Charges
Rent and other EPCS
 | Total Gross Expense
Less: distributions to business units
 | Net Expense
Headcount (year-end)
* Please provide variance explanations for any significant changes from the 1999 estimate.
Spreadsheet: 65655d1266347931-selective-data-to-get-a-printed-report-budget-to-actual-expenditure-2010-slots
Sheet: 7

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Estimated Duty / Tax / Transport = |  | 0.45
 | Details |  |  |  |  | Quotation |  |  |  |  |  | Invoice |  |  |  |  |  |  |  | Local Duty, TAX & Local Transport
I / Q | # | Sequence # | Company | Discription |  | Quotation # | Quotation (Euro) | X rate | RSD | Date (processed) |  | Invoice # | Act invoice (Euro) | X rate | RSD | SHIP invoice | Difference % | Process (date) |  | Duty & Transport | Act invoice | Difference % | Paid (date) |  | Total cost (actual) | Special NOTES
 | 1 | 1 | aeqitas | Hotel IGE SHOW |  |  |  |  | 0 |  |  | 002/10 |  |  | 70516 |  | 0 |  |  | 0 |  | 0 |  |  | 70516
 | 2 |  |  | Flight to London |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 3 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 4 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 5 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 6 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 7 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 8 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 9 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 10 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 11 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 12 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 13 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 14 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 15 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 16 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 17 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 18 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 19 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 20 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 |  |  |  | Total = |  |  |  |  | 0 |  |  |  |  |  | 70516 |  |  |  |  | 0 |  |  | Total spent = |  | 70516
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budget total = |  | 300000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remaining = |  | 229484
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % = |  | 0.7649466666666667